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 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.
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 wanted to know if their was an easier way to make duplicate shapes on a drawing. I am doing a survey plat and need to make at least 66 circles with a 2.5 radius on each corner of the lot. Using copy on autocad does not work since it will place the circles off center.
View 7 Replies View RelatedI know there is a command for making a hole on a wall or a facade without compromising the finishes on the wall.
eg:i have a wall now drawn out, with all the details of the wall done, but i realise now have to make a window out of the wall i have hatched, but i do not want to create a rec and trim it. as i may have to change the window position again.
My boss gave me a drawing to make some changes on a particular block; however, every time I try to insert the block, it always insert the block in Paper Space even though I'm in Model Space.
Is there any way to change that insertion point? I want to insert the block in Model not in PS...
How can I convert drawings on paperspace into PDFs and DWFs with the correct scale? I measured everything on paperspace and it's right; but if I convert them to PDFs and DWFs everything srinks a little and the scale doesn't match at all. What settings or ways to match the scale into what it's suppose to be to convert it to PDFs and DWFs?
View 4 Replies View RelatedIs it possible to enter Excel formulaes eg: =if(a1 = 0; "yes"; "no") into table cells?
I tried doing it, but I only got number symbols as the result (#####).
I need to know if I can import an excel formula for a Von Karmen rocket nosecone and then model it. I do not know how to do 3D modeling only 2D. Is this possible? I would like to do the model isometric if possible. I also have some questions about doing an isometric drawing, but i'll try to figure that out on my own this week at home.
View 7 Replies View Relatedis it possible to draw a dodecahedron with a formula?
View 2 Replies View Relatedi 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 RelatedThere is a problem with my AutoCAD installation that is not allowing me to format my field if that field is a formula. The default unit is Architectural, and most times that is not what I need. I have uninstalled, and reinstalled, I have reinstalled only, and I have gone through and deleted all references to my AutoCAD 2013 installation before reinstalling. This is a huge issue as I am building templates and I need this functionality as I automate our drawings. Where this is happening and how to fix it. I originally downloaded 2013 (Design Suite Premium) from this site through the subscrption center, so I thought it was a bad download, which it may have been, so I then ordered the physical media, which arrived today, and I tried uninstalling, deleting all traces and then reinstalling, but I get the same result. This leads me to believe that it is a problem which is stuck in the install file in my registry, and I need to delete that before reinstalling, but I don't know where it is.
I am attaching pictures of the problem area from my 2013 version where this feature does not work, and my 2011 version where it did. The picture from the 2011 version is actually of the objects field section, but I should have a very similar screen for the formula field creation in the same area of the dialog box.
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)
During design development dimensions get modified a lot. E.g. shorten something by 25mm I just edit the feature dimension by tagging on "-25" in the edit dimension box. If lots of modifications are made the dimension gets messy since all the edits are saved (e.g. 150 mm - 25 mm +1 mm -5 mm). In sketch mode, I just retype the shown dimension, but for other features like offset work planes, extrusion depth, etc, the actual value isn't even shown anywhere. Is there any easy way to replace the formula with the current dimension value without having to measure the feature?
Basically, I like being able to use the dimension entry box as my calculator, but more often then not, don't want the calculation history saved.
I am currently using a field for my elevation tags. The field reads the y-value of a line and displays the results as the elevation. Our local jurisdiction requires that we list elevations from above grade (A.G.L.) as well as from bottom of base plate. The difference is usually 6"-12".
I was wondering if I could create another field that would read the same y-value of a line, but then subtract a predetermined value (6") and display the results.
Currently we have to do the math ourselves and this leaves room for errors and is often very tedious.
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?
Is there a way to add a specific amount/length to a dimension by using a formula? For example, say I wanted to measure a length of conduit between two fittings. The clear distance between the fittings is 48" and the conduit is recessed into the fittings by 3/4" on each side. If I dimension between the fittings, normally it would read 48", but I want it to read 49-1/2" so my shop people know what length to cut.
View 9 Replies View RelatedWhere I can find an integral symbol for a calculus formula in a drawing?
View 7 Replies View Relatedwhen 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 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
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've been fighting with building a formula in a block utilizing a field from another block. I have a support steel member that once placed, will be lengthened. I need a distance from center of the pipe to the top of concrete. I created a block with a field referencing the insertion point (center of pipe) it works fine giving me this elevation. I also have another block that is the datum node. I have several fields in this block, and it is located at the bottom of the support steel plate. I am trying to create a field that takes the center of pipe elevation and subtracts the datum node elevation to get a distance. I created the formula referencing the COP elevation field and the elevation of the datum node. The information shows properly where I am building the formula, when I click evaluate, the Preview gives me ##### and when I create the datum node block that is also the output I get. I can't figure out why it won't give me the difference between the two elevation fields. I don't know what I can do differently to have that information in the datum node.
View 1 Replies View RelatedI am trying to put a field formula in an attribute value. Basically I have a block that has a attribute called QTY and it is equal to 1. I can get the object property to equal 1 with this expression:
%<AcObjProp Object(%<\_ObjId #########>%).Textstring>%
The expression above will show a value equal to 1 (as I would expect)
Lets say I have two blocks now and I have the lisp routine combine the field values to get the expression below.
%<AcObjProp Object(%<\_ObjId #########>%).Textstring>%+%<AcObjProp Object(%<\_ObjId #########>%).Textstring>%
In the attribute dialog box it will show 1+1 instead of 2. My question is how do I get it to show 2 with out opening the formula box and evaluating it?
I have also tried.
%<AcExpr(%<AcObjProp Object(%<\_ObjId #########>%).Textstring>%)+(%<AcObjProp Object(%<\_ObjId #########>%).Textstring>%)>%
and
%<AcExpr((%<AcObjProp Object(%<\_ObjId #########>%).Textstring>%)+(%<AcObjProp Object(%<\_ObjId #########>%).Textstring>%))>%
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.
I want to add a column to my parts list, which displays a value based on a formula.
Lets say i want to show the submerged weight of a part; So i need to create a column, which can use the information about a parts volume and mass to calculate its submerged weight.
An easy formula, but is this possible in Inventor (2012 Pro)?
I am looking for a formula that will allow me to generate flat layouts for screw conveyor flights.
View 9 Replies View RelatedI am trying to create a iLogic Rule that will measure the Length, Width and Thickness of a part and ut it into the custom fields we have. I am having a hard time remembering how to get it to do it from the assembly level. I want to run this on the assembly and have it populate all the parts inside of it. The code below will do it for a part but what is it I add to get it to drill down into the assembly?
iProperties.Value("Custom", "THICKNESS")=Measure.ExtentsHeight
iProperties.Value("Custom", "WIDTH")=Measure.ExtentsWidth
iProperties.Value("Custom", "LENGTH")=Measure.ExtentsLength
Then I want to add this formula to the Stock Number iProperty = <Length> X <Width> I can get it to add the values but I can not get it to add the formula to the stock number.
We have a family that errors when certain values are hit. Its realated to Automatic Sketch Dimension reassociating with work planes when two workplans over lap... Anyway, the QA team knows about this.
The problem I have is that I have an IF statement to trigger an generic error message when these two rare conditions are met. I would rather a pop up window explaining what thy can not do. "Position of legs from ends can not equal half total length" and an OK button.
Is there a "say" style command for revit formulas?
I'm facing a problem dealing with visibility formulas... My situation that im dealing with is, I have 2 yes/no visibility parameters, one that is called Right side clearance and another one named Left side clearance. I want to create another yes/no visibility parameter that's called Clearance. I want to link the Right and Left clearance parameter to the Clearance parameter where if it is off, then there will be nothing that shows.. But if I want it on then I would have to select either right or left without them both showing up?
View 4 Replies View RelatedFor a project, I'm needing the mathematical equations/formulas/matrices of a vector. Vectors are all essentially mathematical... thingies so is there some way that I can get the mathematical calculations that are used to make up a vector object in Illustrator? Or any third party program or script that can pull these formulas for me?
View 13 Replies View Relatedi want to create a sketch line for a sweep where the radius of the curve varies.. i don't want to use a spline or piece together arcs.. something about distance and radius along the line.. is there a formula and can this be done in revit?
View 1 Replies View Related