Add more colors, use multiple maps, or express things in terms of formulas.
Know what I m=-qals+An?
A&A Spreadsheet
-
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
-
Wow, that seems like a lot of work. One little correction: Brazil is worth 3, not 1.
-
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.
-
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!
-
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
-
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!
-
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
-
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!
-
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!
-
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
Suggested Topics
