1 страниц (7 вхождений)
calculation in table - Сообщения
#1 Опубликовано: 14.11.2017 12:39:44
Is possible to make calculation in table, like excel?
#2 Опубликовано: 14.11.2017 16:34:30
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
#3 Опубликовано: 14.11.2017 20:09:50
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.
#4 Опубликовано: 15.11.2017 04:54:27
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 КиБ) скачан 242 раз(а).
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 КиБ) скачан 242 раз(а).
Regards
Peter
Peter J Francis
Twitter: @PeterJFrancis
Thermal Engineer , Maker , Pilot
#5 Опубликовано: 15.11.2017 09:26:33
Tnank You Peter
#6 Опубликовано: 15.11.2017 11:49:34
Thanks Peter: gorgeous ! mm² ... mm[Alt+253]
Hi Paulis ... here is some bed time reading
Rotate Eol.sm (28 КиБ) скачан 115 раз(а).
Utilities Matrix Truth Table.sm (59 КиБ) скачан 132 раз(а).
0Anim Brownian.sm (9 КиБ) скачан 96 раз(а).
2D Fill Stem.sm (12 КиБ) скачан 114 раз(а).
0Anim Ellipse.sm (13 КиБ) скачан 108 раз(а).
0Anim Analemma.sm (29 КиБ) скачан 99 раз(а).
Inst_Colebrook Pipe Data.sm (60 КиБ) скачан 112 раз(а).
2D Isometric Copy.sm (77 КиБ) скачан 109 раз(а).
Utilities Matrix Treasury Copy.sm (355 КиБ) скачан 129 раз(а).
Rotate Image RGB.sm (348 КиБ) скачан 112 раз(а).
Rotate Breather [4 Orientations].sm (1000 КиБ) скачан 107 раз(а).
Image ZOOM Cosmos RGB.sm (1 МиБ) скачан 109 раз(а).
Hi Paulis ... here is some bed time reading
Rotate Eol.sm (28 КиБ) скачан 115 раз(а).
Utilities Matrix Truth Table.sm (59 КиБ) скачан 132 раз(а).
0Anim Brownian.sm (9 КиБ) скачан 96 раз(а).
2D Fill Stem.sm (12 КиБ) скачан 114 раз(а).
0Anim Ellipse.sm (13 КиБ) скачан 108 раз(а).
0Anim Analemma.sm (29 КиБ) скачан 99 раз(а).
Inst_Colebrook Pipe Data.sm (60 КиБ) скачан 112 раз(а).
2D Isometric Copy.sm (77 КиБ) скачан 109 раз(а).
Utilities Matrix Treasury Copy.sm (355 КиБ) скачан 129 раз(а).
Rotate Image RGB.sm (348 КиБ) скачан 112 раз(а).
Rotate Breather [4 Orientations].sm (1000 КиБ) скачан 107 раз(а).
Image ZOOM Cosmos RGB.sm (1 МиБ) скачан 109 раз(а).
2 пользователям понравился этот пост
#7 Опубликовано: 16.11.2017 02:06:31
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 страниц (7 вхождений)
-
Новые сообщения
-
Нет новых сообщений