{"text_format":"1","workbook":"xls","n_sheets":2,"sheets":["Rentabilidad de la clientela","Gráfica de métrica resumida"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Gráfica de métrica resumida","index":1,"reason":"not_a_worksheet"}],"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","formulas":"cached_only"}

{"sheet":"Rentabilidad de la clientela","index":0,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"[Nombre de la empresa]"]
[null,"Análisis de rentabilidad de la clientela"]
[null,"[Fecha]"]
[]
[null,"La plantilla calculará los importes en gris."]
[]
[null,null,"[Segmento]","[Segmento]","[Segmento]","Total"]
[null,"Actividad del cliente:"]
[null,"Clientes activos al principio del período",5,8,8,21]
[null,"Clientes añadidos",2,4,4,10]
[null,"Clientes perdidos",-1,-2,-2,-5]
[null,"Clientes activos al principio del período",6,10,10,26]
[]
[null,"Análisis de rentabilidad:"]
[null,"Ingresos por segmento",1500000,1800000,2500000,5800000]
[null,"Bonificación",0.25862068965517243,0.3103448275862069,0.43103448275862066,1]
[]
[null,"Valor de las ventas:"]
[null,"Costes de atención y servicio",1000000,1400000,1400000,3800000]
[null,"Otros costes directos clientes",200000,100000,100000,400000]
[null,"Valor total de las ventas",1200000,1500000,1500000,4200000]
[]
[null,"Margen bruto",300000,300000,1000000,1600000]
[null,"   Bonificación",0.1875,0.1875,0.625,1]
[]
[null,"Otros costes:"]
[null,"Captación de clientes",105000,120000,235000,460000]
[null,"Publicidad",150000,125000,275000,550000]
[null,"Pérdida de clientes",80000,190000,140000,410000]
[null,"Total otros costes clientes",335000,435000,650000,1420000]
[]
[null,"Rentabilidad del cliente por segmentos",-35000,-135000,350000,180000]
[null,"   Bonificación",0,0,1,1]
[]
[null,"Métrica resumida:"]
[null,null,"[Segmento]","[Segmento]","[Segmento]"]
[null,"Coste medio por cliente ganado",52500,30000,58750]
[null,"Coste medio por cliente perdido",80000,95000,70000]
[null,"Coste medio en publicidad por cliente activo",25000,12500,27500]
[null,"Promedio beneficio (o pérdida) por cliente",-5833.333333333333,-13500,35000]