170 functions are available in Petroleum Office Excel Addin

Function | Category | Description | |
---|---|---|---|

1 | ModifiedHyperbolicDeclineRate | Decline | Modified hyperbolic production decline curve: rate vs time |

2 | ModifiedHyperbolicDeclineCumulative | Decline | Modified hyperbolic production decline curve: cumulative production vs time |

3 | BasicFieldProfile | Decline | Typical field production profile, usually used for annual forecast. |

4 | CombinedFieldProfile | Decline | Field production profile based on drilling shchedule and typical well profile. |

5 | HyperbolicDeclineRate | Decline | Arps hyperbolic production decline curve: rate vs time |

6 | ExponentialDeclineRate | Decline | Arps exponential production decline curve: rate vs time |

7 | HarmonicDeclineRate | Decline | Arps harmonic production decline curve: rate vs time |

8 | HyperbolicDeclineCumulative | Decline | Arps hyperbolic production decline curve: cumulative production vs time |

9 | ExponentialDeclineCumulative | Decline | Arps exponential production decline curve: cumulative production vs time |

10 | HarmonicDeclineCumulative | Decline | Arps harmonic production decline curve: cumulative production vs time |

11 | PowerLawExponentialDeclineRate | Decline | Power Law Exponential Decline Rate-Time Relation |

12 | PressureGradientBeggsBrill | PipeFlow | Pressure gradient for multiphase pipe flow by Beggs and Brill correlation, [psi/ft] It can be applied for any wellbore inclination and flow direction. |

13 | InletPressureBeggsBrill | PipeFlow | Inlet pipe pressure for multiphase pipe flow by Beggs and Brill correlation, [psia]. It can be applied for any wellbore inclination and flow direction. |

14 | OutletPressureBeggsBrill | PipeFlow | Outlet pipe pressure for multiphase pipe flow by Beggs and Brill correlation, [psia]. It can be applied for any wellbore inclination and flow direction. |

15 | PressureGradientGray | PipeFlow | Pressure gradient for multiphase pipe flow by Gray correlation, [psi/ft] It is commonly used for gas wells that are also producing liquid. |

16 | InletPressureGray | PipeFlow | Inlet pressure for multiphase pipe flow by Gray correlation, [psia] It is commonly used for gas wells that are also producing liquid. |

17 | OutletPressureGray | PipeFlow | Outlet pressure for multiphase pipe flow by Gray correlation, [psia] It is commonly used for gas wells that are also producing liquid. |

18 | PressureGradientHarBrown | PipeFlow | Pressure gradient for multiphase pipe flow by Hagedorn and Brown correlation with Griffith modification , [psi/ft]. It was developed for vertical, upward flow and is recommended only for near-vertical wellbores. |

19 | InletPressureHarBrown | PipeFlow | Inlet pressure for multiphase pipe flow by Hagedorn and Brown correlation, [psia]. It was developed for vertical, upward flow and is recommended only for near-vertical wellbores. |

20 | OutletPressureHarBrown | PipeFlow | Outlet pressure for multiphase pipe flow by Hagedorn and Brown correlation, [psia]. It was developed for vertical, upward flow and is recommended only for near-vertical wellbores. |

21 | ReynoldsNumberGas | PipeFlow | Reynolds number for single phase pipe flow of gas (compressible fluid), [dimensionless] |

22 | InletPipePressureGas | PipeFlow | Inlet pipe pressure for single phase pipe flow of gas (compressible fluid), [psia] |

23 | OutletPipePressureGas | PipeFlow | Outlet pipe pressure for single phase pipe flow of gas (compressible fluid), [psia] |

24 | ReynoldsNumberLiquid | PipeFlow | Reynolds number for single phase pipe flow of incompressible, Newtonian fluid, [dimensionless] |

25 | FrictionPressureDropLiquid | PipeFlow | Frictional pressure drop from Fanning equation; Single-phase flow of an incompressible, Newtonian fluid, [psi] |

