Jump to content

City Growth Speed Vol 2


Krampus
 Share

Recommended Posts

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 by Krampus
  • Upvote 4

HEADERS_CTO12.png

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

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.

image.png.8ca8bdb35503c5b44d6d2f3d8ed79b8b.png

Edited by Sweeeeet Ronny D
  • Haha 1
Link to comment
Share on other sites

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? :P

 

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 

HEADERS_CTO12.png

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

Here's a much more expanded upon version

https://docs.google.com/spreadsheets/d/1Q3g5bJ2LZNV0GIvlCCvtfNk84DU7yGCRY42T7vWpbP0/edit?usp=sharing

Edited by Krampus

HEADERS_CTO12.png

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

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

HEADERS_CTO12.png

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and the Guidelines of the game and community.