{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Deficiencies","Instructions","Grade Checks","Vertical Curve Checks","Horizontal Curve","Bridge Considerations"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":45,"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":"Deficiencies","index":0,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[[50,5,51,5],[50,6,50,7],[50,10,51,10],[1,1,1,7],[40,1,40,6],[35,1,37,1],[33,0,33,1],[50,0,51,0],[50,1,51,1],[50,2,51,2],[50,3,51,3],[50,4,51,4],[40,7,40,11],[39,0,39,8],[49,0,49,8],[19,14,21,14],[0,1,0,7],[2,1,2,7],[20,10,20,13],[5,0,5,8],[20,6,20,9],[20,1,20,5],[5,9,6,9],[19,0,19,8]]}
["Project ID:","1440-39-30"]
["Description:","FDL - Plymouth, USH 151 - CTH UU"]
["Highway:","STH 23",null,null,null,null,null,null,null,"55 MPH zone starts about 3600' east of CTH K"]
[]
[]
["Vertical Curve",null,null,null,null,null,null,null,null,"Key"]
["Asbuilt Plan","Location","PI","Type","Length","Design Speed","K & SSD Pass/Fail","Design Speed Testing","Length Extension Testing"]
[{"$f":"IF('Vertical Curve Checks'!A7=\"\",\"\",'Vertical Curve Checks'!A7)","v":"1442-01-73"},{"$f":"IF('Vertical Curve Checks'!B7=\"\",\"\",'Vertical Curve Checks'!B7)","v":"STH 23 WB, 2040' East of CTH K"},{"$f":"IF('Vertical Curve Checks'!C7=\"\",\"\",'Vertical Curve Checks'!C7)","v":"157+00"},{"$f":"IF('Vertical Curve Checks'!E7=\"\",\"\",'Vertical Curve Checks'!E7)","v":"crest"},{"$f":"IF('Vertical Curve Checks'!F7=\"\",\"\",'Vertical Curve Checks'!F7)","v":1450},{"$f":"IF('Vertical Curve Checks'!G7=\"\",\"\",'Vertical Curve Checks'!G7)","v":7},{"$f":"'Vertical Curve Checks'!U7","v":"Both Pass"},{"$f":"'Vertical Curve Checks'!U22","v":"Pass"},{"$f":"'Vertical Curve Checks'!U37","v":"K Pass/ SSD Fail"},{"$f":"'Vertical Curve Checks'!W7","v":1}]
[{"$f":"IF('Vertical Curve Checks'!A8=\"\",\"\",'Vertical Curve Checks'!A8)","v":"1442-01-73"},{"$f":"IF('Vertical Curve Checks'!B8=\"\",\"\",'Vertical Curve Checks'!B8)","v":"STH 23 EB, 2040' East of CTH K"},{"$f":"IF('Vertical Curve Checks'!C8=\"\",\"\",'Vertical Curve Checks'!C8)","v":"157+00"},{"$f":"IF('Vertical Curve Checks'!E8=\"\",\"\",'Vertical Curve Checks'!E8)","v":"crest"},{"$f":"IF('Vertical Curve Checks'!F8=\"\",\"\",'Vertical Curve Checks'!F8)","v":1450},{"$f":"IF('Vertical Curve Checks'!G8=\"\",\"\",'Vertical Curve Checks'!G8)","v":7},{"$f":"'Vertical Curve Checks'!U8","v":"Both Pass"},{"$f":"'Vertical Curve Checks'!U23","v":"Pass"},{"$f":"'Vertical Curve Checks'!U38","v":"K Pass/ SSD Fail"},{"$f":"'Vertical Curve Checks'!W8","v":2}]
[{"$f":"IF('Vertical Curve Checks'!A9=\"\",\"\",'Vertical Curve Checks'!A9)","v":"1442-01-73"},{"$f":"IF('Vertical Curve Checks'!B9=\"\",\"\",'Vertical Curve Checks'!B9)","v":"STH 23, 3640' East of CTH K"},{"$f":"IF('Vertical Curve Checks'!C9=\"\",\"\",'Vertical Curve Checks'!C9)","v":"173+00"},{"$f":"IF('Vertical Curve Checks'!E9=\"\",\"\",'Vertical Curve Checks'!E9)","v":"sag"},{"$f":"IF('Vertical Curve Checks'!F9=\"\",\"\",'Vertical Curve Checks'!F9)","v":1100},{"$f":"IF('Vertical Curve Checks'!G9=\"\",\"\",'Vertical Curve Checks'!G9)","v":-0.41},{"$f":"'Vertical Curve Checks'!U9","v":"Both Pass"},{"$f":"'Vertical Curve Checks'!U24","v":"Pass"},{"$f":"'Vertical Curve Checks'!U39","v":"K Pass/ SSD Fail"},{"$f":"'Vertical Curve Checks'!W9","v":3}]
[{"$f":"IF('Vertical Curve Checks'!A10=\"\",\"\",'Vertical Curve Checks'!A10)","v":"1442-01-73"},{"$f":"IF('Vertical Curve Checks'!B10=\"\",\"\",'Vertical Curve Checks'!B10)","v":"STH 23, 1790' West of CTH UU"},{"$f":"IF('Vertical Curve Checks'!C10=\"\",\"\",'Vertical Curve Checks'!C10)","v":"185+50"},{"$f":"IF('Vertical Curve Checks'!E10=\"\",\"\",'Vertical Curve Checks'!E10)","v":"crest"},{"$f":"IF('Vertical Curve Checks'!F10=\"\",\"\",'Vertical Curve Checks'!F10)","v":1200},{"$f":"IF('Vertical Curve Checks'!G10=\"\",\"\",'Vertical Curve Checks'!G10)","v":4.992},{"$f":"'Vertical Curve Checks'!U10","v":"Both Pass"},{"$f":"'Vertical Curve Checks'!U25","v":"Pass"},{"$f":"'Vertical Curve Checks'!U40","v":"K Pass/ SSD Fail"},{"$f":"'Vertical Curve Checks'!W10","v":4}]
[{"$f":"IF('Vertical Curve Checks'!A11=\"\",\"\",'Vertical Curve Checks'!A11)","v":"1442-01-73"},{"$f":"IF('Vertical Curve Checks'!B11=\"\",\"\",'Vertical Curve Checks'!B11)","v":"STH 23, 840' West of CTH UU"},{"$f":"IF('Vertical Curve Checks'!C11=\"\",\"\",'Vertical Curve Checks'!C11)","v":"195+00"},{"$f":"IF('Vertical Curve Checks'!E11=\"\",\"\",'Vertical Curve Checks'!E11)","v":"sag"},{"$f":"IF('Vertical Curve Checks'!F11=\"\",\"\",'Vertical Curve Checks'!F11)","v":300},{"$f":"IF('Vertical Curve Checks'!G11=\"\",\"\",'Vertical Curve Checks'!G11)","v":-0.78500000000000003},{"$f":"'Vertical Curve Checks'!U11","v":"Both Pass"},{"$f":"'Vertical Curve Checks'!U26","v":"Pass"},{"$f":"'Vertical Curve Checks'!U41","v":"K Pass/ SSD Fail"},{"$f":"'Vertical Curve Checks'!W11","v":5}]
[{"$f":"IF('Vertical Curve Checks'!A12=\"\",\"\",'Vertical Curve Checks'!A12)","v":""},{"$f":"IF('Vertical Curve Checks'!B12=\"\",\"\",'Vertical Curve Checks'!B12)","v":""},{"$f":"IF('Vertical Curve Checks'!C12=\"\",\"\",'Vertical Curve Checks'!C12)","v":""},{"$f":"IF('Vertical Curve Checks'!E12=\"\",\"\",'Vertical Curve Checks'!E12)","v":""},{"$f":"IF('Vertical Curve Checks'!F12=\"\",\"\",'Vertical Curve Checks'!F12)","v":""},{"$f":"IF('Vertical Curve Checks'!G12=\"\",\"\",'Vertical Curve Checks'!G12)","v":""},{"$f":"'Vertical Curve Checks'!U12","v":""},{"$f":"'Vertical Curve Checks'!U27","v":""},{"$f":"'Vertical Curve Checks'!U42","v":""},{"$f":"'Vertical Curve Checks'!W12","v":6}]
[{"$f":"IF('Vertical Curve Checks'!A13=\"\",\"\",'Vertical Curve Checks'!A13)","v":""},{"$f":"IF('Vertical Curve Checks'!B13=\"\",\"\",'Vertical Curve Checks'!B13)","v":""},{"$f":"IF('Vertical Curve Checks'!C13=\"\",\"\",'Vertical Curve Checks'!C13)","v":""},{"$f":"IF('Vertical Curve Checks'!E13=\"\",\"\",'Vertical Curve Checks'!E13)","v":""},{"$f":"IF('Vertical Curve Checks'!F13=\"\",\"\",'Vertical Curve Checks'!F13)","v":""},{"$f":"IF('Vertical Curve Checks'!G13=\"\",\"\",'Vertical Curve Checks'!G13)","v":""},{"$f":"'Vertical Curve Checks'!U13","v":""},{"$f":"'Vertical Curve Checks'!U28","v":""},{"$f":"'Vertical Curve Checks'!U43","v":""},{"$f":"'Vertical Curve Checks'!W13","v":7}]
[{"$f":"IF('Vertical Curve Checks'!A14=\"\",\"\",'Vertical Curve Checks'!A14)","v":""},{"$f":"IF('Vertical Curve Checks'!B14=\"\",\"\",'Vertical Curve Checks'!B14)","v":""},{"$f":"IF('Vertical Curve Checks'!C14=\"\",\"\",'Vertical Curve Checks'!C14)","v":""},{"$f":"IF('Vertical Curve Checks'!E14=\"\",\"\",'Vertical Curve Checks'!E14)","v":""},{"$f":"IF('Vertical Curve Checks'!F14=\"\",\"\",'Vertical Curve Checks'!F14)","v":""},{"$f":"IF('Vertical Curve Checks'!G14=\"\",\"\",'Vertical Curve Checks'!G14)","v":""},{"$f":"'Vertical Curve Checks'!U14","v":""},{"$f":"'Vertical Curve Checks'!U29","v":""},{"$f":"'Vertical Curve Checks'!U44","v":""},{"$f":"'Vertical Curve Checks'!W14","v":8}]
[{"$f":"IF('Vertical Curve Checks'!A15=\"\",\"\",'Vertical Curve Checks'!A15)","v":""},{"$f":"IF('Vertical Curve Checks'!B15=\"\",\"\",'Vertical Curve Checks'!B15)","v":""},{"$f":"IF('Vertical Curve Checks'!C15=\"\",\"\",'Vertical Curve Checks'!C15)","v":""},{"$f":"IF('Vertical Curve Checks'!E15=\"\",\"\",'Vertical Curve Checks'!E15)","v":""},{"$f":"IF('Vertical Curve Checks'!F15=\"\",\"\",'Vertical Curve Checks'!F15)","v":""},{"$f":"IF('Vertical Curve Checks'!G15=\"\",\"\",'Vertical Curve Checks'!G15)","v":""},{"$f":"'Vertical Curve Checks'!U15","v":""},{"$f":"'Vertical Curve Checks'!U30","v":""},{"$f":"'Vertical Curve Checks'!U45","v":""},{"$f":"'Vertical Curve Checks'!W15","v":9}]
[{"$f":"IF('Vertical Curve Checks'!A16=\"\",\"\",'Vertical Curve Checks'!A16)","v":""},{"$f":"IF('Vertical Curve Checks'!B16=\"\",\"\",'Vertical Curve Checks'!B16)","v":""},{"$f":"IF('Vertical Curve Checks'!C16=\"\",\"\",'Vertical Curve Checks'!C16)","v":""},{"$f":"IF('Vertical Curve Checks'!E16=\"\",\"\",'Vertical Curve Checks'!E16)","v":""},{"$f":"IF('Vertical Curve Checks'!F16=\"\",\"\",'Vertical Curve Checks'!F16)","v":""},{"$f":"IF('Vertical Curve Checks'!G16=\"\",\"\",'Vertical Curve Checks'!G16)","v":""},{"$f":"'Vertical Curve Checks'!U16","v":""},{"$f":"'Vertical Curve Checks'!U31","v":""},{"$f":"'Vertical Curve Checks'!U46","v":""},{"$f":"'Vertical Curve Checks'!W16","v":10}]
[{"$f":"IF('Vertical Curve Checks'!A17=\"\",\"\",'Vertical Curve Checks'!A17)","v":""},{"$f":"IF('Vertical Curve Checks'!B17=\"\",\"\",'Vertical Curve Checks'!B17)","v":""},{"$f":"IF('Vertical Curve Checks'!C17=\"\",\"\",'Vertical Curve Checks'!C17)","v":""},{"$f":"IF('Vertical Curve Checks'!E17=\"\",\"\",'Vertical Curve Checks'!E17)","v":""},{"$f":"IF('Vertical Curve Checks'!F17=\"\",\"\",'Vertical Curve Checks'!F17)","v":""},{"$f":"IF('Vertical Curve Checks'!G17=\"\",\"\",'Vertical Curve Checks'!G17)","v":""},{"$f":"'Vertical Curve Checks'!U17","v":""},{"$f":"'Vertical Curve Checks'!U32","v":""},{"$f":"'Vertical Curve Checks'!U47","v":""},{"$f":"'Vertical Curve Checks'!W17","v":11}]
[]
["Horizontal Curve",null,null,null,null,null,null,null,null,null,null,null,null,null,"Key"]
[null,"Existing Conditions",null,null,null,null,"Minimum Required/Maximum Allowable e%",null,null,null,"Design Speed Results"]
["Asbuilt Plan","Location","PI","Design Speed","e (Super Elevation)","Curve Radius","e%","R, min","Current e% Pass/Fail","Existing Alignment Pass/Fail","Max Design Speed","Minimum e%","R, Min","Pass/Fail"]
[{"$f":"IF('Horizontal Curve'!A8=\"\",\"\",'Horizontal Curve'!A8)","v":"1442-01-73"},{"$f":"IF(A23=\"\",\"\",'Horizontal Curve'!B8)","v":"2050' east of CTH K"},{"$f":"IF(B23=\"\",\"\",'Horizontal Curve'!C8)","v":"157+00.15"},{"$f":"'Horizontal Curve'!E8","v":50},{"$f":"IF(D23=\"\",\"\",'Horizontal Curve'!H8)","v":3.2000000000000001E-2},{"$f":"IF(E23=\"\",\"\",'Horizontal Curve'!F8)","v":5729.58},{"$f":"IF(F23=\"\",\"\",'Horizontal Curve'!L8)","v":0},{"$f":"IF(G23=\"\",\"\",'Horizontal Curve'!M8)","v":643},{"$f":"'Horizontal Curve'!R8","v":"Pass"},{"$f":"'Horizontal Curve'!S8","v":"Pass"},{"$f":"IF(J23=\"\",\"\",'Horizontal Curve'!D22)","v":0},{"$f":"IF(K23=\"\",\"\",'Horizontal Curve'!E22)","v":0},{"$f":"IF(L23=\"\",\"\",'Horizontal Curve'!F22)","v":0},{"$f":"'Horizontal Curve'!G22","v":"Pass"},{"$f":"'Horizontal Curve'!T8","v":1}]
[{"$f":"IF('Horizontal Curve'!A9=\"\",\"\",'Horizontal Curve'!A9)","v":"1442-01-73"},{"$f":"IF(A24=\"\",\"\",'Horizontal Curve'!B9)","v":"3100' east of CTH K"},{"$f":"IF(B24=\"\",\"\",'Horizontal Curve'!C9)","v":"167+52.50"},{"$f":"'Horizontal Curve'!E9","v":60},{"$f":"IF(D24=\"\",\"\",'Horizontal Curve'!H9)","v":3.2000000000000001E-2},{"$f":"IF(E24=\"\",\"\",'Horizontal Curve'!F9)","v":5729.58},{"$f":"IF(F24=\"\",\"\",'Horizontal Curve'!L9)","v":2.4E-2},{"$f":"IF(G24=\"\",\"\",'Horizontal Curve'!M9)","v":1060},{"$f":"'Horizontal Curve'!R9","v":"Pass"},{"$f":"'Horizontal Curve'!S9","v":"Pass"},{"$f":"IF(J24=\"\",\"\",'Horizontal Curve'!D23)","v":0},{"$f":"IF(K24=\"\",\"\",'Horizontal Curve'!E23)","v":0},{"$f":"IF(L24=\"\",\"\",'Horizontal Curve'!F23)","v":0},{"$f":"'Horizontal Curve'!G23","v":"Pass"},{"$f":"'Horizontal Curve'!T9","v":2}]
[{"$f":"IF('Horizontal Curve'!A10=\"\",\"\",'Horizontal Curve'!A10)","v":"1442-01-73"},{"$f":"IF(A25=\"\",\"\",'Horizontal Curve'!B10)","v":"3988' east of CTH K"},{"$f":"IF(B25=\"\",\"\",'Horizontal Curve'!C10)","v":"176+38.20"},{"$f":"'Horizontal Curve'!E10","v":60},{"$f":"IF(D25=\"\",\"\",'Horizontal Curve'!H10)","v":3.2000000000000001E-2},{"$f":"IF(E25=\"\",\"\",'Horizontal Curve'!F10)","v":5729.58},{"$f":"IF(F25=\"\",\"\",'Horizontal Curve'!L10)","v":2.4E-2},{"$f":"IF(G25=\"\",\"\",'Horizontal Curve'!M10)","v":1060},{"$f":"'Horizontal Curve'!R10","v":"Pass"},{"$f":"'Horizontal Curve'!S10","v":"Pass"},{"$f":"IF(J25=\"\",\"\",'Horizontal Curve'!D24)","v":0},{"$f":"IF(K25=\"\",\"\",'Horizontal Curve'!E24)","v":0},{"$f":"IF(L25=\"\",\"\",'Horizontal Curve'!F24)","v":0},{"$f":"'Horizontal Curve'!G24","v":"Pass"},{"$f":"'Horizontal Curve'!T10","v":3}]
[{"$f":"IF('Horizontal Curve'!A11=\"\",\"\",'Horizontal Curve'!A11)","v":""},{"$f":"IF(A26=\"\",\"\",'Horizontal Curve'!B11)","v":""},{"$f":"IF(B26=\"\",\"\",'Horizontal Curve'!C11)","v":""},{"$f":"'Horizontal Curve'!E11","v":""},{"$f":"IF(D26=\"\",\"\",'Horizontal Curve'!H11)","v":""},{"$f":"IF(E26=\"\",\"\",'Horizontal Curve'!F11)","v":""},{"$f":"IF(F26=\"\",\"\",'Horizontal Curve'!L11)","v":""},{"$f":"IF(G26=\"\",\"\",'Horizontal Curve'!M11)","v":""},{"$f":"'Horizontal Curve'!R11","v":""},{"$f":"'Horizontal Curve'!S11","v":""},{"$f":"IF(J26=\"\",\"\",'Horizontal Curve'!D25)","v":""},{"$f":"IF(K26=\"\",\"\",'Horizontal Curve'!E25)","v":""},{"$f":"IF(L26=\"\",\"\",'Horizontal Curve'!F25)","v":""},{"$f":"'Horizontal Curve'!G25","v":""},{"$f":"'Horizontal Curve'!T11","v":4}]
[{"$f":"IF('Horizontal Curve'!A12=\"\",\"\",'Horizontal Curve'!A12)","v":""},{"$f":"IF(A27=\"\",\"\",'Horizontal Curve'!B12)","v":""},{"$f":"IF(B27=\"\",\"\",'Horizontal Curve'!C12)","v":""},{"$f":"'Horizontal Curve'!E12","v":""},{"$f":"IF(D27=\"\",\"\",'Horizontal Curve'!H12)","v":""},{"$f":"IF(E27=\"\",\"\",'Horizontal Curve'!F12)","v":""},{"$f":"IF(F27=\"\",\"\",'Horizontal Curve'!L12)","v":""},{"$f":"IF(G27=\"\",\"\",'Horizontal Curve'!M12)","v":""},{"$f":"'Horizontal Curve'!R12","v":""},{"$f":"'Horizontal Curve'!S12","v":""},{"$f":"IF(J27=\"\",\"\",'Horizontal Curve'!D26)","v":""},{"$f":"IF(K27=\"\",\"\",'Horizontal Curve'!E26)","v":""},{"$f":"IF(L27=\"\",\"\",'Horizontal Curve'!F26)","v":""},{"$f":"'Horizontal Curve'!G26","v":""},{"$f":"'Horizontal Curve'!T12","v":5}]
[{"$f":"IF('Horizontal Curve'!A13=\"\",\"\",'Horizontal Curve'!A13)","v":""},{"$f":"IF(A28=\"\",\"\",'Horizontal Curve'!B13)","v":""},{"$f":"IF(B28=\"\",\"\",'Horizontal Curve'!C13)","v":""},{"$f":"'Horizontal Curve'!E13","v":""},{"$f":"IF(D28=\"\",\"\",'Horizontal Curve'!H13)","v":""},{"$f":"IF(E28=\"\",\"\",'Horizontal Curve'!F13)","v":""},{"$f":"IF(F28=\"\",\"\",'Horizontal Curve'!L13)","v":""},{"$f":"IF(G28=\"\",\"\",'Horizontal Curve'!M13)","v":""},{"$f":"'Horizontal Curve'!R13","v":""},{"$f":"'Horizontal Curve'!S13","v":""},{"$f":"IF(J28=\"\",\"\",'Horizontal Curve'!D27)","v":""},{"$f":"IF(K28=\"\",\"\",'Horizontal Curve'!E27)","v":""},{"$f":"IF(L28=\"\",\"\",'Horizontal Curve'!F27)","v":""},{"$f":"'Horizontal Curve'!G27","v":""},{"$f":"'Horizontal Curve'!T13","v":6}]
[{"$f":"IF('Horizontal Curve'!A14=\"\",\"\",'Horizontal Curve'!A14)","v":""},{"$f":"IF(A29=\"\",\"\",'Horizontal Curve'!B14)","v":""},{"$f":"IF(B29=\"\",\"\",'Horizontal Curve'!C14)","v":""},{"$f":"'Horizontal Curve'!E14","v":""},{"$f":"IF(D29=\"\",\"\",'Horizontal Curve'!H14)","v":""},{"$f":"IF(E29=\"\",\"\",'Horizontal Curve'!F14)","v":""},{"$f":"IF(F29=\"\",\"\",'Horizontal Curve'!L14)","v":""},{"$f":"IF(G29=\"\",\"\",'Horizontal Curve'!M14)","v":""},{"$f":"'Horizontal Curve'!R14","v":""},{"$f":"'Horizontal Curve'!S14","v":""},{"$f":"IF(J29=\"\",\"\",'Horizontal Curve'!D28)","v":""},{"$f":"IF(K29=\"\",\"\",'Horizontal Curve'!E28)","v":""},{"$f":"IF(L29=\"\",\"\",'Horizontal Curve'!F28)","v":""},{"$f":"'Horizontal Curve'!G28","v":""},{"$f":"'Horizontal Curve'!T14","v":7}]
[{"$f":"IF('Horizontal Curve'!A15=\"\",\"\",'Horizontal Curve'!A15)","v":""},{"$f":"IF(A30=\"\",\"\",'Horizontal Curve'!B15)","v":""},{"$f":"IF(B30=\"\",\"\",'Horizontal Curve'!C15)","v":""},{"$f":"'Horizontal Curve'!E15","v":""},{"$f":"IF(D30=\"\",\"\",'Horizontal Curve'!H15)","v":""},{"$f":"IF(E30=\"\",\"\",'Horizontal Curve'!F15)","v":""},{"$f":"IF(F30=\"\",\"\",'Horizontal Curve'!L15)","v":""},{"$f":"IF(G30=\"\",\"\",'Horizontal Curve'!M15)","v":""},{"$f":"'Horizontal Curve'!R15","v":""},{"$f":"'Horizontal Curve'!S15","v":""},{"$f":"IF(J30=\"\",\"\",'Horizontal Curve'!D29)","v":""},{"$f":"IF(K30=\"\",\"\",'Horizontal Curve'!E29)","v":""},{"$f":"IF(L30=\"\",\"\",'Horizontal Curve'!F29)","v":""},{"$f":"'Horizontal Curve'!G29","v":""},{"$f":"'Horizontal Curve'!T15","v":8}]
[{"$f":"IF('Horizontal Curve'!A16=\"\",\"\",'Horizontal Curve'!A16)","v":""},{"$f":"IF(A31=\"\",\"\",'Horizontal Curve'!B16)","v":""},{"$f":"IF(B31=\"\",\"\",'Horizontal Curve'!C16)","v":""},{"$f":"'Horizontal Curve'!E16","v":""},{"$f":"IF(D31=\"\",\"\",'Horizontal Curve'!H16)","v":""},{"$f":"IF(E31=\"\",\"\",'Horizontal Curve'!F16)","v":""},{"$f":"IF(F31=\"\",\"\",'Horizontal Curve'!L16)","v":""},{"$f":"IF(G31=\"\",\"\",'Horizontal Curve'!M16)","v":""},{"$f":"'Horizontal Curve'!R16","v":""},{"$f":"'Horizontal Curve'!S16","v":""},{"$f":"IF(J31=\"\",\"\",'Horizontal Curve'!D30)","v":""},{"$f":"IF(K31=\"\",\"\",'Horizontal Curve'!E30)","v":""},{"$f":"IF(L31=\"\",\"\",'Horizontal Curve'!F30)","v":""},{"$f":"'Horizontal Curve'!G30","v":""},{"$f":"'Horizontal Curve'!T16","v":9}]
[{"$f":"IF('Horizontal Curve'!A17=\"\",\"\",'Horizontal Curve'!A17)","v":""},{"$f":"IF(A32=\"\",\"\",'Horizontal Curve'!B17)","v":""},{"$f":"IF(B32=\"\",\"\",'Horizontal Curve'!C17)","v":""},{"$f":"'Horizontal Curve'!E17","v":""},{"$f":"IF(D32=\"\",\"\",'Horizontal Curve'!H17)","v":""},{"$f":"IF(E32=\"\",\"\",'Horizontal Curve'!F17)","v":""},{"$f":"IF(F32=\"\",\"\",'Horizontal Curve'!L17)","v":""},{"$f":"IF(G32=\"\",\"\",'Horizontal Curve'!M17)","v":""},{"$f":"'Horizontal Curve'!R17","v":""},{"$f":"'Horizontal Curve'!S17","v":""},{"$f":"IF(J32=\"\",\"\",'Horizontal Curve'!D31)","v":""},{"$f":"IF(K32=\"\",\"\",'Horizontal Curve'!E31)","v":""},{"$f":"IF(L32=\"\",\"\",'Horizontal Curve'!F31)","v":""},{"$f":"'Horizontal Curve'!G31","v":""},{"$f":"'Horizontal Curve'!T17","v":10}]
[]
["Grade Check"]
["Asbuilts","Failures"]
[{"$f":"IF('Grade Checks'!A23=\"\",\"\",'Grade Checks'!A23)","v":"1442-01-73"},{"$f":"IF(COUNTIF(Grad_PF:Grad_PFF,\"Fail\"),\"Failuring Grades Exist\",\"No Failing Grades\")","v":"Failuring Grades Exist"}]
[{"$f":"IF('Grade Checks'!A24=\"\",\"\",'Grade Checks'!A24)","v":""}]
[{"$f":"IF('Grade Checks'!A25=\"\",\"\",'Grade Checks'!A25)","v":""}]
[]
["Pavement & Shoulder Structure"]
[null,"Previously Existing Roadway Structure",null,null,null,null,null,"Asbuilt Roadway Structure"]
["Asbuilt Plan","Location","Number of Lanes","Lane Width","Paved Shoulder Width","Total Shoulder Width","Cross Slope","Number of Lanes","Lane Width","Paved Shoulder Width","Total Shoulder Width","Cross Slope"]
[]
[]
[]
[]
[]
["RP","RP"]
[]
["Bridge Considerations"]
["Structure Number","Location","Number of Lanes","Lane Width","Bridge Width","Cross Slope","Lateral Clearnce Test",null,"Vertical Clearance Test",null,"Structural Capacity"]
[null,null,null,null,null,null,"Lateral Clearance","Perferred Lateral Clearance","Vertical Clearance","Minimum Vertical Clearance"]
[{"$f":"IF('Bridge Considerations'!A7=\"\",\"\",'Bridge Considerations'!A7)","v":"None"},{"$f":"IF('Bridge Considerations'!B7=\"\",\"\",'Bridge Considerations'!B7)","v":""},{"$f":"IF('Bridge Considerations'!C7=\"\",\"\",'Bridge Considerations'!C7)","v":""},{"$f":"IF('Bridge Considerations'!D7=\"\",\"\",'Bridge Considerations'!D7)","v":""},{"$f":"IF('Bridge Considerations'!E7=\"\",\"\",'Bridge Considerations'!E7)","v":""},{"$f":"IF('Bridge Considerations'!F7=\"\",\"\",'Bridge Considerations'!F7)","v":""},{"$f":"IF('Bridge Considerations'!G7=\"\",\"\",'Bridge Considerations'!G7)","v":""},{"$f":"IF('Bridge Considerations'!H7=\"\",\"\",'Bridge Considerations'!H7)","v":""},{"$f":"IF('Bridge Considerations'!I7=\"\",\"\",'Bridge Considerations'!I7)","v":""},{"$f":"IF('Bridge Considerations'!J7=\"\",\"\",'Bridge Considerations'!J7)","v":""},{"$f":"IF('Bridge Considerations'!K7=\"\",\"\",'Bridge Considerations'!K7)","v":""}]
[{"$f":"IF('Bridge Considerations'!A8=\"\",\"\",'Bridge Considerations'!A8)","v":""},{"$f":"IF('Bridge Considerations'!B8=\"\",\"\",'Bridge Considerations'!B8)","v":""},{"$f":"IF('Bridge Considerations'!C8=\"\",\"\",'Bridge Considerations'!C8)","v":""},{"$f":"IF('Bridge Considerations'!D8=\"\",\"\",'Bridge Considerations'!D8)","v":""},{"$f":"IF('Bridge Considerations'!E8=\"\",\"\",'Bridge Considerations'!E8)","v":""},{"$f":"IF('Bridge Considerations'!F8=\"\",\"\",'Bridge Considerations'!F8)","v":""},{"$f":"IF('Bridge Considerations'!G8=\"\",\"\",'Bridge Considerations'!G8)","v":""},{"$f":"IF('Bridge Considerations'!H8=\"\",\"\",'Bridge Considerations'!H8)","v":""},{"$f":"IF('Bridge Considerations'!I8=\"\",\"\",'Bridge Considerations'!I8)","v":""},{"$f":"IF('Bridge Considerations'!J8=\"\",\"\",'Bridge Considerations'!J8)","v":""},{"$f":"IF('Bridge Considerations'!K8=\"\",\"\",'Bridge Considerations'!K8)","v":""}]
[{"$f":"IF('Bridge Considerations'!A9=\"\",\"\",'Bridge Considerations'!A9)","v":""},{"$f":"IF('Bridge Considerations'!B9=\"\",\"\",'Bridge Considerations'!B9)","v":""},{"$f":"IF('Bridge Considerations'!C9=\"\",\"\",'Bridge Considerations'!C9)","v":""},{"$f":"IF('Bridge Considerations'!D9=\"\",\"\",'Bridge Considerations'!D9)","v":""},{"$f":"IF('Bridge Considerations'!E9=\"\",\"\",'Bridge Considerations'!E9)","v":""},{"$f":"IF('Bridge Considerations'!F9=\"\",\"\",'Bridge Considerations'!F9)","v":""},{"$f":"IF('Bridge Considerations'!G9=\"\",\"\",'Bridge Considerations'!G9)","v":""},{"$f":"IF('Bridge Considerations'!H9=\"\",\"\",'Bridge Considerations'!H9)","v":""},{"$f":"IF('Bridge Considerations'!I9=\"\",\"\",'Bridge Considerations'!I9)","v":""},{"$f":"IF('Bridge Considerations'!J9=\"\",\"\",'Bridge Considerations'!J9)","v":""},{"$f":"IF('Bridge Considerations'!K9=\"\",\"\",'Bridge Considerations'!K9)","v":""}]
[{"$f":"IF('Bridge Considerations'!A10=\"\",\"\",'Bridge Considerations'!A10)","v":""},{"$f":"IF('Bridge Considerations'!B10=\"\",\"\",'Bridge Considerations'!B10)","v":""},{"$f":"IF('Bridge Considerations'!C10=\"\",\"\",'Bridge Considerations'!C10)","v":""},{"$f":"IF('Bridge Considerations'!D10=\"\",\"\",'Bridge Considerations'!D10)","v":""},{"$f":"IF('Bridge Considerations'!E10=\"\",\"\",'Bridge Considerations'!E10)","v":""},{"$f":"IF('Bridge Considerations'!F10=\"\",\"\",'Bridge Considerations'!F10)","v":""},{"$f":"IF('Bridge Considerations'!G10=\"\",\"\",'Bridge Considerations'!G10)","v":""},{"$f":"IF('Bridge Considerations'!H10=\"\",\"\",'Bridge Considerations'!H10)","v":""},{"$f":"IF('Bridge Considerations'!I10=\"\",\"\",'Bridge Considerations'!I10)","v":""},{"$f":"IF('Bridge Considerations'!J10=\"\",\"\",'Bridge Considerations'!J10)","v":""},{"$f":"IF('Bridge Considerations'!K10=\"\",\"\",'Bridge Considerations'!K10)","v":""}]
[{"$f":"IF('Bridge Considerations'!A11=\"\",\"\",'Bridge Considerations'!A11)","v":""},{"$f":"IF('Bridge Considerations'!B11=\"\",\"\",'Bridge Considerations'!B11)","v":""},{"$f":"IF('Bridge Considerations'!C11=\"\",\"\",'Bridge Considerations'!C11)","v":""},{"$f":"IF('Bridge Considerations'!D11=\"\",\"\",'Bridge Considerations'!D11)","v":""},{"$f":"IF('Bridge Considerations'!E11=\"\",\"\",'Bridge Considerations'!E11)","v":""},{"$f":"IF('Bridge Considerations'!F11=\"\",\"\",'Bridge Considerations'!F11)","v":""},{"$f":"IF('Bridge Considerations'!G11=\"\",\"\",'Bridge Considerations'!G11)","v":""},{"$f":"IF('Bridge Considerations'!H11=\"\",\"\",'Bridge Considerations'!H11)","v":""},{"$f":"IF('Bridge Considerations'!I11=\"\",\"\",'Bridge Considerations'!I11)","v":""},{"$f":"IF('Bridge Considerations'!J11=\"\",\"\",'Bridge Considerations'!J11)","v":""},{"$f":"IF('Bridge Considerations'!K11=\"\",\"\",'Bridge Considerations'!K11)","v":""}]
[{"$f":"IF('Bridge Considerations'!A12=\"\",\"\",'Bridge Considerations'!A12)","v":""},{"$f":"IF('Bridge Considerations'!B12=\"\",\"\",'Bridge Considerations'!B12)","v":""},{"$f":"IF('Bridge Considerations'!C12=\"\",\"\",'Bridge Considerations'!C12)","v":""},{"$f":"IF('Bridge Considerations'!D12=\"\",\"\",'Bridge Considerations'!D12)","v":""},{"$f":"IF('Bridge Considerations'!E12=\"\",\"\",'Bridge Considerations'!E12)","v":""},{"$f":"IF('Bridge Considerations'!F12=\"\",\"\",'Bridge Considerations'!F12)","v":""},{"$f":"IF('Bridge Considerations'!G12=\"\",\"\",'Bridge Considerations'!G12)","v":""},{"$f":"IF('Bridge Considerations'!H12=\"\",\"\",'Bridge Considerations'!H12)","v":""},{"$f":"IF('Bridge Considerations'!I12=\"\",\"\",'Bridge Considerations'!I12)","v":""},{"$f":"IF('Bridge Considerations'!J12=\"\",\"\",'Bridge Considerations'!J12)","v":""},{"$f":"IF('Bridge Considerations'!K12=\"\",\"\",'Bridge Considerations'!K12)","v":""}]

