Softpedia >Windows >Office tools >Other Office Tools >SOFA Statistics >  Changelog

SOFA Statistics Changelog

What's new in SOFA Statistics 1.4.5

Aug 17, 2015
  • Box plots can be displayed with different outlier and whisker display options. ODS importing can now cope with repeated column names. Better error message when unable to get regression line details because of limited variability.
  • Bug fixes:
  • Fix bug when problem with imported data. Fix to title and date concatenation code so doesn't break when title has non-ascii characters e.g. in Spanish (affecting Windows and Mac) Reordered regression line plotting in js so appears on top of dots. Added zero division error trap to spearman's test error output. Fixed bug which prevented ods_reader from importing repeating rows at the end of a spreadsheet. Only repeated empty rows at the end are considered the end of the data. Properly handle all read operations on internal-use text files e.g. proj, css etc. Can cope with a utf-8 BOM (only) to cope with Windows Notepad editing. Breaks if other encodings used which is fair enough.

New in SOFA Statistics 1.4.4 (May 12, 2015)

  • Bug fixes:
  • Fix bug resulting in Pearson's r being displayed instead of Spearman's rho.
  • Fixed bug on some systems when saving a worksheet with spaces in name.
  • Prevented numerous bugs related to quoting table names, fully qualified file names etc.
  • Fixed bug with misuse of escape_pre_write on python code rather than normal content.
  • Skew, and normality test now cope with the nan issue better e.g. sqrt of a negative number.
  • Just says unable to calculate instead of displaying nan (not a number).
  • skewtest function now copes with negative number as input to square root.
  • Fixed bug when importing NaN text - now treated as a missing value in a numeric field.
  • Removed bug which sometimes prevented Mac users from being able to successfully change the report name.
  • Stopped making export folder if no output to export into it.

New in SOFA Statistics 1.4.3 (Mar 17, 2014)

  • Can import tab-delimited data.
  • More options for attractive charts and reports. Three new themes available - sky, prestige (screen), and prestige (print).
  • Better support for automation (i.e. headless, running without GUI) esp in international context.
  • Exporting to spreadsheet now relies on more robust code library (xlwt)
  • Easy to select or deselect lots of row stats measures at once.
  • Faster opening in many cases.
  • Bug fixes:
  • Minor tweak to PostgreSQL plug-in to handle timestamps without timezone.
  • Resolved bug when SQLite numbers are stored in a non-numeric field and processed for Chi Square test.
  • Importing csvs now copes better when only missing vals in sample of a field. Gives user the choice.
  • Fixed bug when doing a Row Stats table with a rows variable e.g. by Gender and some of the fields can't be calculated for some of the row categories.
  • Headless importing now works in the event of inconsistent data types in fields.
  • Headless importing now reads entire dataset rather than a sample to avoid need for (human) decisions.
  • Scripts no longer rely on translated arguments. Much safer to use on other machines with different locales.
  • Fixed circular import bugs which only became visible when other bugs occurred.

New in SOFA Statistics 1.4.2 (Feb 27, 2014)

  • Fixed bug introduced in 1.4.1 which stopped SOFA working with MS Access databases.
  • Fixed misc bugs associated with sort order of value labels when configuring a variable. Default project path for sofa_db connection now copes with paths containing single quotes e.g. Grant's Machine.
  • Fixed bug which occurs when running scripts directly in a non-English locale. The locale folder stored in the script is now the one the GUI identified as the correct one. So translated config e.g. for Mean, Sum etc will match what it should.

