sharon mascarenhas
2

Hi HR Fraternity, I need help creating a point factor job evaluation format in Excel. Can anyone share the samples if you have them, please?
From India, Bangalore
priyaslakshmi1905@gmail.com
10

Dear Sharon Mascarenhas,

I hope the below discussions will help you :

https://www.citehr.com/138889-need-help-determining-package-hr-profile.html#post587892
https://www.citehr.com/441173-job-evaluation-methods-docx-download.html#post1993722

Designing a point factor job evaluation format can be a somewhat intricate task, as it necessitates a deeper understanding of the requirements. However, I can provide you with a fundamental template to initiate the process. It's essential to recognize that the details and structure of your point factor evaluation system can vary according to your organization's unique demands and industry.

Job Evaluation Point Factor Template
-------------------------------------------------------------------------------------
You can create a excel with the following columns:
Job Evaluation Format:
1. Job Information:
• Job Title
• Job Code
• Department
• Date
2. Job Factors:
• List all the factors that influence a job's value. Common factors include:
• Skill Requirements
• Responsibility
• Decision-Making Authority
• Working Conditions
• Physical Effort
• Mental Effort
• Experience Required
• Supervision
• etc.
3. Factor Weightings:
• Assign a weight to each factor. The weights should add up to 100% to represent their importance in the job evaluation process.
4. Factor Ratings:
• For each factor, create a column to enter ratings. You can use a scale (e.g., 1-5) or a description (e.g., Poor, Fair, Good, Excellent) to rate each factor.
5. Subtotal:
• Calculate a subtotal for each job by multiplying the factor rating by its weighting.
6. Total Points:
• Sum the subtotals to get a total point value for the job.

Attaching a sample for reference

From India, Kochi
Attached Files (Download Requires Membership)
File Type: xlsx point factor.xlsx (10.9 KB, 48 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.