RQG Character Creation Spreadsheet (multi-lingual) now includes Weapons & Equipment! And 日本語!

[PhilHibbs]

v1.9.6 Beta 4: https://docs.google.com/spreadsheets/d/1Dd9JcHZN-T2iD1x_ko7mDF4vDGWJDr8DTcIg2HICA84/edit?usp=sharing

• Fixed a bug where reassigning a rune to a different characteristic did not work on translated sheets.
• Sorting of skills alphabetically no longer spoils the coloured banding of the skill rows.

 

 

[PhilHibbs]

On 7/14/2020 at 12:45 PM, ChristianD said:

One small bug that I can report, when translated (in french) if you remove a rune to get a CHA increase instead, then it changes the rune back to english and the augment is not calculated. For example if you delete the "Terre" rune (in W3), then you will get the "Earth" rune in W8 and therefore a zero value in X8. A very minor bug though...

Cheers! Fixed - if you want to patch it in to your sheet, un-hide the I18N Lookups tab and copy the 6 new rows across from the latest version, and copy across the formula in the W8 cell that figures out which rune is missing. Or, you know, just type in the French rune name...

[sireRage]

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?

Edited September 5, 2020 by sireRage

[PhilHibbs]

2 hours ago, sireRage said:

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

Excellent, thanks a lot!

Quote

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

Only if you want also the French skill percentages. Changing the language and changing the occupation skill percentages are separate functions, so you can use English language and French skill percentages, or vice versa.

Language is translated on the main CharGen sheet, whereas the occupation skill percentages are changed on the Rules tab

Edited September 5, 2020 by PhilHibbs

[Bill the barbarian]

On 7/3/2020 at 11:42 PM, DreadDomain said:

What is different in the French edition? 

The accent...

 

On 7/4/2020 at 4:45 PM, DreadDomain said:

I am surprised and intrigued that the French edition will have tweaks. I wonder what else will differ...

The wine man, the wine!

 

On 7/10/2020 at 1:31 PM, lordabdul said:

