• State Verified Answer
  • Locked Locked
  • Replies 1 reply
  • Subscribers 83 subscribers
  • Views 1343 views
  • Users 0 members are here
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Average to max day calculations

appan
Offline

Hello:

I was trying to calculate the average to max day  peaking factor. I used flow data for 5 years and got a factor of  around 1.5.

Please find attached the spread sheet. Is this how one calculates average to max ratio? Dec-march are the hottest months in Queanbeyan.

thanks,

Indu 

offtake 1 flows.xlsx
Parents
  • 0 Offline

    Hi Indu,

    I looked at the spreadsheet and based on the way it's calculated I have a question about Max day. In my understanding, Max day demand is the highest daily demand for the range or that year.

    to me,

       Max Day Demand for xx year (MDD) = MAX(Demand_data_for_xx_year)
       Average Day Demand for xx year (ADD) = AVERAGE(Demand_data_for_xx_year)
       Ratio = MDD/ADD

    Hope this helps,



    Answer Verified By: Sushma Choure 

Reply
  • 0 Offline

    Hi Indu,

    I looked at the spreadsheet and based on the way it's calculated I have a question about Max day. In my understanding, Max day demand is the highest daily demand for the range or that year.

    to me,

       Max Day Demand for xx year (MDD) = MAX(Demand_data_for_xx_year)
       Average Day Demand for xx year (ADD) = AVERAGE(Demand_data_for_xx_year)
       Ratio = MDD/ADD

    Hope this helps,



    Answer Verified By: Sushma Choure 

Children
No Data
Communities
Support and Services
Training and Learning
Social Media