ࡱ> ,   !"#$%&'()*+d./0123<56789:;-=>?@ABCDEFGHIJKLMNOPQSUVWXaZ[\]^_`RbclRoot EntryF`@TBook _VBA_PROJECTT5/&8g/&8a2b3d79ddc LQ  !"#$%&'()*+,-./0123456789:<=>?@BCDF6`\ vt_divider$HSettings$t$J6(68l (,, #N/Al,,,$,h,#VALUE!l,h"$l (8t,,,d,\#VALUE!l,h,,vZ,\6H@68@4H8,`ZdH,dp$$$ \AcTB$t48J6HT6`dp$$ AcTB$t4J6T6`t vt_divider$Settings$t4dJ6T6Dl8HdT|,,`ZB,`BbH ,n@,`BfH ,l@,`BhH ,j@,`BjH ,p@f,`BlH ,f@L,`BnH ,h@2,`BpH ,v@,`BrH , @,,`@ H,dp$$ tAcTB$t4DJ6TT6d`0DT,dp$ $ tAcTB$t4DJ6TT6d` DT,j0j DV,,dp$v@d@ tAcTB$t4DJ6TT6d`DT,,`Zl^,j vt_divider$tSettings$t4DJ6T6dlDT ,,jl,,,4,h,t#VALUE!l,hl&4 0l00DTd8H,,,,,X>j,,(j,,`jdrX`j@rH68,H#VALUE!l,h,,,,HhR,,v84j8(,j( HPY RX ,bh ,j( HPP RX ,dh,j( HMP RX ,fh,j( HCY RX ,hh,j( HMY RX ,jhb,j( HCOMP RX ,lh6,j( HMCOMP RX ,nh ,,ph,N(,,`h&,`&jp,`hl$B,`&lH, $&,`&nH, $ ,,j$,,fH@v84j8 N8,H68@6@ 8,`$ ph,`jfpH$v$d@ TB Scheme l |$t 8J6T6`l8,,`jfpH$X $ TB Scheme l |$t J6T68`,`jfpH$X$ TB Scheme l |$t J6T68`,jjl,, ,$h,v fH@v4j,jHA RX ,dt,jHB RX ,fL,jHC RX ,h$,jHD RX,j,N,`b,`jbrH`j` prXD`hnprD\,``h8d``h8,^``h`j8,,,,h.$ ( l8  0\ (lTo cop,,,88,Xh H, x ,,x,D,,hX H(,hX H, x,hX H,fX@vH4jH|h R8NHN, /4(0,)x40,V,, /4(,)00(x,04(, ,,x,,,hX z8,x,, fX@v84j8 |h RHN8N,((),/0 x(,0V,,((),/0 04x(,04 D~)Z!*DXLQP,,XJ|Hv8v8v(j(pH8(, TB Scheme fX@v(4j(8$ 6H@6@6Jht (H8,,`jdj,`jfp$$tt6`"jJ|(v8v8vHjHl (8H,lllpT,`jz,<,,llJX,<Ptlp(8H EE0r(DLAp(DLA,, ,, l,, v\4j\L,jL lCY R< ,bh,jL <MP Rl ,d>,jL <PP Rl ,f,jL <PY Rl ,h,jL <OI Rl ,j,jL<SECTNAME Rl ,l,jL<ACNAME Rl ,nb,jL <COMP Rl ,p6,jL <MCOMP Rl ,r ,,l,NL,,L @ L \`Z,,,d,\#VALUE!l,h,,vZ,dHHr\`ZlHrH68*,vZfH@v8 j8l,h,,H68@6(@$8(,`ZdH.,jp\$pfp$HSectCDTB$t$(J68T6`(8,jpH$pfdp\$SectCDTB$t$J6(T68`(,jjH vt_divider$Settings$t$(J686l(8,,`Z,`bH,jpH$pfp\$SectCDTB$t$J6T68` vt_divider$Settings$t$(J66l (8,`fH,jp$pfdp$SectCDTB$t$J6T6`\ vt_divider$HSettings$t$J6(68l (,, #N/Al,,,$,h,#VALUE!l,h"$l (8`,,,d,\#VALUE!l,h,,vZ,\6H@68@4H8,`ZdH,dp$$$\SectTB$t48J6HT6`dp$$SectTB$t4J6T6`t vt_divider$Settings$t4dJ6T6Dl8HdTd,,`ZB,`BbH ,l@,`BfH ,j@~,`BhH ,h@d,`BjH ,n@J,`BlH ,f@0,`BpH ,r@,`BrH,t@,,`@tZ,dp$v@d@tSectTB$t4DJ6TT6d`0DT,,dp$$tSectTB$t4DJ6TT6d` DT,dp$$tSectTB$t4DJ6TT6d`DT,j jD0,,`Zl^,j0 vt_divider$tSettings$t4DJ6T6dlDT ,,j0l,,,4,h,t#VALUE!l,hl&4 0l00DTd8HAP,,,d,\#VALUE!l,h,,vZ,dHHr\`ZlrH68*,vZfH@v8j8l,h,,H68@6(@$8(,`ZdH*,jp\$rfp$HAcCDTB$t$(J68T6`(8,jpH$rfdp\$AcCDTB$t$J6(T68`(,jjH vt_divider$Settings$t$(J686l(8,,`Z,`bH,jpH$rfp\$AcCDTB$t$J6T68` vt_divider$Settings$t$(J66l (8,`fH,jp$rfdp$AcCDTB$t$J6T,,,,,HT x (,048He ```H$l$ 8  ~ ```` 0 ,4(@``A`h>8*\Rffff*57383eaca4*\Rffff*56383eaca4q*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\WINDOWS\SYSTEM\VBAEN32.OLB#Visual Basic For Applications*#1q*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\WINDOWS\SYSTEM\VBAEN32.OLB#Visual Basic For Applications*#5*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\Program Files\Microsoft Office\Office\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#100@B , ,ɂD <ɂ,N esaSwitches text betwen two options based on the values in a pair of cells. vtxlhelp.hlp!4006 hL ",-ɂ   ɂ lNReturns the balance or name for a special TB heading. vtxlhelp.hlp!4005 " \V jjhhɂ ɂ CReturns the balance or name of an account. vtxlhelp.hlp!4001 1$ r6ɂ HXɂ hUReturns the balance of an account by department or currency. vtxlhelp.hlp!4003 3 t6 x8" %ɂ ɂ IReturns the balance or name of a ledger section. vtxlhelp.hlp!4002 2 ,H$ ^L4ɂ pɂ TReturns the balance of a section by department or currency. vtxlhelp.hlp!4004 l Z " %ɂ \قlL$ɂ ɂ ~l tt pp ll &jjl,htP<P(xE4l  l l *$4 @ZhX8Hj @t Dl ^@ZD(( l @Z@t (z@j `HpZ@TX TH *@@t0 j  L\t de 8 Dj $( @    *@@|0 vt j MEpEyAB$DT6VD @H0Zڜ@lAPP~h=@` y,.H x ZB    (  ,48 <H `$l  .&J,T( , 0 < DHL dp  .&J,T  $(B,08@ D P\F`$     $ ", 8 "@ L "T ` "h t $| $     " & , 6d8p 6dt 6d      $ 0 8 D L X` d *<p"6& B $(,&< L |X    $ ,H $Pt |   (       *T( *TT    *T      0Z             0 B4 8 X  \ h x |  $ $   &    8`  >d  8b`      `   f@             B      $ ( , &<  L  X       ( 0L $Tx   (   ,V 4,V8,Vd   0Z    B 8 <HX\`$p$&  :b @f 8bD|   b h(    "     "  " $ ", 8 "@ L(T d&l | $ $  B0208@6H2j`6.f    $(,<@Last modified 2/7/988%This module contains custom functions(TB now accepts name or number of headingUp to 320 headings allowedY$@ aSSwitches text depending on sign of pair of numbers given by LeftCell and RightCellUp N$ D '`Sw 'gt `pe D LeftCell pos Or 0 Npos/pos or 0/pos pos/0 or 0/0 ' D apos/neg or 0/neg $  Le / ( ) 'po`or / ( ) $  'gpo`ne 0/neg 'g ` LeftCell negative Nboth negative or neg / 0 '`  neg / pos $  ( ) / 'N`( ) / $  'gacggneg/ eshY Y $  T' `?for use in design mode when numbers replaced by name of heading $'g   0 #VALUE!'ringes $  '`re $ PYGPin'PPGP'MPGP'CYGP'MYGP'COMPGP'MCOMPGPG'O'jg LP  '*GGP '*GP '*O'*j $ ' 4G !@!@ *   * TB Scheme 47J%T!`'`P  TB Scheme 47J%T!`'j   TB Scheme 47J%T!`'tT t j 'gm  4$ AGP'^BGP'^CGPch'^DGPT'^j ^   ^$r   ^ $ ^ +G ^  +ggg^eOn Error GoTo AcError  #VALUE!'rg  A@ !@!@   AcTB7J%T!`  AcTB7J%T!`  vt_dividerSettings7J%'` GPcurrent period'*GPprevious period`'*GP previous year'*GPopen item/all periods'*GP section nameio'*GP account namepr'*GP comparativeop '*GPcurrent year - comparative '*j *   AcTB7J%T!`'tco  AcTB7J%T!`'jye t j 've`  *AcTB7J%T!`'7g   vt_dividerSettings7J%'`t 'ggmr#VALUE!'eTOn Error GoTo ACCDError   #VALUE!'rg  A@  !  $'rrr Ggo !@!@     AcCDTB7J%T!`'t     AcCDTB7J%T!`'j t j  vt_dividerSettings7J%'`` GPcurrent period    AcCDTB7J%T!` vt_dividerSettings7J%'GPprevious periodod     AcCDTB7J%T!` vt_dividerSettings7J%'PO#N/A'jiogmr#VALUE!'e tOn Error GoTo SectErroriv  #VALUE!'rg  A@@ !@!@   SectTB7J%T!`  SectTB7J%T!`  vt_dividerSettings7J%'` GPcurrent period'*GPprevious period`'*GP previous year'*GPopen item/all periods'*GP section nameio'*GP comparativepr'*GPcurrent year - comparative '*j *  *SectTB7J%T!`'`ar  SectTB7J%T!`'t  SectTB7J%T!`'j t j 'TBgJ   vt_dividerSettings7J%'`t 'ggmSerTB#VALUE!'et,On Error GoTo SECTCDError  #VALUE!' rg  A@  !  $' rrr Ggo !@!@     SectCDTB7J%T!`'t     SectCDTB7J%T!`'j t j  vt_dividerSettings7J%' `' GPcurrent period    SectCDTB7J%T!` vt_dividerSettings7J%' PGPprevious period     SectCDTB7J%T!` vt_dividerSettings7J%' O#N/A' jiogmr#VALUE!' e l $  '`` $ CYGPin'MPGP 'PPGP'PYGP'OIGP'SECTNAMEGP'ACNAMEGP'COMPGP'MCOMPGP'OG'jgkG)Returns heading number for a heading nameY %The worksheet containing the headingsYYY$ T $$'in TB Scheme $  !@!@%J.ee0Loop through each heading until a match is found[$ & '& &  %T!`T $$'.   &'r egh a etc10b3e5e8114HdirYSummaryInformation(;pDocumentSummaryInformation8Ap( 6 60 0,dvZj^,bvn^,`Z`8b,,`Z`8 ?`Z$:,,vZ$,dv`Z^,`Z``8:T,`fp$@$v6 T6 `ldeleted f0 x,n,,`fp$@$v6 T6 `"vvj FvvvZP , vt_recalc$(p( "@`Zv  vfl@vf@@j Fj v0j0| f\P 0j,|,`fp|$$v6 T6 `"vvj FvvvZP ,,,,v,,,vD,vZ(,|$(p( 6N ,`:,rmNo TB headings found. You should ensure that only one copy of the file 'VTLib.xla' exists on your hard disk.,0 &@VT Accounts Preparation Package v @vf|@ 0,`:,82Most TB headings are not included in the workbook.,0 &@VT Accounts Preparation Package v @vf|@ 0j,`:,2-All TB headings are included in the workbook.,0 &@VT Accounts Preparation Package v @vf|@ 0,,|ResultD$(p( 6 60  j,|$(p( 6N ,,| VT_Results$(p( lN ,|$vl6, ^R, JX,JEWorkbook is protected. Cannot temporarily unhide sheet for printing., JJ,<7Cannot printout to earlier version 'account' workbooks.&,,Printing has failed.,,0 &@VT Accounts Preparation Package v 0vf|@ 0,$,,,|Preparing to print...$(p( 6N ,dvjd:^f,@`jv  j $f`jp|$$vl6 T6` ,`jp@$f`jp|$$vl6 T6`N ,`j| $f`jp|$$vl6 T6` ,| vt_recalc$(p( "@`jv   @NAME0v0`jf@j Fj v\j\$f`jpl$T$vl6DT6`P 0D\,T vt_recalc$(p( "@`jvD `jf@`jf|@jDFj v j $f`jp@$l$vl60T6`P D0 ,vjfT,T$(p(D6ND,vl6,T$2:$5000$vl6D6ND,T$vl6,,,v6,,T$(p(D6ND,,x(p(D6ND,T^  ,&,&,&,L,(T!An unexpected error has occurred.vvD jD vv  j 0"|Please notify VT Software.\ D 0\,  &VT Accounts Preparation PackageDvD|0vfT@D ,, TCannot carry out command.vvD jD vv  j 0N|FPlease ensure that a workbook based on an accounts template is active.\ D 0\,  &VT Accounts Preparation PackageDvD|0vfT@D ,|,L8* l(( &.    B* $*|H,,(p(l6L(p(\6<, VTXLHELP.HLP  l\L<,,vd @$(p( 6N ,L  ,<L\lH,, $l,,h`jpX$H$vl68T6`( 8,`jdj,,,,,`j ,Lt l8F,, v,`vdH@,d TB Scheme A$(p(ThxNT,`vfH@,d TB Scheme B$(p(ThxNT,`vhH@,d TB Scheme C$(p(ThxNTJ,`vjH<,d TB Scheme D$(p(ThxNT,,J(F x T d , ,  , , ,L8  Hf,, v,`vbH , Previous Yearx&,`vdH",Previous Periodx,`vfH&,Movement in Periodx,`vhH , Current Yearx,`vjH$,Movement in Yearxb,`vlH, Comparativex6,`vnH(,Movement from Comparativex,,Hf x in workbook...$(p( 6N ,(p( 6 1dD EE,,@$ chkIncZero$v6 6`N ,,v6 D N ,L, chkIncZero$v6 6 `@ R0 ,x,@9Checking that all TB headings are included in workbook...$(p( 6N ,(p( 6 N ,,,dvZj^F,vZ,`Z`,`Z,,vZ,`bH,6/Cannot find any trial balance headings in list.vv  j  vv0 j0\ 0\,0 &lVT Accounts Preparation Package v @0vf@ 0, ,,`,^  ,$(p( 6N , l1000$ @$A$1$SectList$(p( 46 J606` 0,l [company]$ @$A$1$SectList$(p( 46 J606` 0,(p( 6(N ,@ lstHeading$ResultD$(PD  0\n(`*6` $Z``H( $(Xh`A`````P`>8*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\Program Files\Microsoft Office\Office\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#10q*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\WINDOWS\SYSTEM\VBAEN32.OLB#Visual Basic For Applications*#5*\Rffff*56383eaca4*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\Program Files\Microsoft Office\Office\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#0q*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\WINDOWS\SYSTEM\VBAEN32.OLB#Visual Basic For Applications*#6q*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#..\..\WINDOWS\SYSTEM\VBAEN32.OLB#Visual Basic For Applications*#1*\Rffff*57383eaca4*\Rffff*57383eaca4\0*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\Program Files\Microsoft Office\Office\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#1*\G{00020813-0000-0000-C000-000000000046}#1.0#9#..\..\Program Files\Microsoft Office\Office\XL5EN32.OLB#Microsoft Excel 5.0 Object Library*#814VT Accounts Preparation PackagedDlHVisual Transactionp40HP(rhH|(N (( BT<P (^ac(( (:4lRt   llioق^ ق,ق<قNLɂ \ق$ 8$ 2,  ق  Z6 Hق^ * RH ht ق^ @~Z  l@ $<pDHlh<D\(Zx(Rx0^Z\< ,L h*  @4l GN3l 33j/ l inl  \ E L st@Jv$4 @P<  , l*Ex$at  l @8j@  H$@<`ME`~p $A6A JHD0ZJ@@lK@P*,:H>:.(0X\dlt"x" &$R     NpnXZD < , <0PT&RhFf &,*4 DP dt x |PrZ 6 *80tD6xt2 "0f0@NP $ (B ((*<,RT $ $6^ :$ $6^  DHL PT X \ ` &d pv|xZ :B ZH \ 6<d Z  H  &    :       NT  p @F|  $  Z     "B $ 6Z8 *Hp 0P f l4   &   2           &  :$ L  T  \  d l p bt Z    Z"D"Db pB "$@H\ d|"(B << <(D<Lhl"pt$F  "(l2  $Y$VT Accounts Preparation Package$ sY$Visual TransactionDY p!.the number of headings in each scheme (scheme)tiY !1the number of times heading used (scheme, period)g Y !.true if heading used (scheme, period, heading)ngY !"true if checking being carried outriY$!maximum periodno numberZZInZ l%Y <#array of results HYh` ( ^$A$3 ^$R%!` 'q gkI -No alternate trial balances have been copied. $ $' * c *To copy balance from  4=, choose the Get Balance From VT command from the Tools menu.' *l *0 lA@tIngudbIncludeD %.   chkIncZero %(``  chkIncZero %(`g ! Etf chkIncZero %!` '.9Checking that all TB headings are included in workbook... ( !'r,sch%` 3sch%,periodno% ^^ ^A@~^ ^$r  D ^$r'^gr' /Cannot find any trial balance headings in list. $ $' * *0 lA@0g  'IncludeZeros% = Trueer  (1000$A$1SectList 2%J%(` [company]$A$1SectList 2%J%(`,Triggers all TB functions to be recalculatedre B@(Review results lstHeadingResultD %%. ^^   GScheme and period deemed to be in use if more than 20% of headings usedad ^ $ '@ ^ $? ^$r 'J ^$R.4!loop through for missing headings  ^$r ^  $   4%T!`deleted d'* ^     4%T!`  $A@8 vt_recalc$@ ^ $   $a'* ^     4%T!`  $A@8g$g8g g%g` ( @mNo TB headings found. You should ensure that only one copy of the file 'VTLib.xla' exists on your hard disk.' *no *@ lA@wo Ja2Most TB headings are not included in the workbook.' *ot *@ lA@or *a-All TB headings are included in the workbook.' * *@ lA@`VTResultD %!  ( VT_Results$J.s  (  EWorkbook is protected. Cannot temporarily unhide sheet for printing.' * ' a7Cannot printout to earlier version 'account' workbooks.' *`Printing has failed.' *gri *0 lA@b`:bPreparing to print... (   :(@ $:!^ $    %T(`: $:!   %T(` $:!$Z   %T(` vt_recalc$@ $:!^ $  $:!NAME$   %T(`$ vt_recalc$@ $:!^ $  $:! $:!$   %T(` ( B@$2:$5000 %B@  (gg( B@rrg i (in  (('causes error if no formulae in workbookxp'er rn n :ntb!An unexpected error has occurred. $  $ Please notify VT Software.' *ut *0 lA@D(Cannot carry out command. $  $ FPlease ensure that a workbook based on an accounts template is active.' * *0 lA@lDkalResultD %B@kl vt_recalc$@ ^ $   $#,##0.00z ' @ ^ $   000z :  $Z:  N   B@ $ '$( $@: ^ $$:(^  $$:(ev  $$:(kP usGP Previous Year'ZntGPPrevious Period'ZGPMovement in Period'Zn GP Current Year'ZGPMovement in Year'ZGP Comparative'ZGPMovement from Comparative'ZjRe ^TBGP TB Scheme A$J.RGP TB Scheme B$J.RGP TB Scheme C$J.RGP TB Scheme D$J.Rje`  ^$R.4[   4%T!`  '`pgVTHE  ^+rk@ ! ! VTXLHELP.HLP'  B@okk' RRgrflagVTinuseflagpartflaglblCaptionlstHeadingslstHeadinglsellboxListBoxesAddItemRemoveAllItemsResultDOK_ClickHidePrintOutScreenUpdatingVisibleErrxlVertHiddenDeletexlVeryHiddeniResultsMaxPeriCountlboxiCountudtResultsbeginResultsGetPeriodwtbsapllicationDisplayAlertsiExistamtCheckAllHeadings_BooKErrorpsvt_abbreviatediHeadingNumberGetHeadingNooSheetheadingnameRTrimsHeadingNamef_B_var_LCase_B_var_RTrim_B_var_UCase(sTestNameiCounterMAXHEADLeftReferenceLeftCellPRightCellVTLIB.xla<I ?Z $@@ @( H  = Worksheet&Tools&WindowChart&Tools&WindowVisual Basic Module&Tools&Window\6 VT Softwareson B= _VBA_PROJECT HelpCom_Click=x<$p<W@"1Arial1Arial1Arial1Arial1Arial1Helv""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00!""#,##0.00;[Red]\-""#,##0.003*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-*)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-;,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-2+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-                + ) , *   Functions InclusionqIncludeD ResultD =&APage &P"\A??c>  =&APage &P"\A??c>  = Fn  dMbP?_*+%`,&APage &P",b??U `b@]t EA@@xh3Check All TB Headings Included] 7 A@@33"R chkIncZeroi"Report headings with zero balancesR]X:D CC@(xP4$ OK]\: DCC@(x4$ Cancel]:D CC@(x5$HcmdHelp49. Help]7 A@@?x`5a] i*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#C:\WINDOWS\SYSTEM\VBAEN.OLB#Visual Basic For Applicationsf*\G{00020813-0000-0000-C000-000000000046}#1.0#9#C:\EXCEL\XLEN50.OLB#Microsoft Excel 5.0 Object LibraryPQZ vtxlhelp.hlp >8 a2b3d79ddc 56383eaca4*D> 10b3e5e811 57383eaca4*DH*jb24N*@TDD.   4~tj*jt8R r~4X`x  lDT@P&JhJ@J~*t`J> (d+ Rb^4ZF JzRx^FV $hSHrfK~I \;Nlu2*hS] ctfjغh$f`4Ȳ8N^<T@Oj7FfFzRf($X1bs|. fãfWy=dV!u[+@f?:m#d ~ f(G4@<ffJP]\2h5$n[||TK̍'(ʜ0_f[|scf+m% &u4.Ì>f9zN.T! ^novVqzxozlʇ0fesWnmWzC Tt%^26FV6Tdl@x~'ra &T\NExcelVBABook2Module1_Evaluatevt_versionidvt_autohidevt_balancesgotvt_dblclickvt_comphiddenvt_printgroupvt_showcontentsvt_autoreevalSWITCHPlusTextMinusTextLeftRefrightrefLCaseSWITCH_errorTBReferenceSchemeLetterBHeadingNumberPeriodIDIsNumericPeriodNoMUCasecolnosParentWorksheetsCellsValueABTBErrorACAccountNumberGetPeriodNo IRangerAcErrorACCDaCurDepNumberACCDErrorSECTSectionNumberSectErrorSECTCDnSECTCDErrorReplaceTxtNmsgoldtxtAnewtxtposVTLIB.XLSVTPREP.XLS#_B_str_LCase _B_str_UCaseAdummyMsgBoxpStrIsEmpty_B_str_StrpIsMissingAuto_OpenCheckAllHeadingsvChrheadingno_B_var_ChrBeepcalcmodeyApplicationCalculationxlManualCalculateActiveWorkbookFunctionsInclusionGetTBSheetschWorksheetMaxHeadingsSetMaxHeadingsiMaxmxiMaxActHeadingsbUsediCheckingCheckAllHeadings_CleanupvalflagiIncludeZerosbCheckingbIncludeZerosMaxPeriodIncludeZeroselsifvt_recalcAscAddMissingItemPeriodheadname_B_str_ChrCheckAllHeadings_ErrorfinfunchkIncZerocmdHelpHelpCom_ClickHelpAppHelpFileppHelpFilePathPathSeparatordThisWorkbookDialogSheetsCheckBoxesxlOnxlOffShowStatusBarflaCheck that all TB balance headings are included in the workbook?> " = X  dMbP?_*+%`,&APage &P",??U `b@]|S*A@@%x\6Check All Headings Included - Resultse%]\GQCC@(x6$Close ]\G Q CC@(x 7$PPrint ]zG Q CC@(xd7$H79i$eHelp]0 A@@Qx@ lblCaptionThe following trial balance headings have not been used anywhere in the workbook:QA@]rQ( A@  lstHeadinga> "  Oh+'0@ X`| ,8VT Function Library(c)1994-9 VT Software Limitedni>Contains custom functions used by 'accounts' style workbooks.HPhilip HodgsCompObjEfonMicrosoft Excel@C"Wb~ ՜.+,00 8@ H   Functions Inclusion IncludeDResultD ModulesDialogs FMicrosoft Excel WorksheetBiff5Excel.Sheet.59q