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

{"sheet":"Master Sheet","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"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"]
["Meghraj Sharma","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"]

{"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]
["GPF Loan"]
["RPMF/RGHS"]
["SIP",3000]
["SIL",5000]
["SII"]
["LIC"]
["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","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":"MEGHRAJ SHARMA"},{"$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":13201,"d":"13201.00"}},{"$f":"SUM(I8-N8)","v":{"v":69839,"d":"69839.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":""},{"$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":""},{"$f":"Deductions!A11","v":"LIC"},{"$f":"IF(Deductions!B11=\"\",\"\",Deductions!B11)","v":""},{"$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":""},"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":13202,"d":"13202.00"}},{"$f":"SUM(I13-N13)","v":{"v":69838,"d":"69838.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":""},{"$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":""},"LIC",{"$f":"IF(A15=Deductions!$C$11,Deductions!$D$11,M10)","v":""},{"$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":""},"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":13203,"d":"13203.00"}},{"$f":"SUM(I18-N18)","v":{"v":69837,"d":"69837.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":""},{"$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":""},"LIC",{"$f":"IF(A20=Deductions!$C$11,Deductions!$D$11,M15)","v":""}]
[{"$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":""},"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":13204,"d":"13204.00"}},{"$f":"SUM(I23-N23)","v":{"v":69836,"d":"69836.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":""}]
["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":""},"LIC",{"$f":"IF(A25=Deductions!$C$11,Deductions!$D$11,M20)","v":""}]
[{"$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":""},"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'!$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":13205,"d":"13205.00"}},{"$f":"SUM(I28-N28)","v":{"v":72355,"d":"72355.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":5100,"d":"5100.00"}},"SII",{"$f":"IF(A30=Deductions!$C$10,Deductions!$D$10,M24)","v":""}]
["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":""},"LIC",{"$f":"IF(A30=Deductions!$C$11,Deductions!$D$11,M25)","v":""}]
[{"$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":""},"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":13206,"d":"13206.00"}},{"$f":"SUM(I33-N33)","v":{"v":72354,"d":"72354.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":5100,"d":"5100.00"}},"SII",{"$f":"IF(A35=Deductions!$C$10,Deductions!$D$10,M29)","v":""}]
["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":""},"LIC",{"$f":"IF(A35=Deductions!$C$11,Deductions!$D$11,M30)","v":""}]
[{"$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":""},"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":13207,"d":"13207.00"}},{"$f":"SUM(I40-N40)","v":{"v":72353,"d":"72353.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":5100,"d":"5100.00"}},{"$f":"L34","v":"SII"},{"$f":"IF(A42=Deductions!$C$10,Deductions!$D$10,M34)","v":""}]
["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":""},"LIC",{"$f":"IF(A42=Deductions!$C$11,Deductions!$D$11,M35)","v":""}]
[{"$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":""},"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":13208,"d":"13208.00"}},{"$f":"SUM(I45-N45)","v":{"v":72352,"d":"72352.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":5100,"d":"5100.00"}},{"$f":"L41","v":"SII"},{"$f":"IF(A47=Deductions!$C$10,Deductions!$D$10,M41)","v":""}]
["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":""},"LIC",{"$f":"IF(A47=Deductions!$C$11,Deductions!$D$11,M42)","v":""}]
[{"$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":""},"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":5000,"d":"5000.00"}},{"$f":"SUM(M50:M54,K50:K54)","v":{"v":13209,"d":"13209.00"}},{"$f":"SUM(I50-N50)","v":{"v":72351,"d":"72351.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":5100,"d":"5100.00"}},"SII",{"$f":"IF(A52=Deductions!$C$10,Deductions!$D$10,M46)","v":""}]
["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":""},"LIC",{"$f":"IF(A52=Deductions!$C$11,Deductions!$D$11,M47)","v":""}]
[{"$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":""},"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":5000,"d":"5000.00"}},{"$f":"SUM(M55:M59,K55:K59)","v":{"v":13210,"d":"13210.00"}},{"$f":"SUM(I55-N55)","v":{"v":72350,"d":"72350.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":5100,"d":"5100.00"}},"SII",{"$f":"IF(A57=Deductions!$C$10,Deductions!$D$10,M51)","v":""}]
["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":""},"LIC",{"$f":"IF(A57=Deductions!$C$11,Deductions!$D$11,M52)","v":""}]
[{"$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":""},"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":5000,"d":"5000.00"}},{"$f":"SUM(M60:M64,K60:K64)","v":{"v":13211,"d":"13211.00"}},{"$f":"SUM(I60-N60)","v":{"v":72349,"d":"72349.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":5100,"d":"5100.00"}},"SII",{"$f":"IF(A62=Deductions!$C$10,Deductions!$D$10,M56)","v":""}]
["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":""},"LIC",{"$f":"IF(A62=Deductions!$C$11,Deductions!$D$11,M57)","v":""}]
[{"$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":""},"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":5000,"d":"5000.00"}},{"$f":"SUM(M65:M69,K65:K69)","v":{"v":13212,"d":"13212.00"}},{"$f":"SUM(I65-N65)","v":{"v":72348,"d":"72348.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":5100,"d":"5100.00"}},"SII",{"$f":"IF(A67=Deductions!$C$10,Deductions!$D$10,M61)","v":""}]
["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":""},"LIC",{"$f":"IF(A67=Deductions!$C$11,Deductions!$D$11,M62)","v":""}]
[{"$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":""},"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":65352,"d":"65352.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":0,"d":"0.00"}]
[null,{"$f":"E70","v":"Bouns"},null,null,{"v":0,"d":"0.00"},null,"GPF Loan",null,{"v":0,"d":"0.00"}]
[null,{"$f":"E11","v":"Ot. Allow 1"},null,null,{"v":0,"d":"0.00"},null,"SIL",null,{"v":60000,"d":"60000.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":162630,"d":"162630.00"}},null,null,"Total Net Amount :",null,{"$f":"IFERROR(D96-I96,\"\")","v":{"v":898090,"d":"898090.00"}}]