{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Menú","Informaciones iniciais","Informaciones mensuais","Alertas","Original","Comparativo","Aux","Ejemplo"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":"Menú","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,6,3,18],[6,7,13,17]]}
[]
[]
[]
[null,null,null,null,null,null,"Template para métricas mensais"]
[]
[null,null,null,null,null,null,null,"Preencher com o nome do Engarrafador:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,2022]

{"sheet":"Informaciones iniciais","index":1,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,7,6,13],[7,7,7,13],[8,7,8,13],[6,15,6,17],[8,15,8,17]]}
[]
[]
[]
[null,null,"Informaciones iniciales"]
[]
[]
[null,null,null,null,null,null,null,"Qual é a meta total de compra de EDFs para o ano?",null,null,null,null,null,null,null,{"$f":"IF('Informaciones mensuais'!AE7=\"\",\"\",IF(SUM('Informaciones mensuais'!C7:Z7)<'Informaciones iniciais'!O7,\"Plan incompleto, rever siguiente información:  Confirmación de pedidos con el proveedor\",\"\"))","v":""}]
[null,null,null,null,null,null,null,"Qual é a meta de instalação total (novos e usados) para o ano?"]
[null,null,null,null,null,null,null,"Qual é a % de instalação líquida definida em conjunto com a Coca-Cola com base nas instalações totais?",null,null,null,null,null,null,null,{"$f":"IF(O9>O8,\"Error: parque total es menor que  en el mercado\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,"Obs:","Somente solicitaremos esta informação uma vez ao ano"]
[]
[]
[]
[]
[]
[]
[null,null,2022]

{"sheet":"Informaciones mensuais","index":2,"n_rows":23,"n_cols":39,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,23,3,25],[0,5,0,28],[0,2,0,3],[3,32,3,34],[3,2,3,4],[2,2,2,7],[2,9,2,14],[2,16,2,21],[2,23,2,28],[3,9,3,11],[3,16,3,18]]}
[null,null,"Preencher inconsist. \ne mês atual:",null,"Jan","Informações mensais"]
[]
[null,null,"Análises Q1/2022",null,null,null,null,null,null,"Análises Q2/2022",null,null,null,null,null,null,"Análises Q3/2022",null,null,null,null,null,null,"Análises Q4/2022"]
[null,null,"Template mensal",null,null,"Temp. trim.",null,null,null,"Template mensal",null,null,"Temp. trim.",null,null,null,"Template mensal",null,null,"Temp. trim.",null,null,null,"Template mensal",null,null,"Temp. trim."]
[null,"Processos 2022","Jan","Fev","Mar","Q1/2022",null,"Inconsistência?\nCaso sim, ajustar os dados do mês ou trimestre a esquerda",null,"Abr","Mai","Jun","Q2/2022",null,"Inconsistência?\nCaso sim, ajustar os dados do mês ou trimestre a esquerda",null,"Jul","Ago","Set","Q3/2022",null,"Inconsistência?\nCaso sim, ajustar os dados do mês ou trimestre a esquerda",null,"Out","Nov","Dez","Q4/2022",null,"Inconsistência?\nCaso sim, ajustar os dados do mês ou trimestre a esquerda",null,"Total",null,"vs último mês preenchido","vs YTD","Alerta","Razão","Justificativa (obrigatório somente para dados marcados como nok)",null,"Média"]
[]
[null,"Pedidos confirmados com o fornecedor de EDF",null,null,null,null,null,{"$f":"IF(F7=\"\",\"\",IF(F7=SUM(C7:E7),\"ok\",IF(F7>SUM(C7:E7),F7-SUM(C7:E7),F7-SUM(C7:E7))))","v":""},null,null,null,null,null,null,{"$f":"IF(M7=\"\",\"\",IF(M7=SUM(J7:L7),\"ok\",IF(M7>SUM(J7:L7),M7-SUM(J7:L7),M7-SUM(J7:L7))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA7=\"\",\"\",IF(AA7=SUM(X7:Z7),\"ok\",IF(AA7>SUM(X7:Z7),AA7-SUM(X7:Z7),AA7-SUM(X7:Z7))))","v":""},null,{"$f":"IF(SUM(C7:E7,J7:L7,Q7:S7,X7:Z7)=0,\"\",SUM(C7:E7,J7:L7,Q7:S7,X7:Z7))","v":""}]
[null,"Plano de chegada dos EDFs comprados",null,null,null,null,null,{"$f":"IF(F8=\"\",\"\",IF(F8=SUM(C8:E8),\"ok\",IF(F8>SUM(C8:E8),F8-SUM(C8:E8),F8-SUM(C8:E8))))","v":""},null,null,null,null,null,null,{"$f":"IF(M8=\"\",\"\",IF(M8=SUM(J8:L8),\"ok\",IF(M8>SUM(J8:L8),M8-SUM(J8:L8),M8-SUM(J8:L8))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA8=\"\",\"\",IF(AA8=SUM(X8:Z8),\"ok\",IF(AA8>SUM(X8:Z8),AA8-SUM(X8:Z8),AA8-SUM(X8:Z8))))","v":""},null,{"$f":"IF(SUM(C8:E8,J8:L8,Q8:S8,X8:Z8)=0,\"\",SUM(C8:E8,J8:L8,Q8:S8,X8:Z8))","v":""}]
["1.","Total de coolers\n(mercado + manutenção + descarte+ outros)",null,null,null,null,null,{"$f":"IF(F9=\"\",\"\",IF(F9=E9,\"ok\",IF(F9>E9,F9-E9,F9-E9)))","v":""},null,null,null,null,null,null,{"$f":"IF(M9=\"\",\"\",IF(M9=L9,\"ok\",IF(M9>L9,M9-L9,M9-L9)))","v":""},null,null,null,null,null,null,{"$f":"IF(T9=\"\",\"\",IF(T9=S9,\"ok\",IF(T9>S9,T9-S9,T9-S9)))","v":""},null,null,null,null,null,null,{"$f":"IF(AA9=\"\",\"\",IF(AA9=Z9,\"ok\",IF(AA9>Z9,AA9-Z9,AA9-Z9)))","v":""},null,null,null,{"$f":"IFERROR(ROUND(INDIRECT(Alertas!$D$1&CELL(\"lin\",AL9))/INDIRECT(Alertas!$D$2&CELL(\"lin\",AL9))-1,2),\"\")","v":""},{"$f":"IF(AG9<0,\"<\",\">\")&\" último mês\"","v":"> último mês"},{"$f":"IFERROR(VLOOKUP(ABS(AG9),Alertas!$A$9:$C$11,3,1),\"ok\")","v":"ok"},{"$f":"IF(AI9=\"ok\",\"\",AG9*100&\"% \"&AH9)","v":""}]
["2.","Total de coolers no mercado ",null,null,null,null,null,{"$f":"IF(F10=\"\",\"\",IF(F10=E10,\"ok\",IF(F10>E10,F10-E10,F10-E10)))","v":""},null,null,null,null,null,null,{"$f":"IF(M10=\"\",\"\",IF(M10=L10,\"ok\",IF(M10>L10,M10-L10,M10-L10)))","v":""},null,null,null,null,null,null,{"$f":"IF(T10=\"\",\"\",IF(T10=S10,\"ok\",IF(T10>S10,T10-S10,T10-S10)))","v":""},null,null,null,null,null,null,{"$f":"IF(AA10=\"\",\"\",IF(AA10=Z10,\"ok\",IF(AA10>Z10,AA10-Z10,AA10-Z10)))","v":""},null,null,null,{"$f":"IFERROR(ROUND(INDIRECT(Alertas!$D$1&CELL(\"lin\",AL10))/INDIRECT(Alertas!$D$2&CELL(\"lin\",AL10))-1,2),\"\")","v":""},{"$f":"IF(AG10<0,\"<\",\">\")&\" último mês\"","v":"> último mês"},{"$f":"IFERROR(VLOOKUP(ABS(AG10),Alertas!$D$9:$F$11,3,1),\"ok\")","v":"ok"},{"$f":"IF(AI10=\"ok\",\"\",AG10*100&\"% \"&AH10)","v":""}]
["3.","Chegadas confirmadas dos EDFs ao bottler",null,null,null,null,null,{"$f":"IF(F11=\"\",\"\",IF(F11=SUM(C11:E11),\"ok\",IF(F11>SUM(C11:E11),F11-SUM(C11:E11),F11-SUM(C11:E11))))","v":""},null,null,null,null,null,null,{"$f":"IF(M11=\"\",\"\",IF(M11=SUM(J11:L11),\"ok\",IF(M11>SUM(J11:L11),M11-SUM(J11:L11),M11-SUM(J11:L11))))","v":""},null,null,null,null,null,null,{"$f":"IF(T11=\"\",\"\",IF(T11=SUM(Q11:S11),\"ok\",IF(T11>SUM(Q11:S11),T11-SUM(Q11:S11),T11-SUM(Q11:S11))))","v":""},null,null,null,null,null,null,{"$f":"IF(AA11=\"\",\"\",IF(AA11=SUM(X11:Z11),\"ok\",IF(AA11>SUM(X11:Z11),AA11-SUM(X11:Z11),AA11-SUM(X11:Z11))))","v":""},null,{"$f":"IF(SUM(C11:E11,J11:L11,Q11:S11,X11:Z11)=0,\"\",SUM(C11:E11,J11:L11,Q11:S11,X11:Z11))","v":""},null,{"$f":"IF(AH11<0,\"<\",\">\")&\" plano de chegadas YTD\"","v":"> plano de chegadas YTD"},{"$f":"IFERROR(ROUND(AE11/VLOOKUP(Alertas!$C$1,Alertas!$N$8:$S$19,5,0)-1,2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ABS(AG11),Alertas!G9:I11,3,1),\"ok\")","v":"ok"},{"$f":"IF(AI11=\"ok\",\"\",AH11*100&\"% \"&AG11)","v":""},null,null,{"$f":"IFERROR(IF(AVERAGE(C11:E11,J11:L11,Q11:S11,X11:Z11)=0,\"\",AVERAGE(C11:E11,J11:L11,Q11:S11,X11:Z11)),\"\")","v":""}]
["4.","Instalação de EDFs total \n(1ª instalação + EDF adicional +  *troca de EDFs + eventos + outros)",null,null,null,null,null,{"$f":"IF(F12=\"\",\"\",IF(F12=SUM(C12:E12),\"ok\",IF(F12>SUM(C12:E12),F12-SUM(C12:E12),F12-SUM(C12:E12))))","v":""},null,null,null,null,null,null,{"$f":"IF(M12=\"\",\"\",IF(M12=SUM(J12:L12),\"ok\",IF(M12>SUM(J12:L12),M12-SUM(J12:L12),M12-SUM(J12:L12))))","v":""},null,null,null,null,null,null,{"$f":"IF(T12=\"\",\"\",IF(T12=SUM(Q12:S12),\"ok\",IF(T12>SUM(Q12:S12),T12-SUM(Q12:S12),T12-SUM(Q12:S12))))","v":""},null,null,null,null,null,null,{"$f":"IF(AA12=\"\",\"\",IF(AA12=SUM(X12:Z12),\"ok\",IF(AA12>SUM(X12:Z12),AA12-SUM(X12:Z12),AA12-SUM(X12:Z12))))","v":""},null,{"$f":"IF(SUM(C12:E12,J12:L12,Q12:S12,X12:Z12)=0,\"\",SUM(C12:E12,J12:L12,Q12:S12,X12:Z12))","v":""},null,{"$f":"IF(AH12<0,\"<\",\">\")&\" média dos meses\"","v":"> média dos meses"},{"$f":"IFERROR(ROUND(INDIRECT(Alertas!$D$1&CELL(\"lin\",AL12))/AM12-1,2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ABS(AH12),Alertas!$J$9:$L$11,3,1),\"ok\")","v":"ok"},{"$f":"IF(AI12=\"ok\",\"\",AH12*100&\"% \"&AG12)","v":""},null,null,{"$f":"IFERROR(IF(AVERAGE(C12:E12,J12:L12,Q12:S12,X12:Z12)=0,\"\",AVERAGE(C12:E12,J12:L12,Q12:S12,X12:Z12)),\"\")","v":""}]
["5.","Recolhimento total de EDFs\n(Baixa performance + venda zero + cliente fechado, fechando ou com cooler próprios +  invasão + *Troca de EDFs + eventos + outros)",null,null,null,null,null,{"$f":"IF(F13=\"\",\"\",IF(F13=SUM(C13:E13),\"ok\",IF(F13>SUM(C13:E13),F13-SUM(C13:E13),F13-SUM(C13:E13))))","v":""},null,null,null,null,null,null,{"$f":"IF(M13=\"\",\"\",IF(M13=SUM(J13:L13),\"ok\",IF(M13>SUM(J13:L13),M13-SUM(J13:L13),M13-SUM(J13:L13))))","v":""},null,null,null,null,null,null,{"$f":"IF(T13=\"\",\"\",IF(T13=SUM(Q13:S13),\"ok\",IF(T13>SUM(Q13:S13),T13-SUM(Q13:S13),T13-SUM(Q13:S13))))","v":""},null,null,null,null,null,null,{"$f":"IF(AA13=\"\",\"\",IF(AA13=SUM(X13:Z13),\"ok\",IF(AA13>SUM(X13:Z13),AA13-SUM(X13:Z13),AA13-SUM(X13:Z13))))","v":""},null,{"$f":"IF(SUM(C13:E13,J13:L13,Q13:S13,X13:Z13)=0,\"\",SUM(C13:E13,J13:L13,Q13:S13,X13:Z13))","v":""},null,{"$f":"IF(AH13<0,\"<\",\">\")&\" média dos meses\"","v":"> média dos meses"},{"$f":"IFERROR(ROUND(INDIRECT(Alertas!$D$1&CELL(\"lin\",AL13))/AM13-1,2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ABS(AH13),Alertas!$A$14:$C$16,3,1),\"ok\")","v":"ok"},{"$f":"IF(AI13=\"ok\",\"\",AH13*100&\"% \"&AG13)","v":""},null,null,""]
["6.","Nº de EDFs no mercado com venda zero 30 dias ou mais",null,null,null,null,null,{"$f":"IF(F14=\"\",\"\",IF(F14=E14,\"ok\",IF(F14>E14,F14-E14,F14-E14)))","v":""},null,null,null,null,null,null,{"$f":"IF(M14=\"\",\"\",IF(M14=L14,\"ok\",IF(M14>L14,M14-L14,M14-L14)))","v":""},null,null,null,null,null,null,{"$f":"IF(T14=\"\",\"\",IF(T14=S14,\"ok\",IF(T14>S14,T14-S14,T14-S14)))","v":""},null,null,null,null,null,null,{"$f":"IF(AA14=\"\",\"\",IF(AA14=Z14,\"ok\",IF(AA14>Z14,AA14-Z14,AA14-Z14)))","v":""},null,null,null,{"$f":"IFERROR(ROUND(INDIRECT(Alertas!$D$1&CELL(\"lin\",AL14))/INDIRECT(Alertas!$D$2&CELL(\"lin\",AL14))-1,2),\"\")","v":""},{"$f":"IF(AG14<0,\"<\",\">\")&\" último mês\"","v":"> último mês"},{"$f":"IFERROR(VLOOKUP(ABS(AG14),Alertas!$D$14:$F$16,3,1),\"ok\")","v":"ok"},{"$f":"IF(AI14=\"ok\",\"\",AG14*100&\"% \"&AH14)","v":""}]
["7.","Nº de EDFs com conectividade e com informação atualizada nos últimos 30 dias",null,null,null,null,null,{"$f":"IF(F15=\"\",\"\",IF(F15=E15,\"ok\",IF(F15>E15,F15-E15,F15-E15)))","v":""},null,null,null,null,null,null,{"$f":"IF(M15=\"\",\"\",IF(M15=L15,\"ok\",IF(M15>L15,M15-L15,M15-L15)))","v":""},null,null,null,null,null,null,{"$f":"IF(T15=\"\",\"\",IF(T15=S15,\"ok\",IF(T15>S15,T15-S15,T15-S15)))","v":""},null,null,null,null,null,null,{"$f":"IF(AA15=\"\",\"\",IF(AA15=Z15,\"ok\",IF(AA15>Z15,AA15-Z15,AA15-Z15)))","v":""},null,null,null,{"$f":"IFERROR(ROUND(INDIRECT(Alertas!$D$1&CELL(\"lin\",AL15))/INDIRECT(Alertas!$D$2&CELL(\"lin\",AL15))-1,2),\"\")","v":""},{"$f":"IF(AG15<0,\"<\",\">\")&\" último mês\"","v":"> último mês"},{"$f":"IFERROR(VLOOKUP(ABS(AG15),Alertas!$G$14:$I$16,3,1),\"ok\")","v":"ok"},{"$f":"IF(AI15=\"ok\",\"\",AG15*100&\"% \"&AH15)","v":""}]
[]
["IMPORTANTE"]
["* Troca de EDFs são trocas comerciais (upsize, downsize de portas ou similares) e trocas técnicas (necessidade diagnosticada pelo técnico)"]
[". Troca de EDFs contabilizam tanto em recolhimento como em instalação porque a troca de um EDF prevê seu recolhimento para a instalação de outro em seu lugar."]
[]
[null,"Legenda:"]
[null,"Preencha todo o plano anual"]
[null,"Preencha os dados mês a mês (concluído)"]