26 | PotentialEnergyPressureDropLiquid | PipeFlow | Potential energy pressure drop; Single-phase flow of an incompressible, Newtonian fluid, [psi] |

27 | InletPipePressureLiquid | PipeFlow | Inlet pipe pressure for single phase pipe flow of incompressible, Newtonian fluid, [psia] |

28 | OutletPipePressureLiquid | PipeFlow | Outlet pipe pressure for single phase pipe flow of incompressible, Newtonian fluid, [psia] |

29 | PdLSSIHR | PTA | The expression of dimensionless line source solution pressure of infinite homogeneous reservoir. |

30 | PdwVWIHR | PTA | Dimensionless wellbore pressure drop for vertical well in infinite homogenous reservoir. |

31 | PdwVWIHRLSFB | PTA | Dimensionless wellbore pressure drop for vertical well in infinite homogenous reservoir with linear sealing fault boundary. |

32 | PdwVWIHRLCPB | PTA | Dimensionless wellbore pressure drop for vertical well in infinite homogenous reservoir with linear constant pressure boundary. |

33 | PdwVWIHRPSFB | PTA | Dimensionless wellbore pressure drop for vertical well in infinite homogenous reservoir with perpendicular sealing faults boundary. |

34 | PdwVWIHRPCPB | PTA | Dimensionless wellbore pressure drop for vertical well in infinite homogenous reservoir with perpendicular constant pressures boundary. |

35 | PdwVWIHRPMB | PTA | Dimensionless wellbore pressure drop for vertical well in infinite homogenous reservoir with perpendicular mixed boundaries (boundary 1 - fault, boundary 2 - constant pressure). |

36 | PwVWIHR | PTA | Wellbore pressure drop for vertical well in infinite homogenous reservoir, [psi] |

37 | PwVWIHRLSFB | PTA | Wellbore pressure drop for vertical well in infinite homogenous reservoir with linear sealing fault boundary, [psi] |

38 | PwVWIHRLCPB | PTA | Wellbore pressure drop for vertical well in infinite homogenous reservoir with linear constant pressure boundary, [psi] |

39 | PwVWIHRPSFB | PTA | Wellbore pressure drop for vertical well in infinite homogenous reservoir with perpendicular sealing faults boundary, [psi] |

40 | PwVWIHRPCPB | PTA | Wellbore pressure drop for vertical well in infinite homogenous reservoir with perpendicular constant pressures boundary, [psi] |

41 | PwVWIHRPMB | PTA | Wellbore pressure drop for vertical well in infinite homogenous reservoir with perpendicular mixed boundaries (boundary 1 - fault, boundary 2 - constant pressure), [psi] |

42 | ptaPd | PTA | Dimensionless pressure as defined for constant-rate production |

43 | ptaTd | PTA | Dimensionless time |

44 | ptaRwd | PTA | Dimensionless radius |

45 | ptaLd | PTA | Dimensionless distance |

46 | ptaCd | PTA | Dimensionless wellbore storage coefficient |

47 | IFTgoBakerSwerdloff | PVT | Interfacial (surface) tension for live oil by Baker and Swerdloff correlation, [dymes/cm] |

48 | IFTgoAbdulMajeed | PVT | Interfacial (surface) tension for live oil by Abdul-Majeed correlation, [dymes/cm] |

49 | GasDensity | PVT | Gas density, [g/cc] |

50 | Cg | PVT | Gas compressibility, [1/psi] |

51 | Bg | PVT | Gas formation volume factor, [rcf/scf] |

52 | UgLGE | PVT | Lee, Gonzales and Eakin correlation for gas viscosity, [cP] |

53 | TpcSutton | PVT | Sutton correlation for preudo-critical temperature of hydrocarbon gas, [degR] |

54 | TpcStanding | PVT | Standing correlation for preudo-critical temperature of hydrocarbon gas, [degR] |

