Writing Lab Report: Conservation of Energy

profilehamoor_5e00
data.xlsx

Sheet1

Time (s) P (m) P0 Z (m) h (m) v (m/s) PE (J) KE (J) E (J)
1.32 0.908 0.91 0.002 0.0019696269 0.0190803671 0.0190803671
1.36 0.878 0.032 0.031514031 -0.75 0.3052858729 0.278015625 0.5833014979
1.4 0.843 0.067 0.0659825025 -0.875 0.6391922963 0.3784101563 1.0176024525
1.44 0.811 0.099 0.0974965335 -0.8 0.9444781691 0.31632 1.2607981691
1.48 0.78 0.13 0.1280257511 -0.775 1.2402238585 0.2968589062 1.5370827647
1.52 0.753 0.157 0.1546157148 -0.675 1.4978088137 0.2251926563 1.72300147
1.56 0.729 0.181 0.178251238 -0.6 1.7267732183 0.17793 1.9047032183
1.6 0.708 0.202 0.1989323209 -0.525 1.9271170724 0.1362276562 2.0633447287
1.64 0.689 0.221 0.2176437768 -0.475 2.1083805594 0.1115151563 2.2198957157
1.68 0.673 0.237 0.2334007924 -0.4 2.2610234958 0.07908 2.3401034958
1.72 0.66 0.25 0.2462033675 -0.325 2.3850458817 0.0522051563 2.4372510379
1.76 0.65 0.26 0.2560515022 -0.25 2.480447717 0.030890625 2.511338342
1.8 0.643 0.267 0.2629451965 -0.175 2.5472290016 0.0151364062 2.5623654079
1.84 0.639 0.271 0.2668844503 -0.1 2.5853897358 0.0049425 2.5903322358
1.88 0.637 0.273 0.2688540773 -0.05 2.6044701028 0.001235625 2.6057057278
1.92 0.639 0.271 0.2668844503 0.05 2.5853897358 0.001235625 2.5866253608
1.96 0.643 0.267 0.2629451965 0.1 2.5472290016 0.0049425 2.5521715016
2 0.65 0.26 0.2560515022 0.175 2.480447717 0.0151364062 2.4955841232
2.04 0.659 0.251 0.2471881809 0.225 2.3945860652 0.0250214062 2.4196074715
2.08 0.671 0.239 0.2353704193 0.3 2.2801038629 0.0444825 2.3245863629
2.12 0.686 0.224 0.2205982173 0.375 2.13700111 0.0695039062 2.2065050162
2.16 0.704 0.206 0.2028715748 0.45 1.9652778065 0.100085625 2.0653634315
2.2 0.724 0.186 0.1831753054 0.5 1.774474136 0.1235625 1.898036636
2.24 0.747 0.163 0.1605245956 0.575 1.5550499149 0.1634114063 1.7184613211
2.28 0.773 0.137 0.1349194454 0.65 1.3070051432 0.208820625 1.5158257682
2.32 0.802 0.108 0.1063598547 0.725 1.0303398209 0.2597901563 1.2901299771
2.36 0.833 0.077 0.0758306372 0.775 0.7345941316 0.2968589062 1.0314530378
2.4 0.864 0.046 0.0453014196 0.775 0.4388484422 0.2968589062 0.7357073485
2.44 0.894 0.016 0.0157570155 0.75 0.1526429364 0.278015625 0.4306585614
PE (J) 1.32 1.36 1.4 1.44 1.48 1.52 1.56 1.6 1.64 1.68 1.72 1.76 1.8 1.84 1.88 1.92 1.96 2 2.04 2.08 2.12 2.16 2.2000000000000002 2.2400000000000002 2.27999999999999 98 2.3199999999999998 2.36 2.4 2.44 1.9080367053523277E-2 0.30528587285637243 0.63919229629302976 0.94447816914940097 1.2402238584790117 1.4978088137015759 1.7267732183438553 1.9271170724058495 2.108380559414321 2.2610234958425059 2.3850458816904072 2.4804477169580235 2.5472290016453552 2.5853897357524018 2.6044701028059247 2.5853897357524018 2.5472290016453552 2.4804477169580235 2.3945860652171689 2.2801038628960293 2.1370011099946047 1.9652778065128962 1.7744741359776635 1.5550499148621457 1.3070051431663432 1.0303398208902557 0.73459413156064612 0.43884844223103531 0.15264293642818622 E (J) 1.32 1.36 1.4 1.44 1.48 1.52 1.56 1.6 1.64 1.68 1.72 1.76 1.8 1.84 1.88 1.92 1.96 2 2.04 2.08 2.12 2.16 2.2000000000000002 2.2400000000000002 2.2799999999999998 2.3199999999999998 2.36 2.4 2.44 1.9080367053523277E-2 0.58330149785637242 1.0176024525430341 1.2607981691493988 1.5370827647290117 1.7230014699515759 1.9047032183438553 2.0633447286558497 2.2198957156643222 2.3401034958425049 2.4372510379404071 2.5113383419580235 2.5623654078953551 2.5903322357524017 2.6057057278059248 2.5866253607524019 2.552171501645355 2.4955841232080234 2.4196074714671689 2.3245863628960293 2.2065050162446047 2.0653634315128948 1.8980366359776635 1.7184613211121458 1.5158257681663478 1.2901299771402557 1.0314530378106439 0.73570734848103536 0.4306585614281862 KE (J) 1.32 1.36 1.4 1.44 1.48 1.52 1.56 1.6 1.64 1.68 1.72 1.76 1.8 1.84 1.88 1.92 1.96 2 2.04 2.08 2.12 2.16 2.2000000000000002 2.2400000000000002 2.27999999999999 98 2.3199999999999998 2.36 2.4 2.44 0.27801562499999999 0.37841015625000424 0.31631999999999788 0.29685890625000005 0.22519265625000004 0.17793 0.13622765625000002 0.11151515625000125 7.9079999999998915E-2 5.2205156250000009E-2 3.0890625000000001E-2 1.5136406249999998E-2 4.9425000000000016E-3 1.2356250000000141E-3 1.2356250000000004E-3 4.9425000000000016E-3 1.5136406249999998E-2 2.5021406250000003E-2 4.4482500000000001E-2 6.9503906249999997E-2 0.10008562499999878 0.12356250000000001 0.16341140624999997 0.20882062500000467 0.25979015625000001 0.29685890624999789 0.29685890625000005 0.27801562499999999

