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 RepliesI 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.
Is there a way to force the table and table text height to stay constant despite the scale? I can do it for Point Label Styles with an Expression. But in 2011 there is no way to build an expression for a table style.
I want to create tables in the drawing where the points are and then plot them from a drawing they're Xrefed in to. The tables are too small but zooming in doesn't make them any bigger because the scale of the viewport changes and they adjust.
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 a Civil 3D AECC table that I want to use in Excel but these entities can't be copied and pasted. I have exploded it a few time to get simple lines and text and want to convert these into an AutoCAD table for export to Excel.
I have searched forums and have found a few lisp routines (e.g. maketable.lsp at [URL]) but they don't work.
IDSP Premium 2014 (mainly Civil 3D 2014 UKIE SP1 & Infraworks with some limited 3ds Max Design)
Win 7 Pro x64, 256Gb SSD, 300Gb 15,000 rpm HDD
16Gb Ram Intel Xeon CPU E5-1607 0 @ 3.00GHz (4 CPUs), ~3.0GHz
NVIDIA Quadro 4000, Dual 27" Monitor, Dell T3600
When I click on formula cell (on QTO manager) C3D ask me for a name & path for the formula file. Ok.
I would expect the formula editor dialog box but I see nothing ...
If a do click or couble click I have the same peticion "Choose a file for formula".....
Civil 3D (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?
What is the formula used to find the value civil3d pave, base and subbase? Value of what is needed to calculate it? what parameter values obtained from the lane and shoulders?
View 6 Replies View RelatedI want to know if you can link AutoCad tables to other Autocad tables on different layouts. Say I have ten sheets, each with a table for quantities of pipe length, and one sheet with a total of all quantities. Can I link cells from each separate layout sheet to the main table sheet, so that I can add them all for project totals?
View 3 Replies View Relatedit is possible to create text and then attach a formula to it to change it.
For example:I want to be able to draw or pick a line and if the line is less than X ft than "Say this" if the line is greater than X ft than "Say that"
Is there a way to setup vertical alignment of text in a cell for the entire table, when using Table Tool? It is possible for a single cell, but when selecting a table (or multiple cells) this option is not available.
View 5 Replies View RelatedI'm using Autocad LT 2012 on Windows 7 Professional. I'm also using Microsoft Office Professional 2010. My question is how to change the colour of all cells in a table at once. For example, I copy a section of an Excel spreadsheet, then use "Paste Special", "Autocad LT entities", to paste it into AutoCad. I would like all the text to be coloured "by layer". If I select all the text and go to "properties", the text colour is set to "by block". I can change this to "by layer", but nothing changes. The only way I can seem to get it to change is by selecting the text in an individual cell, highlighting it, and then changing the colour in the text formatting toolbar. I have to then do this for each individual cell. Is there a way to change them all at once?
View 3 Replies View RelatedHow do you set the text style for cells in a table? I used to be able to set the title row, head row and data row text style in vba. In vb.net I tried using <tablestyle>.SetTextStyle but it is asking me for an ID.
View 6 Replies View Relatedi 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 RelatedI've found nearly everything I need to draw my tables, but cannot find how to set the text styles for the Title, Header and Data cells.
There must be a way, but it is hidden under an obscure method or property title which I can't identify or find on the internet or in the Object Browser.
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 RelatedHow can you get the header text in a table to wrap to the next line?
View 3 Replies View RelatedMost people that I work with don't use autocad map, they use the regular Autocad. So they can not access the table data of my vectors. Is it possible to transform the table data that I choose and place it as text in the appropriate place ?
View 2 Replies View RelatedI am using data extraction and data linking to an excel file to count blocks and list details. I need to be able to update automatically and the most trouble I have been having is that I need the images of the blocks to come out in the table as well. so far only have been able to get the text data to come out in the table.
View 3 Replies View RelatedCreating a CTB file to mimic a Microstation pen table? I have a client supplied *.tbl (an intergraph pen table file I believe) and how to generate a CTB that will behave similarly (ie. plot nearly the same)..
I can open the *.tbl file in a text editor and it just looks like a bunch of "if, then" statements related to line weights and pattern files....
I have already created a template with the same layers/levels, colors, linewights, etc... (and can convert everything to dgns), but now I need to figure out how to get similar plotted results from both sets of drawings (the dwg and the dgn..)
I create Table using Autocad .net api C#.
var table = new Table();
In single text(class DBText), change text width of the property - WidthFactor.
How change text width in table cell using autocad .net api C#?
Is there any command in autocad to LINK TEXT TO SCHEDULE TABLE. I have door & windows in my plan I have given attribute numbers to them as per sizes like for
800mm -w1
900mm-w2
1200mm-w3 etc...
I have made window opening schedule table , when ever i add or delete one window form schedule i have to change the order. like if i delete 900mm window schedule will be.
800mm- w1
1200mm- w2 etc....
so I am looking for a command when ever i change my schedule table my attribute numbers should also change.
I am looking for assitance with the VB code to change the text style within a custom table when it is created from a VB standalone program. I am using Inventor 2013 and VB 2010 Express.
I have a customtable that is created within a .idw, and I would like to have the data cells set to "Table_Cells" style that I have created. I cannot find anything in the help file with a sample code to build off.
I figure it's got to be something with oCustomTable.DataTextStyle but beyond that I am lost.This is what I have, and VB is kicking it back in my face.
Dim oTextStyle As TextStyleoTextStyle = oCustomTable.DataTextStyle.StyleType("Table_Cells")
Error 2 'Public ReadOnly Property StyleType As Inventor.StyleTypeEnum' has no parameters and its return type cannot be indexed.
is it possible to import a microsoft excel table to auto cad and have it be autocad lines and text? it is a rather large table and would save me alot of time if i didnt have to redraft it.
View 4 Replies View RelatedI'm preparing plans for individual land owners. I know I need to filter parcels "by hand", center, zoom, scale etc. I'm using labels to get parcels numbers on the plan but I have to add name into title block. I don't want to use feature labels because concat function does not work (I need to show parcel number) plus the name I need to put on is quite long (it doesn't fit in the drawing).
My question is: Is there a way to put text into drawing / title block from attached table or from feature properties of shp or sdf files?
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?
How can I copy existing (in the drawing) text / mtext into a table cell? I found programming solutions but I want to do it manually (one time job).
I tried Copy / Paste but it does not seem to work.
I working with one schedule dwg by using table command. I could not able to edit text in a cell while i double click, inside the table cell. But i can edit by using right click method. before it (double click) was working. now i dont know what happend.
View 3 Replies View RelatedI am using C3D 2012 and i know how to create a table showing volumes for different elevation ranges with different colours, but how to show the total cut or fill for the volume surface in the same table so that you dont have to manually add up all of the cuts or fills? or have to display only two ranges?
View 1 Replies View RelatedI am trying to create a line table. Here are the steps I am following :
First I label the lines I have drawn using a line label type for example Bearing over Distance, then I am going to the Annotate tab, Add Tables, Add Line and Curve and once I get to that dialog box I select my table style that I have already created and the label style I chose to label the line and click on the "apply" box and then "ok" and I see the labels such as L1, L2, etc. and all looks good, except now when I go to use that label style Bearing over distance to label another line, it labels the line with the tags and not the bearing and distance, its like the style is now defaulted to labeling tags and not bearing and distance anymore.