# 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.

Concernant l'employeur :
( 0 commentaires ) United States

Nº du projet : #16284908

## 41 freelance font une offre moyenne de \$153 pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(559 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(181 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(193 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(237 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(140 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(105 Commentaires)
6.2
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(56 Commentaires)
5.1
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(29 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(11 Commentaires)
4.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(26 Commentaires)
5.3
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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(45 Commentaires)
5.2
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(12 Commentaires)
4.8
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(24 Commentaires)
4.7
maxvil32

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(45 Commentaires)
4.1
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(19 Commentaires)
4.3
brobb07

1. Excel expert with extensive vba programming experience. I can help get the calculations you require in each individual spreadsheet. I can then put together an automated process to update your master spreadsheet o Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
3.8
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, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(12 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(7 Commentaires)
3.6
ongskjason

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)
3.4
soltecke

Regards, My name is Kelvin Melendez, I'm a specialist in data mining, data science and business intelligence. We can help you with your requirement. We handle different data analysis tools such as: R, Python, Excel VB Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(2 Commentaires)
3.1