Reporting System
The reporting system for WinFeed 3.0 is implemented through Excel spreadsheets. Reports are based on pre-designed Excel templates, which, to some extent may be customised by the user. Custom reports may easily be provided if required. By using Excel, reports can be integrated into other MS Office documents, and additional calculations and text may then be added to the report.
Below is part of the feed report generated in Excel.
Report Designer
Report Designer command on the Menu bar. Five tabs are available in the designer window: for designing the Feed Reports, Feed Summary Reports, Ingredient Reports, Composition Reports and Composition Summary Reports. Any number of reports may be created in each of these five categories, the options being to include or exclude all of the sections or columns that are available for display. Reports may be created for different purposes – e.g. for different clients, to display excluded ingredients, or to display the matrix only.
In many cases it is possible to change the cell addresses where the different results are displayed in the Excel report, although blocks of data, such as the nutrient specifications in the feed report, will always remain grouped together, so although one can change the location of the block itself, it will ignore the locations given for any of the columns within the block. It is however possible to hide an entire section by un-checking the Include column for that section, or certain columns by un-checking the columns within a block.
The folder in which the template is saved must be entered for each Excel template created, e.g. C:\Program Files (x86)\EFG Software\WinFeed3\report templates\Feed Report template.xlt. Below is an example of a feed report template.
Feed Summary Reports
This report is available under Client Feeds when clicking on this icon . Using this report it is possible to generate a report showing either a single feed, or all feeds within the selected folder. It is recommended that the feeds be re-formulated before generating the report. If the button is clicked while a folder is selected, all feeds in that folder will be re-formulated. When the button is clicked, a new window comes up, which allows the order of the feeds to be set, and a template to be chosen from the available list.
Feed, Composition and Ingredients Reports
Some of these reports are accessed via the Menu bar, and others on the Button bar, in the relevant sections of the program, i.e. when on the Ingredients tab, the button for Ingredient Reports is visible. By pressing on this menu command a drop-down list of report templates is displayed (the default report if no others have been created). Clicking on the required report template will produce an Excel spreadsheet containing the required information.