I don't completely understand what you want to do but your formula returns exactly the expected output in my Excel online sample sheet unless i'm doing something wrong.

=LET(
  lookback,11,
  prevDay,$E$5:$AG$5,
  currDay,$E$8:$AG$8,
  allData,HSTACK(prevDay,currDay),
  prevCols,COLUMNS(prevDay),
  pos,prevCols+COLUMNS($E9:E9),
  above,E8,
  currSoFar,INDEX(currDay,SEQUENCE(1,COLUMNS($E9:E9))),
  anyPosToday,SUM(--(currSoFar>0))>0,
  lastPosIdxToday,IFERROR(LOOKUP(2,1/(currSoFar>0),SEQUENCE(,COLUMNS($E9:E9))),NA()),
  lastPosAbs,IFERROR(prevCols+lastPosIdxToday,NA()),
  zerosSinceStartLen,IF(ISNA(lastPosAbs),0,MIN(lookback, pos-lastPosAbs)),
  zerosSinceStart,IF(
    zerosSinceStartLen>0,
    INDEX(allData,1,SEQUENCE(1,zerosSinceStartLen,lastPosAbs+1)),
    ""
  ),
  zeroCount,SUM(--(zerosSinceStart=0)),

  IF(above>0,
     above,
     IF(NOT(anyPosToday),
        0,
        IF(zeroCount<lookback,0.5,0)
     )
  )
)