decay constancy worksheet

[Logistic]

Does anybody know how to create a worksheet using the excel program with the decay constancy formula of A=A_o

e

^{-(0.693t/T_1/2) ?}

[timo]

The answer to your question is "yes", but that is probably not what you really wanted to know. Perhaps you should be a bit more detailed about what you intend to do.

[Logistic]

The answer to your question is "yes", but that is probably not what you really wanted to know. Perhaps you should be a bit more detailed about what you intend to do.

 

I wasn't sure if this is feasible at excel bec. I asked one computer expert and he said that it doesn't work and that I will need to buy a specific program that will calculate automatically any decay constancy for any isotopes. But since you do you know, perhaps you can guide me on what formula to use on excel and hopefully figure out the rest. I am not so much into computer worksheet. As a matter of fact, I just started excel program last few days ago but couldn't spend time much on this because of work and family issues. So if you or anybody can help, I'll appreciate it very much. Thanks.

[DrRocket]

Does anybody know how to create a worksheet using the excel program with the decay constancy formula of A=A_o

e

^{-(0.693t/T_1/2) ?}

 

Given your relation

 

[math] A=A_0 e^{ \frac {-0.693t}{T_{1/2}}}[/math]

 

You will need to specify a value for [math]T_{1/2}[/math] and then you can compile a list for [math]A/A_o[/math] for specific values of [math]t[/math] using Excel or just a calculator.

 

What is it that you are ultimately trying to do ? This seems like an odd problem for personal amusement or a commercial application. Is this homework or some sort of class assignment ?

[timo]

I am pretty sure you do not need to buy a specialized program for what you want to do. Even if Excel won't do, gnuplot should suffice in any case (and is free). My main question remains: What do you want to do? To give three options: 1) Calculate A(t) for a given A0 and T1/2? 2) Calculate T1/2 from a given A(t)? 3) Something else?

For case 1) try the following off-my-head guide: Enter the times t into the first column. Click on the top box in the 2nd column. Click on the "=" or "f(x)=" button in the symbol bar. Enter the formula where "t" is replaced with either "A1" or "$A$1" (you'll have to try which it is). The correct A(t) for the time in A1 should appear in B1, thereafter. Click the lower-right corner of the field B1, and drag down. This should copy the formula to all other fields in column B.