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

ปิด โพสต์แล้ว 5 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
ปิด

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

Data Analytics วิทยาศาสตร์ข้อมูล การเขียนโปรแกรมฐานข้อมูล Excel

หมายเลขโปรเจค: #18822520

เกี่ยวกับโปรเจกต์

3 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

freelancer freelancer 3 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $10/ชั่วโมง

schoudhary1553

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. เพิ่มเติม

$15 AUD / ชั่วโมง
(336 รีวิว)
8.0