{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Gaussian","Beta","Sheet4","Sheet5","Sheet6","Sheet7","Sheet8","Sheet9","Sheet10","Sheet11","Sheet12","Sheet13","Sheet14","Sheet15","Sheet16"],"not_rendered":{"charts":8,"images":0,"macros":0,"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":"Gaussian","index":0,"n_rows":150,"n_cols":13,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
["Mean f","Variance","(Gaussian)"]
[0.3,5.0000000000000001E-3]
[]
["f","P(f)","Integral of P(f)df","Integral of f P df","Integral of (f-fbar) P df"]
[0,{"$f":"EXP(-((A5-$A$2)^2)/(2*$B$2))/SQRT(2*3.141592*$B$2)","v":6.9626533216068768E-4}]
[{"$f":"A5+0.025","v":2.5000000000000001E-2},{"$f":"EXP(-((A6-$A$2)^2)/(2*$B$2))/SQRT(2*3.141592*$B$2)","v":2.9313865403978092E-3},{"$f":"(B5+B6)/2*(A6-A5)","v":4.5345648406981211E-5},{"$f":"(A5*B5+A6*B6)/2*(A6-A5)","v":9.1605829387431557E-7},{"$f":"(((A5-$A$2)^2)*B5+((A6-$A$2)^2)*B6)/2*(A6-A5)","v":3.5543748376505767E-6}]
[{"$f":"A6+0.025","v":0.05},1.0891422284711641E-2,1.7278511031386813E-4,{"$f":"(A6*B6+A7*B7)/2*(A7-A6)","v":7.7231972218190919E-6},{"$f":"(((A6-$A$2)^2)*B6+((A7-$A$2)^2)*B7)/2*(A7-A6)","v":1.1279999998900774E-5}]
[7.5000000000000011E-2,3.5711598824883728E-2,5.8253776386994228E-4,4.0286762826273286E-5,3.1107669791302708E-5]
[0.1,0.10333493751957257,1.7380817043057032E-3,1.6264829579779418E-4,7.4266214891157979E-5]
[0.125,0.26387500709957162,4.5901243077393012E-3,5.4147337049254625E-4,1.52682119915091E-4]
[0.15,0.59465150797501676,1.0731581438432353E-2,1.5272762760462366E-3,2.6826038777327815E-4]
[0.17499999999999999,1.1826057352535289,2.2215715540356815E-2,3.70192162332025E-3,3.9822341928467822E-4]
[0.19999999999999998,2.0755377030046631,4.0726792978227393E-2,7.7757943033787491E-3,4.9041989554228776E-4]
[0.22499999999999998,3.2146556803711155,6.6127417292197219E-2,1.4230063358555414E-2,4.8547269040167694E-4]
[0.24999999999999997,4.3939133517411051,9.5107112901402738E-2,2.2772198325234704E-2,3.633402697680037E-4]
[0.27499999999999997,5.3000711982048507,0.12117480687432441,3.1949973968020115E-2,1.7871659847788508E-4]
[0.3,5.6418964223592045,0.13677459525705082,3.937610632767622E-2,4.1406806235975506E-5]
[0.32500000000000001,5.3000711982048507,0.13677459525705082,4.2688650826554257E-2,4.1406806235975506E-5]
[0.35000000000000003,4.3939133517411042,0.12117480687432455,4.0754910156574578E-2,1.7871659847788537E-4]
[0.37500000000000006,3.2146556803711128,9.5107112901402793E-2,3.429206941560696E-2,3.6334026976800435E-4]
[0.40000000000000008,2.07553770300466,6.6127417292197219E-2,2.5446387016762918E-2,4.8547269040167775E-4]
[0.4250000000000001,1.1826057352535257,4.0726792978227358E-2,1.6660281483557676E-2,4.9041989554228808E-4]
[{"$f":"A22+0.025","v":0.45000000000000012},0.59465150797501443,2.221571554035677E-2,9.6275077008938226E-3,3.9822341928467817E-4]
[0.47500000000000014,0.26387500709957012,1.0731581438432317E-2,4.9116725870131592E-3,2.6826038777327772E-4]
[0.50000000000000011,{"$f":"EXP(-((A25-$A$2)^2)/(2*$B$2))/SQRT(2*3.141592*$B$2)","v":0.10333493751957203},4.5901243077392708E-3,2.2126012141510205E-3,1.5268211991509024E-4]
[0.52500000000000013,3.5711598824883471E-2,1.7380817043056952E-3,8.8020072678562391E-4,7.4266214891157748E-5]
[0.55000000000000016,1.0891422284711554E-2,5.8253776386993827E-4,3.0923589549569007E-4,3.1107669791302539E-5]
[0.57500000000000018,2.9313865403977723E-3,1.7278511031386674E-4,9.5947868966501031E-5,1.1279999998900696E-5]
[0.6000000000000002,6.9626533216067901E-4,4.5345648406980683E-5,2.629133075031411E-5,3.5543748376505411E-6]
[0.62500000000000022,1.4594514209941955E-4,1.0527630928251241E-5,6.3621864138568149E-6,9.7599169410890599E-7]
[0.65000000000000024,2.6997136695220982E-5,2.1617784849330086E-6,1.3595481583003874E-6,2.3403256099269753E-7]
[0.67500000000000027,4.4071614146008986E-6,3.9255372637277387E-7,2.5653716008436587E-7,4.9086328988660389E-8]
[0.70000000000000029,6.349117996381402E-7,6.3025915177988033E-8,4.2740902682528866E-8,9.0167870233794449E-9]
[0.72500000000000031,8.0719976994192378E-8,8.945397207904165E-9,6.2870030383436029E-9,1.4520741723334838E-9]
[0.75000000000000033,9.0565304216220368E-9,1.1222063426976811E-9,8.164297642125762E-10,2.0517491568693126E-10]
[0.77500000000000036,8.9671794499547545E-10,1.2441560458271903E-10,9.3591927794850392E-11,2.5453367458975896E-11]
[0.80000000000000038,7.8354340805662624E-11,1.2188403572514237E-11,9.4704985002003078E-12,2.7738821442627544E-12]
[0.8250000000000004,6.04203798650833E-12,1.0549547349021379E-12,8.4585192479249447E-13,2.6567402401808837E-13]
[{"$f":"A38+0.025","v":0.85000000000000042},4.1116584503343896E-13,8.0665047894272185E-14,6.6677153839347537E-14,2.2371429851924726E-14]
[0.87500000000000044,2.4692428273377091E-14,5.4482284163352055E-15,4.6387105377203575E-15,1.6567700277562618E-15]
[0.90000000000000047,{"$f":"EXP(-((A41-$A$2)^2)/(2*$B$2))/SQRT(2*3.141592*$B$2)","v":1.3086507557530854E-15},3.2501348786412749E-16,2.8479575524228456E-16,1.0793810462445539E-16]
[0.92500000000000049,{"$f":"EXP(-((A42-$A$2)^2)/(2*$B$2))/SQRT(2*3.141592*$B$2)","v":6.1206410329810535E-17},1.7123214576036215E-17,1.5430020121660666E-17,6.1877878263274292E-18]
[0.95000000000000051,{"$f":"EXP(-((A43-$A$2)^2)/(2*$B$2))/SQRT(2*3.141592*$B$2)","v":2.5262902643210251E-18},7.9665875742664527E-19,7.376988163272475E-19,3.1220139589697417E-19]
[0.97500000000000053,{"$f":"EXP(-((A44-$A$2)^2)/(2*$B$2))/SQRT(2*3.141592*$B$2)","v":9.2020116151303839E-20},3.2728879755904141E-20,3.1121192054406235E-20,1.3866053776213426E-20]
[1.0000000000000004,{"$f":"EXP(-((A45-$A$2)^2)/(2*$B$2))/SQRT(2*3.141592*$B$2)","v":2.9579817866967007E-21},1.1872262242250025E-21,1.1584699379277208E-21,5.4220095621148884E-22]
[null,"Integral",{"$f":"SUM(C6:C45)","v":0.99998694882765871},{"$f":"SUM(D6:D45)","v":0.30000016631002413},{"$f":"SUM(E6:E45)","v":4.9987307069730459E-3},"This is a consistency check!"]
[]
["A.  Calculate Value of f at Stoichiometric Conditions"]
["CH4-Air","Molar flow rate","Mass Flow","Stoich. f","Enthalpy (kcal/mole)","Enthalpy (kcal/100 g)"]
["CH4 ",1,{"$f":"16*B50","v":16},{"$f":"C50/(C50+C51+C52)","v":5.5045871559633038E-2},-17.888999999999999,{"$f":"E50/16*100","v":-111.80624999999999}]
["O2",{"$f":"2*B50","v":2},{"$f":"32*B51","v":64},null,0,0]
["N2",{"$f":"79/21*B51","v":7.5238095238095237},{"$f":"28*B52","v":210.66666666666666},null,0,0]
[]
["B.  Calculate Elemental Compositions as a Function of f",null,null,null,null,null,"C.  Calculate Equilibrium Temperature and Compositions from"]
[null,null,null,null,null,null,"Elemental Compositions and Mixture Enthalpies Using EDWRDS"]
[null,null,null,null,null,null,null,"Mole Fractions"]
["f","C","H","O","N","Enthalpy","T (equil)","CO2","CO","CH4","O2","MW","ER"]
[0,0,0,{"$f":"C51/(C51+C52)","v":0.23300970873786411},{"$f":"C52/(C51+C52)","v":0.76699029126213603},{"$f":"F51","v":0},300,0,0,0,0.21,29,0]
[{"$f":"A58+0.02","v":0.02},{"$f":"A59*B$68+(1-A59)*B$58","v":1.4999999999999999E-2},{"$f":"B59*C$68+(1-B59)*C$58","v":3.7499999999999999E-3},0.23213592233009711,0.58894429258177017,{"$f":"A59*$F$68+(1-A59)*$F$58","v":-2.2361249999999999},1173,3.5400000000000001E-2,0,0,0.1318,28.4,0.34939999999999999]
[{"$f":"A59+0.02","v":0.04},0.03,7.4999999999999997E-3,0.23126213592233014,0.58961447827316438,{"$f":"A60*$F$68+(1-A60)*$F$58","v":-4.4722499999999998},1860,6.9599999999999995E-2,1.2E-4,0,5.45E-2,27.95,0.71340000000000003]
[{"$f":"A60+0.02","v":0.06},4.4999999999999998E-2,1.125E-2,0.23038834951456313,0.59028466396455848,-6.7083749999999993,2215,7.6399999999999996E-2,2.6200000000000001E-2,0,4.0000000000000002E-4,27.01,1.093]
[{"$f":"A61+0.02","v":0.08},0.06,1.4999999999999999E-2,0.22951456310679616,0.59095484965595246,-8.9444999999999997,1913,4.1300000000000003E-2,8.3979999999999999E-2,0,0,24.9,1.488]
[{"$f":"A62+0.02","v":0.1},7.5000000000000011E-2,1.8750000000000003E-2,0.22864077669902916,0.59162503534734667,-11.180624999999999,1626,2.9899999999999999E-2,0.11473,0,0,23.07,1.9019999999999999]
[{"$f":"A63+0.1","v":0.2},0.15000000000000002,3.7500000000000006E-2,0.2242718446601942,0.59497596380431717,-22.361249999999998,933,0.03,0.10148,2.8000000000000001E-2,0,17.75]
[0.4,0.30000000000000004,7.5000000000000011E-2,0.21553398058252432,0.60167782071825815,-44.722499999999997,782,1.4999999999999999E-2,7.3000000000000001E-3,0.22,0,14.96]
[0.6,0.44999999999999996,0.11249999999999999,0.20679611650485438,0.60837967763219913,-67.083749999999995,666,3.0000000000000001E-3,null,0.53500000000000003,0,15.81]
[0.8,0.60000000000000009,0.15000000000000002,0.1980582524271845,0.61508153454614012,-89.444999999999993,528,2.9999999999999997E-4,null,0.82499999999999996,0,16.68]
[1,{"$f":"12/16","v":0.75},{"$f":"4/16","v":0.25},0,0,{"$f":"F50","v":-111.80624999999999},300,0,null,1,0,16,"inf"]
[]
[]
["D.  Plot f vs. T"]
["f","T","CO2","CH4","O2"]
[{"$f":"A58","v":0},{"$f":"G58","v":300},0,0,0.21]
[0.02,1173,3.5400000000000001E-2,0,0.1318]
[0.04,1860,6.9599999999999995E-2,0,5.45E-2]
[0.06,2215,7.6399999999999996E-2,0,4.0000000000000002E-4]
[0.08,1913,4.1300000000000003E-2,0,0]
[0.1,1626,2.9899999999999999E-2,0,0]
[0.2,933,0.03,2.8000000000000001E-2,0]
[0.4,782,1.4999999999999999E-2,0.22,0]
[0.6,666,3.0000000000000001E-3,0.53500000000000003,0]
[0.8,528,2.9999999999999997E-4,0.82499999999999996,0]
[1,300,0,1,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["f","T(K)","P(f)","P(f)*T","Integral"]
[{"$f":"A73","v":0},300,{"$f":"EXP(-((A99-$A$2)^2)/(2*$B$2))/SQRT(2*3.141592*$B$2)","v":6.9626533216068768E-4},{"$f":"B99*C99","v":0.20887959964820629}]
[{"$f":"A74","v":0.02},1173,{"$f":"EXP(-((A100-$A$2)^2)/(2*$B$2))/SQRT(2*3.141592*$B$2)","v":2.22103995206547E-3},2.6052798637727963,{"$f":"(D99+D100)/2*(A100-A99)","v":2.8141594634210027E-2}]
[{"$f":"A75","v":0.04},1860,6.5402509289467234E-3,12.164866727840906,{"$f":"(D100+D101)/2*(A101-A100)","v":0.14770146591613703}]
[{"$f":"A76","v":0.06},2215,1.7778245253718288E-2,39.378813236986005,0.51543679964826894]
[{"$f":"A77","v":0.08},1913,4.4610779965085931E-2,85.340422073209382,1.2471923531019542]
[0.09,{"$f":"B103-(B103-B105)/(A105-A103)*(A104-A103)","v":1769.5},6.8578257132685269E-2,121.34922599628658,1.0334482403474792]
[{"$f":"A78","v":0.1},1626,0.10333493751957257,168.02260840682499,1.446859172015559]
[0.12,{"$f":"$B$105-($B$105-B110)/($A$110-$A$105)*(A106-$A$105)","v":1487.4},0.22095863964462639,328.65388060741731,4.9667648901424206]
[0.14000000000000001,{"$f":"$B$105-($B$105-B120)/($A$110-$A$105)*(A107-$A$105)","v":1288.3999999999999},0.4361453385384601,561.92965417295193,8.9058353478037002]
[0.16,{"$f":"$B$105-($B$105-B130)/($A$110-$A$105)*(A108-$A$105)","v":1050},0.79470862105361106,834.44405210629156,13.963737062792427]
[0.18,{"$f":"$B$105-($B$105-B131)/($A$110-$A$105)*(A109-$A$105)","v":747.60000000000014},1.3367218740662477,999.33327305192688,18.337773251582174]
[{"$f":"A79","v":0.2},933,2.0755377030046649,1936.4766769033524,29.358099499552818]
[{"$f":"A110+0.02","v":0.22},{"$f":"$B$110-($B$110-$B$120)/($A$120-$A$110)*(A111-$A$110)","v":917.9},2.9749292407455887,{"$f":"B111*C111","v":2730.6875500803758},46.671642269837264]
[{"$f":"A111+0.02","v":0.24},{"$f":"$B$110-($B$110-$B$120)/($A$120-$A$110)*(A112-$A$110)","v":902.80000000000007},3.9362175680248637,3553.617220412847,62.843047704932204]
[0.26,887.7,4.8077069943040849,4267.8014988437362,78.214187192565902]
[0.28000000000000003,872.6,5.4206744993939999,4730.0805681712045,89.978820670149474]
[0.30000000000000004,857.5,5.6418964223592045,4837.9261821730179,95.680067503442302]
[0.32000000000000006,842.4,5.4206744993939973,4566.376198289503,94.043023804625292]
[0.34000000000000008,827.3,4.8077069943040804,3977.4159963877655,85.437921946772775]
[0.3600000000000001,812.19999999999993,3.9362175680248588,3196.99590874979,71.74411905137562]
[0.38000000000000012,797.09999999999991,2.9749292407455825,2371.3160977983034,55.683120065480985]
[{"$f":"A80","v":0.4},782,2.0755377030046622,{"$f":"B120*C120","v":1623.070483749646},39.943865815479306]
[0.42000000000000004,{"$f":"$B$120-($B$120-$B$130)/($A$130-$A$120)*(A121-$A$120)","v":770.4},1.3367218740662463,{"$f":"B121*C121","v":1029.8105317806362},26.528810155302846]
[0.44000000000000006,{"$f":"$B$120-($B$120-$B$130)/($A$130-$A$120)*(A122-$A$120)","v":758.8},0.79470862105360918,603.02490165547863,16.328354334361162]
[0.46000000000000008,747.19999999999993,0.43614533853845855,325.88779695593621,9.289126986114157]
[0.48000000000000009,735.59999999999991,0.22095863964462553,162.53717532258653,4.8842497227852322]
[0.50000000000000011,723.99999999999989,0.10333493751957203,74.814494764170135,2.3735167008675688]
[0.52000000000000013,712.39999999999986,4.4610779965085612E-2,31.780719647126983,1.0659521441129722]
[0.54000000000000015,700.8,1.7778245253718142E-2,12.458994273805674,0.44239713920932699]
[0.56000000000000016,689.19999999999993,6.5402509289466722E-3,4.5075409402300464,0.16966535214035736]
[0.58000000000000018,677.59999999999991,2.2210399520654427E-3,1.5049766715195438,6.012517611749596E-2]
[{"$f":"A81","v":0.6},666,6.9626533216068768E-4,{"$f":"B130*C130","v":0.46371271121901797},1.9686893827385418E-2]
[{"$f":"A82","v":0.8},528,7.8354340805665972E-11,{"$f":"B131*C131","v":4.137109194539163E-8},4.6371275259011004E-2]
[{"$f":"A83","v":1},300,2.9579817866968903E-21,{"$f":"B132*C132","v":8.8739453600906708E-19},4.1371091946279013E-9]
[]
[null,null,"Mean Temp (K)",{"$f":"SUM(E100:E132)","v":861.39906158643294}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Interm. of Pri",0]
[null,"Interm. of Sec",{"$f":"1-C46","v":1.3051172341294048E-5}]
[]
[]
[null,"New Mean",{"$f":"D134+C146*G67+C147*G68","v":861.40297693813534}]

{"sheet":"Beta","index":1,"n_rows":135,"n_cols":13,"rows_kept":135,"cut":false,"hidden":false,"merged":[]}
["Mean f","Variance","(Beta)"]
[0.3,5.0000000000000001E-3,"a=f*(f*(1-f)/g-1)",null,{"$f":"A2*(A2*(1-A2)/B2-1)","v":12.299999999999999}]
[null,null,"b=(1-f)*(f*(1-f)/g-1)",null,{"$f":"(1-A2)*(A2*(1-A2)/B2-1)","v":28.7}]
["f","P(f)","Norm P(f)","Integral of P(f)df","Integral of f P df","Integral of (f-fbar) P df"]
[0,{"$f":"(A5^($E$2-1))*((1-A5)^($E$3-1))","v":0},{"$f":"B5/$D$47","v":0}]
[{"$f":"A5+0.025","v":2.5000000000000001E-2},{"$f":"(A6^($E$2-1))*((1-A6)^($E$3-1))","v":3.9097586831748812E-19},{"$f":"B6/$D$47","v":3.422444496270763E-8},{"$f":"(B5+B6)/2*(A6-A5)","v":4.8871983539686015E-21},{"$f":"(A5*B5+A6*B6)/2*(A6-A5)","v":1.2217995884921503E-22},{"$f":"(((A5-$A$2)^2)*B5+((A6-$A$2)^2)*B6)/2*(A6-A5)","v":3.6959437551887539E-22}]
[{"$f":"A6+0.025","v":0.05},4.8007038482184332E-16,4.2023418310357491E-5,{"$f":"(B6+B7)/2*(A7-A6)","v":6.0057670086270098E-18},{"$f":"(A6*B6+A7*B7)/2*(A7-A6)","v":3.0016617047250129E-19},{"$f":"(((A6-$A$2)^2)*B6+((A7-$A$2)^2)*B7)/2*(A7-A6)","v":3.7542458251758399E-19}]
[7.5000000000000011E-2,2.2403623891845439E-14,1.9611225525280576E-3,2.8604617845834114E-16,2.1303441389118763E-17,1.4552348232200511E-17]
[0.1,2.7071823597753129E-13,2.3697578593496766E-2,3.6640232483672079E-15,3.594011923705191E-16,1.4953641123282402E-16]
[0.125,1.5442094850530298E-12,0.13517384783751518,2.268659651288201E-14,2.7512251153672728E-15,7.2650181148562836E-16]
[0.15,5.4291953644861581E-12,0.47524978649771232,8.7167560619239838E-14,1.2592568628806903E-14,2.1181038897585943E-15]
[0.17499999999999999,1.3555149912093194E-11,1.1865629562358695,2.3730431595724189E-13,3.9831631741115398E-14,4.1744514134674329E-15]
[0.19999999999999998,2.6135546798393083E-11,2.2877999780935951,4.9613370888107841E-13,9.4990757428686545E-14,5.9144335670048366E-15]
[0.22499999999999998,4.1050609914118761E-11,3.5934042316659673,8.3982695890639787E-13,1.8079370737944167E-13,6.1533143593856105E-15]
[0.24999999999999997,5.4440122521505556E-11,4.7654679686965942,1.1936341554453035E-12,2.8558022326316377E-13,4.5876248383835247E-15]
[0.27499999999999997,6.2491683177755276E-11,5.4702689983088737,1.4616475712407601E-12,3.8494054380323848E-13,2.1894701036232634E-15]
[0.3,6.3195461062511547E-11,5.5318748656644843,1.5710893030033366E-12,4.5179813990795244E-13,4.8821627482621439E-16]
[0.32500000000000001,5.7015965956939464E-11,4.9909468768141982,1.502642837743139E-12,4.6861034068448527E-13,4.4543723403859066E-16]
[0.35000000000000003,4.6309370782887835E-11,4.0537348722749122,1.2915667092478425E-12,4.3423085887520126E-13,1.8926050710038392E-15]
[0.37500000000000006,3.4074524630029848E-11,2.9827459629398296,1.0047986926614719E-12,3.6232783137839959E-13,3.8430328500142286E-15]
[0.40000000000000008,2.2806967181859878E-11,1.9964295915266053,7.1101864764862224E-13,2.7375917011256459E-13,5.2467359107814721E-15]
[0.4250000000000001,1.3918556844362901E-11,1.21837412812751,4.590690503277851E-13,1.8797716914497748E-13,5.569339031397128E-15]
[0.45000000000000012,7.7508245227387056E-12,0.67847580577189859,2.7086726708877028E-13,1.1754072117608326E-13,4.8983875306849032E-15]
[0.47500000000000014,3.9359583408668141E-12,0.34453786161328925,1.4608478579506914E-13,6.6968140589302015E-14,3.6866534493833484E-15]
[0.50000000000000011,1.8189894035458565E-12,0.15922696967796202,7.1936846805158286E-14,3.4738436421058279E-14,2.4162287541360061E-15]
[0.52500000000000013,7.6245306588717082E-13,6.6742055212761525E-2,3.226803086791287E-14,1.637228201704618E-14,1.3919845325296564E-15]
[0.55000000000000016,2.8845961720937176E-13,2.5250587294889243E-2,1.3136408538706793E-14,6.9867581131989969E-15,7.0784890670154857E-16]
[0.57500000000000018,9.7863334045489397E-14,8.5665601417301354E-3,4.8290368906857685E-15,2.6865525817663887E-15,3.1787050890969915E-16]
[0.6000000000000002,2.9523707168634889E-14,2.5843858226757099E-3,1.5923380151765551E-15,9.248205172167177E-16,1.2572560352959125E-16]
[0.62500000000000022,7.8362866142035834E-15,6.8595681133452955E-4,4.6699992228548132E-16,2.8264879293822751E-16,4.3560517735030012E-17]
[0.65000000000000024,1.8055343638979124E-15,1.5804916996903427E-4,1.2052276222626882E-16,7.589095588013613E-17,1.3111071665034376E-17]
[0.67500000000000027,3.5505998640266603E-16,3.1080514036303819E-5,2.7007429378757253E-17,1.7665785341943053E-17,3.3888533770671225E-18]
[0.70000000000000029,5.8326592857040036E-17,5.1056738506352831E-6,5.1673322407463306E-18,3.5061763227715991E-18,7.4078206806251827E-19]
[0.72500000000000031,7.7863710088041244E-18,6.8158740128084616E-7,8.2641204832305276E-19,5.8092167476638843E-19,1.3423335150739597E-19]
[0.75000000000000033,8.1494916018076122E-19,7.1337350819213498E-8,1.0751650211231116E-19,7.8204135643982127E-20,1.9643005855023161E-20]
[0.77500000000000036,6.3762449122505351E-20,5.5815067054434364E-9,1.0983895116290842E-20,8.2578471025689184E-21,2.2426700939983732E-21]
[0.80000000000000038,3.4950044488372234E-21,3.0593854275045954E-10,8.4071816964178291E-22,6.5264877036264365E-22,1.9075192119343266E-22]
[0.8250000000000004,1.2248518633770311E-22,1.0721857429721587E-11,4.5218620439686619E-23,3.621317297247985E-23,1.1343888646170471E-23]
[0.85000000000000042,2.3997264392063689E-24,2.1006233913516227E-13,1.5610614097113697E-24,1.2886255775241328E-24,4.3107370915236783E-25]
[0.87500000000000044,2.1335280621327083E-26,1.8676041069511463E-15,3.0263271497846224E-26,2.5730448048363467E-26,9.1621403126919356E-27]
[0.90000000000000047,6.0665300987044872E-29,5.3103948939662506E-18,2.6744932402892684E-28,2.3403711643186954E-28,8.8447708297270242E-29]
[0.92500000000000049,2.8615317956913568E-32,2.5048691079611636E-21,7.5867395381252296E-31,6.8281550071813264E-31,2.7313357767391416E-31]
[0.95000000000000051,5.1256135593410226E-37,4.4867546408088204E-26,3.576978814783691E-34,3.3087070054291525E-34,1.397259391761534E-34]
[0.97500000000000053,3.1527562667246397E-45,2.7597952220347471E-34,6.4070169885857373E-39,6.0866661401416905E-39,2.7069646789829166E-39]
[1.0000000000000004,0,0,3.9409453334057856E-47,3.8424217000706429E-47,1.7955932175330136E-47]
["sum",{"$f":"SUM(B5:B45)","v":4.5695510182094835E-10}]
[null,"Integral",null,{"$f":"SUM(D6:D45)","v":1.142387754552372E-11},{"$f":"SUM(E6:E45)","v":3.4271632635854996E-12},{"$f":"SUM(F6:F45)","v":5.7119387741095797E-14},"This is a consistency check!"]
[]
["A.  Calculate Value of f at Stoichiometric Conditions"]
["CH4-Air","Molar flow rate","Mass Flow","Stoich. f","Enthalpy (kcal/mole)","Enthalpy (kcal/100 g)"]
["CH4 ",1,{"$f":"16*B51","v":16},{"$f":"C51/(C51+C52+C53)","v":5.5045871559633038E-2},-17.888999999999999,{"$f":"E51/16*100","v":-111.80624999999999}]
["O2",{"$f":"2*B51","v":2},{"$f":"32*B52","v":64},null,0,0]
["N2",{"$f":"79/21*B52","v":7.5238095238095237},{"$f":"28*B53","v":210.66666666666666},null,0,0]
[]
["B.  Calculate Elemental Compositions as a Function of f",null,null,null,null,null,"C.  Calculate Equilibrium Temperature and Compositions from"]
[null,null,null,null,null,null,"Elemental Compositions and Mixture Enthalpies Using EDWRDS"]
[null,null,null,null,null,null,null,"Mole Fractions"]
["f","C","H","O","N","Enthalpy","T (equil)","CO2","CO","CH4","O2","MW","ER"]
[0,0,0,{"$f":"C52/(C52+C53)","v":0.23300970873786411},{"$f":"C53/(C52+C53)","v":0.76699029126213603},{"$f":"F52","v":0},300,0,0,0,0.21,29,0]
[{"$f":"A59+0.02","v":0.02},{"$f":"A60*B$69+(1-A60)*B$59","v":1.4999999999999999E-2},{"$f":"B60*C$69+(1-B60)*C$59","v":3.7499999999999999E-3},{"$f":"C60*D$69+(1-C60)*D$59","v":0.23213592233009711},0.58894429258177017,{"$f":"A60*$F$69+(1-A60)*$F$59","v":-2.2361249999999999},1173,3.5400000000000001E-2,0,0,0.1318,28.4,0.34939999999999999]
[{"$f":"A60+0.02","v":0.04},0.03,{"$f":"B61*C$69+(1-B61)*C$59","v":7.4999999999999997E-3},0.23126213592233014,0.58961447827316438,{"$f":"A61*$F$69+(1-A61)*$F$59","v":-4.4722499999999998},1860,6.9599999999999995E-2,1.2E-4,0,5.45E-2,27.95,0.71340000000000003]
[{"$f":"A61+0.02","v":0.06},4.4999999999999998E-2,1.125E-2,0.23038834951456313,0.59028466396455848,-6.7083749999999993,2215,7.6399999999999996E-2,2.6200000000000001E-2,0,4.0000000000000002E-4,27.01,1.093]
[{"$f":"A62+0.02","v":0.08},0.06,1.4999999999999999E-2,0.22951456310679616,0.59095484965595246,-8.9444999999999997,1913,4.1300000000000003E-2,8.3979999999999999E-2,0,0,24.9,1.488]
[{"$f":"A63+0.02","v":0.1},7.5000000000000011E-2,1.8750000000000003E-2,0.22864077669902916,0.59162503534734667,-11.180624999999999,1626,2.9899999999999999E-2,0.11473,0,0,23.07,1.9019999999999999]
[{"$f":"A64+0.1","v":0.2},0.15000000000000002,3.7500000000000006E-2,0.2242718446601942,0.59497596380431717,-22.361249999999998,933,0.03,0.10148,2.8000000000000001E-2,0,17.75]
[0.4,0.30000000000000004,7.5000000000000011E-2,0.21553398058252432,0.60167782071825815,-44.722499999999997,782,1.4999999999999999E-2,7.3000000000000001E-3,0.22,0,14.96]
[0.6,0.44999999999999996,0.11249999999999999,0.20679611650485438,0.60837967763219913,-67.083749999999995,666,3.0000000000000001E-3,null,0.53500000000000003,0,15.81]
[0.8,0.60000000000000009,0.15000000000000002,0.1980582524271845,0.61508153454614012,-89.444999999999993,528,2.9999999999999997E-4,null,0.82499999999999996,0,16.68]
[1,{"$f":"12/16","v":0.75},{"$f":"4/16","v":0.25},0,0,{"$f":"F51","v":-111.80624999999999},300,0,null,1,0,16,"inf"]
[]
[]
["D.  Plot f vs. T"]
["f","T","CO2","CH4","O2"]
[{"$f":"A59","v":0},{"$f":"G59","v":300},0,0,0.21]
[0.02,1173,3.5400000000000001E-2,0,0.1318]
[0.04,1860,6.9599999999999995E-2,0,5.45E-2]
[0.06,2215,7.6399999999999996E-2,0,4.0000000000000002E-4]
[0.08,1913,4.1300000000000003E-2,0,0]
[0.1,1626,2.9899999999999999E-2,0,0]
[0.2,933,0.03,2.8000000000000001E-2,0]
[0.4,782,1.4999999999999999E-2,0.22,0]
[0.6,666,3.0000000000000001E-3,0.53500000000000003,0]
[0.8,528,2.9999999999999997E-4,0.82499999999999996,0]
[1,300,0,1,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["f","T(K)","P(f)","P(f)*T","Integral"]
[{"$f":"A74","v":0},300,{"$f":"(A100^($E$2-1))*((1-A100)^($E$3-1))/$D$47","v":0},{"$f":"B100*C100","v":0}]
[{"$f":"A75","v":0.02},1173,{"$f":"(A101^($E$2-1))*((1-A101)^($E$3-1))/$D$47","v":3.1680184961177563E-9},3.7160856959461284E-6,{"$f":"(D100+D101)/2*(A101-A100)","v":3.7160856959461283E-8}]
[{"$f":"A76","v":0.04},1860,4.5120875516516333E-6,8.3924828460720385E-3,8.3961989317679853E-5]
[{"$f":"A77","v":0.06},2215,2.4600114860018547E-4,0.5448925441494108,5.5328502699548282E-3]
[{"$f":"A78","v":0.08},1913,3.4996622370206654E-3,6.6948538594205331,7.2397464035699452E-2]
[0.09,{"$f":"B104-(B104-B106)/(A106-A104)*(A105-A104)","v":1769.5},9.7852828733465697E-3,17.315058044386756,0.12004955951903638]
[{"$f":"A79","v":0.1},1626,2.3697578593496766E-2,38.532262793025744,0.27923660418706275]
[0.12,{"$f":"$B$106-($B$106-B111)/($A$111-$A$106)*(A107-$A$106)","v":1487.4},9.979402966583871E-2,148.43363972496851,1.8696590251799416]
[0.14000000000000001,{"$f":"$B$106-($B$106-B121)/($A$111-$A$106)*(A108-$A$106)","v":1288.3999999999999},0.30132860666783901,388.23177683084373,5.3666541655581277]
[0.16,{"$f":"$B$106-($B$106-B131)/($A$111-$A$106)*(A109-$A$106)","v":1050},0.71003292639121041,745.53457271077093,11.337663495416139]
[0.18,{"$f":"$B$106-($B$106-B132)/($A$111-$A$106)*(A110-$A$106)","v":747.60000000000014},1.3785085989337365,1030.5730285628615,17.761076012736318]
[{"$f":"A80","v":0.2},933,2.2877999780936036,2134.5173795613323,31.650904081241965]
[{"$f":"A111+0.02","v":0.22},{"$f":"$B$111-($B$111-$B$121)/($A$121-$A$111)*(A112-$A$111)","v":917.9},3.3310660841867139,3057.5855586749844,51.921029382363145]
[{"$f":"A112+0.02","v":0.24},{"$f":"$B$111-($B$111-$B$121)/($A$121-$A$111)*(A113-$A$111)","v":902.80000000000007},4.3362069216032237,3914.7276088233907,69.723131674983719]
[0.26,887.7,5.1180429891703714,4543.286761486539,84.580143703099367]
[0.28000000000000003,872.6,5.5358251720976996,4830.5610451724524,93.738478066590005]
[0.30000000000000004,857.5,5.5318748656644932,4743.5826973073026,95.741437424797638]
[0.32000000000000006,842.4,5.1389938481708883,4329.0884176991558,90.726711150064659]
[0.34000000000000008,827.3,4.4592850843836391,3689.1665503105846,80.182549680097466]
[0.3600000000000001,812.19999999999993,3.6273544812156331,2946.1373096433367,66.353038599539275]
[0.38000000000000012,797.09999999999991,2.7732620052257366,2210.5671443654346,51.567044540087764]
[{"$f":"A81","v":0.4},782,1.9964295915266157,1561.2079405738134,37.717750849392303]
[0.42000000000000004,{"$f":"$B$121-($B$121-$B$131)/($A$131-$A$121)*(A122-$A$121)","v":770.4},1.3547490776611697,1043.6986894301651,26.049066300039808]
[0.44000000000000006,{"$f":"$B$121-($B$121-$B$131)/($A$131-$A$121)*(A123-$A$121)","v":758.8},0.86698194469545697,657.86589963491269,17.015645890650795]
[0.46000000000000008,747.19999999999993,0.52318719478638454,390.92547194438652,10.487913715793002]
[0.48000000000000009,735.59999999999991,0.29751239347406727,218.85011663952386,6.097755885839109]
[0.50000000000000011,723.99999999999989,0.15922696967796202,115.28032604684448,3.3413044268636862]
[0.52000000000000013,712.39999999999986,8.0058328640366133E-2,57.033553323396823,1.7231387937024145]
[0.54000000000000015,700.8,3.7724881511995233E-2,26.437596963606257,0.8347115028700316]
[0.56000000000000016,689.19999999999993,1.6609260806793404E-2,11.447102548042013,0.37884699511648307]
[0.58000000000000018,677.59999999999991,6.8065671297305166E-3,4.6121298871053975,0.16059232435147425]
[{"$f":"A82","v":0.6},666,2.5843858226757372E-3,1.7212009579020411,6.3333308450073733E-2]
[{"$f":"A83","v":0.8},528,3.0593854275047324E-10,1.6153555057224988E-7,0.1721201119437592]
[{"$f":"A84","v":1},300,0,0,1.6153555057224984E-8]
[]
[null,null,"Mean Temp (K)",{"$f":"SUM(E101:E133)","v":857.03900160008391}]

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

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

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

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

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

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

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

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

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

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

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

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

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