Reply to thread

Message

<blockquote data-quote="Emirikol" data-source="post: 7310213" data-attributes="member: 10638">Release version 9.1:&nbsp; Ability score errata correction<a href="https://www.dropbox.com/s/xr8anueq2yaw90x/D%26D%205e%20Random%20Character%20Generator%209.1%20RELEASE%20VERSION.xlsx?dl=0" target="_blank">https://www.dropbox.com/s/xr8anueq2yaw90x/D&amp;D 5e Random Character Generator 9.1 RELEASE VERSION.xlsx?dl=0</a>jhVERSION 9.1 FIXED REFERENCE ERRATASKILLS:DONE:&nbsp; Skills:&nbsp; added Proficiency title bar and bonus:&nbsp; CELL SKILLS!G27 to the bottom:&nbsp; &nbsp; =IF((SUM(D27:F27 ))&lt;&gt;0,MATH!$C$46,0)DONE:&nbsp; Skills!G47, G48 reference two of the skills.&nbsp; Should reference ALL CLASS skillsDONE:&nbsp; Corrected cells BN8,9:&nbsp; were referencing races 28,29 rather than the drow, eladrin (23,24TOP SHEET:DONE:&nbsp; corrected column reference for Racial Wepaon proficiency box:&nbsp; PAGE 1: Weapon proficiencies lower cell: =VLOOKUP(MATH!C11,RACE!B6:O34,14,)DONE:&nbsp; EB28,28:&nbsp; only shows “ki save” and number if character is a monkDONE:&nbsp; Fixed:&nbsp; CS37, etc. only shows if character is a MysticDONE:&nbsp; Fixed:&nbsp; missing racial spellsRACE:DONE:&nbsp; Corrected Resistances:&nbsp; gnomes (none), tiefling fire, dragonborn typeMATH:DONE:&nbsp; d49:&nbsp; corrected reference column: =VLOOKUP(C11,RACE!$B$6:$AD$50,27)ABILITIESDONE: Fixed min-max reference error on CLASS:&nbsp; i4:n4 :::: Set to reference =ABILITIES!H36 to h41&nbsp; as correct scores nowDONE:&nbsp; Fixed reference error to MIN-max to raw scores: ABILITIES!D71 =IF(USER!$L$6=3,USER!K15,INDEX(CLASS!$I$6:$N$18,MATH!$C$8,1)) etc.DONE: fixed reference error if user wants to keep both chosen scores and chosen scores in specific order. ABILITIES!N71 (etc) now corrected:=IF(USER!$O$6=4,USER!K15,INDEX($H$70:$K$76,2,(1+USER!$O$6)))DONE: Add OR function to RANd+Save order determination to get correct output:&nbsp; ABILITIES!:f59 etc.*************THEY ARE SET TO NON-MIN MAX, SO MAY GET A MONK WHO IS MORE WISE THAN STRONGUSERDONE: ADDED:&nbsp; “NON RANDOM USER SET” choice to :&nbsp; USER!ABILITY SCORE RANDOMIZATION so USER determines the min-max order</blockquote>

[QUOTE="Emirikol, post: 7310213, member: 10638"] Release version 9.1: Ability score errata correction [url]https://www.dropbox.com/s/xr8anueq2yaw90x/D%26D%205e%20Random%20Character%20Generator%209.1%20RELEASE%20VERSION.xlsx?dl=0[/url] jh VERSION 9.1 FIXED REFERENCE ERRATA SKILLS: DONE: Skills: added Proficiency title bar and bonus: CELL SKILLS!G27 to the bottom: =IF((SUM(D27:F27 ))<>0,MATH!$C$46,0) DONE: Skills!G47, G48 reference two of the skills. Should reference ALL CLASS skills DONE: Corrected cells BN8,9: were referencing races 28,29 rather than the drow, eladrin (23,24 TOP SHEET: DONE: corrected column reference for Racial Wepaon proficiency box: PAGE 1: Weapon proficiencies lower cell: =VLOOKUP(MATH!C11,RACE!B6:O34,14,) DONE: EB28,28: only shows “ki save” and number if character is a monk DONE: Fixed: CS37, etc. only shows if character is a Mystic DONE: Fixed: missing racial spells RACE: DONE: Corrected Resistances: gnomes (none), tiefling fire, dragonborn type MATH: DONE: d49: corrected reference column: =VLOOKUP(C11,RACE!$B$6:$AD$50,27) ABILITIES DONE: Fixed min-max reference error on CLASS: i4:n4 :::: Set to reference =ABILITIES!H36 to h41 as correct scores now DONE: Fixed reference error to MIN-max to raw scores: ABILITIES!D71 =IF(USER!$L$6=3,USER!K15,INDEX(CLASS!$I$6:$N$18,MATH!$C$8,1)) etc. DONE: fixed reference error if user wants to keep both chosen scores and chosen scores in specific order. ABILITIES!N71 (etc) now corrected: =IF(USER!$O$6=4,USER!K15,INDEX($H$70:$K$76,2,(1+USER!$O$6))) DONE: Add OR function to RANd+Save order determination to get correct output: ABILITIES!:f59 etc. *************THEY ARE SET TO NON-MIN MAX, SO MAY GET A MONK WHO IS MORE WISE THAN STRONG USER DONE: ADDED: “NON RANDOM USER SET” choice to : USER!ABILITY SCORE RANDOMIZATION so USER determines the min-max order [/QUOTE]

Verification