Home

USER MANUAL - Carol Margot DeLong

1. 21861 134 73 134 92 135 34 135 21 0 00 21866 13462 134 78 135 32 135 09 0 00 21871 1344 13458 135 18 13541 135 03 0 00 TIP With your cursor in the top cell of the range key Ctrl Shift d to select every cell in the column within the isolated range 3 Copy the selected data TI P To copy the selected right click on the data and choose Copy from the hold down menu 4 Paste the data in the target column TIP To paste the column place the cursor on first cell of your target column Right click and choose Paste Special Values OPMIC Page 21 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Al OAK AL AM AN AO AP Ctrl p to select strain time and temperature data based on temperature interval original data selected data by temperature interval temperature timedmin strain temperature timeimin strain In this example the T5 copied values in the range of interest are pasted into the work area original data Temperature on CTE FORM XLS page NOTE You can also paste selected data into a new spreadsheet or template 5 Repeat steps 2 through 4 for each desired column in the selected range That is copy microstrain column M to the computation area Strain column AL Copy accumulated minutes column AE to the computation area time min column AN Extracting Data for a Specified Temperature Interval d d PMIC Use the work area on CTE_FORM XLS designed for this pu
2. The result shows the reformatted endpoints of interest Figure 15 Aug CTE 130 to OC 0 41 44 0 ppm C U ZU 40 B SU 100 120 140 Figure 15 Endpoints of Interest PMIC Page 29 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Calculating Average CTE To calculate the Average CTE a Right click on one of the endpoints of interest graphed on the report spreadsheet Figure 15 Choose Add Trendline ne Add Trendline select Linear and Series 2 Seres On the Options tab Add Trendline select Automatic and Display equation on chart Click OK ds The result is shown in this enlargement of the Thermal Expansion graph OPMIC Page 30 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Avg OTE 130 ta 04 0 41 0 01pprn c y 0 37578 283 088 The computed CTE value is 0 3757 Note to complete this report LJ Copy computed CTE value and paste it over 0 41 in the original template LJ Remember to change the values 130 0 C to the range of interest values LJ Remember to change 01 to the correct uncertainty as calculated in Chapter 5 Closing the Program L If the test results are acceptable save the spreadsheet On the menu choose File Save as Give the spreadsheet a new name Caution Do not save CIE_form xls as it contains calculation formulas If this file is accidentally saved use the software CD to restore the original Click Step5
3. Hi3 Cc E CA AA A e s ET shartcut Ctr t to plot microstrain vs temperature graph Ctrl D to plot all the specimen s temperature Ctrl p to select strain time and temperature data based on temperature interval Lo 5 000 in 1 cwc fringe 12 455 E 6 in i1 fringe half wavelength oflaser 12 456E 6 in 316 4 nm data lag TM eaea cote D Eum 3 82 NMT l z S is large and is divided into three parts Part 1 details in Figure 4 contains selected data You can use this data to generate a temperature vs microstrain graph lt ctrl gt T or a time vs temperature graph lt ctrl gt P Part 2 details in Figure 5 contains date and time information e Part 3 details in Figure 6 contains a worksheet to assess and refine computations 8 You may see the following message Microsoft Excel x There is a large amount of information on the Clipboard Do vau want to be able to paste this information into i another pragram later To save it on the Clipboard so that you can paste it later click Yes To delete it From the Clipboard and Free memory click Ma If you see this message click No OPMIC Page 16 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 EY CTE_FORM XLS shartcut Ctrl rr to T WS graph Ctrl b to plot all the specimen s temperature CI p to select strain time and temperature data based on temperature interval E 5 000 in 5 1 pur fri
4. Index PMIC September 6 2007 N 4 of BR a A h A Oo WB GU QU BW WwW QU NNN NO 6 OF 014 2 O O N O Page ii MI 900 DATA ANALYSIS GUIDE PMI 900 730 Figure 1 Figure 2 Figure 3 Figure 4 Figure 5 Figure 6 Figure 7 Figure 8 Figure 9 Figure 10 Figure 11 Figure 12 Figure 13 Figure 14 Figure 15 Figure 16 PMIC FIGURES PECHECI sheet law aiid Selected Dita Di bi T2 PEHE cM noc T aaa M 19 PRCHECK Chart 1 1 106000 as anne E eoo aee nite rob pere ka ava aei area a ed cia 14 T Forms Make Tapas pati bornini aab O iia 17 CTET m Wake Tap PA EA O de ue nn 18 ETE Ros Make Graphs By 1m o soto et pet A A A LA A AS OS 19 CTE Porms Make Graphs Mictostrain vs Ten petatufe needed err be ues bibi etit Emo i aede b de FS danse 19 CITE Borns Make Graphs Temp rature ys Data PODES ud nitide tu A sek iae ada br ode td b PH RE S ota RC ea era 20 Microstr ta vs Temperature selected Data Dy Intervalo EA PRIOR Ind o ee IM ro b none 23 Men t LB by Compara Graph witi RAW DAA e ann onte pedi rete E a 25 CTE Data Page of Report Template iiie ii 26 Thermal Expansion ReporbE xa plena aci to i Arean pacer a bandanas aonsiess RS treu a odas us Dec EARO EE a 27 extracted Data Pastedio Veta late ass ia aio 28 Graph ot Pasted ErndpoltSadi A Ad 28 Endpolmnts of Interests 29 Error Calculation R T cut 25 Page iii September
5. Contains 13 Files O Folders Created Today January 10 2003 1 22 29 PM Attributes imd iBead only Advanced Hidden coca te f Inthe Confirm Attribute bp Ch an ge WI n d OW cl ick You have chosen to make the Following attribute change s Apply changes to this unset read only folder subfolders and files g Click OK Do you want to apply this change to this Folder only or do you want to apply it to all subfolders and files as well C Apply changes to this folder only 2 This is not optional The analysis programs must be installed on the C drive as described IMPORTANT These programs require the Excel program to have the following path C Program Files Microsoft Office office excel exe PMIC Page 5 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 4 Create a data folder in CTE CA CTE data This where your raw data files 5 Create shortcuts for the CTE analysis program and or the Review Data program on your Windows desktop For example a On the desktop right click E This wizard helps you to create shortcuts to local or an d C h OOSE network programs files Folders computers or Internet New Shortcut addresses Type the location of the item I n th e Create Sh ortc ut C CTE RunICTE NASA995 15 exe Browse window type the location of the item C CTE Run CTE NASA995 15 exe Click Next to continue Or click Browse to locate this file Cancel Click
6. measured length Lo 11 Reference for this info to be added 12 Reference for this info to be added PMIC Page 34 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Appendix A Troubleshooting THIS SECTION TO BE ADDED SOON PMIC Page 35 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Appendix B Some Data Selection Examples A satisfactory data selection has from 5 to 20 data points between peaks of raw data The following Examples illustrate how to use the CTE Data Analysis program to optimize your data selection 1 Raw data file size lt 64 000 data lines Step 1 Read raw data Accept default 1 Accept default 1 Accept default 0 Step 2 Calculate data Data Increment Number First iteration Accept default 1 Case 2 Second and subsequent iterations Adjust increment to produce the desired data sample Step 3 Check Data If Chart 1 2 and 3 data is well distributed e g at least 5 data points on every cycle of raw data and if are satisfied that your data is not too dense go on to Step 4 If Chart 1 2 and 3 data is very dense e g more than 10 data points per cycle of raw data and if your file has a large number of data points go to Step 2 Repeat the Calculate data and check Data steps until you have a satisfactory sample Go on to the next step If Chart 1 2 and 3 data points are scanty e g if the raw data has cycles with fewer than 5 data points then the test
7. 73 71 5 756 03 11 B F2 00 0 982066 1 69391 41 0 970562 73 96 5 396 03 12 7 f2 01 0 979667 1 58784 4B 0 95831 F4 21 2 40E D2 1 2 10 72 73 0 960361 1 58315 51 0 940412 74 59 4 66 E D 14 J E 31 039091 1 67117 0 930415 74 66 2 466 02 15 202 0974456 165326 0 601697 do 0 14567 H A chart 2 000 _f Chart 3 88000 T Chart 4 183000 f ele Sheeti Lal Ready TT Figurel PKCHECK Sheet 1 Raw and Selected Data Row 3 A D tells how many data points are in the raw data These columns contain values for temperature plus x and y beam component data Row 3 E H tells how many points were used in calculations for the graph In the above example the data increment was 5 Column E lists the selected data points Columns F and G contain test data for selected points Other columns contain computation values OPMIC Page 12 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 ELLIPSE 5 Chart Area e 15 3 1 16000 D 16000 32000 32000 48000 T 48000 64000 1 0 5 0 2 0 4 0 6 0 8 1 12 14 voltage Figute 2 PKCHECK Ellipse Look for a stable concentric ellipse with a clear opening at the center An ellipse like this one indicates valid data Any aberration such as frequent bending failure to paint around a consistent center scattered circles or erratic lines suggest faulty data If this occurs refer to Troubleshooting 160 4 725 140 Plot Area a 2 120 100 y E uE
8. 93 133 77 552 52 20 00 133 77 20 00 133 38 553 52 20 23 133 38 20 23 132 24 554 52 20 01 132 24 20 01 131 23 555 52 18 87 131 23 18 87 130 41 555 52 19 79 130 41 19 79 129 36 567 36 18 72 128 35 18 72 128 15 557 52 19 70 128 15 19 70 127 71 568 52 18 43 12T 71 18 43 126 70 569 36 18 75 126 70 18 75 126 45 558 52 18 70 126 45 18 70 125 42 70 19 18 58 125 42 18 58 Sla 570 52 18 55 SNE 18 55 124 02 571 19 18 51 124 02 18 51 123 55 STS ES 18 44 123 55 18 44 12247 572 19 18 27 122 47 18 27 122 25 572 52 17 81 122 25 17 91 121 17 a 3 35 17 42 IS 17 42 120 92 5473 52 17 40 120 92 17 40 119 39 574 19 17 25 118 38 17 25 118 10 574 52 17 18 118 10 17 18 117 88 575 19 16 48 117 99 16 48 117 43 57557 14A 70 117 43 1R 70 2 Click the Chart 1 tab 3 Select from the menu Edit Paste Special 4 Select T xl New Series Add cells as Values 3 in and Mew series Rows Categories X Values Mew point s f Columns Cancel in First Column Click OK Series Mames in First HOW Replace existing categories PMIC Page 24 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 EE 0n b0DQ o oo0o0GUu bn temperature A Figure 10 Verify CTE by Comparing Graph with Raw Data In this example satisfactory data selection produces a graph Series 2 congruent to the raw data graph Series 1 OPMIC Page 25 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 90
9. E 4 a yi t a i Hau en NE 60 Lt e AE SP Wer a es j E a A I WE uas Mr A E WL T KE de q M ee S EZ a i PTE lud LT I E TY our Eo ERA SAPO E a e WERI g Pu Wa 0 ME BU y M a AF y i axe Md g 40 20 20 2000 4000 6000 8000 10000 12000 14000 16000 data point PMIC Page 13 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Figute 3 PKCHECK Chart 1 1 16000 Temperature C and displacement voltage are plotted against data points 2000 16000 Temperature is the blue sinusoidal line Voltage is the red line representing raw data The dots A are the selected data points Charts 2 3 4 are similarly plotted for their respective data point ranges This graph provides preliminary assessment of the data sample Examine Chart 1 to assess the data selection Look for a plentiful but not excessive distribution of data points on each temperature cycle See Note B Do the same for Charts 2 3 and 4 if applicable Note B To examine a segment of the Chart 1 graph in detail double click the X Axis and adjust the scale in the Format Axis window Patterns Scale Font Mumber Alignment Value X axis scale aua Minimum 4000 m Maximum Em Major unit 2000 IZ Minor unit 400 M value Y axis Crosses at 2000 Display units None M Show display units label on chart Logarithmic scale In this example the horizontal axis initially 2 16000 is adjusted to examine dat
10. Next In Select a Title for the xl Prog ram type a Type a name for this shortcut CTE MASA995 15 convenient name for the S h O rtc u t s Click Finish to create the shortcut Click Finish Repeat this step for the other program review data NASA995 15 exe if you need it on this computer Cancel This completes installation 5 The data folder can be created in another location if you prefer PMIC Page 6 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Chapter 3 CTE Data Analysis The CTE Analysis program computes the coefficient of thermal expansion in parts per million The program takes as input a raw data file containing all the lab data generated during testing Output is in the form of Excel spreadsheets Use the CTE Analysis program and spreadsheets to Assess data validity Select which data to use Generate graphs and reports Preparation Before you begin ensure that The CTE NASA995 15 exe program has been properly installed See page 5 The raw data test file is accessible from your computer Running the Program To use this program a Click the CTE NASA995 15 program icon to start the program NOTE Analyzing the test data is an iterative process The number of iterations depends upon the quality and quantity of data and most importantly on the expertise of the analyst Raw data is captured on 15 data channels as follows Columns A G contain date
11. and time information Corresponding data logged for each data channel follows CH 1 is recorded room temperature Ch 2 Ch 4 are Thermocouple data specimen 1 Ch 5 Ch 6 are Thermocouple data specimen 2 CH 7 Inner Heater Temperature CH 8 Outer Heater Temperature Ch 9 i Diode data voltage data CH10 is Set point CH 11 CH 12 are Specimen 1 beam displacement data X and Y respectively CH 13 CH 14 are Specimen 2 beam displacement data X and Y respectively Ch 15 is Pressure data PMIC September 6 2007 Page 7 MI 900 DATA ANALYSIS GUIDE PMI 900 730 im CTE analysis main menu PMIC September 6 2007 This window remains open as you work As you proceed through the steps a star icon appears only after the most recent step completed Later if necessary you can return to this window and click a selection to repeat the step Page 8 MI 900 DATA ANALYSIS GUIDE PMI 900 730 L Click Step 1 Read Raw Data w Read raw data form Biel E Oj xj Enter the raw data file name complete path Enter the channel Mameffull path af input raw data File c ctedataWASA data 15 csv numbers for the x and Y displacement data Enter 11 and 12 for specimen 1 Or enter 13 and 14 for specimen Channel E of the data to be extracted D Channel of the lt data to be extracted Channel of T1 data to be extracted Enter five W channel numbers Channel of T 2 data to be ext
12. disable macros but if the macros are legitimate you might lose some Functionality Enable Macros More Info New file O x O On the first iteration accept the default Y If you are repeating this step enter N m PMIC Page 11 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Allow processing time When processing is complete Ready appears in the lower left corner of the PKCHECK spreadsheet The PKCHECK spreadsheet file has these tabs See Figure 1 Sheet 1 Figure 1 contains all the raw data Ellipse Figure 2 contains a plot of voltages from the photo detector x and y components of the laser beam Chart 1 Figure 3 graphs temperature and voltage vs data points 1 16000 Chart 2 graphs temperature and voltage vs data points 16001 32000 if any Chart 3 graphs temperature and voltage vs data points 32001 48000 if any Chart 4 graphs temperature and voltage vs data points 48001 64000 if any PA B D E F j G a 1 selected data 2 data paint x data temperatur fringe 3 55997 aba 55997 miss 11399 11399 11399 4 1 72 811 0721036 1 39274 b 0 979456 72 82 0 45233 5 2 72 891 0 727711 1 41306 11 0 976091 72 91 0 00263 5 E 72 811 0 979337 1 66795 16 0 973657 2 93 6 056 03 4 72 811 0979151 1 67902 21 0974429 3 04 1 48E 3 D 5 414 0 977345 1 67066 26 0 975309 73 17 3 24E 3 3 z 72 892 0979456 1 67900 31 0 960863 73 53 1 556 02 10 Fl 72 82 0902556 1 70106 36 0 97121
13. temp 14 E 0 000695 A Et Ll een PA AA ES eM 15 Elo D 0001429 EM LL ae jM Dem 22N 16 Er D 0014142 7 guideline for the best estimation ai measurement uncertainties 1 eee 18 juwetainysouces 1 besestmtkn TL 9 i temperatures GENE R AR NN RENAN IR EA RU OCR CS RS RS PS PE RE ecc COUR Can A a o can tc MM MUNMMAM Md 3 Fringe pattern ES i i i l i measuemert system stabilty RRE Meu KIC s XP CEA ERA aoa and lacer system sanity E NN E MARRE MAN MM E analysis method angle c caiculsbon ee io OA finge i ASE IE A EA RRA RRQ RSR IRE hit DR SS eM ee 8 Figure 16 Error Calculation Worksheet Comments visible on mouse over at the red markers provide important information OPMIC Page 33 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 The CTE uncertainty is calculated by the equation 2 2 2 0 5 Ea Er E Ear where a is the CTE calculated CTE AL L AT Er is the calculated uncertainty of the CTE due to temperature change AT using best estimate of measured temperature error EALis the calculated uncertainty of the CTE due to measured length change AL using best estimate of error in the measured fractional fringe Eio is the calculated uncertainty of the CTE due to the estimated error in the
14. 0 730 Chapter 4 Preparing Reports A PMIC standard report template is provided See Figure 11 and Figure 12 Copy and modify this template to as needed for project requirements Material Temperature 200C to 240 Tests conducted with a Michelson laser interferometer measurement system ASTM Standard E 289 95 performed in vacuum Date SPECIMEN 71 SPECIMEN 2 Microstrain Microstrain Figure 11 Copy extracted data from CTE forms into this template When the analysis programs are loaded the path of the template is C NCTEARun report C CTE Run report template xls OPMIC Page 26 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Thermal Expansion af SPECIMEN 1 B 1 Ll cl ll ll lll ll L l Ll aa ee Li SE L1 L lll Microztrain AL Lo ppm ral 2l 40 b g t te 40 Temperature C Los 5 Aw CTE is calculated as a secant CTE al value is caoulated measurement uneei aniy NX CTE deta specimen 1 la Figure 12 Thermal Expansion Report Example The legend is an easily edited text box Change Avg CTE 1 30 to 0 C to reflect your range of interest for example CTE 125 to 10 C Calculate the average CTE as described in Calculating Average CTE and paste it here replace 0 41 Calculate the measurement uncertainty by the method described in Chapter 5 Paste result here replace 01 to complete your report To use make a report usin
15. 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Chapter 1 Introduction As specialists in thermophysical and micromechanical measurements PMIC is ready to meet your dimensional stability and thermo mechanical measurement needs We feature a variety of testing services ranging from thermal expansion CT E moisture expansion CME thermal conductivity TK mechanical properties optical properties and non destructive testing PMIC offers custom development and design of instruments and applied research to a variety of industries Please visit our Web site at http www pmiclab com MI 900 The MI 900 employs Michelson laser interferometry to measure real time thermal expansion contraction for maximum resolution and accutacy Each shift in a fringe pattern corresponds to a change in specimen length of one half the laser wavelength 12 456 micro inches for a He Ne laser in vacuum Precision optics photo detectors and interpolation techniques produce length resolution accuracy within less than three micro inches SPECIFICATIONS Resolution 0 03 ppm F Temperature Range 30K 420K Specimen Size Maximum 2UXT AUS Lab Control Software LABVIEW CTE Test Program MI 900 executable The MI 900 Data Analysis Application This application provides a set of tools for Data quality assessment Data selection CTE computation Error computation D D D DOLD Preparing reports Prerequisites Environment The CTE Data Analysis program requi
16. 7 1 5335 1 600183 1 966867 2 13355 2 300233 2 466917 2 6336 2 900203 2 966967 3 13365 3 300333 hr 0 005001 0 007778 0 010557 0 013335 0 016113 0 015891 0 021669 0 024447 0 027225 0 030003 0 032761 0 035559 0 038337 0 041115 0 043543 0 046671 0 049449 0 052220 0 055006 Page 18 MI 900 DATA ANALYSIS GUIDE PMI 900 730 2 E Se eee ee PER EPA Ctrl p to select strain time and temperature data based on temperature interval originaldata selected data by temperature interval timeiminy CTE Forms Make Graphs Part 3 To see this part of the spreadsheet move the bottom slider to the right Use this table to generate microstrain data for a specified temperature interval See Extracting Data for a Specified Temperature Interval E zz E E 3 temperature Figure 7 CTE Forms Make Graphs Microstrain vs Temperature Microstrain in parts per million plotted as a function of temperature PMIC Page 19 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 QI Key lt Ctrl gt b to plot all the specimen s temperatures 160 m k a im m RB di OO ug rd c O MM c FR CO 41 MN C O M cC e CO UU dd MA O MA c Et GD DD 5 rn mo DO co eae rr LD O O us LL u Wu YN MMA A 7 CM UC C4 NH M hb FF c a rm Ci OU e Ci e 0 du PF C e 0 G e C e a u PFP rm Rem hem Am AR 2 eee IT DE a a A LA 30 4
17. Exit Close Excel If you did not previously save the CTE_form xls you will see the following message 10 Microsoft Excel x Click No AN Do vou want to save the changes you made to CTE FORM ALS DL Mo Cancel If you copied data to the clipboard you may see the following prompt 10 REMINDER CTE_FORM XLS and PKCHECK XLS are calculation templates with programmed formulas Never save them To save results use the menu File Save as PMIC Page 31 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Microsoft Excel Click No OPMIC Page 32 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Chapter 5 Error Calculation Use the Error Calculation Worksheet to assess the reliability of test results INPUT FIELDS are yellow CALCULATED FIELDS are violet Input the following values Lo gage length Lo highest temp Highest Temperature in range Lowest Temperature in range lowest temp Ero length Lo error Ear fringe error Er highest temp error Er lowest temp error E is the uncertainty of the calculated CTE due to uncertainties of the measured values IMPORTANT This manual and the Error Calculation spreadsheet template Figure 16 will be updated with best estimation data in the near future Ed Microsoft Excel error calculation 1s i LET _ 1 E LEE total of fringe pattern i enter highest temp EN i DET enter lowest
18. IN KA K KA KA IN KA KA KA KA KA K KA KA Md K mo 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 CTE Forms Make Graphs Part 2 date 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 hr 15 15 15 15 15 15 15 ie 15 15 15 15 15 15 ie is 15 15 15 15 min 10 10 10 10 10 11 11 11 11 11 11 12 12 12 12 12 12 13 13 increment sec 1100 sec sec 53 0 29 11 0 49 18 002 21 58 10 001 31 0 63 10 001 411 0 79 10 001 51 0 59 10 001 1 0 99 10 001 11 1 09 10 001 2 1 19 10 001 31 1 28 10 001 47 1 39 10 001 51 1 49 10 001 1 1 58 10 001 11 1 639 10 001 2 1 79 10 001 31 1 89 10 001 411 1 99 10 001 gl 2 09 10 001 1 2 19 10 001 11 im 229 10 001 To view this part of the spreadsheet move the bottom slider to the right This block contains time information for each selected data point Columns V Z and AA AB contain year month day hour minute and second data for each selected data point Column AC displays the time increment between data points Columns AD AE and AF show accumulated time in seconds minutes and hours respectively PMIC September 6 2007 time ofthe test SEC 18 002 20 003 30 004 49 005 50 006 68 007 78 000 00 009 36 01 108 011 118 012 128 013 138 014 148 015 158 015 158 01 7 178 018 188 018 188 02 min 0 300033 0 466717 0 6334 0 800083 0 966767 1 13345 1 300133 1 45581
19. PMIC MODEL MI 900 Data Analysis G PMIC O Precision Measurements and Instruments Corporation September 6 2007 uide PRECISION MEASUREMENTS AND INSTRUMENTS CORPORATION 3665 SW Deschutes Street Corvallis OR 97333 TEL 541 753 0607 FAX 541 753 0610 EMAIL info pmiclab com MI 900 DATA ANALYSIS GUIDE PMI 900 730 MI 900 Documentation The following documentation is provided for this product PMIC Model MI 900 Installation and Operator Guide PMI 900 710 PMIC Model MI 900 Troubleshooting Guide PMI 900 720 PMIC Model MI 900 CTE Analysis and Troubleshooting Guide PMI 900 730 PMIC Model MI 900 Limited Warranty and System Components PMI 900 740 U U U LU The documentation for MI 900 is available on CD PMI 900 700 PMIC September 6 2007 Page i MI 900 DATA ANALYSIS GUIDE PMI 900 730 TABLE OF CONTENTS MI 900 Documentation TABLE OF CONTENTS FIGURES Chapter 1 Introduction MI 900 The MI 900 Data Analysis Application Prerequisites About this Guide Chapter 2 Installation Chapter 3 CTE Data Analysis Running the Program Extracting Data for a Particular Range Extracting Data for a Specified Temperature Interval Chapter 4 Preparing Reports Calculating Average CTE Closing the Program Chapter 5 Error Calculation Appendix A Troubleshooting Appendix B Some Data Selection Examples 1 Raw data file size lt 64 000 data lines 2 Raw data file size 64 000 data lines
20. a points 4000 8000 by changing the Minimum and Maximum X values Click OK to see the result Values in reverse order value Y axis crosses at maximum value ces In this example the resulting detail of the graph shows a generous distribution of selected data points over the raw data Ideally from 5 to 20 selected data points lie between each pair of peaks in the raw data j If you have too many or too few change the increment and do another iteration See Appendix B To adjust the Data Increment go back to the CTE i l 1464 d yy 1 Analysis Menu and click Step 2 Calculate Data Microsoft Excel x Ph AN Do vou want to save the changes vou made to PECHECK XLS No Cancel go to the next step 7 IMPORTANT PKCHECK XLS is a calculation template with programmed formulas Never save it If you want to save this result use the menu File Save as PMIC Page 14 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Ll Click Step 4 Make Graph The Excel spreadsheet CIE FORM XLS opens Microsoft Excel x L1 Click Enable Macros The default is Y MASA data 15 cz4 OPMIC Page 15 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Processing time depends upon selected data set size When complete READY appears in the lower left corner of the Excel window Ed Microsoft Excel CTE F RM XLS Aj nml x File Edit View Insert Format Tools Data Window Help la x
21. corded There is one data line for evety raw data point PMIC Page 9 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Reduction Factor X Total number of data lines 56998 input the reduction D factor default 1 MESA Cancel Start line M start X Total number of data lines 563998 input M start D default 1 beginning of the input file _ ok Cancel End line M_ end Total number of data lines 56998 input M end default U gt the end af the input file If number of data lines is 64 000 accept the default 1 This selects the entire data file If the number of data lines is more than 64 000 see Note A You can reduce the sample size by entering a reduction factor greater than 1 E g fora file of 120 000 data lines enter 2 to select 60 000 lines OO Entera reduction factor OO Click OK Breaking data into segments is a troubleshooting technique In most cases you should accept the default here M_start 1 To specify a segment set M_start to the number of the first data line in the segment you want to analyze Cl Enter the number of the segment start point O Click OK In most cases you should accept the default M_end zero which takes in all data to the end of the file Specify the end of a segment by setting M_end to the number of the last data line in the segment O Enter the number of the segment end point L Click OK Allow time for pr
22. data point a a Figure 8 CTE Forms Make Graphs Temperature vs Data Points Temperature readings for the five data channels plotted as a function of data points time Many possibilities exist for displaying data and producing reports from the CTE_Forms spreadsheet The following examples are useful and may be combined or modified to satisfy project requirements Extracting Data for a Particular Range This example extracts microstrain data for only the final temperature cycle L Locate the final temperature peaks on the Temperature graph Figure 8 O Position your curser on the first peak and note the A information In this example the first peak occurs at data point 4372 start of desired range Series T6 Point 4372 value 135 20 O Locate the second peak In this case data point 5409 ends the desired range Series T6 Point 5409 Value 134 53 L Locate each of these data points in the first column of the CTE FORM spreadsheet Figure 4 Copy the columns of interest within the range Note C Many techniques can be used to copy columns from the desired range to the work area The following example illustrates one technique PMIC Page 20 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 1 For convenience insert a row above the start point and a row below the end point to temporarily isolate the range of interest from the rest of the data A E A j slope of i A fringe i Afringe s
23. g this template O Copy extracted data into the CTE Data page In the following example Ts temperature data time and microstrain data for Specimen 1 is copied from CTE_Forms Figure 9 into the template Figure 13 Ol Using lt ctrl gt click select the endpoints of your range of interest that is two values in column and their corresponding values in column C Copy these points OPMIC Page 27 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Figure 13 Extracted Data Pasted to Template LJ Click the Specimen 1 tab L Click the menu Edit Paste special Select New Series and Categories X Paste Special x Values in First Column Add cells 45 Values Y in Click OK New series L Rows C Mew point s Columns Cancel Series Mames in First HOW Replace existing categories The result is a linear graph Figure 14 Thermal Expansion of SPECIMEN X1 Micrartrais L La ppm m H LL El Il 3111 11 191 15 Teepe alse X Ln 5 Aug CTE ir calculated ar arecant CTE f value ir zalzulatedmearuarementunzerkainky Figure 14 Graph of Pasted Endpoints PMIC Page 28 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 L To format the points right click on the new graph and select Format Data Series On the Patterns tab select Fema o Line None Marker style and color as desired 0o Duae es Order Click OK
24. has not yielded sufficiently reliable data to continue Go to step 5 and exit Retesting is indicated 2 Raw data file size 64 000 data lines Step 1 Read raw data Reduction Factor First Iteration Choose a reduction factor to reduce the file size to 64 000 or fewer data lines Example 180 000 data lines 180000 64000 2 8125 gt a reduction factor of 3 18000 3 60 000 data points Second iteration Case 6 Adjust increment to produce the desired data sample M statt First Iteration Accept default 1 Case 5 Accept default 1 Case 6 If more that 64 000 points in sample define a segment by entering the number of the first data line in the segment which can be 1 First Iteration Accept default 0 Case 5 Accept default 0 Case 6 If you are defining a segment enter the number of the last data line in the segment Step 2 Calculate data Data Increment Number First iteration Accept default 1 Case 5 Second and subsequent iterations Adjust increment to produce the desired data sample Step 3 Check Data If Chart 1 2 and 3 data is well distributed e g at least 5 data points on evety cycle of raw data and if are satisfied that your data is not too dense go on to Step 4 If Chart 1 2 and 3 data is very dense e g more than 10 data points per cycle of raw data and if your file has a large number of data points go to Step 2 Repeat the Calculate data and Check data steps until you have a satisfactor
25. mermin strain 133 84 562 36 19 93 133 84 562 36 19 93 larr 552 52 20 00 SET 552 52 20 00 133 83 562 539 20 04 133 38 553 52 20 23 133 55 562 06 20 10 132 24 554 52 20 01 133 38 563 02 20 07 H N 555 52 18 87 155 54 563 19 20 20 130 41 566 52 19 79 133 59 563 36 20 35 129 36 567 36 19 72 133 38 563 52 20 23 129 16 56r 52 19 70 133 29 563 69 20 30 127 71 558 52 18 43 133 18 563 00 20 14 126 70 569 36 18 75 133 564 02 20 06 126 45 558 52 18 70 132 85 554 18 20 04 125 42 570 18 18 58 132 58 5h54 35 19 98 125 13 57 52 18 55 1323 24 554 52 20 01 124 02 571 18 18 51 1323 18 564 69 19 93 123 55 871 52 18 44 is e 564 ab 19 94 122 47 472 18 18 27 132 06 565 02 19 91 122 25 572 52 17 91 131 60 565 14 19 90 121 17 53 36 1 7 42 131 48 555 35 19 88 120 92 573 52 17 40 ll 555 52 18 87 118 38 574 19 17 25 130 93 565 69 19 65 119 10 574 52 17 18 130 87 565 856 19 83 117 98 575 18 16 48 130 68 566 02 19 83 117 43 575 52 16 20 Figure 9 Microstrain vs Temperature Selected Data by Interval PMIC Page 23 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 L When you finish plot the selected points and compare with the raw data graph 1 Copy the temperature and strain data from selected data by interval generated in Figure 9 Paste them into adjacent columns selected data by temperature interval temperature tirmetmin strain temperature strain 133 84 562 36 19 93 133 84 19
26. nges 12 456 E B in B 70 fringe half wavelength oflaser 12 456E 6 in 316 4 nm E EN EH mum selecte slope of bate data Data E inge ALoto ppm 0 720 r291 7306 7200 72 70 Brig 1 0 00 0 00 1 b 7202 29 3l13 7 272 72 01 0 45 46 23 O48 1 20 2 11 72 91 7295 7 7311 7260 fafa 0 00 2 18 D03 E D 48 1 21 3 16 72 83 3 04 7308 72 75 2S 0 01 0 00 0 30 Ag 1 22 4 J 73 04 73 15 73 21 7302 72 00 0 00 0 02 O D 49 1 23 5 Jb 231 Fab Fab 351 KS ees 0 00 0 00 0 02 E 1 23 5 3113 83 fabs 7358 735 31 53 42 0 02 0 01 0 04 OOOO 0 51 1 27 7 3b r3 3 09 3 b 73 49 fab 0 01 0 01 O03 0 52 1 29 5 4 73 96 4 19 73 94 7405 4 07 0 01 0 02 0 02 0 52 1 30 y jb 74 21 74 43 41 F425 54 23 0 02 0 04 0 107 OO 0 55 1 36 10 5 7453 ABI 4A43 471 F4 F2 0 05 0 02 026 0 59 1 48 11 oh 71 bh FANS P455 7497 74 0 0 02 0 18 0 09 AO 1 54 12 E1 74 0 E 74 771 7507 75 13 0 15 0 02 104 D 76 1 90 CTE Forms Make Graphs Part 1 um This page displays test parameters computations and results for the selected data points See Figure 5 and Figure 6 The raw data point number corresponding to each selected data point is found in column B Shortcuts for making graphs are provided on this page ri E we e kat e A OPMIC Page 17 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 dy w X Y AA AB AC AD AE AF AG Figure 5 BI KA
27. ocessing When complete a star icon appears after Step 1 on the main program menu PMIC Click Step 2 Calculate data Page 10 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 im data calculation form El E mJ x O Enter B data calculation parameters Note In most cases the default values 1 half finge counting shown give the best results Options are a angle calculation used for troubleshooting OO Check to see that air in was emooth data points recotded with CCW rotation If not ec 29 enter n O Click OK filter temperature filter voltage Is air in counter clockwise CEW rotation y smooth the raw data n Cancel OF Allow time for processing l First iteration accept the default 1 to analyze Data Increment Number dud gt y every data line For subsequent iterations Total number of data 56997 input the data increment GE E To reduce the number number default 1 of selected data points enter a larger Cancel number To increase the number enter a smaller increment than on the previous iteration li Ll Enter the data increment LJ Click OK Allow time for processing When complete the stat icon appears after step 2 on the main menu L Click Step3 Check Data The Excel spreadsheet PKCHECK XLS opens Microsoft Excel 7 OO Click Enable Macros CickEeYrumPKICHECK XL5 contains macros Macros may contain viruses Itis always safe to
28. racted Click OK Channel of T3 data to be extracted Channel of T4 data to be extracted Channel of T5 data to be extracted Cancel The raw data file may be very large The following steps judiciously select a subset that gives meaningful output without excessive processing Good data selection may require some iteration Note A This program can handle up to 64 000 data lines If you specify more than that for any operation an error occurs See Appendix B You can reduce the size of a very large file in these ways o Enter a reduction factor n so that only every point is selected o Analyze the data in segments that is specify a limited range of points Repeat the analysis for each subsequent range Example Suppose the raw data file has 192000 data points Do three separate analyses with three ranges as follows 1 64000 S 64001 128000 128101 192000 Important If thermocouples are the only specimen sensors used accept the default values shown 2 3 4 5 and 6 for T1 T5 If the Silicon Diode T9 is used Enter T1 9 Enter any 4 of the other thermocouple data channels 2 3 4 or 5 for T2 T5 preferably including the thermocouple closest to the Si Diode for calibration purposes In general the Si Diode is more precise than the thermocouples at room temperature and below 6 data line contains all the data collected at one data point data point represents a point in time at which data 1s re
29. res MS Windows 98 or higher and MS Office 2000 with MS Excel 2000 spreadsheet program IMPORTANT These programs require the location of the Excel program to have the following path C Program Files Microsoft Office office excel exe Analyst Skill Level This manual assumes that the user has a general engineering or mathematical background and fundamental MS Windows and Excel spreadsheet skills About this Guide This Guide teaches the mechanics of analyzing MI 900 data using the CTE Data Analysis application It provides guidelines and examples but only practice can confer analytic expertise The documentation for MI 900 is available on CD PMI 900 700 OPMIC Page 4 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Chapter 2 Installation 1 Create a CTE folder on your C drive C CTE 2 Copy the application to the CTE folder a Place the Data Analysis installation disc in the CD drive b Copy or drag the Run directory from the CD to the CTE folder C CTE Run 3 Remove the read on y restriction from Run files as follow a Open the C CTE folder b Select the Run folder c Use the menu File Properties or right click and choose Properties d Uncheck Read only in the Attributes section of General Sharing Security the Run Properties window s Type File Falder e Click OK d Location CAETE Aun Size 12 8 MB 13 428 150 bytes 5ize on disk 12 8 MB 13 455 360 bytes
30. rpose Figure 6 Copy Temperature Time and Microstrain data for a range of interest as described above using the work area original data as target columns Ctrl p to select strain time and temperature data based on temperature interval original data selected data by temperature interval temperature timedmin strain temperature fimeimin strain 135 58 729 97 21 01 135 55 7209 04 21 02 135 41 729 21 21 01 135 21 729 37 21 00 134 87 129 64 21 01 134 71 129 71 21 00 134 54 729 97 21 00 134 08 720 04 20 99 133 06 130 21 20 99 133 7 130 37 20 98 153 55 73054 20 97 133 77 130 71 20 96 133 63 T30 87 20 98 133 47 131 04 20 97 Page 22 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 LI To select strain time and temperature data based for a specified interval key lt Ctrl gt P Data selection is as follows Enter DT Data points are selected at 1 intervals But if a ATemperature is less than 1 C then the next point is selected at a one minute interval If ATemperature is less than 1 AND ATime is mote than 1 minute then data is extrapolated to one minute intervals Cancel fi As before when processing is complete Ready appears in lower left corner of the spreadsheet A AK AL Alvi AN ALI AP Ctrl p to select strain time and temperature data based on temperature interval original data selected data by temperature interval temperature tirme mir strain temperature ti
31. um fringe A 135 01 135 08 135 3 135 32 E 0 01 nn TAE 134 91 13503 13541 13536 13521 00 000 0 05 842 134 81 1355 1 135 34 135 64 135 19 0 01 0 00 0 00 8 43 134 76 135 135 37 135 66 135 28 0 00 0 00 B 01 8 43 RE OO I kia RI 134 735 13492 135 34 135 21 0 00 0 00 21 01 21966 134 52 134 78 135 32 135 55 135 08 0 00 0 00 21 02 0 00 0 00 21 01 134 58 135 16 135 41 135 03 A fringe solver 134 55 67 135 21 136 32 27021 13455 1346 13514 135 05 13482 0 00 0 00 0 00 Dar 27026 134 49 134 55 135 08 134 81 134 64 0 00 0 00 0 01 27031 134 46 1344 13507 134 55 134 54 0 00 0 00 0 06 8 51 21 19 27036 134 24 13433 13498 134 98 134 58 0 01 0 00 002 8 50 21 18 27041 13429 13429 13489 134 74 134 53 0 00 0 00 0 08 8 50 21 17 27046 13415 134 22 134 831 134 63 13444 00 0 00 006 849 21 15 27051 1341 13404 1348 134 29 134 28 0 00 0 00 0 03 8 49 21 15 27056 133 86 13395 13464 134 62 134 29 0 00 0 01 0 00 B 48 21 15 TIP When you choose Insert Row Excel inserts a tow above the curser 2 Select a desired column in the range of interest For example on this spreadsheet the T5 column is selected for the desired range RRRRRRRERRRERRERRAERRERREERRRR AR A fringe 21041 135101 135 09 135 3 135 32 135 07 0 00 21046 134 91 1955 09 155 41 135 36 155 21 0 01 21851 134 91 135 1 135 34 135 54 135 18 0 01 210856 134 76 135 135 37 135 66 135 28 0 00
32. y sample Go on to the next step If Chart 1 2 and 3 data points are scanty e g if the raw data has cycles with fewet than 5 data points go to step 1 choose a smaller Data Increment If this condition persists when the data increment is 1 then the test has not yielded sufficiently reliable data to continue Go to step 5 and exit Retesting is indicated PMIC Page 36 September 6 2007 MI 900 DATA ANALYSIS GUIDE PMI 900 730 Index To be added PMIC Page 37 September 6 2007

USER MANUAL - Carol Margot DeLong

Contents

Download Pdf Manuals

Related Search

Related Contents