Excel Spreadsheet Builder for Graphing & Scoring - 26/07/2024 06:51 EDT
Budget: $15 – $25 AUD
I am in need of a proficient Microsoft Excel expert who can build a dynamic and user-friendly spreadsheet for me. The spreadsheet would be designed to graph numeric data inputs, specifically via line graphs, and to score these inputs based on a weighted average system.
The ideal freelancer for this job should:
- Be proficient with Microsoft Excel and visualization of data
- Understand numeric data structures and how they function in spreadsheets
- Have experience with implementing algorithms in Excel
I would expect the following from the spreadsheet:
Build a line graph based on the numeric data inputs
Multiple lines for multiple entries
Be able to easily switch on and off lines in the graph
Able to score these inputs based on a weighted average system
Line data from sheets (2) in the document
Experience in the mentioned areas will greatly contribute towards the successful completion of this project.
SCOPE OF WORKS
The purpose of this document is to compare the performance of certain team members in certain criteria.
A team member is scored in a criteria from a document not include here. Thise scores are manually entered in Sheet “Team Score” . Person 1 will be in column C, Person 2 in Column D, etc etc.
Each section has an average for the section, for example PERSONAL ATTRIBUTES cell C8 is the average of cells C9:C20
These scores for each area are then linked to Sheet ‘Comparable Score’
This score is graphed in the line graph to the right.
The scope of works for this exercise, is to present a user-friendly spreadsheet, that can enter the scores in sheet Team Score. The format of that sheet is not fixed and can be at your discretion, however the average of each criteria labelled “A” to “N” must be linked to Sheet Comparable Score to be graphed accordingly.
Sheet Comparable Score.
The format in Column B is fixed. It must be vertical .
Scope of Works is to present a line graph comparing all team members (currently Person 1 to Person 39) however 50 persons required.
A user friendly method of switching on and off team members (persons) is required.
The ideal freelancer for this job should:
- Be proficient with Microsoft Excel and visualization of data
- Understand numeric data structures and how they function in spreadsheets
- Have experience with implementing algorithms in Excel
I would expect the following from the spreadsheet:
Build a line graph based on the numeric data inputs
Multiple lines for multiple entries
Be able to easily switch on and off lines in the graph
Able to score these inputs based on a weighted average system
Line data from sheets (2) in the document
Experience in the mentioned areas will greatly contribute towards the successful completion of this project.
SCOPE OF WORKS
The purpose of this document is to compare the performance of certain team members in certain criteria.
A team member is scored in a criteria from a document not include here. Thise scores are manually entered in Sheet “Team Score” . Person 1 will be in column C, Person 2 in Column D, etc etc.
Each section has an average for the section, for example PERSONAL ATTRIBUTES cell C8 is the average of cells C9:C20
These scores for each area are then linked to Sheet ‘Comparable Score’
This score is graphed in the line graph to the right.
The scope of works for this exercise, is to present a user-friendly spreadsheet, that can enter the scores in sheet Team Score. The format of that sheet is not fixed and can be at your discretion, however the average of each criteria labelled “A” to “N” must be linked to Sheet Comparable Score to be graphed accordingly.
Sheet Comparable Score.
The format in Column B is fixed. It must be vertical .
Scope of Works is to present a line graph comparing all team members (currently Person 1 to Person 39) however 50 persons required.
A user friendly method of switching on and off team members (persons) is required.