Friday, November 2, 2007

RE: Mathcad - Converting Excel to Mathcad: Best Practices

Here is an article regarding converting Excel to Mathcad:


http://www.mathcad.com/support/item/06jan_es.asp


Suresh Acharya, S.E.

> -----Original Message-----
> From: William.Sherman@CH2M.com [mailto:William.Sherman@CH2M.com]
> Sent: Friday, November 02, 2007 12:00 PM
> To: seaint@seaint.org
> Subject: RE: Mathcad
>
>
> The formulas in Excel won't convert but I believe that you
> can either have a dynamic link to an external Excel
> spreadsheet or you can just import the numerical values into
> a table. I've read about it but haven't tried it myself.
>
> Bill Sherman
> CH2M HILL / DEN
> 720-286-2792
>
> -----Original Message-----
> From: Acharya, Suresh [mailto:Suresh.Acharya@ci.concord.ca.us]
> Sent: Friday, November 02, 2007 12:11 PM
> To: 'seaint@seaint.org'
> Subject: RE: Mathcad
>
> Did you mean 'importing' Excel spreadsheet using OLE (Object
> Linking and Embedding), or converting Excel spreadsheet to
> native Mathcad spreadsheet.
>
> Suresh Acharya, S.E.
>
>
> > -----Original Message-----
> > From: William.Sherman@CH2M.com [mailto:William.Sherman@CH2M.com]
> > Sent: Friday, November 02, 2007 8:48 AM
> > To: seaint@seaint.org
> > Subject: RE: Mathcad
> >
> >
> > MathCAD worksheets can import Excel spreadsheets - there should be a
> > help file on their website or in their Help files to explain this.
> > There are 2 or 3 options, depending upon your intent for file
> > interaction.
> >
> > Bill Sherman
> > CH2M HILL / DEN
> > 720-286-2792
> >
> > -----Original Message-----
> > From: Acharya, Suresh [mailto:Suresh.Acharya@ci.concord.ca.us]
> > Sent: Friday, November 02, 2007 9:43 AM
> > To: 'seaint@seaint.org'
> > Subject: RE: Mathcad
> >
> > Has anybody used MathCAD APIs to customize MathCAD spreadsheets?
> >
> > As of the previous versions, I found the MathCAD APIs available to
> > developers were very my much limited and severely
> restricted. MathCAD
> > spreadsheet, as it is, is great, but not adequate to do all sort of
> > structural calculations.
> >
> > I doubt MathCAD and Excel talk to each other at all.
> >
> > Suresh Acharya, S.E.
> >
> >
> >
> > > -----Original Message-----
> > > From: Alex C. Nacionales [mailto:anacionales@insightts.net]
> > > Sent: Thursday, November 01, 2007 7:42 PM
> > > To: seaint@seaint.org
> > > Subject: Re: Mathcad
> > >
> > >
> > > Yes, Mathcad can use data files. Mathcad can load a data file like
> > > axial loads and moments of a structure taken from an
> > analysis program
> > > then design the footings,columns using these data and formulas
> > > created in Mathcad.
> > >
> > > Alex Nacionales
> > > ----- Original Message -----
> > > From: "Gautam Manandhar" <Gautam_Manandhar@ci.richmond.ca.us>
> > > To: <seaint@seaint.org>
> > > Sent: Friday, November 02, 2007 3:24 AM
> > > Subject: RE: Mathcad
> > >
> > >
> > > Can anyone discuss the ease of ( if possible) of importing
> > data files
> > > and worksheets from Excel.
> > >
> > > gautam
> > >
> > > -----Original Message-----
> > > From: Scott Maxwell [mailto:smaxwell@umich.edu]
> > > Sent: Thursday, November 01, 2007 12:07 PM
> > > To: seaint@seaint.org
> > > Subject: RE: Mathcad vs. Matlab
> > >
> > > I would say MathCAD is likely more useful...unless you are doing
> > > stiffness method by hand and need to do manipulation of large
> > > matricies and lots of matrix math. MathCAD allows for graphical
> > > calculation sheets (i.e. you can create functional forumula
> > that are
> > > visible). This of Excel to some degree except all the
> forumlas are
> > > visable and function...not hidden in cells). Matlab is
> > primarily aimed
> >
> > > at doing serious matix math, but can do "regular" math
> too...but is
> > > not as graphical (i.e. see the formulas) as MathCAD...at
> least the
> > > last time I used it.
> > >
> > > Regards,
> > >
> > > Scott
> > > Adrian, MI
> > >
> > > -----Original Message-----
> > > From: Haan, Scott M POA [mailto:Scott.M.Haan@poa02.usace.army.mil]
> > > Sent: Thursday, November 01, 2007 2:24 PM
> > > To: seaint@seaint.org
> > > Subject: Mathcad vs. Matlab
> > >
> > >
> > > Is Mathcad or Matlab more useful for structural engineering? I
> > > haven't used either, what is the difference?
> > >
> > > ******* ****** ******* ******** ******* ******* ******* ***
> > > * 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) or UnSubscribe, please go to:
> > > *
> > > *

http://www.seaint.org/sealist1.asp
> > > *
> > > * Questions to seaint-ad@seaint.org. Remember, any email you
> > > * send to the list is public domain and may be re-posted
> > > * without your permission. Make sure you visit our web
> > > * 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) or UnSubscribe, please go to:
> > > *
> > > *

http://www.seaint.org/sealist1.asp
> > > *
> > > * Questions to seaint-ad@seaint.org. Remember, any email you
> > > * send to the list is public domain and may be re-posted
> > > * without your permission. Make sure you visit our web
> > > * 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) or UnSubscribe, please go to:
> > > *
> > > *

http://www.seaint.org/sealist1.asp
> > > *
> > > * Questions to seaint-ad@seaint.org. Remember, any email you
> > > * send to the list is public domain and may be re-posted
> > > * without your permission. Make sure you visit our web
> > > * 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) or UnSubscribe, please go to:
> > > *
> > > *

http://www.seaint.org/sealist1.asp
> > > *
> > > * Questions to seaint-ad@seaint.org. Remember, any email you
> > > * send to the list is public domain and may be re-posted
> > > * without your permission. Make sure you visit our web
> > > * 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) or UnSubscribe, please go to:
> > *
> > *

http://www.seaint.org/sealist1.asp
> > *
> > * Questions to seaint-ad@seaint.org. Remember, any email you
> > * send to the list is public domain and may be re-posted
> > * without your permission. Make sure you visit our web
> > * 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) or UnSubscribe, please go to:
> > *
> > *

http://www.seaint.org/sealist1.asp
> > *
> > * Questions to seaint-ad@seaint.org. Remember, any email you
> > * send to the list is public domain and may be re-posted
> > * without your permission. Make sure you visit our web
> > * 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) or UnSubscribe, please go to:
> *
> *

http://www.seaint.org/sealist1.asp
> *
> * Questions to seaint-ad@seaint.org. Remember, any email you
> * send to the list is public domain and may be re-posted
> * without your permission. Make sure you visit our web
> * 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) or UnSubscribe, please go to:
> *
> *

http://www.seaint.org/sealist1.asp
> *
> * Questions to seaint-ad@seaint.org. Remember, any email you
> * send to the list is public domain and may be re-posted
> * without your permission. Make sure you visit our web
> * 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) or UnSubscribe, please go to:
*
*

http://www.seaint.org/sealist1.asp
*
* Questions to seaint-ad@seaint.org. Remember, any email you
* send to the list is public domain and may be re-posted
* without your permission. Make sure you visit our web
* site at: http://www.seaint.org

******* ****** ****** ****** ******* ****** ****** ********