Excel expert

In Progress

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.

Skills: Data Entry, Data Processing, Excel

See more: patient data entry, max graph, letter of advice, letter expert, graphs uses, follow up letter, file excel expert, expert with excel, expert advice, excel expert up, excel expert advice, estimation in excel, data entry experience letter, data entry controls, data entry assessment, contents of the letter, uses for excel, excel uses, letter of contents, excel expert 2013, vo, excel reports, excel graphs, excel expert, change fitness

Project ID: #4376921

Awarded to:

priyal1997

100% satisfaction

$40 USD in 1 day
(9 Reviews)
3.4

36 freelancers are bidding on average $125 for this job

danielgpratidya

Hi, I am sure I can make the application works as you could imagine. I am a "all the time" 5 stars awarded freelancer and have never failed even for a single project. Feel free to check my profile page.

$250 USD in 5 days
(74 Reviews)
5.6
nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing Excel macros contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet conta More

$300 USD in 5 days
(40 Reviews)
5.6
saamorim

Hi. I present my proposal in private messages. Please have a look a them. Thank you

$242 USD in 3 days
(5 Reviews)
5.3
FIBIN

Hi, I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% More

$154 USD in 3 days
(38 Reviews)
5.1
ethicalboy

I like to do this

$50 USD in 3 days
(31 Reviews)
4.7
DeepSyaal

Having a team of Professionals. We provide high quality work with accuracy.

$110 USD in 3 days
(40 Reviews)
4.7
nazmulcb

Dear Sir, quality and expert researcher here. Please give me an opportunity to doing this. I will do it accurately and honestly

$200 USD in 15 days
(12 Reviews)
4.3
uumairkhalid

Excel expert here. Sir its my pleasure to do work with you. I assure you top quality work. Ready to start now

$50 USD in 3 days
(20 Reviews)
4.2
nayabsiddiqi

can provide you reliable solution.

$330 USD in 5 days
(9 Reviews)
4.1
seaanddream

Hi, your excel vba expert here, kindly have your project achieved by a top freelancer. regards,

$120 USD in 7 days
(19 Reviews)
4.0
SteveP495

Excel (incl. VBA) Expert here. Can communicate verbally to discuss requirements in detail. My pedigree in your PM. SteveP.

$245 USD in 5 days
(1 Review)
2.8
benefitworks

Hi Sir, I bid only if I am 100% confident that I can complete the project to customers satisfaction. You may like to see my reviews. I believe I can do better than many here. Please check my PM in your inbox. Thank More

$100 USD in 7 days
(3 Reviews)
2.5
srdas2012

Hi We are Excel/VBA Expert We will like to do this,Please see our Reviews Current work & Past Works

$155 USD in 8 days
(3 Reviews)
2.4
permana22sl

Dear Sir, quality and expert researcher here. Please give me an opportunity to doing this. I will do it accurately and honestly

$110 USD in 15 days
(3 Reviews)
2.3
marcfloyd

I am experienced Financial Analyst (and VBA Developer). Presenting of financial data is my day-to-day job. I believe that medical records are not going to be significantly different to work with. Please check my prev More

$159 USD in 7 days
(3 Reviews)
2.3
maruthimagic

Please Check Private Message, Thanks!

$154 USD in 3 days
(4 Reviews)
2.3
sudewa

Hi, I am keen to do this job and I have a good experience in Excel. I am looking forward to hear from you. Thanks, Sudewa

$200 USD in 3 days
(1 Review)
2.2
soikaushik2013

Hi, I'm interested to work in this project. Thanks

$30 USD in 3 days
(2 Reviews)
2.0
nitinpawar42

I am expert in Excel Please see PM

$110 USD in 3 days
(1 Review)
1.8
haseebhm

10 years of excel experience.

$66 USD in 3 days
(2 Reviews)
1.5