ARMY LIST CALCULATOR

General discussion forum for anything related to Field of Glory Ancients & Medieval.

Moderators: hammy, Slitherine Core, Field of Glory Moderators, Field of Glory Design

babyshark
Field of Glory Moderator
Field of Glory Moderator
Posts: 1336
Joined: Fri Feb 02, 2007 6:59 pm
Location: Government; and I'm here to help.

Post by babyshark » Tue Oct 21, 2008 12:34 am

Omar wrote:I cant seem to find the English version of this? Every one on http://fieldofglory.fr/spip.php?article2 seems to be in french.
More than seems to be French . . . :shock: Olivier--the guy who wrote the spreadsheet--is a Frenchman. He is not just showing off. :D

Once you download the spreadsheet (I suggest the "tournoi" version) you can pick the language that you want to use.

Marc

Omar
Sergeant - Panzer IIC
Sergeant - Panzer IIC
Posts: 192
Joined: Wed Jan 23, 2008 8:19 pm

Post by Omar » Tue Oct 21, 2008 2:25 am

babyshark wrote: Once you download the spreadsheet (I suggest the "tournoi" version) you can pick the language that you want to use.

Marc
Uhh... how?

olivier
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

Post by olivier » Tue Oct 21, 2008 6:28 am

normally, the download is set in english.
On the spreadsheet you have a cell named language, choose your favorite language with the menu.
Olivier

Omar
Sergeant - Panzer IIC
Sergeant - Panzer IIC
Posts: 192
Joined: Wed Jan 23, 2008 8:19 pm

Post by Omar » Tue Oct 21, 2008 7:15 am

Yup, I must of missed that.

Thanks!

BlackPrince
Staff Sergeant - StuG IIIF
Staff Sergeant - StuG IIIF
Posts: 269
Joined: Mon Aug 25, 2008 12:34 pm

Post by BlackPrince » Thu Jan 08, 2009 6:38 am

Very nice work congrats only one problem the spreadsheet does not have any points for heavy weapon, the drop down box allows you to select it but it does not add in any points for that melee weapon. eg

men at arms HF/ Arm/ sup/ heavy weapon by your spreadsheet 11 points but the army list book it is listed as 13 points

Keith

olivier
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

Post by olivier » Thu Jan 08, 2009 7:58 am

As Heavy weapons are also impact, the point for them are added when you choose them in the impact drop down box.
your men at arm are effectively HF/ Arm/ Sup/ -/ HW/ HW

BlackPrince
Staff Sergeant - StuG IIIF
Staff Sergeant - StuG IIIF
Posts: 269
Joined: Mon Aug 25, 2008 12:34 pm

Post by BlackPrince » Thu Jan 08, 2009 9:37 pm

Olivier thank you for explaining that bit.

Cheers
Keith

johno
Administrative Corporal - SdKfz 251/1
Administrative Corporal - SdKfz  251/1
Posts: 145
Joined: Fri Mar 14, 2008 5:07 pm
Location: Plymouth UK

Drop Down Text too small

Post by johno » Sat Feb 07, 2009 3:27 pm

How can I change the size of the text in the drop-downs?

The entries are very small and hard to read, except at 100%, and then you can't see enough of the columns to be usable.

I find I need to scale the sheet to 65% to be able to see all the columns on my screen.

Thanks for providing such a useful tool.

johno

olivier
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

Post by olivier » Mon Feb 16, 2009 9:55 am

Sorry,....but I don't know how to change the size of the drop-downs ( normally and with a normal 15"screen, it's easily readable at 85%)
Olivier

philqw78
Chief of Staff - Elite Maus
Chief of Staff - Elite Maus
Posts: 8471
Joined: Tue Feb 06, 2007 11:31 am
Location: Manchester

Post by philqw78 » Mon Feb 16, 2009 10:23 am

The font size in a drop down can't be changed. You can write some code to change the zoom when the cell is selected, or put a combo box over it, but it would be easier for the user to zoom in.

SirGarnet
Brigadier-General - Elite Grenadier
Brigadier-General - Elite Grenadier
Posts: 2118
Joined: Fri Apr 18, 2008 10:13 am

Post by SirGarnet » Mon Feb 16, 2009 11:05 am

I have made three useful changes to the version I use.

