{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Master Sheet","DA HRA RATE","Deductions","GA55 A Paymanager","Single Page"],"not_rendered":{"images":3,"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Master Sheet","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"merged":[[0,0,0,4],[1,0,1,4],[2,3,2,4]]}
["Government Senior Secondary School, Deogarh (Rajsamand)"]
["GA 55A Offline"]
["Session","2019-20","DDO CODE::",26887]
["Employee Name","Designation","Employee ID","Pay Scale","NPS/GPF"]
["Ashwini Kumar","Lecturer","RJNA12345678910","L-12","GPF"]
["GPF/PRAN Number ","Account No","PAN No.","TAN No","Probation"]
[12345678910,"1234567891011","ABCD1234E","ABCD1234E","NO"]
["March Basic","Handi. All.","Wash All.","CCA Amount","Surrender Month"]
[69200,{"$nulls":3},"November"]
["Ot. Allow 1","Ot. Allow 2","Ot. Allow 3","Bonus","Bonus Months"]
[{"$nulls":3},"NO"]
["If Basic Changed Month","Changed Basic","July Basic Incriment Other Than 7th Pay","Mobile No","SI No"]
[{"$nulls":3},9024823712,12345678]

{"sheet":"DA HRA RATE","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"merged":[[0,0,0,3],[1,0,1,3]]}
[{"$f":"'Master Sheet'!A1","v":"Government Senior Secondary School, Deogarh (Rajsamand)"}]
["DA and HRA Rates Monthwise"]
[]
["Sr.No","Month","DA Rate","HRA Rate"]
[3,"March",{"v":0.12,"d":"12.00%"},{"v":0.08,"d":"8.00%"}]
[4,"April",{"v":0.12,"d":"12.00%"},{"v":0.08,"d":"8.00%"}]
[5,"May",{"v":0.12,"d":"12.00%"},{"v":0.08,"d":"8.00%"}]
[6,"June",{"v":0.12,"d":"12.00%"},{"v":0.08,"d":"8.00%"}]
[7,"July",{"v":0.12,"d":"12.00%"},{"v":0.08,"d":"8.00%"}]
[8,"August",{"v":0.12,"d":"12.00%"},{"v":0.08,"d":"8.00%"}]
[9,"September",{"v":0.12,"d":"12.00%"},{"v":0.08,"d":"8.00%"}]
[10,"October",{"v":0.12,"d":"12.00%"},{"v":0.08,"d":"8.00%"}]
[11,"November",{"v":0.12,"d":"12.00%"},{"v":0.08,"d":"8.00%"}]
[12,"December",{"v":0.12,"d":"12.00%"},{"v":0.08,"d":"8.00%"}]
[1,"January",{"v":0.12,"d":"12.00%"},{"v":0.08,"d":"8.00%"}]
[2,"February",{"v":0.12,"d":"12.00%"},{"v":0.08,"d":"8.00%"}]

{"sheet":"Deductions","index":2,"n_rows":177,"n_cols":4,"rows_kept":177,"merged":[[0,0,0,3],[1,0,1,3],[14,0,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3]]}
[{"$f":"'Master Sheet'!A1","v":"Government Senior Secondary School, Deogarh (Rajsamand)"}]
["Deductions Detail"]
[]
["Deduction Name","Deduction Amount","If Changed than Month","Changed Amount"]
["GPF",5100,"July",5500]
["GPF Loan",100,"November",200]
["RPMF/RGHS",700,"November",800]
["SIP",3000]
["SIL",5000,"November",6000]
["SII",100,"November",200]
["LIC",100,"November",200]
["CM Corona"]
["Other Ded.",""]
["",""]
["Itax Amount"]
["Sr.No","Month","Itax Amount"]
[3,"March",101]
[4,"April",102]
[5,"May",103]
[6,"June",104]
[7,"July",105]
[8,"August",106]
[9,"September",107]
[10,"October",108]
[11,"November",109]
[12,"December",110]
[1,"January",111]
[2,"February",112]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]

