Krampus Posted August 10, 2022 Share Posted August 10, 2022 (edited) I'll keep this short. Recently, someone brought up Hidude's city growth sheet. I noticed it's from March and wanted to update it. Feel free to ask if you have questions. I threw this together in under an hour, feel free to correct me If there is a bug in my code or an error like that. On that note, I only count taxable nations as members, i.e i don't count VMs, grays, applicants and beiged nations. I can't really be arsed to make graphs out of this data, so feel free to if you have the time. The sheet shows the past 2, 3 and 4 months, as I don't have the time to make it more detailed than that, and hidude's is only 4 months old. I'll also include a data dump of city and alliance data that I used, keep in mind its data you can get from the api. (update: apparently the forums don't allow uploading files bigger than 1mb, so if anyone wants the data dump just dm me on discord, its about 200mb) Here it is: https://docs.google.com/spreadsheets/d/1Tn5Xh0BGrau8s4uGA92b8o9W862u6QQzbjLlSReLyis/edit?usp=sharing code.json Edited August 11, 2022 by Krampus 4 Quote Inform Zigbir I have forgotten how to edit the signature field Please remind me how to do it post haste! Link to comment Share on other sites More sharing options...
Denison Posted August 10, 2022 Share Posted August 10, 2022 dnn 4 Quote Janny Larpers Link to comment Share on other sites More sharing options...
Monti Posted August 10, 2022 Share Posted August 10, 2022 10 minutes ago, Denison said: dnn ron 4 6 Quote Link to comment Share on other sites More sharing options...
MinesomeMC Posted August 11, 2022 Share Posted August 11, 2022 7 hours ago, Monti said: ron VGM Quote Link to comment Share on other sites More sharing options...
KiWilliam Posted August 11, 2022 Share Posted August 11, 2022 pnw 1 1 Quote Link to comment Share on other sites More sharing options...
hidude45454 Posted August 11, 2022 Share Posted August 11, 2022 Wordle 418 4/6 ⬛⬛🟩⬛🟩⬛🟩⬛⬛⬛🟨⬛⬛⬛⬛🟩🟩🟩🟩🟩 2 Quote Link to comment Share on other sites More sharing options...
Sweeeeet Ronny D Posted August 11, 2022 Share Posted August 11, 2022 (edited) Why is it every time this gets posted, Grumpy spent like half of the time frame in war? It really makes it tough to compare ourselves against others. oh wait there are tabs... lets see those! Also fun, I just bought city 45 this week, which cost me the same as the 45 cities NW bought over the last 3 months. Edited August 11, 2022 by Sweeeeet Ronny D 1 Quote Link to comment Share on other sites More sharing options...
BrythonLexi Posted August 11, 2022 Share Posted August 11, 2022 (edited) Can you add a column for cities built per member? Edited August 11, 2022 by BrythonLexi Quote Link to comment Share on other sites More sharing options...
Zei-Sakura Alsainn Posted August 11, 2022 Share Posted August 11, 2022 6 minutes ago, BrythonLexi said: Can you add a column for cities built per member? Also wondering where the other (currently 😎 non VM members of ours went? Quote Link to comment Share on other sites More sharing options...
Krampus Posted August 11, 2022 Author Share Posted August 11, 2022 45 minutes ago, BrythonLexi said: Can you add a column for cities built per member? For sure 37 minutes ago, Zei-Sakura Alsainn said: Also wondering where the other (currently 😎 non VM members of ours went? I don't count inactives, grays, beige etc as members, that's the difference. Though if you want to see the difference I could change it Quote Inform Zigbir I have forgotten how to edit the signature field Please remind me how to do it post haste! Link to comment Share on other sites More sharing options...
Krampus Posted August 12, 2022 Author Share Posted August 12, 2022 (edited) Here's a much more expanded upon version https://docs.google.com/spreadsheets/d/1Q3g5bJ2LZNV0GIvlCCvtfNk84DU7yGCRY42T7vWpbP0/edit?usp=sharing Edited August 13, 2022 by Krampus Quote Inform Zigbir I have forgotten how to edit the signature field Please remind me how to do it post haste! Link to comment Share on other sites More sharing options...
dtc justice Posted August 14, 2022 Share Posted August 14, 2022 Oblivion with the 50 city average Quote Link to comment Share on other sites More sharing options...
Krampus Posted August 15, 2022 Author Share Posted August 15, 2022 9 hours ago, dtc justice said: Oblivion with the 50 city average Yeah that was an issue I previously mentioned, i didn't count beige/gray's as members but counted their cities, because it's a lot faster to query in the database. Here's an uptodate version though: CityGrowthSheet.xls Quote Inform Zigbir I have forgotten how to edit the signature field Please remind me how to do it post haste! Link to comment Share on other sites More sharing options...
hidude45454 Posted August 15, 2022 Share Posted August 15, 2022 11 hours ago, dtc justice said: Oblivion with the 50 city average You wish you were this big and beautiful 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.