{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Sheet1","index":0,"n_rows":2015,"n_cols":203,"rows_kept":2015,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. กดปุ่มวิเคราะห์ข้อมูล"]
[null,null,null,null,null,null,null,null,null,null,null,"ทองจุล ขันขาว"]
[null,null,null,null,null,null,null,null,null,null,null,"http://www.thongjoon.com"]
[]
[null,"จำนวนแบบทดสอบ",null,8,"ฉบับ",null,"ลักษณะตัวเลือก",null,null,"ก","ข","ค","ง","จ",null,null,"ข้อสอบแต่ละฉบับ มีจำนวน",null,null,null,null,5,"ข้อ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(จำนวนข้อสูงสุด ไม่เกิน 200 ข้อ นะครับ)"]
[null,"1. กำหนดข้อที่ถูกของทุกข้อคำถาม"]
[null,"ข้อ",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100]
[null,"คำตอบที่ถูก","ค","ง","ก","ข","ง"]
[]
[null,"2. กรอกคำตอบของผู้ทำแบบทดสอบ แต่ละคน (สูงสุด ไม่เกิน 2,000 คน)"]
[null,"ฉบับ\\ข้อ",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100]
[null,1,"ค","ข","ก","ง","ค"]
[null,2,"ค","ข","ค","ข","ข"]
[null,3,"ค","ง","ข","ข","ง"]
[null,4,"ค","ข","ข","ค","ก"]
[null,5,"ค","ค","ง","ข","ก"]
[null,6,"ก","ข","ก","ก","ข"]
[null,7,"ค","ข","ข","ข","ง"]
[null,8,"ง","จ","ก","ง","ง"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["เลยบรรทัดนี้ไป เป็นข้อสอบฉบับที่ 2001 แล้วครับ ผมเตรียมวิเคราะห์ไว้แค่ 2000 ฉบับ นะครับ -- ถ้าต้องการมากกว่านี้ ติดต่อ thongjoon@yahoo.com.sg หรือ thongjoon@gmail.com"]

{"sheet":"Sheet2","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"ผลการวิเคราะห์ข้อสอบของท่าน"]
[]
[null,"จำนวนข้อสอบ (N) = 8"]
[]
[null,"คำถามข้อที่",1,2,3,4,5]
[null,"ตอบถูก",6,1,3,4,3]
[null,"ตอบผิด",2,7,5,4,5]
[null,"pi",0.75,0.125,0.375,0.5,0.375]
[null,"qi",0.25,0.875,0.625,0.5,0.625]
[null,"piqi",0.1875,0.109375,0.234375,0.25,0.234375]
[]
[null,"ร้อยละการเลือกตัวเลือกแต่ละข้อ"]
[null,"ข้อ",1,2,3,4,5]
[null,"ข้อ ก",12.5,0,37.5,12.5,25]
[null,"ข้อ ข",0,62.5,37.5,50,25]
[null,"ข้อ ค",75,12.5,12.5,12.5,12.5]
[null,"ข้อ ง",12.5,12.5,12.5,25,37.5]
[null,"ข้อ จ",0,12.5,0,0,0]
[null,"รวม",100,100,100,100,100]
[]
[null,"IF total (รวม)",0.75,0.125,0.375,0.5,0.375]
[null,"IF Upper (กลุ่มสูง)",1,0.25,0.25,0.75,0.5]
[null,"IF Lower (กลุ่มต่ำ)",0.5,0,0.5,0.25,0.25]
[null,"ID (อำนาจจำแนก)",0.5,0.25,-0.25,0.5,0.25]
[]
[null,"Reliability(KR-20)",-0.23]
[null,"คะแนนเฉลี่ย",2.13]
[null,"S.D.",0.93]
[null,"SEM",1.03]
[]
[null,"ความยาก-ง่าย (IF total)","ดีพอใช้","ยากมาก-ตัดทิ้ง","ดีพอใช้","ดีมาก","ดีพอใช้"]
[null,"อำนาจจำแนก (ID)","ดี","พอใช้ได้","ตัดทิ้ง","ดี","พอใช้ได้"]

{"sheet":"Sheet3","index":2,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"ข้อ",1,2,3,4,5]
[null,"คำตอบที่ถูก","ค","ง","ก","ข","ง"]
[]
[null,"2. กรอกคำตอบของผู้ทำแบบทดสอบ แต่ละคน (สูงสุด ไม่เกิน 2,000 คน)"]
[null,"ฉบับ\\ข้อ",1,2,3,4,5]
[null,1,"ค","ข","ก","ง","ค"]
[null,2,"ค","ข","ค","ข","ข"]
[null,3,"ค","ง","ข","ข","ง"]
[null,4,"ค","ข","ข","ค","ก"]
[null,5,"ค","ค","ง","ข","ก"]
[null,6,"ก","ข","ก","ก","ข"]
[null,7,"ค","ข","ข","ข","ง"]
[null,8,"ง","จ","ก","ง","ง"]
[]
[null,"ผลการตรวจและเรียงคะแนนจากมากไปหาน้อย"]
[null,"ฉบับที่\\ข้อที่",1,2,3,4,5,"X","X2"]
[null,3,1,1,0,1,1,4,{"$f":"H19^2","v":16}]
[null,7,1,0,0,1,1,3,{"$f":"H20^2","v":9}]
[null,1,1,0,1,0,0,2,4]
[null,2,1,0,0,1,0,2,4]
[null,5,1,0,0,1,0,2,4]
[null,8,0,0,1,0,1,2,4]
[null,4,1,0,0,0,0,1,1]
[null,6,0,0,1,0,0,1,1]
[null,null,null,null,null,null,null,{"$f":"SUM(H19:H26)","v":17},{"$f":"SUM(I19:I26)","v":43}]
[null,"คำถามข้อที่",1,2,3,4,5]
[null,"ตอบถูก",{"$f":"COUNTIF(C19:C26,1)","v":6},{"$f":"COUNTIF(D19:D26,1)","v":1},{"$f":"COUNTIF(E19:E26,1)","v":3},{"$f":"COUNTIF(F19:F26,1)","v":4},{"$f":"COUNTIF(G19:G26,1)","v":3}]
[null,"ตอบผิด",{"$f":"COUNTIF(C19:C26,0)","v":2},{"$f":"COUNTIF(D19:D26,0)","v":7},{"$f":"COUNTIF(E19:E26,0)","v":5},{"$f":"COUNTIF(F19:F26,0)","v":4},{"$f":"COUNTIF(G19:G26,0)","v":5}]
[null,"pi",{"$f":"29:29/8","v":0.75},{"$f":"29:29/8","v":0.125},{"$f":"29:29/8","v":0.375},{"$f":"29:29/8","v":0.5},{"$f":"29:29/8","v":0.375}]
[null,"qi",{"$f":"30:30/8","v":0.25},{"$f":"30:30/8","v":0.875},{"$f":"30:30/8","v":0.625},{"$f":"30:30/8","v":0.5},{"$f":"30:30/8","v":0.625}]
[null,"piqi",{"$f":"C31 * C32","v":0.1875},{"$f":"D31 * D32","v":0.109375},{"$f":"E31 * E32","v":0.234375},{"$f":"F31 * F32","v":0.25},{"$f":"G31 * G32","v":0.234375},null,{"$f":"SUM(C33:G33)","v":1.015625}]
[]
[null,"ร้อยละการเลือกตัวเลือกแต่ละข้อ"]
[null,"ข้อ",1,2,3,4,5]
[null,"ข้อ ก",{"$f":"COUNTIF(C8:C15,\"ก\") / 8 * 100","v":12.5},{"$f":"COUNTIF(D8:D15,\"ก\") / 8 * 100","v":0},{"$f":"COUNTIF(E8:E15,\"ก\") / 8 * 100","v":37.5},{"$f":"COUNTIF(F8:F15,\"ก\") / 8 * 100","v":12.5},{"$f":"COUNTIF(G8:G15,\"ก\") / 8 * 100","v":25}]
[null,"ข้อ ข",{"$f":"COUNTIF(C8:C15,\"ข\") / 8 * 100","v":0},{"$f":"COUNTIF(D8:D15,\"ข\") / 8 * 100","v":62.5},{"$f":"COUNTIF(E8:E15,\"ข\") / 8 * 100","v":37.5},{"$f":"COUNTIF(F8:F15,\"ข\") / 8 * 100","v":50},{"$f":"COUNTIF(G8:G15,\"ข\") / 8 * 100","v":25}]
[null,"ข้อ ค",{"$f":"COUNTIF(C8:C15,\"ค\") / 8 * 100","v":75},{"$f":"COUNTIF(D8:D15,\"ค\") / 8 * 100","v":12.5},{"$f":"COUNTIF(E8:E15,\"ค\") / 8 * 100","v":12.5},{"$f":"COUNTIF(F8:F15,\"ค\") / 8 * 100","v":12.5},{"$f":"COUNTIF(G8:G15,\"ค\") / 8 * 100","v":12.5}]
[null,"ข้อ ง",{"$f":"COUNTIF(C8:C15,\"ง\") / 8 * 100","v":12.5},{"$f":"COUNTIF(D8:D15,\"ง\") / 8 * 100","v":12.5},{"$f":"COUNTIF(E8:E15,\"ง\") / 8 * 100","v":12.5},{"$f":"COUNTIF(F8:F15,\"ง\") / 8 * 100","v":25},{"$f":"COUNTIF(G8:G15,\"ง\") / 8 * 100","v":37.5}]
[null,"ข้อ จ",{"$f":"COUNTIF(C8:C15,\"จ\") / 8 * 100","v":0},{"$f":"COUNTIF(D8:D15,\"จ\") / 8 * 100","v":12.5},{"$f":"COUNTIF(E8:E15,\"จ\") / 8 * 100","v":0},{"$f":"COUNTIF(F8:F15,\"จ\") / 8 * 100","v":0},{"$f":"COUNTIF(G8:G15,\"จ\") / 8 * 100","v":0}]
[null,"รวม",{"$f":"SUM(C37:C41)","v":100},{"$f":"SUM(D37:D41)","v":100},{"$f":"SUM(E37:E41)","v":100},{"$f":"SUM(F37:F41)","v":100},{"$f":"SUM(G37:G41)","v":100}]
[]
[null,"IF total (รวม)",{"$f":"SUM(C19:C26)/8","v":0.75},{"$f":"SUM(D19:D26)/8","v":0.125},{"$f":"SUM(E19:E26)/8","v":0.375},{"$f":"SUM(F19:F26)/8","v":0.5},{"$f":"SUM(G19:G26)/8","v":0.375}]
[null,"IF Upper (กลุ่มสูง)",{"$f":"SUM(C19:C22)/4","v":1},{"$f":"SUM(D19:D22)/4","v":0.25},{"$f":"SUM(E19:E22)/4","v":0.25},{"$f":"SUM(F19:F22)/4","v":0.75},{"$f":"SUM(G19:G22)/4","v":0.5}]
[null,"IF Lower (กลุ่มต่ำ)",{"$f":"SUM(C23:C26)/4","v":0.5},{"$f":"SUM(D23:D26)/4","v":0},{"$f":"SUM(E23:E26)/4","v":0.5},{"$f":"SUM(F23:F26)/4","v":0.25},{"$f":"SUM(G23:G26)/4","v":0.25}]
[null,"ID (อำนาจจำแนก)",{"$f":"C45-C46","v":0.5},{"$f":"D45-D46","v":0.25},{"$f":"E45-E46","v":-0.25},{"$f":"F45-F46","v":0.5},{"$f":"G45-G46","v":0.25}]
[]
[null,"Reliability(KR-20)",-0.23]
[null,"คะแนนเฉลี่ย",2.13]
[null,"S.D.",0.93]
[null,"SEM",1.03]
[]
[null,"ความยาก-ง่าย (IF total)",{"$f":"IF(C44 > 0.8,\"ง่ายมาก-ตัดทิ้ง\",IF(C44 > 0.6,\"ดีพอใช้\",IF(C44 >0.4,\"ดีมาก\",IF(C44 >0.19,\"ดีพอใช้\",\"ยากมาก-ตัดทิ้ง\"))))","v":"ดีพอใช้"},{"$f":"IF(D44 > 0.8,\"ง่ายมาก-ตัดทิ้ง\",IF(D44 > 0.6,\"ดีพอใช้\",IF(D44 >0.4,\"ดีมาก\",IF(D44 >0.19,\"ดีพอใช้\",\"ยากมาก-ตัดทิ้ง\"))))","v":"ยากมาก-ตัดทิ้ง"},{"$f":"IF(E44 > 0.8,\"ง่ายมาก-ตัดทิ้ง\",IF(E44 > 0.6,\"ดีพอใช้\",IF(E44 >0.4,\"ดีมาก\",IF(E44 >0.19,\"ดีพอใช้\",\"ยากมาก-ตัดทิ้ง\"))))","v":"ดีพอใช้"},{"$f":"IF(F44 > 0.8,\"ง่ายมาก-ตัดทิ้ง\",IF(F44 > 0.6,\"ดีพอใช้\",IF(F44 >0.4,\"ดีมาก\",IF(F44 >0.19,\"ดีพอใช้\",\"ยากมาก-ตัดทิ้ง\"))))","v":"ดีมาก"},{"$f":"IF(G44 > 0.8,\"ง่ายมาก-ตัดทิ้ง\",IF(G44 > 0.6,\"ดีพอใช้\",IF(G44 >0.4,\"ดีมาก\",IF(G44 >0.19,\"ดีพอใช้\",\"ยากมาก-ตัดทิ้ง\"))))","v":"ดีพอใช้"}]
[null,"อำนาจจำแนก (ID)",{"$f":"IF(C47 >= 0.6,\"ดีมาก\",IF(C47 > 0.4,\"ดี\",IF(C47 >0.2,\"พอใช้ได้\",IF(C47 >0,\"ค่อนข้างต่ำ\",\"ตัดทิ้ง\"))))","v":"ดี"},{"$f":"IF(D47 >= 0.6,\"ดีมาก\",IF(D47 > 0.4,\"ดี\",IF(D47 >0.2,\"พอใช้ได้\",IF(D47 >0,\"ค่อนข้างต่ำ\",\"ตัดทิ้ง\"))))","v":"พอใช้ได้"},{"$f":"IF(E47 >= 0.6,\"ดีมาก\",IF(E47 > 0.4,\"ดี\",IF(E47 >0.2,\"พอใช้ได้\",IF(E47 >0,\"ค่อนข้างต่ำ\",\"ตัดทิ้ง\"))))","v":"ตัดทิ้ง"},{"$f":"IF(F47 >= 0.6,\"ดีมาก\",IF(F47 > 0.4,\"ดี\",IF(F47 >0.2,\"พอใช้ได้\",IF(F47 >0,\"ค่อนข้างต่ำ\",\"ตัดทิ้ง\"))))","v":"ดี"},{"$f":"IF(G47 >= 0.6,\"ดีมาก\",IF(G47 > 0.4,\"ดี\",IF(G47 >0.2,\"พอใช้ได้\",IF(G47 >0,\"ค่อนข้างต่ำ\",\"ตัดทิ้ง\"))))","v":"พอใช้ได้"}]