AFL - Statistics in a spreadsheet

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

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
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

Winner

Arbejdsgiverfeedback

“Really good to work with”

cjtitley, Australia.

Offentlig Præciserings Opslagstavle

• Konkurrenceafholder
• 7 år siden

• 7 år siden
1. vpsiitk
• 7 år siden

Can you please accept the excel file I sent?

• 7 år siden
• Konkurrenceafholder
• 7 år siden

please submit and I will award a winner

• 7 år siden
1. vpsiitk
• 7 å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

• 7 år siden
• jaylancer43
• 7 å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

• 7 år siden
• Konkurrenceafholder
• 7 år siden

and 28.5% is correct number - sorry for confusion

• 7 år siden
• Konkurrenceafholder
• 7 år siden

Higher Number = 29 Lowest Number =22 .... 29-22 = 7

• 7 år siden
• thistlel59
• 7 å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%

• 7 år siden
• thistlel59
• 7 å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?

• 7 år siden
• keithnyongesa802
• 7 å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.

• 7 år siden
• 7 å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?

• 7 år siden
1. Konkurrenceafholder
• 7 år siden

All games

• 7 år siden

Sådan kommer du i gang med konkurrencer

• Opret din konkurrence Hurtigt og nemt

• Få tonsvis af indlæg Fra hele verden