# 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

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

Proje NO: #16284908

## Bu iş için 41 freelancer ortalamada \$153 teklif veriyor

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 Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(559 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 Fazla

in %bids___i_period_sub_35% gün içinde90%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(181 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 Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(193 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 %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(237 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 Fazla

in %bids___i_period_sub_35% gün içinde90%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(140 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 Fazla

in %bids___i_period_sub_35% gün içinde172%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(105 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(56 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
4.8
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(26 Değerlendirme)
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. Daha Fazla

in %bids___i_period_sub_35% gün içinde138%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(45 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(24 Değerlendirme)
4.7
maxvil32

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(45 Değerlendirme)
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.

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
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, Daha Fazla

in %bids___i_period_sub_35% gün içinde170%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 Fazla

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
3.6
ongskjason

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde177%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
3.1