Spreadsheet: 456276d1460728178-vlookup-formula-not-returning-a-value-storm-june-2015
Sheet: Storm Totals

City of Kirksville, Missouri
Public Works Department
Street Maintenance Work Order
Date: 06/22/2015 - 9/11/2015 |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 51
Job Description: | Storm Clean-up, brush pick-up from storm, street repairs & road tube cleaning
Employee's Names | Hours | Rate | Hour Cost | OT Hours |  | Rate | OT Hours Cost | Equip. Used | Equip. Hours | Equip. Rate | Equip. Cost |  | Total Amount
[NAME] |  | 23.47 | 0 |  |  | 35.205 | 0 |  |  |  | 0 |  | 0
[NAME] | 35 | 26.14 | 914.9 | 2 |  | 39.21 | 78.42 |  | 30 | Varies | 1369.5 |  | 2362.82
[NAME] |  | 25.4 | 0 |  |  | 38.09999999999999 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 22.18 | 0 |  |  | 33.27 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 25.4 | 0 |  |  | 38.09999999999999 | 0 |  |  |  | 0 |  | 0
[NAME] | 13 | 20.89 | 271.57 |  |  | 31.335 | 0 |  | 8 |  | 802.5 |  | 1074.07
[NAME] | 48 | 20.89 | 1002.72 |  |  | 31.335 | 0 |  | 25 |  | 1627.25 |  | 2629.97
[NAME] | 34 | 19.6 | 666.4000000000001 |  |  | 29.4 | 0 |  | 24 |  | 1276 |  | 1942.4
[NAME] | 54 | 26.88 | 1451.52 |  |  | 40.32 | 0 |  | 24 |  | 1579.25 |  | 3030.77
[NAME] |  | 22.18 | 0 | 2 |  | 33.27 | 66.53999999999999 |  | 3 |  | 81.4 |  | 147.94
 |  |  |  |  |  |  |  |  | 1 |  | 37.5 |  | 37.5
[NAME] | 23 | 17.12 | 393.76 |  |  | 25.68 | 0 |  | 8 |  | 422 |  | 815.76
[NAME] |  | 17.12 | 0 | 2 |  | 25.68 | 51.36 |  |  |  | 0 |  | 51.36
[NAME] |  | 17.12 | 0 |  |  | 25.68 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 21.2 | 0 |  |  | 31.8 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 22.83 | 0 |  |  | 34.245 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 17.12 | 0 |  |  | 25.68 | 0 |  |  |  | 0 |  | 0
[NAME] | 33 | 17.12 | 564.96 |  |  | 25.68 | 0 |  | 30 |  | 1745 |  | 2309.96
[NAME] |  | 17.12 | 0 |  |  | 25.68 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 20.13 | 0 |  |  | 30.195 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 19.38 | 0 |  |  | 29.07 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 20.5 | 0 |  |  | 30.75 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 21.94 | 0 |  |  | 32.91 | 0 |  |  |  | 0 |  | 0
[NAME] | 27 | 17.12 | 462.24 |  |  | 25.68 | 0 |  | 11 |  | 682.5 |  | 1144.74
[NAME] |  | 20.5 | 0 |  |  | 30.75 | 0 |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
[NAME] |  | 23.46 | 0 |  |  | 35.19 | 0 |  |  |  | 0 |  | 0
Justin Osborn |  | 23.18 | 0 |  |  | 34.77 | 0 |  |  |  | 0 |  | 0
Total Hours: | 267 | Hour Cost | 5728.070000000001 | Total OT Hours: | 6 | OT Cost: | 196.32 | Total Equip. Hours: | 164 | Total Equip. Cost: | 9622.9
 |  | [NAME]. [NAME]): | 2979.169207 |  |  | OT Fringe Benefits(.2128): | 41.77689599999999 |  | Total Labor Cost: | 5924.39 | Total Hours: |  | 273
 |  | Total Hour Cost: | 5728.070000000001 |  |  | Total OT Cost: | 196.32 |  |  |  | Grand Total(Hours + Equip): |  | 15547.29
Description of Materials |  |  |  |  |  |  |  |  | Quantity |  | Unit Cost |  | Total Amount
Cold Mix Asphalt |  |  |  |  |  |  |  |  | 2 |  | 120 | 240
CRS2 Patching Oil |  |  |  |  |  |  |  |  | 400 |  | 2.55 | 1020
[NAME] washed 3/8" rock |  |  |  |  |  |  |  |  | 14 |  | 10 | 140
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | Total Material Cost: | 1400
Vehicle # & Description |  |  |  |  |  | CY |  | HP |  | Cost Code |  |  | Amount
201/235/242 - 2 Ton Dump |  |  |  |  |  | 10 CY |  | 250 |  | 8721 |  |  | 45
240/241/290 - 1½ Ton Truck |  |  |  |  |  | 10 CY |  | 300 |  | 8721 |  |  | 25
231/236/243/245/248/250/262 - 1 Ton Pick-Up |  |  |  |  |  |  |  |  |  | 8804 |  |  | 20
235/242/257/258/272 - 2 Ton Dump |  |  |  |  |  | 10 CY |  | 250 |  | 8721 |  |  | 45
253/263/276 - Tandem Dump |  |  |  |  |  | 18 CY |  | 400 |  | 8723 |  |  | 65
222/273 - Hi [NAME] (1¾ ton w/aerial lift) |  |  |  |  |  |  |  |  |  | 8487/8805 |  |  | 42.25
308 - Crawler Dozer |  |  |  |  |  |  |  | 84 |  | 8251 |  |  | 40
309 - Motor Grader |  |  |  |  |  |  |  | 150 |  | 8331 |  |  | 58
302/317/330/334 - Tractor |  |  |  |  |  |  |  |  |  |  |  |  | 37.5
316/319/331 - Backhoe |  |  |  |  |  | 1.5 CY |  | 90 |  | 8572 |  |  | 33
321/341 - Wheel Loader |  |  |  |  |  | 3 CY |  | 134 |  | 8393 |  |  | 40
327/328/342/347/348 - Trackhoe Loader |  |  |  |  |  | 2 CY |  | 90 |  | 8573 |  |  | 22
Written By: | Ray Sandstrom |  |  |  |  |  |  |  | Total Cost of Project: | 16947.29