Here are 4 tables of iterated values for bottom hole pressures in CO2 injection wells. I’d like to be able to input a Surface Pressure (Psurf), TD (total depth), average fluid temperature Tavg, and CO2% and have excel go find the best approximation of the bottom hole pressure from the tables. Basically it needs to do 4 interpolations. I am totally stumped. Any help at all would be much appreciated. I've pasted the four data sets the best I can.
Thanks
John
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
<colgroup><col><col span="7"></colgroup><tbody>
</tbody>
Thanks
John
CO2 | 100 | |||||||
TD=4925 | Tavg=70 | Tavg=75 | Tavg=80 | Tavg=85 | Tavg=90 | Tavg=95 | Tavg=100 | |
Psurf | 1800 | 3672 | 3635 | 3595 | 3553 | 3509 | 3461 | 3409 |
Psurf | 1850 | 3729 | 3692 | 3654 | 3612 | 3569 | 3522 | 3471 |
Psurf | 1900 | 3786 | 3750 | 3712 | 3671 | 3629 | 3583 | 3533 |
Psurf | 1950 | 3843 | 3807 | 3771 | 3731 | 3690 | 3645 | 3596 |
Psurf | 2000 | 3899 | 3865 | 3828 | 3788 | 3748 | 3705 | 3658 |
Psurf | 2050 | 3955 | 3921 | 3886 | 3847 | 3807 | 3765 | 3720 |
Psurf | 2100 | 4011 | 3978 | 3943 | 3905 | 3866 | 3825 | 3782 |
Psurf | 2150 | 4067 | 4035 | 4001 | 3964 | 3926 | 3887 | 3845 |
Psurf | 2200 | 4123 | 4091 | 4058 | 4022 | 3985 | 3947 | 3907 |
Psurf | 2250 | 4179 | 4147 | 4115 | 4080 | 4044 | 4007 | 3979 |
Psurf | 2300 | 4234 | 4203 | 4171 | 4137 | 4102 | 4066 | 4029 |
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
CO2 | 98 | |||||||
Depth | TD=4925 | Tavg=70 | Tavg=75 | Tavg=80 | Tavg=85 | Tavg=90 | Tavg=95 | Tavg=100 |
Psurf | 1800 | 3647 | 3614 | 3578 | 3542 | 3503 | 3461 | 3417 |
Psurf | 1850 | 3703 | 3670 | 3634 | 3598 | 3559 | 3518 | 3474 |
Psurf | 1900 | 3759 | 3727 | 3691 | 3656 | 3618 | 3577 | 3534 |
Psurf | 1950 | 3815 | 3783 | 3748 | 3713 | 3675 | 3635 | 3594 |
Psurf | 2000 | 3871 | 3840 | 3805 | 3771 | 3734 | 3695 | 3655 |
Psurf | 2050 | 3927 | 3896 | 3862 | 3828 | 3792 | 3754 | 3715 |
Psurf | 2100 | 3982 | 3952 | 3919 | 3886 | 3850 | 3813 | 3775 |
Psurf | 2150 | 4038 | 4009 | 3976 | 3944 | 3909 | 3873 | 3836 |
Psurf | 2200 | 4093 | 4064 | 4032 | 4000 | 3966 | 3931 | 3895 |
Psurf | 2250 | 4147 | 4119 | 4088 | 4057 | 4024 | 3990 | 3955 |
Psurf | 2300 | 4203 | 4175 | 4145 | 4115 | 4083 | 4051 | 4017 |
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
CO2 | 100 | |||||||
TD=4975 | Tavg=70 | Tavg=75 | Tavg=80 | Tavg=85 | Tavg=90 | Tavg=95 | Tavg=100 | |
Psurf | 1800 | 3691 | 3653 | 3613 | 3571 | 3527 | 3479 | 3426 |
Psurf | 1850 | 3747 | 3710 | 3672 | 3630 | 3587 | 3540 | 3489 |
Psurf | 1900 | 3804 | 3768 | 3730 | 3689 | 3647 | 3601 | 3551 |
Psurf | 1950 | 3861 | 3825 | 3789 | 3749 | 3708 | 3663 | 3614 |
Psurf | 2000 | 3917 | 3883 | 3846 | 3806 | 3766 | 3723 | 3676 |
Psurf | 2050 | 3973 | 3939 | 3904 | 3865 | 3825 | 3783 | 3738 |
Psurf | 2100 | 4029 | 3996 | 3961 | 3923 | 3884 | 3843 | 3800 |
Psurf | 2150 | 4085 | 4053 | 4019 | 3982 | 3944 | 3905 | 3863 |
Psurf | 2200 | 4141 | 4109 | 4076 | 4040 | 4003 | 3965 | 3925 |
Psurf | 2250 | 4197 | 4165 | 4133 | 4098 | 4062 | 4025 | 3997 |
Psurf | 2300 | 4254 | 4221 | 4189 | 4155 | 4120 | 4084 | 4046 |
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
CO2 | 98 | ||||||
TD=4975 | Tavg=70 | Tavg=75 | Tavg=80 | Tavg=85 | Tavg=90 | Tavg=95 | Tavg=100 |
1800 | 3666 | 3632 | 3596 | 3560 | 3521 | 3479 | 3434 |
1850 | 3721 | 3688 | 3652 | 3616 | 3577 | 3536 | 3492 |
1900 | 3777 | 3745 | 3709 | 3674 | 3636 | 3595 | 3552 |
1950 | 3833 | 3801 | 3766 | 3731 | 3693 | 3653 | 3612 |
2000 | 3889 | 3858 | 3823 | 3789 | 3752 | 3713 | 3673 |
2050 | 3945 | 3914 | 3880 | 3846 | 3810 | 3772 | 3733 |
2100 | 4000 | 3970 | 3937 | 3904 | 3868 | 3831 | 3793 |
2150 | 4056 | 4027 | 3994 | 3962 | 3927 | 3891 | 3854 |
2200 | 4111 | 4082 | 4050 | 4018 | 3984 | 3949 | 3913 |
2250 | 4165 | 4137 | 4106 | 4075 | 4042 | 4008 | 3973 |
2300 | 4222 | 4193 | 4163 | 4133 | 4101 | 4069 | 4035 |
<colgroup><col><col span="7"></colgroup><tbody>
</tbody>