{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["TOTAL MES TIPO","FRANJAS MES TIPO","ATENDIDAS MES AÑO"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900"}

{"sheet":"TOTAL MES TIPO","index":0,"n_rows":52,"n_cols":6,"rows_kept":52,"merged":[[1,1,1,6],[2,1,2,3],[3,1,9,1],[10,1,10,3],[11,1,17,1],[18,1,18,3],[19,1,25,1],[26,1,26,3],[27,1,33,1],[34,1,34,3],[35,1,41,1],[42,1,42,3],[43,1,49,1],[50,1,50,3],[51,1,51,3]]}
[]
[null,"LLAMADAS"]
[null,"DÍA",null,null,"ATENDIDAS","RECIBIDAS"]
[null,{"$f":"CONCATENATE(\"SEMANA \",INT((DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-DATE(YEAR(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-1)+4),1,3)+WEEKDAY(DATE(YEAR(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-1)+4),1,3))+5)/7))","v":"SEMANA 22"},{"$f":"IF(WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),1),2)=1,1,\"\")","v":""},"LUNES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C4), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C4)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":0},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C4), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,null,{"$f":"IF(WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),1),2)=2,1,IF($C4<>\"\",$C4+1,\"\"))","v":""},"MARTES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C5), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C5)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":0},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C5), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,null,{"$f":"IF(WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),1),2)=3,1,IF($C5<>\"\",$C5+1,\"\"))","v":""},"MIÉRCOLES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C6), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C6)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":0},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C6), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,null,{"$f":"IF(WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),1),2)=4,1,IF($C6<>\"\",$C6+1,\"\"))","v":""},"JUEVES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C7), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C7)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":0},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C7), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,null,{"$f":"IF(WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),1),2)=5,1,IF($C7<>\"\",$C7+1,\"\"))","v":""},"VIERNES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C8), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C8)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":0},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C8), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,null,{"$f":"IF(WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),1),2)=6,1,IF($C8<>\"\",$C8+1,\"\"))","v":1},"SABADO",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C9), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C9)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":16},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C9), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":20}]
[null,null,{"$f":"IF(WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),1),2)=7,1,IF($C9<>\"\",$C9+1,\"\"))","v":2},"DOMINGO",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C10), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C10)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":8},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C10), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":9}]
[null,"TOTAL SEMANA",null,null,{"$f":"SUM(E4:E10)","v":24},{"$f":"SUM(F4:F10)","v":29}]
[null,{"$f":"CONCATENATE(\"SEMANA \",INT((DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-DATE(YEAR(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-1)+4),1,3)+WEEKDAY(DATE(YEAR(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-1)+4),1,3))+5)/7)+1)","v":"SEMANA 23"},{"$f":"C10+1","v":3},"LUNES",230,{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C12), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":235}]
[null,null,{"$f":"C12+1","v":4},"MARTES",267,{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C13), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":278}]
[null,null,5,"MIÉRCOLES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C14), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C14)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":219},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C14), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":229}]
[null,null,6,"JUEVES",208,{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C15), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":214}]
[null,null,7,"VIERNES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C16), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C16)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":157},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C16), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":160}]
[null,null,8,"SABADO",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C17), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C17)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":21},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C17), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":26}]
[null,null,9,"DOMINGO",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C18), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C18)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":11},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C18), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":17}]
[null,"TOTAL SEMANA",null,null,{"$f":"SUM(E12:E18)","v":1113},{"$f":"SUM(F12:F18)","v":1159}]
[null,{"$f":"CONCATENATE(\"SEMANA \",INT((DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-DATE(YEAR(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-1)+4),1,3)+WEEKDAY(DATE(YEAR(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-1)+4),1,3))+5)/7)+2)","v":"SEMANA 24"},{"$f":"C18+1","v":10},"LUNES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C20), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C20)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":254},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C20), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":266}]
[null,null,{"$f":"C20+1","v":11},"MARTES",241,{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C21), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":255}]
[null,null,12,"MIÉRCOLES",228,{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C22), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":237}]
[null,null,13,"JUEVES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C23), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C23)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":157},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C23), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":160}]
[null,null,14,"VIERNES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C24), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C24)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":141},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C24), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":143}]
[null,null,15,"SABADO",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C25), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C25)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":19},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C25), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":20}]
[null,null,16,"DOMINGO",16,{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C26), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":20}]
[null,"TOTAL SEMANA",null,null,{"$f":"SUM(E20:E26)","v":1056},{"$f":"SUM(F20:F26)","v":1101}]
[null,{"$f":"CONCATENATE(\"SEMANA \",INT((DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-DATE(YEAR(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-1)+4),1,3)+WEEKDAY(DATE(YEAR(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-1)+4),1,3))+5)/7)+3)","v":"SEMANA 25"},{"$f":"C26+1","v":17},"LUNES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C28), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C28)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":248},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C28), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":277}]
[null,null,{"$f":"C28+1","v":18},"MARTES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C29), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C29)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":163},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C29), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":183}]
[null,null,19,"MIÉRCOLES",221,{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C30), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":248}]
[null,null,20,"JUEVES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C31), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C31)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":232},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C31), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":241}]
[null,null,21,"VIERNES",144,{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C32), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":155}]
[null,null,22,"SABADO",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C33), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C33)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":19},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C33), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":21}]
[null,null,23,"DOMINGO",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C34), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C34)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":10},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C34), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":12}]
[null,"TOTAL SEMANA",null,null,{"$f":"SUM(E28:E34)","v":1037},{"$f":"SUM(F28:F34)","v":1137}]
[null,{"$f":"CONCATENATE(\"SEMANA \",INT((DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-DATE(YEAR(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-1)+4),1,3)+WEEKDAY(DATE(YEAR(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-1)+4),1,3))+5)/7)+4)","v":"SEMANA 26"},{"$f":"IF(OR($C34=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C34=\"\"),\"\",$C34+1)","v":24},"LUNES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C36), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C36)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":164},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C36), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":172}]
[null,null,{"$f":"IF(OR($C36=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C36=\"\"),\"\",$C36+1)","v":25},"MARTES",110,{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C37), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":120}]
[null,null,{"$f":"IF(OR($C37=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C37=\"\"),\"\",$C37+1)","v":26},"MIÉRCOLES",198,{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C38), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":214}]
[null,null,{"$f":"IF(OR($C38=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C38=\"\"),\"\",$C38+1)","v":27},"JUEVES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C39), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C39)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":178},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C39), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":185}]
[null,null,{"$f":"IF(OR($C39=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C39=\"\"),\"\",$C39+1)","v":28},"VIERNES",156,{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C40), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":166}]
[null,null,{"$f":"IF(OR($C40=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C40=\"\"),\"\",$C40+1)","v":29},"SABADO",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C41), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C41)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":17},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C41), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":21}]
[null,null,{"$f":"IF(OR($C41=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C41=\"\"),\"\",$C41+1)","v":30},"DOMINGO",2,{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C42), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,"TOTAL SEMANA",null,null,{"$f":"SUM(E36:E42)","v":825},{"$f":"SUM(F36:F42)","v":878}]
[null,{"$f":"CONCATENATE(\"SEMANA \",INT((DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-DATE(YEAR(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-1)+4),1,3)+WEEKDAY(DATE(YEAR(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-WEEKDAY(DATE(YEAR('[1]Raw Data - Interacciones'!$C$2),MONTH('[1]Raw Data - Interacciones'!$C$2),DAY('[1]Raw Data - Interacciones'!$C$2))-1)+4),1,3))+5)/7)+5)","v":"SEMANA 27"},{"$f":"IF(OR($C42=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C42=\"\"),\"\",$C42+1)","v":""},"LUNES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C44), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C44)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":0},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C44), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,null,{"$f":"IF(OR($C44=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C44=\"\"),\"\",$C44+1)","v":""},"MARTES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C45), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C45)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":0},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C45), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,null,{"$f":"IF(OR($C45=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C45=\"\"),\"\",$C45+1)","v":""},"MIÉRCOLES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C46), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C46)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":0},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C46), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,null,{"$f":"IF(OR($C46=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C46=\"\"),\"\",$C46+1)","v":""},"JUEVES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C47), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C47)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":0},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C47), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,null,{"$f":"IF(OR($C47=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C47=\"\"),\"\",$C47+1)","v":""},"VIERNES",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C48), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C48)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":0},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C48), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,null,{"$f":"IF(OR($C48=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C48=\"\"),\"\",$C48+1)","v":""},"SABADO",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C49), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C49)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":0},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C49), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,null,{"$f":"IF(OR($C49=DAY(EOMONTH('[1]Raw Data - Interacciones'!$C$7,0)),$C49=\"\"),\"\",$C49+1)","v":""},"DOMINGO",{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$E$2:$E$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C50), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")+ SUMPRODUCT((DAY('[1]Raw Data - HISTORICO'!$E$2:$E$40000)=C50)*('[1]Raw Data - HISTORICO'!$AF$2:$AF$40000)*('[1]Raw Data - HISTORICO'!$G$2:$G$40000 =\"UR_KONTSORTZIO\"))","v":0},{"$f":"SUMIFS('[1]Raw Data - Interacciones'!$D$2:$D$40000,'[1]Raw Data - Interacciones'!$C$2:$C$40000,DATE(YEAR('[1]Raw Data - Interacciones'!$C$7),MONTH('[1]Raw Data - Interacciones'!$C$7),$C50), '[1]Raw Data - Interacciones'!$B$2:$B$40000,\"Telefonía\")","v":0}]
[null,"TOTAL SEMANA",null,null,{"$f":"SUM(E44:E50)","v":0},{"$f":"SUM(F44:F50)","v":0}]
[null,"TOTAL MES",null,null,{"$f":"SUM(E35+E27+E19+E11+E43+E51)","v":4055},{"$f":"SUM(F35+F27+F19+F11+F43+F51)","v":4304}]

