{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Invoice","Data","Sales","Customers Data","Class"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Invoice","index":0,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Invoice Date"]
[null,"Invoice #"]
[null,"Customer Name"]
[null,"TAX NO",{"$f":"IFERROR(VLOOKUP($C$4,Table2[],2,0),\"\")","v":""}]
[null,"Sales Class"]
[null,"Invoice Type"]
[null,"Discount","Sub Total","VAT","WHT",null,"Final Total"]
[null,null,{"$f":"SUM(G12:$G$51)-$B$9","v":0},{"$f":"IF($C$7=\"Tax\",$C$9*0.14,0)","v":0},null,null,{"$f":"$C$9+$D$9-$E$9","v":0}]
[]
[null,"Item#","Description","Unit","QYT","Unite Price","Total","invoice","date","Vendor"]
[null,{"$f":"IF(C12<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C12),\"\")","v":""},null,null,null,null,{"$f":"IF(C12<>\"\",E12*F12,\"\")","v":""},{"$f":"IF($C12<>\"\",$C$3,\"\")","v":""},{"$f":"IF($C12<>\"\",$C$2,\"\")","v":""},{"$f":"IF($C12<>\"\",$C$4,\"\")","v":""}]
[null,{"$f":"IF(C13<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C13),\"\")","v":""},null,null,null,null,{"$f":"IF(C13<>\"\",E13*F13,\"\")","v":""},{"$f":"IF($C13<>\"\",$C$3,\"\")","v":""},{"$f":"IF($C13<>\"\",$C$2,\"\")","v":""},{"$f":"IF($C13<>\"\",$C$4,\"\")","v":""}]
[null,{"$f":"IF(C14<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C14),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C15<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C15),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C16<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C16),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C17<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C17),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C18<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C18),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C19<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C19),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C20<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C20),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C21<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C21),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C22<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C22),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C23<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C23),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C24<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C24),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C25<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C25),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C26<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C26),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C27<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C27),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C28<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C28),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C29<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C29),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C30<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C30),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C31<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C31),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C32<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C32),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C33<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C33),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C34<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C34),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C35<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C35),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C36<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C36),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C37<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C37),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C38<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C38),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C39<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C39),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C40<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C40),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C41<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C41),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C42<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C42),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C43<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C43),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C44<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C44),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C45<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C45),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C46<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C46),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C47<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C47),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C48<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C48),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C49<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C49),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C50<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C50),\"\")","v":""},null,null,null,null,"","","",""]
[null,{"$f":"IF(C51<>\"\",_xlfn.AGGREGATE(3,3,$C$12:C51),\"\")","v":""},null,null,null,null,{"$f":"IF(C51<>\"\",E51*F51,\"\")","v":""},"","",""]

{"sheet":"Data","index":1,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Invoice Date","Invoice #","Customer Name","TAX NO","Sales Class","Invoice Type","Sub Total","VAT","WHT","Final Total"]
["00:00:00",0,0,0,0,0,0,0,0,0]

{"sheet":"Sales","index":2,"n_rows":459,"n_cols":8,"rows_kept":459,"cut":false,"hidden":false,"merged":[]}
["Discription","Unit","QYT","Unit Price","Total","Invoice #","Invoice Date","Customer Name"]
[0,0,0,0,0,0,0,0]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]

{"sheet":"Customers Data","index":3,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Customer Name","TAX NO"]
[null,"Mohamed",123456789]

{"sheet":"Class","index":4,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null," Class"]
[null,"Service"]