Short legion tracking sheet mod to killsheet

[Paladin247]

I have been using Garnier's killsheet in my SPQR campaign and it adds a terrific layer of depth to the game; great stuff.

When I'm playing tho, it's a little too big to have readily at hand and I don't want to jump out of game just to check which legion is where.

So I took the liberty of modifying it to that purpose and have attached same.

I've changed Current status to read Legate for the commanding general's name. The next column is the legion's name. These are readily available on line; just Google "Roman Legion Names" and you'll get eleven pages of really interesting info.

I've also got columns to track in what AOR legion is located and whom they are fighting.

I've found this useful and thought I'd share. Again all credit goes to Garnier; wouldn't have thought of it otherwise.

[Hesus de bodemloze]

This seems interesting, will download this when i continue my campaign.

[czePowerslave]

Why jump, use windowed mode. All much easier

[Ejergard]

Good idea Paladin, but would you mind resaving it as a regular .xls instead of .xlsx? The latter either requires you to have office 2007 to open, or you need a program to convert it, and I just cba atm. Probably others with the same thoughts when it comes to trying out something new they didn't know they needed
And cze, why alt tab at all, just use two monitors, lol. Give the guy some cred, hehe

[Paladin247]

Ejergard, here's the .xls file.

[Ejergard]

Thanks, but now its "Legion tracking sheet.xls.xlsx"
Hm, you got me curious now though, so might go get that program to convert it, hehe

[Paladin247]

Ejergard, my ltd computer skills exposed once again!

When I try to "save as", the following are the options:
Excel workbook
Excel Macro enabled workbook
Excel Binary
Excel 97-2003 workbook
Open document spreadsheet
Pdf or XPS

Any of those do it for you?

[Kaelikk]

Excel 97-2003 should work.

[Paladin247]

I saved it as Excel 97-2003 and when I try to attach it, I get an "invalid file" error msg.

[Paladin247]

I added another column to keep track of legion's homeport. My current tracking sheet attached. Legion VI is unready because it was crunched in the siege of Carthage and is retraining.

[czePowerslave]

Cant open it >.<

[Paladin247]

@czePowerslave, I just checked again and it opened fine for me. Don't know what to tell you.

[czePowerslave]

I have just 03 office. And no, I dont plan on upgrading really. So I wonder why I cannot open it. Except for xlsx or whatever that file is.

[Paladin247]

czePowerslave, if you want to see what it looks like, here's what I did; it's easy.

Copy and paste the first six columns of Garnier's kill sheet, the columns labeled Legion # to Ready.

Legion # stays the same; change the current status column to read Legate for the commander's name. The next column changes to Name for the legion's name.

After the Ready column add three more columns titled, AOR (where the legion is), Enemy (who they're fighting), and Home (their base). Done.

[czePowerslave]

Interesting.
Well I always deployed the legions against enemy and used to color the background of their name with proper killsheet color. And home, thats pretty much obvious!

[Paladin247]

Latest version attached.

The ready column is color coded, green for fully ready, etc.

You'll notice that Legio III rebelled in 191 and is annotated as DD, discharged dishonorable. I've not yet troubled to go kill them off and recover the number for use.

All legates now annotated with the year they took command. I got this hint from Ejergard because leaving one in command for more than 15yrs makes him more susceptible to rebellion while you're pretty safe under 15. The notation PC for the legate of the XII stands for proconsul which is my way of annotating the faction leader and heir who are apparently immune from any tendency to revolt.

[Paladin247]

Latest version attached. Folks who are beyond the destruction of Carthage (Carthage delenda est) in their campaigns will have no need of this. What I've done is add at bottom the fourteen Carthaginian cities that have to be conquered to allow Marian reforms. These are colored to show ownership.

Also have added, for reminder sake, the types of structures that need to be destroyed when conquering enemy cities.

[czePowerslave]

Finally managed to open it. Its good, maybe it can be incorporated into the regular killsheet. Ill look onto it.

[Paladin247]

Cool; thanks.

[Funkyrobbie]

When i open it, it goes and says what program you want to open it with or search internet tried both didnt get it =(