Käynnissä

Levels Bonus

Create a Levels Bonus spreadsheet (using the one attached).

Add all salespersons sales (deal credits) for each store to a combined total monthly sales tab. This should be a formula to automatically find the salesperson at each store's tab for that particular month. For example, Rosario has sales of 7.5+.5+2.5 at the GM, Imports and Toyota stores for a total January sales of 10.5.

Then set up a formula to calculate the 90 day average. In this spreadsheet the Nov-Dec-Jan would be totalled and divided by 3 to get the average.

Then RANK the salespeople based on most to least sales on the 90 day average ending January 2013.

Utlimately we'll add more months to the spreadsheet and allow it to automatically calculate all 3 stores total sales and the 90 day average of each.

Thank you.

Taidot: tiedonsyöttö, Excel

Näytä lisää: the levels, levels 2, excel spreadsheet formula, find a salesperson, GM, find salesperson, bonus, excel formula spreadsheet spreadsheet, data set formula, excel 2013 formula, salespeople, dec 2013, nov 2013, create tab excel, month month excel sales spreadsheet, levels, excel formula spreadsheet, calculate store data, data entry toyota, sales data entry example excel, data entry formula, spreadsheet store data entry, sales bonus spreadsheet, data ending, sales rank data

About the Employer:
( 1 review ) Clarksville, United States

Projektin tunnus: #4256595

Myönnetty käyttäjälle:

eugene2006

Hi. Looks like simple task. Regards, Eugene

40 $ USD 1 päivässä
(8 arvostelua)
3.3

6 freelanceria on tarjonnut keskimäärin 253 $ tähän työhön

binaryromel

##### Excel expert here! Please check PM. #####

50 $ USD 1 päivässä
(43 arvostelua)
5.1
rohitpithisaria

Hi I would like to apply for the posted by you. Rgds Rohit

80 $ USD 7 päivässä
(6 arvostelua)
3.4
seomaster212

Hi sir i am ready for work kindly i provide u 100% good work kindly i request u sir kindly check my private massages and let me know sir i am waiting for u great response thanks.

1000 $ USD 30 päivässä
(3 arvostelua)
3.0
AirDevelopers

Airborne Developers is interested in completing this project for you. Our staff are hired professionals that will help you complete your project with the best quality. Our support system is fast and efficient, you will Lisää

200 $ USD 5 päivässä
(0 arvostelua)
0.0
jani11

I have 10+ years advanced user experience on Excel; I can finish the task within 24 hours; I am familiar with macro level and have been building various financial spreadsheet models in my previous works and also as par Lisää

150 $ USD 1 päivässä
(0 arvostelua)
0.0