{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Recieved","Data","SEARCH"],"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":"Recieved","index":0,"n_rows":78,"n_cols":10,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["TITTLE"]
["م","كود الموظف","الاسم","الرقم القومي","تاريخ الإستقالة / الانقطاع","تاريخ استلام المستحقات","النوع","تاريخ الميلاد","رقم الارشيف"]
[1,1039,"اسم1",10,"2018-08-29","2019-02-16",{"$f":"IFERROR(IF(ISODD(MID(D3,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D3,1)*1=3,20,19)&MID(D3,2,2),MID(D3,4,2),MID(D3,6,2)),\" \")","v":" "}]
[2,1066,"اسم2",20,"2019-02-06","2019-02-09"," "," "]
[3,1042,"اسم3",30,"2018-11-04","2019-02-09"," "," "]
[4,1027,"اسم4",40,"2019-01-14","2019-02-04"," "," "]
[5,1014,"اسم5",50,"2018-11-04","2019-01-12"," "," "]
[6,1003,"اسم6",60,"2018-11-05","2019-01-12"," "," "]
[7,1026,"اسم7",70,"2018-11-04","2019-01-12"," "," "]
[8,776,"اسم8",80,"2018-12-11","2019-01-08"," "," "]
[9,1018,"اسم9",90,"2018-10-03","2018-12-22"," "," "]
[10,881,"اسم10",100,"2018-10-02","2018-12-08"," "," "]
[11,935,"اسم11",110,"2018-10-03","2018-12-08"," "," "]
[12,1000,"اسم12",120,"2018-06-04","2018-12-08"," "," "]
[13,918,"اسم13",130,"2018-10-08","2018-12-08"," "," "]
[14,832,"اسم14",140,"2018-10-01","2018-12-08"," "," "]
[15,743,"اسم15",150,"2018-10-02","2018-12-08"," "," "]
[16,995,"اسم16",160,"2018-08-06","2018-11-10"," "," "]
[17,996,"اسم17",170,"2018-08-06","2018-11-10"," "," "]
[18,1017,"اسم18",180,"2018-08-30","2018-11-10"," "," "]
[19,1926,"اسم19",190,"2018-09-02","2018-11-10"," "," "]
[20,745,"اسم20",200,"2017-08-01","2018-11-10"," "," "]
[21,1055,"اسم21",210,"2018-10-10",null," "," ",null,"تم اعادة استخدام الكود لعدم مرور يوم على استعماله."]
[22,1024,"اسم22",220,"2018-11-01","2018-11-01"," "," "]
[23,1081,"اسم23",230,null,"2019-03-16"," "," "]
[24,983,"اسم24",240,"2019-01-08","2019-03-16"," "," "]
[25,1015,"اسم25",250,"2019-01-02","2019-03-16"," "," "]
[26,1020,"اسم26",260,"2018-08-15","2018-10-27"," "," "]
[27,1023,"اسم27",270,"2018-08-05","2018-10-13"," "," "]
[28,1012,"اسم28",280,"2018-07-26","2018-10-13"," "," "]
[29,1022,"اسم29",290,"2018-08-05","2018-10-13"," "," "]
[30,958,"اسم30",300,"2018-08-01","2018-10-13"," "," "]
[31,1013,"اسم31",310,"2018-07-11","2018-09-15"," "," "]
[32,772,"اسم32",320,"2018-03-01","2018-09-15"," "," "]
[33,420,"اسم33",330,"2018-11-01","2019-03-16",{"$f":"IFERROR(IF(ISODD(MID(D35,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D35,1)*1=3,20,19)&MID(D35,2,2),MID(D35,4,2),MID(D35,6,2)),\" \")","v":" "}]
[34,978,"اسم34",340,"2018-05-06",null," "," "]
[35,null,"اسم35",350,"2018-02-18","2018-04-22"," "," "]
[36,null,"اسم36",360,"2018-02-19","2018-04-21"," "," "]
[37,863,"اسم37",370,"2018-04-30",null," "," "]
[38,872,"اسم38",380,"2018-06-23","2018-09-08"," "," "]
[39,924,"اسم39",390,"2018-07-03","2018-09-08"," "," "]
[40,999,"اسم40",400,"2018-04-22","2018-09-08"," "," "]
[41,962,"اسم41",410,"2018-07-04","2018-09-08"," "," "]
[42,128,"اسم42",420,"2018-06-04","2018-08-18"," "," "]
[43,897,"اسم43",430,"2018-06-07","2018-08-18"," "," "]
[44,945,"اسم44",440,"2018-01-14","2018-01-14"," "," "]
[45,null,"اسم45",450,null,null," "," ",null,"لم يتم تعيينه"]
[46,862,"اسم46",460,"2018-02-05","2018-04-14"," "," "]
[47,953,"اسم47",470,"2018-02-15","2018-08-11"," "," "]
[48,940,"اسم48",480,"2018-06-03","2018-08-18"," "," "]
[49,932,"اسم49",490,"2017-11-05","2018-08-11"," "," "]
[50,880,"اسم50",500,"2018-01-04","2018-03-17"," "," "]
[51,789,"اسم51",510,"2017-12-11","2018-02-17"," "," "]
[52,982,"اسم52",520,"2018-03-14","2018-07-14"," "," "]
[53,989,"اسم53",530,"2018-05-02","2018-07-14"," "," "]
[54,990,"اسم54",540,"2018-05-15","2018-07-14"," "," "]
[55,964,"اسم55",550,"2018-03-29","2018-07-14"," "," "]
[56,711,"اسم56",560,"2018-04-16","2018-07-14"," "," "]
[57,740,"اسم57",570,"2017-01-08","2018-01-18"," "," "]
[58,966,"اسم58",580,"2017-12-06","2018-06-23"," "," "]
[59,986,"اسم59",590,"2018-04-02","2018-06-09"," "," "]
[60,988,"اسم60",600,"2018-04-02","2018-06-09"," "," "]
[61,534,"اسم61",610,"2018-04-10","2018-05-12"," "," "]
[62,441,"اسم62",620,"2018-03-11","2018-05-12"," "," "]
[63,913,"اسم63",630,"2018-01-08","2018-04-28",{"$f":"IFERROR(IF(ISODD(MID(D65,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D65,1)*1=3,20,19)&MID(D65,2,2),MID(D65,4,2),MID(D65,6,2)),\" \")","v":" "}]
[64,969,"اسم64",640,"2018-04-10","2018-04-10",{"$f":"IFERROR(IF(ISODD(MID(D66,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D66,1)*1=3,20,19)&MID(D66,2,2),MID(D66,4,2),MID(D66,6,2)),\" \")","v":" "}]
[65,797,"اسم65",650,"2013-03-02","2018-04-21",{"$f":"IFERROR(IF(ISODD(MID(D67,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D67,1)*1=3,20,19)&MID(D67,2,2),MID(D67,4,2),MID(D67,6,2)),\" \")","v":" "}]
[66,899,"اسم66",660,"2018-01-24","2018-04-02",{"$f":"IFERROR(IF(ISODD(MID(D68,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D68,1)*1=3,20,19)&MID(D68,2,2),MID(D68,4,2),MID(D68,6,2)),\" \")","v":" "}]
[67,947,"اسم67",670,"2018-01-16","2018-03-17",{"$f":"IFERROR(IF(ISODD(MID(D69,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D69,1)*1=3,20,19)&MID(D69,2,2),MID(D69,4,2),MID(D69,6,2)),\" \")","v":" "}]
[68,936,"اسم68",680,"2018-01-08","2018-03-17",{"$f":"IFERROR(IF(ISODD(MID(D70,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D70,1)*1=3,20,19)&MID(D70,2,2),MID(D70,4,2),MID(D70,6,2)),\" \")","v":" "}]
[69,878,"اسم69",690,"2017-12-25","2018-03-10"," "," "]
[70,901,"اسم70",700,"2018-01-04","2018-03-10"," "," "]
[71,914,"اسم71",710,"2017-11-06","2018-01-20"," "," "]
[72,902,"اسم72",720,"2017-12-05","2015-02-10"," "," "]
[73,811,"اسم73",730,"2017-10-01","2017-12-09"," "," "]
[74,938,"اسم74",740,"2017-11-26","2017-12-09"," "," "]
[75,741,"اسم75",750,"2017-11-29","2018-01-08"," "," "]
[1,626,"اسم 1",100,"2019-03-10","2019-02-01",{"$f":"IFERROR(IF(ISODD(MID(D78,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D78,1)*1=3,20,19)&MID(D78,2,2),MID(D78,4,2),MID(D78,6,2)),\" \")","v":" "}]

{"sheet":"Data","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
["م","كود الموظف","الاسم","الرقم القومي","تاريخ الإستقالة / الانقطاع","تاريخ استلام المستحقات","النوع","تاريخ الميلاد","رقم الارشيف"]
[2,951,"اسم 2",200,"2019-03-03",null,{"$f":"IFERROR(IF(ISODD(MID(D3,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D3,1)*1=3,20,19)&MID(D3,2,2),MID(D3,4,2),MID(D3,6,2)),\" \")","v":" "}]
[3,509,"اسم 3",300,"2019-01-31",null,{"$f":"IFERROR(IF(ISODD(MID(D4,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D4,1)*1=3,20,19)&MID(D4,2,2),MID(D4,4,2),MID(D4,6,2)),\" \")","v":" "}]
[4,1040,"اسم 4",400,"2019-02-04",null,{"$f":"IFERROR(IF(ISODD(MID(D5,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D5,1)*1=3,20,19)&MID(D5,2,2),MID(D5,4,2),MID(D5,6,2)),\" \")","v":" "}]
[5,1038,"اسم 5",500,"2019-02-04",null," "," "]
[6,943,"اسم 6",600,"2019-02-03",null," "," "]
[7,1010,"اسم 7",700,"2019-01-19",null," "," "]
[8,884,"اسم 8",800,"2019-01-19",null," "," "]
[9,1049,"اسم 9",900,"2019-01-10",null," "," "]
[10,1029,"اسم 10",1000,"2019-01-02",null,{"$f":"IFERROR(IF(ISODD(MID(D11,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D11,1)*1=3,20,19)&MID(D11,2,2),MID(D11,4,2),MID(D11,6,2)),\" \")","v":" "}]
[11,1048,"اسم 11",1100,"2019-02-10",null,{"$f":"IFERROR(IF(ISODD(MID(D12,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D12,1)*1=3,20,19)&MID(D12,2,2),MID(D12,4,2),MID(D12,6,2)),\" \")","v":" "}]
[12,916,"اسم 12",1200,"2019-01-02",null,{"$f":"IFERROR(IF(ISODD(MID(D13,13,1)),\"Male\",\"Female\"),\" \")","v":" "},{"$f":"IFERROR(DATE(IF(LEFT(D13,1)*1=3,20,19)&MID(D13,2,2),MID(D13,4,2),MID(D13,6,2)),\" \")","v":" "}]
[13,1006,"اسم 13",1300,"2018-05-23",null," "," "]
[14,954,"اسم 14",1400,"2018-11-19",null," "," "]
[15,1045,"اسم 15",1500,"2018-10-16",null," "," "]
[16,942,"اسم 16",1600,"2018-02-06",null," "," "]
[17,920,"اسم 17",1700,"2017-10-31",null," "," "]
[18,750,"اسم 18",1800,"2018-01-18",null," "," "]
[19,498,"اسم 19",1900,"2017-11-11",null," "," "]
[20,null,null,null,null,null," "," "]
[21,null,null,null,null,null," "," "]
[22,null,null,null,null,null," "," "]

{"sheet":"SEARCH","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,7],[7,0,7,7]]}
["تسلم المستحقات"]
["كود الموظف","الاسم","الرقم القومي","تاريخ الإستقالة / الانقطاع","تاريخ استلام المستحقات","النوع","تاريخ الميلاد","رقم الارشيف"]
[1066,{"$f":"VLOOKUP($A$3,Table1[[كود الموظف]:[رقم الارشيف]],2,0)","v":"اسم2"},{"$f":"VLOOKUP($A$3,Table1[[كود الموظف]:[رقم الارشيف]],3,0)","v":20},{"$f":"VLOOKUP($A$3,Table1[[كود الموظف]:[رقم الارشيف]],4,0)","v":"2019-02-06"},{"$f":"VLOOKUP($A$3,Table1[[كود الموظف]:[رقم الارشيف]],5,0)","v":"2019-02-09"},{"$f":"VLOOKUP($A$3,Table1[[كود الموظف]:[رقم الارشيف]],6,0)","v":" "},{"$f":"VLOOKUP($A$3,Table1[[كود الموظف]:[رقم الارشيف]],7,0)","v":" "},{"$f":"VLOOKUP($A$3,Table1[[كود الموظف]:[رقم الارشيف]],8,0)","v":0}]
[]
[]
[]
[]
["لم يتسلم المستحقات"]
["كود الموظف","الاسم","الرقم القومي","تاريخ الإستقالة / الانقطاع","تاريخ استلام المستحقات","النوع","تاريخ الميلاد","رقم الارشيف"]
[626,{"$f":"VLOOKUP($A$10,Table2[[كود الموظف]:[رقم الارشيف]],2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A$10,Table2[[كود الموظف]:[رقم الارشيف]],3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A$10,Table2[[كود الموظف]:[رقم الارشيف]],4,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP($A$10,Table2[[كود الموظف]:[رقم الارشيف]],6,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A$10,Table2[[كود الموظف]:[رقم الارشيف]],7,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A$10,Table2[[كود الموظف]:[رقم الارشيف]],8,0)","v":{"$error":"#N/A"}}]