{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["بيانات المبيعات","تقرير المبيعات","المخزون"],"not_rendered":{"defined_names":10,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"بيانات المبيعات","index":0,"n_rows":13,"n_cols":11,"rows_kept":13}
[]
[null,"مبيعات آلة تسجيل المدفوعات النقدية اليومية"]
[]
[]
[]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[null,"‎التاريخ","الوقت","رقم العملية","SKU/رقم المنتج","الوصف","مقدار المبيعات","نسبة الضريبة","ضريبة المبيعات","الإجمالي"]
[null,"2012-02-01","10:30:00",1001,90001,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[SKU/رقم المنتج]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[SKU/رقم المنتج]],tblInventory[],2,0)),\"No description found\")","v":"بطانية"},{"v":74.95,"d":" 75 ر.س.‏"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[مقدار المبيعات]]*tblSalesData[[#This Row],[نسبة الضريبة]]","v":{"v":3.7475000000000005,"d":" 4 ر.س.‏"}},{"$f":"tblSalesData[[#This Row],[مقدار المبيعات]]+tblSalesData[[#This Row],[ضريبة المبيعات]]","v":{"v":78.6975,"d":" 79 ر.س.‏"}}]
[null,"2012-02-01","10:33:00",1002,90023,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[SKU/رقم المنتج]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[SKU/رقم المنتج]],tblInventory[],2,0)),\"No description found\")","v":"غطاء طاولة دائري 6 بوصات"},{"v":34.99,"d":" 35 ر.س.‏"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[مقدار المبيعات]]*tblSalesData[[#This Row],[نسبة الضريبة]]","v":{"v":1.7495000000000003,"d":" 2 ر.س.‏"}},{"$f":"tblSalesData[[#This Row],[مقدار المبيعات]]+tblSalesData[[#This Row],[ضريبة المبيعات]]","v":{"v":36.7395,"d":" 37 ر.س.‏"}}]
[null,"2012-02-01","10:45:00",1003,90005,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[SKU/رقم المنتج]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[SKU/رقم المنتج]],tblInventory[],2,0)),\"No description found\")","v":"طبق دائري"},{"v":55.95,"d":" 56 ر.س.‏"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[مقدار المبيعات]]*tblSalesData[[#This Row],[نسبة الضريبة]]","v":{"v":2.7975000000000003,"d":" 3 ر.س.‏"}},{"$f":"tblSalesData[[#This Row],[مقدار المبيعات]]+tblSalesData[[#This Row],[ضريبة المبيعات]]","v":{"v":58.7475,"d":" 59 ر.س.‏"}}]
[null,"2012-02-01","10:55:00",1004,90004,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[SKU/رقم المنتج]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[SKU/رقم المنتج]],tblInventory[],2,0)),\"No description found\")","v":"طبق مربع"},{"v":2.95,"d":" 3 ر.س.‏"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[مقدار المبيعات]]*tblSalesData[[#This Row],[نسبة الضريبة]]","v":{"v":0.14750000000000002,"d":" 0 ر.س.‏"}},{"$f":"tblSalesData[[#This Row],[مقدار المبيعات]]+tblSalesData[[#This Row],[ضريبة المبيعات]]","v":{"v":3.0975,"d":" 3 ر.س.‏"}}]
[null,"2012-02-01","11:45:00",1005,90002,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[SKU/رقم المنتج]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[SKU/رقم المنتج]],tblInventory[],2,0)),\"No description found\")","v":"وسادة"},{"v":14.98,"d":" 15 ر.س.‏"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[مقدار المبيعات]]*tblSalesData[[#This Row],[نسبة الضريبة]]","v":{"v":0.7490000000000001,"d":" 1 ر.س.‏"}},{"$f":"tblSalesData[[#This Row],[مقدار المبيعات]]+tblSalesData[[#This Row],[ضريبة المبيعات]]","v":{"v":15.729000000000001,"d":" 16 ر.س.‏"}}]

{"sheet":"تقرير المبيعات","index":1,"n_rows":14,"n_cols":7,"rows_kept":14}
[]
[null,"النقد اليومي تسجيل المبيعات"]
[]
[]
[]
[]
[]
[null,"SKU/رقم المنتج","الوصف","‎التاريخ","Sum of مقدار المبيعات","Sum of ضريبة المبيعات","Sum of الإجمالي"]
[null,90001,"بطانية","2012-02-01",{"v":74.95,"d":" 75 ر.س.‏"},{"v":3.7475000000000005,"d":" 4 ر.س.‏"},{"v":78.6975,"d":" 79 ر.س.‏"}]
[null,90002,"وسادة","2012-02-01",{"v":14.98,"d":" 15 ر.س.‏"},{"v":0.7490000000000001,"d":" 1 ر.س.‏"},{"v":15.729000000000001,"d":" 16 ر.س.‏"}]
[null,90004,"طبق مربع","2012-02-01",{"v":2.95,"d":" 3 ر.س.‏"},{"v":0.14750000000000002,"d":" 0 ر.س.‏"},{"v":3.0975,"d":" 3 ر.س.‏"}]
[null,90005,"طبق دائري","2012-02-01",{"v":55.95,"d":" 56 ر.س.‏"},{"v":2.7975000000000003,"d":" 3 ر.س.‏"},{"v":58.7475,"d":" 59 ر.س.‏"}]
[null,90023,"غطاء طاولة دائري 6 بوصات","2012-02-01",{"v":34.99,"d":" 35 ر.س.‏"},{"v":1.7495000000000003,"d":" 2 ر.س.‏"},{"v":36.7395,"d":" 37 ر.س.‏"}]
[null,"Grand Total",null,null,{"v":183.82000000000002,"d":" 184 ر.س.‏"},{"v":9.191000000000003,"d":" 9 ر.س.‏"},{"v":193.011,"d":" 193 ر.س.‏"}]

{"sheet":"المخزون","index":2,"n_rows":31,"n_cols":3,"rows_kept":31}
[]
[null,"النقد اليومي تسجيل المبيعات"]
[]
[]
[]
[]
[]
[null,"SKU/رقم المنتج","الوصف"]
[null,90001,"بطانية"]
[null,90002,"وسادة"]
[null,90003,"أغطية"]
[null,90004,"طبق مربع"]
[null,90005,"طبق دائري"]
[null,90006,"سلطانية كبيرة"]
[null,90007,"سلطانية صغيرة"]
[null,90008,"طبق دائري صغير"]
[null,90009,"شوكة صغيرة"]
[null,90010,"شوكة كبيرة"]
[null,90011,"ملعقة صغيرة"]
[null,90012,"ملعقة كبيرة"]
[null,90013,"سكين زبدة صغيرة"]
[null,90014,"سكين زبدة كبيرة"]
[null,90015,"غطاء طاولة 10 × 5"]
[null,90016,"غطاء طاولة 8 × 5"]
[null,90017,"غطاء طاولة 8 × 8"]
[null,90018,"غطاء طاولة 6 × 6"]
[null,90019,"غطاء طاولة 6 × 4"]
[null,90020,"غطاء طاولة 4 × 4"]
[null,90021,"غطاء طاولة دائري 10 بوصات"]
[null,90022,"غطاء طاولة دائري 8 بوصات"]
[null,90023,"غطاء طاولة دائري 6 بوصات"]