Project data & BIM
About BIM-based management of attributes, schedules, templates, favorites, hotlinks, projects in general, quality assurance, etc.
SOLVED!

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

Mats Knutsson
Advocate

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

1 ACCEPTED SOLUTION

Accepted Solutions
Solution
Mats Knutsson
Advocate

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

View solution in original post

4 REPLIES 4
Barry Kelly
Moderator

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.

 

One of the forum moderators.
Versions 6.5 to 27
i7-10700 @ 2.9Ghz, 32GB ram, GeForce RTX 2060 (6GB), Windows 10
Lenovo Thinkpad - i7-1270P 2.20 GHz, 32GB RAM, Nvidia T550, Windows 11
Solution
Mats Knutsson
Advocate

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

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

Think Like a Spec Writer
AC4.55 through 27 / USA AC27-6000 USA
Rhino 8 Mac
MacOS 14.6.1

This is how I do my take offs too!