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