UOAM Houses.map data Updated 17 Jan 2018

Discussion in 'Renaissance Discussion' started by Erlkonig, Jul 24, 2016.

  1. Erlkonig

    Erlkonig Well-Known Member
    UO:R Subscriber

    Joined:
    Jun 14, 2015
    Messages:
    1,131
    Likes Received:
    1,165
    I quickly counted 51 and didn't even scroll to Minoc / Vesper / Dagger

    Its pretty damn accurate
  2. Ruck

    Ruck Well-Known Member
    UO:R Subscriber

    Joined:
    May 5, 2013
    Messages:
    1,221
    Likes Received:
    601
    I would never have guessed that many forts exist.
  3. dissident

    dissident Active Member
    UO:R Subscriber

    Joined:
    May 25, 2014
    Messages:
    479
    Likes Received:
    162
    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 :p
  4. dissident

    dissident Active Member
    UO:R Subscriber

    Joined:
    May 25, 2014
    Messages:
    479
    Likes Received:
    162
    Nevermind, I figured it out
  5. FreeHugger

    FreeHugger Well-Known Member

    Joined:
    Jun 3, 2017
    Messages:
    1,029
    Likes Received:
    710
    2700 homes for 300 active accounts, haha, what a joke.
  6. dissident

    dissident Active Member
    UO:R Subscriber

    Joined:
    May 25, 2014
    Messages:
    479
    Likes Received:
    162
    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.
  7. Erlkonig

    Erlkonig Well-Known Member
    UO:R Subscriber

    Joined:
    Jun 14, 2015
    Messages:
    1,131
    Likes Received:
    1,165
    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)

    upload_2018-4-1_12-39-25.png
  8. dissident

    dissident Active Member
    UO:R Subscriber

    Joined:
    May 25, 2014
    Messages:
    479
    Likes Received:
    162
    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.

Share This Page