Question

I have an excel spreadsheet with 3columns filled as: column 1: time in sec Column 2...

I have an excel spreadsheet with 3columns filled as: column 1: time in sec
Column 2 : load in newtons
Column 3: position in mm
I imported the data to matlab
And need to use matlab to calculate the engineering stress and strain and true stress and strain
How do i use the imported spreadsheet data to calculate those
Pleasssee help
Note: each column has lots of data collection
0 0
Add a comment Improve this question Transcribed image text
Answer #1

data = xlsread('myFile.xls');
time = data(:,1);
load = data(:,2);
position = data(:,3);

Here I have provided the code for importing the data from your spread sheet. apply these variables to your formulas to find out the engineering stress and strain and true stress and strain.

Add a comment
Know the answer?
Add Answer to:
I have an excel spreadsheet with 3columns filled as: column 1: time in sec Column 2...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 3. A set of tensile test data is provided. The first column is the force measurement...

    3. A set of tensile test data is provided. The first column is the force measurement (kN) and the second column is the change in the gage length (Al, mm). The initial diameter and gage length of the specimen was 25 mm and 50 mm, respectively Use MatLab or Excel to do the following (a) In the same figure, plot both the engineering stress (y1) and true stress (y2) versus strain(x-axis). Insert legend at the upper left corner as "Eng....

  • ** MATLAB HELP** I have been given a large data set in excel in a format...

    ** MATLAB HELP** I have been given a large data set in excel in a format that can be imported into matlab which i have done. The data recored is Wind Data. The point at which data is collected has been collated as "Timestamps" and they are in milliseconds. I am being asked to plot windspeed against time/date. But i need to convert the millisecond data into a usable time/date vector. Any code help for this problem would be great....

  • Suggest form 1. Open a new Excel Spreadsheet. 2. Create a bold-faced heading for your spreadsheet...

    Suggest form 1. Open a new Excel Spreadsheet. 2. Create a bold-faced heading for your spreadsheet that contains the following: a. Excel Exercise 2 b. Qantas Accounts receivable c. Today's date Hint: Todays date function in Excel is =TODAY() 3. Two rows down from your heading, create a row containing the following column headings: a. Customer ID b. Customer name c. Beginning balance d. Sales e. Collections f. Ending balance 4. Enter the data from the scenario into the spreadsheet....

  • need help with #1 a-c Post-laboratory Assignment (page 1 of 5) Excel Spreadsheet: Part A Use...

    need help with #1 a-c Post-laboratory Assignment (page 1 of 5) Excel Spreadsheet: Part A Use Excel to generate a spreadsheet with the following information. Column A Enter the measured masses of sodium carbonate from data page 1 B Using stoichiometry, calculate the theoretical number of moles of CO, that can be produced from each reactant entry. C Using the ideal gas law, measured volume, and temperature, calculate the theoretical pressure of CO2(g) that can be produced from the theoretical...

  • 1. State the difference between I and polycrystalline materials. Deformability of BCC and FCC met...

    1. State the difference between I and polycrystalline materials. Deformability of BCC and FCC metals. Strength and UTS of metals. 2. Determine the slip systems in BCC and FCC materials. Show the calculations that support your determinations. 3. Find the indices that represent the planes in the following cubic unit cell and show the X-Ray diffract-ability of the these planes in FCC and BCC structures: 4. A tensile specimen with a 12 mm initial diameter and 50 mm gauge length...

  • I need help with the following by 11:30pm if possible- thank you!! Spreadsheet, Using Excel: On...

    I need help with the following by 11:30pm if possible- thank you!! Spreadsheet, Using Excel: On a nursing unit there are several employees. Use a spreadsheet to enter the data below. Type of Employee Number Full Time Radiology Technician 24 Part Time Radiology Technician 22 Full Time Sonographer 20 Part Time Sonographer 16 Full Time MRI Technician 20 Part Time MRI Technician 12 Social Worker/Community Health 6 Laboratory/Phlebotomist 3 Registered Nurse 2 Pharmacist 1 Determine the total number of employees...

  • I need some VBA(excel) help. This is what I was given: 'Review the attached data on...

    I need some VBA(excel) help. This is what I was given: 'Review the attached data on the 'Data worksheet'. The data represents the Sales Tax information for the 50-city States in US. 'Create two functions that computes the following for each state: 'StateTax: ListedPrice * State Tax Rate 'Local Tax Rate: ListedPrice * Local Tax rate 'Determine Sales Amount as: ListedPrice + StateTax + LocalTax 'TotalTax as StateTax + LocalTax 'DiscountOpportunity as: MINIMUM(ListPrice * 2%, SalesTax * 1.5%) These are...

  • Please read the questions very well and plot using excel. Don’t waste my question if you’re...

    Please read the questions very well and plot using excel. Don’t waste my question if you’re not gonna do what I asked for. Thank you Problem 1 A tensile test specimen having a diameter of 0.505 in. and a gage length of 2 in. was tested to fracture. Load and deformation data obtained during the test were as follows. Plot the conventional stress-strain curve for the steel and determine modulus of elasticity, the proportional limit, ultimate stress, yield stress at...

  • Hello guys, i really need your help me solve problem with my assignment excel spreadsheet. how...

    Hello guys, i really need your help me solve problem with my assignment excel spreadsheet. how i put into value in column right (total : subtotal: HST: Amount Due: ) ? how can i solve problem like e.g =B2*B3 or =C4+ E4 or ISNUMBER? I am new to excel spreadsheet, i will learn from you, thank you so much Problem 2: Invoice Figure 3. You may use the Item, Quantity and List_Price data as provided. • Discount Rate, Discount Threshold...

  • i only need help with Q3 CEE 216 Civil Engineering Materials Steel 1. A 32-mm rebar...

    i only need help with Q3 CEE 216 Civil Engineering Materials Steel 1. A 32-mm rebar with a gauge length of 200 mm was subjected to tension to fracture according to ASTM E-8 method. The load and deformation data collected are shown in Table 1. Create a spreadsheet to complete the following. Table 1. Load and displacement data for a 32-mm rebar sample subjected to an increasing tensile load a. Create a plot of stress-strain. Label the axes and show...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT