Find Jobs
Hire Freelancers

Compile Excel Data

$25-100 CAD

クローズ
投稿日: 8年以上前

$25-100 CAD

完了時にお支払い
I need to compile data from one worksheet and have it output onto another. We have a tip pool at our restaurant and data is entered manually for each business day. At the end of each week, each employee needs to have their tips added up and then distributed. Right now, we do the compilation of data manually but I assume that it can be done with a macro. I have attached two sample files as an example. The first is the spreadsheet that has been completed with the tip earnings of each employee from the particular shift they worked. The second is the compilation sheet - the one I am looking to have created automatically by a macro. The formatting is the way I would like it laid out. Basically, I need the macro to search the one spreadsheet and output a second worksheet that has the totals for each person for the week. It needs to be broken out into day shift and night shift for each day and then the sum for the week at the end. I have set the budget low as I don't think this will take too long since it doesn't seem that complicated. I just don't have the skill set to complete the task. If you think it should be more, contact me with your explanation as to why.
プロジェクト ID: 9031782

プロジェクトについて

56個の提案
リモートプロジェクト
アクティブ 8年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に56人のフリーランサーが、平均$73 CADで入札しています
ユーザーアバター
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 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 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 consider awarding me the project. Thanks, Jay
$50 CAD 2日以内
5.0 (638 レビュー)
8.3
8.3
ユーザーアバター
Hi, my name is Sevinc. I read your "Compile Excel Data" project descriptions carefully before bidding. I checked the attached teplate as well...I got what you need and ready to go ahead as soon as we can clarify further project details, along with the output template you need to have... I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
$100 CAD 3日以内
4.9 (261 レビュー)
7.6
7.6
ユーザーアバター
A proposal has not yet been provided
$80 CAD 3日以内
4.9 (183 レビュー)
7.7
7.7
ユーザーアバター
A proposal has not yet been provided
$100 CAD 1日以内
4.9 (255 レビュー)
7.7
7.7
ユーザーアバター
Hi! The attachment got some error and I could not download. Please if you could send me via chat. Thanks
$78 CAD 2日以内
4.9 (349 レビュー)
7.3
7.3
ユーザーアバター
A proposal has not yet been provided
$315 CAD 1日以内
5.0 (142 レビュー)
7.1
7.1
ユーザーアバター
A proposal has not yet been provided
$250 CAD 3日以内
4.8 (189 レビュー)
6.9
6.9
ユーザーアバター
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$50 CAD 1日以内
5.0 (209 レビュー)
6.8
6.8
ユーザーアバター
Hello Sir Im excel VBA Macro and formula Expert :) i can do anything in excel :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara
$25 CAD 0日以内
4.9 (313 レビュー)
6.9
6.9
ユーザーアバター
I can do it for you quickly and exactly
$100 CAD 3日以内
4.9 (114 レビュー)
6.5
6.5
ユーザーアバター
"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. -- Kinds Regards, Mehedi Hasan.
$66 CAD 1日以内
4.8 (122 レビュー)
6.1
6.1
ユーザーアバター
Hello, I am Excel and VBA expert. I can complete this project. Could you provide the files? I can not download the file (error). Please note that I have 100% completion rate and 5-star feedback on projects.
$45 CAD 3日以内
5.0 (64 レビュー)
5.7
5.7
ユーザーアバター
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 50 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$44 CAD 3日以内
4.8 (73 レビュー)
5.8
5.8
ユーザーアバター
Hello I am Shahed from BDtW. Thank you for the kind explanation of your requirements. Unfortunately we are not being able to download the file attachment but we can assure you that we can write a macro with VBA that extract & calculate the tips totals for each employee for the week and automatically generate/distribute the whole weeks tips. It will then display the output onto a different tab. We understand that there are differences between day and night shifts, and the proportion may vary accordingly, but we can apply the rule as soon as we understand the logic behind it. Our qualifications And experiences: From our profile you’ll see that our team earned a good reputation from clients for the good works provided through the years. All our completed works here have been about using VBA to write macros that manipulate data in various manners. So far in all cases our clients have been very happy with the services we provided them. We use VBA to cleanse spreadsheets, format data (based on logics) and move/manipulate them over worksheets, workbooks or office applications. Currently we work from our office as a team and our workplace is well equipped with an excellent communication system. Please let us know if you have any queries or if you want to discuss anything related to the requirements. With thanks & best regards Shahed BDtW
$38 CAD 2日以内
5.0 (33 レビュー)
5.2
5.2
ユーザーアバター
i have the expertise in excel and can create this report based on your specifications quickly and accurately.
$55 CAD 1日以内
4.6 (67 レビュー)
5.2
5.2
ユーザーアバター
Hi, Please give me a chance to make your work done in time accordingly as desired. Besides this my expertise in MS Office, Presentations, Data Entries, Designing, PDF document, Google Spreadsheet, VBA, Macros and Typing. Your response is being awaited.
$52 CAD 1日以内
4.9 (30 レビュー)
4.5
4.5
ユーザーアバター
Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA
$60 CAD 2日以内
4.8 (20 レビュー)
4.7
4.7
ユーザーアバター
A proposal has not yet been provided
$35 CAD 1日以内
4.9 (57 レビュー)
4.4
4.4
ユーザーアバター
Hello, I'm an expert in VBA and VB.NET, with almost 10 years of experience. The link doesn't seem to work, so I wasn't able to take a look at the excel file. But almost anything that is repetitive work in Excel can be automated with a macro. Based on your explanation it doesn't seem to be much work. I'm sure I will be able to finish this within a day or two. I'm still new at freelancer.com, but have already finished a couple of similar projects here. Hope to hear from you. Best regards Wesley
$40 CAD 2日以内
5.0 (10 レビュー)
4.5
4.5
ユーザーアバター
Hello, I was not thinking about giving a bid, as your file was not working, last time I checked it. However it seems like an easy macro work, and here is my offer. Best Regards,
$46 CAD 3日以内
5.0 (21 レビュー)
4.4
4.4

クライアントについて

CANADAのフラグ
Canada
0.0
0
メンバー登録日:12月 3, 2015

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。