* Added a movable text box across the bottom right below the total bases cell (added that too in the bases column) in which I describe the reason for the army structure and order of march, deployment strategy overall and by deployment group, alternative troop mixes, etc. so it's all on one page.

* Copy the total points number to the upper left on the last commander line so I can increase the zoom and get the unit sums off screen but keep the total visible at all times. As I don't have a giant screen this makes the screen more readable.

* In addition to order of march, I have a deployment group column right after that with 1st, 2nd, 3 or 4 to make it easy to see the groups - of course if I manually cut and past to put everything in the right order this is not necessary.

OK, that's actually 4 changes . . . .

Mike

johno
Administrative Corporal - SdKfz 251/1
Administrative Corporal - SdKfz  251/1
Posts: 145
Joined: Fri Mar 14, 2008 5:07 pm
Location: Plymouth UK

Post by johno » Mon Feb 16, 2009 4:11 pm

I increased the font size and that seemed to make a difference - it's certainly easier to read now.

It had the added advantage of making the printed copy easier to read, as well.

I keep the headers in view by freezing the pane

nicofig
Field of Glory Moderator
Field of Glory Moderator
Posts: 743
Joined: Tue Aug 22, 2006 6:54 pm
Location: Toulon
Contact:

Post by nicofig » Mon Mar 02, 2009 5:59 am

New update for this calculator. Thanks Olivier.

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

evileli
Private First Class - Opel Blitz
Private First Class - Opel Blitz
Posts: 2
Joined: Sun Feb 15, 2009 11:52 pm

Post by evileli » Thu Mar 05, 2009 6:24 pm

Oliver

It is a great spread sheet, But how do I add the names of the armies whose books I have to the drop down list.

I can't seem to find the data tables the forumlas are pulling from.

olivier
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

Post by olivier » Thu Mar 05, 2009 6:37 pm

1) Choose your army book in the dropdown menu in the cell "Book name"
2) Write the page number under the cell "Page number" ( page number are found in the index of each army book)
Olivier

DaiSho
1st Lieutenant - Grenadier
1st Lieutenant - Grenadier
Posts: 792
Joined: Sat May 24, 2008 10:02 am
Location: Australia

Post by DaiSho » Sat Jul 18, 2009 12:08 am

Olivier,

What's the "order of book" column for in the comp spreadsheet?

Ian
Viking (15mm)
Syracusan (15mm)
Palmyran (10mm - 15mm basing)
Horse Nomad (15mm)

olivier
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

Post by olivier » Sat Jul 18, 2009 8:28 am

the n° of the line in the army list book for a quick checking by list checker.

Fulgrim
Senior Corporal - Destroyer
Senior Corporal - Destroyer
Posts: 119
Joined: Mon Apr 28, 2008 6:06 pm

Post by Fulgrim » Sat Jul 18, 2009 9:14 am

Firstly thanks for a great, helpful, tool!!

A note though:
Have some trubles with BGs of 6HF+3LF. They show correct for the HF. But its a bit annoying that there is an error message on the LF.

batesmotel
Field of Glory Moderator
Field of Glory Moderator
Posts: 3324
Joined: Thu Mar 13, 2008 8:52 pm

Post by batesmotel » Sat Jul 18, 2009 12:54 pm

Fulgrim wrote:Firstly thanks for a great, helpful, tool!!

A note though:
Have some trubles with BGs of 6HF+3LF. They show correct for the HF. But its a bit annoying that there is an error message on the LF.
Did you give the LF the same order of march number on their line as the HF? That is how the macros identify them as belonging to the same BG.

Fulgrim
Senior Corporal - Destroyer
Senior Corporal - Destroyer
Posts: 119
Joined: Mon Apr 28, 2008 6:06 pm

Post by Fulgrim » Sat Jul 18, 2009 4:16 pm

batesmotel wrote:
Fulgrim wrote:Firstly thanks for a great, helpful, tool!!

A note though:
Have some trubles with BGs of 6HF+3LF. They show correct for the HF. But its a bit annoying that there is an error message on the LF.
Did you give the LF the same order of march number on their line as the HF? That is how the macros identify them as belonging to the same BG.
Off course..

Post Reply

Return to “Field of Glory : Ancient & Medieval Era 3000 BC-1500 AD : General Discussion”