{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Fit Vertical Curve"],"not_rendered":{"charts":0,"images":8,"macros":1,"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":"Fit Vertical Curve","index":0,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Fit a Vertical Curve"]
[]
["Highest/Lowest point fixed"]
[]
[null,"Grade in, g1",1]
[null,"Grade out, g2",2]
[null,"PVI sta",1000]
[null,"PVI elev",800]
[]
[null,"Max/min elev",797]
[]
[null,"Length",{"$f":"(C10-C8)*(2*(C5-C6)/(C5*C6))*100","v":300},"ft"]
[null,null,"Sta","Elev"]
[null,"BVC",{"$f":"C7-C12/2","v":850},{"$f":"C8-C5*C12/200","v":798.5}]
[null,"Hi/Low pt",{"$f":"C14+C5/(C5-C6)*C12","v":550},{"$f":"D14+C5*(C15-C14)/100+((C6-C5)/(2*C12/100))*((C15-C14)/100)^2","v":797},{"$f":"IF(ABS(D15-C10)<0.005,\"Check\",\"\")","v":"Check"}]
[null,"EVC",{"$f":"C7+C12/2","v":1150},{"$f":"C8+C6*C12/200","v":803}]
[]
[]
["Station and Elevation fixed"]
[]
[null,"Grade in, g1",-4,"%"]
[null,"Grade out, g2",3.8,"%"]
[null,"PVI sta",5200]
[null,"PVI elev",1261.5]
["Curve must pass thru:",null,null,null,"Quadratic coefficents"]
[null,"Sta",5350,null,"a =",{"$f":"(C22-C21)/8","v":0.97499999999999998}]
[null,"Elev",1271.2,null,"b =",{"$f":"(C24-C27)+(C26-C23)/100*((C21+C22)/2)","v":-9.8500000000000458}]
[null,null,null,null,"c =",{"$f":"((C22-C21)/2)*((C26/100)^2+(C23/100)^2-2*(C26/100)*(C23/100))","v":8.7750000000000004}]
[]
[null,"Two solutions","BVC sta","EVC sta","Check"]
[null,{"$f":"((-F27+SQRT(F27^2-4*F26*F28)))/(2*F26)*100","v":911.52026166480425},{"$f":"$C$23-B31/2","v":4744.239869167598},{"$f":"$C$23+B31/2","v":5655.760130832402},{"$f":"IF(AND($C$26>C31,$C$26<D31),\"Fits\",\"\")","v":"Fits"}]
[null,{"$f":"((-F27-SQRT(F27^2-4*F26*F28)))/(2*F26)*100","v":98.736148591610728},{"$f":"$C$23-B32/2","v":5150.6319257041951},{"$f":"$C$23+B32/2","v":5249.3680742958049},{"$f":"IF(AND($C$26>C32,$C$26<D32),\"Fits\",\"\")","v":""}]