• To: seaint(--nospam--at)seaint.org
• Subject: RE: Mathcad 2000 Question
• From: Charles Espenlaub <Cespenlaub(--nospam--at)martinaia.com>
• Date: Fri, 7 Jul 2000 15:55:57 -0400
```I disagree.  EXCEL, can be easy to follow if you document your
equations.  If all you do is have input fields, and calculate your
answer with one complicated equation in one cell, with no comments, it
is very hard to follow.  But if you write out the equations to the side,
and/or show intermediate steps (as if you were doing it by hand), it can
be easy to follow.

EXCEL has the added benefit that if you set up the problem correctly,
you can use the solver routine to solve for any particular variable.
For simple example, with a spreadsheet for designing a concrete beam,
you could solve for the required reinforcing, given an assumed size and
depth.  Alternatively (Fy, F'c, etc. staying constant), using the same
spreadsheet, you could solve for the depth assuming the reinforcing and
width of beam.

Charles F. Espenlaub, III, P.E.
Martin-Espenlaub Engineering

-----Original Message-----
From: Bill Allen [mailto:Bill(--nospam--at)AllenDesigns.com]
Sent: Friday, July 07, 2000 2:24 PM
To: seaint(--nospam--at)seaint.org

Yeah, Excel IS easy to do calculations in. The problem(s) with Excel is
that
it is difficult for someone to follow the algorithms (even myself on an
old
template) and the format is best suited for tables, not a complete set
of
calculations. Excel is a tool but not a tool box.

Regards,

Bill Allen, S.E. (CA #2607)
ALLEN DESIGNS
Laguna Niguel, CA
http://www.AllenDesigns.com

||-----Original Message-----
||From: sharonb(--nospam--at)slarchitects.com [mailto:sharonb(--nospam--at)slarchitects.com]
||Sent: Thursday, July 06, 2000 4:21 PM
||To: seaint(--nospam--at)seaint.org
||
||
||Why is this so complicated?  The solution is to use Excel exclusively.
||(not a fan of Mathcad...I like it simple)
||
||> -----Original Message-----
||> From:	Bill Allen [SMTP:Bill(--nospam--at)AllenDesigns.com]
||> Sent:	Thursday, July 06, 2000 3:16 PM
||> To:	seaint(--nospam--at)seaint.org
||> Subject:	RE: Mathcad 2000 Question
||>
||> It would be nice if the instructions were clearer on how to
||pass variables
||> to an embedded Excel obect, have Excel do some work on it,
||then pass the
||>
||> Sigh...
||>
||> Bill Allen, S.E. (CA #2607)
||> ALLEN DESIGNS
||> Laguna Niguel, CA
||> http://www.AllenDesigns.com
||>
||> ||-----Original Message-----
||> ||From: Mark E. Deardorff [mailto:MarkD(--nospam--at)DandDEng.com]
||> ||Sent: Wednesday, July 05, 2000 1:10 PM
||> ||To: seaint(--nospam--at)seaint.org
||> ||Subject: RE: Mathcad 2000 Question
||>
||> <snip>
||> ||Alternatively you could use the Excel object embedded in a
||> ||and use the Excel functions indirectly.
||> ||
||> ||> -----Original Message-----
||> ||> From: Bill Polhemus [mailto:bpolhem(--nospam--at)swbell.net]
||> ||> Sent: Wednesday, July 05, 2000 11:51 AM
||> ||> To: seaint(--nospam--at)seaint.org
||> ||> Subject: Mathcad 2000 Question
||> ||>
||> ||>
||> ||> I'm looking for the analogue to the Excel "vlookup" and
||> ||> "hlookup" function as it
||> ||> (presumably) exists in Mathcad 2000.
||> ||>
||> ||> Anyone have a clue?
||> ||>
||> ||> Can't find anything in the docs!
||> ||>
||> ||> Thanks for your help.
||> ||
||> ||
||> ||******* ****** ******* ******** ******* ******* ******* ***
||> ||*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
||> ||*   This email was sent to you via Structural Engineers
||> ||*   Association of Southern California (SEAOSC) server. To
||> ||*   subscribe (no fee) to the list, send email to
||> ||*   admin(--nospam--at)seaint.org and in the body of the message type
||> ||*   "join seaint" (no quotes). To Unsubscribe, send email
||> ||*   to admin(--nospam--at)seaint.org and in the body of the message
||> ||*   type "leave seaint" (no quotes). For questions, send
||> ||*   email to seaint-ad(--nospam--at)seaint.org. Remember, any email you
||> ||*   send to the list is public domain and may be re-posted
||> ||*   site at: http://www.seaint.org
||> ||******* ****** ****** ****** ******* ****** ****** ********
||> ||
||>
||>
||> ******* ****** ******* ******** ******* ******* ******* ***
||> *   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
||> *   This email was sent to you via Structural Engineers
||> *   Association of Southern California (SEAOSC) server. To
||> *   subscribe (no fee) to the list, send email to
||> *   admin(--nospam--at)seaint.org and in the body of the message type
||> *   "join seaint" (no quotes). To Unsubscribe, send email
||> *   to admin(--nospam--at)seaint.org and in the body of the message
||> *   type "leave seaint" (no quotes). For questions, send
||> *   email to seaint-ad(--nospam--at)seaint.org. Remember, any email you
||> *   send to the list is public domain and may be re-posted
||> *   site at: http://www.seaint.org
||> ******* ****** ****** ****** ******* ****** ****** ********
||
||******* ****** ******* ******** ******* ******* ******* ***
||*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
||*   This email was sent to you via Structural Engineers
||*   Association of Southern California (SEAOSC) server. To
||*   subscribe (no fee) to the list, send email to
||*   admin(--nospam--at)seaint.org and in the body of the message type
||*   "join seaint" (no quotes). To Unsubscribe, send email
||*   to admin(--nospam--at)seaint.org and in the body of the message
||*   type "leave seaint" (no quotes). For questions, send
||*   email to seaint-ad(--nospam--at)seaint.org. Remember, any email you
||*   send to the list is public domain and may be re-posted
||*   site at: http://www.seaint.org
||******* ****** ****** ****** ******* ****** ****** ********
||

******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
*   This email was sent to you via Structural Engineers
*   Association of Southern California (SEAOSC) server. To
*   subscribe (no fee) to the list, send email to
*   admin(--nospam--at)seaint.org and in the body of the message type
*   "join seaint" (no quotes). To Unsubscribe, send email
*   to admin(--nospam--at)seaint.org and in the body of the message
*   type "leave seaint" (no quotes). For questions, send
*   email to seaint-ad(--nospam--at)seaint.org. Remember, any email you
*   send to the list is public domain and may be re-posted
*   site at: http://www.seaint.org
******* ****** ****** ****** ******* ****** ****** ********

******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
*   This email was sent to you via Structural Engineers
*   Association of Southern California (SEAOSC) server. To
*   subscribe (no fee) to the list, send email to
*   admin(--nospam--at)seaint.org and in the body of the message type
*   "join seaint" (no quotes). To Unsubscribe, send email
*   to admin(--nospam--at)seaint.org and in the body of the message
*   type "leave seaint" (no quotes). For questions, send
*   email to seaint-ad(--nospam--at)seaint.org. Remember, any email you
*   send to the list is public domain and may be re-posted