Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculus spreadsheet
Hey everyone,
I have a math project I am doing. This is what I have to do: There is a mass attached to a spring. The mass of the block is M and the spring constant for the spring is k. F(t) represents a force that is applied at different frequencies upward on the mass. The equations that describe the behavior of the system a (1) Vertical position y of mass: dy/dt = v: where v is the velocity of the mass in vertical direction. (2) Velocity of the mass: dv/dt= (f(t)/M) - (k/M)*y. Let us assume that the external force is: f(t) = 10sin(wt), where w is the frequency of the applied force. Set up a spreadsheet in excel that will solve equations (1) and (2) for y(t) using first order Euler integration. Assume M=2kg, k= 32 kg/s^2, and use 40,000 time steps with each step being 0.0025(M/k)^1/2 seconds. Assume y(0) and v(0) are zero. Make plots of y(t) versus t for w= 2, 3, 3.5, 4, 4.5, and 5 rad/sec. I understand this project, but have no idea how to do any of this in excel. I tried looking up videos, but none of them really helped me out. Do I have to use VB/ macros? I'm guessing I have to write these equations in, identify the variables, and have it do the rest. If anyone could point me in the right direction, that would be appreciated. I'm not asking any of you to solve this, just asking for some help doing this in Excel. Thank you and Happy Thanksgiving! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculus spreadsheet
1) http://www.esm.psu.edu/courses/emch1...uler-tutorial/
2) Google with: Excel Euler's method 3) Send me private email and I will send you a PDF of the relevant chapter from my book 4) Buy my book <grin best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "Blair" wrote in message ... Hey everyone, I have a math project I am doing. This is what I have to do: There is a mass attached to a spring. The mass of the block is M and the spring constant for the spring is k. F(t) represents a force that is applied at different frequencies upward on the mass. The equations that describe the behavior of the system a (1) Vertical position y of mass: dy/dt = v: where v is the velocity of the mass in vertical direction. (2) Velocity of the mass: dv/dt= (f(t)/M) - (k/M)*y. Let us assume that the external force is: f(t) = 10sin(wt), where w is the frequency of the applied force. Set up a spreadsheet in excel that will solve equations (1) and (2) for y(t) using first order Euler integration. Assume M=2kg, k= 32 kg/s^2, and use 40,000 time steps with each step being 0.0025(M/k)^1/2 seconds. Assume y(0) and v(0) are zero. Make plots of y(t) versus t for w= 2, 3, 3.5, 4, 4.5, and 5 rad/sec. I understand this project, but have no idea how to do any of this in excel. I tried looking up videos, but none of them really helped me out. Do I have to use VB/ macros? I'm guessing I have to write these equations in, identify the variables, and have it do the rest. If anyone could point me in the right direction, that would be appreciated. I'm not asking any of you to solve this, just asking for some help doing this in Excel. Thank you and Happy Thanksgiving! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculus in Excel 2000 | Excel Discussion (Misc queries) | |||
calculus | Excel Discussion (Misc queries) | |||
How to do integral calculus in Excel spreadsheet? | Excel Worksheet Functions | |||
Basic Propositional Calculus - Sources for Beginners | Excel Discussion (Misc queries) | |||
You should design a way of doing algebra calculus on a computer | Excel Worksheet Functions |