Hoping you could maker more of these Expressions videos. Just started driving into these for the office, & have been thinking of 'converting' an Excel spreadsheet into AC. It's used for calculating the minimum Natural Ventilation requirements for our warehouse projects.

@CONTRABIM

2 жыл бұрын

I definitely will do more Expressions! For the ventilation requirements, sounds like using zones would be the ticket. Nice thing with these properties is you can always take to Excel to format and finalize the output. AC does OK with sums, but not as easy as Excel.

really helpful John 👍🏻

@CONTRABIM

3 жыл бұрын

Thanks! It's a simple workflow but can be used in many different ways

@conmes3077

3 жыл бұрын

@@CONTRABIM absolutly 😉

Hi John, thanks a lot for investing your time to explain the process. Many thanks. I just have a question: how i can subtract the sink from the area. The expression is - Leght x width x 1m2, and that gives the area without subtract the sink(hole). I was thought about the "surface area" but this option is only for walls... Once again thanks for the youtube videos, and for the excellent work you are doing. Soon I will make parte of the "CONTRABIM" family, because i will buy the C5D Estimating Pack ;-), and about that, i have a quick question: I know that the cost link is between AC and Excel, but is possible also between AC an Numbers(Mac)?

@CONTRABIM

2 жыл бұрын

Hi Xavi, thanks for the comment and the question. To subtract the sink area, you'd have to know the length x width of sink, which would be a little difficult to put into an expression to subtract. The reason being, is object properties (length x width of sink) are not usable in the expression. We could use the overall object size for the cabinet, but not the internal object settings of the sink. You could always create two manual length properties, and have them multiply into a sum, and then subtract the sink area. But my question is why subtract the area? If you're having to buy a countertop or slab, typically you'd include the sink area, as it would be part of the overall material required for purchase.... Hang tight on the C5D Estimating Pack until after the August 1st Launch Event:) Big changes coming to that front...

@franciscoxpnobrega

2 жыл бұрын

John, thanks for the quick answer. The reason to subtract the area, is a requirement from the Client, are this clients who wants to know everything (i suppose). But I will try to resolve with slab, then classify as Furniture, and in the property Manager try to get the information with "Surface area of the top slab". But you are completely right, we buy the countertop with the negative for the sink, and stove. Thanks for your time to reply my question. Nice to know that the C5D E.Pack have an update 🙂.

One of the best tutorial John. If we want to take it down, a little further, is there a way to schedule each panel of this cabinet? (It would be very useful to send it to a furniture manufacturer). Of course we can use walls and slabs to build the cabinet, but is there an easiest way?

@CONTRABIM

3 жыл бұрын

That is an awesome question! Thanks for asking it. To schedule each component with associated dimensions for fabrication, it would take some work to get there. Exploding into a morph would get you part count, but unfortunately morphs don't measure length, width, height or anything besides area on the floor plan. You could easily explode a morph, and create a 3d document of the different parts and pieces, which would be effective. That, listed in combination with the list of morphs, and their inputted sizes would do the trick, but all this is very manual... and without the freedom and flexibility of just using the slabs and walls, which do have great measurement options! Let me think on it a bit more and sounds like a good topics for another video! Thanks