Not more spreadsheets to analyse and chart\u2026<\/p>\n
Always a regular cry in the office.\u00a0 Reports produced on a regular basis need to be embellished, with charts that involve some fairly complicated calculations \u2013 cross-reference look-ups, previous month comparisons, and all that sort of thing.<\/p>\n
Probably, now this is done largely by hand.\u00a0 The data sits in several spreadsheets and\/or databases, and is extracted, filtered, pivoted and everything else that was necessary to get it ready, before feeding into a chart.\u00a0 When the chart was ready, it is pasted into the report.<\/p>\n
Wouldn\u2019t it be great with the data is all in one place, and with a single front-end, the necessary criteria set from drop-downs.\u00a0 Once these selections have been made (locations, benchmarks, which dataset to use, and so on)\u00a0you click a button and go and make coffee.\u00a0 Actually, you haven’t really got time to make coffee as the process takes just a couple of minutes \u2013 if that.<\/p>\n
In this instance, any number of queries can be run; sometimes one query, sometimes several to generate the data.\u00a0 Each one automatically loading a into an Excel workbook, in to the right columns, in the right order to aid presentation.\u00a0 Then, your screen explodes into a fresh multi-coloured set of charts based on the information just collated! And is that the pivot table I slave over every month appearing before my very eyes!<\/p>\n
In the past that has meant spending anything between a couple of hours to a couple of days for more complex reporting every period. Multiply that by twelve, and it becomes a not insignificant amount of time in a year m to get these twelve reports, graphs and charts prepared.<\/p>\n
Say it was half a day of someone’s time, at the average salary of \u00a326,000 – that’s a cost of around \u00a360+ to the business for each report, or chart.\u00a0 Each and every time.<\/p>\n
If reporting is weekly, that’s going to be more than \u00a33,000 every year – more likely a lot more than that.\u00a0 If it now takes 30 minutes to do the whole job, that’s a total of just over 4 days for the whole year’s worth (at one report a week).\u00a0 The four days will cost under \u00a3500.\u00a0 So you get to keep \u00a32,500 to do something else with.<\/p>\n
What would you like to do with it?<\/p>\n
Excel automation by Bob Lewis-Basson \u2013 07802 441 728<\/p>\n","protected":false},"excerpt":{"rendered":"
Not more spreadsheets to analyse and chart\u2026 Always a regular cry in the office.\u00a0 Reports produced on a regular basis need to be embellished, with charts that involve some fairly complicated calculations \u2013 cross-reference look-ups, previous month comparisons, and all that sort of thing. Probably, now this is done largely by hand.\u00a0 The data sits […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-160","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.iseberg.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.iseberg.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iseberg.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iseberg.co.uk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iseberg.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=160"}],"version-history":[{"count":1,"href":"https:\/\/www.iseberg.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/160\/revisions"}],"predecessor-version":[{"id":161,"href":"https:\/\/www.iseberg.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/160\/revisions\/161"}],"wp:attachment":[{"href":"https:\/\/www.iseberg.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iseberg.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iseberg.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}