ࡱ>  4;! "#/%&'()*+,-.01235F6789:<=>?@ABCDEGIHRoot Entry FT"2Ɂ7Workbook._VBA_PROJECT_CUR" `}ɁVBA@&趁 `\pAndrew Zimmerman Ba=  ThisWorkbook=hix<(8X@"1ZCalibri1ZCalibri1ZCalibri1ZCalibri1ZCalibri1ZCalibri1ZCalibri1 ZCalibri1ZCalibri14ZCalibri1 ZCalibri1ZCalibri1ZCalibri1,8ZCalibri18ZCalibri18ZCalibri1>ZCalibri14ZCalibri1<ZCalibri1?ZCalibri1h8ZCambria1ZCalibri1 ZCalibri"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.005*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)72_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)61_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0.00 mm/dd/yyyy                                                                       ff         P  P        `            a>  ||>pB}-} 00\);_(*}-} 00\);_(*}A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef ;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L ;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A}  00\);_(*23;_(@_) }A}! 00\);_(*23 ;_(@_) }A}" 00\);_(*;_(@_) }A}# 00\);_(*;_(@_) }A}$ 00\);_(*;_(@_) }A}% 00\);_(*;_(@_) }A}& 00\);_(*;_(@_) }A}' 00\);_(* ;_(@_) }A}( 00\);_(*;_(@_) }}) }00\);_(*;_(@_)    }}* 00\);_(*;_(@_) ??? ??? ??? ???}-}/ 00\);_(*}A}0 a00\);_(*;_(@_) }A}1 00\);_(*;_(@_) }A}2 00\);_(*?;_(@_) }A}3 00\);_(*23;_(@_) }-}4 00\);_(*}}5 ??v00\);_(*̙;_(@_)    }A}6 }00\);_(*;_(@_) }A}7 e00\);_(*;_(@_) }x}800\);_(*;_(  }}9 ???00\);_(*;_(??? ???  ??? ???}-}; 00\);_(*}U}< 00\);_(*;_( }-}= 00\);_(* 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L湸 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ٗ % 60% - Accent3M( 60% - Accent3 23֚ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%3Normal % 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`i,Sheet2gccBĘ7ɹq1  {-  dMbP?_*+%,&ffffff?'ffffff?(?)?",Ę7333333?333333?t&<3U>@7 Sheet1ggD Sheet1 ThisWorkbook$__SRP_2__SRP_3Ig  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHJLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~'\l#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0brHxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2="TEXT;" &1, _/estinB%:=Range("$A$x1")@l=TrialBalancAq@B FRAAsFRowNumberēCAlAdjntFormula serveat-gefreshOnVXERStyxlIntDeleteCellD.SavePaspsworem D8ata/@dColumnWid@6\= dPmo 02.TextaP`aptOnd7&vf'@437P Sb111 arseTypcrip? t"y?  9 2 ; }0* ?r $ "| or"), "Ib'xl@Cc p0 e 0F~Debits 0 O vd #AO Fp!>dV l %% . .RX?.$?< !3AxisLayoutnvt`aTShowB LRi= k'a!PYhe mEy B:F@##rv3"$#,# #0.00C'sw pau ֱ (4, 6i"D4H5PR1C1Q=if( or( RC[-4] >kChr$(x34)``(Q5_ Y05a3]+a2]-a1]6: bOer Integer7 u 6 To 2# c$, 2p " Or 1? -!;E5ҧ0w,IfNP5ollap0aa#&r Range("A4").ShowDetail = False  'ActiveSheet.PivotTables("01~AField4A@ccount _End Sub 1*#rU 0N )Y1 Y  y I 1 q I  Q Y qYAi!I Ia 9q IY!9$4!aI` J 24 '8%'H%'X%'h%x! x ()x4:h%x! 8xx]:H%x'X%:h%$ Qxo$%4! 84W  q46$:h %lC ch%lCfh%lCfh%lC ch%lCfh%lCh%lCfh%lC ch%lC ch%lC(h%lCfh%lC(h%lC(h%lCh%lCh%lCfh%lC ch%lCfh%lCfh%lC fh%lC!hlRXlR(HlR(8lR(lR((?M\ƙu#<bK-I(J啻Fo9@9B F9D J9H9L9N9P9R9T X XD9V9Z^C@\qadd the summary sheet B@Summary ( Detail!A1:A1$&!`A1:A1$&(` Detail!B1:B1$&!` to  Detail!C1:C1$&!`A2:A2$&(` fd Detail!1:1$&B@bcreate the pivot table report  Summary!R3C1t PivotTable1v zx nlDetail!TrialBalanceDetailp h!j%B@r>ActiveSheet.PivotTables("PivotTable1").InGridDropZones = FalseIActiveSheet.PivotTables("PivotTable1").TableStyle2 = "PivotStyleMedium25"Account PivotTable1 %|%~ 99q@ Description PivotTable1 %|%~ 99q Prior PivotTable1 %|%~ Prior Balance  PivotTable1 %|B@ Debits PivotTable1 %|%~ Debits  PivotTable1 %|B@ Credits PivotTable1 %|%~ Credits  PivotTable1 %|B@ PivotTable1 %|! 99qxAActiveSheet.PivotTables("PivotTable1").RowAxisLayout xlCompactRow h(format the money fields $#,##0.00B:F$(set formula for ending balanceEnding Balance$(`=if( or( RC[-4] > "$ "$  , RC[-5] > "$ "$ ), RC[-3]+RC[-2]-RC[-1], "$ "$ )$(]@  N $!` $!`   $! $(dPyHk@ collapse the Account fieldA4$&(WActiveSheet.PivotTables("PivotTable1").PivotFields("Account").ShowDetail = Falseo] !' FalseG|j TEXT; "$A$1$&$ ! %`jAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomi6zD2P Sub _Open() 'add the Detail sheet and import raw dm fro@m ABC s-delimitDfild'first line Hcon%nsm@pany n,0 sta'%e, e/?sedfieldPs SKs.AddAct{AB.ŀC0o D0im F&Asd Sng= Application.GetAEAA, If]" Then 0ExitU With %Quer yTAb-(Conne-on:lR(lR$ "Z$lC#5$ ch%lC$fh%l%& q24 '8%'H%'X%'h%x! x ()x4:h'%x! 8xxOx'X%:h(%$ xa$%4'8%:H)%$ 4,)x45$x'X%:h*%$ xa$:H+4'%:8,%$ 4a%'%:-%$ ,)x46$7H%x'X%:h.%$ x ux:/%:0%%h%:H1%4x$ Hx D4$2,)x45$::H3%:h0%x! 8x$4B5hhqdx5$h%ldC6(h%ldC7 qd::H8%:h0%x! 8x$4B5TTqPx5$h%lPC6(h%lPC7 qPl:H9%:h0%x! 8x$4B5%::%x%:0%4! 844;)x46$l:H<%:h0%x! 8x$4B5%:=%x%:0%4! 844;)x46$l:H>%:h0%x! 8x$4B5%:?%x%:0%4! 844;)x46$2:h0%x! 8x$4A@00q,x5$h%l,C6(h%l,C7 q,x$ Hx x3:HA%:hB%x$ `x$CCx5$9:D%(h%(H%x$ Xx$CEx5$F" G#(*#$" G# *#H*#" G#*#" G# *#I*#" G#*#" G#*#J*F$%(h%(H%x$ XxCK2($  x6$ Ncq kDh%(H%x$ Xx$AE:L]pkD%(%4$ X4AE:xL]p)x46$^ pkDh%(H%x$ Xx$AK%kD%(%4$ X4CK)x46$e q  d^*fH%x'X%:hM%$ x,Ix 4hT0v($  x4$4XrU @$`na  *\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{000208_VBA_PROJECTKdir__SRP_0 __SRP_1j13-0000-0000-C000-000000000046}#1.6#0#C:\Program Files\Microsoft Office\Office12\EXCEL.EXE#Microsoft Excel 12.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.4#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL#Microsoft Office 12.0 Object Library  brH\ Sheet10149da341c Sheet1l-ThisWorkbook0549da341cThisWorkbooku8H!{Epch?D졺\]3Excel+VBAWin16~Win32MacVBA6# VBAProjectstdole`OfficeuSheet1 _Evaluate ThisWorkbook| Workbook_OpenSheets Addr ActiveSheet%N QueryTables Connection DestinationлRange  FieldNamesܸ RowNumbersFillAdjacentFormulasPreserveFormatting=RefreshOnFileOpen|u RefreshStyler3xlInsertDeleteCellsG SavePasswordXSaveDataAdjustColumnWidth RefreshPeriod&TextFilePromptOnRefreshTextFilePlatformJRTextFileStartRow1TextFileParseTypeC xlDelimitedTextFileTextQualifier/xlTextQualifierDoubleQuoteTextFileConsecutiveDelimiter_=TextFileTabDelimiterWTextFileSemicolonDelimitereTextFileCommaDelimiterbTextFileSpaceDelimiterTextFileColumnDataTypesN| xlTextFormat3TextFileTrailingMinusNumbers*oRefreshBackgroundQueryValueKDeletexShiftxlUpActiveWorkbook PivotCachesJ SourceType xlDatabasem SourceDataCreatePivotTable TableDestinationi TableName` DefaultVersion^ xlPivotTableVersion10u PivotTablesw PivotFields Orientationw xlRowFieldrPosition AddDataFieldYxlSum~DataPivotField xlColumnFieldWShowPivotTableFieldListColumnsp9 NumberFormatRCells FormulaR1C1SChrK~counter ShowDetailFModule1bMacro6NModule2cMacro1N SelectionZWorkbookk_Defaultj _B_str_Chrm# WorksheetSheet2Sheet3FileNamej Application*GetOpenFilename]?T   $0* pHd VBAProject4@j = r brH J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE12\MSO.0DLL#M 1q Ob Li`braryK\Sheet1GSeft1T2NHB1Bo-B,l"B +BBThisWorkbook(G@T@isWurkbo 2 I$$u$B&K*rU~~~~~~~~~b 2-KWtbXa   A i  ) VBAProjectSheet1 ThisWorkbookModule1Module2F /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA Y `F4C:\Program Files\Microsoft Office\Office12\EXCEL.EXEExcel Qyp0FC:\WINDOWS\system32\stdole2.tlbstdole aL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLLOffice aFbK-I(J啻Fo  , RC[-5] >  2), RC[-3]+RC[-2]-RC[-1],  )FormulaR1C1  A4VBE6.DLL qY q Sheet2Sheet3 rU~}  !pThisWorkbookThisWorkbookSheet1Sheet1ID="{1860D621-E844-4402-83E5-36CEC8E12568}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="F4F657B95PROJECTwm>PROJECT SummaryInformation(DocumentSummaryInformation87DD5BDD5BDD5BDD5B" DPB="1416B799F7B8F8B8F8B8" GC="343697F99718981898E7" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=22, 29, 884, 641, Z Sheet1=0, 0, 862, 612, Oh+'0@Hd Andrew ZimmermanAndrew ZimmermanMicrosoft Excel@=@h՜.+,0 PXl t|  ABC Softek Sheet2  Worksheets F&Microsoft Office Excel 2003 WorksheetBiff8Excel.Sheet.89qCompObjr