Anyone REALLY good with Excel?

I was reading Pip Daddy's Piponomics thread the other day and became inspired to try to make an excel spreadsheet forecasting FF rate changes using futures prices....see his thread here....

http://www.forexfactory.com/forexfor...ead.php?t=3742

How would I tell excel to figure out....

1.25% * (6/31) + [1.00%p + 1.25%(1 - p)] * (25/31) = 1.14%

...preferably w/o using the stupid solver.

Thanks!

p = (((1.14%-1.25%*(6/31))/(25/31))-1.25%)/0.25

Simon

I'm at another standstill in my little project. I have upload for all to see, comment, and tweak. If anyone is interested in helping me figure this out (and I'll share with all once it's done!) I would be really grateful.

Enclosed is a .zip file (I can't upload .xls files here) with my attempt inside....feel free to upload revisions here.

There's a lot to think about and I can't seem to get a grip on it. I would think you'd need 2 different formulas depending on a rate increase or decrease....

Can anyone tell me where i can find a simple account tracker that displays the account progress as a graph? Thanks in advance.