{"id":264,"date":"2010-03-22T03:14:39","date_gmt":"2010-03-22T07:14:39","guid":{"rendered":"http:\/\/www.sofastatistics.com\/blog\/?p=264"},"modified":"2010-03-22T03:14:39","modified_gmt":"2010-03-22T07:14:39","slug":"0-9-6-easier-frequency-tables-faster-large-data-tables-can-import-calcgnumeric-spreadsheets","status":"publish","type":"post","link":"http:\/\/www.sofastatistics.com\/blog\/0-9-6-easier-frequency-tables-faster-large-data-tables-can-import-calcgnumeric-spreadsheets\/","title":{"rendered":"0.9.6 Easier frequency tables; faster large data tables; can import Calc\/Gnumeric spreadsheets"},"content":{"rendered":"

The latest version of SOFA Statistics (0.9.6) is well worth the upgrade.\u00a0 Deep down, I was never happy with the approach to creating frequency tables.\u00a0 It was elegant in some ways to think of frequency tables as a special case of a rows x columns report tables but it was still a mistake.\u00a0 Now there are four types of report table – Frequencies, Crosstabs, Row summaries (means etc), and simple Data Lists.\u00a0 Here is how to make a simple Frequency Table for Age Groups with column percentages:<\/p>\n

\"New<\/a>

New Frequency Tables Interface<\/p><\/div>\n

Also, large data tables load almost instantly now.\u00a0 The table I just opened was over 200,000 rows and it simply appeared as soon as I clicked on the Open button.<\/p>\n

The third major advance is for people who want to work with spreadsheets.\u00a0 Until now, Excel has been the only option, which is only available on Windows systems.\u00a0 Now users can enter data into an OpenOffice Calc or Gnumeric spreadsheet and it should be possible to import it successfully.\u00a0 Please let me know how that goes.<\/p>\n

\"ODS<\/a>

ODS spreadsheets<\/p><\/div>\n

Here is the full list of new features:<\/p>\n

    \n
  • Added Frequencies as new report table type and substantially improved ease-of-use.<\/li>\n
  • Major speed-up when opening data files as larger files no longer have their columns autosized.\u00a0 There is a button to allow that to be triggered manually.<\/li>\n
  • Now able to import from ods files including OpenOffice Calc and Gnumeric-derived spreadsheets.<\/li>\n
  • Action buttons on report tables form enabled\/disabled according to completeness of configuration data.<\/li>\n
  • The import button is disabled until suitable file and table names have been entered.<\/li>\n
  • \nShifted more close buttons to bottom right location.<\/li>\n
  • Minor improvements to wording of importer dialog to reduce possible confusion.<\/li>\n
  • The actual results continue to show for a report table if the user cancels changing the row or column configuration.\u00a0 Doesn’t revert to demo data.<\/li>\n
  • Importing now turns single dots ‘.’ into nulls (missing data) and informs the user.<\/li>\n
  • Better error messages if import file not found.\u00a0 Sets focus on SOFA Table Name if not provided.\u00a0 Better handling of missing\/misnamed css files.<\/li>\n
  • Variable setting dialog now appears in more sensible position – esp on a notebook or netbook.<\/li>\n<\/ul>\n

    The bug fixes will probably be as important, especially if you have experienced any of them:<\/p>\n

      \n
    • Fixed integer division issue which meant all row and column percentages were rounded down. Now 100.0* … rather than 100* …<\/li>\n
    • Now copes with odd field names like ‘weight(kg)’ and ‘strength\/100’ that would have broken SQL.<\/li>\n
    • Opening the project select dialog now displays the notes for the selected project, which is not necessarily the first one.<\/li>\n
    • Fixed bug which made csv importing unable to recover from data type mismatch. Also fixed bug in csv importing when importing missing cells. Now actual extracts nulls rather than the text ‘None’.<\/li>\n
    • Minor fixes to row button enabling\/disabling on report table dialog.<\/li>\n
    • Fixed misc bugs that became apparent in Windows: right clicking opened dialogs twice; faulty script generation after changing table type; problems with ending busy cursor; and not giving proper message when no data in table.<\/li>\n
    • Fixed raw table display problem – now shows raw value if no label available for particular item.<\/li>\n
    • Project notes can cope with backslash U etc. Now escaped when written to project file.<\/li>\n
    • Can view internal tables with dots in the name.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

      The latest version of SOFA Statistics (0.9.6) is well worth the upgrade.\u00a0 Deep down, I was never happy with the approach to creating frequency tables.\u00a0 It was elegant in some ways to think of frequency tables as a special case of a rows x columns report tables but it was still a mistake.\u00a0 Now there […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-264","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/264","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/comments?post=264"}],"version-history":[{"count":5,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/264\/revisions"}],"predecessor-version":[{"id":271,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/264\/revisions\/271"}],"wp:attachment":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/media?parent=264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/categories?post=264"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/tags?post=264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}