Build a spreadsheet to track gambling results, and update each week with results of bets
$8-15 AUD / ชั่วโมง
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
หมายเลขโปรเจค: #18822520
เกี่ยวกับโปรเจกต์
freelancer freelancer 3 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $10/ชั่วโมง
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. เพิ่มเติม