ARMY LIST CALCULATOR

nicofig · Post by **nicofig** » Sun Sep 06, 2009 3:56 pm

A new version : 3.0.6

http://fieldofglory.fr/spip.php?article2

Better and more beautifull

WombatDazzler · Post by **WombatDazzler** » Mon Sep 07, 2009 2:12 am

it looks wonderful. Very well done and tks for the continued improvement.

Dazzler

7RiclionLys7 · Post by **7RiclionLys7** » Mon Sep 07, 2009 11:09 am

We have problem when i open the file with open office ^^

Beautiful but every compartment are write by error :p

Thank to give me how to make for remove this error !

DavidT · Post by **DavidT** » Fri Sep 11, 2009 7:13 pm

The new version is excellent.
Well done and thanks for the hard work.
David

Ghaznavid · Post by **Ghaznavid** » Sat Sep 12, 2009 4:49 am

RiclionLys wrote:We have problem when i open the file with open office ^^

Beautiful but every compartment are write by error :p

Thank to give me how to make for remove this error !

You can't, us OpenOffice users can only hope Olivier will make an OO version as well again (especially since the old version which did come for OO too has been removed, might have been worthwhile to keep around for the time being).

olivier · Post by **olivier** » Sat Sep 12, 2009 7:58 am

I'll do but I lost my guide for adapting Excel to open office and I don't remember how to proceed!

As I work on Excel 2007 I don't know if any change broke the compatibility with OO

Blathergut · Post by **Blathergut** » Sun Sep 13, 2009 1:24 pm

Thanks for the new version.

recharge · Post by **recharge** » Thu Oct 08, 2009 10:51 pm

As I add the units, I end up getting an error in the fields for # of BG's, PBI, etc.

What am I doing wrong?

John

babyshark · Post by **babyshark** » Fri Oct 09, 2009 4:49 pm

nicofig wrote:A new version : 3.0.6

http://fieldofglory.fr/spip.php?article2

Better and more beautifull

I forgot to say earlier: thanks for the new version. I like it a great deal.

Marc

olivier · Post by **olivier** » Fri Oct 09, 2009 6:41 pm

As I add the units, I end up getting an error in the fields for # of BG's, PBI, etc.

What am I doing wrong?

I don't know!

Did you delete any sheet ?
Did you cut and paste some line?
Have you inserted some line?

recharge · Post by **recharge** » Sat Oct 10, 2009 12:13 pm

olivier wrote:
As I add the units, I end up getting an error in the fields for # of BG's, PBI, etc.

What am I doing wrong?
I don't know!
Did you delete any sheet ?
Did you cut and paste some line?
Have you inserted some line?

No, no and no.
I start with the empty form and insert units one by one. I get the "!REF" in the Game Information block?

John

stenic · Post by **stenic** » Tue Oct 13, 2009 10:27 am

nicofig wrote:A new version : 3.0.6

http://fieldofglory.fr/spip.php?article2

Better and more beautifull

More beautiful but to be honest I preferred the version that had Impact and Melee POAs seperate. I felt it was clearer and those into FOG Fantasy could put together their own combos.

Also, I found the default setting for printing made it too small on landscape, I cleared the print area, reset font sizes to 12, increased some colum sizes and then hid a few rows to keep it to one sheet.

That said, it's still very useful and thanks for taking the time to knock it up and share with us.

Steve P

ravenflight · Post by **ravenflight** » Tue Oct 20, 2009 2:50 am

nicofig wrote:A new version : 3.0.6

http://fieldofglory.fr/spip.php?article2

Better and more beautifull

It's very good. I'm wondering about two things.

Fistly, can you put in the calculation for the 'page number' to be spanned. For example, if I put in Swords and Scimitars, and put page 6, 7 or 8, I get no army. I have to put in 5... which is fine, but just wondering if it's simple to put in another number or not.

