1

Printing

11General

21.1Selections

31.2Modifying the layout

51.2.1Printer settings

61.3Name or description of the price lists on reports

71.4Manage print headers

111.5Layout of the column headers

111.6Layout of general data on printing

121.7Quantity of decimal numbers and sorting

131.8Separate thousands

141.9Exponential notation

161.10Return to the selection window

161.11Save layout printpreviews per user

161.12Report profiles

161.13Possibility to choose a printer for every report

172Important reports

172.1Formulae

172.1.1Print detail formula

312.1.2Report formula + label

352.1.3Report overview formulae

442.1.4Recent formulae

472.1.5Report overview formulae in columns

512.1.6Control list

542.1.7History, overview

722.1.8Detail history formulae

732.1.9History detail formula + label

733Available prints specifications

733.1Detail specification

773.2Detail nutrient in session

783.3History specificaties

783.3.1Overview

1 General

This chapter deals with the way in which a report can be made, especially the design of the layout, print profiles and the printer configuration. After all, this procedure is identical for all the reports. In a following chapter the different, available reports are discussed in more detail, more specifically which data can be printed.

1.1 Selections

In function of the type of report, a first screen allows to select the data that have to be printed. In the example below (overview formula, see 2.5) one can select the systems, the specifications and two alternative pricelists.

1.2 Modifying the layout

The screen of the modification of the layout shows :

· an option that allows entering a specific edition and to indicate if one wants to print a comment

· an option with the printer settings

· an option for the file creation (see chapter 3)

· different options concerning the report data

1.2.1 Printer settings

If “Default printer” is checked, the default printer (selected by Windows) will always be selected. If you want to choose another printer, click the button to select the desired printer.

Attention: if you do not check “Default printer”, this printer will be used by all the users who use this profile, which can cause problems if they do not have access to the printer. Here you have to choose between a Portrait or Landscape print (even if you have indicated that you want to use the default printer):

Since the overview that you get before printing you can copy and paste the image in a Word document, in a mail, etc.

1.3 Name or description of the price lists on reports

