Field Work

[Barry Clark]

I have a sprinkler head legend that has area totals and then a grand total. I want the the block to evaluate the area totals and calculate the grand total. I understand how to get fields to show attribute values but it only returns the default value while in a block. Also, when I try to get a sum, it is asking for cells.... which I don't have.

Any ideas how I can get around this?

[Barry Clark]

Did I come up with a hard one or is this just impossible?

[Alan Cullen]

Barry.....

Could simply be that no-one really understands your question...(I couldn't)

How about you have a re-think, and re-word it......:)

[dbroada]

Had I typed a bit quicker I would have said much the same as Alan.

[Barry Clark]

What I have is a sprinkler head legend that is used to show sprinkler head counts. The sprinkler head counts are made up of area totals and then, finally, a grand total which is the the sum of the area totals. The totals are all attributes in a block.

Now, what I have been trying to do is to get the grand total to be calculated from the area totals.

I figured that maybe I could do it with fields. I have been able to get fields to reference attributes. However, if the fields are in the block where I want them, they do not return anything other than the default value of that attribute.

So, my first question is how can I get a field to return an attribute value while it is in an attributed block?

[Alan Cullen]

I'm still a bit (a lot) confused......are you a landscape architect?

I'm assuming you have spinklers set out on a lawn.....yes/no?????

you want the total area of spinkler coverage....yes/no????

I assume there is an overlap in the coverage from sprinkler to spinkler........yes/no????

No one can help you because we are all confused.......sorry, mate......:(

[Barry Clark]

Fire protection sprinklers.

What I am talking about is the number of heads. When a building is protected by sprinklers, the sprinkler heads are fed in systems. You can have a building with only 1 system or you can go as high 10 or more. Each system will have a number of heads and it will vary from project to project. What I am talking about is to be able to enter in the number of heads per system and have a total comprised of each system total be calculated by a field or however. I thought this was something I could acheive through RTEXT but someone recommended fields to accomplish this.

Better?

[ASMI]

I do not know where you are. However installation of sprinkler systems is regulated by the certain standards. In the Europe it is EN 12845 "Fixed Firefighting Systems Automatic Sprinkler Systems Design, Installation and Maintenance" and in America standards NFPA (National Fire Protection Assotiation) and California Fire Marshal (don't remember exact numbrs), is also insurance companies standarts. Exist precalculated (requre count pessure loses in certain system points) and fully calculated systems (fully calculated is possible only with of the certificated program). The area of an irrigation of everyone sprinkler heads influences as pressure and the charge of a source of water, power of the the pump and hydraulic losses (geometrical and on pipes fittings). Calculation depending on a class of rooms, for example hotels according to EN 12845 concern to class OH-1 (Ordinary Hazard 1) and requre intensity of 5 mm per minute on the area 72 sq. m (12 sq. m. per one standard K=80 head at rated pressure). Read Standards, learn hydravlic calculations and other inportant rules...

[dbroada]

You can do something similar with a table. Create a one column table and in each cell use the "Insert Field" method and select an attribute within a block. Make the final cell =A1 + A2 + etc. As the values within the blocks are changed a regen will recalculate the sum in the table.

[Barry Clark]

You can do something similar with a table. Create a one column table and in each cell use the "Insert Field" method and select an attribute within a block. Make the final cell =A1 + A2 + etc. As the values within the blocks are changed a regen will recalculate the sum in the table.Right. Without more work than we have time to do, the tables- as I know them- are too cumbersome. I am wanting to get my block to act like a table.

[Barry Clark]

I do not know where you are. However installation of sprinkler systems is regulated by the certain standards. In the Europe it is EN 12845 "Fixed Firefighting Systems Automatic Sprinkler Systems Design, Installation and Maintenance" and in America standards NFPA (National Fire Protection Assotiation) and California Fire Marshal (don't remember exact numbrs), is also insurance companies standarts. Exist precalculated (requre count pessure loses in certain system points) and fully calculated systems (fully calculated is possible only with of the certificated program). The area of an irrigation of everyone sprinkler heads influences as pressure and the charge of a source of water, power of the the pump and hydraulic losses (geometrical and on pipes fittings). Calculation depending on a class of rooms, for example hotels according to EN 12845 concern to class OH-1 (Ordinary Hazard 1) and requre intensity of 5 mm per minute on the area 72 sq. m (12 sq. m. per one standard K=80 head at rated pressure). Read Standards, learn hydravlic calculations and other inportant rules...Yes. We use NFPA. What I am wanting to do is to get a block to act like a field doing simple math and no more.

[dbroada]

Right. Without more work than we have time to do, the tables- as I know them- are too cumbersome. I am wanting to get my block to act like a table.I haven't found a way of doing that.

[ASMI]

I use to draw fire sprinkler systems SprinkCAD 3D for AutoCAD program, which also make hydravlic calculations and equpment specifications. But maybe simple block counter can help you:


(defun c:blc(/ blSet filLst cItm)

(defun namesExtract(selSet)
(mapcar '(lambda(x)(assoc 2 x))
(mapcar 'entget(vl-remove-if 'listp
(mapcar 'cadr(ssnamex selSet)))))
); end of namesExtract

(princ "\n<<< Select sample blocks to count >>> ")
(if(setq blSet(ssget '((0 . "INSERT"))))
(progn
(setq filLst(append(list '(0 . "INSERT"))(list '(-4 . "<OR"))
(namesExtract blSet)(list '(-4 . "OR>"))))
(princ "\n<<< Specify area(s) to count >>> ")
(if(setq blSet(ssget filLst))
(progn
(setq nameLst(namesExtract blSet))
(princ "\n========== COUNT REPORT ==========")
(while nameLst
(setq curLen(length nameLst))
(princ(strcat "\n" (cdar nameLst) " "
(itoa(- curLen(length(setq nameLst
(vl-remove(car nameLst)nameLst)))))))
); end while
(princ "\n=========== END REPORT ===========\n")
(textscr)
); end progn
); end if
); end progn
); end if
(princ)
); end of c:blc

It's more fast than to use QSelect...