Encerrado

Automate Clinical Workflow and Information Collection

The Need:

I work in a remote hospital in Kenya, and I need to utilize google services(google sheets, forms, docs, etc) to automate data entry, storage, and reporting, or create an app to help do this.(Which ever is easier) This will help us keep track of patients better and allow us to apply for grant funding once we can easily produce records of what we are doing.

The Need:

I help run a specialty clinic where each patient is seen by a number of clinicians during each visit. I need to allow each clinicians to enter data about a patient. Then, I need to combine the information from each practitioner in one row of a spreadsheet for each patient. I need each row of data to populate a document that can be copied and pasted into an electronic medical record.

I have started trying to automate this process with google forms, google sheets, and google docs. Currently, I have it where each practitioner can enter information on a google form that populates a tab on a google spreadsheet. I have then combined the information from each tab into a master database by using some formulas so that the rows of data are populated based on a key that is made from the patient's unique medical record number and the date of the clinic visit from each practitioner. Basically, I can get the information from each clinician during each clinic into one row for the patient, but I havne't figured out how to make it populate a template that I can copy and paste into the EMR. I would also like some way to record photos on the database if possible.

I have attached a rough draft of what the template would look like and a screen shot of some made up patients on the data base. You can see the basic formula that I used to create the merged information and you can see the tabs that they are coming from at the bottom.

Basic Needs:

Ability to record information in a clean way(currently using google forms with drop downs)

Store it in a meaningful way (each patient sees 3-6 people during each clinic visit and all information from each provider is stored in one line based on the key from medical number and date)

Produce a document from a template

Habilidades: Excel, Google Sheets

Veja mais: customize workflow feedback collection sharepoint, information collection website program, data information collection, benefits of a clinical workflow, clinical workflow solutions, patient flow in medical office, medical office workflow diagram, clinic workflow assessment, clinical workflow diagram, medical workflow, patient scheduling workflow, excel template information collection, information collection, information collection form php, android information collection, ipad app information collection, ecommerce data information collection, information collection budget, information collection methods, icr information collection request

Acerca do Empregador:
( 0 comentários ) Nairobi, Kenya

ID do Projeto: #27404315

31 freelancers are bidding on average $453 for this job

(141 Comentários)
7.1
(163 Comentários)
7.1
(60 Comentários)
6.6
(102 Comentários)
6.3
(96 Comentários)
6.4
(40 Comentários)
5.5
BaNgan

Hello there Thanks for the project, so you are in need a script that can combine the data on multiple sheets to group the row data into template so you can copy into electronic medical recor right? let me know Ngan Le

$425 USD in 3 dias
(23 Comentários)
5.5
(13 Comentários)
5.5
akritisood94

Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project Mais

$300 USD in 2 dias
(57 Comentários)
5.3
merinsinha

Hi i am an certified internet research Expert. For Professional works -Hire me. As 10+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provid Mais

$556 USD in 6 dias
(32 Comentários)
4.1
SIBTEHASSANBUTT

Hi there, I have read your project entitled “ Automate Clinical Workflow and Information Collection ” I am a professional accountant dealing with PowerBi, well versed with data analytics, using excel and other data vis Mais

$250 USD in 7 dias
(8 Comentários)
3.5
AbidHussain1919

Dear Employer, I read the description. I am ready to do work on this project.I am very flexible in web research, data processing, LinkedIn, data entry , data scraping, data mining, and SEO related everything. I can a Mais

$250 USD in 5 dias
(7 Comentários)
2.6
LingarajMK

Hi, Thanks for sharing the requirement. We are expertise in product design, development and Testing (Hardware Design, Digital logic design (CPLD and FPGA), Schematics Entry, PCB Layout design, Software, Firmware, Mech Mais

$750 USD in 7 dias
(0 Comentários)
0.0
irahulrastogi

I would be more then happier to do this task for you within the given or before the period with full of quality work with full of accuracy 100%. Thanks a lot. Rahul R Skype: irahulrastogi

$250 USD in 7 dias
(0 Comentários)
0.0
websiteappdev

Hello, I have already built Similar HOSPITAL Management Software. Please have a glance. Admin [login to view URL] Website [login to view URL] I am involved in the develo Mais

$500 USD in 7 dias
(0 Comentários)
0.0
KashanNisar

Hi, I am a professional Medical Transcriptionist with 10 years of experience. I worked with American doctors but due EMR my job is almost finished. I am fimiliar with Google Sheets and excel as I do data entry task Mais

$278 USD in 2 dias
(0 Comentários)
0.0
sureshkatla

Hi, I have done automations using google suit apps for more than 20 clients. For one such client, I created a tool where multiple psychologists give scores to patients on various aspects and those scores are combine Mais

$750 USD in 7 dias
(0 Comentários)
0.0
hitaishinimishra

HI THERE I SAW YOUR REQUIREMENTS WE HAVE WELL EXPERIENCED DEVELOPERS WHO CAN WORK AS PER YOUR ASPECTS WE DELIVER YOU THE QUALITY WORK AND BEST SERVICE WE OFFER YOU ONE YEAR FREE SERVER MAINTENANCE CHARGES WE WILL COMPL Mais

$749 USD in 28 dias
(1 Comentário)
0.0
yasinnerten

Dear sir, I am interested in your job. I have a lot of experience this kind of projects. I am a college student. This year will be online education, so I have enough time to do job whenever you want. Also I would like Mais

$250 USD em 1 dia
(0 Comentários)
0.0
ckeris21

Hello there, I would like to submit my proposal as I possess the knowledge, skills and abilities to complete this project effectively. I can seek you that you are seeking someone with excellent knowledge in Ms Excel. Mais

$400 USD in 7 dias
(0 Comentários)
0.0