{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["インバート部","矩形部","アーチ部","流量計算書"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":12,"comments":1,"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":"インバート部","index":0,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["アーチカルバートの流量計算"]
[null,"インバート部"]
[]
[]
[null,null,null,null,null,null,"水深が決まっている場合"]
[null,null,null,null,null,null,null,"条件"]
[null,null,null,null,null,null,null,"R",2]
[null,null,null,null,null,null,null,"水深",6.3E-2]
[]
[null,null,null,null,null,null,null,"R-水深",{"$f":"I7-I8","v":1.9370000000000001}]
[null,null,null,null,null,null,null,"水面幅","{R2-(R-水深)2}1/2×2＝"]
[null,null,null,null,null,null,null,{"$f":"\"=｛ \"&FIXED(I7,3)&\"^2 －（ \"&FIXED(I7,3)&\" － \"&FIXED(I8,3)&\" ）^2 ｝^0.5 × 2 ＝\"","v":"=｛ 2.000^2 －（ 2.000 － 0.063 ）^2 ｝^0.5 × 2 ＝"},null,null,null,null,{"$f":"(I7^2-I10^2)^0.5*2","v":0.99605421539191263},"m"]
[]
[null,null,null,null,null,null,null,"θ＝arccos｛（R-水深）／R ｝× 2 ＝"]
[null,null,null,null,null,null,null,{"$f":"\"= arccos｛（\"&FIXED(I7,3)&\"-\"&FIXED(I8,3)&\"）／ \"&FIXED(I7,3)&\" ｝× 2 ＝\"","v":"= arccos｛（2.000-0.063）／ 2.000 ｝× 2 ＝"},null,null,null,null,{"$f":"ACOS(I10/I7)*2","v":0.50332318344838178},"ラジアン"]
[]
[null,null,null,null,null,null,null,"潤辺長＝R×θ（ラジアン）"]
[null,null,null,null,null,null,null,{"$f":"\"＝ \"&FIXED(I7,3)&\" × \"&FIXED(M15,5)&\" ＝\"","v":"＝ 2.000 × 0.50332 ＝"},null,null,null,null,{"$f":"I7*M15","v":1.0066463668967636},"m"]
[]
[null,null,null,null,null,null,"水面幅が決まっている場合"]
[null,null,null,null,null,null,null,"条件"]
[null,null,null,null,null,null,null,"R",2]
[null,null,null,null,null,null,null,"水面幅",1]
[]
[null,null,null,null,null,null,null,"θ＝arcsin ｛（水面幅 ／ 2）／ R｝ ×2 "]
[null,null,null,null,null,null,null,{"$f":"\"= arcsin {（\"&FIXED(I23,3)&\" / 2 ) / \"&FIXED(I22,3)&\" ｝ × 2 ＝\"","v":"= arcsin {（1.000 / 2 ) / 2.000 ｝ × 2 ＝"},null,null,null,null,{"$f":"ASIN(I23/2/I22)*2","v":0.50536051028415729},"ラジアン"]
[]
[null,null,null,null,null,null,null,"潤辺長＝R×θ（ラジアン）"]
[null,null,null,null,null,null,null,{"$f":"\"＝ \"&FIXED(I22,3)&\" × \"&FIXED(M26,5)&\" ＝\"","v":"＝ 2.000 × 0.50536 ＝"},null,null,null,null,{"$f":"I22*M26","v":1.0107210205683146},"m"]
[]
[null,null,null,null,null,null,null,"水深＝R－R cos（θ／2）"]
[null,null,null,null,null,null,null,{"$f":"\"＝\"&FIXED(I22,3)&\" － \"&FIXED(I22,3)&\" × cos ( \"&FIXED(M26,5)&\"　／ 2　） ＝\"","v":"＝2.000 － 2.000 × cos ( 0.50536　／ 2　） ＝"},null,null,null,null,{"$f":"I22-I22*COS(M26/2)","v":6.3508326896291489E-2},"m"]
[]
[null,null,null,null,null,null,"通水断面積"]
[null,null,null,null,null,null,"＝","潤辺長 × R ／ 2 － 水面幅 ×（ R － 水深 ）／ 2"]
[null,null,null,null,null,null,{"$f":"\"=\"&FIXED(M29,3)&\" × \"&FIXED(I22,3)&\" ／ 2 － \"&FIXED(I23,3)&\" ×（\"&FIXED(I22,3)&\" － \"&FIXED(M32,3)&\"）／ 2 ＝\"","v":"=1.011 × 2.000 ／ 2 － 1.000 ×（2.000 － 0.064）／ 2 ＝"},null,null,null,null,null,{"$f":"M29*I22/2-I23*(I22-M32)/2","v":4.2475184016460332E-2},"m2"]

{"sheet":"矩形部","index":1,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["アーチカルバートの流量計算"]
[null,"矩形部"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"潤辺長",null,"（h－h1）×2"]
[null,null,"通水断面積",null,"（h－h1）×B"]

{"sheet":"アーチ部","index":2,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["アーチカルバートの流量計算"]
[null,"アーチ部"]
[null,null,null,null,null,null,"H",1,"m"]
[null,null,null,null,null,null,"B",1,"m"]
[null,null,null,null,null,null,"水深 h",0.9,"m"]
[]
[null,null,null,null,null,null,"満流の場合のアーチ部"]
[]
[null,null,null,null,null,null,null,"条件"]
[null,null,null,null,null,null,null,"R",0.5]
[]
[null,null,null,null,null,null,null,"潤辺長＝R×θ（ラジアン）"]
[null,null,null,null,null,null,null,{"$f":"\"＝ \"&FIXED(I10,3)&\" × π ＝\"","v":"＝ 0.500 × π ＝"},null,null,null,null,{"$f":"I10*PI()","v":1.5707963267948966},"m"]
[]
[null,null,null,null,null,null,null,"通水断面積＝R 2 × π ／ 2"]
[null,null,null,null,null,null,null,{"$f":"\"＝\"&FIXED(I10,3)&\"^2 × π ／ 2 ＝\"","v":"＝0.500^2 × π ／ 2 ＝"},null,null,null,null,{"$f":"I10^2*PI()/2","v":0.39269908169872414},"m2"]
[]
[null,null,null,null,null,null,"満流でない場合の控除"]
[]
[null,null,null,null,null,null,null,"空隙 δh","H - h =",{"$f":"H3-H5","v":9.9999999999999978E-2},"m"]
[]
[null,null,null,null,null,null,null,"R-δh=",{"$f":"I10-J20","v":0.4}]
[null,null,null,null,null,null,null,"水面幅","{R2-(R-δh)2}1/2×2＝"]
[null,null,null,null,null,null,null,{"$f":"\"=｛ \"&FIXED(I10,3)&\"^2 －（ \"&FIXED(I10,3)&\" － \"&FIXED(J20,3)&\" ）^2 ｝^0.5 × 2 ＝\"","v":"=｛ 0.500^2 －（ 0.500 － 0.100 ）^2 ｝^0.5 × 2 ＝"},null,null,null,null,{"$f":"(I10^2-I22^2)^0.5*2","v":0.59999999999999987},"m"]
[]
[null,null,null,null,null,null,null,"θ＝arccos｛（R-δh）／R ｝× 2 ＝"]
[null,null,null,null,null,null,null,{"$f":"\"= arccos｛（\"&FIXED(I10,3)&\"-\"&FIXED(J20,3)&\"）／ \"&FIXED(I10,3)&\" ｝× 2 ＝\"","v":"= arccos｛（0.500-0.100）／ 0.500 ｝× 2 ＝"},null,null,null,null,{"$f":"ACOS(I22/I10)*2","v":1.2870022175865685},"ラジアン"]
[]
[null,null,null,null,null,null,null,"控除潤辺長＝R×θ（ラジアン）"]
[null,null,null,null,null,null,null,{"$f":"\"＝ \"&FIXED(I10,3)&\" × \"&FIXED(M27,5)&\" ＝\"","v":"＝ 0.500 × 1.28700 ＝"},null,null,null,null,{"$f":"I10*M27","v":0.64350110879328426},"m"]
[]
[null,null,null,null,null,null,null,"控除通水断面積＝控除潤辺長 × R ／ 2 － 水面幅 ×（ R － δh ）／ 2"]
[null,null,null,null,null,null,null,{"$f":"\"=\"&FIXED(M30,3)&\" × \"&FIXED(I10,3)&\" ／ 2 － \"&FIXED(M24,3)&\" ×（\"&FIXED(I10,3)&\" － \"&FIXED(J20,3)&\"）／ 2 ＝\"","v":"=0.644 × 0.500 ／ 2 － 0.600 ×（0.500 － 0.100）／ 2 ＝"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M30*I10/2-M24*(I10-J20)/2","v":4.0875277198321083E-2},"m2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"水深に対するアーチ部の潤辺長＝満流の潤辺長-控除潤辺長＝\"&FIXED(M13,3)&\"－\"&FIXED(M30,3)&\"＝\"","v":"水深に対するアーチ部の潤辺長＝満流の潤辺長-控除潤辺長＝1.571－0.644＝"},{"$f":"M13-M30","v":0.9272952180016123},"m"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"水深に対するアーチ部の通水断面積＝満流の通水断面積-控除通水断面積＝\"&FIXED(M16,3)&\"－\"&FIXED(M34,3)&\"＝\"","v":"水深に対するアーチ部の通水断面積＝満流の通水断面積-控除通水断面積＝0.393－0.041＝"},{"$f":"M16-M34","v":0.35182380450040307},"m2"]

{"sheet":"流量計算書","index":3,"n_rows":107,"n_cols":12,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["アーチカルバートの流量計算書"]
[]
["　1.　流出量の計算（合理式）"]
[]
[null,"  流出量　Q ＝ 1／360 × Rt × Σ（ f × A ）"]
[null," Q ："," 流出量（m3/Sec）",null," f ："," 流出係数"]
[null," Rt："," 降雨強度",null," A ："," 流域面積 (ha)"]
[]
[null,"Rt=",120,"mm/hr"]
[]
[null,null,"番  号","Ａ","ｆ","Ａ×ｆ","摘　  要"]
[null,null,1,10,0.6,{"$f":"ROUND(D12*E12,3)","v":6}]
[null,null,2,null,null,{"$f":"ROUND(D13*E13,3)","v":0}]
[null,null,3,null,null,{"$f":"ROUND(D14*E14,3)","v":0}]
[null,null,"合　計",{"$f":"SUM(D12:D14)","v":10},null,{"$f":"SUM(F12:F14)","v":6}]
[]
[null,{"$f":"\"　Q ＝ 1/360 × Rt × Σ(A×f) ＝ 1 ／ 360 × \"&FIXED(降雨強度,0)&\" × \"&FIXED(ΣAf,3)","v":"　Q ＝ 1/360 × Rt × Σ(A×f) ＝ 1 ／ 360 × 120 × 6.000"}]
[null,null,null,null,null,null,"　　　＝",{"$f":"ROUND(1/360*降雨強度*ΣAf,3)","v":2},"m3／Sec"]
[]
[null,"設計流出量",null,"割増率",1.2]
[null,{"$f":"\"　Q1＝ Q × 割増率 ＝ \"&FIXED(流出量,3)&\" × \"&FIXED(割増率,1)","v":"　Q1＝ Q × 割増率 ＝ 2.000 × 1.2"},null,null,null,null,"＝",{"$f":"ROUND(流出量*割増率,3)","v":2.4},"m3／Sec"]
[]
["　2.　形状寸法"]
[null,null,null,null,null,null,null,null,null,null,null,"データー入力セルです"]
[null,null,null,null,null,null,"躯体幅 B ：",2.5,"m"]
[null,null,null,null,null,null,"躯体高 H ：",2.5,"m",null,null,"下の実流量水深計算ボタンをクリックすると水深は自動で入ります。入力することもできます。"]
[null,null,null,null,null,null,"インバート R1 ：",5,"m"]
[null,null,null,null,null,null,"アーチ R2=B/2 ：",{"$f":"H25/2","v":1.25},"m"]
[]
[null,null,null,null,null,null,"水深 h ＝",0.50900000000000001,"m",null,null,"水深を㎜単位で設定するためQ1＝Q2とならないことがあります。"]
[null,null,null,null,null,null,"勾配 I ＝",3.0000000000000001E-3,null,null,null,"この場合Q1＜Q2となるように㎜単位で調整しています。"]
[null,null,null,null,null,null,"粗度係数 n =",1.2999999999999999E-2,null,null,null,"満流でもQ1＜Q2とならない場合は「断面不足」と表示されます。"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"躯体幅B=\"&FIXED(H25,3)&\" m\"","v":"躯体幅B=2.500 m"}]
[null,"h1＝R1－R1 cos（θ1／2）",null,null,null,null,null,null,null,null,{"$f":"\"躯体高H=\"&FIXED(H26,3)&\" m\"","v":"躯体高H=2.500 m"}]
[null,"θ＝arcsin ｛（B ／ 2）／ R1｝ ×2 ＝",null,null,null,null,null,{"$f":"ASIN(H25/2/H27)*2","v":0.50536051028415729},"rad",null,{"$f":"\"=\"&FIXED(H27,3)&\" m\"","v":"=5.000 m"}]
[null,{"$f":"\"h1＝\"&FIXED(H27,3)&\" － \"&FIXED(H27,3)&\" × cos ( \"&FIXED(H36,5)&\"　／ 2　） ＝\"","v":"h1＝5.000 － 5.000 × cos ( 0.50536　／ 2　） ＝"},null,null,null,null,null,{"$f":"ROUND(H27-H27*COS(H36/2),3)","v":0.159},"m",null,{"$f":"\"=\"&FIXED(H28,3)&\" m\"","v":"=1.250 m"}]
[null,{"$f":"\"h2 = H - h1 - h3 = \"&FIXED(H26,3)&\" － \"&FIXED(H37,3)&\" － \"&FIXED(H39,3)&\" ＝\"","v":"h2 = H - h1 - h3 = 2.500 － 0.159 － 1.250 ＝"},null,null,null,null,null,{"$f":"H26-H37-H39","v":1.0910000000000002},"m",null,{"$f":"\"水深h=\"&FIXED(H30,3)&\" m\"","v":"水深h=0.509 m"}]
[null,"h3 = R2 =",null,null,null,null,null,{"$f":"H28","v":1.25},"m"]
[]
["　3.　インバート部の潤辺長および通水断面積"]
[]
[null,"水面幅b ＝ {R1 2-(R1-水深h) 2} 1/2 × 2　ただし　b≦B"]
[null,{"$f":"\"b' =｛ \"&FIXED(H27,3)&\"^2 －（ \"&FIXED(H27,3)&\" － \"&FIXED(H30,3)&\" ）^2 ｝^0.5 × 2 ＝\"","v":"b' =｛ 5.000^2 －（ 5.000 － 0.509 ）^2 ｝^0.5 × 2 ＝"},null,null,null,null,null,{"$f":"(H27^2-(H27-H30)^2)^0.5*2","v":4.3958703347573849},"m"]
[null,null,null,null,null,null,{"$f":"IF(H44<=H25,\"b'≦ B　　b=\",\"b'＞B　　b=\")","v":"b'＞B　　b="},{"$f":"IF(H44<=H25,H44,H25)","v":2.5},"m"]
[null,"θ1＝arcsin ｛（水面幅b ／ 2）／ R1 ｝ ×2 "]
[null,{"$f":"\"= arcsin {（\"&FIXED(H45,3)&\" / 2 ) / \"&FIXED(H27,3)&\" ｝ × 2 ＝\"","v":"= arcsin {（2.500 / 2 ) / 5.000 ｝ × 2 ＝"},null,null,null,null,null,{"$f":"ASIN(H45/2/H27)*2","v":0.50536051028415729},"rad"]
[null,{"$f":"\"潤辺長 s1 ＝ R1 × θ1（rad）＝\"&FIXED(H27,3)&\" × \"&FIXED(H47,5)&\" ＝\"","v":"潤辺長 s1 ＝ R1 × θ1（rad）＝5.000 × 0.50536 ＝"},null,null,null,null,null,{"$f":"ROUND(H27*H47,3)","v":2.5270000000000001},"m"]
[null,"通水断面積a1=潤辺長s1 × R1 ／ 2 － 水面幅b ×（ R1 － 水深h0 ）／ 2"]
[null,"ただしインバート部の計算最大水深はh1",null,null,null,null,{"$f":"IF(H30>=H37,\"h≧h1 h0=h1=\",\"h<h1 h0=h=\")","v":"h≧h1 h0=h1="},{"$f":"IF(H30>=H37,H37,H30)","v":0.159},"m"]
[null,{"$f":"\"a1 =　\"&FIXED(H48,3)&\" × \"&FIXED(H27,3)&\" ／ 2 － \"&FIXED(H45,3)&\" ×（\"&FIXED(H27,3)&\" － \"&FIXED(H50,3)&\"）／ 2\"","v":"a1 =　2.527 × 5.000 ／ 2 － 2.500 ×（5.000 － 0.159）／ 2"}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND(H48*H27/2-H45*(H27-H50)/2,3)","v":0.26600000000000001},"m2"]
[]
["　4.　矩形部の潤辺長および通水断面積"]
[]
[null,"矩形部の水深 h0_2 "]
[null,null,"h1≧h の場合 h0_2=0"]
[null,null,"h1<h≦h1+h2 の場合 h0_2=h-h1"]
[null,null,"h1+h2<h の場合 h0_2=h2"]
[null,null,{"$f":"\"h - h1 = \"&FIXED(H30,3)&\" - \"&FIXED(H37,3)&\" ＝\"","v":"h - h1 = 0.509 - 0.159 ＝"},null,null,{"$f":"H30-H37","v":0.35}]
[null,null,null,null,{"$f":"IF(H37>=H30,\"h1≧h ∴ h0_2＝\",IF(F60>H38,\"h1+h2<h ∴ h0_2=\",\"h1<h≦h1+h2 ∴ h0_2=\"))","v":"h1<h≦h1+h2 ∴ h0_2="},{"$f":"IF(H37>=H30,0,IF(F60>H38,H38,H30-H37))","v":0.35}]
[null,{"$f":"\"潤辺長s2＝h0_2 × 2 ＝ \"&FIXED(F61,3)&\" × 2 ＝\"","v":"潤辺長s2＝h0_2 × 2 ＝ 0.350 × 2 ＝"},null,null,null,null,null,{"$f":"ROUND(F61*2,3)","v":0.7},"m"]
[null,{"$f":"\"通水断面積a2＝h0_2 × B ＝ \"&FIXED(F61,3)&\" × \"&FIXED(H25,3)&\" ＝\"","v":"通水断面積a2＝h0_2 × B ＝ 0.350 × 2.500 ＝"},null,null,null,null,null,{"$f":"ROUND(F61*H25,3)","v":0.875},"m2"]
[]
["　5.　アーチ部の潤辺長および通水断面積"]
[]
[null,"満流の場合のアーチ部潤辺長および通水断面積"]
[null,{"$f":"\"　　潤辺長s3_1＝R2×θ（rad）＝ \"&FIXED(H28,3)&\" × π ＝\"","v":"　　潤辺長s3_1＝R2×θ（rad）＝ 1.250 × π ＝"},null,null,null,null,null,{"$f":"ROUND(H28*PI(),3)","v":3.927},"m"]
[null,{"$f":"\"　　通水断面積a3_1＝R2^2 × π ／ 2＝\"&FIXED(H28,3)&\"^2 × π ／ 2 ＝\"","v":"　　通水断面積a3_1＝R2^2 × π ／ 2＝1.250^2 × π ／ 2 ＝"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(H28^2*PI()/2,3)","v":2.4540000000000002},"m2"]
[]
[null,"満流でない場合の控除値"]
[null,null,"空隙高 δh =","H - h =",{"$f":"IF(H26-H30<=H39,H26-H30,H39)","v":1.25},"m","δh≦h3"]
[null,null,null,"R2-δh=",{"$f":"H28-E73","v":0},"m"]
[null,null,"水面幅 b3=","{R22-(R2-δh)2}1/2×2"]
[null,null,null,null,null,null,{"$f":"\"=｛ \"&FIXED(H28,3)&\"^2 －（ \"&FIXED(H28,3)&\" － \"&FIXED(E73,3)&\" ）^2 ｝^0.5 × 2 ＝\"","v":"=｛ 1.250^2 －（ 1.250 － 1.250 ）^2 ｝^0.5 × 2 ＝"},{"$f":"ROUND((H28^2-E74^2)^0.5*2,3)","v":2.5},"m"]
[null,null,"θ3＝arccos｛（R2-δh）／R2 ｝× 2"]
[null,null,null,null,null,null,{"$f":"\"= arccos｛（\"&FIXED(H28,3)&\"-\"&FIXED(E73,3)&\"）／ \"&FIXED(H28,3)&\" ｝× 2 ＝\"","v":"= arccos｛（1.250-1.250）／ 1.250 ｝× 2 ＝"},{"$f":"ACOS(E74/H28)*2","v":3.1415926535897931},"rad"]
[null,null,"控除潤辺長s3_2＝R2×θ3（rad）"]
[null,null,null,null,null,null,{"$f":"\"＝ \"&FIXED(H28,3)&\" × \"&FIXED(H78,5)&\" ＝\"","v":"＝ 1.250 × 3.14159 ＝"},{"$f":"ROUND(H28*H78,3)","v":3.927},"m"]
[null,null,"控除通水断面積a3_2"]
[null,null," = 控除潤辺長s3_2 × R2 / 2 - 水面幅b3 ×( R2 - δh )/ 2"]
[null,null,{"$f":"\"=\"&FIXED(H80,3)&\" × \"&FIXED(H28,3)&\" ／ 2 － \"&FIXED(H76,3)&\" ×（\"&FIXED(H28,3)&\" － \"&FIXED(E73,3)&\"）／ 2 ＝\"","v":"=3.927 × 1.250 ／ 2 － 2.500 ×（1.250 － 1.250）／ 2 ＝"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(H80*H28/2-H76*(H28-E73)/2,3)","v":2.4540000000000002},"m2"]
[null,"水深に対するアーチ部の潤辺長s3"]
[null,null,null,null," = 満流の潤辺長s3_1 － 控除潤辺長s3_2",null,{"$f":"\"＝\"&FIXED(H68,3)&\"－\"&FIXED(H80,3)&\"＝\"","v":"＝3.927－3.927＝"},{"$f":"ROUND(H68-H80,3)","v":0},"m"]
[]
[null,"水深に対するアーチ部の通水断面積a3"]
[null,null," ＝ 満流の通水断面積a3_1 － 控除通水断面積a3_2"]
[null,null,null,null,null,null,{"$f":"\"＝ \"&FIXED(H70,3)&\"－\"&FIXED(H84,3)&\"＝\"","v":"＝ 2.454－2.454＝"},{"$f":"ROUND(H70-H84,3)","v":0},"m2"]
[]
["　6.　アーチカルバートの流量計算（マニング式による）"]
[]
[null,"通水断面",{"$f":"\"　a ＝ a1 ＋ a2 ＋ a3 ＝ \"&FIXED(H52,3)&\" ＋ \"&FIXED(H63,3)&\" ＋ \"&FIXED(H90,3)&\" ＝\"","v":"　a ＝ a1 ＋ a2 ＋ a3 ＝ 0.266 ＋ 0.875 ＋ 0.000 ＝"}]
[null,null,null,null,null,null,null,{"$f":"H52+H63+H90","v":1.141},"m2"]
[]
[null,"潤辺",{"$f":"\"　s ＝ s1 ＋ s2 ＋ s3 ＝ \"&FIXED(H48,3)&\" ＋ \"&FIXED(H62,3)&\" ＋ \"&FIXED(H86,3)&\" ＝\"","v":"　s ＝ s1 ＋ s2 ＋ s3 ＝ 2.527 ＋ 0.700 ＋ 0.000 ＝"}]
[null,null,null,null,null,null,null,{"$f":"H48+H62+H86","v":3.2270000000000003},"m2"]
[]
[null,"径深",{"$f":"\"　R ＝ a ／ s ＝ \"&FIXED(H95,3)&\" ／ \"&FIXED(H98,3)&\" ＝\"","v":"　R ＝ a ／ s ＝ 1.141 ／ 3.227 ＝"},null,null,null,null,{"$f":"ROUND(H95/H98,3)","v":0.35399999999999998},"m2"]
[]
[null,"流速","　V ＝ 1 ／ n × R2/3 × I1/2"]
[null,null,{"$f":"\"＝ 1／\"&FIXED(粗度係数,3)&\" × \"&FIXED(径深,3)&\"(^2/3) × \"&FIXED(勾配,3)&\"^(1/2) ＝\"","v":"＝ 1／0.013 × 0.354(^2/3) × 0.003^(1/2) ＝"},null,null,null,null,{"$f":"ROUND(1/粗度係数*径深^(2/3)*勾配^(1/2),3)","v":2.1080000000000001},"m／sec"]
[]
[null,"流量",{"$f":"\"　Q2 ＝ a × V ＝ \"&FIXED(通水断面,3)&\" × \"&FIXED(流速,3)&\" ＝\"","v":"　Q2 ＝ a × V ＝ 1.141 × 2.108 ＝"},null,null,null,null,{"$f":"ROUND(通水断面*流速,3)","v":2.4049999999999998},"m3／sec"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H105>=設計流出量,\"Q2 ≧ Q1 ∴　OK\",\"Q2 ＜ Q1 ＮＯ \")","v":"Q2 ≧ Q1 ∴　OK"}]