Find Jobs
Hire Freelancers

Compile Excel Data

$25-100 CAD

Lukket
Slået op over 8 år siden

$25-100 CAD

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

Om projektet

56 forslag
Projekt på afstand
Aktiv 8 å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
56 freelancere byder i gennemsnit $73 CAD på dette job
Brug Avatar.
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 på 2 dage
5,0 (638 anmeldelser)
8,3
8,3
Brug Avatar.
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 på 3 dage
4,9 (261 anmeldelser)
7,6
7,6
Brug Avatar.
A proposal has not yet been provided
$80 CAD på 3 dage
4,9 (183 anmeldelser)
7,7
7,7
Brug Avatar.
A proposal has not yet been provided
$100 CAD på 1 dag
4,9 (255 anmeldelser)
7,7
7,7
Brug Avatar.
Hi! The attachment got some error and I could not download. Please if you could send me via chat. Thanks
$78 CAD på 2 dage
4,9 (349 anmeldelser)
7,3
7,3
Brug Avatar.
A proposal has not yet been provided
$315 CAD på 1 dag
5,0 (142 anmeldelser)
7,1
7,1
Brug Avatar.
A proposal has not yet been provided
$250 CAD på 3 dage
4,8 (189 anmeldelser)
6,9
6,9
Brug Avatar.
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 på 1 dag
5,0 (209 anmeldelser)
6,8
6,8
Brug Avatar.
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 på 0 dag
4,9 (313 anmeldelser)
6,9
6,9
Brug Avatar.
I can do it for you quickly and exactly
$100 CAD på 3 dage
4,9 (114 anmeldelser)
6,5
6,5
Brug Avatar.
"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 på 1 dag
4,8 (122 anmeldelser)
6,1
6,1
Brug Avatar.
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 på 3 dage
5,0 (64 anmeldelser)
5,7
5,7
Brug Avatar.
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 på 3 dage
4,8 (73 anmeldelser)
5,8
5,8
Brug Avatar.
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 på 2 dage
5,0 (33 anmeldelser)
5,2
5,2
Brug Avatar.
i have the expertise in excel and can create this report based on your specifications quickly and accurately.
$55 CAD på 1 dag
4,6 (67 anmeldelser)
5,2
5,2
Brug Avatar.
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 på 1 dag
4,9 (30 anmeldelser)
4,5
4,5
Brug Avatar.
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 på 2 dage
4,8 (20 anmeldelser)
4,7
4,7
Brug Avatar.
A proposal has not yet been provided
$35 CAD på 1 dag
4,9 (57 anmeldelser)
4,4
4,4
Brug Avatar.
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 på 2 dage
5,0 (10 anmeldelser)
4,5
4,5
Brug Avatar.
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 på 3 dage
5,0 (21 anmeldelser)
4,4
4,4

Om klienten

Flag for CANADA
Canada
0,0
0
Medlem siden dec. 3, 2015

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.