Reply to thread

Message

<blockquote data-quote="Yarthok" data-source="post: 4438634" data-attributes="member: 64890">open office calc 2.4.1Thanks again for creating your excellent character designer!&nbsp;I don't own a copy of Excel and instead use OpenOffice 2.4.1 (latest non-beta release) on Vista. In order to get some of the calculations to work in openoffice, I made the changes listed below. If the changes are appropriate to Excel, then I hope you will consider adding them to your version. The list is only what I have discovered for the characters and levels I have designed. &nbsp;[code](Modifications to wiesbaden_charsheet_v1_15_Full.xls to work with OpenOffice 2.4.1)&nbsp;$'Transport Attack'.D8 (repeat for all 'basic attack' &amp; 'power' blocks on the same sheet)old value ==&gt; =D6*C8new value ==&gt; =VALUE(D6)*VALUE(C8)&nbsp;$'Transport Attack'.C25 (repeat for all 'basic attack' &amp; 'power' blocks on the same sheet)old value ==&gt; =IF(D17=TRUE();C19*C20+C21;&quot;&quot;)new value ==&gt; =IF(D17=TRUE();VALUE(C19)*VALUE(C20)+VALUE(C21);&quot;&quot;)&nbsp;$'Transport Attack'.D25 (repeat for all 'basic attack' &amp; 'power' blocks on the same sheet)old value ==&gt; =IF(D17=FALSE();IF(AND(D19=0;D20=0;D21=0);D23;D19*D20-D21);&quot;&quot;)new value ==&gt; =IF(D17=FALSE();IF(AND(VALUE(D19)=0;VALUE(D20)=0;VALUE(D21)=0);VALUE(D23);VALUE(D19)*VALUE(D20)-VALUE(D21));&quot;&quot;)&nbsp;$'Charsheet I'.CT15old value ==&gt; =10+SkillInsightnew value ==&gt; =10+VALUE(SkillInsight)&nbsp;$'Charsheet I'.CT21old value ==&gt; =10+SkillPerceptionold value ==&gt; =10+VALUE(SkillPerception)&nbsp;$'Pro Sheet'.BG58old value ==&gt; =IF(AQ54=&quot;&quot;;&quot;&quot;;IF(.I46=&quot;&quot;;.I40&amp;&quot;+&quot;&amp;VLOOKUP(.J44;.$8:$14;2;FALSE())&amp;IF(OR(.J42=&quot;&quot;;.J42=0);&quot;&quot;;&quot;+&quot;&amp;.J42);.J46))new value ==&gt; =IF(AQ54=&quot;&quot;;&quot;&quot;;IF(.I46=&quot;&quot;;.I40&amp;&quot;+&quot;&amp;VLOOKUP(.I44;.$8:$14;2;FALSE())&amp;IF(OR(.I42=&quot;&quot;;.I42=0);&quot;&quot;;&quot;+&quot;&amp;.I42);.I46))&nbsp;$'Pro Sheet'.AH20old value ==&gt; =10+SArcananew value ==&gt; =10+VALUE(SArcana)&nbsp;$'Pro Sheet'.AH23old value ==&gt; =10+SNaturenew value ==&gt; =10+VALUE(SNature)&nbsp;[/code]&nbsp;Again, thanks so much for your hard work. I know you chose Excel 2007 as your target. Anything you can do to accomodate openoffice user's is very appreciated, but I recognize the difficulty of trying to make your spreadsheet work in multiple programs. &nbsp;I am not an Excel or a Calc guru, so any feedback on the above code is appreciated.</blockquote>

[QUOTE="Yarthok, post: 4438634, member: 64890"] [b]open office calc 2.4.1[/b] Thanks again for creating your excellent character designer! I don't own a copy of Excel and instead use OpenOffice 2.4.1 (latest non-beta release) on Vista. In order to get some of the calculations to work in openoffice, I made the changes listed below. If the changes are appropriate to Excel, then I hope you will consider adding them to your version. The list is only what I have discovered for the characters and levels I have designed. [code] (Modifications to wiesbaden_charsheet_v1_15_Full.xls to work with OpenOffice 2.4.1) $'Transport Attack'.D8 (repeat for all 'basic attack' & 'power' blocks on the same sheet) old value ==> =D6*C8 new value ==> =VALUE(D6)*VALUE(C8) $'Transport Attack'.C25 (repeat for all 'basic attack' & 'power' blocks on the same sheet) old value ==> =IF(D17=TRUE();C19*C20+C21;"") new value ==> =IF(D17=TRUE();VALUE(C19)*VALUE(C20)+VALUE(C21);"") $'Transport Attack'.D25 (repeat for all 'basic attack' & 'power' blocks on the same sheet) old value ==> =IF(D17=FALSE();IF(AND(D19=0;D20=0;D21=0);D23;D19*D20-D21);"") new value ==> =IF(D17=FALSE();IF(AND(VALUE(D19)=0;VALUE(D20)=0;VALUE(D21)=0);VALUE(D23);VALUE(D19)*VALUE(D20)-VALUE(D21));"") $'Charsheet I'.CT15 old value ==> =10+SkillInsight new value ==> =10+VALUE(SkillInsight) $'Charsheet I'.CT21 old value ==> =10+SkillPerception old value ==> =10+VALUE(SkillPerception) $'Pro Sheet'.BG58 old value ==> =IF(AQ54="";"";IF(.I46="";.I40&"+"&VLOOKUP(.J44;.$8:$14;2;FALSE())&IF(OR(.J42="";.J42=0);"";"+"&.J42);.J46)) new value ==> =IF(AQ54="";"";IF(.I46="";.I40&"+"&VLOOKUP(.I44;.$8:$14;2;FALSE())&IF(OR(.I42="";.I42=0);"";"+"&.I42);.I46)) $'Pro Sheet'.AH20 old value ==> =10+SArcana new value ==> =10+VALUE(SArcana) $'Pro Sheet'.AH23 old value ==> =10+SNature new value ==> =10+VALUE(SNature) [/code] Again, thanks so much for your hard work. I know you chose Excel 2007 as your target. Anything you can do to accomodate openoffice user's is very appreciated, but I recognize the difficulty of trying to make your spreadsheet work in multiple programs. I am not an Excel or a Calc guru, so any feedback on the above code is appreciated. [/QUOTE]

Verification