{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["HOME","Phatsinh","In-Chi","In-Thu","SOQUY","CDPS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":31,"comments":0,"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":"HOME","index":0,"n_rows":18,"n_cols":24,"rows_kept":18,"cut":false,"hidden":false,"merged":[[7,2,7,4],[7,6,7,13],[3,2,3,13],[5,2,5,4],[5,6,5,13],[6,2,6,4],[6,6,6,13],[12,2,12,4],[12,6,12,13],[9,2,9,4],[9,6,9,13],[10,2,10,4],[10,6,10,13],[11,2,11,4],[11,6,11,13]]}
[]
[]
[]
[null,null,"THÔNG TIN DOANH NGHIỆP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. KHAI BÁO DANH MỤC",null,null,null,null,null,null,null,"Click xem"]
[null,null,"Công ty",null,null,":","TAICHINHCANHAN.PRO.VN",null,null,null,null,null,null,null,null,null,"- Khai báo danh mục số TK",null,null,"=> Bảng kê: DANH MỤC TÀI KHOẢN"]
[null,null,"Địa chỉ",null,null,":","MỸ ĐÌNH - TỪ LIÊM - HÀ NỘI",null,null,null,null,null,null,null,null,"2. PHÁT SINH"]
[null,null,"MST",null,null,":","038 997 8430",null,null,null,null,null,null,null,null,null,"- Ghi nhận thực tế thu chi trong doanh nghiệp",null,null,null,null,null,null,"Click xem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+ Thông tin trên phiếu"]
[null,null,"Giám đốc",null,null,":","Nguyễn Văn A",null,null,null,null,null,null,null,null,null,null,"+ Thông tin người giao dịch"]
[null,null,"Kế toán Trưởng",null,null,":","Nguyễn Văn B",null,null,null,null,null,null,null,null,"3. IN PHIẾU THU - CHI",null,null,null,null,null,null,null,"Click xem"]
[null,null,"Thủ quỹ",null,null,":","Nguyễn Văn C",null,null,null,null,null,null,null,null,null,"- Số phiếu: Đánh tên số phiếu cần phân biệt phiếu thu - chi"]
[null,null,"Người lập phiếu",null,null,":","Nguyễn Văn D",null,null,null,null,null,null,null,null,null,"- Thao tác in: Chọn số phiếu => Nhấn thao tác Ctrl + P "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4. SỔ QUỸ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- Chọn số TK cần xem",null,null,null,null,null,null,"Click xem"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. BẢNG CÂN ĐỐI PHÁT SINH (RÚT GỌN)",null,null,null,null,null,null,null,"Click xem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- Báo cáo chạy tự động, bạn chỉ cần chọn ngày bắt đầu, ngày kết thúc cho báo cáo"]

{"sheet":"Phatsinh","index":1,"n_rows":69,"n_cols":16,"rows_kept":69,"cut":false,"hidden":false,"merged":[[7,11,7,13],[7,14,8,14],[7,15,8,15],[5,1,5,10],[7,1,7,2],[7,3,8,3],[7,4,8,4],[7,5,7,6],[7,7,7,8],[7,9,8,9],[7,10,8,10]]}
[]
[]
[null,{"$f":"ten","v":"TAICHINHCANHAN.PRO.VN"}]
[null,{"$f":"DC","v":"MỸ ĐÌNH - TỪ LIÊM - HÀ NỘI"}]
[null,{"$f":"MST","v":"038 997 8430"}]
[null,"HẠCH TOÁN NGHIỆP VỤ KINH TẾ PHÁT SINH"]
[null,1,null,2,null,5,6,"x-cấm xoá","x",16,null,19,20,21,22,23]
[null,"Chứng từ",null,"Ngày tháng ghi sổ","Diễn giải  ","TK",null,"Mã ĐT",null,"Thành Tiền","Mã TT","Thông tin về người giao dịch",null,null,"Kèm\ntheo","Chứng\ntừ"]
[null,"Số","Ngày",null,null,"Nợ","Có","Nội bộ","Ngoài",null,null,"Họ và tên","Đơn vị","Địa chỉ"]
[null,"PC01/001","2017-01-01","2017-01-01","Thanh toán tiền cước viễn thông T12/07 ( SM 2444357 )",6422,111,{"$f":"IFERROR(IF(OR(F10=SOQUY!$E$7,G10=SOQUY!$E$7),SOQUY!$E$7,0),\"\")","v":0},null,150774,null,"Anh Hai","Công ty TNHH ABC","Nguyễn Chí Thanh - Hà Nội",1,"HĐ AA-2010T - 0505058"]
[null,"PC01/001","2017-01-01","2017-01-01","Thuế GTGT được khấu trừ HĐơn 683356 ngày 11/01/008 Cty điện lực TPHCM",1331,111,{"$f":"IFERROR(IF(OR(F11=SOQUY!$E$7,G11=SOQUY!$E$7),SOQUY!$E$7,0),\"\")","v":0},null,15101]
[null,"PC01/002","2017-01-01","2017-01-01","Tạm ứng tiền",141,112,{"$f":"IFERROR(IF(OR(F12=SOQUY!$E$7,G12=SOQUY!$E$7),SOQUY!$E$7,0),\"\")","v":112},null,{"$f":"+J10+J11","v":165875},null,"Anh Van","Anh Van","Bộ phận Kinh Doanh - Nội Bộ",1,"TU-2008/01"]
[null,"PT01/001","2017-01-01","2017-01-01","Thu tiền bán hàng Hợp đồng BTU2008",113,131,{"$f":"IFERROR(IF(OR(F13=SOQUY!$E$7,G13=SOQUY!$E$7),SOQUY!$E$7,0),\"\")","v":0},null,12000000,null,"Tran Van C","Cty CP XYZ","cau giay - ha noi",1,"HĐ AA-2010T - 9574635"]
[null,"PT01/002","2017-01-02","2017-01-02","Thu tiền bán hàng Hợp đồng BTU2008 - 1",113,5111,{"$f":"IFERROR(IF(OR(F14=SOQUY!$E$7,G14=SOQUY!$E$7),SOQUY!$E$7,0),\"\")","v":0},null,5000000,null,"Tran Van C","Cty CP Xyz","cau giay - ha noi",1,"HĐ AA-2010T - 9574786"]
[null,"PT01/002","2017-01-02","2017-01-02","Thu tiền bán hàng Hợp đồng BTU2008 - 1",113,3331,{"$f":"IFERROR(IF(OR(F15=SOQUY!$E$7,G15=SOQUY!$E$7),SOQUY!$E$7,0),\"\")","v":0},null,{"$f":"J14*0.1","v":500000}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(F16=SOQUY!$E$7,G16=SOQUY!$E$7),SOQUY!$E$7,0),\"\")","v":0}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(F17=SOQUY!$E$7,G17=SOQUY!$E$7),SOQUY!$E$7,0),\"\")","v":0}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(F18=SOQUY!$E$7,G18=SOQUY!$E$7),SOQUY!$E$7,0),\"\")","v":0}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(F19=SOQUY!$E$7,G19=SOQUY!$E$7),SOQUY!$E$7,0),\"\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]

