Spool ( marked piece ) quantity from Design?

I too have this same question of needing spool counts. We don't have Spooler set up on our model, but our isometrics generate marked and listed spools on our isos. The workaround we used before was to write the whole isometric matlist/MTO to a text file and parse from there, but I don't think the designer saved that report, and I can't figure out how to reproduce it.

So here is the code I use to count spool pieces now. I hope this helps.

---------------------
--START WITH 0 MARK PIECES
!MK = 0
VAR !P COLL ALL BRAN FOR PIPE
DO !PA INDEXES !P
$(
TO COUNT MARK PIECES PROPERLY YOU HAVE TO EXCLUDE THE ATTAS, PIPE AND MDS ITEMS
$)
   VAR !BM COLL ALL BRAN MEM WITH TYPE NEQ 'TUBI' AND TYPE NEQ 'ATTA' AND NOT MATCHW (NAME OF SPRE, '*MDS*') FOR $!P[$!PA]
   IF ARRAYSIZE(!BM) GT 1 THEN
       IF SHOP OF $!BM[1] EQ TRUE AND !MK EQ 0 THEN
       --LOGIC. IF THE FIRST COMPONENT IS SHOP TRUE, THEN THERE IS 1 MARK PIECE
       !MK = 1
       ENDIF
       DO !BMA FROM 2 TO ARRAYSIZE(!BM)
           !BMP = $!BMA - 1
           IF SHOP OF $!BM[$!BMA] EQ TRUE AND SHOP OF $!BM[$!BMP] EQ FALSE THEN
           --LOGIC: IF THERE IS A POINT WHERE IT TRANSITIONS FROM SHOP TRUE TO SHOP FALSE, THEN INCREASE THE MARK PIECE COUNT BY 1
           !MK = !MK + 1
           ENDIF
       ENDDO
   ENDIF
ENDDO
$P Estimated number of Spools: $!MK
------------------

[QUOTE=cekeys1;98291]So here is the code I use to count spool pieces now. I hope this helps.

------------------
$P Estimated number of Spools: $!MK
------------------

Thanks for the reply. I tested it out and it was only one out of five for matching the number of spools marked on our isos, however.

I figured out the workaround we had used previously for anyone who is interested.

I copied and altered our default OPT file to set Matlistfile as seen below.

MatlistFile "C:\matlist.txt" OVERWRITE

Run this OPT file in Isodraft on a detail list of the pipes you want to report on. Import the text file to to excel (I delimited by spaces, but select however is appropriate for the formatting of the spool section of you OPT file) and use a macro to search and record each cell with SPL in the string, and remove duplicates. (Duplicate MTOs are sporadically showing up in the generated text file for some reason.)

It seems like a pretty backwards way to do it, but it avoids the Spooler issue and will be 100% accurate to how your spool numbers are generated by isodraft.

[QUOTE=cary_kriston;97426]hi all,

I had a question regarding spool mark numbers?

the spool mark number is by its default starting from "1". is it possible to change like "01".

thanks
I have the same question, I want to define piece no of pipe in spool module, rename it from <1> to <1-A> (for example) and mark the new name on screen. Any one can do this, plz help me.