In Progress

challenging excel project

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

Skills: Excel, Microsoft Access

See more: excel special, challenging programs, billing microsoft, medical billing work, enter medical, carrier billing, medical insurance project, enter medical data, project 2013 access, module cod, patient files, excel input interface, data input create report, excel line work, create carrier, microsoft excel 2013, create codes access, project access control, program enter excel, medical data interface, insurance module, budget access, access data project 2013, microsoft access insurance, medical diagnosis

About the Employer:
( 30 reviews ) new york, United States

Project ID: #5062966

Awarded to:

dviruki

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 bet More

$55 USD in 3 days
(12 Reviews)
3.3

15 freelancers are bidding on average $140 for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$200 USD in 4 days
(146 Reviews)
6.5
harubel

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 fr More

$94 USD in 3 days
(21 Reviews)
4.9
farr4u

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 c More

$54 USD in 3 days
(19 Reviews)
4.0
bgill

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 comple More

$277 USD in 3 days
(3 Reviews)
3.9
SiroosJafary

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 experie More

$100 USD in 4 days
(9 Reviews)
3.6
inoussakabore

I am a statistician working as a database manager there is 4 years. I master ACESS, VBA SQL. I am ready to start it for you

$89 USD in 3 days
(2 Reviews)
3.3
web2printexpert

we have done similar task before. The proposal is preliminary. The final period and sum will be calculated after discussion. 1. We have big experience (since 2004) in MS Access, Visual Basic, VBA, Excel, Word, Visua More

$222 USD in 5 days
(1 Review)
2.8
MSExcelPro

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 More

$200 USD in 3 days
(1 Review)
2.6
MobileLabs1

Dear Sir, With a basic understanding after going through your posted project,we can provide you with your desired results.These are simple tasks and can be done in a swift and timely manner. Having a team of almo More

$66 USD in 3 days
(2 Reviews)
2.3
tapanpatel89

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 workin More

$127 USD in 3 days
(1 Review)
0.6
carlheller

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 More

$250 USD in 3 days
(0 Reviews)
0.0
sanskar

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 forwa More

$94 USD in 7 days
(0 Reviews)
0.0
EverythingExcel

Hi, I saw your listing here and thought it would be an interesting project. I have a background in working with excel as compensation analyst in HR. I started selling some of my templates and doing custom work earlie More

$165 USD in 4 days
(0 Reviews)
0.0
RMastro

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 ( More

$111 USD in 3 days
(0 Reviews)
0.0