topic Re: Populating an excel sheet with formulas with values from an schedule (xls)? in Project data & BIM

Populating an excel sheet with formulas with values from an schedule (xls)?

Mats Knutsson — Wed, 24 Apr 2024 07:56:31 GMT

Hi,

I remember seeing a youtube video where the user exported values to xls (valuefile) from an Archicad schedule. Another excel file was filled with formulas (formula-file) and the values were populated from the valuefile. I'd like to do this but have forgotten who did the video. If anyone knows please DM me.

Br,

Mats

Re: Populating an excel sheet with formulas with values from an schedule (xls)?

Barry Kelly — Wed, 24 Apr 2024 08:04:06 GMT

I did see this demonstrated in a Central Innovation video about scheduling.

I checked back on their web site later to see if they had uploaded it, but I never found it.

Barry.

Re: Populating an excel sheet with formulas with values from an schedule (xls)?

Mats Knutsson — Wed, 24 Apr 2024 11:18:54 GMT

I think it was this one from John at Contrabim: https://www.youtube.com/watch?v=NEjLDm3_t9I

Re: Populating an excel sheet with formulas with values from an schedule (xls)?

Aaron Bourgoin — Wed, 24 Apr 2024 13:23:26 GMT

it was. It's John's Excel Loader.

Re: Populating an excel sheet with formulas with values from an schedule (xls)?

SenecaDesignLLC — Wed, 24 Apr 2024 13:56:42 GMT

This is how I do my take offs too!