{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","Output_Plots","Input_Template"],"not_rendered":{"charts":6,"images":0,"macros":0,"external_links":0,"defined_names":63,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":80,"n_cols":23,"rows_kept":80,"cut":false,"hidden":false,"merged":[[30,1,30,2],[41,1,41,2],[78,5,78,8],[72,5,72,8],[73,5,73,8],[74,5,74,8],[76,5,76,8],[77,5,77,8],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[68,5,68,8],[64,5,64,8],[63,5,63,8],[49,5,49,8],[58,5,58,8],[50,5,50,8],[51,5,51,8],[57,5,57,8],[55,5,55,8],[54,5,54,8],[32,1,32,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[0,0,0,10],[27,1,27,2],[17,1,17,2],[19,1,19,2],[21,1,21,2],[6,2,6,7],[7,2,7,7],[8,2,8,7],[3,1,3,7],[26,1,26,2],[1,8,1,10],[70,5,70,8],[36,1,36,2],[9,2,9,7],[23,1,23,2],[25,1,25,2],[66,5,66,8],[62,5,62,8],[65,5,65,8],[56,5,56,8],[53,5,53,8],[12,3,12,7],[33,1,33,2],[34,1,34,2],[28,1,28,2],[29,1,29,2],[31,1,31,2],[60,10,60,12],[48,15,48,16],[48,17,48,18],[64,20,64,21],[69,5,69,8]]}
["USGS Methodology for Water and Proppant Associated with Petroleum Production"]
[null,null,null,null,null,null,null,null,"version 1.0 - February 2, 2015",null,null,null,null,null,null,null,"Correlation Matrix"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@RISK Correlations",{"$f":"\"Mean Drainage Area in \"&CELL(\"address\",$K$20)","v":"Mean Drainage Area in $K$20"},{"$f":"\"EUR Distribution Sweet Spot in \"&CELL(\"address\",$W$57)","v":"EUR Distribution Sweet Spot in $W$57"},{"$f":"\"EUR Distribution Non-Sweet Spot  in \"&CELL(\"address\",$W$58)","v":"EUR Distribution Non-Sweet Spot  in $W$58"},{"$f":"\"Mean drilling water, Sweet Spot in \"&CELL(\"address\",$K$29)","v":"Mean drilling water, Sweet Spot in $K$29"},{"$f":"\"Mean water HF water volume, Sweet Spot in \"&CELL(\"address\",$K$30)","v":"Mean water HF water volume, Sweet Spot in $K$30"},{"$f":"\"Mean drilling water, Non-Sweet Spot in \"&CELL(\"address\",$K$40)","v":"Mean drilling water, Non-Sweet Spot in $K$40"},{"$f":"\"Mean water HF water volume, Non-Sweet Spot in \"&CELL(\"address\",$K$41)","v":"Mean water HF water volume, Non-Sweet Spot in $K$41"}]
["Assessment lead(s):",null,null,null,null,null,null,null,null,"Date:",null,null,null,null,null,{"$f":"\"Mean Drainage Area in \"&CELL(\"address\",$K$20)","v":"Mean Drainage Area in $K$20"},1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"EUR Distribution Sweet Spot in \"&CELL(\"address\",$W$57)","v":"EUR Distribution Sweet Spot in $W$57"},0.5,1]
[null,"Number","Name",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"EUR Distribution Non-Sweet Spot in \"&CELL(\"address\",$W$58)","v":"EUR Distribution Non-Sweet Spot in $W$58"},0.5,0,1]
["Region:",null,null,null,null,null,null,null,null,null,"Oil or Gas?",null,null,null,null,{"$f":"\"Mean drilling water, Sweet Spot in \"&CELL(\"address\",$K$29)","v":"Mean drilling water, Sweet Spot in $K$29"},0.5,0.15,0,1]
["Province:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Mean water HF water volume, Sweet Spot in \"&CELL(\"address\",$K$30)","v":"Mean water HF water volume, Sweet Spot in $K$30"},0.5,0.15,0,0.5,1]
["Total Petroleum System:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Mean drilling water, Non-Sweet Spot in \"&CELL(\"address\",$K$40)","v":"Mean drilling water, Non-Sweet Spot in $K$40"},0.5,0,0.15,0,0,1]
["Assessment Unit:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Mean water HF water volume, Non-Sweet Spot in \"&CELL(\"address\",$K$41)","v":"Mean water HF water volume, Non-Sweet Spot in $K$41"},0.5,0,0.15,0,0,0.5,1]
[]
[null,"Date","Name","Lead geologist(s)"]
["Associated petroleum assessment:"]
[]
[]
[]
["Line #",null,null,"Distribution",null,"Minimum","Mode","Median","Maximum",null,"Functions"]
[1,"Productive area of accumulation (acres)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F18,G18,I18,_xll.RiskName(\"AU Area\"))","v":{"$error":"#VALUE!"}}]
[]
[2,"Uncertainty about mean drainage area of wells (acres)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F20,G20,I20,_xll.RiskCorrmat(CorrMatrix,1),_xll.RiskName(\"Mean Drainage Area\"))","v":{"$error":"#VALUE!"}}]
[]
[3,"Percentage of total AU area that is untested (%)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F22,G22,I22,_xll.RiskName(\"Untested Percent\"))","v":{"$error":"#VALUE!"}}]
[]
[4,"Percentage of untested AU area in sweet spots (%)",null,"Triangular",null,null,null,null,null,null,{"$f":"+IF(I24=F24,I24,_xll.RiskTriang(F24,G24,I24,_xll.RiskName(\"Percent in Sweet Spots\")))","v":0},null,null,null,null,"Uniform Probability",{"$f":"_xll.RiskUniform(0,1,_xll.RiskName(\"AU Probability\"))","v":{"$error":"#VALUE!"}}]
[]
[null,"Sweet Spots"]
["5a","Future Success Ratio (%)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F27,G27,I27,_xll.RiskName(\"Sweet Spot Success Ratio\"))","v":{"$error":"#VALUE!"}}]
["5b","Percentage of unsuccessful wells that are drilled and completed (%)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F28,G28,I28,_xll.RiskName(\"Percent of unsuccessful wells that are HF'ed, Sweet Spot\"))","v":{"$error":"#VALUE!"}}]
["5c","Uncertainty about mean water per well for drilling/cement (gallons)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F29,G29,I29,_xll.RiskCorrmat(CorrMatrix,4),_xll.RiskName(\"Mean drilling water, Sweet Spot\"))","v":{"$error":"#VALUE!"}}]
["5d","Uncertainty about mean water per treatment for HF (gallons)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F30,G30,I30,_xll.RiskCorrmat(CorrMatrix,5),_xll.RiskName(\"Mean HF water volume, Sweet Spot\"))","v":{"$error":"#VALUE!"}}]
["5e","Uncertainty about mean HF treatments per well",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F31,G31,I31,_xll.RiskCorrmat(CorrMatrix,5),_xll.RiskName(\"Mean HF water volume, Sweet Spot\"))","v":{"$error":"#VALUE!"}}]
["5f","Uncertainty about mean proppant-to-water ratio for HF (lbs per gallon)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F32,G32,I32,_xll.RiskName(\"Mean proppant/water ratio, Sweet Spot\"))","v":{"$error":"#VALUE!"}}]
["5g","Uncertainty about mean flowback percentage (%)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F33,G33,I33,_xll.RiskName(\"Mean flowback ratio, Sweet Spot\"))","v":{"$error":"#VALUE!"}}]
["5h","Uncertainty about mean produced water/petroleum ratio (bw/bo or gal/mcfg)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F34,G34,I34,_xll.RiskName(\"Mean water/petroleum ratio, Sweet Spot\"))","v":{"$error":"#VALUE!"}},null,null,null,null,"Values for sweet-spot EUR distribution"]
["5i","Uncertainty about mean EUR (mmbo or bcfg)",null,"Lognormal",null,null,null,null,null,null,{"$f":"+W57","v":{"$error":"#VALUE!"}},null,null,null,null,"mean",{"$f":" EXP(U35 + (0.5 * W35 * W35))","v":{"$error":"#NUM!"}},"s.d.",{"$f":" SQRT(EXP(2 * U35) * EXP(W35 * W35) * (EXP(W35 * W35) - 1))","v":{"$error":"#NUM!"}},"mu",{"$f":"LN(H35 - F35)","v":{"$error":"#NUM!"}},"sigma",{"$f":" (LN(I35 - F35) - U35) / 2.326","v":{"$error":"#NUM!"}}]
[]
[null,"Non-Sweet Spots"]
["6a","Future Success Ratio (%)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F38,G38,I38,_xll.RiskName(\"Non-Sweet Spot Success Ratio\"))","v":{"$error":"#VALUE!"}}]
["6b","Percentage of unsuccessful wells that are HF'ed (%)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F39,G39,I39,_xll.RiskName(\"Percent of unsuccessful wells that are HF'ed, Non-Sweet Spot\"))","v":{"$error":"#VALUE!"}}]
["6c","Uncertainty about mean water per well for drilling/cement (gallons)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F40,G40,I40,_xll.RiskCorrmat(CorrMatrix,6),_xll.RiskName(\"Mean drilling water, Non-Sweet Spot\"))","v":{"$error":"#VALUE!"}}]
["6d","Uncertainty about mean water per treatment for HF (gallons)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F41,G41,I41,_xll.RiskCorrmat(CorrMatrix,7),_xll.RiskName(\"Mean HF water volume, Non-Sweet Spot\"))","v":{"$error":"#VALUE!"}}]
["6e","Uncertainty about mean HF treatments per well",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F42,G42,I42,_xll.RiskCorrmat(CorrMatrix,7),_xll.RiskName(\"Mean HF water volume, Non-Sweet Spot\"))","v":{"$error":"#VALUE!"}}]
["6f","Uncertainty about mean proppant-to-water ratio for HF (lbs per gallon)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F43,G43,I43,_xll.RiskName(\"Mean proppant/water ratio, Non-Sweet Spot\"))","v":{"$error":"#VALUE!"}}]
["6g","Uncertainty about mean flowback percentage (%)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F44,G44,I44,_xll.RiskName(\"Mean flowback ratio, Non-Sweet Spot\"))","v":{"$error":"#VALUE!"}}]
["6h","Uncertainty about mean water/petroleum ratio (bw/bo or gal/mcfg)",null,"Triangular",null,null,null,null,null,null,{"$f":"+_xll.RiskTriang(F45,G45,I45,_xll.RiskName(\"Mean water/petroleum ratio, Non-Sweet Spot\"))","v":{"$error":"#VALUE!"}},null,null,null,null,"Values for non-sweet-spot EUR distribution"]
["6i","Uncertainty about mean EUR (mmbo or bcfg)",null,"Lognormal",null,null,null,null,null,null,{"$f":"+W58","v":0},null,null,null,null,"mean",{"$f":" EXP(U46 + (0.5 * W46 * W46))","v":{"$error":"#NUM!"}},"s.d.",{"$f":" SQRT(EXP(2 * U46) * EXP(W46 * W46) * (EXP(W46 * W46) - 1))","v":{"$error":"#NUM!"}},"mu",{"$f":"LN(H46 - F46)","v":{"$error":"#NUM!"}},"sigma",{"$f":" (LN(I46 - F46) - U46) / 2.326","v":{"$error":"#NUM!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculations: Unrisked",null,"Calculations: Risked"]
[null,"AU Probability",null,null,null,"Untested Area (acres)",null,null,null,null,{"$f":"+K18*K22","v":{"$error":"#VALUE!"}},null,null,null,null,"Gas in Sweet Spot Gas Accumulation (bcfg)",{"$f":"_xll.RiskOutput(\"Gas in Sweet Spot Gas Accumulation\",_xll.RiskUnits(\"bcfg\"))+IF($K$8=\"Gas\", $K$54*$K$35,0)","v":0},"Risked Gas in Sweet Spot Gas Accumulation (bcfg)",{"$f":"_xll.RiskOutput(\"Risked Gas in Sweet Spot Gas Accumulation\",_xll.RiskUnits(\"bcfg\"))+IF($K$8=\"Gas\",+IF(Q24<C50,$K$54*$K$35,0),0)","v":0}]
[null,null,null,null,null,"Sweet Spot Area that is Untested (acres)",null,null,null,null,{"$f":"+K50*K24","v":{"$error":"#VALUE!"}},null,null,null,null,"Gas in Non-Sweet Spot Gas Accumulation (bcfg)",{"$f":"_xll.RiskOutput(\"Gas in Non-Sweet Spot Gas Accumulation\",_xll.RiskUnits(\"bcfg\"))++IF($K$8=\"Gas\",+$K$57*$K$46,0)","v":0},"Risked Gas in Non-Sweet Spot Gas Accumulation (bcfg)",{"$f":"_xll.RiskOutput(\"Risked Gas in Non-Sweet Spot Gas Accumulation\",_xll.RiskUnits(\"bcfg\"))+IF($K$8=\"Gas\",IF(Q24<C50,$K$57*$K$46,0),0)","v":0}]
[null,null,null,null,null,"Non-Sweet Spot Area that is Untested (acres)",null,null,null,null,{"$f":"+K50-K51","v":{"$error":"#VALUE!"}},null,null,null,null,"Total Gas in Gas Accumulation (bcfg)",{"$f":"_xll.RiskOutput(\"Total Gas in Gas Accumulation\",_xll.RiskUnits(\"bcfg\"))++($Q$50+$Q$51)","v":0},"Risked Total Gas in Gas Accumulation (bcfg)",{"$f":"_xll.RiskOutput(\"Risked Total Gas in Gas Accumulation\",_xll.RiskUnits(\"bcfg\"))+($S$50+$S$51)","v":0}]
[null,"Correlation",0.5]
[null,null,null,null,null,"Sweet Spot Successful Well Count",null,null,null,null,{"$f":"_xll.RiskOutput(F54,_xll.RiskUnits(\"Wells\"))++(K51/K20)*K27","v":{"$error":"#VALUE!"}},null,null,null,null,"Oil in Sweet Spot Oil Accumulation (mmbo)",{"$f":"_xll.RiskOutput(\"Oil in Sweet Spot Oil Accumulation\",_xll.RiskUnits(\"mmbo\"))+IF($K8=\"Oil\", $K$54*$K$35,0)","v":0},"Risked Oil in Sweet Spot Oil Accumulation (mmbo)",{"$f":"_xll.RiskOutput(\"Risked Oil in Sweet Spot Oil Accumulation\",_xll.RiskUnits(\"mmbo\"))++IF(Q24<C50, IF($K$8=\"Oil\",K54*K35, 0),0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Sweet Spot drilled/HF'ed unsuccessful wells",null,null,null,null,{"$f":"_xll.RiskOutput(F55,_xll.RiskUnits(\"Wells\"))++(K51/K20)*(100%-K27)*K28","v":{"$error":"#VALUE!"}},null,null,null,null,"Oil in Non-Sweet Spot Oil Accumulation (mmbo)",{"$f":"_xll.RiskOutput(\"Oil in Non-Sweet Spot Oil Accumulation\",_xll.RiskUnits(\"mmbo\"))++IF($K$8=\"Oil\",+$K$57*$K$46,0)","v":0},"Risked Oil in Non-Sweet Spot Oil Accumulation (mmbo)",{"$f":"_xll.RiskOutput(\"Risked Oil in Non-Sweet Spot Oil Accumulation\",_xll.RiskUnits(\"mmbo\"))++IF(Q24<C50,IF($K$8=\"Oil\", K57*K46, 0),0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Sweet Spot Total Drilled/HF Well Count",null,null,null,null,{"$f":"_xll.RiskOutput(F56,_xll.RiskUnits(\"Wells\"))++($K$54+$K$55)","v":{"$error":"#VALUE!"}},null,null,null,null,"Total Oil in Oil Accumulation (mmbo)",{"$f":"_xll.RiskOutput(\"Total Oil in Oil Accumulation\",_xll.RiskUnits(\"mmbo\"))+IF($K$8=\"Oil\",+$Q$54+$Q$55,0)","v":0},"Risked Total Oil in Oil Accumulation (mmbo)",{"$f":"_xll.RiskOutput(\"Risked Total Oil in Oil Accumulation\",_xll.RiskUnits(\"mmbo\"))++IF($K$8=\"Oil\",S54+S55, 0)","v":0}]
[null,null,null,null,null,"Non-Sweet Spot Successful Well Count",null,null,null,null,{"$f":"_xll.RiskOutput(F57,_xll.RiskUnits(\"Wells\"))++(K52/K20)*K38","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"EUR Distribution Sweet Spot",null,{"$f":"_xll.RiskOutput(U57,_xll.RiskUnits(\"mmbo or bcfg\"))+_xll.RiskLognorm($Q$35,$S$35,_xll.RiskTruncate(0,$I$35-$F$35),_xll.RiskCorrmat(CorrMatrix,2))+$F$35","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Non-Sweet Spot drilled/HF'ed unsuccessful wells",null,null,null,null,{"$f":"_xll.RiskOutput(F58,_xll.RiskUnits(\"Wells\"))++(K52/K20)*(100%-K38)*K39","v":{"$error":"#VALUE!"}},null,null,null,null,"Sweet Spot Water for Drilling/Cement (gal)",{"$f":"_xll.RiskOutput(P58,_xll.RiskUnits(\"Gal\"))++K56*K29","v":{"$error":"#VALUE!"}},"Risked Sweet Spot Water for Drilling/Cement (gal)",{"$f":"_xll.RiskOutput(R58,_xll.RiskUnits(\"Gal\"))++IF(Q24<C50, K56*K29,0)","v":{"$error":"#VALUE!"}},null,"EUR Distribution Non-Sweet Spot",null,{"$f":"_xll.RiskOutput(\"EUR Distribution Non-Sweet Spot\",_xll.RiskUnits(\"mmbo or bcfg\"))++IF($H$46=0,0,_xll.RiskLognorm($Q$46,$S$46,_xll.RiskTruncate(0,$I$46-$F$46),_xll.RiskCorrmat(CorrMatrix,3))+$F$46)","v":0}]
[null,null,null,null,null,"Non-Sweet Spot Total Drilled/HF  Well Count",null,null,null,null,{"$f":"_xll.RiskOutput(F59,_xll.RiskUnits(\"Wells\"))++($K$57+$K$58)","v":{"$error":"#VALUE!"}},null,null,null,null,"Non-Sweet Spot Water for Drilling/Cement (gal)",{"$f":"_xll.RiskOutput(P59,_xll.RiskUnits(\"Gal\"))++K59*K40","v":{"$error":"#VALUE!"}},"Risked Non-Sweet Spot Water for Drilling/Cement (gal)",{"$f":"_xll.RiskOutput(R59,_xll.RiskUnits(\"Gal\"))++IF(Q24<C50, K59*K40,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Water for Drilling/Cement (gal)",{"$f":"_xll.RiskOutput(P60,_xll.RiskUnits(\"Gal\"))++Q58+Q59","v":{"$error":"#VALUE!"}},"Risked Total Water for Drilling/Cement (gal)",{"$f":"_xll.RiskOutput(R60,_xll.RiskUnits(\"Gal\"))++S58+S59","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,"Means of Outputs",null,null,null,null,"Sweet Spot Water for HF (gal)",{"$f":"_xll.RiskOutput(P61,_xll.RiskUnits(\"Gal\"))++$K$56*K30*K31","v":{"$error":"#VALUE!"}},"Risked Sweet Spot Water for HF (gal)",{"$f":"_xll.RiskOutput(R61,_xll.RiskUnits(\"Gal\"))++IF(Q24<C50, $K$56*K30*K31,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,"Unrisked",null,"Risked",null,null,"Non-Sweet Spot Water for HF (gal)",{"$f":"_xll.RiskOutput(P62,_xll.RiskUnits(\"Gal\"))++$K$59*K41*K42","v":{"$error":"#VALUE!"}},"Risked Non-Sweet Spot Water for HF (gal)",{"$f":"_xll.RiskOutput(R62,_xll.RiskUnits(\"Gal\"))++IF(Q24<C50, $K$59*K41*K42,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Sweet Spot Water for Drilling and Cement (gal)",null,null,null,null,{"$f":"+_xll.RiskMean(Q58)","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S58)","v":{"$error":"#VALUE!"}},null,null,"Total Water for HF (gal)",{"$f":"_xll.RiskOutput(P63,_xll.RiskUnits(\"Gal\"))++Q61+Q62","v":{"$error":"#VALUE!"}},"Risked Total Water for HF (gal)",{"$f":"_xll.RiskOutput(R63,_xll.RiskUnits(\"Gal\"))++S61+S62","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Non-Sweet Spot Water for Drilling and Cement (gal)",null,null,null,null,{"$f":"+_xll.RiskMean(Q59)","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S59)","v":{"$error":"#VALUE!"}},null,null,"Total Water Requirement (gal)",{"$f":"_xll.RiskOutput(P64,_xll.RiskUnits(\"Gal\"))++Q60+Q63","v":{"$error":"#VALUE!"}},"Risked Total Water Requirement (gal)",{"$f":"_xll.RiskOutput(R64,_xll.RiskUnits(\"Gal\"))++S60+S63","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Sweet Spot Water for Hydraulic Fracturing (gal)",null,null,null,null,{"$f":"+_xll.RiskMean(Q61)","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S61)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Unit conversion"]
[null,null,null,null,null,"Non-Sweet Spot Water for Hydraulic Fracturing (gal)",null,null,null,null,{"$f":"+_xll.RiskMean(Q62)","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S62)","v":{"$error":"#VALUE!"}},null,null,"Sweet Spot Proppant for HF (ton)",{"$f":"_xll.RiskOutput(P66,_xll.RiskUnits(\"Ton\"))++$K$56*K32*K30*K31/V66","v":{"$error":"#VALUE!"}},"Risked Sweet Spot Proppant for HF (ton)",{"$f":"_xll.RiskOutput(R66,_xll.RiskUnits(\"Ton\"))++IF(Q24<C50, $K$56*K32*K30*K31/V66,0)","v":{"$error":"#VALUE!"}},null,"lbs per ton:",2000]
[null,null,null,null,null,"Total Water Requirement (10^6 gal)",null,null,null,null,{"$f":"+_xll.RiskMean(Q64)/V69","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S64)/V69","v":{"$error":"#VALUE!"}},null,null,"Non-Sweet Spot Proppant for HF (ton)",{"$f":"_xll.RiskOutput(P67,_xll.RiskUnits(\"Ton\"))++$K$59*K43*K41*K42/V66","v":{"$error":"#VALUE!"}},"Risked Non-Sweet Spot Proppant for HF (ton)",{"$f":"_xll.RiskOutput(R67,_xll.RiskUnits(\"Ton\"))++IF(Q24<C50, $K$59*K43*K41*K42/V66,0)","v":{"$error":"#VALUE!"}},null,"gal per mmbbl:",42000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Proppant for HF (ton)",{"$f":"_xll.RiskOutput(P68,_xll.RiskUnits(\"Ton\"))++Q66+Q67","v":{"$error":"#VALUE!"}},"Risked Total Proppant for HF (ton)",{"$f":"_xll.RiskOutput(R68,_xll.RiskUnits(\"Ton\"))++S66+S67","v":{"$error":"#VALUE!"}},null,"mcf per bcf:",1000000,"(duh…)"]
[null,null,null,null,null,"Sweet Spot Proppant Requirement (ton)",null,null,null,null,{"$f":"+_xll.RiskMean(Q66)","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S66)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"gal per 10^6 gal:",1000000,"(duh…)"]
[null,null,null,null,null,"Non-Sweet Spot Proppant Requirement (ton)",null,null,null,null,{"$f":"+_xll.RiskMean(Q67)","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S67)","v":{"$error":"#VALUE!"}},null,null,"Sweet Spot Flowback Water (gal)",{"$f":"_xll.RiskOutput(P70,_xll.RiskUnits(\"Gal\"))++$K$56*K30*K33*K31","v":{"$error":"#VALUE!"}},"Risked Sweet Spot Flowback Water (gal)",{"$f":"_xll.RiskOutput(R70,_xll.RiskUnits(\"Gal\"))++IF(Q24<C50, $K$56*K30*K33*K31,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Total Proppant Requirement (ton)",null,null,null,null,{"$f":"+_xll.RiskMean(Q68)","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S68)","v":{"$error":"#VALUE!"}},null,null,"Non-Sweet Spot Flowback Water (gal)",{"$f":"_xll.RiskOutput(P71,_xll.RiskUnits(\"Gal\"))++$K$59*K41*K44*K42","v":{"$error":"#VALUE!"}},"Risked Non-Sweet Spot Flowback Water (gal)",{"$f":"_xll.RiskOutput(R71,_xll.RiskUnits(\"Gal\"))++IF(Q24<C50, $K$59*K41*K44*K42,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Flowback Water (gal)",{"$f":"_xll.RiskOutput(P72,_xll.RiskUnits(\"Gal\"))++Q70+Q71","v":{"$error":"#VALUE!"}},"Risked Total Flowback Water (gal)",{"$f":"_xll.RiskOutput(R72,_xll.RiskUnits(\"Gal\"))++S70+S71","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Sweet Spot Flowback Volume (10^6 gal)",null,null,null,null,{"$f":"+_xll.RiskMean(Q70)/V69","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S70)/V69","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Non-Sweet Spot Flowback Volume (10^6 gal)",null,null,null,null,{"$f":"+_xll.RiskMean(Q71)/V69","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S71)/V69","v":{"$error":"#VALUE!"}},null,null,"Sweet Spot Non-Flowback Produced Water (gal)",{"$f":"_xll.RiskOutput(P74,_xll.RiskUnits(\"Gal\"))+IF($K$8=\"Gas\", $K$54*$K$35*$K$34*$V$68,$K$54*$K$35*$K$34*$V$67)","v":{"$error":"#VALUE!"}},"Risked Sweet Spot Non-Flowback Produced Water (gal)",{"$f":"_xll.RiskOutput(R74,_xll.RiskUnits(\"Gal\"))++IF(Q24<C50, +IF($K$8=\"Gas\", $K$54*$K$35*$K$34*$V$68,$K$54*$K$35*$K$34*$V$67),0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Total Flowback Volume (10^6 gal)",null,null,null,null,{"$f":"+_xll.RiskMean(Q72)/V69","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S72)/V69","v":{"$error":"#VALUE!"}},null,null,"Non-Sweet Spot Non-Flowback Produced Water (gal)",{"$f":"_xll.RiskOutput(P75,_xll.RiskUnits(\"Gal\"))+IF($K$8=\"Gas\", $K$57*$K$46*$K$45*$V$68,$K$57*$K$46*$K$45*$V$67)","v":{"$error":"#VALUE!"}},"Risked Non-Sweet Spot Non-Flowback Prod. Water (gal)",{"$f":"_xll.RiskOutput(R75,_xll.RiskUnits(\"Gal\"))++IF(Q24<C50,IF($K$8=\"Gas\", $K$57*$K$46*$K$45*$V$68,$K$57*$K$46*$K$45*$V$67),0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Non-Flowback Produced Water (gal)",{"$f":"_xll.RiskOutput(P76,_xll.RiskUnits(\"Gal\"))++Q74+Q75","v":{"$error":"#VALUE!"}},"Risked Total Non-Flowback Produced Water (gal)",{"$f":"_xll.RiskOutput(R76,_xll.RiskUnits(\"Gal\"))++S74+S75","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Sweet Spot Produced Water (10^6 gal)",null,null,null,null,{"$f":"+_xll.RiskMean(Q77)/V69","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S77)/V69","v":{"$error":"#VALUE!"}},null,null,"Sweet Spot Total Produced Water (gal)",{"$f":"_xll.RiskOutput(P77,_xll.RiskUnits(\"Gal\"))++Q74+Q70","v":{"$error":"#VALUE!"}},"Risked Sweet Spot Total Produced Water (gal)",{"$f":"_xll.RiskOutput(R77,_xll.RiskUnits(\"Gal\"))++S74+S70","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Non-Sweet Spot Produced Water (10^6 gal)",null,null,null,null,{"$f":"+_xll.RiskMean(Q78)/V69","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S78)/V69","v":{"$error":"#VALUE!"}},null,null,"Non-Sweet Spot Total Produced Water (gal)",{"$f":"_xll.RiskOutput(P78,_xll.RiskUnits(\"Gal\"))++Q75+Q71","v":{"$error":"#VALUE!"}},"Risked Non-Sweet Spot Total Produced Water (gal)",{"$f":"_xll.RiskOutput(R78,_xll.RiskUnits(\"Gal\"))++S75+S71","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Total Produced Water (10^6 gal)",null,null,null,null,{"$f":"+_xll.RiskMean(Q79)/V69","v":{"$error":"#VALUE!"}},null,{"$f":"+_xll.RiskMean(S79)/V69","v":{"$error":"#VALUE!"}},null,null,"AU Total Produced Water (gal)",{"$f":"_xll.RiskOutput(P79,_xll.RiskUnits(\"Gal\"))++Q72+Q76","v":{"$error":"#VALUE!"}},"Risked AU Total Produced Water (gal)",{"$f":"_xll.RiskOutput(R79,_xll.RiskUnits(\"Gal\"))++S72+S76","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Note:  mcfg = thousand cubic feet gas"]

{"sheet":"Output_Plots","index":1,"n_rows":70,"n_cols":41,"rows_kept":70,"cut":false,"hidden":false,"merged":[[54,6,58,6],[32,17,36,17],[54,21,58,21],[32,31,36,31],[32,38,36,38],[32,24,36,24],[23,7,23,10],[32,6,36,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"F05/F95 Ratio",{"$f":"+IF(D46=0,0,D28/D46)","v":{"$error":"#VALUE!"}},{"$f":"+IF(E28=E46,0,E28/E46)","v":{"$error":"#VALUE!"}},{"$f":"+IF(F46=0,0,F28/F46)","v":{"$error":"#VALUE!"}},null,"Risked Volumes"]
[]
[null,null,"Fractile","Sweet Spots","Non-Sweet Spots","Total AU",null,"Fractile","Sweet Spots","Non-Sweet Spots","Total AU",null,null,null,null,"Fractile","Total For AU",null,"Fractile","Total For AU",null,null,"Fractile","Total For AU",null,"Fractile","Total For AU",null,null,"Fractile","Total For AU",null,"Fractile","Total For AU",null,null,"Fractile","Total For AU",null,"Fractile","Total For AU"]
[]
[null,null,0.05,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C28))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C28))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C28))","v":{"$error":"#VALUE!"}},null,0.05,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H28))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H28))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H28))","v":{"$error":"#VALUE!"}},null,null,null,null,0.05,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P28))/1000000","v":{"$error":"#VALUE!"}},null,0.05,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S28))/1000000","v":{"$error":"#VALUE!"}},null,null,0.05,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W28))/1000000","v":{"$error":"#VALUE!"}},null,0.05,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z28))/1000000","v":{"$error":"#VALUE!"}},null,null,0.05,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD28))/1000000","v":{"$error":"#VALUE!"}},null,0.05,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG28))/1000000","v":{"$error":"#VALUE!"}},null,null,0.05,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK28))/1000000","v":{"$error":"#VALUE!"}},null,0.05,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN28))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"+C28+0.05","v":0.1},{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C29))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C29))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C29))","v":{"$error":"#VALUE!"}},null,{"$f":"+H28+0.05","v":0.1},{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H29))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H29))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H29))","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"+P28+0.05","v":0.1},{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P29))/1000000","v":{"$error":"#VALUE!"}},null,{"$f":"+S28+0.05","v":0.1},{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S29))/1000000","v":{"$error":"#VALUE!"}},null,null,{"$f":"+W28+0.05","v":0.1},{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W29))/1000000","v":{"$error":"#VALUE!"}},null,{"$f":"+Z28+0.05","v":0.1},{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z29))/1000000","v":{"$error":"#VALUE!"}},null,null,{"$f":"+AD28+0.05","v":0.1},{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD29))/1000000","v":{"$error":"#VALUE!"}},null,{"$f":"+AG28+0.05","v":0.1},{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG29))/1000000","v":{"$error":"#VALUE!"}},null,null,{"$f":"+AK28+0.05","v":0.1},{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK29))/1000000","v":{"$error":"#VALUE!"}},null,{"$f":"+AN28+0.05","v":0.1},{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN29))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"+C29+0.05","v":0.15000000000000002},{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C30))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C30))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C30))","v":{"$error":"#VALUE!"}},null,{"$f":"+H29+0.05","v":0.15000000000000002},{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H30))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H30))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H30))","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"+P29+0.05","v":0.15000000000000002},{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P30))/1000000","v":{"$error":"#VALUE!"}},null,{"$f":"+S29+0.05","v":0.15000000000000002},{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S30))/1000000","v":{"$error":"#VALUE!"}},null,null,{"$f":"+W29+0.05","v":0.15000000000000002},{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W30))/1000000","v":{"$error":"#VALUE!"}},null,{"$f":"+Z29+0.05","v":0.15000000000000002},{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z30))/1000000","v":{"$error":"#VALUE!"}},null,null,{"$f":"+AD29+0.05","v":0.15000000000000002},{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD30))/1000000","v":{"$error":"#VALUE!"}},null,{"$f":"+AG29+0.05","v":0.15000000000000002},{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG30))/1000000","v":{"$error":"#VALUE!"}},null,null,{"$f":"+AK29+0.05","v":0.15000000000000002},{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK30))/1000000","v":{"$error":"#VALUE!"}},null,{"$f":"+AN29+0.05","v":0.15000000000000002},{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN30))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.2,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C31))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C31))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C31))","v":{"$error":"#VALUE!"}},null,0.2,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H31))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H31))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H31))","v":{"$error":"#VALUE!"}},null,null,null,null,0.2,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P31))/1000000","v":{"$error":"#VALUE!"}},null,0.2,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S31))/1000000","v":{"$error":"#VALUE!"}},null,null,0.2,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W31))/1000000","v":{"$error":"#VALUE!"}},null,0.2,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z31))/1000000","v":{"$error":"#VALUE!"}},null,null,0.2,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD31))/1000000","v":{"$error":"#VALUE!"}},null,0.2,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG31))/1000000","v":{"$error":"#VALUE!"}},null,null,0.2,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK31))/1000000","v":{"$error":"#VALUE!"}},null,0.2,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN31))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.25,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C32))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C32))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C32))","v":{"$error":"#VALUE!"}},null,0.25,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H32))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H32))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H32))","v":{"$error":"#VALUE!"}},null,null,null,null,0.25,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P32))/1000000","v":{"$error":"#VALUE!"}},null,0.25,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S32))/1000000","v":{"$error":"#VALUE!"}},null,null,0.25,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W32))/1000000","v":{"$error":"#VALUE!"}},null,0.25,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z32))/1000000","v":{"$error":"#VALUE!"}},null,null,0.25,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD32))/1000000","v":{"$error":"#VALUE!"}},null,0.25,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG32))/1000000","v":{"$error":"#VALUE!"}},null,null,0.25,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK32))/1000000","v":{"$error":"#VALUE!"}},null,0.25,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN32))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.3,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C33))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C33))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C33))","v":{"$error":"#VALUE!"}},"OIL",0.3,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H33))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H33))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H33))","v":{"$error":"#VALUE!"}},null,null,null,null,0.3,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P33))/1000000","v":{"$error":"#VALUE!"}},"Total Water Requirement",0.3,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S33))/1000000","v":{"$error":"#VALUE!"}},null,null,0.3,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W33))/1000000","v":{"$error":"#VALUE!"}},"Total Proppant Requirement",0.3,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z33))/1000000","v":{"$error":"#VALUE!"}},null,null,0.3,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD33))/1000000","v":{"$error":"#VALUE!"}},"Total Flowback Production",0.3,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG33))/1000000","v":{"$error":"#VALUE!"}},null,null,0.3,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK33))/1000000","v":{"$error":"#VALUE!"}},"Total Produced Water",0.3,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN33))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.35,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C34))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C34))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C34))","v":{"$error":"#VALUE!"}},null,0.35,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H34))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H34))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H34))","v":{"$error":"#VALUE!"}},null,null,null,null,0.35,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P34))/1000000","v":{"$error":"#VALUE!"}},null,0.35,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S34))/1000000","v":{"$error":"#VALUE!"}},null,null,0.35,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W34))/1000000","v":{"$error":"#VALUE!"}},null,0.35,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z34))/1000000","v":{"$error":"#VALUE!"}},null,null,0.35,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD34))/1000000","v":{"$error":"#VALUE!"}},null,0.35,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG34))/1000000","v":{"$error":"#VALUE!"}},null,null,0.35,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK34))/1000000","v":{"$error":"#VALUE!"}},null,0.35,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN34))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.39999999999999997,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C35))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C35))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C35))","v":{"$error":"#VALUE!"}},null,0.39999999999999997,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H35))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H35))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H35))","v":{"$error":"#VALUE!"}},null,null,null,null,0.39999999999999997,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P35))/1000000","v":{"$error":"#VALUE!"}},null,0.39999999999999997,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S35))/1000000","v":{"$error":"#VALUE!"}},null,null,0.39999999999999997,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W35))/1000000","v":{"$error":"#VALUE!"}},null,0.39999999999999997,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z35))/1000000","v":{"$error":"#VALUE!"}},null,null,0.39999999999999997,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD35))/1000000","v":{"$error":"#VALUE!"}},null,0.39999999999999997,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG35))/1000000","v":{"$error":"#VALUE!"}},null,null,0.39999999999999997,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK35))/1000000","v":{"$error":"#VALUE!"}},null,0.39999999999999997,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN35))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.44999999999999996,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C36))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C36))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C36))","v":{"$error":"#VALUE!"}},null,0.44999999999999996,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H36))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H36))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H36))","v":{"$error":"#VALUE!"}},null,null,null,null,0.44999999999999996,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P36))/1000000","v":{"$error":"#VALUE!"}},null,0.44999999999999996,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S36))/1000000","v":{"$error":"#VALUE!"}},null,null,0.44999999999999996,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W36))/1000000","v":{"$error":"#VALUE!"}},null,0.44999999999999996,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z36))/1000000","v":{"$error":"#VALUE!"}},null,null,0.44999999999999996,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD36))/1000000","v":{"$error":"#VALUE!"}},null,0.44999999999999996,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG36))/1000000","v":{"$error":"#VALUE!"}},null,null,0.44999999999999996,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK36))/1000000","v":{"$error":"#VALUE!"}},null,0.44999999999999996,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN36))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.49999999999999994,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C37))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C37))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C37))","v":{"$error":"#VALUE!"}},null,0.49999999999999994,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H37))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H37))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H37))","v":{"$error":"#VALUE!"}},null,null,null,null,0.49999999999999994,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P37))/1000000","v":{"$error":"#VALUE!"}},null,0.49999999999999994,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S37))/1000000","v":{"$error":"#VALUE!"}},null,null,0.49999999999999994,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W37))/1000000","v":{"$error":"#VALUE!"}},null,0.49999999999999994,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z37))/1000000","v":{"$error":"#VALUE!"}},null,null,0.49999999999999994,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD37))/1000000","v":{"$error":"#VALUE!"}},null,0.49999999999999994,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG37))/1000000","v":{"$error":"#VALUE!"}},null,null,0.49999999999999994,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK37))/1000000","v":{"$error":"#VALUE!"}},null,0.49999999999999994,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN37))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.54999999999999993,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C38))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C38))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C38))","v":{"$error":"#VALUE!"}},null,0.54999999999999993,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H38))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H38))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H38))","v":{"$error":"#VALUE!"}},null,null,null,null,0.54999999999999993,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P38))/1000000","v":{"$error":"#VALUE!"}},null,0.54999999999999993,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S38))/1000000","v":{"$error":"#VALUE!"}},null,null,0.54999999999999993,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W38))/1000000","v":{"$error":"#VALUE!"}},null,0.54999999999999993,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z38))/1000000","v":{"$error":"#VALUE!"}},null,null,0.54999999999999993,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD38))/1000000","v":{"$error":"#VALUE!"}},null,0.54999999999999993,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG38))/1000000","v":{"$error":"#VALUE!"}},null,null,0.54999999999999993,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK38))/1000000","v":{"$error":"#VALUE!"}},null,0.54999999999999993,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN38))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.6,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C39))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C39))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C39))","v":{"$error":"#VALUE!"}},null,0.6,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H39))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H39))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H39))","v":{"$error":"#VALUE!"}},null,null,null,null,0.6,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P39))/1000000","v":{"$error":"#VALUE!"}},null,0.6,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S39))/1000000","v":{"$error":"#VALUE!"}},null,null,0.6,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W39))/1000000","v":{"$error":"#VALUE!"}},null,0.6,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z39))/1000000","v":{"$error":"#VALUE!"}},null,null,0.6,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD39))/1000000","v":{"$error":"#VALUE!"}},null,0.6,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG39))/1000000","v":{"$error":"#VALUE!"}},null,null,0.6,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK39))/1000000","v":{"$error":"#VALUE!"}},null,0.6,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN39))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.65,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C40))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C40))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C40))","v":{"$error":"#VALUE!"}},null,0.65,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H40))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H40))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H40))","v":{"$error":"#VALUE!"}},null,null,null,null,0.65,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P40))/1000000","v":{"$error":"#VALUE!"}},null,0.65,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S40))/1000000","v":{"$error":"#VALUE!"}},null,null,0.65,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W40))/1000000","v":{"$error":"#VALUE!"}},null,0.65,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z40))/1000000","v":{"$error":"#VALUE!"}},null,null,0.65,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD40))/1000000","v":{"$error":"#VALUE!"}},null,0.65,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG40))/1000000","v":{"$error":"#VALUE!"}},null,null,0.65,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK40))/1000000","v":{"$error":"#VALUE!"}},null,0.65,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN40))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.70000000000000007,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C41))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C41))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C41))","v":{"$error":"#VALUE!"}},null,0.70000000000000007,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H41))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H41))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H41))","v":{"$error":"#VALUE!"}},null,null,null,null,0.70000000000000007,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P41))/1000000","v":{"$error":"#VALUE!"}},null,0.70000000000000007,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S41))/1000000","v":{"$error":"#VALUE!"}},null,null,0.70000000000000007,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W41))/1000000","v":{"$error":"#VALUE!"}},null,0.70000000000000007,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z41))/1000000","v":{"$error":"#VALUE!"}},null,null,0.70000000000000007,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD41))/1000000","v":{"$error":"#VALUE!"}},null,0.70000000000000007,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG41))/1000000","v":{"$error":"#VALUE!"}},null,null,0.70000000000000007,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK41))/1000000","v":{"$error":"#VALUE!"}},null,0.70000000000000007,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN41))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.75000000000000011,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C42))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C42))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C42))","v":{"$error":"#VALUE!"}},null,0.75000000000000011,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H42))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H42))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H42))","v":{"$error":"#VALUE!"}},null,null,null,null,0.75000000000000011,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P42))/1000000","v":{"$error":"#VALUE!"}},null,0.75000000000000011,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S42))/1000000","v":{"$error":"#VALUE!"}},null,null,0.75000000000000011,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W42))/1000000","v":{"$error":"#VALUE!"}},null,0.75000000000000011,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z42))/1000000","v":{"$error":"#VALUE!"}},null,null,0.75000000000000011,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD42))/1000000","v":{"$error":"#VALUE!"}},null,0.75000000000000011,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG42))/1000000","v":{"$error":"#VALUE!"}},null,null,0.75000000000000011,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK42))/1000000","v":{"$error":"#VALUE!"}},null,0.75000000000000011,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN42))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.80000000000000016,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C43))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C43))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C43))","v":{"$error":"#VALUE!"}},null,0.80000000000000016,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H43))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H43))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H43))","v":{"$error":"#VALUE!"}},null,null,null,null,0.80000000000000016,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P43))/1000000","v":{"$error":"#VALUE!"}},null,0.80000000000000016,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S43))/1000000","v":{"$error":"#VALUE!"}},null,null,0.80000000000000016,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W43))/1000000","v":{"$error":"#VALUE!"}},null,0.80000000000000016,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z43))/1000000","v":{"$error":"#VALUE!"}},null,null,0.80000000000000016,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD43))/1000000","v":{"$error":"#VALUE!"}},null,0.80000000000000016,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG43))/1000000","v":{"$error":"#VALUE!"}},null,null,0.80000000000000016,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK43))/1000000","v":{"$error":"#VALUE!"}},null,0.80000000000000016,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN43))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.8500000000000002,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C44))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C44))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C44))","v":{"$error":"#VALUE!"}},null,0.8500000000000002,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H44))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H44))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H44))","v":{"$error":"#VALUE!"}},null,null,null,null,0.8500000000000002,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P44))/1000000","v":{"$error":"#VALUE!"}},null,0.8500000000000002,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S44))/1000000","v":{"$error":"#VALUE!"}},null,null,0.8500000000000002,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W44))/1000000","v":{"$error":"#VALUE!"}},null,0.8500000000000002,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z44))/1000000","v":{"$error":"#VALUE!"}},null,null,0.8500000000000002,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD44))/1000000","v":{"$error":"#VALUE!"}},null,0.8500000000000002,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG44))/1000000","v":{"$error":"#VALUE!"}},null,null,0.8500000000000002,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK44))/1000000","v":{"$error":"#VALUE!"}},null,0.8500000000000002,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN44))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.90000000000000024,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C45))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C45))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C45))","v":{"$error":"#VALUE!"}},null,0.90000000000000024,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H45))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H45))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H45))","v":{"$error":"#VALUE!"}},null,null,null,null,0.90000000000000024,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P45))/1000000","v":{"$error":"#VALUE!"}},null,0.90000000000000024,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S45))/1000000","v":{"$error":"#VALUE!"}},null,null,0.90000000000000024,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W45))/1000000","v":{"$error":"#VALUE!"}},null,0.90000000000000024,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z45))/1000000","v":{"$error":"#VALUE!"}},null,null,0.90000000000000024,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD45))/1000000","v":{"$error":"#VALUE!"}},null,0.90000000000000024,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG45))/1000000","v":{"$error":"#VALUE!"}},null,null,0.90000000000000024,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK45))/1000000","v":{"$error":"#VALUE!"}},null,0.90000000000000024,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN45))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,0.95000000000000029,{"$f":"+_xll.RiskPercentile(Main!$Q$54,(1-C46))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$55,(1-C46))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$56,(1-C46))","v":{"$error":"#VALUE!"}},null,0.95000000000000029,{"$f":"+_xll.RiskPercentile(Main!$S$54,(1-H46))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$55,(1-H46))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$56,(1-H46))","v":{"$error":"#VALUE!"}},null,null,null,null,0.95000000000000029,{"$f":"+_xll.RiskPercentile(Main!$Q$64,(1-P46))/1000000","v":{"$error":"#VALUE!"}},null,0.95000000000000029,{"$f":"+_xll.RiskPercentile(Main!$S$64,(1-S46))/1000000","v":{"$error":"#VALUE!"}},null,null,0.95000000000000029,{"$f":"+_xll.RiskPercentile(Main!$Q$68,(1-W46))/1000000","v":{"$error":"#VALUE!"}},null,0.95000000000000029,{"$f":"+_xll.RiskPercentile(Main!$S$68,(1-Z46))/1000000","v":{"$error":"#VALUE!"}},null,null,0.95000000000000029,{"$f":"+_xll.RiskPercentile(Main!$Q$72,(1-AD46))/1000000","v":{"$error":"#VALUE!"}},null,0.95000000000000029,{"$f":"+_xll.RiskPercentile(Main!$S$72,(1-AG46))/1000000","v":{"$error":"#VALUE!"}},null,null,0.95000000000000029,{"$f":"+_xll.RiskPercentile(Main!$Q$79,(1-AK46))/1000000","v":{"$error":"#VALUE!"}},null,0.95000000000000029,{"$f":"+_xll.RiskPercentile(Main!$S$79,(1-AN46))/1000000","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unrisked",null,null,"Risked",null,null,null,"Unrisked",null,null,"Risked",null,null,null,"Unrisked",null,null,"Risked",null,null,null,"Unrisked",null,null,"Risked"]
[null,null,null,{"$f":"+IF(D70=0,0,D52/D70)","v":{"$error":"#VALUE!"}},{"$f":"+IF(E52=E70,0,E52/E70)","v":{"$error":"#VALUE!"}},{"$f":"+IF(F70=0,0,F52/F70)","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Fractile","Sweet Spots","Non-Sweet Spots","Total AU",null,"Fractile","Sweet Spots","Non-Sweet Spots","Total AU"]
[]
[null,null,0.05,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C52))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C52))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C52))","v":{"$error":"#VALUE!"}},null,0.05,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H52))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H52))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H52))","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"+C52+0.05","v":0.1},{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C53))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C53))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C53))","v":{"$error":"#VALUE!"}},null,{"$f":"+H52+0.05","v":0.1},{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H53))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H53))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H53))","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"+C53+0.05","v":0.15000000000000002},{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C54))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C54))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C54))","v":{"$error":"#VALUE!"}},null,{"$f":"+H53+0.05","v":0.15000000000000002},{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H54))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H54))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H54))","v":{"$error":"#VALUE!"}}]
[null,null,0.2,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C55))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C55))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C55))","v":{"$error":"#VALUE!"}},"GAS",0.2,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H55))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H55))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H55))","v":{"$error":"#VALUE!"}}]
[null,null,0.25,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C56))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C56))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C56))","v":{"$error":"#VALUE!"}},null,0.25,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H56))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H56))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H56))","v":{"$error":"#VALUE!"}}]
[null,null,0.3,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C57))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C57))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C57))","v":{"$error":"#VALUE!"}},null,0.3,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H57))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H57))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H57))","v":{"$error":"#VALUE!"}}]
[null,null,0.35,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C58))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C58))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C58))","v":{"$error":"#VALUE!"}},null,0.35,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H58))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H58))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H58))","v":{"$error":"#VALUE!"}}]
[null,null,0.39999999999999997,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C59))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C59))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C59))","v":{"$error":"#VALUE!"}},null,0.39999999999999997,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H59))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H59))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H59))","v":{"$error":"#VALUE!"}}]
[null,null,0.44999999999999996,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C60))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C60))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C60))","v":{"$error":"#VALUE!"}},null,0.44999999999999996,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H60))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H60))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H60))","v":{"$error":"#VALUE!"}}]
[null,null,0.49999999999999994,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C61))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C61))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C61))","v":{"$error":"#VALUE!"}},null,0.49999999999999994,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H61))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H61))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H61))","v":{"$error":"#VALUE!"}}]
[null,null,0.54999999999999993,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C62))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C62))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C62))","v":{"$error":"#VALUE!"}},null,0.54999999999999993,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H62))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H62))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H62))","v":{"$error":"#VALUE!"}}]
[null,null,0.6,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C63))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C63))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C63))","v":{"$error":"#VALUE!"}},null,0.6,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H63))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H63))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H63))","v":{"$error":"#VALUE!"}}]
[null,null,0.65,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C64))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C64))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C64))","v":{"$error":"#VALUE!"}},null,0.65,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H64))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H64))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H64))","v":{"$error":"#VALUE!"}}]
[null,null,0.70000000000000007,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C65))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C65))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C65))","v":{"$error":"#VALUE!"}},null,0.70000000000000007,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H65))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H65))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H65))","v":{"$error":"#VALUE!"}}]
[null,null,0.75000000000000011,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C66))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C66))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C66))","v":{"$error":"#VALUE!"}},null,0.75000000000000011,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H66))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H66))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H66))","v":{"$error":"#VALUE!"}}]
[null,null,0.80000000000000016,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C67))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C67))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C67))","v":{"$error":"#VALUE!"}},null,0.80000000000000016,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H67))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H67))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H67))","v":{"$error":"#VALUE!"}}]
[null,null,0.8500000000000002,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C68))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C68))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C68))","v":{"$error":"#VALUE!"}},null,0.8500000000000002,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H68))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H68))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H68))","v":{"$error":"#VALUE!"}}]
[null,null,0.90000000000000024,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C69))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C69))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C69))","v":{"$error":"#VALUE!"}},null,0.90000000000000024,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H69))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H69))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H69))","v":{"$error":"#VALUE!"}}]
[null,null,0.95000000000000029,{"$f":"+_xll.RiskPercentile(Main!$Q$50,(1-C70))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$51,(1-C70))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$Q$52,(1-C70))","v":{"$error":"#VALUE!"}},null,0.95000000000000029,{"$f":"+_xll.RiskPercentile(Main!$S$50,(1-H70))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$51,(1-H70))","v":{"$error":"#VALUE!"}},{"$f":"+_xll.RiskPercentile(Main!$S$52,(1-H70))","v":{"$error":"#VALUE!"}}]