{"sheet":"In-Chi","index":2,"n_rows":52,"n_cols":256,"rows_kept":52,"cut":false,"hidden":false,"merged":[[3,5,5,10],[3,12,3,18],[4,12,4,18],[5,12,5,18],[6,7,6,8],[15,1,16,18],[7,23,7,24],[8,0,8,5],[8,6,8,9],[8,14,8,15],[8,16,8,18],[9,14,9,15],[9,16,9,18],[7,4,7,11],[7,14,7,15],[7,16,7,18],[10,3,10,6],[11,3,11,9],[12,3,12,18],[14,2,14,5],[14,6,14,18],[17,2,17,3],[17,7,17,18],[18,12,18,18],[19,0,19,2],[19,3,19,6],[19,7,19,10],[19,11,19,14],[19,15,19,18],[24,0,24,2],[24,3,24,6],[24,7,24,10],[24,11,24,14],[24,15,24,18],[20,0,20,2],[20,3,20,6],[20,7,20,10],[20,11,20,14],[20,15,20,18],[25,0,25,18],[26,0,26,18],[28,5,30,10],[28,12,28,18],[29,12,29,18],[30,12,30,18],[31,7,31,8],[32,4,32,11],[32,14,32,15],[32,16,32,18],[33,0,33,5],[33,6,33,9],[33,14,33,15],[33,16,33,18],[34,14,34,15],[34,16,34,18],[35,3,35,6],[36,3,36,8],[39,2,39,5],[39,6,39,18],[40,1,41,18],[42,2,42,3],[42,7,42,18],[43,12,43,18],[44,0,44,2],[44,3,44,6],[44,7,44,10],[44,11,44,14],[44,15,44,18],[50,0,50,18],[51,0,51,18],[45,0,45,2],[45,3,45,6],[45,7,45,10],[45,11,45,14],[45,15,45,18],[49,0,49,2],[49,3,49,6],[49,7,49,10],[49,11,49,14],[49,15,49,18]]}
[]
[]
[]
[{"$f":"\"Đơn vị : \"&ten","v":"Đơn vị : TAICHINHCANHAN.PRO.VN"},null,null,null,null,"PHIẾU CHI",null,null,null,null,null,null,"Mẫu số 02 - TT"]
[{"$f":"\"Địa chỉ :\"&\" \"&DC","v":"Địa chỉ : MỸ ĐÌNH - TỪ LIÊM - HÀ NỘI"},null,null,null,null,null,null,null,null,null,null,null,"(Ban hành theo TT số 133/2016/TT-BTC"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ngày 26/08/2016 của Bộ Tài Chính)",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,{"$f":"C15","v":165875},{"$f":"RIGHT(\"000000000000\"&ROUND(GK6,0),12)","v":"000000165875"},1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,"Số :","PC01/002"]
[null,null,null,null,{"$f":"+IF($F$4=\"\",\"\",VLOOKUP($H$7,Phatsinh!$B$10:$P$69,2,0))","v":"2017-01-01"},null,null,null,null,null,null,null,null,"Nợ",{"$f":"IF(ISNA(VLOOKUP(H7,Phatsinh!$B:$T,5,0)),\"\",VLOOKUP(H7,Phatsinh!$B:$T,5,0))","v":141},null,{"$f":"IF(O8=\"\",\"\",VLOOKUP(H7,Phatsinh!$B:$T,9,0))","v":165875},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,{"$f":"VALUE(MID(GL6,GM6,1))","v":0},{"$f":"VALUE(MID(GL6,GN6,1))","v":0},{"$f":"VALUE(MID(GL6,GO6,1))","v":0},{"$f":"VALUE(MID(GL6,GP6,1))","v":0},{"$f":"VALUE(MID(GL6,GQ6,1))","v":0},{"$f":"VALUE(MID(GL6,GR6,1))","v":0},{"$f":"VALUE(MID(GL6,GS6,1))","v":1},{"$f":"VALUE(MID(GL6,GT6,1))","v":6},{"$f":"VALUE(MID(GL6,GU6,1))","v":5},{"$f":"VALUE(MID(GL6,GV6,1))","v":8},{"$f":"VALUE(MID(GL6,GW6,1))","v":7},{"$f":"VALUE(MID(GL6,GX6,1))","v":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,{"$f":"'In-Thu'!C15","v":165875},{"$f":"RIGHT(\"000000000000\"&ROUND(II8,0),12)","v":"000000165875"},1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,"Liên 1",null,null,null,null,null,null,{"$f":"IF(Q9<>\"\",\"Nợ\",\"\")","v":""},{"$f":"IF(Q9<>\"\",\"1331\",\"\")","v":""},null,{"$f":"IF(OFFSET(Phatsinh!B10,MATCH(H7,Phatsinh!$B$10:$B$69,0),0)=H7,OFFSET(Phatsinh!J10,MATCH(H7,Phatsinh!$B$10:$B$69,0),0),\"\")","v":""},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,{"$f":"SUM(GM8:GM8)","v":0},{"$f":"SUM(GM8:GN8)","v":0},{"$f":"SUM(GM8:GO8)","v":0},{"$f":"SUM(GP8:GP8)","v":0},{"$f":"SUM(GP8:GQ8)","v":0},{"$f":"SUM(GP8:GR8)","v":0},{"$f":"SUM(GS8:GS8)","v":1},{"$f":"SUM(GS8:GT8)","v":7},{"$f":"SUM(GS8:GU8)","v":12},{"$f":"SUM(GV8:GV8)","v":8},{"$f":"SUM(GV8:GW8)","v":15},{"$f":"SUM(GV8:GX8)","v":20},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,{"$f":"VALUE(MID(IJ8,IK8,1))","v":0},{"$f":"VALUE(MID(IJ8,IL8,1))","v":0},{"$f":"VALUE(MID(IJ8,IM8,1))","v":0},{"$f":"VALUE(MID(IJ8,IN8,1))","v":0},{"$f":"VALUE(MID(IJ8,IO8,1))","v":0},{"$f":"VALUE(MID(IJ8,IP8,1))","v":0},{"$f":"VALUE(MID(IJ8,IQ8,1))","v":1},{"$f":"VALUE(MID(IJ8,IR8,1))","v":6},{"$f":"VALUE(MID(IJ8,IS8,1))","v":5},{"$f":"VALUE(MID(IJ8,IT8,1))","v":8},{"$f":"VALUE(MID(IJ8,IU8,1))","v":7},{"$f":"VALUE(MID(IJ8,IV8,1))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Có",1111,null,{"$f":"IF(Q9=\"\",Q8,Q8+Q9)","v":165875},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,{"$f":"IF(GM8=0,\"\",CHOOSE(GM8,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(GN8=0,IF(AND(GM8<>0,GO8<>0),\"lẻ\",\"\"),CHOOSE(GN8,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(GO8=0,\"\",CHOOSE(GO8,IF(GN8>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(GN8=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(GP8=0,\"\",CHOOSE(GP8,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(GQ8=0,IF(AND(GP8<>0,GR8<>0),\"lẻ\",\"\"),CHOOSE(GQ8,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(GR8=0,\"\",CHOOSE(GR8,IF(GQ8>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(GQ8=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(GS8=0,\"\",CHOOSE(GS8,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"một"},{"$f":"IF(GT8=0,IF(AND(GS8<>0,GU8<>0),\"lẻ\",\"\"),CHOOSE(GT8,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"sáu"},{"$f":"IF(GU8=0,\"\",CHOOSE(GU8,IF(GT8>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(GT8=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"lăm"},{"$f":"IF(GV8=0,\"\",CHOOSE(GV8,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"tám"},{"$f":"IF(GW8=0,IF(AND(GV8<>0,GX8<>0),\"lẻ\",\"\"),CHOOSE(GW8,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"bảy"},{"$f":"IF(GX8=0,\"\",CHOOSE(GX8,IF(GW8>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(GW8=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"lăm"},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,{"$f":"SUM(IK9:IK9)","v":0},{"$f":"SUM(IK9:IL9)","v":0},{"$f":"SUM(IK9:IM9)","v":0},{"$f":"SUM(IN9:IN9)","v":0},{"$f":"SUM(IN9:IO9)","v":0},{"$f":"SUM(IN9:IP9)","v":0},{"$f":"SUM(IQ9:IQ9)","v":1},{"$f":"SUM(IQ9:IR9)","v":7},{"$f":"SUM(IQ9:IS9)","v":12},{"$f":"SUM(IT9:IT9)","v":8},{"$f":"SUM(IT9:IU9)","v":15},{"$f":"SUM(IT9:IV9)","v":20}]
[null,"Họ tên người nhận tiền :",null,{"$f":"IF(Q8=\"\",\"\",VLOOKUP($H$7,Phatsinh!$B:$T,12,0))","v":"Anh Van"},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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(GM8=0,\"\",\"trăm\")","v":""},{"$f":"IF(GN8=0,\"\",IF(GN8=1,\"\",\"mươi\"))","v":""},{"$f":"IF(AND(GO8=0,GO9=0),\"\",\"tỷ\")","v":""},{"$f":"IF(GP8=0,\"\",\"trăm\")","v":""},{"$f":"IF(GQ8=0,\"\",IF(GQ8=1,\"\",\"mươi\"))","v":""},{"$f":"IF(AND(GR8=0,GR9=0),\"\",\"triệu\")","v":""},{"$f":"IF(GS8=0,\"\",\"trăm\")","v":"trăm"},{"$f":"IF(GT8=0,\"\",IF(GT8=1,\"\",\"mươi\"))","v":"mươi"},{"$f":"IF(AND(GU8=0,GU9=0),\"\",\"ngàn\")","v":"ngàn"},{"$f":"IF(GV8=0,\"\",\"trăm\")","v":"trăm"},{"$f":"IF(GW8=0,\"\",IF(GW8=1,\"\",\"mươi\"))","v":"mươi"},"đồng.",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,{"$f":"IF(IK9=0,\"\",CHOOSE(IK9,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(IL9=0,IF(AND(IK9<>0,IM9<>0),\"lẻ\",\"\"),CHOOSE(IL9,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(IM9=0,\"\",CHOOSE(IM9,IF(IL9>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(IL9=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(IN9=0,\"\",CHOOSE(IN9,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(IO9=0,IF(AND(IN9<>0,IP9<>0),\"lẻ\",\"\"),CHOOSE(IO9,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(IP9=0,\"\",CHOOSE(IP9,IF(IO9>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(IO9=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(IQ9=0,\"\",CHOOSE(IQ9,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"một"},{"$f":"IF(IR9=0,IF(AND(IQ9<>0,IS9<>0),\"lẻ\",\"\"),CHOOSE(IR9,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"sáu"},{"$f":"IF(IS9=0,\"\",CHOOSE(IS9,IF(IR9>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(IR9=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"lăm"},{"$f":"IF(IT9=0,\"\",CHOOSE(IT9,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"tám"},{"$f":"IF(IU9=0,IF(AND(IT9<>0,IV9<>0),\"lẻ\",\"\"),CHOOSE(IU9,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"bảy"},{"$f":"IF(IV9=0,\"\",CHOOSE(IV9,IF(IU9>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(IU9=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"lăm"}]
[null,"Địa chỉ :",null,{"$f":"IF(Q8=\"\",\"\",VLOOKUP($H$7,Phatsinh!$B:$T,13,0))","v":"Bộ phận Kinh Doanh - Nội Bộ"},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,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(LEFT(TRIM(IF(GK6=0,\"không đồng.\",GM10&\" \"&GM11&\" \"&GN10&\" \"&GN11&\" \"&GO10&\" \"&GO11&\" \"&GP10&\" \"&GP11&\" \"&GQ10&\" \"&GQ11&\" \"&GR10&\" \"&GR11&\" \"&GS10&\" \"&GS11&\" \"&GT10&\" \"&GT11&\" \"&GU10&\" \"&GU11&\" \"&GV10&\" \"&GV11&\" \"&GW10&\" \"&GW11&\" \"&GX10&\" \"&GX11)),1))&RIGHT(TRIM(IF(GK6=0,\"không đồng.\",GM10&\" \"&GM11&\" \"&GN10&\" \"&GN11&\" \"&GO10&\" \"&GO11&\" \"&GP10&\" \"&GP11&\" \"&GQ10&\" \"&GQ11&\" \"&GR10&\" \"&GR11&\" \"&GS10&\" \"&GS11&\" \"&GT10&\" \"&GT11&\" \"&GU10&\" \"&GU11&\" \"&GV10&\" \"&GV11&\" \"&GW10&\" \"&GW11&\" \"&GX10&\" \"&GX11)),LEN(TRIM(IF(GK6=0,\"không đồng.\",GM10&\" \"&GM11&\" \"&GN10&\" \"&GN11&\" \"&GO10&\" \"&GO11&\" \"&GP10&\" \"&GP11&\" \"&GQ10&\" \"&GQ11&\" \"&GR10&\" \"&GR11&\" \"&GS10&\" \"&GS11&\" \"&GT10&\" \"&GT11&\" \"&GU10&\" \"&GU11&\" \"&GV10&\" \"&GV11&\" \"&GW10&\" \"&GW11&\" \"&GX10&\" \"&GX11)))-1)","v":"Một trăm sáu mươi lăm ngàn tám trăm bảy mươi lăm đồng."},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,{"$f":"IF(IK9=0,\"\",\"trăm\")","v":""},{"$f":"IF(IL9=0,\"\",IF(IL9=1,\"\",\"mươi\"))","v":""},{"$f":"IF(AND(IM9=0,IM10=0),\"\",\"tỷ\")","v":""},{"$f":"IF(IN9=0,\"\",\"trăm\")","v":""},{"$f":"IF(IO9=0,\"\",IF(IO9=1,\"\",\"mươi\"))","v":""},{"$f":"IF(AND(IP9=0,IP10=0),\"\",\"triệu\")","v":""},{"$f":"IF(IQ9=0,\"\",\"trăm\")","v":"trăm"},{"$f":"IF(IR9=0,\"\",IF(IR9=1,\"\",\"mươi\"))","v":"mươi"},{"$f":"IF(AND(IS9=0,IS10=0),\"\",\"ngàn\")","v":"ngàn"},{"$f":"IF(IT9=0,\"\",\"trăm\")","v":"trăm"},{"$f":"IF(IU9=0,\"\",IF(IU9=1,\"\",\"mươi\"))","v":"mươi"},"đồng."]
[null,"Lý do chi :",null,{"$f":"IF($F$4=\"\",\"\",VLOOKUP($H$7,Phatsinh!$B:$T,4,0))","v":"Tạm ứng tiền"},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,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,{"$f":"UPPER(LEFT(TRIM(IF(II8=0,\"không đồng.\",IK11&\" \"&IK12&\" \"&IL11&\" \"&IL12&\" \"&IM11&\" \"&IM12&\" \"&IN11&\" \"&IN12&\" \"&IO11&\" \"&IO12&\" \"&IP11&\" \"&IP12&\" \"&IQ11&\" \"&IQ12&\" \"&IR11&\" \"&IR12&\" \"&IS11&\" \"&IS12&\" \"&IT11&\" \"&IT12&\" \"&IU11&\" \"&IU12&\" \"&IV11&\" \"&IV12)),1))&RIGHT(TRIM(IF(II8=0,\"không đồng.\",IK11&\" \"&IK12&\" \"&IL11&\" \"&IL12&\" \"&IM11&\" \"&IM12&\" \"&IN11&\" \"&IN12&\" \"&IO11&\" \"&IO12&\" \"&IP11&\" \"&IP12&\" \"&IQ11&\" \"&IQ12&\" \"&IR11&\" \"&IR12&\" \"&IS11&\" \"&IS12&\" \"&IT11&\" \"&IT12&\" \"&IU11&\" \"&IU12&\" \"&IV11&\" \"&IV12)),LEN(TRIM(IF(II8=0,\"không đồng.\",IK11&\" \"&IK12&\" \"&IL11&\" \"&IL12&\" \"&IM11&\" \"&IM12&\" \"&IN11&\" \"&IN12&\" \"&IO11&\" \"&IO12&\" \"&IP11&\" \"&IP12&\" \"&IQ11&\" \"&IQ12&\" \"&IR11&\" \"&IR12&\" \"&IS11&\" \"&IS12&\" \"&IT11&\" \"&IT12&\" \"&IU11&\" \"&IU12&\" \"&IV11&\" \"&IV12)))-1)","v":"Một trăm sáu mươi lăm ngàn tám trăm bảy mươi lăm đồng."}]
[]
[null,"Số tiền:",{"$f":"Q10","v":165875},null,null,null,"VND"]
[null,{"$f":"\"Viết bằng chữ : \"&GL12","v":"Viết bằng chữ : Một trăm sáu mươi lăm ngàn tám trăm bảy mươi lăm đồng."}]
[]
[null,"Kèm theo",1,null,"chứng từ gốc",null,null,{"$f":"IF(Q8=\"\",\"\",VLOOKUP($H$7,Phatsinh!$B:$T,15,0))","v":"TU-2008/01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E8","v":"2017-01-01"}]
["Giám đốc",null,null,"Kế toán trưởng",null,null,null,"Thủ quỹ",null,null,null,"Người lập phiếu",null,null,null,"Người nhận tiền"]
["(Ký, họ tên, đóng dấu)",null,null,"(Ký, họ tên)",null,null,null,"(Ký, họ tên)",null,null,null,"(Ký, họ tên)",null,null,null,"(Ký, họ tên)"]
[]
[]
[]
[{"$f":"+TEN_GD","v":"Nguyễn Văn A"},null,null,{"$f":"+TEN_KTT","v":"Nguyễn Văn B"},null,null,null,{"$f":"+TEN_TQ","v":"Nguyễn Văn C"},null,null,null,{"$f":"+TEN_NL","v":"Nguyễn Văn D"},null,null,null,{"$f":"D11","v":"Anh Van"}]
["Đã nhận đủ số tiền (viết bằng chữ) :………………………………………………………………………………………………………………………………………………………………"]
["………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….."]
[]
[{"$f":"+A4","v":"Đơn vị : TAICHINHCANHAN.PRO.VN"},null,null,null,null,{"$f":"+F4","v":"PHIẾU CHI"},null,null,null,null,null,null,{"$f":"+M4","v":"Mẫu số 02 - TT"}]
[{"$f":"+A5","v":"Địa chỉ : MỸ ĐÌNH - TỪ LIÊM - HÀ NỘI"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+M5","v":"(Ban hành theo TT số 133/2016/TT-BTC"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+M6","v":"ngày 26/08/2016 của Bộ Tài Chính)"}]
[null,null,null,null,null,null,{"$f":"+G7","v":"Số :"},{"$f":"+H7","v":"PC01/002"}]
[null,null,null,null,{"$f":"+E8","v":"2017-01-01"},null,null,null,null,null,null,null,null,{"$f":"+N8","v":"Nợ"},{"$f":"+O8","v":141},null,{"$f":"+Q8","v":165875}]
[null,null,null,null,null,null,"Liên 2",null,null,null,null,null,null,{"$f":"+IF($N$9=\"\",\"\",$N$9)","v":""},{"$f":"+IF($O$9=\"\",\"\",$O$9)","v":""},null,{"$f":"+Q9","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF($N$10=\"\",\"\",$N$10)","v":"Có"},{"$f":"+IF($O$10=\"\",\"\",$O$10)","v":1111},null,{"$f":"+IF($Q$10=\"\",\"\",$Q$10)","v":165875}]
[null,{"$f":"+B11","v":"Họ tên người nhận tiền :"},null,{"$f":"+D11","v":"Anh Van"},null,null,null,null,null,null,null,{"$f":"+L11","v":0}]
[null,{"$f":"+B12","v":"Địa chỉ :"},null,{"$f":"D12","v":"Bộ phận Kinh Doanh - Nội Bộ"}]
[null,{"$f":"+B13","v":"Lý do chi :"},null,{"$f":"+D13","v":"Tạm ứng tiền"}]
[]
[null,{"$f":"+B15","v":"Số tiền:"},{"$f":"+C15","v":165875},null,null,null,"VND"]
[null,{"$f":"+B16","v":"Viết bằng chữ : Một trăm sáu mươi lăm ngàn tám trăm bảy mươi lăm đồng."}]
[]
[null,{"$f":"+B18","v":"Kèm theo"},{"$f":"+C18","v":1},null,{"$f":"+E18","v":"chứng từ gốc"},null,null,{"$f":"+H18","v":"TU-2008/01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+M19","v":"2017-01-01"}]
[{"$f":"A20","v":"Giám đốc"},null,null,{"$f":"D20","v":"Kế toán trưởng"},null,null,null,{"$f":"H20","v":"Thủ quỹ"},null,null,null,{"$f":"L20","v":"Người lập phiếu"},null,null,null,{"$f":"P20","v":"Người nhận tiền"}]
["(Ký, họ tên, đóng dấu)",null,null,"(Ký, họ tên)",null,null,null,"(Ký, họ tên)",null,null,null,"(Ký, họ tên)",null,null,null,"(Ký, họ tên)"]
[]
[]
[]
[{"$f":"A25","v":"Nguyễn Văn A"},null,null,{"$f":"D25","v":"Nguyễn Văn B"},null,null,null,{"$f":"IF(H25<>\"\",H25,\"\")","v":"Nguyễn Văn C"},null,null,null,{"$f":"L25","v":"Nguyễn Văn D"},null,null,null,{"$f":"P25","v":"Anh Van"}]
[{"$f":"+A26","v":"Đã nhận đủ số tiền (viết bằng chữ) :………………………………………………………………………………………………………………………………………………………………"}]
["………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….."]

{"sheet":"In-Thu","index":3,"n_rows":55,"n_cols":256,"rows_kept":55,"cut":false,"hidden":false,"merged":[[6,7,6,8],[3,0,3,4],[3,5,5,10],[3,12,3,18],[4,0,4,4],[4,12,5,18],[7,23,7,24],[8,0,8,5],[8,6,8,9],[8,14,8,15],[8,16,8,18],[14,2,14,5],[14,6,14,18],[7,4,7,11],[7,14,7,15],[7,16,7,18],[9,14,9,15],[9,16,9,18],[10,3,10,6],[11,3,11,9],[12,3,12,18],[15,1,16,18],[17,2,17,3],[17,6,17,18],[18,12,18,18],[19,0,19,2],[19,3,19,5],[19,6,19,10],[19,11,19,14],[19,15,19,18],[20,15,20,18],[24,0,24,2],[24,3,24,5],[24,6,24,10],[24,11,24,14],[24,15,24,18],[31,8,31,9],[20,0,20,2],[20,3,20,5],[20,6,20,10],[20,11,20,14],[25,0,25,18],[26,0,26,18],[28,5,30,10],[28,12,28,18],[29,12,30,18],[40,1,41,18],[32,4,32,11],[32,14,32,15],[32,16,32,18],[33,0,33,5],[33,6,33,9],[33,14,33,15],[33,16,33,18],[34,14,34,15],[34,16,34,18],[35,3,35,6],[39,2,39,5],[39,6,39,18],[42,2,42,3],[42,7,42,18],[43,12,43,18],[44,0,44,2],[44,3,44,5],[44,6,44,10],[44,11,44,14],[44,15,44,18],[50,0,50,18],[51,0,51,18],[53,5,53,8],[54,5,54,8],[45,0,45,2],[45,3,45,5],[45,6,45,10],[45,11,45,14],[45,15,45,18],[49,0,49,2],[49,3,49,5],[49,6,49,10],[49,11,49,14],[49,15,49,18]]}
[]
[]
[]
[{"$f":"\"Đơn vị : \"&ten","v":"Đơn vị : TAICHINHCANHAN.PRO.VN"},null,null,null,null,"PHIẾU THU",null,null,null,null,null,null,"Mẫu số 01 - TT"]
[{"$f":"\"Địa chỉ :\"&\" \"&DC","v":"Địa chỉ : MỸ ĐÌNH - TỪ LIÊM - HÀ NỘI"},null,null,null,null,null,null,null,null,null,null,null,"(Ban hành theo TT số 133/2016/TT-BTC ngày 26/08/2016 của Bộ Tài Chính)"]
[]
[null,null,null,null,null,null,"Số :","PC01/002"]
[null,null,null,null,{"$f":"IF($F$4=\"\",\"\",VLOOKUP($H$7,Phatsinh!$B$10:$P$69,2,0))","v":"2017-01-01"},null,null,null,null,null,null,null,null,"Nợ",1111,null,{"$f":"IF(Q10=\"\",Q9,Q9+Q10)","v":165875},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,null,null,null,null,null,null,null,{"$f":"C15","v":165875},{"$f":"RIGHT(\"000000000000\"&ROUND(GV8,0),12)","v":"000000165875"},1,2,3,4,5,6,7,8,9,10,11,12,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,{"$f":"'In-Thu'!C15","v":165875},{"$f":"RIGHT(\"000000000000\"&ROUND(II8,0),12)","v":"000000165875"},1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,"Liên 1",null,null,null,null,null,null,"Có",{"$f":"VLOOKUP($H$7,Phatsinh!$B$10:$G$69,6,0)","v":112},null,{"$f":"IF(ISNA(VLOOKUP($H$7,PS,9,0)),\"\",VLOOKUP($H$7,Phatsinh!$B$10:$P$69,9,0))","v":165875},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,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(MID(GW8,GX8,1))","v":0},{"$f":"VALUE(MID(GW8,GY8,1))","v":0},{"$f":"VALUE(MID(GW8,GZ8,1))","v":0},{"$f":"VALUE(MID(GW8,HA8,1))","v":0},{"$f":"VALUE(MID(GW8,HB8,1))","v":0},{"$f":"VALUE(MID(GW8,HC8,1))","v":0},{"$f":"VALUE(MID(GW8,HD8,1))","v":1},{"$f":"VALUE(MID(GW8,HE8,1))","v":6},{"$f":"VALUE(MID(GW8,HF8,1))","v":5},{"$f":"VALUE(MID(GW8,HG8,1))","v":8},{"$f":"VALUE(MID(GW8,HH8,1))","v":7},{"$f":"VALUE(MID(GW8,HI8,1))","v":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,{"$f":"VALUE(MID(IJ8,IK8,1))","v":0},{"$f":"VALUE(MID(IJ8,IL8,1))","v":0},{"$f":"VALUE(MID(IJ8,IM8,1))","v":0},{"$f":"VALUE(MID(IJ8,IN8,1))","v":0},{"$f":"VALUE(MID(IJ8,IO8,1))","v":0},{"$f":"VALUE(MID(IJ8,IP8,1))","v":0},{"$f":"VALUE(MID(IJ8,IQ8,1))","v":1},{"$f":"VALUE(MID(IJ8,IR8,1))","v":6},{"$f":"VALUE(MID(IJ8,IS8,1))","v":5},{"$f":"VALUE(MID(IJ8,IT8,1))","v":8},{"$f":"VALUE(MID(IJ8,IU8,1))","v":7},{"$f":"VALUE(MID(IJ8,IV8,1))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q10<>\"\",\"Có\",\"\")","v":""},{"$f":"IF(Q10<>\"\",\"33311\",\"\")","v":""},null,{"$f":"IF(OFFSET(Phatsinh!B10,MATCH(H7,Phatsinh!$B$10:$B$69,0),0)=H7,OFFSET(Phatsinh!J10,MATCH(H7,Phatsinh!$B$10:$B$69,0),0),\"\")","v":""},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,null,null,null,null,null,null,null,null,null,{"$f":"SUM(GX9:GX9)","v":0},{"$f":"SUM(GX9:GY9)","v":0},{"$f":"SUM(GX9:GZ9)","v":0},{"$f":"SUM(HA9:HA9)","v":0},{"$f":"SUM(HA9:HB9)","v":0},{"$f":"SUM(HA9:HC9)","v":0},{"$f":"SUM(HD9:HD9)","v":1},{"$f":"SUM(HD9:HE9)","v":7},{"$f":"SUM(HD9:HF9)","v":12},{"$f":"SUM(HG9:HG9)","v":8},{"$f":"SUM(HG9:HH9)","v":15},{"$f":"SUM(HG9:HI9)","v":20},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,{"$f":"SUM(IK9:IK9)","v":0},{"$f":"SUM(IK9:IL9)","v":0},{"$f":"SUM(IK9:IM9)","v":0},{"$f":"SUM(IN9:IN9)","v":0},{"$f":"SUM(IN9:IO9)","v":0},{"$f":"SUM(IN9:IP9)","v":0},{"$f":"SUM(IQ9:IQ9)","v":1},{"$f":"SUM(IQ9:IR9)","v":7},{"$f":"SUM(IQ9:IS9)","v":12},{"$f":"SUM(IT9:IT9)","v":8},{"$f":"SUM(IT9:IU9)","v":15},{"$f":"SUM(IT9:IV9)","v":20}]
[null,"Họ tên người nộp tiền :",null,{"$f":"IF(Q8=\"\",\"\",VLOOKUP($H$7,Phatsinh!$B:$T,12,0))","v":"Anh Van"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(GX9=0,\"\",CHOOSE(GX9,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(GY9=0,IF(AND(GX9<>0,GZ9<>0),\"lẻ\",\"\"),CHOOSE(GY9,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(GZ9=0,\"\",CHOOSE(GZ9,IF(GY9>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(GY9=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(HA9=0,\"\",CHOOSE(HA9,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(HB9=0,IF(AND(HA9<>0,HC9<>0),\"lẻ\",\"\"),CHOOSE(HB9,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(HC9=0,\"\",CHOOSE(HC9,IF(HB9>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(HB9=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(HD9=0,\"\",CHOOSE(HD9,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"một"},{"$f":"IF(HE9=0,IF(AND(HD9<>0,HF9<>0),\"lẻ\",\"\"),CHOOSE(HE9,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"sáu"},{"$f":"IF(HF9=0,\"\",CHOOSE(HF9,IF(HE9>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(HE9=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"lăm"},{"$f":"IF(HG9=0,\"\",CHOOSE(HG9,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"tám"},{"$f":"IF(HH9=0,IF(AND(HG9<>0,HI9<>0),\"lẻ\",\"\"),CHOOSE(HH9,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"bảy"},{"$f":"IF(HI9=0,\"\",CHOOSE(HI9,IF(HH9>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(HH9=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"lăm"},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,{"$f":"IF(IK9=0,\"\",CHOOSE(IK9,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(IL9=0,IF(AND(IK9<>0,IM9<>0),\"lẻ\",\"\"),CHOOSE(IL9,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(IM9=0,\"\",CHOOSE(IM9,IF(IL9>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(IL9=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(IN9=0,\"\",CHOOSE(IN9,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(IO9=0,IF(AND(IN9<>0,IP9<>0),\"lẻ\",\"\"),CHOOSE(IO9,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(IP9=0,\"\",CHOOSE(IP9,IF(IO9>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(IO9=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":""},{"$f":"IF(IQ9=0,\"\",CHOOSE(IQ9,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"một"},{"$f":"IF(IR9=0,IF(AND(IQ9<>0,IS9<>0),\"lẻ\",\"\"),CHOOSE(IR9,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"sáu"},{"$f":"IF(IS9=0,\"\",CHOOSE(IS9,IF(IR9>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(IR9=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"lăm"},{"$f":"IF(IT9=0,\"\",CHOOSE(IT9,\"một\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"tám"},{"$f":"IF(IU9=0,IF(AND(IT9<>0,IV9<>0),\"lẻ\",\"\"),CHOOSE(IU9,\"mười\",\"hai\",\"ba\",\"bốn\",\"năm\",\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"bảy"},{"$f":"IF(IV9=0,\"\",CHOOSE(IV9,IF(IU9>1,\"mốt\",\"một\"),\"hai\",\"ba\",\"bốn\",IF(IU9=0,\"năm\",\"lăm\"),\"sáu\",\"bảy\",\"tám\",\"chín\"))","v":"lăm"}]
[null,"Địa chỉ :",null,{"$f":"IF(Q8=\"\",\"\",VLOOKUP($H$7,Phatsinh!$B:$T,13,0))","v":"Bộ phận Kinh Doanh - Nội Bộ"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(GX9=0,\"\",\"trăm\")","v":""},{"$f":"IF(GY9=0,\"\",IF(GY9=1,\"\",\"mươi\"))","v":""},{"$f":"IF(AND(GZ9=0,GZ10=0),\"\",\"tỷ\")","v":""},{"$f":"IF(HA9=0,\"\",\"trăm\")","v":""},{"$f":"IF(HB9=0,\"\",IF(HB9=1,\"\",\"mươi\"))","v":""},{"$f":"IF(AND(HC9=0,HC10=0),\"\",\"triệu\")","v":""},{"$f":"IF(HD9=0,\"\",\"trăm\")","v":"trăm"},{"$f":"IF(HE9=0,\"\",IF(HE9=1,\"\",\"mươi\"))","v":"mươi"},{"$f":"IF(AND(HF9=0,HF10=0),\"\",\"ngàn\")","v":"ngàn"},{"$f":"IF(HG9=0,\"\",\"trăm\")","v":"trăm"},{"$f":"IF(HH9=0,\"\",IF(HH9=1,\"\",\"mươi\"))","v":"mươi"},"đồng.",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,{"$f":"IF(IK9=0,\"\",\"trăm\")","v":""},{"$f":"IF(IL9=0,\"\",IF(IL9=1,\"\",\"mươi\"))","v":""},{"$f":"IF(AND(IM9=0,IM10=0),\"\",\"tỷ\")","v":""},{"$f":"IF(IN9=0,\"\",\"trăm\")","v":""},{"$f":"IF(IO9=0,\"\",IF(IO9=1,\"\",\"mươi\"))","v":""},{"$f":"IF(AND(IP9=0,IP10=0),\"\",\"triệu\")","v":""},{"$f":"IF(IQ9=0,\"\",\"trăm\")","v":"trăm"},{"$f":"IF(IR9=0,\"\",IF(IR9=1,\"\",\"mươi\"))","v":"mươi"},{"$f":"IF(AND(IS9=0,IS10=0),\"\",\"ngàn\")","v":"ngàn"},{"$f":"IF(IT9=0,\"\",\"trăm\")","v":"trăm"},{"$f":"IF(IU9=0,\"\",IF(IU9=1,\"\",\"mươi\"))","v":"mươi"},"đồng."]
[null,"Lý do nộp :",null,{"$f":"IF($F$4=\"\",\"\",VLOOKUP($H$7,Phatsinh!$B:$T,4,0))","v":"Tạm ứng tiền"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(LEFT(TRIM(IF(GV8=0,\"không đồng.\",GX11&\" \"&GX12&\" \"&GY11&\" \"&GY12&\" \"&GZ11&\" \"&GZ12&\" \"&HA11&\" \"&HA12&\" \"&HB11&\" \"&HB12&\" \"&HC11&\" \"&HC12&\" \"&HD11&\" \"&HD12&\" \"&HE11&\" \"&HE12&\" \"&HF11&\" \"&HF12&\" \"&HG11&\" \"&HG12&\" \"&HH11&\" \"&HH12&\" \"&HI11&\" \"&HI12)),1))&RIGHT(TRIM(IF(GV8=0,\"không đồng.\",GX11&\" \"&GX12&\" \"&GY11&\" \"&GY12&\" \"&GZ11&\" \"&GZ12&\" \"&HA11&\" \"&HA12&\" \"&HB11&\" \"&HB12&\" \"&HC11&\" \"&HC12&\" \"&HD11&\" \"&HD12&\" \"&HE11&\" \"&HE12&\" \"&HF11&\" \"&HF12&\" \"&HG11&\" \"&HG12&\" \"&HH11&\" \"&HH12&\" \"&HI11&\" \"&HI12)),LEN(TRIM(IF(GV8=0,\"không đồng.\",GX11&\" \"&GX12&\" \"&GY11&\" \"&GY12&\" \"&GZ11&\" \"&GZ12&\" \"&HA11&\" \"&HA12&\" \"&HB11&\" \"&HB12&\" \"&HC11&\" \"&HC12&\" \"&HD11&\" \"&HD12&\" \"&HE11&\" \"&HE12&\" \"&HF11&\" \"&HF12&\" \"&HG11&\" \"&HG12&\" \"&HH11&\" \"&HH12&\" \"&HI11&\" \"&HI12)))-1)","v":"Một trăm sáu mươi lăm ngàn tám trăm bảy mươi lăm đồng."},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,{"$f":"UPPER(LEFT(TRIM(IF(II8=0,\"không đồng.\",IK11&\" \"&IK12&\" \"&IL11&\" \"&IL12&\" \"&IM11&\" \"&IM12&\" \"&IN11&\" \"&IN12&\" \"&IO11&\" \"&IO12&\" \"&IP11&\" \"&IP12&\" \"&IQ11&\" \"&IQ12&\" \"&IR11&\" \"&IR12&\" \"&IS11&\" \"&IS12&\" \"&IT11&\" \"&IT12&\" \"&IU11&\" \"&IU12&\" \"&IV11&\" \"&IV12)),1))&RIGHT(TRIM(IF(II8=0,\"không đồng.\",IK11&\" \"&IK12&\" \"&IL11&\" \"&IL12&\" \"&IM11&\" \"&IM12&\" \"&IN11&\" \"&IN12&\" \"&IO11&\" \"&IO12&\" \"&IP11&\" \"&IP12&\" \"&IQ11&\" \"&IQ12&\" \"&IR11&\" \"&IR12&\" \"&IS11&\" \"&IS12&\" \"&IT11&\" \"&IT12&\" \"&IU11&\" \"&IU12&\" \"&IV11&\" \"&IV12)),LEN(TRIM(IF(II8=0,\"không đồng.\",IK11&\" \"&IK12&\" \"&IL11&\" \"&IL12&\" \"&IM11&\" \"&IM12&\" \"&IN11&\" \"&IN12&\" \"&IO11&\" \"&IO12&\" \"&IP11&\" \"&IP12&\" \"&IQ11&\" \"&IQ12&\" \"&IR11&\" \"&IR12&\" \"&IS11&\" \"&IS12&\" \"&IT11&\" \"&IT12&\" \"&IU11&\" \"&IU12&\" \"&IV11&\" \"&IV12)))-1)","v":"Một trăm sáu mươi lăm ngàn tám trăm bảy mươi lăm đồng."}]
[]
[null,"Số tiền:",{"$f":"Q8","v":165875},null,null,null,"VND"]
[null,{"$f":"\"Viết bằng chữ : \"&GW13","v":"Viết bằng chữ : Một trăm sáu mươi lăm ngàn tám trăm bảy mươi lăm đồng."}]
[]
[null,"Kèm theo",{"$f":"IF(Q8=\"\",\"\",VLOOKUP($H$7,Phatsinh!$B:$T,14,0))","v":1},null,"chứng từ gốc",null,{"$f":"IF(Q8=\"\",\"\",VLOOKUP($H$7,Phatsinh!$B:$T,15,0))","v":"TU-2008/01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E8","v":"2017-01-01"}]
["Giám đốc",null,null,"Kế toán trưởng",null,null,"Người nộp tiền",null,null,null,null,"Người lập phiếu",null,null,null,"Thủ quỹ"]
["(Ký, họ tên, đóng dấu)",null,null,"(Ký, họ tên)",null,null,"(Ký, họ tên)",null,null,null,null,"(Ký, họ tên)",null,null,null,"(Ký, họ tên)"]
[]
[]
[]
[{"$f":"+TEN_GD","v":"Nguyễn Văn A"},null,null,{"$f":"+TEN_KTT","v":"Nguyễn Văn B"},null,null,{"$f":"D11","v":"Anh Van"},null,null,null,null,{"$f":"+TEN_NL","v":"Nguyễn Văn D"},null,null,null,{"$f":"+TEN_TQ","v":"Nguyễn Văn C"}]
["Đã nhận đủ số tiền (viết bằng chữ) :………………………………………………………………………………………………………………………………………………………………"]
["………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….."]
[]
[{"$f":"+A4","v":"Đơn vị : TAICHINHCANHAN.PRO.VN"},null,null,null,null,{"$f":"+F4","v":"PHIẾU THU"},null,null,null,null,null,null,{"$f":"+M4","v":"Mẫu số 01 - TT"}]
[{"$f":"+A5","v":"Địa chỉ : MỸ ĐÌNH - TỪ LIÊM - HÀ NỘI"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+M5","v":"(Ban hành theo TT số 133/2016/TT-BTC ngày 26/08/2016 của Bộ Tài Chính)"}]
[{"$f":"+A6","v":0}]
[null,null,null,null,null,null,null,{"$f":"+G7","v":"Số :"},{"$f":"+H7","v":"PC01/002"}]
[{"$f":"+A8","v":0},null,null,null,{"$f":"+E8","v":"2017-01-01"},null,null,null,null,null,null,null,null,{"$f":"+N8","v":"Nợ"},{"$f":"+O8","v":1111},null,{"$f":"+Q8","v":165875}]
[null,null,null,null,null,null,"Liên 2",null,null,null,null,null,null,{"$f":"+IF($N$9=\"\",\"\",$N$9)","v":"Có"},{"$f":"+IF($O$9=\"\",\"\",$O$9)","v":112},null,{"$f":"+Q9","v":165875}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF($N$10=\"\",\"\",$N$10)","v":""},{"$f":"+IF($O$10=\"\",\"\",$O$10)","v":""},null,{"$f":"+IF($Q$10=\"\",\"\",$Q$10)","v":""}]
[null,{"$f":"+B11","v":"Họ tên người nộp tiền :"},null,{"$f":"+D11","v":"Anh Van"},null,null,null,null,null,null,null,{"$f":"+L11","v":0}]
[null,{"$f":"+B12","v":"Địa chỉ :"},null,{"$f":"+D12","v":"Bộ phận Kinh Doanh - Nội Bộ"}]
[null,{"$f":"+B13","v":"Lý do nộp :"},null,{"$f":"+D13","v":"Tạm ứng tiền"}]
[]
[null,{"$f":"+B15","v":"Số tiền:"},{"$f":"+C15","v":165875},null,null,null,"VND"]
[null,{"$f":"+B16","v":"Viết bằng chữ : Một trăm sáu mươi lăm ngàn tám trăm bảy mươi lăm đồng."}]
[]
[null,{"$f":"+B18","v":"Kèm theo"},{"$f":"+C18","v":1},null,{"$f":"+E18","v":"chứng từ gốc"},null,null,{"$f":"+H18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+M19","v":"2017-01-01"}]
["Giám đốc",null,null,"Kế toán trưởng",null,null,"Người nộp tiền",null,null,null,null,"Người lập phiếu",null,null,null,"Thủ quỹ"]
["(Ký, họ tên, đóng dấu)",null,null,"(Ký, họ tên)",null,null,"(Ký, họ tên)",null,null,null,null,"(Ký, họ tên)",null,null,null,"(Ký, họ tên)"]
[]
[]
[]
[{"$f":"+A25","v":"Nguyễn Văn A"},null,null,{"$f":"+D25","v":"Nguyễn Văn B"},null,null,{"$f":"D36","v":"Anh Van"},null,null,null,null,{"$f":"+L25","v":"Nguyễn Văn D"},null,null,null,{"$f":"+P25","v":"Nguyễn Văn C"}]
[{"$f":"+A26","v":"Đã nhận đủ số tiền (viết bằng chữ) :………………………………………………………………………………………………………………………………………………………………"}]
["………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….."]
[]
[null,null,null,null,null,{"$f":"F19","v":"00:00:00"}]
[null,null,null,null,{"$f":"E20","v":0},{"$f":"F20","v":0}]

{"sheet":"SOQUY","index":4,"n_rows":114,"n_cols":9,"rows_kept":114,"cut":false,"hidden":false,"merged":[[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,0,5,6],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,9,6],[103,4,103,6],[104,0,104,2],[104,4,104,6],[105,0,105,2],[105,4,105,6]]}
[]
[]
[{"$f":"ten","v":"TAICHINHCANHAN.PRO.VN"},null,null,null,null,"Mẫu số ……. - DNN"]
[{"$f":"DC","v":"MỸ ĐÌNH - TỪ LIÊM - HÀ NỘI"},null,null,null,null,"(Ban hành theo QĐ số 48/2006/QĐ-BTC"]
[{"$f":"MST","v":"038 997 8430"},null,null,null,null,"ngày 14/09/2006 của Bộ trưởng BTC)"]
["SỔ QUỸ"]
[null,null,null,"Loại quỹ: ",112]
[null,null,null,"Tên Quỹ:",{"$f":"IFERROR(VLOOKUP(E7,DM,2,0),0)","v":"Tiền trên TK cá nhân"}]
[null,null,null,null,null,null,"Đơn vị tính: VNĐ"]
["Ngày tháng ghi sổ","Số hiệu chứng từ","Ngày tháng chứng từ","Diễn giải","Số tiền"]
[null,null,null,null,"Thu","Chi","Tồn"]
["A","B","C","E",1,2,3,null,"x"]
[null,null,null,"Dư đầu kỳ",null,null,{"$f":"IFERROR(VLOOKUP($E$7,CDPS!$K$7:$M$16,3,0),0)","v":20000000},null,"x"]
[{"$f":"IFERROR(INDEX(NGAYGHI,$I14,1),\"\")","v":"2017-01-01"},{"$f":"IFERROR(INDEX(CTU,$I14,1),\"\")","v":"PC01/002"},{"$f":"IFERROR(INDEX(NGAY,$I14,1),\"\")","v":"2017-01-01"},{"$f":"IFERROR(INDEX(DG,$I14,1),\"\")","v":"Tạm ứng tiền"},{"$f":"IFERROR(IF(VALUE(LEFT(INDEX(TK_N,I14,1),3))=$E$7,INDEX(THANHTIEN,I14,1),0),0)","v":0},{"$f":"IFERROR(IF(VALUE(LEFT(INDEX(TK_C,I14,1),3))=$E$7,INDEX(THANHTIEN,I14,1),0),0)","v":165875},{"$f":"G13+E14-F14","v":19834125},null,{"$f":"IFERROR(MATCH($E$7,Phatsinh!$H$10:$H$69,),\"\")","v":3}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I14,0):'Phatsinh'!$H$69,0)+I14)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I14,0):'Phatsinh'!$H$69,0)+I14),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I15,0):'Phatsinh'!$H$69,0)+I15)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I15,0):'Phatsinh'!$H$69,0)+I15),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I16,0):'Phatsinh'!$H$69,0)+I16)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I16,0):'Phatsinh'!$H$69,0)+I16),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I17,0):'Phatsinh'!$H$69,0)+I17)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I17,0):'Phatsinh'!$H$69,0)+I17),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I18,0):'Phatsinh'!$H$69,0)+I18)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I18,0):'Phatsinh'!$H$69,0)+I18),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I19,0):'Phatsinh'!$H$69,0)+I19)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I19,0):'Phatsinh'!$H$69,0)+I19),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I20,0):'Phatsinh'!$H$69,0)+I20)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I20,0):'Phatsinh'!$H$69,0)+I20),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I21,0):'Phatsinh'!$H$69,0)+I21)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I21,0):'Phatsinh'!$H$69,0)+I21),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I22,0):'Phatsinh'!$H$69,0)+I22)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I22,0):'Phatsinh'!$H$69,0)+I22),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I23,0):'Phatsinh'!$H$69,0)+I23)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I23,0):'Phatsinh'!$H$69,0)+I23),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I24,0):'Phatsinh'!$H$69,0)+I24)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I24,0):'Phatsinh'!$H$69,0)+I24),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I25,0):'Phatsinh'!$H$69,0)+I25)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I25,0):'Phatsinh'!$H$69,0)+I25),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I26,0):'Phatsinh'!$H$69,0)+I26)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I26,0):'Phatsinh'!$H$69,0)+I26),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I27,0):'Phatsinh'!$H$69,0)+I27)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I27,0):'Phatsinh'!$H$69,0)+I27),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I28,0):'Phatsinh'!$H$69,0)+I28)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I28,0):'Phatsinh'!$H$69,0)+I28),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I29,0):'Phatsinh'!$H$69,0)+I29)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I29,0):'Phatsinh'!$H$69,0)+I29),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I30,0):'Phatsinh'!$H$69,0)+I30)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I30,0):'Phatsinh'!$H$69,0)+I30),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I31,0):'Phatsinh'!$H$69,0)+I31)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I31,0):'Phatsinh'!$H$69,0)+I31),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I32,0):'Phatsinh'!$H$69,0)+I32)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I32,0):'Phatsinh'!$H$69,0)+I32),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I33,0):'Phatsinh'!$H$69,0)+I33)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I33,0):'Phatsinh'!$H$69,0)+I33),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I34,0):'Phatsinh'!$H$69,0)+I34)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I34,0):'Phatsinh'!$H$69,0)+I34),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I35,0):'Phatsinh'!$H$69,0)+I35)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I35,0):'Phatsinh'!$H$69,0)+I35),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I36,0):'Phatsinh'!$H$69,0)+I36)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I36,0):'Phatsinh'!$H$69,0)+I36),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I37,0):'Phatsinh'!$H$69,0)+I37)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I37,0):'Phatsinh'!$H$69,0)+I37),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I38,0):'Phatsinh'!$H$69,0)+I38)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I38,0):'Phatsinh'!$H$69,0)+I38),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I39,0):'Phatsinh'!$H$69,0)+I39)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I39,0):'Phatsinh'!$H$69,0)+I39),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I40,0):'Phatsinh'!$H$69,0)+I40)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I40,0):'Phatsinh'!$H$69,0)+I40),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I41,0):'Phatsinh'!$H$69,0)+I41)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I41,0):'Phatsinh'!$H$69,0)+I41),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I42,0):'Phatsinh'!$H$69,0)+I42)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I42,0):'Phatsinh'!$H$69,0)+I42),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I43,0):'Phatsinh'!$H$69,0)+I43)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I43,0):'Phatsinh'!$H$69,0)+I43),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I44,0):'Phatsinh'!$H$69,0)+I44)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I44,0):'Phatsinh'!$H$69,0)+I44),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(NGAYGHI,$I46,1),\"\")","v":""},{"$f":"IFERROR(INDEX(CTU,$I46,1),\"\")","v":""},{"$f":"IFERROR(INDEX(NGAY,$I46,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DG,$I46,1),\"\")","v":""},{"$f":"IFERROR(IF(VALUE(LEFT(INDEX(TK_N,I46,1),3))=$E$7,INDEX(THANHTIEN,I46,1),0),0)","v":0},{"$f":"IFERROR(IF(VALUE(LEFT(INDEX(TK_C,I46,1),3))=$E$7,INDEX(THANHTIEN,I46,1),0),0)","v":0},19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I45,0):'Phatsinh'!$H$69,0)+I45)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I45,0):'Phatsinh'!$H$69,0)+I45),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I46,0):'Phatsinh'!$H$69,0)+I46)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I46,0):'Phatsinh'!$H$69,0)+I46),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I47,0):'Phatsinh'!$H$69,0)+I47)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I47,0):'Phatsinh'!$H$69,0)+I47),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I48,0):'Phatsinh'!$H$69,0)+I48)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I48,0):'Phatsinh'!$H$69,0)+I48),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I49,0):'Phatsinh'!$H$69,0)+I49)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I49,0):'Phatsinh'!$H$69,0)+I49),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I50,0):'Phatsinh'!$H$69,0)+I50)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I50,0):'Phatsinh'!$H$69,0)+I50),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I51,0):'Phatsinh'!$H$69,0)+I51)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I51,0):'Phatsinh'!$H$69,0)+I51),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I52,0):'Phatsinh'!$H$69,0)+I52)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I52,0):'Phatsinh'!$H$69,0)+I52),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I53,0):'Phatsinh'!$H$69,0)+I53)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I53,0):'Phatsinh'!$H$69,0)+I53),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I54,0):'Phatsinh'!$H$69,0)+I54)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I54,0):'Phatsinh'!$H$69,0)+I54),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I55,0):'Phatsinh'!$H$69,0)+I55)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I55,0):'Phatsinh'!$H$69,0)+I55),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I56,0):'Phatsinh'!$H$69,0)+I56)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I56,0):'Phatsinh'!$H$69,0)+I56),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I57,0):'Phatsinh'!$H$69,0)+I57)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I57,0):'Phatsinh'!$H$69,0)+I57),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I58,0):'Phatsinh'!$H$69,0)+I58)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I58,0):'Phatsinh'!$H$69,0)+I58),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I59,0):'Phatsinh'!$H$69,0)+I59)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I59,0):'Phatsinh'!$H$69,0)+I59),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I60,0):'Phatsinh'!$H$69,0)+I60)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I60,0):'Phatsinh'!$H$69,0)+I60),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I61,0):'Phatsinh'!$H$69,0)+I61)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I61,0):'Phatsinh'!$H$69,0)+I61),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I62,0):'Phatsinh'!$H$69,0)+I62)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I62,0):'Phatsinh'!$H$69,0)+I62),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I63,0):'Phatsinh'!$H$69,0)+I63)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I63,0):'Phatsinh'!$H$69,0)+I63),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I64,0):'Phatsinh'!$H$69,0)+I64)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I64,0):'Phatsinh'!$H$69,0)+I64),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I65,0):'Phatsinh'!$H$69,0)+I65)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I65,0):'Phatsinh'!$H$69,0)+I65),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I66,0):'Phatsinh'!$H$69,0)+I66)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I66,0):'Phatsinh'!$H$69,0)+I66),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I67,0):'Phatsinh'!$H$69,0)+I67)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I67,0):'Phatsinh'!$H$69,0)+I67),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I68,0):'Phatsinh'!$H$69,0)+I68)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I68,0):'Phatsinh'!$H$69,0)+I68),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I69,0):'Phatsinh'!$H$69,0)+I69)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I69,0):'Phatsinh'!$H$69,0)+I69),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I70,0):'Phatsinh'!$H$69,0)+I70)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I70,0):'Phatsinh'!$H$69,0)+I70),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I71,0):'Phatsinh'!$H$69,0)+I71)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I71,0):'Phatsinh'!$H$69,0)+I71),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I72,0):'Phatsinh'!$H$69,0)+I72)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I72,0):'Phatsinh'!$H$69,0)+I72),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I73,0):'Phatsinh'!$H$69,0)+I73)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I73,0):'Phatsinh'!$H$69,0)+I73),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I74,0):'Phatsinh'!$H$69,0)+I74)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I74,0):'Phatsinh'!$H$69,0)+I74),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I75,0):'Phatsinh'!$H$69,0)+I75)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I75,0):'Phatsinh'!$H$69,0)+I75),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I76,0):'Phatsinh'!$H$69,0)+I76)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I76,0):'Phatsinh'!$H$69,0)+I76),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(NGAYGHI,$I78,1),\"\")","v":""},{"$f":"IFERROR(INDEX(CTU,$I78,1),\"\")","v":""},{"$f":"IFERROR(INDEX(NGAY,$I78,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DG,$I78,1),\"\")","v":""},{"$f":"IFERROR(IF(VALUE(LEFT(INDEX(TK_N,I78,1),3))=$E$7,INDEX(THANHTIEN,I78,1),0),0)","v":0},{"$f":"IFERROR(IF(VALUE(LEFT(INDEX(TK_C,I78,1),3))=$E$7,INDEX(THANHTIEN,I78,1),0),0)","v":0},{"$f":"G77+E78-F78","v":19834125},null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I77,0):'Phatsinh'!$H$69,0)+I77)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I77,0):'Phatsinh'!$H$69,0)+I77),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I78,0):'Phatsinh'!$H$69,0)+I78)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I78,0):'Phatsinh'!$H$69,0)+I78),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I79,0):'Phatsinh'!$H$69,0)+I79)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I79,0):'Phatsinh'!$H$69,0)+I79),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I80,0):'Phatsinh'!$H$69,0)+I80)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I80,0):'Phatsinh'!$H$69,0)+I80),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I81,0):'Phatsinh'!$H$69,0)+I81)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I81,0):'Phatsinh'!$H$69,0)+I81),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I82,0):'Phatsinh'!$H$69,0)+I82)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I82,0):'Phatsinh'!$H$69,0)+I82),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I83,0):'Phatsinh'!$H$69,0)+I83)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I83,0):'Phatsinh'!$H$69,0)+I83),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I84,0):'Phatsinh'!$H$69,0)+I84)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I84,0):'Phatsinh'!$H$69,0)+I84),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I85,0):'Phatsinh'!$H$69,0)+I85)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I85,0):'Phatsinh'!$H$69,0)+I85),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I86,0):'Phatsinh'!$H$69,0)+I86)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I86,0):'Phatsinh'!$H$69,0)+I86),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I87,0):'Phatsinh'!$H$69,0)+I87)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I87,0):'Phatsinh'!$H$69,0)+I87),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I88,0):'Phatsinh'!$H$69,0)+I88)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I88,0):'Phatsinh'!$H$69,0)+I88),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I89,0):'Phatsinh'!$H$69,0)+I89)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I89,0):'Phatsinh'!$H$69,0)+I89),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I90,0):'Phatsinh'!$H$69,0)+I90)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I90,0):'Phatsinh'!$H$69,0)+I90),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I91,0):'Phatsinh'!$H$69,0)+I91)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I91,0):'Phatsinh'!$H$69,0)+I91),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I92,0):'Phatsinh'!$H$69,0)+I92)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I92,0):'Phatsinh'!$H$69,0)+I92),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I93,0):'Phatsinh'!$H$69,0)+I93)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I93,0):'Phatsinh'!$H$69,0)+I93),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I94,0):'Phatsinh'!$H$69,0)+I94)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I94,0):'Phatsinh'!$H$69,0)+I94),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I95,0):'Phatsinh'!$H$69,0)+I95)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I95,0):'Phatsinh'!$H$69,0)+I95),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I96,0):'Phatsinh'!$H$69,0)+I96)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I96,0):'Phatsinh'!$H$69,0)+I96),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I97,0):'Phatsinh'!$H$69,0)+I97)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I97,0):'Phatsinh'!$H$69,0)+I97),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I98,0):'Phatsinh'!$H$69,0)+I98)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I98,0):'Phatsinh'!$H$69,0)+I98),\"\")","v":""}]
["","","","",0,0,19834125,null,{"$f":"IFERROR(IF(TYPE(MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I99,0):'Phatsinh'!$H$69,0)+I99)=16,\"\",MATCH($E$7,OFFSET(Phatsinh!$H$10:$H$69,I99,0):'Phatsinh'!$H$69,0)+I99),\"\")","v":""}]
[null,null,null,"Tổng phát sinh",{"$f":"SUBTOTAL(9,E14:E100)","v":0},{"$f":"SUBTOTAL(9,F14:F100)","v":165875},null,null,"x"]
[null,null,null,"Tồn cuối kỳ",null,null,{"$f":"G13+E101-F101","v":19834125},null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,"Ngày     tháng       năm 2016",null,null,null,"x"]
["Người ghi sổ",null,null,null,"Giám đốc",null,null,null,"x"]
["(Ký, họ tên)",null,null,null,"(Ký, họ tên, đóng dấu)",null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]

