ࡱ>   !  "7,$%&'()*+-./01234568;9:Root Entry FrZ:Workbook_VBA_PROJECT_CUR")WOrWVBA)W@PW  !"#%&'()*+,-./012356789:;<=>?@ABCEFGHIJKLMNOPQRTUVXYZ[\]^_`abcdefghijklmnopqstuvxyz{|}~ \p James Andrews Ba= ThisWorkbook=xx;T$<X@"1Arial1Arial1Arial1Arial1Arial"$"#,##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\);_(* "-"??_);_(@_)                + ) , *  " `1Sheet1 cor_coeff")Contains user defined function  cc    dMbP?_*+%"??U            >@&&&7 Sheet1 'i#xME ThisWorkbook $Sheet1 4Module1__SRP_2D(SLSS<N0{00020819-0000-0000-C000-000000000046}@(%@0]FxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2'i#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%@0]FxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU~| H\L3# (\l0 (\ll j\L3el(\@(\ @L @l \ L3l(\@(\ @L @< 0   `8 X(I@$ xIB( ID, X8xXxIF0 xIH4 IJ8 IL< IN8@ xx]F$*\Rffff*0Y465d8e6e*\R0*#13eB Px P 6x 0 8   P X @  `p(0 8 H Xhp       0@HPX ` p        08@H P ` p       (08 @ P `px kipx P 8ot(I :$0' k  ' ecdI Looks for a value in a group of up to 12 cells and returns the number ofI times the value is found. Required inputs are 1 lookupvalue and 1 cell. P :zHk@ <$0 P <, Ce  ' . kd0 Syntax: Checklist(value, c1, c2, c3, . . . c12)zHk@ >$0 P >  ' kdzk @$0 P @  ' kdzk B$0 P B  ' khd`zXkP D$0 P D  ' kdzk F$0 P F  ' kdzk H$0 P H  ' kxdpzhk` J$0 P J  ' k(d zk L$0 P Lx  ' kdzk N$0 P N  ' kdzxkpdh' XKAttribute VB_Name = "Module1" Function Checklist(value, c1, Oplal c2 3  4 5 6, _X G7 8e 9 10 12)U' Looks for a"  in group of to 12 cells and returns the numb er'time &.und. Require"d0put%re 1 l@up.14.'Syntax:ct. ckI fl= The^n ـ1 Ehlse0@IfC@Not (IsMissing(c2))"2#&+ & EH*Exit~ E% +3]+3++IW4+4׿++55c A=AA66l77߁,x( L(\<(, ((Ό| \(lL<$(, ((,(Ό|0\(lL<4(, 8(6|<|<\L<,  $(,|0lL4\<8, (|6< |L< |                       '                        '    '\`Attribute VB_Name = "Module2" Function Cor_Coeff(x1, x2U 3 4 56U78910R_ *\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:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL#Microsoft Office 11.0 Object Library ]FiThisWorkbook0T465d8e6eThisWorkbook- Sheet10U465d8e6e Sheet1-Module10Y465d8e6eModule1#`3Module20k465d9176VModule20H`0`sE ޳z E' \E%ygNymqbz6P9F冃orx(3 bDElseQf_IfThen Excel+ VBAWin16~Win32MacVBA6#Project1  stdole` VBAProject Officeu ThisWorkbook| _Evaluate Sheet1Sheet2Sheet3 Module1b (Checklist[aXcZd[e\g^h__B_var_FunctionO IsMissing _B_var_ifPCheclistg_B_var_Checlist/c1\c2\c3\c4\c5\c6\c7\c8\c9\c10zc11zc12zvalueK WorksheetWorkbookk Module2cCorNCor_Ch (Cor_Coeffa1k\a2l\a3m\a4n\a5o\a6p\a7q\a8r\a9s\a10$p _B_var_a105-a11%pb1\b2\b3\b4\b5\b6\b7\b8\b9\b10}ub11~uSxx1 _B_var_SxxBSx,_ _B_var_Sxx1_x2_x3_x4_x5_x6_x7_x8_x9_x10#x11$y1O_y2P_y3Q_y4R_y5S_y6T_y7U_y8V_y9W_y10y11s1_s2_s3_ _B_var_s3s4_ _B_var_s4Syy _B_var_SyyВsjs5 _ _B_var_s5xoyls6 _ _B_var_s6Sxy. _B_var_Sxy? _B_var_s1 _B_var_s2lWHG0* pHd VBAProject4@j = r ]F 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\OFFICE11\MSO.0DLL#M 1@1.0 Ob LibraryKEiThisWorkbookGTisWrkbUo 2 QHB1Bx-B,!"B+BB|Sheet1G S@#e@Xt1H2NModule;du32O3O9#!E92G2:O$2OOI% K*yrU~~~~~~~~h )N?)Esa)f%    a pa Q ) ThisWorkbookSheet1Module1Module2 VBAProjectF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA I q0F4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel Ai@0FC:\WINDOWS\system32\stdole2.tlbstdole QyPL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLLOffice a` Checklist VBE6.DLL P  Cor_Coeff2rU  valuec1c2c3c4c5c6c7c8c9c10c11c12x1x2x3x4x5x6x7x8x9x10x11y1y2y3y4y5y6y7y8y9y10y11-ThisWorkbookThisWorkbookSheet1Sheet1ModuPROJECTwmnPROJECTSummaryInformation(DocumentSummaryInformation8le1Module1Module2Module2ID="{9E29704F-8140-402C-86D3-BA37AC62B1AD}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Module1 Module=Module2 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="C6C414501CD0E6D4E6D4E6D4E6D4" DPB="8C8E5EA6E26DE36DE36D" GC="525080E447E547E5B8" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Module1=16, 72, 836, 543, C Module2=16, 12, 1041, 538, Oh+'0@HTl James AndrewsMicrosoft Excel@(@9W՜.+,0 PXd lt|  Sheet1  Worksheets F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89qCompObjm