visard Posted March 19, 2008 Share Posted March 19, 2008 I've read through the 2008 manual on producing records and reports for symbols and didn't see information on how to get reports to show door type and size. Any suggestions? Quote Link to comment
Pat Stanford Posted March 19, 2008 Share Posted March 19, 2008 The door information is in a record that is part of the Door PIO. It is named Door. The formula to get the door width is =door.doorwidth i.e. the record name followed by a period followed by the field name. If there is a space in the record name or field name, then need to be surrounded by single quotes. ' ' You can enter most of these values using the Paste Criteria function from the small black pull down triangle menu. Put an equals sign in the cell and then go to past criteria. Select Field Value is and then select the door field you are interested in. Pat Quote Link to comment
Jeffrey W Ouellette Posted March 19, 2008 Share Posted March 19, 2008 Visard, The standard Door Schedule, accessed in the Architect workspace via the Menu command, Tools > Reports > VA Create Schedule... > Door Schedule is the best place to start. You can add/delete columns, as necessary. For a "Door Type", what information were you looking to convey? We don't currently have a "type" data field, but there are User Fields that you could put the type designation in. Quote Link to comment
visard Posted March 19, 2008 Author Share Posted March 19, 2008 Jeffrey/Pat: thanks for your suggestions. To clarify my intention, I'm trying to get the report to default to the OIP to the 'width', 'height' and 'configuration' settings of the OIP. I imagine the it is possible to attach a record to the door or window object and cause the report to count the objects, show the above size and configuration data and allow me to note finish and hardware, etc. The formulaic method suggested by Pat hasn't panned out probably because the record reference is attached to the marker and not the door itself. Would you suggest that I reset the doors and markers and attach records the door? Quote Link to comment
Pat Stanford Posted March 19, 2008 Share Posted March 19, 2008 So make the schedule of the door markers instead of the doors. Then you can use the =record.field notation to pull the information from your marker record. =door.doorwidth =door.doorheight =door.config will give you the information from the door plug-in record. What will be difficult is to mix and match in the same row data from teh door record and the marker record. Pat Quote Link to comment
Jeffrey W Ouellette Posted March 19, 2008 Share Posted March 19, 2008 Visard, All the OIP parameters you are looking to schedule are part of the Door object already, no need for another tag. Your door object must have "On Schedule" option checked for them to show in the database worksheet. If you use the standard worksheet, these fields are already included. Quote Link to comment
visard Posted April 3, 2008 Author Share Posted April 3, 2008 Jeffrey, The VA schedule is pretty interesting but... it's the size of Oklahoma for one thing, and I haven't been able to discover how to edit the template to show a more relevant set of data. The other thing I noticed is that the object count isn't able to distinguish sequential numbers ie. one (1) is followed by ten (10) not two (2) in; general, text, and scientific cell formats - don't seem to have a numeric format. I would appreciate your comments. Thanks, visard Quote Link to comment
C W Posted April 3, 2008 Share Posted April 3, 2008 (edited) Visard, During the past few weeks I've been working with generating schedules and the program is packed with tools to help you achieve what you're looking for... though nothing is perfect and without compromises. It takes time to get things dialed in to suit your needs but once they are you could could just save the schedule setup as a template. In terms of sequential numbers, if you use the ID Tool to arrange your markers you have the option to insert them in ascending order. Also, there is a "Re-Sequence Openings" plug-in for free: http://www.nemetschek.net/community/addons/plugins/sequence.php -though this isn't without it's flaws... but you may want to experiment with it. Also, I may be confused, but I believe your sequencing issue is simply that it should be object 01,02,etc not 1,2,etc. Edited April 3, 2008 by C W Quote Link to comment
Jeffrey W Ouellette Posted April 3, 2008 Share Posted April 3, 2008 Visard, To edit the Default schedules, you can simply delete the columns you don't wish to include the data for. You can also delete the formula/function in the column of the database header row and it will remove the data without removing the column. You can then replace it with a function/formula of your choice. Once you've changed it to your liking, you can import/export it for other files. C W is right. We don't have global "smart numbering" yet, so you'll have to use 2 or 3 digits for numbers - e.g. 01 or 001 instead of just 1. Quote Link to comment
Kevin Posted April 3, 2008 Share Posted April 3, 2008 How do I change the units in the Schedule? I want my doors and windows to display in inches, but the Schedule show fractions of feet. This is for VW12.5. Quote Link to comment
C W Posted April 3, 2008 Share Posted April 3, 2008 Enter the worksheet then edit the column... very similar to Excel spreadsheets. Quote Link to comment
Kevin Posted April 3, 2008 Share Posted April 3, 2008 Are you sure about this? I tried your suggestion prior to asking the question. I see no ability to set the units for the column. Quote Link to comment
Pat Stanford Posted April 4, 2008 Share Posted April 4, 2008 How are your units set for the document? I think the default for the units is the same as the units for the file. If you are getting feet and want inches, edit the formula for the column and edit it to include a "* 12" to do the conversion. Pat Quote Link to comment
Kevin Posted April 5, 2008 Share Posted April 5, 2008 I stumbled upon the answer. Under the formating section, the cells were set to "General". Once I changed the format to "Dimension", everything fell into place as feet and fractional inches. My schedule units now read in the same format as those shown in the NNA Alexandria Laundry Lofts example. Thanks to all for your help. Quote Link to comment
faust Posted April 30, 2008 Share Posted April 30, 2008 I'm having a numbering issue similar to visard's. It seems to be randomly ordering the doors in the automatic door schedule (sequence 17,15,18,10,07,14,03...). Is there anyway to have the schedule read in sequence (01,02,03...etc)? Thanks! (I tried the plugin and re-sequenced the doors...with some unpredictable results, but the schedule ordering issue persisted) Quote Link to comment
C W Posted April 30, 2008 Share Posted April 30, 2008 (edited) I don't believe there is... although if you place your doors and then label them afterwards per the ID Tool, you have the opportunity to begin in ascending order. Edited April 30, 2008 by C W Quote Link to comment
Pat Stanford Posted April 30, 2008 Share Posted April 30, 2008 You can set the columns to sort a worksheet by by dragging the increasing bars and decreasing bars to the column header with a database row selected. Look for the icons just above the Column A & B headers. Depending on how your doors are numbered, you might need to sort by multiple columns (prefix/suffix). If they are all D-XX, then all you need to do is drag the Incereasing columns button to the Column B header. If you actually want to renumber the doors instead of just change the display order, that is a different issue. Pat Quote Link to comment
doughd Posted May 7, 2008 Share Posted May 7, 2008 How do get the dimensions to show correctly when you summarize doors of the same type? The worksheet seems to add the dimensions (i.e. width) together from the summarized doors. Is this a bug, or am I doing something crazy? Quote Link to comment
Pat Stanford Posted May 7, 2008 Share Posted May 7, 2008 If they are all the same size, change the formula to =width/count If they are different sizes, you are out of luck. Pat Quote Link to comment
doughd Posted May 7, 2008 Share Posted May 7, 2008 Pat, thanks for the response. I'm a little confused by what you said. I tried that formula, but it didn't give me the door sizes. In the Qty colum, I used =COUNT for the formula. Right now the formula in the Nominal Size Width column is =(Door.DoorWidth). Thx! Quote Link to comment
Jeffrey W Ouellette Posted May 7, 2008 Share Posted May 7, 2008 Doug, Please download the attached .VWX file with a "type summarizing" Door Schedule. You can either import or compare and adjust your worksheet's formulas accordingly. Quote Link to comment
doughd Posted May 7, 2008 Share Posted May 7, 2008 (edited) Thx Jeffrey. I got that to work on all doors except overhead doors. For some reason, the overhead doors' width and height dimension is cut by 4, but there are only 2 doors. I have my qty of doors in the very first column, so the formula extension I have to use is /A4. Maybe I should copy those overhead doors in plan and delete the old ones? Does it sound like a bug with those 2 doors? AND some windows are doing this as well! What is up with that? Edited May 7, 2008 by doughd Quote Link to comment
Pat Stanford Posted May 7, 2008 Share Posted May 7, 2008 For those who don't want to dig around in Jeffery's worksheet for the trick, here it is. Insert an additional column into your worksheet and enter the formula =COUNT in the database header. This will give you the number of items that meet the summerization criteria for that row. For this example I am going to assume it is in column AD (as it is in Jeffery's worksheet.) Edit each of the cells that are displaying incorrectly (width, height, etc) to include a "/AD" on the end (without the quotes. For example, the formula for the Width in the default schedule is: =(Door.DoorWidth) Change that to: =(Door.DoorWidth)/AD The trick is that you have to include the count on the worksheet. It will not work if you enter the formula =(Door.DoorWidth)/Count Pat Quote Link to comment
Jeffrey W Ouellette Posted May 8, 2008 Share Posted May 8, 2008 Doug, Sorta sounds like a bug. I would have to take a look at this to be sure. Quote Link to comment
doughd Posted May 20, 2008 Share Posted May 20, 2008 Please check it out, I can't finish my schedules until this is fixed. Can I turn the schedule (or worksheet) into just one big text block, so that I can edit it manually? 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.