Please see attached pic showing a table of days for a pretend patient visit, where their actual LOS was > 10, but because of HH-02 specs, only the 1st 10 days are considered.

Assume also that the Is_GlucSev (Severe result), Is_GlucElv (Elevated result), and IsGlucAny (any result) are correct.  Note that "1" and "0" is akin to "Y" and "N", and all DayNumb > 1 are considered Eligible Days (Is_ElgDay).

Regarding the final column, could someone tell me if, based on all the data in this table, if the Is_HypEvt (i.e. Does this day have a Hyperglycemic Event, as per CMS specs?) column is calculated correctly?  I think it is - with a total of 4, but a testing tool is getting 3 - but unfortunately it doesn't tell me which days it counted as "1/Y".

And, here is the associated glucose lab test details:

Glucose Lab Test, 2023-08-30T08:00, Result: 325 mg/dL
Glucose Lab Test, 2023-08-31T08:00, Result: 250 mg/dL
Glucose Lab Test, 2023-09-01T08:00, Result: 225 mg/dL
Glucose Lab Test, 2023-09-04T08:00, Result: 320 mg/dL

Bonus question: Anyone know why specs use "dayIndex - 2" and "dayIndex - 3" for checking previous days, instead of "dayIndex - 1" and "dayIndex - 2", which would represent the "immediately preceding" days of a day with no glucose tests?