аЯрЁБс>ўџ 8ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџ7  !"#$%&'()*+,-./0123456ўџџџ?K:;<=>@JABCDEFGHILZ]MNOPQRSTUVWXY[_\^ўџџџ`ўџџџўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџRoot Entryџџџџџџџџ РF ~lфkС€ФЕ,ЃŸС9@CWorkbookџџџџџџџџBh_VBA_PROJECT_CUR"Рf ST}С@ŠMST}СVBAџџџџџџџџ Рf ST}С`W$ST}С ўЭЩ@сАСт\p Peter P. Yimec BАaР=гК ThisWorkbookœЏМ=ёџёџˆk8X@"Зк1ШџArial1ШџArial1ШџArial1ШџArial1 џArial1 џМArial1Ш Arial1Ш$Arial1№џМArial1 QTahoma1 QМTahoma"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.005*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-Є"$"#,##0_);\("$"#,##0\)!Ѕ"$"#,##0_);[Red]\("$"#,##0\)"І"$"#,##0.00_);\("$"#,##0.00\)'Ї""$"#,##0.00_);[Red]\("$"#,##0.00\)7Ј2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).Љ)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?Њ:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6Ћ1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)рѕџ Р рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР р Р рЋѕџ јР рЉѕџ јР рЊѕџ јР рЈѕџ јР рєџєР рєџєР р ѕџ јР рР р1*|  рР р Р рX/ рX/ р*x  р1 Р р1 \/ рXР р*x р"x р !x рXР рX “€џ“€џ“€џ“€џ“€ џ“€џ“€џ“€џ`…ѓ BIE CatalogŒ=Ў!  ;СС`iыZ№R№3 №П Р@@ё  їќr и… OrderHeader OrderNumberOrganizationAddressBuyerCountryCodedOtherCurrencyCodedOtherCountyUBL UID Entity NameCore Component UIDBusiness ProcessRegion (Geopolitical)Official ConstraintsProductIndustryRoleFinance FI Account PurchasingCatalogContext$UBL Basic Information Entity CatalogSellerOrderNumber AccountIDstringBuyerOrderNumberdatetimeOrderIssueDateAccountTypeCodeAddressTypeCode CountryCode CurrencyCodeCode Country. Code Code.Type A nation with its own governmentCurrency. CodeThe currency of money UBL000005 UBL000006 UBL000007 UBL000010 UBL000012 UBL000022 UBL000106 UBL000167 UBL000168 UBL000169 UBL000170 UBL000171 UBL000172 UBL000173 UBL000174 UBL000400 UBL000590 UBL000591000032000133Country. DetailsSProduct, PersonAddress, OrganizationAddress, NameAddress, LegalReportingInformationCountryOfOriginCountryOfDestinationProduct, BaseItemDetail!Product. Origin. Country. Details&Product. Destination. Country. Details(potential UBL name should be documented.Identifier.Type(The identifier of the financial account.AccountDetails+FinancialAccount. Product. Type. Identifier%The type of financial account productFor example a Savings Plus.Address. Type. CodeThe type of addressOFor example a business address or a home address. Not the role of the address.Enumerated CodelistFinancial Account. DetailsFinancial Account. IdentifierAccountID, AccountControlKey, AccountName1, AccountName2, SecondaryAccountID, IBAN, AccountTypeCoded, Currency, AccountReferencesFinancial Account. Currency9FIAccountDetails, FIAccount, FIAccountData, ChargeAccount&Financial Account. References. DetailsAccountReferences0References to papers that pertain to the account5Unique identifier assigned to the Order by the buyer.Order. Buyer. IdentifierOrder. Seller. IdentifierSellerOrder. Number. Details#BuyerOrderNumber, SellerOrderNumberOrder. Issue. Date^OrderIssueDate holds a time stamp provided by the application that created the Order document.GThe financial account currency is the currency of the financial accountCountryCurrency Property TermRepresentation TermFinancial Account IdentifierFinancial Account ProductTypeAddressOrderIdentificationTextIssueDate Version: 0.2Last Updated December 5th 2001 Simple Type Complex TypeCore Component typexCBL Definition CC DefinitionCode Lists/Standards Analyst NotesComplex Type Object ClassSimple Type Object ClassxCBL Name and Type CardinalityContained in UBL BIEsContained in xCBL ElementsContains UBL BIEs!Contains xCBL Elements/AttributesAttribute defaultsFinancial Account Reference1..1 (Irremovable)1..10..n0..1RequiredImpliedFixedџŠї m ‚ю m ‚ц ћm ‚Э т- B$%:˜­Мбрѕ]r жы yŽ 6K ўЭЩ@ \Jc'™(Џ(ѕ(џ(џ)***'*/*7*}*‡**—*Ÿ*Ї*э*  dќЉёвMbP?_*+‚€%сСƒ„MHP LaserJet 5L (PCL)д@g іњ,, @MSUD7HP LaserJet 5L PCLФ%d Ё" d,,р?р?U} $ } ’} $}  $} $ } Ж} л} I} $ } ’ } ’ } $ xCBL Business TermsJ;€!Т€щ„ТЃЃ„@ e Т Т Т с€ссс€ћ@ТТссссс§ #§ !kО %%% § "lО ""§ !§ !§ !§ !§ !§ !§ § § m§ n§ o§ p§ q§ r§ s§  t§  u§  _§  `§  v§ w§ x§ y§ z§ {§ |§  §  §  §  §  § § §  &§ L§ L§  a§  D§ P§ N§ § §  '§ O§  § "§ \§  a§  ^§   §  ^§ ~§ D§ K§ ‚§  (§ M§ § B§ C§  a§  g§  b§  § ~§ D§ ‚§  )§ E§  § "§ F§ G§  c§  d§  b§  § § D§ K§ ƒ§  *§ Q§ Q§ S§  }§  R§ D§ ƒ§  +§ H§  § "§ I§ J§  e§  d§   §  § €§ § K§  ,§ U§ § T§  § ~§ § „§ § -§ : § : § ]§ ]§ § ;§ § .§ ? § ? § A§ ]§ <§  § >§ § § § /§ @ § ? § ]§ =§  § >§ § § § 0§ !§  § "§ #§ 8§ § § ]§ K§ 1 §  О  § О §  2§ §  § §  3§ $§  § "§ %§ 9§  § § K§ ‚§ 4§ О §  О§  5§ Z§ § [§  § § §  6§ V§ §  § § § W§  7§ X§ X§  §  § § § YО  $$$ з6\рœz’ЖЈФ„Жˆ„ИЊŒpBŒpll„! с" с# с$ с% с& с' сО ! $$$ О " $$$ О # $$$ О $ $$$ О % $$$ О & $$$ О ' $$$ зќxзe с§ e f§ e § e bз>зЅ сІ сЈ сЉ с§ Ѕ ]§ Ѕ g§ Ѕ  § І ]§ І g§ І h§ Ј ^§ Ј g§ Ј  § Љ ^§ Љ g§ Љ hз ј<***зззззз‹ с§ ‹ f§ ‹ i§ ‹ jз>зззззI с§ I f§ I W§ I bз>ьЮ№j№№R№( № №№~Ђ № Ѓ №<€МО…П XPƒPП?П №61j№]4@МОМ Н Щц,СвHЊPЕ…KХžь №Ж<Tim McGrath: UBL UID: This is a 9-character string, unique across the entire library, starting with the characters "UBL". Until we can assign unique values, which has yet to be determined in co-ordination with the Naming & Design team, use the value "UBL000XXX" for all BIEs. < K §lь~№~Ђ № Ѓ №<€L)О…П XPƒPП?П №†в№]4@L)ОxН eцЎƒЯIЙ0‡L6[hПь №Ж<Tim McGrath: Entity Name: This is the name of the BIE, which - until we have clearer naming rules - functions as a placeholder. If you are comfortable with the ebXML CC naming rules, you can use them (basically, you combine the ObjectClass, add the Property Term, and then add the Representation term to it). If you don't like these, use the xCBL names for now, or something that is meaningful to you. Names should be unique within the scope of your work. We shall attempt to harmonize names across teams as we go, so consult with the list if you have issues with names. If the entity in question is an attribute (in xCBL), precede the name with the string "Attribute:" (Attributes are treated like simple types, but they otherwise require a default value to be supplied.) < K jь~№~Ђ № Ѓ №<€ќ/О…П XPƒPП?П №–ќм№]4@ќ/О;Н !‰=k : Nˆz’ІЂЂEПь №Ж(<)Tim McGrath: Simple Type: If an element directly contains data (string, number, datetime, code, etc.) then the type should be indicated here. These values are strictly the primitive data types: you will say "code" for any enumerated list, even though you know which specific code list you are using. (The specific code list, or other custom data type, would be indicated in the "Property term" column.) A value is only supplied here for those fields that directly contain data - complex structures are not addressed here, and no value should be given. < K  (ь~№~Ђ № Ѓ №<€ш5О…П XPƒPП?П №†u’№]4@ш5ОЌ\Н в"K1ЌиAИэх~%хЗ9Пь №Жъ<ыTim McGrath: Core Component Type: This is the "CCT" from table 6-1 in the CC specification (latest draft). It will not apply to most complex types unless they exist as core components, which most of the aggregate BIEs in xCBL do not. < K @ъь~№~Ђ № Ѓ №<€:О…П XPƒPП?П №†рЁ№]4@:О _Н юPбќџ†ŠKА ЭbмTПь №Жr<sTim McGrath: Complex Type: If an element has substructure - that is, it is an aggregate - then it has a value in this column, identifying which structure defines it's type. In terms of XML Schema, this would be the complex type of the element. In ebXML terms, this can either be the name of an aggregate core component, or - more usually - the name of an aggregate BIE. < K Ьrь~№~Ђ № Ѓ №<€Є'О…П XPƒPП?П №I†к№]4@Є'ОН ,З™2%>O‹y0ЮШ‰§пПь №Ж…<†Tim McGrath: xCBL Definition: This is the definition from the xCBL documentation. Be aware that many xCBL elements are used in many different places within xCBL, and when documented as the children of other elements, this documentation is specific to that use of the element. If in doubt, use the "main" definition from the screen that describes the element in question and its children. < K "…nesь~№~Ђ № Ѓ №<€ф0О…П XPƒPП?П №y†}*№]4@ф0О8#Н bžшЕKНej@[БППь №Жo<pTim McGrath: Core Component Definition: This is the definition, if any, from the corresponding core component. < K ђotn ь~№~Ђ № Ѓ №<€X3О…П XPƒPП?П №y† №]4@X3О`LН гЊћЮІRKšёMXр3EоПь №Ж?<@Tim McGrath: Code Lists/Standards: In those cases where an element or attribute contains an enumerated datatype or other value described in an external standard, then the particular code-list or standard should be identified here. This will not be used much of the time, but should always be filled out for code lists. < K Ъ? tь~№~Ђ №  Ѓ №<€Є8О…П XPƒPП?П № y† Б1№]4 @Є8О@ЎН ЯiкЕŸПЮNЋV2Ц IПь №Жd<eTim McGrath: Analyst Notes: This is a list of comments, queries and notes made as the work is done. < K Мd ggь~№~Ђ №  Ѓ №<€и:О…П XPƒPП?П № Х† Žи№]4 @и:ОАН IцZ”ИЙIˆКmЁвЧПь №Ж!<"Tim McGrath: Complex Type Object Class: Note that this field is only used for complex types, never for simple types, but must always be provided when relevant. It contains the name of the complex type that provides the structure for the element in question. This is the standard "type" for a complex element in XSD or xCBL ("BuyerParty" is of type "Party"). Note that in xCBL, as written in SOX, there is no formal distinction between elements and complex types the way there is in XSD - any element is potentially a type for reuse in SOX/xCBL. < K  !mngь~№~Ђ №  Ѓ №<€Є(О…П XPƒPП?П № Х† яŽ№]4 @Є(ОФ{Н ЕWŸюэyNФXНwЦЃПь №Жc<dTim McGrath: Simple Type Object Class: This field provides information used in the Core Components spec but only pertains to data-containing elements. See the CC spec for an understanding of this property. This should be filled in whenever there is a direct relationship to a CC, and the value should be taken from the "Object Class" property of that CC. < K clnHь~№~Ђ №  Ѓ №<€ј;О…П XPƒPП?П № Х† ”€№]4 @ј;О(!Н єYТh-NT\кБRџ.Пь №Ж<Tim McGrath: Property Term: This is, in an XSD sense, the customized datatype of a simple type. If I have a simple type that takes a code, this field would give me the UBL name of the code list that provides the allowed values. If I have an element containing a number, such as a TaxAmount, this field would provide the name of the specific numeric structure that that value is expected to be in (10 digits, three decimal points might be described as a "Decimal10_3" datatype in xCBL. The nale provided here would be "Decimal10_3".) < K з mecь~№~Ђ №  Ѓ №<€XО…П XPƒPП?П № U†АS№]4 @XОР0Н ƒNбЕИМEИw-^ЌЈ(Пь №Ж—<˜Tim McGrath: Representation Term: This describes the type of values allowed in a simple type, per the CC spec. For complex types, do not make an entry.< K Ж—tzeь~№~Ђ № Ѓ №<€рZО…П XPƒPП?П №U†f=№]4@рZОшТН ЌћWи„OЋ?wфХmm'Пь №Ж†<‡Tim McGrath: xCBL Name and Type: The name and type of the element as given in xCBL. Be aware that these may be the same thing in xCBL.< K z†Comь~№~Ђ № Ѓ №<€œ\О…П XPƒPП?П №JЃГ№]4@œ\О€‰Н .…g—вKMЅшa›1-Пь №ЖЛ<МTim McGrath: Cardinality: This field describes the allowed occurrence of this element's association with its parent, and has the following values: 1..1 (Irremovable) - means it cannot be removed, even through use of an extension mechanism 1..1 - one and only one, but can be extended away 0..1 - zero or one 0..n - zero or more 1..n - 1 or more n..m - from n to m occurrences, where n is a lower number than m, and both are positive integers < K jЛresь~№~Ђ № Ѓ №<€Д`О…П XPƒPП?П №t†ј’№]4@Д`О”аН ќЈѕ[*вJ‚xлцсhПь №Ж(<)Tim McGrath: Contained In UBL BIEs: Gives the name of any UBL BIEs that contain the element in question. Should at least include the name of the parent elements seen in the analysis sample. In the case of attributes, this should be the name of the element of which the attribute is an attribute. < K d(ь~№~Ђ № Ѓ №<€ЬcО…П XPƒPП?П №t†p№]4@ЬcОќлН Њі)ajkAЎћНЧbtQ!Пь №Ж3<4Tim McGrath: Contained In - xCBL Elements: Gives the name of any xCBL elements that contain the element in question. Should at least include the name of the parent elements seen in the analysis sample. In the case of attributes, this should be the name of the element of which the attribute is an attribute.< K ˜3nleь~№~Ђ № Ѓ №<€ЬfО…П XPƒPП?П №x†Щ№]4@ЬfО Н Тh—ЋвV8@ЛgфФ?Ж@TПь №Ж–<—Tim McGrath: Contains - UBL BIEs: This is a list of the children of the BIE being described, in order, by name, and separated by commas (indicating "followed by") or pipes ("|" - indicating "or"). If children must be grouped, as is the case when a choice is one member of a sequence, use parenthesis to group the elements of the sub-choice or sub-sequence. An example of this would be "if a is followed by a choice of b or c", write: a,(b|c). Note that the attributes of an element should be listed here, separate from the children, and preceded by the label "Attributes:". If no child elements exist, then use "N/A" (as will be the case with all simple types.)< K –t eь~№~Ђ № Ѓ №<€ШlО…П XPƒPП?П №x†Y№]4@ШlО(уН Œ)6~C…ЁU щz™Пь №ЖЌ<­Tim McGrath: Contains - xCBL Elements/Attributes: Same as for UBL BIEs, but with xCBL elements and attributes. Can generally be cut-and-pasted from the xCBL documentation. < K 1Ќ nь~№~Ђ № Ѓ №<€ oО…П XPƒPП?П №xД‡№]4@ oОщН }d;Fo›J‡”ќŸ%'HПь №Жћ<ќTim McGrath: Attribute defaults: This is used only for attributes. It provides the default value, which can be any of the following: "Implied," (meaning optional), "Required," "Fixed," accompanied by a fixed value, or a simple value can be provided. < K ‰ћtraь~№~Ђ № Ѓ №<€јoО…П XPƒPП?П №№†p/№]4@јoΘ Œ А˜Р? —ƒLКГЭ­Ÿ>„Пь №Ж„<…Tim McGrath: Core Component UID: This is the UID of the correlated core component, in those cases where a direct correlation exists.< K U„aanь~№~Ђ № Ѓ №<€ЌsО…П XPƒPП?П №О 7№]4@ЌsОˆŒ k< 'MCЎbШћо•1ЃПь №Ж’<“Tim McGrath: Context: These describe the known context-specific application of the BIE as described, in each area. may be safely ignored for now. < K Ÿ’dь~№~Ђ № Ѓ №<€ьuО…П XPƒPП?П №аА7№]4@ьuОPŒ ќ,ŠчџBKНnТХЈ^(Пь №Ж’<“Tim McGrath: Context: These describe the known context-specific application of the BIE as described, in each area. may be safely ignored for now. < K Ÿ’dь~№~Ђ № Ѓ №<€xО…П XPƒPП?П №№P7№]4@xОHŒ ^BЪJІяjBcЋ,ЭПь №Ж’<“Tim McGrath: Context: These describe the known context-specific application of the BIE as described, in each area. may be safely ignored for now. < K Ÿ’dь~№~Ђ № Ѓ №<€LzО…П XPƒPП?П №№P7№]4@LzΘŒ U uTv№FžЈa•GёЎ^Пь №Ж’<“Tim McGrath: Context: These describe the known context-specific application of the BIE as described, in each area. may be safely ignored for now. < K Ÿ’dь~№~Ђ № Ѓ №<€||О…П XPƒPП?П №№P7№]4@||О€шН pЩЪqnƒD† sЊюљ+АПь №Ж’<“Tim McGrath: Context: These describe the known context-specific application of the BIE as described, in each area. may be safely ignored for now. < K Ÿ’dь~№~Ђ № Ѓ №<€Ќ~О…П XPƒPП?П №№P7№]4@Ќ~Оh Œ ѕиsЧIЕKЉА8 hЈEПь №Ж’<“Tim McGrath: Context: These describe the known context-specific application of the BIE as described, in each area. may be safely ignored for now. < K Ÿ’d Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath  Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath Tim McGrath>Ж@я7К Sheet1 ThisWorkbookџџџџ џџџџ†__SRP_2џџџџџџџџџџџџ__SRP_3 џџџџBSheet1џџџџџџџџ~ ўџџџўџџџўџџџ !"#$%&'()*+ўџџџ-./ўџџџ1ўџџџ3456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghiўџџџklmnopqrstuvwxyz{|ўџџџ~ўџџџ€<фjxЬ%влџџ#ˆЖџџџџџџџџ<џџB чhк€wD€v‰}і4РF*>.oeЅHM(„‹”нџџџџџџџџџџџџx*>.oeЅHM(„‹”нB чhк€wD€v‰}і4џџMEџџџџџџџџџџпџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ(SLџџџџSџџџџS”џџџџ6"џџџџџџN0{00020819-0000-0000-C000-000000000046}џџџџ €ўџџџџџџџ(џџџџџџџџџџ%џџџџHƒўџџџџџџџ`џџџџџџџџџџџџџџ %‚ џџџџўџџџџџўџџџџџџџџџџџ %џџџџ`џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџh8@˜˜џџџџџџџџџџџџџџџџџџџџџџ0wЖ%= $*\Rffff*1<3d25b681пџџџџ4ўЪџџџџџџџџxџџџџААAttribute VB_Name = "ThisWorkbook" ŒBasŒ0{00020P819-0C$0046} |GlobalаSpac’False dCreatablPredeclaIdБTru BExposeTemplateDeriv’BustomizD2rU€€€ 0љ!Iџџџџб4qa™џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџŸ`rU€€€ џџџџџџџџ@n<фjxЬ%вџџ#ˆЖџџџџџџџџ<џџчЬѓ№ј{H€я”ш=! РFZХHТ†ОЕK€p Њ UмџџџџџџџџџџџџxZХHТ†ОЕK€p Њ UмчЬѓ№ј{H€я”ш=!џџMEџџџџџџџџџџпџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ(SLџџџџSџџџџS”џџџџ6"џџџџџџN0{00020820-0000-0000-C000-000000000046}џџџџ €ўџџџџџџџ(џџџџџџџџџџ%џџџџHƒўџџџџџџџ`џџџџџџџџџџџџџџ %‚ џџџџўџџџџџўџџџџџџџџџџџ %џџџџ`џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџh8@џџџџџџџџџџџџџџџџџџџџџџ0wЖ%= $*\Rffff*1=3d25b681пџџџџ4ўЪџџџџџџџџxџџџџЈАAttribute VB_Name = "She@et1" шBast0{000Р20820- C$0046} |Global!ФSpac’False dCreatablPre declaIdЋTru BExposeTemplateDeriv$’Bustom izD2rU€€€   1Yџџџџй4Љџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ€`__SRP_4џџџџџџџџџџџџ,р__SRP_5 џџџџ0BModule1џџџџ2ї __SRP_26џџџџџџџџџџџџj„rU€€€ џџџџџџџџ@n№Фд(џџџџЃ %вџџЖџџџџџџџџџџџџџџџџџџџџџџxџџMEџџџџџџџџџџпџџ(џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ 6 џџџџ ”џџD”џџџџLџџџџLџџџџџџџџLџџџџLџџџџџџџџPџџџџ<,џџ<0џџ<4џџ<8џџ<<џџ<џџџџџџџџџџ <џџџџ`џџџџџџџџ˜Dўkџџџџџџџџџџ--„џџџџƒ:џџџџџџpџџџџџџџџџџџџџџ% „Aџџџџxџџџџџ%Јџџџџџџџџџџџџ@xџџџџџџџџxџџџџџџџџџџџџџџџџџџџџџџџџџџџџ`hџџџџАџџџџ˜џџџџџџџџџџџџџџџџџџџџјџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџP@|џџџџhџџџ џџџџџџџџџџHXZbpџџџџџџџџ@ўџ€dџџџ џџ џџџџ@ўџH`џџџ џџ џџџџ@ўџџџџџ\џџџџџ џџџџ@ўџШLџџџ џџ џџџџ@ўџр<џџџ џџ  @ўџШ,џџџ џџ @ўџ џџџ џџ p8ј@ўџР џџ џџ и џџ џџ@ўџџџџџџџџ џџ џџ@ўџџџџџџџџџџ џџ@tџџџџєўџџ џџ џџ@ўџ(фўџџ џџ @Lџџџџдўџџ џџ џџ@ўџшФўџџ џџ (Р @ўџhДўџ џџ Xш @@P8Єўџџ џџ@ўџџџџџ”ўџџ џџ @^џџџџ„ўџџ џџ€ш@ўџtўџџ џџ Јh(@ўџџџџџdўџ џџ Иј!@ўџрTўџџ џџ ш@ўџџџџџDўџџ џџ џџџџџџџџ *џџџџџџџџџџpџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџHџџџџџџџџџџџџџџџџџџџџџџџџџџџџ@wЖ%= $*\Rffff*1;3d25b67d*\R1*#228*\R1*#229*\R1*#c4*\R1*#c0*\R1*#175*\R1*#cd*\R1*#b8*\R1*#76*\R1*#c0пўЪ-"€ џџџџ€ € џџџџBш€ џџџџ<ЈX h <Р @€ џџџџ€&+ ИША€ џџџџ p€ џџџџ 2а !№ >€ џџџџ  € џџџџ&и+xPH€ џџџџ 8€ џџџџ Iˆ 'X€ џџџџ€ џџџџ8€ џџџџ€ џџџџ (€ џџџџџџџџ–oџџpЖa L'P]ђxџ |ўШРkџ LўЌ­ш§’et1" @!ЖSheet1œIџ LўШЖA L'P P$XB@H Z!\ЖœkџџH LЌ '^yџџ0ЖA2:A ^$XB@H bB@dЖSheet1 H%hB@lџ LўЌ­ш§’џ LўШY`k(y p ZB@n @!'tџџџџ Z!\Жœ tЌЌ Z%r(\џџэ | H%h.@ | H%hB@l P$XB@Hџ |ўЌ H!h!z’јџџџџ№џџџџвБAttribute VB_Name = "Module1" Sub CreateSheet() Dim ws As рWorks80 For j”1 To Activ‚eNbook.`€s.Count1ЃT Set^=;œ(j‹4If-B.О<> "Ћ1Р" ThenS(stypтws-ї –S€5.€ƒ s i€s2s65000‹‹‚@cell€"A" & iRange(s).Selec_ˆ xƒVC€&.pValuмyi@botrow=i0 - 1< Exit 5OEnd IfЯKNext 5Kƒ7"A2:@C%S:C?ionŠ\pyЫƒ?•(…)џдlЫEpBЊPpAEK Aћ‚gAqaqРЦgq+h .CghJOffs~0№, 1)LТg‹ HPasр„peci@al (xlтAќlluЏ)Ї -L#ЃBjЁ ’ rU€€€€~| '&ЩyQйЁбщ)бIqЁсщ 1Є,B(,џhџ\џ`џdџ$ Hdџ  `џ 0 l\џ§i<џ)dџ`џўh џ(<џќэhџ`џdџ$ Hdџ  `џ d lџ=xџ)dџ`џџџxџ Hlџћ=/џџxџ H>џFфўќієў<џќэhџ`џdџ$ Hdџ  `џ d џў˜ )dџ`џџ(,џдўўС<џш§ўhДў:LџдўћяфўќіЄў&dџ'Lџ%ќэЄў$  dџў ыdџ+dџ$ (dџaфў:Lџ]ћ3dџ5фў€дў(Lџћœфўќі„ў дўў~Дў2dџ'<џ%:Lџ„ўћяфў%$  dџў ыdџ5фў!dџѕ $ Аdџў˜dџ>џ:Lџ%`џdџ$ Hdџ  `џ d џў˜ )dџ`џџ(,џдўўС<џш§ўhdўЋ:LџдўћяфўќіЄў&dџ'Lџ%ќэЄў$  dџў ыdџ+dџ$ (dџaфў:Lџ]ћ3dџ5фўžЋ дўў~dў6Iєў§“ @(Lџ%(,џ%dџ$ (dџўЂфўў§ѓ `џ`џ,)dџ`џ5фў'ўСLџјяџџ%dџ$ (dџў dџ hџў~ џD8,T< џ џФўДўtўdўдўЄўhџ„ўxџєў$џdџ`џџфў”ўkrU€€€ &џџџџџџџџ$&`§џџџџџџџџџџџnЬamџ  фњ*\G{000204EF-0__SRP_27 џџџџ}g_VBA_PROJECTџџџџџџџџџџџџdirџџџџџџџџџџџџМ__SRP_0џџџџџџџџџџџџХ‡ ‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ЁЂЃЄЅІЇЈЉЊЋЌ­ЎЏАБВГДЕЖЗИЙКЛўџџџНОПРСТУФўџџџЦЧШЩЪЫЬЭЮЯабвгдежзийклмнопрстуфхцчшщъыьэюяўџџџёђўџџџєўџџџіїјљњћќ§ўџ000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications *\G{00020813-0000-0000-C000-000000000046}#1.3#0#C:\Program Files\Microsoft Office\Office\EXCEL9.OLB#Microsoft Excel 9.0 Object LibraryИ*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINNT\System32\stdole2.tlb#OLE Automation *\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.1#0#C:\Program Files\Microsoft Office\Office\MSO9.DLL#Microsoft Office 9.0 Object Library џџџџџџџџwЖ%= џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ%вThisWorkbook1<3d25b681џџThisWorkbookџџлвџџ Sheet11=3d25b681џџ Sheet1џџвџџModule11;3d25b67dџџ:Module1џџА! џџ0аџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџАџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџT%DS€ЪK ѕ§™џџџџщв:CСN’bцяђL‹џџџџџџџџxŸОG#лЕ8Рџџџџџџџџ`Љу^ŒШЫ.хџџџџџџџџHЗ—‡$;ˆЃџџџџџџџџ0ЉZ[}Œ щџџџџџџџџ€ПьЭŠЁџџџџџџџџАЗqЎTюdџџџџџџџџшŸ#MщIpuџџџџџџџџа€Ё6Ž 9ЪЩџџџџџџџџИЃўя3џРџџџџџџџџ –Џ‹Н>WЏџџџџџџџџˆŽDр=cTNaџџџџџџџџpЕП2Є цnџџџџџџџџX—MYѕ+oCŠџџџџџџџџ@ЊэЖ4ŽЭlџџџџџџџџ(БŠШСТ#№џџџџДўџ§тqЈџџџџ X"ЫuзJ•/˜3ё[”џџџџџџџџ0€BOџМ- €џAs=€џDimC€џEachH€џendifO€џexitT€џFor_€џIfb€џinЄ€џSetЏ€џSubВ€џthenГ€џToExcel€+VBAїтWin16С~Win32MacГВVBA6­#Project1 stdole“` VBAProjectОПOfficeu ThisWorkbook|у €џ_EvaluateйSheet1шSheet2щSheet3ъSheet4ыSheet5ьSheet6эSheet7юSheet8яSheet9№Sheet10 PSheet11!PSheet12"PSheet13#PSheet14$PSheet15%PSheet16&PSheet17'PModule1b CreateSheet$9 €џџџ_B_var_ForjLws–_„џWorkbookk WorksheetСўweˆ_€џActiveWorkbookЂ €џџџ_B_var_ifPђi`€џџџ_B_var_i Ђscellћ €џџџ_B_var_scellюОrangesˆ €џџџ_B_var_ranges1}€џRangeк  €џActiveCellНЗ€џValueфKibotrowœ€џџџ_B_var_ibotrow‰Ÿ €џSelectionZЎ€џCopyЦП€џџџ_B_var_Workbook3№ €џWorksheetsМј€џ_DefaultjТ€џActivate—| €џPasteSpecialОK €џxlPasteAlluž€џOffsetшЊstypeYq €џџџ_B_var_stypeF5 €џџџ_B_var_SetCount0vja€џџџ_B_var_j Ђ activewor+ѓactivewookrbookџA€џџџ_B_var_activewookrbook’+џџ`џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ џџџџџџ ; џџџџџџџџџџџџ 6В€0* pH‚dф VBAProjeˆct4@j = r wЖ%= ” J< r€stdole>stdo€le f%\*\G{00€020430-C 0046}#2.0#0#C:\WINNT\System32\c2.tlb#OLE Automation^ƒDOffic„DO€>fic5‚D€…€D2DF8D04C-5BFA-101B -BDE5€DAA5€B4€2ˆD€—gram Files\Microso(ft 6\MS€O9.DLL# € 9.0 ObЙ Library‹€CЬ‚%в ThisWorkbookˆG€ThcsWЋrkЊb€o€Ž2к ЂРHB1t`вB,QТ!л"B+BxSheet1GТS@#e€Tt14H2NуЫРModule€;dugB”2O!#@ЌM9!€C9Т“K*m0џџџџrU€€€€~~~~~~~~~~~~~~~~~~~~~~~~~ щ_ЫћOљ MчIX‡kЊG  фџџџџƒŠe Йџџџџџџ ƒŠe Йџџџџџџ1ˆa & џџџџаџџџџщ џџЩ‘qyProject1 VBAProject ThisWorkbookSheet1Sheet2Sheet3Sheet4Sheet5Sheet6Sheet7Sheet8Sheet9Sheet10Sheet11Sheet12Sheet13Sheet14Sheet15Sheet16Sheet17Module1яРF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA сџџџџ q`РF 3C:\Program Files\Microsoft Office\Office\EXCEL9.OLBExcel йџџџџ yp0РFC:\WINNT\System32\stdole2.tlbstdole щџџџџY€Lај-њ[НхЊDоR 1C:\Program Files\Microsoft Office\Office\MSO9.DLLOffice ЩџџџџёaкРFB чhк€wD€v‰}і4РF*>.oeЅHM(„‹”нDРFWorkbook @иРFчЬѓ№ј{H€я”ш=! РFZХHТ†ОЕK€p Њ UмDРF WorksheetarиќхQьGё˜Ѓыqч7Jk+ГЌAІд'šсb&снVk•§о@­з7#VŠ:FжBfв.B­#Ѓ‡“­Њфі*/ЊJєCЉќБ7№NкхeBЗeдmЪљ<врѕvС.NМхс­6}JѕcKЁ›жJЄћДЙ9Ѓ›7ф(ІF‰кЅ(!žƒq`џ‰ ƒAКЗОЦ„•ћyG#’ћ@БzC!љpьGНgЅрBК ИshЩвЯ:Дкl^@‚ єqщSqЋ —9ЊИFKЂsЌ@њ\БќЃїйПFДDЧ™$•ЬЕ-ˆŠљN†L_.zrB6šLˆЏ˜\LЛњ˜СРНРа‚И•CнGНТ {iё^вIкѕП@ЌZiЕаQКAЇGџ•ИAЛX}<Я%ТsNameтP„[Ц•A…JЏж„`џJ­™VБ$NЏFZ™Зи,цкCИtlFК€/jAsZь \9 hD’0Ѕ$R*ЫЩnф9G…™пWФi?~ж_r"С;D€С"6L“нЫебPшЮєK A™U ZЇ‚fEW[IМ‰э>(тС.ЭtИyИ0H•Еb)c>ѕЭФ”[MО?IЇш@Ѓ КSЁњIBЕK‰‡шЭ ъtїфаwЏъ$GГ‚…ОU8 CreateSheet РFйРF)Qџџџџ Sheet1 A  B2:BCopyзРFActivateFРF)шБРF A2:A aw__SRP_1џџџџ№–PROJECTwmџџџџџџџџџџџџѓVPROJECTџџџџѕCSummaryInformation(џџџџџџџџмrU€€€€~~{ џџџџџџџџџџџџ   ' ‘q ‘lThisWorkbookThisWorkbookSheet1Sheet1Module1Module1ID="{866B473C-8843-467C-B8DC-567A65F70B21}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Module1 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="2725E87CF88C8490849084908490" DPB="AFAD60F460F4E9F5E9F5E9" GC="3735F88C089C919D919D6E" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Sheet2=0, 0, 0, 0, C Sheet3=0, 0, 0, 0, C Sheet4=0, 0, 0, 0, C Sheet5=0, 0, 0, 0, C Sheet6=0, 0, 0, 0, C Sheet7=0, 0, 0, 0, C Sheet8=0, 0, 0, 0, C Sheet9=0, 0, 0, 0, C Sheet10=0, 0, 0, 0, C Sheet11=0, 0, 0, 0, C Sheet12=0, 0, 0, 0, C Sheet13=0, 0, 0ўџџџўџџџ  ўџџџ ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ, 0, C Sheet14=0, 0, 0, 0, C Sheet15=0, 0, 0, 0, C Sheet16=0, 0, 0, 0, C Sheet17=0, 0, 0, 0, C Module1=154, 154, 675, 602, Z ўџ р…ŸђљOhЋ‘+'Гй0Ќ@H`t Œ ˜Єф Lisa Seaburgx Tim McGrathMicrosoft Excel@ŒЙSД0С@—ŸRT}Сўџ еЭеœ.“—+,љЎ0а PDocumentSummaryInformation8џџџџџџџџџџџџCompObjџџџџџџџџџџџџ fџџџџџџџџџџџџџџџџџџџџџџџџXl t|„Œ ” Ќф CommerceOne  BIE Catalog  Worksheetsўџ џџџџ РFMicrosoft Excel WorksheetBiff8Excel.Sheet.8є9Вq