UOAM Houses.map data Updated 17 Jan 2018

I quickly counted 51 and didn't even scroll to Minoc / Vesper / Dagger

Its pretty damn accurate

I would never have guessed that many forts exist.

Great stuff, thanks!

Can you post your formula to correct that offset? I've tried to find a pattern, but I gave up after 5 mins

Nevermind, I figured it out

2700 homes for 300 active accounts, haha, what a joke.

In case anyone is interested in how to correct the http://www.uorenaissance.com/map/house.txt for displaying in UOAM

- New MS Excel workbook (or Google Sheets)
- Name one of the sheets "OffsetData" and paste the following data (3 columns, A to C)

+castle: 1 11
+fortress: 1 11
+keep: 1 6
+large house: 0 2
+log cabin: 1 0
+marble patio: -3 -1
+marble shop: -2 -4
+patio house: -3 2
+sandstone patio: -1 -1
+small house: 0 -1
+small tower: 3 -1
+stone shop: -2 -4
+tower: 1 2
+two story house: -2 2
+villa: 4 -3

- Paste the raw data from http://www.uorenaissance.com/map/house.txt in column A of a different sheet (all data should be in one column, no splitting into columns)
- Paste the below formula in column B

=MID($A1,1,SEARCH(":",$A1,1))&" "&MID(MID($A1,SEARCH(":",$A1,1)+2,LEN($A1)),1,FIND("~",SUBSTITUTE(MID($A1,SEARCH(":",$A1,1)+2,LEN($A1))," ","~",1))-1)+VLOOKUP(MID($A1,1,SEARCH(":",$A1,1)),OffsetData!$A$1:$C$15,2)&" "&MID(MID($A1,SEARCH(":",$A1,1)+2,LEN($A1)),FIND("~",SUBSTITUTE(MID($A1,SEARCH(":",$A1,1)+2,LEN($A1))," ","~",1))+1,FIND("~",SUBSTITUTE(MID($A1,SEARCH(":",$A1,1)+2,LEN($A1))," ","~",2))-FIND("~",SUBSTITUTE(MID($A1,SEARCH(":",$A1,1)+2,LEN($A1))," ","~",1))-1)+VLOOKUP(MID($A1,1,SEARCH(":",$A1,1)),OffsetData!$A$1:$C$15,3)&" "&MID(MID($A1,SEARCH(":",$A1,1)+2,LEN($A1)),FIND("~",SUBSTITUTE(MID($A1,SEARCH(":",$A1,1)+2,LEN($A1))," ","~",2))+1,3)

And on column B you got yourself the corrected data that you can paste into your UOAM houses.map file (remember to keep the lonely "3" at the first line of the houses.map)

I haven't tested the corrected data extensively, and the offset data per house type could be incorrect, as there are a few subtypes -let me know if you find any inconsistencies. The formula can be simplified using intermediate columns, and probably a better choice of functions, but that's all I could come up with in some free time I had in the afternoon -feel free to improve it.

I concatenate too make life easier

=MID(A1,1,FIND(":",A1,1))

=MID(A1,(FIND(":",A1,1)+1),5)

=MID(A1,(FIND(" ",A1,(FIND(":",A1,1)+2))),R1)

x:
=IF(D1="+small house:",F1+0,IF(D1="+marble shop:",F1-2,IF(D1="+stone shop:",F1-2,IF(D1="+small tower:",F1+3,IF(D1="+sandstone patio:",F1-1,IF(D1="+log cabin:",F1+1,IF(D1="+villa:",F1+4,IF(D1="+large house:",F1+0,IF(D1="+patio house:",F1-3,IF(D1="+marble patio:",F1-3,IF(D1="+two story house:",F1-2,IF(D1="+tower:",F1+1,IF(D1="+keep:",F1+1,IF(D1="+castle:",F1+1,IF(D1="+fortress:",F1+1,"n")))))))))))))))

y:
=IF(D1="+small house:",G1-1,IF(D1="+marble shop:",G1-4,IF(D1="+stone shop:",G1-4,IF(D1="+small tower:",G1-1,IF(D1="+sandstone patio:",G1-1,IF(D1="+log cabin:",G1+0,IF(D1="+villa:",G1-3,IF(D1="+large house:",G1+2,IF(D1="+patio house:",G1+2,IF(D1="+marble patio:",G1-1,IF(D1="+two story house:",G1+2,IF(D1="+tower:",G1+2,IF(D1="+keep:",G1+6,IF(D1="+castle:",G1+11,IF(D1="+fortress:",G1+11,"n")))))))))))))))

=CONCATENATE(D1," ",H1," ",I1," ",1)

Yeah, like I said the formula is simpler with intermediate columns. I started with that concatenation model (but with the & operator) but then changed to one column formula -I kinda like less columns even though the formula turns into a cryptic monster. I may go back to multiple columns as it may be useful for sorting houses by coordinates.

This by the way is an interesting tool for finding open housing spots.