Formula Help (Assumes Cell Formatting)

Joneye

Well-known Member
Joined
May 28, 2010
Messages
749
Office Version
  1. 2016
Platform
  1. MacOS
Hi Good people,

The problem cell is E:79, currently reporting #value, if i manually enter "0" in cell D:76 then cell E:79 updates ok.

What i need to understand is this a sum or formatting error? and what steps / advice would you offer to fix it?

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;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><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Filename :</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><td style="text-align: right;;"></td><td style=";"> </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=";">Date Now :</td><td style="text-align: right;;">24-Jul-16</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><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="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><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=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";">-</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="text-align: center;;">Week Comm</td><td style=";">     Rent</td><td style="text-align: center;;">Arrears</td><td style="text-align: center;;">Overpaid</td><td style="text-align: center;;">Received</td><td style=";">     Comments</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;">6</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";">-</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="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><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="text-align: right;;">11-Apr-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£0.00</td><td style="text-align: right;;">£0.00</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;;">£120.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">18-Apr-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£120.00</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£240.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">25-Apr-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£240.00</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£360.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">02-May-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£360.00</td><td style=";"> </td><td style="text-align: right;;">£480.00</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;;">£480.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">09-May-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£480.00</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£600.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">16-May-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£600.00</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£720.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">23-May-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£720.00</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£840.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">30-May-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£840.00</td><td style=";"> </td><td style="text-align: right;;">£480.00</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;;">£960.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">06-Jun-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£960.00</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£1,080.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">13-Jun-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£1,080.00</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£1,200.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">20-Jun-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£1,200.00</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£1,320.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">27-Jun-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£1,320.00</td><td style=";"> </td><td style="text-align: right;;">£480.00</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;;">£1,440.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">04-Jul-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£1,440.00</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£1,560.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">11-Jul-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£1,560.00</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£1,680.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">18-Jul-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£1,680.00</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£1,800.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">25-Jul-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£1,800.00</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£1,920.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">01-Aug-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£2,040.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">08-Aug-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£2,160.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;">15-Aug-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£2,280.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;">22-Aug-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£2,400.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;;">29-Aug-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£2,520.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: right;;">05-Sep-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£2,640.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;;">12-Sep-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£2,760.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: right;;">19-Sep-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£2,880.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: right;;">26-Sep-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£3,000.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style="text-align: right;;">03-Oct-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£3,120.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">34</td><td style="text-align: right;;">10-Oct-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£3,240.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">35</td><td style="text-align: right;;">17-Oct-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£3,360.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">36</td><td style="text-align: right;;">24-Oct-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£3,480.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">37</td><td style="text-align: right;;">31-Oct-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£3,600.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">38</td><td style="text-align: right;;">07-Nov-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£3,720.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">39</td><td style="text-align: right;;">14-Nov-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£3,840.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">40</td><td style="text-align: right;;">21-Nov-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£3,960.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">41</td><td style="text-align: right;;">28-Nov-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£4,080.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">42</td><td style="text-align: right;;">05-Dec-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£4,200.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">43</td><td style="text-align: right;;">12-Dec-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£4,320.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">44</td><td style="text-align: right;;">19-Dec-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£4,440.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">45</td><td style="text-align: right;;">26-Dec-16</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£4,560.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">46</td><td style="text-align: right;;">02-Jan-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£4,680.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">47</td><td style="text-align: right;;">09-Jan-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£4,800.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">48</td><td style="text-align: right;;">16-Jan-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£4,920.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">49</td><td style="text-align: right;;">23-Jan-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£5,040.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">50</td><td style="text-align: right;;">30-Jan-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£5,160.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">51</td><td style="text-align: right;;">06-Feb-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£5,280.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">52</td><td style="text-align: right;;">13-Feb-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£5,400.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">53</td><td style="text-align: right;;">20-Feb-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£5,520.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">54</td><td style="text-align: right;;">27-Feb-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£5,640.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">55</td><td style="text-align: right;;">06-Mar-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£5,760.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">56</td><td style="text-align: right;;">13-Mar-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£5,880.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">57</td><td style="text-align: right;;">20-Mar-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£6,000.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">58</td><td style="text-align: right;;">27-Mar-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£6,120.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">59</td><td style="text-align: right;;">03-Apr-17</td><td style="text-align: right;;">£120.00</td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£6,240.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">60</td><td style="text-align: right;;">10-Apr-17</td><td style="text-align: right;;"></td><td style=";"> </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><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">£6,240.00</td><td style="text-align: right;;">£0.00</td></tr><tr ><td style="color: #161120;text-align: center;">61</td><td style=";">=</td><td style="text-align: right;;"></td><td style=";">=</td><td style=";">=</td><td style=";">=</td><td style=";">=</td><td style=";">=</td><td style=";">=</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";">=</td><td style=";">=</td><td style=";">=</td></tr><tr ><td style="color: #161120;text-align: center;">62</td><td style="text-align: right;;">24-Jul-16</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><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;">63</td><td style="text-align: right;;">£0.00</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><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;">64</td><td style=";">=</td><td style=";">=</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><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;">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><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;">66</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><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;">67</td><td style="text-align: center;;">Week Comm</td><td style=";">     Rent</td><td style="text-align: center;;">Arrears</td><td style="text-align: center;;">Overpaid</td><td style="text-align: center;;">Received</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;">68</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</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><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">69</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><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;">70</td><td style="text-align: right;;">27-Jun-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£1,320.00</td><td style=";"> </td><td style="text-align: right;;">£480.00</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;">71</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><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;">72</td><td style="text-align: right;;">04-Jul-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£1,440.00</td><td style=";"> </td><td style="text-align: right;;">£0.00</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;">73</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><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;">74</td><td style="text-align: right;;">11-Jul-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£1,560.00</td><td style=";"> </td><td style="text-align: right;;">£0.00</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;">75</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><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;">76</td><td style="text-align: right;;">18-Jul-16</td><td style="text-align: right;;">£120.00</td><td style="text-align: right;;">£1,680.00</td><td style=";"> </td><td style="text-align: right;;">£0.00</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;">77</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><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;">78</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</td><td style=";">-</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><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">79</td><td style=";">Carried forward to next statement and now due</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">#VALUE!</td><td style="text-align: right;;">#VALUE!</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;">80</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=";">=</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></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B2</th><td style="text-align:left">=NOW(<font color="Blue"></font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B3</th><td style="text-align:left">=B2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D8</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O7-P8</font>)>1," ",(<font color="Red">O7-P8</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O8</th><td style="text-align:left">=B8+C8</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P8</th><td style="text-align:left">=Q7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O9</th><td style="text-align:left">=B9+O8</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P9</th><td style="text-align:left">=Q8</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O10</th><td style="text-align:left">=B10+O9</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P10</th><td style="text-align:left">=Q9</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O11</th><td style="text-align:left">=B11+O10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P11</th><td style="text-align:left">=Q10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O12</th><td style="text-align:left">=B12+O11</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P12</th><td style="text-align:left">=Q11</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O13</th><td style="text-align:left">=B13+O12</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P13</th><td style="text-align:left">=Q12</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O14</th><td style="text-align:left">=B14+O13</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P14</th><td style="text-align:left">=Q13</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O15</th><td style="text-align:left">=B15+O14</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P15</th><td style="text-align:left">=Q14</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O16</th><td style="text-align:left">=B16+O15</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P16</th><td style="text-align:left">=Q15</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O17</th><td style="text-align:left">=B17+O16</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P17</th><td style="text-align:left">=Q16</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O18</th><td style="text-align:left">=B18+O17</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P18</th><td style="text-align:left">=Q17</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O19</th><td style="text-align:left">=B19+O18</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P19</th><td style="text-align:left">=Q18</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O20</th><td style="text-align:left">=B20+O19</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P20</th><td style="text-align:left">=Q19</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O21</th><td style="text-align:left">=B21+O20</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P21</th><td style="text-align:left">=Q20</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O22</th><td style="text-align:left">=B22+O21</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P22</th><td style="text-align:left">=Q21</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O23</th><td style="text-align:left">=B23+O22</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P23</th><td style="text-align:left">=Q22</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O24</th><td style="text-align:left">=B24+O23</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P24</th><td style="text-align:left">=Q23</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O25</th><td style="text-align:left">=B25+O24</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P25</th><td style="text-align:left">=Q24</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O26</th><td style="text-align:left">=B26+O25</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P26</th><td style="text-align:left">=Q25</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O27</th><td style="text-align:left">=B27+O26</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P27</th><td style="text-align:left">=Q26</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O28</th><td style="text-align:left">=B28+O27</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P28</th><td style="text-align:left">=Q27</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O29</th><td style="text-align:left">=B29+O28</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P29</th><td style="text-align:left">=Q28</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O30</th><td style="text-align:left">=B30+O29</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P30</th><td style="text-align:left">=Q29</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O31</th><td style="text-align:left">=B31+O30</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P31</th><td style="text-align:left">=Q30</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O32</th><td style="text-align:left">=B32+O31</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P32</th><td style="text-align:left">=Q31</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O33</th><td style="text-align:left">=B33+O32</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P33</th><td style="text-align:left">=Q32</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O34</th><td style="text-align:left">=B34+O33</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P34</th><td style="text-align:left">=Q33</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O35</th><td style="text-align:left">=B35+O34</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P35</th><td style="text-align:left">=Q34</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O36</th><td style="text-align:left">=B36+O35</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P36</th><td style="text-align:left">=Q35</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O37</th><td style="text-align:left">=B37+O36</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P37</th><td style="text-align:left">=Q36</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O38</th><td style="text-align:left">=B38+O37</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P38</th><td style="text-align:left">=Q37</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O39</th><td style="text-align:left">=B39+O38</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P39</th><td style="text-align:left">=Q38</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O40</th><td style="text-align:left">=B40+O39</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P40</th><td style="text-align:left">=Q39</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O41</th><td style="text-align:left">=B41+O40</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P41</th><td style="text-align:left">=Q40</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O42</th><td style="text-align:left">=B42+O41</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P42</th><td style="text-align:left">=Q41</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O43</th><td style="text-align:left">=B43+O42</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P43</th><td style="text-align:left">=Q42</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O44</th><td style="text-align:left">=B44+O43</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P44</th><td style="text-align:left">=Q43</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O45</th><td style="text-align:left">=B45+O44</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P45</th><td style="text-align:left">=Q44</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O46</th><td style="text-align:left">=B46+O45</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P46</th><td style="text-align:left">=Q45</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O47</th><td style="text-align:left">=B47+O46</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P47</th><td style="text-align:left">=Q46</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O48</th><td style="text-align:left">=B48+O47</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P48</th><td style="text-align:left">=Q47</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O49</th><td style="text-align:left">=B49+O48</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P49</th><td style="text-align:left">=Q48</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O50</th><td style="text-align:left">=B50+O49</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P50</th><td style="text-align:left">=Q49</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O51</th><td style="text-align:left">=B51+O50</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P51</th><td style="text-align:left">=Q50</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O52</th><td style="text-align:left">=B52+O51</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P52</th><td style="text-align:left">=Q51</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O53</th><td style="text-align:left">=B53+O52</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P53</th><td style="text-align:left">=Q52</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O54</th><td style="text-align:left">=B54+O53</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P54</th><td style="text-align:left">=Q53</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O55</th><td style="text-align:left">=B55+O54</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P55</th><td style="text-align:left">=Q54</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O56</th><td style="text-align:left">=B56+O55</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P56</th><td style="text-align:left">=Q55</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O57</th><td style="text-align:left">=B57+O56</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P57</th><td style="text-align:left">=Q56</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O58</th><td style="text-align:left">=B58+O57</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P58</th><td style="text-align:left">=Q57</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O59</th><td style="text-align:left">=B59+O58</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P59</th><td style="text-align:left">=Q58</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O60</th><td style="text-align:left">=B60+O59</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">P60</th><td style="text-align:left">=Q59</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C9</th><td style="text-align:left">=IF(<font color="Blue">D9=" ",IF(<font color="Red">A9-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O9-P9</font>)<1," ",O9-P9-B9</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D9</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O8-P9</font>)>1," ",(<font color="Red">O8-P9</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C10</th><td style="text-align:left">=IF(<font color="Blue">D10=" ",IF(<font color="Red">A10-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O10-P10</font>)<1," ",O10-P10-B10</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D10</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O9-P10</font>)>1," ",(<font color="Red">O9-P10</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C11</th><td style="text-align:left">=IF(<font color="Blue">D11=" ",IF(<font color="Red">A11-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O11-P11</font>)<1," ",O11-P11-B11</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D11</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O10-P11</font>)>1," ",(<font color="Red">O10-P11</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C12</th><td style="text-align:left">=IF(<font color="Blue">D12=" ",IF(<font color="Red">A12-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O12-P12</font>)<1," ",O12-P12-B12</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D12</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O11-P12</font>)>1," ",(<font color="Red">O11-P12</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C13</th><td style="text-align:left">=IF(<font color="Blue">D13=" ",IF(<font color="Red">A13-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O13-P13</font>)<1," ",O13-P13-B13</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D13</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O12-P13</font>)>1," ",(<font color="Red">O12-P13</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C14</th><td style="text-align:left">=IF(<font color="Blue">D14=" ",IF(<font color="Red">A14-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O14-P14</font>)<1," ",O14-P14-B14</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D14</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O13-P14</font>)>1," ",(<font color="Red">O13-P14</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C15</th><td style="text-align:left">=IF(<font color="Blue">D15=" ",IF(<font color="Red">A15-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O15-P15</font>)<1," ",O15-P15-B15</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D15</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O14-P15</font>)>1," ",(<font color="Red">O14-P15</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C16</th><td style="text-align:left">=IF(<font color="Blue">D16=" ",IF(<font color="Red">A16-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O16-P16</font>)<1," ",O16-P16-B16</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D16</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O15-P16</font>)>1," ",(<font color="Red">O15-P16</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C17</th><td style="text-align:left">=IF(<font color="Blue">D17=" ",IF(<font color="Red">A17-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O17-P17</font>)<1," ",O17-P17-B17</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D17</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O16-P17</font>)>1," ",(<font color="Red">O16-P17</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C18</th><td style="text-align:left">=IF(<font color="Blue">D18=" ",IF(<font color="Red">A18-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O18-P18</font>)<1," ",O18-P18-B18</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D18</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O17-P18</font>)>1," ",(<font color="Red">O17-P18</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C19</th><td style="text-align:left">=IF(<font color="Blue">D19=" ",IF(<font color="Red">A19-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O19-P19</font>)<1," ",O19-P19-B19</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D19</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O18-P19</font>)>1," ",(<font color="Red">O18-P19</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C20</th><td style="text-align:left">=IF(<font color="Blue">D20=" ",IF(<font color="Red">A20-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O20-P20</font>)<1," ",O20-P20-B20</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D20</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O19-P20</font>)>1," ",(<font color="Red">O19-P20</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C21</th><td style="text-align:left">=IF(<font color="Blue">D21=" ",IF(<font color="Red">A21-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O21-P21</font>)<1," ",O21-P21-B21</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D21</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O20-P21</font>)>1," ",(<font color="Red">O20-P21</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C22</th><td style="text-align:left">=IF(<font color="Blue">D22=" ",IF(<font color="Red">A22-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O22-P22</font>)<1," ",O22-P22-B22</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D22</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O21-P22</font>)>1," ",(<font color="Red">O21-P22</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C23</th><td style="text-align:left">=IF(<font color="Blue">D23=" ",IF(<font color="Red">A23-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O23-P23</font>)<1," ",O23-P23-B23</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D23</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O22-P23</font>)>1," ",(<font color="Red">O22-P23</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C24</th><td style="text-align:left">=IF(<font color="Blue">D24=" ",IF(<font color="Red">A24-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O24-P24</font>)<1," ",O24-P24-B24</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D24</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O23-P24</font>)>1," ",(<font color="Red">O23-P24</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C25</th><td style="text-align:left">=IF(<font color="Blue">D25=" ",IF(<font color="Red">A25-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O25-P25</font>)<1," ",O25-P25-B25</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D25</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O24-P25</font>)>1," ",(<font color="Red">O24-P25</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C26</th><td style="text-align:left">=IF(<font color="Blue">D26=" ",IF(<font color="Red">A26-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O26-P26</font>)<1," ",O26-P26-B26</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D26</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O25-P26</font>)>1," ",(<font color="Red">O25-P26</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C27</th><td style="text-align:left">=IF(<font color="Blue">D27=" ",IF(<font color="Red">A27-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O27-P27</font>)<1," ",O27-P27-B27</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D27</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O26-P27</font>)>1," ",(<font color="Red">O26-P27</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C28</th><td style="text-align:left">=IF(<font color="Blue">D28=" ",IF(<font color="Red">A28-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O28-P28</font>)<1," ",O28-P28-B28</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D28</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O27-P28</font>)>1," ",(<font color="Red">O27-P28</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C29</th><td style="text-align:left">=IF(<font color="Blue">D29=" ",IF(<font color="Red">A29-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O29-P29</font>)<1," ",O29-P29-B29</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D29</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O28-P29</font>)>1," ",(<font color="Red">O28-P29</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C30</th><td style="text-align:left">=IF(<font color="Blue">D30=" ",IF(<font color="Red">A30-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O30-P30</font>)<1," ",O30-P30-B30</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D30</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O29-P30</font>)>1," ",(<font color="Red">O29-P30</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C31</th><td style="text-align:left">=IF(<font color="Blue">D31=" ",IF(<font color="Red">A31-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O31-P31</font>)<1," ",O31-P31-B31</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D31</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O30-P31</font>)>1," ",(<font color="Red">O30-P31</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C32</th><td style="text-align:left">=IF(<font color="Blue">D32=" ",IF(<font color="Red">A32-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O32-P32</font>)<1," ",O32-P32-B32</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D32</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O31-P32</font>)>1," ",(<font color="Red">O31-P32</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C33</th><td style="text-align:left">=IF(<font color="Blue">D33=" ",IF(<font color="Red">A33-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O33-P33</font>)<1," ",O33-P33-B33</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D33</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O32-P33</font>)>1," ",(<font color="Red">O32-P33</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C34</th><td style="text-align:left">=IF(<font color="Blue">D34=" ",IF(<font color="Red">A34-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O34-P34</font>)<1," ",O34-P34-B34</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D34</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O33-P34</font>)>1," ",(<font color="Red">O33-P34</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C35</th><td style="text-align:left">=IF(<font color="Blue">D35=" ",IF(<font color="Red">A35-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O35-P35</font>)<1," ",O35-P35-B35</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D35</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O34-P35</font>)>1," ",(<font color="Red">O34-P35</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C36</th><td style="text-align:left">=IF(<font color="Blue">D36=" ",IF(<font color="Red">A36-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O36-P36</font>)<1," ",O36-P36-B36</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D36</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O35-P36</font>)>1," ",(<font color="Red">O35-P36</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C37</th><td style="text-align:left">=IF(<font color="Blue">D37=" ",IF(<font color="Red">A37-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O37-P37</font>)<1," ",O37-P37-B37</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D37</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O36-P37</font>)>1," ",(<font color="Red">O36-P37</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C38</th><td style="text-align:left">=IF(<font color="Blue">D38=" ",IF(<font color="Red">A38-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O38-P38</font>)<1," ",O38-P38-B38</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D38</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O37-P38</font>)>1," ",(<font color="Red">O37-P38</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C39</th><td style="text-align:left">=IF(<font color="Blue">D39=" ",IF(<font color="Red">A39-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O39-P39</font>)<1," ",O39-P39-B39</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D39</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O38-P39</font>)>1," ",(<font color="Red">O38-P39</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C40</th><td style="text-align:left">=IF(<font color="Blue">D40=" ",IF(<font color="Red">A40-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O40-P40</font>)<1," ",O40-P40-B40</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D40</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O39-P40</font>)>1," ",(<font color="Red">O39-P40</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C41</th><td style="text-align:left">=IF(<font color="Blue">D41=" ",IF(<font color="Red">A41-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O41-P41</font>)<1," ",O41-P41-B41</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D41</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O40-P41</font>)>1," ",(<font color="Red">O40-P41</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C42</th><td style="text-align:left">=IF(<font color="Blue">D42=" ",IF(<font color="Red">A42-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O42-P42</font>)<1," ",O42-P42-B42</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D42</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O41-P42</font>)>1," ",(<font color="Red">O41-P42</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C43</th><td style="text-align:left">=IF(<font color="Blue">D43=" ",IF(<font color="Red">A43-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O43-P43</font>)<1," ",O43-P43-B43</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D43</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O42-P43</font>)>1," ",(<font color="Red">O42-P43</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C44</th><td style="text-align:left">=IF(<font color="Blue">D44=" ",IF(<font color="Red">A44-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O44-P44</font>)<1," ",O44-P44-B44</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D44</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O43-P44</font>)>1," ",(<font color="Red">O43-P44</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C45</th><td style="text-align:left">=IF(<font color="Blue">D45=" ",IF(<font color="Red">A45-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O45-P45</font>)<1," ",O45-P45-B45</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D45</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O44-P45</font>)>1," ",(<font color="Red">O44-P45</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C46</th><td style="text-align:left">=IF(<font color="Blue">D46=" ",IF(<font color="Red">A46-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O46-P46</font>)<1," ",O46-P46-B46</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D46</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O45-P46</font>)>1," ",(<font color="Red">O45-P46</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C47</th><td style="text-align:left">=IF(<font color="Blue">D47=" ",IF(<font color="Red">A47-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O47-P47</font>)<1," ",O47-P47-B47</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D47</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O46-P47</font>)>1," ",(<font color="Red">O46-P47</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C48</th><td style="text-align:left">=IF(<font color="Blue">D48=" ",IF(<font color="Red">A48-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O48-P48</font>)<1," ",O48-P48-B48</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D48</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O47-P48</font>)>1," ",(<font color="Red">O47-P48</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C49</th><td style="text-align:left">=IF(<font color="Blue">D49=" ",IF(<font color="Red">A49-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O49-P49</font>)<1," ",O49-P49-B49</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D49</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O48-P49</font>)>1," ",(<font color="Red">O48-P49</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C50</th><td style="text-align:left">=IF(<font color="Blue">D50=" ",IF(<font color="Red">A50-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O50-P50</font>)<1," ",O50-P50-B50</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D50</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O49-P50</font>)>1," ",(<font color="Red">O49-P50</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C51</th><td style="text-align:left">=IF(<font color="Blue">D51=" ",IF(<font color="Red">A51-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O51-P51</font>)<1," ",O51-P51-B51</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D51</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O50-P51</font>)>1," ",(<font color="Red">O50-P51</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C52</th><td style="text-align:left">=IF(<font color="Blue">D52=" ",IF(<font color="Red">A52-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O52-P52</font>)<1," ",O52-P52-B52</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D52</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O51-P52</font>)>1," ",(<font color="Red">O51-P52</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C53</th><td style="text-align:left">=IF(<font color="Blue">D53=" ",IF(<font color="Red">A53-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O53-P53</font>)<1," ",O53-P53-B53</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D53</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O52-P53</font>)>1," ",(<font color="Red">O52-P53</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C54</th><td style="text-align:left">=IF(<font color="Blue">D54=" ",IF(<font color="Red">A54-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O54-P54</font>)<1," ",O54-P54-B54</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D54</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O53-P54</font>)>1," ",(<font color="Red">O53-P54</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C55</th><td style="text-align:left">=IF(<font color="Blue">D55=" ",IF(<font color="Red">A55-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O55-P55</font>)<1," ",O55-P55-B55</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D55</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O54-P55</font>)>1," ",(<font color="Red">O54-P55</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C56</th><td style="text-align:left">=IF(<font color="Blue">D56=" ",IF(<font color="Red">A56-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O56-P56</font>)<1," ",O56-P56-B56</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D56</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O55-P56</font>)>1," ",(<font color="Red">O55-P56</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C57</th><td style="text-align:left">=IF(<font color="Blue">D57=" ",IF(<font color="Red">A57-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O57-P57</font>)<1," ",O57-P57-B57</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D57</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O56-P57</font>)>1," ",(<font color="Red">O56-P57</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C58</th><td style="text-align:left">=IF(<font color="Blue">D58=" ",IF(<font color="Red">A58-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O58-P58</font>)<1," ",O58-P58-B58</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D58</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O57-P58</font>)>1," ",(<font color="Red">O57-P58</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C59</th><td style="text-align:left">=IF(<font color="Blue">D59=" ",IF(<font color="Red">A59-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O59-P59</font>)<1," ",O59-P59-B59</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D59</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O58-P59</font>)>1," ",(<font color="Red">O58-P59</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C60</th><td style="text-align:left">=IF(<font color="Blue">D60=" ",IF(<font color="Red">A60-7>$B$3," ",IF(<font color="Green">(<font color="Purple">O60-P60</font>)<1," ",O60-P60-B60</font>)</font>)," "</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D60</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">O59-P60</font>)>1," ",(<font color="Red">O59-P60</font>)*-1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A9</th><td style="text-align:left">=A8+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A10</th><td style="text-align:left">=A9+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A11</th><td style="text-align:left">=A10+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A12</th><td style="text-align:left">=A11+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A13</th><td style="text-align:left">=A12+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A14</th><td style="text-align:left">=A13+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A15</th><td style="text-align:left">=A14+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A16</th><td style="text-align:left">=A15+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A17</th><td style="text-align:left">=A16+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A18</th><td style="text-align:left">=A17+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A19</th><td style="text-align:left">=A18+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A20</th><td style="text-align:left">=A19+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A21</th><td style="text-align:left">=A20+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A22</th><td style="text-align:left">=A21+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A23</th><td style="text-align:left">=A22+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A24</th><td style="text-align:left">=A23+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A25</th><td style="text-align:left">=A24+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A26</th><td style="text-align:left">=A25+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A27</th><td style="text-align:left">=A26+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A28</th><td style="text-align:left">=A27+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A29</th><td style="text-align:left">=A28+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A30</th><td style="text-align:left">=A29+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A31</th><td style="text-align:left">=A30+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A32</th><td style="text-align:left">=A31+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A33</th><td style="text-align:left">=A32+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A34</th><td style="text-align:left">=A33+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A35</th><td style="text-align:left">=A34+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A36</th><td style="text-align:left">=A35+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A37</th><td style="text-align:left">=A36+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A38</th><td style="text-align:left">=A37+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A39</th><td style="text-align:left">=A38+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A40</th><td style="text-align:left">=A39+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A41</th><td style="text-align:left">=A40+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A42</th><td style="text-align:left">=A41+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A43</th><td style="text-align:left">=A42+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A44</th><td style="text-align:left">=A43+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A45</th><td style="text-align:left">=A44+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A46</th><td style="text-align:left">=A45+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A47</th><td style="text-align:left">=A46+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A48</th><td style="text-align:left">=A47+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A49</th><td style="text-align:left">=A48+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A50</th><td style="text-align:left">=A49+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A51</th><td style="text-align:left">=A50+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A52</th><td style="text-align:left">=A51+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A53</th><td style="text-align:left">=A52+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A54</th><td style="text-align:left">=A53+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A55</th><td style="text-align:left">=A54+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A56</th><td style="text-align:left">=A55+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A57</th><td style="text-align:left">=A56+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A58</th><td style="text-align:left">=A57+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A59</th><td style="text-align:left">=A58+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A60</th><td style="text-align:left">=A59+7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A62</th><td style="text-align:left">=B2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A63</th><td style="text-align:left">=E3</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A70</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$B$3-21,$A$8:$A$60,1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B70</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A$70,$A$8:$C$60,2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C70</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A$70,$A$8:$F$60,3</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D70</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A$70,$A$8:$F$60,4</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E70</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A$70,$A$8:$F$60,5</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A72</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$B$3-14,$A$8:$A$60,1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B72</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A$72,$A$8:$C$60,2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C72</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A$72,$A$8:$C$60,3</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D72</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A72,$A$8:$F$60,4</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E72</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A$72,$A$8:$F$60,5</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A74</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$B$3-7,$A$8:$A$60,1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B74</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A$74,$A$8:$C$60,2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C74</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A$74,$A$8:$C$60,3</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D74</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A74,$A$8:$F$60,4</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E74</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A$74,$A$8:$F$60,5</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A76</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$B$3,$A$8:$A$60,1</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B76</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$B$3,$A$8:$C$60,2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C76</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$B$2,$A$8:$D$60,3</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D76</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$A76,$A$8:$F$60,4</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E76</th><td style="text-align:left">=VLOOKUP(<font color="Blue">$B$3,$A$8:$F$60,5</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E79</th><td style="text-align:left">=SUM(<font color="Blue">B76+C76+D76+E76</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F79</th><td style="text-align:left">=IF(<font color="Blue">E79<1," CR"," "</font>)</td></tr></tbody></table></td></tr></table><br />
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
We really don't need to see all your data, just a small enough sample that we can see what you have and what you want. You just posted 14 pages/screens of data that we need to scroll up and down through to see anything :(
 

Joneye

Well-known Member
Joined
May 28, 2010
Messages
749
Office Version
  1. 2016
Platform
  1. MacOS
We really don't need to see all your data, just a small enough sample that we can see what you have and what you want. You just posted 14 pages/screens of data that we need to scroll up and down through to see anything :(

Ok will do, not sure how to delete this thread :(
 

Watch MrExcel Video

Forum statistics

Threads
1,129,989
Messages
5,639,405
Members
417,086
Latest member
bfruge

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top