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)

View 3 Replies


ADVERTISEMENT

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 View Related

AutoCAD 2010 :: Roundup In Table Formula?

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

AutoCAD Civil 3D :: How To Add Text To Formula In Table

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

AutoCAD 2010 :: Formula (s) Used For Making PEllipse?

May 2, 2012

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.

View 9 Replies View Related

AutoCAD 2010 :: Explode Excel Table But Keep Table-layout And Texts

Mar 14, 2013

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)

View 2 Replies View Related

AutoCAD 2010 :: Same Hatch Properties But Different Result?

Feb 23, 2012

Same hatch properties but different result! How come?

In the screenshots below, I got a hatch of the same properties, but the output in the screen is different!

Software: AutoCAD 2014, AutoCAD C3D, AutoCAD M3D, Revit
Windows 7 (Ultimate 64 bits),
Firefox 20.0,
Kaspersky 2013.

View 9 Replies View Related

Photoshop :: Convert A Film Negative To A Positive...

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

AutoCAD 2010 :: Trim Settings - Earlier Result

Nov 3, 2013

I have some issue in Trim command,.

(Please see the attached picture before read the below steps,.)

generally, I use trim command like this,.

Command: tr (enter) (enter)
select object: (I will select object which I need to trim)

it gave the results shown in the picture named "Earlier result"

But now I am getting differently like "current result"

But Earlier result is comfortable for me,.

Is this because of setting problem?

View 2 Replies View Related

AutoCAD Inventor :: API 2010 / API 2012 - Different Result Of ReferencedFileDescriptors

May 10, 2012

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 don't get it....

View 2 Replies View Related

Photoshop :: How To Convert Scanned Color Negative Into Positive

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

Photoshop Elements :: How To Convert Digital Image To Negative

Oct 23, 2013

how do I convert a digital image to a negative?

View 1 Replies View Related

AutoCAD 2010 :: How To Create Filters Both Positive AND Negative In Parameters

Sep 9, 2013

I have in the past needed to create filters that had both a positive AND a negative in the parameters.

One of my most common examples:  Layers in a specific XRef with names that do not contain specific string.

I tried XRefName|*[~anno]* and it gave me ALL the layers from the XRef (including the ones with anno in the name).

I also tried XRefName|*~anno* and it didn't list ANY layers.

It it possible to do this?  I've read throught the docs on using wildcards in the filter properties but don't see anything.

View 3 Replies View Related

Lightroom :: Convert Negative Image To Positive Image?

Feb 9, 2013

How can I convert negative image to a positive image in Lightroom.

View 2 Replies View Related

Lightroom :: How To Convert Colour Negative To Colour Positive

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

AutoCAD 2013 :: Convert Sheet List Table Into Editable Excel Or Word Document

Jun 5, 2013

I am trying to convert my Sheet List Table into an editable Excel or Word document.

View 1 Replies View Related

AutoCAD 2010 :: How To Convert Solid To Polyline With Mechanical 2010

Nov 8, 2012

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'. 

What am I missing here?

View 1 Replies View Related

AutoCAD 2010 :: Convert Standalone Installation Of 2010 To Network?

Jan 28, 2010

How to convert standalone installation of AutoCAD 2010 to network one without uninstalling the existing standlone version.

View 9 Replies View Related

Paint.NET :: How To Convert A Table From Doc To Image File

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

AutoCAD 2010 :: How To Write (If Statement) In The Table

Apr 19, 2012

Is it possible to write “If statement” in the table?
 
For example, I wanted to have the following if statement:
 
If b3>180º, d3 = b3-180º
If b3<180º, d3 = b3 +180º
 
Is this possible in the AutoCAD the same way we do it in excel? 

Software: AutoCAD 2014, AutoCAD C3D, AutoCAD M3D, Revit
Windows 7 (Ultimate 64 bits),
Firefox 20.0,
Kaspersky 2013.

View 6 Replies View Related

AutoCAD 2010 :: Updating An Existing Table

Mar 24, 2012

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?

View 1 Replies View Related

AutoCAD 2010 :: Table Coming In Mirrored?

Feb 7, 2013

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.

View 6 Replies View Related

AutoCAD 2010 :: Imported Excel Table

Apr 3, 2012

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?

View 5 Replies View Related

AutoCAD 2010 :: Table Rows Linked To XL

Sep 6, 2012

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?

View 2 Replies View Related

AutoCAD 2010 :: Change Font In Table

Mar 12, 2010

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.

View 8 Replies View Related

AutoCAD 2010 :: Importing Of Text As Table?

Mar 28, 2012

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?

View 1 Replies View Related

AutoCAD 2010 :: Table Cell Text

Jul 29, 2009

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.

View 7 Replies View Related

AutoCAD 2010 :: Launching Excel From OLE Table

Oct 13, 2012

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.

View 2 Replies View Related

AutoCAD 2010 :: Table - Remove All Property Overrides

Aug 20, 2012

No documentation : remove all property overrides

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.

View 1 Replies View Related

AutoCAD 2010 :: Dynamic Block - Lookup Table

Oct 22, 2012

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.

View 9 Replies View Related

AutoCAD 2010 :: Missing Plot Style Table

Feb 6, 2012

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. 

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved