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)
>http://www.skypoint.com/~chrisw/
>
>
>
>=========================================
>PipingOffice - Excel Spreadsheets for Piping Calculations
>http://www.pipingoffice.us/
>=========================================
>Main site: http://www.pipingdesign.com
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
Received on Fri Feb 17 14:04:00 2006
This archive was generated by hypermail 2.1.8 : Mon Oct 27 2008 - 20:24:10 EDT