Excel Instructions-
Part 1 - Organization
Within this set of instructions, you will be shown how to set up your spreadsheet with given raw data in an organized manner.
1. Start Microsoft Excel and select blank workbook.
2. Insert Raw Data into Workbook
Data > From Text > rawdata.txt > Import > Finish > OK
3. Rename Sheet by double clicking the sheet name in the bottom right of the spread sheet. Label as 'Raw Data'
Note: Never delete or modify raw data.
4. Separate Runs onto multiple sheets
Right click 'Raw Data' sheet tab > Move or Copy > Create a copy
Rename new sheet Run #1
Repeat this until you have separate sheets labeled
5. Cleaning up sheets
In Run #1, Highlight columns E-P (Runs #2-#4) and Right Click to Delete the data.
Repeat this in the other sheets so that only the Run # for the sheet name is showing.
6. Delete Time and Speed Columns for all runs. We will not need that data for this lab.
7. Final Adjustment to the Sheets
In sheet Run #1, either drag and move data down, or insert rows above Position and Force Columns.
Part 2 - Math Operations
Within these instructions, students are introduced to the math operations and calculating power of Excel. We pick up where we ended in the "organization" instructions. The following table is a filled with commonly used excel operations you will use throughout the semester. These are NOT the only commands that exist, there are THOUSANDS of commands that can be found through the help function or via an internet search.
|
Statistics
|
Trigonometry
|
Graphing
|
General
|
|
=Average()
|
=PI()
|
=SLOPE()
|
=SQRT()
|
|
=Median()
|
=SIN()
|
=MAX()
|
=SUM()
|
|
=STDEV.P()
|
=Radians()
|
=MIN()
|
=ABS()
|
|
=STDEV.S()
|
=Degrees()
|
|
=COUNT()
|
|
|
=COS()
|
|
|
|
|
=TAN()
|
|
|
|
|
|
|
|
Functions-
1. In Column D, next to the Force data, TYPE 'Stress' and 'Strain'
The stress being calculated is an axial stress. The formula for axial stress is Stress=Force/Area
The diameter of the circular cross section = 3.302 mm, find the area.
2. Calculate Stress
Select the cell directly under 'Stress' and TYPE the equation =Force/(diameter^2*PI()*0.25), where "Force" and "diameter" are their respective cells
As seen above in my formula bar, my force cell was C9, and my diameter cell was E4. You will notice also, in the formula bar above, there are $ in front of the E and 4. The $ isolates the cell/variable so that when you copy the cell, the formula is not copied but stays the same. For this equation, the diameter never changes so I put a $ in that cell.
3. Calculate Strain
The strain being calculated can be found from the following equation:
Ε = Δl/l0
For this Lab, l0 is equal to the Gauge Length and ?l refers to the position column.
Select the cell directly under 'Strain' and TYPE the equation = Position/Gauge Length
The gauge length is = 35 mm
4. Copy formulas down to the bottom of data set
Highlight the first box of stress and strain. Double click the small green square in the bottom right corner of the highlighted cells.
5. Repeat steps for the remaining 3 materials.
6. You should find by yourself the mechanical properties of the remaining materials
Part 3- Graphing
In this set of instructions, students are shown how to graph the data set from previous modules.
1. In Sheet Run #1, select INSERT > Scatter Plot
It should give an empty graph, if not, that is ok, you can adjust it later
Right Click the graph, and Select Data. If your graph is empty, then you will just need to ADD data. If Data already appears in the legend entries, REMOVE all to clear.
Click Add and you will get a box that looks like this...
The series name can be a referenced cell, or you can type the name, for this lets Reference a cell...
Click the select range button then Select the Cell that contains the name of the material, '2024-T3 Aluminum'
Click the select range button for Series X Values, These will be our STRAIN values. Highlight all the Strain Data.
Click the select range button fro Series Y Values, These will be our STRESS values.
Highlight all the Stress Data.
Concept Check: EXCEL
Refer to the instructions above on the proper way to organize, analyze, and graph your data.
1. Transfer the Raw Data into EXCEL
2. Organize the data
3. Perform math operations
4. Graph the data
Once you have completed ALL of the steps for ALL of the materials. Upload and submit your .xlsx file into this Assignment.
Attachment:- Assignment.rar