Accrual VS. Usage Formula

M

MsMeliss

New Member
Joined
Jun 22, 2018
Messages
2
Ive got a nice spreadsheet set up with all the info I need, but I cant get the formulas to tie together correctly to calculate properly. Im getting very frustrated! Please help. :confused:
Why cant we attach excel here?!?!


[TABLE="width: 1990"]
<colgroup><col><col><col><col><col span="3"><col span="3"><col><col span="13"><col span="7"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Balance[/TD]
[TD="colspan: 16"]Vacation Accruals[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]D.O.H.[/TD]
[TD] Employee[/TD]
[TD]Since the last ADP payroll on 6/10/2017[/TD]
[TD]6/25[/TD]
[TD]7/10[/TD]
[TD]7/25[/TD]
[TD]8/10[/TD]
[TD]8/25[/TD]
[TD]9/10[/TD]
[TD]9/25[/TD]
[TD]10/10[/TD]
[TD]10/25[/TD]
[TD]11/10[/TD]
[TD]11/25[/TD]
[TD]12/10[/TD]
[TD]12/25[/TD]
[TD]1/10[/TD]
[TD]1/25[/TD]
[TD]2/10[/TD]
[TD]2/25[/TD]
[TD]3/10[/TD]
[TD]3/25[/TD]
[TD]4/10[/TD]
[TD]4/25[/TD]
[TD]5/10[/TD]
[TD]5/25[/TD]
[TD]6/10[/TD]
[TD]6/25[/TD]
[TD]7/10[/TD]
[TD]7/25[/TD]
[TD]Hours Sum[/TD]
[TD]Vacation Usage[/TD]
[TD]Vacation Balance[/TD]
[TD] Employee[/TD]
[TD]Dawn balance 6/10/18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sac[/TD]
[TD="align: right"]6/14/2017[/TD]
[TD]Blanco, Javier[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]40.00[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]46.66[/TD]
[TD] [/TD]
[TD]46.66[/TD]
[TD]Blanco, Javier[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9/6/2017[/TD]
[TD]Bruner, Kevin[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[TD]Bruner, Kevin[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7/12/2017[/TD]
[TD]Coburn, Kenji[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]40.00[/TD]
[TD="align: right"]40.00[/TD]
[TD] [/TD]
[TD]40.00[/TD]
[TD]Coburn, Kenji[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8/21/2017[/TD]
[TD]Grant, Tricia[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[TD]Grant, Tricia[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5/9/2018[/TD]
[TD]Hickson, Richard[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]40.00[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]56.65[/TD]
[TD] [/TD]
[TD]56.65[/TD]
[TD]Hickson, Richard[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6/1/2017[/TD]
[TD]Manuita, Taro JR[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]40.00[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]49.99[/TD]
[TD] [/TD]
[TD]49.99[/TD]
[TD]Manuita, Taro JR[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7/9/2012[/TD]
[TD]Mayer, Charles[/TD]
[TD]22.44[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]112.35[/TD]
[TD]-55.50[/TD]
[TD]36.65[/TD]
[TD]Mayer, Charles[/TD]
[TD="align: right"]46.90[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11/1/2005[/TD]
[TD]Norbeck, Martin[/TD]
[TD]259.87[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]349.78[/TD]
[TD]-55.75[/TD]
[TD]294.03[/TD]
[TD]Norbeck, Martin[/TD]
[TD="align: right"]285.08[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2/1/2018[/TD]
[TD]Perez, Robert[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[TD]Perez, Robert[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2/17/2015[/TD]
[TD]Price, Felecia[/TD]
[TD]127.74[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]217.65[/TD]
[TD]-16.50[/TD]
[TD]201.15[/TD]
[TD]Price, Felecia[/TD]
[TD="align: right"]168.70[/TD]
[TD] > 22.46[/TD]
[/TR]
[TR]
[TD="align: right"]2/16/2015[/TD]
[TD]Sao, Lalotea[/TD]
[TD]14.87[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]104.78[/TD]
[TD]-16.00[/TD]
[TD]88.78[/TD]
[TD]Sao, Lalotea[/TD]
[TD="align: right"]14.83[/TD]
[TD] > 63.96.[/TD]
[/TR]
[TR]
[TD="align: right"]11/1/2015[/TD]
[TD]Scoggins, Larry[/TD]
[TD]113.56[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]203.47[/TD]
[TD]-64.00[/TD]
[TD]139.47[/TD]
[TD]Scoggins, Larry[/TD]
[TD="align: right"]129.52[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0.00[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]6/12/2017[/TD]
[TD]Berry, Charlene[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]40.00[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]49.99[/TD]
[TD]0.00[/TD]
[TD]49.99[/TD]
[TD]Berry, Charlene[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Reno[/TD]
[TD="align: right"]9/1/2016[/TD]
[TD]Brewton, Brian[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]76.59[/TD]
[TD]-16.00[/TD]
[TD]60.59[/TD]
[TD]Brewton, Brian[/TD]
[TD="align: right"]80.65[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2/22/2010[/TD]
[TD]Colvin, Kirk[/TD]
[TD]91.04[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]180.95[/TD]
[TD]-48.00[/TD]
[TD]132.95[/TD]
[TD]Colvin, Kirk[/TD]
[TD="align: right"]67.01[/TD]
[TD] > 55.95[/TD]
[/TR]
[TR]
[TD="align: right"]8/8/2017[/TD]
[TD]Halstead-Oglevie[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[TD]Halstead-Oglevie[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3/13/2017[/TD]
[TD]Lenares, Paul Sr.[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[TD]Lenares, Paul Sr.[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9/16/2016[/TD]
[TD]McGee, Rick[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]8.00[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]74.60[/TD]
[TD]0.00[/TD]
[TD]74.60[/TD]
[TD]McGee, Rick[/TD]
[TD="align: right"]64.66[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5/9/2005[/TD]
[TD]Mix, Kathy[/TD]
[TD]48.49[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]138.40[/TD]
[TD]-16.00[/TD]
[TD]122.40[/TD]
[TD]Mix, Kathy[/TD]
[TD="align: right"]80.45[/TD]
[TD] > 31.96[/TD]
[/TR]
[TR]
[TD="align: right"]5/1/2018[/TD]
[TD]Solan, Matthew[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]40.00[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]56.65[/TD]
[TD] [/TD]
[TD]56.65[/TD]
[TD]Solan, Matthew[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2/3/2014[/TD]
[TD]Solan, Thomas[/TD]
[TD]171.04[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]260.95[/TD]
[TD]-40.00[/TD]
[TD]220.95[/TD]
[TD]Solan, Thomas[/TD]
[TD="align: right"]171.00[/TD]
[TD] > 39.96[/TD]
[/TR]
[TR]
[TD="align: right"]11/17/2003[/TD]
[TD]Water, Robert[/TD]
[TD]107.74[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]197.65[/TD]
[TD]0.00[/TD]
[TD]197.65[/TD]
[TD]Water, Robert[/TD]
[TD="align: right"]187.66[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0.00[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fresno[/TD]
[TD="align: right"]6/11/2012[/TD]
[TD]Avalos, Ross[/TD]
[TD]47.38[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]137.29[/TD]
[TD]-16.00[/TD]
[TD]121.29[/TD]
[TD]Avalos, Ross[/TD]
[TD="align: right"]111.30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3/11/1991[/TD]
[TD]Brown, Sherrie[/TD]
[TD]207.75[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]6.67[/TD]
[TD="align: right"]384.50[/TD]
[TD]-203.50[/TD]
[TD]181.00[/TD]
[TD]Brown, Sherrie[/TD]
[TD="align: right"]164.33[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11/6/2017[/TD]
[TD]Chihany, Debra[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[TD]Chihany, Debra[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]12/8/2009[/TD]
[TD]Crum, Roger[/TD]
[TD]13.90[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]103.81[/TD]
[TD]-40.00[/TD]
[TD]63.81[/TD]
[TD]Crum, Roger[/TD]
[TD="align: right"]13.86[/TD]
[TD] > 39.96[/TD]
[/TR]
[TR]
[TD="align: right"]3/12/2018[/TD]
[TD]Duarte, Danielle[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[TD]Duarte, Danielle[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9/22/2014[/TD]
[TD]Esparza, Alfonso[/TD]
[TD]22.06[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]111.97[/TD]
[TD]-48.00[/TD]
[TD]63.97[/TD]
[TD]Esparza, Alfonso[/TD]
[TD="align: right"]14.02[/TD]
[TD] > 39.96[/TD]
[/TR]
[TR]
[TD="align: right"]6/18/2018[/TD]
[TD]Herndez, Sam (Sylv)[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[TD]Herndez, Sam (Sylv)[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5/9/2007[/TD]
[TD]Puentes, Jeremy[/TD]
[TD]44.69[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]134.60[/TD]
[TD]-24.00[/TD]
[TD]110.60[/TD]
[TD]Puentes, Jeremy[/TD]
[TD="align: right"]3.40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7/3/2017[/TD]
[TD]Sharkey, James[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]40.00[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]43.33[/TD]
[TD] [/TD]
[TD]43.33[/TD]
[TD]Sharkey, James[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/9/2017[/TD]
[TD]Spradley, David[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]40.00[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]86.62[/TD]
[TD]0.00[/TD]
[TD]86.62[/TD]
[TD]Spradley, David[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9/1/2013[/TD]
[TD]Torres, Paul[/TD]
[TD]8.94[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]98.85[/TD]
[TD]-64.00[/TD]
[TD]34.85[/TD]
[TD]Torres, Paul[/TD]
[TD="align: right"]24.80[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6/1/2014[/TD]
[TD]Venegas, Jesus[/TD]
[TD]15.13[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]105.04[/TD]
[TD]-24.00[/TD]
[TD]81.04[/TD]
[TD]Venegas, Jesus[/TD]
[TD="align: right"]17.59[/TD]
[TD] > 53.46[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]11/28/2017[/TD]
[TD]Wallace, Kim[/TD]
[TD]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[TD]Wallace, Kim[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1,376.83[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3,669.83[/TD]
[TD] [/TD]
[TD]2,790.09[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
You must log in or register to reply here.

Similar threads

Q
  • Question Question
A VBA module needed to transfer data from one sheet to another
Replies
1
Views
545
Zot
Z
M
  • Question Question
Vacation accrual formula HELP!
Replies
1
Views
936
aschenbrenerm
aschenbrenerm
A
  • Solved
Sum((CountIF, with Mult. Ranges across Mult. Tabs, 1 Criteria) + (CountIF, with Mult. Ranges across Mult. Tabs, 1 Criteria))
Replies
3
Views
633
AudyAnalyst
A
R
  • Question Question
Salary Distribution and 3 percent increment every year on hire date
Replies
0
Views
1K
ruchperformive
R
C
  • Solved
Formula for calculating Stock Option rolls
Replies
4
Views
849
Toadstool
Toadstool

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

Share this page

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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