Schedule Cost Calculation.

[OfAnna]

I am trying to create a living cost calculator for doors/windows/and surfaces. 

I would love to build a schedule allowing me to price out all the items in the details sheet that could appear on their respective schedules and would change while I build or edit the model/floor plan. 

One example, with doors, I would have two types of doors that cost different. Door A, a single swing door, would be 200 in total cost, while door B, four pocket doors, come to 300 each, however, the client may want to add another swing door in place of one of the 4 pocket doors. I would love to be able to go and switch out the door without having to go into Excel and update the schedule there. 

In the image attached to this post, on the door schedule, you will see a cost at the bottom that remains at 0. Basically, I am trying to figure out how to times the quantity to the purchase price. 

Likewise, when dealing with surface areas, I want to try to have the Area Column times the cost per unit/Volume to get a purchase price. 

Essentially, I am asking if there is a way to have the Feild Lines interact with each other. 

Operating system used: Windows 27.2.0

  

[Barry Kelly]

Ricardo explained it very well (thanks Ricardo).

These examples may also help.

https://help.graphisoft.com/AC/27/INT/index.htm?rhcsh=1&rhnewwnd=0&rhmapid=#t=_AC27_Help%2F045_Prope...

Barry.