You may remember the Bang-Bang Servo diet (that I mistakenly called the Big Bang Servo diet). Well, it’s a hit. I was setting up a spreadsheet for someone this week and I noticed that I didn’t make the chart ranges dynamic. That is, it always charts 90 days because that’s how I happened to set it up the first time. So I fixed it.
Normally, to make dynamic ranges I use a named formula using OFFSET and COUNTA. It might look like this:
And that will certainly work in this case. I’m not a fan of arbitrary row counts, like the A1000 reference above, but I’m usually too lazy to change it. For some reason, I was trying to do my counting on column C, which contains a bunch of NAs. Before I realized that I could count on column A, it dawned on me that I already had the starting and ending dates in the user input section. So I used those, of course.
got the job done and was cleaner. Now I can use those dynamic ranges in my series ranges.
You can download the updated WeightChart.xls.zip. There seems to be a lot of names floating around for this: Steve Ward diet, bang bang servo diet, bang bang diet, line diet, over under diet, and overy-undery diet (my favorite). Happy dieting.