Register Register

Author Topic: Vertical Force Creator  (Read 1394 times)

GoGo Yubari

  • Sergeant
  • *
  • Posts: 158
Vertical Force Creator
« on: 25 February 2022, 10:25:15 »
Since I decided to do a deep dive into the more strategic layers of the various systems (SBF, ACS, ISW), I needed a way to quickly create units from the bottom up. With that in mind, I've been spending way too much time creating a spreadsheet that does the conversion from AS to SBF and SBF to ACS. This will also let you do comparisons between various configurations at the different layers, making it easier to create distinctive units for play instead of just using one simple generic set of stats.

The different levels of play are color coded, so that should help you navigate the different sheets once you grok the code. The overview sheet will be helpful.

Right now, all the lists from which it pulls the stats are not entirely populated, but I think you can see how it works, the benefit and if needed you could add in those stats. Currently it has a bunch of 'Mechs, the standard lances from Combat Manual:Kurita and that's pretty much it.

Also, I'm certain there's some bugs or "unintended features" in there, but it does the basic trick. 

You can find the spreadsheet from the following link: Vertical Force Creator

Please let me know if you have comments, questions or requests. Development on this is certainly not done yet and maybe this will be useful to you as well.
« Last Edit: 25 February 2022, 17:49:09 by GoGo Yubari »

BattleMech Production 3025: thread  list
GoGo's MWO BATTLE ROMs: CBT MWO youtube

GoGo Yubari

  • Sergeant
  • *
  • Posts: 158
Re: Vertical Force Creator
« Reply #1 on: 25 February 2022, 10:25:33 »
Reserved for future changes/issues.

BattleMech Production 3025: thread  list
GoGo's MWO BATTLE ROMs: CBT MWO youtube

Daryk

  • Lieutenant General
  • *
  • Posts: 27546
  • The Double Deuce II/II-σ
Re: Vertical Force Creator
« Reply #2 on: 26 February 2022, 08:03:46 »
Any chance you could extend it down to the TW level? ???

Dahmin_Toran

  • Master Sergeant
  • *
  • Posts: 369
Re: Vertical Force Creator
« Reply #3 on: 26 February 2022, 10:34:41 »
This is much better than the spreadsheet I created.

WarHammer Willy

  • Recruit
  • *
  • Posts: 19
Re: Vertical Force Creator
« Reply #4 on: 27 February 2022, 00:26:03 »
This is much better than the spreadsheet I created.

Same! This is great!

Alexander Knight created a Sample Lances list that has various lance compositions for each House from 3025. Would work into this sheet very nicely I would think. I'll give it a go and see how it works out.

GoGo Yubari

  • Sergeant
  • *
  • Posts: 158
Re: Vertical Force Creator
« Reply #5 on: 27 February 2022, 03:23:12 »
Any chance you could extend it down to the TW level? ???

Unfortunately that's an expansion I'm not going to undertake - it's a huge effort and personally see this as a tool for use at the Alpha Strike and up layers.

BattleMech Production 3025: thread  list
GoGo's MWO BATTLE ROMs: CBT MWO youtube

Daryk

  • Lieutenant General
  • *
  • Posts: 27546
  • The Double Deuce II/II-σ
Re: Vertical Force Creator
« Reply #6 on: 27 February 2022, 05:54:17 »
No worries... I had to ask though.

Vic_Vic

  • Recruit
  • *
  • Posts: 5
Re: Vertical Force Creator
« Reply #7 on: 04 March 2022, 13:21:13 »
What a great tool! Many thanks!