Açık

Excel Commission Auto Calculator and Hourly Calculator - For Sales Reps

We have a basic Excel spreadsheet with all of our agents having separate sheets to track their hours worked, how many sales they made, and any bonus given. We are growing from 50 to 150+ sales reps.

We need an Excel spreadsheet to subtract the 30% from the 100% $2.00 commission per sale in a column that regularly updates. The 30% is paid at the end of the contracted period and needs to auto-calculate and update a sum total per person, weekly.

We need hours auto-calculate $10.00 per hour for a sum total per week. We need the sum total of hours and 70% commission to be summarized per weekly pay period.

Then we need all bonus money auto-calculate and update at a sum per person.

We need the Excel file to auto-calculate the splits and totals and summarize and update each individual's information into a master sheet. This way we can keep the sheets confidential when sharing with the agent, and have an master sheet for management to work with.

Upon review this will likely require Active X programming which is beyond our scope of knowledge.

Total of 150+ agents and 17 possible columns on the master sheet that need to be programmed to automatically transfer to from the individual agent sheets.

*****UPDATED *******

We have a basic Excel spreadsheet with all of our agents having separate sheets to track their hours worked, how many sales they made, and any bonus given. We are growing from 50 to 150+ sales reps.

We need an Excel spreadsheet to subtract the 30% from the 100% $2.00 commission per sale in a column that regularly updates. The 30% is paid at the end of the contracted period and needs to auto-calculate and update a sum total per person, weekly.

We need hours auto-calculate $10.00 per hour for a sum total per week. We need the sum total of hours and 70% commission to be summarized per weekly pay period.

We have Sale's Leaders that on their sheets they need a bonus amount paid after x amount of sales are made. We need that bonus auto-calculate and auto-update to the master sheet.

Then we need all bonus money auto-calculate and update at a sum per person.

We need the Excel file to auto-calculate the splits and totals and summarize and update each individual's information into a master sheet.

The master sheet needs a column per agent total for spiffs and what the organization is spending on spiffs, then auto-calculate the sum total on the master sheet.

This way we can keep the sheets confidential when sharing with the agent, and have an master sheet for management to work with.

Upon review this will likely require Active X programming which is beyond our scope of knowledge.

Total of 150+ agents and 17 possible columns on the master sheet that need to be programmed to automatically transfer to from the individual agent sheets.

We plan to be using Google Spreadsheets - the version online for Excel - and we will give employee's access to their one sheet to update. This will auto-calculate and auto-update to the master sheet.

Beceriler: Veri Girişi, Veri İşleme, Excel, Sipariş İşleme, Visual Basic

Daha fazlasını görün: how to calculate commission in excel formula, tiered sales commission structure, excel tiered pricing formula, excel formula for tiered rates, excel tiered commission formula, how to calculate sales commission formula, sales incentive calculation excel format, calculate tiered fee schedule excel, standard commission for sales reps, headhunters for sales reps charlotte nc, headhunters for sales reps, engineering company looking for sales reps pe, companies looking for sales reps, agency for sales reps, ads for sales reps

İşveren Hakkında:
( 0 değerlendirme ) United States

Proje NO: #16284908

43 freelancers are bidding on average $154 for this job

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) I am an Engineering Graduate with an MB Daha fazlası

in 3 gün içinde200$ USD
(552 Değerlendirme)
8.2
priyal1997

Hi There, I can do this task perfectly for you. I am and expert in advanced excel skills and have a strong financial background. Moreover, have already done lots of similar customized excel template for businesses. P Daha fazlası

in 2 gün içinde90$ USD
(177 Değerlendirme)
6.7
cugamelover

I read your requirements carefully and I confirm that I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentat Daha fazlası

in 3 gün içinde200$ USD
(192 Değerlendirme)
7.1
P0L

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.

in 3 gün içinde150$ USD
(228 Değerlendirme)
6.9
ksriniravi

Greetings! I understand your requirements and can do the needful. Here is the architecture that I am envisaging. There will be one Master sheet with macro code (I would assume that is what you meant when you mention Daha fazlası

in 3 gün içinde90$ USD
(137 Değerlendirme)
6.5
katilinas

Hello, I'm ready to work on "excel commission + time calculators" project. Relevant Skills Excel, VBA Milestones 138 USD - code writing 34 USD - userfriendly interface I can achieve the results that you are asking Daha fazlası

in 3 gün içinde172$ USD
(103 Değerlendirme)
6.2
citijayamala

1. 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 markets. Daha fazlası

in 2 gün içinde138$ USD
(45 Değerlendirme)
5.2
in 3 gün içinde155$ USD
(23 Değerlendirme)
5.2
carlosperezit

Hi I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications I'm also available 24 x 7 Regard Daha fazlası

in 10 gün içinde222$ USD
(29 Değerlendirme)
4.9
WesleyJeftha

I will be able I do most of this project without the use of any macros at all. Contact me for more details.... Below is some general information about me: Good day, I am a Sydney based, English speaking university Daha fazlası

in 7 gün içinde277$ USD
(10 Değerlendirme)
4.8
royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Daha fazlası

1 gün içinde 30$ USD
(52 Değerlendirme)
5.0
awaisjahangir25

Hi, I’ve made various excel templates which are user friendly and dynamic in nature. I’ve advanced level skills of VBA and formulas along with dynamic charts. I can work out on you calculator for commission. Kindly Daha fazlası

in 2 gün içinde100$ USD
(24 Değerlendirme)
4.6
whitehorsetechn

Greeting, I have understood your Excel Commission Auto Calculator and Hourly Calculator task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience Daha fazlası

in 3 gün içinde200$ USD
(10 Değerlendirme)
4.5
JackieXu

hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard.

in 3 gün içinde150$ USD
(17 Değerlendirme)
4.3
maxvil32

A proposal has not yet been provided

1 gün içinde 55$ USD
(45 Değerlendirme)
4.1
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Daha fazlası

in 2 gün içinde170$ USD
(12 Değerlendirme)
3.9
FerriSoft1

I love this kind of challenges. I'm master in Excel VBA. I'm willing to do a proof of concept for you without being awarded just to take the risk of selecting the right candidate out of you. Let me solve a challe Daha fazlası

in 5 gün içinde222$ USD
(6 Değerlendirme)
3.5
ongskjason

A proposal has not yet been provided

in 2 gün içinde100$ USD
(3 Değerlendirme)
3.2
Carlosemadrizmor

Ready to build. Excel or MsAccess. We have a lot of VBA code tested and ready to use. I can work full time. Advance every day.

in 8 gün içinde180$ USD
(3 Değerlendirme)
3.1
stocktimemachine

I have some work, in an Excel spreadsheet. and have undertaken many complicated and extensive data entry projects in word and excel. We aim to serve you with quality and commitment to accuracy. i am a hard work Daha fazlası

in 15 gün içinde30$ USD
(1 Değerlendirme)
1.5