{"id":328,"date":"2018-11-29T17:18:23","date_gmt":"2018-11-29T17:18:23","guid":{"rendered":"http:\/\/www.cdesystems.co.uk\/?page_id=328"},"modified":"2018-11-29T17:18:23","modified_gmt":"2018-11-29T17:18:23","slug":"whynotexcel","status":"publish","type":"page","link":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/?page_id=328","title":{"rendered":"Why Not Excel?"},"content":{"rendered":"<h2>#0: Why Not Excel?<\/h2>\n<p>In many cases excel is the best tool for the job so why not use it? Rather than build a full database and\/or interface, Excel is an easy and quick way to gather and analyse data.<\/p>\n<p>Even though Excel is not a database in many organizations people store more data in spreadsheets than any other document type. It\u2019s not the preferred method for IT professionals, but it works. People need to analyse and access data quickly, they know Excel and it\u2019s usually already installed.<\/p>\n<p>Although Excel is not a relational database it can solves many simple database problems. Only a small percentage of Excel spreadsheets reach the limits of Excel, but when they do, many should and do migrate to a database solution.<\/p>\n<h2><strong>#1: So Really Why Not<\/strong><\/h2>\n<ul>\n<li>If the data is spread across more than one excel document it\u2019s almost certainly time to consider a database solution. If it\u2019s spread across hundreds or thousands it\u2019s time to consider a database to manage the spreadsheets themselves!<\/li>\n<li>More than one user can\u2019t update the information in a document at once. If there are more than two or three people regularly inputting data then a database will allow multiple users to make changes at the same time.<\/li>\n<li>If the amount of data is unmanageable in spread sheet form. If the number of columns get much beyond 52 (AZ) then it can be hard to keep track. Adding rows usually isn\u2019t a problem no matter how many there are, but changing and finding individual records can be very time consuming the more rows added.<\/li>\n<li>If you want to collaborate across the internet and you don\u2019t have Office365 or Excel 2013.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>#0: Why Not Excel? In many cases excel is the best tool for the job so why not use it? Rather than build a full database and\/or interface, Excel is an easy and quick way to gather and analyse data. Even though Excel is not a database in many organizations people store more data in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":289,"menu_order":23,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-328","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/328","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=328"}],"version-history":[{"count":0,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/328\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/289"}],"wp:attachment":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}