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

{"sheet":"2205-2","index":0,"n_rows":66,"n_cols":22,"rows_kept":66,"merged":[[0,0,0,15],[1,0,1,15],[3,4,3,15],[4,1,4,9],[4,11,4,15],[5,5,5,15],[7,0,9,0],[7,1,9,9],[7,10,9,10],[7,11,7,13],[7,14,9,14],[7,15,9,15],[13,0,13,13],[14,0,14,13],[15,0,15,13],[20,0,20,13],[21,0,21,13],[22,0,22,13],[23,0,23,13],[29,0,29,13],[30,0,30,13],[31,0,31,13],[38,0,38,13],[39,0,39,13],[40,0,40,13],[41,0,41,13],[42,0,42,13],[58,7,58,14],[59,7,59,9],[59,12,59,14],[61,1,61,15],[62,1,62,15],[65,9,65,13],[67,0,67,18],[68,0,68,18],[69,0,69,18],[70,0,70,18],[71,0,71,18],[72,0,72,18],[73,0,73,18],[74,0,74,18]]}
["แบบการประเมินความพร้อมของเรือ"]
["สาขา อาวุธปล่อยนำวิถี ESSM (องค์วัตถุ)"]
[]
["หน่วย/เรือที่รับการประเมิน"]
["ผู้ประเมิน",{"$nulls":9},"ตำแหน่ง","ครูประเมินสาขาอาวุธปล่อยนำวิถี"]
["วันที่และช่วงเวลาในการประเมิน"]
[]
["หัวข้อ","รายการ",{"$nulls":8},"น้ำหนัก\nคะแนน","คะแนนการประเมิน",null,null,"คะแนน\nที่ได้","หมายเหตุ",2,1,0,"รวม"]
[{"$nulls":11},"ใช้งานได้/\nเชื่อถือได้","ใช้งานได้","ไม่สามารถ\nใช้งานได้"]
[{"$nulls":11},2,1,0]
[1,"ส่วนสำคัญ",{"$nulls":6},70,"คะแนน"]
[null,1.1,"ระบบอำนวยการรบ 9LV"]
[null,"1.1.1","การรับส่งข้อมูลให้ คคย.",{"$nulls":7},{"v":4,"d":"4.00"},{"$nulls":3},{"$f":"IF(T13>0,T13,\"\")","v":""},null,{"$f":"IF(L13=0,0,K13*2)","v":0},{"$f":"IF(M13=0,0,K13*1)","v":0},{"$f":"IF(N13=0,0,0)","v":0},{"$f":"SUM(Q13:S13)","v":0},{"$f":"IF(P13=\"\",0,K13*2)","v":0}]
["รวมคะแนนที่ประเมินได้",{"$nulls":13},{"$f":"IF(T14>0,T14,\"\")","v":""},"คะแนน",{"$f":"SUM(Q13:Q13)","v":0},{"$f":"SUM(R13:R13)","v":0},{"$f":"SUM(S13:S13)","v":0},{"$f":"SUM(T13:T13)","v":0},{"$f":"SUM(U13:U13)","v":0}]
["รวมคะแนนเต็มเฉพาะรายการที่ประเมินได้",{"$nulls":13},{"$f":"IF(T14=0,\"\",R15)","v":""},"นน.คะแนน",{"$f":"SUM(K13:K13)","v":{"v":4,"d":"4.0"}},{"$f":"IF(T14=0,\"\",IF(U14=0,Q15,Q15-(U14/2)))","v":""}]
["รวมคะแนนระบบอำนวยการรบ 9LV  100 คะแนน ",{"$nulls":13},{"$f":"IF(R16=0,\"\",R16)","v":""},"ร้อยละ",{"$f":"IF(Q15<0,0,(T14+U14)/2)","v":0},{"$f":"IF(Q16=0,0,Q16*100/Q15)","v":0},{"$nulls":3},{"$f":"IF(R16=0,0,1)","v":0}]
[null,1.2,"คคย.CEROS 200"]
[null,"1.2.1","Combine Antena System (อุปกรณ์ตรวจจับ)",{"$nulls":7},{"v":4,"d":"4.00"},{"$nulls":3},{"$f":"IF(T18>0,T18,\"\")","v":""},null,{"$f":"IF(L18=0,0,K18*2)","v":0},{"$f":"IF(M18=0,0,K18*1)","v":0},{"$f":"IF(N18=0,0,0)","v":0},{"$f":"SUM(Q18:S18)","v":0},{"$f":"IF(P18=\"\",0,K18*2)","v":0}]
[null,"1.2.2","Weapon Control Console (เครื่องคำนวณ)",{"$nulls":7},{"v":4,"d":"4.00"},{"$nulls":3},"",null,{"$f":"IF(L19=0,0,K19*2)","v":0},{"$f":"IF(M19=0,0,K19*1)","v":0},{"$f":"IF(N19=0,0,0)","v":0},0,{"$f":"IF(P19=\"\",0,K19*2)","v":0}]
[null,"1.2.3","Tactical Display Console (จอแสดงผล)",{"$nulls":7},{"v":4,"d":"4.00"},{"$nulls":3},"",null,{"$f":"IF(L20=0,0,K20*2)","v":0},{"$f":"IF(M20=0,0,K20*1)","v":0},{"$f":"IF(N20=0,0,0)","v":0},0,{"$f":"IF(P20=\"\",0,K20*2)","v":0}]
["รวมคะแนนที่ประเมินได้",{"$nulls":13},{"$f":"IF(T21>0,T21,\"\")","v":""},"คะแนน",{"$f":"SUM(Q18:Q20)","v":0},{"$f":"SUM(R18:R20)","v":0},{"$f":"SUM(S18:S20)","v":0},{"$f":"SUM(T18:T20)","v":0},{"$f":"SUM(U18:U20)","v":0}]
["รวมคะแนนเต็มเฉพาะรายการที่ประเมินได้",{"$nulls":13},{"$f":"IF(T21=0,\"\",R22)","v":""},"นน.คะแนน",{"$f":"SUM(K18:K20)","v":{"v":12,"d":"12.0"}},{"$f":"IF(T21=0,\"\",IF(U21=0,Q22,Q22-(U21/2)))","v":""}]
["รวมคะแนน คคย.CEROS 200  100 คะแนน ",{"$nulls":13},{"$f":"IF(R23=0,\"\",R23)","v":""},"ร้อยละ",{"$f":"IF(Q22<0,0,(T21+U21)/2)","v":0},{"$f":"IF(Q23=0,0,Q23*100/Q22)","v":0},{"$nulls":3},{"$f":"IF(R23=0,0,1)","v":0}]
["รวมคะแนนส่วนสำคัญ 70 คะแนน",{"$nulls":13},{"$f":"IF(Q24=0,\"\",R24)","v":""},"คะแนน",{"$f":"IF(T24>0,(R16+R23)/T24,0)","v":0},{"$f":"Q24*I11/100","v":0},null,{"$f":"SUM(V16:V23)","v":0},null,{"$f":"IF(T24=0,0,1)","v":0}]
[2,"ส่วนทั่วไป",{"$nulls":6},30,"คะแนน"]
[null,2.1,"ระบบแท่นยิงอาวุธปล่อยนำวิถีแนวตั้ง (VLS MK 41)"]
[null,"2.1.1","ความมั่นคง แข็งแรงของแท่นยิง",{"$nulls":7},{"v":4,"d":"4.00"},{"$nulls":3},{"$f":"IF(T27>0,T27,\"\")","v":""},null,{"$f":"IF(L27=0,0,K27*2)","v":0},{"$f":"IF(M27=0,0,K27*1)","v":0},{"$f":"IF(N27=0,0,0)","v":0},{"$f":"SUM(Q27:S27)","v":0},{"$f":"IF(P27=\"\",0,K27*2)","v":0}]
[null,"2.1.2","ความมั่นคง แข็งแรงของท่อยิง",{"$nulls":7},{"v":4,"d":"4.00"},{"$nulls":3},"",null,{"$f":"IF(L28=0,0,K28*2)","v":0},{"$f":"IF(M28=0,0,K28*1)","v":0},{"$f":"IF(N28=0,0,0)","v":0},0,{"$f":"IF(P28=\"\",0,K28*2)","v":0}]
[null,"2.1.3","อุปกรณ์สนับสนุน",{"$nulls":7},{"v":4,"d":"4.00"},{"$nulls":3},"",null,{"$f":"IF(L29=0,0,K29*2)","v":0},{"$f":"IF(M29=0,0,K29*1)","v":0},{"$f":"IF(N29=0,0,0)","v":0},0,{"$f":"IF(P29=\"\",0,K29*2)","v":0}]
["รวมคะแนนที่ประเมินได้",{"$nulls":13},{"$f":"IF(T30>0,T30,\"\")","v":""},"คะแนน",{"$f":"SUM(Q27:Q29)","v":0},{"$f":"SUM(R27:R29)","v":0},{"$f":"SUM(S27:S29)","v":0},{"$f":"SUM(T27:T29)","v":0},{"$f":"SUM(U27:U29)","v":0}]
["รวมคะแนนเต็มเฉพาะรายการที่ประเมินได้",{"$nulls":13},{"$f":"IF(T30=0,\"\",R31)","v":""},"นน.คะแนน",{"$f":"SUM(K27:K29)","v":{"v":12,"d":"12.0"}},{"$f":"IF(T30=0,\"\",IF(U30=0,Q31,Q31-(U30/2)))","v":""}]
["รวมคะแนนแท่นยิง 25 คะแนน ",{"$nulls":13},{"$f":"IF(R32=0,\"\",R32)","v":""},"ร้อยละ",{"$f":"IF(Q31<0,0,(T30+U30)/2)","v":0},{"$f":"IF(Q32=0,0,Q32*100/Q31)","v":0},{"$f":"R32*25/100","v":0},null,null,{"$f":"IF(S32=0,0,1)","v":0}]
[null,2.2,"เอกสาร"]
[null,"2.2.1","บัญชี สพ.3",{"$nulls":7},{"v":1,"d":"1.00"},{"$nulls":3},{"$f":"IF(T34>0,T34,\"\")","v":""},null,{"$f":"IF(L34=0,0,K34*2)","v":0},{"$f":"IF(M34=0,0,K34*1)","v":0},{"$f":"IF(N34=0,0,0)","v":0},{"$f":"SUM(Q34:S34)","v":0},{"$f":"IF(P34=\"\",0,K34*2)","v":0}]
[null,"2.2.2","ประวัติอาวุธปล่อยนำวิถี",{"$nulls":7},{"v":1,"d":"1.00"},{"$nulls":3},"",null,{"$f":"IF(L35=0,0,K35*2)","v":0},{"$f":"IF(M35=0,0,K35*1)","v":0},{"$f":"IF(N35=0,0,0)","v":0},0,{"$f":"IF(P35=\"\",0,K35*2)","v":0}]
[null,"2.2.3","คู่มือ",{"$nulls":7},{"v":1,"d":"1.00"},{"$nulls":3},"",null,{"$f":"IF(L36=0,0,K36*2)","v":0},{"$f":"IF(M36=0,0,K36*1)","v":0},{"$f":"IF(N36=0,0,0)","v":0},0,{"$f":"IF(P36=\"\",0,K36*2)","v":0}]
[null,"2.2.4","ลยอ.",{"$nulls":7},{"v":1,"d":"1.00"},{"$nulls":3},"",null,{"$f":"IF(L37=0,0,K37*2)","v":0},{"$f":"IF(M37=0,0,K37*1)","v":0},{"$f":"IF(N37=0,0,0)","v":0},0,{"$f":"IF(P37=\"\",0,K37*2)","v":0}]
[null,"2.2.5","ขกส.",{"$nulls":7},{"v":1,"d":"1.00"},{"$nulls":3},"",null,{"$f":"IF(L38=0,0,K38*2)","v":0},{"$f":"IF(M38=0,0,K38*1)","v":0},{"$f":"IF(N38=0,0,0)","v":0},0,{"$f":"IF(P38=\"\",0,K38*2)","v":0}]
["รวมคะแนนที่ประเมินได้",{"$nulls":13},{"$f":"IF(T39>0,T39,\"\")","v":""},"คะแนน",{"$f":"SUM(Q34:Q38)","v":0},{"$f":"SUM(R34:R38)","v":0},{"$f":"SUM(S34:S38)","v":0},{"$f":"SUM(T34:T38)","v":0},{"$f":"SUM(U34:U38)","v":0}]
["รวมคะแนนเต็มเฉพาะรายการที่ประเมินได้",{"$nulls":13},{"$f":"IF(T39=0,\"\",R40)","v":""},"นน.คะแนน",{"$f":"SUM(K34:K38)","v":{"v":5,"d":"5.0"}},{"$f":"IF(T39=0,\"\",IF(U39=0,Q40,Q40-(U39/2)))","v":""}]
["รวมคะแนนเอกสาร 5 คะแนน ",{"$nulls":13},{"$f":"IF(R41=0,\"\",R41)","v":""},"ร้อยละ",{"$f":"IF(Q40<0,0,(T39+U39)/2)","v":0},{"$f":"IF(Q41=0,0,Q41*100/Q40)","v":0},{"$f":"R41*5/100","v":0},null,null,{"$f":"IF(S41=0,0,1)","v":0}]
["รวมคะแนนส่วนทั่วไป 30 คะแนน",{"$nulls":13},{"$f":"IF(Q42=0,\"\",R42)","v":""},"คะแนน",{"$f":"IF(T42>0,(R32+R41)/T42,0)","v":0},{"$f":"Q42*I25/100","v":0},null,{"$f":"SUM(V32:V41)","v":0},null,{"$f":"IF(T42=0,0,1)","v":0}]
["รวมคะแนนทั้งหมด",{"$nulls":13},{"$f":"IF(Q43=0,\"\",Q43)","v":""},"คะแนน",{"$f":"IF(V43=0,0,R24+R42)","v":0},{"$nulls":4},{"$f":"V42+V24","v":0}]
[null,"คำแนะนำในการประเมิน"]
[null,1,"เกณฑ์การให้คะแนน"]
[null,null,"-","ใช้งานได้ / เชื่อถือได้",{"$nulls":4},2,"คะแนน"]
[null,null,"-","ใช้งานได้ ",{"$nulls":4},1,"คะแนน"]
[null,null,"-","ไม่สามารถใช้งานได้ ",{"$nulls":4},0,"คะแนน"]
[null,2,"คิดคะแนนเป็นร้อยละ โดยคิดจากร้อยละคะแนนเต็มตามหัวข้อที่ประเมินได้ และมีบรรจุตามอัตราเรือ"]
[null,null,"(หัวข้อใดไม่ประเมินให้เว้นว่างไว้ไม่ต้องพิมพ์อะไรลงไป)"]
[null,3,"เกณฑ์การประเมิน"]
[null,null,"ดีมาก",null,null,"90 - 100"]
[null,null,"ดี",null,null,"80 - 89"]
[null,null,"ปานกลาง",null,null,"70 - 79"]
[null,null,"พอใช้",null,null,"60 - 69"]
[null,null,"ต้องปรับปรุง",null,null,"0 - 59"]
[null,4,"ผลรวมของคะแนนองค์ยุทธวิธีในกรณีมีการยิง/ปล่อย อาวุธใต้น้ำในทะเล  "]
[null,null,"   = (คะแนนจากผลการยิง คูณ ตัวเกณฑ์ 70%)+(คะแนนวิธีปฏิบัติในการยิง คูณ ตัวเกณฑ์ 30%)"]
[null,"สรุปผลการประเมิน   ",{"$nulls":4},"ร.ล./เรือ",{"$f":"IF(C3=0,\"\",C3)","v":""}]
[{"$nulls":6},"ได้คะแนนรวมร้อยละ",{"$f":"IF(Q43=0,\"\",Q43)","v":""},{"$nulls":3},"อยู่ในเกณฑ์",{"$f":"IF(Q43>=90,C52,IF(Q43>=80,C53,IF(Q43>=70,C54,IF(Q43>=60,C55,IF(Q43>0,C56,\"\")))))","v":""}]
[null,"ข้อคิดเห็น/ข้อเสนอแนะ"]
[]
[]
[]
[{"$nulls":14},"ผู้ประเมิน"]
[{"$nulls":9},"/           /"]