{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["FORMATO TURNO MENSUAL","Instrucciones","Control de cambios"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":40,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"FORMATO TURNO MENSUAL","index":0,"n_rows":185,"n_cols":72,"rows_kept":185,"cut":false,"hidden":false,"merged":[[15,0,26,0],[28,0,32,0],[34,0,40,0],[48,0,53,0],[8,56,15,56],[8,50,15,50],[8,51,15,51],[8,52,15,52],[8,54,15,54],[8,55,15,55],[7,38,7,52],[7,54,7,55],[7,56,7,57],[8,1,8,2],[8,39,15,39],[8,40,15,40],[8,41,15,41],[8,42,15,42],[8,43,15,43],[8,44,15,44],[8,57,15,57],[8,45,15,45],[8,46,15,46],[8,47,15,47],[8,48,15,48],[8,49,15,49],[4,19,4,21],[4,25,4,27],[0,0,2,0],[0,1,2,24],[0,25,0,30],[1,25,1,30],[2,25,2,30]]}
[null,"SERVICIOS – PRONÓSTICOS Y ALERTAS\nFORMATO PROGRAMACIÓN DE TURNOS  OSPA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código: SPA-F003 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versión: 06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha: 29/05/2026"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MES","MAYO",null,null,null,null,"AÑO",2026]
[]
[null,null,null,{"$f":"COUNTIF(D11:D75,$AK$14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"REGISTRO DE TURNO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONVENCIONES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T. SUPLEM.",null,"COMPENSAT."]
["TEMÁTICA","TURNO/ ACTIVIDAD",null,{"$f":"+D10","v":"2026-05-01"},{"$f":"+E10","v":"2026-05-02"},"2026-05-03","2026-05-04","2026-05-05","2026-05-06","2026-05-07","2026-05-08","2026-05-09","2026-05-10","2026-05-11","2026-05-12","2026-05-13","2026-05-14","2026-05-15","2026-05-16","2026-05-17","2026-05-18","2026-05-19","2026-05-20","2026-05-21","2026-05-22","2026-05-23","2026-05-24","2026-05-25","2026-05-26","2026-05-27","2026-05-28","2026-05-29","2026-05-30","2026-05-31",null,null,null,null,null,"Funcionario","Código","Incendios","Deslizamientos","Datos","Coordinacion ITD","Meteorologia","Hidrologia","Entrenamiento","Met Regionales","Oficina","Comision","TOTAL TURNOS","Vinculación",null,"Sábados","Domingos y festivos","Dias Compensados","Compensatorios acumulados del mes"]
[null,"Inicia","Termina",{"$f":"DATEVALUE(CONCATENATE(\"01/\",$T$5,$Z$5))","v":"2026-05-01"},{"$f":"DATEVALUE(CONCATENATE(\"02/\",$T$5,$Z$5))","v":"2026-05-02"},{"$f":"DATEVALUE(CONCATENATE(\"03/\",$T$5,$Z$5))","v":"2026-05-03"},{"$f":"DATEVALUE(CONCATENATE(\"04/\",$T$5,$Z$5))","v":"2026-05-04"},{"$f":"DATEVALUE(CONCATENATE(\"05/\",$T$5,$Z$5))","v":"2026-05-05"},{"$f":"DATEVALUE(CONCATENATE(\"06/\",$T$5,$Z$5))","v":"2026-05-06"},{"$f":"DATEVALUE(CONCATENATE(\"07/\",$T$5,$Z$5))","v":"2026-05-07"},{"$f":"DATEVALUE(CONCATENATE(\"08/\",$T$5,$Z$5))","v":"2026-05-08"},{"$f":"DATEVALUE(CONCATENATE(\"09/\",$T$5,$Z$5))","v":"2026-05-09"},{"$f":"DATEVALUE(CONCATENATE(\"10/\",$T$5,$Z$5))","v":"2026-05-10"},{"$f":"DATEVALUE(CONCATENATE(\"11/\",$T$5,$Z$5))","v":"2026-05-11"},{"$f":"DATEVALUE(CONCATENATE(\"12/\",$T$5,$Z$5))","v":"2026-05-12"},{"$f":"DATEVALUE(CONCATENATE(\"13/\",$T$5,$Z$5))","v":"2026-05-13"},{"$f":"DATEVALUE(CONCATENATE(\"14/\",$T$5,$Z$5))","v":"2026-05-14"},{"$f":"DATEVALUE(CONCATENATE(\"15/\",$T$5,$Z$5))","v":"2026-05-15"},{"$f":"DATEVALUE(CONCATENATE(\"16/\",$T$5,$Z$5))","v":"2026-05-16"},{"$f":"DATEVALUE(CONCATENATE(\"17/\",$T$5,$Z$5))","v":"2026-05-17"},{"$f":"DATEVALUE(CONCATENATE(\"18/\",$T$5,$Z$5))","v":"2026-05-18"},{"$f":"DATEVALUE(CONCATENATE(\"19/\",$T$5,$Z$5))","v":"2026-05-19"},{"$f":"DATEVALUE(CONCATENATE(\"20/\",$T$5,$Z$5))","v":"2026-05-20"},{"$f":"DATEVALUE(CONCATENATE(\"21/\",$T$5,$Z$5))","v":"2026-05-21"},{"$f":"DATEVALUE(CONCATENATE(\"22/\",$T$5,$Z$5))","v":"2026-05-22"},{"$f":"DATEVALUE(CONCATENATE(\"23/\",$T$5,$Z$5))","v":"2026-05-23"},{"$f":"DATEVALUE(CONCATENATE(\"24/\",$T$5,$Z$5))","v":"2026-05-24"},{"$f":"DATEVALUE(CONCATENATE(\"25/\",$T$5,$Z$5))","v":"2026-05-25"},{"$f":"DATEVALUE(CONCATENATE(\"26/\",$T$5,$Z$5))","v":"2026-05-26"},{"$f":"DATEVALUE(CONCATENATE(\"27/\",$T$5,$Z$5))","v":"2026-05-27"},{"$f":"DATEVALUE(CONCATENATE(\"28/\",$T$5,$Z$5))","v":"2026-05-28"},{"$f":"IFERROR(DATEVALUE(CONCATENATE(\"29/\",$T$5,$Z$5)),\" \")","v":"2026-05-29"},{"$f":"IFERROR(DATEVALUE(CONCATENATE(\"30/\",$T$5,$Z$5)),\" \")","v":"2026-05-30"},{"$f":"IFERROR(DATEVALUE(CONCATENATE(\"31/\",$T$5,$Z$5)),\" \")","v":"2026-05-31"},"Validación"]
["INCENDIOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D11:AH11,$AK$14))","v":""}]
["DESLIZAMIENTOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D12:AH12,$AK$14))","v":""}]
["DATOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D13:AH13,$AK$14))","v":""},null,"Validación"]
["INFORME TÉCNICO DIARIO (ITD)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",1,","]
[null,"TURNO",null,{"$f":"+D$10","v":"2026-05-01"},{"$f":"+E$10","v":"2026-05-02"},"2026-05-03","2026-05-04","2026-05-05","2026-05-06","2026-05-07","2026-05-08","2026-05-09","2026-05-10","2026-05-11","2026-05-12","2026-05-13","2026-05-14","2026-05-15","2026-05-16","2026-05-17","2026-05-18","2026-05-19","2026-05-20","2026-05-21","2026-05-22","2026-05-23","2026-05-24","2026-05-25","2026-05-26","2026-05-27","2026-05-28","2026-05-29","2026-05-30","2026-05-31"]
["METEOROLOGÍA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D16:AH16,$AK$14))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",2,",",null,null,null,null,{"$f":"SUM(AP18:AP85)","v":0},{"$f":"SUM(AQ18:AQ85)","v":0},{"$f":"SUM(AR18:AR85)","v":0},{"$f":"SUM(AS18:AS85)","v":0},{"$f":"SUM(AT18:AT72)","v":0},{"$f":"SUM(AU18:AU80)","v":0},{"$f":"SUM(AV18:AV85)","v":0},null,{"$f":"SUM(AX18:AX85)","v":0},null,{"$f":"SUM(AZ18:AZ85)","v":0},null,null,{"$f":"SUMIFS(BC18:BC72,BA18:BA72, \"FO\")+SUMIFS(BC18:BC72,BA18:BA72, \"FA\")","v":0},{"$f":"SUMIFS(BD18:BD72,BA18:BA72, \"fo\")+SUMIFS(BD18:BD72,BA18:BA72, \"FA\")","v":0},{"$f":"SUM(BE18:BE70)","v":0},{"$f":"SUM(BF18:BF70)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"COUNTIF($D$11:$AH$11,$AO18)","v":0},{"$f":"COUNTIF($D$12:$AH$12,$AO18)","v":0},{"$f":"COUNTIF($D$13:$AH$13,$AO18)","v":0},{"$f":"COUNTIF($D$14:$AH$14,$AO18)","v":0},{"$f":"COUNTIF($D$16:$AH$27,$AO18)","v":0},{"$f":"COUNTIF($D$29:$AH$33,$AO18)","v":0},{"$f":"COUNTIF($D$35:$AH$41,$AO18)","v":0},{"$f":"COUNTIF($D$50:$AH$54,$AO18)","v":0},{"$f":"COUNTIF($D$42:$AH$48,$AO18)","v":0},{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO18))","v":0},{"$f":"SUM(AP18:AY18)","v":0},null,null,{"$f":"IF(AO18=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO18)))","v":0},{"$f":"IF(AO18=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO18)))","v":0},{"$f":"IF(AO18=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO18)))","v":0},{"$f":"+BC18+BD18-BE18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",3,",",null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO19))","v":0},0,null,null,{"$f":"IF(AO19=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO19)))","v":0},{"$f":"IF(AO19=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO19)))","v":0},{"$f":"IF(AO19=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO19)))","v":0},{"$f":"+BC19+BD19-BE19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO20))","v":0},0,null,null,{"$f":"IF(AO20=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO20)))","v":0},{"$f":"IF(AO20=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO20)))","v":0},{"$f":"IF(AO20=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO20)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO21))","v":0},0,null,null,{"$f":"IF(AO21=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO21)))","v":0},{"$f":"IF(AO21=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO21)))","v":0},{"$f":"IF(AO21=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO21)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO22))","v":0},0,null,null,{"$f":"IF(AO22=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO22)))","v":0},{"$f":"IF(AO22=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO22)))","v":0},{"$f":"IF(AO22=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO22)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO23))","v":0},0,null,null,{"$f":"IF(AO23=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO23)))","v":0},{"$f":"IF(AO23=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO23)))","v":0},{"$f":"IF(AO23=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO23)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO24))","v":0},0,null,null,{"$f":"IF(AO24=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO24)))","v":0},{"$f":"IF(AO24=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO24)))","v":0},{"$f":"IF(AO24=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO24)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO25))","v":0},0,null,null,{"$f":"IF(AO25=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO25)))","v":0},{"$f":"IF(AO25=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO25)))","v":0},{"$f":"IF(AO25=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO25)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO26))","v":0},0,null,null,{"$f":"IF(AO26=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO26)))","v":0},{"$f":"IF(AO26=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO26)))","v":0},{"$f":"IF(AO26=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO26)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO27))","v":0},null,null,null,{"$f":"IF(AO27=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO27)))","v":0},{"$f":"IF(AO27=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO27)))","v":0},{"$f":"IF(AO27=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO27)))","v":0},0]
[null,"TURNO",null,{"$f":"+D$10","v":"2026-05-01"},{"$f":"+E$10","v":"2026-05-02"},"2026-05-03","2026-05-04","2026-05-05","2026-05-06","2026-05-07","2026-05-08","2026-05-09","2026-05-10","2026-05-11","2026-05-12","2026-05-13","2026-05-14","2026-05-15","2026-05-16","2026-05-17","2026-05-18","2026-05-19","2026-05-20","2026-05-21","2026-05-22","2026-05-23","2026-05-24","2026-05-25","2026-05-26","2026-05-27","2026-05-28","2026-05-29","2026-05-30","2026-05-31"]
["HIDROLOGIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D29:AH29,$AK$14))","v":""},null,null,null,null,null,null,0,0,0,0,{"$f":"COUNTIF($D$16:$AH$27,$AO29)","v":0},{"$f":"COUNTIF($D$29:$AH$33,$AO29)","v":0},{"$f":"COUNTIF($D$35:$AH$41,$AO29)","v":0},{"$f":"COUNTIF($D$50:$AH$54,$AO29)","v":0},{"$f":"COUNTIF($D$42:$AH$48,$AO29)","v":0},{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO29))","v":0},{"$f":"SUM(AP29:AY29)","v":0},null,null,{"$f":"IF(AO29=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO29)))","v":0},{"$f":"IF(AO29=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO29)))","v":0},{"$f":"IF(AO29=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO29)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D30:AH30,$AK$14))","v":""},null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO30))","v":0},0,null,null,{"$f":"IF(AO30=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO30)))","v":0},{"$f":"IF(AO30=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO30)))","v":0},{"$f":"IF(AO30=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO30)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D31:AH31,$AK$14))","v":""},null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO31))","v":0},0,null,null,{"$f":"IF(AO31=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO31)))","v":0},{"$f":"IF(AO31=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO31)))","v":0},{"$f":"IF(AO31=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO31)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D32:AH32,$AK$14))","v":""},null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO32))","v":0},0,null,null,{"$f":"IF(AO32=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO32)))","v":0},{"$f":"IF(AO32=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO32)))","v":0},{"$f":"IF(AO32=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO32)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D33:AH33,$AK$14))","v":""},null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO33))","v":0},0,null,null,{"$f":"IF(AO33=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO33)))","v":0},{"$f":"IF(AO33=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO33)))","v":0},{"$f":"IF(AO33=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO33)))","v":0},0]
[null,"TURNO",null,{"$f":"+D$10","v":"2026-05-01"},{"$f":"+E$10","v":"2026-05-02"},"2026-05-03","2026-05-04","2026-05-05","2026-05-06","2026-05-07","2026-05-08","2026-05-09","2026-05-10","2026-05-11","2026-05-12","2026-05-13","2026-05-14","2026-05-15","2026-05-16","2026-05-17","2026-05-18","2026-05-19","2026-05-20","2026-05-21","2026-05-22","2026-05-23","2026-05-24","2026-05-25","2026-05-26","2026-05-27","2026-05-28","2026-05-29","2026-05-30","2026-05-31",{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D35:AH35,$AK$14))","v":""},null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO34))","v":0},0,null,null,{"$f":"IF(AO34=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO34)))","v":0},{"$f":"IF(AO34=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO34)))","v":0},{"$f":"IF(AO34=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO34)))","v":0},0]
["ENTRENAMIENTO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO35))","v":0},0,null,null,{"$f":"IF(AO35=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO35)))","v":0},{"$f":"IF(AO35=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO35)))","v":0},{"$f":"IF(AO35=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO35)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO36))","v":0},0,null,null,{"$f":"IF(AO36=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO36)))","v":0},{"$f":"IF(AO36=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO36)))","v":0},{"$f":"IF(AO36=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO36)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO37))","v":0},0,null,null,{"$f":"IF(AO37=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO37)))","v":0},{"$f":"IF(AO37=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO37)))","v":0},{"$f":"IF(AO37=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO37)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO38))","v":0},{"$f":"SUM(AP38:AY38)","v":0},null,null,{"$f":"IF(AO38=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO38)))","v":0},{"$f":"IF(AO38=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO38)))","v":0},{"$f":"IF(AO38=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO38)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO39))","v":0},{"$f":"SUM(AP39:AY39)","v":0},null,null,{"$f":"IF(AO39=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO39)))","v":0},{"$f":"IF(AO39=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO39)))","v":0},{"$f":"IF(AO39=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO39)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO40))","v":0},0,null,null,{"$f":"IF(AO40=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO40)))","v":0},{"$f":"IF(AO40=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO40)))","v":0},{"$f":"IF(AO40=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO40)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO41))","v":0},0,null,null,{"$f":"IF(AO41=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO41)))","v":0},{"$f":"IF(AO41=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO41)))","v":0},{"$f":"IF(AO41=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO41)))","v":0},0]
["ACTIVIDADES DE OFICINA ","TURNO",null,{"$f":"+D$10","v":"2026-05-01"},{"$f":"+E$10","v":"2026-05-02"},"2026-05-03","2026-05-04","2026-05-05","2026-05-06","2026-05-07","2026-05-08","2026-05-09","2026-05-10","2026-05-11","2026-05-12","2026-05-13","2026-05-14","2026-05-15","2026-05-16","2026-05-17","2026-05-18","2026-05-19","2026-05-20","2026-05-21","2026-05-22","2026-05-23","2026-05-24","2026-05-25","2026-05-26","2026-05-27","2026-05-28","2026-05-29","2026-05-30","2026-05-31","",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO42))","v":0},0,null,null,{"$f":"IF(AO42=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO42)))","v":0},{"$f":"IF(AO42=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO42)))","v":0},{"$f":"IF(AO42=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO42)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO43))","v":0},0,null,null,{"$f":"IF(AO43=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO43)))","v":0},{"$f":"IF(AO43=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO43)))","v":0},{"$f":"IF(AO43=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO43)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO44))","v":0},0,null,null,{"$f":"IF(AO44=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO44)))","v":0},{"$f":"IF(AO44=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO44)))","v":0},{"$f":"IF(AO44=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO44)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO45))","v":0},0,null,null,{"$f":"IF(AO45=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO45)))","v":0},{"$f":"IF(AO45=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO45)))","v":0},{"$f":"IF(AO45=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO45)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO46))","v":0},0,null,null,{"$f":"IF(AO46=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO46)))","v":0},{"$f":"IF(AO46=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO46)))","v":0},{"$f":"IF(AO46=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO46)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO47))","v":0},0,null,null,{"$f":"IF(AO47=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO47)))","v":0},{"$f":"IF(AO47=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO47)))","v":0},{"$f":"IF(AO47=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO47)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D50:AH50,$AK$14))","v":""},null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO48))","v":0},0,null,null,{"$f":"IF(AO48=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO48)))","v":0},{"$f":"IF(AO48=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO48)))","v":0},{"$f":"IF(AO48=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO48)))","v":0},0]
["OSPA REGIONALES","TURNO",null,{"$f":"+D$10","v":"2026-05-01"},{"$f":"+E$10","v":"2026-05-02"},"2026-05-03","2026-05-04","2026-05-05","2026-05-06","2026-05-07","2026-05-08","2026-05-09","2026-05-10","2026-05-11","2026-05-12","2026-05-13","2026-05-14","2026-05-15","2026-05-16","2026-05-17","2026-05-18","2026-05-19","2026-05-20","2026-05-21","2026-05-22","2026-05-23","2026-05-24","2026-05-25","2026-05-26","2026-05-27","2026-05-28","2026-05-29","2026-05-30","2026-05-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D51:AH51,$AK$14))","v":""},null,null,null,null,null,null,0,0,0,0,{"$f":"COUNTIF($D$16:$AH$27,$AO50)","v":0},{"$f":"COUNTIF($D$29:$AH$33,$AO50)","v":0},{"$f":"COUNTIF($D$35:$AH$41,$AO50)","v":0},{"$f":"COUNTIF($D$50:$AH$54,$AO50)","v":0},{"$f":"COUNTIF($D$42:$AH$48,$AO50)","v":0},{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO50))","v":0},0,null,null,{"$f":"IF(AO50=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO50)))","v":0},{"$f":"IF(AO50=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO50)))","v":0},{"$f":"IF(AO50=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO50)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D52:AH52,$AK$14))","v":""},null,null,null,null,null,null,0,0,0,0,{"$f":"COUNTIF($D$16:$AH$27,$AO51)","v":0},{"$f":"COUNTIF($D$29:$AH$33,$AO51)","v":0},{"$f":"COUNTIF($D$35:$AH$41,$AO51)","v":0},{"$f":"COUNTIF($D$50:$AH$54,$AO51)","v":0},{"$f":"COUNTIF($D$42:$AH$48,$AO51)","v":0},{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO51))","v":0},0,null,null,{"$f":"IF(AO51=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO51)))","v":0},{"$f":"IF(AO51=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO51)))","v":0},{"$f":"IF(AO51=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO51)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D53:AH53,$AK$14))","v":""},null,null,null,null,null,null,0,0,0,0,{"$f":"COUNTIF($D$16:$AH$27,$AO52)","v":0},{"$f":"COUNTIF($D$29:$AH$33,$AO52)","v":0},{"$f":"COUNTIF($D$35:$AH$41,$AO52)","v":0},{"$f":"COUNTIF($D$50:$AH$54,$AO52)","v":0},{"$f":"COUNTIF($D$42:$AH$48,$AO52)","v":0},{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO52))","v":0},0,null,null,{"$f":"IF(AO52=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO52)))","v":0},{"$f":"IF(AO52=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO52)))","v":0},{"$f":"IF(AO52=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO52)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D54:AH54,$AK$14))","v":""},null,null,null,null,null,null,0,0,0,0,{"$f":"COUNTIF($D$16:$AH$27,$AO53)","v":0},{"$f":"COUNTIF($D$29:$AH$33,$AO53)","v":0},{"$f":"COUNTIF($D$35:$AH$41,$AO53)","v":0},{"$f":"COUNTIF($D$50:$AH$54,$AO53)","v":0},{"$f":"COUNTIF($D$42:$AH$48,$AO53)","v":0},{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO53))","v":0},0,null,null,{"$f":"IF(AO53=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO53)))","v":0},{"$f":"IF(AO53=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO53)))","v":0},{"$f":"IF(AO53=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO53)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D56:AH56,$AK$14))","v":""},{"$f":"IF($AK$14=\",\",\"\",COUNTIF(E56:AI56,$AK$14))","v":""},null,null,null,null,null,0,0,0,0,{"$f":"COUNTIF($D$16:$AH$27,$AO54)","v":0},{"$f":"COUNTIF($D$29:$AH$33,$AO54)","v":0},{"$f":"COUNTIF($D$35:$AH$41,$AO54)","v":0},{"$f":"COUNTIF($D$50:$AH$54,$AO54)","v":0},{"$f":"COUNTIF($D$42:$AH$48,$AO54)","v":0},{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO54))","v":0},0,null,null,{"$f":"IF(AO54=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO54)))","v":0},{"$f":"IF(AO54=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO54)))","v":0},{"$f":"IF(AO54=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO54)))","v":0},0]
[null,"TURNO",null,{"$f":"+D$10","v":"2026-05-01"},{"$f":"+E$10","v":"2026-05-02"},"2026-05-03","2026-05-04","2026-05-05","2026-05-06","2026-05-07","2026-05-08","2026-05-09","2026-05-10","2026-05-11","2026-05-12","2026-05-13","2026-05-14","2026-05-15","2026-05-16","2026-05-17","2026-05-18","2026-05-19","2026-05-20","2026-05-21","2026-05-22","2026-05-23","2026-05-24","2026-05-25","2026-05-26","2026-05-27","2026-05-28","2026-05-29","2026-05-30","2026-05-31"]
["NO DISPONIBLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$14=\",\",\"\",COUNTIF(D57:AH57,$AK$14))","v":""},null,null,null,null,null,null,0,0,0,0,{"$f":"COUNTIF($D$16:$AH$27,$AO56)","v":0},{"$f":"COUNTIF($D$29:$AH$33,$AO56)","v":0},{"$f":"COUNTIF($D$35:$AH$41,$AO56)","v":0},{"$f":"COUNTIF($D$50:$AH$54,$AO56)","v":0},{"$f":"COUNTIF($D$42:$AH$48,$AO56)","v":0},{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO56))","v":0},0,null,null,{"$f":"IF(AO56=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO56)))","v":0},{"$f":"IF(AO56=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO56)))","v":0},{"$f":"IF(AO56=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO56)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO57))","v":0},0,null,null,{"$f":"IF(AO57=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO57)))","v":0},{"$f":"IF(AO57=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO57)))","v":0},{"$f":"IF(AO57=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO57)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO58))","v":0},0,null,null,{"$f":"IF(AO58=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO58)))","v":0},{"$f":"IF(AO58=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO58)))","v":0},{"$f":"IF(AO58=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO58)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO59))","v":0},0,null,null,{"$f":"IF(AO59=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO59)))","v":0},{"$f":"IF(AO59=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO59)))","v":0},{"$f":"IF(AO59=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO59)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO60))","v":0},0,null,null,{"$f":"IF(AO60=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO60)))","v":0},{"$f":"IF(AO60=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO60)))","v":0},{"$f":"IF(AO60=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO60)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO61))","v":0},0,null,null,{"$f":"IF(AO61=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO61)))","v":0},{"$f":"IF(AO61=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO61)))","v":0},{"$f":"IF(AO61=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO61)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO62))","v":0},0,null,null,{"$f":"IF(AO62=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO62)))","v":0},{"$f":"IF(AO62=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO62)))","v":0},{"$f":"IF(AO62=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO62)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO63))","v":0},0,null,null,{"$f":"IF(AO63=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO63)))","v":0},{"$f":"IF(AO63=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO63)))","v":0},{"$f":"IF(AO63=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO63)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO64))","v":0},0,null,null,{"$f":"IF(AO64=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO64)))","v":0},{"$f":"IF(AO64=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO64)))","v":0},{"$f":"IF(AO64=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO64)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO65))","v":0},0,null,null,{"$f":"IF(AO65=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO65)))","v":0},{"$f":"IF(AO65=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO65)))","v":0},{"$f":"IF(AO65=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO65)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO66))","v":0},0,null,null,{"$f":"IF(AO66=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO66)))","v":0},{"$f":"IF(AO66=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO66)))","v":0},{"$f":"IF(AO66=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO66)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO67))","v":0},null,null,null,{"$f":"IF(AO67=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO67)))","v":0},{"$f":"IF(AO67=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO67)))","v":0},{"$f":"IF(AO67=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO67)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO68))","v":0},null,null,null,{"$f":"IF(AO68=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO68)))","v":0},{"$f":"IF(AO68=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO68)))","v":0},{"$f":"IF(AO68=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO68)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO69))","v":0},null,null,null,{"$f":"IF(AO69=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO69)))","v":0},{"$f":"IF(AO69=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO69)))","v":0},{"$f":"IF(AO69=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO69)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO70))","v":0},null,null,null,{"$f":"IF(AO70=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO70)))","v":0},{"$f":"IF(AO70=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO70)))","v":0},{"$f":"IF(AO70=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO70)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO71))","v":0},null,null,null,{"$f":"IF(AO71=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO71)))","v":0},{"$f":"IF(AO71=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO71)))","v":0},{"$f":"IF(AO71=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO71)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO72))","v":0},null,null,null,{"$f":"IF(AO72=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO72)))","v":0},{"$f":"IF(AO72=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO72)))","v":0},{"$f":"IF(AO72=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO72)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Columna1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO73))","v":0},null,null,null,{"$f":"IF(AO73=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO73)))","v":0},{"$f":"IF(AO73=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO73)))","v":0},{"$f":"IF(AO73=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO73)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO74))","v":0},null,null,null,{"$f":"IF(AO74=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO74)))","v":0},{"$f":"IF(AO74=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO74)))","v":0},{"$f":"IF(AO74=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO74)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO75))","v":0},null,null,null,{"$f":"IF(AO75=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO75)))","v":0},{"$f":"IF(AO75=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO75)))","v":0},{"$f":"IF(AO75=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO75)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO76))","v":0},{"$f":"SUM(AP76:AY76)","v":0},null,null,{"$f":"IF(AO76=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO76)))","v":0},{"$f":"IF(AO76=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO76)))","v":0},{"$f":"IF(AO76=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO76)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO77))","v":0},0,null,null,{"$f":"IF(AO77=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO77)))","v":0},{"$f":"IF(AO77=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO77)))","v":0},{"$f":"IF(AO77=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO77)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO78))","v":0},0,null,null,{"$f":"IF(AO78=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO78)))","v":0},{"$f":"IF(AO78=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO78)))","v":0},{"$f":"IF(AO78=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO78)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,"01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO79))","v":0},0,null,null,{"$f":"IF(AO79=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO79)))","v":0},{"$f":"IF(AO79=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO79)))","v":0},{"$f":"IF(AO79=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO79)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,"02"]
[null,"FESTIVOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT((B$56:B$75=\"COMISIÓN\") * (B$56:AG$75=AO80))","v":0},0,null,null,{"$f":"IF(AO80=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=7)*($D$11:$AH$53=AO80)))","v":0},{"$f":"IF(AO80=0,0,SUMPRODUCT((IFERROR(WEEKDAY(D$9:AH$9,1),0)=1)*($D$11:$AH$53=AO80)))","v":0},{"$f":"IF(AO80=0,0,SUMPRODUCT((B$56:B$75=\"COMPENSATORIOS\")*(B$56:AG$75=AO80)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,"Programados","03"]
[null,"2024-03-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FO","Funcionario Ospa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(BC18:BC80,BA18:BA80, \"FO\")","v":0},{"$f":"SUMIFS(BD18:BD80,BA18:BA80, \"FO\")","v":0},{"$f":"SUMIFS(BE18:BE80,BA18:BA80, \"FO\")","v":0},{"$f":"SUMIFS(BF18:BF80,BA18:BA80, \"FO\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Cumplidos","04"]
[null,"2024-03-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO","Contratista Ospa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(BC18:BC80,BA18:BA80, \"CO\")","v":0},{"$f":"SUMIFS(BD18:BD80,BA18:BA80, \"CO\")","v":0},{"$f":"SUMIFS(BE18:BE80,BA18:BA80, \"CO\")","v":0},{"$f":"SUMIFS(BF18:BF80,BA18:BA80, \"CO\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"05"]
[null,"2024-03-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FA","Funcionario Apoyo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(BC18:BC80,BA18:BA80, \"FA\")","v":0},{"$f":"SUMIFS(BD18:BD80,BA18:BA80, \"FA\")","v":0},{"$f":"SUMIFS(BE18:BE80,BA18:BA80, \"FA\")","v":0},{"$f":"SUMIFS(BF18:BF80,BA18:BA80, \"FA\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"06"]
[null,"2024-05-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA","Contratista Apoyo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(BC18:BC80,BA18:BA80, \"CA\")","v":0},{"$f":"SUMIFS(BD18:BD80,BA18:BA80, \"CA\")","v":0},{"$f":"SUMIFS(BE18:BE80,BA18:BA80, \"CA\")","v":0},{"$f":"SUMIFS(BF18:BF80,BA18:BA80, \"CA\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"07"]
[null,"2024-06-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08"]
[null,"2024-06-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09"]
[null,"2024-07-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10"]
[null,"2024-07-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11"]
[null,"2024-08-07"]
[null,"2024-08-19"]
[null,"2024-10-14"]
[null,"2024-11-04"]
[null,"2024-11-11"]
[null,"2024-12-08"]
[null,"2024-12-25"]
[null,"2025-01-01"]
[null,"2025-01-06"]
[null,"2025-03-24"]
[null,"2025-04-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(WEEKDAY(AF9)=1,1,IF(WEEKDAY(AF9)=7,2,IF(ISNUMBER(MATCH(AF9,FESTIN,0)),3,0)))","v":0},{"$f":"IF(WEEKDAY(AG9)=1,1,IF(WEEKDAY(AG9)=7,2,IF(ISNUMBER(MATCH(AG9,FESTIN,0)),3,0)))","v":2},{"$f":"IF(WEEKDAY(AH9)=1,1,IF(WEEKDAY(AH9)=7,2,IF(ISNUMBER(MATCH(AH9,FESTIN,0)),3,0)))","v":1}]
[null,"2025-04-18",null,{"$f":"IF(WEEKDAY(D9)=1,1,IF(WEEKDAY(D9)=7,2,IF(ISNUMBER(MATCH(D9,FESTIN,0)),3,0)))","v":3},2,1,0,0,0,0,0,2,1,0,0,0,0,0,2,1,3,0,0,0,0,2,1,0,0,0,0]
[null,"2025-05-01"]
[null,"2025-06-02"]
[null,"2025-06-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"|"]
[null,"2025-06-30"]
[null,"2025-07-20"]
[null,"2025-08-07"]
[null,"2025-08-18"]
[null,"2025-10-13"]
[null,"2025-11-03"]
[null,"2025-11-17"]
[null,"2025-12-08"]
[null,"2025-12-25"]
[null,"2026-01-01"]
[null,"2026-01-12"]
[null,"2026-03-23"]
[null,"2026-04-02"]
[null,"2026-04-03"]
[null,"2026-05-01"]
[null,"2026-05-18"]
[null,"2026-06-08"]
[null,"2026-06-15"]
[null,"2026-06-29"]
[null,"2026-07-20"]
[null,"2026-08-07"]
[null,"2026-08-17"]
[null,"2026-09-12"]
[null,"2026-11-02"]
[null,"2026-11-16"]
[null,"2026-12-08"]
[null,"2026-12-25"]
[null,"2027-01-01"]
[null,"2027-01-11"]
[null,"2027-03-22"]
[null,"2027-03-25"]
[null,"2027-03-26"]
[null,"2027-05-01"]
[null,"2027-05-10"]
[null,"2027-05-31"]
[null,"2027-06-07"]
[null,"2027-07-05"]
[null,"2027-07-20"]
[null,"2027-08-07"]
[null,"2027-08-16"]
[null,"2027-10-18"]
[null,"2027-11-01"]
[null,"2027-11-15"]
[null,"2027-12-08"]
[null,"2027-12-25"]
[null,"2028-01-01"]
[null,"2028-01-10"]
[null,"2028-03-20"]
[null,"2028-04-13"]
[null,"2028-04-14"]
[null,"2028-04-16"]
[null,"2028-05-01"]
[null,"2028-05-29"]
[null,"2028-06-19"]
[null,"2028-06-26"]
[null,"2028-07-03"]
[null,"2028-07-20"]
[null,"2028-08-07"]
[null,"2028-08-21"]
[null,"2028-10-16"]
[null,"2028-11-06"]
[null,"2028-11-13"]
[null,"2028-12-08"]
[null,"2028-12-25"]
[null,"2029-01-01"]
[null,"2029-01-08"]
[null,"2029-03-19"]
[null,"2029-03-29"]
[null,"2029-03-30"]
[null,"2029-05-01"]
[null,"2029-05-14"]
[null,"2029-06-04"]
[null,"2029-06-11"]
[null,"2029-07-02"]
[null,"2029-07-20"]
[null,"2029-08-07"]
[null,"2029-08-20"]
[null,"2029-10-15"]
[null,"2029-11-05"]
[null,"2029-11-12"]
[null,"2029-12-08"]
[null,"2029-12-25"]

{"sheet":"Instrucciones","index":1,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,2,0],[0,1,2,1]]}
[null,"SERVICIOS – PRONÓSTICOS Y ALERTAS\nFORMATO PROGRAMACIÓN DE TURNOS  OSPA",{"$f":"+'[2]TURNO MENSUAL'!Z1","v":"Código: SPA-F003 "}]
[null,null,{"$f":"+'FORMATO TURNO MENSUAL'!Z2:AE2","v":"Versión: 06"},0,0,0,0,0]
[null,null,{"$f":"+'FORMATO TURNO MENSUAL'!Z3:AE3","v":"Fecha: 29/05/2026"},0,0,0,0,0]
[null,"INSTRUCCIONES"]
[null,"Generalidades: El presente formato se debe diligenciar en un archivo mensual individual. Este documento unifica la programación temática y general en un solo archivo consolidado, permitiendo el control y seguimiento integral de los turnos de la Oficina. Será de responsabilidad del Coordinador de cada grupo temático de la OSPA. "]
[null,"IMPORTANTE: El archivo contiene fórmulas y procesos automatizados. Para garantizar su correcto funcionamiento, modifique únicamente las celdas y campos indicados a continuación."]
[]
[null,"PASO 1: TABLERO DE CONTROL"]
[null,"Antes de iniciar el registro de turnos, es indispensable actualizar la relación del personal activo y habilitado a prestar turnos en la OSPA. Diligencie la información requerida en las siguientes columnas:"]
[null,"* Nombre Funcionario (Columna AN): Indique el nombre completo del servidor (Planta o Contratista)."]
[null,"* Código (Columna AO): Asigne las siglas del nombre y apellido. Nota: Este código debe ser único; no puede repetirse entre colaboradores. "]
[null,"* Tipo de Vinculación (Columna BA): Establezca el código correspondiente según el caso: FO - Funcionario OSPA, CO - Contratista OSPA, FA - Funcionario de Apoyo, CA - Contratista de Apoyo"]
[]
[null,"PASO 2: REGISTRO DE TURNO"]
[null,"En esta etapa, se realiza la distribución de los turnos basándose en la programación temática definida previamente. Siga estas instrucciones para un correcto diligenciamiento:"]
[null,"* Periodo Programación (Celdas T5 y Z5):Ingrese el mes y el año correspondientes. El archivo actualizará automáticamente los días del mes y resaltará los fines de semana. Nota: Se recomienda validar que los días festivos estén correctamente marcados. En caso de error, verifique el listado de fechas de referencia a partir de la celda B75."]
[null,"* Temática y Turno/Actividad (Columnas A, B Y C): Defina para cada temática (Deslizamientos, Incendios, Datos, Meteorología o Hidrología) o actividad (Entrenamiento, Actividades de oficina, No disponible, entre otras) los turnos requeridos para el mes u otras actividades a realizar (Compesatorios, comisiones, vacaciones, licencias, entre otros)."]
[null,"* Registro de turno (Columnas D a AH):  Asigne los turnos a cada profesional ingresando el código (establecido en el Paso 1) en el día correspondiente.  Control de Errores: El formato cuenta con una alerta de duplicidad. Si se asigna a un mismo profesional en más de un turno el mismo día, las celdas se tomará un borde color rojo. "]
[]
[null,"PASO 3: VALIDACIONES"]
[null,"Realice las verificaciones necesarias para asegurar que los turnos se hayan distribuido de forma equitativa entre el equipo. Para facilitar esta revisión, el formato cuenta con tres niveles de validación visual:"]
[null,"* Validación 1 (Celda AK14): Ingrese el código del profesional a consultar. Automáticamente, en la tabla de asignación (D10:AH70), sus turnos se resaltarán en naranja claro. Además, se totalizará su carga en la fila 7 y en la columna AI para agilizar el conteo."]
[null,"* Validación 2 (Celda AK16): Ingrese el código de un segundo profesional. Sus turnos se resaltarán en la tabla con un relleno verde claro, permitirá hacer comparaciones facilmente entre profesionales. "]
[null,"* Validación 3 (Celda AK18): Ingrese el código de un tercer profesional. Sus turnos se resaltarán en la tabla con un relleno verde fosforescente, , permitirá hacer comparaciones facilmente entre profesionales. "]
[null,"NOTA IMPORTANTE:: Si no requiere realizar validaciones, mantenga las tres celdas (AK14, AK16 y AK18) con el carácter de coma ( , ). Esto es indispensable para que el proceso de automatización y el formato condicional funcionen correctamente."]

{"sheet":"Control de cambios","index":2,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,3,10,9],[11,3,11,9],[12,3,12,9],[13,3,13,9],[1,9,3,9],[5,4,5,8],[7,3,7,9],[8,3,8,9],[9,3,9,9],[1,1,5,3],[1,4,4,8]]}
[]
[null," ",null,null,"FORMATO PROGRAMACIÓN DE TURNOS  OSPA",null,null,null,null,{"$f":"+'[2]TURNO MENSUAL'!Z1","v":"Código: SPA-F003 "}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'[2]TURNO MENSUAL'!Z2","v":"Versión: 06"}]
[null,null,null,null,"SERVICIOS – PRONÓSTICOS Y ALERTAS",null,null,null,null,{"$f":"+'FORMATO TURNO MENSUAL'!Z3:AE3","v":"Fecha: 29/05/2026"},0,0,0,0,0]
[null,"CONTROL DE CAMBIOS"]
[null,"Versión","Fecha","Cambios Realizados "]
[null,1,"2019-09-30","Creación del documento"]
[null,2,"2022-05-11","Cambio de formato  teniendo en cuenta que el anterior lleva una celda protegida la cual debería ser editable y que corresponde a la fecha del mes programado."]
[null,3,"2022-10-18","Actualización de formato"]
[null,4,"2024-09-10","Actualización de formato y ajuste de colores para dar cumplimiento a la accesibilidad. "]
[null,5,"2025-07-02","Se actualiza el Formato de acuerdo con el memorando enviado por la OAP memorando 20251100097283 lineamientos para la actualización documental en el marco de la implementación del aplicativo suite visión. El código pasa de m-s-p-f003 a spa-f003."]
[null,6,"2026-05-29","Se realiza actualización ajustando a las necesidades de la operación, se estructura adecuadamente la hoja de instrucciones, mantenimiento el cumplimiento de accesibilidad"]