total pipe length

var !pipes coll all pipe where matchwild(NAME of site,'*PIPE-JLE-ROS*') eq TRUE

--!pipes = !!collectallfor(|PIPE|,||,!!ce)


!output = array()


do !pipe values !pipes


!len = 0

!branches = !!collectallfor(|BRAN|,||,!pipes)

q var !branches

return


do !bran values !branches


!len = !len + !bran.cllen


enddo


!output.append(!pipe.name & | Length: | & !len )


enddo


q var !output

i want this as a report in excel

[COLOR="silver"]- - - Updated - - -[/COLOR]

[COLOR=#333333]q var !branches[/COLOR]

[COLOR=#333333]return

this is to be deleted a just doing trials on it [/COLOR]

var !pipes coll all pipe where matchwild(NAME of site,'*PIPE-JLE-ROS*') eq TRUE

--!pipes = !!collectallfor(|PIPE|,||,!!ce)


!output = array()


do !pipe values !pipes


!len = 0

!branches = !!collectallfor(|BRAN|,||,!pipes)

q var !branches

return


do !bran values !branches


!len = !len + !bran.cllen


enddo


!output.append(!pipe.name & | Length: | & !len )


enddo


q var !output

i want this as a report in excel

[COLOR="silver"]- - - Updated - - -[/COLOR]

[COLOR=#333333]q var !branches[/COLOR]

[COLOR=#333333]return

this is to be deleted a just doing trials on it [/COLOR]