Opening an Excel file in BlueSky Statistics:
============================================

Q: What special characters in the column names do we rename?
A: Excel column names having special characters (i.e.@,(,),.,%)   are replaced with dots(.) by R. In BlueSky Statistics application we cannot use    the column names with special characters so we replace those with the underscore. One underscore per special character. In variable grid column    names shown are C# version of the column names but in datagrid the column names are shown just as they appear in R.

Q: How do we select the column types i.e. factor, numeric?
A: Excel columns having strings are treated as “factors” in the BlueSky Statistics.
   Excel numeric columns are “numeric” in BlueSky Statistics.
   Excel Date columns are “date” type in BlueSky Statistics.
   Excel’s empty cells of a column are treated as “NA”

Q: XLSX vs. XLS format.
A: We can load Excel 97-2003 ( .XLS) and Excel 2007 and onward (.XLSX).
   We can only save to Excel  2007 and onward (.XLSX) format.

Q: How are dates handled?
A: Excel Date column appears as Date and time in BlueSky Statistics.

Q: Opening multiple data sheets.
A: You can open multiple sheets in an Excel file however each sheet is a separate dataset in BlueSky Statistics. While opening the Excel file you    will be prompted to select the sheet to open. You will have to select one sheet at a time. Each sheet becomes a separate dataset.

Q: What happens when the Excel column names starts with a number?
A: In R you cannot have a dataset where a variable name/column name in that dataset starts with a number. When Excel column names starts with a    number, the column names is prefixed with a ‘X’ when opened in BlueSky Statistics.
   If a column name is blank in the Excel then we give it a default name like Var1, Var2 and so on.


Opening a CSV file in BlueSky Statistics:
=========================================

Q: What special characters in the column names do we rename?
A: In BlueSky Statistics application we cannot use the column names with special characters (i.e.@,(,),.,%)    so we replace those with the    underscore. One underscore per special character. In the variable grid column names shown are C# version of the column names but in datagrid the    column names are shown just as they appear in R.

Q: How do we select the column types i.e. factor, numeric?
A: CSV columns having character column type are treated as “character” type in the BlueSky Statistics.
   CSV numeric columns are “numeric” type in BlueSky Statistics.
   Empty cells in a column are treated as “NA”

Q: How are dates handled?
A: CSV Date column appear as character type in BlueSky Statistics.

Q: What happens when the column names starts with a number?
A: When CSV column names starts with a number, the column names is prefixed with a ‘X’ when opened in the BlueSky Statistics application.
If a column name is blank in the CSV then we give it a default name like Var1, Var2 and so on.