Reply to thread

Message

<blockquote data-quote="phoffman" data-source="post: 7536253" data-attributes="member: 77498">Some fixesDon't attempt these changes unless you are well versed in xls.&nbsp; I will not respond to any requests.I have a guess that the same reason your spells don't show unless ALL is selected is the same reason Forest gnome didn't show unless ALL is selected.[sblock=FIXES]Some Changes to 2.28b8. All changes to Cells are on Worksheet &quot;Tables&quot;Fix PHB options not showing when &quot;All&quot; isn't selected on Start sheet. A few different ways to do this formula but this worked for BSQ2:BSQ2 =IF(INDEX(Start!$AJ$3:$AJ$12,MATCH(&quot;PHB&quot;,Start!$AG $3:$AG$12,0))=OptionSelect,OptionSelect,&quot;&quot;)Feral Tiefling overrides statistics of any subrace:CR17 =IF(RaceBase=$A$29,&quot;&quot;,1)CS10 =IF(RaceBase=$A$29,2,&quot;&quot;)CS11 =IF(RaceBase=$A$29,2,1)CS12 =IF(RaceBase=$A$29,2,&quot;&quot;)CS13 =IF(RaceBase=$A$29,2,1)CS14 =IF(RaceBase=$A$29,2,&quot;&quot;)CS15 =IF(RaceBase=$A$29,2,&quot;&quot;)CS16 =IF(RaceBase=$A$29,2,&quot;&quot;)CS17 =IF(RaceBase=$A$29,2,&quot;&quot;)CT14 =IF(RaceBase=$A$29,&quot;&quot;,1)CU11 =IF(RaceBase=$A$29,1,&quot;&quot;)CU12 =IF(RaceBase=$A$29,1,&quot;&quot;)CU13 =IF(RaceBase=$A$29,1,&quot;&quot;)CU14 =IF(RaceBase=$A$29,1,&quot;&quot;)CU17 =IF(RaceBase=$A$29,1,&quot;&quot;)Fix Level advancement class abilities for custom subclasses, May fix other issues.GP2 =26Fix Sword Bard Proficiency with Medium ArmorABM85 =IF(ABM$1&gt;2,$WW85,&quot;&quot;)ABM86 =IF(ABM$1&gt;2,$WW86,&quot;&quot;)ABM87 =IF(ABM$1&gt;2,$WW87,&quot;&quot;)ABM88 =IF(ABM$1&gt;2,$WW88,&quot;&quot;)ABM89 =IF(ABM$1&gt;2,$WW89,&quot;&quot;)ABM90 =IF(ABM$1&gt;2,$WW90,&quot;&quot;)Fix Sword Bard to only show selected Fighting Style [Known Issue as a result of this change, if multi-classing, Fighting Styles shown in drop down selection for Bard Swords Level 3 will list those available to all classes. Selecting anything other than Dueling or Two-Weapon Fighting will not display that fighting style Under this class feature.][Trying to minimize changes made. This solution for IO50 isn't elegant and if the text changes in IN50 the numbers in the formula will need updating. This solution is to get around the 255 character limit in formulas.]Copy Existing Cell IO50 to cell IN50 IO50 =LEFT(IN50,259)&amp;IF(QT10=QR31,MID(IN50,420,137),IF( QT10=QR34,MID(IN50,557,135),&quot; (&quot; &amp; SelectText&amp;&quot;)&quot;))&amp;RIGHT(IN50,1451)[/sblock]</blockquote>

[QUOTE="phoffman, post: 7536253, member: 77498"] [b]Some fixes[/b] Don't attempt these changes unless you are well versed in xls. I will not respond to any requests. I have a guess that the same reason your spells don't show unless ALL is selected is the same reason Forest gnome didn't show unless ALL is selected. [sblock=FIXES]Some Changes to 2.28b8. All changes to Cells are on Worksheet "Tables" Fix PHB options not showing when "All" isn't selected on Start sheet. A few different ways to do this formula but this worked for BSQ2: BSQ2 =IF(INDEX(Start!$AJ$3:$AJ$12,MATCH("PHB",Start!$AG $3:$AG$12,0))=OptionSelect,OptionSelect,"") Feral Tiefling overrides statistics of any subrace: CR17 =IF(RaceBase=$A$29,"",1) CS10 =IF(RaceBase=$A$29,2,"") CS11 =IF(RaceBase=$A$29,2,1) CS12 =IF(RaceBase=$A$29,2,"") CS13 =IF(RaceBase=$A$29,2,1) CS14 =IF(RaceBase=$A$29,2,"") CS15 =IF(RaceBase=$A$29,2,"") CS16 =IF(RaceBase=$A$29,2,"") CS17 =IF(RaceBase=$A$29,2,"") CT14 =IF(RaceBase=$A$29,"",1) CU11 =IF(RaceBase=$A$29,1,"") CU12 =IF(RaceBase=$A$29,1,"") CU13 =IF(RaceBase=$A$29,1,"") CU14 =IF(RaceBase=$A$29,1,"") CU17 =IF(RaceBase=$A$29,1,"") Fix Level advancement class abilities for custom subclasses, May fix other issues. GP2 =26 Fix Sword Bard Proficiency with Medium Armor ABM85 =IF(ABM$1>2,$WW85,"") ABM86 =IF(ABM$1>2,$WW86,"") ABM87 =IF(ABM$1>2,$WW87,"") ABM88 =IF(ABM$1>2,$WW88,"") ABM89 =IF(ABM$1>2,$WW89,"") ABM90 =IF(ABM$1>2,$WW90,"") Fix Sword Bard to only show selected Fighting Style [Known Issue as a result of this change, if multi-classing, Fighting Styles shown in drop down selection for Bard Swords Level 3 will list those available to all classes. Selecting anything other than Dueling or Two-Weapon Fighting will not display that fighting style Under this class feature.] [Trying to minimize changes made. This solution for IO50 isn't elegant and if the text changes in IN50 the numbers in the formula will need updating. This solution is to get around the 255 character limit in formulas.] Copy Existing Cell IO50 to cell IN50 IO50 =LEFT(IN50,259)&IF(QT10=QR31,MID(IN50,420,137),IF( QT10=QR34,MID(IN50,557,135)," (" & SelectText&") "))&RIGHT(IN50,1451) [/sblock] [/QUOTE]

Verification