Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

RE: Mathcad - Converting Excel to Mathcad: Best Practices

[Subject Prev][Subject Next][Thread Prev][Thread Next]
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(--nospam--at)CH2M.com [mailto:William.Sherman(--nospam--at)CH2M.com] 
> Sent: Friday, November 02, 2007 12:00 PM
> To: seaint(--nospam--at)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(--nospam--at)ci.concord.ca.us] 
> Sent: Friday, November 02, 2007 12:11 PM
> To: 'seaint(--nospam--at)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(--nospam--at)CH2M.com [mailto:William.Sherman(--nospam--at)CH2M.com]
> > Sent: Friday, November 02, 2007 8:48 AM
> > To: seaint(--nospam--at)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(--nospam--at)ci.concord.ca.us]
> > Sent: Friday, November 02, 2007 9:43 AM
> > To: 'seaint(--nospam--at)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(--nospam--at)insightts.net]
> > > Sent: Thursday, November 01, 2007 7:42 PM
> > > To: seaint(--nospam--at)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(--nospam--at)ci.richmond.ca.us>
> > > To: <seaint(--nospam--at)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(--nospam--at)umich.edu]
> > > Sent: Thursday, November 01, 2007 12:07 PM
> > > To: seaint(--nospam--at)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(--nospam--at)poa02.usace.army.mil]
> > > Sent: Thursday, November 01, 2007 2:24 PM
> > > To: seaint(--nospam--at)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(--nospam--at)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(--nospam--at)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(--nospam--at)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(--nospam--at)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(--nospam--at)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(--nospam--at)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(--nospam--at)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(--nospam--at)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(--nospam--at)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 
******* ****** ****** ****** ******* ****** ****** ********