Spreadsheet Help

[TrueBlue]

Guys I am looking at doing a betting ledger but I am no good with spreadsheets I need to be able to set formulas these are the fields I want....

• Date
• Sport
• Bookmaker
• Odds
• Stake
• Win - Place - Lose
• Return
• Profit/Loss

I need it to be able to work out the return that obviously will include my stake then the profit and loss to work out taking that into account so a lost would be stake only but profit would be return plus stake - Also I need it to work out if I have a horse each way to work out the return etc on that.

So in summary I want to enter my bets and then be able to just enter win place or lose job done!

Willing to pay somebody to help me if it comes down to it!

 

[Pubey]

It's pretty straight forward Scott. Do you use decimal odds? I'm sure that would make things easier. You'll then want to use the LOOKUP function to refer to the Win/Place/Loss column and the Win/EW bet so that it calculates the return correctly.

 

[jimmyshrimp]

I would be intrested in one of these too.

 

[Spartan]

----------Useful tip------------

You won't make a living out of gambling.

 

[TrueBlue]

----------Useful tip------------

You won't make a living out of gambling.

Edited..............

 

[Spartan]

Edited...................

You really do lack something upstairs that you can turn on don't you? Have you ever given it a thought for one minute why swear filters are implemented on many sites?

I try not to get involved with you on here to much as you are clearly a scum bag.

 

[Spartan]

on weekends in brighton, he probably will

You feeling alright? I mean it's been ten minutes already and you haven't looked at my profile or repped me yet. It's creepy and i don't like it.

 

[davewebbsbrain]

You feeling alright? I mean it's been ten minutes already and you haven't looked at my profile or repped me yet. It's creepy and i don't like it.

I've done it for him...we look out for each other here.

 

[Billy Bests boot laces]

I dont understand why you continue to visit our site?. Surely now your club has 'moved on', you should be swapping posts with your championship rivals the Eagles, Skates and Scummers?.

 

[davewebbsbrain]

Edited......................

God knows how u get away with saying that.....in the trolling thread, all I did was mention that on gay sites I expect trolling to be called flirting and it gets deleted.....MODS, sort it out....