Likewise, Excel understands E notation but not D. For more on D format, see the Fortran standard on format specifications, www.fortran.com/fortran/F77_std/rjcnf0001-sh-13.html See section 13.5.9.2.2 on that web page. My understanding is that the D stands for "double" as in double precision.
----- Original Message ----- From: "John Leo Zimmer" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, January 23, 2005 11:49 AM Subject: Re: [Hardhats-members] Numbers for programs stored in Databases > DON't split the coefficient from the root. > Open Office Calc expresses the exponent with an "E" rather than "D". > I think that if you replace "D-" with "E-" and "D " with "E" the file would > import to Calc as a > tab delimited table. > > regards, > jlz > > ---------- Original Message ----------- > From: "Nancy E. Anthracite" <[EMAIL PROTECTED]> > To: [email protected] > Sent: Sun, 23 Jan 2005 08:48:13 -0500 > Subject: Re: [Hardhats-members] Numbers for programs stored in Databases > > > http://www.cdc.gov/growthcharts/data/1977coefficients2.txt > > > > If you click on the word "Coefficients" at the top of this page, > > there is a table with this sort of notation. > > > > I was going to pull it into a spreadsheet and I thought it might be > > easier to separate out the exponent rather than leave it there to be > > parsed out. That way when I exported it again, I could comma > > delimit it rather than "D" delimit it. > > > > I was wondering why it was done that way. Greg probably has the answer. > > > > On Saturday 22 January 2005 11:34 pm, Greg Kreis wrote: > > > I am not sure of what you are asking. Are you referring to this? > > > > > > >w .24e-2 > > > > > > .0024 > > > > > > Nancy E. Anthracite wrote: > > > >Is it fairly typical to provide numbers in a format with a D followed by > > > >a > > > >power of 10, i.e. 0.2400000D-02 is really .00240000, for entry into > > > >databases to be parsed and used by programs? If it is, is the D-02 > > > > portion usually provided in the same piece of data or "cell" or whatever > > > > you want to call it, or in a different, perhaps adjoining, cell? > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting > Tool for open source databases. Create drag-&-drop reports. Save time > by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. > Download a FREE copy at http://www.intelliview.com/go/osdn_nl > _______________________________________________ > Hardhats-members mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ Hardhats-members mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hardhats-members
