Find Jobs
Hire Freelancers

Excel Macro Programming - import an Excel file and transform the data into comfortable sheets - worktime recording

€750-1500 EUR

Concluído
Publicado há mais de 4 anos

€750-1500 EUR

Pago na entrega
Our telematics platform delivers an xls, xlsx file for a certain period, e.g. 1st of month for last month. This file contains all the tracked data and time stamps an employee has done in that period. It is far too much information for the average user (craftmen, Service, construction SME companies) to sort out and to handle the data easily for the hour [login to view URL] raw file contains only tracked data. If there is a holiday, vacancies, seminars or illness there is no data. What we need is an Excel program (macro) which read (Import) that raw tracking data and transforms it into a monthly overview with weekdays. Please see uploaded files attached. Goal is to have an Excel sheet with intelligent macros for easy handling of worktime recorded by tracking system.
ID do Projeto: 20677046

Sobre o projeto

74 propostas
Projeto remoto
Ativo há 5 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
Concedido a:
Avatar do Usuário
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will transform data from a raw table into a useful format. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you 1,000€* and can deliver within a week (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel, and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 320 projects successfully in six years, and I feel confident in achieving your task as well. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
€1.000 EUR em 7 dias
5,0 (675 avaliações)
8,7
8,7
74 freelancers estão ofertando em média €949 EUR for esse trabalho
Avatar do Usuário
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
€750 EUR em 10 dias
5,0 (806 avaliações)
8,4
8,4
Avatar do Usuário
Dear Employer, I have checked both your files and I understand you need to sort out the heavy data files that you have in structured data which can be easily used. I am an expert with over 12 years of experience and will do a perfect job asap. Please do check my previous reviews once for your kind consideration!! :) Thanks and Regards, Ash
€750 EUR em 7 dias
5,0 (288 avaliações)
8,4
8,4
Avatar do Usuário
Hi, Iam good at Excel VBA programming. I have referred the details. I can include the working dates, holidays & ill dates for the dates missing. Looking forward to discuss the project. -chandra
€1.176 EUR em 7 dias
5,0 (1238 avaliações)
8,5
8,5
Avatar do Usuário
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 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, Sandeep
€1.200 EUR em 12 dias
4,9 (569 avaliações)
8,5
8,5
Avatar do Usuário
Hello, I’m an Excel/VBA expert and I have work experience on many similar projects. I'm fully available and I can start right away. By the way, what's your timeframe for this project? Please check my profile and contact me to discuss. Regards.
€900 EUR em 5 dias
5,0 (511 avaliações)
8,1
8,1
Avatar do Usuário
Hello, I am Highly experienced Excel Expert and VBA Developer Can definitely create for you desirable working file If you will be interested, contact me Thanks & Regards
€950 EUR em 10 dias
5,0 (153 avaliações)
8,2
8,2
Avatar do Usuário
Hi, my name is Selim. I am from Solihull, UK. I read your `Excel Macro Programming - import an Excel file and transform the data into comfortable sheets - worktime recording` project descriptions carefully before bidding. I checked the attached templates as well... I got what you need and ready to go ahead as soon as we can clarify further project details. 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 data extraction, aggregation and 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... Kind Regards, Selim
€900 EUR em 10 dias
5,0 (306 avaliações)
8,2
8,2
Avatar do Usuário
Hi there, I'm Mauricio, the VBA and MS Excel expert from Trascender Global Team, with 4 years of experience in building VBA based dashboards to manage and visualize temporary information. I've read the details and checked the files attached of your project and I'm highly interested in building a complete dashboard that will allow you to calculate your KPIs and visualize the information. I will be building a VBA macro that will take the current row data and will allow you to review, by month with weekdays, by quarter and by year, so you can have deeper analysis from this information. Let's chat so we can talk about the details of the project. Looking forward to hearing from you.
€1.000 EUR em 7 dias
4,9 (173 avaliações)
7,9
7,9
Avatar do Usuário
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing, Virtual Assistance and Touch Typing 60wpm Skills. Please Visit My Portfolio to see sample work I did for my numerous clients. Portfolio: https://www.freelancer.com/u/khudammunir?page=portfolio&w=f
€1.000 EUR em 3 dias
4,9 (43 avaliações)
7,8
7,8
Avatar do Usuário
Hello Sir. Im excel vba macro and formula expert. i can do make macro for import your exsting data and can analyze it like you need. please ping me now and im free to start discuss more now. Thank You Galih
€750 EUR em 10 dias
4,9 (426 avaliações)
7,6
7,6
Avatar do Usuário
Hi there, I can create that complex macro for you without problems. Please feel free to contact me to discuss further details. Best regards Miljan ps Wir können auch gerne Deutsch sprechen :)
€882 EUR em 6 dias
4,9 (163 avaliações)
7,8
7,8
Avatar do Usuário
With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked the attached workbook as well… I can write the macro to transform the raw data to readable worktime record. Kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further and work on your project.
€1.000 EUR em 10 dias
5,0 (184 avaliações)
7,6
7,6
Avatar do Usuário
Hi, I am financial experts and gurus in Microsoft Office, Power BI and /VBA/Macro. I have considerable experience in merging files and manipulating the data in a structured database, especially with importing external files to a structured database in Excel and vice versa (+ automation with VBA). I work with advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, user-forms, drop-down boxes, generator reports, charts (by scripts) and API (trading, google maps SQL etc.). Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, payrolls,multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I develop modules which incorporate complex components of business in a simplified and logical manner. I am sure that my combined knowledge, skills and creativity will lead to exceptional results that will exceed your expectations.
€1.000 EUR em 7 dias
4,9 (96 avaliações)
7,5
7,5
Avatar do Usuário
Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced Windows Desktop Apps Developer (C#, C++), Web Data Extractor & Automator (using diff tools like .NET, Excel and VBA, Winautomation, etc) and I'd like to help you. Please, get in touch to discuss and understand all the details in deep. Based on what we will talk, I'll be able to give you a good proposal. Experience building solutions like: Windows Desktop Apps (using Excel and VBA, Access and VBA, .NET,C++,C#, Winautomation) Scrapers Apps Scrape services Automation programs/bots Web apps/systems. Message me to have the whole idea about your project. Will wait for your contact. Thanks.
€1.000 EUR em 10 dias
5,0 (183 avaliações)
7,3
7,3
Avatar do Usuário
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 290+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
€900 EUR em 7 dias
4,9 (268 avaliações)
7,1
7,1
Avatar do Usuário
I am excel and vba expert, I am interested in your project, lets discuss . Malik
€750 EUR em 7 dias
5,0 (100 avaliações)
6,9
6,9
Avatar do Usuário
I can do it for you quickly and exactly .Please contact me for saving your time and your money .
€900 EUR em 7 dias
4,9 (136 avaliações)
7,2
7,2
Avatar do Usuário
Hello there. Ready to work on your project. Over 15 years of experience in software development including Excel macros. I can also develop you the macro as Excel add-in where whenever you open the files there will be a separate tab in Excel with all necessary buttons. Please contact me if interested. Best regards, Tolib
€770 EUR em 7 dias
5,0 (122 avaliações)
7,1
7,1
Avatar do Usuário
Hi, Would you like to see a quick demo of your Excel sheet with a macro that reads raw tracking data and transform it into a monthly overview with weekdays before you award the project? You can consider it professionally done in less than 24 hrs. Before you award this project, I can complete a part of this project as a proof of concept. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time
€1.000 EUR em 5 dias
4,9 (74 avaliações)
7,0
7,0
Avatar do Usuário
Hello! I am Branislav from Serbia, we are in the same time zone. And I know enough of German to handle files on German. What I am interested in, in the first place, why not a database for this? Such calculations are quite easy to perform in a database (Microsoft Access) while on output there will be a report in the desired format (file Telematics-Report). If it is because the users, I will write an Excel macro (VBA actually) to calculate and produce desired reports. Regards, Branislav Mihaljev
€1.125 EUR em 7 dias
5,0 (105 avaliações)
6,9
6,9

Sobre o cliente

Bandeira do(a) GERMANY
Stuttgart, Germany
5,0
11
Método de pagamento verificado
Membro desde set. 11, 2016

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.