{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["قائمة المواد","Sheet1","نموذج","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["اسم المادة","الثمن بالدينار","الوحدة",null,null,null,"اسم المورد "]
["ملح بالبود 01 كغ",30,"وحدة",null,null,null,"الاسم 01"]
["ياغوورت نوعية رفيعة",29,"وحدة",null,null,null,"الاسم 02"]
["لفاح 01 كغ",570,"كلغ",null,null,null,"الاسم 03"]
["زيت المائدة بدون كلسترول 05 ل",680,"وحدة",null,null,null,"الاسم 04"]
["تليتلي 800 غ",100,"وحدة",null,null,null,"الاسم 05"]
["كسكسي 01 كغ",140,"وحدة",null,null,null,"الاسم 06"]
["شربة فريك 01 كلغ",450,"وحدة",null,null,null,"الاسم 07"]
["عدس 800غ",220,"وحدة",null,null,null,"الاسم 08"]
["حمص 800 غ",380,"وحدة",null,null,null,"الاسم 09"]
["أرز مفور 800 غ",140,"وحدة",null,null,null,"الاسم 10"]
["خل قارورة",20,"قارورة",null,null,null,"الاسم 11"]
["لوبيا",240,"كلغ",null,null,null,"الاسم 12"]
["شربة فرميسال",100,"كلغ",null,null,null,"الاسم 13"]
["سباقيتي",100,"كلغ",null,null,null,"الاسم 14"]
["ثوم مرحي",1400,"كلغ",null,null,null,"الاسم 15"]
["جبن حبة نوعية رفيعة",15,"وحدة",null,null,null,"الاسم 16"]
["طماطم مصبرة 400غ",120,"وحدة",null,null,null,"الاسم 17"]
["زبدة",690,"كلغ",null,null,null,"الاسم 18"]
["فلفل أحمر مرحي",780,"كلغ",null,null,null,"الاسم 19"]
["جزر",95,"كلغ",null,null,null,"الاسم 20"]
["خرشف",70,"كلغ",null,null,null,"الاسم 21"]
["خيار",85,"كلغ",null,null,null,"الاسم 22"]
["لفت",70,"كلغ",null,null,null,"الاسم 23"]
["بطاطا",90,"كلغ",null,null,null,"الاسم 24"]
["بصل",100,"كلغ",null,null,null,"الاسم 25"]
["طماطم",110,"كلغ"]
["زيتون أسود",380,"كلغ"]
["زيتون أخضر",430,"كلغ"]
["تفاح",350,"كلغ"]
["موز",470,"كلغ"]
["برتقال",240,"كلغ"]
["تمر",290,"كلغ"]
["اليوسفية مندرينة",240,"كلغ"]
["زعرورة",200,"كلغ"]
["أنناس علب",240,"علبة"]
["سلاطة",80,"كلغ"]
["دبشة",15,"ربطة"]
["بسباس",80,"كلغ"]
["خبز عادي",8,"وحدة"]
["لحم العجل الطازج",1300,"كلغ"]
["دجاج مفرغ لا يقل وزنه عن 02 كلغ",330,"كلغ"]
["صفائح البيض 30 بيضة",300,"صفيحة"]
[""]

{"sheet":"Sheet1","index":1,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[7,1,7,3],[27,0,27,6],[28,0,28,7]]}
[]
[null,null,"الجمهورية الجزائرية الديمقراطية الشعبية"]
["ولاية : برج بوعريريج"]
["دائرة : مجــــــــــانــــة",null,null,null,"اسم المورد :"]
["بلدية : ثنية النصــــــــر",null,null,null,"التاريخ :"]
["المكلف بتسيير المطاعم المدرسية"]
[null,null,null,"وصل تسليم رقم :"]
["الرقم","تعييـــــــــــــــــن البضاعـــــة",null,null,"الوحدة","الكمية","سعر الوحدة","المبلغ الاجمالي"]
[{"$f":"IF(ISBLANK(B9),\"\",COUNTA(B$8:$C9)-1)","v":1},"لفاح 01 كغ",null,null,null,3,{"$f":"IF(ISBLANK(B9),\"\",VLOOKUP(B9,_list,2,0))","v":570},{"$f":"IF(ISBLANK(B9),\"\",F9*G9)","v":1710}]
[{"$f":"IF(ISBLANK(B10),\"\",COUNTA(B$8:$C10)-1)","v":2},"شربة فريك 01 كلغ",null,null,null,3,450,{"$f":"IF(ISBLANK(B10),\"\",F10*G10)","v":1350}]
[{"$f":"IF(ISBLANK(B11),\"\",COUNTA(B$8:$C11)-1)","v":3},"زيت المائدة بدون كلسترول 05 ل",null,null,null,6,680,4080]
[{"$f":"IF(ISBLANK(B12),\"\",COUNTA(B$8:$C12)-1)","v":4},"شربة فريك 01 كلغ",null,null,null,2,450,900]
[{"$f":"IF(ISBLANK(B13),\"\",COUNTA(B$8:$C13)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B14),\"\",COUNTA(B$8:$C14)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B15),\"\",COUNTA(B$8:$C15)-1)","v":""},null,null,null,null,null,"",{"$f":"IF(ISBLANK(B15),\"\",F15*G15)","v":""}]
[{"$f":"IF(ISBLANK(B16),\"\",COUNTA(B$8:$C16)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B17),\"\",COUNTA(B$8:$C17)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B18),\"\",COUNTA(B$8:$C18)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B19),\"\",COUNTA(B$8:$C19)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B20),\"\",COUNTA(B$8:$C20)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B21),\"\",COUNTA(B$8:$C21)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B22),\"\",COUNTA(B$8:$C22)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B23),\"\",COUNTA(B$8:$C23)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B24),\"\",COUNTA(B$8:$C24)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B25),\"\",COUNTA(B$8:$C25)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B26),\"\",COUNTA(B$8:$C26)-1)","v":""},null,null,null,null,null,"",""]
[{"$f":"IF(ISBLANK(B27),\"\",COUNTA(B$8:$C27)-1)","v":""},null,null,null,null,null,"",""]
["الإجمالي",null,null,null,null,null,null,{"$f":"SUM(H9:H27)","v":8040}]
[{"$f":"[1]!NoToTxt(H28,\"دينار\",\"فلس\")","v":{"$error":"#NAME?"}}]

{"sheet":"نموذج","index":2,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":true,"merged":[[1,2,1,5],[27,2,27,4],[28,2,28,5],[3,3,3,5]]}
[]
[null,null,"إيصال إستلام"]
[]
[null,null,"اسم المورد :"]
[null,null,null,null,"التاريخ :",{"$f":"TODAY()","v":"2018-09-25"}]
[]
[null,null,"بيان البضاعة المسلمة "]
[null,"مسلسل","اسم المادة","الثمن بالدينار","العدد","إجمالي الثمن بالدينار"]
[null,{"$f":"IF(ISBLANK(C9),\"\",COUNTA($C$8:C9)-1)","v":1},"زيت المائدة بدون كلسترول 05 ل",{"$f":"IF(ISBLANK(C9),\"\",VLOOKUP(C9,_list,2,0))","v":680},3,{"$f":"IF(ISBLANK(C9),\"\",D9*E9)","v":2040}]
[null,{"$f":"IF(ISBLANK(C10),\"\",COUNTA($C$8:C10)-1)","v":2},"ياغوورت نوعية رفيعة",29,3,87]
[null,{"$f":"IF(ISBLANK(C11),\"\",COUNTA($C$8:C11)-1)","v":3},"تليتلي 800 غ",100,6,600]
[null,{"$f":"IF(ISBLANK(C12),\"\",COUNTA($C$8:C12)-1)","v":4},"عدس 800غ",220,2,440]
[null,{"$f":"IF(ISBLANK(C13),\"\",COUNTA($C$8:C13)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C14),\"\",COUNTA($C$8:C14)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C15),\"\",COUNTA($C$8:C15)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C16),\"\",COUNTA($C$8:C16)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C17),\"\",COUNTA($C$8:C17)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C18),\"\",COUNTA($C$8:C18)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C19),\"\",COUNTA($C$8:C19)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C20),\"\",COUNTA($C$8:C20)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C21),\"\",COUNTA($C$8:C21)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C22),\"\",COUNTA($C$8:C22)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C23),\"\",COUNTA($C$8:C23)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C24),\"\",COUNTA($C$8:C24)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C25),\"\",COUNTA($C$8:C25)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C26),\"\",COUNTA($C$8:C26)-1)","v":""},null,"",null,""]
[null,{"$f":"IF(ISBLANK(C27),\"\",COUNTA($C$8:C27)-1)","v":""},null,"",null,""]
[null,null,"الإجمالي",null,null,{"$f":"SUM(F9:F27)","v":3167}]
[null,null,{"$f":"[1]!NoToTxt(F28,\"دينار\",\"فلس\")","v":{"$error":"#NAME?"}}]

{"sheet":"Sheet2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet3","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}