Hello all.
I was asked to provide a solution for a nursery home where they need to print the therapeutic scheme (medication and dosage) for patients. I have been thinking of the approach to take and I'd like to have some feedback on my ideas.
The need
Create an easy to fill document with the medication by time of the day (on wake up, breakfast, lunch, dinner...).
There is a global set of medication which may, occasionally, change.
The document needs to be easy to fill (tab navigable?).
[/url]
The ideas
In the beginning I thought of using Excel (would it be easier?) but I think I'll go with Word as no calculations will be needed, at the end only selectable values from dropdown lists are needed.
I thought of storing all the possible selectable medication and dosage in a csv file (that way it would be easily updatable) and to use VBA to read that file, when the Word document is open, create objects and store them in maps. Those maps would be used to populate the dropdown lists for selection.
Example of csv file content:
Code:
Omeprazole,20mg,1
Paracetamol,500mg,1
Paracetamol,1000mg,2
Does this sound a good approach?
Any feedback and ideas would be much appreciated.
Thanks.