Dear all,
I am looking for knowledge with the following topic, I have a set of data in the attachment where I have a product A, with the current maximum rate of product 5,400 KG, however now I am trying to find new best production data, the rule is that to find a new best production rate I need to consider the best 7 days in a row and with that calculate the average. Calculate the average of the best 7 days in a row is not the question logically, the question is how to find out through a quick formula what is the best 7 days rates in a row, any idea?
Regards
Joel
I am looking for knowledge with the following topic, I have a set of data in the attachment where I have a product A, with the current maximum rate of product 5,400 KG, however now I am trying to find new best production data, the rule is that to find a new best production rate I need to consider the best 7 days in a row and with that calculate the average. Calculate the average of the best 7 days in a row is not the question logically, the question is how to find out through a quick formula what is the best 7 days rates in a row, any idea?
Regards
Joel
Attachments

413.4 KB Views: 1