Question: 2) Develop an EXCEL spreadsheet for generating the well function curve using the polynomial expansion. You can chop the polynomial at 12 terms. Submit a
2) Develop an EXCEL spreadsheet for generating the well function curve using the polynomial expansion. You can chop the polynomial at 12 terms. Submit a plot of your output and the spreadsheet or the program. Also, give the value of W(u) for U 0.2 and U-0.015, as predicted by your program, when you include 2, 4, 8, and 12 terms in the series. Please give all the significant figures reported by your computer program. 2) Develop an EXCEL spreadsheet for generating the well function curve using the polynomial expansion. You can chop the polynomial at 12 terms. Submit a plot of your output and the spreadsheet or the program. Also, give the value of W(u) for U 0.2 and U-0.015, as predicted by your program, when you include 2, 4, 8, and 12 terms in the series. Please give all the significant figures reported by your computer program
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
