Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Login
2 Pages12>
Excel or spreadsheet region plug in - Excel or spreadsheet region plug in
Options
Go to last post Go to first unread
Previous Topic Next Topic
Offline aviateCar  
#1 Posted : 29 June 2019 00:44:27(UTC)
aviateCar


Rank: Member

Groups: Registered
Joined: 28/06/2019(UTC)
Posts: 16
Canada
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
Back to top

Wanna join the discussion?! Login to your SMath Studio Forum forum account. New Registrations are disabled.
Back to top  
Offline Jean Giraud  
#2 Posted : 29 June 2019 03:31:53(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,866
Canada

Was thanked: 981 time(s) in 809 post(s)
Originally Posted by: aviateCar Go to Quoted Post
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 (20kb) downloaded 26 time(s).
Inst_Colebrook Pipe Data.sm (62kb) downloaded 29 time(s).
Back to top
Offline fedeghi  
#3 Posted : 29 June 2019 10:30:09(UTC)
fedeghi


Rank: Advanced Member

Groups: Registered
Joined: 14/09/2013(UTC)
Posts: 90
Italy

Was thanked: 24 time(s) in 16 post(s)
Originally Posted by: aviateCar Go to Quoted Post
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 Good

Of course, as Jean suggested, every calculation should be prepared using matrix approach.
Back to top
Offline CBG  
#4 Posted : 29 June 2019 22:09:55(UTC)
CBG


Rank: Advanced Member

Groups: Registered
Joined: 14/10/2015(UTC)
Posts: 308

Was thanked: 77 time(s) in 58 post(s)
Something like this?

Table_Moment.png

Tabla_Momentos.sm (58kb) downloaded 44 time(s).


Best Regards

Carlos
Back to top
thanks 1 user thanked CBG for this useful post.
on 01/07/2019(UTC)
Offline aviateCar  
#5 Posted : 02 July 2019 18:30:34(UTC)
aviateCar


Rank: Member

Groups: Registered
Joined: 28/06/2019(UTC)
Posts: 16
Canada
Originally Posted by: Jean Giraud Go to Quoted Post
Originally Posted by: aviateCar Go to Quoted Post
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 (20kb) downloaded 26 time(s).
Inst_Colebrook Pipe Data.sm (62kb) downloaded 29 time(s).



Thank you! Will try that later.
Back to top
Offline aviateCar  
#6 Posted : 02 July 2019 18:32:06(UTC)
aviateCar


Rank: Member

Groups: Registered
Joined: 28/06/2019(UTC)
Posts: 16
Canada
Originally Posted by: fedeghi Go to Quoted Post
Originally Posted by: aviateCar Go to Quoted Post
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 Good

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.
Back to top
Offline aviateCar  
#7 Posted : 02 July 2019 18:33:07(UTC)
aviateCar


Rank: Member

Groups: Registered
Joined: 28/06/2019(UTC)
Posts: 16
Canada
Originally Posted by: CBG Go to Quoted Post
Something like this?

Table_Moment.png

Tabla_Momentos.sm (58kb) downloaded 44 time(s).


Best Regards

Carlos


Exactly what I was looking for! Thank you so much! This function is going to be really useful for me.
Back to top
Offline aviateCar  
#8 Posted : 02 July 2019 23:01:41(UTC)
aviateCar


Rank: Member

Groups: Registered
Joined: 28/06/2019(UTC)
Posts: 16
Canada
Originally Posted by: aviateCar Go to Quoted Post
Originally Posted by: CBG Go to Quoted Post
Something like this?

Table_Moment.png

Tabla_Momentos.sm (58kb) downloaded 44 time(s).


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
Back to top
Offline CBG  
#9 Posted : 03 July 2019 00:33:13(UTC)
CBG


Rank: Advanced Member

Groups: Registered
Joined: 14/10/2015(UTC)
Posts: 308

Was thanked: 77 time(s) in 58 post(s)


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

Edited by user 03 July 2019 00:38:24(UTC)  | Reason: Not specified
Back to top
Offline aviateCar  
#10 Posted : 03 July 2019 00:48:27(UTC)
aviateCar


Rank: Member

Groups: Registered
Joined: 28/06/2019(UTC)
Posts: 16
Canada
Originally Posted by: CBG Go to Quoted Post


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.

1.png2.png

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
Back to top
Offline Davide Carpi  
#11 Posted : 03 July 2019 01:05:37(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,647
Man
Italy
Location: Italy

Was thanked: 1329 time(s) in 875 post(s)
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 consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
Back to top
Offline CBG  
#12 Posted : 03 July 2019 01:09:04(UTC)
CBG


Rank: Advanced Member

Groups: Registered
Joined: 14/10/2015(UTC)
Posts: 308

Was thanked: 77 time(s) in 58 post(s)
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
Back to top
Offline aviateCar  
#13 Posted : 03 July 2019 02:18:31(UTC)
aviateCar


Rank: Member

Groups: Registered
Joined: 28/06/2019(UTC)
Posts: 16
Canada
Originally Posted by: Davide Carpi Go to Quoted Post
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 (153kb) downloaded 17 time(s).

Attached is the subjected worksheet. Please review.

Thanks again!

Chris
Back to top
Offline aviateCar  
#14 Posted : 03 July 2019 02:22:06(UTC)
aviateCar


Rank: Member

Groups: Registered
Joined: 28/06/2019(UTC)
Posts: 16
Canada
Originally Posted by: CBG Go to Quoted Post
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!
Back to top
Offline fedeghi  
#15 Posted : 04 July 2019 11:33:01(UTC)
fedeghi


Rank: Advanced Member

Groups: Registered
Joined: 14/09/2013(UTC)
Posts: 90
Italy

Was thanked: 24 time(s) in 16 post(s)
Originally Posted by: aviateCar Go to Quoted Post

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
Back to top
Offline Jean Giraud  
#16 Posted : 04 July 2019 17:08:00(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,866
Canada

Was thanked: 981 time(s) in 809 post(s)
For what is worth: stable SS 6179 from Carlos 7019
Back to top
Offline aviateCar  
#17 Posted : 04 July 2019 18:02:44(UTC)
aviateCar


Rank: Member

Groups: Registered
Joined: 28/06/2019(UTC)
Posts: 16
Canada
Originally Posted by: fedeghi Go to Quoted Post
Originally Posted by: aviateCar Go to Quoted Post

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 (28kb) downloaded 12 time(s).

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

Thank you!

Chris
Back to top
Offline aviateCar  
#18 Posted : 04 July 2019 18:11:05(UTC)
aviateCar


Rank: Member

Groups: Registered
Joined: 28/06/2019(UTC)
Posts: 16
Canada
Originally Posted by: Jean Giraud Go to Quoted Post
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!Wallbash
Back to top
Offline CBG  
#19 Posted : 04 July 2019 23:07:26(UTC)
CBG


Rank: Advanced Member

Groups: Registered
Joined: 14/10/2015(UTC)
Posts: 308

Was thanked: 77 time(s) in 58 post(s)
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 (168kb) downloaded 16 time(s).


Best Regards

Carlos
Back to top
Offline aviateCar  
#20 Posted : 04 July 2019 23:16:19(UTC)
aviateCar


Rank: Member

Groups: Registered
Joined: 28/06/2019(UTC)
Posts: 16
Canada
Originally Posted by: CBG Go to Quoted Post
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 (168kb) downloaded 16 time(s).


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
Back to top
Users browsing this topic
Guest
2 Pages12>
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET