Is it possible to import excel file into archicad?
because i need to do some calculation inside archicad, eg the costing for carpentry work, or archicad itself has something like excel can do calculation?
Thanks.
Hi Jeff,
Sort of. Even with the old Windows OLE thing, what you saved from Excel is what showed up in PlotMaker. If you didn't save the changes, they didn't show up. So, saving a PDF isn't that much more. I never did write any script to do it automatically though as hinted at in the old post below.
Note, that there are a few things that can make the hassle of having to use Excel (summarized well in your other post) not quite so bad for repeatedly updated schedules:
You can set up a Publisher set that publishes your raw data to one or more CSV files.
You can Import the CSV file into a worksheet in your Excel workbook using the data import feature of Excel in a way that you can quickly update that sheet after each Publish. Your actual schedule would be in a separate worksheet in the workbook and would have formulas that grab the data from the imported-from-csv sheet, so that you can maintain your formatting as desired. You'd have to delete rows, or insert rows and copy-down formulas as the length of the table changed.
(If you import into your actual schedule, if there were new rows published, you would over-write your summary row(s).)
When you import a csv file into a sheet, set it up to save the query def in the worksheet - this lets you refresh the data subsequently (see next post)...
Sort of. Even with the old Windows OLE thing, what you saved from Excel is what showed up in PlotMaker. If you didn't save the changes, they didn't show up. So, saving a PDF isn't that much more. I never did write any script to do it automatically though as hinted at in the old post below.
Note, that there are a few things that can make the hassle of having to use Excel (summarized well in your other post) not quite so bad for repeatedly updated schedules:
You can set up a Publisher set that publishes your raw data to one or more CSV files.
You can Import the CSV file into a worksheet in your Excel workbook using the data import feature of Excel in a way that you can quickly update that sheet after each Publish. Your actual schedule would be in a separate worksheet in the workbook and would have formulas that grab the data from the imported-from-csv sheet, so that you can maintain your formatting as desired. You'd have to delete rows, or insert rows and copy-down formulas as the length of the table changed.
(If you import into your actual schedule, if there were new rows published, you would over-write your summary row(s).)
When you import a csv file into a sheet, set it up to save the query def in the worksheet - this lets you refresh the data subsequently (see next post)...
On the worksheet that is now linked to the csv (text) file published from ArchiCAD, you'll see the attached External Data toolbar.
Just click the red exclamation mark button to refresh the worksheet with the current contents of the CSV file. Your actual schedule on the other worksheet will then of course update, as it references the cells/values on this sheet. Save that sheet as PDF and refresh the placed PDF in AC.
So, workflow would be: click Publish button in AC, click refresh data button in Excel, save main Excel sheet as PDF, refresh placed PDF in AC.
Yeah, FAR from ideal! The ability to perform simple calcs within AC schedules such as you illustrate would sure be wonderful. A 3rd party tool that lets you do spreadsheets (Cigraph has one) is not enough - we need the full query power of the AC element schedules... combined with user formulas.
Cheers,
Karl
Just click the red exclamation mark button to refresh the worksheet with the current contents of the CSV file. Your actual schedule on the other worksheet will then of course update, as it references the cells/values on this sheet. Save that sheet as PDF and refresh the placed PDF in AC.
So, workflow would be: click Publish button in AC, click refresh data button in Excel, save main Excel sheet as PDF, refresh placed PDF in AC.
Yeah, FAR from ideal! The ability to perform simple calcs within AC schedules such as you illustrate would sure be wonderful. A 3rd party tool that lets you do spreadsheets (Cigraph has one) is not enough - we need the full query power of the AC element schedules... combined with user formulas.
Cheers,
Karl
Hello Mr. Ottenstein!
Thanks for the thoughtful reply! My computer skills, understanding of unfamiliar procedures, ability to absorb, navigate, apply and execute methods have surely been tested with this one..........[As an example I had to look up CSV files
]
I'll give this a go but have to admit at first glance it seems equally as complicated as my current "work flow". Of course, I thought the same thing about riding a bicycle as first.......
I certainly appreciate your taking the time to illustrate a work around in line with my wishes/needs.
Is it possible as moderator a poll could be conducted, [they get more attention than just posts right?], asking for a community response to calculation ability, even modest, in schedules......? Just a thought.
Thanks again Karl!
Thanks for the thoughtful reply! My computer skills, understanding of unfamiliar procedures, ability to absorb, navigate, apply and execute methods have surely been tested with this one..........[As an example I had to look up CSV files
]I'll give this a go but have to admit at first glance it seems equally as complicated as my current "work flow". Of course, I thought the same thing about riding a bicycle as first.......
I certainly appreciate your taking the time to illustrate a work around in line with my wishes/needs. Is it possible as moderator a poll could be conducted, [they get more attention than just posts right?], asking for a community response to calculation ability, even modest, in schedules......? Just a thought.
Thanks again Karl!
Still looking?
