Build a spreadsheet to track gambling results, and update each week with results of bets

Hi, 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: Input - 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. Outputs: - 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