Jump to content

Exponential time decay - please help.


f8l_0e

Recommended Posts

Full disclosure: I am no mathematician. The furthest I got in high school was Algebra 2.

 

One of my favorite movies is The Manhattan Project. I want to build a prop replica of the device is the movie. I even plan to build the circuitry with discrete logic instead of a microcontroller. In the film, the device malfunctions due to radiation and its timer circuit begins to count down from 999h:99m:99s. The countdown increases exponentially. I would like to know the time to zero starting from 999:99:99 and possibly graph the decay rate over time.

 

In the film, the formula "As y approaches infinity t = (1 + (1 over / n ))to the nth." Some google-fu leads me to info on Euler's number.

 

 

Could someone assist with the formula needed to find the decay rate and the formula needed to calculate time remaining based on input?

 

Thanks,

 

John

Link to comment
Share on other sites

Thank you for replying, Sensei. Forgive my ignorance, but I need some further hand holding. Can I just plug in the start time in seconds into the Current Quantity Of Elements column of the spreadsheet, or does the formula need to be rewritten?

 

 

Link to comment
Share on other sites

In that SpreadSheet you shouldn't play with first column where is time.

At least not until you will understand whole equation.

You change initial quantity (C2) and half-life (B2) fields.

Columns D,E will be filled automatically, and graph updated.

 

For f.e. half-life 10 seconds, and initial quantity 1000, you will see 1000,933,870,812,etc. going down quickly.

Edited by Sensei
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.