Search the Community
Showing results for tags 'worksheet function'.
I have a worksheet for calculating roof height. Roof height is based on the weighted average of the individual roof areas relative to a geodetic height. In this worksheet, I have a database cell that picks up polygons that are linked to a record. The next column lists the areas of those polygons. I now have a nice list of the polygons, their names and their areas. In the next column I want to perform a division function where the individual areas are divided by the total area. Since the total area shows up in the column header. I can link a spreadsheet cell to this column header and the total area shows up in the spreadsheet cell. ie. same value HOWEVER, When I then try to divide the spreadsheet cell area by the database header value (to get the weighted average) the spreadsheet cell changes it value to zero and the operation fails. Is there a way to get information from a database cell and perform a math function on it without ruining the value of that cell?
Been looking for some definitive info on vectorworks.net and a bit of googling too. Thought I'd just ask instead. Are custom worksheet functions that you call using the RUNSCRIPT() worksheet function excluded from Fundamentals??? Conrad