{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة1","ورقة2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"ورقة1","index":0,"n_rows":405,"n_cols":7,"rows_kept":405,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"الرقم","التاريخ","المادة","الكمية","ثمن الوحدة","المجموع"]
[1,1,"2019-01-01","D",100,1150,{"$f":"E6*F6","v":115000}]
[2,2,"2019-01-02","E",600,1150,690000]
[3,3,"2019-01-03","F",12,6,72]
[4,4,"2019-01-04","G",14,7,98]
[5,5,"2019-01-05","H",16,8,128]
[6,6,"2019-01-06","I",18,9,162]
[7,7,"2019-01-07","J",20,10,200]
[8,8,"2019-01-08","K",22,11,242]
[9,9,"2019-01-09","L",24,12,288]
[10,10,"2019-01-10","M",26,13,338]
[11,11,"2019-01-11","N",28,14,392]
[12,12,"2019-01-12","O",30,15,450]
[13,13,"2019-01-13","P",32,16,512]
[14,14,"2019-01-14","A",34,17,578]
[15,15,"2019-01-15","B",36,18,648]
[16,16,"2019-01-16","C",38,19,722]
[17,17,"2019-01-17","D",40,20,800]
[18,18,"2019-01-18","E",42,21,882]
[19,19,"2019-01-19","F",44,22,968]
[20,20,"2019-01-20","G",46,23,1058]
[21,21,"2019-01-21","H",48,24,1152]
[22,22,"2019-01-22","I",50,25,1250]
[23,23,"2019-01-23","J",52,26,1352]
[24,24,"2019-01-24","K",54,27,1458]
[25,25,"2019-01-25","L",56,28,1568]
[26,26,"2019-01-26","M",58,29,1682]
[27,27,"2019-01-27","N",2,30,60]
[28,28,"2019-01-28","O",6,31,186]
[29,29,"2019-01-29","P",10,32,320]
[30,30,"2019-01-30","A",14,33,462]
[31,31,"2019-01-31","B",18,34,612]
[32,32,"2019-02-01","C",22,35,770]
[33,33,"2019-02-02","D",26,36,936]
[34,34,"2019-02-03","E",30,37,1110]
[35,35,"2019-02-04","F",34,38,1292]
[36,36,"2019-02-05","G",38,39,1482]
[37,37,"2019-02-06","H",42,40,1680]
[38,38,"2019-02-07","I",46,41,1886]
[39,39,"2019-02-08","J",50,42,2100]
[40,40,"2019-02-09","K",54,43,2322]
[41,41,"2019-02-10","L",58,44,2552]
[42,42,"2019-02-11","M",62,45,2790]
[43,43,"2019-02-12","N",66,46,3036]
[44,44,"2019-02-13","O",70,47,3290]
[45,45,"2019-02-14","P",74,48,3552]
[46,46,"2019-02-15","A",78,49,3822]
[47,47,"2019-02-16","B",82,50,4100]
[48,48,"2019-02-17","C",86,51,4386]
[49,49,"2019-02-18","D",90,52,4680]
[50,50,"2019-02-19","E",94,53,4982]
[51,51,"2019-02-20","F",98,54,5292]
[52,52,"2019-02-21","G",102,55,5610]
[53,53,"2019-02-22","H",106,56,5936]
[54,54,"2019-02-23","I",110,57,6270]
[55,55,"2019-02-24","J",1,58,58]
[56,56,"2019-02-25","K",8,59,472]
[57,57,"2019-02-26","L",15,60,900]
[58,58,"2019-02-27","M",22,61,1342]
[59,59,"2019-02-28","N",29,62,1798]
[60,60,"2019-03-01","O",36,63,2268]
[61,61,"2019-03-02","P",43,64,2752]
[62,62,"2019-03-03","A",50,65,3250]
[63,63,"2019-03-04","B",57,66,{"$f":"E68*F68","v":3762}]
[64,64,"2019-03-05","C",64,67,4288]
[65,65,"2019-03-06","D",71,68,4828]
[66,66,"2019-03-07","E",78,69,5382]
[67,67,"2019-03-08","F",85,70,5950]
[68,68,"2019-03-09","G",92,71,6532]
[69,69,"2019-03-10","H",99,72,7128]
[70,70,"2019-03-11","I",106,73,7738]
[71,71,"2019-03-12","J",113,74,8362]
[72,72,"2019-03-13","K",120,75,9000]
[73,73,"2019-03-14","L",127,76,9652]
[74,74,"2019-03-15","M",134,77,10318]
[75,75,"2019-03-16","N",141,78,10998]
[76,76,"2019-03-17","O",148,79,11692]
[77,77,"2019-03-18","P",155,80,12400]
[78,78,"2019-03-19","A",162,81,13122]
[79,79,"2019-03-20","B",169,82,13858]
[80,80,"2019-03-21","C",176,83,14608]
[81,81,"2019-03-22","D",1,84,84]
[82,82,"2019-03-23","E",2,85,170]
[83,83,"2019-03-24","F",3,86,258]
[84,84,"2019-03-25","G",4,87,348]
[85,85,"2019-03-26","H",5,88,440]
[86,86,"2019-03-27","I",6,89,534]
[87,87,"2019-03-28","J",7,90,630]
[88,88,"2019-03-29","K",8,91,728]
[89,89,"2019-03-30","L",9,92,828]
[90,90,"2019-03-31","M",10,93,930]
[91,91,"2019-04-01","N",11,94,1034]
[92,92,"2019-04-02","O",12,95,1140]
[93,93,"2019-04-03","P",13,96,1248]
[94,94,"2019-04-04","A",14,97,1358]
[95,95,"2019-04-05","B",15,98,1470]
[96,96,"2019-04-06","C",16,99,1584]
[97,97,"2019-04-07","D",17,100,1700]
[98,98,"2019-04-08","E",18,101,1818]
[99,99,"2019-04-09","F",19,102,1938]
[100,100,"2019-04-10","G",20,103,2060]
[101,101,"2019-04-11","H",21,104,2184]
[102,102,"2019-04-12","I",22,105,2310]
[103,103,"2019-04-13","J",23,106,2438]
[104,104,"2019-04-14","K",24,107,2568]
[105,105,"2019-04-15","L",25,108,2700]
[106,106,"2019-04-16","M",26,109,2834]
[107,107,"2019-04-17","N",27,110,2970]
[108,108,"2019-04-18","O",28,111,3108]
[109,109,"2019-04-19","P",29,112,3248]
[110,110,"2019-04-20","A",30,113,3390]
[111,111,"2019-04-21","B",31,114,3534]
[112,112,"2019-04-22","C",32,115,3680]
[113,113,"2019-04-23","D",33,116,3828]
[114,114,"2019-04-24","E",34,117,3978]
[115,115,"2019-04-25","F",35,118,4130]
[116,116,"2019-04-26","G",36,119,4284]
[117,117,"2019-04-27","H",37,120,4440]
[118,118,"2019-04-28","I",2,121,242]
[119,119,"2019-04-29","J",3,122,366]
[120,120,"2019-04-30","K",4,123,492]
[121,121,"2019-05-01","L",5,124,620]
[122,122,"2019-05-02","M",6,125,750]
[123,123,"2019-05-03","N",7,126,882]
[124,124,"2019-05-04","O",8,127,1016]
[125,125,"2019-05-05","P",9,128,1152]
[126,126,"2019-05-06","A",10,129,1290]
[127,127,"2019-05-07","B",11,130,{"$f":"E132*F132","v":1430}]
[128,128,"2019-05-08","C",12,131,1572]
[129,129,"2019-05-09","D",13,132,1716]
[130,130,"2019-05-10","E",14,133,1862]
[131,131,"2019-05-11","F",15,134,2010]
[132,132,"2019-05-12","G",16,135,2160]
[133,133,"2019-05-13","H",17,136,2312]
[134,134,"2019-05-14","I",18,137,2466]
[135,135,"2019-05-15","J",19,138,2622]
[136,136,"2019-05-16","K",20,139,2780]
[137,137,"2019-05-17","L",21,140,2940]
[138,138,"2019-05-18","M",22,141,3102]
[139,139,"2019-05-19","N",23,142,3266]
[140,140,"2019-05-20","O",24,143,3432]
[141,141,"2019-05-21","P",25,144,3600]
[142,142,"2019-05-22","A",26,145,3770]
[143,143,"2019-05-23","B",27,146,3942]
[144,144,"2019-05-24","C",28,147,4116]
[145,145,"2019-05-25","D",29,148,4292]
[146,146,"2019-05-26","E",30,149,4470]
[147,147,"2019-05-27","F",31,150,4650]
[148,148,"2019-05-28","G",32,151,4832]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]

