{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Database","Consolidation","Salary Slip"],"not_rendered":{"charts":0,"images":8,"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":"Database","index":0,"n_rows":51,"n_cols":36,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,10,3,22],[3,23,3,27],[3,0,3,8]]}
["Note : To use this sheet you need to enable the macros"]
[]
[1,{"$f":"A3+1","v":2},{"$f":"B3+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,null,"TOTAL GROSS SALARY",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL DEDUCTIONS"]
["Name","Designation","Month","Year","Total Days of Month","Allowed Leave","Leave taken","Worked Days","CTC",{"$f":"CONCATENATE(\"CTC for \"&C6&\" \",D6)","v":"CTC for December 2016"},"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"]
["Raj Sharma","Chief Technical Officer","December",2016,30,2,0,{"$f":"IF(G6>=F6,E6-G6+F6,E6)","v":30},60000,{"$f":"IF(H6=0,\"\",ROUND(I6/E6*H6,-1))","v":60000},{"$f":"IF(H6=0,\"\",ROUND($J6/E6*H6*50%,-1))","v":30000},{"$f":"IF(H6=0,\"\",ROUND(J6/E6*H6*10%,-1))","v":6000},{"$f":"IF(H6=0,\"\",ROUND(J6/E6*H6*25%,-1))","v":15000},{"$f":"IF(H6=0,\"\",1600)","v":1600},{"$f":"IF(H6=0,\"\",ROUND(N6/E6*H6,-1))","v":1600},{"$f":"MIN(1250,IF(AH6=\"Yes\",IF(H6=0,\"\",AI6),0))","v":1250},null,{"$f":"IF(H6=0,\"\",ROUND(J6-T6,-1))","v":6150},{"$f":"IF(R6<=0,0,R6)","v":6150},{"$f":"IF(H6=0,\"\",SUM(K6:M6)+O6+P6)","v":53850},13100,0,{"$f":"IF(H6=0,\"\",SUM(K6:M6)+O6+Q6+S6+U6+V6)","v":71850},{"$f":"ROUND(MIN(1800,IF(AG6=\"Yes\",SUM(K6:L6)*12%,0)),-1)","v":1800},null,7000,null,{"$f":"SUM(X6:AA6)","v":8800},{"$f":"IFERROR(W6-AB6,\"\")","v":63050},"Male",{"$f":"IF(AD6=0,\"\",IF(AD6=\"Male\",\"Mr\",IF(AD6=\"Female\",\"Mrs\")))","v":"Mr"},"Managing Director","Yes","Yes",1250,"Company Name"]
["Sharad Gandhi","Accountant",{"$f":"IF(A7=0,\"\",C$6)","v":"December"},{"$f":"IF(A7=0,\"\",D$6)","v":2016},30,0,0,{"$f":"IF(G7>=F7,E7-G7+F7,E7)","v":30},30000,{"$f":"IF(H7=0,\"\",ROUND(I7/E7*H7,-1))","v":30000},{"$f":"IF(H7=0,\"\",ROUND($J7/E7*H7*50%,-1))","v":15000},{"$f":"IF(H7=0,\"\",ROUND(J7/E7*H7*10%,-1))","v":3000},{"$f":"IF(H7=0,\"\",ROUND(J7/E7*H7*25%,-1))","v":7500},{"$f":"IF(H7=0,\"\",1600)","v":1600},{"$f":"IF(H7=0,\"\",ROUND(N7/E7*H7,-1))","v":1600},{"$f":"MIN(1250,IF(AH7=\"Yes\",IF(H7=0,\"\",AI7),0))","v":1250},null,{"$f":"IF(H7=0,\"\",ROUND(J7-T7,-1))","v":1650},1650,{"$f":"IF(H7=0,\"\",SUM(K7:M7)+O7+P7)","v":28350},2300,0,31050,{"$f":"ROUND(MIN(1800,IF(AG7=\"Yes\",SUM(K7:L7)*12%,0)),-1)","v":1800},null,500,null,2300,28750,"Male","Mr",{"$f":"IF(A7=0,\"\",AF$6)","v":"Managing Director"},"Yes","Yes",1250,"ABC & Company Ltd"]
["Danish D'Souza","Senior Web Developer","December",2016,30,0,0,30,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(A8=0,\"\",AF$6)","v":"Managing Director"},"Yes","Yes",2000,"Sabu & Company Ltd"]
["Pawan Patil","Senior Ux/Ui Developer","December",2016,30,2,2,30,25000,25000,12500,2500,6250,{"$f":"IF(H9=0,\"\",1600)","v":1600},1600,1250,null,900,900,24100,0,0,23750,1800,null,null,null,1800,21950,"Male","Mr",{"$f":"IF(A9=0,\"\",AF$6)","v":"Managing Director"},"Yes","Yes",1250,"ABC & Company Ltd"]
["Rijo Paul","Senior Web Developer","December",2016,30,2,2,30,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(A10=0,\"\",AF$6)","v":"Managing Director"},"Yes","Yes",2200,"ABC & Company Ltd"]
["Joseph P","Senior Web Developer","December",2016,30,2,1,30,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"]
["Aakash Patel","Web Developer","December",2016,30,2,2,30,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"]
["Ganesh Rahu","Ux/Ui Designer","December",2016,30,2,1,30,14000,14000,7000,1400,3500,600,600,1200,null,300,{"$f":"IF(R13<=0,0,R13)","v":300},13700,0,0,12800,1010,null,null,null,1010,11790,"Male","Mr","Managing Director","Yes","Yes",1200,"ABC & Company Ltd"]
["Vinudas K.S","Web Developer","December",2016,30,2,2,30,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"]
["Divya Kumar","Web Developer","December",2016,30,2,2,30,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"]
["Shilpa R","QAA","December",2016,30,2,3,29,8000,7730,3740,750,1870,387,370,774,null,230,230,7504,0,0,6960,540,null,null,null,540,6420,"Female","Mrs","Managing Director","Yes","Yes",774,"ABC & Company Ltd"]
["Sindhu J.P","Web Developer","December",2016,30,2,1,30,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"]
["Deepthi P.S","QAA","December",2016,30,2,2,30,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"]
["Lijin k c","Accountant","December",2016,30,2,2,30,13000,13000,6500,1300,3250,500,500,1000,null,450,450,12550,2000,0,14000,940,null,null,null,940,13060,"Male",{"$f":"IF(AD19=0,\"\",IF(AD19=\"Male\",\"Mr\",IF(AD19=\"Female\",\"Mrs\")))","v":"Mr"},"Managing Director","Yes","Yes",1000,"ABC & Company Ltd"]
["Sayad K M","Project Manager","December",2016,30,2,1,30,35000,35000,17500,3500,8750,{"$f":"IF(H20=0,\"\",1600)","v":1600},1600,1250,null,2400,{"$f":"IF(R20<=0,0,R20)","v":2400},32600,2000,0,35750,1800,null,2000,null,3800,31950,"Male",{"$f":"IF(AD20=0,\"\",IF(AD20=\"Male\",\"Mr\",IF(AD20=\"Female\",\"Mrs\")))","v":"Mr"},"Managing Director","Yes","Yes",1250,"ABC & Company Ltd"]
["Ajil k Mohanan","Web Developer","December",2016,30,2,2,30,22000,22000,11000,2200,5500,500,500,1250,null,1550,1550,20450,0,0,20750,1580,null,null,null,1580,{"$f":"IFERROR(W21-AB21,\"\")","v":19170},"Male","Mr","Managing Director","Yes","Yes",2000,"ABC & Company Ltd"]
["Edison ML","Web Developer","December",2016,30,2,0,30,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"]
["Basil P E","Web Developer","December",2016,30,2,1,30,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"]
["Jobin George","Web Developer","December",2016,30,2,0,30,16000,16000,8000,1600,4000,800,800,1250,null,350,350,15650,1500,0,16250,1150,null,null,null,1150,15100,"Male","Mr","Managing Director","Yes","Yes",1600,"ABC & Company Ltd"]
["Jismon Tomy","Web Developer","December",2016,30,2,1,30,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"]
["Sharafali P","Ux/Ui Designer","December",2016,30,2,0,30,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"]
[null,null,"","",null,null,null,0,null,"","","","",{"$f":"IF(H27=0,\"\",1600)","v":""},"",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,{"$f":"IF(G29>=F29,E29-G29+F29,E29)","v":0},null,"","","","","","",0,null,"",{"$f":"IF(R29<=0,0,R29)","v":""},"",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"",{"$f":"IF(A30=0,\"\",D$6)","v":""},null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,{"$f":"IF(A31=0,\"\",C$6)","v":""},{"$f":"IF(A31=0,\"\",D$6)","v":""},null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,{"$f":"IF(A32=0,\"\",C$6)","v":""},{"$f":"IF(A32=0,\"\",D$6)","v":""},null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"",{"$f":"IF(A33=0,\"\",D$6)","v":""},null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]
[null,null,"","",null,null,null,0,null,"","","","","","",0,null,"","","",null,null,"",0,null,null,null,0,"",null,"","",null,null,null,"ABC & Company Ltd"]

{"sheet":"Consolidation","index":1,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":false,"merged":[[28,12,29,14],[30,12,31,14],[28,15,31,17],[0,0,0,17],[1,0,1,17],[2,3,2,10],[2,2,3,2],[2,1,3,1],[2,0,3,0],[2,11,3,11],[2,12,2,16],[2,17,3,17],[27,0,31,11],[25,0,25,14],[26,1,26,7],[26,8,26,14],[25,15,26,16],[25,17,26,17],[27,12,27,17]]}
[{"$f":"'Salary Slip'!B1","v":"Company Name"}]
[{"$f":"CONCATENATE(\"Consolidated Salary Sheet for the month of \"&\" \"&Database!C6&\" \", Database!D6)","v":"Consolidated Salary Sheet for the month of  December 2016"}]
["Sl No","Name of Employee","CTC",{"$f":"Database!K4","v":"TOTAL GROSS SALARY"},null,null,null,null,null,null,null,{"$f":"Database!W5","v":"TOTAL"},{"$f":"Database!X4","v":"TOTAL DEDUCTIONS"},null,null,null,null,{"$f":"Database!AC5","v":"NET PAYABLE"}]
[null,null,null,{"$f":"Database!K5","v":"Basic Salary"},{"$f":"Database!L5","v":"DA"},{"$f":"Database!M5","v":"HRA"},{"$f":"Database!N5","v":"Conveyance"},{"$f":"Database!P5","v":"Medical Expenses"},{"$f":"Database!S5","v":"Special"},{"$f":"Database!U5","v":"Bonus"},{"$f":"Database!V5","v":"TA"},null,{"$f":"Database!X5","v":"Contribution to PF"},{"$f":"Database!Y5","v":"Profession Tax"},{"$f":"Database!Z5","v":"TDS"},{"$f":"Database!AA5","v":"Salary Advance"},{"$f":"Database!AB5","v":"TOTAL"}]
[1,{"$f":"Database!A6","v":"Raj Sharma"},{"$f":"Database!I6","v":60000},{"$f":"Database!K6","v":30000},{"$f":"Database!L6","v":6000},{"$f":"Database!M6","v":15000},{"$f":"Database!O6","v":1600},{"$f":"Database!P6","v":1250},{"$f":"Database!S6","v":6150},{"$f":"Database!U6","v":13100},{"$f":"Database!V6","v":0},{"$f":"SUM(D5:K5)","v":73100},{"$f":"Database!X6","v":1800},{"$f":"Database!Y6","v":0},{"$f":"Database!Z6","v":7000},{"$f":"Database!AA6","v":0},{"$f":"SUM(M5:P5)","v":8800},{"$f":"L5-Q5","v":64300}]
[{"$f":"IF(C6>0,A5+1,\"\")","v":2},{"$f":"Database!A7","v":"Sharad Gandhi"},{"$f":"Database!I7","v":30000},{"$f":"Database!K7","v":15000},{"$f":"Database!L7","v":3000},{"$f":"Database!M7","v":7500},{"$f":"Database!O7","v":1600},{"$f":"Database!P7","v":1250},{"$f":"Database!S7","v":1650},{"$f":"Database!U7","v":2300},{"$f":"Database!V7","v":0},32300,{"$f":"Database!X7","v":1800},{"$f":"Database!Y7","v":0},{"$f":"Database!Z7","v":500},{"$f":"Database!AA7","v":0},2300,30000]
[3,{"$f":"Database!A8","v":"Danish D'Souza"},{"$f":"Database!I8","v":20000},{"$f":"Database!K8","v":10000},{"$f":"Database!L8","v":2000},{"$f":"Database!M8","v":5000},{"$f":"Database!O8","v":1000},{"$f":"Database!P8","v":1250},{"$f":"Database!S8","v":750},{"$f":"Database!U8","v":0},{"$f":"Database!V8","v":0},20000,{"$f":"Database!X8","v":1440},{"$f":"Database!Y8","v":0},{"$f":"Database!Z8","v":0},{"$f":"Database!AA8","v":0},1440,18560]
[4,{"$f":"Database!A9","v":"Pawan Patil"},{"$f":"Database!I9","v":25000},{"$f":"Database!K9","v":12500},{"$f":"Database!L9","v":2500},{"$f":"Database!M9","v":6250},{"$f":"Database!O9","v":1600},{"$f":"Database!P9","v":1250},{"$f":"Database!S9","v":900},{"$f":"Database!U9","v":0},{"$f":"Database!V9","v":0},25000,{"$f":"Database!X9","v":1800},{"$f":"Database!Y9","v":0},{"$f":"Database!Z9","v":0},{"$f":"Database!AA9","v":0},1800,23200]
[5,{"$f":"Database!A10","v":"Rijo Paul"},{"$f":"Database!I10","v":22000},{"$f":"Database!K10","v":11000},{"$f":"Database!L10","v":2200},{"$f":"Database!M10","v":5500},{"$f":"Database!O10","v":1100},{"$f":"Database!P10","v":1250},{"$f":"Database!S10","v":950},{"$f":"Database!U10","v":2300},{"$f":"Database!V10","v":0},24300,{"$f":"Database!X10","v":1580},{"$f":"Database!Y10","v":0},{"$f":"Database!Z10","v":0},{"$f":"Database!AA10","v":0},1580,22720]
[6,{"$f":"Database!A11","v":"Joseph P"},{"$f":"Database!I11","v":14000},{"$f":"Database!K11","v":7000},{"$f":"Database!L11","v":1400},{"$f":"Database!M11","v":3500},{"$f":"Database!O11","v":700},{"$f":"Database!P11","v":1250},{"$f":"Database!S11","v":150},{"$f":"Database!U11","v":2300},{"$f":"Database!V11","v":0},16300,{"$f":"Database!X11","v":1010},{"$f":"Database!Y11","v":0},{"$f":"Database!Z11","v":0},{"$f":"Database!AA11","v":0},1010,15290]
[7,{"$f":"Database!A12","v":"Aakash Patel"},{"$f":"Database!I12","v":15000},{"$f":"Database!K12","v":7500},{"$f":"Database!L12","v":1500},{"$f":"Database!M12","v":3750},{"$f":"Database!O12","v":600},{"$f":"Database!P12","v":1200},{"$f":"Database!S12","v":450},{"$f":"Database!U12","v":0},{"$f":"Database!V12","v":0},15000,{"$f":"Database!X12","v":1080},{"$f":"Database!Y12","v":0},{"$f":"Database!Z12","v":0},{"$f":"Database!AA12","v":0},1080,13920]
[8,{"$f":"Database!A13","v":"Ganesh Rahu"},{"$f":"Database!I13","v":14000},{"$f":"Database!K13","v":7000},{"$f":"Database!L13","v":1400},{"$f":"Database!M13","v":3500},{"$f":"Database!O13","v":600},{"$f":"Database!P13","v":1200},{"$f":"Database!S13","v":300},{"$f":"Database!U13","v":0},{"$f":"Database!V13","v":0},14000,{"$f":"Database!X13","v":1010},{"$f":"Database!Y13","v":0},{"$f":"Database!Z13","v":0},{"$f":"Database!AA13","v":0},1010,12990]
[9,{"$f":"Database!A14","v":"Vinudas K.S"},{"$f":"Database!I14","v":14000},{"$f":"Database!K14","v":7000},{"$f":"Database!L14","v":1400},{"$f":"Database!M14","v":3500},{"$f":"Database!O14","v":700},{"$f":"Database!P14","v":1250},{"$f":"Database!S14","v":150},{"$f":"Database!U14","v":1500},{"$f":"Database!V14","v":0},15500,{"$f":"Database!X14","v":1010},{"$f":"Database!Y14","v":0},{"$f":"Database!Z14","v":0},{"$f":"Database!AA14","v":0},1010,14490]
[10,{"$f":"Database!A15","v":"Divya Kumar"},{"$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]
[11,{"$f":"Database!A16","v":"Shilpa R"},{"$f":"Database!I16","v":8000},{"$f":"Database!K16","v":3740},{"$f":"Database!L16","v":750},{"$f":"Database!M16","v":1870},{"$f":"Database!O16","v":370},{"$f":"Database!P16","v":774},{"$f":"Database!S16","v":230},{"$f":"Database!U16","v":0},{"$f":"Database!V16","v":0},7734,{"$f":"Database!X16","v":540},{"$f":"Database!Y16","v":0},{"$f":"Database!Z16","v":0},{"$f":"Database!AA16","v":0},540,7194]
[12,{"$f":"Database!A17","v":"Sindhu J.P"},{"$f":"Database!I17","v":8000},{"$f":"Database!K17","v":4000},{"$f":"Database!L17","v":800},{"$f":"Database!M17","v":2000},{"$f":"Database!O17","v":400},{"$f":"Database!P17","v":800},{"$f":"Database!S17","v":0},{"$f":"Database!U17","v":0},{"$f":"Database!V17","v":0},8000,{"$f":"Database!X17","v":580},{"$f":"Database!Y17","v":0},{"$f":"Database!Z17","v":0},{"$f":"Database!AA17","v":0},580,7420]
[13,{"$f":"Database!A18","v":"Deepthi P.S"},{"$f":"Database!I18","v":8000},{"$f":"Database!K18","v":4000},{"$f":"Database!L18","v":800},{"$f":"Database!M18","v":2000},{"$f":"Database!O18","v":180},{"$f":"Database!P18","v":749},{"$f":"Database!S18","v":270},{"$f":"Database!U18","v":0},{"$f":"Database!V18","v":0},7999,{"$f":"Database!X18","v":580},{"$f":"Database!Y18","v":0},{"$f":"Database!Z18","v":0},{"$f":"Database!AA18","v":0},580,7419]
[14,{"$f":"Database!A19","v":"Lijin k c"},{"$f":"Database!I19","v":13000},{"$f":"Database!K19","v":6500},{"$f":"Database!L19","v":1300},{"$f":"Database!M19","v":3250},{"$f":"Database!O19","v":500},{"$f":"Database!P19","v":1000},{"$f":"Database!S19","v":450},{"$f":"Database!U19","v":2000},{"$f":"Database!V19","v":0},15000,{"$f":"Database!X19","v":940},{"$f":"Database!Y19","v":0},{"$f":"Database!Z19","v":0},{"$f":"Database!AA19","v":0},940,14060]
[15,{"$f":"Database!A20","v":"Sayad K M"},{"$f":"Database!I20","v":35000},{"$f":"Database!K20","v":17500},{"$f":"Database!L20","v":3500},{"$f":"Database!M20","v":8750},{"$f":"Database!O20","v":1600},{"$f":"Database!P20","v":1250},{"$f":"Database!S20","v":2400},{"$f":"Database!U20","v":2000},{"$f":"Database!V20","v":0},37000,{"$f":"Database!X20","v":1800},{"$f":"Database!Y20","v":0},{"$f":"Database!Z20","v":2000},{"$f":"Database!AA20","v":0},3800,33200]
[16,{"$f":"Database!A21","v":"Ajil k Mohanan"},{"$f":"Database!I21","v":22000},{"$f":"Database!K21","v":11000},{"$f":"Database!L21","v":2200},{"$f":"Database!M21","v":5500},{"$f":"Database!O21","v":500},{"$f":"Database!P21","v":1250},{"$f":"Database!S21","v":1550},{"$f":"Database!U21","v":0},{"$f":"Database!V21","v":0},{"$f":"SUM(D20:K20)","v":22000},{"$f":"Database!X21","v":1580},{"$f":"Database!Y21","v":0},{"$f":"Database!Z21","v":0},{"$f":"Database!AA21","v":0},{"$f":"SUM(M20:P20)","v":1580},{"$f":"L20-Q20","v":20420}]
[17,{"$f":"Database!A22","v":"Edison ML"},{"$f":"Database!I22","v":12000},{"$f":"Database!K22","v":6000},{"$f":"Database!L22","v":1200},{"$f":"Database!M22","v":3000},{"$f":"Database!O22","v":600},{"$f":"Database!P22","v":1200},{"$f":"Database!S22","v":0},{"$f":"Database!U22","v":1000},{"$f":"Database!V22","v":0},13000,{"$f":"Database!X22","v":860},{"$f":"Database!Y22","v":0},{"$f":"Database!Z22","v":0},{"$f":"Database!AA22","v":0},860,12140]
[18,{"$f":"Database!A23","v":"Basil P E"},{"$f":"Database!I23","v":22000},{"$f":"Database!K23","v":11000},{"$f":"Database!L23","v":2200},{"$f":"Database!M23","v":5500},{"$f":"Database!O23","v":270},{"$f":"Database!P23","v":1067},{"$f":"Database!S23","v":1960},{"$f":"Database!U23","v":5000},{"$f":"Database!V23","v":0},26997,{"$f":"Database!X23","v":1580},{"$f":"Database!Y23","v":0},{"$f":"Database!Z23","v":0},{"$f":"Database!AA23","v":0},1580,25417]
[19,{"$f":"Database!A24","v":"Jobin George"},{"$f":"Database!I24","v":16000},{"$f":"Database!K24","v":8000},{"$f":"Database!L24","v":1600},{"$f":"Database!M24","v":4000},{"$f":"Database!O24","v":800},{"$f":"Database!P24","v":1250},{"$f":"Database!S24","v":350},{"$f":"Database!U24","v":1500},{"$f":"Database!V24","v":0},17500,{"$f":"Database!X24","v":1150},{"$f":"Database!Y24","v":0},{"$f":"Database!Z24","v":0},{"$f":"Database!AA24","v":0},1150,16350]
[20,{"$f":"Database!A25","v":"Jismon Tomy"},{"$f":"Database!I25","v":10000},{"$f":"Database!K25","v":5000},{"$f":"Database!L25","v":1000},{"$f":"Database!M25","v":2500},{"$f":"Database!O25","v":500},{"$f":"Database!P25","v":1000},{"$f":"Database!S25","v":0},{"$f":"Database!U25","v":2000},{"$f":"Database!V25","v":0},12000,{"$f":"Database!X25","v":720},{"$f":"Database!Y25","v":0},{"$f":"Database!Z25","v":0},{"$f":"Database!AA25","v":0},720,11280]
[21,{"$f":"Database!A26","v":"Sharafali P"},{"$f":"Database!I26","v":14000},{"$f":"Database!K26","v":7000},{"$f":"Database!L26","v":1400},{"$f":"Database!M26","v":3500},{"$f":"Database!O26","v":700},{"$f":"Database!P26","v":1250},{"$f":"Database!S26","v":150},{"$f":"Database!U26","v":0},{"$f":"Database!V26","v":0},14000,{"$f":"Database!X26","v":1010},{"$f":"Database!Y26","v":0},{"$f":"Database!Z26","v":0},{"$f":"Database!AA26","v":0},1010,12990]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R5:R25)","v":390780}]
[null,{"$f":"CONCATENATE(\"Rupees \",SpellNumber(R26))","v":{"$error":"#NAME?"}}]
[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":2,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[[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],[22,1,22,3],[23,1,23,5],[24,1,24,5],[0,1,0,12],[8,14,15,14],[17,14,21,14],[3,6,3,7],[3,8,3,12],[1,1,1,12],[3,2,3,3],[20,4,21,5],[4,1,4,5],[19,1,19,3],[12,1,13,3],[12,4,13,5],[17,1,17,3],[18,1,18,3],[9,1,9,3],[10,1,10,3]]}
[null,{"$f":"VLOOKUP(Q2,_xlnm.Database,36,FALSE)","v":"Company Name"}]
[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 December 2016"},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":0}]
["I","Basic Payment",null,null,null,null,"Rs.",{"$f":"Q9","v":30000},"A","Total Attendance",null,null,{"$f":"MIN(30,Q5)","v":30},null,null,"TOTAL DAYS OF THE MONTH",{"$f":"VLOOKUP(Q$2,_xlnm.Database,5,FALSE)","v":30}]
["II","Dearness Allowance",null,null,"Rs.",{"$f":"Q10","v":6000},null,null,"B","Total Leave",null,null,{"$f":"Q4","v":0},null,null,"TOTAL ALLOWED LEAVE",{"$f":"VLOOKUP(Q$2,_xlnm.Database,6,FALSE)","v":2}]
["III","House Rent Allowance",null,null,"Rs.",15000,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,"Rs.",1600,null,null,null,"Loss of Pay days",null,null,{"$f":"IF(M6<=M7,0,M6-M7)","v":0}]
["V","Medical Expenses",null,null,"Rs.",0,null,null,"C","Total Salary Days",null,null,{"$f":"M5-M8","v":30},null,"ADDITIONS","BASIC SALARY",{"$f":"VLOOKUP(Q$2,_xlnm.Database,11,FALSE)","v":30000}]
["VI","Special ",null,null,"Rs.",6150,null,null,null,null,null,null,null,null,null,"DEARNESS ALLOWANCE",{"$f":"VLOOKUP(Q$2,_xlnm.Database,12,FALSE)","v":6000}]
["VII","Bonus",null,null,"Rs.",13100,null,null,null,null,null,null,null,null,null,"HOUSE RENT ALLOWANCE",{"$f":"VLOOKUP(Q$2,_xlnm.Database,13,FALSE)","v":15000}]
["VIII",{"$f":"Database!V5","v":"TA"},null,null,"Rs.",0,null,null,null,null,null,null,null,null,null,"CONVEYANCE",{"$f":"VLOOKUP(Q$2,_xlnm.Database,15,FALSE)","v":1600}]
[null,"Total Gross Salary",null,null,null,null,"Rs.",{"$f":"SUM(F6:F12)","v":41850},null,null,null,null,null,null,null,"MEDICAL EXPENSES",{"$f":"VLOOKUP(Q$2,_xlnm.Database,17,FALSE)","v":0}]
[null,null,null,null,null,null,null,{"$f":"H5+H13","v":71850},null,null,null,null,null,null,null,"SPECIAL",{"$f":"VLOOKUP(Q$2,_xlnm.Database,19,FALSE)","v":6150}]
[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,"Rs.",{"$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":71850}]
[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":63050}]
[null,"Less Salary Advance",null,null,null,null,"Rs",{"$f":"Q21","v":0},{"$f":"SpellNumber(H25)","v":{"$error":"#NAME?"}}]
[null,"NET TAKE HOME",null,null,null,null,null,{"$f":"H23-H24","v":63050}]
[]
[null,{"$f":"CONCATENATE(\"Authorised by\" &\" \",Database!AF6)","v":"Authorised by Managing Director"},null,null,null,null,"Signature",null,"------------------------------------------------"]