{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Analisi redditività cliente"],"not_rendered":{"charts":1,"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Analisi redditività cliente","index":0,"n_rows":42,"n_cols":7,"rows_kept":42}
[{"$nulls":6}," "]
[null,"Nome società"]
[null,"Analisi redditività cliente"]
[null," Data di preparazione: [immettere la data]"]
[]
[null,null,"Nome segmento 1","Nome segmento 2","Nome segmento 3","Risultato complessivo"]
[]
[null,"Attività cliente"]
[]
[null,"Numero di clienti attivi - inizio del periodo",5,8,8,{"$f":"SUM(C10:E10)","v":21}]
[null,"Numero di clienti aggiunti",2,4,4,{"$f":"SUM(C11:E11)","v":10}]
[null,"Numero di clienti persi/rapporto terminato",1,2,2,5]
[null,"Numero di clienti attivi - Fine del periodo",{"$f":"C10+C11-C12","v":6},{"$f":"D10+D11-D12","v":10},10,26]
[]
[null,"Analisi redditività"]
[]
[null,"Ricavi per segmento",{"v":1500000,"d":"1,500,000.00 €"},{"v":1800000,"d":"1,800,000.00 €"},{"v":2500000,"d":"2,500,000.00 €"},{"$f":"SUM(C17:E17)","v":{"v":5800000,"d":"5,800,000.00 €"}}]
[null,"Ponderazione",{"$f":"C17/$F$17","v":{"v":0.25862068965517243,"d":"26%"}},{"$f":"D17/$F$17","v":{"v":0.3103448275862069,"d":"31%"}},{"v":0.43103448275862066,"d":"43%"}]
[]
[null,"Costo delle vendite"]
[]
[null,"Costi di servizi e assistenza continuativi",{"v":1000000,"d":"1,000,000.00 €"},{"v":1400000,"d":"1,400,000.00 €"},{"v":1400000,"d":"1,400,000.00 €"},{"$f":"SUM(C22:E22)","v":{"v":3800000,"d":"3,800,000.00 €"}}]
[null,"Costi di altri clienti diretti",{"v":200000,"d":"200,000.00 €"},{"v":100000,"d":"100,000.00 €"},{"v":100000,"d":"100,000.00 €"},{"$f":"SUM(C23:E23)","v":{"v":400000,"d":"400,000.00 €"}}]
[null,"Costo totale del venduto",{"$f":"SUM(C22:C23)","v":{"v":1200000,"d":"1,200,000.00 €"}},{"$f":"SUM(D22:D23)","v":{"v":1500000,"d":"1,500,000.00 €"}},{"$f":"SUM(E22:E23)","v":{"v":1500000,"d":"1,500,000.00 €"}},{"v":4200000,"d":"4,200,000.00 €"}]
[null,"Profitto lordo",{"$f":"C17-C24","v":{"v":300000,"d":"300,000.00 €"}},{"$f":"D17-D24","v":{"v":300000,"d":"300,000.00 €"}},{"$f":"E17-E24","v":{"v":1000000,"d":"1,000,000.00 €"}},{"v":1600000,"d":"1,600,000.00 €"}]
[null,"Ponderazione",{"$f":"C25/$F$25","v":{"v":0.1875,"d":"19%"}},{"$f":"D25/$F$25","v":{"v":0.1875,"d":"19%"}},{"v":0.625,"d":"63%"}]
[]
[null,"Costi di acquisizione"]
[]
[null,"Acquisizione clienti diretti",{"v":105000,"d":"105,000.00 €"},{"v":120000,"d":"120,000.00 €"},{"v":235000,"d":"235,000.00 €"},{"$f":"SUM(C30:E30)","v":{"v":460000,"d":"460,000.00 €"}}]
[null,"Marketing clienti",{"v":150000,"d":"150,000.00 €"},{"v":125000,"d":"125,000.00 €"},{"v":275000,"d":"275,000.00 €"},{"$f":"SUM(C31:E31)","v":{"v":550000,"d":"550,000.00 €"}}]
[null,"Terminazione rapporto clienti",{"v":35000,"d":"35,000.00 €"},{"v":10000,"d":"10,000.00 €"},{"v":140000,"d":"140,000.00 €"},{"v":185000,"d":"185,000.00 €"}]
[null,"Costi di acquisizione totali",{"$f":"SUM(C30:C32)","v":{"v":290000,"d":"290,000.00 €"}},{"$f":"SUM(D30:D32)","v":{"v":255000,"d":"255,000.00 €"}},{"v":650000,"d":"650,000.00 €"},{"v":1195000,"d":"1,195,000.00 €"}]
[null,"Profitto cliente per segmento",{"$f":"C25-C33","v":{"v":10000,"d":"10,000.00 €"}},{"$f":"D25-D33","v":{"v":45000,"d":"45,000.00 €"}},{"v":350000,"d":"350,000.00 €"},{"v":405000,"d":"405,000.00 €"}]
[null,"Ponderazione",{"$f":"C34/$F$34","v":{"v":0.024691358024691357,"d":"2%"}},{"$f":"D34/$F$34","v":{"v":0.1111111111111111,"d":"11%"}},{"v":0.8641975308641975,"d":"86%"}]
[]
[null,"Metriche di riepilogo per segmento"]
[]
[null,"Costo medio per cliente acquisito",{"$f":"C30/C11","v":{"v":52500,"d":"52,500.00 €"}},{"$f":"D30/D11","v":{"v":30000,"d":"30,000.00 €"}},{"$f":"E30/E11","v":{"v":58750,"d":"58,750.00 €"}},{"$f":"F30/F11","v":{"v":46000,"d":"46,000.00 €"}}]
[null,"Costo medio marketing per cliente attivo",{"$f":"C31/C13","v":{"v":25000,"d":"25,000.00 €"}},{"$f":"D31/D13","v":{"v":12500,"d":"12,500.00 €"}},{"$f":"E31/E13","v":{"v":27500,"d":"27,500.00 €"}},{"$f":"F31/F13","v":{"v":21153.846153846152,"d":"21,153.85 €"}}]
[null,"Costo medio per cliente con rapporto terminato",{"$f":"C32/C12","v":{"v":35000,"d":"35,000.00 €"}},{"$f":"D32/D12","v":{"v":5000,"d":"5,000.00 €"}},{"$f":"E32/E12","v":{"v":70000,"d":"70,000.00 €"}},{"$f":"F32/F12","v":{"v":37000,"d":"37,000.00 €"}}]
[null,"Profitto medio (perdite) per cliente",{"$f":"C34/C13","v":{"v":1666.6666666666667,"d":"1,666.67 €"}},{"$f":"D34/D13","v":{"v":4500,"d":"4,500.00 €"}},{"$f":"E34/E13","v":{"v":35000,"d":"35,000.00 €"}},{"$f":"F34/F13","v":{"v":15576.923076923076,"d":"15,576.92 €"}}]