Skip to main content
J
jkukwa1-Visitor
1-Visitor
October 23, 2015
Question

Excel component in a program

  • October 23, 2015
  • 1 reply
  • 2683 views

I have a detailed spreadsheet for calculating pipe pressure drop and pump head requirements.

Would love to be able to include this in a loop or be able to port in/out ranges of variables to generate system curves.

I used to be able to do it in MathCad about 10 years ago.  I don't have my old sheets any longer.

Anyone know of a way to get MathCad to handle a spreadsheet like this?

1 reply

S
StuartBruff23-Emerald V
23-Emerald V
October 23, 2015

John Kukwa wrote:

I have a detailed spreadsheet for calculating pipe pressure drop and pump head requirements.

Would love to be able to include this in a loop or be able to port in/out ranges of variables to generate system curves.

I used to be able to do it in MathCad about 10 years ago.  I don't have my old sheets any longer.

Anyone know of a way to get MathCad to handle a spreadsheet like this?

If you could do it 10 years ago in Mathcad, you can probably still do it with the current versions of Mathcad (either M15 or Prime 3.1).   Could you provide a little more detail about what you want to do (a 'demo' Excel sheet and a bit of pseudo-code would be helpful).

Stuart

J
jkukwa1-VisitorAuthor
1-Visitor
October 23, 2015

Stuart,

Good morning.

Regrettably I do not have MCad 15 - and I won't be able to install it on my PC.

The attached sheet shows what I am doing.  I input "Flow" and get "TDH".

I want to vary flow from say 0-250 and get the corresponding TDH's.

I swear I used to be able to just make the thing a function or "Flow" an array because I have done this in the past.

Thank you for any light you can shed.  If you need a nice pump sizing spreadsheet you are welcome to use the attached.

Thanks.

John

S
StuartBruff23-Emerald V
23-Emerald V
October 23, 2015

John Kukwa wrote:

Stuart,

Good morning.

Regrettably I do not have MCad 15 - and I won't be able to install it on my PC.

The attached sheet shows what I am doing.  I input "Flow" and get "TDH".

I want to vary flow from say 0-250 and get the corresponding TDH's.

I swear I used to be able to just make the thing a function or "Flow" an array because I have done this in the past.

Thank you for any light you can shed.  If you need a nice pump sizing spreadsheet you are welcome to use the attached.

Ah.  Thanks for attaching the worksheet, John, but unfortunately, I don't have Excel on my system and can't, therefore, read the embedded worksheet (It would be nice if PTC allowed their "Excel" component to work with OpenOffice/LibreOffice).   Any chance you could post just the worksheet?  Thanks,

Is it because of corporate IT reasons that you can't install M15 on your PC?  If so, then you might have an argument to get it installed, as M15 is necessary for Prime's MCD/XMCD to MCDX Converter to work.   You should either have got M15 as part of your Prime package or you (or, rather your IT Dept) can download it for free from here Download PTC Mathcad 15.0 Free | PTC.   Without it, you can't load any worksheets made in previous versions of Mathcad.

Stuart

Terms & ConditionsAccessibility statement