Consulting

Page 1 of 2 1 2 LastLast
Results 1 to 20 of 22

Thread: XML Source data format change, Macro's no longer working

  1. #1
    VBAX Regular
    Joined
    May 2015
    Posts
    34
    Location

    XML Source data format change, Macro's no longer working

    Hi,
    I need your expert knowledge once again.

    My company has changed the way we log our ranges due to internal reports and now the report which saved me 30 mins each day has stopped working. I have attached a sample working workbook, an original XML file and a new one. Hopefully someone can get me the desired output with the new file.

    In the attached workbook there are two sheets named Walk Off Old and Import Old for your reference

    When the original data source was imported, It contained 3 Group Names

    STORE
    WAREHOUSE
    GEORGE

    All the ranges for STORE would be added to sheet "Walk Off" starting at B9 below the Shop floor Heading

    WAREHOUSE ranges at J9
    GEORGE at J30

    Example Original XML

    <SoftwareID Value="7214">  <GroupRange GroupName="STORE" GroupDescription="STORE">
        <TagRange TagRangeName="KIOSK" TagRangeDescription="" TagRangeFrom="3101" TagRangeTo="3109" />
        <TagRange TagRangeName="TILLS" TagRangeDescription="" TagRangeFrom="3110" TagRangeTo="3125" />
        <TagRange TagRangeName="MAGS" TagRangeDescription="" TagRangeFrom="3126" TagRangeTo="3130" />
        <TagRange TagRangeName="FOOD TO GO" TagRangeDescription="" TagRangeFrom="3131" TagRangeTo="3134" />
        <TagRange TagRangeName="FOYER" TagRangeDescription="" TagRangeFrom="3135" TagRangeTo="3141" />
        <TagRange TagRangeName="FRESH" TagRangeDescription="" TagRangeFrom="3142" TagRangeTo="3189" />
        <TagRange TagRangeName="FROZEN" TagRangeDescription="" TagRangeFrom="3190" TagRangeTo="3200" />
        <TagRange TagRangeName="BWS" TagRangeDescription="" TagRangeFrom="3201" TagRangeTo="3225" />
        <TagRange TagRangeName="GROCERY" TagRangeDescription="" TagRangeFrom="3226" TagRangeTo="3274" />
        <TagRange TagRangeName="HEALTH &amp; BEAUTY" TagRangeDescription="" TagRangeFrom="3275" TagRangeTo="3304" />
        <TagRange TagRangeName="GEORGE" TagRangeDescription="" TagRangeFrom="3305" TagRangeTo="3312" />
        <TagRange TagRangeName="GM" TagRangeDescription="" TagRangeFrom="3313" TagRangeTo="3321" />
        <TagRange TagRangeName="GROCERY2" TagRangeDescription="" TagRangeFrom="3322" TagRangeTo="3392" />
        <TagRange TagRangeName="BIBC" TagRangeDescription="" TagRangeFrom="3393" TagRangeTo="3401" />
        <TagRange TagRangeName="GROCERY3" TagRangeDescription="" TagRangeFrom="3402" TagRangeTo="3437" />
        <TagRange TagRangeName="TOPSTOCKS" TagRangeDescription="" TagRangeFrom="5331" TagRangeTo="5543" />
      </GroupRange>
      <GroupRange GroupName="WAREHOUSE" GroupDescription="">
        <TagRange TagRangeName="CHILLED" TagRangeDescription="" TagRangeFrom="101" TagRangeTo="101" />
        <TagRange TagRangeName="FROZEN." TagRangeDescription="" TagRangeFrom="102" TagRangeTo="102" />
        <TagRange TagRangeName="BWS RACKIG" TagRangeDescription="" TagRangeFrom="103" TagRangeTo="103" />
        <TagRange TagRangeName="RACKING" TagRangeDescription="" TagRangeFrom="104" TagRangeTo="111" />
        <TagRange TagRangeName="CAGES" TagRangeDescription="" TagRangeFrom="112" TagRangeTo="118" />
        <TagRange TagRangeName="TOTES" TagRangeDescription="" TagRangeFrom="119" TagRangeTo="120" />
      </GroupRange>
      <GroupRange GroupName="GEORGE" GroupDescription="">
        <TagRange TagRangeName="MENS" TagRangeDescription="" TagRangeFrom="1004" TagRangeTo="1100" />
        <TagRange TagRangeName="WOMENS" TagRangeDescription="" TagRangeFrom="1101" TagRangeTo="1200" />
        <TagRange TagRangeName="KIDS" TagRangeDescription="" TagRangeFrom="1201" TagRangeTo="1300" />
        <TagRange TagRangeName="PACKETS" TagRangeDescription="" TagRangeFrom="1801" TagRangeTo="1899" />
      </GroupRange>
    </SoftwareID>

    The code for importing.

    Sub WRTImport()
    
    Application.ScreenUpdating = False
    
    
    Dim strUser As String
    Dim strXML_Location As String
    
    
    strXML_Location = Range("XML_Location")
    strUser = "jgribbin"
        
        
        Sheets("Import").Visible = True
        Sheets("Import").Select
    
    
        Cells.Select
        Selection.ClearContents
        'MsgBox ("clear")
    
    
        ActiveWorkbook.XmlImport URL:= _
            strXML_Location, ImportMap:=Nothing, _
            Overwrite:=True, Destination:=Range("$A$1")
    
    
    
    
    End Sub
    And adding the ranges to sheet "Walk Off"

    Sub createWalkOff()
    
    
        Application.ScreenUpdating = False
    
    
    WRTImport
    
    
    Dim strArea(90) As String
    Dim strName(90) As String
    Dim strRange(90) As String
    
    
    Dim intA As Integer
    
    
        intA = 0
    
    
        'Clear walk-off sheet
        Sheets("Walk Off").Select
        Range("B8:D35").Select
        Selection.ClearContents
        Range("J8:N20").Select
        Selection.ClearContents
        Range("J23:N27").Select
        Selection.ClearContents
        Range("J22:N22").Select
        Selection.ClearContents
        Range("J29:N39").Select
        Selection.ClearContents
        
        'Dump ranges into an array
        Sheets("Import").Select
        
        Range("B1").Select
        
        Do While ActiveCell.Value <> ""
        
        strArea(intA) = ActiveCell.Value
        strName(intA) = ActiveCell.Offset(0, 2).Value
        strRange(intA) = ActiveCell.Offset(0, 4).Value & " - " & ActiveCell.Offset(0, 5).Value
        
        intA = intA + 1
        
        ActiveCell.Offset(1, 0).Select
        
        Loop
        
        'Insert shopfloor ranges.
        Sheets("Walk Off").Select
        intA = 0
        Range("B9").Select
        
        Do While strArea(intA) <> ""
        
            If strArea(intA) = "STORE" Then
                ActiveCell.Value = strName(intA)
                ActiveCell.Offset(0, 1).Value = strRange(intA)
                
        ActiveCell.Offset(1, 0).Select
        
            End If
        intA = intA + 1
        
        Loop
        
        'Insert Warehouse ranges.
        Sheets("Walk Off").Select
        intA = 0
        Range("J9").Select
        
        Do While strArea(intA) <> ""
        
            If strArea(intA) = "WAREHOUSE" Then
                ActiveCell.Value = strName(intA)
                ActiveCell.Offset(0, 1).Value = strRange(intA)
                
        ActiveCell.Offset(1, 0).Select
        
            End If
        intA = intA + 1
        
        Loop
    
    
        'Insert George ranges.
        Sheets("Walk Off").Select
        intA = 0
        Range("J30").Select
        
        Do While strArea(intA) <> ""
        
            If strArea(intA) = "GEORGE" Then
                ActiveCell.Value = strName(intA)
                ActiveCell.Offset(0, 1).Value = strRange(intA)
                
        ActiveCell.Offset(1, 0).Select
        
            End If
        intA = intA + 1
        
        Loop
    
    
        Sheets("Walk Off").Select
        
        'printcurrent
        Sheets("Import").Visible = False
        Sheets("Main").Select
        
    End Sub
    The new data contains 7 group names

    CHECKOUTS
    FRESH
    GEORGE
    GM
    GROCERY
    VARIANCE DEPARTMENTS
    WAREHOUSE

    Although all the additional groups i still one require a 3 way split on the walk off sheet.

    WAREHOUSE and GEORGE are as before starting at J9 / J30

    All other GROUPS ranges would appear below the shop floor header starting at B9

    Note the data when imported looks totally different and might need importing differently, all this is way over my head

    NEW XML DATA

    <SoftwareID Value="7213">  <GroupRange GroupName="GEORGE" GroupDescription="">
        <TagRange TagRangeName="TOTES DOWNSTAIRS" TagRangeDescription="" TagRangeFrom="22" TagRangeTo="73" DefaultCountTypeID="-1">
          <TagInfo TagNo="22" CountTypeID="-1" />
          <TagInfo TagNo="23" CountTypeID="-1" />
          <TagInfo TagNo="24" CountTypeID="-1" />
          <TagInfo TagNo="25" CountTypeID="-1" />
          <TagInfo TagNo="26" CountTypeID="-1" />
          <TagInfo TagNo="27" CountTypeID="-1" />
          <TagInfo TagNo="28" CountTypeID="-1" />
          <TagInfo TagNo="29" CountTypeID="-1" />
          <TagInfo TagNo="30" CountTypeID="-1" />
          <TagInfo TagNo="31" CountTypeID="-1" />
          <TagInfo TagNo="32" CountTypeID="-1" />
          <TagInfo TagNo="33" CountTypeID="-1" />
          <TagInfo TagNo="34" CountTypeID="-1" />
          <TagInfo TagNo="35" CountTypeID="-1" />
          <TagInfo TagNo="36" CountTypeID="-1" />
          <TagInfo TagNo="37" CountTypeID="-1" />
          <TagInfo TagNo="38" CountTypeID="-1" />
          <TagInfo TagNo="39" CountTypeID="-1" />
          <TagInfo TagNo="40" CountTypeID="-1" />
          <TagInfo TagNo="41" CountTypeID="-1" />
          <TagInfo TagNo="42" CountTypeID="-1" />
          <TagInfo TagNo="43" CountTypeID="-1" />
          <TagInfo TagNo="44" CountTypeID="-1" />
          <TagInfo TagNo="45" CountTypeID="-1" />
          <TagInfo TagNo="46" CountTypeID="-1" />
          <TagInfo TagNo="47" CountTypeID="-1" />
          <TagInfo TagNo="48" CountTypeID="-1" />
          <TagInfo TagNo="49" CountTypeID="-1" />
          <TagInfo TagNo="50" CountTypeID="-1" />
          <TagInfo TagNo="51" CountTypeID="-1" />
          <TagInfo TagNo="52" CountTypeID="-1" />
          <TagInfo TagNo="53" CountTypeID="-1" />
          <TagInfo TagNo="54" CountTypeID="-1" />
          <TagInfo TagNo="55" CountTypeID="-1" />
          <TagInfo TagNo="56" CountTypeID="-1" />
          <TagInfo TagNo="57" CountTypeID="-1" />
          <TagInfo TagNo="58" CountTypeID="-1" />
          <TagInfo TagNo="59" CountTypeID="-1" />
          <TagInfo TagNo="60" CountTypeID="-1" />
          <TagInfo TagNo="61" CountTypeID="-1" />
          <TagInfo TagNo="62" CountTypeID="-1" />
          <TagInfo TagNo="63" CountTypeID="-1" />
          <TagInfo TagNo="64" CountTypeID="-1" />
          <TagInfo TagNo="65" CountTypeID="-1" />
          <TagInfo TagNo="66" CountTypeID="-1" />
          <TagInfo TagNo="67" CountTypeID="-1" />
          <TagInfo TagNo="68" CountTypeID="-1" />
          <TagInfo TagNo="69" CountTypeID="-1" />
          <TagInfo TagNo="70" CountTypeID="-1" />
          <TagInfo TagNo="71" CountTypeID="-1" />
          <TagInfo TagNo="72" CountTypeID="-1" />
          <TagInfo TagNo="73" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="TOTES DOWNSTAIRS." TagRangeDescription="" TagRangeFrom="205" TagRangeTo="221" DefaultCountTypeID="-1">
          <TagInfo TagNo="205" CountTypeID="-1" />
          <TagInfo TagNo="206" CountTypeID="-1" />
          <TagInfo TagNo="207" CountTypeID="-1" />
          <TagInfo TagNo="208" CountTypeID="-1" />
          <TagInfo TagNo="209" CountTypeID="-1" />
          <TagInfo TagNo="210" CountTypeID="-1" />
          <TagInfo TagNo="211" CountTypeID="-1" />
          <TagInfo TagNo="212" CountTypeID="-1" />
          <TagInfo TagNo="213" CountTypeID="-1" />
          <TagInfo TagNo="214" CountTypeID="-1" />
          <TagInfo TagNo="215" CountTypeID="-1" />
          <TagInfo TagNo="216" CountTypeID="-1" />
          <TagInfo TagNo="217" CountTypeID="-1" />
          <TagInfo TagNo="218" CountTypeID="-1" />
          <TagInfo TagNo="219" CountTypeID="-1" />
          <TagInfo TagNo="220" CountTypeID="-1" />
          <TagInfo TagNo="221" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="HANGING W/H" TagRangeDescription="" TagRangeFrom="601" TagRangeTo="647" DefaultCountTypeID="-1">
          <TagInfo TagNo="601" CountTypeID="-1" />
          <TagInfo TagNo="602" CountTypeID="-1" />
          <TagInfo TagNo="603" CountTypeID="-1" />
          <TagInfo TagNo="604" CountTypeID="-1" />
          <TagInfo TagNo="605" CountTypeID="-1" />
          <TagInfo TagNo="606" CountTypeID="-1" />
          <TagInfo TagNo="607" CountTypeID="-1" />
          <TagInfo TagNo="608" CountTypeID="-1" />
          <TagInfo TagNo="609" CountTypeID="-1" />
          <TagInfo TagNo="610" CountTypeID="-1" />
          <TagInfo TagNo="611" CountTypeID="-1" />
          <TagInfo TagNo="612" CountTypeID="-1" />
          <TagInfo TagNo="613" CountTypeID="-1" />
          <TagInfo TagNo="614" CountTypeID="-1" />
          <TagInfo TagNo="615" CountTypeID="-1" />
          <TagInfo TagNo="616" CountTypeID="-1" />
          <TagInfo TagNo="617" CountTypeID="-1" />
          <TagInfo TagNo="618" CountTypeID="-1" />
          <TagInfo TagNo="619" CountTypeID="-1" />
          <TagInfo TagNo="620" CountTypeID="-1" />
          <TagInfo TagNo="621" CountTypeID="-1" />
          <TagInfo TagNo="622" CountTypeID="-1" />
          <TagInfo TagNo="623" CountTypeID="-1" />
          <TagInfo TagNo="624" CountTypeID="-1" />
          <TagInfo TagNo="625" CountTypeID="-1" />
          <TagInfo TagNo="626" CountTypeID="-1" />
          <TagInfo TagNo="627" CountTypeID="-1" />
          <TagInfo TagNo="628" CountTypeID="-1" />
          <TagInfo TagNo="629" CountTypeID="-1" />
          <TagInfo TagNo="630" CountTypeID="-1" />
          <TagInfo TagNo="631" CountTypeID="-1" />
          <TagInfo TagNo="632" CountTypeID="-1" />
          <TagInfo TagNo="633" CountTypeID="-1" />
          <TagInfo TagNo="634" CountTypeID="-1" />
          <TagInfo TagNo="635" CountTypeID="-1" />
          <TagInfo TagNo="636" CountTypeID="-1" />
          <TagInfo TagNo="637" CountTypeID="-1" />
          <TagInfo TagNo="638" CountTypeID="-1" />
          <TagInfo TagNo="639" CountTypeID="-1" />
          <TagInfo TagNo="640" CountTypeID="-1" />
          <TagInfo TagNo="641" CountTypeID="-1" />
          <TagInfo TagNo="642" CountTypeID="-1" />
          <TagInfo TagNo="643" CountTypeID="-1" />
          <TagInfo TagNo="644" CountTypeID="-1" />
          <TagInfo TagNo="645" CountTypeID="-1" />
          <TagInfo TagNo="646" CountTypeID="-1" />
          <TagInfo TagNo="647" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="RAILS W/H" TagRangeDescription="" TagRangeFrom="648" TagRangeTo="685" DefaultCountTypeID="-1">
          <TagInfo TagNo="648" CountTypeID="-1" />
          <TagInfo TagNo="649" CountTypeID="-1" />
          <TagInfo TagNo="650" CountTypeID="-1" />
          <TagInfo TagNo="651" CountTypeID="-1" />
          <TagInfo TagNo="652" CountTypeID="-1" />
          <TagInfo TagNo="653" CountTypeID="-1" />
          <TagInfo TagNo="654" CountTypeID="-1" />
          <TagInfo TagNo="655" CountTypeID="-1" />
          <TagInfo TagNo="656" CountTypeID="-1" />
          <TagInfo TagNo="657" CountTypeID="-1" />
          <TagInfo TagNo="658" CountTypeID="-1" />
          <TagInfo TagNo="659" CountTypeID="-1" />
          <TagInfo TagNo="660" CountTypeID="-1" />
          <TagInfo TagNo="661" CountTypeID="-1" />
          <TagInfo TagNo="662" CountTypeID="-1" />
          <TagInfo TagNo="663" CountTypeID="-1" />
          <TagInfo TagNo="664" CountTypeID="-1" />
          <TagInfo TagNo="665" CountTypeID="-1" />
          <TagInfo TagNo="666" CountTypeID="-1" />
          <TagInfo TagNo="667" CountTypeID="-1" />
          <TagInfo TagNo="668" CountTypeID="-1" />
          <TagInfo TagNo="669" CountTypeID="-1" />
          <TagInfo TagNo="670" CountTypeID="-1" />
          <TagInfo TagNo="671" CountTypeID="-1" />
          <TagInfo TagNo="672" CountTypeID="-1" />
          <TagInfo TagNo="673" CountTypeID="-1" />
          <TagInfo TagNo="674" CountTypeID="-1" />
          <TagInfo TagNo="675" CountTypeID="-1" />
          <TagInfo TagNo="676" CountTypeID="-1" />
          <TagInfo TagNo="677" CountTypeID="-1" />
          <TagInfo TagNo="678" CountTypeID="-1" />
          <TagInfo TagNo="679" CountTypeID="-1" />
          <TagInfo TagNo="680" CountTypeID="-1" />
          <TagInfo TagNo="681" CountTypeID="-1" />
          <TagInfo TagNo="682" CountTypeID="-1" />
          <TagInfo TagNo="683" CountTypeID="-1" />
          <TagInfo TagNo="684" CountTypeID="-1" />
          <TagInfo TagNo="685" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="UPSTAIRS RAILS" TagRangeDescription="" TagRangeFrom="686" TagRangeTo="724" DefaultCountTypeID="-1">
          <TagInfo TagNo="686" CountTypeID="-1" />
          <TagInfo TagNo="687" CountTypeID="-1" />
          <TagInfo TagNo="688" CountTypeID="-1" />
          <TagInfo TagNo="689" CountTypeID="-1" />
          <TagInfo TagNo="690" CountTypeID="-1" />
          <TagInfo TagNo="691" CountTypeID="-1" />
          <TagInfo TagNo="692" CountTypeID="-1" />
          <TagInfo TagNo="693" CountTypeID="-1" />
          <TagInfo TagNo="694" CountTypeID="-1" />
          <TagInfo TagNo="695" CountTypeID="-1" />
          <TagInfo TagNo="696" CountTypeID="-1" />
          <TagInfo TagNo="697" CountTypeID="-1" />
          <TagInfo TagNo="698" CountTypeID="-1" />
          <TagInfo TagNo="699" CountTypeID="-1" />
          <TagInfo TagNo="700" CountTypeID="-1" />
          <TagInfo TagNo="701" CountTypeID="-1" />
          <TagInfo TagNo="702" CountTypeID="-1" />
          <TagInfo TagNo="703" CountTypeID="-1" />
          <TagInfo TagNo="704" CountTypeID="-1" />
          <TagInfo TagNo="705" CountTypeID="-1" />
          <TagInfo TagNo="706" CountTypeID="-1" />
          <TagInfo TagNo="707" CountTypeID="-1" />
          <TagInfo TagNo="708" CountTypeID="-1" />
          <TagInfo TagNo="709" CountTypeID="-1" />
          <TagInfo TagNo="710" CountTypeID="-1" />
          <TagInfo TagNo="711" CountTypeID="-1" />
          <TagInfo TagNo="712" CountTypeID="-1" />
          <TagInfo TagNo="713" CountTypeID="-1" />
          <TagInfo TagNo="714" CountTypeID="-1" />
          <TagInfo TagNo="715" CountTypeID="-1" />
          <TagInfo TagNo="716" CountTypeID="-1" />
          <TagInfo TagNo="717" CountTypeID="-1" />
          <TagInfo TagNo="718" CountTypeID="-1" />
          <TagInfo TagNo="719" CountTypeID="-1" />
          <TagInfo TagNo="720" CountTypeID="-1" />
          <TagInfo TagNo="721" CountTypeID="-1" />
          <TagInfo TagNo="722" CountTypeID="-1" />
          <TagInfo TagNo="723" CountTypeID="-1" />
          <TagInfo TagNo="724" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="KIDS1" TagRangeDescription="" TagRangeFrom="1004" TagRangeTo="1061" DefaultCountTypeID="-1">
          <TagInfo TagNo="1004" CountTypeID="-1" />
          <TagInfo TagNo="1005" CountTypeID="-1" />
          <TagInfo TagNo="1006" CountTypeID="-1" />
          <TagInfo TagNo="1007" CountTypeID="-1" />
          <TagInfo TagNo="1008" CountTypeID="-1" />
          <TagInfo TagNo="1009" CountTypeID="-1" />
          <TagInfo TagNo="1010" CountTypeID="-1" />
          <TagInfo TagNo="1011" CountTypeID="-1" />
          <TagInfo TagNo="1012" CountTypeID="-1" />
          <TagInfo TagNo="1013" CountTypeID="-1" />
          <TagInfo TagNo="1014" CountTypeID="-1" />
          <TagInfo TagNo="1015" CountTypeID="-1" />
          <TagInfo TagNo="1016" CountTypeID="-1" />
          <TagInfo TagNo="1017" CountTypeID="-1" />
          <TagInfo TagNo="1018" CountTypeID="-1" />
          <TagInfo TagNo="1019" CountTypeID="-1" />
          <TagInfo TagNo="1020" CountTypeID="-1" />
          <TagInfo TagNo="1021" CountTypeID="-1" />
          <TagInfo TagNo="1022" CountTypeID="-1" />
          <TagInfo TagNo="1023" CountTypeID="-1" />
          <TagInfo TagNo="1024" CountTypeID="-1" />
          <TagInfo TagNo="1025" CountTypeID="-1" />
          <TagInfo TagNo="1026" CountTypeID="-1" />
          <TagInfo TagNo="1027" CountTypeID="-1" />
          <TagInfo TagNo="1028" CountTypeID="-1" />
          <TagInfo TagNo="1029" CountTypeID="-1" />
          <TagInfo TagNo="1030" CountTypeID="-1" />
          <TagInfo TagNo="1031" CountTypeID="-1" />
          <TagInfo TagNo="1032" CountTypeID="-1" />
          <TagInfo TagNo="1033" CountTypeID="-1" />
          <TagInfo TagNo="1034" CountTypeID="-1" />
          <TagInfo TagNo="1035" CountTypeID="-1" />
          <TagInfo TagNo="1036" CountTypeID="-1" />
          <TagInfo TagNo="1037" CountTypeID="-1" />
          <TagInfo TagNo="1038" CountTypeID="-1" />
          <TagInfo TagNo="1039" CountTypeID="-1" />
          <TagInfo TagNo="1040" CountTypeID="-1" />
          <TagInfo TagNo="1041" CountTypeID="-1" />
          <TagInfo TagNo="1042" CountTypeID="-1" />
          <TagInfo TagNo="1043" CountTypeID="-1" />
          <TagInfo TagNo="1044" CountTypeID="-1" />
          <TagInfo TagNo="1045" CountTypeID="-1" />
          <TagInfo TagNo="1046" CountTypeID="-1" />
          <TagInfo TagNo="1047" CountTypeID="-1" />
          <TagInfo TagNo="1048" CountTypeID="-1" />
          <TagInfo TagNo="1049" CountTypeID="-1" />
          <TagInfo TagNo="1050" CountTypeID="-1" />
          <TagInfo TagNo="1051" CountTypeID="-1" />
          <TagInfo TagNo="1052" CountTypeID="-1" />
          <TagInfo TagNo="1053" CountTypeID="-1" />
          <TagInfo TagNo="1054" CountTypeID="-1" />
          <TagInfo TagNo="1055" CountTypeID="-1" />
          <TagInfo TagNo="1056" CountTypeID="-1" />
          <TagInfo TagNo="1057" CountTypeID="-1" />
          <TagInfo TagNo="1058" CountTypeID="-1" />
          <TagInfo TagNo="1059" CountTypeID="-1" />
          <TagInfo TagNo="1060" CountTypeID="-1" />
          <TagInfo TagNo="1061" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="BABY" TagRangeDescription="" TagRangeFrom="1062" TagRangeTo="1085" DefaultCountTypeID="-1">
          <TagInfo TagNo="1062" CountTypeID="-1" />
          <TagInfo TagNo="1063" CountTypeID="-1" />
          <TagInfo TagNo="1064" CountTypeID="-1" />
          <TagInfo TagNo="1065" CountTypeID="-1" />
          <TagInfo TagNo="1066" CountTypeID="-1" />
          <TagInfo TagNo="1067" CountTypeID="-1" />
          <TagInfo TagNo="1068" CountTypeID="-1" />
          <TagInfo TagNo="1069" CountTypeID="-1" />
          <TagInfo TagNo="1070" CountTypeID="-1" />
          <TagInfo TagNo="1071" CountTypeID="-1" />
          <TagInfo TagNo="1072" CountTypeID="-1" />
          <TagInfo TagNo="1073" CountTypeID="-1" />
          <TagInfo TagNo="1074" CountTypeID="-1" />
          <TagInfo TagNo="1075" CountTypeID="-1" />
          <TagInfo TagNo="1076" CountTypeID="-1" />
          <TagInfo TagNo="1077" CountTypeID="-1" />
          <TagInfo TagNo="1078" CountTypeID="-1" />
          <TagInfo TagNo="1079" CountTypeID="-1" />
          <TagInfo TagNo="1080" CountTypeID="-1" />
          <TagInfo TagNo="1081" CountTypeID="-1" />
          <TagInfo TagNo="1082" CountTypeID="-1" />
          <TagInfo TagNo="1083" CountTypeID="-1" />
          <TagInfo TagNo="1084" CountTypeID="-1" />
          <TagInfo TagNo="1085" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="KIDS" TagRangeDescription="" TagRangeFrom="1086" TagRangeTo="1133" DefaultCountTypeID="-1">
          <TagInfo TagNo="1086" CountTypeID="-1" />
          <TagInfo TagNo="1087" CountTypeID="-1" />
          <TagInfo TagNo="1088" CountTypeID="-1" />
          <TagInfo TagNo="1089" CountTypeID="-1" />
          <TagInfo TagNo="1090" CountTypeID="-1" />
          <TagInfo TagNo="1091" CountTypeID="-1" />
          <TagInfo TagNo="1092" CountTypeID="-1" />
          <TagInfo TagNo="1093" CountTypeID="-1" />
          <TagInfo TagNo="1094" CountTypeID="-1" />
          <TagInfo TagNo="1095" CountTypeID="-1" />
          <TagInfo TagNo="1096" CountTypeID="-1" />
          <TagInfo TagNo="1097" CountTypeID="-1" />
          <TagInfo TagNo="1098" CountTypeID="-1" />
          <TagInfo TagNo="1099" CountTypeID="-1" />
          <TagInfo TagNo="1100" CountTypeID="-1" />
          <TagInfo TagNo="1101" CountTypeID="-1" />
          <TagInfo TagNo="1102" CountTypeID="-1" />
          <TagInfo TagNo="1103" CountTypeID="-1" />
          <TagInfo TagNo="1104" CountTypeID="-1" />
          <TagInfo TagNo="1105" CountTypeID="-1" />
          <TagInfo TagNo="1106" CountTypeID="-1" />
          <TagInfo TagNo="1107" CountTypeID="-1" />
          <TagInfo TagNo="1108" CountTypeID="-1" />
          <TagInfo TagNo="1109" CountTypeID="-1" />
          <TagInfo TagNo="1110" CountTypeID="-1" />
          <TagInfo TagNo="1111" CountTypeID="-1" />
          <TagInfo TagNo="1112" CountTypeID="-1" />
          <TagInfo TagNo="1113" CountTypeID="-1" />
          <TagInfo TagNo="1114" CountTypeID="-1" />
          <TagInfo TagNo="1115" CountTypeID="-1" />
          <TagInfo TagNo="1116" CountTypeID="-1" />
          <TagInfo TagNo="1117" CountTypeID="-1" />
          <TagInfo TagNo="1118" CountTypeID="-1" />
          <TagInfo TagNo="1119" CountTypeID="-1" />
          <TagInfo TagNo="1120" CountTypeID="-1" />
          <TagInfo TagNo="1121" CountTypeID="-1" />
          <TagInfo TagNo="1122" CountTypeID="-1" />
          <TagInfo TagNo="1123" CountTypeID="-1" />
          <TagInfo TagNo="1124" CountTypeID="-1" />
          <TagInfo TagNo="1125" CountTypeID="-1" />
          <TagInfo TagNo="1126" CountTypeID="-1" />
          <TagInfo TagNo="1127" CountTypeID="-1" />
          <TagInfo TagNo="1128" CountTypeID="-1" />
          <TagInfo TagNo="1129" CountTypeID="-1" />
          <TagInfo TagNo="1130" CountTypeID="-1" />
          <TagInfo TagNo="1131" CountTypeID="-1" />
          <TagInfo TagNo="1132" CountTypeID="-1" />
          <TagInfo TagNo="1133" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="MEN" TagRangeDescription="" TagRangeFrom="1134" TagRangeTo="1195" DefaultCountTypeID="-1">
          <TagInfo TagNo="1134" CountTypeID="-1" />
          <TagInfo TagNo="1135" CountTypeID="-1" />
          <TagInfo TagNo="1136" CountTypeID="-1" />
          <TagInfo TagNo="1137" CountTypeID="-1" />
          <TagInfo TagNo="1138" CountTypeID="-1" />
          <TagInfo TagNo="1139" CountTypeID="-1" />
          <TagInfo TagNo="1140" CountTypeID="-1" />
          <TagInfo TagNo="1141" CountTypeID="-1" />
          <TagInfo TagNo="1142" CountTypeID="-1" />
          <TagInfo TagNo="1143" CountTypeID="-1" />
          <TagInfo TagNo="1144" CountTypeID="-1" />
          <TagInfo TagNo="1145" CountTypeID="-1" />
          <TagInfo TagNo="1146" CountTypeID="-1" />
          <TagInfo TagNo="1147" CountTypeID="-1" />
          <TagInfo TagNo="1148" CountTypeID="-1" />
          <TagInfo TagNo="1149" CountTypeID="-1" />
          <TagInfo TagNo="1150" CountTypeID="-1" />
          <TagInfo TagNo="1151" CountTypeID="-1" />
          <TagInfo TagNo="1152" CountTypeID="-1" />
          <TagInfo TagNo="1153" CountTypeID="-1" />
          <TagInfo TagNo="1154" CountTypeID="-1" />
          <TagInfo TagNo="1155" CountTypeID="-1" />
          <TagInfo TagNo="1156" CountTypeID="-1" />
          <TagInfo TagNo="1157" CountTypeID="-1" />
          <TagInfo TagNo="1158" CountTypeID="-1" />
          <TagInfo TagNo="1159" CountTypeID="-1" />
          <TagInfo TagNo="1160" CountTypeID="-1" />
          <TagInfo TagNo="1161" CountTypeID="-1" />
          <TagInfo TagNo="1162" CountTypeID="-1" />
          <TagInfo TagNo="1163" CountTypeID="-1" />
          <TagInfo TagNo="1164" CountTypeID="-1" />
          <TagInfo TagNo="1165" CountTypeID="-1" />
          <TagInfo TagNo="1166" CountTypeID="-1" />
          <TagInfo TagNo="1167" CountTypeID="-1" />
          <TagInfo TagNo="1168" CountTypeID="-1" />
          <TagInfo TagNo="1169" CountTypeID="-1" />
          <TagInfo TagNo="1170" CountTypeID="-1" />
          <TagInfo TagNo="1171" CountTypeID="-1" />
          <TagInfo TagNo="1172" CountTypeID="-1" />
          <TagInfo TagNo="1173" CountTypeID="-1" />
          <TagInfo TagNo="1174" CountTypeID="-1" />
          <TagInfo TagNo="1175" CountTypeID="-1" />
          <TagInfo TagNo="1176" CountTypeID="-1" />
          <TagInfo TagNo="1177" CountTypeID="-1" />
          <TagInfo TagNo="1178" CountTypeID="-1" />
          <TagInfo TagNo="1179" CountTypeID="-1" />
          <TagInfo TagNo="1180" CountTypeID="-1" />
          <TagInfo TagNo="1181" CountTypeID="-1" />
          <TagInfo TagNo="1182" CountTypeID="-1" />
          <TagInfo TagNo="1183" CountTypeID="-1" />
          <TagInfo TagNo="1184" CountTypeID="-1" />
          <TagInfo TagNo="1185" CountTypeID="-1" />
          <TagInfo TagNo="1186" CountTypeID="-1" />
          <TagInfo TagNo="1187" CountTypeID="-1" />
          <TagInfo TagNo="1188" CountTypeID="-1" />
          <TagInfo TagNo="1189" CountTypeID="-1" />
          <TagInfo TagNo="1190" CountTypeID="-1" />
          <TagInfo TagNo="1191" CountTypeID="-1" />
          <TagInfo TagNo="1192" CountTypeID="-1" />
          <TagInfo TagNo="1193" CountTypeID="-1" />
          <TagInfo TagNo="1194" CountTypeID="-1" />
          <TagInfo TagNo="1195" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="WOMENS" TagRangeDescription="" TagRangeFrom="1196" TagRangeTo="1390" DefaultCountTypeID="-1">
          <TagInfo TagNo="1196" CountTypeID="-1" />
          <TagInfo TagNo="1197" CountTypeID="-1" />
          <TagInfo TagNo="1198" CountTypeID="-1" />
          <TagInfo TagNo="1199" CountTypeID="-1" />
          <TagInfo TagNo="1200" CountTypeID="-1" />
          <TagInfo TagNo="1201" CountTypeID="-1" />
          <TagInfo TagNo="1202" CountTypeID="-1" />
          <TagInfo TagNo="1203" CountTypeID="-1" />
          <TagInfo TagNo="1204" CountTypeID="-1" />
          <TagInfo TagNo="1205" CountTypeID="-1" />
          <TagInfo TagNo="1206" CountTypeID="-1" />
          <TagInfo TagNo="1207" CountTypeID="-1" />
          <TagInfo TagNo="1208" CountTypeID="-1" />
          <TagInfo TagNo="1209" CountTypeID="-1" />
          <TagInfo TagNo="1210" CountTypeID="-1" />
          <TagInfo TagNo="1211" CountTypeID="-1" />
          <TagInfo TagNo="1212" CountTypeID="-1" />
          <TagInfo TagNo="1213" CountTypeID="-1" />
          <TagInfo TagNo="1214" CountTypeID="-1" />
          <TagInfo TagNo="1215" CountTypeID="-1" />
          <TagInfo TagNo="1216" CountTypeID="-1" />
          <TagInfo TagNo="1217" CountTypeID="-1" />
          <TagInfo TagNo="1218" CountTypeID="-1" />
          <TagInfo TagNo="1219" CountTypeID="-1" />
          <TagInfo TagNo="1220" CountTypeID="-1" />
          <TagInfo TagNo="1221" CountTypeID="-1" />
          <TagInfo TagNo="1222" CountTypeID="-1" />
          <TagInfo TagNo="1223" CountTypeID="-1" />
          <TagInfo TagNo="1224" CountTypeID="-1" />
          <TagInfo TagNo="1225" CountTypeID="-1" />
          <TagInfo TagNo="1226" CountTypeID="-1" />
          <TagInfo TagNo="1227" CountTypeID="-1" />
          <TagInfo TagNo="1228" CountTypeID="-1" />
          <TagInfo TagNo="1229" CountTypeID="-1" />
          <TagInfo TagNo="1230" CountTypeID="-1" />
          <TagInfo TagNo="1231" CountTypeID="-1" />
          <TagInfo TagNo="1232" CountTypeID="-1" />
          <TagInfo TagNo="1233" CountTypeID="-1" />
          <TagInfo TagNo="1234" CountTypeID="-1" />
          <TagInfo TagNo="1235" CountTypeID="-1" />
          <TagInfo TagNo="1236" CountTypeID="-1" />
          <TagInfo TagNo="1237" CountTypeID="-1" />
          <TagInfo TagNo="1238" CountTypeID="-1" />
          <TagInfo TagNo="1239" CountTypeID="-1" />
          <TagInfo TagNo="1240" CountTypeID="-1" />
          <TagInfo TagNo="1241" CountTypeID="-1" />
          <TagInfo TagNo="1242" CountTypeID="-1" />
          <TagInfo TagNo="1243" CountTypeID="-1" />
          <TagInfo TagNo="1244" CountTypeID="-1" />
          <TagInfo TagNo="1245" CountTypeID="-1" />
          <TagInfo TagNo="1246" CountTypeID="-1" />
          <TagInfo TagNo="1247" CountTypeID="-1" />
          <TagInfo TagNo="1248" CountTypeID="-1" />
          <TagInfo TagNo="1249" CountTypeID="-1" />
          <TagInfo TagNo="1250" CountTypeID="-1" />
          <TagInfo TagNo="1251" CountTypeID="-1" />
          <TagInfo TagNo="1252" CountTypeID="-1" />
          <TagInfo TagNo="1253" CountTypeID="-1" />
          <TagInfo TagNo="1254" CountTypeID="-1" />
          <TagInfo TagNo="1255" CountTypeID="-1" />
          <TagInfo TagNo="1256" CountTypeID="-1" />
          <TagInfo TagNo="1257" CountTypeID="-1" />
          <TagInfo TagNo="1258" CountTypeID="-1" />
          <TagInfo TagNo="1259" CountTypeID="-1" />
          <TagInfo TagNo="1260" CountTypeID="-1" />
          <TagInfo TagNo="1261" CountTypeID="-1" />
          <TagInfo TagNo="1262" CountTypeID="-1" />
          <TagInfo TagNo="1263" CountTypeID="-1" />
          <TagInfo TagNo="1264" CountTypeID="-1" />
          <TagInfo TagNo="1265" CountTypeID="-1" />
          <TagInfo TagNo="1266" CountTypeID="-1" />
          <TagInfo TagNo="1267" CountTypeID="-1" />
          <TagInfo TagNo="1268" CountTypeID="-1" />
          <TagInfo TagNo="1269" CountTypeID="-1" />
          <TagInfo TagNo="1270" CountTypeID="-1" />
          <TagInfo TagNo="1271" CountTypeID="-1" />
          <TagInfo TagNo="1272" CountTypeID="-1" />
          <TagInfo TagNo="1273" CountTypeID="-1" />
          <TagInfo TagNo="1274" CountTypeID="-1" />
          <TagInfo TagNo="1275" CountTypeID="-1" />
          <TagInfo TagNo="1276" CountTypeID="-1" />
          <TagInfo TagNo="1277" CountTypeID="-1" />
          <TagInfo TagNo="1278" CountTypeID="-1" />
          <TagInfo TagNo="1279" CountTypeID="-1" />
          <TagInfo TagNo="1280" CountTypeID="-1" />
          <TagInfo TagNo="1281" CountTypeID="-1" />
          <TagInfo TagNo="1282" CountTypeID="-1" />
          <TagInfo TagNo="1283" CountTypeID="-1" />
          <TagInfo TagNo="1284" CountTypeID="-1" />
          <TagInfo TagNo="1285" CountTypeID="-1" />
          <TagInfo TagNo="1286" CountTypeID="-1" />
          <TagInfo TagNo="1287" CountTypeID="-1" />
          <TagInfo TagNo="1288" CountTypeID="-1" />
          <TagInfo TagNo="1289" CountTypeID="-1" />
          <TagInfo TagNo="1290" CountTypeID="-1" />
          <TagInfo TagNo="1291" CountTypeID="-1" />
          <TagInfo TagNo="1292" CountTypeID="-1" />
          <TagInfo TagNo="1293" CountTypeID="-1" />
          <TagInfo TagNo="1294" CountTypeID="-1" />
          <TagInfo TagNo="1295" CountTypeID="-1" />
          <TagInfo TagNo="1296" CountTypeID="-1" />
          <TagInfo TagNo="1297" CountTypeID="-1" />
          <TagInfo TagNo="1298" CountTypeID="-1" />
          <TagInfo TagNo="1299" CountTypeID="-1" />
          <TagInfo TagNo="1300" CountTypeID="-1" />
          <TagInfo TagNo="1301" CountTypeID="-1" />
          <TagInfo TagNo="1302" CountTypeID="-1" />
          <TagInfo TagNo="1303" CountTypeID="-1" />
          <TagInfo TagNo="1304" CountTypeID="-1" />
          <TagInfo TagNo="1305" CountTypeID="-1" />
          <TagInfo TagNo="1306" CountTypeID="-1" />
          <TagInfo TagNo="1307" CountTypeID="-1" />
          <TagInfo TagNo="1308" CountTypeID="-1" />
          <TagInfo TagNo="1309" CountTypeID="-1" />
          <TagInfo TagNo="1310" CountTypeID="-1" />
          <TagInfo TagNo="1311" CountTypeID="-1" />
          <TagInfo TagNo="1312" CountTypeID="-1" />
          <TagInfo TagNo="1313" CountTypeID="-1" />
          <TagInfo TagNo="1314" CountTypeID="-1" />
          <TagInfo TagNo="1315" CountTypeID="-1" />
          <TagInfo TagNo="1316" CountTypeID="-1" />
          <TagInfo TagNo="1317" CountTypeID="-1" />
          <TagInfo TagNo="1318" CountTypeID="-1" />
          <TagInfo TagNo="1319" CountTypeID="-1" />
          <TagInfo TagNo="1320" CountTypeID="-1" />
          <TagInfo TagNo="1321" CountTypeID="-1" />
          <TagInfo TagNo="1322" CountTypeID="-1" />
          <TagInfo TagNo="1323" CountTypeID="-1" />
          <TagInfo TagNo="1324" CountTypeID="-1" />
          <TagInfo TagNo="1325" CountTypeID="-1" />
          <TagInfo TagNo="1326" CountTypeID="-1" />
          <TagInfo TagNo="1327" CountTypeID="-1" />
          <TagInfo TagNo="1328" CountTypeID="-1" />
          <TagInfo TagNo="1329" CountTypeID="-1" />
          <TagInfo TagNo="1330" CountTypeID="-1" />
          <TagInfo TagNo="1331" CountTypeID="-1" />
          <TagInfo TagNo="1332" CountTypeID="-1" />
          <TagInfo TagNo="1333" CountTypeID="-1" />
          <TagInfo TagNo="1334" CountTypeID="-1" />
          <TagInfo TagNo="1335" CountTypeID="-1" />
          <TagInfo TagNo="1336" CountTypeID="-1" />
          <TagInfo TagNo="1337" CountTypeID="-1" />
          <TagInfo TagNo="1338" CountTypeID="-1" />
          <TagInfo TagNo="1339" CountTypeID="-1" />
          <TagInfo TagNo="1340" CountTypeID="-1" />
          <TagInfo TagNo="1341" CountTypeID="-1" />
          <TagInfo TagNo="1342" CountTypeID="-1" />
          <TagInfo TagNo="1343" CountTypeID="-1" />
          <TagInfo TagNo="1344" CountTypeID="-1" />
          <TagInfo TagNo="1345" CountTypeID="-1" />
          <TagInfo TagNo="1346" CountTypeID="-1" />
          <TagInfo TagNo="1347" CountTypeID="-1" />
          <TagInfo TagNo="1348" CountTypeID="-1" />
          <TagInfo TagNo="1349" CountTypeID="-1" />
          <TagInfo TagNo="1350" CountTypeID="-1" />
          <TagInfo TagNo="1351" CountTypeID="-1" />
          <TagInfo TagNo="1352" CountTypeID="-1" />
          <TagInfo TagNo="1353" CountTypeID="-1" />
          <TagInfo TagNo="1354" CountTypeID="-1" />
          <TagInfo TagNo="1355" CountTypeID="-1" />
          <TagInfo TagNo="1356" CountTypeID="-1" />
          <TagInfo TagNo="1357" CountTypeID="-1" />
          <TagInfo TagNo="1358" CountTypeID="-1" />
          <TagInfo TagNo="1359" CountTypeID="-1" />
          <TagInfo TagNo="1360" CountTypeID="-1" />
          <TagInfo TagNo="1361" CountTypeID="-1" />
          <TagInfo TagNo="1362" CountTypeID="-1" />
          <TagInfo TagNo="1363" CountTypeID="-1" />
          <TagInfo TagNo="1364" CountTypeID="-1" />
          <TagInfo TagNo="1365" CountTypeID="-1" />
          <TagInfo TagNo="1366" CountTypeID="-1" />
          <TagInfo TagNo="1367" CountTypeID="-1" />
          <TagInfo TagNo="1368" CountTypeID="-1" />
          <TagInfo TagNo="1369" CountTypeID="-1" />
          <TagInfo TagNo="1370" CountTypeID="-1" />
          <TagInfo TagNo="1371" CountTypeID="-1" />
          <TagInfo TagNo="1372" CountTypeID="-1" />
          <TagInfo TagNo="1373" CountTypeID="-1" />
          <TagInfo TagNo="1374" CountTypeID="-1" />
          <TagInfo TagNo="1375" CountTypeID="-1" />
          <TagInfo TagNo="1376" CountTypeID="-1" />
          <TagInfo TagNo="1377" CountTypeID="-1" />
          <TagInfo TagNo="1378" CountTypeID="-1" />
          <TagInfo TagNo="1379" CountTypeID="-1" />
          <TagInfo TagNo="1380" CountTypeID="-1" />
          <TagInfo TagNo="1381" CountTypeID="-1" />
          <TagInfo TagNo="1382" CountTypeID="-1" />
          <TagInfo TagNo="1383" CountTypeID="-1" />
          <TagInfo TagNo="1384" CountTypeID="-1" />
          <TagInfo TagNo="1385" CountTypeID="-1" />
          <TagInfo TagNo="1386" CountTypeID="-1" />
          <TagInfo TagNo="1387" CountTypeID="-1" />
          <TagInfo TagNo="1388" CountTypeID="-1" />
          <TagInfo TagNo="1389" CountTypeID="-1" />
          <TagInfo TagNo="1390" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="Single" TagRangeDescription="" TagRangeFrom="1701" TagRangeTo="1701" DefaultCountTypeID="-1">
          <TagInfo TagNo="1701" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="KIDS QTY" TagRangeDescription="" TagRangeFrom="1801" TagRangeTo="1810" DefaultCountTypeID="-1">
          <TagInfo TagNo="1801" CountTypeID="-1" />
          <TagInfo TagNo="1802" CountTypeID="-1" />
          <TagInfo TagNo="1803" CountTypeID="-1" />
          <TagInfo TagNo="1804" CountTypeID="-1" />
          <TagInfo TagNo="1805" CountTypeID="-1" />
          <TagInfo TagNo="1806" CountTypeID="-1" />
          <TagInfo TagNo="1807" CountTypeID="-1" />
          <TagInfo TagNo="1808" CountTypeID="-1" />
          <TagInfo TagNo="1809" CountTypeID="-1" />
          <TagInfo TagNo="1810" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="BABY QTY" TagRangeDescription="" TagRangeFrom="1811" TagRangeTo="1821" DefaultCountTypeID="-1">
          <TagInfo TagNo="1811" CountTypeID="-1" />
          <TagInfo TagNo="1812" CountTypeID="-1" />
          <TagInfo TagNo="1813" CountTypeID="-1" />
          <TagInfo TagNo="1814" CountTypeID="-1" />
          <TagInfo TagNo="1815" CountTypeID="-1" />
          <TagInfo TagNo="1816" CountTypeID="-1" />
          <TagInfo TagNo="1817" CountTypeID="-1" />
          <TagInfo TagNo="1818" CountTypeID="-1" />
          <TagInfo TagNo="1819" CountTypeID="-1" />
          <TagInfo TagNo="1820" CountTypeID="-1" />
          <TagInfo TagNo="1821" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="KIDS2 QTY" TagRangeDescription="" TagRangeFrom="1822" TagRangeTo="1832" DefaultCountTypeID="-1">
          <TagInfo TagNo="1822" CountTypeID="-1" />
          <TagInfo TagNo="1823" CountTypeID="-1" />
          <TagInfo TagNo="1824" CountTypeID="-1" />
          <TagInfo TagNo="1825" CountTypeID="-1" />
          <TagInfo TagNo="1826" CountTypeID="-1" />
          <TagInfo TagNo="1827" CountTypeID="-1" />
          <TagInfo TagNo="1828" CountTypeID="-1" />
          <TagInfo TagNo="1829" CountTypeID="-1" />
          <TagInfo TagNo="1830" CountTypeID="-1" />
          <TagInfo TagNo="1831" CountTypeID="-1" />
          <TagInfo TagNo="1832" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="MEN QTY" TagRangeDescription="" TagRangeFrom="1833" TagRangeTo="1857" DefaultCountTypeID="-1">
          <TagInfo TagNo="1833" CountTypeID="-1" />
          <TagInfo TagNo="1834" CountTypeID="-1" />
          <TagInfo TagNo="1835" CountTypeID="-1" />
          <TagInfo TagNo="1836" CountTypeID="-1" />
          <TagInfo TagNo="1837" CountTypeID="-1" />
          <TagInfo TagNo="1838" CountTypeID="-1" />
          <TagInfo TagNo="1839" CountTypeID="-1" />
          <TagInfo TagNo="1840" CountTypeID="-1" />
          <TagInfo TagNo="1841" CountTypeID="-1" />
          <TagInfo TagNo="1842" CountTypeID="-1" />
          <TagInfo TagNo="1843" CountTypeID="-1" />
          <TagInfo TagNo="1844" CountTypeID="-1" />
          <TagInfo TagNo="1845" CountTypeID="-1" />
          <TagInfo TagNo="1846" CountTypeID="-1" />
          <TagInfo TagNo="1847" CountTypeID="-1" />
          <TagInfo TagNo="1848" CountTypeID="-1" />
          <TagInfo TagNo="1849" CountTypeID="-1" />
          <TagInfo TagNo="1850" CountTypeID="-1" />
          <TagInfo TagNo="1851" CountTypeID="-1" />
          <TagInfo TagNo="1852" CountTypeID="-1" />
          <TagInfo TagNo="1853" CountTypeID="-1" />
          <TagInfo TagNo="1854" CountTypeID="-1" />
          <TagInfo TagNo="1855" CountTypeID="-1" />
          <TagInfo TagNo="1856" CountTypeID="-1" />
          <TagInfo TagNo="1857" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="WOMEN QTY" TagRangeDescription="" TagRangeFrom="1858" TagRangeTo="1873" DefaultCountTypeID="-1">
          <TagInfo TagNo="1858" CountTypeID="-1" />
          <TagInfo TagNo="1859" CountTypeID="-1" />
          <TagInfo TagNo="1860" CountTypeID="-1" />
          <TagInfo TagNo="1861" CountTypeID="-1" />
          <TagInfo TagNo="1862" CountTypeID="-1" />
          <TagInfo TagNo="1863" CountTypeID="-1" />
          <TagInfo TagNo="1864" CountTypeID="-1" />
          <TagInfo TagNo="1865" CountTypeID="-1" />
          <TagInfo TagNo="1866" CountTypeID="-1" />
          <TagInfo TagNo="1867" CountTypeID="-1" />
          <TagInfo TagNo="1868" CountTypeID="-1" />
          <TagInfo TagNo="1869" CountTypeID="-1" />
          <TagInfo TagNo="1870" CountTypeID="-1" />
          <TagInfo TagNo="1871" CountTypeID="-1" />
          <TagInfo TagNo="1872" CountTypeID="-1" />
          <TagInfo TagNo="1873" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="FINANCIAL" TagRangeDescription="" TagRangeFrom="1923" TagRangeTo="1936" DefaultCountTypeID="-1">
          <TagInfo TagNo="1923" CountTypeID="-1" />
          <TagInfo TagNo="1924" CountTypeID="-1" />
          <TagInfo TagNo="1925" CountTypeID="-1" />
          <TagInfo TagNo="1926" CountTypeID="-1" />
          <TagInfo TagNo="1927" CountTypeID="-1" />
          <TagInfo TagNo="1928" CountTypeID="-1" />
          <TagInfo TagNo="1929" CountTypeID="-1" />
          <TagInfo TagNo="1930" CountTypeID="-1" />
          <TagInfo TagNo="1931" CountTypeID="-1" />
          <TagInfo TagNo="1932" CountTypeID="-1" />
          <TagInfo TagNo="1933" CountTypeID="-1" />
          <TagInfo TagNo="1934" CountTypeID="-1" />
          <TagInfo TagNo="1935" CountTypeID="-1" />
          <TagInfo TagNo="1936" CountTypeID="-1" />
        </TagRange>
      </GroupRange>
      <GroupRange GroupName="WAREHOUSE" GroupDescription="
    ">
        <TagRange TagRangeName="GROCERY RACKING" TagRangeDescription="" TagRangeFrom="74" TagRangeTo="105" DefaultCountTypeID="-1">
          <TagInfo TagNo="74" CountTypeID="-1" />
          <TagInfo TagNo="75" CountTypeID="-1" />
          <TagInfo TagNo="76" CountTypeID="-1" />
          <TagInfo TagNo="77" CountTypeID="-1" />
          <TagInfo TagNo="78" CountTypeID="-1" />
          <TagInfo TagNo="79" CountTypeID="-1" />
          <TagInfo TagNo="80" CountTypeID="-1" />
          <TagInfo TagNo="81" CountTypeID="-1" />
          <TagInfo TagNo="82" CountTypeID="-1" />
          <TagInfo TagNo="83" CountTypeID="-1" />
          <TagInfo TagNo="84" CountTypeID="-1" />
          <TagInfo TagNo="85" CountTypeID="-1" />
          <TagInfo TagNo="86" CountTypeID="-1" />
          <TagInfo TagNo="87" CountTypeID="-1" />
          <TagInfo TagNo="88" CountTypeID="-1" />
          <TagInfo TagNo="89" CountTypeID="-1" />
          <TagInfo TagNo="90" CountTypeID="-1" />
          <TagInfo TagNo="91" CountTypeID="-1" />
          <TagInfo TagNo="92" CountTypeID="-1" />
          <TagInfo TagNo="93" CountTypeID="-1" />
          <TagInfo TagNo="94" CountTypeID="-1" />
          <TagInfo TagNo="95" CountTypeID="-1" />
          <TagInfo TagNo="96" CountTypeID="-1" />
          <TagInfo TagNo="97" CountTypeID="-1" />
          <TagInfo TagNo="98" CountTypeID="-1" />
          <TagInfo TagNo="99" CountTypeID="-1" />
          <TagInfo TagNo="100" CountTypeID="-1" />
          <TagInfo TagNo="101" CountTypeID="-1" />
          <TagInfo TagNo="102" CountTypeID="-1" />
          <TagInfo TagNo="103" CountTypeID="-1" />
          <TagInfo TagNo="104" CountTypeID="-1" />
          <TagInfo TagNo="105" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="CHILLER BK-UP" TagRangeDescription="" TagRangeFrom="106" TagRangeTo="123" DefaultCountTypeID="-1">
          <TagInfo TagNo="106" CountTypeID="-1" />
          <TagInfo TagNo="107" CountTypeID="-1" />
          <TagInfo TagNo="108" CountTypeID="-1" />
          <TagInfo TagNo="109" CountTypeID="-1" />
          <TagInfo TagNo="110" CountTypeID="-1" />
          <TagInfo TagNo="111" CountTypeID="-1" />
          <TagInfo TagNo="112" CountTypeID="-1" />
          <TagInfo TagNo="113" CountTypeID="-1" />
          <TagInfo TagNo="114" CountTypeID="-1" />
          <TagInfo TagNo="115" CountTypeID="-1" />
          <TagInfo TagNo="116" CountTypeID="-1" />
          <TagInfo TagNo="117" CountTypeID="-1" />
          <TagInfo TagNo="118" CountTypeID="-1" />
          <TagInfo TagNo="119" CountTypeID="-1" />
          <TagInfo TagNo="120" CountTypeID="-1" />
          <TagInfo TagNo="121" CountTypeID="-1" />
          <TagInfo TagNo="122" CountTypeID="-1" />
          <TagInfo TagNo="123" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="PRODUCE AMBIENT " TagRangeDescription="" TagRangeFrom="124" TagRangeTo="129" DefaultCountTypeID="-1">
          <TagInfo TagNo="124" CountTypeID="-1" />
          <TagInfo TagNo="125" CountTypeID="-1" />
          <TagInfo TagNo="126" CountTypeID="-1" />
          <TagInfo TagNo="127" CountTypeID="-1" />
          <TagInfo TagNo="128" CountTypeID="-1" />
          <TagInfo TagNo="129" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="BWS BK-UP" TagRangeDescription="" TagRangeFrom="130" TagRangeTo="137" DefaultCountTypeID="-1">
          <TagInfo TagNo="130" CountTypeID="-1" />
          <TagInfo TagNo="131" CountTypeID="-1" />
          <TagInfo TagNo="132" CountTypeID="-1" />
          <TagInfo TagNo="133" CountTypeID="-1" />
          <TagInfo TagNo="134" CountTypeID="-1" />
          <TagInfo TagNo="135" CountTypeID="-1" />
          <TagInfo TagNo="136" CountTypeID="-1" />
          <TagInfo TagNo="137" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="H&amp;B W/H" TagRangeDescription="" TagRangeFrom="138" TagRangeTo="142" DefaultCountTypeID="-1">
          <TagInfo TagNo="138" CountTypeID="-1" />
          <TagInfo TagNo="139" CountTypeID="-1" />
          <TagInfo TagNo="140" CountTypeID="-1" />
          <TagInfo TagNo="141" CountTypeID="-1" />
          <TagInfo TagNo="142" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="M&amp;V W/H" TagRangeDescription="" TagRangeFrom="143" TagRangeTo="151" DefaultCountTypeID="-1">
          <TagInfo TagNo="143" CountTypeID="-1" />
          <TagInfo TagNo="144" CountTypeID="-1" />
          <TagInfo TagNo="145" CountTypeID="-1" />
          <TagInfo TagNo="146" CountTypeID="-1" />
          <TagInfo TagNo="147" CountTypeID="-1" />
          <TagInfo TagNo="148" CountTypeID="-1" />
          <TagInfo TagNo="149" CountTypeID="-1" />
          <TagInfo TagNo="150" CountTypeID="-1" />
          <TagInfo TagNo="151" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="GM W/H" TagRangeDescription="" TagRangeFrom="152" TagRangeTo="197" DefaultCountTypeID="-1">
          <TagInfo TagNo="152" CountTypeID="-1" />
          <TagInfo TagNo="153" CountTypeID="-1" />
          <TagInfo TagNo="154" CountTypeID="-1" />
          <TagInfo TagNo="155" CountTypeID="-1" />
          <TagInfo TagNo="156" CountTypeID="-1" />
          <TagInfo TagNo="157" CountTypeID="-1" />
          <TagInfo TagNo="158" CountTypeID="-1" />
          <TagInfo TagNo="159" CountTypeID="-1" />
          <TagInfo TagNo="160" CountTypeID="-1" />
          <TagInfo TagNo="161" CountTypeID="-1" />
          <TagInfo TagNo="162" CountTypeID="-1" />
          <TagInfo TagNo="163" CountTypeID="-1" />
          <TagInfo TagNo="164" CountTypeID="-1" />
          <TagInfo TagNo="165" CountTypeID="-1" />
          <TagInfo TagNo="166" CountTypeID="-1" />
          <TagInfo TagNo="167" CountTypeID="-1" />
          <TagInfo TagNo="168" CountTypeID="-1" />
          <TagInfo TagNo="169" CountTypeID="-1" />
          <TagInfo TagNo="170" CountTypeID="-1" />
          <TagInfo TagNo="171" CountTypeID="-1" />
          <TagInfo TagNo="172" CountTypeID="-1" />
          <TagInfo TagNo="173" CountTypeID="-1" />
          <TagInfo TagNo="174" CountTypeID="-1" />
          <TagInfo TagNo="175" CountTypeID="-1" />
          <TagInfo TagNo="176" CountTypeID="-1" />
          <TagInfo TagNo="177" CountTypeID="-1" />
          <TagInfo TagNo="178" CountTypeID="-1" />
          <TagInfo TagNo="179" CountTypeID="-1" />
          <TagInfo TagNo="180" CountTypeID="-1" />
          <TagInfo TagNo="181" CountTypeID="-1" />
          <TagInfo TagNo="182" CountTypeID="-1" />
          <TagInfo TagNo="183" CountTypeID="-1" />
          <TagInfo TagNo="184" CountTypeID="-1" />
          <TagInfo TagNo="185" CountTypeID="-1" />
          <TagInfo TagNo="186" CountTypeID="-1" />
          <TagInfo TagNo="187" CountTypeID="-1" />
          <TagInfo TagNo="188" CountTypeID="-1" />
          <TagInfo TagNo="189" CountTypeID="-1" />
          <TagInfo TagNo="190" CountTypeID="-1" />
          <TagInfo TagNo="191" CountTypeID="-1" />
          <TagInfo TagNo="192" CountTypeID="-1" />
          <TagInfo TagNo="193" CountTypeID="-1" />
          <TagInfo TagNo="194" CountTypeID="-1" />
          <TagInfo TagNo="195" CountTypeID="-1" />
          <TagInfo TagNo="196" CountTypeID="-1" />
          <TagInfo TagNo="197" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="H&amp;B UPSTAIRS" TagRangeDescription="" TagRangeFrom="198" TagRangeTo="204" DefaultCountTypeID="-1">
          <TagInfo TagNo="198" CountTypeID="-1" />
          <TagInfo TagNo="199" CountTypeID="-1" />
          <TagInfo TagNo="200" CountTypeID="-1" />
          <TagInfo TagNo="201" CountTypeID="-1" />
          <TagInfo TagNo="202" CountTypeID="-1" />
          <TagInfo TagNo="203" CountTypeID="-1" />
          <TagInfo TagNo="204" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="GM Extra" TagRangeDescription="" TagRangeFrom="301" TagRangeTo="360" DefaultCountTypeID="-1">
          <TagInfo TagNo="301" CountTypeID="-1" />
          <TagInfo TagNo="302" CountTypeID="-1" />
          <TagInfo TagNo="303" CountTypeID="-1" />
          <TagInfo TagNo="304" CountTypeID="-1" />
          <TagInfo TagNo="305" CountTypeID="-1" />
          <TagInfo TagNo="306" CountTypeID="-1" />
          <TagInfo TagNo="307" CountTypeID="-1" />
          <TagInfo TagNo="308" CountTypeID="-1" />
          <TagInfo TagNo="309" CountTypeID="-1" />
          <TagInfo TagNo="310" CountTypeID="-1" />
          <TagInfo TagNo="311" CountTypeID="-1" />
          <TagInfo TagNo="312" CountTypeID="-1" />
          <TagInfo TagNo="313" CountTypeID="-1" />
          <TagInfo TagNo="314" CountTypeID="-1" />
          <TagInfo TagNo="315" CountTypeID="-1" />
          <TagInfo TagNo="316" CountTypeID="-1" />
          <TagInfo TagNo="317" CountTypeID="-1" />
          <TagInfo TagNo="318" CountTypeID="-1" />
          <TagInfo TagNo="319" CountTypeID="-1" />
          <TagInfo TagNo="320" CountTypeID="-1" />
          <TagInfo TagNo="321" CountTypeID="-1" />
          <TagInfo TagNo="322" CountTypeID="-1" />
          <TagInfo TagNo="323" CountTypeID="-1" />
          <TagInfo TagNo="324" CountTypeID="-1" />
          <TagInfo TagNo="325" CountTypeID="-1" />
          <TagInfo TagNo="326" CountTypeID="-1" />
          <TagInfo TagNo="327" CountTypeID="-1" />
          <TagInfo TagNo="328" CountTypeID="-1" />
          <TagInfo TagNo="329" CountTypeID="-1" />
          <TagInfo TagNo="330" CountTypeID="-1" />
          <TagInfo TagNo="331" CountTypeID="-1" />
          <TagInfo TagNo="332" CountTypeID="-1" />
          <TagInfo TagNo="333" CountTypeID="-1" />
          <TagInfo TagNo="334" CountTypeID="-1" />
          <TagInfo TagNo="335" CountTypeID="-1" />
          <TagInfo TagNo="336" CountTypeID="-1" />
          <TagInfo TagNo="337" CountTypeID="-1" />
          <TagInfo TagNo="338" CountTypeID="-1" />
          <TagInfo TagNo="339" CountTypeID="-1" />
          <TagInfo TagNo="340" CountTypeID="-1" />
          <TagInfo TagNo="341" CountTypeID="-1" />
          <TagInfo TagNo="342" CountTypeID="-1" />
          <TagInfo TagNo="343" CountTypeID="-1" />
          <TagInfo TagNo="344" CountTypeID="-1" />
          <TagInfo TagNo="345" CountTypeID="-1" />
          <TagInfo TagNo="346" CountTypeID="-1" />
          <TagInfo TagNo="347" CountTypeID="-1" />
          <TagInfo TagNo="348" CountTypeID="-1" />
          <TagInfo TagNo="349" CountTypeID="-1" />
          <TagInfo TagNo="350" CountTypeID="-1" />
          <TagInfo TagNo="351" CountTypeID="-1" />
          <TagInfo TagNo="352" CountTypeID="-1" />
          <TagInfo TagNo="353" CountTypeID="-1" />
          <TagInfo TagNo="354" CountTypeID="-1" />
          <TagInfo TagNo="355" CountTypeID="-1" />
          <TagInfo TagNo="356" CountTypeID="-1" />
          <TagInfo TagNo="357" CountTypeID="-1" />
          <TagInfo TagNo="358" CountTypeID="-1" />
          <TagInfo TagNo="359" CountTypeID="-1" />
          <TagInfo TagNo="360" CountTypeID="-1" />
        </TagRange>
      </GroupRange>
      <GroupRange GroupName="SCHEDULE 9`S" GroupDescription="">
        <TagRange TagRangeName="9A" TagRangeDescription="" TagRangeFrom="990" TagRangeTo="991" DefaultCountTypeID="-1">
          <TagInfo TagNo="990" CountTypeID="-1" />
          <TagInfo TagNo="991" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="9B" TagRangeDescription="" TagRangeFrom="1002" TagRangeTo="1002" DefaultCountTypeID="-1">
          <TagInfo TagNo="1002" CountTypeID="-1" />
        </TagRange>
      </GroupRange>
      <GroupRange GroupName="CHECKOUTS" GroupDescription="">
        <TagRange TagRangeName="TILLS" TagRangeDescription="" TagRangeFrom="2827" TagRangeTo="2870" DefaultCountTypeID="4">
          <TagInfo TagNo="2827" CountTypeID="4" />
          <TagInfo TagNo="2828" CountTypeID="4" />
          <TagInfo TagNo="2829" CountTypeID="4" />
          <TagInfo TagNo="2830" CountTypeID="4" />
          <TagInfo TagNo="2831" CountTypeID="4" />
          <TagInfo TagNo="2832" CountTypeID="4" />
          <TagInfo TagNo="2833" CountTypeID="4" />
          <TagInfo TagNo="2834" CountTypeID="4" />
          <TagInfo TagNo="2835" CountTypeID="4" />
          <TagInfo TagNo="2836" CountTypeID="4" />
          <TagInfo TagNo="2837" CountTypeID="4" />
          <TagInfo TagNo="2838" CountTypeID="4" />
          <TagInfo TagNo="2839" CountTypeID="4" />
          <TagInfo TagNo="2840" CountTypeID="4" />
          <TagInfo TagNo="2841" CountTypeID="4" />
          <TagInfo TagNo="2842" CountTypeID="4" />
          <TagInfo TagNo="2843" CountTypeID="4" />
          <TagInfo TagNo="2844" CountTypeID="4" />
          <TagInfo TagNo="2845" CountTypeID="4" />
          <TagInfo TagNo="2846" CountTypeID="4" />
          <TagInfo TagNo="2847" CountTypeID="4" />
          <TagInfo TagNo="2848" CountTypeID="4" />
          <TagInfo TagNo="2849" CountTypeID="4" />
          <TagInfo TagNo="2850" CountTypeID="4" />
          <TagInfo TagNo="2851" CountTypeID="4" />
          <TagInfo TagNo="2852" CountTypeID="4" />
          <TagInfo TagNo="2853" CountTypeID="4" />
          <TagInfo TagNo="2854" CountTypeID="4" />
          <TagInfo TagNo="2855" CountTypeID="4" />
          <TagInfo TagNo="2856" CountTypeID="4" />
          <TagInfo TagNo="2857" CountTypeID="4" />
          <TagInfo TagNo="2858" CountTypeID="4" />
          <TagInfo TagNo="2859" CountTypeID="4" />
          <TagInfo TagNo="2860" CountTypeID="4" />
          <TagInfo TagNo="2861" CountTypeID="4" />
          <TagInfo TagNo="2862" CountTypeID="4" />
          <TagInfo TagNo="2863" CountTypeID="4" />
          <TagInfo TagNo="2864" CountTypeID="4" />
          <TagInfo TagNo="2865" CountTypeID="4" />
          <TagInfo TagNo="2866" CountTypeID="4" />
          <TagInfo TagNo="2867" CountTypeID="4" />
          <TagInfo TagNo="2868" CountTypeID="4" />
          <TagInfo TagNo="2869" CountTypeID="4" />
          <TagInfo TagNo="2870" CountTypeID="4" />
        </TagRange>
      </GroupRange>
      <GroupRange GroupName="FRESH" GroupDescription="">
        <TagRange TagRangeName="FOOD TO GO" TagRangeDescription="" TagRangeFrom="2871" TagRangeTo="2878" DefaultCountTypeID="69">
          <TagInfo TagNo="2871" CountTypeID="69" />
          <TagInfo TagNo="2872" CountTypeID="69" />
          <TagInfo TagNo="2873" CountTypeID="69" />
          <TagInfo TagNo="2874" CountTypeID="69" />
          <TagInfo TagNo="2875" CountTypeID="69" />
          <TagInfo TagNo="2876" CountTypeID="69" />
          <TagInfo TagNo="2877" CountTypeID="69" />
          <TagInfo TagNo="2878" CountTypeID="69" />
        </TagRange>
        <TagRange TagRangeName="PRODUCE" TagRangeDescription="" TagRangeFrom="3113" TagRangeTo="3181" DefaultCountTypeID="102">
          <TagInfo TagNo="3113" CountTypeID="102" />
          <TagInfo TagNo="3114" CountTypeID="102" />
          <TagInfo TagNo="3115" CountTypeID="102" />
          <TagInfo TagNo="3116" CountTypeID="102" />
          <TagInfo TagNo="3117" CountTypeID="102" />
          <TagInfo TagNo="3118" CountTypeID="102" />
          <TagInfo TagNo="3119" CountTypeID="102" />
          <TagInfo TagNo="3120" CountTypeID="102" />
          <TagInfo TagNo="3121" CountTypeID="102" />
          <TagInfo TagNo="3122" CountTypeID="102" />
          <TagInfo TagNo="3123" CountTypeID="102" />
          <TagInfo TagNo="3124" CountTypeID="102" />
          <TagInfo TagNo="3125" CountTypeID="102" />
          <TagInfo TagNo="3126" CountTypeID="102" />
          <TagInfo TagNo="3127" CountTypeID="102" />
          <TagInfo TagNo="3128" CountTypeID="102" />
          <TagInfo TagNo="3129" CountTypeID="102" />
          <TagInfo TagNo="3130" CountTypeID="102" />
          <TagInfo TagNo="3131" CountTypeID="102" />
          <TagInfo TagNo="3132" CountTypeID="102" />
          <TagInfo TagNo="3133" CountTypeID="102" />
          <TagInfo TagNo="3134" CountTypeID="102" />
          <TagInfo TagNo="3135" CountTypeID="102" />
          <TagInfo TagNo="3136" CountTypeID="102" />
          <TagInfo TagNo="3137" CountTypeID="102" />
          <TagInfo TagNo="3138" CountTypeID="102" />
          <TagInfo TagNo="3139" CountTypeID="102" />
          <TagInfo TagNo="3140" CountTypeID="102" />
          <TagInfo TagNo="3141" CountTypeID="102" />
          <TagInfo TagNo="3142" CountTypeID="102" />
          <TagInfo TagNo="3143" CountTypeID="102" />
          <TagInfo TagNo="3144" CountTypeID="102" />
          <TagInfo TagNo="3145" CountTypeID="102" />
          <TagInfo TagNo="3146" CountTypeID="102" />
          <TagInfo TagNo="3147" CountTypeID="102" />
          <TagInfo TagNo="3148" CountTypeID="102" />
          <TagInfo TagNo="3149" CountTypeID="102" />
          <TagInfo TagNo="3150" CountTypeID="102" />
          <TagInfo TagNo="3151" CountTypeID="102" />
          <TagInfo TagNo="3152" CountTypeID="102" />
          <TagInfo TagNo="3153" CountTypeID="102" />
          <TagInfo TagNo="3154" CountTypeID="102" />
          <TagInfo TagNo="3155" CountTypeID="102" />
          <TagInfo TagNo="3156" CountTypeID="102" />
          <TagInfo TagNo="3157" CountTypeID="102" />
          <TagInfo TagNo="3158" CountTypeID="102" />
          <TagInfo TagNo="3159" CountTypeID="102" />
          <TagInfo TagNo="3160" CountTypeID="102" />
          <TagInfo TagNo="3161" CountTypeID="102" />
          <TagInfo TagNo="3162" CountTypeID="102" />
          <TagInfo TagNo="3163" CountTypeID="102" />
          <TagInfo TagNo="3164" CountTypeID="102" />
          <TagInfo TagNo="3165" CountTypeID="102" />
          <TagInfo TagNo="3166" CountTypeID="102" />
          <TagInfo TagNo="3167" CountTypeID="102" />
          <TagInfo TagNo="3168" CountTypeID="102" />
          <TagInfo TagNo="3169" CountTypeID="102" />
          <TagInfo TagNo="3170" CountTypeID="102" />
          <TagInfo TagNo="3171" CountTypeID="102" />
          <TagInfo TagNo="3172" CountTypeID="102" />
          <TagInfo TagNo="3173" CountTypeID="102" />
          <TagInfo TagNo="3174" CountTypeID="102" />
          <TagInfo TagNo="3175" CountTypeID="102" />
          <TagInfo TagNo="3176" CountTypeID="102" />
          <TagInfo TagNo="3177" CountTypeID="102" />
          <TagInfo TagNo="3178" CountTypeID="102" />
          <TagInfo TagNo="3179" CountTypeID="102" />
          <TagInfo TagNo="3180" CountTypeID="102" />
          <TagInfo TagNo="3181" CountTypeID="102" />
        </TagRange>
        <TagRange TagRangeName="FROZEN" TagRangeDescription="" TagRangeFrom="3651" TagRangeTo="3793" DefaultCountTypeID="69">
          <TagInfo TagNo="3651" CountTypeID="69" />
          <TagInfo TagNo="3652" CountTypeID="69" />
          <TagInfo TagNo="3653" CountTypeID="69" />
          <TagInfo TagNo="3654" CountTypeID="69" />
          <TagInfo TagNo="3655" CountTypeID="69" />
          <TagInfo TagNo="3656" CountTypeID="69" />
          <TagInfo TagNo="3657" CountTypeID="69" />
          <TagInfo TagNo="3658" CountTypeID="69" />
          <TagInfo TagNo="3659" CountTypeID="69" />
          <TagInfo TagNo="3660" CountTypeID="69" />
          <TagInfo TagNo="3661" CountTypeID="69" />
          <TagInfo TagNo="3662" CountTypeID="69" />
          <TagInfo TagNo="3663" CountTypeID="69" />
          <TagInfo TagNo="3664" CountTypeID="69" />
          <TagInfo TagNo="3665" CountTypeID="69" />
          <TagInfo TagNo="3666" CountTypeID="69" />
          <TagInfo TagNo="3667" CountTypeID="69" />
          <TagInfo TagNo="3668" CountTypeID="69" />
          <TagInfo TagNo="3669" CountTypeID="69" />
          <TagInfo TagNo="3670" CountTypeID="69" />
          <TagInfo TagNo="3671" CountTypeID="69" />
          <TagInfo TagNo="3672" CountTypeID="69" />
          <TagInfo TagNo="3673" CountTypeID="69" />
          <TagInfo TagNo="3674" CountTypeID="69" />
          <TagInfo TagNo="3675" CountTypeID="69" />
          <TagInfo TagNo="3676" CountTypeID="69" />
          <TagInfo TagNo="3677" CountTypeID="69" />
          <TagInfo TagNo="3678" CountTypeID="69" />
          <TagInfo TagNo="3679" CountTypeID="69" />
          <TagInfo TagNo="3680" CountTypeID="69" />
          <TagInfo TagNo="3681" CountTypeID="69" />
          <TagInfo TagNo="3682" CountTypeID="69" />
          <TagInfo TagNo="3683" CountTypeID="69" />
          <TagInfo TagNo="3684" CountTypeID="69" />
          <TagInfo TagNo="3685" CountTypeID="69" />
          <TagInfo TagNo="3686" CountTypeID="69" />
          <TagInfo TagNo="3687" CountTypeID="69" />
          <TagInfo TagNo="3688" CountTypeID="69" />
          <TagInfo TagNo="3689" CountTypeID="69" />
          <TagInfo TagNo="3690" CountTypeID="69" />
          <TagInfo TagNo="3691" CountTypeID="69" />
          <TagInfo TagNo="3692" CountTypeID="69" />
          <TagInfo TagNo="3693" CountTypeID="69" />
          <TagInfo TagNo="3694" CountTypeID="69" />
          <TagInfo TagNo="3695" CountTypeID="69" />
          <TagInfo TagNo="3696" CountTypeID="69" />
          <TagInfo TagNo="3697" CountTypeID="69" />
          <TagInfo TagNo="3698" CountTypeID="69" />
          <TagInfo TagNo="3699" CountTypeID="69" />
          <TagInfo TagNo="3700" CountTypeID="69" />
          <TagInfo TagNo="3701" CountTypeID="69" />
          <TagInfo TagNo="3702" CountTypeID="69" />
          <TagInfo TagNo="3703" CountTypeID="69" />
          <TagInfo TagNo="3704" CountTypeID="69" />
          <TagInfo TagNo="3705" CountTypeID="69" />
          <TagInfo TagNo="3706" CountTypeID="69" />
          <TagInfo TagNo="3707" CountTypeID="69" />
          <TagInfo TagNo="3708" CountTypeID="69" />
          <TagInfo TagNo="3709" CountTypeID="69" />
          <TagInfo TagNo="3710" CountTypeID="69" />
          <TagInfo TagNo="3711" CountTypeID="69" />
          <TagInfo TagNo="3712" CountTypeID="69" />
          <TagInfo TagNo="3713" CountTypeID="69" />
          <TagInfo TagNo="3714" CountTypeID="69" />
          <TagInfo TagNo="3715" CountTypeID="69" />
          <TagInfo TagNo="3716" CountTypeID="69" />
          <TagInfo TagNo="3717" CountTypeID="69" />
          <TagInfo TagNo="3718" CountTypeID="69" />
          <TagInfo TagNo="3719" CountTypeID="69" />
          <TagInfo TagNo="3720" CountTypeID="69" />
          <TagInfo TagNo="3721" CountTypeID="69" />
          <TagInfo TagNo="3722" CountTypeID="69" />
          <TagInfo TagNo="3723" CountTypeID="69" />
          <TagInfo TagNo="3724" CountTypeID="69" />
          <TagInfo TagNo="3725" CountTypeID="69" />
          <TagInfo TagNo="3726" CountTypeID="69" />
          <TagInfo TagNo="3727" CountTypeID="69" />
          <TagInfo TagNo="3728" CountTypeID="69" />
          <TagInfo TagNo="3729" CountTypeID="69" />
          <TagInfo TagNo="3730" CountTypeID="69" />
          <TagInfo TagNo="3731" CountTypeID="69" />
          <TagInfo TagNo="3732" CountTypeID="69" />
          <TagInfo TagNo="3733" CountTypeID="69" />
          <TagInfo TagNo="3734" CountTypeID="69" />
          <TagInfo TagNo="3735" CountTypeID="69" />
          <TagInfo TagNo="3736" CountTypeID="69" />
          <TagInfo TagNo="3737" CountTypeID="69" />
          <TagInfo TagNo="3738" CountTypeID="69" />
          <TagInfo TagNo="3739" CountTypeID="69" />
          <TagInfo TagNo="3740" CountTypeID="69" />
          <TagInfo TagNo="3741" CountTypeID="69" />
          <TagInfo TagNo="3742" CountTypeID="69" />
          <TagInfo TagNo="3743" CountTypeID="69" />
          <TagInfo TagNo="3744" CountTypeID="69" />
          <TagInfo TagNo="3745" CountTypeID="69" />
          <TagInfo TagNo="3746" CountTypeID="69" />
          <TagInfo TagNo="3747" CountTypeID="69" />
          <TagInfo TagNo="3748" CountTypeID="69" />
          <TagInfo TagNo="3749" CountTypeID="69" />
          <TagInfo TagNo="3750" CountTypeID="69" />
          <TagInfo TagNo="3751" CountTypeID="69" />
          <TagInfo TagNo="3752" CountTypeID="69" />
          <TagInfo TagNo="3753" CountTypeID="69" />
          <TagInfo TagNo="3754" CountTypeID="69" />
          <TagInfo TagNo="3755" CountTypeID="69" />
          <TagInfo TagNo="3756" CountTypeID="69" />
          <TagInfo TagNo="3757" CountTypeID="69" />
          <TagInfo TagNo="3758" CountTypeID="69" />
          <TagInfo TagNo="3759" CountTypeID="69" />
          <TagInfo TagNo="3760" CountTypeID="69" />
          <TagInfo TagNo="3761" CountTypeID="69" />
          <TagInfo TagNo="3762" CountTypeID="69" />
          <TagInfo TagNo="3763" CountTypeID="69" />
          <TagInfo TagNo="3764" CountTypeID="69" />
          <TagInfo TagNo="3765" CountTypeID="69" />
          <TagInfo TagNo="3766" CountTypeID="69" />
          <TagInfo TagNo="3767" CountTypeID="69" />
          <TagInfo TagNo="3768" CountTypeID="69" />
          <TagInfo TagNo="3769" CountTypeID="69" />
          <TagInfo TagNo="3770" CountTypeID="69" />
          <TagInfo TagNo="3771" CountTypeID="69" />
          <TagInfo TagNo="3772" CountTypeID="69" />
          <TagInfo TagNo="3773" CountTypeID="69" />
          <TagInfo TagNo="3774" CountTypeID="69" />
          <TagInfo TagNo="3775" CountTypeID="69" />
          <TagInfo TagNo="3776" CountTypeID="69" />
          <TagInfo TagNo="3777" CountTypeID="69" />
          <TagInfo TagNo="3778" CountTypeID="69" />
          <TagInfo TagNo="3779" CountTypeID="69" />
          <TagInfo TagNo="3780" CountTypeID="69" />
          <TagInfo TagNo="3781" CountTypeID="69" />
          <TagInfo TagNo="3782" CountTypeID="69" />
          <TagInfo TagNo="3783" CountTypeID="69" />
          <TagInfo TagNo="3784" CountTypeID="69" />
          <TagInfo TagNo="3785" CountTypeID="69" />
          <TagInfo TagNo="3786" CountTypeID="69" />
          <TagInfo TagNo="3787" CountTypeID="69" />
          <TagInfo TagNo="3788" CountTypeID="69" />
          <TagInfo TagNo="3789" CountTypeID="69" />
          <TagInfo TagNo="3790" CountTypeID="69" />
          <TagInfo TagNo="3791" CountTypeID="69" />
          <TagInfo TagNo="3792" CountTypeID="69" />
          <TagInfo TagNo="3793" CountTypeID="69" />
        </TagRange>
        <TagRange TagRangeName="BIBC" TagRangeDescription="" TagRangeFrom="3794" TagRangeTo="3845" DefaultCountTypeID="103">
          <TagInfo TagNo="3794" CountTypeID="103" />
          <TagInfo TagNo="3795" CountTypeID="103" />
          <TagInfo TagNo="3796" CountTypeID="103" />
          <TagInfo TagNo="3797" CountTypeID="103" />
          <TagInfo TagNo="3798" CountTypeID="103" />
          <TagInfo TagNo="3799" CountTypeID="103" />
          <TagInfo TagNo="3800" CountTypeID="103" />
          <TagInfo TagNo="3801" CountTypeID="103" />
          <TagInfo TagNo="3802" CountTypeID="103" />
          <TagInfo TagNo="3803" CountTypeID="103" />
          <TagInfo TagNo="3804" CountTypeID="103" />
          <TagInfo TagNo="3805" CountTypeID="103" />
          <TagInfo TagNo="3806" CountTypeID="103" />
          <TagInfo TagNo="3807" CountTypeID="103" />
          <TagInfo TagNo="3808" CountTypeID="103" />
          <TagInfo TagNo="3809" CountTypeID="103" />
          <TagInfo TagNo="3810" CountTypeID="103" />
          <TagInfo TagNo="3811" CountTypeID="103" />
          <TagInfo TagNo="3812" CountTypeID="103" />
          <TagInfo TagNo="3813" CountTypeID="103" />
          <TagInfo TagNo="3814" CountTypeID="103" />
          <TagInfo TagNo="3815" CountTypeID="103" />
          <TagInfo TagNo="3816" CountTypeID="103" />
          <TagInfo TagNo="3817" CountTypeID="103" />
          <TagInfo TagNo="3818" CountTypeID="103" />
          <TagInfo TagNo="3819" CountTypeID="103" />
          <TagInfo TagNo="3820" CountTypeID="103" />
          <TagInfo TagNo="3821" CountTypeID="103" />
          <TagInfo TagNo="3822" CountTypeID="103" />
          <TagInfo TagNo="3823" CountTypeID="103" />
          <TagInfo TagNo="3824" CountTypeID="103" />
          <TagInfo TagNo="3825" CountTypeID="103" />
          <TagInfo TagNo="3826" CountTypeID="103" />
          <TagInfo TagNo="3827" CountTypeID="103" />
          <TagInfo TagNo="3828" CountTypeID="103" />
          <TagInfo TagNo="3829" CountTypeID="103" />
          <TagInfo TagNo="3830" CountTypeID="103" />
          <TagInfo TagNo="3831" CountTypeID="103" />
          <TagInfo TagNo="3832" CountTypeID="103" />
          <TagInfo TagNo="3833" CountTypeID="103" />
          <TagInfo TagNo="3834" CountTypeID="103" />
          <TagInfo TagNo="3835" CountTypeID="103" />
          <TagInfo TagNo="3836" CountTypeID="103" />
          <TagInfo TagNo="3837" CountTypeID="103" />
          <TagInfo TagNo="3838" CountTypeID="103" />
          <TagInfo TagNo="3839" CountTypeID="103" />
          <TagInfo TagNo="3840" CountTypeID="103" />
          <TagInfo TagNo="3841" CountTypeID="103" />
          <TagInfo TagNo="3842" CountTypeID="103" />
          <TagInfo TagNo="3843" CountTypeID="103" />
          <TagInfo TagNo="3844" CountTypeID="103" />
          <TagInfo TagNo="3845" CountTypeID="103" />
        </TagRange>
        <TagRange TagRangeName="CHILLED" TagRangeDescription="" TagRangeFrom="4321" TagRangeTo="4453" DefaultCountTypeID="69">
          <TagInfo TagNo="4321" CountTypeID="69" />
          <TagInfo TagNo="4322" CountTypeID="69" />
          <TagInfo TagNo="4323" CountTypeID="69" />
          <TagInfo TagNo="4324" CountTypeID="69" />
          <TagInfo TagNo="4325" CountTypeID="69" />
          <TagInfo TagNo="4326" CountTypeID="69" />
          <TagInfo TagNo="4327" CountTypeID="69" />
          <TagInfo TagNo="4328" CountTypeID="69" />
          <TagInfo TagNo="4329" CountTypeID="69" />
          <TagInfo TagNo="4330" CountTypeID="69" />
          <TagInfo TagNo="4331" CountTypeID="69" />
          <TagInfo TagNo="4332" CountTypeID="69" />
          <TagInfo TagNo="4333" CountTypeID="69" />
          <TagInfo TagNo="4334" CountTypeID="69" />
          <TagInfo TagNo="4335" CountTypeID="69" />
          <TagInfo TagNo="4336" CountTypeID="69" />
          <TagInfo TagNo="4337" CountTypeID="69" />
          <TagInfo TagNo="4338" CountTypeID="69" />
          <TagInfo TagNo="4339" CountTypeID="69" />
          <TagInfo TagNo="4340" CountTypeID="69" />
          <TagInfo TagNo="4341" CountTypeID="69" />
          <TagInfo TagNo="4342" CountTypeID="69" />
          <TagInfo TagNo="4343" CountTypeID="69" />
          <TagInfo TagNo="4344" CountTypeID="69" />
          <TagInfo TagNo="4345" CountTypeID="69" />
          <TagInfo TagNo="4346" CountTypeID="69" />
          <TagInfo TagNo="4347" CountTypeID="69" />
          <TagInfo TagNo="4348" CountTypeID="69" />
          <TagInfo TagNo="4349" CountTypeID="69" />
          <TagInfo TagNo="4350" CountTypeID="69" />
          <TagInfo TagNo="4351" CountTypeID="69" />
          <TagInfo TagNo="4352" CountTypeID="69" />
          <TagInfo TagNo="4353" CountTypeID="69" />
          <TagInfo TagNo="4354" CountTypeID="69" />
          <TagInfo TagNo="4355" CountTypeID="69" />
          <TagInfo TagNo="4356" CountTypeID="69" />
          <TagInfo TagNo="4357" CountTypeID="69" />
          <TagInfo TagNo="4358" CountTypeID="69" />
          <TagInfo TagNo="4359" CountTypeID="69" />
          <TagInfo TagNo="4360" CountTypeID="69" />
          <TagInfo TagNo="4361" CountTypeID="69" />
          <TagInfo TagNo="4362" CountTypeID="69" />
          <TagInfo TagNo="4363" CountTypeID="69" />
          <TagInfo TagNo="4364" CountTypeID="69" />
          <TagInfo TagNo="4365" CountTypeID="69" />
          <TagInfo TagNo="4366" CountTypeID="69" />
          <TagInfo TagNo="4367" CountTypeID="69" />
          <TagInfo TagNo="4368" CountTypeID="69" />
          <TagInfo TagNo="4369" CountTypeID="69" />
          <TagInfo TagNo="4370" CountTypeID="69" />
          <TagInfo TagNo="4371" CountTypeID="69" />
          <TagInfo TagNo="4372" CountTypeID="69" />
          <TagInfo TagNo="4373" CountTypeID="69" />
          <TagInfo TagNo="4374" CountTypeID="69" />
          <TagInfo TagNo="4375" CountTypeID="69" />
          <TagInfo TagNo="4376" CountTypeID="69" />
          <TagInfo TagNo="4377" CountTypeID="69" />
          <TagInfo TagNo="4378" CountTypeID="69" />
          <TagInfo TagNo="4379" CountTypeID="69" />
          <TagInfo TagNo="4380" CountTypeID="69" />
          <TagInfo TagNo="4381" CountTypeID="69" />
          <TagInfo TagNo="4382" CountTypeID="69" />
          <TagInfo TagNo="4383" CountTypeID="69" />
          <TagInfo TagNo="4384" CountTypeID="69" />
          <TagInfo TagNo="4385" CountTypeID="69" />
          <TagInfo TagNo="4386" CountTypeID="69" />
          <TagInfo TagNo="4387" CountTypeID="69" />
          <TagInfo TagNo="4388" CountTypeID="69" />
          <TagInfo TagNo="4389" CountTypeID="69" />
          <TagInfo TagNo="4390" CountTypeID="69" />
          <TagInfo TagNo="4391" CountTypeID="69" />
          <TagInfo TagNo="4392" CountTypeID="69" />
          <TagInfo TagNo="4393" CountTypeID="69" />
          <TagInfo TagNo="4394" CountTypeID="69" />
          <TagInfo TagNo="4395" CountTypeID="69" />
          <TagInfo TagNo="4396" CountTypeID="69" />
          <TagInfo TagNo="4397" CountTypeID="69" />
          <TagInfo TagNo="4398" CountTypeID="69" />
          <TagInfo TagNo="4399" CountTypeID="69" />
          <TagInfo TagNo="4400" CountTypeID="69" />
          <TagInfo TagNo="4401" CountTypeID="69" />
          <TagInfo TagNo="4402" CountTypeID="69" />
          <TagInfo TagNo="4403" CountTypeID="69" />
          <TagInfo TagNo="4404" CountTypeID="69" />
          <TagInfo TagNo="4405" CountTypeID="69" />
          <TagInfo TagNo="4406" CountTypeID="69" />
          <TagInfo TagNo="4407" CountTypeID="69" />
          <TagInfo TagNo="4408" CountTypeID="69" />
          <TagInfo TagNo="4409" CountTypeID="69" />
          <TagInfo TagNo="4410" CountTypeID="69" />
          <TagInfo TagNo="4411" CountTypeID="69" />
          <TagInfo TagNo="4412" CountTypeID="69" />
          <TagInfo TagNo="4413" CountTypeID="69" />
          <TagInfo TagNo="4414" CountTypeID="69" />
          <TagInfo TagNo="4415" CountTypeID="69" />
          <TagInfo TagNo="4416" CountTypeID="69" />
          <TagInfo TagNo="4417" CountTypeID="69" />
          <TagInfo TagNo="4418" CountTypeID="69" />
          <TagInfo TagNo="4419" CountTypeID="69" />
          <TagInfo TagNo="4420" CountTypeID="69" />
          <TagInfo TagNo="4421" CountTypeID="69" />
          <TagInfo TagNo="4422" CountTypeID="69" />
          <TagInfo TagNo="4423" CountTypeID="69" />
          <TagInfo TagNo="4424" CountTypeID="69" />
          <TagInfo TagNo="4425" CountTypeID="69" />
          <TagInfo TagNo="4426" CountTypeID="69" />
          <TagInfo TagNo="4427" CountTypeID="69" />
          <TagInfo TagNo="4428" CountTypeID="69" />
          <TagInfo TagNo="4429" CountTypeID="69" />
          <TagInfo TagNo="4430" CountTypeID="69" />
          <TagInfo TagNo="4431" CountTypeID="69" />
          <TagInfo TagNo="4432" CountTypeID="69" />
          <TagInfo TagNo="4433" CountTypeID="69" />
          <TagInfo TagNo="4434" CountTypeID="69" />
          <TagInfo TagNo="4435" CountTypeID="69" />
          <TagInfo TagNo="4436" CountTypeID="69" />
          <TagInfo TagNo="4437" CountTypeID="69" />
          <TagInfo TagNo="4438" CountTypeID="69" />
          <TagInfo TagNo="4439" CountTypeID="69" />
          <TagInfo TagNo="4440" CountTypeID="69" />
          <TagInfo TagNo="4441" CountTypeID="69" />
          <TagInfo TagNo="4442" CountTypeID="69" />
          <TagInfo TagNo="4443" CountTypeID="69" />
          <TagInfo TagNo="4444" CountTypeID="69" />
          <TagInfo TagNo="4445" CountTypeID="69" />
          <TagInfo TagNo="4446" CountTypeID="69" />
          <TagInfo TagNo="4447" CountTypeID="69" />
          <TagInfo TagNo="4448" CountTypeID="69" />
          <TagInfo TagNo="4449" CountTypeID="69" />
          <TagInfo TagNo="4450" CountTypeID="69" />
          <TagInfo TagNo="4451" CountTypeID="69" />
          <TagInfo TagNo="4452" CountTypeID="69" />
          <TagInfo TagNo="4453" CountTypeID="69" />
        </TagRange>
      </GroupRange>
      <GroupRange GroupName="GM" GroupDescription="">
        <TagRange TagRangeName="PHARMACY (DEPT 40)" TagRangeDescription="" TagRangeFrom="2001" TagRangeTo="2014" DefaultCountTypeID="20">
          <TagInfo TagNo="2001" CountTypeID="20" />
          <TagInfo TagNo="2002" CountTypeID="20" />
          <TagInfo TagNo="2003" CountTypeID="20" />
          <TagInfo TagNo="2004" CountTypeID="20" />
          <TagInfo TagNo="2005" CountTypeID="20" />
          <TagInfo TagNo="2006" CountTypeID="20" />
          <TagInfo TagNo="2007" CountTypeID="20" />
          <TagInfo TagNo="2008" CountTypeID="20" />
          <TagInfo TagNo="2009" CountTypeID="20" />
          <TagInfo TagNo="2010" CountTypeID="20" />
          <TagInfo TagNo="2011" CountTypeID="20" />
          <TagInfo TagNo="2012" CountTypeID="20" />
          <TagInfo TagNo="2013" CountTypeID="20" />
          <TagInfo TagNo="2014" CountTypeID="20" />
        </TagRange>
        <TagRange TagRangeName="NEWS CUBE" TagRangeDescription="" TagRangeFrom="2767" TagRangeTo="2767" DefaultCountTypeID="-1">
          <TagInfo TagNo="2767" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="FOYER" TagRangeDescription="" TagRangeFrom="2768" TagRangeTo="2826" DefaultCountTypeID="-1">
          <TagInfo TagNo="2768" CountTypeID="-1" />
          <TagInfo TagNo="2769" CountTypeID="-1" />
          <TagInfo TagNo="2770" CountTypeID="-1" />
          <TagInfo TagNo="2771" CountTypeID="-1" />
          <TagInfo TagNo="2772" CountTypeID="-1" />
          <TagInfo TagNo="2773" CountTypeID="-1" />
          <TagInfo TagNo="2774" CountTypeID="-1" />
          <TagInfo TagNo="2775" CountTypeID="-1" />
          <TagInfo TagNo="2776" CountTypeID="-1" />
          <TagInfo TagNo="2777" CountTypeID="-1" />
          <TagInfo TagNo="2778" CountTypeID="-1" />
          <TagInfo TagNo="2779" CountTypeID="-1" />
          <TagInfo TagNo="2780" CountTypeID="-1" />
          <TagInfo TagNo="2781" CountTypeID="-1" />
          <TagInfo TagNo="2782" CountTypeID="-1" />
          <TagInfo TagNo="2783" CountTypeID="-1" />
          <TagInfo TagNo="2784" CountTypeID="-1" />
          <TagInfo TagNo="2785" CountTypeID="-1" />
          <TagInfo TagNo="2786" CountTypeID="-1" />
          <TagInfo TagNo="2787" CountTypeID="-1" />
          <TagInfo TagNo="2788" CountTypeID="-1" />
          <TagInfo TagNo="2789" CountTypeID="-1" />
          <TagInfo TagNo="2790" CountTypeID="-1" />
          <TagInfo TagNo="2791" CountTypeID="-1" />
          <TagInfo TagNo="2792" CountTypeID="-1" />
          <TagInfo TagNo="2793" CountTypeID="-1" />
          <TagInfo TagNo="2794" CountTypeID="-1" />
          <TagInfo TagNo="2795" CountTypeID="-1" />
          <TagInfo TagNo="2796" CountTypeID="-1" />
          <TagInfo TagNo="2797" CountTypeID="-1" />
          <TagInfo TagNo="2798" CountTypeID="-1" />
          <TagInfo TagNo="2799" CountTypeID="-1" />
          <TagInfo TagNo="2800" CountTypeID="-1" />
          <TagInfo TagNo="2801" CountTypeID="-1" />
          <TagInfo TagNo="2802" CountTypeID="-1" />
          <TagInfo TagNo="2803" CountTypeID="-1" />
          <TagInfo TagNo="2804" CountTypeID="-1" />
          <TagInfo TagNo="2805" CountTypeID="-1" />
          <TagInfo TagNo="2806" CountTypeID="-1" />
          <TagInfo TagNo="2807" CountTypeID="-1" />
          <TagInfo TagNo="2808" CountTypeID="-1" />
          <TagInfo TagNo="2809" CountTypeID="-1" />
          <TagInfo TagNo="2810" CountTypeID="-1" />
          <TagInfo TagNo="2811" CountTypeID="-1" />
          <TagInfo TagNo="2812" CountTypeID="-1" />
          <TagInfo TagNo="2813" CountTypeID="-1" />
          <TagInfo TagNo="2814" CountTypeID="-1" />
          <TagInfo TagNo="2815" CountTypeID="-1" />
          <TagInfo TagNo="2816" CountTypeID="-1" />
          <TagInfo TagNo="2817" CountTypeID="-1" />
          <TagInfo TagNo="2818" CountTypeID="-1" />
          <TagInfo TagNo="2819" CountTypeID="-1" />
          <TagInfo TagNo="2820" CountTypeID="-1" />
          <TagInfo TagNo="2821" CountTypeID="-1" />
          <TagInfo TagNo="2822" CountTypeID="-1" />
          <TagInfo TagNo="2823" CountTypeID="-1" />
          <TagInfo TagNo="2824" CountTypeID="-1" />
          <TagInfo TagNo="2825" CountTypeID="-1" />
          <TagInfo TagNo="2826" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="GM FRONTLINE" TagRangeDescription="" TagRangeFrom="2879" TagRangeTo="3099" DefaultCountTypeID="-1">
          <TagInfo TagNo="2879" CountTypeID="-1" />
          <TagInfo TagNo="2880" CountTypeID="-1" />
          <TagInfo TagNo="2881" CountTypeID="-1" />
          <TagInfo TagNo="2882" CountTypeID="-1" />
          <TagInfo TagNo="2883" CountTypeID="-1" />
          <TagInfo TagNo="2884" CountTypeID="-1" />
          <TagInfo TagNo="2885" CountTypeID="-1" />
          <TagInfo TagNo="2886" CountTypeID="-1" />
          <TagInfo TagNo="2887" CountTypeID="-1" />
          <TagInfo TagNo="2888" CountTypeID="-1" />
          <TagInfo TagNo="2889" CountTypeID="-1" />
          <TagInfo TagNo="2890" CountTypeID="-1" />
          <TagInfo TagNo="2891" CountTypeID="-1" />
          <TagInfo TagNo="2892" CountTypeID="-1" />
          <TagInfo TagNo="2893" CountTypeID="-1" />
          <TagInfo TagNo="2894" CountTypeID="-1" />
          <TagInfo TagNo="2895" CountTypeID="-1" />
          <TagInfo TagNo="2896" CountTypeID="-1" />
          <TagInfo TagNo="2897" CountTypeID="-1" />
          <TagInfo TagNo="2898" CountTypeID="-1" />
          <TagInfo TagNo="2899" CountTypeID="-1" />
          <TagInfo TagNo="2900" CountTypeID="-1" />
          <TagInfo TagNo="2901" CountTypeID="-1" />
          <TagInfo TagNo="2902" CountTypeID="-1" />
          <TagInfo TagNo="2903" CountTypeID="-1" />
          <TagInfo TagNo="2904" CountTypeID="-1" />
          <TagInfo TagNo="2905" CountTypeID="-1" />
          <TagInfo TagNo="2906" CountTypeID="-1" />
          <TagInfo TagNo="2907" CountTypeID="-1" />
          <TagInfo TagNo="2908" CountTypeID="-1" />
          <TagInfo TagNo="2909" CountTypeID="-1" />
          <TagInfo TagNo="2910" CountTypeID="-1" />
          <TagInfo TagNo="2911" CountTypeID="-1" />
          <TagInfo TagNo="2912" CountTypeID="-1" />
          <TagInfo TagNo="2913" CountTypeID="-1" />
          <TagInfo TagNo="2914" CountTypeID="-1" />
          <TagInfo TagNo="2915" CountTypeID="-1" />
          <TagInfo TagNo="2916" CountTypeID="-1" />
          <TagInfo TagNo="2917" CountTypeID="-1" />
          <TagInfo TagNo="2918" CountTypeID="-1" />
          <TagInfo TagNo="2919" CountTypeID="-1" />
          <TagInfo TagNo="2920" CountTypeID="-1" />
          <TagInfo TagNo="2921" CountTypeID="-1" />
          <TagInfo TagNo="2922" CountTypeID="-1" />
          <TagInfo TagNo="2923" CountTypeID="-1" />
          <TagInfo TagNo="2924" CountTypeID="-1" />
          <TagInfo TagNo="2925" CountTypeID="-1" />
          <TagInfo TagNo="2926" CountTypeID="-1" />
          <TagInfo TagNo="2927" CountTypeID="-1" />
          <TagInfo TagNo="2928" CountTypeID="-1" />
          <TagInfo TagNo="2929" CountTypeID="-1" />
          <TagInfo TagNo="2930" CountTypeID="-1" />
          <TagInfo TagNo="2931" CountTypeID="-1" />
          <TagInfo TagNo="2932" CountTypeID="-1" />
          <TagInfo TagNo="2933" CountTypeID="-1" />
          <TagInfo TagNo="2934" CountTypeID="-1" />
          <TagInfo TagNo="2935" CountTypeID="-1" />
          <TagInfo TagNo="2936" CountTypeID="-1" />
          <TagInfo TagNo="2937" CountTypeID="-1" />
          <TagInfo TagNo="2938" CountTypeID="-1" />
          <TagInfo TagNo="2939" CountTypeID="-1" />
          <TagInfo TagNo="2940" CountTypeID="-1" />
          <TagInfo TagNo="2941" CountTypeID="-1" />
          <TagInfo TagNo="2942" CountTypeID="-1" />
          <TagInfo TagNo="2943" CountTypeID="-1" />
          <TagInfo TagNo="2944" CountTypeID="-1" />
          <TagInfo TagNo="2945" CountTypeID="-1" />
          <TagInfo TagNo="2946" CountTypeID="-1" />
          <TagInfo TagNo="2947" CountTypeID="-1" />
          <TagInfo TagNo="2948" CountTypeID="-1" />
          <TagInfo TagNo="2949" CountTypeID="-1" />
          <TagInfo TagNo="2950" CountTypeID="-1" />
          <TagInfo TagNo="2951" CountTypeID="-1" />
          <TagInfo TagNo="2952" CountTypeID="-1" />
          <TagInfo TagNo="2953" CountTypeID="-1" />
          <TagInfo TagNo="2954" CountTypeID="-1" />
          <TagInfo TagNo="2955" CountTypeID="-1" />
          <TagInfo TagNo="2956" CountTypeID="-1" />
          <TagInfo TagNo="2957" CountTypeID="-1" />
          <TagInfo TagNo="2958" CountTypeID="-1" />
          <TagInfo TagNo="2959" CountTypeID="-1" />
          <TagInfo TagNo="2960" CountTypeID="-1" />
          <TagInfo TagNo="2961" CountTypeID="-1" />
          <TagInfo TagNo="2962" CountTypeID="-1" />
          <TagInfo TagNo="2963" CountTypeID="-1" />
          <TagInfo TagNo="2964" CountTypeID="-1" />
          <TagInfo TagNo="2965" CountTypeID="-1" />
          <TagInfo TagNo="2966" CountTypeID="-1" />
          <TagInfo TagNo="2967" CountTypeID="-1" />
          <TagInfo TagNo="2968" CountTypeID="-1" />
          <TagInfo TagNo="2969" CountTypeID="-1" />
          <TagInfo TagNo="2970" CountTypeID="-1" />
          <TagInfo TagNo="2971" CountTypeID="-1" />
          <TagInfo TagNo="2972" CountTypeID="-1" />
          <TagInfo TagNo="2973" CountTypeID="-1" />
          <TagInfo TagNo="2974" CountTypeID="-1" />
          <TagInfo TagNo="2975" CountTypeID="-1" />
          <TagInfo TagNo="2976" CountTypeID="-1" />
          <TagInfo TagNo="2977" CountTypeID="-1" />
          <TagInfo TagNo="2978" CountTypeID="-1" />
          <TagInfo TagNo="2979" CountTypeID="-1" />
          <TagInfo TagNo="2980" CountTypeID="-1" />
          <TagInfo TagNo="2981" CountTypeID="-1" />
          <TagInfo TagNo="2982" CountTypeID="-1" />
          <TagInfo TagNo="2983" CountTypeID="-1" />
          <TagInfo TagNo="2984" CountTypeID="-1" />
          <TagInfo TagNo="2985" CountTypeID="-1" />
          <TagInfo TagNo="2986" CountTypeID="-1" />
          <TagInfo TagNo="2987" CountTypeID="-1" />
          <TagInfo TagNo="2988" CountTypeID="-1" />
          <TagInfo TagNo="2989" CountTypeID="-1" />
          <TagInfo TagNo="2990" CountTypeID="-1" />
          <TagInfo TagNo="2991" CountTypeID="-1" />
          <TagInfo TagNo="2992" CountTypeID="-1" />
          <TagInfo TagNo="2993" CountTypeID="-1" />
          <TagInfo TagNo="2994" CountTypeID="-1" />
          <TagInfo TagNo="2995" CountTypeID="-1" />
          <TagInfo TagNo="2996" CountTypeID="-1" />
          <TagInfo TagNo="2997" CountTypeID="-1" />
          <TagInfo TagNo="2998" CountTypeID="-1" />
          <TagInfo TagNo="2999" CountTypeID="-1" />
          <TagInfo TagNo="3000" CountTypeID="-1" />
          <TagInfo TagNo="3001" CountTypeID="-1" />
          <TagInfo TagNo="3002" CountTypeID="-1" />
          <TagInfo TagNo="3003" CountTypeID="-1" />
          <TagInfo TagNo="3004" CountTypeID="-1" />
          <TagInfo TagNo="3005" CountTypeID="-1" />
          <TagInfo TagNo="3006" CountTypeID="-1" />
          <TagInfo TagNo="3007" CountTypeID="-1" />
          <TagInfo TagNo="3008" CountTypeID="-1" />
          <TagInfo TagNo="3009" CountTypeID="-1" />
          <TagInfo TagNo="3010" CountTypeID="-1" />
          <TagInfo TagNo="3011" CountTypeID="-1" />
          <TagInfo TagNo="3012" CountTypeID="-1" />
          <TagInfo TagNo="3013" CountTypeID="-1" />
          <TagInfo TagNo="3014" CountTypeID="-1" />
          <TagInfo TagNo="3015" CountTypeID="-1" />
          <TagInfo TagNo="3016" CountTypeID="-1" />
          <TagInfo TagNo="3017" CountTypeID="-1" />
          <TagInfo TagNo="3018" CountTypeID="-1" />
          <TagInfo TagNo="3019" CountTypeID="-1" />
          <TagInfo TagNo="3020" CountTypeID="-1" />
          <TagInfo TagNo="3021" CountTypeID="-1" />
          <TagInfo TagNo="3022" CountTypeID="-1" />
          <TagInfo TagNo="3023" CountTypeID="-1" />
          <TagInfo TagNo="3024" CountTypeID="-1" />
          <TagInfo TagNo="3025" CountTypeID="-1" />
          <TagInfo TagNo="3026" CountTypeID="-1" />
          <TagInfo TagNo="3027" CountTypeID="-1" />
          <TagInfo TagNo="3028" CountTypeID="-1" />
          <TagInfo TagNo="3029" CountTypeID="-1" />
          <TagInfo TagNo="3030" CountTypeID="-1" />
          <TagInfo TagNo="3031" CountTypeID="-1" />
          <TagInfo TagNo="3032" CountTypeID="-1" />
          <TagInfo TagNo="3033" CountTypeID="-1" />
          <TagInfo TagNo="3034" CountTypeID="-1" />
          <TagInfo TagNo="3035" CountTypeID="-1" />
          <TagInfo TagNo="3036" CountTypeID="-1" />
          <TagInfo TagNo="3037" CountTypeID="-1" />
          <TagInfo TagNo="3038" CountTypeID="-1" />
          <TagInfo TagNo="3039" CountTypeID="-1" />
          <TagInfo TagNo="3040" CountTypeID="-1" />
          <TagInfo TagNo="3041" CountTypeID="-1" />
          <TagInfo TagNo="3042" CountTypeID="-1" />
          <TagInfo TagNo="3043" CountTypeID="-1" />
          <TagInfo TagNo="3044" CountTypeID="-1" />
          <TagInfo TagNo="3045" CountTypeID="-1" />
          <TagInfo TagNo="3046" CountTypeID="-1" />
          <TagInfo TagNo="3047" CountTypeID="-1" />
          <TagInfo TagNo="3048" CountTypeID="-1" />
          <TagInfo TagNo="3049" CountTypeID="-1" />
          <TagInfo TagNo="3050" CountTypeID="-1" />
          <TagInfo TagNo="3051" CountTypeID="-1" />
          <TagInfo TagNo="3052" CountTypeID="-1" />
          <TagInfo TagNo="3053" CountTypeID="-1" />
          <TagInfo TagNo="3054" CountTypeID="-1" />
          <TagInfo TagNo="3055" CountTypeID="-1" />
          <TagInfo TagNo="3056" CountTypeID="-1" />
          <TagInfo TagNo="3057" CountTypeID="-1" />
          <TagInfo TagNo="3058" CountTypeID="-1" />
          <TagInfo TagNo="3059" CountTypeID="-1" />
          <TagInfo TagNo="3060" CountTypeID="-1" />
          <TagInfo TagNo="3061" CountTypeID="-1" />
          <TagInfo TagNo="3062" CountTypeID="-1" />
          <TagInfo TagNo="3063" CountTypeID="-1" />
          <TagInfo TagNo="3064" CountTypeID="-1" />
          <TagInfo TagNo="3065" CountTypeID="-1" />
          <TagInfo TagNo="3066" CountTypeID="-1" />
          <TagInfo TagNo="3067" CountTypeID="-1" />
          <TagInfo TagNo="3068" CountTypeID="-1" />
          <TagInfo TagNo="3069" CountTypeID="-1" />
          <TagInfo TagNo="3070" CountTypeID="-1" />
          <TagInfo TagNo="3071" CountTypeID="-1" />
          <TagInfo TagNo="3072" CountTypeID="-1" />
          <TagInfo TagNo="3073" CountTypeID="-1" />
          <TagInfo TagNo="3074" CountTypeID="-1" />
          <TagInfo TagNo="3075" CountTypeID="-1" />
          <TagInfo TagNo="3076" CountTypeID="-1" />
          <TagInfo TagNo="3077" CountTypeID="-1" />
          <TagInfo TagNo="3078" CountTypeID="-1" />
          <TagInfo TagNo="3079" CountTypeID="-1" />
          <TagInfo TagNo="3080" CountTypeID="-1" />
          <TagInfo TagNo="3081" CountTypeID="-1" />
          <TagInfo TagNo="3082" CountTypeID="-1" />
          <TagInfo TagNo="3083" CountTypeID="-1" />
          <TagInfo TagNo="3084" CountTypeID="-1" />
          <TagInfo TagNo="3085" CountTypeID="-1" />
          <TagInfo TagNo="3086" CountTypeID="-1" />
          <TagInfo TagNo="3087" CountTypeID="-1" />
          <TagInfo TagNo="3088" CountTypeID="-1" />
          <TagInfo TagNo="3089" CountTypeID="-1" />
          <TagInfo TagNo="3090" CountTypeID="-1" />
          <TagInfo TagNo="3091" CountTypeID="-1" />
          <TagInfo TagNo="3092" CountTypeID="-1" />
          <TagInfo TagNo="3093" CountTypeID="-1" />
          <TagInfo TagNo="3094" CountTypeID="-1" />
          <TagInfo TagNo="3095" CountTypeID="-1" />
          <TagInfo TagNo="3096" CountTypeID="-1" />
          <TagInfo TagNo="3097" CountTypeID="-1" />
          <TagInfo TagNo="3098" CountTypeID="-1" />
          <TagInfo TagNo="3099" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="NEWS &amp; MAGS" TagRangeDescription="" TagRangeFrom="3100" TagRangeTo="3112" DefaultCountTypeID="-1">
          <TagInfo TagNo="3100" CountTypeID="-1" />
          <TagInfo TagNo="3101" CountTypeID="-1" />
          <TagInfo TagNo="3102" CountTypeID="-1" />
          <TagInfo TagNo="3103" CountTypeID="-1" />
          <TagInfo TagNo="3104" CountTypeID="-1" />
          <TagInfo TagNo="3105" CountTypeID="-1" />
          <TagInfo TagNo="3106" CountTypeID="-1" />
          <TagInfo TagNo="3107" CountTypeID="-1" />
          <TagInfo TagNo="3108" CountTypeID="-1" />
          <TagInfo TagNo="3109" CountTypeID="-1" />
          <TagInfo TagNo="3110" CountTypeID="-1" />
          <TagInfo TagNo="3111" CountTypeID="-1" />
          <TagInfo TagNo="3112" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="H&amp;B" TagRangeDescription="" TagRangeFrom="3182" TagRangeTo="3358" DefaultCountTypeID="21">
          <TagInfo TagNo="3182" CountTypeID="21" />
          <TagInfo TagNo="3183" CountTypeID="21" />
          <TagInfo TagNo="3184" CountTypeID="21" />
          <TagInfo TagNo="3185" CountTypeID="21" />
          <TagInfo TagNo="3186" CountTypeID="21" />
          <TagInfo TagNo="3187" CountTypeID="21" />
          <TagInfo TagNo="3188" CountTypeID="21" />
          <TagInfo TagNo="3189" CountTypeID="21" />
          <TagInfo TagNo="3190" CountTypeID="21" />
          <TagInfo TagNo="3191" CountTypeID="21" />
          <TagInfo TagNo="3192" CountTypeID="21" />
          <TagInfo TagNo="3193" CountTypeID="21" />
          <TagInfo TagNo="3194" CountTypeID="21" />
          <TagInfo TagNo="3195" CountTypeID="21" />
          <TagInfo TagNo="3196" CountTypeID="21" />
          <TagInfo TagNo="3197" CountTypeID="21" />
          <TagInfo TagNo="3198" CountTypeID="21" />
          <TagInfo TagNo="3199" CountTypeID="21" />
          <TagInfo TagNo="3200" CountTypeID="21" />
          <TagInfo TagNo="3201" CountTypeID="21" />
          <TagInfo TagNo="3202" CountTypeID="21" />
          <TagInfo TagNo="3203" CountTypeID="21" />
          <TagInfo TagNo="3204" CountTypeID="21" />
          <TagInfo TagNo="3205" CountTypeID="21" />
          <TagInfo TagNo="3206" CountTypeID="21" />
          <TagInfo TagNo="3207" CountTypeID="21" />
          <TagInfo TagNo="3208" CountTypeID="21" />
          <TagInfo TagNo="3209" CountTypeID="21" />
          <TagInfo TagNo="3210" CountTypeID="21" />
          <TagInfo TagNo="3211" CountTypeID="21" />
          <TagInfo TagNo="3212" CountTypeID="21" />
          <TagInfo TagNo="3213" CountTypeID="21" />
          <TagInfo TagNo="3214" CountTypeID="21" />
          <TagInfo TagNo="3215" CountTypeID="21" />
          <TagInfo TagNo="3216" CountTypeID="21" />
          <TagInfo TagNo="3217" CountTypeID="21" />
          <TagInfo TagNo="3218" CountTypeID="21" />
          <TagInfo TagNo="3219" CountTypeID="21" />
          <TagInfo TagNo="3220" CountTypeID="21" />
          <TagInfo TagNo="3221" CountTypeID="21" />
          <TagInfo TagNo="3222" CountTypeID="21" />
          <TagInfo TagNo="3223" CountTypeID="21" />
          <TagInfo TagNo="3224" CountTypeID="21" />
          <TagInfo TagNo="3225" CountTypeID="21" />
          <TagInfo TagNo="3226" CountTypeID="21" />
          <TagInfo TagNo="3227" CountTypeID="21" />
          <TagInfo TagNo="3228" CountTypeID="21" />
          <TagInfo TagNo="3229" CountTypeID="21" />
          <TagInfo TagNo="3230" CountTypeID="21" />
          <TagInfo TagNo="3231" CountTypeID="21" />
          <TagInfo TagNo="3232" CountTypeID="21" />
          <TagInfo TagNo="3233" CountTypeID="21" />
          <TagInfo TagNo="3234" CountTypeID="21" />
          <TagInfo TagNo="3235" CountTypeID="21" />
          <TagInfo TagNo="3236" CountTypeID="21" />
          <TagInfo TagNo="3237" CountTypeID="21" />
          <TagInfo TagNo="3238" CountTypeID="21" />
          <TagInfo TagNo="3239" CountTypeID="21" />
          <TagInfo TagNo="3240" CountTypeID="21" />
          <TagInfo TagNo="3241" CountTypeID="21" />
          <TagInfo TagNo="3242" CountTypeID="21" />
          <TagInfo TagNo="3243" CountTypeID="21" />
          <TagInfo TagNo="3244" CountTypeID="21" />
          <TagInfo TagNo="3245" CountTypeID="21" />
          <TagInfo TagNo="3246" CountTypeID="21" />
          <TagInfo TagNo="3247" CountTypeID="21" />
          <TagInfo TagNo="3248" CountTypeID="21" />
          <TagInfo TagNo="3249" CountTypeID="21" />
          <TagInfo TagNo="3250" CountTypeID="21" />
          <TagInfo TagNo="3251" CountTypeID="21" />
          <TagInfo TagNo="3252" CountTypeID="21" />
          <TagInfo TagNo="3253" CountTypeID="21" />
          <TagInfo TagNo="3254" CountTypeID="21" />
          <TagInfo TagNo="3255" CountTypeID="21" />
          <TagInfo TagNo="3256" CountTypeID="21" />
          <TagInfo TagNo="3257" CountTypeID="21" />
          <TagInfo TagNo="3258" CountTypeID="21" />
          <TagInfo TagNo="3259" CountTypeID="21" />
          <TagInfo TagNo="3260" CountTypeID="21" />
          <TagInfo TagNo="3261" CountTypeID="21" />
          <TagInfo TagNo="3262" CountTypeID="21" />
          <TagInfo TagNo="3263" CountTypeID="21" />
          <TagInfo TagNo="3264" CountTypeID="21" />
          <TagInfo TagNo="3265" CountTypeID="21" />
          <TagInfo TagNo="3266" CountTypeID="21" />
          <TagInfo TagNo="3267" CountTypeID="21" />
          <TagInfo TagNo="3268" CountTypeID="21" />
          <TagInfo TagNo="3269" CountTypeID="21" />
          <TagInfo TagNo="3270" CountTypeID="21" />
          <TagInfo TagNo="3271" CountTypeID="21" />
          <TagInfo TagNo="3272" CountTypeID="21" />
          <TagInfo TagNo="3273" CountTypeID="21" />
          <TagInfo TagNo="3274" CountTypeID="21" />
          <TagInfo TagNo="3275" CountTypeID="21" />
          <TagInfo TagNo="3276" CountTypeID="21" />
          <TagInfo TagNo="3277" CountTypeID="21" />
          <TagInfo TagNo="3278" CountTypeID="21" />
          <TagInfo TagNo="3279" CountTypeID="21" />
          <TagInfo TagNo="3280" CountTypeID="21" />
          <TagInfo TagNo="3281" CountTypeID="21" />
          <TagInfo TagNo="3282" CountTypeID="21" />
          <TagInfo TagNo="3283" CountTypeID="21" />
          <TagInfo TagNo="3284" CountTypeID="21" />
          <TagInfo TagNo="3285" CountTypeID="21" />
          <TagInfo TagNo="3286" CountTypeID="21" />
          <TagInfo TagNo="3287" CountTypeID="21" />
          <TagInfo TagNo="3288" CountTypeID="21" />
          <TagInfo TagNo="3289" CountTypeID="21" />
          <TagInfo TagNo="3290" CountTypeID="21" />
          <TagInfo TagNo="3291" CountTypeID="21" />
          <TagInfo TagNo="3292" CountTypeID="21" />
          <TagInfo TagNo="3293" CountTypeID="21" />
          <TagInfo TagNo="3294" CountTypeID="21" />
          <TagInfo TagNo="3295" CountTypeID="21" />
          <TagInfo TagNo="3296" CountTypeID="21" />
          <TagInfo TagNo="3297" CountTypeID="21" />
          <TagInfo TagNo="3298" CountTypeID="21" />
          <TagInfo TagNo="3299" CountTypeID="21" />
          <TagInfo TagNo="3300" CountTypeID="21" />
          <TagInfo TagNo="3301" CountTypeID="21" />
          <TagInfo TagNo="3302" CountTypeID="21" />
          <TagInfo TagNo="3303" CountTypeID="21" />
          <TagInfo TagNo="3304" CountTypeID="21" />
          <TagInfo TagNo="3305" CountTypeID="21" />
          <TagInfo TagNo="3306" CountTypeID="21" />
          <TagInfo TagNo="3307" CountTypeID="21" />
          <TagInfo TagNo="3308" CountTypeID="21" />
          <TagInfo TagNo="3309" CountTypeID="21" />
          <TagInfo TagNo="3310" CountTypeID="21" />
          <TagInfo TagNo="3311" CountTypeID="21" />
          <TagInfo TagNo="3312" CountTypeID="21" />
          <TagInfo TagNo="3313" CountTypeID="21" />
          <TagInfo TagNo="3314" CountTypeID="21" />
          <TagInfo TagNo="3315" CountTypeID="21" />
          <TagInfo TagNo="3316" CountTypeID="21" />
          <TagInfo TagNo="3317" CountTypeID="21" />
          <TagInfo TagNo="3318" CountTypeID="21" />
          <TagInfo TagNo="3319" CountTypeID="21" />
          <TagInfo TagNo="3320" CountTypeID="21" />
          <TagInfo TagNo="3321" CountTypeID="21" />
          <TagInfo TagNo="3322" CountTypeID="21" />
          <TagInfo TagNo="3323" CountTypeID="21" />
          <TagInfo TagNo="3324" CountTypeID="21" />
          <TagInfo TagNo="3325" CountTypeID="21" />
          <TagInfo TagNo="3326" CountTypeID="21" />
          <TagInfo TagNo="3327" CountTypeID="21" />
          <TagInfo TagNo="3328" CountTypeID="21" />
          <TagInfo TagNo="3329" CountTypeID="21" />
          <TagInfo TagNo="3330" CountTypeID="21" />
          <TagInfo TagNo="3331" CountTypeID="21" />
          <TagInfo TagNo="3332" CountTypeID="21" />
          <TagInfo TagNo="3333" CountTypeID="21" />
          <TagInfo TagNo="3334" CountTypeID="21" />
          <TagInfo TagNo="3335" CountTypeID="21" />
          <TagInfo TagNo="3336" CountTypeID="21" />
          <TagInfo TagNo="3337" CountTypeID="21" />
          <TagInfo TagNo="3338" CountTypeID="21" />
          <TagInfo TagNo="3339" CountTypeID="21" />
          <TagInfo TagNo="3340" CountTypeID="21" />
          <TagInfo TagNo="3341" CountTypeID="21" />
          <TagInfo TagNo="3342" CountTypeID="21" />
          <TagInfo TagNo="3343" CountTypeID="21" />
          <TagInfo TagNo="3344" CountTypeID="21" />
          <TagInfo TagNo="3345" CountTypeID="21" />
          <TagInfo TagNo="3346" CountTypeID="21" />
          <TagInfo TagNo="3347" CountTypeID="21" />
          <TagInfo TagNo="3348" CountTypeID="21" />
          <TagInfo TagNo="3349" CountTypeID="21" />
          <TagInfo TagNo="3350" CountTypeID="21" />
          <TagInfo TagNo="3351" CountTypeID="21" />
          <TagInfo TagNo="3352" CountTypeID="21" />
          <TagInfo TagNo="3353" CountTypeID="21" />
          <TagInfo TagNo="3354" CountTypeID="21" />
          <TagInfo TagNo="3355" CountTypeID="21" />
          <TagInfo TagNo="3356" CountTypeID="21" />
          <TagInfo TagNo="3357" CountTypeID="21" />
          <TagInfo TagNo="3358" CountTypeID="21" />
        </TagRange>
        <TagRange TagRangeName="GM FRONTLINE2" TagRangeDescription="" TagRangeFrom="3359" TagRangeTo="3650" DefaultCountTypeID="105">
          <TagInfo TagNo="3359" CountTypeID="105" />
          <TagInfo TagNo="3360" CountTypeID="105" />
          <TagInfo TagNo="3361" CountTypeID="105" />
          <TagInfo TagNo="3362" CountTypeID="105" />
          <TagInfo TagNo="3363" CountTypeID="105" />
          <TagInfo TagNo="3364" CountTypeID="105" />
          <TagInfo TagNo="3365" CountTypeID="105" />
          <TagInfo TagNo="3366" CountTypeID="105" />
          <TagInfo TagNo="3367" CountTypeID="105" />
          <TagInfo TagNo="3368" CountTypeID="105" />
          <TagInfo TagNo="3369" CountTypeID="105" />
          <TagInfo TagNo="3370" CountTypeID="105" />
          <TagInfo TagNo="3371" CountTypeID="105" />
          <TagInfo TagNo="3372" CountTypeID="105" />
          <TagInfo TagNo="3373" CountTypeID="105" />
          <TagInfo TagNo="3374" CountTypeID="105" />
          <TagInfo TagNo="3375" CountTypeID="105" />
          <TagInfo TagNo="3376" CountTypeID="105" />
          <TagInfo TagNo="3377" CountTypeID="105" />
          <TagInfo TagNo="3378" CountTypeID="105" />
          <TagInfo TagNo="3379" CountTypeID="105" />
          <TagInfo TagNo="3380" CountTypeID="105" />
          <TagInfo TagNo="3381" CountTypeID="105" />
          <TagInfo TagNo="3382" CountTypeID="105" />
          <TagInfo TagNo="3383" CountTypeID="105" />
          <TagInfo TagNo="3384" CountTypeID="105" />
          <TagInfo TagNo="3385" CountTypeID="105" />
          <TagInfo TagNo="3386" CountTypeID="105" />
          <TagInfo TagNo="3387" CountTypeID="105" />
          <TagInfo TagNo="3388" CountTypeID="105" />
          <TagInfo TagNo="3389" CountTypeID="105" />
          <TagInfo TagNo="3390" CountTypeID="105" />
          <TagInfo TagNo="3391" CountTypeID="105" />
          <TagInfo TagNo="3392" CountTypeID="105" />
          <TagInfo TagNo="3393" CountTypeID="105" />
          <TagInfo TagNo="3394" CountTypeID="105" />
          <TagInfo TagNo="3395" CountTypeID="105" />
          <TagInfo TagNo="3396" CountTypeID="105" />
          <TagInfo TagNo="3397" CountTypeID="105" />
          <TagInfo TagNo="3398" CountTypeID="105" />
          <TagInfo TagNo="3399" CountTypeID="105" />
          <TagInfo TagNo="3400" CountTypeID="105" />
          <TagInfo TagNo="3401" CountTypeID="105" />
          <TagInfo TagNo="3402" CountTypeID="105" />
          <TagInfo TagNo="3403" CountTypeID="105" />
          <TagInfo TagNo="3404" CountTypeID="105" />
          <TagInfo TagNo="3405" CountTypeID="105" />
          <TagInfo TagNo="3406" CountTypeID="105" />
          <TagInfo TagNo="3407" CountTypeID="105" />
          <TagInfo TagNo="3408" CountTypeID="105" />
          <TagInfo TagNo="3409" CountTypeID="105" />
          <TagInfo TagNo="3410" CountTypeID="105" />
          <TagInfo TagNo="3411" CountTypeID="105" />
          <TagInfo TagNo="3412" CountTypeID="105" />
          <TagInfo TagNo="3413" CountTypeID="105" />
          <TagInfo TagNo="3414" CountTypeID="105" />
          <TagInfo TagNo="3415" CountTypeID="105" />
          <TagInfo TagNo="3416" CountTypeID="105" />
          <TagInfo TagNo="3417" CountTypeID="105" />
          <TagInfo TagNo="3418" CountTypeID="105" />
          <TagInfo TagNo="3419" CountTypeID="105" />
          <TagInfo TagNo="3420" CountTypeID="105" />
          <TagInfo TagNo="3421" CountTypeID="105" />
          <TagInfo TagNo="3422" CountTypeID="105" />
          <TagInfo TagNo="3423" CountTypeID="105" />
          <TagInfo TagNo="3424" CountTypeID="105" />
          <TagInfo TagNo="3425" CountTypeID="105" />
          <TagInfo TagNo="3426" CountTypeID="105" />
          <TagInfo TagNo="3427" CountTypeID="105" />
          <TagInfo TagNo="3428" CountTypeID="105" />
          <TagInfo TagNo="3429" CountTypeID="105" />
          <TagInfo TagNo="3430" CountTypeID="105" />
          <TagInfo TagNo="3431" CountTypeID="105" />
          <TagInfo TagNo="3432" CountTypeID="105" />
          <TagInfo TagNo="3433" CountTypeID="105" />
          <TagInfo TagNo="3434" CountTypeID="105" />
          <TagInfo TagNo="3435" CountTypeID="105" />
          <TagInfo TagNo="3436" CountTypeID="105" />
          <TagInfo TagNo="3437" CountTypeID="105" />
          <TagInfo TagNo="3438" CountTypeID="105" />
          <TagInfo TagNo="3439" CountTypeID="105" />
          <TagInfo TagNo="3440" CountTypeID="105" />
          <TagInfo TagNo="3441" CountTypeID="105" />
          <TagInfo TagNo="3442" CountTypeID="105" />
          <TagInfo TagNo="3443" CountTypeID="105" />
          <TagInfo TagNo="3444" CountTypeID="105" />
          <TagInfo TagNo="3445" CountTypeID="105" />
          <TagInfo TagNo="3446" CountTypeID="105" />
          <TagInfo TagNo="3447" CountTypeID="105" />
          <TagInfo TagNo="3448" CountTypeID="105" />
          <TagInfo TagNo="3449" CountTypeID="105" />
          <TagInfo TagNo="3450" CountTypeID="105" />
          <TagInfo TagNo="3451" CountTypeID="105" />
          <TagInfo TagNo="3452" CountTypeID="105" />
          <TagInfo TagNo="3453" CountTypeID="105" />
          <TagInfo TagNo="3454" CountTypeID="105" />
          <TagInfo TagNo="3455" CountTypeID="105" />
          <TagInfo TagNo="3456" CountTypeID="105" />
          <TagInfo TagNo="3457" CountTypeID="105" />
          <TagInfo TagNo="3458" CountTypeID="105" />
          <TagInfo TagNo="3459" CountTypeID="105" />
          <TagInfo TagNo="3460" CountTypeID="105" />
          <TagInfo TagNo="3461" CountTypeID="105" />
          <TagInfo TagNo="3462" CountTypeID="105" />
          <TagInfo TagNo="3463" CountTypeID="105" />
          <TagInfo TagNo="3464" CountTypeID="105" />
          <TagInfo TagNo="3465" CountTypeID="105" />
          <TagInfo TagNo="3466" CountTypeID="105" />
          <TagInfo TagNo="3467" CountTypeID="105" />
          <TagInfo TagNo="3468" CountTypeID="105" />
          <TagInfo TagNo="3469" CountTypeID="105" />
          <TagInfo TagNo="3470" CountTypeID="105" />
          <TagInfo TagNo="3471" CountTypeID="105" />
          <TagInfo TagNo="3472" CountTypeID="105" />
          <TagInfo TagNo="3473" CountTypeID="105" />
          <TagInfo TagNo="3474" CountTypeID="105" />
          <TagInfo TagNo="3475" CountTypeID="105" />
          <TagInfo TagNo="3476" CountTypeID="105" />
          <TagInfo TagNo="3477" CountTypeID="105" />
          <TagInfo TagNo="3478" CountTypeID="105" />
          <TagInfo TagNo="3479" CountTypeID="105" />
          <TagInfo TagNo="3480" CountTypeID="105" />
          <TagInfo TagNo="3481" CountTypeID="105" />
          <TagInfo TagNo="3482" CountTypeID="105" />
          <TagInfo TagNo="3483" CountTypeID="105" />
          <TagInfo TagNo="3484" CountTypeID="105" />
          <TagInfo TagNo="3485" CountTypeID="105" />
          <TagInfo TagNo="3486" CountTypeID="105" />
          <TagInfo TagNo="3487" CountTypeID="105" />
          <TagInfo TagNo="3488" CountTypeID="105" />
          <TagInfo TagNo="3489" CountTypeID="105" />
          <TagInfo TagNo="3490" CountTypeID="105" />
          <TagInfo TagNo="3491" CountTypeID="105" />
          <TagInfo TagNo="3492" CountTypeID="105" />
          <TagInfo TagNo="3493" CountTypeID="105" />
          <TagInfo TagNo="3494" CountTypeID="105" />
          <TagInfo TagNo="3495" CountTypeID="105" />
          <TagInfo TagNo="3496" CountTypeID="105" />
          <TagInfo TagNo="3497" CountTypeID="105" />
          <TagInfo TagNo="3498" CountTypeID="105" />
          <TagInfo TagNo="3499" CountTypeID="105" />
          <TagInfo TagNo="3500" CountTypeID="105" />
          <TagInfo TagNo="3501" CountTypeID="105" />
          <TagInfo TagNo="3502" CountTypeID="105" />
          <TagInfo TagNo="3503" CountTypeID="105" />
          <TagInfo TagNo="3504" CountTypeID="105" />
          <TagInfo TagNo="3505" CountTypeID="105" />
          <TagInfo TagNo="3506" CountTypeID="105" />
          <TagInfo TagNo="3507" CountTypeID="105" />
          <TagInfo TagNo="3508" CountTypeID="105" />
          <TagInfo TagNo="3509" CountTypeID="105" />
          <TagInfo TagNo="3510" CountTypeID="105" />
          <TagInfo TagNo="3511" CountTypeID="105" />
          <TagInfo TagNo="3512" CountTypeID="105" />
          <TagInfo TagNo="3513" CountTypeID="105" />
          <TagInfo TagNo="3514" CountTypeID="105" />
          <TagInfo TagNo="3515" CountTypeID="105" />
          <TagInfo TagNo="3516" CountTypeID="105" />
          <TagInfo TagNo="3517" CountTypeID="105" />
          <TagInfo TagNo="3518" CountTypeID="105" />
          <TagInfo TagNo="3519" CountTypeID="105" />
          <TagInfo TagNo="3520" CountTypeID="105" />
          <TagInfo TagNo="3521" CountTypeID="105" />
          <TagInfo TagNo="3522" CountTypeID="105" />
          <TagInfo TagNo="3523" CountTypeID="105" />
          <TagInfo TagNo="3524" CountTypeID="105" />
          <TagInfo TagNo="3525" CountTypeID="105" />
          <TagInfo TagNo="3526" CountTypeID="105" />
          <TagInfo TagNo="3527" CountTypeID="105" />
          <TagInfo TagNo="3528" CountTypeID="105" />
          <TagInfo TagNo="3529" CountTypeID="105" />
          <TagInfo TagNo="3530" CountTypeID="105" />
          <TagInfo TagNo="3531" CountTypeID="105" />
          <TagInfo TagNo="3532" CountTypeID="105" />
          <TagInfo TagNo="3533" CountTypeID="105" />
          <TagInfo TagNo="3534" CountTypeID="105" />
          <TagInfo TagNo="3535" CountTypeID="105" />
          <TagInfo TagNo="3536" CountTypeID="105" />
          <TagInfo TagNo="3537" CountTypeID="105" />
          <TagInfo TagNo="3538" CountTypeID="105" />
          <TagInfo TagNo="3539" CountTypeID="105" />
          <TagInfo TagNo="3540" CountTypeID="105" />
          <TagInfo TagNo="3541" CountTypeID="105" />
          <TagInfo TagNo="3542" CountTypeID="105" />
          <TagInfo TagNo="3543" CountTypeID="105" />
          <TagInfo TagNo="3544" CountTypeID="105" />
          <TagInfo TagNo="3545" CountTypeID="105" />
          <TagInfo TagNo="3546" CountTypeID="105" />
          <TagInfo TagNo="3547" CountTypeID="105" />
          <TagInfo TagNo="3548" CountTypeID="105" />
          <TagInfo TagNo="3549" CountTypeID="105" />
          <TagInfo TagNo="3550" CountTypeID="105" />
          <TagInfo TagNo="3551" CountTypeID="105" />
          <TagInfo TagNo="3552" CountTypeID="105" />
          <TagInfo TagNo="3553" CountTypeID="105" />
          <TagInfo TagNo="3554" CountTypeID="105" />
          <TagInfo TagNo="3555" CountTypeID="105" />
          <TagInfo TagNo="3556" CountTypeID="105" />
          <TagInfo TagNo="3557" CountTypeID="105" />
          <TagInfo TagNo="3558" CountTypeID="105" />
          <TagInfo TagNo="3559" CountTypeID="105" />
          <TagInfo TagNo="3560" CountTypeID="105" />
          <TagInfo TagNo="3561" CountTypeID="105" />
          <TagInfo TagNo="3562" CountTypeID="105" />
          <TagInfo TagNo="3563" CountTypeID="105" />
          <TagInfo TagNo="3564" CountTypeID="105" />
          <TagInfo TagNo="3565" CountTypeID="105" />
          <TagInfo TagNo="3566" CountTypeID="105" />
          <TagInfo TagNo="3567" CountTypeID="105" />
          <TagInfo TagNo="3568" CountTypeID="105" />
          <TagInfo TagNo="3569" CountTypeID="105" />
          <TagInfo TagNo="3570" CountTypeID="105" />
          <TagInfo TagNo="3571" CountTypeID="105" />
          <TagInfo TagNo="3572" CountTypeID="105" />
          <TagInfo TagNo="3573" CountTypeID="105" />
          <TagInfo TagNo="3574" CountTypeID="105" />
          <TagInfo TagNo="3575" CountTypeID="105" />
          <TagInfo TagNo="3576" CountTypeID="105" />
          <TagInfo TagNo="3577" CountTypeID="105" />
          <TagInfo TagNo="3578" CountTypeID="105" />
          <TagInfo TagNo="3579" CountTypeID="105" />
          <TagInfo TagNo="3580" CountTypeID="105" />
          <TagInfo TagNo="3581" CountTypeID="105" />
          <TagInfo TagNo="3582" CountTypeID="105" />
          <TagInfo TagNo="3583" CountTypeID="105" />
          <TagInfo TagNo="3584" CountTypeID="105" />
          <TagInfo TagNo="3585" CountTypeID="105" />
          <TagInfo TagNo="3586" CountTypeID="105" />
          <TagInfo TagNo="3587" CountTypeID="105" />
          <TagInfo TagNo="3588" CountTypeID="105" />
          <TagInfo TagNo="3589" CountTypeID="105" />
          <TagInfo TagNo="3590" CountTypeID="105" />
          <TagInfo TagNo="3591" CountTypeID="105" />
          <TagInfo TagNo="3592" CountTypeID="105" />
          <TagInfo TagNo="3593" CountTypeID="105" />
          <TagInfo TagNo="3594" CountTypeID="105" />
          <TagInfo TagNo="3595" CountTypeID="105" />
          <TagInfo TagNo="3596" CountTypeID="105" />
          <TagInfo TagNo="3597" CountTypeID="105" />
          <TagInfo TagNo="3598" CountTypeID="105" />
          <TagInfo TagNo="3599" CountTypeID="105" />
          <TagInfo TagNo="3600" CountTypeID="105" />
          <TagInfo TagNo="3601" CountTypeID="105" />
          <TagInfo TagNo="3602" CountTypeID="105" />
          <TagInfo TagNo="3603" CountTypeID="105" />
          <TagInfo TagNo="3604" CountTypeID="105" />
          <TagInfo TagNo="3605" CountTypeID="105" />
          <TagInfo TagNo="3606" CountTypeID="105" />
          <TagInfo TagNo="3607" CountTypeID="105" />
          <TagInfo TagNo="3608" CountTypeID="105" />
          <TagInfo TagNo="3609" CountTypeID="105" />
          <TagInfo TagNo="3610" CountTypeID="105" />
          <TagInfo TagNo="3611" CountTypeID="105" />
          <TagInfo TagNo="3612" CountTypeID="105" />
          <TagInfo TagNo="3613" CountTypeID="105" />
          <TagInfo TagNo="3614" CountTypeID="105" />
          <TagInfo TagNo="3615" CountTypeID="105" />
          <TagInfo TagNo="3616" CountTypeID="105" />
          <TagInfo TagNo="3617" CountTypeID="105" />
          <TagInfo TagNo="3618" CountTypeID="105" />
          <TagInfo TagNo="3619" CountTypeID="105" />
          <TagInfo TagNo="3620" CountTypeID="105" />
          <TagInfo TagNo="3621" CountTypeID="105" />
          <TagInfo TagNo="3622" CountTypeID="105" />
          <TagInfo TagNo="3623" CountTypeID="105" />
          <TagInfo TagNo="3624" CountTypeID="105" />
          <TagInfo TagNo="3625" CountTypeID="105" />
          <TagInfo TagNo="3626" CountTypeID="105" />
          <TagInfo TagNo="3627" CountTypeID="105" />
          <TagInfo TagNo="3628" CountTypeID="105" />
          <TagInfo TagNo="3629" CountTypeID="105" />
          <TagInfo TagNo="3630" CountTypeID="105" />
          <TagInfo TagNo="3631" CountTypeID="105" />
          <TagInfo TagNo="3632" CountTypeID="105" />
          <TagInfo TagNo="3633" CountTypeID="105" />
          <TagInfo TagNo="3634" CountTypeID="105" />
          <TagInfo TagNo="3635" CountTypeID="105" />
          <TagInfo TagNo="3636" CountTypeID="105" />
          <TagInfo TagNo="3637" CountTypeID="105" />
          <TagInfo TagNo="3638" CountTypeID="105" />
          <TagInfo TagNo="3639" CountTypeID="105" />
          <TagInfo TagNo="3640" CountTypeID="105" />
          <TagInfo TagNo="3641" CountTypeID="105" />
          <TagInfo TagNo="3642" CountTypeID="105" />
          <TagInfo TagNo="3643" CountTypeID="105" />
          <TagInfo TagNo="3644" CountTypeID="105" />
          <TagInfo TagNo="3645" CountTypeID="105" />
          <TagInfo TagNo="3646" CountTypeID="105" />
          <TagInfo TagNo="3647" CountTypeID="105" />
          <TagInfo TagNo="3648" CountTypeID="105" />
          <TagInfo TagNo="3649" CountTypeID="105" />
          <TagInfo TagNo="3650" CountTypeID="105" />
        </TagRange>
        <TagRange TagRangeName="GM BACKLINE" TagRangeDescription="" TagRangeFrom="4039" TagRangeTo="4320" DefaultCountTypeID="105">
          <TagInfo TagNo="4039" CountTypeID="105" />
          <TagInfo TagNo="4040" CountTypeID="105" />
          <TagInfo TagNo="4041" CountTypeID="105" />
          <TagInfo TagNo="4042" CountTypeID="105" />
          <TagInfo TagNo="4043" CountTypeID="105" />
          <TagInfo TagNo="4044" CountTypeID="105" />
          <TagInfo TagNo="4045" CountTypeID="105" />
          <TagInfo TagNo="4046" CountTypeID="105" />
          <TagInfo TagNo="4047" CountTypeID="105" />
          <TagInfo TagNo="4048" CountTypeID="105" />
          <TagInfo TagNo="4049" CountTypeID="105" />
          <TagInfo TagNo="4050" CountTypeID="105" />
          <TagInfo TagNo="4051" CountTypeID="105" />
          <TagInfo TagNo="4052" CountTypeID="105" />
          <TagInfo TagNo="4053" CountTypeID="105" />
          <TagInfo TagNo="4054" CountTypeID="105" />
          <TagInfo TagNo="4055" CountTypeID="105" />
          <TagInfo TagNo="4056" CountTypeID="105" />
          <TagInfo TagNo="4057" CountTypeID="105" />
          <TagInfo TagNo="4058" CountTypeID="105" />
          <TagInfo TagNo="4059" CountTypeID="105" />
          <TagInfo TagNo="4060" CountTypeID="105" />
          <TagInfo TagNo="4061" CountTypeID="105" />
          <TagInfo TagNo="4062" CountTypeID="105" />
          <TagInfo TagNo="4063" CountTypeID="105" />
          <TagInfo TagNo="4064" CountTypeID="105" />
          <TagInfo TagNo="4065" CountTypeID="105" />
          <TagInfo TagNo="4066" CountTypeID="105" />
          <TagInfo TagNo="4067" CountTypeID="105" />
          <TagInfo TagNo="4068" CountTypeID="105" />
          <TagInfo TagNo="4069" CountTypeID="105" />
          <TagInfo TagNo="4070" CountTypeID="105" />
          <TagInfo TagNo="4071" CountTypeID="105" />
          <TagInfo TagNo="4072" CountTypeID="105" />
          <TagInfo TagNo="4073" CountTypeID="105" />
          <TagInfo TagNo="4074" CountTypeID="105" />
          <TagInfo TagNo="4075" CountTypeID="105" />
          <TagInfo TagNo="4076" CountTypeID="105" />
          <TagInfo TagNo="4077" CountTypeID="105" />
          <TagInfo TagNo="4078" CountTypeID="105" />
          <TagInfo TagNo="4079" CountTypeID="105" />
          <TagInfo TagNo="4080" CountTypeID="105" />
          <TagInfo TagNo="4081" CountTypeID="105" />
          <TagInfo TagNo="4082" CountTypeID="105" />
          <TagInfo TagNo="4083" CountTypeID="105" />
          <TagInfo TagNo="4084" CountTypeID="105" />
          <TagInfo TagNo="4085" CountTypeID="105" />
          <TagInfo TagNo="4086" CountTypeID="105" />
          <TagInfo TagNo="4087" CountTypeID="105" />
          <TagInfo TagNo="4088" CountTypeID="105" />
          <TagInfo TagNo="4089" CountTypeID="105" />
          <TagInfo TagNo="4090" CountTypeID="105" />
          <TagInfo TagNo="4091" CountTypeID="105" />
          <TagInfo TagNo="4092" CountTypeID="105" />
          <TagInfo TagNo="4093" CountTypeID="105" />
          <TagInfo TagNo="4094" CountTypeID="105" />
          <TagInfo TagNo="4095" CountTypeID="105" />
          <TagInfo TagNo="4096" CountTypeID="105" />
          <TagInfo TagNo="4097" CountTypeID="105" />
          <TagInfo TagNo="4098" CountTypeID="105" />
          <TagInfo TagNo="4099" CountTypeID="105" />
          <TagInfo TagNo="4100" CountTypeID="105" />
          <TagInfo TagNo="4101" CountTypeID="105" />
          <TagInfo TagNo="4102" CountTypeID="105" />
          <TagInfo TagNo="4103" CountTypeID="105" />
          <TagInfo TagNo="4104" CountTypeID="105" />
          <TagInfo TagNo="4105" CountTypeID="105" />
          <TagInfo TagNo="4106" CountTypeID="105" />
          <TagInfo TagNo="4107" CountTypeID="105" />
          <TagInfo TagNo="4108" CountTypeID="105" />
          <TagInfo TagNo="4109" CountTypeID="105" />
          <TagInfo TagNo="4110" CountTypeID="105" />
          <TagInfo TagNo="4111" CountTypeID="105" />
          <TagInfo TagNo="4112" CountTypeID="105" />
          <TagInfo TagNo="4113" CountTypeID="105" />
          <TagInfo TagNo="4114" CountTypeID="105" />
          <TagInfo TagNo="4115" CountTypeID="105" />
          <TagInfo TagNo="4116" CountTypeID="105" />
          <TagInfo TagNo="4117" CountTypeID="105" />
          <TagInfo TagNo="4118" CountTypeID="105" />
          <TagInfo TagNo="4119" CountTypeID="105" />
          <TagInfo TagNo="4120" CountTypeID="105" />
          <TagInfo TagNo="4121" CountTypeID="105" />
          <TagInfo TagNo="4122" CountTypeID="105" />
          <TagInfo TagNo="4123" CountTypeID="105" />
          <TagInfo TagNo="4124" CountTypeID="105" />
          <TagInfo TagNo="4125" CountTypeID="105" />
          <TagInfo TagNo="4126" CountTypeID="105" />
          <TagInfo TagNo="4127" CountTypeID="105" />
          <TagInfo TagNo="4128" CountTypeID="105" />
          <TagInfo TagNo="4129" CountTypeID="105" />
          <TagInfo TagNo="4130" CountTypeID="105" />
          <TagInfo TagNo="4131" CountTypeID="105" />
          <TagInfo TagNo="4132" CountTypeID="105" />
          <TagInfo TagNo="4133" CountTypeID="105" />
          <TagInfo TagNo="4134" CountTypeID="105" />
          <TagInfo TagNo="4135" CountTypeID="105" />
          <TagInfo TagNo="4136" CountTypeID="105" />
          <TagInfo TagNo="4137" CountTypeID="105" />
          <TagInfo TagNo="4138" CountTypeID="105" />
          <TagInfo TagNo="4139" CountTypeID="105" />
          <TagInfo TagNo="4140" CountTypeID="105" />
          <TagInfo TagNo="4141" CountTypeID="105" />
          <TagInfo TagNo="4142" CountTypeID="105" />
          <TagInfo TagNo="4143" CountTypeID="105" />
          <TagInfo TagNo="4144" CountTypeID="105" />
          <TagInfo TagNo="4145" CountTypeID="105" />
          <TagInfo TagNo="4146" CountTypeID="105" />
          <TagInfo TagNo="4147" CountTypeID="105" />
          <TagInfo TagNo="4148" CountTypeID="105" />
          <TagInfo TagNo="4149" CountTypeID="105" />
          <TagInfo TagNo="4150" CountTypeID="105" />
          <TagInfo TagNo="4151" CountTypeID="105" />
          <TagInfo TagNo="4152" CountTypeID="105" />
          <TagInfo TagNo="4153" CountTypeID="105" />
          <TagInfo TagNo="4154" CountTypeID="105" />
          <TagInfo TagNo="4155" CountTypeID="105" />
          <TagInfo TagNo="4156" CountTypeID="105" />
          <TagInfo TagNo="4157" CountTypeID="105" />
          <TagInfo TagNo="4158" CountTypeID="105" />
          <TagInfo TagNo="4159" CountTypeID="105" />
          <TagInfo TagNo="4160" CountTypeID="105" />
          <TagInfo TagNo="4161" CountTypeID="105" />
          <TagInfo TagNo="4162" CountTypeID="105" />
          <TagInfo TagNo="4163" CountTypeID="105" />
          <TagInfo TagNo="4164" CountTypeID="105" />
          <TagInfo TagNo="4165" CountTypeID="105" />
          <TagInfo TagNo="4166" CountTypeID="105" />
          <TagInfo TagNo="4167" CountTypeID="105" />
          <TagInfo TagNo="4168" CountTypeID="105" />
          <TagInfo TagNo="4169" CountTypeID="105" />
          <TagInfo TagNo="4170" CountTypeID="105" />
          <TagInfo TagNo="4171" CountTypeID="105" />
          <TagInfo TagNo="4172" CountTypeID="105" />
          <TagInfo TagNo="4173" CountTypeID="105" />
          <TagInfo TagNo="4174" CountTypeID="105" />
          <TagInfo TagNo="4175" CountTypeID="105" />
          <TagInfo TagNo="4176" CountTypeID="105" />
          <TagInfo TagNo="4177" CountTypeID="105" />
          <TagInfo TagNo="4178" CountTypeID="105" />
          <TagInfo TagNo="4179" CountTypeID="105" />
          <TagInfo TagNo="4180" CountTypeID="105" />
          <TagInfo TagNo="4181" CountTypeID="105" />
          <TagInfo TagNo="4182" CountTypeID="105" />
          <TagInfo TagNo="4183" CountTypeID="105" />
          <TagInfo TagNo="4184" CountTypeID="105" />
          <TagInfo TagNo="4185" CountTypeID="105" />
          <TagInfo TagNo="4186" CountTypeID="105" />
          <TagInfo TagNo="4187" CountTypeID="105" />
          <TagInfo TagNo="4188" CountTypeID="105" />
          <TagInfo TagNo="4189" CountTypeID="105" />
          <TagInfo TagNo="4190" CountTypeID="105" />
          <TagInfo TagNo="4191" CountTypeID="105" />
          <TagInfo TagNo="4192" CountTypeID="105" />
          <TagInfo TagNo="4193" CountTypeID="105" />
          <TagInfo TagNo="4194" CountTypeID="105" />
          <TagInfo TagNo="4195" CountTypeID="105" />
          <TagInfo TagNo="4196" CountTypeID="105" />
          <TagInfo TagNo="4197" CountTypeID="105" />
          <TagInfo TagNo="4198" CountTypeID="105" />
          <TagInfo TagNo="4199" CountTypeID="105" />
          <TagInfo TagNo="4200" CountTypeID="105" />
          <TagInfo TagNo="4201" CountTypeID="105" />
          <TagInfo TagNo="4202" CountTypeID="105" />
          <TagInfo TagNo="4203" CountTypeID="105" />
          <TagInfo TagNo="4204" CountTypeID="105" />
          <TagInfo TagNo="4205" CountTypeID="105" />
          <TagInfo TagNo="4206" CountTypeID="105" />
          <TagInfo TagNo="4207" CountTypeID="105" />
          <TagInfo TagNo="4208" CountTypeID="105" />
          <TagInfo TagNo="4209" CountTypeID="105" />
          <TagInfo TagNo="4210" CountTypeID="105" />
          <TagInfo TagNo="4211" CountTypeID="105" />
          <TagInfo TagNo="4212" CountTypeID="105" />
          <TagInfo TagNo="4213" CountTypeID="105" />
          <TagInfo TagNo="4214" CountTypeID="105" />
          <TagInfo TagNo="4215" CountTypeID="105" />
          <TagInfo TagNo="4216" CountTypeID="105" />
          <TagInfo TagNo="4217" CountTypeID="105" />
          <TagInfo TagNo="4218" CountTypeID="105" />
          <TagInfo TagNo="4219" CountTypeID="105" />
          <TagInfo TagNo="4220" CountTypeID="105" />
          <TagInfo TagNo="4221" CountTypeID="105" />
          <TagInfo TagNo="4222" CountTypeID="105" />
          <TagInfo TagNo="4223" CountTypeID="105" />
          <TagInfo TagNo="4224" CountTypeID="105" />
          <TagInfo TagNo="4225" CountTypeID="105" />
          <TagInfo TagNo="4226" CountTypeID="105" />
          <TagInfo TagNo="4227" CountTypeID="105" />
          <TagInfo TagNo="4228" CountTypeID="105" />
          <TagInfo TagNo="4229" CountTypeID="105" />
          <TagInfo TagNo="4230" CountTypeID="105" />
          <TagInfo TagNo="4231" CountTypeID="105" />
          <TagInfo TagNo="4232" CountTypeID="105" />
          <TagInfo TagNo="4233" CountTypeID="105" />
          <TagInfo TagNo="4234" CountTypeID="105" />
          <TagInfo TagNo="4235" CountTypeID="105" />
          <TagInfo TagNo="4236" CountTypeID="105" />
          <TagInfo TagNo="4237" CountTypeID="105" />
          <TagInfo TagNo="4238" CountTypeID="105" />
          <TagInfo TagNo="4239" CountTypeID="105" />
          <TagInfo TagNo="4240" CountTypeID="105" />
          <TagInfo TagNo="4241" CountTypeID="105" />
          <TagInfo TagNo="4242" CountTypeID="105" />
          <TagInfo TagNo="4243" CountTypeID="105" />
          <TagInfo TagNo="4244" CountTypeID="105" />
          <TagInfo TagNo="4245" CountTypeID="105" />
          <TagInfo TagNo="4246" CountTypeID="105" />
          <TagInfo TagNo="4247" CountTypeID="105" />
          <TagInfo TagNo="4248" CountTypeID="105" />
          <TagInfo TagNo="4249" CountTypeID="105" />
          <TagInfo TagNo="4250" CountTypeID="105" />
          <TagInfo TagNo="4251" CountTypeID="105" />
          <TagInfo TagNo="4252" CountTypeID="105" />
          <TagInfo TagNo="4253" CountTypeID="105" />
          <TagInfo TagNo="4254" CountTypeID="105" />
          <TagInfo TagNo="4255" CountTypeID="105" />
          <TagInfo TagNo="4256" CountTypeID="105" />
          <TagInfo TagNo="4257" CountTypeID="105" />
          <TagInfo TagNo="4258" CountTypeID="105" />
          <TagInfo TagNo="4259" CountTypeID="105" />
          <TagInfo TagNo="4260" CountTypeID="105" />
          <TagInfo TagNo="4261" CountTypeID="105" />
          <TagInfo TagNo="4262" CountTypeID="105" />
          <TagInfo TagNo="4263" CountTypeID="105" />
          <TagInfo TagNo="4264" CountTypeID="105" />
          <TagInfo TagNo="4265" CountTypeID="105" />
          <TagInfo TagNo="4266" CountTypeID="105" />
          <TagInfo TagNo="4267" CountTypeID="105" />
          <TagInfo TagNo="4268" CountTypeID="105" />
          <TagInfo TagNo="4269" CountTypeID="105" />
          <TagInfo TagNo="4270" CountTypeID="105" />
          <TagInfo TagNo="4271" CountTypeID="105" />
          <TagInfo TagNo="4272" CountTypeID="105" />
          <TagInfo TagNo="4273" CountTypeID="105" />
          <TagInfo TagNo="4274" CountTypeID="105" />
          <TagInfo TagNo="4275" CountTypeID="105" />
          <TagInfo TagNo="4276" CountTypeID="105" />
          <TagInfo TagNo="4277" CountTypeID="105" />
          <TagInfo TagNo="4278" CountTypeID="105" />
          <TagInfo TagNo="4279" CountTypeID="105" />
          <TagInfo TagNo="4280" CountTypeID="105" />
          <TagInfo TagNo="4281" CountTypeID="105" />
          <TagInfo TagNo="4282" CountTypeID="105" />
          <TagInfo TagNo="4283" CountTypeID="105" />
          <TagInfo TagNo="4284" CountTypeID="105" />
          <TagInfo TagNo="4285" CountTypeID="105" />
          <TagInfo TagNo="4286" CountTypeID="105" />
          <TagInfo TagNo="4287" CountTypeID="105" />
          <TagInfo TagNo="4288" CountTypeID="105" />
          <TagInfo TagNo="4289" CountTypeID="105" />
          <TagInfo TagNo="4290" CountTypeID="105" />
          <TagInfo TagNo="4291" CountTypeID="105" />
          <TagInfo TagNo="4292" CountTypeID="105" />
          <TagInfo TagNo="4293" CountTypeID="105" />
          <TagInfo TagNo="4294" CountTypeID="105" />
          <TagInfo TagNo="4295" CountTypeID="105" />
          <TagInfo TagNo="4296" CountTypeID="105" />
          <TagInfo TagNo="4297" CountTypeID="105" />
          <TagInfo TagNo="4298" CountTypeID="105" />
          <TagInfo TagNo="4299" CountTypeID="105" />
          <TagInfo TagNo="4300" CountTypeID="105" />
          <TagInfo TagNo="4301" CountTypeID="105" />
          <TagInfo TagNo="4302" CountTypeID="105" />
          <TagInfo TagNo="4303" CountTypeID="105" />
          <TagInfo TagNo="4304" CountTypeID="105" />
          <TagInfo TagNo="4305" CountTypeID="105" />
          <TagInfo TagNo="4306" CountTypeID="105" />
          <TagInfo TagNo="4307" CountTypeID="105" />
          <TagInfo TagNo="4308" CountTypeID="105" />
          <TagInfo TagNo="4309" CountTypeID="105" />
          <TagInfo TagNo="4310" CountTypeID="105" />
          <TagInfo TagNo="4311" CountTypeID="105" />
          <TagInfo TagNo="4312" CountTypeID="105" />
          <TagInfo TagNo="4313" CountTypeID="105" />
          <TagInfo TagNo="4314" CountTypeID="105" />
          <TagInfo TagNo="4315" CountTypeID="105" />
          <TagInfo TagNo="4316" CountTypeID="105" />
          <TagInfo TagNo="4317" CountTypeID="105" />
          <TagInfo TagNo="4318" CountTypeID="105" />
          <TagInfo TagNo="4319" CountTypeID="105" />
          <TagInfo TagNo="4320" CountTypeID="105" />
        </TagRange>
        <TagRange TagRangeName="GM BACKLINE2" TagRangeDescription="" TagRangeFrom="4480" TagRangeTo="4530" DefaultCountTypeID="-1">
          <TagInfo TagNo="4480" CountTypeID="-1" />
          <TagInfo TagNo="4481" CountTypeID="-1" />
          <TagInfo TagNo="4482" CountTypeID="-1" />
          <TagInfo TagNo="4483" CountTypeID="-1" />
          <TagInfo TagNo="4484" CountTypeID="-1" />
          <TagInfo TagNo="4485" CountTypeID="-1" />
          <TagInfo TagNo="4486" CountTypeID="-1" />
          <TagInfo TagNo="4487" CountTypeID="-1" />
          <TagInfo TagNo="4488" CountTypeID="-1" />
          <TagInfo TagNo="4489" CountTypeID="-1" />
          <TagInfo TagNo="4490" CountTypeID="-1" />
          <TagInfo TagNo="4491" CountTypeID="-1" />
          <TagInfo TagNo="4492" CountTypeID="-1" />
          <TagInfo TagNo="4493" CountTypeID="-1" />
          <TagInfo TagNo="4494" CountTypeID="-1" />
          <TagInfo TagNo="4495" CountTypeID="-1" />
          <TagInfo TagNo="4496" CountTypeID="-1" />
          <TagInfo TagNo="4497" CountTypeID="-1" />
          <TagInfo TagNo="4498" CountTypeID="-1" />
          <TagInfo TagNo="4499" CountTypeID="-1" />
          <TagInfo TagNo="4500" CountTypeID="-1" />
          <TagInfo TagNo="4501" CountTypeID="-1" />
          <TagInfo TagNo="4502" CountTypeID="-1" />
          <TagInfo TagNo="4503" CountTypeID="-1" />
          <TagInfo TagNo="4504" CountTypeID="-1" />
          <TagInfo TagNo="4505" CountTypeID="-1" />
          <TagInfo TagNo="4506" CountTypeID="-1" />
          <TagInfo TagNo="4507" CountTypeID="-1" />
          <TagInfo TagNo="4508" CountTypeID="-1" />
          <TagInfo TagNo="4509" CountTypeID="-1" />
          <TagInfo TagNo="4510" CountTypeID="-1" />
          <TagInfo TagNo="4511" CountTypeID="-1" />
          <TagInfo TagNo="4512" CountTypeID="-1" />
          <TagInfo TagNo="4513" CountTypeID="-1" />
          <TagInfo TagNo="4514" CountTypeID="-1" />
          <TagInfo TagNo="4515" CountTypeID="-1" />
          <TagInfo TagNo="4516" CountTypeID="-1" />
          <TagInfo TagNo="4517" CountTypeID="-1" />
          <TagInfo TagNo="4518" CountTypeID="-1" />
          <TagInfo TagNo="4519" CountTypeID="-1" />
          <TagInfo TagNo="4520" CountTypeID="-1" />
          <TagInfo TagNo="4521" CountTypeID="-1" />
          <TagInfo TagNo="4522" CountTypeID="-1" />
          <TagInfo TagNo="4523" CountTypeID="-1" />
          <TagInfo TagNo="4524" CountTypeID="-1" />
          <TagInfo TagNo="4525" CountTypeID="-1" />
          <TagInfo TagNo="4526" CountTypeID="-1" />
          <TagInfo TagNo="4527" CountTypeID="-1" />
          <TagInfo TagNo="4528" CountTypeID="-1" />
          <TagInfo TagNo="4529" CountTypeID="-1" />
          <TagInfo TagNo="4530" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="ELECTRICAL BACKLINE" TagRangeDescription="" TagRangeFrom="4531" TagRangeTo="4599" DefaultCountTypeID="-1">
          <TagInfo TagNo="4531" CountTypeID="-1" />
          <TagInfo TagNo="4532" CountTypeID="-1" />
          <TagInfo TagNo="4533" CountTypeID="-1" />
          <TagInfo TagNo="4534" CountTypeID="-1" />
          <TagInfo TagNo="4535" CountTypeID="-1" />
          <TagInfo TagNo="4536" CountTypeID="-1" />
          <TagInfo TagNo="4537" CountTypeID="-1" />
          <TagInfo TagNo="4538" CountTypeID="-1" />
          <TagInfo TagNo="4539" CountTypeID="-1" />
          <TagInfo TagNo="4540" CountTypeID="-1" />
          <TagInfo TagNo="4541" CountTypeID="-1" />
          <TagInfo TagNo="4542" CountTypeID="-1" />
          <TagInfo TagNo="4543" CountTypeID="-1" />
          <TagInfo TagNo="4544" CountTypeID="-1" />
          <TagInfo TagNo="4545" CountTypeID="-1" />
          <TagInfo TagNo="4546" CountTypeID="-1" />
          <TagInfo TagNo="4547" CountTypeID="-1" />
          <TagInfo TagNo="4548" CountTypeID="-1" />
          <TagInfo TagNo="4549" CountTypeID="-1" />
          <TagInfo TagNo="4550" CountTypeID="-1" />
          <TagInfo TagNo="4551" CountTypeID="-1" />
          <TagInfo TagNo="4552" CountTypeID="-1" />
          <TagInfo TagNo="4553" CountTypeID="-1" />
          <TagInfo TagNo="4554" CountTypeID="-1" />
          <TagInfo TagNo="4555" CountTypeID="-1" />
          <TagInfo TagNo="4556" CountTypeID="-1" />
          <TagInfo TagNo="4557" CountTypeID="-1" />
          <TagInfo TagNo="4558" CountTypeID="-1" />
          <TagInfo TagNo="4559" CountTypeID="-1" />
          <TagInfo TagNo="4560" CountTypeID="-1" />
          <TagInfo TagNo="4561" CountTypeID="-1" />
          <TagInfo TagNo="4562" CountTypeID="-1" />
          <TagInfo TagNo="4563" CountTypeID="-1" />
          <TagInfo TagNo="4564" CountTypeID="-1" />
          <TagInfo TagNo="4565" CountTypeID="-1" />
          <TagInfo TagNo="4566" CountTypeID="-1" />
          <TagInfo TagNo="4567" CountTypeID="-1" />
          <TagInfo TagNo="4568" CountTypeID="-1" />
          <TagInfo TagNo="4569" CountTypeID="-1" />
          <TagInfo TagNo="4570" CountTypeID="-1" />
          <TagInfo TagNo="4571" CountTypeID="-1" />
          <TagInfo TagNo="4572" CountTypeID="-1" />
          <TagInfo TagNo="4573" CountTypeID="-1" />
          <TagInfo TagNo="4574" CountTypeID="-1" />
          <TagInfo TagNo="4575" CountTypeID="-1" />
          <TagInfo TagNo="4576" CountTypeID="-1" />
          <TagInfo TagNo="4577" CountTypeID="-1" />
          <TagInfo TagNo="4578" CountTypeID="-1" />
          <TagInfo TagNo="4579" CountTypeID="-1" />
          <TagInfo TagNo="4580" CountTypeID="-1" />
          <TagInfo TagNo="4581" CountTypeID="-1" />
          <TagInfo TagNo="4582" CountTypeID="-1" />
          <TagInfo TagNo="4583" CountTypeID="-1" />
          <TagInfo TagNo="4584" CountTypeID="-1" />
          <TagInfo TagNo="4585" CountTypeID="-1" />
          <TagInfo TagNo="4586" CountTypeID="-1" />
          <TagInfo TagNo="4587" CountTypeID="-1" />
          <TagInfo TagNo="4588" CountTypeID="-1" />
          <TagInfo TagNo="4589" CountTypeID="-1" />
          <TagInfo TagNo="4590" CountTypeID="-1" />
          <TagInfo TagNo="4591" CountTypeID="-1" />
          <TagInfo TagNo="4592" CountTypeID="-1" />
          <TagInfo TagNo="4593" CountTypeID="-1" />
          <TagInfo TagNo="4594" CountTypeID="-1" />
          <TagInfo TagNo="4595" CountTypeID="-1" />
          <TagInfo TagNo="4596" CountTypeID="-1" />
          <TagInfo TagNo="4597" CountTypeID="-1" />
          <TagInfo TagNo="4598" CountTypeID="-1" />
          <TagInfo TagNo="4599" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="GM HOME" TagRangeDescription="" TagRangeFrom="4600" TagRangeTo="4718" DefaultCountTypeID="-1">
          <TagInfo TagNo="4600" CountTypeID="-1" />
          <TagInfo TagNo="4601" CountTypeID="-1" />
          <TagInfo TagNo="4602" CountTypeID="-1" />
          <TagInfo TagNo="4603" CountTypeID="-1" />
          <TagInfo TagNo="4604" CountTypeID="-1" />
          <TagInfo TagNo="4605" CountTypeID="-1" />
          <TagInfo TagNo="4606" CountTypeID="-1" />
          <TagInfo TagNo="4607" CountTypeID="-1" />
          <TagInfo TagNo="4608" CountTypeID="-1" />
          <TagInfo TagNo="4609" CountTypeID="-1" />
          <TagInfo TagNo="4610" CountTypeID="-1" />
          <TagInfo TagNo="4611" CountTypeID="-1" />
          <TagInfo TagNo="4612" CountTypeID="-1" />
          <TagInfo TagNo="4613" CountTypeID="-1" />
          <TagInfo TagNo="4614" CountTypeID="-1" />
          <TagInfo TagNo="4615" CountTypeID="-1" />
          <TagInfo TagNo="4616" CountTypeID="-1" />
          <TagInfo TagNo="4617" CountTypeID="-1" />
          <TagInfo TagNo="4618" CountTypeID="-1" />
          <TagInfo TagNo="4619" CountTypeID="-1" />
          <TagInfo TagNo="4620" CountTypeID="-1" />
          <TagInfo TagNo="4621" CountTypeID="-1" />
          <TagInfo TagNo="4622" CountTypeID="-1" />
          <TagInfo TagNo="4623" CountTypeID="-1" />
          <TagInfo TagNo="4624" CountTypeID="-1" />
          <TagInfo TagNo="4625" CountTypeID="-1" />
          <TagInfo TagNo="4626" CountTypeID="-1" />
          <TagInfo TagNo="4627" CountTypeID="-1" />
          <TagInfo TagNo="4628" CountTypeID="-1" />
          <TagInfo TagNo="4629" CountTypeID="-1" />
          <TagInfo TagNo="4630" CountTypeID="-1" />
          <TagInfo TagNo="4631" CountTypeID="-1" />
          <TagInfo TagNo="4632" CountTypeID="-1" />
          <TagInfo TagNo="4633" CountTypeID="-1" />
          <TagInfo TagNo="4634" CountTypeID="-1" />
          <TagInfo TagNo="4635" CountTypeID="-1" />
          <TagInfo TagNo="4636" CountTypeID="-1" />
          <TagInfo TagNo="4637" CountTypeID="-1" />
          <TagInfo TagNo="4638" CountTypeID="-1" />
          <TagInfo TagNo="4639" CountTypeID="-1" />
          <TagInfo TagNo="4640" CountTypeID="-1" />
          <TagInfo TagNo="4641" CountTypeID="-1" />
          <TagInfo TagNo="4642" CountTypeID="-1" />
          <TagInfo TagNo="4643" CountTypeID="-1" />
          <TagInfo TagNo="4644" CountTypeID="-1" />
          <TagInfo TagNo="4645" CountTypeID="-1" />
          <TagInfo TagNo="4646" CountTypeID="-1" />
          <TagInfo TagNo="4647" CountTypeID="-1" />
          <TagInfo TagNo="4648" CountTypeID="-1" />
          <TagInfo TagNo="4649" CountTypeID="-1" />
          <TagInfo TagNo="4650" CountTypeID="-1" />
          <TagInfo TagNo="4651" CountTypeID="-1" />
          <TagInfo TagNo="4652" CountTypeID="-1" />
          <TagInfo TagNo="4653" CountTypeID="-1" />
          <TagInfo TagNo="4654" CountTypeID="-1" />
          <TagInfo TagNo="4655" CountTypeID="-1" />
          <TagInfo TagNo="4656" CountTypeID="-1" />
          <TagInfo TagNo="4657" CountTypeID="-1" />
          <TagInfo TagNo="4658" CountTypeID="-1" />
          <TagInfo TagNo="4659" CountTypeID="-1" />
          <TagInfo TagNo="4660" CountTypeID="-1" />
          <TagInfo TagNo="4661" CountTypeID="-1" />
          <TagInfo TagNo="4662" CountTypeID="-1" />
          <TagInfo TagNo="4663" CountTypeID="-1" />
          <TagInfo TagNo="4664" CountTypeID="-1" />
          <TagInfo TagNo="4665" CountTypeID="-1" />
          <TagInfo TagNo="4666" CountTypeID="-1" />
          <TagInfo TagNo="4667" CountTypeID="-1" />
          <TagInfo TagNo="4668" CountTypeID="-1" />
          <TagInfo TagNo="4669" CountTypeID="-1" />
          <TagInfo TagNo="4670" CountTypeID="-1" />
          <TagInfo TagNo="4671" CountTypeID="-1" />
          <TagInfo TagNo="4672" CountTypeID="-1" />
          <TagInfo TagNo="4673" CountTypeID="-1" />
          <TagInfo TagNo="4674" CountTypeID="-1" />
          <TagInfo TagNo="4675" CountTypeID="-1" />
          <TagInfo TagNo="4676" CountTypeID="-1" />
          <TagInfo TagNo="4677" CountTypeID="-1" />
          <TagInfo TagNo="4678" CountTypeID="-1" />
          <TagInfo TagNo="4679" CountTypeID="-1" />
          <TagInfo TagNo="4680" CountTypeID="-1" />
          <TagInfo TagNo="4681" CountTypeID="-1" />
          <TagInfo TagNo="4682" CountTypeID="-1" />
          <TagInfo TagNo="4683" CountTypeID="-1" />
          <TagInfo TagNo="4684" CountTypeID="-1" />
          <TagInfo TagNo="4685" CountTypeID="-1" />
          <TagInfo TagNo="4686" CountTypeID="-1" />
          <TagInfo TagNo="4687" CountTypeID="-1" />
          <TagInfo TagNo="4688" CountTypeID="-1" />
          <TagInfo TagNo="4689" CountTypeID="-1" />
          <TagInfo TagNo="4690" CountTypeID="-1" />
          <TagInfo TagNo="4691" CountTypeID="-1" />
          <TagInfo TagNo="4692" CountTypeID="-1" />
          <TagInfo TagNo="4693" CountTypeID="-1" />
          <TagInfo TagNo="4694" CountTypeID="-1" />
          <TagInfo TagNo="4695" CountTypeID="-1" />
          <TagInfo TagNo="4696" CountTypeID="-1" />
          <TagInfo TagNo="4697" CountTypeID="-1" />
          <TagInfo TagNo="4698" CountTypeID="-1" />
          <TagInfo TagNo="4699" CountTypeID="-1" />
          <TagInfo TagNo="4700" CountTypeID="-1" />
          <TagInfo TagNo="4701" CountTypeID="-1" />
          <TagInfo TagNo="4702" CountTypeID="-1" />
          <TagInfo TagNo="4703" CountTypeID="-1" />
          <TagInfo TagNo="4704" CountTypeID="-1" />
          <TagInfo TagNo="4705" CountTypeID="-1" />
          <TagInfo TagNo="4706" CountTypeID="-1" />
          <TagInfo TagNo="4707" CountTypeID="-1" />
          <TagInfo TagNo="4708" CountTypeID="-1" />
          <TagInfo TagNo="4709" CountTypeID="-1" />
          <TagInfo TagNo="4710" CountTypeID="-1" />
          <TagInfo TagNo="4711" CountTypeID="-1" />
          <TagInfo TagNo="4712" CountTypeID="-1" />
          <TagInfo TagNo="4713" CountTypeID="-1" />
          <TagInfo TagNo="4714" CountTypeID="-1" />
          <TagInfo TagNo="4715" CountTypeID="-1" />
          <TagInfo TagNo="4716" CountTypeID="-1" />
          <TagInfo TagNo="4717" CountTypeID="-1" />
          <TagInfo TagNo="4718" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="Foyer extra" TagRangeDescription="" TagRangeFrom="5001" TagRangeTo="5021" DefaultCountTypeID="-1">
          <TagInfo TagNo="5001" CountTypeID="-1" />
          <TagInfo TagNo="5002" CountTypeID="-1" />
          <TagInfo TagNo="5003" CountTypeID="-1" />
          <TagInfo TagNo="5004" CountTypeID="-1" />
          <TagInfo TagNo="5005" CountTypeID="-1" />
          <TagInfo TagNo="5006" CountTypeID="-1" />
          <TagInfo TagNo="5007" CountTypeID="-1" />
          <TagInfo TagNo="5008" CountTypeID="-1" />
          <TagInfo TagNo="5009" CountTypeID="-1" />
          <TagInfo TagNo="5010" CountTypeID="-1" />
          <TagInfo TagNo="5011" CountTypeID="-1" />
          <TagInfo TagNo="5012" CountTypeID="-1" />
          <TagInfo TagNo="5013" CountTypeID="-1" />
          <TagInfo TagNo="5014" CountTypeID="-1" />
          <TagInfo TagNo="5015" CountTypeID="-1" />
          <TagInfo TagNo="5016" CountTypeID="-1" />
          <TagInfo TagNo="5017" CountTypeID="-1" />
          <TagInfo TagNo="5018" CountTypeID="-1" />
          <TagInfo TagNo="5019" CountTypeID="-1" />
          <TagInfo TagNo="5020" CountTypeID="-1" />
          <TagInfo TagNo="5021" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="Optical" TagRangeDescription="" TagRangeFrom="5401" TagRangeTo="5422" DefaultCountTypeID="25">
          <TagInfo TagNo="5401" CountTypeID="25" />
          <TagInfo TagNo="5402" CountTypeID="25" />
          <TagInfo TagNo="5403" CountTypeID="25" />
          <TagInfo TagNo="5404" CountTypeID="25" />
          <TagInfo TagNo="5405" CountTypeID="25" />
          <TagInfo TagNo="5406" CountTypeID="25" />
          <TagInfo TagNo="5407" CountTypeID="25" />
          <TagInfo TagNo="5408" CountTypeID="25" />
          <TagInfo TagNo="5409" CountTypeID="25" />
          <TagInfo TagNo="5410" CountTypeID="25" />
          <TagInfo TagNo="5411" CountTypeID="25" />
          <TagInfo TagNo="5412" CountTypeID="25" />
          <TagInfo TagNo="5413" CountTypeID="25" />
          <TagInfo TagNo="5414" CountTypeID="25" />
          <TagInfo TagNo="5415" CountTypeID="25" />
          <TagInfo TagNo="5416" CountTypeID="25" />
          <TagInfo TagNo="5417" CountTypeID="25" />
          <TagInfo TagNo="5418" CountTypeID="25" />
          <TagInfo TagNo="5419" CountTypeID="25" />
          <TagInfo TagNo="5420" CountTypeID="25" />
          <TagInfo TagNo="5421" CountTypeID="25" />
          <TagInfo TagNo="5422" CountTypeID="25" />
        </TagRange>
      </GroupRange>
      <GroupRange GroupName="GROCERY" GroupDescription="">
        <TagRange TagRangeName="GROCERY BACKLINE" TagRangeDescription="" TagRangeFrom="3846" TagRangeTo="3867" DefaultCountTypeID="-1">
          <TagInfo TagNo="3846" CountTypeID="-1" />
          <TagInfo TagNo="3847" CountTypeID="-1" />
          <TagInfo TagNo="3848" CountTypeID="-1" />
          <TagInfo TagNo="3849" CountTypeID="-1" />
          <TagInfo TagNo="3850" CountTypeID="-1" />
          <TagInfo TagNo="3851" CountTypeID="-1" />
          <TagInfo TagNo="3852" CountTypeID="-1" />
          <TagInfo TagNo="3853" CountTypeID="-1" />
          <TagInfo TagNo="3854" CountTypeID="-1" />
          <TagInfo TagNo="3855" CountTypeID="-1" />
          <TagInfo TagNo="3856" CountTypeID="-1" />
          <TagInfo TagNo="3857" CountTypeID="-1" />
          <TagInfo TagNo="3858" CountTypeID="-1" />
          <TagInfo TagNo="3859" CountTypeID="-1" />
          <TagInfo TagNo="3860" CountTypeID="-1" />
          <TagInfo TagNo="3861" CountTypeID="-1" />
          <TagInfo TagNo="3862" CountTypeID="-1" />
          <TagInfo TagNo="3863" CountTypeID="-1" />
          <TagInfo TagNo="3864" CountTypeID="-1" />
          <TagInfo TagNo="3865" CountTypeID="-1" />
          <TagInfo TagNo="3866" CountTypeID="-1" />
          <TagInfo TagNo="3867" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="BACKWALL" TagRangeDescription="" TagRangeFrom="4454" TagRangeTo="4479" DefaultCountTypeID="-1">
          <TagInfo TagNo="4454" CountTypeID="-1" />
          <TagInfo TagNo="4455" CountTypeID="-1" />
          <TagInfo TagNo="4456" CountTypeID="-1" />
          <TagInfo TagNo="4457" CountTypeID="-1" />
          <TagInfo TagNo="4458" CountTypeID="-1" />
          <TagInfo TagNo="4459" CountTypeID="-1" />
          <TagInfo TagNo="4460" CountTypeID="-1" />
          <TagInfo TagNo="4461" CountTypeID="-1" />
          <TagInfo TagNo="4462" CountTypeID="-1" />
          <TagInfo TagNo="4463" CountTypeID="-1" />
          <TagInfo TagNo="4464" CountTypeID="-1" />
          <TagInfo TagNo="4465" CountTypeID="-1" />
          <TagInfo TagNo="4466" CountTypeID="-1" />
          <TagInfo TagNo="4467" CountTypeID="-1" />
          <TagInfo TagNo="4468" CountTypeID="-1" />
          <TagInfo TagNo="4469" CountTypeID="-1" />
          <TagInfo TagNo="4470" CountTypeID="-1" />
          <TagInfo TagNo="4471" CountTypeID="-1" />
          <TagInfo TagNo="4472" CountTypeID="-1" />
          <TagInfo TagNo="4473" CountTypeID="-1" />
          <TagInfo TagNo="4474" CountTypeID="-1" />
          <TagInfo TagNo="4475" CountTypeID="-1" />
          <TagInfo TagNo="4476" CountTypeID="-1" />
          <TagInfo TagNo="4477" CountTypeID="-1" />
          <TagInfo TagNo="4478" CountTypeID="-1" />
          <TagInfo TagNo="4479" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="TOPSTOCK" TagRangeDescription="" TagRangeFrom="5501" TagRangeTo="5563" DefaultCountTypeID="11">
          <TagInfo TagNo="5501" CountTypeID="11" />
          <TagInfo TagNo="5502" CountTypeID="11" />
          <TagInfo TagNo="5503" CountTypeID="11" />
          <TagInfo TagNo="5504" CountTypeID="11" />
          <TagInfo TagNo="5505" CountTypeID="11" />
          <TagInfo TagNo="5506" CountTypeID="11" />
          <TagInfo TagNo="5507" CountTypeID="11" />
          <TagInfo TagNo="5508" CountTypeID="11" />
          <TagInfo TagNo="5509" CountTypeID="11" />
          <TagInfo TagNo="5510" CountTypeID="11" />
          <TagInfo TagNo="5511" CountTypeID="11" />
          <TagInfo TagNo="5512" CountTypeID="11" />
          <TagInfo TagNo="5513" CountTypeID="11" />
          <TagInfo TagNo="5514" CountTypeID="11" />
          <TagInfo TagNo="5515" CountTypeID="11" />
          <TagInfo TagNo="5516" CountTypeID="11" />
          <TagInfo TagNo="5517" CountTypeID="11" />
          <TagInfo TagNo="5518" CountTypeID="11" />
          <TagInfo TagNo="5519" CountTypeID="11" />
          <TagInfo TagNo="5520" CountTypeID="11" />
          <TagInfo TagNo="5521" CountTypeID="11" />
          <TagInfo TagNo="5522" CountTypeID="11" />
          <TagInfo TagNo="5523" CountTypeID="11" />
          <TagInfo TagNo="5524" CountTypeID="11" />
          <TagInfo TagNo="5525" CountTypeID="11" />
          <TagInfo TagNo="5526" CountTypeID="11" />
          <TagInfo TagNo="5527" CountTypeID="11" />
          <TagInfo TagNo="5528" CountTypeID="11" />
          <TagInfo TagNo="5529" CountTypeID="11" />
          <TagInfo TagNo="5530" CountTypeID="11" />
          <TagInfo TagNo="5531" CountTypeID="11" />
          <TagInfo TagNo="5532" CountTypeID="11" />
          <TagInfo TagNo="5533" CountTypeID="11" />
          <TagInfo TagNo="5534" CountTypeID="11" />
          <TagInfo TagNo="5535" CountTypeID="11" />
          <TagInfo TagNo="5536" CountTypeID="11" />
          <TagInfo TagNo="5537" CountTypeID="11" />
          <TagInfo TagNo="5538" CountTypeID="11" />
          <TagInfo TagNo="5539" CountTypeID="11" />
          <TagInfo TagNo="5540" CountTypeID="11" />
          <TagInfo TagNo="5541" CountTypeID="11" />
          <TagInfo TagNo="5542" CountTypeID="11" />
          <TagInfo TagNo="5543" CountTypeID="11" />
          <TagInfo TagNo="5544" CountTypeID="11" />
          <TagInfo TagNo="5545" CountTypeID="11" />
          <TagInfo TagNo="5546" CountTypeID="11" />
          <TagInfo TagNo="5547" CountTypeID="11" />
          <TagInfo TagNo="5548" CountTypeID="11" />
          <TagInfo TagNo="5549" CountTypeID="11" />
          <TagInfo TagNo="5550" CountTypeID="11" />
          <TagInfo TagNo="5551" CountTypeID="11" />
          <TagInfo TagNo="5552" CountTypeID="11" />
          <TagInfo TagNo="5553" CountTypeID="11" />
          <TagInfo TagNo="5554" CountTypeID="11" />
          <TagInfo TagNo="5555" CountTypeID="11" />
          <TagInfo TagNo="5556" CountTypeID="11" />
          <TagInfo TagNo="5557" CountTypeID="11" />
          <TagInfo TagNo="5558" CountTypeID="11" />
          <TagInfo TagNo="5559" CountTypeID="11" />
          <TagInfo TagNo="5560" CountTypeID="11" />
          <TagInfo TagNo="5561" CountTypeID="11" />
          <TagInfo TagNo="5562" CountTypeID="11" />
          <TagInfo TagNo="5563" CountTypeID="11" />
        </TagRange>
      </GroupRange>
      <GroupRange GroupName="VARIANCE DEPARTMENTS" GroupDescription="">
        <TagRange TagRangeName="KIOSK" TagRangeDescription="" TagRangeFrom="2751" TagRangeTo="2766" DefaultCountTypeID="-1">
          <TagInfo TagNo="2751" CountTypeID="-1" />
          <TagInfo TagNo="2752" CountTypeID="-1" />
          <TagInfo TagNo="2753" CountTypeID="-1" />
          <TagInfo TagNo="2754" CountTypeID="-1" />
          <TagInfo TagNo="2755" CountTypeID="-1" />
          <TagInfo TagNo="2756" CountTypeID="-1" />
          <TagInfo TagNo="2757" CountTypeID="-1" />
          <TagInfo TagNo="2758" CountTypeID="-1" />
          <TagInfo TagNo="2759" CountTypeID="-1" />
          <TagInfo TagNo="2760" CountTypeID="-1" />
          <TagInfo TagNo="2761" CountTypeID="-1" />
          <TagInfo TagNo="2762" CountTypeID="-1" />
          <TagInfo TagNo="2763" CountTypeID="-1" />
          <TagInfo TagNo="2764" CountTypeID="-1" />
          <TagInfo TagNo="2765" CountTypeID="-1" />
          <TagInfo TagNo="2766" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="BWS" TagRangeDescription="" TagRangeFrom="3868" TagRangeTo="3900" DefaultCountTypeID="-1">
          <TagInfo TagNo="3868" CountTypeID="-1" />
          <TagInfo TagNo="3869" CountTypeID="-1" />
          <TagInfo TagNo="3870" CountTypeID="-1" />
          <TagInfo TagNo="3871" CountTypeID="-1" />
          <TagInfo TagNo="3872" CountTypeID="-1" />
          <TagInfo TagNo="3873" CountTypeID="-1" />
          <TagInfo TagNo="3874" CountTypeID="-1" />
          <TagInfo TagNo="3875" CountTypeID="-1" />
          <TagInfo TagNo="3876" CountTypeID="-1" />
          <TagInfo TagNo="3877" CountTypeID="-1" />
          <TagInfo TagNo="3878" CountTypeID="-1" />
          <TagInfo TagNo="3879" CountTypeID="-1" />
          <TagInfo TagNo="3880" CountTypeID="-1" />
          <TagInfo TagNo="3881" CountTypeID="-1" />
          <TagInfo TagNo="3882" CountTypeID="-1" />
          <TagInfo TagNo="3883" CountTypeID="-1" />
          <TagInfo TagNo="3884" CountTypeID="-1" />
          <TagInfo TagNo="3885" CountTypeID="-1" />
          <TagInfo TagNo="3886" CountTypeID="-1" />
          <TagInfo TagNo="3887" CountTypeID="-1" />
          <TagInfo TagNo="3888" CountTypeID="-1" />
          <TagInfo TagNo="3889" CountTypeID="-1" />
          <TagInfo TagNo="3890" CountTypeID="-1" />
          <TagInfo TagNo="3891" CountTypeID="-1" />
          <TagInfo TagNo="3892" CountTypeID="-1" />
          <TagInfo TagNo="3893" CountTypeID="-1" />
          <TagInfo TagNo="3894" CountTypeID="-1" />
          <TagInfo TagNo="3895" CountTypeID="-1" />
          <TagInfo TagNo="3896" CountTypeID="-1" />
          <TagInfo TagNo="3897" CountTypeID="-1" />
          <TagInfo TagNo="3898" CountTypeID="-1" />
          <TagInfo TagNo="3899" CountTypeID="-1" />
          <TagInfo TagNo="3900" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="BWS3" TagRangeDescription="" TagRangeFrom="4001" TagRangeTo="4038" DefaultCountTypeID="-1">
          <TagInfo TagNo="4001" CountTypeID="-1" />
          <TagInfo TagNo="4002" CountTypeID="-1" />
          <TagInfo TagNo="4003" CountTypeID="-1" />
          <TagInfo TagNo="4004" CountTypeID="-1" />
          <TagInfo TagNo="4005" CountTypeID="-1" />
          <TagInfo TagNo="4006" CountTypeID="-1" />
          <TagInfo TagNo="4007" CountTypeID="-1" />
          <TagInfo TagNo="4008" CountTypeID="-1" />
          <TagInfo TagNo="4009" CountTypeID="-1" />
          <TagInfo TagNo="4010" CountTypeID="-1" />
          <TagInfo TagNo="4011" CountTypeID="-1" />
          <TagInfo TagNo="4012" CountTypeID="-1" />
          <TagInfo TagNo="4013" CountTypeID="-1" />
          <TagInfo TagNo="4014" CountTypeID="-1" />
          <TagInfo TagNo="4015" CountTypeID="-1" />
          <TagInfo TagNo="4016" CountTypeID="-1" />
          <TagInfo TagNo="4017" CountTypeID="-1" />
          <TagInfo TagNo="4018" CountTypeID="-1" />
          <TagInfo TagNo="4019" CountTypeID="-1" />
          <TagInfo TagNo="4020" CountTypeID="-1" />
          <TagInfo TagNo="4021" CountTypeID="-1" />
          <TagInfo TagNo="4022" CountTypeID="-1" />
          <TagInfo TagNo="4023" CountTypeID="-1" />
          <TagInfo TagNo="4024" CountTypeID="-1" />
          <TagInfo TagNo="4025" CountTypeID="-1" />
          <TagInfo TagNo="4026" CountTypeID="-1" />
          <TagInfo TagNo="4027" CountTypeID="-1" />
          <TagInfo TagNo="4028" CountTypeID="-1" />
          <TagInfo TagNo="4029" CountTypeID="-1" />
          <TagInfo TagNo="4030" CountTypeID="-1" />
          <TagInfo TagNo="4031" CountTypeID="-1" />
          <TagInfo TagNo="4032" CountTypeID="-1" />
          <TagInfo TagNo="4033" CountTypeID="-1" />
          <TagInfo TagNo="4034" CountTypeID="-1" />
          <TagInfo TagNo="4035" CountTypeID="-1" />
          <TagInfo TagNo="4036" CountTypeID="-1" />
          <TagInfo TagNo="4037" CountTypeID="-1" />
          <TagInfo TagNo="4038" CountTypeID="-1" />
        </TagRange>
        <TagRange TagRangeName="MVG " TagRangeDescription="" TagRangeFrom="4801" TagRangeTo="4931" DefaultCountTypeID="111">
          <TagInfo TagNo="4801" CountTypeID="111" />
          <TagInfo TagNo="4802" CountTypeID="111" />
          <TagInfo TagNo="4803" CountTypeID="111" />
          <TagInfo TagNo="4804" CountTypeID="111" />
          <TagInfo TagNo="4805" CountTypeID="111" />
          <TagInfo TagNo="4806" CountTypeID="111" />
          <TagInfo TagNo="4807" CountTypeID="111" />
          <TagInfo TagNo="4808" CountTypeID="111" />
          <TagInfo TagNo="4809" CountTypeID="111" />
          <TagInfo TagNo="4810" CountTypeID="111" />
          <TagInfo TagNo="4811" CountTypeID="111" />
          <TagInfo TagNo="4812" CountTypeID="111" />
          <TagInfo TagNo="4813" CountTypeID="111" />
          <TagInfo TagNo="4814" CountTypeID="111" />
          <TagInfo TagNo="4815" CountTypeID="111" />
          <TagInfo TagNo="4816" CountTypeID="111" />
          <TagInfo TagNo="4817" CountTypeID="111" />
          <TagInfo TagNo="4818" CountTypeID="111" />
          <TagInfo TagNo="4819" CountTypeID="111" />
          <TagInfo TagNo="4820" CountTypeID="111" />
          <TagInfo TagNo="4821" CountTypeID="111" />
          <TagInfo TagNo="4822" CountTypeID="111" />
          <TagInfo TagNo="4823" CountTypeID="111" />
          <TagInfo TagNo="4824" CountTypeID="111" />
          <TagInfo TagNo="4825" CountTypeID="111" />
          <TagInfo TagNo="4826" CountTypeID="111" />
          <TagInfo TagNo="4827" CountTypeID="111" />
          <TagInfo TagNo="4828" CountTypeID="111" />
          <TagInfo TagNo="4829" CountTypeID="111" />
          <TagInfo TagNo="4830" CountTypeID="111" />
          <TagInfo TagNo="4831" CountTypeID="111" />
          <TagInfo TagNo="4832" CountTypeID="111" />
          <TagInfo TagNo="4833" CountTypeID="111" />
          <TagInfo TagNo="4834" CountTypeID="111" />
          <TagInfo TagNo="4835" CountTypeID="111" />
          <TagInfo TagNo="4836" CountTypeID="111" />
          <TagInfo TagNo="4837" CountTypeID="111" />
          <TagInfo TagNo="4838" CountTypeID="111" />
          <TagInfo TagNo="4839" CountTypeID="111" />
          <TagInfo TagNo="4840" CountTypeID="111" />
          <TagInfo TagNo="4841" CountTypeID="111" />
          <TagInfo TagNo="4842" CountTypeID="111" />
          <TagInfo TagNo="4843" CountTypeID="111" />
          <TagInfo TagNo="4844" CountTypeID="111" />
          <TagInfo TagNo="4845" CountTypeID="111" />
          <TagInfo TagNo="4846" CountTypeID="111" />
          <TagInfo TagNo="4847" CountTypeID="111" />
          <TagInfo TagNo="4848" CountTypeID="111" />
          <TagInfo TagNo="4849" CountTypeID="111" />
          <TagInfo TagNo="4850" CountTypeID="111" />
          <TagInfo TagNo="4851" CountTypeID="111" />
          <TagInfo TagNo="4852" CountTypeID="111" />
          <TagInfo TagNo="4853" CountTypeID="111" />
          <TagInfo TagNo="4854" CountTypeID="111" />
          <TagInfo TagNo="4855" CountTypeID="111" />
          <TagInfo TagNo="4856" CountTypeID="111" />
          <TagInfo TagNo="4857" CountTypeID="111" />
          <TagInfo TagNo="4858" CountTypeID="111" />
          <TagInfo TagNo="4859" CountTypeID="111" />
          <TagInfo TagNo="4860" CountTypeID="111" />
          <TagInfo TagNo="4861" CountTypeID="111" />
          <TagInfo TagNo="4862" CountTypeID="111" />
          <TagInfo TagNo="4863" CountTypeID="111" />
          <TagInfo TagNo="4864" CountTypeID="111" />
          <TagInfo TagNo="4865" CountTypeID="111" />
          <TagInfo TagNo="4866" CountTypeID="111" />
          <TagInfo TagNo="4867" CountTypeID="111" />
          <TagInfo TagNo="4868" CountTypeID="111" />
          <TagInfo TagNo="4869" CountTypeID="111" />
          <TagInfo TagNo="4870" CountTypeID="111" />
          <TagInfo TagNo="4871" CountTypeID="111" />
          <TagInfo TagNo="4872" CountTypeID="111" />
          <TagInfo TagNo="4873" CountTypeID="111" />
          <TagInfo TagNo="4874" CountTypeID="111" />
          <TagInfo TagNo="4875" CountTypeID="111" />
          <TagInfo TagNo="4876" CountTypeID="111" />
          <TagInfo TagNo="4877" CountTypeID="111" />
          <TagInfo TagNo="4878" CountTypeID="111" />
          <TagInfo TagNo="4879" CountTypeID="111" />
          <TagInfo TagNo="4880" CountTypeID="111" />
          <TagInfo TagNo="4881" CountTypeID="111" />
          <TagInfo TagNo="4882" CountTypeID="111" />
          <TagInfo TagNo="4883" CountTypeID="111" />
          <TagInfo TagNo="4884" CountTypeID="111" />
          <TagInfo TagNo="4885" CountTypeID="111" />
          <TagInfo TagNo="4886" CountTypeID="111" />
          <TagInfo TagNo="4887" CountTypeID="111" />
          <TagInfo TagNo="4888" CountTypeID="111" />
          <TagInfo TagNo="4889" CountTypeID="111" />
          <TagInfo TagNo="4890" CountTypeID="111" />
          <TagInfo TagNo="4891" CountTypeID="111" />
          <TagInfo TagNo="4892" CountTypeID="111" />
          <TagInfo TagNo="4893" CountTypeID="111" />
          <TagInfo TagNo="4894" CountTypeID="111" />
          <TagInfo TagNo="4895" CountTypeID="111" />
          <TagInfo TagNo="4896" CountTypeID="111" />
          <TagInfo TagNo="4897" CountTypeID="111" />
          <TagInfo TagNo="4898" CountTypeID="111" />
          <TagInfo TagNo="4899" CountTypeID="111" />
          <TagInfo TagNo="4900" CountTypeID="111" />
          <TagInfo TagNo="4901" CountTypeID="111" />
          <TagInfo TagNo="4902" CountTypeID="111" />
          <TagInfo TagNo="4903" CountTypeID="111" />
          <TagInfo TagNo="4904" CountTypeID="111" />
          <TagInfo TagNo="4905" CountTypeID="111" />
          <TagInfo TagNo="4906" CountTypeID="111" />
          <TagInfo TagNo="4907" CountTypeID="111" />
          <TagInfo TagNo="4908" CountTypeID="111" />
          <TagInfo TagNo="4909" CountTypeID="111" />
          <TagInfo TagNo="4910" CountTypeID="111" />
          <TagInfo TagNo="4911" CountTypeID="111" />
          <TagInfo TagNo="4912" CountTypeID="111" />
          <TagInfo TagNo="4913" CountTypeID="111" />
          <TagInfo TagNo="4914" CountTypeID="111" />
          <TagInfo TagNo="4915" CountTypeID="111" />
          <TagInfo TagNo="4916" CountTypeID="111" />
          <TagInfo TagNo="4917" CountTypeID="111" />
          <TagInfo TagNo="4918" CountTypeID="111" />
          <TagInfo TagNo="4919" CountTypeID="111" />
          <TagInfo TagNo="4920" CountTypeID="111" />
          <TagInfo TagNo="4921" CountTypeID="111" />
          <TagInfo TagNo="4922" CountTypeID="111" />
          <TagInfo TagNo="4923" CountTypeID="111" />
          <TagInfo TagNo="4924" CountTypeID="111" />
          <TagInfo TagNo="4925" CountTypeID="111" />
          <TagInfo TagNo="4926" CountTypeID="111" />
          <TagInfo TagNo="4927" CountTypeID="111" />
          <TagInfo TagNo="4928" CountTypeID="111" />
          <TagInfo TagNo="4929" CountTypeID="111" />
          <TagInfo TagNo="4930" CountTypeID="111" />
          <TagInfo TagNo="4931" CountTypeID="111" />
        </TagRange>
      </GroupRange>
    </SoftwareID>

    Thanks for taking the time to read such a long thread, hope someone can help with this

    Had to ZIP the two source files as file types where not supported

    XML Help VBA Express.xlsm
    XML.zip

  2. #2
    VBAX Regular
    Joined
    May 2015
    Posts
    34
    Location
    Not sure how much of a difference it makes but the number of Tag Ranges within a group changes from store to store. so the new code would need to accommodate this.

    Thanks

  3. #3
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Something like this is a start, but you need to some how pass "strXML_Location" to WRTImport
    
    
    Sub WRTImport(strXML_Location As String)
    'code for importing
    
       Application.ScreenUpdating = False
         
        Sheets("Import").Visible = True
        Sheets("Import").Cells.ClearContents
         
        ActiveWorkbook.XmlImport URL:= _
        strXML_Location, ImportMap:=Nothing, _
        Overwrite:=True, Destination:=Range("$A$1")
         
    GracefulExit:
       Application.ScreenUpdating = True
    End Sub
     
    Sub createWalkOff()
    'addsthe ranges to sheet "Walk Off"
         
        '3100 ~ Number of lines in new XML example
        Dim strArea(3100) As String
        Dim strName(3100) As String 'Not used
        Dim strRange(3100) As String 'Not used
        Dim lngRw As Long, lngSrw As Long, lngWrw As Long, lngGrw As Long
        Dim i As Long
    Dim FoundGeorge As Boolean
    Dim FoundWarehouse As Boolean
        
        Application.ScreenUpdating = False
         
        WRTImport
          
        intA = 0
         
         
         
         'Dump ranges into an array
        With Sheets("Import")
          For lngRw = 1 To 90
            If Cells(lngRw, 2) = "" Then Exit For
            i = lngRw - 1
            strArea(i) = .Cells(lngRw, "B")
            strName(i) = .Cells(lngRw, "D") 'Not used
            strRange(i) = .Cells(lngRw, "F") & " - " & .Cells(lngRw, "G") 'Not used
          Next lngRw
         End With
         
         'Insert shopfloor ranges.
          With Sheets("Walk Off")
          'Clear walk-off sheet
           'Sheets("Walk Off").Range("B8:D35", "J8:N20", "J23:N27", "J22:N22", "J29:N39").ClearContents
           .Range("B8:D3100", "J8:N20", "J22:N27", "J29:N39").ClearContents
           'Probably need to edit the above line Since Geore and Warehouse changed
           
           
            lngSrw = 9
            lngWrw = 9
            lngGrw = 9
            For i = LBound(strArea) To UBound(strArea)
              Select Case strArea(i)
                Case "STORE", "SCHEDULE 9`S", "FRESH", "GM", "GROCERY", "VARIANCE DEPARTMENTS"
                  .Cells(lngSrw, "B") = strArea(i)
                  lngSrw = lngSrw + 1
                Case "WAREHOUSE"
                     'Which came first, Warehouse or George?
                    If FoundGeorge And Not FoundWarehouse Then
                    lngWrw = lngGrw + 1
                    FoundWarehouse = True
                    End If
                    .Cells(lngWrw, "J") = "WAREHOUSE"
                    lngWrw = lngWrw + 1
                Case "GEORGE"
                    If FoundWarehouse And Not FoundGeorge Then
                    lngGrw = lngWrw + 1
                    FoundGeorge = True
                    End If
                    .Cells(lngRw + 21, "J") = "GEORGE"
                    lngGrw = lngGrw + 1
                Case Else: Exit For 'Assumes no empty values in strArea
                Case Else: Exit For 'Assumes no empty values in strArea
              End Select
            Next i
          End With
        
           'printcurrent
        Sheets("Import").Visible = False
        Sheets("Main").Select
         
    GracefulExit:
       Application.ScreenUpdating = True
    End Sub
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  4. #4
    VBAX Regular
    Joined
    May 2015
    Posts
    34
    Location
    Hi SamT,
    Thanks for your reply. My XML data is importing to "Import" with no issues

    On the main code i get a Compile Error "Case without Select Case" on the second repeated line.

                Case Else: Exit For 'Assumes no empty values in strArea
                Case Else: Exit For 'Assumes no empty values in strArea
    I commented the line out to see what happened and i got an error on this line

    .Range("B8:E39", "J8:N27", "J29:N39").ClearContents
    Now that i have seen the imported XML file its obvious how each TagRangeName has a line for every tag within its range

    What i need is every unique TagRangeName from each GroupName with its respected From and To numbers on my walk off

    This might have been obvious and i dont mean to insult your intelligence i just dont want to send you on the wrong path

    Workbook with new XML Imported XML Help VBA Express - Copy.xlsm

    Thanks for your time

    Value GroupName GroupDescription TagRangeName TagRangeDescription TagRangeFrom TagRangeTo DefaultCountTypeID TagNo
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 22
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 23
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 24
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 25
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 26
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 27
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 28
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 29
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 30
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 31
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 32
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 33
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 34
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 35
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 36
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 37
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 38
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 39
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 40
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 41
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 42
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 43
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 44
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 45
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 46
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 47
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 48
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 49
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 50
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 51
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 52
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 53
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 54
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 55
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 56
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 57
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 58
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 59
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 60
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 61
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 62
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 63
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 64
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 65
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 66
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 67
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 68
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 69
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 70
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 71
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 72
    7213 GEORGE TOTES DOWNSTAIRS 22 73 -1 73
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 205
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 206
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 207
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 208
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 209
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 210
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 211
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 212
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 213
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 214
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 215
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 216
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 217
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 218
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 219
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 220
    7213 GEORGE TOTES DOWNSTAIRS. 205 221 -1 221
    7213 GEORGE HANGING W/H 601 647 -1 601
    7213 GEORGE HANGING W/H 601 647 -1 602
    7213 GEORGE HANGING W/H 601 647 -1 603
    7213 GEORGE HANGING W/H 601 647 -1 604
    7213 GEORGE HANGING W/H 601 647 -1 605
    7213 GEORGE HANGING W/H 601 647 -1 606
    7213 GEORGE HANGING W/H 601 647 -1 607
    7213 GEORGE HANGING W/H 601 647 -1 608
    7213 GEORGE HANGING W/H 601 647 -1 609
    7213 GEORGE HANGING W/H 601 647 -1 610
    7213 GEORGE HANGING W/H 601 647 -1 611
    Last edited by GribbiN; 01-24-2016 at 02:41 AM. Reason: Added attachment

  5. #5
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    I too have been working on this.
    GribbiN, is the Import sheet, once loaded, required for anything else at all in the workbook (or outside of it for that matter); I want to manipulate the data on that sheet, and perhaps do away with it altogether.
    SamT, if the answer to the above is that it isn't required for anything else, then on the import sheet, a:
    Sheets("Import").ListObjects(1).Range.RemoveDuplicates Columns:=Array(2, 4), Header:=xlYes
    then maybe delete a column or two, concatenate a couple of columns…

    where's my coat?
    Last edited by p45cal; 01-24-2016 at 07:39 AM.

  6. #6
    VBAX Regular
    Joined
    May 2015
    Posts
    34
    Location
    Hi P45cal,

    The import sheet is only used to add the data to the walk off each day nothing else. You can manipulate it all you want if this gets my ranges onto the walk off sheet.

    The walk off is printed off and used as a working document during inventory so once I have 1 printed copy the data is no longer used

    Thanks for your time also

    John

  7. #7
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    A not very robust solution attached.
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  8. #8
    VBAX Regular
    Joined
    May 2015
    Posts
    34
    Location
    Thanks for the work so far its greatly appreciated

    I got a Run-time error '1004':

    Application-defined or object-defined error

    on this line

    .FormulaR1C1 = "=[@TagRangeFrom] & "" - "" & [@TagRangeTo]"

  9. #9
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    I'm sorry, missed a change in producing your copy. In the code, 4 or 5 lines above that line you have:
    With ThisWorkbook.Sheets("Import (3)").ListObjects(1)
    change it to:
    With ThisWorkbook.Sheets("Import").ListObjects(1)
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  10. #10
    VBAX Regular
    Joined
    May 2015
    Posts
    34
    Location
    Desk.JPG

    Still fails on the same line when using either of the two macros Creatwalkoff and Macro12

  11. #11
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    If you unhide the Import sheet, does it have the column headers TagRangeFrom and TagRangeTo. You can hide it again after checking.
    Otherwise, we could try a TeamViewer session if you have it and you Private Message (here at vbaExpress) me a 'phone number.

    edit post posting:
    Aha! There shouldn't be a Macro12 at all!
    Make all corrections to CreateWalkOff, and click the button/shape on the main sheet to run it.
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  12. #12
    VBAX Regular
    Joined
    May 2015
    Posts
    34
    Location
    Same issue, deleted 12. Used main button.

    Imports XML, Removes Duplicates then fails on the same line.

  13. #13
    VBAX Regular
    Joined
    May 2015
    Posts
    34
    Location
    Just want to thank p45cal for his work on this, I currently have a working file. A real credit to the forum spending your free time to fix my issues!

    Also like to thank SamT for starting to work on my project.

    Till next time

  14. #14
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Why not use a standard fixed form for inventory, one with all the groups and in the Verified column, place an "N/A" for those items not found in the latest Import?

    If I understand correctly, that means merely looping down two columns on the Walk Off and running Find for that cell value in Import, Column D. If Not Found, then Verified = "N/A". Very fast and very simple code.I mean like, less than ten lines simple.

    The next time Corporate changes the XML, you would only need to edit the Walk Off to reflect the Range Names and Area Ranges. The code would not change.

    See attached Gribbon2.xls

    IF that is not acceptable, then paste the below into a hidden sheet perform the Find on it and if not Found then copy from the hidden sheet to Walk Off. Almost as simple and just as maintainable.

    @ All
    Here are the relevant details of the new Import
    GEORGE
    TOTES DOWNSTAIRS 22-73
    TOTES DOWNSTAIRS. 205-221
    HANGING W/H 601-647
    RAILS W/H 648-685
    UPSTAIRS RAILS 686-724
    KIDS1 1004-1061
    BABY 1062-1085
    KIDS 1086-1133
    MEN 1134-1195
    WOMENS 1196-1390
    Single 1701-1701
    KIDS QTY 1801-1810
    BABY QTY 1811-1821
    KIDS2 QTY 1822-1832
    MEN QTY 1833-1857
    WOMEN QTY 1858-1873
    FINANCIAL 1923-1936
    WAREHOUSE
    GROCERY RACKING 74-105
    CHILLER BK-UP 106-123
    PRODUCE AMBIENT 124-129
    BWS BK-UP 130-137
    H&B W/H 138-142
    M&V W/H 143-151
    GM W/H 152-197
    H&B UPSTAIRS 198-204
    GM Extra 301-360
    SCHEDULE 9`S
    9A 990-991
    9B 1002-1002
    CHECKOUTS
    TILLS 2827-28704
    FRESH
    FOOD TO GO 2871-287869
    PRODUCE 3113-3181102
    FROZEN 3651-379369
    BIBC 3794-3845103
    CHILLED 4321-445369
    GM
    PHARMACY (DEPT 40) 2001-201420
    NEWS CUBE 2767-2767
    FOYER 2768-2826
    GM FRONTLINE 2879-3099
    NEWS & MAGS 3100-3112
    H&B 3182-335821
    GM FRONTLINE2 3359-3650105
    GM BACKLINE 4039-4320105
    GM BACKLINE2 4480-4530
    ELECTRICAL BACKLINE 4531-4599
    GM HOME 4600-4718
    Foyer extra 5001-5021
    Optical 5401-542225
    GROCERY
    BACKWALL 4454-4479
    TOPSTOCK 5501-556311
    VARIANCE DEPARTMENTS
    KIOSK 2751-2766
    BWS 3868-3900
    BWS3 4001-4038
    MVG 4801-4931111
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  15. #15
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    Test this one out; Import sheet ditched altogether.
    It may not work out of the box (it did here), and if it errors the first thing to check is the validity of the path and file name of the WTR file you're loading (it doesn't complain about the filename being wrong surprisingly enough, but another line brings it up short).
    The second thing that might cause it to fail is a failure to find some version of MSXML on your computer; there usually is a version on most pcs (it comes with Internet Explorer), but it may not find it or the code will need a reference to it.
    With luck it will just work without needing to do anything.
    It seems to be quite fast.

    SamT, a robust and straightforward idea; was it intended that there was no code in your last attachment?
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  16. #16
    VBAX Regular
    Joined
    May 2015
    Posts
    34
    Location
    Worked a treat and like lightening, the file is used across 7 teams daily and stored on more than 10 laptops.

    I will release this version and have the other to fall back on. The document and WTR file are always on the end users desktop so your code could be modified to always look here? Then i wouldn't need the user to input there username for the file path to the XML??

    Your the brains of the outfit so over to you

  17. #17
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    @ p45cal

    Right, I did no coding until I knew that the suggestion was OK with John Gribbon.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  18. #18
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    Quote Originally Posted by GribbiN View Post
    The document and WTR file are always on the end users desktop so your code could be modified to always look here? Then I wouldn't need the user to input their username for the file path to the XML??
    Automatically looks for ranges.WTR on the user's desktop and more friendly reporting when file not found.
    Replace existing with:
    Sub createWalkOff()
    WOffDataRowsCount = 33
    Set oXMLFile = CreateObject("Microsoft.XMLDOM")
    'XMLFileName = Range("XML_Location").Value
    loadSuccessful = oXMLFile.Load(CreateObject("WScript.Shell").SpecialFolders("Desktop") & Application.PathSeparator & "ranges.WTR")
    If loadSuccessful Then
      For Each thingy In oXMLFile.SelectNodes("/SoftwareID/GroupRange")
        Select Case UCase(thingy.getattribute("GroupName"))
          Case "GEORGE": G = G + thingy.ChildNodes.Length
          Case "WAREHOUSE": W = W + thingy.ChildNodes.Length
          Case Else: S = S + thingy.ChildNodes.Length
        End Select
      Next thingy
      ReDim George(1 To G, 1 To 2): ReDim Warehouse(1 To W, 1 To 2): ReDim Shopfloor(1 To S, 1 To 2)
      For Each NA In oXMLFile.SelectNodes("/SoftwareID/GroupRange/TagRange")
        Select Case UCase(NA.ParentNode.getattribute("GroupName"))
          Case "GEORGE"
            iG = iG + 1
            George(iG, 1) = NA.getattribute("TagRangeName")
            George(iG, 2) = NA.getattribute("TagRangeFrom") & " - " & NA.getattribute("TagRangeTo")
          Case "WAREHOUSE"
            iW = iW + 1
            Warehouse(iW, 1) = NA.getattribute("TagRangeName")
            Warehouse(iW, 2) = NA.getattribute("TagRangeFrom") & " - " & NA.getattribute("TagRangeTo")
          Case Else
            iSh = iSh + 1
            Shopfloor(iSh, 1) = NA.getattribute("TagRangeName")
            Shopfloor(iSh, 2) = NA.getattribute("TagRangeFrom") & " - " & NA.getattribute("TagRangeTo")
        End Select
      Next
      'prepare Walk Off sheet:
      '  Shopfloor:
      With Sheets("Walk Off")
        .Range("B7:D39,J6:L40").ClearContents
        .Range("B7:D39,J6:L40").Font.Bold = False
        Set Destn = .Range("B7")
      End With
      Destn.Resize(Application.Min(WOffDataRowsCount, UBound(Shopfloor)), 2).Value = Shopfloor
      If UBound(Shopfloor) > WOffDataRowsCount Then
        Set Destn = Sheets("Walk Off").Range("J6")
        ccc = Application.Index(Shopfloor, Evaluate("row(34:" & UBound(Shopfloor) & ")"), [{1,2}])
        Destn.Resize(UBound(Shopfloor) - WOffDataRowsCount, 2) = ccc  'Application.Index(Shopfloor, Evaluate("row(34:" & UBound(yyy) & ")"), [{1,2}])
        Set Destn = Destn.Offset(UBound(Shopfloor) - WOffDataRowsCount + 1)
      Else
        Set Destn = Destn.Offset(UBound(Shopfloor) + 1)
        If Destn.Row > 38 Then Set Destn = Sheets("Walk Off").Range("J6")
      End If
      'Warehouse:
      If Destn.Column <> 10 Then Set Destn = Sheets("Walk Off").Range("J6")  'this lines moves Warehouse to right side of printout; remove if tight for space and recode for splitting warehouse list.
      Destn.Value = "WAREHOUSE"
      Destn.Font.Bold = True
      Set Destn = Destn.Offset(1)
      Destn.Resize(UBound(Warehouse), 2).Value = Warehouse
      Set Destn = Destn.Offset(UBound(Warehouse) + 1)
      'George:
      Destn.Value = "GEORGE"
      Destn.Font.Bold = True
      Set Destn = Destn.Offset(1)
      Destn.Resize(UBound(George), 2).Value = George
      Sheets("Walk Off").Select
    Else
      MsgBox "WTR file not found/not loaded suceesfully"
    End If
    End Sub
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  19. #19
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Sweet code. I like it better than a hidden sheet and it will be easy to maintain.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  20. #20
    VBAX Regular
    Joined
    May 2015
    Posts
    34
    Location
    P45cal sir! I require your gracious help once more.

    Your code is working faultlessly across multiple laptops so thank you for the original.

    Now i require the same but the source data is slightly different if you could accommodate?

    There are 3 Groups this time round

    SR
    SF
    Delivery

    I would like all SF on the left and SR/Delivery on the right.

    I know the challenge of something new might not be there but i would be extremely grateful if you could work on the new solution at your own leisure

    Thanks

    John

    I had to change the extension on the XML data to upload, as you are aware ranges.wtr is the standard exported format

    ranges.xls
    WalkOff2016.xlsm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •