| Home > Forum Home > Excel Project Management Template > The Representation of decimal digits | Share |
The Representation of decimal digits
Excel Help for The Representation Of Decimal Digits in Excel Project Management Template
| Forum Topic | Post Reply Login |
The Representation Of Decimal Digits | Rate this: (3/5 from 1 vote) |
 | I have recently got the tool and I have some questions in order to understand the way it works. When I tried to define cost per hour for some human resources, I discovered that the tool is using "." instead of "," as separator of decimal digits. But when I took a look at the "Task" sheet, the field of "Total" cost (at Operating Costs) had a wrong calculated number. For example using 8,125 euros/hour (125 are the decimals) and 1.320 hours the result in the field is 10.725.000 which is not so correct. By changing in 8.125 the cost per hour I got the same result. Is it possible for someone to explain why this is happened. In my regional options (from the control panel of windows) the decimal symbol is "," Takis | |
| Posted by pskiniotis on | ||
| Replies - Displaying 1 to 6 of 6 | Order Replies By: Most Recent | Chronological | Highest Rated |
 | Rate this: (4/5 from 2 votes) |
| Posted by pskiniotis on |
 | Rate this: (3/5 from 1 vote) Commas can be used specify the decimal value within the Human Resources panel to define cost per hour. This way the subsequent calculations will process correctly using the consistent format. |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
 | Rate this: (3/5 from 1 vote) If you enter 8,13 this should work. We will look into extending the number of decimal places allowable in this field. |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
 | Rate this: (3/5 from 1 vote) A workaround to share tasks between multiple participants is to create instances of teh same task for each participant and then use productivity percentages to share the timing. If 2 particpants were sharing a task equally, 2 tasks could be created with same details except that each participant would be assigned 50% productivity. |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Rate this: (3/5 from 1 vote) I followed your advice but when I use comma (for example 8,125) in the definition of humans resource cost per hour, this is represented as 8.125 in the corresponding cell. When I try to staff a task, by default the cost is tansferred without any separator. I use comma for the unit cost in the edit task form and the result is the following: The cost per hour remains as 8.125 but the calculation (hours X cost/hour) is represented correctly. So I believe that is a matter of format that reflects to the appearence of numbers in the cells. |
| Posted by pskiniotis on |
| Rate this: (3/5 from 1 vote) Let me know something else. Is it possible to connect more than one persons from the human resource pool with the same task? Let suppose that I have 5 team members for the development of a project and I want to use 2 or 3 of them for the work in the same task. The form for the tasks definition allow to introduce only the responsible and the working parameters for him/her. Does the tool do any calculations in order to share the working time needed to complete a task between the connected human resources. |
| Posted by pskiniotis on |
| Displaying page 1 of 1 |
| Find relevant Excel templates and add-ins for The Representation of decimal digits in the Excel Business Solutions Directory |