{"sheet":"CDPS","index":5,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,10,5,10],[4,11,5,11],[4,12,4,13],[2,0,2,8],[3,3,3,4],[3,6,3,7],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,4,4],[4,5,4,6],[4,7,4,8]]}
[]
[]
["BẢNG CÂN ĐỐI PHÁT SINH RÚT GỌN",null,null,null,null,null,null,null,null,null,"DANH MỤC TÀI KHOẢN QUỸ"]
[null,null,"Từ ngày:","2017-01-01",null,"Đến ngày:","2017-01-01",null,"Đơn vị tính: VNĐ",null,null,null,null,"Đơn vị tính: VNĐ"]
["STT","SỐ TK","TÊN TK","DƯ ĐK",null,"PHÁT SINH ",null,"DƯ CK",null,null,"TK ","Tên","Dư đầu","Dư đầu"]
[null,null,null,"NỢ ","CÓ","NỢ ","CÓ","NỢ ","CÓ",null,null,null,"Nợ ","Có"]
[1,{"$f":"IF(K7=\"\",\"\",K7)","v":111},{"$f":"IF(L7=\"\",\"\",L7)","v":"Tiền mặt"},{"$f":"+MAX(IF(M7=\"\",0,M7)+SUMIFS(THANHTIEN,TK_N,B7,NGAY,\"<\"&CD_START)-IF(N7=\"\",0,N7)-SUMIFS(THANHTIEN,TK_C,B7,NGAY,\"<\"&CD_START),0)","v":10000000},{"$f":"MAX(IF(N7=\"\",0,N7)-IF(M7=\"\",0,M7)-SUMIFS(THANHTIEN,TK_N,B7,NGAY,\"<\"&CD_START)+SUMIFS(THANHTIEN,TK_C,B7,NGAY,\"<\"&CD_START),0)","v":0},{"$f":"+SUMIFS(THANHTIEN,TK_N,B7,NGAY,\"<=\"&CD_START,NGAY,\">=\"&CD_END)","v":0},{"$f":"++SUMIFS(THANHTIEN,TK_C,B7,NGAY,\">=\"&CD_START,NGAY,\"<=\"&CD_END)","v":165875},{"$f":"+MAX(D7+F7-E7-G7,0)","v":9834125},{"$f":"+MAX(E7+G7-D7-F7,0)","v":0},null,111,"Tiền mặt",10000000]
[2,{"$f":"IF(K8=\"\",\"\",K8)","v":112},"Tiền trên TK cá nhân",20000000,0,0,165875,{"$f":"+MAX(D8+F8-E8-G8,0)","v":19834125},{"$f":"+MAX(E8+G8-D8-F8,0)","v":0},null,112,"Tiền trên TK cá nhân",20000000]
[3,113,"Tiền trên TK công ty",500000,0,12000000,0,{"$f":"+MAX(D9+F9-E9-G9,0)","v":12500000},{"$f":"+MAX(E9+G9-D9-F9,0)","v":0},null,113,"Tiền trên TK công ty",500000]
[4,"","",0,0,0,0,0,0]
[null,"","",0,0,0,0,0,0]
[null,"","",0,0,0,0,0,0]
[null,"","",0,0,0,0,0,0]
[null,"","",0,0,0,0,0,0]
[null,"","",0,0,0,0,0,0]
[null,"","",0,0,0,0,0,0]