{"sheet":"Instructions","index":1,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,2,12],[7,8,7,12],[6,8,6,12],[7,0,7,4],[32,1,32,4],[6,0,6,4],[22,0,23,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[24,5,27,7],[36,0,37,4],[36,8,37,12],[39,1,39,4],[38,1,38,4],[33,1,33,4],[31,5,32,7],[32,8,32,12],[33,8,33,12],[22,8,23,12],[26,8,26,12],[24,8,24,12],[25,8,25,12],[27,8,27,12],[28,8,28,12],[29,8,29,12],[30,8,30,12],[31,8,31,12],[40,1,40,4],[41,1,41,4],[42,1,42,4],[43,1,43,4],[44,1,44,4]]}
["Thank you for completing this project's deficiencies!! "]
[]
[]
[]
[]
[]
["Controlling Criteria",null,null,null,null,null,null,null,"Controlling Criteria "]
["High Speed (50mph & <)",null,null,null,null,null,null,null,"Low Speed (<50 mph)"]
[1,"Design Speed",null,null,null,null,null,null,1,"Design Speed"]
[2,"Design Loading Structural Capacity",null,null,null,null,null,null,2,"Design Loading Structural Capacity"]
[3,"Lane Width"]
[4,"Shoulder Width"]
[5,"Horizontal Curve Radius"]
[6,"Superelevation Rate"]
[7,"Stopping Sight Distance"]
[8,"Maximum Grade"]
[9,"Cross Slope"]
[10,"Vertical Clearance"]
[]
[]
[]
[]
["Things to take into consideration when finding standards:",null,null,null,null,null,null,null,"Creating the Power Point"]
[null,null,null,null,null,"Links"]
[1,"Is the roadway NHS or not? If the roadway is a principal arterial it is considered NHS ",null,null,null,"FDM:11-4-10.4 .3,1.0 Project Description and Need",null,null,"Only show items listed in the controlling criteria "]
[2,"Is it a long truck route?",null,null,null,null,null,null,"List as built that deficiencies were found on"]
[3,"Is it a Federal truck route?",null,null,null,null,null,null,"Add only deficiencies that are not meeting minimums/maximums"]
[4,"Is it a Federal truck route?",null,null,null,null,null,null,"Save copy in the traffic folder"]
[5,"Design classification",null,null,null,null,null,null,"check off that it is complete in the excel sheet"]
[6,"Interstate vs non interstate (4R vs 3R)"]
[7,"Express Way"]
[8,"Windtower Route",null,null,null,"http://dotnet/dtsd/maintenance/freight.htm"]
[9,"High Route"]
[10]
[]
[]
["Filling out the Controlling Criteria Worksheet",null,null,null,null,null,null,null,"File Saving"]
[]
[1,"Save template in the Scoping folder to the Project folder under Traffic"]
[2,"Find all controlling criteria that is outside the minimum or maximum"]
[3,"Fill out controlling criteria worksheet"]
[4,"PDPs can be found here:"]
[5,"RPS can be found here:"]
[6,"Save copy in Traffic"]
[7,"check off that it is complete on the scoping excel sheet"]

