GOOGLE: Changed their “SITES” offering

2017-Jun-13

Imagine my surprise when I found that there is a “new” SITES offering and “old” SITES offering.

And, of course, no automated way to migrate up to the “new” one.

Argh!

# – # – # – # – #  2017-Jun-13 @ 15:45  

EXCEL: Updating my steps target sheet

Long story short I feel off my exercise regimen. 

Sooooo, I wanted to recalibrate my spreadsheet to new lower plateau and then increment every sunday by 500 steps.

Being lazy, last time I did it by hand.

Being not so lazy and on hold for a support chat, I refigured the Excel formulas to do it.

=WEEKDAY(A2) gives you 1 for Sunday.

=IF(WEEKDAY(A3)=1,B2+500,B2) did what I wanted it to do.

So the final result to insert and copy down was:

Taaaa Dahhhh

=IF(WEEKDAY(A120)=1,B119+500,B119)

It was easier than being lazy.

# – # – # – # – #