---
cid: po.bp.scal.relperm.fit
hub: scal
tags: [SCAL, Corey, LET, relative-permeability, regression, LINEST, core-data, oil-water, simulation-input]
facets: { discipline: reservoir, property: rel-perm, phase: water-oil, model: corey, method-type: empirical }
title: Relative Permeability Fit by LINEST
summary: "Regresses Corey exponents on lab relative permeability points and reports the fit's error statistics."
slug: po.scal.relperm.fit
type: worksheet
---

# Relative Permeability Fit by LINEST

## Description

How well does a Corey model hold a set of lab water-oil relative permeability points, and what endpoints do the points imply? You enter the measured endpoints, the lab Sw, Krw and Krow, and which model to use. You read off each Corey exponent and implied endpoint from LINEST on the logarithms, the exponents through the measured endpoints, the R², RMS, average and largest misses, three checks on the data, the fit and the endpoints, and the model curves over the lab points.

**Parameters:**
- **Measured endpoints**: irreducible water saturation `RPF_Swi`, residual oil saturation to water `RPF_Sorw`, Krow at Swi `RPF_KroEnd` and Krw at Sorw `RPF_KrwEnd`
- **Model**: `RPF_Mode`, 1 for the fitted endpoints and exponents, 2 for the measured endpoints with the exponents fitted through them
- **Lab points**: Sw, Krw and Krow at each point, the `RPF_Points` table (named `RPF_Sw`, `RPF_Krw` and `RPF_Krow`)
- **Check limits**: the lowest R² of each log fit `RPF_R2Min` (0.98), the largest average relative miss `RPF_AareMax` (10 %), and the largest gap between a fitted and a measured endpoint `RPF_EndTol` (5 %)

**How to use it:** Paste the SCAL report's Sw, Krw and Krow over the points table, using points strictly between Swi and 1 − Sorw with both kr above zero (the fit takes logarithms), and type the report's measured endpoints. Choose the model: the free fit's endpoints and exponents, or the measured endpoints with the exponents fitted through them. Where the SCAL Endpoint Analysis sheet averages several plugs' endpoints and fits the exponents through them, this sheet lets the points speak for their own endpoints and reports the errors. If one Corey exponent doesn't hold the points (the fit check warns), fit LET instead; the sheet ships no Solver model. Set Solver to minimise the sum of squared log misses, Σ (ln kr − ln kr(LET))², over L, E and T of the LET water and oil functions, starting from L = the Corey exponent, E = 1 and T = 1, inside Lomeland's bounds (L ≥ 1, E > 0, T ≥ 0.5). Type the model's exponents and endpoints into the SCAL Tables Export sheet for the simulator keywords.

**Method:**

- **Normalised saturation.** Sw* = (Sw − Swi)/(1 − Swi − Sorw) on the measured Swi and Sorw.
- **Free fit.** Corey's Krw = Krw@Sorw·Sw*^Nw and Krow = Krow@Swi·(1 − Sw*)^No are straight lines in logarithms: ln Krw = ln Krw@Sorw + Nw·ln Sw*, and ln Krow = ln Krow@Swi + No·ln(1 − Sw*). `INDEX(LINEST(ln Krw, ln Sw*), 1)` is Nw and `EXP(INDEX(…, 2))` the Krw@Sorw the points imply; likewise for oil. R² is `RSQ` on the same logarithms.
- **Through the measured endpoints.** `LINEST(ln Krw − ln Krw@Sorw, ln Sw*, FALSE)` fits the same line with no intercept, so its slope is the exponent at the measured endpoint, Σxy/Σx².
- **Model and errors.** Corey on the chosen pair, written in the cells at each point and across the mobile range: the catalog's Corey functions refuse an endpoint above 1, and a free fit can imply one (1.0074 here). The RMS miss is √(Σ (model − lab)²/n), the average relative miss (AARE) the mean of |model/lab − 1|, and the largest miss the largest |model/lab − 1| of either phase. A fit in logarithms weighs each point by its relative miss, as the log scales a SCAL report is read on do.
- **Checks.** Data: fails for a model other than 1 or 2, a point outside the open mobile range or with a kr of zero, or fewer than three points. Fit: both R² at least the lowest R² and both AARE at most the largest average miss, else a warning that one exponent doesn't hold the points. Endpoints: the free fit's Krw@Sorw and Krow@Swi within the endpoint tolerance of the measured ones.

