https://community.graphisoft.com/t5/Collaboration-with-other/Calculated-fields/m-p/294655#M38433 <DIV class="actalk-migrated-content"><T>I have been asked to add a 'contingency' quantity to a schedule, which is a percentage of the quantity in the model. So, for example, if there are 26 in the model, I need to add 4 as contingency, making a total of 30 to be ordered from the supplier.<BR /> <BR /> I'm not aware of Archicad being able to calculate fields - but does anyone have ideas on how to do this without having to export to Excel? Given I have a preview associated with each part, any update would require a re-export of the Excel file, adding of addition rows (formatting, formulas), changing of page layout to export as a PDF to bring back into Archicad. <BR /> <BR /> It would be much simpler if I could keep this in the .pln file as a schedule.</T></DIV> Sun, 10 Jun 2018 21:29:00 GMT Bruce 2018-06-10T21:29:00Z https://community.graphisoft.com/t5/Collaboration-with-other/Calculated-fields/m-p/294655#M38433 <DIV class="actalk-migrated-content"><T>I have been asked to add a 'contingency' quantity to a schedule, which is a percentage of the quantity in the model. So, for example, if there are 26 in the model, I need to add 4 as contingency, making a total of 30 to be ordered from the supplier.<BR /> <BR /> I'm not aware of Archicad being able to calculate fields - but does anyone have ideas on how to do this without having to export to Excel? Given I have a preview associated with each part, any update would require a re-export of the Excel file, adding of addition rows (formatting, formulas), changing of page layout to export as a PDF to bring back into Archicad. <BR /> <BR /> It would be much simpler if I could keep this in the .pln file as a schedule.</T></DIV> Sun, 10 Jun 2018 21:29:00 GMT https://community.graphisoft.com/t5/Collaboration-with-other/Calculated-fields/m-p/294655#M38433 Bruce 2018-06-10T21:29:00Z https://community.graphisoft.com/t5/Collaboration-with-other/Calculated-fields/m-p/294656#M38434 no way in AC21.<BR /> AC22 has some possibilities for that, otherwise export to Excel. Tue, 24 Jul 2018 08:11:37 GMT https://community.graphisoft.com/t5/Collaboration-with-other/Calculated-fields/m-p/294656#M38434 alemanda 2018-07-24T08:11:37Z