{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["การฝากเงิน","การเบิกถอน"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"การฝากเงิน","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,3,2]]}
[null,"รายเดือน\nธนาคาร\nใบแจ้งยอด",null,"เดือน","ยอดคงเหลือก่อนหน้า","ยอดเงินฝากรวม"]
[{"$nulls":3},{"$f":"UPPER(TEXT(TODAY(),\"mmmm\"))","v":"พฤษภาคม"},{"v":2525.54,"d":"฿2,525.54"},{"$f":"Deposit_total","v":{"v":5400,"d":"฿5,400.00"}}]
[{"$nulls":3},"ปี","ยอดดุลสิ้นสุด","การเบิกถอนทั้งหมด"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2018},{"$f":"IFERROR(ยอดดุลสิ้นสุด+Deposit_total-Withdrawls_total, \"\")","v":{"v":6550.54,"d":"฿6,550.54"}},{"$f":"Withdrawls_total","v":{"v":1375,"d":"฿1,375.00"}}]
[null,"การฝากเงิน"]
[null,"หมายเลขการนำฝาก","วันที่","จำนวน","คำอธิบาย","กระทบยอดแล้ว"]
[null,{"$f":"ROW()-ROW(การฝากเงิน[[#Headers],[หมายเลขการนำฝาก]])","v":1},{"$f":"TODAY()-15","v":"2018-05-01"},{"v":1500,"d":"฿1,500.00"},"งาน 1, เช็ค 1","ใช่"]
[null,{"$f":"ROW()-ROW(การฝากเงิน[[#Headers],[หมายเลขการนำฝาก]])","v":2},{"$f":"TODAY()-10","v":"2018-05-06"},{"v":1200,"d":"฿1,200.00"},"งาน 2, เช็ค 1","ใช่"]
[null,{"$f":"ROW()-ROW(การฝากเงิน[[#Headers],[หมายเลขการนำฝาก]])","v":3},{"$f":"TODAY()-5","v":"2018-05-11"},{"v":1500,"d":"฿1,500.00"},"งาน 1, เช็ค 2","ใช่"]
[null,{"$f":"ROW()-ROW(การฝากเงิน[[#Headers],[หมายเลขการนำฝาก]])","v":4},{"$f":"TODAY()","v":"2018-05-16"},{"v":1200,"d":"฿1,200.00"},"งาน 2, เช็ค 2","ใช่"]
[null,"ผลรวม",null,{"$f":"SUBTOTAL(109,การฝากเงิน[จำนวน])","v":{"v":5400,"d":"฿5,400.00"}}]

{"sheet":"การเบิกถอน","index":1,"n_rows":8,"n_cols":6,"rows_kept":8}
[null,"การเบิกถอน"]
[null,"ชนิด","วันที่","จำนวน","สำหรับ","กระทบยอดแล้ว"]
[null,"เช็ค 1001",{"$f":"TODAY()-8","v":"2018-05-08"},{"v":150,"d":"฿150.00"},"ไฟฟ้า","ใช่"]
[null,"เช็ค 1002",{"$f":"TODAY()-6","v":"2018-05-10"},{"v":150,"d":"฿150.00"},"น้ำ/ท่อระบาย/ขยะ","ใช่"]
[null,"เช็ค 1003",{"$f":"TODAY()-4","v":"2018-05-12"},{"v":850,"d":"฿850.00"},"จำนอง","ใช่"]
[null,"เดบิต",{"$f":"TODAY()-2","v":"2018-05-14"},{"v":125,"d":"฿125.00"},"ของชำ","ใช่"]
[null,"ATM",{"$f":"TODAY()","v":"2018-05-16"},{"v":100,"d":"฿100.00"},"เงินสด","ใช่"]
[null,"ผลรวม",null,{"$f":"SUBTOTAL(109,เช็ค[จำนวน])","v":{"v":1375,"d":"฿1,375.00"}}]