{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["槽列モデルステップ応答","解析解"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":62,"n_cols":29,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["微分方程式数",10,null,"N=",10,null,null,null,"常微分方程式解法シート　Runge-Kutta法",null,null,"VBAプログラムは吉川浩氏（日大）による",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
["θ=","E1=","E2=","E3=","E4=","E5=","E6=","E7=","E8=","E9=","E10=",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[2.4999999999999951,0.99999999998613842,0.99999999963996133,0.99999999531559847,0.9999999592917046,0.99999973416473042,0.99999860842902111,0.99999391678948801,0.99997715546724075,0.999924756007184,0.99977914074035468]
[null,"E1'=","E2'=","E3'=","E4'=","E5'=","E6'=","E7'=","E8'=","E9'=","E10'="]
["微分方程式→",{"$f":"$E$1*(1-B3)","v":1.3861578551654929E-10},{"$f":"$E$1*(B3-C3)","v":3.4617708699613559E-9},{"$f":"$E$1*(C3-D3)","v":4.3243628677913648E-8},{"$f":"$E$1*(D3-E3)","v":3.6023893867920265E-7},{"$f":"$E$1*(E3-F3)","v":2.251269741737616E-6},1.1257357093175102E-5,4.6916395330942606E-5,1.6761322247260679E-4,5.2399460056751224E-4,1.4561526682932424E-3]
[]
["積分区間t=[a,",0]
["b]",2.5]
["積分刻み幅Δt",0.05]
["計算結果"]
["θ","E1","E2","E3","E4","E5","E6","E7","E8","E9","E10"]
[0,0,0,0,0,0,0,0,0,0,0]
[0.05,0.39322916666666669,9.1145833333333329E-2,1.3020833333333334E-2,2.6041666666666665E-3,0,0,0,0,0,0]
[0.1,0.63182915581597232,0.26523844401041669,7.9176161024305552E-2,1.9334581163194444E-2,3.7773980034722225E-3,5.7644314236111112E-4,6.103515625E-5,6.7816840277777774E-6,0,0]
[0.15,0.77660467006542067,0.4429498425236455,0.19054838463112161,6.5556932378698279E-2,1.8726596125849971E-2,4.5168488113968459E-3,9.1386724401403354E-4,1.5728561966507528E-4,2.2658595332392947E-5,2.6667559588396999E-6]
[0.19999999999999998,0.86445022949282035,0.59451420582187031,0.32312004024415841,0.14263878077452569,5.2689470396733593E-2,1.6657714260581102E-2,4.561092520569578E-3,1.0901690909156094E-3,2.2847550334753817E-4,4.2032910349928321E-5]
[0.24999999999999997,0.91775235279121647,0.71301572025433058,0.4562086566067981,0.24221350958701632,0.10874701414684626,4.2081728590548872E-2,1.4243199705115596E-2,4.261000574865368E-3,1.1350195569852408E-3,2.7058329054733187E-4]
[0.3,0.95009452656342042,0.80102066599750033,0.57692450813183027,0.35264956489312022,0.18461170921958736,8.3916541762823094E-2,3.35615082478017E-2,1.1939264905281011E-2,3.810170685219931E-3,1.0978977082416368E-3]
[0.35000000000000003,0.96971881429499207,0.86418953192389147,0.67928292564408621,0.46333747304575001,0.27443695367258891,0.1423325993373134,6.5312563308638563E-2,2.6780146703988636E-2,9.8954365165983653E-3,3.318048144318421E-3]
[0.40000000000000008,0.98162625971545092,0.9084467275950151,0.7620064369976387,0.56655992658664189,0.37108312966232648,0.21479069712887261,0.11066184948449452,5.1164309358559729E-2,2.1393953063310156E-2,8.1457372584456487E-3]
[0.45000000000000012,0.98885135029609394,0.93889774389747616,0.82650028128368513,0.65776332409668203,0.46786178899843023,0.29699256704438026,0.16890799955742303,8.6595499947520596E-2,4.0286334250148048E-2,1.7114642480170462E-2]
[0.50000000000000011,0.99323532452861951,0.95955711188140325,0.87539646963564766,0.735039648076935,0.55950987811522368,0.38398185999242496,0.23776070031679947,0.13335694512462287,6.8111629995040432E-2,3.1852645923428596E-2]
[0.55000000000000016,0.99589539222700085,0.97341693935855944,0.91164859932085229,0.79835907066202494,0.642509788122123,0.4710501345633672,0.31390882900608247,0.19048162607056365,0.10564498372627495,5.3797782798390259E-2]
[0.6000000000000002,0.99750944372107087,0.9826302405439491,0.93803997493271229,0.84884112170608195,0.71498295301702175,0.55431406310399356,0.39365351899323037,0.25597798254999593,0.15274772142959769,8.3934468065045398E-2]
[0.65000000000000024,0.99848880309117061,0.98870818103745928,0.95696277441159427,0.88818115479404813,0.77636934329361929,0.63097193501214133,0.47344946431706669,0.32720019001108791,0.20839976521907735,0.12261389156397318]
[0.70000000000000029,0.99908304979229878,0.99269194619870782,0.97035713419526526,0.91825284255793393,0.82704498881018673,0.69931588177706783,0.55027926390542004,0.40125155914504163,0.27087528216194118,0.16949006508445774]
[0.75000000000000033,0.99944362135834797,0.99528869072970205,0.97973429562582259,0.94086310017650998,0.86796712757796601,0.75859251280144857,0.6218500753771754,0.47533832589826597,0.3379995000980161,0.22356952501878602]
[0.80000000000000038,0.99966240566795594,0.99697324223330452,0.98623668657867847,0.95762165583605907,0.90038824895623193,0.80879260718830692,0.68664062388416858,0.54702850435567751,0.40742439783108236,0.28334839565626341]
[0.85000000000000042,0.99979515760581705,0.99806147004646573,0.99070811521336999,0.96988840714218605,0.92564903660350628,0.85042782296205266,0.7438426525454811,0.61440340300194429,0.47687491821389399,0.3469990014836204]
[0.90000000000000047,0.99987570760977962,0.99876187709140962,0.99376035442260346,0.9787686587518164,0.94504313867526912,0.88432947172221488,0.7932414019494336,0.67611213499256939,0.5443366942627057,0.41256812078567073]
[0.95000000000000051,0.99992458300280895,0.99921119647143974,0.99583023841500917,0.98513452537858492,0.95973945201875499,0.91148602618474894,0.8350718607387575,0.73135144647011019,0.60817463673540528,0.47815647866362543]
[1.0000000000000004,0.99995423916576687,0.99949859480773773,0.99722573393611569,0.98965803722787959,0.97074628590006407,0.93292340741331015,0.86987675648451401,0.77979660414642604,0.66718567064792367,0.54205998503430941]
[1.0500000000000003,0.99997223366047838,0.9996819383683121,0.9981616150515249,0.99284709013432437,0.97890348325424259,0.94962465036223254,0.8983818905747013,0.82150692167069883,0.7205974217501051,0.60286417412994109]
[1.1000000000000001,0.99998315219502987,0.99979862173029221,0.99878627126964548,0.99507933966918161,0.98489146482421774,0.96248200180858456,0.92139607921651168,0.85682451195301157,0.76802828381124943,0.65949222228664184]
[1.1499999999999999,0.99998977724333848,0.99987272009838946,0.99920139555310461,0.99663173143460171,0.98924916792414941,0.97227354228618168,0.93973709958832274,0.88627906699841308,0.80942431084146971,0.71121294372957666]
[1.1999999999999997,0.99999379712942149,0.99991968214362503,0.99947618232444457,0.99770493755298795,0.99239546744002771,0.97965695072195447,0.95418145434451107,0.91050614800675089,0.84498617844426283,0.75761830702394195]
[1.2499999999999996,0.99999623627904999,0.99994939168353525,0.99965741542744457,0.99844284701121921,0.99465071527372484,0.98517426114398343,0.96543397161915367,0.93018223051694782,0.87509624908062378,0.79858080584483204]
[1.2999999999999994,0.99999771628390277,0.99996815539227479,0.9997765477037921,0.99894768291359348,0.99625651869248921,0.98926289135945344,0.97411270818137752,0.94597675510597989,0.90025242626087387,0.83420018155814391]
[1.3499999999999992,0.99999861430768056,0.99997998774826236,0.99985461752344928,0.99929147182138289,0.99739288240180624,0.99226956950181422,0.98074484178148547,0.95851957965416734,0.92101252146002321,0.86474723991295122]
[1.399999999999999,0.99999915920231663,0.99998743855478145,0.99990563252862641,0.99952459025203366,0.99819247245287879,0.99446491319014529,0.98576985722437427,0.96838128591811545,0.93795053425500641,0.89061040550867998]
[1.4499999999999988,0.99999948982848896,0.99999212409045002,0.99993888028019295,0.99968203826952395,0.99875212614592945,0.99605728972413565,0.98954709591265411,0.97606350242894846,0.95162461325485048,0.91224861816857894]
[1.4999999999999987,0.99999969044280712,0.9999950670134885,0.99996049529852038,0.99978798622741905,0.99914191725485002,0.99720521857278221,0.99236549420152165,0.98199653236039108,0.96255545659520902,0.9301524320757415]
[1.5499999999999985,0.99999981216972411,0.99999691329559492,0.99997451534219828,0.99985903390050235,0.99941215609430478,0.99802800771888278,0.99445399859700778,0.98654193119733835,0.97121340301583514,0.9448138354293818]
[1.5999999999999983,0.99999988603006695,0.99999807033740007,0.99998358953675248,0.99990652428661142,0.99959870632304515,0.99861458827374605,0.99599168203715249,0.98999812941686705,0.97801232048557529,0.95670437589299451]
[1.6499999999999981,0.99999993084636873,0.99999879470859887,0.99998945078672852,0.99993817239397398,0.99972696678124651,0.999030669683174,0.99711699226767092,0.99260765174018462,0.98330849272403187,0.96626060926646573]
[1.699999999999998,0.99999995803959352,0.99999924777417271,0.99999322954400072,0.99995920318671849,0.99981481742451572,0.99932441654291371,0.99793585423285291,0.99456489606387244,0.98740293182318983,0.97387561277612922]
[1.7499999999999978,0.99999997453964917,0.99999953089576843,0.99999566137172913,0.99997314123696102,0.99987477569017658,0.9995308753575376,0.99852854406317459,0.99602377823714949,0.99054583116873485,0.97989524110343396]
[1.7999999999999976,0.99999998455140171,0.99999970767008683,0.99999722374924871,0.99998235534469826,0.99991556004836779,0.99967537591629752,0.99895537449275762,0.99710481756590597,0.99294216546052116,0.98461788018593244]
[1.8499999999999974,0.99999999062624112,0.99999981795597093,0.99999822593710175,0.99998843207952015,0.99994321416396847,0.99977611150290624,0.99926130028563054,0.997901436997508,0.99475771273031988,0.9882966111396021]
[1.8999999999999972,0.99999999431227649,0.99999988670933648,0.99999886782558478,0.99999243068858357,0.99996190901560456,0.99984607423772787,0.99947958406266479,0.99848539137337256,0.99612500111098945,0.99114288930941419]
[1.9499999999999971,0.9999999965488553,0.99999992954036321,0.99999927836201197,0.99999505624150264,0.99997451129278314,0.99989449224445281,0.9996346707271494,0.99891132873736399,0.99714886558858906,0.99333104033765063]
[1.9999999999999969,0.99999999790594607,0.99999995620461424,0.99999954057681406,0.99999677673611931,0.99998298364792559,0.99992788732592142,0.99974441203618192,0.99922054497109725,0.99791143858791809,0.99500305688599711]
[2.0499999999999967,0.99999999872938916,0.99999997279365849,0.99999970784195658,0.99999790199007399,0.99998866492548266,0.99995084705910031,0.99982176846665716,0.99944402110825059,0.99847649818143036,0.99627333597718593]
[2.0999999999999965,0.99999999922903038,0.99999998310815519,0.99999981440917174,0.99999863659396226,0.99999246532200203,0.99996658427080742,0.99987609785196219,0.99960484383807202,0.99889316570831233,0.99723312402579034]
[2.1499999999999964,0.99999999953219809,0.99999998951762414,0.99999988222592173,0.99999911533337993,0.99999500163766375,0.99997733971618252,0.99991412212334874,0.99972010935183486,0.99919898758650316,0.99795453492446407]
[2.1999999999999962,0.9999999997161515,0.99999999349828494,0.99999992533502635,0.99999942680870302,0.99999669058496898,0.99998467011005787,0.99994064649611136,0.9998024035381653,0.99942246046008054,0.9984940789223935]
[2.249999999999996,0.99999999982776899,0.99999999596920308,0.99999995270923625,0.99999962913829166,0.99999781289027967,0.99998965297551923,0.99995909040749886,0.99986094091247857,0.99958506995712104,0.99889569053262106]
[2.2999999999999958,0.99999999989549526,0.99999999750220192,0.99999997007425179,0.99999976036948057,0.99999855715744446,0.99999303156125863,0.99997187673457877,0.99990243278604785,0.99970291558040114,0.99919327669559022]
[2.3499999999999956,0.99999999993658961,0.99999999845283982,0.99999998107922117,0.99999984536289122,0.99999904977259413,0.99999531685656362,0.9999807152774437,0.99993174342759716,0.99978799093451787,0.99941282604031267]
[2.3999999999999955,0.99999999996152444,0.99999999904207315,0.999999988047098,0.99999990033352826,0.99999937522196458,0.99999685907514768,0.99998680799665196,0.99995238213792648,0.99984918203350548,0.99957412993903949]
[2.4499999999999953,0.99999999997665412,0.99999999940713513,0.99999999245494808,0.9999999358392806,0.99999958985143178,0.99999789752993129,0.99999099677598224,0.99996686963339665,0.99989303852403222,0.99969216913250625]
[2.4999999999999951,0.99999999998583444,0.99999999963321451,0.99999999524096406,0.99999995874335168,0.99999973115623386,0.99999859529074331,0.99999386925424716,0.99997700904098519,0.99992436441881294,0.99977821836014957]

{"sheet":"解析解","index":1,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["槽列モデル　ステップ入力解析解　Levenspiel p. 327"]
["N=",10]
["θ","F",null,"N-1",1,2,3,4,5,6,7,8,9]
[0,{"$f":"1-EXP(-$B$2*A4)*(1+SUM(E4:M4))","v":0},null,null,{"$f":"$B$2*A4","v":0},{"$f":"($B$2*A4)^$F$3/FACT($F$3)","v":0},{"$f":"($B$2*A4)^$G$3/FACT($G$3)","v":0},{"$f":"($B$2*A4)^$H$3/FACT($H$3)","v":0},{"$f":"($B$2*A4)^$I$3/FACT($I$3)","v":0},{"$f":"($B$2*A4)^$J$3/FACT($J$3)","v":0},{"$f":"($B$2*A4)^$K$3/FACT($K$3)","v":0},{"$f":"($B$2*A4)^$L$3/FACT($L$3)","v":0},{"$f":"($B$2*A4)^$M$3/FACT($M$3)","v":0}]
[0.19354838709677419,{"$f":"1-EXP(-$B$2*A5)*(1+SUM(E5:M5))","v":3.5487109884213552E-5},null,null,{"$f":"$B$2*A5","v":1.935483870967742},{"$f":"($B$2*A5)^$F$3/FACT($F$3)","v":1.8730489073881376},{"$f":"($B$2*A5)^$G$3/FACT($G$3)","v":1.2084186499278307},{"$f":"($B$2*A5)^$H$3/FACT($H$3)","v":0.58471870157798267},{"$f":"($B$2*A5)^$I$3/FACT($I$3)","v":0.22634272319147716},{"$f":"($B$2*A5)^$J$3/FACT($J$3)","v":7.301378167467007E-2},{"$f":"($B$2*A5)^$K$3/FACT($K$3)","v":2.0188142398526284E-2},{"$f":"($B$2*A5)^$L$3/FACT($L$3)","v":4.8842279996434562E-3},{"$f":"($B$2*A5)^$M$3/FACT($M$3)","v":1.0503716128265497E-3}]
[0.38709677419354838,6.5579581109276308E-3,null,null,3.870967741935484,7.4921956295525503,9.6673491994226453,9.3554992252477227,7.2429671421272692,4.6728820271788845,2.5840822270113644,1.2503623679087248,0.53779026576719346]
[0.58064516129032262,7.1244457468756295E-2,null,null,5.806451612903226,16.857440166493237,32.62730354805143,47.362214827816587,55.001281735528941,53.227046840834461,44.151467425576975,32.045419905660701,20.674464455264971]
[0.77419354838709675,0.25191634768348492,null,null,7.741935483870968,29.968782518210201,77.338793595381162,149.68798760396356,231.77494854807262,299.06444973944861,330.76252505745464,320.09276618463355,275.34861607280305]
[0.967741935483871,0.50111972350336553,null,null,9.67741935483871,46.826222684703438,151.05233124097884,365.44918848623917,707.32100997336613,1140.8403386667198,1577.1986248848661,1907.9015623607256,2051.5070563018553]
[1.1612903225806452,0.72215652758949722,null,null,11.612903225806452,67.42976066597295,261.01842838441144,757.79543724506539,1760.0410155369261,3406.5309978134055,5651.3878304738528,8203.6274958491395,10585.325801095665]
[1.3548387096774193,0.86743678347567532,null,null,13.548387096774192,91.77939646201871,414.48759692524573,1403.9096024887356,3804.1421486791537,8589.9984002432502,16625.803355309512,28156.602456572564,42386.283267958694]
[1.5483870967741935,0.94438224171555873,null,null,15.483870967741936,119.8751300728408,618.7103487630493,2395.007801663417,7416.7983535383237,19140.124783324711,42337.603207354194,81943.748143266188,140978.49142927516]
[1.7419354838709677,0.97901968460697597,null,null,17.419354838709676,151.7169614984391,880.9371957973882,3836.3394010531424,13365.311461733527,38802.517146968305,96559.259259736777,210250.00000103973,406935.48387298011]
[1.935483870967742,0.99275624047961641,null,null,19.35483870967742,187.30489073881375,1208.4186499278308,5847.1870157798267,22634.272319147716,73013.78167467007,201881.42398526287,488422.79996434576,1050371.6128265499]
[2.129032258064516,0.99767829553847687,null,null,21.29032258064516,226.63891779396459,1608.4052230539421,8560.8665098032398,36452.721912710571,129348.36807736008,393409.78309243149,1046977.6485524386,2476721.3191563063]