Find Jobs
Hire Freelancers

Create an smart excel sheet to fill a report using data in csv format

€30-250 EUR

Terminado
Publicado hace más de 8 años

€30-250 EUR

Pagado a la entrega
I have to fill a monthly report showing the time I passed in each project, day by day. I use toggle as time tracker and extract a csv report by the end of the month. The cvs contains all entries, with task name, duration, project and client. I use then a pivot table and some copy and past to fill my company form. I'd like to have it automated. The file Feuille de tps is the one I filled for july. The sheet 201507 Summary Toggl Worktool is the one I used to manipulated data from toggle and Toggl_time_entries_2015-07-01_to_2015-07-31 is the csv file I extracted from toggl.
ID del proyecto: 8219950

Información sobre el proyecto

25 propuestas
Proyecto remoto
Activo hace 9 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
Adjudicado a:
Avatar del usuario
Hello. I'm understand how to do this job. Skills in VBA, experiance of working in excel, access two years. No problem with this job and those tasks from discription. I have birthday today, so you can so you can give me a present and accept my bid. Good luck and succeed in this project.
€30 EUR en 2 días
4,3 (5 comentarios)
2,7
2,7
25 freelancers están ofertando un promedio de €122 EUR por este trabajo
Avatar del usuario
A proposal has not yet been provided
€147 EUR en 3 días
5,0 (205 comentarios)
7,4
7,4
Avatar del usuario
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
€250 EUR en 2 días
4,9 (326 comentarios)
7,6
7,6
Avatar del usuario
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
€107 EUR en 3 días
5,0 (155 comentarios)
7,0
7,0
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
€140 EUR en 7 días
4,9 (214 comentarios)
7,4
7,4
Avatar del usuario
I can do it for you quickly and exactly. . . .
€100 EUR en 3 días
4,9 (114 comentarios)
7,0
7,0
Avatar del usuario
A proposal has not yet been provided
€66 EUR en 5 días
4,9 (331 comentarios)
6,8
6,8
Avatar del usuario
Hi: Please note that I have 100% completion rate and 5-star feedback on all projects (>60 total completed projects). More than 90% of my completed projects are related to Excel and VBA Script. Please check my profile to confirm the quality of my work. Please connect with me to discuss more
€100 EUR en 3 días
4,9 (165 comentarios)
7,0
7,0
Avatar del usuario
Hello, I reviewed the three spreadsheets you shared and have a good understanding of what you are looking for. Like you mentioned, this process can be automated such that all the data is transformed in your company's desired format on click of a button. I can write such a macro with some inputs from your side regarding which data goes where. I reviewed the data-sets and some data points from your pivots did not map to any cell in the output. Like for example Cadastro. So, are these files (input and output) from different time periods? Or what are the rules for mapping. If you could share this information, I would certainly be able to help you. With my strong work history here, I can assure you that the solution I create will save you many hours of work by reducing it to a button click. Do let me know if you would like me to work on this project for you and we may discuss the next steps. Look forward to working with you and thank you for considering my bid. Regards, Rishi Automyze Consulting - The Business Process Automation and Optimization Experts
€222 EUR en 7 días
4,9 (131 comentarios)
6,5
6,5
Avatar del usuario
Dear Miguel, I have 12 years of experience in data processing and analysis using Excel and VBA while working in finance, audit and accounting industries. I have completed a number of projects on Freelancer.com that required automation of data processing and reporting. I will be glad to help you with this project. Please contact me to discuss project details. Thank you!
€68 EUR en 2 días
5,0 (65 comentarios)
5,4
5,4
Avatar del usuario
A proposal has not yet been provided
€147 EUR en 3 días
4,9 (9 comentarios)
5,1
5,1
Avatar del usuario
I have the expertise in Excel and i can created the file with a script based on your description. Ready to start work immediately
€77 EUR en 1 día
4,5 (65 comentarios)
5,3
5,3
Avatar del usuario
I have completed projects more or less like this one. The Excel data will be consolidated as you wish. 2 hours work.
€55 EUR en 3 días
5,0 (21 comentarios)
4,4
4,4
Avatar del usuario
Hi, I can help you with the task. Please check out my profile - I am a geek for Microsoft Office automation. Looking forward to working with you. Regards
€110 EUR en 3 días
5,0 (11 comentarios)
4,5
4,5
Avatar del usuario
hello. i can do this for you. i have experience and expertise in excel and developing macros. please see my feedbacks.
€111 EUR en 3 días
5,0 (2 comentarios)
2,9
2,9
Avatar del usuario
Hi, Very interesting project. I really like VBA challenges. I am using and teaching VBA for over 10 years now and I can do this project in the best way possible. Looking forward to hear from you, Best Regards, Amin
€222 EUR en 5 días
5,0 (1 comentario)
0,8
0,8
Avatar del usuario
Dear Sir/Madam, I hope that you are well today. I posses the required skills as per your request to handle your work with utmost professionalism . I offer quality work and timely delivery; this makes me well suited to handle your work. The quality will make you keep coming for more. Kindly allow me to work on to your project. Regards, Munyuahmw
€72 EUR en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, client. I have just read your post and was excited with feeling to satisfy you in this job. I have rich knowledge and experience in Excel VBA. If you hire me, i will complete within 2days. Thanks
€70 EUR en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
my current job profile in automation of ms office using visual basic (VBA). i have been doing this from past 7 years. so i know all about vba fir excel. can easily automate this task for u and make it even better n user friendly. If you give me this i would never disappoint you.
€100 EUR en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am good with creating Reporting Dashboard using VBA and Excel. I already work on such scenario with my current project and i think i can help you out automation wherein you just need to copy paste data from csv to one file and it will calculate all calculation as you did for July. Though i need some clarification for calculation you previously did. So it will be good if we can discuss the same before moving forward. Thanks awaiting for your response.
€111 EUR en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
€222 EUR en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de BRAZIL
São Paulo, Brazil
0,0
0
Forma de pago verificada
Miembro desde jul 28, 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.