Find Jobs
Hire Freelancers

Shrinkage Report/ Attendance Report - open to bidding

$30-250 CAD

Closed
Posted over 9 years ago

$30-250 CAD

Paid on delivery
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!
Project ID: 6886796

About the project

13 proposals
Remote project
Active 9 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
13 freelancers are bidding on average $137 CAD for this job
User Avatar
Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and very high completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$150 CAD in 5 days
5.0 (946 reviews)
9.4
9.4
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 CAD in 7 days
4.9 (196 reviews)
6.6
6.6
User Avatar
Hey, can you share the time cards for the agents (even a sample data set would be good). This will allow me to understand the input data structure and then create the desired attendance/shirnkage report. I will infact create it in such a way that you would be able to use it for more than one groups of agents if required. I am an expert in excel based data analysis as you would see in my work history here on freelancer and can assure you that I would be able to provide the desired results. Do let me know if you would like me to work on this project for you and we may discuss the details. Look forward to hear from you. Thanks and Regards, Shikha (Automyze Consulting)
$277 CAD in 7 days
4.9 (172 reviews)
6.8
6.8
User Avatar
Hi! I can help you. The data in sheet 1 will be filled in manually? Or should be exported ?
$100 CAD in 3 days
5.0 (48 reviews)
5.8
5.8
User Avatar
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. But I joined this site just a month ago. Within a month I won two of tough contests held on this site. This says a lot about the quality of my services. I have worked on lot of advance excel dash boarding and VBA coding and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
$150 CAD in 3 days
4.9 (19 reviews)
5.7
5.7
User Avatar
Hello. I am a chartered accountant with audit firm and industry experience. I am also proficient in microsoft excel. I understand what exactly you are looking for. In fact i have done assignments of payroll before. I can deliver you 100% same what exactly you are looking for. Contact me so we can discuss further. Client satisfaction is my first priority. So if you give me a chance, I promise to deliver you quality work in agreed time. Thanks
$144 CAD in 3 days
4.9 (24 reviews)
4.1
4.1
User Avatar
About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Worked on Macro, VB, Pivot, User Form Proficiency in Office tools ,SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight.
$100 CAD in 3 days
3.9 (9 reviews)
3.5
3.5
User Avatar
Hi, Being an excel expert I can do this project very well. I have following queries: 1. Will it have dummy data in the beginning to show you that it is useful for you? 2. Will you provide Data which needs to be entered into it. I can create the excel template for you in One day. Please let me know if we can proceed.
$147 CAD in 3 days
4.8 (3 reviews)
2.6
2.6
User Avatar
Good afternoon! My name is Tony and I am new to Freelancer. I am an Excel expert, including pivot tables and VBA. I have been working with complex workbooks since LOTUS 1-2-3 came out on 5.25" floppy disks. I have been a financial modeller almost my entire career (mostly Oil and Gas) and I will complete the job for you with superb quality and with a quick turnaround. I will also warranty the work for one week after completion and make any additional tweaks (not major changes) for free. I hope to hear from you soon. Tony
$133 CAD in 3 days
5.0 (1 review)
0.4
0.4
User Avatar
A proposal has not yet been provided
$55 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I can achieve the results that you are asking for. I would love to work on your project. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am an experienced business writer and marketing expert. I can create an pivot table list of small location wise that will have an instant connect with you. I have a 4 year experience in Data Analysis. I have worked across all areas in Data Analysis, nested formula creation and Module Creation
$111 CAD in 2 days
0.0 (0 reviews)
0.5
0.5
User Avatar
Excellent hand on MS Excel 2014 & 365 for the purpose of Structured Database Module development and for the further analysis purpose
$111 CAD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Mississauga, Canada
0.0
0
Payment method verified
Member since Dec 13, 2014

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.