{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["أمر الشراء","قاعدة البيانات","طلب أسعار"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[13,13,13,21],[17,11,17,13],[34,8,35,10],[22,2,22,4],[20,2,20,4],[25,8,25,9],[20,8,20,9],[21,2,21,4],[21,8,21,9],[26,8,26,9],[27,3,27,5],[27,7,27,8],[27,9,27,10],[23,2,23,6],[23,8,23,9],[28,3,28,7],[28,9,28,10],[12,8,12,9],[13,2,13,4],[13,8,13,9],[19,8,19,9],[14,2,14,4],[14,8,14,9],[15,2,15,4],[15,8,15,9],[16,2,16,4],[16,8,16,9],[17,2,17,4],[17,8,17,9],[25,2,25,6],[26,2,26,6],[29,5,29,10],[1,2,1,8],[12,11,12,12],[18,2,18,4],[18,8,18,9],[19,2,19,4],[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],[3,1,3,2],[8,1,8,2],[8,3,8,5]]}
[]
[null,null,"طلب توريد"]
[]
[null,"2021-06-10",null,null,null,null,null,"الرقم المرجعي",112]
[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,null,null,null,null,"المطلوب عند ادخال رقم مرجعي تم حفظه مسبقاً في قاعدة البيانات وبعد الضفط على Search يتم استرجاع مجموعة الأصناف المرتبطة به من قاعد البيانات الى عمود الصنف"]
[null,2,null,null,null,null,null,0]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,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(H25:H26)","v":0},null,null,null,{"$f":"SUM(H25:H26)","v":0}]
[]
[null,null,"\n","شاكرين لكم حسن تعاونكم معنا"]
[]
[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,"050 4941440"]

{"sheet":"قاعدة البيانات","index":1,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["المرجع","التاريخ","المشروع","الموقع","الصنف","الكمية","السعر","الإجمالي","المورد ","عناية","اجمالي قبل الضريبة","نسبة الخصم","القيمة المضافة","الإجمالي العام","شركة","الرقم المرجعي","رقم الصف"]
[101,"28-3-2021",null,null,"حديد تسليح سعودي/سابك 12 مم(طن)",3.5,null,null,null,"خالد",null,null,null,null,"Abrakaen",115,{"$f":"MATCH(P2,A1:A10000,0)","v":{"$error":"#N/A"}}]
[null,"28-3-2021",null,null,"سلك تربيط 22جج (7 كجم )",70,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(E1:E1000,MATCH(P2,A1:A1000,0)),\"0\")","v":"0"}]
[102,"2021-08-04",null,null,"حديد تسليح سعودي /سابك14مم(طن)",3,null,null,null,"خالد",null,null,null,null,"Abrakaen"]
[null,"2021-08-04",null,null,"مسمار برأس فلة(11*2.5)4كيلو(كرتون)",30]
[103,"15-4-2021",null,null,"حديد تسليح 8 مم (طن)",3,null,null,null,"خالد",null,null,null,null,"Abrakaen"]
[null,"15-4-2021",null,null,"حديد تسليح 10 مم ( طن )",0.5]
[null,"15-4-2021",null,null,"حديد تسليح سعودي/سابك 14مم (طن )",0.5]
[null,"15-4-2021",null,null,"حديد تسليح سعودي/سابك 16 مم(طن)",2]
[null,"15-4-2021",null,null,"حديد تسليح سعودي / سابك 18مم (طن)",12]
[104,"17-4-2021",null,null,"بلايوود أحمر صيني (13 ط) 18مم *4 *8",70,null,null,null,"خالد",null,null,null,null,"Abrakaen"]
[105,"2021-09-05",null,null,"شبك حديد ارضيات 8مم فتحة 20*20سم(1.5*4م)",50,null,null,null,"خالد",null,null,null,null,"Abrakaen"]
[null,"2021-09-05",null,null,"بولي ايثيلين شيت 500 ميكرون ( لفة بلاستيك )",90]
[null,"2021-09-05",null,null,"مسمار مقاس ( 2.5\" )",50]
[106,"19/5/2021",null,null,"شبك حديد ارضيات 8مم فتحة 20*20سم(1.5*4م)",40,null,null,null,"خالد",null,null,null,null,"Abrakaen"]
[107,"26/5/2021",null,null,"حديد تسليح 8 مم",2,null,null,null,"حسن",null,null,null,null,"Abrakaen"]
[null,null,null,null,"حديد تسليح  سابك12 مم",1]
[null,null,null,null,"حديد تسليح سابك 16 مم",4]
[108,"24/5/2021",null,null,"ماسورة مقاس 3\" × 3.5 مم",10,null,null,null,"عيد",null,0.26,290.54249999999996,null,"Abrakaen"]
[null,null,null,null,"ماسورة مقاس 2\"",15]
[109,"2021-05-31",null,null,"بلابوود مدهون صيني 13 رقم 1 مقصوص",100,null,null,null,"خالد",null,0,1080,null,"Abrakaen"]
[null,null,null,null,"خشب أبيض 1 *3 * 4 متر",1]
[110,"2021-06-01",null,null,"حديد تسليح سابك 16 مم",3,null,null,null,"حسن",null,0,1395,null,"Abrakaen"]
[111,"2021-06-10",null,null,"حديد تسليح سابك 8 مم ( طن )",2,null,null,null,"حسن",null,0,4275,null,"Abrakaen"]
[null,null,null,null,"حديد تسليح سابك 10 مم ( طن )",1]
[null,null,null,null,"حديد تسليح سعودي/سابك 12مم (طن )",1]
[null,null,null,null,"حديد تسليح سعودي/سابك 14مم (طن )",1]
[null,null,null,null,"حديد تسليح سعودي/سابك 16مم (طن )",4]