55 | PpcSutton | PVT | Sutton correlation for preudo-critical pressure of hydrocarbon gas, [psia] |

56 | PpcStanding | PVT | Standing correlation for preudo-critical pressure of hydrocarbon gas, [psia] |

57 | ZfactorBrillBeggs | PVT | Brill and Beggs correlation for gas compressibility factor (Z), [dimensionless] |

58 | ZfactorDAK | PVT | Gas compressibility factor (Z) based on Dranchuk and Abou-Kassem EoS, [dimensionless] |

59 | BoSat | PVT | Oil formation volume factor, P > Pb, [bbl/STB] |

60 | BoUSatStanding | PVT | Standing correlation for oil formation volume factor, P <= Pb, [bbl/STB] |

61 | BoUSatVasquezBeggs | PVT | Vasquez and Beggs correlation for oil formation volume factor, P <= Pb, [bbl/STB] |

62 | BoUSatGlaso | PVT | Glaso correlation for oil formation volume factor, P <= Pb, [bbl/STB] |

63 | BoUSatAlMarhoun | PVT | Al-Marhoun correlation for oil formation volume factor, P <= Pb, [bbl/STB] |

64 | BoUSatPetroskyFarshad | PVT | Petrosky and Farshad correlation for oil formation volume factor, P <= Pb, [bbl/STB] |

65 | BoUSatDindorukChristman | PVT | Dindoruk and Christman correlation for oil formation volume factor, P <= Pb, [bbl/STB] |

66 | CoSatVasquezBeggs | PVT | Vasquez and Beggs correlation for oil compressibility, P > Pb, [1/psi] |

67 | CoUSatVillenaLanzi | PVT | Villena-Lanzi correlation for oil compressibility, P <= Pb, [1/psi] |

68 | PboStanding | PVT | Standing correlation for oil bubble point pressure, [psia] |

69 | PboVasquezBeggs | PVT | Vasquez and Beggs correlation for oil bubble point pressure, [psia] |

70 | PboGlaso | PVT | Glaso correlation for oil bubble point pressure, [psia] |

71 | PboAlMarhoun | PVT | Al-Marhoun correlation for oil bubble point pressure, [psia] |

72 | PboPetroskyFarshad | PVT | Petrosky and Farshad correlation for oil bubble point pressure, [psia] |

73 | PboDoklaOsman | PVT | Dokla and Osman correlation for oil bubble point pressure, [psia] |

74 | PboDindorukChristman | PVT | Dindoruk and Christman correlation for oil bubble point pressure, [psia] |

75 | RsoUSatStanding | PVT | Standing correlation for solution gas-oil ratio, P <= Pb, [scf/STB] |

76 | RsoUSatVasquezBeggs | PVT | Vasquez and Beggs correlation for solution gas-oil ratio, P <= Pb, [scf/STB] |

77 | RsoUSatGlaso | PVT | Glaso correlation for solution gas-oil ratio, P <= Pb, [scf/STB] |

78 | RsoUSatAlMarhoun | PVT | Al-Marhoun correlation for solution gas-oil ratio, P <= Pb, [scf/STB] |

79 | RsoUSatPetroskyFarshad | PVT | Petrosky and Farshad correlation for solution gas-oil ratio, P <= Pb, [scf/STB] |

80 | RsoUSatDindorukChristman | PVT | Dindoruk and Christman correlation for solution gas-oil ratio, P <= Pb, [scf/STB] |

81 | UoSatVasquezBeggs | PVT | Vasquez and Beggs correlation for oil viscosity, P > Pb, [cP] |

82 | UodEgbogah | PVT | Egbogah correlation for dead oil viscosity, [cP] |

83 | UoUSatBeggsRobinson | PVT | Beggs and Robinson correlation for oil viscosity with solution gas, P < = Pb, [cP] |

84 | CfNewmanS | PVT | Newman correlation for rock pore volume compressibility in sandstones, [1/psi] |

