Army List Calculator

MixusMaximus · Post by **MixusMaximus** » Sun Oct 24, 2010 2:47 pm

With Oliviers great tool for FOG:AM as inspiration I tried to built something similar for FOG:R.
As it is not perfect I'll give it to you without any password-protection, so you can adapt it or fix a bug.

Hope you like it!

Excel 2007: http://home.vr-web.de/lordofchaos/Data/ ... _2007.xltx
Excel 97-2003: http://home.vr-web.de/lordofchaos/Data/ ... 7-2003.xlt

1.1 fixed a bug concerning Grand BG in deployment batches. (actually I didn't read this part in the rule book!)
1.2 false dropdown in shooting fixed
1.3 regimental gun "extrapoints" fixed
1.4 *-bug fixed

Blathergut · Post by **Blathergut** » Sun Oct 24, 2010 3:12 pm

I would like to look at it, but it seemed to require a password or something. (Two years of high school German didn't get me very far there!!

)

Spartacus · Post by **Spartacus** » Sun Oct 24, 2010 3:20 pm

Had some trouble but now I have it. I will give it a run later today.

Initially I would say that the formulas for autosums are not correct. Maybe my Wife can look at it as she understands Excel very well.

Thankyou.

MixusMaximus · Post by **MixusMaximus** » Sun Oct 24, 2010 3:42 pm

see Post 1

Blathergut · Post by **Blathergut** » Sun Oct 24, 2010 3:55 pm

It looks very good! I know olivier was planning one...I sent yours to him for perusal.

I ran a 600pts NMA through it and everything seemed quite fine.

Thank you for the work and effort!

Dan T.

Spartacus · Post by **Spartacus** » Sun Oct 24, 2010 3:59 pm

Aah! That is a better link as I seemed to have dowloaded an earlier version. Now it works fine.

SirGarnet · Post by **SirGarnet** » Sun Oct 24, 2010 7:24 pm

I tried the Excel 2003 version. Here is some constructive commentary.

In a normal black and white printout, the shading color scheme translates to giant bands of black text on almost black background that is really suitable only for a shading discrimination eye test. Backgrounds or shadings that work for color printouts but also automatically translate to black and white would be good - dots and stripes work well for that if it is needed. The dark brown isn't that nice in color either. How about a light Slitherine green?

The fields at the top of the page take up a great deal of real estate compared with FOGAM - so much so that the army does not fit on what is left at the bottom of the (landscape) page and instead scrolls over to page 2. Hiding certain rows doesn't work since the game-useful info is spread out among the rows. I'd prefer the info be organized horizontally rather than vertically so the player/club info line can be omitted for casual play, the incidentals like FF/Naval/Fort Camp have a line, and the essentials have a line or two.

In my FOGAM printouts I have room at the bottom of the page to add a big text box across the page (superimposed on the blank lines below the final line with total base counts and total points) with organizational/planning/deployment concepts/tactical notes.

The points total is there since another usability issue that I cared enough about to modify the FOGAM worksheet slightly was to broadcast the points total to several places (in small boxes) top and bottom of the army listing itself so that it was always readily visible on screen without needing to scroll. When working with it I usually size the spreadsheet and print area to block out the BG value and deterioration columns to get a larger font for viewing.

For the same reason, I put commanders as the first item in the listing - e.g., 4 x TCs @ 35. Allows a larger font with more on the page. Having it above the header is fine, but not having the option of listing them with the troops is inconvenient - there are already columns for name, type, number and points.

Cheers,

Mike

paris · Post by **paris** » Sun Oct 31, 2010 11:22 am

thanks alot - superb!
Hakkapeliita!

MixusMaximus · Post by **MixusMaximus** » Sun Oct 31, 2010 12:49 pm

New Version available!

Blathergut · Post by **Blathergut** » Sun Oct 31, 2010 1:12 pm

Oh I must be olde...I get a bunch of XML files but I don't see the actual Excel file in any of the folders or such. What are all the various things in the zipped file?

MixusMaximus · Post by **MixusMaximus** » Mon Nov 01, 2010 9:47 am

The zip-folder contains only the older versions, as Excel 2007 and 95-2003 templates not spreadsheet.
If you chose the direct link, it should open in Excel on your PC.

deadtorius · Post by **deadtorius** » Mon Nov 01, 2010 8:22 pm

One problem I have found with both sheets so far, I start with mounted troops, make up two battle groups of them. Next battle group is a pike and shot battle group, I start with the pikes then the next line gets the shot. Next up I try to make up a battle group of commanded out shot, there is no musket in any of the drop down menus. If I make that row a mounted unit then make the commanded out shot the next unit the muskets show up in the drop down menu again.
Happened in the first version too, not sure why it is happening but has happened to me twice now.
Thanks for making this up for us, it works quite well so far.

Blathergut · Post by **Blathergut** » Mon Nov 01, 2010 9:27 pm

MixusMaximus wrote:The zip-folder contains only the older versions, as Excel 2007 and 95-2003 templates not spreadsheet.
If you chose the direct link, it should open in Excel on your PC.

So, what is this ancient soul doing wrong? If I click on the above 2007 link, I get a zip file and if I unzip I get all kinds of files and folders but nothing that will open with Excel.

quackstheking · Post by **quackstheking** » Mon Nov 01, 2010 9:46 pm

I'm with you Blathergut - all I get is the zipped files for the 2007 version and no sign of an excel spreadsheet!!

Can you repost the direct XL 2007 link for us "silver surfers"!

Cheers

MixusMaximus · Post by **MixusMaximus** » Tue Nov 02, 2010 7:16 pm

Okay, guys, the dropdown-bug should be fixe - thanks for the hint, deadtorius
here is a plain Excel 2007 spreadsheet-file, if you guys can't open this I #m out of ideas! http://home.vr-web.de/lordofchaos/Data/ ... _2007.xlsx

Blathergut · Post by **Blathergut** » Tue Nov 02, 2010 10:28 pm

MixusMaximus wrote:Okay, guys, the dropdown-bug should be fixe - thanks for the hint, deadtorius
here is a plain Excel 2007 spreadsheet-file, if you guys can't open this I #m out of ideas! http://home.vr-web.de/lordofchaos/Data/ ... _2007.xlsx

I still get a group of folders once the file unzips that contain XML files, theme folders, etc...but no excel file that can be opened. I don't get what I am doing wrong.

Anyone any ideas?

MixusMaximus · Post by **MixusMaximus** » Wed Nov 03, 2010 4:54 pm

You could try the 95-2003-Version or to download the file with the right mouse buttopn to your desktop and then open it with Excel via right mouse button!

Blathergut · Post by **Blathergut** » Wed Nov 03, 2010 10:04 pm

Right-click>save to desktop>open with Excel...worked...(but Excel didn't recognize the file extension)(but did successfully open the file).

Thanks

kadeshuk · Post by **kadeshuk** » Wed Nov 24, 2010 11:08 am

Regimental guns seem to add 30 points for some reason.

MixusMaximus · Post by **MixusMaximus** » Thu Nov 25, 2010 6:44 pm

Fixed the regi-gun bug, there was a little typo in the points-table