Search the Community
Showing results for tags 'material take off'.
-
I’ve been taking my first tentative steps into the world of worksheets. I’ve made a worksheet that reports on material quantities in walls using the COMPAREABYNAME function. In the case of timber cladding/siding I then convert the sqm total into a linear metre value based on the type of cladding/siding being used. So in the case of 200mm featheredge board (bevel edge siding) I multiply the sqm in a separate cell by 5.71 which gives me the total linear metres for the cladding. Hurrah! What I was wondering was, is it possible to record this sqm-to-linear-metres factor in the wall style somewhere rather than inputting it into the spreadsheet? So that if I use a different wall style that has a different type of cladding (with a different sqm-to-linear-metres factor) I won't need to remember to alter the formula in the worksheet in order for the linear metres to be returned correctly because the formula will somehow take the value from the wall style? The worksheet returns values based on the component name 'wood siding' so as long as there's only one type of siding in the file it doesn't matter what type it is. My worksheet has only spreadsheet rows. I tried creating a record format that contained the 5.71 conversion factor in it + attaching it to the walls in the drawing then inserting a database in the worksheet + managed to report the total linear metres this way, but this doesn't really gain me anything. I want my '200mm featheredge cladding' wall style to have this factor baked into it. I saw some posts from people asking if it was possible to attach records to wall styles rather than to the individual walls but they didn't get any responses so I guess not... Any advice would be great. I have only the vaguest notion of how these things work so apologies if I'm asking something stupid. Just keen to keep learning now I'm on a roll!! Thanks