What are the limitations of the internal spreadsheet? The internal spreadsheet can be linked to the Activity quantity, production field, and all the resources fields except the code and description. So lots of fields can be linked. One field that cannot be linked is the Biditem quantity. If my calculation calculates a quantity that will also have to update the Biditem quantity then I have to update manually (or import via excel) the new biditem quantitiy. In my workflow I wait until I am almost done with the estimate, then print out the activity quantity query screen and update my biditem quantities. When doing this I get the following question each time I revise the takeoff quantity:

Answer “No” since the activity and resource quantities are set by the internal spreadsheet calculations. The result is the total costs will stay the same but the biditem unit cost will be corrected to the new quantity.