In Progress

TREG ANALYSIS

I would like to develop a program that can take a Word (.rtf) file, search the fields that I indicate for their content and compare the values to the guidelines that I establish for their fields.

1. the name field should return two columns, the last name in one column and the first name in the second column. They are currently separated by a comma (SEE BROWN CIRCLE)

Each name may have one or several lines of entry to follow. The program will list each entry in a separate line under that name in the order that they appear.

2. the diagnosis (SEE BLACK CIRCLE) should have a "control field" in which I can indicate what procedures (SEE RED CIRCLE) are compatible with that diagnosis. So, 92235 may be compatible with "amde", but not "dry". If the wrong DIAGNOSIS is coupled with the wrong PROCEDURE the program will present me with an error.

The parameters for acceptable pairings between DIAGNOSIS and PROCEDURE is to be constantly adjustable by me, meaning that I can add or delete entries from this section. Hopefully, I will eventually fill in all of the acceptable pairings over time.

for instance: procedure diagnosis 92225 retb

amde

csr

mach

If a diagnosis of "dry" was matched with 92225, the program would show this as an error or an exception.

But, I can change the pairings at anytime.

3. PAID CHARGES will be shown in a separate column to distinguish this entry from unpaid charges (no negative amount in the line in the .rtf report) which will be shown as a zero (0)

4. The UNITS (see GREEN CIRCLE) will be shown in the next column

5. The RECALL (SEE PURPLE CIRCLE) will be shown as the number of months between the visit date and the recall date.

6. There should be a column that appears at the end of each patient's entries that indicate the number of charges that were entered under that individual

The control fields in which I indicate what diagnoses are compatible with which procedures can be on a separate sheet, or adjusted as you see fit

I hope that this is clear and that I have not made a simple exercise seem too complicated.

Skills: Excel, Microsoft Access, Word

See more: lines of a circle, is a circle a line, clear search fields, mach , Csr, circle of hope, word add date, date analysis excel, excel instance column, excel return instance column, instance excel, present statistical analysis mba thesis, instance excel column, excel sheet charges, fill word parameters, rtf excel, add excel file word, simple time line control, analysis green technology, excel compare columns, exercise excel, explain cost capital used net present value analysis, present financial analysis powerpoint, excel file compare, excel exercise

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

Project ID: #6916860

Awarded to:

morrisstarling

Hi, I suggest we keep the control dashboard and pairings in an Excel spreadsheet, this will organise the output. I suggest having the LOG, OUTPUT and ERRORS tab. I am using MS Office 2010 version, however the cod More

$30 USD in 2 days
(0 Reviews)
0.0

3 freelancers are bidding on average $92 for this job

illuminesoft

We are amongst Top 1% Outsourcing Providers worldwide. We have successfully finished over 450 projects in last 13 years. ID : 6916860 Greetings, We are interested to work on this project, please find my comments i More

$222 USD in 5 days
(239 Reviews)
7.4
fedalal2

Hi, I have a lot of experience with MS Excel, MS Word and VB so I'm realy guru in this. I can help you with this project. Best Regards, Alex

$25 USD in 1 day
(22 Reviews)
4.9