{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Pantalla inicial","Financiera","Cliente","Proceso","Aprend","Cli_exist","Hosteleria","Serigrafia","Web","Impagados","Satisfaccion","Convenios","Stock"],"not_rendered":{"charts":15,"images":11,"macros":1,"external_links":0,"defined_names":11,"comments":3,"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":"Pantalla inicial","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Financiera","index":1,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Estrategia crecimiento de ingresos",null,null,null,null,null,"Responsable"]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Ventas clientes existentes",{"$f":"Cli_exist!C25","v":0},{"$f":"C15","v":0},{"$f":"C14-D14","v":0},{"$f":"(C14-D14)/D14","v":{"$error":"#DIV/0!"}},{"$f":"C14","v":0}]
[null,"Ventas  periodo anterior",{"$f":"Cli_exist!D25","v":0},{"$f":"C15","v":0},{"$f":"C15-D15","v":0},{"$f":"(C15-D15)/D15","v":{"$error":"#DIV/0!"}},{"$f":"C15","v":0}]
[null,"Diferencia periodo actual-anterior",{"$f":"C14-C15","v":0},0,{"$f":"E14-E15","v":0},{"$f":"(C16-D16)/D16","v":{"$error":"#DIV/0!"}},{"$f":"C16","v":0}]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Ventas hosteleria",{"$f":"Hosteleria!C25","v":0},{"$f":"C20*1.05","v":0},{"$f":"C19-D19","v":0},{"$f":"(C19-D19)/D19","v":{"$error":"#DIV/0!"}},{"$f":"C19","v":0}]
[null,"Ventas periodo anterior",{"$f":"Hosteleria!D25","v":0},0,{"$f":"C20-D20","v":0},{"$f":"(C20-D20)/D20","v":{"$error":"#DIV/0!"}},{"$f":"C20","v":0}]
[null,"Diferencia periodo actual-anterior",{"$f":"C19-C20","v":0},0,{"$f":"E19-E20","v":0},{"$f":"(C21-D21)/D21","v":{"$error":"#DIV/0!"}},{"$f":"C21","v":0}]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Ventas serigrafia",{"$f":"Serigrafia!C25","v":0},{"$f":"C25*1.05","v":0},{"$f":"C24-D24","v":0},{"$f":"(C24-D24)/D24","v":{"$error":"#DIV/0!"}},{"$f":"C24","v":0}]
[null,"Ventas periodo anterior",{"$f":"Serigrafia!D25","v":0},0,{"$f":"C25-D25","v":0},{"$f":"(C25-D25)/D25","v":{"$error":"#DIV/0!"}},{"$f":"C25","v":0}]
[null,"Diferencia periodo actual-anterior",{"$f":"C24-C25","v":0},0,{"$f":"E24-E25","v":0},{"$f":"(C26-D26)/D26","v":{"$error":"#DIV/0!"}},{"$f":"C26","v":0}]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Ventas página web",{"$f":"Web!B4","v":0},{"$f":"C30*1.05","v":0},{"$f":"C29-D29","v":0},{"$f":"(C29-D29)/D29","v":{"$error":"#DIV/0!"}},{"$f":"C29","v":0}]
[null,"Ventas periodo anterior",{"$f":"Web!E4","v":0},0,{"$f":"C30-D30","v":0},{"$f":"(C30-D30)/D30","v":{"$error":"#DIV/0!"}},{"$f":"C30","v":0}]
[null,"Diferencia periodo actual-anterior",{"$f":"C29-C30","v":0},0,{"$f":"E29-E30","v":0},{"$f":"(C31-D31)/D31","v":{"$error":"#DIV/0!"}},{"$f":"C31","v":0}]
[null,"Page Rank",{"$f":"Web!G4","v":0},0,{"$f":"D32-C32","v":0},{"$f":"(C32-D32)/D32","v":{"$error":"#DIV/0!"}},{"$f":"C32","v":0}]
[null,"Nº compras",{"$f":"Web!A4","v":0},{"$f":"C34","v":0},{"$f":"D33-C33","v":0},{"$error":"#DIV/0!"},{"$f":"C33","v":0}]
[null,"Nº compras período anterior",{"$f":"Web!F4","v":0},0,{"$f":"D34-C34","v":0},{"$error":"#DIV/0!"},0]
[]
[]
[]
[]
[null,null,"Estrategia de sostenibilidad",null,null,null,null,null,"Responsable"]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Compras/beneficios netos",0,0,{"$f":"C42-D42","v":0},{"$f":"(C42-D42)/D42","v":{"$error":"#DIV/0!"}},{"$f":"C42","v":0}]
[null,"Compras/beneficios netos ant.",null,null,{"$f":"C43-D43","v":0},{"$f":"(C43-D43)/D43","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Impagados",{"$f":"Impagados!C25","v":0},{"$f":"C47","v":0},{"$f":"C46-D46","v":0},{"$f":"(C46-D46)/D46","v":{"$error":"#DIV/0!"}},{"$f":"C46","v":0}]
[null,"Impagados anteriores",{"$f":"Impagados!D25","v":0},0,{"$f":"C47-D47","v":0},{"$f":"(C47-D47)/D47","v":{"$error":"#DIV/0!"}},{"$f":"C47","v":0}]

{"sheet":"Cliente","index":2,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Satisfacción y fidelidad de los clientes",null,null,null,null,null,"Responsable"]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Grado de satisfaccion",{"$f":"Satisfaccion!K25","v":4.4000000000000004},200000,{"$f":"C14-D14","v":-199995.6},{"$f":"(C14-D14)/D14","v":-0.99997800000000003},{"$f":"C14","v":4.4000000000000004}]
[null,"Satisfaccion anterior",{"$f":"Satisfaccion!M25","v":{"$error":"#DIV/0!"}},145000,{"$f":"C15-D15","v":{"$error":"#DIV/0!"}},{"$f":"(C15-D15)/D15","v":{"$error":"#DIV/0!"}},{"$f":"C15","v":{"$error":"#DIV/0!"}}]
[null,"Diferencia periodo actual-anterior",{"$f":"C15-C14","v":{"$error":"#DIV/0!"}},{"$f":"D14-D15","v":55000},{"$f":"C16-D16","v":{"$error":"#DIV/0!"}},{"$f":"(C16-D16)/D16","v":{"$error":"#DIV/0!"}},{"$f":"C16","v":{"$error":"#DIV/0!"}}]
[null,"Grado de fidelidad",{"$f":"Satisfaccion!L25","v":5.666666666666667},null,{"$f":"C17-D17","v":5.666666666666667},null,{"$f":"C17","v":5.666666666666667}]
[null,"Fidelidad anterior",{"$f":"Satisfaccion!N25","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$f":"C18","v":{"$error":"#DIV/0!"}}]
[null,"Diferencia periodo actual-anterior",{"$f":"C18-C17","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[null,null,"Productos conveniados",null,null,null,null,null,"Responsable"]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Nº porductos conveniados",{"$f":"Convenios!E4","v":0},2500000,{"$f":"C29-D29","v":-2500000},{"$f":"(C29-D29)/D29","v":-1},{"$f":"C29","v":0}]
[null,"Nº convenios anteriores",{"$f":"Convenios!F4","v":0},2300000,{"$f":"C30-D30","v":-2300000},{"$f":"(C30-D30)/D30","v":-1},{"$f":"C30","v":0}]
[null,"Diferencia periodo actual-anterior",{"$f":"C29-C30","v":0},0,{"$f":"C31-D31","v":0},{"$f":"(C31-D31)/D31","v":{"$error":"#DIV/0!"}},{"$f":"C31","v":0}]

{"sheet":"Proceso","index":3,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Proceso de innovación",null,null,null,null,null,"Responsable"]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Roturas de stock",{"$f":"Stock!D4","v":0},0,{"$f":"C14-D14","v":0},{"$f":"(C14-D14)/D14","v":{"$error":"#DIV/0!"}},{"$f":"C14","v":0}]
[null,"Roturas anteriores",{"$f":"Stock!E4","v":0},0,{"$f":"C15-D15","v":0},{"$f":"(C15-D15)/D15","v":{"$error":"#DIV/0!"}},{"$f":"C15","v":0}]
[null,"Diferencia periodo actual-anterior",{"$f":"C15-C14","v":0},0,0,{"$error":"#DIV/0!"},{"$f":"C16","v":0}]
[]
[]
[]
[]
[]
[null,null,"Gestión del cliente",null,null,null,null,null,"Responsable"]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Plazo dias en servir",2,3,{"$f":"C25-D25","v":-1},{"$f":"(C25-D25)/D25","v":-0.33333333333333331},{"$f":"C25","v":2}]
[null,"Plazo anterior",3,4,{"$f":"C26-D26","v":-1},{"$f":"(C26-D26)/D26","v":-0.25},{"$f":"C26","v":3}]
[null,"Diferencia periodo actual-anterior",{"$f":"C26-C25","v":1},3,{"$f":"C27-D27","v":-2},{"$f":"(C27-D27)/D27","v":-0.66666666666666663},{"$f":"C27","v":1}]
[]
[]
[]
[]
[]
[null,null,"Proceso operativo",null,null,null,null,null,"Responsable"]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Errores en pedidos",2,4,{"$f":"C36-D36","v":-2},{"$f":"(C36-D36)/D36","v":-0.5},{"$f":"C36","v":2}]
[]
[]
[]
[]
[]
[null,null,"Servicio post-venta",null,null,null,null,null,"Responsable"]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Devoluciones",2,2,{"$f":"C45-D45","v":0},{"$f":"(C45-D45)/D45","v":0},{"$f":"C45","v":2}]

{"sheet":"Aprend","index":4,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Competencias estratégicas",null,null,null,null,null,"Responsable"]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Pedidos por empleado",0,0,{"$f":"C14-D14","v":0},{"$f":"(C14-D14)/D14","v":{"$error":"#DIV/0!"}},{"$f":"C14","v":0}]
[]
[]
[]
[]
[]
[null,null,"Técnologias estratégicas",null,null,null,null,null,"Responsable"]
[]
[null,null,"Valor","Objetivo","Desviación","Desviación %","Situación de alerta"]
[null,"Satisfacción usuarios del sistema",0,0,{"$f":"C23-D23","v":0},{"$f":"(C23-D23)/D23","v":{"$error":"#DIV/0!"}},{"$f":"C23","v":0}]

{"sheet":"Cli_exist","index":5,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
[]
["Listado ventas clientes existentes"]
["Código","Nombre","Ventas","Ventas anteriores","Margen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",null,{"$f":"SUM(C4:C24)","v":0},{"$f":"SUM(D4:D24)","v":0},{"$f":"AVERAGE(E4:E24)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Hosteleria","index":6,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
[]
["Listado ventas hosteleria"]
["Código","Nombre","Ventas","Ventas anteriores","Margen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",null,{"$f":"SUM(C4:C24)","v":0},{"$f":"SUM(D4:D24)","v":0},{"$f":"AVERAGE(E4:E24)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Serigrafia","index":7,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
[]
["Listado ventas serigrafia"]
["Código","Nombre","Ventas","Ventas anteriores","Margen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",null,{"$f":"SUM(C4:C24)","v":0},{"$f":"SUM(D4:D24)","v":0},{"$f":"AVERAGE(E4:E24)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Web","index":8,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,1,6]]}
[]
["Listado ventas Web"]
["Nº compra","Importe","Margen","Beneficio","Importe anterior","nº comp. Ant","Page rank"]
[null,{"$f":"SUM(B5:B101)","v":0},{"$f":"AVERAGE(C5:C101)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D5:D101)","v":0}]

{"sheet":"Impagados","index":9,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
["Listado de impagados"]
["Código","Nombre","Deuda","Deudas anteriores"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",null,{"$f":"SUM(C4:C24)","v":0},{"$f":"SUM(D4:D24)","v":0}]

{"sheet":"Satisfaccion","index":10,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,0,1,13]]}
[]
["Satisfaccion clientes"]
["Código","Nombre","S1","S2","S3","S4","S5","F1","F2","F3","S","F","S(ant.)","F(ant.)"]
[null,null,1,3,5,6,7,8,9,0,{"$f":"(C4+D4+E4+F4+G4)/5","v":4.4000000000000004},{"$f":"(H4+I4+J4)/3","v":5.666666666666667}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(K4:K24)","v":4.4000000000000004},{"$f":"AVERAGE(L4:L24)","v":5.666666666666667},{"$f":"AVERAGE(M4:M24)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N4:N24)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Convenios","index":11,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
[]
["Artículos conveniados"]
["Código","Descripcion","Cod. Cliente","Nombre","Nº Art. Conve.","Conv. Ant."]
[null,null,null,null,{"$f":"COUNT(A4:A244)","v":0},0]

{"sheet":"Stock","index":12,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
[]
["Roturas stock"]
["Código","Descripcion","Fecha","Nº roturas","Rot. Ant."]
[null,null,null,{"$f":"COUNT(A4:A244)","v":0},0]