With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, December 8, 2012
yogi_Compute Average Of Differences Between Successive Entries (D2-C2) (E2-D2) For Unspecified Number Of Columns
Google Spreadsheet Post #918
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Dec 8, 2012 user Chris Chalhoub said:(http://productforums.google.com/forum/?zx=85hivgm1a4uy#!category-topic/docs/spreadsheets/67AgtCq68H8) Average increase of a series of numbers Hey guys, I am on chrome on windows ad I am trying to do something and it seems impossible to do it simple. I am trying to find out the average increase between a string of numbers that ether is static (easy enough... 0) or that ONLY increases.
For example I have a row that has the following numbers in columns from left to right (A2:H2) 137,155,174,192,210,228,247,274
I would like to find a simpler way than going =((b2-a2)+(c2-b2)+(d2-c2)....)/8
is this my only option or is there a shorter way to do this or should I prepare to write this for each row I will have in my sheet (many...)