{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DATA","Vacation Letter ","Vacation_Registor","Vacation Report"],"not_rendered":{"charts":0,"images":10,"macros":0,"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":37,"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],[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,null,"candidate key",null,null,null,null,"R_0001"]
[]
[]
[null,"Position cod :",null,null,{"$f":"VLOOKUP(AK4,[2]!Table1[#Data],2,0)","v":1},null,null,null,null,null,null,null,null,null,"Date :",null,{"$f":"TODAY()","v":"2021-02-11"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time :",null,{"$f":"NOW()","v":44238.610405902778}]
[]
[null,null,"يرجى تقديم هذا الطلب الى إدارة الموارد البشرية بفترة لاتقل عن 30 يوماً قبل بدء الإجازة"]
[]
[]
[]
[]
[null,"معلومات مقدم الطلب "]
[]
[null,null,null,"Full Name :",null,null,{"$f":"VLOOKUP(AK4,الجدول3[],3,0)","v":"omar1"},null,null,null,null,null,{"$f":"VLOOKUP(AK4,الجدول3[],4,0)","v":"عمر1"},null,null,null,null,null,"الاسم الكامل :"]
[]
[null,null,null,{"$f":"VLOOKUP(AK4,الجدول3[],14,0)","v":"مدقق حسابات "},null,null,null,"الوظيفة :",null,null,null,null,{"$f":"VLOOKUP(AK4,الجدول3[],12,0)","v":"مالية"},null,null,null,null,null,"القسم :"]
[]
[null,null,null,{"$f":"VLOOKUP(AK4,الجدول3[],6,0)","v":"سعودي "},null,null,null,"الجنسية : ",null,null,null,null,{"$f":"VLOOKUP(AK4,الجدول3[],31,0)","v":"2016-01-01"},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":"Without Pay"},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":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["سجل الاجازات"]
["الاسم","تاريخ بداية الاجازة","تاريخ نهاية الاجازة","مدة الاجازة","نوع الاجازة","ملاحظات"]
[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,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,null,null,"حج"]

{"sheet":"Vacation Report","index":3,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[[1,2,1,4],[2,2,2,4],[63,0,63,2],[65,0,66,2],[65,3,66,3],[65,4,66,4]]}
[]
[null,"اسم الموظف"]
[null,"نوع الاجازة"]
["م","تاريخ بداية الاجازة","تاريخ نهاية الاجازة ","مدة الاجازة","ملاحظة"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الإجمالي",null,null,{"$f":"SUM(D5)","v":0}]
[]
["إجمالي رصيد الإجازات حتى",null,null,{"$f":"TODAY()","v":"2021-02-11"}]