{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["التجميع","كودالاصناف"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":145,"n_cols":16,"rows_kept":145,"cut":false,"hidden":false,"merged":[[0,1,1,11],[3,14,4,14],[3,15,4,15],[0,13,0,14],[1,13,1,14],[3,1,4,1],[3,8,3,10],[3,11,4,11],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,7],[3,13,4,13],[3,12,4,12]]}
[null,"المطلوب : ترحيل كلاً من الأعمدة المرقمة  بـ (1 , 2 , 3 , 14 ) إلى صفحة كود الاصناف ابتداء من الصف 3 العمود k  بحيث تترحل كبيانات فقط وليس دوال بحيث يكون العمود الأساس للترحيل العمود 2 بمعنى أخر صف به بيانات في هذا العمود (أكياس قمامه ) ويقابلها القيمة في العمود 14 هي 78500 لاحظ أن العمود عباره عن دالات وعندما جربت أعمل كود نقلها كبيانات اشتغل تمام  ولكن نقل بقية الأصفار اسفل هذه القيمة وهذه هي المشكلة التي قابلتنا !!!!",null,null,null,null,null,null,null,null,null,null,"اليوم :"]
[null,null,null,null,null,null,null,null,null,null,null,null,"التاريخ :"]
[null,1,2,3,null,null,null,null,null,null,null,null,null,null,14]
[null,"م","الأصناف","الوحدة","الرصيد المرحل",null,null,null,null,null,null,"أخرى","رصيد","السعر","القيمة الإجمالية","الملاحظات"]
[]
[null,1,"ديزل","لتر",null,null,null,null,null,null,null,null,100,670,{"$f":"M6*N6","v":67000}]
[null,2,"الدقيق","كيس",null,null,null,null,null,null,null,null,100,22580,2258000]
[null,3,"السكر","كيلو",null,null,null,null,null,null,null,null,100,450,45000]
[null,4,"الزيت","لتر",null,null,null,null,null,null,null,null,100,1050,105000]
[null,5,"خميرة عادي","باكت",null,null,null,null,null,null,null,null,100,1050,105000]
[null,6,"خميرة فرنسي","باكت",null,null,null,null,null,null,null,null,100,1600,160000]
[null,7,"خميره تركي","باكت",null,null,null,null,null,null,null,null,100,0,0]
[null,8,"سمن البنت","تنك",null,null,null,null,null,null,null,null,100,1540,154000]
[null,9,"سمن البنت علب","علبه",null,null,null,null,null,null,null,null,100,0,0]
[null,10,"البيض","طبق",null,null,null,null,null,null,null,null,100,2335,233500]
[null,11,"الحليب","كيلو",null,null,null,null,null,null,null,null,100,1840,184000]
[null,12,"جلجل","كيلو",null,null,null,null,null,null,null,null,100,1840,184000]
[null,13,"جبن","كيلو",null,null,null,null,null,null,null,null,100,0,0]
[null,14,"زبدة علب","علبة",null,null,null,null,null,null,null,null,100,6100,610000]
[null,15,"زبدة عادية","كيلو",null,null,null,null,null,null,null,null,100,0,0]
[null,16,"زبدة اوكيه","كيلو",null,null,null,null,null,null,null,null,100,1450,145000]
[null,17,"زبدة رهام","كيلو",null,null,null,null,null,null,null,null,100,1150,115000]
[null,18,"باكنج بودر صيني","كيلو",null,null,null,null,null,null,null,null,100,1250,125000]
[null,19,"باكنج بودر عادي","كيلو",null,null,null,null,null,null,null,null,100,0,0]
[null,20,"لوز","كيلو",null,null,null,null,null,null,null,null,100,1320,132000]
[null,21,"فانيليا","علبة",null,null,null,null,null,null,null,null,100,360,36000]
[null,22,"زبيب","كيلو",null,null,null,null,null,null,null,null,100,2700,270000]
[null,23,"كاكاو","كيلو",null,null,null,null,null,null,null,null,100,1240,124000]
[null,24,"محسن كيك","كيلو",null,null,null,null,null,null,null,null,100,2000,200000]
[null,25,"فرمسة","كيلو",null,null,null,null,null,null,null,null,100,2200,220000]
[null,26,"زينة ترت منوع","كيلو",null,null,null,null,null,null,null,null,100,0,0]
[null,27,"جوز الهند","كيلو",null,null,null,null,null,null,null,null,100,2335,233500]
[null,28,"سميد","كيلو",null,null,null,null,null,null,null,null,100,900,90000]
[null,29,"كريمة شانتيه","كيلو",null,null,null,null,null,null,null,null,100,2500,250000]
[null,30,"تمر","كيلو",null,null,null,null,null,null,null,null,100,500,50000]
[null,31,"تانج","علبه",null,null,null,null,null,null,null,null,100,0,0]
[null,32,"مربى جام","علبه",null,null,null,null,null,null,null,null,100,0,0]
[null,33,"صبغات","علبه",null,null,null,null,null,null,null,null,100,6500,650000]
[null,34,"جيلي مزاز","علبه",null,null,null,null,null,null,null,null,100,800,80000]
[null,35,"نكهة","علبة",null,null,null,null,null,null,null,null,100,7500,750000]
[null,36,"دريم ويب(كريمة)","كيلو",null,null,null,null,null,null,null,null,100,0,0]
[null,37,"شوكلاته","كيلو",null,null,null,null,null,null,null,null,100,3500,350000]
[null,38,"نشاء","كيلو",null,null,null,null,null,null,null,null,100,580,58000]
[null,39,"شمر","كيلو",null,null,null,null,null,null,null,null,100,0,0]
[null,40,"زيت عباد الشمس","لتر",null,null,null,null,null,null,null,null,100,0,0]
[null,41,"أمونيا","كيلو",null,null,null,null,null,null,null,null,100,480,48000]
[null,42,"ورق سكر","كيلو",null,null,null,null,null,null,null,null,100,3500,350000]
[null,43,"قواعد ترات ورقية","حبة",null,null,null,null,null,null,null,null,100,0,0]
[null,44,"أكياس لاصق","كيلو",null,null,null,null,null,null,null,null,100,3000,300000]
[null,45,"أقلاص ورقية","باكت",null,null,null,null,null,null,null,null,100,3000,300000]
[null,46,"ورق كيك","كيلو ",null,null,null,null,null,null,null,null,100,1150,115000]
[null,47,"غلافة ","لفة",null,null,null,null,null,null,null,null,100,8000,800000]
[null,48,"لفافة ","كيلو",null,null,null,null,null,null,null,null,100,515,51500]
[null,49,"وسائل ترت","لفة",null,null,null,null,null,null,null,null,100,0,0]
[null,50,"علاقي رقم12","شدة",null,null,null,null,null,null,null,null,100,415,41500]
[null,51,"علاقي رقم10","شدة",null,null,null,null,null,null,null,null,100,355,35500]
[null,52,"علاقي صغير","شدة",null,null,null,null,null,null,null,null,100,310,31000]
[null,53,"علاقي دعاية","شدة",null,null,null,null,null,null,null,null,100,0,0]
[null,54,"صحون سفري صغير","سله",null,null,null,null,null,null,null,null,100,5200,520000]
[null,55,"صحون سفري وسط","سلة",null,null,null,null,null,null,null,null,100,5800,580000]
[null,56,"صحون سفري كبير","سله",null,null,null,null,null,null,null,null,100,7800,780000]
[null,57,"حليب بقري كبير","قرطاس",null,null,null,null,null,null,null,null,100,0,0]
[null,58,"حليب بقري صغير","قرطاس",null,null,null,null,null,null,null,null,100,0,0]
[null,59,"حليب رصابه","قرطاس",null,null,null,null,null,null,null,null,100,0,0]
[null,60,"اسفنج","حبه",null,null,null,null,null,null,null,null,100,40,4000]
[null,61,"ملمع زجاج ","عبوه",null,null,null,null,null,null,null,null,100,900,90000]
[null,62,"فلاش","عبوه",null,null,null,null,null,null,null,null,100,875,87500]
[null,63,"صابون ","كيلو",null,null,null,null,null,null,null,null,100,0,0]
[null,64,"ململ تنظيف","طاقة",null,null,null,null,null,null,null,null,100,7000,700000]
[null,65,"خيوط القش","حبه",null,null,null,null,null,null,null,null,100,300,30000]
[null,66,"قصدير","لفه",null,null,null,null,null,null,null,null,100,6000,600000]
[null,67,"بترول","لتر",null,null,null,null,null,null,null,null,100,0,0]
[null,68,"دفاتر","حبه",null,null,null,null,null,null,null,null,100,125,12500]
[null,69,"اقلام","حبه",null,null,null,null,null,null,null,null,100,86,8600]
[null,70,"ربالات","شدة ",null,null,null,null,null,null,null,null,100,300,30000]
[null,71,"بطاريات","حبة",null,null,null,null,null,null,null,null,100,0,0]
[null,72,"ليف حديد","حبة",null,null,null,null,null,null,null,null,100,30,3000]
[null,73,"دفتر فواتير","حبة",null,null,null,null,null,null,null,null,100,350,35000]
[null,74,"لصقة","حبة",null,null,null,null,null,null,null,null,100,215,21500]
[null,75,"ملح","قطمة",null,null,null,null,null,null,null,null,100,5000,500000]
[null,76,"أكياس سفره","لفة",null,null,null,null,null,null,null,null,100,185,18500]
[null,77,"أكياس قمامة","شده",null,null,null,null,null,null,null,null,100,875,87500]
[null,{"$f":"IF(C82<>\"\",B82+1,\"\")","v":78},{"$f":"IFERROR(IF(B83<>\"\",(VLOOKUP(B83,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},{"$f":"IF(C83<>\"\",(VLOOKUP(B83,كودالاصناف!$A$4:$D$153,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B84<>\"\",(VLOOKUP(B84,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},{"$f":"IF(C84<>\"\",(VLOOKUP(B84,كودالاصناف!$A$4:$D$153,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B85<>\"\",(VLOOKUP(B85,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},{"$f":"IF(C85<>\"\",(VLOOKUP(B85,كودالاصناف!$A$4:$D$153,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B86<>\"\",(VLOOKUP(B86,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},{"$f":"IF(C86<>\"\",(VLOOKUP(B86,كودالاصناف!$A$4:$D$153,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B87<>\"\",(VLOOKUP(B87,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(B87<>\"\",(VLOOKUP(B87,كودالاصناف!$A$4:$D$153,4,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B88<>\"\",(VLOOKUP(B88,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(B88<>\"\",(VLOOKUP(B88,كودالاصناف!$A$4:$D$153,4,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B89<>\"\",(VLOOKUP(B89,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(B89<>\"\",(VLOOKUP(B89,كودالاصناف!$A$4:$D$153,4,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B90<>\"\",(VLOOKUP(B90,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(B90<>\"\",(VLOOKUP(B90,كودالاصناف!$A$4:$D$153,4,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B91<>\"\",(VLOOKUP(B91,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(B91<>\"\",(VLOOKUP(B91,كودالاصناف!$A$4:$D$153,4,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B92<>\"\",(VLOOKUP(B92,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B93<>\"\",(VLOOKUP(B93,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B94<>\"\",(VLOOKUP(B94,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B95<>\"\",(VLOOKUP(B95,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B96<>\"\",(VLOOKUP(B96,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B97<>\"\",(VLOOKUP(B97,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B98<>\"\",(VLOOKUP(B98,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B99<>\"\",(VLOOKUP(B99,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B100<>\"\",(VLOOKUP(B100,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B101<>\"\",(VLOOKUP(B101,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B102<>\"\",(VLOOKUP(B102,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B103<>\"\",(VLOOKUP(B103,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B104<>\"\",(VLOOKUP(B104,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B105<>\"\",(VLOOKUP(B105,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B106<>\"\",(VLOOKUP(B106,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B107<>\"\",(VLOOKUP(B107,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B108<>\"\",(VLOOKUP(B108,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B109<>\"\",(VLOOKUP(B109,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B110<>\"\",(VLOOKUP(B110,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B111<>\"\",(VLOOKUP(B111,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B112<>\"\",(VLOOKUP(B112,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B113<>\"\",(VLOOKUP(B113,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B114<>\"\",(VLOOKUP(B114,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B115<>\"\",(VLOOKUP(B115,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B116<>\"\",(VLOOKUP(B116,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B117<>\"\",(VLOOKUP(B117,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B118<>\"\",(VLOOKUP(B118,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B119<>\"\",(VLOOKUP(B119,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B120<>\"\",(VLOOKUP(B120,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B121<>\"\",(VLOOKUP(B121,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B122<>\"\",(VLOOKUP(B122,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B123<>\"\",(VLOOKUP(B123,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B124<>\"\",(VLOOKUP(B124,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B125<>\"\",(VLOOKUP(B125,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B126<>\"\",(VLOOKUP(B126,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B127<>\"\",(VLOOKUP(B127,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B128<>\"\",(VLOOKUP(B128,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B129<>\"\",(VLOOKUP(B129,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B130<>\"\",(VLOOKUP(B130,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B131<>\"\",(VLOOKUP(B131,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B132<>\"\",(VLOOKUP(B132,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B133<>\"\",(VLOOKUP(B133,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B134<>\"\",(VLOOKUP(B134,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B135<>\"\",(VLOOKUP(B135,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B136<>\"\",(VLOOKUP(B136,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B137<>\"\",(VLOOKUP(B137,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B138<>\"\",(VLOOKUP(B138,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B139<>\"\",(VLOOKUP(B139,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B140<>\"\",(VLOOKUP(B140,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B141<>\"\",(VLOOKUP(B141,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B142<>\"\",(VLOOKUP(B142,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B143<>\"\",(VLOOKUP(B143,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B144<>\"\",(VLOOKUP(B144,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]
[null,"",{"$f":"IFERROR(IF(B145<>\"\",(VLOOKUP(B145,كودالاصناف!$A$4:$C$153,3,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,0]

{"sheet":"كودالاصناف","index":1,"n_rows":153,"n_cols":18,"rows_kept":153,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,5,2,5],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4]]}
[null,"بيانات جميع الاصناف ",null,null,null,null,null,null,null,null,"الأرصدة المرحلة من البرنامج القديم  ",null,null,null,null,null,"مخزني","عادي"]
[null,"م","الأصناف","الوحدة","نوع الصنف \nمخزني / عادي","الرصيد الافتتاحي",null,null,null,null,"م","الأصناف","الوحدة","الرصيد المرحل للسنة الجديدة"]
[null,null,null,null,null,null,null,null,"إلى هنا يكون الترحيل ",null,1,"ديزل","لتر",67000]
[{"$f":"IF(E4=\"مخزني\",COUNTIF($E$4:E4,\"مخزني\"),\"\")","v":1},{"$f":"IF(C4<>\"\",COUNTA($C$4:C4),\"\")","v":1},"ديزل","لتر","مخزني",100,null,null,null,null,2,"الدقيق","كيس",2258000]
[2,2,"الدقيق","كيس","مخزني",100,null,null,null,null,3,"السكر","كيلو",45000]
[3,3,"السكر","كيلو","مخزني",100,null,null,null,null,4,"الزيت","لتر",105000]
[4,4,"الزيت","لتر","مخزني",100,null,null,null,null,5,"خميرة عادي","باكت",105000]
[5,5,"خميرة عادي","باكت","مخزني",100,null,null,null,null,6,"خميرة فرنسي","باكت",160000]
[6,6,"خميرة فرنسي","باكت","مخزني",100,null,null,null,null,7,"خميره تركي","باكت",0]
[7,7,"خميره تركي","باكت","مخزني",100,null,null,null,null,8,"سمن البنت","تنك",154000]
[8,8,"سمن البنت","تنك","مخزني",100,null,null,null,null,9,"سمن البنت علب","علبه",0]
[9,9,"سمن البنت علب","علبه","مخزني",100,null,null,null,null,10,"البيض","طبق",233500]
[10,10,"البيض","طبق","مخزني",100,null,null,null,null,11,"الحليب","كيلو",184000]
[11,11,"الحليب","كيلو","مخزني",100,null,null,null,null,12,"جلجل","كيلو",184000]
[12,12,"جلجل","كيلو","مخزني",100,null,null,null,null,13,"جبن","كيلو",0]
[13,13,"جبن","كيلو","مخزني",100,null,null,null,null,14,"زبدة علب","علبة",610000]
[14,14,"زبدة علب","علبة","مخزني",100,null,null,null,null,15,"زبدة عادية","كيلو",0]
[15,15,"زبدة عادية","كيلو","مخزني",100,null,null,null,null,16,"زبدة اوكيه","كيلو",145000]
[16,16,"زبدة اوكيه","كيلو","مخزني",100,null,null,null,null,17,"زبدة رهام","كيلو",115000]
[17,17,"زبدة رهام","كيلو","مخزني",100,null,null,null,null,18,"باكنج بودر صيني","كيلو",125000]
[18,18,"باكنج بودر صيني","كيلو","مخزني",100,null,null,null,null,19,"باكنج بودر عادي","كيلو",0]
[19,19,"باكنج بودر عادي","كيلو","مخزني",100,null,null,null,null,20,"لوز","كيلو",132000]
[20,20,"لوز","كيلو","مخزني",100,null,null,null,null,21,"فانيليا","علبة",36000]
[21,21,"فانيليا","علبة","مخزني",100,null,null,null,null,22,"زبيب","كيلو",270000]
[22,22,"زبيب","كيلو","مخزني",100,null,null,null,null,23,"كاكاو","كيلو",124000]
[23,23,"كاكاو","كيلو","مخزني",100,null,null,null,null,24,"محسن كيك","كيلو",200000]
[24,24,"محسن كيك","كيلو","مخزني",100,null,null,null,null,25,"فرمسة","كيلو",220000]
[25,25,"فرمسة","كيلو","مخزني",100,null,null,null,null,26,"زينة ترت منوع","كيلو",0]
[26,26,"زينة ترت منوع","كيلو","مخزني",100,null,null,null,null,27,"جوز الهند","كيلو",233500]
[27,27,"جوز الهند","كيلو","مخزني",100,null,null,null,null,28,"سميد","كيلو",90000]
[28,28,"سميد","كيلو","مخزني",100,null,null,null,null,29,"كريمة شانتيه","كيلو",250000]
[29,29,"كريمة شانتيه","كيلو","مخزني",100,null,null,null,null,30,"تمر","كيلو",50000]
[30,30,"تمر","كيلو","مخزني",100,null,null,null,null,31,"تانج","علبه",0]
[31,31,"تانج","علبه","مخزني",100,null,null,null,null,32,"مربى جام","علبه",0]
[32,32,"مربى جام","علبه","مخزني",100,null,null,null,null,33,"صبغات","علبه",650000]
[33,33,"صبغات","علبه","مخزني",100,null,null,null,null,34,"جيلي مزاز","علبه",80000]
[34,34,"جيلي مزاز","علبه","مخزني",100,null,null,null,null,35,"نكهة","علبة",750000]
[35,35,"نكهة","علبة","مخزني",100,null,null,null,null,36,"دريم ويب(كريمة)","كيلو",0]
[36,36,"دريم ويب(كريمة)","كيلو","مخزني",100,null,null,null,null,37,"شوكلاته","كيلو",350000]
[37,37,"شوكلاته","كيلو","مخزني",100,null,null,null,null,38,"نشاء","كيلو",58000]
[38,38,"نشاء","كيلو","مخزني",100,null,null,null,null,39,"شمر","كيلو",0]
[39,39,"شمر","كيلو","مخزني",100,null,null,null,null,40,"زيت عباد الشمس","لتر",0]
[40,40,"زيت عباد الشمس","لتر","مخزني",100,null,null,null,null,41,"أمونيا","كيلو",48000]
[41,41,"أمونيا","كيلو","مخزني",100,null,null,null,null,42,"ورق سكر","كيلو",350000]
[42,42,"ورق سكر","كيلو","مخزني",100,null,null,null,null,43,"قواعد ترات ورقية","حبة",0]
[43,43,"قواعد ترات ورقية","حبة","مخزني",100,null,null,null,null,44,"أكياس لاصق","كيلو",300000]
[44,44,"أكياس لاصق","كيلو","مخزني",100,null,null,null,null,45,"أقلاص ورقية","باكت",300000]
[45,45,"أقلاص ورقية","باكت","مخزني",100,null,null,null,null,46,"ورق كيك","كيلو ",115000]
[46,46,"ورق كيك","كيلو ","مخزني",100,null,null,null,null,47,"غلافة ","لفة",800000]
[47,47,"غلافة ","لفة","مخزني",100,null,null,null,null,48,"لفافة ","كيلو",51500]
[48,48,"لفافة ","كيلو","مخزني",100,null,null,null,null,49,"وسائل ترت","لفة",0]
[49,49,"وسائل ترت","لفة","مخزني",100,null,null,null,null,50,"علاقي رقم12","شدة",41500]
[50,50,"علاقي رقم12","شدة","مخزني",100,null,null,null,null,51,"علاقي رقم10","شدة",35500]
[51,51,"علاقي رقم10","شدة","مخزني",100,null,null,null,null,52,"علاقي صغير","شدة",31000]
[52,52,"علاقي صغير","شدة","مخزني",100,null,null,null,null,53,"علاقي دعاية","شدة",0]
[53,53,"علاقي دعاية","شدة","مخزني",100,null,null,null,null,54,"صحون سفري صغير","سله",520000]
[54,54,"صحون سفري صغير","سله","مخزني",100,null,null,null,null,55,"صحون سفري وسط","سلة",580000]
[55,55,"صحون سفري وسط","سلة","مخزني",100,null,null,null,null,56,"صحون سفري كبير","سله",780000]
[56,56,"صحون سفري كبير","سله","مخزني",100,null,null,null,null,57,"حليب بقري كبير","قرطاس",0]
[57,57,"حليب بقري كبير","قرطاس","مخزني",100,null,null,null,null,58,"حليب بقري صغير","قرطاس",0]
[58,58,"حليب بقري صغير","قرطاس","مخزني",100,null,null,null,null,59,"حليب رصابه","قرطاس",0]
[59,59,"حليب رصابه","قرطاس","مخزني",100,null,null,null,null,60,"اسفنج","حبه",4000]
[60,60,"اسفنج","حبه","مخزني",100,null,null,null,null,61,"ملمع زجاج ","عبوه",90000]
[61,61,"ملمع زجاج ","عبوه","مخزني",100,null,null,null,null,62,"فلاش","عبوه",87500]
[62,62,"فلاش","عبوه","مخزني",100,null,null,null,null,63,"صابون ","كيلو",0]
[63,63,"صابون ","كيلو","مخزني",100,null,null,null,null,64,"ململ تنظيف","طاقة",700000]
[64,64,"ململ تنظيف","طاقة","مخزني",100,null,null,null,null,65,"خيوط القش","حبه",30000]
[65,65,"خيوط القش","حبه","مخزني",100,null,null,null,null,66,"قصدير","لفه",600000]
[66,66,"قصدير","لفه","مخزني",100,null,null,null,null,67,"بترول","لتر",0]
[67,67,"بترول","لتر","مخزني",100,null,null,null,null,68,"دفاتر","حبه",12500]
[68,68,"دفاتر","حبه","مخزني",100,null,null,null,null,69,"اقلام","حبه",8600]
[69,69,"اقلام","حبه","مخزني",100,null,null,null,null,70,"ربالات","شدة ",30000]
[70,70,"ربالات","شدة ","مخزني",100,null,null,null,null,71,"بطاريات","حبة",0]
[71,71,"بطاريات","حبة","مخزني",100,null,null,null,null,72,"ليف حديد","حبة",3000]
[72,72,"ليف حديد","حبة","مخزني",100,null,null,null,null,73,"دفتر فواتير","حبة",35000]
[73,73,"دفتر فواتير","حبة","مخزني",100,null,null,null,null,74,"لصقة","حبة",21500]
[74,74,"لصقة","حبة","مخزني",100,null,null,null,null,75,"ملح","قطمة",500000]
[75,75,"ملح","قطمة","مخزني",100,null,null,null,null,76,"أكياس سفره","لفة",18500]
[76,76,"أكياس سفره","لفة","مخزني",100,null,null,null,null,77,"أكياس قمامة","شده",87500]
[77,77,"أكياس قمامة","شده","مخزني",100]
["",78,"ثلج",null,"عادي"]
["",""]
["",""]
["","",null,null,null,{"$f":"IF(E84=\"مخزني\",COUNTIF($E$4:E84,\"مخزني\"),\"\")","v":""}]
["","",null,null,null,""]
["","",null,null,null,{"$f":"IF(E86=\"مخزني\",COUNTA($E$4:E86),\"\")","v":""}]
["","",null,null,null,""]
["","",null,null,null,""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]