Vehicle or Ordnance spreadsheet idea

[Kevin Kenneally]

All,

I am trying to create a spreadsheet (like the Chapter H graphics) that players could use (and read on a tablet or computer).

It will also allow them to incorporate the TPP counters into this spreadsheet for information.

Lastly, it will allow them to place an inventory number on how many counters of that specific vehicle or ordnance they currently possess (not what comes in each module).

See below (I hope the copy/paste works):

Vehicle	Type	Main Gun	Machine Guns	Notes	Amount
Light Tanks
M2A4	Light Tank	37LL	4/4/2	White circle around 1st MG FP	10
M3	Light Tank	37LL	4/4/2	White circle around 1st MG FP	10
M3A1	Light Tank	37LL	2/4/2		22
M3A1 Satan	Light Tank	TF 32 B11	2/4/2		6
M3A1F	Light Tank	37LL	2/4/2		12
M5A1	Light Tank	37LL	2/4/2		36
M5A1C	Light Tank	37LL	2/4/2		10
M5A1F	Light Tank	37LL	2/4/2		4
M5A1 Satan	Light Tank	TF 32 B11	2/4/2		9
M24 Chaffee	Light Tank	75	2/4/4		10

Just an idea I am working on.

Comments please.

Kevin

 

[Vinnie]

I can send you a spreadsheet of the chapter H tables for each nationality. Then you only need modify the number of counter column to keep track of what you have.
I don't have all TPPs in it but quite a few.

 

[olli]

Kevin my counter tabs over at Texas ASL site in the Downloads has almost every vehicle by nationality on them if that helps? official and TPP

 

[Kevin Kenneally]

Kevin my counter tabs over at Texas ASL site in the Downloads has almost every vehicle by nationality on them if that helps? official and TPP

Cool Olli.

Thanks for the tip.

Heading there now.

Kevin

 

[stuh42asl]

Hi Kevin

You amaze me...........you should hire yourself out as a ASL storage kit designer.............if you are like me you must have at least 3-4 sets of every module.

Shane

 

[Kevin Kenneally]

Hi Kevin

You amaze me...........you should hire yourself out as a ASL storage kit designer.............if you are like me you must have at least 3-4 sets of every module.

Shane

Shane,

Close enough:

BV - 4

Paratrooper - 2

Yanks - 2

Partisan - 3

WoA - 1 (For King & Country - 3)

The Last Hurrah - 2

Code of Bushido - 1.5

Gung Ho - 1.5

Croix de Guerre - 2

Doomed Battalions - 2 (v2, v3)

AoO - 1

HASL

Red Barricades - 2 ( 4 sets of maps)

KGP I & II - 3 each

Pegasus Bridge - 3 (just got the third at the beginning of this month for $29 on Ebay)

BRT - 2

ABtF - 2

OV - 1 ( plus 10 AFV and 5 Infantry extra countersheets)

OW - 1

VotGs - 2

FB - 2

I like the Official products with many counters.

 

[olli]

Shane,

Close enough:

BV - 4

Paratrooper - 2

Yanks - 2

Partisan - 3

WoA - 1 (For King & Country - 3)

The Last Hurrah - 2

Code of Bushido - 1.5

Gung Ho - 1.5

Croix de Guerre - 2

Doomed Battalions - 2 (v2, v3)

AoO - 1

HASL

Red Barricades - 2 ( 4 sets of maps)

KGP I & II - 3 each

Pegasus Bridge - 3 (just got the third at the beginning of this month for $29 on Ebay)

BRT - 2

ABtF - 2

OV - 1 ( plus 10 AFV and 5 Infantry extra countersheets)

OW - 1

VotGs - 2

FB - 2

I like the Official products with many counters.

I will keep quiet on this subject;-)

 

[Kevin Kenneally]

I will keep quiet on this subject;-)

Olli, we all know you can multiply the amounts I have by 10 and still not be accurate to your collection size.

 

[xenovin]

Shane,

Close enough:

BV - 4

Paratrooper - 2

Yanks - 2

Partisan - 3

WoA - 1 (For King & Country - 3)

The Last Hurrah - 2

Code of Bushido - 1.5

Gung Ho - 1.5

Croix de Guerre - 2

Doomed Battalions - 2 (v2, v3)

AoO - 1

HASL

Red Barricades - 2 ( 4 sets of maps)

