Author Topic: Anyone have a Abstract Combat System spreadsheet?  (Read 3990 times)

panzerfaust150

  • Master Sergeant
  • *
  • Posts: 276
Anyone have a Abstract Combat System spreadsheet?
« on: 22 March 2019, 11:04:23 »
Hi,
 Well, I am in the homestretch with Clover Spear and writing it and I just got my hands on IO and the ACS..and feeling mighty dumb I did not get this sooner (I doubt it would have changed much, as the Falcons and Vipers were caught by surprise...). But I'd love to be able to run things through and maybe make some revisions for the definitive version and the sourcebook when I get around to them? Anyhow, has anyone done a spreadsheet for this?

 
Clover Spear author and cat wrangler!
FedCom Fan!

Alexander Knight

  • Peditum Generalis
  • BattleTech Volunteer
  • Major
  • *
  • Posts: 4960
  • O-R-E-O
Re: Anyone have a Abstract Combat System spreadsheet?
« Reply #1 on: 22 March 2019, 11:19:41 »
What do you mean by spreadsheet?

panzerfaust150

  • Master Sergeant
  • *
  • Posts: 276
Re: Anyone have a Abstract Combat System spreadsheet?
« Reply #2 on: 22 March 2019, 13:33:42 »
Like a resolution spreadsheet? Plug in the numbers and units and it spits out the results?
Clover Spear author and cat wrangler!
FedCom Fan!

Alexander Knight

  • Peditum Generalis
  • BattleTech Volunteer
  • Major
  • *
  • Posts: 4960
  • O-R-E-O
Re: Anyone have a Abstract Combat System spreadsheet?
« Reply #3 on: 22 March 2019, 13:38:10 »
Ah.  Not atm, but maybe I could work something up

idea weenie

  • Major
  • *
  • Posts: 4855
Re: Anyone have a Abstract Combat System spreadsheet?
« Reply #4 on: 23 March 2019, 03:53:39 »
I'd be tempted to just go with each side per combat round, takes 10% of the other side's point value.

So assuming a chart:
Combat turnSide ASide B
Start1000800
Turn 1  920700
Turn 2  850608
Turn 3  789523
Turn 4  736444
Turn 5  691370
Turn 6  654300
Turn 7  624234
Turn 8  600171
Turn 9  582121
Turn 10  569  62
Turn 11  562    5
Turn 12  561Annihilated

Of course you would have to take into account speed of the two formations, scouting capabilities (i.e. Side B spots Side A first and chooses not to fight), consumables (i.e. ammunition), and other fun.

Alsadius

  • Lieutenant
  • *
  • Posts: 926
Re: Anyone have a Abstract Combat System spreadsheet?
« Reply #5 on: 19 April 2019, 07:11:38 »
I'd be tempted to just go with each side per combat round, takes 10% of the other side's point value.

So assuming a chart:
(snip)

Of course you would have to take into account speed of the two formations, scouting capabilities (i.e. Side B spots Side A first and chooses not to fight), consumables (i.e. ammunition), and other fun.

If you're doing something that simple, make it a random number - (2d6+3)%, perhaps. A quick spreadsheet to do that, with your same 1000 vs 800, gave me the following results:
P1 wins round 12 with 575 left
P1 wins round 11 with 650 left
P1 wins round 13 with 553 left
P1 wins round 15 with 423 left
P1 wins round 13 with 550 left
P1 wins round 12 with 595 left
P1 wins round 13 with 542 left
P1 wins round 13 with 600 left
P1 wins round 12 with 614 left
P1 wins round 13 with 563 left

So overall it's in the same ballpark, but it's got some variance.