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 fixed liability . i would also need 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 "fixed liability"
Column P : Profit/loss
Column Q : Total profit/loss
Plus 6 more columns for % recovery & 1-4 laying staking.
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) .
I will explain how different staking plans work .
Need this done as soon as possible .
I need this done in "OpenOffice" spreadsheet,not microsoft!
I definitely can finish this in less than a day and delivery to you on the same day. Please let me know the details of the calculations and I'll get it to you in 1 day.
You need to provide the formulas for the calculations
How Profit / Loss & Total Profit & Loss are calculated for 6 different stakes including %level and 1-4 laying