Author Topic: Infantry Platoon Creation Spreadsheet  (Read 4547 times)

boilerman

  • Warrant Officer
  • *
  • Posts: 654
  • Spinning wrenches since 1968.
Infantry Platoon Creation Spreadsheet
« on: 05 May 2013, 01:36:39 »
Hello.

I've updated my conventional infantry platoon creation spreadsheet.  Since it is so big, 614kb, I have stored it at box.com.  You can download it by going to the link below.

https://www.box.com/s/8ns4cgbyrnakidviq0vn

The instruction pdf:
https://www.box.com/s/2zmimm0ve5gvpxd08jvw
« Last Edit: 10 June 2013, 23:50:55 by boilerman »
Avatar by Wombat. Thanks Wombat!

Maelwys

  • Major
  • *
  • Posts: 4067
Re: Infantry Platoon Creation Spreadsheet
« Reply #1 on: 05 May 2013, 20:08:04 »
A 30 man WoB (WoB Armor and Mauser 1200) Jump Platoon with A-M training is 93 million and change.

Suddenly infantry doesn't seem like that cheap alternative to `Mechs :)

truetanker

  • Major
  • *
  • Posts: 4492
  • Clan Hells Horses 666th Mech. Assualt Cluster
Re: Infantry Platoon Creation Spreadsheet
« Reply #2 on: 05 May 2013, 21:48:38 »
Unable to complete...

Is there a user manual?

[edit:1] Still unable to get past 24 soldiers @ 6 per 4 Squad. Any ideas how?
[edit:2] How can I custom the Infantry numbers if the blue user inputs won't allow it? Won't allow me to enter names either.

TT
« Last Edit: 08 May 2013, 19:55:32 by truetanker »
Khan,Clan Iron Dolphin
Azeroth Pocketverse

That is, if true tanker doesn't beat me to it. He makes truly evil units.Col.Hengist on 31 May 2013
TT, we know you are the master of nasty  O0 ~ Fletch on 22 June 2013
If I'm attacking you, conventional wisom says to bring 3x your force.  I want extra insurance, so I'll bring 4 for every 1 of what you have :D ~ Tai Dai Cultist on 21 April 2016
Me: Would you rather fight my Epithymía Thanátou from the Whispers of Blake?
Nav_Alpha: That THING... that is horrid
~ Nav_Alpha on 10 October 2016

boilerman

  • Warrant Officer
  • *
  • Posts: 654
  • Spinning wrenches since 1968.
Re: Infantry Platoon Creation Spreadsheet
« Reply #3 on: 05 May 2013, 22:16:19 »
Yes, I think I better write on.  I'll try and have something posted tomorrow.
Avatar by Wombat. Thanks Wombat!

worktroll

  • Oldest and fatherless
  • Ombudsman
  • Colonel
  • *
  • Posts: 18861
  • 504th "Gateway" Division
    • There are Monsters in my Sky!
Re: Infantry Platoon Creation Spreadsheet
« Reply #4 on: 05 May 2013, 22:47:08 »
THis is great!

I had to remember to "enable editing" in Office 2010, and when saving it complained about links to "TacOps_IPCR", but I found it easy to use and worked well.

Many thanks!
* No, FASA wasn't big on errata - ColBosch
* The Housebook series is from the 80's and is the foundation of Btech, the 80's heart wrapped in heavy metal that beats to this day - Sigma
* To sum it up: FASAnomics: By Cthulhu, for Cthulhu - Moonsword
* Because Battletech is a conspiracy by Habsburg & Bourbon pretenders - MadCapellan
* The Hellbringer is cool, either way. It's not cool because it's bad, it's cool because it's bad with balls - Nightsky
* It was a glorious time for people who felt that we didn't have enough Marauder variants - HABeas2, re "Empires Aflame"

boilerman

  • Warrant Officer
  • *
  • Posts: 654
  • Spinning wrenches since 1968.
Re: Infantry Platoon Creation Spreadsheet
« Reply #5 on: 06 May 2013, 00:19:37 »
THis is great!

I had to remember to "enable editing" in Office 2010, and when saving it complained about links to "TacOps_IPCR", but I found it easy to use and worked well.

