topic Schedule export to Excel and return to Archicad in Collaboration with other software

Schedule export to Excel and return to Archicad

Tom Krowka — Wed, 09 Jun 2021 20:03:05 GMT

Have exported a finish schedule that includes areas & perimeter to an Owner. .XLSX file. They intend to complete the schedule using Excel. Is there any way to import that Excel file back into AC and still keep the areas and perimeter dimensions linked to the imported spread sheet?
Thanks TK.

Re: Schedule export to Excel and return to Archicad

sinceV6 — Wed, 09 Jun 2021 20:47:42 GMT

Hi.-

Sure!
But depends on the data and how you are thinking to display or keep linked in AC
Read here:
https://helpcenter.graphisoft.com/user-guide/135510/

My best bet would be that you link both your data and theirs into a spreadsheet that you control and format how you want, and bring back into AC as PDF.

Best regards.

Re: Schedule export to Excel and return to Archicad

Tom Krowka — Wed, 09 Jun 2021 20:57:34 GMT

My problem is that room areas and perimeters might change so while the PDF method is easy....it's really not accurate in the long term. Have followed the export via classifications method, but have set up properties so that I can select any item as long as it's included in the checklist for that classification property. The Owner adds something in the exported file that's not one of the property values and I can't import it. Seems like no easy way to do this.

TK.

Re: Schedule export to Excel and return to Archicad

Eduardo Rolon — Wed, 09 Jun 2021 21:43:51 GMT

Tom wrote:
My problem is that room areas and perimeters might change so while the PDF method is easy....it's really not accurate in the long term. Have followed the export via classifications method, but have set up properties so that I can select any item as long as it's included in the checklist for that classification property. The Owner adds something in the exported file that's not one of the property values and I can't import it. Seems like no easy way to do this.

TK.

Trick is to create Properties for the owner to fill in then you'll get the info back.

Re: Schedule export to Excel and return to Archicad

Tom Krowka — Thu, 10 Jun 2021 12:43:24 GMT

Am planning to do just that. Also am going to include properties A,B, C, D, that they can designate. those will translate back into AC, then I can just add a text legend for those values on the layout. Can't think of any other way to accommodate unknowns.
TK.