ࡱ> }Root EntryRoot Entry FOFk~1CompObjfWorkbookW_K_VBA_PROJECT_CUR":OFk0HOFkV  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJLMNOPQRSTUXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|MSDigSig(Author)$K(SummaryInformation(dDocumentSummaryInformation8`%VBA :OFk0HOFk՜.+,D՜.+,D"" X`l t| :  WorksheetExample  WorksheetsA!!, !!0 *H 010 *H 0R +7D0B0 +7JY-<|&HSB0 0 *H k?64`똠x0500  *H 0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA0 960409093559Z 991231093558Z0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA00  *H 0ieRT(bTUDEJ;~Ȁ k)vsb<ulMԘisbN1 }GQod5}gwQ>wCʣA="HH0  *H 10o#&mvh*(K󉰙2[{ls$ D}xKO200$_)ȡXu9`EލW Ɲ6tk|ҥ*j~۩+"00)ъĽ5ǛSV0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.00  *H 0. h|,-.  WSu3* [4 Z%}XsjxqX)X^-bXq"X/6MJ;"V~!lJGj6 -Ӵ90  *H :>{թy=q#+(ߌe,ZbVkbEƢ5"r-| CMlX 5ʉp*}a qfbB="2"d$006C!FXF%`0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z01'0%U VeriSign Time Stamping Service10U VeriSign Trust Network1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.10U VeriSign, Inc.10UInternet00  *H 0aGܴ^i b1FI:?xZcEO n06- o' Q`5OTOз,B Ѝ^㖴"IBlӘV.:X"e匫xGBh[-}0  *H m`_i{p+b#D Q#tI'\q5+ൖ苧KsH ڋ %VNGWF8V!&;-%2Λ@GmGv0;~*1+ݰUApF-,~0 0 yfnжneq0  *H 0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA0 980416000000Z 990416235959Z0]10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA1F0DU =www.verisign.com/repository/CPS Incorp. by Ref.,LIAB.LTD(c)961>0<U 5Digital ID Class 3 - Microsoft Software Validation v21 0 UUS10U Washington10URedmond10UMicrosoft Corporation10U Microsoft Corporation0 0  *H  0&dm{AO o*q.S26h5IؖeS zpm̳*02X|k%gw #100u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H p0 +7 100 *H  1  +70 +7 10  +70 *H  1\;_ug0  *H O5(++׿aha ;_u}9UGOX.v1ۢ1hp= rhfԓz~v&$.Q f6)nި6j&RY:4WP!4 f}W.5Kqre.23$%U+MEYP uzc5|C]f"Ӳ&@EΊ-K`^cĥZTe^O%kbcRRw"7Y$ <&qtw`z!S0 *H  100010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.C!FXF%`0 *H Y0 *H  1  *H 0 *H  1 981201003122Z0 *H  13IKA4XVO0  *H J5DF<pl goXu?3D@}*@W&zh9S[YcJyA?h7ɒeO^z-3V>¥CERT ,Microsoft Corporation1#{l2e55d8fc-d4a1-11d1-b3af-00c04fa3493dAtalla Base Cryptographic Provider v1.0}~}+  0 0 yfnжneq0  *H 0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA0 980416000000Z 990416235959Z0]10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA1F0DU =www.verisign.com/repository/CPS Incorp. by Ref.,LIAB.LTD(c)961>0<U 5Digital ID Class 3 - Microsoft Software Validation v21 0 UUS10U Washington10URedmond10UMicrosoft Corporation10U Microsoft Corporation0 0  *H  0&dm{AO o*q.S26h5IؖeS zpm̳*02X|k%gw # 8@ _PID_HLINKSA0Imsbpz://-r:276DB11F/  http:///Mmsbpz://-r:276DB15B/Hmsbpz://-r:276DB1E7/Imsbpz://-r:276DB11F/  http:///Mmsbpz://-r:276DB15B/Hmsbpz://-r:276DB1E7/Oh+'0d X`| Break-Even AnalysisMicrosoft CorporationMicrosoft CorporationMicrosoft Excel@mMt@7)+@G|c[% 1&" WMFCC $Dd1[% EMFD @    !" !" !  " !  2'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 62% Ld11!??% #6#% Ld###!??% 161% Ld111!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw \lP@$0 \l|pd+%w0%    TT AA LP1   ( &% 6% Ld!??   TT (7AA (LP2U   %  6 % Ld   !??   TT :IAA :LP3   % :6:% Ld:::!??   TT KZAA KLP4   % K6K% LdKKK!??   TT \kAA \LP5nc   % \6\% Ld\\\!??   TT m|AA mLP6)   % m6m% Ldmmm!??   TT ~AA ~LP7n    % ~6~% Ld~~~!??   TT AA LP8   % 6% Ld!??   TT AA LP9Y    % 6% Ld!??   TT"AAL#PAEO    % 6% Ld!??   TTAALPBVe    % $6$% Ld$$$!??% % " !% %   2'%    Ld#9 )!??'% (  Ld#19#S)!??'% (  Ld9#9 !??'% (  Ld#91#9S!??RL Tahoma TahomaDhۍ0&" WMFC DWXw '\@$0 '\ 0%    T3 +8AA3 LMicrosoft Business Planner       RL Verdana VerdanaDhۍ0WXw (\@$0 (\0%  T2MYAA2MLhGo to Article:   RL  Verdana Ref Verdana Refw}!w`WXw .\@$0 .\3 0% T2^kAA2^!LCalculating Your Break-Even Point 1RL  Verdana VerdanaDhۍ0WXw *\@$0 *\ 0%   RL  Verdana VerdanaDhۍ0WXw \@$0 \ D0% %  % % % % " !% %   $2%   T3AA3LtBreak-Even Analysis      % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $2% % % % % % % % % % % % %   T21AA2fLEnter the relevant data from your profit and loss statement to calculate your break-even point (BEP).   T21AA2mL(Vary the size of the different inputs to analyse your BEP's sensitivity to rises or falls in sales or costs. T21AA2ELYou can customize the form by changing the row labels or adding rows.    T21AA2dLTo add a row, select one of the rows labelled "Other", click Insert on the Excel menu bar, and then     T21AA2eLclick Rows. The cells displaying zeroes or "#DIV/0!" contain formulae to perform the calculations on     T21AA2gLyour data. Do not type into these cells as you will erase the formulae in them. Click on the "Example"       Tt21AA21Ltab to see a completed version of this worksheet.  % % % " !% %   2% % " !% %   2' % (     ( &% % Ld!??l&WMFCD% % Ld#!??% % Ld1!??'%   ( &% #}63}% Ld#}1}#}!??% ( % " !%   2% " !%   2'%    ( &% 62% Ld12!??% 6% Ld!??% "   2  '' ' ,2-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-2- @ !1-##- @ !#-11- @ !1-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1R -- @ !  2 ( 2o -  - @ !   2 : 3R -::- @ !:  2 K 4o -KK- @ !K  2 \ 5R -\\- @ !\  2 m 6o -mm- @ !m  2 ~ 7R -~~- @ !~  2 8o -- @ !  2 9R -- @ !  2 #Ao  -- @ !  2 BR  -$$- @ !$-"System-'-- ,2-   @ !) -    @ !)S#-    @ ! 9-    @ !S9# Tahoma-  .2 3Microsoft Business Planner        Verdana-  2 M2Go to Article:    Verdana Ref- 92 ^2!Calculating Your Break-Even Point Verdana-    Verdana--  - - --'- -  ,2$-  $2 3Break-Even Analysis      - - ----------------------------------'--  ,2$------------- 2 2fEnter the relevant data from your profit and loss statement to calculate your break-even point (BEP).   2 2mVary the size of the different inputs to analyse your BEP's sensitivity to rises or falls in sales or costs. o2 2EYou can customize the form by changing the row labels or adding rows.R    2 2dTo add a row, select one of the rows labelled "Other", click Insert on the Excel menu bar, and then     2 2eclick Rows. The cells displaying zeroes or "#DIV/0!" contain formulae to perform the calculations on     2 2gyour data. Do not type into these cells as you will erase the formulae in them. Click on the "Example"       Q2 21tab to see a completed version of this worksheet.  ---'--  ,2--'--  ,2-   -- @ !-- @ !#-- @ !1-  -}#}3- @ !}#- -'- ,2-'- ,2-   -2- @ !2-- @ !-'0  *H 0 10 *H 0g +7Y0W03 +70%7)O•0 0 *H {bs+ (r̠?00)ъĽ5ǛSV0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.00  *H 0. h|,-.  WSu3* [4 Z%}XsjxqX)X^-bXq"X/6MJ;"V~!lJGj6 -Ӵ90  *H :>{թy=q#+(ߌe,ZbVkbEƢ5"r-| CMlX 5ʉp*}a qfbB="2"d$006C!FXF%`0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z01'0%U VeriSign Time Stamping Service10U VeriSign Trust Network1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.10U VeriSign, Inc.10UInternet00  *H 0aGܴ^i b1FI:?xZcEO n06- o' Q`5OTOз,B Ѝ^㖴"IBlӘV.:X"e匫xGBh[-}0  *H m`_i{p+b#D Q#tI'\q5+ൖ苧KsH ڋ %VNGWF8V!&;-%2Λ@GmGv0;~*1+ݰUApF-,~0 0 yfnжneq0  *H 0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA0 980416000000Z 990416235959Z0]10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA1F0DU =www.verisign.com/repository/CPS Incorp. by Ref.,LIAB.LTD(c)961>0<U 5Digital ID Class 3 - Microsoft Software Validation v21 0 UUS10U Washington10URedmond10UMicrosoft Corporation10U Microsoft Corporation0 0  *H  0&dm{AO o*q.S26h5IؖeS zpm̳*02X|k%gw #1J0F0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1䘫=?k0x +7 1j0h(&Break Even Analysis<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H .k#m`r`1P0d`WP-Rn dyUcGPfhsܩ_e$hR5fDŇ4p D[x@[SFRGୡљ,GlclqV'C 0؊vwDrF]f .HB)Q.Z u9Kfr2ڜ`y.wHǻt/vΝv0)`_-"IR"* #,##0.00_-;\-"IR"* #,##0.00_-;_-"IR"* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_- "$"#,##0.00 "$"#,##0#,##0;\ \(#,##0\)#,##0_);\ \(#,##0\)                 %@   7     % @ % !@     D  $ 7 # ! ! ) )  % @   !7  7     @  `  %!( @   !x@  @  %!(@  %!(@  `7   % 7  p7  p7 (@ (@(@%( %!( %qh @   qt"7   $7   $7   $7 7 qt"7  %q`"@ %( $7   %!( %qh"@   `  @  %!(@7  % 7 7 %ah"@@  at" @   %!(@ qt"7 @   (@7( h@@  ` @ %ah@  at  %a @  %a @  %a(@  A!7   H7 !  @ !  `  `7 H @ h7 `7  H ! X P ! A!7 #  `  %a @ ) ) ) ! ) ! ) ) ) ) )  amount Body text header Header Total Header1 Header2 Header3 Header4NonPrint_copyrightNonPrint_HeadingNonPrint_Hyperlink NonPrint_TemTitle! NonPrint_Text "Normal 2#$ Product Title %Text &Title`w Worksheet*5Example  ;6  ;7 g F'CALCULATE YOUR GROSS PROFITProjected SalesLess Direct CostsPurchases (material costs) Labour Costs Gross ProfitGross Profit MarginCALCULATE YOUR OVERHEADSIndirect Costs/Business Salaries (including your own drawings)RentRates Light/HeatingTelephone/Postage InsuranceRepairs AdvertisingBank Interest/Hire Purchase Overheads/Wavendon Plumbing: 6-Month Financial ProjectionBreak-Even Analysis: ExampleBreak-Even SalesMonthly Break-Even SalesProfit (for 6 months)Break-Even AnalysisNumber of MonthsProfit During PeriodGo to Article: See Also:.Break-Even Point for Selling Multiple Products!Calculating Your Break-Even PointProfits accumulate in favour of the business once the break-even point has been reached. As overhead costs have been provided for in the break-even calculation, profits accumulate at a rate of 30 per cent (i.e. the gross margin percentage) on projected sales over and above the break-even figure. These figures can thus be affected by: actual level of sales achieved; increase/decrease in gross margin; increase/decrease in overheads. zEnter the relevant data from your profit and loss statement to calculate your break-even point (BEP). Vary the size of the different inputs to analyse your BEP's sensitivity to rises or falls in sales or costs. You can customize the form by changing the row labels or adding rows. To add a row, select one of the rows labelled "Other", click Insert on the Excel menu bar, and then click Rows. The cells displaying zeroes or "#DIV/0!" contain formulae to perform the calculations on your data. Do not type into these cells as you will erase the formulae in them. Click on the "Example" tab to see a completed version of this worksheet.Break-Even Point'Other (eg depreciation of fixed assets)Microsoft Business PlannerNote: When you save this template as a workbook, note the workbook's file name and location. To edit the workbook next time, you must open it using Excel. Every time you open this template from Business Planner, a new workbook is created.Note: When you save this template as a workbook, note the workbook's file name and location. To edit the workbook next time, you must open it using Excel. Every time you open this template from Business Planner, a new workbook is created.R Colin and Paul Barrow 1998, The Business Plan Workbook, published by Kogan Page.9* ^N! @ D"H*2@3  dMbP?_*+% &LDate: &D&~?'~?(~?)~?MHP LaserJet 5Si/5Si MX7@ `@dXX7@XXEXCELCourier New (X/\\proliant\pro_frontHP5SI" dXX `? `?U} I} &}  } I} $ C} C} $ CD @@@  X@                    'TUUUUU(' d#UUUUU('VWWWWW(' XWWWWW(' cWWWWW('YYYYYY('ZZZZZZ(' hiiiii(' j iiiik( 'abbbbb( ' l% iiiik( '[\\\\\( ']^^^^^( ' V \\\\\('[\\\\\(' c!\\\\\(' mm\\\\('_WWWWW('_WWWW e&('MN''''(B'gf''''(B( SR''''(B(*.''''(B( 3/''''(B(K:''''(B( 20''''(B(*0''''(B( L9''''(B(4:''''(B( 59''''(B( 6:''''(B( );''''(BD.l..........000000  !  "  # $ % & ' ( ) * + , - . / 0  1  2  3  4  5  6  7  8 9 : ; < = > ?  ( 7( <"DDD ''''(B!(+1''''(B"( "=!"83 D D"''''(B#(*.''''(B$( $2$0''''(B%(*0''''(B&( &>&9''''(B'( '@ '?''''(B(( (@ (?''''(B)( )@ )?''''(B*( *@ *?''''(B+( +@ +?''''(B,( ,@,?''''(B-( -@-?''''(B.( .@.?''''(B/( /6/?''''(B0( 0-"0;''''(B1( 1A#1<  %'01''''(B2(*.''''(B3( 3A!3I7 D1D"3''''(B4(H/''''(B5( 5A!5<'( D3D5''''(B6(DE''''(B7( 7F(7G5DD3D"7''''(B8((((((((B9((((((((B:BJJJJJJJB;B<B=B>B?BDlZS000000000000USSZ @ABC@BABBCCC x< >@  " 7^yK yK *msbpz://-r:276DB1E7/^yK yK *msbpz://-r:276DB15B/FyK yK http:///^yK yK *msbpz://-r:276DB11F/ Sheet1 @ CQ8u@HwI  dMbP?_*+% &LDate: &D&x ?  (+1''''(B!( !=!!8333333?2 DD!''''(B"(*.''''(B#( #2#0''''(B$(*0''''(B%( %>%9''''(B&( &@ ~ &?p@&''''(B'( '@ ~ '?@@'''''(B(( (@ ~ (?@@(''''(B)( )@ ~ )?@@)''''(B*( *@ ~ *?@@*''''(B+( +@~ +?@@+''''(B,( ,@~ ,?@@,''''(B-( -@~ -?p@-''''(B.( .6~ .?p@.''''(B/( /-"~ /;p@/''''(B0( 0A#0<@ %&/0''''(B1(*.''''(B2( 2A!2<@4 D0D!2''''(B3(,/''''(B4( 4A!4<UUUUU@6 D2D4''''(B5(DE''''(B6( 6O(6Pp@'(DD2D!6''''(B7((((((((B8((((((((B9BJJJJJJJB:B;B<B=B>B?BDlS00<<<<<<<<<<USSZ @AB@BACBC Z( >@<dccc" 7^yK yK *msbpz://-r:276DB1E7/^yK yK *msbpz://-r:276DB15B/FyK yK http:///^yK yK *msbpz://-r:276DB11F/ Sheet2   "#$&()*,-./012456789:;<=>?@ABCDEFGHIJKLMNOPQSUVWXZ[\]_`abcdefghijklmnopqrstuvwxyz{|}~ FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2MainMainID="{7BFDC745-6759-11D2-B09D-080009FBA239}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Module=Main Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="7577B9365BAF5FAF5FAD61AD61" DPB="EAE826C19AC29AC29A" GC="5F5D935C7DA4F3A5F3A50C" [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 Main=44, 44, 632, 442, Z <jx^X#<DO`FDO`xDO`DO`MESheet1~Sheet2 ~__SRP_0^ __SRP_1Y<__SRP_2T__SRP_3RB__SRP_43__SRP_5+__SRP_6'__SRP_7%B__SRP_8!__SRP_9BThisWorkbook _VBA_PROJECTak  *\G{000204EF-0000-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#D:\WINNT\System32\StdOle2.tlb#OLE Automation*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINNT\System32\fm20.dll#Microsoft Forms 2.0 Object Library*\G{5DBCDB52-F197-11D1-9DC7-00C04FB160FE}#2.0#0#C:\TEMP\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.1#0#D:\Program Files\Microsoft Office\Office\MSO97.DLL#Microsoft Office 8.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO360.DLL#Microsoft DAO 3.6 Object Library  <|c7^ThisWorkbook05378e0cc5ThisWorkbookX Sheet106378e0cc6 Sheet1Z Sheet207378e0cc6 Sheet2$0Main08378e0cc6Main&HhH0DO`DO`DO`DO`MNd/ Excel+ VBAWin16~Win32MacVBA6# VBAProjectstdole`MSFormsCOfficeuDAO ThisWorkbook| _Evaluate Sheet1 Sheet2 Main, (RegCreateKeyhKey lpSubKey phkResult4 advapi32.dll}0(RegQueryValueExT lpValueName) lpReservedPlpTypelpDatah0lpcbData4 (RegCloseKeyl(!LU&^strCellstrQueryM?(aLUs$ (Auto_OpenV (FillDocFUbProfiledbsǂdbPathers_ Recordset WorksheetsRange ValueKi` (GetProfileDBf (GetCurrentDB DBEngineQ WorkspacesUd OpenDatabase`ErroClear OpenRecordset|dbOpenForwardOnly;EOFBOFy (GetOptionsKeyostrDirRight strValueKstrKeystrData@dwActionR dwDataSize)dwTypeHKEY_CURRENT_USERʝREG_SZdChrK~Trim@Workbookk Worksheet_DefaultjItemzNumber-Fields7 _B_str_Right#( _B_var_Stringӊ _B_str_Chrm# _B_str_LeftV _B_var_TrimmT H@@Q(SLSS6"N0{00020819-0000-0000-C000-000000000046}(%H` % %`h8@0<|c7$*\Rffff*05378e0cc54xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2rU @nrU Q y i 4 1 `rU @nrU  i 4 1 `rU  0Y p (@ $p9Qi("(( Lp$`(`#$`$`(!`0 nrU~| %qqa91 Y!I1!9 Y  iI l<AA +z  [<$ DK]A@X(\%l$ l dX8A:( ]@)lX68g   1t 1t lt 0H'%'(%'H%ltX(\%l $ <l 0X XQx)lXc7 llHl1l'(%'H%\%kAx Qlp$ ll ll!#p 4kp k:H 8X(\%lp l 0X D8KF%kA@((%$  dC)lX6 8 p  d x XD0ptx,lX8TCtt 1x/t(xtCdd FTh/dh:D ]@u%hd #@=2d@ch:DThh:DTh h1x<,xhd@TT :,h4`h($4l$^ q LLLLLLLLx@P0H>B@z `H(hXPP>NVXZ`f@l @\ @@X @H @8 @(( @ @  @ @ @p @ ( p@ @ @ @ @ @ p" (  `Xx l@t 0 H `  `Vx lp@x d @T @D @@ 8 p h 0 H `lxX 0 @, \*6@ ( @$ @  @  @ @(  @ P0P x<|c7$*\Rffff*08378e0cc6(*\Rffff*08378e0cc6\0*\R5*#24*\R5*#2e*\R1*#229*\R1*#c4*\R1*#b8*\R5*#46*\R5*#1b*\R5*#21*\R5*#22*\R0*#13*\R0*#19*\R5*#0*\R0*#1a*\R5*#28*\R5*#29*\R5*#2a*\R0*#fq H  H  H   (08 8@ Tx  "   :(h, D  N Ph " p bx 6   (0 0`8 h  p   H   "1 $@ #P4h       B B   ( H,7X  B    @  <X4 " (Z *$2 8 @ PX  `px x^^0p@1This array holds cell/query combinations to fill.NNote: The first element in this array is the sentinel. If the cell of its namecontains data, we'll exit.] P AutoOpen Macro3 This is where the data to be written is specified:B21$>(:Profiler_MEGATASK600111_A1$>(<> Uncomment this to fill the document from the profile databaseA@BH Or uncomment this to fill the document from the current wizard database FillDoc Falseo\ This does the actual work. If bProfile is true we get the info out of the profile database,/ otherwise we get it from the current wizard db](]H]`$>!:$N%P!RG|j] D$V'Hdh$X'HkP HG|j H Z%\%^.F T >  `B@b T$>!< f F%d.J ` J!h J!j$JX T$>!:$N%P(RkXkP JB@B T FB@BoCurrentWizardDB$l'Xi]CurrentProfileDir$l'n n n$ p\G n\'nj n msbp_plz.mdb'nkP n'Vi@0]]]] ]87Software\Microsoft\Microsoft Reference\SBB\9.0Z\Options't6This is a template moniker First, get the content root ~ t "$  $\'v " r  v$* v$  v v$  $ 'vk v$'v v'lk "A@6kixAttribute VB_Name = "Main" Option Explicit Declare FuncpRegCreateKey Lib "advapi32.dll" Alias " LA" (ByVal hhAs Long, lpSubSphkResult ,)!Querbueactuwornkb>@,t; getbinfop outA3m,'o rwis5be"it %b AOrror `NexaDim dbsu,Patha.Sb/!r"Recordse a `[WsheetT.Range(H). <>X ""&NE\ /,a iIntegeri *=ACdb = Get5DB{cE;!aICCHIfL&S:*= DBEng~."paces(iAs%.( W H` F5i0 To UBoundB() - 1C'Err.C_PD$a5=<. 51izbw,` !wbOnly hen0 (rs.EOF A%@BOF)1B CGaC= C O(@,& r& s%3be 0 i1pg >F#(!(0 ing_sP~("WFDB" !yX*yQ0WDiSuirP47Right$(C, e\9= & "\ `1"msbp_plz.mdbp` `{Cpu, təYQPwAB0w9SizepL`Con~HKEY_CURREN@T_USER@ &8H80:SREG_SZ ` "Soft6e\MiysZfznce\SBB\9.0Z\d%da templP moniker Fi,eAorooZ I( ~) H?U= (1024, 32P.WRF28Ex(!, 0, eP!`(a5In2+p, Chr$U) >  Lef.V ii,ugTrim :,DAub$q2r <|c7 J< rstdole>stdole f%\*\G{00020430-C 0046}#2.0#0#D:\WINNT\System32\StdOle2.tlb#OLE Autom`ation^MSFor ms>SFErms$3DD452EE1-E08F-101A-8-02608C4D0BB4DCDfm20.dll#Microsoft 9 \ Ob Library/;C~1s00}#0#j0jA5DBCDB52-F197-11D1-9DC7@C04FB160FE6TEMP\VBE\DM.exd`5.E .`0M ACOf(ficDO@ficB *2DF8D04@C-5BFAaB -BDE5*AAu@42*@gram File,s\^\MSO97.DLL1 8.0Lg"@DAO>ADAO*@i25E01&05nPROGRAM FILES\COMMONMICROSOFT SHARED\360L- 3.6,^ThisWorkbookG`Th@/sWb`kbok2` H1Z`&",XT""+)S@heet1G SŠe@t1 ]2 Z 2 2 2 2 $ `MainG Mam`-n 2o m(&!'c(b