Find Jobs
Hire Freelancers

Compile Excel Data

$25-100 CAD

Fechado
Publicado há mais de 8 anos

$25-100 CAD

Pago na entrega
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 do Projeto: 9031782

Sobre o projeto

56 propostas
Projeto remoto
Ativo há 8 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
56 freelancers estão ofertando em média $73 CAD for esse trabalho
Avatar do Usuário
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 em 2 dias
5,0 (638 avaliações)
8,3
8,3
Avatar do Usuário
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 em 3 dias
4,9 (261 avaliações)
7,6
7,6
Avatar do Usuário
A proposal has not yet been provided
$80 CAD em 3 dias
4,9 (183 avaliações)
7,7
7,7
Avatar do Usuário
A proposal has not yet been provided
$100 CAD em 1 dia
4,9 (255 avaliações)
7,7
7,7
Avatar do Usuário
Hi! The attachment got some error and I could not download. Please if you could send me via chat. Thanks
$78 CAD em 2 dias
4,9 (349 avaliações)
7,3
7,3
Avatar do Usuário
A proposal has not yet been provided
$315 CAD em 1 dia
5,0 (142 avaliações)
7,1
7,1
Avatar do Usuário
A proposal has not yet been provided
$250 CAD em 3 dias
4,8 (189 avaliações)
6,9
6,9
Avatar do Usuário
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 em 1 dia
5,0 (209 avaliações)
6,8
6,8
Avatar do Usuário
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 em 0 dia
4,9 (313 avaliações)
6,9
6,9
Avatar do Usuário
I can do it for you quickly and exactly
$100 CAD em 3 dias
4,9 (114 avaliações)
6,5
6,5
Avatar do Usuário
"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 em 1 dia
4,8 (122 avaliações)
6,1
6,1
Avatar do Usuário
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 em 3 dias
5,0 (64 avaliações)
5,7
5,7
Avatar do Usuário
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 em 3 dias
4,8 (73 avaliações)
5,8
5,8
Avatar do Usuário
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 em 2 dias
5,0 (33 avaliações)
5,2
5,2
Avatar do Usuário
i have the expertise in excel and can create this report based on your specifications quickly and accurately.
$55 CAD em 1 dia
4,6 (67 avaliações)
5,2
5,2
Avatar do Usuário
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 em 1 dia
4,9 (30 avaliações)
4,5
4,5
Avatar do Usuário
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 em 2 dias
4,8 (20 avaliações)
4,7
4,7
Avatar do Usuário
A proposal has not yet been provided
$35 CAD em 1 dia
4,9 (57 avaliações)
4,4
4,4
Avatar do Usuário
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 em 2 dias
5,0 (10 avaliações)
4,5
4,5
Avatar do Usuário
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 em 3 dias
5,0 (21 avaliações)
4,4
4,4

Sobre o cliente

Bandeira do(a) CANADA
Canada
0,0
0
Membro desde dez. 3, 2015

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.