**Example:** The defaults are the rock the SCAL sheets share: a water-wet sandstone with Swi 20 %, Sorw 25 %, Krow@Swi 1 and Krw@Sorw 0.35, whose Corey exponents are Nw 2 and No 2.5. The nine lab points are synthetic: that rock's curves at Sw* = 0.1, 0.2, … 0.9 (Sw 25.5 % to 69.5 %), each given 2 to 6 % of scatter and read to four places. The free fit gives Nw = 1.9859 with a Krw@Sorw of 0.3461 (R² 0.99934), and No = 2.5147 with a Krow@Swi of 1.0074 (R² 0.99951), close to the 2 and 2.5 the points were built from. Through the measured endpoints the exponents are 1.9938 and 2.5094. The free model misses Krw by 0.0032 and Krow by 0.0110 RMS, 3.22 % and 3.65 % on average, and 6.49 % at worst (Krw at the second point, Sw 31 %, where the lab reads 0.0133 and the model 0.0142). The endpoints the points imply are within 1.11 % of the measured ones.

## Validity

Corey's form fits a curve with one exponent per phase. Where the measured curves change shape across the saturation range, as many mixed-wet and carbonate curves do, the fit check warns and LET is the alternative. A fit in logarithms weighs the low-kr points as heavily as the high ones; their lab uncertainty is often larger, so read the largest miss with the point it comes from. The free fit's endpoints are extrapolations to Sw* = 0 and 1 and should agree with the measured ones; a large gap means an endpoint is wrong or the curve is not Corey-shaped near it. The measured Swi and Sorw define Sw*, so an error in them moves both exponents. The sheet fits steady- or unsteady-state points that are already corrected (JBN or history-matched); it does no capillary end-effect correction.

Named alternatives: LET (Lomeland, Ebeltoft and Thomas, 2005) by Solver; Chierici's exponential form; a fit through the measured endpoints only (the SCAL Endpoint Analysis sheet); history matching the core flood directly.

## References

- Corey, A.T. (1954). "The Interrelation Between Gas and Oil Relative Permeabilities." *Producers Monthly* 19(1), 38–41.
- Brooks, R.H. and Corey, A.T. (1964). *Hydraulic Properties of Porous Media*. Hydrology Paper 3, Colorado State University.
- Lomeland, F., Ebeltoft, E. and Thomas, W.H. (2005). "A New Versatile Relative Permeability Correlation." SCA2005-32, International Symposium of the Society of Core Analysts.
- Honarpour, M., Koederitz, L. and Harvey, A.H. (1986). *Relative Permeability of Petroleum Reservoirs*. CRC Press, ch. 2 and 3.
- McPhee, C., Reed, J. and Zubizarreta, I. (2015). *Core Analysis: A Best Practice Guide*. Elsevier, ch. 10 (relative permeability data and its models).

## Functions used

None: the sheet uses only Excel's built-in functions.

## Spreadsheet: ScalRelpermFit

