topic Re: Getting a correct SUM of zones within interactive schedu in Collaboration with other software

Getting a correct SUM of zones within interactive schedules

Anonymous — Wed, 29 Apr 2009 17:48:52 GMT

I have got a problem to get correct sum of quantities (the elements quantified are zones).

When I use AC12 and and interactive schedules the result is partially right. In the attached picture 3 columns are wrong : SHOB, d and S'x0,95. When I collect the data and use MSXLS to calculate the sums, the result is totally correct. Same with any calculator.

How can I set AC12 to get all sums correct ? Is it possible ? Are there specific settings to push AC12 to display correctly this quantities collected from zones within interactive schedules ?

Re: Getting a correct SUM of zones within interactive schedu

David Maudlin — Thu, 30 Apr 2009 11:44:03 GMT

Til:

This could be due to a rounding error, can you display greater precision for the AC schedules? Also, for column S'x0,95, my calculator shows that 84.42 x 8 = 675.36, so the AC schedule seems correct, and the XLS is wrong.

HTH

David

Re: Getting a correct SUM of zones within interactive schedu

Anonymous — Thu, 30 Apr 2009 13:04:55 GMT

David

David wrote:
This could be due to a rounding error, can you display greater precision for the AC schedules?

yes understood, and found it.

Warning there is a trap :

IS are not linked to the "Options/Project Preferences/Dimensions" settings,
IS are linked to the "Options/Project Preferences/Calculations Units" settings

The result will show correctly only if I turn of decimals (as shown on the images attached)
When ever a decimal is displayed one of the columns will generate a calculation error.

David wrote:
Also, for column S'x0,95, my calculator shows that 84.42 x 8 = 675.36, so the AC schedule seems correct, and the XLS is wrong.

Waow you are right, I should maybe send another post to MS

Thanx a lot David