Completed

Create macro to dispatch timesheet

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 !

Skills: Excel

See more: software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, excel macro create unique file worksheet worksheet name, excel macro create shape, excel macro create txt file, software write protection, excel macro create text file, free software write book, software write book, set macro create email, outlook macro create alert, macro create thumbnails, vba macro create xml xls, outlook macro create folder, macro create dynamic chart excel 2003, excel macro create permutations, macro create html

About the Employer:
( 41 reviews ) lille, France

Project ID: #12181599

Awarded to:

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 More

$66 USD in 3 days
(62 Reviews)
0.0

32 freelancers are bidding on average $148 for this job

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 More

$120 USD in 2 days
(224 Reviews)
0.0
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 in 1 day
(26 Reviews)
0.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 More

$155 USD in 3 days
(57 Reviews)
0.0
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 More

$35 USD in 1 day
(31 Reviews)
0.0
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. More

$99 USD in 3 days
(42 Reviews)
0.0
CanadianQuality

Native English speaker. Excel/VBA expert. Soyez libre de communiquer en francais puisque je suis bilingue. I've looked at your file and I can definitely do this for you. I bid high because the work I provide is o More

$222 USD in 3 days
(2 Reviews)
0.0
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 More

$120 USD in 6 days
(43 Reviews)
0.0
vivirain

Hi, I'm an Excel VBA expert with rich similar programming experiences and I can help get it done before 1 Dec. However, I would like to clarify some questions with you: 1. Delivery file: .xlsx file can' More

$200 USD in 5 days
(10 Reviews)
0.0
zebracaro

I can do it for you quickly and exactly .

$120 USD in 5 days
(92 Reviews)
0.0
ludacar

Hello, I've been doing macros and VBA programming in excel for more than 10 years, 5 of them within a big enterprise with time constraints, so I'm sure you'll be satisfied with the result. I'll be glad to work fo More

$100 USD in 3 days
(0 Reviews)
0.0
vurititeja128

Hi this Ravi. I am working in testing from last 5 years. I use the excel macros every I can day to day work. till now I created different types excel VBA macros. I would like work with you if you are interested. pleas More

$166 USD in 3 days
(0 Reviews)
0.0
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 More

$155 USD in 4 days
(170 Reviews)
0.0
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 in 3 days
(301 Reviews)
0.0
mianimranamjad

Hello I’m very interested in your job post involving these skills. I have good experience in excel. I believe my skills would be ideal for your project. I can complete this job within the required time period. We can More

$88 USD in 1 day
(1 Review)
0.0
AlexandrUKR

hello, i have >15Y excel & VBA experience, could you clarify possible next steps? .

$250 USD in 7 days
(15 Reviews)
0.0
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 More

$140 USD in 5 days
(127 Reviews)
0.0
surgeonkirti

My overall goal is not just to build website but helps my clients realize their vision for their business. let me know if your are interested. i had really love to work on your site. Hope to hear from you soon.

$155 USD in 3 days
(0 Reviews)
0.0
Taisho

Hello, I have read the project requirements carefully and I'll be able to provide such solution with Excel VBA macros. One note - macro files can't have .xlsx format (.xlsm/.xlsb/.xls), but generating .xlsx file usi More

$95 USD in 3 days
(50 Reviews)
0.0
medway25

I believe that the best computing systems are those that offer users reliable facilities to do their own jobs, without needing to understand the details of the technologies involved. It is my vision to create, implemen More

$250 USD in 7 days
(0 Reviews)
0.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 More

$200 USD in 7 days
(115 Reviews)
0.0