NationStates

Ianoia wrote:How do people go about teams improving/declining season to season?

I use a coefficient system based on the one used by UICA (or the RL UEFA system).
I have modifiers for each competition, and calculate ranking points for each season based on results in each competition.

I then edit these values manually when I RP something that might alter a team's performance (e.g. new manager, new ownership, sold their top striker, long-serving captain retired, signed new superstar etc etc) or if it looks like one or two teams are overpowered.

Is it on excel? If so could you please share it.

Legalese wrote:

Britonisea wrote:
I wish there was.

I've never tried it, but obstensibly any excel scorinator would work, either through an app that allows you to use excel spreadsheets, or via Google Drive. It's not xkoranate, but it'll get the job done.

Just by putting the formulae in the sheets, or how would one go about doing that?

New North Aqmuland wrote:

Legalese wrote:
I've never tried it, but obstensibly any excel scorinator would work, either through an app that allows you to use excel spreadsheets, or via Google Drive. It's not xkoranate, but it'll get the job done.

Just by putting the formulae in the sheets, or how would one go about doing that?

You can upload an Excel spreadsheet to Google Drive and Google will convert it to the Google Docs format.

Saintland wrote:

New North Aqmuland wrote:Just by putting the formulae in the sheets, or how would one go about doing that?

You can upload an Excel spreadsheet to Google Drive and Google will convert it to the Google Docs format.

And xkoranate comes in an excel spreadsheet format?

New North Aqmuland wrote:

Saintland wrote:
You can upload an Excel spreadsheet to Google Drive and Google will convert it to the Google Docs format.

And xkoranate comes in an excel spreadsheet format?

No

Gregoryisgodistan wrote:

New North Aqmuland wrote:And xkoranate comes in an excel spreadsheet format?

No

Is there one that does?

Any one fill like scorinating a hole tournament for my region, Don't be scared our region is tiny.

United States Of Devonta wrote:Any one fill like scorinating a hole tournament for my region, Don't be scared our region is tiny.

It depends. Tell me more!

Can I please have like a tutor help me set up a league using nsfs? I really don't know what 'tf I'm doing
.

The baseball NSFS scorinator that allows inning scores to be shown, is the home team (and by that, the team that gets the 'home advantage bonus') the top or bottom team in each individual result? The same question for the American Football scorinator, too.

Koana Islands wrote:The baseball NSFS scorinator that allows inning scores to be shown, is the home team (and by that, the team that gets the 'home advantage bonus') the top or bottom team in each individual result? The same question for the American Football scorinator, too.

There is no home advantage in the NSFS3 formula for baseball or American football. In baseball, the home team should be on the bottom so that they bat second; in American football, the order is immaterial.

Commerce Heights wrote:

Koana Islands wrote:The baseball NSFS scorinator that allows inning scores to be shown, is the home team (and by that, the team that gets the 'home advantage bonus') the top or bottom team in each individual result? The same question for the American Football scorinator, too.

There is no home advantage in the NSFS3 formula for baseball or American football. In baseball, the home team should be on the bottom so that they bat second; in American football, the order is immaterial.

Where scorinators actually have a working home advantage, however, the home team is generally listed first and that is, generally speaking, the NS Sports convention.

Hi. I am trying to make an excel based football scorinator and I found some advise from another thread a while ago.

Commerce Heights wrote:

Arkolon wrote:How would you calculate the threshold?

With a formula based on their ranks and style modifier.

For example, SQIS uses 0.1 ± 0.07 × (1 − Lower Rank / Higher Rank) × (1 + Style Modifier / 12.5) × Home Advantage. The ± is positive for the team with the higher rank and negative for the team with lower rank. There are several other ways to do it; e.g., some formulas are based on the difference in rank, rather than the ratio.

Commerce Heights wrote:The usual technique is to calculate a threshold for each team to score, based on their ranks and style modifiers, and then to generate a series of random numbers for each team called “attacks”, each one scoring a goal if it is less than the threshold.

Can someone please explain to me how this threshold is supposed to work. By the way, I am familiar with terms like, rank and style modifier. How can this be incorporated into an excel format? I'm just a bit confused.

Microbe42 wrote:Can someone please explain to me how this threshold is supposed to work. By the way, I am familiar with terms like, rank and style modifier. How can this be incorporated into an excel format? I'm just a bit confused.

Make a row of cells for each team, with one column for each attack (e.g., SQIS gives each team 12 attacks), with a formula like =IF(RAND()<threshold,1,0). Then the sum of each row is your final score.

Commerce Heights wrote:

Microbe42 wrote:Can someone please explain to me how this threshold is supposed to work. By the way, I am familiar with terms like, rank and style modifier. How can this be incorporated into an excel format? I'm just a bit confused.

Make a row of cells for each team, with one column for each attack (e.g., SQIS gives each team 12 attacks), with a formula like =IF(RAND()<threshold,1,0). Then the sum of each row is your final score.

Wow. Thanks a lot!

Another question. For this formula,
0.1 ± 0.07 × (1 − Lower Rank / Higher Rank) × (1 + Style Modifier / 12.5) × Home Advantage.

By "Style modifier" are the style modifiers from the two teams added up?

Microbe42 wrote:Another question. For this formula,
0.1 ± 0.07 × (1 − Lower Rank / Higher Rank) × (1 + Style Modifier / 12.5) × Home Advantage.

By "Style modifier" are the style modifiers from the two teams added up?

Indeed.

Commerce Heights wrote:

Microbe42 wrote:Another question. For this formula,
0.1 ± 0.07 × (1 − Lower Rank / Higher Rank) × (1 + Style Modifier / 12.5) × Home Advantage.

By "Style modifier" are the style modifiers from the two teams added up?

Indeed.

Thank you.

oops

New Wolfopolis wrote:

Semarland wrote:Is there any scorinators that run on ChromeOS?

Not unless you use some tricks to put Ubuntu on that Chromebook of yours.

I found this very disappointing... But I do have Ubuntu so I'll give it a shot. Any recommendations for a football/soccer scorinator?

The Candy Lane wrote:

New Wolfopolis wrote:Not unless you use some tricks to put Ubuntu on that Chromebook of yours.

I found this very disappointing... But I do have Ubuntu so I'll give it a shot. Any recommendations for a football/soccer scorinator?

Xkoronate is a scorinator which is widely used.

Are there any scorinators other than NSFS and xkorinate?

Republic of Guadalajara wrote:Are there any scorinators other than NSFS and xkorinate?

I have always been trying to find a score simulator. I wish I could a link to those.

In the 'auto racing' event in xkoranate it has a "Starting Grid" checkbox. If that is selected does it factor in how you list the drivers in the groups? If that is the case, is it top to bottom 1st to last or the other way around? Many thanks.