RE: Stress Analysis Spreadsheet Software - Opinions

From: <Steve>
Date: Sat Feb 18 2006 - 06:00:00 EST

Thanks Ivan

I did a bit of googling, and see what you mean. Looking forward to giving it a go.

Cheers

Steve

-----Original Message-----
From: <a href="/group/PipingDesign/post?postID=OgafxFFRHahRLDrH_J0Q9SSkXe8cGT5N_9YZxRrwVQMVD2zcDBnxphQcg5pMu5_tyfMIGpmVLXapGyWgxliGPafgneo">PipingDesign@yahoogroups.com</a> [mailto:<a href="/group/PipingDesign/post?postID=OgafxFFRHahRLDrH_J0Q9SSkXe8cGT5N_9YZxRrwVQMVD2zcDBnxphQcg5pMu5_tyfMIGpmVLXapGyWgxliGPafgneo">PipingDesign@yahoogroups.com</a>] On Behalf Of Ivan Locke
Sent: Saturday, February 18, 2006 8:05 AM To: <a href="/group/PipingDesign/post?postID=OgafxFFRHahRLDrH_J0Q9SSkXe8cGT5N_9YZxRrwVQMVD2zcDBnxphQcg5pMu5_tyfMIGpmVLXapGyWgxliGPafgneo">PipingDesign@yahoogroups.com</a> Subject: Re: [PipingDesign] Stress Analysis Spreadsheet Software - Opinions

Just a note on Excel functionality that isn't used much by people, but is really useful, is making user defined functions. It is at least the same ease as writing as a macro, and I believe easier because you pass it values rather than having the macro get the values. Also, you can make these functions load with Excel such that they can be called from any spreadsheet. Just google for "excel user defined functions" and plenty of helpful references will pop up.

Ivan Locke

Christopher Wright 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, Spotsylvania
>1864)
><a href="http://www.skypoint.com/~chrisw/">http://www.skypoint.com/~chrisw/</a>
>
>
>
>=========================================
>PipingOffice - Excel Spreadsheets for Piping Calculations
>http://www.pipingoffice.us/ =========================================
>Main site: <a href="http://www.pipingdesign.com">http://www.pipingdesign.com</a>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>

---

PipingOffice - Excel Spreadsheets for Piping Calculations

<a href="http://www.pipingoffice.us/">http://www.pipingoffice.us/</a> =========================================

Main site: <a href="http://www.pipingdesign.com">http://www.pipingdesign.com</a>

Yahoo! Groups Links

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.10/263 - Release Date:
2/16/2006


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.10/263 - Release Date:
2/16/2006

Received on Sat Feb 18 06:00:00 2006