{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Macro","Sale","MacroAtWork"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Macro","index":0,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Shortcut Build"]
[]
[]
[null,null,null,null,null,null,null,"Macro Test"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Test Again"]
[]
[null,null,null,null,null,null,null,"Test Macro"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Shortcut Build"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veerachai"]
[]
[null,null,null,null,"Test Again"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Macro Test"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Test Shortcut"]

{"sheet":"Sale","index":1,"n_rows":115,"n_cols":18,"rows_kept":115,"cut":false,"hidden":false,"merged":[[2,5,2,16],[2,17,3,17],[114,0,114,4],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4]]}
["Company",null,"C1114"]
["BA",null,"C7"]
["Loc","Project ","Prod","Date","CC","Accrued",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01"]
["L-0423","423","Pepsi","2018-11-16","1423",1182.4100000000001,1182.4100000000001,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(F5:Q5),2)","v":2364.8200000000002}]
["L-0436","436","S Cola","2018-07-03","1436",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0436","436","Fanta","2018-09-10","1436",4000,4000,0,0,0,0,0,0,0,0,0,0,8000]
["L-0436","436","M-100","2018-11-16","1436",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0439","439","S Cola","2019-01-14","1439",11202.02,1722.56,1722.56,0,0,0,0,0,0,0,0,0,14647.14]
["L-0437","437","Coke","2019-01-25","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0438","438","Fanta","2019-01-01","1438",1399.93,1399.93,0,0,0,0,0,0,0,0,0,0,2799.86]
["L-0438","438","S Cola","2019-01-01","1438",44423.86,38773.68,38371.129999999997,978.04,0,0,0,0,0,0,0,0,122546.71]
["L-0436","436","Pepsi","2019-02-01","1436",323.58,306.60000000000002,306.60000000000002,306.60000000000002,0,0,0,0,0,0,0,0,1243.3800000000001]
["L-0436","436","M-100","2019-02-04","1436",451.06,165.83,165.83,165.83,0,0,0,0,0,0,0,0,948.55]
["L-0416","416","Fanta","2019-03-29","1416",4879.71,4879.71,0,0,0,0,0,0,0,0,0,0,9759.42]
["L-0437","437","M-100","2019-03-01","1437",112.31,112.31,0,0,0,0,0,0,0,0,0,0,224.62]
["L-0434","434","Pepsi","2019-03-29","1434",1465.49,1465.49,1465.49,1459.67,0,0,0,0,0,0,0,0,5856.14]
["L-0437","437","Fanta","08/05/2019","1437",291.79000000000002,0,0,0,0,0,0,0,0,0,0,0,291.79000000000002]
["L-0416","416","Pepsi","2019-06-06","1416",21.15,0,0,19.760000000000002,0,0,0,0,0,0,0,0,40.909999999999997]
["L-0434","434","Coke","2019-06-06","1434",778.04,778.04,778.04,778.04,0,0,0,0,0,0,0,0,3112.16]
["L-0436","436","M-100","2019-06-18","1436",917.78,0,0,0,0,0,0,0,0,0,0,0,917.78]
["L-0438","438","Coke","2019-04-01","1438",582.16,582.16,582.16,582.16,0,0,0,0,0,0,0,0,2328.64]
["L-0439","439","Pepsi","2019-06-01","1439",42687.18,2027.85,2027.85,0,0,0,0,0,0,0,0,0,46742.879999999997]
["L-0437","437","Mirinda","2019-06-07","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","S Cola","2019-07-23","1437",618.04,618.04,618.04,0,0,0,0,0,0,0,0,0,1854.12]
["L-0437","437","Mirinda","2019-07-23","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0439","439","Pepsi","2019-07-21","1439",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Coke","2019-07-01","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Coke","2019-08-01","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0436","436","Coke","2019-08-08","1436",5753.01,4959.34,4959.34,0,0,0,0,0,0,0,0,0,15671.69]
["L-0436","436","S Cola","2019-08-12","1436",8575.7000000000007,150.76,150.76,150.76,0,0,0,0,0,0,0,0,9027.98]
["L-0438","438","Sprite","2019-08-01","1438",6057.37,0,0,0,0,0,0,0,0,0,0,0,6057.37]
["L-0438","438","Pepsi","2019-08-04","1438",1593,1398,1398,1263,0,0,0,0,0,0,0,0,5652]
["L-0437","437","S Cola","2019-09-18","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Mirinda","2019-10-10","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","S Cola","2019-10-01","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Sprite","2019-07-01","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0439","439","S Cola","2019-10-01","1439",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0416","416","Coke","2019-11-22","1416",124237.14,57473.95,6518.44,4098.42,0,0,0,0,0,0,0,0,192327.95]
["L-0420",421,"Pepsi","2019-11-22","1421",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0423","423","M-100","2019-11-22","1423",3270,0,0,0,0,0,0,0,0,0,0,0,3270]
["L-0434","434","Coke","2019-11-22","1434",13061.26,1605.2,1056.52,1064.42,0,0,0,0,0,0,0,0,16787.400000000001]
["L-0436","436","Mirinda","2019-11-07","1436",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0436","436","Mirinda","2019-11-01","1436",63702.97,20207.13,7892.24,1125.67,0,0,0,0,0,0,0,0,92928.01]
["L-0436","436","Sprite","2019-11-07","1436",41001.96,32417.82,649.39,649.39,0,0,0,0,0,0,0,0,74718.559999999998]
["L-0436","436","S Cola","2019-12-12","1436",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0436","436","Coke","2019-11-22","1436",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0436","436","Mirinda","2019-12-02","1436",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","S Cola","2019-10-02","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Pepsi","2019-12-01","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0416","416","Mirinda","2019-12-05","1416",442.47,0,0,0,0,0,0,0,0,0,0,0,442.47]
["L-0436","436","Coke","2019-11-29","1436",3780.2,611.61,611.61,611.61,0,0,0,0,0,0,0,0,5615.03]
["L-0436","436","M-100","2019-12-05","1436",18971.310000000001,0,0,70.05,0,0,0,0,0,0,0,0,19041.36]
["L-0436","436","M-100","2019-12-07","1436",74000,62297.41,33988.589999999997,515.25,0,0,0,0,0,0,0,0,170801.25]
["L-0437","437","M-100","2019-12-01","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Mirinda","2019-12-09","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Pepsi","2019-12-15","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Coke","2019-12-20","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0438","438","Sprite","2019-12-18","1438",4194.2,4194.2,4194.2,4194.2,0,0,0,0,0,0,0,0,16776.8]
["L-0437","437","M-100","2020-01-01","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0416","416","Sprite","2020-01-10","1416",353314.22,367703.3,219426.74,29113.08,0,0,0,0,0,0,0,0,969557.34]
["L-0416","416","S Cola","2020-01-06","1416",29880,29778.31,1234.1199999999999,0,0,0,0,0,0,0,0,0,60892.43]
["L-0420","420","Sprite","2020-03-01","1420",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0423","423","Fanta","2020-01-01","1423",11298.91,16844.96,93149.81,0,0,0,0,0,0,0,0,0,121293.68]
["L-0423","423","M-100","2020-01-10","1423",357677.42,21015.46,26521.3,1462.03,0,0,0,0,0,0,0,0,406676.21]
["L-0434","434","Fanta","2020-01-10","1434",82177.070000000007,64123.9,5957.22,5964.85,0,0,0,0,0,0,0,0,158223.04000000001]
["L-0436","436","Coke","2020-01-10","1436",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0436","436","Coke","2020-02-01","1436",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Pepsi","2020-01-10","1437",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(F69:Q69),2)","v":0}]
["L-0437","437","M-100","2020-01-10","1437",4509.54,353.53,0,0,0,0,0,0,0,0,0,0,4863.07]
["L-0437","437","Pepsi","2020-01-25","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Pepsi","2020-01-17","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","M-100","2020-01-17","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Pepsi","2020-01-18","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0439","439","S Cola","2020-01-16","1439",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0416","416","M-100","2020-03-20","1416",0,0,205470.98,48793.33,0,0,0,0,0,0,0,0,254264.31]
["L-0416","416","S Cola","2020-02-07","1416",0,23240,16119.73,15219.25,0,0,0,0,0,0,0,0,54578.98]
["L-0416","416","Fanta","2020-03-20","1416",0,0,749.26,0,0,0,0,0,0,0,0,0,749.26]
["L-0416","416","Pepsi","2020-02-28","1416",0,22089.07,32000.9,35.53,0,0,0,0,0,0,0,0,54125.5]
["L-0423","423","Pepsi","2020-03-20","1423",0,0,333000,275314.51,0,0,0,0,0,0,0,0,608314.51]
["L-0434","434","Fanta","2020-03-20","1434",0,0,36520,30012.53,0,0,0,0,0,0,0,0,66532.53]
["L-0437","437","M-100","2020-02-25","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Mirinda","2020-02-10","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Mirinda","2020-02-10","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Sprite","2020-03-20","1437",0,0,332.96,139.66,0,0,0,0,0,0,0,0,472.62]
["L-0437","437","Fanta","2020-02-01","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Fanta","2020-01-01","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Pepsi","2020-03-01","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Coke","2020-01-09","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","S Cola","2020-01-09","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Coke","2020-01-09","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0437","437","Fanta","2020-02-27","1437",0,416.5,708.09,352.09,0,0,0,0,0,0,0,0,1476.68]
["L-0437","437","Sprite","2020-02-27","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0438","438","Mirinda","2020-02-17","1438",0,479.25,175.27,0,0,0,0,0,0,0,0,0,654.52]
["L-0438","438","Fanta","2020-02-17","1438",0,2053.92,0,0,0,0,0,0,0,0,0,0,2053.92]
["L-0438","438","Sprite","2020-02-10","1438",0,475.63,0,0,0,0,0,0,0,0,0,0,475.63]
["L-0439","439","Sprite","2020-02-01","1439",0,6986.43,14454.68,19679.509999999998,0,0,0,0,0,0,0,0,41120.620000000003]
["L-0437","437","M-100","2019-11-01","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0436","436","Mirinda","2019-08-08","1436",0,0,1156.42,0,0,0,0,0,0,0,0,0,1156.42]
["L-0436","436","M-100","2020-02-29","1436",0,0,4780.37,3453.63,0,0,0,0,0,0,0,0,8234]
["L-0436","436","M-100","2020-03-20","1436",0,0,26400,8276.76,0,0,0,0,0,0,0,0,34676.76]
["L-0436","436","Coke","2020-03-06","1436",0,0,1520.27,0,0,0,0,0,0,0,0,0,1520.27]
["L-0437","437","Pepsi","2020-03-01","1437",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0436","436","Fanta","2020-04-20","1436",0,0,0,0,0,0,0,0,0,0,0,0,0]
["L-0436","436","Coke","2020-04-22","1436",0,0,0,649.79999999999995,0,0,0,0,0,0,0,0,649.79999999999995]
["L-0436","436","Sprite","2020-04-21","1436",0,0,0,9630,0,0,0,0,0,0,0,0,9630]
["L-0436","436","Sprite","2020-04-15","1436",0,0,0,1383.83,0,0,0,0,0,0,0,0,1383.83]
["L-0438","438","S Cola","2020-04-16","1438",0,0,0,3264.6,0,0,0,0,0,0,0,0,3264.6]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total",null,null,null,null,1322834.26,798890.29,1127134.9100000001,470777.86,0,0,0,0,0,0,0,0,{"$f":"SUM(R5:R114)","v":3719637.32}]

{"sheet":"MacroAtWork","index":2,"n_rows":105,"n_cols":6,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["Location","Project ","Product","Date","CostCenter","Total"]
["L-0423","423","Pepsi","2018-11-16","1423",2364.8200000000002]
["L-0436","436","S Cola","2018-07-03","1436",0]
["L-0436","436","Fanta","2018-09-10","1436",8000]
["L-0436","436","M-100","2018-11-16","1436",0]
["L-0439","439","S Cola","2019-01-14","1439",14647.14]
["L-0437","437","Coke","2019-01-25","1437",0]
["L-0438","438","Fanta","2019-01-01","1438",2799.86]
["L-0438","438","S Cola","2019-01-01","1438",122546.71]
["L-0436","436","Pepsi","2019-02-01","1436",1243.3800000000001]
["L-0436","436","M-100","2019-02-04","1436",948.55]
["L-0416","416","Fanta","2019-03-29","1416",9759.42]
["L-0437","437","M-100","2019-03-01","1437",224.62]
["L-0434","434","Pepsi","2019-03-29","1434",5856.14]
["L-0437","437","Fanta","08/05/2019","1437",291.79000000000002]
["L-0416","416","Pepsi","2019-06-06","1416",40.909999999999997]
["L-0434","434","Coke","2019-06-06","1434",3112.16]
["L-0436","436","M-100","2019-06-18","1436",917.78]
["L-0438","438","Coke","2019-04-01","1438",2328.64]
["L-0439","439","Pepsi","2019-06-01","1439",46742.879999999997]
["L-0437","437","Mirinda","2019-06-07","1437",0]
["L-0437","437","S Cola","2019-07-23","1437",1854.12]
["L-0437","437","Mirinda","2019-07-23","1437",0]
["L-0439","439","Pepsi","2019-07-21","1439",0]
["L-0437","437","Coke","2019-07-01","1437",0]
["L-0437","437","Coke","2019-08-01","1437",0]
["L-0436","436","Coke","2019-08-08","1436",15671.69]
["L-0436","436","S Cola","2019-08-12","1436",9027.98]
["L-0438","438","Sprite","2019-08-01","1438",6057.37]
["L-0438","438","Pepsi","2019-08-04","1438",5652]
["L-0437","437","S Cola","2019-09-18","1437",0]
["L-0437","437","Mirinda","2019-10-10","1437",0]
["L-0437","437","S Cola","2019-10-01","1437",0]
["L-0437","437","Sprite","2019-07-01","1437",0]
["L-0439","439","S Cola","2019-10-01","1439",0]
["L-0416","416","Coke","2019-11-22","1416",192327.95]
["L-0420",421,"Pepsi","2019-11-22","1421",0]
["L-0423","423","M-100","2019-11-22","1423",3270]
["L-0434","434","Coke","2019-11-22","1434",16787.400000000001]
["L-0436","436","Mirinda","2019-11-07","1436",0]
["L-0436","436","Mirinda","2019-11-01","1436",92928.01]
["L-0436","436","Sprite","2019-11-07","1436",74718.559999999998]
["L-0436","436","S Cola","2019-12-12","1436",0]
["L-0436","436","Coke","2019-11-22","1436",0]
["L-0436","436","Mirinda","2019-12-02","1436",0]
["L-0437","437","S Cola","2019-10-02","1437",0]
["L-0437","437","Pepsi","2019-12-01","1437",0]
["L-0416","416","Mirinda","2019-12-05","1416",442.47]
["L-0436","436","Coke","2019-11-29","1436",5615.03]
["L-0436","436","M-100","2019-12-05","1436",19041.36]
["L-0436","436","M-100","2019-12-07","1436",170801.25]
["L-0437","437","M-100","2019-12-01","1437",0]
["L-0437","437","Mirinda","2019-12-09","1437",0]
["L-0437","437","Pepsi","2019-12-15","1437",0]
["L-0437","437","Coke","2019-12-20","1437",0]
["L-0438","438","Sprite","2019-12-18","1438",16776.8]
["L-0437","437","M-100","2020-01-01","1437",0]
["L-0416","416","Sprite","2020-01-10","1416",969557.34]
["L-0416","416","S Cola","2020-01-06","1416",60892.43]
["L-0420","420","Sprite","2020-03-01","1420",0]
["L-0423","423","Fanta","2020-01-01","1423",121293.68]
["L-0423","423","M-100","2020-01-10","1423",406676.21]
["L-0434","434","Fanta","2020-01-10","1434",158223.04000000001]
["L-0436","436","Coke","2020-01-10","1436",0]
["L-0436","436","Coke","2020-02-01","1436",0]
["L-0437","437","Pepsi","2020-01-10","1437",0]
["L-0437","437","M-100","2020-01-10","1437",4863.07]
["L-0437","437","Pepsi","2020-01-25","1437",0]
["L-0437","437","Pepsi","2020-01-17","1437",0]
["L-0437","437","M-100","2020-01-17","1437",0]
["L-0437","437","Pepsi","2020-01-18","1437",0]
["L-0439","439","S Cola","2020-01-16","1439",0]
["L-0416","416","M-100","2020-03-20","1416",254264.31]
["L-0416","416","S Cola","2020-02-07","1416",54578.98]
["L-0416","416","Fanta","2020-03-20","1416",749.26]
["L-0416","416","Pepsi","2020-02-28","1416",54125.5]
["L-0423","423","Pepsi","2020-03-20","1423",608314.51]
["L-0434","434","Fanta","2020-03-20","1434",66532.53]
["L-0437","437","M-100","2020-02-25","1437",0]
["L-0437","437","Mirinda","2020-02-10","1437",0]
["L-0437","437","Mirinda","2020-02-10","1437",0]
["L-0437","437","Sprite","2020-03-20","1437",472.62]
["L-0437","437","Fanta","2020-02-01","1437",0]
["L-0437","437","Fanta","2020-01-01","1437",0]
["L-0437","437","Pepsi","2020-03-01","1437",0]
["L-0437","437","Coke","2020-01-09","1437",0]
["L-0437","437","S Cola","2020-01-09","1437",0]
["L-0437","437","Coke","2020-01-09","1437",0]
["L-0437","437","Fanta","2020-02-27","1437",1476.68]
["L-0437","437","Sprite","2020-02-27","1437",0]
["L-0438","438","Mirinda","2020-02-17","1438",654.52]
["L-0438","438","Fanta","2020-02-17","1438",2053.92]
["L-0438","438","Sprite","2020-02-10","1438",475.63]
["L-0439","439","Sprite","2020-02-01","1439",41120.620000000003]
["L-0437","437","M-100","2019-11-01","1437",0]
["L-0436","436","Mirinda","2019-08-08","1436",1156.42]
["L-0436","436","M-100","2020-02-29","1436",8234]
["L-0436","436","M-100","2020-03-20","1436",34676.76]
["L-0436","436","Coke","2020-03-06","1436",1520.27]
["L-0437","437","Pepsi","2020-03-01","1437",0]
["L-0436","436","Fanta","2020-04-20","1436",0]
["L-0436","436","Coke","2020-04-22","1436",649.79999999999995]
["L-0436","436","Sprite","2020-04-21","1436",9630]
["L-0436","436","Sprite","2020-04-15","1436",1383.83]
["L-0438","438","S Cola","2020-04-16","1438",3264.6]