{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Production Economics","Oil Decline","Gas Decline"],"not_rendered":{"charts":7,"images":1,"macros":1,"external_links":1,"defined_names":108,"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":"Summary","index":0,"n_rows":66,"n_cols":4,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,1,1,3],[2,1,3,3]]}
[null,"The Domino Effect Multi-Commodity Production Economics Model"]
[]
[null,"Permian - Wolfcamp"]
[]
[]
[null,"Drilling and Completion Cost"]
[null,"Drilling"]
[null,"Rig and Mobilization",490,{"$f":"C8/$C$20","v":6.5333333333333327E-2}]
[null,"Location Prep/Build",465,{"$f":"C9/$C$20","v":6.2E-2}]
[null,"Casing",815,{"$f":"C10/$C$20","v":0.10866666666666666}]
[null,"Drilling, Cementing, Directional Services, Fuel, Mud",1650,{"$f":"C11/$C$20","v":0.22}]
[null,null,{"$f":"SUM(C8:C11)","v":3420},{"$f":"C12/$C$20","v":0.45600000000000002}]
[null,"Completion"]
[null,"Perforating, Flowback, Water, Tubing,  Surface Equipment",1200,{"$f":"C14/$C$20","v":0.16}]
[null,"Stimulation (Fracking)",2220,{"$f":"C15/$C$20","v":0.29599999999999999}]
[null,null,{"$f":"SUM(C14:C15)","v":3420},{"$f":"C16/$C$20","v":0.45600000000000002}]
[null,"Facilities"]
[null,"Labor, Communications, Insurance, Etc.",660,{"$f":"C18/$C$20","v":8.7999999999999995E-2}]
[]
[null,null,{"$f":"C12+C16+C18","v":7500},{"$f":"D12+D16+D18","v":1}]
[]
[]
[]
[null,"Production Economics "]
[null,"Discount Factor",{"$f":"'Production Economics'!E7","v":0.1}]
[null,"Payback (Yrs)",{"$f":"'Production Economics'!E8","v":1.614353163746101}]
[null,"Internal Rate of Return (Discounted)",{"$f":"'Production Economics'!E10","v":0.30579460845253337}]
[null,"Disc. Cash Flow",{"$f":"'Production Economics'!E11","v":10278.4180290819}]
[null,"Total EUR (BOE)",{"$f":"C36+C45+C52","v":1157997.7629049306},{"$f":"D36+D45+D52","v":1}]
[]
[null,"Oil/Condensate"]
[null,"Initial Daily Oil Production (Bbl/d)",{"$f":"'Production Economics'!L7","v":475}]
[null,"Oil Price ($/Bbl)",{"$f":"'Production Economics'!L8","v":70}]
[null,"Incremental Cost ($/Bbl)",{"$f":"'Production Economics'!L10","v":10}]
[null,"Oil Production Tax",{"$f":"'Production Economics'!L12","v":4.4999999999999998E-2}]
[null,"EUR Oil Production (BOE)",{"$f":"'Production Economics'!L43","v":696480.22955975484},{"$f":"C36/$C$29","v":0.60145213736214664}]
[]
[null,"Natural Gas"]
[null,"Initial Daily Gas Production (MCF)",{"$f":"'Production Economics'!X7","v":1100}]
[null,"Initial Daily Gas Flow After Shrinkage ",{"$f":"'Production Economics'!X8","v":838.2}]
[null,"Gas GPM Content",{"$f":"'Production Economics'!X9","v":6.5}]
[null,"Gas Price ($/Mcf)",{"$f":"'Production Economics'!X10","v":3.5}]
[null,"Oper. Cost ($/Mcf)",{"$f":"'Production Economics'!X11","v":1}]
[null,"Production Tax",{"$f":"'Production Economics'!X12","v":7.4999999999999997E-2}]
[null,"EUR Natural Gas Production (BOE)",{"$f":"'Production Economics'!X43/5.8","v":211901.85838946121},{"$f":"C45/$C$29","v":0.18298986852780125}]
[]
[null,"Natural Gas Liquids"]
[null,"Initial Daily NGL Production (Bbl)",{"$f":"'Production Economics'!AJ7","v":170.23809523809524}]
[null,"NGL Weighted Average Price ($/Bbl)",{"$f":"'Production Economics'!AJ8","v":28}]
[null,"NGL Oil Pirce Ratio",{"$f":"'Production Economics'!AJ9","v":0.4}]
[null,"Processing Cost ($/Mcf)",{"$f":"'Production Economics'!AJ11","v":0.3}]
[null,"EUR NGL Production (BOE)",{"$f":"'Production Economics'!AJ43","v":249615.67495571458},{"$f":"C52/$C$29","v":0.21555799411005214}]
[]
[]
[null,"Decline Curve (All Commodities)"]
[null,"Year 1",{"$f":"'Production Economics'!H18","v":0.55000000000000004}]
[null,"Year 2",{"$f":"'Production Economics'!H19","v":0.3}]
[null,"Year 3",{"$f":"'Production Economics'!H20","v":0.2}]
[null,"Year 4",{"$f":"'Production Economics'!H21","v":0.15}]
[null,"Year 5",{"$f":"'Production Economics'!H22","v":0.1}]
[null,"Year 6",{"$f":"'Production Economics'!H23","v":0.09}]
[null,"Year 7",{"$f":"'Production Economics'!H24","v":7.0000000000000007E-2}]
[null,"Year 8",{"$f":"'Production Economics'!H25","v":0.06}]
[null,"Year 9",{"$f":"'Production Economics'!H26","v":0.05}]
[null,"Year 10",{"$f":"'Production Economics'!H27","v":0.05}]
[null,"Steady State Decline Rate",{"$f":"'Production Economics'!H28","v":0.05}]

{"sheet":"Production Economics","index":1,"n_rows":43,"n_cols":42,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,3,2,4],[5,7,5,10],[3,3,3,4],[5,1,5,2],[5,3,5,4],[5,19,5,22],[5,31,5,34],[4,3,4,4],[6,19,6,22],[6,31,6,34],[6,7,6,10],[10,7,10,10],[7,19,7,22],[7,31,7,34],[7,7,7,10],[8,19,8,22],[8,31,8,34],[8,7,8,10],[0,2,1,4],[42,2,42,3],[42,19,42,22],[42,31,42,34],[42,7,42,10],[11,19,11,22],[11,31,11,34],[11,7,11,10],[14,20,14,22],[14,32,14,34],[14,8,14,10],[9,19,9,22],[9,31,9,34],[9,7,9,10],[10,19,10,22],[10,31,10,34]]}
[null,null,"The Domino Effect Multi-Commodity Production Economics Model"]
[]
[null,null,"Input Variables","in blue"]
[null,null,"Calculated Fields","in green"]
[]
[null,"Well Inputs",null,"Production Economics ",null,null,null,"Oil/Condensate Inputs",null,null,null,null,null,null,null,null,null,null,null,"Natural Gas Inputs",null,null,null,null,null,null,null,null,null,null,null,"Natural Gas Liquids Inputs"]
[null,"Basin","Wolfcamp Horizontal","Discount Factor",0.1,null,null,"Initial Daily Oil Production (Bbl/d)",null,null,null,475,null,null,null,null,null,null,null,"Initial Daily Gas Production (MCF)",null,null,null,1100,"Shrinkage Factor",{"$f":"IF(X9<1,0,0.035*X9+0.0105)","v":0.23800000000000004},null,null,null,null,null,"Initial Daily NGL Production (Bbl)",null,null,null,{"$f":"(X9*X7)/42","v":170.23809523809524}]
[null,"Drilling and Completion Cost",7500000,"Payback (Yrs)",{"$f":"MAX(A18:A42)","v":1.614353163746101},null,null,"Oil Price ($/Bbl)",null,null,null,70,null,null,null,null,null,null,null,"Initial Daily Gas Flow After Shrinkage ",null,null,null,{"$f":"X7*(1-Z7)","v":838.2},null,null,null,null,null,null,null,"NGL Weighted Average Price ($/Bbl)",null,null,null,{"$f":"AJ9*L8","v":28}]
[null,"Royalty Interest",0.25,"IRR",{"$f":"IRR(B17:B42)","v":0.43637406930567346},null,null,"Oil Price Escalation (%/yr)",null,null,null,0,null,null,null,null,null,null,null,"Gas GPM Content",null,null,null,6.5,null,null,null,null,null,null,null,"NGL Oil Price Ratio",null,null,null,0.4]
[null,"Well Spacing",30,"IRR (Discounted)",{"$f":"IRR(E17:E42)","v":0.30579460845253337},null,null,"Incremental Cost ($/Bbl)",null,null,null,10,null,null,null,null,null,null,null,"Gas Price ($/Mcf)",null,null,null,3.5,"Gas Price Esc.  (%/yr)",0,null,null,null,null,null,"NGL Price Escalation (%/Yr)",null,null,null,0]
[null,"Leasehold Costs ($/Acre)",0,"Disc. Cash Flow",{"$f":"SUM(E17:E42)","v":10278.4180290819},null,null,"Incremental Cost Esc. (%/yr)",null,null,null,0,null,null,null,null,null,null,null,"Oper. Cost ($/Mcf)",null,null,null,1,"Oper. Cost Esc. (%/yr)",0,null,null,null,null,null,"Processing Cost ($/Mcf)",null,null,null,0.3]
[null,null,null,null,null,null,null,"Oil Production Tax   (%)",null,null,null,4.4999999999999998E-2,null,null,null,null,null,null,null,"Production Tax   (%)",null,null,null,7.4999999999999997E-2,null,null,null,null,null,null,null,"NGL O&M Exp. Escalation (%/Yr)",null,null,null,0]
[]
["Payback","Annual","Cumulative","Discount","Discounted",null,null,null,null,null,null,"Gross Oil","Net Oil","Oil","Net","Incremental","Incremental","Before-Tax",null,null,null,null,null,"Gas Production","Net Gas Production -","Gas","Net","Operating","Operating ","Before-Tax",null,null,null,null,null,"Gross NGL","Net NGL","NGL","Net","Processing","Processing ","Before-Tax"]
["Period","Cash Flow","Cash Flow","Factors","Cash Flow",null,null,"Decline","Daily Production Rate (Bbls)",null,null,"Production","Production","Price","Revenue","Costs","Costs & Taxes","Net Cash Flow",null,"Decline","Daily Production Rate (Mcf)",null,null,"After Shrinkage","After Shrinkage & Royalty Interest","Price","Revenue","Costs","Costs & Taxes","Net Cash Flow",null,"Decline","Daily Production Rate (Bbls)",null,null,"Production","Production","Price","Revenue","Costs","Costs & Taxes","Net Cash Flow"]
["(Yrs.)","($)","($)","@10.0%","($)","Year",null,"Rate","Begin","End","Average","(Bbl/yr)","(Bbl/yr)","($/Bbl)","('000)","$/Bbl",null,null,null,"Rate","Begin","End","Average","(Mcf/yr)","(Mcf/yr)","($/Mcf)","($M)","$/Mcf",null,null,null,"Rate","Begin","End","Average","(BBL/yr)","(BBL/yr)","($/BBL)","('000)","$/Mcf"]
[null,{"$f":"-(C8+(C10*C11))/1000","v":-7500},{"$f":"B17","v":-7500},null,{"$f":"B17","v":-7500},0]
[{"$f":"IF(AND(A17=0,C18>0),(F18-C18/B18),A17)","v":0},{"$f":"AD18+AP18+R18","v":5526.1957081401315},{"$f":"C17+B18","v":-1973.8042918598685},{"$f":"1/((1+$E$7)^F18)","v":0.90909090909090906},{"$f":"B18*D18","v":5023.8142801273925},1,null,0.55000000000000004,{"$f":"L7","v":475},{"$f":"'Oil Decline'!F11","v":211.77337172834345},{"$f":"AVERAGE('Oil Decline'!$B$43:$B$54)","v":309.46021989526082},{"$f":"K18*365","v":112952.98026177019},{"$f":"L18*(1-'Production Economics'!$C$9)","v":84714.735196327645},{"$f":"L8","v":70},{"$f":"M18*N18/1000","v":5930.0314637429346},{"$f":"L10","v":10},{"$f":"(L18*P18/1000)+(O18*$L$12)","v":1396.381218486134},{"$f":"O18-Q18","v":4533.6502452568002},null,0.55000000000000004,{"$f":"X7*(1-Z7)","v":838.2},{"$f":"'Gas Decline'!F11","v":373.70340719594577},{"$f":"AVERAGE('Gas Decline'!$B$43:$B$54)","v":546.0848199431299},{"$f":"W18*365","v":199320.95927924241},{"$f":"X18*(1-$C$9)","v":149490.7194594318},{"$f":"X10","v":3.5},{"$f":"Y18*Z18/1000","v":523.21751810801129},{"$f":"X11","v":1},{"$f":"(X18*AB18/1000)+(AA18*$X$12)","v":238.56227313734325},{"$f":"AA18-AC18","v":284.65524497066804},null,{"$f":"T18","v":0.55000000000000004},{"$f":"((($X$7/$X$8)*$U18)*$X$9)/42","v":170.23809523809524},{"$f":"((($X$7/$X$8)*$V18)*$X$9)/42","v":75.899017209525297},{"$f":"((($X$7/$X$8)*$W18)*$X$9)/42","v":110.90961534902962},{"$f":"AI18*365","v":40482.00960239581},{"$f":"AJ18*(1-'Production Economics'!$C$9)","v":30361.507201796856},{"$f":"AJ8","v":28},{"$f":"AK18*AL18/1000","v":850.12220165031192},{"$f":"AJ11","v":0.3},{"$f":"(AM18*$X$12)+((AN18*(($X$7/$X$8)*X18))/1000)","v":142.23198373764836},{"$f":"AM18-AO18","v":707.8902179126635}]
[{"$f":"IF(AND(A18=0,C19>0),(F19-C19/B19),A18)","v":1.614353163746101},3212.8170054896946,1239.0127136298261,0.82644628099173545,2655.220665693962,2,null,0.3,{"$f":"J18","v":211.77337172834345},{"$f":"'Oil Decline'!F12","v":151.78891054002469},{"$f":"AVERAGE('Oil Decline'!$B$55:$B$66)","v":179.91381291431648},{"$f":"K19*365","v":65668.541713725514},{"$f":"L19*(1-'Production Economics'!$C$9)","v":49251.406285294135},{"$f":"N18*(1+$L$9)","v":70},{"$f":"M19*N19/1000","v":3447.5984399705894},{"$f":"P18*(1+$L$11)","v":10},811.8273469359317,{"$f":"O19-Q19","v":2635.7710930346575},null,0.3,{"$f":"V18","v":373.70340719594577},{"$f":"'Gas Decline'!F12","v":267.85229955503672},{"$f":"AVERAGE('Gas Decline'!$B$55:$B$66)","v":317.48269977127308},{"$f":"W19*365","v":115881.18541651468},86910.889062386006,{"$f":"Z18*(1+$Z$10)","v":3.5},{"$f":"Y19*Z19/1000","v":304.18811171835102},{"$f":"AB18*(1+$Z$11)","v":1},138.69529379539102,{"$f":"AA19-AC19","v":165.49281792296},null,{"$f":"T19","v":0.3},{"$f":"((($X$7/$X$8)*$U19)*$X$9)/42","v":75.899017209525297},{"$f":"((($X$7/$X$8)*$V19)*$X$9)/42","v":54.400698259834357},{"$f":"((($X$7/$X$8)*$W19)*$X$9)/42","v":64.480613314375546},{"$f":"AI19*365","v":23535.423859747076},{"$f":"AJ19*(1-'Production Economics'!$C$9)","v":17651.567894810309},{"$f":"AL18*(1+$AJ$10)","v":28},{"$f":"AK19*AL19/1000","v":494.24390105468859},{"$f":"AN18*(1+$AJ$12)","v":0.3},82.690806522611354,{"$f":"AM19-AO19","v":411.55309453207724}]
[1.614353163746101,2447.6941063727891,3686.7068200026151,0.75131480090157754,1838.9888101974368,3,null,0.2,{"$f":"J19","v":151.78891054002469},{"$f":"'Oil Decline'!F13","v":122.64611652038248},{"$f":"AVERAGE('Oil Decline'!$B$67:$B$78)","v":137.06789101644696},50029.780221003144,{"$f":"L20*(1-'Production Economics'!$C$9)","v":37522.33516575236},70,2626.563461602665,10,618.49315798215139,2008.0703036205136,null,0.2,{"$f":"V19","v":267.85229955503672},{"$f":"'Gas Decline'!F13","v":216.42566264808684},{"$f":"AVERAGE('Gas Decline'!$B$67:$B$78)","v":241.87495096827581},88284.357103420669,66213.267827565505,3.5,231.74643739647928,1,105.66533990815662,126.08109748832265,null,0.2,54.400698259834357,43.955968229363968,49.124708826827678,17930.518721792101,{"$f":"AJ20*(1-'Production Economics'!$C$9)","v":13447.889041344075},28,376.54089315763406,0.3,62.998187893681077,313.542705263953]
[1.614353163746101,2033.1946104744513,5719.9014304770662,0.68301345536507052,1388.6992763297935,4,null,0.15,122.64611652038248,{"$f":"'Oil Decline'!F14","v":104.81262076607183},{"$f":"AVERAGE('Oil Decline'!$B$79:$B$90)","v":113.85644063843536},41557.600833028904,{"$f":"L21*(1-'Production Economics'!$C$9)","v":31168.200624771678},70,2181.7740437340171,10,513.75584029831975,1668.0182034356974,null,0.15,216.42566264808684,{"$f":"'Gas Decline'!F14","v":184.95590714804831},{"$f":"AVERAGE('Gas Decline'!$B$79:$B$90)","v":200.91502096632667},73333.982652709237,55000.486989531928,3.5,192.50170446336176,1,87.771610487461373,104.73009397590039,null,0.15,43.955968229363968,37.564473080312275,40.805762913420928,14894.103463398638,{"$f":"AJ21*(1-'Production Economics'!$C$9)","v":11170.577597548978},28,312.77617273137139,0.3,52.329859668517912,260.44631306285351]
[1.614353163746101,1765.2744025961365,7485.1758330732027,0.62092132305915493,1096.0965176224524,5,null,0.1,104.81262076607183,{"$f":"'Oil Decline'!F15","v":92.543400370160796},{"$f":"AVERAGE('Oil Decline'!$B$91:$B$102)","v":98.853245425293395},36081.43458023209,{"$f":"L22*(1-'Production Economics'!$C$9)","v":27061.075935174067},70,1894.2753154621846,10,446.05673499811917,1448.2185804640653,null,0.1,184.95590714804831,{"$f":"'Gas Decline'!F15","v":163.30511836248834},{"$f":"AVERAGE('Gas Decline'!$B$91:$B$102)","v":174.43973905028534},63670.504753354151,47752.878565015613,3.5,167.13507497755464,1,76.205635376670756,90.929439600883882,null,0.1,37.564473080312275,33.16720626659712,35.428643414162437,12931.45484616929,{"$f":"AJ22*(1-'Production Economics'!$C$9)","v":9698.5911346269677},28,271.5605517695551,0.3,45.434169238367872,226.12638253118723]
[1.614353163746101,1574.711110202732,9059.8869432759348,0.56447393005377722,888.88336907548285,6,null,0.09,92.543400370160796,{"$f":"'Oil Decline'!F16","v":83.476322482404228},{"$f":"AVERAGE('Oil Decline'!$B$103:$B$114)","v":88.181939714466978},32186.407995780446,{"$f":"L23*(1-'Production Economics'!$C$9)","v":24139.805996835334},70,1689.7864197784734,10,397.90446884783574,1291.8819509306377,null,0.09,163.30511836248834,{"$f":"'Gas Decline'!F16","v":147.30497213024233},{"$f":"AVERAGE('Gas Decline'!$B$103:$B$114)","v":155.60870135570099},56797.175994830861,42597.881996123149,3.5,149.09258698643103,1,67.979120018813191,81.113466967617839,null,0.09,33.16720626659712,29.91758276610971,31.604066954507452,11535.48443839522,{"$f":"AJ23*(1-'Production Economics'!$C$9)","v":8651.6133287964149},28,242.2451732062996,0.3,40.529480901823199,201.71569230447639]
[1.614353163746101,1430.6856466839063,10490.57258995984,0.51315811823070645,734.16795423199471,7,null,7.0000000000000007E-2,83.476322482404228,{"$f":"'Oil Decline'!F17","v":76.443429688624121},{"$f":"AVERAGE('Oil Decline'!$B$115:$B$126)","v":80.116693630131721},29242.593174998077,{"$f":"L24*(1-'Production Economics'!$C$9)","v":21931.944881248557},70,1535.2361416873989,10,361.51155812591378,1173.7245835614851,null,7.0000000000000007E-2,147.30497213024233,{"$f":"'Gas Decline'!F17","v":134.89443860968544},{"$f":"AVERAGE('Gas Decline'!$B$115:$B$126)","v":141.37643174547136},51602.397587097046,38701.798190322785,3.5,135.45629366612977,1,61.761619612056776,73.694674054072991,null,7.0000000000000007E-2,29.91758276610971,27.397008216565286,28.713498510984998,10480.426956509524,{"$f":"AJ24*(1-'Production Economics'!$C$9)","v":7860.3202173821428},28,220.0889660867,0.3,36.82257701835173,183.26638906834827]
[1.614353163746101,1317.1485279513847,11807.721117911226,0.46650738020973315,614.45950912170701,8,null,0.06,76.443429688624121,{"$f":"'Oil Decline'!F18","v":70.794233498362445},{"$f":"AVERAGE('Oil Decline'!$B$127:$B$138)","v":73.758756384796257},26921.946080450634,{"$f":"L25*(1-'Production Economics'!$C$9)","v":20191.459560337975},70,1413.4021692236583,10,332.8225584195709,1080.5796108040875,null,0.06,134.89443860968544,{"$f":"'Gas Decline'!F18","v":124.92563668810919},{"$f":"AVERAGE('Gas Decline'!$B$127:$B$138)","v":130.15695437188074},47507.288345736473,35630.466259302353,3.5,124.70663190755825,1,56.860285738803341,67.846346168754906,null,0.06,27.397008216565286,25.372348408721088,26.434827003412849,9648.711856245689,{"$f":"AJ25*(1-'Production Economics'!$C$9)","v":7236.5338921842667},28,202.62294898115948,0.3,33.900378002617067,168.72257097854242]
[1.614353163746101,1224.8262672655467,13032.547385176773,0.42409761837248466,519.44590286737866,9,null,0.05,70.794233498362445,{"$f":"'Oil Decline'!F19","v":66.134782038961347},{"$f":"AVERAGE('Oil Decline'!$B$139:$B$150)","v":68.588824463259897},25034.920929089862,{"$f":"L26*(1-'Production Economics'!$C$9)","v":18776.190696817397},70,1314.3333487772177,10,309.4942099858734,1004.8391387913443,null,0.05,124.92563668810919,{"$f":"'Gas Decline'!F19","v":116.70338128712628},{"$f":"AVERAGE('Gas Decline'!$B$139:$B$150)","v":121.03388301595793},44177.367300824641,33133.02547561848,3.5,115.96558916466468,1,52.874786488174493,63.090802676490185,null,0.05,25.372348408721088,23.702411522507212,24.581934745773228,8972.406182207229,{"$f":"AJ26*(1-'Production Economics'!$C$9)","v":6729.3046366554217},28,188.42052982635181,0.3,31.52420402863963,156.89632579771217]
[1.614353163746101,1147.9457650160953,14180.493150192868,0.38554328942953148,442.58278633100537,10,null,0.05,66.134782038961347,{"$f":"'Oil Decline'!F20","v":62.211120495013986},{"$f":"AVERAGE('Oil Decline'!$B$151:$B$162)","v":64.283611593107722},23463.518231484319,{"$f":"L27*(1-'Production Economics'!$C$9)","v":17597.638673613241},70,1231.8347071529267,10,290.06774413672485,941.76696301620188,null,0.05,116.70338128712628,{"$f":"'Gas Decline'!F20","v":109.77953243612811},{"$f":"AVERAGE('Gas Decline'!$B$151:$B$162)","v":113.43673229750733},41404.407288590177,31053.305466442631,3.5,108.68656913254921,1,49.555899973531368,59.130669159017842,null,0.05,23.702411522507212,22.29618050352558,23.03895637838388,8409.2190781101162,{"$f":"AJ27*(1-'Production Economics'!$C$9)","v":6306.9143085825872},28,176.59360064031245,0.3,29.545467799436885,147.04813284087555]
[1.614353163746101,1082.7047927594786,15263.197942952345,0.3504938994813922,379.48142480146225,11,null,{"$f":"H27","v":0.05},62.211120495013986,{"$f":"'Oil Decline'!F21","v":58.851422092970935},{"$f":"AVERAGE('Oil Decline'!$B$163:$B$174)","v":60.630197788809703},22130.022192915541,{"$f":"L28*(1-'Production Economics'!$C$9)","v":16597.516644686657},70,1161.8261651280659,10,273.58239935991838,888.24376576814757,null,{"$f":"T27","v":0.05},109.77953243612811,{"$f":"'Gas Decline'!F21","v":103.85087700152023},{"$f":"AVERAGE('Gas Decline'!$B$163:$B$174)","v":106.98977415304493},39051.267565861403,29288.450674396052,3.5,102.50957736038617,1,46.739485867890366,55.770091492495808,null,0.05,22.29618050352558,21.092072881823569,21.729581677127609,7931.297312151577,{"$f":"AJ28*(1-'Production Economics'!$C$9)","v":5948.4729841136832},28,166.55724355518311,0.3,27.866308056347947,138.69093549883516]
[1.614353163746101,1026.4861172218516,16289.684060174197,0.31863081771035656,327.07011089872748,12,null,{"$f":"H28","v":0.05},58.851422092970935,{"$f":"'Oil Decline'!F22","v":55.934843488268768},{"$f":"AVERAGE('Oil Decline'!$B$175:$B$186)","v":57.482021292519306},20980.937771769546,{"$f":"L29*(1-'Production Economics'!$C$9)","v":15735.70332882716},70,1101.4992330179011,10,259.37684320350104,842.12238981440009,null,0.05,103.85087700152023,{"$f":"'Gas Decline'!F22","v":98.704169496856366},{"$f":"AVERAGE('Gas Decline'!$B$175:$B$186)","v":101.43437923022024},37023.548419030391,27767.661314272795,3.5,97.186814599954786,1,44.312559514027001,52.874255085927786,null,0.05,21.092072881823569,20.046778581726237,20.601283120748398,7519.4683390731652,{"$f":"AJ29*(1-'Production Economics'!$C$9)","v":5639.6012543048737},28,157.90883512053648,0.3,26.419362799012831,131.48947232152364]
[1.614353163746101,977.42291833132458,17267.106978505522,0.28966437973668779,283.12460337886637,13,null,0.05,55.934843488268768,{"$f":"'Oil Decline'!F23","v":53.373665159252674},{"$f":"AVERAGE('Oil Decline'!$B$187:$B$198)","v":54.734542535168991},19978.108025336682,{"$f":"L30*(1-'Production Economics'!$C$9)","v":14983.581019002511},70,1048.8506713301758,10,246.97936046322474,801.87131086695103,null,0.05,98.704169496856366,{"$f":"'Gas Decline'!F23","v":94.184616215505088},{"$f":"AVERAGE('Gas Decline'!$B$187:$B$198)","v":96.586072414677872},35253.916431357422,26440.437323518068,3.5,92.54153063231324,1,42.194531228780917,50.346999403532323,null,0.05,20.046778581726237,19.128859061391797,19.616593884995819,7160.0567680234735,{"$f":"AJ30*(1-'Production Economics'!$C$9)","v":5370.0425760176049},28,150.36119212849292,0.3,25.1565840676517,125.20460806084122]
[1.614353163746101,934.14400836479615,18201.25098687032,0.26333125430607973,245.98931342521081,14,null,0.05,53.373665159252674,{"$f":"'Oil Decline'!F24","v":51.102509950595667},{"$f":"AVERAGE('Oil Decline'!$B$199:$B$210)","v":52.310976731869857},19093.506507132497,{"$f":"L31*(1-'Production Economics'!$C$9)","v":14320.129880349374},70,1002.4090916244561,10,236.0434741944255,766.36561743003062,null,0.05,94.184616215505088,{"$f":"'Gas Decline'!F24","v":90.176849786098458},{"$f":"AVERAGE('Gas Decline'!$B$199:$B$210)","v":92.309355923910005},33692.914912227148,25269.686184170361,3.5,88.443901644596266,1,40.326207535571868,48.117694109024399,null,0.05,19.128859061391797,18.314883252394701,18.747994422741378,6843.0179643006031,{"$f":"AJ31*(1-'Production Economics'!$C$9)","v":5132.2634732254519},28,143.70337725031266,0.3,24.04268042457154,119.66069682574111]
[1.614353163746101,895.61716906675611,19096.868155937074,0.23939204936916339,214.40362955309922,15,null,0.05,51.102509950595667,{"$f":"'Oil Decline'!F25","v":49.07155179165558},{"$f":"AVERAGE('Oil Decline'!$B$211:$B$222)","v":50.153520959219684},18306.035150115185,{"$f":"L32*(1-'Production Economics'!$C$9)","v":13729.526362586388},70,961.06684538104707,10,226.30835954329899,734.75848583774814,null,0.05,90.176849786098458,{"$f":"'Gas Decline'!F25","v":86.592944971286926},{"$f":"AVERAGE('Gas Decline'!$B$211:$B$222)","v":88.50222821251981},32303.31329756973,24227.484973177299,3.5,84.796197406120541,1,38.663028103028772,46.133169303091769,null,0.05,18.314883252394701,17.58699357309602,17.974768259635635,6560.790414767007,{"$f":"AJ32*(1-'Production Economics'!$C$9)","v":4920.5928110752557},28,137.77659871010715,0.3,23.051084784191001,114.72551392591615]
[1.614353163746101,861.04892051021693,19957.917076447291,0.21762913579014853,187.3893324436788,16,null,0.05,49.07155179165558,{"$f":"'Oil Decline'!F26","v":47.242081882681944},{"$f":"AVERAGE('Oil Decline'!$B$223:$B$234)","v":48.217741338550461},17599.475588570916,{"$f":"L33*(1-'Production Economics'!$C$9)","v":13199.606691428187},70,923.97246839997308,10,217.57351696370796,706.39895143626518,null,0.05,86.592944971286926,{"$f":"'Gas Decline'!F26","v":83.364594560913531},{"$f":"AVERAGE('Gas Decline'!$B$223:$B$234)","v":85.086279343444417},31056.491960357213,23292.368970267911,3.5,81.52329139593769,1,37.170738815052538,44.352552580885153,null,0.05,17.58699357309602,16.931316855578615,17.280990367841166,6307.5614842620262,{"$f":"AJ33*(1-'Production Economics'!$C$9)","v":4730.6711131965194},28,132.45879116950255,0.3,22.161374676436004,110.29741649306655]
[1.614353163746101,829.81820374054723,20787.735280187837,0.19784466890013502,164.17510776635336,17,null,0.05,47.242081882681944,{"$f":"'Oil Decline'!F27","v":45.583524091754896},{"$f":"AVERAGE('Oil Decline'!$B$235:$B$246)","v":46.468859347985017},16961.13366201453,{"$f":"L34*(1-'Production Economics'!$C$9)","v":12720.850246510898},70,890.45951725576288,10,209.68201489665461,680.77750235910821,null,0.05,83.364594560913531,{"$f":"'Gas Decline'!F27","v":80.437842607920487},{"$f":"AVERAGE('Gas Decline'!$B$235:$B$246)","v":82.000137647747991},29930.050241428016,22447.537681071011,3.5,78.566381883748548,1,35.822528882709157,42.74385300103939,null,0.05,16.931316855578615,16.33689466790036,16.654196185175664,6078.7816075891169,{"$f":"AJ34*(1-'Production Economics'!$C$9)","v":4559.0862056918377},28,127.65441375937145,0.3,21.357565378971763,106.29684838039969]
[1.614353163746101,801.43121948235341,21589.166499670191,0.17985878990921364,144.14444933156147,18,null,0.05,45.583524091754896,{"$f":"'Oil Decline'!F28","v":44.071372050507527},{"$f":"AVERAGE('Oil Decline'!$B$247:$B$258)","v":44.879222847188096},16380.916339223655,{"$f":"L35*(1-'Production Economics'!$C$9)","v":12285.687254417742},70,859.99810780924201,10,202.50907824365243,657.48902956558959,null,0.05,80.437842607920487,{"$f":"'Gas Decline'!F28","v":77.769444135488854},{"$f":"AVERAGE('Gas Decline'!$B$247:$B$258)","v":79.19500698191726},28906.177548399799,21679.633161299847,3.5,75.878716064549465,1,34.597081253241008,41.281634811308457,null,0.05,16.33689466790036,15.794943972024672,16.084475233797722,5870.8334603361682,{"$f":"AJ35*(1-'Production Economics'!$C$9)","v":4403.1250952521259},28,123.28750266705953,0.3,20.62694756160419,102.66055510545533]
[1.614353163746101,775.48989515511619,22364.656394825306,0.16350799082655781,126.79879466311102,19,null,0.05,44.071372050507527,{"$f":"'Oil Decline'!F29","v":42.685730000009045},{"$f":"AVERAGE('Oil Decline'!$B$259:$B$270)","v":43.426540270127987},15850.687198596715,{"$f":"L36*(1-'Production Economics'!$C$9)","v":11888.015398947537},70,832.16107792632761,10,195.9541204926519,636.20695743367571,null,0.05,77.769444135488854,{"$f":"'Gas Decline'!F29","v":75.324290248871193},{"$f":"AVERAGE('Gas Decline'!$B$259:$B$270)","v":76.6315507058073},27970.516007619663,20977.887005714747,3.5,73.422604520001613,1,33.477211346619782,39.945393173381831,null,0.05,15.794943972024672,15.298334165031333,15.56383825733494,5680.8009639272532,{"$f":"AJ36*(1-'Production Economics'!$C$9)","v":4260.6007229454399},28,119.29682024247231,0.3,19.959275694413634,99.337544548058673]
[1.614353163746101,751.66937982787124,23116.325774653178,0.14864362802414349,111.73086369227272,20,null,0.05,42.685730000009045,{"$f":"'Oil Decline'!F30","v":41.410259468814957},{"$f":"AVERAGE('Oil Decline'!$B$271:$B$282)","v":42.09262037098339},15363.806435408937,{"$f":"L37*(1-'Production Economics'!$C$9)","v":11522.854826556702},70,806.59983785896907,10,189.93505705774299,616.66478080122602,null,0.05,75.324290248871193,{"$f":"'Gas Decline'!F30","v":73.073549396873034},{"$f":"AVERAGE('Gas Decline'!$B$271:$B$282)","v":74.277667782383347},27111.34874056992,20333.511555427438,3.5,71.167290443996023,1,32.448895523869624,38.7183949201264,null,0.05,15.298334165031333,14.841209570043578,15.085765547603168,5506.3044248751567,{"$f":"AJ37*(1-'Production Economics'!$C$9)","v":4129.7283186563673},28,115.63239292237829,0.3,19.346188815859442,96.286204106518852]
[1.614353163746101,729.70166833867142,23846.02744299185,0.13513057093103953,98.60500305193672,21,null,0.05,41.410259468814957,{"$f":"'Oil Decline'!F31","v":40.231405043956279},{"$f":"AVERAGE('Oil Decline'!$B$283:$B$294)","v":40.862455195515189},14914.796146363044,{"$f":"L38*(1-'Production Economics'!$C$9)","v":11186.097109772283},70,783.02679768405983,10,184.38416735941311,598.64263032464669,null,0.05,73.073549396873034,{"$f":"'Gas Decline'!F31","v":70.993301133218466},{"$f":"AVERAGE('Gas Decline'!$B$283:$B$294)","v":72.106874548497203},26319.009210201479,19739.25690765111,3.5,69.087399176778888,1,31.500564148459894,37.586835028318994,null,0.05,14.841209570043578,14.41871195369079,14.644878282878134,5345.3805732505189,{"$f":"AJ38*(1-'Production Economics'!$C$9)","v":4009.0354299378891},28,112.2529920382609,0.3,18.780789052555193,93.472202985705707]
[1.614353163746101,709.36347809522476,24555.390921087073,0.12284597357367227,87.142447084214226,22,null,0.05,40.231405043956279,{"$f":"'Oil Decline'!F32","v":39.137816015122119},{"$f":"AVERAGE('Oil Decline'!$B$295:$B$306)","v":39.723541197201079},14499.092536978394,{"$f":"L39*(1-'Production Economics'!$C$9)","v":10874.319402733796},70,761.20235819136576,10,179.2450314883954,581.95732670297036,null,0.05,70.993301133218466,{"$f":"'Gas Decline'!F32","v":69.063515524487613},{"$f":"AVERAGE('Gas Decline'!$B$295:$B$306)","v":70.097106726550535},25585.443955190945,19189.082966393209,3.5,67.161790382376225,1,30.622578233869163,36.539212148507062,null,0.05,14.41871195369079,14.026773244256017,14.236695216928462,5196.3937541788882,{"$f":"AJ39*(1-'Production Economics'!$C$9)","v":3897.2953156341664},28,109.12426883775665,0.3,18.257329594009285,90.866939243747368]
[1.614353163746101,690.46713441359645,25245.85805550067,0.11167815779424752,77.110097588783532,23,null,0.05,39.137816015122119,{"$f":"'Oil Decline'!F33","v":38.119908012198849},{"$f":"AVERAGE('Oil Decline'!$B$307:$B$318)","v":38.665368827695715},14112.859622108936,{"$f":"L40*(1-'Production Economics'!$C$9)","v":10584.644716581701},70,740.92513016071905,10,174.47022707832173,566.45490308239732,null,0.05,69.063515524487613,{"$f":"'Gas Decline'!F33","v":67.267279596554047},{"$f":"AVERAGE('Gas Decline'!$B$307:$B$318)","v":68.22981873345573},24903.883837711342,18677.912878283507,3.5,65.372695073992276,1,29.80683596826076,35.565859105731519,null,0.05,14.026773244256017,13.661958423247137,13.857449749014568,5057.9691583903177,{"$f":"AJ40*(1-'Production Economics'!$C$9)","v":3793.4768687927381},28,106.21735232619666,0.3,17.770980100729055,88.446372225467599]
[1.614353163746101,672.85362166207733,25918.711677162748,0.10152559799477048,68.311866302189458,24,null,0.05,38.119908012198849,{"$f":"'Oil Decline'!F34","v":37.169526353324038},{"$f":"AVERAGE('Oil Decline'!$B$319:$B$330)","v":37.679033409642422},13752.847194519483,{"$f":"L41*(1-'Production Economics'!$C$9)","v":10314.635395889612},70,722.02447771227287,10,170.01957344224709,552.0049042700258,null,0.05,67.267279596554047,{"$f":"'Gas Decline'!F34","v":65.59020326390214},{"$f":"AVERAGE('Gas Decline'!$B$319:$B$330)","v":66.489297009817506},24268.593408583391,18201.445056437544,3.5,63.705057697531402,1,29.046472735898249,34.658584961633153,null,0.05,13.661958423247137,13.321344869871387,13.503950461311517,4928.941918378704,{"$f":"AJ41*(1-'Production Economics'!$C$9)","v":3696.7064387840283},28,103.50778028595279,0.3,17.31764785553441,86.190132430418373]
[1.614353163746101,656.38721828009898,26575.098895442847,9.2295998177064048E-2,60.581913501828154,25,null,0.05,37.169526353324038,{"$f":"'Oil Decline'!F35","v":36.279684396346155},{"$f":"AVERAGE('Oil Decline'!$B$331:$B$342)","v":36.756934704486561},13416.281167137595,{"$f":"L42*(1-'Production Economics'!$C$9)","v":10062.210875353196},70,704.35476127472373,10,165.85877592873851,538.49598534598522,null,0.05,65.59020326390214,{"$f":"'Gas Decline'!F35","v":64.019957613266669},{"$f":"AVERAGE('Gas Decline'!$B$331:$B$342)","v":64.862129864238241},23674.677400446959,17756.008050335218,3.5,62.14602817617326,1,28.335629513659953,33.810398662513307,null,0.05,13.321344869871387,13.002428586621463,13.173473444492831,4808.3178072398832,{"$f":"AJ42*(1-'Production Economics'!$C$9)","v":3606.2383554299122},28,100.97467395203753,0.3,16.893839680437047,84.08083427160048]
[null,{"$f":"SUM(B17:B42)","v":26575.098895442847},null,null,{"$f":"SUM(E17:E42)","v":10278.4180290819},null,null,null,null,null,null,{"$f":"SUM(L18:L42)","v":696480.22955975484},{"$f":"SUM(M18:M42)","v":522360.17216981621},{"$f":"AVERAGE(N18:N42)","v":70},{"$f":"SUM(O18:O42)","v":36565.212051887138},{"$f":"AVERAGE(P18:P42)","v":10},{"$f":"SUM(Q18:Q42)","v":8610.2368379324707},{"$f":"SUM(R18:R42)","v":27954.975213954662},null,null,null,null,null,{"$f":"SUM(X18:X42)","v":1229030.778658875},{"$f":"SUM(Y18:Y42)","v":921773.08399415622},{"$f":"AVERAGE(Z18:Z42)","v":3.5},{"$f":"SUM(AA18:AA42)","v":3226.2057939795473},{"$f":"AVERAGE(AB18:AB42)","v":1},{"$f":"SUM(AC18:AC42)","v":1470.9962132073415},{"$f":"SUM(AD17:AD42)","v":1755.2095807722062},null,null,null,null,null,{"$f":"SUM(AJ18:AJ42)","v":249615.67495571458},{"$f":"SUM(AK18:AK42)","v":187211.75621678587},{"$f":"AVERAGE(AL18:AL42)","v":28},{"$f":"SUM(AM18:AM42)","v":5241.9291740700073},{"$f":"AVERAGE(AN18:AN42)","v":0.29999999999999988},{"$f":"SUM(AO18:AO42)","v":877.01507335402027},{"$f":"SUM(AP18:AP42)","v":4364.9141007159851}]

