{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Cover","Dates","Text","Replace","Formulas"],"not_rendered":{"images":1,"external_links":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Cover","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"flags":["formulas_cached_only"]}
{"$rows_empty":9}
["STARS Webinar"]
[]
["2010-02-25"]
[]
[]
["Data Issue Examples"]

{"sheet":"Dates","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"flags":["formulas_cached_only"]}
["Dates as Numbers"]
[]
["Sometimes databases export numbers that look like dates but the computer sees as numbers."]
[]
[null,"sample data from a CAMA"]
[null,"appears as a date is a number",null,"DateValue",null,"Paste Special- Value"]
[null,"10/27/2008",null,39748,null,"2008-10-27"]
[null,"5/23/2008"]
[null,"6/19/2008"]
[null,"1/4/2008"]
[null,"11/13/2008"]
[null,"5/14/2008"]
[null,"12/3/2008"]
[null,"8/11/2008"]
[null,"4/29/2008"]
[null,"2/29/2008"]

{"sheet":"Text","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"flags":["formulas_cached_only"]}
["Numbers as Text"]
[]
["Sometimes what appear to be numbers are actually text."]
[]
["Text","Paste Special- Values","Convert Text to Number","Alternate Conversion *",null,"Formula"]
["12345","12345",12345,12345,null,12345]
["321","321"]
["147","147"]
["741","741"]
["357","357"]
["753","753"]
[]
[0,0,12345,12345,"Total",12345]
[]
["* Data / Text to Columns / Orig.Data Type = Delimited / Next / General / Advanced - set decimal and thousands separator / OK / Finish"]

{"sheet":"Replace","index":3,"n_rows":22,"n_cols":3,"rows_kept":22,"flags":["formulas_cached_only"]}
["Issues with using the Replace command in Excel"]
[]
[]
["Original List",null,"Altered List"]
["Fair"]
["Average"]
["Fair +"]
["Average +"]
["Average ++"]
["Average+"]
["Avereage"]
["Fair"]
["Good "]
["Fair +"]
["Good "]
["Average"]
[]
["Considerations:"]
["Largely manual process"]
["Sort dangers"]
["Input dangers: 3..0 instead of 3.0"]
["Must repeat for each new export of data"]

{"sheet":"Formulas","index":4,"n_rows":25,"n_cols":9,"rows_kept":25,"flags":["formulas_cached_only"]}
["Ways of Automating the Conversion - Example of Using a Formula or Table"]
[]
["Formula"]
["Could use a nested IF statement: =IF(H9=\"Flat\",1,IF(H9=\"Moderate\",2,IF(H9=\"Steep\",3,\"\")))"]
[1]
[" - OR -"]
["Table"]
["Data to Use",{"$nulls":4},"Data As Imported"]
["PIN","Nbrhd","Topo","Quality",null,"PIN","Nbrhd","Topo","Quality"]
[1115001,11,1,2,null,1115001,"East Valley","Flat","Fair"]
[1215001,12,2,3,null,1215001,"West Valley","Moderate","Moderate"]
[1011005,10,1,4,null,1011005,"Twin Lakes","Flat","Good"]
[1502010,15,3,4,null,1502010,"Tee Harbor","Steep","Good"]
[]
["*Essential to remember to Paste Special- Values (so you do not past the formulas into STARS)."]
[]
[]
["Neighborhood",null,null,"Topography",null,null,"Quality"]
["Desc","Code",null,"Code","Desc",null,"Code","Desc"]
["East Valley",11,null,1,"Flat",null,5,"Excellent"]
["Tee Harbor",15,null,2,"Moderate",null,2,"Fair"]
["Twin Lakes",10,null,3,"Steep",null,4,"Good"]
["West Valley",12,{"$nulls":4},3,"Moderate"]
[{"$nulls":6},1,"Poor"]
["** Lookup tables can have the description (lookup_vector) and code (recult_vector) in either column but must be sorted by the lookup column."]