Excel or spreadsheet region plug in

Excel or spreadsheet region plug in - Excel or spreadsheet region plug in - Messaggi

#1 Pubblicato: 28/06/2019 18:44:27
aviateCar

aviateCar

0 apprezzamenti in 16 post.

Gruppo: 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 Pubblicato: 28/06/2019 21:31:53
Jean Giraud

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: 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) scaricato 1158 volta(e).
Inst_Colebrook Pipe Data.sm (61,58 KiB) scaricato 1166 volta(e).
#3 Pubblicato: 29/06/2019 04:30:09
fedeghi

fedeghi

25 apprezzamenti in 112 post.

Gruppo: 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 Pubblicato: 29/06/2019 16:09:55
CBG

CBG

78 apprezzamenti in 312 post.

Gruppo: User

Something like this?

Table_Moment.png

Tabla_Momentos.sm (57,1 KiB) scaricato 1191 volta(e).


Best Regards

Carlos
1 utenti hanno apprezzato questo post
Andrey Ivashov 30/06/2019 19:28:00
#5 Pubblicato: 02/07/2019 12:30:34
aviateCar

aviateCar

0 apprezzamenti in 16 post.

Gruppo: 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) scaricato 1158 volta(e).
Inst_Colebrook Pipe Data.sm (61,58 KiB) scaricato 1166 volta(e).




Thank you! Will try that later.
#6 Pubblicato: 02/07/2019 12:32:06
aviateCar

aviateCar

0 apprezzamenti in 16 post.

Gruppo: 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 Pubblicato: 02/07/2019 12:33:07
aviateCar

aviateCar

0 apprezzamenti in 16 post.

Gruppo: User

Wrote

Something like this?

Table_Moment.png

Tabla_Momentos.sm (57,1 KiB) scaricato 1191 volta(e).


Best Regards

Carlos



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

aviateCar

0 apprezzamenti in 16 post.

Gruppo: User

Wrote

Wrote

Something like this?

Table_Moment.png

Tabla_Momentos.sm (57,1 KiB) scaricato 1191 volta(e).


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 Pubblicato: 02/07/2019 18:33:13
CBG

CBG

78 apprezzamenti in 312 post.

Gruppo: 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 Pubblicato: 02/07/2019 18:48:27
aviateCar

aviateCar

0 apprezzamenti in 16 post.

Gruppo: 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.

File non trovato.File non trovato.

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 Pubblicato: 02/07/2019 19:05:37
Davide Carpi

Davide Carpi

1.443 apprezzamenti in 2.936 post.

Gruppo: 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 Pubblicato: 02/07/2019 19:09:04
CBG

CBG

78 apprezzamenti in 312 post.

Gruppo: 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 Pubblicato: 02/07/2019 20:18:31
aviateCar

aviateCar

0 apprezzamenti in 16 post.

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

Attached is the subjected worksheet. Please review.

Thanks again!

Chris
#14 Pubblicato: 02/07/2019 20:22:06
aviateCar

aviateCar

0 apprezzamenti in 16 post.

Gruppo: 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 Pubblicato: 04/07/2019 05:33:01
fedeghi

fedeghi

25 apprezzamenti in 112 post.

Gruppo: 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 Pubblicato: 04/07/2019 11:08:00
Jean Giraud

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: User

For what is worth: stable SS 6179 from Carlos 7019
#17 Pubblicato: 04/07/2019 12:02:44
aviateCar

aviateCar

0 apprezzamenti in 16 post.

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

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

Thank you!

Chris

#18 Pubblicato: 04/07/2019 12:11:05
aviateCar

aviateCar

0 apprezzamenti in 16 post.

Gruppo: 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 Pubblicato: 04/07/2019 17:07:26
CBG

CBG

78 apprezzamenti in 312 post.

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


Best Regards

Carlos
#20 Pubblicato: 04/07/2019 17:16:19
aviateCar

aviateCar

0 apprezzamenti in 16 post.

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


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