Secondly, can you have the terrain automatically calculate? We know what list it is, we know what army it is, we know everything, so it wouldn't be too much (except inputting the data) to have that as well.

Great work though, thanks.

olivier · Post by **olivier** » Sat Oct 24, 2009 9:43 am

No, no and no.
I start with the empty form and insert units one by one. I get the "!REF" in the Game Information block?

Oh ....

Send me in a PM your sheet and I'll study it

Fistly, can you put in the calculation for the 'page number' to be spanned. For example, if I put in Swords and Scimitars, and put page 6, 7 or 8, I get no army. I have to put in 5... which is fine, but just wondering if it's simple to put in another number or not.

I choose to tag the n° in the index from the army list (easier for a umpire to check a list) If I tag all the page, I have a problem with any page who spoke about 2 different army.

Secondly, can you have the terrain automatically calculate? We know what list it is, we know what army it is, we know everything, so it wouldn't be too much (except inputting the data) to have that as well.

I can do that !:D , but its off limit with copyright and I respect Slitherine and JDM wish

rich · Post by **rich** » Tue Nov 03, 2009 7:29 pm

stenic wrote:
nicofig wrote:A new version : 3.0.6

Better and more beautifull
Also, I found the default setting for printing made it too small on landscape, I cleared the print area, reset font sizes to 12, increased some colum sizes and then hid a few rows to keep it to one sheet.

Steve P

I'm sure you know this but for anyone not totally into EXCEL...SET PRINT AREA and BLACK&WHITE options (fits landscape and saves colored ink)…..

1 - Select (highlight) ALL the cells you want to print - Left click on the cell (ColumnQ/row??) of the last row that you have put a BG in...... (hold down left mouse button) and drag to cell B2.

2 - Set the print area to what you highlighted - Select - FILE – PRINT AREA – SET PRINT AREA from the menu.

3 - Set to print in black and white – Select FILE – PAGE SETUP – SHEET (Check print black and white)

4 - Select PRINT PREVIEW - to check it is correct.

5 – Print it.

philqw78 · Post by **philqw78** » Tue Nov 03, 2009 7:32 pm

Or just set to print on 1 page wide by 1 page tall in page set up. Do whatever you want then, it will always fit.

johno · Post by **johno** » Wed Nov 04, 2009 6:00 pm

Yes, Phil, it will always fit, but sometimes the text will be too small for some of us to read!

Johno

recharge · Post by **recharge** » Wed Nov 04, 2009 7:34 pm

olivier wrote:
No, no and no.
I start with the empty form and insert units one by one. I get the "!REF" in the Game Information block?

Oh ....

Send me in a PM your sheet and I'll study it

Not sure why, but it isn't doing it now??

If it happens again, I will send a sheet to you.

John

philqw78 · Post by **philqw78** » Thu Nov 05, 2009 7:10 am

johno wrote:Yes, Phil, it will always fit, but sometimes the text will be too small for some of us to read!

Johno

Thought you old blokes with vision problems played 25mm so that you had less BG so could get bigger print

SirGarnet · Post by **SirGarnet** » Thu Nov 05, 2009 7:42 am

I am happy with an earlier version - I like a separate column for each POA. (BTW< mine often autofills based on the first letter or two)

I added a points total box in a big red font at cell b12 so I can view the total onscreen easily without having to view the rightmost columns.

The cells have lots and lots of white spaceso the text does not need to be tiny - it is easy to make it more readable by adjusting cell width, borders and the font size (or font) so the text is larger and easier to read.

For notes/tactics etc. I just draw a big Excel text box across the sheet right under the total element count line and write in troop selection, terrain and other doctrine, and deployment notes. This prints out with the list, though I might print out a version without the text box for exchanging lists during a game.

I also have a second column that identifies which batch each unit is in - 1st 2nd 3 4, but this is pure chrome.

Moving entries and resorting them according to deployment order is a little problematic, but maybe that is unavoidable.