Excel or spreadsheet region plug in

Excel or spreadsheet region plug in - Excel or spreadsheet region plug in - Сообщения

#1 Опубликовано: 28.06.2019 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 Опубликовано: 28.06.2019 21:31:53
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: 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 КиБ) скачан 44 раз(а).
Inst_Colebrook Pipe Data.sm (61 КиБ) скачан 50 раз(а).
#3 Опубликовано: 29.06.2019 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 Опубликовано: 29.06.2019 16:09:55
CBG

CBG

77 сообщений из 312 понравились пользователям.

Группа: User

Something like this?

Table_Moment.png

Tabla_Momentos.sm (57 КиБ) скачан 64 раз(а).


Best Regards

Carlos
1 пользователям понравился этот пост
Andrey Ivashov 30.06.2019 19:28:00
#5 Опубликовано: 02.07.2019 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 КиБ) скачан 44 раз(а).
Inst_Colebrook Pipe Data.sm (61 КиБ) скачан 50 раз(а).




Thank you! Will try that later.
#6 Опубликовано: 02.07.2019 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 Опубликовано: 02.07.2019 12:33:07
aviateCar

aviateCar

0 сообщений из 16 понравились пользователям.

Группа: User

Wrote

Something like this?

Table_Moment.png

Tabla_Momentos.sm (57 КиБ) скачан 64 раз(а).


Best Regards

Carlos



Exactly what I was looking for! Thank you so much! This function is going to be really useful for me.
#8 Опубликовано: 02.07.2019 17:01:41
aviateCar

aviateCar

0 сообщений из 16 понравились пользователям.

Группа: User

Wrote

Wrote

Something like this?

Table_Moment.png

Tabla_Momentos.sm (57 КиБ) скачан 64 раз(а).


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 Опубликовано: 02.07.2019 18:33:13
CBG

CBG

77 сообщений из 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 Опубликовано: 02.07.2019 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 Опубликовано: 02.07.2019 19:05:37
Davide Carpi

Davide Carpi

1416 сообщений из 2873 понравились пользователям.

Группа: 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 Опубликовано: 02.07.2019 19:09:04
CBG

CBG

77 сообщений из 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 Опубликовано: 02.07.2019 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 КиБ) скачан 35 раз(а).

Attached is the subjected worksheet. Please review.

Thanks again!

Chris
#14 Опубликовано: 02.07.2019 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 Опубликовано: 04.07.2019 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 Опубликовано: 04.07.2019 11:08:00
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: User

For what is worth: stable SS 6179 from Carlos 7019
#17 Опубликовано: 04.07.2019 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 КиБ) скачан 35 раз(а).

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

Thank you!

Chris

#18 Опубликовано: 04.07.2019 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 Опубликовано: 04.07.2019 17:07:26
CBG

CBG

77 сообщений из 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 КиБ) скачан 38 раз(а).


Best Regards

Carlos
#20 Опубликовано: 04.07.2019 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 КиБ) скачан 38 раз(а).


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
  • Новые сообщения Новые сообщения
  • Нет новых сообщений Нет новых сообщений