visual basic excel coding (programming)

profiledbsq88
hw3_problem_2.xlsm
Home>Engineering homework help>Mechanical Engineering homework help>visual basic excel coding (programming)

Sheet1

t U(1) U(2) U(3) m NEWTON h=0.01 h=0.1 h=0.05
0.1 0.0007056267 0.0141125337 0.282250674 3 t uxact ucalc Δu ucalc Δu error(0.1/0.05)
0.2 0.0053975592 0.0797261158 1.0300209678 3 0.5 0.116136173 0.1178431929 0.0017070199 0.1165939338 0.0004577608 0.2681637395
0.3 0.0208976134 0.2302749695 1.9809561071 2 1 0.8357295131 0.809426782 -0.0263027311 0.8293845226 -0.0063449905 0.2412293393
0.4 0.0558817607 0.4694079762 2.8017040254 3 1.5 1.8624779014 1.797856566 -0.0646213353 1.8468301811 -0.0156477203 0.2421448
0.5 0.1178431929 0.7698206674 3.2065497987 3 2 3.4669866114 3.3205577658 -0.1464288456 3.4313529872 -0.0356336242 0.2433511242
0.6 0.2104921538 1.0831585509 3.0602078711 3
0.7 0.3325262832 1.357524038 2.4271018721 3
0.8 0.4782165241 1.5562807798 1.5480329643 2
0.9 0.6395934236 1.6712572089 0.7514956176 2
1 0.809426782 1.7254099587 0.3315593786 3
1.1 0.9838910555 1.7638755124 0.4377516941 3
1.2 1.1639204312 1.8367120011 1.0189780799 3
1.3 1.3547483121 1.979845617 1.8436942391 2
1.4 1.5638155492 2.2014991256 2.5893759328 2
1.5 1.797856566 2.4793212108 2.9670657701 3
1.6 2.0602874724 2.7692969166 2.8324483461 3
1.7 2.3498976273 3.022906181 2.2397369427 3
1.8 2.6613306098 3.2057534695 1.4172088266 2
1.9 2.9871355942 3.3103462188 0.6746461588 2
2 3.3205577658 3.3580972125 0.2803737161 3