Tool for End Game in Steam over Europe

    After several End Games I've made a tool to make the End Game a bit easier for callers. It's a Google-Sheet tool. The tool is a template, so if you intend to use it copy it to your own Google-Profile. It should only be downloaded by ONE from the city, who then host it for the rest of the callers. It's a tool that can be used to make scenarios for which Online good to choose. Just change the WT-entries and goods to see, which good would be most efficient to choose, or at which WT it would be acceptable to choose a specific good as Online.


    I've also made a manual for using it.


    The Tool itself:

    The Tool-template


    The Manual


    I have to give credit to Rantanen who created the initial tool, that's been upgraded extensively since

    Quite a complex sheet at first sight. Always good to see people willing to share their tools though ;)


    I've used sheets for calling for the past year as well, but never something as sophisticated as that. Well done, must have taken you a while !


    Sofia is better situated than Bucarest for EG, if Sarajevo isn't heavily populated though ;)

    Fr-201 Bad Wolf de coeur

    en pause indéterminée - away from the game until next interesting server


    Likely coming back for clash!

    It's intended to be able to use it for all 50 cities, as long as you enter the industry and distance to city. And it only has to be done ONCE. If I myself gets the data for a city at some point, I'll upload updated data, that can simply copied to your own copy

    I have some data for a few mega-cities, but not in the same format. If I find the time I'll make sure to translate it to english, convert it to this format using your template and send it to you so that you can upload it.


    It would be awesome to get this information (and maybe more later) available to all players and I'm glad you started this topic !

    Fr-201 Bad Wolf de coeur

    en pause indéterminée - away from the game until next interesting server


    Likely coming back for clash!

    Its based on city levels. When a city transforms to a megacity the stock is tripled.


    Below a table with the stocksize of megacities from level 36 to 47.


    Level Stocksize
    36 156.000
    37 162.000
    38 168.000
    39 174.000
    40 180.000
    41 187.500
    42 195.000
    43 202.500
    44 210.000
    45 217.500
    46 225.000

    Good and helpful tool.
    Thank's!

    Hi Jack,

    very nice and useful tool.

    did you create an updated version of the tool with the new calculation mode of the number of good required based also of number of city active player ?

    I'would be very interested in it.

    Thanks!!!

    zioMauri

    I don't know for sure but I do know Jack a little (teammate) so my guess is that the tool has been updated with the new EG-formulas ;)

    :engine1: NL01 Stoomketel :engine1: NL201 Euromast :engine1: COM202 Loch Ness :engine1:

    :engine1: ES201 El Escorial :engine1: COM401 Einstein :engine1:

    Thanks a lot Jack!!!

    I used the previous version of it.. and in fact the distance/track lenght was an important information during the good selection. (I missed it)

    Maybe, a cell were you can add the "actual" WT beside the W column, give additional infos and provide you a more complete picture of the industries status before the call.


    Unfortunately the players of megacity and region were almost sleeping so I did not have the possbility to discover the full benefit of the tool (we took always a couple of hours to complete a good :( )

    But it was good time to get familiar with it.

    I'm going to use it in a month....I'll provide additional feedback.


    Last thing: did you ever think to create a version for the Classic scenario ? or is it already available somewhere ?

    Thanks again !!!!

    Hi Jack, it seems that cell L15 (City requires /h) is not the result of the calculation based on active players and city level. it seems a normal cell to be filled.

    Do I missing something ?

    Thanks!