I dabbled with google sheets and have been experimenting with it more since my posts. I have the impression no one else is trying it. It has lots of limitations and minor issues to work around but I still think it is an option that will provide individuals with exactly the graphs they want or the calculated values you mentioned. I can see a way around the 2000 row limit which puts most people off. The discussion is here:
