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
