{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PECCD All","Variables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"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":"PECCD All","index":0,"n_rows":266,"n_cols":37,"rows_kept":266,"cut":false,"hidden":false,"merged":[[0,0,0,29],[1,0,1,29],[8,0,8,1],[7,0,7,1],[6,0,6,1],[5,0,5,1],[8,8,8,10],[5,11,5,14],[5,25,5,29],[7,25,7,29],[8,25,8,29],[8,11,8,14],[7,11,7,14],[6,11,6,14],[3,2,3,10],[3,11,3,14],[262,16,262,17],[5,15,5,22],[3,0,3,1],[9,11,9,14],[8,15,8,16],[257,0,257,29],[5,2,5,10],[6,2,6,10],[12,21,12,24],[11,0,11,29],[256,0,256,29],[255,0,255,29],[12,5,12,14],[8,2,8,5],[8,6,8,7],[9,16,9,17],[12,16,12,19],[8,21,8,22],[8,18,8,19],[259,0,259,29],[258,0,258,29],[9,18,9,19],[9,23,9,25],[9,26,9,29],[8,23,8,24],[9,20,9,22],[3,22,3,24],[3,25,3,29],[3,15,3,21],[5,23,5,24],[6,15,6,22],[7,15,7,22],[7,23,7,24],[6,23,6,29],[9,0,9,6],[9,7,9,10],[264,0,264,3],[263,0,263,3],[265,0,265,3],[265,4,265,9],[7,2,7,5],[7,6,7,7],[7,8,7,10],[262,0,262,3],[262,4,262,9],[262,10,262,15],[260,0,260,29],[262,18,262,23],[262,24,262,28],[265,24,265,28],[264,24,264,28],[263,24,263,28],[265,18,265,23],[264,18,264,23],[263,18,263,23],[265,12,265,15],[264,12,264,15],[263,12,263,15],[265,16,265,17],[264,16,264,17],[263,16,263,17],[265,10,265,11],[264,10,264,11],[263,10,263,11],[264,4,264,9],[263,4,263,9]]}
["STATE OF FLORIDA DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(P4,\"yyyymmdd\")&\"_\"&LEFT(C7,8)&\"_SR \"&I9&\"_\"&I8","v":"20240321_444612-1_SR 45_13010000"}]
["PAVEMENT EVALUATION CORING AND CONDITION DATA"]
[]
["Cored By:",null,"Ardaman & Associates, Inc.",null,null,null,null,null,null,null,null,"Coring Completion Date:",null,null,null,"2024-03-21",null,null,null,null,null,null,"Typical Section:",null,null,1]
[]
["W.P.I. No.:",null,null,null,null,null,null,null,null,null,null,"Name:",null,null,null,"SR 45 (US 41) ",null,null,null,null,null,null,null,"Lanes:",null,6]
["Fin. Proj. ID:",null,"444612-1-31-01",null,null,null,null,null,null,null,null,"From:",null,null,null,"EDWARDS DRIVE",null,null,null,null,null,null,null,"Shoulder Type and Condition:"]
["F.A. Project No.:",null,null,null,null,null,"Roadway ID:",null,"13010000",null,null,"To:",null,null,null,"MAGELLAN DRIVE",null,null,null,null,null,null,null,"Inside:",null,"None"]
["County:",null,"Manatee",null,null,null,"SR No.:",null,45,null,null,"Beg MP:",null,null,null,0,null,"End MP:",2.0950000000000002,null,"Length:",{"$f":"S9-P9","v":2.0950000000000002},null,"Outside:",null,"Paved / Curb"]
["Overall Pavement Condition (from DMO field review):",null,null,null,null,null,null,"Fair",null,null,null,"Median Curbed (Y/N):",null,null,null,"N","Paved",null,"Lawn",null,"Other:",null,null,"Curb & Gutter (Y/N):",null,null,"Y"]
[]
["All Cores"]
[null,null,null,null,null,"PAVEMENT LAYER (IN.)",null,null,null,null,null,null,null,null,null,null,"BASE",null,null,null,null,"CRACK"]
["CORE NO.","MILE POST2","LANE TYPE","LANE","WP\n(Y/N)","FC9.5","FC5","FC3","S","SP1C","S","SAHM","BIND",null,null,"TOTAL ASPHALT THICKNESS\n(IN.)","LR","CONC","ABC-2","SHEL","STABILIZED SUBGRADE 3","DEPTH (IN.)","TYPE","CLASS","EXTENT","PAVEMENT CONDITION","RUT DEPTH - LWP (IN.)","RUT DEPTH - RWP (IN.)","CROSS SLOPE (%)4","COMMENTS"]
[1,0.70499999999999996,"ML","R1","N",null,1,null,null,1.2,1.6,null,1.7,null,null,{"$f":"IF(A15=\"\",\"\",SUM(F15:O15))","v":5.5},6.9,null,null,null,12,3.2,"C","III","S","P",0.2,0.2,2.2000000000000002]
[2,1.635,"ML","R1","N",null,0.8,null,null,1.1000000000000001,1.6,null,0.8,null,null,4.3,7.6,null,null,null,12,4.3,"C","III","S","P",0.3,0.4,3.7,"Base is half LR half ABC-2"]
[3,0.06,"ML","R2","N",null,0.8,null,null,1.1000000000000001,0.9,null,1.2,null,null,4,8.6999999999999993,null,null,null,12,2.8,"C","III","M","P",0.1,0.1,3.1]
[4,1.052,"ML","R2","N",null,1,null,null,1.2,1.3,null,0.9,null,null,4.4000000000000004,9,null,null,null,12,3.4,"C","III","S","P",0.3,0.3,3.1]
[5,2.8000000000000001E-2,"ML","R3","Y",null,0.8,null,null,1.6,0.8,null,0.7,null,null,3.9000000000000004,7.1,null,null,null,12,3.2,"C","III","S","P",0.2,0.2,4.5999999999999996]
[6,1.66,"ML","R3","Y",null,1,null,null,1.5,1.1000000000000001,null,0.9,null,null,4.5,8.5,null,null,null,12,4.5,"C","III","S","P",0.2,0.2,3.9]
[7,0.19500000000000001,"ML","L1","N",null,0.9,null,null,1.6,2.5,null,null,null,null,5,null,null,4,null,12,3.8,"C","III","S","P",0.3,0.1,2.6]
[8,1.8959999999999999,"ML","L1","N",null,1,null,null,1.6,1.2,null,1,null,null,4.8,9.1,null,null,null,12,4.8,"B","III","S","P",0.2,0.3,2,"Base is half LR half CONC"]
[9,0.29699999999999999,"ML","L2","Y",null,0.8,null,null,1.6,1.3,null,0.9,null,null,4.6000000000000005,7.8,null,null,null,12,4.5999999999999996,"C","III","S","P",0.3,0.4,3]
[10,1.829,"ML","L2","Y",null,0.8,null,null,1.5,1.5,null,1.2,null,null,5,7.4,null,null,null,12,4.2,"C","III","S","P",0.3,0.2,3.4]
[11,0.746,"ML","L3","Y",null,0.7,null,null,1.6,0.8,null,0.9,null,null,3.9999999999999996,8.6,null,null,null,12,4,"B","III","S","P",0.3,0.1,4.5]
[12,1.954,"ML","L3","N",null,1,null,null,1.5,0.6,null,1.3,null,null,4.4000000000000004,7.3,null,null,null,12,3.8,"C","II","L","P",0.2,0.2,5.0999999999999996]
[13,2.8000000000000001E-2,"ML","R3","N",null,0.8,null,null,1.5,0.7,null,0.6,null,null,3.6,7.3,null,null,null,12,null,null,null,null,"P",0.2,0.2,4.5999999999999996]
[1,0.01,"ML","R3","Y",0.9,null,null,null,1,1.2,null,null,null,null,{"$f":"IF(A28=\"\",\"\",SUM(F28:O28))","v":3.0999999999999996},12,null,null,null,null,2.7,"C",2,"S","P",0.1,0.1,3.9]
[2,0.01,"ML","L3","Y",1.4,null,null,null,1.3,null,null,1.3,null,null,4,11.5,null,null,null,null,2.2000000000000002,"C",3,"S","P",0.1,0.1,2.9]
[3,0.04,"ML","R3","Y",null,0.7,null,null,2.6,null,null,0.7,null,null,4,17.5,null,null,null,null,2.8,"C",3,"M","F",0.1,0.1,5.3]
[4,0.70699999999999996,"ML","R3","Y",null,0.6,null,null,1.8,null,null,0.6,null,null,3,10.5,null,null,null,null,3,"C",3,"S","P",0.1,0.3,5,"Base Crack"]
[5,1.194,"ML","R3","Y",null,0.9,null,null,1.6,null,null,1.4,null,null,3.9,11.5,null,null,null,12.5,"---","---","---","---","F",0.1,0.1,4.0999999999999996]
[6,1.6519999999999999,"ML","R3","Y",null,1.1000000000000001,null,null,1.8,null,null,1.6,null,null,4.5,11,null,null,null,null,"---","---","---","---","F",0.2,0.1,4.0999999999999996]
[7,2.0859999999999999,"ML","R2","N",null,0.5,null,null,1.3,null,null,1.8,null,null,3.6,null,null,null,null,11.8,1.75,"C",3,"S","P",0.1,0.1,2.8,"Bridge Approach slab"]
[8,2.0859999999999999,"ML","L2","N",null,0.9,null,null,1.1000000000000001,null,null,null,null,null,2,null,null,null,null,null,"---","---","---","---","F",0.1,0.1,1.5,"Bridge Approach slab"]
[9,1.9530000000000001,"ML","L3","N",null,0.9,null,null,2.2999999999999998,null,null,1.2,null,null,4.3999999999999995,11.25,null,null,null,null,0.9,"C",2,"M","F",0.1,0.1,5.5]
[10,1.288,"ML","L3","Y",null,0.9,null,null,1.8,null,null,0.7,null,null,3.4000000000000004,11.5,null,null,null,null,3.4,"C",3,"S","P",0.2,0.1,4.3,"Base Crack"]
[11,0.98699999999999999,"ML","L3","Y",null,0.8,null,null,2.5,null,null,1.2,null,null,4.5,12.25,null,null,null,null,4.5,"C",3,"S","P",0.1,0,5.0999999999999996,"Base Crack"]
[12,0.39200000000000002,"ML","L3","Y",null,1,null,null,1.5,null,null,0.8,null,null,3.3,9.5,null,null,null,12.2,"---","---","---","---","F",0.1,0.1,3.3]
[13,7.0000000000000007E-2,"ML","R2","N",null,0.7,null,null,2.5,null,null,0.9,null,null,4.1000000000000005,8.1999999999999993,null,null,null,null,3,"C",2,"M","P",0.2,0,3.3,"Raveling"]
[14,0.502,"ML","R2","Y",null,1,null,null,2.2999999999999998,null,null,1.2,null,null,{"$f":"IF(A41=\"\",\"\",SUM(F41:O41))","v":4.5},7.5,null,null,null,null,"---","---","---","---","F",0.1,0.1,3.6,"Raveling"]
[15,1.0529999999999999,"ML","R2","N",null,0.9,null,null,2.4,null,null,1.1000000000000001,null,null,4.4000000000000004,11.5,null,null,null,null,2,"C",3,"S","P",0.1,0.1,3.4]
[16,1.851,"ML","R2","N",null,0.9,null,null,2.6,null,null,1.6,null,null,5.0999999999999996,7.4,null,null,null,null,5.0999999999999996,"C",3,"S","P",0.3,0.1,3.1,"Joint crack/Raveling/Base crack"]
[17,1.83,"ML","L2","Y",null,0.8,null,null,2.9,null,null,1.3,null,null,5,8.1,null,null,null,null,3.8,"C",3,"S","P",0.2,0.1,3.2]
[18,1.417,"ML","L2","N",null,1,null,null,3,null,null,1,null,null,5,8.4,null,null,null,null,5,"C",3,"S","P",0.4,0.1,3.3,"Base Crack"]
[19,0.60499999999999998,"ML","L2","N",null,0.8,null,null,2.2999999999999998,null,null,1.4,null,null,4.5,9,null,null,null,null,"---","---","---","---","F",0.3,0.3,3]
[20,0.308,"ML","L2","Y",null,0.9,null,null,2.8,null,null,1,null,null,4.6999999999999993,10.199999999999999,null,null,null,null,2.4,"C",3,"S","P",0.2,0.3,3.3]
[21,0.28499999999999998,"ML","R1","N",null,1,null,null,3.1,0.6,null,null,null,null,4.6999999999999993,12.8,null,null,null,11.5,4.7,"C",3,"S","P",0,0.3,3,"Base crack"]
[22,0.70499999999999996,"ML","R1","N",null,1.1000000000000001,null,null,2.9,null,null,1.5,null,null,5.5,8.6,null,null,null,null,2.1,"C",3,"S","P",0.1,0.1,1.4,"Raveling"]
[23,1.1040000000000001,"ML","R1","Y",null,0.8,null,null,3.7,null,null,null,null,null,4.5,null,null,4.7,null,null,"---","---","---","---","P",0.3,0.2,4.4000000000000004]
[24,1.81,"ML","R1","Y",null,0.8,null,null,3.4,null,null,null,null,null,4.2,null,null,3.1,null,null,"---","---","---","---","P",0.3,0.1,3.6,"Raveling"]
[25,2.0110000000000001,"ML","L1","Y",null,0.9,null,null,1.3,4.4000000000000004,null,null,null,null,6.6000000000000005,null,null,null,8.3000000000000007,11.7,"---","---","---","---","F",0.1,0.1,2.6]
[26,1.4590000000000001,"ML","L1","Y",null,0.9,null,null,2.1,4.5,null,null,null,null,7.5,10.1,null,null,null,null,"---","---","---","---","P",0.1,0.1,3.1,"Raveling, BOT of core broke of during extraction"]
[27,0.83499999999999996,"ML","L1","Y",null,0.8,null,null,1.8,1.6,null,null,null,null,4.2,9.75,null,null,null,null,5.0999999999999996,"C",3,"S","P",0.1,0.1,3.4]
[28,0.2,"ML","L1","N",null,0.9,null,null,2.2000000000000002,0.4,null,null,null,null,3.5,null,null,5.3,null,null,2.2999999999999998,"C",3,"S","P",0.3,0.2,2.9]
[29,1.48,"ML","R2","N",null,1.1000000000000001,null,null,1.9,0.6,null,1.7,null,null,5.3,7.75,null,null,null,null,5.25,"C",3,"S","P",0.1,0.1,2.7,"Joint crack/Raveling/Base crack"]
[30,0.54200000000000004,"TL/CO","R1","Y",null,1.1000000000000001,null,null,1.7,1.7,null,null,null,null,4.5,null,null,3,null,null,"---","---","---","---","F",0,0,"2..4"]
[31,0.56299999999999994,"SS","R1","N",null,1,null,null,1.5,null,null,null,null,null,2.5,11,null,null,null,null,"---","---","---","---","F",0,0,0.5,"Braden Ave"]
[32,0.64600000000000002,"SS","R1","N",null,0.5,null,null,2,null,null,null,null,null,2.5,null,null,null,12,null,"---","---","---","---","F",0,0.1,0.3,"Hernando Ave"]
[33,0.73599999999999999,"SS","R1","N",null,0.9,null,null,3.1,null,null,null,null,null,4,null,null,null,11.8,null,"---","---","---","---","F",0.2,0.2,0.3,"Suwanee Ave"]
[34,0.83499999999999996,"SS","R1","N",null,1,null,null,1.8,0.8,null,null,null,null,3.5999999999999996,13.5,null,null,null,null,"---","---","---","---","F",0.1,0,0.9,"Pinehurst St, Raveling"]
[35,1.2529999999999999,"SS","L1","Y",null,0.8,null,null,1.7,null,null,0.8,null,null,3.3,12.2,null,null,null,null,"---","---","---","---","F",0,0,0.7,"Ponce de Leon, Raveling"]
[36,1.357,"TL/CO","R1","Y",null,1.1000000000000001,null,null,1.4,1.5,null,null,null,null,4,null,null,4.0999999999999996,null,12.7,"---","---","---","---","F",0,0.4,2.8]
[37,1.3779999999999999,"SS","L1","N",null,null,0.5,3.2,null,null,null,null,null,null,3.7,6.5,null,null,null,null,3.7,"C",3,"M","P",0.5,0.6,0.5,"Tallevast St"]
[38,1.55,"TL/CO","R1","Y",null,0.4,null,null,2.2000000000000002,2.5,null,null,null,null,5.0999999999999996,null,null,3.5,null,null,"---","---","---","---","P",0.4,0.4,1.4,"Raveling Completely"]
[39,1.57,"SS","R1","N",null,null,0.8,0.8,null,null,1.3,null,null,null,2.9000000000000004,9.5,null,null,null,null,"---","---","---","---","F",0.1,0.1,1.7,"69th Ave"]
[40,1.72,"TL/CO","R1","Y",null,1,null,null,2.2999999999999998,null,null,null,null,null,3.3,null,null,5.8,null,null,0.5,"C",3,"S","P",0.3,0,2.4]
[41,1.73,"SS","L1","N",2,null,null,null,null,null,null,null,null,null,2,10.199999999999999,null,null,null,null,"---","---","---","---","G",0,0,1.6,"Pearl St, Left turn lane"]
[42,1.881,"SS","R1","N",null,0.7,null,3.5,null,null,null,null,null,null,4.2,9.75,null,null,null,null,4.2,"C",3,"M","F",0.1,0.1,3.1,"Montgomery Ave, Raveling"]
[43,1.95,"TL/CO","R1","Y",null,0.8,null,null,1.6,3.4,null,null,null,null,5.8000000000000007,null,null,null,14.75,null,3.2,"C",3,"M","F",0.1,0.3,2.2000000000000002]
[44,2.036,"TL/CO","R1","N",null,1,null,null,1.5,5.0999999999999996,null,null,null,null,7.6,null,null,null,12.5,null,"---","---","---","---","F",0.1,0,1.4]
[45,2.0579999999999998,"SS","R1","N",null,null,0.5,3.4,null,null,null,null,null,null,3.9,10.1,null,null,null,null,"---","---","---","---","F",0.1,0.1,1.9,"Magellan Dr, Raveling"]
[46,2.069,"TL/CO","L1","N",null,0.6,null,null,2,3.7,null,null,null,null,6.3000000000000007,null,null,null,17,12.3,"---","---","---","---","F",0.1,0.1,2.6]
[47,1.982,"TL/CO","L1","N",null,0.9,null,null,1.9,4.2,null,null,null,null,7,null,null,null,18,null,"---","---","---","---","F",0.1,0.1,2.8]
[48,1.883,"TL/CO","L1","N",null,0.9,null,null,2.1,1.8,null,2.6,null,null,7.4,null,null,null,12.5,null,0.75,"C",2,"M","F",0,0,2.9]
[49,1.7509999999999999,"TL/CO","L1","N",null,1,null,null,3.1,null,null,null,null,null,4.0999999999999996,null,null,4.7,null,null,2.2000000000000002,"C",3,"M","P",0,0.1,2.1]
[50,1.73,"SS","R1","N",1.4,null,null,null,1.4,null,null,null,null,null,2.8,11,null,null,null,null,"---","---","---","---","F",0.1,0.1,1.5,"Pearl st (west)"]
[51,1.59,"TL/CO","L1","Y",null,0.9,null,3.6,null,null,null,null,null,null,4.5,null,null,4.2,null,null,"---","---","---","---","F",0.1,0.1,2.1]
[52,1.57,"SS","R1","N",null,1,null,null,1.7,null,1.2,null,null,null,{"$f":"IF(A79=\"\",\"\",SUM(F79:O79))","v":3.9000000000000004},9.4,null,null,null,null,3.9,"C",3,"M","P",0.1,0,2.2999999999999998,"Whitfield (west), Raveling"]
[53,1.399,"TL/CO","L1","Y",null,0.8,null,null,1.6,1.3,null,null,null,null,3.7,null,null,6.8,null,null,"---","---","---","---","P",0.1,0.2,3.3]
[54,1.3779999999999999,"SS","R1","Y",null,0.8,null,null,2.2999999999999998,null,1.4,null,null,null,4.5,9.5,null,null,null,null,"---","---","---","---","F",0,0,2.8,"Gaines (west) top of core damaged retrieving"]
[55,1.1040000000000001,"SS","L1","N",null,0.9,null,null,1.3,null,null,2.7,null,null,4.9000000000000004,12.8,null,null,null,11.2,"---","---","---","---","F",0,0.1,0.7,"Westmoreland (west)"]
[56,1.083,"SS","R1","N",null,null,0.8,1.9,null,null,null,null,null,null,2.7,11.5,null,null,null,null,"---","---","---","---","F",0,0.1,1.4,"Westmoreland (west)"]
[57,1.0229999999999999,"SS","L1","N",null,2.5,null,1.5,null,null,null,null,null,null,4,9.6999999999999993,null,null,null,null,"---","---","---","---","F",0.1,0.2,1.4,"Scott Ave (west), Raveling"]
[58,0.93500000000000005,"SS","R1","N",null,0.8,null,null,1.5,null,null,0.7,null,null,3,9.5,null,null,null,null,"---","---","---","---","F",0,0,0.5,"Benard Ave (west)"]
[59,0.83499999999999996,"SS","L1","N",null,1,null,null,2.6,null,null,null,null,null,3.6,10.199999999999999,null,null,null,null,"---","---","---","---","F",0,0.1,1,"Somerset (west), Raveling"]
[60,0.73599999999999999,"SS","L1","N",null,0.9,null,null,1.7,null,null,1.7,null,null,4.3,9.3000000000000007,null,null,null,null,2.6,"C",3,"S","P",0,0,1.2,"Suwanee Ave (west), Raveling"]
[61,0.64600000000000002,"SS","L1","Y",null,0.9,null,null,2,null,null,1,null,null,3.9,9.5,null,null,null,null,"---","---","---","---","P",0.1,0.3,1.8,"Hernando (west), Raveling"]
[62,0.58499999999999996,"TL/CO","L1","N",null,0.8,null,null,1.9,0.8,null,2,null,null,5.5,9,null,null,null,null,5.5,"C",3,"S","P",0,0,2.2999999999999998,"Base Crack"]
[63,0.56299999999999994,"SS","L1","N",null,0.9,null,null,1.9,2.5,null,null,null,null,5.3,null,null,null,10.3,null,"---","---","---","---","F",0.1,0.1,1.8,"Braden Ave"]
[64,0.32900000000000001,"TL/CO","L3","N",null,0.6,null,null,1.8,7.4,null,null,null,null,9.8000000000000007,13.5,null,null,null,null,"---","---","---","---","F",0,0,1.5]
[65,0.246,"TL/CO","L3","Y",null,0.9,null,3.7,null,null,null,null,null,null,4.6000000000000005,null,null,null,null,null,"---","---","---","---","F",0,0.1,2]
[66,0.17,"TL/CO","L3","Y",null,1,null,null,3,1.3,null,null,null,null,5.3,null,null,10.3,null,null,"---","---","---","---","F",0.1,0.1,2]
[67,0.15,"SS","L1","N",null,0.6,null,null,1.3,2,null,null,null,null,3.9,null,null,10.6,null,null,"---","---","---","---","F",0.2,0.1,0.6,"Seagate, Raveling"]
[68,0,"SS","L1","Y",null,1.2,null,2.9,null,null,null,null,null,null,4.0999999999999996,12,null,null,null,null,"---","---","---","---","F",0.1,0.1,1.1000000000000001,"Edwards Dr., Core sheared off and broke apart"]
[69,0.09,"TL/CO","L1","Y",null,0.8,null,null,1.2,1.9,null,null,null,null,3.9,null,null,4.5999999999999996,null,null,"---","---","---","---","F",0,0.1,2.8]
[70,0.374,"TL/CO","L1","N",null,1.1000000000000001,null,2.4,null,null,null,null,null,null,3.5,null,null,4.0999999999999996,null,12.5,"---","---","---","---","F",0,0,2.2000000000000002]
[71,0.98699999999999999,"TL/CO","L1","N",null,1.1000000000000001,null,null,2,1,null,null,null,null,4.0999999999999996,null,null,4.5,null,null,1.1000000000000001,"C",3,"M","P",0.1,0.1,2.9]
[72,1.65,"TL/CO","L1","Y",null,0.9,null,null,1.5,2.2999999999999998,null,null,null,null,4.6999999999999993,null,null,5.8,null,null,"---","---","---","---","F",0,0.1,0.5]
[73,1.881,"TL/CO","L1","N",null,1.5,null,null,1.5,1.1000000000000001,null,1.7,null,null,5.8,null,7.7,null,null,null,"---","---","---","---","F",0,0.1,2,"Concrete Base"]
[74,1.962,"TL/CO","L1","N",null,0.9,null,null,1.6,3,null,null,null,null,5.5,null,null,null,17,null,"---","---","---","---","F",0.1,0.1,1.5]
[75,2.0579999999999998,"TL/CO","L1","N",null,0.3,null,null,1.5,3.7,null,null,null,null,5.5,null,null,null,17.5,null,"---","---","---","---","F",0,0.2,0.7]
[76,1.9910000000000001,"ML","R1","N",null,0.8,null,null,1.8,0.9,null,1.5,null,null,5,null,null,null,9,null,2.4,"C",3,"M","P",0.1,0.2,2.8,"Raveling"]
[77,1.88,"ML","L3","Y",null,0.9,null,null,2.4,null,null,1,null,null,4.3,12,null,null,null,null,4.3,"C",3,"S","P",0.2,0.2,3.8,"Base Crack"]
[78,0.15,"S","OR","N",null,1,null,null,1.5,null,null,1.4,null,null,3.9,13.25,null,null,null,null,"---","---","---","---","F","---","---",4.3]
[79,0.51,"S","OL","N",null,1,null,null,1.4,null,null,1.5,null,null,3.9,12,null,null,null,null,"---","---","---","---","F","---","---",3.7]
[80,1.194,"S","OR","N",null,1,null,null,1.5,null,null,1.4,null,null,3.9,11.25,null,null,null,null,"---","---","---","---","F","---","---",3.7]
[81,1.76,"S","OL","N",null,1.1000000000000001,null,null,1.2,1.1000000000000001,null,null,null,null,3.4,11.5,null,null,null,null,"---","---","---","---","F","---","---",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A143=\"\",\"\",SUM(F143:O143))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A207=\"\",\"\",SUM(F207:O207))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
["AVERAGE",null,null,null,null,{"$f":"IF(SUBTOTAL(2,'PECCD All'!F$15:F$248)=0,\"\",SUBTOTAL(1,'PECCD All'!F$15:F$248))","v":1.4249999999999998},{"$f":"IF(SUBTOTAL(2,'PECCD All'!G$15:G$248)=0,\"\",SUBTOTAL(1,'PECCD All'!G$15:G$248))","v":0.90232558139534846},{"$f":"IF(SUBTOTAL(2,'PECCD All'!H$15:H$248)=0,\"\",SUBTOTAL(1,'PECCD All'!H$15:H$248))","v":0.65},{"$f":"IF(SUBTOTAL(2,'PECCD All'!I$15:I$248)=0,\"\",SUBTOTAL(1,'PECCD All'!I$15:I$248))","v":2.6899999999999995},{"$f":"IF(SUBTOTAL(2,'PECCD All'!J$15:J$248)=0,\"\",SUBTOTAL(1,'PECCD All'!J$15:J$248))","v":1.8963855421686748},{"$f":"IF(SUBTOTAL(2,'PECCD All'!K$15:K$248)=0,\"\",SUBTOTAL(1,'PECCD All'!K$15:K$248))","v":1.9581395348837209},{"$f":"IF(SUBTOTAL(2,'PECCD All'!L$15:L$248)=0,\"\",SUBTOTAL(1,'PECCD All'!L$15:L$248))","v":1.3},{"$f":"IF(SUBTOTAL(2,'PECCD All'!M$15:M$248)=0,\"\",SUBTOTAL(1,'PECCD All'!M$15:M$248))","v":1.246666666666667},{"$f":"IF(SUBTOTAL(2,'PECCD All'!N$15:N$248)=0,\"\",SUBTOTAL(1,'PECCD All'!N$15:N$248))","v":""},{"$f":"IF(SUBTOTAL(2,'PECCD All'!O$15:O$248)=0,\"\",SUBTOTAL(1,'PECCD All'!O$15:O$248))","v":""},{"$f":"IF(SUBTOTAL(2,'PECCD All'!P$15:P$248)=0,\"\",SUBTOTAL(1,'PECCD All'!P$15:P$248))","v":4.4085106382978712},{"$f":"IF(SUBTOTAL(2,'PECCD All'!Q$15:Q$248)=0,\"\",SUBTOTAL(1,'PECCD All'!Q$15:Q$248))","v":10.045081967213115},{"$f":"IF(SUBTOTAL(2,'PECCD All'!R$15:R$248)=0,\"\",SUBTOTAL(1,'PECCD All'!R$15:R$248))","v":7.7},{"$f":"IF(SUBTOTAL(2,'PECCD All'!S$15:S$248)=0,\"\",SUBTOTAL(1,'PECCD All'!S$15:S$248))","v":5.2411764705882344},{"$f":"IF(SUBTOTAL(2,'PECCD All'!T$15:T$248)=0,\"\",SUBTOTAL(1,'PECCD All'!T$15:T$248))","v":13.387499999999998},{"$f":"IF(SUBTOTAL(2,'PECCD All'!U$15:U$248)=0,\"\",SUBTOTAL(1,'PECCD All'!U$15:U$248))","v":12.018181818181818},{"$f":"IF(SUBTOTAL(2,'PECCD All'!V$15:V$248)=0,\"\",SUBTOTAL(1,'PECCD All'!V$15:V$248))","v":3.324418604651163},null,null,null,{"$f":"IF(SUBTOTAL(2,'PECCD All'!Z$15:Z$248)=0,\"\",SUBTOTAL(1,'PECCD All'!Z$15:Z$248))","v":""},{"$f":"IF(SUBTOTAL(2,'PECCD All'!AA$15:AA$248)=0,\"\",SUBTOTAL(1,'PECCD All'!AA$15:AA$248))","v":0.12777777777777766},{"$f":"IF(SUBTOTAL(2,'PECCD All'!AB$15:AB$248)=0,\"\",SUBTOTAL(1,'PECCD All'!AB$15:AB$248))","v":0.13333333333333316},{"$f":"IF(SUBTOTAL(2,'PECCD All'!AC$15:AC$248)=0,\"\",SUBTOTAL(1,'PECCD All'!AC$15:AC$248))","v":2.6473118279569894}]
["MAX",null,null,null,null,{"$f":"IF(SUBTOTAL(2,'PECCD All'!F$15:F$248)=0,\"\",SUBTOTAL(4,'PECCD All'!F$15:F$248))","v":2},{"$f":"IF(SUBTOTAL(2,'PECCD All'!G$15:G$248)=0,\"\",SUBTOTAL(4,'PECCD All'!G$15:G$248))","v":2.5},{"$f":"IF(SUBTOTAL(2,'PECCD All'!H$15:H$248)=0,\"\",SUBTOTAL(4,'PECCD All'!H$15:H$248))","v":0.8},{"$f":"IF(SUBTOTAL(2,'PECCD All'!I$15:I$248)=0,\"\",SUBTOTAL(4,'PECCD All'!I$15:I$248))","v":3.7},{"$f":"IF(SUBTOTAL(2,'PECCD All'!J$15:J$248)=0,\"\",SUBTOTAL(4,'PECCD All'!J$15:J$248))","v":3.7},{"$f":"IF(SUBTOTAL(2,'PECCD All'!K$15:K$248)=0,\"\",SUBTOTAL(4,'PECCD All'!K$15:K$248))","v":7.4},{"$f":"IF(SUBTOTAL(2,'PECCD All'!L$15:L$248)=0,\"\",SUBTOTAL(4,'PECCD All'!L$15:L$248))","v":1.4},{"$f":"IF(SUBTOTAL(2,'PECCD All'!M$15:M$248)=0,\"\",SUBTOTAL(4,'PECCD All'!M$15:M$248))","v":2.7},{"$f":"IF(SUBTOTAL(2,'PECCD All'!N$15:N$248)=0,\"\",SUBTOTAL(4,'PECCD All'!N$15:N$248))","v":""},{"$f":"IF(SUBTOTAL(2,'PECCD All'!O$15:O$248)=0,\"\",SUBTOTAL(4,'PECCD All'!O$15:O$248))","v":""},{"$f":"IF(SUBTOTAL(2,'PECCD All'!P$15:P$248)=0,\"\",SUBTOTAL(4,'PECCD All'!P$15:P$248))","v":9.8000000000000007},{"$f":"IF(SUBTOTAL(2,'PECCD All'!Q$15:Q$248)=0,\"\",SUBTOTAL(4,'PECCD All'!Q$15:Q$248))","v":17.5},{"$f":"IF(SUBTOTAL(2,'PECCD All'!R$15:R$248)=0,\"\",SUBTOTAL(4,'PECCD All'!R$15:R$248))","v":7.7},{"$f":"IF(SUBTOTAL(2,'PECCD All'!S$15:S$248)=0,\"\",SUBTOTAL(4,'PECCD All'!S$15:S$248))","v":10.6},{"$f":"IF(SUBTOTAL(2,'PECCD All'!T$15:T$248)=0,\"\",SUBTOTAL(4,'PECCD All'!T$15:T$248))","v":18},{"$f":"IF(SUBTOTAL(2,'PECCD All'!U$15:U$248)=0,\"\",SUBTOTAL(4,'PECCD All'!U$15:U$248))","v":12.7},{"$f":"IF(SUBTOTAL(2,'PECCD All'!V$15:V$248)=0,\"\",SUBTOTAL(4,'PECCD All'!V$15:V$248))","v":5.5},null,null,null,{"$f":"IF(SUBTOTAL(2,'PECCD All'!Z$15:Z$248)=0,\"\",SUBTOTAL(4,'PECCD All'!Z$15:Z$248))","v":""},{"$f":"IF(SUBTOTAL(2,'PECCD All'!AA$15:AA$248)=0,\"\",SUBTOTAL(4,'PECCD All'!AA$15:AA$248))","v":0.5},{"$f":"IF(SUBTOTAL(2,'PECCD All'!AB$15:AB$248)=0,\"\",SUBTOTAL(4,'PECCD All'!AB$15:AB$248))","v":0.6},{"$f":"IF(SUBTOTAL(2,'PECCD All'!AC$15:AC$248)=0,\"\",SUBTOTAL(4,'PECCD All'!AC$15:AC$248))","v":5.5}]
["MIN",null,null,null,null,{"$f":"IF(SUBTOTAL(2,'PECCD All'!F$15:F$248)=0,\"\",SUBTOTAL(5,'PECCD All'!F$15:F$248))","v":0.9},{"$f":"IF(SUBTOTAL(2,'PECCD All'!G$15:G$248)=0,\"\",SUBTOTAL(5,'PECCD All'!G$15:G$248))","v":0.3},{"$f":"IF(SUBTOTAL(2,'PECCD All'!H$15:H$248)=0,\"\",SUBTOTAL(5,'PECCD All'!H$15:H$248))","v":0.5},{"$f":"IF(SUBTOTAL(2,'PECCD All'!I$15:I$248)=0,\"\",SUBTOTAL(5,'PECCD All'!I$15:I$248))","v":0.8},{"$f":"IF(SUBTOTAL(2,'PECCD All'!J$15:J$248)=0,\"\",SUBTOTAL(5,'PECCD All'!J$15:J$248))","v":1},{"$f":"IF(SUBTOTAL(2,'PECCD All'!K$15:K$248)=0,\"\",SUBTOTAL(5,'PECCD All'!K$15:K$248))","v":0.4},{"$f":"IF(SUBTOTAL(2,'PECCD All'!L$15:L$248)=0,\"\",SUBTOTAL(5,'PECCD All'!L$15:L$248))","v":1.2},{"$f":"IF(SUBTOTAL(2,'PECCD All'!M$15:M$248)=0,\"\",SUBTOTAL(5,'PECCD All'!M$15:M$248))","v":0.6},{"$f":"IF(SUBTOTAL(2,'PECCD All'!N$15:N$248)=0,\"\",SUBTOTAL(5,'PECCD All'!N$15:N$248))","v":""},{"$f":"IF(SUBTOTAL(2,'PECCD All'!O$15:O$248)=0,\"\",SUBTOTAL(5,'PECCD All'!O$15:O$248))","v":""},{"$f":"IF(SUBTOTAL(2,'PECCD All'!P$15:P$248)=0,\"\",SUBTOTAL(5,'PECCD All'!P$15:P$248))","v":2},{"$f":"IF(SUBTOTAL(2,'PECCD All'!Q$15:Q$248)=0,\"\",SUBTOTAL(5,'PECCD All'!Q$15:Q$248))","v":6.5},{"$f":"IF(SUBTOTAL(2,'PECCD All'!R$15:R$248)=0,\"\",SUBTOTAL(5,'PECCD All'!R$15:R$248))","v":7.7},{"$f":"IF(SUBTOTAL(2,'PECCD All'!S$15:S$248)=0,\"\",SUBTOTAL(5,'PECCD All'!S$15:S$248))","v":3},{"$f":"IF(SUBTOTAL(2,'PECCD All'!T$15:T$248)=0,\"\",SUBTOTAL(5,'PECCD All'!T$15:T$248))","v":8.3000000000000007},{"$f":"IF(SUBTOTAL(2,'PECCD All'!U$15:U$248)=0,\"\",SUBTOTAL(5,'PECCD All'!U$15:U$248))","v":11.2},{"$f":"IF(SUBTOTAL(2,'PECCD All'!V$15:V$248)=0,\"\",SUBTOTAL(5,'PECCD All'!V$15:V$248))","v":0.5},null,null,null,{"$f":"IF(SUBTOTAL(2,'PECCD All'!Z$15:Z$248)=0,\"\",SUBTOTAL(5,'PECCD All'!Z$15:Z$248))","v":""},{"$f":"IF(SUBTOTAL(2,'PECCD All'!AA$15:AA$248)=0,\"\",SUBTOTAL(5,'PECCD All'!AA$15:AA$248))","v":0},{"$f":"IF(SUBTOTAL(2,'PECCD All'!AB$15:AB$248)=0,\"\",SUBTOTAL(5,'PECCD All'!AB$15:AB$248))","v":0},{"$f":"IF(SUBTOTAL(2,'PECCD All'!AC$15:AC$248)=0,\"\",SUBTOTAL(5,'PECCD All'!AC$15:AC$248))","v":0.3}]
["LAYER COEF.",null,null,null,null,{"$f":"IF(F$14=\"\",\"\",_xlfn.XLOOKUP(F$14,Variables!$A$2:$A$44,_xlfn.XLOOKUP($H$10,Variables!$A$1:$E$1,Variables!$A$2:$E$44)))","v":0.25},{"$f":"IF(G$14=\"\",\"\",_xlfn.XLOOKUP(G$14,Variables!$A$2:$A$44,_xlfn.XLOOKUP($H$10,Variables!$A$1:$E$1,Variables!$A$2:$E$44)))","v":0},{"$f":"IF(H$14=\"\",\"\",_xlfn.XLOOKUP(H$14,Variables!$A$2:$A$44,_xlfn.XLOOKUP($H$10,Variables!$A$1:$E$1,Variables!$A$2:$E$44)))","v":0.17},{"$f":"IF(I$14=\"\",\"\",_xlfn.XLOOKUP(I$14,Variables!$A$2:$A$44,_xlfn.XLOOKUP($H$10,Variables!$A$1:$E$1,Variables!$A$2:$E$44)))","v":0.25},{"$f":"IF(J$14=\"\",\"\",_xlfn.XLOOKUP(J$14,Variables!$A$2:$A$44,_xlfn.XLOOKUP($H$10,Variables!$A$1:$E$1,Variables!$A$2:$E$44)))","v":0.25},{"$f":"IF(K$14=\"\",\"\",_xlfn.XLOOKUP(K$14,Variables!$A$2:$A$44,_xlfn.XLOOKUP($H$10,Variables!$A$1:$E$1,Variables!$A$2:$E$44)))","v":0.25},{"$f":"IF(L$14=\"\",\"\",_xlfn.XLOOKUP(L$14,Variables!$A$2:$A$44,_xlfn.XLOOKUP($H$10,Variables!$A$1:$E$1,Variables!$A$2:$E$44)))","v":0.11},{"$f":"IF(M$14=\"\",\"\",_xlfn.XLOOKUP(M$14,Variables!$A$2:$A$44,_xlfn.XLOOKUP($H$10,Variables!$A$1:$E$1,Variables!$A$2:$E$44)))","v":0.2},{"$f":"IF(N$14=\"\",\"\",_xlfn.XLOOKUP(N$14,Variables!$A$2:$A$44,_xlfn.XLOOKUP($H$10,Variables!$A$1:$E$1,Variables!$A$2:$E$44)))","v":""},{"$f":"IF(O$14=\"\",\"\",_xlfn.XLOOKUP(O$14,Variables!$A$2:$A$44,_xlfn.XLOOKUP($H$10,Variables!$A$1:$E$1,Variables!$A$2:$E$44)))","v":""},null,{"$f":"IF(Q$14=\"\",\"\",_xlfn.XLOOKUP(Q$14,Variables!$F$2:$F$30,_xlfn.XLOOKUP($H$10,Variables!$F$1:$J$1,Variables!$F$2:$J$30)))","v":0.18},{"$f":"IF(R$14=\"\",\"\",_xlfn.XLOOKUP(R$14,Variables!$F$2:$F$30,_xlfn.XLOOKUP($H$10,Variables!$F$1:$J$1,Variables!$F$2:$J$30)))","v":"UNKW"},{"$f":"IF(S$14=\"\",\"\",_xlfn.XLOOKUP(S$14,Variables!$F$2:$F$30,_xlfn.XLOOKUP($H$10,Variables!$F$1:$J$1,Variables!$F$2:$J$30)))","v":0.16},{"$f":"IF(T$14=\"\",\"\",_xlfn.XLOOKUP(T$14,Variables!$F$2:$F$30,_xlfn.XLOOKUP($H$10,Variables!$F$1:$J$1,Variables!$F$2:$J$30)))","v":0.18},0.08]
[]
["Notes:"]
["1. The data presented on this table is specific only at the locations cored at the time of the investigation. Should questions arise regarding the pavement composition, it is incumbent upon those raising the question to perform additional exploration as necessary."]
["2. Mile posts are approximate based on field recorded measurements using a Distance Measuring Instrument (DMI) or a GPS unit."]
["3. Stabilization thickness was checked on all coring locations. For pavement design, assume 12 inches of thickness for stabilization."]
["4. The cross slope is approximate and measured in the center of the lane."]
["5. A blank cell indicates measurement was not recorded."]
["6. A value of \"UNK\" indicates material was encountered but the total thickness was not determined. "]
[]
["Lane Designations - Decreasing MP",null,null,null,"Lane Designations - Increasing MP",null,null,null,null,null,"Lane Type",null,null,null,null,null,"Crack Type",null,"Crack Rating",null,null,null,null,null,"Extent",null,null,null,null,"Pavement Condition"]
["OL/IL - Outside/Inside Shoulder",null,null,null,"OR/IR - Outside/Inside Shoulder",null,null,null,null,null,"ML - Mainline",null,"S - Shoulder",null,null,null,"A - Alligator",null,"Class IB - Hairline cracks that are ≤  1/8 inch wide",null,null,null,null,null,"L - Light",null,null,null,null,"G - Good"]
["L1 - 1st Lane Left of Centerline",null,null,null,"R1 - 1st Lane Right of Centerline",null,null,null,null,null,"TL - Turn Lane",null,"SS - Side Street",null,null,null,"B - Block",null,"Class II - Cracks > than 1/8 inch and ≤ 1/4 inch",null,null,null,null,null,"M - Moderate",null,null,null,null,"F - Fair"]
["LL/LR - Left/Right Turn Lane",null,null,null,"RL/RR - Left/Right Turn Lane",null,null,null,null,null,"CO - Crossover",null,"BR - Bridge Approach/Departure",null,null,null,"C - Combination",null,"Class III -  Cracks > 1/4 inch",null,null,null,null,null,"S - Severe",null,null,null,null,"P - Poor"]

{"sheet":"Variables","index":1,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Pavement Layer Codes","Description","Good","Fair","Poor","Base Layer Codes","Description","Good","Fair","Poor","All Cores","All Cores","Overall Condition"]
["ARMI","Asphalt Rubber Membrane Interlayer",0,0,0,"ABC-1","ABC similar to SAHM and SBRM",0.17,0.14000000000000001,0.1,"Mainline","ML","Good"]
["BIND","Asphalt Binder Course",0.25,0.2,0.15,"ABC-2","ABC similar to SAHM and SBRM",0.2,0.16,0.12,"Shoulders","S","Fair"]
["BRCK","Brick Pavers","UNKW","UNKW","UNKW","ABC-3","ABC similar to S-II and S-I",0.25,0.2,0.15,"Turn Lanes","TL","Poor"]
["CONC","Portland Cement Concrete","UNKW","UNKW","UNKW","B-12.5","Type B-12.5",0.25,0.2,0.15,"Side Street","SS",{"$f":"IF('PECCD All'!H10=\"Good\",3,IF('PECCD All'!H10=\"Fair\",4,5))","v":4}]
["CRL","Crack Relief Layer",0,0,0,"BRCK","Brick Pavers (Clay or Asphalt)","UNKW","UNKW","UNKW","Bridge Approach/Departure","BR"]
["FAB","Pavement Overlay Fabric",0,0,0,"CONC","Concrete","UNKW","UNKW","UNKW","Crossovers","CO"]
["FC","Friction Course","UNKW","UNKW","UNKW","CTSG","Cement Treated (300 psi)",0.12,0.12,0.12,"Gore Area","GO"]
["FC1","Friction Course 1",0.17,0.15,0.12,"ECON","Econocrete Base",0.12,0.12,0.12]
["FC2","Friction Course 2",0,0,0,"FDR","Full Depth Reclamation",0.2,0.2,0.2]
["FC3","Friction Course 3",0.2,0.17,0.15,"GRAG","Graded Aggregate (LBR 100)",0.15,0.15,0.15]
["FC4","Friction Course 4",0.17,0.15,0.12,"GRAV","Gravel & Stone","UNKW","UNKW","UNKW"]
["FC5","Friction Course 5",0,0,0,"LR","Limerock (LBR 100)",0.18,0.18,0.18]
["FC6","Friction Course 6",0.34,0.25,0.15,"LRST","Limerock Stab. (LBR 70)",0.12,0.12,0.12]
["FC9.5","Friction Course 9.5 mm",0.34,0.25,0.15,"LTSG","Lime Treated",0.08,0.08,0.08]
["FC12.5","Friction Course 12.5 mm",0.34,0.25,0.15,"MARL","Marl","UNKW","UNKW","UNKW"]
["S","Type S Asphaltic Concrete",0.34,0.25,0.15,"NONE","None",0,0,0]
["SAHM","Sand Asphalt Hot Mix",0.13,0.11,0.08,"RAP","Reclaimed Asphalt Pavement Base","UNKW","UNKW","UNKW"]
["SP1C","9.5mm Coarse Graded",0.34,0.25,0.15,"RCA","Recycled Concrete Aggregate (LBR 150)",0.18,0.18,0.18]
["SP1F","9.5mm Fine Graded",0.34,0.25,0.15,"SAHM","Sand Asphalt Hot Mix",0.13,0.11,0.08]
["SP2C","12.5mm Coarse Graded",0.34,0.25,0.15,"SCEM 300","Soil Cement (300 psi)",0.15,0.15,0.15]
["SP2F","12.5mm Fine Graded",0.34,0.25,0.15,"SCEM 500","Soil Cement (500 psi)",0.2,0.2,0.2]
["SP3C","19.0mm Coarse Graded",0.34,0.25,0.15,"SCLY","Sand Clay (LBR 75)",0.12,0.12,0.12]
["SP3F","19.0mm Fine Graded",0.34,0.25,0.15,"SHBR","Bank Run Shell (LBR 100)",0.18,0.18,0.18]
["SP9.5","Structural Course 9.5mm",0.34,0.25,0.15,"SHCC","Cemented Coquina (LBR 100)",0.18,0.18,0.18]
["SP12.5","Structural Course 12.5mm",0.34,0.25,0.15,"SHEL","Shell Rock (LBR 100)",0.18,0.18,0.18]
["ST","Surface Treatment",0,0,0,"SHST","Shell Stab. (LBR 70)",0.1,0.1,0.1]
["S1","Type S-I Asphaltic Concrete",0.34,0.25,0.15,"ST30","Type B Stab. (LBR 30)",0.06,0.06,0.06]
["S2","Type S-II Asphaltic Concrete",0.34,0.25,0.15,"ST40","Type B Stab. (LBR 40)",0.08,0.08,0.08]
["S3","Type S-III Asphaltic Concrete",0.34,0.25,0.15,"STC","Type C Stab.",0.06,0.06,0.06]
["T1","Type I Asphaltic Concrete",0.3,0.23,0.15]
["T2","Type II Asphaltic Concrete",0.17,0.15,0.12]
["T3","Type III Asphaltic Concrete",0.25,0.2,0.15]
["UNIM","Unimproved Surface","UNKW","UNKW","UNKW"]
["UNKW","Unknown","UNKW","UNKW","UNKW"]
["WC","Wearing Course","UNKW","UNKW","UNKW"]
["WC1","Wearing Course 1","UNKW","UNKW","UNKW"]
["WC2","Wearing Course 2","UNKW","UNKW","UNKW"]
["WC3","Wearing Course 3","UNKW","UNKW","UNKW"]
["WC4","Wearing Course 4","UNKW","UNKW","UNKW"]
["WC5","Wearing Course 5","UNKW","UNKW","UNKW"]
["WC6","Wearing Course 6","UNKW","UNKW","UNKW"]
["WC7","Wearing Course 7","UNKW","UNKW","UNKW"]
["WC8","Wearing Course 8","UNKW","UNKW","UNKW"]