Hi

I have lab report and I am done from it but I still need to do the result section which biased on excel. so please help! so here is the description and you will do the 4 graphs according to the data that I have in the lab report and they will look like similar to attached pictures

So as usual, all your results are going to have to be computer-generated and that includes any kind of diagram, graph, table, and so on. So the first thing you’re gonna do is create a sketch of the beam. And you’re going to clearly label the location and magnitude of the applied loads. And then you’re going to use statics to calculate and draw the shear and bending moment diagrams. And you have to provide all calculations and label your diagrams. I need to see exactly what you did. So this is just an example of what the shear moment diagrams could look like if you chose to create them in Excel. Okay, then you’re going to plot the graph of strains for the gauges one through six, which were the gauges in-between the load hangers. And you’re going to plot those strains versus their position relative to the neutral axis, in other words C. And we’re going to plot the average strain on the x axis and see on the y-axis. And there’s some questions in the lab procedure document that you’re going to have to answer. Then you’re going to calculate the experimental stresses for all the gauges. And then you’re going to plot the stress versus strain to determine the modulus of elasticity and pay close attention to units. This is somewhat what your graph should look like. Okay, so one source of error is gage sensitivity. The gauges are extremely sensitive and fragile. And so even putting your hand over a gage will affect its reading. And so just to give you an example. So let’s say you’re performing lab in person and someone left their phone on the table during the experiment. So if the phone vibrates while you’re taking measurements, this vibration of the phone that’s not even touching the beam, it’s just on the table. It’s going to affect the strain readings. Gages are also really sensitive to temperature. So as you may have read in the lab procedure, there’s actually an 11th strain gauge, that is placed on an area of the beam that is stress-free. So in this case it’s to the left end of the support . And so since this gauge is an stress-free location, it is only affected by temperature. And this temperature gauge is then used to correct the other ten gages on the beam for the effects of temperature.