Many thanks!
I thought I fixed that "TacOps" thing.  Looks like I have my first fix.  Of course if you find any more please post them here and I try and fix them.

And FYI for those that don't know there are a number of user defined functions in the spreadsheet so you must enable macros.

I also set the TRO worksheet up so that you can copy and paste it into another spreadsheet to save it.
Avatar by Wombat. Thanks Wombat!

Weirdo

  • Painter of Borth the Magic Puma
  • Global Moderator
  • Lieutenant General
  • *
  • Posts: 28978
Re: Infantry Platoon Creation Spreadsheet
« Reply #6 on: 06 May 2013, 00:39:35 »
Sweet, an update to this most excellent spreadsheet! Any extra functions/options since your last version?
"Thanks to Megamek, I can finally play BattleTech the way it was meant to be played--pantsless!"   -Neko Bijin
"It's just that the Hegemony had one answer to every naval problem. 'I kills it with my battleships.'" - Liam's Ghost
"...finally, giant space panties don't seem so strange." - Whistler
"The BT universe is startlingly deficient in both wisdom and hindsight." - Cray
"Damn you, Weirdo... Damn you for being right!" - Paul
Battleforce Space is too bulky. I vote we start calling it BattleFace.

Maelwys

  • Major
  • *
  • Posts: 4067
Re: Infantry Platoon Creation Spreadsheet
« Reply #7 on: 06 May 2013, 00:50:44 »
The various BVs seem slightly off. For instance, I have a Jump Capable platoon of 30 men (5 squads of 6 men), armed with Mauser 1200s and the WoB Infantry Armor Kit.  Not Anti-Mech trained at all.

The BV on the TacOps_ICR worksheet is 201. No clue if that's right or not.

But when I go to the BV worksheet, the BV is listed as 236.

When I set it to A-M Trained with a skill of 5, the BV on TacOps_ICR changes to 236. The BV on the BV page remains the same at 236.

However, the A-M Battle Rating on the BV worksheet remains the same at 0.00. It doesn't change when I turn on the AM training.

I'm also not sure whats going on, but on the TacOps_IPCR Worksheet there's a couple of IF statements in B12, C12, D12 and F12 that show some results, but I have no idea what they are (looks like something to do with displaying certain lists, and certain values if using Beast mounted infantry or something).

And a small suggestion. Put the BV worksheet either before or after the TRO page, instead of all the way at the end. People are more likely to look at that rather than 10 pages of data :)

boilerman

  • Warrant Officer
  • *
  • Posts: 654
  • Spinning wrenches since 1968.
Re: Infantry Platoon Creation Spreadsheet
« Reply #8 on: 06 May 2013, 01:24:42 »
This workbook was created to do the basic number crunching for creating BattleTech conventional infantry platoons using the rules in TechManual & Tactical Operations. To fully understand how this spreadsheet works you should be familiar with those rules since this workbook does not prevent construction rules violations. 

There are only 20 real inputs in this spreadsheet: 17 pulldown menus & 4 number inputs.  Pulldown menus:
   Infantry Type,
   Infantry Specialty,
   Engineering Specialty,
   XCT Training category,
   Gunnery Skill TN,
   Secondary Weapons Per Squad,
   Anti-‘Mech Attack Equipment,
   Anti-‘Mech Skill TN,
   Primary Weapon Type & Model,
   Secondary Weapon Type & Model,
   Disposable Weapon Model,
   Field Gun/Field Artillery Model,
   Infantry Armor Type,
   Riding Beast Species.

Numerical Inputs:
   Soldiers Per Squad/Riding Beasts Per Platoon
   Number of Squads,
   Paramedics Assigned,
   Number of Field Guns/Field Artillery.

Title blocks for unit name and notable units are also provided for the TRO.

There are approximately 40 user defined functions in this spreadsheet so you will have to have macros enabled for it to function.  I have utilized conditional formatting to grey out or highlight different cells based on selections to help guide the creation process. 

Note when selecting the Beast Mounted platoon type 2 cells automatically go red.  They will not change color until a riding beast species is chosen in the Beast Mounted Infantry stats block further down the worksheet.  This is because certain parameters of a beast mounted platoon are based on the size of the animal.  Field guns and field artillery work similarly.

