What I really want to do is on our fire alarm blocks we have 3 different attributes one for the address, the candela and one for misc info. I want to make an attribute that takes the number from the candela (15,30,75or 110) and change a different attribute to a value depending on which candela we use (such as 15=.078, 30=.113, 75=.195 or 110=.259). But I dont want the .078,.113,.195,.259 to print out on paper, I want to export block information exell file so I can add up all values. I hope I made this clear enough.
>> But I dont want the .078,.113,.195,.259 to print out on paper, I want to export block information exell file
When you export the attribute-values to excel, why don't you make the formula (like 15=.078, 30=.113 ...) directly in Excel (as you don't need these values in the drawing)?
- alfred -
This uses a lookup table and a distance parameter. One attribute reads the distance and a second attribute reads the lookup, the lookup table uses your values. You can make the attribute invisible but they are still available to the data extraction