[link Point to another website Only the registered members can access]
In LP Dake’s Book on “Fundamentals of Reservoir Engineering”, Exercise 7.2, there is a numerical for Pressure Drawdown Testing where the Dietz Shape factor is calculated & the corresponding geometric configuration of the well is found.

Please see the attached worked out Excel file.

In the numerical, keeping all other parameters same, I wanted to solve it for a longer flowing time. I have taken the flowing time t as 16520 hrs. And I have distributed the Flowing Bottom hole pressures according to this flowing time i.e from t=0 to t=16520 hrs.

However, finally I got a very high value of Dietz shape factor (=1380308). Please see attached Excel file.

My question is:
i) Is my calculation procedure & the resulting Dietz shape factor correct. If not, where did I go wrong.?
ii) If correct, what is the corresponding geometric configuration of the well in the reservoir?