There are several things you need to understand concerning the anti-‘Mech capability in this spreadsheet.  Of course the basic capability is based on infantry platoon type, but in the latest version of the TechManual errata something has been added; if a platoon is capable, but not trained or equipped its mass and BV are adjusted. 

All infantry types capable of anti-‘Mech attacks have had their individual soldier masses reduced by 15kg.  If a soldier is anti-‘Mech attack trained and equipped the soldier’s mass increases 15kg.  In the spreadsheet the default is to assume that if the basic platoon type is capable of anti-‘Mech attacks it is equipped and trained, which effects cost.  In the Anti-‘Mech Training block you must chose “No” on the Equipped dropdown menu to adjust the mass and cost of the platoon down.  If an infantry armor type is chosen that is encumbering the anti-‘Mech stats will adjust accordingly.

This spreadsheet calculates Battle Values, the base, and adjusted.  The base BV is standard design BV, which is in turn based of a gunnery skill of 4 and an anti-‘Mech skill of 5.  If a platoon is anti-‘Mech capable but not trained or equipped the base BV is adjusted down in accordance with the TechManual errata v3.1.  The adjusted BV is of course adjusted based on the platoons gunnery and anti-‘Mech skill levels input via their respectively dropdown lists.

One of my goals with this latest version of the sheet was to have it create a canon style TRO automatically so all you had to do was copy and paste it into sheet or a word document for saving.  I’ve come really close.  You will need to manually bold parts of the text to exactly copy the canon TRO.  I have also added some lines, to reflect such things as disposable weapons, which are used in the published platoons so far.

I cannot say everything is 100% accurate, but I have worked pretty hard to follow the design calculation process exactly.  Please let me know if you see problems and I will try to resolve them as quickly as I can.

All constructive criticism is appreciated.  Enjoy.

Duane “Boilerman” Bywaters

battletech.boilerman@gmail.com

5/6/2013



A few other things:
Some of the damage values and BV values for the weapons might not be accurate.  I tried to verify everything, and Herb can attest to the fact that I badgered him quite a few times about infantry weapon stats but I may have missed something.  I do plan on going through the stats again ASAP.  On the various equipment pages I have put in some of my own equipment stats.  Most of the ones added just changed the name and availability dates.  By the way, my “Battle Rifle” is simply an M&G G-150 rifle with a larger magazine.  I use it to represent something like an M14 or FN FAL.

I think that will get you started.  I will try to flesh this out over the next few days or so to make it more complete.  Just remember the key things are the dropdown menus and number inputs for “Squad per Squad,” “Number of Squads” and “Paramedics Assigned” and for beasts and field guns when those options are selected.
« Last Edit: 06 May 2013, 13:18:56 by boilerman »
Avatar by Wombat. Thanks Wombat!

boilerman

  • Warrant Officer
  • *
  • Posts: 654
  • Spinning wrenches since 1968.
Re: Infantry Platoon Creation Spreadsheet
« Reply #9 on: 06 May 2013, 02:20:07 »
The various BVs seem slightly off. For instance, I have a Jump Capable platoon of 30 men (5 squads of 6 men), armed with Mauser 1200s and the WoB Infantry Armor Kit.  Not Anti-Mech trained at all.

The BV on the TacOps_ICR worksheet is 201. No clue if that's right or not.

But when I go to the BV worksheet, the BV is listed as 236.

When I set it to A-M Trained with a skill of 5, the BV on TacOps_ICR changes to 236. The BV on the BV page remains the same at 236.

However, the A-M Battle Rating on the BV worksheet remains the same at 0.00. It doesn't change when I turn on the AM training.

I'm also not sure whats going on, but on the TacOps_IPCR Worksheet there's a couple of IF statements in B12, C12, D12 and F12 that show some results, but I have no idea what they are (looks like something to do with displaying certain lists, and certain values if using Beast mounted infantry or something).

And a small suggestion. Put the BV worksheet either before or after the TRO page, instead of all the way at the end. People are more likely to look at that rather than 10 pages of data :)
Better disregard BV numbers for now.   those cells on row 12 do provide input for some cells.  Right clip on the worksheet tab and you can move the worksheet tab any where you like.
« Last Edit: 06 May 2013, 02:22:43 by boilerman »
Avatar by Wombat. Thanks Wombat!

