Excel or spreadsheet region plug in

Excel or spreadsheet region plug in - Excel or spreadsheet region plug in - Mensajes

#1 Publicado: 28/6/2019 18:44:27
aviateCar

aviateCar

0 me gusta en 16 mensajes.

Grupo: User

Hi Gurus:

Does Smath has Excel or Spreadsheet region plug in function?

I am trying to make a table to calculate area moment to inertia but dont know how to make it work.


2019-06-28 15_41_30-SEC.png


Thanks,

Chris
#2 Publicado: 28/6/2019 21:31:53
Jean Giraud

Jean Giraud

983 me gusta en 6.866 mensajes.

Grupo: User

Wrote

Does Smath has Excel or Spreadsheet region plug in function?


You just need to know the maths of each col,
and construct the Smath matrix in descending rows
... No need for Excel
Visit Colebrook Pipe Data.

Inst_Colebrook MOODY.sm (19,13 KiB) descargado 1154 vez(es).
Inst_Colebrook Pipe Data.sm (61,58 KiB) descargado 1164 vez(es).
#3 Publicado: 29/6/2019 4:30:09
fedeghi

fedeghi

25 me gusta en 112 mensajes.

Grupo: User

Wrote

Hi Gurus:

Does Smath has Excel or Spreadsheet region plug in function?

I am trying to make a table to calculate area moment to inertia but dont know how to make it work.

Thanks,

Chris



You can also try Davide Carpi "Table region" plugin.
It is another option to list the results of your calculation in a good looking way.
Very convenient for publishing purpose

Of course, as Jean suggested, every calculation should be prepared using matrix approach.
#4 Publicado: 29/6/2019 16:09:55
CBG

CBG

78 me gusta en 312 mensajes.

Grupo: User

Something like this?

Table_Moment.png

Tabla_Momentos.sm (57,1 KiB) descargado 1187 vez(es).


Best Regards

Carlos
A 1 usuarios les gustó este mensaje
Andrey Ivashov 30/6/2019 19:28:00
#5 Publicado: 2/7/2019 12:30:34
aviateCar

aviateCar

0 me gusta en 16 mensajes.

Grupo: User

Wrote

Wrote

Does Smath has Excel or Spreadsheet region plug in function?


You just need to know the maths of each col,
and construct the Smath matrix in descending rows
... No need for Excel
Visit Colebrook Pipe Data.

Inst_Colebrook MOODY.sm (19,13 KiB) descargado 1154 vez(es).
Inst_Colebrook Pipe Data.sm (61,58 KiB) descargado 1164 vez(es).




Thank you! Will try that later.
#6 Publicado: 2/7/2019 12:32:06
aviateCar

aviateCar

0 me gusta en 16 mensajes.

Grupo: User

Wrote

Wrote

Hi Gurus:

Does Smath has Excel or Spreadsheet region plug in function?

I am trying to make a table to calculate area moment to inertia but dont know how to make it work.

Thanks,

Chris



You can also try Davide Carpi "Table region" plugin.
It is another option to list the results of your calculation in a good looking way.
Very convenient for publishing purpose

Of course, as Jean suggested, every calculation should be prepared using matrix approach.



Thank you! I agree table is so easy to read in reports.
#7 Publicado: 2/7/2019 12:33:07
aviateCar

aviateCar

0 me gusta en 16 mensajes.

Grupo: User

Wrote

Something like this?

Table_Moment.png

Tabla_Momentos.sm (57,1 KiB) descargado 1187 vez(es).


Best Regards

Carlos



Exactly what I was looking for! Thank you so much! This function is going to be really useful for me.
#8 Publicado: 2/7/2019 17:01:41
aviateCar

aviateCar

0 me gusta en 16 mensajes.

Grupo: User

Wrote

Wrote

Something like this?

Table_Moment.png

Tabla_Momentos.sm (57,1 KiB) descargado 1187 vez(es).


Best Regards

Carlos



Exactly what I was looking for! Thank you so much! This function is going to be really useful for me.



Hi Carlos:

This happened while I was working on it.

Plug in Failed.png

This red cross took all of the work after the plug-in away.

Have you experienced this?

How can I fix it?

Thank you!

Chris
#9 Publicado: 2/7/2019 18:33:13
CBG

CBG

78 me gusta en 312 mensajes.

Grupo: User



Hi Carlos:

This happened while I was working on it.

Plug in Failed.png

This red cross took all of the work after the plug-in away.

Have you experienced this?

How can I fix it?

Thank you!

Chris



Hi Chris

Yes, I've had that kind of problem, and it happens when the Plugin is not recognized or is not installed.
You have to install the plugin or update it.
Verify that your version of Smath Studio is compatible with the version of the Table Region Plugin.

Table_Region_Compact.png


Best Regards

Carlos
#10 Publicado: 2/7/2019 18:48:27
aviateCar

aviateCar

0 me gusta en 16 mensajes.

Grupo: User

Wrote



Hi Chris

Yes, I've had that kind of problem, and it happens when the Plugin is not recognized or is not installed.
You have to install the plugin or update it.
Verify that your version of Smath Studio is compatible with the version of the Table Region Plugin.

Table_Region_Compact.png


Best Regards

Carlos




Hi Carlos:

Thank you so much for the response.

Archivo no encontrado.Archivo no encontrado.

How do I know if they are compatible?

I installed the plugin from within the extension manager (from online gallery) and assume they are compatible?

Thanks,

Chris
#11 Publicado: 2/7/2019 19:05:37
Davide Carpi

