Find Jobs
Hire Freelancers

Commission Spreadsheet

$15-25 USD / hour

已授予
已发布将近 10 年前

$15-25 USD / hour

I have an existing spreadsheet that is used on a regular basis to calculate the targets and commission for the sales team members. The spreadsheet currently works but needs some tweaking to improve the functionality and change some of the behaviour. The largest component of the project is to provide a faster and easier method of updating the workbook. The data is exported out of MYOB on a ad hoc basis, but typically weekly to monthly. I need a sliding scale of commission based upon the sales person's sales for the year. Not currently in the spreadsheet. I am currently using Pivot tables for the reports, this is working but if a better way can be proposed, happy to change. I need someone that can speak English and okay to use Skype to communicate. This will assist in explaining and what is required to be delivered in the project. I have added a sample file for the basis of this project.
项目 ID: 5969476

关于此项目

21提案
远程项目
活跃10 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
21威客以平均价$20 USD/小时来参与此工作竞价
用户头像
Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and very high completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you award me the project. Thanks, Jay
$15 USD 在7天之内
5.0 (426条评论)
7.8
7.8
用户头像
Hi Mate. I shall be glad to help you through with your sheet. I have been working with VBA Excel for some time and would be able to get it done. Kindly discuss so we may proceed swiftly. Regards. Usman.
$25 USD 在2天之内
4.9 (82条评论)
6.8
6.8
用户头像
Hello, my name is Cristian, I have a degree in Business and I am Financial Advisor. Working with excel every day, and have much experience with spreadsheets and complex formulas. I have my own spreadsheet that estimates the commissions I perceive by the business I do with my clients. But would need to talk to you to better understand the need for your project. Greetings.
$15 USD 在10天之内
5.0 (170条评论)
6.7
6.7
用户头像
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$21 USD 在5天之内
4.9 (105条评论)
6.2
6.2
用户头像
Hello ready to start asap to deliver you, If you can give me your notes and conditions, I can deliver it to you fast, I checked your file and sheets such as constants or sales pivot table but I like to hear more, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have a base of statistics, mathematics, accounting, cost calculating, project scheduling and project management and finance that helps in this project.
$15 USD 在10天之内
4.9 (63条评论)
5.2
5.2
用户头像
Hello I am so interested in your project. I have many experiences on Visual Basic and MS office/Excel I am looking forward to working with you. Hope your reply Thanks
$25 USD 在45天之内
5.0 (1条评论)
3.4
3.4
用户头像
Excel experience and accuracy in data handling My experience with spreadsheets comes since 30 years ago. In recent years I've been involved in financial analisys which I mainly perform by designing, filling and operating dedicated spreadsheets. In such a job I also need to handle big quantities of numbers and data that require high accuracy. As far as Engish and Skype are concerned: 1) I can speak English, maybe I will ask you to speak slowly, 2) I live in Italy, where time is GMT+1 (at present GMT+2 because of the DST), so I think we'll have to carefully schedule our calls: I can work late in the evening (night) so that we could meet in your morning time. I look forward to further discussing with you the details of the project.
$18 USD 在6天之内
4.9 (3条评论)
3.1
3.1
用户头像
Hi Greetings!! Having 4+ years’ experience in data analysis, data modeling and data entry in Excel. Placed a few documents in my portfolio, please have a look on those to get an idea on my skillsets and the quality. Will deliver the project beyond your expectation. I will automate all the output requirements of yours so that you will be required to only enter the input data and the results will be generated automatically to save your analysis time. Willing to work on this Project. Please contact me for discussing the way forward on this Project. Request to consider the BID. We can agree/negotiate upon the timelines and the BID values too. Thanks, Arun
$16 USD 在15天之内
5.0 (1条评论)
1.9
1.9
用户头像
Hi there Thanks for the opportunity to bid on your project. I think that your proposal seems relatively straightforward and I am confident that I can produce a good result for you. For starters I am fluent in English (I would certainly hope so anyway) and I live in Australia too so communication by phone is also an option. I work for an accounting firm so I am familiar with MYOB and my current work involves building various excel based VBA models. I could automate your tool completely so that all you would need to do is open your spreadsheet and click a macro enhanced button that would prompt you to locate the MYBO export file. The macro would then import the file data, sort and perform any other manual process that is currently performed manually within the workbook. You would be able to update your workbook in literally seconds any time in the month. I would be able to build separate reporting for each sales person and I could also include any other functionality that may be required such as charting and reporting. I look forward to possibly working with you and if I am not successful then good luck with your project. Regards Marko
$22 USD 在3天之内
5.0 (1条评论)
1.6
1.6
用户头像
Looking at the spreadsheet, I am assuming that the import function should change the format and values of "import" sheet to "data" sheet, adding the columns and formula. I am planning 4-5 hours to complete that, including a import button that does the formatting and changing The sliding scale of commission needs a bit more clarification, i.e. whether it should remain as a calculation in the "data" sheet with additional variables to relate to tiering levels or whether that should be done after the total sales or sales per category is calculated. Possibly 2-3 hours Improve reporting, just need to understand what information you require from the reports, besides calculating the commission per person. Leave about 2-4 hours for that task. Work throughput @ 2.5 hours per day would give 4 workdays. I travel over the weekends so I could complete this in 1 work week. Regards
$16 USD 在10天之内
5.0 (1条评论)
0.8
0.8
用户头像
Hi, let me help you. I've been doing commission statements with my current company. I'm excellent with excel formulas.
$22 USD 在3天之内
5.0 (1条评论)
0.0
0.0
用户头像
Im adept at developing report through visual basic and macro. We can do it through Excel/Word/Powerpoint/Access Databased.
$22 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, I saw your spread sheet and I am currently working on the similar projects. if you give your contact details I will update you with some example projects I have done......It is similar one you are asking for.. I will be able to make a user entry for for data entry and a graphical representation for the Result. Please consider my bid ..
$15 USD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
Dear Sir, I have been in this industry for 10 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I do not have any ratings/testimonials to show you. I can assure you that if you work with me once, you will always work with me for these kind of projects. Looking for your favourable reply. Thanks
$15 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$22 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Thanks for the opportunity to bid on your project. I have read your tender advert as well as the attached Spreadsheet. I currently have Excel 2007 deployed and have used Excel for full-featured Application development since Excel version 4. I will bring over 20 years in the software development industry with me. I am skype ready and proficient in English as well. Please contact me if you have questions on any or all aspects of my offer.
$22 USD 在3天之内
0.0 (1条评论)
2.9
2.9
用户头像
i am confident and well prepared for this job.i think my skills are very good for this job, because i am trained & i have experience.......
$16 USD 在5天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi Client, I am a Qualified Accountant (Working for North American groups) and have professional level expertise in Ms Excel and other accounting applications. I am a certified Microsoft Excel Expert member (MOS 77-888/ 882) Exam. This makes me competent enough to make real-time models and resolve practical and complex Excel models. I have constructed real-time automated work flow models in Excel with the assistance of VBA/SQL, which have given organizations optimized results in very less span. I hope, my expertise will deliver the desired results as per your request. Please feel free to discuss the project details and deadlines for your sales reports. P.S. I speak English and would be comfortable to work with SKYPE. Thanks, Fahad
$22 USD 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

AUSTRALIA的国旗
MELBOURNE, Australia
0.0
0
付款方式已验证
会员自4月 3, 2013起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。