|
Major
Posts: 6147
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.
|
|
|
Colonel
Posts: 15160
Emo Elvis is watching you pee...
|
Wow, this looks awesome. Thanks, man!
|
|
|
Lieutenant
Posts: 1489
Yer leg's off. No it's not.
|
Very interseting B-Man. I'll dive into this at my next opportunity.
|
|
|
Colonel
Posts: 15160
Emo Elvis is watching you pee...
|
Trying to work through this, it seems to work pretty good, though it doesn't list a machine gun's burst-fire effects...
|
|
|
Major
Posts: 6147
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.
|
|
|
Colonel
Posts: 15160
Emo Elvis is watching you pee...
|
...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.
|
|
|
Major
Posts: 6147
Boom & Zoom on the Cheap
|
Damn Marians. Well I can't fix that one without giving the clanners a freebie or a serious addition.
|
|
|
Colonel
Posts: 15160
Emo Elvis is watching you pee...
|
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. 
|
|
|
Master Sergeant
Posts: 206
|
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!
|
|
|
Lieutenant
Posts: 1497
|
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.
|
|
|
Lieutenant Colonel
Posts: 7719
|
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.
|
|
|
Major
Posts: 6147
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. 
|
|
|
Major
Posts: 6147
Boom & Zoom on the Cheap
|
ok, I extended the search ranges so this verion should correct the problem that Maverick reported. 
|
|
|
Major
Posts: 4219
Zakus FTW!!
|
Any updates?
|
|
|
Colonel
Posts: 15160
Emo Elvis is watching you pee...
|
He's probably staring at all the new options in TacOps, wondering how on earth he'll implement those... 
|
|
|
Major
Posts: 6147
Boom & Zoom on the Cheap
|
Pretty much.
|
|
|
Major
Posts: 3272
" …the laws on his tail, burning for home …"
|
[starts sniffing around for an update, if any]
|
|
|
Major
Posts: 6147
Boom & Zoom on the Cheap
|
Won't have one together anytime soon.
|
|
|
Major
Posts: 3272
" …the laws on his tail, burning for home …"
|
Can't ask for much more: Thanks!
|
|
|
Lieutenant Colonel
Posts: 8942
|
Awesome file, thanks!
|
|