calculation in table

calculation in table - Messaggi

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

Paulius

0 apprezzamenti in 11 post.

Gruppo: User

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

Alexander O. Melnik

127 apprezzamenti in 498 post.

Gruppo: 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 Pubblicato: 14/11/2017 20:09:50
Jean Giraud

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: 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 Pubblicato: 15/11/2017 04:54:27
Peter J Francis

Peter J Francis

0 apprezzamenti in 18 post.

Gruppo: 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) scaricato 1513 volta(e).

Regards

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

Paulius

0 apprezzamenti in 11 post.

Gruppo: User

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

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: User

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

Hi Paulis ... here is some bed time reading

Rotate Eol.sm (28,47 KiB) scaricato 1390 volta(e).
Utilities Matrix Truth Table.sm (59,2 KiB) scaricato 1311 volta(e).
0Anim Brownian.sm (9,94 KiB) scaricato 1281 volta(e).
2D Fill Stem.sm (12,71 KiB) scaricato 1290 volta(e).
0Anim Ellipse.sm (13,85 KiB) scaricato 1291 volta(e).
0Anim Analemma.sm (29,24 KiB) scaricato 1318 volta(e).
Inst_Colebrook Pipe Data.sm (60,09 KiB) scaricato 1334 volta(e).
2D Isometric Copy.sm (77,29 KiB) scaricato 1235 volta(e).
Utilities Matrix Treasury Copy.sm (355,68 KiB) scaricato 1274 volta(e).
Rotate Image RGB.sm (348,52 KiB) scaricato 1324 volta(e).
Rotate Breather [4 Orientations].sm (1000,05 KiB) scaricato 1116 volta(e).
Image ZOOM Cosmos RGB.sm (1,79 MiB) scaricato 1303 volta(e).
2 utenti hanno apprezzato questo post
Peter J Francis 15/11/2017 13:02:00, frapuano 15/11/2017 16:58:00
#7 Pubblicato: 16/11/2017 02:06:31
Alexander O. Melnik

Alexander O. Melnik

127 apprezzamenti in 498 post.

Gruppo: 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.
  • Nuovi post
  • Nessun nuovo post