• Play
  • About
  • News
  • Forums
  • Yppedia
  • Help
Welcome Guest   | Login
  Index  | Recent Threads  | Register  | Search  | Help  | RSS feeds  | View Unanswered Threads  
  Search  


Quick Go »
Thread Status: Normal
Total posts in this thread: 16
[Add To My Favorites] [Watch this Thread] [Post new Thread]
Author
Previous Thread This topic has been viewed 2598 times and has 15 replies Next Thread
wrs1864b

Member's Avatar


Joined: Apr 10, 2006
Posts: 6312
Status: Offline
Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

I dug up some stats on the number of shops/stalls before and after the merger and I thought others might be interested in the results. I found it interesting to see which oceans faired better and which islands had the most shops built/dust.

All this data is based on information for the YARRG website and *not* from hand counts of every ocean. The latter is a huge amount more work and I don't have info from the pre-merger state, so this is the best I can do.

The YARRG data will only list a store if it is buying or selling *something* on the dockside market, so thing like tailor stalls being used as a huge wardrobe often don't show up. On the other hand, those kinds of stores rarely have any economic impact, so it is probably better to not count them.

Also, I don't go through the effort to figure out what the type of each shop is, so things like the palace/market count as a "shop". I have also only listed medium/large islands.

Lastly, the "Min Assets" column should probably be ignored or at least taken with a huge grain of salt. What I do is figure out the absolute minimum a store has in its coffers by looking at what the store is buying. I also look at what the store is offering to sell and value those items at a "reasonable market value" to get a minimum value of the store's hold. The actual store coffers/hold is often much much larger than what I can prove, these are just absolute minimums. On the other hand, people tend to run their stores the same way, so if minimum provable assets of their stores change, that can tell you something, just not very much.

Edit: I've added back in islands that begin with 'T" *blush*

Hunter
Hunter islands had 21.1% more shops/stalls before the merger

Before the merger:
Island Apot Dist Furn Iron Ship Tail Weav Shop Total Min Assets
Aimuari Island 34 45 11 113 13 30 24 67 = 337 58940k
Alkaid Island 2 5 . 8 . 2 5 37 = 59 10506k
Armstrong Island 3 11 1 17 2 . 2 38 = 74 11110k
Chachapoya Island 8 17 1 28 1 6 2 3 = 66 8538k
Doyle Island . . . . . . 5 5 = 10 821k
Hubble's Eye . 5 . 16 . . . 6 = 27 1410k
Ilha da Aguia . . . 1 . 1 4 4 = 10 526k
Pukru Island . . . . 3 . . 5 = 8 2870k
Quetzal Island 7 15 2 48 6 7 4 2 = 91 10448k
Sayers Rock 8 10 2 22 1 3 . 37 = 83 15775k
The Lowland Hundred . 8 . 4 . . . 3 = 15 1221k
--- --- --- --- --- --- --- --- ---- -------
Total 62 116 17 257 26 49 46 207 = 780 122165k

After the merger:
Island Apot Dist Furn Iron Ship Tail Weav Shop Total Min Assets
Aimuari Island 22 28 4 74 7 22 10 69 = 236 61113k
Alkaid Island 2 4 . 10 . 1 3 44 = 64 13134k
Armstrong Island 3 11 2 15 1 . . 36 = 68 8331k
Chachapoya Island 5 13 . 26 . 1 1 3 = 49 7214k
Doyle Island . . . . . . 8 4 = 12 769k
Hubble's Eye . 7 . 25 1 . . 5 = 38 3077k
Ilha da Aguia . . . 2 . 1 6 4 = 13 840k
Pukru Island . . . . 4 4 . 4 = 12 3866k
Quetzal Island 8 12 1 31 5 4 3 3 = 67 10544k
Sayers Rock 9 7 . 15 . 1 . 37 = 69 15057k
The Lowland Hundred . 7 . 4 1 . . 4 = 16 892k
--- --- --- --- --- --- --- --- ---- -------
Total 49 89 7 202 19 34 31 213 = 644 124837k

Sage
Sage islands had 0.2% more shops/stalls before the merger