Davide Carpi

1.443 me gusta en 2.936 mensajes.

Grupo: Moderator

Seems the right version. You can guess it is the right version by the 3rd 4-digits number, that should be similar and usually the same or slightly greater in the plugin. You can have more hints by checking the release dates. If you installed it by the internal release manager or by opening a worksheet there shouldn't be conflicts. I don't know what happened, if I have time tomorrow I'll try to make some tests...
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#12 Publicado: 2/7/2019 19:09:04
CBG

CBG

78 me gusta en 312 mensajes.

Grupo: User

Hi Chris

The green color and the tilde indicate that it is compatible.
When the plugin is not compactible it is shown as the following example.

Table_Region_Fail.png


Why not try the latest version of Smath Studio?

Best Regards

Carlos
#13 Publicado: 2/7/2019 20:18:31
aviateCar

aviateCar

0 me gusta en 16 mensajes.

Grupo: User

Wrote

Seems the right version. You can guess it is the right version by the 3rd 4-digits number, that should be similar and usually the same or slightly greater in the plugin. You can have more hints by checking the release dates. If you installed it by the internal release manager or by opening a worksheet there shouldn't be conflicts. I don't know what happened, if I have time tomorrow I'll try to make some tests...



Thank you for walking me through this procedure David!

Stress Analysis-Table Region Failed.sm (152,05 KiB) descargado 1127 vez(es).

Attached is the subjected worksheet. Please review.

Thanks again!

Chris
#14 Publicado: 2/7/2019 20:22:06
aviateCar

aviateCar

0 me gusta en 16 mensajes.

Grupo: User

Wrote

Hi Chris

The green color and the tilde indicate that it is compatible.
When the plugin is not compactible it is shown as the following example.

Why not try the latest version of Smath Studio?

Best Regards

Carlos



Thank you Carlos!

Its a work computer and it takes time for IT to respond any request.

I ll try it on my own computer, a mac tho...

Thanks again!
#15 Publicado: 4/7/2019 5:33:01
fedeghi

fedeghi

25 me gusta en 112 mensajes.

Grupo: User

Wrote


Attached is the subjected worksheet. Please review.

Thanks again!

Chris



Hi Chris, I have downloaded and opened your file, same problem on my PC.

In any case, Table plug-in is still working correctly for me, when opening other files.
So, I'm afraid that in your case the bug is not in the plug-in installation itself, but in the calculation file that maybe got corrupted in some way?

Strange that when I open you file, first page is completely blank, second is a snapshot of a figure/book, third apparently contains nothing more than one declaration, some text and the mentioned error "red box".
Is there no other maths? Or did it get deleted by you? Or maybe by the bugged table?

Bye
#16 Publicado: 4/7/2019 11:08:00
Jean Giraud

Jean Giraud

983 me gusta en 6.866 mensajes.

Grupo: User

For what is worth: stable SS 6179 from Carlos 7019
#17 Publicado: 4/7/2019 12:02:44
aviateCar

aviateCar

0 me gusta en 16 mensajes.

Grupo: User

Wrote

Wrote


Attached is the subjected worksheet. Please review.

Thanks again!

Chris



Hi Chris, I have downloaded and opened your file, same problem on my PC.

In any case, Table plug-in is still working correctly for me, when opening other files.
So, I'm afraid that in your case the bug is not in the plug-in installation itself, but in the calculation file that maybe got corrupted in some way?

Strange that when I open you file, first page is completely blank, second is a snapshot of a figure/book, third apparently contains nothing more than one declaration, some text and the mentioned error "red box".
Is there no other maths? Or did it get deleted by you? Or maybe by the bugged table?

Bye



Hi Fedeghi:

Thank you so much for trying to help.

I deleted the first page. When the "red box" appeared, it took about 4 pages of content away. Only 2 pages are related to the table region, the rest of them were independent.

Stress Analysis-Moment of Inertia Calculation.sm (27,27 KiB) descargado 1125 vez(es).

Here is the "table region" as an independent file. It worked fine until I inserted it into the main file.

Thank you!

Chris

#18 Publicado: 4/7/2019 12:11:05
aviateCar

aviateCar

0 me gusta en 16 mensajes.

Grupo: User

Wrote

For what is worth: stable SS 6179 from Carlos 7019



Maybe thats the reason... Carlos used a newer version to prepare it but I used the older one to modify it, but on the other side, they are all math!
#19 Publicado: 4/7/2019 17:07:26
CBG

CBG

78 me gusta en 312 mensajes.

Grupo: User

Here is a version of the file in SS-7030 including a sheet that is visible from the file that failed

Stress_Analysis_Fail.png

Stress Analysis-Moment of Inertia Calculation_V7030.sm (167,23 KiB) descargado 1215 vez(es).


Best Regards

Carlos
#20 Publicado: 4/7/2019 17:16:19
aviateCar

aviateCar

0 me gusta en 16 mensajes.

Grupo: User

Wrote

Here is a version of the file in SS-7030 including a sheet that is visible from the file that failed

Stress_Analysis_Fail.png

Stress Analysis-Moment of Inertia Calculation_V7030.sm (167,23 KiB) descargado 1215 vez(es).


Best Regards

Carlos



Thank you Carlos!

There is supposed to be 2 more pages of data. I assume when the error happens it removed everything after it.

Anyways, I have re written everything and so far no issues.

Thanks again for your help!

Chris
  • Nuevos mensajes
  • Sin mensajes nuevos