Maptitude - http://research.umbc.edu/~roswell/maptitude.html
Dear Maptituders: I am VERY sorry I sent ALL of you an attachment. I meant
to send it to only one of you, and didn't think. Its not secret data or
anything, but just dump the email message; I hope I did not nail anyone's
mail server.
Again, I apologize. Then again if you can fix the formatting problem, help
yourself.
Again, sorry ...
Richard Hoskins
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
GMT -8
-----Original Message-----
From: Michael K. LaRue [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 7:59 AM
To: Maptitude
Subject: RE: [Maptitude] Reading an Excel file into Maptitude
Maptitude - http://research.umbc.edu/~roswell/maptitude.html
What version of Mapt are you using? I just tried it (made a one-record
.xls file with default Excel column & row settings) and it imported
properly in Mapt 4.1 (at least, the version of 4.1 I'm using).
If the Excel file is not too big and if it does not contain any
sensitive or proprietary data, you might send it to me as an attachment
to a private email & I'd be happy to look more closely. A copied
fragment would likely work as well.
-----Original Message-----
From: Health Maps [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 9:55 AM
To: Maptitude
Subject: RE: [Maptitude] Reading an Excel file into Maptitude
Maptitude - http://research.umbc.edu/~roswell/maptitude.html
I read it into Mapt directly as an xls, it asks me which sheet of the
workbook I want to use and then asks for a name of the resulting dbf
file.
The columns are formatted as number with 6 decimal places. But the
resulting
file in mapt has only 2 decimal places.
Richard Hoskins
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
GMT -8
-----Original Message-----
From: Michael K. LaRue [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 7:41 AM
To: Maptitude
Subject: RE: [Maptitude] Reading an Excel file into Maptitude
Maptitude - http://research.umbc.edu/~roswell/maptitude.html
How do you go about "reading it into Maptitude"? Do you open it as an
Excel (.xls) file, or do you first save in another format (such as Dbase
(.dbf))? Are the rows in the Excel table formatted as "number" with
decimals set to 6 places, or are they the default format?
-----Original Message-----
From: Health Maps [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 9:37 AM
To: Maptitude
Subject: [Maptitude] Reading an Excel file into Maptitude
Maptitude - http://research.umbc.edu/~roswell/maptitude.html
I have an Excel file with longs and lats (death records) with 6 decimal
places.
When I read it into Maptitude the resulting dbf that is then used to
make the point map, has been rounded off the numbers to 2 decimal
places. Sometimes is works, often it doesn't. Looking at the Modify
Table dialogue there are only 2 decimals there. How do I reliably avoid
this? I tend to go back and re-format the xls file columns with the long
and lat (usually they are the way I want them already), but its not
clear what the real problem is. The columns are wide enough (not a dbf
clipping of decimals because they are hidden)
Thanks
Richard Hoskins
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
GMT -8
_____
To unsubscribe, write to [EMAIL PROTECTED]
______________________________________________________________________
To unsubscribe, write to [EMAIL PROTECTED]
______________________________________________________________________
To unsubscribe, write to [EMAIL PROTECTED]
______________________________________________________________________
To unsubscribe, write to [EMAIL PROTECTED]
______________________________________________________________________
To unsubscribe, write to [EMAIL PROTECTED]
