{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Nhap","Xuat","NXT","DM"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"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":"Nhap","index":0,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[2,9,3,9],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5]]}
[]
[]
["STT","Ngày","Số phiếu","Mã hàng","Tên hàng","ĐVT","Số lượng","Đơn giá","Thành tiền","Ghi chú"]
[]
[1,"2017-01-02","PX17/001","VT10",{"$f":"IF(D5=\"\",\"\",VLOOKUP(D5,DM_HH,2,0))","v":"VT10"},{"$f":"IF(D5=\"\",\"\",VLOOKUP(D5,DM_HH,3,0))","v":"Cái"},15,10000,{"$f":"IF(D5=0,\"\",G5*H5)","v":150000}]
[2,"2017-01-02","PX17/001","VT20","VT20","Cái",16,20000,320000]
[3,"2017-01-03","PX17/002","VT10","VT10","Cái",20,10000,200000]
[4,"2017-01-03","PX17/002","VT50","VT50","Cái",30,49000,1470000]
[5,"2017-01-03","PX17/002","VT100","VT100","Cái",10,98500,985000]
[6,null,null,null,"","",null,null,""]
[7,null,null,null,"","",null,null,""]
[8,null,null,null,"","",null,null,""]
[9,null,null,null,"","",null,null,""]
[10,null,null,null,"","",null,null,""]
[11,null,null,null,"","",null,null,""]
[12,null,null,null,"","",null,null,""]
[13,null,null,null,"","",null,null,""]
[14,null,null,null,"","",null,null,""]
[15,null,null,null,"","",null,null,""]
[16,null,null,null,"","",null,null,""]
[17,null,null,null,"","",null,null,""]
[18,null,null,null,"","",null,null,""]
[19,null,null,null,"","",null,null,""]
[20,null,null,null,"","",null,null,""]
[21,null,null,null,"","",null,null,""]
[22,null,null,null,"","",null,null,""]
[23,null,null,null,"","",null,null,""]
[24,null,null,null,"","",null,null,""]
[25,null,null,null,"","",null,null,""]
[26,null,null,null,"","",null,null,""]
[27,null,null,null,"","",null,null,""]
[28,null,null,null,"","",null,null,""]
[29,null,null,null,"","",null,null,""]
[30,null,null,null,"","",null,null,""]
[31,null,null,null,"","",null,null,""]
[32,null,null,null,"","",null,null,""]
[33,null,null,null,"","",null,null,""]
[34,null,null,null,"","",null,null,""]
[35,null,null,null,"","",null,null,""]
[36,null,null,null,"","",null,null,""]
[37,null,null,null,"","",null,null,""]
[38,null,null,null,"","",null,null,""]
[39,null,null,null,"","",null,null,""]
[40,null,null,null,"","",null,null,""]
[41,null,null,null,"","",null,null,""]
[42,null,null,null,"","",null,null,""]
[43,null,null,null,"","",null,null,""]
[44,null,null,null,"","",null,null,""]
[45,null,null,null,"","",null,null,""]
[46,null,null,null,"","",null,null,""]
[47,null,null,null,"","",null,null,""]
[48,null,null,null,"","",null,null,""]
[49,null,null,null,"","",null,null,""]
[50,null,null,null,"","",null,null,""]
[51,null,null,null,"","",null,null,""]
[52,null,null,null,"","",null,null,""]
[53,null,null,null,"","",null,null,""]
[54,null,null,null,"","",null,null,""]
[55,null,null,null,"","",null,null,""]
[56,null,null,null,"","",null,null,""]
[57,null,null,null,"","",null,null,""]
[58,null,null,null,"","",null,null,""]
[59,null,null,null,"","",null,null,""]
[60,null,null,null,"","",null,null,""]
[61,null,null,null,"","",null,null,""]
[62,null,null,null,"","",null,null,""]
[63,null,null,null,"","",null,null,""]
[64,null,null,null,"","",null,null,""]
[65,null,null,null,{"$f":"IF(D69=\"\",\"\",VLOOKUP(D69,DM_HH,2,0))","v":""},{"$f":"IF(D69=\"\",\"\",VLOOKUP(D69,DM_HH,3,0))","v":""},null,null,{"$f":"IF(D69=0,\"\",G69*H69)","v":""}]
[66,null,null,null,"","",null,null,""]
[67,null,null,null,"","",null,null,""]
[68,null,null,null,"","",null,null,""]
[69,null,null,null,"","",null,null,""]
[70,null,null,null,"","",null,null,""]
[71,null,null,null,"","",null,null,""]
[72,null,null,null,"","",null,null,""]
[73,null,null,null,"","",null,null,""]
[74,null,null,null,"","",null,null,""]
[75,null,null,null,"","",null,null,""]
[76,null,null,null,"","",null,null,""]
[77,null,null,null,"","",null,null,""]
[78,null,null,null,"","",null,null,""]
[79,null,null,null,"","",null,null,""]
[80,null,null,null,"","",null,null,""]
[81,null,null,null,"","",null,null,""]
[82,null,null,null,"","",null,null,""]
[83,null,null,null,"","",null,null,""]
[84,null,null,null,"","",null,null,""]
[85,null,null,null,"","",null,null,""]
[86,null,null,null,"","",null,null,""]
[87,null,null,null,"","",null,null,""]
[88,null,null,null,"","",null,null,""]
[89,null,null,null,"","",null,null,""]
[90,null,null,null,"","",null,null,""]
[null,null,null,null,"","",null,null,""]

{"sheet":"Xuat","index":1,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4]]}
[]
[]
["STT","Ngày","Số phiếu","Mã hàng","Tên hàng","ĐVT","Số lượng","Đơn giá","Thành tiền","Ghi chú"]
[]
[1,"2017-01-02","PX17/001","VT10",{"$f":"IF(D5=\"\",\"\",VLOOKUP(D5,DM_HH,2,0))","v":"VT10"},{"$f":"IF(D5=\"\",\"\",VLOOKUP(D5,DM_HH,3,0))","v":"Cái"},5,10000,{"$f":"IF(D5=0,\"\",G5*H5)","v":50000}]
[2,"2017-01-02","PX17/001","VT20","VT20","Cái",3,20000,60000]
[3,"2017-01-03","PX17/002","VT10","VT10","Cái",7,10000,70000]
[4,"2017-01-03","PX17/002","VT50","VT50","Cái",14,49000,686000]
[5,"2017-01-03","PX17/002","VT100","VT100","Cái",8,98500,788000]
[6,null,null,null,"","",null,null,""]
[7,null,null,null,"","",null,null,""]
[8,null,null,null,"","",null,null,""]
[9,null,null,null,"","",null,null,""]
[10,null,null,null,"","",null,null,""]
[11,null,null,null,"","",null,null,""]
[12,null,null,null,"","",null,null,""]
[13,null,null,null,"","",null,null,""]
[14,null,null,null,"","",null,null,""]
[15,null,null,null,"","",null,null,""]
[16,null,null,null,"","",null,null,""]
[17,null,null,null,"","",null,null,""]
[18,null,null,null,"","",null,null,""]
[19,null,null,null,"","",null,null,""]
[20,null,null,null,"","",null,null,""]
[21,null,null,null,{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,DM_HH,2,0))","v":""},{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,DM_HH,3,0))","v":""},null,null,{"$f":"IF(D25=0,\"\",G25*H25)","v":""}]
[22,null,null,null,"","",null,null,""]
[23,null,null,null,"","",null,null,""]
[24,null,null,null,"","",null,null,""]
[25,null,null,null,"","",null,null,""]
[26,null,null,null,"","",null,null,""]
[27,null,null,null,"","",null,null,""]
[28,null,null,null,"","",null,null,""]
[29,null,null,null,"","",null,null,""]
[30,null,null,null,"","",null,null,""]
[31,null,null,null,"","",null,null,""]
[32,null,null,null,"","",null,null,""]
[33,null,null,null,"","",null,null,""]
[34,null,null,null,"","",null,null,""]
[35,null,null,null,"","",null,null,""]
[36,null,null,null,"","",null,null,""]
[37,null,null,null,"","",null,null,""]
[38,null,null,null,"","",null,null,""]
[39,null,null,null,"","",null,null,""]
[40,null,null,null,"","",null,null,""]
[41,null,null,null,"","",null,null,""]
[42,null,null,null,"","",null,null,""]
[43,null,null,null,"","",null,null,""]
[44,null,null,null,"","",null,null,""]
[45,null,null,null,"","",null,null,""]
[46,null,null,null,"","",null,null,""]
[47,null,null,null,"","",null,null,""]
[48,null,null,null,"","",null,null,""]
[49,null,null,null,"","",null,null,""]
[50,null,null,null,"","",null,null,""]
[51,null,null,null,"","",null,null,""]
[52,null,null,null,"","",null,null,""]
[53,null,null,null,"","",null,null,""]
[54,null,null,null,"","",null,null,""]
[55,null,null,null,"","",null,null,""]
[56,null,null,null,"","",null,null,""]
[57,null,null,null,"","",null,null,""]
[58,null,null,null,"","",null,null,""]
[59,null,null,null,"","",null,null,""]
[60,null,null,null,"","",null,null,""]
[61,null,null,null,"","",null,null,""]
[62,null,null,null,"","",null,null,""]
[63,null,null,null,"","",null,null,""]
[64,null,null,null,"","",null,null,""]
[65,null,null,null,"","",null,null,""]
[66,null,null,null,"","",null,null,""]
[67,null,null,null,"","",null,null,""]
[68,null,null,null,"","",null,null,""]
[69,null,null,null,"","",null,null,""]
[70,null,null,null,"","",null,null,""]
[71,null,null,null,"","",null,null,""]
[72,null,null,null,"","",null,null,""]
[73,null,null,null,"","",null,null,""]
[74,null,null,null,"","",null,null,""]
[75,null,null,null,"","",null,null,""]
[76,null,null,null,"","",null,null,""]
[77,null,null,null,"","",null,null,""]
[78,null,null,null,"","",null,null,""]
[79,null,null,null,"","",null,null,""]
[80,null,null,null,"","",null,null,""]
[81,null,null,null,"","",null,null,""]
[82,null,null,null,"","",null,null,""]
[83,null,null,null,"","",null,null,""]
[84,null,null,null,"","",null,null,""]
[85,null,null,null,{"$f":"IF(D89=\"\",\"\",VLOOKUP(D89,DM_HH,2,0))","v":""},{"$f":"IF(D89=\"\",\"\",VLOOKUP(D89,DM_HH,3,0))","v":""},null,null,{"$f":"IF(D89=0,\"\",G89*H89)","v":""}]
[86,null,null,null,"","",null,null,""]
[87,null,null,null,"","",null,null,""]
[88,null,null,null,"","",null,null,""]
[89,null,null,null,"","",null,null,""]
[90,null,null,null,"","",null,null,""]
[null,null,null,null,{"$f":"IF(D95=\"\",\"\",VLOOKUP(D95,DM_HH,2,0))","v":""},{"$f":"IF(D95=\"\",\"\",VLOOKUP(D95,DM_HH,3,0))","v":""},null,null,{"$f":"IF(D95=0,\"\",G95*H95)","v":""}]

