{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["2","البحث","ورقة1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"2","index":0,"n_rows":266,"n_cols":17,"rows_kept":266,"cut":false,"hidden":false,"merged":[]}
["الرقم","التاريخ","المادة","الكمية","سعر الوحدة","المجموع"]
[1,"2022-10-12","يايورت عادي",205,{"$f":"VLOOKUP(C2,$P$3:$Q$33,2,FALSE)","v":20},{"$f":"D2*E2","v":4100}]
[2,"2022-10-12","بيض",60,{"$f":"VLOOKUP(C3,$P$3:$Q$33,2,FALSE)","v":14},{"$f":"D3*E3","v":840},"total",{"$f":"F266","v":579369},null,null,null,null,null,null,null,0]
[3,"2022-10-16","بصل",7,95,665,null,null,null,null,null,null,null,null,80,"بطاطا",80]
[4,"2022-10-16","بطاطا",7,80,560,null,null,null,null,null,null,null,null,95,"بصل",95]
[5,"2022-10-16","جزر",7,80,560,null,null,null,null,null,null,null,null,80,"جزر",80]
[6,"2022-10-16","اجاص",32,340,10880,null,null,null,null,null,null,null,null,120,"طماطم حب",120]
[7,"2022-10-16","تمر",47,440,20680,null,null,null,null,null,null,null,null,120,"سلاطة حشيش",120]
[8,"2022-10-16","ثوم",170,1,170,null,null,null,null,null,null,null,null,350,"زيتون سلاطة",350]
[9,"2022-10-16","بيض",810,14,11340,null,null,null,null,null,null,null,null,14,"بيض",14]
[10,"2022-10-16","طماطم حب",6,120,720,null,null,null,null,null,null,null,null,17,"جبن قطع",17]
[11,"2022-10-16","جومبو",240,12,2880,null,null,null,null,null,null,null,null,450,"تفاح",450]
[12,"2022-10-16","عصير",406,1,406,null,null,null,null,null,null,null,null,440,"تمر",440]
[13,"2022-10-23","طماطم حب",12,120,1440,null,null,null,null,null,null,null,null,340,"موز",340]
[14,"2022-10-23","بطاطا",17,80,1360,null,null,null,null,null,null,null,null,340,"اجاص",340]
[15,"2022-10-23","بصل",14,95,1330,null,null,null,null,null,null,null,null,40,"ماء معدني",40]
[16,"2022-10-23","جزر",15,80,1200,null,null,null,null,null,null,null,null,100,"مرغرين",100]
[17,"2022-10-23","تفاح",52,450,23400,null,null,null,null,null,null,null,null,200,"برتقال طامسة",200]
[18,"2022-10-23","تمر",60,440,26400,null,null,null,null,null,null,null,null,250,"برتقال ماندرين",250]
[19,"2022-10-23","بيض",1440,14,20160,null,null,null,null,null,null,null,null,20,"يايورت عادي",20]
[20,"2022-11-06","طماطم حب",8,120,960,null,null,null,null,null,null,null,null,30,"يايورت مشكل",30]
[21,"2022-11-06","جزر",6,80,480,null,null,null,null,null,null,null,null,20,"عصير",20]
[22,"2022-11-06","بصل",5,95,475,null,null,null,null,null,null,null,null,380,"دجاج",380]
[23,"2022-11-06","تمر",76,440,33440,null,null,null,null,null,null,null,null,100,"طونة",100]
[24,"2022-11-06","تفاح",54,450,24300,null,null,null,null,null,null,null,null,170,"شربة",170]
[25,"2022-11-06","بيض",1440,14,20160,null,null,null,null,null,null,null,null,170,"مقارون",170]
[26,"2022-11-06","بطاطا",10,80,800,null,null,null,null,null,null,null,null,170,"سباقيتي",170]
[27,"2022-11-13","يايورت عادي",350,20,7000,null,null,null,null,null,null,null,null,110,"طماطم مركزة",110]
[28,"2022-11-13","بطاطا",10,80,800,null,null,null,null,null,null,null,null,40,"ملح",40]
[29,"2022-11-13","طماطم حب",8,120,960,null,null,null,null,null,null,null,null,1,"ثوم",1]
[30,"2022-11-13","جزر",6,80,480,null,null,null,null,null,null,null,null,2,"لحم العجل",2]
[31,"2022-11-13","بصل",5,95,475,null,null,null,null,null,null,null,null,3,"لحم الخروف",3]
[32,"2022-11-13","تمر",70,440,30800,null,null,null,null,null,null,null,null,4,"لحم مفروم",4]
[33,"2022-11-13","تفاح",56,450,25200]
[34,"2022-11-13","بيض",1440,14,20160]
[35,"2022-11-13","كؤوس بلاستكية",3000,2,6000]
[36,"2022-11-15","بيض",100,14,1400]
[37,"2022-11-15","جبن قطع",343,17,5831]
[38,"2022-11-15","يايورت عادي",343,20,6860,null,null,null,null,null,null,null,null,12,"جومبو"]
[39,"2022-11-20","طونة",343,80,27440,null,null,null,null,null,null,null,null,2,"كؤوس بلاستكية"]
[40,"2022-11-20","بطاطا",10,80,800]
[41,"2022-11-20","طماطم حب",10,120,1200]
[42,"2022-11-20","بصل",6,95,570]
[43,"2022-11-20","جزر",6,80,480]
[44,"2022-11-20","بيض",1440,14,20160]
[45,"2022-11-20","تفاح",61,450,27450]
[46,"2022-11-20","يايورت عادي",343,20,6860]
[47,"2022-11-20","تمر",60,440,26400]
[48,"2022-11-20","جبن قطع",686,17,11662]
[49,"2022-11-27","تفاح",50,450,22500]
[50,"2022-11-27","طونة",345,80,27600]
[51,"2022-11-27","يايورت عادي",345,1,345]
[52,"2022-11-27","تمر",60,440,26400]
[53,"2022-11-27","بيض",1725,14,24150]
[54,"2022-11-27","طماطم حب",10,120,1200]
[55,"2022-11-27","جزر",6,80,480]
[56,"2022-11-27","بصل",8,95,760]
[57,"2022-11-27","بطاطا",10,80,800]
[58,"2022-11-29","يايورت عادي",343,20,6860]
[59,"2022-11-29","ماء معدني",720,40,28800]
[60,"2022-11-29","كؤوس بلاستكية",600,1.3,780]
[61,null,null,null,0,0]
[62,null,null,null,0,0]
[63,null,null,null,0,0]
[64,null,null,null,0,0]
[65,null,null,null,0,0]
[66,null,null,null,{"$f":"VLOOKUP(C67,$P$3:$Q$33,2,FALSE)","v":0},{"$f":"D67*E67","v":0}]
[67,null,null,null,0,0]
[68,null,null,null,0,0]
[69,null,null,null,0,0]
[70,null,null,null,0,0]
[71,null,null,null,0,0]
[72,null,null,null,0,0]
[73,null,null,null,0,0]
[74,null,null,null,0,0]
[75,null,null,null,0,0]
[76,null,null,null,0,0]
[77,null,null,null,0,0]
[78,null,null,null,0,0]
[79,null,null,null,0,0]
[80,null,null,null,0,0]
[81,null,null,null,0,0]
[82,null,null,null,0,0]
[83,null,null,null,0,0]
[84,null,null,null,0,0]
[85,null,null,null,0,0]
[86,null,null,null,0,0]
[87,null,null,null,0,0]
[88,null,null,null,0,0]
[89,null,null,null,0,0]
[90,null,null,null,0,0]
[91,null,null,null,0,0]
[92,null,null,null,0,0]
[93,null,null,null,0,0]
[94,null,null,null,0,0]
[95,null,null,null,0,0]
[96,null,null,null,0,0]
[97,null,null,null,0,0]
[98,null,null,null,0,0]
[99,null,null,null,0,0]
[100,null,null,null,0,0]
[101,null,null,null,0,0]
[102,null,null,null,0,0]
[103,null,null,null,0,0]
[104,null,null,null,0,0]
[105,null,null,null,0,0]
[106,null,null,null,0,0]
[107,null,null,null,0,0]
[108,null,null,null,0,0]
[109,null,null,null,0,0]
[110,null,null,null,0,0]
[111,null,null,null,0,0]
[112,null,null,null,0,0]
[113,null,null,null,0,0]
[114,null,null,null,0,0]
[115,null,null,null,0,0]
[116,null,null,null,0,0]
[117,null,null,null,0,0]
[118,null,null,null,0,0]
[119,null,null,null,0,0]
[120,null,null,null,0,0]
[121,null,null,null,0,0]
[122,null,null,null,0,0]
[123,null,null,null,0,0]
[124,null,null,null,0,0]
[125,null,null,null,0,0]
[126,null,null,null,0,0]
[127,null,null,null,0,0]
[128,null,null,null,0,0]
[129,null,null,null,0,0]
[130,null,null,null,{"$f":"VLOOKUP(C131,$P$3:$Q$33,2,FALSE)","v":0},{"$f":"D131*E131","v":0}]
[131,null,null,null,0,0]
[132,null,null,null,0,0]
[133,null,null,null,0,0]
[134,null,null,null,0,0]
[135,null,null,null,0,0]
[136,null,null,null,0,0]
[137,null,null,null,0,0]
[138,null,null,null,0,0]
[139,null,null,null,0,0]
[140,null,null,null,0,0]
[141,null,null,null,0,0]
[142,null,null,null,0,0]
[143,null,null,null,0,0]
[144,null,null,null,0,0]
[145,null,null,null,0,0]
[146,null,null,null,0,0]
[147,null,null,null,0,0]
[148,null,null,null,0,0]
[149,null,null,null,0,0]
[150,null,null,null,0,0]
[151,null,null,null,0,0]
[152,null,null,null,0,0]
[153,null,null,null,0,0]
[154,null,null,null,0,0]
[155,null,null,null,0,0]
[156,null,null,null,0,0]
[157,null,null,null,0,0]
[158,null,null,null,0,0]
[159,null,null,null,0,0]
[160,null,null,null,0,0]
[161,null,null,null,0,0]
[162,null,null,null,0,0]
[163,null,null,null,0,0]
[164,null,null,null,0,0]
[165,null,null,null,0,0]
[166,null,null,null,0,0]
[167,null,null,null,0,0]
[168,null,null,null,0,0]
[169,null,null,null,0,0]
[170,null,null,null,0,0]
[171,null,null,null,0,0]
[172,null,null,null,0,0]
[173,null,null,null,0,0]
[174,null,null,null,0,0]
[175,null,null,null,0,0]
[176,null,null,null,0,0]
[177,null,null,null,0,0]
[178,null,null,null,0,0]
[179,null,null,null,0,0]
[180,null,null,null,0,0]
[181,null,null,null,0,0]
[182,null,null,null,0,0]
[183,null,null,null,0,0]
[184,null,null,null,0,0]
[185,null,null,null,0,0]
[186,null,null,null,0,0]
[187,null,null,null,0,0]
[188,null,null,null,0,0]
[189,null,null,null,0,0]
[190,null,null,null,0,0]
[191,null,null,null,0,0]
[192,null,null,null,0,0]
[193,null,null,null,0,0]
[194,null,null,null,{"$f":"VLOOKUP(C195,$P$3:$Q$33,2,FALSE)","v":0},{"$f":"D195*E195","v":0}]
[195,null,null,null,0,0]
[196,null,null,null,0,0]
[197,null,null,null,0,0]
[198,null,null,null,0,0]
[199,null,null,null,0,0]
[200,null,null,null,0,0]
[201,null,null,null,0,0]
[202,null,null,null,0,0]
[203,null,null,null,0,0]
[204,null,null,null,0,0]
[205,null,null,null,0,0]
[206,null,null,null,0,0]
[207,null,null,null,0,0]
[208,null,null,null,0,0]
[209,null,null,null,0,0]
[210,null,null,null,0,0]
[211,null,null,null,0,0]
[212,null,null,null,0,0]
[213,null,null,null,0,0]
[214,null,null,null,0,0]
[215,null,null,null,0,0]
[216,null,null,null,0,0]
[217,null,null,null,0,0]
[218,null,null,null,0,0]
[219,null,null,null,0,0]
[220,null,null,null,0,0]
[221,null,null,null,0,0]
[222,null,null,null,0,0]
[223,null,null,null,0,0]
[224,null,null,null,0,0]
[225,null,null,null,0,0]
[226,null,null,null,0,0]
[227,null,null,null,0,0]
[228,null,null,null,0,0]
[229,null,null,null,0,0]
[230,null,null,null,0,0]
[231,null,null,null,0,0]
[232,null,null,null,0,0]
[233,null,null,null,0,0]
[234,null,null,null,0,0]
[235,null,null,null,0,0]
[236,null,null,null,0,0]
[237,null,null,null,0,0]
[238,null,null,null,0,0]
[239,null,null,null,0,0]
[240,null,null,null,0,0]
[241,null,null,null,0,0]
[242,null,null,null,0,0]
[243,null,null,null,0,0]
[244,null,null,null,0,0]
[245,null,null,null,0,0]
[246,null,null,null,0,0]
[247,null,null,null,0,0]
[248,null,null,null,0,0]
[249,null,null,null,0,0]
[250,null,null,null,0,0]
[251,null,null,null,0,0]
[252,null,null,null,0,0]
[253,null,null,null,0,0]
[254,null,null,null,0,0]
[255,null,null,null,0,0]
[256,null,null,null,0,0]
[257,null,null,null,0,0]
[258,null,null,null,{"$f":"VLOOKUP(C259,$P$3:$Q$33,2,FALSE)","v":0},{"$f":"D259*E259","v":0}]
[259,null,null,null,0,0]
[260,null,null,null,0,0]
[261,null,null,null,0,0]
[262,null,null,null,0,0]
[263,null,null,null,0,0]
[264,null,null,null,0,0]
[null,null,null,null,"المجموع",{"$f":"SUM(F2:F265)","v":579369}]

{"sheet":"البحث","index":1,"n_rows":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":false,"merged":[[30,8,31,9],[32,8,33,9],[41,8,42,9]]}
[]
["من تاريخ","2022-10-06",null,null,null,null,null,null,null,null,null,"التاريخ","التاريخ"]
["الى تاريخ","2022-10-23",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER($B$2),CONCATENATE(\">=\",$B$2),\"\")","v":">=44840"},{"$f":"IF(ISNUMBER($B$3),CONCATENATE(\"<=\",$B$3),IF(ISNUMBER($B$2),CONCATENATE(\"<=\",$B$2),\"\"))","v":"<=44857"}]
[]
["الرقم","التاريخ","المادة","الكمية","سعر الوحدة","المجموع",null,"المجموع العام"]
[1,"2022-10-12","يايورت عادي",205,20,4100]
[2,"2022-10-12","بيض",60,14,840]
[3,"2022-10-16","بصل",7,95,665]
[4,"2022-10-16","بطاطا",7,80,560]
[5,"2022-10-16","جزر",7,80,560]
[6,"2022-10-16","اجاص",32,340,10880]
[7,"2022-10-16","تمر",47,440,20680]
[8,"2022-10-16","ثوم",170,1,170]
[9,"2022-10-16","بيض",810,14,11340]
[10,"2022-10-16","طماطم حب",6,120,720]
[11,"2022-10-16","جومبو",240,12,2880]
[12,"2022-10-16","عصير",406,1,406,null,{"$f":"SUBTOTAL(9,F:F)","v":209706}]
[13,"2022-10-23","طماطم حب",12,120,1440]
[14,"2022-10-23","بطاطا",17,80,1360]
[15,"2022-10-23","بصل",14,95,1330]
[16,"2022-10-23","جزر",15,80,1200]
[17,"2022-10-23","تفاح",52,450,23400]
[18,"2022-10-23","تمر",60,440,26400]
[19,"2022-10-23","بيض",1440,14,20160,{"$f":"SUM(F6:F24)","v":129091}]
[20,"2022-11-06","طماطم حب",8,120,960]
[21,"2022-11-06","جزر",6,80,480]
[22,"2022-11-06","بصل",5,95,475]
[23,"2022-11-06","تمر",76,440,33440]
[24,"2022-11-06","تفاح",54,450,24300]
[25,"2022-11-06","بيض",1440,14,20160]
[26,"2022-11-06","بطاطا",10,80,800,null,null,"المطلو المجموع يكون متحرك حسب تاريخ البحث"]
[null,"2022-11-07",null,null,null,"المجموع",null,{"$f":"SUM(F9:F31)","v":204101}]
[null,"2022-11-08"]
[null,"2022-11-09"]
[null,"2022-11-10"]
[null,"2022-11-11"]
[null,"2022-11-12"]
[null,"2022-11-13"]
[null,"2022-11-14"]
[null,"2022-11-15"]
[null,"2022-11-16"]
[null,"2022-11-17",null,null,null,null,null,null,"مثلا لو كان البحث الى 17/11/2022 يتحول مجموع البحث في العمود :F الى هنا"]
[null,null,null,null,null,"المجموع",null,{"$f":"SUM(F20:F42)","v":153105}]

{"sheet":"ورقة1","index":2,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"بطاطا",80,"اكتوبر 2022"]
[null,null,null,null,null,null,null,null,null,"بصل",95,"نوفمبر 2022",null,null,"بطاطا"]
[null,null,null,null,null,null,null,null,null,"جزر",80,"ديسمبر 2022",null,null,"بصل"]
[null,null,null,null,null,null,null,null,null,"طماطم حب",120,"جانفي 2023",null,null,"جزر"]
[null,null,null,null,null,null,null,null,null,"سلاطة حشيش",120,"فبراير 2023",null,null,"طماطم حب"]
[null,null,null,null,null,null,null,null,null,"زيتون سلاطة",350,"مارس 2023",null,null,"سلاطة حشيش"]
[null,null,null,null,null,null,null,null,null,"بيض",14,"ابريل 2023",null,null,"زيتون سلاطة"]
[null,null,null,null,null,null,null,null,null,"جبن قطع",17,"ماي 2023",null,null,"بيض"]
[null,null,null,null,null,null,null,null,null,"تفاح",450,"جوان 2023",null,null,"جبن قطع"]
[null,null,null,null,null,null,null,null,null,"تمر",440,"سبتمبر 2023",null,null,"تفاح"]
[null,null,null,null,null,null,null,null,null,"موز",340,"اكتوبر 2023",null,null,"تمر"]
[null,null,null,null,null,null,null,null,null,"اجاص",340,"نوفمبر 2023",null,null,"موز"]
[null,null,null,null,null,null,null,null,null,"ماء معدني",40,"ديسمبر 2023",null,null,"اجاص"]
[null,null,null,null,null,null,null,null,null,"مرغرين",100,"جانفي 2024",null,null,"ماء معدني"]
[null,null,null,null,null,null,null,null,null,"برتقال طامسة",200,"فبراير 2024",null,null,"مرغرين"]
[null,null,null,null,null,null,null,null,null,"برتقال ماندرين",250,"مارس 2024",null,null,"برتقال طامسة"]
[null,null,null,null,null,null,null,null,null,"يايورت عادي",20,"أبريل 2024",null,null,"برتقال ماندرين"]
[null,null,null,null,null,null,null,null,null,"يايورت مشكل",30,"ماي 2024",null,null,"يايورت عادي"]
[null,null,null,null,null,null,null,null,null,"عصير",20,"جوان 2024",null,null,"يايورت مشكل"]
[null,null,null,null,null,null,null,null,null,"دجاج",380,null,null,null,"عصير"]
[null,null,null,null,null,null,null,null,null,"طونة",100,null,null,null,"دجاج"]
[null,null,null,null,null,null,null,null,null,"شربة",170,null,null,null,"طونة"]
[null,null,null,null,null,null,null,null,null,"مقارون",170,null,null,null,"شربة"]
[null,null,null,null,null,null,null,null,null,"سباقيتي",170,null,null,null,"مقارون"]
[null,null,null,null,null,null,null,null,null,"طماطم مركزة",110,null,null,null,"سباقيتي"]
[null,null,null,null,null,null,null,null,null,"ملح",40,null,null,null,"طماطم مركزة"]
[null,null,null,null,null,null,null,null,null,"ثوم",1,null,null,null,"ملح"]
[null,null,null,null,null,null,null,null,null,"لحم العجل",2,null,null,null,"ثوم"]
[null,null,null,null,null,null,null,null,null,"لحم الخروف",3,null,null,null,"لحم العجل"]
[null,null,null,null,null,null,null,null,null,"لحم مفروم",4,null,null,null,"لحم الخروف"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"لحم مفروم"]