{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":50,"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":"Sheet1","index":0,"n_rows":84,"n_cols":9,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
["材料","SN400"]
["ヤング係数",205000,"N/mm2"]
["F",235,"N/mm2"]
["限界細長比Λ",{"$f":"SQRT(PI()^2*B2/(0.6*B3))","v":119.78908480518268}]
[]
["諸条件"]
["スパン",20000,"mm"]
["荷重",30,"kN/m"]
[]
["設計変数",null,null,null,"下限","上限"]
["ライズ",2000,"mm",null,{"$f":"0.1*B7","v":2000},{"$f":"0.5*B7","v":10000}]
["選択断面No.",1]
[]
[]
["円弧中心・半径の算定"]
[null,"x","y"]
["Ａ点",0,0,null,"a11",{"$f":"2*(B18-B17)","v":20000}]
["Ｂ点",{"$f":"B7/2","v":10000},{"$f":"B11","v":2000},null,"a12",{"$f":"2*(C18-C17)","v":4000}]
["Ｃ点",{"$f":"B7","v":20000},{"$f":"C17","v":0},null,"a21",{"$f":"2*(B19-B18)","v":20000}]
[null,null,null,null,"a22",{"$f":"2*(C19-C18)","v":-4000}]
[null,"x0","y0",null,"b11",{"$f":"B18^2-B17^2+C18^2-C17^2","v":104000000}]
["円弧中心点",{"$f":"1/F23*(F20*F21-F18*F22)","v":10000},{"$f":"1/F23*(-F19*F21+F17*F22)","v":-24000},null,"b21",{"$f":"B19^2-B18^2+C19^2-C18^2","v":296000000}]
[null,"Ｒ",null,null,"det|A|",{"$f":"F17*F20-F18*F19","v":-160000000}]
["円弧半径",{"$f":"SQRT((B17-B22)^2+(C17-C22)^2)","v":26000},"mm"]
[null,"φ(rad)","角度"]
[null,{"$f":"ACOS((B24-B11)/B24)","v":0.39479111969976133},{"$f":"B26/PI()*180","v":22.619864948040416}]
[]
["アーチの反力"]
["⊿=",{"$f":"B26-3*COS(B26)*SIN(B26)+2*B26*COS(B26)^2","v":2.4824952827872115E-3}]
["VA=VC=",{"$f":"B8*B26*B24/10^3","v":307.93707336581389},"kN","合力"]
["HA=-HC=",{"$f":"B8*B24/10^3/(4*B29)*(-8*fai+(9-4*fai^2)*SIN(2*fai)-10*fai*COS(2*fai))","v":756.75727817808672},"kN",{"$f":"SQRT(B30^2+B31^2)","v":817.01090520788568},"kN"]
[]
["アーチの応力"]
["分割",10]
["⊿φ",{"$f":"fai/B34","v":3.9479111969976131E-2}]
[]
[null,"α","y","Mx","N",null,"σb/fb","σc/fc","検定比"]
[null,"rad","mm","kN*m","kN"]
[{"$f":"B34","v":10},{"$f":"A39*$B$35","v":0.39479111969976133},{"$f":"$B$24*(COS(B39)-COS(fai))","v":0},{"$f":"$B$8*($B$24/10^3)^2*(fai*SIN(fai)+COS(fai)-B39*SIN(B39)-COS(B39))-$B$31*(C39/10^3)","v":-2.2515322939398175E-12},{"$f":"-$B$8*($B$24/10^3)*B39*SIN(B39)-$B$31*COS(B39)","v":-816.98251576662381},null,0,{"$f":"ABS(E39)*10^3/VLOOKUP($B$12,sec,6,0)/$B$60","v":24.970578269854087},{"$f":"G39+H39","v":24.970578269854087}]
[{"$f":"A39-1","v":9},{"$f":"A40*$B$35","v":0.35531200772978516},375.98779982510354,-5.1806484818941954,{"$f":"-$B$8*($B$24/10^3)*B40*SIN(B40)-$B$31*COS(B40)","v":-805.90213748271276},null,{"$f":"ABS(D40)*10^6/VLOOKUP($B$12,sec,8,0)/$B$59","v":0.44801653504336564},24.63191318478998,{"$f":"G40+H40","v":25.079929719833345}]
[{"$f":"A40-1","v":8},0.31583289575980905,713.98811251975621,-7.3300195277879538,-795.8447962190229,null,{"$f":"ABS(D41)*10^6/VLOOKUP($B$12,sec,8,0)/$B$59","v":0.63389167632524879},24.324516609753189,24.958408286078438]
[7,0.27635378378983294,1013.4741991212542,-7.2663696146809116,-786.85776554739687,null,0.62838730488879835,24.049833432979401,24.678220737868198]
[6,0.23687467181985677,1273.9793411542696,-5.7177841879351945,-778.98305030845461,null,0.49446741444767017,23.80914750710949,24.303614921557159]
[5,0.19739555984988066,1495.0975679639243,-3.31990852225249,-772.25727751702334,null,0.28710187884754418,23.603578314779718,23.890680193627261]
[4,0.15791644787990453,1676.4842893795869,-0.61397030611669834,-766.71160132777914,null,5.3095447438144761E-2,23.434078063953852,23.487173511391997]
[3,0.11843733590992839,1817.8568327234605,1.9549014308488495,-762.37162226834869,null,0.1690576321595923,23.301429219331585,23.470486851491177]
[2,7.8958223939952263E-2,1918.9948833270664,4.0390571225134408,-759.25732091594591,null,0.34929302445339228,23.206242475214896,23.555535499668288]
[{"$f":"A47-1","v":1},3.9479111969976131E-2,1979.7408278691601,5.3894039801018607,-757.38300616208346,null,0.46606947094610313,23.14895517425014,23.615024645196243]
[0,0,1999.9999999999986,5.8561773019634984,-756.75727817808672,null,0.5064354921193196,23.129830175491307,23.636265667610626]
[]
[null,null,"max",{"$f":"MAX(D39:D49)","v":5.8561773019634984},null,null,null,"max",{"$f":"MAX(I39:I49)","v":25.079929719833345}]
[null,null,"min",{"$f":"MIN(D39:D49)","v":-7.3300195277879538},{"$f":"MIN(E39:E49)","v":-816.98251576662381}]
[]
[]
["細長比、許容応力度"]
["アーチ全長",{"$f":"2*B24*fai","v":20529.138224387589},"mm"]
["λ",{"$f":"(B56/2)/VLOOKUP(B12,sec,9,0)","v":245.08788783783882},null,null,"λ／Λ","v","λ≦Λ","λ＞Λ"]
[null,null,null,null,{"$f":"B57/B4","v":2.0459951608815956},{"$f":"3/2+2/3*E58^2","v":4.2907307989006043},{"$f":"(1-0.4*E58^2)*$B$3/F58","v":-36.938472738861925},{"$f":"0.277*$B$3/(E58)^2","v":15.550287646433897}]
[" 長期　fb",{"$f":"B3/1.5","v":156.66666666666666},"N/mm2"]
["fc",{"$f":"IF(B57>B4,H58,G58)","v":15.550287646433897},"N/mm2"]
[]
[]
["総重量"]
["γ",78.5,"kN/㎥"]
["総重量",{"$f":"VLOOKUP(B12,sec,6,0)*B56*B64/10^9","v":3.3906745856927514},"kN"]
[]
[]
["多目的最適化"]
[null,null,null,null,"重みパラメータ"]
[null,null,"M0","H0","w1","w2"]
["目的関数",{"$f":"E71*B65/C71+F71*B31/D71","v":3.5750316134704023E-2},94.843205663328675,756.75727817808672,1,{"$f":"1-E71","v":0}]
[]
["結果を記録","w1","w2","総重量","水平反力","目的関数","ライズ","断面No.","2018-01-15T14:00:39"]
[null,0,1,47.665751704738071,150.00000000000003,0.19821414914056595,10000,65,"2018-01-15T14:01:33"]
[null,0.1,0.9,30.046309749245992,150.64318138247356,0.21083764135634908,9968.4310159047254,74,"2018-01-15T14:02:18"]
[null,0.2,0.8,28.165005500485815,152.56039111515776,0.22067079084461272,9874.8867773486545,95,"2018-01-15T14:03:05"]
[null,0.3,0.7,28.165005500485815,152.56039111515776,0.23020742587544263,9874.8867773486545,95,"2018-01-15T14:03:52"]
[null,0.4,0.6,23.025612896192118,172.62343154423112,0.23397585265245591,8948.560352176939,94,"2018-01-15T14:04:39"]
[null,0.5,0.5,23.025612896192118,172.62343154423112,0.23544247147346237,8948.560352176939,94,"2018-01-15T14:05:26"]
[null,0.6,0.4,16.526267801986076,231.52325050201804,0.22692547378332636,6808.5730865978257,31,"2018-01-15T14:06:08"]
[null,0.7,0.30000000000000004,16.526267801986076,231.52325050201804,0.21375618151997455,6808.5730865978257,31,"2018-01-15T14:06:24"]
[null,0.8,0.19999999999999996,10.936364702467834,340.85100813051156,0.18232994501594574,4561.3022579707131,30,"2018-01-15T14:06:52"]
[null,0.9,9.9999999999999978E-2,10.936364986962035,340.85097086856814,0.14881994211846206,4561.3027812557011,30,"2018-01-15T14:07:34"]
[null,1,0,10.078919456460525,584.99679146403798,0.10626928292827159,2601.7069564663148,30,"2018-01-15T14:08:15"]

{"sheet":"Sheet2","index":1,"n_rows":126,"n_cols":10,"rows_kept":126,"cut":false,"hidden":false,"merged":[]}
[null,1,{"$f":"B1+1","v":2},{"$f":"C1+1","v":3},4,5,6,7,8,9]
[]
["E",205000,"N/mm2"]
["F",235,"N/mm2","SN400B"]
[]
[null,"断面no.","H","B","t1","t2","断面積","断面２次","断面係数","断面2次半径"]
[null,null,null,null,null,null,"A","Iy","Zy","i"]
["ＪＩＳ",1,100,100,6,8,{"$f":"C8*D8-(D8-E8)*(C8-2*F8)","v":2104},{"$f":"(C8^3*D8-(D8-E8)*(C8-2*F8)^3)/12","v":3690485.3333333335},{"$f":"H8/(C8/2)","v":73809.706666666665},{"$f":"SQRT(H8/G8)","v":41.881176596475854}]
[null,{"$f":"B8+1","v":2},125,125,6.5,9,{"$f":"C9*D9-(D9-E9)*(C9-2*F9)","v":2945.5},{"$f":"(C9^3*D9-(D9-E9)*(C9-2*F9)^3)/12","v":8247752.458333333},{"$f":"H9/(C9/2)","v":131964.03933333332},{"$f":"SQRT(H9/G9)","v":52.916156889302073}]
[null,3,150,150,7,10,3910,16006583.333333334,213421.11111111112,63.982461098477948]
[null,4,175,175,7.5,11,4997.5,28164706.458333332,321882.35952380951,75.071693541922258]
[null,5,200,200,8,12,6208,46104917.333333336,461049.17333333334,86.178269639599989]
[null,6,250,250,9,14,8998,105788119.33333333,846304.95466666657,108.42900033845092]
[null,7,300,300,10,15,11700,199327500,1328850,130.52409149861361]
[null,8,350,350,12,19,17044,395061761.33333331,2257495.7790476191,152.24629585195652]
[null,9,400,400,13,21,21454,653615871.33333337,3268079.3566666669,174.54489709674675]
[null,{"$f":"B16+1","v":10},148,100,6,9,2580,9805100,132501.35135135136,61.647598141283225]
[null,{"$f":"B17+1","v":11},194,150,6,9,3756,25845988,266453.48453608248,82.953320977094464]
[null,{"$f":"B18+1","v":12},244,175,7,11,5404,58674261.333333336,480936.56830601097,104.19962242065921]
[null,13,294,200,8,12,6960,108608400,738832.6530612245,124.91859418202637]
[null,14,340,250,9,14,9808,208875829.33333334,1228681.349019608,145.93311912753921]
[null,15,390,300,10,16,13180,374142793.33333331,1918680.9914529913,168.48490098939482]
[null,16,440,300,11,18,15244,541562725.33333337,2461648.7515151515,188.48418345746472]
[null,17,488,300,11,18,15772,681371557.33333337,2792506.3825136614,207.84932390792451]
[null,18,588,300,12,20,18576,1132838592,3853192.4897959186,246.94936659988153]
[null,19,700,300,13,24,22876,1946069925.3333333,5560199.7866666662,291.66826391122947]
[null,20,800,300,14,26,26072,2825535690.6666665,7063839.2266666666,329.20257607576013]
[null,21,890,299,15,23,26414,3336803428.6666665,7498434.6711610481,355.42520680953015]
[null,22,900,300,16,28,30304,3996325845.3333335,8880724.1007407419,363.14533304304882]
[null,23,912,302,18,34,35728,4861514133.333333,10661215.204678362,368.87686942627749]
[null,24,918,303,19,37,38458,5305246803.333333,11558271.902687,371.41500804978449]
[null,25,150,75,5,7,1730,6420256.666666667,85603.422222222231,60.919053022799076]
[null,26,175,90,5,8,2235,11722586.25,133972.41428571427,72.422406985387099]
[null,27,200,100,5.5,8,2612,17609322.666666668,176093.22666666668,82.107861181434316]
[null,28,250,125,6,9,3642,38929334,311434.67200000002,103.38761483708946]
[null,29,300,150,6.5,9,4533,69325191,462167.94,123.66667320749943]
[null,30,350,175,7,11,6146,131234688.66666667,749912.50666666671,146.12618453630216]
[null,31,400,200,8,13,8192,229648682.66666666,1148243.4133333333,167.43143808237846]
[null,32,450,200,9,14,9398,322589452.66666669,1433730.9007407408,185.27096410707424]
[null,33,500,200,10,16,11080,460365493.33333331,1841461.9733333332,203.83628786430751]
[null,34,600,200,11,17,13026,744186438,2480621.46,239.02060354193216]
["ハイパーＨ",35,400,200,9,12,8184,220578432,1102892.1599999999,164.17185759739539]
[null,36,400,200,9,16,9712,273443157.33333331,1367215.7866666666,167.79506864968383]
[null,37,400,200,9,19,10858,311612979.33333331,1558064.8966666665,169.40758471783732]
[null,38,400,200,9,22,12004,348538245.33333331,1742691.2266666666,170.39711084986871]
[null,39,400,200,12,22,13072,359817749.33333331,1799088.7466666666,165.90912457516936]
[null,40,450,200,9,12,8634,288251982,1281119.92,182.71749346558494]
[null,41,450,200,9,16,10162,356282107.33333331,1583476.0325925925,187.24378475000901]
[null,42,450,200,9,19,11308,405625429.33333331,1802779.6859259258,189.39551350365781]
[null,43,450,200,9,22,12454,453552295.33333331,2015787.9792592591,190.83553812715246]
[null,44,450,200,12,19,12544,423109061.33333331,1880484.717037037,183.65727680418561]
[null,45,450,200,12,22,13672,470283149.33333331,2090147.3303703703,185.46573461585405]
[null,46,450,200,12,25,14800,516083333.33333331,2293703.7037037038,186.73643323008903]
[null,47,450,250,9,16,11762,431658640.66666669,1918482.8474074076,191.57094070993986]
[null,48,450,250,9,19,13208,493919062.66666669,2195195.8340740739,193.37902394227808]
[null,49,450,250,9,22,14654,554392228.66666663,2463965.4607407404,194.50486716551831]
[null,50,450,250,12,22,15872,571123082.66666663,2538324.8118518516,189.69200595611801]
[null,51,450,250,12,25,17300,629104166.66666663,2796018.5185185182,190.69452718286169]
[null,52,450,250,12,28,18728,685371650.66666663,3046096.2251851852,191.30105624204541]
[null,53,500,200,9,12,9084,366718032,1466872.128,200.92203578749991]
[null,54,500,200,9,16,10612,451823557.33333331,1807294.2293333332,206.34113478048994]
[null,55,500,200,9,19,11758,513772879.33333331,2055091.5173333331,209.0349282680717]
[null,56,500,200,9,22,12904,574133845.33333337,2296535.3813333334,210.93293590884821]
[null,57,500,200,12,19,13144,538425661.33333337,2153702.6453333334,202.39468330764791]
[null,58,500,200,12,22,14272,597838549.33333337,2391354.1973333335,204.66780843276175]
[null,59,500,200,12,25,15400,655708333.33333337,2622833.3333333335,206.34549474961455]
[null,60,500,250,9,16,12212,545560090.66666663,2182240.3626666665,211.36248125522908]
[null,61,500,250,9,19,13658,623726512.66666663,2494906.0506666666,213.69952078965346]
[null,62,500,250,9,22,15104,699888778.66666663,2799555.1146666664,215.26257287899787]
[null,63,500,250,12,22,16472,723593482.66666663,2894373.9306666665,209.59173679037977]
[null,64,500,250,12,25,17900,796854166.66666663,3187416.6666666665,210.99050346214739]
[null,65,500,250,12,28,19328,868187050.66666663,3472748.2026666664,211.94012857773126]
[null,66,500,300,12,19,{"$f":"C73*D73-(D73-E73)*(C73-2*F73)","v":16944},{"$f":"(C73^3*D73-(D73-E73)*(C73-2*F73)^3)/12","v":758332928},{"$f":"H73/(C73/2)","v":3033331.7119999998},{"$f":"SQRT(H73/G73)","v":211.55436262931957}]
[null,67,500,300,12,22,18672,849348416,3397393.6639999999,213.27871783756015]
[null,68,500,300,12,25,20400,938000000,3752000,214.43039000305612]
[null,69,500,300,16,22,20496,880954688,3523818.7519999999,207.32049128006082]
[null,70,500,300,16,25,22200,968375000,3873500,208.85520222272535]
[null,71,500,300,16,28,23904,1053494912,4213979.648,209.93310593903522]
[null,72,550,200,9,12,9534,456539082,1660142.1163636365,218.82725211475179]
[null,73,550,200,9,16,11062,560630007.33333337,2038654.5721212123,225.12376461743935]
[null,74,550,200,9,19,12208,636617829.33333337,2314973.9248484848,228.35847728060207]
[null,75,550,200,9,22,13354,710845395.33333337,2584892.3466666667,230.71821939331528]
[null,{"$f":"B82+1","v":76},550,200,12,19,13744,670172261.33333337,2436990.0412121215,220.81910783652722]
[null,77,550,200,12,22,14872,743233949.33333337,2702668.9066666667,223.55175371213531]
[null,78,550,200,12,25,16000,814583333.33333337,2962121.2121212124,225.63567610937179]
[null,79,550,250,9,16,12662,674726540.66666663,2453551.0569696967,230.84089116226991]
[null,80,550,250,9,19,14108,770606462.66666663,2802205.3187878788,233.71339165240681]
[null,81,550,250,9,22,15554,864265328.66666663,3142783.0133333332,235.72329230003461]
[null,82,550,250,12,22,17072,896653882.66666663,3260559.5733333332,229.17657023274131]
[null,83,550,250,12,25,18500,986979166.66666663,3589015.1515151514,230.97667679925007]
[null,84,550,250,12,28,19928,1075162450.6666667,3909681.6387878791,232.27645381510857]
[null,85,550,250,16,28,21904,1115347045.3333333,4055807.4375757575,225.65413448468357]
[null,86,550,250,16,32,23776,1227716341.3333333,4464423.0593939396,227.23730093811665]
[null,87,550,300,12,16,15816,823571032,2994803.7527272729,228.1929396444844]
[null,88,550,300,12,19,17544,938149528,3411452.8290909091,231.24466545898431]
[null,89,550,300,12,22,19272,1050073816,3818450.24,233.42454512077384]
[null,90,550,300,12,25,21000,1159375000,4215909.0909090908,234.96453633119475]
[null,91,550,300,16,22,21296,1093258554.6666667,3975485.6533333338,226.57522665404824]
[null,92,550,300,16,25,23000,1201041666.6666667,4367424.2424242431,228.51521371355284]
[null,93,550,300,16,28,24704,1306268778.6666667,4750068.2860606061,229.94958710105294]
[null,94,600,200,9,12,9984,558277632,1860925.4399999999,236.46824473749274]
[null,95,600,200,9,16,11512,683263957.33333337,2277546.5244444446,243.62332462077993]
[null,96,600,200,9,19,12658,774722779.33333337,2582409.2644444448,247.39482865038974]
[null,97,600,200,9,22,13804,864249445.33333337,2880831.4844444445,250.21715363605153]
[null,98,600,200,12,19,14344,819098861.33333337,2730329.5377777778,238.96429907729032]
[null,99,600,200,12,22,15472,907219349.33333337,3024064.4977777777,242.14913600416358]
[null,100,600,200,12,25,16600,993458333.33333337,3311527.777777778,244.63623515374988]
[null,101,600,200,12,28,17728,1077836117.3333333,3592787.0577777773,246.57355383101569]
[null,102,600,250,9,16,13112,819720490.66666663,2732401.6355555556,250.03362962745973]
[null,103,600,250,9,19,14558,935121412.66666663,3117071.3755555553,253.44465890512632]
[null,104,600,250,12,19,16244,979497494.66666663,3264991.6488888888,245.55861451181468]
[null,105,600,250,12,22,17672,1091054282.6666667,3636847.6088888892,248.47364317073087]
[null,106,600,250,12,25,19100,1200229166.6666667,4000763.888888889,250.67752868115116]
[null,107,600,250,12,28,20528,1307047850.6666667,4356826.1688888893,252.33205471220239]
[null,108,600,250,16,28,22704,1360710912,4535703.04,244.81146044005109]
[null,109,600,250,16,32,24576,1497182208,4990607.3600000003,246.82078518633716]
[null,110,600,300,12,19,18144,1139896128,3799653.76,250.64908330764541]
[null,111,600,300,12,22,19872,1274889216,4249630.7199999997,253.28847810371602]
[null,112,600,300,12,25,21600,1407000000,4690000,255.22321385189258]
[null,113,600,300,12,28,23328,1536259584,5120865.28,256.62180143392612]
[null,114,600,300,16,22,22096,1332182421.3333333,4440608.071111111,245.54156452274842]
[null,115,600,300,16,25,23800,1462458333.3333333,4874861.111111111,247.88672641279658]
[null,116,600,300,16,28,25504,1589922645.3333333,5299742.151111111,249.68005290049666]
[null,117,600,300,16,32,27776,1755554474.6666667,5851848.2488888893,251.40406946665212]
[]
[null,null,null,null,null,null,{"$f":"MAX(G8:G124)","v":38458}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}