Mass Combat Spreadsheet

[Grey_Fox]

Spoiler:  

The other day I saw someone asking if anyone had done a spreadsheet for Mass Combat, I have created one, its pretty simple but it is handy, makes creation of armies a lot easier, and handles some basics of the battle stuff. I have uploaded it here:

(see below)

Also if anyone has any suggestions as to how to improve it, or if you find a bug let me know and I will fix it.

*note its a .xlsx file so It may have some problems with data validation on older versions of excel.

Happy Gaming

OK made some fix ups, was a typo and some data validation changes, now works fine on the older excel versions, get the new one (see Below).

EDIT:
Hey guys, fell of the planet for a while but i am back now and reviewing my old stuff for a new game, as such i have dusted off my MC spreadsheet and updated it alot
<Link no longer available> Lots of changes, added the options for picking strategies, changed some colors around and updated the units as per the errata, as always if you find a bug let me know and i will fix it, Happy Gaming!
EDIT:
Made some changes to the formulas, they should calculate correctly now. Also added the example army to the TL0-5 army page
<Link no longer available>
As always any errors let me know
EDIT:
Made a fix for C3I units, now they dont add to TS if they are support
<Link no longer available>
EDIT:
Revanche has made some great fixes, available here
<Link no longer available>

EDIT:
Updated Link
Latest Version

[Grey_Fox]

Spoiler:  

there is a .xls version for anyone who doesnt have a newer version of excel, fair warning though only the first page has data validation rules(the dropdown lists for units and troop quality etc) set up because of the way old excel does things.

EDIT: Removed bad old links. See above, ingore this post

[vicky_molokh]

Just curious: how about converting to Google Docs? Anyway, will check it out when I get to my computer.

[Grey_Fox]

Spoiler:  

there is a link to a .xls version on google docs, i have managed to fix the data validation problem with the old version.

I would prefer not to convert it to the google docs spreadsheet as i am not familiar with it and there is a bit of stuff that this sheet does in the background

new version ignore this post

EDIT: Removed bad old link

[Blind Mapmaker]

I tried the old excel version and the TL 0-5 page works like a charm. There's only a small glitch: I get the specials first when I click on the element drop-down box. When I directly click on the cell after that it shows the element drop-down correctly.

I'm not sure about what the problem is you talk about. Would it be possible to make a separate TL 6+ file that has working selections and stuff? This looks really useful and I'm sure I won't be the only one to appreciate it.

Thanks for making it available.

[Grey_Fox]

New version with a typo fixed, Here

[safisher]

Thank you! This is great. If you want to expand it, look at the Spaceships in Mass combat article in Pyramid. It would be very neat to integrate them. Thanks!

[Metaphysica]

Hey, I was about to run my first mass combat battle, and I thought there would probably be a pretty great spreadsheet out there for the mass combat sheets, and, viola, Grey Fox provides!

Two questions, what dark magick did you use to hide the sheets with the element information? I'd love to add my own weird elements, and make minor changes on the official ones from the books. Looking at the sheet you've used a VLOOKUP to search through a sheet called "TLX-X Elements." I cannot for the life of me unhide that sheet. Excel insists there's nothing hidden. Anyway we can get a version of the sheet with that exposed, or can you walk me through unhiding it?

Second, I'm not following how you're calculating TS as a result of Support Elements (with TS in parentheses in the book). The spreadsheet seems to counting Support classes as only contributing to their special class TS. If I understand the book correctly they should add their full TS to their special class, and 10% of their TS to the Total TS. For example, the AEW is TS (5000), it should add 500 to the total TS and 5000 to the Air Support TS. I double checked the examples in the back and they seem to be done this way.

Is that an error or am I missing something?

Thanks for the work on this, it's great!

Keith

[Grey_Fox]

Glad you like the sheet Metaphysica =)

Where is the 10% TS thing for the support units mentioned in MC, i was working on the description from the front of the book "It means that the element’s TS can only be used when calculating special class superiority – never when determining the TS ratio". Looking at the example of the modern force in the back it is set up the same way, if you add all the values for the non-parenthesis units they add up to the total TS, so i may be doing it wrong but i don't think i am, point me to a page and i will double check myself though.

[vierasmarius]

Originally Posted by Grey_Fox

Glad you like the sheet Metaphysica =)

Where is the 10% TS thing for the support units mentioned in MC, i was working on the description from the front of the book "It means that the element’s TS can only be used when calculating special class superiority – never when determining the TS ratio". Looking at the example of the modern force in the back it is set up the same way, if you add all the values for the non-parenthesis units they add up to the total TS, so i may be doing it wrong but i don't think i am, point me to a page and i will double check myself though.

I think the 10% TS is a houserule that's been bandied about on the forum. It's supposed to deal with situations like a TL8 Heavy Weapons squad being instantly overrun by TL3 Medium Infantry, simply because they have an actual TS and the HW doesn't.