{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["NE（入力値と結果のみ）","NE（計算値や早見表）","計算による従来の一体化長さ","計算による従来の一体化長さ手順","菅外径と管厚と継手の限界曲げモーメント","曲管の早見表（JDPA T57 P20）","T字管の早見表（JDPA T57 P20） ","管端部および仕切弁部の早見表（JDPA T57 P49）","片落管部の早見表（JDPA T57 P48）"],"not_rendered":{"charts":0,"images":22,"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":"NE（入力値と結果のみ）","index":0,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,1,4,4],[16,0,17,26],[2,1,3,9],[0,0,1,26],[6,6,8,7],[5,1,6,3]]}
["各種パターンによる一体化長さの考え方【NS形E種管】 ：呼び径φ75～150 　Ver 1.0"]
[]
[null,"検討条件"]
[]
[null,"検討したいパターン",null,null,null,"③","曲管の一体化長さ仮定値　[m] ",null,null,null,7,{"$f":"IF(AND(2.5<='NE（計算値や早見表）'!T44,'NE（計算値や早見表）'!T45<=0.01),\"\",\"一体化長さ仮定値を見直してください\")","v":""}]
[null,"呼び径",null,null,"本管側",75,"曲管Aより既設管までの延長 [m] ",null,null,null,7,{"$f":"IF(F5=\"⑤\",\"⇒ \"&K6&\"m\",\"\")","v":""}]
[null,null,null,null,"支管側",75,"複合曲管部の合成角度 [°]",null,"曲管の角度 [°] ",null,5.625]
[null,"設計水圧　[MPa]",null,null,null,0.75,null,null,"両受曲管の角度 [°]",null,22.5]
[null,"土被り　[m]",null,null,null,0.6,null,null,"合成角度 [°]",null,28.125]
[null,"管種",null,null,null,"E種","曲管Aの角度 [°]",null,null,null,5.625]
[null,"ポリエチレンスリーブの被覆",null,null,null,"あり","曲管Bの角度 [°]",null,null,null,5.625]
[null,"管と土の摩擦係数",null,null,null,{"$f":"IF(F11=\"あり\",0.3,0.4)","v":0.3},"曲管Cの角度 [°]",null,null,null,5.625]
[null,"土の単位体積重量　[kN/m3]",null,null,null,16,"曲管Dの角度 [°]",null,null,null,5.625]
[null,"既設管の接合形式",null,null,null,"一般継手","曲管Eの角度 [°]",null,null,null,5.625]
[]
[]
["各種パターンによる一体化長さの考え方【NS形E種管】 ：呼び径φ75～150 　Ver 1.0"]
[]
[]
[null,null,"※曲管の角度を変更しても管割図は変更されませんのでご注意下さい。"]
[null,null,"※複合曲管部の合成角度は、曲管を2個使用した場合の合成角度になりますが、3個以上使用する場合は、合成角度を直接入力して下さい。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"曲管Aより既設"]
[null,null,null,null,null,"菅までの距離"]

{"sheet":"NE（計算値や早見表）","index":1,"n_rows":65,"n_cols":36,"rows_kept":65,"cut":false,"hidden":true,"merged":[[24,22,24,23],[24,16,24,17],[24,18,24,19],[24,20,24,21],[23,25,25,25],[25,16,25,17],[25,20,25,21],[25,22,25,23],[25,18,25,19],[23,26,23,27],[23,28,23,29],[23,30,23,31],[23,32,23,33],[23,34,23,35],[24,26,24,27],[24,28,24,29],[24,30,24,31],[24,32,24,33],[24,34,24,35],[48,16,49,18],[1,12,2,13],[24,12,25,13],[24,14,24,15],[1,0,4,0],[2,14,2,15],[25,14,25,15],[2,16,2,17],[1,25,3,25],[2,34,2,35],[1,34,1,35],[1,32,1,33],[1,30,1,31],[1,28,1,29],[2,26,2,27],[2,28,2,29],[2,30,2,31],[2,32,2,33],[1,26,1,27],[2,20,2,21],[2,22,2,23],[1,14,1,15],[1,16,1,17],[1,18,1,19],[1,20,1,21],[1,22,1,23]]}
["曲管およびT字管部の早見表",null,null,null,null,null,null,null,null,null,null,null,"片落管部の早見表（計算値）",null,null,null,null,null,null,null,null,null,null,null,null,"管端部および仕切弁部の早見表（計算値）"]
["呼び径","曲管部",null,null,null,null,null,"T字管",null,null,null,null,"呼び径",null,"土被りh=0.6m",null,"土被りh=0.8m",null,"土被りh=1.0m",null,"土被りh=1.2m",null,"土被りh=1.4m",null,null,"呼び径","土被りh=0.6m",null,"土被りh=0.8m",null,"土被りh=1.0m",null,"土被りh=1.2m",null,"土被りh=1.4m"]
[null,"22.5°以下",null,"22.5°を越え45°以下",null,"45°を越え90°以下",null,null,null,null,null,null,null,null,"水圧（MPa）",null,"水圧（MPa）",null,"水圧（MPa）",null,"水圧（MPa）",null,"水圧（MPa）",null,null,null,"水圧（MPa）",null,"水圧（MPa）",null,"水圧（MPa）",null,"水圧（MPa）",null,"水圧（MPa）"]
[null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,null,null,null,"大菅","小管",0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,null,null,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3]
[null,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,null,null,null,100,75,3.5,6,3,4.5,2.5,4,2,3.5,1.5,3,null,75,7.5,12.5,5.5,9.5,4.5,8,4,6.5,3.5,5.5]
[75,1,1,1,1,1,4,1,1,null,null,null,150,100,6.5,11,5,8.5,4,7,3.5,6,3,5,null,100,9,15.5,7,12,5.5,9.5,5,8,4,7]
[100,1,1,1,1,1,5,1,1,null,null,null,200,150,6.5,11,5,8.5,4,7,3.5,6,3,5.5,null,150,12.5,21,9.5,16.5,8,13.5,6.5,11.5,6,10]
[150,1,1,1,1,4,6,1,6,null,null,null,250,200,6.5,11,5,8.5,4.5,7,3.5,6,3,5.5,null,200,15.5,26.5,12,20.5,10,17,8.5,14.5,7,12]
[200,1,1,1,1,4,8,1,6,null,null,null,300,100,18,31.5,14.5,25,12,20.5,10.5,17.5,9,15.5,null,250,18.5,31.5,14.5,25,12,20.5,10,17.5,9,15]
[250,1,1,1,2,6,11,2,7,null,null,null,300,150,15.5,26.5,12,21,10,17.5,8.5,15,7.5,13,null,300,21,36,16.5,28.5,14,24,12,20.5,10.5,17.5]
[300,1,2,1,7,7,16,7,13,null,null,null,300,200,11.5,19.5,9,15.5,7.5,13,6.5,11,5.5,9.5]
[null,null,null,null,null,null,null,null,null,null,null,null,300,250,6.5,10.5,5,8.5,4,7,3.5,6,3,5.5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"備考）1．計算条件は以下の通りである。"]
["注）1．単独曲管部では曲管の両側に一体化長さを確保する。",null,null,null,null,null,null,null,null,null,null,null,"備考）1．土被りは大管側の土被りとした。",null,null,null,null,null,null,null,null,null,null,null,null,"①土の単位体積重量：16kNm"]
["　　2．枝管の呼び径で判断し、枝管側に表中の一体化長さを確保する。なお、本管側の一体化長さは呼び径によらず両側とも１ｍとする。",null,null,null,null,null,null,null,null,null,null,null,"2．一体化長さは大菅側のみ確保する長さである。",null,null,null,null,null,null,null,null,null,null,null,null,"②管と土の摩擦係数：0.3"]
["備考）1．適用条件は以下の通りである。",null,null,null,null,null,null,null,null,null,null,null,"3．計算条件は以下の通りである。",null,null,null,null,null,null,null,null,null,null,null,null,"2．計算結果は0.5m単位で切り上げた。"]
["①設計水圧：1.3MPa",null,null,null,null,null,null,null,null,null,null,null,"①土の単位体積重量：16kNm"]
["②土被り：0.6m以上",null,null,null,null,null,null,null,null,null,null,null,"②管と土の摩擦係数：0.3"]
["③埋戻し条件：一般的な埋め戻しでN値5以上の締固め。",null,null,null,null,null,null,null,null,null,null,null,"4．計算結果は0.5m単位で切り上げた。"]
["2．計算結果は0.5m単位で切り上げた。"]
["3．表中の設計水圧は、0.75MPaは0.75MPa以下の場合、1.3MPa以下の場合、1.3MPaは0.75MPaを越え、"]
["1.3MPa以下の場に適用する。なお、設計水圧は、静水圧と水撃圧を加えたものとする。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"管端部および仕切弁部の早見表（計算値）"]
["4．曲管が2個以上の曲管部で90°を越え、112.5°以下の角度であれば、表の45°を越え、90°以下の曲管部の一体化長さをそのまま適用できる。",null,null,null,null,null,null,null,null,null,null,null,"片落管部の早見表（厳密な計算値）",null,null,null,null,null,null,null,null,null,null,null,null,"呼び径","土被りh=0.6m",null,"土被りh=0.8m",null,"土被りh=1.0m",null,"土被りh=1.2m",null,"土被りh=1.4m"]
["但し、112.5°を越える角度については管端部の一体化長さを適用する。",null,null,null,null,null,null,null,null,null,null,null,"呼び径",null,"土被りh=0.6m",null,"土被りh=0.8m",null,"土被りh=1.0m",null,"土被りh=1.2m",null,"土被りh=1.4m",null,null,null,"水圧（MPa）",null,"水圧（MPa）",null,"水圧（MPa）",null,"水圧（MPa）",null,"水圧（MPa）"]
["5．管には必ずポリエチレンスリーブを施工する。",null,null,null,null,null,null,null,null,null,null,null,null,null,"水圧（MPa）",null,"水圧（MPa）",null,"水圧（MPa）",null,"水圧（MPa）",null,"水圧（MPa）",null,null,null,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3]
[null,null,null,null,null,null,null,null,null,null,null,null,"大菅","小管",0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,null,75,7.0239994199535989,12.174932327919572,5.3644602776137029,9.2983978145304196,4.3392409221213581,7.5213509316770208,3.643012936221421,6.3145557561171302,3.1393125648116151,5.4414751123401333]
[null,null,null,null,null,null,null,null,null,null,null,null,100,75,3.3122651086006005,5.7412595215743742,2.5410741636412064,4.404528550311424,2.0611734717354073,3.5727006843413727,1.7337432141126261,3.0051549044618855,1.496081361595474,2.5932076934321548,null,100,8.7431240515933215,15.154748356095091,6.707472351571595,11.626285409390764,5.4407164778092545,9.4305752282027075,4.5764247418586184,7.932469552554938,3.9490875599725848,6.8450851039524805]
[null,null,null,null,null,null,null,null,null,null,null,null,150,100,6.1782000045383638,10.708880007866496,4.7812073522967884,8.2874260773144321,3.8994724786597605,6.7590856296769175,3.2923144438353531,5.706678369314611,2.8487557447669323,4.9378432909293482,null,150,12.05544649379109,20.89610725590455,9.3295117297908412,16.171153664970788,7.6089931996311675,13.188921546027355,6.4242531140521626,11.13537206435708,5.5587424216908063,9.6351535309307277]
[]
[]
["①",null,null,null,"②",null,null,null,"③",null,null,null,"④",null,null,null,"⑤",null,null,null,"⑥",null,null,null,"⑦"]
[]
[null,null,null,"VLOOK用",null,null,null,"VLOOK用",null,null,null,"VLOOK用",null,null,null,"VLOOK用",null,null,null,"VLOOK用",null,null,null,"VLOOK用",null,null,null,"VLOOK用"]
["呼び径",{"$f":"'NE（入力値と結果のみ）'!F6","v":75},null,null,"呼び径",{"$f":"'NE（入力値と結果のみ）'!F6","v":75},null,null,"呼び径",{"$f":"'NE（入力値と結果のみ）'!F6","v":75},null,null,"呼び径",{"$f":"'NE（入力値と結果のみ）'!F7","v":75},null,null,"呼び径",{"$f":"'NE（入力値と結果のみ）'!F6","v":75},null,null,"呼び径",{"$f":"'NE（入力値と結果のみ）'!F7","v":75},null,null,"呼び径",{"$f":"'NE（入力値と結果のみ）'!F7","v":75}]
["土被り",{"$f":"ROUNDDOWN('NE（入力値と結果のみ）'!$F$9,1)","v":0.6},"→",{"$f":"IF(AND(0.6<=B36,B36<0.8),0,IF(AND(0.8<=B36,B36<1),2,IF(AND(1<=B36,B36<1.2),4,IF(AND(1.2<=B36,B36<1.4),6,IF(AND(B36=1.4),8)))))","v":0},"合成角度",{"$f":"'NE（入力値と結果のみ）'!K9","v":28.125},"→",{"$f":"IF(AND(F36<=22.5),3,IF(AND(22.5<F36,F36<=45),5,IF(AND(45<F36,F36<112.5),7,)))","v":5},"土被り",{"$f":"ROUNDDOWN('NE（入力値と結果のみ）'!$F$9,1)","v":0.6},"→",{"$f":"IF(AND(0.6<=J36,J36<0.8),0,IF(AND(0.8<=J36,J36<1),2,IF(AND(1<=J36,J36<1.2),4,IF(AND(1.2<=J36,J36<1.4),6,IF(AND(J36=1.4),8)))))","v":0},"設計水圧",{"$f":"'NE（入力値と結果のみ）'!F8","v":0.75},"→",{"$f":"IF(AND(N36<=0.75),3,4)","v":3},"曲管Aの角度",{"$f":"'NE（入力値と結果のみ）'!K10","v":5.625},"→",{"$f":"IF(AND(R36<=22.5),3,IF(AND(22.5<R36,R36<=45),5,IF(AND(45<R36,R36<112.5),7,)))","v":3},"曲管Bの角度",{"$f":"'NE（入力値と結果のみ）'!K11","v":5.625},"→",{"$f":"IF(AND(V36<=22.5),3,IF(AND(22.5<V36,V36<=45),5,IF(AND(45<V36,V36<112.5),7,)))","v":3},"曲管Dの角度",{"$f":"'NE（入力値と結果のみ）'!K13","v":5.625},"→",{"$f":"IF(AND(Z36<=22.5),3,IF(AND(22.5<Z36,Z36<=45),5,IF(AND(45<Z36,Z36<112.5),7,)))","v":3}]
["摩擦係数",{"$f":"'NE（入力値と結果のみ）'!$F$12","v":0.3},"→",{"$f":"IF(AND(B37=0.3),3,13)","v":3},"設計水圧",{"$f":"'NE（入力値と結果のみ）'!F8","v":0.75},"→",{"$f":"IF(AND(F37<=0.75),0,1)","v":0},"摩擦係数",{"$f":"'NE（入力値と結果のみ）'!$F$12","v":0.3},"→",{"$f":"IF(AND(J37=0.3),3,13)","v":3},null,null,null,null,"設計水圧",{"$f":"'NE（入力値と結果のみ）'!F8","v":0.75},"→",{"$f":"IF(AND(R37<=0.75),0,1)","v":0},"設計水圧",{"$f":"'NE（入力値と結果のみ）'!F8","v":0.75},"→",{"$f":"IF(AND(V37<=0.75),0,1)","v":0},"設計水圧",{"$f":"'NE（入力値と結果のみ）'!F8","v":0.75},"→",{"$f":"IF(AND(Z37<=0.75),0,1)","v":0}]
["設計水圧",{"$f":"'NE（入力値と結果のみ）'!F8","v":0.75},"→",{"$f":"IF(AND(B38<=0.75),0,1)","v":0},null,null,null,"↓","設計水圧",{"$f":"'NE（入力値と結果のみ）'!F8","v":0.75},"→",{"$f":"IF(AND(J38<=0.75),0,1)","v":0},"一体化長さ",null,null,{"$f":"VLOOKUP(N35,'T字管の早見表（JDPA T57 P20） '!4:9,P36,FALSE)","v":1},null,null,null,"↓",null,null,null,"↓",null,null,null,"↓"]
[null,null,null,"↓",null,null,null,{"$f":"H35+H36+H37","v":5},null,null,null,"↓",null,null,"表示用",{"$f":"IF('NE（入力値と結果のみ）'!F5=\"④\",\"Lp = \"&P38&\"m\",\"\")","v":""},null,null,null,{"$f":"T35+T36+T37","v":3},null,null,null,{"$f":"X35+X36+X37","v":3},null,null,null,{"$f":"AB35+AB36+AB37","v":3}]
[null,null,null,{"$f":"D36+D37+D38","v":3},null,null,null,null,null,null,null,{"$f":"L36+L37+L38","v":3}]
[null,null,null,"元のD42=VLOOKUP(B35,'管端部および仕切弁部の早見表（JDPA T57 P49）'!6:11,D40,FALSE)","一体化長さ（合成角度112.5度以下）",null,null,{"$f":"VLOOKUP(F35,'曲管の早見表（JDPA T57 P20）'!5:10,H39,FALSE)","v":1},null,null,null,"元のL42＝VLOOKUP(J35,'管端部および仕切弁部の早見表（JDPA T57 P49）'!6:11,L40,FALSE)",null,null,"表示用",{"$f":"IF('NE（入力値と結果のみ）'!F5=\"④\",\"Lp =1m\",\"\")","v":""},"一体化長さ",null,null,{"$f":"VLOOKUP(R35,'曲管の早見表（JDPA T57 P20）'!5:10,T39,FALSE)","v":1},"一体化長さ",null,null,{"$f":"VLOOKUP(V35,'曲管の早見表（JDPA T57 P20）'!5:10,X39,FALSE)","v":1},"一体化長さ",null,null,{"$f":"VLOOKUP(Z35,'曲管の早見表（JDPA T57 P20）'!5:10,AB39,FALSE)","v":1}]
["一体化長さ",null,null,{"$f":"CEILING(B65,0.5)","v":7.5},"一体化長さ（合成角度112.5度超える）",null,null,{"$f":"D42","v":7.5},"一体化長さ",null,null,{"$f":"CEILING(J65,0.5)","v":7.5},null,null,null,null,null,null,"表示用",{"$f":"IF('NE（入力値と結果のみ）'!F5=\"⑤\",\"Lp = \"&T41&\"m\",\"\")","v":""},null,null,"表示用",{"$f":"IF('NE（入力値と結果のみ）'!F5=\"⑥\",\"Lp = \"&X41&\"m\",\"\")","v":""},null,null,"表示用",{"$f":"IF('NE（入力値と結果のみ）'!F5=\"⑦\",\"Lp = \"&AB41&\"m\",\"\")","v":""}]
[null,null,"表示用",{"$f":"IF('NE（入力値と結果のみ）'!F5=\"①\",\"Lp = \"&D42&\"m\",\"\")","v":""},null,null,null,null,null,null,"表示用",{"$f":"IF('NE（入力値と結果のみ）'!F5=\"③\",\"Lp = \"&L42&\"m\",\"\")","v":"Lp = 7.5m"},null,null,null,null,null,null,"表示用（管端側、耐震継手の場合）",{"$f":"IF(AND('NE（入力値と結果のみ）'!F5=\"⑤\",'NE（入力値と結果のみ）'!F14=\"耐震継手\"),\"Lp = \"&T41&\"m\",\"\")","v":""}]
[null,null,null,null,"一体化長さ",null,null,{"$f":"IF(AND(F36<=112.5),H41,H42)","v":1},null,null,null,null,null,null,null,null,"継手の安全性",null,null,{"$f":"計算による従来の一体化長さ!E65","v":53.237462511576368},"呼び径",{"$f":"'NE（入力値と結果のみ）'!F7","v":75},null,null,"呼び径",{"$f":"'NE（入力値と結果のみ）'!F7","v":75}]
[null,null,null,null,null,null,"表示用",{"$f":"IF('NE（入力値と結果のみ）'!F5=\"②\",\"Lp = \"&H44&\"m\",\"\")","v":""},"呼び径",{"$f":"'NE（入力値と結果のみ）'!F7","v":75},null,null,null,null,null,null,"曲管部の移動量",null,null,{"$f":"計算による従来の一体化長さ!E71","v":3.8024407476378822E-4},"曲管Cの角度",{"$f":"'NE（入力値と結果のみ）'!K12","v":5.625},"→",{"$f":"IF(AND(V45<=22.5),3,IF(AND(22.5<V45,V45<=45),5,IF(AND(45<V45,V45<112.5),7,)))","v":3},"曲管Eの角度",{"$f":"'NE（入力値と結果のみ）'!K14","v":5.625},"→",{"$f":"IF(AND(Z45<=22.5),3,IF(AND(22.5<Z45,Z45<=45),5,IF(AND(45<Z45,Z45<112.5),7,)))","v":3}]
[null,null,null,null,null,null,null,null,"設計水圧",{"$f":"'NE（入力値と結果のみ）'!F8","v":0.75},"→",{"$f":"IF(AND(J46<=0.75),3,4)","v":3},null,null,null,null,null,null,null,null,"設計水圧",{"$f":"'NE（入力値と結果のみ）'!F8","v":0.75},"→",{"$f":"IF(AND(V46<=0.75),0,1)","v":0},"設計水圧",{"$f":"'NE（入力値と結果のみ）'!F8","v":0.75},"→",{"$f":"IF(AND(Z46<=0.75),0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"計算による一体化長さ",null,null,{"$f":"IF(AND(2.5<=T44,T45<0.01),計算による従来の一体化長さ!E41,\"NG\")","v":7},null,null,null,"↓",null,null,null,"↓"]
[null,null,null,null,null,null,null,null,"一体化長さ",null,null,{"$f":"VLOOKUP(J45,'T字管の早見表（JDPA T57 P20） '!4:9,L46,FALSE)","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"X44+X45+X46","v":3},null,null,null,{"$f":"AB44+AB45+AB46","v":3}]
[null,null,null,null,null,null,null,null,null,null,"表示用",{"$f":"IF('NE（入力値と結果のみ）'!F5=\"③\",\"Lp = \"&L48&\"m\",\"\")","v":"Lp = 1m"},null,null,null,null,"既設管までの距離を比較する\n一体化長さ",null,null,{"$f":"IF(AND(T47<=2*T41),T47,2*T41)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"一体化長さ",null,null,{"$f":"VLOOKUP(V44,'曲管の早見表（JDPA T57 P20）'!5:10,X48,FALSE)","v":1},"一体化長さ",null,null,{"$f":"VLOOKUP(Z44,'曲管の早見表（JDPA T57 P20）'!5:10,AB48,FALSE)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"表示用",{"$f":"IF('NE（入力値と結果のみ）'!F5=\"⑥\",\"Lp = \"&X50&\"m\",\"\")","v":""},null,null,"表示用",{"$f":"IF('NE（入力値と結果のみ）'!F5=\"⑦\",\"Lp = \"&AB50&\"m\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"既設管側の一体化長さ",null,null,{"$f":"IF(AND(T49<'NE（入力値と結果のみ）'!K6),\"Lp =\"&'NE（計算値や早見表）'!T41&\"m\",\"\")","v":"Lp =1m"}]
["2018.03.16 光森",null,null,null,null,null,null,null,"2018.03.16 光森",null,null,null,null,null,null,null,null,null,"表示用",{"$f":"IF('NE（入力値と結果のみ）'!F5=\"⑤\",T52,\"\")","v":""}]
["管端部および仕切弁部の一体化長さ（計算値）",null,null,null,null,null,null,null,"管端部および仕切弁部の一体化長さ（計算値）",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(T49<'NE（入力値と結果のみ）'!K6),\"\",\"曲管部に防護コンクリートを打設して下さい\")","v":""}]
["呼び径",{"$f":"'NE（入力値と結果のみ）'!F6","v":75},null,null,null,null,null,null,"呼び径",{"$f":"'NE（入力値と結果のみ）'!$F$6","v":75},null,null,null,null,null,null,null,null,"表示用",{"$f":"IF(AND('NE（入力値と結果のみ）'!F5=\"⑤\",OR('NE（入力値と結果のみ）'!F14=\"一般継手\",'NE（入力値と結果のみ）'!F14=\"不明・その他\")),T54,\"\")","v":""}]
["管外径",{"$f":"IF(B55=75,0.093,IF(B55=100,0.118,IF(B55=150,0.169,IF(B55=200,0.22,IF(B55=250,0.2716,IF(B55=300,0.3228,0.4256))))))","v":9.2999999999999999E-2},"m",null,null,null,null,null,"管外径",{"$f":"IF(B55=75,0.093,IF(B55=100,0.118,IF(B55=150,0.169,IF(B55=200,0.22,IF(B55=250,0.2716,IF(B55=300,0.3228,0.4256))))))","v":9.2999999999999999E-2}]
["設計水圧",{"$f":"'NE（入力値と結果のみ）'!F8","v":0.75},"MPa",null,null,null,null,null,"設計水圧",{"$f":"'NE（入力値と結果のみ）'!$F$8","v":0.75}]
["土被り",{"$f":"'NE（入力値と結果のみ）'!F9","v":0.6},"m",null,null,null,null,null,"土被り",{"$f":"'NE（入力値と結果のみ）'!$F$9","v":0.6}]
["摩擦係数",{"$f":"'NE（入力値と結果のみ）'!F12","v":0.3},null,null,null,null,null,null,"摩擦係数",{"$f":"'NE（入力値と結果のみ）'!$F$12","v":0.3}]
["単位体積重量",{"$f":"'NE（入力値と結果のみ）'!F13","v":16},"kN/m3",null,null,null,null,null,"単位体積重量",{"$f":"'NE（入力値と結果のみ）'!$F$13","v":16}]
["安全率",1.25,null,null,null,null,null,null,"安全率",1.25]
[]
["(1)P",{"$f":"(PI()/4)*B56^2*B57*1000","v":5.0946815364183982},"kN",null,null,null,null,null,"(1)P",{"$f":"(PI()/4)*J56^2*J57*1000","v":5.0946815364183982}]
["(2)Wf",{"$f":"B60*(B58+B56/2)","v":10.343999999999999},"kN/m2",null,null,null,null,null,"(2)Wf",{"$f":"J60*(J58+J56/2)","v":10.343999999999999}]
["(3)Lp",{"$f":"(B61*B63)/(B59*B64*PI()*B56)","v":7.0239994199535989},"m",null,null,null,null,null,"(3)Lp",{"$f":"(J61*J63)/(J59*J64*PI()*J56)","v":7.0239994199535989}]

{"sheet":"計算による従来の一体化長さ","index":2,"n_rows":71,"n_cols":9,"rows_kept":71,"cut":false,"hidden":true,"merged":[[10,0,11,4]]}
["NS・S形ダクタイル鉄管管路の設計（P35）"]
[]
[null,null,null,"VLOOK用"]
["呼び径",{"$f":"'NE（入力値と結果のみ）'!F6","v":75}]
["曲管Aの角度",{"$f":"'NE（入力値と結果のみ）'!K10","v":5.625},"→",{"$f":"IF(AND(B5<=22.5),3,IF(AND(22.5<B5,B5<=45),5,IF(AND(45<B5,B5<112.5),7,)))","v":3}]
["設計水圧",{"$f":"'NE（入力値と結果のみ）'!F8","v":0.75},"→",{"$f":"IF(AND(B6<=0.75),0,1)","v":0}]
[null,null,null,"↓"]
[null,null,null,{"$f":"D4+D5+D6","v":3}]
["一体化長さ",null,null,{"$f":"VLOOKUP(B4,'曲管の早見表（JDPA T57 P20）'!5:10,D8,FALSE)","v":1},null,null,"技術資料の（）内の番号に対応"]
[null,null,null,null,null,null,"↓"]
["これより下が計算による従来の一体化長さ"]
[]
[]
["菅外径",null,null,"D2",{"$f":"VLOOKUP(B4,菅外径と管厚と継手の限界曲げモーメント!A3:B8,2,FALSE)","v":9.2999999999999999E-2}]
["管の断面積",null,null,null,{"$f":"0.25*PI()*E14^2","v":6.7929087152245309E-3}]
["①曲管部に作用する不平均力",null,null,null,{"$f":"2*計算による従来の一体化長さ!B6*1000*E15*SIN((計算による従来の一体化長さ!B5*PI()/180)/2)","v":0.49996834886177521},null,"(1)"]
[]
[]
["管種",{"$f":"'NE（入力値と結果のみ）'!F10","v":"E種"},null,null,{"$f":"IF(AND(B19=\"1種\"),3,4)","v":4}]
["公称管厚",null,null,"T",4.4999999999999997E-3]
["公称管厚≦0.01mmの場合の計算管厚",null,null,null,{"$f":"(VLOOKUP(B4,菅外径と管厚と継手の限界曲げモーメント!A3:D8,E19,FALSE))-0.001","v":5.0000000000000001E-3},null,"(2)"]
["公称管厚>0.01mmの場合の計算管厚",null,null,null,{"$f":"(VLOOKUP(B4,菅外径と管厚と継手の限界曲げモーメント!A3:D8,E19,FALSE))/1.1","v":5.4545454545454541E-3},null,"(3)"]
["②計算管厚",null,null,"t",3.8E-3]
[]
[]
["土の単位体積重量",null,null,"γs",{"$f":"'NE（入力値と結果のみ）'!F13","v":16}]
["土被り",null,null,"h",{"$f":"'NE（入力値と結果のみ）'!F9","v":0.6}]
["有効土被り",null,null,"hs",{"$f":"E27+(E14/2)","v":0.64649999999999996}]
["③土被りによる土圧",null,null,"Wf",{"$f":"E26*E28","v":10.343999999999999},null,"(4)"]
[]
[]
["地盤反力係数",null,null,"k",3000]
["管外径",null,null,"D2",{"$f":"E14","v":9.2999999999999999E-2}]
["管内径",null,null,"D1",{"$f":"E33-2*E23","v":8.5400000000000004E-2}]
["ダクタイル鋳鉄の弾性係数",null,null,"E",{"$f":"1.6*10^8","v":160000000}]
["管の鉄部の弾性二次モーメント",null,null,"I",{"$f":"PI()/64*(E33^4-E34^4)","v":1.0610247254620094E-6}]
["β",null,null,null,{"$f":"(E32*E33/4/E35/E36)^(1/4)","v":0.80061676711721108},null,"(6)"]
["管の鉄部の断面積",null,null,"A1",{"$f":"PI()/4*(E33^2-E34^2)","v":1.0648742458607961E-3}]
["管と土の摩擦係数",null,null,"μ",{"$f":"'NE（入力値と結果のみ）'!F12","v":0.3}]
["α",null,null,null,{"$f":"E38*E35*E39*E29*PI()","v":1661031.7948326413}]
["仮定した一体化長さ",null,null,"Lp",{"$f":"'NE（入力値と結果のみ）'!K5","v":7}]
["cosh(2βLp)",null,null,null,{"$f":"COSH(2*E37*E41)","v":36882.319146111404}]
["cos(2βLp)",null,null,null,{"$f":"COS(2*E37*E41)","v":0.21145213566233817}]
["sinh(2βLp)",null,null,null,{"$f":"SINH(2*E37*E41)","v":36882.319132554767}]
["sin(2βLp)",null,null,null,{"$f":"SIN(2*E37*E41)","v":-0.9773883538920628}]
["X",null,null,null,{"$f":"(E42+E43+2)/(E44+E45)","v":1.0000864625280803},null,"(7)"]
["βαX*(1/k)",null,null,null,{"$f":"E37*E40*E46/E32","v":443.3216292808728}]
["tan（θ/2）",null,null,null,{"$f":"TAN(PI()/180*B5/2)","v":4.9126849769467254E-2}]
["cos（θ/2）",null,null,null,{"$f":"COS(PI()/180*B5/2)","v":0.99879545620517241}]
["④管軸方向に作用する力 （1）",null,null,"P2",{"$f":"-(E47*E48^2)+((E47*E48^2)^2+(E16*E47*E48/E49))^(0.5)","v":2.4009018686020229},null,"(5)"]
[]
["⑤管と土の摩擦力から計算される一体化長さ　",null,null,"Lp1",{"$f":"E50/(E39*E29*PI()*E33)","v":2.6480843934016098},null,"(9)"]
[]
["Lp≧Lp1の場合のP2",null,null,null,{"$f":"E50","v":2.4009018686020229}]
["Lp<Lp1の場合のP3",null,null,null,{"$f":"E39*E29*PI()*E33*E41","v":6.3465927000255187}]
["⑥管軸方向に作用する力 （2）",null,null,"P2",{"$f":"IF(AND(E41>=E52),E54,E55)","v":2.4009018686020229}]
[]
["⑦管軸直角方向に作用する力",null,null,"P1",{"$f":"(E16/2/E49)-E56*E48","v":0.13233690905286044},null,"(11)"]
[]
["Y",null,null,null,{"$f":"(E42-E43)/(E44+E45)","v":1.0000207679476572}]
["⑧発生曲げモーメント",null,null,"M",{"$f":"E58*E60/2/E37","v":8.264856723859125E-2},null,"(12)"]
[]
["継手の限界曲げモーメント",null,null,"M0'",{"$f":"VLOOKUP(B4,菅外径と管厚と継手の限界曲げモーメント!A3:E8,5,FALSE)","v":4.4000000000000004}]
["計算に用いる限界曲げモーメント",null,null,"M0",{"$f":"E63","v":4.4000000000000004}]
["⑨曲げモーメントに対する継手の安全率",null,null,"Sf",{"$f":"E64/E61","v":53.237462511576368},null,"(13)"]
[]
[]
["⑩曲管部の移動量",null,null,"δ1",{"$f":"E58*E37*E46/E32/E33","v":3.7978605412301153E-4},null,"(14)"]
[]
[]
["不平均力P方向の曲管部の移動量",null,null,"δ",{"$f":"E68/E49","v":3.8024407476378822E-4},null,"(15)",null,"(8)、(10)は不要"]

{"sheet":"計算による従来の一体化長さ手順","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"菅外径と管厚と継手の限界曲げモーメント","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5]
["呼び径","管外径（m）","1種公称管厚（m）","S種公称管厚（m）","継手の限界曲げモーメント"]
[75,9.2999999999999999E-2,7.4999999999999997E-3,6.0000000000000001E-3,4.4000000000000004]
[100,0.11799999999999999,7.4999999999999997E-3,6.0000000000000001E-3,7.4]
[150,0.16900000000000001,7.4999999999999997E-3,6.4999999999999997E-3,17]
[200,0.22,7.4999999999999997E-3,6.4999999999999997E-3,24]
[250,0.27160000000000001,7.4999999999999997E-3,6.4999999999999997E-3,35]
[300,0.32279999999999998,7.4999999999999997E-3,7.0000000000000001E-3,64]

{"sheet":"曲管の早見表（JDPA T57 P20）","index":5,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":true,"merged":[[7,0,7,1],[8,0,8,1],[9,0,9,1],[1,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1]]}
[1,2,3,4,5,6,7,8]
["呼び径",null,"22.5°以下",null,"22.5°を越え45°以下",null,"45°を越え90°以下"]
[null,null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）"]
[null,null,0.75,1.3,0.75,1.3,0.75,1.3]
[75,null,1,1,1,1,1,4]
[100,null,1,1,1,1,1,4,"→NEは4"]
[150,null,1,1,1,1,4,6]
[200,null,1,1,1,1,4,8]
[250,null,1,1,1,2,6,11]
[300,null,1,2,1,7,7,16]

{"sheet":"T字管の早見表（JDPA T57 P20） ","index":6,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":true,"merged":[[8,0,8,1],[1,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1]]}
[1,2,3,4]
["呼び径",null,"設計水圧（MPa）"]
[null,null,0.75,1.3]
[75,null,1,1]
[100,null,1,1]
[150,null,1,6]
[200,null,1,6]
[250,null,2,7]
[300,null,7,13]

{"sheet":"管端部および仕切弁部の早見表（JDPA T57 P49）","index":7,"n_rows":11,"n_cols":22,"rows_kept":11,"cut":false,"hidden":true,"merged":[[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[1,0,1,1],[2,0,2,1],[3,0,4,1],[5,0,5,1],[6,0,6,1],[3,12,3,13],[3,14,3,15],[3,16,3,17],[3,18,3,19],[3,20,3,21],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]
["管摩擦係数",null,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4]
["土被り [m]",null,0.6,0.6,0.8,0.8,1,1,1.2,1.2,1.4,1.4,0.6,0.6,0.8,0.8,1,1,1.2,1.2,1.4,1.4]
["呼び径",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）"]
[null,null,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3]
[75,null,7.5,12.5,5.5,9.5,4.5,8,4,6.5,3.5,5.5,5.5,9.5,4.5,7,3.5,6,3,5,2.5,4.5]
[100,null,9,15.5,7,12,5.5,9.5,5,8,4,7,7,11.5,5.5,9,4.5,7.5,3.5,6,3,5.5]
[150,null,12.5,21,9.5,16.5,8,13.5,6.5,11.5,6,10,9.5,16,7,12.5,6,10,5,8.5,4.5,7.5]
[200,null,15.5,26.5,12,20.5,10,17,8.5,14.5,7,12,11.5,20,9,15.5,7.5,13,6.5,11,5.5,9.5]
[250,null,18.5,31.5,14.5,25,12,20.5,10,17.5,9,15,14,23.5,11,18.5,9,15.5,7.5,13,6.5,11.5]
[300,null,21,36,16.5,28.5,14,24,12,20.5,10.5,17.5,16,27,12.5,21.5,10.5,18,9,15.5,8,13.5]

{"sheet":"片落管部の早見表（JDPA T57 P48）","index":8,"n_rows":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":true,"merged":[[3,8,3,9],[3,10,3,11],[3,0,3,1],[1,0,1,1],[2,0,2,1],[3,6,3,7],[3,2,3,3],[3,4,3,5],[3,12,3,13],[3,14,3,15],[3,16,3,17],[3,18,3,19],[3,20,3,21]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
["管摩擦係数",null,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4]
["土被り [m]",null,0.6,0.6,0.8,0.8,1,1,1.2,1.2,1.4,1.4,0.6,0.6,0.8,0.8,1,1,1.2,1.2,1.4,1.4]
["呼び径",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）",null,"設計水圧（MPa）"]
["大菅","小管",0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3,0.75,1.3]
[100,75,3.5,6,3,4.5,2.5,4,2,3.5,1.5,3,2.5,4.5,2,3.5,2,3,1.5,2.5,1.5,2]
[150,100,6.5,11,5,8.5,4,7,3.5,6,3,5,5,8.5,4,6.5,3,5.5,2.5,4.5,2.5,4]
[200,150,6.5,11,5,8.5,4,7,3.5,6,3,5.5,5,8.5,4,6.5,3,5.5,3,4.5,2.5,4]
[250,200,6.5,11,5,8.5,4.5,7,3.5,6,3,5.5,5,8.5,4,6.5,3.5,5.5,3,4.5,2.5,4]
[300,100,18,31.5,14.5,25,12,20.5,10.5,17.5,9,15.5,13.5,23.5,11,18.5,9,15.5,8,13.5,7,11.5]
[300,150,15.5,26.5,12,21,10,17.5,8.5,15,7.5,13,11.5,20,9,15.5,7.5,13,6.5,11,5.5,10]
[300,200,11.5,19.5,9,15.5,7.5,13,6.5,11,5.5,9.5,8.5,14.5,7,11.5,5.5,9.5,5,8.5,4.5,7.5]
[300,250,6.5,10.5,5,8.5,4,7,3.5,6,3,5.5,5,8,4,6.5,3,5.5,3,4.5,2.5,4]