Conquer Club

[Excel] Starting Drop Spreadsheet

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

Moderator: Cartographers

Forum rules
Please read the Community Guidelines before posting.

[Excel] Starting Drop Spreadsheet

Postby thenobodies80 on Fri Aug 12, 2011 9:01 am

We all know that during the development of a map, one of the first things to check is the number of territories.
I am always bothered by having to count the possible initial drop and balance it, especially in the presence of starting positions. I know it is not difficult, but it bothers me a lot. :P

For this reason I've created a spreadsheet that calculates the possible outcome, after having selected 5 data:
- Number of regions on the map (total amount of regions)
- Number of coded neutrals (number of regions that start neutral in any case)
- Number of starting positions
- Number of regions for each starting positions *
- Underlying Neutrals (Y/N)**

Notes:
* The tool works only if all starting positions have the same number of regions (components)
**In case of underlying neutrals, the spreadsheet can be used only if ALL your starting positions have underlying neutrals.


The spreadsheet gives you the number of starting regions for each player and the overall number of neutrals on the map at the start, this for games from 2 to 8 players.
In addition, although both of them are minor things, is possible to see the final amount of territories in the starting pot (standard regions) and the number of starting positions assigned to each player.

startingdrop1.2.xlsx


I hope it helps! :P

Nobodies

p.s. Any suggestions for possible improvements are welcome
User avatar
Sergeant 1st Class thenobodies80
 
Posts: 5399
Joined: Wed Sep 05, 2007 4:30 am
Location: Milan

Re: [Excel] Starting Drop Spreadsheet

Postby Victor Sullivan on Sat Aug 13, 2011 3:53 am

Could you perhaps convert the file from .xlsx to .xls? I've got an older-school version of Excel.

-Sully
User avatar
Corporal Victor Sullivan
 
Posts: 6010
Joined: Mon Feb 08, 2010 8:17 pm
Location: Columbus, OH

Re: [Excel] Starting Drop Spreadsheet

Postby gimil on Sat Aug 13, 2011 7:43 am

Victor Sullivan wrote:Could you perhaps convert the file from .xlsx to .xls? I've got an older-school version of Excel.

-Sully


What version of Excel do you have? There should be a compatibility download available to you.
What do you know about map making, bitch?

natty_dread wrote:I was wrong


Top Score:2403
User avatar
Corporal 1st Class gimil
 
Posts: 8599
Joined: Sat Mar 03, 2007 12:42 pm
Location: United Kingdom (Scotland)

Re: [Excel] Starting Drop Spreadsheet

Postby isaiah40 on Sat Aug 13, 2011 10:33 am

Hope this helps!
Copy of StartingDrop1.0.xls
(72 KiB) Downloaded 1075 times
Lieutenant isaiah40
 
Posts: 3990
Joined: Mon Aug 27, 2007 7:14 pm

Re: [Excel] Starting Drop Spreadsheet

Postby Victor Sullivan on Sun Aug 14, 2011 1:03 pm

