Find Jobs
Hire Freelancers

Excel Commission Auto Calculator and Hourly Calculator - For Sales Reps

$30-250 USD

Annulleret
Slået op cirka 6 år siden

$30-250 USD

Betales ved levering
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.
Projekt-ID: 16284908

Om projektet

37 forslag
Projekt på afstand
Aktiv 6 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
37 freelancere byder i gennemsnit $157 USD på dette job
Brug Avatar.
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 MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you. Please pay me once job is 100% done.
$200 USD på 3 dage
5,0 (762 anmeldelser)
8,5
8,5
Brug Avatar.
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 på 3 dage
4,9 (359 anmeldelser)
7,5
7,5
Brug Avatar.
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 mentioned Active X programming - for implementing your requirements Active X may not necessarily be needed) and one folder with individual worksheets for each of the Sales Reps. When you click on a button in the Master Worksheet, the macro code will interact with all the individual Sales Rep worksheets as needed (commissions, hours and bonus calculations). Being a full time freelancer working exclusively on Excel based projects, I work on developing such solutions every single day. I have 18 years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation / modelling similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last 20 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Have a Great Day! Srinivasan Krishnamoorthi
$90 USD på 3 dage
5,0 (207 anmeldelser)
6,9
6,9
Brug Avatar.
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. Please refer my profile to see more details about me, and if you are comfortable, we can discuss the project. I look forward to hearing form you. Best regards Priyal
$90 USD på 2 dage
5,0 (195 anmeldelser)
6,8
6,8
Brug Avatar.
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 presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Just FYI, I own a small engineering consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/
$200 USD på 3 dage
4,8 (202 anmeldelser)
7,2
7,2
Brug Avatar.
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 for.
$172 USD på 3 dage
5,0 (120 anmeldelser)
6,5
6,5
Brug Avatar.
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 challenge for you, please send me a couple of agents excel files, and let me show you how I do a VBA function that fills some of the columns in a master sheet with a single click. Once you see it working, you can award me Meanwhile all your choices are open, you can select any other freelancer at any time, no questions asks, is the risk I'm willing to take Thanks, Felice
$222 USD på 5 dage
5,0 (13 anmeldelser)
6,3
6,3
Brug Avatar.
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, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
$170 USD på 2 dage
5,0 (34 anmeldelser)
5,8
5,8
Brug Avatar.
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. 3. Can complete on time with good quality and on time. 4. Experienced MBA Finance as well.
$138 USD på 2 dage
4,7 (69 anmeldelser)
5,7
5,7
Brug Avatar.
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 Regards Carlos
$222 USD på 10 dage
4,9 (32 anmeldelser)
5,0
5,0
Brug Avatar.
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 text me for further details. Regards.
$100 USD på 2 dage
4,5 (37 anmeldelser)
5,3
5,3
Brug Avatar.
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 graduate with 17 years experience using excel to solve complex business problems. My key strengths include: Financial analysis and modelling, Business Case Evaluation, Process Automation, API and Real Time Data Exchange, Business Intelligence, Web Scraping, Data Extraction, Data Aggregation, Master Data Management, VBA and Macro Troubleshooting / Development, Advanced Reporting and Dashboarding. Over and above my Excel knowledge and skills, I have 12 years corporate business experience and have developed strong commercial acumen around value delivery and customer service. I work quickly, accurately and professionally and am available immediately. Warm Regards Wesley Jeftha
$277 USD på 7 dage
5,0 (12 anmeldelser)
4,9
4,9
Brug Avatar.
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 in Data Entry, Data Processing, Excel, Order Processing, Visual Basic
$200 USD på 3 dage
4,8 (14 anmeldelser)
5,2
5,2
Brug Avatar.
A proposal has not yet been provided
$55 USD på 1 dag
4,9 (45 anmeldelser)
4,2
4,2
Brug Avatar.
A proposal has not yet been provided
$100 USD på 2 dage
5,0 (7 anmeldelser)
3,8
3,8
Brug Avatar.
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 once I get additional details. 2. I have worked for several years in excel and perform daily work using vba, user forms, pivot tables, formulas, etc. 3. I would start by committing to 3 days but this depends on the scope and could change 4. I have an extensive background in Excel. I would love to know more about your project.
$155 USD på 3 dage
5,0 (1 bedømmelse)
3,8
3,8
Brug Avatar.
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.
$180 USD på 8 dage
5,0 (5 anmeldelser)
3,6
3,6
Brug Avatar.
Hello, Hope you are doing well. I am a web developer and I have more than five years experience. I specialize in design and development for the purposes of informing and engaging the target audience. If you are trying to build your online presence and improve your graphical interfaces, design and web applications with quality then you on the right place. I am a professional full stack developer. I am committed to getting your job done with best quality. Thanks Atiqur Rahman
$155 USD på 3 dage
5,0 (3 anmeldelser)
3,2
3,2
Brug Avatar.
A proposal has not yet been provided
$133 USD på 3 dage
5,0 (1 bedømmelse)
3,0
3,0
Brug Avatar.
Hi Greetings of the Day, I understood requirement, I am interested in this task, I am full time freelancer carrying 13 yrs of experience in Mobile development, Web and Windows development using ASP.Net, MVC, C#, WPF, WCF, SQL server, Xamarin, WebAPI, JQuery, Bootstrap, Cr Reports, XML, ClassicASP, VB6, COM/DCOM etc Please feel free to contact me. skype: sahu_mk Thanks!
$155 USD på 3 dage
5,0 (1 bedømmelse)
1,8
1,8

Om klienten

Flag for UNITED STATES
United States
0,0
0
Medlem siden feb. 13, 2018

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.