85 | CfNewmanL | PVT | Newman correlation for rock pore volume compressibility in limestones, [1/psi] |

86 | BwMcCain | PVT | McCain correlation for water formation volume factor, [bbl/STB] |

87 | RswpMcCain | PVT | McCain correlation for solution gas-water ratio for pure water, [scf/STB] |

88 | RswMcCain | PVT | McCain correlation for solution gas-water ratio for reservoir water, [scf/STB] |

89 | CwSatOsif | PVT | Osif correlation for water compressibility, P >= Pb, [1/psi] |

90 | CwUSatMcCain | PVT | McCain correlation for water compressibility, P <= Pb, [1/psi] |

91 | Uw1McCain | PVT | McCain correlation for water viscosity at atmospheric pressure and reservoir temperature, [cP] |

92 | UwMcCain | PVT | McCain correlation for water viscosity, [cP] |

93 | KrgIKGasOilSand | SCAL | Ibrahim-Koederitz correlation for predicting gas relative permeability in gas-oil system in sandstone. |

94 | KrogIKGasOilCarb | SCAL | Ibrahim-Koederitz correlation for predicting oil relative to gas permeability in carbonate. |

95 | KrgIKGasOilCarb | SCAL | Ibrahim-Koederitz correlation for predicting gas relative permeability in gas-oil system in carbonate. |

96 | KrgwIKGasWater | SCAL | Ibrahim-Koederitz correlation for predicting relative permeability of gas with respect to water. |

97 | KrwIKGasWater | SCAL | Ibrahim-Koederitz correlation for predicting water relative permeability in gas-water system. |

98 | KrowIKSandStrongWaterWet | SCAL | Ibrahim-Koederitz correlation for predicting oil relative permeability in strongly water-wet sandstone. |

99 | KrwIKSandStrongWaterWet | SCAL | Ibrahim-Koederitz correlation for predicting water relative permeability in strongly water-wet sandstone. |

100 | KrowIKCarbStrongWaterWet | SCAL | Ibrahim-Koederitz correlation for predicting oil relative permeability in strongly water-wet carbonate. |

101 | KrwIKCarbStrongWaterWet | SCAL | Ibrahim-Koederitz correlation for predicting water relative permeability in strongly water-wet carbonate. |

102 | KrowIKSandWaterWet | SCAL | Ibrahim-Koederitz correlation for predicting oil relative permeability in water-wet sandstone. |

103 | KrwIKSandWaterWet | SCAL | Ibrahim-Koederitz correlation for predicting water relative permeability in water-wet sandstone. |

104 | KrowIKCarbWaterWet | SCAL | Ibrahim-Koederitz correlation for predicting oil relative permeability in water-wet carbonate. |

105 | KrwIKCarbWaterWet | SCAL | Ibrahim-Koederitz correlation for predicting water relative permeability in water-wet carbonate. |

106 | KrowIKSandInterWet | SCAL | Ibrahim-Koederitz correlation for predicting oil relative permeability in intermediate-wet sandstone. |

107 | KrwIKSandInterWet | SCAL | Ibrahim-Koederitz correlation for predicting water relative permeability in intermediate-wet sandstone. |

108 | KrowIKCarbInterWet | SCAL | Ibrahim-Koederitz correlation for predicting oil relative permeability in intermediate-wet carbonate. |

109 | KrwIKCarbInterWet | SCAL | Ibrahim-Koederitz correlation for predicting water relative permeability in intermediate-wet carbonate. |

110 | KrowIKSandOilWet | SCAL | Ibrahim-Koederitz correlation for predicting oil relative permeability in oil-wet sandstone. |

111 | KrwIKSandOilWet | SCAL | Ibrahim-Koederitz correlation for predicting water relative permeability in oil-wet sandstone. |

112 | KrowIKCarbOilWet | SCAL | Ibrahim-Koederitz correlation for predicting oil relative permeability in oil-wet carbonate. |

