Dozens tracker in excel

[kingsroulette]

Hi,
     Can anybody provide an excel tracker that can track three kinds of dozen bets: latest, prior to latest and farthest dozen?I mean a win/loss tracker of these bets, when we enter numbers of european roulette. It should not be very tough thing to do for anyone skilled in excel formula.
Thanks.

[ddarko]

Isn't that something that somebody with a holy grail should be able to do themselves Albalaha

Erm Kingsroulette.... 

[Colbster]

Here you go - let me know if you need any changes made.

[kingsroulette]

Thanks Colbster,
       It has a small error. If zero comes, instead of showing the sequence as earlier,it shows dozen 1 as the latest. Please check.

[Colbster]

Unless you want 0 tracked, just omit entering 0. If you want zero tracked, how do you want it? As it's own dozen?

[kingsroulette]

can we show 0 as 1st dozen? Can we show it as red or black? 0 is zero, a loss for all outside bets. Anyways, I have corrected it with just adding a small formula. Thanks for your support and efforts.