Excel expert

This project was awarded to priyal1997 for $40 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
Project Description

My company currently uses Excel to generate individual health reports. We are seeking a person with extensive experience with Excel to modify this workbook to update its contents, modify its appearance and modify the generated report.

In brief, there is a single workbook for each patient assessed. Each time the patient is assessed, the new data is entered and this is then compared graphically with past assessments for that patient. The workbook contains the following pages/worksheets:-
1. 2 pages of data entry (demographics, health findings and measurements)
2. 1 page showing outcome of cardiac risk
3. 1 page summary of results
4. 1 page of multiple graphs showing specific results for each assessment
5. 1 page to create a letter
6. 1 page follow up plans for the patient
7. 2 pages of results summarised comparing current the last assessment
8. Another fitness page
9. Page of normative values for estimate of where the person fits at their age/sex
10. Summary of all results for each assessment in a spreadsheet
11. Stress graph
12. Audio graph
13. PCW170 data
14. VO max data
15. Sum of 6 data
16. Controls page

The changes required:-

• Change the colour scheme
• Update the entry data – some data is no longer of use and needs to be replaced with updated items
• Update the normative values
• Change the cardiac risk estimation data to a different set of values based on the Framingham data
• For the trends graph, modify the graph to display shade areas for the normal data and orange and then red areas for abnormal data, some of this will rely on data from tables relating to changing age
• Change the letter page to a written summary of advice page
• Remove the PCW170 data page and sum of 6 page
• Update the controls page

Please see the attached file.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online