AutoCAD 2010 :: 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 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
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.
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
I write programs for large CNC routers, and I'm trying to make a parametric program that uses an ellipse in it. I need to know the formula or formulas used to produce the arcs that make up a pellipse so that I can get the radii, and end points of each arc.
In our company, we put Excel tables in our drawings. The reason we've chosen for Excel-tables is that we can adjust the layout of the table quite easily. These tables consist of grouped cells in a particular company-specific layout. We select the range of the desired cells, copy and paste them in our AutoCAD drawing. This drawing is sent to our customers. The disadvantage of this method is, that when our customers (who use CAD-software of other brands) open the dwg, they don't see the table, but some kind of picture of the table.
Is there a way to 'explode' the excel-table, but keep the specific layout of the table? For attributes in blocks there's the 'Explode Attributes'-command in the Express-tools, but is there something similar for Excel-tables?
Product Design Suite 2014 Inventor 2012 SP2, Vault 2014 HP Workstation Z220 Intel Xeon 3.4GHz 16GB RAM Nvidia Quadro 4000 Windows 7 Professional (64bit)
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.
As you could already read in the headline of this topic, I'm getting two diffrent results from Inventor.File.ReferencedFileDescriptor with the Inventor 2010 API and Inventor 2012 API when I'm trying to get some information from the same Inventor file!
In my case the FullFileName and therefore the ReferenceMissing property get's me different values, although it's exactly the same Inventor file and exactly the same source code.
How could this happen? Any changes for the ReferenceFileDescriptors object from API 2010 to 2012?
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.?
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!
I'm using AutoCAD Mechanical 2010 and received a .DXF file that contains 'solid' objects. Unfortunately the next tool in my workflow doesn't understand 'solids' only polylines (and a few other basic shapes like circles, lines, etc). Is there some way to convert the object in AutoCAD?
I tried the 'boundary' command but when it asks to 'Pick Points' and I click inside the solid, it always gives the error 'Valid hatch boundary not found'.
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.
I'm attempting to create a table within autocad that I can update as I add new things to my drawing.
I have a ton of dblocks that carry attributes with them, and I want to be able to have the table in autocad populate with the information from each insertion.
The table in autocad will be linked to an excel spreadsheet that should also be updated (either as a separate action or automatically... not sure what would be better).
The table in excel will go through a system of formula that will divide it up into useable groups for me. How do I update a table within Autocad, instead of having to create a new table every time I want to add data to the extraction information?
We use a table with an inserted jpeg image (company logo) as our title block. Everything works fine when you start a new drawing, however, when one tries to insert the template into an existing drawing or thru a new layout, the table that is our title block comes in mirrored with the rows and columns all out of whack.
I have a table imported into autocad from excel, however despite the table (excel) being formatted, border lines appropriately placed and hidden througout the sheet, all off the border lines of the cells appear when imported into autocad.
is there anything i can do to hide back some border lines for selected cells?
I've linked a table to an Excel file. It comes in with twice the number of rows that are needed. There are 35 rows of data and it comes in with 70 rows. The print area in Excel is set to only the 35 rows. Can I truncate the table?
I copied a piece of an Excel file into AutoCAD as a table. It comes in with the truetype font even though it is assigned to a table style that utilizes an shx font and the correct text style is assigned when I double click in the cell. If I click into the cell and change the text style it will change the font but this will be very time consuming.In the end, I need an AutoCAD table with this information.
i Have the dwg drawing in which a table is made by simling joining the lines & putting the text in those line.Can that data in actual be converted into the table?
I am currently using 2008. I have data linked an excel sheet to a table in my drawing. That part works fine.I am trying to link cell values in that table to block attributes using fields-object-formula-cell.Numeric values transfer to my field OK but values containing letters or full words transfer as #####.This appears to be the 'way it is' in 2008.
I use an embedded excel file I a lot of my drawings. 90% of the time a double click opens excel for editing with no problem. But every so often I get a stubborn one that just will not open. It will select and the quick properties box will appear and then the properties box, but nor firing up of Excel. Usually if I am persistent I can get it to work, but I have one right now that is more stubborn than I am.
If I insert a table with our standard table style is is to big, so made a smaller text style, made a new table style with the new text style in it.
And if I insert a new table with the new style its still big...
But... select the table, right click, Remove All Property Overrides... And the text style is OK, only the row height is wrong, so in the table bar - unlocked, select the table again and move the right little triangle up until the rows don't get smaller.
I have created a dynamic block and have applied some lookup tables to it but its not working just the way I want it. I think its to do with the custom entry on the lookup tables. If I delete the custom entry when i select the block in model space the drop down select box to allow me choose a selection is no longer available. How can I remove the custom entry and still have the block working normally. I've attached the block.
Here's my problem: I have a customized plot style table "SK.ctb". I have it saved both in the appropriate folders on my computer and in a shared folder on the network. Usually when I am working in a file and open the plot window, my plot table is available in the list at the upper right "Plot style table (pen assignments)".
Right now I am working in a drawing that was sent to me by another firm. They of course didn't send me their pen assignment tables, not that I really care as I would rather edit the layer colors if necessary, but use my own. The problem is that in the plot window it is only showing their plot styles - none of mine! Theirs are all listed as missing, but I can't get it to even look for the plot tables I usually use.
