View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Export timsheet .csv; conversion rate from hours to days is variable - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

27 juin (16h-17h30)

16 juillet (10h-12h30)

22 août (16h-17h30)

12 sept (10h-12h30)

1er oct (16h-17h30)

 
 

Planifiez avec ProjeQtOr

18 et 19 juin (9h - 12h30)

18 et 19 septembre (9h - 12h30)

 
 

Administrez avec ProjeQtOr

25 et 26 juin (9h - 12h30)

25 et 26 juin (9h - 12h30)

 

 

 

Export timsheet .csv; conversion rate from hours to days is variable

More
02 Mar 2023 18:43 - 03 Mar 2023 12:00 #1 by Meldel1
Hello,
When I export to .csv from the timesheet field (all resources / all weeks) the output is a file with a work column and a cost column, as below
Example: (not including the last column that I have added and calculated)

id          resource  project      type of item    element id     name              assignment       work d    date cost             unit cost
20378    EB          O_01_x    Activity           170                3_Task 1         498                   0,03       28/02/202            369,3333333
20377    EB          R_15_z    Activity            363               Task3              1938                 0,47        02/03/2023          339,4680851
20376    EB          R_08_y    Activity           1750               2_Task4         1948                  0,07       02/03/2023           316,5714286

When I want to check the unit cost by dividing the cost by work, I should always have the same amount for each person, their hourly/daily rate on the same day shouldn't change; and yet, it does, as you can see.

In our system:
- the daily work hours cover a range of 8 hours with a pause in the middle
- the Unit for timesheet is set to hours
- the unit for workload is set to hours
- the number of hours per day is set to 7.6

I found in the Manuel a warning here: manual.projeqtor.org/html_en/GlobalParam...y-work-hours-section  (scroll to the Units for Work warning) that something could affect the rounding, but I sincerely don't understand what "both" is referring to and if this is what is impacting my exported values.

and yet, the conversion is sometimes 7.6, sometimes 7.5, sometimes something else, and I can't find an easy rounding error to rebuild the initial values.

Could anyone help me to understand why the conversion from hours to days is inconsistent? And how do we fix it so that on the export we have a consistent, reliable and steady conversion?

Alternatively, is there any other way of exporting the whole database directly in hours instead of days?

Many thanks for any pointers.

 
Last edit: 03 Mar 2023 12:00 by Meldel1. Reason: table formatting

Please Connexion or Create an account to join the conversation.

More
03 Mar 2023 11:48 #2 by babynus

unit cost by dividing the cost by work, I should always have the same amount for each person, their hourly/daily rate on the same day shouldn't change

Not so sure. Resources may have different "cost".

- the daily work hours cover a range of 8 hours with a pause in the middle

Is not important here, is used only to calculate open hours delays

- the Unit for timesheet is set to hours
- the unit for workload is set to hours
- the number of hours per day is set to 7.6
the conversion is sometimes 7.6, sometimes 7.5

Conversion should always be 7.6 as defined.
Issue is due to rounding at 2 digits of the export.
We'll have a look to improve this.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
03 Mar 2023 12:02 - 03 Mar 2023 12:16 #3 by Meldel1
Hi,
Thanks for this reply; is there any other way of exporting this information, rounding to at least 4 decimal points? (considering we can input hours to 2 decimal points, the conversion to days should at least be 4 decimals).

or could it just export in the format entered? ie in hours instead of days?
Last edit: 03 Mar 2023 12:16 by Meldel1.

Please Connexion or Create an account to join the conversation.

More
03 Mar 2023 16:28 #4 by babynus
Rounding removed on V10.2.3

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.044 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.