Need a book? Engineering books recommendations...

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

RE: Excel equations *was Calculation Software

[Subject Prev][Subject Next][Thread Prev][Thread Next]
In another spread sheet cell:
=Disfor.xls!disfor(C6)

If the spreadsheet is not in the same folder with the Disfor.xls then you
may need to add the directory reference.



Ronald A. Hill, P.E.
HILL Consulting Engineering
PO BOX 26525
Birmingham, Alabama 35260 USA
Phone: 205-823-4784
FAX: 205-823-4145
email: ronhill(--nospam--at)hillce.com
Messenger: ronhill(--nospam--at)hillce.com
http://www.hillce.com


-----Original Message-----
From: Jeremy South [mailto:jslist(--nospam--at)jenkins-engineering.com] 
Sent: Thursday, July 15, 2004 1:01 PM
To: seaint(--nospam--at)seaint.org
Subject: Re: Excel equations *was Calculation Software


I just sent Mark Johnson an email asking the same thing. I haven't been able
to figure it out yet either.

Jeremy South, EI, LSI

----- Original Message -----
From: "Joseph Harouni" <jharouni(--nospam--at)sbcglobal.net>
To: <seaint(--nospam--at)seaint.org>
Sent: Thursday, July 15, 2004 12:43
Subject: Re: Excel equations *was Calculation Software


> Hi,
> Anyone has figured out how to import Disfor() into a calc sheet 
> already created? Thanks,
> Joseph Harouni
> On Jul 14, 2004, at 7:35 PM, Markajohn(--nospam--at)cs.com wrote:
>
> > Kevin,
> >
> > Awesome!  That's the Holy Grail!  If I can figure out how to import 
> > that function to other excel files, I'll never think about MathCAD 
> > again!
> >
> > Mark Johnson
> >
> > In a message dated 7/14/04 5:48:28 PM Pacific Daylight Time, 
> > kevinbelow(--nospam--at)videotron.ca writes:
> >
> >> The freeware disfor() function in Excel is great for showing the 
> >> actual  figures in a calculation.
> >>
> >>  The Disfor() function will convert any referenced address of the 
> >> formula  in the cell to their respective value, and display the 
> >> formula with the
> >>  respective values. If value in the displayed formula contain 'Empty',
> >>  'Null', 'Error' or 'String', then the formula contains non numeric
> >>  values or invalid reference.
> >>
> >>
> >>  HYPERLINK
> >>
> >> "http://www.geocities.com/SiliconValley/Hills/1829/VBA/
> >> disfor.htm"http:/  
> >> /www.geocities.com/SiliconValley/Hills/1829/VBA/disfor.htm
> >>
> >>
> >>  Kevin Below, ing., Ph.D.
> >>
> >
> > ******* ****** ******* ******** ******* ******* ******* ***
> > *   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 
******* ****** ****** ****** ******* ****** ****** ********