agree, keeping excel file organized and refresheable in a very easy way is a magic and needs good skills
@CONTRABIM4 жыл бұрын
Thanks Dave! A lot more Excel tips to share...
@vladiklass1890 Жыл бұрын
How is your exerience with the ARCHICAD plugin? How easy to use would you say it is (form 1 to 10)? Are there easier tools to set up and use, too?
@ayan13yxq4 жыл бұрын
Hi John! Are these .pln file and the .xml file you imported here in this video included in the AMT+C5D course?
@CONTRABIM4 жыл бұрын
Hi! So the AMT MasterTemplate + C5D was based on the 2019 build of C5D. The AMT+C5D does include the reports and Excel estimate template, but it's just the older version which didn't contain the major upgrades to 2020 build. Totally rebuilt formulas and new summary sheets if you check out the product page you can see in the video www.contrabim.com/c5d
@tazevil4 жыл бұрын
@@CONTRABIM Hi John, what is the major upgrade from AMT+C5D ? is there a discount for people who already purchased the AMT+C5D pack and want this upgrade ?
@CONTRABIM4 жыл бұрын
@@tazevil Yes the major upgrades are in the Properties, Cleaner Interactive Schedules, and a re-built Excel Estimate template that is much more flexible and allows you to switch around columns from your ARCHICAD reports without issue on the other side in Excel. It also features a new flexible summary sheet that allows you to create your own summary structure. I definitely will do a discount for the upgrade. Please send me an email:)
@tazevil4 жыл бұрын
@@CONTRABIM thanks John for your reply and commercial gesture, At which address should I send you email and what do you need in it for applying the discount? (AMT +C5D mail account? Name? Address?)
@ahmedkammoun94094 жыл бұрын
Good work !! i just wonder to know, what is CSI category, CSI , uniform L3 and L4 etc ? is that a local specific coding system of your country or what exactly ? why there is 4 entries in the identification CB ?
@CONTRABIM4 жыл бұрын
Hi Ahmed. CSI Masterformat is the primary specification system we use here in the US, it works really well for organizing costs and trades of construction by materials. Uniformat is a systems based approach, which does a great job of organizing by location and purpose. I like have multiple levels of these as properties, so that you can report on various levels. Sometimes more summary level, and sometimes more detailed. It's also nice to have a header in ARCHICAD schedules based on one, while still needing the code reference in the line item below if that makes sense... Thanks!
@andrecalapez1424 жыл бұрын
hi, may you help me please? zone cost per m2? i can't do the expression. i create a propriety to insert the price, then another expression (area * propriety cost) and doenst work. best regards mate
@CONTRABIM4 жыл бұрын
Hi Andre. If you multiplying an area by a number/integer, to result in a number/integer, you'll have to divide the area by 1m2. Add that to your expression and it should work. it'll look something like this: (area parameter / 1 m2) * cost
@andrecalapez1424 жыл бұрын
@@CONTRABIM it works! (area parameter / 1 m2) * cost!! thanks!! ............... is possible to change the value units? this is 112,04(m2)*600,00 (€) = 67226,65 (€) this last number is complicated. normally we use 67.226,65.... this dot or space is very useful. and if we add more itens to this list... when we hit the 2milion... the number will be 2078449,87.. this is a very complicated number ahaha.... is the anyway to help reading this better?
@CONTRABIM4 жыл бұрын
Andre Calapez if you want to change the display of the number, you’ll have to convert it to a string and do some splits and concatenations to add the period and commas in the preferred location. I’d recommend starting by creating a new property, that references your current output. You can set your property type to integer to get ride of the last two digits, may help and simplify. Sorry I’d have to work through this one myself to give you the exact formula. I’ll try to get to it this week!