Menu: Tools ( Options ( category ‘Price lists’ (PL)

At the options a new category has been added, ‘Price lists’. Here one can indicate if the price list descriptions should be used on the reports instead of the price list names:

This option is especially interesting if Libra Go (optimisation for the external service) has been installed as well, because there the description is more commonly worked with than the name.

1.4 Manage print headers

Menu: Print ( manage print headers

One can now set different headers for oneself and subsequently indicate for every report which header one wants to use.

Description of the most important columns

Code: Code that selects the header. This code is shown in the choice lists of the headers.

Title: this text is shown in a large font in the header. Enter a space if you do not want a title.

Large title: if you check this, you get a slightly larger title.

Font: Choose here the font you want to use for the header.

Number of columns in header: indicates in how many columns the date from the header will be printed. If nothing is filled in, the default is 3.

Separation line: if checked, a full line is printed beneath the header

Layout: click here to select the data that you want to see in the header:

.

.

Use system data: if checked, the data (address, zip code …) of the system are used. In case of the report detail formula, this is the system of the formula in question. In case of the other reports the first visible system is used. Libra QC uses the date of the customer.

Address, zip code… if you do not use the data of the system, you can fill in these data here.

For logos you have to enter the complete path name of the file. Ensure yourself that the screen is rectangle. Possibly add blank space to the bitmap. The file format always has to be bitmap (bmp).

You can also enter a separate logo per system (Data ( Systems ( Modify):

One can set 2 logos as desired on the print headers:

Left logo:

· If the box “Use system data” is checked for the header in question, then the logo of the system is used here.

· If no logo has been set on the system, the left logo is used that was specified for this header.

· The system, of which the logo is used, is the system of the printed specification for the reports “Detail formula” and “Specification”. For the other reports the logo of the first system in session or that of the first visible system is used.

Right logo:

· On the report “Detail formula”, the logo of the species is printed on the right if this was checked in the configuration of the print profile and if a logo has been set for that species.

· In the other cases the right logo that has been specified in the print header comes here.

· If this was not filled in, the logo of Radar Automation comes here.

.

Printer settings

When modifying the layout of a report, at the bar “Printer setings”, one can set which header one wants to use.

Default header:

In the menu Tools ( Options, in the category PR (Printer settings), there are two new options in relation to printer headers. Under “default print header”, you can enter the code of the header that should be used on the prints where a header has not explicitly been selected. If neither on the report, nor in this option something has been filled in, the old header is used, as in release 10 and previous. With the option “Always print date and time at the top?” you make sure that date and time are always printed in the header. If not they will be placed at the bottom if page numbers are printed, and at the top in other cases.

1.5 Layout of the column headers

For every part of the report one can indicate how the column header should be shown: with or without border lines, with or without gray background, the number of lines of which the header should consist.

Example for the report “Raw materials ( Consumption and prices” (“modify layout” check):

1.6 Layout of general data on printing

There are a number of additional possibilities to arrange the data that are printed line by line on a report, as for example the general data on top of the report detail formula. When one clicks on the button “Configure data” for such a part of the report, there is a new column “Interspace”. With this you can insert empty fields. A negative value ensures that this field is concatenated with the previous field. With a value of -1 a space of 1 is inserted, with -2 2 spaces are inserted, etc.

Example of the report detail formula

Without interspace

With interspace

Configuration of the data on the report:

1.7 Quantity of decimal numbers and sorting

· It is possible to determine the quantity of numbers after the comma for each column. In some cases the entered value is ignored. This is the case for the analytical values that are printed with the quantity of numbers after the comma as determined with the nutrient concerned. (Might be different for every nutrient). This value is obviously also ignored for text fields.

· It is also possible to determine on which columns one arranges the report and in which direction (ascending or descending). One can also sort on the columns that are not printed.

Example for the report “raw materials ( consumption and price” (in the screen configure layout and in the part “Raw material data”):

In the configuration window of the report there is a bar/button for every existent data block. The data blocks that have not been selected for the print are “closed”. Click on the bar to open the data block underneath the bar. One now has access to all the available options.

1.8 Separate thousands

When configuring the layout, underneath the bar “Printer settings”, you can indicate that you want to separate the thousands. The division mark is always a space.

Attention:If this box is checked, some columns can become a bit wider. Make sure that the columns are set wide enough.

This option is also available in the label models under the bar default layout. It is not taken into account for the production of external files.

1.9 Exponential notation

With all the reports it is now possible to indicate that large values have to be printed in exponential notation. This is now possible by way of the modification of the layout, under the bar “Printer settings”. Give in the exponent from which it has to be changed over to the exponential notation. If you for example enter 5, the values are printed in exponential notation from 100 000. If you enter 0, the normal notation will always be used.

.

Result:

Notice that this setting is valid for all the values that are on the report. The values are shown with maximum 3 significant figures.

For labels this has to be set on the first tab page of the label model.

The exponential notation is not used in the text files that are ignored with the labels.

1.10 Return to the selection window

When one clicks “Cancel or “Escape” while modifying the layout of a report or at the preview, one returns to the selection window. This is to avoid that you have to select the data over and over again, which is useful when one is testing a print profile.

1.11 Save layout printpreviews per user

The way in which you want to see the report preview (larger, smaller, maximalised, etc.) is kept up per user per report. The most recently used layout of the report preview is applied again, also after closing and restarting Libra.

1.12 Report profiles

All of the parameterized elements can be registered in a profile. Click the button “Profiles” at the bottom left of the screen to save a profile. The profiles can subsequently be selected in the first selection screen which allows you to manage the different layouts from one and the same report.

For every edition there are predefined profiles that you can use.

Attention: if you click the button “Profiles” in the selection screen, you will manage the layout profiles of the small window and not of the report.

1.13 Possibility to choose a printer for every report

Tools ( Options ( category ‘Printer settings’

If one checks the option “Ask printer before every print-job?”, every time you print the question will pop up which printer should be used. Default (thus with this option unchecked) this is determined in the layout profile of the report.

2 Important reports2.1 Formulae2.1.1 Print detail formula

Menu : Print ( Formulae ( Detail

This print is available during an optimisation session and outside of a session. There are some small differences that are highlighted in the text.

( System selection (not mandatory) and the specifications that you want to print

( Optional: Nutrients to be calculated. If you do not indicate a nutrient, all the nutrients will be printed that have been selected in the formula. If you do not want to print any nutrients, you have to indicate this on the level of the layout (cf. further on)

( Price list: optional. Is only useful if you have indicated in the layout that the files concerning this price list should be printed.

( Print comment: only appears if you have specified it in your profile

( Layout profile

( Modify layout: if you want to modify the profile that you have indicated above or if you want to create a new profile.

( Extra printout using selected profiles: if you for example choose “Detail formula” as a profile for the layout, and you check “Production-order” and “Rounded formula” as additional profiles, you get three different reports for every formula at once.

If we now look at the layout window:

Options in the first part :

( First page only. To avoid a waste of paper, you can check this box. The formulae that can not fit on 1 page will be cut off after the first page, and the nutrients that are less important in general or a part of the raw materials will not appear

( Decompose semi-products? Whit this option Libra will replace the semi-products by their composition. If a semi-product on its turn contains a semi-product, it is decomposed as well, and thus one after the other( with a precision that corresponds to the number of decimals that are used for the percentages of the raw materials).

Important: this option can also influence the nutritional values (only for certain columns that are recalculated cf. further on)

If you have a semi-product that has not been taken in production for several months, and you do not decompose the formula, Libra will use the nutritional values of the semi-product that were in use during the last transfer in production. If you do decompose, Libra will use the current values (of the raw materials in the semi-product).

( Only if you have the module “complementary feed”:

· Print the external raw materials. If you check this, the complete formula will be printed, if not it is the complementary formula that you print. Make sure that the raw material columns and the nutrients that you choose correspond with this option.

· Group internal raw materials. If you check this (for a complementary formula), all the raw materials in the complementary formula will be regrouped on one line. The code, name, description etc. will be those of the complementary specification. This option is useful to adapt the complete formula, given the fact that it hides the composition of the complementary formula.

· If you check the two options mentioned above, you will get a report with one raw material that shows the complementary formula.

( Only if you have the module “Variants”: Apply the current variants in the formulae in production. If you do not check this, the production formula will be printed with the variants that are in use on the moment of the transfer in production. If you check, the variants that have been indicated in the specification will be used. If the production formula contains a raw material that is no longer selected in the specification, it is still the variant of the production formula that will be used.

Remark: outside of a session you can only print the formula that is in production on that moment, but during a session you also print the work formula. The work formula during a session is always printed with its own variants.

( Print title: this title will be shown at the top of the report with a larger font. For example “Production-order”.

( Print comment. This is the comment that you have entered in the first window. It will be shown under the bar “Details formulae”.

( Formula comment. This is the comment that you can enter on the level of the formula, during the session.

( Footer: this is a text zone that is saved with the layout profile that will be printed completely on the end of the report.

( Print derived specifications: if one checks this, a list of formulae that are derived from the formula while printing will be printed

Bar “Formula title”

When you click on “Configuration”, you will get the next window:

Optionally you can print a title (in slightly bolder letters), with the fields that you can choose here: code, name, description, administrative code and/or factory identification, sequence code. The factory identification equals the specification code but without the first positions that indicate a system.

Details of the formula:

The details of the formula are printed under the title. The possibilities are fairly extended (click “Configuration”). Attention: the order in which the fields appear might be different from the order that is shown here. You can change the order by moving the lines in the configuration window. Remember that the fields will be printed first from left to right and subsequently form high to low (if you want to use more than one column).

The letter symbols are sometimes fairly long, in order to clearly distinguish between the different fields. You can always enter a private, specific letter symbol.

1. Administrative code

2. Sequence code of the specification

3. Factory identification: specification code, without the first positions that indicate the system.

4. Contamination code (informative field about the specification). This code must be entered by way of the menu Specifications ( Modify. The possible values can be managed by way of the menu Specification ( contamination codes.

5. System code to which the formula belongs

6. System name

7. Data concerning the system address. Use this if you manage a system per customer, to show the data of the customer on the reports.

8. Version. Outside of the session it is the version number of the production formula.

During the session it is the number of the version of the work formula. If you have loaded a formula that is or has been in production, you will see the number of the veritable version. If you have loaded a formula that has never been in production, or you have just optimised a work formula, you will see “0” as version.

9. Optimal price: cost price of the optimal formula, according to the raw material prices with which the formula is optimised. The prices are saved on the level of the formula, if you have thus modified the price list that has been mentioned at 8, these modifications will not be taken into account.

10. Rounded price (optimisation): cost price of the rounded formula, according the raw material prices with which the formula has been optimised. The prices are the same as 9.

11. Rounded price production formula: cost prices of the production formula, calculated according to the rounded percentages and according to the prices of the raw materials with which the production formula has been optimised. The prices are not necessarily the same as 9 and 10. Outside of the session 11=10

12. Price list: number and name of the price list that you have selected in the window where you have selected the formulae to be printed. If you have not selected a price list there, the price list mentioned at 10 will be used.

13. Optimal price: the cost price of the optimal formula, calculated in accordance with the price list mentioned at 12. If you have not selected a price list, the price list of 8 will be used. Opposed to 9, one will use the price list as it is today, thus one has to take into account the modifications that were made since the optimisation.

14. Rounded price. As 13 but for the rounded formula.

15. Rounded price production formula. As 14 but for the production formula. Outside the session: 15=14

16. Price list market (per system): number and name of the pricelist that you have requested on the level of the system

17. Market price. The cost price of the optimal formula. Calculated according to the price list mentioned at 16.

18. Rounded market price. Like 17 but for the rounded formula.

19. Rounded market price production formula. Like 18 but for the production formula. Outside session 19=18.

20. Price list contract and real price list (per system): the same as for 17 and 21, but for the two other price lists that we can request on the level of a system.

21. Code, name and description of the specification.

22. If one has the module “Liquid formulation” one can also print the data that concerns the reference nutrient: code, name, description, and value

23. In the first window, where one can select the formulae to be printed, one can enter a second price list. One can make the code and name of this price list appear on the report.

Only if you have the module “Complementary feed”:

24. Price complete formula (optimisation): Like 9, but here the external raw materials are also included.

25. Price formula complete production (optimisation): Like 24 but for the production formula.

26. Price of the complete formula: Like 13 but taking into account the external raw materials.

27. Price of the complete production formula: Like 26 but for the production formula.

28. Margin complete formula

29. Margin (of the complement)

Only if you have the module “Wet feed”

30. Price on dry matter (optimisation): like 9 but divided by the percentage of the dry matter in the formula

31. Price on dry matter: like 13 but divided by the percentage of the dry matter in the formula.

32. Price on reference nutrient of the formula (optimisation): like 9 but divided by the percentage of the reference nutrient in the formula.

33. Price on reference nutrient of the formula: like 13 but divided by the percentage of the reference nutrient in the formula.

34. Price on the complete formula on

a. Reference nutrient

i. according to optimisation prices

ii. according to price list

iii. according to second price list

b. Equivalent of the dry matter (88 % MS)

i. according to optimisation prices

ii. according to price list

iii. according to second price list

35. Dry matter of the complete formula

36. Reference nutrient of the complete formula

37. Optimisation date

38. In production since: the date since the formula was in production

39. In production until: the date until the formula was in production

40. Marginal cost on the weight: marginal cost on the implicit pressure that states that the sum of the raw materials must be 100 %

41. Tonnage of the formula (only useful during the session)

42. Weight of the theoretic load

43. Weight of the real value

44. Matrix: name of the matrix used to optimise this formula.

45. Dry matter: percentage of the dry matter in a wet food (only if you have the module)

46. Uptake of the premix in the nutrient: only if you have the module “Premix”.

47. Code, name and description of the basic specification (only if you have the module “derived formulae”)

48. Only if you have the module “Traceability”

i. Send date in production (might be different from date 38)

ii. Created by: user that creates the formula

iii. Transferred in production by: user that has transferred formula in production

Configuration des matières premières :

‘Si pas de variante, appliquer la matière première de base’ : Avec cette nouvelle option cochée, le résultat final de l’édition utilise les données (code, code administratif, nom et description) de la matière première pour remplir les colonnes concernant les variantes, pour les matières premières qui n’ont pas de variante.

MP externe :

Pour une édition avec les matières premières internes regroupées, on trouvera les prix sur la ligne de regroupement. Si les matières premières externes sont imprimées, les contributions aux prix sont au niveau de la formule complète. Par exemple, avec le profil FR$Complémenté :

Valeurs nutriments :

On peut faire un choix de 6 nutriments que apparaîtront pour chaque matière première. La valeur totale de ces nutriments (en bas, sur la ligne avec les totaux) est uniquement disponible pour les nutriments sélectionnés dans la formule.

Vous avez le choix entre les colonnes suivantes.

1. Code matière première

2. Nom

3. Description

4. Code administratif

Only if you have the module “Variants”:

49. Variant: a “V” will be printed for the raw materials that have a variant

50. Code, name, description and administrative code of the variant

51. Percentage

52. Rounded percentage

53. Weight: percentage (57) multiplied by the weight of the real load

54. Cumulated weight: sum of the weight of this raw material and all the previous raw materials.

55. Minimum and maximum: constraints

56. Rounded percentage formula in production. Outside the session this column equals column 60.

57. Difference with the formula in production = 58 - 62

Only if you have the module “complementary feed”:

58. Percentage in the complete formula: contains the external raw materials

59. Percentage in the complete formula in production: contains the external raw materials

60. Minimum and maximum on the level in the complement: constraints (61) expressed on the complement. If these constraints are already on the complement 66 = 61

61. Constraints on the complement: a “C” will be printed if the constraints (61) are on the level of the complement (if not they are on the complete formula).

62. External raw material: an “E” will be printed for the external raw materials/

Only if you have the module “Wet feed”

63. Percentage on dry matter = 59/47

64. Percentage on reference nutrient

65. Type of constraint: basic for the constraints (61): complete matter, dry matter or reference nutrient

66. Three new columns with different price types of raw materials: on dry matter, equivalent of the dry matter (88% MS) and on the complete matter. It is different for the normal prices, considering that they sometimes apply on the fresh products, sometimes on the dry matter (shown in cursive)

Only if you have two modules: “Complementary feed” and “wet feed”=

1. Percentage on dry matter in the complete formula = 64 / 75

2. Percentage on reference nutrient in the complete formula.

Now all types of contributions to prices are available in percentage and in absolute value (€).

67. Price (optimisation): the price with which the formula is optimised. The weighed average of this column gives the cost price 11, discussed in the part “Details formula”.

68. Contribution to price (optimisation): the contribution of the raw material to the cost price 12 of the rounded formula

69. Price (optimisation) of the formula in production: it is the price with which the production formula is optimised. The weighed average of this column gives the cost price 13, discussed in the part “details formula”

70. Price: it is the price of the price list (14) that you have selected in the selection window. If you have not selected a price list, the price of the list (10) is used to optimise the formula. If this list has not been modified since than 78 = 75

71. Contribution to price: shows the contribution of the raw material to the cost price 18

72. Market price: the price according to the list (16) for the market prices that you can select per system

73. Contribution to the market price: shows the contribution of the raw material to the cost price 18.

74. Contract price and real prices and their contribution to the cost price: like 77 and 78

75. Marginal cost: the marginal cost decreased by the constraint

76. Inferior and superior price: prices between which the optimal solution stays valid.

77. Sequence code

78. Indicator “group”. This indicator serves to sort, to place groups at the end. If one does not indicate a sorting, the groups will be placed in any case.

79. Number and description of the weigher (also see below)

80. Weight cumulated by the weigher

81. Line number. It is a simple counter that starts at 1 and increases with 1 for every raw material

82. Price according to the second price list, and contribution to this price. For this work formula and for the production formula.

Configuration of the nutrients

You have the choice between the following columns:

83. Nutrient code

84. Name

85. Description

86. Value

87. Rounded percentage

88. Minimum and maximum: constraints

89. Rounded percentage production formula: outside a session this column corresponds to column 90

90. Marginal cost: it is the marginal cost decreased with the constraint

91. Inferior and superior border: borders for the constraints between which the marginal cost stays valid

92. Sequence code

93. Indicator “Proportion” (to implement sortings)

Only if you have the module “Complementary feed”:

94. Value in the complete formula: contains the external raw materials

95. Value in the complete production formula: contains the external raw materials

96. Minimum and maximum on the level of the complement: constraints (91) expressed on the complement

97. Constraints on the complement: a “C” will be printed if the constraints (91) on the level of the complement (if not they are on the complete formula).

Only if you have the formula “Wet feed”:

98. Value on dry matter= 97/47

99. Value on reference nutrient

100. Type constraint: base for the constraints (91): complete matter, dry matter, equivalent dry matter and reference nutrient.

Only if you have the two modules “Complementary feed” and “wet feed”:

100. Value on dry matter in the complete formula = 66/47

101. Value on reference nutrient in the complete formula.

There is a column “Value on label” available to show the value of the label that has been entered on the level of the specification or of the formula in session. This value is not necessarily the one that appears on the label if a correction has been set on the level of the version of the label.

Possibility to regroup the raw materials per weigher

First the weighers have to be defined. This is possible by way of the menu Data ( Systems ( Manage Weighers. Press F6 to add a registration of Shift-F6 to remove one. You can also use the menu “Weighers” or click right on the header of the line.

.

A good weigher is always associated to a specific system. For an entered system, the number of the weigher needs to be unique. Pay attention before you associate numbers of weighers: the sorting of the weighers is always done by way of their number.

Subsequently you must indicate the weigher to be used for each raw material of an entered system. You can do this by way of the menu Data ( Systems ( Modify, in the pane with the raw materials. Use the button “Profiles” if you do not see the columns with the number and description of the weighers.

Finally you have to check “Group by weigher” in the configuration layout of detail formula. Example of a possible outcome (also notice the numbers of the lines and the cumulated weight per weigher):

If you choose “Group by weigher”, the description of every weigher will be printed in the column of the descriptions of the raw materials (or in the column with the names if you have not printed the descriptions).

The numbers of the weighers will be printed in the column with the codes of the raw materials, or the column with the article numbers or the sequence codes. If none of these columns is printed, the numbers of the weighers will also not be printed

.

Supplementary batch weights

You have the possibility to create parameters for up to 5 different supplementary batch weights. For this purpose you have to go to the configuration page. There is a zone available for entering the supplementary batch weights in the general pane.

The columns are added per batch weight for the columns weight, cumulated weight, and cumulated weight per weigher.

.

Result:

In the configuration of the formula layout, there is an option to print total line.

Result :

2.1.2 Report formula + label

This report allows to print a formula and a label on the same page. A layout for the formula already has to be prepared.

If one makes this report during an optimisation session, the printed formula will be the work formula, but the label is always the one that is in production on that moment. It is not possible to print a label that is not yet validated.

If there are different label versions for a certain formula, the version that you have checked “default” in the management of the versions will be the one that will be printed. If this version exists in different languages, it is the “default” language that will be printed. If you want to print another version than the default one, you have to indicate this in the options: menu Tools ( Options, category “Libra LB”. Uncheck the parameter “Print default version”, and indicate the desired version on the level “Print the specified label version”. This version will be used for all the specifications.

To obtain this report, go to the menu Print ( Formulae( Formula + label. In the layout one can choose a different report profile, which determines the layout of the formula.

On the other hand there are options to modify the positions, orientations and measures of the panes formula and label. When you check the option “Zoom the formula according to the available print area”, the formula part will become smaller. This option is useful for when the layout profile shows a lot of columns for the formula. If one does not zoom and the formula is too large, one has to adapt the profile itself to make it wider (Print ( Formulae ( Detail and choose the profile concerned). Subsequently one can modify the profile if one has checked the option “modify layout”. Default the option is checked to obtain the same behaviour as before. If unchecked, one obtains the more natural procedures.

To print the label of a formula, LIBRA always takes the version and the default label language. One can change the language and default version in Labels ( Version ( Modify/Create

An example of the report “Formula + label” without automatic zoom. Now the formula appears without modification. Nevertheless one sometimes has to modify the formula profile to get a nice report.

2.1.3 Report overview formulae

This report is available in the session (menu: formulae ( overview) or outside the session (menu: Print ( Formulae ( Overview).

2.1.3.1 Selection screen

During a session the alternative price list used in the session will be placed automatically on the list that was chosen here.

One can insert a short comment that will be printed as indicated in the profile. This comment is not saved in the profile.

Reference system: if you regroup the formulae per factory number, you will be able to print a column with the difference between the cost price of a formula and the cost price of the formula that has the same factory number on the reference system. Further on you will find a concrete example.

You can choose a profile for the layout of the report. This profile will determine which ciolumns will be printed and in which order. We have foreseen the following predefined profiles: “EN$Overview” and “EN$Comparison”. The first corresponds to the Libra report “Formulae, global”. The second more or less corresponds to the report “Formulae, work <-> production” of Libra 4. If you want to modify the chosen profile or you want a completely new profile, check the corresponding box. You consequently end up in the window where you can modify the layout.

2.1.3.2 Wijziging van de opmaak van de afdruk

Grouping by factory identification: the factory identification is the code of the specification, but without the part with the number of the system. If you check this the formulae will be sorted according to their factory identification an you will obtain an average per factory identification.

It is especially useful if you produce the same product in different factories, and if the same product has the same factory identification in all the factories.

Price type for differences: you can have 6 different prices shown on this report: the optimisation price (outside the session this price is replaced by a price in agreement with a pricelist as desired), the first and second alternative price (his are 2 price lists that can be entered) en subsequently the market price, the contract price and the real price. These last three price lists are entered per system (Files ( Systems ( Modify). Certain columns allow you to see the differences in price, but these columns are not available for all of these prices at the same time. You have to choose which type of price you want to use to calculate the differences.

Real production: with the module “History real productions”, it is possible to print the real production of the formulae. For example, a report ‘Overview formula’ with the column ‘Real production’:

Other new columns with this subject:

· The average prices weighed according to the real productions

· The production period in the header

2.1.3.2.1 Session data

2.1.3.2.2 Data formula

If the list does not fit on one page in the horizontal way, it will be continued on the second page. To be able to repeat the specifications on the second page, it is recommended to repeat the columns with the specification identification. In the predefined profiles we have chosen to place the code and description of the specification and to repeat these 2 columns on every page (= number of fixed columns).

You can choose the following columns:

Some explanation about certain columns:

· factory identification: specification code without the part “system”.

· Production date: date since when the formula is in production. None if the formula has never been in production (which is usually the case, except when one has loaded an old formula). Don’t confuse with the column “Formula in prod.: in production since”, which refers to the production formula.

· Optimal formula price= cost price of the optimal formula according to the prices with which it is optimised.

· Alternative optimal formula price: cost price of the optimal formula according to the alternative price list.

· Rounded formula price in prod. = cost price of the rounded production formula, calculated in accordance with the selected price list in the session.

· Diff. price, price production formula= difference between the price of the optimal formula and the rounded production formula.

· Diff. % price, price production formula = idem the previous but expressed in percentage of the production formula price.

· One also still has the same for the amounts in accordance with the optimal production formula and for the prices in accordance with the alternative pricelist.

· Amount rounded formula price in accordance with the market price list: it is the cost price mentioned above, multiplied by the tonnage of the formula.

· Price production formula in accordance with the market price list. It is the cost price of the rounded production formula, calculated with the market price list that you can find on the level of the system.

· Amount production formula in accordance with the market price list. It is the cost price mentioned above, multiplied by the tonnage of the formula.

· The four columns above are equally disposable in accordance with the contract price list and the real price list; the other price list can be entered on the level of a system.

· Difference in accordance with the selected price type: rounded – average. In the example we have selected the market prices to calculate the differences. In this column we will thus see the difference between

· The cost price of the rounded work formula, calculated in accordance with the market price list

· And the weighed minimum of these cost prices, for all the work formulae with the same factory identification

· Difference in accordance with the selected price type: rounded – reference. In the example we have selected market prices to calculate the differences. In this column, we will thus see the difference between

· The cost price of the rounded work formula, calculated in accordance with the market price list

· And the cost price of the rounded work formula that has the same factory identification but for the reference system.

For a formula of the reference system, this difference will always be 0.

Result with the profile EN$Overview:

Result with the profile EN$Comparison:

2.1.4 Recent formulae

Menu (in or outside session): Print ( Formulae ( overview recent versions

Libra saves a short term memory of usually 5 formulae per specification. Except this, there is also a long term history that is available by way of the reports in Print ( Formulae ( History.

In the short term history you can find 4 different formula types:

· The production formula. This formula has a version number, a starting date and an end date.

· The old production formula. It has a version number, a starting date and an end date.

· A formula that has not yet been transferred in production. It is a formula that one has saved by way of the menu File ( Save data ( formulae. It neither has a version, nor a starting date or end date/

In the selection window of this report one can choose which data one wants to print (specifications, raw materials, nutrients, …).

In the print profile,one can among other things parameterize the following matters:

· New page per specification. With this unchecked, the formulae of all the specifications will subsequently be shown in one panel. In this case you have to pay attention that at least the code or description of the specifications is registered in the header of the columns, if not one will not be able to distinguish the different specification.

· Number of versions per page. If it is 0, Libra will place as many as possible versions on one page, depending on the width of the paper. In each column one will foresee the place for every raw material that appears in at least one column, even if it is on the next page.

· Print work version. Check this if you also want to print the work version. This option is only available in a session.

· Number of saved versions / versions in production / planned versions. For every one of these formula types one can indicate how many versions at least have to be printed. If one for example puts the number of the saved versions on 3 and the number of the production versions on 1, one will always obtain the production version plus the 2 most recent versions next to the one in production. These two versions could have been in production or not.

· Under the “Session data” one can, by way of the button “Configure”, choose a couple of data to be printed in the header. Outside the session it is only about the data of the specification (code, description, …). These data are only printed if the box “New page per specification” is checked (if not one can have several specifications per page). In a session one can also print the number and name of the session, the price list of the session, the tonnage list, and so on.

· Under the bar “Print header”, one can indicate data that have to appear in the headers of the columns (version number, starting- and end date, optimisation date, price, price of the complete feed and the data about the specification such as the code, description,…).

· The price that is printed is the cost price of the rounded formula, calculated in accordance with the prices with which the formula is optimised (thus without taking into account possible modifications on the pricelist since then).

· The price of the complete food (only for the formulae with external raw materials) is calculated in accordance with the optimisation prices. It is expressed on the fresh weight, the reference nutrient, the dry matter, or on the equivalent of the dry matter. These two last possibilities only apply themselves on the wet feed. The choice between these 4 possibilities is done by way of the following option in the category “SE”, that also applies for the complete food shown in the screen “Detail formula”:

· Under the bar “Raw materials and nutrients” one can modify some options concerning the list of raw materials and nutrients:

· RAW MATERIALS: here you can modify the header of the raw material list

· Print raw materials: indicate here if you want to print the raw material list

· Print zero percentages: if you uncheck only the raw materials with a percentage larger than 0 will be printed. The percentage that is used for this decision (optimal, rounded, complementary or complete) depends on the columns that you print.

· If not a variant, apply basic raw material: if you check and a certain raw material does not have a variant, one will print the data (code, description …) of the base raw material in the columns that concern the variant. If not the fields remain empty.

· Group productions groups: check if you want to add raw materials of a feed group on a single line. For more explanation about the feed groups, see the user instruction about the basic data, paragraph 4.

· GROUPS: here you can modify the header of the raw material list

· Print groups: check if you want to print the raw material group list (on condition that you have selected groups in the selection window).

· NUTRIENTS: here you can modify the header of the nutrient list

· Print nutrients: check if you want to print the nutrient list.

· Sort nutrients using: here you can indicate how you want to sort the nutrient list. The configuration of the columns (see further) is valid for the raw materials, groups and nutrients at the same time, but the sorting is only applied to the raw materials and the groups.

· Replace nutrients by selected nutrients (else they will be added): if you have not selected any nutrient in the selection window, an automatic selection is set up that consists of all the nutrients selected in at least one of the printed formulae. If you have selected at least one nutrient, only the selected nutrients will be printed, except when you uncheck this option. In that case the selected nutrients will be added to the automatic selection.

· Sort versions using: here you can indicate the order of the columns. They are sorted in the first place by the specification (same sorting as in the choice list). Afterwards one can sort them (ascending or descending) by way of the version number, the production or optimisation date. Notice that the version number of which one talks is the internal version number, than one does not see on the screen. This version number is also associated to the internal formulae that have never been in production. The result is that one obtains formulae in the sorting in which they were saved.

· Eventually one can use the button “Configure” to indicate the columns that should be printed

· Code, description, name, administrative code and sequence code : the basic data of the raw materials and the nutrients. Considering that the nutrients do not have an administrative code, it is their code that will be printed instead.

· Unity (code and description)

The following columns are resumed for every formula:

· Rounded value: the percentage (or the nutritional value) in the rounded formula

· Rounded value, current matrix: the nutritional values are calculated according to the current matrix.

· Rounded value (complete) (only for complementary formulae): the reconstructed percentage (or the nutritional value) in the complete food.

· Value on dry matter (complete) (only for the module wet feed): the percentage (or nutritional value) expressed on the dry matter.

· Value on the reference nutrient (complete) (only for the module wet feed): the percentage (or the nutritional value) expressed on the reference nutrient.

· Minimum, maximum, optimisation price, external raw materials, constraint on the complement (only module complementary feed), type of constraint (only module wet feed): data with which the formula is optimised.

· Marginal cost, minimal price, maximal price: results of the optimisation

· Variant indicator: indicate if one has used a variant for this raw material.

· Code, description, name, administrative code of the variant: data on the used variant.

.

Example :

2.1.5 Report overview formulae in columns

This is a print during an optimisation session. One sees a column per formula and a line per raw material or per nutrient. One can print some data per raw material (description, total consumption …) and some data per formula (optimal value, marginal cost, …)

At “Specification header” one can indicate which data one wants to have in the heading of every column.

“Raw material data”:

One can indicate which data have to appear on every line in the raw material section. (Uncheck “Print” if you do not want to print the raw materials). From “Optimal percentage work formula” the data in question return in every column. The column “Variant” shows a “V” if the raw material has a variant in the concerning formula.

In the section “Nutrient data”, one can indicate which data have to come on every line (uncheck “Print” if you want to print the nutrients). From “Optimal value work formula”, the data in question return in every column.

The pane with the ingredients. Notice that it is always about ingredients that are shown on the label in production on that moment.

The eventual result could be as follows:

2.1.6 Control list

Menu : Print ( Formulae( Control list

This report allows controlling which production formulae do not suffice to the constraints in the specifications, as a consequence of modifications of the matrix values, as a consequence of modifications to the constraints, as a consequence of variant replacements, or as a consequence of modifications to the programs. The obtained formula list can be saved in a preselection in order to easily start an optimisation session.

You can admit a certain deviation in relation to the current constraint. This deviation can possibly be entered separately for every nutrient, either in absolute value or in the percentage of the actual constraint. Menu Data ( Nutrients ( Modify:

These two fields can equally be modified by way of the parallel modification (press Ctrl – F2 to modify the profile and visualize the corresponding columns).

Selection screen:

You can enter the following information:

· Selection of the systems to be controlled and specifications

· Maximal deviation (in %) for the first nutrient list

· First nutrient list. These nutrients will all be controlled in relation to the above deviation.

· Second nutrient list. These nutrients will be controlled in relation to the own maximal deviation (entered by way of Data ( Nutrients ( Modify)

· Control on constraints? If not in relation to optimal values? If you check this, the maximal deviation will be applied to the deviations in the specifications (taking into account the possible programs). By entering a maximal deviation larger than 0, you can allow the constraints to be slightly crossed.

If you do not check this, the control will be implemented in relation to the optimal values. These are the values of the optimal formula (not rounded) during the transfer in production. In this case you can only control the nutrients that are selected in the formula.

· Control on the basis of current variants? If not on the basis of variants in the formula. If you check this the current variants are calculated using the indicated variants in the specifications. If not one uses the variants from the moment of the transfer in production.

· Optionally you can indicate a preselection (new or existent) in which one registers the formulae that do not suffice to the constraints. If it is an existing preselection, you can check that the preselection has to be emptied first. If not specifications will be added.

· Eventually you can enter a comment, choose the print profile and possibly indicate that you want to modify the layout.

· With the button “Profiles’ below, you can register the profiles for this screen. In this profile one also registers the values of the boxes to be checked and the value of the maximal deviation. In this way one can modify the initially proposed values.

In the print profiles you can enter the print title, indicate if you want to print a print comment and indicate if you want to print a selection that you have made (controlled in relation to the specifications or the optimal values.

You have the choice between the following columns:

· Code, description, name, administrative code, sequence code of the specification

· Code, description, name, sequence code, unit, unit name

· Program. If the minimal/maximal constraint (cf. see further) is a program constraint, a “C” will appear in this column. If not the column will stay empty.

· Minimal value. Or it is the minimum of the specification reduced with the maximal deviation, or it is the optimal value reduced by the maximal deviation (according to the choice you have made). This column is only requested if the current value is smaller than this minimum. For the given line, either the minimal value is filled in or the maximal value, but never the two.

· Minimal constraint. This is the current constraint of the specification, taking into account the possible programs but not the admitted deviation. If you have requested a control in relation to the optimal values, the minimal deviation is printed if the current value is smaller than the optimal value reduced with the deviation, even if the minimal constraint is not crossed. If the minimal deviation is a program constraint, a “C” appears in the corresponding column.

· Optimal value. It is the value in the optimal formula during the transfer in production.

· Current value. It is the value of the rounded production formula, calculated with the current matrix, either with the variants of the current specification, or with the variants on the moment of the transfer in production (depending on your choice).

· Maximal value. As for the minimal value.

· Maximal constraint. As for the minimal constraint.

· Deviation. It is the current value reduced with the minimal or maximal value (depending on the case).

· Maximal deviation. It is the maximal deviation that you have allowed for this nutrient, in absolute value.

· Deviation in percentage

· Maximal deviation in percentage

.

Example of a report with the profile “EN$Controllist”:

2.1.7 History, overview

Menu : Print ( Formulae ( History, overview

.

Raw materials groups that have to be taken into account:

When modifying the layout, an option allows indicating if one has to print the groups of the raw materials and the title of the part:

Attention :One always uses the current definition of the groups. Considering the fact that a deactivated raw material is removed from all groups, the values of the deactivated raw materials are not taken into account in the calculation of the values of the groups!

Selection of the nutrients:

When one does not select any nutrient in the selection screen, Libra will automatically select it in the following way. If one prints values in the formula, LIBRA will select the values that are used during the optimisation of the formula. If one prints the column with the label value, Libra will select the nutrient that appears on the label.

The user can automatically modify this selection by making his own nutrient selection in the selection screen. Moreover one can indicate if these nutrients have to be added to the automatic selection, or should replace it. For this purpose one has to use the option “Replace the selected nutrients in the automatic selection (if not they are added)” in the layout screen.

Par exemple par une version 67 d’une formule :

Ingredients:

Now, in function of the options of the label model, the ingredients with the percentages above the presentation threshold, will be shown by an asterisk * on the reports.

One can change these options in Labels ( models ( modify:

Graphs of the nutrients and prices:

In the report ‘Formulae’ ( History, overview’ now there is a possibility to show the graphs of the evolution of the prices and the nutrients of a formula. In the selection screen one can enter the nutrients that one wants to see on the graph.

Subsequently, in the layout, there are options to configure the graphs. One can determine the size of the graph and set the width and height in the percentage of the page.

For nutrients you can choose if you want a graph per nutrient (box checked) or all the nutrients in one graph (box unchecked):

Click the button “Configure” in the layout, to obtain the configuration options of the graph:

Sort nutrients by: allows sorting the nutrients in another way than the raw materials. The possible sorting criteria are the code, the name, the description and the sequence code.

Group nutrient categories: this option in the layout of the prints makes it possible to group the nutrients per category:

One can create or modify categories in the menu Labels ( Nutrient categories ( Modify/create.

Value of the production formula if there is no label value.

The part programs allows showing the history of the programs for the selected specifications.

Examples:

Example report raw material groups:

Example: the report ‘Formulae ( History’, overview with a profile that selects the header, the price graph and the graph of the selected nutrients:

Result with the profile EN$History and 5 versions per page:

Leernsesteenweg 128D - B-9800 Deinze

Spécification

10001

POUSSIN DEMARRAGE 0 A

2 SEMAIN

Liste de prix

Matrice optimisation

1 Libra

Version6059585756

En prod.26/04/200709/03/200709/03/200709/03/200609/03/2006

Tonnage

Prix

CodeDescription

MATIERES PREMIERES

1200000Carbonate farine 0.1850.1850.2000.200

1300000Sel 0.2800.2800.2800.2800.280

2200000Lysine HCl pur 0.3000.3950.3950.4000.400

2300000DL Methionine pur 0.3500.3050.3050.3000.300

3000400Prémix poule 0.5% 0.5000.5000.5000.5000.500

9300050Amprolium+ 0.5000.5000.5000.5000.500

10000030Avoine 5.0005.0005.0015.001

10300020Maïs, jaune, France 10.00010.00110.00110.00210.002

10300120Maïs, jaune USA 30.00025.00325.00325.00525.005

31010040Tourteau de soja, solvant Brazil 45.4 7.050

40000010Pois Canada 40.57046.05546.05546.05946.059

41000040graines de colza - tanné 0.800

41200010Graines de tournesol - décortiqué 2.500

51000010Graisses (+) : Graisses mélangés 0.0750.0750.0500.050

70002120CPC C50/11.3 7.1506.7016.7016.7016.701

86100010Gluten de mais 60.8 5.0005.0005.0015.001

NUTRIMENTS

1101Humidité 11.719611.916111.916111.942311.9423

1102Cellulose brute 3.9024.1604.1604.1614.161

1103Cendres brutes 5.1895.0545.0545.0695.069

1104Proteine brute 20.01619.99919.99920.00320.003

1105Matieres grasses 4.5493.1273.1273.1023.102

1115Amidon 43.86045.66145.66145.66645.666

1116Sucres 2.352

1117Sucres + Amidon 46.55948.01048.01048.01548.015

1301Phosphore 0.7210.6720.6720.6720.672

1302Calcium 1.0511.0481.0481.0541.054

1303Sodium 0.1670.1650.1650.1650.165

1501C18:3 Acide linoléique 1.8551.0891.0891.0871.087

2101EM Volaille 2949.92950.42950.42948.72948.7

2131EM pondeuses 3000.82983.22983.22981.22981.2

3101P disponible Volail 0.4800.4550.4550.4550.455

4102Methionine digestible volail 0.5760.5640.5640.5590.559

4103Met + Cyst. dig volail 0.7870.7820.7820.7770.777

4104Lysine dig. volail 1.1351.1211.1211.1251.125

4105Threonine digestible volail 0.5990.6190.6190.6200.620

4106Tryptophane digestible volail 0.1540.1320.1320.1320.132

5101EQ xantho jaune 7.27916.87916.87916.88116.881

10100Methionine 0.6070.5960.5960.5910.591

10105Lysine 1.3221.2951.2951.2991.299

90001Ca/P total 1.4581.5611.5611.5691.569

Historique formules

Libra 5.2 / 11.11

RADAR Automation S.A.

Demo

Result with the profile EN$History without limitation of the number of versions per page: there are rules where all the values are zero, which is not the case with the option.

Leernsesteenweg 128D - B-9800 Deinze

Spécification

10001

POUSSIN DEMARRAGE 0 A

2 SEMAIN

Liste de prix

Matrice optimisation

1 Libra

Version6059585756

En prod.26/04/200709/03/200709/03/200709/03/200609/03/2006

Tonnage

Prix

CodeDescription

MATIERES PREMIERES

1200000Carbonate farine 0.1850.1850.2000.200

1300000Sel 0.2800.2800.2800.2800.280

2200000Lysine HCl pur 0.3000.3950.3950.4000.400

2300000DL Methionine pur 0.3500.3050.3050.3000.300

3000400Prémix poule 0.5% 0.5000.5000.5000.5000.500

9300050Amprolium+ 0.5000.5000.5000.5000.500

10000030Avoine 5.0005.0005.0015.001

10100020Blé 56 amidon aliment granulé

10300020Maïs, jaune, France 10.00010.00110.00110.00210.002

10300120Maïs, jaune USA 30.00025.00325.00325.00525.005

30000010Tourteau de colza, solvant 32.5/12

31010040Tourteau de soja, solvant Brazil 45.4 7.050

40000010Pois Canada 40.57046.05546.05546.05946.059

41000040graines de colza - tanné 0.800

41200010Graines de tournesol - décortiqué 2.500

51000010Graisses (+) : Graisses mélangés 0.0750.0750.0500.050

70002120CPC C50/11.3 7.1506.7016.7016.7016.701

86100010Gluten de mais 60.8 5.0005.0005.0015.001

NUTRIMENTS

1101Humidité 11.719611.916111.916111.942311.9423

1102Cellulose brute 3.9024.1604.1604.1614.161

1103Cendres brutes 5.1895.0545.0545.0695.069

1104Proteine brute 20.01619.99919.99920.00320.003

1105Matieres grasses 4.5493.1273.1273.1023.102

1115Amidon 43.86045.66145.66145.66645.666

1116Sucres 2.352

1117Sucres + Amidon 46.55948.01048.01048.01548.015

1301Phosphore 0.7210.6720.6720.6720.672

1302Calcium 1.0511.0481.0481.0541.054

1303Sodium 0.1670.1650.1650.1650.165

1501C18:3 Acide linoléique 1.8551.0891.0891.0871.087

2101EM Volaille 2949.92950.42950.42948.72948.7

2131EM pondeuses 3000.82983.22983.22981.22981.2

3101P disponible Volail 0.4800.4550.4550.4550.455

4102Methionine digestible volail 0.5760.5640.5640.5590.559

4103Met + Cyst. dig volail 0.7870.7820.7820.7770.777

4104Lysine dig. volail 1.1351.1211.1211.1251.125

4105Threonine digestible volail 0.5990.6190.6190.6200.620

4106Tryptophane digestible volail 0.1540.1320.1320.1320.132

5101EQ xantho jaune 7.27916.87916.87916.88116.881

10100Methionine 0.6070.5960.5960.5910.591

10105Lysine 1.3221.2951.2951.2991.299

90001Ca/P total 1.4581.5611.5611.5691.569

95000Blé/céréales 0.0000.0000.0000.0000.000

Libra 5.2 / 11.11

RADAR Automation S.A.

Demo

Historique formules

Result with the profile EN$Variants. This profile shows the history of the programs.

2.1.8 Detail history formulae

Print ( Formulae ( History, detail

It is important to notice that this report can not be confused with ‘detail formula’ (Formulae ( detail). First of all you can not find all the fields that are present at ‘Detail formula’ (for example batchweight, certain prices, certain contributions, etc.). In the second place the tonnages that one uses are not the same. In case of detail formula one uses the tonnages of a tonnage list. In ‘History, detail’, one uses the real tonnages.

Attention : the used constraints on the history reports are the current constraints !

2.1.9 History detail formula + label

Menu: Print ( Formulae ( history, detail + label

Detailed information of every selected version and moreover the labels when they are available

In the layout one can choose a profile for the part detail formula.

3 Available prints specifications

3.1 Detail specification

Print ( Specifications ( Detail

With this report you can get a detailed report with the data of one or more specifications. The following options are available to configure the print in the layout page (the gray bars represent parts with specific options that one makes visible and modifiable by clicking the bars):

With the print ‘Detail formula’ one can generate different rapports of for example all the programs applied on a specification or of the derived specifications of a basic specification. Another possibility is among others a list of all the specifications that are attached to a program:

A characteristic property of this report is that certain fields/columns only appear for certain types of specifications (normal, derived, complementary, manual, wet feed). This makes it possible to use one and the same profile for different goals (for different types of specifications).

Example:

With this profile one sees the following for a complementary food:

For another type of specification these specific columns are ignored:

At the configuration of the header (part ‘Details in the page layout), there are four fields ‘Type: …’ These four fields are different than usually. LIBRA chooses one of these fields, as the box “Print” is checked, depending on the type of specification.

Concerning the derived specifications the following columns are available (in the part ‘Derived specifications’ click ‘Configure’):

· Raw material: raw material code of the addition

· Raw material name: raw material name of the addition

· Raw material description: description of the addition

· Raw material sequence: sequence code of the added raw material

· Raw material administrative code: administrative code of the raw material

· Percentage: value in % added

· Type derivative: type of addition and compensation in agreement with the property in the specification screen

Example of a report of a specification detail in which the part “Derived specifications is printed.

3.2 Detail nutrient in session

Menu: Print ( Details nutrient

It is possible to make a selection between the nutriënts of this session.

3.3 History specificaties

Menu: Print ( Specifications ( History

3.3.1 Overview

With this report one obtains a rapport of the evolution in time of one or more specifications. The following information can be printed:

· Additions or removals of raw materials

· Additions or removals of nutrients

· Changes on the constraints of raw materials

· Changes on the constraints of nutrients

· Date and time of creation/activation and deactivation of raw materials

· Date and time of creation/ activation and deactivation of nutrients

· The type of constraint

· Kernel raw materials

· Changes in the type specification (regular specification, derived specification, complementary specification, semi-product, manual composition, wet feed).

· Date and time of modifications in the specification

· Operator who has implemented the changes

· History of the comments

So that the history of the specifications is saved in Libra, it is necessary that the history check is on. Default this is activated (if one disposes of the module history). One can possibly check this if necessary (basic data specification).

After selecting this function, the selection screen appears. Here one can choose of which specifications and for which period one wants to see the evolution.

If one has checked the option “Modify layout”, then the following configuration screen appears:

History specification title

In this part one can enter a title. Subsequently one can by way of data ( configure, choose out of the following optional fields:

The fields that are selected here will appear in the column title below the header on the report. The title will appear for every page of the print.

Header specification

With every first page of a report of a specification, a header is printed. For this purpose the following fields are available with information of the specification.

· Print table: if one checks this, a header is printed, otherwise not.

· Number of data columns: the number of columns over which the data of the header are divided.

· File creation: options in relation to the creation of a csv. File

· Optional fields:

Column titles history specification

These fields appear on top of the columns if selected. For every period, that is to say for every moment in time that a change has been implemented in the specification, they appear once. Three are available:

· Date modification: the date on which a modification has been implemented in the specification.

· Time modification: the hour of change

· Modified by: here the user is filled in that has implemented the modification

History specification

In this part the data concerning the raw materials and/or nutrients are shown. One disposes of the following options:

· Print table: to print the raw material- and/or nutrient data

· Header with border line: column title with or without border line

· Header with gray background: columntitles with or without gray background

· File creation: options in relation to the creation of a csv file

· All the values (if not, only the modified): if this option is checked then all the values will be printed even if they have remained the same. Also there will be a representation of the initial values of the specification (at creation) and/or the current values if it would be the case that the selected staring- and end date do not coincide. The modified values are shown in bold. If this option is turned off, only those raw materials will appear that have been modified in the selected period (selection screen). Unchanged values are represented by three dots (…).

· Most recent modifications first (left): default this option is unchecked and the report will be printed from old to new. With this option checked, one gets a reverse timeline, from new to old.

· Division line between the periods: the basic unit on this report is the ‘period’. This agrees with the period in which the specification has stayed unaltered and is marked out by two points of time on which the specification underwent modifications. For every period certain selected columns (data ( configure) will be repeated.

· Print raw materials?: printing or not printing the raw material data

· Title “Raw materials”: here one can enter a title for the raw material part. Default ‘raw materials” appears here.

· ¨Print nutrients?: printing or not printing the nutrient data.

· Title ‘Nutrients’: here one can enter a title for this part. Default the title is ‘nutrients’.

· Columns: by way of the button configure one can choose the columns that have to appear on the report. The number of columns appears once, others are repeated for every period.

The following columns are, if selected, printed for every period:

· Minimum of the raw material and/or nutrient in the specification

· Maximum of the raw material and/or nutrient in the specification

· Type constraint: minimum or maximum on

· On fresh weight

· On dry matter

· On reference nutrient

· Default

· Constraint on the kernel: this column only appears for complementary feed and/or wet feed.

· K: it is a constraint on the kernel

· -: it is a constraint on the complete food

· External raw material: this column only appears for complementary and/or wet feed.

· E: external raw material

· -: internal raw material

History comments

This part gives a summarizing overview of the specification in time. The information that one finds here are the comments and the sort specification. In this part you have the following options:

· Print table: print the raw material- and/or nutrientdata

· Header with border line: column title with or without border line

· Header with gray background: column titles with or without gray background

· File creation: options in relation to the creation of a .csv file

· Columns: by way of “configure” one gets an overview of the columns that can be integrated in this overview table.

· Date modification

· Time modification

· Modified by: the user who has modified the specification

· History comment: in this field the comment appears that one can enter in the basic data of the specifications.

· History status: tells you if the history for the concerning specification is activated or not. If one disposes of the module ‘history’ this is default turned on for every specification. One can always turn this on by way of the basic data of the specification.

· Type: in this field the type of specification is indicated

· Derived specification

· Basic specification

· Complementary food

· Wet food

· Semi-product

.

It is possible to enter a comment here. It appears between the general data and the detail.

It is possible to select a layout profile. Click the icon to obtain a list with the available profiles. The profiles must have been registered before

Check this to obtain the screen of the modification of the layout. The screen opens after clicking OK.

Enter a print title here. If the report has a default title (in general the title of the list in the menu), this one is replaced by the entered title.

Indicate here if the print comment that was entered in the previous screen has to be printed.

Click here to select a specific printer (see more below)

Indicate here that the default printer should be used

Check if you want a preview

Enter the number of copies here

Click here to determine the base font

Select here the base number format

�

Choose the printer

Choose here between portrait or landscape

Other properties specific for your printer

Sequence code is not printed

For a number of columns the quantity of numbers after the comma is set

The raw materials are sorted on sequence code and subsequently one code

�

Pas de variante et case cochée ? ( Les données de la matière première sont utilisées.

MP externe

MP interne regroupées

Valeur absolue (sans indication d’unité)

Valeur relative (%)

�

Enter the supplementary batch weight here and press Enter to insert a new line. The number of decimals is registered in the report.

Total line. The most important raw material is modified to become a total of 100 %.

With the option “Modify layout” checked, one can choose the profile for formula layout

Label part

Zoomed in formula

La production réelle de la formule 10001 fait un total de 27 tonnes. Sur l’édition ‘Aperçu historique formule’ on peut observer que la formule 10001 a les versions 65, 66 et 67 avec respectivement les tonnages de 12, 3 et 12 ; totalisant 27 tonnes.

�

�

�

In the selection screen one can manually select the nutrients. Default Libra will select all the nutrients in the formula and/or in the label.

Dans la mise en page on peut choisir sélection manuelle et/ou automatique

Sélection manuelle, case cochée

Sélection automatique

Sélection manuelle, case décochée

Version 23 a une version d’étiquette avec un modèle qui contient un seuil pour affichage de 5 %. Pour cette raison, les valeurs de certains ingrédients sont représentées par un astérisque.

Version 22 a une version d’étiquette avec un modèle avec l’option ‘afficher … ingrédients ?’ décochée.

Version 24 a une version d’étiquette avec un modèle sans seuil d’affichages des ingrédients.

Click here to preselect the nutrients you want to see in the graph

Options for the data (nutrients or prices): Frame style, color, size, symbol size.

Click here to determine the graph style

Line

Horizontal bar

Horizontal bar 3D

Vertical bar

Vertical bar 3D

Pie

Pie 3D

Area

Strata

Manhattan

Web

Font size of the symbols of the legend

Title position. The values are always relative to the report page.

With “Group nutrient categories” checked, the nutrients are shown per category and moreover with the descriptions of the categories.

Use formula value in case no label value is available

Men heeft de 7 meest recente versies van de formule 20006 geselecteerd met een tonnage > 0 (Hiervoor bevat de afdruk de getoonde versie 18).

Pour chaque version de la formule, le graphique, montre les valeurs du prix et des nutriments sélectionnés, dans ce cas un seul nutriment : Matières Grasses.

One can select the versions that are, or have been, in production since a certain date. Nonetheless we see the complete production in the report.

Current constraints!

There are two columns that concern the external raw materials selected in the configuration of the raw materials.

The columns that concern the complementary food have disappeared

For the report of a complementary food only the field ‘Type: Complementary specification’ will be printed.

Here one can enter the starting- and enddate of the period of which one wants to print the history of the specifications.

Multiple choice lists for the selection of

Systems

Specifications

Raw materials

Nutrients

Print comment