challenging excel project

This project was successfully completed by dviruki for $55 USD in 3 days.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Completed In
3 days
Total Bids
Project Description

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

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online