En cours

Do some Excel Work

I currently have a business that takes in medical specimens from various marketing firms. All the specimens get entered into the software that we use in the lab. I'll refer to this software as the Lab Information System (LIS).

Then we drop claims for the work we do, this is entered into the Billing Software (Billing). Right now, the two systems do not talk to each other, which makes things a bit difficult.

My marketers ask for regular reports. Any report we generate from the LIS will show ALL specimens received, but it doesn't tell them how much has been collected. We can pull that data from a report on the Billing software, but it doesn't show all specimens - only the ones which have been billed so far.

What I'd like you to do is build an excel model that will do the following:

1) Takes Data from LIS of all specimens as well as Data from Billing system and just uses a lookup function to match payments to the appropriate patient accounts.

2) Creates a report for each marketer by pulling from the report the data that has his/her Account number on the specimen.

3) Does some basis analysis on each marketer report (# of specimens for the period, average pay per specimen, and anything else you think we would want to see, etc.)

4) Creates a rollup summary page for us to see all our marketers and how each of them are performing, etc.

We'd like this whole thing to be pretty automated so all we have to do is feed the excel program with data dumps each time we need to run the report and it can run it all for us so we can send reports to each marketing partner.

Compétences : Analytics, Saisie de Données, Traitement de Données, Excel, Ventes

Voir plus : what will do, need a business marketer, my marketing lab, marketing function in a business, i need a marketer right now, how to do reports, how do i get a marketer, how can i get a marketer, contract work excel access, excel 2000 macros work excel 2007, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, data entry work excel, work excel database, surf internet work excel

Concernant l'employeur :
( 4 commentaires ) Dallas, Sweden

N° du projet : #8530208

Décerné à :

deepbluetech

Hi, I undertake Excel VBA based projects and would be happy to assist you. Before confirming, I would like to have a look at the Lab Information System (LIS) file and reports that you currently generate. Regards Plus

600 $ USD en 7 jours
(170 Commentaires)
6.7

10 freelance ont fait une offre moyenne de 525 $ pour ce travail

zExcel

A proposal has not yet been provided

600 $ USD en 3 jours
(210 Commentaires)
7.3
vsolcorp

A proposal has not yet been provided

458 $ USD en 12 jours
(166 Commentaires)
7.0
AishaAlimuhammad

Hello, I have been referred by a freelancer assistant. I wanted to tell you that this can be done easily on Excel or on Google Docs (I will prefer). I have done many similar project like this. Just wanted to clear one Plus

705 $ USD en 20 jours
(122 Commentaires)
6.6
danielgpratidya

Hi, Crystal explanation on the description, thank you. Could you please send me the files produced by the LIS and the Billing as samples? I can create a mockup sample from them and we can discuss further. I am Plus

450 $ USD en 5 jours
(153 Commentaires)
6.3
safiqulislam67

Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportu Plus

500 $ USD en 10 jours
(79 Commentaires)
6.0
raghav1101

Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. Please contact with further details if interested. Regards R Plus

588 $ USD en 7 jours
(62 Commentaires)
5.9
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regard Plus

511 $ USD en 5 jours
(76 Commentaires)
5.9
dangersystem

Hello there, Just read the whole description carefully, I think i am able to complete your job within minimum time and with best result Please ask me any inquiry you are searching for, I am ready to discuss with Plus

588 $ USD en 10 jours
(105 Commentaires)
5.4
someka

I have inspected your project desc. It is pretty straightforward, however i may have questions. Will you feed the data just putting the necessary info into excel? Or you want the excel to connect to your software datab Plus

250 $ USD en 5 jours
(45 Commentaires)
4.8