Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jul 30, 2013
user theillway (http://productforums.google.com/forum/?zx=gx080770b9kk#!mydiscussions/docs/dpamcy2XFwU)
Finding the current trend in a sheet
I keep a spreadsheet of how much I have charged a client, and how much time I spent on work for that client. I use this information to get the average of how much per hour I am charging. I then use the trend function to figure out whether I'm improving or holding steady. The problem is, everytime I enter in new information, I have to manually update which cells the trend should apply to (if I simply have the trend for the whole column, the formula breaks). I want to be able to lock the sheet so that I can have other (less tech savvy) staff use the spreadsheet without fear.