What does your spreadsheet look like?
 

Since I've been preparing for another tournament coming up at the end of May, I pulled out my old army analysis spreadsheet and started plugging ideas in. I know other people do this too:
I'm just wondering what they look like. Mine looks like this:
http://i.imgur.com/oDynK.jpg
I have columns so that I think about how the army would respond to the common problems (Q9, Rats, etc.) and last time around I color coded stuff (those armies are all from the Eugene tournament in 2008, I went with something that's not even on the list) and figured out every army's threat range and life and other fun stuff. What do you have on your spreadsheet?

Re: What does your spreadsheet look like?
 

Wow.

I don't make one.

I usually just get out a sheet of looseleaf paper and start scribbling words on it. Then I phone a friend.

Re: What does your spreadsheet look like?
 

phone a friend = spider_poison

This was a roll up sheet from my GCarmies 2009 spreadsheet from last year. Each event (I was playing in) had its own tab and the top 8 armies on each tab autopopulated on this roll up tab.

http://www.heroscapers.com/community...s_original.jpg

I use a master SS to house all the units in sortable, filterable fashion that also auto calculates points and hexes as units & quantities are designated. From there, I copy paste the chosen units into the current Army spreadsheet.

Re: What does your spreadsheet look like?
 

Yeah, that's what I'm talking about. I've never gotten around to making the master sheet to pull from, though I suppose I could use bixby's to start with.

And Jexik, I'm kind of surprised. I thought you'd rate higher on the autism spectrum scale. High enough at least for obsessive spreadsheets. :)

Re: What does your spreadsheet look like?
 

I don't use spereadhseets, one's head is good enough in most instances here

Re: What does your spreadsheet look like?
 

My spreadsheets usually goes like this -

Variation of Knight armies
Variation of Orc armies
Variation of Dwarf armies
Variation of Roman armies

I also have the "other" category. It usually invovles like Dividers, Drones, SB, Armocs, Blades, etc.

I also have a category -
Can it beat Q9? Can it beat rats? Can it beat the 10th? Can it beat 'trons?

phone a friend for me = fomox. Though it's usally through pm or e-mail.

I've got most of my Gen Con armies already nailed down to about 2 choices for each event. TreasureQuest is really making me think though.

Re: What does your spreadsheet look like?
 

I agree. Rarely do the spreadsheets spawn an idea, they are simply tools I like to use. Also, I like nice clean printouts. :-D

Re: What does your spreadsheet look like?
 

http://www.nyys.us/HS/ABSS.jpg

All the tan areas are editable. Type in the unit and all the stats appear. Further, put a * or ** in the column next to the unit and the special abilities (and synergies) appear below along with the current Power Ranking over on the upper right.

This was my build for our Scenario Tourney we ran last weekend (Battle at the Border III).

Re: What does your spreadsheet look like?
 

I like to have the spreadsheet just to remember. Without it, I would certainly forget some silly/fun army I thought up.

Re: What does your spreadsheet look like?
 

Rÿchean, that is a thing of beauty.

I love spreadsheets, but for army composition I mostly do it on paper and in my head. Last year I had a simple notepad document to keep track of my main ideas for each event. This year it is random notes in the margins of handouts I get at boring presentations/meetings, and email and texts back and forth with MM. A couple events are basically done (assuming they'll be no Wave D2 by then), but the main event choice will probably keep changing until August.

Fun thread, yagyuninja.

Re: What does your spreadsheet look like?
 

I just suck at using spreadsheets.

I don't own a camera either, because I like using my memory when possible. I kind of want a camera now though, so I can show others what I'm talking about here.

I know the point totals and likely armies well enough at most events at this point that I know exactly what someone's playing when they say, "I'm playing Knights" or whatever. I'll usually spit out one or two solid builds and one will be the one they're playing.
Yeah, when my mind isn't enough, I look for some corroboration. He told me to play Vanilla Ice in the first tourney I actually won,* and I convinced him to play Trons in the main event the last two years, and Stingers/Rats in the '08 mindshackle.

Those phone calls are usually about 95% of our tourney prep, honestly.

Re: What does your spreadsheet look like?
 

According to Sandra the official release date for D2 is August 17th.

Ive never messed around with spreadsheets. I have a notebook I take everywhere with me.