113 | KrwIKCarbOilWet | SCAL | Ibrahim-Koederitz correlation for predicting water relative permeability in oil-wet carbonate. |

114 | KrowLET | SCAL | LET-type oil relative permeability, [dimensionless] |

115 | KrwLET | SCAL | LET-type water relative permeability, [dimensionless] |

116 | KrowCorey | SCAL | Corey-type oil relative permeability, [dimensionless] |

117 | KrwCorey | SCAL | Corey-type water relative permeability, [dimensionless] |

118 | KrowHonarpourSandWaterWet | SCAL | Honarpour correlation for predicting oil relative permeability in water wet sandstone and conglomerate. |

119 | KrwHonarpourSandWaterWet | SCAL | Honarpour correlation for predicting water relative permeability in water wet sandstone and conglomerate. |

120 | KrowHonarpourSandInterWet | SCAL | Honarpour correlation for predicting oil relative permeability in intermediately wet sandstone and conglomerate. |

121 | KrwHonarpourSandInterWet | SCAL | Honarpour correlation for predicting water relative permeability in intermediately wet sandstone and conglomerate. |

122 | KrwHonarpourCarbWaterWet | SCAL | Honarpour correlation for predicting water relative permeability in water wet limestone and dolomite. |

123 | KrowHonarpourCarbWaterWet | SCAL | Honarpour correlation for predicting oil relative permeability in water wet limestone and dolomite. |

124 | KrwHonarpourCarbInterWet | SCAL | Honarpour correlation for predicting water relative permeability in intermediately wet limestone and dolomite. |

125 | KrowHonarpourCarbInterWet | SCAL | Honarpour correlation for predicting oil relative permeability in intermediately wet limestone and dolomite. |

126 | KrcgIKGasCond | SCAL | Ibrahim-Koederitz correlation for predicting relative permeability of condensate with respect to gas. |

127 | KrgIKGasCond | SCAL | Ibrahim-Koederitz correlation for predicting gas relative permeability in gas-condensate system. |

128 | KrogIKGasOilSand | SCAL | Ibrahim-Koederitz correlation for predicting oil relative to gas permeability in sandstone. |

129 | CubicSplineInterpolate | Utilities | A natural cubic spline with continuous second derivative in the interior and zero second derivative at the end points. Interpolate at point t. |

130 | CubicSplineDifferentiate | Utilities | A natural cubic spline with continuous second derivative in the interior and zero second derivative at the end points. Differentiate at point t. |

131 | CubicSplineIntegrate | Utilities | A natural cubic spline with continuous second derivative in the interior and zero second derivative at the end points. Integrate up to point t. |

132 | CubicSplineIntegrateT1T2 | Utilities | A natural cubic spline with continuous second derivative in the interior and zero second derivative at the end points. Integrate from point t1 up to point t2. |

133 | CubicSplinesIntersection | Utilities | x value of intersection point between two cubic splines. |

134 | LinearSplineInterpolate | Utilities | Linear Spline Interpolation Algorithm. Interpolate at point t. |

135 | LinearSplineDifferentiate | Utilities | Linear Spline Interpolation Algorithm. Differentiate at point t. |

136 | LinearSplineIntegrate | Utilities | Linear Spline Interpolation Algorithm. Integrate up to point t. |

137 | LinearSplineIntegrateT1T2 | Utilities | Linear Spline Interpolation Algorithm. Integrate from point t1 up to point t2. |

138 | LinearSplinesIntersection | Utilities | x value of intersection point between two linear splines. |

139 | DataDifferentiate | Utilities | Derrivative of for data samples at point t with smoothing. |

140 | ExpIntegralEi | Utilities | The exponential integral function - Ei(x) |

141 | ProximalInterpolate | Utilities | Proximal (Nearest-neighbor) Interpolation Algorithm. Interpolate at point t. |

