{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\froman\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Arial;}}{\colortbl\red0\green0\blue0;\red255\green255\blue255;\red0\green0\blue255;\red128\green128\blue128;}{\stylesheet {\style\s0 \ql\fi0\li0\ri0\f1\fs24\cf0 Normal;}{\style\s3 \ql\fi0\li0\ri0\f1\fs26\b\cf0 heading 3;}{\style\s2 \ql\fi0\li0\ri0\f1\fs28\b\i\cf0 heading 2;}{\style\s1 \ql\fi0\li0\ri0\f1\fs32\b\cf0 heading 1;}}{\*\listtable}{\*\listoverridetable}{\*\generator iText 2.1.5 (by lowagie.com)}{\info}\paperw11907\paperh16840\margl720\margr720\margt720\margb720{\footer \pard\plain\s0\qc\fi0\li0\ri0\sl320\plain\f0\fs18 \u31532?\f0{\field{\*\fldinst PAGE}{\fldrslt  }}\f0\fs18 \u-26507?\par}{\header \pard\plain\s0\qr\fi0\li0\ri0\sl320\plain\f0\fs18 \u21517?\u24072?\u-29774?\u25480?\u183?\u20248?\u-29400?\u-29698?\u31243?\u8212?\u8212?\u21517?\u-29698?\u22530?\par}\pgwsxn11907\pghsxn16840\marglsxn720\margrsxn720\margtsxn720\margbsxn720\pard\plain\s0\qc\fi0\li0\ri0\sa140\plain\f0\fs36\b \u20174?Excel\u23567?\u30333?\u21040?Excel\u-25896?\u25163?\u-29779?\u32451?\u-31707?\u-248?\u31532?18\u26399?\u-247?\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u32534?\u21495?\u12305?\u-230?\f0\fs22\b MKT002281\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u21517?\u31216?\u12305?\u-230?\f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk/002281.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u20174?Excel\u23567?\u30333?\u21040?Excel\u-25896?\u25163?\u-29779?\u32451?\u-31707?\u-248?\u31532?18\u26399?\u-247?\ul0 }}\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u25152?\u23646?\u31867?\u21035?\u12305?\u-230?\u-32692?\u19994?\u25216?\u-32515?\u22521?\u-29779?\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u24320?\u-29698?\u26102?\u-27148?\u12305?\u-230?2025\u24180?03\u26376?14\u26085? \u21040? 2025\u24180?03\u26376?15\u26085? \u26477?\u24030? 3980\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?04\u26376?19\u26085? \u21040? 2024\u24180?04\u26376?20\u26085? \u26477?\u24030? 3980\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2023\u24180?06\u26376?30\u26085? \u21040? 2023\u24180?07\u26376?01\u26085? \u26477?\u24030? 3980\u20803?/\u20301?\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u-29708?\u26126?\u12305?\u-230?\u26412?\u22521?\u-29779?\u-29698?\u31243?\u20840?\u24180?\u24490?\u29615?\u24320?\u-29698?\u-244?\u22914?\u26377?\u-26880?\u27714?\u-244?\u27426?\u-28722?\u26469?\u30005?\u21672?\u-29726?\u-255?\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u20854?\u20182?\u24320?\u-29698?\u22478?\u24066?\u12305?\u-230?\f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk8/055810.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u26477?\u24030?\ul0 }}\f0\fs22  \par\pard\plain\s0\fi0\li0\ri0\sl300\plain\f0\fs22 \u12304?\u-29698?\u31243?\u20851?\u-27346?\u23383?\u12305?\u-230?Excel\u22521?\u-29779?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u25105?\u-30335?\u25253?\u21517?\b0\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u21672?\u-29726?\u30005?\u-29731?\u-230?027-5111 9925 , 027-5111 9926\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u20540?\u29677?\u25163?\u26426?\u-230?18971071887    \u-28498?\u31665?\u-230?Service@mingketang.com\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u20225?\u19994?\u30171?\u28857?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22312?\u31185?\u25216?\u21457?\u-28738?\u30340?\u26102?\u20195?\u-244?\u23398?\u21592?\u-28419?\u25110?\u22810?\u25110?\u23569?\u22312?\u20114?\u-32684?\u32593?\u25110?\u30701?\u-30266?\u-26479?\u19978?\u23398?\u20102?\u19968?\u20123?Excel\u30693?\u-29754?\u-244?\u20294?\u26159?\u21040?\u20102?\u24037?\u20316?\u22330?\u26223?\u20013?\u-244?\u21364?\u20381?\u28982?\u19981?\u30693?\u-28589?\u24590?\u20040?\u19979?\u25163?\u-230?\u19968?\u20010?\u21407?\u22240?\u26159?\u22240?\u20026?\u23398?\u21592?\u25214?\u19981?\u21040?\u21078?\u26512?\u-27154?\u-26472?\u30340?\u26041?\u27861?\u-229?\u21478?\u19968?\u20010?\u21407?\u22240?\u26159?\u22240?\u20026?\u32593?\u19978?\u30340?\u-29698?\u-244?\u24448?\u24448?\u-28419?\u26159?5-10\u20998?\u-27489?\u19968?\u-32126?\u-29698?\u-244?\u-28640?\u25104?\u20869?\u23481?\u24448?\u24448?\u26080?\u27861?\u28145?\u24230?\u23637?\u24320?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25968?\u25454?\u-28657?\u-30266?\u-30616?\u23545?\u20110?\u22823?\u-28440?\u20998?\u20154?\u26469?\u-29708?\u-244?\u21482?\u26159?\u20570?\u19968?\u20010?\u27719?\u24635?\u30340?\u24037?\u20855?\u12290?\u20294?\u20854?\u23454?\u25968?\u-28657?\u24456?\u24378?\u22823?\u-244?\u21487?\u20197?\u20998?\u27573?\u12289?\u21487?\u20197?\u25286?\u20998?\u-30616?\u26684?\u12289?\u21487?\u20197?\u20570?\u21160?\u24577?\u22270?\u-30616?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u23545?\u20110?\u22270?\u-30616?\u26469?\u-29708?\u-244?\u26465?\u26609?\u-26244?\u25240?\u24182?\u19981?\u-27060?\u29983?\u12290?\u20294?\u26159?\u24448?\u24448?\u26368?\u31616?\u21333?\u30340?\u25165?\u26159?\u26368?\u-26946?\u30340?\u-244?\u22914?\u20309?\u32473?\u-32767?\u26495?\u23637?\u31034?\u20986?\u26368?\u24819?\u-30335?\u30340?\u-28509?\u19968?\u-26782?\u-244?\u20197?\u21450?\u29992?\u-28711?\u22235?\u31181?\u31867?\u22411?\u22270?\u-28712?\u-32515?\u25193?\u23637?\u20986?\u20160?\u20040?\u22270?\u12290?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-28670?\u29992?\u23545?\u-29599?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25152?\u26377?\u23545?Excel\u26377?\u-26880?\u27714?\u30340?\u23398?\u21592?\u-244?\u19988?\u26085?\u24120?\u26377?\u20351?\u29992?\u-28729?Excel\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u24037?\u20855?\u21253?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u20250?\u26377?\u-30266?\u-26479?\u-29779?\u32451?\u-31707?\u20026?\u23398?\u21592?\u25299?\u23637?\u26032?\u30693?\u-29754?+\u22797?\u20064?\u20869?\u23481?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u26377?\u23567?\u31038?\u32676?\u23398?\u21592?\u21487?\u20197?\u25552?\u-27154?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u24494?\u20449?\u20844?\u20247?\u-29402?\u21495?\u26377?\u23558?\u-28719?150\u26399?\u30340?\u20869?\u23481?\u-244?\u20379?\u23398?\u21592?\u20108?\u27425?\u23398?\u20064?\u21644?\u22797?\u20064?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u20142?\u28857?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u-29698?\u31243?\u-29774?\u-30237?\u26041?\u24335?\u26159?\u20197?\u26696?\u20363?\u20316?\u20026?\u21576?\u29616?\u-244?\u30446?\u26631?\u26159?\u26356?\u26377?\u24773?\u26223?\u21270?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u26377?\u-30266?\u-26479?\u-29779?\u32451?\u-31707?\u21644?\u24494?\u20449?\u20844?\u20247?\u-29402?\u21495?\u-28709?\u-30644?\u22238?\u24518?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u22823?\u32434? Outline\b0\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u19968?\u12289?\u22522?\u30784?\u21151?\u-32515?\u-31741?\u21462?\u19982?\u32508?\u21512?\u-28720?\u29992?\u-32515?\u21147?\u25552?\u21319?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u-28663?\u25321?\u19978?\u19975?\u-30644?\u25968?\u25454?\u-244?\u-26946?\u-28589?\u-26784?\u25302?\u25341?\u-225?\u-29307?\u-28729?2\u31186?\u31639?\u25105?\u-28781?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u22635?\u20805?\u25968?\u25454?\u-244?\u-26784?\u21452?\u20987?\u-225?\u20320?\u30693?\u-28589?\u23427?\u30340?\u32570?\u-27017?\u21527?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u24207?\u21495?\u23601?\u-32515?\u29609?\u-28820?\u24037?\u-29372?\u26465?\u-244?\u22914?\u20309?\u27599?\u19968?\u-30644?\u24555?\u-28641?\u21152?\u-30616?\u22836?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u-28712?\u22312?\u29992?\u20989?\u25968?\u27719?\u24635?\u27714?\u21644?\u21527?\u-225?\u31896?\u-29388?\u20063?\u21487?\u20197?\u23436?\u25104?\u-28720?\u31639?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u31896?\u-29388?\u21518?\u-30616?\u26684?\u23485?\u24230?\u21464?\u24418?\u-244?\u25163?\u24037?\u-29693?\u-225?\u19968?\u25307?\u-30237?\u20915?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.1\u21015?\u25968?\u25454?\u22914?\u20309?\u24555?\u-28641?\u25353?\u29031?\u-30335?\u27714?\u25286?\u25104?\u22810?\u21015?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.\u25968?\u25454?\u25343?\u26469?\u23601?\u-32515?\u20351?\u29992?\u21527?\u-225?\u25945?\u20320?\u19968?\u25307?\u19975?\u-32515?\u28165?\u27927?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8.\u-28663?\u25321?\u24615?\u31896?\u-29388?\u19982?\u20998?\u21015?\u32467?\u21512?\u-244?\u-30237?\u20915?\u23454?\u25112?\u24773?\u26223?\u-27154?\u-26472?\u20004?\u20010?\u26696?\u20363?\u12290?\u25945?\u20320?\u20998?\u-30237?\u-27154?\u-26472?\u30340?\u26041?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 9.\u25968?\u25454?\u-28720?\u31639?\u19982?\u25968?\u25454?\u24405?\u20837?\u30340?\u-30268?\u-31997?\u-244?\u-29783?\u20320?\u19981?\u20877?\u20986?\u-27367?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 10.\u22914?\u20309?\u24555?\u-28641?\u25235?\u20303?\u-30616?\u20013?\u30340?\u29305?\u24449?\u31867?\u22411?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 11.\u23450?\u20301?\u26465?\u20214?\u19982?\u24207?\u21495?\u32467?\u21512?\u-244?\u-30237?\u20915?\u23454?\u25112?\u24773?\u26223?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 12.\u-28663?\u25321?\u24615?\u31896?\u-29388?\u19982?\u23450?\u20301?\u26465?\u20214?\u32467?\u21512?\u-244?\u-30237?\u20915?\u23454?\u25112?\u24773?\u26223?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 13.\u23450?\u20301?\u26465?\u20214?\u19982?\u-28663?\u25321?\u24615?\u31896?\u-29388?\u12289?\u20998?\u21015?\u32467?\u21512?\u-244?\u-30237?\u20915?\u23454?\u25112?\u24773?\u26223?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u20108?\u12289?\u25968?\u25454?\u32479?\u-29791?\u19982?\u25968?\u25454?\u20998?\u26512?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u21019?\u24314?\u19982?\u19977?\u22823?\u25490?\u29256?\u21407?\u21017?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u21033?\u29992?\u-29307?\u32423?\u-30616?\u30772?\u-30237?\u25968?\u-28657?\u21160?\u24577?\u-31997?\u22260?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u21033?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u22270?\u21644?\u20999?\u29255?\u22120?\u-244?\u20570?\u20202?\u-30616?\u26495?\u-32684?\u21160?\u24335?\u25253?\u21578?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u22914?\u20309?\u21033?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u20570?\u21344?\u27604?\u20998?\u26512?\u-248?\u25972?\u20307?\u21344?\u27604?\u-244?\u23618?\u32423?\u21344?\u27604?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u22914?\u20309?\u21033?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u20570?\u25490?\u21517?\u20998?\u26512?\u-248?\u29305?\u23450?\u-26502?\u24207?\u25490?\u21517?\u-244?\u19994?\u32489?\u25490?\u21517?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.\u22914?\u20309?\u21033?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u20570?\u32676?\u32452?\u20998?\u26512?\u-248?\u-26503?\u30446?\u32676?\u32452?\u-244?\u25968?\u23383?\u31867?\u32676?\u32452?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.\u22914?\u20309?\u21033?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u20570?\u26102?\u-27148?\u20998?\u26512?\u-248?\u23395?\u24230?\u20998?\u26512?\u12289?\u24180?\u24230?\u20998?\u26512?\u12289?\u26376?\u24230?\u20998?\u26512?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8.\u29992?\u30495?\u23454?\u26696?\u20363?\u21578?\u-29751?\u20320?\u-244?\u22914?\u20309?\u20351?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-244?\u21033?\u29992?\u25968?\u25454?\u25351?\u23548?\u20844?\u21496?\u-28720?\u-31707?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 9.\u-30616?\u26684?\u24555?\u-28641?\u25286?\u20998?\u-26784?VBA\u-225?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u23601?\u21487?\u20197?\u25630?\u23450?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u19977?\u12289?\u-29695?\u-29708?\u20989?\u25968?\u-28509?\u20040?\u21487?\u24597?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u32654?\u20803?\u31526?\u21495?\u22312?\u21442?\u25968?\u20013?\u30340?\u24847?\u20041?\u-244?\u29609?\u-28820?\u23427?\u25165?\u26159?\u20989?\u25968?\u30340?\u24320?\u22987?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u-28646?\u-28729?Vlookup\u20989?\u25968?\u-244?\u20102?\u-30237?\u20989?\u25968?\u30340?\u-30268?\u21017?\u20197?\u21450?\u-29776?\u20303?\u20989?\u25968?\u30340?\u26041?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.Vlookup\u22312?1985\u24180?\u-29762?\u-29791?\u20043?\u21021?\u30340?\u32570?\u-27017?\u20197?\u21450?\u30772?\u-30237?\u20043?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.Vlookup\u30340?\u27169?\u31946?\u20351?\u29992?\u-30268?\u21017?\u20197?\u21450?\u30772?\u-30237?IF\u23884?\u22871?\u22810?\u30340?\u22256?\u24785?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u21033?\u29992?N/A\u-26503?\u-30237?\u20915?\u23454?\u25112?\u20013?\u30340?\u27604?\u23545?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.\u22810?\u23545?\u22810?\u24773?\u20917?\u19979?\u-244?\u-29723?\u22914?\u20309?\u23436?\u25104?\u25968?\u25454?\u21305?\u-28339?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.\u31616?\u31216?\u19982?\u20840?\u31216?\u-27148?\u-244?\u25968?\u25454?\u23548?\u20837?\u19982?\u21305?\u-28339?\u20351?\u29992?\u26041?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8.Xlookup\u-29730?\u29983?\u19982?\u30772?\u-30237?Vlookup\u30340?\u32570?\u-27017?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 9.\u21033?\u29992?GetpivotData\u20989?\u25968?\u-244?\u-30237?\u20915?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u26080?\u27861?\u21160?\u24577?\u25552?\u25968?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 10.Sumifs\u22810?\u26465?\u20214?\u19979?\u27719?\u24635?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 11.Sumifs\u30340?\u27169?\u31946?\u21305?\u-28339?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 12.Countifs\u20989?\u25968?\u21482?\u20570?\u21442?\u25968?\u-30237?\u26512?\u-230?\u-29783?\u23398?\u21592?\u-32278?\u24049?\u21435?\u25720?\u32034?\u24773?\u26223?\u20013?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 13.Averageifs\u30340?\u20351?\u29992?\u-230?\u23398?\u21592?\u23436?\u20840?\u-32278?\u24049?\u23398?\u20064?\u21442?\u25968?\u-28720?\u29992?\u-244?\u-28646?\u-28729?\u27492?\u20989?\u25968?\u-29783?\u23398?\u21592?\u-32278?\u25105?\u25104?\u-27265?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 14.If\u20989?\u25968?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 15.\u22914?\u20309?\u30772?\u-30237?IF\u20989?\u25968?\u23884?\u22871?\u-26946?\u30340?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 16.IF\u20989?\u25968?\u19982?Vlookup\u20989?\u25968?\u32467?\u21512?\u-244?\u25552?\u-25896?\u23454?\u25112?\u20013?\u32508?\u21512?\u-30237?\u20915?\u23454?\u25112?\u30340?\u-32515?\u21147?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 17.\u20026?\u20160?\u20040?\u-28781?\u20986?\u30340?\u26159?\u20989?\u25968?\u-244?\u-32756?\u19981?\u26159?\u-28781?\u20986?\u30340?\u20540?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 18.\u-28646?\u-28339?\u31526?\u30340?\u21452?\u20995?\u21073?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u22235?\u12289?\u23545?\u-29688?\u22270?\u-32142?\u21464?\u-29708?NO\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u30334?\u20998?\u27604?\u19968?\u23450?\u-28663?\u-26244?\u24418?\u22270?\u21527?\u-225?\u28145?\u24230?\u-30237?\u26512?\u-26244?\u24418?\u22270?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u22270?\u-30616?\u19982?\u22270?\u29255?\u32467?\u21512?\u-244?\u29609?\u20986?\u-25896?\u22823?\u19978?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u20570?\u25968?\u25454?\u20998?\u26512?\u24590?\u20040?\u23569?\u30340?\u20102?\u23427?\u-244?\u28431?\u26007?\u22270?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u20570?\u-29791?\u21010?\u24590?\u20040?\u-32515?\u19981?\u20250?\u23427?\u-244?\u29976?\u29305?\u22270?\u19968?\u30446?\u20102?\u28982?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u23454?\u-27067?\u21644?\u-29791?\u21010?\u24773?\u20917?\u30340?\u26174?\u31034?\u-244?\u27700?\u-27402?\u124?\u23376?\u24377?\u22270?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.\u25910?\u20837?\u21644?\u25903?\u20986?\u12289?\u31163?\u-32692?\u21644?\u20837?\u-32692?\u-244?\u30456?\u24726?\u22411?\u20851?\u31995?\u30340?\u23637?\u31034?---\u-30860?\u-30858?\u124?\u26059?\u-26418?\u22270?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.\u25968?\u25454?\u-28209?\u24046?\u-29219?\u22823?\u-244?\u-28640?\u25104?\u19968?\u32452?\u25968?\u25454?\u26174?\u31034?\u22826?\u23567?\u24590?\u20040?\u21150?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8.\u22914?\u20309?\u24039?\u22937?\u21033?\u29992?\u22270?\u-30616?\u-28212?\u30340?\u27169?\u22411?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 9.\u22914?\u20309?\u-28805?\u26494?\u28155?\u21152?\u22270?\u-30616?\u-28212?\u25152?\u-26880?\u30340?\u20803?\u32032?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u20116?\u12289?\u23439?\u30340?\u20351?\u29992?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u23439?\u30340?\u24405?\u21046?\u19982?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u24320?\u21457?\u24037?\u20855?\u30340?\u28155?\u21152?\u19982?\u20351?\u29992?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29323?\u-32767?\u24072?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29372?\u21382?\u-32564?\u26223?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u29616?\u-32680?\u-29705?\u20026?\u25628?\u29392?\u-29406?\u21153?\u25968?\u25454?\u20998?\u26512?\u-26498?\u-27154?\u-244?\u-29409?\u-29405?\u-30237?\u20915?\u-29406?\u21153?\u26041?\u21521?\u30340?\u25968?\u25454?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u19990?\u30028?\u-27402?\u-30644?OFFICE\u26041?\u21521?\u19987?\u23478?\u-26498?\u-27154?\u-244?\u-30237?\u20915?\u30456?\u20851?\u-26490?\u22495?\u25152?\u26377?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25480?\u-29698?\u32463?\u-25972?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20013?\u25237?\u-244?\u20013?\u22269?\u20154?\u20445?\u-244?\u19990?\u30028?\u-27402?\u-30644?\u-244?\u20013?\u22269?\u-27402?\u-30644?\u-244?\u20892?\u19994?\u-27402?\u-30644?\u-244?\u28044?\u-27417?\u25237?\u-29372?\u-244?\u22269?\u20449?\u-29759?\u21048?\u-244?\u26477?\u24030?\u-27402?\u-30644?\u-244?\u-32015?\u29305?\u23572?\u-244?\u30334?\u24230?\u-244?\u20013?\u-32214?\u20449?\u-244?\u29483?\u30524?\u-244?\u28165?\u21326?\u21516?\u26041?\u-244?\u24403?\u24403?\u-244?\u28023?\u-28791?\u-244?\u24555?\u-27471?\u25903?\u20184?\u-244?\u22825?\u-25027?\u-244?\u-24922?\u-32765?\u26519?\u-244?\u24247?\u21513?\u26862?\u-244?CCTV\u-244?\u26131?\u20256?\u23186?\u-244?\u25628?\u29392?\u-26938?\u22242?\u-244?\u27773?\u-28826?\u20043?\u23478?\u-244?\u22269?\u32593?\u-244?\u21335?\u32593?\u-244?\u20013?\u28023?\u27833?\u-244?\u20013?\u30707?\u21270?\u-244?\u27993?\u-32515?\u-244?\u31070?\u21326?\u29028?\u27833?\u-244?\u20013?\u-32214?\u27833?\u31561?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u25105?\u-30335?\u25253?\u21517?\b0\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u21672?\u-29726?\u30005?\u-29731?\u-230?027-5111 9925 , 027-5111 9926\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u20540?\u29677?\u25163?\u26426?\u-230?18971071887    \u-28498?\u31665?\u-230?Service@mingketang.com\par}