Sunday, December 15, 2013

yogi_Compute Jerry Seinfeld Chain From A Set Of Current Streaks

                                          Google Spreadsheet   Post  #1440
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Dec-15, 2013
question by Josiah Sprague (!mydiscussions/docs/wBleMdlhsWM)
Formula for calculating a running average of streak length
I'm using Jerry Seinfeld's chain method to track habits that I want to change. I want to track my chains in a Spreadsheet and have a running average of my chain length. I want to be able to say something like, "On average, over the last six months, the length of my 'winning streaks' has gone up/down".

I have a vague idea of how to set this up, but I am not quite there. I've got one column for date, another column for the current streak length on each day, and I'm trying to come up with a third column that will generate a running average of my streak lengths over a certain time period (say 6 months). Eventually I would like to graph this information too, so that I can see how my average streak length is changing on a daily basis. I'm at a loss for which formula to use, or perhaps I need to tweak my model a little bit to get the information I am looking for.

Any help would be greatly appreciated!