Find Jobs
Hire Freelancers

Create macro to dispatch timesheet

$30-250 USD

Suoritettu
Julkaistu yli 7 vuotta sitten

$30-250 USD

Maksettu toimituksen yhteydessä
Hello I would like to get a Excel macro that displays hours timesheet in Excel from raw .xls file. We are a very small team and cannot afford to change our hour system. --------------------------- WHAT WE NEED My actual time tracking software delivers the attached export in .xls, with following columns : - projet (project name) - Intervenant (colleague involved) - Type de temps (nature of tasks done) - Taux horaire (hourly rate) - Description (text details about the task done) - date (date in DD/MM/YYYY format) - min (nb of minutes) My lacks with this existing system : - we don't have any sum (money or time) per project - we dont have time displayed in hours (minutes in note satisfying) - we can't easily sort time by projet => What I need : automatic Excel macro that splits project into multiple sheets and displays sums. --------------------------- DELIVERABLES : I need an excel macro that splits this data into multiple sheets within the excel document : - 1 projects Resume sheet - 1 people Resume sheet - several project sheets (one sheet per project, created automatically, rename with the name of the project) The macro must be delivered into a .xlsx spredsheet CONTENT OF PROJECT RESUME SHEET > header with : "Période : " (Displays time range : from DD/MM/YYYY to DD/MM/YYYY) "nombre de project" - nb of project : X (= number of project found) > data table "Projets facturés de la période", One row per project with two columns, sort by project name : - "projet" (project name) - Sous-total HT (sum of all due € of the project) Content for the last line of the table (with bold text) : - "Total" - x €HT (= final sum) CONTENT OF PEOPLE RESUME SHEET > header with : "Période : " (Displays time range : from DD/MM/YYYY to DD/MM/YYYY) "nombre d'intervenants : X" (= nb of people found in "Intervenant" columns ) > data table "Intervenants", several rows for each people, on row per project, sort by people name, with 3 columns : - Intervenant (colleague name) - "projet" (project name) - SS-total heures (sum of hours per project for this colleague Content for the last line of the table (with bold text) : - "Total" - x hour (= final sum of hours) CONTENT OF PROJECT SHEET = 8 columns : - date (date in DD/MM/YYYY format) - projet (project name) - Intervenant (person) - Type de temps (nature of tasks done) - Description (text details about the task done) - Taux horaire €HT (hourly rate in euros) - Heures (= number of hours,= 'min' (number of minutes) / 60) - €HT (= 'Taux horaire €HT' * Heures) ! - If 'Taux horaire €HT' = 0, the text the whole row must look erased like this (text with bar) --------------------------- DELAY : I would like to get this work done by the December 1st. WHO CAN APPLY FOR THIS PROJECT ? - some excel or VBA developer already skilled with excel macros --------------------------- thanks !
Projektin tunnus (ID): 12181599

Tietoa projektista

30 ehdotukset
Etäprojekti
Aktiivinen 7 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I can start working on the project immediately and complete the job within two maybe three days. Regards
$66 USD 3 päivässä
4,9 (64 arvostelua)
5,7
5,7
30 freelancerit tarjoavat keskimäärin $142 USD tätä projektia
Käyttäjän avatar
Hello, I am spreadsheet expert and visual basic programmer However, I have previously created macros to split spreadsheet to several files and I think I am the one you need PM me for further details if you will be interested Regards
$155 USD 4 päivässä
5,0 (199 arvostelua)
8,2
8,2
Käyttäjän avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$120 USD 2 päivässä
4,9 (346 arvostelua)
8,0
8,0
Käyttäjän avatar
Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on skype as well: ashish260287 Thanks and Regards, Ashish Singhal PLEASE CHANGE THE ATTACHED FILE'S FORMAT TO XLSM BEFORE USING.
$155 USD 3 päivässä
5,0 (200 arvostelua)
7,8
7,8
Käyttäjän avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD 3 päivässä
4,9 (401 arvostelua)
7,6
7,6
Käyttäjän avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) 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 USD 5 päivässä
4,9 (250 arvostelua)
7,6
7,6
Käyttäjän avatar
Hello Sir I already ready all your instruction and i can do your project Sir :) please give me a chance for doing your project and im able to start doing your project right now Thank You Sincerely Prameswara :)
$200 USD 3 päivässä
4,9 (378 arvostelua)
7,3
7,3
Käyttäjän avatar
Dear Sir/Madam, I have been working with Excel VBA for 4 years. I currently work as a data analyst at Ford Motor Company creating automated report and dashboards. Even though Ford is a big company, the HR in Hungary was struggling with timesheets in Excel format sent by each employee separately. I managed to come up with a solution that consolidated the timesheets of the month and created reports of it. I think I can help in your project too. Regards, Balint Kolosi
$140 USD 3 päivässä
5,0 (121 arvostelua)
7,0
7,0
Käyttäjän 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
$200 USD 5 päivässä
5,0 (271 arvostelua)
7,1
7,1
Käyttäjän avatar
I can do it for you quickly and exactly .
$120 USD 5 päivässä
4,9 (116 arvostelua)
7,1
7,1
Käyttäjän avatar
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. . I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$100 USD 4 päivässä
5,0 (209 arvostelua)
6,9
6,9
Käyttäjän avatar
Hello, I am Excel and VBA expert. I can provide a macro to test over the weekend. Please note that I have 100% completion rate and 5-star feedback on 50 projects.
$150 USD 3 päivässä
5,0 (93 arvostelua)
6,0
6,0
Käyttäjän avatar
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$200 USD 7 päivässä
4,9 (115 arvostelua)
6,2
6,2
Käyttäjän avatar
A proposal has not yet been provided
$45 USD 2 päivässä
4,9 (56 arvostelua)
5,7
5,7
Käyttäjän avatar
Hello, I am proficient with Excel and VBA and I have a lot of experience with projects very similar to this one. I would love to help you. Please contact me for more information.
$123 USD 3 päivässä
4,9 (134 arvostelua)
5,8
5,8
Käyttäjän avatar
Hi, i can help you with this project, and i will do my best to delver it to you ASAP today also my bid includes the support for this macro even when we done from the project.
$250 USD 1 päivässä
5,0 (26 arvostelua)
5,3
5,3
Käyttäjän avatar
Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have developed an Excel VBA program for Timesheet. So, I have excellent knowledge and experience of creating Timesheet data in excel VBA. Please check my portfolio "Work Management System" for this project. I also have expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management and creating reports. Ready to start please reply soon. Thanks, Virendra
$120 USD 6 päivässä
4,8 (69 arvostelua)
5,5
5,5
Käyttäjän avatar
Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$99 USD 3 päivässä
4,6 (43 arvostelua)
5,6
5,6
Käyttäjän avatar
A proposal has not yet been provided
$250 USD 5 päivässä
4,7 (12 arvostelua)
4,2
4,2
Käyttäjän avatar
Hi Employer, I have gone through the excel requirement. I can complete this work in a very short time. I have total 6+ years of experience in excel VBA. I have completed many of excel VBA projects successfully. Please let me know if interested. Thanks for the consideration!!
$35 USD 1 päivässä
4,5 (31 arvostelua)
4,2
4,2
Käyttäjän avatar
Hello, My proposal is to develop the windows based software in .net not macros. To generate the same outputs. but I want to see the raw files. Thanks, Sheik
$111 USD 5 päivässä
4,6 (4 arvostelua)
3,8
3,8

Tietoja asiakkaasta

Maan FRANCE lippu
La Madeleine, France
5,0
45
Maksutapa vahvistettu
Liittynyt syysk. 13, 2014

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.