{"sheet":"طلب أسعار","index":2,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,8,29,10],[29,11,29,12],[23,4,23,6],[24,4,24,8],[24,10,24,11],[25,4,25,8],[25,10,25,11],[26,4,26,8],[26,10,26,11],[27,5,27,7],[27,9,27,10],[27,11,27,12],[28,5,28,9],[28,11,28,12],[20,4,20,6],[20,10,20,11],[21,4,21,6],[21,10,21,11],[22,4,22,6],[22,10,22,11],[17,4,17,6],[17,10,17,11],[18,4,18,6],[18,10,18,11],[19,4,19,6],[19,10,19,11],[14,4,14,6],[14,10,14,11],[15,4,15,6],[15,10,15,11],[16,4,16,6],[16,10,16,11],[13,10,13,11],[2,4,2,10],[3,5,3,11],[4,3,4,4],[5,4,5,6],[6,3,6,4],[6,5,6,6],[8,3,8,9],[9,3,9,4],[9,5,9,7],[11,4,11,7],[13,4,13,6]]}
[]
[]
[null,null,null,null,"طلب عرض سعر"]
[]
[null,null,null,{"$f":"TODAY()","v":"2021-06-10"},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,1,null,null,null,null,null,{"$f":"SUM(H15*I15)","v":0}]
[null,null,null,2,null,null,null,null,null,0]
[null,null,null,3,null,null,null,null,null,0]
[null,null,null,4,null,null,null,null,null,0]
[null,null,null,5,null,null,null,null,null,0]
[null,null,null,6,null,null,null,null,null,0]
[null,null,null,7,null,null,null,null,null,0]
[null,null,null,8,null,null,null,null,null,0]
[null,null,null,9,null,null,null,null,null,0]
[null,null,null,10,null,null,null,null,null,0]
[null,null,null,null,"الاجمالي ",null,null,null,null,{"$f":"SUM(J15:J23)","v":0}]
[null,null,null,null,"ضريبة القيمة المضافة",null,null,null,null,{"$f":"SUM(J25*15%)","v":0}]
[null,null,null,null,"الاجمالي شامل ضريبة القيمة المضافة",null,null,null,null,{"$f":"SUM(J25:J26)","v":0}]
[]
[null,null,null,null,"\n","شاكرين لكم حسن تعاونكم معنا"]
[null,null,null,null,null,null,null,null,"شركة وادي الابرقين للمقاولات"]