calculation in table

calculation in table - Messages

#1 Posted: 2017/11/14 12:39:44
Paulius

Paulius

0 likes in 11 posts.

Group: User

Is possible to make calculation in table, like excel?
#2 Posted: 2017/11/14 16:34:30
Alexander O. Melnik

Alexander O. Melnik

127 likes in 498 posts.

Group: Moderator

Not that I am aware off, but you can "connect" to EXCEL if you have it on your windows machine:
https://en.smath.info/forum/yaf_postst4375_Plugin---EXCEL--2003--I-O-with-recalculation-and-export-to-PNG.aspx
#3 Posted: 2017/11/14 20:09:50
Jean Giraud

Jean Giraud

983 likes in 6,866 posts.

Group: User

Wrote

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.
#4 Posted: 2017/11/15 04:54:27
Peter J Francis

Peter J Francis

0 likes in 18 posts.

Group: User

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 (30.69 KiB) downloaded 846 time(s).

Regards

Peter
Peter J Francis Twitter: @PeterJFrancis Thermal Engineer , Maker , Pilot
#5 Posted: 2017/11/15 09:26:33
Paulius

Paulius

0 likes in 11 posts.

Group: User

Tnank You Peter
#6 Posted: 2017/11/15 11:49:34
Jean Giraud

Jean Giraud

983 likes in 6,866 posts.

Group: User

Thanks Peter: gorgeous ! mm² ... mm[Alt+253]

Hi Paulis ... here is some bed time reading

Rotate Eol.sm (28.47 KiB) downloaded 751 time(s).
Utilities Matrix Truth Table.sm (59.2 KiB) downloaded 713 time(s).
0Anim Brownian.sm (9.94 KiB) downloaded 666 time(s).
2D Fill Stem.sm (12.71 KiB) downloaded 682 time(s).
0Anim Ellipse.sm (13.85 KiB) downloaded 685 time(s).
0Anim Analemma.sm (29.24 KiB) downloaded 694 time(s).
Inst_Colebrook Pipe Data.sm (60.09 KiB) downloaded 732 time(s).
2D Isometric Copy.sm (77.29 KiB) downloaded 650 time(s).
Utilities Matrix Treasury Copy.sm (355.68 KiB) downloaded 676 time(s).
Rotate Image RGB.sm (348.52 KiB) downloaded 707 time(s).
Rotate Breather [4 Orientations].sm (1000.05 KiB) downloaded 560 time(s).
Image ZOOM Cosmos RGB.sm (1.79 MiB) downloaded 675 time(s).
2 users liked this post
Peter J Francis 2017/11/15 13:02:00, frapuano 2017/11/15 16:58:00
#7 Posted: 2017/11/16 02:06:31
Alexander O. Melnik

Alexander O. Melnik

127 likes in 498 posts.

Group: Moderator

Wrote

Wrote

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.
  • New Posts
  • No New Posts