{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Employee Attendance Template","Database","Consolidation","Salary Slip"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":3,"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":"Employee Attendance Template","index":0,"n_rows":44,"n_cols":42,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,35,0,41],[0,4,0,34],[1,35,1,41],[43,2,43,3],[1,0,1,1],[0,0,0,1],[0,2,1,2]]}
["www.ExceDataPro.com",null,null,"Month",{"$f":"D2","v":"May"},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,"Attendance"]
["Attendance And Salary Sheet",null,null,"May",{"$f":"TEXT(E3,\"ddd\")","v":"Tue"},{"$f":"TEXT(F3,\"ddd\")","v":"Wed"},"Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Summary"]
["SR No","Employee Name","Emp ID","Designation","2018-05-01",{"$f":"+E3+1","v":"2018-05-02"},"2018-05-03","2018-05-04","2018-05-05","2018-05-06","2018-05-07","2018-05-08","2018-05-09","2018-05-10","2018-05-11","2018-05-12","2018-05-13","2018-05-14","2018-05-15","2018-05-16","2018-05-17","2018-05-18","2018-05-19","2018-05-20","2018-05-21","2018-05-22","2018-05-23","2018-05-24","2018-05-25","2018-05-26","2018-05-27","2018-05-28","2018-05-29","2018-05-30","2018-05-31","Present","Leave Taken","Allowed Leave","Total Days in Month","Total Working Days","Worked Days","Total Day Off"]
[1,"Raj Sharma","EM1024","Chief Technical Officer","P","L","P","P","P","H","P","P","P","P","P","P","H","P","P","P","L","P","P","H","P","P","P","P","H","P","H","L","L","L","P",{"$f":"COUNTIF(E4:AI4,\"P\")","v":21},{"$f":"COUNTIF(E4:AI4,\"L\")","v":5},2,{"$f":"COUNTA(E2:AI2)","v":31},{"$f":"COUNTA(E2:AI2)-COUNTIF(E2:AI2,\"Sun\")","v":27},{"$f":"IF(AK4>=AL4,AN4-AK4,AN4)","v":22},{"$f":"COUNTIF(E4:AI4,\"H\")","v":5}]
[2,"Sharad Gandhi","EM1025","Accountant","P","P","P","P","P","H","P","L","P","P","P","P","H","P","P","P","P","P","P","H","P","P","L","P","H","P","H","P","P","P","L",23,{"$f":"COUNTIF(E5:AI5,\"L\")","v":3},2,{"$f":"COUNTA(E3:AI3)","v":31},{"$f":"AN4","v":27},{"$f":"IF(AK5>=AL5,AN5-AK5,AN5)","v":24},{"$f":"COUNTIF(E5:AI5,\"H\")","v":5}]
[3,"Danish D'Souza","EM1026","Senior Web Developer","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",26,0,2,31,{"$f":"AN5","v":27},27,5]
[4,"Pawan Patil","EM1027","Senior Ux/Ui Developer","L","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",25,1,2,31,{"$f":"AN6","v":27},27,5]
[5,"Rijo Paul","EM1028","Senior Web Developer","P","P","P","P","P","H","P","P","P","L","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",25,1,2,31,{"$f":"AN7","v":27},27,5]
[6,"Joseph P","EM1029","Senior Web Developer","P","P","P","P","L","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","L","P","P","P",24,2,2,31,{"$f":"AN8","v":27},25,5]
[7,"Aakash Patel","EM1030","Web Developer","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",26,0,2,31,{"$f":"AN9","v":27},27,5]
[8,"Ganesh Rahu","EM1031","Ux/Ui Designer","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",26,0,2,31,{"$f":"AN10","v":27},27,5]
[9,"Vinudas K.S","EM1032","Web Developer","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",26,0,2,31,{"$f":"AN11","v":27},27,5]
[10,"Divya Kumar","EM1033","Web Developer","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","L","P","H","P","P","P","L","H","P","H","P","P","P","P",24,2,2,31,{"$f":"AN12","v":27},25,5]
[11,"Shilpa R","EM1034","QAA","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",26,0,2,31,{"$f":"AN13","v":27},27,5]
[12,"Sindhu J.P","EM1035","Web Developer","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",26,0,2,31,{"$f":"AN14","v":27},27,5]
[13,"Deepthi P.S","EM1036","QAA","P","L","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",25,1,2,31,{"$f":"AN15","v":27},27,5]
[14,"Lijin k c","EM1037","Accountant","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",26,0,2,31,{"$f":"AN16","v":27},27,5]
[15,"Sayad K M","EM1038","Project Manager","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",26,0,2,31,{"$f":"AN17","v":27},27,5]
[16,"Ajil k Mohanan","EM1039","Web Developer","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",26,0,2,31,{"$f":"AN18","v":27},27,5]
[17,"Edison ML","EM1040","Web Developer","P","P","P","P","P","H","P","P","P","L","P","P","H","P","L","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",24,2,2,31,{"$f":"AN19","v":27},25,5]
[18,"Basil P E","EM1041","Web Developer","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",26,0,2,31,{"$f":"AN20","v":27},27,5]
[19,"Jobin George","EM1042","Web Developer","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","L","H","P","H","L","P","L","P",23,3,2,31,{"$f":"AN21","v":27},24,5]
[20,"Jismon Tomy","EM1043","Web Developer","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","L","P","P","P","H","P","P","P","P","H","P","H","P","P","P","P",25,1,2,31,{"$f":"AN22","v":27},27,5]
[21,"Sharafali P","EM1044","Ux/Ui Designer","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","P","P","H","P","P","P","P","H","P","H","P","P","P","L",25,1,2,31,{"$f":"AN23","v":27},27,5]
[22,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,0,0,null,31,{"$f":"AN24","v":27},27,0]
[23,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,0,0,null,31,{"$f":"AN25","v":27},27,0]
[24,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,0,0,null,0,{"$f":"AN26","v":27},27,0]
[25,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,0,0,null,0,{"$f":"AN27","v":27},27,0]
[26,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,0,0,null,0,{"$f":"AN28","v":27},27,0]
[27,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,0,0,null,0,{"$f":"AN29","v":27},27,0]
[28,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,0,0,null,0,{"$f":"AN30","v":27},27,0]
[29,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,0,0,null,0,{"$f":"AN31","v":27},27,0]
[30,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,0,0,null,0,{"$f":"AN32","v":27},27,0]
[31,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,0,0,null,0,{"$f":"AN33","v":27},27,0]
[32,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,0,0,null,0,{"$f":"AN34","v":27},27,0]
[33,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,0,0,null,0,{"$f":"AN35","v":27},27,0]
[34,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,0,0,null,0,{"$f":"AN36","v":27},27,0]
[35,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,0,0,null,0,{"$f":"AN37","v":27},27,0]
[36,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,0,0,null,0,{"$f":"AN38","v":27},27,0]
[37,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,0,0,null,0,{"$f":"AN39","v":27},27,0]
[38,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,0,0,null,0,{"$f":"AN40","v":27},27,0]
[39,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,0,0,null,0,{"$f":"AN41","v":27},27,0]
[40,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,0,0,null,0,{"$f":"AN42","v":27},27,0]
[null,{"$f":"COUNTA(B4:B43)","v":21},"Daily Employee Strength",null,{"$f":"COUNTIF(E4:E43, \"P\")","v":20},{"$f":"COUNTIF(F4:F43, \"P\")","v":19},{"$f":"COUNTIF(G4:G43, \"P\")","v":21},{"$f":"COUNTIF(H4:H43, \"P\")","v":21},{"$f":"COUNTIF(I4:I43, \"P\")","v":20},{"$f":"COUNTIF(J4:J43, \"P\")","v":0},{"$f":"COUNTIF(K4:K43, \"P\")","v":21},{"$f":"COUNTIF(L4:L43, \"P\")","v":20},{"$f":"COUNTIF(M4:M43, \"P\")","v":21},{"$f":"COUNTIF(N4:N43, \"P\")","v":19},{"$f":"COUNTIF(O4:O43, \"P\")","v":21},{"$f":"COUNTIF(P4:P43, \"P\")","v":21},{"$f":"COUNTIF(Q4:Q43, \"P\")","v":0},{"$f":"COUNTIF(R4:R43, \"P\")","v":21},{"$f":"COUNTIF(S4:S43, \"P\")","v":20},{"$f":"COUNTIF(T4:T43, \"P\")","v":20},{"$f":"COUNTIF(U4:U43, \"P\")","v":20},{"$f":"COUNTIF(V4:V43, \"P\")","v":20},{"$f":"COUNTIF(W4:W43, \"P\")","v":21},{"$f":"COUNTIF(X4:X43, \"P\")","v":0},{"$f":"COUNTIF(Y4:Y43, \"P\")","v":21},{"$f":"COUNTIF(Z4:Z43, \"P\")","v":21},{"$f":"COUNTIF(AA4:AA43, \"P\")","v":20},{"$f":"COUNTIF(AB4:AB43, \"P\")","v":19},{"$f":"COUNTIF(AC4:AC43, \"P\")","v":0},{"$f":"COUNTIF(AD4:AD43, \"P\")","v":21},{"$f":"COUNTIF(AE4:AE43, \"P\")","v":0},{"$f":"COUNTIF(AF4:AF43, \"P\")","v":18},{"$f":"COUNTIF(AG4:AG43, \"P\")","v":20},{"$f":"COUNTIF(AH4:AH43, \"P\")","v":19},{"$f":"COUNTIF(AI4:AI43, \"P\")","v":19}]

