📊 Live Interactive Excel Sheet Calculator
Calculate your 7th CPC salary in real time using the official Excel formula model. You can modify any row in the spreadsheet below and click Download Excel Spreadsheet (.CSV / .XLSX) for offline use.
Interactive 7th CPC Salary Spreadsheet
| Cell | Salary Component | Formula / Basis | Rate / Value | Amount (₹) |
|---|---|---|---|---|
| A1 | 7th CPC Pay Level | Selected Grade | - | |
| A2 | Basic Pay | Matrix Entry Cell | ₹35,400 | |
| A3 | Dearness Allowance (DA) | =A2 * DA% |
₹18,762 | |
| A4 | House Rent Allowance (HRA) | =A2 * HRA% |
₹10,620 | |
| A5 | Transport Allowance (TA) | Pay Matrix Scale Level | ₹3,600 | ₹3,600 |
| A6 | DA on Transport Allowance | =A5 * DA% |
53% | ₹1,908 |
| A7 | GROSS SALARY | =SUM(A2:A6) |
Gross Earnings | ₹70,290 |
| B1 | NPS Employee Contribution | =(A2 + A3) * 10% |
10% of (Basic + DA) | -₹5,416 |
| B2 | CGEGIS Insurance | Group C/B/A | Fixed Tier | -₹60 |
| B3 | CGHS Medical Card | Level 1-18 Slabs | Fixed Slab | -₹450 |
| B4 | NET TAKE-HOME SALARY | =A7 - SUM(B1:B3) |
In-Hand Bank Credit | ₹64,364 |
Key Excel Formulas for 7th Pay Commission
If you are building your own office payroll spreadsheet, use these exact Microsoft Excel / Google Sheets formulas:
Gross Salary = SUM(Basic, DA, HRA, TA, DA_on_TA) DA = Basic * 0.53 HRA (X City) = Basic * 0.30 HRA (Y City) = Basic * 0.20 HRA (Z City) = Basic * 0.10 DA on TA = TA * 0.53 NPS Deduction = (Basic + DA) * 0.10 Net In-Hand Salary = Gross_Salary - NPS - CGEGIS - CGHS - Professional_Tax
Frequently Asked Questions
How can I download the 7th Pay Commission salary calculator in Excel?
You can click the "Download Excel Sheet (.CSV)" button on this page to immediately save the pre-calculated payroll template with formulas to your computer.
What is the formula for NPS in Excel for 7th CPC?
The standard NPS employee contribution formula is =ROUND((Basic_Pay + DA)*0.10, 0).
What HRA percentages should be used in 2026 Excel calculations?
Since Dearness Allowance exceeded 50%, HRA rates revised automatically to 30% for X-class cities, 20% for Y-class cities, and 10% for Z-class cities.