Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Betting winnings spreadsheet (a work in progress)

  • 02-08-2011 3:36pm
    #1
    Worztron
    Registered Users, Registered Users 2 Posts: 8,791 ✭✭✭


    Hi.

    I wanted to upload the file in .ods format but it was not accepted :eek:
    Nevermind, .xls will suit both OpenOffice/LibreOffice and non OpenOffice/LibreOffice users.

    I am trying to make betting database. Can someone help me with it? Any formulas or changes are welcomed.

    Thanks.

    Mitch Hedberg: "Rice is great if you're really hungry and want to eat two thousand of something."



Comments

  • #2
    Dailynaps
    Closed Accounts Posts: 184 ✭✭Dailynaps


    This is what I use, nice and simple.


  • #3
    Worztron
    Registered Users, Registered Users 2 Posts: 8,791 ✭✭✭Worztron


    Dailynaps wrote: »
    This is what I use, nice and simple.

    Excellent spreadsheet.

    How about putting in a loss section?

    How can I put in odds like 5/4 in odds box and for it to automatically change to 1.25.

    In E9; I added =C9*D9+C9

    Mitch Hedberg: "Rice is great if you're really hungry and want to eat two thousand of something."



  • #4
    TheYid
    Closed Accounts Posts: 29 ✭TheYid


    Heres your spreadsheet with a bit I've added in to help make it easier to calculate your winnings. I've added dailynaps summary information at the top, I hope you don't mind. After putting in the wager and odds, all you do is put in W or L in column D and excel calculates your profit or loss. The odds column have to be in decimal format.


  • #5
    johnmcdnl
    Registered Users, Registered Users 2 Posts: 3,739 ✭✭✭johnmcdnl


    Worztron wrote: »
    Excellent spreadsheet.

    How about putting in a loss section?

    How can I put in odds like 5/4 in odds box and for it to automatically change to 1.25.

    In E9; I added =C9*D9+C9


    if you right click on the cells and go to format... then go to "number" and format as decimal that should change it to decimal notation



    This is a simple enough one I just threw together there now


Advertisement