ࡱ> XY  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWRoot Entry FPͫAWorkbookCOle :OlePres000" *F\ Embedding 1Oh+'0@H`x Stefan EckhofRainer BergmannMicrosoft Excel@ǽbd)@TA՜.+,0 PXl t|  Teamworks 3 Zl" 6d  i  '' ' h' h' hArial- 2  Tabelle fr: "System 7-'- -- Arial-*2 ANZAHL@Lineares Muster1    ----'- -- Arial-2  B1@Skizze3  ----'- h-'-  d2 >(NT73350-21+SN 72523X 60 -2,2-0,6+K-PAK D2- 80X 60_111-35)      2 2 2  80-'- h-'-  d2 >(NT73350-22+SN 72523X 70 -3,2-0,9+K-PAK D2- 95X 65_111-35)      2 2 2  95-'- h-'-  d2 >(NT73350-23+SN 72523X 80 -5,9-1,7+K-PAK D2-110X 90_111-35)      2 2 2 110-'- h-'-  d2 >(NT73350-00+SN 72523X 60 - 10-2,5+K-PAK D5- 80X 280_111-35)      2 5 2  80-'- h-'-   d2 >(NT73350-01+SN 72523X 60 - 11-2,8+K-PAK D5- 80X 310_111-35)      2 5 2  80-'- h-'-  d2 >(NT73350-03+SN 72523X 70 - 16-4,1+K-PAK D5- 95X 310_111-35)      2 5 2  95-'- h-'- - d2 >(NT73350-02+SN 72523X 60 - 13-3,2+K-PAK D6- 80X 350_111-35)      2 6 2  80-'- h-'- =. d2 ->(NT73350-04+SN 72523X 70 - 18-4,6+K-PAK D6- 95X 350_111-35)      2 -6 2 - 95-'- h-'- M> d2 =>(NT73350-05+SN 72523X 70 - 20-5,2+K-PAK D6- 95X 400_111-35)      2 =6 2 = 95-'- h-'- ]N d2 M>(NT73350-06+SN 72523X 80 - 26-7,0+K-PAK D6-110X 390_111-35)      2 M6 2 M110-'- h-'- m^ d2 ]>(NT73350-07+SN 72523X 80 - 30-8,2+K-PAK D6-110X 460_111-35)      2 ]6 2 ]110-'- h-'- }n d2 m>(NT73350-08+SN 72523X 80 - 36-9,7+K-PAK D6-110X 540_111-35)      2 m6 2 m110-'- h-'- h-  -- @ !-- @ !-- @ !-- @ !-- @ !-- @ !-- @ !-  - @ ! -- @ !---- @ !--==- @ !=-MM- @ !M-]]- @ !]-mm- @ !m-}}- @ !}-- @ !-- @ !-- @ !-- @ !-- @ !-- @ !-- @ !-- @ !-- @ !-$$- @ !$-55- @ !5-FF- @ !F-WW- @ !W-hh- @ !h-yy- @ !y-- @ !-- @ !-- @ !-- @ !-- @ !-- @ !-- @ !-- @ !-- @ !-##- @ !#-44- @ !4-EE- @ !E-VV- @ !V-gg- @ !g-h- @ !h-h- @ !h-h- @ !h-h- @ !h--'- h'NANI \pRainer Bergmann Ba=DieseArbeitsmappe=pU2x-8X@"1Arial1Arial1Arial1Arial1Courier1Arial1 Arial1$Arial1Courier1& Courier New3#,##0\ " ";\-#,##0\ " "=#,##0\ " ";[Red]\-#,##0\ " "?#,##0.00\ " ";\-#,##0.00\ " "I"#,##0.00\ " ";[Red]\-#,##0.00\ " "q*6_-* #,##0\ " "_-;\-* #,##0\ " "_-;_-* "-"\ " "_-;_-@_-k)3_-* #,##0\ _ _-;\-* #,##0\ _ _-;_-* "-"\ _ _-;_-@_-,>_-* #,##0.00\ " "_-;\-* #,##0.00\ " "_-;_-* "-"??\ " "_-;_-@_-{+;_-* #,##0.00\ _ _-;\-* #,##0.00\ _ _-;_-* "-"??\ _ _-;_-@_-"Ja";"Ja";"Nein""Wahr";"Wahr";"Falsch""Ein";"Ein";"Aus"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                 + )      , * 1  1 Z  Z  @/  @*  ZP/  ZP* Q"xQ x  q x  1 D  D a"xa x       1( ( 1 ZT)   X)  Standard_Teil -1Standard_Teil -120Standard_Teil -51`Tabelle1CTabelle2wTabelle311sX@Fritzmdexxfertige_TeileSN 71214 KernblecheSN 71214-170 Streifenschnitt Typ DX.xlsTabelle1Tabelle3YFamily1::'Such:;B"N<)Ziel:;B"N" qSsbezei1Ssbezei2SszeinumDatenbernahmeFormelSN 72523X 60 -2,2-0,6 NT73350-21SN 72523X 70 -3,2-0,9 NT73350-22SN 72523X 80 -5,9-1,7 NT73350-23SN 72523X 60 - 10-2,5 NT73350-00SN 72523X 60 - 11-2,8 NT73350-01SN 72523X 70 - 16-4,1 NT73350-03SN 72523X 60 - 13-3,2 NT73350-02SN 72523X 70 - 18-4,6 NT73350-04SN 72523X 70 - 20-5,2 NT73350-05SN 72523X 80 - 26-7,0 NT73350-06SN 72523X 80 - 30-8,2 NT73350-07SN 72523X 80 - 36-9,7 NT73350-08ANZAHL@Lineares Muster1 B1@Skizze1 B1@Skizze3 L@Skizze1K-PAK D2- 80X 60_111-35K-PAK D2- 95X 65_111-35K-PAK D2-110X 90_111-35K-PAK D5- 80X 280_111-35K-PAK D5- 80X 310_111-35K-PAK D5- 95X 310_111-35K-PAK D6- 80X 350_111-35K-PAK D6- 95X 350_111-35K-PAK D6- 95X 400_111-35K-PAK D6-110X 390_111-35K-PAK D6-110X 460_111-35K-PAK D6-110X 540_111-35 Tabelle fr: K-BL D 6 95X 350_111-35SN 71214 11- 25- 60 NT73750-50K-BL D 5 95X 310_111-35SN 71214 11- 25- 65 NT73750-48K-BL D 6 110X 540_111-35SN 71214 11- 20-100 NT73750-58K-BL D 2 110X 90_111-35SN 71214 11- 25- 40 NT73750-32K-BL D 6 80X 390_111-35SN 71214 11- 20- 70 NT73750-53K-BL D 2 95X 65_111-35SN 71214 11- 20- 25 NT73750-30K-BL D 4 110X 198_530-50SN 71214 9,5- 20- 52 NT73751-99K-BL D 6 110X 460_111-35SN 71214 11- 30- 80 NT73750-56K-BL D 6 80X 460_111-35 NT73750-55K-BL D 6 110X 390_111-35 NT73750-54K-BL D 2 80X 90_111-35 NT73750-31K-BL D 6 80X 540_111-35 NT73750-57K-BL D 6 80X 350_111-35 NT73750-46K-BL D 5 60X 310_111-35 NT73750-43K-BL D 5 80X 280_111-35SN 71214 11- 20- 60 NT73750-42K-BL D 5 60X 280_111-35 NT73750-41K-BL D 6 70X 350_111-35 NT73750-49K-BL D 5 80X 310_111-35 NT73750-44K-BL D 6 60X 350_111-35 NT73750-45K-BL D 5 70X 310_111-35 NT73750-47K-BL D 2 60X 60_111-35SN 71214 11- 20- 20 NT73750-27K-BL D 4 95X 455_111-35SN 71214 15- 64-109 NT73751-12K-BL D 4 95X 435_111-35SN 71214 15- 54-109 NT73751-13K-BL D 4 95X 401_111-35SN 71214 15- 37-109 NT73751-14K-BL D 2 70X 65_111-35 NT73750-29K-BL D 2 80X 60_111-35 NT73750-28Excel soll denTEIL($G3;10;18) der SpalteG in der Tabelle3, Spalte A suchen. Bei Gleichheit mchte ich ausder betreffenden Zeile,der Spalte B der Tabelle 3 ein Teilstck auslesen.(TeilTabelle3 B;17,4)Tabelle3 Spalte Dz  *G[$j5X{%Bg= ccR   C  dMbP?_*+%"<~?<~?U } =} I} $} } $} } m} } } 5     @ @ @ @ @ @ @ @ @ @ @ @ @ @ @               -       ,p $J(+!L  , BA>(NT73350-21+SN 72523X 60 -2,2-0,6+K-PAK D2- 80X 60_111-35)%K(LA2% K(L A 80%K(LA 60% K(L A 60G-_!1#*D A#B@BA- 20;4K %Z :BK-PAK D2- 80X 60_111-35;hK  %Z :BSN 72523X 60 -2,2-0,6;K %Z :B NT73350-21 K( - #(L+L+L)BPA>(NT73350-21+SN 72523X 60 -2,2-0,6+K-PAK D2- 80X 60_111-35)$4L(A>(NT73350-22+SN 72523X 70 -3,2-0,9+K-PAK D2- 95X 65_111-35)%L(2%L( 95%L( 65%L( 70G-l`!1#*D A#B@BA- 25;L %Z :BK-PAK D2- 95X 65_111-35;M  %Z :BSN 72523X 70 -3,2-0,9;HM %Z :B NT73350-22 `M( A>(NT73350-22+SN 72523X 70 -3,2-0,9+K-PAK D2- 95X 65_111-35)$M(A>(NT73350-23+SN 72523X 80 -5,9-1,7+K-PAK D2-110X 90_111-35)%`N(2%dN(110%lN( 90%xN( 80G-x`!1#*D A#B@BA- 40;N %Z :BK-PAK D2-110X 90_111-35;N  %Z :BSN 72523X 80 -5,9-1,7;N %Z :B NT73350-23  O( A>(NT73350-23+SN 72523X 80 -5,9-1,7+K-PAK D2-110X 90_111-35)$O(A>(NT73350-00+SN 72523X 60 - 10-2,5+K-PAK D5- 80X 280_111-35)% P(5%P( 80%P( 280%$P( 60G-`!1#*D A#B@BA- 60;8P %Z :BK-PAK D5- 80X 280_111-35;lP  %Z :BSN 72523X 60 - 10-2,5;P %Z :B NT73350-00 P( A>(NT73350-00+SN 72523X 60 - 10-2,5+K-PAK D5- 80X 280_111-35)$8Q(A>(NT73350-01+SN 72523X 60 - 11-2,8+K-PAK D5- 80X 310_111-35)%Q(5%Q( 80%Q( 310%Q( 60G-`!1#*D A#B@BA- 65;Q %Z :BK-PAK D5- 80X 310_111-35;R  %Z :BSN 72523X 60 - 11-2,8;LR %Z :B NT73350-01 dR( A>(NT73350-01+SN 72523X 60 - 11-2,8+K-PAK D5- 80X 310_111-35)$R(A>(NT73350-03+SN 72523X 70 - 16-4,1+K-PAK D5- 95X 310_111-35)%dS(5%hS( 95%pS( 310%|S( 70G-`!1#*D A#B@BA- 65;S %Z :BK-PAK D5- 95X 310_111-35;S  %Z :BSN 72523X 70 - 16-4,1;S %Z :B NT73350-03 T( A>(NT73350-03+SN 72523X 70 - 16-4,1+K-PAK D5- 95X 310_111-35)$T(A>(NT73350-02+SN 72523X 60 - 13-3,2+K-PAK D6- 80X 350_111-35)%U(6%U( 80%U( 350%(U(  60G-`! 1#*D A#B@BA- 60;(NT73350-02+SN 72523X 60 - 13-3,2+K-PAK D6- 80X 350_111-35) $(NT73350-04+SN 72523X 70 - 18-4,6+K-PAK D6- 95X 350_111-35) %V( 6 %V(  95 %V(  350 %V(  70G -`! 1#*D  A#B@BA- 60; V %Z :BK-PAK D6- 95X 350_111-35; W %Z :BSN 72523X 70 - 18-4,6; PW %Z :B NT73350-04 hW(  A>(NT73350-04+SN 72523X 70 - 18-4,6+K-PAK D6- 95X 350_111-35) $W( A>(NT73350-05+SN 72523X 70 - 20-5,2+K-PAK D6- 95X 400_111-35) %hX( 6 %lX(  95 %tX(  400 %X(  70G -*`! 1#*D  A#B@BA; X %Z  : BK-PAK D6- 95X 400_111-35; X %Z  : BSN 72523X 70 - 20-5,2; X %Z  : B NT73350-05 Y(  A>(NT73350-05+SN 72523X 70 - 20-5,2+K-PAK D6- 95X 400_111-35) $Y( A>(NT73350-06+SN 72523X 80 - 26-7,0+K-PAK D6-110X 390_111-35) %Z( 6 % Z( 110 %Z(  390 % Z(  80G -`! 1#*D  A#B@BA- 70; 4Z %Z  : BK-PAK D6-110X 390_111-35; hZ %Z  : BSN 72523X 80 - 26-7,0; Z %Z  : B NT73350-06 Z(  A>(NT73350-06+SN 72523X 80 - 26-7,0+K-PAK D6-110X 390_111-35) $4[( A>(NT73350-07+SN 72523X 80 - 30-8,2+K-PAK D6-110X 460_111-35) %[( 6 %[( 110 %[(  460 %[(  80G -`! 1#*D  A#B@BA- 80; [ %Z  : BK-PAK D6-110X 460_111-35; \ %Z  : BSN 72523X 80 - 30-8,2; H\ %Z  : B NT73350-07 `\(  A>(NT73350-07+SN 72523X 80 - 30-8,2+K-PAK D6-110X 460_111-35) $\( A>(NT73350-08+SN 72523X 80 - 36-9,7+K-PAK D6-110X 540_111-35) %`]( 6 %d]( 110 %l](  540 %x]( 80G -`!1#*D  A#B@BA-100; ] %Z  : BK-PAK D6-110X 540_111-35; ] %Z  : BSN 72523X 80 - 36-9,7; ] %Z  : B NT73350-08  ^(  A>(NT73350-08+SN 72523X 80 - 36-9,7+K-PAK D6-110X 540_111-35)$^(%^(%^(%^(%^(%;^ %Z  : B;^ %Z  : B;^  %Z  : B ^( (++)$^(%^(%^(%^(%^(%;^ %Z :B;^ %Z :B;^  %Z :B ^( (++)$^(%^(%^(%^(%^(%;^ %Z :B;^ %Z :B;_  %Z :B _(T- (++)) *o)))))))+))))*+B*X*b   >@527 Tabelle1  8=FLQUV[_dui=nsaw  dMbP?_*+%M,\\PRINTMASTER\EPSON Stylus COLO`N  4dhh3 *** qhhDLLName32=e_du10me.dll L dL 2EPSON Stylus COLOR 850" d<~?<~?U } I} } $ =      ! ! ! #! # # #" # # ## # # #$ # # #% # # #& # # #' # # #( # # #) # # #* # # #+ # # #, # # """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """Dl************* !"#$%&'()*+,-./0123456789:;<=>? """ !""" """" #""" $""" %""" &""" '""" (""" )""" *""" +""" ,""" -""" .""" /""" 0""" 1""" 2""" 3""" 4""" 5""" 6""" 7""" 8""" 9""" :""" ;""" <""" =""" >""" ?"""Dl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @""" A""" B""" C""" D""" E""" F""" G""" H""" I""" J""" K""" L""" M""" N""" O""" P""" Q""" R""" S""" T""" U""" V""" W""" X""" Y""" Z""" [""" \""" ]""" ^""" _"""Dl`abcdefghijklmnopqrstuvwxyz{|}~ `""" a""" b""" c""" d""" e""" f""" g""" h""" i""" j""" k""" l""" m""" n""" o""" p""" q""" r""" s""" t""" u""" v""" w""" x""" y""" z""" {""" |""" }""" ~""" """Dl """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """Dl """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """Dl """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """Dl """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """Dl      """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """ """Dl !"#$%&'()*+,-./0123456789:;< """ !""" """" #""" $""" %""" &""" '""" (""" )""" *""" +""" ,""" -""" .""" /""" 0""" 1""" 2""" 3""" 4""" 5""" 6""" 7""" 8""" 9""" :""" ;""" <""">0>@/2 7 Tabelle2  {  dMbP?_*+%M6HP DeskJet 722CXC 4d,,A4DINU"4$@$$$$$" d,,<~?<~?U } } $} m       & & & '. '/ '0 '1 '2 '3 '4 '5 '6 '7 '8 '9 ': '; '< '= '> '? '@ 'A 'B 'C 'D 'E 'F 'D 'G 'H '; 'I 'J '8 'K 'L '5 'M 'N '/ 'O 'P '2 'Q 'R 'S 'T 'U 'S 'V (W (/ (X (Y (2 (Z ([ (/ (\ (] (2 (^ (_ (` (a (b (c (d (e (f (g (h (i (j (k (> (l (m (` (n:**************************>@7 Tabelle3 SummaryInformation(DocumentSummaryInformation8CompObj p Tabelle1 Tabelle2 Tabelle3 Arbeitsbltter F$Microsoft Office Excel-ArbeitsblattBiff8Excel.Sheet.89q