Build excel database with automated processes (bidrectional sheets and two automated formatted word docs from item/variables)
Budget: $250 – $750 USD
I need a database to follow roughly 200 patients in excel for case management with a bidirectional sheet for patient reports and a print option for creating either one of two word docs from Sheet 3 or 4 based on editable data in sheet 2.
Example file is attached.
Sheet 1: Monatsplan ALLE: simple documenting of times and tasks per co-worker related to variable "patient name" in sheet "PATIENTS".
Sheet 2: PATIENT: Main data sheet with data of each patient as a basis for other sheets. However, it should be possible to bidirectionally entry data also in Sheet 3 "REPORT" and Sheet 4 "BETREUUNGSPLAN".
Sheet 3 and 4: Main entry sheets and masks for word docs and simple data entry: Mask should be filled by corresponding data from sheet 2 and should be editable, so that changes in sheet 3 or 4 will be made in sheet 2 and vice versa. Sheet 3 or 4 should be exportable as a ready to print document (maybe a simple print button). Some items in Sheet 2 are linked with a dropdown menu from sheet 5 or 6 (for example addresses). The choice from sheet 2 should be automatically updated in Sheet 3 or 4. Add one of two different headers dependent on one of the items.
Sheet 5: Value sheet for dropdown options
Sheet 6: Adressbuch: Value sheet for dropdown option for adresses from different categories
Sheet 7: Compendium: medications currently not related to other sheets.
Do you have experience with programming an excel database like this?
Example file is attached.
Sheet 1: Monatsplan ALLE: simple documenting of times and tasks per co-worker related to variable "patient name" in sheet "PATIENTS".
Sheet 2: PATIENT: Main data sheet with data of each patient as a basis for other sheets. However, it should be possible to bidirectionally entry data also in Sheet 3 "REPORT" and Sheet 4 "BETREUUNGSPLAN".
Sheet 3 and 4: Main entry sheets and masks for word docs and simple data entry: Mask should be filled by corresponding data from sheet 2 and should be editable, so that changes in sheet 3 or 4 will be made in sheet 2 and vice versa. Sheet 3 or 4 should be exportable as a ready to print document (maybe a simple print button). Some items in Sheet 2 are linked with a dropdown menu from sheet 5 or 6 (for example addresses). The choice from sheet 2 should be automatically updated in Sheet 3 or 4. Add one of two different headers dependent on one of the items.
Sheet 5: Value sheet for dropdown options
Sheet 6: Adressbuch: Value sheet for dropdown option for adresses from different categories
Sheet 7: Compendium: medications currently not related to other sheets.
Do you have experience with programming an excel database like this?