Simulation using Excel

Excel can be used to solve simulation problems. like gravity flow tank
write the mass balance and equation of motion as:

with the dimensions of tanks and pipe and initial conditions, the variables are flow rate f (or velocity v) and height h, and we have two equations to solve.
steps to solve:
1. with the initial conditions find the derivatives dh/dt and dv/dt
2. calculate the new values of h and v by using the definition of derivative i.e.
v2 = v1 + dt*dv/dt
h2 = h1+dt*dh/dt
3. with new values calculate the derivatives
4. caluclate the new values of the variables
5. repeat till  the values we get converged values.