punter club with data and graphs

Hi,

horse racing [login to view URL] for detaied sheets and graphs.

hoping to have one to show money in and money out. it cost 20 per join so if one person pays 50 they be in the green by 30 and another doesnt pay be in the red 20.

also some nice graphs from the data

Each week 1 to 3 people take turns betting $50 on multiple bets.

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 sport type ($ 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 messageE

Excel Entrada de datos Procesamiento de datos Diseño gráfico Google Analytics

Nº del proyecto: #29976141

Sobre el proyecto