Conquer Club

[Excel] Map Bonus Calculator

How to make a map. Official Handbook, Guides, Tutorials and more...

Moderator: Cartographers

Forum rules
Please read the Community Guidelines before posting.

[Excel] Map Bonus Calculator

Postby thenobodies80 on Fri Aug 12, 2011 8:18 am

Thanks to WidowMakers we have a good excel spreadsheet to help us to find out possible good bonus values for a map.

Once you have input all the required data (the instructions are within the excel file), the spreadsheet will suggest you the bonuses. This formula is not perfect so your bonuses might need further adjustaments to balance things on your map.

There're few things to keep in mind before using this tool:
  • The spreadsheet often gives values that are too low for bonus zones that are in the middle of the map. If a map does have such a centrally-located bonus zone, then its natural value (the difficulty of gaining and holding the bonus) is often more than what the spreadsheet shows.
  • When on your map you have linear bonuses, such as stations along a railway (with each station being adjacent to a non-railway region), instead of the spreadsheet, you can use an easily-remembered rule: +1 for each station.
  • When on your map you have bonuses for holding all regions of a special type (that are not adjacent to each other, such as holding all capital cities), instead of the spreadsheet, you can give +1 for each region, then adding an extra +1 at the end. (e.g. +6 for holding all 5 capital cities).

The spreadsheet and the few notes here above, can help you to see, for example, whether a bonus will be ignored by most players because it's too low. However, they are all only guides and good maps can vary from the numbers given, especially if the mapmaker wants the play to develop in a certain direction.

Copia di CC_MAP_BONUS_CALC.xls
I do NOT visit this site and I'm NOT Team CC anymore.
All PMs are autobinned.
If you need to contact me, you should already have a way to do it without using this site.
Thanks to those who helped me through the years. :)
Corporal 1st Class thenobodies80
 
Posts: 5388
Joined: Wed Sep 05, 2007 4:30 am
Location: Not here
Medals: 70
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (2) Manual Troops Achievement (2) Freestyle Achievement (2) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Speed Achievement (2) Teammate Achievement (1) Cross-Map Achievement (3) Bot Achievement (1) Ratings Achievement (4)
General Achievement (8) Map Contribution (7) Tournament Contribution (6) General Contribution (17)

Re: [Excel] Map Bonus Calculator

Postby CHAMPOS on Thu May 17, 2018 1:00 am

I cannot download this from either here or the gameplay section, can it be uploaded?
...boogie
User avatar
Corporal 1st Class CHAMPOS
 
Posts: 104
Joined: Sat Jun 24, 2006 1:58 am
Location: exeter, uk
Medals: 5
Standard Achievement (2) Freestyle Achievement (2) Speed Achievement (1)

Re: [Excel] Map Bonus Calculator

Postby iancanton on Fri May 18, 2018 5:28 pm

although i no longer have an easily-accessible copy of the original spreadsheet, which hasn't been used by foundry staff for years, i'll upload a modified version in the next day or two. thanks for having alerted me to the lack of a working link.

ian. :)
Image
User avatar
Brigadier iancanton
Foundry Foreman
Foundry Foreman
 
Posts: 2029
Joined: Fri Jun 01, 2007 5:40 am
Location: europe
Medals: 73
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (3) Manual Troops Achievement (1)
Freestyle Achievement (2) Nuclear Spoils Achievement (1) Fog of War Achievement (3) Trench Warfare Achievement (1) Teammate Achievement (2)
Random Map Achievement (2) Cross-Map Achievement (3) Ratings Achievement (4) General Achievement (7) Clan Achievement (17)
General Contribution (20)

Re: [Excel] Map Bonus Calculator

Postby TeeGee on Sun May 20, 2018 12:44 am

I asked admin if there was a copy in the archives, unfortunately not found at this stage.
Image
User avatar
Major TeeGee
 
Posts: 4665
Joined: Sat Nov 11, 2006 5:07 pm
Location: Back in the Big Smoke, Vic, AUS.
Medals: 95
Conquer Cup Silver Achievement (1) Standard Achievement (3) Doubles Achievement (3) Triples Achievement (4) Quadruples Achievement (4)
Terminator Achievement (1) Assassin Achievement (2) Manual Troops Achievement (1) Freestyle Achievement (3) Polymorphic Achievement (1)
Nuclear Spoils Achievement (2) Fog of War Achievement (4) Trench Warfare Achievement (2) Speed Achievement (1) Teammate Achievement (3)
Random Map Achievement (2) Cross-Map Achievement (3) Beta Map Achievement (1) Battle Royale Achievement (1) Ratings Achievement (3)
Tournament Achievement (5) General Achievement (7) Clan Achievement (16) Challenge Achievement (2) Tribe Achievement (3)
Tournament Contribution (2) General Contribution (15)

Re: [Excel] Map Bonus Calculator

Postby iancanton on Sun May 20, 2018 6:01 pm

thanks for trying, TeeGee!

i've uploaded a spreadsheet that can be used to suggest bonus values and shall be happy to answer any questions that arise.

ian. :)
Attachments
bonuscalc-20180520.xlsx
(5.92 KiB) Downloaded 12 times
Image
User avatar
Brigadier iancanton
Foundry Foreman
Foundry Foreman
 
Posts: 2029
Joined: Fri Jun 01, 2007 5:40 am
Location: europe
Medals: 73
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (3) Manual Troops Achievement (1)
Freestyle Achievement (2) Nuclear Spoils Achievement (1) Fog of War Achievement (3) Trench Warfare Achievement (1) Teammate Achievement (2)
Random Map Achievement (2) Cross-Map Achievement (3) Ratings Achievement (4) General Achievement (7) Clan Achievement (17)
General Contribution (20)


Return to Tools & Guides

Who is online

Users browsing this forum: No registered users