ࡱ> b  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry F  ïKWorkbook"A_VBA_PROJECT_CUR" ,rï ïVBA,rïRï \ptaernst Ba=VSDieseArbeitsmappe=-8^9?8X@"1Arial1Arial1Arial1Arial1Arial1Arial1@Arial1Arial1Arial1Arial1Arial1Arial1+Arial1 Arial1$Arial18Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial18Arial1Arial""SFr."\ #,##0;"SFr."\ \-#,##0'""SFr."\ #,##0;[Red]"SFr."\ \-#,##0(#"SFr."\ #,##0.00;"SFr."\ \-#,##0.00-("SFr."\ #,##0.00;[Red]"SFr."\ \-#,##0.00F*A_ "SFr."\ * #,##0_ ;_ "SFr."\ * \-#,##0_ ;_ "SFr."\ * "-"_ ;_ @_ .))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ N,I_ "SFr."\ * #,##0.00_ ;_ "SFr."\ * \-#,##0.00_ ;_ "SFr."\ * "-"??_ ;_ @_ 6+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_  "Jahr:"\ 0#[$-807]dddd\,\ d\.\ mmmm\ yyyy mmmmmmmm\ dd\,\ yyyy mmmm\ yyyy[$-F800]dddd\,\ mmmm\ dddd\ \ \ \ \ dddddd dddd dddd\ dd h/mm dd/mm/yyyy;@ dd/mm/yy;@ hh/mm" h";@ hh/mm;@0.0#.# 0.0\ "Tage" #0.0 #0.0\ "Tage" mmm\ yyyy0.0\ "Stunden / Tag"0.0\ "h ferienGuthaben"0.0\ "h/D, Tagesstunden"0.0\ "D FerienGuthaben"0.00\ "h GleitZeit"0.0\ "GleitZeit"000.0\ "GleitZeit"##0.0\ "GleitZeit" ??0.00???0.00\ "GleitZeit" ???0.00% ???0.0;[Red]\-??0.0\ "Gleitziet"2-???0.0\ "Gleitziet";[Red]\-??0.0\ "Gleitziet"2-???0.0\ "Gleitzeit";[Red]\-??0.0\ "Gleitzeit"50???0.0\ "Gleitzeit";[Yellow]\-??0.0\ "Gleitzeit"61???0.0\ "h Gleitzeit";[Red]\-??0.0\ "h Gleitzeit"94??0.0\ "D Ferienguth.";[Red]\-??0.0\ "D Ferienguth."83???0.00\ "h Gleitzeit";[Red]\-??0.00\ "h Gleitzeit";6???0.00\ "h Gleitzeit";[Yellow]\-??0.00\ "h Gleitzeit" "("0.00")"4/??0.0\ "D Ferien";[Red]\-??0.0\ "D Ferienguth."/*??0.0\ "D Ferien";[Red]\-??0.0\ "D Ferien"???0.00;[Red]\-??0.000.00;[Red]\-0.000.0;[Red]\-0.0 "h/Tag: "0.0 d/mm/yy;@0.0;0;[Red]\-0.00.0;;[Red]\-0.00.0;"";[Red]\-0.00.#;[Red]\-0.00.##;[Red]\-0.## 0.0000.##;[Red]\-0.00 0.0%`                ` `     Z` `) ! Z ` ` - ` ,p (` *   + `  #Zl Z  (@ ) @  #Zl   4 `   hd )  xd )   ` Z   yU * ``  h)  ` * ! ` `  `  ` `) (P $p Z`  `  1`  `  @    x h !) qZ  qZ `  | Q() Q() Qx h` @Z ` @Z `` x  ( Q(w ) Q(w ) Q(w ) Q(w ) Q(p ) Q) Q) Q() Q` ) Q` ) w  g   !    !  ! ` @Z(` Q() Q(  ) Q ) Q()  l Q() p "   a!h )  ) h  ` ) )  a!h  qZ  ` h @Z `   ww  `ww   gw  r   rw  rw  ww  ww  Qp ) p ) ( ( h (p (p hp ( ( ( ( (p (p (  ( h $ $ %  % %` % % %` (` (`p (` (` #( #h #(` $`  'P 'Q   'Pp  'Qp  p   (` (`p  % % %`   `  ,  # pw  'Q 'Q  r   w  `w   g  0 "0  0 0 0 0 0 (rw  #( ( .p     L  l  \  &Q8)  8  &Q8 )  8 8  a"Zx  a"Z8   a#Zx !#Z8  2-Datum 2-GleitZeit 2-MonatsTag 2-Soll 2-Typ2-berschriften2-berschriften vertikal 2-WochenTag 2-Zeit2-Zeit, dezimal 3-%-Tot 3-CHF 3-CHF-Tot 3-Datum 3-Index 3-Satz 3-TextEingabe! 3-Titel-Date"3-berschriften#3-berschriften-Klein$3-berschriften-kleinst%3-berschriften-Vertikal& 3-WP Titel' ( CopyPaste )Datum* DezimalZeit+FerienGuthaben, GleitZeit- .Index /Konto0 Konto Total1 Leistungszeit 2Monat3 MonatsTag4 P-Titel-Date5 P-WP Titel6 ResultatZeit 7Soll 8SollZeit9StundenZuteilung :Titel;Typ< berschriften=berschriften-Klein>berschriften-kleinst? WochenTag@ Zeit, dez AZeiten`x: Februar 2010 Januar 20101):# MONATSENDEJ !  =!  =0 !DieseArbeitsmappe.CreateNewMonth2Doz_1:Doz_2:Doz_3:Ext_1: Ext_2: Ext_3: % KostenStze;Prof_1:Prof_2:Prof_3: WissMit_1: WissMit_2: WissMit_3: Zus_1: Zus_2:Zus_3:"   XE&-    - # 3 A@@ 1MorgenMittagAbendAdmin GleitzeitIst. + h kumuliert =><= Kumuliert Jahr<= Total Monat <= VorMonatTextLabVIEW SupportMonatSollAFr: Arbeit / Frei A : ArbeitAFe: Arbeit / FerienAK : Arbeit / Krank Fr : FreiFrF: Frei / FerienFrK: Frei / Krank Fe : FerienFeK: Ferien / Krank Team SitzungVariaIn W PartnerpflegeRSTMC Verkehrshaus Assistenz:Beleuchtung: Future Light Ferien (D) Krank (h)Beleuchtung: Feldversuch KlotenMitarbeiterInfo AcquirierenK: KrankVaria: Kurse etc.Licht: TheorieTreff: 2009,1&2; 2010,1NullBeleuchtung: LichtstrasseTotProgrammierung Bespr / AdminKompensation GuthabenTreff: 2010,1 & 2:A7 7X78\8|9G :cc   mYye"  dMbP?_*+%M\\ps01\p0000539_hpclj3800_psS 4dXXA4PRIV0'''' P4(^>7 SMTJHP Universal Printing PSHPDocUISUITrueESPRITSupportedTrueHPOrientationHPOrientationPortraitHPOrientRotate180FalsePostScriptCustomPageSizeFalseDuplexDuplexNoTumbleHPReverseOrderForFold_StitchTrueHPBestGlossDefaultInputSlot*UseFormTrayTableHPDuplicateJobNameOverrideSWFWPageSizeA4PageRegionLeadingEdgeMediaTypePLAINHPMediaTypeTreeviewPopupTrueCollateTrueJCLHPPrintOnBothSidesManuallyFalseJCLEconomodeFalseOutputBinAutoStapleLocationNoneTextAsBlackFalseAlternateLetterHeadFalseJCLResolution600dpiJCLFastResNoneHPConsumerCustomPaperTruePrintQualityGroupPQGroup_1JRHDInstalledJRHDOffHPNUseDiffFirstPageChoiceTrueHPPageExceptionsFileHPCPE083HPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsCoverInsertionHPEnableRAWSpoolingTrueHPDocPropResourceDataHPCabFileNameRGBColorDefault-sRGBCMYKInksDefaultCMYK+JRConstraintsJRCHDFullHPColorSmartAutomaticHPColorSmart_ColorOptions_EdgeControlNormalHPColorSmart_ColorOptions_HalftoneDetailHPColorModeCOLOR_MODEHPColorSmart_Text_NeutralGraysBlackOnlyHPColorSmart_Text_HalftoneDetailHPColorSmart_Graphics_NeutralGraysBlackOnlyHPColorSmart_Graphics_HalftoneDetailHPColorSmart_Photo_NeutralGrays4-ColorHPColorSmart_Photo_HalftoneDetailHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_GROUPNAMEHPBornOnDateHPBODHPJobAccWoPinTrueHPXMLFileUsedhpcu083s.xmlPSAlignmentFileHPCLS083HPSmartHubInet_SID_263_BID_514_HID_265HPColorAsGrayFalseIUPHxAkA1HixK.z, AԊݝЪkR1`<`[%Mx~~#xU?7d&鶹Tuox;o3o&'@µpq)ʸ4-^ZȦse̢+o OƙϢWx6 x-dǾ;"^H׊h4Zj{:PpοgީPSԨ =`>asT3e:sZxOI慌&!o$̟U!…?}j=Femtz5>%oħc{ƾ4`i˴!ds $ZQq'GJxƼc_&'i;kjcI_d,o}ނf^\>Q|ynR7~;Z+k M   %pK" dXX<~?<~?cU } } } } } F} } C} } E} F} $} %% m&& &Z@ &@&;@ &;@&;@&;@&;@&;@ &;@ &;@  &;@ &; &;@& &;@&& & &5@ &h&@&&&&&&&&&&$?@@@@@@ @"@$@&@(@*@,@.@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@@@@@A@A@B@B@%~ L@@    sz@2$(L@L@BF BM@M@  M@  M@  M@  M?  M@M@M@M@M@M@M?M@M@M@M@M@M@M?M@M@M@M@M@  M@!!M?""M##M$$N%%I~ O@y,e@@DAEDADAAKf`@5D@9$B  D@ BKf@5D@9$B  D@ BK f@ 5D@9$B  D@ BK f@ 5D @9$B  D @ BK f@ 5D @9$B  D @ BK f@ 5D @9$B  D @ BK f @ 5D @9$B  D @ BKf@@5D @9$B  D @ BKf`@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf @5D@9$B  D@ BKf@@5D@9$B  D@ BKf`@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf @5D@9$B  D@ BKf@@5D@9$B  D@ BKf`@5D@9$B  D@ BK f@ 5D@9$B  D@ BK!f@!5D @9$B  D @ BK"f"5D!@9$B  D!@ BK#f3#5D"@9$B  D"@ BK$g3$5D#@9$B  D#@ BK%B35D$@9$B  D$@ B i!8@Z!0@  DD)@ %$D @@  $ @@@@@ ~ u@&$ ]"Z~ #Gz0@  %$!?  DD @@Y@ ~ j@$$ P^^xtqq? qq?$$ PL__tt$ P__ttUUUUUU? 98?$$ ]  qq?  rq?$ $ jL kkuu$ i o! {GzR@  D D # {GzR@  % $  @@@@ # zG @ 2 zG@ $ @@@@@ # zG @ zG@~ @$ $  ? zG@ )D %  B? zG*@ )D %  B? )\(4@ )D %  B? zG:@ )D %   B? = ףp=>@ )D %   B? \; )D %   B? z; )D %   B? {GzB@ )D %   B? ףp= E@ )D %  B? 333333I@ )D %  B? (\L@ )D %  B? QO@ )D %  B? z < )D %  B?  < )D %  B? P@ )D %  B? {GzR@ )D %  B? \L5 )D %  B?  < )D %  B? \$< )D %  B? (< )D %  B? ,< )D %  B? 0< )D %  B?  4< )D %  B?  8< )D %  B? 3<< )D %  B? z@< )D %  B? D< !)D %   B? ! H< ")D !% ! B? "fL< #)D "% " B? #GP< $)D #% # B? $T< )D $% $ B Q `! $@  D D # $@  % $    d $ZLAGLAGLAGLAGLAHLAHLAHLAH<AL    @                                       ffffff@(   (                               !  ! "  " #  # $  $   %G ?X<)D %  B?\<)D %  B?@ )D %  B? f`< )D %   B? 3d< )D %   B? 3h< )D %   B? fl< )D %   B? fp<)D %   B?t<)D %  B?x<)D %  B?f|<)D %  B?̀<)D %  B?3<)D %  B?<)D %  B?<)D %  B?$@ )D %  B?<5 )D %  B?f< )D %  B?< )D %  B?< )D %  B?< )D %  B?< )D %  B?< )D %  B?̰< )D %  B?(< )D %  B?<  )D %  B? < !)D %   B?!< ")D !% ! B?"< #)D "% " B?#< $)D #% # B?$< )D $% $ B lmGz.>Z!nQ:  DD#vzG @  %$v"$LLLL  (  zG @(      ((((((((  !!""##$$ ?z<)D% B?z<)D% B?< )D% B? z85  )D %  B? zG @  )D %  B? <  )D %  B? <  )D %  B? \4 )D %  B?\4 )D% B?\5 )D% B?\5 )D% B?\(5 )D% B?Q= )D% B?= )D% B?H5 )D% B?5 )D% B?zP5 )D% B?Q= )D% B?Q= )D% B?\= )D% B? = )D% B? $= )D% B?(= )D% B? ,= )D% B?0= )D% B?Q4=  )D% B? p8= !)D %  B?!f<= ")D!%! B?"3@= #)D"%" B?#D= $)D#%# B?$H= )D$%$ BDDDDD{$ LDD  D  D  D  D  DDDDDDDDDDDDDDDDDDD  D!!D""D##D$$DRJJVJ | K K  K  K  K  K  K K K&2KKKKKKKKKKKKKKKKKKKKSD%abbww } T T  T&  T  T  T  T T T h T T T T T T T T T T T T T T T  T !T "TTU$ /~ )D%$B$Y Z [ \ \, \$L @-Vcc(  c  c  c  c  ccccccccc@(c(ccccccccc  c!!c""c##c$$d p qW#r@  %#fffff>t@  %~yyG#@(+LDD$%p q0W#r@  %$.XK@ Z:$B~۶m۶m?(% ~ @> $%%6%% LA&LB%p qW#r?  %$.rJ@ Z:$B~< $%%p q(W#r333333?  %$.r33333A@ Z:$B~m۶m?(% ~ @e@> $%%p q%W#r %$.rf@Z:$B~۶m۶m@%D$%% p# qW#r %#P@ %~yy?%D$%%p q.W#r %$.rM@Z:$B~n۶m۶?%D$%% pqW#r %$.rZ:$B~%D$%% pqW#r %$.rZ:$B~%D$%%p q(W#r %$.r333333@Z:$B~aa?%D$%!%DNlC %^^X==l=2: &!&"&#&$&%&&&'&(&)&*&+&,&-&.&/&0&1&2&3&4&5&6&7&8&9&:&;&<&=&>&?& p+ qW# r  %!$# fffffB@4 %!$ ~0 0 ? %D $ %!%!p !q.!W#!r" %!!$.!rfffff&B@Z!:!$!B!~$I$I?!%D!$!%"% "pqW#"r# %""$."r#Z":"$"B"~"%D"$"%#% #pqW##r$ %##$.#r$Z#:#$#B#~#%D#$#%$%$p $q($W#$r  %$$$.$r?!Z$:$$$B$~yy?$%D$$$%&% %p %qW#%r% %&'#%- %&'%~%%D%$%%&%&p &q-&W#&r' %&&$.&r"Z&:&$&B&~&%D&$&%'%'p 'q.'W#'r% %''$.'r&Z':'$'B'~'%D'$'%*% (p (qW#(r@ ( %),#(ffffff!@  %),(~$I$I?((%D($(%)%)p )q)W#)r? ) %))$.)r@ (Z):)$)B)~0 0 ?()%$)~ )?$)$)%*%*p *q$*W#*r, %**$.*r'Z*:*$*B*~*%D*$*%+%+p +q+W#+r@ + %++$.+r@ )Z+:+$+B+~yy?(+% +~ +?+ ~ +?$+$+%,%%,p ,q',W#,r( %,,$.,r*Z,:,$,BF,~$,%.% -p -qW#-r- %.1#-B@+ %.1-~I$I$?-%--L LDD-$-%.%.p .q.W#.r/ %..$..rB@,Z.:.$.B.~I$I$?.%-D.$.%/% /pqW#/r0 %//$./r.Z/:/$/B/~/%-D/$/%0% 0pqW#0r1 %00$.0r/Z0:0$0B0~0%-D0$0%1%1p 1q1W#1r- %11$.1r0Z1:1$1B1~1%-D1$1%3% 2p 2qW#2r2 %34#2fffffv@% %342~y$@2%-D2$2%3%3p 3q3W3r433R -!.3rfffffv@1Z3:3$3B3~y$@3%-D3$3%4% 4pq~ 4W4r23.4r3Z4:4$4B4~4%-D4$4%5% 5p* 5qW5r535X555S LL5~5%-D5$5%6% 6pqW6r636X656~6%-D6$6%7% 7pqW7r737X757~7%-D7$7%87%7V%% LA&LB% 8pqW8r838X858~8%-D8$8%97% 9pqW9r939X959~9%-D9$9%:7% :pqW:r:3:X:5:~:%-D:$:%;7% ;pqW;r;3;X;5;~;%-D;$;%<7% <pqW<r<3<X<5<~<%-D<$<%=7% =pqW=r=3=X=5=~=%-D=$=%>7% >pqW>r>3>X>5>~>%-D>$>%?7% ?pqW?r?3?X?5?~?%-D?$?%@7%D l-@&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&[&\&]&^&_& @pqW@r@3@X@5@~@%-D@$@%A7% ApqWArA3AXA5A~A%-DA$A%B7% BpqWBrB3BXB5B~B%-DB$B%C7% CpqWCrC3CXC5C~C%-DC$C%D7% DpqWDrD3DXD5D~D%-DD$D%E7% EpqWErE3EXE5E~E%-DE$E%F7% FpqWFrF3FXF5F~F%-DF$F%G7% GpqWGrG3GXG5G~G%-DG$G%H7% HpqWHrH3HXH5H~H%-DH$H%I7% IpqWIrI3IXI5I~I%-DI$I%J7% JpqWJrJ3JXJ5J~J%-DJ$J%K7% KpqWKrK3KXK5K~K%-DK$K%L7% LpqWLrL3LXL5L~L%-DL$L%M7% MpqWMrM3MXM5M~M%MMkLDDM$M%N7% NpqWNrN3NXN5N~N%MDN$N%O7% OpqWOrO3OXO5O~O%MDO$O%P7% PpqWPrP3PXP5P~P%MDP$P%Q7% QpqWQrQ3QXQ5Q~Q%MDQ$Q%R7% RpqWRrR3RXR5R~R%MDR$R%S7% SpqWSrSSSk -!SXS5S~S%MDS$S%T7% TpqWTrTSTXTTTk LLT~T%MDT$T%U7% UpqWUrUSUXUTU~U%MDU$U%V7% VpqWVrVSVXVTV~V%MDV$V%W7% WpqWWrWSWXWTW~W%MDW$W%XW%Wj%%LA&LB% XpqWXrXSXXXTX~X%MDX$X%YW% YpqWYrYSYXYTY~Y%MDY$Y%ZW% ZpqWZrZSZXZTZ~Z%MDZ$Z%[W% [pqW[r[S[X[T[~[%MD[$[%\W% \pqW\r\S\X\T\~\%MD\$\%]W% ]pqW]r]S]X]T]~]%MD]$]%^W% ^pqW^r^S^X^T^~^%MD^$^%_W% _pqW_r_S_X_T_~_%MD_$_%`W%Dul`&a&b&c&d&e&f&g&h&i&j&k&l& `pqW`r`S`X`T`~`%MD`$`%aW% apqWaraSaXaTa~a%MDa$a%bW% bpqWbrbSbXbTb~b%MDb$b%cW% cpqWcrcScXcTc~c%MDc$c%dW% dpqWdrdSdXdTd~d%MDd$d%eW% epqWereSeXeTe~e%MDe$e%fW% fpqWfrfSfXfTf~f%MDf$f%gW% gpqWgrgSgXgTg~g%MDg$g%hW% hpqWhrhShXhTh~h%MDh$h%iW% ipqWiriSiXiTi~i%MDi$i%jW% jpqWjrjSjXjTj~j%MDj$j%kW% kkkSkkTkl MFk%DlHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH$  "Hk H<<T$(  T T  fS@Y-  ?8PS "`;:C],`@Y-8/ <-9 < Add sheet Ctrl+b< yP'>(@A 2 7$$$;4$$  T  l@ @l@ B%;$$$  Tl@ l@ B%$$;4$$  T l@l@B$;$$$  T l@ @l@ B%&; l@ l@ B%$$;4$ l@ B%  T FeL@BR;$$ l@ B%  T l@ @l@ B%&; l@ l@ B%jj ; L";  ,%lB$$$; ;  j$j$ ;4j$B$B%  T L;$j$B$B%  Tl@ @l@ B%3#;  l@ @l@ @,%B%/  %$A Monat eingeben: FormatMM.JJJJ% Tabelle29ggD   m,l  dMbP?_*+%M\\ps01\p0000539_hpclj3800_psS 4dXXA4PRIV0'''' P4(^>7 SMTJHP Universal Printing PSHPDocUISUITrueESPRITSupportedTrueHPOrientationHPOrientationPortraitHPOrientRotate180FalsePostScriptCustomPageSizeFalseDuplexDuplexNoTumbleHPReverseOrderForFold_StitchTrueHPBestGlossDefaultInputSlot*UseFormTrayTableHPDuplicateJobNameOverrideSWFWPageSizeA4PageRegionLeadingEdgeMediaTypePLAINHPMediaTypeTreeviewPopupTrueCollateTrueJCLHPPrintOnBothSidesManuallyFalseJCLEconomodeFalseOutputBinAutoStapleLocationNoneTextAsBlackFalseAlternateLetterHeadFalseJCLResolution600dpiJCLFastResNoneHPConsumerCustomPaperTruePrintQualityGroupPQGroup_1JRHDInstalledJRHDOffHPNUseDiffFirstPageChoiceTrueHPPageExceptionsFileHPCPE083HPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsCoverInsertionHPEnableRAWSpoolingTrueHPDocPropResourceDataHPCabFileNameRGBColorDefault-sRGBCMYKInksDefaultCMYK+JRConstraintsJRCHDFullHPColorSmartAutomaticHPColorSmart_ColorOptions_EdgeControlNormalHPColorSmart_ColorOptions_HalftoneDetailHPColorModeCOLOR_MODEHPColorSmart_Text_NeutralGraysBlackOnlyHPColorSmart_Text_HalftoneDetailHPColorSmart_Graphics_NeutralGraysBlackOnlyHPColorSmart_Graphics_HalftoneDetailHPColorSmart_Photo_NeutralGrays4-ColorHPColorSmart_Photo_HalftoneDetailHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_GROUPNAMEHPBornOnDateHPBODHPJobAccWoPinTrueHPXMLFileUsedhpcu083s.xmlPSAlignmentFileHPCLS083HPSmartHubInet_SID_263_BID_514_HID_265HPColorAsGrayFalseIUPHxAkA1HixK.z, AԊݝЪkR1`<`[%Mx~~#xU?7d&鶹Tuox;o3o&'@µpq)ʸ4-^ZȦse̢+o OƙϢWx6 x-dǾ;"^H׊h4Zj{:PpοgީPSԨ =`>asT3e:sZxOI慌&!o$̟U!…?}j=Femtz5>%oħc{ƾ4`i˴!ds $ZQq'GJxƼc_&'i;kjcI_d,o}ނf^\>Q|ynR7~;Z+k M   %pK" dXX<~?<~?cU } } } } } F} } C} } E} F} $} %% m&& &Z@ &@&;@ &;@&;@&;@&;@&;@ &;@ &;@  &;@ &; &;@& &;@&& & &5@ &h&@&&&&&&&&&&$?@@@@@@ @"@$@&@(@*@,@.@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@@@@@A@A@B@B@%~ L`@    sz@2$(L@L@BF BM@M?  M@  M@  M@  M@  M@M@M?M@M@M@M@M@M@M?M@M@M@M@M@M@M?M@M@  M@!!M@""M@##M@$$N? %I~ O@y,e`@DAEDADAAKf@5D@9$B  D@ BKf@ 5D@9$B  D@ BK f@ 5D@9$B  D@ BK f@ 5D @9$B  D @ BK f@ 5D @9$B  D @ BK f @ 5D @9$B  D @ BK f@@5D @9$B  D @ BKf`@5D @9$B  D @ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf @5D@9$B  D@ BKf@@5D@9$B  D@ BKf`@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf@5D@9$B  D@ BKf @5D@9$B  D@ BKf@@5D@9$B  D@ BKf`@5D@9$B  D@ BKf@ 5D@9$B  D@ BK f@!5D@9$B  D@ BK!f@"5D @9$B  D @ BK"f@#5D!@9$B  D!@ BK#f@$5D"@9$B  D"@ BK$g @%5D#@9$B  D#@ BK%B4 5D$@9$B  D$@ B i!~ 9@!8@) DD)?%$D~  @< $ ]"#RQ@  %$!AA?  DD  ~  ^@ $e@Y@@s@@ $@@@q@@ @}@  !~ "@ #$ PB^^xt ??! "$ PL__tt$ PB__tt UUUUUU?!UUUUUU? "$ ]B  UUUUUU? !? "$ j kkuu  @@@@@@@  @Ё@ ~ v@ ~ @  @@  !$ i o! `@  D D # `@ % $ $ @@@@@ $ @@@@@ $ @@@@@ $ @@@@@" #$  ?  4 )D %  B?  4 )D %  B? G 4 )D %  B? zG@ )D %   B? zG*@ )D %   B? )\(4@ )D %   B? zG:@ )D %   B? @@ )D %   B? G4 )D %  B? (4 )D %  B? )\(D@ )D %  B? QG@ )D %  B? zGJ@ )D %  B? = ףp=N@ )D %  B? P@ )D %  B? 4 )D %  B? G4 )D %  B? {GzR@ )D %  B? )\(T@ )D %  B? ףp= U@ )D %  B? QW@ )D %  B? 333333Y@ )D %  B?  4 )D %  B?  $4 )D %  B? zGZ@ )D %  B? (\\@ )D %  B? = ףp=^@ !)D %   B? !Q_@ ")D !% ! B? "`@ #)D "% " B? #G(4 $)D #% # B? $,4 )D $% $ B Q `! O@ D D # O@ % $   d $ZLAGLAGLAGLAGLAHLAHLAHLAH<AL  #        333333@   333333@   333333@   @         @   @       @                     @               @   @ !  !"@ "  "   # $  $  %G ?04)D %  B?44)D %  B?f84 )D %  B? f<4 )D %   B? 333333@ )D %   B? 333333+@ )D %   B? ffffff4@ )D %   B? fffff9@)D %   B?@4)D %  B?D4)D %  B?fffff>@)D %  B?LB@)D %  B?3H4)D %  B?D@)D %  B?L4)D %  B?P4)D %  B?fT4)D %  B?fX4)D %  B?\4)D %  B?`4)D %  B?F@)D %  B?d4)D %  B?h4)D %  B?l4)D %  B?(p4)D %  B?G@ )D %  B? J@!)D %   B?!O@")D !% ! B?"t4#)D "% " B?#x4$)D #% # B?$|4)D $% $ B l~ mĩ!nGz.> DD#vhfffff@ %$v"$LLLL     Gz?  Gz?  Gz?    Q?!!> ףp=@#"#$$ ? 4)D% B? 4)D% B? 4 )D% B? z4 )D %  B? Gz? )D %  B? Gz? )D %  B? Q? )D %  B? 4)D %  B?ה4)D% B?4)D% B?4)D% B? 4)D% B?Q4)D% B?4)D% B?Q4)D% B?4)D% B? 4)D% B?Q4)D% B?Q4)D% B?\4)D% B?4)D% B?Q4)D% B?4)D% B? 4)D% B?4)D% B?Q4 )D% B? p= ף?!)D %  B?!hfffff@")D!%! B?"4#)D"%" B?#4$)D#%# B?$4)D$%$ BDDDDD{$ LDD  D  D  D  D  DDDDDDDDDDDDDDDDDDD  D!!D""D##D$$DRJJVJ | K K  K  K  K  K  K K K&2KKKKKKKKKKKKKKKKKKKKSD%abbww } T T  T  T  T  T  T T T h T T& T T& T T T& T& T& T T& T T T& T  T !T "T& #T $U /~ )D%$B$Y Z [ \ \, \$L @-Vcc  c  c  c  c  ccccccccccccccccccc  c!!c""c##c$$d p qW#rffffff"@ %#`s@% %~=@~$I$I? ~  ? ~ p@,$%%%p q%W#r %$~ Xf@~۶m۶m@D$%%% p# qW#r333333@# %#YL@ %~?D$%%%p q.W#r@ %$~ Xµ@~ba? ~  @4$%%% pqW#r %$!X DD~D$%%% pqW#r %$!X DD~(D$%%%p q(W#r333333@ %$~ X?~yy? ~  f@ ~ @,$% %%DNlC Pz^N==Y=2  &!&"&#&$&%&&&'&(&)&*&+&,&-&.&/&0&1&2&3&4&5&6&7&8&9&:&;&<&=&>&?& p+ qW# r8@0 %!$~ H@ ~$I$I?*D $ %!%%!p !q.!W#!r8@# %!!$~ !XH@!~$I$I? ! ! @@ @@@ !~ !@.!$!%"%% "pqW#"r" %""$!"X0% D"D""~!D"$"%#%% #pqW##r$ %##$!#X# D#D##~"D#$#%$%%$p $q($W#$r  %$$$~ $X?$~yy?D$$$%%%% %p %qW#%r' %&'~ %d@%~m۶m?4D%$%%&%%&p &q-&W#&r' %&&$&X&&&+ LL&~%D&$&%'%%'p 'q.'W#'r% %''$'X'&'~&D'$'%(%% (p (qW#(r@& %),(X@(&(~yy?)D($(%)%%)p )q)W#)r?) %))$)X?"&)~yy?*) ~ ) ?8) $)%*%%*p *q$*W#*r+ %**$*X*&*~+D*$*%+%%+p +q+W#+r@, %++$+X@+&+~?- +~ +@j@(+$+%,%%,p ,q',W#,r( %,,$H,X~$,%-%% -p -qW#-r2@ %.1-X2@---K LL-~I$I$?.--KLDD-$-%.%%.p .q.W#.r2@/ %..$.X2@.-.~I$I$?/-8..@@"@! ."$.%/%% /pqW#/r1 %//$/r/-/~1-D/$/%!% 0pqW#0r0 %00$!0r0 D0D00~$-D0$0%1%%1p 1q1W#1r- %11$1r1-1~3-D1$1%2%% 2p 2qW#2r2 %342r2-2~3-D2$2%3%%3p 3q3W3r233Q -!~ 3X5@3~y$@5-D3$3%4%% 4pq~ 4W4r434X4-4~.-D4$4%5%% 5p* 5qW5r535X5-5~6-D5$5%6%% 6pqW6r636X6-6~7-D6$6%7%% 7pqW7r737X7-7~8-D7$7%8%% 8pqW8r838X8-8~9-D8$8%9%% 9pqW9r939X9-9~:-D9$9%:%% :pqW:r:3:X:-:~;-D:$:%;%% ;pqW;r;3;X;-;~<-D;$;%<%% <pqW<r<3<X<-<~=-D<$<%=%% =pqW=r=3=X=-=~>-D=$=%>%% >pqW>r>3>X>->~?-D>$>%?%% ?pqW?r?3?X?-?~@-D?$?%@%%D&l@&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&[&\&]&^&_& @pqW@r@3@X@-@~A-D@$@%A%% ApqWArA3AXA-A~B-DA$A%B%% BpqWBrB3BXB-B~C-DB$B%C%% CpqWCrC3CXC-C~D-DC$C%D%% DpqWDrD3DXD-D~E-DD$D%E%% EpqWErE3EXE-E~F-DE$E%F%% FpqWFrF3FXF-F~G-DF$F%G%% GpqWGrG3GXG-G~H-DG$G%H%% HpqWHrH3HXH-H~I-DH$H%I%% IpqWIrI3IXI-I~J-DI$I%J%% JpqWJrJ3JXJ-J~K-DJ$J%K%% KpqWKrK3KXK-K~L-DK$K%L%% LpqWLrL3LXLLLk LLL~MLLk LDDL$L%M%% MpqWMrM3MXMLM~NLDM$M%N%% NpqWNrN3NXNLN~OLDN$N%O%% OpqWOrO3OXOLO~PLDO$O%P%% PpqWPrP3PXPLP~QLDP$P%Q%% QpqWQrQ3QXQLQ~RLDQ$Q%R%% RpqWRrRRRk -!RXRLR~SLDR$R%S%% SpqWSrSRSXSLS~TLDS$S%T%% TpqWTrTRTXTLT~ULDT$T%U%% UpqWUrURUXULU~VLDU$U%V%% VpqWVrVRVXVLV~WLDV$V%W%% WpqWWrWRWXWLW~XLDW$W%X%% XpqWXrXRXXXLX~YLDX$X%Y%% YpqWYrYRYXYLY~ZLDY$Y%Z%% ZpqWZrZRZXZLZ~[LDZ$Z%[%% [pqW[r[R[X[L[~\LD[$[%\%% \pqW\r\R\X\L\~]LD\$\%]%% ]pqW]r]R]X]L]~^LD]$]%^%% ^pqW^r^R^X^L^~_LD^$^%_%% _pqW_r_R_X_L_~`LD_$_%`%_%_j%% LA&LB%Dul `&a&b&c&d&e&f&g&h&i&j&k&l& `pqW`r`R`X`L`~aLD`$`%a%_% apqWaraRaXaLa~bLDa$a%b%_% bpqWbrbRbXbLb~cLDb$b%c%_% cpqWcrcRcXcLc~dLDc$c%d%_% dpqWdrdRdXdLd~eLDd$d%e%_% epqWereReXeLe~fLDe$e%f%_% fpqWfrfRfXfLf~gLDf$f%g%_% gpqWgrgRgXgLg~hLDg$g%h%_% hpqWhrhRhXhLh~iLDh$h%i%_% ipqWiriRiXiLi~jLDi$i%j%_% jpqWjrjRjXjLj~kLDj$j%_% kkkRkkLk LFk%DlHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH$  H "H<<  4$(  4 4  fSdC%  ?8PS "`;:C],`dC% 3 B%9 < Add sheet Ctrl+b< yP'>(@A 2 7$$$;4$$  4  l@ @l@ B%;$$$  4l@ l@ B%$$;4$$  4 l@l@B$;$$$  4 l@ @l@ B%&; l@ l@ B%$$;4$ l@ B%  4 FeL@BR;$$ l@ B%  4 l@ @l@ B%&; l@ l@ B%jj ; L";  ,%lB$$$; ;  j$j$ ;4j$B$B%  4 L;$j$B$B%  4l@ @l@ B%3#;  l@ @l@ @,%B%/  %$A Monat eingeben: FormatMM.JJJJ% Tabelle28ggD Modul1DieseArbeitsmappe$0__SRP_3 | __SRP_21  !"#$%&'()*+,-./02346789:;<=>?@ABCDEFGHIKLMNPRSTUVWXYZ[\]^_`bcdefghijkmnopqrstuvxyz{|}~$+jxMExp M x!Attribute VB_Name = "Modul1" rU (  A q  Y 1 1 y Q  1 Y A 0 *P*(.6,@ 8p0.0.8 h BB 8 X 2p H* D BhDD .@&p&& ,  "  ( H P h      & ((  P p +  /    7B.0H ,&M#D l,:I%uHF*DdLNx%*VɵC, CVx*DdLNx%* l,:I%uHME([LSS>"*L<,<0<4<8<<<N0{00020819-0000-0000-C000-000000000046}0bBb"PBb$Bb( BB,B B.0B B2XB B6@$BB8BB< Bb@BBBBBF BBJ0BBL BBPH BBT BBVp BBZ B B^ %B"B` B#Bd B%BhB'Bj B(Bn8 B*BrB,Bt` B-Bx B/B|H1B~H2 A : Arbeit %  ` kTWW/@l @\ `,Z`T`L@< @x, @ ``HH  ` Fr : Freidf@  @  @H  `8%BBBXBb (Bb&xBb* BB0B B4B B:h$Bb>BBDBBH BBNXBBRBBXBB\ B!BbHdB$BfpB&BlB)BpB+Bv8B.Bz`B0(xh@p h P0XH p0 XH 8 `  ` 8@@  %@` @x @ %X@ @ @ @x 8 `P Vtv|z~h@`  60@ $er@ t .day@ d M @ T "@xD peOf@ 4 : @$ orki@ (0 jprlnXZ\@ `|z8J ^`btC@@ @ @ @ @ @ 2' a@$ e I@ #5@rlnXZ\p `CPJ2:bants r p !@ @ + 7@ "]rI &'H 3h88 HXTO M $*\Rffff*0n4c274d66*\R1*#74*\R0*#f*\R0*#12*\R1*#1c8*\R1*#e8*\R1*#2ac</ .P>  =     0 $Q@ 8h  :   :       :  0 D8  7 " :  7  ( @ *PH *Px  (   08   0 ` x]hX]( Row of first day of the month]( Column of days of month](( Column of days of week]P( Column of type of day]H( Column of the types list] Hx(! Column of working hours in a day] ( Column of the Soll column](& Position of the end of month switches]0( Calculation Columns]X) Month input cell]$@( Cumulated vacations]$ h( Cumulated shifts]( Work days]( Free days]    h Input Range]  0   Xh Input Range Constants for Version 2]H ]( Column of first day of the month]p V X  Z h Input range] d W Input range 2]H ((Cell with date of first day of the month]p(%Cell with vacations of previous month] ('Cell with shift hours of previous month]8 ((Cell with sicknes days of previous month](Row of flags for valid days]` (Row for day of week]8(Row for day of month] (Row for kind of day] A : Arbeit` Fr : FreitP On Error GoTo Terminate Blank Makro Key short: Strg+b Cell's Rows and Columns]H`x]]] B@Windows(1).Width = WindowSizeX2!Windows(1).Height = WindowSitzeY2 Initialise Variables !' B@ Create new sheet  B@ B@ Set new month d f$B@H  d f$!9m5$9q' Rename new sheet with the actual month d f$!' $' $' $   ( Set default values V'  ',*Set defaults for kind of day (working ...) t $!  , b v $!  v $!  | z $(d@ ~ z $(k   '  , b z $(  '= Report cumulated vacation days, shift hours and siknes hours=' '!D5'  h j$(=' '!D6'  p r$(=' '!D16'  l n$( Clear input range  X Z7 \ ^77( ` Z7 b ^77(qP X Z$ X Z$$B@H Protect Sheet  B@  (o CreateNewMonth2() oAttribute VB_Name = "DieseArbeitsmappe" " Bas0{00020819-0C$ 0046} |GlobalSpacIFalse dCreatablPredeclaIdTru BExposeTemplate`DerivBustomizD2Option /licit Const WindowSizeXH950, tzeY 600Day0_I As Integ$er2 ' Row of fDir.daythe monthÇ;%sOfM '3'' Column #s".aWeekU$w 3TypeOf 4G4It@ # Li: 18F As l WorkingHours WwC h in a GSollߌS$#B cZgEnd^w172 ' Posi”#{wendFh switches%RestC22, RightCalcJ%u @~Shee tD@= 1,F & ' cIinput cel"leVac36l, #6`umA`jvacaEhiShi9shift`ρ;L2i2' a8FFreeRae InToppLeftZu,@u#5!Bot`0 + 3LIn11'À +Rang pCP3, CP2: 6ants for VersF2GX2Y15!8A'F!&_'@ݛb1C+.2 $1&+ 7dolIn31u"I"]rI1ea24 100$&' +gq:Sch'C@p hTXH so&C @fH V:!Gprevious%f:01?b;4U rSick 0n 1)s < 7) Thenc 1c$`=Q7ElaU = D`B End If DayC ol = @+ 1tLoop$Do While (R<v)>Cells(KindRow,).Value|""*Dw3' Report cumulated vacation days, shift h@ours as`iknesCC:VsI='" & OldSheet"'!D5Thj|l,8 ;Sick9~6 975 s0 551 A ?CAA' Clear input rangeWith ActiveUC)$.RA (.CVInTopBInLe$ft, BotRighBSS2, B?1.C0/).SelectCC@' Prot JN.Draw@ingObj s:=False, ContentTruSce nario _^Allow@Insert@ Hyperlink?/$En0ablep= xlNoRestdri?onEA(SHub Dre`vNewMh2(      $" !#4*&'()3,-./012%6:789C<=>?@AB5) #< a ,! 8! 8W<+c%c%c%! 8 /! 8Qo%! 85! 87(%(% $ X  5 $ ( QB(%(% $ X A %,6.a9 ,6c>(%(% $ X A OtL6LM@ \LM@ `1T5=\" #*#lT*F%! 825 (ll(UpZ5Q(%l @ $ X At lkZD]c'd6t(%l @ $ X A (]pt(%l @ $ X dA4 (D]c$')6d4T::%(%l @ $ X C 5::%(%l @ $ X C 5l(l9lkZD]g ::%(%l @ $ X C 5l(l:<:,57,(%(% $ X C 5":<:`16:lF%(%(% $ X C 5:<:57(%(% $ X C 5! 8QP:%(%(%%( %(T%%%tC 6tP:%(%(%%(d%(T%%%tC 6tc(%(% $ X (%(T% $ X  $ )68f%c%c%cT%c%! 8%! 8H0 T,\<l< td4$XrU H$`U3(9 n|L/F#<tsNu( F5JxTabelle28 5+__SRP_18J,__SRP_19OgKlasse1Q5JtsNu(ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(% ` H0 %& % 00x@LHp M $*\Rffff*0f4cd154f94 " 0ophհAttribute VB_Name = "Tabelle28" " Bas0{00020820v-C$0046} |GlobalSpacAFalse dCreatablPredeclaIdTru B@ExposeTemplateD0eriv$Bus`tomizD2 P Sub Image1_Click() @ End rU  I9q40 0  XrU @$`Hn/@%xME (SS S<N0{FCFB3D2A-A0FA-1068-A738-08002B3371B5}H(%H0(xAttribute VB_Name = "Klasse1" Basx0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobalSpac False dCr@eatablPredecla IdCExposeTemplateDeriv%Customiz E$+ךxMExpModul2 aModul3lModul4 w__SRP_4T M x!Attribute VB_Name = "Modul2" $+xMExp M x!Attribute VB_Name = "Modul3" 2>exME(6 << < `@x -Makro am 13.05.2009 von taernst aufgezeichnet 14p%X M $*\Rffff*0s4bb1cc9c "   4( ` h*p  Makro1 Makro. Makro am 13.05.2009 von taernst aufgezeichnet B@of day  (oH@>Attribute VB_Name = "Modul4" Sub Makro1() L.DescriptionrX am 13.05.2 009 v4taernst aufgezeichnetPro cData^Invoke_FunBc^ \n1' '%{0  ActiveSheet.?tect DrawingObjs:=True, ContentScenario _ (, AllowInsert$8Row :EnableSel5xlNoRes΀Mons End rU~| krU $`n* xME__SRP_5oModul5__SRP_d__SRP_co(6 << <80% `x -Makro am 31.08.2009 von taernst aufgezeichnet 14@88 M $*\Rffff*0y4c274d90 "   40 h p x*8op Makro2 Makro. Makro am 31.08.2009 von taernst aufgezeichnet B@x  B@@4Attribute VB_Name = "Modul5" Sub Makro2() L.DescriptionrX am 31.08.2 009 v4taernst aufgezeichnetPro cData^Invoke_Func^ \n146' '%{)0  ActiveSheet.Unprotect L DrawingObjs:=False, Co ntentTruScenario _&(AllowInsert%Hype rlink End rU~|  0 8  krU $ `!nModul6< __SRP_16^__SRP_17Tabelle29+xME(6 << <H 14 0%  `x-Makro am 10.12.2009 von taernst aufgezeichnet;@ 14  `8-Makro am 10.12.2009 von taernst aufgezeichnet8 M $*\Rffff*0s4caf1f02"   48 p x    "  0 8 4X  (88op Insert_ProJectLine Makro. Makro am 10.12.2009 von taernst aufgezeichnetum29:29$B@H  B@28:28$B@H B@A29$B@Hs\ B@n F ( B@o Insert_ProjLine Makropsw. Makro am 10.12.2009 von taernst aufgezeichnet29:29$B@H  B@A28$B@H " %B@H $ %B@HA28$B@HHAttribute VB_Name = "Modul6" Sub Insert_ProJectLine() >.Descriptionakro am 10.12.2009 v4taernst aufgezeichnetx^cDatajInvok@e_Funcj \n14B' ' M%)  Rows("29:29").Sel\ z. Shift:=x`lDown8:28Copyange("A5ActiveSheet.PasteApplica.Cut$ÀFalsSClearContents End @}~j}?}Ҕo|{{pW{@](xlToR0ight Le:fRQ CrrU~| frU $`$`n|L׆o#<C`ޙD\ Fm{'9Eҳ)xm{'9Eҳ)C`ޙD\ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(% ` H0 %* % 00x@LHp M $*\Rffff*0t4cf77fe24 " 0ophհAttribute VB_Name = "Tabelle29" " Bas0{00020820v-C$0046} |GlobalSpacAFalse dCreatablPredeclaIdTru B@ExposeTemplateD0eriv$Bus`tomizD2 P Sub Image1_Click() @ End rU @__SRP_6,__SRP_7g_VBA_PROJECT+dir940 0  XrU @$`Hn 0* pHd VBAProject4@j = r  M J< rstdole>stdole h%^*\G     "#$&'()+]TypeList2 WorkingHours2QSollEndColwRestCol1 RightCalc8 SheetDateRow SheetDateColvVacRow!VacColShiRowvShiColO&WorkTypeFreeType[X InTopLeftRow InTopLeftColpCInBottomRightRow~InBottomRightCol. CPTopLeftRow CPTopLeftCol9CPBottomRightRow.CPBottomRightColj WindowSizeX2 WindowSitzeY2ʖ FirstDayCol1InTopRow; InLeftColiInBotRowV InRightColz InTopRow2 InBotRow2DateRowDateColB VacationRowV/ VacationColTShiftRowShiftColoSickRowSickCol DayFlagRow[ WeekDayRownDayRowhKindRowWorkDayT^FreeDayBlankL(CreateNewMonth2z DayColMonth_Year_Date_2OldSheet(CumulateVacationsgCumulateShiftshY CumulateSicksX ActiveSheet%N Unprotect?ProtectfDrawingObjectsߺContents= ScenarioskCopyƿBeforeCells ActiveCellValueKDateAdd/6MonthYear6n MonthNameHRange AllowInsertingRowsHwEnableSelectionahxlNoRestrictionsXCreateNewMonth@Day_I; FreeDay_S WorkDay_SwcYear_S2Date_D`WindowsdHeight|Month_IDay_I; Tabelle15 Image1_ClickKlasse1AModul2Modul3 Tabelle16 Tabelle17 Tabelle19 Tabelle200Modul4Makro1C| Tabelle211Workbookk Worksheet_Defaultj Tabelle222 Tabelle211 Tabelle233 Tabelle221  Tabelle244 Tabelle231.Modul5Makro2D|AllowInsertingHyperlinks 9 Tabelle255 Tabelle241S Tabelle266 Tabelle251x Tabelle277 Tabelle261Modul6Insert_ProJectLinezRowsU SelectionZInsertrShiftxlDown0DPaste Application* CutCopyMode ClearContents{Insert_ProjLineCT xlToRight|xlToLeftWY Tabelle288 Tabelle271» Tabelle299 Tabelle281 Tabelle30U Tabelle291       '+  0Rp{00020430-C 0046}#2.0#0#C:\WINDOWS\syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5ETAAC42Ec:\gramme\Gemeinsame Dateien\Microsoft Shared\OFFICE11\MSO.DLL#N 11.0 Ob LibraryLMSForms>SFrms3D452EE1-E08F0A-8-02608C4D0BB40SFM20L'B @`&/;"~1kqAq00}#0q# h0@E181D9E2-D416-4254-AFB2-51BDBD7EF 23_DOKUME~1\taernst\LOKALTemp\Excel8.0@[/.exdH\4".E .`ay  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Programme\Gemeinsame Dateien\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.5#0#C:\Programme\Microsoft Office\OFFICE11\EXCEL.EXE#Microsoft Excel 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation,*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.3#0#c:\Programme\Gemeinsame Dateien\Microsoft Shared\OFFICE11\MSO.DLL#Microsoft Office 11.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#c:\WINDOWS\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{E181D9E2-D416-4254-AFB2-51BDBD7EF232}#2.0#0#C:\DOKUME~1\taernst\LOKALE~1\Temp\Excel8.0\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M    M   Modul10c4ba5eb19 Modul1j"DieseArbeitsmappe0n4c274d66"DieseArbeitsmappeM&Tabelle280f4cd154f9'Tabelle28/F8RKlasse10g4c57fbf2Klasse1@%H5 Modul20g4ba5eb19 Modul2` Modul30h4ba5eb19 Modul3x Modul40s4bb1cc9c Modul4>e Modul50y4c274d90 Modul5 h Modul60s4caf1f02  Modul6Tabelle290t4cf77fe2+Tabelle29o0Rpx`0H8hL~CV:/Z؞DMPCVUNE@ CN|F%"TKe 5 5 5 5 6 6 6 6 fLmU `9ݳe9e902Po2+rU~~{ __SRP_0;___SRP_1iPROJECTwm  PROJECTTabelle29 Tabelle2812B-qH3 MөO A *` ;TO:)XtpmB#~Oc Tabelle30> LT~ȭSA".D-ZDSܷi3jK}Ld/ iy\,ANYf'oa@N23C`ޙD\m{'9Eҳ) Tabelle291>ytBH2xrUxxMAєW a Q  e          -Makro am 13.05.2009 von taernst aufgezeichnet 14  -Makro am 31.08.2009 von taernst aufgezeichnet -Makro am 10.12.2009 von taernst aufgezeichnetBModul1Modul1DieseArbeitsmappeDieseArbeitsmappeKlasse1Klasse1Modul2Modul2Modul3Modul3Modul4Modul4Modul5Modul5Modul6Modul6Tabelle28Tabelle28Tabelle29Tabelle29 Tabelle17 Tabelle19 Tabelle20ID="{615CBFF6-9D90-44F1-B4F6-7FF0A58CDE23}" Module=Modul1 Document=DieseArbeitsmappe/&H00000000 Class=Klasse1 Module=Modul2 Module=Modul3 Module=Modul4 Module=Modul5 Module=Modul6 Document=Tabelle28/&H00000000 Document=Tabelle29/&H00000000 HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="66647EE2821E2422242224222422" DPB="04061C80241F251F251F" GC="A2A0BA2659275927A6" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 &H00000002={00020818-0000-0000-C000-000000000046};Excel8.0;&H00000000 [Workspace] Modul1=-64, 164, 954, 579, C DieseArbeitsmappe=32, 15, 1284, 888, C Klasse1=176, 232, 937, 996, C Modul2=146, 167, 942, 823, C Modul3=144, 260, 1282, 1024, C Modul4=132, 174, 1391, 762, C Modul5=-73, 113, 1186, 701, C Modul6=0, 0, 0, 0, C Tabelle28=0, 0, 0, 0, C Tabelle29=0, 0, 0, 0, C  aFOh+'0@HXh taernsttaernstMicrosoft Excel@wg@ï Unprotect՜.+,0 PXd lt| FHZ' SummaryInformation(!!DocumentSummaryInformation8% CompObj*pK*y   rU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~L p.PN`Dh,  a Q  e  Qi  q a qY  e iqy VBAProjectModul1DieseArbeitsmappe Tabelle15Klasse1Modul2Modul3 Tabelle16 Tabelle17 Tabelle19 Tabelle20Modul4 Tabelle21 A : Arbeit Fr : FreiF /C:\PROGRA~1\GEMEIN~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  Y`FCopy 0C:\Programme\Microsoft Office\OFFICE11\EXCEL.EXEExcel  yp0FC:\WINDOWS\system32\stdole2.tlbstdole YL-[DRAC:\Programme\Gemeinsame Dateien\Microsoft Shared\OFFICE11\MSO.DLLOffice .E .`M C:\WINDOWS\system32\FM20.DLLMSForms aفTBQ~26C:\DOKUME~1\taernst\LOKALE~1\Temp\Excel8.0\MSForms.exd  aFLprHpHFWC[ȅvh7r% DVt_ DFWorkbookCreateNewMonth2CreateNewMonthBlank HMakro1 UnprotectNameDrawingObjectsContentsScenariosProtect BeforeFF 1  Select Value m    =' '!D5 '!D6 '!D16 Cells Range $AllowInsertingRowsEnableSelection VBE6.DLL  ! *DdLNx%*VɵC, CV ) (  HF-iq%E&jdds F6W#ʰ@Zr퐦WUNG.h)g Tabelle24 Tabelle231xisNOU~uP F&K l,:I%uHp^y`MY?O/gCloGtgModul5Makro2 0AllowInsertingHyperlinksA*HjHKB](6͊4PFI7Fu<4zMe0 Tabelle25 Tabelle241_i\CP3V>/XJ8FI@&&LcB|(zAnKwgz^ Tabelle26 Tabelle251O/mKrN{*Uw6AHo9O^k Tabelle27 Tabelle261~6@=J+lZPA;*eyModul6Insert_ProJectLineInsert_ProjLine Tabelle28 Tabelle271tsNu(5J  Februar 2010 Januar 2010 Arbeitsbltter F$Microsoft Office Excel-ArbeitsblattBiff8Excel.Sheet.89q