AutoCAD Architecture :: Formula In Table - Convert Negative Result To 0 (zero)
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
ADVERTISEMENT
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)
View 3 Replies
View Related
Oct 28, 2010
I have imported an Excel 2003 spreadsheet into an AutoCAD 2010 Table, all came in fine except the following formula =ROUNDUP(((SUM(E27:E33))/24),0)
Does 2010 not support ROUNDUP ? The formula is used to calculate the number (whole) of driver boards required to drive the number of LED's calculated by the SUM function. Each driver board can drive 24 LED's, so if i have 23 LED's I need 1 driver or if I have 25 LED's I need 2 drivers
Also is there a list or table that shows what Excel functions are or are not supported in AutoCAD? I can't seem to find one.
View 4 Replies
View Related
Aug 12, 2013
i have a table with a simple formula =sum(b3:b16) the formula works fine what i want to do is after the formula i want to add text. if the value of the formula is 22 i want the cell to read 22 V.F. i'm using civil 3d 2014
View 3 Replies
View Related
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
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
View Related
Oct 5, 2011
Im trying to create a material for glass balustrade that will elevate and show outline but not block what is behind. Useful for shr screens (show tiling, taps etc) balustrade for balconies, stairs etc.
I have balustrade I'm working on now using a railing object. There are no posts at all and I'm using dynamic posts with a nothing material to cut up the guardrail material into pieces. So need the posts to disappear but stil cut the glass into sections. Also in elevation, need to see the glass outline but also to show what's behind. Normal glass in elevation rightly blocks what's behind (inside).
There is a problem with how materials operate. You are unable to use an object/material combination as a negative. For e.g. assigning my posts above a material that has 3d body turned off negates it impacting the glass (ie no longer cuts) so I have to 'see' the gaps otherwise the glass goes straight thru. The post has to be directly inline with the glass to cut (fair enough) but turning the 'gap' material 3D body display off and the railing def no longer sees the post cutting the glass just because 3d body is turned off in the material display. (not sure why these have to be linked. If glass has frame (shr screen) then it's ok. just turn off glass but if in the case of glass balustrade you need to be able to do it.
Im thinking maybe using another object rather than railing, like a curtain wall and having a very small width frame using normal glass material that will elevate and another glass material that will disappear.
View 1 Replies
View Related
Jun 6, 2012
This problem has bugged me for several versions. I'm using 2012 at the moment as I haven't wanted to get into the fiasco of a new drawing version with 2013.Anyway, the image below really tells the story for me:
You can see the behavior of the crosshairs overlapping a drawing line with Hardware Acceleration On and Off. It's always been handy to have the drawing lines or crosshair go to the "negative" color when they overlap. However, with Acceleration ON, that behavior goes away entirely. This happens on every machine we have. It's not isolated to one machine or video card. In fact, on this same machine I have had this happen with two entirely different video cards.
So, I have to choose...hardware acceleration or overlapping negative colored lines.
View 1 Replies
View Related
Feb 27, 2009
I am photographing 2 1/4 negatives with a CANON 50D and macro lens. Then in Photoshop CS3 I was looking for the filter to convert the negative film file into a positive file so I can work on it with Adobe and then print in on my Canon printer.. I have tried to sample the orange base color and take that out and then invert and then increased the contrast curve.
View 1 Replies
View Related
Feb 12, 2013
Is there a way to control which of two 'Graphic Property definitions' are used via a formula property with a IF, Then, condition statement?
View 3 Replies
View Related
Jun 21, 2013
I have just scanned a color negative into photoshop and lo and behold it comes up on screen as a color negative. How do i now convert it to a positive so that I can work with it.?
View 11 Replies
View Related
Oct 23, 2013
how do I convert a digital image to a negative?
View 1 Replies
View Related
Aug 25, 2011
I have two related properties... One is a formula property, the other is a manual property.
In the formular property I'd like to set the value of the manual property.
View 1 Replies
View Related
Aug 28, 2012
I am insert a sheet list table - Two Columns "Dwg #" and "Sheet Title" under the first category (building 1) each column works fine) then under category 2 (building 2) it gets the file name under the dwg #.
View 2 Replies
View Related
Sep 13, 2011
In ACA2008 there seems to be a maximum of 10 Cell Styles allowed in a Table Style? When I try to make a new 11th style, one of the existing 10 styles gets supplanted by the new style.
View 3 Replies
View Related
Dec 21, 2011
From Project Navigator, I R-click the Project in the SHEET tab. This is not "lit up" to choose.
I am in my cover sheet, paper space, with 51 sheets in the set.
I tried to use the Sheet Set Manager, but I have the same problem.
View 6 Replies
View Related
Dec 10, 2013
I have a linked table (linked to an Excel spreadsheet) in my drawing. I would like to set the transparency of the lines in the table in ACA to about 80% - BUT I want the text in the table to stay at 0% transparent. Is there a way to do this? I get the whole table, text and all, at 80% when I try.
View 1 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
Feb 9, 2013
How can I convert negative image to a positive image in Lightroom.
View 2 Replies
View Related
Sep 12, 2013
I have photographed some colour negatives in RAW. Any outline of a process as to how to convert these to positives using Lightroom v5. I have tried and failed!
View 6 Replies
View Related
Jul 7, 2011
In ACA2008, can the display of each of the four edges of a cell in a table be controlled individually? I want left and right edges of cells to display, and top and bottom edges to not display. In the Cell Border Properties dialog box, I can set the Lineweight, Linetype, and Color of each edge, but I don't see how to set the visibility of each edge.
View 4 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
Sep 1, 2010
Having problem with the monochrome .ctb plot style table not showing up in the plot dialogue for AutoCAD Architecture 2010? Typically it seems to be standard upon install of the software.
View 6 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
May 30, 2012
Some view-port with excel table external reference does not appear when I print
View 1 Replies
View Related
Jun 5, 2013
I am trying to convert my Sheet List Table into an editable Excel or Word document.
View 1 Replies
View Related
May 5, 2011
I struggled for a while this morning with trying to data link to a large door schedule in Excel. After several failures, I searched online for answers, and read in another forum that AutoCAD won't data link to more than 2000 cells.
My door schedule is about 2050 cells now, and will be about 4000 when done. I defined a set of about 1,000 cells in the Excel spreadsheet, and AutoCAD linked to it no problem. So, I tend to believe the poster who stated the 2000 cell limit, but I can't find this.
View 1 Replies
View Related
Sep 4, 2012
I can convert the dwg to a bitmap, but the problem is when I select the object to convert the viewport is also displayed. If I do not activate model space, to select object, then nothing is displayed but viewport. Am I missing a step?
View 2 Replies
View Related
Mar 19, 2012
I am repeatedly running into the same problem of a data linked table losing its formatting upon closing and opening the file.
Each time this happens, I am forced to enter the properties tab and return the height of the text and the height of the cell to the size that it had originally been. Is there an option that I have not seen? What is continuously causing this error?
View 1 Replies
View Related
Oct 14, 2013
I want to convert a table from .doc to an image file.
If I screen print it and edit in paint.net the quality deteriorates.
I copied the table from the doc file and directly pasted in paint.net
This is what i get after pasting it,
My question:
How do I get a white background for this table? I want the quality same as you can find in the word doc. I used paint bucket but again the quality doesn't look the same.
View 3 Replies
View Related
Aug 5, 2012
In Revit there is a tool to convert lines to walls including lines of an xrefed AutoCAD file. Is this feature available in ACA?
View 3 Replies
View Related
