What is Computer

Module: M3-R5: Python Programming

Chapter: Ch1 Computer Intro

💼 Employee Salary Sheet Example

  This spreadsheet shows how to calculate 
  DA (Dearness Allowance), 
  HRA (House Rent Allowance), 
  PF (Provident Fund), 
  EPF (Employees’ Provident Fund), 
  Gross Salary, 
  Net Salary, 
  Annual Salary, and 
  Tax (as per current Indian Income Tax Slabs) 
  automatically in Excel or LibreOffice Calc.
📊 Salary Sheet Data
Emp ID Employee Name Basic (₹) DA (10%) HRA (20%) PF (12%) EPF (3%) Gross Salary Net Salary Annual Salary Tax (As per Slab)
E001Aarav Patel35000=C2*10%=C2*20%=C2*12%=C2*3%=C2+D2+E2=G2-(F2+H2)=I2*12=IF(J2<=300000,0,IF(J2<=600000,(J2-300000)*5%,IF(J2<=900000,15000+(J2-600000)*10%,IF(J2<=1200000,45000+(J2-900000)*15%,IF(J2<=1500000,90000+(J2-1200000)*20%,150000+(J2-1500000)*30%))))))
E002Priya Sharma42000=C3*10%=C3*20%=C3*12%=C3*3%=C3+D3+E3=G3-(F3+H3)=I3*12=IF(J3<=300000,0,IF(J3<=600000,(J3-300000)*5%,IF(J3<=900000,15000+(J3-600000)*10%,IF(J3<=1200000,45000+(J3-900000)*15%,IF(J3<=1500000,90000+(J3-1200000)*20%,150000+(J3-1500000)*30%))))))
E003Rohit Verma50000=C4*10%=C4*20%=C4*12%=C4*3%=C4+D4+E4=G4-(F4+H4)=I4*12=IF(J4<=300000,0,IF(J4<=600000,(J4-300000)*5%,IF(J4<=900000,15000+(J4-600000)*10%,IF(J4<=1200000,45000+(J4-900000)*15%,IF(J4<=1500000,90000+(J4-1200000)*20%,150000+(J4-1500000)*30%))))))
E004Sneha Iyer28000=C5*10%=C5*20%=C5*12%=C5*3%=C5+D5+E5=G5-(F5+H5)=I5*12=IF(J5<=300000,0,IF(J5<=600000,(J5-300000)*5%,IF(J5<=900000,15000+(J5-600000)*10%,IF(J5<=1200000,45000+(J5-900000)*15%,IF(J5<=1500000,90000+(J5-1200000)*20%,150000+(J5-1500000)*30%))))))
E005Karan Singh60000=C6*10%=C6*20%=C6*12%=C6*3%=C6+D6+E6=G6-(F6+H6)=I6*12=IF(J6<=300000,0,IF(J6<=600000,(J6-300000)*5%,IF(J6<=900000,15000+(J6-600000)*10%,IF(J6<=1200000,45000+(J6-900000)*15%,IF(J6<=1500000,90000+(J6-1200000)*20%,150000+(J6-1500000)*30%))))))
E006Neha Gupta75000=C7*10%=C7*20%=C7*12%=C7*3%=C7+D7+E7=G7-(F7+H7)=I7*12=IF(J7<=300000,0,IF(J7<=600000,(J7-300000)*5%,IF(J7<=900000,15000+(J7-600000)*10%,IF(J7<=1200000,45000+(J7-900000)*15%,IF(J7<=1500000,90000+(J7-1200000)*20%,150000+(J7-1500000)*30%))))))
E007Arjun Das90000=C8*10%=C8*20%=C8*12%=C8*3%=C8+D8+E8=G8-(F8+H8)=I8*12=IF(J8<=300000,0,IF(J8<=600000,(J8-300000)*5%,IF(J8<=900000,15000+(J8-600000)*10%,IF(J8<=1200000,45000+(J8-900000)*15%,IF(J8<=1500000,90000+(J8-1200000)*20%,150000+(J8-1500000)*30%))))))
E008Pooja Mehta120000=C9*10%=C9*20%=C9*12%=C9*3%=C9+D9+E9=G9-(F9+H9)=I9*12=IF(J9<=300000,0,IF(J9<=600000,(J9-300000)*5%,IF(J9<=900000,15000+(J9-600000)*10%,IF(J9<=1200000,45000+(J9-900000)*15%,IF(J9<=1500000,90000+(J9-1200000)*20%,150000+(J9-1500000)*30%))))))
E009Rakesh Kumar155000=C10*10%=C10*20%=C10*12%=C10*3%=C10+D10+E10=G10-(F10+H10)=I10*12=IF(J10<=300000,0,IF(J10<=600000,(J10-300000)*5%,IF(J10<=900000,15000+(J10-600000)*10%,IF(J10<=1200000,45000+(J10-900000)*15%,IF(J10<=1500000,90000+(J10-1200000)*20%,150000+(J10-1500000)*30%))))))
E010Divya Nair180000=C11*10%=C11*20%=C11*12%=C11*3%=C11+D11+E11=G11-(F11+H11)=I11*12=IF(J11<=300000,0,IF(J11<=600000,(J11-300000)*5%,IF(J11<=900000,15000+(J11-600000)*10%,IF(J11<=1200000,45000+(J11-900000)*15%,IF(J11<=1500000,90000+(J11-1200000)*20%,150000+(J11-1500000)*30%))))))
📘 Explanation of Formulas
  • =C2*10% → Calculates DA (10% of Basic).
  • =C2*20% → Calculates HRA (20% of Basic).
  • =C2*12% → Calculates PF (12% deduction).
  • =C2*3% → Calculates EPF (Employer contribution).
  • =C2+D2+E2 → Gross Salary = Basic + DA + HRA.
  • =G2-(F2+H2) → Net Salary = Gross - (PF + EPF).
  • =I2*12 → Annual Salary = Net × 12.
  • =IF(...) → Calculates tax based on the new Indian slab system.
💡 Tax Slabs (New Regime 2025–26)
Income Range (₹)Tax Rate
Up to 3,00,000Nil
3,00,001 – 6,00,0005%
6,00,001 – 9,00,00010%
9,00,001 – 12,00,00015%
12,00,001 – 15,00,00020%
Above 15,00,00030%
🏁 Conclusion

This Salary Sheet can be used in Excel or LibreOffice Calc to automate salary and tax calculations. By changing the basic salary, all dependent values update instantly — saving HR departments valuable time.

O Level Modules

Quick Links