{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Template","Sheet1","Sheet2"],"not_rendered":{"charts":6,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Template","index":0,"n_rows":39,"n_cols":28,"rows_kept":39,"merged":[[0,0,0,27],[1,0,2,5],[1,6,1,14],[1,15,1,20],[1,21,1,27],[2,6,2,14],[2,15,2,20],[2,21,2,27],[3,0,3,5],[3,6,3,14],[3,15,3,20],[3,21,3,27],[4,0,14,2],[17,0,26,2],[28,0,28,3],[29,0,33,0],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,0,34,3],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,27],[67,0,67,22],[68,0,69,4],[68,5,68,10],[68,11,68,16],[68,17,68,22],[69,5,69,10],[69,11,69,16],[69,17,69,22],[70,0,70,4],[70,5,70,10],[70,11,70,16],[70,17,70,22],[71,0,81,2],[84,0,94,2],[97,0,97,3],[98,0,102,0],[98,1,98,3],[99,1,99,3],[100,1,100,3],[101,1,101,3],[102,1,102,3],[103,0,103,3],[104,0,104,3],[105,0,105,3],[106,0,106,3]],"flags":["formulas_cached_only"]}
["AVERAGE AND RANGE (X & R) CONTROL CHART"]
["Plant :",{"$nulls":5},"Process / Opn : ",{"$nulls":8},"Sample Size       : ",{"$nulls":5},"Specification Limit :"]
[{"$nulls":6},"Machine          : ",{"$nulls":8},"Frequency          : ",{"$nulls":5},"Date      :"]
["Part No:       Iss No:",{"$nulls":5},"Description      : ",{"$nulls":8},"Characteristic     : ",{"$nulls":5},"Shift      :"]
["AVERAGES( X CHART)\n  Calculation:\n  Averages (X\n  =\n  UCL = X + A2 x R\n  =\n  =\n  =\n LCL = X(-) A2 x R\n  =\n  =\n  ="]
{"$rows_empty":10}
[null,"Average = 0.000",null,null,"UCLx = 0.000",{"$nulls":5},"LCLx = 0.000",{"$nulls":7},"Cp_ =  0.000"]
[null,"R = 0.000",null,null,"UCLr =  0.000         ",{"$nulls":5},"LCLr  = 0.000",{"$nulls":7},"Cpk = 0.000"]
["  Calculation:\n  Averages (X R\n  =\n  UCLR =D4 x R\n  =\n  =\n  =\nLCLR = D3 x R\n  =\n  =\n  ="]
{"$rows_empty":9}
[{"$nulls":4},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["Sample No. :",{"$nulls":3},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["READINGS","Sample X1"]
[null,"Sample X2"]
[null,"Sample X3"]
[null,"Sample X4"]
[null,"Sample X5"]
["Sum of Samples (Ex)"]
["X = EX / No.Of Samples"]
["R = Highest - Lowest"]
["Signature"]
["MSMU-QA-010 Date: 10-01-10"]

{"sheet":"Sheet1","index":1,"n_rows":39,"n_cols":28,"rows_kept":39,"hidden":true,"merged":[[0,0,0,27],[1,0,2,5],[1,6,1,14],[1,15,1,20],[1,21,1,27],[2,6,2,14],[2,15,2,20],[2,21,2,27],[3,0,3,5],[3,6,3,14],[3,15,3,20],[3,21,3,27],[4,0,14,2],[17,0,26,2],[28,0,28,3],[29,0,33,0],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,0,34,3],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,27],[67,0,67,22],[68,0,69,4],[68,5,68,10],[68,11,68,16],[68,17,68,22],[69,5,69,10],[69,11,69,16],[69,17,69,22],[70,0,70,4],[70,5,70,10],[70,11,70,16],[70,17,70,22],[71,0,81,2],[84,0,94,2],[97,0,97,3],[98,0,102,0],[98,1,98,3],[99,1,99,3],[100,1,100,3],[101,1,101,3],[102,1,102,3],[103,0,103,3],[104,0,104,3],[105,0,105,3],[106,0,106,3]],"flags":["formulas_cached_only"]}
["AVERAGE AND RANGE (X & R) CONTROL CHART"]
["Plant : MSPL - Manufacturing Unit",{"$nulls":5},"Process / Opn : Grinding",{"$nulls":8},"Sample Size       : 5 Nos.",{"$nulls":5},"Specification Limit : 7.972 / 7.987"]
[{"$nulls":6},"Machine          : Grinding",{"$nulls":8},"Frequency          : 1 hr",{"$nulls":5},"Date      :"]
["Part No: 26254370      Iss No:",{"$nulls":5},"Description      : Drive Shaft",{"$nulls":8},"Characteristic     : Grinding Dia",{"$nulls":5},"Shift      :"]
["AVERAGES( X CHART)\n  Calculation:\n  Averages (X\n  =\n  UCL = X + A2 x R\n  =\n  =\n  =\n LCL = X(-) A2 x R\n  =\n  =\n  ="]
{"$rows_empty":10}
[null,"R= 0.000",null,null,"UCLR =          ",null,"D4R  = 0.000",{"$nulls":3},"LCLR  =",null,"D3R=",{"v":0,"d":"0.000"},{"$nulls":4},"Cp_ = "]
[{"$nulls":18},"Cpk ="]
["  Calculation:\n  Averages (X R\n  =\n  UCLR =D4 x R\n  =\n  =\n  =\nLCLR = D3 x R\n  =\n  =\n  ="]
{"$rows_empty":9}
[{"$nulls":4},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["Date / Time : ",{"$nulls":3},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["READINGS","Sample X1",null,null,7.985,7.983,7.981,7.983,7.986,7.982,7.978]
[null,"Sample X2",null,null,7.986,7.984,7.982,7.981,7.981,7.985,7.985]
[null,"Sample X3",null,null,7.986,7.982,7.983,7.984,7.984,7.982,{"v":7.98,"d":"7.980"}]
[null,"Sample X4",null,null,7.981,{"v":7.98,"d":"7.980"},7.981,7.983,7.983,7.981,7.979]
[null,"Sample X5",null,null,{"v":0,"d":"0.000"},7.981,7.982,7.982,7.984,7.981,7.978]
["Sum of Samples (Ex)",{"$nulls":3},{"v":7.985666666666667,"d":"7.986"},{"v":7.981999999999999,"d":"7.982"},{"v":7.9818,"d":"7.982"},{"v":7.982600000000001,"d":"7.983"},{"v":7.9836,"d":"7.984"},{"v":7.982200000000001,"d":"7.982"},{"v":7.9799999999999995,"d":"7.980"}]
["X = EX / No.Of Samples",{"$nulls":3},{"v":0.0009999999999994458,"d":"0.001"},{"v":0.0039999999999995595,"d":"0.004"},{"v":0.0019999999999997797,"d":"0.002"},{"v":0.0030000000000001137,"d":"0.003"},{"v":0.004999999999999893,"d":"0.005"},{"v":0.004000000000000448,"d":"0.004"},{"v":0.007000000000000561,"d":"0.007"}]
["R = Highest - Lowest"]
["Signature"]
["MSMU-QA-010 Date: 10-01-10"]

{"sheet":"Sheet2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}