Home

User Manual

1. TE 36 7 13 37 714 Reporis saucius dioi E US ouv DO casuais a 37 EGITRON Page 1 ControLab Quality Control Software for Cork Products User Manual 7 15 BUS UO Sst 38 O REPONS 38 Types ol REPONS 39 de POSSIDIE COMIC CANONS M 39 8 3 Creation of Reports Ih seo sus ae rs uS ome Ex aU we scu xu Pas 40 MUNDI PIRING 41 9 SQL Server Database 41 10 EGITRON CORO MOQUICS 41 10 1 Module of Statistical Analysis 42 10 2 MOQUIO seica 43 10 3 Integration with EGITRON SPC 44 10 4 Module of T
2. on Fo Mose c m NoDETI NoDTS gt Disc 2 wi weigh E readings of the diameters the Without Low Edge Diameter gt Disc 1 positions for the moisture readings f Diameters by Peston With Corks Orientation that MedCork will have to realize as Note These Parameters will on Low edge Extra default for new reports well as the eventual orientation of the corks by the MedCork feeder the SMA In the window of the technical specification it is also possible to fill a field of notes which contents are automatically copied to the internal notes of the new created reports that use this specification To ease the management of the technical specifications there are two buttons in the right top pane of the window that permit the following operations o Duplication It permits the user to duplicate each of the technical specifications o Propagation of Values This feature permits to copy the values of the current specification the user may choose the tests which values are to be copied to one or different specifications already existing in the database e Sampling Tables In ControLab it is possible to configure various sampling tables each of them being identified by its name given by the user The objective of the definition of the sampling tables is to permit to automatically attribute the correct sampling dimensions for eac
3. EGITRON RUA CENTRAL DA VERGADA 1280 4535 166 MOZELOS VFR PORTUGAL 351227 471120 FAX 351 227 471 129 E mail info egitron pt WEB www egitron pt Engenharia e Automa o Industrial Lda ControLab Quality Control Software for Cork Products User Manual Manual version 3 4 0 Applies to versions 6 1 0 or higher ControLab Quality Control Software for Cork Products User Manual EGITRON ControLab Quality Control Software for Cork Products User Manual Exemption of Responsibilit This manual was produced and reviewed trying to describe as correctly as possible the ControLab Quality Control Software for Cork Products features and characteristics Nevertheless this manual or Software can be changed without previous warnings EGITRON Engenharia e Automa o Industrial Lda does not answer for damages caused directly or indirectly by errors omissions or discrepancies between ControLab and the instructions or descriptions contained in this manual Any part of this document can be reproduced or transmitted on any format for any objective without EGITRON written agreement Commercial Brands Windows and Microsoft are Microsoft Corporation registered commercial brands Other commercial brands and registered commercial brands not listed above may be used in this manual Before requesting help to EGITRON read carefully this manual use the technical services of your company if they
4. GITRON QUALITY CONTROL REPORT rtugu RELATORIO DE CONTROLO DA QUALIDADE RAPPORT DE CONTROLE DE LA QUALITE Footer Certification L File egitron jpG Mode Strecht INFORME DE CONTROLO DE LA CALIDAD po ail Pruefbericht Qualitaetssicherung Relazione del Controllo Qualit Note Double Click in the fields to open the options windows for the Font Color and Style File 9001 14001 220004 CIPR_Cor jpa 31fa ff57508cb3 Mode Zoom Zoom Zoom Width Total M Half Picture Files Folder D Engenharia Trabalhos Al icans Note When the header second logo is configured the text of the right superior comer will not appear in the printed reports One example is the possibility to configure the reports headers for the different languages Logotypes Title Colors etc with the possibility for the user to create until three different headers depending on the Software Acquisition License that may be chosen before printing a report For each group of headers and footers it is possible to configure a maximum total of 5 logotypes 2 for the header and 3 for the footer with an adjustable with The objective is to have a structure similar to the one illustrated by the following picture hacer planet a DL SC Os resulta
5. The user should read the specific manuals for the modules of EGITRON ControLab in at order to get more detailed information about the features and the use of each of them EGITRON Page 41 ControLab Quality Control Software for Cork Products User Manual 10 1 Module of Statistical Analysis For each of the reports and tests of EGITRON ControLab it is possible to define if it must or not be considered by the statistical analysis module for results and presented computations This configuration must be done by the user from the activation field that has a histogram as Icon oll Statistical Analysis Analysis ERO Test of Density S Jh of Densit Analysis Average Maximum Minimum Filters Statistics Date between 19 06 2011 and 19 07 2011 Filter last 30 days X Axis By Day Products Sizes Categories O Select Ungelect Al O Salect LInselect Al E O Select nzelect Al Agglo 1 1 12 23 126 Container Natural 13x 21 4 Despatched v 28 X 18 X 12 Sample 4 28 Xx 18 X 1 v Submited 44 X 27 45 X 23 5 45 X 24 45 X 25 452 23 2 Status D eragated In Process Apraved Rejected Conditional All K O O Inspection Expedition All Type li Hame like Entities Grades Treatments washings e Lots without Washing W Uncolored v ashing v Washed white Add from Group 151 Lots without Treatment EGITRON 2nd A 3rd VwiTreatment 4th sth Bth Ext Supe
6. 20 6 4 Configuration of ControLab for use in Terminal Service ecce nnmnnn 21 6 5 Configuration of the Acquisition Equipments 1e 22 6 6 Configuration of Translations ict csccisee M 22 67 OIher C OnO ONS 23 RTOS 24 Window REDOR o DS Em 24 7 2 ASSOC See REA 26 DOs NOSSO 27 Automatic ACQUISTHON sssaaa aaa ua ana 31 7 8 Repons DUDICANONS 32 7 6 Importation of values from RepottS sssunnsennnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn nnnm nnmnnn nnnm nnmnnn nnna 32 7 7 equential Creation RODOINS sssrinin kanino eaaa aaaeaii aani 34 7 8 Acceptance Rejection of Tests and Reports from AQLs or tolerated 34 7 9 Categories for the Reports cssccssscssssssseessseessseeeseeeenseeeseeeenseesneaesneaesneaesneaesneeesneaesneaesseeesseaesnseesseaes 35 7 10 ec 35 7 11 List of Changes to the Finished Reports cssccsssecsssessssessseeessseeesnseneenseneeneenesneeneeneeneeneenensees 36 7 12 MII A A UMN
7. Test amp 1 1 v lt Weight Density manual we will describe Sample 12 Maximum 48 194 Method NP2803 1 40 157 the main ch aracteristics EL 20050723 Average 45 173 Standard Deviation 0 26 10 61 common to the different eto E lt Lower Limit 0 0 tests of ControLab E v 46 182 Indeed with the Tus 44 17 NC TT E 0 00 8 33 Automatic PEE objective to ease the ica Density in kg m3 BORED em 1 Es Internal Notes register of values for the zz E auto L1 Double click to edit Notes for printed Reports different tests a common structure was adopted when possible for all of them To get more detailed information about a test of ControLab the user should read the The common structure for the ControLab tests normally includes corresponding specific user manual e Table of individual values Values introduced through automatic acquisition or manual register EGITRON Page 28 ControLab Quality Control Software for Cork Products User Manual e Statistical Values Calculated through the individual values Maximum Minimum Average Standard Deviation Range e No Conformities Depending on the configuration the no conformities may be the number of products with values out of specifications limits or the corresponding percentage It is pos
8. Brand Picture Spec ore h Expedition Date Chamber Type RE Predictable Delivery Date Packing Type Approved Size 45 X 24 Quantity by S alume B Ex Conditicnal Report s Responsible Armindo Oliveira d Quantity 150 000 Report s Creator ssn Armindo Oliveira M t Final Result Mores Identification Additional Motes Internal Frinted BH Double click ta edit Potes for printed Reports Current User workstation mmo ppm rw Armindo Oliveira Sena se gs Mute E E EGITRON Record WN GITRON Page 25 ControLab Quality Control Software for Cork Products User Manual e The first page is the report identification page contains all the fields that describe this report some are required Number category product client date e he second page contains resumed information relative to the tests associated to the report test name current state data used method sample dimension result and associated responsible e The eventual third page presenis the information relative to the selected test for the current report the third page only is visible if a test has been selected After having selected a particular report the user has two ways for selecting one of the tests associated to it e The user may use the Selection List present in the top pane of the reporis main window Between 2009 06 29 and 2009 07 29 Filter by Catego
9. Please read carefully note is a suggestion or advice that helps to get the best of the program 4 Introduction The main objectives of ControLab are the elaboration of quality control reports for cork products and the storage of the data relative to the tests in a simple and safe way Nevertheless ControLab can t be seen just as a simple program for the elaboration of quality control reports but also as an excellent tool for laboratories analysis and management It also guarantees the interconnection with numerous automatic acquisition equipments This program is based on the database developing tools Microsoft Access XP and Microsoft SQL Server 2005 adding an easy use and fast processing to a safe way to store data We list below some of the main characteristics of EGITRON ControLab e Security the system is based on the technology of relational databases e Friendly ambient proportioned by a nice and intuitive user interface permitting to easily configure all the needed parameters e Complete integration of different modules in a single program e Easy analysis and processing of store data The Software permits to access the information relative to the reports in an efficient and simple way with an easy integration and sharing of all the information EGITRON Page 4 ControLab Quality Control Software for Cork Products User Manual e Multi user ambient There may be different persons using simultaneously
10. Product Ex Conditionnal In Process Client Supplier and Product only O Rejected Other Filters NENNEN ERN IRAN M Res Client Supplier ze Grade Date Quantity GGEEGITRON Natural 2009 11 06 GGGHEGITRON Bartop 2009 11 23 Natural 2009 11 06 Natural 2009 11 06 BGMBEGITRON Natural 2009 11 06 BE 200970006 ESSWEGITRON Natural 2009 11 06 Double Click in the report to open it This window serves to make a resume evaluation of some general aspects of the reports saved in the database It includes a set of different filter options in order to permit to extract some information relative to the realized reports between dates by status category client product GITRON Page 37 ControLab Quality Control Software for Cork Products User Manual size grade There is also a button for the search result printing It the user double clicks the field code the corresponding report will be automatically opened a results The user should notice that the list includes the identification of the status of the report with an abbreviation This abbreviation is configurable in the table of the names for tests Configuration of the Names for Tests Results Abbrev Mame to Use Portuguese French Spanish German Italiar s RES TAP A
11. must be filled or the two simultaneously Whenever a report is created ControLab is going to try to find a specification to associate to it following the steps Step Client Supplier or Group Product Grade xX X OX 2 x XxX __ X _ L4 0X PX 8 0X X X a 0X X E 0 0 0X eK 8 0X j 9 0 X X X __ 300 X mp X X n 0 0 0 a Last Step Select the Technical Specification by Default K Same Empty If a determined field is not empty but the option selected is different from the one used in the Technical Specification the Technical Specification is automatically out of the list of possible choices e This way it is possible to define a technical specification by default for each product filling just the field product and letting the specification defined as generic It is also possible to define a technical specification by default for each of the client filling just the field client and letting the specification as generic EGITRON Page 16 ControLab Quality Control Software for Cork Products User Manual Another important objective of the technical specifications table is to ITRON Mags 7 configure the automatic acquisition from MedCork It is trough this Lo With Length X With Center Moisture window that is defined the number of
12. Dust Quantification gt gt Products in the page Tests 2222 Grain Measuring lt lt for the product and client group Oxidants defined in this report Lain Residual Sensorial Torsion Treatment Visual Quality The user may correct this list for the particular report without changing the configurations by default selecting or unselecting tests The window for tests selection is accessible through the button Select Tests from the page Tests List of the main reports window or double clicking in the selection list of the tests in the main reports window 7 3 Test ControLab permits the realization of the following tests e Absorption e Absorption in Bottle e Agglomerate Density e Bartop Dimensions and Weight e BarTop Visual Analysis e Boiling Water 1 e Boiling Water ll e Capillarity e Compression Insertion Density e Dimensions Length Diameter Ovality e Dust e Extraction e Gas Leaking e Liquid Leaking EGITRON Page 27 ControLab Quality Control Software for Cork Products User Manual e Glue Plan Resistance Bartops e Grain Measuring e Microbiology e Moisture Oxidants e Relaxation e Screw Caps e Sensorial e SPME GC MS e Visual Quality e Recovery e Residual e Torsion e Treatment e Water Pressure Test WPT In this section of the Identification Tests List Density
13. S Developed by Software will permit to consult not ZEGITRON only the graphic for the selected analysis from the selection lists in the top of the window but also the list of individual values For these two modes of visualization of information it will be possible to print a specific report 4 higher consistence for the analysis to be realized Note The Statistical Analysis module just considers the finished tests This way it is not possible to analyse tests that are not completely finished in order to guarantee a 10 2 Historical Module The objective of the creation of a Historical Database for ControLab is to save and administrate all the information relative to reports and configuration data that it is not pertinent to keep in the current database but that is important for answering to client s complaints or supplier s verifications still for statistical analysis purposes The exportation of the information to the Historical Database permits to lighten the computational weight associated to the current Database improving the performance from EGITRON ControLab The passage of the values is only in the way Current Database gt Historical Database The user should read the specific manual for this module in order to get more detailed information EGITRON Page 43 ControLab Quality Control Software for Cork Products User Manual 10 3 Integration with EGITRON SPC Pro The main ob
14. able to change the data The button New permits to add one register and the button Delete permits to delete the current register The button that permits to close the current window is the button that contains an icon showing a red cross Some windows of ControLab show a confirmation button with a suggestive icon When this button is closed to the the closing button this last one has the meaning cancel EGITRON Page 5 ControLab Quality Control Software for Cork Products User Manual Regarding the button Edit note that changes to a register are only saved in the database when the user unselect the status of edition button up e Selection Lists It is possible to verify that some of the fields have a little lateral arrow that Natural Agglo 1 1 5 associated list from where you can Search Products indicates that the fields have an Configuration 0 select one of its elements It is possible to select the elements with the mouse or introducing the 1st character of the desired item The items of the list are introduced in the tables relative to the field normally identified as a similar name e Double click Double Clicking in the selection lists associated to tables of configuration will ease the navigation between the windows in the Software Indeed when the user double clicks in a selection list relative to a table the corresponding window is opened e Introduc
15. e d ivid U al fi of th e Entity responsible for calibrations Internal Warn Users about Calibrations E eg u nt or 51 th e an n u al Phone Warming of the following calibration with antecedence of days plan of calibrations New Devic L In order to correctly configure the registers of calibrations there are two main steps e Configure the Calibration warnings The user must define if the equipment Calibration may have calibrations and if warnings Equipment that may have calibrations required as well as the respective Entity responsible for calibrations Intemal antecedence Warn Users about Calibrations Warning of the following calibration with antecedence of 30 e Define the dates of the planned and realized Calibrations The list available from the Calibrations Registers Calibrations of the tab of the window of Date for TE 2007 09 M es Calibration cal b rat n S iS ist of cal rat n Annual Calibration Equipment OK Nuno Almeida E 3 17 Calibration predicted and realized for the selected equipment th e fi eld 2 IS n ot Se ected y th IS Note Each Calibration Register with the field Calibrated Cal unselected will origin warning to the user considering the date for the calibration and the antecedence for the
16. exist and or use all the tools of auto help that may have been put available during the acquisition of the product If you do not manage to solve the problem you should contact EGITRON through the contacts listed in this manual indicating e Software acquisition date e Software name and version e Problem description and origin e Error Message or similar that may appear EGITRON ControLab Quality Control Software for Cork Products User Manual 1 Condratuladols NOIES ccc cece dapi Ee dbi a 3 2 About this en Conventions We T 4 MOU ON 4 5 General Aspects of ControLab 5 assassinadas aliadas isa ainsi passion tuas 7 6 1 Logical Sequence 8 6 2 Description of some Configuration Tables 9 6 3 Obsolete Configuration HeglS ers lacius eai eucuuaco cuna dcr kus cosa tu cunc o tun eec Us RU
17. password to proceed to the F user authentication by ControLab Workstation Next if the authentication got success the main reports window will be opened The superior part of the reports window permits to filter and to select the reports existing in the ControLab database By default ControLab will open the reports with the state In Process having a date contained in the 30 years before the current date EGITRON ControLab version 5 2 2 lI Between 2010 11 15 and 49 Filterby Categories amp X Reports Ree In Process EGITRON eens Mns EH 21 i Inspection Conditional As it is possible to see in the picture the possible filters for the reports to open are the following n Click in the Lizt bo edit the available tests o Temporal filter between 2 editable dates by default open the last 30 days o Filter by Product selection list below the field Filter by for all EGITRON Page 24 ControLab Quality Control Software for Cork Products User Manual o Filter by Type reports for expedition reports for reception o Filter by State In Process Approved Rejected Conditional o Filter by Categories Whenever one of the filters modified the list of the reports opened in the window is also modified The user at any time can also use the refresh button in the right of the d
18. this table it is also possible to associate each image to a list of clients suppliers It is important to notice the possibility to filter the registers by entity in the second page of the tabulator The association of the image to each report is done from the window of identification of reports selecting the corresponding name with the possibility to filter the registers that are specifically associated to the clientisupplier associated to the Brand Picture Spec report field Spec EGITROM 6 3 Obsolete Configuration Register Most of the configuration tables Clients Suppliers Categories Jbsolete E References Sample Patterns Sizes Producis Grades Washings Obsolete Treatments permit its registers to be defined as obsolete they are defined by default as current making them disappear from the different windows for register and analysis Reports Orders Sample Patterns References Technical Files Statistical Analysis and Reports Status This feature is partcularly interesting for registers that the user wants to delete but that ControLab does not allow because associated information exists in reports and tests EGITRON Page 20 ControLab Quality Control Software for Cork Products User Manual 6 4 Configuration of ControLab for use in Terminal Service The setup process of ControLab is the same independently of its type of use local PC or via Terminal Service To get more detai
19. warnings defined in the page Equipment Identification means that the register is a predicted calibration and ControLab will use as base the field Date that will become the predicted date to provide warnings to the users From the moment that the field Cal is filled then the warning is not emitted any more because this means that the calibration has effectively been realized EGITRON Page 45 ControLab Quality Control Software for Cork Products User Manual 10 6 Module of Technical File The module of Technical Files of m EGITRON ControLab is a tool that ER gt Es Product Natural English Header Note Revision O Client Supplier EGITRON permits the management and Size 45 24 Article Schema Cork 1 Chamfer printing of the technical files for the mansi Washing white different types of products and for Sidi E Brand each of the clients defined in the Notes database of the Software Easy to Characteristics 40 Pattern Sample Measure Tolerances use and to configure the module of conten Total Percentage A Technical Specifications is pex completely integrated in EGITRON mmm de s ControLab ES o The module permits the insertion of pictures of products schemas and bartops as well as the regist
20. 0000 ADS InterLab and its parameters For the case of the T oe ge E 00000000000 10 0000000000000 0 0000000000000 Acquire dimensional measures through Weight Acquisition Mode Normal Mode In the dimensional acquisition window manual values introduction capability for the user instead of equipment moisture reading through Aqua Boy it is necessary to check that the type of the used InterLab Aqua Boy DMX Scale Torsiometer JAY BarCode Printer ExtraLab ParkerLab MLER _InterLab Aqua Boy DMX Digital Scale Torsiometer Extralab ParkerLab Mecmesin MLER Database BarCode Printer hygrometer corresponds to the correct Gauss configuration Scale EGITRON SESS Name EGITRON SC2009 Scale by Default 4 The By Default Scale is the Scale used by the Software ControLab permits the connection and of characters to receive First character to receive a First character to receive when not stable CO nf g u rat n of a n y type of scal e fo r Position of the first character of the value 1 of characters that define the value Minimum Valid Value 0 5015 automatic values acquisition since the scale iis do Nore bay ti Sip Comunication Settings String to Ask Actual Value S Fill this Field only when it is not posible to SetUp the Scale to send by Hardware stable Values permit a RS232 Connection The Connection via InterL
21. O Conditionnal Product Grade Client Supplier E spedition a B Inssecton Double Click in the report to open tt EGITRON Page 36 ControLab Quality Control Software for Cork Products User Manual 7 13 Barcodes Label Besides the different tyoes of reports that can be created in the Software and that that will be described in this manual there is the possibility to print barcodes labels with the information relative to the identification of lots To get the best of this feature the user should use the following equipment e A Label Printer e A terminal barcode reader After the correct configuration of the name of the labels printer in the window for the configuration of the acquisition equipment the report identification labels can be printed from the printing configuration window The user may indicate the number of labels to print The labels have the format 9 50 x 9 50 cm After the labels are printed they can follow the lots and the corresponding report can be easily found by using the window Search by Code available from the menu Reports This window receives the inputs of the barcodes reader and when a valid code is introduces the respective report is automatically opened 7 14 Window Reports Status Reports Status DA Sort Ascending Filters Date Between 2001 12 15 and 2010 01 14 X Report Date Status List Serial Printing Report Name State O Conditionnal
22. Order Quantity Sample EGITRON 45x 24 08 07 2011 150 000 Sample EGITRUM 45x 24 08 07 2011 150 000 Osidants Dust Torsion EE E E Liquid Leaking The structure for the window of importation of values is as follows e The upper pane of the window shows the filters for the list of the available reports temporal by entity product etc e Inthe center and bottom of the window there are two lists of reports o The first with the available reports and that depend on the selected filters o The second with the reports effectively selected from the list the selection of each report is done with a double click on the field Report in the list of availbale reports e In the right pane of the window there is a list of tests that permits the user to select the ones that are to import There is an useful feature that permits to select which of e a Show configurable field H the two lists existing in the window of values importation the latest configuration is kept in the three configurable fields of ControLab may appear in memory EGITRON Page 33 ControLab Quality Control Software for Cork Products User Manual 7 7 Sequential Creation of Report Using the button New in the window of reports identification it is em possible to create a list with the identification fileds that are required to create reports in ControLab This list if confirmed permit
23. TRON Page 9 ControLab Quality Control Software for Cork Products User Manual e Technical Files Module e Orders Module Edit and or Delete Another important feature of this window is the possibility to introduce the users digitalized signature that may appear in the printed reports e Table of Clients Suppliers Groups Easy to fill the main objective of this table is to ease the definition of the configurations of the tests to realize by default While defining the clients groups the user will have to remember that the objectives of these groups and of their association to each of the clients are mainly two e Associate tests by default to the client group depending on the product This means that when a report is created the tests that will be associated by default are the ones that are defined for the respective client group and product e Associate AQLs and sampling tables to the client group once more it depends on the product This means that whenever a report is created the sampling tables and AQLs that will be associated to it by default are the ones that are defined for the respective client group and product T The definition of client groups is required If you don t want to differentiate the clients a you may just define one client group that will aggregate all the clients On the other side if each client must be seen as a particular entity a client group may be defined for each client e Table of Clie
24. ab configuration of the scale will have to define if Record 0 Loi exe ppa oF 1 it is directly connected to the PC or trough an InterLab the scale settings parameters and some other relevant information about the communication 6 6 Configuration of Translation In the various configuration tables there are normally fields for the translation of the different registers It is important to realize this translation and it is strongly advised to do it in the moment of the introduction of the register to avoid the user to forget about it We alert that Portuguese French Spanish incorrect translation or even worse the lack of it may origin translation errors or empty fields in the reports printed in the different languages EGITRON Page 22 ControLab Quality Control Software for Cork Products User Manual 6 7 Other Configuration Beyond the various configurations that have been described in the preceding paragraph there are a high number of other important configurations The user may discover these configurations running through the various tables and the options that are available Reports Titles Headers Colors Identification Sub Reports Titles Color E Header Report Name Fore Color I Text ia Cental AMOZELOS Back Color EI Back Color Show the Company address Reports Titles Header Company Left
25. ade Validity Limit Date Treatment W T reatment Washing Uncolored Size 45X 25 Do not Warn Users M Chamf Erin dM ed Warning Antecedance Days Finishing Packing Type Bags EGITRON Page 14 ControLab Quality Control Software for Cork Products User Manual ControLab may work correctly without using the table references but it may be useful One Reference must be seen as an entity placed one level above the Pattern Sample Indeed the register of a reference does not include only the pattern sample the aggregation in percents of the visual grades but also important characteristics about the product such as the grade the washing the size the brand etc The references may be defined as associated to a Client Supplier or as internal this means that they can be used for any client or supplier The objective of the definition of references is to ease the creation of reports The user just has to select a particular reference to make the other configuration fields of the report to be automatically filled e Table of Technical Specifications Technical Specifications Order By EGITRON DO Elent Suple Identification Dimensions Diensity Moisture BarTop Tests Other Tests MedCark P Help Technical Specification Identification E Chent Suppler EGITRONM or Group Do n Product Natural gt Sp
26. ality control for different products This flexibility is allowed thanks to the table of Products Indeed through this table and at any time it is possible to add a new product to the ControLab database This table permits beyond identifying the products that may be controlled the configuration of the essential parameters for the more important tests in ControLab These configurations can be seen as configurations by default for each product and may be corrected report by report GITRON Page 12 ControLab Quality Control Software for Cork Products User Manual The main configurations are the following O Dimensional Test Configuration Name for the first dimensional reading length number of diameter readings product identification with discs bar top Agglo Configuration of the moisture test Number of readings name for each reading Configuration for the density test Definition of the visibility of the weight and density in the printed reports and in the window of the test Various Configurations related to the test of visual quality and defects Identification of the different pressures for the leaking tests Other Configurations Configuration by default of the TCA Quantification Test of the visual grades to use by default in the visual test configuration of the extraction test Do not forget to correctly fill the translations of the main fields in the page Languages An erroneous tr
27. anslation or its lack may origin translation errors or empty fields in printed reports It is also through the table Products more precisely through the page Tests that will be configured the tests to realize and to print by default whenever a report is created for the selected product and for each client group defined in the table Clients Suppliers Groups Products Search Products search by Clients Suppliers GouplA Selection of tests to achieve by Product and Group Printing Tests Graphics Density 14 EGITRON Available Tests Selected Tests Absorption Density Absorption in Bottle Dimensions Agglomerate Density Moisture Bartap Dimensions and eight BarT op Visual Analysis Boiling water I Boiling Water Capilarit amp bsorption Cork Information printing in Absorption in Battle Density Descriptive Reporte Agglomerate Density F Dimensions AGL Dimensions Bartop Dimensions and weight Moisture BarTap Visual Analysis Rejections O AQL Moisture Bolina water ABL weight Diameter AGL Oxidants Extraction Torsion Moisture 1 O ABL Treatment E dit Mew Delete 3 Page 13 ControLab Quality Control Software for Cork Products User Manual e Table of Pattern Samples The table of Pattern Samples permits to define the set of the pattern samples used in visual tests and serves as pattern for comp
28. arison between the quantities found in the test and the pattern sample Pattern Samples Search Sample Configuration Mates List n Lists for Renovation and Elimination of Pattern Samples Identification Code of the Pattern Sample Printed Reports Mame of the Pattern Sample P S Demo 001 Product Natural amp Validity Date 2004 03 24 Active Reference Sample Quantity 1 000 Mote The unactive references can t be selected in new reports Validity Limit Date Do not Var Users Warming 4ntecedance Days Total Percentage 100 X New Delete x In fact one Pattern Sample is identified by its code normally an internal code for the Record 14 4 of 1 laboratory and is the aggregation in percent of different grades until a limit of 8 grades The association of each pattern sample to a report is made in the same register as the visual test e Table of References References Search Reference Ref Deno gt Configuration Notes List Lists for Renovation and Elimination of References Identification Name of the Reference Ref Demo Product Natural Client Supplier EGITRON Pattern S ample 5 Demo M Validity Active Reference Reference Date 2004 03 24 Client Reference Note The unactive references can t be Sample Quantity 10 000 selected in new reports Quantity by Volume Gr
29. asks and Pending Tests ssssccssseccssseeessseeesseeeenseeensoeeensoeeeneoeeenseneeneonesneonesnenenees 44 10 5 Module deiecit 45 10 6 Module Technical p cenas 46 10 7 Module OR sas DSL 46 NOTES rest 47 EGITRON Page 2 ControLab Quality Control Software for Cork Products User Manual 1 Congratulations Note Congratulations for acquiring EGITRON ControLab Quality Control Software for Cork Products With this excellent Software you can create quality control reports integrating different tests and using equipments with automatic values acquisition as the MedCork the InterLab the TorsiLab or digital scales between a set of numerous equipments This manual will permit to obtain detailed information relative to the Software features 2 About this Manual This manual describes the functioning of ControLab Quality Control Software for Cork Products compatible with Microsoft Windows 2000 XP This program was specially developed to permit the elaboration of quality control reports and holds a set of additional features that permit to manage and analyze the information archived in the reports After this manual reading the user will be ready to Install ControLab Software and Database Configure t
30. ate filter fields to refresh the presented information This feature may be more usefull in case of simultaneous users The selection of a particular report in this list will be realized through the Selection List defined by Reports Whenever a user tries to find a report and do not find it in the selection list he will have to check the various filters of selection Indeed an incorrect configuration of the filter may origin the fact that the report is invisible for the user Below the superior part of the filters and selection of reports the ControLab main window is also composed by a tab that may have two or three pages EGITRON ControLab version 6 1 0 Between 19 06 2011 and 19 07 2011 4 Filter by Categories CGITRONS 201170001 A l Category Me iti j Expedition Approved TE EN Inspection Conditional Doubl Click inthe List to edit the available tests Identification Tests List Report Sort the List of Clientetsuppliers by Code bru ient 5 gem Category EELE Ed Client i Reference Internal Refter Product Natural _ Report Date 08 07 2011 Collect Place Iu Io Expedition Prod Order Treatment WT reatment Inspection Washing washing 7 Purchase Bags Dim Conditions the Ambient Inspection Date 29 06 2011 ME TRC
31. be considered by default and 4141 414 14 D D 959 29059 IV HY SS HL HL HL OY OY OS HL HL AV o the sampling table to use by default by ren Tate test There may be configurations for each of the possible combinations Generic Groups and also a configuration by default Group by Default While creating a report the ControLab behavior will be as follows o 1st Step Try to find the configurations for the Client Supplier and the Product of the report created to generate the tests o 2 Step If the first step has failed there are no configurations for the Client Supplier and the Product of the generated report use the configurations by default to generate the tests e ControLab General Parameters Setup window The configuration window for the general parameters of ControLab permits the user to define parameters that will incidence in various aspects of the Software It is very important for the correct use of the program that the user knows the data that can be defined in this window and the respective consequences in the use of ControLab Some of the characteristics that can be configured in this window are e Automatic codification for the name of ne
32. brief z m Selection of the Language for Printed Reports indication that appears while pointing with the mouse to the referred object e Important keys Another important aspect is the behavior of the following keys o ESC permits to cancel an invalid user operation o Tab and Enter used to navigate between the different fields e Navigations Buttons At last it is important to refer a set of buttons Record 4 g Gia oF q SL that permit when available to navigate between the registers of the respective window 6 Confiquration As we have already mentioned in this manual the ControLab base is the set of its configuration tables This way it is essential that the user correcily understands the set of configuration tables that are available An incorrect or incomplete configuration of the ControLab tables may origin a multiplication of the amount of work while creating reports and registers for the respective tests Indeed the configuration tables permit to define the main set of default values for numerous reports and tests parameters If there tests are not correctly defined they will have to be individually corrected report by report This way the first step the user has to follow for the correct EGITRON Controlab Setup Database use of ControLab is the configuration of the tables The main Clients Suppliers part of these tables is accessible thr
33. cator Table e Hygrometer e Digital Scale Regarding the acquisition of values from MedCork it is important to refer that it is done from the Software of control of the equipment that exports the values directly to the ControLab s Database In the second page of the reports identification window tests pane there is a button that permits to update all the reports with pending individual values from MedCork Pending from MedCork Beyond this after the update process EGITRON ControLab of a report with values from MedCork ControLab checks if there are others Do vou want them to be updated 2 There are other reports with pending values trom EGITRON Page 31 ControLab Quality Control Software for Cork Products User Manual pending reports and if so it asks the user if he wants to update them From the button shown in the right top pane of the window of reports the user may access the feature of duplication of reports Any created report will have the same information as the initial report except obviously the name or the category of the new report that must be introduced by the user If the user wants to duplicate the information relative to some of the tests only he may select them from a list corresponding to the tests associated to the report Report Duplication Identification of the New Report Name Reportlopy Category W Statistics By default include new reports and respe
34. ch the Software has been opened 8 4 Multiple Printing LJ In the window for the Multiple Selection of Reports to Print printing configuration for the Results Reports Descriptive Report Dimensions D ensity M oisture BarTop Dimensions and Weight reports there 5 a button that permits Resume Report Dimensions Moisture Compression Insertion Extraction Relaxation to open a window from which it is Recovers Absorption Dust possible to select various reports to be Seem printed The objective is the possibility iii a to print a set of reports directly to the Create PDF x X printer defined as being the printer by A default or still the possibility to create an unique PDF file merging the different selected reports 9 SQL Server Database Maintenance From the window of Database Maintenance the user can access the following features for the management of the SQL Server database e Realize Backups the Integrity of Data e Compact the Database e Restore the ControLab database using a backup file previously created Some of there operations have risks associated with the possibility to corrupt the database For this reason they must be used carefully and after the creation of a backup file 10 EGITRON ControLab Module The next paragraphs of this document will succinctly describe each of the modules of EGITRON ControLab
35. ctive tests in the Statistics Tests to Duplicate E Dimensions Mime i _ JM The user can define if the reports and tests created as a copy must be considered or not i 4 automatic change in the other Despite this the Software permits the user at the end of the in the statistical analysis module activation field with a colored histogram as icon When the duplication finishes the two reports the initial and the copy do not have any common data and for this reason any change of data in one of them will not imply any duplication to create an association between the two reports in the tree structure Traceability feature for the reports 7 6 Importation of values from Report Using a button present in the right top pane of the main window of reports the user may import values from one or different tests from list of different reports existing in EGITRON Page 32 ControLab Quality Control Software for Cork Products User Manual ControLab for the current report destination The values from the original reports are compiled in the final report Values Importation Origin Reports Between 19 06 2011 19 07 2011 Destination Report Filters Prod Order Code ity Purchase Ord Product Bags Dim State Available Reports Tests to Import Absorption L L TCA K Dimensions K Moisture Category Eritity Product Date Prod
36. da EGITRON Page 48
37. dos dos ensaios apenas deem m zpeito aos ibe nz enzala dos Este relat rio s pode ser re produzido integral ou parcialmente de acordo com a empresa RR dot Pagina 1 de 1 Documents Codes Document Name Document Model Document Code RH dot Barcode Label AG dat RD dot RDI dot RDF dot RDE dot RDA dot RDA dot RR dot RRI dot RRF dot Another example is the table of Este relat rio s pode zer RL3710 ani configuration of documents codes that permit to configure for each of the report type the RE dot Technical File 8 EGITRON ControLab Quality Control Software for Cork Products User Manual codes that will have to appear in the left hand bottom corner in the pages footer of the respective reports In order to ease the management of registers some configuration tables of ControLab permit to print reports with the list of registers 7 Reports and Test In the following sections and sub sections the manual will aboard the most important questions for the correct use of ControLab for the creation and register of reports and tests 7 1 gt Window for Reports EGITROM Controlab version 5 2 7 The first step that must be realized by the user while opening EGITRON ControLab is the pE er ca User Name x introduction of its identification rmindo Oliveire of its
38. ds to its status at the moment that a quality control is realized on it Possible options are reception submitted container and etc When the Software detects that a specific report has already been realized but with a different grade a button in the different tests permits to realize the comparison of values statistical between the different grades e Using the categories table the user can define the number of days that separate by default and by category the inspection and expedition date from the report date 7 10 Rejection From the page of identification of reports it is possible to access a window that permits to manage the rejections that have eventually been associated to a report It is then possible to add a new index of verification for the report where the previously rejected tests may have been changed to approved without loosing this information Check Results Check t 1 a Report 2010 0001 Category Sample Rejections by Index of Yenfication gt a dae To Responsblo Dimensions 201042 15 Armindo Oliveira 20101215 Olvera 20101215 2010 12 15 Armindo Oliveira EE EGITRON Page 35 ControLab Quality Control Software for Cork Products User Manual 7 11 List of Changes to the Finished Repo From the moment a report is finished the status Approved or Rejected is associated to it and if this option is active in the window of configu
39. ec By Default NOTE The Chent Suppler the Product are required fields The Grade and the Size optional fields Mates Note The notes introduced here will be passed to the field Internal Notes af the new created reports Dee INI Record 4 The table of Technical Specifications definition of tolerances and nominal values expected for each of the tests is one of the most important in the objective to reduce the individual configuration of reports and to privilege the configuration of specifications by default for the creation of reports Considering the technical specifications the user should retain the following points EGITRON Page 15 ControLab Quality Control Software for Cork Products User Manual e There may be an infinite list of technical specifications e Just one of them can be defined as being the specification by default All the others are generic e There always must be at least one technical specification defined by default e The specification by default is the specification that ControLab attributes to the report when none can be associated to it this way ControLab guarantees that each report has a technical specification associated when created e Each technical specification can be defined by Client Or Client Group Product Grade and Size The main requirement is that one of the fields Client Or Group or Product
40. er of their characteristics and technical specifications tolerances in the technical files printed from the ControLab The module of Orders permits to register and u TETUR 2000069 and 2009 07 30 1 E urchase Order to manage orders using auxiliary Cent E BS eee gt Order General Information Orders List Orders Items List configuration tables common to the quality phe a Client EGITRON E reports It also permits to search registers m O peo General Notes following different filters and to print reports of the order items saved in the database B vw 2 Pending Agglo 1 1 Note that some characteristics of this module have as objective to turn its use more flexible EGITRON Star Report based on the following Purchase 7 7 Z Mem Delete and easier as the possibility to create various c 7 headers definition of the logo and colours used in titles for the printing of the main report of the order or still the feature of duplication of registers and etc EGITRON Page 46 ControLab Quality Control Software for Cork Products User Manual NOTE EGITRON Page 47 ControLab Quality Control Software for Cork Products User Manual EGITRON Engenharia e Automa o Industrial L
41. ert Washing Brand Treatment Quantity add ress of th e O Insert Inspection and Expedition Dates cl ient suppl ier am bient Insert Ambiental Conditions conditions line for the washing brand and treatment visibility of the grade and visual reference and etc 8 3 Creation of Reports in PDF format For all the reports created EL Page setup amp Print g Export to zoom Export report to PDF by ControLab the Software the possibility to Temporary folder for PDF files creation export the report to a file in the PDF format This file can then be sent by email PDF file viewer optional Open POF file after creation with the following program for example PDF file identification Folder CAPDF For this the user just has to use the button Create PDF in the tool bar that appears during the preview of the reports The user can then before creating the PDF configure the destination PATH as well as personalize the name of the file to be created EGITRON Page 40 ControLab Quality Control Software for Cork Products User Manual The user should notice in the top pane of the window the existence of a field for the definition of a temporarily folder for the files creation This folder by default CAPDFY must permit write and read operations to the Windows login from whi
42. h of the available tests in ControLab depending on the quantity of products defined in reports identification This attribution is realized by intervals This means that whenever the quantity of products for the report is between a lower and higher value defined in the sampling table ControLab will attribute the value defined in the corresponding register for each of the defined tests The choice of the sampling table that must be used for each report depends on the product and on the client group and must be defined on the table Association of Clients Suppliers to AQLs and Sampling Tables described in the following paragraph 1 EGITRON Page 17 The sampling tables permit to define sampling quantities by default It is though possible to individually correct these quantities by report and test ControLab Quality Control Software for Cork Products User Manual e Association of Clients Suppliers to AQLs and Sampling Tables It is through this table that the ControLab user can configure for each combination Client Group Product if ControLab must use AQLs by defect or admissible Table of Clients Association to AQL s Search for Group and Product Natural Identification Tests Configuration percents out of tolerances In this table it is also possible to associate to each combination the AQLs and limit percents that must
43. he various tables needed for the best use of ControLab Manage configure and print quality reports Configure and register tests Manage filter and control the information archived in the reports Use the modules included in ControLab Statistical Analysis Technical Files Calibrations Pending Tasks and Orders This Manual is composed by ControLab User Manual this document It provides a general perspective of the Software its features and a brief description of its use Installation annex This Annex describes in details all the installation process of the ControLab Software and of its Microsoft SQL Server 2005 database Specific Manuals of Tests Annexes that describe in details each of the tests that the user can realize in the creation of a quality control report Modules and Other Annexes Annexes for the modules of the Software and specific features that justify a more detailed description than the one that can be found in the user manual An installation CD of EGITRON ControLab for PC is provided with this user manual EGITRON Page 3 ControLab Quality Control Software for Cork Products User Manual Messages The messages are used in this manual to call the reader attention about important information This type of message is identified as shown below Take care A warning advice informs that the incorrect use of the Software or the non following of instructions may have severe consequences
44. id Leaking respective test Depending on this configuration ze ControLab will accept or reject each of the tests from the moment that they are finished The result of the test itself will be updated according to the following rules e fthere is a rejected test Conditional Report e there are not any rejected tests and at least one test in process Report In Process e lfallthetests are approved Report Approved GITRON Page 34 ControLab Quality Control Software for Cork Products User Manual The automatic atribution of a result for each of the tests and m reports depends on the selection of the field auto lt present in the different windows closed to the identification of the result of the test itself It the field is not selected the atribution of the result is not automatic any more Note that manually changing the status of the result the field auto is not selected any more Besides the status In process Conditional Approved and Rejected there is also a non exclusive status of Ex conditional automatically activated but the user may edit it whenever the result switches from Conditional to another status in the reports status window it is possible to filter the Ex Conditional reports An useful feature is the possibility to create reports with the same name but with different categories The category of the lot correspon
45. idual values the ControLab users are identified as Pemisinto delete eats FZI Statisical anabsis module Calibrations module Technical files module well as the operators in the laboratory Database maintenance operations Associate Tests and Reports to t rt t O Configuration of accesses m bl f h d f h O Edition of accepted and rejected reports res po n 5 or re po 5 or e Edition of cond and in process reports Edition of reports status Edition of data from tables used in reports A iens deg js i Permission to delete reports tatistical analysis module tests th at are bei ng created Calibrations module Technical files module Orders module Edit Delete Besides the identification of the users the software permits to define from the page Accesses of this window the configurations of access for each of them Regarding the Permissions of Access the following can be defined by user e Database maintenance operations e Configuration of accesses e Edition of accepted and rejected reports e Edition of conditional and in process reports e Edition of data from tables used in reports e Permission to delete reports e Associate Tests and Reports to other users e Edition of Technical Specifications e Edition of reports status e Edit delete individual values e Statistical Analysis Module e Calibrations Module EGI
46. ivate Inactivate the automatic warnings by email e Changes of the reports status that will origin a warning report approved rejected process and conditional e Language of the email to be created e Send an email for a list of predefined email addresses e Also send for the Client and or Supplier when this option is not selected the Software considers the address respective to the field email in the table of Clients Suppliers Regarding the feature of sending emails from ControLab and because of its independency to third tools for example Microsoft Outlook it is necessary to fill the relative to the SMTP Server port and eventual authentication Emails Configuration Emails Configuration SMTP Server SMTP Server Port Password Do From Address EGITRON Page 19 ControLab Quality Control Software for Cork Products User Manual e Brands Pictures Brands Pictures Search EBITRUM Identification List by Entity Identification and Configuration Name GITRON Picture Type File Folder D Engenharia Trabalhos ADPMlogosy File name and Extension oom Stretch Association to Clients and Suppliers CimSupir O EGITRON ControLab permits the administration and the inclusion the printed reports of the brands pictures The registry of the brands pictures is done from the specific table for this objective In
47. jective of the integration module of ControLab with EGITRON SPC Pro is to permit the importation of values that have been acquired and introduced in this system during the production process and normally associated to Control Cards into EGITRON ControLab associating them to the final report of the product before its expedition Quality Control Report This importation is peculiarly pertinent and useful for characteristics that are not changed since the control by the operator and the expedition avoiding this way a new control that would result in reality in the information redundancy and consequent loss of time The module permits the importation of values for the following tests of ControLab Dimensions Moisture Weight Density and Torsion The user should read the specific manual for this module in order to get more detailed information 10 4 Module of Tasks and Pending Test The module of Tasks and Pending List of Tasks and Pending Tests Tests is a module totally integrated in atc setween 2008030 ana 20080750 Order By C Report Number C Main Responsible ControLab and depends on the reports e E and created tests The main objective of this module IS to Test Absorption in Bottle Responsible z control at any time from the window of nr oro Dae 2090730 Dimensions and Weight the module or from the respecti
48. led information about the installation and maintenance of the Software the reader should consult the specific document produced by EGITRON Nevertheless in order to guarantee the correct use of the Software in Terminal Service some attention must be paid to the following configurations e The server needs as OS Windows Server 2003 or higher in order to permit the local RS 232 ports to be used e Activation of the Terminal Server use in the window of General Parameters Setup General Parameters Setup General 1 General 11 Tests Type of use Setup Software to be run and installed in local computers Software to be run and installed in local computers Terminal Service Selection of the workstation in the Login window e Administrate and configure the workstations creating a register for each PC from which a connection may be opened to the server numerous configurations namely the physical configurations of the acquisition devices are created by Workstation Workstations Equipments setup Workstation VIRTUALXP 59751 InterLab Aqua Boy Digital Scale Torsiometer JAV Extralab ParkerLab Mecmesin MLER Database BarCode Printer e In the Login window select the workstation Workstation corresponding to the PC from which the connection is IE being done Regarding the configuration workstations the user must pay attention to these points o It is possible to define by user a Defaul
49. nted Tests do add Graphics to add Report Identification Configuration Notes Available Options Selected Options Include Internal Notes Density Dimensions Extraction Moisture SPMESGC M5 Treatment Introduced Notes Locked Change in Reports English Portuguese Test Hotes Portuguese Before starting the printing the user may besides selecting the required type of report configure the main characteristics of these reports as e The required language for the report EGITRON Page 39 ControLab Quality Control Software for Cork Products User Manual e The presentation or not of the limits and deviations in the report e The tests to add to the report e The graphics to show e The header to use e The insertion or not of the logo of the company in the header of the report e The inclusion of the internal notes besides the notes for the client e The insertion or not of the digital signature of the user responsible for the report In the page Report Tests do add Graphics to add Report identification Configuration Repart Identification Configuration Identification Clienti Supplier Identification Name Code Configuration all the Insert Grade and Reference Name information relative to the Insert Client Supplier Address identification of the report Ins
50. nts Suppliers This table permits to register all the clients and suppliers that may be associated to quality reports EGITRON Page 10 ControLab Quality Control Software for Cork Products User Manual Clients Suppliers Individual Register Name EGITRON Code EGITRON Ciient Supplier Group Contact fm Pre Function Po Address Aua Central da Vergada 1290 Ciy County PORTUGAL Postal Code 4535 166 Phone Number Number Emai Reports sent via Email POF Formal Language by Default for Mates Reports Printin Portuguese 7 Edt New Delete X Record 14 Beyond the identification fields that must be filled Name code group and classification as client supplier or both it is possible to introduce all a set of information fields associated to the clientisupplier We underline the importance of the configuration of the following fields due to their connection to other features of the Software Email This information maybe used by the Software depending on the activation of the feature of the preparation of emails to the client and or supplier associated to the report e Reports sent via When the field is filled the information appears in the IE Preview used as a reminder regarding the way the report is sent Sent by default via E mail PDF Format inti C ne configuration window for the printing of reports It may be to the client Re
51. ough the menu Tables The others are accessible through the menu Setup Responsibles Analysis References The required conditions for a correct and efficient configuration of the Products Software can be resumed in the following 2 points Tests Sampling Tables 4QLs EGITRON Page 7 ControLab Quality Control Software for Cork Products User Manual e Respect of the logical sequence for the configuration e Understanding of the information contained in the most important configuration tables In the next chapters this manual will present each of these points While starting to fill the configuration tables the user will have to worry about guarantying that there is a logic sequence that permits him not to go back various times to the same windows and that guarantees him that he won t have to stop the configuration of a table because anothe was not configured yet r one This way the logical sequence suggested for the correct configuration of ControLab is as follows Table of Responsible Users Client Groups Table of Countries Y Table of Clients Suppliers Y General Tables about Products Sizes Grades Washings Treatments Defects Table of Products Table of Sample Pattern Table of References Technical Specifications General Tables about Tests Sensorial Aromas Norms and Tests Methods Categories Sampling Tables AQLs Table Association of Clients S
52. port nat Printed EGITRON Page 11 ControLab Quality Control Software for Cork Products User Manual e Address and Country Depending on the printing configuration this information may appear in the printed reports e Language by Default for Reports Printing The correct configuration of this field eases the choice of the language required for each of the reports since it will be automatically done by the Software it is a choice by default that may however corrected by the user This feature is particularly interesting for laboratories that print reports in different languages for clients of different countries e Table of Products Products Search Products Natural Configuration I Configuration Configuration uy Languages Tests by Llients Suppliers Groups Produet Dimensional 1st Characternstic Mame Length Length Read two diameters The Product i not a BarTop 1st Characteristic Abbreviation Do not read tops thickness Do nat read Disc diameter Do not read Disco diameter Dimensional BarTop Product without BarT op Moisture Moisture 1 Name Mosue2Name O Weight and Density In test window Show weight and density Inthe reports Show weight Show density Note Do nat forget to fill the traduction Fields in the tab page Languages New Delete X Record TA In a flexible way ControLab permits to realize the qu
53. pproved Aprovado _ JAppmv Aprobado Genehmit foro JPJ Heiected _ Heiiado Reite Rechazado Nicht Angenommen ifulato JED Conditional Condicional Condiiomel Eednt Note The abbreviation the result is used in the list of the reports status Edit X 7 15 Histogram amp There is in the header of the reports main window a button to open the window for the visualisation of histograms In this Histogram Density ae Report Histogram Selection window the user may select the category 5 S ample 12 of Controled Products 12 histogram for the required characteristic and test The user may also print the required histogram Interval Values in Kg m3 8 Reports Printinc The window for the printing of reports can be opened from the Menu Reports Reports Printing or still from the button including the picture of a printer in the top pane of the main window of the reports Note the possibility to automatically General Parameters Setup General I General II Tests fill the field of notes for the printed Notes added tor the Printed Reports English Portuguese French Spanish German Italian EGITRON Page 38 ControLab Quality Control Software for Cork Products User Manual reports and translations in the General Parameters Setup window 8 1 Type
54. r Ol Select Inselect All Ol Select Inselect All Select Inselect All 5 O Select ngelect All The module of Statistical Analysis permits the treatment and visualisation of the values saved in the database quality reports with filter options depending on different parameters as the product the size the category the entity the visual grade or still the treatment there is a list for each of these parameters from which the user may choose the elements than can be interesting for analysis Besides these filter parameters there are still other filters that must be considered in the analysis as the possibility to filter the reports establishing filters for the name of the reports or still between two dates or still defining the status of these reports GITRON Page 42 ControLab Quality Control Software for Cork Products User Manual In the first page of the tab of the window it is possible to choose the filters for the information that must be considered in the analysis Statistical Analysis Analysis Test of Moisture In this page the user must define E Filters Statistics the criteria for analysis X axis for ses the graphic In order to see the information relative to the selected filters the user must select the page Printing Graphic M Statistics This way the dszoou e002 955000 600 958000 600 459000 600 5 00 600
55. r this the user must use Export to MS Excel Configurations the menu Setup Export to Destination forder for exported Ms Excel files MS Excel Configurations 2 and introduce the PATH in the Ms Excel Location Folder that contains the file Excel exe field relative to the localization C Program Files Microsoft Office Office 0s 4 Note when the Ms Excel location is correctly filled the file is automatically opened after being exported of created reports ER EGITRON Page 30 ControLab Quality Control Software for Cork Products User Manual e Feature to colour in red the values out of limits In the window of some tests there is a button that permits to colour in red the values out of tolerances in the grid of individual values This feature is only available for windows and not for printed reporis 7 4 Automatic Acquisition EGITRON ControLab permits the automatic acquisition of values from different acquisition equipments for the main number of tests available for each report A description of the automatic acquisition for the different available equipments is given in the specific user manuals for each test The Software permits the automatic acquisition from the following equipments e MedCork ExtraLab e ExtraLab Champ e ExtraLab Plus e MecMesin Portable Extral ab e TorsiLab Torsiometer 2000 JAV Machine ParkerLab e Calliper Digital Indi
56. ration of the general parameters of ControLab the Software will keep the history of the main changes applied to the report and that occur after this Each register of change includes the identification of the change the date hour and the identification of the user that has made it The changes controlled include the changes on the reports identification fields as well as the status of tests To guarantee the consistence of the information from this list the fields included can t be edited List of Corrections on Finished Report Report 201070001 Category Sample dentification Report Status 7 12 Traceabili The window of traceability permits to create associations between the reports indicating that a specific report lot has originated or has been created by various reports This feature permits to show by the use of two trees one for descendant and the other for ascendency the origin of a specific report The refereed association trees permit to show until five levels of hierarchy Report History Report tt Category Entry gt Exit Descending Reports 2010 0001 Sample 2010 0001 Sample 2010 0002 Sample E E 2010 0005 Sample 7 a ae 2010 0004 Sample so 2010 0005 Sample 2010 0005 Sample Exit lt Entry Ascending This repart has associations Filters Between 2010 11 15 In Process and 2010 12 15 Approved and Rejected
57. ries Lid he Reports 200970062 In Process Category S ample Approved Tests ES Conditional Density 2009 07 29 NP28 Dimensions 2009 07 29 Extraction 2009 07 29 Expedition e tis also possible trough the list of tests associated to the report double clicking in the field Test In the third page of the same tab the information relative to the chosen test will be opened Using the horizontal scrollbar from this window it is possible to consult the internal notes for each test of the report gt gt Sample Pi 12 0 Pi 120 Approved 10 1 E 2009 07 29 2009 07 29 2009 07 29 2009 07 29 2009 07 29 S3 6012 amp ET To apen a test double click in its respective name field select Tests GITRON Page 26 ControLab Quality Control Software for Cork Products User Manual As already indicated In this Selection of the Tests for the Report Perot TS ET manual the tests that are d Selection of the tests to realize for the report associated by defau It to a Available Tests m Selected Tests Absorption E Density specific report when this one is aeos boxe nica Bartop Dimensions and Weight Moisture created are the tests defined in S Boiling Water Il the configuration window Of 2222
58. s of Report There are three types of reports each of them can have different configurations with more or less information and more or less tests 1 Descriptive Report 2 Resume Report 3 Results Reports The descriptive report is a report that presents the statistical data obtained for each of the tests realized and it is the test that contains more information about the tests The resume report has the same objectives as the descriptive report but shows the data in less quantity of information in a resume table permitting to get a report using less space in paper Contrarily to the other two types of reports the results reports do not have as objective to show the statistical and resume values of all the tests included in the report but to show the set of all the individual values obtained in a specific test This way there is a result report for each of the tests with individual values 8 2 Possible Configuration Report Printing Settings Report 201070001 Filters Date between 2009 05 08 Expedition X Language Portuguese and 2010 06 07 Inspection Report Type Printing Options OM Preview Descriptive Report Insert Logotype from Header Header3 m EcL i E 2 Resume Report LJ Show Limits and dev Descriptive Resume and Res Results Report for the Test af Sent by default via Absorption Email POF Format Barcode Label s Insert scanned signature Report not Pri
59. s to sequentially create these reports The list is kept in memory allowing the process to be repeated at any time List of Reports to Create Report Category Product Date Ciuantity Client Supplier sample Natural 19 07 2011 45 4 24 150 000 EGITRON Container Natural 19 07 2011 49 x 24 450 000 EGITRON 19 07 2011 O campo Relat rio N dever ficar em branco caso se pretenda manter a atribui o autom tica do nome sequencial aos relat rios assim criados 7 8 Acceptance Rejection of Tests and Reports from AQLs or tolerated For any of the reports it is possible to define if the acceptance or the rejection for each of its test is realized from AQLs or admissible percentages The configuration by default is defined as already referred in the window of association of clients to AQLs This configuration may nevertheless be realized report by report from the button AQLs in the right top pane of the main window of reports The button permits to open a window AQLs that identifies for each of the tests of Report 2009 0002 Category Sample the respective report if the user wants TC EM a ae Treatmen Absorption in Bottle Agglomerate D ensi to use AQLs or tolerable percentages m v Torsion O TCA Quantification Dust Quantification In order to accept or reject the Oxidants Compression Insertion Residual Quantification Moisture AL Recovery Liqu
60. sible to see in the grid of individual values of the different tests the registers that correspond to no conformities using the specific button for this 1 feature that will permit to make the no conform values to Individual values Notes LL o T oe appear with a red background and a yellow foreground A text with the identification of the indexes of no conformities will also appear Ho Conforms 2 4 e Fields of Date Method Sample Result Responsible e Comparisons of different categories For reports having the same code but different category the results obtained for 11 the same tests may be directly compared through the button of comparison that will open a window with the various results obtained by category Notes For each test as well as for each report it is possible to introduce mes internal notes well as notes for Portuguese printing for each of the different French languages The notes shown in the test Spanish window are notes for internal use German To introduce or to access the notes for printing on different GITRON Page 29 ControLab Quality Control Software for Cork Products User Manual languages the user will have to double click on the field Internal Notes e Additional Information for the Reports Identification For each report besides the notes that the user may in
61. t workstation fg default workstation from the responsible table o If in the table of workstations there is a register with the same name as the local PC this one is selected by default by the Software EGITRON Page 21 ControLab Quality Control Software for Cork Products User Manual 6 5 Configuration of the Acquisition Equipment Some of the physical tests for example EGITRON ControLab File Tables Setup Database Reports Statistics Modules About f Quit General Parameters Setup Dimensions Moisture and Density between Error Headers EE Documents Codes others permit the automatic values acquisition Export to MS Excel Configurations trough InterLab This way while clicking in the InterLab Aqua Boy DMX Scale Torsiometer JAY BarCode Printer Extrabab MLER acquisition button and if there is no error a Acquisition Mode By Default for Dimensions Automatic window for values acquisition for the respective anera in enl Boy DMX ESTE test is opened If an error window appears the user should check the correct connection to Adjust Equations Seviat Post o 0 0000000000000 3 0 0000000000000 3 Settings 9600 N 8 1 0 0000000000000 v3 x 03 0 000000000
62. the Software from different PCs For this it is necessary to acquire the required user licenses e Reports and Graphics Printing with the capacity to configure different aspecis as for example the language and the tests to include e Integration of automatic acquisition equipments as the MedCork the InterLab the TorsiLab digital scales hygrometers Mitutoyo equipments etc 1 lt of ControLab Features The ControLab has a set of characteristics which understanding by the user permit a better use of the Software Below we describe some of these main characteristics e Based on tables The base structure for the database is a relational database this is the fact that makes ControLab to have its main characteristics and advantages security data coherence simplicity One of the obvious consequences of this base for the Software is that it assents on a set of table of registers The contents of these tables correspond to the registers needed for the system good behavior We will describe in another section of this document the main tables essential to the correct software configuration e Common Buttons Edit New Delete Close and Confirm These buttons are common to the main number of ControLab windows The button Edit is for data changes E X security By default the presented data is protected and can t be changed The button Edit will have to be selected for the user to be
63. tion of Dates In the fields for dates in ControLab the user will only dose be able to introduce dates in the format defined in ER Novembro de 2005 Dezembro de 2005 the Regional Settings of the OS Windows seg ter qua qui sex s b dom ter qua qui sex s b dom 44151 1 2 3 4 5 1 2 3 4 1 45 7 8 8 10 11 12 13 5 6 7 8 9 10 11 accessible through the Windows Control Panel TO gli is 1920 Soliz 13 14 15 18 17 18 qr 21 22 23 24 25 26 27 20 21 22 23 24 25 ease the insertion of dates and to reduce the risk of gt 25 28 27 28 28 30 1 112 3 4 5 7 8 errors there is the possibility to open a calendar 3hoje 2005 11 17 double clicking in the field In this window you can select the year the month and the day To validate the date and to insert it in the corresponding field you must Double click in the desired date e Required fields bold While introducing registers some of the fields may be ReportDate 2005 1116 Treatment 7 required contrarily to others Washing The required fields are normally presented in Bold Beri EN amter 0 T Finishing Type Size 44 27 mm Quantity GITRON Page 6 ControLab Quality Control Software for Cork Products User Manual e Tool Tips One characteristic common to the main part of the Language by Default for Reports Printin buttons lists fields etc is the existence of a
64. troduce by test and the notes relative to the final result of a report internal and for printing it is also possible to introduce additional notes that will be printed in the grid identification of the report Double clicking in this field the Software opens a window for the introduction of translations Note that whenever this field is filled it will then appear in printed reports e Repetition of Tests At any time the user may repeat any test associated to the report The insertion or elimination of tests is possible trough the use of the buttons New Test and Delete Test accessible in each test E Ll The navigation between the tests of the same report must be realized through the selection list created for this effect and normally Test 1 1 located in the left hand superior corner of the test window There is also a button that permits if there is more than Test TITO one test to change the position of the current test to make 12 it become the last highest index This feature is particularly usefull since the tests considered for printing and for the Statistical analysis module of ControLab are always the last created for each of the reports highest index e Exportation for Excel The exportation of the tests individual values for excel is possible through the use of the button existing in the window of each of the tesis The files will be copied to a folder previously defined Fo
65. uppliers to AQLs and Sampling Tables GITRON Page 8 ControLab Quality Control Software for Cork Products User Manual More detailed information about the configuration tables in this sequence can be obtained through the reading of the next paragraph of the manual The sequence suggested here is a sequence for the initial configuration At any time the user 4 may proceed to the maintenance of the configuration tables changing or adding registers since these operations are in agree with the security and coherence rules for the data guaranteed by the relational database 6 2 Description of some Configuration Table This chapter will describe the more important configuration tables required for a good behavior of the ControLab as well as the tables that may be seen as more difficult to understand for the user e Table of Responsible Users Search Responsble A Search Responsible Selection Curent Ex Responsibles All Identification List The table of responsible users is very asswor Access Fermissions ae Armindo Oliveira Database maintenance operations a Tests and Reports to f h bl h Configuration of accesses ot ee IM portant 5 nce It IS rom t IS ta e 1 Edition of accepted and rejected reports Edition of technical specifications Edition of cond and in process reports Edition of reports status Edition of data from tables used in reports Edit delete indiv
66. ve Report PALIN PIIK Date 2009 07 30 reports that can be printed the pending e vota Responsible tasks associated to each of the rp of 2 responsible users in the laboratory The attribution of tasks is realized by test Each responsible user can be associated to one or various tests Whenever a report is opened the Software associates to each of the tests the respective responsible user It is possible to manually correct the automatic association of responsible users to each test EGITRON Page 44 ControLab Quality Control Software for Cork Products User Manual 10 5 Module of Calibration The module of calibrations Calibration Registers OOE Equipments Search LABO1 M Report L Ei Individual File permits the register of each of equipments existing in the Equipment Identification Notes Calibrations laboratory of the company as Equipment Calpper 4801 Measure Unity mm well as the management of o0 Serial 123 Scale Acquisition D ate 2009 07 30 Resolution Initial Date of Utilization 2009 07 30 Utilization Place eventual calibrations permitting Supplier Calibration the printing of different reports Name EGITRON Vergada PORTUGAL Equipment that may have calibrations as th
67. w reports e Various parameters relative to the reports printing e Configuration of the name for some fields present in the page of identification of reports e Automatic attribution of the responsible for the creation of the report e Specific configurations regarding tests as for example the visual test SPME GC MS and etc e Eventual use of the Software in Terminal Service the reader should consult the specific paragraph from this document EGITRON Page 18 ControLab Quality Control Software for Cork Products User Manual e Window for the configuration of Tests Methods In this window the user may define by product the set of methods and norms used in the realization of tests These values will be passed by default to the new created reports with the possibility for the user to manually change the values e Window for the configuration of Tests Names This window permits the configuration of the names of the tests and respective translations in the different languages e Window for the configuration of decimal places It permits the user to configure for some tests the number of decimal places e Window for the configuration of Warnings by Email The ControLab has a feature for the automatic creation of warnings by emails that are initiated when a report changes of status In the window for the configuration of warnings by email it is possible to define different configurations related to this feature e Act

User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents