{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["คำอธิบาย","หลักเกณฑ์","Report"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":0,"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":"คำอธิบาย","index":0,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,2,0],[1,7,2,8]]}
["รายงานการตรวจสอบและบำรุงรักษาเครื่องชั่ง"]
["คำอธิบาย",null,null,null,null,null,null,"2020-07-22"]

{"sheet":"หลักเกณฑ์","index":1,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[20,0,21,4],[20,5,21,7],[20,8,21,8],[32,0,33,4],[32,5,33,7],[32,8,33,8],[28,0,29,4],[28,5,29,7],[28,8,29,8],[4,5,4,6],[12,5,12,6],[30,0,31,4],[30,5,31,7],[30,8,31,8],[22,0,23,4],[22,5,23,7],[22,8,23,8],[24,0,25,4],[24,5,25,7],[24,8,25,8],[18,0,19,4],[18,5,19,7],[26,0,27,4],[26,5,27,7],[26,8,27,8]]}
["หลักเกณฑ์การเลือกตุ้มน้ำหนัก"]
["1. การเลือกตุ้มน้ำหนักสำหรับ Repeatability โดยอิงจาก Maximum capacity   คือ  \n"]
[]
[]
[null,"Maximum capacity ",null,null,"g"]
[]
[null,"เครื่องชั่งความละเอียด",null,null,"ตำแหน่ง"]
[]
[null,"น้ำหนักตุ้มที่เหมาะสมอยู่ในช่วงตั้งแต่",null,null,{"$f":"IF(D7=\"\",\"\",((2000*0.41*(10^-D7))))","v":""},"ถึง",{"$f":"IF(D5=\"\",\"\",D5*5/100)","v":""},"g"]
["2. การเลือกตุ้มน้ำหนักสำหรับ Accuracy และ Eccentricity โดยอิงจาก Maximum capacity   คือ  "]
[]
[]
[null,"Maximum capacity ",null,{"$f":"IF(D5=\"\",\"\",D5)","v":""},"g"]
[]
[null,"เครื่องชั่งความละเอียด",null,{"$f":"IF(D7=\"\",\"\",D7)","v":""},"ตำแหน่ง"]
[]
[null,"น้ำหนักตุ้มที่เหมาะสมอยู่ในช่วงตั้งแต่",null,null,{"$f":"IF(D5=\"\",\"\",D5*5/100)","v":""},"ถึง",{"$f":"IF(D5=\"\",\"\",D5)","v":""},"g"]
["หลักเกณฑ์ในการกำหนดเกณฑ์ที่ยอมรับ (%Tolerance)"]
["ผลต่อคุณภาพ,ราคา,ความปลอดภัย, ประสิทธิภาพ และของเสีย (Effects on quality, cost, safety, efficiency and waste)",null,null,null,null,"\nผลกระทบต่อคุณภาพ\n(Quality impact)\n",null,null,"Process Tolerance "]
[null,null,null,null,null,null,null,null,"%"]
["สารมีความสำคัญมาก: มีผลกระทบสูง / ค่าใช้จ่ายสูง\n(Super-critical components: high effect/cost)",null,null,null,null,"รุนแรง (Acute)",null,null,"≤ 0.1"]
[]
["สารหรือกระบวนการ มีราคาแพง และสำคัญมาก\n(Expensive, very critical components or processes)",null,null,null,null,"สำคัญมาก (Crucial)",null,null,0.1]
[]
["สารหรือกระบวนการ มีความสำคัญ\n(Key components and processes)",null,null,null,null,"สูงมาก (Very high)",null,null,0.2]
[]
["คุณภาพและ กระบวนการที่สำคัญ สูงกว่าค่าเฉลี่ย\n(Above average quality & critical processes)",null,null,null,null,"สูง (High)",null,null,0.5]
[]
["ข้อกำหนดและกระบวนการโดยเฉลี่ย\n(Average requirements & processes)",null,null,null,null,"ปานกลาง (Median)",null,null,1]
[]
["สารราคาไม่แพง\n(Inexpensive base materials)",null,null,null,null,"ต่ำ (Low)",null,null,2]
[]
[" สารราคาถูก และผลิตภัณฑ์มีประสิทธิภาพต่ำ\n (Low cost materials, and products with low effectivity)",null,null,null,null,"เล็กน้อย (Negligible)",null,null,"5-10"]

{"sheet":"Report","index":2,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[19,11,20,12],[19,7,19,8],[20,7,20,8],[33,13,33,14],[3,0,3,3],[8,0,8,6],[25,1,25,2],[11,0,11,6],[12,0,12,6],[13,0,13,6],[14,0,14,6],[9,0,9,6],[10,0,10,6],[21,1,21,2],[22,1,22,2],[23,1,23,2],[21,5,21,6],[19,5,20,6],[47,1,47,3],[41,1,41,3],[47,4,47,5],[44,2,44,3],[45,2,45,3],[46,2,46,3],[42,4,42,5],[41,4,41,5],[46,4,46,5],[43,4,43,5],[42,2,42,3],[43,2,43,3],[4,1,4,4],[5,1,5,4],[18,0,18,1],[5,7,5,9],[4,7,4,9],[45,11,45,13],[27,5,27,14],[28,5,28,14],[44,11,44,13],[37,13,37,14],[35,13,35,14],[45,4,45,5],[44,4,44,5],[21,11,21,12],[19,1,19,2],[20,1,20,2],[41,13,41,14],[30,2,30,3],[27,1,27,2],[28,1,28,2],[29,1,29,2],[26,1,26,2],[22,7,22,8],[22,9,22,10],[22,11,22,12],[22,14,22,15],[19,14,20,15],[24,1,24,2],[22,5,22,6],[48,1,48,2],[48,4,48,5],[0,0,1,15],[21,14,21,15],[39,13,39,14],[25,5,25,14],[26,5,26,14],[8,13,8,14],[9,13,9,14],[12,12,12,13],[11,12,11,13],[19,9,19,10],[20,9,20,10],[21,9,21,10],[21,7,21,8],[4,11,4,13]]}
["รายงานการตรวจสอบและบำรุงรักษาเครื่องชั่ง"]
[]
[]
["รายละเอียดเครื่องชั่ง"]
["ผู้ผลิต :",null,null,null,null,"Model :",null,null,null,null,"S/N :"]
["ที่ตั้ง:",null,null,null,null,"รหัสครุภัณฑ์ :",null,null,null,null,"เครื่องชั่งความละเอียด",null,null,null,"ตำแหน่ง"]
[]
["Pre-Checking Condition"]
["รายการตรวจสอบ",null,null,null,null,null,null,"ผล",null,null,"Max. capacity (g): "]
["1. ตัวเครื่องชั่งและจอแสดงผล",null,null,null,null,null,null,{"$f":"IF(I10=TRUE,\"ผ่าน\",\"ไม่ผ่าน\")","v":"ไม่ผ่าน"},false,null,"Readability (g): ",null,null,{"$f":"10^-N6","v":1}]
["2. จานชั่งและฐานรองจานชั่ง",null,null,null,null,null,null,"ไม่ผ่าน",false,null,"Smallest net weight:",null,null,null,"g"]
["3. ขาปรับระดับ",null,null,null,null,null,null,"ไม่ผ่าน",false,null,"เกณฑ์ที่ยอมรับ:",null,null,null,"%"]
["4. ตู้ครอบหรือกระจกกันลม",null,null,null,null,null,null,"ไม่ผ่าน",false,null,"ชุดตุ้มน้ำหนัก:"]
["5. สายไฟและฟิวส์ (fuse)",null,null,null,null,null,null,"ไม่ผ่าน",false]
["6. อุณหภูมิและความชื้น",null,null,null,null,null,null,"ไม่ผ่าน",false,{"$f":"COUNTIF(I10:I15,TRUE)","v":0}]
[]
["Repeatability"]
[]
["ตุ้มน้ำหนักที่ใช้(g)"]
[1,null,null,null,null,"ตุ้มที่ใช้(g)",null,"น้ำหนักตุ้มที่",null,"ค่าที่ปรากฏ",null,"Relative error",null,"เกณฑ์","ผล"]
[2,null,null,null,null,null,null,"แท้จริง (g)",null,"(g)",null,null,null,"(±ไม่เกิน)"]
[3,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(J22=\"\",H22=\"\"),\"\",ABS(((J22-H22)/H22)*100))","v":""},null,{"$f":"M12","v":0},{"$f":"IF(OR(L22=\"\",N22=\"\"),\"\",IF(ABS(L22)<N22,\"ผ่าน\",\"ไม่ผ่าน\"))","v":""}]
[4,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(J23=\"\",H23=\"\"),\"\",((J23-H23)/H23))","v":""},null,{"$f":"IF(OR(J23=\"\",H23=\"\"),\"\",H23*M12/100)","v":""},{"$f":"IF(OR(L23=\"\",N23=\"\"),\"\",IF(ABS(L23)<N23,\"ผ่าน\",\"ไม่ผ่าน\"))","v":""}]
[5]
[6]
[7]
[8]
[9]
[10]
["SD",{"$f":"IF(ISERROR(STDEV(B20:C29)),\"\",STDEV(B20:C29))","v":""},null,{"$f":"IF(C31<M12,\"ผ่าน\",\"ไม่ผ่าน\")","v":{"$error":"#VALUE!"}}]
[{"$f":"0.41*M10","v":0},{"$f":"IF(B30<A31,A31,B30)","v":""},{"$f":"((2*B31)/N11)*100","v":{"$error":"#VALUE!"}}]
["Eccentricity",null,null,null,null,null,null,null,null,"สรุปผล"]
[]
[null,null,null,null,null,null,null,null,"» Pre-Checking condition",null,null,null,null,{"$f":"IF(J15=6,\"ปกติ\",\"!!\")","v":"!!"}]
[]
[null,null,null,null,null,null,null,null,"» Repeatability",null,null,null,null,{"$f":"IF(ISERROR(D30),\"!!\",D30)","v":"!!"}]
[]
[null,null,null,null,null,null,null,null,"» Recommended *SNW(g)",null,null,null,null,{"$f":"IF(B30<>\"\",200*B30/M12,\"\")","v":""}]
[]
["ตุ้มน้ำหนักที่ใช้(g)",null,null,null,null,null,null,null,"» Accuracy",null,null,null,null,{"$f":"IF(O22 = \"ผ่าน\",O22,\"!!\")","v":"!!"}]
[]
[null,"ตำแหน่ง",null,null,"Deviation",null,null,null,"» Eccentricity",null,null,null,null,{"$f":"IF(ISERROR(E49),\"!!\",E49)","v":"!!"}]
[null,1,null,null,"-"]
[{"$f":"IF(C44=\"\",\"\",ABS(C43-C44))","v":""},2,null,null,{"$f":"IF(C44=\"\",\"\",C44-C43)","v":""},null,{"$f":"IF(A44=E48,\"!\",\" \")","v":" "}]
[{"$f":"IF(C45=\"\",\"\",ABS(C43-C45))","v":""},3,null,null,{"$f":"IF(C45=\"\",\"\",C45-C43)","v":""},null,{"$f":"IF(A45=E48,\"!\",\" \")","v":" "},null,null,null,"ลงชื่อ:"]
[{"$f":"IF(C46=\"\",\"\",ABS(C43-C46))","v":""},4,null,null,{"$f":"IF(C46=\"\",\"\",C46-C43)","v":""},null,{"$f":"IF(A46=E48,\"!\",\" \")","v":" "},null,null,null,"วันที่:"]
[{"$f":"IF(C47=\"\",\"\",ABS(C43-C47))","v":""},5,null,null,{"$f":"IF(C47=\"\",\"\",C47-C43)","v":""},null,{"$f":"IF(A47=E48,\"!\",\" \")","v":" "}]
[{"$f":"MAX(A44:A47)","v":0},"Maximum Deviation",null,null,{"$f":"MAX(A44:A47)","v":0}]
[null,"เกณฑ์ (ไม่เกิน)",null,{"$f":"IF(AND(C40<>\"\",M12<>\"\"),(M12*C43/100)/2,\"กรอกไม่ครบ\")","v":"กรอกไม่ครบ"},{"$f":"IF(OR(C40=\"\",M12=\"\"),\"!!\",IF(E48<=D49,\"ผ่าน\",\"ไม่ผ่าน\"))","v":"!!"}]