Sheet2

frame time [s] y [m] Vy KE PE E delta y W air Abs (W air) cumulative W air Total E + cumulative W air uncertainty k
1 0 37.6213 103232.8472 103232.8472 186975.019405914 0.019825 31.726
6 0.334 37.0177 -1.8071856287 457.2287855427 101576.5688 102033.797585543 -0.6036 -62.541757255 62.541757255 83742.172205914 185775.969791457
11 0.667 36.1124 -2.7186186186 1034.72420709 99092.4256 100127.14980709 -0.9053 -212.2777198125 212.2777198125 183869.322013004
16 1 34.6035 -4.5312312312 2874.487905924 94952.004 97826.4919059239 -1.5089 -982.897495603 982.897495603 181568.664111838
21 1.334 32.5917 -6.0233532934 5079.309885618 89431.6248 94510.934685618 -2.0118 -2315.6706846451 2315.6706846451 178253.106891532
26 1.667 30.0769 -7.551951952 7984.4769598428 82531.0136 90515.4905598427 -2.5148 -4550.2704264796 4550.2704264796 174257.662765757
31 2 27.2604 -8.457957958 10015.1873946018 74802.5376 84817.7249946018 -2.8165 -6392.2848504951 6392.2848504951 168559.897200516
36 2.334 24.3432 -8.7341317365 10679.908006741 66797.7408 77477.648806741 -2.9172 -7060.2649801419 7060.2649801419 161219.821012655
41 2.667 21.2249 -9.3642642643 12276.5223295367 58241.1256 70517.6479295368 -3.1183 -8675.2207968661 8675.2207968661 154259.820135451
46 3 18.0059 -9.6666666667 13082.2222222222 49408.1896 62490.4118222222 -3.219 -9543.1067726667 9543.1067726667 146232.584028136
51 3.334 15.0888 -8.7338323353 10679.1758166302 41403.6672 52082.8430166302 -2.9171 -7059.5389391134 7059.5389391134 135825.015222544
56 3.667 11.568 -10.572972973 15650.2860482104 31742.592 47392.8780482104 -3.5208 -12486.7932097341 12486.7932097341 131135.050254124
61 4 8.6508 -8.7603603604 10744.1479100722 23737.7952 34481.9431100722 -2.9172 -7102.7326436771 7102.7326436771 118224.115315986
66 4.334 5.5325 -9.3362275449 12203.1202678476 15181.18 27384.3002678476 -3.1183 -8623.3511325584 8623.3511325584 111126.472473762
71 4.667 2.4142 -9.3642642643 12276.5223295367 6624.5648 18901.0871295367 -3.1183 -8675.220796866 8675.220796866 102643.259335451

