sireRage

Have you tried a field to be filled in by the user with the name of the file to be read and that would complete an importrange formula?

Having received the french rulebook, I see no more words to change in our french googlesheet version, for the moment.

All is ok for the french version.

Next possible changes will arrise when the other books will be published

By the way, do we have to make any manipulation into the rule tab when changing for the french view?

12 hours ago, DreadDomain said:

Quick question, the Alternative Rules snapshot found here https://runequest-glorantha.fandom.com/wiki/Google_Sheets_Character_Creation_Workbook_by_Phil_Hibbs shows an alternate rule with "Use profession skill bonus values from the French edition"

What is different in the French edition? 

It's probably too soon to answer precisely because french rules are still unpublished and under corrections, but to say it shortly, some more skills are added to the occupational skills in the character creation chapter and a few ones are slightly modified

It's good to see Runequest reappear in French.
Hoping not to wait too long between the english and the french version

Everything seems ok

• "Characteristic" from CharGen/T1 doesn't translate. I suppose it's because it lacks a final s (characteristics)
• CharSheet/A1 ("HP") and AN1 ("MP") don't translate in french. I don't know why.
• Spells lists don't work (in French) for me. There is simply no list. I tried in English, it works fine.

French translation available for the spells, here:

https://docs.google.com/spreadsheets/d/1_L7LmxTB-145W4H8NTkqKZdc9QCFkcTcdm3HD75sUW0

If line 949 "(arme) de vérité" for "True (Weapon)" is problematic, change "(arme) de vérité" to "Vraie (arme)"

22 hours ago, PhilHibbs said:

What changes are needed to make the CharSheet printable? Just the HP and MP tracks down the sides? I can just add those to the CharSheet.

Yes, on the print setting page, you'll have to specify margins to 0.394" (1cm) and activate custom page breaks. this will fix printing scale (maybe you'll have to finish the printing process for these settings to be stored in the app).

I didn't found other way to maintain printing margins and scale in the file.

I'm on the spells translation process. I try, as much I can, to reuse the names applied in the french RQ3 version.

WIP is there (translations tab) : https://docs.google.com/spreadsheets/d/1_L7LmxTB-145W4H8NTkqKZdc9QCFkcTcdm3HD75sUW0

• When do the spell selection lists fill up?

Because if I only fill the chargen/A column, spells lists are still blank to me on charsheet. Did I miss something ?

