Clients use Excel to manipulate large amounts of data but when they need to produce more professional and accessible reports they prefer to use Word. However that is time consuming and open to creating errors.
For a number of clients we have automated this process. One client calculated that our system saved two hours a day in producing their daily flyer.
We built an Excel worksheet for Energy Quote from which they could generate a report in Word to send to their clients.
There are three buttons for the morning, midday and afternoon versions. The Excel sheet is populated directly from a live Reuters feed. As well as the current price there is a graph of one year’s price movements. The graph automatically resets the date to move on by one day, every day.
To create a new flyer all the user need to do is:
The Word template lays out the data in line with the detailed layouts prepared by their designers. The three alternative reports are differentiated by the banners at the top of the page and the afternoon version also allows Energy Quote to add their round up commentary on the day.
This is an example of the pdf created from the Word file created by clicking on Create Midday Report