{"sheet":"Input_Template","index":2,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,8,1,10],[34,1,34,2],[29,1,29,2],[0,0,0,10],[6,2,6,7],[7,2,7,7],[8,2,8,7],[9,2,9,7],[3,1,3,7],[17,1,17,2],[19,1,19,2],[21,1,21,2],[31,1,31,2],[32,1,32,2],[12,3,12,7],[28,1,28,2],[33,1,33,2],[36,1,36,2],[37,1,37,2],[27,1,27,2],[23,1,23,2],[25,1,25,2],[26,1,26,2],[30,1,30,2],[44,1,44,2],[45,1,45,2],[51,5,51,8],[38,1,38,2],[39,1,39,2],[40,1,40,2],[42,1,42,2],[43,1,43,2],[41,1,41,2]]}
["USGS Methodology for Water and Proppant Associated with Petroleum Production"]
[null,null,null,null,null,null,null,null,{"$f":"+Main!I2","v":"version 1.0 - February 2, 2015"}]
[]
["Assessment lead(s):",{"$f":"IF(Main!B4=\"\", \"\", Main!B4)","v":""},null,null,null,null,null,null,null,"Date:",{"$f":"IF(Main!K4=\"\", \"\", Main!K4)","v":""}]
[]
[null,"Number","Name"]
["Region:",{"$f":"IF(Main!B7=\"\", \"\", Main!B7)","v":""},{"$f":"IF(Main!C7=\"\", \"\", Main!C7)","v":""},null,null,null,null,null,null,null,"Oil or Gas?"]
["Province:",{"$f":"IF(Main!B8=\"\", \"\", Main!B8)","v":""},{"$f":"IF(Main!C8=\"\", \"\", Main!C8)","v":""},null,null,null,null,null,null,null,{"$f":"IF(Main!K8=\"\", \"\", Main!K8)","v":""}]
["Total Petroleum System:",{"$f":"IF(Main!B9=\"\", \"\", Main!B9)","v":""},{"$f":"IF(Main!C9=\"\", \"\", Main!C9)","v":""}]
["Assessment Unit:",{"$f":"IF(Main!B10=\"\", \"\", Main!B10)","v":""},{"$f":"IF(Main!C10=\"\", \"\", Main!C10)","v":""}]
[]
[null,"Date","Name","Lead geologist(s)"]
["Associated petroleum assessment:",{"$f":"IF(Main!B13=\"\", \"\", Main!B13)","v":""},{"$f":"IF(Main!C13=\"\", \"\", Main!C13)","v":""},{"$f":"IF(Main!D13=\"\", \"\", Main!D13)","v":""}]
[]
[]
[]
["Line #",null,null,"Distribution",null,"Minimum","Mode","Median","Maximum",null,"Functions"]
[1,"Productive area of accumulation (acres)",null,"Triangular",null,{"$f":"IF(Main!F18=\"\", \"\", Main!F18)","v":""},{"$f":"IF(Main!G18=\"\", \"\", Main!G18)","v":""},{"$f":"IF(Main!H18=\"\", \"\", Main!H18)","v":""},{"$f":"IF(Main!I18=\"\", \"\", Main!I18)","v":""},null,{"$f":"IF(Main!K18=\"\", \"\", Main!K18)","v":{"$error":"#VALUE!"}}]
[]
[2,"Uncertainty about mean drainage area of wells (acres)",null,"Triangular",null,{"$f":"IF(Main!F20=\"\", \"\", Main!F20)","v":""},{"$f":"IF(Main!G20=\"\", \"\", Main!G20)","v":""},{"$f":"IF(Main!H20=\"\", \"\", Main!H20)","v":""},{"$f":"IF(Main!I20=\"\", \"\", Main!I20)","v":""},null,{"$f":"IF(Main!K20=\"\", \"\", Main!K20)","v":{"$error":"#VALUE!"}}]
[]
[3,"Percentage of total AU area that is untested (%)",null,"Triangular",null,{"$f":"IF(Main!F22=\"\", \"\", Main!F22)","v":""},{"$f":"IF(Main!G22=\"\", \"\", Main!G22)","v":""},{"$f":"IF(Main!H22=\"\", \"\", Main!H22)","v":""},{"$f":"IF(Main!I22=\"\", \"\", Main!I22)","v":""},null,{"$f":"IF(Main!K22=\"\", \"\", Main!K22)","v":{"$error":"#VALUE!"}}]
[]
[4,"Percentage of untested AU area in sweet spots (%)",null,"Triangular",null,{"$f":"IF(Main!F24=\"\", \"\", Main!F24)","v":""},{"$f":"IF(Main!G24=\"\", \"\", Main!G24)","v":""},{"$f":"IF(Main!H24=\"\", \"\", Main!H24)","v":""},{"$f":"IF(Main!I24=\"\", \"\", Main!I24)","v":""},null,{"$f":"IF(Main!K24=\"\", \"\", Main!K24)","v":0}]
[]
[null,"Sweet Spots"]
["5a","Future Success Ratio (%)",null,"Triangular",null,{"$f":"IF(Main!F27=\"\", \"\", Main!F27)","v":""},{"$f":"IF(Main!G27=\"\", \"\", Main!G27)","v":""},{"$f":"IF(Main!H27=\"\", \"\", Main!H27)","v":""},{"$f":"IF(Main!I27=\"\", \"\", Main!I27)","v":""},null,{"$f":"IF(Main!K27=\"\", \"\", Main!K27)","v":{"$error":"#VALUE!"}}]
["5b","Percentage of unsuccessful wells that are HF'ed (%)",null,"Triangular",null,{"$f":"IF(Main!F28=\"\", \"\", Main!F28)","v":""},{"$f":"IF(Main!G28=\"\", \"\", Main!G28)","v":""},{"$f":"IF(Main!H28=\"\", \"\", Main!H28)","v":""},{"$f":"IF(Main!I28=\"\", \"\", Main!I28)","v":""},null,{"$f":"IF(Main!K28=\"\", \"\", Main!K28)","v":{"$error":"#VALUE!"}}]
["5c","Uncertainty about mean water per well for drilling/cement (gallons)",null,"Triangular",null,{"$f":"IF(Main!F29=\"\", \"\", Main!F29)","v":""},{"$f":"IF(Main!G29=\"\", \"\", Main!G29)","v":""},{"$f":"IF(Main!H29=\"\", \"\", Main!H29)","v":""},{"$f":"IF(Main!I29=\"\", \"\", Main!I29)","v":""},null,{"$f":"IF(Main!K29=\"\", \"\", Main!K29)","v":{"$error":"#VALUE!"}}]
["5d","Uncertainty about mean water per treatment for HF (gallons)",null,"Triangular",null,{"$f":"IF(Main!F30=\"\", \"\", Main!F30)","v":""},{"$f":"IF(Main!G30=\"\", \"\", Main!G30)","v":""},{"$f":"IF(Main!H30=\"\", \"\", Main!H30)","v":""},{"$f":"IF(Main!I30=\"\", \"\", Main!I30)","v":""},null,{"$f":"IF(Main!K30=\"\", \"\", Main!K30)","v":{"$error":"#VALUE!"}}]
["5e","Uncertainty about mean HF treatments per well",null,"Triangular",null,{"$f":"IF(Main!F31=\"\", \"\", Main!F31)","v":""},{"$f":"IF(Main!G31=\"\", \"\", Main!G31)","v":""},{"$f":"IF(Main!H31=\"\", \"\", Main!H31)","v":""},{"$f":"IF(Main!I31=\"\", \"\", Main!I31)","v":""},null,{"$f":"IF(Main!K31=\"\", \"\", Main!K31)","v":{"$error":"#VALUE!"}}]
["5f","Uncertainty about mean proppant-to-water ratio for HF (lbs per gallon)",null,"Triangular",null,{"$f":"IF(Main!F32=\"\", \"\", Main!F32)","v":""},{"$f":"IF(Main!G32=\"\", \"\", Main!G32)","v":""},{"$f":"IF(Main!H32=\"\", \"\", Main!H32)","v":""},{"$f":"IF(Main!I32=\"\", \"\", Main!I32)","v":""},null,{"$f":"IF(Main!K32=\"\", \"\", Main!K32)","v":{"$error":"#VALUE!"}}]
["5g","Uncertainty about mean flowback percentage (%)",null,"Triangular",null,{"$f":"IF(Main!F33=\"\", \"\", Main!F33)","v":""},{"$f":"IF(Main!G33=\"\", \"\", Main!G33)","v":""},{"$f":"IF(Main!H33=\"\", \"\", Main!H33)","v":""},{"$f":"IF(Main!I33=\"\", \"\", Main!I33)","v":""},null,{"$f":"IF(Main!K33=\"\", \"\", Main!K33)","v":{"$error":"#VALUE!"}}]
["5h","Uncertainty about mean water/petroleum ratio (bw/bo or gal/mcfg)",null,"Triangular",null,{"$f":"IF(Main!F34=\"\", \"\", Main!F34)","v":""},{"$f":"IF(Main!G34=\"\", \"\", Main!G34)","v":""},{"$f":"IF(Main!H34=\"\", \"\", Main!H34)","v":""},{"$f":"IF(Main!I34=\"\", \"\", Main!I34)","v":""},null,{"$f":"IF(Main!K34=\"\", \"\", Main!K34)","v":{"$error":"#VALUE!"}}]
["5i","Uncertainty about mean EUR (mmbo or bcfg)",null,"Lognormal",null,{"$f":"IF(Main!F35=\"\", \"\", Main!F35)","v":""},{"$f":"IF(Main!G35=\"\", \"\", Main!G35)","v":""},{"$f":"IF(Main!H35=\"\", \"\", Main!H35)","v":""},{"$f":"IF(Main!I35=\"\", \"\", Main!I35)","v":""},null,{"$f":"IF(Main!K35=\"\", \"\", Main!K35)","v":{"$error":"#VALUE!"}}]
[]
[null,"Non-Sweet Spots"]
["6a","Future Success Ratio (%)",null,"Triangular",null,{"$f":"IF(Main!F38=\"\", \"\", Main!F38)","v":""},{"$f":"IF(Main!G38=\"\", \"\", Main!G38)","v":""},{"$f":"IF(Main!H38=\"\", \"\", Main!H38)","v":""},{"$f":"IF(Main!I38=\"\", \"\", Main!I38)","v":""},null,{"$f":"IF(Main!K38=\"\", \"\", Main!K38)","v":{"$error":"#VALUE!"}}]
["6b","Percentage of unsuccessful wells that are HF'ed (%)",null,"Triangular",null,{"$f":"IF(Main!F39=\"\", \"\", Main!F39)","v":""},{"$f":"IF(Main!G39=\"\", \"\", Main!G39)","v":""},{"$f":"IF(Main!H39=\"\", \"\", Main!H39)","v":""},{"$f":"IF(Main!I39=\"\", \"\", Main!I39)","v":""},null,{"$f":"IF(Main!K39=\"\", \"\", Main!K39)","v":{"$error":"#VALUE!"}}]
["6c","Uncertainty about mean water per well for drilling/cement (gallons)",null,"Triangular",null,{"$f":"IF(Main!F40=\"\", \"\", Main!F40)","v":""},{"$f":"IF(Main!G40=\"\", \"\", Main!G40)","v":""},{"$f":"IF(Main!H40=\"\", \"\", Main!H40)","v":""},{"$f":"IF(Main!I40=\"\", \"\", Main!I40)","v":""},null,{"$f":"IF(Main!K40=\"\", \"\", Main!K40)","v":{"$error":"#VALUE!"}}]
["6d","Uncertainty about mean water per treatment for HF (gallons)",null,"Triangular",null,{"$f":"IF(Main!F41=\"\", \"\", Main!F41)","v":""},{"$f":"IF(Main!G41=\"\", \"\", Main!G41)","v":""},{"$f":"IF(Main!H41=\"\", \"\", Main!H41)","v":""},{"$f":"IF(Main!I41=\"\", \"\", Main!I41)","v":""},null,{"$f":"IF(Main!K41=\"\", \"\", Main!K41)","v":{"$error":"#VALUE!"}}]
["6e","Uncertainty about mean HF treatments per well",null,"Triangular",null,{"$f":"IF(Main!F42=\"\", \"\", Main!F42)","v":""},{"$f":"IF(Main!G42=\"\", \"\", Main!G42)","v":""},{"$f":"IF(Main!H42=\"\", \"\", Main!H42)","v":""},{"$f":"IF(Main!I42=\"\", \"\", Main!I42)","v":""},null,{"$f":"IF(Main!K42=\"\", \"\", Main!K42)","v":{"$error":"#VALUE!"}}]
["6f","Uncertainty about mean proppant-to-water ratio for HF (lbs per gallon)",null,"Triangular",null,{"$f":"IF(Main!F43=\"\", \"\", Main!F43)","v":""},{"$f":"IF(Main!G43=\"\", \"\", Main!G43)","v":""},{"$f":"IF(Main!H43=\"\", \"\", Main!H43)","v":""},{"$f":"IF(Main!I43=\"\", \"\", Main!I43)","v":""},null,{"$f":"IF(Main!K43=\"\", \"\", Main!K43)","v":{"$error":"#VALUE!"}}]
["6g","Uncertainty about mean flowback percentage (%)",null,"Triangular",null,{"$f":"IF(Main!F44=\"\", \"\", Main!F44)","v":""},{"$f":"IF(Main!G44=\"\", \"\", Main!G44)","v":""},{"$f":"IF(Main!H44=\"\", \"\", Main!H44)","v":""},{"$f":"IF(Main!I44=\"\", \"\", Main!I44)","v":""},null,{"$f":"IF(Main!K44=\"\", \"\", Main!K44)","v":{"$error":"#VALUE!"}}]
["6h","Uncertainty about mean water/petroleum ratio (bw/bo or gal/mcfg)",null,"Triangular",null,{"$f":"IF(Main!F45=\"\", \"\", Main!F45)","v":""},{"$f":"IF(Main!G45=\"\", \"\", Main!G45)","v":""},{"$f":"IF(Main!H45=\"\", \"\", Main!H45)","v":""},{"$f":"IF(Main!I45=\"\", \"\", Main!I45)","v":""},null,{"$f":"IF(Main!K45=\"\", \"\", Main!K45)","v":{"$error":"#VALUE!"}}]
["6i","Uncertainty about mean EUR (mmbo or bcfg)",null,"Lognormal",null,{"$f":"IF(Main!F46=\"\", \"\", Main!F46)","v":""},{"$f":"IF(Main!G46=\"\", \"\", Main!G46)","v":""},{"$f":"IF(Main!H46=\"\", \"\", Main!H46)","v":""},{"$f":"IF(Main!I46=\"\", \"\", Main!I46)","v":""},null,{"$f":"IF(Main!K46=\"\", \"\", Main!K46)","v":0}]
[]
[]
[]
[null,"AU Probability"]