I am part of a gambling club with 10 other members.
Each week 2 to 3 people take turns betting $50 on multiple bets, with multiple legs.
The job involves the three key activities: 1) Build a spreadsheet to track betting results, 2) Weekly update of spreadsheet with betting information, and 3) Weekly notification of who is betting each week. These tasks are detailed below:
1. Build a spreadsheet to track betting results for the group and each member. The spreadsheet will need to be able to calculate the following:
- Bet data, including each leg and odds, bet type for each leg, $amount placed, result for each leg, result for the bet, person who placed the bet, date, calendar week, sport of each leg.
- Returns cumulative to date ($ and %)
- Returns by person ($ and %)
- Indication of the bet with highest odds that has won
- Indication of the bet with the lowest odds that has lost
- Indication of the individual leg with highest odds that has won
- Indication of the individual leg with the lowest odds that has lost
- Summary data table with condition formatting (colours) to show the above information
2) Weekly update of spreadsheet
- Upload spreadsheet to Google Docs and share with group members
- Update spreadsheet with details of each bet (screenshot of each bet to be shared through a Whatsapp group)
- Update spreadsheet with results of each bet (from public new sources) to determine whether each bet and each leg has won or lost
- Supply screenshot of updated summary table to whatsapp group
- Notify group who is scheduled for betting in the following week through whatsapp message
Bu iş için 5 freelancer ortalamada $10/saat teklif veriyor
Hi sir I can manage your [login to view URL] update on excel and send monthly status with result and some probability also I can added through data science. a Can we discuss regarding this project. Thanks