ࡱ> rxRoot EntryRoot Entry F@HFks*CompObjfWorkbookV7_VBA_PROJECT_CUR"HFkHFkU  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIKLMNOPQRSTuWXYZ[\]^_`abcdefghijklmnopqtvwz{|}~MSDigSig(Author)$JHSummaryInformation(bDocumentSummaryInformation8 %VBA HFkHFk՜.+,D՜.+,D"" X`l t| / Summary of Key Ratios  WorksheetsA!!, !!0 *H 010 *H 0R +7D0B0 +7=! unWd 0 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  19D%miR *!0  *H pAf+7tgr]J,ɉ"z.}0  *H ; uh|}>baV}HqXs Km/I(,P{J.<6,X6I*qL#0W`I9ݚwNe[pB|%M:E 5CERT ,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_HLINKSA$WBmsbptz://Profit and Loss Statement - Summary of Years 1 to 5.xlt/@6msbptz://Balance Sheet - Summary of Years 1 to 5.xlt/msbpz://-r:276DB119/  http:///  http:///  http:///Oh+'0b X`  %Summary of Key Ratios - Years 1 to 5elMicrosoft Corporation- Microsoft Corporation- Microsoft Excel@v)t@7)+@8Gpa;% 0&" WMFCO #Cd0;% EMFC @    !" !" !  " !  1'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 61% Ld00!??% #6#% Ld###!??% 6% Ld!??% 060% Ld000!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw \lP@$0 \l|pd+%w0%    TT AA LP1gn   ( &% 6% Ld!??   TT (7AA (LP2   %  6 % Ld   !??   TT :IAA :LP3   % :6:% Ld:::!??   TT KZAA KLP4   % K6K% LdKKK!??   TT \kAA \LP5   % \6\% Ld\\\!??   TT m|AA mLP6sh   % m6m% Ldmmm!??   TT ~AA ~LP7n    % ~6~% Ld~~~!??   TT AA LP8TL   % 6% Ld!??   TT AA LP9LS   % 6% Ld!??   TT"AAL#PAnc    % 6% Ld!??   TTyAAyLPBU    % $6$% Ld$$$!??   TTAALPCL    % 6% Ld!??% % " !% %   1'%    Ld#9 )!??'% (  Ld#09#g)!??'% (  Ld9#&" WMFC C9 !??'% (  Ld#90#9g!??RL Tahoma TahomaDhۍ0WXw \@$0 \ 0%  % % " !% %   $ 09   T3 +8AA3 LMicrosoft Business Planner       % % " !% %   1RL Verdana VerdanaDhۍ0WXw \@$0 \0%    T2MYAA2MLhGo to Article:   RL  Verdana Ref Verdana RefDhۍ0WXw \@$0 \3 0% RL  Verdana VerdanaDhۍ0WXw \@$0 \ 0%   RL  Verdana VerdanaDhۍ0WXw \@$0 \ D0% % % % " !% %   $\0l  T2^kAA2^LSummary of Performance RatiosG  %  % % % % % % % " !% %   $1%   T$30AA3$LSummary of Key Ratios - Years 1 to 5            % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $1% % % % % % % %   Tt20AA2\LThis template will automatically calculate your key operating ratios, based on the data you    TP20AA2VLenter from your profit and loss statement and balance sheet summaries of years 1 to 5.   T20AA2_L Fill in the appropriate cells in the "Data Collection" section. The cells displaying zeroes or 12  TP20AA2VL"#DIV/0!" contain formulae to perform the calculations on your data. Do not type into     T20AA23Lthese cells as you will erase the formulae in them.   % % % " !% %   1% % " !% %   1' % (     ( &% % Ld!??% % Ld#!??% % Ld!??% % Ld0!??'%   ( &% #}62}&6WMFCC% Ld#}0}#}!??% ( % " !%   1% " !%   1'%    ( &% 61% Ld01!??% 6% Ld!??% "   1  '' ' ,1-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-1- @ !0-##- @ !#-- @ !-00- @ !0-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1 -- @ !  2 ( 2/ -  - @ !   2 : 3 -::- @ !:  2 K 4 -KK- @ !K  2 \ 5/ -\\- @ !\  2 m 6 -mm- @ !m  2 ~ 7 -~~- @ !~  2 8/ -- @ !  2 9 -- @ !  2 #A  -- @ !  2 yB/  -$$- @ !$  2 C  -- @ !-"System-'-- ,1-   @ !) -    @ !)g#-    @ ! 9-    @ !g9# Tahoma-  --'- -  ,90 $ .2 3Microsoft Business Planner       --'- -  ,1 Verdana-   2 M2Go to Article:    Verdana Ref-  Verdana-    Verdana-- --'- -  ,l0\$ 32 ^2Summary of Performance Ratios  -  - - - - - --'- -  ,1$-  =2 3$Summary of Key Ratios - Years 1 to 5            - - ------------------------------------'--  ,1$-------- 2 2\This template will automatically calculate your key operating ratios, based on the data you    2 2Venter from your profit and loss statement and balance sheet summaries of years 1 to 5.   2 2_Fill in the appropriate cells in the "Data Collection" section. The cells displaying zeroes or   2 2V"#DIV/0!" contain formulae to perform the calculations on your data. Do not type into     T2 23these cells as you will erase the formulae in them.r   ---'--  ,1--'--  ,1-   -- @ !-- @ !#-- @ !-- @ !0-  -}#}2- @ !}#- -'- ,1-'- ,1-   -1- @ !1-- @ !-'0A *H 20.10 *H 0g +7Y0W03 +70%7)O•0 0 *H =]yz ex^b#?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 #1k0g0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1 xĒ*ݽ0 +7 10FDSummary of Key Ratios Years 1 to 5<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H '+8ؠb=K}iCTV{CI1T{!Q&2>QwhHWH{p^UYƾ Pކ6^',@B+qBO?YM|L ;|h3h-Mbg oKD!̸]K\e#\oA WWȂCAa40 *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 981201010504Z0 *H  1&pVyl0  *H *F vWV usrCh$iҖiƞߍ,+e"YW373FA@Q_=:5^׸EkST/L2י}/'B5Xm(+nƊ?(GPROJECT PROJECTwmMdirSMain  & @`\pMicrosoft Corporation Ba= ThisWorkbook=-j,8X@"1Arial1Arial1Arial1Arial1 Verdana1Verdana1Verdana1 Tahoma1Tahoma1Tahoma1 Arial1@ Tahoma1Tahoma1@ Tahoma1Verdana1Verdana1Verdana1& Verdana Ref1& Verdana Ref1& Verdana Ref1& Verdana Ref1&? Verdana Ref1$Arial"$"#,##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\);_(* "-"??_);_(@_)""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- "$"#,##0.00 "$"#,##0#,##0;\ \(#,##0\)#,##0_);\ \(#,##0\)                 %@@   7  % @  %@"@        D  $ 7 # ! ! ) )  % @  !7  7     @  `  `  %   `7   % 7   %   % 7   Q    Q @ %  !p   H  @  `   h@@  `@  ` @  % 7   % 7  %1(@ %18@ %10 %10   Q(@ a @  % @  % 7  % 7 7  %   % 7   %A`7  % @7  Q(@ Q( % 7  $  $7  % 77   qh  q(   %(@ !7   H7 !  @ !  `  `7 H @ h7 `7  H ) ) X P  %   $ )P )P P @ ` %1p  q8 7 !7 #  `  `  %1 @ ! ! ! ) ) ) )  amount Body text  header Header Total Header1 Header2 Header3 Header4NonPrint_copyrightNonPrint_HeadingNonPrint_HyperlinkNonPrint_TemTitle NonPrint_Text Normal 2 Product Title !Text "Title` Summary of Key Ratios  ;7 g*&Sales Cost of Sales Gross ProfitTotal ExpensesProfit Before Tax Balance Sheet Net WorthReturn on Net WorthDebt to EquityNet Current Assets Current RatioDATA COLLECTIONTotal Current AssetsTotal Current LiabilitiesCalled-Up SharesAccumulated Profits/Deficit Loan CapitalProfit and Loss StatementTotal Cost of Goods SoldProfit After Tax KEY RATIOSPerformance RatiosBalance Sheet RatiosYear 1Year 2Year 3Year 4Year 5Go to Article: See Also:Summary of Performance RatiosThis template will automatically calculate your key operating ratios, based on the data you enter from your profit and loss statement and balance sheet summaries of years 1 to 5. Fill in the appropriate cells in the "Data Collection" section. 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.$Summary of Key Ratios - Years 1 to 5'Balance Sheet - Summary of Years 1 to 53Profit and Loss Statement - Summary of Years 1 to 5Microsoft 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.R Colin and Paul Barrow 1998, The Business Plan Workbook, published by Kogan Page.9* F6 @ L'%2a4  dMbP?_*+% &LDate: &D&x &&&&(^$ > &&&&(^$ >&&&&(^$ >&&&&(^Dl0000000002.^..... !"#$%&'()*+,-./0 1 2 3 4 5 6 7 8 9 : ; < = > ?  $ > &&&&(^!$,))))*^"$ "<"))))*^#$ #>#&&&&(^$$ $>$&&&&(^%$ %>%&&&&(^&$ &M&&&&&(^'$ '>'&&&&(^($ (>(&&&&(^)$D????@^*$ *=*))))*^+$,))))*^,$ ,E,AAAAB^-$ --!-H^ D$D#!-H- D$D#!-H- D$D#!-H- D$D#!-I. D$D#-_.$ .-!.H- D%D#!.H. D%D#!.H. D%D#!.H. D%D#!.I/ D%D#._/$ /-!/H. D&D#!/H/ D&D#!/H/ D&D#!/H/ D&D#!/I0 D&D#/_0$ 0-!0H/ D'D#!0H0 D'D#!0H0 D'D#!0H0 D'D#!0I0 D'D#0_1$C????@^2$ 2F2AAAAB^3$ 3-!3&5 DD!3&3 DD!3&3 DD!3&3 DD!3G4 DD3^4$ 4-!4H- D(D3!4H4 D(D3!4H4 D(D3!4H4 D(D3!4I5 D(D34_5$ 5-(5H4D DD3(5H5D DD3(5H5D DD3(5H5D DD3(5I6D DD35_6$ 6- !6&3 DD!6&6 DD!6&6 DD!6&6 DD!6G7 DD6^7$ 76 !776 DD!777 DD!777 DD!777 DD!7J7 DD7^8$$$$$$$$111 9$$$$$$$$111 :12222222111 ;1<1=1>1?1DJ l........... @ABCDEFGHIJK@1A1B1C1D1E1F1G1H1I1J1K1h >@<d  2 7FyK yK http:///FyK yK http:///FyK yK http:///^yK yK *msbpz://-r:276DB119/yK yK lmsbptz://Balance Sheet - Summary of Years 1 to 5.xlt/yK yK msbptz://Profit and Loss Statement - Summary of Years 1 to 5.xlt/ Sheet1   "#$&'()*+,./0123456789:;<=>?@ABCDEFGHIJKMOPQRTUVWYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qThisWorkbookThisWorkbookSheet1Sheet1MainMainID="{7BFDC7A3-6759-11D2-B09D-080009FBA239}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Main Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="9092476D4B6D4B6F4D6F4D" DPB="2022F7F8F8F8F8F8" GC="B0B2678868886877" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Main=132, 132, 720, 530, Z <jx#<![DO`F![DO`x![DO`![DO`MESheet1~__SRP_0 X __SRP_1S4__SRP_2N__SRP_3LB__SRP_4-__SRP_5%__SRP_6!__SRP_7BThisWorkbook _VBA_PROJECTy3ak  *\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}#4.0#0#D:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL#Microsoft DAO 3.5 Object Library  H+6'ThisWorkbook04378e0d2dThisWorkbook Sheet105378e0d2e Sheet1Main06378e0d2eMainĕ0P0![DO`![DO`![DO`0LM@/ Excel+ VBAWin16~Win32MacVBA6# VBAProjectstdole`MSFormsCOfficeuDAO ThisWorkbook| _Evaluate Sheet1 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_TrimmTx   6@@Q(SLSS6"N0{00020819-0000-0000-C000-000000000046}(%H` % %`h8@0H+6'$*\Rffff*04378e0d2d4xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2rU @nrU  i 4 1 `rU  0 p (@ $p9Qi("(( Lp$`(`#$`$`(!`0Q nrU~| %qa9 I1Y! ay   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 stdole f%\*\G{00020430-C 0046}#2.0#0#D:\WINNT\System32\StdOle2j^ĕl&RegCreateKeyA&8RegQueryValueExA&`$RegCloseKeyxRRMELL@H6(LX(LJ> LLLLLLLL`zk @`o'' iB  Dx@%`Ft Hpx%`R+V`8 tkG+T0`@ @k K@lh +j` kpVip0 @rh `td` `@vP @x@ `z<@|C@~B<x@P0H<@@z `H(hXPP<LTVX^d@l @\ @@X @H @8 @(( @ @  @ @ @p @ ( p@ @ @ @ @ @ p" (  `Vx j@t 0 H `  `Tx jn@x d @T @D @@ 8 p h 0 H `jxX 0 @, \(4@ ( @$ @  @  @ @(  @ P0P xH+6'$*\Rffff*06378e0d2e(*\Rffff*06378e0d2e\0*\R5*#28*\R5*#2d*\R1*#229*\R1*#c4*\R1*#b8*\R5*#1f*\R5*#1e*\R5*#24*\R5*#23*\R0*#13*\R0*#19*\R5*#0*\R0*#1a*\R5*#31*\R5*#30*\R5*#2f*\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$<(8Profiler_MEGATASK600111_A1$<(:> Uncomment this to fill the document from the profile databaseA@@H 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]`$<!8$L%N!PG|j] B$T'Fdh$V'FkP FG|j F X%Z%\.D R <  ^B@` R$<!: d D%b.H ^ H!f H!h$HX R$<!8$L%N(PkXkP HB@B R DB@BoCurrentWizardDB$j'Vi]CurrentProfileDir$j'l l l$ n\G l\'lj l msbp_plz.mdb'lkP l'Ti@0]]]] ]87Software\Microsoft\Microsoft Reference\SBB\9.0Z\Options'r6This is a template moniker First, get the content root | r $ $\'t  p ~ t$( t$  t t$  $ 'tk t$'t t'jk A@4kixAttribute 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$q22.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&04*@Common-Shared\350L- 3.5,ThisWorkbookG`Th@/sWb`kbok2` H1Z`&",T""+)S@heet1G SŠe@t1 ݣ2  `MainG Ma`n 2o mXĕ!cb