Need Help To Split Expenses

lex_m · Jul 20, 2011

Lets say some people went out and bought stuff for a party, 4 in this case, and they want to split the expenses up equally between them. With the layout below how would you tell who owes who money? Are would there be a better way to set it up?
Thanks Excel 2003

Formulas in cells are
B1 =SUM(B6:B15)
B2 =COUNT(B6:B15)
B3 =B1/B2

Excel 2003<table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">amount of bill</td><td style="text-align: right;;">202.6</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">number of people</td><td style="text-align: right;;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">amount per person</td><td style="text-align: right;;">50.65</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="border-bottom: 1px solid black;;">Amount Spent By:</td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="font-weight: bold;text-align: right;color: #FF0000;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">Person 1</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">104.89</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">Person 2</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">68.24</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">Person 3</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">29.47</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">Person 4</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">0.00</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">Person 5</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;"></td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">Person 6</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;"></td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">Person 7</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;"></td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">Person 8</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;"></td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">Person 9</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;"></td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">Person 10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;"></td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;"></td><td style="border-bottom: 1px solid black;;">Person 1</td><td style="border-bottom: 1px solid black;;">Person 2</td><td style="border-bottom: 1px solid black;;">Person 3</td><td style="border-bottom: 1px solid black;;">Person 4</td><td style="border-bottom: 1px solid black;;">Person 5</td><td style="border-bottom: 1px solid black;;">Person 6</td><td style="border-bottom: 1px solid black;;">Person 7</td><td style="border-bottom: 1px solid black;;">Person 8</td><td style="border-bottom: 1px solid black;;">Person 9</td><td style="border-bottom: 1px solid black;;">Person 10</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="border-right: 1px solid black;;">Person 1 owes</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="border-right: 1px solid black;;">Person 2 owes</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="border-right: 1px solid black;;">Person 3 owes</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="border-right: 1px solid black;;">Person 4 owes</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="border-right: 1px solid black;;">Person 5 owes</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="border-right: 1px solid black;;">Person 6 owes</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="border-right: 1px solid black;;">Person 7 owes</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="border-right: 1px solid black;;">Person 8 owes</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="border-right: 1px solid black;;">Person 9 owes</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="border-right: 1px solid black;;">Person 10 owes</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr></tbody></table>Split Expenses

wigi · Jul 20, 2011

Hi

Why don't you organise it such that everyone pays to (or receives from) a bank (which could a new person for instance)? Then your grid becomes a column and the number of solutions decreases from infinity to 1...

lex_m · Jul 20, 2011

That may work, if I understand you right, if everybody gets together before hand and puts the money in a pile and one person goes out and buys everything, but what if they have all ready bought things and they just bring in the receipt for what they bought, what would be the best way to find out who owes who what amount to make everybody pay the same?

wigi · Jul 20, 2011

Just make individually the difference of their expense, and the average. Some will be +, some will be -, but the total will be 0

It does not tell you who pays who, but those who pay put the money on the table, after which those who need money, can take it from the pile.

lex_m · Jul 20, 2011

Thanks, that will work, was just wanting to get it to give me the amount of each person Probably hard to get that, I could even use something in a macro if that can be done

wigi · Jul 21, 2011

But there are an infinite number of solutions. Maybe you might end up with only 1 solution or a few, if you minimize or maximize certain criteria (like the "total money that is exchanged" or "the number of persons that are involved in the payments") and so on.

VBA or not, the same solutions will exist...

Greg Truby · Jul 21, 2011