My first reaction was to go check the occupation skill bonuses for the Hunter in the French version and YES, PEOPLE, WE DID IT (let's take credit for this shall we? ). The Hunter went from 140 points in the English version to 200 points in the French version. I haven't checked what other changes have been made, and frankly I'm not sure what I can share at this point anyway.

 

Go Hunters!

 

On 7/14/2020 at 5:45 AM, ChristianD said:

Thanks a lot Phil for the huge work!

 

I'm with him Phil, good on ya!

[Singemonkey]

Made some chars this week and I noticed that spirit combat was evaluating to 1D6+3 despite the Pow+Char being over 33 *and* the char being an assistant shaman. It should have evaluated to 1D6+4 with the +1 from the assistant shaman occupation?

Phenomenal work Phil.

[PhilHibbs]

21 minutes ago, Singemonkey said:

Made some chars this week and I noticed that spirit combat was evaluating to 1D6+3 despite the Pow+Char being over 33 *and* the char being an assistant shaman. It should have evaluated to 1D6+4 with the +1 from the assistant shaman occupation?

Phenomenal work Phil.

Ok, one for the bug list and backlog...

[PhilHibbs]

V1.9.6 Beta 5: https://docs.google.com/spreadsheets/d/1mtWV2l9ow3J8aeDH78cFkibjbV9o-OXDJ_oLUaOIoQc/edit?usp=sharing

• Apprentice Shaman occupation gives +1 to Spirit Combat Damage Bonus

If your character is not actively working as an assistant shaman,  such as Vishi Dunn in exile in Sartar, then you should not get this bonus. Therefore once the Assistant Shaman entry in the Profession box is done with (you've clicked the button and got the skills), change it to something like "Ex-Assistant Shaman" and the bonus will no longer be applied on the character sheet. Note that this edited entry will not be translated into other languages.

Edited April 6, 2021 by PhilHibbs

[TeacherX]

How about Non-Humans?  Change the Man - beast rune set?  Just now returning to RQ since Version 2.  Thanks for your work.

 

[PhilHibbs]

11 minutes ago, TeacherX said:

How about Non-Humans?  Change the Man - beast rune set?  Just now returning to RQ since Version 2.  Thanks for your work.

 

Yes, if you pick "Aldryami" and press the button above the stats then the Beast rune gets swapped for a Plant rune.

[PhilHibbs]

I've been trying to implement a new feature, but I'm struggling with it. I want to be able to copy the data from an old version of the sheet into a new version, but permissions seem to be a problem. Google is, probably quite rightly, making it really hard to do this because it would mean that my code could in theory access any and all of your Google sheets and do anything it wants with your data.

So I don't think this feature will be coming any time soon, unless anyone here knows how to get around this and grant my code limited permission to access other specific documents in your Google account.

Maybe I could do it by having the user copy their CharGen, CharSheet, and Family History tabs into the new sheet with "Copy to > Existing spreadsheet", and then have code in the new sheet pick up the data from the copied sheets, and delete them afterwards.

Edited April 5, 2021 by PhilHibbs

[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?

Edited April 6, 2021 by sireRage
clarification

[PhilHibbs]

12 hours ago, sireRage said:

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?

Thanks, I'll try it... It's not very intuitive, I sat staring at the "REF!" until I accidentally moused over it and it said "You need to connect these sheets" with a button to click. So maybe... I will play around a little more. There are a lot of ranges that will need importing, but you only need to click that once.

IMPORTRANGE is not ideal. The imported data can't be distinguished between a formula result and a literal value. The dice roll results in the Value column might be derived from the random numbers in the Roll column, or they may be manually entered dice rolls. There's no way I can tell this in the results of an IMPORTRANGE. Same for any manual override value that is normally, or defaulted by, a formula. For example, the specialist skill names e.g. Darktongue start out as formulae that calculate a number of spaces that pad out the "Speak (           )" to the right length. This will just be a literal string of spaces in the IMPORTRANGE result, I guess I could special-case that, but that's getting complicated.

I suppose if I copy across the ranges in a sensible order, I can take an approach of only copying across a value if it is different to the calculated value in the new sheet.

Oh, yes this is working really nicely!

Building a complete list of all ranges to copy across, that's going to take some time.....

Edited April 6, 2021 by PhilHibbs

[PhilHibbs]

New bug found:

• Translating to another language does not translate the French and English alternative skill value for Sing that Ernalda cultists get. This will remain the "Sing" skill and will not be translated to "Chant", for example, and so Ernalda cultists will not get the changed value.

Fixed in v1.9.7 Alpha 1: https://docs.google.com/spreadsheets/d/1nBxpA8nvCItSoyyhd-Npp2UXv2HNLmDfgi_KkjZTVHo/edit?usp=sharing

• Fixed translation of Sing skill alternative value in French rule set.
• Added new column for keeping track of changes to Rune values after character creation (values added in the Extra column will not affect the characteristic bonus, which the Adds column does affect).

Edited April 6, 2021 by PhilHibbs

[PhilHibbs]

V1.9.7 Alpha 1 is badly broken! That's why it's called "Alpha"... 

V1.9.7 Alpha 2: https://docs.google.com/spreadsheets/d/1A9RfzOPgKcigkgC54j2AxTpxI2pPABhm18uK6MjMbSs/edit?usp=sharing

• The Rune Extra column messed up swapping in the race areas (which happens even for Human). I had not added the two extra columns to the alternative sheets that pull in the hit location calculations.

In any case, I think I messed up sharing V1.9.7 Alpha 1 and nobody had access to it.

[PhilHibbs]

V1.9.7 Alpha 3: https://docs.google.com/spreadsheets/d/1U9EjuBt1pmyUdAMg8ae76B1WUxdE2HfgmAxfERCXf_g/edit

• Added copying of characters from one version of the sheet to another. Unfortunately, versions prior to this are not supported as they lack the named ranges that this feature uses. This will allow future versions to import a character from any version from V1.9.7 Alpha 3 onwards.

I could, in theory, support older versions but that would require you to paste some code into the code editor of your sheet. Let me know if you need this, and what version you are using! No promises!

New "RuneQuest" menu added.

First, run the "Start copy from old sheet" command from the RuneQuest menu.

Allow permissions, you might need to run the command again after this if it did nothing.

Paste the URL of the source spreadsheet into the pop up box and click OK.

You will be presented with the "working area" of the copy process. When this has loaded, cell A3 should say "#N/A". Mouse over this, and a pop-up should appear with a button "Allow Access". Click this.

Next, run the "Continue copy from old sheet" command from the RuneQuest menu.

Everything will be copied over.

I say "everything" - I have defined certain ranges that will be copied, anything outside of those ranges will not be. They cover all the blue cells on the CharGen tab, and most of the cells that people will have entered data on CharSheet.

It does not copy:

• Skill ticks.
• Armour Points on the hit location chart.
• Any edited weapon stats, e.g. iron or enchanted/gifted for extra HP.
• New weapons added to the Weapons tab.
• Family History.

If you are copying a non-human with changes such as aldryami, centaur, or baboon, or you are using a different language, apply those changes to the new sheet first prior to copying.

IN PARTICULAR, if you have sorted the skills into a new order, then everything will be wrong! Make sure that the new sheet is sorted the same way as the old, or vice versa!

Edited April 9, 2021 by PhilHibbs

[PhilHibbs]

I have added support for copying from V1.9.4 and layout-compatible versions, I'd need to trace back and forward through the versions to see where the layout changes.

If anyone is interested in this feature, and is using a version close to that, please let me know. I am in the process of converting the "canonicals" that I recreated a while back using that version.

Here they all are:

Vasana
Yanioth
Harmast
Vishi Dunn
Vostor
Sorala
Nathem

Vostor was complicated. For some reason I had added an extra language to Vostor, but I don't think it was necessary. This made all the skills after that language mis-align by one and everything broke! Removing the extra language from the (copy of the) original and re-doing the copy into a fresh sheet fixed the problem.

Seems like Sorala was where the problem started, she has an extra written language, and Vostor probably was created using the same sheet. I managed to get Sorala done, but it was messy getting everything to work properly.

Edited April 8, 2021 by PhilHibbs
Added new Vasana

[PhilHibbs]

So here's the process for copying a character from an old version, that is layout-identical to V1.9.4:

• Go to Extensions > Apps Script.
• Paste in this code, in addition to the existing code:

Spoiler

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('RuneQuest')
      .addItem('Create Copy Ranges', 'CreateCopyRanges')
      .addToUi();
}

function CreateCopyRanges() {
  // v1.9.4
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.setNamedRange('AdventurerBorn', spreadsheet.getRange('CharSheet!R4'));
  spreadsheet.setNamedRange('AdventurerHomeland', spreadsheet.getRange('CharSheet!F3'));
  spreadsheet.setNamedRange('AdventurerName', spreadsheet.getRange('CharSheet!E2'));
  spreadsheet.setNamedRange('AdventurerOccupation', spreadsheet.getRange('CharSheet!G4'));
  spreadsheet.setNamedRange('AdventurerPlayer', spreadsheet.getRange('CharSheet!R2'));
  spreadsheet.setNamedRange('AdventurerTribe', spreadsheet.getRange('CharSheet!S3'));
  spreadsheet.setNamedRange('Assign', spreadsheet.getRange('CharGen!F2:F27'));
  spreadsheet.setNamedRange('BaseRoll', spreadsheet.getRange('CharGen!U2:U8'));
  spreadsheet.setNamedRange('CultLevel', spreadsheet.getRange('CharSheet!Q85:Q86'));
  spreadsheet.setNamedRange('CultName', spreadsheet.getRange('CharSheet!D85:D86'));
  spreadsheet.setNamedRange('CultRP', spreadsheet.getRange('CharSheet!AD85:AD86'));
  spreadsheet.setNamedRange('CultRP1', spreadsheet.getRange('CharSheet!AI85:AI86'));
  spreadsheet.setNamedRange('CultRP2', spreadsheet.getRange('CharSheet!AL85:AL86'));
  spreadsheet.setNamedRange('DiceRandoms', spreadsheet.getRange('CharGen!G2:G27'));
  spreadsheet.setNamedRange('DiceValues', spreadsheet.getRange('CharGen!I2:I27'));
  spreadsheet.setNamedRange('Equipment', spreadsheet.getRange('CharSheet!B101:B112'));
  spreadsheet.setNamedRange('FamilyBorn', spreadsheet.getRange('CharSheet!AB79:AB83'));
  spreadsheet.setNamedRange('FamilyClan', spreadsheet.getRange('CharSheet!N79:N83'));
  spreadsheet.setNamedRange('FamilyDied', spreadsheet.getRange('CharSheet!AE79:AE83'));
  spreadsheet.setNamedRange('FamilyNames', spreadsheet.getRange('CharSheet!E79:E83'));
  spreadsheet.setNamedRange('FamilyOcc', spreadsheet.getRange('CharSheet!T79:T83'));
  spreadsheet.setNamedRange('FamilySib', spreadsheet.getRange('CharSheet!AH79:AH83'));
  spreadsheet.setNamedRange('PassionBonus', spreadsheet.getRange('CharGen!BP2:BP13'));
  spreadsheet.setNamedRange('PassionChoice', spreadsheet.getRange('CharGen!BO2:BO13'));
  spreadsheet.setNamedRange('PassionDetail', spreadsheet.getRange('CharGen!BM2:BM11'));
  spreadsheet.setNamedRange('PassionType', spreadsheet.getRange('CharGen!BL2:BL11'));
  spreadsheet.setNamedRange('PermAdds', spreadsheet.getRange('CharGen!V2:V8'));
  spreadsheet.setNamedRange('Posessions', spreadsheet.getRange('CharSheet!O101:O112'));
  spreadsheet.setNamedRange('RepGain', spreadsheet.getRange('CharSheet!AL101:AL112'));
  spreadsheet.setNamedRange('Reputation', spreadsheet.getRange('CharSheet!AB101:AB112'));
  spreadsheet.setNamedRange('RuneAdds', spreadsheet.getRange('CharGen!P2:P17'));
  spreadsheet.setNamedRange('RuneBonusNames', spreadsheet.getRange('CharGen!W2:W8'));
  spreadsheet.setNamedRange('RuneChoice', spreadsheet.getRange('CharGen!O2:O17'));
  spreadsheet.setNamedRange('RuneCulture', spreadsheet.getRange('CharGen!N2:N17'));
  spreadsheet.setNamedRange('RuneSpellNames', spreadsheet.getRange('CharSheet!N89:N98'));
  spreadsheet.setNamedRange('RuneSpellPts', spreadsheet.getRange('CharSheet!W89:W98'));
  spreadsheet.setNamedRange('SkillChoice', spreadsheet.getRange('CharGen!BH2:BH123'));
  spreadsheet.setNamedRange('SkillChoiceCult', spreadsheet.getRange('CharGen!BG2:BG123'));
  spreadsheet.setNamedRange('SkillCult', spreadsheet.getRange('CharGen!BF2:BF123'));
  spreadsheet.setNamedRange('SkillCulture', spreadsheet.getRange('CharGen!BD2:BD123'));
  spreadsheet.setNamedRange('SkillDetail', spreadsheet.getRange('CharGen!AW2:AW123'));
  spreadsheet.setNamedRange('SkillExtra', spreadsheet.getRange('CharGen!BI2:BI123'));
  spreadsheet.setNamedRange('SkillOccupation', spreadsheet.getRange('CharGen!BE2:BE123'));
  spreadsheet.setNamedRange('SorceryNames', spreadsheet.getRange('CharSheet!Z89:Z98'));
  spreadsheet.setNamedRange('SpeciesMax', spreadsheet.getRange('CharGen!Y2:Y8'));
  spreadsheet.setNamedRange('SpiritSpellNames', spreadsheet.getRange('CharSheet!B89:B98'));
  spreadsheet.setNamedRange('SpiritSpellPts', spreadsheet.getRange('CharSheet!K89:K98'));
  spreadsheet.setNamedRange('TempAdds', spreadsheet.getRange('CharGen!AA2:AA10'));
  spreadsheet.setNamedRange('WeaponsMelee', spreadsheet.getRange('CharSheet!B64:B68'));
  spreadsheet.setNamedRange('WeaponsMeleeHP', spreadsheet.getRange('CharSheet!AG64:AG68'));
  spreadsheet.setNamedRange('WeaponsRanged', spreadsheet.getRange('CharSheet!B74:B76'));
  spreadsheet.setNamedRange('WeaponsRangedHP', spreadsheet.getRange('CharSheet!AG74:AI76'));
  spreadsheet.setNamedRange('WeaponsShields', spreadsheet.getRange('CharSheet!B70:B72'));
  spreadsheet.setNamedRange('WeaponsShieldsHP', spreadsheet.getRange('CharSheet!AG70:AG72'));
};

• Click the Save button .
• Close the Script Editor tab.
• In the browser tab that the character sheet is loaded in, click the browser's Refresh button .
• Wait for it to re-load, then wait a few seconds more until the RuneQuest menu appears after the Help menu, this might take around 20 seconds to happen in my experience.
• Run the RuneQuest > Create Copy Ranges command and wait for it to complete, takes around 30 seconds. If you open up Data > Named Ranges, you can see the new ranges appear. They are in alphabetical order, so when it gets to the "Weapons" ranges, it's done.
• Go to the new sheet, a copy of the v1.9.7 or later sheet.
• Set the Race as appropriate, and click the  button. Give permission if necessary, and click it again if it didn't do anything (it should reduce the INT and SIZ entries to two each for humans, or to whatever the dice are for other races). 
• Run the RuneQuest > Start copy from old sheet command.
• Follow the instructions, after you click "Ok" it should bring up the working area for the copy process, which might initially say #NA! which should quickly change to #REF!. When you click the "Allow access" button that pops up when you mouse over the #REF!, then the #REF! should be replaced with the character's name. This confirms that the access is working, and you pasted in the right URL.
• Run the RuneQuest > Continue copy from old sheet command.
• You will see it step through the ranges, data will flash through on the sheet until all the ranges are copied.

If anyone wants to do this and is using a layout that is not identical to V1.9.4, let me know and I can fairly easily customise the code for a different layout.

Edited December 9, 2021 by PhilHibbs

[PhilHibbs]

OOPS!

Found a new bug! Well not new, it's been in since 1.7!

• Treat Disease and Treat Poison do not show up on the character sheet.

I'm going to fix it by removing a couple of the Lore (            ) entries. It was the change over to a flexible list of lores like this that brought in this bug.

[PhilHibbs]

V1.9.7 Beta 4: https://docs.google.com/spreadsheets/d/1Q-jETXJlWzZ7Qxem1NRyPJ3TRfctD4GUMUdKiC_5f5M

• Treat Disease and Treat Poison now show up on the character sheet.
• Minor improvements to copy-from-old-version functionality.
• Sorcery spells are now a drop-down list again.
• If there is a tie for highest rune or second highest rune, the first rune in the list wins in terms of which characteristic gets the bonus. Previously, no bonus was given. You can still break the tie manually by adding an extra 0.1 or 0.2 to the Adds column.

Edited April 8, 2021 by PhilHibbs

[PhilHibbs]

OOPS!

Found a new bug!

• Critical and Special chance calculations in columns BU and BV on the CharGen tab do not take into account temporary bonuses.

[PhilHibbs]

V1.9.7 Beta 1: https://docs.google.com/spreadsheets/d/1AlKinzaEIdaXO_nkM7bYNBGZw7x5rFgWvdvaHuCPUwg

• Fix critical and special calculations for temporary skills on CharGen tab.
• Fumble chances now show as 00 instead of 100.
• Added new column to hold temporary skill bonuses that are added into the temporary skill level, for example for Bladesharp skill increase.
• The "Copy from old sheet" functionality now supports Family History. Below is the new code to add into the old sheet's Code Editor to support this.

Spoiler

 

function onOpen() {

  var ui = SpreadsheetApp.getUi();

  ui.createMenu('RuneQuest')

      .addItem('Create Copy Ranges', 'CreateCopyRanges')

      .addToUi();

}

 

function CreateCopyRanges() {

  // v1.9.4

  var spreadsheet = SpreadsheetApp.getActive();

  spreadsheet.setNamedRange('AdventurerBorn', spreadsheet.getRange('CharSheet!R4'));

  spreadsheet.setNamedRange('AdventurerHomeland', spreadsheet.getRange('CharSheet!F3'));

  spreadsheet.setNamedRange('AdventurerName', spreadsheet.getRange('CharSheet!E2'));

  spreadsheet.setNamedRange('AdventurerOccupation', spreadsheet.getRange('CharSheet!G4'));

  spreadsheet.setNamedRange('AdventurerPlayer', spreadsheet.getRange('CharSheet!R2'));

  spreadsheet.setNamedRange('AdventurerTribe', spreadsheet.getRange('CharSheet!S3'));

  spreadsheet.setNamedRange('Assign', spreadsheet.getRange('CharGen!F2:F27'));

  spreadsheet.setNamedRange('BaseRoll', spreadsheet.getRange('CharGen!U2:U8'));

  spreadsheet.setNamedRange('CultLevel', spreadsheet.getRange('CharSheet!Q85:Q86'));

  spreadsheet.setNamedRange('CultName', spreadsheet.getRange('CharSheet!D85:D86'));

  spreadsheet.setNamedRange('CultRP', spreadsheet.getRange('CharSheet!AD85:AD86'));

  spreadsheet.setNamedRange('CultRP1', spreadsheet.getRange('CharSheet!AI85:AI86'));

  spreadsheet.setNamedRange('CultRP2', spreadsheet.getRange('CharSheet!AL85:AL86'));

  spreadsheet.setNamedRange('DiceRandoms', spreadsheet.getRange('CharGen!G2:G27'));

  spreadsheet.setNamedRange('DiceValues', spreadsheet.getRange('CharGen!I2:I27'));

  spreadsheet.setNamedRange('Equipment', spreadsheet.getRange('CharSheet!B101:B112'));

  spreadsheet.setNamedRange('FamilyBorn', spreadsheet.getRange('CharSheet!AB79:AB83'));

  spreadsheet.setNamedRange('FamilyClan', spreadsheet.getRange('CharSheet!N79:N83'));

  spreadsheet.setNamedRange('FamilyDied', spreadsheet.getRange('CharSheet!AE79:AE83'));

  spreadsheet.setNamedRange('FamilyNames', spreadsheet.getRange('CharSheet!E79:E83'));

  spreadsheet.setNamedRange('FamilyOcc', spreadsheet.getRange('CharSheet!T79:T83'));

  spreadsheet.setNamedRange('FamilySib', spreadsheet.getRange('CharSheet!AH79:AH83'));

  spreadsheet.setNamedRange('PassionBonus', spreadsheet.getRange('CharGen!BP2:BP13'));

  spreadsheet.setNamedRange('PassionChoice', spreadsheet.getRange('CharGen!BO2:BO13'));

  spreadsheet.setNamedRange('PassionDetail', spreadsheet.getRange('CharGen!BM2:BM11'));

  spreadsheet.setNamedRange('PassionType', spreadsheet.getRange('CharGen!BL2:BL11'));

  spreadsheet.setNamedRange('PermAdds', spreadsheet.getRange('CharGen!V2:V8'));

  spreadsheet.setNamedRange('Posessions', spreadsheet.getRange('CharSheet!O101:O112'));

  spreadsheet.setNamedRange('RepGain', spreadsheet.getRange('CharSheet!AL101:AL112'));

  spreadsheet.setNamedRange('Reputation', spreadsheet.getRange('CharSheet!AB101:AB112'));

  spreadsheet.setNamedRange('RuneAdds', spreadsheet.getRange('CharGen!P2:P17'));

  spreadsheet.setNamedRange('RuneBonusNames', spreadsheet.getRange('CharGen!W2:W8'));

  spreadsheet.setNamedRange('RuneChoice', spreadsheet.getRange('CharGen!O2:O17'));

  spreadsheet.setNamedRange('RuneCulture', spreadsheet.getRange('CharGen!N2:N17'));

  spreadsheet.setNamedRange('RuneSpellNames', spreadsheet.getRange('CharSheet!N89:N98'));

  spreadsheet.setNamedRange('RuneSpellPts', spreadsheet.getRange('CharSheet!W89:W98'));

  spreadsheet.setNamedRange('SkillChoice', spreadsheet.getRange('CharGen!BH2:BH123'));

  spreadsheet.setNamedRange('SkillChoiceCult', spreadsheet.getRange('CharGen!BG2:BG123'));

  spreadsheet.setNamedRange('SkillCult', spreadsheet.getRange('CharGen!BF2:BF123'));

  spreadsheet.setNamedRange('SkillCulture', spreadsheet.getRange('CharGen!BD2:BD123'));

  spreadsheet.setNamedRange('SkillDetail', spreadsheet.getRange('CharGen!AW2:AW123'));

  spreadsheet.setNamedRange('SkillExtra', spreadsheet.getRange('CharGen!BI2:BI123'));

  spreadsheet.setNamedRange('SkillOccupation', spreadsheet.getRange('CharGen!BE2:BE123'));

  spreadsheet.setNamedRange('SorceryNames', spreadsheet.getRange('CharSheet!Z89:Z98'));

  spreadsheet.setNamedRange('SpeciesMax', spreadsheet.getRange('CharGen!Y2:Y8'));

  spreadsheet.setNamedRange('SpiritSpellNames', spreadsheet.getRange('CharSheet!B89:B98'));

  spreadsheet.setNamedRange('SpiritSpellPts', spreadsheet.getRange('CharSheet!K89:K98'));

  spreadsheet.setNamedRange('TempAdds', spreadsheet.getRange('CharGen!AA2:AA10'));

  spreadsheet.setNamedRange('WeaponsMelee', spreadsheet.getRange('CharSheet!B64:B68'));

  spreadsheet.setNamedRange('WeaponsMeleeHP', spreadsheet.getRange('CharSheet!AG64:AG68'));

  spreadsheet.setNamedRange('WeaponsRanged', spreadsheet.getRange('CharSheet!B74:B76'));

  spreadsheet.setNamedRange('WeaponsRangedHP', spreadsheet.getRange('CharSheet!AG74:AI76'));

  spreadsheet.setNamedRange('WeaponsShields', spreadsheet.getRange('CharSheet!B70:B72'));

  spreadsheet.setNamedRange('WeaponsShieldsHP', spreadsheet.getRange('CharSheet!AG70:AG72'));

  

  spreadsheet.setNamedRange('FH1582a', spreadsheet.getRange('Family History!E5'));

  spreadsheet.setNamedRange('FH1582b', spreadsheet.getRange('Family History!C7'));

  spreadsheet.setNamedRange('FH1582c', spreadsheet.getRange('Family History!C9'));

  spreadsheet.setNamedRange('FH1582d', spreadsheet.getRange('Family History!F11'));

  spreadsheet.setNamedRange('FH1597a', spreadsheet.getRange('Family History!E13'));

  spreadsheet.setNamedRange('FH1597b', spreadsheet.getRange('Family History!F15'));

  spreadsheet.setNamedRange('FH1602a', spreadsheet.getRange('Family History!E17'));

  spreadsheet.setNamedRange('FH1602b', spreadsheet.getRange('Family History!C19'));

  spreadsheet.setNamedRange('FH1602c', spreadsheet.getRange('Family History!F21'));

  spreadsheet.setNamedRange('FH1603a', spreadsheet.getRange('Family History!E23'));

  spreadsheet.setNamedRange('FH1603b', spreadsheet.getRange('Family History!F25'));

  spreadsheet.setNamedRange('FH1605a', spreadsheet.getRange('Family History!E27'));

  spreadsheet.setNamedRange('FH1605b', spreadsheet.getRange('Family History!C29'));

  spreadsheet.setNamedRange('FH1605c', spreadsheet.getRange('Family History!C31'));

  spreadsheet.setNamedRange('FH1605d', spreadsheet.getRange('Family History!C33'));

  spreadsheet.setNamedRange('FH1605e', spreadsheet.getRange('Family History!F35'));

  spreadsheet.setNamedRange('FH1608a', spreadsheet.getRange('Family History!E39'));

  spreadsheet.setNamedRange('FH1608b', spreadsheet.getRange('Family History!C41'));

  spreadsheet.setNamedRange('FH1608c', spreadsheet.getRange('Family History!F43'));

  spreadsheet.setNamedRange('FH1610a', spreadsheet.getRange('Family History!E45'));

  spreadsheet.setNamedRange('FH1610b', spreadsheet.getRange('Family History!C47'));

  spreadsheet.setNamedRange('FH1610c', spreadsheet.getRange('Family History!C49'));

  spreadsheet.setNamedRange('FH1610d', spreadsheet.getRange('Family History!F51'));

  spreadsheet.setNamedRange('FH1613a', spreadsheet.getRange('Family History!E53'));

  spreadsheet.setNamedRange('FH1613b', spreadsheet.getRange('Family History!C55'));

  spreadsheet.setNamedRange('FH1613c', spreadsheet.getRange('Family History!F57'));

  spreadsheet.setNamedRange('FH1615a', spreadsheet.getRange('Family History!E59'));

  spreadsheet.setNamedRange('FH1615b', spreadsheet.getRange('Family History!C61'));

  spreadsheet.setNamedRange('FH1615c', spreadsheet.getRange('Family History!F63'));

  spreadsheet.setNamedRange('FH1616a', spreadsheet.getRange('Family History!E65'));

  spreadsheet.setNamedRange('FH1616b', spreadsheet.getRange('Family History!C67'));

  spreadsheet.setNamedRange('FH1616c', spreadsheet.getRange('Family History!C69'));

  spreadsheet.setNamedRange('FH1616d', spreadsheet.getRange('Family History!C71'));

  spreadsheet.setNamedRange('FH1616e', spreadsheet.getRange('Family History!F73'));

  spreadsheet.setNamedRange('FH1618a', spreadsheet.getRange('Family History!E75'));

  spreadsheet.setNamedRange('FH1618b', spreadsheet.getRange('Family History!C77'));

  spreadsheet.setNamedRange('FH1618c', spreadsheet.getRange('Family History!F79'));

  spreadsheet.setNamedRange('FH1619a', spreadsheet.getRange('Family History!E81'));

  spreadsheet.setNamedRange('FH1619b', spreadsheet.getRange('Family History!C83'));

  spreadsheet.setNamedRange('FH1619c', spreadsheet.getRange('Family History!F85'));

  spreadsheet.setNamedRange('FH1620a', spreadsheet.getRange('Family History!E87'));

  spreadsheet.setNamedRange('FH1620b', spreadsheet.getRange('Family History!C89'));

  spreadsheet.setNamedRange('FH1620c', spreadsheet.getRange('Family History!F91'));

  spreadsheet.setNamedRange('FH1621a', spreadsheet.getRange('Family History!E93'));

  spreadsheet.setNamedRange('FH1621b', spreadsheet.getRange('Family History!C95'));

  spreadsheet.setNamedRange('FH1621c', spreadsheet.getRange('Family History!C97'));

  spreadsheet.setNamedRange('FH1621d', spreadsheet.getRange('Family History!F99'));

  spreadsheet.setNamedRange('FH1622a', spreadsheet.getRange('Family History!E103'));

  spreadsheet.setNamedRange('FH1622b', spreadsheet.getRange('Family History!C105'));

  spreadsheet.setNamedRange('FH1622c', spreadsheet.getRange('Family History!C107'));

  spreadsheet.setNamedRange('FH1622d', spreadsheet.getRange('Family History!C109'));

  spreadsheet.setNamedRange('FH1622e', spreadsheet.getRange('Family History!F111'));

  spreadsheet.setNamedRange('FH1623a', spreadsheet.getRange('Family History!E113'));

  spreadsheet.setNamedRange('FH1623b', spreadsheet.getRange('Family History!C115'));

  spreadsheet.setNamedRange('FH1623c', spreadsheet.getRange('Family History!C117'));

  spreadsheet.setNamedRange('FH1623d', spreadsheet.getRange('Family History!F119'));

  spreadsheet.setNamedRange('FH1624a', spreadsheet.getRange('Family History!E121'));

  spreadsheet.setNamedRange('FH1624b', spreadsheet.getRange('Family History!C123'));

  spreadsheet.setNamedRange('FH1624c', spreadsheet.getRange('Family History!C125'));

  spreadsheet.setNamedRange('FH1624d', spreadsheet.getRange('Family History!C127'));

  spreadsheet.setNamedRange('FH1624e', spreadsheet.getRange('Family History!C129'));

  spreadsheet.setNamedRange('FH1624f', spreadsheet.getRange('Family History!F131'));

  spreadsheet.setNamedRange('FH1625a', spreadsheet.getRange('Family History!E133'));

  spreadsheet.setNamedRange('FH1625b', spreadsheet.getRange('Family History!C135'));

  spreadsheet.setNamedRange('FH1625c', spreadsheet.getRange('Family History!C137'));

  spreadsheet.setNamedRange('FH1625d', spreadsheet.getRange('Family History!C139'));

  spreadsheet.setNamedRange('FH1625e', spreadsheet.getRange('Family History!C141'));

  spreadsheet.setNamedRange('FH1625f', spreadsheet.getRange('Family History!F143'));

};

 

Edited April 9, 2021 by PhilHibbs

[Lordabdul]

I tried to create a couple character using the sheet and I'm not sure if I did something wrong, but I had to populate the lookups by hand for the spirit and rune spells, so that the dropdowns on the Character Sheet work... are those lookups supposed to be done at the beginning when you click the "down arrow" button just after picking race/occupation/cult?

[PhilHibbs]

13 hours ago, lordabdul said:

I tried to create a couple character using the sheet and I'm not sure if I did something wrong, but I had to populate the lookups by hand for the spirit and rune spells, so that the dropdowns on the Character Sheet work... are those lookups supposed to be done at the beginning when you click the "down arrow" button just after picking race/occupation/cult?

Yes, it worked for me when I did Mago the other day. I'll check. It's the Cult arrow that does it.

What version, what cult?

Edited April 18, 2021 by PhilHibbs

[PhilHibbs]

13 hours ago, lordabdul said:

I tried to create a couple character using the sheet and I'm not sure if I did something wrong, but I had to populate the lookups by hand for the spirit and rune spells, so that the dropdowns on the Character Sheet work... are those lookups supposed to be done at the beginning when you click the "down arrow" button just after picking race/occupation/cult?

Ah, I think I found it, is it Yelm? Because I've made a typo in the spells list, it's down as "Yem"!