Using the SCS-1 Saturation Curve Solver

This is a step-by-step guide on using Dr. Kirk's Saturation Curve Solver (SCS-1) for determining shot peening intensity from 4 data points. The Curve Solver was developed by Dr. David Kirk as an aid to determine shot peening intensity using a Microsoft Excel spreadsheet. Dr. Kirk's Excel template files are available at www.shotpeener.com The video references text to be copied and pasted from a text file. The same text may be copied below this line. --------------------------------------------------------------------------------------------- Sub RunSCS1Solver() ' ' Macro that runs through the 4-data point solver process. ' By Dave Barkley of EI SPT ' Range("J6").Select Selection.Copy Range("J4").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("H16").Select SolverOk SetCell:="$H$16", MaxMinVal:=2, ValueOf:="0", ByChange:="$J$4:$J$5" SolverSolve (True) End Sub