{"sheet":"Oil Decline","index":2,"n_rows":342,"n_cols":7,"rows_kept":342,"cut":false,"hidden":false,"merged":[[40,0,40,1],[1,0,1,1],[2,3,2,10],[3,3,3,10],[4,3,4,10],[5,3,5,10],[7,1,7,6]]}
[]
["Curve Fitting",null,null,"Instructions:"]
["Parameter","Value",null,"1.) Make sure that macros are enabled and fillout the pink cells with the appropriate values."]
["IP =",{"$f":"'Production Economics'!L7","v":475},null,"2a.) Press Command+Option+s and the solver will fit the smooth curve to the data you have provided"]
["D_i =",1.7009594001320087,null,"2b.) If Macro in 2a does not work use the solver add in to minimize cell G35 by changing cells B5 and B6."]
["b =",1.660676580727972,null,"3.) After a solution is reached the ladder chart below will reflect this new fitted curve. "]
[]
[null,"Curve Characteristics"]
["Year","Annual Decline (%)","Begin Production (Bbld)","End Production (Bbld)","Average Production (Bbld)","Calculated","Squared Residual"]
[1,{"$f":"'Production Economics'!H18*100","v":55.000000000000007},{"$f":"B4","v":475},{"$f":"C10*(1-B10/100)","v":213.74999999999997},{"$f":"(C10+D10)/2","v":344.375},{"$f":"$B$4/(1+$B$5*$B$6*($A10-1))^(1/$B$6)","v":475},{"$f":"(F10-C10)^2","v":0}]
[2,{"$f":"'Production Economics'!H19*100","v":30},{"$f":"D10","v":213.74999999999997},{"$f":"C11*(1-B11/100)","v":149.62499999999997},{"$f":"(C11+D11)/2","v":181.68749999999997},211.77337172834345,{"$f":"(F11-C11)^2","v":3.9070593243118528}]
[3,{"$f":"'Production Economics'!H20*100","v":20},{"$f":"D11","v":149.62499999999997},{"$f":"C12*(1-B12/100)","v":119.69999999999999},134.66249999999997,151.78891054002469,4.682508825230058]
[4,{"$f":"'Production Economics'!H21*100","v":15},119.69999999999999,101.74499999999999,110.7225,122.64611652038248,8.6796025516706248]
[5,{"$f":"'Production Economics'!H22*100","v":10},101.74499999999999,91.570499999999996,96.657749999999993,104.81262076607183,9.4102971644351854]
[6,{"$f":"'Production Economics'!H23*100","v":9},91.570499999999996,83.329155,87.449827499999998,92.543400370160796,0.94653513025902314]
[7,{"$f":"'Production Economics'!H24*100","v":7.0000000000000009},83.329155,77.496114149999997,80.412634574999998,83.476322482404228,2.1658267877198809E-2]
[8,{"$f":"'Production Economics'!H25*100","v":6},77.496114149999997,72.846347300999994,75.171230725499996,76.443429688624121,1.108144575222217]
[9,{"$f":"'Production Economics'!H26*100","v":5},72.846347300999994,69.20402993594999,71.025188618474999,70.794233498362445,4.2111710589755438]
[10,{"$f":"'Production Economics'!H27*100","v":5},69.20402993594999,65.74382843915248,67.473929187551235,66.134782038961347,9.4202826531692043]
[11,{"$f":"'Production Economics'!H28*100","v":5},65.74382843915248,62.456637017194851,64.100232728173665,62.211120495013986,12.480025418579224]
[12,{"$f":"'Production Economics'!H29*100","v":5},62.456637017194851,59.333805166335104,60.895221091764981,58.851422092970935,12.997574649846852]
[13,{"$f":"'Production Economics'!H30*100","v":5},59.333805166335104,56.367114908018344,57.850460037176724,55.934843488268768,11.552940488963518]
[14,{"$f":"'Production Economics'!H31*100","v":5},56.367114908018344,53.548759162617422,54.957937035317883,53.373665159252674,8.9607413983852524]
[15,{"$f":"'Production Economics'!H32*100","v":5},53.548759162617422,50.871321204486549,52.210040183551982,51.102509950595667,5.9841352073170562]
[16,{"$f":"'Production Economics'!H33*100","v":5},50.871321204486549,48.32775514426222,49.599538174374388,49.07155179165558,3.2391699393619304]
[17,{"$f":"'Production Economics'!H34*100","v":5},48.32775514426222,45.911367387049104,47.119561265655662,47.242081882681944,1.1786864309103535]
[18,{"$f":"'Production Economics'!H35*100","v":5},45.911367387049104,43.615799017696645,44.763583202372871,45.583524091754896,0.10748122626936546]
[19,{"$f":"'Production Economics'!H36*100","v":5},43.615799017696645,41.435009066811809,42.525404042254223,44.071372050507527,0.20754678822450517]
[20,{"$f":"'Production Economics'!H37*100","v":5},{"$f":"D28","v":41.435009066811809},39.363258613471217,40.399133840141516,42.685730000009045,1.5643028527377654]
[21,{"$f":"'Production Economics'!H38*100","v":5},39.363258613471217,{"$f":"C30*(1-B30/100)","v":37.395095682797653},38.379177148134431,41.410259468814957,4.1902125017780012]
[22,{"$f":"'Production Economics'!H39*100","v":5},37.395095682797653,{"$f":"C31*(1-B31/100)","v":35.525340898657767},36.46021829072771,40.231405043956279,8.0446507921960553]
[23,{"$f":"'Production Economics'!H40*100","v":5},35.525340898657767,{"$f":"C32*(1-B32/100)","v":33.74907385372488},34.637207376191327,39.137816015122119,13.049976467074138]
[24,{"$f":"'Production Economics'!H41*100","v":5},33.74907385372488,{"$f":"C33*(1-B33/100)","v":32.061620161038633},32.905347007381756,38.119908012198849,19.104191240882844]
[25,{"$f":"'Production Economics'!H42*100","v":5},{"$f":"D33","v":32.061620161038633},{"$f":"C34*(1-B34/100)","v":30.458539152986699},31.260079657012668,37.169526353324038,26.090705669187589]
[26,null,null,null,null,36.279684396346155,{"$f":"SUM(G10:G34)","v":171.13960062286534}]
[]
[]
[]
["It is not necessary to edit below this line."]
[]
["Typical Production Curve"]
["Year","Monthly Production (Bbld)","Monthly Production (Bbl)","Cumulative Production (Bbl)"]
[1,{"$f":"$B$4/(1+$B$5*$B$6*(A43-1))^(1/$B$6)","v":475},{"$f":"B43*(365/12)","v":14447.916666666668},{"$f":"C43","v":14447.916666666668}]
[{"$f":"A43+1/12","v":1.0833333333333333},{"$f":"$B$4/(1+$B$5*$B$6*(A44-1))^(1/$B$6)","v":418.22631784616863},{"$f":"B44*(365/12)","v":12721.050501154295},{"$f":"C44+D43","v":27168.967167820963}]
[{"$f":"A44+1/12","v":1.1666666666666665},376.53078690273759,{"$f":"B45*(365/12)","v":11452.811434958268},{"$f":"C45+D44","v":38621.778602779232}]
[1.2499999999999998,344.33062669637735,10473.389895348146,49095.168498127379]
[1.333333333333333,318.54929846528347,9689.2078283190385,58784.376326446421]
[1.4166666666666663,297.33784319616643,9044.0260638833952,67828.402390329822]
[1.4999999999999996,279.51130835478085,8501.8022957912508,76330.204686121069]
[1.5833333333333328,264.27163376412074,8038.2621936586729,84368.466879779735]
[1.6666666666666661,251.05964069614805,7636.3974045078367,92004.864284287571]
[1.7499999999999993,239.47067040238014,7283.8995580723958,99288.763842359971]
[1.8333333333333326,229.20390962418966,6971.6189177357692,106260.38276009574]
[1.9166666666666659,220.03060279477663,6692.597501674456,112952.98026177019]
[1.9999999999999991,211.77337172834353,6441.4400567371158,119394.42031850731]
[2.0833333333333326,204.29233680358749,6213.89191110912,125608.31222961644]
[2.1666666666666661,197.47554935176774,6006.5479594496019,131614.86018906604]
[2.2499999999999996,191.23223978009918,5816.64729331135,137431.50748237738]
[2.333333333333333,185.4879535108943,5641.9252526230348,143073.43273500042]
[2.4166666666666665,180.18098221272999,5480.5048756372043,148553.93761063763]
[2.5,175.2597022378423,5330.8159430677033,153884.75355370532]
[2.5833333333333335,170.68056026280482,5191.5337079936471,159076.28726169898]
[2.666666666666667,166.40652836730797,5061.5319045056176,164137.8191662046]
[2.7500000000000004,162.405904764799,4939.8462699293032,169077.66543613392]
[2.8333333333333339,158.65137254223606,4825.6459148263466,173903.31135096026]
[2.9166666666666674,155.11925340938507,4718.2106245354626,178621.52197549571]
[3.0000000000000009,151.78891054002469,4616.9126955924175,183238.43467108812]
[3.0833333333333344,148.64226660873828,4521.2022760157897,187759.63694710392]
[3.1666666666666679,145.66341170552894,4430.595439376506,192190.23238648043]
[3.2500000000000013,142.83828201145113,4344.6644111816386,196534.89679766208]
[3.3333333333333348,140.15439465444356,4263.0295040726587,200797.92630173473]
[3.4166666666666683,137.6006275195017,4185.3524203848438,204983.27872211958]
[3.5000000000000018,135.16703529441705,4111.3306568718517,209094.60937899142]
[3.5833333333333353,132.84469492390511,4040.692803935447,213135.30218292685]
[3.6666666666666687,130.62557508502954,3973.1945755029819,217108.49675842983]
[3.7500000000000022,128.50242540247265,3908.61543932521,221017.11219775505]
[3.8333333333333357,126.46868197781029,3846.7557434917298,224863.86794124678]
[3.9166666666666692,124.51838647404047,3787.4342552520643,228651.30219649884]
[4.0000000000000027,122.64611652038239,3730.4860441616311,232381.78824066048]
[4.0833333333333357,120.84692561635151,3675.7606541640253,236057.54889482449]
[4.1666666666666687,119.11629104339535,3623.1205192366087,239680.66941406109]
[4.2500000000000018,117.45006855584521,3572.4395852402918,243253.10899930139]
[4.3333333333333348,115.84445283494756,3523.6021070629886,246776.71110636438]
[4.4166666666666679,114.29594286125673,3476.501595363226,250253.21270172761]
[4.5000000000000009,112.80131150014461,3431.0398914627317,253684.25259319035]
[4.5833333333333339,111.35757870915121,3387.1263524033493,257071.37894559369]
[4.666666666666667,109.96198786946154,3344.6771310294553,260416.05607662315]
[4.75,108.61198482094589,3303.614538303771,263719.6706149269]
[4.833333333333333,107.30519924408877,3263.8664770077003,266983.53709193459]
[4.9166666666666661,106.03942808525368,3225.3659375931329,270208.90302952775]
[4.9999999999999991,104.81262076607183,3188.0505483013517,273396.95357782912]
[5.0833333333333321,103.6228659548934,3151.8621727946743,276548.81575062382]
[5.1666666666666652,102.46837970947583,3116.7465494965563,279665.56230012036]
[5.2499999999999982,101.34749482644058,3082.6529676375676,282748.21526775794]
[5.3333333333333313,100.25865125533697,3049.5339756831663,285797.7492434411]
[5.4166666666666643,99.200387454099882,3017.3451183955381,288815.09436183661]
[5.4999999999999973,98.17133257882368,2986.0446992725538,291801.13906110916]
[5.5833333333333304,97.170199414562575,2955.5935655262783,294756.73262663546]
[5.6666666666666634,96.195777965678715,2925.9549131227277,297682.68753975822]
[5.7499999999999964,95.24692963440593,2897.0941097131804,300579.78164947138]
[5.8333333333333295,94.322581925037383,2868.9785335532206,303448.76018302457]
[5.9166666666666625,93.421723618693846,2841.5774267352713,306290.33760975982]
[5.9999999999999956,92.543400370160853,2814.8617612590592,309105.19937101885]
[6.0833333333333286,91.686710683955837,2788.8041166369903,311894.00348765583]
[6.1666666666666616,90.850802231714454,2763.3785678813147,314657.38205553713]
[6.2499999999999947,90.034868477286182,2738.5605828507883,317395.9426383879]
[6.3333333333333277,89.238145579682751,2714.3269280486838,320110.26956643659]
[6.4166666666666607,{"$f":"$B$4/(1+$B$5*$B$6*(A108-1))^(1/$B$6)","v":88.459909547311682},2690.6555820640638,322800.92514850065]
[{"$f":"A108+1/12","v":6.4999999999999938},87.699473619809226,{"$f":"B109*(365/12)","v":2667.5256559358641},{"$f":"C109+D108","v":325468.45080443652}]
[6.5833333333333268,86.956185856322776,2644.9173197964847,328113.36812423298]
[6.6666666666666599,86.229426911323586,2622.8117352194258,330736.17985945242]
[6.7499999999999929,85.51860798100023,2601.1909927554238,333337.37085220782]
[6.8333333333333259,84.823168905023437,2580.0380541944628,335917.4089064023]
[6.916666666666659,84.142576410012879,2559.3366991378916,338476.74560554017]
[6.999999999999992,83.476322482404271,2539.0714755064632,341015.81708104664]
[7.083333333333325,82.823922859627885,2519.2276536470149,343535.04473469366]
[7.1666666666666581,82.184915629590208,2499.7911837333691,346034.83591842704]
[7.2499999999999911,81.558859929413018,2480.7486561863129,348515.58457461337]
[7.3333333333333242,80.945334735242909,2462.0872648636387,350977.67183947703]
[7.4166666666666572,80.343937735712956,2443.7947727946025,353421.46661227162]
[7.4999999999999902,79.754284282324448,2425.8594802540356,355847.32609252568]
[7.5833333333333233,79.176006410634272,2408.2701949901257,358255.59628751583]
[7.6666666666666563,78.608751926685301,2391.016204436678,360646.61249195249]
[7.7499999999999893,78.052183553615308,2374.0872497557989,363020.69974170829]
[7.8333333333333224,77.505978133826744,2357.4735015705637,365378.17324327887]
[7.9166666666666554,76.969825882503429,2341.1655372594796,367719.33878053835]
[7.9999999999999885,76.443429688624192,2325.1543196956527,370044.49310023402]
[8.0833333333333215,75.926504459951104,2309.4311773235127,372353.92427755753]
[8.1666666666666554,75.418776508768886,2293.9877854750539,374647.91206303256]
[8.2499999999999893,74.919982975420197,2278.8161488356977,376926.72821186826]
[8.3333333333333233,74.429871286925561,2263.9085849773192,379190.63679684559]
[8.4166666666666572,73.948198648198854,2249.2577088827152,381439.89450572833]
[8.4999999999999911,73.474731563570003,2234.8564183919211,383674.75092412025]
[8.583333333333325,73.009245386509548,2220.6978805063322,385895.44880462659]
[8.666666666666659,72.551523895616555,2206.7755184916705,388102.22432311828]
[8.7499999999999929,72.101358895083436,2193.0829997254546,390295.30732284376]
[8.8333333333333268,71.658549837988872,2179.6142242388282,392474.9215470826]
[8.9166666666666607,71.222903470897919,2166.3633139064787,394641.28486098908]
[8.9999999999999947,70.794233498362487,2153.3246022418589,396794.60946323094]
[9.0833333333333286,70.372360266022611,2140.492624758188,398935.1020879891]
[9.1666666666666625,69.957110461104591,2127.8621098585982,401062.9641978477]
[9.2499999999999964,69.548316829201696,2115.4279702215517,403178.39216806926]
[9.3333333333333304,69.145817906303932,2103.185294650078,405281.57746271935]
[9.4166666666666643,68.749457765118976,2091.1293403557024,407372.70680307504]
[9.4999999999999982,68.359085774793968,2079.2555256499832,409451.96232872503]
[9.5833333333333321,67.974556373212039,2067.5594230185329,411519.52175174357]
[9.6666666666666661,67.595728851095089,2056.0367525541424,413575.55850429769]
[9.75,67.222467147198046,2044.6833757272739,415620.24188002496]
[9.8333333333333339,66.854639653929112,2033.4952894736773,417653.73716949864]
[9.9166666666666679,66.492119032776102,2022.4686205802732,419676.20579007891]
[10.000000000000002,66.134782038961347,2011.5996203517411,421687.80541043065]
[10.083333333333336,65.782509354785716,2000.8846595413991,423688.69006997207]
[10.16666666666667,65.435185431159312,1990.3202235310957,425679.01029350318]
[10.250000000000004,65.092698336848443,1979.9029077458069,427658.91320124897]
[10.333333333333337,64.754939615000467,1969.6294132895976,429628.54261453857]
[10.416666666666671,64.421804146535337,1959.4965427904499,431588.03915732901]
[10.500000000000005,64.093190020020614,1949.5011964422938,433537.5403537713]
[10.583333333333339,63.768998407669542,1939.6403682332821,435477.18072200456]
[10.666666666666673,63.44913344712598,1929.9111423500819,437407.09186435462]
[10.750000000000007,63.133502128720508,1920.3106897485823,439327.40255410317]
[10.833333333333341,62.822014187901523,1910.8362648820048,441238.23881898518]
[10.916666666666675,62.514582002563813,1901.4852025779828,443139.72402156313]
[11.000000000000009,62.211120495013958,1892.2549150566747,445031.97893661982]
[11.083333333333343,61.911547038327662,1883.1428890824664,446915.12182570231]
[11.166666666666677,61.615781366869101,1874.1466832422686,448789.2685089446]
[11.250000000000011,61.323745490755748,1865.2639253438208,450654.53243428841]
[11.333333333333345,61.035363614065751,1856.4923099278333,452511.02474421624]
[11.416666666666679,60.750562056595626,1847.829595888117,454358.85434010433]
[11.500000000000012,60.469269178988817,1839.2736041942433,456198.12794429855]
[11.583333333333346,60.191415311064844,1830.8222157115558,458028.95016001014]
[11.66666666666668,59.916932683188953,1822.4733691136641,459851.42352912377]
[11.750000000000014,{"$f":"$B$4/(1+$B$5*$B$6*(A172-1))^(1/$B$6)","v":59.64575536053173},1814.2250588828401,461665.64858800662]
[{"$f":"A172+1/12","v":11.833333333333348},59.377819180076195,{"$f":"B173*(365/12)","v":1806.0753333939842},{"$f":"C173+D172","v":463471.72392140061}]
[11.916666666666682,59.113061690237785,1798.022293078066,465269.74621447868]
[12.000000000000016,58.851422092970878,1790.0640886611977,467059.81030313991]
[12.08333333333335,58.59284118824182,1782.1989194756889,468842.00922261557]
[12.166666666666684,58.337261320755267,1774.4250318396394,470616.43425445521]
[12.250000000000018,58.084626328826864,1766.7407175018172,472383.17497195705]
[12.333333333333352,57.834881495301296,1759.1443121487478,474142.31928410579]
[12.416666666666686,57.587973500419409,1751.6341939710903,475893.9534780769]
[12.50000000000002,57.343850376544715,1744.2087822865685,477638.16226036346]
[12.583333333333353,57.102461464662468,1736.8665362168167,479375.02879658027]
[12.666666666666687,56.863757372570795,1729.605953415695,481104.63474999595]
[12.750000000000021,56.627689934686479,1722.4255688467138,482827.06031884265]
[12.833333333333355,56.394212173392667,1715.3239536073604,484542.38427245]
[12.916666666666689,56.163278261859006,1708.2997137982115,486250.68398624822]
[13.000000000000023,55.934843488268719,1701.3514894348402,487952.03547568305]
[13.083333333333357,55.708864221390243,1694.47795340062,489646.51342908369]
[13.166666666666691,55.485297877434377,1687.677810438629,491334.1912395223]
[13.250000000000025,55.264102888140535,1680.9497961809413,493015.14103570324]
[13.333333333333359,55.045238670038756,1674.292676213679,494689.43371191691]
[13.416666666666693,54.828665594837283,1667.7052451763007,496357.13895709318]
[13.500000000000027,54.614344960886477,1661.1863258936305,498018.3252829868]
[13.583333333333361,54.402238965674151,1654.7347685392556,499673.06005152606]
[13.666666666666694,54.192310679308235,1648.349449828959,501321.40950135502]
[13.750000000000028,53.984524018945379,1642.0292722429219,502963.43877359794]
[13.833333333333362,53.778843724125935,1635.7731632754972,504599.21193687344]
[13.916666666666696,53.575235332977698,1629.5800747114051,506228.79201158485]
[14.00000000000003,53.37366515925261,1623.4489819272669,507852.2409935121]
[14.083333333333364,53.17410027016232,1617.3788832174373,509469.61987672956]
[14.166666666666698,52.976508464979851,1611.3687991431373,511080.98867587268]
[14.250000000000032,52.780858254376703,1605.4177719039581,512686.40644777665]
[14.333333333333366,52.58711884046528,1599.524864730819,514285.93131250748]
[14.4166666666667,52.395260097519085,1593.6891612995389,515879.62047380704]
[14.500000000000034,52.205252553343122,1587.9097651641866,517467.53023897123]
[14.583333333333368,52.017067371269157,1582.1857992094369,519049.71603818069]
[14.666666666666702,51.830676332751175,1576.5164051211816,520626.23244330188]
[14.750000000000036,51.646051820537636,1570.9007428746866,522197.13318617659]
[14.833333333333369,51.463166802398163,1565.3379902396109,523762.47117641621]
[14.916666666666703,51.281994815383058,1559.8273423012347,525322.29851871741]
[15.000000000000037,51.102509950595582,1554.3680109972825,526876.66652971471]
[15.083333333333371,50.924686838456935,1548.9592246697318,528425.62575438444]
[15.166666666666705,50.748500634445811,1543.6002276310601,529969.22598201549]
[15.250000000000039,50.57392700529406,1538.290279744361,531507.5162617598]
[15.333333333333373,50.400942115621881,1533.0286560168322,533040.5449177766]
[15.416666666666707,50.229522614995702,1527.8146462061193,534568.3595639827]
[15.500000000000041,50.059645625393372,1522.6475544390485,536091.00711842172]
[15.583333333333375,49.891288729061628,1517.5266988422914,537608.53381726402]
[15.666666666666709,49.724429956751131,1512.4514111845135,539120.98522844852]
[15.750000000000043,49.559047776315822,1507.4210365296062,540628.40626497811]
[15.833333333333377,49.39512108166295,1502.4349329005815,542130.8411978787]
[15.91666666666671,49.232629182041315,1497.4924709537568,543628.33366883243]
[16.000000000000043,49.071551791655509,1492.5930336628551,545120.92670249532]
[16.083333333333375,48.911869019594768,1487.7360160126743,546608.66271850804]
[16.166666666666707,48.753561360064822,1482.9208247019717,548091.58354321006]
[16.250000000000039,48.596609682912487,1478.1468778552548,549569.73042106535]
[16.333333333333371,48.440995224432477,1473.4136047431546,551043.14402580855]
[16.416666666666703,48.286699578446637,1468.7204455110852,552511.8644713196]
[16.500000000000036,48.133704687646151,1464.0668509159038,553975.9313222355]
[16.583333333333368,47.981992835187647,1459.4522820702909,555435.3836043058]
[16.6666666666667,47.831546636534398,1454.8762101945879,556890.25981450034]
[16.750000000000032,47.682349031534294,1450.3381163758347,558340.59793087619]
[16.833333333333364,47.534383276726622,1445.8374913337682,559786.43542220991]
[16.916666666666696,47.387632937869654,1441.3738351935353,561227.80925740348]
[17.000000000000028,47.242081882681902,1436.9466572649078,562664.75591466844]
[17.083333333333361,{"$f":"$B$4/(1+$B$5*$B$6*(A236-1))^(1/$B$6)","v":47.097714273789634},1432.5554758277681,564097.31139049621]
[{"$f":"A236+1/12","v":17.166666666666693},46.954514561873921,{"$f":"B237*(365/12)","v":1428.1998179236653},{"$f":"C237+D236","v":565525.51120841992}]
[17.250000000000025,46.812467479010664,1423.8792191532411,566949.39042757312]
[17.333333333333357,46.671558032196891,1419.5932234793222,568368.98365105246]
[17.416666666666689,46.531771497057719,1415.3413830355057,569784.32503408799]
[17.500000000000021,46.393093411727534,1411.123257940046,571195.44829202804]
[17.583333333333353,46.255509570900273,1406.9384161148835,572602.38670814293]
[17.666666666666686,46.119006020042754,1402.7864331096339,574005.1731412526]
[17.750000000000018,45.983569049766366,1398.6668919303936,575403.84003318299]
[17.83333333333335,45.849185190351633,1394.5793828731955,576798.41941605613]
[17.916666666666682,45.715841206420961,1390.5235033619711,578188.9429194181]
[18.000000000000014,45.583524091754875,1386.4988577908775,579575.44177720894]
[18.083333333333346,45.452221064247134,1382.5050573708504,580957.94683457981]
[18.166666666666679,45.321919560994381,1378.5417199802457,582336.48855456]
[18.250000000000011,45.192607233516178,1374.6084700194504,583711.09702457942]
[18.333333333333343,45.064271943101318,1370.7049382693317,585081.80196284875]
[18.416666666666675,44.936901756276484,1366.8307617534097,586448.63272460212]
[18.500000000000007,44.810484940393501,1362.9855836036356,587811.61830820574]
[18.583333333333339,44.685009959331587,1359.1690529296691,589170.78736113536]
[18.666666666666671,44.560465469310941,1355.3808246915412,590526.16818582686]
[18.750000000000004,44.436840314814631,1351.6205595756117,591877.78874540247]
[18.833333333333336,44.314123524614864,1347.8879238737022,593225.6766692762]
[18.916666666666668,44.192304307901274,1344.1825893653304,594569.85925864149]
[19,44.071372050507527,1340.5042332029373,595910.36349184439]
[19.083333333333332,43.951316311233732,1336.8525378000261,597247.21602964436]
[19.166666666666664,43.832126818261443,1333.2271907221188,598580.44322036649]
[19.249999999999996,43.713793465658817,1329.6278845804557,599910.0711049469]
[19.333333333333329,43.596306309973244,1326.0543169283528,601236.12542187527]
[19.416666666666661,43.479655566908654,1322.5061901601382,602558.63161203545]
[19.499999999999993,43.363831608085121,1318.9832114125891,603877.61482344801]
[19.583333333333325,43.248824957878682,1315.4850924688099,605193.0999159168]
[19.666666666666657,43.134626290338502,1312.0115496644628,606505.11146558123]
[19.749999999999989,43.021226426179616,1308.5623037962966,607813.67376937752]
[19.833333333333321,42.908616329848819,1305.1370800329016,609118.81084941037]
[19.916666666666654,42.796787106661746,1301.7356078276282,610420.54645723803]
[19.999999999999986,42.685730000009066,1298.3576208336092,611718.90407807159]
[20.083333333333318,42.57543638862979,1295.0028568208229,613013.90693489241]
[20.16666666666665,42.465897783949913,1291.6710575951433,614305.57799248758]
[20.249999999999982,42.357105827484382,1288.3619689193167,615593.93996140687]
[20.333333333333314,42.249052288300916,1285.0753404358195,616879.01530184271]
[20.416666666666647,42.141729060543462,1281.8109255915303,618160.82622743421]
[20.499999999999979,42.035128161014327,1278.5684815641857,619439.39470899838]
[20.583333333333311,41.929241726812549,1275.3477691905484,620714.74247818894]
[20.666666666666643,41.824062013027742,1272.1485528962605,621986.89103108516]
[20.749999999999975,41.719581390487299,1268.970600627322,623255.86163171253]
[20.833333333333307,41.615792343555839,1265.8136837831569,624521.6753154957]
[20.916666666666639,41.512687467985437,1262.6775771512237,625784.35289264692]
[20.999999999999972,41.410259468814985,1259.5620588431225,627043.91495149001]
[21.083333333333304,41.308501158317867,1256.4669102321684,628300.38186172221]
[21.166666666666636,41.207405453996117,1253.391915892382,629553.77377761458]
[21.249999999999968,41.106965376620153,1250.3368635388631,630804.11064115341]
[21.3333333333333,41.007174048312848,1247.3015439695159,632051.41218512296]
[21.416666666666632,40.908024690676612,1244.2857510080803,633295.69793613104]
[21.499999999999964,40.809510622962499,1241.2892814484428,634536.9872175795]
[21.583333333333297,40.71162526027998,1238.3119350001828,635775.29915257974]
[21.666666666666629,40.614362111846873,1235.3535142353423,637010.65266681509]
[21.749999999999961,40.517714779277725,1232.4138245363642,638243.06649135146]
[21.833333333333293,40.421676954909927,1229.492674045177,639472.55916539661]
[21.916666666666625,40.326242420166793,1226.5898736134066,640699.14903901005]
[21.999999999999957,40.231405043956315,1223.7052367536712,641922.85427576373]
[22.08333333333329,40.13715878110488,1220.8385795919401,643143.69285535568]
[22.166666666666622,40.043497670824877,1217.9897208209234,644361.68257617659]
[22.249999999999954,39.950415835215615,1215.1584816544751,645576.84105783107]
[22.333333333333286,39.857907477796381,1212.3446857829733,646789.1857436141]
[22.416666666666618,{"$f":"$B$4/(1+$B$5*$B$6*(A300-1))^(1/$B$6)","v":39.765966882071112},1209.5481593296631,647998.73390294379]
[{"$f":"A300+1/12","v":22.49999999999995},39.674588410123562,{"$f":"B301*(365/12)","v":1206.7687308079251},{"$f":"C301+D300","v":649205.50263375172}]
[22.583333333333282,39.583766501242692,1204.0062310794654,650409.50886483118]
[22.666666666666615,39.493495670576834,1201.2604933133787,651610.76935814461]
[22.749999999999947,39.403770507816724,1198.5313529460921,652809.30071109068]
[22.833333333333279,39.314585675905846,1195.8186476421363,654005.11935873283]
[22.916666666666611,39.225935909778201,1193.1222172557536,655198.24157598859]
[22.999999999999943,39.137816015122169,1190.4419037932994,656388.68347978184]
[23.083333333333275,39.050220867170317,1187.7775513764304,657576.46103115822]
[23.166666666666607,38.963145409514205,1185.1290062060571,658761.59003736428]
[23.24999999999994,38.87658465294367,1182.4961165270367,659944.08615389129]
[23.333333333333272,38.79053367431009,1179.8787325935987,661123.9648864849]
[23.416666666666604,38.704987615412939,1177.276706635477,662301.24159312039]
[23.499999999999936,38.619941681909125,1174.689892824736,663475.93148594513]
[23.583333333333268,38.5353911422444,1172.1181472432672,664648.04963318841]
[23.6666666666666,38.45133132660667,1169.5613278509529,665817.61096103932]
[23.749999999999932,38.367757625900424,1167.0192944544713,666984.6302554938]
[23.833333333333265,38.284665490741581,1164.4919086767231,668149.12216417049]
[23.916666666666597,38.202050430472944,1161.9790339268854,669311.10119809734]
[23.999999999999929,38.119908012198898,1159.4805353710499,670470.58173346834]
[24.083333333333261,38.038233859839771,1156.9962799034597,671627.57801337179]
[24.166666666666593,37.957023653204537,1154.5261361183047,672782.10414949013]
[24.249999999999925,37.876273127082364,1152.0699742820887,673934.17412377219]
[24.333333333333258,37.795978070351637,1149.6276663065289,675083.80179007875]
[24.41666666666659,37.716134325106729,1147.1990857219964,676231.00087580073]
[24.499999999999922,37.636737785801877,1144.7841076514737,677375.78498345218]
[24.583333333333254,37.55778439841162,1142.3826087850202,678518.16759223724]
[24.666666666666586,37.479270159607687,1139.9944673547338,679658.16205959197]
[24.749999999999918,37.401191115951903,1137.6195631102037,680795.78162270214]
[24.83333333333325,37.323543363104449,1135.2577772944271,681931.03939999652]
[24.916666666666583,37.246323045047554,1132.9089926201964,683063.9483926167]
[24.999999999999915,37.169526353324116,1130.5730932469419,684194.5214858636]
[25.083333333333247,37.09314952629061,1128.2499647580062,685322.77145062166]
[25.166666666666579,37.017188848384535,1125.939494138363,686448.71094476001]
[25.249999999999911,36.941640649405642,1123.641569752755,687572.35251451272]
[25.333333333333243,36.866501303810701,1121.3560813242423,688693.708595837]
[25.416666666666575,36.791767230021698,1119.0829199131599,689812.79151575011]
[25.499999999999908,36.717434889746912,1116.8219778964685,690929.61349364661]
[25.58333333333324,36.64350078731475,1114.5731489474904,692044.18664259405]
[25.666666666666572,36.569961469020171,1112.3363280160302,693156.52297061007]
[25.749999999999904,36.496813522482995,1110.1114113088579,694266.63438191894]
[25.833333333333236,36.424053576018274,1107.8982962705559,695374.53267818945]
[25.916666666666568,36.351678298018356,1105.6968815647251,696480.22955975414]

