{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sores ","Repport","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"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":"Sores ","index":0,"n_rows":35,"n_cols":47,"rows_kept":35,"cut":false,"hidden":true,"merged":[[0,0,0,45],[1,21,1,24],[1,25,1,27],[2,11,2,12],[2,16,2,18],[2,19,2,21],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,40,5,45],[1,3,1,4],[1,5,4,7]]}
[]
[null,null,"Employee Name","الموظف الاول ",null,"ارغب باستبدال المعادلات ب فجوال بيسك بحيث اختار الموظف وتاريخ الاجازة ونوع الاجازة واعمل حفظ تظهر فى الشيت مباشرة حيث تتنوع نوع الاجازة فلا يمكن استعمال المعادلات ",null,null,null,null,null,null,"Staff attendance Of Month   ",null,null,null,null,null,null,null,null,"January",null,null,null,{"$f":"I7","v":"2021-02-01"}]
[null,null,"start  leave","2021-02-01",null,null,null,null,"Start Day ",null,null,"2021-02-01",null,null,null,null,"End day",null,null,{"$f":"EOMONTH(L3,0)","v":"2021-02-28"}]
[null,null,"end  leave","2021-02-28"]
[null,null,"Type of leave","paid leave",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,35,36,37,38,39,40,41]
["S.N","Emp ID No.","Employee Name",null,null,null,null,null,{"$f":"TEXT(I7,\"dddd\")","v":"Monday"},{"$f":"TEXT(J7,\"dddd\")","v":"Tuesday"},"Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","","","",null,1]
[null,null,null,null,"start  leave","end  leave","LEAVE RETURN ","Type",{"$f":"L3","v":"2021-02-01"},{"$f":"IF(I7<$T$3,I7+1,\"\")","v":"2021-02-02"},{"$f":"IF(J7<$T$3,J7+1,\"\")","v":"2021-02-03"},"2021-02-04","2021-02-05","2021-02-06","2021-02-07","2021-02-08","2021-02-09","2021-02-10","2021-02-11","2021-02-12","2021-02-13","2021-02-14","2021-02-15","2021-02-16","2021-02-17","2021-02-18","2021-02-19","2021-02-20","2021-02-21","2021-02-22","2021-02-23","2021-02-24","2021-02-25","2021-02-26","2021-02-27","2021-02-28","","","","Total Paid days","Medical leaves","Vacation","Absence","Unpaid","Official holiday","pay","remark "]
[{"$f":"(SUBTOTAL(3,$C$8:C8))","v":1},1,"الموظف الاول ","work","2021-02-01","2021-02-28",null,"Absence",{"$f":"IF($I$6=\"الجمعة\",\"\",IF(AND(E8<=$I$7,F8>=$I$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$I$7,F8>=$I$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$I$7,F8>=$I$7,H8=\"Medical leave\"),\"M\",IF(AND($E$8<=I7,$F$8>=I7,$H$8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($J$6=\"الجمعة\",\"\",IF(AND(E8<=$J$7,F8>=$J$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$J$7,F8>=$J$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$J$7,F8>=$J$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$J$7,F8>=$J$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($K$6=\"الجمعة\",\"\",IF(AND(E8<=$K$7,F8>=$K$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$K$7,F8>=$K$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$K$7,F8>=$K$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$K$7,F8>=$K$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($L$6=\"الجمعة\",\"\",IF(AND(E8<=$L$7,F8>=$L$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$L$7,F8>=$L$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$L$7,F8>=$L$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$L$7,F8>=$L$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($M$6=\"الجمعة\",\"\",IF(AND(E8<=$M$7,F8>=$M$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$M$7,F8>=$M$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$M$7,F8>=$M$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$M$7,F8>=$M$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($N$6=\"الجمعة\",\"\",IF(AND(E8<=$N$7,F8>=$N$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$N$7,F8>=$N$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$N$7,F8>=$N$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$N$7,F8>=$N$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($O$6=\"الجمعة\",\"\",IF(AND(E8<=$O$7,F8>=$O$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$O$7,F8>=$O$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$O$7,F8>=$O$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$O$7,F8>=$O$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($P$6=\"الجمعة\",\"\",IF(AND(E8<=$P$7,F8>=$P$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$P$7,F8>=$P$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$P$7,F8>=$P$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$P$7,F8>=$P$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($Q$6=\"الجمعة\",\"\",IF(AND(E8<=$Q$7,F8>=$Q$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$Q$7,F8>=$Q$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$Q$7,F8>=$Q$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$Q$7,F8>=$Q$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($R$6=\"الجمعة\",\"\",IF(AND(E8<=$R$7,F8>=$R$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$R$7,F8>=$R$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$R$7,F8>=$R$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$R$7,F8>=$R$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($S$6=\"الجمعة\",\"\",IF(AND(E8<=$S$7,F8>=$S$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$S$7,F8>=$S$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$S$7,F8>=$S$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$S$7,F8>=$S$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($T$6=\"الجمعة\",\"\",IF(AND(E8<=$T$7,F8>=$T$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$T$7,F8>=$T$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$T$7,F8>=$T$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$T$7,F8>=$T$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($U$6=\"الجمعة\",\"\",IF(AND(E8<=$U$7,F8>=$U$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$U$7,F8>=$U$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$U$7,F8>=$U$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$U$7,F8>=$U$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($V$6=\"الجمعة\",\"\",IF(AND(E8<=$V$7,F8>=$V$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$V$7,F8>=$V$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$V$7,F8>=$V$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$V$7,F8>=$V$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($W$6=\"الجمعة\",\"\",IF(AND(E8<=$W$7,F8>=$W$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$W$7,F8>=$W$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$W$7,F8>=$W$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$W$7,F8>=$W$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($X$6=\"الجمعة\",\"\",IF(AND(E8<=$X$7,F8>=$X$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$X$7,F8>=$X$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$X$7,F8>=$X$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$X$7,F8>=$X$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($Y$6=\"الجمعة\",\"\",IF(AND(E8<=$Y$7,F8>=$Y$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$Y$7,F8>=$Y$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$Y$7,F8>=$Y$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$Y$7,F8>=$Y$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($Z$6=\"الجمعة\",\"\",IF(AND(E8<=$Z$7,F8>=$Z$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$Z$7,F8>=$Z$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$Z$7,F8>=$Z$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$Z$7,F8>=$Z$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($AA$6=\"الجمعة\",\"\",IF(AND(E8<=$AA$7,F8>=$AA$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AA$7,F8>=$AA$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AA$7,F8>=$AA$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$AA$7,F8>=$AA$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($AB$6=\"الجمعة\",\"\",IF(AND(E8<=$AB$7,F8>=$AB$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AB$7,F8>=$AB$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AB$7,F8>=$AB$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$AB$7,F8>=$AB$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($AC$6=\"الجمعة\",\"\",IF(AND(E8<=$AC$7,F8>=$AC$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AC$7,F8>=$AC$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AC$7,F8>=$AC$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$AC$7,F8>=$AC$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($AD$6=\"الجمعة\",\"\",IF(AND(E8<=$AD$7,F8>=$AD$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AD$7,F8>=$AD$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AD$7,F8>=$AD$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$AD$7,F8>=$AD$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($AE$6=\"الجمعة\",\"\",IF(AND(E8<=$AE$7,F8>=$AE$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AE$7,F8>=$AE$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AE$7,F8>=$AE$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$AE$7,F8>=$AE$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($AF$6=\"الجمعة\",\"\",IF(AND(E8<=$AF$7,F8>=$AF$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AF$7,F8>=$AF$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AF$7,F8>=$AF$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$AF$7,F8>=$AF$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($AG$6=\"الجمعة\",\"\",IF(AND(E8<=$AG$7,F8>=$AG$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AG$7,F8>=$AG$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AG$7,F8>=$AG$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$AG$7,F8>=$AG$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($AH$6=\"الجمعة\",\"\",IF(AND(E8<=$AH$7,F8>=$AH$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AH$7,F8>=$AH$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AH$7,F8>=$AH$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$AH$7,F8>=$AH$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($AI$6=\"الجمعة\",\"\",IF(AND(E8<=$AI$7,F8>=$AI$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AI$7,F8>=$AI$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AI$7,F8>=$AI$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$AI$7,F8>=$AI$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($AJ$6=\"الجمعة\",\"\",IF(AND(E8<=$AJ$7,F8>=$AJ$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AJ$7,F8>=$AJ$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AJ$7,F8>=$AJ$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$AJ$7,F8>=$AJ$7,H8=\"Absence\"),\"A\",\"\")))))","v":"A"},{"$f":"IF($AK$6=\"الجمعة\",\"\",IF(AND(E8<=$AK$7,F8>=$AK$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AK$7,F8>=$AK$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AK$7,F8>=$AK$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$AK$7,F8>=$AK$7,H8=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF(AL6=\"الجمعة\",\"\",IF(AND(E8<=$AL$7,F8>=$AL$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AL$7,F8>=$AL$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AL$7,F8>=$AL$7,H8=\"Medical leave\"),\"M\",IF(AND(E8<=$AL$7,F8>=$AL$7,H8=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AM$7=\"الجمعة\",\"\",IF(AND(E8<=$AM$7,F8>=$AM$7,H8=\"paid leave\"),\"V\",IF(AND(E8<=$AM$7,F8>=$AM$7,H8=\"unpaid leave\"),\"u\",IF(AND(E8<=$AM$7,F8>=$AM$7,H8=\"Medical leave\"),\"M\",IF(AND($E8<=$AM$7,F8>=$AM$7,H8=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"26-SUM(AP8,AQ8,AR8)","v":-2},{"$f":"COUNTIF(I8:AM8,\"M\")","v":0},{"$f":"COUNTIF(I8:AM8,\"v\")","v":0},{"$f":"COUNTIF(I8:AM8,\"a\")","v":28},{"$f":"COUNTIF(I8:AM8,\"u\")","v":0},{"$f":"COUNTIF(I8:AM8,\"h\")","v":0}]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C9),\"\")","v":2},2,"الموظف الثانى ","work",null,null,null,null,{"$f":"IF($I$6=\"الجمعة\",\"\",IF(AND(E9<=$I$7,F9>=$I$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$I$7,F9>=$I$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$I$7,F9>=$I$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$I$7,F9>=$I$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($J$6=\"الجمعة\",\"\",IF(AND(E9<=$J$7,F9>=$J$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$J$7,F9>=$J$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$J$7,F9>=$J$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$J$7,F9>=$J$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($K$6=\"الجمعة\",\"\",IF(AND(E9<=$K$7,F9>=$K$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$K$7,F9>=$K$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$K$7,F9>=$K$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$K$7,F9>=$K$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($L$6=\"الجمعة\",\"\",IF(AND(E9<=$L$7,F9>=$L$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$L$7,F9>=$L$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$L$7,F9>=$L$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$L$7,F9>=$L$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($M$6=\"الجمعة\",\"\",IF(AND(E9<=$M$7,F9>=$M$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$M$7,F9>=$M$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$M$7,F9>=$M$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$M$7,F9>=$M$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($N$6=\"الجمعة\",\"\",IF(AND(E9<=$N$7,F9>=$N$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$N$7,F9>=$N$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$N$7,F9>=$N$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$N$7,F9>=$N$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($O$6=\"الجمعة\",\"\",IF(AND(E9<=$O$7,F9>=$O$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$O$7,F9>=$O$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$O$7,F9>=$O$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$O$7,F9>=$O$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($P$6=\"الجمعة\",\"\",IF(AND(E9<=$P$7,F9>=$P$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$P$7,F9>=$P$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$P$7,F9>=$P$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$P$7,F9>=$P$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($Q$6=\"الجمعة\",\"\",IF(AND(E9<=$Q$7,F9>=$Q$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$Q$7,F9>=$Q$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$Q$7,F9>=$Q$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$Q$7,F9>=$Q$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($R$6=\"الجمعة\",\"\",IF(AND(E9<=$R$7,F9>=$R$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$R$7,F9>=$R$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$R$7,F9>=$R$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$R$7,F9>=$R$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($S$6=\"الجمعة\",\"\",IF(AND(E9<=$S$7,F9>=$S$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$S$7,F9>=$S$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$S$7,F9>=$S$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$S$7,F9>=$S$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($T$6=\"الجمعة\",\"\",IF(AND(E9<=$T$7,F9>=$T$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$T$7,F9>=$T$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$T$7,F9>=$T$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$T$7,F9>=$T$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($U$6=\"الجمعة\",\"\",IF(AND(E9<=$U$7,F9>=$U$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$U$7,F9>=$U$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$U$7,F9>=$U$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$U$7,F9>=$U$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($V$6=\"الجمعة\",\"\",IF(AND(E9<=$V$7,F9>=$V$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$V$7,F9>=$V$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$V$7,F9>=$V$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$V$7,F9>=$V$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($W$6=\"الجمعة\",\"\",IF(AND(E9<=$I$7,F9>=$I$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$I$7,F9>=$I$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$I$7,F9>=$I$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$W$7,F9>=$W$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($X$6=\"الجمعة\",\"\",IF(AND(E9<=$X$7,F9>=$X$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$X$7,F9>=$X$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$X$7,F9>=$X$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$X$7,F9>=$X$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($Y$6=\"الجمعة\",\"\",IF(AND(E9<=$Y$7,F9>=$Y$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$Y$7,F9>=$Y$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$Y$7,F9>=$Y$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$Y$7,F9>=$Y$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($Z$6=\"الجمعة\",\"\",IF(AND(E9<=$Z$7,F9>=$Z$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$Z$7,F9>=$Z$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$Z$7,F9>=$Z$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$Z$7,F9>=$Z$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AA$6=\"الجمعة\",\"\",IF(AND(E9<=$AA$7,F9>=$AA$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AA$7,F9>=$AA$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AA$7,F9>=$AA$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$AA$7,F9>=$AA$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AB$6=\"الجمعة\",\"\",IF(AND(E9<=$AB$7,F9>=$AB$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AB$7,F9>=$AB$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AB$7,F9>=$AB$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$AB$7,F9>=$AB$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AC$6=\"الجمعة\",\"\",IF(AND(E9<=$AC$7,F9>=$AC$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AC$7,F9>=$AC$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AC$7,F9>=$AC$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$AC$7,F9>=$AC$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AD$6=\"الجمعة\",\"\",IF(AND(E9<=$AD$7,F9>=$AD$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AD$7,F9>=$AD$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AD$7,F9>=$AD$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$AD$7,F9>=$AD$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AE$6=\"الجمعة\",\"\",IF(AND(E9<=$AE$7,F9>=$AE$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AE$7,F9>=$AE$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AE$7,F9>=$AE$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$AE$7,F9>=$AE$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AF$6=\"الجمعة\",\"\",IF(AND(E9<=$AF$7,F9>=$AF$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AF$7,F9>=$AF$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AF$7,F9>=$AF$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$AF$7,F9>=$AF$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AG$6=\"الجمعة\",\"\",IF(AND(E9<=$AG$7,F9>=$AG$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AG$7,F9>=$AG$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AG$7,F9>=$AG$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$AG$7,F9>=$AG$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AH$6=\"الجمعة\",\"\",IF(AND(E9<=$AH$7,F9>=$AH$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AH$7,F9>=$AH$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AH$7,F9>=$AH$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$AH$7,F9>=$AH$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AI$6=\"الجمعة\",\"\",IF(AND(E9<=$AI$7,F9>=$AI$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AI$7,F9>=$AI$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AI$7,F9>=$AI$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$AI$7,F9>=$AI$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AJ$6=\"الجمعة\",\"\",IF(AND(E9<=$AJ$7,F9>=$AJ$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AJ$7,F9>=$AJ$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AJ$7,F9>=$AJ$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$AJ$7,F9>=$AJ$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AK$6=\"الجمعة\",\"\",IF(AND(E9<=$AK$7,F9>=$AK$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AK$7,F9>=$AK$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AK$7,F9>=$AK$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$AK$7,F9>=$AK$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF(AL7=\"الجمعة\",\"\",IF(AND(E9<=$AL$7,F9>=$AL$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AL$7,F9>=$AL$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AL$7,F9>=$AL$7,H9=\"Medical leave\"),\"M\",IF(AND(E9<=$AL$7,F9>=$AL$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"IF($AM$7=\"الجمعة\",\"\",IF(AND(E9<=$AM$7,F9>=$AM$7,H9=\"paid leave\"),\"V\",IF(AND(E9<=$AM$7,F9>=$AM$7,H9=\"unpaid leave\"),\"u\",IF(AND(E9<=$AM$7,F9>=$AM$7,H9=\"Medical leave\"),\"M\",IF(AND($E9<=$AM$7,F9>=$AM$7,H9=\"Absence\"),\"A\",\"\")))))","v":""},{"$f":"26-SUM(AP9,AQ9,AR9)","v":26},{"$f":"COUNTIF(I9:AM9,\"M\")","v":0},{"$f":"COUNTIF(I9:AM9,\"v\")","v":0},{"$f":"COUNTIF(I9:AM9,\"a\")","v":0},{"$f":"COUNTIF(I9:AM9,\"u\")","v":0},{"$f":"COUNTIF(I9:AM9,\"h\")","v":0}]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C10),\"\")","v":3},3,"الموظف الثالث","work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C11),\"\")","v":4},4,"الموظف الرابع","work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C12),\"\")","v":5},5,"الموظف الخامس","work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C13),\"\")","v":6},6,"الموظف السادس","work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C14),\"\")","v":7},7,"الموظف السابع","work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C15),\"\")","v":7},8,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C16),\"\")","v":7},9,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C17),\"\")","v":7},10,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C18),\"\")","v":7},11,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C19),\"\")","v":7},12,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C20),\"\")","v":7},13,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C21),\"\")","v":7},14,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C22),\"\")","v":7},15,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C23),\"\")","v":7},16,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C24),\"\")","v":7},17,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C25),\"\")","v":7},18,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C26),\"\")","v":7},19,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C27),\"\")","v":7},20,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C28),\"\")","v":7},21,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C29),\"\")","v":7},22,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C30),\"\")","v":7},23,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C31),\"\")","v":7},24,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C32),\"\")","v":7},25,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C33),\"\")","v":7},26,null,"work",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",26,0,0,0,0,0]
[{"$f":"IFERROR(SUBTOTAL(3,$C$8:C34),\"\")","v":7},27,null,"Resingnation",{"$f":"IF(D34=\"resingnation\",$L$3)","v":"2021-02-01"},{"$f":"IF(D34=\"resingnation\",$T$3)","v":"2021-02-28"},null,"unpaid leave","u","u","u",{"$f":"IF($L$6=\"الجمعة\",\"\",IF(AND(E34<=$L$7,F34>=$L$7,H34=\"paid leave\"),\"V\",IF(AND(E34<=$L$7,F34>=$L$7,H34=\"unpaid leave\"),\"u\",IF(AND(E34<=$L$7,F34>=$L$7,H34=\"Medical leave\"),\"M\",IF(AND(E34<=$L$7,F34>=$L$7,H34=\"Absence\"),\"A\",\"\")))))","v":"u"},"u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","","","",-2,0,0,0,28,0]
[28,28,null,"Resingnation",{"$f":"IF(D35=\"resingnation\",$L$3)","v":"2021-02-01"},{"$f":"IF(D35=\"resingnation\",$T$3)","v":"2021-02-28"},null,"unpaid leave","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","u","","","",-2,0,0,0,28,0]