Before the merger:
Island Apot Dist Furn Iron Ship Tail Weav Shop Total Min Assets
Admiral Island 25 46 7 109 11 35 22 84 = 339 94296k
Arakoua Island 3 1 . 5 . . 5 43 = 57 10893k
Barbary Island 4 6 . 7 . . 1 38 = 56 9208k
Blackthorpe Island . 5 . 4 . . . 5 = 14 1503k
Bowditch Island 4 9 1 14 3 . 1 52 = 84 14052k
Caravanserai Island 5 3 1 8 . 4 6 68 = 95 26501k
Descartes Isle 5 14 1 13 1 6 2 2 = 44 6265k
Greenwich Island 8 11 2 21 2 3 4 3 = 54 9851k
Isle of Kent . 27 . 66 5 . . 4 = 102 7444k
Kasidim Island . . . 21 4 . . 5 = 30 2294k
Lincoln Island 7 14 3 21 2 4 1 2 = 54 7252k
Scrimshaw Island 6 6 . 20 . 1 3 70 = 106 20134k
Spaniel Island . 10 . 19 . . . 4 = 33 2796k
Wensleydale 14 26 6 34 5 15 23 2 = 125 18509k
Wissahickon Island . 5 . 4 1 . . 4 = 14 1858k
--- --- --- --- --- --- --- --- ---- -------
Total 81 183 21 366 34 68 68 386 = 1207 232856k

After the merger:
Island Apot Dist Furn Iron Ship Tail Weav Shop Total Min Assets
Admiral Island 32 32 3 117 11 26 22 88 = 331 76176k
Arakoua Island 1 3 . 1 . . 6 45 = 56 8748k
Barbary Island 4 5 . 7 . . . 53 = 69 12928k
Blackthorpe Island . 5 . 11 . . . 5 = 21 1765k
Bowditch Island 4 6 2 14 . . 2 62 = 90 15008k
Caravanserai Island 6 2 . 8 . 2 7 84 = 109 22781k
Descartes Isle 3 8 1 10 1 3 1 2 = 29 5359k
Greenwich Island 6 10 2 21 5 3 2 3 = 52 8157k
Isle of Kent . 27 . 61 6 . . 4 = 98 6087k
Kasidim Island . . . 19 2 . . 5 = 26 3062k
Lincoln Island 7 13 1 20 2 4 2 2 = 51 5723k
Scrimshaw Island 5 6 . 14 1 1 1 72 = 100 19921k
Spaniel Island . 16 . 18 . . . 4 = 38 3193k
Wensleydale 13 21 5 36 7 13 17 2 = 114 18552k
Wissahickon Island . 7 . 9 1 . . 4 = 21 2817k
--- --- --- --- --- --- --- --- ---- -------
Total 81 161 14 366 36 52 60 435 = 1205 210277k


Malachite
Malachite islands had 22.3% more shops/stalls before the merger

Before the merger:
Island Apot Dist Furn Iron Ship Tail Weav Shop Total Min Assets
Acanthaster Spits . . . 3 . 1 . 1 = 5 2196k
Barracuda Island 8 10 . 19 . . . 2 = 39 6459k
Celesta Isle 8 . 4 . 6 . 14 4 = 36 5408k
Chelydra Cove . 13 20 22 5 . . 3 = 63 12116k
Chrysalis Island . 13 . 33 9 . 23 3 = 81 9428k
Drogeo Island . 11 . 22 . 3 . 4 = 40 2358k
Fugu Island 5 . . . . 5 . 4 = 14 2988k
Nightshade Island . 7 . 15 1 . 9 3 = 35 3361k
Saltstraum Rock 13 15 . 31 . 21 . 2 = 82 18652k
--- --- --- --- --- --- --- --- ---- -------
Total 34 69 24 145 21 30 46 26 = 395 62965k

After the merger:
Island Apot Dist Furn Iron Ship Tail Weav Shop Total Min Assets
Acanthaster Spits . . 1 3 . . . 5 = 9 946k
Barracuda Island 4 10 . 10 . . . 2 = 26 2212k
Celesta Isle 6 . 5 . 3 . 7 3 = 24 3861k
Chelydra Cove . 15 10 22 8 . . 2 = 57 7917k
Chrysalis Island . 12 . 23 12 . 17 2 = 66 7165k
Drogeo Island . 10 . 16 . 2 . 3 = 31 1750k
Fugu Island 5 . . . 3 2 . 4 = 14 4778k
Nightshade Island . 10 . 17 4 . 6 3 = 40 3441k
Saltstraum Rock 12 9 . 17 . 16 . 2 = 56 14543k
--- --- --- --- --- --- --- --- ---- -------
Total 27 66 16 108 30 20 30 26 = 323 46614k

