Autocad Table

[dvertz]

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.

[tony1978]

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