{"sheet":"GA55 A Paymanager","index":3,"n_rows":96,"n_cols":24,"rows_kept":96,"merged":[[0,0,0,8],[0,12,0,13],[1,0,1,8],[1,12,1,13],[2,0,2,1],[2,2,2,3],[2,5,2,6],[2,7,2,10],[2,13,2,14],[3,0,3,1],[3,2,3,6],[3,7,3,8],[3,9,3,14],[4,0,4,1],[4,2,4,6],[4,7,4,8],[4,9,4,14],[5,0,5,1],[5,2,5,6],[5,7,5,8],[5,9,5,11],[5,13,5,14],[6,0,6,1],[6,4,6,7],[6,9,6,12],[7,1,11,1],[12,1,16,1],[17,1,21,1],[22,1,26,1],[27,1,31,1],[32,1,36,1],[37,0,37,8],[37,12,37,13],[38,0,38,8],[38,12,38,13],[39,1,43,1],[44,1,48,1],[49,1,53,1],[54,1,58,1],[59,1,63,1],[64,1,68,1],[73,0,73,8],[73,12,73,13],[74,0,74,8],[74,12,74,13],[75,0,76,0],[75,1,76,1],[75,2,76,2],[75,3,76,3],[77,0,78,0],[77,1,78,1],[77,2,78,2],[77,3,78,3],[79,0,80,0],[79,1,80,1],[79,2,80,2],[79,3,80,3],[81,0,82,0],[81,1,82,1],[81,2,82,2],[81,3,82,3],[84,1,84,5],[84,6,84,8],[85,1,85,2],[85,8,85,9],[85,11,85,12],[86,1,86,2],[86,8,86,9],[86,11,86,12],[87,1,87,2],[87,8,87,9],[87,11,87,12],[88,1,88,2],[88,8,88,9],[88,11,88,12],[89,1,89,2],[89,8,89,9],[89,11,89,12],[90,1,90,2],[90,8,90,9],[90,11,90,12],[91,1,91,2],[91,8,91,9],[91,11,91,12],[92,1,92,2],[92,8,92,9],[92,11,92,12],[93,1,93,2],[93,8,93,9],[93,11,93,12],[94,1,94,2],[94,8,94,9],[94,13,94,14],[95,1,95,2],[95,3,95,4],[95,6,95,7],[95,8,95,9],[95,11,95,12],[95,13,95,14]]}
["Government Of Rajasthan",{"$nulls":11},"Page No.",null,1]
["GA55 A",{"$nulls":11},"Financial Year : ",null,{"$f":"IF('Master Sheet'!B3=\"\",\"\",'Master Sheet'!B3)","v":"2019-20"}]
["DDO Code:",null,{"$f":"IF('Master Sheet'!D3=\"\",\"\",'Master Sheet'!D3)","v":26887},null,null,"Office Name :",null,"GSSS Deogarh",{"$nulls":4},"TAN:",{"$f":"IF('Master Sheet'!D7=\"\",\"\",'Master Sheet'!D7)","v":"ABCD1234E"}]
["Employee Name :",null,{"$f":"IF('Master Sheet'!A5=\"\",\"\",UPPER('Master Sheet'!A5))","v":"ASHWINI KUMAR"},{"$nulls":4},"Employee ID :",null,{"$f":"IF('Master Sheet'!C5=\"\",\"\",'Master Sheet'!C5)","v":"RJNA12345678910"}]
["Designation :",null,{"$f":"IF('Master Sheet'!B5=\"\",\"\",'Master Sheet'!B5)","v":"Lecturer"},{"$nulls":4},"Pay Scale :",null,{"$f":"IF('Master Sheet'!D5=\"\",\"\",'Master Sheet'!D5)","v":"L-12"}]
["GPF/PRAN Number :",null,{"$f":"IF('Master Sheet'!A7=\"\",\"\",'Master Sheet'!A7)","v":12345678910},{"$nulls":4},"Account No :",null,{"$f":"IF('Master Sheet'!B7=\"\",\"\",'Master Sheet'!B7)","v":"1234567891011"},null,null,"PAN :",{"$f":"IF('Master Sheet'!C7=\"\",\"\",'Master Sheet'!C7)","v":"ABCD1234E"}]
["Pay Month\nPay Year",null,"Bill No.\nTV No.","Bill Date\nTV Date","----------------Allowances----------------",{"$nulls":3},"Gross Amount","------------Deductions------------",{"$nulls":3},"Total deduction","NetAmount"]
[null,"Salary",null,null,"Basic",{"$f":"IF('Master Sheet'!$A$9=\"\",\"\",'Master Sheet'!$A$9)","v":{"v":69200,"d":"69200.00"}},"DA",{"$f":"IF('Master Sheet'!$E$7=\"YES\",\"\",IF(F8=\"\",\"\",ROUND(F8*'DA HRA RATE'!$C$5,0)))","v":{"v":8304,"d":"8304.00"}},{"$f":"SUM(F8:F12,H8:H12)","v":{"v":83040,"d":"83040.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F8,H8)*10%,0)),\"\")","v":""},{"$f":"Deductions!A9","v":"SIL"},{"$f":"IF(Deductions!B9=\"\",\"\",Deductions!B9)","v":{"v":5000,"d":"5000.00"}},{"$f":"SUM(M8:M12,K8:K12)","v":{"v":14201,"d":"14201.00"}},{"$f":"SUM(I8-N8)","v":{"v":68839,"d":"68839.00"}},{"$nulls":7},{"$f":"A10","v":"March"},{"$f":"F8","v":{"v":69200,"d":"69200.00"}}]
[{"$nulls":4},"HRA",{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(F8=\"\",\"\",ROUND(F8*'DA HRA RATE'!$D$5,0)))","v":{"v":5536,"d":"5536.00"}},"Wash All.",{"$f":"IF('Master Sheet'!$C$9=\"\",\"\",'Master Sheet'!$C$9)","v":""},null,{"$f":"Deductions!A5","v":"GPF"},{"$f":"IF(Deductions!B5=\"\",\"\",Deductions!B5)","v":{"v":5100,"d":"5100.00"}},{"$f":"Deductions!A10","v":"SII"},{"$f":"IF(Deductions!B10=\"\",\"\",Deductions!B10)","v":{"v":100,"d":"100.00"}},{"$nulls":9},{"$f":"A15","v":"April"},{"$f":"F13","v":{"v":69200,"d":"69200.00"}}]
["March",{"$nulls":3},"Handi. All.",{"$f":"IF('Master Sheet'!$B$9=\"\",\"\",'Master Sheet'!$B$9)","v":""},"CCA",{"$f":"IF('Master Sheet'!$D$9=\"\",\"\",'Master Sheet'!$D$9)","v":""},null,{"$f":"Deductions!A6","v":"GPF Loan"},{"$f":"IF(Deductions!B6=\"\",\"\",Deductions!B6)","v":{"v":100,"d":"100.00"}},{"$f":"Deductions!A11","v":"LIC"},{"$f":"IF(Deductions!B11=\"\",\"\",Deductions!B11)","v":{"v":100,"d":"100.00"}},{"$nulls":9},{"$f":"A20","v":"May"},{"$f":"F18","v":{"v":69200,"d":"69200.00"}}]
[{"$f":"LEFT($O$2,4)","v":"2019"},{"$nulls":3},{"$f":"'Master Sheet'!$A$10","v":"Ot. Allow 1"},{"$f":"IF('Master Sheet'!$A$11=\"\",\"\",'Master Sheet'!$A$11)","v":""},{"$f":"'Master Sheet'!$B$10","v":"Ot. Allow 2"},{"$f":"IF('Master Sheet'!$B$11=\"\",\"\",'Master Sheet'!$B$11)","v":""},null,{"$f":"Deductions!A7","v":"RPMF/RGHS"},{"$f":"IF(Deductions!B7=\"\",\"\",Deductions!B7)","v":{"v":700,"d":"700.00"}},"Itax",{"$f":"IF(A10=Deductions!B17,Deductions!C17,\"\")","v":{"v":101,"d":"101.00"}},{"$nulls":9},{"$f":"A25","v":"June"},{"$f":"F23","v":{"v":69200,"d":"69200.00"}}]
[{"$nulls":4},{"$f":"'Master Sheet'!$C$10","v":"Ot. Allow 3"},{"$f":"IF('Master Sheet'!$C$11=\"\",\"\",'Master Sheet'!$C$11)","v":""},"Ot. Allow 4",null,null,{"$f":"Deductions!A8","v":"SIP"},{"$f":"IF(Deductions!B8=\"\",\"\",Deductions!B8)","v":{"v":3000,"d":"3000.00"}},{"$f":"Deductions!A12","v":"CM Corona"},{"$f":"IF(Deductions!B12=\"\",\"\",Deductions!B12)","v":""},{"$nulls":9},{"$f":"A30","v":"July"},{"$f":"F28","v":{"v":71300,"d":"71300.00"}}]
[null,"Salary",null,null,"Basic",{"$f":"IF(A15='Master Sheet'!$A$13,'Master Sheet'!$B$13,F8)","v":{"v":69200,"d":"69200.00"}},"DA",{"$f":"IF('Master Sheet'!$E$7=\"YES\",\"\",IF(F13=\"\",\"\",ROUND(F13*'DA HRA RATE'!$C$6,0)))","v":{"v":8304,"d":"8304.00"}},{"$f":"SUM(F13:F17,H13:H17)","v":{"v":83040,"d":"83040.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F13,H13)*10%,0)),\"\")","v":""},{"$f":"L8","v":"SIL"},{"$f":"IF(A15=Deductions!$C$9,Deductions!$D$9,M8)","v":{"v":5000,"d":"5000.00"}},{"$f":"SUM(M13:M17,K13:K17)","v":{"v":14202,"d":"14202.00"}},{"$f":"SUM(I13-N13)","v":{"v":68838,"d":"68838.00"}},{"$nulls":7},{"$f":"A35","v":"August"},{"$f":"F33","v":{"v":71300,"d":"71300.00"}}]
[{"$nulls":4},"HRA",{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(F13=\"\",\"\",ROUND(F13*'DA HRA RATE'!$D$6,0)))","v":{"v":5536,"d":"5536.00"}},"Wash All.",{"$f":"H9","v":""},null,{"$f":"J9","v":"GPF"},{"$f":"IF(A15=Deductions!$C$5,Deductions!$D$5,K9)","v":{"v":5100,"d":"5100.00"}},{"$f":"L9","v":"SII"},{"$f":"IF(A15=Deductions!$C$10,Deductions!$D$10,M9)","v":{"v":100,"d":"100.00"}},{"$nulls":9},{"$f":"A42","v":"September"},{"$f":"F40","v":{"v":71300,"d":"71300.00"}}]
["April",{"$nulls":3},"Handi. All.",{"$f":"F10","v":""},"CCA",{"$f":"H10","v":""},null,{"$f":"J10","v":"GPF Loan"},{"$f":"IF(A15=Deductions!$C$6,Deductions!$D$6,K10)","v":{"v":100,"d":"100.00"}},"LIC",{"$f":"IF(A15=Deductions!$C$11,Deductions!$D$11,M10)","v":{"v":100,"d":"100.00"}},{"$nulls":9},{"$f":"A47","v":"October"},{"$f":"F45","v":{"v":71300,"d":"71300.00"}}]
[{"$f":"LEFT($O$2,4)","v":"2019"},{"$nulls":3},{"$f":"'Master Sheet'!$A$10","v":"Ot. Allow 1"},{"$f":"F11","v":""},{"$f":"'Master Sheet'!$B$10","v":"Ot. Allow 2"},{"$f":"H11","v":""},null,"RPMF/RGHS",{"$f":"IF(A15=Deductions!$C$7,Deductions!$D$7,K11)","v":{"v":700,"d":"700.00"}},"Itax",{"$f":"IF(A15=Deductions!B18,Deductions!C18,\"\")","v":{"v":102,"d":"102.00"}},{"$nulls":9},{"$f":"A52","v":"November"},{"$f":"F50","v":{"v":71300,"d":"71300.00"}}]
[{"$nulls":4},{"$f":"'Master Sheet'!$C$10","v":"Ot. Allow 3"},{"$f":"F12","v":""},{"$f":"G12","v":"Ot. Allow 4"},{"$f":"H12","v":{"v":0,"d":"0.00"}},null,"SIP",{"$f":"K12","v":{"v":3000,"d":"3000.00"}},"CM Corona",{"$f":"IF(A15=Deductions!$C$12,Deductions!$D$12,M12)","v":""},{"$nulls":9},{"$f":"A57","v":"December"},{"$f":"F55","v":{"v":71300,"d":"71300.00"}}]
[null,"Salary",null,null,"Basic",{"$f":"IF(A20='Master Sheet'!$A$13,'Master Sheet'!$B$13,F13)","v":{"v":69200,"d":"69200.00"}},"DA",{"$f":"IF('Master Sheet'!$E$7=\"YES\",\"\",IF(F18=\"\",\"\",ROUND(F18*'DA HRA RATE'!$C$7,0)))","v":{"v":8304,"d":"8304.00"}},{"$f":"SUM(F18:F22,H18:H22)","v":{"v":83040,"d":"83040.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F18,H18)*10%,0)),\"\")","v":""},{"$f":"L13","v":"SIL"},{"$f":"IF(A20=Deductions!$C$9,Deductions!$D$9,M13)","v":{"v":5000,"d":"5000.00"}},{"$f":"SUM(M18:M22,K18:K22)","v":{"v":14203,"d":"14203.00"}},{"$f":"SUM(I18-N18)","v":{"v":68837,"d":"68837.00"}},{"$nulls":7},{"$f":"A62","v":"January"},{"$f":"F60","v":{"v":71300,"d":"71300.00"}}]
[{"$nulls":4},"HRA",{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(F18=\"\",\"\",ROUND(F18*'DA HRA RATE'!$D$7,0)))","v":{"v":5536,"d":"5536.00"}},"Wash All.",{"$f":"H14","v":""},null,{"$f":"J14","v":"GPF"},{"$f":"IF(A20=Deductions!$C$5,Deductions!$D$5,K14)","v":{"v":5100,"d":"5100.00"}},"SII",{"$f":"IF(A20=Deductions!$C$10,Deductions!$D$10,M14)","v":{"v":100,"d":"100.00"}},{"$nulls":9},{"$f":"A67","v":"February"},{"$f":"F65","v":{"v":71300,"d":"71300.00"}}]
["May",{"$nulls":3},"Handi. All.",{"$f":"F15","v":""},"CCA",{"$f":"H15","v":""},null,{"$f":"J15","v":"GPF Loan"},{"$f":"IF(A20=Deductions!$C$6,Deductions!$D$6,K15)","v":{"v":100,"d":"100.00"}},"LIC",{"$f":"IF(A20=Deductions!$C$11,Deductions!$D$11,M15)","v":{"v":100,"d":"100.00"}}]
[{"$f":"LEFT($O$2,4)","v":"2019"},{"$nulls":3},{"$f":"'Master Sheet'!$A$10","v":"Ot. Allow 1"},{"$f":"F16","v":""},{"$f":"'Master Sheet'!$B$10","v":"Ot. Allow 2"},{"$f":"H16","v":""},null,"RPMF/RGHS",{"$f":"IF(A20=Deductions!$C$7,Deductions!$D$7,K16)","v":{"v":700,"d":"700.00"}},"Itax",{"$f":"IF(A20=Deductions!B19,Deductions!C19,\"\")","v":{"v":103,"d":"103.00"}}]
[{"$nulls":4},{"$f":"'Master Sheet'!$C$10","v":"Ot. Allow 3"},{"$f":"F17","v":""},{"$f":"G17","v":"Ot. Allow 4"},{"$f":"H17","v":{"v":0,"d":"0.00"}},null,"SIP",{"$f":"K17","v":{"v":3000,"d":"3000.00"}},"CM Corona",{"$f":"IF(A20=Deductions!$C$12,Deductions!$D$12,M17)","v":""}]
[null,"Salary",null,null,"Basic",{"$f":"IF(A25='Master Sheet'!$A$13,'Master Sheet'!$B$13,F18)","v":{"v":69200,"d":"69200.00"}},"DA",{"$f":"IF('Master Sheet'!$E$7=\"YES\",\"\",IF(F23=\"\",\"\",ROUND(F23*'DA HRA RATE'!$C$8,0)))","v":{"v":8304,"d":"8304.00"}},{"$f":"SUM(F23:F27,H23:H27)","v":{"v":83040,"d":"83040.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F23,H23)*10%,0)),\"\")","v":""},{"$f":"L18","v":"SIL"},{"$f":"IF(A25=Deductions!$C$9,Deductions!$D$9,M18)","v":{"v":5000,"d":"5000.00"}},{"$f":"SUM(M23:M27,K23:K27)","v":{"v":14204,"d":"14204.00"}},{"$f":"SUM(I23-N23)","v":{"v":68836,"d":"68836.00"}}]
[{"$nulls":4},"HRA",{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(F23=\"\",\"\",ROUND(F23*'DA HRA RATE'!$D$8,0)))","v":{"v":5536,"d":"5536.00"}},"Wash All.",{"$f":"H19","v":""},null,{"$f":"J19","v":"GPF"},{"$f":"IF(A25=Deductions!$C$5,Deductions!$D$5,K19)","v":{"v":5100,"d":"5100.00"}},"SII",{"$f":"IF(A25=Deductions!$C$10,Deductions!$D$10,M19)","v":{"v":100,"d":"100.00"}}]
["June",{"$nulls":3},"Handi. All.",{"$f":"F20","v":""},"CCA",{"$f":"H20","v":""},null,{"$f":"J20","v":"GPF Loan"},{"$f":"IF(A25=Deductions!$C$6,Deductions!$D$6,K20)","v":{"v":100,"d":"100.00"}},"LIC",{"$f":"IF(A25=Deductions!$C$11,Deductions!$D$11,M20)","v":{"v":100,"d":"100.00"}}]
[{"$f":"LEFT($O$2,4)","v":"2019"},{"$nulls":3},{"$f":"'Master Sheet'!$A$10","v":"Ot. Allow 1"},{"$f":"F21","v":""},{"$f":"'Master Sheet'!$B$10","v":"Ot. Allow 2"},{"$f":"H21","v":""},null,"RPMF/RGHS",{"$f":"IF(A25=Deductions!$C$7,Deductions!$D$7,K21)","v":{"v":700,"d":"700.00"}},"Itax",{"$f":"IF(A25=Deductions!B20,Deductions!C20,\"\")","v":{"v":104,"d":"104.00"}}]
[{"$nulls":4},{"$f":"'Master Sheet'!$C$10","v":"Ot. Allow 3"},{"$f":"F22","v":""},{"$f":"G22","v":"Ot. Allow 4"},{"$f":"H22","v":{"v":0,"d":"0.00"}},null,"SIP",{"$f":"K22","v":{"v":3000,"d":"3000.00"}},"CM Corona",{"$f":"IF(A25=Deductions!$C$12,Deductions!$D$12,M22)","v":""}]
[null,"Salary",null,null,"Basic",{"$f":"IF('Master Sheet'!C13=\"\",IF('Master Sheet'!$E$7=\"Yes\",'GA55 A Paymanager'!$F$23,MROUND(F23*1.03,100)),'Master Sheet'!C13)","v":{"v":71300,"d":"71300.00"}},"DA",{"$f":"IF('Master Sheet'!$E$7=\"YES\",\"\",IF(F28=\"\",\"\",ROUND(F28*'DA HRA RATE'!$C$9,0)))","v":{"v":8556,"d":"8556.00"}},{"$f":"SUM(F28:F32,H28:H32)","v":{"v":85560,"d":"85560.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F28,H28)*10%,0)),\"\")","v":""},{"$f":"L23","v":"SIL"},{"$f":"IF(A30=Deductions!$C$9,Deductions!$D$9,M23)","v":{"v":5000,"d":"5000.00"}},{"$f":"SUM(M28:M32,K28:K32)","v":{"v":14605,"d":"14605.00"}},{"$f":"SUM(I28-N28)","v":{"v":70955,"d":"70955.00"}}]
[{"$nulls":4},"HRA",{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(F28=\"\",\"\",ROUND(F28*'DA HRA RATE'!$D$9,0)))","v":{"v":5704,"d":"5704.00"}},"Wash All.",{"$f":"H24","v":""},null,{"$f":"J24","v":"GPF"},{"$f":"IF(A30=Deductions!$C$5,Deductions!$D$5,K24)","v":{"v":5500,"d":"5500.00"}},"SII",{"$f":"IF(A30=Deductions!$C$10,Deductions!$D$10,M24)","v":{"v":100,"d":"100.00"}}]
["July",{"$nulls":3},"Handi. All.",{"$f":"F25","v":""},"CCA",{"$f":"H25","v":""},null,{"$f":"J25","v":"GPF Loan"},{"$f":"IF(A30=Deductions!$C$6,Deductions!$D$6,K25)","v":{"v":100,"d":"100.00"}},"LIC",{"$f":"IF(A30=Deductions!$C$11,Deductions!$D$11,M25)","v":{"v":100,"d":"100.00"}}]
[{"$f":"LEFT($O$2,4)","v":"2019"},{"$nulls":3},{"$f":"'Master Sheet'!$A$10","v":"Ot. Allow 1"},{"$f":"F26","v":""},{"$f":"'Master Sheet'!$B$10","v":"Ot. Allow 2"},{"$f":"H26","v":""},null,"RPMF/RGHS",{"$f":"IF(A30=Deductions!$C$7,Deductions!$D$7,K26)","v":{"v":700,"d":"700.00"}},"Itax",{"$f":"IF(A30=Deductions!B21,Deductions!C21,\"\")","v":{"v":105,"d":"105.00"}}]
[{"$nulls":4},{"$f":"'Master Sheet'!$C$10","v":"Ot. Allow 3"},{"$f":"F27","v":""},{"$f":"G27","v":"Ot. Allow 4"},{"$f":"H27","v":{"v":0,"d":"0.00"}},null,"SIP",{"$f":"K27","v":{"v":3000,"d":"3000.00"}},"CM Corona",{"$f":"IF(A30=Deductions!$C$12,Deductions!$D$12,M27)","v":""}]
[null,"Salary",null,null,"Basic",{"$f":"IF(A35='Master Sheet'!$A$13,'Master Sheet'!$B$13,F28)","v":{"v":71300,"d":"71300.00"}},"DA",{"$f":"IF('Master Sheet'!$E$7=\"YES\",\"\",IF(F33=\"\",\"\",ROUND(F33*'DA HRA RATE'!$C$10,0)))","v":{"v":8556,"d":"8556.00"}},{"$f":"SUM(F33:F37,H33:H37)","v":{"v":85560,"d":"85560.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F33,H33)*10%,0)),\"\")","v":""},{"$f":"L28","v":"SIL"},{"$f":"IF(A35=Deductions!$C$9,Deductions!$D$9,M28)","v":{"v":5000,"d":"5000.00"}},{"$f":"SUM(M33:M37,K33:K37)","v":{"v":14606,"d":"14606.00"}},{"$f":"SUM(I33-N33)","v":{"v":70954,"d":"70954.00"}}]
[{"$nulls":4},"HRA",{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(F33=\"\",\"\",ROUND(F33*'DA HRA RATE'!$D$10,0)))","v":{"v":5704,"d":"5704.00"}},"Wash All.",{"$f":"H29","v":""},null,{"$f":"J29","v":"GPF"},{"$f":"IF(A35=Deductions!$C$5,Deductions!$D$5,K29)","v":{"v":5500,"d":"5500.00"}},"SII",{"$f":"IF(A35=Deductions!$C$10,Deductions!$D$10,M29)","v":{"v":100,"d":"100.00"}}]
["August",{"$nulls":3},"Handi. All.",{"$f":"F30","v":""},"CCA",{"$f":"H30","v":""},null,{"$f":"J30","v":"GPF Loan"},{"$f":"IF(A35=Deductions!$C$6,Deductions!$D$6,K30)","v":{"v":100,"d":"100.00"}},"LIC",{"$f":"IF(A35=Deductions!$C$11,Deductions!$D$11,M30)","v":{"v":100,"d":"100.00"}}]
[{"$f":"LEFT($O$2,4)","v":"2019"},{"$nulls":3},{"$f":"'Master Sheet'!$A$10","v":"Ot. Allow 1"},{"$f":"F31","v":""},{"$f":"'Master Sheet'!$B$10","v":"Ot. Allow 2"},{"$f":"H31","v":""},null,"RPMF/RGHS",{"$f":"IF(A35=Deductions!$C$7,Deductions!$D$7,K31)","v":{"v":700,"d":"700.00"}},"Itax",{"$f":"IF(A35=Deductions!B22,Deductions!C22,\"\")","v":{"v":106,"d":"106.00"}}]
[{"$nulls":4},{"$f":"'Master Sheet'!$C$10","v":"Ot. Allow 3"},{"$f":"F32","v":""},{"$f":"G32","v":"Ot. Allow 4"},{"$f":"H32","v":{"v":0,"d":"0.00"}},null,"SIP",{"$f":"K32","v":{"v":3000,"d":"3000.00"}},"CM Corona",{"$f":"IF(A35=Deductions!$C$12,Deductions!$D$12,M32)","v":""}]
["Government Of Rajasthan",{"$nulls":11},"Page No.",null,2]
["GA55 A",{"$nulls":11},"Financial Year : ",null,{"$f":"O2","v":"2019-20"}]
[null,"Salary",null,null,"Basic",{"$f":"IF(A42='Master Sheet'!$A$13,'Master Sheet'!$B$13,F33)","v":{"v":71300,"d":"71300.00"}},"DA",{"$f":"IF('Master Sheet'!$E$7=\"YES\",\"\",IF(F40=\"\",\"\",ROUND(F40*'DA HRA RATE'!$C$11,0)))","v":{"v":8556,"d":"8556.00"}},{"$f":"SUM(F40:F44,H40:H44)","v":{"v":85560,"d":"85560.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F40,H40)*10%,0)),\"\")","v":""},{"$f":"L33","v":"SIL"},{"$f":"IF(A42=Deductions!$C$9,Deductions!$D$9,M33)","v":{"v":5000,"d":"5000.00"}},{"$f":"SUM(M40:M44,K40:K44)","v":{"v":14607,"d":"14607.00"}},{"$f":"SUM(I40-N40)","v":{"v":70953,"d":"70953.00"}}]
[{"$nulls":4},"HRA",{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(F40=\"\",\"\",ROUND(F40*'DA HRA RATE'!$D$11,0)))","v":{"v":5704,"d":"5704.00"}},"Wash All.",{"$f":"H34","v":""},null,{"$f":"J34","v":"GPF"},{"$f":"IF(A42=Deductions!$C$5,Deductions!$D$5,K34)","v":{"v":5500,"d":"5500.00"}},{"$f":"L34","v":"SII"},{"$f":"IF(A42=Deductions!$C$10,Deductions!$D$10,M34)","v":{"v":100,"d":"100.00"}}]
["September",{"$nulls":3},"Handi. All.",{"$f":"F35","v":""},"CCA",{"$f":"H35","v":""},null,{"$f":"J35","v":"GPF Loan"},{"$f":"IF(A42=Deductions!$C$6,Deductions!$D$6,K35)","v":{"v":100,"d":"100.00"}},"LIC",{"$f":"IF(A42=Deductions!$C$11,Deductions!$D$11,M35)","v":{"v":100,"d":"100.00"}}]
[{"$f":"LEFT($O$2,4)","v":"2019"},{"$nulls":3},{"$f":"'Master Sheet'!$A$10","v":"Ot. Allow 1"},{"$f":"F36","v":""},{"$f":"'Master Sheet'!$B$10","v":"Ot. Allow 2"},{"$f":"H36","v":""},null,"RPMF/RGHS",{"$f":"IF(A42=Deductions!$C$7,Deductions!$D$7,K36)","v":{"v":700,"d":"700.00"}},"Itax",{"$f":"IF(A42=Deductions!B23,Deductions!C23,\"\")","v":{"v":107,"d":"107.00"}}]
[{"$nulls":4},{"$f":"'Master Sheet'!$C$10","v":"Ot. Allow 3"},{"$f":"F37","v":""},{"$f":"G37","v":"Ot. Allow 4"},{"$f":"H37","v":{"v":0,"d":"0.00"}},null,"SIP",{"$f":"K37","v":{"v":3000,"d":"3000.00"}},"CM Corona",{"$f":"IF(A42=Deductions!$C$12,Deductions!$D$12,M37)","v":""}]
[null,"Salary",null,null,"Basic",{"$f":"IF(A47='Master Sheet'!$A$13,'Master Sheet'!$B$13,F40)","v":{"v":71300,"d":"71300.00"}},"DA",{"$f":"IF('Master Sheet'!$E$7=\"YES\",\"\",IF(F45=\"\",\"\",ROUND(F45*'DA HRA RATE'!$C$12,0)))","v":{"v":8556,"d":"8556.00"}},{"$f":"SUM(F45:F49,H45:H49)","v":{"v":85560,"d":"85560.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F45,H45)*10%,0)),\"\")","v":""},{"$f":"L40","v":"SIL"},{"$f":"IF(A47=Deductions!$C$9,Deductions!$D$9,M40)","v":{"v":5000,"d":"5000.00"}},{"$f":"SUM(M45:M49,K45:K49)","v":{"v":14608,"d":"14608.00"}},{"$f":"SUM(I45-N45)","v":{"v":70952,"d":"70952.00"}}]
[{"$nulls":4},"HRA",{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(F45=\"\",\"\",ROUND(F45*'DA HRA RATE'!$D$12,0)))","v":{"v":5704,"d":"5704.00"}},"Wash All.",{"$f":"H41","v":""},null,{"$f":"J41","v":"GPF"},{"$f":"IF(A47=Deductions!$C$5,Deductions!$D$5,K41)","v":{"v":5500,"d":"5500.00"}},{"$f":"L41","v":"SII"},{"$f":"IF(A47=Deductions!$C$10,Deductions!$D$10,M41)","v":{"v":100,"d":"100.00"}}]
["October",{"$nulls":3},"Handi. All.",{"$f":"F42","v":""},"CCA",{"$f":"H42","v":""},null,{"$f":"J42","v":"GPF Loan"},{"$f":"IF(A47=Deductions!$C$6,Deductions!$D$6,K42)","v":{"v":100,"d":"100.00"}},"LIC",{"$f":"IF(A47=Deductions!$C$11,Deductions!$D$11,M42)","v":{"v":100,"d":"100.00"}}]
[{"$f":"LEFT($O$2,4)","v":"2019"},{"$nulls":3},{"$f":"'Master Sheet'!$A$10","v":"Ot. Allow 1"},{"$f":"F43","v":""},{"$f":"'Master Sheet'!$B$10","v":"Ot. Allow 2"},{"$f":"H43","v":""},null,"RPMF/RGHS",{"$f":"IF(A47=Deductions!$C$7,Deductions!$D$7,K43)","v":{"v":700,"d":"700.00"}},"Itax",{"$f":"IF(A47=Deductions!B24,Deductions!C24,\"\")","v":{"v":108,"d":"108.00"}}]
[{"$nulls":4},{"$f":"'Master Sheet'!$C$10","v":"Ot. Allow 3"},{"$f":"F44","v":""},{"$f":"G44","v":"Ot. Allow 4"},{"$f":"H44","v":{"v":0,"d":"0.00"}},null,"SIP",{"$f":"K44","v":{"v":3000,"d":"3000.00"}},"CM Corona",{"$f":"IF(A47=Deductions!$C$12,Deductions!$D$12,M44)","v":""}]
[null,"Salary",null,null,"Basic",{"$f":"IF(A52='Master Sheet'!$A$13,'Master Sheet'!$B$13,F45)","v":{"v":71300,"d":"71300.00"}},"DA",{"$f":"IF('Master Sheet'!$E$7=\"YES\",\"\",IF(F50=\"\",\"\",ROUND(F50*'DA HRA RATE'!$C$13,0)))","v":{"v":8556,"d":"8556.00"}},{"$f":"SUM(F50:F54,H50:H54)","v":{"v":85560,"d":"85560.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F50,H50)*10%,0)),\"\")","v":""},{"$f":"L45","v":"SIL"},{"$f":"IF(A52=Deductions!$C$9,Deductions!$D$9,M45)","v":{"v":6000,"d":"6000.00"}},{"$f":"SUM(M50:M54,K50:K54)","v":{"v":16009,"d":"16009.00"}},{"$f":"SUM(I50-N50)","v":{"v":69551,"d":"69551.00"}}]
[{"$nulls":4},"HRA",{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(F50=\"\",\"\",ROUND(F50*'DA HRA RATE'!$D$13,0)))","v":{"v":5704,"d":"5704.00"}},"Wash All.",{"$f":"H46","v":""},null,{"$f":"J46","v":"GPF"},{"$f":"IF(A52=Deductions!$C$5,Deductions!$D$5,K46)","v":{"v":5500,"d":"5500.00"}},"SII",{"$f":"IF(A52=Deductions!$C$10,Deductions!$D$10,M46)","v":{"v":200,"d":"200.00"}}]
["November",{"$nulls":3},"Handi. All.",{"$f":"F47","v":""},"CCA",{"$f":"H47","v":""},null,{"$f":"J47","v":"GPF Loan"},{"$f":"IF(A52=Deductions!$C$6,Deductions!$D$6,K47)","v":{"v":200,"d":"200.00"}},"LIC",{"$f":"IF(A52=Deductions!$C$11,Deductions!$D$11,M47)","v":{"v":200,"d":"200.00"}}]
[{"$f":"LEFT($O$2,4)","v":"2019"},{"$nulls":3},{"$f":"'Master Sheet'!$A$10","v":"Ot. Allow 1"},{"$f":"F48","v":""},{"$f":"'Master Sheet'!$B$10","v":"Ot. Allow 2"},{"$f":"H48","v":""},null,"RPMF/RGHS",{"$f":"IF(A52=Deductions!$C$7,Deductions!$D$7,K48)","v":{"v":800,"d":"800.00"}},"Itax",{"$f":"IF(A52=Deductions!B25,Deductions!C25,\"\")","v":{"v":109,"d":"109.00"}}]
[{"$nulls":4},{"$f":"'Master Sheet'!$C$10","v":"Ot. Allow 3"},{"$f":"F49","v":""},{"$f":"G49","v":"Ot. Allow 4"},{"$f":"H49","v":{"v":0,"d":"0.00"}},null,"SIP",{"$f":"K49","v":{"v":3000,"d":"3000.00"}},"CM Corona",{"$f":"IF(A52=Deductions!$C$12,Deductions!$D$12,M49)","v":""}]
[null,"Salary",null,null,"Basic",{"$f":"IF(A57='Master Sheet'!$A$13,'Master Sheet'!$B$13,F50)","v":{"v":71300,"d":"71300.00"}},"DA",{"$f":"IF('Master Sheet'!$E$7=\"YES\",\"\",IF(F55=\"\",\"\",ROUND(F55*'DA HRA RATE'!$C$14,0)))","v":{"v":8556,"d":"8556.00"}},{"$f":"SUM(F55:F59,H55:H59)","v":{"v":85560,"d":"85560.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F55,H55)*10%,0)),\"\")","v":""},{"$f":"L50","v":"SIL"},{"$f":"IF(A57=Deductions!$C$9,Deductions!$D$9,M50)","v":{"v":6000,"d":"6000.00"}},{"$f":"SUM(M55:M59,K55:K59)","v":{"v":16010,"d":"16010.00"}},{"$f":"SUM(I55-N55)","v":{"v":69550,"d":"69550.00"}}]
[{"$nulls":4},"HRA",{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(F55=\"\",\"\",ROUND(F55*'DA HRA RATE'!$D$14,0)))","v":{"v":5704,"d":"5704.00"}},"Wash All.",{"$f":"H51","v":""},null,{"$f":"J51","v":"GPF"},{"$f":"IF(A57=Deductions!$C$5,Deductions!$D$5,K51)","v":{"v":5500,"d":"5500.00"}},"SII",{"$f":"IF(A57=Deductions!$C$10,Deductions!$D$10,M51)","v":{"v":200,"d":"200.00"}}]
["December",{"$nulls":3},"Handi. All.",{"$f":"F52","v":""},"CCA",{"$f":"H52","v":""},null,{"$f":"J52","v":"GPF Loan"},{"$f":"IF(A57=Deductions!$C$6,Deductions!$D$6,K52)","v":{"v":200,"d":"200.00"}},"LIC",{"$f":"IF(A57=Deductions!$C$11,Deductions!$D$11,M52)","v":{"v":200,"d":"200.00"}}]
[{"$f":"LEFT($O$2,4)","v":"2019"},{"$nulls":3},{"$f":"'Master Sheet'!$A$10","v":"Ot. Allow 1"},{"$f":"F53","v":""},{"$f":"'Master Sheet'!$B$10","v":"Ot. Allow 2"},{"$f":"H53","v":""},null,"RPMF/RGHS",{"$f":"IF(A57=Deductions!$C$7,Deductions!$D$7,K53)","v":{"v":800,"d":"800.00"}},"Itax",{"$f":"IF(A57=Deductions!B26,Deductions!C26,\"\")","v":{"v":110,"d":"110.00"}}]
[{"$nulls":4},{"$f":"'Master Sheet'!$C$10","v":"Ot. Allow 3"},{"$f":"F54","v":""},{"$f":"G49","v":"Ot. Allow 4"},{"$f":"H54","v":{"v":0,"d":"0.00"}},null,"SIP",{"$f":"K54","v":{"v":3000,"d":"3000.00"}},"CM Corona",{"$f":"IF(A57=Deductions!$C$12,Deductions!$D$12,M54)","v":""}]
[null,"Salary",null,null,"Basic",{"$f":"IF(A62='Master Sheet'!$A$13,'Master Sheet'!$B$13,F55)","v":{"v":71300,"d":"71300.00"}},"DA",{"$f":"IF('Master Sheet'!$E$7=\"YES\",\"\",IF(F60=\"\",\"\",ROUND(F60*'DA HRA RATE'!$C$15,0)))","v":{"v":8556,"d":"8556.00"}},{"$f":"SUM(F60:F64,H60:H64)","v":{"v":85560,"d":"85560.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F60,H60)*10%,0)),\"\")","v":""},{"$f":"L55","v":"SIL"},{"$f":"IF(A62=Deductions!$C$9,Deductions!$D$9,M55)","v":{"v":6000,"d":"6000.00"}},{"$f":"SUM(M60:M64,K60:K64)","v":{"v":16011,"d":"16011.00"}},{"$f":"SUM(I60-N60)","v":{"v":69549,"d":"69549.00"}}]
[{"$nulls":4},"HRA",{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(F60=\"\",\"\",ROUND(F60*'DA HRA RATE'!$D$15,0)))","v":{"v":5704,"d":"5704.00"}},"Wash All.",{"$f":"H56","v":""},null,{"$f":"J56","v":"GPF"},{"$f":"IF(A62=Deductions!$C$5,Deductions!$D$5,K56)","v":{"v":5500,"d":"5500.00"}},"SII",{"$f":"IF(A62=Deductions!$C$10,Deductions!$D$10,M56)","v":{"v":200,"d":"200.00"}}]
["January",{"$nulls":3},"Handi. All.",{"$f":"F57","v":""},"CCA",{"$f":"H57","v":""},null,{"$f":"J57","v":"GPF Loan"},{"$f":"IF(A62=Deductions!$C$6,Deductions!$D$6,K57)","v":{"v":200,"d":"200.00"}},"LIC",{"$f":"IF(A62=Deductions!$C$11,Deductions!$D$11,M57)","v":{"v":200,"d":"200.00"}}]
[{"$f":"LEFT($O$2,2)&RIGHT($O$2,2)","v":"2020"},{"$nulls":3},{"$f":"'Master Sheet'!$A$10","v":"Ot. Allow 1"},{"$f":"F58","v":""},{"$f":"'Master Sheet'!$B$10","v":"Ot. Allow 2"},{"$f":"H58","v":""},null,"RPMF/RGHS",{"$f":"IF(A62=Deductions!$C$7,Deductions!$D$7,K58)","v":{"v":800,"d":"800.00"}},"Itax",{"$f":"IF(A62=Deductions!B27,Deductions!C27,\"\")","v":{"v":111,"d":"111.00"}}]
[{"$nulls":4},{"$f":"'Master Sheet'!$C$10","v":"Ot. Allow 3"},{"$f":"F59","v":""},{"$f":"G59","v":"Ot. Allow 4"},{"$f":"H59","v":{"v":0,"d":"0.00"}},null,"SIP",{"$f":"K59","v":{"v":3000,"d":"3000.00"}},"CM Corona",{"$f":"IF(A62=Deductions!$C$12,Deductions!$D$12,M59)","v":""}]
[null,"Salary",null,null,"Basic",{"$f":"IF(A67='Master Sheet'!$A$13,'Master Sheet'!$B$13,F60)","v":{"v":71300,"d":"71300.00"}},"DA",{"$f":"IF('Master Sheet'!$E$7=\"YES\",\"\",IF(F65=\"\",\"\",ROUND(F65*'DA HRA RATE'!$C$16,0)))","v":{"v":8556,"d":"8556.00"}},{"$f":"SUM(F65:F69,H65:H69)","v":{"v":85560,"d":"85560.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F65,H65)*10%,0)),\"\")","v":""},{"$f":"L60","v":"SIL"},{"$f":"IF(A67=Deductions!$C$9,Deductions!$D$9,M60)","v":{"v":6000,"d":"6000.00"}},{"$f":"SUM(M65:M69,K65:K69)","v":{"v":16012,"d":"16012.00"}},{"$f":"SUM(I65-N65)","v":{"v":69548,"d":"69548.00"}}]
[{"$nulls":4},"HRA",{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(F65=\"\",\"\",ROUND(F65*'DA HRA RATE'!$D$16,0)))","v":{"v":5704,"d":"5704.00"}},"Wash All.",{"$f":"H61","v":""},null,{"$f":"J61","v":"GPF"},{"$f":"IF(A67=Deductions!$C$5,Deductions!$D$5,K61)","v":{"v":5500,"d":"5500.00"}},"SII",{"$f":"IF(A67=Deductions!$C$10,Deductions!$D$10,M61)","v":{"v":200,"d":"200.00"}}]
["February",{"$nulls":3},"Handi. All.",{"$f":"F62","v":""},"CCA",{"$f":"H62","v":""},null,{"$f":"J62","v":"GPF Loan"},{"$f":"IF(A67=Deductions!$C$6,Deductions!$D$6,K62)","v":{"v":200,"d":"200.00"}},"LIC",{"$f":"IF(A67=Deductions!$C$11,Deductions!$D$11,M62)","v":{"v":200,"d":"200.00"}}]
[{"$f":"LEFT($O$2,2)&RIGHT($O$2,2)","v":"2020"},{"$nulls":3},{"$f":"'Master Sheet'!$A$10","v":"Ot. Allow 1"},{"$f":"F63","v":""},{"$f":"'Master Sheet'!$B$10","v":"Ot. Allow 2"},{"$f":"H63","v":""},null,"RPMF/RGHS",{"$f":"IF(A67=Deductions!$C$7,Deductions!$D$7,K63)","v":{"v":800,"d":"800.00"}},"Itax",{"$f":"IF(A67=Deductions!B28,Deductions!C28,\"\")","v":{"v":112,"d":"112.00"}}]
[{"$nulls":4},{"$f":"'Master Sheet'!$C$10","v":"Ot. Allow 3"},{"$f":"F64","v":""},{"$f":"G59","v":"Ot. Allow 4"},{"$f":"H64","v":{"v":0,"d":"0.00"}},null,"SIP",{"$f":"K64","v":{"v":3000,"d":"3000.00"}},"CM Corona",{"$f":"IF(A67=Deductions!$C$12,Deductions!$D$12,M64)","v":""}]
["Month","Bonus",null,null,"Bouns",{"$f":"IF('Master Sheet'!D11=\"Yes\",ROUND(6774/12*'Master Sheet'!$E$11,0),\"\")","v":""},null,null,{"$f":"SUM(F70)","v":{"v":0,"d":"0.00"}},"GPF 2004",null,"Other Ded.",null,{"$f":"SUM(K70,M70)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I70-N70)","v":{"v":0,"d":"0.00"}}]
["Month","DA",null,null,"DA",{"v":2076,"d":"2076.00"},"DA",{"v":2076,"d":"2076.00"},{"$f":"SUM(F71,H71)","v":{"v":4152,"d":"4152.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F71,H71)*10%,0)),\"\")","v":""},"GPF",{"$f":"IF('Master Sheet'!$E$5=\"NPS\",\"\",I71)","v":{"v":4152,"d":"4152.00"}},{"$f":"SUM(K71,M71)","v":{"v":4152,"d":"4152.00"}},{"$f":"SUM(I71-N71)","v":{"v":0,"d":"0.00"}}]
["Month","DA",null,null,"DA",null,"DA",null,{"$f":"SUM(F72,H72)","v":{"v":0,"d":"0.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F72,H72)*10%,0)),\"\")","v":""},"GPF",{"$f":"IF('Master Sheet'!$E$5=\"NPS\",\"\",I72)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K72,M72)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I72-N72)","v":{"v":0,"d":"0.00"}}]
[{"$f":"'Master Sheet'!E9","v":"November"},"Surrender",null,null,"Basic",{"$f":"ROUND(VLOOKUP($A$73,$W$8:$X$19,2,0)/2,0)","v":{"v":35650,"d":"35650.00"}},"DA",{"$f":"ROUND(VLOOKUP($A$73,Table1[[#All],[Month]:[DA Rate]],2,0)*F73,0)","v":{"v":4278,"d":"4278.00"}},{"$f":"SUM(F73,H73)","v":{"v":39928,"d":"39928.00"}},"Itax",null,"Other Ded.",null,{"$f":"SUM(K73,M73)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I73-N73)","v":{"v":39928,"d":"39928.00"}}]
["Government Of Rajasthan",{"$nulls":11},"Page No.",null,3]
["GA55 A",{"$nulls":11},"Financial Year : ",null,{"$f":"O2","v":"2019-20"}]
["Month","Salary Arrear",null,null,"Basic",null,"DA",null,{"$f":"SUM(H76:H77,F76:F77)","v":{"v":0,"d":"0.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F76,H76)*10%,0)),\"\")","v":""},"Itax",null,{"$f":"SUM(M76:M77,K76:K77)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I76-N76)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"HRA",null,{"$f":"E48","v":"Ot. Allow 1"},null,null,"GPF",null,"Other Ded."]
["Month","Other Arrear",null,null,"Basic",null,"DA",null,{"$f":"SUM(H78:H79,F78:F79)","v":{"v":0,"d":"0.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F78,H78)*10%,0)),\"\")","v":""},"Itax",null,{"$f":"SUM(M78:M79,K78:K79)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I78-N78)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"HRA",null,{"$f":"G77","v":"Ot. Allow 1"},null,null,"GPF",null,"Other Ded."]
["Month","Other Arrear",null,null,"Basic",null,"DA",null,{"$f":"SUM(H80:H81,F80:F81)","v":{"v":0,"d":"0.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F80,H80)*10%,0)),\"\")","v":""},"Itax",null,{"$f":"SUM(M80:M81,K80:K81)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I80-N80)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"HRA",null,{"$f":"G79","v":"Ot. Allow 1"},null,null,"GPF",null,"Other Ded."]
["Month","Other Arrear",null,null,"Basic",null,"DA",null,{"$f":"SUM(H82:H83,F82:F83)","v":{"v":0,"d":"0.00"}},"ECPenF",{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(F82,H82)*10%,0)),\"\")","v":""},"Itax",null,{"$f":"SUM(M82:M83,K82:K83)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I82-N82)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"HRA",null,{"$f":"G77","v":"Ot. Allow 1"},null,null,"GPF",null,"Other Ded."]
[]
[null,"Total Allowances",{"$nulls":4},"Total Allowances"]
[null,{"$f":"E8","v":"Basic"},null,100,{"$f":"SUMIF($E$8:$E$37,$B86,$F$8:$F$37)+SUMIF($E$40:$E$73,$B86,$F$40:$F$73)+SUMIF($E$76:$E$83,$B86,$F$76:$F$83)+SUMIF($G$8:$G$37,$B86,$H$8:$H$37)+SUMIF($G$40:$G$73,$B86,$H$40:$H$73)+SUMIF($G$76:$G$83,$B86,$H$76:$H$83)","v":{"v":882850,"d":"882850.00"}},null,"ECPenF",null,{"$f":"SUMIF($J$8:$J$37,$G86,$K$8:$K$37)+SUMIF($L$8:$L$37,$G86,$M$8:$M$37)+SUMIF($J$40:$J$73,$G86,$K$40:$K$73)+SUMIF($L$40:$L$73,$G86,$M$40:$M$73)+SUMIF($J$76:$J$83,$G86,$K$76:$K$83)+SUMIF($L$76:$L$83,$G86,$M$76:$M$83)","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"E9","v":"HRA"},null,107,{"v":67776,"d":"67776.00"},null,"GPF",null,{"v":68552,"d":"68552.00"}]
[null,"Handi. All.",null,null,{"v":0,"d":"0.00"},null,"SIP",null,{"v":36000,"d":"36000.00"}]
[null,{"$f":"G8","v":"DA"},null,104,{"v":110094,"d":"110094.00"},null,"RPMF",null,{"v":0,"d":"0.00"}]
[null,{"$f":"G9","v":"Wash All."},null,null,{"v":0,"d":"0.00"},null,"CM Corona",null,{"v":0,"d":"0.00"}]
[null,"CCA",null,null,{"v":0,"d":"0.00"},null,"LIC",null,{"v":1600,"d":"1600.00"}]
[null,{"$f":"E70","v":"Bouns"},null,null,{"v":0,"d":"0.00"},null,"GPF Loan",null,{"v":1600,"d":"1600.00"}]
[null,{"$f":"E11","v":"Ot. Allow 1"},null,null,{"v":0,"d":"0.00"},null,"SIL",null,{"v":64000,"d":"64000.00"}]
[null,{"$f":"G11","v":"Ot. Allow 2"},null,null,{"v":0,"d":"0.00"},null,"Itax",null,{"v":1278,"d":"1278.00"}]
[null,{"$f":"E12","v":"Ot. Allow 3"},null,null,{"v":0,"d":"0.00"},null,"Other Ded.",null,{"v":0,"d":"0.00"}]
[null,"Total Allowances:",null,{"$f":"ROUND(SUM(E86:E95),0)","v":{"v":1060720,"d":"1060720.00"}},null,null,"Total Deduction:",null,{"$f":"ROUND(SUM(I86:J95),0)","v":{"v":173030,"d":"173030.00"}},null,null,"Total Net Amount :",null,{"$f":"IFERROR(D96-I96,\"\")","v":{"v":887690,"d":"887690.00"}}]

{"sheet":"Single Page","index":4,"n_rows":30,"n_cols":36,"rows_kept":30,"merged":[[0,0,0,25],[1,0,1,24],[3,1,3,4],[3,6,3,8],[3,10,3,11],[3,12,3,13],[3,14,3,17],[3,18,3,20],[3,21,3,22],[3,24,3,25],[4,1,4,4],[4,6,4,8],[4,10,4,11],[4,12,4,13],[4,14,4,17],[4,18,4,20],[4,21,4,24],[29,0,29,2],[29,23,29,24]]}
[{"$f":"IF('Master Sheet'!A1=\"\",\"\",'Master Sheet'!A1)","v":"Government Senior Secondary School, Deogarh (Rajsamand)"}]
[{"$f":"\"वेतन एवं कटौतियों का ब्यौरा सत्र\"&\" - \"&'Master Sheet'!$B$3","v":"वेतन एवं कटौतियों का ब्यौरा सत्र - 2019-20"}]
[]
["नाम कर्मचारी-",{"$f":"IF('Master Sheet'!A5=\"\",\"\",'Master Sheet'!A5)","v":"Ashwini Kumar"},{"$nulls":3},"पद-",{"$f":"IF('Master Sheet'!B5=\"\",\"\",'Master Sheet'!B5)","v":"Lecturer"},null,null,"लेवल-",{"$f":"IF('Master Sheet'!D5=\"\",\"\",'Master Sheet'!D5)","v":"L-12"},null,"Employee ID-",null,{"$f":"IF('Master Sheet'!C5=\"\",\"\",'Master Sheet'!C5)","v":"RJNA12345678910"},{"$nulls":3},"मार्च का बेसिक-",null,null,{"$f":"IF('Master Sheet'!A9=\"\",\"\",'Master Sheet'!A9)","v":{"v":69200,"d":"69200.00"}},null,"TAN No.",{"$f":"IF('Master Sheet'!D7=\"\",\"\",'Master Sheet'!D7)","v":"ABCD1234E"}]
["पैन नं.-",{"$f":"IF('Master Sheet'!C7=\"\",\"\",'Master Sheet'!C7)","v":"ABCD1234E"},{"$nulls":3},"Mobile-",{"$f":"IF('Master Sheet'!D13=\"\",\"\",'Master Sheet'!D13)","v":9024823712},null,null,"SI No.-",{"$f":"IF('Master Sheet'!E13=\"\",\"\",'Master Sheet'!E13)","v":12345678},null,"GPF/PRAN No.-",null,{"$f":"IF('Master Sheet'!A7=\"\",\"\",'Master Sheet'!A7)","v":12345678910},{"$nulls":3},"बैंक खाता सं.-",null,null,{"$f":"IF('Master Sheet'!B7=\"\",\"\",'Master Sheet'!B7)","v":"1234567891011"}]
["Month & Year","Basic Pay","DA","HRA","Washing Allow.","Handicaped Allowance","CCA Allowance",{"$f":"'Master Sheet'!A10","v":"Ot. Allow 1"},"Gross Salary","SIP","GPF","NPS","GPF Loan","RPMF","SIL","SII","GIS","LIC","COVIS-19","GPF 2004","Hitkari Nidhi",{"$f":"Deductions!A13","v":"Other Ded."},"ITAX","Total Deduction","NET Payment","Bill No./ Date",{"$nulls":8},{"$f":"'Master Sheet'!E9","v":"November"}]
["March",{"$f":"IF('Master Sheet'!$A$9=\"\",\"\",'Master Sheet'!$A$9)","v":{"v":69200,"d":"69,200"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B7=\"\",\"\",ROUND(B7*'DA HRA RATE'!$C5,0)))","v":{"v":8304,"d":"8,304"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B7=\"\",\"\",ROUND(B7*'DA HRA RATE'!$D5,0)))","v":{"v":5536,"d":"5,536"}},{"$f":"IF('Master Sheet'!$C$9=\"\",\"\",'Master Sheet'!$C$9)","v":""},{"$f":"IF('Master Sheet'!$B$9=\"\",\"\",'Master Sheet'!$B$9)","v":""},{"$f":"IF('Master Sheet'!$D$9=\"\",\"\",'Master Sheet'!$D$9)","v":""},{"$f":"IF('Master Sheet'!$A$11=\"\",\"\",'Master Sheet'!$A$11)","v":""},{"$f":"SUM(B7:H7)","v":{"v":83040,"d":"83,040"}},{"$f":"IF(Deductions!B8=\"\",\"\",Deductions!B8)","v":{"v":3000,"d":"3,000"}},{"$f":"IF(Deductions!B5=\"\",\"\",Deductions!B5)","v":{"v":5100,"d":"5,100"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B7:C7)*10%,0)),\"\")","v":""},{"$f":"IF(Deductions!B6=\"\",\"\",Deductions!B6)","v":100},{"$f":"IF(Deductions!B7=\"\",\"\",Deductions!B7)","v":700},{"$f":"IF(Deductions!B9=\"\",\"\",Deductions!B9)","v":{"v":5000,"d":"5,000"}},{"$f":"IF(Deductions!B10=\"\",\"\",Deductions!B10)","v":100},null,{"$f":"IF(Deductions!B11=\"\",\"\",Deductions!B11)","v":100},{"$nulls":4},{"$f":"IF(A7=Deductions!B17,Deductions!C17,\"\")","v":101},{"$f":"SUM(J7:W7)","v":{"v":14201,"d":"14,201"}},{"$f":"SUM(I7-X7)","v":{"v":68839,"d":"68,839"}},{"$nulls":9},{"$f":"A7","v":"March"},{"$f":"B7","v":69200}]
["April",{"$f":"IF(A8='Master Sheet'!$A$13,'Master Sheet'!$B$13,B7)","v":{"v":69200,"d":"69,200"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B8=\"\",\"\",ROUND(B8*'DA HRA RATE'!$C6,0)))","v":{"v":8304,"d":"8,304"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B8=\"\",\"\",ROUND(B8*'DA HRA RATE'!$D6,0)))","v":{"v":5536,"d":"5,536"}},{"$f":"E7","v":""},{"$f":"F7","v":""},{"$f":"G7","v":""},{"$f":"H7","v":""},{"$f":"SUM(B8:H8)","v":{"v":83040,"d":"83,040"}},{"$f":"J7","v":{"v":3000,"d":"3,000"}},{"$f":"IF(A8=Deductions!$C$5,Deductions!$D$5,K7)","v":{"v":5100,"d":"5,100"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B8:C8)*10%,0)),\"\")","v":""},{"$f":"IF(A8=Deductions!$C$6,Deductions!$D$6,M7)","v":100},{"$f":"IF(A8=Deductions!$C$7,Deductions!$D$7,N7)","v":700},{"$f":"IF(A8=Deductions!$C$9,Deductions!$D$9,O7)","v":{"v":5000,"d":"5,000"}},{"$f":"IF(A8=Deductions!$C$10,Deductions!$D$10,P7)","v":100},220,{"$f":"IF(A8=Deductions!$C$11,Deductions!$D$11,R7)","v":100},{"$nulls":4},{"$f":"IF(A8=Deductions!B18,Deductions!C18,\"\")","v":102},{"$f":"SUM(J8:W8)","v":{"v":14422,"d":"14,422"}},{"$f":"SUM(I8-X8)","v":{"v":68618,"d":"68,618"}},{"$nulls":9},{"$f":"A8","v":"April"},{"$f":"B8","v":69200}]
["May",{"$f":"IF(A9='Master Sheet'!$A$13,'Master Sheet'!$B$13,B8)","v":{"v":69200,"d":"69,200"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B9=\"\",\"\",ROUND(B9*'DA HRA RATE'!$C7,0)))","v":{"v":8304,"d":"8,304"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B9=\"\",\"\",ROUND(B9*'DA HRA RATE'!$D7,0)))","v":{"v":5536,"d":"5,536"}},{"$f":"E8","v":""},{"$f":"F8","v":""},{"$f":"G8","v":""},{"$f":"H8","v":""},{"$f":"SUM(B9:H9)","v":{"v":83040,"d":"83,040"}},{"$f":"J8","v":{"v":3000,"d":"3,000"}},{"$f":"IF(A9=Deductions!$C$5,Deductions!$D$5,K8)","v":{"v":5100,"d":"5,100"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B9:C9)*10%,0)),\"\")","v":""},{"$f":"IF(A9=Deductions!$C$6,Deductions!$D$6,M8)","v":100},{"$f":"IF(A9=Deductions!$C$7,Deductions!$D$7,N8)","v":700},{"$f":"IF(A9=Deductions!$C$9,Deductions!$D$9,O8)","v":{"v":5000,"d":"5,000"}},{"$f":"IF(A9=Deductions!$C$10,Deductions!$D$10,P8)","v":100},null,{"$f":"IF(A9=Deductions!$C$11,Deductions!$D$11,R8)","v":100},{"$nulls":4},{"$f":"IF(A9=Deductions!B19,Deductions!C19,\"\")","v":103},{"$f":"SUM(J9:W9)","v":{"v":14203,"d":"14,203"}},{"$f":"SUM(I9-X9)","v":{"v":68837,"d":"68,837"}},{"$nulls":9},"May",69200]
["June",{"$f":"IF(A10='Master Sheet'!$A$13,'Master Sheet'!$B$13,B9)","v":{"v":69200,"d":"69,200"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B10=\"\",\"\",ROUND(B10*'DA HRA RATE'!$C8,0)))","v":{"v":8304,"d":"8,304"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B10=\"\",\"\",ROUND(B10*'DA HRA RATE'!$D8,0)))","v":{"v":5536,"d":"5,536"}},{"$f":"E9","v":""},{"$f":"F9","v":""},{"$f":"G9","v":""},{"$f":"H9","v":""},{"$f":"SUM(B10:H10)","v":{"v":83040,"d":"83,040"}},{"$f":"J9","v":{"v":3000,"d":"3,000"}},{"$f":"IF(A10=Deductions!$C$5,Deductions!$D$5,K9)","v":{"v":5100,"d":"5,100"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B10:C10)*10%,0)),\"\")","v":""},{"$f":"IF(A10=Deductions!$C$6,Deductions!$D$6,M9)","v":100},{"$f":"IF(A10=Deductions!$C$7,Deductions!$D$7,N9)","v":700},{"$f":"IF(A10=Deductions!$C$9,Deductions!$D$9,O9)","v":{"v":5000,"d":"5,000"}},{"$f":"IF(A10=Deductions!$C$10,Deductions!$D$10,P9)","v":100},null,{"$f":"IF(A10=Deductions!$C$11,Deductions!$D$11,R9)","v":100},{"$nulls":4},{"$f":"IF(A10=Deductions!B20,Deductions!C20,\"\")","v":104},{"$f":"SUM(J10:W10)","v":{"v":14204,"d":"14,204"}},{"$f":"SUM(I10-X10)","v":{"v":68836,"d":"68,836"}},{"$nulls":9},"June",69200]
["July",{"$f":"IF('Master Sheet'!$C$13=\"\",IF('Master Sheet'!$E$7=\"Yes\",$B$9,MROUND($B$9*1.03,100)),'Master Sheet'!$C$13)","v":{"v":71300,"d":"71,300"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B11=\"\",\"\",ROUND(B11*'DA HRA RATE'!$C9,0)))","v":{"v":8556,"d":"8,556"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B11=\"\",\"\",ROUND(B11*'DA HRA RATE'!$D9,0)))","v":{"v":5704,"d":"5,704"}},{"$f":"E10","v":""},{"$f":"F10","v":""},{"$f":"G10","v":""},{"$f":"H10","v":""},{"$f":"SUM(B11:H11)","v":{"v":85560,"d":"85,560"}},{"$f":"J10","v":{"v":3000,"d":"3,000"}},{"$f":"IF(A11=Deductions!$C$5,Deductions!$D$5,K10)","v":{"v":5500,"d":"5,500"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B11:C11)*10%,0)),\"\")","v":""},{"$f":"IF(A11=Deductions!$C$6,Deductions!$D$6,M10)","v":100},{"$f":"IF(A11=Deductions!$C$7,Deductions!$D$7,N10)","v":700},{"$f":"IF(A11=Deductions!$C$9,Deductions!$D$9,O10)","v":{"v":5000,"d":"5,000"}},{"$f":"IF(A11=Deductions!$C$10,Deductions!$D$10,P10)","v":100},null,{"$f":"IF(A11=Deductions!$C$11,Deductions!$D$11,R10)","v":100},{"$nulls":4},{"$f":"IF(A11=Deductions!B21,Deductions!C21,\"\")","v":105},{"$f":"SUM(J11:W11)","v":{"v":14605,"d":"14,605"}},{"$f":"SUM(I11-X11)","v":{"v":70955,"d":"70,955"}},{"$nulls":9},"July",71300]
["August",{"$f":"IF(A12='Master Sheet'!$A$13,'Master Sheet'!$B$13,B11)","v":{"v":71300,"d":"71,300"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B12=\"\",\"\",ROUND(B12*'DA HRA RATE'!$C10,0)))","v":{"v":8556,"d":"8,556"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B12=\"\",\"\",ROUND(B12*'DA HRA RATE'!$D10,0)))","v":{"v":5704,"d":"5,704"}},{"$f":"E11","v":""},{"$f":"F11","v":""},{"$f":"G11","v":""},{"$f":"H11","v":""},{"$f":"SUM(B12:H12)","v":{"v":85560,"d":"85,560"}},{"$f":"J11","v":{"v":3000,"d":"3,000"}},{"$f":"IF(A12=Deductions!$C$5,Deductions!$D$5,K11)","v":{"v":5500,"d":"5,500"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B12:C12)*10%,0)),\"\")","v":""},{"$f":"IF(A12=Deductions!$C$6,Deductions!$D$6,M11)","v":100},{"$f":"IF(A12=Deductions!$C$7,Deductions!$D$7,N11)","v":700},{"$f":"IF(A12=Deductions!$C$9,Deductions!$D$9,O11)","v":{"v":5000,"d":"5,000"}},{"$f":"IF(A12=Deductions!$C$10,Deductions!$D$10,P11)","v":100},null,{"$f":"IF(A12=Deductions!$C$11,Deductions!$D$11,R11)","v":100},{"$nulls":4},{"$f":"IF(A12=Deductions!B22,Deductions!C22,\"\")","v":106},{"$f":"SUM(J12:W12)","v":{"v":14606,"d":"14,606"}},{"$f":"SUM(I12-X12)","v":{"v":70954,"d":"70,954"}},{"$nulls":9},"August",71300]
["September",{"$f":"IF(A13='Master Sheet'!$A$13,'Master Sheet'!$B$13,B12)","v":{"v":71300,"d":"71,300"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B13=\"\",\"\",ROUND(B13*'DA HRA RATE'!$C11,0)))","v":{"v":8556,"d":"8,556"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B13=\"\",\"\",ROUND(B13*'DA HRA RATE'!$D11,0)))","v":{"v":5704,"d":"5,704"}},{"$f":"E12","v":""},{"$f":"F12","v":""},{"$f":"G12","v":""},{"$f":"H12","v":""},{"$f":"SUM(B13:H13)","v":{"v":85560,"d":"85,560"}},{"$f":"J12","v":{"v":3000,"d":"3,000"}},{"$f":"IF(A13=Deductions!$C$5,Deductions!$D$5,K12)","v":{"v":5500,"d":"5,500"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B13:C13)*10%,0)),\"\")","v":""},{"$f":"IF(A13=Deductions!$C$6,Deductions!$D$6,M12)","v":100},{"$f":"IF(A13=Deductions!$C$7,Deductions!$D$7,N12)","v":700},{"$f":"IF(A13=Deductions!$C$9,Deductions!$D$9,O12)","v":{"v":5000,"d":"5,000"}},{"$f":"IF(A13=Deductions!$C$10,Deductions!$D$10,P12)","v":100},null,{"$f":"IF(A13=Deductions!$C$11,Deductions!$D$11,R12)","v":100},{"$nulls":4},{"$f":"IF(A13=Deductions!B23,Deductions!C23,\"\")","v":107},{"$f":"SUM(J13:W13)","v":{"v":14607,"d":"14,607"}},{"$f":"SUM(I13-X13)","v":{"v":70953,"d":"70,953"}},{"$nulls":9},"September",71300]
["October",{"$f":"IF(A14='Master Sheet'!$A$13,'Master Sheet'!$B$13,B13)","v":{"v":71300,"d":"71,300"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B14=\"\",\"\",ROUND(B14*'DA HRA RATE'!$C12,0)))","v":{"v":8556,"d":"8,556"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B14=\"\",\"\",ROUND(B14*'DA HRA RATE'!$D12,0)))","v":{"v":5704,"d":"5,704"}},{"$f":"E13","v":""},{"$f":"F13","v":""},{"$f":"G13","v":""},{"$f":"H13","v":""},{"$f":"SUM(B14:H14)","v":{"v":85560,"d":"85,560"}},{"$f":"J13","v":{"v":3000,"d":"3,000"}},{"$f":"IF(A14=Deductions!$C$5,Deductions!$D$5,K13)","v":{"v":5500,"d":"5,500"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B14:C14)*10%,0)),\"\")","v":""},{"$f":"IF(A14=Deductions!$C$6,Deductions!$D$6,M13)","v":100},{"$f":"IF(A14=Deductions!$C$7,Deductions!$D$7,N13)","v":700},{"$f":"IF(A14=Deductions!$C$9,Deductions!$D$9,O13)","v":{"v":5000,"d":"5,000"}},{"$f":"IF(A14=Deductions!$C$10,Deductions!$D$10,P13)","v":100},null,{"$f":"IF(A14=Deductions!$C$11,Deductions!$D$11,R13)","v":100},{"$nulls":4},{"$f":"IF(A14=Deductions!B24,Deductions!C24,\"\")","v":108},{"$f":"SUM(J14:W14)","v":{"v":14608,"d":"14,608"}},{"$f":"SUM(I14-X14)","v":{"v":70952,"d":"70,952"}},{"$nulls":9},"October",71300]
["November",{"$f":"IF(A15='Master Sheet'!$A$13,'Master Sheet'!$B$13,B14)","v":{"v":71300,"d":"71,300"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B15=\"\",\"\",ROUND(B15*'DA HRA RATE'!$C13,0)))","v":{"v":8556,"d":"8,556"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B15=\"\",\"\",ROUND(B15*'DA HRA RATE'!$D13,0)))","v":{"v":5704,"d":"5,704"}},{"$f":"E14","v":""},{"$f":"F14","v":""},{"$f":"G14","v":""},{"$f":"H14","v":""},{"$f":"SUM(B15:H15)","v":{"v":85560,"d":"85,560"}},{"$f":"J14","v":{"v":3000,"d":"3,000"}},{"$f":"IF(A15=Deductions!$C$5,Deductions!$D$5,K14)","v":{"v":5500,"d":"5,500"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B15:C15)*10%,0)),\"\")","v":""},{"$f":"IF(A15=Deductions!$C$6,Deductions!$D$6,M14)","v":200},{"$f":"IF(A15=Deductions!$C$7,Deductions!$D$7,N14)","v":800},{"$f":"IF(A15=Deductions!$C$9,Deductions!$D$9,O14)","v":{"v":6000,"d":"6,000"}},{"$f":"IF(A15=Deductions!$C$10,Deductions!$D$10,P14)","v":200},null,{"$f":"IF(A15=Deductions!$C$11,Deductions!$D$11,R14)","v":200},{"$nulls":4},{"$f":"IF(A15=Deductions!B25,Deductions!C25,\"\")","v":109},{"$f":"SUM(J15:W15)","v":{"v":16009,"d":"16,009"}},{"$f":"SUM(I15-X15)","v":{"v":69551,"d":"69,551"}},{"$nulls":9},"November",71300]
["December",{"$f":"IF(A16='Master Sheet'!$A$13,'Master Sheet'!$B$13,B15)","v":{"v":71300,"d":"71,300"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B16=\"\",\"\",ROUND(B16*'DA HRA RATE'!$C14,0)))","v":{"v":8556,"d":"8,556"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B16=\"\",\"\",ROUND(B16*'DA HRA RATE'!$D14,0)))","v":{"v":5704,"d":"5,704"}},{"$f":"E15","v":""},{"$f":"F15","v":""},{"$f":"G15","v":""},{"$f":"H15","v":""},{"$f":"SUM(B16:H16)","v":{"v":85560,"d":"85,560"}},{"$f":"J15","v":{"v":3000,"d":"3,000"}},{"$f":"IF(A16=Deductions!$C$5,Deductions!$D$5,K15)","v":{"v":5500,"d":"5,500"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B16:C16)*10%,0)),\"\")","v":""},{"$f":"IF(A16=Deductions!$C$6,Deductions!$D$6,M15)","v":200},{"$f":"IF(A16=Deductions!$C$7,Deductions!$D$7,N15)","v":800},{"$f":"IF(A16=Deductions!$C$9,Deductions!$D$9,O15)","v":{"v":6000,"d":"6,000"}},{"$f":"IF(A16=Deductions!$C$10,Deductions!$D$10,P15)","v":200},null,{"$f":"IF(A16=Deductions!$C$11,Deductions!$D$11,R15)","v":200},{"$nulls":4},{"$f":"IF(A16=Deductions!B26,Deductions!C26,\"\")","v":110},{"$f":"SUM(J16:W16)","v":{"v":16010,"d":"16,010"}},{"$f":"SUM(I16-X16)","v":{"v":69550,"d":"69,550"}},{"$nulls":9},"December",71300]
["January",{"$f":"IF(A17='Master Sheet'!$A$13,'Master Sheet'!$B$13,B16)","v":{"v":71300,"d":"71,300"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B17=\"\",\"\",ROUND(B17*'DA HRA RATE'!$C15,0)))","v":{"v":8556,"d":"8,556"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B17=\"\",\"\",ROUND(B17*'DA HRA RATE'!$D15,0)))","v":{"v":5704,"d":"5,704"}},{"$f":"E16","v":""},{"$f":"F16","v":""},{"$f":"G16","v":""},{"$f":"H16","v":""},{"$f":"SUM(B17:H17)","v":{"v":85560,"d":"85,560"}},{"$f":"J16","v":{"v":3000,"d":"3,000"}},{"$f":"IF(A17=Deductions!$C$5,Deductions!$D$5,K16)","v":{"v":5500,"d":"5,500"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B17:C17)*10%,0)),\"\")","v":""},{"$f":"IF(A17=Deductions!$C$6,Deductions!$D$6,M16)","v":200},{"$f":"IF(A17=Deductions!$C$7,Deductions!$D$7,N16)","v":800},{"$f":"IF(A17=Deductions!$C$9,Deductions!$D$9,O16)","v":{"v":6000,"d":"6,000"}},{"$f":"IF(A17=Deductions!$C$10,Deductions!$D$10,P16)","v":200},null,{"$f":"IF(A17=Deductions!$C$11,Deductions!$D$11,R16)","v":200},{"$nulls":4},{"$f":"IF(A17=Deductions!B27,Deductions!C27,\"\")","v":111},{"$f":"SUM(J17:W17)","v":{"v":16011,"d":"16,011"}},{"$f":"SUM(I17-X17)","v":{"v":69549,"d":"69,549"}},{"$nulls":9},"January",71300]
["February",{"$f":"IF(A18='Master Sheet'!$A$13,'Master Sheet'!$B$13,B17)","v":{"v":71300,"d":"71,300"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B18=\"\",\"\",ROUND(B18*'DA HRA RATE'!$C16,0)))","v":{"v":8556,"d":"8,556"}},{"$f":"IF('Master Sheet'!$E$7=\"Yes\",\"\",IF(B18=\"\",\"\",ROUND(B18*'DA HRA RATE'!$D16,0)))","v":{"v":5704,"d":"5,704"}},{"$f":"E17","v":""},{"$f":"F17","v":""},{"$f":"G17","v":""},{"$f":"H17","v":""},{"$f":"SUM(B18:H18)","v":{"v":85560,"d":"85,560"}},{"$f":"J17","v":{"v":3000,"d":"3,000"}},{"$f":"IF(A18=Deductions!$C$5,Deductions!$D$5,K17)","v":{"v":5500,"d":"5,500"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B18:C18)*10%,0)),\"\")","v":""},{"$f":"IF(A18=Deductions!$C$6,Deductions!$D$6,M17)","v":200},{"$f":"IF(A18=Deductions!$C$7,Deductions!$D$7,N17)","v":800},{"$f":"IF(A18=Deductions!$C$9,Deductions!$D$9,O17)","v":{"v":6000,"d":"6,000"}},{"$f":"IF(A18=Deductions!$C$10,Deductions!$D$10,P17)","v":200},null,{"$f":"IF(A18=Deductions!$C$11,Deductions!$D$11,R17)","v":200},{"$nulls":4},{"$f":"IF(A18=Deductions!B28,Deductions!C28,\"\")","v":112},{"$f":"SUM(J18:W18)","v":{"v":16012,"d":"16,012"}},{"$f":"SUM(I18-X18)","v":{"v":69548,"d":"69,548"}},{"$nulls":9},"February",71300]
["DA Arrear",null,{"v":4152,"d":"4,152"},{"$nulls":5},{"$f":"SUM(B19:H19)","v":{"v":4152,"d":"4,152"}},null,{"$f":"IF('Master Sheet'!$E$5=\"NPS\",\"\",I19)","v":{"v":4152,"d":"4,152"}},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B19:C19)*10%,0)),\"\")","v":""},{"$nulls":11},{"$f":"SUM(J19:W19)","v":{"v":4152,"d":"4,152"}},{"$f":"SUM(I19-X19)","v":0}]
["DA Arrear",{"$nulls":7},{"$f":"SUM(B20:H20)","v":0},null,{"$f":"IF('Master Sheet'!$E$5=\"NPS\",\"\",I20)","v":0},{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B20:C20)*10%,0)),\"\")","v":""},{"$nulls":11},{"$f":"SUM(J20:W20)","v":0},{"$f":"SUM(I20-X20)","v":0}]
["Bonus",{"$f":"IF('Master Sheet'!$D$11=\"Yes\",ROUND(6774/12*'Master Sheet'!$E$11,0),\"\")","v":""},{"$nulls":6},{"$f":"SUM(B21:H21)","v":0},{"$nulls":14},{"$f":"SUM(J21:W21)","v":0},{"$f":"SUM(I21-X21)","v":0}]
["Surrender",{"$f":"ROUND(VLOOKUP($AI$6,$AI$7:$AJ$18,2,0)/2,0)","v":{"v":35650,"d":"35,650"}},{"$f":"ROUND(VLOOKUP($AI$6,Table1[[#All],[Month]:[DA Rate]],2,0)*B22,0)","v":{"v":4278,"d":"4,278"}},{"$nulls":5},{"$f":"SUM(B22:H22)","v":{"v":39928,"d":"39,928"}},{"$nulls":14},{"$f":"SUM(J22:W22)","v":0},{"$f":"SUM(I22-X22)","v":{"v":39928,"d":"39,928"}}]
["Fixa. Arrear",{"$nulls":7},{"$f":"SUM(B23:H23)","v":0},null,null,{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B23:C23)*10%,0)),\"\")","v":""},{"$nulls":11},{"$f":"SUM(J23:W23)","v":0},{"$f":"SUM(I23-X23)","v":0}]
["Other",{"$nulls":7},{"$f":"SUM(B24:H24)","v":0},null,null,{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B24:C24)*10%,0)),\"\")","v":""},{"$nulls":11},{"$f":"SUM(J24:W24)","v":0},{"$f":"SUM(I24-X24)","v":0}]
["Salary Arrear1",{"$nulls":7},{"$f":"SUM(B25:H25)","v":0},null,null,{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B25:C25)*10%,0)),\"\")","v":""},{"$nulls":11},{"$f":"SUM(J25:W25)","v":0},{"$f":"SUM(I25-X25)","v":0}]
["Salary Arrear2",{"$nulls":7},{"$f":"SUM(B26:H26)","v":0},null,null,{"$f":"IFERROR(IF('Master Sheet'!$E$5=\"GPF\",\"\",ROUND(SUM(B26:C26)*10%,0)),\"\")","v":""},{"$nulls":11},{"$f":"SUM(J26:W26)","v":0},{"$f":"SUM(I26-X26)","v":0}]
["Total",{"$f":"SUM(B7:B26)","v":{"v":882850,"d":"882,850"}},{"$f":"SUM(C7:C26)","v":{"v":110094,"d":"110,094"}},{"$f":"SUM(D7:D26)","v":{"v":67776,"d":"67,776"}},{"$f":"SUM(E7:E26)","v":0},{"$f":"SUM(F7:F26)","v":0},{"$f":"SUM(G7:G26)","v":0},{"$f":"SUM(H7:H26)","v":0},{"$f":"SUM(I7:I26)","v":{"v":1060720,"d":"1,060,720"}},{"$f":"SUM(J7:J26)","v":{"v":36000,"d":"36,000"}},{"$f":"SUM(K7:K26)","v":{"v":68552,"d":"68,552"}},{"$f":"SUM(L7:L26)","v":0},{"$f":"SUM(M7:M26)","v":{"v":1600,"d":"1,600"}},{"$f":"SUM(N7:N26)","v":{"v":8800,"d":"8,800"}},{"$f":"SUM(O7:O26)","v":{"v":64000,"d":"64,000"}},{"$f":"SUM(P7:P26)","v":{"v":1600,"d":"1,600"}},{"$f":"SUM(Q7:Q26)","v":220},{"$f":"SUM(R7:R26)","v":{"v":1600,"d":"1,600"}},0,0,0,0,{"$f":"SUM(W7:W26)","v":{"v":1278,"d":"1,278"}},{"$f":"SUM(X7:X26)","v":{"v":183650,"d":"183,650"}},{"$f":"SUM(Y7:Y26)","v":{"v":877070,"d":"877,070"}},0]
[]
[]
["Signature Of Employee",{"$nulls":22},"Signature Of DDO"]