ExcelResult2.xlsm (39 КиБ) скачан 66 раз(а).Hey guys,

im coming form mathcad and want to try smath if its better for me and for my calculations.

To my problem:

I have big excel files with input datas from Loadcases. Can be 30 loadcases or more.
The number of laodcases are different from project to project.

So i need to load in the input matrix. This input Matrix should be dependend of the number of loadcases.

What i realised in mathcad: Reading the maximum number of loadcases form excel (only a number)

Now importing a matrix, which columns are dependend of this imported number

Now i need to use Excel XLSM because performing different additional functions in excel.

I tryed with smath and loaded some extensions, but i didnt get to manage it.

Can somone help me ?

I attached the excel file how it should look like. Below the input parameters is the result area.

Best Thx=)))

ExcelResult2.xlsm (39 КиБ) скачан 82 раз(а).

O jea and by the way.

I also need to transform the matrix because every loadcase needs to be vertical so i can define every input parameter as vector and calculate every loadcase vectorised

Hello soletto,

You can use importData.xlsx(...) from XlsxImportExport plugin (if you already have the plugin you have to update it, since there was a bug in the extensions handling; if you can't update just rename the file as .xlsx); I can't try but I guess that also EXCEL I/O plugin should works.

To transform the imported matrix, you can use the transpose function or create a new matrix with programming functions (for/while loops).

OK thx input seems to work and i dont need to specify the number of columns i want to read in thats good so all loadcases are calculated.

But i really need the possibility to read in the xlsm format because i always need the makro function.


I have too much excel datas to calculate and i cannot safe it as xlsx coz i need the makro after.

Would it be possible to add xlsm support or is it not possible?

Seems to be a good programm an a good alternative to mathcad and the not usable Prime

In XlsxImportExport is not possible, since to execute the macros you need to run them inside Excel and this plugin is designed to work indipendently from third party applications.

I guess may be possible in the EXCEL I/O plugin, since it works directly with Microsoft Excel (we have to wait comments from Alex here).

Ok thx for info. I really hope this is possible.

Hello Soletto,

I Understand what you are attempting to do: being myself a former
Process Control & Instrumentation [Consultant]. Mathcad 11 was great
for collecting loops components, specification list style ... including
XTR's their calibration range, Orifice Plates ...

That reminds me to do "Valve Sizing" in Smath. There are about a dozen
Smath "Instrumentation" done, including Orifice plates.

By default, in Mathcad, the "comments" are black, but there is a way
to have them in other colors. Unfortunately, my Mathcad 11 is now "Museum".

Jean

Hallo Jean,

what do you mean with "That reminds me to do "Valve Sizing"

Yea when i started with my new work i had the idea that i can automatisise well defined calculations.

For Example calculating all 23 different pipes weather they are OK or NOK regarding goverment formulas.

I realised it by writing all loadcases in the excel file as you can see and seting up the calculation in mathcad because easy writing of formulas with the symbolic input.

Calculating and the result im retransporting to excel for making report.

This is working pretty good. IN the last time i realised a second mathcad file in which i can calculate one loadcase manually by defining a number in mathcad which then shows the variables for that loadcase.


But i get to a point that some parts of mathcad are really annoying.

Especially when i want to do an iterative Calculation with a program which is really big.

And the writing possibilityies are really not usable. All Mathcad Files are looking really horrible.

So is my hope i can do this with smath.

And i need a Content like in Word.

Up to now i hope its possible in smath.

But as to say XLSM input is not possible i can not proceed :-(

Best regards form Austria

Hmm i think Mathcad 11 is older than me and im 31

Wrote

Hmm I think Mathcad 11 is older than me and I'm 31

Not that much older than you. In 2003, you were just a naughty boy of 18 !

Given pipe size/min_max flow/pressure across the valve, valve sizing
consists in selecting the appopriate valve zize/style ...
Looks simple, not so ... I suspect a 2 days work to make it Smath.

Cheers, Jean

yea i solved a lot of calculations via Mathcad Excel connection.

But im not satisfied with mathcad.

But i cannot open my mathcad files in smath

But as i cannot read from xlsm i cannot use smath at the moment coz all of my excel files contain makros

Wrote

In XlsxImportExport is not possible, since to execute the macros you need to run them inside Excel and this plugin is designed to work indipendently from third party applications.

I guess may be possible in the EXCEL I/O plugin, since it works directly with Microsoft Excel (we have to wait comments from Alex here).

Ihave used excel_IO with spreadsheets that contain macro.. You will need to assign macro execution on cell change or similar.

If you post an example .sm workbook & .xlsm sheet with instructions on what you want to achieve I can give it a shot

Wrote

...
Ihave used excel_IO with spreadsheets that contain macro.. You will need to assign macro execution on cell change or similar.
...

Hi. There are two kind of macros in excel: "Pure" macros, which starts with Sub(), and "formula" macros, starting with Function().

The bigest difference between both is that pure macros can modify any cell, but formula macros can't. Also, formula macros can be called inside the cell, but pure macros don't.

My experience is that even the most people uses pure macros, the same calculus can be done better with functions. I don't try smath with xlsm function macros, but guess that don't need special treatment, and works like any other formula in excel.

Best regards.

Alvaro.