I need an Excel except

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

I need to be able to see what each team is doing every day , how they are doing compared to the goals and how far are they in reaching their tiers- 3 tiers.

so, Anna, Alex, Felicia, Maureen and Arcy are the team leaders that head their departments. The stats they are responsible for are in the same row as their name. For example: Anna is the team leader overseeing Dr. Miller, Dr. Baker, Dr. Zeitlin and Dr. Gilmore. The goal that Dr. Miller needs to reach every month is 36992, Dr. Baker 6688, Dr. Gilmore 11584, Dr. Zeitlin 12928. So when Anna enters information every day she should be able to see where each Dr. is at compared to the monthly goal , how far each Dr. from the monthly goal, what does each Dr. need to collect every day to reach the monthly goal (depending on the number of days left in the month). Each team leader will be doing the same and they need to know for each doctors and their department. Also, all this information should be able to tell if they have reached their first tier collectively, how far are they from reaching the first tier, second tier and third tier. I am putting data together for the 2nd and third tiers, in the meantime I want to get a framework ready. Transferring the data into Graphs and pies or any other visual aid is preferable.

Data Processing Excel

Project ID: #18416210

About the project

45 proposals Remote project Active 5 years ago

Awarded to:

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$222 USD in 3 days
(749 Reviews)
8.5

45 freelancers are bidding on average $133 for this job

schoudhary1553

Hello, I have gone through your job and i am sure i can deliver you the quality job. Please see my profile i have deliver almost 430 projects with 100% client satisfaction. Please ping me for further discussion.

$200 USD in 3 days
(340 Reviews)
8.0
ponnarasiBabu

I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs. Looks like this project is feasible. Just want to un More

$250 USD in 3 days
(205 Reviews)
7.1
dgled

Hi! We are a team of two professionals in finance who have considerable working experience with Excel. We consider ourselves as gurus in Excel/VBA/Macro, We have extensive knowledge and expertise in advanced formula More

$250 USD in 3 days
(90 Reviews)
7.1
Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor More

$120 USD in 3 days
(256 Reviews)
6.9
periyannas

Ok Sure

$200 USD in 5 days
(116 Reviews)
6.4
best4best

Hi, I am an Excel expert. I can create an easy-to-use template with formulas to easily keep an eye for goals of each doctor. Please take a look at my portfolio (for Excel projects) and consider me for this project. More

$66 USD in 2 days
(161 Reviews)
6.4
TechnoGuruu

Hi, I have checked your project description and the attached file in details and I will build these excel sheet for you where you can manage all this required information in one place with graphs. I have expertise i More

$149 USD in 3 days
(86 Reviews)
6.0
macroPOL

Hello, I am Excel and VBA expert. What do the sheets look like for the daily team leaders information? If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-s More

$150 USD in 3 days
(94 Reviews)
6.0
c4cuteconain

I am a professional with a decade of experience working in a US based NASDAQ registered company. Can help you with your project as per your requirements. please send me a message to discuss further.

$138 USD in 3 days
(79 Reviews)
5.8
lightingdavid

Hello How are you? I have reviewed "I need an Excel except". I have good skills for these (Data Processing, Excel). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get pa More

$140 USD in 1 day
(90 Reviews)
5.8
dynamitewebsol

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you

$100 USD in 3 days
(12 Reviews)
5.2
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar More

$150 USD in 3 days
(69 Reviews)
5.7
dalsaniyasonu123

Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

$150 USD in 5 days
(45 Reviews)
5.2
sajidkhan45

Hi, I went through your complete description and excel file. Here are my ideas for the project: This project will be divided into 3 parts: Data Logger, Database generation and Reports. Forms can be created that au More

$250 USD in 3 days
(67 Reviews)
5.8
jsb1156

Experienced project professional, US based, MBA, EXCEL and MS Project expert; strong estimating background, experienced with complex formulas, LOOKUPS, PIVOTS, and charts towards the delivery financial analytics. I More

$100 USD in 3 days
(27 Reviews)
4.3
paulodayto08

Hi Good Day! A serious freelancer here! I can help you to complete this project in 1-2 days. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take More

$35 USD in 2 days
(40 Reviews)
4.5
sevillajk01

hello! let me do it for you. I have read the project description and checked your excel file. And this is what I can offer, I can create an interactive dashboard and gantt chart for you with a professional look. I off More

$250 USD in 10 days
(30 Reviews)
4.6
p0902

I have excellent excel skills and the job you require to be done, is right in my field of expertise. I work in the planning dept of a manufacturing company, and hence am very familiar with the daily goal setting and ac More

$166 USD in 2 days
(4 Reviews)
3.4
AMC1979

Good morning, My name is Albert and I have a lot of experience in Excel (including formulas, macros and VBA). I have been an Excel user for many years, I have taken courses and I have learned in a self-taught way all More

$150 USD in 7 days
(6 Reviews)
2.9
sambit892

Please give me this project Relevant Skills and Experience I am a web developer and Excel export

$155 USD in 3 days
(0 Reviews)
0.0