"The cell or chart you are trying to change is protected and therefore read-only" :(

@gimil, it won't let me open the .xlsx file in Excel, it opens up some Mac version called "Numbers", and some of the stuff doesn't translate well (though it is usable, and I can edit the cells unlike the .xls version).

-Sully
User avatar
Corporal Victor Sullivan
 
Posts: 6010
Joined: Mon Feb 08, 2010 8:17 pm
Location: Columbus, OH

Re: [Excel] Starting Drop Spreadsheet

Postby cairnswk on Sun Aug 14, 2011 2:23 pm

isaiah40 wrote:Hope this helps!
Copy of StartingDrop1.0.xls

isaiah40, why is this file password protected.
I would like to see what the calculations are in the s'sheet.

Oh, and i notice there are new Post Icon in Php above the POst a Reply screen...but they don't have mouse-over pop-ups to explain what they are.
Image
* Pearl Harbour * Waterloo * Forbidden City * Jamaica * Pot Mosbi
User avatar
Private cairnswk
 
Posts: 11510
Joined: Sat Feb 03, 2007 8:32 pm
Location: Australia

Re: [Excel] Starting Drop Spreadsheet

Postby thenobodies80 on Sun Aug 14, 2011 2:45 pm

Victor Sullivan wrote:"The cell or chart you are trying to change is protected and therefore read-only" :(


If you save it on your machine instead of just open it, then you can change the cells. Only yellow cells can be edited selectiong the appropriate numbers listed. ;)

cairnswk wrote:isaiah40, why is this file password protected.
I would like to see what the calculations are in the s'sheet.

Oh, and i notice there are new Post Icon in Php above the POst a Reply screen...but they don't have mouse-over pop-ups to explain what they are.


Isaiah can't help you with this. I'm the one who created this spreadsheet and also applied the password.
It's 1000 times better then write everywhere don't change these values or the like.
In any case I think it's up to me to decide if I want it locked or not. No? O:) ;)

Anyway, cairnswk, if you want to know how it works I can give you all the details, but privately.

About icons, thanks for letting me know, they shouldn't be available. An admin will disable them asap.

Nobodies
User avatar
Sergeant 1st Class thenobodies80
 
Posts: 5399
Joined: Wed Sep 05, 2007 4:30 am
Location: Milan

Re: [Excel] Starting Drop Spreadsheet

Postby Victor Sullivan on Sun Aug 14, 2011 2:52 pm

thenobodies80 wrote:
Victor Sullivan wrote:"The cell or chart you are trying to change is protected and therefore read-only" :(


If you save it on your machine instead of just open it, then you can change the cells.

Oh lol, well don't I feel silly? :oops:

-Sully
User avatar
Corporal Victor Sullivan
 
Posts: 6010
Joined: Mon Feb 08, 2010 8:17 pm
Location: Columbus, OH

Re: [Excel] Starting Drop Spreadsheet

Postby cairnswk on Sun Aug 14, 2011 2:58 pm

thanks tnb80 for your reply.

thenobodies80 wrote:It's 1000 times better then write everywhere don't change these values or the like.

Sorry i don't understand what you are saying here.

In any case I think it's up to me to decide if I want it locked or not. No? O:) ;)

Can i ask the reasoning behind this decision?
Image
* Pearl Harbour * Waterloo * Forbidden City * Jamaica * Pot Mosbi
User avatar
Private cairnswk
 
Posts: 11510
Joined: Sat Feb 03, 2007 8:32 pm
Location: Australia

Re: [Excel] Starting Drop Spreadsheet

Postby thenobodies80 on Sun Aug 14, 2011 3:51 pm

cairnswk wrote:thanks tnb80 for your reply.

thenobodies80 wrote:It's 1000 times better then write everywhere don't change these values or the like.

Sorry i don't understand what you are saying here.

In any case I think it's up to me to decide if I want it locked or not. No? O:) ;)

Can i ask the reasoning behind this decision?


Sure, the hidden part is full of functions and calculations, those values shouldn't be changed or the file won't work. You can't imagine how many nested functions I've used to have this working properly. ;)
With all due respect for those who want to use this file, the final user doesn't need to see how it works to use it. (if you think it's the same for the 99% of the software you can find on the web). In fact having the "code" part visible doesn't give advantages to the final users, indeed it can only be cause of errors or issues.

Btw I'm developing a better version (1.1) to fix a couple of minor errors. (the version 1.0 can be used in any case, in fact there are errors only in rare/useless cases)
I've not had so much free time to test it properly these days, but I think it will be ready in 3 or 4 days.

If you want to help me with some testing, just let me know :P
User avatar
Sergeant 1st Class thenobodies80
 
Posts: 5399
Joined: Wed Sep 05, 2007 4:30 am
Location: Milan

Re: [Excel] Starting Drop Spreadsheet

Postby cairnswk on Sun Aug 14, 2011 4:13 pm

Your reasoning is quite sound.
However, since this is CC and we have some "training" going on in relation to tools and paint programs that are used in this forum, then i really think it should not be password protected.
It should be almost like "open source".
I can appreciate what you've put into it as i do budgets etc.
But that doesn't mean you should keep it all to yourself so-to-speak, so that others can't see what is going on in the formulas etc.
Otherwise, how do people learn?
Offering it to me privately does nothing to appease anyone else who might be interested to learn about what great work you've done. :)
Image
* Pearl Harbour * Waterloo * Forbidden City * Jamaica * Pot Mosbi
User avatar
Private cairnswk
 
Posts: 11510
Joined: Sat Feb 03, 2007 8:32 pm
Location: Australia

Re: [Excel] Starting Drop Spreadsheet

Postby Victor Sullivan on Sun Aug 14, 2011 10:49 pm

I know when I open the .xlsx file in "Numbers", the password is disabled and all hidden items are revealed...

-Sully
User avatar
Corporal Victor Sullivan
 
Posts: 6010
Joined: Mon Feb 08, 2010 8:17 pm
Location: Columbus, OH

Re: [Excel] Starting Drop Spreadsheet

Postby thenobodies80 on Sun Dec 04, 2011 2:48 pm

Tool updated! Current version V1.2

What's new:

- Number of starting regions removed (not necessary)
- Added an additional editable field (number of regions for each starting position)
- Added auto validation of starting positions fields
- Changed the way data are calculated to prevent errors
- Fixed minor errors

Nobodies

startingdrop1.2.xlsx
User avatar
Sergeant 1st Class thenobodies80
 
Posts: 5399
Joined: Wed Sep 05, 2007 4:30 am
Location: Milan

Re: [Excel] Starting Drop Spreadsheet

Postby cairnswk on Wed Dec 26, 2012 3:38 pm

tnb80.
below is the drop calc for Ethiopia.
why doesn't the 2 player drop show the same as the 3 player drop, when we all know a 2 player game is divisible by 3 - 2 players and a third neutral?
Click image to enlarge.
image
Image
* Pearl Harbour * Waterloo * Forbidden City * Jamaica * Pot Mosbi
User avatar
Private cairnswk
 
Posts: 11510
Joined: Sat Feb 03, 2007 8:32 pm
Location: Australia

Re: [Excel] Starting Drop Spreadsheet

Postby thenobodies80 on Thu Dec 27, 2012 12:29 pm

Starting positions are given out evenly among the players. The neutral is not a player....why code SP if then you want them neutral? And this is why we use underlying neutral to force a not assigned SP to start as neutral.

The simple formula is something along this way: (the real one it's a bit tricker, but i'm not going to include underlying neutrals)

((Starting positions/ # of players) + (((total territories - starting positions) - neutrals)/ (# of players + K)))= starting regions for each player

where K is equal to 0 for all games except the 1vs1, where K=1 (the neutral player)


So, using your example and the formula

((SP/NPL)+(((TT-SP)-N)/(NPL+K)))

in a 1vs1 game it is:

((24/2)+((29-24)-5)/(2+1))) = 12

instead in a 1vs1vs1 game it results:

((24/3)+((29-24)-5)/(3+0))) = 8

The formula applies only if you do NOT have underlying neutrals for your starting positions.

Hope it's clear, if not, just let me know ;)
Nobodies
User avatar
Sergeant 1st Class thenobodies80
 
Posts: 5399
Joined: Wed Sep 05, 2007 4:30 am
Location: Milan

Re: [Excel] Starting Drop Spreadsheet

Postby cairnswk on Sat Jan 12, 2013 5:08 pm

tnb, can you put a divisor drop list in this or is it already there and i am just not reading it properly?
Also in the lastest version you've added the compoment function - what does that do please?
sorry to be so dumb.
Image
* Pearl Harbour * Waterloo * Forbidden City * Jamaica * Pot Mosbi
User avatar
Private cairnswk
 
Posts: 11510
Joined: Sat Feb 03, 2007 8:32 pm
Location: Australia

Re: [Excel] Starting Drop Spreadsheet

Postby thenobodies80 on Sun Jan 13, 2013 12:54 pm

What do you mean with divisor drop list?

The components are the number of territories for each starting positions. You certainly know that you can have, for example, 3 starting positions, each one with more than a single region into it.
Unfortunately, for now you can use the spreadsheet only if you have the same amount for all starting positions. So if you have 2 with 2 components and 1 with 3 components, you need to do your math manually.
I'll develop a better version in future, as soon as i have a bit of free time. So don't be afraid to ask if something is not clear or if you would like to have additional options/features into it. ;)

Nobodies
User avatar
Sergeant 1st Class thenobodies80
 
Posts: 5399
Joined: Wed Sep 05, 2007 4:30 am
Location: Milan

Re: [Excel] Starting Drop Spreadsheet

Postby cairnswk on Sun Jan 13, 2013 1:32 pm

thenobodies80 wrote:What do you mean with divisor drop list?
....
Nobodies


The divisior....normally you get +1 for every 3 territories you hold...that is with the divisor at 3.
But some maps now are having a divisior of 4...meaning if they hold 18 terrtories, they get +4, not +6.
This is to do with min/max reinforcement. :)
Image
* Pearl Harbour * Waterloo * Forbidden City * Jamaica * Pot Mosbi
User avatar
Private cairnswk
 
Posts: 11510
Joined: Sat Feb 03, 2007 8:32 pm
Location: Australia

Re: [Excel] Starting Drop Spreadsheet

Postby thenobodies80 on Sun Jan 13, 2013 3:31 pm

Oh, now i understand. Yes it can be added something like that...it is a simple thing.

But this tool doesn't count the number of troops you start with, but the number of regions.
User avatar
Sergeant 1st Class thenobodies80
 
Posts: 5399
Joined: Wed Sep 05, 2007 4:30 am
Location: Milan


Return to Tools & Guides

Who is online

Users browsing this forum: No registered users

cron