|
Boilerman
Major Posts: 5704 Tech for hire. Cheap.  
|
|
For those that are interested I have created a spreadsheet to do the number crunching when building a conventional infantry platoon using the rules in TechManual.
Now you need to understand a few things:
First - you need to refer to the actual rules in TechManual to understand some of the things in this spreadsheet.
Second - I am not a professional programmer. Let me know if anything needs a fix and I'll try to fix it but I make no guarantees.
Third - I made a few assumptions to make this sheet. The big one is that an Anti-Mech Skill of 7 or less qualifies as anti-'Mech trained for platoon cost. I can't remember any others at the moment but if I remember I post about it.
At any rate here it is, pick it apart.
|
Avatar by Wombat. Thanks Wombat. 
 Logged
|
|
|
Weirdo
Lieutenant Colonel Posts: 12603 The Sexy MAD Strut©. Now with 93% less pants!
|
|
| Wow, this looks awesome. Thanks, man! |
The following have no place in proper conversation, as they are not words in any way: U, R, 2, and teh. THERE IS NO EXCUSE FOR USING THEM. "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 You know, Zug, it's times like these that it's clear YOU ARE A FRICKIN' GENIUS. - 97jedi "Errol, where are you going!?" "Space Hawaii is THAT way!" -Intercepted comm chatter, Battlefleet Insanity Founding member, Phacade Force Five
| Logged
|
|
|
Shadow6
Lieutenant Posts: 1461 Yer leg's off. No it's not.
|
|
| Very interseting B-Man. I'll dive into this at my next opportunity. |
The game ain't over until somebody loses a leg to the Battlearmor. Solve a man's problems with violence. Help him for a day Teach a man to solve his problems with violence. Help him for a lifetime. Avatar created by the NAIS(Wombat Surveillance Division)http://thereview.affshc.net/
| Logged
|
|
|
Weirdo
Lieutenant Colonel Posts: 12603 The Sexy MAD Strut©. Now with 93% less pants!
|
|
| Trying to work through this, it seems to work pretty good, though it doesn't list a machine gun's burst-fire effects... |
The following have no place in proper conversation, as they are not words in any way: U, R, 2, and teh. THERE IS NO EXCUSE FOR USING THEM. "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 You know, Zug, it's times like these that it's clear YOU ARE A FRICKIN' GENIUS. - 97jedi "Errol, where are you going!?" "Space Hawaii is THAT way!" -Intercepted comm chatter, Battlefleet Insanity Founding member, Phacade Force Five
| Logged
|
|
|
Boilerman
Major Posts: 5704 Tech for hire. Cheap.
|
|
| Burst fire effect for MGs only works if there are 2 or more MGs per squad. Since I couldn't figure out a way to do the cruncher based on weapons at the squad level, I did them at the platoon level, you need to have 6 or more MGs in the platoon to get the burst fire effect. |
Avatar by Wombat. Thanks Wombat.
| Logged
|
|
|
Weirdo
Lieutenant Colonel Posts: 12603 The Sexy MAD Strut©. Now with 93% less pants!
|
|
...and since a TW-legal Marian platoon has 2.5 squads in it for a max of 5 MGs, it won't come up for me.
No problem, just means I'll have to remember it myself. |
The following have no place in proper conversation, as they are not words in any way: U, R, 2, and teh. THERE IS NO EXCUSE FOR USING THEM. "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 You know, Zug, it's times like these that it's clear YOU ARE A FRICKIN' GENIUS. - 97jedi "Errol, where are you going!?" "Space Hawaii is THAT way!" -Intercepted comm chatter, Battlefleet Insanity Founding member, Phacade Force Five
| Logged
|
|
|
Boilerman
Major Posts: 5704 Tech for hire. Cheap.
|
|
| Damn Marians. Well I can't fix that one without giving the clanners a freebie or a serious addition. |
Avatar by Wombat. Thanks Wombat.
| Logged
|
|
|
Weirdo
Lieutenant Colonel Posts: 12603 The Sexy MAD Strut©. Now with 93% less pants!
|
|
Like I said, no problem. I'll just write it in the sheet myself. It's the price I pay for playing a faction that doesn't believe in grouping its infantry in numbers less than 100.  |
The following have no place in proper conversation, as they are not words in any way: U, R, 2, and teh. THERE IS NO EXCUSE FOR USING THEM. "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 You know, Zug, it's times like these that it's clear YOU ARE A FRICKIN' GENIUS. - 97jedi "Errol, where are you going!?" "Space Hawaii is THAT way!" -Intercepted comm chatter, Battlefleet Insanity Founding member, Phacade Force Five
| Logged
|
|
|
Maverick
Sergeant Posts: 189
|
|
Boilerman, this is great! I've been wanting to find one of these for a while. I've gotten started on building my own more than once, but could never seem to get around to actually finishing the sheet. Props for you! 
I did find one issue, though - if I try to equip medium recoilless rifles (either inferno or non-inferno), the sheet comes up with values of zero across the board (for cost, damage, base range, and bv). Both the light and heavy recoilless rifles work fine, but the mediums seem to be having a hiccup. Other than that, the sheet seems to work great. Thanks for sharing it with us! |
|
The complexity of a weapon is inversely proportional to the IQ of the weapon's operator. - Updated, Improved, and Expanded Murphy's Laws of Combat courtesy of Staff Sergeant Brian A. Heitman
| Logged
|
|
|
gomi
Lieutenant Posts: 1362
|
|
Excellent sheet, Boilerman.
I've also found that issue that Maverick mentioned. It affects support weapons further down the list than "Recoilless Rifle, Light, Non-Inferno C." So, medium RRs, LAWs, SRMs, etc. It's because you didn't extend the range in the macro. Currently it only does a lookup from A3 to A55 (light RR, non-inferno). Extend that range and it'll work fine. |
| Logged
|
|
|
Jellico
Lieutenant Colonel Posts: 6419
|
|
| Seeing similar problems with Clan platoons. It is not picking up on the 5 man points so using 5 support weapons is slowing down the unit and giving support weapon ranges rather than primary weapon ranges. |
| Logged
|
|
|
Boilerman
Major Posts: 5704 Tech for hire. Cheap.
|
|
I did find one issue, though - if I try to equip medium recoilless rifles (either inferno or non-inferno), the sheet comes up with values of zero across the board (for cost, damage, base range, and bv). Both the light and heavy recoilless rifles work fine, but the mediums seem to be having a hiccup. Other than that, the sheet seems to work great. Thanks for sharing it with us!
Thanks for checking it out, I'll try and fix it. Gomi looks to have found where the issue is already so fixing it shouldn't be too tough.
Seeing similar problems with Clan platoons. It is not picking up on the 5 man points so using 5 support weapons is slowing down the unit and giving support weapon ranges rather than primary weapon ranges.
Yea, I'm aware of the issues with clan units, at this point I'm not sure how to fix them though.  |
Avatar by Wombat. Thanks Wombat.
| Logged
|
|
|
Boilerman
Major Posts: 5704 Tech for hire. Cheap.
|
|
| ok, I extended the search ranges so this verion should correct the problem that Maverick reported. |
Avatar by Wombat. Thanks Wombat.
| Logged
|
|
|
