PO.FA.Asphaltene.deBoer


Description

Screens a live oil for asphaltene deposition by the de Boer plot: its undersaturation, the reservoir pressure less the bubble point, against its density at reservoir conditions. Light, highly undersaturated oils hold the least asphaltene in solution and lose the most solvency as the pressure falls to the bubble point, so they sit in the severe region; heavy oils close to saturation sit in the no-problem region whatever their asphaltene content. The function returns the region, 0 for no problems, 1 for slight (possible) problems and 2 for severe problems, or either boundary's undersaturation at the given density, so a sheet can draw the plot.

Formula

=LAMBDA(dp, rho, output, IF(OR(dp<0, rho<0.5, rho>0.9), NA(), LET( slight, IF(rho<0.55, 915+5200*(rho-0.5), IF(rho<0.6, 1175+2300*(rho-0.55), IF(rho<0.65, 1290+6000*(rho-0.6), IF(rho<0.675, 1590+10200*(rho-0.65), IF(rho<0.7, 1845+14200*(rho-0.675), IF(rho<0.725, 2200+22800*(rho-0.7), IF(rho<0.75, 2770+28000*(rho-0.725), IF(rho<0.775, 3470+36800*(rho-0.75), IF(rho<0.8, 4390+47200*(rho-0.775), IF(rho<0.825, 5570+60000*(rho-0.8), 7070+69200*(rho-0.825))))))))))), severe, IF(rho<0.55, 1790+11800*(rho-0.5), IF(rho<0.6, 2380+6000*(rho-0.55), IF(rho<0.65, 2680+8000*(rho-0.6), IF(rho<0.675, 3080+18800*(rho-0.65), IF(rho<0.7, 3550+29600*(rho-0.675), IF(rho<0.725, 4290+42400*(rho-0.7), IF(rho<0.75, 5350+53200*(rho-0.725), IF(rho<0.775, 6680+73200*(rho-0.75), 8510+81600*(rho-0.775))))))))), IF(output="Region", IF(dp>severe, 2, IF(dp>slight, 1, 0)), IF(output="Slight", slight, IF(output="Severe", severe, NA()))))))

Parameters

Parameter Unit Description
dp psi Undersaturation: the initial reservoir pressure less the bubble point at reservoir temperature, 0 or more
rho g/cm³ In-situ density of the live oil at reservoir pressure and temperature, 0.5 to 0.9 (the plot's range)
output text "Region" (0 no problems, 1 slight problems, 2 severe problems), "Slight" (the undersaturation above which slight problems start, psi) or "Severe" (the undersaturation above which problems are severe, psi)

Examples

Invocation Expected
=PO.FA.Asphaltene.deBoer(3251, 0.738, "Region") 1
=PO.FA.Asphaltene.deBoer(3251, 0.738, "Slight") 3134
=PO.FA.Asphaltene.deBoer(3251, 0.738, "Severe") 6041.6
=PO.FA.Asphaltene.deBoer(4300, 0.62, "Region") 2
=PO.FA.Asphaltene.deBoer(9300, 0.81, "Region") 1
=PO.FA.Asphaltene.deBoer(0, 0.6, "Slight") 1290
=PO.FA.Asphaltene.deBoer(0, 0.6, "Severe") 2680
=PO.FA.Asphaltene.deBoer(1289, 0.6, "Region") 0
=PO.FA.Asphaltene.deBoer(1291, 0.6, "Region") 1
=PO.FA.Asphaltene.deBoer(2681, 0.6, "Region") 2
=PO.FA.Asphaltene.deBoer(0, 0.75, "Slight") 3470
=PO.FA.Asphaltene.deBoer(0, 0.75, "Severe") 6680
=PO.FA.Asphaltene.deBoer(0, 0.5, "Slight") 915
=PO.FA.Asphaltene.deBoer(0, 0.85, "Slight") 8800
=PO.FA.Asphaltene.deBoer(1380, 0.658, "Region") 0
=PO.FA.Asphaltene.deBoer(0, 0.7, "Region") 0
=IF(ISNA(PO.FA.Asphaltene.deBoer(1000, 0.45, "Region")), 1, 0) 1
=IF(ISNA(PO.FA.Asphaltene.deBoer(1000, 0.7, "Onset")), 1, 0) 1

Need a custom LAMBDA? Suggest a New Lambda