LAB #2 EXCEL TEMPLATE FOR THE ANALYSIS OF RESULTS
LAB #2 EXCEL TEMPLATE FOR THE ANALYSIS OF RESULTS
The template consists of 6 worksheets. The first sheet is labeled “SAMPLE”. The next four worksheets are labeled “aluminum”, ‘copper”, “500C heated steel”, and “cold finish steel”. The sixth and last worksheet is labeled “results”.
Input the Instron specimen data, elongation, and force data in the appropriate worksheets (see tabs at bottom left of the worksheet). Specifically, if you copy the three columns of data at the bottom of your Instron files into the first three columns (A-C) of the appropriate worksheet (row 10 and below), drag down the remaining columns (D-K), and enter your specimen dimensions, most everything else will be done for you. Refer to the SAMPLE page as an example of what each of the four worksheets should look like when you are done copying your data. Note: the red numbers represent the data you will enter. Also, your values will not be red.
You should first open your Instron text files into another EXCEL file before copying and pasting the data. Do the following.
1. open EXCEL
2. under File, select Open
3. Find and open your text file select “Text files” or “All Files” in the ‘Files of Type’ window
4. A ‘Text Import Wizard’ window should open
5. Select ‘Delimited’ and hit next
6. Check the ‘comma’ box and hit finish
7. Copy the data in the three columns starting at cell A99 and below, for example A99 to C876
8. Paste the data in cell A10 of the appropriate worksheet in the EXCEL I have provided (i.e. put copper data in the worksheet labeled copper this is for plotting reasons)
9. Type in the appropriate specimen dimensions in cells B3 to B6
10. Repeat steps 1 through 9 for each of your tensile test specimen
When you are finished entering the data, you should have completed stress-strain and force-elongation plots on the ‘results’ worksheet. There is also a table of important values from the tensile test results. You will need to:
1. give the correct units
2. determine the ‘Yield Strength’ and Young’s Modulus’ for each of the specimen
3. input the ‘Hardness’ values with the appropriate measured scale enclose converted values in parenthesis.
I hope this helps save some time.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- blackbaud raiser s edge import guide
- connecting bartender to an excel file for printing
- redcap data migration from ms excel home iths
- requirements for modifying a spreadsheet for ert import
- softmax pro software import and export tools
- importing employee data
- instructions on how to read the acs summary file into excel
- adobe captivate
- lab 2 excel template for the analysis of results
- knowledge base abila
Related searches
- excel template for small business
- excel template for loan payments
- excel template for loan repayment
- excel template for contact management
- excel template for loan payment
- excel template for rental property
- excel template for personal finance
- excel template for amortization schedule
- excel template for tracking stocks
- excel template for password management
- excel template for income statement
- excel template for business expenses