EQ2Interface.com
Search Downloads


Go Back   EQ2Interface > Utilities

Category: Utilitieseq2log XYZ + Zonerect + Elevation Extractor
Interface Information
Download
tonyis3l33t's Portal Bug Reports Feature Requests
How do I install this? (FAQ)
Name: eq2log XYZ + Zonerect + Elevation Extractor   Popular!
Author:
Date: 02-14-2005 02:17 AM
Size: 9.32 Kb
Version: N/A
Rate Addon: 5 out of 5 with 3 votes  
Pictures
Click to enlarge 

Views: 5157
Size: 9.15 Kb
Dimensions: 324 x 566
Example Output
 
Description
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



File Statistics
User Rating:
5 out of 5 with 3 votes
Downloads: 7917
Views: 32048
Favorites: 1
Uploaded By:
 
Last Modified: 03-22-2005 03:32 PM by tonyis3l33t    

View Pictures. Download Now! Post A Comment


Post A Reply
Author Comments Comment Options
Unread 05-02-2005, 12:50 AM  
diztorded
Crushbone - Cronique
 
diztorded's Avatar
Interface Author - Click to view interfaces

Server: Crushbone
Forum posts: 163
File comments: 6
Uploads: 1
[HowTo] Importing into Open Office

Save the output file as a *.txt.

Start Open Office.

Click File then Open.

Change files of type to: Text CSV

Select your output file and click open.

Under Seperator options, deselect TAB, select OTHER and put in %

Click OK.

Your done!

Last edited by diztorded : 05-02-2005 at 12:56 AM.
diztorded is offline Report comment to moderator   Reply With Quote Reply With Quote
Unread 03-28-2005, 05:11 AM  
tonyis3l33t
a hedgehog
 
tonyis3l33t's Avatar
Interface Author - Click to view interfaces

Server: Nagafen
Forum posts: 854
File comments: 43
Uploads: 22
Re: What is it used for ?

This is meant for people who make maps.
tonyis3l33t is offline Report comment to moderator   Reply With Quote Reply With Quote
Unread 03-28-2005, 12:27 AM  
IsmeldaLasombra
A Young Mystail Rat

Server: Antonia Bayle
Forum posts: 4
File comments: 13
Uploads: 0
What is it used for ?

I see some potential in but can't understand how you use it just that way.

I do not draw maps so maybe you use it for that ?

Please explain the idea behind this.
IsmeldaLasombra is offline Report comment to moderator   Reply With Quote Reply With Quote
Post A Reply

 
Category Jump:
Search this Category:
 

All times are GMT -5. The time now is 03:55 PM.


Our Network
EQInterface | EQ2Interface | WoWInterface | LoTROInterface | ESOUI | MMOUI