Viridian
Viridian islands had 15.6% more shops/stalls before the merger

Before the merger:
Island Apot Dist Furn Iron Ship Tail Weav Shop Total Min Assets
Carmine Island . . . . 3 2 6 4 = 15 3872k
Cochineal Island . . . . 1 . 6 4 = 11 1382k
Dragon's Nest 27 40 6 103 9 12 15 2 = 214 40951k
Fintan Island 4 5 . 9 . 2 2 49 = 71 18321k
Garden Cradle 5 15 . . 6 . 14 2 = 42 2819k
Hadrian Island 4 6 1 12 1 . 2 44 = 70 10753k
Harmattan Island . . . . . . 13 3 = 16 1568k
Jubilee Island 14 8 3 25 4 3 6 32 = 95 23045k
Kirin Island 5 18 3 29 2 5 14 31 = 107 22298k
Labyrinth Moors 4 5 . 9 . . . 67 = 85 16773k
Lima Island 49 51 23 174 38 55 40 5 = 435 67303k
Napi Peak 2 2 1 5 . . 1 108 = 119 17230k
Olive Island . . . 6 . . . 4 = 10 2400k
Prolix Purlieu . . . . . . 5 5 = 10 3293k
Sakejima Island 7 11 2 22 4 6 5 6 = 63 8673k
Stormy Fell 5 12 2 15 3 2 4 8 = 51 6379k
Swampfen Island . . . . 7 9 . 3 = 19 970k
Terra Island 2 5 . 6 1 . 1 57 = 72 22813k
Tigerleaf Mountain 4 12 . 10 . 1 4 72 = 103 19200k
Windward Vale . 16 . 15 2 . . 4 = 37 4693k
--- --- --- --- --- --- --- --- ---- -------
Total 132 206 41 440 81 97 138 510 = 1645 294734k

After the merger:
Island Apot Dist Furn Iron Ship Tail Weav Shop Total Min Assets
Carmine Island . . . . 2 5 4 4 = 15 2031k
Cochineal Island . . . . 1 . 6 4 = 11 2830k
Dragon's Nest 23 34 5 84 5 13 13 2 = 179 44988k
Fintan Island 5 3 . 8 . . . 44 = 60 20872k
Garden Cradle 5 11 . . 2 . 15 3 = 36 2057k
Hadrian Island 2 1 . 5 . . . 55 = 63 10856k
Harmattan Island . . . . . 1 11 3 = 15 2144k
Jubilee Island 5 5 1 10 . 3 5 54 = 83 17480k
Kirin Island 7 13 1 20 2 5 7 56 = 111 28090k
Labyrinth Moors 3 3 . 4 . 1 1 62 = 74 18911k
Lima Island 44 39 19 113 25 56 33 5 = 334 63880k
Napi Peak 2 1 . 4 . . 2 105 = 114 21341k
Olive Island . . . 9 . . . 4 = 13 1773k
Prolix Purlieu . . . . 2 . 7 4 = 13 5485k
Sakejima Island 9 8 1 15 3 6 6 5 = 53 9278k
Stormy Fell 1 6 . 8 1 1 1 23 = 41 7790k
Swampfen Island . . . . 2 6 . 3 = 11 965k
Terra Island 2 2 1 6 . . 1 56 = 68 21633k
Tigerleaf Mountain 5 5 . 8 . 3 3 65 = 89 21640k
Windward Vale . 12 . 22 2 . . 4 = 40 2871k
--- --- --- --- --- --- --- --- ---- -------
Total 113 143 28 316 47 100 115 561 = 1423 306916k


Cobalt
Cobalt islands had 26.2% more shops/stalls before the merger

