{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Úvod","Teorie","RFM . data 1","Data","Data 2","další infrmace"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"Úvod","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,1,28,11],[1,2,1,9],[11,2,12,6],[14,3,15,6],[15,7,15,9]]}
[]
[null,null,"Jak na Excel "]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"RFM"]
[]
[]
[]
[]
[]
[null,null,"Pavel Lasák"]
[]
[]
[null,null,null,"Lektor, expert na Microsoft Excel, držitel prestižního ocenění Microsoftu MVP v České republice"]
[null,null,null,null,null,null,null,5002722]
[]
[]
[]
[null,null,null,"Další informace ke cvičení:"]
[null,null,null,null,"https://office.lasakovi.com/excel/grafy/RFM-segmentace-Excel/"]
[]
[]
[]
[]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2018 rev 2019"]

{"sheet":"Teorie","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]]}
["RFM"]
["http://office.lasakovi.com/"]
[]
[]
[null,"Recency - doba od posledního nákupu"]
[null,"Frequency - počet nákupu za dané období (jak často nakupuje)"]
[null,"Monetary - za kolik za dané období nakoupil (například v Kč)"]

{"sheet":"RFM . data 1","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]]}
["RFM"]
["http://office.lasakovi.com/"]
[]
[]
[null,"Zákazník","Recenty","Frequency","Monetary"]
[null,"Customer 1",4,5,"20 000"]
[null,"Customer 2",14,15,"50 000"]
[null,"Customer 3",30,3,"100 000"]
[null,"Customer 4",45,2,"10 000"]

{"sheet":"Data","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Firma","R","F","M"]
["Firma 1",10,15,20]
["Firma 2",10,15,20]
["Firma 3",10,15,20]
[]
[]
[]
[null,"Recency - doba od posledního nákupu"]
[null,"Frequency - počet nákupu za dané období (jak často nakupuje)"]
[null,"Monetary - za kolik za dané období nakoupil (například v Kč)"]

{"sheet":"Data 2","index":4,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Firma","R","F","M","R","F","M","Score"]
["Firma 1",10,15,20,null,null,null,null,null,null,1,2,3,4,5]
["Firma 2",10,15,20,null,null,null,null,null,"R"]
["Firma 3",10,15,20,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,null,"M"]
[]
[]
[null,null,null,null,null,null,null,null,null,"R",50]
[null,null,null,null,null,null,null,null,null,"F",30]
[null,null,null,null,null,null,null,null,null,"M",20]

{"sheet":"další infrmace","index":5,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]]}
["RFM"]
["http://office.lasakovi.com/"]
[]
[]
[null,"Pro vaše poznámky"]