<TABLE border=1 cellSpacing=0 borderColor=#c0c0c0 borderColorDark=#ffffff><TBODY><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=207>amount of bill</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=69 align=right>$850.00</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=207>number of people</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=69 align=right>10</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=207>amount per person</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=69 align=right>$ 85.00</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=207 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=207>Amount Spent By:</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=207>Person 1</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=69 align=right>225</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right>140</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=207>Person 2</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=69 align=right>25</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right>-60</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=207>Person 3</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=69 align=right>50</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right>-35</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=207>Person 4</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=69 align=right>75</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right>-10</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=207>Person 5</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=69 align=right>100</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right>15</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=207>Person 6</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=69 align=right>80</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right>-5</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=207>Person 7</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=69 align=right>100</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right>15</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=207>Person 8</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=69 align=right>75</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right>-10</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=207>Person 9</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=69 align=right>15</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right>-70</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=207>Person 10</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff99 height=26 vAlign=middle width=69 align=right>105</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right>20</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=207 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=207 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=69 align=right>140</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>-60</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>-35</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>-10</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>15</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>-5</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>15</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>-10</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>-70</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=69 align=right>20</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=207 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=69 align=right>225</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>25</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>50</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>75</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>100</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>80</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>100</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>75</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right>15</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=69 align=right>105</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=207 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=middle width=207 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=middle width=69>Person 1</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=middle width=63>Person 2</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=middle width=63>Person 3</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=middle width=63>Person 4</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=middle width=63>Person 5</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=middle width=63>Person 6</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=middle width=63>Person 7</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=middle width=63>Person 8</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=middle width=63>Person 9</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=middle width=69>Person 10</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=44 vAlign=middle width=85>Check Unders</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=207>Person 1 owes</TD><TD style="WHITE-SPACE: nowrap" bgColor=#000000 height=26 vAlign=middle width=69 align=center></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=85 align=center>-</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=207>Person 2 owes</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>60.00</TD><TD style="WHITE-SPACE: nowrap" bgColor=#000000 height=26 vAlign=middle width=63 align=center></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=85 align=center>TRUE</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=207>Person 3 owes</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>35.00</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#000000 height=26 vAlign=middle width=63 align=center></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=85 align=center>TRUE</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=207>Person 4 owes</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>10.00</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#000000 height=26 vAlign=middle width=63 align=center></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=85 align=center>TRUE</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=207>Person 5 owes</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#000000 height=26 vAlign=middle width=63 align=center></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=85 align=center>-</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=207>Person 6 owes</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>5.00</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#000000 height=26 vAlign=middle width=63 align=center></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=85 align=center>TRUE</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=207>Person 7 owes</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#000000 height=26 vAlign=middle width=63 align=center></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=85 align=center>-</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=207>Person 8 owes</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>10.00</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#000000 height=26 vAlign=middle width=63 align=center></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=85 align=center>TRUE</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=207>Person 9 owes</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>20.00</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>15.00</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>15.00</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#000000 height=26 vAlign=middle width=63 align=center></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>20.00</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=85 align=center>TRUE</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=207>Person 10 owes</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=69 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#000000 height=26 vAlign=middle width=69 align=center></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=26 vAlign=middle width=85 align=center>-</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=207 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=69 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=85 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=middle width=207>Check: overs repaid</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=69 align=center>TRUE</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=center>TRUE</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=center>TRUE</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=center>-</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=69 align=center>TRUE</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=25 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=85 align=right></TD></TR></TBODY></TABLE>

Greg Truby · Jul 21, 2011

