Manual english - AdvancedTools
Contents
1. Ee ss Add Ins available iW AdvRptV2AX AddInConnect Analysis ToolPak Analysis ToolPak VBA Euro Currency Tools i F Solver Add in Browse SReport2AX AddInConnect Ec 35 38 vigilantplant YOKOGAWA The clear path te operational excellence Deutschland GmbH If the VSTO runtime encounters a problem loading the add in you ll see this message instead Load Behavior Not Loaded A runtime error occurred during the loading of the COM Add 5 in 10 1 2 Find the problem Set the VSTO_SUPPRESSDISPLAYALERTS environment variable to 0 Then go back to the registry key mentioned in step 1 and set the LoadBehavior to 3 Now restart the Excel You should be able to see a dialog describing what is happening Microsoft Office Application Add In An unhandled exception occurred in your application Contact your administrator or the author of this document for further assistance HK This is an intentional exception injected for demonstration purposes XEXXXEXXXEXXXXEX Exception Test HHMEHMERMEHMEE System Exception This 12 an intentional exception injected for demonstration purposes at MyExcelAddin T his amp ddln Thistddin StartupfObiect sender EventArgs e in c Auserskhaahmadidocuments visual studio 201 0 ProjecteinewMyExcel ddin MyExcel ddin T his ddln cs lime 15 at Microsoft Office Tools Addinimpl Onstartupl al It is also a good2. If the appropriate channels have been given tag names these will be shown in the report If no tag names are defined the channel number will be shown instead 3 4 1 Manual stabilisations selection With the stabilization selection it is possible to the stabilization time manual The calculated stabilization time will be set as default value 15 38 vigilantplant The clear path to operational excellence YOKOGAWA 4 Deutschland GmbH 4 Furnace templates With the furnace template it is possible to create a template for a lot of furnace with different settings Use the button Add Change delete and Save to modify the entry values for the different furnaces E z l Sample_1 G Fumacer Informationen Measurement Data Report Settings Q Sample 2 Sample 3 Company Mame Company Performing Survey Certificate No Furnace Name Furnace Location Furnace Serial No Charge Number Survey Recorder Survey Type TC Set Date Next Due Approved for Use Engineer Approved by Yokogawa g Yokogawa Deutschland BestFumaceCompany Cert ABC123 Fumacer Number 1 Station 3 SER12345 CUST20130405 Yokogawa DXAdvanced Periodic XYZ 10 12 2013 500Deg C 2100 Deg C D Jones M van Cleve y Visible J Visible y Visible 9 Visible v Visible iw Visible Iv Visible v Visible 4 Visible 7 Visible 7 Visible v Visible v Visible W Visible E Visible E Visible Visible 9
3. 32Bit 6 38 vigilanti ioni YOKOGAWA The clear path to operation excellence Deutschland GmbH 1 Download Load the latest version of our solution from the following web Page http www AdvancedTools de Check there for Version 2 and TUSReport Version 2 1 1 Internet Explorer Message If the Internet Explorer Function enables SmartScreen Filter you get sometime the following Message Window SetupTUSReport2 R2 1 22 0 20131105 exe is not commonly downloaded and could harm your computer Delete Actions View downloads SmartScreen Filter Click Actions d This program might harm your computer Publisher Unknown Name SetupTUSReport2 R2 1 22 0 20131105 exe SmartScreen Filter reported that this program is not commonly downloaded and is not signed by its author If you received this program as an unexpected solicitation link or attachment it might be an attempt to fool you We recommend that you delete it D Don t run this program Delete program v More Options What s SmartScreen Filter Click Don t run this program otherwise it has been download again 7 38 vigilanti ioni YOKOGAWA The clear path te operational excellence Deutschland GmbH 2 Starting the program The program shows the header TUS Report in the Menu bar of Microsoft Excel The program is controlled via the add in menu e Uniformity survey report e Print e Template creator e Fur
4. option the print preview with the appropriate test protocol pages will be shown It is possible to then either select a printer or to save the test as a PDF file A PDF printer is required for this EJ Microsoft Excel TUSTemplate1 al Eu Preview Page 1 of Print preview 29 38 YOKOGAWA 4 vigilanti ioni Deutschland GmbH Tha dua path to operaho al excellence 8 Generating Excel templates Through the report function Excel Template it is possible to use all functions of MS Excel For simple generation of the templates there is a Template assistant Data Review View Developer Fite Home Insert Page Layout Formulas gt El r i dd Info R P e CH Error handling urnace T C Correction Settings gt Ha A Uniformity Print emplate mplates factor Survey Report creator Tll Report Templates TUSReport TUSReport Settings TUSReport Help 8 1 Creating a template Having clicked on Template creator there will be a window shown with the device information In this window all information relating to the specific recorder data is listed TUSRepon2 y Tempenstuns E urdormay Template With the Drag amp Drop functionality you can add information to the Excel sheet 30 38 vigilanti ioni YOKOGAWA The clear path te operational excellence Deutschland GmbH TUSReport2 Uniformity Ed Hj Temperature uniformity een een a gt controllersetpoin
5. 2006 14 47 44 30 11 2006 15 55 16 S5F 105492 9 1250 C e s c 30 11 2006 15 55 28 30 11 2006 16 36 20 S5F 105492 10 11 Company Name CCSS Yokogawa 12 Compan Performing Surve ustomer Compan 13 Certificate No o M4567 14 Fumace Name FumaceB 15 Fumace Location JBuldimg 16 ChargeNumber CH O 17 Survey Recorder YokogawaDXA 18 SuvyTyp Periode O 19 CSt CDE O MN MN NN m zu 0 21 Approved for Usel A 30 33 EA Korrektur Faktoren an den Messwerten angewendet SeienNummer 750 C 850 C 950 C 1050 C 1150 C 1250 C Uniformity 1 SerialNumber1 o o o o ol o Uniformty2 SeialNumer2 D o o ol Uniformity 3 35 0 36 Uniformity 6 Seral Number6 o ol 37 Uniformity 7_ Seral Number o o o o o ol 38 Uniformity 8 Serial Numbers o o o o o ol 39 Uniformty9 Ser al Numbers 1 o o o o o ol 40 Uniformity t0 SeialNumer 0 1 1 1 1 1 1p o o o o o 0 41 Uniformity 11 Serial Number o o o o o ol 42 MN Vorlage Test Data Overview DXA_CC1 750 Data 750 ii sl Ready NUM Test Data The calculation results will be displayed on the overview page 26 38 vigilantplant YOKOGAWA The clear path be operational excellence Deutschland GmbH Ej Microsoft Excel TUSTemplate1 br
6. DER Be Edit View Insert Fue Tools Data Window TUS Report Help Adobe PDF Type a question for help B X f 1200 EA 8 MA t 6 o H 5 Jj K 4 3 n Furnace Temperature Uniformity Survey ES Calibration Correction Data from Configuration File 4 DA NADCAP NADCAP Information NewiDemo _Files Uniformity_Survey_Config1 PDL 8 Uniformity 1 Setpoint Number Measured Value T INNEN ERES ERR NN 600 599 H0 rt 15 Uniformity 2 Setpoint Number Measured Value True Value H6 ao 4002 al Ready DXA CC 27 38 vigilantplant YOKOGAWA The clear path be operational excellence Deutschland GmbH A tabular and graphic representation of all readings of the respective data files is portrayed on the following pages ES Microsoft Excel TUSTemplate1 Imp ux NA NAAA AN EN ATAN e Ki Ofen Temperaturstabilitat Ubersicht 3 Korrekturfaktoren sind nicht an den gezeigten Daten angewendet worden 4 Korrekturfaktoren des Rekorders sind an den gezeigten Daten angewendet worden 5 6 MAX Uniformity 1 Uniformity 1MAX Uniformity 2 Uniformity 2MAX Uniformity 3 Uniformity 3MAX Uniformity 4 Uniformity 4MAX ga A eee eee 8 30 11 2006 09 24 56 1060 men 1059 059 1058 1058 1059 1059 9 30 112006 09 2524 2313 2706 2311 2706 2312 2707 2310 2705 10 30 11 2006 09 25 52 4486 4
7. It is also possible to write manual settings into the fields 18 38 vigilantplant YOKOGAWA The clear path be operational excellence Deutschland GmbH Start your report E Insert measurement data gt ij insert correction factor gt Y Finalize your report Set Corretion Factor for each sensor V 11 12141516 7 8 9 10 Ld SURVEYT C SURVEYT C SURVEYT C SURVEYT C SURVEYT C SURVEYT C LOADT C SURVEYT C SURVEYT C 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Yokogawa Selection Combo box 19 38 YOKOGAWA 4 Deutschland GmbH vigilantplant The clear path bo operohonal excellence 6 Create Report Test Protocol Under the menu item Uniformity Survey Report the test protocol is created The report assistant takes you through each point of the test protocol There are three screens shown in total The individual settings are requested and checked for completeness 6 1 Main The highlighted window consists of two entry fields The first part defines the free text fields How to modify free text fields can be found in Options 3 2 Use the combo box to change the entry The second part defines the measurement data s common settings Each threshold has its own temperature the maximum permissible deviation and the set point of the furnace temperature controller ae Dem one a o insert correction factor gt Finalize your report Start y
8. les E pf S File Edit View Insert Format Tools Data Window TUS Report Help Adobe PDF Type a question for help B X d Al el Ofen Temperaturstabilitat Ubersicht Korrekturfaktoren sind an den gezeigten Daten angewendet worden 4 Korrekturfaktoren des Rekorders sind an den gezeigten Daten angewendet worden 5 EM AA J a 3 LI m 7 TCAmah Minimum Maximum Overshoot Minimum Maximum Over ee 3 M j oE A Bee Of o 3 85 AAA K 85 752 2 85 O 752 2 85 Uniormiy5 85 Vois i 85 85 85 85 85 KOSTER 7503 7509 7528 8489 85 1 Max Abweichung 01 o 28 4 29 5 20 TCAnzahl Uniformi 1 Uniformity 7 Uniformity 7 Uniformity 14 Uniformity 10 Unifor 21 BESTANDEN FEHLGESCHLAGEN BESTANDEN BESTANDEN BESTANDEN BESTANDEN BESTANDEN BESTA 22 Erstes und Letztes TC in der Spezifikation 000000 009 23 Stabilisierungspunkt 00 34 12 30 11 2006 11 41 20 30 11 2006 12 26 08 00 4 00 00 00 00 00 00 00 00 co in on on on on om om on con ed Ried Med Died SS SSL ofofo 6 Co en co t a jw 4 HA Vorlage Test Data Overview DXA_CC1 Z 750_Data 750 Graph 850 Data le al Ready NUM Overview Data for the CC1 Option are displayed on the sheet DXA CC1 Ej Microsoft Excel TUSTemplate1 EE
9. my add in does not load What is the problem This is a common question which came across many times in Forums Here are simple and quick checks that you can do before you start scratching your head or jump to the Forums I ll be using Excel as the Office application but the approach is applicable to others more or less 10 1 1 Check out COM Add Ins dialog in Excel Now open Excel and see if your add in loads successfully If not open Excel Options dialog File 2Options and navigate to Add Ins tab e gef e 8 mg E J e Daks General af oe e View and manage Microsoft Office Add ins Formulas Proofing Add ins Save Name Location Type Solver Add in CA Microsoft Ottice Ofticel4 Library SOLVER SOLVER ALAM Excel Add in Language Team Foundation Add in C Common7 IDE PrivateAssemblies TFSOfficeAdd in dll COM Add in TUSReport2AX AddInConnect C Program Files x86 TUSReport2X TUSReport2AX dll Excel Add in Advanced Visual Studio Tools for Office Design Time Adaptor for Excel CA O A Visual Studio Tools for Office x86 VSTOExcelAdaptor dil COM Add in Customize Ribbon Document Related Add ins Quick Access Toolbar 3 file ort2 TUSReport2 bin Debug TUSReport2 vsto vstolocal COM Add in Add in Yokogawa TUSReport2 Trust Center 1 Publisher lt None gt Compatibility No compatibility information available Location file D VB Net Yokogawa TUSReport2 TUSReport2 bin De
10. practice to enclose the code inside the add in s startup event in a try catch block and log all exceptions 10 1 3 Make sure your add in is installed correctly and it is enabled Open registry editor and navigate to HKEY CURRENT USER Software Microsoft Office Excel Addins Here is how this registry key looks like after installed MyExcelAddin E Regale Edito De Dd Yee Fpunbe Dep Mee Type ua se Tus it ap t7 vale nof sek feet Feo C VE soris Firowart gea LL ab andre PEG SI PA cabin DICEN MES DoD ICON CAN hie IC ara ha ahi A Oey rene PE oo er PME cond ei Debug Het cen enn Al Computer HOY CURRENT LEER Soften Piraten D The registry string we are interested in the most is the LoadBehavior Whenever you see 3 Loaded at Startup as the value of this string you are good in this part and your add in tries to load when the Excel starts For more information about registry entries for application level Office solutions see this article on Microsoft site http msdn microsoft com en us library bb386 106 aspx 36 38 vigilantp lant YOKOGAWA The clear path bo operational excellence Deutschland GmbH 10 2 Before ask your Service Team To solve the problem please use the Error handling routine under lt Error Handling gt We needs these information to check an solve a problem File Home Insert Page Layout Formulas Data Review View Developer Yokogawa Yokogawa Ow E 1 Y E
11. 782 4487 4782 4486 4782 4486 4780 11130 11 2006 09 26 20 5874 6073 5874 6074 5874 m 5874 6074 12 687 3 13 30 11 2006 736 0 14 30 11 2006 09 27 44 748 1 1 152 1 16 152 2 17 30 11 2006 09 28 12 7500 702 7500 7503 7501 75802 7499 7503 AR 1320 44 nni ade 4 ACUL EA Ton A FEN FEN N Ten 4 TEE UC vn 0 Eh ST OL E M j s IN 4 WA Vorlage Test Data Overview DXA CC1 750 Data 750 Graph 850 Data lt ji gt Ready NUM E Tabular data displa PAE Test Temperatur ThE C Stabilit t TAA Stabilit t Unitormity 1 Uniformity 1 Uniformity 2 Uniformity 2 Uniformity 3 Uniformity 3 Uniformity 4 Uniformity Uniformity E Uniformity E Uniformity 6 Uniformity 6 Jill Ready Graphic data displa 28 38 vigilanti ioni YOKOGAWA Tha dear path lo operelianal excellence Deutschland GmbH 7 Print Report The program includes a print function which will print the complete report with all pages and sequential page numbering Home Insert Page Layout Formulas Data Review View Deve Ei git p E Info Ce E f y SA Error handling Uniformity Template Furnace T C Correction Settings Survey Report creator templates factor f Help TUSReport TUSReport Templates TUSReport Settings TUSReport Help Menu list with Print option After clicking the Print
12. Data DX100 DX200 DDS Display Data DEV Event Data DX1000 DX1000N DX2000 DAD Display Data DXAdvanced DAE Event Data www DAQStation com DX1000 DX1000N DX2000 R4 DSD Display Data DXAdvanced R4 DSE Event Data FX100 DDS Display Data DEV Event Data DX100P DX200P DBD Display Data Pharma Model DBE Event Data MW100 MX100 MXD Data For the analysis using a PC the following minimum hardware requirements must be met e Hard disk capacity 13 MB e Memory 1GB 5 38 vigilanti ioni YOKOGAWA The clear path bo operational excellence Deutschland GmbH 3 2 Software The program TUSReport Version 2 is Windows based and requires therefore a Windows Operating System 3 3 Prerequirement Windows Net Framework 4 Full installation is checked by setup o http www microsoft com en us download details aspx id 17718 Microsoft OFFICE NET Framework VSTO installation is checked by setup o http www microsoft com en us download details aspx id 35594 3 4 Operating System The program has been tested on the following platforms Windows XP Professional SP2 Windows 7 32bit Windows 7 64bit Windows 8 64bit Note Operation under Windows 8 has not been fully tested at the time of writing this manual Also the program Microsoft Excel is required The program has been tested with the following Microsoft Excel Software versions Microsoft Excel 2010 32Bit Microsoft Excel 2013
13. Factor 30 TR Other Color of minimum line PB Blue ai Color of maximum line lll Red License Sice Chart Calculation Line 1 Color of stabilisation line Mill Blue Sice Chart Calculation Line 1 channel color Bg DarkViolet channel color 7 PaleTurquoise No color on data sheets channel color El Peru channel color Khaki channel color EJ HotPink channel color S LawnGreen channel color El Coral channel color DarkSalmon channel color y LightG reen channel color C Bisque channel color Bg Sienna Chart tab 3 3 1 Color settings With this tab it is possible to change the line colors for the charts The Min Max values colors are settings with the Color Table value 3 3 2 Line strength The line strength of the individual trend lines can be between 4 strengths can be selected 3 3 3 Zoom range The zoom factor defines the range over and under the test temperature The value Null set the factor to default 13 38 vigilantplant YOKOGAWA The clear path te operational excellence Deutschland GmbH 3 4 Change language License YOKOGAWA 4 License Q9 Data File Informations License 9 Detail Information Field Comments Language Other Q9 Color o Em english License License No i Name Yokogawa save serialno License tab 3 4 1 Change Language By using the button Language the program can be
14. S Info Error handling Uniformity Print Template Furnace T C Correction Settings gt Surrey Report creator templates factor E Help TUSReport TUSReport Templates TUSReport Settings TUSReport Help Error handling routine Default Data Directory Coser yef00764 Desktop create Error Log Menu Error handling routine E Error Log was created C Users Desktop 20130617_1528_ TUSReport Log file saved The Windows Explorer will be open Please send the files with exact error message and if necessary the file to be converted to the normal service email address shown in the program 37 38 vigilanti ioni YOKOGAWA The clear path te operational excellence Deutschland GmbH lt End of Document gt 38 38
15. Visible 7 Visible M Visible Visible Visible Visible 7 Visible 7 Visible Visible 7 Visible 7 Visible Report Header Entry tab There are 14 user definable text fields available for selection These can be displayed in the test overview or footer of the report To setup more than one Furnace Template use this tab Check chapter 3 2 Textfields Fields for setting different text items for the report header 16 38 vigilanti ioni YOKOGAWA The clear path bo operational excellence Deutschland GmbH YOKOGAWA 4 Sample 1 el Sample_1 Sample_1 Sample 2 Sample 3 Measurement Counter 6 Test Temp Uniformity Controller Setpoint Temperature Value 750 750 recovery test Temperature Value 850 850 recovery test Temperature Value 950 950 recovery test Temperature Value F recovery test Temperature Value 1150 1150 recovery test Temperature Value 1250 E recovery test Temperature Value recovery test Temperature Value recovery test Temperature Value ecovery test Temperature Value ecovery test Temperature Value ecovery test Temperature Value ecovery test Yokogawa Data file To set the different temperature settings and tests use this tab YOKOGAWA 4 Sample 1 ri Sample 1 Sample_1 9 Sample 2 9 Sample 3 Excel Template C Users Public Desktop TUSReport_Sample sample_1 TUSTemplate EE Configuration Fil
16. am TUSReport TUS Temperature Uniformity Survey for Microsoft Excel outputs the collected data from the test protocol and generates a report as documentation of the conducted test A requirement for these functions is the existence of the displays data files and or the Event display files in a file on the windows PC Through the FTP client a function of the Yokogawa recorders it is possible to store the files on the PC An FTP server program is required on the windows computer This is a standard component in the Windows XP and all newer Windows operating systems as a special feature which requires activation In other operating systems the use of freeware or shareware FTP server is recommended You can find further information in the user manual of the recorder or on our webpage For updates and changes about the program please read the info file stored in the installation folder or contact your Yokogawa sales team 2 Revision Date version Det O Z 05 2013 First creation TUSReport Version 2 09 2013 Update Recorder List and some chapter 11 2013 Update Recorder List and some chapter 4 38 vigilantplant YOKOGAWA The clear path to operational excellence Deutschland GmbH 3 System Requirements 3 1 Hardware For the documentation of the test a paperless Data recorder is required The Data recorders listed below are supported by the Add in GX20 GP20 GDS Display Data www smartdaq com GEV Event
17. bug TUSReport2 vsto vstolocal Description Create a report for Nadcap organization c by Yokogawa Deutschland GmbH Germany Dev M van Cleve Excel Add ins Y 89 5 Excel Add ins COM Add ins 4 Actions XML Expansion Packs Disabled Items Manage 34 38 vigilantplant YOKOGAWA The clear path bo operational excellence Deutschland GmbH The items listed below were disabled because they prevented Excel from functioning correctly Please note that you may have to restart Excel for these changes to take place Select the ones you wish to re enable Addin vokogawa tusreport fle d vb net vokogawa tusreportz tusreport2 bin debug tusrepor Healthy add ins show up as Active Application Add ins however if an add in is disabled for whatever reason it will appear under the Inactive Application Add ins You can select the COM Add ins from the Manage dropdown at the bottom of this dialog and see the LoadBehavior of all COM add ins In normal cases the add in should be checked and its Load Behavior should be Loaded at Startup Il 7 X Add Ins available a Team Foundation Add in CT Visual Studio Tools for Office Design Time Adaptor for Excel E Y Yokogawa AdvRpt COM Add In for Excel Isl Il rokogawa TUSReport2 i Remove Location C Program Files x86 TUSReport2 TUSReport2 vsto vstolocal Load Behavior Load at Startup
18. d Under default template a Excel sheet can be defined as the default template At the report generation the template can still be changed for another The standard template defines the folder location to look for the data file and where to send the completed report These settings will also be requested confirmed during the composition of the report With Report filename the name of the finished report is defined 9 38 vigilanti ioni YOKOGAWA The clear path te operational excellence Deutschland GmbH Use the following sign for a predefined name TO1 bis 114 Entry of the 14 user definable text fields Hour of the first file O Original file name of the first file In the expanded display the stabilization point is shown for each file in the report Insert the path to the Software DAQStandard Viewer into the Viewer Text field 3 2 Textfields Fields D CAE iSem YOKOGAWA Detail Information Field A CH Data File Informations Detail Information Field O I Detail Information Field Overview Emtee Comments mi qii rees Other Detail Information Field 1 Company Name i Visible Visible 9 Color Detail Information Field 2 Company Performing Survey Y Visible 7 Visible License Detail Information Field 3 Certificate No v Visible Visible Detail Information Field 4 Fumace Name Visible 7 Visible Detail Information Field 5 Fumace Location v Visibl
19. e Visible Detail Information Field 6 Fumace Serial No Y Visible 7 Visible Detail Information Field 7 Charge Number 4 Visible F Visible Detail Information Field 8 Survey Recorder Y Visible Visible Detail Information Field 9 Survey Type 4 Visible Visible Detail Information Field 10 T C Set Y Visible 7 Visible Detail Information Field 11 Date Next Due Y Visible Visible Detail Information Field 12 Approved for Use V Visible Visible Detail Information Field 13 Engineer Y Visible E Visible Detail Information Field 14 Approved by Y Visible Visible Default V Add Date to footer V Add File Name to footer 3 2 1 Free defined Labels There are 14 user definable text fields available for selection These can be displayed in the test overview or footer of the report The position of these fields in the report can be set using the checkboxes If the checkboxes unchecked or the text field is empty in the main form the text field is invisible 10 38 vigilantplant YOKOGAWA The clear path to operational excellence Deutschland GmbH 3 2 2 Put file name and date into footer Please check these fields to put the information into the footer of each page 3 1 Comments Comments Data File Informations Comments 9 Detail Information Field JComments V Visi Other Comment 1 Comment 1 J Visible Q9 Color Comment 2 Comment 2 V Visibl
20. e License Comment 3 Comment 3 Y Visible Comment 4 Comment 4 v Visible Comment 5 Comment 5 Y Visible Comment 6 Comment 6 v Visible Comment 7 Comment 7 7 Visible Comment 8 Comment 8 Y Visible Comment 9 Comment 9 v Visible Comment10 Comment 10 v Visible Comments tab y 3 1 1 User definable comments For better definition of comment fields in the main body extended comments can be entered here If the text field is empty in the main form the comment field is invisible 11 38 vigilantp lant YOKOGAWA The clear path Io operational excellence Deutschland GmbH 3 2 Other YOKOGAWA 4 Data File Informations Detail Information Field Comments Ga Temperatur Unit M pel Advanced View icense Stabilisation Factor D2 Setting tab Data file If a DXAdvanced is chosen there is the additional possibility to enter channel calibration correction data into the test CC1 option 3 2 1 Temperature unit If another temperature unit is required this can be entered here DegC F 3 2 2 Stabilisation Factor With the stabilisation factor the maximum divergence of the measuring value is defined over a period of 6 minutes 12 38 vigilanti ioni YOKOGAWA Tha dear path to operelianal excellence Deutschland GmbH 3 3 Chart YOKOGAWA 4 Color Data File Informations 9 Detail Information Field m Comments Chart Zoom
21. e DXAdvanced CC1 C Users Public Desktop TUSReport_Sample sample_1 CC1 DXA_750 ES Default Data Directory C Users Public Desktop TUSReport_Sample sampie_1 Stability period 30 T si 7 Set Corretion Factor for each sensor Data period gt Channel exclude 1 Sample 12 13 14 40 41 Group Channel include 20121 22 23 24 25 26 27 28 29 3011 Default Taget Directory C Users Public Desktop TUSReport_Sample sample_1 en uum Yokogawa Report layout On this tab it is possible to setup a different default template for each test furnace Also the stabilization test period is setup on this tab To exclude some channels add the channels into the text box The selected channels are not shown in the report Separate each channel with a pipe sign 17 38 vigilantplant YOKOGAWA The clear path be operational excellence Deutschland GmbH 5 Correction Factor templates With the correction factor template it is possible to create a template for a lot of different thermo couples Use the button Save and Cancel to modify the entry values for the different thermo couples YOKOGAWA Correction factor table With this table it is possible to define 20 different Thermo couple with Serial number an 12 temperature entry On Tab 2 of the creating report Form it is possible to select different Thermo couple
22. mment 10 Yokogawa Comments tab 24 38 vigilanti ioni YOKOGAWA The clear path do operational sxcallence Deutschland GmbH YOKOGAWA Stabilisation time 750 Filename Name Recorder Serial No Start End 000040_R 02 08 0038 DAE DX2000 S5G505 28 04 2008 17 23 30 000 29 04 2008 07 30 00 000 msgSetStabpoint 29 04 2008 Set time manuall 6 4 Create test protocol After pressing Create report the test will be run in the background A file with the following data sheets is generated e Cover sheet with graph e Test Data e Overview e DXA_CC1 if selected e Actual temperature data in Tabular form e Actual temperature data in graphical form 25 38 vigilantplant YOKOGAWA The clear path bo operational excellence Deutschland GmbH EJ Microsoft Excel TUSTemplate1 dl Sele 5 Be Edit View Insert Format Tools Data Window TUSReport Help Adobe PDF Tynes questonforhelp y 8 xX i 1 ul Aa 100 MM emt Ofen Temperaturstabilitat Ubersicht 3 Test__ Stabilitat Test Start Datum TestEnd Datum Recorder Serien Nu 4 750 C T 6 C 30 11 2006 09 24 56 30 11 2006 10 02 04 S5F 105492 5 850 C 6 C 30 11 2006 11 40 28 30 11 2006 12 26 08 S5F 105492 6 950 C 5 C 30 11 2006 13 16 16 30 11 2006 13 58 08 S5F 105492 7 1050 C_ 5 C 30 11 2006 13 58 28 30 11 2006 14 47 32 S5F 105492 8 1150 C 5 C 30 11
23. nace Template e T C Correction Factor e Settings e Error Handling e Info Home Insert Page Layout Formulas Data Review View Developer Yokogawa Yokogawa E E i Info en O M ES SA Error handling Uniformity Print Template Furnace T C Correction Settings survey Report creator templates factor Y Help TUSReport TUSReport Templates TUSReport setings TUSReport Help Vokoda ni Ribbon The individual menu items are explained in the following chapters Tip After successful installation please check your settings Menu item Settings 8 38 vigilanti ioni YOKOGAWA The clear path te operational excellence Deutschland GmbH 3 Settings Items under the menu choice Settings must be processed before the report creation Using the Save Cancel and Transfer buttons the settings are confirmed rejected and are then made available in the report 3 1 Data File informations DB YOKOGAWA 4 e Data File Informations D e Data File Informations 9 Detail Information Field 9 Comments Q9 Other Color License Default Taget Directory Default Data Directory Default file name 0 Default Viewer DX Advanced Default Viewer Software MVv 100 Tab Report details mum 3 1 1 Template Directory In order to customize reports to your specific needs reports can have special header sheets applie
24. nnnnnnnnnnonononinnnnnnnnnnnnnnnos 15 CE Re KE 15 3 4 1 Manual stabilisations selection EE 15 As m 16 oc Conecuon Factor Te Di ee e er E EE 18 MEE ici Report T e aA PrO EE 20 A E POD EE A E E E E 20 02 Thermocouple Correction e 23 0 9 Enter COMME Sustrato dalt int 24 64 Create test Protocolo olaa 25 T POR PON E 29 EE 30 WE er bucetseoagseasenteusiuseannaeiecetomeenaseeteceusieteoncaetiecet etd 30 6 2 Custom design template header footer ssiirinicni ciclistas 22 e Eeer EE 52 GZ c mH 33 vigilanti ioni YOKOGAWA The clear path te operational excellence Deutschland GmbH DIU AA o A A E E ES 34 10 1 SONS Problem Dy yoursel noite icroseciasco oriente soria 34 10 1 1 Check out COM Add Ins dialog in Excel ssnnneoeesssesonnnsssssssssseeersssssssseseresssssssses 34 10 2 PP cee 36 10 1 3 Make sure your add in is installed correctly and it is enabled 36 10 2 Betore ask your Service Tea nun ee ee ine 37 3 38 vigilanti ioni YOKOGAWA The clear path to operational excellence Deutschland GmbH 1 Introduction The leading players from the aviation industry have set up a program for common working and management practice under the name Nadcap National Aerospace amp Defense Contractors Accreditation A part of the program is dedicated to the registration and documentation of component testing The progr
25. on the correction factor for each channel should be entered on the next page 21 38 vigilanti ioni YOKOGAWA The clear path te operational excellence Deutschland GmbH Activating the Checkbox One correction factor per T C set reduces the number of correction factors per channel to one only The stability time defines the minimum duration of the stability in the respective temperature profile Tip Most of these entries will be saved and with new tests it will not be necessary to re enter all details During the test interval data reduction takes place to simplify the report Only the data in this interval are portrayed in the report In addition all further relevant data outside of this interval are considered in the report and are portrayed in the overview Channel exclude 1 Group Channel include 1r 1 1 21415 6 718190101 Select different exclude Channel 22 38 vigilanti ioni YOKOGAWA The clear path to operational excellence Deutschland GmbH 6 2 Thermocouple Correction factor If all values are correctly entered use the Next button to continue In this window a serial number must be entered for each thermocouple A separate text box is shown for each channel If the checkbox Correction factor is activated a textbox for each sensor at each measurement point is shown The correction factors must be entered for each measurement point ID m 5 eg zem a YOKOGAWA Jj Start y
26. our report E Insert measurement data gt ij insert correction factor gt Finalize your report I Set Corretion Factor for each sensor 11 1214 516 7 8 9 10 Correctionfactor Templates Sample 500 C 750 C 950C 1190 C SURVEYTIC Serialno1 0 1 0 2 0 3 04 SURVEYT C Serialno2 07 0 8 0 3 0 1 SURVEYT C Serialno3 0 11 0 22 0 33 0 44 SURVEYT C Serialno3 0 11 0 22 0 44 SURVEYT C Seriaino3 0 11 0 22 0 44 SURVEYT C Seriaino3 0 11 0 22 LOADT C Seriaino3 0 11 0 22 SURVEYT C Serialno3 0 11 0 22 SURVEYTIC Serialno3 0 11 0 22 a 4 Yokogawa Sensor correction factors 23 38 vigilanti ioni YOKOGAWA The clear path te operational excellence Deutschland GmbH 6 3 Enter comments The final window of the report assistant defines the comment fields Definition of free comment fields can be found in Settings in section 5 4 There are six fields which can be added The first three are single sentence fields In the remaining three larger comments or notes can be added The comments are shown in the respective templates YOKOGAWA e Ip J Start your report Insert measurement data gt J insert correction factor gt w Finalize your report Comment 1 Comment 1 Comment E Comment 6 Comment 2 Comment 2 Comment 7 Comment 7 Comment 3 Comment 3 Comment 8 Comment 8 Comment 4 Comment 4 Comment 9 Comment S Comment 5 Comment 5 Comment 10 Co
27. our report gt Furnacer Templates Hast data Company Name Company Performing Survey Certificate No Furnace Name Furnace Location Furnace Serial No Charge Number Survey Recorder Survey Type TIC Set Date Next Due Approved for Use Engineer Approved by me 8 Yokogawa Main tab Sample 3 BestFumaceCompany Cert ABC123 Fumacer Number 1 Station 3 SER12345 CUST20130405 Yokogawa DXAdvanced Periodic XYZ 10 12 2013 500Deg C 2100 Deg C D Jones M van Cleve 20 38 Overview i Visible v Visible J Visible v Visible Visible Y Visible V Visible v Visible Y Visible Y Visible 7 Visible Y Visible Visible Visible Footer Visible Visible Visible 7 Visible Visible Visible Visible Visible Visible Visible Visible Visible F Visible Visible vigilantplant YOKOGAWA The clear path te operational excellence Deutschland GmbH Up to 12 test points can be entered Oe Sex insert correction factor gt Finalize your report o Measurement Jj Start your report E Insert measurement data gt Measurement Counter j Stability period 30 Test Temp Uniformity Controller Setpoint 3 500 Data period 1 750 3 950 Temperature Value 500 Temperature Value 750 Set Timestamps manually F Temperature Value 950 Temperature Value 1190 3 Channel exclude 1 em
28. perature Value i SES Group Channel include 1111 1214 516 718 9 10 Temperature Value Temperature Value bes Temperature Value Excel Template C Users Public Desktop TUSReport_Sample sample_3 TUS Template xlsx Configuration File DXAdvanced CC1 C Users Public Desktop TUSReport_Sample sample_3 config for 40 test PDL a data files File Path Recorder Typ Serial No Start Time End Time 28 04 2008 17 23 30 000 29 04 2008 07 30 00 000 C Users Public Desktop TUSReport_Sample s File Name 000040_R 02 08 0038 DAE DX2000 55G505495 25 Yokogawa Main tab Recorder Typ Serial No 000040_R 02 08 0038 DAE DX2000 55G505495 28 04 2008 17 23 30 000 29 04 2008 07 30 00 000 C Users Public Ser 694 28 04 2008 17 23 30 000 29 04 2008 07 30 00 000 vas 3kogawa Add files Using the datafiles button selects the data The Open data window shows when a point is selected a small sample of the general data information If an incorrect value is recognized this field will be shown in red Tip Use the Drag and Drop function for an easy file selection If the DXAdvanced recorder selected it is possible to add the configuration file with the CC1 option data There is a separate page printed in the report for these details If itis necessary to enter additional correction factors the checkbox Correction factor needs to be activated With this functi
29. set to another language Once another language is selected this will be implemented immediately Please re start the program to ensure proper operation after this step 3 4 2 Create new language data It is possible to translate the program into many different languages To create a new language perform the following steps 1 Copy the file english Ing from the Installation directory to a temporary directory 2 Re name the file according to the new language e g French Ing 3 Open the file and change the text behind the symbol 4 Save the new file you just created and copy back to the original installation directory 5 The new language can be selected in Excel after re starting 14 38 vigilanti ioni YOKOGAWA The clear path to operational excellence Deutschland GmbH 3 4 3 Serial number If the software is installed in demo mode entering a valid serial number and clicking on the save license button will unlock the software 3 4 4 Name Under Name company enter your company name A serial number with the registered company name can be obtained from Yokogawa Deutschland GmbH 3 4 5 Overview page The results of each test will be shown on one sheet as default By changing this option it will be create a separate overview page for the each test 3 4 6 Show extended data sheet Advanced View By activation of these functions the software put more information into the report sheets 3 4 7 Tag Name
30. t a o result Tabellet st 26 Gl result TY ee H comment norm 2 H textfield E Serial Number D stabilityperiod Drag amp Drop The entry is indicated by a small triangle in the upper right hand corner Clicking on this triangle will highlight the field The first two sheets of a template file are supported Note Each value can be used only once per sheet The template can be saved and used in Excel Default File format or as Excel template format 31 38 vigilanti ioni YOKOGAWA The clear path te operational excellence Deutschland GmbH 8 2 Custom design template header footer It is also possible to create a separate sheet for the automatically generated report sheet Create a template file with the following separate sheets Name the sheets TEST DATA 2 the report sheet with the test data OVERVIEW 2 the report sheet with the result overview DATA gt the report sheet with the temperature values e g 750 DATA adv3advpagestart YOKOGAWA R4C2 OVERVIEW SBS4 adv3advpagestart Start cell Separate sheets for the auto generated sheets To put the report on the different place like the cell A1 default use the cellname advpagestart You will find this placeholder in the template creator Also it is possible to put every other information from the template creator on every sheet in the report 8 3 Example data After the installation of the sof
31. tware some example templates are made available in the installation menu 32 38 vigilantplant YOKOGAWA The clear path to operational excellence Deutschland GmbH 9 Info In the Help dialogue box the version number and the address are shown in case of questions or support issues E TUSReport Temperature Uniformity Survey TUS reporting tool for YOKOGAWA DAQ Station Version 2 1 12 0 Built on 2013 06 09 01 14 Copyright 2013 Yokogawa Deutschland GmbH Ratingen Germany n TUSReport Version Z is Copyright 2012 2013 Yokogawa Deutschland GmbH Dipl Ing M van Cleve Yokogawa UK Ltd Dipl Ing D Jones Yokogawa Deutschland GmbH Dipl Ing M van Cleve Yokogawa UK Ltd Dipl Ing D Jones nformation Load the latest version of our solution from the following web Page http www AdvancedTools de Check there for Version 2 and TUSReport Version 2 33 38 vigilanti ioni YOKOGAWA Tha clear path lo operational sxcellance Deutschland GmbH 10 Error handling If an error is recognized in the conversion or in general running of the program this is indicated by an Alert window and registered in the error log IEEE Note PAN 1 Please read this chapter to solve the problem 2 Use the Error Handling routine before calling your Services Team 10 1 Solve Problem by yourself I installed my Office solution VSTO add in successfully but when I open the Office application
32. vigilantplant YOKOGAWA The clear path te operational excellence Deutschland GmbH The clear path to operational excellence vigilantplant TUSReportV2 Version 2 Temperature Uniformity Survey YOKOGAWA Deutschland GmbH Broichhofstra e 7 11 40880 Ratingen Germany Tel 49 2102 4983 0 1 38 vigilanti ioni YOKOGAWA Deutschland GmbH Contents EM UU dm 4 PX HRC VISIO m 4 Pr o 5 S U I tee ERE 5 32 OU Cu NT 6 29 AA m emm 6 S MEE Ee E 6 ENER e TOA C ee E a re e O o re 7 I T In met Explorer E 7 2 tasto The ONO 0 110 oorr mementos a gece oe Eur circa eue means ERE P o pone Rd Ee ET een 8 A A 9 s Data Pue torno ETE 9 SLL Template Di over ee re see aa 9 A FS 58 ol 8 SE Fields NIE ne EA BENENNEN NEN INNEN 10 24241 MC ee mec WE ee een ee 10 32 2 Purtile name and date 3060 Toter cerenuseroe22050279225500022105 907 ene 7030855 02792205 00020305 02 vpET EIUS SUA 11 SL COMME mm 11 ILL User A Table COMING ING oom ea ne ea ee er Eee 11 SEH d EE 12 321 Temp Tale rt ace pois eese A 12 322 DaB auoH o are ee ee ee re A 12 i MIA PA O A II e 13 Io E elle o NU A 13 Ioe AAA e e O EE ends 13 3993 OOO m 13 34 EEN e E ET 14 IL ER ee ee ade ee ie here 14 DNA Tea Dew Jangudpe E 14 o io A een ee nee een 15 VAN eg see o E A 15 3453 EE 15 3 4 6 Show extended data sheet Advanced View ooooooocccnnnnncnnonnnoon
Download Pdf Manuals
Related Search