Fixed a typo. It had the elevation values negated before. So if you downloaded before 3/22/05 get it again
What it does:
creates an excel document that looks like the picture below. Has each number separated into 3 different columns
A=X coordinate
B=Z coordinate
C=Y coordinate
Places 3 rows at the end
Zonerect:calculated based on the /locs in the logfile.
Elevation (Highest):Highest elevation found
Elevation (Lowest):Lowest elevation found
(Elevation used for multi-floor maps)
How to use it:
01)Put the logfile in the same directory as the script (or be prepared to type full path info)
02) Run the script
03) Type in the INPUT filename (your raw eq2 log)
04) Type in the OUTPUT filename (the data to import into Excel)
05) Open Excel
06) Go to Data->Import External Data->Import Data
07) Find and open the OUTPUT file
08) Check the Delimited Option, say NEXT (not finish)
09) Click in the OTHER field, type in
%
10) Click Finish, OK
How it does it:
1) Removes all lines that dont have
your location is
2) Removes everything before the coordinate in each line
3) Removes everything after the coordinates in each line
4) Replaces
, with %
5) Adds the formula for the zonerect finder at the bottom
6) Saves the results into an external file, never writing to the original logfile