Schedule - Quantity of Uniform Elements Only

[Anonymous]

How can you create/ show the quantity of uniform elements in the interactive schedule instead of total elements?

See attached screen shot of an areas schedule, where I want to quantify the number of apartments (woningen).
I have the 'merge uniform items' turned on as required to only show each apartment type (woningen) and apartment number (woningen nr.) once.

However, using the quantity parameter or adding sum/ number sum to each field still calculates all instances of the elements and not the uniform elements as shown.

Many thanks.

[Anonymous]

Any solutions or suggestions?
It is quite important.

Many thanks

[ChrisB]

You're screen shot seems not to have attached.

It sounds like it may be something to do with the grouping (flag) setting. Any chance you can post a screen shot of the schedule including it's settings and I'll take a look?

[ChrisB]

Sorry...it's appeared now...must have been something to do with my Firefox browser settings (now using a different machine).

Any chance you can post a screen shot of the schedule settings...

[Anonymous]

Hi Chris,

I have updated the schedule a little bit to reflect how we want it, so it's a bit more complex now than how it was. Originally we had one field with the apartment numbers, which were highlighted by the first field, apartment type, which was highlighted as the headline. Hence it was the sub quantities and total quantity of apartments I wanted to automatically calculate.

Now we have the home story as the headline field and there are two other zone types other than the apartments on each floor, Storage and general space.

See attached screenshot of the new schedule with the scheme settings window open.

I would still like to know how we do the simple number quantity calculation for uniform items, and now how we might also think about producing a quantity here.

Many thanks

[Laszlo Nagy]

I am not sure this is possible to do because when it says "12" it is because there are 12 Zones (which are listed in 6 rows because Uniform Items are listed as one row - but there are still 12 zones).

One thing you may try is this: in the Fields panel, the flag is in the row of "Home Story" meaning subtotals will be calculated based on that column. Try to activate the Flag icon for the "Zone Number" field and see if that makes any difference.

[ChrisB]

Unfortunately, I tend to agree with Laszlo that it’s not possible to do this in a schedule directly. The schedule is performing it’s calculations on the zone element, so will report the totals relating to the number of zones it finds.

Moving the flag to the ‘Zone Number’ field won’t work. All this will do is give you a sub total of zones for each apartment i.e in your example the total of 12 shown will be broken down into subtotals which will be shown in a separate line under each apartment type

Possible work arounds I can think of…

1. Create one high level zone for each apartment & base this schedule on those high level zones only. All other ‘sub’ zones can be excluded through the criteria panel e.g. exclude all zones with ‘Zone Category’ (or some similar field)….
2. Leave the schedule setup pretty much as it is but remove the count function from the ‘Zone Number’ field. Then open the schedule & save as an Excel workbook when it’s ready for publishing. The schedule will look exactly the same in the excel workbook but you can add the additional total function to each cell to give the correct count of apartment types. This can then be re-inserted into a layout ready for publishing. Sounds worse than it is…I use this a lot for schedules I’ve produced that you use IFC custom fields that contain formula based on standard element data. The formula is automatically calculated when transferred to the Excel workbook e.g IFC field contains ‘=Overhang right + width + overhang left’ to calculate the total size of the head/arch over a window

With regards the other zone types that you don’t want to quantify…

1. These zones can be excluded altogether using the criteria section or;
2. If you want to include their names but not the quantities, this may be possible using IFC properties/fields but I’ve ran into a problem where schedules are unable to sum up quantities contained with IFC properties/fields for uniform items, that I’ve yet to resolve
3. Easily altered if you take the Excel Workbook option mention above

I’m sure it’s not what you wanted to hear but hope it helps…