{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["แผ่นเวลาของพนักงาน","วันในสัปดาห์_การค้นหา"],"not_rendered":{"defined_names":27},"read":"whole","date_system":"1900"}

{"sheet":"แผ่นเวลาของพนักงาน","index":0,"n_rows":36,"n_cols":26,"rows_kept":36,"merged":[[0,1,2,4],[0,5,2,9],[0,10,2,14],[0,15,3,23],[0,24,3,24],[3,1,3,3],[3,5,3,9],[3,10,3,14],[4,1,6,3],[4,4,6,6],[5,14,7,14],[5,22,7,22],[5,23,7,23],[5,24,7,24],[21,1,21,6],[22,1,23,3],[22,4,23,6],[23,14,24,14],[23,22,24,22],[23,23,24,23],[23,24,24,24],[32,1,32,6],[32,24,33,24],[32,25,33,25],[33,1,33,6],[34,1,34,6],[35,1,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,14],[35,15,35,16],[35,17,35,23]]}
[null,"แผ่นเวลาการปฏิบัติงานของพนักงาน",{"$nulls":3},"ชื่อพนักงาน",{"$nulls":9},"เลือก ใช่ ในเซลล์ทางด้านขวาถ้าต้องมีการอนุญาต \nให้ทำงานล่วงเวลา"]
[]
[]
[null,"วันสิ้นสุดของบัญชีเงินเดือน",null,null,{"$f":"V7","v":"2025-06-14"},"หมายเลขพนักงาน"]
[null,"ชั่วโมงทำงานปกติ:",null,null,"วันที่:"]
[{"$nulls":14},"ผลรวม\nสัปดาห์ที่ 1\nปกติ",{"$nulls":7},"ผลรวม\nสัปดาห์ 2\nปกติ","ผลรวม\nปกติ\nชั่วโมง","บัญชีค่าจ้าง\nใช้เท่านั้น\nรหัสจ่ายเงิน"]
[{"$nulls":7},"2025-06-01",{"$f":"วัน_หนึ่ง+1","v":"2025-06-02"},{"$f":"วัน_หนึ่ง+2","v":"2025-06-03"},{"$f":"วัน_หนึ่ง+3","v":"2025-06-04"},{"$f":"วัน_หนึ่ง+4","v":"2025-06-05"},{"$f":"วัน_หนึ่ง+5","v":"2025-06-06"},{"$f":"วัน_หนึ่ง+6","v":"2025-06-07"},null,{"$f":"วัน_หนึ่ง+7","v":"2025-06-08"},{"$f":"วัน_หนึ่ง+8","v":"2025-06-09"},{"$f":"วัน_หนึ่ง+9","v":"2025-06-10"},{"$f":"วัน_หนึ่ง+10","v":"2025-06-11"},{"$f":"วัน_หนึ่ง+11","v":"2025-06-12"},{"$f":"วัน_หนึ่ง+12","v":"2025-06-13"},{"$f":"วัน_หนึ่ง+13","v":"2025-06-14"}]
[null,"งาน","สถานที่","หมายเลขใบสั่งงาน","คำอธิบายงาน","ตำแหน่งงาน","หมายเลขของตำแหน่ง",{"$f":"VLOOKUP(WEEKDAY(วัน_หนึ่ง),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"อา."},{"$f":"VLOOKUP(WEEKDAY(I7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"จ."},{"$f":"VLOOKUP(WEEKDAY(J7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"อ."},{"$f":"VLOOKUP(WEEKDAY(K7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"พ."},{"$f":"VLOOKUP(WEEKDAY(L7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"พฤ."},{"$f":"VLOOKUP(WEEKDAY(M7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"ศ."},{"$f":"VLOOKUP(WEEKDAY(N7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"ส."},null,{"$f":"VLOOKUP(WEEKDAY(P7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"อา."},{"$f":"VLOOKUP(WEEKDAY(Q7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"จ."},{"$f":"VLOOKUP(WEEKDAY(R7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"อ."},{"$f":"VLOOKUP(WEEKDAY(S7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"พ."},{"$f":"VLOOKUP(WEEKDAY(T7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"พฤ."},{"$f":"VLOOKUP(WEEKDAY(U7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"ศ."},{"$f":"VLOOKUP(WEEKDAY(V7),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"ส."}]
[{"$nulls":14},{"$f":"SUM(H9:N9)","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"SUM(P9:V9)","v":{"v":0,"d":"0.00"}},{"$f":"O9+W9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"$f":"SUM(H16:N16)","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"SUM(P16:V16)","v":{"v":0,"d":"0.00"}},{"$f":"O16+W16","v":{"v":0,"d":"0.00"}}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"ชั่วโมงทำงานปกติทั้งหมด   ",{"$nulls":5},{"$f":"SUM(H9:H21)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(Q9:Q21)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(W9:W21)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(X9:X21)","v":{"v":0,"d":"0.00"}}]
[null,"ชั่วโมงทำงานล่วงเวลา:",null,null,"วันที่:"]
[{"$nulls":7},{"$f":"วัน_หนึ่ง","v":"2025-06-01"},{"$f":"วัน_หนึ่ง+1","v":"2025-06-02"},{"$f":"วัน_หนึ่ง+2","v":"2025-06-03"},{"$f":"วัน_หนึ่ง+3","v":"2025-06-04"},{"$f":"วัน_หนึ่ง+4","v":"2025-06-05"},{"$f":"วัน_หนึ่ง+5","v":"2025-06-06"},{"$f":"วัน_หนึ่ง+6","v":"2025-06-07"},"O/T ของสัปดาห์ที่ 1",{"$f":"วัน_หนึ่ง+7","v":"2025-06-08"},{"$f":"วัน_หนึ่ง+8","v":"2025-06-09"},{"$f":"วัน_หนึ่ง+9","v":"2025-06-10"},{"$f":"วัน_หนึ่ง+10","v":"2025-06-11"},{"$f":"วัน_หนึ่ง+11","v":"2025-06-12"},{"$f":"วัน_หนึ่ง+12","v":"2025-06-13"},{"$f":"วัน_หนึ่ง+13","v":"2025-06-14"},"O/T ของสัปดาห์ที่ 2","OT ทั้งหมด","ล่วงเวลา\nรหัส"]
[null,"งาน","สถานที่","หมายเลขใบสั่งงาน","คำอธิบายงาน","ตำแหน่งงาน","หมายเลขของตำแหน่ง",{"$f":"VLOOKUP(WEEKDAY(วัน_หนึ่ง),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"อา."},{"$f":"VLOOKUP(WEEKDAY(I24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"จ."},{"$f":"VLOOKUP(WEEKDAY(J24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"อ."},{"$f":"VLOOKUP(WEEKDAY(K24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"พ."},{"$f":"VLOOKUP(WEEKDAY(L24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"พฤ."},{"$f":"VLOOKUP(WEEKDAY(M24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"ศ."},{"$f":"VLOOKUP(WEEKDAY(N24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"ส."},null,{"$f":"VLOOKUP(WEEKDAY(P24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"อา."},{"$f":"VLOOKUP(WEEKDAY(Q24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"จ."},{"$f":"VLOOKUP(WEEKDAY(R24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"อ."},{"$f":"VLOOKUP(WEEKDAY(S24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"พ."},{"$f":"VLOOKUP(WEEKDAY(T24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"พฤ."},{"$f":"VLOOKUP(WEEKDAY(U24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"ศ."},{"$f":"VLOOKUP(WEEKDAY(V24),วันในสัปดาห์_การค้นหา!$B$2:$C$8,2)","v":"ส."}]
[{"$nulls":14},{"$f":"SUM(H26:N26)","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"SUM(P26:V26)","v":{"v":0,"d":"0.00"}},{"$f":"O26+W26","v":{"v":0,"d":"0.00"}}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":14},{"v":0,"d":"0.00"},{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"ชั่วโมงทำงานล่วงเวลาทั้งหมด     ",{"$nulls":5},{"$f":"SUM(H26:H32)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(O26:O32)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(P33:V33)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(X26:X32)","v":{"v":0,"d":"0.00"}},"ผลรวม\nชั่วโมง\nทำงาน","ผลรวม\nชั่วโมง\nชำระเงินแล้ว"]
[null,"ค่าตอบแทนสำหรับการทำงานล่วงเวลา     ",{"$nulls":12},{"$f":"IF(SUM(H34:N34)<=O33,SUM(H34:N34),O33)","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(SUM(P34:V34)<=W33,SUM(P34:V34),W33)","v":{"v":0,"d":"0.00"}},{"$f":"IF(SUM(Q34:W34)<=X33,SUM(Q34:W34),X33)","v":{"v":0,"d":"0.00"}}]
[null,"ค่าล่วงเวลา     ",{"$nulls":5},{"$f":"IF(H33>=H34,H33-H34,H33)","v":{"v":0,"d":"0.00"}},{"$f":"IF(I33>=I34,I33-I34,I33)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(W33>=W34,W33-W34,W33)","v":{"v":0,"d":"0.00"}},{"$f":"IF(X33>=X34,X33-X34,X33)","v":{"v":0,"d":"0.00"}},{"$f":"$X$22+$X$33","v":{"v":0,"d":"0.00"}},{"$f":"X22+X35","v":{"v":0,"d":"0.00"}}]
[null,"พนักงาน ",{"$nulls":4},"หัวหน้างาน ",{"$nulls":8},"หัวหน้างาน "]

{"sheet":"วันในสัปดาห์_การค้นหา","index":1,"n_rows":8,"n_cols":3,"rows_kept":8}
[null,"วันทำงาน\nเลขวัน","วันทำงาน\nชื่อย่อ"]
[null,1,"อา."]
[null,2,"จ."]
[null,3,"อ."]
[null,4,"พ."]
[null,5,"พฤ."]
[null,6,"ศ."]
[null,7,"ส."]