Excel Pivot Tables,Graphs/Charts and automation
$30-250 USD
Pago na entrega
PTL Fulfillment Scorecard is what I receive each week. The tabs are broken down to individual people and their metrics.
I would like to be able to have a master Excel sheet to be able to run a macro and auto populate the data as I did manually in the PTL detailed upload.
The repot should be able to use pivot tables and show graphical reports showing the following:
Ranking by top performers - top two KPI data that is lowest number to greatest. (Means fastest in data entry to slowest)
Ranking same performers by - bottom two KPI data from highest to lowest. (Means delivery 100% to the ones with slowest delivery of product)
Finally ranking by the average delivery time and by the number of online orders from Week, month and year to date as shown on each excel tab.
The main idea as a manager is I can quickly see a list of who is doing the fastest data entry, followed by high highest delivery percentages and by the number of online orders and average delivery time.
This way I don't give credit to someone with the was the fastest in data entry and in delivery time but only had 10 online orders WTD, MTD or YTD compared to someone who had to do 3,000 orders.
ID do Projeto: #13590028
Sobre o projeto
43 freelancers estão ofertando em média $155 nesse trabalho
Hi, I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with f Mais
Bid Summmary Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
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 rega Mais
Hi, I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel m Mais
Hello, I am proficient with Excel and VBA and would love to help you with this project. Please contact me for more information.
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a hotel price comparison system that pulls data using the Mais
I have fluent written and verbal English skills. I am hard working, dependable, punctual, and available full-time. I have a good understanding and grasping capabilities. You can look at my resume in the portfolio secti Mais
Hello, I am working with Excel for a long time and I can create complex formulas and macros. I have keen attention for details and my promise is quality work. If you are interested please open a chat with me. Mais
Hi, I am expert in Excel. I did not read all your project description, but i sure i can do what ever you want. I so the the file that you have uploaded. Kindly, let us discuss your project and tasks you need t Mais