{"sheet":"Repport","index":1,"n_rows":34,"n_cols":48,"rows_kept":34,"cut":false,"hidden":false,"merged":[[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,40,5,46],[2,20,2,24],[2,12,2,15],[0,0,0,46],[1,3,1,4],[1,5,4,7],[1,22,1,25],[1,26,1,28],[2,17,2,19],[3,21,3,23]]}
[]
[null,null,"Employee Name","الموظف الاول ",null,"ارغب باستبدال المعادلات ب فجوال بيسك بحيث اختار الموظف وتاريخ الاجازة ونوع الاجازة واعمل حفظ تظهر فى الشيت مباشرة حيث تتنوع نوع الاجازة فلا يمكن استعمال المعادلات ",null,null,null,null,null,null,null,"Staff attendance Of Month   "]
[null,null,"start  leave","2021-02-01",null,null,null,null,null,"Start Day ",null,null,"2021-03-01",null,null,null,null,"End day",null,null,"2021-03-31"]
[null,null,"end  leave","2021-02-28"]
[null,null,"Type of leave","paid leave"]
["S.N","Emp ID No.","Employee Name",null,null,null,null,null,null,"Sunday","Monday","Tuesday","Wednesday","Thursday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Saturday","Sunday","Monday","Tuesday",null,null,null,null,1]
[null,null,null,null,"start  leave","end  leave","LEAVE\nRETURN ","Type",null,"1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-07","1900-01-08","1900-01-09","1900-01-10","1900-01-11","1900-01-12","1900-01-14","1900-01-15","1900-01-16","1900-01-17","1900-01-18","1900-01-19","1900-01-21","1900-01-22","1900-01-23","1900-01-24","1900-01-25","1900-01-26","1900-01-28","1900-01-29","1900-01-30","1900-01-31",null,null,null,"Working Days","Medical leaves","Vacation","Absence","Unpaid","Official holiday","pay","emergency leave","remark "]
[]
[{"$f":"IF(C9=\"\",\"\",MAX($A$8:A8)+1)","v":1},1,"Employee 1","work",null,null,null,null,null,"H","U","U","U",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E","P","A","V","E","P","M","A",null,null,27,1,1,2,3,1,2,2,12]
[{"$f":"IF(C10=\"\",\"\",MAX($A$8:A9)+1)","v":2},2,"Employee 2","work",null,null,null,null,null,"M","U","V","U","P","P","U","H","M","V","V","A","U","E","H","A","A","H","A","A","E","H","V","A","M","H","U","H",null,null,27,3,4,6,5,6,2,2,28]
[{"$f":"IF(C11=\"\",\"\",MAX($A$8:A10)+1)","v":3},3,"Employee 3","work",null,null,null,null,null,"H","U","H","P","V","P","M","H","U","H","H","M","H","A","A","A","H",null,null,"V","U","E","U","U","M","M","H","M",null,null,27,5,2,3,5,8,2,1,26]
[{"$f":"IF(C12=\"\",\"\",MAX($A$8:A11)+1)","v":4},4,"Employee 4","work",null,null,null,null,null,"M","M","U","H","V","A",null,null,null,null,null,null,null,null,null,null,null,null,null,"M","V","P","H","U","M","P","V","M",null,null,27,5,3,1,2,2,2,null,15]
[{"$f":"IF(C13=\"\",\"\",MAX($A$8:A12)+1)","v":5},5,"Employee 5","work",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,"V",null,null,27,null,1,null,null,null,null,null,1]
[{"$f":"IF(C14=\"\",\"\",MAX($A$8:A13)+1)","v":6},6,"Employee 6","work",null,null,null,null,null,"A","E","A","E",null,"A","A","P","H","H","P","H",null,null,null,null,"E",null,"U","V","P","M","M","U","H",null,"V","E","V",null,27,2,3,4,2,4,3,4,22]
[{"$f":"IF(C15=\"\",\"\",MAX($A$8:A14)+1)","v":7},7,"Employee 7","work",null,null,null,null,null,"P","U","V","V","M","V","E","U","U","U","V","U","A","V","P","V","P","A","U","A","V","H","U","H","H","E","V","P","M",null,27,2,8,3,7,3,4,2,29]
[{"$f":"IF(C16=\"\",\"\",MAX($A$8:A15)+1)","v":8},8,"Employee 8","work",null,null,null,null,null,"A",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,27,null,null,1,null,null,null,null,1]
[{"$f":"IF(C17=\"\",\"\",MAX($A$8:A16)+1)","v":""},null,null,"work"]
[{"$f":"IF(C18=\"\",\"\",MAX($A$8:A17)+1)","v":""},null,null,"work"]
[{"$f":"IF(C19=\"\",\"\",MAX($A$8:A18)+1)","v":""},null,null,"work"]
[{"$f":"IF(C20=\"\",\"\",MAX($A$8:A19)+1)","v":""},null,null,"work"]
[{"$f":"IF(C21=\"\",\"\",MAX($A$8:A20)+1)","v":""},null,null,"work"]
[{"$f":"IF(C22=\"\",\"\",MAX($A$8:A21)+1)","v":""},null,null,"work"]
[{"$f":"IF(C23=\"\",\"\",MAX($A$8:A22)+1)","v":""},null,null,"work"]
[{"$f":"IF(C24=\"\",\"\",MAX($A$8:A23)+1)","v":""},null,null,"work"]
[{"$f":"IF(C25=\"\",\"\",MAX($A$8:A24)+1)","v":""},null,null,"work"]
[{"$f":"IF(C26=\"\",\"\",MAX($A$8:A25)+1)","v":""},null,null,"work"]
[{"$f":"IF(C27=\"\",\"\",MAX($A$8:A26)+1)","v":""},null,null,"work"]
[{"$f":"IF(C28=\"\",\"\",MAX($A$8:A27)+1)","v":""},null,null,"work"]
[{"$f":"IF(C29=\"\",\"\",MAX($A$8:A28)+1)","v":""},null,null,"work"]
[{"$f":"IF(C30=\"\",\"\",MAX($A$8:A29)+1)","v":""},null,null,"work"]
[{"$f":"IF(C31=\"\",\"\",MAX($A$8:A30)+1)","v":""},null,null,"work"]
[{"$f":"IF(C32=\"\",\"\",MAX($A$8:A31)+1)","v":""},null,null,"work"]
[{"$f":"IF(C33=\"\",\"\",MAX($A$8:A32)+1)","v":""},null,null,"work"]
[{"$f":"IF(C34=\"\",\"\",MAX($A$8:A33)+1)","v":""},null,null,"work"]

{"sheet":"Sheet2","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Type Leave"]
[null,null,"Medical leaves","M"]
[null,null,"Vacation","V"]
[null,null,"Absence","A"]
[null,null,"Unpaid","U"]
[null,null,"Official holiday","H"]
[null,null,"emergency leave","E"]
[null,null,"Pay","P"]