VBA Code Populate Certain Column Data into Rows in another sheet

mcarrigg · Apr 24, 2012

Hi Everyone,

I will preface this by saying I have got a cross thread in ozgrid

http://www.ozgrid.com/forum/showthread.php?t=164724

For Those that cannot view the sample workbook attached in that post, I have two worksheets...

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; 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><TH>Q</TH><TH>R</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; COLOR: #0000ff; FONT-WEIGHT: bold; TEXT-DECORATION: underline"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="FONT-STYLE: italic">Invoice Details</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="TEXT-ALIGN: right; COLOR: #ffffff"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic"></TD><TD style="TEXT-ALIGN: right; FONT-STYLE: italic"></TD><TD style="TEXT-ALIGN: right; FONT-STYLE: italic"></TD><TD style="TEXT-ALIGN: right; FONT-STYLE: italic"></TD><TD style="TEXT-ALIGN: right; FONT-STYLE: italic"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic">3,564.51 </TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic">- </TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic">3,564.51 </TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic"></TD><TD style="TEXT-ALIGN: right; FONT-STYLE: italic"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Invoice Number</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Invoice Date</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Customer Code</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Customer Name</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Qty</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Charge Type</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Tax Inclusive Amount </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Tax Code </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Invoice Due Date</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Payment Date</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Invoice Status</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">GST Tax Amount </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Exclusive Amount </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">SC1 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">State Ref </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">SC2 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Error Code </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Multi Line Inv </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">INV00001</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">13-Apr-12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Nicholas Smith</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">50:00</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Gross Standard $ Charged</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$360.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Exempt </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18-Apr-12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$360.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0-1</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">E2</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">INV00001</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">13-Apr-12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Nicholas Smith</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Rebate</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($115.55)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Exempt </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18-Apr-12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($115.55)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0-1</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">E2</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Y</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">INV00002</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">13-Apr-12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Ethan Williams</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:00</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Gross Standard $ Charged</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$432.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Exempt </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18-Apr-12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$432.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0-2</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">E2</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">INV00002</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">13-Apr-12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Ethan Williams</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:05</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Gross Overtime $ Charged</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Exempt </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18-Apr-12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0-2</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">E2</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Y</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">INV00002</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">13-Apr-12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Ethan Williams</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Rebate</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($138.47)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Exempt </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18-Apr-12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($138.47)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0-2</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">E2</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Y</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">INV00002</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">13-Apr-12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Ethan Williams</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Overtime Discount</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($0.19)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Exempt </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18-Apr-12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($0.19)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0-2</TD><TD style="TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">E2</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Y</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">11</TD><TD style="BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">INV00002</TD><TD style="TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">13-Apr-12</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-LEFT: black 1px solid">Ethan Williams</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #dbe5f1; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Materials</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$3,026.00 </TD><TD style="TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Exempt </TD><TD style="TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18-Apr-12</TD><TD style="TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$3,026.00 </TD><TD style="TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0-2</TD><TD style="TEXT-ALIGN: center; BORDER-LEFT: black 1px solid">0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">E2</TD><TD style="TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Y</TD></TR></TBODY></TABLE>

