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
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
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
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
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
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
Sep 27, 2013
When labeling pipes in a pipe network; is there a way or expression to roundup the label to 6 inch interval. For example, if I have a pipe length of 2.6 feet, I want to roundup this to 3.0 feet and if I have a pipe length of 2.4 feet, I want to roundup this to 2.5 feet.
View 7 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
Jul 25, 2012
I am trying to add a table that I can edit like an attribute but have it in a block, Basically I am trying to put information for all the poles in an electrical panel, but im not using MV parts just a block is there anything that can be recommended in this instance.
Just another note I need to reference 72 poles and 5 colums for each of these.
View 1 Replies
View Related
Feb 18, 2010
Can't drag it, copy it...anything. I guess you're just never supposed to want your table on some other sheet than the one you created it on.
Oh wait; I know...I could just swap everything *else* on the two sheets....
View 5 Replies
View Related
Sep 24, 2012
I have linked a table from excel into autocad 2012. I have selected "Start with excel formatting, do not update" in the datalink options. My problem is when I break the table the first table will keep my formatting changes - text height and alignment, but the following table breaks do not stay the same once I close and reopen the drawing
View 1 Replies
View Related
Nov 23, 2011
I am trying to insert a table using a data link. I set up the Link through the DataLink manager and then insert the table using a range. I click OK to insert the table and after a few seconds of thinking ACAD sits there with no table on the screen. When I look in XREFs, the DL is there but says it is unrefrenced. Tried multiple ways of entering or setting up information to no avail.
View 6 Replies
View Related
May 30, 2012
I like the concept of datalinks, it's ingenious working with excel and do what excel does best instead of doing it in acad. I am done with the excel part and want to edit my table in autocad.
My problem is that I have some unused rows and columns that I can't get rid of, erase is greyed out.
View 2 Replies
View Related
Sep 26, 2012
Is there a way to hide or collapse several rows in a Table with a single click? This would be similar to grouping rows together in Excel.
View 1 Replies
View Related
Mar 2, 2012
Using Civil 3D release 2102 on a 64bit Win7 capable Dell Precision, everything up to date.
I have a table created from a datalink using TABLE command. I want to have it use a fill color of 255 in order to mask the objects behind it. I cannot seem to modify the table style, and using fill in Excel doesn't seem to the affect Autocad table.
As you know, when I create a table from a datalink I am not allowed to choose which style.
I don't like using wipeouts to provide a background mask, because they never seem to work when plotting from paper space.
How I can apply fill to the table, or otherwise mask the pbjects behind the table?
C3D 2012 on 64bit Win 7 all up to date
Dell Precision 7core 8GB RAM
NVIDIA Quadro FX 1800M
LDT/C3D user since release 12
View 1 Replies
View Related
Jun 26, 2012
We are experiencing a case where the sheet list table will not insert into a page. It works on all other jobs, but this one won't let a sheet list table insert into any page, by any body.
I even tried inserting a block of the table from another set and then updating - all the lines disappeared.
We have done about 200 jobs with these, without trouble and this is the one giving us problems now.
View 9 Replies
View Related
Oct 9, 2013
How can I change this :
Unselected - Selected
Can I make this line a bit thinner ?
It's a kind of highlight but makes the table unreadable.
View 9 Replies
View Related
Mar 7, 2012
I've started having problems when trying to edit text in table cells. Sometimes I double click and all is ok. Sometimes it wont let me select anything in the cell. Sometimes I have to select the cell, then right click to edit text. I get this message:
Command: Specify opposite corner:
Invalid window specification.
Specify opposite corner: Specify opposite corner:
Is this likely to be a hardwear issue, and the pc is struggling to run AC correctly with all the other crap my company has running in the background? Or is there a systems setting that may have been changed, for whatever reason?
View 4 Replies
View Related
Jan 26, 2012
Is there a way to create a table to display parametric information -- either Dimensional Constraint Parameters or User Parameters? This can be done with Inventor but I haven't yet found a way to do this in AutoCAD. I've also considered Data Extraction but this doesn't seem to recognize parameters.
View 1 Replies
View Related
Feb 21, 2012
I want to import my excel table to autocad. but when i try to do this, the table is not correctly import. Im using paste special command and past to link. if i paste my file excel, image and other formats, i can not plot my draw. i attach my excel file.
Note: i found a software that name is auto table. but its 150$. we don't want to buy an other software.
View 6 Replies
View Related
