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

Arbejdsgiverfeedback

“Really good to work with”

Profilbillede cjtitley, Australia.

Bedste indlæg fra denne konkurrence

Se flere indlæg

Offentlig Præciserings Opslagstavle

  • cjtitley
    Konkurrenceafholder
    • 7 år siden

    please take screenshot

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

      Can you please accept the excel file I sent?

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

    please submit and I will award a winner

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

    and 28.5% is correct number - sorry for confusion

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

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

    • 7 år siden
  • thistlel59
    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
    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
    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
  • olteanutoader
    olteanutoader
    • 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. cjtitley
      Konkurrenceafholder
      • 7 år siden

      All games

      • 7 år siden

Vis flere kommentarer

Sådan kommer du i gang med konkurrencer

  • Opret din konkurrence

    Opret din konkurrence Hurtigt og nemt

  • Få tonsvis af indlæg

    Få tonsvis af indlæg Fra hele verden

  • Tildel det bedste indlæg

    Tildel det bedste indlæg Download filerne - Nemt!

Opret en Konkurrence Nu eller slut dig til os i dag!