November 3rd, 2013, 07:55 PM  #11  
Senior Member Joined: Jul 2012 From: DFW Area Posts: 642 Thanks: 99 Math Focus: Electrical Engineering Applications  Re: water remaining in tank Quote:
Quote:
1) In my previous post, I said that for each approximation you would need to do an integration. That was a mistake. In my simulation program I was doing an integration over the slot height and checking it against the formula. But if you just use the formula: your procedure can easily be implemented in Excel. You will still need the IF statement, but that is easy to use. Sorry about my confusion (I will edit my previous post, mentioning the error). 2) I did use t_step = 0.0001 in my previous simulation, but that was only to check it against the formula to high accuracy. I ran a simulation with the same parameters as in the first simulation, but with H=1 and using the formula given above. After 100s, these are my results: t_step=0.1, volume = 6.248 t_step=0.01, volume = 6.277 t_step=0.001, volume = 6.28 t_step=0.0001, volume = 6.281 So even a t_step of 0.1s is fairly accurate. I made an Excel workbook with a t_step of 0.1 a got the same result. I'll bet Excel would have no problem with a t_step of 0.01 (or 0.05 or whatever) but I did not try it. So I know your problem can be done in Excel with decent accuracy. Have fun, and feel free to reply if you have any more questions.  
November 3rd, 2013, 11:30 PM  #12 
Member Joined: Sep 2013 Posts: 43 Thanks: 0  Re: water remaining in tank
I have checked some mathematic book with list of integration table for this integral and couldnt recognize any pattern. So in mathematic, there is still equations that not possible to do the integral and need to find it using series? Since is an approximation method, the curve is not smooth compare to the actual formula( if it exist) and i wonder what the result using approximation to get set of value than apply least square method or newtongauss method to smoothen the curve. I couldn't done this now due to lack of knowledge in this method and having difficulty in understand it. 

Tags 
remaining, tank, water 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Water remaining in inner cubic tank bounded by outer tank  chuackl  Calculus  2  December 27th, 2013 05:06 PM 
How much water did each tank contain originally?  Chikis  Elementary Math  2  May 12th, 2013 02:44 PM 
Work done pumping water out of a spherical tank  mymyz4  Calculus  1  May 4th, 2013 11:22 AM 
Work to pump water out of a tank  Decave  Calculus  3  February 15th, 2012 05:50 PM 
A water tank has shape of an inverted circular cone of altit  urduworld  Calculus  2  November 1st, 2009 03:06 AM 