Details

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; 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><TH>Q</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc000; FONT-WEIGHT: bold">13-Apr-12</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="BACKGROUND-COLOR: #7cf0b0; FONT-STYLE: italic">Financial Summary</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">customer ------></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Nicholas Smith</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Ethan Williams</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">TEST customer 3</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">TEST customer 5</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">TEST customer 8</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">TEST customer 10</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">17</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">19</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Test customer 20</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Total</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 1 Standard Hours</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">270:00</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 1 Overtime Hours</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:40</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 1 Total Hours</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">40:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">40:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">40:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">40:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">40:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">40:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">330:40</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">11</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 1 Gross Standard $ Charged</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,944.00 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">12</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 1 Gross Overtime $ Charged</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$105.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$105.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$105.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$105.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$105.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$105.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$635.76 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">13</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 1 Total Gross $ Charged</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$321.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$321.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$321.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$321.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$321.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$321.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$2,579.76 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">14</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 1 Standard Discount</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">15</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 1 Rebate</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($69.33)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($69.14)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($46.03)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($46.03)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($47.36)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($47.36)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($325.25)</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">16</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 1 Overtime Discount</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($0.19)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($23.30)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($23.30)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($34.31)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($34.31)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($115.41)</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">17</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 1 Total Discount</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($69.33)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($69.33)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($69.33)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($69.33)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($81.67)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($81.67)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($440.66)</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">18</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 1 Materials</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,730.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,418.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,346.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,706.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,298.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,298.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,730.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,298.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$11,824.00 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">19</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 1 Nett Payable</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$146.67 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,877.39 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,670.39 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,598.39 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,946.05 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,538.05 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,619.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$2,051.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,514.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$13,963.10 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">20</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 2 Standard Hours</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">220:00</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">21</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 2 Overtime Hours</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">22</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 2 Total Hours</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">30:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">220:00</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">23</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 2 Gross Standard $ Charged</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$144.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$144.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$144.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$144.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$144.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,584.00 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">24</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 2 Gross Overtime $ Charged</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">25</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 2 Total Gross $ Charged</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$144.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$144.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$144.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$144.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$144.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$216.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,584.00 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">26</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 2 Standard Discount</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">27</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 2 Rebate</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($46.22)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($69.33)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($46.22)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($46.22)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($81.67)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($81.67)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($371.33)</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">28</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 2 Overtime Discount</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">29</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 2 Total Discount</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($46.22)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($69.33)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($46.22)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($46.22)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($81.67)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($81.67)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($371.33)</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">30</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 2 Materials</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,296.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$552.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,272.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$864.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$864.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$864.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,296.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$7,008.00 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">31</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Week 2 Nett Payable</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$97.78 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,442.67 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$649.78 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$97.78 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,406.33 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$998.33 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,008.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,008.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,512.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #c5d9f1; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$8,220.67 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">32</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ee0213; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Standard Hours</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">50:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">50:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">50:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">50:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">50:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">490:00</TD><TD style="BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00">Total Standard Hrs to go into column E, Ignore if none</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">33</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ee0213; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Overtime Hours</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:40</TD><TD style="BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00">Total Overtime Hrs to go into column E, Ignore if none</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">34</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ee0213; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Hours</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">50:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">70:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">70:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">60:05</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0:00</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">550:40</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">35</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ee0213; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Gross Standard $ Charged</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$360.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$432.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$360.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$360.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$432.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$432.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$360.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$360.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$432.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$3,528.00 </TD><TD style="BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00">Total Fortnightly $ charged to go into column g, Ignore if none</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">36</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ee0213; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Gross Overtime $ Charged</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$105.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$105.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$105.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$105.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$105.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$105.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$635.76 </TD><TD style="BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00">Total Overtime Hrs to go into column g, Ignore if none</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">37</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ee0213; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Gross $ Charged</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$360.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$432.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$465.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$465.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$537.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$537.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$465.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$465.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$432.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$4,163.76 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">38</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ee0213; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Standard Discount</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00">Total Overtime Hrs to go into column g, Ignore if none</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">39</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ee0213; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Rebate</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($115.55)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($138.47)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($92.25)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($92.25)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($129.03)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($129.03)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($696.58)</TD><TD style="BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00">Total Overtime Hrs to go into column g, Ignore if none</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">40</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ee0213; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Overtime Discount</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($0.19)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($23.30)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($23.30)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($34.31)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($34.31)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($115.41)</TD><TD style="BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00">Total Overtime Hrs to go into column g, Ignore if none</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">41</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ee0213; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Discount</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($115.55)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($138.66)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($115.55)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($115.55)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($163.34)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($163.34)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">($811.99)</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">42</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ee0213; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Total Materials</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$3,026.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,970.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$1,346.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$2,978.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$2,162.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$2,162.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$2,594.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$2,594.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$18,832.00 </TD><TD style="BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00">Total Overtime Hrs to go into column g, Ignore if none</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">43</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Total Nett Payable</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">$244.45 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">$3,320.06 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">$2,320.17 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">$1,696.17 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">$3,352.38 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">$2,536.38 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">$2,627.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">$3,059.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">$3,026.72 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">$0.00 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #ffff00; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">$22,183.77 </TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #7cf0b0; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">44</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">45</TD><TD style="BACKGROUND-COLOR: #ee0213">For Each Cell in Red, a new line needs to be entered for the invoice number generated for each customer - refer to invoices 1 & 2 on details sheet.</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ee0213"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ee0213"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ee0213"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ee0213"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ee0213"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ee0213"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ee0213"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ee0213"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ee0213"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #7cf0b0"></TD></TR></TBODY></TABLE>

Financial Summary

I am wanting to create rows on "Details" worksheet from certain Parts of a Column from "Financial Summary" worksheet. The difference being that each column in essence is pertaining to one customer hence one invoice number.

Rows 5:31 of "Financial Summary" are ignored for this issue. 32:43 are the rows i want to look at.

i want the date (L1) of "Financial Summary" to be copied for each generated invoice number in column (B) of "Details"

I have got instructions In yellow at the side of the financial summary table of where i want that data to populate into "Details" worksheet - this should only happen if there is a value for that row.

I have got a macro that creates the next invoice number from the "Details" worksheetand places it into the next blank row, but I have run into trouble progressing further.

