7-day average, 7-day rate of change, and 14-day rate of change functions for statistical processing

ave7-roc7-roc14.txt

AVE7DAYS = LAMBDA(range,
iferror(average(offset(range,-6,0,7,1)),"")
);
ROC7DAYS = LAMBDA(range,ifzero,
if(row(range)>14,iferror(
    if(sum(offset(range,-6,0,7,1))/sum(offset(range,-13,0,7,1))<>0,
    sum(offset(range,-6,0,7,1))/sum(offset(range,-13,0,7,1)),ifzero),
        ifzero),"")
)
;
ROC14DAYS = LAMBDA(range,ifzero,
if(row(range)>28,iferror(
    if(sum(offset(range,-13,0,14,1))/sum(offset(range,-27,0,14,1))<>0,
        sum(offset(range,-13,0,14,1))/sum(offset(range,-27,0,14,1)),ifzero)
        ,ifzero),"")
)
;
RATELASTWEEK = LAMBDA(range, 
iferror(
VALUE(range)/value(offset(range,-7,0,1,1))
,""
)
);