{"sheet":"Gas Decline","index":3,"n_rows":342,"n_cols":7,"rows_kept":342,"cut":false,"hidden":false,"merged":[[40,0,40,1],[7,1,7,6],[1,0,1,1],[2,3,2,10],[3,3,3,10],[4,3,4,10],[5,3,5,10]]}
[]
["Curve Fitting",null,null,"Instructions:"]
["Parameter","Value",null,"1.) Make sure that macros are enabled and fillout the pink cells with the appropriate values."]
["IP =",{"$f":"'Production Economics'!X8","v":838.2},null,"2a.) Press Command+Option+s and the solver will fit the smooth curve to the data you have provided"]
["D_i =",1.7009354086247042,null,"2b.) If Macro in 2a does not work use the solver add in to minimize cell G35 by changing cells B5 and B6."]
["b =",1.66066536582352,null,"3.) After a solution is reached the ladder chart below will reflect this new fitted curve. "]
[]
[null,"Curve Characteristics"]
["Year","Annual Decline (%)","Begin Production (Mcfd)","End Production (Mcfd)","Average Production (Mcfd)","Calculated","Squared Residual"]
[1,{"$f":"'Production Economics'!T18*100","v":55.000000000000007},{"$f":"B4","v":838.2},{"$f":"C10*(1-B10/100)","v":377.19},{"$f":"(C10+D10)/2","v":607.69500000000005},{"$f":"$B$4/(1+$B$5*$B$6*($A10-1))^(1/$B$6)","v":838.2},{"$f":"(F10-C10)^2","v":0}]
[2,{"$f":"'Production Economics'!T19*100","v":30},{"$f":"D10","v":377.19},{"$f":"C11*(1-B11/100)","v":264.03299999999996},{"$f":"(C11+D11)/2","v":320.61149999999998},373.70340719594577,{"$f":"(F11-C11)^2","v":12.156329381282708}]
[3,{"$f":"'Production Economics'!T20*100","v":20},{"$f":"D11","v":264.03299999999996},{"$f":"C12*(1-B12/100)","v":211.22639999999998},237.62969999999996,267.85229955503672,14.587049091104024]
[4,{"$f":"'Production Economics'!T21*100","v":15},211.22639999999998,179.54243999999997,195.38441999999998,216.42566264808684,27.032332083791168]
[5,{"$f":"'Production Economics'!T22*100","v":10},179.54243999999997,161.58819599999998,170.56531799999999,184.95590714804831,29.305626562998633]
[6,{"$f":"'Production Economics'!T23*100","v":9},161.58819599999998,147.04525835999999,154.31672717999999,163.30511836248834,2.9478223988126162]
[7,{"$f":"'Production Economics'!T24*100","v":7.0000000000000009},147.04525835999999,136.75209027479997,141.89867431739998,147.30497213024233,6.7451242453492238E-2]
[8,{"$f":"'Production Economics'!T25*100","v":6},136.75209027479997,128.54696485831195,132.64952756655595,134.89443860968544,3.4508697089027902]
[9,{"$f":"'Production Economics'!T26*100","v":5},128.54696485831195,122.11961661539635,125.33329073685415,124.92563668810919,13.11401771630406]
[10,{"$f":"'Production Economics'!T27*100","v":5},122.11961661539635,116.01363578462653,119.06662620001144,116.70338128712628,29.335605131200861]
[11,{"$f":"'Production Economics'!T28*100","v":5},116.01363578462653,110.2129539953952,113.11329489001086,109.77953243612811,38.864044559759243]
[12,{"$f":"'Production Economics'!T29*100","v":5},110.2129539953952,104.70230629562543,107.45763014551031,103.85087700152023,40.476023675993105]
[13,{"$f":"'Production Economics'!T30*100","v":5},104.70230629562543,99.467190980844151,102.0847486382348,98.704169496856366,35.977645056747633]
[14,{"$f":"'Production Economics'!T31*100","v":5},99.467190980844151,94.493831431801937,96.980511206323044,94.184616215505088,27.905596151397063]
[15,{"$f":"'Production Economics'!T32*100","v":5},94.493831431801937,89.769139860211837,92.131485646006894,90.176849786098458,18.636330529340714]
[16,{"$f":"'Production Economics'!T33*100","v":5},89.769139860211837,85.280682867201236,87.524911363706536,86.592944971286926,10.08821397243273]
[17,{"$f":"'Production Economics'!T34*100","v":5},85.280682867201236,81.016648723841172,83.148665795521197,83.364594560913531,3.671394397492485]
[18,{"$f":"'Production Economics'!T35*100","v":5},81.016648723841172,76.965816287649105,78.991232505745131,80.437842607920487,0.33501651982718916]
[19,{"$f":"'Production Economics'!T36*100","v":5},76.965816287649105,73.117525473266653,75.041670880457872,77.769444135488854,0.64581771782354702]
[20,{"$f":"'Production Economics'!T37*100","v":5},{"$f":"D28","v":73.117525473266653},69.461649199603315,71.289587336434977,75.324290248871193,4.8698107748489567]
[21,{"$f":"'Production Economics'!T38*100","v":5},69.461649199603315,{"$f":"C30*(1-B30/100)","v":65.988566739623153},67.725107969613234,73.073549396873034,13.045823035037035]
[22,{"$f":"'Production Economics'!T39*100","v":5},65.988566739623153,{"$f":"C31*(1-B31/100)","v":62.689138402641994},64.338852571132577,70.993301133218466,25.047366350435851]
[23,{"$f":"'Production Economics'!T40*100","v":5},62.689138402641994,{"$f":"C32*(1-B32/100)","v":59.554681482509892},61.12190994257594,69.063515524487613,40.632683691508838]
[24,{"$f":"'Production Economics'!T41*100","v":5},59.554681482509892,{"$f":"C33*(1-B33/100)","v":56.576947408384392},58.065814445447145,67.267279596554047,59.48416966875746]
[25,{"$f":"'Production Economics'!T42*100","v":5},{"$f":"D33","v":56.576947408384392},{"$f":"C34*(1-B34/100)","v":53.748100037965166},55.162523723174779,65.59020326390214,81.238781117024971]
[26,null,null,null,null,64.019957613266669,{"$f":"SUM(G10:G34)","v":532.91582053527713}]
[]
[]
[]
["It is not necessary to edit below this line."]
[]
["Typical Production Curve"]
["Year","Monthly Production (Mcfd)","Monthly Production (Mcf)","Cumulative Production (Mcf)"]
[1,{"$f":"$B$4/(1+$B$5*$B$6*(A43-1))^(1/$B$6)","v":838.2},{"$f":"B43*(365/12)","v":25495.250000000004},{"$f":"C43","v":25495.250000000004}]
[{"$f":"A43+1/12","v":1.0833333333333333},{"$f":"$B$4/(1+$B$5*$B$6*(A44-1))^(1/$B$6)","v":738.01649941362109},{"$f":"B44*(365/12)","v":22448.001857164309},{"$f":"C44+D43","v":47943.251857164316}]
[{"$f":"A44+1/12","v":1.1666666666666665},664.43974587098978,{"$f":"B45*(365/12)","v":20210.042270242608},{"$f":"C45+D44","v":68153.294127406931}]
[1.2499999999999998,607.6185360749372,18481.730472279341,86635.024599686265]
[1.333333333333333,562.12405872420572,17097.940119527924,103732.96471921419]
[1.4166666666666663,524.69365077234454,15959.431877658813,119692.396596873]
[1.4999999999999996,493.23634209367731,15002.605405349352,134695.00200222235]
[1.5833333333333328,466.3438688994039,14184.62601235687,148879.62801457921]
[1.6666666666666661,443.02949693240913,13475.480531694111,162355.10854627332]
[1.7499999999999993,422.57915836357148,12853.4494002253,175208.55794649862]
[1.8333333333333326,404.46203193275005,12302.386804621148,187510.94475111976]
[1.9166666666666659,388.27445023964702,11810.014528122598,199320.95927924235]
[1.9999999999999991,373.70340719594589,11366.811968876687,210687.77124811904]
[2.0833333333333326,360.50206736246724,10965.27121560838,221653.04246372741]
[2.1666666666666661,348.47288283717728,10599.38351963081,232252.42598335823]
[2.2499999999999996,337.45567880024623,10264.276896840824,242516.70288019907]
[2.333333333333333,327.31907031223017,9955.9550553303343,252472.65793552939]
[2.4166666666666665,317.9541647976622,9671.1058459288924,262143.76378145828]
[2.5,309.26986539633344,9406.9584058051423,271550.72218726343]
[2.5833333333333335,301.18931637927375,9161.1750398695767,280711.89722713298]
[2.666666666666667,293.64717694329585,8931.7682986919153,289643.66552582488]
[2.7500000000000004,286.58750494942814,8717.0366088784394,298360.70213470334]
[2.8333333333333339,279.96209594961113,8515.5137518006723,306876.21588650404]
[2.9166666666666674,273.7291663316056,8325.9288092530041,315202.14469575707]
[3.0000000000000009,267.85229955503672,8147.1741114657007,323349.31880722276]
[3.0833333333333344,262.29959566446894,7978.2793681275971,331327.59817535034]
[3.1666666666666679,257.04297940325404,7818.3906235156437,339145.98879886599]
[3.2500000000000013,252.05763319421158,7666.7530096572691,346812.74180852325]
[3.3333333333333348,247.32152925749205,7522.696514915383,354335.43832343863]
[3.4166666666666683,242.81504105618797,7385.6241654590513,361721.0624888977]
[3.5000000000000018,238.52061868432463,7255.0021516482075,368976.06464054593]
[3.5833333333333353,234.42251614980515,7130.3515328899066,376106.41617343581]
[3.6666666666666687,230.5065610461028,7011.2412318189608,383117.65740525478]
[3.7500000000000022,226.7599590575243,6897.282087999698,390014.93949325447]
[3.8333333333333357,223.17112725270997,6788.1217872699281,396803.06128052442]
[3.9166666666666692,219.72955129819124,6683.4405186533168,403486.50179917773]
[4.0000000000000027,216.42566264808679,6582.9472388793065,410069.44903805701]
[4.0833333333333357,213.25073249655281,6486.3764467701485,416555.82548482716]
[4.1666666666666687,210.19677986065884,6393.4853874283735,422949.31087225553]
[4.2500000000000018,207.25649162628744,6304.0516202995768,429253.36249255511]
[4.3333333333333348,204.423152763774,6217.8708965647929,435471.23338911991]
[4.4166666666666679,201.69058522266758,6134.7553005228056,441605.98868964269]
[4.5000000000000009,199.05309426111512,6054.5316171089189,447660.5203067516]
[4.5833333333333339,196.50542116648111,5977.0398938138005,453637.56020056538]
[4.666666666666667,194.0427014889199,5902.1321702879804,459539.69237085339]
[4.75,191.66042804575909,5829.6713530585057,465369.36372391187]
[4.833333333333333,189.35441806729264,5759.5302162134849,471128.89394012536]
[4.9166666666666661,187.12078394832486,5691.5905117615475,476820.48445188691]
[4.9999999999999991,184.95590714804831,5625.7421757531365,482446.22662764002]
[5.0833333333333321,182.85641484639964,5561.8826182446564,488008.1092458847]
[5.1666666666666652,180.81915902015456,5499.9160868630343,493508.02533274773]
[5.2499999999999982,178.84119764853381,5439.7530951429035,498947.77842789062]
[5.3333333333333313,176.9197777974592,5381.309908006051,504329.08833589667]
[5.4166666666666643,175.05232036502983,5324.5080777696576,509653.59641366632]
[5.4999999999999973,173.23640629926717,5269.2740249360431,514922.87043860235]
[5.5833333333333304,171.46976412350602,5215.5386587566418,520138.40909735899]
[5.6666666666666634,169.75025862564945,5163.2370331968377,525301.64613055578]
[5.7499999999999964,168.07588058541427,5112.3080344730179,530413.95416502876]
[5.8333333333333295,166.44473742911416,5062.6940968022227,535476.64826183103]
[5.9166666666666625,164.85504471484759,5014.3409434099476,540490.98920524097]
[5.9999999999999956,163.30511836248843,4967.1973501923567,545458.18655543332]
[6.0833333333333286,161.79336755287932,4921.2149297334126,550379.40148516675]
[6.1666666666666616,160.31828822933267,4876.3479336422024,555255.74941880896]
[6.2499999999999947,158.87845714212798,4832.5530714063934,560088.3024902154]
[6.3333333333333277,157.47252638332003,4789.7893441593178,564878.0918343747]
[6.4166666666666607,{"$f":"$B$4/(1+$B$5*$B$6*(A108-1))^(1/$B$6)","v":156.09921836497534},4748.0178919346672,569626.10972630943]
[{"$f":"A108+1/12","v":6.4999999999999938},154.75732119904038,{"$f":"B109*(365/12)","v":4707.2018531374779},{"$f":"C109+D108","v":574333.31157944689}]
[6.5833333333333268,153.44568444151918,4667.3062350962082,579000.61781454307]
[6.6666666666666599,152.16321516757532,4628.2977946804158,583628.91560922354]
[6.7499999999999929,150.90887434764724,4590.1449280742709,588219.06053729786]
[6.8333333333333259,149.68167349773944,4552.8175688895744,592771.87810618745]
[6.916666666666659,148.48067157976641,4516.2870938845617,597288.16520007199]
[6.999999999999992,147.30497213024245,4480.5262356282083,601768.69143570017]
[7.083333333333325,146.15372059774822,4445.5090015148417,606214.20043721504]
[7.1666666666666581,145.0261018715147,4411.2105985919052,610625.41103580699]
[7.2499999999999911,143.92133798516005,4377.6073637152849,615003.01839952229]
[7.3333333333333242,142.83868598113443,4344.6766985928389,619347.69509811513]
[7.4166666666666572,141.77743592277966,4312.3970093178814,623660.09210743301]
[7.4999999999999902,140.73690904212714,4280.7476500313669,627940.83975746436]
[7.5833333333333233,139.71645601264095,4249.7088703844956,632190.54862784885]
[7.6666666666666563,138.71545533709249,4219.2617665032303,636409.81039435207]
[7.7499999999999893,137.73331184162831,4189.3882351828615,640599.19862953492]
[7.8333333333333224,136.76945526788367,4160.0709310647953,644759.2695605997]
[7.9166666666666554,135.82333895570468,4131.2932265693507,648890.56278716901]
[7.9999999999999885,134.89443860968555,4103.0391743779355,652993.60196154693]
[8.0833333333333215,133.9822511433056,4075.2934722755458,657068.89543382253]
[8.1666666666666554,133.08629359497786,4048.0414301805768,661116.93686400307]
[8.2499999999999893,132.20610211079315,4021.2689392032921,665138.20580320642]
[8.3333333333333233,131.34123098917692,3994.9624425874649,669133.1682457939]
[8.4166666666666572,130.49125178306517,3969.1089084015657,673102.27715419547]
[8.4999999999999911,129.65575245556181,3943.6958038566718,677045.97295805218]
[8.583333333333325,128.83433658536259,3918.7110711381124,680964.68402919034]
[8.666666666666659,128.02662261852447,3894.143104646786,684858.82713383716]
[8.7499999999999929,127.23224316342743,3869.980729554251,688728.80786339135]
[8.8333333333333268,126.45084432602071,3846.2131815831303,692575.02104497445]
[8.9166666666666607,125.68208508266777,3822.8300879311446,696397.85113290558]
[8.9999999999999947,124.92563668810922,3799.8214492633224,700197.67258216895]
[9.0833333333333286,124.18118211624864,3777.177622702563,703974.8502048715]
[9.1666666666666625,123.44841553163823,3754.8893057539963,707729.73951062548]
[9.2499999999999964,122.72704178969737,3732.947521103295,711462.6870317288]
[9.3333333333333304,122.01677596384032,3711.3436022334763,715174.03063396225]
[9.4166666666666643,121.31734289782244,3690.069179808766,718864.09981377097]
[9.4999999999999982,120.62847678173478,3669.1161687777662,722533.21598254878]
[9.5833333333333321,119.94992075018794,3648.47675615155,726181.69273870031]
[9.6666666666666661,119.2814265013305,3628.1433894154698,729809.83612811577]
[9.75,118.62275393543906,3608.1087655362717,733417.94489365199]
[9.8333333333333339,117.97367081190733,3588.365820528848,737006.31071418081]
[9.9166666666666679,117.33395242353915,3568.907719549316,740575.21843373019]
[10.000000000000002,116.70338128712628,3549.7278474834243,744124.94628121366]
[10.083333333333336,116.08174684936006,3530.8198000013685,747655.766081215]
[10.16666666666667,115.4688452071891,3512.1773750520019,751167.94345626701]
[10.250000000000004,114.86447884179398,3493.7945647712336,754661.73802103824]
[10.333333333333337,114.26845636540405,3475.66554778104,758137.40356881928]
[10.416666666666671,113.68059228023246,3457.7846818570706,761595.18825067638]
[10.500000000000005,113.10070674885141,3440.1464969442304,765035.33474762063]
[10.583333333333339,112.52862537537288,3422.7456885009251,768458.08043612156]
[10.666666666666673,111.96417899684094,3405.577111153912,771863.65754727542]
[10.750000000000007,111.40720348427892,3388.6357726468173,775252.29331992229]
[10.833333333333341,110.85753955286822,3371.9168280664085,778624.21014798875]
[10.916666666666675,110.31503258076987,3355.4155743317501,781979.62572232052]
[11.000000000000009,109.77953243612805,3339.1274449322282,785318.75316725275]
[11.083333333333343,109.25089331182426,3323.0480049013213,788641.80117215402]
[11.166666666666677,108.72897356757551,3307.1729460137553,791948.97411816777]
[11.250000000000011,108.21363557899542,3291.4980821944441,795240.47220036224]
[11.333333333333345,107.70474559325861,3276.0193451282826,798516.49154549057]
[11.416666666666679,107.20217359103145,3260.7327800605403,801777.22432555107]
[11.500000000000012,106.70579315435032,3245.6345417781558,805022.8588673292]
[11.583333333333346,106.21548134014776,3230.7208907628278,808253.57975809206]
[11.66666666666668,105.73111855914453,3215.9881895073131,811469.56794759934]
[11.750000000000014,{"$f":"$B$4/(1+$B$5*$B$6*(A172-1))^(1/$B$6)","v":105.25258845984123},3201.4328989868377,814671.00084658619]
[{"$f":"A172+1/12","v":11.833333333333348},104.77977781735774,{"$f":"B173*(365/12)","v":3187.0515752779647},{"$f":"C173+D172","v":817858.05242186412}]
[11.916666666666682,104.31257642688433,3172.840866317732,821030.89328818186]
[12.000000000000016,103.85087700152012,3158.7975087962373,824189.69079697807]
[12.08333333333335,103.39457507428766,3144.9183251762497,827334.6091221543]
[12.166666666666684,102.94356890412354,3131.2002208337576,830465.80934298807]
[12.250000000000018,102.49775938565736,3117.640181313745,833583.4495243018]
[12.333333333333352,102.05704996259908,3104.2352696957223,836687.68479399756]
[12.416666666666686,101.62134654456652,3090.9826240638986,839778.66741806141]
[12.50000000000002,101.1905574271933,3077.8794550771295,842856.54687313852]
[12.583333333333353,100.76459321536561,3064.9230436340372,845921.46991677256]
[12.666666666666687,100.34336674944403,3052.1107386289227,848973.58065540146]
[12.750000000000021,99.926793034335333,3039.4399547943667,852013.02061019582]
[12.833333333333355,99.514789171284505,3026.9081706265706,855039.92878082243]
[12.916666666666689,99.10727429226587,3014.5129263897538,858054.44170721213]
[13.000000000000023,98.704169496856281,3002.2518221960454,861056.69352940819]
[13.083333333333357,98.305397791481539,2990.1225161575635,864046.81604556576]
[13.166666666666691,97.910884030930831,2978.1227226074798,867024.93876817322]
[13.250000000000025,97.520554862040242,2966.2502103870575,869991.18897856027]
[13.333333333333359,97.134338669451537,2954.5028011958179,872945.6917797561]
[13.416666666666693,96.752165523356055,2942.8783680020802,875888.57014775823]
[13.500000000000027,96.373967129139359,2931.3748335113223,878819.94498126954]
[13.583333333333361,95.999676778844659,2919.9901686898584,881739.9351499594]
[13.666666666666694,95.62922930437972,2908.7223913415501,884648.65754130099]
[13.750000000000028,95.262561032391844,2897.5695647352522,887546.22710603627]
[13.833333333333362,94.899609740743287,2886.5297962809418,890432.75690231717]
[13.916666666666696,94.540314616518998,2875.601236252453,893308.35813856963]
[14.00000000000003,94.184616215504974,2864.7820765549432,896173.14021512459]
[14.083333333333364,93.832456423075385,2854.0705495352099,899027.2107646598]
[14.166666666666698,93.4837784164326,2843.4649268331582,901870.67569149297]
[14.250000000000032,93.138526628144021,2832.9635182727143,904703.63920976571]
[14.333333333333366,92.796646710924549,2822.5646707906217,907526.20388055628]
[14.4166666666667,92.4580855036142,2812.2667674015988,910338.47064795787]
[14.500000000000034,92.122790998303685,2802.0682261984039,913140.53887415631]
[14.583333333333368,91.79071230856222,2791.9674993854342,915932.50637354178]
[14.666666666666702,91.461799638725083,2781.9630723445548,918714.46944588632]
[14.750000000000036,91.136004254198156,2772.0534627318607,921486.52290861821]
[14.833333333333369,90.813278452741656,2762.2372196042256,924248.76012822241]
[14.916666666666703,90.493575536693598,2752.5129225744304,927001.27305079682]
[15.000000000000037,90.17684978609833,2742.8791809938243,929744.15223179059]
[15.083333333333371,89.863056432704468,2733.3346331614275,932477.48686495202]
[15.166666666666705,89.552151634800197,2723.8779455585059,935201.36481051054]
[15.250000000000039,89.244092452853678,2714.5078121076326,937915.87262261822]
[15.333333333333373,88.938836825928718,2705.2229534553321,940621.09557607351]
[15.416666666666707,88.636343548846725,2696.0221162774214,943317.11769235088]
[15.500000000000041,88.336572250067078,2686.9040726062071,946004.02176495711]
[15.583333333333375,88.039483370259788,2677.8676191787354,948681.88938413584]
[15.666666666666709,87.745038141544853,2668.9115768053225,951350.80096094112]
[15.750000000000043,87.453198567373832,2660.0347897576207,954010.83575069869]
[15.833333333333377,87.163927403030712,2651.2361251755174,956662.07187587419]
[15.91666666666671,86.877188136729401,2642.5144724921861,959304.58634836634]
[16.000000000000043,86.592944971286769,2633.8687428766393,961938.45509124303]
[16.083333333333375,86.311162806350353,2625.2978686931565,964563.75295993616]
[16.166666666666707,86.031807221161159,2616.8008029769853,967180.5537629131]
[16.250000000000039,85.754844457832988,2608.3765189257533,969788.93028183887]
[16.333333333333371,85.480241405129732,2600.0240094060296,972388.95429124485]
[16.416666666666703,85.20796558272329,2591.7422864745004,974980.6965777193]
[16.500000000000036,84.937985125915645,2583.5303809132674,977564.22695863259]
[16.583333333333368,84.670268770809201,2575.38734177878,980139.61430041131]
[16.6666666666667,84.404785839908982,2567.3122359638983,982706.92653637519]
[16.750000000000032,84.141506228143584,2559.3041477727006,985266.23068414791]
[16.833333333333364,83.880400389288923,2551.3621785075384,987817.59286265541]
[16.916666666666696,83.621439322782351,2543.485446067963,990361.0783087234]
[17.000000000000028,83.36459456091346,2535.6730845611178,992896.75139328453]
[17.083333333333361,{"$f":"$B$4/(1+$B$5*$B$6*(A236-1))^(1/$B$6)","v":83.109838156378885},2527.9242439231912,995424.67563720769]
[{"$f":"A236+1/12","v":17.166666666666693},82.857142670189575,{"$f":"B237*(365/12)","v":2520.2380895515998},{"$f":"C237+D236","v":997944.91372675926}]
[17.250000000000025,82.606481159917777,2512.6138019474993,1000457.5275287067]
[17.333333333333357,82.3578271682739,2505.0505763683313,1002962.5781050751]
[17.416666666666689,82.111154712000953,2497.547622490029,1005460.125727565]
[17.500000000000021,81.866438271077357,2490.1041640786029,1007950.2298916436]
[17.583333333333353,81.62365277821776,2482.7194386707902,1010432.9493303144]
[17.666666666666686,81.382773608661452,2475.3926972634526,1012908.3420275779]
[17.750000000000018,81.143776570240604,2468.1232040114851,1015376.4652315894]
[17.83333333333335,80.906637893718027,2460.9102359339236,1017837.3754675234]
[17.916666666666682,80.671334223386268,2453.753082627999,1020291.1285501514]
[18.000000000000014,80.437842607920444,2446.6510459909136,1022737.7795961422]
[18.083333333333346,80.206140491475509,2439.6034399490468,1025177.3830360913]
[18.166666666666679,79.976205705021414,2432.6095901944013,1027609.9926262858]
[18.250000000000011,79.748016457908193,2425.6688339280408,1030035.6614602138]
[18.333333333333343,79.521551329653605,2418.7805196102972,1032454.4419798241]
[18.416666666666675,79.296789261947268,2411.9440067175628,1034866.3859865416]
[18.500000000000007,79.073709550863455,2405.1586655054302,1037271.5446520471]
[18.583333333333339,78.852291839277285,2398.4238767780175,1039669.9685288251]
[18.666666666666671,78.632516109477137,2391.7390316632632,1042061.7075604884]
[18.750000000000004,78.41436267596805,2385.1035313940283,1044446.8110918824]
[18.833333333333336,78.197812178459927,2378.516787094823,1046825.3278789773]
[18.916666666666668,77.982845575034887,2371.9782195739781,1049197.3060985513]
[19,77.769444135488854,2365.4872591211192,1051562.7933576724]
[19.083333333333332,77.557589434841717,2359.0433453097689,1053921.8367029822]
[19.166666666666664,77.347263347011278,2352.6459268049266,1056274.4826297872]
[19.249999999999996,77.138448038646104,2346.2944611754856,1058620.7770909627]
[19.333333333333329,76.931125963112521,2339.9884147113394,1060960.7655056741]
[19.416666666666661,76.725279854631282,2333.727262245035,1063294.4927679191]
[19.499999999999993,76.520892722559765,2327.5104869778597,1065622.003254897]
[19.583333333333325,76.317947845814899,2321.3375803102031,1067943.3408352071]
[19.666666666666657,76.116428767433376,2315.2080416760987,1070258.5488768832]
[19.749999999999989,75.916319289264777,2309.1213783818039,1072567.670255265]
[19.833333333333321,75.717603466793975,2303.0771054483166,1074870.7473607133]
[19.916666666666654,75.520265604089019,2297.0747454577076,1077167.8221061709]
[19.999999999999986,75.32429024887125,2291.1138284031672,1079458.9359345741]
[20.083333333333318,75.129662187703317,2285.1938915426426,1081744.1298261168]
[20.16666666666665,74.936366441293231,2279.3144792560024,1084023.4443053729]
[20.249999999999982,74.744388259909528,2273.4751429055814,1086296.9194482784]
[20.333333333333314,74.553713118905691,2267.6754407000481,1088564.5948889784]
[20.416666666666647,74.364326714350312,2261.9149375614888,1090826.5098265398]
[20.499999999999979,74.17621495876007,2256.193204995619,1093082.7030315355]
[20.583333333333311,73.989363976932523,2250.5098209650309,1095333.2128525006]
[20.666666666666643,73.803760101876406,2244.8643697654074,1097578.077222266]
[20.749999999999975,73.619389870836244,2239.2564419046025,1099817.3336641707]
[20.833333333333307,73.436240021409375,2233.6856339845353,1102051.0192981553]
[20.916666666666639,73.254297487752154,2228.1515485857949,1104279.1708467412]
[20.999999999999972,73.073549396873091,2222.65379415489,1106501.8246408962]
[21.083333333333304,72.893983065011398,2217.1919848940965,1108719.0166257902]
[21.166666666666636,72.715585994097069,2211.765740653786,1110930.7823664439]
[21.249999999999968,72.538345868292197,2206.374686827221,1113137.1570532711]
[21.3333333333333,72.362250550609517,2201.0184542477064,1115338.1755075187]
[21.416666666666632,72.18728807960774,2195.6966790880688,1117533.8721866067]
[21.499999999999964,72.013446666160419,2190.4090027623797,1119724.281189369]
[21.583333333333297,71.840714690297247,2185.1550718298745,1121909.4362611989]
[21.666666666666629,71.669080698115252,2179.9345379010056,1124089.3707991]
[21.749999999999961,71.498533398758767,2174.7470575455791,1126264.1178566455]
[21.833333333333293,71.329061661465545,2169.5922922029104,1128433.7101488484]
[21.916666666666625,71.160654512678235,2164.4699080939631,1130598.1800569424]
[21.999999999999957,70.993301133218523,2159.3795761353967,1132757.5596330778]
[22.08333333333329,70.826990855523533,2154.3209718555077,1134911.8806049332]
[22.166666666666622,70.661713160941389,2149.2937753119672,1137061.1743802452]
[22.249999999999954,70.497457677086061,2144.2976710113676,1139205.4720512566]
[22.333333333333286,70.334214175248803,2139.3323478304847,1141344.8043990871]
[22.416666666666618,{"$f":"$B$4/(1+$B$5*$B$6*(A300-1))^(1/$B$6)","v":70.17197256786487},2134.3974989392232,1143479.2018980263]
[{"$f":"A300+1/12","v":22.49999999999995},70.010722906035198,{"$f":"B301*(365/12)","v":2129.4928217252373},{"$f":"C301+D300","v":1145608.6947197516}]
[22.583333333333282,69.850455377100033,2124.6180177201263,1147733.3127374717]
[22.666666666666615,69.691160302264507,2119.772792527212,1149853.0855299989]
[22.749999999999947,69.532828134274169,2114.9568557508392,1151968.0423857498]
[22.833333333333279,69.37544945513983,2110.1699209271701,1154078.2123066769]
[22.916666666666611,69.219014973909552,2105.4117054564158,1156183.6240121333]
[22.999999999999943,69.063515524487698,2100.6819305365011,1158284.3059426697]
[23.083333333333275,68.908942063499282,2095.9803210981031,1160380.2862637679]
[23.166666666666607,68.755285668198383,2091.3066057410342,1162471.592869509]
[23.24999999999994,68.602537534420122,2086.6605166719455,1164558.2533861808]
[23.333333333333272,68.450688974574618,2082.0417896433114,1166640.2951758241]
[23.416666666666604,68.299731415682103,2077.450163893664,1168717.7453397177]
[23.499999999999936,68.149656397448254,2072.8853820890513,1170790.6307218068]
[23.583333333333268,68.000455570378847,2068.3471902656902,1172858.9779120726]
[23.6666666666666,67.852120693932278,2063.8353377737735,1174922.8132498462]
[23.749999999999932,67.704643634710081,2059.3495772224319,1176982.1628270687]
[23.833333333333265,67.558016364683056,2054.8896644257766,1179037.0524914945]
[23.916666666666597,67.412230959453936,2050.4553583500574,1181087.5078498444]
[23.999999999999929,67.267279596554133,2046.046421061855,1183133.5542709064]
[24.083333333333261,67.123154553774654,2041.6626176773125,1185175.2168885837]
[24.166666666666593,66.97984820753021,2037.3037163123772,1187212.5206048961]
[24.249999999999925,66.837353031255603,2032.9694880340246,1189245.4900929302]
[24.333333333333258,66.695661593833989,2028.6597068124506,1191274.1497997425]
[24.41666666666659,66.554766558055647,2024.3741494741926,1193298.5239492166]
[24.499999999999922,66.414660679107172,2020.1125956561766,1195318.6365448728]
[24.583333333333254,66.275336803090156,2015.8748277606589,1197334.5113726335]
[24.666666666666586,66.136787865568692,2011.6606309110477,1199346.1720035446]
[24.749999999999918,65.999006890144756,2007.4697929085698,1201353.6417964532]
[24.83333333333325,65.861986987061584,2003.30210418979,1203356.9439006429]
[24.916666666666583,65.725721351833513,1999.157357784936,1205356.1012584278]
[24.999999999999915,65.590203263902282,1995.0353492770278,1207351.1366077049]
[25.083333333333247,65.455426085319019,1990.9358767617869,1209342.0724844667]
[25.166666666666579,65.321383259451281,1986.8587408083099,1211328.9312252749]
[25.249999999999911,65.188068309714794,1982.8037444204917,1213311.7349696953]
[25.333333333333243,65.055474838328863,1978.7706929991696,1215290.5056626946]
[25.416666666666575,64.923596525095732,1974.7593943049953,1217265.2650569996]
[25.499999999999908,64.792427126202398,1970.7696584219898,1219236.0347154217]
[25.58333333333324,64.661960473045312,1966.801297721795,1221202.8360131434]
[25.666666666666572,64.532190471076532,1962.854126828578,1223165.6901399719]
[25.749999999999904,64.403111098671957,1958.9279625846054,1225124.6181025566]
[25.833333333333236,64.274716406019948,1955.0226240164402,1227079.6407265731]
[25.916666666666568,64.147000514030921,1951.1379323017738,1229030.7786588748]