{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Welcome","1. Employer information","2. Job roles information","3. Gender representation","4. Factor and subfactor plan","5. Additional subfactors","6. Graduated factor comparison","7. Pay structure "],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Enable macros ",null,"When using this Excel worksheet for the first time, please enable macros. Press 'Yes' to make this file a trusted document.\n"]
[null,null,null,null," If you did not enable macros, close the file and open again, then click 'Enable content'. "]
[]
[null,null,"Worksheet for simplified gender-neutral job evaluation approach for micro-organisations"]
[]
[null,null,"Conducting the gender-neutral job evaluation using the graduated factor comparison method"]
[]
[]
[null,null,"Before you get started: "]
[null,null,"Read the use guidance provided in Tool 3"]
[null,null,"Get familiar with the Factor and Subfactor plan provided in the toolkit"]

{"sheet":"1. Employer information","index":1,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,2,4,3],[6,2,6,3],[8,1,9,1],[9,2,9,3]]}
[]
[null,"Employer information "]
[]
[]
[null,"Name of organisation:"]
[]
[null,"Start date: "]
[]
[null,"Job evaluation committee meeting date: "]
[]
[]
[null,"Job evaluator (main):"]
[]
[null,"Other job evaluation committee members (if any):"]
[]
[null,"Completion date:"]

{"sheet":"2. Job roles information","index":2,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,2,3,5],[5,1,5,4]]}
[]
[null,"List of jobs and job information "]
[]
[null,"Instructions: ","Gather information about existing jobs in your organisation and fill in the table below. "]
[]
[null,"This information might come from job descriptions or previous job ads. "]
[null,"It may also come from various internal sources such as workers’ files, contracts, payroll records, job advertisements, manager notes, collective agreements and organisational charts. "]
[null,"You can read more on this in TOOL 2."]
[]
[null,"No. ","Role","Job description","Employment type","Department ","Place of work","Reporting line","Total pay (annual )","Bonuses / allowances","Historical pay notes","Other observations"]
[null,1,"Owner / Shop manager","Oversees the overall operation, performance and sustainability of the flower shop, managing staff, finances and customer relationships.","Full-time","Senior Management","Office","N/A",37600,"None","Pay increased 5% last year","Recently updated job description"]
[null,2,"Florist / Senior salesperson","Creates floral arrangements, manages customer relations, and ensures smooth day-to-day operations of the shop. This role combines creative floral design with a customer-focused sales approach to drive business success and ensure customer satisfaction","Full-time","Administration","Office","Reports to Shop manager",28000,"None","Pay increased 5% last year"]
[null,3,"Shop assistant","Provides front-of-house customer service, manages in-store and online sales, and assists with basic floral arrangements.","Full-time","Administration","Office","Reports to Shop manager",19900,"None"]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[]
[]
[null,"Add more rows as needed. Double check that all tabs in this Worksheet have enough rows for the number of job roles that you are evaluating. "]
[null,"Spread the formulas embedded in cells on all rows that you add. Each tab provides tips on this, where relevant."]

