topic Re: Creating Furniture Schedule in Collaboration with other software

Creating Furniture Schedule

Anonymous — Tue, 28 Jul 2009 20:09:00 GMT

I have created a furniture schedule (contains info on furniture type, quantity, cost per piece and total cost per furniture type). The only problem I'm having is that the total cost per furniture type is totaled below the cost per piece. I would like to create a separate column for the total per type. If anyone knows how to do that, I would greatly appreciate the help.

Re: Creating Furniture Schedule

Erika Epstein — Tue, 28 Jul 2009 21:54:37 GMT

This has been discussed. If you go to the help menu when AC is open
Help>Archicad Help>Sort Schedule Fields you will learn how to summarize as you describe.

Please add you version of AC and your platform to your profile.

"Click the second button to add a schedule cell which displays the sum of the items in the selected field. Here, we will have the schedule add a sum to the schedule’s Volume column.

The second button contains an icon for a second option: to list a quantity for this field. Here, we will have the schedule add a Quantity to the schedule’s Wall Type column.
The result: Wall Type shows a Quantity at the bottom of the column (a total of 8 walls), and the Volume column shows a total sum of all the volumes at the bottom (65.19 m3)...."

Re: Creating Furniture Schedule

Anonymous — Tue, 28 Jul 2009 23:27:30 GMT

"Erika Epstein" wrote:
"Click the second button to add a schedule cell which displays the sum of the items in the selected field. Here, we will have the schedule add a sum to the schedule’s Volume column.

The second button contains an icon for a second option: to list a quantity for this field. Here, we will have the schedule add a Quantity to the schedule’s Wall Type column.
The result: Wall Type shows a Quantity at the bottom of the column (a total of 8 walls), and the Volume column shows a total sum of all the volumes at the bottom (65.19 m3)...."

I have read about the second button and tried it. As you have said, and the help topic describes, the sum goes into a cell below. I would like it to go to the right so you can read across. The idea is to be able to bring this into excel and clean up the schedule without having to jump through that addition hoop. No one I have spoken to on the phone seems to know how to do this either. AC Schedules seem inclined to build schedules vertically and not horizontally as they would be read in a real world setting. adding down gets confusing.

Re: Creating Furniture Schedule

Erika Epstein — Wed, 29 Jul 2009 00:14:50 GMT

Siobhan,
I see what you are after now. No, I don't know how to achieve this in archicad; someone else here might.
As you are exporting the schedule to excel which can have a template to perform the math in the next column horizontally, you could omit this finally summary column in the archicad schedule.

If you want to see this info when in archicad you could have two versions of the schedule in the file.