Requirements connected between BU and IT
Whoever deals with the management or business side of the company likes Excel; they have grown accustomed to using it and consider it an essential tool.
This love, however, is not always reciprocated by Information Technology departments who instead consider it to be an “uncontrollable” and unreliable tool from the point of view of security, data backup etc.
In some contexts, when a business oriented approach prevails, flow optimization is sacrificed to the advantage of total flexibility (i.e. every one organizes files more or less arbitrarily).
In other contexts, the exact opposite happens: the IT philosophy wins and the use of Excel is discouraged, often replaced by a less flexible and therefore more controllable ad hoc software.
In this second scenario, the IT department has to try to meet a series of incessant requests by the Business Units, the development time for the platform changes will inevitably slow down work, creating discomfort in both departments.
We suggest IT-Tidy as a solution to this problem: the structure of the Excel files is in fact determined by the file’s creator, but once the data is saved in the database thanks to IT-Tidy, it meets the requirements of IT departments.
The value of having updated information
Many companies, both large and small, use Excel a great deal. Our job was to observe the limits of this software and to extend its functionality.
How many times have you had to send an Excel document to a colleague or co-worker via e-mail only to realise shortly afterwards that there is some imperfection or correction to be made? Once the error is corrected we send a second mail, but what happens if the recipient has already started working on the first file?
This small example, if carried to a large scale, with large work groups, is without doubt the most obvious: when the recipients of my attached file become more than one, or even a different team, the workflow becomes more and more unmanageable.
These everyday problems have a solution in IT-Tidy: this Add-On for Excel is able to manage the data by saving it in a Database which is accessible to different chosen users. This software’s mission is to create a neat workflow that allows saving time and avoiding the chaos caused by sending duplicate Excel files via email or corporate intranet.