@wroos. Excellent questions. Actually the survey only has one free text question, and that is for “Other diagnoses.” (And we don’t do anything with that information other than marking it as an instance of ‘other’.) Therefore, every answer is a specific response and mapped to the UN form, the country form, or both. The mapping is complex, so I think that I will need to do this to have accurate and reproducible results. I do not know how to automate this process post-survey in Excel, but that would probably be a better solution, and I will be working with our IT department. Reports are produced monthly, so this process would allow our end users to copy and paste blocks of cells from the main spreadsheet to another matching the specific report. Then using filters for age, gender, and status, the columns can be summed and pasted into the final form (Still pretty low tech.)
The Notes at the end are used for feedback to the user and do not require additional analysis. See example: Advice on creating a summary page
I was mostly concerned about the survey size. We can improve the reporting mechanism over time, but I did not want to be creating technical issues. If you have specific suggestions for improvement, please feel free to contact me by private message.
FYI, and just for fun, here is an example of the mapping that is done. Blue highlights map to one form and red text maps to another. The choices under Dehydration relate to best practices, but do not map to either form
