Find Jobs
Hire Freelancers

Compile Excel Data

$25-100 CAD

Cerrado
Publicado hace más de 8 años

$25-100 CAD

Pagado a la 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 del proyecto: 9031782

Información sobre el proyecto

56 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
56 freelancers están ofertando un promedio de $73 CAD por este trabajo
Avatar del usuario
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 en 2 días
5,0 (638 comentarios)
8,3
8,3
Avatar del usuario
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 en 3 días
4,9 (261 comentarios)
7,6
7,6
Avatar del usuario
A proposal has not yet been provided
$80 CAD en 3 días
4,9 (183 comentarios)
7,7
7,7
Avatar del usuario
A proposal has not yet been provided
$100 CAD en 1 día
4,9 (255 comentarios)
7,7
7,7
Avatar del usuario
Hi! The attachment got some error and I could not download. Please if you could send me via chat. Thanks
$78 CAD en 2 días
4,9 (349 comentarios)
7,3
7,3
Avatar del usuario
A proposal has not yet been provided
$315 CAD en 1 día
5,0 (142 comentarios)
7,1
7,1
Avatar del usuario
A proposal has not yet been provided
$250 CAD en 3 días
4,8 (189 comentarios)
6,9
6,9
Avatar del usuario
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 en 1 día
5,0 (209 comentarios)
6,8
6,8
Avatar del usuario
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 en 0 día
4,9 (313 comentarios)
6,9
6,9
Avatar del usuario
I can do it for you quickly and exactly
$100 CAD en 3 días
4,9 (114 comentarios)
6,5
6,5
Avatar del usuario
"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 en 1 día
4,8 (122 comentarios)
6,1
6,1
Avatar del usuario
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 en 3 días
5,0 (64 comentarios)
5,7
5,7
Avatar del usuario
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 en 3 días
4,8 (73 comentarios)
5,8
5,8
Avatar del usuario
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 en 2 días
5,0 (33 comentarios)
5,2
5,2
Avatar del usuario
i have the expertise in excel and can create this report based on your specifications quickly and accurately.
$55 CAD en 1 día
4,6 (67 comentarios)
5,2
5,2
Avatar del usuario
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 en 1 día
4,9 (30 comentarios)
4,5
4,5
Avatar del usuario
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 en 2 días
4,8 (20 comentarios)
4,7
4,7
Avatar del usuario
A proposal has not yet been provided
$35 CAD en 1 día
4,9 (57 comentarios)
4,4
4,4
Avatar del usuario
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 en 2 días
5,0 (10 comentarios)
4,5
4,5
Avatar del usuario
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 en 3 días
5,0 (21 comentarios)
4,4
4,4

Sobre este cliente

Bandera de CANADA
Canada
0,0
0
Miembro desde dic 3, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos 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)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.