I need a spreadsheet to keep a record of my bets .
But i also need it to automaticaly calculate stake/profit/loss using 4 different staking plans .(to test which staking plan would make most profit).
i do have spreadsheets for these staking plans,but they are all separate . i need them all in one page/one spreadsheet,so i dont have to enter same data 4 times .
The staking plans i am using are : level stake,lay 88,maria and ed liability . (would also be usefull to have recovery % staking and lay1-4 staking)
So the spreadsheet should look something like that ;
Column A : Meeting and date Column B : Time and Race type Column C : Selection Column D : Betfair Lay Odds . Column E : Won or Lost Column F : Stake needed for "Level stake " Column G : Profit / loss Column H : Total profit loss Column I : Stake needed for "Lay88" Column J : Profit /loss Column K : Total profit loss Column L :Stake needed for "Maria " Column M :Profit / loss Column N : Total profit/loss Column O : Stake needed for "ed liability" Column P : Profit/loss Column Q : Total profit/loss
So i would manually enter info into columns A-E,and the spreadsheet would calculate different stakes/profit/loss for each staking plan(columns F-Q) .