Reply to thread

Message

<blockquote data-quote="KarinsDad" data-source="post: 6545269" data-attributes="member: 2011">Math flaw.If one were to create an Excel spreadsheet with 20 rows (1-20) and 20 columns (1-20) and use the equation MAX(B$1,$A2)-MIN(B$1,$A2) (adjusted for row and column), they would get your answer.However, this assumes that the lowest dice is always the &quot;first dice rolled&quot; which is the flaw.One has to decide whether the rows or the columns are the &quot;first dice rolled&quot; and then remove the MAX(B$1,$A2)-MIN(B$1,$A2) and replace it by zero for those squares that are greater than or equal to the &quot;second roll&quot; (i.e. 15 on first roll followed by 6 on second roll is not an increase of 9, it is an increase of 0). Or alternatively, one can put an IF statement into the Excel, but I didn't bother with that.Once that is done, the total bonus for all 400 squares (190 squares gain a bonus in 1 to 19 range, 210 gain a bonus of zero, i.e. the first roll was greater or equal to the second roll) becomes 1330. 1330 / 400 = +3.325.This was a cool try, but mathematically flawed. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60e.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":cool:" title="Cool&nbsp; &nbsp; :cool:"&nbsp; data-smilie="6"data-shortname=":cool:" />Edit: Fixed my math typo. I hate getting old and mistyping. <img src="http://www.enworld.org/forum/images/smilies/laugh.png"&nbsp; class="smilie" loading="lazy" alt=":lol:" title="Laughing&nbsp; &nbsp; :lol:" data-shortname=":lol:" /></blockquote>

[QUOTE="KarinsDad, post: 6545269, member: 2011"] Math flaw. If one were to create an Excel spreadsheet with 20 rows (1-20) and 20 columns (1-20) and use the equation MAX(B$1,$A2)-MIN(B$1,$A2) (adjusted for row and column), they would get your answer. However, this assumes that the lowest dice is always the "first dice rolled" which is the flaw. One has to decide whether the rows or the columns are the "first dice rolled" and then remove the MAX(B$1,$A2)-MIN(B$1,$A2) and replace it by zero for those squares that are greater than or equal to the "second roll" (i.e. 15 on first roll followed by 6 on second roll is not an increase of 9, it is an increase of 0). Or alternatively, one can put an IF statement into the Excel, but I didn't bother with that. Once that is done, the total bonus for all 400 squares (190 squares gain a bonus in 1 to 19 range, 210 gain a bonus of zero, i.e. the first roll was greater or equal to the second roll) becomes 1330. 1330 / 400 = +3.325. This was a cool try, but mathematically flawed. :cool: Edit: Fixed my math typo. I hate getting old and mistyping. :lol: [/QUOTE]

Verification