KGP I & II - 3 each

Pegasus Bridge - 3 (just got the third at the beginning of this month for $29 on Ebay)

BRT - 2

ABtF - 2

OV - 1 ( plus 10 AFV and 5 Infantry extra countersheets)

OW - 1

VotGs - 2

FB - 2

I like the Official products with many counters.

No Rising Sun?! Common now....

 

[Kevin Kenneally]

No Rising Sun?! Common now....

Yeah, got one from the Gamer's on their Pre-order list.

Forgot to add it, but its only ONE copy. I can't afford the 2nd copy due to the tough economic times and Government down-sizing......

I hope to win the lottery, or sell my blood to get an additional copy.

 

[stuh42asl]

So far my collection is

1 x Mint condition 2nd Edition rule book
1 x 2nd Edition (home copy)
1 x 2nd (travel copy)

4 X copies BV
1 x West of Alamein
2 x For King and Country
2 x Crois de Geurre
3 x Doomed Battalions
2 x last Hurrah
3 Armies of Oblivion
2 x Gung Ho
1 x Rising Sun
2 x Japanese modules(can't remember the name)
2 x VOTG
3 x Festung Budapest
2 x Red Barricades
3 x Rileys Road
2 x Yanks
1 x Paratroopers
And tons and tons of modules, scenarios, and ASL knik knaks.

I have so many counters you could lay them end to end and be promptly committed to and mental hospital

Shane

 

[Srynerson]

I'm replying to this thread just to get poor stuh42asl's post out of limbo.

 

[kynken]

So far my collection is

1 x Mint condition 2nd Edition rule book
1 x 2nd Edition (home copy)
1 x 2nd (travel copy)

4 X copies BV
1 x West of Alamein
2 x For King and Country
2 x Crois de Geurre
3 x Doomed Battalions
2 x last Hurrah
3 Armies of Oblivion
2 x Gung Ho
1 x Rising Sun
2 x Japanese modules(can't remember the name)
2 x VOTG
3 x Festung Budapest
2 x Red Barricades
3 x Rileys Road
2 x Yanks
1 x Paratroopers
And tons and tons of modules, scenarios, and ASL knik knaks.

I have so many counters you could lay them end to end and be promptly committed to and mental hospital

Shane

you dudes are hardcore. I can only muster one copy of each going back to Beyond Valor. Maybe 2 x Doomed Battalions, at the most.

 

[stuh42asl]

you dudes are hardcore. I can only muster one copy of each going back to Beyond Valor. Maybe 2 x Doomed Battalions, at the most.

I have been playing ASL since it came out...........or you can say I was playing ASL when it was carved in stone and the pieces were rockchips............and if you want to know my age all you have to do is cut off my arm and count the rings

Shane

 

[olli]

So far my collection is

1 x Mint condition 2nd Edition rule book
1 x 2nd Edition (home copy)
1 x 2nd (travel copy)

4 X copies BV
1 x West of Alamein
2 x For King and Country
2 x Crois de Geurre
3 x Doomed Battalions
2 x last Hurrah
3 Armies of Oblivion
2 x Gung Ho
1 x Rising Sun
2 x Japanese modules(can't remember the name)
2 x VOTG
3 x Festung Budapest
2 x Red Barricades
3 x Rileys Road
2 x Yanks
1 x Paratroopers
And tons and tons of modules, scenarios, and ASL knik knaks.

I have so many counters you could lay them end to end and be promptly committed to and mental hospital

Shane

Hey Shane that lot could be my travel kit basics! ;-)

 

[hongkongwargamer]

Olli, you might want to consider travelling in a coach with game tables setup and enough counters, maps and scenarios for everyone. A rolling ASL tourney that runs around the country, picking up players and spectators at every stop!!


Regards,
Jack

Hey Shane that lot could be my travel kit basics! ;-)

 

[olli]

Olli, you might want to consider travelling in a coach with game tables setup and enough counters, maps and scenarios for everyone. A rolling ASL tourney that runs around the country, picking up players and spectators at every stop!!


Regards,
Jack

Just need the bus and tables then!

 

[HansK]

LOL!

:laugh:

 

[Kevin Kenneally]

Just need the bus and tables then!

An old VW van would be a small substitute.....

 

[Vinnie]

Hey Kevin, did the excel spreadsheet reach you OK?