ARMY LIST CALCULATOR
Moderators: philqw78, terrys, hammy, Slitherine Core, Field of Glory Design, Field of Glory Moderators
-
- Corporal - 5 cm Pak 38
- Posts: 35
- Joined: Wed Jun 06, 2007 6:00 am
- Location: Sydney
-
- Corporal - Strongpoint
- Posts: 56
- Joined: Thu May 29, 2008 1:44 pm
-
- 1st Lieutenant - 15 cm sFH 18
- Posts: 800
- Joined: Wed Aug 29, 2007 1:44 am
- Location: Germany
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).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 !
Karsten
~ We are not surrounded, we are merely in a target rich environment. ~
~ We are not surrounded, we are merely in a target rich environment. ~
-
- Field Marshal - Elefant
- Posts: 5875
- Joined: Tue Jan 22, 2008 1:44 am
- Location: Southern Ontario, Canada
-
- Field of Glory Moderator
- Posts: 1336
- Joined: Fri Feb 02, 2007 6:59 pm
- Location: Government; and I'm here to help.
I forgot to say earlier: thanks for the new version. I like it a great deal.nicofig wrote:A new version : 3.0.6
http://fieldofglory.fr/spip.php?article2
Better and more beautifull
Marc
olivier wrote:I don't know!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?
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
-
- Sergeant First Class - Elite Panzer IIIL
- Posts: 437
- Joined: Mon Feb 04, 2008 7:24 pm
- Location: Cheltenham, Glos, UK
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.nicofig wrote:A new version : 3.0.6
http://fieldofglory.fr/spip.php?article2
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.
That said, it's still very useful and thanks for taking the time to knock it up and share with us.
Steve P
-
- Brigadier-General - 15 cm Nblwf 41
- Posts: 1966
- Joined: Wed Aug 26, 2009 6:52 am
It's very good. I'm wondering about two things.nicofig wrote:A new version : 3.0.6
http://fieldofglory.fr/spip.php?article2
Better and more beautifull
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.
-
- Lieutenant Colonel - Fw 190A
- Posts: 1126
- Joined: Mon Nov 06, 2006 5:49 pm
- Location: Paris, France
Oh ....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?
Send me in a PM your sheet and I'll study it
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.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.
I can do that !:D , but its off limit with copyright and I respect Slitherine and JDM wish
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)…..stenic wrote: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.nicofig wrote:A new version : 3.0.6
Better and more beautifull
Steve P
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.
-
- Chief of Staff - Elite Maus
- Posts: 8812
- Joined: Tue Feb 06, 2007 11:31 am
- Location: Manchester
Thought you old blokes with vision problems played 25mm so that you had less BG so could get bigger printjohno wrote:Yes, Phil, it will always fit, but sometimes the text will be too small for some of us to read!
Johno
phil
putting the arg into argumentative, except for the lists I check where there is no argument!
putting the arg into argumentative, except for the lists I check where there is no argument!
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.
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.