Shrinkage Report/ Attendance Report - open to bidding

So i heard your the best of the best!

I need you to create a attrition report for a call center. Feel free to use access or excel. ( Excel would be better ). This report must generate up to 100 employees. Example for one agent: I need to know his vacation days, sick days, lou days, any kind of day including holidays off. I also need to know the agents shrinkage report. How long was he on a meeting for, how long was he off the phone, how long was he on lunch, break etc. Anything and everything that requires an agent to be off the phone i need those stats. That would be in sheet 1. In sheet 2, i need a pivot table of all the data that is in sheet 1 including charts. I need to be able to make graphs out of all the information presented in sheet1.

This report must have a list of 100 agents,and in the end of it all- it needs to tell me the total in minutes, seconds, hours, and days in seperate colums. Let me know if this is something you can do.

Thank you!

Skills: Data Entry, Data Processing, Excel, Microsoft, Visual Basic

See more: excel pivot table raw data, create pivot table using data table, convert pivot table raw data, can create excel pivot table quickbooks data, crystal report excel pivot table, excel convert pivot table raw data, vsto pivot table sort data, excel connection sql pivot table reading data, access 2007 open report selected specific data, load pivot table source data excel, excel pivot table change data source, create mysql table form data, open source phpmysql report maker, download open office database report addon, php create table csv data

About the Employer:
( 0 reviews ) India

Project ID: #11750068

12 freelancers are bidding on average $161 for this job


i have similiar project already done.. inbox me to discuss. i m an expect of excel vb macros

$166 CAD in 2 days
(21 Reviews)

I have 16 years’ experience using Microsoft Excel. I have taken all classes from 03 to 2010 beginner to expert. I am skilled in VLOOKUP formula development, Pivot Table generation, Chart creation, Importing and expo More

$111 CAD in 3 days
(7 Reviews)

I have sound knowledge in MS word , Excel, Powerpoint. I am a dedicated person in work and always give my full potential to complete the job on time. Looking forward to hear from you.

$155 CAD in 3 days
(6 Reviews)

Hello, I have 10 years of experience into VB.Net, WPF, VB6, VBA, SQL server, WCF. I have made created and modified many macros. Also have worked over many .Net based excel projects. If you allow I can create this i More

$150 CAD in 5 days
(2 Reviews)

Hi I understood your requirements. I have good experience in excel and data analysis. I have experience in generating reports for various companies. It would be great if you share sample data for generating those r More

$167 CAD in 3 days
(9 Reviews)

I have a bachelor degree from the National University of Rwanda, and many trainings in Project Management, Business administration, ICT,…with 13 years of experience in Data Entry services.I am a Translator consultant a More

$155 CAD in 3 days
(0 Reviews)
$166 CAD in 3 days
(0 Reviews)

I have 4 yrs of corporate experience [login to view URL] [login to view URL] on pivot. Good internet speed reliable only 1 project at time work from home my skillset matching with job. I need 4 weeks to complete entire task.

$188 CAD in 30 days
(0 Reviews)

i am good at visual basic and excel . will create a report for you that solve your purpose.

$166 CAD in 5 days
(0 Reviews)

Hi. I would like to work on your project, as in detailed given information i can work on your file considering your request on graphs and other presentation, i can work on it for 2 days. Ive been using excel for 1 More

$30 CAD in 2 days
(0 Reviews)

Thanks for your consideration!

$250 CAD in 3 days
(0 Reviews)

I'm relatively new here building my reputation in Freelancer. I just finished my first project and getting the hang of things. I want to continue fostering good relationships with employers through my excellent work et More

$222 CAD in 3 days
(0 Reviews)