Excel help

[satana]

Hi all, I need to test the below sequence of bets as if I'm using a fixed % of my bank.
Hence I need to add a single cell where I can enter a certain amount and the sheet runs all the bets in column A at odds of column B at a certain % of said a amount. So say I enter 100, the first bet is a 0.05x100 stake, the second one is 0.05x(100-5) and so on and at the same time I need the sheet to be able to add a winning stake (D5 and D14 in this case) to the sequence in recalculating my available balance in such cases.
There are probably other ways to test it I don't know, I'm open to suggestions.
This is the sheets and it's editable if someone can showme how to add those features:

work in progress as you are posting suggestions https://docs.google.com/spreadsheets...it?usp=sharing

How it looked originally:

https://docs.google.com/spreadsheets/d/1lMGYKtx_Si_eFf5_1Y2rCCu0w3wIbhhbwpk_FCuwJe0/edit?usp=sharing

[Waterstpub87]

If I understand what you are asking
In A1, write bet
In B1, Write Stake
In C1, Write result
In D1, write starting bankroll

In D2, write 100
In D3, write =D2-C2

In B2 write =.05* D1

If you drag C1 and D1 down after inputing your bets and win/loss amount, this should calculate what you mean

[Biff41]

I am having a more simple problem. I can't post a schedule from cbs or Espn onto a .odt spreadsheet. I can post to simple text but need to put info into columns. Thanks for any assistance.

[Waterstpub87]

I am having a more simple problem. I can't post a schedule from cbs or Espn onto a .odt spreadsheet. I can post to simple text but need to put info into columns. Thanks for any assistance.

I dont really know about open office. In excel it will normally give you two options, match format or keep format. Keep format would be what you wanted.