Renishaw CNC Reporter user's guide
Contents
1. gt gt ene A001 1 A001 2 B002 3 B002 4 A001 5 A001 6 B002 7 B002 8 Various 9 METERNE EET The header section is populated using data defined in the Initial Set Up Data panel and provides a summary of any failures found The body section is populated with colour coded inspection data Feature Names appear in bold blue font Toleranced Feature Attributes appear in bold red or bold green font depending on adherence to tolerance Untoleranced Feature Attributes and Process Information appear in non bold black font Renishaw CNC Reporter user s guide 23 Analyse data Capability Chart Select View Capability Chart from the Floating Window or Compile Capability Chart from the CNC Heporter Control Panel located on the Start tab The Capability Chart Data tab will become active and a graphical display showing the variation of actual measured values for a single feature across all inspected components is visible Source Demo TEXT Connection Paused Stop Data Collection ERE FEATURE BASED CAPABILITY CHART 4 Sample n Mms cw 01 Z TOP SURF T01 POSITION Z 0 0000 Average Dev n 0 1200 Span 0 0600 Max Value 0 0600 Min Value 0 0000 Mean 0 0638 Std Deviation Upper Specified Limit r Specified Limi r Waming Limi Lower Waming Limit 0 1000 Tool Filter Feature Part Number li Operation Sample ID Nominal Actual Deviation Upper2. 18 May 2012 Sample 11 Sample 12 a Il D The Overview tab shows actual measured data in colour coded data cells indicating adherence to tolerance This is the same information as displayed by the Overview tab in Renishaw CNC Reporter Renishaw CNC Reporter user s guide 37 Trend Analysis Chart tab Installations with Excel 2003 and Excel 2007 only o E 2 ai E o E o LI 3 o ki o Historical Deviation Trend Linear Deviation The Trend Analysis Chart provides a graphical representation of measured data for a single feature across multiple components Comparison Chart tab Installations with Excel 2010 only 0 0600 Measured Deviation of Filtered Features Feature zi Measure Sequence DEV 02 BORE 40 00 MM TO2 POSITION X DEV 02 BORE 40 00 MM TO2 POSITION Y 01 Z TOP SURF T01 POSITION Z 02 BORE 40 00MM T02 POSITION X 02 BORE 40 00MM T02 POSITION Y 02 BORE 40 00MM T02 SIZE 03 WEB 25 20MM T02 SIZE 3 Archive Query Mis B Comparison Chart 2 LH The Comparison Chart provides a graphical representation of measured data for one or more features across multiple components 38 Renishaw CNC Reporter user s guide Using Data Manager Select machine Select Get Machines from the Archive Query tab to display a list of t
3. Enable Auto Start Iv Initial CNC Reporter Template C Renishaw piciRenishaw CNC ReporteriCNCReporterTemplate xlt EB Enable Auto Save F Allow Nulls Blanks in Input Boxes Enable Disable Admin Options Enable Log File Output Enable Disable Output Options Increment Sample only Unprotect Sheet Password with COMPON EN TEND Change Protection Password Protect Unprotect all sheets Unprotect Sheets Protect Sheets Accept Changes Enable Auto Start When checked CNC Reporter will go straight into Collect Data REAL TIME mode when CNC Reporter is opened NOTE This option must be used in conjunction with the Lock Setup check box CNC Reporter Control Panel Start tab Enable AutoSave When checked CNC Reporter will auto save hourly Allow Nulls Blanks in Input Boxes When checked Input Box fields used for Custom Template information can remain empty If left unchecked and Input Box fields remain empty a prompt will be displayed until sufficient valid information is entered 28 Renishaw CNC Reporter user s guide Enable Log File Output When checked CNC Reporter will log all events to a file in the installation directory Increment Sample only with COMPONENTEND When checked the Sample ID Number will only increment when the New Part Inspection Sheet Trigger Word COMPONENTEND or similar is seen at the end of a report If left unchecked the Sample ID Number will remain as set in the nitial Set
4. Disable Admin Options Output 3 2 f Multiple Instance Manager Step 2 of 2 Enable Disable Output Options SS EE C TOP LEFT Select the desired Unprotect Sheet Password risk ee ti on for THIS session of Change Protection Password CNC Reporter Protect Unprotect all sheets Unprotect Sheets Protect Sheets The Admin tab displays the current license status and allows background functionality as described in the Advanced features section to be set The CNC Reporter Multiple Instance Position panel provides the option to run four instances of CNC Reporter concurrently Select Set Instance Position and use the Multiple Instance Manager to position the windows NOTE In order to use the multiple instance function a minimum screen resolution of 1920 x 1080 is required If this minimum resolution is not met the following dialog will be displayed FE Multiple Instance Positions were designed for use with a video mode of at least 1920 X 1080 The current video mode is 1680 X 1050 Please adjust your display OK 16 Renishaw CNC Reporter user s guide Templates tab The Templates tab allows users to vary the templates used for Probing Inspection Reports depending on the part number of the inspected component NOTE To access the Templates tab select Custom Templates OFF in the nitial Set Up Data panel within the Start tab This setting will then toggle to Custom Templates ON and t
5. Formulas Trusted Locations Disable all macros without notification Proofing Protecting your privacy Trusted Documents Disable all macros with notification a Save Save Microsoft cares about your privacy For more information about how Microsoft Excel helps to protect your privacy please Add ins Disable all macros except digitally signed macros ane See per rure n Enable all macros not recommended potentially dangerous code can run CH Save As SC Show the Microsoft Excel privacy statement OS Advanced Office com privacy statement Macro Settings Penelope Baran Selling 2 Feks Customer Experience Improvement Program Ke Vicus T Trust access to the VBA project object model Quick Access Toolbar Security amp more Message Bar ad lose Add Ins Learn more about protecting your privacy and security from Office com External Content Trust center Microsoft Trustworthy Computing File Block Settings Info Microsoft Excel Trust Center Privacy Options The Trust Center contains security and privacy settings These settings help keep your Recent computer secure We recommend that you do not change these settings Print ve amp Send Excel 2010 Renishaw CNC Reporter user s guide 13 Renishaw CNC Reporter screen layout For detailed operational information please see Using Renishaw CNC Reporter on page 17 Use the tabs at the bottom of the screen to navigate through Reni
6. Parts Part Number Operation Sample ID Date Feature Nominal Deviation Lower Tol Upper Tol Pass Fail Notes Link x Ly x 7 z E E A001 1 Sample 1 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 1000 0 1000 0 1000 0 1000 PASS GO A001 1 Sample 2 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 0500 0 0500 0 1000 0 1000 PASS GO A001 1 Sample 3 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 0400 0 0400 0 1000 0 1000 PASS GO A001 1 Sample 4 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 0900 0 0900 0 1000 0 1000 PASS GO A001 1 Sample 5 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 0300 0 0300 0 1000 0 1000 PASS Q A001 1 Sample 6 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 1100 0 1100 0 1000 0 1000 FAIL GO A001 1 Sample 7 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 0100 0 0100 0 1000 0 1000 PASS Data Manager will process the filtered Archive Query fields and create a blue GO hyperlink When the hyperlink is clicked Data Manager will retrieve the relevant archive and open the Probing Inspection Report containing the toleranced data Part Number Operation Machine Type Work Centre ID Probing Inspection Report 1 Failure s RENISHAW apply innovation A001 1 Demo Machine Demo 01 Z TOP SURF TO1 POSITION Z WORK OFFSET UPDATED NOTE Hyperlinks will not work if the archives have been moved from their original location Clear data Press Clear Data to return Data
7. Renishaw CNC Reporter the DELIMf function must be activated and the appropriate delimiter character for example P must be defined Example post processor content DELIM function inactive with delimiter character DELIM DELIM function active with 7 delimiter character _DELIM DELIM is located in the Reporting section of the Renishaw RenMF editing tool Indicating a new component in an inspection report When inspecting a batch of components it is important to identify each instance of a new component being inspected This is achieved by outputting a trigger word at the end of the Productivity inspection cycle using DPRNT or equivalent followed by a particular word or string of characters added as for example a G code block A sample G code block for an ISO controller Sample output results as per the Demo Results would be txt file would appear POPEN PNUM A001 OPERATION 1 p G103Pl 02 BORE 40 00MM TO2 SIZE 40 0000 39 991 0 009 0 1000 0 1000 DPRNT COMPONENTEND POSITION X 12 5000 12 5024 0 0024 0 0500 0 0500 Ap vr POSITION Y 10 0000 9 9868 0 0132 GS 0 0500 0 0500 MAT CON 0 0000 0 009 0 009 0 1000 0 1000 PCLOS g 03 WEB 25 20MM T02 S129 75 2000 25 204 0 0040 0 0500 0 0500J POSITION Y 25 0000 24 890 TT New Part 0 0000 0 0000 Inspection Sheet CAUTION The trigger word used within the DEN FG Word Pe macro program must exactly match the New Part Inspection Sheet Trigg
8. ReporteriCNCReporterTemplate xlt E CNC Reporter Options Admin Enable Disable Admin Options Output Enable Disable Output Options Unprotect Sheet Password Change Protection Password Protect Unprotect all sheets Unprotect Sheets Protect Sheets Data imported into Renishaw CNC Reporter is password protected to prevent deletion or editing Attempts to edit data will display a warning that cells are password protected and therefore read only The cell or chart you are trying to change is protected and therefore read only A To modify a protected cell or chart first remove protection using the Unprotect Sheet command Tools menu Protection submenu You may be ssword prompted For a pa To unprotect a worksheet open the Unprotect Sheet dialog Excel 2003 Tools gt Protection gt Unprotect Sheet Excel 2007 2010 Review gt Unprotect Sheet and enter the password As shipped the required password is password all lower case To modify the password select Change Protection Password on the Admin tab Enter the default password when prompted then enter and confirm the new password Save Renishaw CNC Reporter to retain the new password NOTE The password can only be changed when there is no data within CNC Reporter If necessary perform a Clear Data operation before changing the password Protect Unprotect all sheets To unprotect all Probing Inspection Reports in a single oper
9. Up Data panel within the Start tab and will not increment when the New Part Inspection Sheet Trigger Word is seen CNC Reporter Options Output Options Administration License Status 28 Days Remaining Click to register license of CNC Reporter Register License Initial CNC Reporter Template me ean Enable Disable Output Options Output Options Enable Print on Trigger CNC Reporter Options Admin Enable Disable Admin Options Enable SPC Text Output F Output Enable Disable Output Options Enable Data Manager 7 Output Unprotect Sheet Password Only Output T S Change Protection Password W j l g g IT Protect Unprotect all sheets Unprotect Sheets Protect Sheets Accept Changes Enable Print on Trigger When checked the live report is sent to the default printer whenever the New Part Inspection Sheet Trigger Word is seen Renishaw CNC Reporter user s guide 29 Enable SPC Text Output When checked a text file called wcid name SPC ARCHIVE DATA txt of inspection results data for toleranced features is produced in the specified backup directory location This data can then be imported into an external SPC package for further analysis The structure of the output is as follows Part number Operation Number Machine Type Work Centre ID Company Name Sample Number Date Units Feature Name amp Attribute Nominal Actual Deviation Lower To
10. any shrink wrap or packaging in which the Product is contained and or installing and or using the Product you indicate your acceptance of the terms of the Licence If you do not agree to the terms of this Licence do not install or use the software and promptly return the Product and accompanying documentation to the person who supplied it to you in order to obtain a refund of any licence fee paid If you are installing the Product on a computer that is not owned by you you are bound by this Licence both individually and as agent for the end user and your actions bind the end user The end user means the person firm or company that is the user of the computer Renishaw grants the Licensee a Licence to use the Product on condition the Licensee accepts the following terms and conditions 1 All rights in and title to the Product are and shall remain vested in Renishaw and its licensors 2 Renishaw shall replace or repair the Product if it does not materially perform to specification under proper use within 90 days of delivery Except as stated in this paragraph all warranties conditions and terms implied by law are excluded In particular no warranty is given that the Product is bug or error free 3 NOTE LIMITATION OF LIABILITY IN CONNECTION WITH USE OF THE PRODUCT Renishaw does not exclude liability for personal injury or death caused by Renishaw s negligence For Products supplied free of charge to the Licensee Renishaw has no
11. charts and Overviews can be saved automatically or manually to the Backup Directory Location defined in the nitial Set Up Data panel The type of data archived is dependent on selections made in the nitial Set Up Data panel within the Start tab Manual archive Select Create Archive from the CNC Reporter Control Panel on the Start tab All data will be processed and a date stamped Excel workbook created in the defined backup location The same archive workbook will be overwritten on each manual archive operation unless Clear Data is selected which will create a new archive workbook for subsequent archive data NOTE Where more than one archive is created in a single day an incremental prefix is applied to the name of the Excel workbook Automatic archive When the number of inspection reports worksheets equals the number defined in the Maximum Number of Worksheets field defined in the nitial Data Set Up panel on the Start tab Renishaw CNC Reporter will automatically pause process and archive data before resuming collection 26 Renishaw CNC Reporter user s guide Additional features Custom templates By default Renishaw CNC Reporter is configured to use a standard template for all Probing Inspection Reports The location and name of this template file is defined in the Administration panel on the Admin tab as C NRenishaw plc Renishaw CNC ReporterNCNCReporterTemplate xlt Administration License Status 28 Day
12. data collection then press Next CNC Reporter Step 1 of 2 Select the Renishaw Probing Software Type Software Type Inspection Plus Productivity Plus pre v1 7 Productivity Plus Select the CNC controller type then press Finish For CNC machine controllers similar to Fanuc select the arrow to the right of the Fanuc field and select the appropriate control from the drop down list CNC Reporter Step 2 of 2 Please indicate the CNC Controller type for the Machine Tool Controller Type NOTE Some NC control platforms which are compatible with Renishaw probing software do not support the output of inspection report data and are therefore not compatible with Renishaw CNC Heporter Backup Directory Location Defines the location to which Excel Archives and data Text Logs are stored New Part Inspection Sheet Trigger Word Defines the word used in the inspection data to indicate the end of a report See also Indicating a new component in an inspection report on page 8 Maximum Number of Worksheets Defines the number of inspection reports that will trigger the automatic archive process The entered value must be between 5 and 400 inspection reports See Archive data on page 25 for more information Inspection Sheets checkbox When this tick box is checked all Probing Inspection Reports will be archived during the automated archive process Chart Overview checkbox When this tick box is
13. other liability to Licensee For Products paid for by the Licensee Renishaw s liability is limited to a the warranty contained in paragraph 2 and b direct losses up to a maximum of 50 000 Renishaw has no liability to the Licensee for any indirect consequential or economic loss including without limitation loss of data profits or goodwill The Product has been designed for use with Renishaw s machine tool probing systems and Renishaw has no liability for the results of using the Product with another manufacturer s machine tool probing systems By accepting the terms of this Licence the Licensee agrees that this limitation of liability is reasonable 4 The Licensee may not make any copies of the Product except as provided in this Licence or as permitted by applicable law The Licensee is authorised to make a backup copy of the Product for security purposes The Licensee must not remove any licence and copyright notices labels or marks contained in the original and shall ensure all copies contain such notices without modification 4 Renishaw CNC Reporter user s guide 10 11 12 If the Product contains electronic manuals the Licensee may print out the manuals in part or in full provided that the print outs or copies are not supplied to any third party that is not an employee or contractor for the Licensee without Renishaw s written permission The Licensee shall not reverse engineer decompile
14. 10 0000 10 0100 0 0100 0 0500 0 0500 PASS ADU Sample 2340 WEB 25 20MM T02 SIZE 25 2000 25 2500 0 0500 0 0500 0 0500 PASS ADV Sample 2340 Op SURF T01 POSITION 0 0000 0 0300 0 0300 0 1000 0 1000 PASS W 8 8 H Archive Query Review data Overview The Overview tab provides the same information as the Overview tab in Renishaw CNC Reporter with the addition of a filterable Date field Cells are colour coded to identify whether data is in tolerance green or out of tolerance red CP CPk Span Average StdDev Nominal Upper Tol USL Lower Tol Part Number Operation Feature A001 e 1 Date Sample ID Sample 1 Sample 2 Sample 3 23May2012 Sample 4 Sample 5 Sample 6 Sample 7 Analyse data Trend Analysis Chart Excel 2003 2007 only Historical Deviation Trend 0 0600 Span 0 1000 tion 0 0500 lation 0 0500 0 0100 0 0379 2 S S 8 3 Measurement Units 5 e gt 8 8 0 0400 Lower Tol 2 Deviation Upper Tol Linear Deviation The Trend Analysis Chart shows a single stream of data representing data in the Archive Query tab NOTE Whatever the number of features selected only a single line will be plotted Renishaw CNC Reporter user s guide 41 Analyse data Comparison Chart Excel 2010 only Measure Sequence DEV Demo 02 BORE 40 00
15. Analyse data Trend Analysis Chart ssicccses cakes dsunsaezsespevecedoctsntebssndentanans doeb euis Pr Pre rwbPPe eU eb bb docete senken 40 Analyse data Comparison Chart dE 41 Additional WS ie EEE 42 Greate AY PENNE Lurer 42 e gem TU TK 42 Use of wildcards EO mc 42 leet Welt ale VE 43 Renishaw CNC Reporter user s guide 7 About Renishaw CNC Reporter Renishaw CNC Reporter is a software package designed to display and process inspection results from Renishaw probing software It allows users to create multiple inspection reports and to track a measured feature between several measured parts An additional complementary application Data Manager allows the historical analysis of inspection data that has previously been processed using Renishaw CNC Reporter Both CNC Reporter and Data Manager run within the Microsoft Excel spreadsheet package providing a familiar operating environment in which to work We hope that Renishaw CNC Reporter meets your reporting requirements If you have any questions or require technical assistance please contact your local Renishaw representative Details are available at www renishaw com contact Compatibility and system requirements Data output package Renishaw CNC Reporter is compatible with inspection data produced by the following software packages Productivity Active Editor Pro Productivity GibbsCAM plug in Renishaw Inspection Plu
16. C Solution Check for possible issues with the data transfer process Re inspect the component and import new data Problem CNC Reporter dialog with the message Data Manager Database at CACNC Reporten is currently NOT available displayed and DATA MANAGER DATABASE AT CACNC REPORTER WAS NOT AVAILABLE displayed at the end of a Probing Inspection Report Cause Data Manager not installed correctly was not installed to the correct location or the data base file could not be found Solution Reinstall Renishaw CNC Reporter ensuring to accept all default file locations offered Problem Cross talk between multiple instances of Renishaw CNC Reporter or Data Manager where one instance of Renishaw CNC Reporter attempts to access data specified by another instance of the application Cause Registry key changes which allow each instance of Renishaw CNC Reporter to open in a new instance of Microsoft Excel have not been made Solution Heinstall Renishaw CNC Reporter to automatically make the necessary adjustments to the necessary registry keys or make the amendments manually These registry keys and the changes made are hkey classes root excel sheet 8 shell open command hkey classes root excel sheet 12 shell open command hkey classes root Excel SheetMacroEnabled 12 shell1 open command The Default key setting of e or dde is changed to 31 44 Renishaw CNC Reporter user s guide The command key j
17. Dates Select Part Number A001 A001 Part Number Operation Sample ID Date Feature Nominal Actual Deviation Lower Tol Upper Tol Pass Fail Notes Link A001 1 Sample 1 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 1000 0 1000 0 1000 0 1000 PASS A001 1 Sample 1 23 May 12 02 BORE 40 00MM T02 SIZE 40 0000 39 9500 0 0500 0 1000 0 1000 PASS A001 1 Sample 1 23 May 12 02 BORE 40 00MM T02 POSITION X 12 5000 12 4900 0 0100 0 0500 0 0500 PASS A001 1 Sample 1 23 May 12 02 BORE 40 00MM T02 POSITION Y 10 0000 10 0200 0 0200 0 0500 0 0500 PASS A001 1 Sample 1 23 May 12 03 WEB 25 20MM T02 SIZE 25 2000 25 2600 0 0600 0 0500 0 0500 FAIL The Archive Query Overview and Trend Analysis Chart tabs are all populated during the data retrieval process NOTE Progress bars may be visible on screen depending on the volume of data being retrieved If retrieval times are prohibitive select a smaller date range 40 Renishaw CNC Reporter user s guide Review and analyse data Review data Archive query The Archive Guery tab presents a tabular view of retrieved data User selectable filters allow data to be refined For example select a single feature and Fail instances of that feature Cee Data RENISHAW A apply innovation Create Hyperlinks Select Machine emo Get Machines Select Date Range 000000 01 01 201 Set Dates Select Part Number A00 Get Parts Part Numbe Operation Sample ID Date eature in ct viation ower To
18. Failure s Machine Type Work Centre ID The alarm message will show whether the dimension is Out of Tolerance or outside above or below a Warning Limit The message will also show the Sample ID that is out of tolerance and identify the row on which it appears NOTE Where multiple alarm messages are generated they may stack on top of one another Selecting Look Up from the alarm dialog will highlight the row within the Probing Inspection Report relating to the error message Quality Problem CNC Reporter xls O Renishaw CNC Reporter user s guide 33 Notes Add notes to and clear alarm messages by pressing Reset Alarm from the alarm dialog Enter a Corrective Action into the input box and press OK 02 02 BORE 40 00MM TO2 40 00MM T02 ZE 398900 0 1100 0 1000 0 1000 NO FAL pomon nom zmo omo omo omo ws me f POSITION Y 0 0500 The note will then be added to the Probing Inspection Report NOTE Alarm notes are not displayed in the Data Manager database Redisplay Quality Warnings To redisplay all warnings after they have been acknowledged click Redisplay Quality Warning on the Start tab All warnings will be redisplayed at the top of CNC Reporter Be aware that they may stack on top of one another 34 Renishaw CNC Reporter user s guide Upgrading and retaining settings When upgrading to a new version of Renishaw CNC Rep
19. Lower Upper Lower Upper Warning Lower Index Pass Sta Tolerance Tolerance Specified Specified Limit Warning I v x Ej T v Limit Limit Limit Fail 01 Z TOP SURF T01 POSITION Z A001 1 Sample 1 0 0000 0 0500 0 0500 0 1000 0 1000 0 1000 0 1000 0 0750 0 0750 1 Pass 01 Z TOP SURF T01 POSITION Z A001 1 Sample 2 0 0000 0 0600 0 0600 0 1000 0 1000 01000 01000 0 0750 00750 8 Pass 01 Z TOP SURF T01 POSITION Z A001 1 Sample 5 0 0000 0 0500 0 0500 0 1000 01000 01000 01000 0 0750 00750 29 Pass 01 Z TOP SURF T01 POSITION Z A001 1 Sample 6 0 0000 0 0600 0 0600 0 1000 0 1000 01000 01000 0 0750 00750 36 Pass v Hit HRS A001 1 A001 2 8002 3 B002 4 app 5 A001 6 B002 7 B002 8 Various 9 Capability Chart Data YET RENDERE 2 M gt Statistical data such as mean standard deviation Cp and Cpk values for the feature is displayed to the right of the chart Data can be filtered by Feature Part Number Operation and Sample ID Microsoft Excel custom filters can also be used Statistical data is updated automatically as filters are applied Demo TEXT I Connection Paused E Stop Data Collection rowe mesme View Capability Chart 4 SortAtoz Z SotztoA Sort by Color K Clear Filter From Feature Search E Select Al V 01Z TOP SURF TO1 POSITION Z 02 BORE 40 00MM TO2 MAT CON 02 BORE 40 00MM TO2 POSITION X 02 BORE 40 00MM TO2 POSITI
20. MM T02 POSITION X DEV Demo 02 BORE 40 00MM TO2 POSITION Y The Comparison Chart shows an individual line for each feature selected using the Feature slicers located to the top right of the chart To clear the filters click on the filter cross j Feature Clear Filter Alt C NOTE Both the Overview tab and Archive Guery tab are linked to the Feature slicers To disable the link press DISABLE AUTO REFRESH OF OVERVIEW Change Tolerances Disable Auto Refresh Where features with different tolerances have been selected is it possible to adjust the tolerances used Select Change Tolerances and specify the new upper and lower tolerances to be applied to all currently filtered features New Upper Tolerance Disable Auto Refresh Change Tolerances New Lower Tolerance OK Cancel NOTE This will affect the display on the Comparison Chart but will not affect data in the source database Part Number K 42 Renishaw CNC Reporter user s guide Additional features Create hyperlinks Hyperlinks can be added to individual rows within the Archive Guery tab to link back to an archived Probing Inspection Report containing the original toleranced data Select Create Hyperlinks in the Archive Guery tab Probing Report Create Hyperlinks Select Machine Demo Get Machines Select Date Range W 0 20 0 01 01 2014 Set Dates Select Part Number A001 LG Get
21. Manager to its original state and remove all applied filters Probing Report Part Number Operation Sample ID Date Feature Nominal RENISHAW S apply innovation Create Hyperlinks Get Machines Set Dates Get Parts Select Machine Select Date Range W A Select Part Number 01 01 2014 Deviation Lower Tol Pass Fail Notes Actual Upper Tol Use of wildcards If there is a requirement to analyse data obtained using multiple CNC machines use a wildcard character in the red Select Machines field Select Machine Select Date Range Select Part Number 01 01 2010 Get Machines Set Dates Get Parts 01 01 2014 A001 Renishaw CNC Reporter user s guide 43 Troubleshooting Problem NO TOLERANCED DATA FOUND displayed at the end of a Probing Inspection Report In addition to this message no coloured data is shown in Probing Inspection Reports the Capability Chart Overview tab or Data Manager Cause This message is displayed when no tolerance data is received from the CNC machine tool Solution Ensure tolerance values are set in the probing cycles Problem There is a Format Problem with the Feature displayed in the Notes column within a Probing Inspection Report or when attempting to export to Data Manager or a statistical process control SPC package Cause This is the result of corrupt numerical data spurious characters being output from the CN
22. ON Y 02 BORE 40 00MM T02 SIZE e Actual Upper Sr 03 WEB 25 20MM T02 MAT CON 03 WEB 25 20MM T02 SIZE 0 1000 Tool Filter Fe ok cma Part Number mr 01 Z TOP SURF T01 POSITION Z E 1 1 01 Z TOP SURF T01 POSITION Z 4 Sample 2 01 Z TOP SURF T01 POSITION Z p 1 Sample 5 i 01 Z TOP SURF T01 POSITION Z A001 1 Sample 6 T NOTE The Renishaw CNC Reporter Capability Chart shows data for a single feature across multiple components Users of Microsoft Excel 2010 can use the Comparison Chart within Data Manager to compare data across multiple features 24 Renishaw CNC Reporter user s guide Control limits Hed lines on the capability chart are Specified Limits determined by the tolerance value set within the probing cycles Visibility of these limits on the capability chart is determined by the status of the Specified Limits tick box in the CNC Reporter Control Panel on the Start tab Orange lines are Warning Limits defined as a percentage of the tolerance value Visibility of these limits on the compatibility chart is determined by the status of the Warning Limits tick box in the CNC Reporter Control Panel on the Start tab The percentage of tolerance Warning Limits Multiplier is also set in the Control Panel By default the Warning Limits Multiplier is 75 Analyse data Overview tab The Overview tab shows a Red Amber Green RAG chart for the data and a
23. SS A001 12 4600 0 0400 0 0500 0 0500 PASS A001 10 0400 0 0400 0 0500 0 0500 PASS A001 25 1500 0 0500 0 0500 0 0500 PASS A001 0 0900 0 0900 0 1000 0 1000 PASS A001 39 9500 0 0500 0 1000 0 1000 PASS A001 12 5300 0 0300 0 0500 0 0500 PASS A001 3 BORE 40 0 j UUUU 10 0100 0 0100 0 0500 0 0500 PASS A001 1 Sample 4 23 May 12 03 WEB 25 20MM T02 SIZE 25 2000 25 2500 0 0500 0 0500 0 0500 PASS A001 1 Sample 5 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 0300 0 0300 0 1000 0 1000 PASS a Hi Archive Query dren Trend Analysis Chat CC mai m Demo Inge TENATSNENATE RT VI TJ TLF AAT e Set Dates Select the required CNC machine tool from the list Select date range Select Set Dates and use the resulting calendar to set the required start and end dates of the machine data to be analysed Select Machine Get Machines Select Date Range 02000 01 01 2014 Select Part Number X Set Dates Actual E 01 04 2010 Set End Date 01 01 2014 Renishaw CNC Reporter user s guide 39 Select part number Select Get Parts Parts are listed in the database alphabetically and by default the first part number in the database is selected Click in the green coloured cell to open a drop down box allowing other parts to be selected Based on these selections data is retrieved and analysed Select Machine Demo Get Machines Probing Report Select Date Range 0 0 20 0 01 01 2014 Set
24. User s guide REN ISHAW e apply innovation Renishaw CNC Reporter cP CPk Span Average st Nominal Upper Tol Benchmark amp Benchmark Benchmark amp Benchmark FEATURE BASED CAPARE ITY CHART 012 TOP SURF 701 POSITION Z 01 Z TOP SURF T01 POSITION Z 01 Z TOP SURF T01 POSITION Z 01 Z TOP SURF T01 POSITION Z 01 Z TOP SURF T01 POSITION Z RENISHAW apply innovation Part Number A001 Name Name Operation 1 Sample ID Sample 1 Machine Type Demo Machine Date 18 05 2012 Work Centre ID Demo Units Metric Upper Tolerance In Tolerance 01 Z TOP SURF T01 POSITION Z WORK OFFSET UPDATED 02 BORE 40 00MM T02 6 B002 7 B002 8 Various 9 Chart Data N Admin Determine process capability 2 Renishaw CNC Reporter user s guide O 2012 Renishaw plc All rights reserved This document may not be copied or reproduce in whole or in part or transferred to any other media or language by any means without the prior written permission of Renishaw plc The publication of material within this document does not imply freedom from the patent rights of Renishaw plc Disclaimer RENISHAW HAS MADE CONSIDERABLE EFFORTS TO ENSURE THE CONTENT OF THIS DOCUMENT IS CORRECT AT THE DATE OF PUBLICATION BUT MAKES NO WARRANTIES OR REPRESENTATIONS REGARDING THE CONTENT RENISHAW EXCLUDES LIABILITY HO
25. WSOEVER ARISING FOR ANY INACCURACIES IN THIS DOCUMENT Trademarks RENISHAW and the probe emblem used in the RENISHAW logo are registered trademarks of Renishaw plc in the UK and other countries apply innovation is a trademark of Renishaw plc All other brand names and product names used in this document are trade names trademarks or registered trademarks of their respective owners Renishaw part no H 5465 8501 01 A Issued 10 2012 Renishaw CNC Reporter user s guide 3 IMPORTANT PLEASE READ CAREFULLY RENISHAW PRODUCT LICENCE Licensee you the person firm or company accepting the terms of this Licence Renishaw Renishaw plc New Mills Wotton under Edge Gloucestershire GL12 8JR United Kingdom Product this software Renishaw CNC Reporter including all modules and components manuals and any software protection devices incorporated within or issued with it Licence to use non exclusive licence to use the product on a single installation at any one time using a Renishaw licence key The licence to use may be transferred from one installation to another installation in accordance with the procedures specified by Renishaw If the Product is licensed for a time limited trial or demonstration only the Product will not operate after expiry of the specified time Renishaw provides no warranties regarding the performance of the Product and the first sentence of Condition 2 below does not apply By opening
26. ap Delimiter Set Controller Type Fanuc Macro Backup Directory Location CACNC Reporten New Part Inspection Sheet Trigger Word COMPONENTEND Maximum Number of Worksheets Inspection Sheets Chart Overview iv Iv Work Centre ID Unique name of the CNC machine tool used to gather the inspection data which will be imported Part Number Number or identifier of the part for which inspection data is to be imported Operation Operation name or number associated with the inspection data to be imported Name Company or operator name associated with the inspection data to be imported Machine Type The machine type or name from which the inspection data is to be imported Sample ID An automatically generated incremental value comprising a prefix and numeric value Initial Prefix Can be either a text or numeric value Initial Number A numeric value which will be incremented with each new inspection report Units Measurement units Metric or Imperial Inches Renishaw CNC Reporter user s guide 19 Delimiter Defines the delimiter character used in the inspection data file to be imported The default character is See Customise the Productivity post processor on page 8 for further information and for an example of how the delimiter character should appear as part of the function Set Controller Type Click Set Controller Type to initiate the Set Controller Wizard Within the wizard select the probing software used for
27. ation select Unprotect Sheets on the Admin tab Password protection can be applied to all the sheets in a single operation by selecting Protect Sheets on the Admin tab Renishaw CNC Reporter user s guide 31 Poll time NOTE Poll time is only applicable when using the REAL TIME method of data import The period of time between accessing a results data file can be adjusted by amending the Poll Time secs value in the CNC Reporter Control Panel on the Start tab Poll Time can be any whole number between 5 and 999 seconds CNC Reporter Control Panel Click to Collect Data automatically Lock Setu Collect Data REAL TIME C Data Retrieval Method Poll Time TEXT 20 secs Lock setup The Lock Setup check box allows users to prevent changes to a number of fields within the Initial Set Up Data panel With this option ticked only Part Number Operation Name Machine Type and Sample ID remain editable The method of data retrieval the results file being imported and the poll time are also locked when this check box is selected CNC Reporter Control Panel Click to Collect Data automatically Lock Setu Collect Data REAL TIME Fr Data Retrieval Method Poll Time TEXT 20 secs To unlock deselect the check box and enter the Unprotect Sheet password 32 Renishaw CNC Reporter user s guide Alarms The CNC Reporter Control Panel on the Start tab provides the ability to generate on screen alarms when eit
28. ault the Open dialog will display files with a txt file extension This can be modified and any file type supported by Microsoft Excel can be imported Renishaw CNC Reporter user s guide 21 Data collection REAL TIME method The REAL TIME data import method periodically accesses polls a file to retrieve inspection data The time between each access the poll time can be any whole value between 5 and 999 seconds default setting is 20 seconds and is defined in the Poll Time field See also Poll time on page 31 If the file is locked by another application CNC Reporter skips over the file by the defined poll time To import data select Collect Data REAL TIME from the Floating Window or the CNC Reporter Control Panel within the Start tab Source De o TE p P c Connection Disabled Tools Data Window Help 7 window CNC Reporter Control Panel RENISHAW amp Click to Collect Data automatically apply innovation Data Retrieval Method TEXT Click to Collect Data from a stored Text File Lookin di Renishaw CNC Reporter AQ X Gi E ies Collect Data FILE IMPORT tne Date modd s DIRE SS My Recent di images Documents Demo Resa Click to Create Capability Chart __ Readme Compile Capability Chart Desktop Click to remove all existing Inspection Sheets Clear Data A Click to create a Saved file without macros i File name Create Archive Place
29. checked the Capability Chart and Overview sheets will be archived during the automated archive process NOTE Select Inspection Sheets and Chart Overview checkboxes to ensure all data is archived 20 Renishaw CNC Reporter user s guide Importing data Two methods of data import are available FILE IMPORT and REAL TIME Data collection FILE IMPORT method FILE IMPORT is a manual process which imports all inspection data from a text or similar file in a single operation This is expected to be the most common method of data import Select Collect Data FILE IMPORT from the Start tab Source Demo TEXT r Connection Disabled H il E 4 MI SN 4 130 B Arial 10 B CNC Reporter Control Panel Click to Collect Data automatically Lock RE N I amp H AW Collect Data REAL TIME T apply innovation Data Retrieval Method Poll Time TEXT 2p s Open EMT Click to Collect Data from a stored Text File i di Renishaw CNC Reporter x mI Xu Tools i Collect Data FILE IMPORT A Ze d SS A images Documen ts E Demo Results L Readme Click to Create Capability Chart Compile Capability Chart Click to remove all existing Inspection Sheets Clear Data Click to create a Saved file without macros File name Create Archive Fees oF bpe Text Fies a Click OK in the Import a Data File dialog then navigate to and select the data file for import NOTE By def
30. cted to install these packages SQL Server Compact 3 5 SP1 Microsoft Data Access Component 2 80 or hig 6 1 7601 NOTE When installing Renishaw CNC Reporter on PCs with early versions of Microsoft Windows and Microsoft Excel additional components such as Windows Installer NET Framework v2 0 Microsoft Data Access Components v2 8 Excel 2003 NET patch may also be installed Screenshots may vary from those shown depending on the version of Renishaw CNC Reporter installed 10 Renishaw CNC Reporter user s guide Once installation is complete a Renishaw CNC Reporter icon will be visible on the PC desktop Double click this icon or single click and press Enter to open Renishaw CNC Reporter Depending on the configuration and permission settings of the target PC a Security Warning dialog Microsoft Excel version dependent may be displayed when Renishaw CNC Reporter is first launched C Renishaw plc Renishaw CNC Reporter YNC Reporter de contains macros by Detail GS Productivity Solutions Ltd Macros may contain viruses It is usually safe to disable macros but if the macros are legitimate you might lose some functionality V Always trust macros from this publisher Excel 2003 Home Insert Page Layout Formulas Data Review Security Warning Macros have been disabled Options e Security Alert Macro Macros have been disabled Macros might contain viruses or other security hazards Do
31. ep your demens sf andyourconptrseare ana ety T T Formulas Proofing Protecting your privacy Add ins Save Microsoft cares about your privacy For more information about how Microsoft Office Excel helps to protect your privacy please see the privacy statements Trusted Locations 3 For macros in documents not in a trusted location Disable all macros without notification Disable all macros with notification Disable all macros except digitally signed macros Enable all macros not recommended potentially dangerous code can run ActiveX Settings Message Bar Advanced 8 Show the Microsoft Office Excel privacy statement Microsoft Office Online privacy statement Customer Experience Improvement Program Add Ins External Content P zo Resources Customize Developer Macro Settings Privacy Options Learn more about protecting your privacy and security from Microsoft Office Online Microsoft Tr omputin Microsoft Office Excel Trust Center The Trust Center contains security and privacy settings These settings help keep your computer secure We recommend that you do not change these settings Print b Z Prepare gt gj sena als a Publish gt lo m Sy nni Options X Eat tn oe 7 General ei Help keep your documents safe and your computer secure and healthy Trusted Publishers Home In
32. er Word defined in PNUM A001 OPERATION 1 the nitial Set Up Data panel in the Start tab of Renishaw CNC Reporter 02 BORE 40 00MM T02 SIZE 40 0000 39 999 0 0010 0 1000 0 1000 POSITION X 12 5000 12 6498 0 1498 0 0500 0 0500 POSITION Y 10 0000 9 9541 0 0459 0 0500 0 0500 MAT CON 0 0000 0 001 0 001 0 1000 0 1000 03 WEB 25 20MM T02 SIZE 25 2000 25 259 0 059 0 0500 0 0500 0 0000 0 0000 Inspection Sheet MAT CON 0 0000 0 05 01 Trigger Word 5007 Pd Renishaw CNC Reporter user s guide 9 Installation and product registration Install Renishaw CNC Reporter NOTE Admin rights for the target PC are required to install Renishaw CNC Reporter Insert the Renishaw CNC Reporter software disc into your CD DVD drive Navigate to the CD DVD drive and double click to select the software file to install based on the version of Microsoft Excel 32 bit or 64 bit currently installed on the target PC A setup wizard will guide you through the installation process Welcome to the Renishaw CNC Reporter Setup Wizard The Setup Wizard will install Renishaw CNC Reporter on your computer Click Next to continue or Cancel to exit the Setup Wizard If the installer cannot detect a copy of Microsoft Excel notification will be given and the installation process will cease A dialog will indicate that additional prerequisite software packages are required by Renishaw CNC Reporter ensure the tick boxes are sele
33. he CNC machine tools from which data has been collected E Clear Data RENISHAW apply innovation i Create Hyperlinks Select Machine Demo Probing Report Select Date Range anna aa ETE Dates Select Part Number AO0 Part Number Operation Sample ID Date Feature i Deviation 3 Upper Tol Pass Fail Notes Link El x x 7 i Ll 0 1000 0 1000 PASS A001 1 Sample 1 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 1000 A001 1 Sample 1 23 May 12 02 BORE 40 00MM T02 SIZE 40 0000 39 9500 9 0 0 1000 0 1000 PASS A001 1 Sample 1 23 May 12 02 BORE 40 00MM T02 POSITION X 12 5000 12 4900 0 0100 0 0500 0 0500 PASS A001 1 Sample 1 23 May 12 02 BORE 40 00MM T02 POSITION Y 10 0000 10 0200 0 0200 0 0500 0 0500 PASS A001 1 Sample 1 23 May 12 03 WEB 25 20MM T02 SIZE 25 2000 600 0 0600 0 0500 0 0500 FAIL A001 1 Sample 2 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 0500 0 0500 0 1000 0 1000 PASS A001 1 Sample 2 23 May 12 02 BORE 40 00MM T02 SIZE 40 0000 39 9200 0 0800 0 1000 0 1000 PASS A001 1 Sample 2 23 May 12 02 BORE 40 00MM T02 POSITION X 12 509 12 4600 0 0400 0 0500 0 0500 PASS A001 1 Sample 2 23 May 12 02 BORE 40 00MM T02 POSITION Y 0 0000 9 9800 0 0200 0 0500 0 0500 PASS A001 1 Sample 2 23 May 12 03 WEB 25 20MM T02 SIZE 25 2000 25 1900 0 0100 0 0500 0 0500 PASS A001 1 Sample 3 23 May 12 01 Z TOP SURF T01 POSITION 0 0000 0 0400 0 0400 0 1000 0 1000 PASS A001 1 40 0300 0 0300 0 1000 0 1000 PA
34. he Templates tab will be visible Initial Set Up Data Once clicked Templates tab is active Work Centre ID Capability Chart Data Custom Part Specific Template Manager Current Part New Part Number Trigger Word Exclude Trigger Word PNUM B002 PNUM Iv Archive By Part Increase Available Input Rows Part Number 2peration Template Click in Cell to define Template File xIt Location Metric Imperial PNUM A001 C Renishaw plciRenishaw CNC Reporter CNCReporterTemplate xit Metric euen RS RN AN Renishaw CNC Reporter user s guide 17 Using Renishaw CNC Reporter Initial configuration When first run Renishaw CNC Reporter will display a message indicating that registration is required Until registration is complete the application will run using a time limited license The time limited license allows the application to operate for 30 days and limits analysis capability to the Demo Results txt file supplied with the application NOTE License status is always displayed in the Administration panel located on the Admin tab as shown on page 15 Register Renishaw CNC Reporter Navigate to the Admin tab and select Register License to display the CNC Reporter License Registration dialog License Registration RENISHAW amp apply innovation CNG Reporter License Registration RENISHAW lt CNC Reporter amp Serial ID SeialD Lo o o Company ID Co
35. her Specified Limits and or Warning Limits are exceeded Specified Limits Specified Limits displayed as red lines on the Capability Chart provide a visual indication of tolerances defined within inspection programs Measured values which exceed these limits are displayed in red in the Probing Inspection Report and in red cells in the Overview tab NOTE Where tolerances are specified as 0 000 no limits are displayed on the Capability Chart Warning Limits Warning Limits displayed as dashed orange lines on the Capability Chart provide a visual indication of features approaching tolerance These limits are generated by Renishaw CNC Reporter and are defined as a percentage of the Specified Limit Warning Limits Multiplier Measured values exceeding these limits but within the Specified Limits are displayed in green in the Probing Inspection Report and in yellow cells in the Overview tab NOTE Where the Warning Limit Multiplier is 100 Warning Limits and Specified Limits are the same no Specified Limits are displayed on the Capability Chart Alarm Messages Alarm message boxes will appear at the top of the screen for inspection values which exceed the defined limits Kid 9 le Quality Problem CNC Reporter xls Quality Warning CNC Reporter xls Home Insert Page Layout Out of Tolerance ew D Above Upper Warning Limit Sample 2 Row 26 mm Sample 2 Row 22 Part Number Probing Inspection Report Operation 1
36. l er Tol Pass Fail Notes Link AO Sample OP SURF TO1 POSITION 0 0000 0 1000 0 1000 0 1000 0 1000 PASS ADY Sample BORE 40 00MM 102 SIZE 40 0000 39 9500 0 0500 0 1000 0 1000 PASS AD Sample BORE 40 00MM 102 POSITION 12 5000 12 4900 0 0100 0 0500 0 0500 PASS AD Sample BORE 40 00MM T02 POSITION 10 0000 10 0200 EI 0 0500 0 0500 PASS ADY Sample Mar WEB 25 2004M 102 SIZE 25 2000 25 2600 0 0600 0 0500 0 0500 FAIL AD Sample Mar Op SURF TO1 POSITION 0 0000 0 0500 0 0500 0 1000 0 1000 PASS AQ0 Sample Mar BORE 40 00MM T02 SIZE 40 0000 39 9200 0 0800 0 1000 0 1000 PASS ADY Sample BORE 40 00MM T02 POSITION 12 5000 12 4600 0 0400 0 0500 0 0500 PASS A00 Sample BORE 40 00MM T02 POSITION 10 0000 9 9800 0 0200 0 0500 0 0500 PASS AQ0 Sample WEB 25 204M TO2 SE 25 2000 25 1900 0 0100 0 0500 0 0500 PASS A00 Sample Op SURF TOT POSITION 0 0000 0 0400 0 0400 0 1000 0 1000 PASS A0 Sample BORE 40 008 TO2 SIZE 40 0000 40 0300 0 0300 0 1000 0 1000 PASS A0 Sample BORE 40 00MM T02 POSITION 12 5000 12 4600 0 0400 0 0500 0 0500 PASS ADO Sample BORE 40 00MM T02 POSITION 10 0000 10 0400 0 0400 0 0500 0 0500 PASS A0 Sample ay WEB 25 20MM T02 SIZE 25 2000 25 1500 0 0500 0 0500 0 0500 PASS A0 Sample Op SURF T01 POSITION 0 0000 0 0900 0 0900 0 1000 0 1000 PASS AN Sample BORE 40 00MM T02 SIZE 40 0000 39 9500 0 0500 0 1000 0 1000 PASS ADU Sample lay BORE 40 00MM T02 POSITION 12 5000 12 5300 0 0300 0 0500 0 0500 PASS ADV Sample 2340 BORE 40 00MM T02 POSITION
37. lerance Upper Tolerance In Tolerance Pass Fall Enable Data Manager Output A001 1 Demo Machine Demo Renishaw plc Samplel 02 June 2012 Metric POINT1 POSITION X 0 Dy 0 05 0 05 0 05 YES PASS When checked this option enables toleranced results data to be written to a local database for subsequent access and analysis using Data Manager An on screen dialog will advise if the database is unaccessible and a message will be added to the Probing Inspection Report m E E e DATA MANAGER DATABASE AT CACNC Reporter WAS NOT AVAILABLE Only Output on Trigger Word When checked results are only sent to the database when the New Part Inspection Sheet Trigger Word COMPONENTEND or similar is seen at the end of a report Leave this option unchecked during component or job prove out where a disproportionate number of failures could be expected This will prevent data obtained during the prove out process being sent to database within Renishaw CNC Reporter and processed by the application Once the prove out process is complete check the option to allow Renishaw CNC Reporter to import and analyse results data 30 Renishaw CNC Reporter user s guide Password protection Administration License Status 28 Days Remaining Click to register license of CNC Reporter Register License Initial CNC Reporter Template C Renishaw plciRenishaw CNC
38. mpany Activation Code TE e Activation Code Validate License Registration Status 28 Days Remaining Exit In the Work Centre ID WCID field enter a unique name for the CNC machine tool used to gather inspection data The default Demo entry is only valid for use with the Demo Results txt file and cannot be used with real inspection data files In the remaining fields enter the seven digit Serial ID the seven digit aloha numeric Company ID and the 32 digit alpha numeric Activation Code provided on a product label on the rear of the packaging Select Validate License Read acknowledge and accept the resulting software product license agreement Renishaw CNC Reporter is now activated and available for unlimited use NOTE If Renishaw CNC Reporter is uninstalled from a PC and then reinstalled at a later date it is not necessary to reactivate the software as the PC will retain license information 18 Renishaw CNC Reporter user s guide Initial Set Up Data panel Before data is imported into Renishaw CNC Reporter it is necessary to populate the Initial Set Up Data panel within the Start tab to define the information which will be displayed in the header section of Probing Inspection Reports Initial Set Up Data Custom Tem plates OFT Work Centre ID Part Number Various Operation Name Machine Type Demo Machine Initial Prefix Sample Sample ID Initial Num ber Units Metric View Template M
39. mplates ON and will make the Part number and Operation fields in this panel inactive A Templates tab will open and CNC Reporter will jump to this tab Initial Set Up Data Custom Templates ON Work Centre ID Name Name Kam Capability Chart Data Renishaw CNC Reporter user s guide 27 In the Part number column enter the part numbers that appear in the results data file Click the relevant cell in the Template column to select the template to be used for each part Custom Part Specific Template Manager Current Part New Part Number Trigger Word Exclude bm Word Greg EN T Text string to indicate SE Part Number Operation eration PNUM A001_ Increase Available Input Ro new part number D PNUM B002 baus 4 Template Click in Cell to define Template File xIt Location Metric Imperial Part number within Custom template to use C Renishaw pic Renishaw CNC ReporteriCNCReporterTemplate xlt Metric the results file for specified part number C Renishaw plciRenishaw CNC ReporteriEngineeringLogoTemplate xlt In the New Part Number Trigger Word area at the top of the worksheet enter the unique text string used in the results data file to indicate the inspection of a new part number CNC Reporter Options Admin Options Administration License Status 28 Days Remaining recep erem Click to register license of CNC Reporter Enable Disable Admin Options Register License
40. nalysis data User selectable filters allow data to be refined as necessary NOTE The Capability Chart can only display toleranced results data If the imported results file does not contain toleranced data CNC Reporter is unable to populate the chart and a dialog advising There was no TOLERANCED data to process will be displayed Overview tab CP CPk Span Average StdDev Nominal Upper Tol USL Lower Tol LSL Max Min Part Number x Operation Feature Sheet Sample ID Index Sample 1 A 1 Sample 2 2 CH Sew A001 1 A001 2 8002 3 8002 4 Vi Mau gt The Overview tab displays actual measured data in colour coded data cells providing a visual indication of features which are in tolerance green approaching tolerance yellow and out of tolerance red NOTE The Overview tab can only display toleranced results data If the imported results file does not contain toleranced data the Overview tab will remain empty Renishaw CNC Reporter user s guide 15 Admin tab Administration About Administration About License Status About CNC Reporter 28 Days Remaining Click to register license of CNC Reporter Register License Save Settings Load Settings Initial CNC Reporter Template C Renishaw piciRenishaw CNC ReporteriCNCReporterTemplate xlt an s CNC Reporter Multiple Instance Position CNC Reporter Options Admin Set Instance Position Enable
41. ng Inspection Report and specifies how the inspection of a new component and the end of a report are identified within the imported inspection data file 14 Renishaw CNC Reporter user s guide Capability Chart Data tab m gt FEATURE BASED CAPABILITY CHART 2 Sample n 01 Z TOP SURF T01 POSITION Z 0 0550 Average Dev n 0 0100 Span 0 0600 Max Value 0 0500 Min Value 0 0550 Mean 0 0071 Std Deviation 4 71 Cp 2 12 Cpk E 2 E eo 5 S 0 0500 a L o z gt 8 5 8 Actual Upper Specified Limit Lower Specified Limit Upper Waming Limit Lower Waming Limit 0 1000 0 1000 0 0750 0 0750 Tool Filter Feature Part Number i Operation Sample ID Nominal Actual Deviation Upper Lower Upper Lower Upper Warning Lower Index Pass Sta Tolerance Tolerance Specified Specified Limit Warning I v a EG 57 v Limit Limit Limit Fail 01 Z TOP SURF T01 POSITION Z A001 1 Sample 1 0 0000 0 0500 0 0500 0 1000 0 1000 0 1000 0 1000 0 0750 0 0750 1 Pass 01 Z TOP SURF T01 POSITION Z A001 1 Sample 2 0 0000 0 0600 0 0600 0 1000 0 1000 01000 0 1000 0 0750 0 0750 8 Pass 4 gt HRS A001 1 A001 2 lt B002 3 lt B002 4 lt Various 5 Capability Chart Data TETT dn 2 nt i w gt The Capability Chart provides a graphical representation of the variation in measured data for a single feature across multiple components along with associated statistical a
42. nnnarennnnnnnnnsvnnnvnnnnnnvnnevnnnnnnsnensnnnnnnssnnnnnnnnnsee 17 mia Se Up Data panel MN E er 18 DONN 0 Bel REE T tt 20 Data collection FILE IMPORT MENN EE 20 Data collection REAL TIME MENA EE 21 PROVIEW eG Qe ee 22 Review data Probing Inspection Reports uk 22 Analyse data Capability Chart 23 Seife MINTS ENTE RD mm 24 Analyse data Overview Tab 24 TEN 25 POGOe ht 26 Custom WENN EE EE e IREE 26 CNC Reporter Options Admin CODHOES sacs cece ssuicentinececsiseusstssentas pntat tena tronc riesen este se ino Pusdicutec 27 CNC Reporter Options Output Options ucuoiuinsmsttotin tert dud tuna ee bntk bacis abet roster dtr saifeuuebesiicneheiviesdisentnites 28 x T de Reie CO EE 30 FO 31 Bere ND 31 E d RENERE DK RC A ED NEUE 32 NW ee EM Ipae 32 PAREN IMIS Le ET 32 NOE A 33 FRE GIS EON AA AMIN EE EE a 33 Upgrading and retaining Ernie NE EN 34 6 Renishaw CNC Reporter user s guide Contents continued BELE INIRE 35 Data Manager screen Aurvana kokekar 36 Archive Query taD ERR Rm I M R 36 OE a e E uU e 36 Trend Analysis Chart E 37 Comparison Chart taD jr 37 PN TOT TM 38 wis 2161 TAC MINS NORTE TT T Ee 38 Select date range EEE TEL DOES 38 Select part p U CM E 39 Review and analyse daa 40 Review data Archive query EE NE dr IU NDUUPdUUE aD Ite enon aonesuntenased 40 Review data STi 40
43. not enable this content unless you trust the source of this file Note The digital signature is valid but the signature is from a publisher whom you have not yet chosen to trust More information File Path C Renishaw plciRenishaw CNC Reporter Ch Reporter lem Signature Signed by GS Productivity Solutions Ltd Certificate expiration 15 03 2015 Certificate issued by COMODO Code Signing CA 2 Show Signature Details Help protect me from unknown content recommended Enable this content Trust all documents from this publisher Excel 2007 Home Insert Page Layout Formulas Data Review View Excel 2010 Select the option to enable content trust the publisher as appropriate and allow CNC Reporter to run Renishaw CNC Reporter user s guide 11 Depending on the target PC configuration and permission settings a Macro Security Trust Settings dialog may now be displayed Although CNC Reporter is digitally signed by GSP5 a further security setting must be manually changed in order for Reporter to execute correctly Please change your Macro Security Trust Settings To change your security setting 1 Please Close this session of CNC Reporter 2 Select Tools Macro Security 3 Select the Trusted Sources Publishers tab 4 Place a checkmark next to Trust access to Visual Basic Project Although CNC Reporter is digitally signed by GSPS a further security setting must be manually changed in
44. nstallation with Microsoft Excel 2010 Archive Query Aes Meedia Archive Query tab m gt Ee RENISHAW apply innovation Create Hyperlinks Select Machine Demo Get Machines Probing Report Select Date Range WM SES 01 01 2014 Set Dates Select Part Number A001 Get Parts Part Number Operation Sample ID Date Feature Nominal Deviation Lower Tol Upper Tol Pass Fail Notes Link DI x 7 7 DH x 7 7 DI H LG A001 1 Sample 1 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 1000 0 1000 0 1000 0 1000 PASS A001 1 Sample 1 23 May 12 02 BORE 40 00MM T02 SIZE 40 0000 39 9500 0 0500 0 1000 0 1000 PASS A001 1 Sample 1 23 May 12 02 BORE 40 00MM T02 POSITION X 12 5000 12 4900 0 0100 0 0500 0 0500 PASS A001 1 Sample 1 23 May 12 02 BORE 40 00MM T02 POSITION Y 10 0000 10 0200 0 0200 0 0500 0 0500 PASS A001 1 Sample 1 23 May 12 03 WEB 25 20MM T02 SIZE 25 2000 25 2600 0 0600 0 0500 0 0500 FAIL A001 1 Sample 2 23 May 12 01Z TOP SURF T01 POSITION Z 0 0000 0 0500 0 0500 0 1000 0 1000 PASS A001 1 Sample 2 23 May 12 02 BORE 40 00MM T02 SIZE 40 0000 39 9200 0 0800 0 1000 0 1000 PASS A001 1 Sample 2 23 May 12 02 BORE 40 00MM T02 POSITION X 12 5000 12 4600 0 0400 0 0500 0 0500 PASS A001 1 Sample 2 23 May 12 02 BORE 40 00MM T02 POSITION Y 10 0000 9 9800 0 0200 0 0500 0 0500 PASS A001 1 Sample 2 23 May 12 03 WEB 25 20MM T02 SIZE 25 2000 25 1900 0 0100 0 0500 0 0500 PASS A001 1 Sample 3 23 Ma
45. or modify the Product or re use any components separately from the Product unless permitted by applicable law provided that Licensee has first contacted Renishaw to request any information required to interface with Licensee s other software The Licensee shall not make the Product available to any third party in any manner whatsoever nor may this Licence and the Product be transferred to a third party without Renishaw s prior written agreement Any agreement by Renishaw is conditional on the permitted transferee agreeing to all terms of this Licence and the Licensee not retaining any copies of the Product The Licensee shall not export the Product in contravention of any applicable export control laws The Licensee shall permit reasonable auditing and tracing of copies of the Product by Renishaw or its licensors Renishaw shall have the right to terminate this Licence immediately if the Licensee fails to comply with any of these terms and conditions The Licensee agrees upon receipt of notice of termination from Renishaw to immediately return or destroy all copies of the Product in its possession or control Statement concerning United States Government users This Product is commercial computer software and commercial computer software documentation as used in 48 CFR 12 212 and 48 CFR 227 7202 1 to 227 7202 4 that has been developed exclusively at private expense If this Product is acquired directly or indirectly on behalf of a unit or agenc
46. order for Reporter to execute correctly Please change your Macro Security Trust Settings To change your security setting 1 Please Close this session of CNC Reporter 2 Select the Windows Button Top Left Excel Options Trust Center 3 Select Trust Center Settings and then Macro Settings 4 Place a checkmark next to Trust access to the VBA project object model Although CNC Reporter ts digitally signed by GSP a further security setting must be manually changed in order for Reporter to execute correctly Please change your Macro Security Trust Settings To change your security setting 1 Please Close this session of CNC Reporter 2 Select the File Options Trust Center 3 Select Trust Center Settings and then Macro Settings 4 Place a checkmark next to Trust access to the VBA project object model Excel 2010 Renishaw CNC Reporter will close down allowing the trust access to Visual Basic VBA Project to be checked 12 Renishaw CNC Reporter user s guide Follow the instructions provided in the dialog to resolve the issue Issued To Issued By Microsoft Corp Microsoft C Renishaw plc VeriSign Cla Friendly Name Mone None Expira 22 01 23 02 View Remove v Trust all installed addins and templates E Trust access to Visual Basic Project Add Ins Options EI Popular h Si pr Trusted Publishers Her ke
47. orter it is possible to save settings from the existing installation which can then be loaded to the new version Select Save Settings Settings panel Admin tab Install the latest version of Renishaw CNC Reporter This will overwrite the currently installed version but will not affect software registration and database files Open the new installation Select Load Settings Settings panel Admin tab NOTE Before loading the saved settings any existing Probing Inspection Report data should be cleared by selecting Clear Data CNC Reporter Control Panel on the Start tab Renishaw CNC Reporter user s guide 35 Data Manager Data Manager is a separate complementary application for the analysis of historical data which has previously been processed using Renishaw CNC Reporter Data can be viewed in tabular rchive Guery tab Overview and chart formats to determine trends and variations The application installs alongside Renishaw CNC Reporter and a Data Manager icon is added to the desktop NOTE Only toleranced data is available for review and analysis in Data Manager Two versions of Data Manager exist the version installed with Renishaw CNC Reporter being dependent on the version of Microsoft Excel installed on the target PC 36 Renishaw CNC Reporter user s guide Data Manager screen layout Use the tabs at the bottom of the screen to navigate through Data Manager Tabs shown below are from an i
48. range of statistical data lcs es vo gie i out Formulas Data Review View Developer Options Design CPk Span Average StdDev Nominal Upper Tol USL Lower Tol LSL Max Min Feature Part Number x Operation Sample ID Sample 1 Sample 2 Sample 5 Sample 6 STEE Overview AIPA Ee 2 4 v Data can be filtered by Feature Part Number Operation Sample ID or Sheet Index to change add or remove attributes Microsoft Excel custom filters can also be used Statistical data is updated automatically as filters are applied Colour coding of the actual data cells is dependent on the Specified Limits and Warning Limits Red indicates actual data is outside the Specified Limit green indicates actual data is inside the Warning Limit yellow indicates that actual data is outside the Warning Limit but inside the Specified Limit Colour of Cp and Cpk data cells are determined using Conditional Formatting within Microsoft Excel The default settings are Red x 1 yellow gt 1 and 1 33 green gt 1 33 These values can be amended using the Conditional Formatting Rules Manager within Microsoft Excel Buen ume Dr Rule applied in order shown Format Cell Value gt 1 33 Cell Value between 1 Cell Value lt 1 e Aae sc HEEN e Renishaw CNC Reporter user s guide 25 Archive data An Excel workbook archive containing Inspection Reports Capability
49. s Configuration by Renishaw engineers is required before Inspection Plus data can be used with Renishaw CNC Reporter PC specification For optimum performance ensure the target PC meets or exceeds the following PC specification Operating system Microsoft Windows XP or later Processor 2 0 GHz Intel Core 2 Duo or equivalent Memory 2 GB RAM 1 GB hard disk space 32 bit operating systems 4 GB RAM 1 GB hard disk space 64 bit operating systems CD DVD drive for software installation An existing installation of Microsoft Excel 2003 or later Excel 2010 recommended NOTE Microsoft Excel 2003 with a Windows 7 operating system is not a supported combination for the use of Renishaw CNC Reporter NOTE It is not possible to use a 64 bit version of Microsoft Excel in combination with a 32 bit operating system Renishaw CNC Reporter is available in English only 8 Renishaw CNC Reporter user s guide Customise the Productivity post processor The Renishaw Productivity post processor is a text file with a RenMF file extension containing a series of commands and switches that can be configured to suit a particular CNC machine tool and application The post processor includes a DELIM function that is used to configure the system to output delimited data When the post processor is first installed the DELIM function is disabled rendering the function inactive In order to use Productivity generated inspection data in
50. s Files of type Text Files In the resulting dialog navigate to and select the data file to import NOTE By default the Open dialog will display files with a txt file extension This can be modified and any file type supported by Microsoft Excel can be imported Once all data has been imported the file is deleted but the application will continue to interrogate the folder location periodically as defined by the poll time for any additional results files that may be added 22 Renishaw CNC Reporter user s guide Review and analyse data Review data Probing Inspection Reports A Probing Inspection Report is created for each inspected component with a new worksheet created for each report Worksheet tabs are named sequentially using the data from the Initial Prefix field and the Initial Number field defined in the nitial Set Up Data panel of the Start tab Each report comprises a header section and a body section RENISHAW S apply innovation Header section Part Number A001 Name Name Probing Inspection Report Operation 1 Sample ID Sample 1 Machine Type Demo Machine Date 18 05 2012 Work Centre ID Demo Units Metric Feature name seg Lo Feature attribute Lesser ze a toleranced M ee Sa Se Feature attribute p E Body untoleranced lasse mm See section Elo anas eg res ICOMPONENTEND New report trigger word
51. s Remaining Click to register license of CNC Reporter Register License Initial CNC Reporter Template Se CNC Reporter Options Admin Enable Disable Admin Options Output Enable Disable Output Options Unprotect Sheet Password Change Protection Password Protect Unprotect all sheets Unprotect Sheets Protect Sheets If required the white area at the top of this template can be modified and images can be added to create a customised template that can be used instead To create a customised template open the existing template file in a new instance of Microsoft Excel make the necessary amendments and save as an Excel template xlt or xltx file extension NOTE Do not amend cell positions or data column headings To use a customised template for all Probing Inspection Reports relating to a single data results file navigate to the Admin tab and select the ellipsis button tothe right of the location and file name of the default template within the Administration panel Navigate to and select the required alternative template The location and file name of this template will now be displayed in the Initial CNC Reporter Template field Where a results file contains inspection data for multiple parts it is also possible to vary the template used dependent on the part inspected Select Custom Templates OFF in the Initial Set Up Data panel within the Start tab This will toggle the setting to Custom Te
52. shaw CNC Reporter Capability Chart Data 7 Overview 7 Admin Z Templates A Start tab Floating window CNC Reporter Control Panel Initial Set Up Data RENISHAW emm Click to Collect Data automatically Lock RE Work Centre ID Demo Setu i m Stop Data Collection CT apply innovation Data Retrieval Method Poll Time 20 secs Name Name IV Auto Click to Collect Data from a stored Text File Collect Data FILE IMPORT Click to Create Capability Chart Compile Capability Chart Click to remove all existing Inspection Sheets Clear Data Machine Type Demo Machine Iv Auto Initial Prefix Sample Sample ID amp IV Auto Initial Number 1 Units Metric View Template Map Delimiter Set Controller Type I Fanuc Macro Click to create a Saved file without macros Backup Directory Location Create Arch Greate Archive C CNC_Reporter peu Activate Quality Warnings New Part Inspection Sheet Trigger Word Specified Limits Warning Limits COMPONENTEND r r Maximum Number of Worksheets Warning Limits Multiplier 75 0 Inspection Sheets Chart Overview i Redisplay Quality Warnings v M gt M Start A001 1 A001 2 7 B002 3 B002 4 A001 5 A001 6 B002 7 B002 8 Various 9 Merrie keira r BP TT 5 4 m GN Read
53. ust below Default is deleted The ddeexec key has open 1 removed from the Default key See also Microsoft Knowledgebase Article 2636670 covering How to open Excel files in separate windows in Windows 7 NOTE Microsoft Office updates may restore these registry keys to their original settings CNC Reporter will detect this and when next opened will ask to run an executable AMEND EXCEL REGISTRY exe which will return these registry keys to the settings CNC Reporter requires Administration rights on the PC are required to enable this executable to run Problem When using REAL TIME data import multiple instances of the results data are imported and the source file is not deleted Cause The results data file being imported into Renishaw CNC Reporter contains the word demo in the file name Solution Rename the results data file In the CNC Reporter Control Panel on the Start tab select Collect Data REAL TIME and in the File Open dialog navigate to and select the renamed file Renishaw CNC Reporter user s guide 45 This page in intentionally left blank Renishaw plc T 44 0 1453 524524 RE R IS HAW ns New Mills Wotton under Edge ied Ges 524901 e Gloucestershire GL12 8JR Me eee e TM United Kingdom www renishaw com apply Innovation For worldwide contact details please visit our main web site at www renishaw com contact H 5464 8501 01
54. y I Blaa ve 2 0 65 The Renishaw CNC Reporter Start tab comprises two panels CNC Reporter Control Panel Initial Set Up Data CNC Reporter Control Panel Initial Set Up Data Custom Templates ON Click to Collect Data automatically Lock Work Centre ID Demo 1 Setu Stop Data Collection r various Data Retrieval Method Poll Time TEXT 20 rr secs Click to Collect Data from a stored Text File Name Nme W Auto Collect Data FILE IMPORT Machine Type Demo Machine M Auto Click to Create Capability Chart initial Prefix Sample ID amp Iv Auto Compile Capability Chart weg Click to remove all existing Inspection Sheets Clear Data Delimiter Set Controller Type Fanuc Macro Click to create a Saved file without macros Backup Directory Location Create Archive C CNC_Reporter New Part Inspection Sheet Trigger Word Activate Quality Warnings Specified Limits Warning Limits E 5 Maximum Number of Worksheets Warning gis m ee e T T er Redisplay Warnings Iv Iw The CNC Reporter Control Panel is used to select the data file for import and to initiate the creation of the Capability Chart Options allow the calculation of warning limits derived from tolerance values within the inspection data and the display of Specified Limits tolerance and Warning Limits on the chart The nitial Set Up Data panel is used to define information contained within the header section of each Probi
55. y 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 0400 0 0400 0 1000 0 1000 PASS A001 1 Sample 3 23 May 12 02 BORE 40 00MM T02 SIZE 40 0000 40 0300 0 0300 0 1000 0 1000 PASS A001 1 Sample 3 23 May 12 02 BORE 40 00MM T02 POSITION X 12 5000 12 4600 0 0400 0 0500 0 0500 PASS A001 1 Sample 3 23 May 12 02 BORE 40 00MM T02 POSITION Y 10 0000 10 0400 0 0400 0 0500 0 0500 PASS A001 1 Sample 3 23 May 12 03 WEB 25 20MM T02 SIZE 25 2000 25 1500 0 0500 0 0500 0 0500 PASS A001 1 Sample 4 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 0900 0 0900 0 1000 0 1000 PASS A001 1 Sample 4 23 May 12 02 BORE 40 00MM T02 SIZE 40 0000 39 9500 0 0500 0 1000 0 1000 PASS A001 1 Sample 4 23 May 12 02 BORE 40 00MM T02 POSITION X 12 5000 12 5300 0 0300 0 0500 0 0500 PASS A001 1 Sample 4 23 May 12 02 BORE 40 00MM T02 POSITION Y 10 0000 10 0100 0 0100 0 0500 0 0500 PASS A001 1 Sample 4 23 May 12 03 WEB 25 20MM T02 SIZE 25 2000 25 2500 0 0500 0 0500 0 0500 PASS A001 1 Sample 5 23 May 12 01 Z TOP SURF T01 POSITION Z 0 0000 0 0300 0 0300 0 1000 0 1000 PASS L 44 gt H Archive Query dis TT ARIE o 7 Nat D gt The Archive Query tab presents a tabular view of the inspection data retrieved by Data Manager based on Machine Date range and Part number selections Overview tab CP CPk Span Average StdDev Nominal Upper Tol USL Lower Tol LSL Max Min Part Number Operation ij Feature Date Sample ID Sample 3 Sample 4 Sample 7 Sample 8
56. y of the United States Government under the terms of i a United States Department of Defense contract then pursuant to DOD FAR Supplement 227 7202 3 a the United States Government shall only have the rights set forth in this Licence or ii a civilian agency contract then use reproduction or disclosure is subject to the restrictions set forth in FAR clause 27 405 b 2 i entitled Acquisition of Existing Computer Software and any restrictions in the agency s FAR supplement and any successor regulations thereto and the restrictions set forth in this Licence This Licence is governed by English law and the parties submit to the exclusive jurisdiction of the English courts Renishaw CNC Reporter user s guide 5 Contents About Renishaw CNC Reporter usesioure nt curn pio E Gal tur R pnta ut uU ocu suat m pn Publ sss E seRERUI cU IER UUUME 7 Compatibility and system reoguiremmente nennen nnne nnne nnns 7 Data e reide len LE 7 Se e rj RR H Customise the Productivity post processor nennen nnne nnn rs 8 Indicating a new component in an inspection report 8 Installation and product registraton 9 Install Renishaw CNC Reporter EE 9 Renishaw CNC Reporter screen TAY OUT des egeeiegenget eegene ee gege deele 13 DN 13 Capability Chart Data tab EEE EE NE 14 END 14 AMIN TAD EE 15 KES 4 21 150 REE EE E EEE NE 16 Using Renishaw CNC FN E 17 MAN 17 Register Renishaw CNC Reporter rrrvrrnnnnnnvvnrnnnnnnnvvvnnnn
Download Pdf Manuals
Related Search