{"id":39709,"date":"2018-07-26T03:01:37","date_gmt":"2018-07-25T17:01:37","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/ITblog\/?p=39709"},"modified":"2018-07-26T09:43:18","modified_gmt":"2018-07-25T23:43:18","slug":"libreoffice-spreadsheet-via-dbase-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/libreoffice-spreadsheet-via-dbase-primer-tutorial\/","title":{"rendered":"LibreOffice Spreadsheet via dBase Primer Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice_dbf_xls_pivot_table.pdf\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"LibreOffice Spreadsheet via dBase Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice_dbf_xls_pivot_table.jpg\" title=\"LibreOffice Spreadsheet via dBase Primer Tutorial\"  \/><\/a><p class=\"wp-caption-text\">LibreOffice Spreadsheet via dBase Primer Tutorial<\/p><\/div>\n<p>When we presented the blog posting thread ending with <a target=_blank href='https:\/\/www.rjmprogramming.com.au\/ITblog\/dams-in-the-united-states-timeline-tutorial\/' title='Dams in the United States Timeline Tutorial'>Dams in the United States Timeline Tutorial<\/a> its data basis had the same origin as today&#8217;s, that being the wonderful United States data resource website <a target=_blank title='US data.gov' href='http:\/\/data.gov'>data.gov<\/a> website.  From there we got to a website of interest, as following our interest in bees (and ants) to <a target=_blank title='El Programa Cooperativo Sobre la Apifauna Mexicana' href='http:\/\/wwx.inhs.illinois.edu\/collections\/insect\/data\/mexican-bee\/'>El Programa Cooperativo Sobre la Apifauna Mexicana<\/a> (a database in <a target=_blank title='dBase database' href='http:\/\/www.dbase.com\/'>dBase<\/a> format &#8230;<\/p>\n<blockquote cite='http:\/\/wwx.inhs.illinois.edu\/collections\/insect\/data\/mexican-bee\/'><p>\nThe PCAM (El Programa Cooperativo Sobre la Apifauna Mexicana) Database of Mexican Bees,with Floral Records;by Douglas Yanega, Illinois Natural History Survey. Funded by NSF Grant#BSR-90-24723 to Wallace E. LaBerge (INHS) and Ronald J. McGinley (Smithsonian Institution), principal investigators.\n<\/p><\/blockquote>\n<p> &#8230; regarding Mexican bees).<\/p>\n<p>We then realized these loose dBase database files have header records within them, where there is enough information for those (previously readable by FoxPro) dBase database (*.dbf) files be read by <a target=_blank title='LibreOffice' href='http:\/\/libreoffice.org'>LibreOffice<\/a> Spreadsheet functionality and then Save As Microsoft Excel *.xlsx format.<\/p>\n<p>As might be more familiar to most of us, once you have the data in Microsoft Excel *.xlsx format, a whole new world of functionality is available to you, some of which we touch on with today&#8217;s <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice_dbf_xls_pivot_table.pdf\" title=\"Click picture\">PDF slideshow<\/a> presentation &#8230;<\/p>\n<ul>\n<li>formulae best applicable to numerical data columns of the spreadsheet<\/li>\n<li>scenarios &#8230; like views of the data with styling choices<\/li>\n<li>pivot table creation to check the validity of data, a pretty important tool for large data sets, as a pivot table can summarize and collate the data to check for weird aberrations perhaps<\/li>\n<\/ul>\n<p> &#8230; and amongst the many functionalities in &#8220;not shown&#8221; you should know that spreadsheets and charts are good bedfellows of functionality.<\/p>\n<p>We hope this synergy between spreadsheets and RDBMS (relational database management system) systems is of help to you.<\/p>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d39709' onclick='var dv=document.getElementById(\"d39709\"); dv.innerHTML = \"<iframe width=670 height=600 src=\" + \"\/\/www.rjmprogramming.com.au\/ITblog\/tag\/database\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d39709' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n","protected":false},"excerpt":{"rendered":"<p>When we presented the blog posting thread ending with Dams in the United States Timeline Tutorial its data basis had the same origin as today&#8217;s, that being the wonderful United States data resource website data.gov website. From there we got &hellip; <a href=\"https:\/\/www.rjmprogramming.com.au\/ITblog\/libreoffice-spreadsheet-via-dbase-primer-tutorial\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,12,37],"tags":[290,2628,2146,299,2627,407,602,694,1838,1185,1319],"class_list":["post-39709","post","type-post","status-publish","format-standard","hentry","category-database","category-elearning","category-tutorials","tag-data","tag-data-processing","tag-data-gov","tag-database-2","tag-dbase","tag-export","tag-import","tag-libreoffice","tag-pivot-table","tag-spreadsheet","tag-tutorial"],"_links":{"self":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/39709"}],"collection":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/comments?post=39709"}],"version-history":[{"count":4,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/39709\/revisions"}],"predecessor-version":[{"id":39721,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/39709\/revisions\/39721"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=39709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=39709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=39709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}