Find Jobs
Hire Freelancers

Compile Excel Data

$25-100 CAD

Ditutup
Disiarkan lebih dari 8 tahun yang lalu

$25-100 CAD

Dibayar semasa penghantaran
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 Projek: 9031782

Tentang projek

56 cadangan
Projek jarak jauh
Aktif 8 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
56 pekerja bebas membida secara purata $73 CAD untuk pekerjaan ini
Avatar Pengguna
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 dalam 2 hari
5.0 (638 ulasan)
8.3
8.3
Avatar Pengguna
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 dalam 3 hari
4.9 (261 ulasan)
7.6
7.6
Avatar Pengguna
A proposal has not yet been provided
$80 CAD dalam 3 hari
4.9 (183 ulasan)
7.7
7.7
Avatar Pengguna
A proposal has not yet been provided
$100 CAD dalam 1 hari
4.9 (255 ulasan)
7.7
7.7
Avatar Pengguna
Hi! The attachment got some error and I could not download. Please if you could send me via chat. Thanks
$78 CAD dalam 2 hari
4.9 (349 ulasan)
7.3
7.3
Avatar Pengguna
A proposal has not yet been provided
$315 CAD dalam 1 hari
5.0 (142 ulasan)
7.1
7.1
Avatar Pengguna
A proposal has not yet been provided
$250 CAD dalam 3 hari
4.8 (189 ulasan)
6.9
6.9
Avatar Pengguna
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 dalam 1 hari
5.0 (209 ulasan)
6.8
6.8
Avatar Pengguna
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 dalam 0 hari
4.9 (313 ulasan)
6.9
6.9
Avatar Pengguna
I can do it for you quickly and exactly
$100 CAD dalam 3 hari
4.9 (114 ulasan)
6.5
6.5
Avatar Pengguna
"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 dalam 1 hari
4.8 (122 ulasan)
6.1
6.1
Avatar Pengguna
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 dalam 3 hari
5.0 (64 ulasan)
5.7
5.7
Avatar Pengguna
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 dalam 3 hari
4.8 (73 ulasan)
5.8
5.8
Avatar Pengguna
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 dalam 2 hari
5.0 (33 ulasan)
5.2
5.2
Avatar Pengguna
i have the expertise in excel and can create this report based on your specifications quickly and accurately.
$55 CAD dalam 1 hari
4.6 (67 ulasan)
5.2
5.2
Avatar Pengguna
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 dalam 1 hari
4.9 (30 ulasan)
4.5
4.5
Avatar Pengguna
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 dalam 2 hari
4.8 (20 ulasan)
4.7
4.7
Avatar Pengguna
A proposal has not yet been provided
$35 CAD dalam 1 hari
4.9 (57 ulasan)
4.4
4.4
Avatar Pengguna
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 dalam 2 hari
5.0 (10 ulasan)
4.5
4.5
Avatar Pengguna
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 dalam 3 hari
5.0 (21 ulasan)
4.4
4.4

Tentang klien

Bendera CANADA
Canada
0.0
0
Ahli sejak Dis 3, 2015

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.