{"sheet":"Database","index":1,"n_rows":54,"n_cols":36,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,23,1,27],[1,0,1,8],[1,9,1,22]]}
[1,{"$f":"A1+1","v":2},{"$f":"B1+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]
[null,null,null,null,null,null,null,null,null,"TOTAL GROSS SALARY",null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL DEDUCTIONS"]
["Name","Designation","Month","Year","Working Days","Allowed Leave","Leave taken","Worked Days","CTC",{"$f":"CONCATENATE(\"CTC for \"&C4&\" \",D4)","v":"CTC for May 2018"},"Basic Salary","DA","HRA","Conveyance","Conv Working","Medical Expenses","Medi Working","Spec working","Special","Total working","Bonus","TA","TOTAL","Contribution to PF","Profession Tax","TDS","Salary Advance","TOTAL","NET PAYABLE","Gender","Prefix","Name of Authorised Signatory","PF Applicable","Medical Bill Submitted","Medical Bill Amount","Your Company Name"]
[{"$f":"IF('Employee Attendance Template'!B4=\"\",\"\",'Employee Attendance Template'!B4)","v":"Raj Sharma"},{"$f":"IF('Employee Attendance Template'!D4=\"\",\"\",'Employee Attendance Template'!D4)","v":"Chief Technical Officer"},"May",2018,{"$f":"IF(A4=\"\",0,'Employee Attendance Template'!AN4)","v":27},{"$f":"IF(A4=\"\",0,'Employee Attendance Template'!AL4)","v":2},{"$f":"IF(A4=\"\",0,'Employee Attendance Template'!AK4)","v":5},{"$f":"IF(G4>=F4,E4-G4+F4,E4)","v":24},60000,{"$f":"IF(H4=0,\"\",ROUND(I4/E4*H4,-1))","v":53330},{"$f":"IF(H4=0,\"\",ROUND($J4/E4*H4*50%,-1))","v":23700},{"$f":"IF(H4=0,\"\",ROUND(J4/E4*H4*10%,-1))","v":4740},{"$f":"IF(H4=0,\"\",ROUND(J4/E4*H4*25%,-1))","v":11850},{"$f":"IF(H4=0,\"\",1600)","v":1600},{"$f":"IF(H4=0,\"\",ROUND(N4/E4*H4,-1))","v":1420},{"$f":"MIN(1250,IF(AH4=\"Yes\",IF(H4=0,\"\",AI4),0))","v":1250},null,{"$f":"IF(H4=0,\"\",ROUND(J4-T4,-1))","v":10370},{"$f":"IF(R4<=0,0,R4)","v":10370},{"$f":"IF(H4=0,\"\",SUM(K4:M4)+O4+P4)","v":42960},13100,0,{"$f":"IF(H4=0,\"\",SUM(K4:M4)+O4+Q4+S4+U4+V4)","v":65180},{"$f":"ROUND(MIN(1800,IF(AG4=\"Yes\",SUM(K4:L4)*12%,0)),-1)","v":1800},null,7000,null,{"$f":"SUM(X4:AA4)","v":8800},{"$f":"IFERROR(W4-AB4,\"\")","v":56380},"Male",{"$f":"IF(AD4=0,\"\",IF(AD4=\"Male\",\"Mr\",IF(AD4=\"Female\",\"Mrs\")))","v":"Mr"},"Managing Director","Yes","Yes",1250,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B5=\"\",\"\",'Employee Attendance Template'!B5)","v":"Sharad Gandhi"},{"$f":"IF('Employee Attendance Template'!D5=\"\",\"\",'Employee Attendance Template'!D5)","v":"Accountant"},{"$f":"IF(A5=0,\"\",C$4)","v":"May"},{"$f":"IF(A5=0,\"\",D$4)","v":2018},{"$f":"IF(A5=\"\",0,'Employee Attendance Template'!AN5)","v":27},{"$f":"IF(A5=\"\",0,'Employee Attendance Template'!AL5)","v":2},{"$f":"IF(A5=\"\",0,'Employee Attendance Template'!AK5)","v":3},{"$f":"IF(G5>=F5,E5-G5+F5,E5)","v":26},30000,{"$f":"IF(H5=0,\"\",ROUND(I5/E5*H5,-1))","v":28890},{"$f":"IF(H5=0,\"\",ROUND($J5/E5*H5*50%,-1))","v":13910},{"$f":"IF(H5=0,\"\",ROUND(J5/E5*H5*10%,-1))","v":2780},{"$f":"IF(H5=0,\"\",ROUND(J5/E5*H5*25%,-1))","v":6960},{"$f":"IF(H5=0,\"\",1600)","v":1600},{"$f":"IF(H5=0,\"\",ROUND(N5/E5*H5,-1))","v":1540},{"$f":"MIN(1250,IF(AH5=\"Yes\",IF(H5=0,\"\",AI5),0))","v":1250},null,{"$f":"IF(H5=0,\"\",ROUND(J5-T5,-1))","v":2450},2450,{"$f":"IF(H5=0,\"\",SUM(K5:M5)+O5+P5)","v":26440},2300,0,29940,{"$f":"ROUND(MIN(1800,IF(AG5=\"Yes\",SUM(K5:L5)*12%,0)),-1)","v":1800},null,500,null,2300,27640,"Male","Mr",{"$f":"IF(A5=0,\"\",AF$4)","v":"Managing Director"},"Yes","Yes",1250,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B6=\"\",\"\",'Employee Attendance Template'!B6)","v":"Danish D'Souza"},{"$f":"IF('Employee Attendance Template'!D6=\"\",\"\",'Employee Attendance Template'!D6)","v":"Senior Web Developer"},"May",2018,{"$f":"IF(A6=\"\",0,'Employee Attendance Template'!AN6)","v":27},{"$f":"IF(A6=\"\",0,'Employee Attendance Template'!AL6)","v":2},{"$f":"IF(A6=\"\",0,'Employee Attendance Template'!AK6)","v":0},27,20000,20000,10000,2000,5000,1000,1000,1250,null,750,750,19250,0,0,18750,1440,null,null,null,1440,17310,"Male","Mr",{"$f":"IF(A6=0,\"\",AF$4)","v":"Managing Director"},"Yes","Yes",2000,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B7=\"\",\"\",'Employee Attendance Template'!B7)","v":"Pawan Patil"},{"$f":"IF('Employee Attendance Template'!D7=\"\",\"\",'Employee Attendance Template'!D7)","v":"Senior Ux/Ui Developer"},"May",2018,{"$f":"IF(A7=\"\",0,'Employee Attendance Template'!AN7)","v":27},{"$f":"IF(A7=\"\",0,'Employee Attendance Template'!AL7)","v":2},{"$f":"IF(A7=\"\",0,'Employee Attendance Template'!AK7)","v":1},27,25000,25000,12500,2500,6250,{"$f":"IF(H7=0,\"\",1600)","v":1600},1600,1250,null,900,900,24100,0,0,23750,1800,null,null,null,1800,21950,"Male","Mr",{"$f":"IF(A7=0,\"\",AF$4)","v":"Managing Director"},"Yes","Yes",1250,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B8=\"\",\"\",'Employee Attendance Template'!B8)","v":"Rijo Paul"},{"$f":"IF('Employee Attendance Template'!D8=\"\",\"\",'Employee Attendance Template'!D8)","v":"Senior Web Developer"},"May",2018,{"$f":"IF(A8=\"\",0,'Employee Attendance Template'!AN8)","v":27},{"$f":"IF(A8=\"\",0,'Employee Attendance Template'!AL8)","v":2},{"$f":"IF(A8=\"\",0,'Employee Attendance Template'!AK8)","v":1},27,22000,22000,11000,2200,5500,1100,1100,1250,null,950,950,21050,2300,0,23050,1580,null,null,null,1580,21470,"Male","Mr",{"$f":"IF(A8=0,\"\",AF$4)","v":"Managing Director"},"Yes","Yes",2200,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B9=\"\",\"\",'Employee Attendance Template'!B9)","v":"Joseph P"},{"$f":"IF('Employee Attendance Template'!D9=\"\",\"\",'Employee Attendance Template'!D9)","v":"Senior Web Developer"},"May",2018,{"$f":"IF(A9=\"\",0,'Employee Attendance Template'!AN9)","v":27},{"$f":"IF(A9=\"\",0,'Employee Attendance Template'!AL9)","v":2},{"$f":"IF(A9=\"\",0,'Employee Attendance Template'!AK9)","v":2},27,14000,14000,7000,1400,3500,700,700,1250,null,150,150,13850,2300,0,15050,1010,null,null,null,1010,14040,"Male","Mr","Managing Director","Yes","Yes",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B10=\"\",\"\",'Employee Attendance Template'!B10)","v":"Aakash Patel"},{"$f":"IF('Employee Attendance Template'!D10=\"\",\"\",'Employee Attendance Template'!D10)","v":"Web Developer"},"May",2018,{"$f":"IF(A10=\"\",0,'Employee Attendance Template'!AN10)","v":27},{"$f":"IF(A10=\"\",0,'Employee Attendance Template'!AL10)","v":2},{"$f":"IF(A10=\"\",0,'Employee Attendance Template'!AK10)","v":0},27,15000,15000,7500,1500,3750,600,600,1200,null,450,450,14550,0,0,13800,1080,null,null,null,1080,12720,"Male","Mr","Managing Director","Yes","Yes",1200,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B11=\"\",\"\",'Employee Attendance Template'!B11)","v":"Ganesh Rahu"},{"$f":"IF('Employee Attendance Template'!D11=\"\",\"\",'Employee Attendance Template'!D11)","v":"Ux/Ui Designer"},"May",2018,{"$f":"IF(A11=\"\",0,'Employee Attendance Template'!AN11)","v":27},{"$f":"IF(A11=\"\",0,'Employee Attendance Template'!AL11)","v":2},{"$f":"IF(A11=\"\",0,'Employee Attendance Template'!AK11)","v":0},27,14000,14000,7000,1400,3500,600,600,1200,null,300,{"$f":"IF(R11<=0,0,R11)","v":300},13700,0,0,12800,1010,null,null,null,1010,11790,"Male","Mr","Managing Director","Yes","Yes",1200,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B12=\"\",\"\",'Employee Attendance Template'!B12)","v":"Vinudas K.S"},{"$f":"IF('Employee Attendance Template'!D12=\"\",\"\",'Employee Attendance Template'!D12)","v":"Web Developer"},"May",2018,{"$f":"IF(A12=\"\",0,'Employee Attendance Template'!AN12)","v":27},{"$f":"IF(A12=\"\",0,'Employee Attendance Template'!AL12)","v":2},{"$f":"IF(A12=\"\",0,'Employee Attendance Template'!AK12)","v":0},27,14000,14000,7000,1400,3500,700,700,1250,null,150,150,13850,1500,0,14250,1010,null,null,null,1010,13240,"Male","Mr","Managing Director","Yes","Yes",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B13=\"\",\"\",'Employee Attendance Template'!B13)","v":"Divya Kumar"},{"$f":"IF('Employee Attendance Template'!D13=\"\",\"\",'Employee Attendance Template'!D13)","v":"Web Developer"},"May",2018,{"$f":"IF(A13=\"\",0,'Employee Attendance Template'!AN13)","v":27},{"$f":"IF(A13=\"\",0,'Employee Attendance Template'!AL13)","v":2},{"$f":"IF(A13=\"\",0,'Employee Attendance Template'!AK13)","v":2},27,8000,8000,4000,800,2000,400,400,800,null,0,0,8000,0,0,7200,580,null,null,null,580,6620,"Female","Mrs","Managing Director","Yes","Yes",800,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B14=\"\",\"\",'Employee Attendance Template'!B14)","v":"Shilpa R"},{"$f":"IF('Employee Attendance Template'!D14=\"\",\"\",'Employee Attendance Template'!D14)","v":"QAA"},"May",2018,{"$f":"IF(A14=\"\",0,'Employee Attendance Template'!AN14)","v":27},{"$f":"IF(A14=\"\",0,'Employee Attendance Template'!AL14)","v":2},{"$f":"IF(A14=\"\",0,'Employee Attendance Template'!AK14)","v":0},27,8000,8000,4000,800,2000,387,390,774,null,40,40,7964,0,0,7230,580,null,null,null,580,6650,"Female","Mrs","Managing Director","Yes","Yes",774,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B15=\"\",\"\",'Employee Attendance Template'!B15)","v":"Sindhu J.P"},{"$f":"IF('Employee Attendance Template'!D15=\"\",\"\",'Employee Attendance Template'!D15)","v":"Web Developer"},"May",2018,{"$f":"IF(A15=\"\",0,'Employee Attendance Template'!AN15)","v":27},{"$f":"IF(A15=\"\",0,'Employee Attendance Template'!AL15)","v":2},{"$f":"IF(A15=\"\",0,'Employee Attendance Template'!AK15)","v":0},27,8000,8000,4000,800,2000,400,400,800,null,0,0,8000,0,0,7200,580,null,null,null,580,6620,"Female","Mrs","Managing Director","Yes","Yes",800,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B16=\"\",\"\",'Employee Attendance Template'!B16)","v":"Deepthi P.S"},{"$f":"IF('Employee Attendance Template'!D16=\"\",\"\",'Employee Attendance Template'!D16)","v":"QAA"},"May",2018,{"$f":"IF(A16=\"\",0,'Employee Attendance Template'!AN16)","v":27},{"$f":"IF(A16=\"\",0,'Employee Attendance Template'!AL16)","v":2},{"$f":"IF(A16=\"\",0,'Employee Attendance Template'!AK16)","v":1},27,8000,8000,4000,800,2000,181,180,749,null,270,270,7729,0,0,7250,580,null,null,null,580,6670,"Female","Mrs","Managing Director","Yes","Yes",749,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B17=\"\",\"\",'Employee Attendance Template'!B17)","v":"Lijin k c"},{"$f":"IF('Employee Attendance Template'!D17=\"\",\"\",'Employee Attendance Template'!D17)","v":"Accountant"},"May",2018,{"$f":"IF(A17=\"\",0,'Employee Attendance Template'!AN17)","v":27},{"$f":"IF(A17=\"\",0,'Employee Attendance Template'!AL17)","v":2},{"$f":"IF(A17=\"\",0,'Employee Attendance Template'!AK17)","v":0},27,13000,13000,6500,1300,3250,500,500,1000,null,450,450,12550,2000,0,14000,940,null,null,null,940,13060,"Male",{"$f":"IF(AD17=0,\"\",IF(AD17=\"Male\",\"Mr\",IF(AD17=\"Female\",\"Mrs\")))","v":"Mr"},"Managing Director","Yes","Yes",1000,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B18=\"\",\"\",'Employee Attendance Template'!B18)","v":"Sayad K M"},{"$f":"IF('Employee Attendance Template'!D18=\"\",\"\",'Employee Attendance Template'!D18)","v":"Project Manager"},"May",2018,{"$f":"IF(A18=\"\",0,'Employee Attendance Template'!AN18)","v":27},{"$f":"IF(A18=\"\",0,'Employee Attendance Template'!AL18)","v":2},{"$f":"IF(A18=\"\",0,'Employee Attendance Template'!AK18)","v":0},27,35000,35000,17500,3500,8750,{"$f":"IF(H18=0,\"\",1600)","v":1600},1600,1250,null,2400,{"$f":"IF(R18<=0,0,R18)","v":2400},32600,2000,0,35750,1800,null,2000,null,3800,31950,"Male",{"$f":"IF(AD18=0,\"\",IF(AD18=\"Male\",\"Mr\",IF(AD18=\"Female\",\"Mrs\")))","v":"Mr"},"Managing Director","Yes","Yes",1250,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B19=\"\",\"\",'Employee Attendance Template'!B19)","v":"Ajil k Mohanan"},{"$f":"IF('Employee Attendance Template'!D19=\"\",\"\",'Employee Attendance Template'!D19)","v":"Web Developer"},"May",2018,{"$f":"IF(A19=\"\",0,'Employee Attendance Template'!AN19)","v":27},{"$f":"IF(A19=\"\",0,'Employee Attendance Template'!AL19)","v":2},{"$f":"IF(A19=\"\",0,'Employee Attendance Template'!AK19)","v":0},27,22000,22000,11000,2200,5500,500,500,1250,null,1550,1550,20450,0,0,20750,1580,null,null,null,1580,{"$f":"IFERROR(W19-AB19,\"\")","v":19170},"Male","Mr","Managing Director","Yes","Yes",2000,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B20=\"\",\"\",'Employee Attendance Template'!B20)","v":"Edison ML"},{"$f":"IF('Employee Attendance Template'!D20=\"\",\"\",'Employee Attendance Template'!D20)","v":"Web Developer"},"May",2018,{"$f":"IF(A20=\"\",0,'Employee Attendance Template'!AN20)","v":27},{"$f":"IF(A20=\"\",0,'Employee Attendance Template'!AL20)","v":2},{"$f":"IF(A20=\"\",0,'Employee Attendance Template'!AK20)","v":2},27,12000,12000,6000,1200,3000,600,600,1200,null,0,0,12000,1000,0,11800,860,null,null,null,860,10940,"Male","Mr","Managing Director","Yes","Yes",1200,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B21=\"\",\"\",'Employee Attendance Template'!B21)","v":"Basil P E"},{"$f":"IF('Employee Attendance Template'!D21=\"\",\"\",'Employee Attendance Template'!D21)","v":"Web Developer"},"May",2018,{"$f":"IF(A21=\"\",0,'Employee Attendance Template'!AN21)","v":27},{"$f":"IF(A21=\"\",0,'Employee Attendance Template'!AL21)","v":2},{"$f":"IF(A21=\"\",0,'Employee Attendance Template'!AK21)","v":0},27,22000,22000,11000,2200,5500,267,270,1067,null,1960,1960,20037,5000,0,25930,1580,null,null,null,1580,24350,"Male","Mr","Managing Director","Yes","Yes",1067,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B22=\"\",\"\",'Employee Attendance Template'!B22)","v":"Jobin George"},{"$f":"IF('Employee Attendance Template'!D22=\"\",\"\",'Employee Attendance Template'!D22)","v":"Web Developer"},"May",2018,{"$f":"IF(A22=\"\",0,'Employee Attendance Template'!AN22)","v":27},{"$f":"IF(A22=\"\",0,'Employee Attendance Template'!AL22)","v":2},{"$f":"IF(A22=\"\",0,'Employee Attendance Template'!AK22)","v":3},26,16000,15410,7420,1480,3710,800,770,1250,null,780,780,14630,1500,0,15660,1070,null,null,null,1070,14590,"Male","Mr","Managing Director","Yes","Yes",1600,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B23=\"\",\"\",'Employee Attendance Template'!B23)","v":"Jismon Tomy"},{"$f":"IF('Employee Attendance Template'!D23=\"\",\"\",'Employee Attendance Template'!D23)","v":"Web Developer"},"May",2018,{"$f":"IF(A23=\"\",0,'Employee Attendance Template'!AN23)","v":27},{"$f":"IF(A23=\"\",0,'Employee Attendance Template'!AL23)","v":2},{"$f":"IF(A23=\"\",0,'Employee Attendance Template'!AK23)","v":1},27,10000,10000,5000,1000,2500,500,500,1000,null,0,0,10000,2000,0,11000,720,null,null,null,720,10280,"Male","Mr","Managing Director","Yes","Yes",1000,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B24=\"\",\"\",'Employee Attendance Template'!B24)","v":"Sharafali P"},{"$f":"IF('Employee Attendance Template'!D24=\"\",\"\",'Employee Attendance Template'!D24)","v":"Ux/Ui Designer"},"May",2018,{"$f":"IF(A24=\"\",0,'Employee Attendance Template'!AN24)","v":27},{"$f":"IF(A24=\"\",0,'Employee Attendance Template'!AL24)","v":2},{"$f":"IF(A24=\"\",0,'Employee Attendance Template'!AK24)","v":1},27,14000,14000,7000,1400,3500,700,700,1250,null,150,150,13850,0,0,12750,1010,null,null,null,1010,11740,"Male","Mr","Managing Director","Yes","Yes",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B25=\"\",\"\",'Employee Attendance Template'!B25)","v":""},{"$f":"IF('Employee Attendance Template'!D25=\"\",\"\",'Employee Attendance Template'!D25)","v":""},null,null,{"$f":"IF(A25=\"\",0,'Employee Attendance Template'!AN25)","v":0},{"$f":"IF(A25=\"\",0,'Employee Attendance Template'!AL25)","v":0},{"$f":"IF(A25=\"\",0,'Employee Attendance Template'!AK25)","v":0},{"$f":"IF(G25>=F25,E25-G25+F25,E25)","v":0},null,{"$f":"IF(H25=0,\"\",ROUND(I25/E25*H25,-1))","v":""},{"$f":"IF(H25=0,\"\",ROUND($J25/E25*H25*50%,-1))","v":""},{"$f":"IF(H25=0,\"\",ROUND(J25/E25*H25*10%,-1))","v":""},{"$f":"IF(H25=0,\"\",ROUND(J25/E25*H25*25%,-1))","v":""},0,null,{"$f":"MIN(1250,IF(AH25=\"Yes\",IF(H25=0,\"\",AI25),0))","v":0},null,{"$f":"IF(H25=0,\"\",ROUND(J25-T25,-1))","v":""},{"$f":"IF(R25<=0,0,R25)","v":""},{"$f":"IF(H25=0,\"\",SUM(K25:M25)+O25+P25)","v":""},0,0,{"$f":"IF(H25=0,\"\",SUM(K25:M25)+O25+Q25+S25+U25+V25)","v":""},{"$f":"ROUND(MIN(1800,IF(AG25=\"Yes\",SUM(K25:L25)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X25:AA25)","v":0},{"$f":"IFERROR(W25-AB25,\"\")","v":""},"Male",{"$f":"IF(AD25=0,\"\",IF(AD25=\"Male\",\"Mr\",IF(AD25=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A25=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B26=\"\",\"\",'Employee Attendance Template'!B26)","v":""},{"$f":"IF('Employee Attendance Template'!D26=\"\",\"\",'Employee Attendance Template'!D26)","v":""},null,null,{"$f":"IF(A26=\"\",0,'Employee Attendance Template'!AN26)","v":0},{"$f":"IF(A26=\"\",0,'Employee Attendance Template'!AL26)","v":0},{"$f":"IF(A26=\"\",0,'Employee Attendance Template'!AK26)","v":0},{"$f":"IF(G26>=F26,E26-G26+F26,E26)","v":0},null,{"$f":"IF(H26=0,\"\",ROUND(I26/E26*H26,-1))","v":""},{"$f":"IF(H26=0,\"\",ROUND($J26/E26*H26*50%,-1))","v":""},{"$f":"IF(H26=0,\"\",ROUND(J26/E26*H26*10%,-1))","v":""},{"$f":"IF(H26=0,\"\",ROUND(J26/E26*H26*25%,-1))","v":""},0,{"$f":"IF(H26=0,\"\",ROUND(N26/E26*H26,-1))","v":""},{"$f":"MIN(1250,IF(AH26=\"Yes\",IF(H26=0,\"\",AI26),0))","v":0},null,{"$f":"IF(H26=0,\"\",ROUND(J26-T26,-1))","v":""},{"$f":"IF(R26<=0,0,R26)","v":""},{"$f":"IF(H26=0,\"\",SUM(K26:M26)+O26+P26)","v":""},0,0,{"$f":"IF(H26=0,\"\",SUM(K26:M26)+O26+Q26+S26+U26+V26)","v":""},{"$f":"ROUND(MIN(1800,IF(AG26=\"Yes\",SUM(K26:L26)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X26:AA26)","v":0},{"$f":"IFERROR(W26-AB26,\"\")","v":""},"Male",{"$f":"IF(AD26=0,\"\",IF(AD26=\"Male\",\"Mr\",IF(AD26=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A26=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B27=\"\",\"\",'Employee Attendance Template'!B27)","v":""},{"$f":"IF('Employee Attendance Template'!D27=\"\",\"\",'Employee Attendance Template'!D27)","v":""},null,null,{"$f":"IF(A27=\"\",0,'Employee Attendance Template'!AN27)","v":0},{"$f":"IF(A27=\"\",0,'Employee Attendance Template'!AL27)","v":0},{"$f":"IF(A27=\"\",0,'Employee Attendance Template'!AK27)","v":0},{"$f":"IF(G27>=F27,E27-G27+F27,E27)","v":0},null,{"$f":"IF(H27=0,\"\",ROUND(I27/E27*H27,-1))","v":""},{"$f":"IF(H27=0,\"\",ROUND($J27/E27*H27*50%,-1))","v":""},{"$f":"IF(H27=0,\"\",ROUND(J27/E27*H27*10%,-1))","v":""},{"$f":"IF(H27=0,\"\",ROUND(J27/E27*H27*25%,-1))","v":""},0,{"$f":"IF(H27=0,\"\",ROUND(N27/E27*H27,-1))","v":""},{"$f":"MIN(1250,IF(AH27=\"Yes\",IF(H27=0,\"\",AI27),0))","v":0},null,{"$f":"IF(H27=0,\"\",ROUND(J27-T27,-1))","v":""},{"$f":"IF(R27<=0,0,R27)","v":""},{"$f":"IF(H27=0,\"\",SUM(K27:M27)+O27+P27)","v":""},0,0,{"$f":"IF(H27=0,\"\",SUM(K27:M27)+O27+Q27+S27+U27+V27)","v":""},{"$f":"ROUND(MIN(1800,IF(AG27=\"Yes\",SUM(K27:L27)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X27:AA27)","v":0},{"$f":"IFERROR(W27-AB27,\"\")","v":""},"Male",{"$f":"IF(AD27=0,\"\",IF(AD27=\"Male\",\"Mr\",IF(AD27=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A27=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B28=\"\",\"\",'Employee Attendance Template'!B28)","v":""},{"$f":"IF('Employee Attendance Template'!D28=\"\",\"\",'Employee Attendance Template'!D28)","v":""},null,null,{"$f":"IF(A28=\"\",0,'Employee Attendance Template'!AN28)","v":0},{"$f":"IF(A28=\"\",0,'Employee Attendance Template'!AL28)","v":0},{"$f":"IF(A28=\"\",0,'Employee Attendance Template'!AK28)","v":0},{"$f":"IF(G28>=F28,E28-G28+F28,E28)","v":0},null,{"$f":"IF(H28=0,\"\",ROUND(I28/E28*H28,-1))","v":""},{"$f":"IF(H28=0,\"\",ROUND($J28/E28*H28*50%,-1))","v":""},{"$f":"IF(H28=0,\"\",ROUND(J28/E28*H28*10%,-1))","v":""},{"$f":"IF(H28=0,\"\",ROUND(J28/E28*H28*25%,-1))","v":""},0,{"$f":"IF(H28=0,\"\",ROUND(N28/E28*H28,-1))","v":""},{"$f":"MIN(1250,IF(AH28=\"Yes\",IF(H28=0,\"\",AI28),0))","v":0},null,{"$f":"IF(H28=0,\"\",ROUND(J28-T28,-1))","v":""},{"$f":"IF(R28<=0,0,R28)","v":""},{"$f":"IF(H28=0,\"\",SUM(K28:M28)+O28+P28)","v":""},0,0,{"$f":"IF(H28=0,\"\",SUM(K28:M28)+O28+Q28+S28+U28+V28)","v":""},{"$f":"ROUND(MIN(1800,IF(AG28=\"Yes\",SUM(K28:L28)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X28:AA28)","v":0},{"$f":"IFERROR(W28-AB28,\"\")","v":""},"Male",{"$f":"IF(AD28=0,\"\",IF(AD28=\"Male\",\"Mr\",IF(AD28=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A28=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B29=\"\",\"\",'Employee Attendance Template'!B29)","v":""},{"$f":"IF('Employee Attendance Template'!D29=\"\",\"\",'Employee Attendance Template'!D29)","v":""},null,null,{"$f":"IF(A29=\"\",0,'Employee Attendance Template'!AN29)","v":0},{"$f":"IF(A29=\"\",0,'Employee Attendance Template'!AL29)","v":0},{"$f":"IF(A29=\"\",0,'Employee Attendance Template'!AK29)","v":0},{"$f":"IF(G29>=F29,E29-G29+F29,E29)","v":0},null,{"$f":"IF(H29=0,\"\",ROUND(I29/E29*H29,-1))","v":""},{"$f":"IF(H29=0,\"\",ROUND($J29/E29*H29*50%,-1))","v":""},{"$f":"IF(H29=0,\"\",ROUND(J29/E29*H29*10%,-1))","v":""},{"$f":"IF(H29=0,\"\",ROUND(J29/E29*H29*25%,-1))","v":""},0,{"$f":"IF(H29=0,\"\",ROUND(N29/E29*H29,-1))","v":""},{"$f":"MIN(1250,IF(AH29=\"Yes\",IF(H29=0,\"\",AI29),0))","v":0},null,{"$f":"IF(H29=0,\"\",ROUND(J29-T29,-1))","v":""},{"$f":"IF(R29<=0,0,R29)","v":""},{"$f":"IF(H29=0,\"\",SUM(K29:M29)+O29+P29)","v":""},0,0,{"$f":"IF(H29=0,\"\",SUM(K29:M29)+O29+Q29+S29+U29+V29)","v":""},{"$f":"ROUND(MIN(1800,IF(AG29=\"Yes\",SUM(K29:L29)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X29:AA29)","v":0},{"$f":"IFERROR(W29-AB29,\"\")","v":""},"Male",{"$f":"IF(AD29=0,\"\",IF(AD29=\"Male\",\"Mr\",IF(AD29=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A29=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B30=\"\",\"\",'Employee Attendance Template'!B30)","v":""},{"$f":"IF('Employee Attendance Template'!D30=\"\",\"\",'Employee Attendance Template'!D30)","v":""},null,null,{"$f":"IF(A30=\"\",0,'Employee Attendance Template'!AN30)","v":0},{"$f":"IF(A30=\"\",0,'Employee Attendance Template'!AL30)","v":0},{"$f":"IF(A30=\"\",0,'Employee Attendance Template'!AK30)","v":0},{"$f":"IF(G30>=F30,E30-G30+F30,E30)","v":0},null,{"$f":"IF(H30=0,\"\",ROUND(I30/E30*H30,-1))","v":""},{"$f":"IF(H30=0,\"\",ROUND($J30/E30*H30*50%,-1))","v":""},{"$f":"IF(H30=0,\"\",ROUND(J30/E30*H30*10%,-1))","v":""},{"$f":"IF(H30=0,\"\",ROUND(J30/E30*H30*25%,-1))","v":""},0,{"$f":"IF(H30=0,\"\",ROUND(N30/E30*H30,-1))","v":""},{"$f":"MIN(1250,IF(AH30=\"Yes\",IF(H30=0,\"\",AI30),0))","v":0},null,{"$f":"IF(H30=0,\"\",ROUND(J30-T30,-1))","v":""},{"$f":"IF(R30<=0,0,R30)","v":""},{"$f":"IF(H30=0,\"\",SUM(K30:M30)+O30+P30)","v":""},0,0,{"$f":"IF(H30=0,\"\",SUM(K30:M30)+O30+Q30+S30+U30+V30)","v":""},{"$f":"ROUND(MIN(1800,IF(AG30=\"Yes\",SUM(K30:L30)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X30:AA30)","v":0},{"$f":"IFERROR(W30-AB30,\"\")","v":""},"Male",{"$f":"IF(AD30=0,\"\",IF(AD30=\"Male\",\"Mr\",IF(AD30=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A30=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B31=\"\",\"\",'Employee Attendance Template'!B31)","v":""},{"$f":"IF('Employee Attendance Template'!D31=\"\",\"\",'Employee Attendance Template'!D31)","v":""},null,null,{"$f":"IF(A31=\"\",0,'Employee Attendance Template'!AN31)","v":0},{"$f":"IF(A31=\"\",0,'Employee Attendance Template'!AL31)","v":0},{"$f":"IF(A31=\"\",0,'Employee Attendance Template'!AK31)","v":0},{"$f":"IF(G31>=F31,E31-G31+F31,E31)","v":0},null,{"$f":"IF(H31=0,\"\",ROUND(I31/E31*H31,-1))","v":""},{"$f":"IF(H31=0,\"\",ROUND($J31/E31*H31*50%,-1))","v":""},{"$f":"IF(H31=0,\"\",ROUND(J31/E31*H31*10%,-1))","v":""},{"$f":"IF(H31=0,\"\",ROUND(J31/E31*H31*25%,-1))","v":""},0,{"$f":"IF(H31=0,\"\",ROUND(N31/E31*H31,-1))","v":""},{"$f":"MIN(1250,IF(AH31=\"Yes\",IF(H31=0,\"\",AI31),0))","v":0},null,{"$f":"IF(H31=0,\"\",ROUND(J31-T31,-1))","v":""},{"$f":"IF(R31<=0,0,R31)","v":""},{"$f":"IF(H31=0,\"\",SUM(K31:M31)+O31+P31)","v":""},0,0,{"$f":"IF(H31=0,\"\",SUM(K31:M31)+O31+Q31+S31+U31+V31)","v":""},{"$f":"ROUND(MIN(1800,IF(AG31=\"Yes\",SUM(K31:L31)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X31:AA31)","v":0},{"$f":"IFERROR(W31-AB31,\"\")","v":""},"Male",{"$f":"IF(AD31=0,\"\",IF(AD31=\"Male\",\"Mr\",IF(AD31=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A31=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B32=\"\",\"\",'Employee Attendance Template'!B32)","v":""},{"$f":"IF('Employee Attendance Template'!D32=\"\",\"\",'Employee Attendance Template'!D32)","v":""},null,null,{"$f":"IF(A32=\"\",0,'Employee Attendance Template'!AN32)","v":0},{"$f":"IF(A32=\"\",0,'Employee Attendance Template'!AL32)","v":0},{"$f":"IF(A32=\"\",0,'Employee Attendance Template'!AK32)","v":0},{"$f":"IF(G32>=F32,E32-G32+F32,E32)","v":0},null,{"$f":"IF(H32=0,\"\",ROUND(I32/E32*H32,-1))","v":""},{"$f":"IF(H32=0,\"\",ROUND($J32/E32*H32*50%,-1))","v":""},{"$f":"IF(H32=0,\"\",ROUND(J32/E32*H32*10%,-1))","v":""},{"$f":"IF(H32=0,\"\",ROUND(J32/E32*H32*25%,-1))","v":""},0,{"$f":"IF(H32=0,\"\",ROUND(N32/E32*H32,-1))","v":""},{"$f":"MIN(1250,IF(AH32=\"Yes\",IF(H32=0,\"\",AI32),0))","v":0},null,{"$f":"IF(H32=0,\"\",ROUND(J32-T32,-1))","v":""},{"$f":"IF(R32<=0,0,R32)","v":""},{"$f":"IF(H32=0,\"\",SUM(K32:M32)+O32+P32)","v":""},0,0,{"$f":"IF(H32=0,\"\",SUM(K32:M32)+O32+Q32+S32+U32+V32)","v":""},{"$f":"ROUND(MIN(1800,IF(AG32=\"Yes\",SUM(K32:L32)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X32:AA32)","v":0},{"$f":"IFERROR(W32-AB32,\"\")","v":""},"Male",{"$f":"IF(AD32=0,\"\",IF(AD32=\"Male\",\"Mr\",IF(AD32=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A32=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B33=\"\",\"\",'Employee Attendance Template'!B33)","v":""},{"$f":"IF('Employee Attendance Template'!D33=\"\",\"\",'Employee Attendance Template'!D33)","v":""},null,null,{"$f":"IF(A33=\"\",0,'Employee Attendance Template'!AN33)","v":0},{"$f":"IF(A33=\"\",0,'Employee Attendance Template'!AL33)","v":0},{"$f":"IF(A33=\"\",0,'Employee Attendance Template'!AK33)","v":0},{"$f":"IF(G33>=F33,E33-G33+F33,E33)","v":0},null,{"$f":"IF(H33=0,\"\",ROUND(I33/E33*H33,-1))","v":""},{"$f":"IF(H33=0,\"\",ROUND($J33/E33*H33*50%,-1))","v":""},{"$f":"IF(H33=0,\"\",ROUND(J33/E33*H33*10%,-1))","v":""},{"$f":"IF(H33=0,\"\",ROUND(J33/E33*H33*25%,-1))","v":""},0,{"$f":"IF(H33=0,\"\",ROUND(N33/E33*H33,-1))","v":""},{"$f":"MIN(1250,IF(AH33=\"Yes\",IF(H33=0,\"\",AI33),0))","v":0},null,{"$f":"IF(H33=0,\"\",ROUND(J33-T33,-1))","v":""},{"$f":"IF(R33<=0,0,R33)","v":""},{"$f":"IF(H33=0,\"\",SUM(K33:M33)+O33+P33)","v":""},0,0,{"$f":"IF(H33=0,\"\",SUM(K33:M33)+O33+Q33+S33+U33+V33)","v":""},{"$f":"ROUND(MIN(1800,IF(AG33=\"Yes\",SUM(K33:L33)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X33:AA33)","v":0},{"$f":"IFERROR(W33-AB33,\"\")","v":""},"Male",{"$f":"IF(AD33=0,\"\",IF(AD33=\"Male\",\"Mr\",IF(AD33=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A33=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B34=\"\",\"\",'Employee Attendance Template'!B34)","v":""},{"$f":"IF('Employee Attendance Template'!D34=\"\",\"\",'Employee Attendance Template'!D34)","v":""},null,null,{"$f":"IF(A34=\"\",0,'Employee Attendance Template'!AN34)","v":0},{"$f":"IF(A34=\"\",0,'Employee Attendance Template'!AL34)","v":0},{"$f":"IF(A34=\"\",0,'Employee Attendance Template'!AK34)","v":0},{"$f":"IF(G34>=F34,E34-G34+F34,E34)","v":0},null,{"$f":"IF(H34=0,\"\",ROUND(I34/E34*H34,-1))","v":""},{"$f":"IF(H34=0,\"\",ROUND($J34/E34*H34*50%,-1))","v":""},{"$f":"IF(H34=0,\"\",ROUND(J34/E34*H34*10%,-1))","v":""},{"$f":"IF(H34=0,\"\",ROUND(J34/E34*H34*25%,-1))","v":""},0,{"$f":"IF(H34=0,\"\",ROUND(N34/E34*H34,-1))","v":""},{"$f":"MIN(1250,IF(AH34=\"Yes\",IF(H34=0,\"\",AI34),0))","v":0},null,{"$f":"IF(H34=0,\"\",ROUND(J34-T34,-1))","v":""},{"$f":"IF(R34<=0,0,R34)","v":""},{"$f":"IF(H34=0,\"\",SUM(K34:M34)+O34+P34)","v":""},0,0,{"$f":"IF(H34=0,\"\",SUM(K34:M34)+O34+Q34+S34+U34+V34)","v":""},{"$f":"ROUND(MIN(1800,IF(AG34=\"Yes\",SUM(K34:L34)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X34:AA34)","v":0},{"$f":"IFERROR(W34-AB34,\"\")","v":""},"Male",{"$f":"IF(AD34=0,\"\",IF(AD34=\"Male\",\"Mr\",IF(AD34=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A34=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B35=\"\",\"\",'Employee Attendance Template'!B35)","v":""},{"$f":"IF('Employee Attendance Template'!D35=\"\",\"\",'Employee Attendance Template'!D35)","v":""},null,null,{"$f":"IF(A35=\"\",0,'Employee Attendance Template'!AN35)","v":0},{"$f":"IF(A35=\"\",0,'Employee Attendance Template'!AL35)","v":0},{"$f":"IF(A35=\"\",0,'Employee Attendance Template'!AK35)","v":0},{"$f":"IF(G35>=F35,E35-G35+F35,E35)","v":0},null,{"$f":"IF(H35=0,\"\",ROUND(I35/E35*H35,-1))","v":""},{"$f":"IF(H35=0,\"\",ROUND($J35/E35*H35*50%,-1))","v":""},{"$f":"IF(H35=0,\"\",ROUND(J35/E35*H35*10%,-1))","v":""},{"$f":"IF(H35=0,\"\",ROUND(J35/E35*H35*25%,-1))","v":""},0,{"$f":"IF(H35=0,\"\",ROUND(N35/E35*H35,-1))","v":""},{"$f":"MIN(1250,IF(AH35=\"Yes\",IF(H35=0,\"\",AI35),0))","v":0},null,{"$f":"IF(H35=0,\"\",ROUND(J35-T35,-1))","v":""},{"$f":"IF(R35<=0,0,R35)","v":""},{"$f":"IF(H35=0,\"\",SUM(K35:M35)+O35+P35)","v":""},0,0,{"$f":"IF(H35=0,\"\",SUM(K35:M35)+O35+Q35+S35+U35+V35)","v":""},{"$f":"ROUND(MIN(1800,IF(AG35=\"Yes\",SUM(K35:L35)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X35:AA35)","v":0},{"$f":"IFERROR(W35-AB35,\"\")","v":""},"Male",{"$f":"IF(AD35=0,\"\",IF(AD35=\"Male\",\"Mr\",IF(AD35=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A35=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B36=\"\",\"\",'Employee Attendance Template'!B36)","v":""},{"$f":"IF('Employee Attendance Template'!D36=\"\",\"\",'Employee Attendance Template'!D36)","v":""},null,null,{"$f":"IF(A36=\"\",0,'Employee Attendance Template'!AN36)","v":0},{"$f":"IF(A36=\"\",0,'Employee Attendance Template'!AL36)","v":0},{"$f":"IF(A36=\"\",0,'Employee Attendance Template'!AK36)","v":0},{"$f":"IF(G36>=F36,E36-G36+F36,E36)","v":0},null,{"$f":"IF(H36=0,\"\",ROUND(I36/E36*H36,-1))","v":""},{"$f":"IF(H36=0,\"\",ROUND($J36/E36*H36*50%,-1))","v":""},{"$f":"IF(H36=0,\"\",ROUND(J36/E36*H36*10%,-1))","v":""},{"$f":"IF(H36=0,\"\",ROUND(J36/E36*H36*25%,-1))","v":""},0,{"$f":"IF(H36=0,\"\",ROUND(N36/E36*H36,-1))","v":""},{"$f":"MIN(1250,IF(AH36=\"Yes\",IF(H36=0,\"\",AI36),0))","v":0},null,{"$f":"IF(H36=0,\"\",ROUND(J36-T36,-1))","v":""},{"$f":"IF(R36<=0,0,R36)","v":""},{"$f":"IF(H36=0,\"\",SUM(K36:M36)+O36+P36)","v":""},0,0,{"$f":"IF(H36=0,\"\",SUM(K36:M36)+O36+Q36+S36+U36+V36)","v":""},{"$f":"ROUND(MIN(1800,IF(AG36=\"Yes\",SUM(K36:L36)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X36:AA36)","v":0},{"$f":"IFERROR(W36-AB36,\"\")","v":""},"Male",{"$f":"IF(AD36=0,\"\",IF(AD36=\"Male\",\"Mr\",IF(AD36=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A36=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B37=\"\",\"\",'Employee Attendance Template'!B37)","v":""},{"$f":"IF('Employee Attendance Template'!D37=\"\",\"\",'Employee Attendance Template'!D37)","v":""},null,null,{"$f":"IF(A37=\"\",0,'Employee Attendance Template'!AN37)","v":0},{"$f":"IF(A37=\"\",0,'Employee Attendance Template'!AL37)","v":0},{"$f":"IF(A37=\"\",0,'Employee Attendance Template'!AK37)","v":0},{"$f":"IF(G37>=F37,E37-G37+F37,E37)","v":0},null,{"$f":"IF(H37=0,\"\",ROUND(I37/E37*H37,-1))","v":""},{"$f":"IF(H37=0,\"\",ROUND($J37/E37*H37*50%,-1))","v":""},{"$f":"IF(H37=0,\"\",ROUND(J37/E37*H37*10%,-1))","v":""},{"$f":"IF(H37=0,\"\",ROUND(J37/E37*H37*25%,-1))","v":""},0,{"$f":"IF(H37=0,\"\",ROUND(N37/E37*H37,-1))","v":""},{"$f":"MIN(1250,IF(AH37=\"Yes\",IF(H37=0,\"\",AI37),0))","v":0},null,{"$f":"IF(H37=0,\"\",ROUND(J37-T37,-1))","v":""},{"$f":"IF(R37<=0,0,R37)","v":""},{"$f":"IF(H37=0,\"\",SUM(K37:M37)+O37+P37)","v":""},0,0,{"$f":"IF(H37=0,\"\",SUM(K37:M37)+O37+Q37+S37+U37+V37)","v":""},{"$f":"ROUND(MIN(1800,IF(AG37=\"Yes\",SUM(K37:L37)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X37:AA37)","v":0},{"$f":"IFERROR(W37-AB37,\"\")","v":""},"Male",{"$f":"IF(AD37=0,\"\",IF(AD37=\"Male\",\"Mr\",IF(AD37=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A37=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B38=\"\",\"\",'Employee Attendance Template'!B38)","v":""},{"$f":"IF('Employee Attendance Template'!D38=\"\",\"\",'Employee Attendance Template'!D38)","v":""},null,null,{"$f":"IF(A38=\"\",0,'Employee Attendance Template'!AN38)","v":0},{"$f":"IF(A38=\"\",0,'Employee Attendance Template'!AL38)","v":0},{"$f":"IF(A38=\"\",0,'Employee Attendance Template'!AK38)","v":0},{"$f":"IF(G38>=F38,E38-G38+F38,E38)","v":0},null,{"$f":"IF(H38=0,\"\",ROUND(I38/E38*H38,-1))","v":""},{"$f":"IF(H38=0,\"\",ROUND($J38/E38*H38*50%,-1))","v":""},{"$f":"IF(H38=0,\"\",ROUND(J38/E38*H38*10%,-1))","v":""},{"$f":"IF(H38=0,\"\",ROUND(J38/E38*H38*25%,-1))","v":""},0,{"$f":"IF(H38=0,\"\",ROUND(N38/E38*H38,-1))","v":""},{"$f":"MIN(1250,IF(AH38=\"Yes\",IF(H38=0,\"\",AI38),0))","v":0},null,{"$f":"IF(H38=0,\"\",ROUND(J38-T38,-1))","v":""},{"$f":"IF(R38<=0,0,R38)","v":""},{"$f":"IF(H38=0,\"\",SUM(K38:M38)+O38+P38)","v":""},0,0,{"$f":"IF(H38=0,\"\",SUM(K38:M38)+O38+Q38+S38+U38+V38)","v":""},{"$f":"ROUND(MIN(1800,IF(AG38=\"Yes\",SUM(K38:L38)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X38:AA38)","v":0},{"$f":"IFERROR(W38-AB38,\"\")","v":""},"Male",{"$f":"IF(AD38=0,\"\",IF(AD38=\"Male\",\"Mr\",IF(AD38=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A38=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B39=\"\",\"\",'Employee Attendance Template'!B39)","v":""},{"$f":"IF('Employee Attendance Template'!D39=\"\",\"\",'Employee Attendance Template'!D39)","v":""},null,null,{"$f":"IF(A39=\"\",0,'Employee Attendance Template'!AN39)","v":0},{"$f":"IF(A39=\"\",0,'Employee Attendance Template'!AL39)","v":0},{"$f":"IF(A39=\"\",0,'Employee Attendance Template'!AK39)","v":0},{"$f":"IF(G39>=F39,E39-G39+F39,E39)","v":0},null,{"$f":"IF(H39=0,\"\",ROUND(I39/E39*H39,-1))","v":""},{"$f":"IF(H39=0,\"\",ROUND($J39/E39*H39*50%,-1))","v":""},{"$f":"IF(H39=0,\"\",ROUND(J39/E39*H39*10%,-1))","v":""},{"$f":"IF(H39=0,\"\",ROUND(J39/E39*H39*25%,-1))","v":""},0,{"$f":"IF(H39=0,\"\",ROUND(N39/E39*H39,-1))","v":""},{"$f":"MIN(1250,IF(AH39=\"Yes\",IF(H39=0,\"\",AI39),0))","v":0},null,{"$f":"IF(H39=0,\"\",ROUND(J39-T39,-1))","v":""},{"$f":"IF(R39<=0,0,R39)","v":""},{"$f":"IF(H39=0,\"\",SUM(K39:M39)+O39+P39)","v":""},0,0,{"$f":"IF(H39=0,\"\",SUM(K39:M39)+O39+Q39+S39+U39+V39)","v":""},{"$f":"ROUND(MIN(1800,IF(AG39=\"Yes\",SUM(K39:L39)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X39:AA39)","v":0},{"$f":"IFERROR(W39-AB39,\"\")","v":""},"Male",{"$f":"IF(AD39=0,\"\",IF(AD39=\"Male\",\"Mr\",IF(AD39=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A39=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B40=\"\",\"\",'Employee Attendance Template'!B40)","v":""},{"$f":"IF('Employee Attendance Template'!D40=\"\",\"\",'Employee Attendance Template'!D40)","v":""},null,null,{"$f":"IF(A40=\"\",0,'Employee Attendance Template'!AN40)","v":0},{"$f":"IF(A40=\"\",0,'Employee Attendance Template'!AL40)","v":0},{"$f":"IF(A40=\"\",0,'Employee Attendance Template'!AK40)","v":0},{"$f":"IF(G40>=F40,E40-G40+F40,E40)","v":0},null,{"$f":"IF(H40=0,\"\",ROUND(I40/E40*H40,-1))","v":""},{"$f":"IF(H40=0,\"\",ROUND($J40/E40*H40*50%,-1))","v":""},{"$f":"IF(H40=0,\"\",ROUND(J40/E40*H40*10%,-1))","v":""},{"$f":"IF(H40=0,\"\",ROUND(J40/E40*H40*25%,-1))","v":""},0,{"$f":"IF(H40=0,\"\",ROUND(N40/E40*H40,-1))","v":""},{"$f":"MIN(1250,IF(AH40=\"Yes\",IF(H40=0,\"\",AI40),0))","v":0},null,{"$f":"IF(H40=0,\"\",ROUND(J40-T40,-1))","v":""},{"$f":"IF(R40<=0,0,R40)","v":""},{"$f":"IF(H40=0,\"\",SUM(K40:M40)+O40+P40)","v":""},0,0,{"$f":"IF(H40=0,\"\",SUM(K40:M40)+O40+Q40+S40+U40+V40)","v":""},{"$f":"ROUND(MIN(1800,IF(AG40=\"Yes\",SUM(K40:L40)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X40:AA40)","v":0},{"$f":"IFERROR(W40-AB40,\"\")","v":""},"Male",{"$f":"IF(AD40=0,\"\",IF(AD40=\"Male\",\"Mr\",IF(AD40=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A40=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B41=\"\",\"\",'Employee Attendance Template'!B41)","v":""},{"$f":"IF('Employee Attendance Template'!D41=\"\",\"\",'Employee Attendance Template'!D41)","v":""},null,null,{"$f":"IF(A41=\"\",0,'Employee Attendance Template'!AN41)","v":0},{"$f":"IF(A41=\"\",0,'Employee Attendance Template'!AL41)","v":0},{"$f":"IF(A41=\"\",0,'Employee Attendance Template'!AK41)","v":0},{"$f":"IF(G41>=F41,E41-G41+F41,E41)","v":0},null,{"$f":"IF(H41=0,\"\",ROUND(I41/E41*H41,-1))","v":""},{"$f":"IF(H41=0,\"\",ROUND($J41/E41*H41*50%,-1))","v":""},{"$f":"IF(H41=0,\"\",ROUND(J41/E41*H41*10%,-1))","v":""},{"$f":"IF(H41=0,\"\",ROUND(J41/E41*H41*25%,-1))","v":""},0,{"$f":"IF(H41=0,\"\",ROUND(N41/E41*H41,-1))","v":""},{"$f":"MIN(1250,IF(AH41=\"Yes\",IF(H41=0,\"\",AI41),0))","v":0},null,{"$f":"IF(H41=0,\"\",ROUND(J41-T41,-1))","v":""},{"$f":"IF(R41<=0,0,R41)","v":""},{"$f":"IF(H41=0,\"\",SUM(K41:M41)+O41+P41)","v":""},0,0,{"$f":"IF(H41=0,\"\",SUM(K41:M41)+O41+Q41+S41+U41+V41)","v":""},{"$f":"ROUND(MIN(1800,IF(AG41=\"Yes\",SUM(K41:L41)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X41:AA41)","v":0},{"$f":"IFERROR(W41-AB41,\"\")","v":""},"Male",{"$f":"IF(AD41=0,\"\",IF(AD41=\"Male\",\"Mr\",IF(AD41=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A41=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B42=\"\",\"\",'Employee Attendance Template'!B42)","v":""},{"$f":"IF('Employee Attendance Template'!D42=\"\",\"\",'Employee Attendance Template'!D42)","v":""},null,null,{"$f":"IF(A42=\"\",0,'Employee Attendance Template'!AN42)","v":0},{"$f":"IF(A42=\"\",0,'Employee Attendance Template'!AL42)","v":0},{"$f":"IF(A42=\"\",0,'Employee Attendance Template'!AK42)","v":0},{"$f":"IF(G42>=F42,E42-G42+F42,E42)","v":0},null,{"$f":"IF(H42=0,\"\",ROUND(I42/E42*H42,-1))","v":""},{"$f":"IF(H42=0,\"\",ROUND($J42/E42*H42*50%,-1))","v":""},{"$f":"IF(H42=0,\"\",ROUND(J42/E42*H42*10%,-1))","v":""},{"$f":"IF(H42=0,\"\",ROUND(J42/E42*H42*25%,-1))","v":""},0,{"$f":"IF(H42=0,\"\",ROUND(N42/E42*H42,-1))","v":""},{"$f":"MIN(1250,IF(AH42=\"Yes\",IF(H42=0,\"\",AI42),0))","v":0},null,{"$f":"IF(H42=0,\"\",ROUND(J42-T42,-1))","v":""},{"$f":"IF(R42<=0,0,R42)","v":""},{"$f":"IF(H42=0,\"\",SUM(K42:M42)+O42+P42)","v":""},0,0,{"$f":"IF(H42=0,\"\",SUM(K42:M42)+O42+Q42+S42+U42+V42)","v":""},{"$f":"ROUND(MIN(1800,IF(AG42=\"Yes\",SUM(K42:L42)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X42:AA42)","v":0},{"$f":"IFERROR(W42-AB42,\"\")","v":""},"Male",{"$f":"IF(AD42=0,\"\",IF(AD42=\"Male\",\"Mr\",IF(AD42=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A42=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[{"$f":"IF('Employee Attendance Template'!B43=\"\",\"\",'Employee Attendance Template'!B43)","v":""},{"$f":"IF('Employee Attendance Template'!D43=\"\",\"\",'Employee Attendance Template'!D43)","v":""},null,null,{"$f":"IF(A43=\"\",0,'Employee Attendance Template'!AN43)","v":0},{"$f":"IF(A43=\"\",0,'Employee Attendance Template'!AL43)","v":0},{"$f":"IF(A43=\"\",0,'Employee Attendance Template'!AK43)","v":0},{"$f":"IF(G43>=F43,E43-G43+F43,E43)","v":0},null,{"$f":"IF(H43=0,\"\",ROUND(I43/E43*H43,-1))","v":""},{"$f":"IF(H43=0,\"\",ROUND($J43/E43*H43*50%,-1))","v":""},{"$f":"IF(H43=0,\"\",ROUND(J43/E43*H43*10%,-1))","v":""},{"$f":"IF(H43=0,\"\",ROUND(J43/E43*H43*25%,-1))","v":""},0,{"$f":"IF(H43=0,\"\",ROUND(N43/E43*H43,-1))","v":""},{"$f":"MIN(1250,IF(AH43=\"Yes\",IF(H43=0,\"\",AI43),0))","v":0},null,{"$f":"IF(H43=0,\"\",ROUND(J43-T43,-1))","v":""},{"$f":"IF(R43<=0,0,R43)","v":""},{"$f":"IF(H43=0,\"\",SUM(K43:M43)+O43+P43)","v":""},0,0,{"$f":"IF(H43=0,\"\",SUM(K43:M43)+O43+Q43+S43+U43+V43)","v":""},{"$f":"ROUND(MIN(1800,IF(AG43=\"Yes\",SUM(K43:L43)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X43:AA43)","v":0},{"$f":"IFERROR(W43-AB43,\"\")","v":""},"Male",{"$f":"IF(AD43=0,\"\",IF(AD43=\"Male\",\"Mr\",IF(AD43=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A43=0,\"\",AF$4)","v":"Managing Director"},"No","No",1400,"ABC & Company Ltd"]
[null,null,null,null,{"$f":"IF(A44=\"\",0,'Employee Attendance Template'!AN44)","v":0},{"$f":"IF(A44=\"\",0,'Employee Attendance Template'!AL44)","v":0},{"$f":"IF(A44=\"\",0,'Employee Attendance Template'!AK44)","v":0},{"$f":"IF(G44>=F44,E44-G44+F44,E44)","v":0},null,{"$f":"IF(H44=0,\"\",ROUND(I44/E44*H44,-1))","v":""},{"$f":"IF(H44=0,\"\",ROUND($J44/E44*H44*50%,-1))","v":""},{"$f":"IF(H44=0,\"\",ROUND(J44/E44*H44*10%,-1))","v":""},{"$f":"IF(H44=0,\"\",ROUND(J44/E44*H44*25%,-1))","v":""},0,{"$f":"IF(H44=0,\"\",ROUND(N44/E44*H44,-1))","v":""},{"$f":"MIN(1250,IF(AH44=\"Yes\",IF(H44=0,\"\",AI44),0))","v":0},null,{"$f":"IF(H44=0,\"\",ROUND(J44-T44,-1))","v":""},{"$f":"IF(R44<=0,0,R44)","v":""},{"$f":"IF(H44=0,\"\",SUM(K44:M44)+O44+P44)","v":""},0,0,{"$f":"IF(H44=0,\"\",SUM(K44:M44)+O44+Q44+S44+U44+V44)","v":""},{"$f":"ROUND(MIN(1800,IF(AG44=\"Yes\",SUM(K44:L44)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X44:AA44)","v":0},{"$f":"IFERROR(W44-AB44,\"\")","v":""},"Male",{"$f":"IF(AD44=0,\"\",IF(AD44=\"Male\",\"Mr\",IF(AD44=\"Female\",\"Mrs\")))","v":"Mr"},{"$f":"IF(A44=0,\"\",AF$4)","v":""},"No","No",1400,"ABC & Company Ltd"]
[null,null,{"$f":"IF(A45=0,\"\",C$4)","v":""},{"$f":"IF(A45=0,\"\",D$4)","v":""},null,null,null,{"$f":"IF(G45>=F45,E45-G45+F45,E45)","v":0},null,{"$f":"IF(H45=0,\"\",ROUND(I45/E45*H45,-1))","v":""},{"$f":"IF(H45=0,\"\",ROUND($J45/E45*H45*50%,-1))","v":""},{"$f":"IF(H45=0,\"\",ROUND(J45/E45*H45*10%,-1))","v":""},{"$f":"IF(H45=0,\"\",ROUND(J45/E45*H45*25%,-1))","v":""},{"$f":"IF(H45=0,\"\",1600)","v":""},{"$f":"IF(H45=0,\"\",ROUND(N45/E45*H45,-1))","v":""},{"$f":"MIN(1250,IF(AH45=\"Yes\",IF(H45=0,\"\",AI45),0))","v":0},null,{"$f":"IF(H45=0,\"\",ROUND(J45-T45,-1))","v":""},{"$f":"IF(R45<=0,0,R45)","v":""},{"$f":"IF(H45=0,\"\",SUM(K45:M45)+O45+P45)","v":""},null,null,{"$f":"IF(H45=0,\"\",SUM(K45:M45)+O45+Q45+S45+U45+V45)","v":""},{"$f":"ROUND(MIN(1800,IF(AG45=\"Yes\",SUM(K45:L45)*12%,0)),-1)","v":0},null,null,null,{"$f":"SUM(X45:AA45)","v":0},{"$f":"IFERROR(W45-AB45,\"\")","v":""},null,{"$f":"IF(AD45=0,\"\",IF(AD45=\"Male\",\"Mr\",IF(AD45=\"Female\",\"Mrs\")))","v":""},{"$f":"IF(A45=0,\"\",AF$4)","v":""}]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"",""]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"",""]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"",""]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"",""]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"",""]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"",""]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"",""]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"",""]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"",""]

