{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["3200"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"3200","index":0,"n_rows":41,"n_cols":19,"rows_kept":41,"merged":[[0,0,0,13],[1,0,1,13],[2,4,2,13],[3,1,3,8],[3,10,3,13],[4,5,4,13],[5,1,5,7],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[11,8,11,9],[12,8,12,9],[13,0,13,11],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,0,22,11],[23,8,23,9],[24,0,24,11],[25,8,25,9],[26,0,26,11],[27,0,27,10],[35,4,35,11],[36,7,36,9],[36,11,36,13],[37,6,37,13],[38,1,38,13],[39,8,39,11],[40,8,40,11]]}
["แบบการประเมินความพร้อมของเรือ"]
["สาขา การอาวุธใต้น้ำ (องค์วัตถุ)"]
["หน่วย/เรือที่รับการประเมิน"]
["ผู้ประเมิน",{"$nulls":8},"ตำแหน่ง","ครูประเมินสาขาการอาวุธใต้น้ำ"]
["วันที่และช่วงเวลาในการประเมิน"]
["หัวข้อ","รายการ",{"$nulls":6},"คะแนนเต็มจากรายการตรวจ",null,"คะแนนที่ได้จากรายการตรวจ","ตัวคูณ\nน้ำหนักเป็น %","คะแนนที่ได้","หมายเหตุ",{"$f":"SUM(I13:J13)","v":{"v":100,"d":"100.0"}},"mark",{"$f":"COUNT(I8:J13)","v":5},{"$f":"SUM(I8:J13)","v":{"v":500,"d":"500.0"}}]
["1","เครื่องยิง/เครื่องทิ้ง",{"$nulls":9},35,{"$f":"IF(K7=\"\",\"\",O7)","v":""}]
[null,1.1,"ท่อตอร์ปิโด…..............",{"$nulls":5},{"v":100,"d":"100.00"},{"$nulls":3},{"$f":"IF(O8>0,O8,\"\")","v":""},null,{"$f":"IF(P8=1,0,K8)","v":{"v":0,"d":"0.0"}},{"$f":"IF(N8=\"\",0,1)","v":0}]
[null,1.2,"แท่นยิง RDC",{"$nulls":5},{"v":100,"d":"100.00"},{"$nulls":3},{"$f":"IF(O9>0,O9,\"\")","v":""},null,{"$f":"IF(P9=1,0,K9)","v":{"v":0,"d":"0.0"}},{"$f":"IF(N9=\"\",0,1)","v":0}]
[null,1.3,"เครื่องยิงลูกระเบิดปราบเรือดำน้ำ",{"$nulls":5},{"v":100,"d":"100.00"},{"$nulls":3},"",null,{"v":0,"d":"0.0"},0]
[null,null,"MK 10 (LIMBO)"]
[null,1.4,"เครื่องยิงลูกระเบิดลึก K-GUN",{"$nulls":5},{"v":100,"d":"100.00"},{"$nulls":3},"",null,{"$f":"IF(P12=1,0,K12)","v":{"v":0,"d":"0.0"}},0]
[null,1.5,"รางปล่อยลูกระเบิดลึก",{"$nulls":5},{"v":100,"d":"100.00"},{"$nulls":3},"",null,{"v":0,"d":"0.0"},0]
["รวมคะแนนเครื่องยิง/เครื่องทิ้ง (35 คะแนน)",{"$nulls":11},{"$f":"IF(R14=0,\"\",R14)","v":""},null,{"$f":"SUM(O8:O13)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(P8:P13)","v":{"v":0,"d":"0.0"}},{"$f":"IF(O14>0,O14/(Q6-P14),0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(P14>=1,L7,Q14*L7/100)","v":0},{"$f":"IF(R14=0,0,1)","v":0}]
["2","เครื่องควบคุมการยิง",{"$nulls":9},35,{"$f":"IF(K15=\"\",\"\",O15)","v":""},{"$nulls":3},{"$f":"COUNT(I16:J22)","v":7}]
[null,2.1,"CRU",{"$nulls":5},{"v":100,"d":"100.00"},{"$nulls":3},{"$f":"IF(O16>0,O16,\"\")","v":""},null,{"$f":"IF(P16=1,0,K16)","v":{"v":0,"d":"0.0"}},{"$f":"IF(N16=\"\",0,1)","v":0}]
[null,2.2,"DSCP ตู้ไฟยิง",{"$nulls":5},{"v":100,"d":"100.00"},{"$nulls":3},"",null,{"v":0,"d":"0.0"},0]
[null,2.3,"LCC",{"$nulls":5},{"v":100,"d":"100.00"},{"$nulls":3},"",null,{"v":0,"d":"0.0"},0]
[null,2.4,"MK 264 Mod1",{"$nulls":5},{"v":100,"d":"100.00"},{"$nulls":3},"",null,{"v":0,"d":"0.0"},0]
[null,2.5,"MK 309 Mod 0",{"$nulls":5},{"v":100,"d":"100.00"},{"$nulls":3},{"$f":"IF(O20>0,O20,\"\")","v":""},null,{"$f":"IF(P20=1,0,K20)","v":{"v":0,"d":"0.0"}},{"$f":"IF(N20=\"\",0,1)","v":0}]
[null,2.6,"TLS-MK331",{"$nulls":5},{"v":100,"d":"100.00"},{"$nulls":3},"",null,{"v":0,"d":"0.0"},0]
[null,2.7,"ZST-2D",{"$nulls":5},{"v":100,"d":"100.00"},{"$nulls":3},"",null,{"v":0,"d":"0.0"},0]
["รวมคะแนนเครื่องควบคุมการยิง (35 คะแนน)",{"$nulls":11},{"$f":"IF(R23=0,\"\",R23)","v":""},null,{"$f":"SUM(O16:O22)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(P16:P22)","v":{"v":0,"d":"0.0"}},{"$f":"IF(O23>0,O23/(Q15-P23),0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(P23>=1,L15,Q23*L15/100)","v":0},{"$f":"IF(R23=0,0,1)","v":0}]
["3","คลังสรรพาวุธ",{"$nulls":6},{"v":100,"d":"100.00"},null,null,15,{"$f":"IF(O24>0,O24,\"\")","v":""},null,{"$f":"K24","v":{"v":0,"d":"0.0"}},0,{"$f":"COUNT(I24)","v":1}]
["รวมคะแนนคลังสรรพาวุธ (15 คะแนน)",{"$nulls":11},{"$f":"IF(R25=0,\"\",R25)","v":""},null,{"$f":"SUM(O24)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(P24)","v":{"v":0,"d":"0.0"}},{"$f":"IF(O25>0,O25,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(P24=1,L24,Q25*L24/100)","v":0},{"$f":"IF(R25=0,0,1)","v":0}]
["4","เอกสาร",{"$nulls":6},{"v":100,"d":"100.00"},null,null,15,{"$f":"IF(O26>0,O26,\"\")","v":""},null,{"$f":"IF(P26=1,0,K26)","v":{"v":0,"d":"0.0"}},{"$f":"IF(N26=\"\",0,1)","v":0},{"$f":"COUNT(I26)","v":1}]
["รวมคะแนนเอกสาร (15 คะแนน)",{"$nulls":11},{"$f":"IF(R27=0,\"\",R27)","v":""},null,{"$f":"SUM(O26)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(P26)","v":{"v":0,"d":"0.0"}},{"$f":"IF(O27>0,O27,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(P26=1,L26,Q27*L26/100)","v":0},{"$f":"IF(R27=0,0,1)","v":0}]
["คะแนนรวมทั้งหมด",{"$nulls":11},{"$f":"IF(S28>0,R28,\"\")","v":""},"ร้อยละ",{"$nulls":3},{"$f":"SUM(R7:R27)","v":0},{"$f":"SUM(S7:S27)","v":0}]
[null,"ระดับผลการประเมิน"]
[null,1,"เกณฑ์การให้คะแนน"]
[{"$nulls":3},"ต้องปรับปรุง",{"$nulls":3},"0 - 59",null,"ปานกลาง","70 - 79",null,"ดี","80 - 89"]
[{"$nulls":3},"พอใช้",{"$nulls":3},"60 - 69",{"$nulls":4},"ดีมาก","90 - 100"]
[null,2,"คิดคะแนนเป็นร้อยละ โดยคิดจากร้อยละคะแนนเต็มตามหัวข้อที่ประเมินได้ และมีบรรจุตามอัตราเรือ"]
[null,null,"(หัวข้อใดไม่ประเมินให้เว้นว่างไว้ไม่ต้องพิมพ์อะไรลงไป)"]
[null,"สรุปผลการประเมิน   "]
[{"$nulls":3},"ร.ล./เรือ",{"$f":"IF(E3>0,E3,\"\")","v":""}]
[{"$nulls":3},"ได้คะแนนรวมร้อยละ",{"$nulls":3},{"$f":"IF(M28=0,\"\",M28)","v":""},null,null,"อยู่ในเกณฑ์",{"$f":"IF(H37=\"\",\"\",IF(H37>=90,M32,IF(H37>=80,M31,IF(H37>=70,J31,IF(H37>=60,D32,IF(H37>0,D31,\"\"))))))","v":""}]
[null,"ข้อคิดเห็น/ข้อเสนอแนะ"]
[]
[{"$nulls":12},"ผู้ประเมิน"]
[{"$nulls":8},"         /               /      "]