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

Callout: |  |  | City of Kirksville, Missouri
 |  |  | Public Works Department
Date: 09/11/2015 |  |  | Street Maintenance Work Order |  |  |  |  |  |  |  |  | [NAME] Plowed:
Location / Address: | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | 7
Job Description: | Repair road from storm damage
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] | 3 | 26.14 | 78.42 |  |  | 39.21 | 0 | 251 | 3 | 45 | 135 |  | 213.42
[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] |  | 20.89 | 0 |  |  | 31.335 | 0 |  |  |  | 0 |  | 0
[NAME] | 8 | 20.89 | 167.12 |  |  | 31.335 | 0 | 328 | 4 | 22 | 88 |  | 255.12
[NAME] |  | 19.6 | 0 |  |  | 29.4 | 0 |  |  |  | 0 |  | 0
[NAME] | 8 | 26.88 | 215.04 |  |  | 40.32 | 0 | 308 | 8 | 40 | 320 |  | 535.04
[NAME] |  | 22.18 | 0 |  |  | 33.27 | 0 |  |  |  | 0 |  | 0
[NAME] | 3 | 17.12 | 51.36 |  |  | 25.68 | 0 | 272 | 3 | 45 | 135 |  | 186.36
[NAME] |  | 17.12 | 0 |  |  | 25.68 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 17.12 | 0 |  |  | 25.68 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 21.94 | 0 |  |  | 32.91 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 22.83 | 0 |  |  | 34.245 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 17.12 | 0 |  |  | 25.68 | 0 |  |  |  | 0 |  | 0
[NAME] | 3 | 17.12 | 51.36 |  |  | 25.68 | 0 | 276 | 3 | 65 | 195 |  | 246.36
[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] | 3 | 17.12 | 51.36 |  |  | 25.68 | 0 | 263 | 3 | 65 | 195 |  | 246.36
[NAME] |  | 20.5 | 0 |  |  | 30.75 | 0 |  |  |  | 0 |  | 0
[NAME] |  | 23.46 | 0 |  |  | 35.19 | 0 |  |  |  | 0 |  | 0
Justin Osborn |  | 23.18 | 0 |  |  | 34.77 | 0 |  |  |  | 0 |  | 0
Total Hours: | 28 | Hour Cost | 614.6600000000001 | Total OT Hours: | 0 | OT Cost: | 0 | Total Equip. Hours: | 24 | Total Equip. Cost: | 1068
 |  | Reg. [NAME]): | 311.878484 |  |  | OT Fringe Benefits(.1972): | 0 |  | Total Labor Cost: | 614.6600000000001 | Total Hours: |  | 28
 |  | Total Hour Cost: | 614.6600000000001 |  |  | Total OT Cost: | 0 |  |  |  | Grand Total(Hours + Equip): |  | 1682.66
Description of Materials |  |  |  |  |  |  |  |  | Quantity |  | Unit Cost |  | Total Amount
1" 1/4 rock |  |  |  |  |  |  |  |  | 80 |  | 13.45 |  | 1076
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | Total Material Cost: | 1076
Vehicle # & Description |  |  |  |  |  | CY |  | HP |  | Cost Code |  |  | Amount
#201/235/242 - 2 Ton Dump |  |  |  |  |  | 10 CY |  | 250 |  | 8721 |  |  | 56.5
#240/241/249/254/290 - 1½ Ton Truck |  |  |  |  |  | 10 CY |  | 300 |  | 8721 |  |  | 56.5
#243/245/247/262 - 1 Ton Pick-Up |  |  |  |  |  |  |  |  |  | 8804 |  |  | 29.75
#251/257/258/272 - 2 Ton Dump |  |  |  |  |  | 10 CY |  | 250 |  | 8721 |  |  | 56.5
#253/263/276/276 - Tandem Dump |  |  |  |  |  | 18 CY |  | 400 |  | 8723 |  |  | 77.25
#305 Pavement Roller |  |  |  |  |  |  |  | 45 |  | 8221 |  |  | 17.5
#309 - Motor Grader |  |  |  |  |  |  |  | 150 |  | 8331 |  |  | 58
#314 - Tractor |  |  |  |  |  |  |  | 80 |  | 8401 |  |  | 25
#316/319/331 - Backhoe |  |  |  |  |  | 1.5 CY |  | 90 |  | 8572 |  |  | 33
#338 Asphalt Paver (towed) |  |  |  |  |  |  |  |  |  | 8430 |  |  | 8
#321/341 - Wheel Loader |  |  |  |  |  | 3 CY |  | 134 |  | 8393 |  |  | 40
#327/328/342 - Skid Loader |  |  |  |  |  | 1.5 CY |  | 90 |  | 8542 |  |  | 26.5
#348/355 - Skid Loader |  |  |  |  |  | 2 CY |  | 90 |  | 8573 |  |  | 43.75
#441 Concrete Saw |  |  |  |  |  |  |  |  |  | 8511 |  |  | 13.5
Written By: | Ray Sandstrom |  |  |  |  |  |  |  | Total Cost of Project: | 2758.66