{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Testo","Foglio1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":57,"comments":1,"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":"Testo","index":0,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://en.wikipedia.org/wiki/K-means_clustering"]

{"sheet":"Foglio1","index":1,"n_rows":32,"n_cols":20,"rows_kept":32,"cut":false,"hidden":false,"merged":[[32,18,34,20],[4,1,4,3],[5,5,5,6],[5,7,5,8],[5,9,5,10],[9,6,9,7],[6,5,6,6],[6,7,6,8],[6,9,6,10],[22,2,26,7]]}
[]
[]
[]
[]
[null,"test data"]
[null,"n","VAR1","VAR2",null,"cluster center 1",null,"cluster center 2",null,"cluster center 3",null,null,"index","dist C1","dist C2","dist C3",null,null,"class","min distance"]
[null,1,4,12,null,"c_1",null,"c_2",null,"c_3",null,null,1]
[null,2,5,10,null,3,10,9,8,5,4,null,2]
[null,3,8,7,null,null,null,null,null,null,null,null,3]
[null,4,5,3,null,null,null,null,null,null,null,null,4]
[null,5,5,4,null,null,null,null,null,null,null,null,5]
[null,6,2,11,null,null,null,null,null,null,null,null,6]
[null,7,5,4,null,null,null,null,null,null,null,null,7]
[null,8,3,8,null,null,null,null,null,null,null,null,8]
[null,9,6,2,null,null,null,null,null,null,null,null,9]
[null,10,7,4,null,null,null,null,null,null,null,null,10]
[null,11,10,8,null,null,null,null,null,null,null,null,11]
[null,12,8,9,null,null,null,null,null,null,null,null,12]
[null,13,10,9,null,null,null,null,null,null,null,null,13]
[null,14,10,12,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T7:T20)","v":0}]
[]
[null,null,"Verificare che i centroidi trovati dal risolutore corrispondano alle medie aritmetiche dei singoli gruppi (utilizzare per la verifica la funzione MEDIA.SE)",null,null,null,null,null,null,null,null,null,"Nella cella T20 si inserisce la funzione obiettivo che si vuole minimizzare"]
[null,null,null,null,null,null,null,null,null,null,null,null,"In questo caso k=3, n=14"]
[null,null,null,null,null,null,null,null,null,null,null,null,"c_1=zona F8:G8"]
[null,null,null,null,null,null,null,null,null,null,null,null,"c_2=zona H8:I8"]
[null,null,null,null,null,null,null,null,null,null,null,null,"c_3=zona J8:K8"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Obiettivo: cercare i 6 numeri da inserire nella zona F8:K8 minimizzano il numero contenuto nella cella obiettivo (T21)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vincolo"]