{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Daily Striping Report","Lists"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":15,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Daily Striping Report","index":0,"n_rows":44,"n_cols":26,"rows_kept":44,"cut":false,"hidden":false,"merged":[[33,1,33,3],[32,1,32,3],[31,1,31,3],[30,1,30,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[5,1,5,2],[1,0,1,14],[2,1,2,2],[2,12,2,13],[3,1,3,2],[4,1,4,2],[13,1,13,3],[6,1,6,2],[7,1,7,2],[7,8,7,9],[8,1,8,2],[8,8,8,9],[9,1,9,2],[9,8,9,9],[10,1,10,2],[10,8,10,9],[11,1,11,2],[11,8,11,9],[12,0,12,14],[14,1,14,3],[15,1,15,3],[23,1,23,3],[21,1,21,3],[22,1,22,3],[20,1,20,3],[19,1,19,3],[18,1,18,3],[17,1,17,3],[16,1,16,3],[41,5,42,14],[37,1,37,3],[38,1,38,4],[38,5,38,14],[39,1,39,4],[39,5,40,6],[39,11,40,11],[39,14,40,14],[40,1,40,4],[41,0,42,0],[41,1,42,4],[34,1,34,3],[35,1,35,3],[36,1,36,3]]}
["Daily Striping Report",null,null,null,null,null,null,{"$f":"MATCH(\"JANE\",J15:J44,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5280]
["Contractor & District Information"]
["DISTRICT",null,null,null,"CONTRACTOR","[Name]"]
["CONTACT",null,null,null,null,"[Mailing Address]"]
["PROJECT TYPE:",null,null,null,null,"[City, ST ZIP CODE]"]
["FUNDING STRIP:",null,null,null,null,"[Phone]"]
["CONTRACT ID:",null,null,null,null,"[Fax]"]
["APPLICATION DATE:","2011-01-12",null,null,null,"[E-Mail Address]"]
["APPLICATION TYPE:",null,null,null,null,"[Crew Name/No.]"]
["FIRST DAY TO TEST:",{"$f":"IF(OR(B8=\"\",B9=\"Temporary\"),\"\",IF(A40=\"Thermoplastic\",B8+150,B8+30))","v":"2011-02-11"},null,null,null,"[Driver]"]
["LAST DAY TO TEST:",{"$f":"IF(OR(B8=\"\",B9=\"Temporary\"),\"\",IF(A40=\"Thermoplastic\",B8+210,B8+60))","v":"2011-03-13"},null,null,null,"[Striping Truck]"]
["SECTION STATUS:","ACCEPT",null,null,null,"[Comment]"]
["Route Information"]
["County","Route",null,null,"Direction","Color","Width","Line Type","Starting \nMilepoint","Ending \nMilepoint","Striped Line Length (Feet)","Route Length (Feet)","Route Type","Mobile     (KM 203)?","Corrective Re-stripe?"]
["","",null,null,"","","","","","","",{"$f":"IF(OR(I15=\"\",J15=\"\"),\"\",ABS(J15-I15)*$Z$1)","v":""},"","","",{"$f":"IF(AND(F15=\"White\",G15=4,M15=\"MP\"),K15,0)","v":0},{"$f":"IF(AND(F15=\"Yellow\",G15=4,M15=\"MP\"),K15,0)","v":0},{"$f":"IF(AND(F15=\"White\",G15=6,M15=\"MP\"),K15,0)","v":0},{"$f":"IF(AND(F15=\"Yellow\",G15=6,M15=\"MP\"),K15,0)","v":0},{"$f":"IF(AND(F15=\"White\",G15=4,M15=\"RS\"),K15,0)","v":0},{"$f":"IF(AND(F15=\"Yellow\",G15=4,M15=\"RS\"),K15,0)","v":0}]
["","",null,null,"","","","","","","",{"$f":"IF(OR(I16=\"\",J16=\"\"),\"\",ABS(J16-I16)*$Z$1)","v":""},"","","",{"$f":"IF(AND(F16=\"White\",G16=4,M16=\"MP\"),K16,0)","v":0},{"$f":"IF(AND(F16=\"Yellow\",G16=4,M16=\"MP\"),K16,0)","v":0},{"$f":"IF(AND(F16=\"White\",G16=6,M16=\"MP\"),K16,0)","v":0},{"$f":"IF(AND(F16=\"Yellow\",G16=6,M16=\"MP\"),K16,0)","v":0},{"$f":"IF(AND(F16=\"White\",G16=4,M16=\"RS\"),K16,0)","v":0},{"$f":"IF(AND(F16=\"Yellow\",G16=4,M16=\"RS\"),K16,0)","v":0}]
["","",null,null,"","","","","","","","","","","",{"$f":"IF(AND(F17=\"White\",G17=4,M17=\"MP\"),K17,0)","v":0},{"$f":"IF(AND(F17=\"Yellow\",G17=4,M17=\"MP\"),K17,0)","v":0},{"$f":"IF(AND(F17=\"White\",G17=6,M17=\"MP\"),K17,0)","v":0},{"$f":"IF(AND(F17=\"Yellow\",G17=6,M17=\"MP\"),K17,0)","v":0},{"$f":"IF(AND(F17=\"White\",G17=4,M17=\"RS\"),K17,0)","v":0},{"$f":"IF(AND(F17=\"Yellow\",G17=4,M17=\"RS\"),K17,0)","v":0}]
["","",null,null,"","","","","","","","","","","",{"$f":"IF(AND(F18=\"White\",G18=4,M18=\"MP\"),K18,0)","v":0},{"$f":"IF(AND(F18=\"Yellow\",G18=4,M18=\"MP\"),K18,0)","v":0},{"$f":"IF(AND(F18=\"White\",G18=6,M18=\"MP\"),K18,0)","v":0},{"$f":"IF(AND(F18=\"Yellow\",G18=6,M18=\"MP\"),K18,0)","v":0},{"$f":"IF(AND(F18=\"White\",G18=4,M18=\"RS\"),K18,0)","v":0},{"$f":"IF(AND(F18=\"Yellow\",G18=4,M18=\"RS\"),K18,0)","v":0}]
["","",null,null,"","","","","","","","","","","",{"$f":"IF(AND(F19=\"White\",G19=4,M19=\"MP\"),K19,0)","v":0},{"$f":"IF(AND(F19=\"Yellow\",G19=4,M19=\"MP\"),K19,0)","v":0},{"$f":"IF(AND(F19=\"White\",G19=6,M19=\"MP\"),K19,0)","v":0},{"$f":"IF(AND(F19=\"Yellow\",G19=6,M19=\"MP\"),K19,0)","v":0},{"$f":"IF(AND(F19=\"White\",G19=4,M19=\"RS\"),K19,0)","v":0},{"$f":"IF(AND(F19=\"Yellow\",G19=4,M19=\"RS\"),K19,0)","v":0}]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["","",null,null,"","","","","","","","","","","",0,0,0,0,0,0]
["Materials","Comments",null,null,null,"Totals Summary",null,null,null,null,null,null,null,null,null,{"$f":"SUM(P15:P38)","v":0},0,0,0,0,0]
[null,null,null,null,null,"Striped Line Length (Feet)",null,"MP 4\" W","MP 4\" Y","MP 6\" W","MP 6\" Y",null,"RS 4\" W","RS 4\" Y"]
[null,null,null,null,null,null,null,{"$f":"IF($P39=0,\"\",$P39)","v":""},{"$f":"IF($Q39=0,\"\",$Q39)","v":""},{"$f":"IF($R39=0,\"\",$R39)","v":""},{"$f":"IF($S39=0,\"\",$S39)","v":""},null,{"$f":"IF($T39=0,\"\",$T39)","v":""},{"$f":"IF($U39=0,\"\",$U39)","v":""}]
["Beads"]
[]
["To request measurement of retroreflectivity in accordance with KM203, please email all correspondence to brandi.mitchell@ky.gov.  Please notify Central Office at least two (2) weeks in advance of when mobile testing is needed."]

{"sheet":"Lists","index":1,"n_rows":30,"n_cols":26,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[1,null,"District Wide Striping","North","YELLOW",4,"CL","Permanent","Yes","MP","ACCEPT",null,"ACCEPT AT 70% PAY",null,"District 1","District 2","District 3","District 4","District 5","District 6","District 7","District 8","District 9","District 10","District 11","District 12"]
[2,"Yellow WB Traffic Paint","Rehabilitation / Resurfacing","South","WHITE",6,"EL","Temporary","No","RS","ACCEPT WITH DEDUCTION",null,"ACCEPT AT 100% PAY",null,"BALLARD","CALDWELL","ALLEN","BRECKINRIDGE","BULLITT","BOONE","ANDERSON","ADAIR","BATH","BREATHITT","BELL","FLOYD"]
[3,"Yellow Hi-Build WB Traffic Paint",null,"East",null,8,"LL",null,null,null,"FAIL",null,"FAIL",null,"CALLOWAY","CHRISTIAN","BARREN","GRAYSON","FRANKLIN","BRACKEN","BOURBON","CASEY","BOYD","ESTILL","CLAY","JOHNSON"]
[4,"Yellow Thermoplastic",null,"West",null,12,"SK",null,null,null,null,null,null,null,"CARLISLE","DAVIESS","BUTLER","GREEN","HENRY","CAMPBELL","BOYLE","CLINTON","CARTER","LEE","HARLAN","KNOTT"]
[5,null,null,null,null,null,"GM",null,null,null,null,null,null,null,"CRITTENDEN","HANCOCK","EDMONSON","HARDIN","JEFFERSON","CARROLL","CLARK","CUMBERLAND","ELLIOTT","MAGOFFIN","JACKSON","LAWRENCE"]
[6,null,null,null,null,null,"DTLE",null,null,null,null,null,null,null,"FULTON","HENDERSON","LOGAN","HART","OLDHAM","GALLATIN","FAYETTE","LINCOLN","FLEMING","MENIFEE","KNOX","LETCHER"]
[7,"White WB Traffic Paint",null,null,null,null,null,null,null,null,null,null,null,null,"GRAVES","HOPKINS","METCALFE","LARUE","SHELBY","GRANT","GARRARD","McCREARY","GREENUP","MORGAN","LAUREL","MARTIN"]
[8,"White Hi-Build WB Traffic Paint",null,null,null,null,null,null,null,null,null,null,null,null,"HICKMAN","McLEAN","MONROE","MARION","SPENCER","HARRISON","JESSAMINE","PULASKI","LEWIS","OWSLEY","LESLIE","PIKE"]
[9,"White Thermoplastic",null,null,null,null,null,null,null,null,null,null,null,null,"LIVINGSTON","MUHLENBERG","SIMPSON","MEADE","TRIMBLE","KENTON","MADISON","ROCKCASTLE","MASON","PERRY","WHITLEY"]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,"LYON","OHIO","TODD","NELSON","","OWEN","MERCER","RUSSELL","NICHOLAS","POWELL",""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,"MARSHALL","UNION","WARREN","TAYLOR","","PENDLETON","MONTGOMERY","WAYNE","ROWAN","WOLFE",""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,"McCRACKEN","WEBSTER","","WASHINGTON","","ROBERTSON","SCOTT","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRIGG",null,null,null,null,null,"WOODFORD","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Click the 'Calculate' button after entering all Route Information above."]