I would like to create a module that enables me to enter a patients' demographic data, their insurance carrier, procedures performed at the time of their examination and the diagnoses that relate to these procedures.
The INSURANCE carrier will act as a control for how the input into the PROCEDURE field displays. The display may be one line or several lines and the data /costs/ codes associated with each line can be made specific to the input in PROCEDURE. Each procedure can be linked with a specific diagnoses, and while it is rare, a diagnosis may also appear differently based on a specific insurance carrier.
Some procedures can only accept certain diagnoses, so there will need to be a "category" classification to which a diagnosis must belong in order to be linked to a specific procedure.
Each patient outcome will need to be printed as a distinct page, but I also want to be able to create a report of patients entered based on dates that I control.
Ultimately, I would like the module to link to a medical billing program by building an HL7 interface. This is a special linkage cod (?) used for medical programs...? if you can do this i will pay a bonus that we agree upon.
Please beware that this project will need to be tweeked as we work; I will change my ideas based on what you come up with. I also need this completes as soon as possible (ASAP)
I have attached two files ONLY to demonstrate my concept at this time.
My budget is very limited (sorry) Good luck. Please reach out to me with any questions
Hi, I can do what you need. I have 12 years of extensive Excel and Access experience. Please see a small sample of recent workings in my portfolio.
Please clarify whether you will provide information on linkage between insurance carriers, procedures and diagnoses (to populate drop down lists).
As to HL7 interface, sorry, but I have no experience with it.
$55 USD in 3 days
5.0 (65 reviews)
5.4
5.4
14 freelancers are bidding on average $146 USD for this job
Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting.
Here are the links for my past experiences:
https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html
https://www.freelancer.com/projects/4848189.html
https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html
https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html
https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html
By "module" do you mean a user form? which gives you some data entry fields such as drop-down ?
Regards.
HI, Access and Excel VBA expert here, as per the info mentioned by you it seems you need user forms in the application to be very dynamic i.e. data fields or their number count changing depending on some other data.I can offer you with a very dynamic application (excel/Access) for you requirements with a user friendly interface for data operations as well as report(patient outcome) generations. I suggest access will meet your needs better, I want to send you an access DEMO application to give you an idea of the functionality that I can offer you, if you could reply me on this message I will be able to send you the demo app. Regards.
Please visit my profile at: https://www.freelancer.com/u/harubel.html
Last employer review was" “ Super Fast and Good quality job, will use again and recommend him for excel. ”
So, I expect you will take service from the expert. Noted that I have outstanding expertise in Word, Excel and Powerpoint.
I read out your project details and check the attachments and confirm you that i will execute the output in a professional way. Please hand over the job to me, you will be happy with my work.
Regards
harubel
Get it done right the first time! My company specializes in work like this, custom excel templates. I will be able to work with you in the future to tweek or upgrade.
See my profile for similar tasks i have completed using vba (the "macro" language of excel.)
Hi. Do you still need help?
Excel expert here. I can do what you are requesting, except the link to medical software. No problem with adjusting your ideas with the progress of the project. We will be working together to get the best solution. Best regard, Ricardo
I am experienced software developer.I can give you best quality application as per your requirements.I have gone through your requirements ,I assure the project to be completed on time with good Quality. looking forward to work with you! .....Thanks!!
Hello,
As my part of day job, I work extensively with excel and creating custom modules. I work in the energy field and projects often require customization based on different inputs. A project I am currently working on is similar to this one in that it requires a module. The module allows the clients to bundle various project depending on their needs. The client can pick project individually or group as many as they want. Your proposed project would follow a similar scheme, while meeting the requirements you have outlined. I work with our client base to constantly modify the module based on their suggestions.
I have create several 'user input' modules in the past and your project perfectly lines up with my experience. On your request, I can send you a working version of the module I am currently working on to show you my skills.
Although I am not familiar with HL7, I can work on your request. I have experience linking excel files with several other programs and would be happy to investigate the issue.
Thank you for your consideration! Please let me know if you have any questions or would like to some examples of my work.
I've been working with medical data for the past 18 years.
Is there a reason you want this in Excel? This would be an easy application to write standalone (in C#, java, etc.). Honestly, I'd think it would be a lot easier to do this in a standalone application.
I can help out with the HL7 as well. Do you know what type of messages need to be sent (ADT/PIN/etc.)?
I'd be happy to discuss this further to flesh out details.
Carl.
Hello. I have several years of experience working with hospital and physician groups to do just what you're describing. Additionally, my wife is currently employed as a certified consultant working in just this field (EPIC Electronic Medical Records) at a large hospital group, and would be available to assist. We should also be able to include your HL7 info with very little additional complication.
Look forward to hearing more about the project.
