Page 6 of 13
Posted: Wed Feb 20, 2008 10:20 am
by neilhammond
Olivier - the worksheet with the calculations (donnees) is now visible and selectable (it's been hidden up to now). Not a problem, but is this your intention?
Neil
Posted: Wed Feb 20, 2008 5:24 pm
by olivier
If I insert rows, the addition cells are turning red. also when I print out the lists on a laser printer, they are hard to read due to the grays, reds and greens on the sheet.
Yes, it's for prevent you that some of calcul may not work after this modifs. It's better to write after the last line and sort at the end.
I had stop to put nationality in the drop down bax after too many colony wish to add their names!
I go to languages with the last versions and if you want a sheet with Maori or Rapa nui
I happilly send you a version for a translation of the different term.
Olivier - the worksheet with the calculations (donnees) is now visible and selectable (it's been hidden up to now). Not a problem, but is this your intention?
No
I was too tired yesterday evening when I send the las version.
Posted: Thu Feb 21, 2008 7:24 am
by nicofig
It's corrected.
A question : this topic is not a sticky now. It's normal ?
Posted: Thu Feb 21, 2008 3:57 pm
by davem
terrys wrote:Is there an easy way to turn all the colours off?
Page setup/sheet/black & white
Doh!!
Posted: Thu Feb 21, 2008 4:39 pm
by hammy
Just noticed that this thread is no longer sticky. I will put it back.
Posted: Thu Feb 21, 2008 5:29 pm
by nicofig
Thank you Hammy. I think it's more easy for newbies.
Posted: Fri Feb 22, 2008 2:14 pm
by AdeNash
As a new boy to these rules, only got them yesterday, this sheet looks excellent and very easy to use.
Cheers for all your hard work
Posted: Fri Feb 22, 2008 11:17 pm
by hazelbark
Just downloaded a fresh version.
Getting some odd errors with I copy cells.
The only one that didn't go away is not always are generals called generals in the authobreak column
CiC has an 25% column of 1
two other lines of TC have 0 for 25% column
4th TC has the word general.
PS this is great work.
Posted: Sat Feb 23, 2008 8:33 am
by bertalucci
Olivier
Thanks from all of us out here - great work and extremely useful.
Bert
Posted: Sat Feb 23, 2008 12:06 pm
by olivier
The only one that didn't go away is not always are generals called generals in the authobreak column
CiC has an 25% column of 1
two other lines of TC have 0 for 25% column
4th TC has the word general.
Some of the computing for 25% and autobreak work with order of march cell.
If you leave this cell blank, the sheet think they are the same BG!
.
One option is to put a different symbol (not number) in each "order of march" cell of the generals.
Today I send an example (medieval danish starter army) to be put on the Nicolas site, if Slitherine team are OK.
Posted: Sat Feb 23, 2008 6:17 pm
by kustenjaeger
Greetings
Using 2.3.4 I copied the liste armee into a new worksheet - however this ended up with the BG counter (A11) not working on the copy (works fine on the original) i.e showing 0 even when numbers input into the order of march column (unlike earlier versions) - any idea what I am doing wrong?
Regards
Posted: Sat Feb 23, 2008 6:39 pm
by olivier
the counting is made on a hidden sheet. If you made a copy, you lost all the calcul.
For a copy on another sheet , you must made a special paste and select format and value.
Posted: Sat Feb 23, 2008 7:19 pm
by kustenjaeger
Greetings
Thanks.
Having unhidden some sheets and columns I see that making a copy of the sheet keeps the original formula for the BG count (Donnes!BL7) and the hidden donnes sheet is working purely from the original liste armee sheet. Therefore if you copy the liste armee into a new sheet, say sheet 1, then enters BG data into the liste armee cell A11 in both the liste armee sheet and in Sheet 1 (with no data entered) will show the same values.
I managed to produce multiple working copies using my laptop in earlier versions - I wonder what I did?
Regards
Posted: Sat Feb 23, 2008 7:42 pm
by olivier
Therefore if you copy the liste armee into a new sheet, say sheet 1, then enters BG data into the liste armee cell A11 in both the liste armee sheet and in Sheet 1 (with no data entered) will show the same values.
effectively, it's OK if you work on the same worksheet, because the reference table is named. If you copy on a new worksheet, this worksheet don't have this table and can't work. In precedent version cell 11A point at hiddencell IQ7 of the same sheet.
Now cell 11A point at hidden "Donnees"sheet. It save some kilo octet
and it's easier to transport with my USB key at work!
Posted: Sun Feb 24, 2008 3:36 am
by Keith
Not sure how the BG deployment works , any examples of a filled in sheet , and excel file ?
Posted: Sun Feb 24, 2008 8:44 am
by bertalucci
Olivier
In 2.3.4 the Pre Battle Initiative modifiers for Generals seems to be in error.
Also when choosing more than 1 General the Autobreak Column only reads General on the last entry and 0 on any others
Is this the cause of the error
Or am I inputting incorrectly
Keep up the great work.
Bert
Posted: Sun Feb 24, 2008 8:59 am
by olivier
Not sure how the BG deployment works , any examples of a filled in sheet , and excel file ?
I hope to put one in
http://www.fieldofglory.fr/
In 2.3.4 the Pre Battle Initiative modifiers for Generals seems to be in error.
Also when choosing more than 1 General the Autobreak Column only reads General on the last entry and 0 on any others Confused
For pre battle initiative you
MUST put CinC in the column special
For read general on each entry, as I said before you must put a $;£,% etc... different on each ligne of general. If not Excel think is the same BG !
Posted: Sun Feb 24, 2008 9:07 am
by bertalucci
Oh I'm so embarrssed
Cheers
Posted: Sun Feb 24, 2008 11:22 am
by nicofig
The examples are online here :
http://fieldofglory.fr/spip.php?article2
Picture 1 is a simple sheet
Picture 2 is with order of march like in the book (you send it to referee)
Picture 3 is for you, the player, with BG in order of march
Thanks Olivier
Posted: Fri Feb 29, 2008 4:58 pm
by Kineas1
I've owned the rules four days, and am very excited. And thanks to the author for this excellent tool!
Hey, USA and New Zealand--it could be worse--you could be Canadian. Then NO ONE would ever remember you had a nationality. (Tongue firmly in cheek).