{"sheet":"Grade Checks","index":2,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,1,6,5],[3,0,3,5],[4,1,4,5],[5,1,5,5],[0,1,0,8],[1,1,1,8],[2,1,2,8]]}
["Project ID:",{"$f":"IF(Deficiencies!B1=\"\",\"\",Deficiencies!B1)","v":"1440-39-30"}]
["Description:",{"$f":"IF(Deficiencies!B2=\"\",\"\",Deficiencies!B2)","v":"FDL - Plymouth, USH 151 - CTH UU"},null,null,null,null,null,null,null,null,null,null,null,"3R Projects: Design Speed = Posted Speed"]
["Highway:",{"$f":"IF(Deficiencies!B3=\"\",\"\",Deficiencies!B3)","v":"STH 23"}]
["Maximum Grade Check (FDM 11-10 Attatchment 5.3)"]
["Type of Roadway: ","Principal Arterial"]
["Type of Terrain:","Level"]
["Design Speed(s):","35 MPH, 45 MPH, 55 MPH"]
["Asbuilt","Location","Grade","Design Speed","Maximum Grade","Grade: Pass/Fail","Comments","Key"]
["1442-01-73","STH 23 EB, to 2040' East of CTH K",7.0000000000000007E-2,45,0.04,{"$f":"IF(C9=\"\",\"\",IF(E9>ABS(C9),\"Pass\",\"Fail\"))","v":"Fail"},"Not controlling, Deisgn Speed less than 50 MPH",1]
["1442-01-73","STH 23 EB, from 2040' East of CTH K",-4.1000000000000003E-3,55,0.03,{"$f":"IF(C10=\"\",\"\",IF(E10>ABS(C10),\"Pass\",\"Fail\"))","v":"Pass"},null,2]
["1442-01-73","STH 23, from 3640' East of CTH K",4.9919999999999999E-2,55,0.03,"Fail",null,3]
["1442-01-73","STH 23, from 1790' West of CTH UU",-7.8499999999999993E-3,55,0.03,"Pass",null,4]
["1442-01-73","STH 23, 840' West of CTH UU - CTH UU",3.5799999999999998E-3,55,0.03,"Pass",null,5]
[null,null,null,null,null,"",null,6]
[null,null,null,null,null,"",null,7]
[null,null,null,null,null,"",null,8]
[null,null,null,null,null,"",null,9]
[null,null,null,null,null,"",null,10]
[null,null,null,null,null,"",null,11]
[null,null,null,null,null,"",null,12]
[]
["Asbuilts"]
["1442-01-73"]

