EXCEL SPREAD SHEET DESIGN:
DATA ENTRY FIELDS, GRAPHS AND PRESENTATION
I need to effectively measure clients progress and present this to them in a professional looking graph for various strength and aerobic exercises.
Attached IPPT excel sheet draft with data entry fields and corresponding chart to measure progress with key and trend lines.
• In the existing setup I’ve listed my strength exercises below the data entry fields. These are the exercises I want to track progress for clients by date (x) and weight values (y) in the graphs axis's and must be added to the data entry fields.
• Below the strength based exercises I’ve listed the aerobic exercises I want to track progress for clients by date (x) and either distance (y) or time (y) values in the graphs axis's and must be added to the data entry fields
NOTE: Due to there been a distance (y) and a time (y) graph axis we require two graph's for the aerobic exercises.
NOTE: Require separate excel sheets for strength and aerobic exercises if required we could have 1-2 for aerobic exercises.
Require those strength and aerobic exercise fields but also the ability to add more easily which will be incorporated into the graph.
All exercises listed must have:
Data entry field
Key on graph
Specific trend line on graph (as per the existing)
Should be able to show a printed PDF presentation of this information for the table and graph based progress in a professional manner with company logo (to be provided).
Existing setup linked to the graph extends axis when you add higher weight values (y) e.g. 180kg. The graph will automatically increase the value of the graph on the y axis. This must be the case for all other data entry fields added and new ones.
Attached existing excel sheet setup with further information. Require this to be modified as detailed above and built with additional exercises listed.
33 freelancers are bidding on average $142 for this job
Hello I am with more than 3 years experience and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expectations. Regards