|    | A                                                                                                                                                                 | B                                                                                                                                                                                      | C                                                                                                                                                                                                                                                                                                                                                                                                                                          | D                                         | E          | F               | G          | H           | I                                       | J                                         | K               | L               |
|----|-------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------|------------|-----------------|------------|-------------|-----------------------------------------|-------------------------------------------|-----------------|-----------------|
| 1  | Relative Permeability Fit by LINEST                                                                                                                               |                                                                                                                                                                                        | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                           |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 2  | Blue cells on yellow are inputs. Type the endpoints and paste the lab's Sw, Krw and Krow over the points table; the exponents, the errors and the overlay follow. |                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 3  | Measured Endpoints (the SCAL sheets' shared rock) and the Model                                                                                                   |                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 4  | Irreducible water saturation, Swi                                                                                                                                 | 0.2                                                                                                                                                                                    | %                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 5  | Residual oil saturation to water, Sorw                                                                                                                            | 0.25                                                                                                                                                                                   | %                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 6  | Measured Krow at Swi                                                                                                                                              | 1                                                                                                                                                                                      | frac                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 7  | Measured Krw at Sorw                                                                                                                                              | 0.35                                                                                                                                                                                   | frac                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 8  | Model the curves use: 1 fitted endpoints, 2 measured ones                                                                                                         | 1                                                                                                                                                                                      | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 9  | Check Limits                                                                                                                                                      |                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 10 | Lowest R² of each log fit                                                                                                                                         | 0.98                                                                                                                                                                                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 11 | Largest average relative miss of the model at the points                                                                                                          | 0.1                                                                                                                                                                                    | %                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 12 | Largest gap between a fitted and a measured endpoint                                                                                                              | 0.05                                                                                                                                                                                   | %                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 14 | The Fits, the Model and Its Errors                                                                                                                                |                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 15 | Mobile oil saturation, 1 − Swi − Sorw                                                                                                                             | =1-RPF_Swi-RPF_Sorw                                                                                                                                                                    | %                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 16 | Lab points                                                                                                                                                        | =COUNT(RPF_Sw)                                                                                                                                                                         | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 17 | Water exponent Nw, LINEST slope of ln Krw on ln Sw*                                                                                                               | =INDEX(LINEST(RPF_LnKrw,RPF_LnS),1)                                                                                                                                                    | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 18 | Krw at Sorw the points imply, e^intercept                                                                                                                         | =EXP(INDEX(LINEST(RPF_LnKrw,RPF_LnS),2))                                                                                                                                               | frac                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 19 | R² of the water fit                                                                                                                                               | =RSQ(RPF_LnKrw,RPF_LnS)                                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 20 | Oil exponent No, LINEST slope of ln Krow on ln(1 − Sw*)                                                                                                           | =INDEX(LINEST(RPF_LnKrow,RPF_Ln1S),1)                                                                                                                                                  | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 21 | Krow at Swi the points imply, e^intercept                                                                                                                         | =EXP(INDEX(LINEST(RPF_LnKrow,RPF_Ln1S),2))                                                                                                                                             | frac                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 22 | R² of the oil fit                                                                                                                                                 | =RSQ(RPF_LnKrow,RPF_Ln1S)                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 23 | Nw at the measured Krw@Sorw, LINEST through the origin                                                                                                            | =INDEX(LINEST(RPF_LnKrw-LN(RPF_KrwEnd),RPF_LnS,FALSE),1)                                                                                                                               | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 24 | No at the measured Krow@Swi, LINEST through the origin                                                                                                            | =INDEX(LINEST(RPF_LnKrow-LN(RPF_KroEnd),RPF_Ln1S,FALSE),1)                                                                                                                             | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 25 | Model water exponent                                                                                                                                              | =CHOOSE(MIN(2,MAX(1,INT(RPF_Mode))),RPF_Nw,RPF_NwFix)                                                                                                                                  | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 26 | Model Krw at Sorw                                                                                                                                                 | =CHOOSE(MIN(2,MAX(1,INT(RPF_Mode))),RPF_KrwFit,RPF_KrwEnd)                                                                                                                             | frac                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 27 | Model oil exponent                                                                                                                                                | =CHOOSE(MIN(2,MAX(1,INT(RPF_Mode))),RPF_No,RPF_NoFix)                                                                                                                                  | —                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 28 | Model Krow at Swi                                                                                                                                                 | =CHOOSE(MIN(2,MAX(1,INT(RPF_Mode))),RPF_KroFit,RPF_KroEnd)                                                                                                                             | frac                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 29 | RMS miss of the model's Krw at the points                                                                                                                         | =SQRT(SUMPRODUCT((RPF_KrwMod-RPF_Krw)^2)/RPF_NPts)                                                                                                                                     | frac                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 30 | RMS miss of the model's Krow at the points                                                                                                                        | =SQRT(SUMPRODUCT((RPF_KroMod-RPF_Krow)^2)/RPF_NPts)                                                                                                                                    | frac                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 31 | Average relative miss of the model's Krw (AARE)                                                                                                                   | =AVERAGE(RPF_MissW)                                                                                                                                                                    | %                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 32 | Average relative miss of the model's Krow (AARE)                                                                                                                  | =AVERAGE(RPF_MissO)                                                                                                                                                                    | %                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 33 | Largest relative miss at any point, either phase                                                                                                                  | =MAX(RPF_MissW,RPF_MissO)                                                                                                                                                              | %                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 34 | Data check                                                                                                                                                        | =IF(OR(RPF_Mode<1,RPF_Mode>2,RPF_Mode<>INT(RPF_Mode)),"FAIL",IF(SUMPRODUCT((RPF_Sw<=RPF_Swi)+(RPF_Sw>=1-RPF_Sorw)+(RPF_Krw<=0)+(RPF_Krow<=0))>0,"FAIL",IF(RPF_NPts<=2,"FAIL","PASS"))) | =IF(OR(RPF_Mode<1,RPF_Mode>2,RPF_Mode<>INT(RPF_Mode)),"the model is 1 (fitted endpoints) or 2 (measured endpoints)",IF(SUMPRODUCT((RPF_Sw<=RPF_Swi)+(RPF_Sw>=1-RPF_Sorw)+(RPF_Krw<=0)+(RPF_Krow<=0))>0,"every point needs Sw strictly between Swi and 1 − Sorw and both kr above zero: the fit takes logarithms",IF(RPF_NPts<=2,"the fit needs three points or more","every point lies inside the mobile range with both kr above zero"))) |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 35 | Fit check                                                                                                                                                         | =IF(AND(MIN(RPF_R2w,RPF_R2o)>=RPF_R2Min,MAX(RPF_AareW,RPF_AareO)<=RPF_AareMax),"PASS","WARN")                                                                                          | =IF(AND(MIN(RPF_R2w,RPF_R2o)>=RPF_R2Min,MAX(RPF_AareW,RPF_AareO)<=RPF_AareMax),"R² of "&FIXED(MIN(RPF_R2w,RPF_R2o)*100,2)&" % or more, and the model misses the points by "&FIXED(MAX(RPF_AareW,RPF_AareO)*100,2)&" % on average at most","R² down to "&FIXED(MIN(RPF_R2w,RPF_R2o)*100,2)&" % or an average miss of "&FIXED(MAX(RPF_AareW,RPF_AareO)*100,2)&" %: one Corey exponent does not hold these points; fit LET")                  |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 36 | Endpoint check                                                                                                                                                    | =IF(MAX(ABS(RPF_KrwFit/RPF_KrwEnd-1),ABS(RPF_KroFit/RPF_KroEnd-1))<=RPF_EndTol,"PASS","WARN")                                                                                          | =IF(MAX(ABS(RPF_KrwFit/RPF_KrwEnd-1),ABS(RPF_KroFit/RPF_KroEnd-1))<=RPF_EndTol,"the endpoints the points imply are within "&FIXED(MAX(ABS(RPF_KrwFit/RPF_KrwEnd-1),ABS(RPF_KroFit/RPF_KroEnd-1))*100,2)&" % of the measured ones","an endpoint the points imply is "&FIXED(MAX(ABS(RPF_KrwFit/RPF_KrwEnd-1),ABS(RPF_KroFit/RPF_KroEnd-1))*100,2)&" % off the measured one; check the endpoint, or model on it (2)")                        |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 38 | How to use it: paste the SCAL report's Sw, Krw and Krow over the points table (strictly inside the mobile range) and type its measured endpoints.                 |                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 39 | For a LET fit, set Solver to minimise the squared log misses over L, E and T of the LET water and oil functions, from L = the Corey exponent, E = 1, T = 1.       |                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 40 | The points shipped are synthetic: the shared rock's Corey curves, Nw 2 and No 2.5, with 2 to 6 % of scatter.                                                      |                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 42 | Lab Points, Their Logarithms and the Model's Miss                                                                                                                 |                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 43 | Sw (%)                                                                                                                                                            | Krw, lab (frac)                                                                                                                                                                        | Krow, lab (frac)                                                                                                                                                                                                                                                                                                                                                                                                                           | Sw* (—)                                   | ln Sw* (—) | ln(1 − Sw*) (—) | ln Krw (—) | ln Krow (—) | Krw, model (frac)                       | Krow, model (frac)                        | Krw miss (%)    | Krow miss (%)   |
| 44 | 0.255                                                                                                                                                             | 0.0037                                                                                                                                                                                 | 0.7531                                                                                                                                                                                                                                                                                                                                                                                                                                     | =(A44-RPF_Swi)/RPF_Mobile                 | =LN(D44)   | =LN(1-D44)      | =LN(B44)   | =LN(C44)    | =RPF_UseKrw*MIN(1,MAX(0,D44))^RPF_UseNw | =RPF_UseKro*MIN(1,MAX(0,1-D44))^RPF_UseNo | =ABS(I44/B44-1) | =ABS(J44/C44-1) |
| 45 | 0.31                                                                                                                                                              | 0.0133                                                                                                                                                                                 | 0.5896                                                                                                                                                                                                                                                                                                                                                                                                                                     | =(A45-RPF_Swi)/RPF_Mobile                 | =LN(D45)   | =LN(1-D45)      | =LN(B45)   | =LN(C45)    | =RPF_UseKrw*MIN(1,MAX(0,D45))^RPF_UseNw | =RPF_UseKro*MIN(1,MAX(0,1-D45))^RPF_UseNo | =ABS(I45/B45-1) | =ABS(J45/C45-1) |
| 46 | 0.365                                                                                                                                                             | 0.0328                                                                                                                                                                                 | 0.3936                                                                                                                                                                                                                                                                                                                                                                                                                                     | =(A46-RPF_Swi)/RPF_Mobile                 | =LN(D46)   | =LN(1-D46)      | =LN(B46)   | =LN(C46)    | =RPF_UseKrw*MIN(1,MAX(0,D46))^RPF_UseNw | =RPF_UseKro*MIN(1,MAX(0,1-D46))^RPF_UseNo | =ABS(I46/B46-1) | =ABS(J46/C46-1) |
| 47 | 0.42                                                                                                                                                              | 0.0543                                                                                                                                                                                 | 0.29                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A47-RPF_Swi)/RPF_Mobile                 | =LN(D47)   | =LN(1-D47)      | =LN(B47)   | =LN(C47)    | =RPF_UseKrw*MIN(1,MAX(0,D47))^RPF_UseNw | =RPF_UseKro*MIN(1,MAX(0,1-D47))^RPF_UseNo | =ABS(I47/B47-1) | =ABS(J47/C47-1) |
| 48 | 0.475                                                                                                                                                             | 0.0901                                                                                                                                                                                 | 0.1715                                                                                                                                                                                                                                                                                                                                                                                                                                     | =(A48-RPF_Swi)/RPF_Mobile                 | =LN(D48)   | =LN(1-D48)      | =LN(B48)   | =LN(C48)    | =RPF_UseKrw*MIN(1,MAX(0,D48))^RPF_UseNw | =RPF_UseKro*MIN(1,MAX(0,1-D48))^RPF_UseNo | =ABS(I48/B48-1) | =ABS(J48/C48-1) |
| 49 | 0.53                                                                                                                                                              | 0.121                                                                                                                                                                                  | 0.1063                                                                                                                                                                                                                                                                                                                                                                                                                                     | =(A49-RPF_Swi)/RPF_Mobile                 | =LN(D49)   | =LN(1-D49)      | =LN(B49)   | =LN(C49)    | =RPF_UseKrw*MIN(1,MAX(0,D49))^RPF_UseNw | =RPF_UseKro*MIN(1,MAX(0,1-D49))^RPF_UseNo | =ABS(I49/B49-1) | =ABS(J49/C49-1) |
| 50 | 0.585                                                                                                                                                             | 0.1749                                                                                                                                                                                 | 0.0468                                                                                                                                                                                                                                                                                                                                                                                                                                     | =(A50-RPF_Swi)/RPF_Mobile                 | =LN(D50)   | =LN(1-D50)      | =LN(B50)   | =LN(C50)    | =RPF_UseKrw*MIN(1,MAX(0,D50))^RPF_UseNw | =RPF_UseKro*MIN(1,MAX(0,1-D50))^RPF_UseNo | =ABS(I50/B50-1) | =ABS(J50/C50-1) |
| 51 | 0.64                                                                                                                                                              | 0.2195                                                                                                                                                                                 | 0.0184                                                                                                                                                                                                                                                                                                                                                                                                                                     | =(A51-RPF_Swi)/RPF_Mobile                 | =LN(D51)   | =LN(1-D51)      | =LN(B51)   | =LN(C51)    | =RPF_UseKrw*MIN(1,MAX(0,D51))^RPF_UseNw | =RPF_UseKro*MIN(1,MAX(0,1-D51))^RPF_UseNo | =ABS(I51/B51-1) | =ABS(J51/C51-1) |
| 52 | 0.695                                                                                                                                                             | 0.2863                                                                                                                                                                                 | 0.003                                                                                                                                                                                                                                                                                                                                                                                                                                      | =(A52-RPF_Swi)/RPF_Mobile                 | =LN(D52)   | =LN(1-D52)      | =LN(B52)   | =LN(C52)    | =RPF_UseKrw*MIN(1,MAX(0,D52))^RPF_UseNw | =RPF_UseKro*MIN(1,MAX(0,1-D52))^RPF_UseNo | =ABS(I52/B52-1) | =ABS(J52/C52-1) |
| 55 | The Model Across the Mobile Range                                                                                                                                 |                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                           |            |                 |            |             |                                         |                                           |                 |                 |
| 56 | Sw (%)                                                                                                                                                            | Sw* (—)                                                                                                                                                                                | Krw, model (frac)                                                                                                                                                                                                                                                                                                                                                                                                                          | Krow, model (frac)                        |            |                 |            |             |                                         |                                           |                 |                 |
| 57 | =RPF_Swi+B57*RPF_Mobile                                                                                                                                           | =0/10                                                                                                                                                                                  | =RPF_UseKrw*MIN(1,MAX(0,B57))^RPF_UseNw                                                                                                                                                                                                                                                                                                                                                                                                    | =RPF_UseKro*MIN(1,MAX(0,1-B57))^RPF_UseNo |            |                 |            |             |                                         |                                           |                 |                 |
| 58 | =RPF_Swi+B58*RPF_Mobile                                                                                                                                           | =1/10                                                                                                                                                                                  | =RPF_UseKrw*MIN(1,MAX(0,B58))^RPF_UseNw                                                                                                                                                                                                                                                                                                                                                                                                    | =RPF_UseKro*MIN(1,MAX(0,1-B58))^RPF_UseNo |            |                 |            |             |                                         |                                           |                 |                 |
| 59 | =RPF_Swi+B59*RPF_Mobile                                                                                                                                           | =2/10                                                                                                                                                                                  | =RPF_UseKrw*MIN(1,MAX(0,B59))^RPF_UseNw                                                                                                                                                                                                                                                                                                                                                                                                    | =RPF_UseKro*MIN(1,MAX(0,1-B59))^RPF_UseNo |            |                 |            |             |                                         |                                           |                 |                 |
| 60 | =RPF_Swi+B60*RPF_Mobile                                                                                                                                           | =3/10                                                                                                                                                                                  | =RPF_UseKrw*MIN(1,MAX(0,B60))^RPF_UseNw                                                                                                                                                                                                                                                                                                                                                                                                    | =RPF_UseKro*MIN(1,MAX(0,1-B60))^RPF_UseNo |            |                 |            |             |                                         |                                           |                 |                 |
| 61 | =RPF_Swi+B61*RPF_Mobile                                                                                                                                           | =4/10                                                                                                                                                                                  | =RPF_UseKrw*MIN(1,MAX(0,B61))^RPF_UseNw                                                                                                                                                                                                                                                                                                                                                                                                    | =RPF_UseKro*MIN(1,MAX(0,1-B61))^RPF_UseNo |            |                 |            |             |                                         |                                           |                 |                 |
| 62 | =RPF_Swi+B62*RPF_Mobile                                                                                                                                           | =5/10                                                                                                                                                                                  | =RPF_UseKrw*MIN(1,MAX(0,B62))^RPF_UseNw                                                                                                                                                                                                                                                                                                                                                                                                    | =RPF_UseKro*MIN(1,MAX(0,1-B62))^RPF_UseNo |            |                 |            |             |                                         |                                           |                 |                 |
| 63 | =RPF_Swi+B63*RPF_Mobile                                                                                                                                           | =6/10                                                                                                                                                                                  | =RPF_UseKrw*MIN(1,MAX(0,B63))^RPF_UseNw                                                                                                                                                                                                                                                                                                                                                                                                    | =RPF_UseKro*MIN(1,MAX(0,1-B63))^RPF_UseNo |            |                 |            |             |                                         |                                           |                 |                 |
| 64 | =RPF_Swi+B64*RPF_Mobile                                                                                                                                           | =7/10                                                                                                                                                                                  | =RPF_UseKrw*MIN(1,MAX(0,B64))^RPF_UseNw                                                                                                                                                                                                                                                                                                                                                                                                    | =RPF_UseKro*MIN(1,MAX(0,1-B64))^RPF_UseNo |            |                 |            |             |                                         |                                           |                 |                 |
| 65 | =RPF_Swi+B65*RPF_Mobile                                                                                                                                           | =8/10                                                                                                                                                                                  | =RPF_UseKrw*MIN(1,MAX(0,B65))^RPF_UseNw                                                                                                                                                                                                                                                                                                                                                                                                    | =RPF_UseKro*MIN(1,MAX(0,1-B65))^RPF_UseNo |            |                 |            |             |                                         |                                           |                 |                 |
| 66 | =RPF_Swi+B66*RPF_Mobile                                                                                                                                           | =9/10                                                                                                                                                                                  | =RPF_UseKrw*MIN(1,MAX(0,B66))^RPF_UseNw                                                                                                                                                                                                                                                                                                                                                                                                    | =RPF_UseKro*MIN(1,MAX(0,1-B66))^RPF_UseNo |            |                 |            |             |                                         |                                           |                 |                 |
| 67 | =RPF_Swi+B67*RPF_Mobile                                                                                                                                           | =10/10                                                                                                                                                                                 | =RPF_UseKrw*MIN(1,MAX(0,B67))^RPF_UseNw                                                                                                                                                                                                                                                                                                                                                                                                    | =RPF_UseKro*MIN(1,MAX(0,1-B67))^RPF_UseNo |            |                 |            |             |                                         |                                           |                 |                 |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| RPF_Swi | $B$4 | Irreducible water saturation, Swi, % |
| RPF_Sorw | $B$5 | Residual oil saturation to water, Sorw, % |
| RPF_KroEnd | $B$6 | Measured Krow at Swi, frac |
| RPF_KrwEnd | $B$7 | Measured Krw at Sorw, frac |
| RPF_Mode | $B$8 | Model the curves use: 1 fitted endpoints, 2 measured ones |
| RPF_R2Min | $B$10 | Lowest R² of each log fit |
| RPF_AareMax | $B$11 | Largest average relative miss of the model at the points, % |
| RPF_EndTol | $B$12 | Largest gap between a fitted and a measured endpoint, % |
| RPF_Inputs | $B$4:$B$12 | The measured endpoints, the model the curves use, and the R², average-miss and endpoint limits of the checks |
| RPF_Mobile | $B$15 | Mobile oil saturation, 1 − Swi − Sorw, % |
| RPF_NPts | $B$16 | Lab points |
| RPF_Nw | $B$17 | Water exponent Nw, LINEST slope of ln Krw on ln Sw* |
| RPF_KrwFit | $B$18 | Krw at Sorw the points imply, e^intercept, frac |
| RPF_R2w | $B$19 | R² of the water fit |
| RPF_No | $B$20 | Oil exponent No, LINEST slope of ln Krow on ln(1 − Sw*) |
| RPF_KroFit | $B$21 | Krow at Swi the points imply, e^intercept, frac |
| RPF_R2o | $B$22 | R² of the oil fit |
| RPF_NwFix | $B$23 | Nw at the measured Krw@Sorw, LINEST through the origin |
| RPF_NoFix | $B$24 | No at the measured Krow@Swi, LINEST through the origin |
| RPF_UseNw | $B$25 | Model water exponent |
| RPF_UseKrw | $B$26 | Model Krw at Sorw, frac |
| RPF_UseNo | $B$27 | Model oil exponent |
| RPF_UseKro | $B$28 | Model Krow at Swi, frac |
| RPF_RmseW | $B$29 | RMS miss of the model's Krw at the points, frac |
| RPF_RmseO | $B$30 | RMS miss of the model's Krow at the points, frac |
| RPF_AareW | $B$31 | Average relative miss of the model's Krw (AARE), % |
| RPF_AareO | $B$32 | Average relative miss of the model's Krow (AARE), % |
| RPF_MaxMiss | $B$33 | Largest relative miss at any point, either phase, % |
| RPF_DataCheck | $B$34 | Data check verdict |
| RPF_DataCheckNote | $C$34 | Data check comment |
| RPF_FitCheck | $B$35 | Fit check verdict |
| RPF_FitCheckNote | $C$35 | Fit check comment |
| RPF_EndCheck | $B$36 | Endpoint check verdict |
| RPF_EndCheckNote | $C$36 | Endpoint check comment |
| RPF_Results | $B$15:$B$36 | The mobile range and point count; the free fits' exponents, endpoints and R²; the exponents through the measured endpoints; the model's four parameters; its RMS and average misses and the largest; and three checks |
| RPF_Points | $A$44:$L$52 | Each lab point's Sw, Krw and Krow, its normalised saturation and the logarithms the fits take, the model's Krw and Krow there and the relative misses |
| RPF_Sw | $A$44:$A$52 | Lab water saturations |
| RPF_Krw | $B$44:$B$52 | Lab Krw |
| RPF_Krow | $C$44:$C$52 | Lab Krow |
| RPF_LnS | $E$44:$E$52 | ln Sw* of each point |
| RPF_Ln1S | $F$44:$F$52 | ln(1 - Sw*) of each point |
| RPF_LnKrw | $G$44:$G$52 | ln Krw of each point |
| RPF_LnKrow | $H$44:$H$52 | ln Krow of each point |
| RPF_KrwMod | $I$44:$I$52 | Model Krw at each point |
| RPF_KroMod | $J$44:$J$52 | Model Krow at each point |
| RPF_MissW | $K$44:$K$52 | Relative miss of the model Krw at each point |
| RPF_MissO | $L$44:$L$52 | Relative miss of the model Krow at each point |
| RPF_Curve | $A$57:$D$67 | Sw from Swi to 1 − Sorw, Sw*, and the model's Krw and Krow |

---

## Related Blueprints
- [Corey Relative Permeability Curves](/blueprint/po.scal.corey.relperm.md)
- [SCAL Tables Export for SWOF and SGOF](/blueprint/po.scal.tables.export.md)
- [SCAL Endpoint Analysis](/blueprint/po.scal.endpoint.analysis.md)
- [Honarpour Gas-Oil Relative Permeability](/blueprint/po.scal.honarpour.gasoil.md)
- [Waterflood Fractional Flow Analysis](/blueprint/po.scal.fractional.flow.md)
- [Relative Permeability Model Comparison](/blueprint/po.scal.models.compare.md)