142 | StepInterpolate | Utilities | Step Interpolation Algorithm. Interpolate at point t. |

143 | UnitConverter | Utilities | Converts a number from one measurement system to another. |

144 | SG2API | Utilities | Converts a oil specific gravity to API gravity |

145 | API2SG | Utilities | Converts a API gravity to oil specific gravity (water=1.0) |

146 | GasFlowRatePSS | WellFlow | Gas well flow rate for pseudosteady state condition using Darcy flow approximation, [mscf/d] |

147 | GasFlowRatePSSNonDarcy | WellFlow | Gas well stabilized flow rate for pseudosteady state condition, with Non-Darcy flow equation, [mscf/d] |

148 | TimeToPSSGas | WellFlow | Time to stabilized flow in gas well, [h] |

149 | NonDarcyCoefficient | WellFlow | Correlation for estimating non-Darcy coefficient, [d/mscf] |

150 | DrainageRadius | WellFlow | Effective drainage radius, [ft] |

151 | DrainageAreaHorWell1 | WellFlow | The horizontal well drainage area is represented by two half circles of radius b at each end and a rectangle, of dimensions L(2b), in the center. (Joshi Method 1), [acres] |

152 | DrainageAreaHorWell2 | WellFlow | The horizontal well drainage area is an ellipse. (Joshi Method 2), [acres] |

153 | EffectiveWellboreRadius | WellFlow | Effective wellbore radius, [ft] |

154 | EquivalentSkinFactor | WellFlow | Equivalent skin factor for vertical well with hydraulic fracture. |

155 | FlowRateTFVogel | WellFlow | Vogel inflow performance for transient-state flow, [STB/d] |

156 | FlowRateTF | WellFlow | Transient-state production flow rate, [STB/d] |

157 | ProdIndexTF | WellFlow | Transient state productivity index for vertical well, [STB/(d.psi)] |

158 | FlowRatePSSVogel | WellFlow | Vogel inflow performance for pseudosteady state flow, [STB/d] |

159 | FlowRatePSS | WellFlow | Pseudosteady state production flow rate, [STB/d] |

160 | TimeToPSS | WellFlow | Time to pseudosteady state for regular shape drainage area, [h] |

161 | ProdIndexPSS | WellFlow | Pseudosteady state productivity index for vertical well, [STB/(d.psi)] |

162 | FlowRateSSVogel | WellFlow | Vogel inflow performance for Steady state flow, [STB/d] |

163 | FlowRateSS | WellFlow | Steady state production flow rate, [STB/d] |

164 | ProdIndexSS | WellFlow | Steady state productivity index for vertical well, [STB/(d.psi)] |

165 | ProdIndexHorWellBorisov | WellFlow | Horizontal well productivity index under steady state flow. Borisov method for well in an isotropic reservoir, [STB/(d.psi)] |

166 | ProdIndexHorWellGRJ | WellFlow | Horizontal well productivity index under steady state flow. The Giger-Reiss-Jourdan method for well in an anisotropic reservoir, [STB/(d.psi)] |

167 | ProdIndexHorWellJoshi | WellFlow | Horizontal well productivity index under steady state flow. The Joshi method for well in an anisotropic reservoir, [STB/(d.psi)] |

168 | ProdIndexHorWellRD | WellFlow | Horizontal well productivity index under steady state flow. The Renard-Dupuy method for well in an anisotropic reservoir, [STB/(d.psi)] |

169 | ProdIndexHorWellBO | WellFlow | Pseudosteady state productivity index for horizontal well, [STB/(d.psi)] The Babu Odeh method for a box-shaped , anisotropic reservoir, with a well placed parallel to X(box length)-direction. |

170 | ProdIndexHorWellBO2 | WellFlow | Pseudosteady state productivity index for horizontal well, [STB/(d.psi)] The Babu Odeh method for a box-shaped , anisotropic reservoir, with a well centrally placed parallel to X(box length)-direction. |