Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

schedule to spreadsheet

3 REPLIES 3
Reply
Message 1 of 4
Anonymous
337 Views, 3 Replies

schedule to spreadsheet

Hello,

We need to bring an area schedule into a spreadsheet so the client can
play with numbers however, the total are exported as a number and not a
formula.

This means we need to sum the values on the spreadsheet to calculate the
total areas again.

The other thing is that we cannont sum values with decimal figures. Only
whole numbers, otherwise the spreadsheet won't calculate. We've checked
the regional settings, but with no success.

Any ideas? We use open office spreadsheet.

Thanks.
3 REPLIES 3
Message 2 of 4
Anonymous
in reply to: Anonymous

You can set the number of places to show in your schedule so in your case - 0

Just change the settings for that field not to use the project settings. Edited by: waltermullett9350 on Mar 16, 2010 2:26 PM
Message 3 of 4
Anonymous
in reply to: Anonymous

Yes, I know. the thing is that the spreadsheet won't calculate number
with decimal places exported from rvt. Only whole numbers.



Em 16-03-2010 14:27, waltermullett9350 escreveu:
> You can set the number of places to show in your schedule so in your case - 0
>
> Just change the settings for that field not to use the project settings.
>
> Edited by: waltermullett9350 on Mar 16, 2010 2:26 PM
Message 4 of 4
Anonymous
in reply to: Anonymous

It works - I just did it. And BTW, decimal places also work.

Are you sure you are exporting numbers? Don't let Revit put in something like SF because the field then becomes text when exported and then it will not add in excel.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Forma Design Contest


Autodesk Design & Make Report