{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Input Data","MorningStar","Mutual Fund Information","Sheet10"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input Data","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,3,21,3],[0,5,0,12]]}
[null,null,"Selecting Mutual Funds for your portfolios",null,null,"Instruction for Using the Mutual Fund Filtering Program"]
[null,"Input Ticker Below:","--"]
["#","Mutual Fund","Ticker"]
[1,null,"MADVX","|-----------Enter Tickers Here or Click 'Set Up' Button---------|"]
[{"$f":"IF(C5=\"\",\"\",A4+1)","v":2},null,"PGP"]
[{"$f":"IF(C6=\"\",\"\",A5+1)","v":3},null,"INDBX"]
[4,null,"ASBBX"]
[5,null,"AMGEX"]
[6,null,"ATGIX"]
[7,null,"PGIAX",null,null,"Step 1:","Entering your Tickers"]
[8,null,"PLTIX"]
[9,null,"PGVFX"]
[10,null,"JMVCX"]
[11,null,"JISCX"]
[12,null,"JMCVX"]
[13,null,"JSCVX"]
[14,null,"PBFBX"]
[15,null,"PABFX"]
[16,null,"PCAIX"]
[17,null,"PCIZX"]
[""]
[""]
["",null,null,null,null,"Step 2:","Pulling Data from Morningstar"]
[{"$f":"IF(C24=\"\",\"\",A23+1)","v":""}]
[""]

{"sheet":"MorningStar","index":1,"n_rows":129,"n_cols":27,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
["Provided by Brigham Young University "]
["Friday, Dec. 10, 2010 "]
["End Session"]
["HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters"]
["Print"]
[]
[]
[]
["  Snapshot"]
["  Data Interpreter",null,null,"Prudential CA Municipal Income Z PCIZX"]
[" Analyst Research"]
[" Stewardship Grade",null,null,"See Fund Family Data "]
["  Total Returns "]
["  Tax Analysis "]
["  Risk Measures ",null,null," Performance  more ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Key Stats  more "]
["  Portfolio"]
["  Management",null,null,"Growth of $10,000","2010-11-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Morningstar Category",null,"Morningstar Rating"]
["  Fees & Expenses",null,null,null,"Fund",null,"Current Category",null,"Index",null,null,null,null,null,null,null,null,null,null,null,null,null,"Muni California Long",null,"5 stars\r\n                          "]
["  Purchase Info "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NAV (12-09-10) ",null,"Day Change"]
[null,null,null,null,null,2006,null,null,2007,null,null,2008,null,null,2009,null,null,2010,null,null,null,null,10.11,null,0.01]
[]
[null,null,null,"Fund",null,5.0999999999999996,null,null,2.4,null,null,-6.1,null,null,15.2,null,null,4.3,null,null,null,null,"Total Assets($mil)",null,"Expense Ratio %  "]
[null,null,null,"+/- BarCap Municipal TR USD",null,"---",null,null,"---",null,null,"---",null,null,"---",null,null,-0.1,null,null,null,null,209,null,0.65]
[null,null,null,"+/- Cat",null,0.5,null,null,1.7,null,null,4.9000000000000004,null,null,-2.1,null,null,-0.2]
[null,null,null,"Fund Category",null,"MC",null,null,"MC",null,null,"MC",null,null,"MC",null,null,"MC",null,null,null,null,"Front Load %",null,"Deferred Load %"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",null,"None"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yield % (TTM)",null,"Min Investment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.75,null,0]
[null,null,null,"Trailing Returns %",null,"2010-12-09"]
[null,null,null,null,"YTD","3 year","5 year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manager",null,"Start Date"]
[null,null,null,"Fund",2.76,3.66,3.84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Susan Courtney",null,"2005-04-04"]
[null,null,null,"+/- Cat",0.17,1.35,1.19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Robert Tipp",null,"2004-10-31"]
[null,null,null,"+/- BarCap Municipal TR USD",-0.24,-0.78,-0.54]
[null,null,null,"(change index)"]
[]
[]
[]
[null,null,null," Morningstar's Proprietary Features"]
[]
[null,null,null,"Analyst Pick or Pan ","Role in Portfolio ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analyst Report Summary"]
[null,null,null,"---","---",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Available"]
[]
[null,null,null," Portfolio Analysis  more ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-10-31"]
[]
[null,null,null,"Morningstar Style Box "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bond Quality "]
[null,null,null,null,null,"Average Eff Duration"]
[null,null,null,null,null,"7.44 Yrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AAA",null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AA",null,25.4]
[null,null,null,null,null,"Average Eff Maturity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,26]
[null,null,null,null,null,"---",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BBB",null,24.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BB",null,0]
[null,null,null,null,null,"Average Credit Quality",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",null,0]
[null,null,null,null,null,"BBB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Below B",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Rated",null,8.6999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bond Data through 09-30-10"]
[null,null,null,"Bond Data through 09-30-10"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sector Breakdown (% of bonds)  "]
[null,null,null,"Asset Allocation % more "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Obligation",null,9.08]
[null,null,null,null,"% Long","% Short","% Net Assets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Advance Refunded",null,7.82]
[null,null,null,"Cash",3.2,0.1,3.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State Appropriated Tobacco",null,1.82]
[null,null,null,"Stocks",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-state Appropriated Tobacco",null,3.25]
[null,null,null,"Bonds",96.9,0,96.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Education",null,4.96]
[null,null,null,"Other",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health",null,5.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing",null,2.52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrial",null,1.53]
[null,null,null,"Annual Turnover %",19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation",null,3.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utilities",null,2.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water/Sewer",null,6.14]
[null,null,null,"% Assets in Top 10",20.83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc. Revenue",null,19.93]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The sector breakdown is based on available information and may not account for 100% of the fund´s bond portfolio."]
[]
[]
[]
[null,null,null,"Top 5 Holdings Get Price Quotes ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maturity Date",null,null,"Value $000","% Net Assets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southern Calif Pub Pwr Auth","2016-07-01",null,null,14698,6.6299999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sacramento Calif City Fing Aut Tax Alloc","2016-11-01",null,null,4295,1.9400000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sacramento Calif City Fing Aut Tax Alloc","2017-11-01",null,null,4010,1.8100000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Long Beach Calif Hbr Rev Rev Ref B 6%","2019-05-15",null,null,3549,1.6E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Los Angeles Calif Cmnty Colleg Go Bds 5%","2033-08-01",null,null,3420,1.54E-2]
[]
[]
[]
[]
[]
[null,null,null,"S&P 500 TR"]
[null,null,null,"Dow Jones TR"]
[null,null,null,"Nasdaq PR"]
[null,null,null,"S&P Mid-Cap TR"]
[null,null,null,"LB Aggregate TR"]
[null,null,null,"MSCI EAFE NDTR_D TR"]
[null,null,null,"LB Municipal TR"]
[null,null,null,"M* U.S. MARKET TR"]
[null,null,null,"M* U.S. VALUE TR"]
[null,null,null,"M* U.S. CORE TR"]
[null,null,null,"M* U.S. GROWTH TR"]
[null,null,null,"M* LARGE CAP TR"]
[null,null,null,"M* LARGE VALUE TR"]
[null,null,null,"M* LARGE CORE TR"]
[null,null,null,"M* LARGE GROWTH TR"]
[null,null,null,"M* MID CAP TR"]
[null,null,null,"M* MID VALUE TR"]
[null,null,null,"M* MID CORE TR"]
[null,null,null,"M* MID GROWTH TR"]
[null,null,null,"M* SMALL CAP TR"]
[null,null,null,"M* SMALL VALUE TR"]
[null,null,null,"M* SMALL CORE TR"]
[null,null,null,"M* SMALL GROWTH TR"]
[null,null,null,"M* TELECOM SECTOR TR"]
[null,null,null,"M* FIN-SVS SECTOR TR"]
[null,null,null,"M* HEALTHCARE SECTOR TR"]
[null,null,null,"M* UTILITIES SECTOR TR"]
[]
[]
[null,null,null,"Sector weighting calculations do not include the fund´s short positions (if any)."]
[]
[]
[null,null,null,"S&P 500 index data: S&P 500 Copyright © 2006"]
[]
[]
[null,null,null,"Show Data Definitions  |  Ticker Lookup"]
["Contact us. Please read our User's Agreement and Troubleshooting documents."]
["© 2010 Morningstar, Inc. All rights reserved. "]
["Biggest Stocks | %Price ChangeHelpXOM0.2%Analyst_ReportWMT-0.3%New_Analyst_ReportJNJ-0.6%Analyst_ReportKO0.7%Analyst_ReportGE0.5%Analyst_ReportINTC0.0%Analyst_ReportMSFT-0.6%Analyst_ReportAIG13.2%Analyst_ReportPFE0.2%New_Analyst_ReportBP-1.1%New_Analyst_ReportC1.0%New_Analyst_Report "]

{"sheet":"Mutual Fund Information","index":2,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["#","Fund","Ticker","NAV","Total Assets($mil)","Front Load %","Deferred Load %","Min Investment","Start Date","Morningstar Rating",2010,2009,2008,2007,2006,"Earnings Graph","Earnings Graph Link"]
[1,"BlackRock Equity Dividend Instl MADVX","MADVX",17.149999999999999,10603,"None","None",2000000,"2001-11-01","5 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",22.2,-32.6,14.8,19.3,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_MADVX.png"]
[2,"PIMCO Global StocksPLUS & Income PGP","PGP",13.9,140,"None","None","--- ","2005-05-25","4 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",63.3,-47.3,3.1,22.2,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_PGP.png"]
[3,"Pioneer Independence B INDBX","INDBX",10.76,826,"None *",4,"closed ","2001-11-09","Not Rated","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",41.7,-49.3,"---","---",null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_INDBX.png"]
[4,"Pioneer Classic Balanced B ASBBX","ASBBX",9.15,285,"None *",4,"closed ","2005-09-23","3 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",26.3,-25.6,3.9,12.5,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_ASBBX.png"]
[5,"Pioneer Government Income A AMGEX","AMGEX",10,198,4.5,"None",1000,"2005-09-30","2 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",3.8,7.6,6.4,3,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_AMGEX.png"]
[6,"Pioneer Government Income Y ATGIX","ATGIX",10,198,"None","None",5000000,"2005-09-30","4 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",4.0999999999999996,8.3000000000000007,6.9,3.5,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_ATGIX.png"]
[7,"Putnam Global Industrial A PGIAX","PGIAX",15.83,9,5.75,"None",500,"2009-12-30","Not Rated","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",24.7,"---","---","---",null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_PGIAX.png"]
[8,"PNC Multi Factor Small Cap Gr I PLTIX","PLTIX",11.21,30,"None","None",0,"2005-10-03","3 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",16.3,-37,10.6,7.5,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_PLTIX.png"]
[9,"Polaris Global Value PGVFX","PGVFX",13.78,185,"None","None",2500,"1998-06-01","3 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",35.5,-46.2,-4,24.6,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_PGVFX.png"]
[10,"Perkins Mid Cap Value C JMVCX","JMVCX",21.95,13285,"None",1,2500,"1998-08-12","Not Rated","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters","---","---","---","---",null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_JMVCX.png"]
[11,"Perkins Small Cap Value S JISCX","JISCX",24.17,3099,"None *","None *","closed ","1985-02-14","Not Rated","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters","---","---","---","---",null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_JISCX.png"]
[12,"Perkins Mid Cap Value T JMCVX","JMCVX",22.19,13285,"None","None",2500,"1998-08-12","5 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",30.4,-27.3,7.4,15.3,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_JMCVX.png"]
[13,"Perkins Small Cap Value T JSCVX","JSCVX",24.23,3099,"None *","None *","closed ","1985-02-14","5 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",36.6,-21.8,3,12.4,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_JSCVX.png"]
[14,"Prudential Asset Allocation B PBFBX","PBFBX",11.74,350,"None",5,2500,"2005-09-30","2 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",18.2,-27.5,3.5,10.9,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_PBFBX.png"]
[15,"Prudential Asset Allocation Z PABFX","PABFX",11.71,350,"None","None",10000000,"2005-09-30","3 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",19.399999999999999,-26.8,4.5999999999999996,12,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_PABFX.png"]
[16,"Prudential CA Municipal Income B PCAIX","PCAIX",10.11,209,"None",5,2500,"2005-04-04","3 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",14.8,-6.7,1.9,4.7,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_PCAIX.png"]
[17,"Prudential CA Municipal Income Z PCIZX","PCIZX",10.11,209,"None","None",0,"2005-04-04","5 stars\r\n                          ","HomeCompaniesFundsETFsMarketsPortfolioHelp & EducationNewsletters",15.2,-6.1,2.4,5.0999999999999996,null,"http://im.morningstar.com/Graph/FOGrowth4YearPNG/USA_PCIZX.png"]
[{"$f":"IF(C19=\"\",\"\",ROWS($A$1:A19)-1)","v":""}]
[{"$f":"IF(C20=\"\",\"\",ROWS($A$1:A20)-1)","v":""}]
[{"$f":"IF(C21=\"\",\"\",ROWS($A$1:A21)-1)","v":""}]
[{"$f":"IF(C22=\"\",\"\",ROWS($A$1:A22)-1)","v":""}]
[{"$f":"IF(C23=\"\",\"\",ROWS($A$1:A23)-1)","v":""}]
[{"$f":"IF(C24=\"\",\"\",ROWS($A$1:A24)-1)","v":""}]
[{"$f":"IF(C25=\"\",\"\",ROWS($A$1:A25)-1)","v":""}]
[{"$f":"IF(C26=\"\",\"\",ROWS($A$1:A26)-1)","v":""}]
[{"$f":"IF(C27=\"\",\"\",ROWS($A$1:A27)-1)","v":""}]
[{"$f":"IF(C28=\"\",\"\",ROWS($A$1:A28)-1)","v":""}]
[{"$f":"IF(C29=\"\",\"\",ROWS($A$1:A29)-1)","v":""}]

{"sheet":"Sheet10","index":3,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,3,5,3]]}
[]
[null,null,"Deferred Load %","Different Page",null,"Deferred Load %"]
["Function:",null,null,null,null,null,"None"]
["Cells.find(cell  (Deferred Load %)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"INDBX"]
[null,null,null,null,null,null,null,"ASBBX"]
[null,null,null,null,null,null,null,"AMGEX"]
[null,null,null,null,null,null,null,"ATGIX"]
[null,null,null,null,null,null,null,"PGIAX"]
[null,null,null,null,null,null,null,"PLTIX"]
[null,null,null,null,null,null,null,"PGVFX"]
[null,null,null,null,null,null,null,"JMVCX"]
[null,null,null,null,null,null,null,"JISCX"]
[null,null,null,null,null,null,null,"JMCVX"]
[null,null,null,null,null,null,null,"JSCVX"]
[null,null,null,null,null,null,null,"PBFBX"]
[null,null,null,null,null,null,null,"PABFX"]
[null,null,null,null,null,null,null,"PCAIX"]
[null,null,null,null,null,null,null,"PCIZX"]