Κλειστη

Create macro to dispatch timesheet

Αυτό το πρότζεκτ ανατέθηκε στον nagybatonyi για $66 USD.

Λάβετε δωρεάν αναφορές για ένα πρότζεκτ σαν αυτό
Εργασία Εργοδότη
Προϋπολογισμός Εργασίας
$30 - $250 USD
Σύνολο Προσφορών
33
Περιγραφή Εργασίας

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 !

Ανατέθηκε στον:
Απαιτούμενες Δεξιότητες

Ψάχνετε τρόπους για να κερδίσετε μερικά χρήματα;

  • Ορίστε τον προϋπολογισμό σας και το χρονικό πλαίσιο
  • Περιγράψτε την πρότασή σας
  • Πληρωθείτε για τη δουλειά σας

Προσλάβετε Freelancers που ήδη έχουν υποβάλει προσφορά σε αυτή την εργασία

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online