BIS.Net Report Generator – User Manual
Contents
1. SELECT TAB displays the main screen which enables you to generate your reports and specify filters Buttons used to generate the reports are displayed on the left hand side e The REPORT TAB displays the report which you have generated Once the report is generated you will automatically be directed to this TAB e The RAW DATA TAB displays the drilled down data via the Exception report e The CHART TAB displays a Machine Interface look a like chart generated from drilling down into the underlying exception via the Exception report After drilling down into the underlying exception via the Exception report you will need to click on the CHART tab to view the chart Please Note 1 The BIS Net launch pad www ccabisnet com au may be set up as a favourite To set up as a favourite load the launch pad and then click on the Add to Favourites link located at the top left hand side of the screen 5 Page BIS Net Data Editor Administrator Manual ENa Ao KO Filtering data for reporting When generating any of the reports a filter box will be available enabling you to filter data based on any criteria Below is an example of the filter box Columm lt The structure of the filter box is as follows Column Lists all of the fields in the selected table Enables you to filter data that is equal to the value entered under this column for the corresponding field2. gt Enables you to filter data that is equal to or greater than the value entered under this column for the corresponding field lt Enables you to filter data that is equal to or less than the value entered under this column for the corresponding field 6 Page BIS Net Data Editor Administrator Manual ENa Ao ke Below is an example of filters assigned ALTERNATIVELY instead of entering values directly into the filter box you may select your filtering criteria from choice lists To do this click on the cell where you will be entering a filter and press the Populate Choice Lists button located directly underneath the TABS The cell in which you have selected will display a choice list listing all of the values for the selected field as shown over the page 7 Page BIS Net Data Editor Administrator Manual Neen Ao KO Select Report Raw Data Char Populate Choice Lists Press the Populate Choice Lists button to display a choice list in the selected cell General Stats Report Monthly Stats Report W amp M Report Exception Report Appletini 3 5 Appletiser Appletiser RTD Bisleri Chinatta Canadian Club and Cola 4 6 Canadian Club and Cola 5 Canadian Club and Dry 4 6 Canadian Club and Ginger Br CF Coke CF Diet Coke Coca Cola Coke Lime Coke Zero Deep Spring All Natural Lemi Deep Spring All Natural Man Deep Spring All Natural Oran Deep Spring All Natural Oran Deep Spring All Natur
3. no nested tree view menus to locate reports gt Previously Brix and CO2 had to be reported on two different tabular reports Now Brix and CO2 reports are combined in the one tabular report thus reducing the number of configurations gt Previously individual reports were created for each site Now only one report per report type has been created for ALL sites Filters are now used to generate reports for your site and line gt Greater flexibility when filtering data for reports Previously only a fixed number of filters were available Now all possible filters are available All reports have been pre configured and are easily accessible at a click of a button Reports which have been configured are General Statistics Reports Weekly Statistics reports Monthly Statistics Reports W amp M Statistics Reports Exception Reports Raw Data reports for Brix amp CO2 Raw Data Reports for Volume Se ee ee oe YY Specifications Report For NZ users there are additional reports which have been configured Generation of these reports will be the same as generating the above reports The remainder of this user manual will now cover the following e Launching the BIS Net Report Generator e Filtering data for reporting e Generating the General Statistics Report e Generating the Weekly Statistics Report e Generating the Monthly Statistics Report 3 Page BIS Net Data Editor Administrator Manual ENa Ao KO e
4. BIS Net Report Generator User Manual BIS Net Data Editor Administrator Manual Neen Ao Ko Table of Contents 6 g a ee ee re ee 3 Launching the BIS Net Report Generator ccccecceseesseeeeeseesenseesees 4 Filtering data for reporting ccccecceccescesseeseeceescuseeseseeseeeseeseusesens 6 Generating the General Statistics Report Brix amp CO2 assecc 8 Generating the Weekly Statistics Report Brix amp CO2 eessscscecs 9 Generating the Monthly Statistics Report Brix amp CO2 assecc 10 Generating the W amp M Report Fill VolUMe ccc ecc cess esse eeees 11 Generating the Brix and CO2 Raw Data Report cccceceeseeseeeees 12 Generating the Fill Volume Raw Data Report cccceeceeceeeeeeeees 13 Generating the Specifications Report cccceccesseseeeeeeseeseeseeseeeees 14 Generating the Exception Report Brix amp CO2 oo cece eee eeee es 15 EXPONE tO EX CON erare EAE EA RTEA A AE AARE 18 2 Page Age LET gt Sram ee oa ae ieee Manual The BIS Net Report Generator is an on line web application available to National QA and all BIS Net users to generate statistically based reports on Brix CO2 and Fill Volume The BIS Net Report Generator is the new upgrade from BIS Net Web Turbo What s New gt There is no more Tree View to generate reports from Generation of reports is direct with
5. Drill Into button located at the top right hand side of the screen underneath the CCA logo COCA COLA AMATIL Export to Excel A Drill Into a 3 You will automatically be directed to the Raw Data TAB displaying the data representing the highlighted exception To view the chart click on the Chart TAB 5 The appearance of the chart will be exactly the same as the chart displayed on the Machine Interface The chart will display the following details gt The individual measurements gt The specifications regions gt The Filler stop line to show users when the Filler had stopped running 17 Page BIS Net Data Editor Administrator Manual ENa Ao KO Line 312 Cans Lift Record Line 312 Cans Lift Exporting to Excel After generating any of the selected reports the data can be exported into Microsoft Excel for further analysis To export data into excel please follow these instructions 1 Generate any desired report 2 After the report has been generated click on the Export to Excel button located at the top right hand side of the screen underneath the CCA logo COCA COLA AMATIL E Drill Into 18 Page BIS Net Data Editor Administrator Manual ENa ia yA KO 3 A message box will be displayed asking whether you want to open the data in Excel or save the data to an Excel worksheet If you press Open then Excel will open with the data pasted If you pre
6. Generating the W amp M Statistics Report e Generating the Brix and CO2 Raw Data Report e Generating the Fill Volume Raw Data Report e Generating the Exception Report e Generating the Specifications Report e Exporting the reports to Microsoft Excel Launching the BIS Net Report Generator 1 Load your Internet Explorer In the address bar type www ccabisnet com au 3 The following launch pad will be displayed enabling you to launch the different BIS Net web applications and documentation gt CCA Launcher Windows Internet Explorer Go e F 4 x fere o awe CCA Launcher A D eh Pap gt GQ tods E COCA COLA AMATIL Zz zZ gz Z z TPT Bip I menet Protected Moda On His start 2 em A CA Launcher windo ETEN 4 Click onthe Reports_Auv button for Australia and Reports_NZ for New Zealand CCA COCA COLA AMATIL ditor _Au Editor_Nz Reports Au Reports Nz 4 Page BIS Net Data Editor Administrator Manual ENa Ao ne 5 The BIS Net Report generator will be displayed GO E revstiatestneresi Elf r fie sex WB CCA Report Generator Select Report RawData Chart COCA COLA AMATIL e a a a se eee ees od Sed 4 6m cca Report Generato The layout of the BIS Net Report Generator is as follows The BIS Net Report Generator is divided into TABS These TABS are Select Report Raw Data and Chart e The
7. Report button which is located underneath the RED Specifications button 5 Before the report commences a message box will be displayed asking for you to please wait until the TAB changes Press the OK button to continue 6 After the Monthly Statistics Report has been generated you will automatically be directed to the Report TAB Generating the W amp M Report Fill Volume The W amp M Statistics Report is used to generate fill volume reports reporting on the Australian Weights and Measures statistics To generate the W amp M Statistics Report please follow these instructions 1 On the left hand side of the reporting module click the W amp M Report button 11 Page BIS Net Data Editor Administrator Manual Neena c Ao KO Select Report Raw Data Chart General Stats Report Weekly Stats Report Monthly Stats Report oo W amp M Report E Exception Report Raw Data for Brix and Carb Raw Data for Volume Specifications A filter box will be displayed 3 Specify filters in the filter box Please refer to the Filtering Data for reporting section on page 2 for further details on using the filter box Press the View Report button which is located underneath the RED Specifications button 5 Before the report commences a message box will be displayed asking for you to please wait until the TAB changes Press the OK button to continue 6 Af
8. al Oran Deep Spring All Natural Oran Deep Spring All Natural Oran Deep Spring All Natural Pine Deep Spring Lemon Deep Spring Lemon Lime Or Deep Spring Natural Deep Spring Orange amp Passi Diet Coke Diet Coke Lemon Diet Coke Lime Diet Coke Vanilla Raw Data for Brix and Carb Raw Data for Volume Please Note 1 When displaying choice lists on the filter box if filters have already been assigned for other fields then after pressing the Populate Choice Lists button the values listed in the selected choice list will be based on the filters already assigned For example if you have specified a date and wish to display a choice list for the Flavour field the flavours which will be displayed in the choice list will be based on the date which you have specified earlier 2 Itis highly recommended to filter data for reporting rather than reporting on the entire data to obtain the best performance Generating the General Statistics Report Brix amp C02 The General Statistics Report is used to calculate summary capability statistics for each line flavour and packaging group based on the filters provided 8 Page BIS Net Data Editor Administrator Manual Neen Ao KO To generate the General Statistics Report please follow these instructions 1 On the left hand side of the reporting module click the General Stats Report button Select Report Raw Data Chart General St
9. ats Report J Weekly Stats Report Monthly Stats Report Wahl Report Exception Report Raw Data for Brix and Carb Raw Data for volume specications 2 A filter box will be displayed Specify filters in the filter box Please refer to the Filtering Data for reporting section on page 2 for further details on using the filter box Press the View Report button which is located underneath the RED Specifications button 5 Before the report commences a message box will be displayed asking for you to please wait until the TAB changes Press the OK button to continue 6 After the General Statistics Report has been generated you will automatically be directed to the Report TAB Generating the Weekly Statistics Report Brix amp C02 The Weekly Statistics Report is used to calculate summary capability statistics for each week line flavour and packaging group based on the filters provided To generate the Weekly Statistics Report please follow these instructions 1 On the left hand side of the reporting module click the Weekly Stats Report button 9 Page BIS Net Data Editor Administrator Manual Neen Ao Ko Select Report Raw Data Chart Populate Choice Lists Colum General Stats Report aa pes i Weekly Stats Re po al p Monthly Stats Report W amp M Report Exception Report Raw Data for Brix and Carb Raw Data for Volume 2 A
10. filter box will be displayed Specify filters in the filter box Please refer to the Filtering Data for reporting section on page 2 for further details on using the filter box Press the View Report button which is located underneath the RED Specifications button 5 Before the report commences a message box will be displayed asking for you to please wait until the TAB changes Press the OK button to continue 6 After the Weekly Statistics Report has been generated you will automatically be directed to the Report TAB Generating the Monthly Statistics Report Brix amp C02 The Monthly Statistics Report is used to calculate summary capability statistics for each month line flavour and packaging group based on the filters provided To generate the Monthly Statistics Report please follow these instructions 1 On the left hand side of the reporting module click the Monthly Stats Report button 10 Page BIS Net Data Editor Administrator Manual ENa Ao O Select Report Raw Data Chart General Stats Report Weekly Stats Report re Monthly Stats Report l H e E W amp M Report Exception Report Raw Data for Brix and Carb Raw Data for Volume A filter box will be displayed 3 Specify filters in the filter box Please refer to the Filtering Data for reporting section on page 2 for further details on using the filter box Press the View
11. hart General Stats Report Weekly Stats Report Monthly Stats Report WeM Report Exception Report Raw Data for Brix and Carb Raw Data for Volume specifications 2 A filter box will be displayed Specify filters in the filter box Please refer to the Filtering Data for reporting section on page 2 for further details on using the filter box 4 Press the View Report button which is located underneath the RED Specifications button 5 Before the report commences a message box will be displayed asking for you to please wait until the TAB changes Press the OK button to continue 6 After the Exception Report has been generated you will automatically be directed to the Report TAB Drilling down into the underlying exception You may drill down into the underlying exception to either extract the data representing the exception or plot the chart To drill down into the exception please follow these instructions 1 Highlight the row which you would like to drill down into further by clicking on the SLATE BLUE record selector as shown over the page 16 Page BIS Net Data Editor Administrator Manual Neena Ao Ko Select Report RawData Chart S lt gt gt Line Flavour Packaging Brix Cp Brix E Brix NC Brien CO2Cp CO2 ae CO2 NC _CO2n i ra TE R ooo s OO eeno F G G a o sej e o meej 9 cas l CO aj a f 2 a 2 Click on the
12. ick the RED Specifications button 14 Page BIS Net Data Editor Administrator Manual ENa Ao O Select Report Raw Data Chart General Stats Report Weekly Stats Report Monthly Stats Report Wahl Report Exception Report Raw Data for Brix and Carb Raw Data for Volume SHecnicatians 2 A filter box will be displayed 3 Specify filters in the filter box and press the View Report button Please refer to the Filtering Data for reporting section on page 2 for further details on using the filter box 4 Before the report commences a message box will be displayed asking for you to please wait until the TAB changes Press the OK button to continue 5 After the Specifications Report has been generated you will automatically be directed to the Raw Data TAB Generating the Exception Report Brix amp C02 The Exception Report is used to highlight warnings or exceptions for each line flavour and packaging group based on the filters which have been applied Exceptions are reported for Cp Cok and Non Conformance and are colour coded The colour code is as follows GREEN GOOD YELLOW WARNING RED EXCEPTION To generate the Exception report please follow these instructions 1 On the left hand side of the reporting module click the Exception Report button 15 Page BIS Net Data Editor Administrator Manual Neena Ao O Select Report Raw Data C
13. ss Save then you will need to specify the name and location where the Excel file is to be saved 19 Page
14. t The Fill Volume Raw Data Report is used to display the individual measurements which are stored in the database based on the filters applied To generate the Fill Volume raw data report please follow these instructions 1 On the left hand side of the reporting module click the Raw Data for Volume button 13 Page BIS Net Data Editor Administrator Manual Neena Ao ke Select Report Raw Data Chart General Stats Report Weekly Stats Report Monthly Stats Report W amp M Report Exception Report Raw Data for Brix and Carb Raw Data for Volume LU spei Micatllans 2 A filter box will be displayed 3 Specify filters in the filter box Please refer to the Filtering Data for reporting section on page 2 for further details on using the filter box Press the View Report button which is located underneath the RED Specifications button 5 Before the report commences a message box will be displayed asking for you to please wait until the TAB changes Press the OK button to continue 6 After the Fill Volume Raw Data Report has been generated you will automatically be directed to the Report TAB Generating the Specifications Report The Specifications Report is used to generate a specifications report To generate the Specifications report please follow these instructions 1 On the left hand side of the reporting module cl
15. ter the W amp M Statistics Report has been generated you will automatically be directed to the Report TAB Generating the Brix and CO2 Raw Data Report The Brix and CO2 Raw Data Report is used to display the raw data results which are stored in the database based on the filters applied To generate the Brix and CO2 Raw Data Report please follow these instructions 1 On the left hand side of the reporting module click the Raw Data for Brix and Carb button 12 Page BIS Net Data Editor Administrator Manual Neena Ao Ko Select Report Raw Data Chart General Stats Report Weekly Stats Report Monthly Stats Report W amp M Report Exception Report en Raw Data for Brix and Carb Raw Data for Volume ll Specifications A filter box will be displayed 3 Specify filters in the filter box Please refer to the Filtering Data for reporting section on page 2 for further details on using the filter box Press the View Report button which is located underneath the RED Specifications button 5 Before the report commences a message box will be displayed asking for you to please wait until the TAB changes Press the OK button to continue 6 After the Brix and CO2 Raw Data Report has been generated you will automatically be directed to the Report TAB Please Note 1 Out of spec results will be coloured in RED Generating the Fill Volume Raw Data Repor
Download Pdf Manuals
Related Search