Christopher,
I dont use Excel that often. I leave it to the Beanies to use. Have seen too many mistakes made in Excel.
But for the miniscule investment in TK solver and the R&Y module I think you would be a mile a head on any cost benefit analysis basis. Its so intuitive for engineers and you are up and running in no time. The beauty of the appproach the software uses is if there are 20 variables and you know 19 it will solve for the unknown without having to jig around your code or structure. In Excel you have to goal seek but that does not always work . As for weverything in macros that makes it even more complex.
I prefer to use my time doing the engineering not writing elegant software applications.
Geoff
Geoff Stone
Christopher Wright <chrisw@skypoint.com> wrote:
On Feb 17, 2006, at 4:26 AM, Steve McKenzie wrote:
> I am embarassed to say I still use the 5th edition.
> Better buy some software.
I still use the 4th edition and I'm glad. One thing you might want to
consider is making yourself an Excel workbook with a library of the
formulas you use often. It's not too difficult to write macro functions
to do the arithmetic, and if you name all the variables all the
equations look like they do in the book, rather than having cell
references. I do this for Section VIII calculations as a sort of
project notebook, and it's a wonderful help.
Visual Basic looks like a great pain in the ass when you start off, but it's not all that bad. The really great thing about using Excel for that is portability. You can write off results as basic ASCII files, use them in Merge documents and link results into MSWord documents if you need something for your client or your file. You have basic charting tools available if you need them and even a fair amount of optimization (Goal seek) and what-if? capability.
Christopher Wright P.E. |"They couldn't hit an elephant at chrisw@skypoint.com | this distance" (last words of Gen.
.......................................| John Sedgwick, Spotsylvania1864)
SPONSORED LINKS
Mechanical engineering Mechanical engineering jobs Cad drafter
Process piping Mechanical
YAHOO! GROUPS LINKS Visit your group "PipingDesign" on the web.
To unsubscribe from this group, send an email to: PipingDesign-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Design Detail and Development (a division of Blenray Pty Ltd)
Mail Address PO Box 1351 Castle Hill NSW 1765 Australia Tel Mob 0402 35 2313
Office 02 8850 2313 AH 02 8850 2324
We specialise in pipe network and waterhammer analysis, pipe stress analysis,
the design of buried pipelines and thermoplastic pipe systems.
[Non-text portions of this message have been removed] Received on Fri Feb 17 21:54:00 2006
This archive was generated by hypermail 2.1.8 : Mon Oct 27 2008 - 20:24:10 EDT