Basara
UO Forum Moderator
Moderator
Professional
Governor
Stratics Veteran
Stratics Legend
Wiki Moderator
UNLEASHED
Campaign Supporter
Creating a custom .map file for UOC/UOAM for SOS fishing (now as a google doc!)
OK, I've made a Google Documents version of the OpenOffice file, and set it for anyone to access it.
Welcome to Google Docs
I've also recreated an Excel version of the file; I'm gonna check on getting the Excel & OO versions hosted as downloads with Stratics.
Update: For Ultima Mapper, the procedure is as below, but then you have to import the .map file you put the list of markers in, into UM with its import marker tool. I've not had a chance to test the importation process, though, as last I ran UM I was still having the "not following the character" bug. (of course, I've just done a full reinstall on my computer and haven't got around to reinstalling any of the map programs yet).
The following is a corrected repost from 2007 (from another stratics forum), and is essentially recreating data lost in 2008, from posts much earlier in the decade. Thanks to GreywolfUK for pointing out the coding difference between OpenOffice and Excel
The following data will allow you to create a spreadsheet in OpenOffice or Excel to make the raw data to plug into a UOC or UOAM .map file, to plot your SOS.
You type in the Lat/Long, it converts them to code needed for UOAM & UOC (which is text), then you copy and paste the column of info into a .map file (a new one or existing one). Someone made it a long time ago for the FCB.
The file was originally written for Excel, but my current version was saved as an OpenOffice Calc file. I do know that I couldn't get pre-XP versions of Corel Quattro to convert the original Excel data into a working form, which sucks, as I prefer using it (it's what my college in the 90s taught their freshmen intro to computers in, plus it was a free program for me - Microsoft Office cost - and still costs - WAY too much). Anyone want to help me get a version of this to work in Quattro 8?
Setup:
Here's the constant data to start with, that should be in rows 1-4, Columns A-C (LB throne data in A2, B2; World Size in A3,B3; Tiles data in A4,B4 - the y & x for illustrative purposes were in a1 & b1) The commas are there just to show division between columns (like in a CSV file). you do NOT enter them.
yx
1624,1323, :LB Throne
4096,5120, :World Size
11.4,14.2, :Tiles per degree
Now, Row 6 Is the header, of sorts for your data conversion table
As before, the commas are there to show the division of columns - and (Empty) means the column is used as a spacer - don't put anything into it.
A,B,C,D,E,F, G (Empty), H,I, J(Empty), K
y deg,y min,y N/S, x deg,x min,x E/W,(empty),x,y, (empty), .map file (copy and paste)
Row 7 and lower (make Row 7, then copy down)
Columns A-F are where you will enter data, as you go along. You might want to put zeros into them, to keep the program happy, while you input the formulas in Columns H, I & K.
Column G (and Column J) will be empty
Column H should be as follows (note that the Row 7 reference will change as you paste downward, for the other rows). There are different versions for OO & Excel, due to the programs suing slightly different coding (one uses a semicolon where the other uses a comma)
Open Office Version:
Excel Version
Open Office Version
Excel Version
Open Office Version
Excel Version
1. Open a file with notepad
2. the first line in the file is a "3" (just the number 3, no quotes or anything)
Then, starting with K7, down to where you last entered data, copy Column K, and paste it in the file as lines 2 to whatever.
OK, I've made a Google Documents version of the OpenOffice file, and set it for anyone to access it.
Welcome to Google Docs
I've also recreated an Excel version of the file; I'm gonna check on getting the Excel & OO versions hosted as downloads with Stratics.
Update: For Ultima Mapper, the procedure is as below, but then you have to import the .map file you put the list of markers in, into UM with its import marker tool. I've not had a chance to test the importation process, though, as last I ran UM I was still having the "not following the character" bug. (of course, I've just done a full reinstall on my computer and haven't got around to reinstalling any of the map programs yet).
The following is a corrected repost from 2007 (from another stratics forum), and is essentially recreating data lost in 2008, from posts much earlier in the decade. Thanks to GreywolfUK for pointing out the coding difference between OpenOffice and Excel
The following data will allow you to create a spreadsheet in OpenOffice or Excel to make the raw data to plug into a UOC or UOAM .map file, to plot your SOS.
You type in the Lat/Long, it converts them to code needed for UOAM & UOC (which is text), then you copy and paste the column of info into a .map file (a new one or existing one). Someone made it a long time ago for the FCB.
The file was originally written for Excel, but my current version was saved as an OpenOffice Calc file. I do know that I couldn't get pre-XP versions of Corel Quattro to convert the original Excel data into a working form, which sucks, as I prefer using it (it's what my college in the 90s taught their freshmen intro to computers in, plus it was a free program for me - Microsoft Office cost - and still costs - WAY too much). Anyone want to help me get a version of this to work in Quattro 8?
Setup:
Here's the constant data to start with, that should be in rows 1-4, Columns A-C (LB throne data in A2, B2; World Size in A3,B3; Tiles data in A4,B4 - the y & x for illustrative purposes were in a1 & b1) The commas are there just to show division between columns (like in a CSV file). you do NOT enter them.
yx
1624,1323, :LB Throne
4096,5120, :World Size
11.4,14.2, :Tiles per degree
Now, Row 6 Is the header, of sorts for your data conversion table
As before, the commas are there to show the division of columns - and (Empty) means the column is used as a spacer - don't put anything into it.
A,B,C,D,E,F, G (Empty), H,I, J(Empty), K
y deg,y min,y N/S, x deg,x min,x E/W,(empty),x,y, (empty), .map file (copy and paste)
Row 7 and lower (make Row 7, then copy down)
Columns A-F are where you will enter data, as you go along. You might want to put zeros into them, to keep the program happy, while you input the formulas in Columns H, I & K.
Column G (and Column J) will be empty
Column H should be as follows (note that the Row 7 reference will change as you paste downward, for the other rows). There are different versions for OO & Excel, due to the programs suing slightly different coding (one uses a semicolon where the other uses a comma)
Open Office Version:
Code:
[/SIZE]
[SIZE=3]=INT(MOD(IF(F7="w";$B$2-(E7/60)*$B$4-D7*$B$4;$B$2+(E7/60)*$B$4+D7*$B$4);$B$3))
Code:
[/SIZE]
[SIZE=3][SIZE=2][FONT=Arial]=INT(MOD(IF(F7="w",$B$2-(E7/60)*$B$4-D7*$B$4,$B$2+(E7/60)*$B$4+D7*$B$4),$B$3))[/FONT][/SIZE]Column I should be as follows
Open Office Version
Code:
[LEFT]=MOD(INT(IF(C7="n";$A$2-(B7/60)*$A$4-A7*$A$4;$A$2+(B7/60)*$A$4+A7*$A$4));$A$3)[/LEFT][/SIZE]
[SIZE=3]
Code:
[/SIZE]
[SIZE=3][FONT=Arial]=MOD(INT(IF(C7="n",$A$2-(B7/60)*$A$4-A7*$A$4,$A$2+(B7/60)*$A$4+A7*$A$4)),$A$3)[/FONT]Column K should be as follows
Open Office Version
Code:
="+treasure: "&H7&" "&I7&" 2 SOS"
Code:
="+treasure: "&H7&" "&I7&" 2 SOS"Save your file. Make it read-only (As you don't want to have to rebuild this over and over from mistakes). After all, the data is gonna be pasted over to the map file, then written over the next time you use the spreadsheet. If you feel you must save every entry session, then just "save as" each file with the day's date added, leaving the original read-only.
Making the .MAP file
When it becomes time to build your sos.map file, do the following:
1. Open a file with notepad
2. the first line in the file is a "3" (just the number 3, no quotes or anything)
Then, starting with K7, down to where you last entered data, copy Column K, and paste it in the file as lines 2 to whatever.
Save it, and FORCE the damn thing to save as a .map file without a ,TXT extension. To do this, you might have to open a different .map file, save it as sos.mib (or whatever name you choose), empty out this new copy, then put the 3 and the pasted material in.
You will be saving this into the folder for UOC or UOAM. As this will be in your program folder, some people will have difficulty from Vista & Win7 being an ass about letting you alter files in your program folders manually. As I'm still using XP, that's out of my league - ask people over in UO Tech.
Once the file is created, you will then probably have to go into your map program's "Options" (try right-clicking on the program while its running) and make sure that your "sos" file is checked, to have the points display.
As you fish up your SOS, once you make sure that you don't have two so close that they show up as one point, right click on the used point, and delete it (or edit it to indicate it has been completed, if you want to look for the non-existent patterns some have claimed exist).
The next time you use your spreadsheet, just input the new SOS data over the old data, and when you paste, open the existing sos.map file, and paste the column K data at the bottom of any remaining map data.
[/code][/SIZE]
