Window Schedule columns

[Anonymous]

hey,

i've created windows schedule and what i need to get is a table like the one i made in excel as an example(attached below)

how can i achieve that situation that the schedule will count windows by the level of the building and then sum them all up?

thanks

[Corsten.Au]

Hello

In Revit window schedule, you can achieve that in Rows ( if not columns )

1. Add Levels in the schedule, Add Count...

2. Sort by Levels

3. and follow these settings for a. Calculation, Sorting, Grand Total.

Attached screenshot and Screencast ( Video ) to explain how schedules can be modified

using Sorting, calculations, filter etc..

Windows - Levels

Window Schedule settingsWindow Schedule settings for Calculate Totals

https://autode.sk/2Uim6ih

[Anonymous]

well, i know how to acheive what you did, but i want my specific situation (because i have many types of windows and i want to make floor levels columns and not rows)

is it possible?

[Avaris. · Accepted solution]

No, schedules are a bit limited in Revit, but you can export your schedule as csv and translate row/column in Excel.

[Anonymous]

too bad 😞

thank you!

[Corsten.Au]

Revit doesn't allow Filtering using Columns...

But if you are forced to use that Format, then It would be complete Manual..

1. Add the Parameters ( Text - Ground, Level 1, Level 2, Level 3 )

2. and Fill in the Numbers Manually.

Example..

Custom Window Scheduel - Manual ( the count won't come automatic for Levels, but default Count column works )