• To translate the spell names, can you put each of them in the translation tab please (I guess you're better than me to filter multiple occurrences of the same spell) ?

• I come again on the printer friendly charsheet. I still think it's useful. Not for you, not for most English user as there is already character sheets available. But, in the French case, it's, for the moment, the only existing French character sheet. And last but not least, we don't always play with electronic device at hand.

19 hours ago, PhilHibbs said:

Personally I don't think I would want to print this sheet, I'd transcribe onto a real sheet.

Yep, me too when french character sheet will exist

it would be cool adding another tab containing the CharSheet formated for compatibility with A4 printer

I've toyed a little with the charsheet tab and I propose you the following layout :

https://docs.google.com/spreadsheets/d/1_L7LmxTB-145W4H8NTkqKZdc9QCFkcTcdm3HD75sUW0/edit?usp=sharing

It seems formulas and layout survive to the transfer from on spreadsheet to another one.

Édit: and the translate process seems to work fine on this new tab

I've given a try with the compare function from adobe acrobat pro : It just highlights changes and often finds modifications that didn't occured. I didn't found a way to export the result.

I've tried diffoscope on linux : I get a 300 Mo text file with, also, a lot of false changes detected. Maybe some parameters in the app have to be ajusted...

I finally think a good diff would be more easily done if working on an export in text format of the two native files

here's the corrected sentence :

• Category modifiers in +5 bands, each 4 points either side of the 9-12 band : +/-5 en modificateur de cat. par tranche de 4 pts inf. à 9 ou sup. à 12

Maybe I answered too quickly.

I'll have a look tonight

French translation for new terms :

• Rule : Règle
• Implement : Activer
• Active : Actif
• Description : Description
• Deactivates : Désactive
• RQG Cat Mod Breaks : Mod. de Cat. à la RQG
• Category modifiers in +5 bands, each 4 points either side of the 9-12 band : Modification par tranche de 5pts au dessous de 9 ou au dessus de 12
• RQ3 Cat Mod Breaks : Mod. de Cat. à la RQ3
• Category modifiers +/- 1 per characteristic point either side of 10RQG Cat Mod Breaks : Modification +/-1 par pt de caractéristique au dessus ou au dessous de 10

Considering "Parler langue" a pleonasm and the fact that d' is in french only usable before a vowel,  I propose some changes for the languages names translation.

• keep "Parler" for the speak skill and take for:

• Darktongue	Des Ténèbres
  Earthtongue	De la Terre
  Spiritspeech	Des Esprits
  Boatspeech	Marin

• Stormspeech	Des tempête
  Firepeech	Du Feu
  Beastspeech	Des Bêtes

• Why did you went back to "Conn. Pays natal" for "Homeland lore" ?        Previous correction was "Conn. région" and it was perfect.  Please, place "Conn. région" as the traslation of "Homeland lore".
• "Cowbell" is intented to describe a bell around cow's neck ? if yes, "Sonnaille" is OK.

P152, the last sentence of In sight paragraph seems unfinished to my French eyes:

The  gamemaster may choose to change the time scale  from melee rounds to 

Greg has brought to many players around the world a lot of happiness by sharing his creations.

our thoughts are with his loved ones.

Is there enough room for

L. des Bêtes instead of d'Betes ?

And

L. des Ténèbres instead of d'Tenebres ?

For "parler langue", I think it's wasting space, but maybe you have an idea behind this modification?

17 hours ago, PhilHibbs said:

v1.9: https://docs.google.com/spreadsheets/d/1gLCGxM8OKBOZDDst5tsoYN31jcSqd6mfSRnqqUqJOkY/edit?usp=sharing

• Fixed another French translation

@sireRage Can you check over the French instructions, please, I've attempted to update it to describe the new translation mechanism but I probably bungled something!

You're right, I forgot some old translation system on the wiki page. I reworked the translation chapter on the french page to give hints how to add a new language or modify an existing one (for example to be closer to the official french rules if they appear someday).

I realize just now the count column usage. It's there you see if there is two times the same expression in the column, right ?

If so, ther is still "(a) normal year" which give same french term "Une année calme" and "devoured/Fed to the Crimson Bat" giving "dévoré par la chauve souris pourpre"

12 hours ago, PhilHibbs said:

I thought I had already applied most of those changes of yours, I think I might have lost a version somewhere.

Lost in translation 😊

There's just one omitted translation : Line 136 : "Homeland lore" have to be "Conn. région"

And everythings will then be fine for me.

Can you update french translation ?

I've changed some wordings and added "spirit lore".

Don't bother anymore with Marchand : Merchant will be "Marchand." and "Tradetalk", "Marchand"

For Actuel/Actu. I changed them to "Actuelle" and "Actuel"

All the changes are on a background of color different from the green

Traduction_FR

I've translated the wiki page.

here's the link to the french version

https://runequest-glorantha.wikia.com/wiki/Création_de_personnage_avec_Google_Sheet_par_Phil_Hibbs

I let you juge the possibility to change the wiki adress during the translate process, or adding this link into your first post, with the sheet link.

Good luck

Nice job, thanks

I still prefer Actuel to Actu on charsheet, especially since the full version of current is no longer used anywhere in the sheet. So I propose to remove the "Current" word from the translations and only work with Curr./Actuel.

Oh, and you didn't took into account my other points : "Langue natale" instead of "Parler natale", Homeland lore must be translated to "Conn. région" instead of "Conn. pays natal"

my translation file, on google drive is roughly up to date

Charsheet/Ab57 isn't translated (spirit lore = "Conn. des esprits" or "Conn. (Esprits)", as you prefer)

By the way, is it possible, to simplify the translation process ? I though it was maybe possible to migrate the translate button to Chargen/somewhere under A13 and make the macro associated to copy/paste the right language col using the choice made in chargen/A13 ?

For example, the user choose "Français" on Chargen/A13 and click on translate (wich is placed near there, on the same sheet), and the translate macro makes a copy of the french column from translation and launch the translation process as usual.

By this way, non english users can use the sheet without having to dive into others

Nice job, thanks

I still prefer Actuel to Actu on charsheet, especially since the full version of current is no longer used anywhere in the sheet. So I propose to remove the "Current" word from the translations and only work with Curr./Actuel.

By the way, is it possible, to simplify the translation process ? I though it was maybe possible to migrate the translate button to Chargen/somewhere under A13 and make the macro associated copy/paste the right language col using the choice made in chargen/A13 ?

For example, the user choose "Français" on Chargen/A13 and click on translate (wich is placed near there, on the same sheet), and the translate macro makes a copy of the french column from translation and launch the translation process as usual.

By this way, non english users can use the sheet without having to dive into others tab and make copy/paste not so obvious to everyone.