I have an Excel sheet to magnify (replicate) a timeseries of daily sewage patterns with a certain peak factor to a similar pattern but with another peak factor; the X-axis has time in hours, and the Y-axis has the value of the peak factor. Usually, I change the peak factor value and get the new pattern. The average value has to equal 1, and the number of hours equals 24 based on the required new peak factor. I iterate the cell E30 to get an average of 1 and total hours of 24
Description of the Excel sheet: • Column A Hour: has time from 1 to 24 hours • Column B Original Pattern: has the value from the original pattern • Column C Unit Pattern: is used to make the peak factor equal to 1 • Column D Reduced: use of a function to reduce the error from the Unit Pattern • Column E Pattern: is for the new pattern of the new peak factor • Column F Required Peak Factor: the required peak factor.
Is there any python function to automate this process? The Link to Excel Sheet: https://docs.google.com/spreadsheets/d/1HYGTGo0-riI7ajFSZBnOMf2iM3P8msaF/edit?usp=sharing&ouid=117376103914635182979&rtpof=true&sd=true