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

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #16284908

## 41 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

\$200 USD 3 päivässä
(559 arvostelua)
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 Lisää

\$90 USD 2 päivässä
(181 arvostelua)
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 Lisää

\$200 USD 3 päivässä
(193 arvostelua)
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.

\$150 USD 3 päivässä
(237 arvostelua)
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 Lisää

\$90 USD 3 päivässä
(140 arvostelua)
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 Lisää

\$172 USD 3 päivässä
(105 arvostelua)
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 Lisää

\$30 USD 1 päivässä
(56 arvostelua)
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 Lisää

\$222 USD 10 päivässä
(29 arvostelua)
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 Lisää

\$277 USD 7 päivässä
(11 arvostelua)
4.8
\$155 USD 3 päivässä
(26 arvostelua)
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. Lisää

\$138 USD 2 päivässä
(45 arvostelua)
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 Lisää

\$200 USD 3 päivässä
(12 arvostelua)
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 Lisää

\$100 USD 2 päivässä
(24 arvostelua)
4.7
maxvil32

A proposal has not yet been provided

\$55 USD 1 päivässä
(45 arvostelua)
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.

\$150 USD 3 päivässä
(19 arvostelua)
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 Lisää

\$155 USD 3 päivässä
(1 arvostelu)
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, Lisää

\$170 USD 2 päivässä
(12 arvostelua)
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 Lisää

\$222 USD 5 päivässä
(7 arvostelua)
3.6
ongskjason

A proposal has not yet been provided

\$100 USD 2 päivässä
(4 arvostelua)
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 Lisää

\$177 USD 10 päivässä
(2 arvostelua)
3.1