{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sample Computation"],"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":"Sample Computation","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,2,1],[12,0,12,1]]}
["**Input values in cells in gray only"]
[]
["Non-VATable"]
["Purchases-Refunds"]
["Less: MSF"]
["Settlement Amt Before Tax (Purchases - Refunds - MSF)",{"$f":"B4-B5","v":0},{"$f":"B6/2","v":0},"<-- Tax Base"]
[]
["Less: Tax (Settlement Amt Before Tax * 0.50%)",{"$f":"B6*0.5%","v":0}]
["Add: Adjustments/MADJT"]
[]
["Settlement Amt After Tax (Settlement Amt Before Tax - Tax + Adjustments)",{"$f":"B6-B8+B9","v":0}]
[]
["VATable"]
["Purchases-Refunds"]
["Less: MSF"]
["Settlement Amt Before Tax (Purchases - Refunds - MSF)",{"$f":"B14-B15","v":0}]
["Settlement Amt Before Tax Less VAT (Settlement Amt Before Tax / 1.12)",{"$f":"B16/1.12","v":0},{"$f":"B17/2","v":0},"<-- Tax Base"]
[]
["Less: Tax (Settlement Amt Before Tax Less VAT * 0.50%) ",{"$f":"B17*0.5%","v":0}]
["Add: Adjustments/MADJT"]
[]
["Settlement Amt After Tax (Settlement Amt Before Tax - Tax + Adjustments)",{"$f":"B16-B19+B20","v":0}]