Spreadsheet problems?

Wargaming on an Epic Scale
OldnGrey
Admiral
Admiral
Posts: 1230
Joined: Wed Jun 08, 2005 1:29 pm

Spreadsheet problems?

Postby OldnGrey » Tue Nov 09, 2010 7:23 pm

I like this game, reminds me of some budget games I had in the 70's (they had everything in a small plastic "case", small enough to use when travelling) :)

I just had to make myself a small spreadsheet for making the units force list, put the units in from the book and the only one that came out correct is the Copperhead. Followed by much searching for my error.
Wish I had read "3 Questions" thread first.
Going by the book it was not possible to get a speed 3/4, nor a second attack dice of 2 when the unit size is 3 with the full attack dice 4. VPs do not come out to neat multiples of 5. Don't ya just love computers, no give. :roll:

One thing I did find was that the Special Traits on page 20 had to be applied to the ORAT and not the DRAT to get close to the published stats. Dan, is this correct?

Paul

mj12games
Admiral of the Fleet
Admiral of the Fleet
Posts: 3637
Joined: Sun Mar 27, 2005 9:56 pm
Location: Denver, CO
Contact:

Re: Spreadsheet problems?

Postby mj12games » Wed Nov 10, 2010 6:12 pm

OldnGrey wrote:Going by the book it was not possible to get a speed 3/4, nor a second attack dice of 2 when the unit size is 3 with the full attack dice 4.

As mentioned in the other thread, I used fractional values for some units in the book.

VPs do not come out to neat multiples of 5. Don't ya just love computers, no give. :roll:

An aesthetic choice on my part for published units. VPs are rounded to the nearest 5 or 0.

One thing I did find was that the Special Traits on page 20 had to be applied to the ORAT and not the DRAT to get close to the published stats. Dan, is this correct?

It shouldn't matter... :?:
Daniel Kast
Majestic Twelve Games
www.mj12games.com

OldnGrey
Admiral
Admiral
Posts: 1230
Joined: Wed Jun 08, 2005 1:29 pm

Re: Spreadsheet problems?

Postby OldnGrey » Wed Nov 10, 2010 6:26 pm

Thanks dan.
Your right about the mods, even though it screams that having them applied to the larger (ORAT) should make the result larger. I think I just blew a logic chip :shock: Ah, that's better.
Quantum Legions.zip
(7.84 KiB) Downloaded 157 times

Paul
So let it be written, so let it be done.

OldnGrey
Admiral
Admiral
Posts: 1230
Joined: Wed Jun 08, 2005 1:29 pm

Re: Spreadsheet problems?

Postby OldnGrey » Tue Nov 16, 2010 11:42 am

If you use this spreadsheet could you please let me know if the AFV and Infantry list output need more unit spaces.

Thanks.
Paul

OldnGrey
Admiral
Admiral
Posts: 1230
Joined: Wed Jun 08, 2005 1:29 pm

Re: Spreadsheet problems?

Postby OldnGrey » Thu Dec 02, 2010 2:32 pm

Added space for two more afv and two more infantry units in the force list.
In files section.
Paul
So let it be written, so let it be done.


Return to “Quantum Legions”

Who is online

Users browsing this forum: No registered users and 1 guest