Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do i calculate this?

in physics we have to calculate a hang time for when people jump using their
average jump and i dont know how too.
He said to do something like this: =SQRT(2*average jump G4/9.8)*2
but everytime i use it, it doesnt work.
please help me
thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,805
Default how do i calculate this?

Enter the (average) Jump height (in meters) in the cell A and paste this
formula in B1 to get the (average) hang time...
=2*SQRT(2*A1/9.8)

since g=9.8 m/s*s

"cheypie1000" wrote:

in physics we have to calculate a hang time for when people jump using their
average jump and i dont know how too.
He said to do something like this: =SQRT(2*average jump G4/9.8)*2
but everytime i use it, it doesnt work.
please help me
thanks

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 857
Default how do i calculate this?

Hi,

In general a falling body starting from rest and accelerating under the
influence of gravity obeys the following formula:

S=1/2gt^2

distance = 1/2 * 9.8m/ss * (time)^2

where ^ means squared.

solving the above for t gives

t = (2*S*9.8)^2 or t = SQRT(2*S*9.8)

Of course I'm not sure how this has relevence to hang time, since I assume
that relates to falling through air, in which case air resistance becomes an
important factor even if no parachute is open. The above solution is for
free fall in a vacumn. For example, a free falling person in the atmosphere
reaches a terminal velocity because of air resistance, while the above
formula assumes no such factor.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"cheypie1000" wrote:

in physics we have to calculate a hang time for when people jump using their
average jump and i dont know how too.
He said to do something like this: =SQRT(2*average jump G4/9.8)*2
but everytime i use it, it doesnt work.
please help me
thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate Rao Ratan Singh Excel Discussion (Misc queries) 3 October 20th 08 07:42 AM
calculate time does not calculate Wanna Learn Excel Discussion (Misc queries) 4 August 19th 08 12:51 AM
only calculate if 100 KJensen Excel Worksheet Functions 5 May 22nd 06 10:45 PM
Calculate Carbob Excel Worksheet Functions 2 March 1st 06 02:27 PM
How can i calculate only once? Marc G Excel Discussion (Misc queries) 3 August 11th 05 07:52 PM


All times are GMT +1. The time now is 01:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"