spread sheet Case Manager weekly Productivity

The business provides case manager services (social services) to mental health clients, each team (Broward1) has 1 supervisor, each supervisor has 7 case managers and each case manager has X amount of clients, can be from 2 to 25 clients.

All clients have different insurances and each insurances granted us different amount of hours and each hour is convert in 4 units, the insurance pay us fee for services (per unit of 15 minutes), we pay our case managers the same way fee for services, some insurances they approved units per client the date of the admission, units last for 6 or 3 months (its important to have a section approval date and due date), another insurance we admit the client and we have to submit request after admission and we have to wait until insurance reply back to us with approval sometimes takes 2 days or 10 days, each time that I have a new client I need to input client's information, choose case manager assigned to case, choose team#, and input admission date, unit submission date, units approved, starting date and end date, each week we pulled from our software the units submitted per client, we will input that number for X week and automatically i want the excel the calculate the remaining units, on the same spread sheet we continue the same system weekly, that is the way how we verify if case manager is working with all their clients weekly (case managers must have to work with each client weekly). we also need a column in which we have to choose if client is active, or discharged, date of activation and discharged date as well, the report has also to calculate their total weekly productivity, a column with expected productivity by client and total expect productivity, if the system can convert next column in hours, next column a percentage expected is always 100% and units submitted in %. Also will be benefit to add colors, if the productivity is below 75% , or below 50% another color or the productivity was equal or above another color.

Skills: Excel

See more: web service spread sheet, iphone spread sheet, stock control spread sheet, time management template excel, spreadsheet template download, printable time management sheets, weekly time management template, managing team workload excel, time management sheet template, time management worksheet pdf, daily time tracking spreadsheet, time managment spread sheet, time management spread sheet, lock excel spread sheet, copy product spread sheet, j2me spread sheet, operating budget excel spread sheet exampleproject, convert word document spread sheet, usable spread sheet, excel dispatch spread sheet

About the Employer:
( 0 reviews ) United States

Project ID: #16308064

10 freelancers are bidding on average $126 for this job


Dear Sir/Madam, I'm happy to help you on this excel task. I just went trough the detailed description and I'm 100% sure that I can develop a perfect excel based model for this purpose. I'm an expert in advanced excel More

$150 USD in 3 days
(179 Reviews)

Hello, I'm ready to work on "weekly productivity dashboard" project. Relevant Skills Excel, VBA Milestones 120 USD - code writing 30 USD - userfriendly interface I have samples of work very similar to what you are More

$150 USD in 3 days
(113 Reviews)
$155 USD in 3 days
(49 Reviews)
$155 USD in 3 days
(96 Reviews)

Hi I went through the project requirements. I have understood what is expected. Kindly ping back to discuss further detailed. Please check my past reviews, I have 10+ years of experience in Excel/Macros/VBA . I will b More

$166 USD in 2 days
(133 Reviews)

I am a professional accountant with years of experience working in a US based NASDAQ registered company's finance department with an excellent excel skill currently serving as a finance manager. Working in a US Based M More

$161 USD in 3 days
(30 Reviews)

v Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can d More

$50 USD in 3 days
(35 Reviews)

Hello, I am Noel, a researcher and academic writer with several years’ experience. I am proficient in diverse disciplines and I can assure you high quality work. I also have access to reputable academic references and More

$147 USD in 3 days
(8 Reviews)

Hello , okay got it i will do this kob fo you and manage files Message me i can start work now and available 24/7

$100 USD in 2 days
(9 Reviews)

Good day. I would like to offer you my service, providing you an excel spreadsheet with the given data and columns and the necessary formulas and calculations.

$30 USD in 2 days
(7 Reviews)