{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DATA","Vacation Letter ","Vacation_Registor","Vacation Report"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":3,"defined_names":9,"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":"DATA","index":0,"n_rows":6,"n_cols":39,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["key ","Position code ","Name  ","Name Ar","Nationality "," Nationality  Ar","Statues","Statues Ar","Gender","Gender Ar","Department","Departmant Ar","Position","Position Ar","Location","Location Ar","Baisc","HRA","Trans","Mobile Allw.","Other Allw.","Ticket","Other Benefits","Mobile .No","Education","Years of Experience ","Bearth Date ","Age ","Email","Offer Date ","Joining Date ","Badge ","Direct Manager","Direct Manager Ar","ID Number ","GOSI"]
[{"$f":"TEXT(ROW(A1),\"R\\_0000\")","v":"R_0001"},1,"omar1","عمر1","saudi","سعودي ","single ","اعزب ",null,null,null,"مالية",null,"مدقق حسابات ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-01-01"]
[{"$f":"TEXT(ROW(A2),\"R\\_0000\")","v":"R_0002"},2,"omar2","عمر2","yamane","يمني ","married","متزوج ",null,null,null,"محاسبة ",null,"محاسب ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-09-08"]
["R_0003",3,"omar3","عمر3","saudi","سعودي ","single ","اعزب ",null,null,null,"مالية",null,"مدقق حسابات ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-01"]
["R_0004",4,"omar4","عمر4","yamane","يمني ","married","متزوج ",null,null,null,"محاسبة "," ","محاسب ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-04-07"]
[{"$f":"TEXT(ROW(A5),\"R\\_0000\")","v":"R_0005"},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]

{"sheet":"Vacation Letter ","index":1,"n_rows":47,"n_cols":32,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,5,4,17],[3,31,5,35],[3,36,5,39],[6,1,6,3],[6,4,6,7],[6,16,6,20],[1,18,2,22],[3,18,4,22],[7,16,7,20],[9,2,12,21],[14,1,14,22],[16,3,16,5],[16,6,16,11],[16,12,16,17],[16,18,16,20],[18,3,18,6],[18,7,18,8],[18,12,18,17],[18,18,18,20],[20,3,20,6],[20,7,20,8],[20,12,20,17],[20,18,20,20],[22,1,22,22],[24,3,25,6],[24,7,24,10],[24,12,25,15],[24,16,25,17],[24,18,25,20],[25,7,25,10],[31,1,31,22],[26,3,27,6],[26,7,26,10],[26,12,27,15],[26,16,27,17],[26,18,27,20],[27,7,27,10],[28,3,29,6],[28,7,28,10],[28,12,29,17],[28,18,29,20],[29,7,29,10],[33,4,33,11],[33,12,33,19],[34,4,36,11],[34,12,36,19],[37,4,38,6],[37,7,38,16],[37,17,38,19],[39,4,40,6],[39,7,40,16],[39,17,40,19],[42,1,42,22],[44,2,45,7],[44,8,45,14],[44,15,45,21],[46,2,46,7],[46,8,46,14],[46,15,46,21],[47,2,51,7],[47,8,51,14],[47,15,51,21]]}
[]
[null,null,null,null,null,"نموذج طلب اجازة ",null,null,null,null,null,null,null,null,null,null,null,null,"طلب رقم"]
[]
[null,null,null,null,null,null,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,"candidate key"]
[]
[]
[null,"Position cod :",null,null,{"$f":"IFERROR(VLOOKUP(AK4,[2]!Table1[#Data],2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,"Date :",null,{"$f":"TODAY()","v":"2021-02-22"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time :",null,{"$f":"NOW()","v":44249.519560300927}]
[]
[null,null,"يرجى تقديم هذا الطلب الى إدارة الموارد البشرية بفترة لاتقل عن 30 يوماً قبل بدء الإجازة"]
[]
[]
[]
[]
[null,"معلومات مقدم الطلب "]
[]
[null,null,null,"Full Name :",null,null,{"$f":"IFERROR(VLOOKUP(AK4,الجدول3[],3,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AK4,الجدول3[],4,0),\"\")","v":""},null,null,null,null,null,"الاسم الكامل :"]
[]
[null,null,null,{"$f":"IFERROR(VLOOKUP(AK4,الجدول3[],14,0),\"\")","v":""},null,null,null,"الوظيفة :",null,null,null,null,{"$f":"IFERROR(VLOOKUP(AK4,الجدول3[],12,0),\"\")","v":""},null,null,null,null,null,"القسم :"]
[]
[null,null,null,{"$f":"IFERROR(VLOOKUP(AK4,الجدول3[],6,0),\"\")","v":""},null,null,null,"الجنسية : ",null,null,null,null,{"$f":"IFERROR(VLOOKUP(AK4,الجدول3[],31,0),\"\")","v":""},null,null,null,null,null,"تاريخ الالتحاق  : "]
[]
[null,"معلومات الاجازة "]
[]
[null,null,null,null,null,null,null,"تاريخ بدء الاجازة ",null,null,null,null,"Type of Request ",null,null,null,"الايام",null,"نوع الطلب "]
[null,null,null,null,null,null,null,"Vacation Start Day"]
[null,null,null,null,null,null,null,"تاريخ انتهاء الاجازة",null,null,null,null,{"$f":"VLOOKUP(S27,[2]!TypeOfVacation[#Data],2,0)","v":{"$error":"#REF!"}},null,null,null,{"$f":"D27-D25+1","v":1},null,"بدون راتب"]
[null,null,null,null,null,null,null,"Vacation End Day "]
[null,null,null,null,null,null,null,"تاريخ مباشرة العمل ",null,null,null,null,null,null,null,null,null,null,"مدة التأشيرة "]
[null,null,null,null,null,null,null,"Resumption Day "]
[]
[null,"معلومات الموظف البديل "]
[]
[null,null,null,null,"Employee In Charge ",null,null,null,null,null,null,null,"الموظف البديل اثناء الاجازة ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,"I, the undersigned agree to undertake the jop function of this from applicant beside my jop during his vacation",null,null,null,null,null,null,null,"اوافق انا الموقع ادناه بمهام مقدم هذا الطلب اثناء اجازته مع عدم الاخلال بمهام وظيفتي "]
[]
[]
[null,null,null,null,"Name",null,null,"ابو سعيد مقصد",null,null,null,null,null,null,null,null,null,"الاسم "]
[]
[null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,"التوقيع"]
[]
[]
[null,"التوقيع والتعميد "]
[]
[null,null,"موافقة مدير الشركة/ الادارة",null,null,null,null,null,"توقيع المدير المباشر ",null,null,null,null,null,null,"توقيع الموظف"]
[]
[null,null,"Co. \\ Div .Mgr.Authorization ",null,null,null,null,null,"Direct Manager's Signature",null,null,null,null,null,null,"Employee's Signature"]

{"sheet":"Vacation_Registor","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["سجل الاجازات"]
["الاسم","تاريخ بداية الاجازة","تاريخ نهاية الاجازة","مدة الاجازة","نوع الاجازة","ملاحظات","رقم الاجازة"]
["omar1","1900-01-01","1900-01-02","2","بدون راتب",null,1]
["omar2","2021-01-01","2021-02-20","51","بدون راتب",null,2]
["omar3","1900-01-01",1,2,"بدون راتب",null,3,"بدل إجازة"]
["omar2","2021-01-01","2021-02-20","51","مرضياً",null,4,"مرضياً"]
[null,null,null,null,null,null,null,"زواج"]
[null,null,null,null,null,null,null,"مولود"]
[null,null,null,null,null,null,null,"وفاء"]
[null,null,null,null,null,null,null,"أعياد"]
[null,null,null,null,null,null,null,"حج"]

{"sheet":"Vacation Report","index":3,"n_rows":64,"n_cols":16,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,2,1,4],[2,2,2,4],[65,0,66,2],[65,3,66,3],[65,4,66,4]]}
[]
[null,"اسم الموظف"]
[null,"نوع الاجازة","بدون راتب"]
["م","تاريخ بداية الاجازة","تاريخ نهاية الاجازة ","مدة الاجازة","نوع الاجازة",null,null,null,null,null,null,null,null,null,"omar2","بدون راتب"]
[{"$f":"IF(B5=\"\",\"\",SUBTOTAL(103,$B$5:B5))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"ali","سنوية"]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(103,$B$5:B6))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"saeed","مرضية"]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(103,$B$5:B7))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"mohammed","جميع الاجازات"]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(103,$B$5:B8))","v":""}]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(103,$B$5:B9))","v":""}]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(103,$B$5:B10))","v":""}]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(103,$B$5:B11))","v":""}]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(103,$B$5:B12))","v":""}]
[{"$f":"IF(B13=\"\",\"\",SUBTOTAL(103,$B$5:B13))","v":""}]
[{"$f":"IF(B14=\"\",\"\",SUBTOTAL(103,$B$5:B14))","v":""}]
[{"$f":"IF(B15=\"\",\"\",SUBTOTAL(103,$B$5:B15))","v":""}]
[{"$f":"IF(B16=\"\",\"\",SUBTOTAL(103,$B$5:B16))","v":""}]
[{"$f":"IF(B17=\"\",\"\",SUBTOTAL(103,$B$5:B17))","v":""}]
[{"$f":"IF(B18=\"\",\"\",SUBTOTAL(103,$B$5:B18))","v":""}]
[{"$f":"IF(B19=\"\",\"\",SUBTOTAL(103,$B$5:B19))","v":""}]
[{"$f":"IF(B20=\"\",\"\",SUBTOTAL(103,$B$5:B20))","v":""}]
[{"$f":"IF(B21=\"\",\"\",SUBTOTAL(103,$B$5:B21))","v":""}]
[{"$f":"IF(B22=\"\",\"\",SUBTOTAL(103,$B$5:B22))","v":""}]
[{"$f":"IF(B23=\"\",\"\",SUBTOTAL(103,$B$5:B23))","v":""}]
[{"$f":"IF(B24=\"\",\"\",SUBTOTAL(103,$B$5:B24))","v":""}]
[{"$f":"IF(B25=\"\",\"\",SUBTOTAL(103,$B$5:B25))","v":""}]
[{"$f":"IF(B26=\"\",\"\",SUBTOTAL(103,$B$5:B26))","v":""}]
[{"$f":"IF(B27=\"\",\"\",SUBTOTAL(103,$B$5:B27))","v":""}]
[{"$f":"IF(B28=\"\",\"\",SUBTOTAL(103,$B$5:B28))","v":""}]
[{"$f":"IF(B29=\"\",\"\",SUBTOTAL(103,$B$5:B29))","v":""}]
[{"$f":"IF(B30=\"\",\"\",SUBTOTAL(103,$B$5:B30))","v":""}]
[{"$f":"IF(B31=\"\",\"\",SUBTOTAL(103,$B$5:B31))","v":""}]
[{"$f":"IF(B32=\"\",\"\",SUBTOTAL(103,$B$5:B32))","v":""}]
[{"$f":"IF(B33=\"\",\"\",SUBTOTAL(103,$B$5:B33))","v":""}]
[{"$f":"IF(B34=\"\",\"\",SUBTOTAL(103,$B$5:B34))","v":""}]
[{"$f":"IF(B35=\"\",\"\",SUBTOTAL(103,$B$5:B35))","v":""}]
[{"$f":"IF(B36=\"\",\"\",SUBTOTAL(103,$B$5:B36))","v":""}]
[{"$f":"IF(B37=\"\",\"\",SUBTOTAL(103,$B$5:B37))","v":""}]
[{"$f":"IF(B38=\"\",\"\",SUBTOTAL(103,$B$5:B38))","v":""}]
[{"$f":"IF(B39=\"\",\"\",SUBTOTAL(103,$B$5:B39))","v":""}]
[{"$f":"IF(B40=\"\",\"\",SUBTOTAL(103,$B$5:B40))","v":""}]
[{"$f":"IF(B41=\"\",\"\",SUBTOTAL(103,$B$5:B41))","v":""}]
[{"$f":"IF(B42=\"\",\"\",SUBTOTAL(103,$B$5:B42))","v":""}]
[{"$f":"IF(B43=\"\",\"\",SUBTOTAL(103,$B$5:B43))","v":""}]
[{"$f":"IF(B44=\"\",\"\",SUBTOTAL(103,$B$5:B44))","v":""}]
[{"$f":"IF(B45=\"\",\"\",SUBTOTAL(103,$B$5:B45))","v":""}]
[{"$f":"IF(B46=\"\",\"\",SUBTOTAL(103,$B$5:B46))","v":""}]
[{"$f":"IF(B47=\"\",\"\",SUBTOTAL(103,$B$5:B47))","v":""}]
[{"$f":"IF(B48=\"\",\"\",SUBTOTAL(103,$B$5:B48))","v":""}]
[{"$f":"IF(B49=\"\",\"\",SUBTOTAL(103,$B$5:B49))","v":""}]
[{"$f":"IF(B50=\"\",\"\",SUBTOTAL(103,$B$5:B50))","v":""}]
[{"$f":"IF(B51=\"\",\"\",SUBTOTAL(103,$B$5:B51))","v":""}]
[{"$f":"IF(B52=\"\",\"\",SUBTOTAL(103,$B$5:B52))","v":""}]
[{"$f":"IF(B53=\"\",\"\",SUBTOTAL(103,$B$5:B53))","v":""}]
[{"$f":"IF(B54=\"\",\"\",SUBTOTAL(103,$B$5:B54))","v":""}]
[{"$f":"IF(B55=\"\",\"\",SUBTOTAL(103,$B$5:B55))","v":""}]
[{"$f":"IF(B56=\"\",\"\",SUBTOTAL(103,$B$5:B56))","v":""}]
[{"$f":"IF(B57=\"\",\"\",SUBTOTAL(103,$B$5:B57))","v":""}]
[{"$f":"IF(B58=\"\",\"\",SUBTOTAL(103,$B$5:B58))","v":""}]
[{"$f":"IF(B59=\"\",\"\",SUBTOTAL(103,$B$5:B59))","v":""}]
[{"$f":"IF(B60=\"\",\"\",SUBTOTAL(103,$B$5:B60))","v":""}]
[{"$f":"IF(B61=\"\",\"\",SUBTOTAL(103,$B$5:B61))","v":""}]
[{"$f":"IF(B62=\"\",\"\",SUBTOTAL(103,$B$5:B62))","v":""}]
[{"$f":"IF(B63=\"\",\"\",SUBTOTAL(103,$B$5:B64))","v":""}]
[{"$f":"IF(B64=\"\",\"\",SUBTOTAL(103,$B$5:B64))","v":""}]