<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0"><tr><td bgcolor="#FFFFFF" width="207" height="25" valign="middle" style="white-space: nowrap">amount of bill</td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="middle" style="white-space: nowrap">=SUM(B6:B15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFFFF" width="207" height="25" valign="middle" style="white-space: nowrap">number of people</td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="middle" style="white-space: nowrap">=COUNT(B6:B15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFFFF" width="207" height="25" valign="middle" style="white-space: nowrap">amount per person</td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="middle" style="white-space: nowrap">=AVERAGE(B6:B15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFFFF" width="207" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFFFF" width="207" height="26" valign="middle" style="white-space: nowrap">Amount Spent By:</td><td bgcolor="#FFFFFF" width="69" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="26" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFF99" width="207" height="26" valign="middle" style="white-space: nowrap">Person 1</td><td bgcolor="#FFFF99" width="69" height="26" align="right" valign="middle" style="white-space: nowrap">225</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap">=IF(LEN(B6),B6-avg.per.pers,"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="26" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFF99" width="207" height="26" valign="middle" style="white-space: nowrap">Person 2</td><td bgcolor="#FFFF99" width="69" height="26" align="right" valign="middle" style="white-space: nowrap">25</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap">=IF(LEN(B7),B7-avg.per.pers,"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="26" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFF99" width="207" height="26" valign="middle" style="white-space: nowrap">Person 3</td><td bgcolor="#FFFF99" width="69" height="26" align="right" valign="middle" style="white-space: nowrap">50</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap">=IF(LEN(B8),B8-avg.per.pers,"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="26" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFF99" width="207" height="26" valign="middle" style="white-space: nowrap">Person 4</td><td bgcolor="#FFFF99" width="69" height="26" align="right" valign="middle" style="white-space: nowrap">75</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap">=IF(LEN(B9),B9-avg.per.pers,"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="26" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFF99" width="207" height="26" valign="middle" style="white-space: nowrap">Person 5</td><td bgcolor="#FFFF99" width="69" height="26" align="right" valign="middle" style="white-space: nowrap">100</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap">=IF(LEN(B10),B10-avg.per.pers,"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="26" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFF99" width="207" height="26" valign="middle" style="white-space: nowrap">Person 6</td><td bgcolor="#FFFF99" width="69" height="26" align="right" valign="middle" style="white-space: nowrap">80</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap">=IF(LEN(B11),B11-avg.per.pers,"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="26" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFF99" width="207" height="26" valign="middle" style="white-space: nowrap">Person 7</td><td bgcolor="#FFFF99" width="69" height="26" align="right" valign="middle" style="white-space: nowrap">100</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap">=IF(LEN(B12),B12-avg.per.pers,"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="26" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFF99" width="207" height="26" valign="middle" style="white-space: nowrap">Person 8</td><td bgcolor="#FFFF99" width="69" height="26" align="right" valign="middle" style="white-space: nowrap">75</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap">=IF(LEN(B13),B13-avg.per.pers,"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="26" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFF99" width="207" height="26" valign="middle" style="white-space: nowrap">Person 9</td><td bgcolor="#FFFF99" width="69" height="26" align="right" valign="middle" style="white-space: nowrap">15</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap">=IF(LEN(B14),B14-avg.per.pers,"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="26" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFF99" width="207" height="26" valign="middle" style="white-space: nowrap">Person 10</td><td bgcolor="#FFFF99" width="69" height="26" align="right" valign="middle" style="white-space: nowrap">105</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap">=IF(LEN(B15),B15-avg.per.pers,"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="26" align="right" valign="middle" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFFFF" width="207" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="bottom" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFFFF" width="207" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="bottom" style="white-space: nowrap">=TRANSPOSE(C6:C15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(C6:C15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(C6:C15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(C6:C15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(C6:C15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(C6:C15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(C6:C15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(C6:C15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(C6:C15)</td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(C6:C15)</td></tr><tr><td bgcolor="#FFFFFF" width="207" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="bottom" style="white-space: nowrap">=TRANSPOSE(B6:B15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(B6:B15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(B6:B15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(B6:B15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(B6:B15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(B6:B15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(B6:B15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(B6:B15)</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(B6:B15)</td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="middle" style="white-space: nowrap">=TRANSPOSE(B6:B15)</td></tr></table>

Greg Truby · Jul 21, 2011