Vy

Vy 0 0.33400000000000002 0.66700000000000004 1 1.3340000000000001 1.667 2 2.3340000000000001 2.6669999999999998 3 3.3340000000000001 3.6669999999999998 4 4.3339999999999996 4.6669999999999998 -1.8071856287425152 -2.718618618618609 -4.5312312312312439 -6.0233532934131535 -7.5519519519519669 -8.4579579579579516 -8.7341317365269475 -9.3642642642642659 -9.6666666666666643 -8.733832335329339 -10.572972972972986 -8.7603603603603535 -9.3362275449101908 -9.3642642642642571

Time

Velocity

KE 0 0.33400000000000002 0.66700000000000004 1 1.3340000000000001 1.667 2 2.3340000000000001 2.6669999999999998 3 3.3340000000000001 3.6669999999999998 4 4.3339999999999996 4.6669999999999998 457.22878554268721 1034.7242070899654 2874.487905923 9579 5079.3098856179513 7984.4769598427574 10015.187394601795 10679.908006741012 12276.522329536749 13082.222222222215 10679.175816630206 15650.286048210412 10744.147910072217 12203.120267847567 12276.522329536725 PE 0 0.33400000000000002 0.66700000000000004 1 1.3340000000000001 1.667 2 2.3340000000000001 2.6669999999999998 3 3.3340000000000001 3.6669999999999998 4 4.3339999999999996 4.6669999999999998 103232.84719999999 101576.56879999999 99092.42560000 0002 94952.003999999986 89431.624800000005 82531.013599999991 74802.537599999996 66797.7408 58241.125600000007 49408.189599999998 41403.667200000004 31742.592000000001 23737.7952 15181.179999999998 6624.5648000000001 E 0 0.33400000000000002 0.66700000000000004 1 1.3340000000000001 1.667 2 2.3340000000000001 2.6669999999999998 3 3.3340000000000001 3.6669999999999998 4 4.3339999999999996 4.6669999999999998 103232.84719999999 102033.79758554268 100127.14980708 997 97826.491905923947 94510.934685617962 90515.490559842743 84817.724994601798 77477.64880674101 70517.647929536761 62490.411822222217 52082.843016630213 47392.878048210412 34481.943110072214 27384.300267847568 18901.087129536725 Abs (W air) 0 0.33400000000000002 0.66700000000000004 1 1.3340000000000001 1.667 2 2.3340000000000001 2.6669999999999998 3 3.3340000000000001 3.6669999999999998 4 4.3339999999999996 4.6669999999999998 62.541757254977405 212.27771981251027 982.8 9749560296696 2315.670684645117 4550.2704264795966 6392.2848504951444 7060.2649801419002 8675.2207968660568 9543.1067726666661 7059.5389391134095 12486.793209734113 7102.7326436770809 8623.3511325583841 8675.2207968660459 Total E + cumulative W air 0 0.33400000000000002 0.66700000000000004 1 1.3340000000000001 1.667 2 2.3340000000000001 2.6669999999999998 3 3.3340000000000001 3.6669999999999998 4 4.3339999999999996 4.6669999999999998 186975.01940591395 185775.96979145665 183869.32201300393 181568.66411183792 178253.10689153193 174257.66276575672 168559.89720051578 161219.82101265498 154259.82013545075 146232.58402813619 135825.0152225442 131135.05025412439 118224.11531598619 111126.47247376153 102643.2593354507

Sheet3