We have an Excel document given to us by a lab on a regular basis. Each row contains the lab results for a particular person. The record contains the following data:
Date, First Name, Last Name, Date of Birth, Gender, Height, Weight, Smoker, Fasting, Systolic BP, Diastolic BP, 2nd Systolic BP, 2nd Diastolic BP, Glucose, Cholesterol, Triglycerides, HDL, LDL, PSA, Notes
There is also a survey that is filled out prior to generating the documents (the 'self reported data' on page 12 of the pdf). We have this data in a database and can export it to CSV. We will combine this data into a single CSV with the lab data for easy manipulation.
We need a system or application developed that can take the excel document (or a converted csv if needed) and generate a document for each person that has dynamic text fields and graphics based on the values in the record.
I have a sample XLS document and PDF attached of what the resulting document should look like. The resulting document can be in any format, as long as we can print it. The resulting document must use the formatting in the attached PDF. We can provide that template in a variety of formats such as PDF, Word and possibly some other graphic-specific formats I can request from our designer. All text used in the document should be changeable.
The only graphics that will need to be dynamic are the Risk Level sliders that appear in each biometric section. We'd like there to be an indication of where on the chart their values fall.
We are not specifying how this document will be created. If the developer wants to use a tool that will require an investment (e.g. Microsoft Access or Adobe InDesign), please contact us first to make sure we have the application or are willing to purchase it before bidding.
The project files are attached at the bottom of this project description. The Excel document with biometrics has fake data to protect privacy.