We rounded up some of the simplest yet powerful MS Excel spreadsheet tips you can start using on your data.
- Use MS Excel Format Painter.
- Select Entire Spreadsheet Columns or Rows.
- Import Data Into Excel Correctly.
- Enter The Same Data Into Multiple Cells.
- Display Excel Spreadsheet Formulas.
- Freeze Excel Rows And Columns.
Salary Sheet is a document that includes complete details of the amount payable to an employee for work done during a particular period. It includes details like basic pay, allowances, deductions, and overtime, etc. of employees. Generally, Payroll is made daily for wages, weekly, biweekly, or monthly for salaries.
The formula to calculate salary per day is very simple. Start with the s*alary and divide by 52* to determine the weekly pay spread over the entire year. For example if you calculate that a $60,000 dollar per year salar*y* divided by 52 weeks, it will result in employee earnings of $1,153.85 dollars per week.
What Is Basic Salary?Definition, Formula & Income Tax
- Annual Basic = Monthly Basic X 12. Formula To Calculate Basic Salary.
- Gross Pay = Basic + DA + HRA + Conveyance + Medical + Other. Hence, to calculate your basic from the gross pay you need to do the reverse calculation.
- Basic = Gross Pay – DA – HRA – Conveyance – Medical – Other.
- Basic = Gross Pay X Percentage.
The total of basic pay and grade pay is used in assessing dearness and other allowances. How much is basic salary of CTC? Usually, basic salary is 40% to 50% of CTC (Cost to Company). Statutory components such as bonus, PF, gratuity and other benefits are determined on the basis of the basic salary.
- Open your income and expenses Excel worksheet.
- Select an empty cell beneath the last item in your "income" column.
- Type "Total Income" in this cell, then press the "Enter" key.
- Select the cell directly beneath the "Total Income" label.
- Type "=SUM(" into this empty cell.
A sign-in sheet, or sign-up sheet, is used to obtain information of visitors or guests to an event. Upon entering the location, the form will be present for the attendee to write their name, time (with date), and signature (if required).
How to make a sign-in sign-out sheet?
- Download a free template. To make things easier for you, download a template with the format you need.
- Add spaces of the date and the names. Upon the arrival of an attendee to your event, have them write down their name and the date.
- Ask your guests to sign the form.
- Present your form.
A sign-in sheet typically provides a numbered list where people can sign their names and give contact information or other relevant details. Interested parties can sign up to participate in an activity or simply receive information about an event, which helps to organize the planning process.
1 Answer
- No problem.
- I have to add l(which indicate late comer) also with attendance.So 'P' and 'l' also counted in total days present.Kindly help me in this. –
- In the next column across, use the same formula but with a l instead of P: =COUNTIF(B2:D2,"l") – Garrulinae Apr 16 '14 at 7:51.
Base days for monthly salary calculation
- Calendar days. This is probably the most widely adopted basis. In the calendar-day basis, the per-day pay is calculated as the total salary for the month divided by the total number of calendar days.
- Calendar days adjusted for Sundays. This is a variant of the Calendar day basis.
- Fixed number of days, such as 26 or 30.
The formula for measuring absenteeism is relatively easy: simply take the number of unexcused absences in a given period of time, divide it by the total period, and multiply the result by 100 to get the percentage of absenteeism over a month, a year, etc.
Add up the total number of days that should have been worked (or hours for variable hours employees). Work out the total number of days/hours lost to sickness absence. Divide the number of days/hours lost by the number that should have been worked. Multiply this result by 100 to calculate a sickness absence percentage.
Multiply the employee's daily salary by the number of unpaid days the employee took during the pay period. For example, assume the employee in the example took three unpaid days. The amount do deduct is $115.38 x 3 = $346.14.
Get the hours per months = Hours in Year ÷ 12 (months) Get Hourly Pay = Monthly Salary ÷ Hours Per Month. Get Daily Pay = Hourly Pay x Hours Per Day.
Annual employee leave entitlements are calculated via three steps:
- Calculate total annual leave hours. Multiply the total number of weeks an employee has worked by 2.923.
- Deduct leave. Deduct any annual leave the employee has already taken.
- Calculate the total amount that must be paid in annual leave.
To calculate unpaid leave:Find the number of working days in the current month. Use this figure to calculate how much the employee is paid daily (monthly salary/working days in month). Multiply this figure by the number of days of unpaid leave.
How to Calculate for the Daily Rate from Your Monthly Salary?
- (Basic Monthly Salary x 12) / (Total Working Days in a Year) = DAILY RATE.
- Important: The total working days in a year (TWD) may vary from one employee to another.
- Basic Salary: ₱ 23,000.
- Total Working Days in a Year: 261.
- (23,000 x 12) / (261) = ₱ 1,057.47.
- Basic Salary: ₱ 25,000.
- Total Working Days in a Year: 313.
Calculate Gross Salaryphp $sal=10000; $hra=($sal*5)/100; $gross_sal=$sal+$hra; echo " The Gross Salary is $gross_sal"; ?> Similarly you can try many programs.
