Search the Community
Showing results for tags 'count'.
I have about ten classes each of which includes a number of hexagons (ranging from one to about forty, and created using the Regular Polygon tool). VW does not retain Regular Polygon as a criteria object though so how do I count them in Worksheet? If it matters all hexagons are the same size 346m² A script would only be useful if the answer is written back to the worksheet, or another worksheet. I only use VW's workshet function so only looking for worksheet solutions, I've not had fun or success using the DB thing - and basically don't trust it not to profoundly f&^% up my drawings.
I have not yet tried this but have not found anything in help files or other questions and no sense reinventing the wheel if someone's managed it. I want to know if Marionette can parse or read raster file data, e.g. count pixels of a given colour/color and produce summed counts of those colours. E.g. from this simple 4 colour + white image: Why I'm doing this is I'm producing planview landscape planting concepts in a digital painting program, thresholding the artwork to reduce the colour space to represent plant zones (eg 4 colours > 4 zone types in encl.), and then counting pixels via imagemagick to work out planting areas. But then have recently wondered if Marionette can count pixels.
HI all So I have a sparse worksheet (most cells are empty), and all I want to do is count the filled cells in the columns i.e. I just want a cell at each column base that says 7, 9, 3, 15 etc. As in the mockup image encl. I'm on Windows 2012 if it matters. Active cell contents are calculations from other cells, and sometimes manually entered numbers, and in case it matters the function in a cell looks like this. But Ideally I'd also like to be able to count plain text-filled cells later on. =(INT((K$7*$D$5*$A$30)/5)*5)+5