I am looking to create a google sheet to co-ordinate the capture and reporting of values in an ophthalmic examination.
There are multiple parameters recorded for each patient such as
corneal appearance etc
Dependent on the heading, the input may be a yes/no value, a number, a body of text, a choice from drop down box, a drop down box contingent on an initial selection.
Having inputted / selected values for each clinical parameter into the spreadsheet I require a report to be automatically generated (on the same google sheet) that can be cut and pasted into another programme. Basically the report will turn lots of individual findings into a coherent and readable text.
I understand the =CONCATENATE function so that values can be dropped into a meaningful sentence but I require help to make the process more sophisticated. For example a results box could have a default setting such as 'normal' which can then be overwritten to describe an abnormality. Some input boxes left blank would not appear in the final report.
Ideally I would like to work with an expert who is prepared to teach in the development of this google sheet so I can be a close to self sufficient in the future if I need to add more parameters. I foresee this as being a step by step process as I describe my needs with the project winner both creating the sheet function and explains how this is done.
18 freelanceria on tarjonnut keskimäärin $120 tähän työhön
I got the knowledge and also worked as the entry operator. so i know that how i can complete my work in less time. i also got good knowledge of excel. my typing speed is 50 per minute and i also know about web search.