1 páginas (7 elementos)
calculation in table - Mensajes
Is possible to make calculation in table, like excel?
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
https://en.smath.info/forum/yaf_postst4375_Plugin---EXCEL--2003--I-O-with-recalculation-and-export-to-PNG.aspx
WroteIs 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.
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) descargado 1507 vez(es).
Regards
Peter
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) descargado 1507 vez(es).
Regards
Peter
Peter J Francis
Twitter: @PeterJFrancis
Thermal Engineer , Maker , Pilot
Thanks Peter: gorgeous ! mm² ... mm[Alt+253]
Hi Paulis ... here is some bed time reading
Rotate Eol.sm (28,47 KiB) descargado 1388 vez(es).
Utilities Matrix Truth Table.sm (59,2 KiB) descargado 1307 vez(es).
0Anim Brownian.sm (9,94 KiB) descargado 1275 vez(es).
2D Fill Stem.sm (12,71 KiB) descargado 1286 vez(es).
0Anim Ellipse.sm (13,85 KiB) descargado 1287 vez(es).
0Anim Analemma.sm (29,24 KiB) descargado 1314 vez(es).
Inst_Colebrook Pipe Data.sm (60,09 KiB) descargado 1328 vez(es).
2D Isometric Copy.sm (77,29 KiB) descargado 1229 vez(es).
Utilities Matrix Treasury Copy.sm (355,68 KiB) descargado 1270 vez(es).
Rotate Image RGB.sm (348,52 KiB) descargado 1317 vez(es).
Rotate Breather [4 Orientations].sm (1000,05 KiB) descargado 1110 vez(es).
Image ZOOM Cosmos RGB.sm (1,79 MiB) descargado 1300 vez(es).
Hi Paulis ... here is some bed time reading
Rotate Eol.sm (28,47 KiB) descargado 1388 vez(es).
Utilities Matrix Truth Table.sm (59,2 KiB) descargado 1307 vez(es).
0Anim Brownian.sm (9,94 KiB) descargado 1275 vez(es).
2D Fill Stem.sm (12,71 KiB) descargado 1286 vez(es).
0Anim Ellipse.sm (13,85 KiB) descargado 1287 vez(es).
0Anim Analemma.sm (29,24 KiB) descargado 1314 vez(es).
Inst_Colebrook Pipe Data.sm (60,09 KiB) descargado 1328 vez(es).
2D Isometric Copy.sm (77,29 KiB) descargado 1229 vez(es).
Utilities Matrix Treasury Copy.sm (355,68 KiB) descargado 1270 vez(es).
Rotate Image RGB.sm (348,52 KiB) descargado 1317 vez(es).
Rotate Breather [4 Orientations].sm (1000,05 KiB) descargado 1110 vez(es).
Image ZOOM Cosmos RGB.sm (1,79 MiB) descargado 1300 vez(es).
A 2 usuarios les gustó este mensaje
WroteWroteIs 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.
1 páginas (7 elementos)
- Nuevos mensajes
- Sin mensajes nuevos