Well the precise way of doing this is what etaf recommended. But I noticed in your post that you said "you understand you are going with averages". Here is my solution based on this "understanding". I have put all steps of what I did from left to right on worksheet "My Final". I hope this chart is what you need. Please let me know.
F
Bookmarks