{"sheet":"Consolidation","index":2,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[27,1,27,11],[26,17,27,17],[28,12,28,17],[29,12,30,14],[31,12,32,14],[29,15,32,17],[0,0,0,15],[0,16,1,17],[28,0,32,11],[26,0,26,14],[2,0,2,17],[3,3,3,10],[3,2,4,2],[3,1,4,1],[3,0,4,0],[3,11,4,11],[3,12,3,16],[3,17,4,17],[1,0,1,15],[26,15,27,16]]}
["www.ExcelDataPro.com"]
[{"$f":"'Salary Slip'!B1","v":"ABC & Company Ltd"}]
[{"$f":"CONCATENATE(\"Consolidated Salary Sheet for the month of \"&\" \"&Database!C4&\" \", Database!D4)","v":"Consolidated Salary Sheet for the month of  May 2018"}]
["Sl No","Name of Employee","CTC",{"$f":"Database!J2","v":"TOTAL GROSS SALARY"},null,null,null,null,null,null,null,{"$f":"Database!W3","v":"TOTAL"},{"$f":"Database!X2","v":"TOTAL DEDUCTIONS"},null,null,null,null,{"$f":"Database!AC3","v":"NET PAYABLE"}]
[null,null,null,{"$f":"Database!K3","v":"Basic Salary"},{"$f":"Database!L3","v":"DA"},{"$f":"Database!M3","v":"HRA"},{"$f":"Database!N3","v":"Conveyance"},{"$f":"Database!P3","v":"Medical Expenses"},{"$f":"Database!S3","v":"Special"},{"$f":"Database!U3","v":"Bonus"},{"$f":"Database!V3","v":"TA"},null,{"$f":"Database!X3","v":"Contribution to PF"},{"$f":"Database!Y3","v":"Profession Tax"},{"$f":"Database!Z3","v":"TDS"},{"$f":"Database!AA3","v":"Salary Advance"},{"$f":"Database!AB3","v":"TOTAL"}]
[1,{"$f":"Database!A4","v":"Raj Sharma"},{"$f":"Database!I4","v":60000},{"$f":"Database!K4","v":23700},{"$f":"Database!L4","v":4740},{"$f":"Database!M4","v":11850},{"$f":"Database!O4","v":1420},{"$f":"Database!P4","v":1250},{"$f":"Database!S4","v":10370},{"$f":"Database!U4","v":13100},{"$f":"Database!V4","v":0},{"$f":"SUM(D6:K6)","v":66430},{"$f":"Database!X4","v":1800},{"$f":"Database!Y4","v":0},{"$f":"Database!Z4","v":7000},{"$f":"Database!AA4","v":0},{"$f":"SUM(M6:P6)","v":8800},{"$f":"L6-Q6","v":57630}]
[{"$f":"IF(C7>0,A6+1,\"\")","v":2},{"$f":"Database!A5","v":"Sharad Gandhi"},{"$f":"Database!I5","v":30000},{"$f":"Database!K5","v":13910},{"$f":"Database!L5","v":2780},{"$f":"Database!M5","v":6960},{"$f":"Database!O5","v":1540},{"$f":"Database!P5","v":1250},{"$f":"Database!S5","v":2450},{"$f":"Database!U5","v":2300},{"$f":"Database!V5","v":0},31190,{"$f":"Database!X5","v":1800},{"$f":"Database!Y5","v":0},{"$f":"Database!Z5","v":500},{"$f":"Database!AA5","v":0},2300,28890]
[3,{"$f":"Database!A6","v":"Danish D'Souza"},{"$f":"Database!I6","v":20000},{"$f":"Database!K6","v":10000},{"$f":"Database!L6","v":2000},{"$f":"Database!M6","v":5000},{"$f":"Database!O6","v":1000},{"$f":"Database!P6","v":1250},{"$f":"Database!S6","v":750},{"$f":"Database!U6","v":0},{"$f":"Database!V6","v":0},20000,{"$f":"Database!X6","v":1440},{"$f":"Database!Y6","v":0},{"$f":"Database!Z6","v":0},{"$f":"Database!AA6","v":0},1440,18560]
[4,{"$f":"Database!A7","v":"Pawan Patil"},{"$f":"Database!I7","v":25000},{"$f":"Database!K7","v":12500},{"$f":"Database!L7","v":2500},{"$f":"Database!M7","v":6250},{"$f":"Database!O7","v":1600},{"$f":"Database!P7","v":1250},{"$f":"Database!S7","v":900},{"$f":"Database!U7","v":0},{"$f":"Database!V7","v":0},25000,{"$f":"Database!X7","v":1800},{"$f":"Database!Y7","v":0},{"$f":"Database!Z7","v":0},{"$f":"Database!AA7","v":0},1800,23200]
[5,{"$f":"Database!A8","v":"Rijo Paul"},{"$f":"Database!I8","v":22000},{"$f":"Database!K8","v":11000},{"$f":"Database!L8","v":2200},{"$f":"Database!M8","v":5500},{"$f":"Database!O8","v":1100},{"$f":"Database!P8","v":1250},{"$f":"Database!S8","v":950},{"$f":"Database!U8","v":2300},{"$f":"Database!V8","v":0},24300,{"$f":"Database!X8","v":1580},{"$f":"Database!Y8","v":0},{"$f":"Database!Z8","v":0},{"$f":"Database!AA8","v":0},1580,22720]
[6,{"$f":"Database!A9","v":"Joseph P"},{"$f":"Database!I9","v":14000},{"$f":"Database!K9","v":7000},{"$f":"Database!L9","v":1400},{"$f":"Database!M9","v":3500},{"$f":"Database!O9","v":700},{"$f":"Database!P9","v":1250},{"$f":"Database!S9","v":150},{"$f":"Database!U9","v":2300},{"$f":"Database!V9","v":0},16300,{"$f":"Database!X9","v":1010},{"$f":"Database!Y9","v":0},{"$f":"Database!Z9","v":0},{"$f":"Database!AA9","v":0},1010,15290]
[7,{"$f":"Database!A10","v":"Aakash Patel"},{"$f":"Database!I10","v":15000},{"$f":"Database!K10","v":7500},{"$f":"Database!L10","v":1500},{"$f":"Database!M10","v":3750},{"$f":"Database!O10","v":600},{"$f":"Database!P10","v":1200},{"$f":"Database!S10","v":450},{"$f":"Database!U10","v":0},{"$f":"Database!V10","v":0},15000,{"$f":"Database!X10","v":1080},{"$f":"Database!Y10","v":0},{"$f":"Database!Z10","v":0},{"$f":"Database!AA10","v":0},1080,13920]
[8,{"$f":"Database!A11","v":"Ganesh Rahu"},{"$f":"Database!I11","v":14000},{"$f":"Database!K11","v":7000},{"$f":"Database!L11","v":1400},{"$f":"Database!M11","v":3500},{"$f":"Database!O11","v":600},{"$f":"Database!P11","v":1200},{"$f":"Database!S11","v":300},{"$f":"Database!U11","v":0},{"$f":"Database!V11","v":0},14000,{"$f":"Database!X11","v":1010},{"$f":"Database!Y11","v":0},{"$f":"Database!Z11","v":0},{"$f":"Database!AA11","v":0},1010,12990]
[9,{"$f":"Database!A12","v":"Vinudas K.S"},{"$f":"Database!I12","v":14000},{"$f":"Database!K12","v":7000},{"$f":"Database!L12","v":1400},{"$f":"Database!M12","v":3500},{"$f":"Database!O12","v":700},{"$f":"Database!P12","v":1250},{"$f":"Database!S12","v":150},{"$f":"Database!U12","v":1500},{"$f":"Database!V12","v":0},15500,{"$f":"Database!X12","v":1010},{"$f":"Database!Y12","v":0},{"$f":"Database!Z12","v":0},{"$f":"Database!AA12","v":0},1010,14490]
[10,{"$f":"Database!A13","v":"Divya Kumar"},{"$f":"Database!I13","v":8000},{"$f":"Database!K13","v":4000},{"$f":"Database!L13","v":800},{"$f":"Database!M13","v":2000},{"$f":"Database!O13","v":400},{"$f":"Database!P13","v":800},{"$f":"Database!S13","v":0},{"$f":"Database!U13","v":0},{"$f":"Database!V13","v":0},8000,{"$f":"Database!X13","v":580},{"$f":"Database!Y13","v":0},{"$f":"Database!Z13","v":0},{"$f":"Database!AA13","v":0},580,7420]
[11,{"$f":"Database!A14","v":"Shilpa R"},{"$f":"Database!I14","v":8000},{"$f":"Database!K14","v":4000},{"$f":"Database!L14","v":800},{"$f":"Database!M14","v":2000},{"$f":"Database!O14","v":390},{"$f":"Database!P14","v":774},{"$f":"Database!S14","v":40},{"$f":"Database!U14","v":0},{"$f":"Database!V14","v":0},8004,{"$f":"Database!X14","v":580},{"$f":"Database!Y14","v":0},{"$f":"Database!Z14","v":0},{"$f":"Database!AA14","v":0},580,7424]
[12,{"$f":"Database!A15","v":"Sindhu J.P"},{"$f":"Database!I15","v":8000},{"$f":"Database!K15","v":4000},{"$f":"Database!L15","v":800},{"$f":"Database!M15","v":2000},{"$f":"Database!O15","v":400},{"$f":"Database!P15","v":800},{"$f":"Database!S15","v":0},{"$f":"Database!U15","v":0},{"$f":"Database!V15","v":0},8000,{"$f":"Database!X15","v":580},{"$f":"Database!Y15","v":0},{"$f":"Database!Z15","v":0},{"$f":"Database!AA15","v":0},580,7420]
[13,{"$f":"Database!A16","v":"Deepthi P.S"},{"$f":"Database!I16","v":8000},{"$f":"Database!K16","v":4000},{"$f":"Database!L16","v":800},{"$f":"Database!M16","v":2000},{"$f":"Database!O16","v":180},{"$f":"Database!P16","v":749},{"$f":"Database!S16","v":270},{"$f":"Database!U16","v":0},{"$f":"Database!V16","v":0},7999,{"$f":"Database!X16","v":580},{"$f":"Database!Y16","v":0},{"$f":"Database!Z16","v":0},{"$f":"Database!AA16","v":0},580,7419]
[14,{"$f":"Database!A17","v":"Lijin k c"},{"$f":"Database!I17","v":13000},{"$f":"Database!K17","v":6500},{"$f":"Database!L17","v":1300},{"$f":"Database!M17","v":3250},{"$f":"Database!O17","v":500},{"$f":"Database!P17","v":1000},{"$f":"Database!S17","v":450},{"$f":"Database!U17","v":2000},{"$f":"Database!V17","v":0},15000,{"$f":"Database!X17","v":940},{"$f":"Database!Y17","v":0},{"$f":"Database!Z17","v":0},{"$f":"Database!AA17","v":0},940,14060]
[15,{"$f":"Database!A18","v":"Sayad K M"},{"$f":"Database!I18","v":35000},{"$f":"Database!K18","v":17500},{"$f":"Database!L18","v":3500},{"$f":"Database!M18","v":8750},{"$f":"Database!O18","v":1600},{"$f":"Database!P18","v":1250},{"$f":"Database!S18","v":2400},{"$f":"Database!U18","v":2000},{"$f":"Database!V18","v":0},37000,{"$f":"Database!X18","v":1800},{"$f":"Database!Y18","v":0},{"$f":"Database!Z18","v":2000},{"$f":"Database!AA18","v":0},3800,33200]
[16,{"$f":"Database!A19","v":"Ajil k Mohanan"},{"$f":"Database!I19","v":22000},{"$f":"Database!K19","v":11000},{"$f":"Database!L19","v":2200},{"$f":"Database!M19","v":5500},{"$f":"Database!O19","v":500},{"$f":"Database!P19","v":1250},{"$f":"Database!S19","v":1550},{"$f":"Database!U19","v":0},{"$f":"Database!V19","v":0},{"$f":"SUM(D21:K21)","v":22000},{"$f":"Database!X19","v":1580},{"$f":"Database!Y19","v":0},{"$f":"Database!Z19","v":0},{"$f":"Database!AA19","v":0},{"$f":"SUM(M21:P21)","v":1580},{"$f":"L21-Q21","v":20420}]
[17,{"$f":"Database!A20","v":"Edison ML"},{"$f":"Database!I20","v":12000},{"$f":"Database!K20","v":6000},{"$f":"Database!L20","v":1200},{"$f":"Database!M20","v":3000},{"$f":"Database!O20","v":600},{"$f":"Database!P20","v":1200},{"$f":"Database!S20","v":0},{"$f":"Database!U20","v":1000},{"$f":"Database!V20","v":0},13000,{"$f":"Database!X20","v":860},{"$f":"Database!Y20","v":0},{"$f":"Database!Z20","v":0},{"$f":"Database!AA20","v":0},860,12140]
[18,{"$f":"Database!A21","v":"Basil P E"},{"$f":"Database!I21","v":22000},{"$f":"Database!K21","v":11000},{"$f":"Database!L21","v":2200},{"$f":"Database!M21","v":5500},{"$f":"Database!O21","v":270},{"$f":"Database!P21","v":1067},{"$f":"Database!S21","v":1960},{"$f":"Database!U21","v":5000},{"$f":"Database!V21","v":0},26997,{"$f":"Database!X21","v":1580},{"$f":"Database!Y21","v":0},{"$f":"Database!Z21","v":0},{"$f":"Database!AA21","v":0},1580,25417]
[19,{"$f":"Database!A22","v":"Jobin George"},{"$f":"Database!I22","v":16000},{"$f":"Database!K22","v":7420},{"$f":"Database!L22","v":1480},{"$f":"Database!M22","v":3710},{"$f":"Database!O22","v":770},{"$f":"Database!P22","v":1250},{"$f":"Database!S22","v":780},{"$f":"Database!U22","v":1500},{"$f":"Database!V22","v":0},16910,{"$f":"Database!X22","v":1070},{"$f":"Database!Y22","v":0},{"$f":"Database!Z22","v":0},{"$f":"Database!AA22","v":0},1070,15840]
[20,{"$f":"Database!A23","v":"Jismon Tomy"},{"$f":"Database!I23","v":10000},{"$f":"Database!K23","v":5000},{"$f":"Database!L23","v":1000},{"$f":"Database!M23","v":2500},{"$f":"Database!O23","v":500},{"$f":"Database!P23","v":1000},{"$f":"Database!S23","v":0},{"$f":"Database!U23","v":2000},{"$f":"Database!V23","v":0},12000,{"$f":"Database!X23","v":720},{"$f":"Database!Y23","v":0},{"$f":"Database!Z23","v":0},{"$f":"Database!AA23","v":0},720,11280]
[21,{"$f":"Database!A24","v":"Sharafali P"},{"$f":"Database!I24","v":14000},{"$f":"Database!K24","v":7000},{"$f":"Database!L24","v":1400},{"$f":"Database!M24","v":3500},{"$f":"Database!O24","v":700},{"$f":"Database!P24","v":1250},{"$f":"Database!S24","v":150},{"$f":"Database!U24","v":0},{"$f":"Database!V24","v":0},14000,{"$f":"Database!X24","v":1010},{"$f":"Database!Y24","v":0},{"$f":"Database!Z24","v":0},{"$f":"Database!AA24","v":0},1010,12990]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R6:R26)","v":382720}]
[null,{"$f":"CONCATENATE(\"Rupees \",SpellNumber(R27))","v":"Rupees Three Lakh EightyTwo Thousand Seven Hundred Twenty Only "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Salary Slip'!B27","v":"Authorised by Managing Director"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Salary Slip'!G27","v":"Signature"}]

{"sheet":"Salary Slip","index":3,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[[12,0,24,0],[3,2,3,5],[22,14,24,16],[13,1,13,5],[12,1,12,5],[8,14,16,14],[11,1,11,3],[14,1,14,3],[0,13,24,13],[22,1,22,5],[2,0,2,12],[1,14,7,14],[0,14,0,16],[0,1,0,12],[17,14,21,14],[3,6,3,7],[3,8,3,12],[1,1,1,12],[20,4,21,5],[4,1,4,5],[19,1,19,3],[17,1,17,3],[18,1,18,3],[9,1,9,3],[10,1,10,3],[26,1,26,5],[9,8,22,12],[5,6,11,7],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[15,1,15,3],[16,1,16,3],[20,1,21,3],[26,6,26,7],[23,8,24,12],[23,1,23,5],[24,1,24,5]]}
[null,{"$f":"VLOOKUP(Q2,_xlnm.Database,36,FALSE)","v":"ABC & Company Ltd"}]
[null,{"$f":"PROPER(CONCATENATE(\"SALARY PAY SLIP FOR THE MONTH OF\"&\" \",VLOOKUP(Q2,_xlnm.Database,3,FALSE)&\" \",VLOOKUP(Q2,_xlnm.Database,4,FALSE)))","v":"Salary Pay Slip For The Month Of May 2018"},null,null,null,null,null,null,null,null,null,null,null,null,null,"NAME","Raj Sharma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DESIGNATION",{"$f":"VLOOKUP(Q2,_xlnm.Database,2,FALSE)","v":"Chief Technical Officer"}]
[null,"Name:",{"$f":"VLOOKUP(Q2,_xlnm.Database,31,FALSE)&\".\"&VLOOKUP(Q2,_xlnm.Database,1,FALSE)","v":"Mr.Raj Sharma"},null,null,null,{"$f":"PROPER(P3)","v":"Designation"},null,{"$f":"Q3","v":"Chief Technical Officer"},null,null,null,null,null,null,"TOTAL LEAVE DAYS",{"$f":"VLOOKUP(Q$2,_xlnm.Database,7,FALSE)","v":5}]
["I","Basic Payment",null,null,null,null,"$",{"$f":"Q9","v":23700},"A","Total Attendance",null,null,{"$f":"MIN(30,Q5)","v":27},null,null,"TOTAL DAYS OF THE MONTH",{"$f":"VLOOKUP(Q$2,_xlnm.Database,5,FALSE)","v":27}]
["II","Dearness Allowance",null,null,"$",{"$f":"Q10","v":4740},null,null,"B","Total Leave",null,null,{"$f":"Q4","v":5},null,null,"TOTAL ALLOWED LEAVE",{"$f":"VLOOKUP(Q$2,_xlnm.Database,6,FALSE)","v":2}]
["III","House Rent Allowance",null,null,"$",11850,null,null,null,"Allowed Leave",null,null,{"$f":"Q6","v":2},null,null,"CTC",{"$f":"VLOOKUP(Q$2,_xlnm.Database,9,FALSE)","v":60000}]
["IV","Conveyance",null,null,"$",1420,null,null,null,"Loss of Pay days",null,null,{"$f":"IF(M6<=M7,0,M6-M7)","v":3}]
["V","Medical Expenses",null,null,"$",0,null,null,"C","Total Salary Days",null,null,{"$f":"M5-M8","v":24},null,"ADDITIONS","BASIC SALARY",{"$f":"VLOOKUP(Q$2,_xlnm.Database,11,FALSE)","v":23700}]
["VI","Special ",null,null,"$",10370,null,null,null,null,null,null,null,null,null,"DEARNESS ALLOWANCE",{"$f":"VLOOKUP(Q$2,_xlnm.Database,12,FALSE)","v":4740}]
["VII","Bonus",null,null,"$",13100,null,null,null,null,null,null,null,null,null,"HOUSE RENT ALLOWANCE",{"$f":"VLOOKUP(Q$2,_xlnm.Database,13,FALSE)","v":11850}]
["VIII",{"$f":"Database!V3","v":"TA"},null,null,"$",0,null,null,null,null,null,null,null,null,null,"CONVEYANCE",{"$f":"VLOOKUP(Q$2,_xlnm.Database,15,FALSE)","v":1420}]
[null,"Sub Total",null,null,null,null,"$",{"$f":"SUM(F6:F12)","v":41480},null,null,null,null,null,null,null,"MEDICAL EXPENSES",{"$f":"VLOOKUP(Q$2,_xlnm.Database,17,FALSE)","v":0}]
[null,"Total Gross Salary",null,null,null,null,null,{"$f":"H5+H13","v":65180},null,null,null,null,null,null,null,"SPECIAL",{"$f":"VLOOKUP(Q$2,_xlnm.Database,19,FALSE)","v":10370}]
[null,"Deductions ",null,null,null,null,null,null,null,null,null,null,null,null,null,"BONUS",{"$f":"VLOOKUP(Q$2,_xlnm.Database,21,FALSE)","v":13100}]
[null,"a.Contribution to PF",null,null,"$",{"$f":"Q18","v":1800},null,null,null,null,null,null,null,null,null,"OTHERS",{"$f":"VLOOKUP(Q$2,_xlnm.Database,22,FALSE)","v":0}]
[null,"b.Salary Advance",null,null,"Rs.",{"$f":"Q21","v":0},null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"TOTAL\",\" \" & O9)","v":"TOTAL ADDITIONS"},{"$f":"SUM(Q9:Q16)","v":65180}]
[null,"c.Profession Tax",null,null,"Rs.",{"$f":"Q19","v":0},null,null,null,null,null,null,null,null,"DEDUCTIONS","CONTRIBUTION TO PF",{"$f":"VLOOKUP(Q$2,_xlnm.Database,24,FALSE)","v":1800}]
[null,"d.TDS",null,null,"Rs.",{"$f":"Q20","v":7000},null,null,null,null,null,null,null,null,null,"PROFESSION TAX",{"$f":"VLOOKUP(Q$2,_xlnm.Database,25,FALSE)","v":0}]
[null,"Total Deductions",null,null,null,{"$f":"SUM(F16:F19)","v":8800},null,null,null,null,null,null,null,null,null,"TDS",{"$f":"VLOOKUP(Q$2,_xlnm.Database,26,FALSE)","v":7000}]
[null,"Total Deductions",null,null,null,null,"Rs.",{"$f":"ROUND(F20,-1)","v":8800},null,null,null,null,null,null,null,"SALARY ADVANCE",{"$f":"VLOOKUP(Q$2,_xlnm.Database,27,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"TOTAL\",\" \" & O18)","v":"TOTAL DEDUCTIONS"},{"$f":"SUM(Q18:Q21)","v":8800}]
[null,"SALARY AFTER DEDUCTIONS",null,null,null,null,null,{"$f":"H14-H21","v":56380}]
[null,"Less Salary Advance",null,null,null,null,"Rs",{"$f":"Q21","v":0},{"$f":"SpellNumber(H25)","v":"FiftySix Thousand Three Hundred Eighty Only "}]
[null,"NET TAKE HOME",null,null,null,null,null,{"$f":"H23-H24","v":56380}]
[]
[null,{"$f":"CONCATENATE(\"Authorised by\" &\" \",Database!AF4)","v":"Authorised by Managing Director"},null,null,null,null,"Signature",null,"-----------------------------------"]