{"sheet":"3. Gender representation","index":3,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Job roles and gender"]
[]
[null,null,"Instructions: ","1. All distinct job roles within the organisation should be listed automatically for you, based on information provided in the previous tab."]
[null,null,null,"2. Identify the gender of the current job holders for each job"]
[null,null,null,"3. Identify if any job roles are women-dominated (put an X) or men-dominated (leave the cell empty) based on workforce distribution."]
[]
[null,"Your organisation"]
[null,"Ref.","Job / Job role:","N","Women (n)","Men         (n)","Women-dominated?"]
[null,1,{"$f":"IFERROR(IF('2. Job roles information'!C11=0,\"\",'2. Job roles information'!C11), \"\")","v":"Owner / Shop manager"},1,1,null,"X"]
[null,2,{"$f":"IFERROR(IF('2. Job roles information'!C12=0,\"\",'2. Job roles information'!C12), \"\")","v":"Florist / Senior salesperson"},1,1,null,"X"]
[null,3,{"$f":"IFERROR(IF('2. Job roles information'!C13=0,\"\",'2. Job roles information'!C13), \"\")","v":"Shop assistant"},3,1,2]
[null,4,{"$f":"IFERROR(IF('2. Job roles information'!C14=0,\"\",'2. Job roles information'!C14), \"\")","v":""}]
[null,5,{"$f":"IFERROR(IF('2. Job roles information'!C15=0,\"\",'2. Job roles information'!C15), \"\")","v":""}]
[null,6,{"$f":"IFERROR(IF('2. Job roles information'!C16=0,\"\",'2. Job roles information'!C16), \"\")","v":""}]
[null,7,{"$f":"IFERROR(IF('2. Job roles information'!C17=0,\"\",'2. Job roles information'!C17), \"\")","v":""}]
[null,8,{"$f":"IFERROR(IF('2. Job roles information'!C18=0,\"\",'2. Job roles information'!C18), \"\")","v":""}]
[null,9,{"$f":"IFERROR(IF('2. Job roles information'!C19=0,\"\",'2. Job roles information'!C19), \"\")","v":""}]
[null,10,{"$f":"IFERROR(IF('2. Job roles information'!C20=0,\"\",'2. Job roles information'!C20), \"\")","v":""}]

{"sheet":"4. Factor and subfactor plan","index":4,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":false,"merged":[[18,1,22,1],[23,1,26,1],[27,1,29,1],[30,1,31,1],[36,1,45,1]]}
[]
[null,"Factor and subfactor plan"]
[]
[null,"Before starting:","Make sure you understand the graduated factor comparison method (Step-by-step toolkit, TOOL 3)"]
[]
[null,"Information: ","This factor and subfactor plan is your scoring guide."]
[null,null,"It contains the essential criteria to evaluate any job (skills, responsibility, effort and working conditions)."]
[null,null,"Each of these is broken down into subfactors with different levels of complexity (see second table below)"]
[]
[null,"Instructions: ","1. Read this plan carefully and think about what each factor and subfactor mean in the context of your organisation."]
[null,null,"2. Start with the four main factors. "]
[null,null,"3. Review the subfactor list - which are most relevant to your organisation?"]
[null,null,"4. Which of these subfactors highlight the most significant differences between the jobs in my organisation?"]
[null,null,"5. Pay attention to often overlooked or undervalued aspects of jobs."]
[null,null,"6. Create a shortlist of subfactors based on your review. Uncheck the subfators which you do not want to include in your shortlist."]
[]
[null,"*Click on the cell of the factor / subfactor to see an explanation / description"]
[null,"Factors","Subfactors","Chosen for evaluation"]
[null,"Skills","Knowledge",true]
[null,null,"Interpersonal and communication skills",true]
[null,null,"Problem-solving skills",true]
[null,null,"Planning and organisational skills ",true]
[null,null,"Physical skills",true]
[null,"Responsibility","People",true]
[null,null,"Goods and equipment ",true]
[null,null,"Information",true]
[null,null,"Financial resources",true]
[null,"Effort","Mental effort",true]
[null,null,"Psycho-social and emotional effort",true]
[null,null,"Physical effort",true]
[null,"Working conditions ","Environment (physical, psychological or emotional)",true]
[null,null,"Organisational environment",true]
[]
[]
[null,"Levels per subfactor  ","*Click on the number under each subfactor to see an explanation"]
[]
[null,"Levels (0 = lowest level, not applicable - 5 = highly advanced or sophisticated requirements)","Knowledge","Interpersonal and communication skills","Problem-solving skills","Planning and organisational skills ","Physical skills","People","Goods and equipment ","Information","Financial resources","Mental effort","Psycho-social and emotional effort","Physical effort","Environment (physical, psychological or emotional) working conditions","Organisational environment working conditions"]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
[null,null,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
[null,null,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
[null,null,6]
[null,null,7]
[null,null,8]

{"sheet":"5. Additional subfactors","index":5,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[11,1,16,1],[20,1,25,1],[29,1,34,1],[39,1,44,1]]}
[]
[null,"Additional subfactors"]
[]
[null,"Instructions:","1. If you consider you need to add additional subfactors to reflect the needs of your company, use the tables below. "]
[null,null,"2. Insert a definition of the additional subfactor(s), as well as the definition of each level. "]
[]
[]
[null,null,"Remember: all additional subfactors need to be methodological (that is, follow a consistent and structured approach) and not have any gender bias."]
[]
[]
[null,"Additional subfactor: Skills","Levels","Points","Definition","Adding this subfactor to your evaluation? "]
[null,"Definition…",0,0]
[null,null,1,{"$f":"$D$17/5*C13","v":0}]
[null,null,2,{"$f":"$D$17/5*C14","v":0},null,false]
[null,null,3,{"$f":"$D$17/5*C15","v":0}]
[null,null,4,{"$f":"$D$17/5*C16","v":0}]
[null,null,5,{"$f":"'[1]4. Factor and subfactor plan'!D35","v":0}]
[]
[]
[null,"Additional subfactor: Responsability","Levels","Points","Definition","Adding this subfactor to your evaluation? "]
[null,"Definition…",0,0]
[null,null,1,{"$f":"$D$26/5*C22","v":0}]
[null,null,2,{"$f":"$D$26/5*C23","v":0},null,false]
[null,null,3,{"$f":"$D$26/5*C24","v":0}]
[null,null,4,{"$f":"$D$26/5*C25","v":0}]
[null,null,5,{"$f":"'[1]4. Factor and subfactor plan'!D41","v":0}]
[]
[]
[null,"Additional subfactor: Effort","Levels","Points","Definition","Adding this subfactor to your evaluation? "]
[null,"Definition…",0,0]
[null,null,1,{"$f":"$D$35/5*C31","v":0}]
[null,null,2,{"$f":"$D$35/5*C32","v":0},null,false]
[null,null,3,{"$f":"$D$35/5*C33","v":0}]
[null,null,4,{"$f":"$D$35/5*C34","v":0}]
[null,null,5,{"$f":"'[1]4. Factor and subfactor plan'!D46","v":0}]
[]
[]
[]
[null,"Additional subfactor: Working conditions","Levels","Points","Definition","Adding this subfactor to your evaluation? "]
[null,"Definition…",0,0]
[null,null,1,{"$f":"$D$45/5*C41","v":0}]
[null,null,2,{"$f":"$D$45/5*C42","v":0},null,false]
[null,null,3,{"$f":"$D$45/5*C43","v":0}]
[null,null,4,{"$f":"$D$45/5*C44","v":0}]
[null,null,5,{"$f":"'[1]4. Factor and subfactor plan'!D50","v":0}]

{"sheet":"6. Graduated factor comparison","index":6,"n_rows":26,"n_cols":22,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Graduated factor comparison "]
[]
[null,"Now, you will evaluate each job role, one at a time, using your shortlist of subfactors. "]
[]
[null,"Instructions: ","1. All  job roles in  your organisation and the list of subfactors you kept checked in the previous tab should be listed automatically for you."]
[null,null,"2. Compare each job to the levels (remember to read the descriptions for each level (0-5) for each subfactor."]
[null,null,"3. Record the level (0-5)."]
[null,null,"4. Document a brief justification, e.g. as a comment or in the format that you find suitable."]
[null,null,"5. Repeat for all subfactors and for all jobs."]
[null,null,"6. Once you have assigned a level to each subfactor for all your jobs, the table will automatically sum up the levels for each job giving you a total score.  "]
[]
[null,"No. ","Role","Knowledge","Interpersonal and communication skills","Problem-solving skills","Planning and organisational skills ","Physical skills","People","Goods and equipment","Information","Financial resources","Mental effort","Psycho-social and emotional effort","Physical effort","Environment (physical, psychological or emotional)","Organisational environment","Additional subfactor: Skills","Additional subfactor: Responsability","Additional subfactor: Effort","Additional subfactor: Working conditions","Total score"]
[null,1,{"$f":"IFERROR(IF('2. Job roles information'!C11=0,\"\",'2. Job roles information'!C11), \"\")","v":"Owner / Shop manager"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM(D14:U14)=0,\"\",SUM(D14:U14)),\"\")","v":""}]
[null,2,{"$f":"IFERROR(IF('2. Job roles information'!C12=0,\"\",'2. Job roles information'!C12), \"\")","v":"Florist / Senior salesperson"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM(D15:U15)=0,\"\",SUM(D15:U15)),\"\")","v":""}]
[null,3,{"$f":"IFERROR(IF('2. Job roles information'!C13=0,\"\",'2. Job roles information'!C13), \"\")","v":"Shop assistant"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,4,{"$f":"IFERROR(IF('2. Job roles information'!C14=0,\"\",'2. Job roles information'!C14), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,5,{"$f":"IFERROR(IF('2. Job roles information'!C15=0,\"\",'2. Job roles information'!C15), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,6,{"$f":"IFERROR(IF('2. Job roles information'!C16=0,\"\",'2. Job roles information'!C16), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,7,{"$f":"IFERROR(IF('2. Job roles information'!C17=0,\"\",'2. Job roles information'!C17), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,8,{"$f":"IFERROR(IF('2. Job roles information'!C18=0,\"\",'2. Job roles information'!C18), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,9,{"$f":"IFERROR(IF('2. Job roles information'!C19=0,\"\",'2. Job roles information'!C19), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,10,{"$f":"IFERROR(IF('2. Job roles information'!C20=0,\"\",'2. Job roles information'!C20), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM(D23:U23)=0,\"\",SUM(D23:U23)),\"\")","v":""}]
[]
[]
[null,"Before moving on, take a moment to review the results of your job evaluation and conduct a quick test for potential gender bias. Follow guidance in TOOL 3."]

{"sheet":"7. Pay structure ","index":7,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,1,4,15],[25,2,25,3],[24,2,24,3],[19,2,19,3],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[12,2,12,5],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3]]}
[]
[null,"Your pay structure"]
[]
[null,"You can now use the job ranking to create a simple and fair pay structure that ensures equal pay for equal work or work of equal value. You will also need to ensure this for any variable pay components. Follow the guidance from the toolkit on how to do this (TOOL 3, Step 5 and Step 6). Below, you can build your basic pay structure. "]
[]
[]
[]
[null,null,"Instructions:","1. Group jobs into pay grades based on the results of job evaluation (total score of the job) (e.g. Grade 1 for the job(s) that the score the lowest, and so on). "]
[null,null,null,"For a microenterprise, you will likely only need 2-4 pay grades. "]
[null,null,null,"2. Define pay ranges for each grade, setting clear minimums and maximums with logical progression. (Refer to toolkit for more guidance)"]
[]
[]
[null,null,"INPUTS"]
[null,null,"Minimum Salary (€)"]
[null,null,"Maximum Salary (€)"]
[null,null,"Number of grades"]
[null,null,"Progression Factor"]
[]
[]
[null,null,"Grade",null,"Min Salary","Midpoint","Max Salary "]
[null,null,null,null,"(€)","(€)","(€)"]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[]
[]
[null,null,"Once your job evaluation is complete, see if job titles and descriptions needs to be updated. "]
[null,null,"Make sure to explain these changes to workers and revise the job evaluation periodically."]