Σε Εξέλιξη

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 !

Δεξιότητες: Excel

Δείτε περισσότερα: 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

Σχετικά με τον Εργοδότη:
( 35 αξιολογήσεις ) lille, France

ID Εργασίας: #12181599

Ανατέθηκε στον/στην:

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 Περισσότερα

$66 USD σε 3 μέρες
(58 Αξιολογήσεις)
5.7

33 freelancers κάνουν προσφορές με μέσο όρο $151 γι' αυτή τη δουλειά

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 σε 3 μέρες
(267 Αξιολογήσεις)
6.7
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 Περισσότερα

$200 USD σε 5 μέρες
(152 Αξιολογήσεις)
6.5
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 σε 3 μέρες
(118 Αξιολογήσεις)
6.3
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 Περισσότερα

$140 USD σε 5 μέρες
(93 Αξιολογήσεις)
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 Περισσότερα

$200 USD σε 7 μέρες
(97 Αξιολογήσεις)
6.1
wsh2

ocarpentier writes: "The macro must be delivered into a .xlsx spreadsheet " NB: '*.xlsx' spreadsheets cannot contain macros. Greetings from the U S A.. {smile} Highly experienced (25+ years) MsEXCEL Business Pr Περισσότερα

$222 USD σε 3 μέρες
(24 Αξιολογήσεις)
5.7
zebracaro

I can do it for you quickly and exactly .

$120 USD σε 5 μέρες
(69 Αξιολογήσεις)
5.5
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 σε 3 μέρες
(78 Αξιολογήσεις)
5.2
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. Περισσότερα

$99 USD σε 3 μέρες
(39 Αξιολογήσεις)
5.5
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 Περισσότερα

$120 USD σε 2 μέρες
(74 Αξιολογήσεις)
5.3
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 σε 3 μέρες
(52 Αξιολογήσεις)
5.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 Περισσότερα

$140 USD σε 3 μέρες
(53 Αξιολογήσεις)
5.2
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 σε 1 μέρα
(17 Αξιολογήσεις)
4.8
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 Περισσότερα

$100 USD σε 4 μέρες
(33 Αξιολογήσεις)
4.6
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 Περισσότερα

$120 USD σε 6 μέρες
(31 Αξιολογήσεις)
4.2
The24CarrotsInc

A proposal has not yet been provided

$45 USD σε 2 μέρες
(16 Αξιολογήσεις)
3.9
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 Περισσότερα

$155 USD σε 4 μέρες
(9 Αξιολογήσεις)
3.6
ksinghrajeev

Hello There, Here are some of my work examples. Project Report Automation - [url removed, login to view] Log Report Automation - [url removed, login to view] Περισσότερα

$170 USD σε 5 μέρες
(6 Αξιολογήσεις)
3.7
humayoonsheikh4u

A proposal has not yet been provided

$250 USD σε 5 μέρες
(5 Αξιολογήσεις)
3.4
AlexandrUKR

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

$250 USD σε 7 μέρες
(3 Αξιολογήσεις)
3.5