As a search option or visible data? Definitely adding a column, and possibly a search option.
Initially, I was thinking a column (for those of us viewing all three cities), but I could see a lot of people limiting their searches by city.
Yes, I actually kind of planned on just converting all prices to kronar and leaving raw prices available as the secondary option, maybe in a mouse over or hidden column.
I like the mouse-over idea.
Good point, I planned on adding a 'directions' blurb for each store with the lich room number, I can add room name and genie room number if we get our hands on those.
You don't need a room # for the Genie rooms, as they are all labeled by room name. (That is, you can type #goto followed by the first few letters of the room name.) Using the room name instead of the Genie number will also make the list more user-friendly for people who don't use Genie.
Here are all of the rooms that may contain shops (in the order my spreadsheet uses):
Crossing's Market Plaza (Map1j_Market_Plaza)
Sun Room: 3
Water Room: 4
Grass Room: 5
Solarium: 6
Forest Room: 8
Dimly-Lit Storage: 9
Meeting Room: 10
Moon Room: 11
Armor Room: 12
Lodge Room: 13
Gladiolus Room: 14
Fire Room: 15
Library: 16
Volcano Room: 35
Palm Room: 36
Ocean Room: 37
Tundra Room: 38
Jungle Room: 39
Savannah Room: 40
Desert Room: 41
River Room: 42
Tasting Room: 29
Bottle Room: 30
Stomping Room: 31
Barrel Room: 34
Fermentation Room: 32
Cooper Room: 33
Riverhaven's Knight's Hall (Map30_Riverhaven)
Rose Room: 433
Warrior Room: 434
Food Plaza: 435
Children's Room: 436
Theatre Room: 437
World Room: 438
Back Room: 439
Keep Room: 430
Dungeon Room: 431
Storage Area: 432
Shard's Crystal Plaza (Map67_Shard)
Play Yard: 479
Prism Room: 480
Oak Room: 481
Luminous Room: 482
Storage: 476
Food Court: 477
Sea: 478
As a search option or visible data? Definitely adding a column, and possibly a search option. Initially, I was thinking a column (for those of us viewing all three cities), but I could see a lot of people limiting their searches by city. Yes, I actually kind of planned on just converting all prices to kronar and leaving raw prices available as the secondary option, maybe in a mouse over or hidden column. I like the mouse-over idea. Good point, I planned on adding a 'directions' blurb for each store with the lich room number, I can add room name and genie room number if we get our hands on those. You don't need a room # for the Genie rooms, as they are all labeled by room name. (That is, you can type #goto followed by the first few letters of the room name.) Using the room name instead of the Genie number will also make the list more user-friendly for people who don't use Genie. Here are all of the rooms that may contain shops (in the order my spreadsheet uses): Crossing's Market Plaza (Map1j_Market_Plaza) Sun Room: 3 Water Room: 4 Grass Room: 5 Solarium: 6 Forest Room: 8 Dimly-Lit Storage: 9 Meeting Room: 10 Moon Room: 11 Armor Room: 12 Lodge Room: 13 Gladiolus Room: 14 Fire Room: 15 Library: 16 Volcano Room: 35 Palm Room: 36 Ocean Room: 37 Tundra Room: 38 Jungle Room: 39 Savannah Room: 40 Desert Room: 41 River Room: 42 Tasting Room: 29 Bottle Room: 30 Stomping Room: 31 Barrel Room: 34 Fermentation Room: 32 Cooper Room: 33 Riverhaven's Knight's Hall (Map30_Riverhaven) Rose Room: 433 Warrior Room: 434 Food Plaza: 435 Children's Room: 436 Theatre Room: 437 World Room: 438 Back Room: 439 Keep Room: 430 Dungeon Room: 431 Storage Area: 432 Shard's Crystal Plaza (Map67_Shard) Play Yard: 479 Prism Room: 480 Oak Room: 481 Luminous Room: 482 Storage: 476 Food Court: 477 Sea: 478