{"sheet":"FRANJAS MES TIPO","index":1,"n_rows":28,"n_cols":35,"rows_kept":28,"merged":[[1,33,1,34],[2,33,2,34]]}
[]
[null,"CC+BIDEO","SÁBADO","DOMINGO","LUNES","MARTES","MIÉRCOLES","JUEVES","VIERNES","SÁBADO","DOMINGO","LUNES","MARTES","MIÉRCOLES","JUEVES","VIERNES","SÁBADO","DOMINGO","LUNES","MARTES","MIÉRCOLES","JUEVES","VIERNES","SÁBADO","DOMINGO","LUNES","MARTES","MIÉRCOLES","JUEVES","VIERNES","SÁBADO","DOMINGO","LUNES","TOTAL"]
[null,"FRANJA",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,"00:00:00",0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C4:AG4)","v":1},{"$f":"AH4*$AI$28/$AH$28","v":{"v":2.4660912453760788E-4,"d":"0.02%"}}]
[null,"01:00:00",0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C5:AG5)","v":1},{"$f":"AH5*$AI$28/$AH$28","v":{"v":2.4660912453760788E-4,"d":"0.02%"}}]
[null,"02:00:00",0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,{"v":4.9321824907521577E-4,"d":"0.05%"}]
[null,"03:00:00",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,0,{"v":0,"d":"0.00%"}]
[null,"04:00:00",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,0,{"v":0,"d":"0.00%"}]
[null,"05:00:00",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,0,{"v":0,"d":"0.00%"}]
[null,"06:00:00",2,2,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7,{"v":1.7262638717632551E-3,"d":"0.17%"}]
[null,"07:00:00",0,0,1,0,0,1,0,0,0,1,3,2,0,0,0,0,0,0,0,1,1,0,0,0,0,2,1,0,0,0,0,13,{"v":3.2059186189889025E-3,"d":"0.32%"}]
[null,"08:00:00",1,0,10,10,10,8,7,0,0,9,6,7,6,5,2,3,12,5,12,4,6,0,0,7,2,4,5,1,0,0,0,142,{"v":0.03501849568434032,"d":"3.50%"}]
[null,"09:00:00",3,1,29,32,35,33,26,1,1,29,34,34,30,24,2,1,29,29,21,10,25,1,1,15,11,22,18,21,0,0,0,518,{"v":0.12774352651048088,"d":"12.77%"}]
[null,"10:00:00",4,0,35,36,28,17,30,5,0,36,42,28,18,19,3,2,36,21,28,24,29,6,1,27,19,26,45,28,2,0,0,595,{"v":0.1467324290998767,"d":"14.67%"}]
[null,"11:00:00",2,0,40,47,27,34,20,2,1,44,31,42,18,16,2,1,27,20,27,29,23,2,1,26,9,25,16,28,4,0,0,564,{"v":0.13908754623921085,"d":"13.91%"}]
[null,"12:00:00",1,2,21,37,33,21,26,5,0,23,26,24,21,24,4,1,29,21,40,32,15,2,2,30,19,26,29,24,2,0,0,540,{"v":0.13316892725030827,"d":"13.32%"}]
[null,"13:00:00",1,0,24,23,17,21,8,1,1,23,26,19,15,9,0,1,25,8,28,27,9,3,3,15,15,22,17,10,3,0,0,374,{"v":0.09223181257706535,"d":"9.22%"}]
[null,"14:00:00",1,0,13,24,13,13,7,0,2,22,14,13,13,8,2,1,17,12,11,17,11,0,2,4,12,11,4,10,0,0,0,257,{"v":0.06337854500616523,"d":"6.34%"}]
[null,"15:00:00",0,1,11,17,12,13,6,2,0,14,11,13,7,8,1,0,15,9,8,25,3,0,0,8,0,8,10,7,0,0,0,209,{"v":0.05154130702836005,"d":"5.15%"}]
[null,"16:00:00",1,0,10,11,8,17,7,1,0,23,14,12,8,7,1,1,21,13,10,18,2,0,0,7,11,9,9,10,0,1,0,232,{"v":0.05721331689272503,"d":"5.72%"}]
[null,"17:00:00",0,0,15,14,20,7,8,0,0,13,9,12,11,12,1,0,12,8,14,12,11,0,0,7,0,19,10,5,1,0,0,221,{"v":0.054500616522811345,"d":"5.45%"}]
[null,"18:00:00",0,2,12,8,8,7,8,1,3,7,12,10,5,6,0,4,11,7,9,24,3,2,0,4,0,9,8,5,1,0,0,176,{"v":0.04340320591861899,"d":"4.34%"}]
[null,"19:00:00",0,0,6,4,4,9,3,1,1,7,7,3,2,2,1,0,9,6,5,7,5,0,0,7,6,11,4,5,2,0,0,117,{"v":0.028853267570900124,"d":"2.89%"}]
[null,"20:00:00",0,0,2,3,4,1,1,2,0,1,3,4,1,1,0,0,4,2,3,2,1,2,0,5,1,4,2,2,0,1,0,52,{"v":0.01282367447595561,"d":"1.28%"}]
[null,"21:00:00",0,0,0,0,0,2,0,0,0,0,1,2,1,0,0,0,1,2,5,0,0,1,0,2,5,0,0,0,0,0,0,22,{"v":0.005425400739827373,"d":"0.54%"}]
[null,"22:00:00",0,0,0,0,0,3,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,6,{"v":1.4796547472256474E-3,"d":"0.15%"}]
[null,"23:00:00",0,0,0,1,0,1,0,0,0,0,2,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,6,{"v":1.4796547472256474E-3,"d":"0.15%"}]
[null,"TOTAL",{"$f":"SUM(C4:C27)","v":16},{"$f":"SUM(D4:D27)","v":8},230,267,219,208,157,21,11,254,241,228,157,141,19,16,248,163,221,232,144,19,10,164,110,198,178,156,17,2,0,4055,{"v":1,"d":"100.00%"}]

