Help with formula in soccer

  • Resolved dabal

    (@dabal)


    4 years, 2 months ago

    Hello

    I need help with a formula please, but I speak Spanish, I hope you understand my basic English.
    I have a championship that has a general rule. Each team must add 1890 total minutes at the end of the season, among all players under 21 years of age (born from 01/01/2001 onwards), without exceeding 90 minutes per game.

    example: Player A (45′)+Player B (85′) = 130′, but only 90′ are counted

    Is it possible to create a ranking table according on the minutes counted per team and with the minutes remaining?

    Example,

    Column A: Minutes to complete 1890
    Column B: Added Minutes 130
    Column D: Minutes remaining 1760

    For now I have defined the sum of minutes per player and for each game he plays

    In players performance, I added a column where I assign the minutes played by each player and then in the results table, I made another column where with an equation I add the total minutes of the team in that event.
    I thought about creating another column in the same results box, where if the team exceeds 90′, with an equation adjust it to 90′, but I have not been able to do it

    I hope you could understand me. Excuse the length.
    Thanks in advance`

Viewing 1 replies (of 1 total)
  • Roch

    (@rochesterj)

    4 years, 2 months ago

    Hi there!

    Thanks for reaching out.

    Your English is fine, I can understand it pretty well.

    As for your issue, since this is a team-wide stat, you’ll need to add a new event result field. In it, you’ll manually enter the number of minutes to be summed.

    So that 45 + 85 = 130 sum you did, you’ll need to manually do it, and check if it is over 90, so that you can add just 90.

    From there, you can add this to your league table as a new column.

    Thanks!

Viewing 1 replies (of 1 total)

The topic ‘Help with formula in soccer’ is closed to new replies.