{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["IPR-MB-Eqs","F-IPR","F-MB","F-MBd","Pot-Aq-Gas-MB-ex"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":36,"comments":2,"pivot_tables":0},"unopened":[{"sheet":"F-IPR","index":1,"reason":"not_a_worksheet"},{"sheet":"F-MB","index":2,"reason":"not_a_worksheet"},{"sheet":"F-MBd","index":3,"reason":"not_a_worksheet"}],"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":"IPR-MB-Eqs","index":0,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["Approximate Generalized IPR (PSS Rate) and Material Balance Equations"]
["TPG4150 - Reservoir Recovery Methods"]
["Curtis Hays Whitson"]
["2018-09"]
[]
["pRi",1000,"bara"]
[]
["PSS Rate Equation"]
["J (pwf>px)",10,"Sm3/d/bar"]
["px (<=pRi)",400,"bara"]
["J' (pwf<px)",{"$f":"$B$9/(2*$B$10)","v":1.2500000000000001E-2},"Sm3/d/bar^2"]
["qmax (AOFP)",{"$f":"MAX(0,$B$9*($B$6-$B$10))+$B$11*(MIN($B$6,$B$10)^2)","v":8000},"Sm3/d"]
[]
["Material Balance",null,null,"Best-Fit Polynomial Coefficients"]
["Qpu",100,"Sm3","a0",1,"   = 1"]
["m0 (-10 to -0.1)",-3.0914264859726148,-1,"a1",{"$f":"B16","v":-3.0914264859726148},"   = m0"]
["m1 (-10 to -0.1)",-0.8638678527184338,-1,"a2",{"$f":"-3-2*B16-B17","v":4.0467208246636632},"   = -3 - 2m0 - m1"]
[null,null,null,"a3",{"$f":"B16+B17+2","v":-1.9552943386910488},"   = m1 + m0 + 2"]
["Current Conditions"]
["pR (<=pRi)",600]
["qmax (AOFP)",{"$f":"MAX(0,$B$9*($B$20-$B$10))+$B$11*(MIN($B$20,$B$10)^2)","v":4000},"Sm3/d"]
[]
[null,"For Plotting Only",null,null,null,"Fitting MB Eq",null,"Convert to (Qd,pd)",null,null,null,null,"For Plotting Only",null,"For Plotting Only"]
[null,null,null,null,null,null,null,null,null,null,"RMS"]
[null,"General Rate Eq.",null,null,null,"Actual MB Data",null,"Data","Data","MB Eq.",{"$f":"SQRT(SUM(K28:K48))","v":5.3960659447436152E-2},null,"General MB Eq.",null,"General MB Eq."]
[null,"pwf","q","Instant",null,"Qp","pR","Qd","pd","pd","residual",null,"Qd","pd","Qp","pR"]
[null,"bara","Sm3/d","PI=q/dp",null,"Sm3","bara",null,null,null,null,null,null,null,"Sm3","bara"]
[null,{"$f":"$B$20","v":600},{"$f":"q_ipr($B$9,$B$20,$B$10,B28)","v":0},null,null,0,1000,{"$f":"F28/$B$15","v":0},{"$f":"G28/$B$6","v":1},{"$f":"pd(H28,$E$15,$E$16,$E$17,$E$18)","v":1},{"$f":"(J28-I28)^2","v":0},null,{"$f":"F28","v":0},{"$f":"$E$15+$E$16*M28+$E$17*M28^2+$E$18*M28^3","v":1},{"$f":"$B$15*M28","v":0},{"$f":"pR(O28,$B$15,$E$15,$E$16,$E$17,$E$18,$B$6)","v":1000}]
[null,{"$f":"MAX(0,B28-25)","v":575},{"$f":"q_ipr($B$9,$B$20,$B$10,B29)","v":250},{"$f":"IF(B28>0,-(C29-C28)/(B29-B28),0)","v":10},null,1.4844193885544921,950,{"$f":"F29/$B$15","v":1.4844193885544921E-2},0.95,{"$f":"pd(H29,$E$15,$E$16,$E$17,$E$18)","v":0.95499556555541731},{"$f":"(J29-I29)^2","v":2.4955675218472339E-5},null,2.5000000000000001E-2,{"$f":"$E$15+$E$16*M29+$E$17*M29^2+$E$18*M29^3","v":0.92521298689205733},{"$f":"$B$15*M29","v":2.5},{"$f":"pR(O29,$B$15,$E$15,$E$16,$E$17,$E$18,$B$6)","v":925.2129868920573}]
[null,550,500,{"$f":"IF(B29>0,-(C30-C29)/(B30-B29),0)","v":10},null,3.0642947378149876,900,3.0642947378149876E-2,0.9,0.90901315163970131,8.1236902480250029E-5,null,0.05,0.85530106597069211,5,855.30106597069209]
[null,525,750,10,null,4.7525410602374363,850,4.7525410602374363E-2,0.85,0.8620089831468748,1.4421567622192343E-4,null,7.4999999999999997E-2,0.79008092839165178,7.5,790.08092839165181]
[null,500,1000,10,null,6.564822816384841,800,6.564822816384841E-2,0.8,0.81394024168135737,1.9433033813465208E-4,null,0.1,0.72936926531068413,10,729.36926531068411]
[null,475,1250,10,null,8.5203675003877049,750,8.5203675003877044E-2,0.75,0.7647674971334566,2.1807897158664883E-4,null,0.125,0.67298276788353695,12.5,672.98276788353689]
[null,450,1500,10,null,10.643092507615236,700,0.10643092507615236,0.7,0.71445871430925278,2.0905441947659251E-4,null,0.15,0.62073812726595801,15,620.73812726595804]
[null,425,1750,10,null,12.963199773774969,650,0.12963199773774969,0.65,0.66299574259034433,1.6888932547448892E-4,null,0.17499999999999999,0.57245203461369476,17.5,572.45203461369476]
[null,400,2000,10,null,15.519466003190473,600,0.15519466003190474,0.6,0.61038519724840323,1.0785232188824254E-4,null,0.2,0.52794118108249521,20,527.94118108249518]
[null,375,2242.1875,9.6875,null,18.362598173175016,550,0.18362598173175015,0.55000000000000004,0.55667675090609958,4.4579002662100996E-5,null,0.22500000000000001,0.48702225782810687,22.5,487.02225782810689]
[null,350,2468.75,9.0625,null,21.560242626574166,500,0.21560242626574166,0.5,0.50199410899310526,3.9764706763832704E-6,null,0.25,0.44951195600627758,25,449.51195600627756]
[null,325,2679.6875,8.4375,null,25.204536734126403,450,0.25204536734126404,0.45,0.44658827851026611,1.1639843523512094E-5,null,0.27500000000000002,0.415226966772755,27.500000000000004,415.22696677275502]
[null,300,2875,7.8125,null,28.087933716655243,415,0.28087933716655245,0.41499999999999998,0.40761265454741408,5.457287283584162E-5,null,0.3,0.38398398128328692,30,383.98398128328694]
[null,275,3054.6875,7.1875,null,34.396902785749241,350,0.34396902785749239,0.35,0.33585775410327923,2.0000311900331491E-4,null,0.32500000000000001,0.35559969069362091,32.5,355.59969069362097]
[null,250,3218.75,6.5625,null,40.375636399883675,300,0.40375636399883674,0.3,0.282812528183921,2.9540918742850967E-4,null,0.35,0.3298907861595049,35,329.8907861595049]
[null,225,3367.1875,5.9375,null,49.776531070708444,237.4,0.49776531070708446,0.2374,0.22270307515730434,2.1599959983184495E-4,null,0.375,0.30667395883668641,37.5,306.67395883668644]
[null,200,3500,5.3125,null,56.637935209688706,200,0.56637935209688706,0.2,0.19195927824269493,6.4653206378399307E-5,null,0.4,0.28576589988091317,40,285.76589988091314]
[null,175,3617.1875,4.6875,null,67.233977807852256,150,0.67233977807852252,0.15,0.15653100540759213,4.2654031633997683E-5,null,0.42499999999999999,0.26698330044793273,42.5,266.98330044793272]
[null,150,3718.75,4.0625,null,78.737903095553676,100,0.78737903095553674,0.1,0.12023080883772019,4.0928562622837727E-4,null,0.45,0.25014285169349326,45,250.14285169349327]
[null,125,3804.6875,3.4375,null,89.938506082257078,50,0.89938506082257075,0.05,7.0493555032276056E-2,4.1998579786092717E-4,null,0.47499999999999998,0.23506124477334223,47.5,235.06124477334222]
[null,100,3875,2.8125,null,99.81210568855272,1,0.99812105688552721,1E-3,1.6167491043377336E-3,3.8037945770139655E-7,null,0.5,0.22155517084322729,50,221.5551708432273]
[null,75,3929.6875,2.1875,null,null,null,null,null,null,null,null,0.52500000000000002,0.20944132105889618,52.5,209.44132105889619]
[null,50,3968.75,1.5625,null,null,null,null,null,null,null,null,0.55000000000000004,0.19853638657609668,55.000000000000007,198.53638657609667]
[null,25,3992.1875,0.9375,null,null,null,null,null,null,null,null,0.57499999999999996,0.18865705855057641,57.499999999999993,188.65705855057635]
[null,0,4000,0.3125,null,null,null,null,null,null,null,null,0.6,0.17962002813808331,60,179.62002813808337]
[null,0,4000,0,null,null,null,null,null,null,null,null,0.625,0.17124198649436473,62.5,171.24198649436474]
[null,0,4000,0,null,null,null,null,null,null,null,null,0.65,0.16333962477516872,65,163.33962477516883]
[null,0,4000,0,null,null,null,null,null,null,null,null,0.67500000000000004,0.15572963413624308,67.5,155.72963413624308]
[null,0,4000,0,null,null,null,null,null,null,null,null,0.7,0.14822870573333502,70,148.22870573333503]
[null,0,4000,0,null,null,null,null,null,null,null,null,0.72499999999999998,0.14065353072219244,72.5,140.65353072219244]
[null,0,4000,0,null,null,null,null,null,null,null,null,0.75,0.13282080025856347,75,132.82080025856345]
[null,0,4000,0,null,null,null,null,null,null,null,null,0.77500000000000002,0.12454720549819487,77.5,124.54720549819487]
[null,0,4000,0,null,null,null,null,null,null,null,null,0.8,0.11564943759683577,80,115.64943759683577]
[null,0,4000,0,null,null,null,null,null,null,null,null,0.82499999999999996,0.10594418771023251,82.5,105.94418771023251]
[null,0,4000,0,null,null,null,null,null,null,null,null,0.85,9.5248146994133531E-2,85,95.248146994133535]
[null,0,4000,0,null,null,null,null,null,null,null,null,0.875,8.3378006604286847E-2,87.5,83.378006604286853]
[null,0,4000,0,null,null,null,null,null,null,null,null,0.9,7.0150457696439128E-2,90,70.150457696439133]
[null,null,null,null,null,null,null,null,null,null,null,null,0.92500000000000004,5.5382191426339045E-2,92.5,55.382191426339048]
[null,null,null,null,null,null,null,null,null,null,null,null,0.95,3.8889898949733936E-2,95,38.889898949733933]
[null,null,null,null,null,null,null,null,null,null,null,null,0.97499999999999998,2.0490271422371809E-2,97.5,20.490271422371809]
[null,null,null,null,null,null,null,null,null,null,null,null,1,0,100,-4.4408920985006262E-13]

{"sheet":"Pot-Aq-Gas-MB-ex","index":4,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["POT AQUIFER GAS MATERIAL BALANCE -- Example only"]
[]
["Swc",0.25]
["cw",{"$f":"0.000005*14.5","v":7.25E-5},"1/bar"]
["cf",{"$f":"0.000005*14.5","v":7.25E-5},"1/bar"]
["M",4,null,null,"HCPV ="]
["ce",{"$f":"(B5+B4*B3+B6*(B4+B5))/(1-B3)","v":8.941666666666667E-4},"1/bar",null,"Constant","Pot Aq"]
[null,null,null,null,"RF","RF"]
[null,"p","Z","p/Z","Gp/G","Gp/G"]
[null,"bara",null,"bara","%","%"]
[]
["pRi",1000,1.876173641038043,{"$f":"B12/C12","v":532.99970649130501},{"$f":"100*(1-D12/$D$12)","v":0},{"$f":"100*(1-(D12*(1-$B$7*($B$12-B12))/$D$12))","v":0}]
[null,950,1.8092213921125351,{"$f":"B13/C13","v":525.08775550720952},{"$f":"100*(1-D13/$D$12)","v":1.4844193885544921},{"$f":"100*(1-(D13*(1-$B$7*($B$12-B13))/$D$12))","v":5.8888868050578687}]
[null,900,1.7419342773306783,516.66702453272262,3.0642947378149876,11.731962383342031]
[null,850,1.6743203573450756,507.6686765893607,4.7525410602374363,17.527606490533099]
[null,800,1.6063959614277266,498.00922014829956,6.564822816384841,23.274147002721357]
[null,750,1.538189641048783,487.58617272225803,8.5203675003877049,28.969877015405199]
[null,700,1.4697482103871544,476.27205466411772,10.643092507615236,34.613082942447448]
[null,650,1.4011462548082931,463.9058897452029,12.963199773774969,40.202091711240648]
[null,600,1.3325012655167863,450.28099824528192,15.519466003190473,45.735336996049348]
[null,550,1.2639984608523593,435.12711212410443,18.362598173175016,51.211447733243723]
[null,500,1.195932843153886,418.08367657285146,21.560242626574166,56.629350818943294]
[null,450,1.1287825512437628,398.65959967591812,25.204536734126403,61.988322272755823]
[null,415,1.0827279777540182,383.29110222206026,28.087933716655243,65.704236688644343]
[null,350,1.0009600190350016,349.66431560116206,34.396902785749241,72.525969579148565]
[null,300,0.9439968132595965,317.79768298592853,40.375636399883675,77.695519316589824]
[null,237.4,0.88684360494792736,267.69094198287576,49.776531070708444,84.023487634106459]
[null,200,0.86535253803561973,231.11967806092872,56.637935209688706,87.656265556358065]
[null,150,0.85889597615895286,174.64280211302332,67.233977807852256,92.137519924809226]
[null,100,0.88240292077951055,113.32691409459578,78.737903095553676,95.848575579406855]
[null,50,0.93235341410359951,53.627733050210288,89.938506082257078,98.485325936466452]
[null,1,0.99852604721588545,1.0014761285278679,99.81210568855272,99.979946509875006]