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.
Bu iş için 18 freelancer ortalamada $120 teklif veriyor
It's a simple task. I will create a sheet for the data entry. All the input fields will be set up (with drop down, etc). You have to enter the needed values (you can leave some values blank) I will give a menu optio Daha Fazla
Hi there, I'm an industrial engineer with plenty of experience with spreadsheets and dashboards creation. I can teach you how to create this kind of tasks while we create this one together (data validation, data forma Daha Fazla
Hi there, I’m a freelance writer. I would like to offer you my services. As a professional writer and creative mind, I would be more than happy to use my talents and engage with your target audience! I’m able to cover Daha Fazla
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.