{"sheet":"Vertical Curve Checks","index":3,"n_rows":47,"n_cols":25,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,0,3,10],[0,1,0,7],[1,1,1,7],[2,1,2,7],[34,18,35,18],[19,4,20,4],[34,0,35,0],[34,4,35,4],[4,12,4,13],[19,0,20,0],[19,2,20,2],[19,1,20,1],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[19,17,20,17],[19,6,20,6],[19,7,20,7],[19,5,20,5],[19,8,20,8],[19,9,20,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,20,16],[34,21,35,21],[33,1,33,21],[34,5,35,5],[34,6,35,6],[34,7,35,7],[34,8,35,8],[34,9,35,9],[34,10,34,11],[34,12,34,13],[34,14,34,15],[34,16,35,16],[34,17,35,17],[34,1,35,1],[34,2,35,2],[34,3,35,3],[34,19,35,19],[18,22,20,22],[33,22,35,22],[4,22,5,22],[18,1,18,21],[4,21,5,21],[19,18,20,18],[19,21,20,21],[19,19,20,19],[19,20,20,20],[19,3,20,3],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[34,20,35,20],[4,0,5,0],[4,20,5,20],[4,19,5,19],[4,18,5,18],[4,16,5,16],[4,17,5,17],[4,10,4,11],[4,14,4,15]]}
["Project ID:",{"$f":"IF(Deficiencies!B1=\"\",\"\",Deficiencies!B1)","v":"1440-39-30"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
["Description:",{"$f":"IF(Deficiencies!B2=\"\",\"\",Deficiencies!B2)","v":"FDL - Plymouth, USH 151 - CTH UU"},null,null,null,null,null,null,null,null,null,null,"3R Projects: Design Speed = Posted Speed"]
["Highway:",{"$f":"IF(Deficiencies!B3=\"\",\"\",Deficiencies!B3)","v":"STH 23"}]
["Vertical Curve Checks (FDM 11-10 Exhibit 5.4)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rows",4]
["Asbuilt","Location","PI","Desgin Speed","Curve Type","L","G1","G2","A","K","Crest (6\"Object)",null,"Crest (24\" Object)",null,"Sag",null,"Desirable S","K","k-Check","Sight Distance Check","Combined Pass/Fail","Comment","Key"]
[null,null,null,null,null,null,null,null,null,null,"S, (S>L)","S,(S<L)","S, (S>L)","S,(S<L)","S,  (S>L)","S,  (S<L)"]
["1442-01-73","STH 23 WB, 2040' East of CTH K","157+00",45,"crest",1450,7,-0.41,{"$f":"IF(H7=\"\",\"\",ABS(H7-G7))","v":7.41},{"$f":"IF(F7=\"\",\"\",F7/I7)","v":195.68151147098516},{"$f":"IF(AND($E7=\"Crest\",$F7<$Q7),(((1329/$I7)+$F7)/2),\"\")","v":""},{"$f":"IF(AND($E7=\"Crest\",$F7>$Q7),(((1329*F7)/I7)^(1/2)),\"\")","v":509.96149731615941},{"$f":"IF(AND($E7=\"Crest\",$F7<$Q7),(((2158/$I7)+$F7)/2),\"\")","v":""},{"$f":"IF(AND($E7=\"Crest\",$F7>$Q7),(((2158*$F7)/$I7)^(1/2)),\"\")","v":649.83128714642999},{"$f":"IF(AND($E7=\"Sag\",$F7<$Q7),((I7*F7)+400)/((2*I7)-3.5),\"\")","v":""},{"$f":"IF(AND($E7=\"Sag\",$F7>$Q7),((SQRT(49*F7^2+6400*I7*F7)+7*F7)/(4*I7)),\"\")","v":""},360,98,{"$f":"IF(B7=\"\",\"\",IF(J7>R7, \"Pass\",\"Fail\"))","v":"Pass"},{"$f":"IF(I7=\"\",\"\",IF(E7=\"Crest\",IF(F7<Q7,IF(K7>Q7,IF(M7>Q7,\"Both Pass\",\"6-In Pass/24-In Fail\"),IF(M7>Q7,\"6-In Fail/ 24-In Pass\",\"Both Fail\")),IF(L7>Q7,IF(N7>Q7,\"Both Pass\",\"6-In Pass/24-In Fail\"),IF(N7>Q7,\"6-In Fail/24-In Pass\",\"Both Fail\"))),IF(F7<Q7,IF(O7>Q7,\"Pass\",\"Fail\"),IF(P7>Q7,\"Pass\",\"Fail\"))))","v":"Both Pass"},{"$f":"IF(T7=\"\",\"\",IF(S7=\"Pass\",IF(OR(T7=\"Both Pass\",T7=\"Pass\"),\"Both Pass\",IF(T7=\"6-In Pass/24-In Fail\",\"K Pass/SSD Min Pass\",\"K Pass/ SSD Fail\")),IF(OR(T7=\"Pass\",T7=\"Both Pass\"),\"K Fail/ SSD Pass\",IF(T7=\"6-In Pass/24-In Fail\",\"K Fail/SSD Min Pass\",\"Both Fail\"))))","v":"Both Pass"},null,1]
["1442-01-73","STH 23 EB, 2040' East of CTH K","157+00",45,"crest",1450,7,-0.41,{"$f":"IF(H8=\"\",\"\",ABS(H8-G8))","v":7.41},{"$f":"IF(F8=\"\",\"\",F8/I8)","v":195.68151147098516},{"$f":"IF(AND($E8=\"Crest\",$F8<$Q8),(((1329/$I8)+$F8)/2),\"\")","v":""},{"$f":"IF(AND($E8=\"Crest\",$F8>$Q8),(((1329*F8)/I8)^(1/2)),\"\")","v":509.96149731615941},{"$f":"IF(AND($E8=\"Crest\",$F8<$Q8),(((2158/$I8)+$F8)/2),\"\")","v":""},{"$f":"IF(AND($E8=\"Crest\",$F8>$Q8),(((2158*$F8)/$I8)^(1/2)),\"\")","v":649.83128714642999},{"$f":"IF(AND($E8=\"Sag\",$F8<$Q8),((I8*F8)+400)/((2*I8)-3.5),\"\")","v":""},{"$f":"IF(AND($E8=\"Sag\",$F8>$Q8),((SQRT(49*F8^2+6400*I8*F8)+7*F8)/(4*I8)),\"\")","v":""},360,98,{"$f":"IF(B8=\"\",\"\",IF(J8>R8, \"Pass\",\"Fail\"))","v":"Pass"},{"$f":"IF(I8=\"\",\"\",IF(E8=\"Crest\",IF(F8<Q8,IF(K8>Q8,IF(M8>Q8,\"Both Pass\",\"6-In Pass/24-In Fail\"),IF(M8>Q8,\"6-In Fail/ 24-In Pass\",\"Both Fail\")),IF(L8>Q8,IF(N8>Q8,\"Both Pass\",\"6-In Pass/24-In Fail\"),IF(N8>Q8,\"6-In Fail/24-In Pass\",\"Both Fail\"))),IF(F8<Q8,IF(O8>Q8,\"Pass\",\"Fail\"),IF(P8>Q8,\"Pass\",\"Fail\"))))","v":"Both Pass"},{"$f":"IF(T8=\"\",\"\",IF(S8=\"Pass\",IF(OR(T8=\"Both Pass\",T8=\"Pass\"),\"Both Pass\",IF(T8=\"6-In Pass/24-In Fail\",\"K Pass/SSD Min Pass\",\"K Pass/ SSD Fail\")),IF(OR(T8=\"Pass\",T8=\"Both Pass\"),\"K Fail/ SSD Pass\",IF(T8=\"6-In Pass/24-In Fail\",\"K Fail/SSD Min Pass\",\"Both Fail\"))))","v":"Both Pass"},null,2]
["1442-01-73","STH 23, 3640' East of CTH K","173+00",55,"sag",1100,-0.41,4.992,5.4020000000000001,203.62828582006665,"","","","","",812.89772393613407,495,115,"Pass","Pass","Both Pass",null,3]
["1442-01-73","STH 23, 1790' West of CTH UU","185+50",55,"crest",1200,4.992,-0.78500000000000003,5.7770000000000001,207.72027003635105,"",525.41434970726732,"",669.52247366197173,"","",495,185,"Pass","Both Pass","Both Pass",null,4]
["1442-01-73","STH 23, 840' West of CTH UU","195+00",55,"sag",300,-0.78500000000000003,0.35799999999999998,1.143,262.46719160104988,"","","","","",1021.4203524253682,null,115,"Pass","Pass","Both Pass",null,5]
[null,null,null,null,null,null,null,null,"","","","","","","","",null,null,"","","",null,6]
[null,null,null,null,null,null,null,null,"","","","","","","","",null,null,"","","",null,7]
[null,null,null,null,null,null,null,null,"","","","","","","","",null,null,"","","",null,8]
[null,null,null,null,null,null,null,null,"","","","","","","","",null,null,"","","",null,9]
[null,null,null,null,null,null,null,null,"","","","","","","","",null,null,"","","",null,10]
[null,null,null,null,null,null,null,null,"","","","","","","","",null,null,"","","",null,11]
[]
[null,"Design Speed Testing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key"]
["Asbuilt","Location","Pass/Fail","Desgin Speed","Curve Type","L","G1","G2","A","K","Crest (6\"Object)",null,"Crest (24\" Object)",null,"Sag",null,"Desirable S","K","k-Check","Sight Distance Check","Combined Pass/Fail","Comment"]
[null,null,null,null,null,null,null,null,null,null,"S, (S>L)","S,(S<L)","S, (S>L)","S,(S<L)","S,  (S>L)","S,  (S<L)"]
[{"$f":"IF(A7=\"\",\"\",A7)","v":"1442-01-73"},{"$f":"B7","v":"STH 23 WB, 2040' East of CTH K"},{"$f":"IF(OR(U7=\"Both Pass\", U7=\"K Pass/SSD Min Pass\"),\"Pass\",\"More Checks Required\")","v":"Pass"},null,{"$f":"IF(E7=\"\",\"\",E7)","v":"crest"},{"$f":"IF(F7=\"\",\"\",F7)","v":1450},{"$f":"IF(G7=\"\",\"\",G7)","v":7},{"$f":"IF(H7=\"\",\"\",H7)","v":-0.41},{"$f":"IF(H22=\"\",\"\",ABS(H22-G22))","v":7.41},{"$f":"IF(F22=\"\",\"\",F22/I22)","v":195.68151147098516},{"$f":"IF(AND($E22=\"Crest\",$F22<$Q22),(((1329/$I22)+$F22)/2),\"\")","v":""},{"$f":"IF(AND($E22=\"Crest\",$F22>$Q22),(((1329*F22)/I22)^(1/2)),\"\")","v":509.96149731615941},{"$f":"IF(AND($E22=\"Crest\",$F22<$Q22),(((2158/$I22)+$F22)/2),\"\")","v":""},{"$f":"IF(AND($E22=\"Crest\",$F22>$Q22),(((2158*$F22)/$I22)^(1/2)),\"\")","v":649.83128714642999},{"$f":"IF(AND($E22=\"Sag\",$F22<$Q22),((I22*F22)+400)/((2*I22)-3.5),\"\")","v":""},{"$f":"IF(AND($E22=\"Sag\",$F22>$Q22),((SQRT(49*F22^2+6400*I22*F22)+7*F22)/(4*I22)),\"\")","v":""},null,null,{"$f":"IF(R22=\"\",\"\",IF(OR(B22=\"\",C22=\"Pass\"),\"Pass\",IF(J22>R22, \"Pass\",\"Fail\")))","v":""},{"$f":"IF(OR(C22=\"Pass\",C22=\"\"),\"Pass\",IF(I22=\"\",\"\",IF(E22=\"Crest\",IF(F22<Q22,IF(K22>Q22,IF(M22>Q22,\"Both Pass\",\"6-In Pass/24-In Fail\"),IF(M22>Q22,\"6-In Fail/ 24-In Pass\",\"Both Fail\")),IF(L22>Q22,IF(N22>Q22,\"Both Pass\",\"6-In Pass/24-In Fail\"),IF(N22>Q22,\"6-In Fail/24-In Pass\",\"Both Fail\"))),IF(F22<Q22,IF(O22>Q22,\"Pass\",\"Fail\"),IF(P22>Q22,\"Pass\",\"Fail\")))))","v":"Pass"},{"$f":"IF(C22=\"Pass\",\"Pass\",IF(T22=\"\",\"\",IF(S22=\"Pass\",IF(OR(T22=\"Both Pass\",T22=\"Pass\"),\"Both Pass\",IF(T22=\"6-In Pass/24-In Fail\",\"K Pass/SSD Min Pass\",\"K Pass/ SSD Fail\")),IF(OR(T22=\"Pass\",T22=\"Both Pass\"),\"K Fail/ SSD Pass\",IF(T22=\"6-In Pass/24-In Fail\",\"K Fail/SSD Min Pass\",\"Both Fail\")))))","v":"Pass"},null,{"$f":"W7","v":1}]
[{"$f":"IF(A8=\"\",\"\",A8)","v":"1442-01-73"},{"$f":"B8","v":"STH 23 EB, 2040' East of CTH K"},{"$f":"IF(OR(U8=\"Both Pass\", U8=\"K Pass/SSD Min Pass\"),\"Pass\",\"More Checks Required\")","v":"Pass"},null,{"$f":"IF(E8=\"\",\"\",E8)","v":"crest"},1450,7,-0.41,{"$f":"IF(H23=\"\",\"\",ABS(H23-G23))","v":7.41},{"$f":"IF(F23=\"\",\"\",F23/I23)","v":195.68151147098516},{"$f":"IF(AND($E23=\"Crest\",$F23<$Q23),(((1329/$I23)+$F23)/2),\"\")","v":""},{"$f":"IF(AND($E23=\"Crest\",$F23>$Q23),(((1329*F23)/I23)^(1/2)),\"\")","v":509.96149731615941},{"$f":"IF(AND($E23=\"Crest\",$F23<$Q23),(((2158/$I23)+$F23)/2),\"\")","v":""},649.83128714642999,{"$f":"IF(AND($E23=\"Sag\",$F23<$Q23),((I23*F23)+400)/((2*I23)-3.5),\"\")","v":""},{"$f":"IF(AND($E23=\"Sag\",$F23>$Q23),((SQRT(49*F23^2+6400*I23*F23)+7*F23)/(4*I23)),\"\")","v":""},null,null,{"$f":"IF(R23=\"\",\"\",IF(OR(B23=\"\",C23=\"Pass\"),\"Pass\",IF(J23>R23, \"Pass\",\"Fail\")))","v":""},{"$f":"IF(OR(C23=\"Pass\",C23=\"\"),\"Pass\",IF(I23=\"\",\"\",IF(E23=\"Crest\",IF(F23<Q23,IF(K23>Q23,IF(M23>Q23,\"Both Pass\",\"6-In Pass/24-In Fail\"),IF(M23>Q23,\"6-In Fail/ 24-In Pass\",\"Both Fail\")),IF(L23>Q23,IF(N23>Q23,\"Both Pass\",\"6-In Pass/24-In Fail\"),IF(N23>Q23,\"6-In Fail/24-In Pass\",\"Both Fail\"))),IF(F23<Q23,IF(O23>Q23,\"Pass\",\"Fail\"),IF(P23>Q23,\"Pass\",\"Fail\")))))","v":"Pass"},{"$f":"IF(C23=\"Pass\",\"Pass\",IF(T23=\"\",\"\",IF(S23=\"Pass\",IF(OR(T23=\"Both Pass\",T23=\"Pass\"),\"Both Pass\",IF(T23=\"6-In Pass/24-In Fail\",\"K Pass/SSD Min Pass\",\"K Pass/ SSD Fail\")),IF(OR(T23=\"Pass\",T23=\"Both Pass\"),\"K Fail/ SSD Pass\",IF(T23=\"6-In Pass/24-In Fail\",\"K Fail/SSD Min Pass\",\"Both Fail\")))))","v":"Pass"},null,{"$f":"W8","v":2}]
["1442-01-73","STH 23, 3640' East of CTH K","Pass",null,{"$f":"IF(E9=\"\",\"\",E9)","v":"sag"},1100,-0.41,4.992,5.4020000000000001,203.62828582006665,"","","","","",812.89772393613407,null,null,"","Pass","Pass",null,3]
["1442-01-73","STH 23, 1790' West of CTH UU","Pass",null,{"$f":"IF(E10=\"\",\"\",E10)","v":"crest"},1200,4.992,-0.78500000000000003,5.7770000000000001,207.72027003635105,"",525.41434970726732,"",669.52247366197173,"","",null,null,"","Pass","Pass",null,4]
["1442-01-73","STH 23, 840' West of CTH UU","Pass",null,{"$f":"IF(E11=\"\",\"\",E11)","v":"sag"},300,-0.78500000000000003,0.35799999999999998,1.143,262.46719160104988,"","","","","",1021.4203524253682,null,null,"","Pass","Pass",null,5]
["",0,"More Checks Required",null,{"$f":"IF(E12=\"\",\"\",E12)","v":""},"","","","","","","","","","","",null,null,"","","",null,6]
["",0,"More Checks Required",null,{"$f":"IF(E13=\"\",\"\",E13)","v":""},"","","","","","","","","","","",null,null,"","","",null,7]
["",0,"More Checks Required",null,{"$f":"IF(E14=\"\",\"\",E14)","v":""},"","","","","","","","","","","",null,null,"","","",null,8]
["",0,"More Checks Required",null,{"$f":"IF(E15=\"\",\"\",E15)","v":""},"","","","","","","","","","","",null,null,"","","",null,9]
["",0,"More Checks Required",null,{"$f":"IF(E16=\"\",\"\",E16)","v":""},"","","","","","","","","","","",null,null,"","","",null,10]
["",0,"More Checks Required",null,{"$f":"IF(E17=\"\",\"\",E17)","v":""},"","","","","","","","","","","",null,null,"","","",null,11]
[]
[null,"Extending Length of Curve Testing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key"]
["Asbuilt","Location","Pass/Fail","Desgin Speed","Curve Type","L","G1","G2","A","K","Crest (6\"Object)",null,"Crest (24\" Object)",null,"Sag",null,"Desirable S","K","k-Check","Sight Distance Check","Combined Pass/Fail","Comment"]
[null,null,null,null,null,null,null,null,null,null,"S, (S>L)","S,(S<L)","S, (S>L)","S,(S<L)","S,  (S>L)","S,  (S<L)"]
[{"$f":"IF(A22=\"\",\"\",A22)","v":"1442-01-73"},{"$f":"B22","v":"STH 23 WB, 2040' East of CTH K"},{"$f":"IF(OR(U22=\"Both Pass\", U22=\"K Pass/SSD Min Pass\"),\"Pass\",\"More Checks Required\")","v":"More Checks Required"},{"$f":"IF(D7=\"\",\"\",D7)","v":45},{"$f":"IF(E22=\"\",\"\",E22)","v":"crest"},null,{"$f":"IF(G22=\"\",\"\",G22)","v":7},{"$f":"IF(H22=\"\",\"\",H22)","v":-0.41},{"$f":"IF(H37=\"\",\"\",ABS(H37-G37))","v":7.41},{"$f":"IF(F37=\"\",\"\",F37/I37)","v":""},{"$f":"IF(AND($E37=\"Crest\",$F37<$Q37),(((1329/$I37)+$F37)/2),\"\")","v":89.676113360323882},{"$f":"IF(AND($E37=\"Crest\",$F37>$Q37),(((1329*F37)/I37)^(1/2)),\"\")","v":""},{"$f":"IF(AND($E37=\"Crest\",$F37<$Q37),(((2158/$I37)+$F37)/2),\"\")","v":145.61403508771929},{"$f":"IF(AND($E37=\"Crest\",$F37>$Q37),(((2158*$F37)/$I37)^(1/2)),\"\")","v":""},{"$f":"IF(AND($E37=\"Sag\",$F37<$Q37),((I37*F37)+400)/((2*I37)-3.5),\"\")","v":""},{"$f":"IF(AND($E37=\"Sag\",$F37>$Q37),((SQRT(49*F37^2+6400*I37*F37)+7*F37)/(4*I37)),\"\")","v":""},{"$f":"IF(Q7=\"\",\"\",Q7)","v":360},{"$f":"IF(R7=\"\",\"\",R7)","v":98},{"$f":"IF(R37=\"\",\"\",IF(OR(B37=\"\",C37=\"Pass\"),\"Pass\",IF(J37>R37, \"Pass\",\"Fail\")))","v":"Pass"},{"$f":"IF(OR(C37=\"Pass\",C37=\"\"),\"Pass\",IF(I37=\"\",\"\",IF(E37=\"Crest\",IF(F37<Q37,IF(K37>Q37,IF(M37>Q37,\"Both Pass\",\"6-In Pass/24-In Fail\"),IF(M37>Q37,\"6-In Fail/ 24-In Pass\",\"Both Fail\")),IF(L37>Q37,IF(N37>Q37,\"Both Pass\",\"6-In Pass/24-In Fail\"),IF(N37>Q37,\"6-In Fail/24-In Pass\",\"Both Fail\"))),IF(F37<Q37,IF(O37>Q37,\"Pass\",\"Fail\"),IF(P37>Q37,\"Pass\",\"Fail\")))))","v":"Both Fail"},{"$f":"IF(C37=\"Pass\",\"Pass\",IF(T37=\"\",\"\",IF(S37=\"Pass\",IF(OR(T37=\"Both Pass\",T37=\"Pass\"),\"Both Pass\",IF(T37=\"6-In Pass/24-In Fail\",\"K Pass/SSD Min Pass\",\"K Pass/ SSD Fail\")),IF(OR(T37=\"Pass\",T37=\"Both Pass\"),\"K Fail/ SSD Pass\",IF(T37=\"6-In Pass/24-In Fail\",\"K Fail/SSD Min Pass\",\"Both Fail\")))))","v":"K Pass/ SSD Fail"},null,{"$f":"W7","v":1}]
[{"$f":"IF(A23=\"\",\"\",A23)","v":"1442-01-73"},{"$f":"B23","v":"STH 23 EB, 2040' East of CTH K"},{"$f":"IF(OR(U23=\"Both Pass\", U23=\"K Pass/SSD Min Pass\"),\"Pass\",\"More Checks Required\")","v":"More Checks Required"},{"$f":"IF(D8=\"\",\"\",D8)","v":45},{"$f":"IF(E23=\"\",\"\",E23)","v":"crest"},null,{"$f":"IF(G23=\"\",\"\",G23)","v":7},-0.41,{"$f":"IF(H38=\"\",\"\",ABS(H38-G38))","v":7.41},{"$f":"IF(F38=\"\",\"\",F38/I38)","v":""},{"$f":"IF(AND($E38=\"Crest\",$F38<$Q38),(((1329/$I38)+$F38)/2),\"\")","v":89.676113360323882},{"$f":"IF(AND($E38=\"Crest\",$F38>$Q38),(((1329*F38)/I38)^(1/2)),\"\")","v":""},{"$f":"IF(AND($E38=\"Crest\",$F38<$Q38),(((2158/$I38)+$F38)/2),\"\")","v":145.61403508771929},"",{"$f":"IF(AND($E38=\"Sag\",$F38<$Q38),((I38*F38)+400)/((2*I38)-3.5),\"\")","v":""},{"$f":"IF(AND($E38=\"Sag\",$F38>$Q38),((SQRT(49*F38^2+6400*I38*F38)+7*F38)/(4*I38)),\"\")","v":""},{"$f":"IF(Q8=\"\",\"\",Q8)","v":360},98,{"$f":"IF(R38=\"\",\"\",IF(OR(B38=\"\",C38=\"Pass\"),\"Pass\",IF(J38>R38, \"Pass\",\"Fail\")))","v":"Pass"},{"$f":"IF(OR(C38=\"Pass\",C38=\"\"),\"Pass\",IF(I38=\"\",\"\",IF(E38=\"Crest\",IF(F38<Q38,IF(K38>Q38,IF(M38>Q38,\"Both Pass\",\"6-In Pass/24-In Fail\"),IF(M38>Q38,\"6-In Fail/ 24-In Pass\",\"Both Fail\")),IF(L38>Q38,IF(N38>Q38,\"Both Pass\",\"6-In Pass/24-In Fail\"),IF(N38>Q38,\"6-In Fail/24-In Pass\",\"Both Fail\"))),IF(F38<Q38,IF(O38>Q38,\"Pass\",\"Fail\"),IF(P38>Q38,\"Pass\",\"Fail\")))))","v":"Both Fail"},{"$f":"IF(C38=\"Pass\",\"Pass\",IF(T38=\"\",\"\",IF(S38=\"Pass\",IF(OR(T38=\"Both Pass\",T38=\"Pass\"),\"Both Pass\",IF(T38=\"6-In Pass/24-In Fail\",\"K Pass/SSD Min Pass\",\"K Pass/ SSD Fail\")),IF(OR(T38=\"Pass\",T38=\"Both Pass\"),\"K Fail/ SSD Pass\",IF(T38=\"6-In Pass/24-In Fail\",\"K Fail/SSD Min Pass\",\"Both Fail\")))))","v":"K Pass/ SSD Fail"},null,{"$f":"W8","v":2}]
["1442-01-73","STH 23, 3640' East of CTH K","More Checks Required",55,"sag",null,{"$f":"IF(G24=\"\",\"\",G24)","v":-0.41},4.992,5.4020000000000001,"","","","","",54.764512595837893,"",{"$f":"IF(Q9=\"\",\"\",Q9)","v":495},115,"Pass","Fail","K Pass/ SSD Fail",null,3]
["1442-01-73","STH 23, 1790' West of CTH UU","More Checks Required",55,"crest",null,{"$f":"IF(G25=\"\",\"\",G25)","v":4.992},-0.78500000000000003,5.7770000000000001,"",115.02509953262938,"",186.77514280768565,"","","",{"$f":"IF(Q10=\"\",\"\",Q10)","v":495},185,"Pass","Both Fail","K Pass/ SSD Fail",null,4]
["1442-01-73","STH 23, 840' West of CTH UU","More Checks Required",55,"sag",null,{"$f":"IF(G26=\"\",\"\",G26)","v":-0.78500000000000003},0.35799999999999998,1.143,"","","","","","","",{"$f":"IF(Q11=\"\",\"\",Q11)","v":""},115,"Pass","Fail","K Pass/ SSD Fail",null,5]
["",0,"More Checks Required","","",null,{"$f":"IF(G27=\"\",\"\",G27)","v":""},"","","","","","","","","",{"$f":"IF(Q12=\"\",\"\",Q12)","v":""},"","","","",null,6]
["",0,"More Checks Required","","",null,{"$f":"IF(G28=\"\",\"\",G28)","v":""},"","","","","","","","","",{"$f":"IF(Q13=\"\",\"\",Q13)","v":""},"","","","",null,7]
["",0,"More Checks Required","","",null,{"$f":"IF(G29=\"\",\"\",G29)","v":""},"","","","","","","","","",{"$f":"IF(Q14=\"\",\"\",Q14)","v":""},"","","","",null,8]
["",0,"More Checks Required","","",null,{"$f":"IF(G30=\"\",\"\",G30)","v":""},"","","","","","","","","",{"$f":"IF(Q15=\"\",\"\",Q15)","v":""},"","","","",null,9]
["",0,"More Checks Required","","",null,{"$f":"IF(G31=\"\",\"\",G31)","v":""},"","","","","","","","","",{"$f":"IF(Q16=\"\",\"\",Q16)","v":""},"","","","",null,10]
["",0,"More Checks Required","","",null,{"$f":"IF(G32=\"\",\"\",G32)","v":""},"","","","","","","","","",{"$f":"IF(Q17=\"\",\"\",Q17)","v":""},"","","","",null,11]

{"sheet":"Horizontal Curve","index":4,"n_rows":34,"n_cols":25,"rows_kept":34,"cut":false,"hidden":false,"merged":[[18,7,20,7],[0,1,0,7],[1,1,1,7],[2,1,2,7],[5,17,6,17],[5,12,6,12],[5,13,6,13],[5,8,6,8],[5,16,6,16],[19,3,19,6],[19,0,19,2],[18,0,18,6],[3,0,3,6],[5,0,6,0],[5,7,6,7],[5,14,6,14],[5,11,6,11],[5,15,6,15],[4,19,6,19],[5,18,6,18],[4,10,4,18],[5,10,6,10],[5,6,6,6],[5,9,6,9],[4,0,4,6],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5]]}
["Project ID:",{"$f":"IF(Deficiencies!B1=\"\",\"\",Deficiencies!B1)","v":"1440-39-30"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Description:",{"$f":"IF(Deficiencies!B2=\"\",\"\",Deficiencies!B2)","v":"FDL - Plymouth, USH 151 - CTH UU"},null,null,null,null,null,null,null,null,"3R Projects: Design Speed = Posted Speed"]
["Highway:",{"$f":"IF(Deficiencies!B3=\"\",\"\",Deficiencies!B3)","v":"STH 23"}]
["Horizontal Curve Checks (FDM 11-10 Attatchment 5.1 - 5.14)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rows",5]
["Existing Conditions",null,null,null,null,null,null,null,null,null,"Minimum Required or Maximum e% For Speed",null,null,null,null,null,null,null,null,"Key"]
["Asbuilt Plan","Location","PI (STA)","Posted Speed","Design Speed","R \n(curve radius)","RO\n(Superelevation runoff length)","e \n(Superelevation)","SE (T) \n(Superelevation Transition)","Degree of Curve (D),(Degrees, Minutes)","Design Speed","e% \n(Superelevation)","R, min","L, min","X\n(Superelevation runoff length)","SE (T) \n(Superelevation Transition)","Degree of Curve (D),(Degrees, Minutes)","Current Super Pass/Fail","Existing Alignment Pass/Fail"]
[]
["1442-01-73","2050' east of CTH K","157+00.15",45,{"$f":"IF(D8=\"\",\"\",D8+5)","v":50},5729.58,null,3.2000000000000001E-2,108.93,1,{"$f":"IF(E8=\"\",\"\",E8)","v":50},0,643,200,67,267,null,{"$f":"IF(L8=\"\",\"\",IF(L8<=H8,\"Pass\",\"Fail\"))","v":"Pass"},{"$f":"IF(M8=\"\",\"\",IF(F8>M8,\"Pass\",\"Fail\"))","v":"Pass"},1]
["1442-01-73","3100' east of CTH K","167+52.50",55,{"$f":"IF(D9=\"\",\"\",D9+5)","v":60},5729.58,null,3.2000000000000001E-2,108.9,1,{"$f":"IF(E9=\"\",\"\",E9)","v":60},2.4E-2,1060,230,77,307,null,{"$f":"IF(L9=\"\",\"\",IF(L9<=H9,\"Pass\",\"Fail\"))","v":"Pass"},{"$f":"IF(M9=\"\",\"\",IF(F9>M9,\"Pass\",\"Fail\"))","v":"Pass"},2]
["1442-01-73","3988' east of CTH K","176+38.20",55,60,5729.58,null,3.2000000000000001E-2,108.9,1,60,2.4E-2,1060,230,77,307,null,"Pass","Pass",3]
[null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,"","",4]
[null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,"","",5]
[null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,"","",6]
[null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,"","",7]
[null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,"","",8]
[null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,"","",9]
[null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,"","",10]
[]
["Secondary Failure Testing",null,null,null,null,null,null,"Key"]
["Existing Conditions",null,null,"Design Speed Test"]
["Location","Existing Alignment Pass/Fail","R (Curve Radius)","Max Design Speed","Minimum e%","R, Min","Pass/Fail"]
[{"$f":"IF(B8=\"\",\"\",B8)","v":"2050' east of CTH K"},{"$f":"S8","v":"Pass"},{"$f":"F8","v":5729.58},null,null,null,{"$f":"IF(A22=\"\",\"\",IF(B22=\"Pass\",\"Pass\",IF(F22<C22,\"Pass\",\"Fail\")))","v":"Pass"},{"$f":"T8","v":1}]
[{"$f":"IF(B9=\"\",\"\",B9)","v":"3100' east of CTH K"},{"$f":"S9","v":"Pass"},{"$f":"F9","v":5729.58},null,null,null,{"$f":"IF(A23=\"\",\"\",IF(B23=\"Pass\",\"Pass\",IF(F23<C23,\"Pass\",\"Fail\")))","v":"Pass"},{"$f":"T9","v":2}]
["3988' east of CTH K","Pass",5729.58,null,null,null,"Pass",3]
["","",0,null,null,null,"",4]
["","",0,null,null,null,"",5]
["","",0,null,null,null,"",6]
["","",0,null,null,null,"",7]
["","",0,null,null,null,"",8]
["","",0,null,null,null,"",9]
["","",0,null,null,null,"",10]
[]
[]
[{"$f":"IF(B20=\"\",\"\",B20)","v":""}]

{"sheet":"Bridge Considerations","index":5,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,1,7],[2,1,2,7],[4,10,5,10],[4,6,4,7],[4,8,4,9],[4,5,5,5],[3,0,3,7],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4]]}
["Project ID:",{"$f":"IF(Deficiencies!B1=\"\",\"\",Deficiencies!B1)","v":"1440-39-30"}]
["Description:",{"$f":"IF(Deficiencies!B2=\"\",\"\",Deficiencies!B2)","v":"FDL - Plymouth, USH 151 - CTH UU"}]
["Highway:",{"$f":"IF(Deficiencies!B3=\"\",\"\",Deficiencies!B3)","v":"STH 23"}]
["Bridge Considerations (FDM 11-3-5.4)"]
["Structure Number","Location","Number of Lanes","Lane Width","Bridge Width","Cross Slope","Lateral Clearnce Test",null,"Vertical Clearance Test",null,"Structural Capacity"]
[null,null,null,null,null,null,"Lateral Clearance","Perferred Lateral Clearance","Vertical Clearance","Minimum Vertical Clearance"]
["None"]