A&A Spreadsheet

[mtngoatjoe]

I’ll be interested to see how you make it work in Excel. There are differences between Numbers and Excel; each has it’s strengths and weaknesses. Excel is designed to crunch numbers. Numbers is designed to make numbers look pretty. Anyway, please post some screenshots so I can see what you come up with.

I’ve used my spreadsheet three times. The first time was to work out some bugs and my buddies gave me a lot of crap because I was using a Mac and they are all Microsoft employees. Once I got the bugs worked out, the next two games went very smooth, but my buddies still gave me crap. For the fourth game, I didn’t use it, and my buddies seemed strangely disappointed every time we had to calculate how much to pay someone  :-|

I’m bringing it to the next game and I’m hoping to hook my laptop up to my buddy’s HDTV. We play in his family room and I think it would work pretty well.

I’ve quickly checked into adding a reset button, but I haven’t figured it out yet. I don’t think it’s possible with the version I have. Apple is supposed to release a new version of iWork soon, so maybe I’ll upgrade and see what happens. At a minimum, with the new version, I’ll be able to update the name of the territory and the IPC value with the color of the country that owns it. With the version I have, I can only change the color of the cell that shows who owns a territory.

[el_che]

hi there

looks very nice but unfortunately i don’t have a mac and i was wondering if there is already somebody who made a similar spreadsheet like this but in excell then, it would help alot with the calculating during the game and it would save us alot of time too.

again, nice work though!!

greetings

[77stranger77]

Wow, that seems like a lot of work. One little correction: Brazil is worth 3, not 1.

[mtngoatjoe]

Good catch on Brazil! I’ve updated my link with the correction. Please let me know if you spot any other mistakes.

This spreadsheet is basically a rewrite that simplified the formulas (they used to be really ugly and unreadable). But now they are much shorter and easier to manage. I haven’t used this version for an actual game yet, but I thought I’d smoke tested it enough to post here. On the positive side, at least my formulas were adding things up correctly! All I had to do was change the IPC value for Brazil and the U.S. went from 40 IPCs to 42.

[mtngoatjoe]

Ok, Here is an Excel Spreadsheet version of my IPC Tracker. I have not tried this in an actual game, but it seems to work. If you find any bugs or typos, please let me know and I will fix them. Download the file at https://files.me.com/mtngoatjoe/yhgc63

I do not think it looks as good as the Numbers version, but part of that is because I did not have a lot of time to work on it. Also, I created it on a computer running Windows in Spanish. And since I do not speak Spanish, it was a bit of a process just to get this far.

Let me know what you think of the graphs. I have mixed feelings about them, but they solved some design problems.

Let me know what you think!

[el_che]

thanks for the excell spreadsheet, i will try it out as soon as i play my next game, i can’t promise it will be anytime soon but i will definitly let you know if it works good

thanks again dude

greetz

oh, and the graphics, don’t worry about it, looks great and all that counts for me is that it works during gameplay, i’ve had a quick look already and it really works, now i just need to test it during the game, again thank you very much

[ragnarok628]

wouldn’t it be great if some gracious soul reworked that as a java applet and hosted it on this site?  then we could just come here and voila, easy keeping track of everything!

[el_che]

unbelievable, but true, we finally got together to play another round of A&A and i was able to try the excell spreadsheet, it works great, everybody was happy to use it so many thanks, graphics doesn’t matter, the attention went to the game, 8 hours and allies won! history repeated itself

[mtngoatjoe]

@el_che:

unbelievable, but true, we finally got together to play another round of A&A and i was able to try the excell spreadsheet, it works great, everybody was happy to use it so many thanks, graphics doesn’t matter, the attention went to the game, 8 hours and allies won! history repeated itself

Glad to hear it worked. That made my day!

[tastysub]

It looks like the me.com link is broken (thanks, Apple).  Any chance you could post the spreadsheet again?  I am numbers/excel agnostic.

Thanks!

[mtngoatjoe]

Ok, I’ve made a minor update so that the color matches the controlling country. This works well in Excel 2010. I’ve not tested it in other versions. https://dl.dropboxusercontent.com/u/99318978/Axis_and_Allies_Excel_Spreadsheet.xlsx

I’ve also uploaded my unit purchase tool. This is good for those that have trouble formulating their purchases. It works well on my iPhone, but I have no idea if it works on other platforms. Note: First enter the available IPC and Industrial Capacity, and then use the plus and minus buttons for making purchases. https://dl.dropboxusercontent.com/u/99318978/Axis_and_Allies_Purchase_Tool%204.html

Edit: I’ve created an iOS Numbers version of the unit purchase tool. You’ll need iOS and Number to use it, and it isn’t quite as fancy as the html version above, but the interface is a little cleaner.
https://dl.dropboxusercontent.com/u/99318978/Axis_and_Allies_Purchase_Tool_iOS.numbers.zip