Need a book? Engineering books recommendations...

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

RE: Mathcad and or Excel

[Subject Prev][Subject Next][Thread Prev][Thread Next]
In Excel, you can take one of your spreadsheets that you used multiple times
and reveal all the formulas so that plan checker or reviewer can check the
formulas easier.  To expose the formulas in Excel, go to  TOOLS on the top
menu bar, then click on OPTIONS whcih is at the bottom of the list, then
click on the VIEW tab, then click in the FORMULAS box by the bottom left
corner.  Now all the formulas are revealed.

I have never used Mathcad, but I sure love Excel.

Mike O'Brien, P.E.

> -----Original Message-----
> From: Sherman, William [mailto:ShermanWC(--nospam--at)]
> Sent: Thursday, August 12, 1999 12:16 PM
> To: 'seaint(--nospam--at)'
> Subject: RE: Mathcad and or Excel
> More than just "better looking" calc sheets, Mathcad calc
> sheets help avoid
> errors and should save time in checking calcs.  I've used
> Excel alot in the
> past, but I always require that the formula used be hand typed in an
> adjacent cell so that the hard copy includes a formula and
> the result.  The
> problem is that the typed formula may not always match the
> cell formula.  I
> recently did a spreadsheet where I copied a column of
> formulas to adjacent
> columns for repetitive calculations - but I later discovered
> that I had
> accidentally entered hard numbers in two cells such that they
> overwrote the
> hidden formulas and the results were in error.  This was not
> obvious when
> looking at the spreadsheet.  In Mathcad, the actual formula
> can be seen and
> checked directly.  Thus I am trying to transition from Excel
> to Mathcad, but
> it takes some time to develop new templates.
> > -----Original Message-----
> > From: Joseph Harouni [mailto:yosi_h(--nospam--at)]
> > Sent: Thursday, August 12, 1999 10:58 AM
> > To: seaint(--nospam--at)
> > Subject: Mathcad and or Excel
> >
> >
> > Hi,
> > I see lots of us are using Mathcad for Calc Sheets. I used to
> > use version 5
> > of Mathcad but switched to Excel for its power of
> calculating against
> > Mathcad. Besides better looking calc sheets does Mathcad have
> > any advantages
> > over Excel?
> > Thanks,
> > Joseph Harouni