{"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,null,"اسم المورد "]
["ملح بالبود 01 كغ",30,null,null,null,null,"الاسم 01"]
["ياغوورت نوعية رفيعة",29,null,null,null,null,"الاسم 02"]
["لفاح 01 كغ",570,null,null,null,null,"الاسم 03"]
["زيت المائدة بدون كلسترول 05 ل",680,null,null,null,null,"الاسم 04"]
["تليتلي 800 غ",100,null,null,null,null,"الاسم 05"]
["كسكسي 01 كغ",140,null,null,null,null,"الاسم 06"]
["شربة فريك 01 كلغ",450,null,null,null,null,"الاسم 07"]
["عدس 800غ",220,null,null,null,null,"الاسم 08"]
["حمص 800 غ",380,null,null,null,null,"الاسم 09"]
["أرز مفور 800 غ",140,null,null,null,null,"الاسم 10"]
["خل قارورة",20,null,null,null,null,"الاسم 11"]
["لوبيا",240,null,null,null,null,"الاسم 12"]
["شربة فرميسال",100,null,null,null,null,"الاسم 13"]
["سباقيتي",100,null,null,null,null,"الاسم 14"]
["ثوم مرحي",1400,null,null,null,null,"الاسم 15"]
["جبن حبة نوعية رفيعة",15,null,null,null,null,"الاسم 16"]
["طماطم مصبرة 400غ",120,null,null,null,null,"الاسم 17"]
["زبدة",690,null,null,null,null,"الاسم 18"]
["فلفل أحمر مرحي",780,null,null,null,null,"الاسم 19"]
["جزر",95,null,null,null,null,"الاسم 20"]
["خرشف",70,null,null,null,null,"الاسم 21"]
["خيار",85,null,null,null,null,"الاسم 22"]
["لفت",70,null,null,null,null,"الاسم 23"]
["بطاطا",90,null,null,null,null,"الاسم 24"]
["بصل",100,null,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,{"$f":"IF(ISBLANK(B10),\"\",VLOOKUP(B10,_list,2,0))","v":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,{"$f":"IF(ISBLANK(B11),\"\",VLOOKUP(B11,_list,2,0))","v":680},4080]
[{"$f":"IF(ISBLANK(B12),\"\",COUNTA(B$8:$C12)-1)","v":4},"شربة فريك 01 كلغ",null,null,null,2,{"$f":"IF(ISBLANK(B12),\"\",VLOOKUP(B12,_list,2,0))","v":450},900]
[{"$f":"IF(ISBLANK(B13),\"\",COUNTA(B$8:$C13)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B13),\"\",VLOOKUP(B13,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B14),\"\",COUNTA(B$8:$C14)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B14),\"\",VLOOKUP(B14,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B15),\"\",COUNTA(B$8:$C15)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B15),\"\",VLOOKUP(B15,_list,2,0))","v":""},{"$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(B16),\"\",VLOOKUP(B16,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B17),\"\",COUNTA(B$8:$C17)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B17),\"\",VLOOKUP(B17,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B18),\"\",COUNTA(B$8:$C18)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B18),\"\",VLOOKUP(B18,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B19),\"\",COUNTA(B$8:$C19)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B19),\"\",VLOOKUP(B19,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B20),\"\",COUNTA(B$8:$C20)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B20),\"\",VLOOKUP(B20,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B21),\"\",COUNTA(B$8:$C21)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B21),\"\",VLOOKUP(B21,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B22),\"\",COUNTA(B$8:$C22)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B22),\"\",VLOOKUP(B22,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B23),\"\",COUNTA(B$8:$C23)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B23),\"\",VLOOKUP(B23,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B24),\"\",COUNTA(B$8:$C24)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B24),\"\",VLOOKUP(B24,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B25),\"\",COUNTA(B$8:$C25)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B25),\"\",VLOOKUP(B25,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B26),\"\",COUNTA(B$8:$C26)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B26),\"\",VLOOKUP(B26,_list,2,0))","v":""},""]
[{"$f":"IF(ISBLANK(B27),\"\",COUNTA(B$8:$C27)-1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B27),\"\",VLOOKUP(B27,_list,2,0))","v":""},""]
["الإجمالي",null,null,null,null,null,null,{"$f":"SUM(H9:H27)","v":8040}]
[{"$f":"[1]!NoToTxt(H28,\"دينار\",\"فلس\")","v":"فقط ثمانية آلاف وأربعون دينار"}]

{"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},"ياغوورت نوعية رفيعة",{"$f":"IF(ISBLANK(C10),\"\",VLOOKUP(C10,_list,2,0))","v":29},3,{"$f":"IF(ISBLANK(C10),\"\",D10*E10)","v":87}]
[null,{"$f":"IF(ISBLANK(C11),\"\",COUNTA($C$8:C11)-1)","v":3},"تليتلي 800 غ",{"$f":"IF(ISBLANK(C11),\"\",VLOOKUP(C11,_list,2,0))","v":100},6,{"$f":"IF(ISBLANK(C11),\"\",D11*E11)","v":600}]
[null,{"$f":"IF(ISBLANK(C12),\"\",COUNTA($C$8:C12)-1)","v":4},"عدس 800غ",{"$f":"IF(ISBLANK(C12),\"\",VLOOKUP(C12,_list,2,0))","v":220},2,{"$f":"IF(ISBLANK(C12),\"\",D12*E12)","v":440}]
[null,{"$f":"IF(ISBLANK(C13),\"\",COUNTA($C$8:C13)-1)","v":""},null,{"$f":"IF(ISBLANK(C13),\"\",VLOOKUP(C13,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C13),\"\",D13*E13)","v":""}]
[null,{"$f":"IF(ISBLANK(C14),\"\",COUNTA($C$8:C14)-1)","v":""},null,{"$f":"IF(ISBLANK(C14),\"\",VLOOKUP(C14,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C14),\"\",D14*E14)","v":""}]
[null,{"$f":"IF(ISBLANK(C15),\"\",COUNTA($C$8:C15)-1)","v":""},null,{"$f":"IF(ISBLANK(C15),\"\",VLOOKUP(C15,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C15),\"\",D15*E15)","v":""}]
[null,{"$f":"IF(ISBLANK(C16),\"\",COUNTA($C$8:C16)-1)","v":""},null,{"$f":"IF(ISBLANK(C16),\"\",VLOOKUP(C16,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C16),\"\",D16*E16)","v":""}]
[null,{"$f":"IF(ISBLANK(C17),\"\",COUNTA($C$8:C17)-1)","v":""},null,{"$f":"IF(ISBLANK(C17),\"\",VLOOKUP(C17,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C17),\"\",D17*E17)","v":""}]
[null,{"$f":"IF(ISBLANK(C18),\"\",COUNTA($C$8:C18)-1)","v":""},null,{"$f":"IF(ISBLANK(C18),\"\",VLOOKUP(C18,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C18),\"\",D18*E18)","v":""}]
[null,{"$f":"IF(ISBLANK(C19),\"\",COUNTA($C$8:C19)-1)","v":""},null,{"$f":"IF(ISBLANK(C19),\"\",VLOOKUP(C19,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C19),\"\",D19*E19)","v":""}]
[null,{"$f":"IF(ISBLANK(C20),\"\",COUNTA($C$8:C20)-1)","v":""},null,{"$f":"IF(ISBLANK(C20),\"\",VLOOKUP(C20,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C20),\"\",D20*E20)","v":""}]
[null,{"$f":"IF(ISBLANK(C21),\"\",COUNTA($C$8:C21)-1)","v":""},null,{"$f":"IF(ISBLANK(C21),\"\",VLOOKUP(C21,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C21),\"\",D21*E21)","v":""}]
[null,{"$f":"IF(ISBLANK(C22),\"\",COUNTA($C$8:C22)-1)","v":""},null,{"$f":"IF(ISBLANK(C22),\"\",VLOOKUP(C22,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C22),\"\",D22*E22)","v":""}]
[null,{"$f":"IF(ISBLANK(C23),\"\",COUNTA($C$8:C23)-1)","v":""},null,{"$f":"IF(ISBLANK(C23),\"\",VLOOKUP(C23,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C23),\"\",D23*E23)","v":""}]
[null,{"$f":"IF(ISBLANK(C24),\"\",COUNTA($C$8:C24)-1)","v":""},null,{"$f":"IF(ISBLANK(C24),\"\",VLOOKUP(C24,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C24),\"\",D24*E24)","v":""}]
[null,{"$f":"IF(ISBLANK(C25),\"\",COUNTA($C$8:C25)-1)","v":""},null,{"$f":"IF(ISBLANK(C25),\"\",VLOOKUP(C25,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C25),\"\",D25*E25)","v":""}]
[null,{"$f":"IF(ISBLANK(C26),\"\",COUNTA($C$8:C26)-1)","v":""},null,{"$f":"IF(ISBLANK(C26),\"\",VLOOKUP(C26,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C26),\"\",D26*E26)","v":""}]
[null,{"$f":"IF(ISBLANK(C27),\"\",COUNTA($C$8:C27)-1)","v":""},null,{"$f":"IF(ISBLANK(C27),\"\",VLOOKUP(C27,_list,2,0))","v":""},null,{"$f":"IF(ISBLANK(C27),\"\",D27*E27)","v":""}]
[null,null,"الإجمالي",null,null,{"$f":"SUM(F9:F27)","v":3167}]
[null,null,{"$f":"[1]!NoToTxt(F28,\"دينار\",\"فلس\")","v":"فقط ثلاثة آلاف ومائة وسبعة وستون دينار"}]

{"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":[]}