ruthkingsbury Posted November 24, 2008 Share Posted November 24, 2008 Hi I am new to worksheets and am presently trying to figure it all out. I need to make a worksheet to show plant data. I have managed to get all my data onto the worksheet. On the worksheet it seems to list every symbol of a particular species that I have put on the drawing. I just want a single row with a total quanity of each? Can someone help?? Quote Link to comment
Wyle C Posted November 24, 2008 Share Posted November 24, 2008 RuthKingsbury, Try the "spreadsheet reports" discussion. there is a lot of great information on that topic. I am not sure if you can do what you want to do. For instance, if I use 32 of a particular size anchor or j-bolt in a concrete wall I will get the totals in the "header row" and then 32 rows of that J-bolt, which is an enormous waste of space and paper if printing. Quote Link to comment
Pat Stanford Posted November 24, 2008 Share Posted November 24, 2008 Wyle, Check out the SUM icon/button at the top of your worksheet. Select a row in oyr database and then drag the icon/button to the column you want to SUMMERIZE on. You will end up with one row for each type of object defined in that column. Pat Quote Link to comment
Wyle C Posted November 25, 2008 Share Posted November 25, 2008 Pat, thanks, I tried that and when I "sum" in the column It changes the count from 32 to 1. I click the header row to activate the "sum" button, drag the sum button to the column and the count goes to 1. Terry Quote Link to comment
ccroft Posted November 25, 2008 Share Posted November 25, 2008 drag another sum widget to another column...like name maybe Quote Link to comment
Pat Stanford Posted November 25, 2008 Share Posted November 25, 2008 OK try this. Create a drawing with some plants (10 to 20 of 4 or five different types should be enough). Go to the Tools Menu, Reports, Create Report. Set it to be Object with a record, Plant. Do not summarize. You should get a worksheet showing one row for every plant in the drawing. Select a row in the database and drag the SUM icon down to Column A. You should now have a single row for each different type of plant in the drawing. Select the database header row and select cell C2 (you could insert a new column or use any other column, but for simplicity, use C2 for this demo.) Change the formula to (or overwrite the existing formula with) =count The data in column C will now be the number of plants that match the Summarization. If you go through and change the Tag Display of some of the plant to be different than the others (left instead of right for instance), you will end up with a -- in column D since the data is not the same for every plant. If you now drag a second SUM to column D (remember to select a row in the database first), you will get two multiple rows (one for each Tag Display option) for each plant that has different settings. Plants that all have the same settings will still display as a single row. Hope this helps, Pat Quote Link to comment
Jonathan Pickup Posted November 25, 2008 Share Posted November 25, 2008 why not use one of the predefined plant worksheets. 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.