Modelling a radionuclide generator in Excel

We've been teaching our first year (second year now) residents about nuclear medicine physics, and one of the topics we've covered is producing radionuclides for medical use. So I'm trying to whip up a spreadsheet that will model the activity of a typical Mo-Tc radionuclide generator to show off transient equilibrium and what happens when the generator is eluted.

Modelling the Mo/Tc activity in the generator is easy. What I'm finding a little more difficult is including the effects of generator elution where some of the Tc activity is removed from the generator. I'm thinking if I can reformulate the transient equilibrium equation as a recursive equation that looks something like A(t+dt) = f(A(t)) then I can get it to work. Spreadsheets are good at dealing with recursive equations. Should be simple.

So let's start with the Bateman equation (need to learn some MathML). For a 2 radionuclide (parent/daughter) setup, it looks like

Ad(t) = Ap(0)(λd/(λdp))(exp(-λpt)-exp(-λdt)) + Ad(0)exp(-λdt)

Now, it's a fairly simple exercise to show that when transient equilibrium is established, the recursive equation has the form

Ad(t+1) = Ad(t)exp(-λp)

But, when the generator is eluted, transient equilibrium no longer exists, and we need to go back to the Bateman equation to determine the daughter activity.

So, supposing that at time t=0, we have no initial daughter activity. Our equation looks like

Ad(0) = Ap(0)(λd/(λdp))

And at time t=1, we have

Ad(1) = Ap(0)(λd/(λdp))(exp(-λp)-exp(-λd))

At time t=2,

Ad(1) = Ap(0)(λd/(λdp))(exp(-2λp)-exp(-2λd))

Already we can see that the term containing the difference of exponentials

is going to cause a lot of grief. A recursive Bateman equation may not be possible. I may have to come up with another way to do my spreadsheet.