{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Setup","Raw","Email_list"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"Setup","index":0,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,5,1,6],[2,5,2,6],[3,5,3,6],[4,4,6,9],[0,1,0,10]]}
[null,"Model tự động chia files và gửi báo cáo từ sheet tổng hợp"]
[null,"To:",{"$f":"VLOOKUP($J$2,Email_list!A:C,2,0)","v":"thanhct12@excelviet.com.vn"},null,"Row filter:",4,null,null,"Unit","12"]
[null,"CC:",{"$f":"IF(VLOOKUP($J$2,Email_list!A:C,3,0)=0,\"\",VLOOKUP($J$2,Email_list!A:C,3,0))","v":"admin@excelviet.com.vn"},null,"Column filter:",2]
[null,"Email Subject:",{"$f":"\"Kết quả kinh doanh đơn vị \"&J2","v":"Kết quả kinh doanh đơn vị 12"},null,"Rank filter","A:M"]
[null,"Email Content:","Kính gửi anh chị,\n\nXin gửi anh chị báo cáo kết quả kinh doanh của đơn vị như file đính kèm\n\n---------------------------\nBest regards,\nCao Thanh\nExt: 1133\n--------------------------",null,"\nHướng dẫn:\n (1) Nhập danh sách email của đầu mối các đơn vị tại sheet Email_List\n (2) Tại sheet Raw, paste dữ liệu cần chia tách\n (3) Tại sheet Setup:\n       * To, CC (cell C2,C3): Tự động, link từ Email_List \n       * Email Subject (C4): Bạn cần thay đổi subject của email \n       * Email content (C5): Bạn cần thay đổi subject của email \n       * Attached File (C6): Tên file đính kèm, thay đổi nếu bạn muốn\n       * Path file (C7): Đường dẫn để đặt file sau khi được chia, chú ý có \\ ở cuối \n       * Row filter(F2): Dòng dữ liệu để đặt filter\n       * Column filter (F3): Cột để đưa điều kiện lọc cho đơn vị\n       *  Rank filter (F4): Rank để copy dữ liệu cho từng đơn vị\n       * Unit (J2): Tự động, macro sẽ chạy tất cả các đơn vị ở sheet Email_list\n    "]
[null,"Attached file:",{"$f":"\"Report_DV\"&J2&\".xlsx\"","v":"Report_DV12.xlsx"}]
[null,"Path file","D:\\Report\\"]

{"sheet":"Raw","index":1,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Bảng tổng hợp …."]
[]
[null,"Đơn vị","Thông tin 1","Thông tin 2","Thông tin 3","Thông tin 4","Thông tin 5","Thông tin 6","Thông tin 7","Thông tin 8","Thông tin 9","Thông tin 10","Thông tin 11"]
[null,"4","A","X",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"15","A","X",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"4","A","X",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"8","B","X",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"8","B","X",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"7","B","X",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"1","A","X",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"7","A","X",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"6","A","X",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"5","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"3","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"2","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"5","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"4","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"12","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"9","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"7","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"6","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"2","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"7","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"4","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"5","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"9","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"14","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
[null,"8","A","Y",10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]

{"sheet":"Email_list","index":2,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Đơn vị","Email người nhận","CC"]
["1","thanhct1@excelviet.com.vn","admin@excelviet.com.vn"]
["2","thanhct2@excelviet.com.vn","admin@excelviet.com.vn"]
["3","thanhct3@excelviet.com.vn","admin@excelviet.com.vn"]
["4","thanhct4@excelviet.com.vn","admin@excelviet.com.vn"]
["5","thanhct5@excelviet.com.vn","admin@excelviet.com.vn"]
["6","thanhct6@excelviet.com.vn","admin@excelviet.com.vn"]
["7","thanhct7@excelviet.com.vn","admin@excelviet.com.vn"]
["8","thanhct8@excelviet.com.vn","admin@excelviet.com.vn"]
["9","thanhct9@excelviet.com.vn","admin@excelviet.com.vn"]
["10","thanhct10@excelviet.com.vn","admin@excelviet.com.vn"]
["11","thanhct11@excelviet.com.vn","admin@excelviet.com.vn"]
["12","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["13","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["14","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["15","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["16","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["17","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["18","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["19","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["20","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["21","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["22","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["23","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["24","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["25","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["26","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["27","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["28","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["29","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["30","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]
["31","thanhct12@excelviet.com.vn","admin@excelviet.com.vn"]