From: Arthur W. Brooks Sent: Monday, August 15, 2005 5:18 PM To: Brentley C. Stratton Cc: Steve Raftopoulos; Wayne T. Reiersen Attachments: Side Clamps Shim Sizes.xls; Mod C Clamp Numbering.ppt Brent, Attached is a draft of the spreadsheet that will integrate the Romer Arm measurements of the Modular Coil Winding Form (when then become available) and produce a table of side clamp shim sizes. It employes Mike Zarnstorff's second method for controlling the current center which takes into account changes in coil cross-section area. These changes are predicted based on the coil curvature and torsion using the experience gained on the TRC (side A). A few comments on the spreadsheet - The data assumes we will collect data following the "standard pattern" specified in Steve's Metrology Procedure and uses the clamp numbering scheme and Side A/B identification shown in Dave Williamson's ProE Model which is highlighted in the attached powerpoint document. There are a number of worksheets that serve as place holders for the Romer arm data as was done for the TRC data. The summary sheets serve to average the data at each section. At the moment they are all filled with 0. As a consequence, the calculated shim sizes on the first worksheet (last 2 columns to the right) at the moment reflect only the shiming required due to coil curvature and torsion. It should be noted that the side A and Side B are predicted to behave differently (different area changes) during winding because the Out of Plane Curvature in general differs on each side. This results in the target heights of the two sides being different to preserve the current center even for a perfect winding form. Finally, the coefficients of the fit for the height change based on curvature and torsion during winding differs from what was previously given due to a correction in the value of the spacing of the current centers of side A and B. Art