ࡱ> v  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuwxyz{|}~Root Entry FRVWorkbook*h_VBA_PROJECT_CUR"('RVBA@8 (.@`\p Sam Foster Ba= ThisWorkbook=x[;8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1& Baskerville1& Baskerville1& Baskerville1Arial1Arial1Arial1hCentaur1Arial1& Baskerville1& Baskerville1Arial1Arial1Arial1Arial1& Baskerville1Arial1 Arial1 xMS Serif1Arial1Arial1Arial1Arial1Arial1 xMS Serif1Arial1* MS Sans Serif1Arial1* MS Sans Serif1Univers1Univers1 Arial1 Arial1 Arial1Arial1Arial1Arial1$Arial1 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\);_(* "-"??_);_(@_)m/d mmmm\-yyA<_("$"* #,##0.000_);_("$"* \(#,##0.000\);_("$"* "-"??_);_(@_)C>_("$"* #,##0.0000_);_("$"* \(#,##0.0000\);_("$"* "-"??_);_(@_) 0.0%mmmm\ d\,\ yyyy yyyy3._(* #,##0.0_);_(* \(#,##0.0\);_(* "-"?_);_(@_) 0.0000000 0.00000000 0.000000000 0.000000 0.00000 0.0000 0.0000.00_);\(0.00\) "$"#,##0.00#,##0.0_);\(#,##0.0\)0.000000000000000%0.00000000000000%% "$"#,##0.0_);[Red]\("$"#,##0.0\) 00000#,##0.000_);\(#,##0.000\)83_(* #,##0.000_);_(* \(#,##0.000\);_(* "-"??_);_(@_):5_(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"??_);_(@_)4/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_)                + ) , * / 0 %      #  ! # +  # +   +" +  ! '    & &  #@@  #@  #  @  #@  #  # + # +# # # @ # # " + #@ + # +#@ +# +# +#@ +# #@ # #  # 1"@ @ 1"@ "@ "@ 1"@ "@ #"@  "@  " @  @@  @   @  @    @   @   , $`! &a h $a h &a#x $a l $` $h!   "   ) )# * )" *  ) " "  s ""@ @  #    # & &  #          #  &  &    ! " & #  " " "   &          &  &  +&  &   &     & &     & & & & & & & +& +& '& '& " & &  2 & +& +& +& "     +& & " + & +&   #  "   # '& & " &  ,& & & 1"  " " '& ,& &  1" " '# ! &     " +& & & & '! # & & & "    & &     2 & # & #  #  +&          @  " "   ""@ @ ! 1"@ # "#@@ "#@ "#  @ "@ "#@ "# "# "@ +"#@ +"# +"# 1"@ + #@ + # + # # +#@ +# +# +# #@ # # "@ ,#  # #"@ # @ # #  #"@ '#"@ 1"""@ @ '"@ "@  r#""@ @ #"@ # 1&""@ @ + "@ ""@@ " " @  "@  "@   # & & # & +  & +#  +    #   "         A # !       &  # #  +! ,& ,& ,&` ,&` - # ( '( ) #( ( (( "@ " @  H  L  L  L  L  H 1r"@ @ 1"@  L " #  . . " " " " " " " "  Normal_Company Info8 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`k READ ME !!!!!bt Data Entry> SSG (pg1)P! SSG (pg2)w get quotew CalculationsR SSG RAW FILE, Average0 Average1 Average2 Average3 Average4 Average5 Average6 Average7 Average8 Average9+ Book1_Sheet1_List; dataget:q$EPS_Exp_Growth: " EPS_Hist_avg: # EPS_Preferred: &EPS_Str_line_fit: $EPS_Two_pt_avg: ! EPS_YBGuess: % Get_data_from_Internet getdatafromxls! No_of_years: OpenSSGFileDialog  ;/  ;:   ;L?% quotes?IM_quotes_symbol_hd_type_Quote;F Restore0 Restore1 Restore2 Restore3 Restore4 Restore5 Restore6 Restore7 Restore8 Restore9&Sales_Exp_Growth:$Sales_Hist_avg:%Sales_Preferred:(Sales_Str_line_fit:&Sales_Two_pt_avg:# Sales_YBGuess: sharesplit`ijb(1#.3  @@   Company Prepared By High PriceDate Low PriceData taken fromEarnings Per Share EPS trendSymbolDividend Per Share Where Traded Sales trendMain product/service(Total Preferred Shares Outstanding (mil)Income Tax Rate (%)%Total Common Shares Outstanding (mil)Total Debt ($mil)Quarter EndingEPS Latest QuarterEPS Year Ago Quarter Current Price52 Week High Price52 Week Low PriceLatest Data YearRecent Severe Market Low Price'NAIC Preferred Procedure to Project EPS5yr Projections for:% Pre-Tax Profit'Weighted average of the last five years Tax Rate (%)Number of Preferred SharesNumber of Common Shares Estimated EPSRECENT QUARTERLY FIGURESCAPITALIZATION Authorized OutstandingSALESEPS PreferredLatest QuarterCommonYear Ago QuarterPercentage ChangePotential Dilution. VISUAL ANALYSIS of Sales, Earnings and PriceHistorical Sales GrowthHistorical EPS GrowthEstimated Future Sales GrowthEstimated Future EPS Growth EVALUATING MANAGEMENTLAST 5 TRENDYEAR AVGUPDOWNAB4PRICE-EARNINGS HISTORY as an indicator of the future PRESENT PRICEHIGH THIS YEAR LOW THIS YEARPRICEEarningsPrice Earnings RatioDividendYearHIGHLOW Per Share% Payout % High YieldTOTALAVERAGEAVERAGE PRICE EARNINGS RATIOCURRENT PRICE EARNINGS RATIO0EVALUATING RISK and REWARD over the next 5 yearsHIGH PRICE - NEXT 5 YEARS Avg. High P/EXLOW PRICE - NEXT 5 YEARS(a) Avg. Low P/E=(b)(c) Present Divd.(d) High YieldSelected Estimated Low Price =CZONING1/3 of Range = Lower 1/3 =to(Buy) Middle 1/3 =(Maybe) Upper 1/3 =(Sell)Present Market Price of is in therangeD9UP-SIDE DOWN-SIDE RATIO (Potential Gain vs. Risk of Loss)EPRICE TARGET (Simple Interest)5-YEAR POTENTIAL"AVERAGE YIELD OVER NEXT FIVE YEARS$Avg. Earnings Per Share Next 5 Years,ESTIMATED ANNUAL RETURN OVER NEXT FIVE YEARSdivided by 5 ==Est future Sales growth rate via the Straight Line Fit method%6:Est future Sales growth rate via the NAIC Preferred method%3>Est future Sales growth rate via the Exponential Growth method%7?Est future Sales growth rate via the Two-Point Averaging method%8*Historical Sales growth rate for the last (Historical EPS growth rate for the last 8Est future EPS growth rate via the NAIC Preferred method#1<Est future EPS growth rate via the Exponential Growth method#5=Est future EPS growth rate via the Two-Point Averaging method#6;Est future EPS growth rate via the Straight Line Fit method#4"Recent Severe Market Low Price = Price Dividend Will Support #Avg Low Price of the Last 5 Years =High Forecast Price, Minus Low Forecast Price, Equals Get this ?????? 5 Year Appreciation Potential Average Yield +Total Annual Return for 5 Years (average) ESTIMATED APR AND RETURN X Avg. % Payout ;% Pre-tax Profit on Sales (Net Before Taxes / Sales)Market Capitalization ($mil)Relative Value = < 100% is DESIREDMarket Capitalization% Return on Shr. Equity ROEAPR% Total Return[G][C][D][I]Net Profit ($mill)(Value Line)Sales or Revenues ($mill)Sales ($mill) Latest QuarterSales ($mill) Year Ago Quarter WANT > 3 TO 1 WANT >15%PTo Calculate the Earnings Per Share (EPS) five years from now do you wish to use!)ITo Calculate the Sales growth rate five years from now do you wish to use!".Est future EPS growth rate via Your Best Guess0Est future Sales growth rate via Your Best Guess! Total DebtBook Value Per ShareBetaRevenues ($mill)6% Returned on Equity (E/S / Book Value)1/4 of Range = Data for the graph on SSG(pg1)Strong Buy Under Strong Sell Over = Forecast High PRICEEstimated High Earnings/Share Estimated Low Earnings/Share Minus Present Price Minus Low Price Present Price High Price INVEST THIS Appreciation Present Market Price Present Full Year's Dividend Present Price of Stock /Present Yield or % Returned on Purchase Price IgnoreDO NOT MESS WITH THIS PAGE # of OLD # of NewLow Price (Oldest Year)Sales (Oldest Year)SalesTax Rate (Oldest Year)Tax RatePreTax Inc (Oldest Year) PreTax IncNet Income (Oldest Year) Net IncomeBook Value (Oldest Year) Book Value Earnings per Share (Oldest Year)Earnings per Share Dividend per Share (Oldest Year)Dividend per Share Current P/ECurrent DividendLast yr of dataNo of Data Years Used 52 Week high 52 Week low Number common shares outstanding #auth. common #pref shares #auth pref Total debt Pot. dilutionLatest quarterly salesYear Ago quarterly salesLatest quarterly E/SYear Ago quarterly E/Slast CY of data +5Outside e/s estChoice low price (5Yr Avg Low) Choice hi PE Choice low PEAdd/Delete flag Low e/s est.Qtrly e/s growthProj e/s growthQtrly sales growthProj sales growth Current yield Avg. yieldHist. e/s growthAvg PE U:D ratio5 yr. sales est.Avg pre-tax prof.Income tax ratePref. dividendsProj. liabilitiesProj. out. sharesPref. proc. e/sVisual e/s est.Last CY trend e/sHist. sales growthAvg. ROELow price est.Avg. price est.Sell level priceProj. div payout% Previous E/S New EpS estProj. hi price Current CashCurrent Accounts ReceivablesCurrent InventoriesCurrent assets!Short Term Debt (Sum Last 4 Qtrs)Current liabilitiesYear Ago Current CashYear Ago Accounts ReceivablesYear Ago InventoriesYear Ago Curr assetsYear Ago Debt Year Ago Cur liabilitiesTotal capitalizationLong term debt (Oldest)Long term debt"Number shares outstanding (Oldest)Number shares outstandingCash flow/sh (Oldest) Cash flow/sh Total assetsInterest coverage % Total returnProj. e/s growthsevere low price R squaredReservedQuarterly Sales (Oldest)Quarterly Sales Quarterly E/S (Oldest) Quarterly E/SQuarterly Dividends (Oldest)Quarterly DividendsINSIDE OWNERSHIPINSTITUTIONAL HOLDINGS#Ace 5 Year Estimate E/S Growth RatePREDICTABILITYLT DEBTFiscal Yr end MonthNameExchange Data sourceDate of data Creationv-l pagecode Reserved industrySplit Ratio During QuarterLatest Quarter Ending DateMonth of Latest Quarterly DataYear of Latest Quarterly DataSoftware Version Sic CodeS & P Stock RankFinancial strength VL Safety VL!Quarterly Pre-Tax Income (Oldest)Quarterly Pre-Tax Income 'Quarterly Pre-Tax Income (Most Recent)Quarterly Net Income (Oldest)Quarterly Net Income "Quarterly Net Income (Most Recent)+E/S in 5 Yrs. Based on Ace Proj Growth RateHistorical 5 Yr E/S Growth RateCurrent PE/Ace 5 Yr Growth rate S&P Rating Avg 5 Yr PEProj 5 Yr High Price%Proj Compounded Appreciation of Price Current YieldProj Total Return"Historical 5 Yr. Sales Growth Rate$Historical 5 Yr E/S Growth R-SquaredIndustry Group% Off 52 Week High Price% Above 52 Week Low PriceRelative Value PE/Avg ROEDebt as % of CapitalNext Year E/S estimate'Historical 5 Yr. Sales Growth R-SquaredKNOWN PROBLEMS:`The Visual Analysis chart will give an error message "Negative or zero values cannot be properlyl charted on a log chart" if any of the revenues, earnings or pre-tax profit figures are zero or negative.aI have attempted to make the workbook useable for both user-contributed datafiles in the SSG Filec Library, which have the user's projections, as well as the Undervalued Stock and Stock to Studya Datafiles on the NAIC Web Site, which do not have judgement. However, this may cause trouble in some circumstances.dIf less than 10 years of positive earnings and sales are included in the data, some calculations may/ display errors in Excel (#NUM! or #DIV/0!).High Price (oldest) High trend< Low trend_You should always make your own judgements about a company's future growth and price potential.dThis workbook will read *.SSG datafiles, the default file format of NAIC's SSG software programs. Itb*.SSG files are available from several online sources, and investors often share their analyses by,e-mailing, or downloading, these data files.XFrom your SSG program, you can export a *.SSG file, which may then be imported into this2spreadsheet and converted to a readable text file.\To use the workbook, click the Import SSG File button on the Stock Selection Guide Page, anddselect the *.SSG file you wish to view. All data will be imported and all calculations will be done.mrequires Excel 5.0 or later. Mainly it provides a format that uses formulas that the NAIC organization uses.G(www.better-investing.org) It has been tested on Excel for Mac as well.(e)Projected Low Price =[P]'a (G)rowth, an (I)ncome, a (C)yclical,#a Cyclical but the maket is (D)own,or use (P)rojected Low Price?   the NAIC (P)referred method, $ the Exponential (G)rowth method, % the (T)wo-Point Averaging method,  & or the Straight Line (F)it method, # the Straight Line (F)it method, 6 OR use the (Y)our Best Guess that you entered above? DO NOT USE********************* THE MORE YOU USE THE AVERAGES, THE LESS ACCURATE YOUR RESULTING DATA WILL BE!!!!!!!!!!!!!!!!!!!! **********************YIs this stock;(used for the low price)(used for the high price)FPlease report all errors and/or glitches or suggestions to Sam Foster.PEG(By Sam Foster (sfoster@anythingetal.com)Some Macros were obtained from Douglas Gerlach (by permission) (Ver.2.2)(gerlach@better-investing.org) and the original layout of the charts from R. Beaubien (Rev. 1.52)(bad email add.)This program and / or any part of this program and any formula are for use as a tool by the USER HE(S) ASSUMES ALL RISK and the originators (Foster, Gerlach, and Beaubien) hold no liability for any results obtained from the use of this or part of the program.\#`a#xGCurrent Volume Ticker Symbol Version 5.1SSG-XLT-51.xlt NewsChart SEC FilingsProfileConference CallsHomeMarketsOptionsHighLowOpenBidAskMore...ResearchFreeRealTime.com FRT Express FRT Stream | Insight CommunityTools Join for FREE Why Sign Up?Quote Time&Sales MessageBoardMultexInvestorForgot Your Login? Latest News PR Newswire Business Wire intermoney Market UpdateBefore the BellAfter the Bell WatchList ETF Center Most ActivesPercent Gainers Market PlaceTrader's LibraryHelpPortfolio Tracker BullsessionSearch SEC Filings IPO ExpressDJIANasdaqS&P 500 30 Yr Bond 10 Yr BondLast Change (%)After Hours Chg (%)** Trade TimeExchange Quote Bid (size) Ask (size)N/A Day Volume Last Size Latest Ticks # of TradesAvg Trade SizeVWAP 52 Wk High 52 Wk Low Prev Close Avg Day VolR** Represents the price change since the close of normal trading hours at 4 pm ET.Exchange market data provided by DTN Market Access. Data and information is provided for informational purposes only, and is not intended for trading purposes. Neither FreeRealTime.com nor any of its data or content providers shall be liable for any errors or delays in the content, or for any actions taken in reliance thereon. By accessing the FreeRealTime.com site, a member has agreed to the FreeRealTime.com Member Agreement.ACopyright 1998-2003 FreeRealTime.com, Inc. All rights reserved.0User Agreement, Privacy Statement, Version 3.50 0 (0)Nforgot your login? - my member info - help - site map - about us - contact us #Markets are closed for the weekend.More ACS+ Pre-Announce $7 TRADES!Pick of the DayI View WatchList Edit Watchlist Symbol Search Portfolio Tracker6AFFILIATED COMPUTER SVC - New York Stock Exchange: ACSReal-time ECN Quote* 0.09 (0.16)0 (0.00)=-== P/E RatioMarket Cap (mil)* A Real-time ECN Quote is a real-time quote from a participating ECN (Island, Instinet) and does not necessarily represent the best bid or ask in the marketplace. ECN's (Electronic Communications Networks) are electronic marketplaces that match buy and sell orders with each other.+7:13:01 PM EST - Saturday, January 17, 2004 FRT Express![7:13:02 PM EST - Saturday, January 17, 2004- Exchange quote is delayed at least 15 minutes.AScottrade: $7 Trades, Fast Executions, Real-Time Account BalancesPZSSG-XLT-R51.xlt Sam Foster (Rev. 1.52 by R. Beaubien) 1-14-04 [sfoster@anythingetal.com] 6 :7w728w99%:";_;<>< =Gs==>@0 >B{ HC C D E1FoGHSHoII5JBKKSLL%MvNN3O=PzPQRfSoTV XZ^\y]_1`L p` ` Gab a ?bZ b c c wfRgmqi (.@ &Bpst  dMbP?_*+%M\\192.168.1.151\SHARP AL-1540CS odXXLetterSCPI&SHARP AL-1540CS odXXLetterH ff**** o****d"ArialdXffff  ffb@222222< Username unknownJobname unknown`@< dSC0C"dhh??cU} \M&   ; Mw Nv Op Mq MS MZ M[ MT MU MV MW MX MYP QR RF MG MH MI MJ MK ML MM MN4, "u% "Mr %MnD>@%7 Sheet6 (.@ $y "  dMbP?_*+%&A&?'?M\\192.168.1.151\SHARP AL-1540CS od,,LetterSCPI&SHARP AL-1540CS od,,LetterH ~ 33**** o****d"Ariald,3333 ~ ~ 33 @222222< Username unknownJobname unknown`@< dSC0C"2,,??cU} $%} $}  } $ }  } $             @           [" D   D D D  D  D  D  D  D D$? D$@ D$@ D$@ D@ D  n& XDD?DA @(DD?@DBn& XDD?DA @(DD?@DBn&$$ XDD333333?DA @(DD333333?@DBn&d( XDD?DA @(DD?@DBB[, ,ZA @@:B eP  n&0 XDD?DA @(DD?@DBn&4 XDD?DA @(DD?@DBn&8 XDD333333?DA @(DD333333?@DBn&< XDD?DA @(DD?@DBB[@ ,Z'A @@:'B- eQ  \&TD FDZ9DA @@DZ9DB\&H FDZ9DA @@DZ9DB\&L FDZ9DA @@DZ9DB\&P FDZ9DA @@DZ9DB\&T *FDZ9DA @@DZ9DB e u  $      %%%%%   \ $      %%%%%   \&X FDZ9DA @@DZ9DB\&\ FDZ9DA @@DZ9DB\&` FDZ9DA @@DZ9DB\&d FDZ9DA @@DZ9DB\&h FDZ9DA @@DZ9DB e  $'%%%%   $ %%%%%    l   R  HLLA@--------------------@LLB-------------------- ,   -------------------- -   --------------------    -------------------- 4   -------------------- H  -------------------- Kt   --------------------    --------------------    --------------------    -------------------- (%%%%     ^i ^^^^^^^^^   k fl --  )  _N ,5$ 8D  D D D tD  BD   Bad Data! DD " DD " DD" DD" DD" DD B Bad Data!  .u  -- )8 D D D D `D  <D  Insufficent Data!5 years."6 years."7 years."8 years."9 years." 10 years.BInsufficent Data!N,\ 8D  D D D tD  BD   Bad Data! DD " DD " DD" DD" DD" DD B Bad Data! .t --p  CInsufficent Data!  ` sf Z0Z' Try a Different One!!!!  BA @HZ0Z' Try a Different One!!!! @"BTry a Different One!!!!i L SD.DA@n/a$D.D@Bn/a  )v)/+DD )q  ea +U D D <D D D  [D   Bad Data!9% `$`T$b4D"9% ``$`$b4D"9%`$`%b4D"9%`%`t%b4D"9%`%`%b4D"9%` %`p&b4DB?@@@@$@?@@@@@&@?@@@@@@(@?@@@@@@ @*@?@@@@@@ @"@,@ ?@@@@@@ @"@$@.@ Bad Data!  )w)++  D D <D D D  [D   Bad Data!9% `|&`&b4D"9% `&` 'b4D"9%`'`l'b4D"9%`x'`'b4D"9%`'`P(b4D"9%` \(`(b4DB?@@@@$@?@@@@@&@?@@@@@@(@?@@@@@@ @*@?@@@@@@ @"@,@ ?@@@@@@ @"@$@.@ Bad Data! )r  +# D lD $D D D  XD   Bad Data!6% B% B@"0% B% B"6% B% B @"0% B% B"6% B% B@"0% B% BB Bad Data!  )x+  D lD $D D D  XD   Bad Data!6% B% B@"0% B% B"6% B% B @"0% B% B"6% B% B@"0% B% BB Bad Data! )s  ;J + D sD ,D D D  WD   Bad Data!5% b1`(D"5% b1`(D"5%b1`)D"5%b1`()D"5%b1`@)D"5%b1`X)DB.@?.@?.@?.@?.@?.@? Bad Data!  )yJ+F0  D sD ,D D D  WD   Bad Data!5% b1`p)D"5% b1`)D"5%b1`)D"5%b1`) xD"5%b1`)0D"5%b1`)wDB.@?.@?.@?.@?.@?.@? Bad Data! )p  b fm   c~    )~   ) ! d  FD * Use DZ D?dA.% to equal Your Projected High Price for year DAEnter in more DataxUse DZ D?dA.% to equal Your Projected High Price for year DBEnter in more Data " e # gg$l Q@Est. Number of Preferred Shares Outstanding (mill) for the year D@DAEst. Number of Preferred Shares Outstanding (mill) for the year 5%  d dd$ N=Est. Number of Common Shares Outstanding (mill) for the year D@A>Est. Number of Common Shares Outstanding (mill) for the year 5% b&?'?Ep/Sales or Revenues ($mill) for D@"Sales or Revenues ($mill) for 5( c;%Income Tax Rate (%) D@Income Tax Rate (%) 5) dE /Projected High Price for year D@@"Projected High Price for year 5 f # gD.Projected Low Price for year D@@!Projected Low Price for year 5 S tTj gg hi" D i  Di Di D i D i D i D i D i Di Di? Di@ Di@ Di@ Di@ Di@  DgD~2l!`h2NN2NNBLx4bcLsw !"#$%&'()*+,- ./3456789:;<=>? j j g k@l? l?   L? lp= ף?   lʡ?   lnV}r?   l67k?   l_ q?   l%{?   lgQ?   l=?   lS:?   l>͌]?   lFӻ?   l#`o+?   l ̭?  % lo@!D ? g!j !gg!k$@l?!l?!!!!L?!l](\?!!!lK?! !! lz-!l?! !! lm>"?! !! lXPX?! !! l~Z-?! !! l*,&@!!!l0ԭ@!!!l> @!!!lEO.@!!!l36V @!!!l^@ @!!!lFa@!!%!lK@"D!?!g"j "gg"k.@l?"lffffff?""""Lffffff?"l(\(?"""l-$U?" "" lZC?" "" loB@" "" l&)&@" "" lʀG@" "" lx@"""l[IS$ @"""l㯦.@"""l%y} @"""lrf@"""lODz[t@"""l4eυM@""%"lʓ,F @#D"ffffff?"g#j #gg#k4@l?#l333333?####L333333?#l ףp= ?###lS?# ## lǘ@# ## lP@# ## lSK@# ## l=Z @# ## l73@###lu@###l~V@###lA^g@###l82 !@###lwoW f%@###l[)@##%#l:!e.@$D#333333?#g$j $gg$k?l?$l?$$$$L?$l?$$$l@?$ $$ l@$ $$ lj@$ $$ l@$ $$ l@$ $$ l@$$$le@$$$l _"@$$$lvH'@$$$l-@$$$l@02@$$$lļ6@$$%$l4&k<@%D$?$g%j %gg%k>@l?%l?%%%%L?%l ףp= ?%%%l~jt@% %% lGJ@% %% lòҤ @% %% le'N@% %% l[r@% %% lP @%%%l5%@%%%lw Z+@%%%l_<1@%%%lz|NOL7@%%%lɟnLI>@%%%l{~ׯC@%%%%l W˗I@D%?%g&j.&gggggggggggggggggggg 'j'+++++++++ '_o'++++ ((+++++++++` )) +D) +)` *\*!T.FZ Z Z Z Z *f*a\PZZ9{Gz?A @$@ZZ9{Gz?B ++!,D+a ,,*-D,a -"-# D-b . ;. Ω %D)D*D+D,D-.b/b3 44 55 66 77 88 99 : ; < = > ?>?0:00000<L.A777W @ABCDEFG @ A B C D E F GjH - 0 ( 333ff3  x  6*CC@],@*qXT*9$ $<Restore< &/xx  6l+CC@ ],@l+rt +9# $<Restore< &/xx  6,CC@ ],@,r+9" $<Restore< &/xx  6,CC@ ],@,0sD,9! $<Restore< &/xx  6P-CC@  ],@P-sȅ,9  $<Restore< &/xx  6-CC@  ],@-`t䅰-9 $<Restore< &/xx  6.CC@  ], @.t(.9 $<Restore< &/xx  6$/CC@  ], @$/u.9 $<Restore< &/xx  6/CC@  ], @/(v8`/9 $<Restore< &/xx  60CC@ ], @0vT,09 $<Restore< &/xx  6(1CC@  ],@(1Xwp09 $<AVERAGE Average< e 0xx  61CC@  ],@1wd19 $<AVERAGE Average< e 0xx  6`2CC@   ],@`2x29 $<AVERAGE Average< e 0xx  62CC@   ],@2 yĆ29 $<AVERAGE Average< e 0xx  63CC@   ],@3y839 $<AVERAGE Average< e 0xx  644CC@   ],@44Pz39 $<AVERAGE Average< e 0xx  6$5CC@   ],@$5zp49 $<AVERAGE Average< e 0xx  65CC@  ],@5{4L59 $<AVERAGE Average< e 0xx  6H6CC@  ],@H6|P59  $<AVERAGE Average< e 0xx  66CC@  ],@6|l69  $<AVERAGE Average< e 0xx  67CC@  ],@7H} 79+ $ < Share Split<@ xx ! 68CC@ ],!@8}79 $ < Import .SSG<H xx , 69CC@KdPx],,@9܇89 $<Get data from Internet<~xx - 69CC@+G],-@9X99 $)<*Get data from a old Excel SSG spreadsheet<)@@>@ ')*/%7  ?  SSG spreadsheetCC ? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D  ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D ? SSG spreadsheetCC D Sheet1 (.@ @d  dMbP?_*+%&Q?'?(?)?M\\192.168.1.151\SHARP AL-1540CS od,,LetterSCPI &SHARP AL-1540CS od,,LetterH ~ 33**** o****d"Ariald,3333 ~ ~ 33 @222222< Username unknownJobname unknown`@< dSC0C"d,,cU} *} $ *} m *} $ *} *} I *} I *} *} I*} $ *} $ @     x@      x@ J  ;  s`Z Companyg8Z gspZDatehZ h s|Z Prepared ByeZ esZData taken fromeZ e s:Z Where TradedeZ esZ Ticker SymboleZ e sZMain product/serviceeZ e +'fZ .Af ,!-- s" # $ . Z  % & '/0 Z   1( 2 Z 2 Z  ) / 0Z   s* 2 Z 2 Z 3  4 Z  5  s+Y bCD D D A @-D D @D B-Y  CD D D A @-D D @D B- 3 6, cd s3637~ 8? w- xxxxxxx 9r *j"$T 4 ) - . @4 8 9 : @; < = > ? ):) : -rr - rr .;;;;;;;;;;; 4< 8=.8+ 8C& Bad Data!8>48CInsufficent Data!8 8=/8m5X8 C Bad Data!8 >l9CInsufficent Data! 9 9=09+F2ZY  #*ZP  #'ZG  #%]ZT  #);ZF  #(Incorrect Entry""""B 9 9=19nZY  #ZP  #ZG  # ]ZT  #;ZF  #Incorrect Entry""""Bn/a :A:?9+ZY (Y)our Best GuessZP NAIC (P)referred methodZG "Exponential (G)rowth methodZT #(T)wo-Point Averaging methodSZF !Straight Line (F)it methodIncorrect Entry""""BNAIC (P)referred method :A:?:+ZY (Y)our Best GuessZP NAIC (P)referred methodZG "Exponential (G)rowth methodZT #(T)wo-Point Averaging methodSZF !Straight Line (F)it methodIncorrect Entry""""BNAIC (P)referred method;=@ABCA<=@BBDA=D>D?DZ  < $(  d  s *AM?% 7] @  (.@&A Page &PM\\192.168.1.151\SHARP AL-1540CS odXXLetterSCPI&SHARP AL-1540CS odXXLetterH ff**** o****d"ArialdXffff  ffb@222222< Username unknownJobname unknown`@< dSC0C"dX??33d23 M NM4 3Q  30%Q ;%%Q ;Q3_  NM  d4EC4 3Q  25%Q ;$$Q ;Q3_  NM   d4EC4 3Q  20%Q ;##Q ;Q3_  NM  d4EC4 3Q  15%Q ;""Q ;Q3_  NM  d4EC4 3Q  10%Q ;!!Q ;Q3_  NM  d4EC4 3Q 5%Q ; Q ;Q 3_  NM  d4EC4  3Q SalesQi ;Q ;Q3_ NM   d4E4  3Q  EPSQ+ ;Q ;Q3_  NM   d4E4  3Q  High PriceQi ;Q ;Q3_ NM   d4E4  3Q  Low PriceQi ;Q ;Q 3_  NM   d4E4D$% /3O& Q4$% /3O& Q4FA9n3O3 bo! ! 43*?"! ! ! 43" w3O% ;3OQ423  NM44$% @/3OQ'4$% /3OQ'4444 e""""""""" "                            ? ? ? ? ? ? @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @@@@@@@e?????? ??333333?ffffff???  ףp= ?? ףp= ?(\(?](\?p= ף? ~jt@@?S?-$U?K?ʡ? GJ@@ǘ@ZC?z-!l?nV}r? òҤ @j@P@oB@m>"?67k? e'N@@SK@&)&@XPX?_ q? [r@@=Z @ʀG@~Z-?%{? P @@73@x@*,&@gQ?  5%@ e@ u@ [IS$ @ 0ԭ@ =?     w Z+@  _"@ ~V@ 㯦.@ > @ S:?     _<1@ vH'@ A^g@ %y} @ EO.@ >͌]?     z|NOL7@ -@ 82 !@ rf@ 36V @ Fӻ?     ɟnLI>@ @02@ woW f%@ ODz[t@ ^@ @ #`o+?    {~ׯC@ļ6@[)@4eυM@Fa@ ̭? e   >T @Text 3f]T $<NAIC STOCK SELECTION GUIDE<y>@J  %7 Sheet2 (.@ L&,M/c{j  dMbP?_*+%&?'?(?)?M\\192.168.1.151\SHARP AL-1540CS od,,LetterSCPI&SHARP AL-1540CS odXXLetterH ff**** o****d"ArialdXffff  ffb@222222< Username unknownJobname unknown`@< dSC0C"Z,,cU} r} r} Ir}  mr} r} mr} r} m r} r} $ r} $ LJ@K@ x@@@@@@J  @  @  @ J x@@@@x~ p@ q2 s Z Company  t Z uu*vwxxyyyyyzy{||yxxx p}s~   p}s~   3 4!" Z !  Z! Z! Z!  Z!  Z!  Z!  Z!  Z Z 5 6 7 8  sq]Z Z Z  B%Bad Data$ZZ ZB Bad Datas{]Z Z Z  B%Bad Data$ZZ ZB Bad Datas0]Z Z Z  B%Bad Data$ZZ ZB Bad DatasD]Z Z Z  B%Bad Data$ZZ ZB Bad Datas X]Z  Z  Z  B%Bad Data$Z Z Z B Bad Datas l ]Z  Z  Z  B%Bad Data$Z Z Z B Bad Datas  ]Z  Z  Z  B%Bad Data$Z Z Z B Bad Datas  ]Z  Z  Z  B%Bad Data$Z Z Z B Bad Datas r]Z  Z  Z  B%Bad Data$Z Z Z B Bad DatasѼ ]Z Z Z  B%Bad Data$ZZ ZB Bad Data#Bt % B K 9  Z --------------------,Z ---------------------( Z --------------------T Z -------------------- 4Z -------------------- Ȭ Z -------------------- KZ --------------------  Z -------------------- 0Z --------------------\Z --------------------#l,  % B K~ v@ :&xxxxxxxxxxxxxxxx p}  ;  Z  <  Z =   Z   >  ?  @ A  B  C  D  E  C D E  F G ~ ?! ZZ Z Z S o =Z Z A @-@Z Z B- S  =Z Z A @-@Z Z B-  Z K5D DA @-@D DB-K5D DA @-@D DB-~ @! ZZ Z Z S ) =Z Z A @-@Z Z B- S _ =Z Z A @-@Z Z B-  Z K5D DA @-@D DB-K 5D DA @-@D DB-~ @! ZZ Z Z S - =Z Z A @-@Z Z B- S - =Z Z A @-@Z Z B-  Z K5D DA @-@D DB-K 5D DA @-@D DB-~ @! ZZ Z Z S  =Z Z A @-@Z Z B- S Ѽ =Z Z A @-@Z Z B-  Z K5D DA @-@D DB-K 5D DA @-@D DB-~ @ ZZZZS  =ZZA @-@ZZB- S  =ZZA @-@ZZB-  ZK5D DA @-@D DB-K 5D DA @-@D DB-~ @ H # % O '9% AA @-% @B O  9% AA @-% @B  O 9%A @-%@B ~ @ I # %B O 9% BA @-% @BB- O 9% BA @-% @BB-  O9%BA @-%@BB- ~  @ JQX ;$ $ BA @-$ $ @BB-~  "@  K %ZZ rj~ v@ Lxxxxxxxxx   xx !oK DD xx  8 M  N D - O   Z  !9 DD  A  +ZY (Y)our Best GuessZP NAIC (P)referred methodZG "Exponential (G)rowth methodZT #(T)wo-Point Averaging methodSZF !Straight Line (F)it methodIncorrect Entry""""BNAIC (P)referred method  9 P   Q  R D - O    Z S! DD  & T |$ D    \  ]  !Z ^DV&l.2XFsssso*D !"x#$%&x'(x)*@ +x@,@ -@.@/x@0@1x@2@3@4@5@6x@7@8@9@:@;x@<J@ =x@>@?@&   !U! !z!'Z! ! ! !&""# #V # # E D # # $W$ ${ $ $ S$ $ SZ$ *DD  %B B%D %BB$ $$% %X % #% # %B$% :&' 'Y'$ZP  $ZG  $}ZI  $$ \ZC  $;ZD  $!Incorrect Entry!""""BA @-ZP  $ZG  $}ZI  $$ \ZC  $;ZD  $!Incorrect Entry!""""@"B-'Q'(;ZP /((e) Selected just because it LOOKED GOODZG (a) Selected for GrowthZI (d) Selected for IncomeZC (b) Cyclical Company\ZD 4-(c) Cyclical Company (but the market is down)Error!""""B(a) Selected for Growth(' :( )Z )[)UU** D* *} **X D'-* *~ * !* 6\, D*D** *\*-*H$- D* * , ,],\% D*-, ,^!,^. D*D*, , _, ,i,i,j6\- D* ,j - -`!-^. D*D*- -^!-io, D-D*- - a- - - !-A=0 D*D, - . .b!.io- D-D*. .^.H D*. . c. . . !.+* DD, .*/0 0d0 Z0 0e00 /.D0D-  Strong BuyD0D- D0D, B$ BuyD0D- D0D- B$ MaybeiD0D. D0D. B$ Sell8D0D.  Strong SellError""""B0 0 f0 *1 2g 2h 2 2 3 33*D3 3 3 3 0Z3 4 4 S4 53DZ Not Meaningful!DZ ^ZD'  N.M.F.3DZZD'A To 1""B4 5 553 Z5 5 5 5 `,D*-5 $6 7i 7j 8 884 D8 8 8~ 8@@ 89 9S(9 bHDZ9 9 9 $9Uy1O:DZ 9 : ::5Z:!:APV8 D8D9 ::;~ <v@ <k&<xxxxxxxxxxxxxxxx*= >8 >>->@Z>? ?S&? >ZZ? ? ? DlDD>|>. ..N (F.o@@Ax@BC@D@E@Fx@G@H@I@J@ K0@ @@-@:Z@*A B9 Bl&BC CmC=CD':::::BC C C C d? D-C "D DS*DI DCDZ DE E E C ZE  GZ Gn G H HHHb9D9 H H oH H G#C D9  H G `HhIJD9?AQA @!D9?AQ@B HI I I GJ DD I H >IlJ(DDA @@$DBJ J !J I#H DH DI  J J JJpK4DHDIA @@DHDIB JKt5 Z]ZSSG-XLT-R51.xlt Sam Foster (Rev. 1.52 by R. Beaubien) 1-14-04 [sfoster@anythingetal.com] K  K EhRKU,lt <DJAQA @DJ@AQB Kk.Fpc*.0 "(  RB  C B4 4]0ZRB  C B99]ZRB  C B??]xZRB  C B DD]ZRB  C BC$ $]XTLB  3  $ $]ȇxp2  6AA B?J0L<]8xp2  6AA B? 35@]xp2  6AA B? f] xp2   6AA B?6/ 1] xp2 ! 6AA B?p`]!Pxp2 " 6AA B?GMI@]">@,,,,%700 00 ?00 6AA B?Buy?00 6AA B? Maybe?00 6AA B? Sell? 6AA B? x? 6AA B?X? 6AA B?x4444?44 6AA B??44 6AA B?44 44 ?44 6AA B??44 6AA B? Sheet3 (.@ G\|$  dMbP?_*+%M\\192.168.1.151\SHARP AL-1540CS odXXLetterSCPI&SHARP AL-1540CS odXXLetterH ff**** o****d"ArialdXffff  ffb@222222< Username unknownJobname unknown`@< dSC0C"dXX??U} }  } m } I } G    @ @@@@ U U$UUUUUUUUUUUUUUU UU U U UUUUUUUUUUUUU(UUUUUUUUUUUUUUUUU Ux UUU U~ U Uy U U  U  U  U  U  U U U U(UUUUUUUUUUUUUUUUU(UUUUUUUUUUUUUUUUU U U$UUUUUUUUUUUUUUU(UUUUUUUUUUUUUUUUU(UUUUUUUUUUUUUUUUU( UUUUUUUUUUUUUUUUU U U~ U U UUUUUUUUUUUUU UUUUU U U~ W@@ UU ~ U4@ UUUUUU U U$ UUUUUUUUUUUUUUU U U UUU U U~ W A UU ~ U@ UUUUUUU U$UUUUUUUUUUUUUUUU U UUU UU~ W@ UU ~  UP@ UUUUUUU U$UUUUUUUUUUUUUUUU U| UUU UU~ U~@ UU ~  U@ UUUUUUU Uy$UUUUUUUUUUUUUUUU U UUU UU~ Uy@ UU ~  U@ UUUUUUU Uz$UUUUUUUUUUUUUUUU UU Z UUUUUUUUUUUUUU U{U U UUUUUUUUUUUUUU UU U U UUUUUU  U  U  U UUUU U}U~ U7@ U UUUUUU  X[[?  U  X UUUU U$UUUUUUUUUUUUUUUU Uy$UUUUUUUUUUUUUUUU UU U UUUUUUUUUUUUUU UU U U UUUUUU  U  U UUUUU UU~ Z.@ U~ ]@@UUUUU  U  X UUUUU UU U U UUUUUU  U  U UUUUU UU VV.@UL@UUUUU  U@L@U@  UUUUDlDZ,,,D,,,Tl@@@@@TT@@T !"#$%&'()*+,-./0123456789:;<=>? U U U U U U UUUUU U U UUUU !UUU!UV3,AVB@!UUUUU ! UB@Z@ ! UUUU"U "U"U "U "U "U"UUUUU " U " U" UUUU#U #U#U#Yl@U@Y#UUUUU # U8@V@ # UUUU$U $U$U $U $UUUUUUUUUUUUU%U %U$%UUUUUUUUUUUUUUU&U &U&U &U &UUUUUUUUUUUUU'U 'U$'UUUUUUUUUUUUUUU(U (U(U (U (UUUUUUUUUUUUU)U )U$)UUUUUUUUUUUUUUU*U *U*U *U *UUUUUUUUUUUUU+U +U$+UUUUUUUUUUUUUUU,U ,U,U ,U ,UUUUUUUUUUUUU-U -U$-UUUUUUUUUUUUUUU.U .U$.UUUUUUUUUUUUUUU/U /U$/UUUUUUUUUUUUUUU0U 0U$0UUUUUUUUUUUUUUU1U 1U$1UUUUUUUUUUUUUUU2U 2U$2UUUUUUUUUUUUUUU3U 3U$3UUUUUUUUUUUUUUU4U 4U$4UUUUUUUUUUUUUUU5U 5U$5UUUUUUUUUUUUUUU6U 6U$6UUUUUUUUUUUUUUU7U 7U$7UUUUUUUUUUUUUUU8U 8U$8UUUUUUUUUUUUUUU9U 9U$9UUUUUUUUUUUUUUU:U :U$:UUUUUUUUUUUUUUU;U ;U$;UUUUUUUUUUUUUUU<U <U$<UUUUUUUUUUUUUUU=U =U$=UUUUUUUUUUUUUUU>U >U$>UUUUUUUUUUUUUUU(?UUUUUUUUUUUUUUUUUD lhzT@T@T@T@T@@@@@@@@@@@@@@@@@@@ABCDEF(@UUUUUUUUUUUUUUUUU(AUUUUUUUUUUUUUUUUU BU&BUUUUUUUUUUUUUUUU(CUUUUUUUUUUUUUUUUU DU&DUUUUUUUUUUUUUUUU EU&EUUUUUUUUUUUUUUUU(FUUUUUUUUUUUUUUUUUx,,8,88> @# ## 4A%quotes?IM=quotes&symbol=hd&type=Quote- DOLhttp://quotes.freerealtime.com/dl/frt/quotes?IM=quotes&symbol=acs&type=Quote:%quotes?IM=quotes&symbol=hd&type=Quotes&#%7 Sheet7 (.@ I  dMbP?_*+%M\\192.168.1.151\SHARP AL-1540CS odXXLetterSCPI&SHARP AL-1540CS odXXLetterH ff**** o****d"ArialdXffff  ffb@222222< Username unknownJobname unknown`@< dSC0C"RXX??U} } } $ } I } $       @     FH FI/000000001 FJ2333333334 FK<55555555= FL>????55??@ FIA66665566B FIC77775377D FMC777E5377D FN 899999999: F' N D D D  F N D G  ? Z  F N D   ?Z  F ND  FND'QDD D R LD D RR  R  R  R  R  RSFNDT LD D UUU  U  U  U  U  UVF'NDD D T LD D UUU  U  U  U  U  UVF'NDD D 'W DD D U LD D UU  U  U  U  U  UVFNDT LD D UUU  U  U  U  U  UVF'NDD D TUUUUUUUUVF'NDD D TUUUUUUUUVFNDXYYYYYYYYZF'NDD D FNDF'NDD D  FO FP:,,,,,,,,5tKWWKWK5>@%7  ? DD D  AL-1540CS ?DD D  AL-1540CS D?DD D  AL-1540CS D?DD D  AL-1540CS D?DD D  AL-1540CS D?DD D  AL-1540CS D?DD D  AL-1540CS D  ? DD D  AL-1540CS D   ? DD D  AL-1540CS D ?DD D  AL-1540CS D?DD D  AL-1540CS D?DD D  AL-1540CS D?DD D  AL-1540CS D  ? DD D  AL-1540CS D   ? DD D  AL-1540CS D   ? DD D  AL-1540CS D   ? DD D  AL-1540CS D   ? DD D  AL-1540CS D   ? DD D  AL-1540CS D   ? DD D  AL-1540CS D   ? DD D  AL-1540CS D  Sheet4 (.@ D>"<jz   dMbP?_*+%"?? U} a} ^]]]     __` \O \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \^ \^ \Dl !"#$%&'()*+,-./0123456789:;<=>? ^ \~ ^?!^ !\"^ "\#^ #\$^ $\%^ %\&^ &\'^ '\ (\ )\ *\ +\ ,\ -\ .\ /\ 0\ 1\,1^D1D1ffffff? 2\ 3\ 4\ 5\ 6\ 7\ 8\ 9\ :\ ;\ <\ =\ >\ ?\Dl&>@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @\ A\ B\ C\ D\ E\ F\ G\ H\ I\ J\ K\ L\ M\ N\ O\ P\ Q\ R\ S\ T\ U\ V\ W\ X\ Y\ Z\ [\ \\ ]\ ^\ _\D@l`abcdefghijklmnopqrstuvwxyz{|}~ `\ a\ ba ca da e\ f\ g\ h\ i\ j\ ka la mb na oa paX qa ra sa ta ua va wa xa ya za {a |a }a ~a aD@l a a a a a a a^ a a a a a a a a a a a a a a a a \ \ \ \ \ \ \ \ \DJl b \ b a \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \D@l \ \ \  \  a  a  a  a \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \D@l \ a a \ \ a a \ \ \ \ \ \ \ \c \ a  a! b" a# \$ \ \ \ \ \ \ \ \ \c \%c \D^l      \ \ \ \ \ \ \ \ \ \ \ \ \ \& \' \ \ \ \ \( \ \ \) \* b+ b, \ \ \ \ \ \D@l !"#$%&'()*+,-./0123456789:;<=>? \ !\ "\ #\ $\ %\ &\ '\ (\ )\ *\ +\ ,\ -\ .\ /\ 0\ 1\ 2\ 3\ 4\ 5\ 6\ 7\ 8\ 9\ :\- ;\. <\. =\. >\. ?\.D@l@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @\. A\/ B\0 C\1 D\1 E\1 F\1 G\1 H\1 I\2Jc J\ K\ L\ M\ N\ O\ P\ Q\ R\ S\ T\ U\ V\ W\ X\ Y\ Z\3 [\4 \\5 ]\6 ^\7 _\8DJl`abcdefghijklmnopqrstuvwxyz{|}~ `\9 a\: b\; c\< d\= e\> f\? g\@ h\A i\B j\C k\D l\E m\ n\ o\ p\ q\ r\ s\ t\ u\ v\ w\ x\ y\ z\ {\ |\ }\ ~\ \D@l \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \$ ,>@%7 Sheet5 ThisWorkbook"__SRP_cl__SRP_d !gSheet1##    z7 !"#$%&'()*+,-./012345689:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxy|}~  "$%&'()*+,-./0123456789:;<=>?@ABCEFGHIJLMOPQRSTUVWXYZ[\]^_`bcdfhijklmnopqrstuvwxy{|}}#<C;jF6o_F$Xx6o_F$XC;jME(SLSS6"N0{00020819-0000-0000-C000-000000000046}8 `|+h@% % %@@@@)@ $*\Rffff*2O4089a6cc4 " ophӰAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2 P Sub _Open()End rU i;1;4!`   8$ 4XrU @$ `n8%}y#<@ x  Mثt4 FbƗ"r M G=BxbƗ"r M G=B@ x  Mثt4ME PSLSS006"<<<N0{00020820-0000-0000-C000-000000000046} `h|+h@%%% % `x+8e ! X %i P@X x@0@@@$)@ *\R1*#175$*\Rffff*134162f5ce4 "  "   (0ophoAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomizD2 P Sub CommandButton1_Click() 8End Works_SelectionChange(ByVal Target As R %rU LaL4A`IW8__SRP_7 D__SRP_6KSheet2 N__SRP_ea$ @ l x (x 4PrU @$`,A` anDr}{#<O*\N>q`T F`֥CL x`֥CL O*\N>q`TME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%Hh % %8p@@8)@ $*\Rffff*0t40865eae4 xAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 rU (a)4A`rU @nDr}u#__SRP_feBSheet3g__SRP_10z__SRP_11~B<%6DZt! F K?k^OI|x K?k^OI|%6DZt!ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%Hh %  %8p@@8)@ $*\Rffff*0u40865eae4 xAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 rU A)ai)4A`rU @nSheet4 __SRP_18__SRP_19BModule1$Dr}w#<uǩU B/Z F(ߚe~Lyx(ߚe~LyuǩU B/ZME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%Hh %" %8p@@8)@ $*\Rffff*0v40865eae4 xAttribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 rU *a*4A`rU @nrU $`a$`$`$`$!`$I`$q`$`$`$ `$ `" "318(X !p1( .G( "4 @"H "P3`1( !1( .G(@ "X4h" "31( !1(0 H.GX( "4" "31(0 !H1X(x .G( "4"  "(381X(x !1( .G( "04@`"h "p31( !1(  .G0(` "x4(5P}qxME<6 LLLL<8 1 &p`@hXk!Macro recorded 5/22/00 by FOSTERS 14 F` k H` k J0`h k* Lp`k8 N`kF P``kT R0`kb Tp`kp V `Xk ~ X `k  Z0 `k  fp `k  h `Xk  j`0k l0`!k np`"k! p`$k< r`&kW t0`h(kr vp`@*k x`,tk77 14 `. k0p0p0pp0p0p$%@0p0p0pp0p0p((,026<@@@x 4@Xh @d @pT @D @4 @$ @ @ @ (,026<@@ x @ h X@d @ T @H D @0 H@` 4 @x $ ,@  FILE@  h@ B@8x ` (,026<@@>@ x @ h B@@d $0@ T @ D B@H@ 4 B@H@ $ 8@8  2@P  FILE@ A21: 8  (,026<@00@P x @h h B@H@d B@@ T 8@ D 2@ 4 FILE@ $ A61:@  B@4@  ry$@ F7$(,026<@H@x 8@h 2@d FILE@(T A81:@@D B@4@X4 ry$@p$ F6$@ @ B@ SSG pX(,026<@W LE@x A94@h B@4@d ry$@T B22@D @4 B@$ SSG @0 @H H@ Data0(,026<@nt$@Hx B11@`h @d B@xT SSG @D @4 @$ Data@ @ @ >(,026<@@x SSG @h @d @ T SSG @8D @P4 @h$ >@ @ @ hP(,026<@@x @h @d @T @D @4 @$ @( @@ @ ((,026<@@@x @Xh @d @pT @D @4 @$ @ @ @ (,026<@@x @h @d @T @0D @H4 @`$ @x @ @ `hxP(,026<@\@x @h @d @T @D @4 @$ @  @8 @ Hd@ 8@P((,026<@\@hx @h @d @T @D @4 @$ @ @ @ d@ ((,026<@\@@x @Xh @d @pT @D @4 @$ @ @ @ d@  (,026<@\@ x @0 h @d @H T @` D @x 4 @ $ @  @  @ d@ !"!"(,026<@\@!x @"h @d @ "T @8"D @P"4 @h"$ @" @" @ !d@ #$#$(,026<@\@#x @#h @d @#T @$D @($4 @@$$ @X$ @p$ @ #d@ p%x&%`&(,026<@\@%x @%h @d @%T @%D @&4 @&$ @0& @H& @ X%d@ H'P(`'8((,026<@\@x'x @'h @d @'T @'D @'4 @'$ @( @ ( @ 0'd@ )(*8)*(,026<@\@P)x @h)h @d @)T @)D @)4 @)$ @) @) @ )d@ *,++(,026<@\@(+x @@+h @d @X+T @p+D @+4 @+$ @+ @+ @ *d@ -,,.|,0~\(2<@-l @-\ @0-L @H-< @`-, @x- @- @- @- @ @- @. @ . @8. @h. @P. @ @t ,@x1(0/p0P/0X0/1(02@h/x @t @d @/T @/D @/4 @/$ @0 @1 @ 0 @ @0 @0 @0 @0 @1 @1 @01| @H1l @`1\ @L @< 8/,6<@|@1, @1 @ H #)@ $*\Rffff*1>40898513*\R1*#ce*\R0*#17*\R1*#98*\R1*#7d*\R0*#14*\R1*#63*\R1*#b*\R1*#40*\R1*#175*\R1*#b8*\R1*#b3*\R1*#c4*\R1*#229*\R1*#1714" "31( ! 10(P h.Gx( "4" " 3 10 (P  !h 1x (   .G (  " 4 8 "@  "H 3X 1x (  ! 1 (   .G (8  "P 4`  "  " 3 1 (  ! 1 ((  @ .GP (  " 4  "  " 3 1 ((  !@ 1P (p   .G (  " 4 " " 30(P !h1x( .G1("!((P"!h("!&S(("!((P !h.Gx( "4" "3(0 !H1X(x .G1("!(0"!H(p"!&S(("!(0 !H.GX( "4" "3( !(18(X p.G1("!("!((P"!h&S(("!( !(.G8(h "4" "3( !1(8 P.G`1("!("!(0"!H&Sp(("!( !.G(H "`4p" "3( !1( 0.G@1p("!("!("!(&SP(x("!( !.G(( "@4Pp"x "3( !1( .G 1P(p"!("!("!&S0(X(p"!( !.G( " 40P"X "`3p( !1( .G 10 (P "!h ( "! ( "! &S!(8!(P!"!h!(! !!.G!(! ""4"0""8" "@"3P"(p" !"1"(" ".G"1#(0#"!H#(p#"!#(#"!#&S#($(0$"!H$(p$ !$.G$($ "$4$%"% " %30%(P% !h%1x%(% %.G%1%(&"!(&(P&"!h&(&"!&&S&(&('"!('(P' !h'.Gx'(' "'4''"' "(3((0( !H(1X((x( (.G(1((($!)(0)$!H)(p)$!)&S)()()$!*(0* !H*.GX*(* "*4**"** p+*1X+(x+l\+1,( ,l\8, , ",3,1,(- ! -10-(P-.Gh-(- #- !-1-(-.G. 8.(H. #`. !p.1.(..G.(. #/ !/1 /(@/.GX/(/ "/4/ / /"+/ 0 0  0 @0 &`0 "0%0  "00 *@0(|0 %`1 (PH !1 13111(p1 2  2 11(2(H2 !`21p2(2.F2 H12(2 !31 3(@3.FX3 H13(3 !313(3.F4 hH1L((K !`K(pK.GK(K.GK 184(X4 !p414(4.F4 xH14(5 ! 5105(P5.Fh5 H15(5 !515(6.F6 H1H6(h6 !616(6.F6 H16(7 !071@7(`7.Gx7 H17(7 !717(8.G(8 I1X8(x8 !818(8.G8 (I19((9 !@91P9(p9.G9 HI19(9 !91:( :.G8: $hI1h:(: !:1:(:.G: (I1;(8; !P;1`;(;.G; I1;(; !<1<(0<.GH< I1x<(< !<1<(<.G= I10=(P= !p=1=(=.G= J1=(> ! >10>(P>.Gh> J1>(> !>1>(?.G? 0J1H?(h? !?1?(?.G? HJ1?(@ !8@1H@(h@.G@ `J1@(@ !@1@(A.G0A pJ1`A(A !A1A(A.GA J1B(0B !HB1XB(xB.GB J1B(B !B1C((C.G@C J1pC(C !C1C(C.GC J1 D(@D !XD1hD(D.FD J1D(D !E1E(8E.GPE K1E(E !E1E(E.GF @K10F(PF !hF1xF(F.GF  F1 L(G !G((G @G  PG)`G4pG G1G "G ,+GH H&+H 8H @H HL ((* calculations$,(. Calculations$,B@HF3:F10$0B@H 2B@4 Data Entry$,B@HicatioF3$0B@H1 6B@8osoft  <8 @>BD 2B@:ecF3$0B@H ((* calculations$,(.op ((* calculations$,(. Calculations$,B@HG3:G10$0B@H 2B@4 Data Entry$,B@HG3$0B@H 6B@8  <8 @>BD 2B@:G3$0B@H ((* calculations$,(.op ((* calculations$,(. Calculations$,B@HH3:H10$0B@H 2B@4 Data Entry$,B@HH3$0B@H 6B@8  <8 @>BD 2B@:H3$0B@H ((* calculations$,(.o( ((* calculations$,(.x Calculations$,B@HI3:I10$0B@H 2B@4 Data Entry$,B@HI3$0B@H 6B@8  <8 @>BD 2B@:I3$0B@H ((* calculations$,(.o0 ((* calculations$,(. Calculations$,B@HJ3:J10$0B@H 2B@4 Data Entry$,B@HJ3$0B@H 6B@8  <8 @>BD 2B@:J3$0B@H ((* calculations$,(.op ((* calculations$,(. Calculations$,B@HK3:K10$0B@H 2B@4 Data Entry$,B@HK3$0B@H 6B@8  <8 @>BD 2B@:K3$0B@H ((* calculations$,(.oP ((* calculations$,(. Calculations$,B@HL3:L10$0B@H 2B@4 Data Entry$,B@HL3$0B@H 6B@8  <8 @>BD 2B@:L3$0B@H ((* calculations$,(.o ((* calculations$,(. Calculations$,B@HM3:M10$0B@H 2B@4 Data Entry$,B@HM3$0B@H 6B@8  <8 @>BD 2B@:M3$0B@H ((* calculations$,(.o0 ((* calculations$,(. Calculations$,B@HN3:N10$0B@H 2B@4 Data Entry$,B@HN3$0B@H 6B@8  <8 @>BD 2B@:N3$0B@H ((* calculations$,(.oxp ((* calculations$,(. Calculations$,B@HO3:O10$0B@H 2B@4 Data Entry$,B@HO3$0B@H 6B@8  <8 @>BD 2B@:O3$0B@H ((* calculations$,(.o0 ((* calculations$,(. Calculations$,B@Ha11:a25$0B@H 2B@4 Data Entry$,B@Hb11$0B@H 6B@8  <8 @>BD 2B@:b2$0B@H ((* calculations$,(.o ((* calculations$,(.F3:F10$0B@H 2B@4 Calculations$,B@HF3$0B@H 6B@8  <8 @>BD 2B@: DATA ENTRY$,B@HF3$0B@H=AVERAGE(RC[1],RC[2]) \(^F4$0B@H=AVERAGE(RC[1],RC[2]) \(^F5$0B@H=AVERAGE(RC[1],RC[2]) \(^F5:F9$0b dl 2B@`F5:F9$0B@HF10$0B@H=AVERAGE(RC[1],RC[2]) \(^F3:F10$0B@H 2B@4  <8 @>BD 2B@:F3$0B@H ((* calculations$,(.o0 ((* calculations$,(.G3:G10$0B@H 2B@4 Calculations$,B@HG3$0B@H 6B@8  <8 @>BD 2B@: DATA ENTRY$,B@HG3$0B@H=AVERAGE(RC[-1],RC[1]) \(^G4$0B@H=AVERAGE(RC[-1],RC[1]) \(^G5$0B@H=AVERAGE(RC[-1],RC[1]) \(^G5:G9$0b dl 2B@`G5:G9$0B@HG10$0B@H=AVERAGE(RC[-1],RC[1]) \(^G3:G10$0B@H 2B@4  <8 @>BD 2B@:G3$0B@H ((* calculations$,(.o( p ((* calculations$,(.H3:H10$0B@H 2B@4 Calculations$,B@HH3$0B@H 6B@8  <8 @>BD 2B@: DATA ENTRY$,B@HH3$0B@H=AVERAGE(RC[-1],RC[1]) \(^H4$0B@H=AVERAGE(RC[-1],RC[1]) \(^H5$0B@H=AVERAGE(RC[-1],RC[1]) \(^H5:H9$0b dl 2B@`H5:H9$0B@HH10$0B@H=AVERAGE(RC[-1],RC[1]) \(^H3:H10$0B@H 2B@4  <8 @>BD 2B@:H3$0B@H ((* calculations$,(.oH  ((* calculations$,(.I3:I10$0B@H 2B@4 Calculations$,B@HI3$0B@H 6B@8  <8 @>BD 2B@: DATA ENTRY$,B@HI3$0B@H=AVERAGE(RC[-1],RC[1]) \(^I4$0B@H=AVERAGE(RC[-1],RC[1]) \(^I5$0B@H=AVERAGE(RC[-1],RC[1]) \(^I5:I9$0b dl 2B@`I5:I9$0B@HI10$0B@H=AVERAGE(RC[-1],RC[1]) \(^I3:I10$0B@H 2B@4  <8 @>BD 2B@:I3$0B@H ((* calculations$,(.oh ((* calculations$,(.J3:J10$0B@H 2B@4 Calculations$,B@HJ3$0B@H 6B@8  <8 @>BD 2B@: DATA ENTRY$,B@HJ3$0B@H=AVERAGE(RC[-1],RC[1]) \(^J4$0B@H=AVERAGE(RC[-1],RC[1]) \(^J5$0B@H=AVERAGE(RC[-1],RC[1]) \(^J5:J9$0b dl 2B@`J5:J9$0B@HJ10$0B@H=AVERAGE(RC[-1],RC[1]) \(^J3:J10$0B@H 2B@4  <8 @>BD 2B@:J3$0B@H ((* calculations$,(.o0 ((* calculations$,(.K3:K10$0B@H 2B@4 Calculations$,B@HK3$0B@H 6B@8  <8 @>BD 2B@: DATA ENTRY$,B@HK3$0B@H=AVERAGE(RC[-1],RC[1]) \(^K4$0B@H=AVERAGE(RC[-1],RC[1]) \(^K5$0B@H=AVERAGE(RC[-1],RC[1]) \(^K5:K9$0b dl 2B@`K5:K9$0B@HK10$0B@H=AVERAGE(RC[-1],RC[1]) \(^K3:K10$0B@H 2B@4  <8 @>BD 2B@:K3$0B@H ((* calculations$,(.op ((* calculations$,(.L3:L10$0B@H 2B@4 Calculations$,B@HL3$0B@H 6B@8  <8 @>BD 2B@: DATA ENTRY$,B@HL3$0B@H=AVERAGE(RC[-1],RC[1]) \(^L4$0B@H=AVERAGE(RC[-1],RC[1]) \(^L5$0B@H=AVERAGE(RC[-1],RC[1]) \(^L5:L9$0b dl 2B@`L5:L9$0B@HL10$0B@H=AVERAGE(RC[-1],RC[1]) \(^L3:L10$0B@H 2B@4  <8 @>BD 2B@:L3$0B@H ((* calculations$,(.o ((* calculations$,(.M3:M10$0B@H 2B@4 Calculations$,B@HM3$0B@H 6B@8  <8 @>BD 2B@: DATA ENTRY$,B@HM3$0B@H=AVERAGE(RC[-1],RC[1]) \(^M4$0B@H=AVERAGE(RC[-1],RC[1]) \(^M5$0B@H=AVERAGE(RC[-1],RC[1]) \(^M5:M9$0b dl 2B@`M5:M9$0B@HM10$0B@H=AVERAGE(RC[-1],RC[1]) \(^M3:M10$0B@H 2B@4  <8 @>BD 2B@:M3$0B@H ((* calculations$,(.o ((* calculations$,(.N3:N10$0B@H 2B@4 Calculations$,B@HN3$0B@H 6B@8  <8 @>BD 2B@: DATA ENTRY$,B@HN3$0B@H=AVERAGE(RC[-1],RC[1]) \(^N4$0B@H=AVERAGE(RC[-1],RC[1]) \(^N5$0B@H=AVERAGE(RC[-1],RC[1]) \(^N5:N9$0b dl 2B@`N5:N9$0B@HN10$0B@H=AVERAGE(RC[-1],RC[1]) \(^N3:N10$0B@H 2B@4  <8 @>BD 2B@:N3$0B@H ((* calculations$,(.o0 ((* calculations$,(.O3:O10$0B@H 2B@4 Calculations$,B@HO3$0B@H 6B@8  <8 @>BD 2B@: DATA ENTRY$,B@HO3$0B@H=AVERAGE(RC[-2],RC[-1]) \(^O4$0B@H=AVERAGE(RC[-1],RC[-2]) \(^O5$0B@H=AVERAGE(RC[-1],RC[-2]) \(^O5:O9$0b dl 2B@`O5:O9$0B@HO10$0B@H=AVERAGE(RC[-1],RC[-2]) \(^O3:O10$0B@H 2B@4  <8 @>BD 2B@:O3$0B@H ((* calculations$,(.o(pzdIf you mess this up, re-run share split, and just reverse the values that you entered the first timeA@| DATA ENTRY$,B@HP25$0B@HFEnter the NEW Shares Data i.e. in a 2 for 1 split you would enter 2Share Split Data$~ \(^ DATA ENTRY$,B@HO25$0B@HFEnter the OLD Shares Data i.e. in a 2 for 1 split you would enter 1Share Split Data$~ \(^data1 ((* calculations$,(. Data Entry$,B@HF3:O10$0B@H 2B@4 Calculations$,B@HF3$0B@H  <8 @>BD 2B@:F15:O19$0B@H (( 2B@4 Data Entry$,B@HF3$0B@H  <8 @>BD 2B@:data2B2:B27$0B@H (( 2B@4 Calculations$,B@HA2$0B@H  <8 @>BD 2B@:B11:B25$0B@H (( 2B@4 Data Entry$,B@HB11$0B@H  <8 @>BD 2B@:N26$0B@H ((* calculations$,(.(z SHARE SPLIT CancelledA@|oz OpenSSGFileDialog Macro 5/3/96 by Douglas Gerlach MODIFIED 8-16-00 BY Sam Foster (!. ((*SSG Files (*.ssg), *.ssg (%' /    bD B@ (!.A:A$0B@HH 2B@4 B@ SSG RAW FILE$,(. SSG RAW FILE$,B@H high price 6B@8 ssgimport Macro SSG RAW FILE$,B@HA1:A10$0B@H 2B@4 Data Entry$,B@HF3$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA11:A20$0B@H 2B@4 Data Entry$,B@HF4$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA21:A30$0B@H 2B@4 Data Entry$,B@HF8$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA31:A40$0B@H 2B@4 Data Entry$,B@HF10$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA61:A70$0B@H 2B@4 Data Entry$,B@HF7$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA71:A80$0B@H 2B@4 Data Entry$,B@HF5$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA81:A90$0B@H 2B@4 Data Entry$,B@HF6$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA91$0B@H 2B@4 Data Entry$,B@HB19$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA94$0B@H 2B@4 Data Entry$,B@HB22$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA96:A97$0B@H 2B@4 Data Entry$,B@HB20$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA98$0B@H 2B@4 Data Entry$,B@HB11$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA100$0B@H 2B@4 Data Entry$,B@HB10$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA99$0B@H 2B@4 SSG (pg1)$,B@HH10$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA101$0B@H 2B@4 SSG (pg1)$,B@HH9$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA102$0B@H 2B@4 Data Entry$,B@HB12$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@H A104:A105$0B@H 2B@4 Data Entry$,B@HB15$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@H A106:A107$0B@H 2B@4 Data Entry$,B@HB17$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA199$0B@H 2B@4 Data Entry$,B@HB23$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA236$0B@H 2B@4 Data Entry$,B@HB2$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA239$0B@H 2B@4 Data Entry$,B@HB5$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@H A237:A238$0B@H 2B@4 Data Entry$,B@HB6$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA244$0B@H 2B@4 Data Entry$,B@HB8$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA242$0B@H 2B@4 Data Entry$,B@HB3$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA240$0B@H 2B@4 Data Entry$,B@HB4$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA255$0B@H 2B@4 Data Entry$,B@HB14$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA286$0B@H 2B@4 Data Entry$,B@HB9$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA51:A60$0B@H 2B@4 Data Entry$,B@HF9$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA134$0B@H 2B@4 Data Entry$,B@HB26$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA136$0B@H 2B@4 Data Entry$,B@HB27$0B@H  <8 @>BD 2B@: SSG RAW FILE$,B@HA139$0B@H 2B@4 Data Entry$,B@HB25$0B@H  <8 @>BD 2B@: clearing the clipboardA1:A1$0B@H 2B@A1:A1$0B@H 6B@8 B@ B@B SSG RAW FILE$,(. B@ DATA ENTRY$,B@H ((*SSG File Successfully Imported!A@|7z7SSG File Import CancelledA@|7o77A:A$0B@Hreen tax rate book valueH low price sales / revenue eps div / share current price last data year 52 week high-low common shares outstanding # of preffered shares # of authorized common shares! # of authorized preffered shares total debt latest qtr sales latest qtr eps severe low price name of company data source symbol and market industry prepared by data entry date latest qtr ending datebeta net income 5 year sales estimate 5 year income tax rateC33$0B@Hshar 5 year common shares 2B@4A31:A40$0B@H  8 >BD 2B@:A136$0B@H  8 >BD 2B@: SSG RAW FILE$,B@H SSG RAW FILE$,B@HxDbAttribute VB_Name = "Module1" Sub Restore9() T.nDescr@iption|acro recorded 5/22/00 by FOSTERSProcDataTInvoke _FuncT \(n148 Ap plicao.ScreenUpd ng)False 'Sheets("calcul/s").V isiblTr u C Select&Range("F3:F10# .Copy>h Entry ( Active^.PastQE1 Special :=xlValues,` Operu None, SkipBlanks:8= _O, Transpose:=HO'Y_OT_aEnd ʚ8(zxzG3:Gz1RG3zzVz?=l8=7?=z*zv3H3:H?=`E}zH?=#zzz& Q?=?=5qz6?=?=?= 0=0I3:I?=?= D)I?=?=?=3g6?=5nzjz*}"J3:J6z?=Jz z|[pAzzz%( Wzzs۟4 VK3:K [lPKϟxlߟ  3v L3:L&?=;=Lze @F?=6=~2onq ["M3:Mߟ_bMT$G re1n Application.ScreenUpdpng = False Sheets("calculs").VisibleV(Tru TC TSelectRange("N3:N<10F  Copy }Data Entry 4P @Active.Past1 Special :=xlValues, Operu None, SkipBlanks:= _O, Transpose:=O5End@ Sub  Restore0 ()RO3:OzYRO3zzVz'zXzxznzv3a11:a253zzb11=AC zz! #z|b2=]q=Av ge9=9F3:F_vEFv߳߳߳DATA ENxTRY,:F"Cell.Form!R1C1 /"=AVERAGE(@RC[1],2])"# 4 Mn 74AutoFilld Ddin3:F9")1ypnxlDefaul+~F5.s%/ % * Ȅ% <:oB/oBoBb dB8oBoCN <ndG3:GoB&?oBmGoB_G\oB;/ RoB jB-sB1}BGBGlGGBOL BB0G5:GB͟B"B("&BBC[s?+$Bnxl‚o65aBBN BB7BBB%jH3:HBB 6BBHB,!opABB B?;-#HB==qVERAGE(R@C[-1],`1@])" Range("H5").Select\ActiveCell.FormulaR1C1 = "=Aion.AutoFill Des tinat:=n:H9"), Type:=xl)Defaulg ( 10C'3 :H)gCopy PasteSpecial eValues, Oper{xlNone, SkipBlanks0:= _'FalsTransposO w pplic0.ScreenUpd ngTrueSheets(`"calcqas@Visible End Sub  Av.ge6()A*%5I3:I]1C1CcC)MJ&.i ?r+rGDATA ENTRY)/.4C SI__^/ZI5:I_@QLߛV_ž_?L=oH_T_O>5_g `NJ3<:J_` _J3rc_s%]{=aJBoo_SJBB_@J5:JB_"B("&BM 8?+)Q_nc'_____d 0B_ *B_]4Bn_/%BK3:KBov BKB,BB //߯B==BBKBOB6_onK5:KBB"B("&BBBB?+B  P&Ȑ(A h0OBn,ge3BB BBïBd L3:LBBBor &_BVpڳ se Sheets("DATA ENTRY").SelectRange("L3 \ActiveCell.FormulaR1C1 = "=AVERAGE(R@C[-1], 1])" 4KN5CN|ion.AutoFill De@stinat :=5:L9"), Type:=xlDefauNl10K3 :L)gCopy PasteSpecial 2Values, Oper=xlNone, SkipBlanks0:= _FalsTransxposDBpplicB.ScreenUpdDngTru cXalcasNVisible End Sub "  Av.ge2() A*EÇ%5M3:M]C1CcJJM&.i ?r9=#]_SM_?T6_ /ZM5:M_QLV_ž_?L)Lfj-_ 2 wYQ1_g `NN3:N_` _N_ `?_?_ ?___@/ ___#NBOOO3NBB_5:NB_"NyB("&BM ?+ _nj&____d Bw__Bn_Bge0Bns"_$BO3:OBF3Wow.Cl@veCh{@EܔVisible =#ori`ginal%DATA ENTRY Applic].ScreenLUp = K MsgBoxH ("FiSuccessfully Imported!") GoTo D ErrorHler:e Cancelled G@Sub__SRP_2 {__SRP_3!Sheet5__SRP_1aD$ @x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd$ xdH" x$ x x3cT%d:h%x$ x dd)xd1d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h %x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd$ xdH" x$ x x3cT%d:h%x$ x dd)xd1d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h %x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd$ xdH" x$ x x3cT%d:h%x$ x dd)xd1d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h %x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd$ {xdH" x$ x x3cT%d:h%x$ x dd)xd1d:h%x$ x dd)xd(x'T%:h %$ xx!x $ x x1d:h %x$ x dd)xd(x'T%:h!%$ xxx$ @x xGh%D%f$%f%x $ x  x(x'T%:h!%$ xx" x$ x x4fT%d:h%x$ x dd)xd$ xdH" x$ x x3cT%d:h%x$ x dd)xd1d:h%x$ x dd)xd(x'T%:h"%$ xx!x $ x x1d:h %x$ x dd)xd(x'T%:h#%$ xxx$ @x xGh%D%f$%f%x $ x  x(x'T%:h#%rU~| A a ;  < Q< 1 I i<<<=!=Q=q====>A>a>>>>?1?Q??? @yq@@4@a@YAyAAAAB!BIBiBBBBBC9CYCyCCCC??7 D)DIDqDDDDDEEEF9FaF HIKII'YKFq GyK$KaK L y i I 9!Qq!A )Qq!Ii1Qy )Qq 1Qq9H" x$ x x3cT%d:h%x$ x dd)xd1d:h%x$ x dd)xd(x'T%:h %$ xx!x $ x x1d:h %x$ x dd)xd(x'T%:h %$ xxx$ @x xGh%D%f$%f%x $ x  x(x'T%:h %$ xx" x$ x x4fT%d:h%x$ x dd)xd$ xdH" x$ x x3cT%d:h%x$ x dd)xd1d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h %x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd$ xdH" x$ x x3cT%d:h%x$ x dd)xd1d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h %x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd $ xdH" x$ x x3cT%d:h%x$ x dd)xd1d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h %x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xdLE$ xdH" x$ x x3cT%d:h%x$ x dd)xd1d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h %x$ x dd)xd(x'T%:h%$ xxx$ xx" x$ x x4fT%d:h%x$ x dd)xd($ xdH" x$ x x3cT%d:h%x$ x dd)xd1d:h%x$ x dd)xd(x'T%:h$%$ xx!x $ x x1d:h %x$ x dd)xd(x'T%:h%%$ xxx$ @x xGh%D%f$%f%x $ x  x(x'T%:h&%$ xx" x$ x x4fT%d:h%x$ x dd)xd$$ xd|@" x$ x x3cT%d:h%x$ x dd)xd(x'T%:h %$ xx!x $ x x1d:h%x$ x dd)xd(x'T%:h %$ xxx$ @x xGh%D%f$%f%x $ x  x1d:h'%x$ x dd)xd(x'T%:h %$ xx!:h(%x$ (x,x(x'T%:h)%$ xx!:h(%x$ (x,x(x'T%:h*%$ xx!:h(%x$ (x,xSx'T%:h+%$ Qxo%4%d $ d,-.d5(x'T%:h+%$ xx(x'T%:h/%$ xx!:h(%x$ (x,x(x'T%:h %$ xx!x $ x xGh%D%f$%f%x $ x  x(x'T%:h %$ xx" x$ x x4fT%d:h%x$ x dd)xd@$ xd|@" x$ x x3cT%d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h%x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x1d:h'%x$ x dd)xd(x'T%:h%$ xx!:h0%x$ (x,x(x'T%:h1%$ xx!:h0%x$ (x,x(x'T%:h2%$ xx!:h0%x$ (x,xSx'T%:h3%$ Qxo%4%d $ d,-.d5(x'T%:h3%$ xx(x'T%:h4%$ xx!:h0%x$ (x,x(x'T%:h%$ xx!x $ x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd@$ xd|@" x$ x x3cT%d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h%x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x1d:h'%x$ x dd)xd(x'T%:h%$ xx!:h0%x$ (x,x(x'T%:h5%$ xx!:h0%x$ (x,x(x'T%:h6%$ xx!:h0%x$ (x,xSx'T%:h7%$ Qxo%4%d $ d,-.d5(x'T%:h7%$ xx(x'T%:h8%$ xx!:h0%x$ (x,x(x'T%:h%$ xx!x $ x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd@$ xd|@" x$ x x3cT%d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h%x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x1d:h'%x$ x dd)xd(x'T%:h%$ xx!:h0%x$ (x,x(x'T%:h9%$ xx!:h0%x$ (x,x(x'T%:h:%$ xx!:h0%x$ (x,xSx'T%:h;%$ Qxo%4%d $ d,-.d5(x'T%:h;%$ xx(x'T%:h<%$ xx!:h0%x$ (x,x(x'T%:h%$ xx!x $ x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd@$ xd|@" x$ x x3cT%d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h%x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x1d:h'%x$ x dd)xd(x'T%:h%$ xx!:h0%x$ (x,x(x'T%:h=%$ xx!:h0%x$ (x,x(x'T%:h>%$ xx!:h0%x$ (x,xSx'T%:h?%$ Qxo%4%d $ d,-.d5(x'T%:h?%$ xx(x'T%:h@%$ xx!:h0%x$ (x,x(x'T%:h%$ xx!x $ x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd@$ xd|@" x$ x x3cT%d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h%x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x1d:h'%x$ x dd)xd(x'T%:h%$ xx!:h0%x$ (x,x(x'T%:hA%$ xx!:h0%x$ (x,x(x'T%:hB%$ xx!:h0%x$ (x,xSx'T%:hC%$ Qxo%4%d $ d,-.d5(x'T%:hC%$ xx(x'T%:hD%$ xx!:h0%x$ (x,x(x'T%:h%$ xx!x $ x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd@$ xd|@" x$ x x3cT%d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h%x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x1d:h'%x$ x dd)xd(x'T%:h%$ xx!:h0%x$ (x,x(x'T%:hE%$ xx!:h0%x$ (x,x(x'T%:hF%$ xx!:h0%x$ (x,xSx'T%:hG%$ Qxo%4%d $ d,-.d5(x'T%:hG%$ xx(x'T%:hH%$ xx!:h0%x$ (x,x(x'T%:h%$ xx!x $ x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd@$ xd|@" x$ x x3cT%d:h%x$ x dd)xd(x'T%:h%$ xx!x $ x x1d:h%x$ x dd)xd(x'T%:h%$ xxx$ @x xGh%D%f$%f%x $ x  x1d:h'%x$ x dd)xd(x'T%:h%$ xx!:h0%x$ (x,x(x'T%:hI%$ xx!:h0%x$ (x,x(x'T%:hJ%$ xx!:h0%x$ (x,xSx'T%:hK%$ Qxo%4%d $ d,-.d5(x'T%:hK%$ xx(x'T%:hL%$ xx!:h0%x$ (x,x(x'T%:h%$ xx!x $ x xGh%D%f$%f%x $ x  x(x'T%:h%$ xx" x$ x x4fT%d:h%x$ x dd)xd@$ xd|@" x$ x x3cT%d:h%x$ x dd)xd(x'T%:h %$ xx!x $ x x1d:h%x$ x dd)xd(x'T%:h!%$ xxx$ @x xGh%D%f$%f%x $ x  x1d:h'%x$ x dd)xd(x'T%:h!%$ xx!:h0%x$ (x,x(x'T%:hM%$ xx!:h0%x$ (x,x(x'T%:hN%$ xx!:h0%x$ (x,xSx'T%:hO%$ Qxo%4%d $ d,-.d5(x'T%:hO%$ xx(x'T%:hP%$ xx!:h0%x$ (x,x(x'T%:h %$ xx!x $ x xGh%D%f$%f%x $ x  x(x'T%:h!%$ xx" x$ x x4fT%d:h%x$ x dd)xd@$ xd|@" x$ x x3cT%d:h%x$ x dd)xd(x'T%:h"%$ xx!x $ x x1d:h%x$ x dd)xd(x'T%:h#%$ xxx$ @x xGh%D%f$%f%x $ x  x1d:h'%x$ x dd)xd(x'T%:h#%$ xx!:hQ%x$ (x,x(x'T%:hR%$ xx!:hS%x$ (x,x(x'T%:hT%$ xx!:hS%x$ (x,xSx'T%:hU%$ Qxo%4%d $ d,-.d5(x'T%:hU%$ xx(x'T%:hV%$ xx!:hS%x$ (x,x(x'T%:h"%$ xx!x $ x xGh%D%f$%f%x $ x  x(x'T%:h#%$ xx" x$ x x4fT%d:h%x$ x dd)xd@$ xd8K+'''<:lWN\\ X6\<1:l'%$  d)('L%:lY%$ \''''':LZN<<:l[N\\ \F%$ (,6\<1:l'%$  d)('L%:l]%$ \''''':LZN<<:l^N\\ \F%$ (,6\<" $  3cL%:l%$  d)1:l %$  d)('L%:l_%$ ! $  1:l%$  d)('L%:l %$ Gl%,%f%f% $   ('L%:l`%$ # $  ! $  1:l %$  d)('L%:l %$ Gl%,%f%f% $   ('L%:la%$ # $  ! $  1:l%$  d)('L%:lb%$ Gl%,%f%f% $   ('L%:lc%$ # $  ! $  1:l %$  d)('L%:ld%$ Gl%,%f%f% $   ('L%:le%$ " $  4fL%:l%$  d)+'''<:lfN\\ X6\<$ 4 \<'&%tx$ x HQtdx" x$ x xK&@ '%'$%'4%'D%:Tg%x$ x xx(TlR(DlR hZ 'L%'\%'l%'|%f%f%f%f%f%f%%($%4%x$ x Hi/x5%tx$ x HQt<x(x'D%:Tj%$ xx!x $ x x dk3cD%t:Tl%x$ x dt)xt1t:Tl%x$ x dt)xt(x'D%:Tj%$ xxx$ @x x1t:Tl%x$ x dt)xt(x'D%:Tm%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T %$ xxFT%4%f%c%x $ x  x1t:Tl%x$ x dt)xt(x'D%:Tn%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T)%$ xxFT%4%f%c%x $ x  x1t:Tl%x$ x dt)xt(x'D%:To%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:Tp%$ xxFT%4%f%c%x $ x  x1t:Tl%x$ x dt)xt(x'D%:Tq%$ xx!x $ x x(x'D%:Tr%$ xxGT%4%f%f%x $ x  x(x'D%:Ts%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:Tr%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T/%$ xxFT%4%f%c%x $ x  x1t:Tl%x$ x dt)xt(x'D%:Tt%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:Tu%$ xxFT%4%f%c%x $ x  x1t:Tl%x$ x dt)xt(x'D%:Tv%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T*%$ xxFT%4%f%c%x $ x  x1t:Tl%x$ x dt)xt(x'D%:Tw%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:Tx%$ xxFT%4%f%c%x $ x  x1t:Tl%x$ x dt)xt(x'D%:Ty%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:Tz%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T{%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T|%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T}%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T~%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:Td%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T%x$ x dt)xt(x'D%:T8%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T%x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxFT%4%f%c%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:Ts%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ x x1t:T %x$ x dt)xt(x'D%:T%$ xxGT%4%f%f%x $ x  x1t:Tl%x$ x dt)xt(x'D%:T%$ xx!x $ xx(x'D%:T%$ xxx$ @x x  Fs۹̨JZⲘ;xs۹̨JZⲘ;`~!H85>ME PSLSS16"<<<0N0{00020820-0000-0000-C000-000000000046} `x+@) ` %h%`%% x % % xeeeeeeeeeehh@ )@ *\R1*#175$*\Rffff*0x40865eae4 "  ophAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomizD2 P Sub Works_SelectionChange(ByVal Target As Excel.R ) End rU *a*4A` @ l x (x 4XrU @,`anDr}܍#<oL37; Fd<@ȟ )]xd<@ȟ )]oL37;ME__SRP_1bxSheet6__SRP_a__SRP_bB(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%Hh % %8p@@8)@ $*\Rffff*0y40865eae4 xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 rU PQ(ay(4A`rU @n<jx}S#<:!+lH:J&-y F[ LnHGTxSheet7~__SRP_8__SRP_9BModule2;[ LnHGT:!+lH:J&-yME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` % %`h8@0)@ $*\Rffff*0S408fe98c4xAttribute VB_Name = "She@et7" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU  4a144A`rU @nrU $`$`n ,A- !      !"#$%&'(*+-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUW (( # !1(0.GH  x1X ( # !1(.G  01x (x #p !x1P ( .Gp   $  H X   *  $  t   $  (0 x "H p vX  1x(@ #8 ! 10 (x.G  1 ( # !1(.G # 1     4  P 4 40  ,` * (     h ( U0  J+B+0 4 1( "@ "   .  H( %0  "  *@ax%P 1` 1( ! @ 1 ( .G  1(  !(   (8 .GP  P)` p +  1 (  "  8op Get_data_from_Internet Macromya1$0B@HB@H]`]B30$0B@HPHd30$0/m Selection.Copy MARKET CAPnameT \ CAP = CAP / 1000 2!=C current pricecks. 52 week highphp3?t ((ent PE 9 9999 9 C@irqX Selection.Copy Range("B2").Selectntry$ Sheets("get quote").Select Range("d22").SelectB fill in data.Selecm34$0B@H (( 2B@4 Data Entry$,B@HB19$0B@H  <8 @>BD 2B@: 6B@hB@HL34$0B@HB@H (( 2B@4 Data Entry$,B@HB20$0B@H  <8 @>BD 2B@: Selection.Copy.E34$0B@HB@H (( 2B@4x Data Entry$,B@HB21$0B@H  <8 @>BD 2B@:Ticker"A30L36$0B@Hote" CAP = ActiveCell.ValueH 52 week low Data Entry$,B@HB31$0B@Hd30$0B@HB@H E/}4,xMEx@6 LLLLLLLLLLLLLLLLLLL<|<  0% `xxk&Macro recorded 7/21/2003 by Sam FosterNot 14`l 0 2`@k228`l `\ 8`B\ `H0@h~(,02|@`L @x< @, @ @ @ @ @ @  @8 @P h@h @ @| @l  @h @d p`8L X@T X  0@P`rU@<@6R @8@ < W 8 514( @P$ @h MA@ MA@ sw@ @ @ @ MA@ MA@( sw@@ @Xt x@pd @T -0@D -0@4 ls@$ `@ ` 8hP( (,02<@@H @D @4 @$ @  @8 @ @@ @ @ @ @ @ @ @ @p |@X ` @p P @@ P 8P)@ $*\Rffff*4=4089a7ce*\R1*#b3*\R1*#c4*\R1*#b3*\R1*#b*\R1*#40*\R1*#ac*\R1*#aa*\R1*#175*\R1*#b8*\R1*#c4*\R1*#229*\R0*#14*\R1*#b8*\R1*#98*\R0*#17*\R1*#171*\R1*#c4*\R1*#b3*\R1*#b8*\R1*#c4*\R1*#b3*\R1*#ce*\R1*#b8*\R1*#c4*\R1*#b3*\R1*#b8*\R1*#c4*\R1*#b3*\R1*#b8"  $ , h p`X `Pd<0  "  3 1 (@ *b&HP X `hp x 5(+Xh  p  $ t  1 ( #@ !P1`(.G   18  <8 @>BD 2B@: current PE Sheets("get quote").Select> Range("E33").Select End Withd22$0B@HB@H (( 2B@4 Current VolumeH  <8 @>BD 2B@: (( r& Macro written 7/21/2003 by Sam Fosterdela  ((*B@H**FzFk ((8z0 Data Entry$,B@HA@|Not a good Ticker try againA@|>Update failed, more than likely due to no Internet connection.A@|j% 6Please establish a Internet connection, and try again.A@|gcolor 2B@4B3$0B@H 0 getdatafromxls Macro( Macro written on 8/5/2003 by Sam FosterSSG Files (*.xls), *.xls (%'ments\]  8B@g1)$ B@B  B@ments\ Data Entry$,B@H zF3:O10$0B@H 2B@4]8 8B@4 Data Entry$,B@H .Acti B@] (!.ct B@e("F3" (!.8 READ ME !!!!!$,B@H B@e("F3: ((*ctz` Data Entry$,B@HF3$0B@H''  <8 @>BD 2B@:B2:B29$0B@H 2B@4B2$0B@H  <8 @>BD 2B@:o Update failedA@| Data Entry$,B@HB3$0B@H ((*8 GFj 2B@4e("L36 Data Entry$,B@Hicatio Data Entry$,B@H8   <8 @>BD 2B@:B6$0B@H Range("B13").Selectntry$B6$0B@H Data Entry$,B@H<8With Selection 2 .WrapText = FalseSheets("Data Entry").Select Range("B7").Selectry$EXCHANGE .Orientation = 0 ((*P  get quote$,(. get quote$,B@H get quote$,B@H get quote$,B@H get quote$,B@H get quote$,B@HActiveCell.Value = CAP .AddIndent = False get quote$,B@H get quote$,(.BURL;http://quotes.freerealtime.com/dl/frt/quotes?IM=quotes&symbol=  &type=Quote9# Application.CutCopyMode = False Sheets("Data Entry").SelectfSelection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= False, Transpose:=False Range("B7").Selectb Range("d22").Select Sheets("Data Entry").SelectDfSelection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= False, Transpose:=False! Application.CutCopyMode = Falseh Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= False, Transpose:=False +B6$0b  b:J DDD 2B@H & .HorizontalAlignment = xlRight$ .VerticalAlignment = xlCenter .ShrinkToFit = True .MergeCells = False bdf 6B@`VEnter the Ticker for the Stock. If the stock has A or B series enter a DOT i.e. MOG.A$~'b Range("B2").Select g Selection.TextToColumns Destination:=Range("B2"), DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar :="-", FieldInfo:=Array(Array(1, 2), Array(2, 9)) g Selection.TextToColumns Destination:=Range("B7"), DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar :="-", FieldInfo:=Array(Array(1, 9), Array(2, 2)) h Selection.TextToColumns Destination:=Range("B7"), DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar :=":", FieldInfo:=Array(Array(1, 2), Array(2, 9))( get quote$,B@HAttribute VB_Name = "Module2" Sub Get_data_from_Interne`t() F.Descriptionacro recorded 7/21/2003 by Sam Fos_y![ProcDgInvoke_Funcg \n14F' ' M wr`ittenI  Dim ticker As Variant  CAP On Erro@r GoToHandler:pTART#.= InputBox("E thhe T=f#Stock. Ifs has A B ser ies ea DOT i.e. MOG.A"@rA" ThB)Done%ApplicaAs.ScreenU"ping]FalseC9C'fill in Sheets("get quote").VisiblATru SelecYRange("a1With @.QueryTa@9.ConnDURL;ht tp://$s.f5realtime.com/d l/frt?IM= &symb@ol=" &ł& "&type=FQ6Web%T@KxlAll's FormattCUxlGNcK PreedTextToColumnsTB>@?secutiveDelimim`sAsOn/SaleBlKa Import h=EDis-reR{gni~mRe ,sh Backg round4:=End a9C@SA>d30")"#T'!Msg`d ("Not a gooddtry again%]!"[fSm!If 'n ~22 N'@MCopy!W vryT'  B ' Pa`Special :=xlValues, pOperqB, SkipBlanks:= _@ *, Transpose*- 'curr pxricpe"A2. Cut"@L(<& &&19)H~&&&& '52 week highcE i#&m34,w&&n], DB2@g4 O&R&?&0`&SFlow?)z  L?h&e,bc _:&99 f?99@[9R&@9h24hqdJ/&y99LxB6LL MARKET P[&&Q\$&E33 = Acs`Cell.X'h!/ 10003_] oPe sge1{ JEXCHANGE q++'`+'YhB7oooooohxPa oe#'dL38__O ? &R//////8}$V?&tEeeRR?:R3éjxxpxxx!5ication.CutCopyMode = False Sheets("Data Entry").Select@ActiveL.UnprDot4 'Range("B2 r2FTextToColumns DestinI:==, Type:=xlDelimited8, _lIQualifier&oubleQu, Consecu>z, T0ab:=(Semicolon CommaSpacHOth;@True, CharP:="-", FieldInfo:=Array(1, 2), 2, 9))n 7:_d?SS9 S2SKsB|K:'With F&$Qm.HorizontalAlignmentxlRigh|Vert@2Cer\.W8rapaxj.Ori0bbh.Ad`id  .ShrinkToFiAsC.MergeCPellsj'd !6oIo __?@F__WIo IP Draw@ingObjsl:=ft:Scenario GoTo Don ErrorHandl MsgBox ("Update failmore than likely duo no Internet conn@ "@F Please @ablish aq,  again.A : 5eg qӀIVi|siGP%I3!PApplScreen* ^$nd Sub`ub `afr@omxls(P'=k Macroq writ0 on 8/5/2003 by Sam Fosq?Dim fPtoopen As Vanԃ Dg~l7 S=  #&Workbo|ok;{sOn r$ %)%SCH GetOF namSSGjles (*.?ir1!!U s.q:='#3/ve+E$READ ME !8#& &F3:O10A2Ac %.Bp7 v?8Pa&Spe`cial V alues Jpe"rDxlNA, SkipBlankC9ĚTranspos囃 (/ ϰ_$ B2:B29o d |f/ p$eWin@dow.Cl  saveH [[[TT_oRFuoRr".oRruERL__SRP_5 __SRP_4_VBA_PROJECTdir$QDLH1D:4a%H$ H dD )HD1D:4%H$ H dD )HD(H'$%:4b%$ HH!H $ HH \c1D:4%H$ H dD )HD(H'$%:4d%$ HHG4%%f%f%H $ H  !"H Lc1D:4%H$ H dD )HD(H'$%:4e%$ HH!H $ HH \c(H'$%:4%$ HHG4%%f%f%H $ H  !"H Lc)f4%H$ DH H \c+'@'P'`:4fN 6`P@1D:4%H$ H dD )HD(H'$%:46%$ HH" H$ H $H<`0l\L(HD`P@frU~| jI'+A a  + ,A- !i!!)""###- $- 1  i- -!.$1.1Q.q...../)%I%Y& 0q2221/q//$//+34y644 5I5555616Q666 7a77 8A8q8889)9q999 1q IYqLLMV K <'|''''':L^N<< Fll6<|l:L]3X " h$ h $h3c,%d:L8%h$ h dd)hd1d:L8%h$ h dd )hd(h',%:L9%$ hh*h $ hW< TTqPh&:L:l<:,;%lPC6<L%lPCL%lPC cL%lPC cL%lPCfL%lPCfL%lPCfL%lP qP5h',%:L<%$ ha<: ]3h5<5+''':LN<< 6<1d:L8%h$ h dd )hd(h',%:L<%$ hh# h$ h $h!h $ hh1d:L%h$ h dd )hd(h',%:L%%$ hhGL% %f%f%h $ h  !"h1d:L8%h$ h dd )hd(h',%:L?%$ hh# h$ h $h!h $ hh1d:L%h$ h dd )hd(h',%:L'%$ hhGL% %f%f%h $ h  !"h1d:L8%h$ h dd )hd(h',%:Lg%$ hh# h$ h $h!h $ hh1d:L%h$ h dd )hd(h',%:L)%$ hhGL% %f%f%h $ h  !"h1d:L8%h$ h dd )hd(h',%:L=%$ hh# h$ h $h!h $ hh1d:L%h$ h dd )hd(h',%:L+%$ hhGL% %f%f%h $ h  !"h1d:L8%h$ h dd )hd(h',%:Li%$ hh# h$ h $h!h $ hh1d:L%h$ h dd )hd(h',%:L1%$ hhGL% %f%f%h $ h  !"h1d:L8%h$ h dd )hd(h',%:Lh%$ hh# h$ h $h!h $ hh1d:L%h$ h dd )hd(h',%:L3%$ hhGL% %f%f%h $ h  !"h# h$ h $h1d:L%h$ h dd )hdh$ @hYh(h',%:L+%$ hhh',%:L+%$ Qho%@%%f%f%f%f%ft%cT%:4Q%4<( l40898513$Module1qxV Sheet50x40865eae Sheet5 Sheet60y40865eae Sheet6 Sheet70S408fe98c Sheet7SModule24=4089a7ceModule24,/x0H`xGOQ]OIpU-:K4<9I}=1LrvDktbd~NLvS8cX\QD(;/O_GzX?Φi@3퓋TR!,M{@ As=DimDelseRFalse^Goto_IfkIspletNullThenTrueVARIANT Excel+ VBAWin16~Win32MacVBA6# SSG_formZstdole`MSFormsCOfficeu ThisWorkbook| _Evaluate Workbook_Open Sheet1CommandButton1_Click Sheet2 Sheet3 Sheet4 Module1b(Restore9` Application*ScreenUpdating! Sheets VisibleRange  SelectionZCopyƿ ActiveSheet%NPaste PasteSpecialKxlValueso OperationyxlNo  B0* pHdSSG_form,@ Z= n )@ %J< rst dole>stdole f%\*\G{0002`0430-C 0046}#2.0#0#C:\WINNT\System32\c2.tlb#OLE Automation^MSFls>SFErms3DD452EE1-E08F-101A-8-02608C@4D0BB4DFM20.DLL#Microsoft 9 \ Object Library/;C~1s00}#0#j0AED5EE547-D4F5-4AA0-9813-AD1975C7C54A6DOCUME~1\hjua\LOCALS@Temp\Excel8.0\DT.exd`<".E .`M ACOfficDO@ficB 12DF8D04C-5BFAhB-BDE5@JQ404421Program F`iles\e\MSO97 n^ 9Ln# D}BThisWorkb@ookG TDh1sWkbok 2 HB1BܶB,!"B+BBSheet1*G Se`*tn1 s2 h y 2 2 2 2  { 3 3 Z3 3 )u 4 4 4 4 w odule8o@uBA8N2 *V*qT!F555U5ǰT*6 6 6 6** 7 7 7 7 ҰTSp4?b8c8qc/)84,8":rU~~~y __SRP_0% )__SRP_1PROJECTwmPROJECT&55 B14 A286 B9 A51:A60 F9 A134 B26 B27 A139 B25 A1:A1Cut DATA ENTRY >SSG File Successfully Imported! 2SSG File Import Cancelled9 VBE6.DLL YY  YS  B2:B29 Update failedF݀) LO+Fy[@;ZYDFWorkbook Workbook_Open @FCMOJƸw FMpAr .DF WorksheetCommandButton1_Click READ ME !!!!!VšK4oA T@yOuX <Enter the Ticker for the Stock zacks.comQueryTable C3  `URL;http://my.zacks.com/print_myquote.php3?tick=Connection  WebSelectionTypeWebFormatting8WebPreFormattedTextToColumns:WebConsecutiveDelimitersAsOne 0WebSingleBlockTextImport 2WebDisableDateRecognitionBackgroundQueryRefresh 6Not a good Ticker try again A2 A8 B21 b30 C8 B31! |Update failed, more than likely due to no Internet connection. lPlease establish a Internet connection, and try again. YT  lUEFئjWjOGNIeJkSheet9Sheet10Sheet11oL37;d<@ȟ )]; I^+_jN^QPO*\N>q`T`֥CL %6DZt! K?k^OI|rgs۹̨JZⲘ;Worksheet_SelectionChangeFF cnet.com a20 Bd22& URL;http://investor.cnet.com/investor/quotes/quote-detail/0-9970-1042-0- .html?tag=detq a21 F21 G21 B38 B40 B28 E33 B13 B29 B7 E29 B30 E28 &type=Quote d30 d22 m34 d36L (Enter the Ticker for the Stock. If the stock has A or B seK*m   rU ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~[ _bN-kOH:   a a !+a a a )a   )Ii ) I i ) I i Aa !+Ya qe a    ia ThisWorkbookSheet1Sheet2Sheet3Sheet4Module1Sheet5Sheet6Sheet7Module2Module3SSG_formF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  `F 3C:\Program Files\Microsoft Office\Office\EXCEL9.OLBExcel pSheet80FC:\WINNT\System32\stdole2.tlbstdole 1y.E .`M C:\WINNT\System32\FM20.DLLMSForms QG^ԠJuJ 3C:\DOCUME~1\hjua\LOCALS~1\Temp\Excel8.0\MSForms.exd QL-[DR 2C:\Program Files\Microsoft Office\Office\MSO97.DLLOffice IRestore9Restore8Restore7Restore6Restore5Restore4Restore3Restore2Restore1Restore0RestorexAverage9Average8Average7Average6Average5Average4Average3Average2Average1Average0 sharesplitOpenSSGFileDialog Get_data_from_InternetgetdatafromxlsFF9 a F A101 0SSG Files (*.xls), *.xlsF SSG (pg1)F Select Data Entry F3:O10CopyActivate 0SSG Files (*.ssg), *.ssg A:A SSG RAW FILEVisible Paste A1:A10 F3OperationSkipBlanksTransposePasteSpecial A11:A20 F4 A21:A30 F8 C33 A31:A40 A136 F10 A61:A70 F7 A71:A80 F5 A81:A90 F6 A91 B19 A94 B22 A96:A97 B20 A98 B11 A100 B10 A99 H10 H9 A102 B12 A104:A105 B15 A106:A107 B17 A199 B23 A236 B2 A239 B5 A237:A238 B6 A244 B8 A242 B3 A240 B4 A2ries enter a 001 (zero-zero-one) in place of the DOT or Hyphen i.e. MOG.A would be MOG001A get quote a1# URL;http://quotes.freerealtime.com/dl/frt/quotes?IM=quotes&symbol= f36:!+lH:J&-y[ LnHGTMacro1Macro2 -DestinationDataTypeTextQualifier (ConsecutiveDelimiterTabSemicolon Comma Space OtherOtherCharFieldInfoTextToColumns : &HorizontalAlignment "VerticalAlignmentWrapText L10OrientationAddIndentShrinkToFitMergeCellsMacro3UnprotectDrawingObjectsContentsScenariosProtect- Enter the Ticker for the Stock. If the stock has A or B series enter a DOT i.e. MOG.AC;j6o_F$X calculations Calculations F3:F10 G3:G10 G3 H3:H10 H3 I3:I10 I3 J3:J10 J3 K3:K10 K3 L3:L10 L3 M3:M10 M3 N3:N10 N3 O3:O10 O3 a11:a25 b11 b2 L5 L5:L9 *=AVERAGE(RC[1],RC[2]) F5:F9TypeAutoFill ,=AVERAGE(RC[-1],RC[1]) G4 G5 G5:G9 G10 H4 H5 H5:H9 I4 I5 I5:I9 I10 J4 J5 J5:J9 J10 K4 K5 K5:K9 K10 L4 M4 M5 M5:M9 M10 N4 N5 N5:N9 N10 .=AVERAGE(RC[-2],RC[-1]) O4 .=AVERAGE(RC[-1],RC[-2]) O5 O5:O9 O10% Enter the OLD Shares Data i.e. in a 2 for 1 split you would enter 1 F15:O194 If you mess this up, re-run share split, and just reverse the values that you entered the first time P25% Enter the NEW Shares Data i.e. in a 2 for 1 split you would enter 2 Share Split Data O25 B2:B27 B11:B25 N26 *SHARE SPLIT Cancelled L34 E34@ x  Mثt4bƗ"r M G=B L36\        !Macro recorded 5/22/00 by FOSTERS 14 &Macro recorded 7/21/2003 by Sam Foster   a+(Target &Macro recorded 8/12/2003 by Sam FosterBThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Sheet3Sheet3Sheet4Sheet4Module1Module1Sheet5Sheet5Sheet6Sheet6Module2Module2Sheet7Sheet7ID="{36CAE5C6-300E-11D4-B8D8-0050040770A1}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 Document=Sheet4/&H00000000 Module=Module1 Document=Sheet5/&H00000000 Document=Sheet6/&H00000000 Module=Module2 Document=Sheet7/&H00000000 HelpFile="" Name="SSG_form" HelpContextID="0" VersionCompatible32="393222000" CMG="B7B52A993EAF0DB30DB30DB30DB3" DPB="82801FD6EBD7EBD7EB" GC="4D4FD02750F351F3510C" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 &H00000002={00020818-0000-0000-C000-000000000046};Excel8.0;&H00000000 [Workspace] ThisWorkbook=82, 194, 744, 708, C Sheet1=45, 43, 707, 557, Sheet2=132, 132, 677, 646, C Sheet3=154, 154, 699, 668, C Sheet4=110, 110, 772, 624, C Module1=36, 26, 688, 518, Sheet5=41, 173, 906, 574, C Sheet6=198, 198, 988, 717, C Module2=44, 44, 563, 489, Z Sheet7=198, 198, 774, 643, C Oh+'08@ T ` lx Sam Foster@7a@da@՜.+,0 PX `hpx  READ ME !!!!! Data Entry SSG (pg1) SSG (pg2) get quoSummaryInformation())DocumentSummaryInformation8,P CompObjVfte Calculations SSG RAW FILE  WorksheetsA ,=0  *H 010 *H 0R +7D0B0 +7ɉ;Ce0 0 *H &{_ (LE 00`#B7 *c0  *H 0a1_0]UVSam Foster aka sfoster@anythingetal.com0 030101050000Z 090101050000Z0a1_0]UVSam Foster aka sfoster@anythingetal.com00  *H 0Zd[y597( ;HڀDܔ є5XV/.*`mj k`/722Kϸ'QxTϴ̆~.&:ÊHI# Up&hŷK00U% 0 +0U0Kaf_` -P-n'\/LdQ 00`#B7 *c0  *H 0a1_0]UVSam Foster aka sfoster@anythingetal.com0 030101050000Z 090101050000Z0a1_0]UVSam Foster aka sfoster@anythingetal.com00  *H 0Zd[y597( ;HڀDܔ є5XV/.*`mj k`/722Kϸ'QxTϴ̆~.&:ÊHI# Up&hŷK00U% 0 +0U0Ka