One of Us
- Jul 23, 2010
For next time a database is probably a better way to go. Excel is great for displaying data but as you have found out it does have some limitations with this kind of analysis unless you go into advanced functionality, are which point it's easier to bite the bullet and store the information in a database anyway.Just to give you an idea of my extremely messy data collection, here's some pictures of my excel sheet which has all my data prior to inserting it into the graphic each morning.
This is for the next 7 days
This is for each individual day
And this was when i was working out what weightings worked best for the weighted average
And this is why i don't publish my excel sheet directly here lol