Spreadsheet: 79061d1279290437-cell-references-changing-match-index-sample-vacation-report
Sheet: Data

DEPT | SUPERVISOR | EE# | EE NAME | Date of hire | Rehire Date | vacation hours earned | vacation hours taken | Vacation hours remaining | Hourly or salaried | vacation code | base salary | hours worked biweekly | weekly hours | hourly rate | vacation $ owing | vacation weeks due | Years of Service | annual vacation entitlement (hours) | annual vacation entitlement (weeks) | hours over entitlement | weeks over entitlement | ranged weeks over entitlement | VP | Daily Hourly Accruals | Estimated VAC HRS as of Estimate Month | Estimated VAC WKS DUE as of Estimate Month | Estimated VAC Weeks Due | Anniversary Month | >1 week in anniversary month? | 2010-07-14 00:00:00 | #N/A | #N/A
111 | [NAME] | 1234 | A Adams | 2001-06-19 00:00:00 |  | 880.5 | 718.19 | 162.31 | H | VACMB | 15.64 | 80 | 40 | 15.64 | 2538.5284 | 4.05775 | 9.073972602739726 | 120 | 3 | 42.31 | 1.05775 | 1-2 | [NAME] | 0.3287671232876712 | #N/A | #N/A | #N/A | June | #N/A
222 | [NAME] | 1235 | B Bradley | 1999-06-15 00:00:00 |  | 1011.2 | 978.5 | 32.7 | S | VACMB | 2122.77 | 80 | 40 | 26.534625 | 867.6822375 | 0.8175 | 11.08767123287671 | 160 | 4 | -127.3 | -3.1825 | <1 | [NAME] | 0.4383561643835616 | #N/A | #N/A | #N/A | June | #N/A
333 | [NAME] | 1236 | C Charles | 1998-08-04 00:00:00 |  | 1085.56 | 959.1 | 126.46 | H | VACMB | 15.64 | 80 | 40 | 15.64 | 1977.8344 | 3.1615 | 11.95068493150685 | 160 | 4 | -33.54000000000001 | -0.8384999999999998 | <1 | [NAME] | 0.4383561643835616 | #N/A | #N/A | #N/A | August | #N/A
111 | [NAME] | 1237 | D Davidson | 1981-03-20 00:00:00 |  | 1749.2 | 1507.2 | 242 | H | VACMB | 28 | 80 | 40 | 28 | 6776 | 6.05 | 29.33698630136986 | 200 | 5 | 42 | 1.05 | 1-2 | [NAME] | 0.547945205479452 | #N/A | #N/A | #N/A | March | #N/A
222 | [NAME] | 1238 | E Erickson | 1983-04-04 00:00:00 |  | 1816.18 | 1291.9 | 524.28 | H | VACMB | 17.17 | 80 | 40 | 17.17 | 9001.8876 | 13.107 | 27.2958904109589 | 200 | 5 | 324.28 | 8.107 | 8-10 | [NAME] | 0.547945205479452 | #N/A | #N/A | #N/A | April | #N/A
333 | [NAME] | 1239 | [NAME] | 1992-01-27 00:00:00 |  | 1359.72 | 1253.5 | 106.22 | H | VACMB | 28 | 80 | 40 | 28 | 2974.16 | 2.6555 | 18.47397260273972 | 160 | 4 | -53.78 | -1.3445 | <1 | [NAME] | 0.4383561643835616 | #N/A | #N/A | #N/A | January | #N/A
111 | [NAME] | 1247 | G [NAME] | 1997-04-17 00:00:00 |  | 1247.26 | 1052 | 195.26 | S | VACMB | 1251.2 | 80 | 40 | 15.64 | 3053.8664 | 4.8815 | 13.24931506849315 | 160 | 4 | 35.25999999999999 | 0.8815 | <1 | [NAME] | 0.4383561643835616 | #N/A | #N/A | #N/A | April | #N/A
444 | [NAME] | 1240 | H Hanson | 1984-01-31 00:00:00 |  | 1753.12 | 1584 | 169.12 | S | VACMB | 2122.77 | 80 | 40 | 26.534625 | 4487.53578 | 4.228 | 26.46849315068493 | 200 | 5 | -30.88 | -0.7720000000000002 | <1 | [NAME] | 0.547945205479452 | #N/A | #N/A | #N/A | January | #N/A
555 | [NAME] | 1241 | I Ingalls | 2001-07-05 00:00:00 | 2003-07-22 00:00:00 | 676.06 | 637.6 | 38.46 | S | VACMB | 1548.5 | 80 | 40 | 19.35625 | 744.441375 | 0.9615 | 6.983561643835617 | 120 | 3 | -81.53999999999999 | -2.0385 | <1 | [NAME] | 0.3287671232876712 | #N/A | #N/A | #N/A | July | #N/A
333 | [NAME] | 1242 | J Jackson | 1994-03-14 00:00:00 | 1986-02-25 00:00:00 | 1617.56 | 1572.6 | 44.96 | S | VACMB | 2122.7692 | 80 | 40 | 26.534615 | 1192.9962904 | 1.124 | 24.3972602739726 | 200 | 5 | -155.04 | -3.876 | <1 | [NAME] | 0.547945205479452 | #N/A | #N/A | #N/A | February | #N/A
222 | [NAME] | 1243 | K Kracker | 1991-05-27 00:00:00 |  | 1381.34 | 1328 | 53.34 | S | VACMB | 2399.42 | 80 | 40 | 29.99275 | 1599.813285 | 1.3335 | 19.14520547945206 | 160 | 4 | -106.66 | -2.6665 | <1 | [NAME] | 0.4383561643835616 | #N/A | #N/A | #N/A | May | #N/A
444 | [NAME] | 1244 | L Lyons | 2001-06-05 00:00:00 |  | 735.3 | 705.26 | 30.04 | S | LEAVE | 1095.04 | 65 | 32.5 | 16.8467692307692 | 506.076947692308 | 0.924307692307692 | 9.112328767123287 | LEAVE | LEAVE | LEAVE | LEAVE | LEAVE | [NAME] | N/A | N/A | N/A | 10+ | June | #N/A
555 | [NAME] | 1245 | M Martens | 1998-07-21 00:00:00 |  | 1111.82 | 786.2 | 325.62 | H | VACMB | 13.13 | 80 | 40 | 13.13 | 4275.3906 | 8.1405 | 11.98904109589041 | 160 | 4 | 165.62 | 4.140499999999999 | 4-6 | [NAME] | 0.4383561643835616 | #N/A | #N/A | #N/A | July | #N/A
111 | [NAME] | 1246 | N Nichols | 2000-02-10 00:00:00 |  | 1027.3 | 872 | 155.3 | H | VACMB | 13.13 | 80 | 40 | 13.13 | 2039.089 | 3.8825 | 10.43013698630137 | 160 | 4 | -4.699999999999989 | -0.1175000000000002 | <1 | [NAME] | 0.4383561643835616 | #N/A | #N/A | #N/A | February | #N/A
222 | [NAME] | 1247 | O Oscor | 1995-06-12 00:00:00 |  | 1294.54 | 1185.8 | 108.74 | H | VACMB | 15.64 | 80 | 40 | 15.64 | 1700.6936 | 2.7185 | 15.0986301369863 | 160 | 4 | -51.26000000000001 | -1.2815 | <1 | [NAME] | 0.4383561643835616 | #N/A | #N/A | #N/A | June | #N/A
555 | [NAME] | 1248 | P Peters | 2000-01-03 00:00:00 |  | 1059.3 | 916 | 143.3 | S | VMB03 | 2765.14 | 80 | 40 | 34.56425 | 4953.057025 | 3.5825 | 10.53424657534247 | 160 | 4 | -16.69999999999999 | -0.4175 | <1 | [NAME] | 0.4383561643835616 | #N/A | #N/A | #N/A | January | #N/A
444 | [NAME] | 1249 | R Randall | 1995-09-27 00:00:00 |  | 1295.22 | 1151.1 | 144.12 | H | VACMB | 15.64 | 80 | 40 | 15.64 | 2254.0368 | 3.603 | 14.80547945205479 | 160 | 4 | -15.88 | -0.3969999999999998 | <1 | [NAME] | 0.4383561643835616 | #N/A | #N/A | #N/A | September | #N/A
333 | [NAME] | 1250 | S Smith | 1992-05-11 00:00:00 |  | 1332.72 | 1144.7 | 188.02 | H | VACMB | 15.64 | 80 | 40 | 15.64 | 2940.6328 | 4.7005 | 18.18630136986301 | 160 | 4 | 28.02000000000001 | 0.7004999999999999 | <1 | [NAME] | 0.4383561643835616 | #N/A | #N/A | #N/A | May | #N/A
444 | [NAME] | 1251 | T Thompson | 1998-11-04 00:00:00 |  | 1149.24 | 943.8 | 205.44 | H | VACMB | 15.64 | 80 | 40 | 15.64 | 3213.0816 | 5.136 | 11.6986301369863 | 160 | 4 | 45.44 | 1.136 | 1-2 | [NAME] | 0.4383561643835616 | #N/A | #N/A | #N/A | November | #N/A