Valve Spring Sorting System Manual
Contents
1. 142. 2008 Larson Systems Inc All rights reserved No part of this manual may be reproduced by any means without written permission of the author except portions necessary for internal use only by the purchaser of the LSI system 1 OVER VIEW eb e TE 5 2 INSTALLING THE LARSON SYSTEMS UTM OR SSS AND THE VALVE SPRING TEMPLATES otia eee ee ee er re 5 3 FIRST c 5 3 1 UTM or SSS First Time 6 3 2 Valve Spring Certifying Template First Time Setup eese enne nennen nnne 8 3 3 Valve Spring Sorting Template First Time Setup eese eeeeeeeeennee entente nnn tnn nnn 9 3 4 First Time Tester Setup EE A 9 4 USING THE VALVE SPRING CERTIFYING TEMPLATE 10 5 USING THE VALVE SPRING SORTING 11 1 OVERVIEW This manual explains the use of the Larson Systems Inc Valve Spring Certification and Valve Spring Sorting Excel templates These templates are used in conjunction with the Larson Systems Inc UTM or SSS computer software and any Larson Systems Inc spring tester This manual will show how each template works and how to alter the template for other uses Each template uses macros to accomplish the interface to the Larson Systems Inc UTM and SSS
3. occur d Leave the Baud Rate at 9600 e Type in any Port Comments desired f Check the Enabled setting above the communications port selection 9 Click the OK button to close the Port Options 3 Data Exchange Setup a Click the menu item Options Data Exchange to open the Data Exchange Setup window UTM 3 22 59 9 Be f Data Exchange Data Exchange Setup Communication Type Dynamic Data Ex C Program Files Microsoft Office Offic LI LI LI LI LI b Click the Add button type in a name for the data exchange setup and click the Add button c The Communication Type should be set to Data Exchange as shown in the picture d Action Performed should be set to Send Results as shown above e In the Spread Sheet Program Setup set the following i Spread Sheet Program This is the path to the spreadsheet Click the Find Spread Sheet Program button to open a File Folder navigation window to find the correct path Set the Spread Sheet Title For Microsoft Excel the title should be Excel Set the Sheet Name This will be the sheet where the data is placed For the Larson Systems Inc templates the sheet is labeled Data Excel Template for Valve Spring Set Building and Certification Page 7 of 11 060 1000 0084 01 f In the check box list in the middle of the window uncheck all items except for Test Point Results repeated This list controls the data sent to the workshe
4. product and other features The purpose of the Valve Spring Certification template is to create a certificate for a set of valve springs The certificate states that all the springs are within tolerance and how closely they are matched The template is set up to check 8 intake springs and 8 exhaust springs but can be altered by the user for any number of springs The purpose of the Valve Spring Sorting template is to sort large groups of springs into matched sets The user has full control of the overall tolerance of the springs and how closely each set is matched This is done when the user decides how many sub sets are within the overall tolerance A large number of sub sets creates closer matched sets 2 INSTALLING THE LARSON SYSTEMS UTM OR SSS AND THE VALVE SPRING TEMPLATES This section gives step by step instructions for installing the UTM or SSS software 1 Insert the UTM or SSS CD into a CD drive 2 The Setup exe program should run automatically If it does not open the CD and the Explorer window and run the setup exe program 3 Read and follow the on screen instructions to install the program 4 Note the location where the UTM or SSS is installed This path will be needed later when you set up the Excel templates 5 Eject the disk Larson Systems Inc suggests that you copy the Excel Templates from the provided CD to a primary file server These copies should never the altered When they are to be used we suggest that they
5. the Clear All Data button to clear any data the Spring by Spring Results table 6 Click the Begin Testing button This will set the UTM or SSS and the template to begin receiving data 7 Begin testing the parts After each part is tested the 4 sort groups will be filled in Sort the part by the desired group The number of parts that can be tested is limited only by the row limitation of the spreadsheet When all parts are finished click the Stop Testing button If any part needs to be re tested use the mouse to click into the row of the part to be re tested and click the Re Test XX button The template and UTM SSS will be set to receive one test s worth of data 10 If a new sorting group is desired select the desired group s option button and click the Sort button The entire list will sort based on the selected option button 11 When all parts are tested click the Save button to save the results to a file with a unique name 12 When all parts are tested click the Print button to print a hard copy of the results Click the Clear All Data button to clear the results table and begin anew If a new set of testing specifications is desired change the appropriate cells mentioned in step 2 above click the Stop Testing button if it is shown click the Upload Test button to transfer the new testing specifications to the UTM SSS program and finally press the Begin Test button to begin receiving data 2o Co x
6. Excel templates These steps are given so that the original Larson Systems Inc templates can be modified once to create new customer originals for everyday use These steps should be performed for each of the Larson Systems Inc original templates 1 Copy the Larson Systems Inc original to a temporary computer such as your workstation Rename the copy for easier identification Open the template The templates contain un certified macros These macros must be enabled for the template to function properly The Security settings under the Macro section of the Tools menu need to be set to Medium or Low In the High setting all un signed macros are disabled Under the Medium setting the user has the option to enable or disable macros Under the Low setting all macros are enabled without user intervention 4 Switch to the Program Setup tab In cell B1 enter the path to the UTM or SSS program that was installed in section 2 5 Switch to the Program Three Point Test tab a Change cells B5 to D5 to the number of the com port where the tester will be connected b Change cells B6 to E6 to reflect the tester s that may be connected to the computer Set the cell to ACTIVE if the tester shown in row 3 of the individual columns can possibly be connected to the computer Set the cell to INACTIVE if the listed tester will not be connected to the computer 6 Switch back to the Control tab Save the template and close the spreadsheet 7 S
7. Larson Systems Inc 060 1000 0084 01 Excel Template for Valve Spring Set Building and Certification Certificate of Matched Springs Valve Spring Sorting Report insert your logo here gt insert your logo here gt Sample Company Sample Company Test Setup Test Setup Yalve Spring Verification Check Valve Spring Sorting Larson Systems Inc 050 1000 0044 01 Larson Systems Inc 050 1000 0044 02 Test Date 1200 08 Test Date 1210008 Engine Number Larson Tester Model Spring Set Number Tester Serial Number Larson Tester Model SDHT Program Program Three Point Test Tester Serial Number 123456789 Program Program Three Point Test Valve Specifications Sort Specifications 16500 Seat Height 15600 Open Height Units 5 of Sort Groups Engine Info 38 0000 Seat Force 53 0000 Open Force 136 3600 Rate in Inch 8 Number of Cylinders 0 0500 Seat Tolerance 0 0500 Open Tolerance 1 3030 Tolerance Ib Pounds 00800 Intake Valve Lift Valves Fully Open 39 3000 Maximum Seat Force 55 6500 Maximum Open Force 177 6771 Marimum Rate 0 0900 Exhaust Valve Lift Valves Fully Open 36 1000 Minimum Seat Force 50 3500 Minimum Open Force 95 0423 Minimum Rate 0 0200 Valve Retainer Thickness Spring Results a Clearanc Seat Sort Open Sort Rate Sort Average I
8. ake Valve Testing Specifications e Cells B40 to B42 G40 to G42 and K41 to K42 Exhaust Valve Testing Specifications Verify that the tester is connected to the computer correctly Press the Upload amp Test button This will transfer the testing specification to the UTM or SSS program and set the program to receive data from the tester Press the Clear All Data button to clear any existing data in the Spring by Spring Results table Begin testing parts on the tester For manual testers the data will appear in the Spring by Spring Results table as the Send button is pressed For FLASH and FLASH Lite testers the results will appear when the test cycle is finished If a single part needs to be re tested press the Re Test Single Part button A list of parts will be shown Double click on the part to be re tested A verification window will appear showing the selected part When the verification is complete the selected row s data will be cleared The next test s data will appear in the cleared row After the single test is performed the next test s data will appear at the end of the rest of the data If the last few parts need to be re tested press the Re Test to End button A list of parts will be shown Double click on the first part to be re tested A verification window will appear showing the selected part When the verification is complete the selected row s data and all data to the end of the list will be cleared 10 When all parts ar
9. be copied and renamed before opening This will help maintain the integrity of the originals The originals on the provided CD also have their Read Only property set 3 FIRST TIME SETUP Before the Excel templates can be used the Larson Systems software must be set up correctly and the Templates should be set for typical use 3 1 UTM or SSS First Time Setup This section explains how to set up the software correctly The SSS and UTM are very similar products Any picture below uses the UTM product however the SSS has the same menu structure 1 Start the UTM or SSS program 2 Serial Port Setup a Open the menu item Options Setup Port UTM 3 22 Etec Setup Ports Port Options c Wane E SONSON Hardware and i SMaratiers 2 DelayNone M None 8 Even Mak Space b Using the Up Down arrows on the left select the RS 232 Serial port to which the tester will be connected Larson Systems Inc testers currently use only RS 232 Serial communication If your computer does not have any serial ports then you will need a USB to Serial adapter c Select the correct device from the Device Type section For FLASH or FLASH Lite testers use the UT selection For the Super DHT and DHT testers make Excel Template for Valve Spring Set Building and Certification Page 6of 11 060 1000 0084 01 sure to select the correct device If the port is set for a Super DHT and a DHT is connected communication will not
10. e tested press the Save button to bring up a File Save As window to save the results with a unique file name Press the Print button to generate a hard copy of the Print tab 11 If another set of springs is to be tested repeat these test steps beginning at Step 3 5 USING THE VALVE SPRING SORTING TEMPLATE This section covers a typical use of the Valve Spring Certifying template 1 Power on and initialize the tester Refer to the tester user manual for the proper method to initialize the tester 2 Open the template 3 From the Control tab fill in the following cells with the appropriate information a Cells D27 D28 and D30 to D34 Company Name Date Spring Set Number Lot Number Tester Used Tester Serial Number and Program b Cell F28 Valve Retainer Thickness if one is used c Cell F31 number of sort groups within the tolerance range d Cell F33 the Auto Sort check box When this option is checked the spring data is automatically re arranged based on the selected group e Cells B37 to B39 F37 to F39 and J38 to J39 Valve testing specs f Testing Units for both Force and Length g Select the Auto Sort group criteria the option buttons above the right side of the Spring by Spring results If the Auto Sort option from step d is checked the results will automatically sort based on the four groups selected 4 Click the Upload Test button This will transfer the testing data to the UTM or SSS program 5 Click
11. et For the Larson Systems Inc templates only the data is necessary g Click the Alter Macros button Ig Macro Definition i Click inside the Postamble Macro section then double click on the Down item in the Additional Keystrokes list This tells the UTM to move down a cell after each result is sent to the spreadsheet This is necessary for the Larson Systems Inc templates to function correctly ii Click the OK button to close the windows h In the DDE Link Setup section set the Cell to send to item to A1 This specifies the cell where the first piece of data is sent i Set the Cell to receive from section to E2 This is necessary for the bi directional communication to the template j Select the item Send Results On The Fly This allows data to be sent to the template as it is received k Finally check the Enable DDE Receive Ability under the Setup name Click the close button to close the window The First Time Setup for the UTM or SSS is complete Close the UTM or SSS program 3 2 Valve Spring Certifying Template First Time Setup This section explains the suggested first time setup steps for the Excel templates These steps are given so that the original Larson Systems Inc templates can be modified once to create new customer originals for everyday use These steps should be performed for each of the Larson Systems Inc original templates 1 Copy the Larson Systems Inc original to a temporary computer such as you
12. etthe properties of the new template to Read Only to avoid inadvertently overwriting the original 2 3 3 4 First Time Tester Setup Larson Systems Inc FLASH FLASH Lite and DHT tester are set up to work with the Larson Systems Inc UTM or SSS right out of the box The Larson Systems Inc Super DHT tester must have its RS232 settings set up correctly to work with the UTM or SSS product Refer to the tester s User Manual for further information on the following settings 1 2 3 4 5 Output Format must be set to Data Send Results must be set to Yes The following Data Transfer settings must be set Send Heading Send Count Send Date Send Time Send Tab Char Send Length Send Force Communication Protocol set to Hardware Communication Baud Rate set to 9600 o oococp 4 USING THE VALVE SPRING CERTIFYING TEMPLATE This section illustrates a typical use of the Valve Spring Certifying template 1 2 3 Power on and initialize the tester Refer to the tester user manual to for the proper method to initialize the tester Open the template From the Control tab fill in the following cells with the appropriate information a E24 to E30 Company Name Date Engine Number Spring Set Number Tester Used Tester Serial Number and Program b Cells H24 and H72 Number of Cylinders and Valve Retainer Thickness if one is used Testing Units for Force and Length d Cells B33 to B35 G33 to G35 and K34 to K35 Int
13. ntake Valve Specifications Units Date Toleramc Group Group Group Sort 16500 Seat Height 15600 Open Height in Inch 38 000 Seat Force 54 000 Open Force 166 66 Rate Ib Pounds 10 00 Seat Tolerance 10 00 Open Tolerance 60 66 Tolerance 41 800 Maximum Seat Force 59 400 Maximum Open Force 267 755956 Maximum Rate 34 200 Minimum Seat Force 48 600 Minimum Open Force 65 564044 Minimum Rate Exhaust Valve Spe 18400 Seat Height 15500 Open Height 39 000 Seat Force 56 000 Open Force 166 66 Rate 10 007 Seat Tolerance 10007 Open Tolerance 60 66 Tolerance 42 900 Matimum Seat Force 61600 Maximum Open Force 267 756 Maximum Rate 35 100 Minimum Seat Force 50400 Minimum Open Force 163 027 Minimum Fiate Spring Results Seat Open Clearanc Force Condition Force e Condition Spring Summary Intake Summary 3DIVIOI 3DIVIO Matched better than 0 00 Exhaust Summary DIVi0 _ Matched better than 0 00 Test Performed By Date Excel Template for Valve Spring Set Building and Certification Page 2 of 11 060 1000 0084 01 About This Manual This manual could contain technical inaccuracies or typographical errors Changes are periodically made to the information contained herein These changes will be incorporated in new editions of the manual Copyright
14. r workstation 2 Rename the copy for easier identification 3 Open the template The templates contain un certified macros These macros must be enabled for the template to function properly The Security settings under the Macro section of the Tools menu need to be set to Medium or Low In the High setting all un signed macros are disabled Under the Medium setting the user has Excel Template for Valve Spring Set Building and Certification Page 8 of 11 060 1000 0084 01 the option to enable or disable macros Under the Low setting all macros are enabled without user intervention 4 Switch to the Program Setup tab In cell B1 enter the path to the UTM or SSS program that was installed in section 2 5 Switch to the Program Three Point Test tab a Change cells B5 to E5 to the number of the communications port where the tester will be connected b Change cells B6 to E6 to reflect the tester s that may be connected to the computer Set the cell to ACTIVE if the tester shown in row 3 of the individual columns can possibly be connected to the computer Set the cell to INACTIVE if the listed tester will not be connected to the computer 6 Switch back to the Control tab Save the template and close the spreadsheet 7 Set the properties of the new template to Read Only to avoid inadvertently overwriting the original 3 3 Valve Spring Sorting Template First Time Setup This section explains the suggested first time setup steps for the
Download Pdf Manuals
Related Search