Doug L Posted October 21, 2008 Share Posted October 21, 2008 Can VW08 count irrigation head symbols to give totals per each type of nozzle in the standard Irrigation Head Schedule Worksheet? In plant list worksheets, the formula is ='Plant Record'.Quantity but =('Irrigation Head'.Quantity) only results in 0. (I don't understand why all the irrigation formulas all have brackets but it doesn't seem to affect the results). Thanks. Quote Link to comment
dspearman Posted October 22, 2008 Share Posted October 22, 2008 Try =Count The plant worksheet counts the contents of a field in the plant record which calculates the number of plants in the placed plant object If you simply want to count the number of symbols matching a criteria you can simply use '=Count' Quote Link to comment
Thom Posted October 22, 2008 Share Posted October 22, 2008 There is a spreadsheet for irrigation equip. I have not had good luck with its accuracy. Quote Link to comment
Doug L Posted October 22, 2008 Author Share Posted October 22, 2008 Try =Count The plant worksheet counts the contents of a field in the plant record which calculates the number of plants in the placed plant object If you simply want to count the number of symbols matching a criteria you can simply use '=Count' dspearman, thanks. =Count did count, except that when I brought in the irrigation head schedule worksheet, the chart shows one row for each and every instance of each head nozzle, with a count of 1, instead of the quantity that each different head nozzle was used in my drawing. Perhaps the irrigation head schedule worksheet is intended to only be an itemized list, instead of quantity totals similar to plant lists? Quantities would be helpful for cost estimates and contractor's bidding. Quote Link to comment
Doug L Posted October 22, 2008 Author Share Posted October 22, 2008 There is a spreadsheet for irrigation equip. I have not had good luck with its accuracy. Thom, are you referring to the Irrigation Head Schedule and Irrigation Line Schedule worksheets, or something else? Thanks. Quote Link to comment
Pat Stanford Posted October 22, 2008 Share Posted October 22, 2008 In your worksheet, you need to select a row in the database and then drag the SUM icon to the column header that you want to summerize on. In your case, this would be the head type. You will then get one row for each head type and the count will be the number of heads for that type. Pat Quote Link to comment
Doug L Posted October 23, 2008 Author Share Posted October 23, 2008 Thanks Pat. It worked! Just for clarification for others, I dragged the SUM icon to the column header of the Nozzle column. The next column, which has =Count in the header, automatically contains the quantities of each type of nozzle. Thanks everyone for your suggestions to solve this question! Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.