mbear

  • Stood Far Back When The Gravitas Was Handed Out
  • Captain
  • *
  • Posts: 2994
    • Tower of Jade
Re: Infantry Platoon Creation Spreadsheet
« Reply #10 on: 06 May 2013, 08:19:15 »
This is cool! Thanks!

Although I tried to idiot proof this sheet
Every time I've tried that at work, someone's invented a better idiot. :)

Probably won't run into that here though.

boilerman

  • Warrant Officer
  • *
  • Posts: 654
  • Spinning wrenches since 1968.
Re: Infantry Platoon Creation Spreadsheet
« Reply #11 on: 07 May 2013, 22:32:48 »
Updated, I think I have BV working properly now.  I have also updated weapon damage values and BV.  The link below will take you to version 4K3.

https://www.box.com/s/2998kzv89gksh91jqjfn

The instruction pdf:
https://www.box.com/s/2zmimm0ve5gvpxd08jvw

Sweet, an update to this most excellent spreadsheet! Any extra functions/options since your last version?
Got several little details fixed.  BV should work now, beast-mounts should work.  I'm sure there are several things I'm missing since I don't remember what didn't work before I dug back into this project.
Avatar by Wombat. Thanks Wombat!

worktroll

  • Oldest and fatherless
  • Ombudsman
  • Colonel
  • *
  • Posts: 18861
  • 504th "Gateway" Division
    • There are Monsters in my Sky!
Re: Infantry Platoon Creation Spreadsheet
« Reply #12 on: 07 May 2013, 22:57:23 »
Boilermaker,

Got the new version, love it!

I do note that it's no longer possible for one man with a heavy crossbow to score "golden BB" hits on 'Mechs; you need at least 14 ;) Have yet to explore the wonders of mechanised & beast-mounted infantry, which have always been in the "too hard" basket previously.

Many thanks!
* No, FASA wasn't big on errata - ColBosch
* The Housebook series is from the 80's and is the foundation of Btech, the 80's heart wrapped in heavy metal that beats to this day - Sigma
* To sum it up: FASAnomics: By Cthulhu, for Cthulhu - Moonsword
* Because Battletech is a conspiracy by Habsburg & Bourbon pretenders - MadCapellan
* The Hellbringer is cool, either way. It's not cool because it's bad, it's cool because it's bad with balls - Nightsky
* It was a glorious time for people who felt that we didn't have enough Marauder variants - HABeas2, re "Empires Aflame"

hive_angel

  • Lieutenant
  • *
  • Posts: 1209
  • A, B, C, D, E, F, Guy ...
    • Send Three Squads To Help
Re: Infantry Platoon Creation Spreadsheet
« Reply #13 on: 08 May 2013, 08:31:10 »
Link is not working for me? Try Google Docs?
Follow my blog for Battletech battle reports!

http://ststh.blogspot.com

Search for "Battle Report"

boilerman

  • Warrant Officer
  • *
  • Posts: 654
  • Spinning wrenches since 1968.
Re: Infantry Platoon Creation Spreadsheet
« Reply #14 on: 08 May 2013, 09:16:48 »
Should work now.  Changed the links in the first post.
Avatar by Wombat. Thanks Wombat!

Marwynn

  • Major
  • *
  • Posts: 3975
Re: Infantry Platoon Creation Spreadsheet
« Reply #15 on: 08 May 2013, 10:03:23 »
Ooh, this looks nifty! Thanks boilerman, will play around with this when I get home.

worktroll

  • Oldest and fatherless
  • Ombudsman
  • Colonel
  • *
  • Posts: 18861
  • 504th "Gateway" Division
    • There are Monsters in my Sky!
Re: Infantry Platoon Creation Spreadsheet
« Reply #16 on: 16 May 2013, 23:04:40 »
Boilerman,

This couldn't have been better timed. I've been working to build out some of my 'Mech companies into combined-arms battalions. This has involved much fun with DA infantry stands ;) Your spreadsheet has been a delight to use to try and work out what my custom platoons can do in the game.

A couple of questions, which may be based on my lack of complete comprehension of the infantry construction rules, and not the fault of your spreadsheet:

1) Took a while for me to realise that field gun platoons need to be Motorised (I was thinking they'd be Foot, and need a carrier vehicle, but this is completely sensible in-game). Consider the situation: I have a platoon of 4 squads of 7 men each. Each squad has one LAC-5, for a total of 5 per platoon. SO what we have in "reality" is 20 men serving the guns, and 8 standing around with rifles.

Question: the Standard Weapon damage (roes 63 and 68) seems to calculate standard weapons damage as if all 28 were firing their rifles, where I'd have expected it to be much lower. Is this an artifact of the rules (eg. you either fire the rifles or fire the LAC), or a potential enhancement?

2) IIRC, there are some rules addressing encumbrance on infantry - things that happen if you have more than one support weapon per squad, things that happen if you have heavy armour. Any chance of having these sort of effects listed in the "Special Effects & Notes" section row 42 and under?

I use Excel a lot at work, and figured I was pretty hot with it, but this is marvellously insane! Thanks for all the work.

Cheers,

W.
* No, FASA wasn't big on errata - ColBosch
* The Housebook series is from the 80's and is the foundation of Btech, the 80's heart wrapped in heavy metal that beats to this day - Sigma
* To sum it up: FASAnomics: By Cthulhu, for Cthulhu - Moonsword
* Because Battletech is a conspiracy by Habsburg & Bourbon pretenders - MadCapellan
* The Hellbringer is cool, either way. It's not cool because it's bad, it's cool because it's bad with balls - Nightsky
* It was a glorious time for people who felt that we didn't have enough Marauder variants - HABeas2, re "Empires Aflame"

Weirdo

  • Painter of Borth the Magic Puma
  • Global Moderator
  • Lieutenant General
  • *
  • Posts: 28978