Before the merger:
Island Apot Dist Furn Iron Ship Tail Weav Shop Total Min Assets
Carmine Island 4 14 . 15 4 . 4 2 = 43 1844k
Cochineal Island . 5 . 6 . 2 3 4 = 20 1639k
Cormorant Island 7 11 . 9 . . . 4 = 31 1651k
Dragon's Nest 10 13 9 35 7 10 9 3 = 96 11822k
Fintan Island 3 3 3 7 1 1 3 28 = 49 4777k
Garden Cradle 8 17 . 13 6 . 12 2 = 58 4152k
Harmattan Island 7 9 . 13 . . 10 3 = 42 1843k
Jubilee Island 3 2 . 7 4 . 2 3 = 21 693k
Kirin Island 13 7 4 11 2 6 7 15 = 65 11637k
Labyrinth Moors 4 3 2 4 . 1 1 19 = 34 4448k
Lima Island 9 6 1 11 2 4 3 9 = 45 5090k
Napi Peak 2 1 1 4 . 1 2 16 = 27 4542k
Olive Island . 5 . 13 . . . 4 = 22 1825k
Pranayama Island . 6 . 8 1 5 5 3 = 28 1887k
Prolix Purlieu . 12 . 18 9 . . 4 = 43 2912k
Sakejima Island 2 7 . 6 1 . . 8 = 24 2900k
Terra Island 7 3 5 5 . 2 4 28 = 54 9602k
Tigerleaf Mountain 5 4 . 7 . 2 5 41 = 64 7775k
--- --- --- --- --- --- --- --- ---- -------
Total 84 128 25 192 37 34 70 196 = 766 81038k

After the merger:
Island Apot Dist Furn Iron Ship Tail Weav Shop Total Min Assets
Carmine Island 5 9 . 14 4 . 3 2 = 37 2444k
Cochineal Island 2 5 . 3 . 2 1 3 = 16 1917k
Cormorant Island 3 8 . 5 . . . 3 = 19 1156k
Dragon's Nest 8 10 2 26 1 6 4 3 = 60 9317k
Fintan Island 2 3 1 5 . . 1 24 = 36 5563k
Garden Cradle 5 15 . 11 2 . 13 2 = 48 3639k
Harmattan Island 5 6 . 15 . . 6 3 = 35 2063k
Jubilee Island 3 3 . 5 2 . 1 10 = 24 2249k
Kirin Island 8 3 2 4 1 4 5 18 = 45 12646k
Labyrinth Moors 4 2 1 2 . . 1 15 = 25 3746k
Lima Island 4 4 1 7 . 2 3 9 = 30 4501k
Napi Peak . 1 . 1 . . 1 18 = 21 2169k
Olive Island . 7 . 9 . . . 4 = 20 1672k
Pranayama Island . 5 . 5 3 5 5 2 = 25 1560k
Prolix Purlieu . 12 . 25 6 . . 4 = 47 3473k
Sakejima Island 1 3 . 4 1 . . 8 = 17 2473k
Terra Island 7 4 3 4 . 2 3 28 = 51 6967k
Tigerleaf Mountain 2 4 . 5 . 1 . 39 = 51 7452k
--- --- --- --- --- --- --- --- ---- -------
Total 59 104 10 150 20 22 47 195 = 607 75007k

Midnight
Midnight islands had 8.9% more shops/stalls before the merger

Before the merger:
Island Apot Dist Furn Iron Ship Tail Weav Shop Total Min Assets
Alpha Island 5 4 3 5 . 3 3 18 = 41 18555k
Beta Island . . 1 2 . . . 22 = 25 5480k
Byrne Island 4 3 . 8 . 2 1 4 = 22 4638k
Cleopatra's Pearls 3 5 . 5 . 1 . 2 = 16 824k
Cnossos Island 2 5 1 6 2 2 1 12 = 31 2153k
Cranberry Island 4 4 2 3 2 3 7 15 = 40 5020k
Delta Island 1 4 . 3 . . . 22 = 30 5387k
Emperor Island 5 5 . 4 . 5 . 4 = 23 2527k
Endurance Island 1 1 . 1 . . 1 14 = 18 2871k
Epsilon Island 4 4 1 8 . . 8 12 = 37 5102k
Eta Island 1 2 . 8 . . 1 26 = 38 7610k
Gaea Island 2 4 . 4 . 2 3 18 = 33 3890k
Guava Island . 3 . 6 1 . 2 21 = 33 7470k
Hephaestus' Forge 1 1 . 8 . 1 2 14 = 27 3784k
Islay of Luthien 2 5 . 9 . 1 1 6 = 24 2109k
Jorvik Island 3 1 . 6 . 1 1 26 = 38 6408k
Lagniappe Island . . . 1 . . 1 12 = 14 6302k
Midsummer . 5 . . . . . 1 = 6 423k
Namath Island 1 3 . 4 . 1 2 14 = 25 3850k
Nu Island 2 5 . 3 . . 3 14 = 27 2521k
Ostreum Island 6 9 . 9 8 . 3 2 = 37 2691k
Oyster Island 6 7 1 6 1 3 7 11 = 42 3797k
Papaya Island 3 4 3 8 2 1 2 10 = 33 2406k
Park Island 2 5 1 6 2 1 3 12 = 32 4114k
Spring Island 4 4 1 13 4 3 2 30 = 61 11202k
Tinga Island 3 5 . 6 2 1 6 7 = 30 1787k
Turtle Island 4 5 . 23 3 4 3 22 = 64 12492k
Vernal Equinox . . . 3 . 3 4 5 = 15 1022k
Winter Solstice 2 2 . 3 . 1 . 19 = 27 2367k
Wrasse Island 2 4 . 6 . 1 . 4 = 17 1817k
Xi Island 3 3 3 4 . 1 1 12 = 27 9497k
Zeta Island 2 4 1 5 . . 1 17 = 30 4343k
--- --- --- --- --- --- --- --- ---- -------
Total 78 116 18 186 27 41 69 428 = 963 154461k

