Forums >> Revit Building >> Technical Support >> Calculating cost of Nested Families in families in projects - Custom Kitchens

daleyy

active

Joined: Mon, Nov 1, 2004
49 Posts

I am trying to figure out a way get a total cost of a custom kitchen based on custom pieces of cabinet.  What I am thinking is creating different families that are pieces of base/upper cabinet.  Each piece family has a cost to it of which some might be based on a per foot cost.  I then want those piece families to be placed into a cabinet family.  As I place (or turn on or off(yes/no) these pieces into the cabinet family the cabinet family then has a cost calculated.  Then as I place the individual cabinets into a project, I can get a total cost of the entire kitchen cabinets.

Is this even possible?

Thanks

Dale

Revit 2014

-----------------------------------

DaleW

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

If you use nested families and they are set to shared, then the individual nested items can be scheduled.

This user is offline

daleyy

active

Joined: Mon, Nov 1, 2004
49 Posts

Thanks.  Yes, each family is set to shared.  I can get a schedule based on what I have placed in the Cabinet model.  I am now having a problem getting a total cost for just the cabinet with the pieces in place. I cannot see the cost parameter for the pieces to be able to do a formula to calculate the cost of the cabinet.  Or am I only able to get a cost of each piece once the kitchen is completely created in the project file, and get a total cost based on every piece beign used?  Not what I wanted.  I want a price on each cabinet and then a total on the kitchen itself.

thanks again

Dale

-----------------------------------

DaleW

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

Limit your schedule to one of the cabinets you have placed.

This user is offline

daleyy

active

Joined: Mon, Nov 1, 2004
49 Posts

Sorry, I may have mis-explained something. 

I want to get a price point per cabinet based on the price of the individual pieces in the cabinet.  I cannot get a schedule inside the cabindet family, but I need to calculate each piece of the cabinet to get a total cabinet price.  Then take that cabinet family and place it into the project, and calculate the kitchen cabinets cost in a schedule.

Upon testing some of this, I am having a problem getting the cost from the pieces to the cabinet and getting a total in the cabinet.

-----------------------------------

DaleW

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

1. You can't schedule in a family, only in a project.
2. If nested families are shared, they can be scheduled in a project.
3. To calculate price per unit, you will need to isolate the unit.  You can do that by sorting the schedule by family type.

Your problem will be that the same nested families might be in multiple cabinet types.  You will have to find a way to associate those with individual cabinets.  Be creative and find a way to do that.

This user is offline

daleyy

active

Joined: Mon, Nov 1, 2004
49 Posts

Ok trying to be creative.  How can I create a Cost Parameter in one of the pieces family that gets loaded into the Cabinet Family and I can use the value of that parameter in a formula for a shared parameter that gets used in a schedule in the project?  I have it set up but I cannot access the Cost parameter of the piece family.

To explain maybe better, Piece 1 has a UNIT COST parameter.  Cabinet 1 has this Piece 1 in an array with parameter for PIECE 1 COUNT.  Cabinet 1 also has a shared parameter PIECE 1 COST with a formula to get a total cost for all the Piece 1 in use =UNIT COST*PIECE 1 COUNT. In project file I can schedule PIECE 1 COST.  I cannot get the Cabinet 1 to see the UNIT COST parameter to use in formula.

The only other thing I can think of is not use the Piece 1 family and just build the piece in the Cabinet 1 family and put a cost to just that piece, but that kills my flexibility that I want in future.

thanks

-----------------------------------

DaleW

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

Below is a schedule created from the attached family.  Study the family.  Place it in a model and see if you can create a schedule like mine.  When you complete that, you will understand.

Attached Images

Attached Files 125993_Item_Host.rfa

This user is offline

daleyy

active

Joined: Mon, Nov 1, 2004
49 Posts

Yep...I got that to work.  Just was not the direction I was hoping to go in.  I wanted one more level of flexibility.

I guess I will go with this for now and see where it leads me.

Thanks for the help.

I appreciate it.

-----------------------------------

DaleW

This user is offline

Locking nested families?

13

Calculating two Formulas on the same row in a Schedule

4

Hiding nested families in a project

4

turning on/off nested families in host family in different views in project.

2

Revit - Nested Families Reload

1