{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Progress","242","211","341","3387"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Progress","index":0,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":true,"merged":[[1,0,1,1],[0,0,0,1]]}
["2023-06-05",null,"2023-06-06","2023-06-07","2023-06-08","2023-06-09","2023-06-10","2023-06-11","2023-06-12","2023-06-13","2023-06-14","2023-06-15","2023-06-16"]
[{"$f":"A1","v":"2023-06-05"},null,{"$f":"C1","v":"2023-06-06"},"2023-06-07","2023-06-08","2023-06-09","2023-06-10","2023-06-11","2023-06-12","2023-06-13","2023-06-14","2023-06-15","2023-06-16"]
["Nội dung","Ngày thực hiện"]
["Chạy giá costing cuối tháng","Cuối tháng (31/5)","Chạy thử các lệnh đóng sổ",null,null,null,"Off","Off","Closing T1","Closing T2","Closing T3","Closing T4","Bay về BN"]
["Post chứng từ lên GL",null,"Reconcile 152",null,null,null,"Off","Off"]
["post batch tiền mặt",null,null,null,null,null,"Off","Off"]
["revaluation tỷ giá","Sau khi post batch tiền",null,null,null,null,"Off","Off"]
["post ar, ap",null,null,null,null,null,"Off","Off"]
["revaluation ar, ap","Sau khi post ar, ap",null,null,null,null,"Off","Off"]
[null,null,null,null,null,null,"Off","Off"]

{"sheet":"242","index":1,"n_rows":20,"n_cols":30,"rows_kept":20,"cut":false,"hidden":false,"merged":[[9,14,9,15],[9,16,9,17],[0,8,0,9]]}
[null,null,null,null,null,null,null,null,"2023-06-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"**Copy value last yearend - Acc YTD 31/12"]
["Inv No.","Inv Date","Contract","Other Doc.","System Desc","Debit","Credit","Dept","Amt","Item Desc","Begin date","End date","Org Amt","Dur (M)","Per Month","Acc last year","Acc YTD","Residual",{"$f":"DATE(YEAR(I1),1,31)","v":"2023-01-31"},{"$f":"EOMONTH(S3,1)","v":"2023-02-28"},{"$f":"EOMONTH(T3,1)","v":"2023-03-31"},"2023-04-30","2023-05-31","2023-06-30","2023-07-31","2023-08-31",{"$f":"EOMONTH(Z3,1)","v":"2023-09-30"},"2023-10-31","2023-11-30","2023-12-31"]
[null,null,null,null,null,642,242,"FIN",{"$f":"SUM(($S$3:$AD$3=$I$1)*$S4:$AD4)","v":14285000},"A","2023-02-05","2023-09-04",100000000,{"$f":"DATEDIF(K4,L4,\"m\")+1","v":7},{"$f":"ROUNDDOWN(M4/N4,-3)","v":14285000},0,{"$f":"SUMIFS($S4:$AD4,$S$3:$AD$3,\"<=\"&$I$1)+P4","v":69384000},{"$f":"M4-Q4","v":30616000},{"$f":"IF(Dateinmonth($L4,S$3)=1,$M4-$P4-SUMIFS($S4:$AD4,$S$3:$AD$3,\"<>\"&EOMONTH($L4,0)),IF(Dateinmonth($K4,S$3)=1,ROUNDDOWN($O4*(DAY(S$3)-DAY($K4)+1)/DAY(S$3),-3),IF(Dateinrange($K4,$L4,S$3)=1,$O4,0)))","v":0},{"$f":"IF(Dateinmonth($L4,T$3)=1,$M4-$P4-SUMIFS($S4:$AD4,$S$3:$AD$3,\"<>\"&EOMONTH($L4,0)),IF(Dateinmonth($K4,T$3)=1,ROUNDDOWN($O4*(DAY(T$3)-DAY($K4)+1)/DAY(T$3),-3),IF(Dateinrange($K4,$L4,T$3)=1,$O4,0)))","v":12244000},{"$f":"IF(Dateinmonth($L4,U$3)=1,$M4-$P4-SUMIFS($S4:$AD4,$S$3:$AD$3,\"<>\"&EOMONTH($L4,0)),IF(Dateinmonth($K4,U$3)=1,ROUNDDOWN($O4*(DAY(U$3)-DAY($K4)+1)/DAY(U$3),-3),IF(Dateinrange($K4,$L4,U$3)=1,$O4,0)))","v":14285000},{"$f":"IF(Dateinmonth($L4,V$3)=1,$M4-$P4-SUMIFS($S4:$AD4,$S$3:$AD$3,\"<>\"&EOMONTH($L4,0)),IF(Dateinmonth($K4,V$3)=1,ROUNDDOWN($O4*(DAY(V$3)-DAY($K4)+1)/DAY(V$3),-3),IF(Dateinrange($K4,$L4,V$3)=1,$O4,0)))","v":14285000},{"$f":"IF(Dateinmonth($L4,W$3)=1,$M4-$P4-SUMIFS($S4:$AD4,$S$3:$AD$3,\"<>\"&EOMONTH($L4,0)),IF(Dateinmonth($K4,W$3)=1,ROUNDDOWN($O4*(DAY(W$3)-DAY($K4)+1)/DAY(W$3),-3),IF(Dateinrange($K4,$L4,W$3)=1,$O4,0)))","v":14285000},{"$f":"IF(Dateinmonth($L4,X$3)=1,$M4-$P4-SUMIFS($S4:$AD4,$S$3:$AD$3,\"<>\"&EOMONTH($L4,0)),IF(Dateinmonth($K4,X$3)=1,ROUNDDOWN($O4*(DAY(X$3)-DAY($K4)+1)/DAY(X$3),-3),IF(Dateinrange($K4,$L4,X$3)=1,$O4,0)))","v":14285000},{"$f":"IF(Dateinmonth($L4,Y$3)=1,$M4-$P4-SUMIFS($S4:$AD4,$S$3:$AD$3,\"<>\"&EOMONTH($L4,0)),IF(Dateinmonth($K4,Y$3)=1,ROUNDDOWN($O4*(DAY(Y$3)-DAY($K4)+1)/DAY(Y$3),-3),IF(Dateinrange($K4,$L4,Y$3)=1,$O4,0)))","v":14285000},{"$f":"IF(Dateinmonth($L4,Z$3)=1,$M4-$P4-SUMIFS($S4:$AD4,$S$3:$AD$3,\"<>\"&EOMONTH($L4,0)),IF(Dateinmonth($K4,Z$3)=1,ROUNDDOWN($O4*(DAY(Z$3)-DAY($K4)+1)/DAY(Z$3),-3),IF(Dateinrange($K4,$L4,Z$3)=1,$O4,0)))","v":14285000},{"$f":"IF(Dateinmonth($L4,AA$3)=1,$M4-$P4-SUMIFS($S4:$AD4,$S$3:$AD$3,\"<>\"&EOMONTH($L4,0)),IF(Dateinmonth($K4,AA$3)=1,ROUNDDOWN($O4*(DAY(AA$3)-DAY($K4)+1)/DAY(AA$3),-3),IF(Dateinrange($K4,$L4,AA$3)=1,$O4,0)))","v":2046000},{"$f":"IF(Dateinmonth($L4,AB$3)=1,$M4-$P4-SUMIFS($S4:$AD4,$S$3:$AD$3,\"<>\"&EOMONTH($L4,0)),IF(Dateinmonth($K4,AB$3)=1,ROUNDDOWN($O4*(DAY(AB$3)-DAY($K4)+1)/DAY(AB$3),-3),IF(Dateinrange($K4,$L4,AB$3)=1,$O4,0)))","v":0},{"$f":"IF(Dateinmonth($L4,AC$3)=1,$M4-$P4-SUMIFS($S4:$AD4,$S$3:$AD$3,\"<>\"&EOMONTH($L4,0)),IF(Dateinmonth($K4,AC$3)=1,ROUNDDOWN($O4*(DAY(AC$3)-DAY($K4)+1)/DAY(AC$3),-3),IF(Dateinrange($K4,$L4,AC$3)=1,$O4,0)))","v":0},{"$f":"IF(Dateinmonth($L4,AD$3)=1,$M4-$P4-SUMIFS($S4:$AD4,$S$3:$AD$3,\"<>\"&EOMONTH($L4,0)),IF(Dateinmonth($K4,AD$3)=1,ROUNDDOWN($O4*(DAY(AD$3)-DAY($K4)+1)/DAY(AD$3),-3),IF(Dateinrange($K4,$L4,AD$3)=1,$O4,0)))","v":0}]
[null,null,null,null,null,641,242,"SAL",{"$f":"SUM(($S$3:$AD$3=$I$1)*$S5:$AD5)","v":1142000},"B","2022-06-05","2024-02-05",24000000,{"$f":"DATEDIF(K5,L5,\"m\")+1","v":21},{"$f":"ROUNDDOWN(M5/N5,-3)","v":1142000},7841000,{"$f":"SUMIFS($S5:$AD5,$S$3:$AD$3,\"<=\"&$I$1)+P5","v":14693000},{"$f":"M5-Q5","v":9307000},{"$f":"IF(Dateinmonth($L5,S$3)=1,$M5-$P5-SUMIFS($S5:$AD5,$S$3:$AD$3,\"<>\"&EOMONTH($L5,0)),IF(Dateinmonth($K5,S$3)=1,ROUNDDOWN($O5*(DAY(S$3)-DAY($K5)+1)/DAY(S$3),-3),IF(Dateinrange($K5,$L5,S$3)=1,$O5,0)))","v":1142000},{"$f":"IF(Dateinmonth($L5,T$3)=1,$M5-$P5-SUMIFS($S5:$AD5,$S$3:$AD$3,\"<>\"&EOMONTH($L5,0)),IF(Dateinmonth($K5,T$3)=1,ROUNDDOWN($O5*(DAY(T$3)-DAY($K5)+1)/DAY(T$3),-3),IF(Dateinrange($K5,$L5,T$3)=1,$O5,0)))","v":1142000},{"$f":"IF(Dateinmonth($L5,U$3)=1,$M5-$P5-SUMIFS($S5:$AD5,$S$3:$AD$3,\"<>\"&EOMONTH($L5,0)),IF(Dateinmonth($K5,U$3)=1,ROUNDDOWN($O5*(DAY(U$3)-DAY($K5)+1)/DAY(U$3),-3),IF(Dateinrange($K5,$L5,U$3)=1,$O5,0)))","v":1142000},{"$f":"IF(Dateinmonth($L5,V$3)=1,$M5-$P5-SUMIFS($S5:$AD5,$S$3:$AD$3,\"<>\"&EOMONTH($L5,0)),IF(Dateinmonth($K5,V$3)=1,ROUNDDOWN($O5*(DAY(V$3)-DAY($K5)+1)/DAY(V$3),-3),IF(Dateinrange($K5,$L5,V$3)=1,$O5,0)))","v":1142000},{"$f":"IF(Dateinmonth($L5,W$3)=1,$M5-$P5-SUMIFS($S5:$AD5,$S$3:$AD$3,\"<>\"&EOMONTH($L5,0)),IF(Dateinmonth($K5,W$3)=1,ROUNDDOWN($O5*(DAY(W$3)-DAY($K5)+1)/DAY(W$3),-3),IF(Dateinrange($K5,$L5,W$3)=1,$O5,0)))","v":1142000},{"$f":"IF(Dateinmonth($L5,X$3)=1,$M5-$P5-SUMIFS($S5:$AD5,$S$3:$AD$3,\"<>\"&EOMONTH($L5,0)),IF(Dateinmonth($K5,X$3)=1,ROUNDDOWN($O5*(DAY(X$3)-DAY($K5)+1)/DAY(X$3),-3),IF(Dateinrange($K5,$L5,X$3)=1,$O5,0)))","v":1142000},{"$f":"IF(Dateinmonth($L5,Y$3)=1,$M5-$P5-SUMIFS($S5:$AD5,$S$3:$AD$3,\"<>\"&EOMONTH($L5,0)),IF(Dateinmonth($K5,Y$3)=1,ROUNDDOWN($O5*(DAY(Y$3)-DAY($K5)+1)/DAY(Y$3),-3),IF(Dateinrange($K5,$L5,Y$3)=1,$O5,0)))","v":1142000},{"$f":"IF(Dateinmonth($L5,Z$3)=1,$M5-$P5-SUMIFS($S5:$AD5,$S$3:$AD$3,\"<>\"&EOMONTH($L5,0)),IF(Dateinmonth($K5,Z$3)=1,ROUNDDOWN($O5*(DAY(Z$3)-DAY($K5)+1)/DAY(Z$3),-3),IF(Dateinrange($K5,$L5,Z$3)=1,$O5,0)))","v":1142000},{"$f":"IF(Dateinmonth($L5,AA$3)=1,$M5-$P5-SUMIFS($S5:$AD5,$S$3:$AD$3,\"<>\"&EOMONTH($L5,0)),IF(Dateinmonth($K5,AA$3)=1,ROUNDDOWN($O5*(DAY(AA$3)-DAY($K5)+1)/DAY(AA$3),-3),IF(Dateinrange($K5,$L5,AA$3)=1,$O5,0)))","v":1142000},{"$f":"IF(Dateinmonth($L5,AB$3)=1,$M5-$P5-SUMIFS($S5:$AD5,$S$3:$AD$3,\"<>\"&EOMONTH($L5,0)),IF(Dateinmonth($K5,AB$3)=1,ROUNDDOWN($O5*(DAY(AB$3)-DAY($K5)+1)/DAY(AB$3),-3),IF(Dateinrange($K5,$L5,AB$3)=1,$O5,0)))","v":1142000},{"$f":"IF(Dateinmonth($L5,AC$3)=1,$M5-$P5-SUMIFS($S5:$AD5,$S$3:$AD$3,\"<>\"&EOMONTH($L5,0)),IF(Dateinmonth($K5,AC$3)=1,ROUNDDOWN($O5*(DAY(AC$3)-DAY($K5)+1)/DAY(AC$3),-3),IF(Dateinrange($K5,$L5,AC$3)=1,$O5,0)))","v":1142000},{"$f":"IF(Dateinmonth($L5,AD$3)=1,$M5-$P5-SUMIFS($S5:$AD5,$S$3:$AD$3,\"<>\"&EOMONTH($L5,0)),IF(Dateinmonth($K5,AD$3)=1,ROUNDDOWN($O5*(DAY(AD$3)-DAY($K5)+1)/DAY(AD$3),-3),IF(Dateinrange($K5,$L5,AD$3)=1,$O5,0)))","v":1142000}]
[null,null,null,null,null,627,242,"PRD",{"$f":"SUM(($S$3:$AD$3=$I$1)*$S6:$AD6)","v":0},"C","2023-07-06","2024-08-05",130000000,{"$f":"DATEDIF(K6,L6,\"m\")+1","v":13},{"$f":"ROUNDDOWN(M6/N6,-3)","v":10000000},0,{"$f":"SUMIFS($S6:$AD6,$S$3:$AD$3,\"<=\"&$I$1)+P6","v":0},{"$f":"M6-Q6","v":130000000},{"$f":"IF(Dateinmonth($L6,S$3)=1,$M6-$P6-SUMIFS($S6:$AD6,$S$3:$AD$3,\"<>\"&EOMONTH($L6,0)),IF(Dateinmonth($K6,S$3)=1,ROUNDDOWN($O6*(DAY(S$3)-DAY($K6)+1)/DAY(S$3),-3),IF(Dateinrange($K6,$L6,S$3)=1,$O6,0)))","v":0},{"$f":"IF(Dateinmonth($L6,T$3)=1,$M6-$P6-SUMIFS($S6:$AD6,$S$3:$AD$3,\"<>\"&EOMONTH($L6,0)),IF(Dateinmonth($K6,T$3)=1,ROUNDDOWN($O6*(DAY(T$3)-DAY($K6)+1)/DAY(T$3),-3),IF(Dateinrange($K6,$L6,T$3)=1,$O6,0)))","v":0},{"$f":"IF(Dateinmonth($L6,U$3)=1,$M6-$P6-SUMIFS($S6:$AD6,$S$3:$AD$3,\"<>\"&EOMONTH($L6,0)),IF(Dateinmonth($K6,U$3)=1,ROUNDDOWN($O6*(DAY(U$3)-DAY($K6)+1)/DAY(U$3),-3),IF(Dateinrange($K6,$L6,U$3)=1,$O6,0)))","v":0},{"$f":"IF(Dateinmonth($L6,V$3)=1,$M6-$P6-SUMIFS($S6:$AD6,$S$3:$AD$3,\"<>\"&EOMONTH($L6,0)),IF(Dateinmonth($K6,V$3)=1,ROUNDDOWN($O6*(DAY(V$3)-DAY($K6)+1)/DAY(V$3),-3),IF(Dateinrange($K6,$L6,V$3)=1,$O6,0)))","v":0},{"$f":"IF(Dateinmonth($L6,W$3)=1,$M6-$P6-SUMIFS($S6:$AD6,$S$3:$AD$3,\"<>\"&EOMONTH($L6,0)),IF(Dateinmonth($K6,W$3)=1,ROUNDDOWN($O6*(DAY(W$3)-DAY($K6)+1)/DAY(W$3),-3),IF(Dateinrange($K6,$L6,W$3)=1,$O6,0)))","v":0},{"$f":"IF(Dateinmonth($L6,X$3)=1,$M6-$P6-SUMIFS($S6:$AD6,$S$3:$AD$3,\"<>\"&EOMONTH($L6,0)),IF(Dateinmonth($K6,X$3)=1,ROUNDDOWN($O6*(DAY(X$3)-DAY($K6)+1)/DAY(X$3),-3),IF(Dateinrange($K6,$L6,X$3)=1,$O6,0)))","v":0},{"$f":"IF(Dateinmonth($L6,Y$3)=1,$M6-$P6-SUMIFS($S6:$AD6,$S$3:$AD$3,\"<>\"&EOMONTH($L6,0)),IF(Dateinmonth($K6,Y$3)=1,ROUNDDOWN($O6*(DAY(Y$3)-DAY($K6)+1)/DAY(Y$3),-3),IF(Dateinrange($K6,$L6,Y$3)=1,$O6,0)))","v":8387000},{"$f":"IF(Dateinmonth($L6,Z$3)=1,$M6-$P6-SUMIFS($S6:$AD6,$S$3:$AD$3,\"<>\"&EOMONTH($L6,0)),IF(Dateinmonth($K6,Z$3)=1,ROUNDDOWN($O6*(DAY(Z$3)-DAY($K6)+1)/DAY(Z$3),-3),IF(Dateinrange($K6,$L6,Z$3)=1,$O6,0)))","v":10000000},{"$f":"IF(Dateinmonth($L6,AA$3)=1,$M6-$P6-SUMIFS($S6:$AD6,$S$3:$AD$3,\"<>\"&EOMONTH($L6,0)),IF(Dateinmonth($K6,AA$3)=1,ROUNDDOWN($O6*(DAY(AA$3)-DAY($K6)+1)/DAY(AA$3),-3),IF(Dateinrange($K6,$L6,AA$3)=1,$O6,0)))","v":10000000},{"$f":"IF(Dateinmonth($L6,AB$3)=1,$M6-$P6-SUMIFS($S6:$AD6,$S$3:$AD$3,\"<>\"&EOMONTH($L6,0)),IF(Dateinmonth($K6,AB$3)=1,ROUNDDOWN($O6*(DAY(AB$3)-DAY($K6)+1)/DAY(AB$3),-3),IF(Dateinrange($K6,$L6,AB$3)=1,$O6,0)))","v":10000000},{"$f":"IF(Dateinmonth($L6,AC$3)=1,$M6-$P6-SUMIFS($S6:$AD6,$S$3:$AD$3,\"<>\"&EOMONTH($L6,0)),IF(Dateinmonth($K6,AC$3)=1,ROUNDDOWN($O6*(DAY(AC$3)-DAY($K6)+1)/DAY(AC$3),-3),IF(Dateinrange($K6,$L6,AC$3)=1,$O6,0)))","v":10000000},{"$f":"IF(Dateinmonth($L6,AD$3)=1,$M6-$P6-SUMIFS($S6:$AD6,$S$3:$AD$3,\"<>\"&EOMONTH($L6,0)),IF(Dateinmonth($K6,AD$3)=1,ROUNDDOWN($O6*(DAY(AD$3)-DAY($K6)+1)/DAY(AD$3),-3),IF(Dateinrange($K6,$L6,AD$3)=1,$O6,0)))","v":10000000}]
["Insert above this red line",null,null,null,null,"Insert above this red line"]
[null,null,null,null,null,"Total",null,null,{"$f":"SUM(I4:I7)","v":15427000},null,null,null,{"$f":"SUM(M4:M7)","v":254000000},null,{"$f":"SUM(O4:O7)","v":25427000},{"$f":"SUM(P4:P7)","v":7841000},{"$f":"SUM(Q4:Q7)","v":84077000},{"$f":"SUM(R4:R7)","v":169923000},{"$f":"SUM(S4:S7)","v":1142000},13386000,15427000,15427000,15427000,15427000,23814000,25427000,13188000,11142000,11142000,11142000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manually filled",null,"Book to System"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reconciliation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Org",{"$f":"M8","v":254000000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Detail",{"$f":"Q8+R8","v":254000000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff",{"$f":"P15-P14","v":0},"**must be 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel",{"$f":"R8","v":169923000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TB balance",185350000,"Acc 242"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff",{"$f":"P19-P18","v":15427000},"**must be 0"]

{"sheet":"211","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"341","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"3387","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}