{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["data","Purchases","Purchases invoices","j-balance","pos","group","NAME","ITEM","ACUNT","salles invoices","SET"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":1},"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":"data","index":0,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["الباركود","الصنف","السعر البيع","الكميه المشتراه","الكميه المباعه","المخزون","مكان الطباعه","رقم الصنف","مجموعه","سعر الشراء"]
["1A","كوكتيل",5,1000,40,960,null,null,null,5]
["2A","سبرايت",10,1000,5,995,null,null,null,5]
["3A","قهوه",15,1000,90,910,null,null,null,5]
["4A","نسكافية",20,1000,2,998,null,null,null,5]
["5A","شاي لاتيه",25,1000,4,996,null,null,null,5]

{"sheet":"Purchases","index":1,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["المعرف","اسم المورد","تاريخ الشراء","رقم الفاتوره","باركود الصنف","رقم الصنف","الصنف","الكميه","سعر الشراء","سعر البيع"]

{"sheet":"Purchases invoices","index":2,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["الباركود","رقم الصنف","اسم الصنف","الكميه","سعر الشراء","سعر البيع","الإجمالي","رقم السند","المورد","رقم فاتورة المشريات","تاريخ فاتورة المشريات","وقت الادخال"]
[2002,"100002A","100002A",10,5,7,50,1,"محلات المقدادي","A2221A","2023-10-17","2023-10-22T11:51:11"]
["2A","100002A","100002A",15,1,2.5,15,1,"محلات المقدادي","A2221A","2023-10-17","2023-10-22T11:51:11"]

{"sheet":"j-balance","index":3,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["الرقم","مدين","دائن","البيان","البيان الاسم","ملاحظات","تاريخ","وقت الادخال",null,null,"الحساب","مدين ()","دائن()","الرصيد()"]
[1,75,null,"A00002","الصندوق","POINT OF SALE2023-10-22 12:02:52 PM CHASH BILL","2023-10-22","2023-10-22T12:02:54",null,null,"الصندوق",700,null,700]
[1,null,75,"A00004","المبيعات","POINT OF SALE2023-10-22 12:02:52 PM CHASH BILL","2023-10-22","2023-10-22T12:02:54",null,null,"المبيعات",null,1800,-1800]
[2,15,null,1,"احمد","POINT OF SALE2023-10-22 12:03:57 PM احمد","2023-10-22","2023-10-22T12:04:00",null,null,"(blank)",null,null,0]
[2,null,15,"A00004","المبيعات","POINT OF SALE2023-10-22 12:03:57 PM احمد","2023-10-22","2023-10-22T12:04:00",null,null,"احمد",85,null,85]
[3,10,null,"A00002","الصندوق","POINT OF SALE2023-10-22 12:04:09 PM علاء","2023-10-22","2023-10-22T12:04:14",null,null,"علاء",15,null,15]
[3,15,null,4,"علاء","POINT OF SALE2023-10-22 12:04:09 PM علاء","2023-10-22","2023-10-22T12:04:14",null,null,"محمد",1000,null,1000]
[3,null,25,"A00004","المبيعات","POINT OF SALE2023-10-22 12:04:09 PM علاء","2023-10-22","2023-10-22T12:04:14",null,null,"Grand Total",1800,1800,0]
[4,20,null,"A00002","الصندوق","POINT OF SALE2023-10-22 12:56:43 PM احمد","2023-10-22","2023-10-22T12:56:47"]
[4,70,null,1,"احمد","POINT OF SALE2023-10-22 12:56:43 PM احمد","2023-10-22","2023-10-22T12:56:47"]
[4,null,90,"A00004","المبيعات","POINT OF SALE2023-10-22 12:56:43 PM احمد","2023-10-22","2023-10-22T12:56:47"]
[5,595,null,"A00002","الصندوق","POINT OF SALE2023-10-22 1:08:28 PM محمد","2023-10-22","2023-10-22T13:08:40"]
[5,1000,null,2,"محمد","POINT OF SALE2023-10-22 1:08:28 PM محمد","2023-10-22","2023-10-22T13:08:40"]
[5,null,1595,"A00004","المبيعات","POINT OF SALE2023-10-22 1:08:28 PM محمد","2023-10-22","2023-10-22T13:08:40"]

{"sheet":"pos","index":4,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["الباركود","الصنف","السعر","الكميه","الإجمالي","تسلسل","الوقت والتاريخ","الزبون"]
["الباركود","الصنف","السعر","الكميه","الإجمالي","تسلسل","الوقت والتاريخ","الزبون"]

{"sheet":"group","index":5,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["المجموعات"]
["مشروبات"]
["تموين"]
["مواد تنظيف"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," لا"]

{"sheet":"NAME","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["المعرف","الاسم","العنوان","رقم الهاتف","مورد - زيون"]
[1,"احمد","رام الله",123,"Customer"]
[2,"محمد","بيرزيت",124,"Customer"]
[3,"حسن","بيرنبالا",555,"Customer"]
[4,"علاء","بيرنبالا",321,"Customer"]
[5,"شاكر","جنين",987,"Customer"]
[6,"صفاء","طولكرم",569,"Customer"]
[7,"عزات","جنين",115,"Customer"]
[8,"قيس","بير زيت",658,"Customer"]
[9,"نور","نابلس",349,"Customer"]

{"sheet":"ITEM","index":7,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["الباركود","رقم الباركود","اسم الصنف","رقم الصنف"]
["1A","1A","كوكتيل",1]
["2A","2A","سبرايت",2]
["3A","3A","قهوه",3]
["4A","4A","نسكافية",4]
["5A","5A","شاي لاتيه",5]

{"sheet":"ACUNT","index":8,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["المعرف","اسم الحساب"]
["A00001","مشتريات"]
["A00002","الصندوق"]
["A00003","البنك"]
["A00004","المبيعات"]

{"sheet":"salles invoices","index":9,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["الباركود","الصنف","السعر  البيع","الكميه","الإجمالي","رقم السند","الوقت والتاريخ","الزبون"]
["5A","شاي لاتيه",25,1,25,1,"2023-10-22","CASH"]
["4A","نسكافية",20,1,20,1,"2023-10-22","CASH"]
["3A","قهوه",15,1,15,1,"2023-10-22","CASH"]
["2A","سبرايت",10,1,10,1,"2023-10-22","CASH"]
["1A","كوكتيل",5,1,5,1,"2023-10-22","CASH"]
["3A","قهوه",15,1,15,2,"2023-10-22",1]
["5A","شاي لاتيه",25,1,25,3,"2023-10-22",4]
["5A","شاي لاتيه",25,1,25,4,"2023-10-22",1]
["3A","قهوه",15,1,15,4,"2023-10-22",1]
["2A","سبرايت",10,5,50,4,"2023-10-22",1]
["5A","شاي لاتيه",25,1,25,5,"2023-10-22",2]
["1A","كوكتيل",5,40,200,5,"2023-10-22",2]
["3A","قهوه",15,90,1350,5,"2023-10-22",2]
["4A","نسكافية",20,1,20,5,"2023-10-22",2]

{"sheet":"SET","index":10,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["تاريخ 1","تاريخ 2","اجمالي المبيعات"]
["2023-10-18","2023-10-18",{"$f":"SUMIFS('salles invoices'!E:E,'salles invoices'!G:G,\">=\"&A2,'salles invoices'!G:G,\"<=\"&B2)","v":0}]
[]
["تاريخ 1","تاريخ 2","اجمالي المشتريات"]
["2023-10-01","2023-10-18",{"$f":"SUMIFS('Purchases invoices'!G:G,'Purchases invoices'!K:K,\">=\"&A5,'Purchases invoices'!K:K,\"<=\"&B5)","v":65}]