Medical services company requires the ability to combine several excel spreadsheet calculators to create a dashboard showing patient health data. Medical data would be entered into fields (such as cholesterol levels, heart condition, blood counts, or other data).
Upon data entry, the inputs will use existing formulas and macros that will output a "risk report" showing the amount of risk of certain conditions over time. The risk scores will have multiple numbers associated with conditions such as diabetes, heart attack and stroke and should be displayed both numerically and graphically in a dashboard style report that can then be printed in pdf.
Along with the score, comments can be pulled into the report based upon the score. There should also be the ability to add comments to each score as well. Reports can then be downloaded, emailed or printed by the administrator.
Currently there are as many as 5 spreadsheets containing the formulas, graphs and inputs. These would need some feedback regarding dashboard/report design.
Long term, we want to have these build into an app and the ability to store reports in a secure portal...but that is not part of this spec.
Attached are a sample spreadsheets that would be used for the project.
9 freelancers are bidding on average $13/hour for this job
Hi, I can work for you on this project. You can contact me at any time to get my services. I will give you reliable results with satisfaction guaranteed. Thanks.