Page 9 of 13

Posted: Tue Oct 21, 2008 12:34 am
by babyshark
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

Posted: Tue Oct 21, 2008 2:25 am
by Omar
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?

Posted: Tue Oct 21, 2008 6:28 am
by olivier
normally, the download is set in english.
On the spreadsheet you have a cell named language, choose your favorite language with the menu.
Olivier

Posted: Tue Oct 21, 2008 7:15 am
by Omar
Yup, I must of missed that.

Thanks!

Posted: Thu Jan 08, 2009 6:38 am
by BlackPrince
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

Posted: Thu Jan 08, 2009 7:58 am
by olivier
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

Posted: Thu Jan 08, 2009 9:37 pm
by BlackPrince
Olivier thank you for explaining that bit.

Cheers
Keith

Drop Down Text too small

Posted: Sat Feb 07, 2009 3:27 pm
by johno
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

Posted: Mon Feb 16, 2009 9:55 am
by olivier
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

Posted: Mon Feb 16, 2009 10:23 am
by philqw78
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.

Posted: Mon Feb 16, 2009 11:05 am
by SirGarnet
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

Posted: Mon Feb 16, 2009 4:11 pm
by johno
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

Posted: Mon Mar 02, 2009 5:59 am
by nicofig
New update for this calculator. Thanks Olivier.

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

Posted: Thu Mar 05, 2009 6:24 pm
by evileli
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.

Posted: Thu Mar 05, 2009 6:37 pm
by olivier
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

Posted: Sat Jul 18, 2009 12:08 am
by DaiSho
Olivier,

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

Ian

Posted: Sat Jul 18, 2009 8:28 am
by olivier
the n° of the line in the army list book for a quick checking by list checker.

Posted: Sat Jul 18, 2009 9:14 am
by Fulgrim
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.

Posted: Sat Jul 18, 2009 12:54 pm
by batesmotel
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.

Posted: Sat Jul 18, 2009 4:16 pm
by Fulgrim
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..