The cell A45 in "Financial Summary" worksheet explains what i want to happen to the cells in yellow.

i have manually entered the data in "Details" to show how Customers Nicholas and Ethan, invoice should populate the "Details Tab". Note that Nicholas all entries are with reference INV00001 and Ethan is INV00002. I want the macro to look up columns B:K for customers but not do anything if there is no customer name (in this example column (K)).

Sorry for the long post but i wanted to be clear on what i am after. Please ask if you have any more questions.

My grasp of VBA is very limited so your help is much appreciated.

mcarrigg · Apr 24, 2012

Ohh I forgot to mention that I am not getting any response the my question in the ozgrid forum so this is why I am asking the good people in here.

Thanks again for anyone that may be able to assist.

Zack Barresse · Apr 24, 2012

Hello,

A few questions:

What version of Excel are you using?
How do you know what customer you want to move details of to the Details worksheet?
Your instructions (in yellow) are very confusing, and most often are just repeating. Can you clarify them? Do you mean that you want code to fire when you change a cell, and only look in the rows specified (32 through 43), and if the name of that customer (column header) does not exist in the Details worksheet, then add it?
What if there is already a customer, should it update the information?
It looks like one record would include data from rows 34 (Total Hours) and 37 (Total Gross $ Charged), then another one would include data from rows 39 (Total Rebate) (are you sure it wouldn't be 41 - Total Discount??)
So are you looking for a routine to do this one time? Or are you looking for a change event to do this continuously?

Please clarify and quantify your questions more.

mcarrigg · Apr 25, 2012

Zack Barresse said:
Hello,

A few questions:

What version of Excel are you using?

How do you know what customer you want to move details of to the Details worksheet?

Your instructions (in yellow) are very confusing, and most often are just repeating. Can you clarify them? Do you mean that you want code to fire when you change a cell, and only look in the rows specified (32 through 43), and if the name of that customer (column header) does not exist in the Details worksheet, then add it?

What if there is already a customer, should it update the information?

It looks like one record would include data from rows 34 (Total Hours) and 37 (Total Gross $ Charged), then another one would include data from rows 39 (Total Rebate) (are you sure it wouldn't be 41 - Total Discount??)

So are you looking for a routine to do this one time? Or are you looking for a change event to do this continuously?

Please clarify and quantify your questions more.

Hi Zack, thanks for the questions.

What version of Excel are you using? - 2007
How do you know what customer you want to move details of to the Details worksheet? - All customers on this worksheet, it is only updated fortnightly for a service business
Your instructions (in yellow) are very confusing, and most often are just repeating. Can you clarify them? Do you mean that you want code to fire when you change a cell, and only look in the rows specified (32 through 43), and if the name of that customer (column header) does not exist in the Details worksheet, then add it? - Code to fire on command button action, and yes only look in rows 32:43. Each customer name (column header) will have one unique invoice generated for this fortnight but there will be multiple rows (records?) on this invoice number depending on which rows have values from the customer column on financial summary sheet). If there is no customer name on financial summary sheet then no invoice generated for that fortnight. This financial summary table uses lookups for active customers for the fortnight so the customer list here is dynamic and will always vary depending on work provided for fortnight. So times there could only be one customer name. Very rarely will I have more than 7 or 8 customer jobs per fortnight so I have provisioned for 10.
What if there is already a customer, should it update the information? - No the details tab retains a recorded history of all invoices created so in time can be 1,000's of rows (until a clean up is performed for all closed invoices at financial year end). the financial summary is a sheet that is updated fortnightly and exported every fortnight to retain work records per customer (already acheived this process). I want to press a command button so that all records from the financial summary sheet are populated in the details tab (invoiced), then the the financial summary sheet date is changed to the new fortnightly date specified in the user form the action is commenced.
It looks like one record would include data from rows 34 (Total Hours) and 37 (Total Gross $ Charged), then another one would include data from rows 39 (Total Rebate) (are you sure it wouldn't be 41 - Total Discount??) - Yes that is correct and yes I just changed my mind and decided to go with total discount rather than split discount and rebate. One record will contain Std Hrs and Std $, another will contain overtime hrs and $ (if values exist) and another record for discount (if values exist) and finally another for materials (if values exist). Each record for that fortnight should share the same invoice number for that customer for that fortnight. This process should loop through for each customer that is on this financial summary sheet for the fortnight.
So are you looking for a routine to do this one time? Or are you looking for a change event to do this continuously? - I will have a userform to change fortnight end date which fires off this macro to do this import into details worksheet, call a macro which already exists to copy fortnightly work data into another book and save it in a directory and finally change the fortnightly end date in cell L1 of the financial summary worksheet. i am fine creating the userform and assigning the new date to the cell and calling the macros, just need a lot of help with this macro. I have the vision of what this macro was required to do, just not the expertise to make this part of it happen!

Hopefully the red text answers your questions and opens some more light on my intentions and goal of this macro, but if you have anymore I am more than happy to let you know the answers.

Zack Barresse · Apr 25, 2012

Thank you for the answers. They do indeed help. Some other clarifying questions.

Will this data structure always be the same? Or is there a chance it will change? I ask because if we tell it to look at row 34, and then down the road you add a row at, say, row 30, it should then be row 35 you want. So you can either go by row number, or look at the header in column A. Either will work. Which one would you like?
Invoice number can be assumed that, from the Details worksheet, the last Invoice Number in column A will be the highest numerically annotated invoice? For example, "INV00002" is the bottom-most value. Can we assume that the bottom-most value is the highest number, thus assume the next invoice number will be "INV00003"?

I think that's good for right now.

Zack Barresse · Apr 25, 2012

Oh yes, one other question. Your last customer is in column J. Then you have a (more or less) blank column K, and a totals column in L. Will this always be the same? So if we found the right-most column, can we always assume the last customer will be two columns to the left of that?

mcarrigg · Apr 25, 2012

Zack Barresse said:
Thank you for the answers. They do indeed help. Some other clarifying questions.

Will this data structure always be the same? Or is there a chance it will change? I ask because if we tell it to look at row 34, and then down the road you add a row at, say, row 30, it should then be row 35 you want. So you can either go by row number, or look at the header in column A. Either will work. Which one would you like?

Invoice number can be assumed that, from the Details worksheet, the last Invoice Number in column A will be the highest numerically annotated invoice? For example, "INV00002" is the bottom-most value. Can we assume that the bottom-most value is the highest number, thus assume the next invoice number will be "INV00003"?

I think that's good for right now.

Will this data structure always be the same? Or is there a chance it will change? I ask because if we tell it to look at row 34, and then down the road you add a row at, say, row 30, it should then be row 35 you want. So you can either go by row number, or look at the header in column A. Either will work. Which one would you like? - The structure as far as I currently see it will remain the same, but to future proof it to a certain degree I was thinking that look at the header from column A
Invoice number can be assumed that, from the Details worksheet, the last Invoice Number in column A will be the highest numerically annotated invoice? For example, "INV00002" is the bottom-most value. Can we assume that the bottom-most value is the highest number, thus assume the next invoice number will be "INV00003"? - Correct.

mcarrigg · Apr 25, 2012

Zack Barresse said:
Oh yes, one other question. Your last customer is in column J. Then you have a (more or less) blank column K, and a totals column in L. Will this always be the same? So if we found the right-most column, can we always assume the last customer will be two columns to the left of that?

Sorry Zack just saw this question after I posted the previous response.

Column K thoeretically can contain customer information if work has been done for that many clients in the fortnight. The structure will not change, I was just allowing for a little growth if i took on another worker and increased capacity. We are currently looking at 6-7 customers per fortnight. Even allowing for a couple of smaller jobs (major majority of jobs entail 20+hours) each fortnight I cant see needing more than 10 columns for now.

Short answer, customers can populate columns B right through to and including Column K with total in L. So we can look at 1 column to left of Total Column L

thanks again for looking at this for me.

Zack Barresse · Apr 25, 2012

Okay, I think last question. The other information at the top of the Details worksheet, i.e. "Invoice Date", "Tax Code", "SC1", "SC2", etc, where does that information come from? Are you only wanting to populate just a sparse amount of data specified?

mcarrigg · Apr 25, 2012

Zack Barresse said:
Okay, I think last question. The other information at the top of the Details worksheet, i.e. "Invoice Date", "Tax Code", "SC1", "SC2", etc, where does that information come from? Are you only wanting to populate just a sparse amount of data specified?

Invoice Date should be populate by the date in Cell L1 of Financial Summary Worksheet.

The rest of the columns in the Details worksheet are not inputs, they are all lookups and formulas and are irrelevant to what this task is doing, those columns automatically should populate down as more rows are added to the table in "Details"

VBA Code Populate Certain Column Data into Rows in another sheet

mcarrigg

New Member

Excel Facts

mcarrigg

New Member

Zack Barresse

MrExcel MVP

mcarrigg

New Member

Zack Barresse

MrExcel MVP

Zack Barresse

MrExcel MVP

mcarrigg

New Member

mcarrigg

New Member

Zack Barresse

MrExcel MVP

mcarrigg

New Member

Similar threads

Forum statistics

Share this page

VBA Code Populate Certain Column Data into Rows in another sheet

New Member

Excel Facts

New Member

MrExcel MVP

New Member

MrExcel MVP

MrExcel MVP

New Member

New Member

MrExcel MVP

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock