AFL - Statistics in a spreadsheet

Status: Closed
Prize: $20
Entries Received: 5
Winner: vpsiitk

Winner

Contest Brief

I would like someone to find the following regarding AFL (Australian Football League) complied in a spreadsheet

A) Over the last 5 years
B) Every single game
C) Compare each Teams "Scoring Shots"
D) Subtract the higher number of scoring shots from the lower number
E) Then multiply by 6 = x

Then
F) Find the Winning Margin between the two teams = y
G) As a percentage y/x multipled by 100

For example

Adelaide v Hawthorn Played on Friday 11 July 2014
Adelaide Scoring Shots = 22
Hawthorn Scoring Shots = 29
29-22= 7
7 multiplied by 6 = 42 (x)

Winning Margin
Hawthorn 104 v Adelaide 92 = 104-92 = 12 (y)

x = 42
y = 12

42/12 * 100 = 28.5%

Can you please sort this spreadsheet by each game over the last 5 years in the AFL

Recommended Skills

Winner

Post a Contest Like This

Employer Feedback

“Really good to work with”

cjtitley, Australia.

Public Clarification Board

Contest Holder
- 11 years ago
please take screenshot
- 11 years ago
1. vpsiitk
  - 11 years ago
  Can you please accept the excel file I sent?
  - 11 years ago
Contest Holder
- 11 years ago
please submit and I will award a winner
- 11 years ago
1. vpsiitk
  - 11 years ago
  I have submitted my entry again after the change in X formula as you said. for now I have uploaded on 2013 data but I have data from 2009 to 2013, 5 years
  - 11 years ago
jaylancer43
- 11 years ago
hello - we cannot upload excel file but only image file. you will need to award first and then we can do it. Thanks
- 11 years ago
Contest Holder
- 11 years ago
and 28.5% is correct number - sorry for confusion
- 11 years ago
Contest Holder
- 11 years ago
Higher Number = 29 Lowest Number =22 .... 29-22 = 7
- 11 years ago
thistlel59
- 11 years ago
Also, what is the percentage supposed to be? You say 42/12 * 100 = 28.5% but it's not, it's 350%. Whereas 12/42*100 = 28.5%
- 11 years ago
thistlel59
- 11 years ago
Your instruction D says to subtract the higher number of scoring shots from the lower number, but the example shows the opposite (i.e. 29 - 22 is subtracting the lower from the higher). Which is correct?
- 11 years ago
keithnyongesa802
- 11 years ago
I have a certificate of the computer packages and I have accountant for two years now in a supermarket. I promise to complete the job in accordance to the time given by my employer.

Thank you.
- 11 years ago
olteanutoader
- 11 years ago
You want the statistics for all teams ,over the last 5 years, or just only a certain match,over the last 5 years?
- 11 years ago
1. Contest Holder
  - 11 years ago
  All games
  - 11 years ago