Create macro to dispatch timesheet

Fullført Lagt ut 7 år siden Betales ved levering
Fullført 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 !

Excel

Prosjekt-ID: #12181599

Om prosjektet

30 bud Eksternt prosjekt Aktiv 7 år siden

Tildelt til:

nagybatonyi

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

$66 USD på 3 dager
(64 omtaler)
5.7

30 frilansere byr i gjennomsnitt $142 for denne jobben

sandroshubladze

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

$155 USD på 4 dager
(199 Omtaler)
8.2
schoudhary1553

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

$120 USD på 2 dager
(346 Omtaler)
8.0
asin1987

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: as Mer

$155 USD på 3 dager
(200 Omtaler)
7.8
P0L

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 på 3 dager
(401 Omtaler)
7.6
paris2785

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 y Mer

$140 USD på 5 dager
(250 Omtaler)
7.6
prameswara

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 på 3 dager
(378 Omtaler)
7.3
kolosibalint

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

$140 USD på 3 dager
(121 Omtaler)
7.0
elqueabandona

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

$200 USD på 5 dager
(271 Omtaler)
7.1
zebracaro

I can do it for you quickly and exactly .

$120 USD på 5 dager
(116 Omtaler)
7.1
ksriniravi

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

$100 USD på 4 dager
(209 Omtaler)
6.9
macroPOL

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 på 3 dager
(93 Omtaler)
6.0
dpune

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. Wai Mer

$200 USD på 7 dager
(115 Omtaler)
6.2
The24CarrotsInc

A proposal has not yet been provided

$45 USD på 2 dager
(56 Omtaler)
5.7
vlayausa

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 på 3 dager
(134 Omtaler)
5.8
MoohHHooM

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 på 1 dag
(26 Omtaler)
5.3
vsprybhanu

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

$120 USD på 6 dager
(69 Omtaler)
5.5
sonarkaushik

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

$99 USD på 3 dager
(43 Omtaler)
5.6
humayoonsheikh4u

A proposal has not yet been provided

$250 USD på 5 dager
(12 Omtaler)
4.2
shivaparvathi108

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

$35 USD på 1 dag
(31 Omtaler)
4.2
sheikDev

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 på 5 dager
(4 Omtaler)
3.8