{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["LEAVE CALCULATION"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"LEAVE CALCULATION","index":0,"n_rows":43,"n_cols":28,"rows_kept":43,"cut":false,"hidden":false,"merged":[[9,10,9,15],[9,0,10,0],[6,0,6,15],[2,0,2,15],[3,0,3,15],[7,7,7,11],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,9,9]]}
[]
[]
[]
[]
[]
[]
["Leave Balance Calculation Sheet"]
[null,"Date:",{"$f":"TODAY()","v":"2019-09-03"}]
[]
["S/L","File No","Employee Name","Designation","Joining Date:","Gross Salary",null,null,null,null,"Leave Balance Calculation"]
[null,null,null,null,null,"Basic ","Accomodation","Bonus ","Food","Total Salary ","Days","Net working days","Leave Without Pay","Previouse Paid Leave (days)","Desirve Leaves ( Days)","Leave Balance "]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"L12*(30/365)-N12","v":0},12,{"$f":"L12*(12/180)-N12","v":0},"less","He Don't Deserve Leave Salary",null,"desirve",{"$f":"IF(L12<365,W12,U12)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"L13*(30/365)-N13","v":0},12,{"$f":"L13*(12/180)-N13","v":0},"less","He Don't Deserve Leave Salary",null,"desirve",{"$f":"IF(L13<365,W13,U13)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"L14*(30/365)-N14","v":0},12,{"$f":"L14*(12/180)-N14","v":0},"less","He Don't Deserve Leave Salary",null,"desirve",{"$f":"IF(L14<365,W14,U14)","v":0}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,12,0,"less","He Don't Deserve Leave Salary",null,"desirve",0]