{"sheet":"ATENDIDAS MES AÑO","index":2,"n_rows":17,"n_cols":11,"rows_kept":17,"merged":[[1,2,1,10]]}
[]
[null,null,"LLAMADAS ATENDIDAS 2023-2024 "]
[]
[null,null,"LLAMADAS ","ALARMAK","VIDEO",{"$nulls":3},"LLAMADAS ","ALARMAK","VIDEO"]
[null,"ENERO",4348,54,14,null,null,"ENERO",{"$f":"5077+19","v":5096},261,19]
[null,"FEBRERO",4932,70,14,null,null,"FEBRERO",{"$f":"5310+34","v":5344},200,15]
[null,"MARZO",4277,68,17,null,null,"MARZO",{"$f":"4224+14","v":4238},3793,12]
[null,"ABRIL",3696,40,12,null,null,"ABRIL",{"$f":"4363+17","v":4380},179,7]
[null,"MAYO",5372,0,18,null,null,"MAYO",{"$f":"5425+27","v":5452},263,1]
[null,"JUNIO",4014,335,17,null,null,"JUNIO",{"$f":"4032+23","v":4055},165,2]
[null,"JULIO",3528,304,14,null,null,"JULIO",{"$f":"4884+38","v":4922},173,0]
[null,"AGOSTO",{"$f":"3930+28","v":3958},312,7,null,null,"AGOSTO",{"$f":"4473+80","v":4553},130,1]
[null,"SEPTIEMBRE",{"$f":"3992+28","v":4020},275,20,null,null,"SEPTIEMBRE"]
[null,"OCTUBRE",{"$f":"4569+20","v":4589},433,12]
[null,"NOVIEMBRE",{"$f":"5440+20","v":5460},446,11]
[null,"DICIEMBRE",{"$f":"3434+25","v":3459},318,10]
[null,null,{"$f":"SUM(C5:C16)","v":51653}]