{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Vertical Curve Analysis"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Vertical Curve Analysis","index":0,"n_rows":405,"n_cols":15,"rows_kept":405,"cut":false,"hidden":false,"merged":[]}
["VERTICAL CURVE",null,null,1]
["CREST",null,"VPI =",900,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"FDM 11-10-5, Attachment 5.4, Category 1"]
[null,"Station","Station","Curve (ft)",null,null,"(crest)",null,null,null,"24\" Object Height","\"K\" Value","6\" Object Height","\"K\" Value","Min. L=3V"]
[null,600,1200,{"$f":"IF(OR(B7=\"\",C7=\"\"),\"\",ABS(C7-B7))","v":600},"= L",null,"K",null,null,null,"Minimum",151,"Desirable Minimum",245,{"$f":"J2*3","v":180}]
[null,null,null,null,null,null,{"$f":"D7/D13","v":1500},null,null,"Sight Distance (S) =",570,null,570,null,"YES"]
[null,null,null,"Algebraic",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,null,null,"Difference"]
[null,"Grade 1","Grade2","in Grades",null,null,null,null,null,null,"S < L",null,"S < L"]
[null,"(%)","(%)","(g2-g1)",null,null,null,null,null,"S =",{"$f":"(SQRT(G8))*46.45","v":1799.0007643133451},"S =",{"$f":"(SQRT(G8))*36.46","v":1412.0897280272243}]
[null,0,-0.4,{"$f":"ABS(C13-B13)","v":0.4},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S > L"]
[null,null,null,"K = L/A",null,null,null,null,null,"S =",{"$f":"(1079/D13)+(D7/2)","v":2997.5},"S =",{"$f":"(665/D13)+(D7/2)","v":1962.5}]
[]
[]
["VERTICAL CURVE",null,null,2]
["SAG",null,"VPI =",2200,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,1900,2500,{"$f":"IF(OR(B24=\"\",C24=\"\"),\"\",ABS(C24-B24))","v":600},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D24/D30","v":999.99999999999989},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,-0.4,0.2,{"$f":"ABS(C30-B30)","v":0.60000000000000009},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D30*D24+400)/(2*D30-3.5)","v":-330.43478260869568},"S =",{"$f":"(3.5*D24+SQRT(12.25*D24^2+(1600*D30*D24)))/(2*D30)","v":3610.7794065928392}]
[]
["VERTICAL CURVE",null,null,3]
["SAG",null,"VPI =",3800,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,3500,4100,{"$f":"IF(OR(B41=\"\",C41=\"\"),\"\",ABS(C41-B41))","v":600},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D41/D47","v":2000},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,0.2,0.5,{"$f":"ABS(C47-B47)","v":0.3},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D47*D41+400)/(2*D47-3.5)","v":-200},"S =",{"$f":"(3.5*D41+SQRT(12.25*D41^2+(1600*D47*D41)))/(2*D47)","v":7112.4783736376903}]
[]
[]
["VERTICAL CURVE",null,null,4]
["SAG",null,"VPI =",5000,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,4700,5300,{"$f":"IF(OR(B59=\"\",C59=\"\"),\"\",ABS(C59-B59))","v":600},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D59/D65","v":1999.9999999999998},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,0.5,0.8,{"$f":"ABS(C65-B65)","v":0.30000000000000004},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D65*D59+400)/(2*D65-3.5)","v":-200},"S =",{"$f":"(3.5*D59+SQRT(12.25*D59^2+(1600*D65*D59)))/(2*D65)","v":7112.4783736376885}]
[]
[]
["VERTICAL CURVE",null,null,5]
["CREST",null,"VPI =",6800,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"FDM 11-10-5, Attachment 5.4, Category 1"]
[null,"Station","Station","Curve (ft)",null,null,"(crest)",null,null,null,"24\" Object Height","\"K\" Value","6\" Object Height","\"K\" Value","Min. L=3V"]
[null,6400,7200,{"$f":"IF(OR(B77=\"\",C77=\"\"),\"\",ABS(C77-B77))","v":800},"= L",null,"K",null,null,null,"Minimum",151,"Desirable Minimum",245,{"$f":"J72*3","v":180}]
[null,null,null,null,null,null,{"$f":"D77/D83","v":571.42857142857144},null,null,"Sight Distance (S) =",570,null,570,null,"YES"]
[null,null,null,"Algebraic",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,null,null,"Difference"]
[null,"Grade 1","Grade2","in Grades",null,null,null,null,null,null,"S < L",null,"S < L"]
[null,"(%)","(%)","(g2-g1)",null,null,null,null,null,"S =",{"$f":"(SQRT(G78))*46.45","v":1110.3673780716517},"S =",{"$f":"(SQRT(G78))*36.46","v":871.56070192663981}]
[null,0.8,-0.6,{"$f":"ABS(C83-B83)","v":1.4},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S > L"]
[null,null,null,"K = L/A",null,null,null,null,null,"S =",{"$f":"(1079/D83)+(D77/2)","v":1170.7142857142858},"S =",{"$f":"(665/D83)+(D77/2)","v":875}]
[]
[]
["VERTICAL CURVE",null,null,6]
["SAG",null,"VPI =",8650,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,8250,9050,{"$f":"IF(OR(B94=\"\",C94=\"\"),\"\",ABS(C94-B94))","v":800},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D94/D100","v":800},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,-0.6,0.4,{"$f":"ABS(C100-B100)","v":1},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D100*D94+400)/(2*D100-3.5)","v":-800},"S =",{"$f":"(3.5*D94+SQRT(12.25*D94^2+(1600*D100*D94)))/(2*D100)","v":2909.96688705415}]
[]
[]
["VERTICAL CURVE",null,null,7]
["SAG",null,"VPI =",10400,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,10200,10600,{"$f":"IF(OR(B112=\"\",C112=\"\"),\"\",ABS(C112-B112))","v":400},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D112/D118","v":1000},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,0.4,0.8,{"$f":"ABS(C118-B118)","v":0.4},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D118*D112+400)/(2*D118-3.5)","v":-207.40740740740739},"S =",{"$f":"(3.5*D112+SQRT(12.25*D112^2+(1600*D118*D112)))/(2*D118)","v":3610.7794065928397}]
[]
["VERTICAL CURVE",null,null,8]
["CREST",null,"VPI =",11250,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"FDM 11-10-5, Attachment 5.4, Category 1"]
[null,"Station","Station","Curve (ft)",null,null,"(crest)",null,null,null,"24\" Object Height","\"K\" Value","6\" Object Height","\"K\" Value","Min. L=3V"]
[null,10950,11550,{"$f":"IF(OR(B129=\"\",C129=\"\"),\"\",ABS(C129-B129))","v":600},"= L",null,"K",null,null,null,"Minimum",151,"Desirable Minimum",245,{"$f":"J124*3","v":180}]
[null,null,null,null,null,null,{"$f":"D129/D135","v":428.57142857142861},null,null,"Sight Distance (S) =",570,null,570,null,"YES"]
[null,null,null,"Algebraic",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,null,null,"Difference"]
[null,"Grade 1","Grade2","in Grades",null,null,null,null,null,null,"S < L",null,"S < L"]
[null,"(%)","(%)","(g2-g1)",null,null,null,null,null,"S =",{"$f":"(SQRT(G130))*46.45","v":961.60635694357074},"S =",{"$f":"(SQRT(G130))*36.46","v":754.79370880866713}]
[null,0.8,-0.6,{"$f":"ABS(C135-B135)","v":1.4},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S > L"]
[null,null,null,"K = L/A",null,null,null,null,null,"S =",{"$f":"(1079/D135)+(D129/2)","v":1070.7142857142858},"S =",{"$f":"(665/D135)+(D129/2)","v":775}]
[]
["VERTICAL CURVE",null,null,9]
["SAG",null,"VPI =",12033.3,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,11833.3,12233.3,{"$f":"IF(OR(B145=\"\",C145=\"\"),\"\",ABS(C145-B145))","v":400},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D145/D151","v":666.66666666666674},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,-0.6,0,{"$f":"ABS(C151-B151)","v":0.6},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D151*D145+400)/(2*D151-3.5)","v":-278.26086956521743},"S =",{"$f":"(3.5*D145+SQRT(12.25*D145^2+(1600*D151*D145)))/(2*D151)","v":2442.5106139336431}]
[]
["VERTICAL CURVE",null,null,10]
["SAG",null,"VPI =",14250,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,13950,14550,{"$f":"IF(OR(B162=\"\",C162=\"\"),\"\",ABS(C162-B162))","v":600},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D162/D168","v":600},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,0,1,{"$f":"ABS(C168-B168)","v":1},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D168*D162+400)/(2*D168-3.5)","v":-666.66666666666663},"S =",{"$f":"(3.5*D162+SQRT(12.25*D162^2+(1600*D168*D162)))/(2*D168)","v":2208.6630226256466}]
[]
[]
["VERTICAL CURVE",null,null,11]
["CREST",null,"VPI =",16100,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"FDM 11-10-5, Attachment 5.4, Category 1"]
[null,"Station","Station","Curve (ft)",null,null,"(crest)",null,null,null,"24\" Object Height","\"K\" Value","6\" Object Height","\"K\" Value","Min. L=3V"]
[null,15800,16400,{"$f":"IF(OR(B180=\"\",C180=\"\"),\"\",ABS(C180-B180))","v":600},"= L",null,"K",null,null,null,"Minimum",151,"Desirable Minimum",245,{"$f":"J175*3","v":180}]
[null,null,null,null,null,null,{"$f":"D180/D186","v":857.14285714285722},null,null,"Sight Distance (S) =",570,null,570,null,"YES"]
[null,null,null,"Algebraic",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,null,null,"Difference"]
[null,"Grade 1","Grade2","in Grades",null,null,null,null,null,null,"S < L",null,"S < L"]
[null,"(%)","(%)","(g2-g1)",null,null,null,null,null,"S =",{"$f":"(SQRT(G181))*46.45","v":1359.9167516537811},"S =",{"$f":"(SQRT(G181))*36.46","v":1067.4394997911056}]
[null,1,0.3,{"$f":"ABS(C186-B186)","v":0.7},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S > L"]
[null,null,null,"K = L/A",null,null,null,null,null,"S =",{"$f":"(1079/D186)+(D180/2)","v":1841.4285714285716},"S =",{"$f":"(665/D186)+(D180/2)","v":1250}]
[]
["VERTICAL CURVE",null,null,12]
["SAG",null,"VPI =",17950,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,17750,18150,{"$f":"IF(OR(B196=\"\",C196=\"\"),\"\",ABS(C196-B196))","v":400},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D196/D202","v":363.63636363636368},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,0.3,1.4,{"$f":"ABS(C202-B202)","v":1.0999999999999999},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D202*D196+400)/(2*D202-3.5)","v":-646.15384615384608},"S =",{"$f":"(3.5*D196+SQRT(12.25*D196^2+(1600*D202*D196)))/(2*D202)","v":1378.2620277492063}]
[]
["VERTICAL CURVE",null,null,13]
["CREST",null,"VPI =",19190,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"FDM 11-10-5, Attachment 5.4, Category 1"]
[null,"Station","Station","Curve (ft)",null,null,"(crest)",null,null,null,"24\" Object Height","\"K\" Value","6\" Object Height","\"K\" Value","Min. L=3V"]
[null,18690,19690,{"$f":"IF(OR(B213=\"\",C213=\"\"),\"\",ABS(C213-B213))","v":1000},"= L",null,"K",null,null,null,"Minimum",151,"Desirable Minimum",245,{"$f":"J208*3","v":180}]
[null,null,null,null,null,null,{"$f":"D213/D219","v":285.71428571428572},null,null,"Sight Distance (S) =",570,null,570,null,"YES"]
[null,null,null,"Algebraic",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,null,null,"Difference"]
[null,"Grade 1","Grade2","in Grades",null,null,null,null,null,null,"S < L",null,"S < L"]
[null,"(%)","(%)","(g2-g1)",null,null,null,null,null,"S =",{"$f":"(SQRT(G214))*46.45","v":785.14830264279203},"S =",{"$f":"(SQRT(G214))*36.46","v":616.28648254803431}]
[null,1.4,-2.1,{"$f":"ABS(C219-B219)","v":3.5},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S > L"]
[null,null,null,"K = L/A",null,null,null,null,null,"S =",{"$f":"(1079/D219)+(D213/2)","v":808.28571428571422},"S =",{"$f":"(665/D219)+(D213/2)","v":690}]
[]
["VERTICAL CURVE",null,null,14]
["SAG",null,"VPI =",20550,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,20350,20750,{"$f":"IF(OR(B229=\"\",C229=\"\"),\"\",ABS(C229-B229))","v":400},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D229/D235","v":307.69230769230768},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,-2.1,-0.8,{"$f":"ABS(C235-B235)","v":1.3},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D235*D229+400)/(2*D235-3.5)","v":-1022.2222222222223},"S =",{"$f":"(3.5*D229+SQRT(12.25*D229^2+(1600*D235*D229)))/(2*D235)","v":1181.1261099755516}]
[]
["VERTICAL CURVE",null,null,15]
["SAG",null,"VPI =",21400,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,21200,21600,{"$f":"IF(OR(B246=\"\",C246=\"\"),\"\",ABS(C246-B246))","v":400},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D246/D252","v":666.66666666666652},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,-0.8,-0.2,{"$f":"ABS(C252-B252)","v":0.60000000000000009},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D252*D246+400)/(2*D252-3.5)","v":-278.26086956521743},"S =",{"$f":"(3.5*D246+SQRT(12.25*D246^2+(1600*D252*D246)))/(2*D252)","v":2442.5106139336426}]
[]
["VERTICAL CURVE",null,null,16]
["SAG",null,"VPI =",23675,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,23475,23875,{"$f":"IF(OR(B263=\"\",C263=\"\"),\"\",ABS(C263-B263))","v":400},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D263/D269","v":2000},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,-0.2,0,{"$f":"ABS(C269-B269)","v":0.2},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D269*D263+400)/(2*D269-3.5)","v":-154.83870967741936},"S =",{"$f":"(3.5*D263+SQRT(12.25*D263^2+(1600*D269*D263)))/(2*D269)","v":7112.4783736376885}]
[]
["VERTICAL CURVE",null,null,17]
["SAG",null,"VPI =",35500,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,35300,35700,{"$f":"IF(OR(B280=\"\",C280=\"\"),\"\",ABS(C280-B280))","v":400},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D280/D286","v":4000},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,0,0.1,{"$f":"ABS(C286-B286)","v":0.1},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D286*D280+400)/(2*D286-3.5)","v":-133.33333333333334},"S =",{"$f":"(3.5*D280+SQRT(12.25*D280^2+(1600*D286*D280)))/(2*D286)","v":14113.367697511496}]
[]
["VERTICAL CURVE",null,null,18]
["CREST",null,"VPI =",39100,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"FDM 11-10-5, Attachment 5.4, Category 1"]
[null,"Station","Station","Curve (ft)",null,null,"(crest)",null,null,null,"24\" Object Height","\"K\" Value","6\" Object Height","\"K\" Value","Min. L=3V"]
[null,38800,39400,{"$f":"IF(OR(B297=\"\",C297=\"\"),\"\",ABS(C297-B297))","v":600},"= L",null,"K",null,null,null,"Minimum",151,"Desirable Minimum",245,{"$f":"J292*3","v":180}]
[null,null,null,null,null,null,{"$f":"D297/D303","v":1200},null,null,"Sight Distance (S) =",570,null,570,null,"YES"]
[null,null,null,"Algebraic",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,null,null,"Difference"]
[null,"Grade 1","Grade2","in Grades",null,null,null,null,null,null,"S < L",null,"S < L"]
[null,"(%)","(%)","(g2-g1)",null,null,null,null,null,"S =",{"$f":"(SQRT(G298))*46.45","v":1609.0752002314873},"S =",{"$f":"(SQRT(G298))*36.46","v":1263.0114488792256}]
[null,0.1,-0.4,{"$f":"ABS(C303-B303)","v":0.5},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S > L"]
[null,null,null,"K = L/A",null,null,null,null,null,"S =",{"$f":"(1079/D303)+(D297/2)","v":2458},"S =",{"$f":"(665/D303)+(D297/2)","v":1630}]
[]
["VERTICAL CURVE",null,null,19]
["SAG",null,"VPI =",40000,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,39700,40300,{"$f":"IF(OR(B313=\"\",C313=\"\"),\"\",ABS(C313-B313))","v":600},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D313/D319","v":1500},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,-0.4,0,{"$f":"ABS(C319-B319)","v":0.4},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D319*D313+400)/(2*D319-3.5)","v":-237.03703703703701},"S =",{"$f":"(3.5*D313+SQRT(12.25*D313^2+(1600*D319*D313)))/(2*D319)","v":5361.900619313752}]
[]
["VERTICAL CURVE",null,null,20]
["SAG",null,"VPI =",41300,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,41000,41600,{"$f":"IF(OR(B330=\"\",C330=\"\"),\"\",ABS(C330-B330))","v":600},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D330/D336","v":1500},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,0,0.4,{"$f":"ABS(C336-B336)","v":0.4},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D336*D330+400)/(2*D336-3.5)","v":-237.03703703703701},"S =",{"$f":"(3.5*D330+SQRT(12.25*D330^2+(1600*D336*D330)))/(2*D336)","v":5361.900619313752}]
[]
["VERTICAL CURVE",null,null,21]
["CREST",null,"VPI =",42300,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"FDM 11-10-5, Attachment 5.4, Category 1"]
[null,"Station","Station","Curve (ft)",null,null,"(crest)",null,null,null,"24\" Object Height","\"K\" Value","6\" Object Height","\"K\" Value","Min. L=3V"]
[null,41800,42800,{"$f":"IF(OR(B347=\"\",C347=\"\"),\"\",ABS(C347-B347))","v":1000},"= L",null,"K",null,null,null,"Minimum",151,"Desirable Minimum",245,{"$f":"J342*3","v":180}]
[null,null,null,null,null,null,{"$f":"D347/D353","v":769.23076923076917},null,null,"Sight Distance (S) =",570,null,570,null,"YES"]
[null,null,null,"Algebraic",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,null,null,"Difference"]
[null,"Grade 1","Grade2","in Grades",null,null,null,null,null,null,"S < L",null,"S < L"]
[null,"(%)","(%)","(g2-g1)",null,null,null,null,null,"S =",{"$f":"(SQRT(G348))*46.45","v":1288.2912057330948},"S =",{"$f":"(SQRT(G348))*36.46","v":1011.2184577185927}]
[null,0.4,-0.9,{"$f":"ABS(C353-B353)","v":1.3},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S > L"]
[null,null,null,"K = L/A",null,null,null,null,null,"S =",{"$f":"(1079/D353)+(D347/2)","v":1330},"S =",{"$f":"(665/D353)+(D347/2)","v":1011.5384615384615}]
[]
["VERTICAL CURVE",null,null,22]
["SAG",null,"VPI =",43725,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,43225,44225,{"$f":"IF(OR(B363=\"\",C363=\"\"),\"\",ABS(C363-B363))","v":1000},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D363/D369","v":625},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,-0.9,0.7,{"$f":"ABS(C369-B369)","v":1.6},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D369*D363+400)/(2*D369-3.5)","v":-6666.6666666666706},"S =",{"$f":"(3.5*D363+SQRT(12.25*D363^2+(1600*D369*D363)))/(2*D369)","v":2296.3675878058657}]
[]
["VERTICAL CURVE",null,null,23]
["CREST",null,"VPI =",44900,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"FDM 11-10-5, Attachment 5.4, Category 1"]
[null,"Station","Station","Curve (ft)",null,null,"(crest)",null,null,null,"24\" Object Height","\"K\" Value","6\" Object Height","\"K\" Value","Min. L=3V"]
[null,44700,45100,{"$f":"IF(OR(B380=\"\",C380=\"\"),\"\",ABS(C380-B380))","v":400},"= L",null,"K",null,null,null,"Minimum",151,"Desirable Minimum",245,{"$f":"J375*3","v":180}]
[null,null,null,null,null,null,{"$f":"D380/D386","v":454.54545454545462},null,null,"Sight Distance (S) =",570,null,570,null,"YES"]
[null,null,null,"Algebraic",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,null,null,"Difference"]
[null,"Grade 1","Grade2","in Grades",null,null,null,null,null,null,"S < L",null,"S < L"]
[null,"(%)","(%)","(g2-g1)",null,null,null,null,null,"S =",{"$f":"(SQRT(G381))*46.45","v":990.3173274718107},"S =",{"$f":"(SQRT(G381))*36.46","v":777.32981183255572}]
[null,0.7,-0.18,{"$f":"ABS(C386-B386)","v":0.87999999999999989},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S > L"]
[null,null,null,"K = L/A",null,null,null,null,null,"S =",{"$f":"(1079/D386)+(D380/2)","v":1426.1363636363637},"S =",{"$f":"(665/D386)+(D380/2)","v":955.68181818181824}]
[]
["VERTICAL CURVE",null,null,24]
["SAG",null,"VPI =",55544.4,null,null,null,null,"Design Speed =",60,"mph"]
[]
[null,null,null,"Length of",null,null,"Rate of",null,null,null,"FDM 11-10-5, Attachment 5.6, Category 1"]
[null,"VPC","VPT","Vertical",null,null,"Curvature",null,null,null,null,"\"K\" Value",null,"\"K\" Value"]
[null,"Station","Station","Curve (ft)",null,null,"(sag)",null,null,null,"Minimum",null,"Desirable"]
[null,55044.4,56044.4,{"$f":"IF(OR(B396=\"\",C396=\"\"),\"\",ABS(C396-B396))","v":1000},"= L",null,"K",null,null,null,"SSD (ft)",136,"SSD (ft)",136]
[null,null,null,null,null,null,{"$f":"D396/D402","v":2083.3333333333335},null,null,"Sight Distance (S) =",570,null,570]
[null,null,null,"Algebraic"]
[null,null,null,"Difference"]
[null,"Grade1","Grade2","in Grades",null,null,null,"For a given \"A\" and 'L\".  What is \"S\" for this curve?"]
[null,"(%)","(%)","(g2-g1)"]
[null,-0.18,0.3,{"$f":"ABS(C402-B402)","v":0.48},"= A"]
[null,null,null,null,null,null,null,null,null,null,"S > L",null,"S < L"]
[null,null,null,"K = L/A"]
[null,"When \"A\" is 1.75% or less, S is not restricted for a \"SAG\" vertical curve",null,null,null,null,null,null,null,"S =",{"$f":"(D402*D396+400)/(2*D402-3.5)","v":-346.45669291338584},"S =",{"$f":"(3.5*D396+SQRT(12.25*D396^2+(1600*D402*D396)))/(2*D402)","v":7404.2151696796318}]