Create macro to dispatch timesheet
$30-250 USD
Betales ved levering
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 !
Prosjekt-ID: #12181599
Om prosjektet
Tildelt til:
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 macr Mer
30 frilansere byr i gjennomsnitt $142 for denne jobben
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 in Mer
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 o Mer
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.
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 :)
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 Hunga Mer
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 rega Mer
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 Reporti Mer
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.
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.
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.
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 Timeshe Mer
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. Mer
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 Mer
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