Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Login


Options
Go to last post Go to first unread
Offline Paulius  
#1 Posted : 14 November 2017 18:39:44(UTC)
Paulius

Rank: Newbie

Groups: Registered
Joined: 27/10/2017(UTC)
Posts: 8
Lithuania

Is possible to make calculation in table, like excel?

Wanna join the discussion?! Login to your SMath Studio Forum forum account. New Registrations are disabled.

Offline Alex M.  
#2 Posted : 14 November 2017 22:34:30(UTC)
Alex M.


Rank: Advanced Member

Groups: Registered
Joined: 03/03/2014(UTC)
Posts: 418
Canada

Was thanked: 125 time(s) in 96 post(s)
Not that I am aware off, but you can "connect" to EXCEL if you have it on your windows machine:
https://en.smath.info/fo...n-and-export-to-PNG.aspx
Offline Jean Giraud  
#3 Posted : 15 November 2017 02:09:50(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,866
Canada

Was thanked: 981 time(s) in 809 post(s)
Originally Posted by: Paulius Go to Quoted Post
Is possible to make calculation in table, like excel?


Your question is too vague, a bit of work sheet would help.
In short: there is no known limit about what Smath can do
within a matrix [its own matrix] wrt the project you are Engineering.
Then, you may send to Excel via Alex plugin.
Alex, please correct me if wrong !

Cheers.
Offline Peter J Francis  
#4 Posted : 15 November 2017 10:54:27(UTC)
Peter J Francis


Rank: Member

Groups: Registered
Joined: 02/06/2017(UTC)
Posts: 18
United Kingdom
Location: Stoke on Trent

Hi Paulius,
I had a similar problem.
I wanted to create a table of values for a project at work that could be easily read by non SMath people (i.e. I wanted a nice looking table but also array names with text to identify the value rather than numbers)

Some of the values were fixed (sizes , powers or text ) but I needed to perform calculations on some of the values and incorporate it in a table.
I came up with the following method using TableRegions , although it looks a little complicated it works great and generates a great looking table and I can use arrays with meaning full text identifiers.

The attached file is annotated so should be fairly self explainatory and there are some examples of how to use the values at the bottom.
If you have a problems with it let me know.

TableRegion example by PJF.sm (31kb) downloaded 151 time(s).

Regards

Peter

Peter J Francis

Twitter: @PeterJFrancis

Thermal Engineer , Maker , Pilot
Offline Paulius  
#5 Posted : 15 November 2017 15:26:33(UTC)
Paulius

Rank: Newbie

Groups: Registered
Joined: 27/10/2017(UTC)
Posts: 8
Lithuania

Tnank You Peter
Offline Jean Giraud  
#6 Posted : 15 November 2017 17:49:34(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,866
Canada

Was thanked: 981 time(s) in 809 post(s)
Thanks Peter: gorgeous ! mm² ... mm[Alt+253]

Hi Paulis ... here is some bed time reading

Rotate Eol.sm (29kb) downloaded 29 time(s).
Utilities Matrix Truth Table.sm (60kb) downloaded 38 time(s).
0Anim Brownian.sm (10kb) downloaded 15 time(s).
2D Fill Stem.sm (13kb) downloaded 18 time(s).
0Anim Ellipse.sm (14kb) downloaded 17 time(s).
0Anim Analemma.sm (30kb) downloaded 13 time(s).
Inst_Colebrook Pipe Data.sm (61kb) downloaded 20 time(s).
2D Isometric Copy.sm (78kb) downloaded 17 time(s).
Utilities Matrix Treasury Copy.sm (356kb) downloaded 29 time(s).
Rotate Image RGB.sm (349kb) downloaded 15 time(s).
Rotate Breather [4 Orientations].sm (1,001kb) downloaded 16 time(s).
Image ZOOM Cosmos RGB.sm (1,839kb) downloaded 20 time(s).
thanks 2 users thanked Jean Giraud for this useful post.
on 15/11/2017(UTC),  on 15/11/2017(UTC)
Offline Alex M.  
#7 Posted : 16 November 2017 08:06:31(UTC)
Alex M.


Rank: Advanced Member

Groups: Registered
Joined: 03/03/2014(UTC)
Posts: 418
Canada

Was thanked: 125 time(s) in 96 post(s)
Originally Posted by: Jean Giraud Go to Quoted Post
Originally Posted by: Paulius Go to Quoted Post
Is possible to make calculation in table, like excel?


Your question is too vague, a bit of work sheet would help.
In short: there is no known limit about what Smath can do
within a matrix [its own matrix] wrt the project you are Engineering.
Then, you may send to Excel via Alex plugin.
Alex, please correct me if wrong !

Cheers.



Agree with Jean - you can do all sorts of operations in SMath with matricies and then present them as a table region OR you could use excel to do an present all the table stuff for you.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.