Notes

flag_ALL =
VAR s = [activity]
VAR Fecha = gaia_monitoring[datetime]

VAR Vigente_R1_R8 = NOT ISBLANK(Fecha) && Fecha >= DATE(2026,1,12) + TIME(15,0,0)
VAR Vigente_R8_Nueva = NOT ISBLANK(Fecha) && Fecha >= DATE(2026,2,2) + TIME(15,0,0)
VAR Vigente_Dist_01 = NOT ISBLANK(Fecha) && Fecha >= DATE(2026,2,9) + TIME(11,0,0)

RETURN
IF(
ISBLANK(s) || NOT Vigente_R1_R8,
BLANK(),

VAR has1 = CONTAINSSTRING(s, """1""")
VAR has2 = CONTAINSSTRING(s, """2""")
VAR has3 = CONTAINSSTRING(s, """3""")
VAR has4 = CONTAINSSTRING(s, """4""")
VAR has5 = CONTAINSSTRING(s, """5""")
VAR has6 = CONTAINSSTRING(s, """6""")
VAR has7 = CONTAINSSTRING(s, """7""")
VAR has8 = CONTAINSSTRING(s, """8""")
VAR has9 = CONTAINSSTRING(s, """9""")
VAR has10 = CONTAINSSTRING(s, """10""")
VAR has12 = CONTAINSSTRING(s, """12""")
VAR has21 = CONTAINSSTRING(s, """21""")
VAR has48 = CONTAINSSTRING(s, """48""")
VAR has56 = CONTAINSSTRING(s, """56""")
VAR has58 = CONTAINSSTRING(s, """58""")
VAR has64 = CONTAINSSTRING(s, """64""")
VAR has65 = CONTAINSSTRING(s, """65""")
VAR has66 = CONTAINSSTRING(s, """66""")
VAR has53 = CONTAINSSTRING(s, """53""")
VAR has57 = CONTAINSSTRING(s, """57""")
VAR has67 = CONTAINSSTRING(s, """67""")
VAR has68 = CONTAINSSTRING(s, """68""")
VAR has70 = CONTAINSSTRING(s, """70""")

VAR hasDamage =
CONTAINSSTRING(s, """13""") || CONTAINSSTRING(s, """14""")
|| CONTAINSSTRING(s, """15""") || CONTAINSSTRING(s, """16""")
|| CONTAINSSTRING(s, """17""") || CONTAINSSTRING(s, """18""")
|| CONTAINSSTRING(s, """19""") || CONTAINSSTRING(s, """20""")
|| CONTAINSSTRING(s, """21""") || CONTAINSSTRING(s, """22""")
|| CONTAINSSTRING(s, """23""") || CONTAINSSTRING(s, """24""")
|| CONTAINSSTRING(s, """59""") || CONTAINSSTRING(s, """61""")
|| CONTAINSSTRING(s, """62""") || CONTAINSSTRING(s, """63""")

VAR R1_base = (has1||has2||has3||has4||has8) && NOT(has48||has56||has5||has6||has7||has58)
VAR R1 = Vigente_R1_R8 && R1_base

VAR R8_base_antigua = (has1||has2||has3||has4||has8) && has56 && NOT(has48||has5||has6)
VAR R8_nueva_A = (has1||has2||has3||has4||has8) && has56 && NOT(has5||has6||has48||has53||has67||has70||has57)
VAR R8_nueva_B = (has1||has2||has3||has4||has8) && has56 && has68 && NOT(has5||has6||has48||has53||has67||has70)
VAR R8_def = IF(Vigente_R8_Nueva, (R8_nueva_A||R8_nueva_B), R8_base_antigua)
VAR R8 = Vigente_R1_R8 && R8_def

VAR R4_AvSinDef = has8 && has10 && NOT(has48||has9||has56||has66||has12||hasDamage)
VAR R4_AvCond = has1 && has10 && NOT(has48||has9||has2||has3||has58||has56||has66||has12||hasDamage)

VAR R5_CON_01_base = has65&&has66 && (has1||has2||has3||has4||has8) && NOT(has7||has58||has56)
VAR R5_1 = has65&&has66 && (has5||has6) && NOT(has7||has58)
VAR R5_2 = has65&&has66&&has56 && (has1||has2||has3||has4||has8) && NOT(has7||has58)
VAR R5_3 = (has64||has65) && has21 && has5
VAR R5_4 = (has64||has65) && has21 && has6 && NOT(has1||has2||has3||has4||has8)
VAR R5_SIN_01_base = R5_1||R5_2||R5_3||R5_4
VAR R5_CON_01 = Vigente_Dist_01 && R5_CON_01_base
VAR R5_SIN_01 = Vigente_Dist_01 && R5_SIN_01_base
VAR R5_GEN = NOT Vigente_Dist_01 && (R5_CON_01_base||R5_SIN_01_base)

VAR R6_1 = (has64||has65)&&has21 && (has1||has2||has3||has4||has8) && NOT has56
VAR R6_2 = (has64||has65)&&has21&&has6 && (has1||has2||has3||has4||has8) && NOT has56
VAR R6y7_CON_01_base = R6_1||R6_2
VAR R6y7_SIN_01_base = (has64||has65)&&has21&&has56
VAR R6y7_CON_01 = Vigente_Dist_01 && R6y7_CON_01_base
VAR R6y7_SIN_01 = Vigente_Dist_01 && R6y7_SIN_01_base
VAR R6y7_GEN = NOT Vigente_Dist_01 && (R6y7_CON_01_base||R6y7_SIN_01_base)

RETURN
SWITCH(
TRUE(),
R4_AvSinDef||R4_AvCond, "4",
R5_CON_01, "5 (con 01)",
R5_SIN_01, "5 (sin 01)",
R6y7_CON_01, "6 y 7 (con 01)",
R6y7_SIN_01, "6 y 7 (sin 01)",
R5_GEN, "5",
R6y7_GEN, "6 y 7",
R8, "8",
R1, "1",
BLANK()
)
)