Autocad Table

dvertz — Thu, 14 Nov 2024 15:17:30 GMT

I am working on a tree calculation table. What I need, I believe can't be done. But I thought I would check with the forum to see if anyone had answers. I am looking NOT to use an Excel spreadsheet but just the Autocad Table entity.

The table is attached.

It calculates the existing trees minus the removed trees for the remaining trees. Simple math that works fine.
The next part is the required trees. This is a variable where the value can be from 300 SF - 2000 SF.

It is easy to divide the variable by 200 to get the required large trees. However, when the variable = 750 SF it would be necessary to use a medium sized tree (750-150=600) and then divide the 600 by 200. But I wouldn't know how to do that test without the IF or COND statement. So when the calculations were done at this level, it should provide the number of Large, Medium and Small trees to plant.

Next is the Trees Provided. This again, I believe would need the if statement. If the remaining trees exceeds the required, then the trees provided would be what's remaining. But if the remaining trees is less than the required, then the trees provided would need to meet or exceed the required.

Re: Autocad Table

tony1978 — Fri, 15 Nov 2024 06:24:19 GMT

Very interesting. My company just created our first landscape app that calculates total # of trees and total caliper inches per zones such as fire lanes, bldg pads....etcs for tree mitigation. Our next app was something a little similar to what you are wanting to do. Message me and maybe we can create an app for you. Are you using blocks for your trees or cogo points

topic Re: Autocad Table in Civil 3D Forum

Autocad Table

Re: Autocad Table