<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0"><tr><td bgcolor="#FFFFFF" width="207" height="44" align="right" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="44" valign="middle" style="white-space: nowrap">Person 1</td><td bgcolor="#FFFFFF" width="63" height="44" valign="middle" style="white-space: nowrap">Person 2</td><td bgcolor="#FFFFFF" width="63" height="44" valign="middle" style="white-space: nowrap">Person 3</td><td bgcolor="#FFFFFF" width="63" height="44" valign="middle" style="white-space: nowrap">Person 4</td><td bgcolor="#FFFFFF" width="63" height="44" valign="middle" style="white-space: nowrap">Person 5</td><td bgcolor="#FFFFFF" width="63" height="44" valign="middle" style="white-space: nowrap">Person 6</td><td bgcolor="#FFFFFF" width="63" height="44" valign="middle" style="white-space: nowrap">Person 7</td><td bgcolor="#FFFFFF" width="63" height="44" valign="middle" style="white-space: nowrap">Person 8</td><td bgcolor="#FFFFFF" width="63" height="44" valign="middle" style="white-space: nowrap">Person 9</td><td bgcolor="#FFFFFF" width="69" height="44" valign="middle" style="white-space: nowrap">Person 10</td><td bgcolor="#FFFFFF" width="25" height="44" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="44" valign="middle" style="white-space: nowrap">Check Unders</td></tr><tr><td bgcolor="#FFFFFF" width="207" height="26" valign="middle" style="white-space: nowrap">Person 1 owes</td><td bgcolor="#000000" width="69" height="26" align="center" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(ISNUMBER(C17),($B6<avg.per.pers)*(C$18>avg.per.pers)*MAX(0,MIN(-$C6-SUM($B21:B21),C$17)),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(ISNUMBER(D17),($B6<avg.per.pers)*(D$18>avg.per.pers)*MAX(0,MIN(-$C6-SUM($B21:C21),D$17)),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(ISNUMBER(E17),($B6<avg.per.pers)*(E$18>avg.per.pers)*MAX(0,MIN(-$C6-SUM($B21:D21),E$17)),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(ISNUMBER(F17),($B6<avg.per.pers)*(F$18>avg.per.pers)*MAX(0,MIN(-$C6-SUM($B21:E21),F$17)),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(ISNUMBER(G17),($B6<avg.per.pers)*(G$18>avg.per.pers)*MAX(0,MIN(-$C6-SUM($B21:F21),G$17)),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(ISNUMBER(H17),($B6<avg.per.pers)*(H$18>avg.per.pers)*MAX(0,MIN(-$C6-SUM($B21:G21),H$17)),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(ISNUMBER(I17),($B6<avg.per.pers)*(I$18>avg.per.pers)*MAX(0,MIN(-$C6-SUM($B21:H21),I$17)),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(ISNUMBER(J17),($B6<avg.per.pers)*(J$18>avg.per.pers)*MAX(0,MIN(-$C6-SUM($B21:I21),J$17)),"")</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(ISNUMBER(K17),($B6<avg.per.pers)*(K$18>avg.per.pers)*MAX(0,MIN(-$C6-SUM($B21:J21),K$17)),"")</td><td bgcolor="#FFFFFF" width="25" height="26" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(C6<0,SUM(B21:K21)+C6=0,"-")</td></tr><tr><td bgcolor="#FFFFFF" width="207" height="26" valign="middle" style="white-space: nowrap">Person 2 owes</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B7<avg.per.pers)*(B$18>avg.per.pers)*MAX(0,MIN(-$C7,B$17-SUM(B$21:B21))),"")</td><td bgcolor="#000000" width="63" height="26" align="center" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B7<avg.per.pers)*(D$18>avg.per.pers)*MAX(0,MIN(-$C7-SUM($B22:C22),D$17-SUM(D$21:D21))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B7<avg.per.pers)*(E$18>avg.per.pers)*MAX(0,MIN(-$C7-SUM($B22:D22),E$17-SUM(E$21:E21))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B7<avg.per.pers)*(F$18>avg.per.pers)*MAX(0,MIN(-$C7-SUM($B22:E22),F$17-SUM(F$21:F21))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B7<avg.per.pers)*(G$18>avg.per.pers)*MAX(0,MIN(-$C7-SUM($B22:F22),G$17-SUM(G$21:G21))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B7<avg.per.pers)*(H$18>avg.per.pers)*MAX(0,MIN(-$C7-SUM($B22:G22),H$17-SUM(H$21:H21))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B7<avg.per.pers)*(I$18>avg.per.pers)*MAX(0,MIN(-$C7-SUM($B22:H22),I$17-SUM(I$21:I21))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B7<avg.per.pers)*(J$18>avg.per.pers)*MAX(0,MIN(-$C7-SUM($B22:I22),J$17-SUM(J$21:J21))),"")</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B7<avg.per.pers)*(K$18>avg.per.pers)*MAX(0,MIN(-$C7-SUM($B22:J22),K$17-SUM(K$21:K21))),"")</td><td bgcolor="#FFFFFF" width="25" height="26" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(C7<0,SUM(B22:K22)+C7=0,"-")</td></tr><tr><td bgcolor="#FFFFFF" width="207" height="26" valign="middle" style="white-space: nowrap">Person 3 owes</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B8<avg.per.pers)*(B$18>avg.per.pers)*MAX(0,MIN(-$C8,B$17-SUM(B$21:B22))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B8<avg.per.pers)*(C$18>avg.per.pers)*MAX(0,MIN(-$C8-SUM($B23:B23),C$17-SUM(C$21:C22))),"")</td><td bgcolor="#000000" width="63" height="26" align="center" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B8<avg.per.pers)*(E$18>avg.per.pers)*MAX(0,MIN(-$C8-SUM($B23:D23),E$17-SUM(E$21:E22))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B8<avg.per.pers)*(F$18>avg.per.pers)*MAX(0,MIN(-$C8-SUM($B23:E23),F$17-SUM(F$21:F22))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B8<avg.per.pers)*(G$18>avg.per.pers)*MAX(0,MIN(-$C8-SUM($B23:F23),G$17-SUM(G$21:G22))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B8<avg.per.pers)*(H$18>avg.per.pers)*MAX(0,MIN(-$C8-SUM($B23:G23),H$17-SUM(H$21:H22))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B8<avg.per.pers)*(I$18>avg.per.pers)*MAX(0,MIN(-$C8-SUM($B23:H23),I$17-SUM(I$21:I22))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B8<avg.per.pers)*(J$18>avg.per.pers)*MAX(0,MIN(-$C8-SUM($B23:I23),J$17-SUM(J$21:J22))),"")</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B8<avg.per.pers)*(K$18>avg.per.pers)*MAX(0,MIN(-$C8-SUM($B23:J23),K$17-SUM(K$21:K22))),"")</td><td bgcolor="#FFFFFF" width="25" height="26" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(C8<0,SUM(B23:K23)+C8=0,"-")</td></tr><tr><td bgcolor="#FFFFFF" width="207" height="26" valign="middle" style="white-space: nowrap">Person 4 owes</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B9<avg.per.pers)*(B$18>avg.per.pers)*MAX(0,MIN(-$C9,B$17-SUM(B$21:B23))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B9<avg.per.pers)*(C$18>avg.per.pers)*MAX(0,MIN(-$C9-SUM($B24:B24),C$17-SUM(C$21:C23))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B9<avg.per.pers)*(D$18>avg.per.pers)*MAX(0,MIN(-$C9-SUM($B24:C24),D$17-SUM(D$21:D23))),"")</td><td bgcolor="#000000" width="63" height="26" align="center" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B9<avg.per.pers)*(F$18>avg.per.pers)*MAX(0,MIN(-$C9-SUM($B24:E24),F$17-SUM(F$21:F23))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B9<avg.per.pers)*(G$18>avg.per.pers)*MAX(0,MIN(-$C9-SUM($B24:F24),G$17-SUM(G$21:G23))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B9<avg.per.pers)*(H$18>avg.per.pers)*MAX(0,MIN(-$C9-SUM($B24:G24),H$17-SUM(H$21:H23))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B9<avg.per.pers)*(I$18>avg.per.pers)*MAX(0,MIN(-$C9-SUM($B24:H24),I$17-SUM(I$21:I23))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B9<avg.per.pers)*(J$18>avg.per.pers)*MAX(0,MIN(-$C9-SUM($B24:I24),J$17-SUM(J$21:J23))),"")</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B9<avg.per.pers)*(K$18>avg.per.pers)*MAX(0,MIN(-$C9-SUM($B24:J24),K$17-SUM(K$21:K23))),"")</td><td bgcolor="#FFFFFF" width="25" height="26" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(C9<0,SUM(B24:K24)+C9=0,"-")</td></tr><tr><td bgcolor="#FFFFFF" width="207" height="26" valign="middle" style="white-space: nowrap">Person 5 owes</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B10<avg.per.pers)*(B$18>avg.per.pers)*MAX(0,MIN(-$C10,B$17-SUM(B$21:B24))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B10<avg.per.pers)*(C$18>avg.per.pers)*MAX(0,MIN(-$C10-SUM($B25:B25),C$17-SUM(C$21:C24))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B10<avg.per.pers)*(D$18>avg.per.pers)*MAX(0,MIN(-$C10-SUM($B25:C25),D$17-SUM(D$21:D24))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B10<avg.per.pers)*(E$18>avg.per.pers)*MAX(0,MIN(-$C10-SUM($B25:D25),E$17-SUM(E$21:E24))),"")</td><td bgcolor="#000000" width="63" height="26" align="center" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B10<avg.per.pers)*(G$18>avg.per.pers)*MAX(0,MIN(-$C10-SUM($B25:F25),G$17-SUM(G$21:G24))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B10<avg.per.pers)*(H$18>avg.per.pers)*MAX(0,MIN(-$C10-SUM($B25:G25),H$17-SUM(H$21:H24))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B10<avg.per.pers)*(I$18>avg.per.pers)*MAX(0,MIN(-$C10-SUM($B25:H25),I$17-SUM(I$21:I24))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B10<avg.per.pers)*(J$18>avg.per.pers)*MAX(0,MIN(-$C10-SUM($B25:I25),J$17-SUM(J$21:J24))),"")</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B10<avg.per.pers)*(K$18>avg.per.pers)*MAX(0,MIN(-$C10-SUM($B25:J25),K$17-SUM(K$21:K24))),"")</td><td bgcolor="#FFFFFF" width="25" height="26" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(C10<0,SUM(B25:K25)+C10=0,"-")</td></tr><tr><td bgcolor="#FFFFFF" width="207" height="26" valign="middle" style="white-space: nowrap">Person 6 owes</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B11<avg.per.pers)*(B$18>avg.per.pers)*MAX(0,MIN(-$C11,B$17-SUM(B$21:B25))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B11<avg.per.pers)*(C$18>avg.per.pers)*MAX(0,MIN(-$C11-SUM($B26:B26),C$17-SUM(C$21:C25))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B11<avg.per.pers)*(D$18>avg.per.pers)*MAX(0,MIN(-$C11-SUM($B26:C26),D$17-SUM(D$21:D25))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B11<avg.per.pers)*(E$18>avg.per.pers)*MAX(0,MIN(-$C11-SUM($B26:D26),E$17-SUM(E$21:E25))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B11<avg.per.pers)*(F$18>avg.per.pers)*MAX(0,MIN(-$C11-SUM($B26:E26),F$17-SUM(F$21:F25))),"")</td><td bgcolor="#000000" width="63" height="26" align="center" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B11<avg.per.pers)*(H$18>avg.per.pers)*MAX(0,MIN(-$C11-SUM($B26:G26),H$17-SUM(H$21:H25))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B11<avg.per.pers)*(I$18>avg.per.pers)*MAX(0,MIN(-$C11-SUM($B26:H26),I$17-SUM(I$21:I25))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B11<avg.per.pers)*(J$18>avg.per.pers)*MAX(0,MIN(-$C11-SUM($B26:I26),J$17-SUM(J$21:J25))),"")</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B11<avg.per.pers)*(K$18>avg.per.pers)*MAX(0,MIN(-$C11-SUM($B26:J26),K$17-SUM(K$21:K25))),"")</td><td bgcolor="#FFFFFF" width="25" height="26" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(C11<0,SUM(B26:K26)+C11=0,"-")</td></tr><tr><td bgcolor="#FFFFFF" width="207" height="26" valign="middle" style="white-space: nowrap">Person 7 owes</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B12<avg.per.pers)*(B$18>avg.per.pers)*MAX(0,MIN(-$C12,B$17-SUM(B$21:B26))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B12<avg.per.pers)*(C$18>avg.per.pers)*MAX(0,MIN(-$C12-SUM($B27:B27),C$17-SUM(C$21:C26))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B12<avg.per.pers)*(D$18>avg.per.pers)*MAX(0,MIN(-$C12-SUM($B27:C27),D$17-SUM(D$21:D26))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B12<avg.per.pers)*(E$18>avg.per.pers)*MAX(0,MIN(-$C12-SUM($B27:D27),E$17-SUM(E$21:E26))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B12<avg.per.pers)*(F$18>avg.per.pers)*MAX(0,MIN(-$C12-SUM($B27:E27),F$17-SUM(F$21:F26))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B12<avg.per.pers)*(G$18>avg.per.pers)*MAX(0,MIN(-$C12-SUM($B27:F27),G$17-SUM(G$21:G26))),"")</td><td bgcolor="#000000" width="63" height="26" align="center" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B12<avg.per.pers)*(I$18>avg.per.pers)*MAX(0,MIN(-$C12-SUM($B27:H27),I$17-SUM(I$21:I26))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B12<avg.per.pers)*(J$18>avg.per.pers)*MAX(0,MIN(-$C12-SUM($B27:I27),J$17-SUM(J$21:J26))),"")</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B12<avg.per.pers)*(K$18>avg.per.pers)*MAX(0,MIN(-$C12-SUM($B27:J27),K$17-SUM(K$21:K26))),"")</td><td bgcolor="#FFFFFF" width="25" height="26" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(C12<0,SUM(B27:K27)+C12=0,"-")</td></tr><tr><td bgcolor="#FFFFFF" width="207" height="26" valign="middle" style="white-space: nowrap">Person 8 owes</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B13<avg.per.pers)*(B$18>avg.per.pers)*MAX(0,MIN(-$C13,B$17-SUM(B$21:B27))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B13<avg.per.pers)*(C$18>avg.per.pers)*MAX(0,MIN(-$C13-SUM($B28:B28),C$17-SUM(C$21:C27))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B13<avg.per.pers)*(D$18>avg.per.pers)*MAX(0,MIN(-$C13-SUM($B28:C28),D$17-SUM(D$21:D27))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B13<avg.per.pers)*(E$18>avg.per.pers)*MAX(0,MIN(-$C13-SUM($B28:D28),E$17-SUM(E$21:E27))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B13<avg.per.pers)*(F$18>avg.per.pers)*MAX(0,MIN(-$C13-SUM($B28:E28),F$17-SUM(F$21:F27))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B13<avg.per.pers)*(G$18>avg.per.pers)*MAX(0,MIN(-$C13-SUM($B28:F28),G$17-SUM(G$21:G27))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B13<avg.per.pers)*(H$18>avg.per.pers)*MAX(0,MIN(-$C13-SUM($B28:G28),H$17-SUM(H$21:H27))),"")</td><td bgcolor="#000000" width="63" height="26" align="center" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B13<avg.per.pers)*(J$18>avg.per.pers)*MAX(0,MIN(-$C13-SUM($B28:I28),J$17-SUM(J$21:J27))),"")</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B13<avg.per.pers)*(K$18>avg.per.pers)*MAX(0,MIN(-$C13-SUM($B28:J28),K$17-SUM(K$21:K27))),"")</td><td bgcolor="#FFFFFF" width="25" height="26" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(C13<0,SUM(B28:K28)+C13=0,"-")</td></tr><tr><td bgcolor="#FFFFFF" width="207" height="26" valign="middle" style="white-space: nowrap">Person 9 owes</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B14<avg.per.pers)*(B$18>avg.per.pers)*MAX(0,MIN(-$C14,B$17-SUM(B$21:B28))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B14<avg.per.pers)*(C$18>avg.per.pers)*MAX(0,MIN(-$C14-SUM($B29:B29),C$17-SUM(C$21:C28))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B14<avg.per.pers)*(D$18>avg.per.pers)*MAX(0,MIN(-$C14-SUM($B29:C29),D$17-SUM(D$21:D28))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B14<avg.per.pers)*(E$18>avg.per.pers)*MAX(0,MIN(-$C14-SUM($B29:D29),E$17-SUM(E$21:E28))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B14<avg.per.pers)*(F$18>avg.per.pers)*MAX(0,MIN(-$C14-SUM($B29:E29),F$17-SUM(F$21:F28))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B14<avg.per.pers)*(G$18>avg.per.pers)*MAX(0,MIN(-$C14-SUM($B29:F29),G$17-SUM(G$21:G28))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B14<avg.per.pers)*(H$18>avg.per.pers)*MAX(0,MIN(-$C14-SUM($B29:G29),H$17-SUM(H$21:H28))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B14<avg.per.pers)*(I$18>avg.per.pers)*MAX(0,MIN(-$C14-SUM($B29:H29),I$17-SUM(I$21:I28))),"")</td><td bgcolor="#000000" width="63" height="26" align="center" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B14<avg.per.pers)*(K$18>avg.per.pers)*MAX(0,MIN(-$C14-SUM($B29:J29),K$17-SUM(K$21:K28))),"")</td><td bgcolor="#FFFFFF" width="25" height="26" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(C14<0,SUM(B29:K29)+C14=0,"-")</td></tr><tr><td bgcolor="#FFFFFF" width="207" height="26" valign="middle" style="white-space: nowrap">Person 10 owes</td><td bgcolor="#FFFFFF" width="69" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B15<avg.per.pers)*(B$18>avg.per.pers)*MAX(0,MIN(-$C15,B$17-SUM(B$21:B29))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B15<avg.per.pers)*(C$18>avg.per.pers)*MAX(0,MIN(-$C15-SUM($B30:B30),C$17-SUM(C$21:C29))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B15<avg.per.pers)*(D$18>avg.per.pers)*MAX(0,MIN(-$C15-SUM($B30:C30),D$17-SUM(D$21:D29))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B15<avg.per.pers)*(E$18>avg.per.pers)*MAX(0,MIN(-$C15-SUM($B30:D30),E$17-SUM(E$21:E29))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B15<avg.per.pers)*(F$18>avg.per.pers)*MAX(0,MIN(-$C15-SUM($B30:E30),F$17-SUM(F$21:F29))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B15<avg.per.pers)*(G$18>avg.per.pers)*MAX(0,MIN(-$C15-SUM($B30:F30),G$17-SUM(G$21:G29))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B15<avg.per.pers)*(H$18>avg.per.pers)*MAX(0,MIN(-$C15-SUM($B30:G30),H$17-SUM(H$21:H29))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B15<avg.per.pers)*(I$18>avg.per.pers)*MAX(0,MIN(-$C15-SUM($B30:H30),I$17-SUM(I$21:I29))),"")</td><td bgcolor="#FFFFFF" width="63" height="26" align="center" valign="middle" style="white-space: nowrap">=IFERROR(($B15<avg.per.pers)*(J$18>avg.per.pers)*MAX(0,MIN(-$C15-SUM($B30:I30),J$17-SUM(J$21:J29))),"")</td><td bgcolor="#000000" width="69" height="26" align="center" valign="middle" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="25" height="26" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="26" align="center" valign="middle" style="white-space: nowrap">=IF(C15<0,SUM(B30:K30)+C15=0,"-")</td></tr><tr><td bgcolor="#FFFFFF" width="207" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="69" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="25" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="25" align="right" valign="bottom" style="white-space: nowrap"></td></tr><tr><td bgcolor="#FFFFFF" width="207" height="25" valign="middle" style="white-space: nowrap">Check: overs repaid</td><td bgcolor="#FFFFFF" width="69" height="25" align="center" valign="bottom" style="white-space: nowrap">=IF(AND(B17>0,ISNUMBER(B17)),SUM(B21:B30)=B17,"-")</td><td bgcolor="#FFFFFF" width="63" height="25" align="center" valign="bottom" style="white-space: nowrap">=IF(AND(C17>0,ISNUMBER(C17)),SUM(C21:C30)=C17,"-")</td><td bgcolor="#FFFFFF" width="63" height="25" align="center" valign="bottom" style="white-space: nowrap">=IF(AND(D17>0,ISNUMBER(D17)),SUM(D21:D30)=D17,"-")</td><td bgcolor="#FFFFFF" width="63" height="25" align="center" valign="bottom" style="white-space: nowrap">=IF(AND(E17>0,ISNUMBER(E17)),SUM(E21:E30)=E17,"-")</td><td bgcolor="#FFFFFF" width="63" height="25" align="center" valign="bottom" style="white-space: nowrap">=IF(AND(F17>0,ISNUMBER(F17)),SUM(F21:F30)=F17,"-")</td><td bgcolor="#FFFFFF" width="63" height="25" align="center" valign="bottom" style="white-space: nowrap">=IF(AND(G17>0,ISNUMBER(G17)),SUM(G21:G30)=G17,"-")</td><td bgcolor="#FFFFFF" width="63" height="25" align="center" valign="bottom" style="white-space: nowrap">=IF(AND(H17>0,ISNUMBER(H17)),SUM(H21:H30)=H17,"-")</td><td bgcolor="#FFFFFF" width="63" height="25" align="center" valign="bottom" style="white-space: nowrap">=IF(AND(I17>0,ISNUMBER(I17)),SUM(I21:I30)=I17,"-")</td><td bgcolor="#FFFFFF" width="63" height="25" align="center" valign="bottom" style="white-space: nowrap">=IF(AND(J17>0,ISNUMBER(J17)),SUM(J21:J30)=J17,"-")</td><td bgcolor="#FFFFFF" width="69" height="25" align="center" valign="bottom" style="white-space: nowrap">=IF(AND(K17>0,ISNUMBER(K17)),SUM(K21:K30)=K17,"-")</td><td bgcolor="#FFFFFF" width="25" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="85" height="25" align="right" valign="bottom" style="white-space: nowrap"></td></tr></table>