Find Jobs
Hire Freelancers

excel data input module

$30-250 USD

Cancelled
Posted over 10 years ago

$30-250 USD

Paid on delivery
I have posted two other projects and I am looking for another worker to try to come up with an independent solution. [EXCEL PROJECT 2, CHALLENGING EXCEL PROJECT] Please do look at them for more description. Effectively, I am looking to create a system that will enable me to enter in codes to a PROCEDURE field that will automatically populate information like CPT CODE, DESCRIPTION, UNITS, PRICE REFER_DIAGNOSIS, etc. However, based on the INSURANCE field that will contain one of various possible entries, the information that a particular entry into PROCEDURE yields will differ. Sort of like a translator will give you a different definition for the same word depending on which language is requested. Some PROCEDURES will result in one line of description and CPT codes, others will result in multiple, and this will differ based on the INSURANCE input (the ultimate controller). Each PROCEDURE has to be linked to a DIAGNOSIS, another input field that is populated with several entries; the entries in DIAGNOSIS will be categorized; the PROCEDURE ENTRY can only accept certain diagnoses form the appropriate category. All of the data in these different fields need to be easily changed and updated/ deleted/added, based on changes made by the insurance carrier. I will want to be able to print a sheet at the conclusion of an encounter on a patient by patient basis, and as a report based on dates that I can select Wait! More! I am trying ultimately to use this project to work with a medical billing program that I currently use. This contains all of my patient information. Today, when I am preparing information for a given day, I print out a 'batch' that merges prefabricated forms with individual patient data who are scheduled for that day, using "TAGS" that the program has established. i really want to have my new module be populated with this data AUTOMATICALLY so that I can look at it on the patients account, or as a free standing module with the day's patients entered, such that, after review of the input the next day, I can have the inputted data enter automatically into the billing program. This may be a bit much. i will work within any limitations. We use a link in the US called HL7 that acts as an 'exchange"(?) for medical software to create interconnectivity. I do not know what I just said, but I was told that one needs to build an HL7 interface for the program you make to work with the existing billing program. I will attach some (feeble) examples.
Project ID: 5076950

About the project

7 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
7 freelancers are bidding on average $387 USD for this job
User Avatar
Hello Sir, We are a big set up company with excellent skilled operator who have a lot of experience in this segment, our employee complete more than 300 similar job, i have gone through your project specification, its really a simple task, please let me handle this task, we ll make a well formatted,error free list. Waiting for your reply, once you approve we ll make a sample for you Waiting for your reply. Thanks DG
$144 USD in 3 days
4.8 (48 reviews)
5.9
5.9
User Avatar
Hi We have done similar project, We have expert team. WE provide you quality work as per your requirement. Ready to start Now. Thanks
$155 USD in 3 days
4.8 (95 reviews)
5.9
5.9
User Avatar
Hello, I can help. I have designed and developed large scale systems with all degrees of complexity. Your's is one more challenge and I accept it. A bit about myself: Having worked in the US for seven years, I was involved in various project development activities in many of US govt agencies. Some of them - California Employment Development Dept (CalEDD), Washington Dept of Revenue (WADOR), Louisville Jefferson County Revenue Commission (LJRC), Washington State Hospital (WSH), Nationwide Insurance, and many more... I had also expressed interest in your earlier post. Let me know if you are interested. Best regards, AccuPro - Providing simple solutions to complex problems!
$1,111 USD in 10 days
5.0 (3 reviews)
1.9
1.9
User Avatar
Just a forewarning, the module that you are wanting to create is very complex. My bid is higher than your maximum just due to the time and expertise it will take to create this. I have created modules that feed into third party applications for industrial contractors. My end goal would be to create this so that it would be able to be integrated into the system that you use. Jason
$555 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This is one of those projects where what you really need is a database report instead of a spreadsheet. The reason I say that is in order for Excel to do what you are asking, it will be doing multi-dimensional queries (every time you hit Enter). You can get around that by setting calculation to manual and putting in a manual trigger (macro) but that would still result in a large number of complicated calculations to be done at once. In addition, adding new items (new payers, no procedures, new diagnoses) will require either the file originator to go in and add to/modify the code, or your staff will need to do that. I would strongly advise you develop a regular working relationship with the freelancer or other developer who puts this together for you. So, operating on the assumption that we are going to create this in Excel. The way I would go about it is to create multiple reference tables (dynamic named ranges) with Pivot Tables associated with them. The reason for this is that a PivotTable can update with a single click, or vary based on a single field whereas raw data still requires all output to be specified and separate codes for each entry you want to return. As for the auto-populate. The new day's patient names (and other relevant information) would be put into an input sheet. A macro would be created that builds and populates a template sheet for each person on your next day's list. With regard to the HL7 interface, that would have to be a new project.
$450 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
new york, United States
5.0
30
Payment method verified
Member since May 14, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.