{"sheet":"Alertas","index":3,"n_rows":20,"n_cols":19,"rows_kept":20,"cut":false,"hidden":true,"merged":[[12,0,12,2],[12,3,12,5],[12,6,12,8],[12,9,12,11],[0,0,0,1],[7,0,7,2],[7,3,7,5],[7,6,7,8],[7,9,7,11]]}
["Selecione o mês atual",null,"Dez",{"$f":"VLOOKUP(C1,$N$8:$O$19,2,0)","v":"z"}]
[null,null,{"$f":"VLOOKUP(C1,$N$8:$P$20,3,0)","v":"Nov"},{"$f":"VLOOKUP(C2,$P$9:$Q$20,2,0)","v":"y"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan de chegadas YTD","EDFs descartadas no último trimestre"]
["Total de coolers",null,null,"Total de coolers no mercado ",null,null,"Chegadas confirmadas dos EDFs ao bottler",null,null,"Instalação de EDFs total ",null,null,null,"Jan","c",null,null,{"$f":"'Informaciones mensuais'!C8","v":0}]
[0,0.05,"ok",0,0.05,"ok",0,0.1,"ok",0,0.1,"ok",null,"Fev","d","Jan","c",{"$f":"'Informaciones mensuais'!C8+'Informaciones mensuais'!D8","v":0}]
[{"$f":"B9+0.0000001","v":5.0000100000000006E-2},0.1,"Atención",{"$f":"E9+0.0000001","v":5.0000100000000006E-2},0.1,"Atención",{"$f":"H9+0.0000001","v":0.10000010000000001},0.2,"Atención",{"$f":"K9+0.0000001","v":0.10000010000000001},0.2,"Atención",null,"Mar","e","Fev","d",{"$f":"'Informaciones mensuais'!C8+'Informaciones mensuais'!D8+'Informaciones mensuais'!E8","v":0},"f16"]
[{"$f":"B10+0.0000001","v":0.10000010000000001},1,"nok",{"$f":"E10+0.0000001","v":0.10000010000000001},1,"nok",{"$f":"H10+0.0000001","v":0.20000010000000001},1,"nok",{"$f":"K10+0.0000001","v":0.20000010000000001},1,"nok",null,"Abr","j","Mar","e",{"$f":"'Informaciones mensuais'!C8+'Informaciones mensuais'!D8+'Informaciones mensuais'!E8+'Informaciones mensuais'!J8","v":0},"f16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mai","k","Abr","j",{"$f":"'Informaciones mensuais'!C8+'Informaciones mensuais'!D8+'Informaciones mensuais'!E8+'Informaciones mensuais'!J8+'Informaciones mensuais'!K8","v":0},"f16"]
["Recolhimento total de EDFs",null,null,"Nº de EDFs no mercado com venda zero 30 dias ou mais",null,null,"Nº de EDFs con conectividad y con información actualizada en los últimos 30 días",null,null,"Nº de EDFs descartados en el mês",null,null,null,"Jun","l","Mai","k",{"$f":"'Informaciones mensuais'!C8+'Informaciones mensuais'!D8+'Informaciones mensuais'!E8+'Informaciones mensuais'!J8+'Informaciones mensuais'!K8+'Informaciones mensuais'!L8","v":0},"m16"]
[0,0.1,"ok",0,0.05,"ok",0,0.5,"ok",0,0.03,"ok",null,"Jul","q","Jun","l",{"$f":"'Informaciones mensuais'!C8+'Informaciones mensuais'!D8+'Informaciones mensuais'!E8+'Informaciones mensuais'!J8+'Informaciones mensuais'!K8+'Informaciones mensuais'!L8+'Informaciones mensuais'!Q8","v":0},"m16"]
[{"$f":"B14+0.0000001","v":0.10000010000000001},0.2,"Atención",{"$f":"E14+0.0000001","v":5.0000100000000006E-2},0.1,"Atención",{"$f":"H14+0.0000001","v":0.50000009999999995},1,"Atención",{"$f":"K14+0.0000001","v":3.0000099999999998E-2},0.05,"Atención",null,"Ago","r","Jul","q",{"$f":"'Informaciones mensuais'!C8+'Informaciones mensuais'!D8+'Informaciones mensuais'!E8+'Informaciones mensuais'!J8+'Informaciones mensuais'!K8+'Informaciones mensuais'!L8+'Informaciones mensuais'!Q8+'Informaciones mensuais'!R8","v":0},"m16"]
[{"$f":"B15+0.0000001","v":0.20000010000000001},1,"nok",{"$f":"E15+0.0000001","v":0.10000010000000001},1,"nok",{"$f":"H15+0.0000001","v":1.0000001000000001},10,"nok",{"$f":"K15+0.0000001","v":5.0000100000000006E-2},10,"nok",null,"Set","s","Ago","r",{"$f":"'Informaciones mensuais'!C8+'Informaciones mensuais'!D8+'Informaciones mensuais'!E8+'Informaciones mensuais'!J8+'Informaciones mensuais'!K8+'Informaciones mensuais'!L8+'Informaciones mensuais'!Q8+'Informaciones mensuais'!R8+'Informaciones mensuais'!S8","v":0},"t16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Out","x","Set","s",{"$f":"'Informaciones mensuais'!C8+'Informaciones mensuais'!D8+'Informaciones mensuais'!E8+'Informaciones mensuais'!J8+'Informaciones mensuais'!K8+'Informaciones mensuais'!L8+'Informaciones mensuais'!Q8+'Informaciones mensuais'!R8+'Informaciones mensuais'!S8+'Informaciones mensuais'!W8","v":0},"t16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nov","y","Out","x",{"$f":"'Informaciones mensuais'!C8+'Informaciones mensuais'!D8+'Informaciones mensuais'!E8+'Informaciones mensuais'!J8+'Informaciones mensuais'!K8+'Informaciones mensuais'!L8+'Informaciones mensuais'!Q8+'Informaciones mensuais'!R8+'Informaciones mensuais'!S8+'Informaciones mensuais'!W8+'Informaciones mensuais'!Y8","v":0},"t16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Dez","z","Nov","y",{"$f":"'Informaciones mensuais'!C8+'Informaciones mensuais'!D8+'Informaciones mensuais'!E8+'Informaciones mensuais'!J8+'Informaciones mensuais'!K8+'Informaciones mensuais'!L8+'Informaciones mensuais'!Q8+'Informaciones mensuais'!R8+'Informaciones mensuais'!S8+'Informaciones mensuais'!W8+'Informaciones mensuais'!Y8+'Informaciones mensuais'!Z8","v":0},"a16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dez","z"]

{"sheet":"Original","index":4,"n_rows":24,"n_cols":36,"rows_kept":24,"cut":false,"hidden":true,"merged":[[3,2,3,4],[3,9,3,11],[3,16,3,18],[3,23,3,25],[3,32,3,34],[0,2,0,3],[0,5,0,28],[2,2,2,7],[2,9,2,14],[2,16,2,21],[2,23,2,28]]}
[null,null,"Llenar inconsist. \ny mes actual:",null,{"$f":"'Informaciones mensuais'!E1","v":"Jan"},"Informaciones mensuales"]
[]
[null,null,"Análisis Q1/2021",null,null,null,null,null,null,"Análisis Q2/2021",null,null,null,null,null,null,"Análisis Q3/2021",null,null,null,null,null,null,"Análisis Q4/2021"]
[null,null,"Template mensual",null,null,"Temp. trim.",null,null,null,"Template mensual",null,null,"Temp. trim.",null,null,null,"Template mensual",null,null,"Temp. trim.",null,null,null,"Template mensual",null,null,"Temp. trim."]
[null,"Procesos 2021","Ene","Feb","Mar","Q1/2021",null,"Inconsistencia?\nCoso sí, ajustar los datos del mês o trimestre a la esquierda",null,"Abr","May","Jun","Q2/2021",null,"Inconsistencia?\nCoso sí, ajustar los datos del mês o trimestre a la esquierda",null,"Jul","Ago","Sep","Q3/2021",null,"Inconsistencia?\nCoso sí, ajustar los datos del mês o trimestre a la esquierda",null,"Oct","Nov","Dic","Q4/2021",null,"Inconsistencia?\nCoso sí, ajustar los datos del mês o trimestre a la esquierda",null,"Total",null,"vs último mês preenchido","vs promedio YTD","Alerta","Justificación (confirman que los datos señalados como rojo son correctos)"]
[]
[null,"Pedidos confirmados con el proveedor de cooler",12554,null,174,12748,null,{"$f":"IF(F7=\"\",\"\",IF(F7=SUM(C7:E7),\"ok\",IF(F7>SUM(C7:E7),F7-SUM(C7:E7),F7-SUM(C7:E7))))","v":20},null,null,null,null,0,null,{"$f":"IF(M7=\"\",\"\",IF(M7=SUM(J7:L7),\"ok\",IF(M7>SUM(J7:L7),M7-SUM(J7:L7),M7-SUM(J7:L7))))","v":"ok"},null,null,null,null,null,null,{"$f":"IF(T7=\"\",\"\",IF(T7=SUM(Q7:S7),\"ok\",IF(T7>SUM(Q7:S7),T7-SUM(Q7:S7),T7-SUM(Q7:S7))))","v":""},null,null,null,null,null,null,{"$f":"IF(AA7=\"\",\"\",IF(AA7=SUM(X7:Z7),\"ok\",IF(AA7>SUM(X7:Z7),AA7-SUM(X7:Z7),AA7-SUM(X7:Z7))))","v":""},null,{"$f":"IF(SUM(C7:E7,J7:L7,Q7:S7,X7:Z7)=0,\"\",SUM(C7:E7,J7:L7,Q7:S7,X7:Z7))","v":12728}]
[null,"Plan de llegada de los coolers comprados",198,1478,3182,4858,null,{"$f":"IF(F8=\"\",\"\",IF(F8=SUM(C8:E8),\"ok\",IF(F8>SUM(C8:E8),F8-SUM(C8:E8),F8-SUM(C8:E8))))","v":"ok"},null,2620,2999,1346,6965,null,{"$f":"IF(M8=\"\",\"\",IF(M8=SUM(J8:L8),\"ok\",IF(M8>SUM(J8:L8),M8-SUM(J8:L8),M8-SUM(J8:L8))))","v":"ok"},null,150,176,null,null,null,{"$f":"IF(T8=\"\",\"\",IF(T8=SUM(Q8:S8),\"ok\",IF(T8>SUM(Q8:S8),T8-SUM(Q8:S8),T8-SUM(Q8:S8))))","v":""},null,null,null,null,null,null,{"$f":"IF(AA8=\"\",\"\",IF(AA8=SUM(X8:Z8),\"ok\",IF(AA8>SUM(X8:Z8),AA8-SUM(X8:Z8),AA8-SUM(X8:Z8))))","v":""},null,{"$f":"IF(SUM(C8:E8,J8:L8,Q8:S8,X8:Z8)=0,\"\",SUM(C8:E8,J8:L8,Q8:S8,X8:Z8))","v":12149}]
["1.","Total de coolers\n(mercado + mantenimiento + descarte+ otros)\"",null,null,111488,111488,null,{"$f":"IF(F9=\"\",\"\",IF(F9=E9,\"ok\",IF(F9>E9,F9-E9,F9-E9)))","v":"ok"},null,112755,113713,109369,109369,null,{"$f":"IF(M9=\"\",\"\",IF(M9=L9,\"ok\",IF(M9>L9,M9-L9,M9-L9)))","v":"ok"},null,null,null,null,null,null,{"$f":"IF(T9=\"\",\"\",IF(T9=S9,\"ok\",IF(T9>S9,T9-S9,T9-S9)))","v":""},null,null,null,null,null,null,{"$f":"IF(AA9=\"\",\"\",IF(AA9=Z9,\"ok\",IF(AA9>Z9,AA9-Z9,AA9-Z9)))","v":""},null,null,null,{"$f":"IFERROR(K9/E9-1,\"\")","v":1.9957304822043609E-2},null,{"$f":"ABS(AG9)","v":1.9957304822043609E-2}]
["2.","Total de coolers en el mercado ",null,null,104510,104510,null,{"$f":"IF(F10=\"\",\"\",IF(F10=E10,\"ok\",IF(F10>E10,F10-E10,F10-E10)))","v":"ok"},null,105016,105390,101275,101275,null,{"$f":"IF(M10=\"\",\"\",IF(M10=L10,\"ok\",IF(M10>L10,M10-L10,M10-L10)))","v":"ok"},null,null,null,null,null,null,{"$f":"IF(T10=\"\",\"\",IF(T10=S10,\"ok\",IF(T10>S10,T10-S10,T10-S10)))","v":""},null,null,null,null,null,null,{"$f":"IF(AA10=\"\",\"\",IF(AA10=Z10,\"ok\",IF(AA10>Z10,AA10-Z10,AA10-Z10)))","v":""},null,null,null,{"$f":"IFERROR(K10/E10-1,\"\")","v":8.4202468663285845E-3},null,{"$f":"ABS(AG10)","v":8.4202468663285845E-3}]
["3.","Llegadas confirmadas de los coolers al bottler"," 175",281,1532,1813,null,{"$f":"IF(F11=\"\",\"\",IF(F11=SUM(C11:E11),\"ok\",IF(F11>SUM(C11:E11),F11-SUM(C11:E11),F11-SUM(C11:E11))))","v":"ok"},null,1267,633,4287,6187,null,{"$f":"IF(M11=\"\",\"\",IF(M11=SUM(J11:L11),\"ok\",IF(M11>SUM(J11:L11),M11-SUM(J11:L11),M11-SUM(J11:L11))))","v":"ok"},null,null,null,null,null,null,{"$f":"IF(T11=\"\",\"\",IF(T11=SUM(Q11:S11),\"ok\",IF(T11>SUM(Q11:S11),T11-SUM(Q11:S11),T11-SUM(Q11:S11))))","v":""},null,null,null,null,null,null,{"$f":"IF(AA11=\"\",\"\",IF(AA11=SUM(X11:Z11),\"ok\",IF(AA11>SUM(X11:Z11),AA11-SUM(X11:Z11),AA11-SUM(X11:Z11))))","v":""},null,{"$f":"IF(SUM(C11:E11,J11:L11,Q11:S11,X11:Z11)=0,\"\",SUM(C11:E11,J11:L11,Q11:S11,X11:Z11))","v":8000},null,null,{"$f":"SUM(C11:K11)/SUM(C8:K8)-1","v":-0.63964786436256926},{"$f":"ABS(AH11)","v":0.63964786436256926}]
["4.","Instalación equipos total \n(1ª instalación + equipo adicional +  *cambio de equipos + eventos + otros)"," 630",744,1595,2177,null,{"$f":"IF(F12=\"\",\"\",IF(F12=SUM(C12:E12),\"ok\",IF(F12>SUM(C12:E12),F12-SUM(C12:E12),F12-SUM(C12:E12))))","v":-162},null,1712,1273,351,3336,null,{"$f":"IF(M12=\"\",\"\",IF(M12=SUM(J12:L12),\"ok\",IF(M12>SUM(J12:L12),M12-SUM(J12:L12),M12-SUM(J12:L12))))","v":"ok"},null,null,null,null,null,null,{"$f":"IF(T12=\"\",\"\",IF(T12=SUM(Q12:S12),\"ok\",IF(T12>SUM(Q12:S12),T12-SUM(Q12:S12),T12-SUM(Q12:S12))))","v":""},null,null,null,null,null,null,{"$f":"IF(AA12=\"\",\"\",IF(AA12=SUM(X12:Z12),\"ok\",IF(AA12>SUM(X12:Z12),AA12-SUM(X12:Z12),AA12-SUM(X12:Z12))))","v":""},null,{"$f":"IF(SUM(C12:E12,J12:L12,Q12:S12,X12:Z12)=0,\"\",SUM(C12:E12,J12:L12,Q12:S12,X12:Z12))","v":5675},null,{"$f":"IFERROR(K12/J12-1,\"\")","v":-0.25642523364485981},{"$f":"IFERROR(K12/AVERAGE(C12:Z12)-1,\"\")","v":-7.6364955559586445E-2},{"$f":"(ABS(AG12)+ABS(AH12))/2","v":0.16639509460222313}]
["5.","Retiro total de equipos del mercado\n(Baja performance + venta cero + cliente cerrado, cerrando o con cooler proprio +  contaminación + *cambio de equipos + eventos + otros)"," 374",387,924,766,null,{"$f":"IF(F13=\"\",\"\",IF(F13=SUM(C13:E13),\"ok\",IF(F13>SUM(C13:E13),F13-SUM(C13:E13),F13-SUM(C13:E13))))","v":-545},null,1224,901,2052,2052,null,{"$f":"IF(M13=\"\",\"\",IF(M13=SUM(J13:L13),\"ok\",IF(M13>SUM(J13:L13),M13-SUM(J13:L13),M13-SUM(J13:L13))))","v":-2125},null,null,null,null,null,null,{"$f":"IF(T13=\"\",\"\",IF(T13=SUM(Q13:S13),\"ok\",IF(T13>SUM(Q13:S13),T13-SUM(Q13:S13),T13-SUM(Q13:S13))))","v":""},null,null,null,null,null,null,{"$f":"IF(AA13=\"\",\"\",IF(AA13=SUM(X13:Z13),\"ok\",IF(AA13>SUM(X13:Z13),AA13-SUM(X13:Z13),AA13-SUM(X13:Z13))))","v":""},null,{"$f":"IF(SUM(C13:E13,J13:L13,Q13:S13,X13:Z13)=0,\"\",SUM(C13:E13,J13:L13,Q13:S13,X13:Z13))","v":5488},null,{"$f":"IFERROR(K13/J13-1,\"\")","v":-0.26388888888888884},{"$f":"IFERROR(K13/AVERAGE(C13:Z13)-1,\"\")","v":0.43878637331440751},{"$f":"(ABS(AG13)+ABS(AH13))/2","v":0.35133763110164817}]
["6.","Nº de coolers en el mercado con venta cero de 30 días o más","5.471 ",6276,12172,12172,null,{"$f":"IF(F14=\"\",\"\",IF(F14=E14,\"ok\",IF(F14>E14,F14-E14,F14-E14)))","v":"ok"},null,12043,13084,12607,12607,null,{"$f":"IF(M14=\"\",\"\",IF(M14=L14,\"ok\",IF(M14>L14,M14-L14,M14-L14)))","v":"ok"},null,null,null,null,null,null,{"$f":"IF(T14=\"\",\"\",IF(T14=S14,\"ok\",IF(T14>S14,T14-S14,T14-S14)))","v":""},null,null,null,null,null,null,{"$f":"IF(AA14=\"\",\"\",IF(AA14=Z14,\"ok\",IF(AA14>Z14,AA14-Z14,AA14-Z14)))","v":""},null,null,null,{"$f":"IFERROR(K14/J14-1,\"\")","v":8.6440255750228401E-2},{"$f":"IFERROR(K14/AVERAGE(C14:Z14)-1,\"\")","v":0.13126073047516695},{"$f":"(ABS(AG14)+ABS(AH14))/2","v":0.10885049311269768}]
["7.","Nº de EDFs con conectividad y con información actualizada en los últimos 30 días",223,144,110,110,null,{"$f":"IF(F15=\"\",\"\",IF(F15=E15,\"ok\",IF(F15>E15,F15-E15,F15-E15)))","v":"ok"},null,149,260,95,95,null,{"$f":"IF(M15=\"\",\"\",IF(M15=L15,\"ok\",IF(M15>L15,M15-L15,M15-L15)))","v":"ok"},null,null,null,null,null,null,{"$f":"IF(T15=\"\",\"\",IF(T15=S15,\"ok\",IF(T15>S15,T15-S15,T15-S15)))","v":""},null,null,null,null,null,null,{"$f":"IF(AA15=\"\",\"\",IF(AA15=Z15,\"ok\",IF(AA15>Z15,AA15-Z15,AA15-Z15)))","v":""},null,null,null,{"$f":"IFERROR(K15/J15-1,\"\")","v":0.74496644295302006},{"$f":"IFERROR(K15/AVERAGE(C15:Z15)-1,\"\")","v":0.75379426644182135},{"$f":"(ABS(AG15)+ABS(AH15))/2","v":0.7493803546974207}]
["8.","Nº de EDFs descartados en el mes",756,0,307,1063,null,{"$f":"IF(F16=\"\",\"\",IF(F16=SUM(C16:E16),\"ok\",IF(F16>SUM(C16:E16),F16-SUM(C16:E16),F16-SUM(C16:E16))))","v":"ok"},null,0,0,952,952,null,{"$f":"IF(M16=\"\",\"\",IF(M16=SUM(J16:L16),\"ok\",IF(M16>SUM(J16:L16),M16-SUM(J16:L16),M16-SUM(J16:L16))))","v":"ok"},null,null,null,null,null,null,{"$f":"IF(T16=\"\",\"\",IF(T16=SUM(Q16:S16),\"ok\",IF(T16>SUM(Q16:S16),T16-SUM(Q16:S16),T16-SUM(Q16:S16))))","v":""},null,null,null,null,null,null,{"$f":"IF(AA16=\"\",\"\",IF(AA16=SUM(X16:Z16),\"ok\",IF(AA16>SUM(X16:Z16),AA16-SUM(X16:Z16),AA16-SUM(X16:Z16))))","v":""},null,{"$f":"IF(SUM(C16:E16,J16:L16,Q16:S16,X16:Z16)=0,\"\",SUM(C16:E16,J16:L16,Q16:S16,X16:Z16))","v":2015},null,{"$f":"IFERROR(K16/J16-1,\"\")","v":""},{"$f":"IFERROR(K16/AVERAGE(C16:Z16)-1,\"\")","v":-1},{"$f":"(ABS(AG16)+ABS(AH16))/2","v":{"$error":"#VALUE!"}}]
[]
["IMPORTANTE"]
["* Cambio de equipos son cambios comerciales (upsize, downsize de puertas o similares) y cambios técnicos (necesidad diagnosticada por el técnico)"]
[". Cambio de equipos contabilizan tanto en retiro como en instalación porque el cambio de un equipo prevé su retiro para la instalación de otro en su lugar."]
[]
[null,"Leyenda:"]
[null,"Solo solicitaremos esta información una vez al año (planeado)"]
[null,"Complete los datos mes a mes (realizado)"]

{"sheet":"Comparativo","index":5,"n_rows":24,"n_cols":36,"rows_kept":24,"cut":false,"hidden":true,"merged":[[3,2,3,4],[3,9,3,11],[3,16,3,18],[3,23,3,25],[3,32,3,34],[0,2,0,3],[0,5,0,28],[2,2,2,7],[2,9,2,14],[2,16,2,21],[2,23,2,28]]}
[null,null,"Llenar inconsist. \ny mes actual:",null,{"$f":"Original!período_selecionado","v":"Jan"},"Informaciones mensuales"]
[]
[null,null,"Análisis Q1/2021",null,null,null,null,null,null,"Análisis Q2/2021",null,null,null,null,null,null,"Análisis Q3/2021",null,null,null,null,null,null,"Análisis Q4/2021"]
[null,null,"Template mensual",null,null,"Temp. trim.",null,null,null,"Template mensual",null,null,"Temp. trim.",null,null,null,"Template mensual",null,null,"Temp. trim.",null,null,null,"Template mensual",null,null,"Temp. trim."]
[null,"Procesos 2021","Ene","Feb","Mar","Q1/2021",null,"Inconsistencia?\nCoso sí, ajustar los datos del mês o trimestre a la esquierda",null,"Abr","May","Jun","Q2/2021",null,"Inconsistencia?\nCoso sí, ajustar los datos del mês o trimestre a la esquierda",null,"Jul","Ago","Sep","Q3/2021",null,"Inconsistencia?\nCoso sí, ajustar los datos del mês o trimestre a la esquierda",null,"Oct","Nov","Dic","Q4/2021",null,"Inconsistencia?\nCoso sí, ajustar los datos del mês o trimestre a la esquierda",null,"Total",null,"vs último mês preenchido","vs promedio YTD","Alerta","Justificación (confirman que los datos señalados como rojo son correctos)"]
[]
[null,"Pedidos confirmados con el proveedor de cooler",{"$f":"'Informaciones mensuais'!C7=Original!C7","v":false},{"$f":"'Informaciones mensuais'!D7=Original!D7","v":true},{"$f":"'Informaciones mensuais'!E7=Original!E7","v":false},{"$f":"'Informaciones mensuais'!F7=Original!F7","v":false},null,null,null,{"$f":"'Informaciones mensuais'!J7=Original!J7","v":true},{"$f":"'Informaciones mensuais'!K7=Original!K7","v":true},{"$f":"'Informaciones mensuais'!L7=Original!L7","v":true},{"$f":"'Informaciones mensuais'!M7=Original!M7","v":true},null,null,null,{"$f":"'Informaciones mensuais'!Q7=Original!Q7","v":true},{"$f":"'Informaciones mensuais'!R7=Original!R7","v":true},{"$f":"'Informaciones mensuais'!S7=Original!S7","v":true},{"$f":"'Informaciones mensuais'!T7=Original!T7","v":true},null,null,null,{"$f":"'Informaciones mensuais'!X7=Original!X7","v":true},{"$f":"'Informaciones mensuais'!Y7=Original!Y7","v":true},{"$f":"'Informaciones mensuais'!Z7=Original!Z7","v":true},{"$f":"'Informaciones mensuais'!AA7=Original!AA7","v":true},null,null,null,{"$f":"IF(SUM(C7:E7,J7:L7,Q7:S7,X7:Z7)=0,\"\",SUM(C7:E7,J7:L7,Q7:S7,X7:Z7))","v":""}]
[null,"Plan de llegada de los coolers comprados",{"$f":"'Informaciones mensuais'!C8=Original!C8","v":false},{"$f":"'Informaciones mensuais'!D8=Original!D8","v":false},{"$f":"'Informaciones mensuais'!E8=Original!E8","v":false},{"$f":"'Informaciones mensuais'!F8=Original!F8","v":false},null,null,null,{"$f":"'Informaciones mensuais'!J8=Original!J8","v":false},{"$f":"'Informaciones mensuais'!K8=Original!K8","v":false},{"$f":"'Informaciones mensuais'!L8=Original!L8","v":false},{"$f":"'Informaciones mensuais'!M8=Original!M8","v":false},null,null,null,{"$f":"'Informaciones mensuais'!Q8=Original!Q8","v":false},{"$f":"'Informaciones mensuais'!R8=Original!R8","v":false},{"$f":"'Informaciones mensuais'!S8=Original!S8","v":true},{"$f":"'Informaciones mensuais'!T8=Original!T8","v":true},null,null,null,{"$f":"'Informaciones mensuais'!X8=Original!X8","v":true},{"$f":"'Informaciones mensuais'!Y8=Original!Y8","v":true},{"$f":"'Informaciones mensuais'!Z8=Original!Z8","v":true},{"$f":"'Informaciones mensuais'!AA8=Original!AA8","v":true},null,null,null,{"$f":"IF(SUM(C8:E8,J8:L8,Q8:S8,X8:Z8)=0,\"\",SUM(C8:E8,J8:L8,Q8:S8,X8:Z8))","v":""}]
["1.","Total de coolers\n(mercado + mantenimiento + descarte+ otros)\"",{"$f":"'Informaciones mensuais'!C9=Original!C9","v":true},{"$f":"'Informaciones mensuais'!D9=Original!D9","v":true},{"$f":"'Informaciones mensuais'!E9=Original!E9","v":false},{"$f":"'Informaciones mensuais'!F9=Original!F9","v":false},null,null,null,{"$f":"'Informaciones mensuais'!J9=Original!J9","v":false},{"$f":"'Informaciones mensuais'!K9=Original!K9","v":false},{"$f":"'Informaciones mensuais'!L9=Original!L9","v":false},{"$f":"'Informaciones mensuais'!M9=Original!M9","v":false},null,null,null,{"$f":"'Informaciones mensuais'!Q9=Original!Q9","v":true},{"$f":"'Informaciones mensuais'!R9=Original!R9","v":true},{"$f":"'Informaciones mensuais'!S9=Original!S9","v":true},{"$f":"'Informaciones mensuais'!T9=Original!T9","v":true},null,null,null,{"$f":"'Informaciones mensuais'!X9=Original!X9","v":true},{"$f":"'Informaciones mensuais'!Y9=Original!Y9","v":true},{"$f":"'Informaciones mensuais'!Z9=Original!Z9","v":true},{"$f":"'Informaciones mensuais'!AA9=Original!AA9","v":true},null,null,null,null,null,{"$f":"IFERROR(K9/E9-1,\"\")","v":""},null,{"$f":"ABS(AG9)","v":{"$error":"#VALUE!"}}]
["2.","Total de coolers en el mercado ",{"$f":"'Informaciones mensuais'!C10=Original!C10","v":true},{"$f":"'Informaciones mensuais'!D10=Original!D10","v":true},{"$f":"'Informaciones mensuais'!E10=Original!E10","v":false},{"$f":"'Informaciones mensuais'!F10=Original!F10","v":false},null,null,null,{"$f":"'Informaciones mensuais'!J10=Original!J10","v":false},{"$f":"'Informaciones mensuais'!K10=Original!K10","v":false},{"$f":"'Informaciones mensuais'!L10=Original!L10","v":false},{"$f":"'Informaciones mensuais'!M10=Original!M10","v":false},null,null,null,{"$f":"#REF!=Original!Q10","v":{"$error":"#REF!"}},{"$f":"'Informaciones mensuais'!Q10=Original!R10","v":true},{"$f":"'Informaciones mensuais'!S10=Original!S10","v":true},{"$f":"'Informaciones mensuais'!T10=Original!T10","v":true},null,null,null,{"$f":"'Informaciones mensuais'!X10=Original!X10","v":true},{"$f":"'Informaciones mensuais'!Y10=Original!Y10","v":true},{"$f":"'Informaciones mensuais'!Z10=Original!Z10","v":true},{"$f":"'Informaciones mensuais'!AA10=Original!AA10","v":true},null,null,null,null,null,{"$f":"IFERROR(K10/E10-1,\"\")","v":""},null,{"$f":"ABS(AG10)","v":{"$error":"#VALUE!"}}]
["3.","Llegadas confirmadas de los coolers al bottler",{"$f":"'Informaciones mensuais'!C11=Original!C11","v":false},{"$f":"'Informaciones mensuais'!D11=Original!D11","v":false},{"$f":"'Informaciones mensuais'!E11=Original!E11","v":false},{"$f":"'Informaciones mensuais'!F11=Original!F11","v":false},null,null,null,{"$f":"'Informaciones mensuais'!J11=Original!J11","v":false},{"$f":"'Informaciones mensuais'!K11=Original!K11","v":false},{"$f":"'Informaciones mensuais'!L11=Original!L11","v":false},{"$f":"'Informaciones mensuais'!M11=Original!M11","v":false},null,null,null,{"$f":"'Informaciones mensuais'!Q11=Original!Q11","v":true},{"$f":"'Informaciones mensuais'!R10=Original!R11","v":true},{"$f":"'Informaciones mensuais'!S11=Original!S11","v":true},{"$f":"'Informaciones mensuais'!T11=Original!T11","v":true},null,null,null,{"$f":"'Informaciones mensuais'!X11=Original!X11","v":true},{"$f":"'Informaciones mensuais'!Y11=Original!Y11","v":true},{"$f":"'Informaciones mensuais'!Z11=Original!Z11","v":true},{"$f":"'Informaciones mensuais'!AA11=Original!AA11","v":true},null,null,null,{"$f":"IF(SUM(C11:E11,J11:L11,Q11:S11,X11:Z11)=0,\"\",SUM(C11:E11,J11:L11,Q11:S11,X11:Z11))","v":""},null,null,{"$f":"SUM(C11:K11)/SUM(C8:K8)-1","v":{"$error":"#DIV/0!"}},{"$f":"ABS(AH11)","v":{"$error":"#DIV/0!"}}]
["4.","Instalación equipos total \n(1ª instalación + equipo adicional +  *cambio de equipos + eventos + otros)",{"$f":"'Informaciones mensuais'!C12=Original!C12","v":false},{"$f":"'Informaciones mensuais'!D12=Original!D12","v":false},{"$f":"'Informaciones mensuais'!E12=Original!E12","v":false},{"$f":"'Informaciones mensuais'!F12=Original!F12","v":false},null,null,null,{"$f":"'Informaciones mensuais'!J12=Original!J12","v":false},{"$f":"'Informaciones mensuais'!K12=Original!K12","v":false},{"$f":"'Informaciones mensuais'!L12=Original!L12","v":false},{"$f":"'Informaciones mensuais'!M12=Original!M12","v":false},null,null,null,{"$f":"'Informaciones mensuais'!Q12=Original!Q12","v":true},{"$f":"'Informaciones mensuais'!R12=Original!R12","v":true},{"$f":"'Informaciones mensuais'!S12=Original!S12","v":true},{"$f":"'Informaciones mensuais'!T12=Original!T12","v":true},null,null,null,{"$f":"'Informaciones mensuais'!X12=Original!X12","v":true},{"$f":"'Informaciones mensuais'!Y12=Original!Y12","v":true},{"$f":"'Informaciones mensuais'!Z12=Original!Z12","v":true},{"$f":"'Informaciones mensuais'!AA12=Original!AA12","v":true},null,null,null,{"$f":"IF(SUM(C12:E12,J12:L12,Q12:S12,X12:Z12)=0,\"\",SUM(C12:E12,J12:L12,Q12:S12,X12:Z12))","v":""},null,{"$f":"IFERROR(K12/J12-1,\"\")","v":""},{"$f":"IFERROR(K12/AVERAGE(C12:Z12)-1,\"\")","v":""},{"$f":"(ABS(AG12)+ABS(AH12))/2","v":{"$error":"#VALUE!"}}]
["5.","Retiro total de equipos del mercado\n(Baja performance + venta cero + cliente cerrado, cerrando o con cooler proprio +  contaminación + *cambio de equipos + eventos + otros)",{"$f":"'Informaciones mensuais'!C13=Original!C13","v":false},{"$f":"'Informaciones mensuais'!D13=Original!D13","v":false},{"$f":"'Informaciones mensuais'!E13=Original!E13","v":false},{"$f":"'Informaciones mensuais'!F13=Original!F13","v":false},null,null,null,{"$f":"'Informaciones mensuais'!J13=Original!J13","v":false},{"$f":"'Informaciones mensuais'!K13=Original!K13","v":false},{"$f":"'Informaciones mensuais'!L13=Original!L13","v":false},{"$f":"'Informaciones mensuais'!M13=Original!M13","v":false},null,null,null,{"$f":"'Informaciones mensuais'!Q13=Original!Q13","v":true},{"$f":"'Informaciones mensuais'!R13=Original!R13","v":true},{"$f":"'Informaciones mensuais'!S13=Original!S13","v":true},{"$f":"'Informaciones mensuais'!T13=Original!T13","v":true},null,null,null,{"$f":"'Informaciones mensuais'!X13=Original!X13","v":true},{"$f":"'Informaciones mensuais'!Y13=Original!Y13","v":true},{"$f":"'Informaciones mensuais'!Z13=Original!Z13","v":true},{"$f":"'Informaciones mensuais'!AA13=Original!AA13","v":true},null,null,null,{"$f":"IF(SUM(C13:E13,J13:L13,Q13:S13,X13:Z13)=0,\"\",SUM(C13:E13,J13:L13,Q13:S13,X13:Z13))","v":""},null,{"$f":"IFERROR(K13/J13-1,\"\")","v":""},{"$f":"IFERROR(K13/AVERAGE(C13:Z13)-1,\"\")","v":""},{"$f":"(ABS(AG13)+ABS(AH13))/2","v":{"$error":"#VALUE!"}}]
["6.","Nº de coolers en el mercado con venta cero de 30 días o más",{"$f":"'Informaciones mensuais'!C14=Original!C14","v":false},{"$f":"'Informaciones mensuais'!D14=Original!D14","v":false},{"$f":"'Informaciones mensuais'!E14=Original!E14","v":false},{"$f":"'Informaciones mensuais'!F14=Original!F14","v":false},null,null,null,{"$f":"'Informaciones mensuais'!J14=Original!J14","v":false},{"$f":"'Informaciones mensuais'!K14=Original!K14","v":false},{"$f":"'Informaciones mensuais'!L14=Original!L14","v":false},{"$f":"'Informaciones mensuais'!M14=Original!M14","v":false},null,null,null,{"$f":"'Informaciones mensuais'!Q14=Original!Q14","v":true},{"$f":"'Informaciones mensuais'!R14=Original!R14","v":true},{"$f":"'Informaciones mensuais'!S14=Original!S14","v":true},{"$f":"'Informaciones mensuais'!T14=Original!T14","v":true},null,null,null,{"$f":"'Informaciones mensuais'!X14=Original!X14","v":true},{"$f":"'Informaciones mensuais'!Y14=Original!Y14","v":true},{"$f":"'Informaciones mensuais'!Z14=Original!Z14","v":true},{"$f":"'Informaciones mensuais'!AA14=Original!AA14","v":true},null,null,null,null,null,{"$f":"IFERROR(K14/J14-1,\"\")","v":""},{"$f":"IFERROR(K14/AVERAGE(C14:Z14)-1,\"\")","v":""},{"$f":"(ABS(AG14)+ABS(AH14))/2","v":{"$error":"#VALUE!"}}]
["7.","Nº de EDFs con conectividad y con información actualizada en los últimos 30 días",{"$f":"'Informaciones mensuais'!C15=Original!C15","v":false},{"$f":"'Informaciones mensuais'!D15=Original!D15","v":false},{"$f":"'Informaciones mensuais'!E15=Original!E15","v":false},{"$f":"'Informaciones mensuais'!F15=Original!F15","v":false},null,null,null,{"$f":"'Informaciones mensuais'!J15=Original!J15","v":false},{"$f":"'Informaciones mensuais'!K15=Original!K15","v":false},{"$f":"'Informaciones mensuais'!L15=Original!L15","v":false},{"$f":"'Informaciones mensuais'!M15=Original!M15","v":false},null,null,null,{"$f":"'Informaciones mensuais'!Q15=Original!Q15","v":true},{"$f":"'Informaciones mensuais'!R15=Original!R15","v":true},{"$f":"'Informaciones mensuais'!S15=Original!S15","v":true},{"$f":"'Informaciones mensuais'!T15=Original!T15","v":true},null,null,null,{"$f":"'Informaciones mensuais'!X15=Original!X15","v":true},{"$f":"'Informaciones mensuais'!Y15=Original!Y15","v":true},{"$f":"'Informaciones mensuais'!Z15=Original!Z15","v":true},{"$f":"'Informaciones mensuais'!AA15=Original!AA15","v":true},null,null,null,null,null,{"$f":"IFERROR(K15/J15-1,\"\")","v":""},{"$f":"IFERROR(K15/AVERAGE(C15:Z15)-1,\"\")","v":""},{"$f":"(ABS(AG15)+ABS(AH15))/2","v":{"$error":"#VALUE!"}}]
["8.","Nº de EDFs descartados en el mes",{"$f":"#REF!=Original!C16","v":{"$error":"#REF!"}},{"$f":"#REF!=Original!D16","v":{"$error":"#REF!"}},{"$f":"#REF!=Original!E16","v":{"$error":"#REF!"}},{"$f":"#REF!=Original!F16","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!=Original!J16","v":{"$error":"#REF!"}},{"$f":"#REF!=Original!K16","v":{"$error":"#REF!"}},{"$f":"#REF!=Original!L16","v":{"$error":"#REF!"}},{"$f":"#REF!=Original!M16","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!=Original!Q16","v":{"$error":"#REF!"}},{"$f":"#REF!=Original!R16","v":{"$error":"#REF!"}},{"$f":"#REF!=Original!S16","v":{"$error":"#REF!"}},{"$f":"#REF!=Original!T16","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!=Original!X16","v":{"$error":"#REF!"}},{"$f":"#REF!=Original!Y16","v":{"$error":"#REF!"}},{"$f":"#REF!=Original!Z16","v":{"$error":"#REF!"}},{"$f":"#REF!=Original!AA16","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(SUM(C16:E16,J16:L16,Q16:S16,X16:Z16)=0,\"\",SUM(C16:E16,J16:L16,Q16:S16,X16:Z16))","v":{"$error":"#REF!"}},null,{"$f":"IFERROR(K16/J16-1,\"\")","v":""},{"$f":"IFERROR(K16/AVERAGE(C16:Z16)-1,\"\")","v":""},{"$f":"(ABS(AG16)+ABS(AH16))/2","v":{"$error":"#VALUE!"}}]
[]
["IMPORTANTE"]
["* Cambio de equipos son cambios comerciales (upsize, downsize de puertas o similares) y cambios técnicos (necesidad diagnosticada por el técnico)"]
[". Cambio de equipos contabilizan tanto en retiro como en instalación porque el cambio de un equipo prevé su retiro para la instalación de otro en su lugar."]
[]
[null,"Leyenda:"]
[null,"Solo solicitaremos esta información una vez al año (planeado)"]
[null,"Complete los datos mes a mes (realizado)"]

{"sheet":"Aux","index":6,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["-"]
["Jan"]
["Fev"]
["Mar"]
["Abr"]
["Mai"]
["Jun"]
["Jul"]
["Ago"]
["Set"]
["Out"]
["Nov"]
["Dez"]

{"sheet":"Ejemplo","index":7,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,"Ejemplo"]
[]
[]
[null,null,null,null,"Procesos 2021","Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic","Total"]
[null,null,null,null,null,{"$f":"IF(R10=\"\",\"\",IF(R10<>R9,\"Rever plan de llegada de equipos\",\"\"))","v":""}]
[null,null,null,null,"Pedidos confirmados con el proveedor de EDF",10000,10000,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F9:Q9)=0,\"\",SUM(F9:Q9))","v":20000}]
[null,null,null,null,"Plan de llegada de los EDFs comprados",5000,null,5000,null,null,5000,null,null,null,5000,null,null,20000]
[null,null,null,"1.","Llegadas confirmadas de los EDFs al bottler",4500,null,null,null,null,null,null,null,null,null,null,null,4500]
[null,null,null,"2.","Instalación equipos total \n(1ª instalación + equipo adicional +  *cambio de equipos + eventos + otros)",3000,null,null,null,null,null,null,null,null,null,null,null,3000]
[null,null,null,"3.","Retiro total de equipos del mercado\n(Baja performance + venta cero + cliente cerrado, cerrando o con EDF proprio +  contaminación + *cambio de equipos + eventos + otros)",1000,null,null,null,null,null,null,null,null,null,null,null,1000]
[null,null,null,"4.","Nº de EDFs en el mercado con venta cero de 30 días o más",500,null,null,null,null,null,null,null,null,null,null,null,500]
[null,null,null,"5.","Total de EDFs monitoreados regularmente por conectividad",100,null,null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,"6.","Bajas de EDFs totales\n(pérdidas + descarte + otros)",100,null,null,null,null,null,null,null,null,null,null,null,100]
[]
[null,null,null,"IMPORTANTE"]
[null,null,null,"* Cambio de equipos son cambios comerciales (upsize, downsize de puertas o similares) y cambios técnicos (necesidad diagnosticada por el técnico)"]
[null,null,null,". Cambio de equipos contabilizan tanto en retiro como en instalación porque el cambio de un equipo prevé su retiro para la instalación de otro en su lugar."]
[]
[null,null,null,null,"Leyenda:"]
[null,null,null,null,"Solo solicitaremos esta información una vez al año (planeado)"]
[null,null,null,null,"Complete los datos mes a mes (realizado)"]
[]
[]
[null,null,2021]