How to get same Schedule total values in excel

[ali.mkhm683277]

Hello guys,

I am quite new to Revit 2014 and would appreciate your help.

Under the project's schedules, I have enabled "Calculate Totals" for some of the fields and the total is shown up.

Now, when I export this schedule to Excel, and do a sum calculation of the column content, the sum I get in excel is slightly different than the one showing up by Revit Schedule (usually less than one unit). Is there some sort of default rounding of the values Revit applies, so that the final sum is different? Or what do you think might be the case?

Notes:
- In my current testing, this is happening to many including: "Airflow Delta" and "Calculated Cooling Load"
- For the 2 fields mentioned above (and others having this problem), I have checked and confirmed there is no Conditional Formatting applied.
- When I click on Schedule's formatting, and click on Field Format to see rounding options and etc. the "Use project setting" is checked, and I am not sure how to find the project setting?


Thank you very much.

[dkoch]

Project rounding settings: On the Manage ribbon tab, on the Settings panel, select the Project Units tool. In the Project Units dialog choose the button in the format column next to the unit type whose rounding you want to check/edit. In the Format dialog, use the Rounding dropdown to set the desired rounding.

As to the issue of the total calculated being slightly different than the sum of the displayed values, that is a rounding thing. The displayed values are rounded; the total is calculated based on the raw numbers, and then rounded. Round ups and round downs do not always offset each other. And if you have a schedule with a lot of values that all round the same way, especially if they are very close to the dividing point for rounding, you can get a total that is several units off. For example, a room schedule set to round to the nearest square foot, with eight rooms with an area of 87.45 square feet each will show in the schedule as 87 square feet. 87 x 8 = 696, but the total will show as 700 (87.45 x 8 = 699.6 --> 700).

The only thing you can do is pick a rounding amount that is sufficiently small that any discrepancy can be accepted as "rounding" without raising alarm. In the example above, changing the rounding to one decimal place changes the displayed values to 87.5 square feet, and the total to 699.6. 87.5 x 8 = 700, so now the difference is only 0.4 square feet, rather than 4 square feet.