After the merger:
Island Apot Dist Furn Iron Ship Tail Weav Shop Total Min Assets
Alpha Island 1 4 2 5 . 2 3 16 = 33 16618k
Beta Island . 1 . . . . . 22 = 23 6844k
Byrne Island 4 3 . 8 3 2 2 5 = 27 3312k
Cleopatra's Pearls 3 6 . 5 . . . 2 = 16 1033k
Cnossos Island 2 4 2 6 1 4 . 13 = 32 3698k
Cranberry Island 1 3 1 4 1 . 7 14 = 31 3115k
Delta Island 1 4 1 2 . . . 25 = 33 4603k
Emperor Island 5 5 . 5 . 3 . 3 = 21 1376k
Endurance Island 1 1 . 1 . . 1 10 = 14 1028k
Epsilon Island 5 5 1 7 1 . 5 12 = 36 4999k
Eta Island 1 2 . 5 . 1 2 22 = 33 6889k
Gaea Island 3 6 . 4 . 1 3 18 = 35 4581k
Guava Island . 2 . 7 1 . 2 23 = 35 5350k
Hephaestus' Forge 4 1 . 7 1 1 1 14 = 29 5482k
Islay of Luthien 2 5 . 10 . . 2 6 = 25 1846k
Jorvik Island 4 3 . 4 . 1 1 22 = 35 5084k
Lagniappe Island . . . 1 . . 2 12 = 15 6507k
Midsummer . 6 . . . . . 1 = 7 434k
Namath Island 1 2 . 3 . 1 2 16 = 25 3630k
Nu Island 3 2 . 4 . . 2 12 = 23 3034k
Ostreum Island 6 8 . 8 4 . 3 2 = 31 1765k
Oyster Island 1 5 . 6 . 2 3 9 = 26 4469k
Papaya Island 4 6 1 8 2 1 2 10 = 34 2034k
Park Island 3 5 1 4 . 1 . 10 = 24 1759k
Spring Island 4 5 1 9 3 1 . 27 = 50 10936k
Tinga Island 3 3 . 8 1 1 5 7 = 28 1982k
Turtle Island 4 4 . 13 2 3 1 22 = 49 10625k
Vernal Equinox . . . 2 . 2 5 5 = 14 665k
Winter Solstice 3 3 . 4 . . . 15 = 25 2847k
Wrasse Island 4 4 . 7 . 1 1 4 = 21 1809k
Xi Island 3 3 2 3 1 1 1 12 = 26 7785k
Zeta Island . 3 1 2 . 1 1 22 = 30 5970k
--- --- --- --- --- --- --- --- ---- -------
Total 76 114 13 162 21 30 57 413 = 886 142109k

