topic Re: Include Calculations in Collaborate forum
https://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236845#M30434
<BLOCKQUOTE>KeesW wrote:<BR />
Couldn't you use a spreadsheet as a database to both fill in and calculate? There are other Archicad applications that combine Archicad data with Excel.
</BLOCKQUOTE>
Kees<BR />
<BR />
Yes, it would be possible to use a stand alone spreadsheet, however I would need a separate spreadsheet for each project & every time I wanted to update, I would then need to open the spreadsheet & save (as <*.pdf>?) for updating in AC. It's easier to update the text in AC (with little bit of manual calculation), I think, & it's updated automatically by AC.<BR />
<BR />
Thanks for the suggestion, though.<BR />
<BR />
RegardsTue, 14 Apr 2020 00:45:54 GMTgreybeard2020-04-14T00:45:54ZInclude Calculations
https://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236839#M30428
<DIV class="actalk-migrated-content"><R>So, first: <BR />
Thank you all for the help you have unwittingly given me over the years (since I taught myself how to use AC 6!). I have never needed to ask an open question before because I am never the only one with a problem.<BR />
<BR />
Now to the question: <BR />
I have an ongoing project involving 21 (which may increase) different versions of a system for houses on 3 different foundations & with 6 different cladding options. Here in NZ, we need to demonstrate compliance with an energy efficiency code (NZBC H1). I have developed a block of text that I can, after manually plugging parameters from Element Information into Project Info, and then using Autotext, have them appear in the text box. I then use a calculator to perform the arithmetic functions (x, +, /, <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">ðŸ˜ƒ</span> & manually amend the text block. <BR />
Here's a screen shot of the text block, the Autotext is in grey (as usual):<BR />
<BR />
<BR />
<BR />
<BR />
<BR />
This works OK for a one-off design, but is there a way to perform these arithmetic functions automatically?<BR />
<BR />
21 x 3 x 6 = daunting prospect!<BR />
<BR />
I became an architect because all the books had pictures; I don't want to spend days with a calculator in my hand (like an engineer!).</R></DIV>Mon, 13 Apr 2020 04:51:57 GMThttps://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236839#M30428greybeard2020-04-13T04:51:57ZRe: Include Calculations
https://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236840#M30429
FYI:<BR />
<BR />
The short answer is NO -- Archicad presently has no internal means to perform calculations across multiple elements.<BR />
<BR />
The long answer is: Using the C++ API, this is a easy problem.<BR />
<BR />
Also you may want to wait for version 24. Archicad has recently added Python as a alternate to the C++ API. Using Python, this would be a extremely simple application to program and display and would be available automatically with one click in all plans.<BR />
<BR />
Unfortunately the initial release of Python is extremely limited in the type of elements that can be addressed and roofs , skylights, windows, and doors are not among them. However, in the initial beta release of Python we were promised that it would be expanded starting with the next version of Archicad which would be 24. It may now have that capability. I am not a 24 beta tester, so I don't know if it has been upgraded as promised? If so, this is a simple application that could easily be done in a day.<BR />
<BR />
Maybe a Beta tester might add some insight? Other than that, only a C++ ADDON could do this.<BR />
<BR />
Now, if you want to do more work, you could use expressions and properties to calculate the heat release of various walls, windows, doors, roofs and zones (floors) and then sum those up using a schedule. Somewhat complicated but would also work. IMNOHO -- The setup would be more trouble than just manually adding up areas but once done?Mon, 13 Apr 2020 07:23:35 GMThttps://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236840#M30429poco20132020-04-13T07:23:35ZRe: Include Calculations
https://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236841#M30430
Couldn't you use a spreadsheet as a database to both fill in and calculate? There are other Archicad applications that combine Archicad data with Excel.Mon, 13 Apr 2020 12:06:09 GMThttps://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236841#M30430KeesW2020-04-13T12:06:09ZRe: Include Calculations
https://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236842#M30431
Do you know that Cadimage have a tool that does this. Does all the Math for you.<BR />
I would send you an image but don't know how?Mon, 13 Apr 2020 21:37:11 GMThttps://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236842#M30431rjwilden2020-04-13T21:37:11ZRe: Include Calculations
https://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236843#M30432
Richard<BR />
Thank you for your reply.<BR />
Even if you can't attach an image, could you perhaps give me the name of the tool?<BR />
If it is part of the select group, then I will be out of luck - I am not a Select customer/member.<BR />
RegardsTue, 14 Apr 2020 00:34:26 GMThttps://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236843#M30432greybeard2020-04-14T00:34:26ZRe: Include Calculations
https://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236844#M30433
<BLOCKQUOTE>poco2013 wrote:<BR />
FYI:<BR />
<BR />
The short answer is NO -- Archicad presently has no internal means to perform calculations across multiple elements.<BR />
<BR />
The long answer is: Using the C++ API, this is a easy problem.<BR />
<BR />
Also you may want to wait for version 24. Archicad has recently added Python as a alternate to the C++ API. Using Python, this would be a extremely simple application to program and display and would be available automatically with one click in all plans.<BR />
<BR />
Unfortunately the initial release of Python is extremely limited in the type of elements that can be addressed and roofs , skylights, windows, and doors are not among them. However, in the initial beta release of Python we were promised that it would be expanded starting with the next version of Archicad which would be 24. It may now have that capability. I am not a 24 beta tester, so I don't know if it has been upgraded as promised? If so, this is a simple application that could easily be done in a day.<BR />
<BR />
Maybe a Beta tester might add some insight? Other than that, only a C++ ADDON could do this.<BR />
<BR />
Now, if you want to do more work, you could use expressions and properties to calculate the heat release of various walls, windows, doors, roofs and zones (floors) and then sum those up using a schedule. Somewhat complicated but would also work. IMNOHO -- The setup would be more trouble than just manually adding up areas but once done?
</BLOCKQUOTE>
poco2013<BR />
Thank for the suggestion. I know nothing about C++ (whatever that may mean) but I will see if I can find the add-on & then figure what/how it does it's thing.<BR />
RegardsTue, 14 Apr 2020 00:39:27 GMThttps://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236844#M30433greybeard2020-04-14T00:39:27ZRe: Include Calculations
https://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236845#M30434
<BLOCKQUOTE>KeesW wrote:<BR />
Couldn't you use a spreadsheet as a database to both fill in and calculate? There are other Archicad applications that combine Archicad data with Excel.
</BLOCKQUOTE>
Kees<BR />
<BR />
Yes, it would be possible to use a stand alone spreadsheet, however I would need a separate spreadsheet for each project & every time I wanted to update, I would then need to open the spreadsheet & save (as <*.pdf>?) for updating in AC. It's easier to update the text in AC (with little bit of manual calculation), I think, & it's updated automatically by AC.<BR />
<BR />
Thanks for the suggestion, though.<BR />
<BR />
RegardsTue, 14 Apr 2020 00:45:54 GMThttps://community.graphisoft.com/t5/Collaborate-forum/Include-Calculations/m-p/236845#M30434greybeard2020-04-14T00:45:54Z