Can I program a single cell?

[Ramon PG]

Doing a sidewalk reconstruction project and I'd like to program a cell C-8 to read colored polígons in the drawing (executed work) and subtract them from the total polygon area in in the drawing (cell A-8) so that I can tell at a glance how much work is pending. Now, I have to do a magic wand selection by color to get a number and manually insert it into cel C-8.

 

Can it be done?

 

Thanks for any tips.

 

[Pat Stanford]

The Area function in worksheet can be used in a Spreadsheet cell using criteria. So you should be able to do something like:

 

=AREA(((T=RECT) & (FB=1236)))

 

You will probably want to change the Type from Rect to Poly.  FB is Fill Background Color which is the color that is actually displayed in a filled poly.

 

HTH

[Ramon PG]

46 minutes ago, Pat Stanford said:

The Area function in worksheet can be used in a Spreadsheet cell using criteria. So you should be able to do something like:

 

=AREA(((T=RECT) & (FB=1236)))

 

You will probably want to change the Type from Rect to Poly.  FB is Fill Background Color which is the color that is actually displayed in a filled poly.

 

HTH

 

 

Thanks, but I am a bit lost. I cannot find the function in the Vectorworks 2024 Help to understand how to use it.

[Pat Stanford]

Post a file with a few of your colored polys and your worksheet and I will try to help.

[Ramon PG]

5 minutes ago, Pat Stanford said:

Post a file with a few of your colored polys and your worksheet and I will try to help.

 

Sent you a personal message. thanks.