----------------------------------------
Algol can not assert the truth of all statements in this post and still be consistent.
----------------------------------------
[Edit 3 times, last edit by wrs1864b at Jun 9, 2013 3:37:43 PM]
[Jun 9, 2013 8:12:47 AM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
Shinito

Member's Avatar


Joined: Jan 3, 2006
Posts: 582
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

At what point were the before and after snapshots taken?
----------------------------------------
Thorkill on Malachite 2.0 Obsidian
[Jun 9, 2013 10:46:10 AM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
wrs1864b

Member's Avatar


Joined: Apr 10, 2006
Posts: 6312
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

 
At what point were the before and after snapshots taken?

The "before" is the last set of uploads that the YARRG website had before the merger, so mostly around late Jan 2012, but some island data is as old as Nov 2011. As of a couple of months ago, you could still download YARRG's databases for the old oceansss.

The "after" is copies of the YARRG databases that I downloaded yesterday, so you can get exact dates for the islands via the website. Some of the "after" data is pretty old, but I'm too lazy to go update all islands on all oceans.

Sorry, I meant to add that info to the OP, but spaced. Thanks for pointing that out.
----------------------------------------
Algol can not assert the truth of all statements in this post and still be consistent.
[Jun 9, 2013 11:12:12 AM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
marundel

Member's Avatar


Joined: Jan 7, 2007
Posts: 2955
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

Hmmm... missing both Tigerleaf Mountain and Tinga on the Cerulean lists... and I know that both have dockside buy offers posted/
----------------------------------------
Pizzahutpete on the Cerulean Ocean
Prince, Super Awesomeness
SO, Boochin' Drunks

Pizzahutpete everywhere, thanks to the merge
[Jun 9, 2013 1:15:39 PM] Show Printable Version of Post        Send Private Message    http://www.thehomebrewstore.com    meadbrewer [Link]  Go to top 
Shinito

Member's Avatar


Joined: Jan 3, 2006
Posts: 582
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

Using PPAT I made some statistics:

On Jan 2012 the average population* of Hunter and Sage was ~770 (320 and 450 respectively) and as of Jun 2013 the population of Emerald was standing at ~500. This indicates a ~35% decrease in the population. Meanwhile the stats indicate only a 7.1% decrease in stalls/shoppes.

The population of Viridian and Malachite on Jan 2012 was ~640 (570 and 70) and as of Jun 2013 Meridians population was ~450 indicating a ~27% decrease in population. The decrease in stalls/shoppes is 14.41%.

Cobalt and Midnight population was ~210 (100 and 110) as of Jan 2012 and Cerulean 140 as of Jun 2013 with ~33% decrease in population. Stall/shoppe decrease of 13.38%.

In the end stats are:

Emerald:
Population: ~35% decrease since merge
Stalls/shoppes: 7.1% decrease since merge

Meridian:
Population: ~30% decrease since merge
Stalls/shoppes: 14.41% decrease since merge

Cerulean:
Population: ~33% decrease since merge
Stalls/shoppes: 13.38% decrease since merge

Conclusions:

The three oceans seem to show very different decreases in populations and industry remaining.

Emerald seems to have an extremely stable industry that is highly resistant to population drops especially with the Sage half suffering almost no drop in stalls/shoppes. Without ever playing on Emerald I would guess that most of the stalls/shoppes are owned by the same players since the merge.

Meridian seems to have suffered a rather significant decrease in industry compared to the population while at the same time suffering a slightly lesser population drop than Emerald and I cannot thing of a good reason for why.

Cerulean seems to have suffered the same fate as Meridian despite having a smaller community and an easier entry cost for stalls.


Anyway feel free to point out statistical errors ask questions of try to reason the difference between the population and stall drops on different oceans.

*Interpreting PPAT numbers is pretty hard so I am at most providing slightly inaccurate numbers
----------------------------------------
Thorkill on Malachite 2.0 Obsidian
[Jun 9, 2013 1:52:16 PM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
wrs1864b

Member's Avatar


Joined: Apr 10, 2006
Posts: 6312
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

 
Hmmm... missing both Tigerleaf Mountain and Tinga on the Cerulean lists... and I know that both have dockside buy offers posted/

For Viridian (and Malachite), I deleted a "Total" line at the bottom of an intermediate step out by hand. For the rest, automatically deleted all lines that began with 'T", thus deleting Terra, TLM, Tinga, etc. D'oh! *sigh*.

I have automated things a little more and edited the original. This didn't change the percentages dramatically.

Hunter should have been 21.1% but was 21.8%
Cobalt should have been 26.2% but was 28.3%
Midnight should have been 8.9% but was 7.4%

Let me know what other stupid things I did. ;-)
----------------------------------------
Algol can not assert the truth of all statements in this post and still be consistent.
----------------------------------------
[Edit 1 times, last edit by wrs1864b at Jun 9, 2013 3:36:42 PM]
[Jun 9, 2013 3:30:29 PM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
mari_

Member's Avatar


Joined: May 18, 2005
Posts: 2470
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

Are you including shoppes and stalls in your data?

Interesting that you are stating there are no SY on Park... mine has been there since pre-merge and is still running quite happily thank you.
----------------------------------------
Calamarie - now also in Obsidian flavour!
Dignity - Emerald

"Always remember... Rumours are carried by haters, spread by fools, and accepted by idiots."

The Shadow is in my very core ;)
[Jun 10, 2013 1:13:15 PM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
Winklecat



Joined: Jun 8, 2008
Posts: 109
Status: Offline

Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

The stats for scrimshaw are out of whack. Probably because a lot of the ship yards don't buy or sell dockside unless the price of wood cooperates. Very interesting stats though. Thanks for publishing it.
----------------------------------------
Winklecat
SO of The Bootleggers on Emerald
Royal and occasional monarch of The End
[Jun 10, 2013 3:08:39 PM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
wrs1864b

Member's Avatar


Joined: Apr 10, 2006
Posts: 6312
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

 
Are you including shoppes and stalls in your data?

Interesting that you are stating there are no SY on Park...

in the OP I wrote: "Also, I don't go through the effort to figure out what the type each shop is, so things like the palace/market count as a "shop"."

So, yes, your SY shop is listed as a shop.

 
The stats for scrimshaw are out of whack. Probably because a lot of the ship yards don't buy or sell dockside unless the price of wood cooperates.

Scrimshaw has a huge number of shops, judging by the names, a lot of them look like SYs. (Others like "Stark Industries" are much less clear. ;-)

Maybe after 4 years, it is time to actually take the effort to try and figure out what type each shop is, there sure are a lot of them now a days. hmmm... If I did, I'm not sure if i should lump shops in with stalls or list them separately.
----------------------------------------
Algol can not assert the truth of all statements in this post and still be consistent.
[Jun 10, 2013 3:22:59 PM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
Shinito

Member's Avatar


Joined: Jan 3, 2006
Posts: 582
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

Is it feasible to get a list of stall owners before the merge and as of now since it would be interesting to look at how they fared in terms of quitting the game compared to the average player and what percentage of the stalls are owned by long standing players.
----------------------------------------
Thorkill on Malachite 2.0 Obsidian
[Jun 10, 2013 4:26:29 PM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
wrs1864b

Member's Avatar


Joined: Apr 10, 2006
Posts: 6312
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

 
Is it feasible to get a list of stall owners before the merge and as of now since it would be interesting to look at how they fared in terms of quitting the game compared to the average player and what percentage of the stalls are owned by long standing players.

See:
http://schlitt.net/yohoho/stall_list_Cerulean.txt
http://schlitt.net/yohoho/stall_list_Cobalt.txt
http://schlitt.net/yohoho/stall_list_Emerald.txt
http://schlitt.net/yohoho/stall_list_Hunter.txt
http://schlitt.net/yohoho/stall_list_Ice.txt
http://schlitt.net/yohoho/stall_list_Malachite.txt
http://schlitt.net/yohoho/stall_list_Meridian.txt
http://schlitt.net/yohoho/stall_list_Midnight.txt
http://schlitt.net/yohoho/stall_list_Sage.txt
http://schlitt.net/yohoho/stall_list_Viridian.txt

Let me know if I made any mistakes or this isn't what you wanted...
----------------------------------------
Algol can not assert the truth of all statements in this post and still be consistent.
[Jun 10, 2013 5:05:32 PM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
Shinito

Member's Avatar


Joined: Jan 3, 2006
Posts: 582
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

Thanks for the lists. Here's some semi-accurate data I managed to get out of it:

MERIDIAN

Stall owners before the merge: 953
Stall owners after the merge: 724
Started a stall before the merge: 392(54%)
Started a stall after the merge: 332(45%)

EMERALD

Stall owners before the merge: 908
Stall owners after the merge: 767
Started a stall before the merge: 404(52%)
Started a stall after the merge: 363(47%)

CERULEAN

Stall owners before the merge: 716
Stall owners after the merge: 571
Started a stall before the merge: 413(72%)
Started a stall after the merge: 158(27%)

It appears that since the merge nearly half of the stall owners on doubloon oceans have closed shop which is ~15% higher than the percentage of people who quit the game outright. I wonder why since the upkeep for most stalls is pretty negligible. I kinda want to run some kind of survey to find that out.

Ceruleans economy seems to be run by mostly the same people since the merge which is pretty understandable considering the lack of influx of new players.

I really wish that OOO would provide some APIs to mine Y!PP economics data since virtual economies are pretty fun to study.
----------------------------------------
Thorkill on Malachite 2.0 Obsidian
[Jun 11, 2013 5:29:15 AM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
TexasBeesh

Member's Avatar


Joined: Oct 14, 2005
Posts: 1754
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

I wonder how many of these stalls shut down due to the removal of no spawn 30 min before reboot. I know a lot of people relied on this.

Was that before or after the merge?
----------------------------------------
Seatexan - on the Midnight side of Cerulean
LOW RACK PRICES AT DRESSED TO KILL - NAMATH
Always looking for Pollack Sloops!
[Jun 11, 2013 7:33:46 AM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
marundel

Member's Avatar


Joined: Jan 7, 2007
Posts: 2955
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

One thing the data doesn't reveal is the number of shops/stalls that are not actually producing anything... the so-called "trophies"; nor does it reveal the number that are on auto-pilot (the owner and/or managers haven't logged in for months or years, but the coffers have sufficient funds to continue operations.) The data that Algol pulled is the result of dockside buy/sell offers; but I suspect there are many more shops/stalls that are using solely self-supplied (1/1/1) labor, that are unmonitored, or that are augmented by income from other sources being fed into the coffers.

I am a very active player. I own 12 shops, a number of stalls, and I manage several more. Some of the stalls I manage are owned by people who haven't logged on in more than 3 years... but I keep them going because they are useful or because I would feel a sense of remorse if those friends logged in to find their stalls dusted after entrusting me to look after them. I offer fairly decent wages in most of my shops... although that is hurting rather than helping. While I have many employees, I find it next to impossible to compete for sales against the 1/1/1 shops or those who don't care about profit because they are augmenting from other income sources. That's not a complaint - merely an observation. The end result is that I don't have as many sales as it takes to keep those who labor in my shops happy.

The bottom line is that most of my shops are operating at less than 20% efficiency - this meaning that they are either not producing anything 75% of the time, or that they are producing product for dockside sales but are not able to sell 75% of what they produce within a reasonable time. This was not the case pre-merger, where my shops were running at greater than 50% efficiency and I had trouble keeping the reserve labor full.

So, the statistics show an interesting picture of the decline of populations relative to the decline of shops... but really show no indication of whether or not the remaining shops are contributing/sustainable on merit or if they are simply "there".
----------------------------------------
Pizzahutpete on the Cerulean Ocean
Prince, Super Awesomeness
SO, Boochin' Drunks

Pizzahutpete everywhere, thanks to the merge
[Jun 11, 2013 8:03:18 AM] Show Printable Version of Post        Send Private Message    http://www.thehomebrewstore.com    meadbrewer [Link]  Go to top 
Shinito

Member's Avatar


Joined: Jan 3, 2006
Posts: 582
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

 
I wonder how many of these stalls shut down due to the removal of no spawn 30 min before reboot. I know a lot of people relied on this.

Was that before or after the merge?


It was a march update so it got fixed after the merge.
----------------------------------------
Thorkill on Malachite 2.0 Obsidian
[Jun 11, 2013 8:29:55 AM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
Belthazar451

Member's Avatar


Joined: Sep 17, 2007
Posts: 3561
Status: Offline
Re: Changes in shops/stalls since the ocean mergers Reply to this Post
Reply with Quote

Shinito wrote: 
Ceruleans economy seems to be run by mostly the same people since the merge which is pretty understandable considering the lack of influx of new players.

Cerulean (or at least Midnight) has always been far more stable in terms of building changes than the doubloon oceans. When I was keeping the wiki's island articles up-to-date on a regular basis, I'd find that shoppes would get built and dusted in a matter of months - sometimes even weeks - on the doubloon oceans, but the same buildings are still standing after years on Midnight.

It's why I stopped bothering updating the island articles - by the time I finished one round of all the oceans, it'd already be outdated...
[Jun 11, 2013 2:16:09 PM] Show Printable Version of Post        Send Private Message [Link]  Go to top 
[Show Printable Version of Thread] [Post new Thread]

Puzzle Pirates™ © 2001-2016 Grey Havens, LLC All Rights Reserved.   Terms · Privacy · Affiliates