I have been working on creating a BOM with formula based columns that include all items in a view file. This BOM {schedule} automaticaly updates, and includes all new items
I have used an if then else statement to control what is placed in the cell, and 3 other DataSetDefinitions to Concatenate Text, Length, and Style for each outcome outlined in the if then statement.
Here is the problem...
I've concatinated [text][length][style][text]
(FC ) (6'-0") (12 Inch D.I. Pipe) (Guaged)
FC 72 12 INCH DI MECH JOINT-TYTON JOINT CEMENT MORTAR LINED ASPHALT COATED (GUAGED)
However.. the [Length] posts in inches.. even more confusing to the client and contractor is the decimal values 17.937 inches.. they expect 1'-5 15/16" the only value that drives them more insane is feet in decimal 1.49475 Feet. They don't care about automated schecules and CAD issues, they just want the length in a term they understand, and think we're idiots if we can't type in the correct format of the length.
So if you have any ideas how to correct this I'd like to know... I have great difficulty understanding where to set, and how to control the formatting of the data in the DataSetDefinitions window in the style manager.. and or schedule editor.
See this file.
http://dl.dropbox.com/u/20790817/testing09.dwgI also attempted to use Chr() to insert ( " ) ( ' ) and ( - )
See this file
http://dl.dropbox.com/u/20790817/testing07.dwgAny help you could provide will be greatly appreciated.