Excel tool to keep track of closed tickets per agent monthly

Closed Posted 4 years ago Paid on delivery
Closed

I need an excel tool which is a calendar and a tool to keep track of how many closed tickets per agents per months working days.

These are the requirements

- Calendar

- Possibility to enter absences

- Possibility to enter number of closed tickets

So the goal of the tool is to be able to see how many tickets an agent has closed a month according to the number of working days he had that month.

Reports

See list of agents and the number of closed tickets and the average per day.

Agent Name -- Year/Month/YeartoDate --- Working days -- Closed total -- Average a day

Excel Visual Basic PHP Software Architecture Data Processing

Project ID: #22382062

About the project

27 proposals Remote project Active 4 years ago

27 freelancers are bidding on average $8/hour for this job

elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Look at the comments that employers have left me, that i More

$15 USD / hour
(305 Reviews)
7.3
dgled

Hi, I can do your project. I am financial experts and a guru in Excel with extensive knowledge and expertise in advanced formulas, Pivot Tables, Tables, solver and Visual Basic Application including preparation of avai More

$10 USD / hour
(94 Reviews)
7.2
irfankhokhar1986

Hello sir I hope you are doing well. After reading your offer, this looks like a perfect fit for my skill sets so May I discuss with you for further details about this project?

$2 USD / hour
(130 Reviews)
6.1
razvancotofana

Hello, I am an excel and VBA professional and I would be happy to assist you with your tool for tracking agents' monthly activity project. Please send me a message so that we can discuss in details your requirements. L More

$15 USD / hour
(19 Reviews)
6.0
dreammate0621

Dear Client! I am very happy to see your project detail. I think it is just my project. :) As you can see in my profile, (my review: https://www.freelancer.com/u/dreammate0621?w=f) I have much experience with your job. More

$8 USD / hour
(26 Reviews)
5.7
MartinDudumi

Ready to accept this task. Everyone can sell themselves with words, i know that i dont have words but works. 10 years working with data, can not be shadowed by a new freelancer profile. Please try me and you will be n More

$3 USD / hour
(43 Reviews)
5.3
selopezr

Hello! I'd be glad to put my vast experience programming excel solutions to your service! I can offer a tool with several features, from the entry of calendars per agent to the report of required information. Please do More

$8 USD / hour
(31 Reviews)
4.9
babooshani49

HI there, I have read and understood your requirements. I will be able to work with you.I Can start immediately. I will be able to available finish this on time. Please leave a message so that we can discuss more over More

$5 USD / hour
(5 Reviews)
4.1
hkh581e5c8f1cb8a

Hi there, Am a professional accountant in KSA, who has more than 6 years of REAL experience. With high Ms excel, research and finance management knowledge. Can offer you free samples and perfect results at a fair price More

$3 USD / hour
(16 Reviews)
4.2
sahumk2000

Hi Greetings of the Day, I am interested in this task, I am full time freelancer carrying 15 yrs of experience in Web and Windows development and Mobile development using ASP.Net, C#, SQL server, Xamarin, WebAPI, VB6 More

$5 USD / hour
(11 Reviews)
3.9
ahmadaskar

Hello, Sure all is doable via excel, let me see your data to assess and confirm or should i develop the data from scratch Looking forward working with you Regards. Ahmad.

$5 USD / hour
(2 Reviews)
2.1
facundosegovia

Hi, I can do the task. Do you need this in Excel only? Because we can make a Web App to do what is requiered. Let me know if you are interested. Thanks

$5 USD / hour
(1 Review)
1.6
Bhavik0417

Hi, gone through with your requirement, I did that kind of job previously for a online carnival system which is built in php based framework. I can surely help you into this. For more discussion please come to chat bo More

$2 USD / hour
(1 Review)
1.2
SupremeWriters

Hello... Hello, I am an excel expert and I am able to manage bulk data entry within your given deadline. I can manage data entry, Data processing, Internet research, Data mining, data scraping, etc. My ability to accur More

$2 USD / hour
(1 Review)
0.3
youssefdouhou

Hello, I have experience in data entry and I would like to help you! Looking forward to hearing from you! Youssef douhou

$2 USD / hour
(0 Reviews)
0.0
mohamedabdalslam

hi I have about more than Six years of experience working in Accountant& Sales & Secretary also i have Great experience in copy writing typing and Microsoft Office Especially [Excel & Word]

$8 USD / hour
(0 Reviews)
0.0
deepakkumar1852

I done lot of projects in data entry and i also develop lots of websites in my college so i have good skills

$10 USD / hour
(0 Reviews)
0.0
willian1002

Greetings, I can design and create a local database which can log, track and report every parameter you want of your agents. I'm able to create reports for agents which logs all tickets of the agent; date wich logs More

$7 USD / hour
(0 Reviews)
0.0
aliubaidrajput12

Hi there, I hope you are well. I have reviewed your complete description thoroughly in which need a excel tool in which calendar and a tool that shows the tracking of how many closed tickets per agent per month workin More

$4 USD / hour
(0 Reviews)
0.0
DimitrisVry

Hi, Your excel project seems pretty easy and can be done within 1-2 hours max (the function/macros) with expected another 1 hour just for the formatting/report beautification. I charge on average 10 euros per hour s More

$12 USD / hour
(0 Reviews)
0.0