{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["أمر الشراء","قاعدة البيانات","Sheet1"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":1,"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":"أمر الشراء","index":0,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[13,11,13,13],[12,11,12,13],[30,3,30,4],[22,2,22,4],[28,3,28,7],[29,5,29,10],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[28,9,28,10],[20,8,20,9],[21,8,21,9],[26,8,26,9],[12,8,12,9],[13,8,13,9],[19,8,19,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[27,2,27,6],[26,7,27,7],[23,2,23,6],[23,8,23,9],[24,2,24,6],[25,2,25,6],[26,2,26,6],[25,8,25,9],[1,2,1,8],[18,8,18,9],[12,2,12,4],[2,3,2,9],[4,2,4,4],[7,1,7,7],[10,2,10,5],[5,1,5,2],[5,3,5,4],[8,1,8,2],[8,3,8,5],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[3,1,3,3]]}
[]
[null,null,"أمر شراء"]
[]
[null,"2022-03-12",null,null,null,null,null,"الرقم المرجعي",105]
[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,1,null,null,null,null,null,{"$f":"SUM(F14*G14)","v":0}]
[null,2,null,null,null,null,null,{"$f":"SUM(F15*G15)","v":0}]
[null,3,null,null,null,null,null,{"$f":"SUM(F16*G16)","v":0}]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,{"$f":"SUM(F19*G19)","v":0}]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,{"$f":"SUM(F21*G21)","v":0}]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,null,"الاجمالي",null,null,null,null,{"$f":"SUM(H14:H22)","v":0},null,null,null,null,"أدخل نسبة الخصم"]
[null,null,"نسبة الخصم",null,null,null,null,{"$f":"IF(M25>0,H24*M25,0)","v":0},null,null,null,{"$f":"SUM(H24*M25)","v":0}]
[null,null,"ضريبة القيمة المضافة",null,null,null,null,{"$f":"IF(H25>0,(H24-H25)*15%,H24*15%)","v":0},null,null,null,{"$f":"SUM(H25*15%)","v":0}]
[null,null,"الاجمالي شامل ضريبة القيمة المضافة",null,null,null,null,{"$f":"SUM(H24+H26-H25)","v":0},null,null,null,{"$f":"SUM(H25:H26)","v":0}]
[null,null,"فقط "]
[null,null,null,"شاكرين لكم حسن تعاونكم معنا"]
[null,null,null,null,null,null,null,null,null,null,null,null,"For Contact:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ahmedshawky1@gmail.com"]

{"sheet":"قاعدة البيانات","index":1,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["المرجع","التاريخ","المشروع","الموقع","الصنف","الكمية","السعر","الإجمالي","المورد ","عناية","اجمالي قبل الضريبة","نسبة الخصم","القيمة المضافة","الإجمالي العام","شركة","الرقم المرجعي","رقم الصف"]
[101,"2022-02-23","KJ,M","MJBMNB",";LKJ,M",212,41,8692,213132,13454,8992,0.02,1321.8239999999998,10133.984,"Abrakaen",101]
[101,null,null,null,"JH",12,25,300]
[102,"2022-02-23","KJ,M","MJBMNB",";LKJ,M",212,41,8692,213132,13454,13106,null,1965.8999999999999,15071.9,"Abrakaen",102]
[102,null,null,null,"JH",12,25,300]
[102,null,null,null,"LJKH",55,22,1210]
[102,null,null,null,"LKJ",88,33,2904]
[103,"2022-02-27","KJ,M","MJBMNB",";LKJ,M",212,41,8692,213132,13454,8992,0.02,1321.8239999999998,10133.984,"Abrakaen",103]
[103,null,null,null,"JH",12,25,300]
[104,"2022-02-27","رءؤررءؤر","ءؤرءؤر","ءؤرءؤرء",443,23,10189,"يسبسيبسيب","يبيؤيسؤء",10189,0.05,1451.9324999999999,11131.482499999998,"Abrakaen",104]

{"sheet":"Sheet1","index":2,"n_rows":1,"n_cols":17,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["المرجع","التاريخ","المشروع","الموقع","الصنف","الكمية","السعر","الإجمالي","المورد ","عناية","اجمالي قبل الضريبة","نسبة الخصم","القيمة المضافة","الإجمالي العام","شركة","الرقم المرجعي","رقم الصف"]