{"sheet":"ورقة2","index":1,"n_rows":407,"n_cols":8,"rows_kept":407,"cut":false,"hidden":false,"merged":[[1,5,1,7]]}
[]
[null,null,null,null,null,"جلب بيانات بين تاريخيين"]
[null,null,"التاريخ الاول","2019-01-01"]
[null,null,"التاريخ الثاني","2019-02-28"]
[]
[null,null,null,null,null,null,null,"المجموع العام"]
[null,"الرقم","التاريخ","المادة","الكمية","ثمن الوحدة","المجموع",{"$f":"SUBTOTAL(9,G:G)","v":902086}]
[1,1,"2019-01-01","D",100,1150,115000]
[2,2,"2019-01-02","E",600,1150,690000]
[3,3,"2019-01-03","F",12,6,72]
[4,4,"2019-01-04","G",14,7,98]
[5,5,"2019-01-05","H",16,8,128]
[6,6,"2019-01-06","I",18,9,162]
[7,7,"2019-01-07","J",20,10,200]
[8,8,"2019-01-08","K",22,11,242]
[9,9,"2019-01-09","L",24,12,288]
[10,10,"2019-01-10","M",26,13,338]
[11,11,"2019-01-11","N",28,14,392]
[12,12,"2019-01-12","O",30,15,450]
[13,13,"2019-01-13","P",32,16,512]
[14,14,"2019-01-14","A",34,17,578]
[15,15,"2019-01-15","B",36,18,648]
[16,16,"2019-01-16","C",38,19,722]
[17,17,"2019-01-17","D",40,20,800]
[18,18,"2019-01-18","E",42,21,882]
[19,19,"2019-01-19","F",44,22,968]
[20,20,"2019-01-20","G",46,23,1058]
[21,21,"2019-01-21","H",48,24,1152]
[22,22,"2019-01-22","I",50,25,1250]
[23,23,"2019-01-23","J",52,26,1352]
[24,24,"2019-01-24","K",54,27,1458]
[25,25,"2019-01-25","L",56,28,1568]
[26,26,"2019-01-26","M",58,29,1682]
[27,27,"2019-01-27","N",2,30,60]
[28,28,"2019-01-28","O",6,31,186]
[29,29,"2019-01-29","P",10,32,320]
[30,30,"2019-01-30","A",14,33,462]
[31,31,"2019-01-31","B",18,34,612]
[32,32,"2019-02-01","C",22,35,770]
[33,33,"2019-02-02","D",26,36,936]
[34,34,"2019-02-03","E",30,37,1110]
[35,35,"2019-02-04","F",34,38,1292]
[36,36,"2019-02-05","G",38,39,1482]
[37,37,"2019-02-06","H",42,40,1680]
[38,38,"2019-02-07","I",46,41,1886]
[39,39,"2019-02-08","J",50,42,2100]
[40,40,"2019-02-09","K",54,43,2322]
[41,41,"2019-02-10","L",58,44,2552]
[42,42,"2019-02-11","M",62,45,2790]
[43,43,"2019-02-12","N",66,46,3036]
[44,44,"2019-02-13","O",70,47,3290]
[45,45,"2019-02-14","P",74,48,3552]
[46,46,"2019-02-15","A",78,49,3822]
[47,47,"2019-02-16","B",82,50,4100]
[48,48,"2019-02-17","C",86,51,4386]
[49,49,"2019-02-18","D",90,52,4680]
[50,50,"2019-02-19","E",94,53,4982]
[51,51,"2019-02-20","F",98,54,5292]
[52,52,"2019-02-21","G",102,55,5610]
[53,53,"2019-02-22","H",106,56,5936]
[54,54,"2019-02-23","I",110,57,6270]
[55,55,"2019-02-24","J",1,58,58]
[56,56,"2019-02-25","K",8,59,472]
[57,57,"2019-02-26","L",15,60,900]
[58,58,"2019-02-27","M",22,61,1342]
[59,59,"2019-02-28","N",29,62,1798]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]