{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Salim"],"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":"Sheet1","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,10,8,12]]}
["العمود الاول\n1",null,null,"العمود الثانى\n2",null,null,"اجمالى الاعمدة",null,"اجمالى الاعمدة"]
[390,null,null,491,null,null,{"$f":"IF(ROWS($G$2:G2)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G2)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G2))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G2)-COUNTA(list1)))))","v":390},null,102]
[102,null,null,285,null,null,{"$f":"IF(ROWS($G$2:G3)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G3)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G3))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G3)-COUNTA(list1)))))","v":102},null,284]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G4)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G4)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G4))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G4)-COUNTA(list1)))))","v":621},null,285]
[621,null,null,503,null,null,{"$f":"IF(ROWS($G$2:G5)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G5)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G5))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G5)-COUNTA(list1)))))","v":509},null,390]
[509,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G6)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G6)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G6))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G6)-COUNTA(list1)))))","v":284},null,409,null,"المطلوب ان يكون بهذا الشكل"]
[284,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G7)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G7)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G7))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G7)-COUNTA(list1)))))","v":910},null,491]
[null,null,null,713,null,null,{"$f":"IF(ROWS($G$2:G8)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G8)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G8))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G8)-COUNTA(list1)))))","v":564},null,503]
[null,null,null,409,null,null,{"$f":"IF(ROWS($G$2:G9)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G9)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G9))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G9)-COUNTA(list1)))))","v":491},null,509]
[910,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G10)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G10)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G10))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G10)-COUNTA(list1)))))","v":285},null,564]
[null,null,null,693,null,null,{"$f":"IF(ROWS($G$2:G11)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G11)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G11))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G11)-COUNTA(list1)))))","v":503},null,621]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G12)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G12)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G12))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G12)-COUNTA(list1)))))","v":713},null,693]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G13)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G13)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G13))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G13)-COUNTA(list1)))))","v":409},null,713]
[564,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G14)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G14)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G14))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G14)-COUNTA(list1)))))","v":693},null,910]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G15)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G15)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G15))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G15)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G16)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G16)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G16))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G16)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G17)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G17)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G17))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G17)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G18)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G18)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G18))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G18)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G19)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G19)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G19))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G19)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G20)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G20)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G20))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G20)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G21)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G21)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G21))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G21)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G22)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G22)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G22))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G22)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G23)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G23)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G23))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G23)-COUNTA(list1)))))","v":""}]

{"sheet":"Salim","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["العمود الاول\n1",null,null,"العمود الثانى\n2",null,null,"اجمالى الاعمدة",null,"اجمالى الاعمدة"]
[390,null,null,"zyx",null,null,{"$f":"IF(ROWS($G$2:G2)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G2)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G2))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G2)-COUNTA(list1)))))","v":390},null,102]
[102,null,null,285,null,null,{"$f":"IF(ROWS($G$2:G3)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G3)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G3))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G3)-COUNTA(list1)))))","v":102},null,284]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G4)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G4)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G4))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G4)-COUNTA(list1)))))","v":"Abc"},null,285]
["Abc",null,null,"AAA",null,null,{"$f":"IF(ROWS($G$2:G5)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G5)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G5))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G5)-COUNTA(list1)))))","v":509},null,390]
[509,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G6)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G6)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G6))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G6)-COUNTA(list1)))))","v":284},null,409]
[284,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G7)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G7)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G7))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G7)-COUNTA(list1)))))","v":910},null,509]
[null,null,null,713,null,null,{"$f":"IF(ROWS($G$2:G8)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G8)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G8))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G8)-COUNTA(list1)))))","v":564},null,564]
[null,null,null,409,null,null,{"$f":"IF(ROWS($G$2:G9)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G9)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G9))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G9)-COUNTA(list1)))))","v":"zyx"},null,693]
[910,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G10)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G10)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G10))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G10)-COUNTA(list1)))))","v":285},null,713]
[null,null,null,693,null,null,{"$f":"IF(ROWS($G$2:G11)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G11)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G11))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G11)-COUNTA(list1)))))","v":"AAA"},null,"AAA"]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G12)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G12)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G12))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G12)-COUNTA(list1)))))","v":713},null,"Abc"]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G13)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G13)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G13))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G13)-COUNTA(list1)))))","v":409},null,"zyx"]
[564,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G14)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G14)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G14))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G14)-COUNTA(list1)))))","v":693}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G15)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G15)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G15))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G15)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G16)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G16)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G16))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G16)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G17)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G17)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G17))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G17)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G18)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G18)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G18))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G18)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G19)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G19)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G19))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G19)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G20)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G20)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G20))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G20)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G21)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G21)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G21))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G21)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G22)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G22)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G22))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G22)-COUNTA(list1)))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ROWS($G$2:G23)>COUNTA(list1)+COUNTA(list2),\"\",IF(ROWS($G$2:G23)<=COUNTA(list1),INDEX(list1,SMALL(IF(list1<>\"\",ROW(list1)-1),ROWS($G$2:G23))),INDEX(list2,SMALL(IF(list2<>\"\",ROW(list2)-1),ROWS($G$2:G23)-COUNTA(list1)))))","v":""}]