New in SOFA Statistics 1.4.1 (Feb 27, 2014)

  • Fixed bug in charting when users use variable names SOFA used in underlying SQL queries.
  • Fixed bug when refreshing database table dropdowns when no databases visible - was assuming the databases were included in the number of items in the sizer.
  • Fixed bug when print content redirected to output file in Windows and Mac - now coverted to utf-8 byte strings directly by overriding sys.stdout and sys.stderr with codecs.getwriter etc.
  • Immediate impact is fix for bug when recoding a table and field names include non-ascii characters.
  • Fixed up fonts used so always look good on all systems.
  • Fixed bug which can occur when designing a new table. If we recode it before clicking the Update button, SOFA thinks we are trying to override another table of the same name. This is because SOFA started out thinking our table had no name and was never updated to tell it otherwise. Minor changes to enable translation.
  • Fixed bug when importing empty pairs of double or single quotes. These were already being de-escaped (as a side-effect of the approach necessary to handle internal quote escaping in the csv module) and turned to solo quotes - and thus evading the check for blank raw vals which would have been turned to NULL.
  • Fixed bug giving error message for too many rows instead of too many columns when too many columns e.g. in Chi Square test. SOFA now checks very early to see if you've installed SOFA under a local user folder instead of a program folder.
  • Fixed bug in PostgreSQL plug-in when working with a numeric field lacking a defined decimal points or numeric precision setting. Show scatterplot minor axis ticks more readily so better when fewer distinct x values. Scatterplots cope with absence of variability in an axis by forcing a different min and max for that axis.

New in SOFA Statistics 1.4.0 (Dec 16, 2013)

  • Cleaner interface for viewing, saving, and exporting output. Data export to spreadsheet plug-in now automatically exports as csv as well as xls. Data importing copes with spaces at the end of dates - trailing spaces are removed and the value is treated properly as a date.

New in SOFA Statistics 1.3.5 (Oct 14, 2013)

  • Fixed bug in histogram output when limited data spread. Error caused by miscalculation of significant decimal points required for display.
  • Fixed bug stopping late-added title details appearing when exporting output. The demo output is refreshed first so the source file is forced to be up-to-date. Probably needs a proper tidy-up some day but this works well in the mean time.
  • Fixed bug in exporting to desktop folder in fix_pdf - need to strip end off folder name when no AM/PM under localisation used.
  • Fixed various bugs associated with exporting output. When copying output, message about keeping form open now names form it means (to reduce confusion).
  • Fixed bug when using a project after it has just been deleted (by pressing cancel in select projects dialog after having deleted the currently active project).
  • Fixed bug which meant "Show Results" and "Add to report" options were displayed when setting up a project.
  • Fixed bug when cancelling a variable details selection in a project.

