|
Boilerman
Major Posts: 6028 Boom & Zoom on the 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.
|
 Logged
|
|
|
Weirdo
Colonel Posts: 13893 The Sexy MAD Strut©. We're back, baby!
|
|
| 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: 1483 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
Colonel Posts: 13893 The Sexy MAD Strut©. We're back, baby!
|
|
| 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: 6028 Boom & Zoom on the 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. |
| Logged
|
|
|
Weirdo
Colonel Posts: 13893 The Sexy MAD Strut©. We're back, baby!
|
|
...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: 6028 Boom & Zoom on the Cheap
|
|
| Damn Marians. Well I can't fix that one without giving the clanners a freebie or a serious addition. |
| Logged
|
|
|
Weirdo
Colonel Posts: 13893 The Sexy MAD Strut©. We're back, baby!
|
|
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: 192
|
|
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: 1443
|
|
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: 6855
|
|
| 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: 6028 Boom & Zoom on the 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.  |
| Logged
|
|
|
Boilerman
Major Posts: 6028 Boom & Zoom on the Cheap
|
|
ok, I extended the search ranges so this verion should correct the problem that Maverick reported.  |
| Logged
|
|
|
Lt. Nebfer
Major Posts: 3658 Zakus FTW!!
|
|
| Any updates? |
|
WWII: How you can not have hatred for the Russians after your experiences with them?
Erich Hartmann: One thing I learned is this: Never allow yourself to hate a people because of the actions of a few. Hatred and bigotry destroyed my nation, and millions died. I hope most people did not hate Germans because of the Nazis, or Americans because of slaves. Never hate, it only eats you alive. Keep an open mind and always look for the good in people.You may be surprised at what you find.
| Logged
|
|
|
Weirdo
Colonel Posts: 13893 The Sexy MAD Strut©. We're back, baby!
|
|
| He's probably staring at all the new options in TacOps, wondering how on earth he'll implement those... |
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: 6028 Boom & Zoom on the Cheap
|
|
| Pretty much. |
| Logged
|
|
|
Goose
Captain Posts: 2923 " …the laws on his tail, burning for home …"
|
|
| [starts sniffing around for an update, if any] |
|
This Space for Rent
| Logged
|
|
|
Boilerman
Major Posts: 6028 Boom & Zoom on the Cheap
|
|
| Won't have one together anytime soon. |
| Logged
|
|
|
Goose
Captain Posts: 2923 " …the laws on his tail, burning for home …"
|
|
| Can't ask for much more: Thanks! |
|
This Space for Rent
| Logged
|
|
|
