{"id":1517,"date":"2014-09-24T15:58:07","date_gmt":"2014-09-24T15:58:07","guid":{"rendered":"https:\/\/www.otiss.co.uk\/support\/?p=1517"},"modified":"2014-09-25T08:26:30","modified_gmt":"2014-09-25T08:26:30","slug":"excel-template-reports","status":"publish","type":"post","link":"https:\/\/www.otiss.co.uk\/support\/2014\/09\/excel-template-reports\/","title":{"rendered":"Excel Template Reports"},"content":{"rendered":"<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-1514\" src=\"https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2014\/09\/TreeSafety-excel-chart-4.png?resize=200%2C180&#038;ssl=1\" alt=\"TreeSafety excel chart 4\" width=\"200\" height=\"180\" \/>OTISS provides a powerful system to provide you with a range of Excel reports with data tables and summary charts.<\/p>\n<h4>Pre-defined reports<\/h4>\n<ul>\n<li>Select and download a pre-defined report: Complete, Basic or Raw data.<\/li>\n<li>Use Excel to adjust style and colours, remove un-wanted columns, etc.<\/li>\n<li>Use Excel to create charts from the summary tables.<\/li>\n<\/ul>\n<h4>Template driven reports<\/h4>\n<ul>\n<li>OTISS provides an Excel template with example tables for you to customise.<br \/>\n<h4><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-1501\" src=\"https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2014\/09\/TreeSafety-excel-1.png?resize=350%2C85&#038;ssl=1\" alt=\"TreeSafety excel 1\" width=\"350\" height=\"85\" srcset=\"https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2014\/09\/TreeSafety-excel-1.png?resize=300%2C73&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2014\/09\/TreeSafety-excel-1.png?w=583&amp;ssl=1 583w\" sizes=\"auto, (max-width: 350px) 100vw, 350px\" \/><\/h4>\n<\/li>\n<li>Use Excel to edit the template. Customise the fonts, colours, styles, column widths, border, formatting, etc. Re-arrange the columns and delete the ones you don\u2019t need.<\/li>\n<li>Add new columns and formulas to get exactly what you want.<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-1525\" src=\"https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2014\/09\/TreeSafety-excel-6.png?resize=350%2C43&#038;ssl=1\" alt=\"TreeSafety excel 6\" width=\"350\" height=\"43\" srcset=\"https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2014\/09\/TreeSafety-excel-6.png?resize=300%2C36&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2014\/09\/TreeSafety-excel-6.png?w=438&amp;ssl=1 438w\" sizes=\"auto, (max-width: 350px) 100vw, 350px\" \/><\/li>\n<li>Select the summary tables to provide some key statistics: e.g. condition, species, etc.<\/li>\n<li>Upload your prepared template to OTISS and the spreadsheet is immediately returned to you with the requested data.<\/li>\n<\/ul>\n<p>This feature is available on all survey modules \u2013 TreeSafety, BS5837, Estate Management, etc.<\/p>\n<p><a title=\"Excel Template reports\" href=\"https:\/\/www.otiss.co.uk\/support\/help\/excel-template-reports\/\">Read more&#8230;<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>OTISS provides a powerful system to provide you with a range of Excel reports with data tables and summary charts. Pre-defined reports Select and download a pre-defined report: Complete, Basic or Raw data. Use Excel to adjust style and colours, remove un-wanted columns, etc. Use Excel to create charts from the summary tables. Template driven [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[],"class_list":["post-1517","post","type-post","status-publish","format-standard","hentry","category-release","entry"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoYpC-ot","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/posts\/1517","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/comments?post=1517"}],"version-history":[{"count":10,"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/posts\/1517\/revisions"}],"predecessor-version":[{"id":1530,"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/posts\/1517\/revisions\/1530"}],"wp:attachment":[{"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/media?parent=1517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/categories?post=1517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/tags?post=1517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}