{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Cover","Survey","Low Grade","Mod Grade","Stable Bottom","Access","Manning's n","Instr.","Calc.","Draw LG","Draw MG","Draw SB","Draw AC"],"not_rendered":{"charts":6,"images":20,"macros":1,"external_links":1,"defined_names":20,"comments":7,"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":"Cover","index":0,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[39,0,49,0],[39,6,39,7],[41,2,41,5],[41,11,41,16],[42,12,42,16],[44,1,44,8],[44,11,44,16],[49,16,50,17],[46,5,46,7],[47,11,47,16],[48,2,48,5],[48,12,48,16],[32,10,32,17],[32,18,32,19],[33,10,33,17],[33,18,33,19],[45,12,45,16],[38,18,38,19],[34,10,34,17],[34,18,34,19],[35,10,35,17],[35,18,35,19],[38,10,38,17],[36,10,36,17],[36,18,36,19],[37,10,37,17],[37,18,37,19],[30,10,30,17],[30,18,30,19],[31,10,31,17],[31,18,31,19],[24,2,24,7],[24,10,25,19],[26,10,26,17],[26,18,26,19],[27,10,27,17],[27,18,27,19],[28,10,28,17],[28,18,28,19],[29,10,29,17],[28,2,28,3],[29,18,29,19],[29,2,29,3],[19,3,19,4],[19,5,19,17],[21,3,21,4],[21,5,21,11],[25,2,27,7],[12,1,12,19],[15,1,15,19],[17,3,17,4],[17,5,17,17],[6,2,6,18],[7,1,7,19],[9,1,9,19],[11,3,11,5],[28,4,28,7],[29,4,29,7],[42,2,42,5],[49,2,49,5],[45,5,45,7],[45,2,45,4],[34,2,34,5],[36,2,36,7],[32,1,32,8],[38,2,38,7],[37,2,37,7]]}
[]
[]
[]
[]
[]
[]
[null,null,"Natural Resources Conservation Service"]
[null,"U. S. DEPARTMENT OF AGRICULTURE"]
[]
[null,"IN COOPERATION WITH"]
[]
[null,null,null,null,null,null,"COUNTY CONSERVATION DISTRICT"]
[null,"PENNSYLVANIA"]
[]
[]
[null,"DETAIL PLANS FOR"]
[]
[null,null,null,"(PRACTICE)",null,"Animal Stream Crossing"]
[]
[null,null,null,"(COOPERATOR)"]
[]
[null,null,null,"(LOCATION)"]
[]
[]
[null,null,"NOTICE TO THE COOPERATOR AND CONTRACTOR",null,null,null,null,null,null,null,"INDEX OF DRAWINGS"]
[null,null,"PA ACT 287 of 1974 as amended by Act 121 of 2008 73P.S. § 176 et. seq.:    IT IS THE DUTY OF COOPERATORS AND CONTRACTORS TO COMPLY WITH THE PROVISIONS OF PENNSYLVANIA ACT 121 (2008) BEFORE PERFORMING ANY EXCAVATION WORK.                                                                                                                                                                           "]
[null,null,null,null,null,null,null,null,null,null,"TITLE",null,null,null,null,null,null,null,"SHEET NO."]
[null,null,null,null,null,null,null,null,null,null,"COVER SHEET",null,null,null,null,null,null,null,1]
[null,null,"Serial No.",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null," 2"]
[null,null,"DATE:",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null," 3"]
[null,null,null,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,null,null,null," 5"]
[null,"CONSTRUCTION DATA"]
[null,null,"LAYOUT BY:"]
[null,null,null,null,null,null,"DATE:"]
[null,null,"CONTRACTOR NAME AND ADDRESS:"]
[]
[]
[]
[null,null,"CONSTRUCTION COMPLETED       (DATE):"]
[null,null,"PRACTICE  (DOES)  (DOES NOT)  MEET STANDARDS AND SPECIFICATIONS.",null,null,null,null,null,null,null,null,"PREPARED BY:"]
[null,null,null,null,null,null,"DATE:",null,null,null,null,null,null,null,null,null,null,"DATE:"]
[null,null,"TITLE:",null,null,null,null,null,null,null,null,"TITLE:"]
[null,null,null,null,null,null,null,null,null,null,null,"REVIEWED AND APPROVED BY:"]
[null,"AS-BUILT DRAWINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE:"]
[null,null,"SUBMITTED BY:     ",null,null,null,null,null,null,null,null,"TITLE:"]
[null,null,null,null,null,"TITLE:",null,null,null,null,null,"REVIEWED AND CONCURRED BY:"]
[null,null,"REVIEWED AND APPROVED BY:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE:"]
[null,null,null,null,null,null,"DATE:",null,null,null,null,"TITLE:"]
[null,null,"TITLE:",null,null,null,null,null,null,null,null,null,null,null,null,null,"SHEET 1 OF"]
[]
[]
[null,null,"Version 5.0  Apr2018 - J.Harrold",null,null,null,null,null,"Page 1"]

{"sheet":"Survey","index":1,"n_rows":57,"n_cols":24,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Section Survey notes",null,null,null,"channel","Manning's",null,null,"Est.",null,null,null,null,"Profile Survey notes",null,null,null,"channel"]
[null,null,null,"Height of Instrument (ft):",null,null,"slope (%)","\"n\"",null,null,"Bankfull",null,null,null,null,null,null,null,null,"slope (%)"]
[null,null,null,null,null,null,null,0.03,null,"Depth",5,"ft.",null,null,null,"Height of Instrument (ft):",{"$f":"C20","v":0},null,null,{"$f":"SLOPE(P23:P57,O23:O57)*-100","v":{"$error":"#DIV/0!"}}]
[null,"Pnt","Distance","FS","Elevation",null,null,null,null,"Elev",{"$f":"IF(ISNUMBER(K20),IF(SUM(C23:C57)=0,0,K20+INDEX(E23:E57,MATCH(MAX(D23:D57),D23:D57,0))),0)","v":0},"ft.",null,"Pnt","Distance","FS","Elevation"]
[null,"no.","(ft)","(ft)","(ft)",null,null,null,null,null,null,null,null,"no.","(ft)","(ft)","(ft)"]
[null,{"$f":"IF(ISNUMBER(C23),1,NA())","v":{"$error":"#N/A"}},null,null,{"$f":"IF(ISNUMBER(D23),C$20-D23,NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(O23),1,NA())","v":{"$error":"#N/A"}},null,null,{"$f":"IF(ISNUMBER(P23),Q$20-P23,NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ISNUMBER(C24),B23+1,NA())","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},null,"Peak Discharge",690,"cfs",null,null,null,null,{"$f":"IF(ISNUMBER(O24),N23+1,NA())","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"Calculated Discharge",{"$f":"G37","v":0},"cfs",{"$f":"IF(H25>H24,'Calc.'!H1,'Calc.'!H2)","v":"Try Again?"},null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,"Exterior Frame Stone size",{"$f":"IF(Survey!G36<=4.5,\"R-3\",IF(Survey!G36<=6.5,\"R-4\",IF(Survey!G36<=8,\"R-5\",IF(Survey!G36<=9.2,\"R-6\",IF(Survey!G36<=10.4,\"R-7\",IF(Survey!G36<=13,\"R-8\",IF(Survey!G36>=13.01,NA())))))))","v":"R-3"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"Dimensions",null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$f":"ABS(IF(ISNUMBER(K21),SUM('Calc.'!D3:D36),0))","v":0},"x-section area (ft2)",null,{"$f":"IF(G30<>0,G29/G30,0)","v":0},"d mean",null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$f":"ABS(IF(ISNUMBER(K21),SUM('Calc.'!C3:C36),0))","v":0},"width (ft)",null,{"$f":"IF(ISNUMBER(K21),SUM('Calc.'!E3:E36),0)","v":0},"wet P",null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$f":"IF(ISNUMBER(K20),IF(SUM(C23:C57)=0,0,K21-INDEX(E23:E57,MATCH(MAX(D23:D57),D23:D57,0))),0)","v":0},"d max (in)",null,{"$f":"IF(J30<>0,G29/J30,0)","v":0},"hyd radi",null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"Hydraulics",null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$f":"IF(J30<>0,IF(H20<>0,1.4865*((G29/J30)^0.666)*((G20/100)^0.5)/H20,0),0)","v":0},"velocity (ft/sec)",null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$f":"G36*G29","v":0},"discharge rate, Q (cfs)",null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$f":"IF(J30<>0,62.4*(G29/J30)*G20/100,0)","v":0},"shear stress (lbs/ft2)",null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$f":"IF(J30<>0,(32.17*(G29/J30)*G20/100)^0.5,0)","v":0},"shear velocity (ft/sec)",null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,{"$f":"IF(J30<>0,IF(G30<>0,G36^2/(32.2*J29),0),0)","v":0},"Froude number",null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,"Page 2",null,null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,"Page 3"]
[null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$f":"Cover!$F$20","v":0},"Design Sheet",null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$f":"Cover!$F$20","v":0},"Design Sheet"]

{"sheet":"Low Grade","index":2,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Type Of Crossing:",null,null,null,"Volume of stone"]
[null,null,"Low Gradient",null,null,null,null,"Interior Stone","in.","Yd3","Tons"]
[null,null,null,null,null,null,null,"MODIFIED 2A",4,{"$f":"(C32*(I20/12)*C39)/27","v":0},{"$f":"ROUNDUP((J20*1.5),1)","v":0},"Top"]
[null,null,{"$f":"IF(F21=FALSE,Survey!$K$26,)","v":"R-3"},null,"Not Required",false,null,"AASHTO #1",6,{"$f":"(C32*(I21/12)*C39)/27","v":0},{"$f":"ROUNDUP((J21*1.5),1)","v":0},"Base"]
[null,"Sizing Frame Stone",null,null,"Or Use…","R-4",null,"Frame Stone",{"$f":"G23","v":"R-3"},{"$f":"(C25*D25^2)*2/27","v":0},{"$f":"ROUNDUP(J22*1.5,2)","v":0}]
[null,null,"Exterior Frame",null,null,null,{"$f":"IF(F21=FALSE,$C$21,IF(F22=0,H23,F22))","v":"R-3"},"(Not Required)"]
[null,null,"Stone Length","Width","Depth"]
[null,null,null,{"$f":"IF(F21=TRUE,(IF(F22=\"R-3\",1,IF(F22=\"R-4\",1.5,IF(F22=\"R-5\",2.25,IF(F22=\"R-6\",3,IF(F22=\"R-7\",3.75,IF(F22=\"R-8\",6,NA()))))))),(IF(C21=\"R-3\",1,IF(C21=\"R-4\",1.5,IF(C21=\"R-5\",2.25,IF(C21=\"R-6\",3,IF(C21=\"R-7\",3.75,IF(C21=\"R-8\",6,NA()))))))))","v":1},{"$f":"D25","v":1}]
[]
[]
[]
[null,null,"Stream Bottom"]
[]
[null,null,"Crossing width"]
[]
[null,null,"Minimum Length"]
[null,null,{"$f":"Survey!G30","v":0}]
[null,null,"Additional"]
[null,null,"Apron Length"]
[null,null,null,"Left"]
[null,null,null,"Right"]
[null,null,{"$f":"C25+C37+C38","v":0}]
[]
[]
[]
[]
[null,null,"Stream Approaches"]
[null,null,null,"Left Bank"]
[null,null,null,"Right Bank"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Page 4"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Cover!$F$20","v":0},"Design Sheet"]

{"sheet":"Mod Grade","index":3,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Type Of Crossing:",null,null,null,"Volume of stone"]
[null,null,"Moderate Gradient",null,null,null,null,"Interior Stone","in.","Yd3","Tons"]
[null,null,null,null,null,null,null,"MODIFIED 2A",4,{"$f":"(C32*(I20/12)*C39)/27","v":0},{"$f":"ROUNDUP((J20*1.5),1)","v":0},"Top"]
[null,null,{"$f":"IF(F21=FALSE,Survey!$K$26,)","v":"R-3"},null,"Not Required",false,null,"AASHTO #1",8,{"$f":"(C32*(I21/12)*C39)/27","v":0},{"$f":"ROUNDUP((J21*1.5),1)","v":0},"Base"]
[null,"Sizing Frame Stone",null,null,"Or Use…",null,null,"Frame Stone",{"$f":"G23","v":"R-3"},{"$f":"((C25*D25^2)*2+(C30*(2/3)*C30)+(C30*C30/3))/27","v":0},{"$f":"ROUNDUP(J22*1.5,2)","v":0}]
[null,null,"Exterior Frame",null,null,null,{"$f":"IF(F21=FALSE,$C$21,IF(F22=0,H23,F22))","v":"R-3"},"(Not Required)"]
[null,null,"Stone Length","Width","Depth"]
[null,null,null,{"$f":"IF(F21=TRUE,(IF(F22=\"R-3\",1,IF(F22=\"R-4\",1.5,IF(F22=\"R-5\",2.25,IF(F22=\"R-6\",3,IF(F22=\"R-7\",3.75,IF(F22=\"R-8\",6,NA()))))))),(IF(C21=\"R-3\",1,IF(C21=\"R-4\",1.5,IF(C21=\"R-5\",2.25,IF(C21=\"R-6\",3,IF(C21=\"R-7\",3.75,IF(C21=\"R-8\",6,NA()))))))))","v":1},{"$f":"D25","v":1}]
[]
[]
[]
[null,null,"Stream Bottom"]
[]
[null,null,"Crossing width"]
[]
[null,null,"Minimum length"]
[null,null,{"$f":"Survey!G30","v":0}]
[null,null,"Additional"]
[null,null,"Apron Length"]
[null,null,null,"Left"]
[null,null,null,"Right"]
[null,null,{"$f":"C25+C37+C38","v":0}]
[]
[]
[]
[]
[null,null,"Stream Approaches"]
[null,null,null,"Left Bank"]
[null,null,null,"Right Bank"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Page 4"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Cover!$F$20","v":0},"Design Sheet"]

{"sheet":"Stable Bottom","index":4,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Type Of Crossing:",null,null,"Volume of stone"]
[null,null,"Stable Bottom",null,null,null,null,"Interior Stone","in.","Yd3","Tons"]
[null,null,null,null,null,null,null,"AASHTO 57",4,{"$f":"((C32*(I20/12)*C39)+(C32*(I20/12)*C40))/27","v":0},{"$f":"ROUNDUP((J20*1.5),1)","v":0},"Top"]
[null,null,{"$f":"IF(F21=FALSE,Survey!$K$26,)","v":"R-3"},null,"Not Required",false,null,"AASHTO #1",6,{"$f":"((C32*(I21/12)*C39)+(C32*(I21/12)*C40))/27","v":0},{"$f":"ROUNDUP((J21*1.5),1)","v":0},"Base"]
[null,"Frame Stone Sizing ",null,null,"Or Use…",null,null,"Frame Stone",{"$f":"G23","v":"R-3"},{"$f":"(((C25*D25^2)*2+(D25^2*C32))+((C27*D27^2)*2+(D27^2*C32)))/27","v":0},{"$f":"ROUNDUP((J22*1.5),1)","v":0}]
[null,null,"Exterior Frame Stone",null,null,null,{"$f":"IF(F21=FALSE,$C$21,IF(F22=0,H23,F22))","v":"R-3"},"(Not Required)"]
[null,null,"Left Length","Width","Depth"]
[null,null,null,{"$f":"IF($F$21=TRUE,(IF($F$22=\"R-3\",1,IF($F$22=\"R-4\",1.5,IF($F$22=\"R-5\",2.25,IF($F$22=\"R-6\",3,IF($F$22=\"R-7\",3.75,IF($F$22=\"R-8\",6,NA()))))))),(IF($C$21=\"R-3\",1,IF($C$21=\"R-4\",1.5,IF($C$21=\"R-5\",2.25,IF($C$21=\"R-6\",3,IF($C$21=\"R-7\",3.75,IF($C$21=\"R-8\",6,NA()))))))))","v":1},{"$f":"D25","v":1}]
[null,null,"Right Length","Width","Depth"]
[null,null,null,{"$f":"IF($F$21=TRUE,(IF($F$22=\"R-3\",1,IF($F$22=\"R-4\",1.5,IF($F$22=\"R-5\",2.25,IF($F$22=\"R-6\",3,IF($F$22=\"R-7\",3.75,IF($F$22=\"R-8\",6,NA()))))))),(IF($C$21=\"R-3\",1,IF($C$21=\"R-4\",1.5,IF($C$21=\"R-5\",2.25,IF($C$21=\"R-6\",3,IF($C$21=\"R-7\",3.75,IF($C$21=\"R-8\",6,NA()))))))))","v":1},{"$f":"D27","v":1}]
[]
[null,null,"Stream Bottom"]
[]
[null,null,"Crossing width"]
[]
[null,null,"Crossing length"]
[null,null,{"$f":"Survey!$G$30","v":0}]
[null,null,"Additional"]
[null,null,"Apron Length"]
[null,null,null,"Left"]
[null,null,null,"Right"]
[null,null,{"$f":"C25+C37","v":0}]
[null,null,{"$f":"C27+C38","v":0}]
[]
[]
[]
[null,null,"Stream Approaches"]
[null,null,null,"Left Bank"]
[null,null,null,"Right Bank"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Page 4"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Cover!$F$20","v":0},"Design Sheet"]

{"sheet":"Access","index":5,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Type Of Crossing:",null,null,null,"Volume of stone"]
[null,null,"Access Ramp",null,null,null,null,"Interior Stone","in.","Yd3","Tons"]
[null,null,null,null,null,null,null,"AASHTO 57",4,{"$f":"(C32*(I20/12)*C38)/27","v":0},{"$f":"ROUNDUP((J20*1.8),1)","v":0},"Top"]
[null,null,{"$f":"IF(F21=FALSE,Survey!$K$26,)","v":0},null,"Not Required",true,null,"AASHTO #1",6,{"$f":"(C32*(I21/12)*C38)/27","v":0},{"$f":"ROUNDUP((J21*1.6),1)","v":0},"Base"]
[null,"Sizing Frame Stone",null,null,"Or Use…","R-4",null,"Frame Stone",{"$f":"G23","v":"R-4"},{"$f":"(C25*D25^2)*2/27+(C32*D25^2)/27","v":0},{"$f":"ROUNDUP((J22*1.5),1)","v":0}]
[null,null,"Exterior Frame",null,null,null,{"$f":"IF(F21=FALSE,$C$21,IF(F22=0,H23,F22))","v":"R-4"},"(Not Required)"]
[null,null,"Stone Length","Width","Depth",null,null,null,null,{"$f":"C26","v":"v"}]
[null,null,null,{"$f":"IF(F21=TRUE,(IF(F22=\"R-3\",1,IF(F22=\"R-4\",1.5,IF(F22=\"R-5\",2.25,IF(F22=\"R-6\",3,IF(F22=\"R-7\",3.75,IF(F22=\"R-8\",6,NA()))))))),(IF(C21=\"R-3\",1,IF(C21=\"R-4\",1.5,IF(C21=\"R-5\",2.25,IF(C21=\"R-6\",3,IF(C21=\"R-7\",3.75,IF(C21=\"R-8\",6,NA()))))))))","v":1.5},{"$f":"D25","v":1.5}]
[null,null,{"$f":"IF(C28>0,D28,E28)","v":"v"},null,null,null,null,null,null,{"$f":"C26","v":"v"}]
[null,null,"Stream Bottom Station"]
[null,null,null,"^","v"]
[null,null,"Stream Bottom","Pad"]
[]
[null,null,"Crossing width"]
[]
[null,null,"Crossing length"]
[null,null,{"$f":"Survey!G30","v":0}]
[null,null,"Additional"]
[null,null,"Apron Length"]
[]
[null,null,{"$f":"IF(C28<=0,'Calc.'!F37,'Calc.'!G37)+C37+D30","v":0}]
[]
[]
[]
[]
[]
[null,null,"Stream Approach"]
[null,null,11,"Bank"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Page 4"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Cover!$F$20","v":0},"Design Sheet"]

{"sheet":"Manning's n","index":6,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Non-Vegetatal channels1:",null,null,null,null,null,null,"Manning's \"n\""]
[null,"Wooden flumes--planed (no battens)",null,null,null,null,null,0.01,1.4E-2]
[null,"Wooden flumes--unplaned (no battens)",null,null,null,null,null,1.0999999999999999E-2,1.4999999999999999E-2]
[null,"Metal flumes--smooth",null,null,null,null,null,1.0999999999999999E-2,1.4999999999999999E-2]
[null,"Metal flumes--corrugated",null,null,null,null,null,2.1999999999999999E-2,0.03]
[null,"Vitrified clay tile",null,null,null,null,null,1.2E-2,1.7000000000000001E-2]
[null,"Concrete--finished",null,null,null,null,null,1.0999999999999999E-2,1.4E-2]
[null,"Concrete--unfinished",null,null,null,null,null,1.4999999999999999E-2,0.02]
[null,"Masonry--rubble",null,null,null,null,null,1.7000000000000001E-2,0.03]
[null,"Masonry--dry-rubble",null,null,null,null,null,2.5000000000000001E-2,3.5000000000000003E-2]
[]
["Earth channels subject to intermittent flow:"]
["Bare--unable to support vegetal growth or vegetal growth not permitted by farm operations"]
[null,"Straight and uniform",null,null,null,null,null,1.7000000000000001E-2,2.5000000000000001E-2]
[null,"Dreged (rough bed)",null,null,null,null,null,2.5000000000000001E-2,3.5000000000000003E-2]
[]
["Earth channels subject to continuous flow2:"]
["Canals and ditches with continuous flow or sufficiently frequent flow to keep"]
["vegetation from growing on the bed."]
["A.","Channels with unusually good alignment, relitively smooth"]
[null,"beds and side slopes. Banks fairly well vegetated but no "]
[null,"vegetation or large obstructions on the bed."]
[null,"Product of top width and depth:"]
[null,null,"Up to 10",null,null,null,null,0.03,0.04]
[null,null,"10 to 20",null,null,null,null,0.02,0.03]
[null,null,"Greater than 20",null,null,null,null,1.7000000000000001E-2,2.5000000000000001E-2]
[]
["B.","Channels with average bed and side-slope roughness and"]
[null,"alinement.  Banks fairly well vegetated.  Average maintenance."]
[null,"Product of top width and depth:"]
[null,null,"Up to 10",null,null,null,null,4.4999999999999998E-2,0.05]
[null,null,"10 to 20",null,null,null,null,0.04,4.4999999999999998E-2]
[null,null,"Greater than 20",null,null,null,null,0.03,0.04]
[]
["C.","Channels choked with weeds and willows.  Values of n as high as "]
[null,"0.015 may develop.",null,null,null,null,null,0.15]
[]
[]
["Reference SCS TP-61"]
["\"HANDBOOK OF CHANNEL DESIGN FOR"]
["SOIL AND WATER CONSERVATION\""]
[]
[]
[]
[]
[]
[]
["1 Selected from table of Horton's values of n in King's \"Handbook of Hydraulics.\""]
["2 Reference to U.S. Dept. Agr. Technical Bulletins by C.E. Ramer and F.C. Scobey"]
["is recommended."]

{"sheet":"Instr.","index":7,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"General Instructions And Guidance"]
[null,null,null,"This spreadsheet does not cover slat crossings"]
[null,null,null,"see PA Standard Drawings #29 and #30"]
[null,null,"Macro buttons are available to switch between worksheets."]
[null,null,"Enter data in teal shaded areas as needed."]
[null,null,"Comments are added to give additional guidance."]
[]
[]
[]
[]
["(1","Complete a site survey including a profile along the stream, and a cross section where the"]
[null,"proposed animal crossing will be."]
["(2","Enter the data on the cover sheet in the teal colored blocks."]
["(3","Enter the survey data on the Survey Notes sheet:"]
[null,"a) Enter the instrument height."]
[null,"b) Enter the station, (Left side as negative station and right side as positive station, and the "]
[null,"center as zero) as looking up stream. "]
[null,"(Enter the stations in sequential order from lowest to highest or highest to lowest.)"]
[null,"c) Enter the foresight reading for the station."]
[null,"d) Do this for each station in the cross section and the stream profile."]
["(4","Enter the channel slope as a positive percentage; 0 or larger. (1, 2, 3, 0.5, 2.5…)%"]
["(5","Enter the Manning's \"n\" value for the stream.  Check the list provided and enter the "]
[null,"appropriate value for the stream crossing site."]
["(6","Enter the desired Peak Discharge needed to pass the crossing. "]
[null," Use of EFH-2 or other hydraulic formula needed to calculate the 10 year -24 hour storm."]
["(7","Enter an estimated Bank full depth in feet from the bottom of the crossing."]
[null,"(Entering a depth that exceeds the surveyed maximum ground height will give erroneous results.)"]
[null,"The calculated discharge for the initial estimated bank full depth will compare to the desired"]
[null,"Peak Discharge.  Adjusting the  estimated Bank Full Depth will increase or decrease the  "]
[null,"calculated discharge to match the desired Peak Discharge determined for the site."]
[null,"The stream velocity will determine the size frame stone needed, R-3, R-4,…  "]
[null,"The designer has the option to select an optional sized frame stone using the Isbash Curve, "]
[null,"or not to use the stone at all. (Note; a safety factor has been applied to the stone size.)"]
["(8","When the calculated discharge meets or exceeds the desired Peak Discharge, select the type "]
[null,"of crossing from the macros on the bottom of the cross section page."]
["(9","The macro will take you to the design page for the crossing type you selected."]
["(10","The stream velocity has determined the size frame stone needed, the designer can choose "]
[null,"not install the frame stone or use an optional sized stone by checking the box list. "]
[null,"near \"Not Required\" and if a new size is needed select from the \"Or Use…\" list."]
[null,"(Also if the stone is Not Required set the Exterior Frame stone length to zero feet .)"]
["(11","If the frame stone is used, enter the length across the stream the stone is needed."]
[null,"  (See PA578 Standard.)"]
["(12","Enter the stream bottom width."]
["(13","Enter the required width of the crossing.  (See PA578 Standard.)"]
["(14","Enter any additional apron length required outside the calculated stream width needed to "]
[null,"pass the 10-year storm."]
["(15","Enter the stream approach slope ratio.  Ratio must be 4 to 1 or flatter."]
["(16","Page numbers may be altered if additional pages are needed, such as the site Plainview, or "]
[null,"EFH-2 calculations.  Adjust the cover sheet as needed."]
["(17","Print the design."]
[null,"* Selecting the Print Design macro will print the cover page, the survey pages, the design page, "]
[null,"   and an 11x17detail sheet.  The default printer must have the capability to print 11x17."]

{"sheet":"Calc.","index":8,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,"Width",null,null,"Access",null,"OK",null,null,null,"Sheet Passwords can be seen on each sheet."]
[{"$f":"Survey!$K$21","v":0},{"$f":"IF(D37=2,A2,Survey!K21+(Survey!K21-INDEX(Survey!E23:E57,MATCH(MAX(Survey!D23:D57),Survey!D23:D57,0))))","v":{"$error":"#N/A"}},null,null,null,"Left Bank","Right Bank","Try Again?"]
[{"$f":"Survey!$K$21","v":0},{"$f":"B$2","v":{"$error":"#N/A"}},{"$f":"IF(Survey!$C$23-Survey!$C$24<0,1,-1)*(IF(ISNA(Survey!$E$24),0,IF(Survey!$E$23<Survey!$K$21,IF(Survey!$E$24<Survey!$K$21,((Survey!$C$24-Survey!$C$23)^2)^0.5,(((Survey!$K$21-Survey!$E$23)*(Survey!$C$24-Survey!$C$23)/(Survey!$E$24-Survey!$E$23))^2)^0.5),IF(Survey!$E$24<Survey!$K$21,(((Survey!$K$21-Survey!$E$24)*(Survey!$C$24-Survey!$C$23)/(Survey!$E$23-Survey!$E$24))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E24),0,IF(Survey!E23<Survey!K$21,IF(Survey!E24<Survey!K$21,(Survey!K$21-(Survey!E23+Survey!E24)*0.5)*C3,(Survey!K$21-Survey!E23)*0.5*C3),IF(Survey!E24<Survey!K$21,(Survey!K$21-Survey!E24)*0.5*C3,0)))","v":0},{"$f":"IF(ISNA(Survey!E24),0,IF(Survey!E23<Survey!K$21,IF(Survey!E24<Survey!K$21,(C3^2+(Survey!E24-Survey!E23)^2)^0.5,(C3^2+(Survey!K$21-Survey!E23)^2)^0.5),IF(Survey!E24<Survey!K$21,(C3^2+(Survey!K$21-Survey!E24)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C23<Access!$C$28,'Calc.'!C3,0)","v":0},{"$f":"IF(Survey!$C23>=Access!$C$28,'Calc.'!C3,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C24-Survey!C25<0,1,-1)*(IF(ISNA(Survey!E25),0,IF(Survey!E24<Survey!K$21,IF(Survey!E25<Survey!K$21,((Survey!C25-Survey!C24)^2)^0.5,(((Survey!K$21-Survey!E24)*(Survey!C25-Survey!C24)/(Survey!E25-Survey!E24))^2)^0.5),IF(Survey!E25<Survey!K$21,(((Survey!K$21-Survey!E25)*(Survey!C25-Survey!C24)/(Survey!E24-Survey!E25))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E25),0,IF(Survey!E24<Survey!K$21,IF(Survey!E25<Survey!K$21,(Survey!K$21-(Survey!E24+Survey!E25)*0.5)*C4,(Survey!K$21-Survey!E24)*0.5*C4),IF(Survey!E25<Survey!K$21,(Survey!K$21-Survey!E25)*0.5*C4,0)))","v":0},{"$f":"IF(ISNA(Survey!E25),0,IF(Survey!E24<Survey!K$21,IF(Survey!E25<Survey!K$21,(C4^2+(Survey!E25-Survey!E24)^2)^0.5,(C4^2+(Survey!K$21-Survey!E24)^2)^0.5),IF(Survey!E25<Survey!K$21,(C4^2+(Survey!K$21-Survey!E25)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C24<Access!$C$28,'Calc.'!C4,0)","v":0},{"$f":"IF(Survey!$C24>=Access!$C$28,'Calc.'!C4,0)","v":0},null,null,"GABIONS"]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C25-Survey!C26<0,1,-1)*(IF(ISNA(Survey!E26),0,IF(Survey!E25<Survey!K$21,IF(Survey!E26<Survey!K$21,((Survey!C26-Survey!C25)^2)^0.5,(((Survey!K$21-Survey!E25)*(Survey!C26-Survey!C25)/(Survey!E26-Survey!E25))^2)^0.5),IF(Survey!E26<Survey!K$21,(((Survey!K$21-Survey!E26)*(Survey!C26-Survey!C25)/(Survey!E25-Survey!E26))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E26),0,IF(Survey!E25<Survey!K$21,IF(Survey!E26<Survey!K$21,(Survey!K$21-(Survey!E25+Survey!E26)*0.5)*C5,(Survey!K$21-Survey!E25)*0.5*C5),IF(Survey!E26<Survey!K$21,(Survey!K$21-Survey!E26)*0.5*C5,0)))","v":0},{"$f":"IF(ISNA(Survey!E26),0,IF(Survey!E25<Survey!K$21,IF(Survey!E26<Survey!K$21,(C5^2+(Survey!E26-Survey!E25)^2)^0.5,(C5^2+(Survey!K$21-Survey!E25)^2)^0.5),IF(Survey!E26<Survey!K$21,(C5^2+(Survey!K$21-Survey!E26)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C25<Access!$C$28,'Calc.'!C5,0)","v":0},{"$f":"IF(Survey!$C25>=Access!$C$28,'Calc.'!C5,0)","v":0},"R-3",null,"AASHTO #1"]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C26-Survey!C27<0,1,-1)*(IF(ISNA(Survey!E27),0,IF(Survey!E26<Survey!K$21,IF(Survey!E27<Survey!K$21,((Survey!C27-Survey!C26)^2)^0.5,(((Survey!K$21-Survey!E26)*(Survey!C27-Survey!C26)/(Survey!E27-Survey!E26))^2)^0.5),IF(Survey!E27<Survey!K$21,(((Survey!K$21-Survey!E27)*(Survey!C27-Survey!C26)/(Survey!E26-Survey!E27))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E27),0,IF(Survey!E26<Survey!K$21,IF(Survey!E27<Survey!K$21,(Survey!K$21-(Survey!E26+Survey!E27)*0.5)*C6,(Survey!K$21-Survey!E26)*0.5*C6),IF(Survey!E27<Survey!K$21,(Survey!K$21-Survey!E27)*0.5*C6,0)))","v":0},{"$f":"IF(ISNA(Survey!E27),0,IF(Survey!E26<Survey!K$21,IF(Survey!E27<Survey!K$21,(C6^2+(Survey!E27-Survey!E26)^2)^0.5,(C6^2+(Survey!K$21-Survey!E26)^2)^0.5),IF(Survey!E27<Survey!K$21,(C6^2+(Survey!K$21-Survey!E27)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C26<Access!$C$28,'Calc.'!C6,0)","v":0},{"$f":"IF(Survey!$C26>=Access!$C$28,'Calc.'!C6,0)","v":0},"R-4"]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C27-Survey!C28<0,1,-1)*(IF(ISNA(Survey!E28),0,IF(Survey!E27<Survey!K$21,IF(Survey!E28<Survey!K$21,((Survey!C28-Survey!C27)^2)^0.5,(((Survey!K$21-Survey!E27)*(Survey!C28-Survey!C27)/(Survey!E28-Survey!E27))^2)^0.5),IF(Survey!E28<Survey!K$21,(((Survey!K$21-Survey!E28)*(Survey!C28-Survey!C27)/(Survey!E27-Survey!E28))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E28),0,IF(Survey!E27<Survey!K$21,IF(Survey!E28<Survey!K$21,(Survey!K$21-(Survey!E27+Survey!E28)*0.5)*C7,(Survey!K$21-Survey!E27)*0.5*C7),IF(Survey!E28<Survey!K$21,(Survey!K$21-Survey!E28)*0.5*C7,0)))","v":0},{"$f":"IF(ISNA(Survey!E28),0,IF(Survey!E27<Survey!K$21,IF(Survey!E28<Survey!K$21,(C7^2+(Survey!E28-Survey!E27)^2)^0.5,(C7^2+(Survey!K$21-Survey!E27)^2)^0.5),IF(Survey!E28<Survey!K$21,(C7^2+(Survey!K$21-Survey!E28)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C27<Access!$C$28,'Calc.'!C7,0)","v":0},{"$f":"IF(Survey!$C27>=Access!$C$28,'Calc.'!C7,0)","v":0},"R-5",null,"AASHTO 57"]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C28-Survey!C29<0,1,-1)*(IF(ISNA(Survey!E29),0,IF(Survey!E28<Survey!K$21,IF(Survey!E29<Survey!K$21,((Survey!C29-Survey!C28)^2)^0.5,(((Survey!K$21-Survey!E28)*(Survey!C29-Survey!C28)/(Survey!E29-Survey!E28))^2)^0.5),IF(Survey!E29<Survey!K$21,(((Survey!K$21-Survey!E29)*(Survey!C29-Survey!C28)/(Survey!E28-Survey!E29))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E29),0,IF(Survey!E28<Survey!K$21,IF(Survey!E29<Survey!K$21,(Survey!K$21-(Survey!E28+Survey!E29)*0.5)*C8,(Survey!K$21-Survey!E28)*0.5*C8),IF(Survey!E29<Survey!K$21,(Survey!K$21-Survey!E29)*0.5*C8,0)))","v":0},{"$f":"IF(ISNA(Survey!E29),0,IF(Survey!E28<Survey!K$21,IF(Survey!E29<Survey!K$21,(C8^2+(Survey!E29-Survey!E28)^2)^0.5,(C8^2+(Survey!K$21-Survey!E28)^2)^0.5),IF(Survey!E29<Survey!K$21,(C8^2+(Survey!K$21-Survey!E29)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C28<Access!$C$28,'Calc.'!C8,0)","v":0},{"$f":"IF(Survey!$C28>=Access!$C$28,'Calc.'!C8,0)","v":0},"R-6",null,"MODIFIED 2A"]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C29-Survey!C30<0,1,-1)*(IF(ISNA(Survey!E30),0,IF(Survey!E29<Survey!K$21,IF(Survey!E30<Survey!K$21,((Survey!C30-Survey!C29)^2)^0.5,(((Survey!K$21-Survey!E29)*(Survey!C30-Survey!C29)/(Survey!E30-Survey!E29))^2)^0.5),IF(Survey!E30<Survey!K$21,(((Survey!K$21-Survey!E30)*(Survey!C30-Survey!C29)/(Survey!E29-Survey!E30))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E30),0,IF(Survey!E29<Survey!K$21,IF(Survey!E30<Survey!K$21,(Survey!K$21-(Survey!E29+Survey!E30)*0.5)*C9,(Survey!K$21-Survey!E29)*0.5*C9),IF(Survey!E30<Survey!K$21,(Survey!K$21-Survey!E30)*0.5*C9,0)))","v":0},{"$f":"IF(ISNA(Survey!E30),0,IF(Survey!E29<Survey!K$21,IF(Survey!E30<Survey!K$21,(C9^2+(Survey!E30-Survey!E29)^2)^0.5,(C9^2+(Survey!K$21-Survey!E29)^2)^0.5),IF(Survey!E30<Survey!K$21,(C9^2+(Survey!K$21-Survey!E30)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C29<Access!$C$28,'Calc.'!C9,0)","v":0},{"$f":"IF(Survey!$C29>=Access!$C$28,'Calc.'!C9,0)","v":0},"R-7"]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C30-Survey!C31<0,1,-1)*(IF(ISNA(Survey!E31),0,IF(Survey!E30<Survey!K$21,IF(Survey!E31<Survey!K$21,((Survey!C31-Survey!C30)^2)^0.5,(((Survey!K$21-Survey!E30)*(Survey!C31-Survey!C30)/(Survey!E31-Survey!E30))^2)^0.5),IF(Survey!E31<Survey!K$21,(((Survey!K$21-Survey!E31)*(Survey!C31-Survey!C30)/(Survey!E30-Survey!E31))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E31),0,IF(Survey!E30<Survey!K$21,IF(Survey!E31<Survey!K$21,(Survey!K$21-(Survey!E30+Survey!E31)*0.5)*C10,(Survey!K$21-Survey!E30)*0.5*C10),IF(Survey!E31<Survey!K$21,(Survey!K$21-Survey!E31)*0.5*C10,0)))","v":0},{"$f":"IF(ISNA(Survey!E31),0,IF(Survey!E30<Survey!K$21,IF(Survey!E31<Survey!K$21,(C10^2+(Survey!E31-Survey!E30)^2)^0.5,(C10^2+(Survey!K$21-Survey!E30)^2)^0.5),IF(Survey!E31<Survey!K$21,(C10^2+(Survey!K$21-Survey!E31)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C30<Access!$C$28,'Calc.'!C10,0)","v":0},{"$f":"IF(Survey!$C30>=Access!$C$28,'Calc.'!C10,0)","v":0},"R-8"]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C31-Survey!C32<0,1,-1)*(IF(ISNA(Survey!E32),0,IF(Survey!E31<Survey!K$21,IF(Survey!E32<Survey!K$21,((Survey!C32-Survey!C31)^2)^0.5,(((Survey!K$21-Survey!E31)*(Survey!C32-Survey!C31)/(Survey!E32-Survey!E31))^2)^0.5),IF(Survey!E32<Survey!K$21,(((Survey!K$21-Survey!E32)*(Survey!C32-Survey!C31)/(Survey!E31-Survey!E32))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E32),0,IF(Survey!E31<Survey!K$21,IF(Survey!E32<Survey!K$21,(Survey!K$21-(Survey!E31+Survey!E32)*0.5)*C11,(Survey!K$21-Survey!E31)*0.5*C11),IF(Survey!E32<Survey!K$21,(Survey!K$21-Survey!E32)*0.5*C11,0)))","v":0},{"$f":"IF(ISNA(Survey!E32),0,IF(Survey!E31<Survey!K$21,IF(Survey!E32<Survey!K$21,(C11^2+(Survey!E32-Survey!E31)^2)^0.5,(C11^2+(Survey!K$21-Survey!E31)^2)^0.5),IF(Survey!E32<Survey!K$21,(C11^2+(Survey!K$21-Survey!E32)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C31<Access!$C$28,'Calc.'!C11,0)","v":0},{"$f":"IF(Survey!$C31>=Access!$C$28,'Calc.'!C11,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C32-Survey!C33<0,1,-1)*(IF(ISNA(Survey!E33),0,IF(Survey!E32<Survey!K$21,IF(Survey!E33<Survey!K$21,((Survey!C33-Survey!C32)^2)^0.5,(((Survey!K$21-Survey!E32)*(Survey!C33-Survey!C32)/(Survey!E33-Survey!E32))^2)^0.5),IF(Survey!E33<Survey!K$21,(((Survey!K$21-Survey!E33)*(Survey!C33-Survey!C32)/(Survey!E32-Survey!E33))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E33),0,IF(Survey!E32<Survey!K$21,IF(Survey!E33<Survey!K$21,(Survey!K$21-(Survey!E32+Survey!E33)*0.5)*C12,(Survey!K$21-Survey!E32)*0.5*C12),IF(Survey!E33<Survey!K$21,(Survey!K$21-Survey!E33)*0.5*C12,0)))","v":0},{"$f":"IF(ISNA(Survey!E33),0,IF(Survey!E32<Survey!K$21,IF(Survey!E33<Survey!K$21,(C12^2+(Survey!E33-Survey!E32)^2)^0.5,(C12^2+(Survey!K$21-Survey!E32)^2)^0.5),IF(Survey!E33<Survey!K$21,(C12^2+(Survey!K$21-Survey!E33)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C32<Access!$C$28,'Calc.'!C12,0)","v":0},{"$f":"IF(Survey!$C32>=Access!$C$28,'Calc.'!C12,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C33-Survey!C34<0,1,-1)*(IF(ISNA(Survey!E34),0,IF(Survey!E33<Survey!K$21,IF(Survey!E34<Survey!K$21,((Survey!C34-Survey!C33)^2)^0.5,(((Survey!K$21-Survey!E33)*(Survey!C34-Survey!C33)/(Survey!E34-Survey!E33))^2)^0.5),IF(Survey!E34<Survey!K$21,(((Survey!K$21-Survey!E34)*(Survey!C34-Survey!C33)/(Survey!E33-Survey!E34))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E34),0,IF(Survey!E33<Survey!K$21,IF(Survey!E34<Survey!K$21,(Survey!K$21-(Survey!E33+Survey!E34)*0.5)*C13,(Survey!K$21-Survey!E33)*0.5*C13),IF(Survey!E34<Survey!K$21,(Survey!K$21-Survey!E34)*0.5*C13,0)))","v":0},{"$f":"IF(ISNA(Survey!E34),0,IF(Survey!E33<Survey!K$21,IF(Survey!E34<Survey!K$21,(C13^2+(Survey!E34-Survey!E33)^2)^0.5,(C13^2+(Survey!K$21-Survey!E33)^2)^0.5),IF(Survey!E34<Survey!K$21,(C13^2+(Survey!K$21-Survey!E34)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C33<Access!$C$28,'Calc.'!C13,0)","v":0},{"$f":"IF(Survey!$C33>=Access!$C$28,'Calc.'!C13,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C34-Survey!C35<0,1,-1)*(IF(ISNA(Survey!E35),0,IF(Survey!E34<Survey!K$21,IF(Survey!E35<Survey!K$21,((Survey!C35-Survey!C34)^2)^0.5,(((Survey!K$21-Survey!E34)*(Survey!C35-Survey!C34)/(Survey!E35-Survey!E34))^2)^0.5),IF(Survey!E35<Survey!K$21,(((Survey!K$21-Survey!E35)*(Survey!C35-Survey!C34)/(Survey!E34-Survey!E35))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E35),0,IF(Survey!E34<Survey!K$21,IF(Survey!E35<Survey!K$21,(Survey!K$21-(Survey!E34+Survey!E35)*0.5)*C14,(Survey!K$21-Survey!E34)*0.5*C14),IF(Survey!E35<Survey!K$21,(Survey!K$21-Survey!E35)*0.5*C14,0)))","v":0},{"$f":"IF(ISNA(Survey!E35),0,IF(Survey!E34<Survey!K$21,IF(Survey!E35<Survey!K$21,(C14^2+(Survey!E35-Survey!E34)^2)^0.5,(C14^2+(Survey!K$21-Survey!E34)^2)^0.5),IF(Survey!E35<Survey!K$21,(C14^2+(Survey!K$21-Survey!E35)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C34<Access!$C$28,'Calc.'!C14,0)","v":0},{"$f":"IF(Survey!$C34>=Access!$C$28,'Calc.'!C14,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C35-Survey!C36<0,1,-1)*(IF(ISNA(Survey!E36),0,IF(Survey!E35<Survey!K$21,IF(Survey!E36<Survey!K$21,((Survey!C36-Survey!C35)^2)^0.5,(((Survey!K$21-Survey!E35)*(Survey!C36-Survey!C35)/(Survey!E36-Survey!E35))^2)^0.5),IF(Survey!E36<Survey!K$21,(((Survey!K$21-Survey!E36)*(Survey!C36-Survey!C35)/(Survey!E35-Survey!E36))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E36),0,IF(Survey!E35<Survey!K$21,IF(Survey!E36<Survey!K$21,(Survey!K$21-(Survey!E35+Survey!E36)*0.5)*C15,(Survey!K$21-Survey!E35)*0.5*C15),IF(Survey!E36<Survey!K$21,(Survey!K$21-Survey!E36)*0.5*C15,0)))","v":0},{"$f":"IF(ISNA(Survey!E36),0,IF(Survey!E35<Survey!K$21,IF(Survey!E36<Survey!K$21,(C15^2+(Survey!E36-Survey!E35)^2)^0.5,(C15^2+(Survey!K$21-Survey!E35)^2)^0.5),IF(Survey!E36<Survey!K$21,(C15^2+(Survey!K$21-Survey!E36)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C35<Access!$C$28,'Calc.'!C15,0)","v":0},{"$f":"IF(Survey!$C35>=Access!$C$28,'Calc.'!C15,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C36-Survey!C37<0,1,-1)*(IF(ISNA(Survey!E37),0,IF(Survey!E36<Survey!K$21,IF(Survey!E37<Survey!K$21,((Survey!C37-Survey!C36)^2)^0.5,(((Survey!K$21-Survey!E36)*(Survey!C37-Survey!C36)/(Survey!E37-Survey!E36))^2)^0.5),IF(Survey!E37<Survey!K$21,(((Survey!K$21-Survey!E37)*(Survey!C37-Survey!C36)/(Survey!E36-Survey!E37))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E37),0,IF(Survey!E36<Survey!K$21,IF(Survey!E37<Survey!K$21,(Survey!K$21-(Survey!E36+Survey!E37)*0.5)*C16,(Survey!K$21-Survey!E36)*0.5*C16),IF(Survey!E37<Survey!K$21,(Survey!K$21-Survey!E37)*0.5*C16,0)))","v":0},{"$f":"IF(ISNA(Survey!E37),0,IF(Survey!E36<Survey!K$21,IF(Survey!E37<Survey!K$21,(C16^2+(Survey!E37-Survey!E36)^2)^0.5,(C16^2+(Survey!K$21-Survey!E36)^2)^0.5),IF(Survey!E37<Survey!K$21,(C16^2+(Survey!K$21-Survey!E37)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C36<Access!$C$28,'Calc.'!C16,0)","v":0},{"$f":"IF(Survey!$C36>=Access!$C$28,'Calc.'!C16,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C37-Survey!C38<0,1,-1)*(IF(ISNA(Survey!E38),0,IF(Survey!E37<Survey!K$21,IF(Survey!E38<Survey!K$21,((Survey!C38-Survey!C37)^2)^0.5,(((Survey!K$21-Survey!E37)*(Survey!C38-Survey!C37)/(Survey!E38-Survey!E37))^2)^0.5),IF(Survey!E38<Survey!K$21,(((Survey!K$21-Survey!E38)*(Survey!C38-Survey!C37)/(Survey!E37-Survey!E38))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E38),0,IF(Survey!E37<Survey!K$21,IF(Survey!E38<Survey!K$21,(Survey!K$21-(Survey!E37+Survey!E38)*0.5)*C17,(Survey!K$21-Survey!E37)*0.5*C17),IF(Survey!E38<Survey!K$21,(Survey!K$21-Survey!E38)*0.5*C17,0)))","v":0},{"$f":"IF(ISNA(Survey!E38),0,IF(Survey!E37<Survey!K$21,IF(Survey!E38<Survey!K$21,(C17^2+(Survey!E38-Survey!E37)^2)^0.5,(C17^2+(Survey!K$21-Survey!E37)^2)^0.5),IF(Survey!E38<Survey!K$21,(C17^2+(Survey!K$21-Survey!E38)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C37<Access!$C$28,'Calc.'!C17,0)","v":0},{"$f":"IF(Survey!$C37>=Access!$C$28,'Calc.'!C17,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C38-Survey!C39<0,1,-1)*(IF(ISNA(Survey!E39),0,IF(Survey!E38<Survey!K$21,IF(Survey!E39<Survey!K$21,((Survey!C39-Survey!C38)^2)^0.5,(((Survey!K$21-Survey!E38)*(Survey!C39-Survey!C38)/(Survey!E39-Survey!E38))^2)^0.5),IF(Survey!E39<Survey!K$21,(((Survey!K$21-Survey!E39)*(Survey!C39-Survey!C38)/(Survey!E38-Survey!E39))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E39),0,IF(Survey!E38<Survey!K$21,IF(Survey!E39<Survey!K$21,(Survey!K$21-(Survey!E38+Survey!E39)*0.5)*C18,(Survey!K$21-Survey!E38)*0.5*C18),IF(Survey!E39<Survey!K$21,(Survey!K$21-Survey!E39)*0.5*C18,0)))","v":0},{"$f":"IF(ISNA(Survey!E39),0,IF(Survey!E38<Survey!K$21,IF(Survey!E39<Survey!K$21,(C18^2+(Survey!E39-Survey!E38)^2)^0.5,(C18^2+(Survey!K$21-Survey!E38)^2)^0.5),IF(Survey!E39<Survey!K$21,(C18^2+(Survey!K$21-Survey!E39)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C38<Access!$C$28,'Calc.'!C18,0)","v":0},{"$f":"IF(Survey!$C38>=Access!$C$28,'Calc.'!C18,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C39-Survey!C40<0,1,-1)*(IF(ISNA(Survey!E40),0,IF(Survey!E39<Survey!K$21,IF(Survey!E40<Survey!K$21,((Survey!C40-Survey!C39)^2)^0.5,(((Survey!K$21-Survey!E39)*(Survey!C40-Survey!C39)/(Survey!E40-Survey!E39))^2)^0.5),IF(Survey!E40<Survey!K$21,(((Survey!K$21-Survey!E40)*(Survey!C40-Survey!C39)/(Survey!E39-Survey!E40))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E40),0,IF(Survey!E39<Survey!K$21,IF(Survey!E40<Survey!K$21,(Survey!K$21-(Survey!E39+Survey!E40)*0.5)*C19,(Survey!K$21-Survey!E39)*0.5*C19),IF(Survey!E40<Survey!K$21,(Survey!K$21-Survey!E40)*0.5*C19,0)))","v":0},{"$f":"IF(ISNA(Survey!E40),0,IF(Survey!E39<Survey!K$21,IF(Survey!E40<Survey!K$21,(C19^2+(Survey!E40-Survey!E39)^2)^0.5,(C19^2+(Survey!K$21-Survey!E39)^2)^0.5),IF(Survey!E40<Survey!K$21,(C19^2+(Survey!K$21-Survey!E40)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C39<Access!$C$28,'Calc.'!C19,0)","v":0},{"$f":"IF(Survey!$C39>=Access!$C$28,'Calc.'!C19,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C40-Survey!C41<0,1,-1)*(IF(ISNA(Survey!E41),0,IF(Survey!E40<Survey!K$21,IF(Survey!E41<Survey!K$21,((Survey!C41-Survey!C40)^2)^0.5,(((Survey!K$21-Survey!E40)*(Survey!C41-Survey!C40)/(Survey!E41-Survey!E40))^2)^0.5),IF(Survey!E41<Survey!K$21,(((Survey!K$21-Survey!E41)*(Survey!C41-Survey!C40)/(Survey!E40-Survey!E41))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E41),0,IF(Survey!E40<Survey!K$21,IF(Survey!E41<Survey!K$21,(Survey!K$21-(Survey!E40+Survey!E41)*0.5)*C20,(Survey!K$21-Survey!E40)*0.5*C20),IF(Survey!E41<Survey!K$21,(Survey!K$21-Survey!E41)*0.5*C20,0)))","v":0},{"$f":"IF(ISNA(Survey!E41),0,IF(Survey!E40<Survey!K$21,IF(Survey!E41<Survey!K$21,(C20^2+(Survey!E41-Survey!E40)^2)^0.5,(C20^2+(Survey!K$21-Survey!E40)^2)^0.5),IF(Survey!E41<Survey!K$21,(C20^2+(Survey!K$21-Survey!E41)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C40<Access!$C$28,'Calc.'!C20,0)","v":0},{"$f":"IF(Survey!$C40>=Access!$C$28,'Calc.'!C20,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C41-Survey!C42<0,1,-1)*(IF(ISNA(Survey!E42),0,IF(Survey!E41<Survey!K$21,IF(Survey!E42<Survey!K$21,((Survey!C42-Survey!C41)^2)^0.5,(((Survey!K$21-Survey!E41)*(Survey!C42-Survey!C41)/(Survey!E42-Survey!E41))^2)^0.5),IF(Survey!E42<Survey!K$21,(((Survey!K$21-Survey!E42)*(Survey!C42-Survey!C41)/(Survey!E41-Survey!E42))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E42),0,IF(Survey!E41<Survey!K$21,IF(Survey!E42<Survey!K$21,(Survey!K$21-(Survey!E41+Survey!E42)*0.5)*C21,(Survey!K$21-Survey!E41)*0.5*C21),IF(Survey!E42<Survey!K$21,(Survey!K$21-Survey!E42)*0.5*C21,0)))","v":0},{"$f":"IF(ISNA(Survey!E42),0,IF(Survey!E41<Survey!K$21,IF(Survey!E42<Survey!K$21,(C21^2+(Survey!E42-Survey!E41)^2)^0.5,(C21^2+(Survey!K$21-Survey!E41)^2)^0.5),IF(Survey!E42<Survey!K$21,(C21^2+(Survey!K$21-Survey!E42)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C41<Access!$C$28,'Calc.'!C21,0)","v":0},{"$f":"IF(Survey!$C41>=Access!$C$28,'Calc.'!C21,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C42-Survey!C43<0,1,-1)*(IF(ISNA(Survey!E43),0,IF(Survey!E42<Survey!K$21,IF(Survey!E43<Survey!K$21,((Survey!C43-Survey!C42)^2)^0.5,(((Survey!K$21-Survey!E42)*(Survey!C43-Survey!C42)/(Survey!E43-Survey!E42))^2)^0.5),IF(Survey!E43<Survey!K$21,(((Survey!K$21-Survey!E43)*(Survey!C43-Survey!C42)/(Survey!E42-Survey!E43))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E43),0,IF(Survey!E42<Survey!K$21,IF(Survey!E43<Survey!K$21,(Survey!K$21-(Survey!E42+Survey!E43)*0.5)*C22,(Survey!K$21-Survey!E42)*0.5*C22),IF(Survey!E43<Survey!K$21,(Survey!K$21-Survey!E43)*0.5*C22,0)))","v":0},{"$f":"IF(ISNA(Survey!E43),0,IF(Survey!E42<Survey!K$21,IF(Survey!E43<Survey!K$21,(C22^2+(Survey!E43-Survey!E42)^2)^0.5,(C22^2+(Survey!K$21-Survey!E42)^2)^0.5),IF(Survey!E43<Survey!K$21,(C22^2+(Survey!K$21-Survey!E43)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C42<Access!$C$28,'Calc.'!C22,0)","v":0},{"$f":"IF(Survey!$C42>=Access!$C$28,'Calc.'!C22,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C43-Survey!C44<0,1,-1)*(IF(ISNA(Survey!E44),0,IF(Survey!E43<Survey!K$21,IF(Survey!E44<Survey!K$21,((Survey!C44-Survey!C43)^2)^0.5,(((Survey!K$21-Survey!E43)*(Survey!C44-Survey!C43)/(Survey!E44-Survey!E43))^2)^0.5),IF(Survey!E44<Survey!K$21,(((Survey!K$21-Survey!E44)*(Survey!C44-Survey!C43)/(Survey!E43-Survey!E44))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E44),0,IF(Survey!E43<Survey!K$21,IF(Survey!E44<Survey!K$21,(Survey!K$21-(Survey!E43+Survey!E44)*0.5)*C23,(Survey!K$21-Survey!E43)*0.5*C23),IF(Survey!E44<Survey!K$21,(Survey!K$21-Survey!E44)*0.5*C23,0)))","v":0},{"$f":"IF(ISNA(Survey!E44),0,IF(Survey!E43<Survey!K$21,IF(Survey!E44<Survey!K$21,(C23^2+(Survey!E44-Survey!E43)^2)^0.5,(C23^2+(Survey!K$21-Survey!E43)^2)^0.5),IF(Survey!E44<Survey!K$21,(C23^2+(Survey!K$21-Survey!E44)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C43<Access!$C$28,'Calc.'!C23,0)","v":0},{"$f":"IF(Survey!$C43>=Access!$C$28,'Calc.'!C23,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C44-Survey!C45<0,1,-1)*(IF(ISNA(Survey!E45),0,IF(Survey!E44<Survey!K$21,IF(Survey!E45<Survey!K$21,((Survey!C45-Survey!C44)^2)^0.5,(((Survey!K$21-Survey!E44)*(Survey!C45-Survey!C44)/(Survey!E45-Survey!E44))^2)^0.5),IF(Survey!E45<Survey!K$21,(((Survey!K$21-Survey!E45)*(Survey!C45-Survey!C44)/(Survey!E44-Survey!E45))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E45),0,IF(Survey!E44<Survey!K$21,IF(Survey!E45<Survey!K$21,(Survey!K$21-(Survey!E44+Survey!E45)*0.5)*C24,(Survey!K$21-Survey!E44)*0.5*C24),IF(Survey!E45<Survey!K$21,(Survey!K$21-Survey!E45)*0.5*C24,0)))","v":0},{"$f":"IF(ISNA(Survey!E45),0,IF(Survey!E44<Survey!K$21,IF(Survey!E45<Survey!K$21,(C24^2+(Survey!E45-Survey!E44)^2)^0.5,(C24^2+(Survey!K$21-Survey!E44)^2)^0.5),IF(Survey!E45<Survey!K$21,(C24^2+(Survey!K$21-Survey!E45)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C44<Access!$C$28,'Calc.'!C24,0)","v":0},{"$f":"IF(Survey!$C44>=Access!$C$28,'Calc.'!C24,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C45-Survey!C46<0,1,-1)*(IF(ISNA(Survey!E46),0,IF(Survey!E45<Survey!K$21,IF(Survey!E46<Survey!K$21,((Survey!C46-Survey!C45)^2)^0.5,(((Survey!K$21-Survey!E45)*(Survey!C46-Survey!C45)/(Survey!E46-Survey!E45))^2)^0.5),IF(Survey!E46<Survey!K$21,(((Survey!K$21-Survey!E46)*(Survey!C46-Survey!C45)/(Survey!E45-Survey!E46))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E46),0,IF(Survey!E45<Survey!K$21,IF(Survey!E46<Survey!K$21,(Survey!K$21-(Survey!E45+Survey!E46)*0.5)*C25,(Survey!K$21-Survey!E45)*0.5*C25),IF(Survey!E46<Survey!K$21,(Survey!K$21-Survey!E46)*0.5*C25,0)))","v":0},{"$f":"IF(ISNA(Survey!E46),0,IF(Survey!E45<Survey!K$21,IF(Survey!E46<Survey!K$21,(C25^2+(Survey!E46-Survey!E45)^2)^0.5,(C25^2+(Survey!K$21-Survey!E45)^2)^0.5),IF(Survey!E46<Survey!K$21,(C25^2+(Survey!K$21-Survey!E46)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C45<Access!$C$28,'Calc.'!C25,0)","v":0},{"$f":"IF(Survey!$C45>=Access!$C$28,'Calc.'!C25,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C46-Survey!C47<0,1,-1)*(IF(ISNA(Survey!E47),0,IF(Survey!E46<Survey!K$21,IF(Survey!E47<Survey!K$21,((Survey!C47-Survey!C46)^2)^0.5,(((Survey!K$21-Survey!E46)*(Survey!C47-Survey!C46)/(Survey!E47-Survey!E46))^2)^0.5),IF(Survey!E47<Survey!K$21,(((Survey!K$21-Survey!E47)*(Survey!C47-Survey!C46)/(Survey!E46-Survey!E47))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E47),0,IF(Survey!E46<Survey!K$21,IF(Survey!E47<Survey!K$21,(Survey!K$21-(Survey!E46+Survey!E47)*0.5)*C26,(Survey!K$21-Survey!E46)*0.5*C26),IF(Survey!E47<Survey!K$21,(Survey!K$21-Survey!E47)*0.5*C26,0)))","v":0},{"$f":"IF(ISNA(Survey!E47),0,IF(Survey!E46<Survey!K$21,IF(Survey!E47<Survey!K$21,(C26^2+(Survey!E47-Survey!E46)^2)^0.5,(C26^2+(Survey!K$21-Survey!E46)^2)^0.5),IF(Survey!E47<Survey!K$21,(C26^2+(Survey!K$21-Survey!E47)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C46<Access!$C$28,'Calc.'!C26,0)","v":0},{"$f":"IF(Survey!$C46>=Access!$C$28,'Calc.'!C26,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C47-Survey!C48<0,1,-1)*(IF(ISNA(Survey!E48),0,IF(Survey!E47<Survey!K$21,IF(Survey!E48<Survey!K$21,((Survey!C48-Survey!C47)^2)^0.5,(((Survey!K$21-Survey!E47)*(Survey!C48-Survey!C47)/(Survey!E48-Survey!E47))^2)^0.5),IF(Survey!E48<Survey!K$21,(((Survey!K$21-Survey!E48)*(Survey!C48-Survey!C47)/(Survey!E47-Survey!E48))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E48),0,IF(Survey!E47<Survey!K$21,IF(Survey!E48<Survey!K$21,(Survey!K$21-(Survey!E47+Survey!E48)*0.5)*C27,(Survey!K$21-Survey!E47)*0.5*C27),IF(Survey!E48<Survey!K$21,(Survey!K$21-Survey!E48)*0.5*C27,0)))","v":0},{"$f":"IF(ISNA(Survey!E48),0,IF(Survey!E47<Survey!K$21,IF(Survey!E48<Survey!K$21,(C27^2+(Survey!E48-Survey!E47)^2)^0.5,(C27^2+(Survey!K$21-Survey!E47)^2)^0.5),IF(Survey!E48<Survey!K$21,(C27^2+(Survey!K$21-Survey!E48)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C47<Access!$C$28,'Calc.'!C27,0)","v":0},{"$f":"IF(Survey!$C47>=Access!$C$28,'Calc.'!C27,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C48-Survey!C49<0,1,-1)*(IF(ISNA(Survey!E49),0,IF(Survey!E48<Survey!K$21,IF(Survey!E49<Survey!K$21,((Survey!C49-Survey!C48)^2)^0.5,(((Survey!K$21-Survey!E48)*(Survey!C49-Survey!C48)/(Survey!E49-Survey!E48))^2)^0.5),IF(Survey!E49<Survey!K$21,(((Survey!K$21-Survey!E49)*(Survey!C49-Survey!C48)/(Survey!E48-Survey!E49))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E49),0,IF(Survey!E48<Survey!K$21,IF(Survey!E49<Survey!K$21,(Survey!K$21-(Survey!E48+Survey!E49)*0.5)*C28,(Survey!K$21-Survey!E48)*0.5*C28),IF(Survey!E49<Survey!K$21,(Survey!K$21-Survey!E49)*0.5*C28,0)))","v":0},{"$f":"IF(ISNA(Survey!E49),0,IF(Survey!E48<Survey!K$21,IF(Survey!E49<Survey!K$21,(C28^2+(Survey!E49-Survey!E48)^2)^0.5,(C28^2+(Survey!K$21-Survey!E48)^2)^0.5),IF(Survey!E49<Survey!K$21,(C28^2+(Survey!K$21-Survey!E49)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C48<Access!$C$28,'Calc.'!C28,0)","v":0},{"$f":"IF(Survey!$C48>=Access!$C$28,'Calc.'!C28,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C49-Survey!C50<0,1,-1)*(IF(ISNA(Survey!E50),0,IF(Survey!E49<Survey!K$21,IF(Survey!E50<Survey!K$21,((Survey!C50-Survey!C49)^2)^0.5,(((Survey!K$21-Survey!E49)*(Survey!C50-Survey!C49)/(Survey!E50-Survey!E49))^2)^0.5),IF(Survey!E50<Survey!K$21,(((Survey!K$21-Survey!E50)*(Survey!C50-Survey!C49)/(Survey!E49-Survey!E50))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E50),0,IF(Survey!E49<Survey!K$21,IF(Survey!E50<Survey!K$21,(Survey!K$21-(Survey!E49+Survey!E50)*0.5)*C29,(Survey!K$21-Survey!E49)*0.5*C29),IF(Survey!E50<Survey!K$21,(Survey!K$21-Survey!E50)*0.5*C29,0)))","v":0},{"$f":"IF(ISNA(Survey!E50),0,IF(Survey!E49<Survey!K$21,IF(Survey!E50<Survey!K$21,(C29^2+(Survey!E50-Survey!E49)^2)^0.5,(C29^2+(Survey!K$21-Survey!E49)^2)^0.5),IF(Survey!E50<Survey!K$21,(C29^2+(Survey!K$21-Survey!E50)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C49<Access!$C$28,'Calc.'!C29,0)","v":0},{"$f":"IF(Survey!$C49>=Access!$C$28,'Calc.'!C29,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C50-Survey!C51<0,1,-1)*(IF(ISNA(Survey!E51),0,IF(Survey!E50<Survey!K$21,IF(Survey!E51<Survey!K$21,((Survey!C51-Survey!C50)^2)^0.5,(((Survey!K$21-Survey!E50)*(Survey!C51-Survey!C50)/(Survey!E51-Survey!E50))^2)^0.5),IF(Survey!E51<Survey!K$21,(((Survey!K$21-Survey!E51)*(Survey!C51-Survey!C50)/(Survey!E50-Survey!E51))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E51),0,IF(Survey!E50<Survey!K$21,IF(Survey!E51<Survey!K$21,(Survey!K$21-(Survey!E50+Survey!E51)*0.5)*C30,(Survey!K$21-Survey!E50)*0.5*C30),IF(Survey!E51<Survey!K$21,(Survey!K$21-Survey!E51)*0.5*C30,0)))","v":0},{"$f":"IF(ISNA(Survey!E51),0,IF(Survey!E50<Survey!K$21,IF(Survey!E51<Survey!K$21,(C30^2+(Survey!E51-Survey!E50)^2)^0.5,(C30^2+(Survey!K$21-Survey!E50)^2)^0.5),IF(Survey!E51<Survey!K$21,(C30^2+(Survey!K$21-Survey!E51)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C50<Access!$C$28,'Calc.'!C30,0)","v":0},{"$f":"IF(Survey!$C50>=Access!$C$28,'Calc.'!C30,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C51-Survey!C52<0,1,-1)*(IF(ISNA(Survey!E52),0,IF(Survey!E51<Survey!K$21,IF(Survey!E52<Survey!K$21,((Survey!C52-Survey!C51)^2)^0.5,(((Survey!K$21-Survey!E51)*(Survey!C52-Survey!C51)/(Survey!E52-Survey!E51))^2)^0.5),IF(Survey!E52<Survey!K$21,(((Survey!K$21-Survey!E52)*(Survey!C52-Survey!C51)/(Survey!E51-Survey!E52))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E52),0,IF(Survey!E51<Survey!K$21,IF(Survey!E52<Survey!K$21,(Survey!K$21-(Survey!E51+Survey!E52)*0.5)*C31,(Survey!K$21-Survey!E51)*0.5*C31),IF(Survey!E52<Survey!K$21,(Survey!K$21-Survey!E52)*0.5*C31,0)))","v":0},{"$f":"IF(ISNA(Survey!E52),0,IF(Survey!E51<Survey!K$21,IF(Survey!E52<Survey!K$21,(C31^2+(Survey!E52-Survey!E51)^2)^0.5,(C31^2+(Survey!K$21-Survey!E51)^2)^0.5),IF(Survey!E52<Survey!K$21,(C31^2+(Survey!K$21-Survey!E52)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C51<Access!$C$28,'Calc.'!C31,0)","v":0},{"$f":"IF(Survey!$C51>=Access!$C$28,'Calc.'!C31,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C52-Survey!C53<0,1,-1)*(IF(ISNA(Survey!E53),0,IF(Survey!E52<Survey!K$21,IF(Survey!E53<Survey!K$21,((Survey!C53-Survey!C52)^2)^0.5,(((Survey!K$21-Survey!E52)*(Survey!C53-Survey!C52)/(Survey!E53-Survey!E52))^2)^0.5),IF(Survey!E53<Survey!K$21,(((Survey!K$21-Survey!E53)*(Survey!C53-Survey!C52)/(Survey!E52-Survey!E53))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E53),0,IF(Survey!E52<Survey!K$21,IF(Survey!E53<Survey!K$21,(Survey!K$21-(Survey!E52+Survey!E53)*0.5)*C32,(Survey!K$21-Survey!E52)*0.5*C32),IF(Survey!E53<Survey!K$21,(Survey!K$21-Survey!E53)*0.5*C32,0)))","v":0},{"$f":"IF(ISNA(Survey!E53),0,IF(Survey!E52<Survey!K$21,IF(Survey!E53<Survey!K$21,(C32^2+(Survey!E53-Survey!E52)^2)^0.5,(C32^2+(Survey!K$21-Survey!E52)^2)^0.5),IF(Survey!E53<Survey!K$21,(C32^2+(Survey!K$21-Survey!E53)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C52<Access!$C$28,'Calc.'!C32,0)","v":0},{"$f":"IF(Survey!$C52>=Access!$C$28,'Calc.'!C32,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C53-Survey!C54<0,1,-1)*(IF(ISNA(Survey!E54),0,IF(Survey!E53<Survey!K$21,IF(Survey!E54<Survey!K$21,((Survey!C54-Survey!C53)^2)^0.5,(((Survey!K$21-Survey!E53)*(Survey!C54-Survey!C53)/(Survey!E54-Survey!E53))^2)^0.5),IF(Survey!E54<Survey!K$21,(((Survey!K$21-Survey!E54)*(Survey!C54-Survey!C53)/(Survey!E53-Survey!E54))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E54),0,IF(Survey!E53<Survey!K$21,IF(Survey!E54<Survey!K$21,(Survey!K$21-(Survey!E53+Survey!E54)*0.5)*C33,(Survey!K$21-Survey!E53)*0.5*C33),IF(Survey!E54<Survey!K$21,(Survey!K$21-Survey!E54)*0.5*C33,0)))","v":0},{"$f":"IF(ISNA(Survey!E54),0,IF(Survey!E53<Survey!K$21,IF(Survey!E54<Survey!K$21,(C33^2+(Survey!E54-Survey!E53)^2)^0.5,(C33^2+(Survey!K$21-Survey!E53)^2)^0.5),IF(Survey!E54<Survey!K$21,(C33^2+(Survey!K$21-Survey!E54)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C53<Access!$C$28,'Calc.'!C33,0)","v":0},{"$f":"IF(Survey!$C53>=Access!$C$28,'Calc.'!C33,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C54-Survey!C55<0,1,-1)*(IF(ISNA(Survey!E55),0,IF(Survey!E54<Survey!K$21,IF(Survey!E55<Survey!K$21,((Survey!C55-Survey!C54)^2)^0.5,(((Survey!K$21-Survey!E54)*(Survey!C55-Survey!C54)/(Survey!E55-Survey!E54))^2)^0.5),IF(Survey!E55<Survey!K$21,(((Survey!K$21-Survey!E55)*(Survey!C55-Survey!C54)/(Survey!E54-Survey!E55))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E55),0,IF(Survey!E54<Survey!K$21,IF(Survey!E55<Survey!K$21,(Survey!K$21-(Survey!E54+Survey!E55)*0.5)*C34,(Survey!K$21-Survey!E54)*0.5*C34),IF(Survey!E55<Survey!K$21,(Survey!K$21-Survey!E55)*0.5*C34,0)))","v":0},{"$f":"IF(ISNA(Survey!E55),0,IF(Survey!E54<Survey!K$21,IF(Survey!E55<Survey!K$21,(C34^2+(Survey!E55-Survey!E54)^2)^0.5,(C34^2+(Survey!K$21-Survey!E54)^2)^0.5),IF(Survey!E55<Survey!K$21,(C34^2+(Survey!K$21-Survey!E55)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C54<Access!$C$28,'Calc.'!C34,0)","v":0},{"$f":"IF(Survey!$C54>=Access!$C$28,'Calc.'!C34,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C55-Survey!C56<0,1,-1)*(IF(ISNA(Survey!E56),0,IF(Survey!E55<Survey!K$21,IF(Survey!E56<Survey!K$21,((Survey!C56-Survey!C55)^2)^0.5,(((Survey!K$21-Survey!E55)*(Survey!C56-Survey!C55)/(Survey!E56-Survey!E55))^2)^0.5),IF(Survey!E56<Survey!K$21,(((Survey!K$21-Survey!E56)*(Survey!C56-Survey!C55)/(Survey!E55-Survey!E56))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E56),0,IF(Survey!E55<Survey!K$21,IF(Survey!E56<Survey!K$21,(Survey!K$21-(Survey!E55+Survey!E56)*0.5)*C35,(Survey!K$21-Survey!E55)*0.5*C35),IF(Survey!E56<Survey!K$21,(Survey!K$21-Survey!E56)*0.5*C35,0)))","v":0},{"$f":"IF(ISNA(Survey!E56),0,IF(Survey!E55<Survey!K$21,IF(Survey!E56<Survey!K$21,(C35^2+(Survey!E56-Survey!E55)^2)^0.5,(C35^2+(Survey!K$21-Survey!E55)^2)^0.5),IF(Survey!E56<Survey!K$21,(C35^2+(Survey!K$21-Survey!E56)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C55<Access!$C$28,'Calc.'!C35,0)","v":0},{"$f":"IF(Survey!$C55>=Access!$C$28,'Calc.'!C35,0)","v":0}]
[{"$f":"Survey!$K$21","v":0},{"$error":"#N/A"},{"$f":"IF(Survey!C56-Survey!C57<0,1,-1)*(IF(ISNA(Survey!E57),0,IF(Survey!E56<Survey!K$21,IF(Survey!E57<Survey!K$21,((Survey!C57-Survey!C56)^2)^0.5,(((Survey!K$21-Survey!E56)*(Survey!C57-Survey!C56)/(Survey!E57-Survey!E56))^2)^0.5),IF(Survey!E57<Survey!K$21,(((Survey!K$21-Survey!E57)*(Survey!C57-Survey!C56)/(Survey!E56-Survey!E57))^2)^0.5,0))))","v":0},{"$f":"IF(ISNA(Survey!E57),0,IF(Survey!E56<Survey!K$21,IF(Survey!E57<Survey!K$21,(Survey!K$21-(Survey!E56+Survey!E57)*0.5)*C36,(Survey!K$21-Survey!E56)*0.5*C36),IF(Survey!E57<Survey!K$21,(Survey!K$21-Survey!E57)*0.5*C36,0)))","v":0},{"$f":"IF(ISNA(Survey!E57),0,IF(Survey!E56<Survey!K$21,IF(Survey!E57<Survey!K$21,(C36^2+(Survey!E57-Survey!E56)^2)^0.5,(C36^2+(Survey!K$21-Survey!E56)^2)^0.5),IF(Survey!E57<Survey!K$21,(C36^2+(Survey!K$21-Survey!E57)^2)^0.5,0)))","v":0},{"$f":"IF(Survey!$C56<Access!$C$28,'Calc.'!C36,0)","v":0},{"$f":"IF(Survey!$C56>=Access!$C$28,'Calc.'!C36,0)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F3:F36)","v":0},{"$f":"SUM(G3:G36)","v":0}]

{"sheet":"Draw LG","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Draw MG","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Draw SB","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Draw AC","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}