3 replies to this topic

[Chris Haslego]

As many of you move over to the 2007 version of MS Excel, you may notice compatibility problems with spreadsheet that invoke the Solver function. We've updated two (2) such tools on the site.

Steam Tracing Spreadsheet (Excel 2007 edition)

Pipe Sizing Tool (Excel 2007 edition)

In case some of you have other spreadsheets, here is an example of the types of changes that we've had to make.

Valid code for previous versions of MS Excel:

CODE

SolverOK SetCell:="$P$148", MaxMinVal:=2, ValueOf:="0", ByChange:=_ "$O$144,$O$145,$K$150,$K$182"
SolverSolve True

Replacement code for MS Excel 2007:

CODE

Application.Run "solver.xlam!solverok", "$P$148", "2", "0", "$O$144,$O$145,$K$150,$K$182"
Application.Run "solver.xlam!solversolve", True

I hope this information is helpful. The new versions have also been posted on the pages where the tools were first introduced on the site.

[sheiko]

Pipe Sizing Tool (Excel 2007 edition)

Just to let you know that in the article "Updated Rules for Pipe Sizing" related to the pipe sizing spreadsheet, the parameter M of the Generaux equation: M=(a'+b')*E*P/(17.9*K*Y) is equal to 0.065 (as a'+b'=0.4, E=0.5, P=150, K=0.07 and Y=365) and not 0.575 as written in the article. It shall affect the results given by the spreadsheet in some proportion...

Edited by sheiko, 07 November 2009 - 01:10 PM.

[sunhao8459]

Sorry, I don't know how to use it. the excle is wrong. Please make some picture to show.

I suggest adding the as the last line of code in the pipe size macro. Otherwise one ends up with dozens of identical constaints

Application.Run "solver.xlam!solverreset"