AFL - Statistics in a spreadsheet

Status: Closed
Præmier: $20
Modtagne indlæg: 5
Vinder: vpsiitk

Winner

Konkurrence Instruktioner

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

Anbefalede færdigheder

Winner

Opret en konkurrence som denne

Arbejdsgiverfeedback

“Really good to work with”

cjtitley, Australia.

Offentlig Præciserings Opslagstavle

Konkurrenceafholder
- 8 år siden
please take screenshot
- 8 år siden
1. vpsiitk
  - 8 år siden
  Can you please accept the excel file I sent?
  - 8 år siden
Konkurrenceafholder
- 8 år siden
please submit and I will award a winner
- 8 år siden
1. vpsiitk
  - 8 år siden
  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
  - 8 år siden
jaylancer43
- 8 år siden
hello - we cannot upload excel file but only image file. you will need to award first and then we can do it. Thanks
- 8 år siden
Konkurrenceafholder
- 8 år siden
and 28.5% is correct number - sorry for confusion
- 8 år siden
Konkurrenceafholder
- 8 år siden
Higher Number = 29 Lowest Number =22 .... 29-22 = 7
- 8 år siden
thistlel59
- 8 år siden
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%
- 8 år siden
thistlel59
- 8 år siden
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?
- 8 år siden
keithnyongesa802
- 8 år siden
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.
- 8 år siden
olteanutoader
- 8 år siden
You want the statistics for all teams ,over the last 5 years, or just only a certain match,over the last 5 years?
- 8 år siden
1. Konkurrenceafholder
  - 8 år siden
  All games
  - 8 år siden