New in SOFA Statistics 1.3.4 (Jul 23, 2013)

  • Bug fixes:
  • Fixed bug with calculation of mean with MS SQL Server data (now explicitly cast as float to avoid integer result).
  • Fixed bug in ANOVA output for precise (as opposed to speed) - it used to try mixing Decimals and other numeric types unsuccessfully.
  • Fixed bugs with chart data gathering queries so works in MS SQL Server properly. Also cleaner for the others in any case.
  • Fixed bug in underlying code if unique=False ever applied with scatterplots (currently never but it was still, technically, a bug).
  • Fixed bug in scatterplot SQL which affected MS Access and MS SQL Server (can't use aliases in group by etc).
  • Adjusted y-title position in dojo scatterplots to avoid it being cropped.
  • Fixed bug when Postgresql date date being displayed as a category (couldn't calculate a length of a datetime.datetime object).
  • Fixed layout bug when report table resized after Add to Report checkbox hidden. Now freshens layout when checkbox reappears.
  • Fixed bug preventing charts from being produced when linked to MS Access.
  • Fixed bug adding large delay to display of output when linked to MS Access.

New in SOFA Statistics 1.3.3 (Apr 25, 2013)

  • 95% confidence intervals now added to ANOVA and t-tests
  • Right justified numbers in associated output
  • Can now sort by category labels in clustered bar charts, line charts, area charts and box plots
  • Area charts can also be sorted ascending or descending by count/mean/sum
  • The series and category are now displayed in tooltips e.g. Italy, 20-29 for clustered bar charts, multi-series line charts, and box plots. This is especially helpful when there are lots of categories and/or series
  • Improved statistics output footnotes
  • Borders on bar-type charts are now optional
  • Chi square clustered bar charts can cope with higher default limits for number of values
  • Importing field names with more than 90 characters prohibited at the point of import rather than causing problems later
  • The group by max number of values is now controlled by a single my_global setting (making it easier to override)
  • The default settings for some remaining max values have been increased
  • Bug fixes:
  • Line charts now cope better with lots of categories (increased padding around max label width in overall width calculations).

New in SOFA Statistics 1.3.2 (Jan 28, 2013)

  • Minor GUI bugs on start screen fixed.

New in SOFA Statistics 1.3.1 (Jan 10, 2013)

  • Fixed code picking optimal min and max axis values for scatterplots and box plots to cope when value range is much smaller than gap to 0.
  • CSV import now copes with new lines inside fields when gathering data for sample display.
  • Extra settings for Line Charts now display when they should even if only changing data type.
  • Fixed bug which allowed line breaks in field names.

New in SOFA Statistics 1.3.0 (Nov 5, 2012)

  • Added Mode as an option to Row Stats report tables.
  • Line and area charts can show major labels only as an option.
  • Pie charts now have option of displaying count and percentage (not just in the tooltips as at present).
  • Histograms use consistent bins when charted by a second variable.
  • Better placement of y-axis title when wide labels.
  • Pie charts keep consistent colors even if sorted by count rather than value or label.
  • Better message when adding new reports if required subfolder with javascript and background images is missing. Only show message now if a problem. When trying to export report, SOFA checks for expected subfolder as well (otherwise dojo fails for any charts and export fails).
  • SOFA prevents attempt to export report if no report file (yet).
  • No longer displays View or Export Report buttons on Projects dialog.
  • Bug fixes:
  • Fixed bug in row stats where data should have explicitly filtered out None values.
  • Fixed bug in setting of min and max values for y-axis for boxplots when min is below 0.
  • Pie charts keep consistent colours for categories even if order differs between charts in a series.
  • Refactored code for running report in output module. Easier to understand and also made it easy to save copy of internal html output with absolute paths to images - very helpful when exporting images.
  • Built more robust value quoting e.g. for sql statements.

New in SOFA Statistics 1.2.2 (Sep 20, 2012)

  • Restored standard deviation option to row stats report tables.
  • Fixed bug which meant row % was appended multiple times to config col dialog (until session closed).
  • Restored PostgreSQL functionality by fixing faulty psycopg import statement.

New in SOFA Statistics 1.2.1 (Aug 29, 2012)

  • Fixed nasty bug breaking demo report tables. A casualty of the changes to the independent display of titles from report tables in 1.2.0 so wide titles didn't mean wide table cells.
  • Fixed bug with display of percent symbols in report tables. A missing not was the culprit - another casualty of the big refactoring for 1.2.0.
  • Fixed bug with Data List reports - wouldn't update display after changing sort order of a variable.
  • Sort by value now works properly in Data List reports.
  • Can now handle excessively long values being used as categories in report tables or charts etc. Checks are also now made for excessively long category variable values.
  • If encoding problems try to use the field encoding e.g. iso-8859-1.

New in SOFA Statistics 1.2.0 (Aug 18, 2012)

  • Bug fixes:
  • Fixed bug when more colours are required for auxiliary clustered barcharts than in the css.
  • Fixed bug re: linked images with non-English characters not displaying in GUI html window (still issue if user relying on IE6).
  • Fixed bug which made report tables widen if the title or subtitle was wider.
  • Fixed bug where removal of filter in the charting dialog would change third variable dropdown to the last value it had when the filter was applied even if it had subsequently been changed to the Nothing Selected value.
  • The default values are now updated everytime the dropdowns change.
  • Now a guaranteed consistency in series colours across charts even if a series is missing e.g. the middle one, from one of the charts.
  • Misc bug fixes for stats tests where no variability.
  • Better user messages. Independent variable tests cope with new lines in text values.
  • Histograms all get title case titles if no value label instead of upper case.
  • Fixed bug when filtering results in no group a and b values possible in indep2var analyses.
  • Fixed histogram width issue esp if wide numbers e.g. 12000 is wider than 12. Fixed css display problem in webkit internal browsers.

New in SOFA Statistics 1.1.7 (Jul 7, 2012)

  • Fixed bug encountered when importing spaces in fields.
  • Fixed bug when missing values in some fields in a boxplot with multiple series.
  • Table design changes now cope with pre-existing sofa id index and demo values no longer updated on exit (inadvertently via on_show event).
  • Fixed bug in tooltip display of averages in general charts - no longer rounds to lower integer.
  • Charts of averages don't show percentages in tooltips.
  • All matplotlib histograms, including those in stats display such as for one-way ANOVAs, now cope with sigma of 0.
  • Fixed bug calculating percentages where all values in a chart (of a series) are 0
  • Fixed bug in showing rotate when changing to clustered bar charts.
  • Fixed bug in ods importing where display of sample values didn't include repeated cells (only showing the first value).
  • SQLite now correctly identifies more types as numeric.

New in SOFA Statistics 1.1.6 (Jul 7, 2012)

  • Fixed ODS import bugs when encountering fields formatted as fractions, boolean, percentage etc.
  • Fixed bug stopping linked images external to the html e.g. generated by matplotlib, from displaying in the internal GUI if the report path was different from the default report path.
  • Fixed bug when running scatterplots and histograms with chart by (because of use of dd object which cannot be used headless).
  • Fixed bug in charts dialog where second variable drop down would sometimes be overly restrictive when doing a chart of average values.
  • Fixed bug where old pycs can interfere with Windows upgrades.

New in SOFA Statistics 1.1.5 (May 28, 2012)

  • Charts now have the option of rotated (vertical) x-axis labels. This can be useful for longer labels.
  • Scatterplots now focus on the data better by starting axes just below the minimum x and y values of the data unless the value is close enough to 0 to make it worth using 0 anyway.
  • Numeric values are right justified in data tables.
  • Kurtosis values in the normality test include the Fischer adjustment (subtracting 3).
  • Duplicated field names in imports are given unique suffixes and allowed (now that they are unique).
  • Excel importing now handles times without dates.
  • More date formats are accepted when importing data.
  • Better guidance on data preparation before importing data.
  • More robust handling of variable definition files if corrupted.
  • Note: if upgrading on Linux, the two user folders (sofastats and sofastats_recovery) may be shifted from inside your home folder to a better location e.g. "/home/username/Documents" if free desktop standards are supported. After upgrading you may wish to manually replace the contents of the new folders with the contents of the old ones.

New in SOFA Statistics 1.1.4 (Feb 24, 2012)

  • Fixed bug where getting observed values e.g. for chi square test, fell over when one field in pair had missing values while the other didn't.
  • Fixed bug in calculation of upper and lower whiskers in box plots. Single bar charts don't show a bar title anymore - only needed if multichart.
  • Fixed bug which only changed variable definitions when the extra settings dialog was closed with OK and didn't ever set it otherwise e.g. when changing the selected project.
  • Now copes with newer versions of matplotlib on Linux.
  • No longer stores empty strings as variable labels if user doesn't enter a label.

New in SOFA Statistics 1.1.1 (Oct 11, 2011)

  • More sophisticated extraction of cell values from ODS spreadsheets. Now copes with formatted content of cells and other complex cases by handling subelements in the XML.

New in SOFA Statistics 1.1.0 (Aug 22, 2011)

  • Much easier access to data - can now open data table from anywhere the table can be selected e.g. charts, report tables, stats analyses.
  • Importing from Google Doc spreadsheets now automatically starts import process if downloading was successful.
  • Easier importing from spreadsheets - SOFA now shows user first 4 rows of spreadsheets so user can decide whether has a header or not.
  • Windows users can install into any folder now, not just one with sofastats in the name.

New in SOFA Statistics 1.0.7 (Jul 28, 2011)

  • Fixed bug in chi square when no labels set for numerical variables. Needed to convert value to unicode before using as label.
  • Fixed bug when importing datetimes with 'T' as the separator between date and time.
  • Fixed bug caused by SQLite queries sometimes returning strings instead of floats when extracting REAL (numeric) data. Fixed it where it affected Row Stats medians and std devs; and statistical tests.
  • Fixed bug when uwhisker and lwhisker not set. Also copes better when no boxes are displayed in boxplot.
  • Handling Python 2.6 unicode keyword bug.
  • Replaced pprint.pformat where it messes up unicode e.g. user paths with non-ascii characters. Misc other changes to fix internal issues.
  • Fixed bug allowing None to be displayed in Val A and Val B drop-downs under Group by e.g. ANOVA.
  • Config dialog in Report Tables widened slightly when needed to display title.
  • Fixed bug when decimal entered into value label list for an integer field.
  • Fixed CSV import bug when trying to guess whether a header or not.

New in SOFA Statistics 1.0.6 (Jun 4, 2011)

  • Fixed bug preventing comma being used as decimal separator when importing data.
  • Fixed bug when making line charts with averages - shows smoothed data line and trend line appropriately. Also only enables or disables checkboxes for smoothed data line and trend line where appropriate.
  • Better handling of comtype errors.
  • Fixed bug in histogram code when no default limits supplied.

New in SOFA Statistics 1.0.5 (May 17, 2011)

  • Fixed bug occurring when user selects a google docs spreadsheet and clicks on download after manually selecting a spreadsheet but without manually selecting a worksheet.
  • Fixed bug with report tables which occurred sometimes when a field value was the same as a field name.
  • Fixed bug when pie chart label has new line characters in it.
  • Adjusted y-axis placement on bar charts so not truncated in some cases.
  • When importing ODS data without a header, and responding to a data type inconsistency with Cancel, the progress bar is now reset to the start.
  • Fixed bug when saving projects in Windows with different name (albeit the same name if case insensitive). Would not appear in projselect list and would be unable to reopen projselect.

New in SOFA Statistics 1.0.4 (Apr 13, 2011)

  • Added a new "Get Started" button to main form and emphasised the most important buttons.
  • When importing csv files, SOFA now sets the default for 'Has header row?' according to a review of the sample contents.
  • On exiting for the first time, users get option of giving brief feedback.
  • Added feedback link to main form.
  • Exit control added to all forms where appropriate.

New in SOFA Statistics 1.0.3 (Mar 21, 2011)

  • Bug fix when importing from ODS any data which could potentially be a year e.g. 2631.
  • Report quality histograms no longer leave out values falling right on the upper limit.
  • Two-tailed vs one-tailed corrections in output display.
  • Fixed problem with table names (esp safetblname) surviving test for SQLite validity and breaking future tests.

New in SOFA Statistics 1.0.2 (Feb 10, 2011)

  • Fixed bug when reporting on datetime fields as rows or columns in report tables in MySQL, PostgreSQL, Access, and SQL Server.
  • Fixed minor bug which meant MySQL importing failed on Macs because it didn't recognise the platform.

New in SOFA Statistics 1.0.1 (Feb 3, 2011)

  • More netbook-friendly - the start dialog and the statistical test selection dialog now have special versions for smaller screens
  • Importing (and recoding) now accepts field names with dots
  • Better feedback to user when too few values in sample for analysis
  • Fixed bug preventing single reports from having multiple styles
  • Fixed error in O'Brien's homogeneity of variance test

New in SOFA Statistics 0.9.25 (Jan 24, 2011)

  • Changing folder locations from sofa to sofastats. If you are reinstalling SOFA and wish to keep previous settings, rename your existing username/sofa folder to username/sofastats first.
  • More useful version upgrade checking. Auto-checking for any version upgrades is now the default. Users can disable this feature by selecting the "No checking" option, or only auto-check for major upgrades. This feature only reads the contents of a small text file on the sofastatistics.com domain containing the latest version number.
  • SOFA suggests names more likely to be valid when user selects a file for importing.
  • Can now import csv files with a txt extension.
  • MySQL and PostgreSQL can now accept blank passwords.
  • Better message for user if comtypes problem.
  • Windows and Mac versions will no longer accept being launched with Python 2.7 and will give useful messages about fixing the problem. For Windows, the importance of installing the site-packages to python26 rather than python27 is explained.

New in SOFA Statistics 0.9.24 (Dec 23, 2010)

  • Major bug fix for problem introduced in 0.9.23 which prevented Excel importing.
  • PostgreSQL and MS SQL Server now cope with databases which are listed but where a connection is not possible e.g. because of permissions.
  • Fixed minor bug in sqlite table name test - now commits when making table and before dropping it so a chance to succeed or fail on individual step. Otherwise, net effect is no change (table added and removed) so no chance to fail.
  • Safer reading and executing project and variable detail code in Windows (change new lines to required sort).
  • Now possible to run test code in Windows (change new lines to required sort).
  • Fixed bug when refreshing default sofa tables but not in the sofa sqlite connection.

New in SOFA Statistics 0.9.23 (Dec 14, 2010)

  • All lines in multi-line text cells are now imported from ods spreasdsheets correctly.
  • Errors when getting project settings file at start return useful message and don't fail because tried to use msgbox before the GUI application is running.
  • Better handling of errors when identifying date format. Falls back to a reasonable default.
  • Fixed error preventing message being shown when unable to change database details e.g. selecting a different db in the drop-down.
  • Fixed bug in legend of auxiliary clustered bar charts when long value labels. Now has automatic line splitting.
  • Correct initial display of csv data when importing if missing cells in some rows.
  • Majorly reduced impact of bug when creating report tables using numbers with more decimal points than python displays when converting to text e.g. into an SQL statement ready for execution.
  • CSV importing now provides useful error messages if actually an Excel spreadsheet saved as a csv with Excel features preserved (i.e. a faulty csv file). Also copes better with faulty delimiters being manually supplied.

New in SOFA Statistics 0.9.22 (Nov 11, 2010)

  • Scatterplots can be run in series e.g. by country
  • SOFA now checks (or not) for upgrades according to user preferences.
  • Translations all working (Croatian, Spanish, Russian, Galician, and Breton).
  • Less alarming message when PostgreSQL not installed on a system.
  • Better handling of python version mismatch taking OS into account.
  • Better help text for report tables and Data Entry/Editing menu choice.
  • Warning about changes to default report on version change now appear on top of main start screen not before it.

New in SOFA Statistics 0.9.21 (Oct 30, 2010)

  • Can now make chart series e.g. separate Pie Charts of Satisfaction Level for each Region.
  • Much nicer images on main menu.
  • Better printing of output reports through web browsers e.g. Firefox.
  • Major bug fix for Windows users with certain user names.
  • Imports numeric fields in csv files as numbers even if using commas as decimal separator (e.g. as in Germany).
  • Shifted Help button to top left of main dialogs.
  • Removed Export button (from view).
  • Changed text in Run button to Show Results.
  • Mann-Whitney U now explicitly says it is one-tailed.
  • Discreet "sofastatistics.com" text added to edge of each graphic.

New in SOFA Statistics 0.9.20 (Oct 12, 2010)

  • Legend closer to charts and outer background colour now covers the x-axis labels.
  • Better placement of y-axis titles.
  • SOFA warns user if not enough suitable variables for an analysis - e.g. paired t-test - and suggests a likely cause and solution.
  • Default sofa_db row in projects is read-only.
  • Better message to user if attempting to connect to an empty SQLite database.

New in SOFA Statistics 0.9.19 (Oct 6, 2010)

  • Simple bar charts and pie charts have sort option (none, by label, by frequency, by descending frequency).
  • Can include or exclude display of percentages in bar, line, and area charts.
  • Axis titles on charts are now bold and better positioned vertically to distinguish more easily from axis labels.
  • Histograms have more human-friendly bins.
  • Simplified analysis dialogs by shifting some settings into separate dialog.
  • Better looking chart type buttons in chart dialog.
  • Long chart labels split into lines.
  • Scatterplots have option of removing dot border (useful if almost all values are overlapping other values e.g. in a line).
  • Added hour glass for display of chart output (can matter for scatterplots on slower machines).
  • Existing default report is archived on upgrade to ensure any new chart content displays correctly in the default output.

New in SOFA Statistics 0.9.18 (Sep 27, 2010)

  • Beautiful Histograms and Scatterplots added.
  • Support charts for statistical tests now themable like main output charts.
  • Tool tips now display arrows (with border colour controlled by selected theme).
  • Charting dialog devotes more space to displaying chart output. Simplified interface design.
  • Charts give sensible message if no data (perhaps because of filtering). X axis labels for clustered bar charts and multiple line line charts where legend doesn't provide the same label.
  • Pie charts slightly wider (esp on Windows, which truncates overwidth labels).

New in SOFA Statistics 0.9.17 (Sep 18, 2010)

  • Beautiful Line and Area Charts with dynamic eye candy.
  • Smaller javascript file for faster loading of charts.
  • Added y-axis labelling to charts.

New in SOFA Statistics 0.9.16 (Sep 13, 2010)

  • Beautiful Pie Charts and Clustered Bar Charts with dynamic eye candy.
  • Themes can be applied to charts e.g. Grey Spirals, Pebbles.
  • Added percentages to tooltips of Bar Charts.
  • More improvements to installation process, especially on top of existing installations.
  • More robust CSV and ODS importing.

New in SOFA Statistics 0.9.15 (Aug 30, 2010)

  • Beautiful bar charts with dynamic eye candy
  • Better installation process, especially on top of existing installations.

New in SOFA Statistics 0.9.14 (Aug 17, 2010)

  • Added min, max, and range to row stats tables.
  • Report tables are much easier to read when there are multiple row variables. Added pale line between row variables in left-most column.
  • CSV importing has been substantially improved. User gets option of confirming or changing auto-identified csv file delimiter and encoding. Confirming presence of a header is also integrated and the first 20 rows are displayed in a table with visible cell borders. The import is more forgiving of some faults e.g. missing items at the end of a row. These are automatically filled with empty strings. When errors are encountered in csv import SOFA tells user the relevant line number. Also made other minor improvements to (error) messages from csv importing.
  • Added Filter button next to Table dropdown to make filtering functionality of SOFA more accessible.
  • Much simpler installation for Ubuntu/Linux Mint users. No additional steps required now that SOFA has started using gtk-webkit.
  • ANOVAs and similar group by analyses now cope with massive tables when selecting unique values to show in group by drop downs.
  • Appropriate messages are shown to users when large tables underlying analyses are about to be run. The user can opt out.
  • Changed default for Anova from precision to speed.
  • Better messages when chopping group by values shown.
  • If SOFA has been opened by an incompatible version of Python it will give a useful message and leave a helpful text file behind with instructions for fixing the problem.
  • Better messages when Chi Square warnings about number of rows, cols, or cells.
  • Better tool tip for setting MS SQL Server host e.g. my-svr-01, 1433.
  • Added minor improvement to tool tips for data tables. It now always shows labelled value if possible and read only status as suffix as appropriate.
  • Created more robust startup process with better error messages. Users also able to run test code (e.g. sent by the SOFA developer) and get result. Great for diagnosis.
  • Overhauled start code so checks version if possible, updates version, and makes a recovery folder if not current.