AutoCAD 2013 :: Architecture 2014 - Formula Column Totals In Schedule
Nov 22, 2013
when creating a schedule with a simple formula column (e.g : [QUANTITY]*Width), the formula column total doesn't add the formula results for a grand total. The total shown is the addition of Width of element.
If I try and enable "Apply formula to totals", the total is : total quantity*total width instead of just a simple addition of formula resulting values.
For example:
I have 4 windows of 2 different styles.Two windows have a width of 2 meters, the other 2 windows have a width of 3 meters. I want to find out, my total window width, of all window styles.Therefore, i make a schedule with the following columns: QUANTITY, WIDTH and TOTAL WIDTH. The total width column is a formula column (Quantity*Width). The total of the formula column (Quantity*Width) doesn't add the resulting values (2*2+3*2=10), it only adds the simple widths without multiplication with quantity, my result is 5, wich is incorect. If i enable "Apply formula to totals", it multiplies total quantity (4) by total width (5).
I need a solution for having the corect total on the formula column.
View 3 Replies
ADVERTISEMENT
Nov 22, 2013
when creating a schedule with a simple formula column (e.g : [QUANTITY]*Width), the formula column total doesn't add the formula results for a grand total. The total shown is the addition of Width of element.If I try and enable "Apply formula to totals", the total is : total quantity*total width instead of just a simple addition of formula resulting values.
For example:
I have 4 windows of 2 different styles.Two windows have a width of 2 meters, the other 2 windows have a width of 3 meters. I want to find out, my total window width, of all window styles.Therefore, i make a schedule with the following columns: QUANTITY, WIDTH and TOTAL WIDTH. The total width column is a formula column (Quantity*Width). The total of the formula column (Quantity*Width) doesn't add the resulting values (2*2+3*2=10), it only adds the simple widths without multiplication with quantity, my result is 5, wich is incorect. If i enable "Apply formula to totals", it multiplies total quantity (4) by total width (5).
View 4 Replies
View Related
Oct 1, 2013
how to get the annotative scale to work with schedule tags.When I use attributes in blocks I draw the attribute definition with a height that I wish it to display in PaperSpace. Then when defining the block I select the annotative scale so that the block and text display correctly in any viewport.
However when I create Scheduling Tags using the Create Tags button on the Annotate/Scheduling tab it shrinks the text by 1/8" as soon as the tag is created. I've made sure that the scales are set to 1:1 when I create it. I guess I can just enlarge the text 8 times before I make the Tag.
View 4 Replies
View Related
Sep 27, 2013
I continue to suffer project downtime and setbacks due to a variety of defects in the software. Here formula columns are not working. I created a Formula Column for simply computing ItemQTY *Item Cost in a Data Extraction table for a current project.
QTO is defective, and now Data Extraction is not working. What does the product leadership expect us to do for quantity analysis?How can Quality Control of this software significantly improve?
View 5 Replies
View Related
Nov 25, 2012
I want to add a column to my parts list, which displays a value based on a formula.
Lets say i want to show the submerged weight of a part; So i need to create a column, which can use the information about a parts volume and mass to calculate its submerged weight.
An easy formula, but is this possible in Inventor (2012 Pro)?
View 2 Replies
View Related
Jul 8, 2013
When I try to attach a 2013 Excel file into a 2014 drawing I get a message 'You have selected an unsupported DGN File. Only V7 and V8 files are supported.' Cannot attache through the Import command either. I know in past versions you could insert the file and any changes made to the file appeared to the attachment in the drawing.
Is this no longer possible? Surely not, it is way to handy. What am I overlooking to make this happen?
View 1 Replies
View Related
Aug 6, 2011
I can create structural column schedule but i cant create for architectural columns.i wonder that i do something wrong or simply i cant be done?
View 1 Replies
View Related
Jul 15, 2012
I am having trouble creating my own column and beam
structural column schedule
structural framing schedule
i do not know the settings to be ticked for me to create the schedules and make them appear after i create new scheduling...
also i want to know how the graphical column and beam works...
then setting the level in the schedule to make them reflect instead of using the comments section...
Attach here is a screenshot of the levels...
View 3 Replies
View Related
Oct 21, 2013
my drawing file , have block name 'column' but i want to change name from column to new column.
View 2 Replies
View Related
Sep 10, 2012
I am setting up a table to automatically calculate plumbing fixtures based on occupancy count.
The problem I have is creating a formula for plumbing fixtures for B occupancy where toilets are required at 1 per 25 for the first 50 occupants and thereafter 1 per 50 occupants. (International Building Code)
A simple formula for 1 at 25 would be "value/25" whereby the value would be a cell content (occupancy number).
Taking this further with a formula like "(value-50)/50+(value/25)" works fine as long as the value (occupancy) is greater than 50.
If the value is less than 50 the first part of the formula (value-50)/50 creates a negative result.
Is there a way to convert a negative result of the first part of the formula to a 0 (zero)
I know this is possible in Excel with the "max" function
View 2 Replies
View Related
Sep 4, 2012
I'd like to apply a property set to a dimension, tag it, and have the tag display the dimension value. This tag would be remote from the dimension, and on a separate layer, which would remain on when the dimension layer is frozen.
At present, the property set for dimensions appears not to include the dimension value.
View 6 Replies
View Related
Jan 3, 2014
I am having trouble creating custom schedule tags. I have followed the tutorial "to create a schedule tag", but it does not work for me. First off it is not annotative, I created it in 1 to 1 scale and checked the plotting scale to ensure it is 1 to 1.
Also, it creates the block, and I get it into the tool pallet, but when selected, it just inserts a block. I am trying to create a door tag, so when I select it from the tool pallet, it does not ask me to select a door to tag, just inserts the block.
The tag I want to create is very simple, I want to modify the OTTB Door Tag - Project Based, to remove the suffix and center the door number.
View 1 Replies
View Related
Mar 4, 2011
The architect has a schedule set up that will schedule his room numbers and names. He draws spaces for each room.
I want to add perimeter and area to this. I copied this room schedule in the tool pallete, renamed it with "trial", added columns for perimeter and area, BUT STILL GET ? FOR VALUES!
I've looked everywhere and it should work. When I look at "properties" of the space it shows area and perimeter, but I can't figure out how to extract the info.
View 3 Replies
View Related
Mar 4, 2013
Possible to send attribute data that is in our title block to a schedule that is populated with property set definitions? We are not using the Project Navigator at this time.
View 2 Replies
View Related
May 23, 2008
I am getting an error message when I am trying to insert a schedule room tag. It does not matter which room tag out of the content browser I select, I get the same message. the message is as follow: "No symbol has been specified for the tag" All of the tags have worked up until today. Nothing has changed that I know of on our network and all of the paths seem to be pointing to the correct directories. We are currently using Architecture 2008. This problem is only coming up with these specific room tags.
View 3 Replies
View Related
Nov 1, 2013
I've created a number of spaces, and I want the space name to show up in a Room schedule. Here is a picture of the Properties window with one of my spaces selected. The space name is 'Spanish 2'. see first attachment
I understand I need to add a column to my room schedule that has this value in it. Here is an image from the 'Edit Schedule Table Style' dialog and the 'add column' sub dialog.
see second attachment
which one of this rather lengthy list is the correct one? I've tried all the values that have 'name' in them but all I get is '?' in my schedule. I've attached the file I'm working on. I created the spaces by dragging and dropping from the tool palettes out of the box, and the room schedule the same way.
View 6 Replies
View Related
Dec 6, 2012
Is it possible to Justify an entire schedule? It appears that my schedules have an anchor point that is the upper right corner. Is it possible to change it to the upper left corner?
View 3 Replies
View Related
Oct 20, 2013
Is subtotaling still impossible with ACA 2014?
Is there a workaround to what I am trying to do? I just want to create a table that has a list of all the spaces sorted by name, give a quantity of the spaces and the combined area of all those spaces in one row of the table.
Roughly:
King 4 2000sf
Queen 2 1000sf
Suite 4 3000sf
My attached schedule gives a row for each space, except that it groups spaces of exact same areas. I want a single row for each room type.
Also, when working with spaces sometimes using Space_Add, Generate I am met with the response that a space already exists and no space can be added. The "phantom" space does not show up in the schedule, thawing all layers does not reveal any space and I've tried all my selection tricks to parse a space from the closed boundary that appears empty.
View 4 Replies
View Related
Aug 31, 2012
There is a problem with my AutoCAD installation that is not allowing me to format my field if that field is a formula. The default unit is Architectural, and most times that is not what I need. I have uninstalled, and reinstalled, I have reinstalled only, and I have gone through and deleted all references to my AutoCAD 2013 installation before reinstalling. This is a huge issue as I am building templates and I need this functionality as I automate our drawings. Where this is happening and how to fix it. I originally downloaded 2013 (Design Suite Premium) from this site through the subscrption center, so I thought it was a bad download, which it may have been, so I then ordered the physical media, which arrived today, and I tried uninstalling, deleting all traces and then reinstalling, but I get the same result. This leads me to believe that it is a problem which is stuck in the install file in my registry, and I need to delete that before reinstalling, but I don't know where it is.
I am attaching pictures of the problem area from my 2013 version where this feature does not work, and my 2011 version where it did. The picture from the 2011 version is actually of the objects field section, but I should have a very similar screen for the formula field creation in the same area of the dialog box.
View 9 Replies
View Related
Mar 16, 2012
I've got a multi-family building where I'm trying to create a schedule tag that will number walls sequentially in a view drawing. The units are elements that are then brought into a construct and mirrored and rotated as needed.
The first thing I did was to create a Property Set that uses Level and Manual property set that automatically increments to create a property called Unit Number. Then created a tag that will number the units in my building i.e. : 201 202 etc. This works fine.
I then created a Property Set to apply to the walls that uses the Unit Number from the other Property Set along with a Manual Property Set that increments as well to create a wall tag. What I am expecting to get is 201-01, 201-02 etc. What I’m getting is ?-01, ?-02 etc.
View 7 Replies
View Related
Feb 14, 2011
I am having a hard time creating a material takeoff schedule in ACA 2011. I can't seem to get it to give me a square footage of any material. I can get the left and right side gross or net square footage.
I created the walls with components and mapped materials to these but I can't seem to get that info in the schedule.
View 1 Replies
View Related
Jan 26, 2011
I'm having problems in exporting a window schedule from ACA 2010 to Excel. I have Excel 2010 installed on my home computer.
when I try to export I get the message that excel application may need to be loaded.
View 1 Replies
View Related
Dec 21, 2013
I'm using ACA2013. I've been working on making a couple of custom schedule tags and have found what seems to be a bit of a glitch. I have the annotative scale set to 1'-0"=1'-0". Once I have the desired linework and attributes created, I have used the 'create tag wizard'. Once that is finished, the tag is inserted at a much smaller size than the linework I used - 1/10.6666. If I scale the linework and attribute text size by 10-2/3 prior to using the 'wizard' then the tag is created the correct size. Is there something I'm doing incorrectly or is that a glitch in ACA2013?
View 6 Replies
View Related
Nov 25, 2013
So, I'm familiar with creating Property Set data and schedule styles and all, but I am having trouble wrapping my brain around the following, I would love to know how you tackled it in the simplest way possible:
I need to show a schedule for Windows and Doors, that will read the drawing or selection, and list all the door and window types. Now, that is not so bad, but there is a caveat that I can't get past.
We offer two or more Manufacturers for said windows and doors and are being asked to show tags on our floor plans that reference a table that says:
"For window type "1", ship either Manufacturer A - Part No. X, or Manufacturer B - Part No. Y
What I can't wrap my brain around right now is how to get Property Set data to know that "1" means both of those parts, and not one or the other. The way this is supposed to work, is for each of our plans we are to have only the types ("1", "2", etc.) that are currently shown on that plan, and if one of those windows or doors change to a different type, have the schedule update automatically.
I would prefer not to need to write a LISP or Vlisp that does this, but am open to using VBscript in the Property Set Data, I am just unsure of how to write that into a Formula.
View 4 Replies
View Related
Mar 6, 2011
I need to make the door schedule have the room name in it. I am using the project based door tag so it is already numbered like the room tag.
View 2 Replies
View Related
Nov 24, 2009
I am having a problem with project based door tags getting the *ERROR GETTING VALUE*. I have checked the synchronizations and they are fine. The tags work in all our other projects, just not this one. We are also having some problems with a ? showing up for a space style in the schedule.
View 8 Replies
View Related
Apr 20, 2011
What is the best way to setup Plot Co-Ordinates that have a tag that updates as you move the co-ordinate point and also I would like to schedule these points in a table ..
for e.g. :
Plot A
_______________________
E 123456.789 N 123456.789
View 2 Replies
View Related
Aug 7, 2011
I am having trouble trying to edit the title fonts in a door schedule. No matter which font I pick under "Edit Schedule Table Style" after a selection of the schedule and right clik, the title font will not change. The listed doors font does change. Is it not poosible to change the title and descriptor font?
View 1 Replies
View Related
Feb 18, 2013
I have the below code where by I can gain access to property sets.
But it doesn't look like the Schedule Styles are there.
How can I change this up to get access to Schedule Styles defined in the drawing?
(setq acadObj (vlax-get-acad-object)
schedApp (vla-getInterfaceObject
acadObj
"AecX.AecScheduleApplication.7.0"
)
)
View 2 Replies
View Related
Mar 16, 2012
Im trying to change the table style formatting and nothing seems to stick. I want to turn the border off in the title cell and only use a thick underline.
I change the schedule cell, save changes to the style and Ive tried saving as a new style but when I reinsert the cell format is gone. Back to the out of the box state.
Also, when I save the OTB style to my new A3 Sheet Keynote style the new style doesnt match what was saved.
View 3 Replies
View Related
Oct 7, 2012
I am creating a schedule to pick up the room areas and additional information to do with artificial lighting. That bit is the easy bit.
What I am trying to do is put a column in the schedule that shows how many light points are within that particular space. I have looked into ticking the quantity box, but that picks up just the spaces. If there was a way that this could be used to pick up the blocks in a particular space, and not the spaces that would be the simplest way to solve this (I think anyway).
Just to let you know, I am using Dynamic Blocks for the light fittings. As I can have all the different types within the one block. I have heard that I can do this using the MultiView blocks (I haven't explored this yet), but the amount of blocks that I need is going to be increased (from what I know about MultiView blocks). The simpler this is, the better I believe.
I have tried using Count under the Automaitc Property, but when used, adds the blocks as an extra row, not into the desired column. I may have to add something to the block to get it to do what I want it to do, but don't know how to do this. At the moment, I am putting this information manually into the space properties.
The next part to my question, and again, I maybe asking a bit too much here, but I want to take two totals from two different columns to create an average. If I could do this in the one table, fantastic! If I have to create a second schedule to pick this up, that is ok I suppose, but I would then do the math for it manually and just write it in if that was the case.
I'm using ACA 13
View 8 Replies
View Related
