Ok, so it's nice to be able to see how things are trending, but given that things keep changing it means you need to have to keep old reports or backups around that you can plug into excel.
Wait though, we have the history of each cell available within two clicks. And we have the highlight feature which shows which cells have changed in the past 'x' days.
So... what if we leveraged that inherent data and created the ability to "view this sheet on day x in the past"??? So you'd click on a box somewhere in the title and say which day you'd like to go back to. Then, once selected, the entire sheet would (temporarily) revert back to the version from that date. This could be really helpful, particularly if we could leave it in this view and generate our graphs off of it again. Call it a "History View"
ehh???