{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Example","Sheet1"],"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":"Example","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,1,4,3],[0,5,0,7],[1,5,1,7],[2,5,2,7],[3,5,3,7],[0,1,0,3],[1,1,1,3],[2,1,2,3],[3,1,3,3]]}
["ITEM DESC:",null,null,null,"PROJECT I.D."]
["ITEM #:",null,null,null,"ROADWAY"]
["CATEGORY:",null,null,null,"DESCRIPTION"]
["ENTERED:",null,null,null,"COUNTY"]
["CHECKED:"]
[]
[null,{"$f":"D8","v":12},"Inch Pipe @",null,"STA",{"$f":"D11","v":"152+30"}]
["Pipe Diameter (If Eliptical, enter Height)",null,null,12,"IN"]
["Pipe Wall Thickness",null,null,4,"IN"]
["Skew",null,null,14,"DEG"]
["Pipe STA",null,null,"152+30","STA"]
["Pipe Length (Plan)",null,null,50,"FT"]
["Inlet Elevation (Plan)",null,null,742.5,"FT"]
["Discharge Elevation (Plan)",null,null,742.1,"FT"]
[]
[]
["Finish Roadway Elevation (Plan)",null,null,746.29,"FT"]
["Finish Roadway Elevation (Calculated)",null,null,{"$f":"D20+D19","v":746.3},"FT","Note: For Checking"]
["Height of CABC and Pavement",null,null,1.5,"FT"]
["Top of Subgrade",null,null,744.8,"FT"]
[]
[]
[null,null,"Left",null,"Right"]
["Roadway Width",null,20,null,20]
["Slope, %",null,-0.02,null,-0.02]
["Top of Subgrade",null,{"$f":"D20+C24*C25","v":744.4},null,{"$f":"D20+E24*E25","v":744.4}]
["Flow Line",null,742.5,null,742.1,"Note: Input Field Survey If Possible"]
["Top of Pipe",null,{"$f":"C27+D8/12+D9/12","v":743.83333333333337},null,{"$f":"E27+D8/12+D9/12","v":743.43333333333339}]
["Ditch Slope, ratio",null,4,null,4]
["Depth of Cover",null,{"$f":"C26-C28","v":0.56666666666660603},null,{"$f":"E26-E28","v":0.9666666666665833}]
["Length (w/o offset)",null,{"$f":"(C24+C29*C30)/COS(RADIANS(D10))","v":22.948330146857479},null,{"$f":"(E24+E29*E30)/COS(RADIANS(D10))","v":24.597311953817226}]
["Endwall Width",null,10,null,10]
["Endwall Offset",null,{"$f":"0.5*C32*SIN(RADIANS(D10))","v":1.2096094779983386},null,{"$f":"0.5*E32*SIN(RADIANS(D10))","v":1.2096094779983386}]
["C' Section Length",null,0,null,0,"Note: For Concrete Only"]
["Eng. Judgement",null,-0.5,null,-0.5]
["Length (w/ offset)",null,{"$f":"C31+C33-C34+C35","v":23.657939624855818},null,{"$f":"E31+E33-E34+E35","v":25.306921431815564}]
[]
[]
[null,null,"Total Length =",{"$f":"C36+E36","v":48.964861056671381},"FT"]
[null,null,"Number of AEW =",2]
[null,null,"Inlet Elevation =",{"$f":"C27","v":742.5},"FT"]
[null,null,"Discharge Elevation =",{"$f":"E27","v":742.1},"FT"]

{"sheet":"Sheet1","index":1,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,1,4,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,5,3,7],[2,5,2,7],[1,5,1,7],[0,5,0,7],[3,1,3,2]]}
["ITEM DESC:",null,null,null,"PROJECT I.D:"]
["ITEM #:",null,null,null,"ROADWAY:"]
["CATEGORY:",null,null,null,"DESCRIPTION:"]
["ENTERED:",null,null,null,"COUNTY:"]
["CHECKED:"]
[]
[null,{"$f":"D8","v":0},"Inch Pipe @",null,"STA",{"$f":"D11","v":0}]
["Pipe Diameter (If Eliptical, enter Height)",null,null,null,"IN"]
["Pipe Wall Thickness",null,null,null,"IN"]
["Skew",null,null,null,"DEG"]
["Pipe STA",null,null,null,"STA"]
["Pipe Length (Plan)",null,null,null,"FT"]
["Inlet Elevation (Plan)",null,null,null,"FT"]
["Discharge Elevation (Plan)",null,null,null,"FT"]
[]
[]
["Finish Roadway Elevation (Plan)",null,null,null,"FT"]
["Finish Roadway Elevation (Calculated)",null,null,{"$f":"D20+D19","v":0},"FT","Note: For Checking"]
["Height of CABC and Pavement",null,null,null,"FT"]
["Top of Subgrade",null,null,null,"FT"]
[]
[]
[null,null,"Left",null,"Right"]
["Roadway Width"]
["Slope, %"]
["Top of Subgrade",null,{"$f":"D20+C24*C25","v":0},null,{"$f":"D20+E24*E25","v":0}]
["Flow Line",null,null,null,null,"Note: Input Field Survey If Possible"]
["Top of Pipe",null,{"$f":"C27+D8/12+D9/12","v":0},null,{"$f":"E27+D8/12+D9/12","v":0}]
["Ditch Slope, ratio"]
["Depth of Cover",null,{"$f":"C26-C28","v":0},null,{"$f":"E26-E28","v":0}]
["Length (w/o offset)",null,{"$f":"(C24+C29*C30)/COS(RADIANS(D10))","v":0},null,{"$f":"(E24+E29*E30)/COS(RADIANS(D10))","v":0}]
["Endwall Width"]
["Endwall Offset",null,{"$f":"0.5*C32*SIN(RADIANS(D10))","v":0},null,{"$f":"0.5*E32*SIN(RADIANS(D10))","v":0}]
["C' Section Length",null,null,null,null,"Note: For Concrete Only"]
["Eng. Judgement"]
["Length (w/ offset)",null,{"$f":"C31+C33-C34+C35","v":0},null,{"$f":"E31+E33-E34+E35","v":0}]
[]
[]
[null,null,"Total Length =",{"$f":"C36+E36","v":0},"FT"]
[null,null,"Number of AEW ="]
[null,null,"Inlet Elevation =",{"$f":"C27","v":0},"FT"]
[null,null,"Discharge Elevation =",{"$f":"E27","v":0},"FT"]