{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["CARTE DI CONTROLLO X VARIABILI","CARTE DI CONTROLLO X ATTRIBUTI"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"CARTE DI CONTROLLO X VARIABILI","index":0,"n_rows":145,"n_cols":15,"rows_kept":145,"cut":false,"hidden":false,"merged":[[64,1,64,5],[92,1,92,5],[120,1,120,5]]}
[]
["CAMPIONI con numerosità unitaria"]
["Caratteristica di qualità: Diametro esterno minimo",{"$nulls":4},"Caratteristica di qualità: Diametro interno",{"$nulls":4},"Caratteristica di qualità: Lunghezza"]
[]
["Campione misurato ","Diametro esterno minimo (mm) ",null,null,null,"Campione misurato ","Diametro interno (mm) ",null,null,null,"Campione misurato ","Lunghezza (mm) "]
[1,15.380699999999999,null,null,null,1,14.1282,null,null,null,1,23.1462]
[2,15.2805,null,null,null,2,14.278499999999999,null,null,null,2,23.045999999999999]
[3,15.2805,null,null,null,3,14.278499999999999,null,null,null,3,23.346600000000002]
[4,15.2805,null,null,null,4,13.877699999999999,null,null,null,4,23.296500000000002]
[5,15.2805,null,null,null,5,14.078100000000001,null,null,null,5,22.945799999999998]
[6,15.380699999999999,null,null,null,6,13.9779,null,null,null,6,23.1462]
[7,15.3306,null,null,null,7,14.1783,null,null,null,7,23.045999999999999]
[8,15.380699999999999,null,null,null,8,14.078100000000001,null,null,null,8,23.246399999999998]
[9,15.230399999999999,null,null,null,9,14.1282,null,null,null,9,23.346600000000002]
[10,15.2805,null,null,null,10,13.8276,null,null,null,10,22.945799999999998]
[11,15.3306,null,null,null,11,13.877699999999999,null,null,null,11,22.995899999999999]
[12,15.380699999999999,null,null,null,12,14.1783,null,null,null,12,23.0961]
[13,15.4308,null,null,null,13,14.228399999999999,null,null,null,13,23.1462]
[14,15.230399999999999,null,null,null,14,14.028,null,null,null,14,23.246399999999998]
[15,15.180300000000001,null,null,null,15,14.1282,null,null,null,15,23.196299999999997]
[16,15.230399999999999,null,null,null,16,13.9278,null,null,null,16,22.995899999999999]
[17,15.2805,null,null,null,17,13.877699999999999,null,null,null,17,23.246399999999998]
[18,15.380699999999999,null,null,null,18,14.278499999999999,null,null,null,18,22.945799999999998]
[19,15.2805,null,null,null,19,14.1783,null,null,null,19,22.995899999999999]
[20,15.2805,null,null,null,20,13.877699999999999,null,null,null,20,23.045999999999999]
[21,15.2805,null,null,null,21,14.1282,null,null,null,21,23.0961]
[22,15.4308,null,null,null,22,14.078100000000001,null,null,null,22,23.1462]
[23,15.4809,null,null,null,23,13.877699999999999,null,null,null,23,23.246399999999998]
[24,15.2805,null,null,null,24,14.1282,null,null,null,24,23.045999999999999]
[]
[]
["Campioni con numerosità pari a 3"]
["Caratteristica di qualità: Diametro esterno minimo",{"$nulls":4},"Caratteristica di qualità: Diametro interno",{"$nulls":4},"Caratteristica di qualità: Lunghezza"]
[]
["Campione misurato ","Diametro esterno minimo medio (mm) ","Range Ri (mm)",null,null,"N° campione ","Diametro interno medio (mm) ","Range Ri (mm) ",null,null,"N° campione ","Lunghezza media (mm) ","Range Ri (mm) "]
[1,15.3306,0.3,null,null,1,14.05,0.1,null,null,1,23.16,0.83]
[2,15.380699999999999,0.35,null,null,2,14.12,0.25,null,null,2,23.13,0.37]
[3,15.230399999999999,0.25,null,null,3,14.02,0.1,null,null,3,22.98,0.16]
[4,15.2805,0.01,null,null,4,13.8276,0.25,null,null,4,23.1462,0.41]
[5,15.3306,0.2,null,null,5,13.877699999999999,0.05,null,null,5,23.246399999999998,0.49]
[6,15.380699999999999,0.25,null,null,6,14.1783,0.15,null,null,6,23.196299999999997,0.28000000000000003]
[7,15.4308,0.1,null,null,7,14.228399999999999,0.05,null,null,7,22.995899999999999,0.26]
[8,15.230399999999999,0.1,null,null,8,14.028,0.05,null,null,8,23.246399999999998,0.06]
[9,15.180300000000001,0.25,null,null,9,14.1282,0.05,null,null,9,22.945799999999998,0.06]
[10,15.230399999999999,0.09,null,null,10,13.9278,0.08,null,null,10,22.995899999999999,0.36]
[11,15.2805,0.05,null,null,11,13.877699999999999,0.1,null,null,11,23.045999999999999,0.18]
[12,15.380699999999999,0.22,null,null,12,14.278499999999999,0.05,null,null,12,23.0961,0.28999999999999998]
[13,15.2805,0.1,null,null,13,14.1783,0.05,null,null,13,23.1462,0.41]
[14,15.2805,0.2,null,null,14,13.877699999999999,0.2,null,null,14,23,0.16]
[15,15.2805,0.1,null,null,15,14.1282,0.1,null,null,15,22.8,0.3]
[16,15.25,0.11,null,null,16,14.08,0.1,null,null,16,23.02,0.28999999999999998]
[17,15.33,0.2,null,null,17,14.07,0.05,null,null,17,23.2,0.21]
[18,15.28,0.1,null,null,18,14.1,0.1,null,null,18,22.9,0.17]
[19,15.37,0.15,null,null,19,13.95,0.25,null,null,19,23.1,0.27]
[20,15.32,0.25,null,null,20,13.92,0.1,null,null,20,23.12,0.11]
[21,15.42,0.3,null,null,21,14.08,0.05,null,null,21,23.03,0.05]
[22,15.25,0.11,null,null,22,14.02,0.05,null,null,22,22.97,0.31]
[23,15.28,0.25,null,null,23,14,0.12,null,null,23,22.91,0.23]
[24,15.3,0.1,null,null,24,14.02,0.1,null,null,24,23.21,0.24]
[]
[]
["Campioni con numerosità variabile"]
["Caratteristica di qualità: Diametro esterno minimo"]
[]
["Campione misurato","Diametro esterno minimo (mm) "]
[1,15.25,15.52]
[2,15.25,15.56,15.28]
[3,15.29,15.31,15.29]
[4,15.3306,15.15]
[5,15.380699999999999,15.27,15.33]
[6,15.230399999999999,15.25,15.3]
[7,15.2805,15.2805,15.25]
[8,15.3306,15.2805,15.25,15.35]
[9,15.380699999999999,15.25,15.19,15.15]
[10,15.4308,15.33]
[11,15.230399999999999,15.28,15.22,15.3,15.42]
[12,15.180300000000001,15.37,15.3,15.29]
[13,15.230399999999999,15.32,15.23,15.34]
[14,15.2805,15.42,15.29,15.32,15.02]
[15,15.26,15.25,15.3,15.15]
[16,15.15,15.31,15.26]
[17,15.56,15.15,15.09,15.2]
[18,15.15,15.28]
[19,15.02,15.31,15.09]
[20,15.23,15.12]
[21,15.28,15.03,15.12]
[22,15.32,15.25]
[23,15.15,15.23]
[24,15.25,15.04,15.11]
[]
[]
["Caratteristica di qualità: Diametro interno"]
["Campione misurato ","Diametro interno   (mm) "]
[1,14.05,14.02]
[2,14.12,14.05,14.05]
[3,14.02,14.05,14.25]
[4,13.8276,14.05]
[5,13.877699999999999,14.05,14.05]
[6,14.1783,13.8,14.1]
[7,14.228399999999999,14.01,14.05]
[8,14.028,14.05,13.75,14]
[9,14.1282,13.85,14.05,14.02]
[10,13.9278,14]
[11,13.877699999999999,14.1,13.97,14.05,14.35]
[12,13.85,14.1,14.05,13.95]
[13,14.05,14.05,14.05,13.77]
[14,14,14.12,14.1,13.85,13.88]
[15,13.9,14.02,14.15,13.95]
[16,14.2,13.8276,14.05]
[17,13.96,13.877699999999999,14.2,14.02]
[18,14.03,14.1783]
[19,13.8,14.228399999999999,14.15]
[20,13.95,14.028]
[21,13.98,14.1282,14.01]
[22,13.95,13.9278]
[23,14.03,13.877699999999999]
[24,13.85,14.15,14.02]
[]
[]
["Caratteristica di qualità: Lunghezza"]
["Campione misurato ","Lunghezza (mm) "]
[1,23.45,23.7,{"$nulls":11},5]
[2,23.51,23.57,23.12]
[3,22.83,23.87,23.43]
[4,23.49,23.09]
[5,23.1462,23.08,22.93]
[6,23,22.97,23.05]
[7,22.8,23.05,22.91]
[8,23.02,22.74,23.05,22.93]
[9,23.2,22.99,22.79,23.17]
[10,22.9,23.1462]
[11,23.1,23.43,22.95,22.91,22.83]
[12,23.12,22.84,23.45,22.93]
[13,23.03,23.02,23.11,22.83]
[14,22.97,23.2,22.9,22.97,22.93]
[15,22.91,22.9,23,22.91]
[16,23.21,23.13,23.1]
[17,22.9,23.12,23.1,23.23]
[18,22.97,23.03]
[19,22.98,22.97,23.12]
[20,22.74,22.91]
[21,22.95,23.21,23.07]
[22,23.18,22.93]
[23,23.15,22.99]
[24,23.13,22.87,23.21]

{"sheet":"CARTE DI CONTROLLO X ATTRIBUTI","index":1,"n_rows":93,"n_cols":10,"rows_kept":93,"cut":false,"hidden":false,"merged":[[66,0,66,3]]}
[]
["CAMPIONI con numerosità unitaria",{"$nulls":8},"Si riporta nella tabella, per ogni campione, la presenza o meno dei possibili difetti di interesse, indicando con il verde la presenza del corrispondente difetto, e con il rosso la sua assenza. "]
[{"$nulls":9},"Successivamente, per ogni campione si sommano i difetti presenti, e dividendo i difetti totali per i campioni totali si ottiene il parametro C, parametro chiave per la costruzione delle omonime carte"]
["Si valutano le seguenti 3 caratteristiche: "]
[null,"visibilità dell’incisione trasversale "]
[null,"presenza di bave "]
[null,"visibilità del marchio"]
[{"$nulls":6},"assenza difetto"]
[{"$nulls":6},"presenza difetto"]
[]
["Campione misurato ","Visibilità incisione","Presenza Bave","Visibilità marchio","N° Difetti"]
[1,null,null,null,1]
[2,null,null,null,0]
[3,null,null,null,1]
[4,null,null,null,1]
[5,null,null,null,2]
[6,null,null,null,2]
[7,null,null,null,0]
[8,null,null,null,2]
[9,null,null,null,0]
[10,null,null,null,0]
[11,null,null,null,2]
[12,null,null,null,2]
[13,null,null,null,1]
[14,null,null,null,1]
[15,null,null,null,2]
[16,null,null,null,1]
[17,null,null,null,2]
[18,null,null,null,0]
[19,null,null,null,1]
[20,null,null,null,2]
[21,null,null,null,2]
[22,null,null,null,2]
[23,null,null,null,3]
[24,null,null,null,1]
[]
["Campioni con numerosità pari a 3"]
[]
["Campione misurato ","Difetti",{"$nulls":7},"L’analisi effettuata in questo caso è del tutto similare a quella precedentemente condotta, con la sola differenza che si dispone di un numero maggiore di misurazioni a comporre ogni campione, per cui si può adottare nuovamente la carta C. Tuttavia ci si deve aspettare ora valori di C maggiori del caso precedente (nella tabella seguente si omettono, per comodità di lettura, i dati relativi alla singola misurazione)"]
[1,3]
[2,1]
[3,2]
[4,3]
[5,4]
[6,5]
[7,3]
[8,4]
[9,4]
[10,2]
[11,3]
[12,4]
[13,6]
[14,5]
[15,1]
[16,2]
[17,3]
[18,2]
[19,4]
[20,3]
[21,4]
[22,2]
[23,3]
[24,5]
[]
[]
["Campioni con numerosità vaiabile"]
["(per i seguenti campioni occorre ricordare la seguente Numerosità)"]
[]
["Campione misurato ","Numerosità","Numero di Difetti","Numero medio di difetti"]
[1,2,6,{"$f":"+C70/B70","v":3}]
[2,3,4,{"$f":"+C71/B71","v":1.3333333333333333}]
[3,3,5,1.6666666666666667]
[4,2,5,2.5]
[5,3,3,1]
[6,3,5,1.6666666666666667]
[7,3,3,1]
[8,4,4,1]
[9,4,8,2]
[10,2,2,1]
[11,5,4,0.8]
[12,4,6,1.5]
[13,4,4,1]
[14,5,6,1.2]
[15,4,3,0.75]
[16,3,4,1.3333333333333333]
[17,4,6,1.5]
[18,2,5,2.5]
[19,3,6,2]
[20,2,6,3]
[21,3,5,1.6666666666666667]
[22,2,3,1.5]
[23,2,6,3]
[24,3,5,1.6666666666666667]