Re: Infantry Platoon Creation Spreadsheet
« Reply #17 on: 17 May 2013, 09:28:48 »
1) Took a while for me to realise that field gun platoons need to be Motorised (I was thinking they'd be Foot, and need a carrier vehicle, but this is completely sensible in-game). Consider the situation: I have a platoon of 4 squads of 7 men each. Each squad has one LAC-5, for a total of 5 per platoon. SO what we have in "reality" is 20 men serving the guns, and 8 standing around with rifles.

Question: the Standard Weapon damage (roes 63 and 68) seems to calculate standard weapons damage as if all 28 were firing their rifles, where I'd have expected it to be much lower. Is this an artifact of the rules (eg. you either fire the rifles or fire the LAC), or a potential enhancement?

This is indeed a rules thing. You are correct in that a platoon can choose to fire their field guns *or* their normal guns in a given turn but not both, and whichever one is fired has the firepower associated wil the full current strength of the platoon.

Heck, I think Motor platoons with field guns can even choose to do anti-mech attacks if they want! (Would not be surprised if a rule does exist prohibiting it that I've forgotten.)
"Thanks to Megamek, I can finally play BattleTech the way it was meant to be played--pantsless!"   -Neko Bijin
"It's just that the Hegemony had one answer to every naval problem. 'I kills it with my battleships.'" - Liam's Ghost
"...finally, giant space panties don't seem so strange." - Whistler
"The BT universe is startlingly deficient in both wisdom and hindsight." - Cray
"Damn you, Weirdo... Damn you for being right!" - Paul
Battleforce Space is too bulky. I vote we start calling it BattleFace.

Martius

  • Captain
  • *
  • Posts: 1746
Re: Infantry Platoon Creation Spreadsheet
« Reply #18 on: 17 May 2013, 09:48:03 »
It is also good to know that while shooting their rifles infantry can ignore stealth armour (but not mimetic) but the field guns are affected by it normally.

boilerman

  • Warrant Officer
  • *
  • Posts: 654
  • Spinning wrenches since 1968.
Re: Infantry Platoon Creation Spreadsheet
« Reply #19 on: 17 May 2013, 14:35:46 »
Thanks for the comments guys.  WT as Weirdo said, it's either fire the big guns or the infantry weapons, not both, regardless of how many people are required to handle the big guns.

As for encumbrance, putting a note to that effect in the notes line would be useful in my opinion.  I'll see how I can put it in.  Another school semester has started though so it might be a little while before I can get to it.

And as far as I know, yes a motorized platoon of field guns or field artillery is capable of anti-Mech attacks.
Avatar by Wombat. Thanks Wombat!

Weirdo

  • Painter of Borth the Magic Puma
  • Global Moderator
  • Lieutenant General
  • *
  • Posts: 28978
Re: Infantry Platoon Creation Spreadsheet
« Reply #20 on: 17 May 2013, 14:38:13 »
And as far as I know, yes a motorized platoon of field guns or field artillery is capable of anti-Mech attacks.

Sweet. Now to get some use in before a rules dev notices the obvious problem here and prohibits them from using said field guns during a swarm. [skull]
"Thanks to Megamek, I can finally play BattleTech the way it was meant to be played--pantsless!"   -Neko Bijin
"It's just that the Hegemony had one answer to every naval problem. 'I kills it with my battleships.'" - Liam's Ghost
"...finally, giant space panties don't seem so strange." - Whistler
"The BT universe is startlingly deficient in both wisdom and hindsight." - Cray
"Damn you, Weirdo... Damn you for being right!" - Paul
Battleforce Space is too bulky. I vote we start calling it BattleFace.

worktroll

  • Oldest and fatherless
  • Ombudsman
  • Colonel
  • *
  • Posts: 18861
  • 504th "Gateway" Division
    • There are Monsters in my Sky!
Re: Infantry Platoon Creation Spreadsheet
« Reply #21 on: 17 May 2013, 16:30:44 »
And as far as I know, yes a motorized platoon of field guns or field artillery is capable of anti-Mech attacks.

Thanks, Boilerman. Consider yourself a class example of the good that happens when fans decide to take on one of the more obscure corners of the BT universe, and decide "Ask not what Battletech can do for me ..."  O0
* No, FASA wasn't big on errata - ColBosch
* The Housebook series is from the 80's and is the foundation of Btech, the 80's heart wrapped in heavy metal that beats to this day - Sigma
* To sum it up: FASAnomics: By Cthulhu, for Cthulhu - Moonsword
* Because Battletech is a conspiracy by Habsburg & Bourbon pretenders - MadCapellan
* The Hellbringer is cool, either way. It's not cool because it's bad, it's cool because it's bad with balls - Nightsky
* It was a glorious time for people who felt that we didn't have enough Marauder variants - HABeas2, re "Empires Aflame"

Paul

  • dies a lot at the Solaris Melee Challenge!
  • Battletech Volunteer
  • Lieutenant Colonel
  • *
  • Posts: 12518
Re: Infantry Platoon Creation Spreadsheet
« Reply #22 on: 17 May 2013, 16:40:03 »
Sweet. Now to get some use in before a rules dev notices the obvious problem here and prohibits them from using said field guns during a swarm. [skull]

Oh, look what time it is: TW errata time.

Weirdo

  • Painter of Borth the Magic Puma
  • Global Moderator
  • Lieutenant General
  • *
  • Posts: 28978
Re: Infantry Platoon Creation Spreadsheet
« Reply #23 on: 17 May 2013, 16:41:08 »
Take your time. Field guns are TacOps.
"Thanks to Megamek, I can finally play BattleTech the way it was meant to be played--pantsless!"   -Neko Bijin
"It's just that the Hegemony had one answer to every naval problem. 'I kills it with my battleships.'" - Liam's Ghost
"...finally, giant space panties don't seem so strange." - Whistler
"The BT universe is startlingly deficient in both wisdom and hindsight." - Cray
"Damn you, Weirdo... Damn you for being right!" - Paul
Battleforce Space is too bulky. I vote we start calling it BattleFace.

Paul

  • dies a lot at the Solaris Melee Challenge!
  • Battletech Volunteer
  • Lieutenant Colonel
  • *
  • Posts: 12518
Re: Infantry Platoon Creation Spreadsheet
« Reply #24 on: 17 May 2013, 16:44:49 »
Take your time. Field guns are TacOps.

This will only briefly delay me.  O:-)

worktroll

  • Oldest and fatherless
  • Ombudsman
  • Colonel
  • *
  • Posts: 18861
  • 504th "Gateway" Division
    • There are Monsters in my Sky!
Re: Infantry Platoon Creation Spreadsheet
« Reply #25 on: 17 May 2013, 19:27:01 »
Sweet. Now to get some use in before a rules dev notices the obvious problem here and prohibits them from using said field guns during a swarm. [skull]

Done!

* No, FASA wasn't big on errata - ColBosch
* The Housebook series is from the 80's and is the foundation of Btech, the 80's heart wrapped in heavy metal that beats to this day - Sigma
* To sum it up: FASAnomics: By Cthulhu, for Cthulhu - Moonsword
* Because Battletech is a conspiracy by Habsburg & Bourbon pretenders - MadCapellan
* The Hellbringer is cool, either way. It's not cool because it's bad, it's cool because it's bad with balls - Nightsky
* It was a glorious time for people who felt that we didn't have enough Marauder variants - HABeas2, re "Empires Aflame"

boilerman

  • Warrant Officer
  • *
  • Posts: 654
  • Spinning wrenches since 1968.
Re: Infantry Platoon Creation Spreadsheet
« Reply #26 on: 18 May 2013, 00:45:40 »
Cool work WT.   O0

I've bee working on another spreadsheet project.  It's a TO&E sheet.  It's a big one, payroll, calculates unit quality and sums up combat asset values for contract purposes using the IO betas that were posted a few months ago: to name a few features.  I'm still working on the maintenance requirements.  I hope to polish it for posting in the next month or two, school work permitting.
Avatar by Wombat. Thanks Wombat!

boilerman

  • Warrant Officer
  • *
  • Posts: 654
  • Spinning wrenches since 1968.
Re: Infantry Platoon Creation Spreadsheet
« Reply #27 on: 10 June 2013, 23:59:47 »
I've updated the sheet to correct a couple of problems I discovered when playing around with it.  The platoon cost listed in the TRO was incorrect.  For the moment I have disabled a function that modified the cost for the TRO.  It adds the commas to make it look neat but it's having problems cutting up the value.  The other fix solved the problem with creating combat engineering units other than foot infantry.  Had to fully implement some changes I made before I posted the last version, got distracted and didn't complete the job.  Sorry worktroll I will get to modifying the sheet as you recommended, it's just going to take a bit more than I thought it would.

https://www.box.com/s/8ns4cgbyrnakidviq0vn

The link at the top of the thread has been changed as well.  Both take you to the V4K3B version.
Avatar by Wombat. Thanks Wombat!

worktroll

  • Oldest and fatherless
  • Ombudsman
  • Colonel
  • *
  • Posts: 18861
  • 504th "Gateway" Division
    • There are Monsters in my Sky!
Re: Infantry Platoon Creation Spreadsheet
« Reply #28 on: 11 June 2013, 00:40:19 »
Downloaded, and will give it a whirl.

One (or two?) other request. At the moment, even though you have the maxium squad size and maximum platoon size on the "Infantry TRO Types" tab (B4-C23), I can quite easily (for example) have a platoon of foot/mountain troops with 4 squads of 15 men each for 60 troopers, when the "legal limits' are 10 men/squad and 20 men total. Don't know how hard it would be to put the limits in the "V" column as read-only , eg.
V5 "Max"
V6 max soldiers per squad
V7 Max number of squads (being max platoon size / current squad size, U6)
V8 max platoon size

and to have the values in U6 and U8 go red if the limit is exceeded.

Just a thought, and thanks again,

W.
* No, FASA wasn't big on errata - ColBosch
* The Housebook series is from the 80's and is the foundation of Btech, the 80's heart wrapped in heavy metal that beats to this day - Sigma
* To sum it up: FASAnomics: By Cthulhu, for Cthulhu - Moonsword
* Because Battletech is a conspiracy by Habsburg & Bourbon pretenders - MadCapellan
* The Hellbringer is cool, either way. It's not cool because it's bad, it's cool because it's bad with balls - Nightsky
* It was a glorious time for people who felt that we didn't have enough Marauder variants - HABeas2, re "Empires Aflame"

Terminax

  • Lieutenant
  • *
  • Posts: 1065
  • Never despair. Never surrender.
Re: Infantry Platoon Creation Spreadsheet
« Reply #29 on: 11 June 2013, 09:33:38 »
Can we get the various Clan ACs for field guns?

 

Register