{"id":3630,"date":"2019-06-13T16:29:35","date_gmt":"2019-06-13T16:29:35","guid":{"rendered":"https:\/\/www.otiss.co.uk\/support\/?p=3630"},"modified":"2019-06-13T16:50:24","modified_gmt":"2019-06-13T16:50:24","slug":"excel-reports-bells-and-whistles","status":"publish","type":"post","link":"https:\/\/www.otiss.co.uk\/support\/2019\/06\/excel-reports-bells-and-whistles\/","title":{"rendered":"Excel Reports \u2013 bells and whistles"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"alignright is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2019\/06\/Reports-logo.png?resize=425%2C276&#038;ssl=1\" alt=\"\" class=\"wp-image-3615\" width=\"425\" height=\"276\" srcset=\"https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2019\/06\/Reports-logo.png?w=850&amp;ssl=1 850w, https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2019\/06\/Reports-logo.png?resize=300%2C195&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2019\/06\/Reports-logo.png?resize=768%2C499&amp;ssl=1 768w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">We have added some snazzy improvements to the Excel Reports.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>The Excel Reports now include your company logo (if you have set one up on your Account Settings page). <\/li><li>There are now a few extra fields that can be  inserted into the report  template: client name, site name, etc. These  are related to the client,  estate or site \u2013 rather than data about each  tree\/item.      <\/li><\/ul>\n\n\n\n<div style=\"height:104px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"244\" height=\"296\" src=\"https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2019\/06\/Reports-colours-2.png?resize=244%2C296&#038;ssl=1\" alt=\"\" class=\"wp-image-3624\"\/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>A really useful feature is to be able to colour the cell background  based on the cell\u2019s value. For example, the Condition, ISA TRAQ or QTRA  Rating or Timescale columns could be coloured red, orange, green, etc.   to highlight the risky trees or the ones in most urgent need of  attention.   <\/li><\/ul>\n\n\n\n<div style=\"height:217px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li> With the new feature where you can record the Multiple Species in a group, there are now two types of summary table (on which to create Excel Charts) \u2013 per-tree and per-inspection summary tables. Depending on the data and what you want to show, you select which is the most appropriate table to use.  In the example below you can see the difference between per-tree and per-inspection statistics \u2013 all the trees in the groups are included in the per-tree table.   <\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"919\" height=\"154\" src=\"https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2019\/06\/TreeSafety-excel-5.png?resize=919%2C154&#038;ssl=1\" alt=\"\" class=\"wp-image-3515\" srcset=\"https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2019\/06\/TreeSafety-excel-5.png?w=919&amp;ssl=1 919w, https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2019\/06\/TreeSafety-excel-5.png?resize=300%2C50&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.otiss.co.uk\/support\/wp-content\/uploads\/2019\/06\/TreeSafety-excel-5.png?resize=768%2C129&amp;ssl=1 768w\" sizes=\"auto, (max-width: 919px) 100vw, 919px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"> All these features have been added to the Excel Reports. And you can use the Excel Templates to tailor your reports and all these extra features:- data columns, charts, logo, cell colours, layout, etc. <a href=\"https:\/\/www.otiss.co.uk\/support\/help\/excel-template-reports\/\">Read More\u2026<\/a>  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have added some snazzy improvements to the Excel Reports. The Excel Reports now include your company logo (if you have set one up on your Account Settings page). There are now a few extra fields that can be inserted into the report template: client name, site name, etc. These are related to the client, [&hellip;]<\/p>\n","protected":false},"author":123457,"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-3630","post","type-post","status-publish","format-standard","hentry","category-release","entry"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoYpC-Wy","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/posts\/3630","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\/123457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/comments?post=3630"}],"version-history":[{"count":4,"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/posts\/3630\/revisions"}],"predecessor-version":[{"id":3635,"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/posts\/3630\/revisions\/3635"}],"wp:attachment":[{"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/media?parent=3630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/categories?post=3630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.otiss.co.uk\/support\/wp-json\/wp\/v2\/tags?post=3630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}