{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Ramp \"T\" RT- Near","Ramp T to I-480 WB"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":15,"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":"Ramp \"T\" RT- Near","index":0,"n_rows":41,"n_cols":29,"rows_kept":41,"cut":false,"hidden":false,"merged":[[34,24,34,25],[34,27,34,28],[1,6,1,7],[3,10,3,11],[4,10,4,11],[34,17,34,18],[34,21,34,22]]}
[null,null,null,null,null,"Project Name",null,"CUY-071-10.07 SW"]
[null,null,null,null,null,"Project #",114536,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Page",1,"of",2]
[null,null,null,null,null,"Subject","Guardrail Calcs",null,null,"Sheet #"," "]
[null,null,null,null,null,"Calculated by","SMS",null,null,"Date","2023-08-09"]
[null,null,null,null,null,"Checked by",null,null,null,"Date",""]
[]
[]
["Project Information:"]
["Roadway",null,null,"Ramp T"]
["Design Speed (S)",null,null,60,"MPH"]
["Volume (ADT)",null,null,11497,"ADT"]
[]
["Warranting Feature:",null,null,"2:1 Slope",null,null,null,"Station:",32726.31,14.66,"RT"]
[]
["Analyzing for Adjacent or Opposing Traffic?",null,null,null,null,"Adjacent"]
[]
["Lr =",300,"ft","(Fig 602-1)",{"$f":"D10","v":60},{"$f":"E10","v":"MPH"}]
["Lc = ",40,"ft","(Fig 600-1)",{"$f":"D10","v":60},{"$f":"E10","v":"MPH"}]
["Lh = ",14.66,"ft","(Fig 602-1)",null,"CAD"]
["L1 =",0,"ft","(Fig 602-1)"]
["L2 = ",14.66,"ft","(Fig 301-3 (G)"]
["a =",7,null,"(Fig 602-1)",{"$f":"D10","v":60},{"$f":"E10","v":"MPH"}]
["b = ",0,null,"(Fig 602-1)",null,"CAD"]
["b/a =",{"$f":"B23/B22","v":0},null,"(Fig 602-1)","not flared"]
[]
["Is Lh<Lc",{"$f":"IF(B19<B18,\"Yes\",\"No\")","v":"Yes"},"X (LON) = (Lh+(b/a)L1-L2)/(b/a)+ Lh/Lr)",null,null,null,{"$f":"ROUNDUP((B19+(B24*B20)-B21)/(B24+(B19/B17)),0)","v":0},"ft"]
[null,null,"Y = Lh-X(Lh/Lr)",null,null,null,{"$f":"ROUNDUP(B19-(G26*(B19/B17)),0)","v":15},"ft"]
["Is Lh>Lc",{"$f":"IF(B19>B18,\"Yes\",\"No\")","v":"No"},"X (LON) = (Lc+(b/a)L1-L2)/(b/a)+ Lc/Lr)",null,null,null,{"$f":"ROUNDUP((B18+(B24*B20)-B21)/(B24+(B18/B17)),0)","v":191},"ft"]
[]
["Length of Need (LON) point = ",null,null,{"$f":"I13+G26","v":32726.31}]
["Designer Note: "]
["Type of End Terminal (ET): ",null,null,"Type E"]
[null,null,null,"Calculated",null,"Actual (use this)"]
["Begin AA =",null,null,null,null,{"$f":"F35-12.5","v":32713.519999999997}]
["End AA E, Begin MGS Guardrail =",null,null,{"$f":"I13-G28","v":32535.31},null,{"$f":"D36-255","v":32726.019999999997},null,null,null,"End Guardrail",32981.019999999997,null,null,null,null,32681.25,null,"Near RT",null,null,null,"Near LT",null,null,"Far LT",null,null,"Far RT"]
["End MGS Guardrail, Begin BTA =",null,null,{"$f":"K35","v":32981.019999999997},null,{"$f":"D36","v":32981.019999999997},"CAD",null,null,"Begin LON Sta",{"$f":"I13-G26","v":32726.31},null,null,null,null,32731.25,{"$f":"+P36-P35","v":50},1,"AA",null,32843.5,null,null,null,null,null,33445.800000000003,1,"BTA 2"]
["End BTA",null,null,33013.24,null,{"$f":"D37","v":33013.24},null,null,null,null,null,null,null,null,null,32956.25,225,225,"MGS GR",null,32918.5,{"$f":"+U37-U36","v":75},"MGS GR",33538.33,{"$f":"+X37-X38","v":162.5},"MGS GR",33858.300000000003,{"$f":"+AA37-AA36","v":412.5},"MGS GR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32983.15,{"$f":"+P38-P37","v":26.900000000001455},1,"BTA 1",null,32945.4,1,"BTA 1",33375.83,1,"BTA 2",33870.800000000003,1,"Ty T"]
[null,null,null,null,null,null,null,null,null,"Length neeeded",{"$f":"+K35-K36","v":254.70999999999549},255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"totals (Ramp T)","MGS GR","BTA 1","BTA 2","Ty AA","Ty E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+R37+V37+Y37+AB37","v":875},{"$f":"+R38+V38","v":2},{"$f":"+Y38+AB36","v":2},{"$f":"+R36","v":1},{"$f":"+AB38","v":1}]

{"sheet":"Ramp T to I-480 WB","index":1,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[36,0,36,1],[33,0,33,1],[36,3,36,5],[1,6,1,7],[3,10,3,11],[4,10,4,11],[34,0,34,1],[35,0,35,1]]}
[null,null,null,null,null,"Project Name",null,{"$f":"'Ramp \"T\" RT- Near'!H1","v":"CUY-071-10.07 SW"}]
[null,null,null,null,null,"Project #",114536,null,null,"Page",2,"of",2]
[null,null,null,null,null,"Subject","Guardrail Calcs",null,null,"Sheet #"," "]
[null,null,null,null,null,"Calculated by","SMS",null,null,"Date","2023-08-09"]
[null,null,null,null,null,"Checked by",null,null,null,"Date",""]
[]
[]
["Project Information:"]
["Roadway"]
["Design Speed (S)",null,null,60,"MPH"]
["Volume (ADT)",null,null,2200,"ADT"]
[]
["Warranting Feature:",null,null,"Bridge Pier",null,null,null,"Station:",null,null,"RT"]
[]
["Analyzing for Adjacent or Opposing Traffic?",null,null,null,null,"Adjacent"]
[]
["Lr =",300,"ft","(Fig 602-1)",{"$f":"D10","v":60},{"$f":"E10","v":"MPH"}]
["Lc = ",40,"ft","(Fig 600-1)",{"$f":"D10","v":60},{"$f":"E10","v":"MPH"}]
["Lh = ",24,"ft","(Fig 602-1)",null,"CAD"]
["L1 =",0,"ft","(Fig 602-1)"]
["L2 = ",7.5,"ft","(Fig 301-3 (G)"]
["a =",7,null,"(Fig 602-1)",{"$f":"D10","v":60},{"$f":"E10","v":"MPH"}]
["b = ",1,null,"(Fig 602-1)"]
["b/a =",{"$f":"B23/B22","v":0.14285714285714285},null,"(Fig 602-1)"]
[]
["Is Lh<Lc",{"$f":"IF(B19<B18,\"Yes\",\"No\")","v":"Yes"},"X (LON) = (Lh+(b/a)L1-L2)/(b/a)+ Lh/Lr)",null,null,null,{"$f":"ROUNDUP((B19+(B24*B20)-B21)/(B24+(B19/B17)),0)","v":75},"ft"]
[null,null,"Y = Lh-X(Lh/Lr)",null,null,null,{"$f":"ROUNDUP(B19-(G26*(B19/B17)),0)","v":18},"ft"]
["Is Lh>Lc",{"$f":"IF(B19>B18,\"Yes\",\"No\")","v":"No"},"X (LON) = (Lc+(b/a)L1-L2)/(b/a)+ Lc/Lr)",null,null,null,{"$f":"ROUNDUP((B18+(B24*B20)-B21)/(B24+(B18/B17)),0)","v":118},"ft"]
[]
["Length of Need (LON) point = ",null,null,{"$f":"I13+G26","v":75}]
[]
["Type of End Terminal (ET): ",null,null,"Type E"]
[null,null,null,"Calculated",null,"Actual (use this)"]
["Begin BTA",null,null,"Connect to Barrier End Section ",null,"24'-4.75\"",null,null,null,null,null,"EXISTING GUARDRAIL TO REMAIN"]
["End BTA, Begin MGS Guardrail =",null,null,"One tangent section (12.5') + two radial sections (25')",null,"37.5'","CAD",null,null,"Begin LON Sta"]
["End MGS Guardrail, Begin AA =",null,null,"Use Type E",null,"50'",null,null,null,"End Guardrail"]
["End AA =",null,null,"Totals:   111'-4.75\" > 75' LON"]
[]
[null,null,null,null,null,null,null,null,null,"Length neeeded"]
[null,null,null,null,null,null,null,null,null,"Begin GR"]
[null,null,null,null,null,null,null,null,null,"Begin Ty E AA"]