Home

QTrans V2.0 User Manual - bei der Haller + Erne GmbH!

1. DRE order to reduce the data quantity and to limit No _ it to the relevant information In addition the oo a results presentation can then be adjusted for on each report interactively using filters Satan appear grouping and sorting options so that the actually relevant data is easily visible It goes TRES without saying that all reports can be printed or exported into a file XML or Excel format Figure 4 7 Drill down report 4 5 1 Dynamic Report The dynamic report shows new tightening results in real time as received from the tightening system in a list Per line the data of one tightening step is shown The following screenshot shows an example 20 QTrans V2 0 User Manual 4 Introduction Q Das transfer E FIDZI Operations Reports S ele creas reporter e coo IV Front Cover Drag a column header here to group by that column Operation S EUN DateTime ppiNol ppiesut Spinde Prg Step Resul QC L 000000003886 28 09 2005 15 54 05 1 1 Spindle 01 1 7A Angle high 0 00 260 25 250 L 000000003887 28 09 2005 15 54 27 1 1 Spindle 01 Angle high 0 00 260 25 7A 000000003888 28 09 2005 15 55 10 141 OK Spindle 1 1 3A OK L 000000003889 28 09 2005 15 55 24 1 1 OK Spinde01 1 94 3 00 0 1 00 50 00 L 000000003890 28 09 2005 15 56 11 1 1 Spindle 01 1 74 Angle high 10 00 260 25 L 00
2. CA N 0E0200 ER iz NOK API o 08 06 2005 16 59 33 AP17 11 08 06 2005 17 00 29 42 08 06 2005 17 00 58 42 OK 28 L 000000003884 26 09 2005 15 51 44 101 L 000000003885 28 09 2005 15 52 06 1 1 _ L 000000003886 26 09 2005 15 54 05 1 1 _ E lua waT al 2 0 0kB F un ee a A End of Cycle Report FTO Summary Report Root Cause Analysis 4 Introduction a iol xi y ey lcation O S OO a TE pel i eee ee ibn ge be NOK 42 3A 0 17 4985 50 131 NOK 42 0 06 Er maf f E da 0111500175 maf fJ 3A 0 11 5001 75 fa 3A 0 11 5001 T mf fJ 3A 0 11 5001 75 Aa 34 0 11 5001 75 mf fJ 3A 0 11 5001 75 mf 34 0 11 5001 75 Aa 3A _ 0 11 5001 75 Aa fJ 3A 0 11 5001 75 Aa 34 0 11 5001 75 mf fJ 3A 011 500175 mf fJ 3A 011 500175 mf fJ E EE a2 aa 04 5007 1 OK 12h fonfsonsa aia li ok 42 34 0 12 5001 50 mf fJ 3A 0 12 5001 50 a za jon 26025 oo nfa foo 2025 S a 7a ooo 26025 a za ooz 26025 aa an an 177 7 a _ A JV ignore invalid Trace Figure 4 9 End of cycle report 4 5 2 2 Root Cause Analysis This report shows a summarized listing of the NOK tightenings and sorts and or groups them according to the NOK reason The presentation can be displayed from the point of
3. Global ChO 1 Pro test Step 24 Category pre tonque SF 0600 LINE 0001 AA E fff 1100 Station Labor pet 2100 Part 2100 44 Characteristics Drag column header here to group by that column CEE EE D a M M i e kort reset ons T Neonrene vaul fet KField K0011 Ea Figure 6 29 Screenshot K field table multiple assignment 48 QTrans V2 0 User Manual 6 Configuration 6 5 Checking the K Field Values using Nutrunner Test Data The K field table described above for editing K field values on characteristic level can also be used for checking the generated data There all the data is basically shown in the same form as it will later be generated by QTrans and saved in the corresponding Q Das files For calling the test function button in the K field table must be called after that the file selection dialog for selecting a test file will be displayed see following screenshot a Q Das transfer configuration c program files bosch rexroth ag gtrans config ib K Field editor Ol x a File Edit Tools Window Help Q N o El g Global Look in E Exchange e ef EB v id Characteristics Haa 10001 Line 1 A gi 1300 oP 1 300m Fe Gil 133010713304 Drag a column header here t i nae Name Date modified Type Size Tags o H 1350 0P1350M ola i QTrans 04 09 2010 23 02 File Folder o H i Beceni Places selogOrigin
4. Cells Channel lt gt Spindle Figure 6 2 Screenshot Line editor empty The window is divided into three separate areas 1 Area for tightening cells Here information on the tightening cells registered in the system is displayed as tree Tightening cells tightening channels tightening programs and tightening applications 2 Area for the line Here information on the logic line structure is displayed as tree Lines stations and spindles 3 Area for part definition Here part types and tightening positions for the station currently selected in area are displayed In every area you can call a context menu by clicking with the right mouse button this menu contains the respectively valid commands The following sections show how a new station is created and completely configured 6 2 1 Creating a Tightening Cell For creating a tightening cell you must perform a mouse click in area of the tightening cells and select the new cell function This opens the window for the automated data entry and asks for data for the tightening cell to be newly created see following screenshot Add new cell x Cell name Zele Station 1 IP Address 10 23 232 180 Cancel OF Figure 6 3 Screenshot Parameters for new tightening cell 33 QTrans V2 0 User Manual 6 Configuration Here you must now enter the name and the TCP IP address of the tightening system the tightening cell After clicking on OK a
5. K Field editor fo File Edit Tools Window Help 0001 Line 1 H ji 1200 OF 1 300M Hil 1330 oP 13304 fil 1350 0P1350M Output Characteristics Drag a column header here to group by that column B MF 14001 0P1 400 qo eon events lm Bi orooro koe i Paea ed te E ie Jo eis DO fe e a CRT M D CE EC COTES O O 7 CEE S H A foo o 7 CU ao Cm do koe Patsdets a Vies ER CC O am ae Oe amp voeu io e J fps e aa owas oon e S CORTE Gl COTE A ets deta T CORTE O CE D DT SE fo eg Eg de a gt et Figure 6 32 Screenshot K field table test run result The generated K field data is displayed in column real output By means of the table s standard functions filter sort group the generated data can be further examined in the screenshot above the column filter is e g displayed at the real output column 50 QTrans V2 0 User Manual 7 Monitoring and Diagnosis 7 Monitoring and Diagnosis 7 1 QTrans Station Overview and Reports Apart from the station state the station overview in the QTrans main window Operations index card also shows counters for the number of received and correctly processed data packages See following screenshot Q Das transfer 2 00 00 114 Mil Operations Reports Operation Lastpartid Mode State Results Reiedted station state OPIN B Nomalpotcion Ee m rt J how eat OPT 3304
6. The ID code information is edited in the configuration editor In the line editor menu Edit gt Line the ID code processing which part of the ID code is used for which purposes for the station can be defined and then the selection criterion can be specified for the individual part types and or tightening positions The following screenshot shows an example E 0 Das transfer configuration dsrc projects datenerfassung opel usas v2 0 v2 00 00 100 doci resources qtrans coniig ib Line amp Part configurati an m File Edit Tools Window Help Cells Lines Parts Channel lt gt Spindle oo Pee Station Labor ID Code mask 444444444444444444444444444444444444444444444444444444444444 444TA y El Br 10 23 2322 190 Zelle Station 1 ff 0600 LINE 0001 4A ee H D testanw a 0 1100 Station Labor m 1 Ch D1 PO Ai LA 0002 Spindel Nr 02 BE 2 ch02P0 EE 0000test ree er M 0001 test 3step 70 Bolt 0001 Bosch Rexroth Zelle Station 1 Ch 0 1 App 0 PO test 2 70 Bolt 0002 Bosch Rexroth Zelle Station 1 Ch 0 2 App 0 PO test a a selector Ch 0 2 7 E 0003 test NOK 0047 VerficationPrg B 4 0003 Spindel Nr 03 oo 0000 test ff 0001 test_3step E 0002 xx 0003 test NOK MA 0047 Verification Prg Figure 6 17 Screenshot Line editor with ID code masking You can see the following operating elements ID code mask for the station It is defined here which information is
7. KELOPIS30 Ch1 2 6 Spinde6 3 CF 22s2Nm OJ KE_OP1330 Ch 1 3 7 Spinde 3 CF 22m O KE_OP1330 Ch14 8 Spinde8 3 CF 222m O Study parameter Tool Option Study template EMS Type 14 verification wi If Lonsen alter each rur Destination directory Ic GMPT_DATASEMS Type_1 Reset Ok Nok counters Humber of runs 50 Filename prefix F Delay after rury F3 sec Figure 5 5 Screenshot Start measurement system analysis Here you can now select the spindles for the study If several spindles are selected the specified number of measurements will be carried out for each spindle and the results will be saved in a joint dfq file The processing order is determined by the displayed order it can be easily changed by re sorting it By pressing the Start button the measurement series is started with the specified number of measurements for one spindle In this connection the operator is provided with the following information Information Please mount reference transducer to Spindle 3 Spindle name Spindle 3 Cell KE_OP13304 Ch 00 51 Click OK when done to start runing the spindle Click Cancel to abort test mode Cancel Figure 5 6 Screenshot Operator information in capability studies h Fe 29 QTrans V2 0 User Manual 5 Operation After the correct study environment set up has been confirmed the nutrunner is started with the preselected tightening program and the measurements of the r
8. Note In case of drag amp drop operations selecting new elements the first unused entries from the corresponding catalogs will always be used for all catalog fields In order to check the assignment between tightening channels and tightening spindles the Channel Spindle button can be activated area in the preceding screenshot Afterwards the display between the 38 QTrans V2 0 User Manual 6 Configuration tightening cell and the line will always be synchronized automatically If e g you click on spindle no 2 tightening channel Ch 0 1 will also be marked in the area of the cell in the tree If the spindle assignment is to be changed e g the order a spindle can be deleted by calling the context menu for the spindle right click This spindle will then be free again for the assignment to a station The following screenshot shows the state after deletion of spindle 1 Figure 6 14 Screenshot after deletion of spindle 1 Here two operations are possible now see arrows in the preceding screenshot Drag amp drop of the tightening cell to the line This would create a new station and enter the tightening channel that has not been allocated yet as new spindle of the station Drag amp drop of channel Ch 0 1 to the station This would create a new tightening spindle in the existing Station effectively this would change the order of the spindles as compared to the original configuration as with drag amp drop new elem
9. 0 g chraubstu a Figure 6 6 Screenshot Program display You can see that for these tightening programs no docu steps have been defined this has to be rectified if necessary using the tightening system parameterization software BS350 After the data has been read in by the tightening system they can now be transferred into the configuration This process is started by clicking on the cell or also on All Controllers using the right mouse button and selecting Synchronize gt Overwrite all Automated data entry ID x rer cay ver m B BB AK 0e i if All Controllers Tightening programs Tightening applications 4 w ae Actual tightening programs Tightening programs in Database a EE Lo yo a ee Tee PY re o c e a sS PET Te D IE a DRE GR Ss P 1 ltest 3step 10 23 2932 180 Zelle Station 1 a Finished a Figure 6 7 Screenshot Start synchronization 35 QTrans V2 0 User Manual 6 Configuration The processing state is again shown in the status line After synchronization has been completed the display is updated so that the data is displayed as follows Automated data entry i x Tightening programs Tightening applications Actual tightening programs Tightening programs in Database Marne D wa OR Deroy 110 23 232 180 Zelle Station 1 7 synchronized 9 programs a Figure 6 8 Screenshot Synchronization result You can see that in area
10. 800 1012 1200 200 D 10 8C US31 8200100207 18 03 2009 10 50 41 OK Spindie 1 21 34 OK 8 00 1020 1200 200 L_ 10 BC USST 8200100807 18 03 2008 10 50 44 OK Spindie 1 21 34 OK 8 00 1005 1200 200 L 108C U831820010040 19 03 2009 10 50 48 OK Spindle 1 71 34 OK 8601 1200 200 ai mooacmencs Pa ee Pe PO i ol ibd O l Hi IE LastStep Yes and Prg 71 2 810 1980K8 E 0 cd ignore invalid ff Trace Figure 7 2 Screenshot QTrans report error analysis By selecting the column filters program number it can be easily recognized that for some tightening results the tightening program has not been allocated QTrans has not been able to find a tightening position 51 QTrans V2 0 User Manual 7 Monitoring and Diagnosis 7 2 Monitoring for QBackup Data Transfer If the automatic network transfer service has been installed QBackup for push transfer of the created Q Das files an icon will be shown for the logged on user whether locally or via remote terminal services in the Windows tray displaying more information on the state of the file transfer to the Q Das server Figure 7 3 Screenshot QBackup monitor 7 3 Configuration Editor Test Run In case of problems with the Q Das data output the function described in chapter 6 5 Checking the K Field Values using Nutrunner Test Data can be used For this purpose the Trace file generated by QTrans see previous section chapt
11. TOBC US31 8200110101 a Normal production OP14004 TO BC UI9318200060101 Normal production OP1410M TO BC U9318200060301 Normal production 2 810 1960k8 IF 0 M ignore invalid KL Figure 7 1 Screenshot QTrans main window error counter If data is received that cannot be allocated an error counter is increased and the received dataset is saved if applicable Trace checkbox In this way it can be easily seen whether the system configuration still contains errors For further cause diagnosis why has it not been possible to allocate a tightening result the dynamic report on the Reports index card is useful it also shows rejected tightening results and provides more details why a result is not ok Q Das transfer 00 00 114 olx Operations Reports ajal eae Css F Barcode Sorted by received last step only Dynamicrepart Operation eae EUN Te fpptiolAppRes Pot Songe fralSee Re ac fr fes oscussisco0scv01 aoea Ok lemia e Val suomi 20 Choscussieponosneon 1a0s200s 104858 Ok Spika aire 200 Phoscussiszocce0ser 19032009 104856 OK Spiny Val esoizi2o 200 Cfoscusaezonosoaon 12032008 105000 ok fmin 2 da ok een 200 Cfoscusaeonnsofiscs2oos 10500 MN Srina 34 Choscusseomosos 1s0s20ns 105010 0K Spina a4 oK eo zu 200 L_ 10 BC USS 8200100107 18 03 2009 105036 OK Spindle 1 71 34 OK
12. V2 0 User Manual 4 Introduction program and or tightening application number must be allocated to the logic structure line station part and or part type and tightening position expected by Q Das The following figure shows the terminology and the basic assignment between the tightening technology and the line structure Tightening system Production Line Cell Station Channel SE CS ra Oa in ee Spindle Application Part Part type a ea Figure 4 2 Assignment between tightening technology and line structure L Here the following special facts have to be considered Between the tightening channel of a tightening cell and the tightening spindle of a station there is always a one to one assignment The designation and or numbering of the tightening spindles is however often different from the tightening channel numbering A tightening channel is defined via the slot and thus has an implicit numbering rack and slot e g Ch 0 1 whereas the spindles are often numbered according to the station station 1 spindle 1 n station 2 spindle 1 m Between tightening cell and station there is generally no clear assignment There may be several tightening cells in one station e g one KE350 for the nutrunners of the left side and one KE350 for the right side and also one tightening cell controlling several nutrunners e g one joint KE for the nutrunners of the automatic and the reworking station If several tigh
13. been entered according to the specifications Default column If now individual values are overwritten on a lower level as described above this can be done as follows e g changing K1110 project on part level J 0 Das transfer configuration d src projects datenerfassung opel usa 2 0 Y2 00 00 100 doc resources qtrans configib K Field editor l OI xj fos File Edit Tools Window Help 1 x E Globa S 0600 LINE 0001 AA a A Enabled F 1100 Station Labor nai aE FLOKEY Enabled FF le EIRE G Koer Jenable none Work Cycle Description ARE Summary table Gk mandatory none Plant Sector K110 ia 0400 70 Bolt 0001 Bosch Rexroth F WG kiio enable rin K1102 Station ine loop ie CHE ee f6 Kant a ec Test Fac Number G K1202 enable ttn 1202 Gage number bolt 46 1k1208 Jenable in K12083 G iki enable none Testlocston E Figure 6 26 Screenshot Overwriting K field value on a lower level The K1110 K field is again inserted in the editor this time on the part level Part 2100 AA You can already see in the K field selection that the first column for the fields defined before K1101 and K1110 now shows an L highlighted in green an indication that this field value has been re defined on the line level Override After acceptance of the value it can be further processed as described above 46 QTrans V2 0 User Manual 6 Configuration If K field values are to be processed on
14. executed when it is needed In QTrans this is used for the realization of customer specific requirements without the need of adjusting the software core An object produced in a production system component workpiece is referred to as part The part can usually be clearly identified by means of a part ident Any number or text which clearly identifies a part Examples include chassis numbers component serial numbers or the like A part type describes a class of parts with common properties Different variants are defined by means of different part types e g 4 cylinder motor and 5 cylinder motor Template file used by QTrans for the customer specific adjustment of the Q Das data output depending on the application Contains script instructions for the assignment between process values and configuration data and the K fields Moreover allows for the definition of parameter values for the GUI the use of catalogs and customer specific formatting or conversions of K field values QTrans V2 0 User Manual 2 Overview of QTrans 2 Overview of QTrans This section gives a short overview of the QTrans functions and shows how the software can be used The operation and installation of the software as well more general information on the software are described as of chapter 3 2 1 System Overview It is the basic function of the QTrans software to accept tightening results data from the Rexroth 300 310 350 tightening systems to convert it into
15. for the assignment between tightening system and logic line configuration tightening position assignment and part definition Here you can also transfer the data from the tightening system o K fields Editor for the K field data processing Tools Contains different tools for the direct data access administrator Window and Help Standard menus as known from other Windows applications More details are described in the QTrans V2 0 Reference manual 6 2 Set up of a New Station For setting up a new station the following steps have to be carried out in DBEdit Creation of one or several tightening cells belonging to the station Creation of a line and one station in this line Assignment of the tightening cell tightening channels to the station s tightening spindles Creation of part types that are processes in the station and assignment of the tightening programs to tightening positions for the individual part types 32 QTrans V2 0 User Manual 6 Configuration All operations are carried out in the line editor Edit gt Lines in the configuration editor Assignments between the individual areas are set up by means of drag amp drop After start the line editor looks as follows if no information has been stored yet a Q Das transfer configuration d src projects datenerfassung opel usa 2 0 2 00 00 100 doc resources qtrans configib Line amp Part configura tion OI x BE File Edit Tools Window Help x
16. however not updated Channel name and program name Changes in the spindle assignment particularly the addition or deletion of tightening spindles and newly added tightening programs are not updated automatically either as for this purpose you must first of all define a tightening position assignment Note The parameter monitoring behavior can be activated or deactivated for individual K fields via the template 4 3 2 Additional Information For the entry and administration of additional information that cannot be automatically taken over from the tightening system or that does basically not exist there the QTrans software provides a K field editor In this connection you can basically process two different types of information K field values If K field values are directly processed they can either be specified as Default standard value that is only used if there is no other value for the K field or as Override value that is always used for the output Alternatively a K field can be allocated a function in the template that will then calculate values in a flexible form and format them if necessary Template properties Template properties are variable values that are filled with values during the configuration This mechanism cooperates closely with the templates The template defines which properties are available the user can then process them in the configuration editor In the generation of the Q Das datasets the tem
17. new cell will be entered in the window for the automated data entry as shown in the following screenshot the question mark preceding the entry shows that the tightening system has not yet read in any current values J Automated data entry gt 10 x File Cell View Tools F SBA B e ii All Controllers oo pren gt a es aie EA Delete KE E Scan tightening programs Synchronize Ls List Channels Be Sbort cerl 4 lt No data to display gt 10 23 232 190 Zelle Station 1 KE synchronizedt 9 programs ve Figure 6 4 Screenshot Start automated data entry from tightening cell A right click on the cell and selection of the menu entry Scan gt Scan tightening programs or clicking on the corresponding button in the toolbar starts the automated data entry from the tightening system Here the progress of the automated data entry is shown in the status line After completion of the automated data entry the data is displayed as follows Automated data entry p OI x Fie Cell wiew Tools ca Tightening programs Tightening applications AU es s O 4 Actual tightening programs Tightening programs in Database a Hza wi o ee ONE Name a oes 7 a i ee Veriicatonra ajl ER a ajl PJ 1 test_astep ER Scan Finished 2 Figure 6 5 Screenshot New data received from tightening cell 110 23
18. of the configuration directly from the tightening system QBackup Component for the reliable and automatic loading of the quality datasets to the Q Das server push model QTrans V2 0 User Manual 2 Overview of QTrans Depending on the purpose these components may be jointly installed on one computer for a small system or also in a distributed form in the network The following figure shows an example of a distributed use with central server in the computer center report viewers at the line configuration using a computer in the planning department and MCS capability studies by means of a laptop Server B Q Das Q Database Figure 2 2 Distributed QTrans installation in the network 2 3 Reports The QTrans software offers report functions for the simple diagnosis and analysis directly on the production level They do not contain high end statistics functions like the Q Das qs Stat software but rather offer easy to use analyses providing a quick overview of the latest components produced adjustable e g the last 10000 rundowns The following reports are available Dynamic report This report shows all new tightening results directly and in real time as received from the tightening system The OK NOK results are optically highlighted by means of color codes and information regarding configuration problems is displayed Flexible filter and sorting options allow for the easy tracking of individu
19. of the configuration view the numbers and names have now been transferred and the numbers and names comply with the information from the tightening system area The column between area and does however not show the symbol for compliance for all programs but also the a symbol for not identical By double clocking on one line you can again open the detail view B Tightening program O x Overview Tightening program Program name online ywx database www Date of last change online 2010 01 22 15 25 35 database 2010 01 22 15 25 35 Step configuration Show all steps Figure 6 9 Screenshot Detail view program comparison On the Overview index card this view now shows that in the comparison between tightening program from the tightening controller and tightening definition in the configuration there is a difference in the docu step listing As already described above no docu step has been defined in the program this is not admissible and thus interpreted as error As there is no docu step no tightening step can be transferred into the configuration this should be corrected in the tightening program 36 QTrans V2 0 User Manual 6 Configuration After closing of the comparative detail view and the automated data entry window the main window of the configuration software with opened line editor will be shown again uration _ oi xl ja File Edit Tools Window Help 1 x Cel
20. of the tightening step Additional Additional parameters are parameters of a tightening step that influence the tightening parameters process e g command speed torque threshold can however not interrupt the tightening process 1 3 2 Terms Regarding the Quality Q Das qs Stat and the Software AQDEF Automotive quality data exchange format A data form defined by a work group with participants from the automobile industry and the Q Das company The goal is a Standardized data exchange format for automotive quality data allowing for the processing of manufacturer and customer independent quality data by means of the Q Das software products In this connection binding specifications for the data acquisition and the data transfer have been defined The data format is based on the Q Das ASCII transfer format the AQDEF specification moreover defines which data has to be supplied for certain applications mandatory and which is optional Apart from that applications boundary conditions for the software application and its operation are defined A certification ensures that the requirements have been met completely dfd dfx and dfq Standard file name extensions for the quality file formats that have been defined by Q Das Apart from descriptive information they contain changeable values dfx parameter values dfd or both dfq Catalog In Q Das qs Stat only pre defined values can be used for some K fields The admissible values are
21. s 9 dass he LLC Figure 5 10 Screenshot Station state during MCS PCS By clicking on show edit once again details on the current state can be displayed Station properties Elle X Station OP13304 MProduction Study mode informatio Total number of Runs 50 B Engine i 1026190822 06 dfq C GMPT_DATA M M ff C Engine 1026190822 01 dfq C GMPT_DATA M Part 17 Stop all Studies Pause Continue Close Figure 5 11 Screenshot Station state details Here the MCS or PCS can also be stopped or paused in order to continue it later if applicable 31 QTrans V2 0 User Manual 6 Configuration 6 Configuration 6 1 DBEdit GUI After having started the configuration software DBEdit the DBEdit main window will be displayed as follows ol Q Das transfer configuration c program files bosch rexroth ag qtrans config ib OI x File Edit Tools window Help Figure 6 1 Screenshot DBEdit main window After the start the current configuration will be loaded automatically see window title line Via the main menu the following functions can be called File menu Opening and saving configuration data exchanging files with the server import and export for remote configuration and closing the configuration editor Edit menu Here the different editors for the parameterization can be opened o Global parameters Configuring the global settings o Lines Editor
22. specified and or maintained in a file in the DFD file format that in addition to the actual value contains a key value and a description optional Only the key values will then be saved in the Q Das data as numerical value applications will show the user the value and or the description also localized according to the local language if applicable K field The K field is the basic element in the AQDEF data exchange format All characteristics are defined via K fields and the characteristic values are allocated to K fields Apart from the characteristic values additional information is stored in K fields e g measuring point organizational data Finally there is one column in the quality database behind each K field Characteristic In statistics a characteristic is generally described by a feature or a status of an examined object which can be used for differentiation or evaluation purposes In technology you distinguish between variable changeable usually physical measurement values and attributive discrete statuses e g red green yellow In the tightening technology quality evaluations the individual measurement values are used as characteristics i e there are characteristics for torque angle time etc Characteristic type Is used in the context of Q Das for the measurement type with variable characteristics i e for example torque or angle Characteristic See characteristic value QTrans V2 0 User Manual 1 About
23. steps docu steps with number 1 10 Communication unit It is used to control several control units and at the same time also to communicate with partner controllers Within one tightening application 1 to n tightening positions are coordinated As tightening controller is either a compact system or a modular system tightening controller with several tightening units One tightening channel comprises the components necessary for a tightening This includes the entire tightening spindle the control the servo amplifier and the connecting cable The tightening program coordinates the tightening process tightening sequence It is divided into different tightening steps in which the tightening parameters are determined The tightening position designates the defined location at which the tightening is realized by means of a tightening channel and a tightening program Smallest unit of a tightening program A tightening system is a complete system with all tightening channels that are required for tightening the defined tightening case Tightening cell designates the installed hardware of at least one tightening channel and at least one data interface for communication with the operating program or with the partner controller This includes the related tightening programs and tightening applications Control unit Compact systems consist of one single control unit each Controls are Tightening controller SE or compact system Communic
24. taken from which location and or via which mechanism of the ID code for more information see below Entry field for the selection criterion for a part type Part selector If it has e g been defined in the ID code mask that a part is selected by means of a 3 digit code the code allocated to this part type will be entered here e g code X12 will then identify part type Part 2100 AA Entry field for the selection criterion Tightening position Position If it has e g been defined in the ID code mask that the tightening position is positioned by means of a 2 digit code the code allocated to this tightening position will be entered here e g 01 for position 1 41 QTrans V2 0 User Manual 6 Configuration For processing the ID code mask another editor is available that is called by extending the drop down list in the entry field of the ID code mask screenshot above area see the following screenshot Lines N 1100 Name Station Labor ID Code mask MlzZ le345678 01 To Example ID code mas 64 characters REP RER EEE ID Code _ x 1 2 if2 31a sfef7 8l ol ft Part serial C C C C Eai m m m Ba 1 ma f E c f c N patsseco MMO OOO 000000000000 001 Rs CD values Part sea O Patt selector by Boltpositon _ o ooo E aan Juse static mask test clear all cancel accept Figure 6 18 Screenshot Editor for ID cod
25. the K fields K fields can be activated deactivated new K fields can be added and process values can be freely allocated to K fields direct assignments or flexible expressions with formatting and scripting o Minimization of the double configuration Any information that is stored in the tightening controller spindle names and names of tightening positions program parameters can be directly accepted by the tightening system In the software only the assignment of the tightening positions and moreover Q Das specific parameters if necessary are stored Full support for the tightening system generation 350 with firmware V2 200 Oo Support for up to 10 docu steps and 100 tightening programs per channel full support of the new data formats step category program names modification date o Remote control of the tightening system spindle start and program selection for measurement system analyses without manual reconfiguration of the tightening system via serial USB or Ethernet o Read in of the nutrunner configuration and programs directly from SE CS KE no manual configuration of tightening programs and tightening steps necessary any more with support for the tracking of changes in the tightening programs Support for one virtual tightening step per tightening position In this way a standard conform and complete data recording of the tightening results can be achieved despite limitations of the Q Das data format also for t
26. the characteristic level or if you want to see the complete list of K fields for all characteristics the Summary Table entry can be selected on the left side in the tree Then the following editor will be shown a Q Das transfer configuration d src projects datenerfassung opelusa 2 05 2 00 00 100 doc resources gtrans contig ib K Field editor P OI x ja File Edit Tools Window Help 1 x SF 0600 LINE 0001 AA i gi 0100 Station Labor A T 2100 Part 2100 AA Drag a column header here to group fl Characteristic Output CN kroa Bot Dosu cra we cron Jo um do kos Pete OM Jo keno __ _ Patsdetsle 0 Jo eno __ OT A OOOO Jo en PE AE P EEE okm _ Fe D COM Fated EE ome Poea M o Kian Patsd al dot enabled Resun gt o oaz Patsas fo enebe in KITO o kas Potsdste JL OuPost erabi rone o ie Posdata P Cibo Priest enable rove NU Figure 6 27 Screenshot K field table In the editor area and all K fields of all characteristics are listed In area descriptive data the characteristic number column N for Part related characteristics 0 is used the K field number the related tightening position the related tightening step Docu and the characteristic type column Char t B A for Angle as well as the K field type column Type are shown for each K field The rig
27. 0000003891 28 09 2005 15 56 33 1 1 Spindle 01 1 74 Angle high 0 00 L 000000003892 28 09 2005 15 57 56 1 1 OK Spindle O11 34 OK J 9 00 0 03 16 00 1 00 L 000000003883 28 09 2005 15 58 11 1 1 OK Spindle O1 1_ 94 ok 94 00 0 01 16 00 1 00 gt L 000000003926 04 10 2005 15 48 40 1 2 Nok fre 01 1 54 NOK Angle high Torque low 4 00 0 21 11 00 2 00 7009 74 7000 00 Spindle 02 14 Spindle bypass ByPass L 000000003928 04 10 2005 15 49 01 1 2 Spindle 01 1 Angle high Torque low 4 00 0 25 11 00 2 00 7008 99 7000 00 Spindle bypass ByPass Spindle 01 1 Angle high 8 00 15 00 1 00 360 74 350 00 a Spindle bypass ByPass Si Spindle 01 1 Angle high 8 00 g DRE i US oo ae Spindle 02 14 Spindle bypass ByPass w i i Spindle 02 Spindle bypass ByPass 52 0 07 CERLLEEZX L 000000003932 04 10 2005 15 52 52 Spindle 01 1 Angle high 6 00 0 06 15 00 0 00 260 25 250 00 cu Configuration Logoff 0 OkB 2 M ignore invalid 7 Trace Figure 4 8 Screenshot for dynamic report Some functions in the dynamic report include for more see QTrans V2 0 Reference Generating static reports on the basis of the displayed data Print out and data export Excel or XML Grouping filtering and sorting the data displaying only the result step or all s
28. 232 180 Zelle Station 1 In area the tightening channels are displayed that are connected to the tightening system In area the new data read in by the nutrunner is displayed and in area that is currently still empty the data is displayed that is currently saved in the configuration The automated data entry processes both tightening programs and tightening applications this is shown on separate index cards see in the screenshot In the area between the tightening system data and the configuration data an information column is shown indicating whether the information between tightening system and local configuration is synchronous Here 34 QTrans V2 0 User Manual 6 Configuration the local configuration does not contain any information yet thus the A symbol is shown information that the program is to be newly transferred into the configuration For each tightening program or also tightening application another column with additional information is shown in addition to the number and the name If here a yellow exclamation mark is shown the tightening program or the tightening application has not been correctly prepared for the use with QTrans e g no docu steps have been defined By double clicking on the line concerned another window with detailed information can be opened pa Tightening program O x Tightening program Program 2 xX Tightening step 24 Schraubstute amp Ange TA
29. AAA AAA A AAA we Gt er nea i0001 LINE 0001 4 AA LINE 0002 AA LINE 0003 44 LINE 0004 AA LINE 0005 AA LINE 0006 AA LINE 0007 AA LINE 0008 44 LINE 0003 4A LINE 0010 44 Figure 6 12 Screenshot Determining line number and name from the catalog In order to add a new station you must now drag a tightening controller or a tightening cell to the line by means of drag amp drop see arrow in the preceding screenshot The result will then look as follows Q Das transfer configurz src projects datenertassung op 0 v 2 00 00 100 doc resources qtrans config ib Line amp Part configuration Fie Edit Tools Windo Channel lt gt Spindle M1100 Mame Stetion Labor ID Code mask 444444444444444444444444444444444444444444444444444444444444444444444 Ee pees 80 Zelle Station 1 L Standard production Verification study D test bs 3 0 Station Labor aa Patt selector iy 1 Chot PO H HA 0001 Spindel Nr 01 EH 2Ch02P0 EE 0002 Spindel Nr 02 No data to display Figure 6 13 Screenshot Line editor after tightening cell assignment You can see that all red arrows have disappeared all tightening channels have been allocated to tightening spindles A station has been created automatically number and name can again be selected via a catalog see drop down entry field in area in the screenshot above and the spindles have been inserted accordingly
30. By means of an override value as specified in the K field editor the K field can be given a manually defined value As in the standard application steps 1 and 2 only use information from the tightening system and the tightening position assignment the system generally provides correct Q Das files without manual adjustment of the K field values In order to create a complete dataset according to AQDEF specification only a few manual entries like e g department name K1101 or works name K1301 are necessary This is considerably simplified by the K field editor as the latter allows for the definition of default or override values for K fields on the line station part tightening position and characteristic level Thus field values applying to one line or station don t have to be defined several times for all parts for more information on the K field editor see QTrans V2 0 Reference In this case the data of the first NOK tests will be lost The multi processing option allows for the saving of all processing steps at a tightening position in a completely understandable form see QTrans V2 0 Reference 19 QTrans V2 0 User Manual 4 Introduction The following figure shows how the QTrans software generates the quantity of K fields the K field values and thus the Q Das datasets from the tightening results data Configured K Field values for parts and characteristics K Field GUI Editor Process data Configurati
31. Haller Erne GmbH QTrans V2 0 User Manual QTrans V2 0 0 document revision R02 QTrans V2 0 User Manual de RO2 docx 2011 01 20 QTrans V2 0 User Manual Document revisions Document revisions RO1 2011 01 18 ce Translation of German manual Christian Enssner www enssner de RO2 2011 01 20 he Replaced screenshots and diagrams with english versions Fixed broken text formatting and layout No further corrections on content syntax or language QTrans V2 0 User Manual 1 About This Documentation Content Te SAD OME TINS DOCU SION Se ana bn a do to 1 1 1 OE I seers E E E E E cen E S 1 1 2 Additional Documentation ccccccsssssssseecccccceaessseeccccccsaueesseeecccessaeasseeececesssaeuuseeeeeeeesseuaasseeeeesesuagagssss 1 1 3 Term and ADDON ON e E E de E 2 1 3 1 Tightening System TONG eresie es ea e 2 1 3 2 Terms Regarding the Quality Q Das qs Stat and the Software 3 Z ONCE IN OT T ea ee eee eee eee ee 5 2 1 Systemi OVEFVIOW ns anenetese es ares essence sne a tesans danse sata ces danse ad aetes Ds auee ner A te ertinte ser 5 2 2 C omponentsand FI ICAI IIS esac a an D ee an ne de ue 5 2 3 OO E E E S E E E E eae 6 2 4 Szolo he aro 8 e A E A E E ne A 7 2 5 New and Changed Functions in QTrans V2 0 sense sense 7 AST OS ee acts A ee eee a center ne nu 9 3 1 MASE LE La Le PT gientiasaaucventiaenwnrss 9 3 2 SONT AC ATOM a ea E E ed a 10 TO UN TOME ee eee a de ae ii eens 11 4 1 ON ee ee ee ee ee 11 4 2 Line Structure and T
32. O Ojo Ojo Oo Oyo Oyo Oyo ole Generated values Pet seiat Lo o ooo Part selector CS ooo O fuse static mask test clear all cancel accept H H H H 4 rii Figure 4 3 Editor for ID code masking Note The ID code masking also defines which parts of the ID code are to be used as actual clear part ident this is used for the control of the parts supply and discharge see chapter 4 4 QTrans offers two diagnosis functions in case of problems with the parts type or tightening position assignment During the configuration Here a consistency check between the defined part type and tightening position mask and the specification for a component is carried out Deviations are marked in red in the parts editor see also screenshot at the top Entries that could lead to an ambiguity of part type or tightening position are generally rejected During the runtime QTrans shows in the dynamic report whether successful assignment to component type or tightening position has been possible for a tightening result if this is not the case corresponding information will be shown 4 3 Parameter Setting Apart from the tightening result assignment to parts and tightening positions see above additional information is required for the generation of standard conform Q Das datasets In QTrans this information is taken over from two different areas Information from the tightening system T
33. PT3304 Ch 1 3 App 1 PTBR 10 2Nm Sn KE DF1330A Ch 1 5 App 1 PBR 202m D po Bot 10 KE_0P13304 Ch 2 1 App 1 P1 BR_10 2Nrm 11 Bot11 _ KE_0P1330A Ch 2 2 App 1 P1 BR 108 2Mrm 12 Bot12 KE_OP13304 Ch 2 3 App 1 P1 BR_10 2Nml TF TA 13 Bat13 KE_OP13304 Ch 2 4 App 1 PT BR_10 2Nm Dy A Eg 000 Spindle 10 AN NC Boti KE_OP13308 Ch 0 1 App 2 P2 BR_204 2Nrm Ch 2 4 di es a 0011 Spindle 11 NC_IBot2 KE_0P13308 Ch 0 2 App 2 P2 BR_20 2Nm ob 3N N Bat3 KE_OP13304 Ch 0 3 App 2 P2 BR_20 2Nm oe 123 229 67 143 KE_OP1350M LL of 0012 Spindle 12 a Nota KE_OP13308 Ch 0 4 App 2 P2 BR_20 2Nm ee 123 229 67 168 KE_OP14004 FH 0013 Spindle 13 5 NO N KE 0P13308 Ch 1 1 App 2 P2 BR_20 2Nm M FH 123229 67 155 KE_OP1410M AR il 1350 0P1350m 6 BO LIKE OPERA Ch o o DES eee ee ee 3 8 Bok _ JKE_0P1330A Ch 1 4 App 2 P2 BR 20 2 Hf anono 3 Bots KE OP1330A Ch 1 5 App 2 P2IBR 20 2Nm SE 100021 Line 2 HO Boti0 KE_OP13304 Ch 2 1 App 2 P2 BR_20 2Nml a Fi Bok 1 KE OP13304 Ch 22 App 2 P2 BR_206 2Nm EE Ped iste F2 Bok 12 KE DP1 3304 Ch 2 3 App 2 P2 BR_206 2Nm Hey 0001 Spindle 1 13 Bolt13 KE_OP13304 Ch 2 4 App 2 P2 BR_20 2Nm a Hl gf 0002 Spindle 2 Hl gf 0003 Spindle 3 You can also see from the screenshot that part types are allocated to a station In the context of Q Das a part type always describes a processing version in a statio
34. This Documentation value Characteristic ident Characteristic class Characteristic value Quality characteristic Q Das qs Stat Script scripting Part Part ident Part type Template Clear identifier for a characteristic Is used in order to allow for clear assignment of the characteristic values in the quality database Is used in the context of Q Das for differentiating the relevance of the characteristics depending on the characteristic class a characteristic is a quality characteristic or not secondary characteristic In the tightening technology it is here particularly with special tightening processes distinguished between the controlled guided and the free measured monitored value e g tightening torque torque controlled angle monitored gt torque is no statistically relevant measurement value Value for a characteristic usually a measurement value for variable characteristics A characteristic that is decisive for the quality Company supplying software for the statistical examination of production processes Q Das software package for the statistical evaluation of process data In the software technology these terms designate an instruction sequence in a programming language that is especially used for application extensions in order to realize additional processing or adjustment to special requirements in a flexible form The instruction sequence is usually saved as text and only interpreted and
35. a the data output In the read out of the tightening controller memory the DBEdit configuration editor allows for the automatic takeover of all information from the nutrunner and a comparison and the synchronization of changes if necessary This can be used for the verification e g with incorrectly configured tightening programs or also for updating changes that are not updated automatically e g the addition of a new tightening spindle The only information that the user has to enter for the data takeover from the nutrunner is the tightening system s IP address i e the one time creation of the tightening cell in the system The following screenshot shows an example of the data takeover J Automated data entry sons File Cell View Tools FBBAH B i All Controllers Tightening programs programs Tightening applications 9 WE 123 229 67 133 KE_OP1300M Actual tightening programs Tightening programs in Database ER 123 229 67 163 KE_OP1330A Con ee ee Name 9 EM 123 229 67 143 KE_OP1350M ofest al et i esta fesse SSCS Bree be ahs D ben S A7 VeriicatonPrg y vertica i 10 23 j 10u 0 2 CHO 6 Yon Se lest el Ot EI cas i esta fesse SSS Update selected WO23 232 180 1023 292 180 synchronized 9 program fg Figure 4 4 Read in and synchronization of a tightening cell When transmitting synchronizing the data from the tightening system memory the following inform
36. aet Ma ok rmonhenin sx mx fe El UFMT l gt 0 OKE i 2 M ignore invalid Trace 4 Figure 5 2 Tables in the GUI The following elements are available 1 Column selection By clicking on this box the menu is shown which displays all columns that are available in the table If you tick a box the corresponding column will be shown Alternatively the column selection can be called via the context menu and the Column selection entry 2 Column headers Columns and column groups display a labeling for the columns By clicking on the column header column filters quick filters and column sorting can be adjusted 3 Grouping field By dragging amp dropping a column header into this area the displayed data can be grouped according to the column 4 Summarized cells As in Excel cells with identical values can be summarized in order to increase the clarity 5 Navigation area By means of the symbols in the navigation area more functions can be called e g the filter dialog can also be accessed via the context menu 27 QTrans V2 0 User Manual 5 Operation 6 Context menu Can be called by clicking in the table with the right mouse button and offers more functions like e g automatically re calculate the optimal column width 5 4 QTrans GUI After having started the QTrans software the main window of the QTrans software will be displayed as follows Q Das transfer Y1 27 9 6 OI x Opera
37. al log 20 03 2009 03 27 Text Document 2 049 KB i 1400 OPT 4004 i z __tst_Bosch_T log 11 06 2010 15 51 Text Document 5 KB ee Desktop ee Administrator po Computer a Network i File name Files of type a A Figure 6 30 Screenshot K field table test run After selection of a suitable result file FTP dataset the data dialog for selection of the test data will then be displayed J Tightening result editor Cell 192 168 1 109 KE_TST Showmex fn 2 Station TST_Station tightening results Cancel Tightening results Config 1234500001 _55194229_7190T F40 5 4 10 05 201 0 1 0 00 00 4 1234500001_55194229 2190T F40 6 4 10 06 2010 10 0000 OK NOK 15 SEI52M CH O4 Kit 4 PD 2010 04 14709 22 21 D 2010 05 10 H 10 00 00 L 17088 P88 OK ID Code 1234500001_55194229 Z19DT F40 6 wR_4 M 11 00M OOTM 1100 W 45000w 502 00w4 550 00 MWS 0 00 G 11 000G 0 008G 11 000MGS 0 00 T O657T 10 00 S24 QC 1 RC SB4 OK gt Figure 6 31 Screenshot Dialog for test data selection 49 QTrans V2 0 User Manual 6 Configuration Here the individual datasets contained in the file are listed in the central area by pressing the Add to part button they can be added to the test dataset By pressing the Run button a complete Q Das dataset is generated the dialog is closed and displayed in the K field table as follows a Q Das transfer configuration c program files bosch rexroth ag qtrans config ib
38. al nutrunners components or stations Using the dynamic reports more reports see below can be generated in order to further analyze the data drill down End of cycle report This report shows a station and part based view of the tightening results data Here the result values are shown in a table so that the individual tightening positions are arranged horizontally next to each other and the columns with the results of one tightening position can be easily compared with each other Here the first time quality percentages of the tightening positions are also calculated and displayed Reject report Similar to the end of cycle report however the reject report shows the components with NOK tightening and the related reasons Root cause analysis This report shows a summarized listing of the NOK tightenings and sorts and or groups them according to the NOK reason The presentation can be displayed from the point of view 6 QTrans V2 0 User Manual 2 Overview of QTrans of the tightening step the program the tightening application or the station so that you can easily get an overview of the selected group or compare them with each other e g which station produces most NOKs The individual entries will then show the number of NOK tightenings per tightening step tightening program tightening spindle etc so that extraordinary deviations e g spindle positioning errors frequent cancelations in a certain tightening step can be identi
39. an be defined in the configuration editor which parts of the entire ID code contain the part ident information 44 3 Generating the K Fields The QTrans software generates Q Das data for each part type separately In the configuration any information necessary for that purpose is stored In this connection the Q Das files dfx dfd dfq are set up as follows One dataset of a part type consists of o N tightening positions as defined in the configuration o Per tightening position a different number of tightening steps are possible Only tightening steps and the related results which are marked as docu steps will be taken over into the Q Das data o Per tightening step there may be several characteristics e g torque and angle t In case of NOK cancelation in a non docu step this data will normally be lost The virtual tightening step function allows for the complete saving of all tightening steps see QTrans V2 0 Reference 18 QTrans V2 0 User Manual 4 Introduction Per station only one single dataset is generated for one part In this connection processing steps by several tools are allocated to the relevant tightening positions in the dataset Ifthe same tightening position is processed several times only the processing completed last will be saved in the Q Das file Thus a Q Das dataset may for example look as follows Tightening positions Tightening position 2 Characteristic type Characteristic
40. ans operating modes 4 6 2 Measurement System Analyses In this connection QTrans is able to control a tightening system and carry out the required number of tightening attempts In this connection the operator is led through the sequence and gets step by step instructions for the correct process implementation Depending on the analysis type QTrans supports type 1 and type 1A the data is automatically read in by a reference measuring system and also included in the result dataset The measurement procedure e g 50 measurements is than completed automatically without the need of manual user interventions The measurement system analysis can also be carried out in portable form as no changes in the tightening system configuration are necessary for controlling the tightening system and transferring the data for the individual measurements Apart from the communication via a network communication with the tightening system is also possible via a serial or the USB interface only system 350 The following screenshots show how the function has been realized in QTrans MCS and PCS are only available if QTrans has not been installed as Windows service 24 QTrans V2 0 User Manual 4 Introduction a Studies amp Vertlication tudy template MS Type 1A verticabon wi nation directory C OSDATA EMS TypelA BT fel stil 414i Figure 4 14 User guidance for measurement system analyses 25 QTra
41. aracters the code page 1252 Latin applies 43 QTrans V2 0 User Manual 6 Configuration Note In tightening applications the tightening system transmits one joint ID code thus only one joint position code can be entered in the editor for the application the editor will automatically transmit this code for all tightening positions of the application Note No selection codes 0 characters entered will be displayed with gray background color of the entry fields 6 4 Processing K Field Values K fields are processed in the configuration editor in the K field editor The latter is called from the configuration editor main menu via Edit gt K Fields and displayed as in the following screenshot in the tree in the left area one line is selected 0 Das transfer configuration d src projects d opel usa v2 0v2 7 oc resources qtrans config ib K Field editor loj x fos File Edit Tools Window Help _ o x H oc Global ps properties En E Enabled TD 1100 Station Labor e tT F 2100 Part 2100 44 fone KA Summary table me 0400 70 Bolt 0001 Bosch Rexroth i 0401 70 Bolt 0002 Bosch Rexroth No data to display Figure 6 22 Screenshot K field editor empty In the left area the editor shows a structured tree view of the entire system configuration from the global level to the tightening position level For each level a processing window is displayed in the right area normally comp
42. arameters separately for all characteristics group processing of a characteristic group is also possible see QTrans V2 0 Reference In addition the K field editor offers the possibility to examine the actually generated datasets For this purpose a Summary table entry is contained for each part type in the hierarchy tree The following screenshot shows an example Hl Q Das transfer configuration d src projects datenerfassung opel usa v2 0 2 00 00 100 doc resources qtrans config K Field editor ioj x BE File Edit Tools Window Help le x A Global E PO oO eA 0001 Line 1 H fl 300 0F1300M A E i 11330 0P13304 Let a e La ee L Se moneo e ES EE Et CE mwg Moo w G nn NN o kao o CN mosea o a o O O a le oka Drag a column header here to group by that column 0004 Bolt 4 K1232 E eee 0005 Bolt 5 NN NI Parts data SGMW OD Powertrain B o 10 Pats data PT 7 CR CES Pats dats ffe mandatory _1in_K1303 0007 Bat 7 fajo Kieo2 Pats data AL 0008 Balt 8 10 Ooo OS S LEZ 0 Es nic jooa ecks Vs on ao tT Mesuemenivaue 6 poeto ikoon Jeska ft 7 Memuemenvaue 6 ee vi e joottjckt1 Vi kos fens p Mesowementvee 6 ena AIT J1 KOOOS Boty 1 T Messurementvaue G w VU CL Here all K fields are shown in exactly the same form as they will later be generated in the Q Das result file So you can easily see which K fields get their values from where for val
43. as data is saved accordingly in separate sub directories with the station and or part type names More information on the data storage options is contained in the QTrans V2 0 Installation and Administration manual 4 4 2 Parts Processing Cycle ofa Station The QTrans software works basically in a station related form i e it collects all tightening results of the nutrunners allocated to a station in a joint pool In principle there can only be one component at a time in one station in the line that is after all the definition of a processing station and any and all processing at this component is carried out with the unique part ident for the tracking The QTrans software utilizes this criterion in order to internally generate signals for Parts supply and Parts discharge from the transmitted tightening results data The software interprets the receipt of tightening results data with a changed part ident as the information that a new component is now processed in the station parts supply That implies that the previously processed part has now been completed has left the station and thus any tightening results data with the part ident received before is now complete parts discharge At this moment a complete Q Das dataset is generated and saved in the file system Note As apart from the unique part ident the ID code that is transmitted by the tightening controller with each tightening may also contain more information it c
44. ation is taken over Name like e g channel names program names or tightening position designations The tightening program structure particularly step information on steps for which the data output has been activated in the tightening program 15 QTrans V2 0 User Manual 4 Introduction Monitoring and target function parameters from the tightening steps For the read out of information on number and type of the Q Das characteristics to be created Apart from that the characteristic classes and characteristic types are generated automatically Tightening step parameters In this connection the limit values and set values for the characteristics are read out As this configuration is normally only carried out in the commissioning another mechanism has to make sure that these uniquely determined parameters won t become obsolete For this purpose the QTrans software will check for every received data package whether the configuration is still up to date In case of deviations the parameters are automatically tracked and the configuration is updated The tracking works on the basis of the tightening system docu levels If new docu levels are activated new characteristics are also automatically generated in the data output if docu levels are deleted the related characteristics will be deleted Note All important parameters like command and limit values serial numbers etc are automatically updated The following parameters are
45. ation unit KE Designates the process in which several tightening positions at one component are tightened one after another by means of a tightening spindle or a group of tightening spindles by mechanical displacement of the tightening spindle s or the component During the tightening process a monitoring function observes compliance with upper and lower limit values by controlling a monitoring parameter e g gradient If the monitoring function is switching non compliance with the limit values will result in the immediate termination of the tightening step If it is not switching it sets the step result to NOK even if the target parameter has been achieved The monitoring parameter is the measurand e g gradient of a tightening step which has to be kept within certain limits in order to guarantee safe completion of the tightening process Violation of the limits might result in the termination of the tightening step QTrans V2 0 User Manual 1 About This Documentation Target function By monitoring the target parameter e g torque the target function controls the process run of a tightening step and leads to the completion of the step if the parameter reaches its target value Target parameter The target parameter is the measurand e g torque of a tightening step which for the successful completion of a tightening process has to achieve a certain value target value Achievement of the target value results in the termination
46. cumentation regarding the system installation and maintenance as well as information on safety and integration in the Windows operating system for the system administrator and other system environments e B Siemens HMI QTrans V2 0 Reference Detailed documentation regarding the input masks file formats and internal software processes QTrans V2 0 Template Reference Documentation regarding the customer specific templates Here it is described how the process data is mapped to the customer specific K fields and which additional functions and parameters are used Apart from that short Technical Notes and How To instructions on special topics are available QTrans V2 0 User Manual 1 About This Documentation 1 3 Terms and Abbreviations 1 3 1 Tightening System Terms Docu step KE Tightening application Tightening controller Tightening channel Tightening program Tightening position Tightening step Tightening system Tightening cell SE Control Stitching Monitoring function Monitoring parameter Tightening step in which the data output function is activated Normally result data is only automatically generated for the chronologically last tightening step that has been tightened if a step is marked as docu step the data from the marked step is output as addition Each docu step can be clearly allocated by means of a number in the tightening system 350 up to 10 steps can be defined as docu
47. e 28 5 5 Performing a Measurement System Analysis ins rer sense 28 5 6 Performing a Machine or Process Capability Test 30 COMP SUGATION ES SRE Re tech eat plies TR de nn Aa de dt Ale telnet Nm al 32 6 1 BBETON ar A be aca senateaniauicu gare sau ena eae auneeoau va eee atarea aaa 32 6 2 S t UD O1 NOW Stationerne cess nent pas awa ion eens 32 6 2 1 creatine a HISMUCAING COM cial civil a At nn bestia teeth anete adc 33 6 2 2 Creating a Station and Allocating the Spindles ss 37 6 2 3 Creation of Part Types and Tightening Position Assignment 39 6 3 Type Selection or Position Specification via ID Code ss 41 6 4 Processine KiPICIG ValUGS ss nn Mt a dde fees teen dre db a res ctbat ect 44 6 5 Checking the K Field Values using Nutrunner Test Data ss 49 Monit rng and Diagnosis es A en Ca S 51 7 1 OTrans Station Ovemiew and REDO Seriean a a a dies 51 7 2 Monitoring for OBackUb Data Transfer it A E 52 7 3 Configuration Editor Test RUM es ASE fn na A lotte 52 7 4 Windows System FUNCTIONS dd NS RES ct ide ai 52 7 4 1 VC OG ne E ed nem ee canton 52 7 4 2 Event Tracing TOR WINDOWS see cr ee A Se Ne te en 52 QTrans V2 0 User Manual 1 About This Documentation 1 About This Documentation 1 1 Content This documentation describes the general function and operation of the QTrans software from the user s view Here the frequently used functions and operating steps are explained The complete description of all user interface el
48. e mask The editor has three lines with checkboxes for the simple mask assignment area in the preceding screenshot for the part serial number Part the part type selection Part selector and the tightening position Bolt position If one of the checkboxes is ticked the sign from the ID code transmitted by the tightening controller is accepted accordingly In order to provide for easier processing and examination of the mask definition a sample ID code can be entered in the entry field and masked by clicking on the Test button in area The masking results are then displayed in the text fields in area 3 as can be seen in the following screenshot a Q Das transfer configuration d src projects datenerfassung opel usa 2 0 2 00 00 100 doc resources gtrans contig ib Line amp Part configuration OI xj BE File Edit Tools Window Help x Cells Lines Parts 1100 Mame Station Labor ID Code mask 22204444444401 10004444444444444444444444444444444444444444444444 PE 0800 LINE 0001 AA Example ID code max 64 characters KE X12_12345678_01_TO0 100 Station Labor z f 002 Spinde 2 o Meeffe p e e pon peeps peir 18 13 20 21 22 z code x1121_ 112131415 16 7181 ol NT T Pat serial OOOO MMM M MM 0 0 0 a m 0001 test_astep Pail selector M0 00000000 0000000000 M TA 2 CC EE CC ye inom 0047 VerticationPrg Generated values Pees Sande Hs Patt ser
49. e or the tightening application and or tightening program This report offers a simple but nevertheless powerful option to examine and compare tightening results If the results in this report are grouped you can e g compare tightening spindles with each other and problems with individual spindles become easily visible e g mechanical problems like e g positioning or tool wear If the tightening systems use different tightening programs or tightening applications for tightening different tightening positions or part types the grouping function can also be used in order to identify the extraordinary deviations By means of the grouping and sorting functions this report generally offers a possibility to identify the most frequent problems at the Stations If these problems are removed the production quality can be improved effectively 4 5 2 4 Reject Report spmdies bat Cob 16 FTO 62 aprdes lst cotlo 2 FTO 3 Sore Sorel 10 Sonda 34 Sondel7 34 Sorel amp 44 3i 4 Sonda 11 194 ET epee int Ce 17 FTO 5X 3 Paes 35 a Peeve 12 47 18 17 ar Det it at et Ey jee 137 Pi 7 C lss nez lim e f os End of Ope Peper 740 Sa Ragas hapas Haut Reet Cape Arco Figure 4 11 FTQ report The reject report functions similarly to the end of cycle report The displayed data is however filtered automatically and the column
50. e requested on the telephone or by fax email Note The software activation binds the software license and the software serial number to the computer name An activation key is only valid for one computer When exchanging a computer e g in case of a computer failure the software can still be used as long as the computer name is taken over without changes as e g with an image backup restore For more related information please refer to the QTrans V2 0 Installation and Administration manual 10 QTrans V2 0 User Manual 4 Introduction 4 Introduction 4 1 Overview The following illustration shows an overview of the QTrans software The QTrans software consists of several software components DBEdit for configuration QTrans for data conversion for reporting and capability study as well as QBackup for data transfer via the network The following figure shows the interaction of the components Configuration gs Ga Den Pie Pa Files on Q Das Server ready for import into Q Das Database Temporary Files Files awaiting transfer DFD DFX DFQ DFD DFX DFQ always in append mode ready for upload Figure 4 1 QTrans system overview The tightening results data is basically sent from the tightening system to the QTrans software via the FTP network protocol QTrans contains an FTP server accepting these results and converting them into Q Das compatible files according to the configuration
51. eference measurement system are transferred if applicable The measurement progress is indicated as follows Tool study results Too Torque ar Referenc Meter 20626 Torque 0 1 6 M CRC ok Transducer H 56825 Angle 0 0 Comm Log ToobAngle Reference Ange Tool GC a 016 4 CO ES Angle 94 20 Figure 5 7 Screenshot Progress reference measurement After completion of the measurement series another window with user information will be shown for changing to a new tightening spindle or the study is completed and the result file dfq is saved After completion of the study the station is automatically switched back into the default operating mode for the collection conversion and forwarding of the process data 5 6 Performing a Machine or Process Capability Test For performing a MCS or PCS you should proceed as follows In QTrans on the Operations index card you first of all click on the show edit button of the station for which the capability study is to be performed Then QTrans shows the following dialog Station properties Mel x Station OF13304 Standard prodcution mode information last part ID 10 EC 09318200110101 Tool Study ernfication Production Study Figure 5 8 Screenshot Changing the station state This dialog shows details on the current station state If here you click on the Production Study button a dialog for selecting the study parameters will be displa
52. ements and more information on the functioning installation and configuration are contained in the additional documentation This documentation is divided into the following chapters Chapter 1 Information about This Documentation Chapter 2 Overview of the QTrans System Describes briefly how the system is set up and which function it offers Chapter 3 Installation Contains important information on the system installation Chapter 4 Introduction Describes how the system functions how data is transported through the system and provides background information on the understanding of the system processes Chapter 5 Operation Describes the system operation Here general user interface elements are explained operating concepts are explained and processes for the implementation of frequently used functions are shown Chapter 6 Configuration Describes the system configuration Here all steps necessary for the configuration are explained using a complete system configuration as example Chapter 7 Monitoring and Diagnosis Shows which monitoring and diagnostic functions are available in QTrans 1 2 Additional Documentation Please also observe the current instructions of the Rexroth tightening system components and the following additional manuals and instructions for the QTrans software QTrans V2 0 Quickstart Examples of the commissioning of a data acquisition system with QTrans QTrans V2 0 Installation and Administration Do
53. ents are added at the end of the station and or the spindle list Now the station has been created completely and all tightening channels have been allocated to the tightening spindles The next step is the creation of parts part types and the definition and or assignment of the tightening positions 6 2 3 Creation of Part Types and Tightening Position Assignment The creation of new parts for a station exact part types is either realized by calling the context menu in the parts area and selecting the add new part entry or automatically by means of drag amp drop of a tightening program or tightening application to the parts area The following screenshot shows the assignment of a tightening application as this is the fastest way for the creation of a part and at the same time tightening positions for the individual application programs are created automatically In order to open the application display the station has to be selected click on using the mouse consequently the window with the list of tightening applications highlighted in yellow will be opened There you must now selected click on the desired application and drag it to the parts area by means of drag amp drop 39 QTrans V2 0 User Manual 6 Configuration lol x 18 x Lines Parts H aa ZT Sty eh 444444444444444444444444444444444444444444444444444444444444444444444 Verification study Part selector ttt LT cho PO D ttt
54. er 7 1 can be imported and examined in detail in the configuration table Here you can then easily answer questions like the following Why is a K field missing Where does the incorrect value in the K field come from by means of the inheritance view in the editor 7 4 Windows System Functions QTrans is deeply integrated into the Windows system and uses its management functions 7 4 1 Event Log The QTrans software components write important information into the Windows system log event log The event log can be easily monitored by means of common management solutions so that malfunctions or configuration problems can be forwarded and processed 7 4 2 Event Tracing for Windows The QTrans software components use the Windows event tracing infrastructure for writing important information about the program process This function can be activated via the standard Windows management applications trace level and in case of errors provides additional information on the error cause 52
55. fied and optimized and or removed FTQ report first time quality This report provides a fast overview of the OK NOK figures of tightening cells spindles and tightening applications This gives you a fast overview of where the most frequent problems occur and the possibility to give their removal top priority All reports offer the possibility of interactive filtering sorting and grouping so that the desired information can be presented in perfect form In addition the displaced data can be exported as Excel or XML or printed for further processing 2 4 Capability Studies Apart from the standard operating mode for converting and saving the result datasets for transfer to the Q Das server QTrans supports the generation of datasets for capability studies for evaluating the capability of measurement systems machines and processes For carrying out measurement system analyses QTrans offers special functions leading the operator through the process in an interactive form and allowing for the remote control of the tightening system to be examined from the QTrans software This also allows operators without knowledge of the tightening system programming and parameterization to carry out correct measurement system analyses After selection of a measurement system analyses by the user parameters for the measurement series will be queried then the nutrunner will be started according to the number of specified measurement cycles and the mea
56. for a break New system service for automatic data upload to the quality data server push QTrans V2 0 User Manual 3 Installation 3 Installation 3 1 Installation The software installation is started by calling the setup exe installation program After the call up the installation program will lead you through the installation step by step In the Select components step see screenshot below it should be made sure that the correct installation version is selected je Setup OTrans Mimi Select Components Which components should be installed Select the components vou want to install clear the components you do not wank to install Click Next when vou are ready to continue Full OTrans Server installation including GUI tools Full QTrans Server installation including GUI tools OTrans Server installation no local GUI tools OTrans standalone installation including GUI tools OTrans standalone installation without uploader Also used For tool verification Trans report viewer client For use with an already installed QTrans server Custom installation OTrans database configuration editor 2 4 ME OTrans standalone report viewer and client 2 9 ME Current selection requires at least 44 1 ME of disk space lt Back Cancel Generally the following selection options are available 1 Server installation Installs the QTrans server version as Windows system service Depending on the selection with or wit
57. gt Choa Po 7 Sal De U3 No data to display 0000 test fy D001 test step it 0002 ss 0003 test NOK p047 YerificationPrg Figure 6 15 Screenshot Creating a part from an application The result shows the following screenshot El Q Das transfer configuration d src projects datenerfassung opel usas wz 0 w2 00 00 100 doci resources gtrans config ib Line amp Part configuration 1 OI x ja File Edit Tools Window Help l x Lines Parts Channel lt gt Spindle N 1100 lHame Station Labor ID Code mask 444444444444444444444444444444444444444444444444444444444444444444444 SF 0600 LINE 0001 AA e im 1100 Station Labor Standard production Vernhication study Part selector E gt 10021 Spinde N 02 ZEL ae Ae F 7O Bolt 0001 BoschRexoth Zelle Station 1 Ch 0 1 test EE wA 70 Bolt 0002 Bosch Rexroth Zelle Station 1 Ch D est NN F ia oof 10003 test NOK fils 0047 VerificationPrg Figure 6 16 Screenshot Part after drag amp drop operation In the parts area in the preceding screenshot a new part type Part 2100 AA has been created comprising two tightening positions 400 and 401 The tightening positions have been transferred from the application definition as have the program numbers In order to add more tightening positions the following operations can be carried out see preceding screenshot D
58. he NOK case Support for desktop and server operation QTrans can work as system service without registration configuration monitoring and reports can be carried out remotely via the network Performance optimization for dynamic reports and the data conversion as well as considerably improved performance for the integrated FTP server Optimization of the configuration workflow For the basic function only the nutrunner configuration has to be read in and the tightening position assignment has to be defined New K field editor More flexibility definition of K field values not only possible on part and characteristic level but moreover on line station and tightening position level easier operation K fields and description are displayed catalogs are supported and integrated diagnosis tools process data can be simulated directly from the K field editor and the generated Q Das files can be examined Support for new reference measurement systems Schatz Inspect Improved support for tightening position and part type assignment via the ID code for stitching with GUI for the assignment between ID code and the corresponding masks Scripting in many parts of the application for flexible adjustments Improved behavior for quitting restarting the applications station status and datasets can now be maintained also after a restart without being completed configuration changes can now be implemented immediately without waiting
59. his is the preferred area takeover of information that has already been stored in the tightening system ensures that there is no incorrect information due to double configuration at different locations which has to be updated requiring a great amount of work 14 QTrans V2 0 User Manual 4 Introduction Additional information So that QTrans is able to cover flexible requirements of different customers and applications additional information can be inserted manually This information can be entered in the K field editor on different levels line station spindle part tightening position or characteristic calculated dynamically via scripts or also be selected by means of the template from numerous predefined variable and filled with values 4 3 1 Takeover from the Tightening System For the takeover of information from the tightening system QTrans uses two different mechanisms For the basic configuration in the DBEdit configuration editor the tightening controller memory can be read out and information on the tightening channels tightening applications and tightening programs configured there can be extracted During runtime the corresponding information is extracted from the FTP tightening results datasets and automatically updated Here the advantage is that no learning is necessary for the system configuration any required data can be taken over by the tightening system Subsequent changes are then automatically updated vi
60. hout additional GUI software additional configuration software and the report viewer automatically configured for a local connection to the server are installed In this configuration no MCS and measurement system analyses are possible without additional manual interventions 2 Desktop installation Installs the QTrans software as Windows application with GUI for the local data acquisition and conversion In this connection all QTrans software functions including MCS and measurement system analyses are available for operation with one single computer Depending on the selection the software for the automatic upload of the Q Das datasets to the server push will be installed automatically 3 Report viewer client Installs a viewer for the read only access to an already existing QTrans server installation This allows e g on a computer close to the production system to access the data of the server that is e g located in the computer center and to use the QTrans reports Note For the installation with the Siemens HMI option 2 should be selected as the software is then started together with the HMI For MCS measurement system analyses you can then create a shortcut according to the description in the QTrans V2 0 Installation and Administration manual QTrans V2 0 User Manual 3 Installation Note For more details regarding the installation and set up of the QTrans software for different applications please refer to the QTran
61. ht area shows information about the contents K field values of the K fields The first column shows where in the configuration the K field value has been defined by pressing the drop down area the hierarchy of the definition is displayed see the Default column shows the default value or the Override value see above the forced column shows whether the value has been overwritten on characteristic level gray from superior level or calculated automatically with checkbox ticked default of the characteristic level is used not ticked K field is not generated in data output The last column shows information that has been generated in the test run test run can be called using button see QTrans V2 0 Reference manual If for example you want to make an adjustment to the K field of a characteristic you have to proceed as follows Selection of the K field For this purpose the filter and grouping functions of the table can be used e g group by tightening position first then by characteristic number drag amp drop of the Bolt column header into the grouping area then drag amp drop of the N column header into the grouping area Ticking of the checkbox in the force column Entry of the new value in the default column 47 QTrans V2 0 User Manual 6 Configuration The result will then look as follows 0 Das transfer configuration d src projects datenerfassung opel usa 2 0 2 00 00 100 doc
62. ial Channel lt gt Spindle 0000 test Pat seer IZ ME moon te atep open J 100021 I ft 10003 test NOK ft 10047 VetiicationPra Figure 6 19 Screenshot Test for ID code masking Pressing the Accept button accepts the settings and closes the editor You are now shown the following screen 42 QTrans V2 0 User Manual 6 Configuration a Q Das transfer configuration d src projects datenerfassung opel usa v2 0 2 00 00 100 doc resources gtrans confhigib Line amp Part configuration ioj x BE File Edit Tools Window Help x Lines Channel lt gt Spindle N 1100 Name Station Labor ID Code mask 2220444444440110004444444444444444444444444444444444444444444444 0600 LINE 0001 AA Standard production Verification study Emm AU ET Cho PO al A TA 02 ETES tt gt ch02p0 P TOO test Sstep 7O Bolt 0001 Bosch Rexoth Zelle Station 1 Ch 0 1 App O PO test 70 Bolt 0002 Bosch Rexroth Zelle Station 1 Ch 0 2 App 0 PO test iE 0003 test NOK inom 0047 Verification rg a 0003 Spindel Nr 03 0000 test it 0001 test Ssten it D002 ses iy 0003 test NOK 0047 VetificationPrg Figure 6 20 Screenshot ID code assignment with errors The entry fields for the part type and tightening position selection are highlighted in red This indicates an entry error for the fields concerned this is correct as QTrans now expects a three digit code for the par
63. ightening Position Assignment sise 11 4 3 Pra Vel SOLAR a db tbe ee ti ia ati tn ne 14 4 3 1 Takeover from the Tightening System sn 15 4 3 2 Additional INTOA OG ge Sean aan a ee mm one 16 4 3 3 Global K Field COMBAT nano aan nan coated edouniasta en Rene nn 17 4 4 Generation of the Q Das DataSets ccciscss vcaaserowsedansavcednnsm vudanss Enen iN E EE EEEE latente 18 4 4 1 DA OAE E e E E ee 18 4 4 2 Parts Processing Cycle ofa Stal OW En ae te ne en a te 18 4 4 3 G n ration a eee 18 4 5 PEDOT a de E a ried sea a ah 20 4 5 1 Dynamic REDO nee a mn nt dt nt ne ere 20 4 5 2 SAUC RODOR PR braneaawenas E wont pieucceaencumenenbaumoaaeuetconen este 21 4 6 CaP ON Se ee ere nee ee ene ee 24 4 6 1 Machine and Process Capability Tests sccinccesasesastsnnndtcavavhousnsndesiaxtanseseenoaueiavacesusnecdsatiaseeateibents 24 4 6 2 Measurement System Analyses ccccccccccssecccssecceececescsceecsceecseeueceeeeeseenseeeeuceeeueceeseceneueseuensss 24 5 QTrans V2 0 User Manual 1 About This Documentation DST AIO Menea a va ah carseiel wei veiuslivaa a a a a 26 5 1 Star wg ect atlases beeen tea hc cas Rese eens eae Gace ede the tentent 26 5 2 User LOBI Re Rd A Tao ln a en tee ee a 26 5 3 Ser INTE aCe El CNG US Rennais 26 5 3 1 P FOS AI VIN COW estaseces Sob siazenteueet tea sia ne ns ne Ne en ne niet ts 26 5 3 2 TASS Sant esac te teh eed eee be ew sat be aed ses eae nat ba een ats ara at 27 5 4 arans COURS Re E ene E rere ne rere arene et ace sentent te
64. led ResFune Descipion JE Mef 2100 Par 2100 44 ekos enable m0 Machine Number Garo enable tin K1088 Postion Spindle H bonamen Len none Work Cycle Operation E Meurtre Plank Sector enable tm 1102 Station ineo enable none Cotcemre enable tm KIO Proiest O O enable none O Test Facility Number Figure 6 23 Screenshot New K field value You will then be shown a selection list of the available K fields on the tightening position level no fields of the part level are available with additional properties like name description and already existing default values e g K1101 here has a global default of Assembly line The first column shows on which level the value has been defined in this example everything has been determined on the G level Global By selecting list entries you can now accept a K field for processing the value In the following screenshot the K fields K1101 department and K1110 project have been selected as example Q Das transfer configuration d src projects datenerfassung opel us 00 00 1 00 doc resource qanfig ib K Field editor a File Edit Tools Window Help Global 0600 LINE 0001 AA E ffl 1100 Station Labor fel 2100 Part 2100 44 0400 7O Bolt 0001 Bosch Rexraoth 0401 70 Bolt 0002 Bosch Resrath ds CH Figure 6 24 Screenshot Editing the K field value The default K field value can be changed by editing the field value in the Defa
65. ls Channel lt gt Spindle Figure 6 10 Screenshot Line editor after cell information read in Now the line editor shows all tightening channels and tightening applications as they have been transferred from the tightening system The red arrows in front of the tightening channels or the cell indicate that it has not yet been allocated to a station The station has now been completely created the next step is the creation of a tightening station and assignment of the tightening channels to the tightening station or to the tightening spindles 6 2 2 Creating a Station and Allocating the Spindles A station can only be created in the context of a line therefore the line is created first This is done via the context menu in the line area central column in the line editor a Q Das transfer configuration d src projects datenerfassung opel usa 7 0 v7 00 00 100 doc resources qtrans config b lbine amp Part configur ation OI x fos File Edit Tools Window Help 1 x Cells Channel lt gt Spindle AE 1023 232180 Zele Station 1 Figure 6 11 Screenshot Creation of a new line 37 QTrans V2 0 User Manual 6 Configuration After the new line has been created line number and line name can be determined these are catalog fields i e you must first of all select an entry from the list see area fos File Edit Tools Window Help Cells e lt gt Spinde _ 1 ID Code mask 44444 AAA AA
66. n In practice it is particularly the assignment of the tightening results to the correct tightening positions which is not always easy Based on the individual tightening result QTrans must recognize the component type and the corresponding tightening position and select them for saving the data In this connection the following problems occur Ambiguity of the tightening position definition As already one single tightening result must be enough for the selection of the tightening position and the part type if e g in case of NOK only one tightening position is actually tightened the received data of one single tightening result must allow for clear assignment Offline data As in case of communication failures datasets are saved in the tightening controller and tracked subsequently external signals e g digital I O or other signals transmitted in real time field bus systems or OPC etc cannot be used in order to provide for unambiguity For these reasons only information that is contained in the tightening results datasets is used for the tightening position assignment The following parameters are used TCP IP address and channel number tightening cell and tightening channel assignment to station and spindle In the configuration the corresponding spindle and thus also the station is stored for each tightening cell and each tightening channel 13 QTrans V2 0 User Manual 4 Introduction Tightening program number a
67. nd tightening application number Both values together are used as primary information for selecting a part type and for the assignment of a tightening position As the tightening system allows you to start the same tightening programs via different tightening applications the application number can for example be used as additional type selection information or position information ID code From the ID code additional information on the tightening position and or on the part type selection can be seen In this connection the parameters that are stored in the part and or tightening position configuration are then compared with an extract form the ID code In case of compliance the corresponding part type or the tightening position will then be selected J Q Das transfer configuration c program filesi bosch rexroth ag qtrans configib Line amp Part configuration fo File Edit Tools Window Help Lines N 1300 Name OP1 300M 0001 Line 1 fl 12300 0P1300M ji 1330 OF 13304 ffl 1350 0P1350M fl 1400 oF 14004 fil 1410 0F1410M 0002 Line 2 ID Code mask EMI Example ID code max 64 characters AA 1234567890 xx W123 pt fet ay ats e e es fio ti i2 13 14 15 16 17 18 13 20 21 22 23 24 25 2 ID Code Ala _ rf2 sfa s el7 s sto _ x _ witf2y3 tf Partserial O O 0 4 M4 M4 M MMM MM 000000000000 Part selector M4 OO OOOO 000000000000 00 0 0 0 I Bottpesiion OO OOOO OO O
68. ns V2 0 User Manual 5 Operation 5 Operation 5 1 Start The installation configures QTrans with an auto boot function Depending on the installed version as Windows service or as desktop application QTrans is then either started upon system start system service or after a user s log off desktop application By default the installer creates three shortcuts in the Windows start menu under Start gt Programs gt BoschRexroth AG gt QTrans QTrans Depending on the installation type this shortcut starts QTrans either in the Report Viewer mode as standalone application or as Tool Verification GUI DBEdit This shortcut starts the configuration editor User manual Opens a pdf version of this user manual 5 2 User Login If QTrans is run in the standalone mode a user login is necessary for changing the station status i e for starting capability measurements Access to the configuration database is controlled by means of rights in the file system the administrator can then determine these rights accordingly for Windows users or groups Note More information on the user login and on access rights is contained in the QTrans V2 0 Installation and Administration manual 5 3 User Interface Elements 5 3 1 Program Window The QTrans and DBEdit program windows contain the following elements in the user interface 1 Q Das transfer configuration c program files bosch rexroth ag qtrans configib K Field editor OI
69. ns for changing the operating state of individual stations for capability studies are made available show edit buttons If the Reports index card is selected the list of the tightening results received last will be displayed the dynamic report see above From here you can then generate the additional static reports and analyze the data 5 5 Performing a Measurement System Analysis For performing a measurement system analysis you should proceed as follows In QTrans on the Operations index card you first of all click on the show edit button of the station for which the capability study is to be performed Then QTrans shows the following dialog 28 QTrans V2 0 User Manual 5 Operation Station properties Esel x Station OP13304 Standard prodcution mode information last part ID 10 EC 09318200110101 Tool Study verification Production Study Figure 5 4 Screenshot Changing the station state This dialog shows details on the current station state If here you click on the Tool Study button the user guidance for the measurement system analysis is started Then QTrans shows the following dialog Studies amp Yerification Ml x Vertication part spindle action groupl Part 17 KE_OP1330 Ch 01 1 Spindle 3 CR 22m O KELOPI330 ChO2 2 Spinde2 3 CR 224 24m EC E A KE_OP1330 Ch 04 4 Spindle 3 CF22323Nm O KE_OP1330Ch11 5 Spinde5 3 CR 22m O
70. on A Process data N Configuration variable list variable list variable list Si variable list ce Customer template defaults a lt S Generated files All A DFD DFX DFQ K Fields Template processor processor er AL data from configuration f data from customer data from customer gs dynamic process data database specific template specific Q Das catalog from tightening system Figure 4 6 Processing pipeline for K fields 4 5 Reports The reports integrated in QTrans are designed for fast and easy to use data analyses directly at the production system Instead of complex statistical analyses on the characteristic level they provide superordinate information and different comparative views in order to reveal and solve problems in the production Here the data quantity is basically limited to the latest parts produced e g the last 10000 parts in order to guarantee fast interactive operation The report window in QTrans offers the possibility to display the tightening results updated in real time in a list and to monitor them On the basis of this dynamic report four more reports can be generated allowing for the retrieval of exact information regarding FTQ Summary Report the data quantity drill down With every additional report call filters can be applied in drill down gt
71. plate can then use these properties in order to calculate K field values The K field editor allows for the processing on different levels see following screenshot 16 QTrans V2 0 User Manual 4 Introduction a Q Das transfer configuration d src projects datenerfassung opel usa 2 05 2 00 00 100 doc resources gtrans config ib K Field editor ioj x BE File Edit Tools Window Help 18 x H Global K Fielda Template properties S 0001 Line 1 mE Enabled Ee gi 113001 0F 1300 A Em EN 1330 013304 ekion Jenabe none Drawingnumbe E a 00018 Enare eko enable nome Drawig mendmen un E RE Smaise E O fente neina Pats ve operon number ST K172 Supe Staton Desfenable one Euh Desoipien 8 mmea fg IN Et nae E a a inber a e UE se T 0002 Bolt 3 Supplier Description enable _fn_K1085 Machine Number G Format A40 Jenabe rf K1085 Position Spindle 0004 Bolt 4 n o K10AR enable nane Work Cucle Mn ration Figure 4 5 K field editor with inheritance If values are defined on a higher level they also apply to all lower levels the settings are inherited if e g a parameter is set on station level it will also apply to all parts tightening positions and characteristics see screenshot the S marking highlighted in blue In this way the K field editor allows for an easy determination of joint parameters without the necessity of entering the p
72. rag amp drop of a tightening program to an already existing part operation in the preceding screenshot Adds a new tightening position to the part Drag amp drop of a tightening program to the free area operation in the preceding screenshot Creates a new part type and adds the tightening program as new tightening position Note Both operations are also possible for applications 40 QTrans V2 0 User Manual 6 Configuration 6 3 Type Selection or Position Specification via ID Code For applications in which one tightening spindle processes several tightening positions or several part types have to be differentiated QTrans offers different possibilities for providing for clear tightening position assignments and or part type assignments see also chapter 4 2 1 Solely using channel number program number and application number 2 Moreover using information from the ID code Selection of part type and or tightening position using the information from the ID code is always reasonable if the number of program numbers and or application numbers max 100 programs or 48 applications are possible runs short many tightening positions are tightened using the same tightening programs the configuration work for the assignment is then less as is the administration work in case of changes in the tightening program using the BS350 or different part types have to be generated which are however not differentiated by the tightening programs
73. resources qtrans config ib K Field editor ja File Edit Tools Window Help Ee Global 0600 LINE 0001 AA 0 1100 Station Labor Balt i 2100 Part 2100 AA M Pm E e e JE 2 Bolt F0 Balt 000 Bosch Resroth COEN 2 oo fa T Mesuemenveue G a5 Koo fa r Measuement vee e MSS kos fa fr Messuementvoue 6 M SSCS Koe fa fr _ Messuementveue G OO D SCS Koo fa f Messuemenvaue G ft D SCS Koe s T Measurement vee G SS ko fa r _ Measuementveve 6 OOO NT Kono fa f Mesuemenveue e E S O pete E Characteristics Figure 6 28 Screenshot K field table with characteristic change Here the value of the K0011 K field has been changed selection via a catalog The column displaying the entry s hierarchy level now shows a C an indication that the value has now been determined on the characteristic level C Characteristic In order to change several K field values simultaneously the K field table offers an additional option see following screenshot By applying filters shows the active filter the quantity to be changed is selected and the first entry is then edited manually as described above Then the first entry is copied to all other fields by clicking on the button green pushbutton J 0 Das transfer configuration d src projects datenerfassung opel usa 2 0 2 00 00 100 doc resources gtrans config ib K Field editor foe File Edit Tools Window Help
74. rising two index cards for the processing of the K fields and the processing of the optional template parameters For processing the global level and the Summary table another editor is displayed see below In order to determine a new value for a K field you should proceed as follows 1 Decide on which available level the K field value is to be determined line station part tightening position or characteristic In QTrans values are inherited i e if a K field value is determined on the line level it will also apply to station part tightening position etc As the values can however be overwritten on every subordinate level you can also define exceptions e g A value is determined for the line which is to apply to all parts of the line but for one It would then be reasonable to enter the general value on the line level and to overwrite the exception for the special part 2 Enter a new value A new value can be created by calling the context menu and selecting the add new record in the editor window right click in area The following screenshot shows an example 44 QTrans V2 0 User Manual 6 Configuration 0 Das transfer configuration d src projects datenerfassung opel usa 2 0 2 00 00 100 doc resources qtrans configib K Field editor l OI x fos File Edit Tools Window Help 1 x D ca 0600 LINE 0001 AA FLOKE Enabled Eb BP 11001 Staton Labor CIDRE Defaut Enab
75. s V2 0 Installation and Administration manual 3 2 Software Activation Use of the QTrans software requires an activation for the release of all functions After the installation the software is by default in the demo mode in this mode the use of the software is limited There are two options to release activate the software Requesting an activation key for test purposes By selecting this option an activation key is requested After entry of the returned activation key in the activation dialog all software functions will be released for a test period 30 days During the test period the software will display a reference to the test operation during start up specifying the remaining test period After expiry of the test period the software will change back to the limited demo mode Requesting an activation key for buying the software license By selecting this option an activation key is requested In this case data on the licensee the computer name and the software serial number are transmitted by email or fax After entry of the returned activation key the software functions will be released according to the license and the registration dialogs upon software start up will be deactivated If the software has been acquired as physical delivery a CD the software serial number that is necessary for the activation is contained in the CD case and or on the CD labeling If the software has been downloaded the serial number can b
76. s displayed by default contain a more exact description of the NOK cause see the following screenshot Q Das transfer 2 00 00 1 14 aS See x Drag column header here to group by that column static reports Tooo S ajeun DateTime AppiNo Station jac fac ProfSte 4 Ax A ac PrafStep aC Prafster _ 108C 109316200440101 18 03 2009 10 41 36 OP1300M A fe 11 2A 12274 1360 ae O BC US316200440102 18 03 2009 10 41 40 OP1300M CICw 0 En 0 CICw 0 En 0 99 34 Mel E Operations Reports pensons gs f Br poaa 15379050 o o _ 10 EC 09316200440502 18 03 2009 10 42 06 OP1300M CICW 0 En 0 CICW 0 En 0 99 34 _ 108c 09318200050501 13 03 2009 10 36 30 OP1 som Jo mess 10 8C U8318200060502 19 032008 10 36 34 OP1300M CICW 0 En 0 CICw 0 En 0 99 34 icscussiseneoso a03 20s ions forts x tfa 1524 150 1 1 1 10 80 U8318200080602 19 03 2009 10 50 07 OP1300M CICW 0 En 0 CICW 0 En 0 99 34 _ 10 6C 09316200440101 18 03 2009 10 41 36 OP1300M AAT 12274 ao _ 10 6C 19316200440102 18 03 2003 10 41 40 OP1300M C Cw 0 En 0 CICw 0 En 0 89 34 a ae x poa 15379050 y o o OBC S91 6200440502 18 03 2009 104208 _JOPTSOOW CCM NE no E fa _ jij jt _ 10 6C U931 8200050501 19 03 2081 O 36 30 OP1300M re 34 50 75 50 ESS ees HH H A E EMNET End of Cycle Report FTO Summary Report Reject Report Root Cause Anal
77. specifications In this connection the individual tightening results are then allocated to tightening positions so that subsequent analyses allow for clear reference to the component The generated files are temporarily buffered for a specified time or number so that several datasets can be collected in one file After a complete file has been created it is copied into a transfer directory so that it can then be transmitted to the server via the network optionally via the QBackup service or directly read in and processed by means of qs Stat For the configuration the DBEdit software component is used It offers graphical editors for processing the configuration database Here especially the definition of lines and stations as well as the assignment between the nutrunner hardware and the logic line structure as well as the definition of part types and the assignment of the tightening positions are made possible For special requirements and additional parameters a K field editor is provided by means of which the data output can be adjusted up to the K field level 4 2 Line Structure and Tightening Position Assignment For creating the Q Das quality data the QTrans software must map process data tightening results that is received from the tightening controllers into the Q Das data model In this connection the data contained in the tightening results dataset like TCP IP address of the control tightening channel number tightening 11 QTrans
78. surement values are read in by the nutrunner and the reference measurement system if applicable After completion of the measurements the results are saved in the Q Das format In the measurement system analyses the following types are supported Type 1 Examination of the nutrunner by means of a specified reference part that is usually a calibrated torque measuring device creating a given reference torque angle profile Here the measured torque and angle values notified by the nutrunner are compared with fixedly determined reference values Type 1A Examination of the nutrunner by means of a reference measurement system Here a calibrated reference measuring encoder is mounted at the nutrunner output drive this encoder provides comparative values for the measured torque and angle values notified by the nutrunner 2 5 New and Changed Functions in QTrans V2 0 As compared to the previous versions V1 27 the QTrans version 2 0 offers the following new or changed functions Support of the AQDEF format and certification according to AQDEF category C o Guaranteed compatibility of the data interface and conformity of the user interface by certification according to AQDEF standard V3 0 category C for tightening systems QTrans V2 0 User Manual 2 Overview of QTrans Oo Support for the dfd dfx and dfq file formats as well as all writing modes according to AQDEF standard Support of catalogs Flexible configuration and assignment of
79. t selection and a two digit code for the position selection If no correct codes are entered in the configuration the tightening results cannot be allocated and no result data for the part concerned or the tightening position will be generated This can be corrected by entering the corresponding codes a Q Das transfer configuration d src projects datenerfassung opel usa 2 0 2 00 00 100 doc resources gtrans contig ib Line amp Part configuration ioj x BE File Edit Tools Window Help x Lines Channel lt gt Spindle Eno Mame Station Labor ID Code mask 2220444444440110004444444444444444444444444444444444444444444444 Y Standard production Yernfication study EH 4 Ch 0 1 PO af 02 Part 2100 AA Ga FR 2 cho2ro P 0001 test astep 7O Bolt 0001 Bosch Rexroth Zelle Station 1 Ch 0 1 App 0 PO test 7O Bolt 0002 Bosch Rewrath Zelle Station 1 Ch 0 2 App 0 PO test oll 0003 test NOK ion 0047 VenficationPrg E 4 0003 Spindel Nr 03 i D000 test 0001 test 3sten Ht 0002 xxx ft 10003 test NOK ft 10047 VetiicationPra Figure 6 21 Screenshot Corrected ID code assignment Now the codes have been allocated correctly Note The selection codes are compared in the ASCII character set character by character i e the number of characters and the writing capital small letters must be exactly the same If spaces are contained they must also be entered to special ch
80. teTime AppiNo ApniFtesut Spinde Pro SteefResut OC Spinde 01 1 36 OK oo aoea 1 00 60 00 100 00 A Spindle bypass ByPass LL Spinde gift jas OK 00 0631666100 50 00 100 00 1A Spindle bypass ByPass UN nun o 04 10 2005 16 13 30 a 04 10 2005 16 13 20 1 2 l Sort Ascending 4102005 18 or poseondea ra M Arie ich 0 0 07 15 00 000 25025 250 00 ee Spindle bypass Pas 0410 2008 if feglehigh 600 003 1800 000 26025 25000 Spindle bypass ByPass die 01 1 94 OK foo 0 10 16 00 1 00 50 00 100 60 nde 02 Spindle bypass ByPass nde 1 34 OK fao ao 16 00 on sooo 100 00 Spindle bypass ByPass die 01 1 Angle high 600 0 08 15 00 0 00 26025 250 00 Spindle bypass ByPass nde 01 1 Anglehigh 00 0061500 0 00 260 25 250 00 Group By This Field 1 Group By Box Footer Group Footers 04 10 2005 04 10 2005 1 04 10 2005 1 Remove This Column ef Field Chooser 04 10 2005 1 nr ee Spindle bypass ByPass L 000000003936 04 10 2005 RER de 01 1 Angle high 600 0 06 15 00 0 00 27025 250 00 Spin 1 Angle high 600 006 1500 0 00 270 25 250 00 L OOOOO0003935 04 10 2005 16 02 28 Spindle bypass ByPass 54 a OK 00 609 16 00 1 00 5000 10000 a L 000000005954 04 10 2005 15 54 36 1 2 e 1 000000003833 04 10 2005 18424 12 spr
81. tening positions of one component are tightened with one nutrunner e g by displacement stitching there may possibly no longer be a 1 1 assignment between tightening program and tightening position The following screenshot shows how the assignment has been implemented in the QTrans configuration in the DBEdit configuration editor Here the assignments between tightening channel and tightening spindle as well as between tightening program or tightening application and tightening position can be established by means of drag amp drop 12 QTrans V2 0 User Manual 4 Introduction a Q Das transfer configuration d src projects datenerfassung opel usa v2 0 2 00 00 100 doc resources gtrans conkigib Line amp Part config MEI an ioj x File Edit Tools window Help Ei Cells Lines Parts Channel lt gt Spindle H 8 Mame Spindle ID Code mask 4444444444444444444444444444444444444444444444444444444444444444 Ele E 0001 Line 1 Standard production Verification study A el an Eh di 1320 oF13304 as Bf 0011 Spinde ie Bott KE_OPISS08 CHOY Ape PER Am O Bat KE_OP13304Ch 0 2 App 1 P1 BR_10 2Nm I ca mua Jali i 3 Bot3 KE_OF1330A Ch 0 3 App 1 P1 BR_10 2 m Hg 10004 Spindle 4 4 Bok4 KE_OP1330A Ch 0 4 App 1 P2 BR_20 2Nm A ee Got KE_OPISGOA Ch1 1 App 1 PH BR106 2Nm e eote KE OP13304 Ch 1 2 App 1 PI BR106 2Nm EH y 10008 Spinde 6 7 Yok KE O
82. teps Reference to NOK tightenings highlighted in red and configuration problems tightening result cannot be allocated to a tightening position in red font 4 5 2 Static Reports Based on the data displayed in the dynamic report more so called statistic reports can be generated As for the further processing only the displayed datasets are used the flexible filters available in the dynamic report can be used in order to make a data pre selection As compared to the dynamic report in which all the data is listed one below the other without easily recognizable tightening spindle and tightening position assignment one line per tightening step all tightening results will be allocated to tightening spindles parts and tightening positions and shown accordingly for the statistic reports 4 5 2 1 End of Cycle Report The first step for the creation of the statistic report is the creation of the End of Cycle report In this connection the tightening results are re sorted so that all tightening spindles are listed next to each other In this connection the data is sorted according to the part ident so that all tightening results are shown combined for one part The footer calculates and displays the percentage share of the OK tightenings FTQ first time quality see the following screenshot 21 QTrans V2 0 User Manual Q Das transfer Operations Reports wS E El B Drag a column header here to group by that column
83. the Q Das AQDEF file format and forward it for further analyses storage and archiving Apart from that the software offers user guidance for the control of nutrunners and measurement systems in order to perform MCS and measurement system analyses This allows for the completion of type 1 and type 1A measurement system analyses without reconfiguration of the tightening controller The following illustration shows the basic overview of the QTrans software use Tightening System 3xx ns Reference measureme non Reference meter j PC running QTrans Software Figure 2 1 Use of the QTrans software 2 2 Components and Applications The QTrans software consists of the following components QTrans central data conversion component Can be used as Windows system service then without GUI independently as desktop application or also as report viewer client in the network The report functions show currently incoming tightening results and allow for the creation of simple statistical reports The support for capability studies offers functions for the remote control of tightening systems for measurement system analyses with worker guide and automatic measurement value storage for reference measurement systems as well as commissioning and process capability studies DBEdit Component for the system configuration Offers graphical editors for the tightening position assignment and K field processing as well as functions for the transfer
84. tions Reports aj le eal al x Css f Barcode Sorted by received gt last step only a EE EE TE EE o _ ICONS ElGE EL coooooteo7se 2o0a 10v28 18 3621 EL cooooorecrss 2o08 10 2618 3623 Ok Spt ezja ok 1008200 9400 9436 10000 t coooootecrsa zo0a ta 2e tasse OK Set ajea ox 10001220 8000 9420 1000 Q Das transfer 1 27 9 6 I loj x 0 2 00 80 00 34 79 100 00 Operations Reports 102 00 80 00 94 80 100 00 P6200 0 00 4 26 100 00 59 200 80 00 8477 1000 ee oe ss D Normal production z Idle show edit mm D 94 12 100 00 Configuration Logotf Normal production z Idle show edit M ignore invalid 7 Trace 4 Normal production z Idle show edit TestkE310 TestC5 351 L 0000001 80729 Normal production ist Running show edit 2 Configuration Logatf LE 2 KE EFE M ignore invalid 7 Trace Figure 5 3 QTrans main window i Depending on the operating mode only the Reports index card for the Report Client mode or both index cards will be shown standalone or Tool Verification mode In the lower part of the window buttons for accessing the configuration and for logging users on and off are shown again according to the operating mode If the Operations index card is active an overview of the state of the configured stations of this installation is shown which component has been processed last in each station and functio
85. type Characteristic Ke LE Ra number Measurement en eter Ctele In the example there are 12 characteristics The order of the characteristics characteristic number is determined by the configuration and an internal sorting as follows Tightening positions are sorted according to the order of their definition in the configuration i e using the tightening position number All characteristics of tightening position 1 i e all characteristics of all steps of tightening position 1 are output before the characteristics of tightening position 2 etc Steps are sorted according to the order of the docu step number The characteristics of the step with docu step number 1 are output before the characteristics of the step with number 2 etc Within one step characteristics are output sorted according to their characteristic type In this connection an internal assignment order is used The K field value generation is controlled via the processing pipeline for K fields In this connection the following processing steps will be carried out one after the other for each K field that is defined in the global K field list The K field is initialized with a default value as specified in the K field editor By means of a processing instruction from the template the K field can be overwritten with a combination of configuration values or the process values Here assignments to catalog values will also be performed if applicable 3
86. ues manually entered in the K field editor which characteristics are available etc By importing a tightening results file measurement values can be entered so that the complete processing by the QTrans software can be simulated and the results can be verified As in other areas of the QTrans software you can here also use grouping sorting and filter functions in order to get a quick overview of the desired information 4 3 3 Global K Field Configuration QTrans is delivered with the K fields according to AQDEF standard V3 0 category C for tightening technology In the global K field editor area you can however depending on the application change the global list of the 17 QTrans V2 0 User Manual 4 Introduction available K fields to do so administrator rights are necessary Here K fields can be added and removed global defaults can be defined or K fields can be deactivated deactivated fields are not written into the Q Das files Apart from that you can here also adjust the data types that are allocated to the relevant K fields More information on the global K field configuration is contained in the QTrans V2 0 Reference 4 4 Generation of the Q Das Datasets 4 4 1 Data Storage The QTrans software generates Q Das files based on the information that is stored in the configuration and updated during the runtime if applicable see above In this connection each station and each part type is administrated separately and the Q D
87. ult column Here it is important to understand that this is really a default value i e this value is only used if no other data is available for this K field Whether and how other data for this field is generated is determined by means of the ResFunc column As all parameters of the superior level are accepted when a new K field is inserted into the editor the determinations for the ResFunc column are basically accepted there as well If a K field value is not only to 45 QTrans V2 0 User Manual 6 Configuration be accepted as Default but also as Override i e as determined value none has to be set as entry in the ResFunc column Consequently QTrans will not generate an automatically calculated value but always use the default value that has been entered in the Default column After the processing has been completed everything should look as follows a Q Das transfer configuration d src projects datenerfassung opel usa 2 0 2 00 00 1005 doc resources gtranscontig ib K Field editor OI x mi Fie Edit Tools Window Help 18 x E Globa 0600 LINE OO01 AA eae T F 2100 Part 2100 A4 KA Summary table 0400 70 Bolt 0001 Bosch Rexraoth 0401 70 Bolt 0004 Bosch Rexrath Figure 6 25 Processing K field processing completed All K fields are enabled Enabled column the automatic calculation by QTrans is deactivated ResFunc is none and all values have
88. view of the tightening step the program the tightening application or the station so that you can easily get an overview of the selected group or compare them with each other e g which station produces most NOKs The individual entries will then show the number of NOK tightenings per tightening step tightening program tightening spindle etc so that extraordinary deviations e g spindle positioning errors frequent cancelations in a certain tightening step can be identified and optimized and or removed see the following screenshot Q Das transfer Operations Reports Drag a column header here to group by that column FAootlausednalysis E f Station AppING GC Description Pra 1 aP17 10 2 l ngle high F8 6 FU 1 74 8 7 a Af 3 i E E 18 Angle high Torque low 1 5A mn je E E on step lewel Oro drain Eve onapplicationlevel TT an station level 135 Spindle bypass ByPass sl o TE maremu End of Cycle Report RETO Summan Report Reject Report Root Cause Analysis E 0 OKB 2 M ignore invalid 7 Trace 4 Figure 4 10 Report for root cause analysis 22 QTrans V2 0 User Manual 4 Introduction In addition the footer calculates a vertical total so that an interactive analysis as with a cross table becomes possible 4 5 2 3 FTQ Report The FTQ report provides information on the OK and NOK number related to the tightening spindl
89. x BE File Edit Tools Window Help 1 x a Q Characteristics Global Drag column header here to group by that column Heu gt 000 Line 1 ff 1300 0 P1 300M Si 1330 OF 13304 HA 0017 Part 17 Bt 0005 E Engine Characteristic Output jo SN 6 D CRC O Oo OT CO ko TG ee 1 Koon Bota TT Messurementvaue G Y JM fon pots 1 Measurement vane 6 25 a kooos Bota 1 1 _ Measuemertvahe Je 3 ne 2 ele 4h Figure 5 1 Screenshot GUI interface elements The following elements are contained 1 Window title Shows the name of the application and additional information document name if applicable 2 Menu bar Contains the application main menu optionally additional toolbars 26 QTrans V2 0 User Manual 5 Operation 3 Status line Displays additional information 4 Window area Contains the application specific data range and document area 5 3 2 Tables At several locations QTrans and DBEdit use tables for the presentation and entry of data The tables offer many joint functions for the adjustment and optimization of the view The following screenshot shows which options are available l A Q Das transfer Operations Reports ee ee et ag emia O 7 ront Cover 100 delete all a e i Drag 4 column header here to group by that column BZ Operation aT Params BEUN em Da
90. yed looking as follows 30 QTrans V2 0 User Manual 5 Operation Production study parameters Be EX study Process Capability Destination directory CAGMPT_DATASMRO Process_Capabilty Humber of runs CE Filename prefix PO Start Figure 5 9 Screenshot Parameters for PCS MCS After entry of the parameters or selection from the list of pre defined parameter sets the station is switched into the PCS MCS operation by pressing the Start button From this time tightening results data will not be written into the default Q Das files any more but into the directory selected above The station will remain in this operating mode until the specified number of measurements for each part type processed during the measurement series has been carried out completely While this operating mode is active the station state will be displayed in QTrans on the Operations index card as shown in the following figure Q Das transfer 2 00 00 114 OF x Operations Reports Last part id Mode State Resks Rejected station state 0 OP1300M Normal production show edit OP1350M 10 BC U9318200070401 Normal production Running 1 0 show edit OP14004 110 BC U931 8200060101 Normal production Running 18 lo show edit OPT 410M 110 BC 931 8200060301 amp Normal production B Running 1 lo show edit TST_Station Normal production Idle 0 0 show edit f
91. ysis 810 1980K8 IF 0 W ignore invalid 7 Trace Figure 4 12 Reject report 23 QTrans V2 0 User Manual 4 Introduction 4 6 Capability Studies Apart from production data processing QTrans offers support for the implementation of capability studies and the saving of the study data in the Q Das format For all capability studies standard parameters like e g the necessary number of measurements can be specified in the configuration so that the operation is standardized and simplified 4 6 1 Machine and Process Capability Tests Here you can switch QTrans into an operating mode for which the data of one or several stations is temporarily not saved in the default production dataset but in a separate file After completion of the specified number of parts QTrans will automatically switch back to the creation of default production data The following screenshots show an example of the machine capability and process capability studies loj x Operations Reports rocess Capabili Last part id Mode Seen OPM E Normal production Destination directory CMQSDATAARD Process Capability co Idle Production Study mode information Total number of Runs 50 Torque oo 83540 01 OSDAT SR Product type 1 3 8 1028183540 01 C QSDATAMAR z Contigur 40 20kB ee M ignc Stop all Studies Pause Continue Close Figure 4 13 QTr

QTrans V2.0 User Manual - bei der Haller + Erne GmbH!

Contents

Download Pdf Manuals

Related Search

Related Contents