Excel expert

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 37

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.

Get free quotes for a project like this
Awarded to:
Skills Required

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