Excel or spreadsheet region plug in

Excel or spreadsheet region plug in - Excel or spreadsheet region plug in - 消息

#1 已发布: 2019/6/28 18:44:27
aviateCar

aviateCar

0个赞,共16个帖子。

组: 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 已发布: 2019/6/28 21:31:53
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: 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)已下载 1169 次。
Inst_Colebrook Pipe Data.sm (61.58 KiB)已下载 1172 次。
#3 已发布: 2019/6/29 04:30:09
fedeghi

fedeghi

25个赞,共112个帖子。

组: 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 已发布: 2019/6/29 16:09:55
CBG

CBG

78个赞,共312个帖子。

组: User

Something like this?

Table_Moment.png

Tabla_Momentos.sm (57.1 KiB)已下载 1196 次。


Best Regards

Carlos
1位用户喜欢此帖子
Andrey Ivashov 2019/6/30 19:28:00
#5 已发布: 2019/7/2 12:30:34
aviateCar

aviateCar

0个赞,共16个帖子。

组: 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)已下载 1169 次。
Inst_Colebrook Pipe Data.sm (61.58 KiB)已下载 1172 次。




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

aviateCar

0个赞,共16个帖子。

组: 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 已发布: 2019/7/2 12:33:07
aviateCar

aviateCar

0个赞,共16个帖子。

组: User

Wrote

Something like this?

Table_Moment.png

Tabla_Momentos.sm (57.1 KiB)已下载 1196 次。


Best Regards

Carlos



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

aviateCar

0个赞,共16个帖子。

组: User

Wrote

Wrote

Something like this?

Table_Moment.png

Tabla_Momentos.sm (57.1 KiB)已下载 1196 次。


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 已发布: 2019/7/2 18:33:13
CBG

CBG

78个赞,共312个帖子。

组: 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 已发布: 2019/7/2 18:48:27
aviateCar

aviateCar

0个赞,共16个帖子。

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

未找到文件。未找到文件。

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 已发布: 2019/7/2 19:05:37
Davide Carpi

Davide Carpi

1,443个赞,共2,936个帖子。

组: 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 已发布: 2019/7/2 19:09:04
CBG

CBG

78个赞,共312个帖子。

组: 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 已发布: 2019/7/2 20:18:31
aviateCar

aviateCar

0个赞,共16个帖子。

组: 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)已下载 1135 次。

Attached is the subjected worksheet. Please review.

Thanks again!

Chris
#14 已发布: 2019/7/2 20:22:06
aviateCar

aviateCar

0个赞,共16个帖子。

组: 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 已发布: 2019/7/4 05:33:01
fedeghi

fedeghi

25个赞,共112个帖子。

组: 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 已发布: 2019/7/4 11:08:00
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: User

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

aviateCar

0个赞,共16个帖子。

组: 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)已下载 1133 次。

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

Thank you!

Chris

#18 已发布: 2019/7/4 12:11:05
aviateCar

aviateCar

0个赞,共16个帖子。

组: 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 已发布: 2019/7/4 17:07:26
CBG

CBG

78个赞,共312个帖子。

组: 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)已下载 1231 次。


Best Regards

Carlos
#20 已发布: 2019/7/4 17:16:19
aviateCar

aviateCar

0个赞,共16个帖子。

组: 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)已下载 1231 次。


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
  • 有新帖
  • 无新帖