Archicad Excel Estimate Templates in ANY Language!

[@conmes3077]

Stunning 👍🏻 thanks John 🥰

[@CONTRABIM]

Thanks Conmes!

[@conmes3077]

@@CONTRABIM thank you John 👍🏻

[@guyshavit3464]

Hi John. That is great. Awesome 😊

[@lucasrolim5106]

Nice! From a native Portuguese speaker it looks very accurate. I just found funny that it translated "gross area" to something similar to "disgusting area" in Portuguese

[@CONTRABIM]

Lucas Rolim Haha yes that is totally expected, few little changes need to be made here and there, and I’m looking to capture all those to get a baseline version:) thanks! What would be the proper in Portuguese for Gross Area?

[@lucasrolim5106]

@@CONTRABIM I think "Área Bruta" would be the best translation in this case

[@CONTRABIM]

​@@lucasrolim5106 Yes, I see! It's funny "Gross" translates to "Bruta", but "Gross + Area" goes to "área nojenta". Almost...

[@AlanEnriquez]

and stories to Histórias and has nothing to do with levels or niveles (andares)

[@guyshavit3464]

Next stage from my point of view, is to find the correct methodology to change the CSI code to a local one maybe manually in the ArchiCAD or by using the Excel VLOOKUP function . For instance, we are using a different code (material based) that also has 3 separate digits but with a different meaning in which the cost per unit is connected to it. Guess it is the same in some other countries. I guess that the idea is to make all these manipulations outside from ArchiCAD. many Thanks

[@CONTRABIM]

Thanks Guy for the comment! SYSTEMS is already setup for any International Classification you can throw at it. Works exactly the same way as CSI, and runs in parallel! Takes about 15 minutes to add any new Classification system...something that's already included in the product training, but definitely a video I'll do for KZbin! What classification system are you using in Israel? Is there an Archicad Classification XML for it? If you can provide an XML for import into Archicad, and an Excel listing of data fields I'd be happy to demonstrate with that as an example:) Or I can use any other one from the GRAPHISOFT BIM content page! Thanks for the question and perspective!

[@nejcvrabl701]

Yup.... Very interesting!!

[@CONTRABIM]

Thanks Nejc!

[@parix85]

Hey random question please help. In Archicad how do i Change the currency from the default US$. Thanks

[@CONTRABIM]

Hi Patrick 25! So in Archicad, there isn't really any default US$ symbol. Most currency based parameters don't carry the $ symbol unless you type it in manually. If your currency can be described in the property "number" format (0.00) then you should be OK. You can always concat function in whatever currency symbol you want, but then of course you're converting a number value to a string. Hope this helps!

[@parix85]

@@CONTRABIM on my wall schedule under classification. Cost per volume and total cost of volume is US$ that how it shows in my schedules. Tried to find a way to change under classification manager. No luck.

[@CONTRABIM]

@@parix85 It's not in the classification manager. It's in the property manager. If you go to the "Cost of Structure (Expression)" properties you'll see the Number parameters, and also the String parameters that have the extra (USD) or ($). Notice the expression based property: CONCAT ( STR ( ( {Property:COST OF STRUCTURE (Expression)/Cost Per Volume} / 1 m3 * {Property:General Parameters/Conditional Volume} ), 2 ), " $" ) This is the CONCAT function, that will combine your "Cost per Structure (Number)" with a $ or USD. Change the $ to whatever you want in this expression, and it should report that way in your schedules. You can also move the Currency Symbol to the front by reordering the CONCAT variables. Beware! I've noticed there have been some errors in these preloaded expressions n the past. Something to double check with a manual calculation before fully trusting it!

[@parix85]

@@CONTRABIM dude it worked. You are a Archicad Guru lol. Thank you so much...

[@CONTRABIM]

@@parix85 Haha awesome glad it did!

[@videopeich]

Hi John, I really think that your AC - Excel templates and workflows are awesome. But relying on some online translator is rubbish and not according to your high end product. The AEC terminology in all languages is too specific. There even are differences between same languages in different regions, for example, Spanish terms in construction between Spain and Latin American countries. So online translators are a NO GO. Cheers

[@CONTRABIM]

Hi Nico. Thanks for the comment. Yes I understand that online translators can only go so far, but it's at least a fast track to get the translation process moving. What's nice about the setup with the new Excel templates, is you only have to modify/adjust the translation in 1 location, on 1 sheet, and the entire workbook updates. So you are right that the translation isn't 100%, and of course there is specific terminology that needs to be adjusted, it's a starting point. I'm slowly collecting the "corrected" translations with proper terminology for different languages and classification systems, but one step at a time!

[@ulrikeklaschka6898]

For me is too much to complicated. Couldn't you break it down just for us not so deep specialized beginners?

[@CONTRABIM]

If you want to see how it works from the beginning. You might want to check out the 60 Minute Live stream from last week! We talk about the basic structure of this workflow, classifications, properties, reports, and assigning elements. kzbin.info/www/bejne/iJbQqYyqfsSAqZY

[@ulrikeklaschka6898]

@@CONTRABIM I tried to follow that stream, but there where too many components to follow. And it was tooo fast.

[@ulrikeklaschka6898]

Great. In german? Yea yea.

[@CONTRABIM]

Ulrike Klaschka yes! I’ve already tested it out and runs through no problems! What classification are you using there??

[@ulrikeklaschka6898]

@@CONTRABIM Do you need the list?