reqs.md

#Project Requirements / Goals

##Calculate Weekly averages

• Rolling weekly average of the last 7 days
• This is easy to do.
• Week To Date Average
• Sunday just uses Sunday for the average
• Monday uses Sunday and Monday
• Tuesday uses Sunday - Tuesday
• ...
• Saturday uses Sunday - Saturday

##Calculate Monthly Averages

• Rolling monthly average of the last 30 days
• This is easy to do
• Month To Date Average
• First day uses just first day.
• Second day uses days 1-2
• Third day uses days 1-3
• ...
• last day uses 1- ( 28, 29, 30 or 31)

##Calculate Yearly Average

• Year To Date Running Average
• This is easy to do.

sheets.txt

=if(B4 = "Sunday",average(D4:D4), if(B4 = "Monday",average(D4:D5), if(B4 = "Tuesday",average(D4:D6), if(B4 = "Wednesday", average(D4:D7), if(B4 = "Thursday", average(D4:D8),  if(B4 = "Friday", average(D4:D9), if(B4 = "Saturday",average(D4:D10))))))))
=if(B5 = "Sunday",average(D4:D4), if(B5 = "Monday",average(D4:D5), if(B5 = "Tuesday",average(D4:D6), if(B5 = "Wednesday", average(D4:D7), if(B5 = "Thursday", average(D4:D8),  if(B5 = "Friday", average(D4:D9), if(B5 = "Saturday",average(D4:D10))))))))
=if(B6 = "Sunday",average(D4:D4), if(B6 = "Monday",average(D4:D5), if(B6 = "Tuesday",average(D4:D6), if(B6 = "Wednesday", average(D4:D7), if(B6 = "Thursday", average(D4:D8),  if(B6 = "Friday", average(D4:D9), if(B6 = "Saturday",average(D4:D10))))))))
=if(B7 = "Sunday",average(D4:D4), if(B7 = "Monday",average(D4:D5), if(B7 = "Tuesday",average(D4:D6), if(B7 = "Wednesday", average(D4:D7), if(B7 = "Thursday", average(D4:D8),  if(B7 = "Friday", average(D4:D9), if(B7 = "Saturday",average(D4:D10))))))))
=if(B8 = "Sunday",average(D4:D4), if(B8 = "Monday",average(D4:D5), if(B8 = "Tuesday",average(D4:D6), if(B8 = "Wednesday", average(D4:D7), if(B8 = "Thursday", average(D4:D8),  if(B8 = "Friday", average(D4:D9), if(B8 = "Saturday",average(D4:D10))))))))
=if(B9 = "Sunday",average(D4:D4), if(B9 = "Monday",average(D4:D5), if(B9 = "Tuesday",average(D4:D6), if(B9 = "Wednesday", average(D4:D7), if(B9 = "Thursday", average(D4:D8),  if(B9 = "Friday", average(D4:D9), if(B9 = "Saturday",average(D4:D10))))))))
=if(B10 = "Sunday",average(D4:D4), if(B10 = "Monday",average(D4:D5), if(B10 = "Tuesday",average(D4:D6), if(B10 = "Wednesday", average(D4:D7), if(B10 = "Thursday", average(D4:D8),  if(B10 = "Friday", average(D4:D9), if(B10 = "Saturday",average(D4:D10))))))))