{"sheet":"NXT","index":2,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
["BÁO CÁO NHẬP XUẤT TỒN SỐ LƯỢNG"]
[]
["MÃ HÀNG","TÊN HÀNG","ĐVT","TỒN ĐẦU KỲ","NHẬP TRONG KỲ","XUẤT TRONG KỲ","TỒN CUỐI KỲ","Ghi chú"]
[null,"TỔNG",null,{"$f":"SUBTOTAL(9,D7:D7862)","v":0},{"$f":"SUBTOTAL(9,E7:E7862)","v":91},{"$f":"SUBTOTAL(9,F7:F7862)","v":37},{"$f":"SUBTOTAL(9,G7:G7862)","v":54}]
[{"$f":"DM!B5","v":"VT10"},{"$f":"DM!C5","v":"VT10"},{"$f":"DM!D5","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A7)","v":35},{"$f":"SUMIFS(AMOUNT,MA_BAN,$A7)","v":12},{"$f":"E7-F7","v":23}]
[{"$f":"DM!B6","v":"VT20"},{"$f":"DM!C6","v":"VT20"},{"$f":"DM!D6","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A8)","v":16},3,{"$f":"E8-F8","v":13}]
[{"$f":"DM!B7","v":"VT50"},{"$f":"DM!C7","v":"VT50"},{"$f":"DM!D7","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A9)","v":30},14,16]
[{"$f":"DM!B8","v":"VT100"},{"$f":"DM!C8","v":"VT100"},{"$f":"DM!D8","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A10)","v":10},8,2]
[{"$f":"DM!B9","v":"VT500"},{"$f":"DM!C9","v":"VT500"},{"$f":"DM!D9","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A11)","v":0},0,0]
[{"$f":"DM!B10","v":"MO10"},{"$f":"DM!C10","v":"MO10"},{"$f":"DM!D10","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A12)","v":0},0,0]
[{"$f":"DM!B11","v":"MO20"},{"$f":"DM!C11","v":"MO20"},{"$f":"DM!D11","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A13)","v":0},0,0]
[{"$f":"DM!B12","v":"MO50"},{"$f":"DM!C12","v":"MO50"},{"$f":"DM!D12","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A14)","v":0},0,0]
[{"$f":"DM!B13","v":"MO100"},{"$f":"DM!C13","v":"MO100"},{"$f":"DM!D13","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A15)","v":0},0,0]
[{"$f":"DM!B14","v":"MO500"},{"$f":"DM!C14","v":"MO500"},{"$f":"DM!D14","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A16)","v":0},0,0]
[{"$f":"DM!B15","v":"VN10"},{"$f":"DM!C15","v":"VN10"},{"$f":"DM!D15","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A17)","v":0},0,0]
[{"$f":"DM!B16","v":"VN20"},{"$f":"DM!C16","v":"VN20"},{"$f":"DM!D16","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A18)","v":0},0,0]
[{"$f":"DM!B17","v":"VN50"},{"$f":"DM!C17","v":"VN50"},{"$f":"DM!D17","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A19)","v":0},0,0]
[{"$f":"DM!B18","v":"VN100"},{"$f":"DM!C18","v":"VN100"},{"$f":"DM!D18","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A20)","v":0},0,0]
[{"$f":"DM!B19","v":"VN500"},{"$f":"DM!C19","v":"VN500"},{"$f":"DM!D19","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A21)","v":0},0,0]
[{"$f":"DM!B20","v":"CO10"},{"$f":"DM!C20","v":"CO10"},{"$f":"DM!D20","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A22)","v":0},0,0]
[{"$f":"DM!B21","v":"CO20"},{"$f":"DM!C21","v":"CO20"},{"$f":"DM!D21","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A23)","v":0},0,0]
[{"$f":"DM!B22","v":"CO50"},{"$f":"DM!C22","v":"CO50"},{"$f":"DM!D22","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A24)","v":0},0,0]
[{"$f":"DM!B23","v":"CO100"},{"$f":"DM!C23","v":"CO100"},{"$f":"DM!D23","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A25)","v":0},0,0]
[{"$f":"DM!B24","v":"CO500"},{"$f":"DM!C24","v":"CO500"},{"$f":"DM!D24","v":"Cái"},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A26)","v":0},0,0]
[{"$f":"DM!B25","v":0},{"$f":"DM!C25","v":0},{"$f":"DM!D25","v":0},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A27)","v":0},0,0]
[{"$f":"DM!B26","v":0},{"$f":"DM!C26","v":0},{"$f":"DM!D26","v":0},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A28)","v":0},0,0]
[{"$f":"DM!B27","v":0},{"$f":"DM!C27","v":0},{"$f":"DM!D27","v":0},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A29)","v":0},0,0]
[{"$f":"DM!B28","v":0},{"$f":"DM!C28","v":0},{"$f":"DM!D28","v":0},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A30)","v":0},0,0]
[{"$f":"DM!B29","v":0},{"$f":"DM!C29","v":0},{"$f":"DM!D29","v":0},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A31)","v":0},0,0]
[{"$f":"DM!B30","v":0},{"$f":"DM!C30","v":0},{"$f":"DM!D30","v":0},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A32)","v":0},0,0]
[{"$f":"DM!B31","v":0},{"$f":"DM!C31","v":0},{"$f":"DM!D31","v":0},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A33)","v":0},0,0]
[{"$f":"DM!B32","v":0},{"$f":"DM!C32","v":0},{"$f":"DM!D32","v":0},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A34)","v":0},0,0]
[{"$f":"DM!B33","v":0},{"$f":"DM!C33","v":0},{"$f":"DM!D33","v":0},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A35)","v":0},0,0]
[{"$f":"DM!B34","v":0},{"$f":"DM!C34","v":0},{"$f":"DM!D34","v":0},null,{"$f":"SUMIFS(AMOUNT_IN,ma_nhap,$A36)","v":0},0,0]

{"sheet":"DM","index":3,"n_rows":204,"n_cols":5,"rows_kept":204,"cut":false,"hidden":false,"merged":[[2,4,3,4],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3]]}
[]
[]
["STT","Mã hàng","Tên hàng","ĐVT","Ghi chú"]
[]
[1,"VT10","VT10","Cái"]
[2,"VT20","VT20","Cái"]
[3,"VT50","VT50","Cái"]
[4,"VT100","VT100","Cái"]
[5,"VT500","VT500","Cái"]
[6,"MO10","MO10","Cái"]
[7,"MO20","MO20","Cái"]
[8,"MO50","MO50","Cái"]
[9,"MO100","MO100","Cái"]
[10,"MO500","MO500","Cái"]
[11,"VN10","VN10","Cái"]
[12,"VN20","VN20","Cái"]
[13,"VN50","VN50","Cái"]
[14,"VN100","VN100","Cái"]
[15,"VN500","VN500","Cái"]
[16,"CO10","CO10","Cái"]
[17,"CO20","CO20","Cái"]
[18,"CO50","CO50","Cái"]
[19,"CO100","CO100","Cái"]
[20,"CO500","CO500","Cái"]
[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]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]