NATION

PASSWORD

Scorinators (OOC Discussion)

A battle ground for the sportsmen and women of nations worldwide. [In character]

Advertisement

Remove ads

User avatar
TURTLESHROOM II
Senator
 
Posts: 4128
Founded: Dec 08, 2014
Right-wing Utopia

Postby TURTLESHROOM II » Sat Apr 15, 2017 6:14 pm

A Scorinator for tractor pulling would be hilariously awesome.

Tractor pulling is determined by weight. Each player's tractor is hitched up to a heavy sled. The object of the game is to see who can pull the most weight the farthest.
  • Each tractor that passes a certain distance moves to the next round.
  • When a tractor fails to go a certain distance, it is dropped from the tournament.
  • In each round, the weight is increased.
  • The last tractor standing wins.

Is there something similar to that in the existing Scorinator consoles?

If not, there's always Pumpkin Chunking:
  • Players are presented pumpkins of equal size.
  • The pumpkins are loaded into custom-made trebuchets designed by each player or team.
  • The pumpkin thrown the farthest is the winner.
  • Multiple rounds can ensue if desired.

For Pumpkin Chunking, we can simply use a javelin calculator and multiply it by ten to simulate extreme distances. If you can calculate the weight of the javelin as well, that'll work too.
Jesus loves you and died for you!
World Factbook
First Constitution
Legation Quarter
"NOOKULAR" STOCKPILE: 701,033 fission and dropping, 7 fusion.
CM wrote:Have I reached peak enlightened centrism yet? I'm getting chills just thinking about taking an actual position.

Proctopeo wrote:anarcho-von habsburgism

Lillorainen wrote:"Tengri's balls, [do] boys really never grow up?!"
Nuroblav wrote:On the contrary! Seize the means of ROBOT ARMS!
News ticker (updated 4/6/2024 AD):

As TS adapts to new normal, large flagellant sects remain -|- TurtleShroom forfeits imperial dignity -|- "Skibidi Toilet" creator awarded highest artistic honor for contributions to wholesome family entertainment (obscene gestures cut out)

User avatar
Commerce Heights
Minister
 
Posts: 2050
Founded: Antiquity
Anarchy

Postby Commerce Heights » Sun Apr 16, 2017 7:39 am

TURTLESHROOM II wrote:A Scorinator for tractor pulling would be hilariously awesome.

Tractor pulling is determined by weight. Each player's tractor is hitched up to a heavy sled. The object of the game is to see who can pull the most weight the farthest.
  • Each tractor that passes a certain distance moves to the next round.
  • When a tractor fails to go a certain distance, it is dropped from the tournament.
  • In each round, the weight is increased.
  • The last tractor standing wins.

Is there something similar to that in the existing Scorinator consoles?

It seems similar enough to high jump and pole vault.

User avatar
Tinhampton
Postmaster-General
 
Posts: 13701
Founded: Oct 05, 2016
Civil Rights Lovefest

Postby Tinhampton » Fri May 05, 2017 6:15 pm

Following on from my previous SGIS sagas, I've sorted out the code. Well, sorted it out enough so I can see it on the Association Football dropdown menu.
Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<sport version="0.3">
    <name>Association football—SGIS formula</name>
    <discipline>Association football</discipline>
    <event>SGIS formula</event>
    <scorinator /> <!-- only one scorinator is needed for this event -->
   
    <paradigm>sgis</paradigm>
    <paradigmOptions>
      <double type="constantA">0.11</double>
      <double type="constantB">0.08</double>
      <double type="homeAdvantage">1.223333333333</double>
      <double type="homeAdvantageGG">0.123333333333</double>
      <int type="attacks">12</int>
      <double type="etAttackCoeff">0.293333333333</double>
      <int type="shootoutLength">5</int>
      <double type="goldenGoalProb">0.4</double>
      <double type="shootoutProb">0.65</double>
      <int type="pointValues">1</int>
      <double type="attackCoeffs">1</double>
      <double type="NSFSStyleCoeffA">2.0000000000000</double>
      <double type="NSFSStyleCoeffB">1.2000000000000</double>
      <double type="NSFSStyleExponent">-0.23705203296846</double>
      <double type="NSFSStyleOffset">0.102435335725325</double>
      <string type="tableHeaderGoalsFor">GF</string>
      <string type="tableHeaderGoalsAgainst">GA</string>
      <string type="tableHeaderGoalDifference">GD</string>
      <list type="tiebreakers">
         <string>extratime</string>
         <string>shootout</string>
      </list>
      <list type="tiebreakerNames">
         <string>AET</string>
         <string>pen.</string>
      </list>
    </paradigmOptions>
   
   <!-- the style modifier distribution is a bit wonky because negative modifiers are less likely to take effect -->
    <dataPoints name="style">
      <dataPoint pos="0">-3</dataPoint>
      <dataPoint pos="0.4">-1</dataPoint>
      <dataPoint pos="0.5">0</dataPoint>
      <dataPoint pos="0.65">0</dataPoint>
      <dataPoint pos="1">3</dataPoint>
    </dataPoints>
</sport>

However, this code asks me either for a mass-start or a multiple run league, and ends up scorinating every match as a negative-one-all draw (yes, you read that right, negative goals). Something is wrong with the data - but what is?
The Self-Administrative City of TINHAMPTON (pop. 329,537): Saffron Howard, Mayor (UCP); Alexander Smith, WA Delegate-Ambassador

Authorships & co-authorships: SC#250, SC#251, Issue #1115, SC#267, GA#484, GA#491, GA#533, GA#540, GA#549, SC#356, GA#559, GA#562, GA#567, GA#578, SC#374, GA#582, SC#375, GA#589, GA#590, SC#382, SC#385*, GA#597, GA#607, SC#415, GA#647, GA#656, GA#664, GA#671, GA#674, GA#675, GA#677, GA#680, Issue #1580, GA#682, GA#683, GA#684, GA#692, GA#693, GA#715
The rest of my CV: Cup of Harmony 73 champions; Philosopher-Queen of Sophia; *author of the most popular SC Res. ever; anti-NPO cabalist in good standing; 48yo Tory woman w/Asperger's; Cambridge graduate ~ currently reading The World by Simon Sebag Montefiore

User avatar
Commerce Heights
Minister
 
Posts: 2050
Founded: Antiquity
Anarchy

Postby Commerce Heights » Sat May 06, 2017 1:32 pm

Tinhampton wrote:Following on from my previous SGIS sagas, I've sorted out the code. Well, sorted it out enough so I can see it on the Association Football dropdown menu.
Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<sport version="0.3">
    <name>Association football—SGIS formula</name>
    <discipline>Association football</discipline>
    <event>SGIS formula</event>
    <scorinator /> <!-- only one scorinator is needed for this event -->
   
    <paradigm>sgis</paradigm>
    <paradigmOptions>
      <double type="constantA">0.11</double>
      <double type="constantB">0.08</double>
      <double type="homeAdvantage">1.223333333333</double>
      <double type="homeAdvantageGG">0.123333333333</double>
      <int type="attacks">12</int>
      <double type="etAttackCoeff">0.293333333333</double>
      <int type="shootoutLength">5</int>
      <double type="goldenGoalProb">0.4</double>
      <double type="shootoutProb">0.65</double>
      <int type="pointValues">1</int>
      <double type="attackCoeffs">1</double>
      <double type="NSFSStyleCoeffA">2.0000000000000</double>
      <double type="NSFSStyleCoeffB">1.2000000000000</double>
      <double type="NSFSStyleExponent">-0.23705203296846</double>
      <double type="NSFSStyleOffset">0.102435335725325</double>
      <string type="tableHeaderGoalsFor">GF</string>
      <string type="tableHeaderGoalsAgainst">GA</string>
      <string type="tableHeaderGoalDifference">GD</string>
      <list type="tiebreakers">
         <string>extratime</string>
         <string>shootout</string>
      </list>
      <list type="tiebreakerNames">
         <string>AET</string>
         <string>pen.</string>
      </list>
    </paradigmOptions>
   
   <!-- the style modifier distribution is a bit wonky because negative modifiers are less likely to take effect -->
    <dataPoints name="style">
      <dataPoint pos="0">-3</dataPoint>
      <dataPoint pos="0.4">-1</dataPoint>
      <dataPoint pos="0.5">0</dataPoint>
      <dataPoint pos="0.65">0</dataPoint>
      <dataPoint pos="1">3</dataPoint>
    </dataPoints>
</sport>

However, this code asks me either for a mass-start or a multiple run league, and ends up scorinating every match as a negative-one-all draw (yes, you read that right, negative goals). Something is wrong with the data - but what is?

xkoranate doesn’t have a paradigm called “sgis”.

User avatar
Tinhampton
Postmaster-General
 
Posts: 13701
Founded: Oct 05, 2016
Civil Rights Lovefest

Postby Tinhampton » Sat May 06, 2017 1:41 pm

Commerce Heights wrote:
Tinhampton wrote:Following on from my previous SGIS sagas, I've sorted out the code. Well, sorted it out enough so I can see it on the Association Football dropdown menu.
Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<sport version="0.3">
    <name>Association football—SGIS formula</name>
    <discipline>Association football</discipline>
    <event>SGIS formula</event>
    <scorinator /> <!-- only one scorinator is needed for this event -->
   
    <paradigm>sgis</paradigm>
    <paradigmOptions>
      <double type="constantA">0.11</double>
      <double type="constantB">0.08</double>
      <double type="homeAdvantage">1.223333333333</double>
      <double type="homeAdvantageGG">0.123333333333</double>
      <int type="attacks">12</int>
      <double type="etAttackCoeff">0.293333333333</double>
      <int type="shootoutLength">5</int>
      <double type="goldenGoalProb">0.4</double>
      <double type="shootoutProb">0.65</double>
      <int type="pointValues">1</int>
      <double type="attackCoeffs">1</double>
      <double type="NSFSStyleCoeffA">2.0000000000000</double>
      <double type="NSFSStyleCoeffB">1.2000000000000</double>
      <double type="NSFSStyleExponent">-0.23705203296846</double>
      <double type="NSFSStyleOffset">0.102435335725325</double>
      <string type="tableHeaderGoalsFor">GF</string>
      <string type="tableHeaderGoalsAgainst">GA</string>
      <string type="tableHeaderGoalDifference">GD</string>
      <list type="tiebreakers">
         <string>extratime</string>
         <string>shootout</string>
      </list>
      <list type="tiebreakerNames">
         <string>AET</string>
         <string>pen.</string>
      </list>
    </paradigmOptions>
   
   <!-- the style modifier distribution is a bit wonky because negative modifiers are less likely to take effect -->
    <dataPoints name="style">
      <dataPoint pos="0">-3</dataPoint>
      <dataPoint pos="0.4">-1</dataPoint>
      <dataPoint pos="0.5">0</dataPoint>
      <dataPoint pos="0.65">0</dataPoint>
      <dataPoint pos="1">3</dataPoint>
    </dataPoints>
</sport>

However, this code asks me either for a mass-start or a multiple run league, and ends up scorinating every match as a negative-one-all draw (yes, you read that right, negative goals). Something is wrong with the data - but what is?

xkoranate doesn’t have a paradigm called “sgis”.

Thanks for the clarification! It's up'n'running now.
The Self-Administrative City of TINHAMPTON (pop. 329,537): Saffron Howard, Mayor (UCP); Alexander Smith, WA Delegate-Ambassador

Authorships & co-authorships: SC#250, SC#251, Issue #1115, SC#267, GA#484, GA#491, GA#533, GA#540, GA#549, SC#356, GA#559, GA#562, GA#567, GA#578, SC#374, GA#582, SC#375, GA#589, GA#590, SC#382, SC#385*, GA#597, GA#607, SC#415, GA#647, GA#656, GA#664, GA#671, GA#674, GA#675, GA#677, GA#680, Issue #1580, GA#682, GA#683, GA#684, GA#692, GA#693, GA#715
The rest of my CV: Cup of Harmony 73 champions; Philosopher-Queen of Sophia; *author of the most popular SC Res. ever; anti-NPO cabalist in good standing; 48yo Tory woman w/Asperger's; Cambridge graduate ~ currently reading The World by Simon Sebag Montefiore

User avatar
Audioslavia
Game Moderator
 
Posts: 3486
Founded: Antiquity
Left-Leaning College State

Postby Audioslavia » Mon May 08, 2017 3:59 pm

The Racing Scorinator V1
Save to your own Google Drive (recommended) or download and run in Excel
See an error? Leave a comment on the file, or make a post on this thread, or send me a TG


The WGPC scorinator is a massive thing. 'The Racing Scorinator' is an attempt at distilling it into something user friendly. I'd still call it 'pretty far from user friendly' but hey.

Anyone with a degree of skill in using spreadsheets effectively will note that the sheet is still needlessly heavy. If anyone would like to take a shot at further distilling it down they're more than welcome. My spreadsheet skills are still somewhat lacking.

For anyone who is a bit put off by the masses of numbers firing everywhere: relax. If you follow the instructions and don't fiddle with any parts that you shouldn't fiddle with (ie the grey parts) then you should be fine.

Here are some instructions. Let me know if you need anything adding.

Setting up the Scorinator

ENTERING DRIVERS
- Go to the 'Info' tab. Find the orange boxes on the left.
- Insert the information for each driver. Nationality should be in the form of a trigram. Make sure no two drivers have the same number. Teammates should be put next to one another.
- IF USING 'RELIABILITY' AS THIRD SKILL: Enter the driver's 'Aggression' skill under 'A'. Enter the driver's 'Technique' skill under 'C'. Enter the driver's 'Reliability' skill under 'R'. The maximum total value for these three stats is 12. No skill should be larger than 6 or smaller than 2.
- IF NOT USING 'RELIABILITY' AS A THIRD SKILL: Enter the driver's 'Aggression' skill under 'A'. Enter the driver's 'Technique' skill under 'C'. The maximum total value for these two stats is 8. No skill should be larger than 6 or smaller than 2
- Ignore the black columns.
- Now, copy the driver numbers. To do this, highlight everything from field A3 to field A28 and hit 'ctrl+c'. If you have more active drivers than this, then you have too many drivers.
- Now, go to the 'Standings and bonus' tab, click on column B3 and hit ctrl+v. All stats for the driver with this number should appear on the sheet automatically.
- The information should automatically appear on all the relevant sheets.
- You should also paste these numbers into the L32 - L57 fields in the Race tab. This is the place (or, rather, K32 - K57 is the place) where the starting grid is set.

ENTERING TEAMS
- Go to the 'info' tab. Find the purple boxes on in the middle.
- Enter the team name and nationality. The nationality should be in the form of a trigram.
- IF USING 'RELIABILITY' AS THIRD SKILL: Enter the team's 'Acceleration' skill under 'A'. Enter the team's 'Cornering' skill under 'C'. Enter the driver's 'Reliability' skill under 'R'. The maximum total value for these three stats is 12. No skill should be larger than 6 or smaller than 2.
- IF NOT USING 'RELIABILITY' AS A THIRD SKILL: Enter the team's 'Acceleration' skill under 'A'. Enter the team's 'Technique' skill under 'C'. The maximum total value for these two stats is 8. No skill should be larger than 6 or smaller than 2

ENTERING CIRCUITS
- Go to the 'info' tab. Find the green boxes on the right.
- Enter the information about the circuit's nation and name, and the name of the Grand Prix and the place the grandprix is at. The nationality should be in the form of a trigram.
- The 'fastest expected laptime' columns are automated. Ignore these.
- Enter the track's lap record. This is be for a WGPC-speed car.
- Enter the length of the track in kilometres.
- Ignore the '# of laps' column. This is automatic.
- For the circuit's Aggressiveness rating, enter a number in the 'A' column. This number should be between 1 and 10.
- For the circuit's Technical Difficulty, enter a number between 1 and 10. The two numbers should add up to ten.
- If the qualifying type is 'Traditional', enter 'T'. If it's two-tiered, enter 'TT'.
- Enter the precipitation percentage under 'Chance of Rain (%). This number should be between 1 and 20. 1 means there will be a 1% chance of a wet race and 1.5% chance of a 'changeable' race. 20% means there will be a 20% chance of a wet race and a 30% chance of a 'changeable' race
- Enter the 'overtaking difficulty' stat for each circuit. This should be a number between 0.5 and 5, with 5 being difficult and 0.5 being easy. 2.5 is average.

GENERAL SEASON INFO
- Just to the right of the circuits you'll see some boxes for general info about the season.
- Enter the 'kilometres per race' on the right hand side. This is 305 for the WGPC. It will probably be lower for WGP2.
- For 'Speed of Cars' put '100' if the cars are Formula 1 standard or '90' if the cars are GP2 standard. WGP2 cars will be slower than the top-of-the-range WGPC cars. You would put 45 or so for touring cars, 60 for Formula E cars etc)
- If you're using 'Reliability' as a metric, then put a 'Y' in this box. If not, put a 'N'. Either option is fine. Switching it to 'N' when all teams/drivers have a 'reliability' setting is fine. Setting it to 'Y' when no drivers/teams have a reliability setting is suicidal.
- Enter the amount of points awarded per race on the right-hand-side of the yellow fields. If these aren't in descending order then you're doing something very wrong.

Scorinating

SCORINATING PRACTICE EVENTS

- Sort out RP bonuses first.
- Go to the 'current' tab. In the B1 field next to 'raceweek' you should put the current week of the season. For the first event this number would be '1'.
- Practice is held on Friday, so write 'Friday' in B2.
- The results for that practice event should then be displayed.
- Copy and paste the information displayed into notepad (or similar) and neaten it up.
- Paste into thread in PRE tags.

SCORINATING QUALIFYING EVENTS
- Sort out RP bonuses.
- Go to the 'current' tab. In the B1 field next to 'raceweek' you should put the week. For the first event, this number should be '1'.
- Qualifying is held on a Saturday, so write 'Saturday' in B2.
- Results for qualifying should appear.
- Copy and paste the information displayed into notepad (or similar) and neaten it up.
- Paste into thread in PRE tags.
- If it says 'Two-tiered' under qualifying type, then go to the 'Two-tiered qualifying' tab. Otherwise, go to the 'traditional qualifying' tab.
- Highlight the row of purple cells with the red numbers and hit ctrl+c
- Go to the 'race' tab and find cell L32. Right-click and in the 'paste special' submenu select 'paste values only'. This will set up the starting grid for Sunday's race.

SCORINATING RACE EVENTS

- Sort out RP bonuses.
- Go to the 'race' tab and check that the cars are in the correct order on the grid by checking the 'Qual pos' column from L32 to L57
- Go to the 'current' tab. In the B1 field next to 'raceweek' you should put the week. For the first event, this number should be '1'.
- Races are held on a Sunday so write 'Sunday' in B2.
- Copy and paste the information displayed into notepad (or similar) and neaten it up.
- Now go back to the 'race' tab. Highlight the row of 26 blue fields with yellow numbers and hit ctrl+c.
- Go to the 'Standings and Bonus' tab and select the top blue box of that raceweek.
- Right-click, go to the 'paste special' submenu and hit 'paste values only'.
- Scroll right and you'll see the updated drivers championship standings. Copy and paste into notepad.
- Go to the 'team standings' tab. Copy the yellow columns and paste into notepad.
- Neaten up and post in PRE tabs.

GRADING RP BONUS
- Go to the 'RP bonus' tab
- Write the trigram of every RPer in the leftmost column.
- For the driver signup period, where drivers negotiate to find teams, the maximum RP bonus is 20.
- For races, the maximum RP bonus is 10.
- The scorinator runs on a multiplicative/degrading system. RPs graded for the current race are multiplied by 13. The previous race's are multiplied by 7.5, the one before that by 4.75 and so on in a ((12/X)+1) fashion. As of 2017-11-03 this process is automatic.
- If you'd prefer to use an additive RP bonus system (not recommended), then you can simply replace all of the numbers at the top with a '1' in each field.

Signups Templates
These templates contain the minimum information required. You can add various RP stuff to this if you want.

DRIVER SIGNUPS
Driver Name:
Nationality (Trigram):
Preferred Number:


THEN EITHER
Aggression (Between 2 and 6):
Technique (Between 2 and 6):


OR
Aggression (Between 2 and 5):
Technique (Between 2 and 5):
Reliability (Between 2 and 5):


TEAM SIGNUPS
Team Name:
Team Nationality (Trigram):


THEN EITHER
Acceleration(Between 2 and 6):
Cornering (Between 2 and 6):


OR
Acceleration (Between 2 and 5):
Cornering (Between 2 and 5):
Reliability (Between 2 and 5):


CIRCUIT SIGNUPS
Circuit Name:
Grand Prix Name:
Place:
Lap Record (F1/WGPC Car):
Track Length (km):
Qualifying Type (Traditional or Two-Tiered):
Chance of being a wet race (1%-20%)
Overtaking difficulty (0.5 - 5. 0.5 is easy, 5 is difficult):

Aggressiveness (1-10):
Technical Ability (1-10):
(Both these numbers should add up to 10)



Limitations
Thing that might break the scorinator				Workaround
Having more than two drivers from the same nation Use a different trigram for the extra drivers AND a different trigram
for the race circuit of that nation. To mimick the home race bonus for
those drivers, try giving them an RP bonus boost for that raceday.

Having two teams from the same nation. Use a different trigram for the extra team
To mimick the home race bonus for the teams, try giving them
an RP bonus boost for that raceday.

Removing a drver during the season You will need to copy and [paste special]>[paste values only]
THE ENTIRE ROW of driver info on the Standings and Bonus
sheet to one of the empty rows below the roster of drivers on that
sheet. This should ensure their points still show up in
the drivers/teams championship standings.

Drivers switching teams during the season This is a fart. I recommend you instigate a 'one team per season'
rule for drivers.

A race having more than 93 laps Don't have races that last for more than 93 laps.

A race having less than 30 laps. I can't remember why this is a problem, but I was warned about this when
Liventia gave me the original sheet so I've always tried to avoid it.
Avoid this, just in case. It might still be a bug in the system.

Having more than 26 drivers on the grid. Don't have more than 26 drivers on the grid.

Having more than one circuit per nation. Don't have more than one circuit per nation.
Use a different trigram for the second circuit AND give the home drivers
an RP bonus for that race to preserve the home circuit bonus.



FAQ
Q: Is this the WGPC scorinator?
A: Not quite. This is a heavily modified version of the Season 15 scorinator. Season 16's scorinator will be a heavily modified version the Season 15 scorinator too, but in a different way.

Q: This is a bit overwhelming...
A: It is a little, yes, I suppose. You can make it easier by ignoring anything that's in a grey box. The bits that you'll need to enter data into are generally colorful.

Q: Can I make changes to this sheet?
A: Go ahead. I don't own it. What you're seeing is a heavily edited version of a sheet which I received from Liventia, which in turn was a heavily edited sheet which he'd received from Casari. The whole thing is about 8 years old.

Q: SHOULD I make changes to this sheet?
A: If you know what you're doing then sure, why not?

Q: I haven't used any spreadsheets before, actually.
A: Then no. You should probably change nothing outwith the instructions above.

Q: I found an error in the sheet...
A: Awesome! Please TG me or leave a note in the scorinators thread

Q: What do these ACR things do?
A: Drivers take their 'A' skills from their own Aggression stats and their car's Acceleration stats and multiply them by the course's Aggressiveness stats. It's the same with the Technique/Cornering/Technical Difficulty stats. The reliability stat controls how often they crash or spin or destroy their car.

Q: Is one better than the other?
A: No. *touch wood*

Q: You've only just released this scorinator. Nobody else has used it. How is it possible that you have 'frequently asked questions'
A: How is it possible that your face has frequently asked questions, you mean. Bumarse.

Q: I pressed a button and all the results changed and it's messed everything up!
A: Don't press a button. The moment you scorinate you should:
(a) Immediately copy and paste the results into notepad.
(b) After qualifying you should immediately C+P the final qualifying positions into the racegrid and, after the race, you should immediately copy and paste the results into the results grid.
If you do anything between (a) and (b) then you will lose your data.

Q: I.. lost the data...
A: Rescorinate.

Q: Can a team change drivers in the middle of a season?
A: Yes, that's not too much of a problem. Simply go to the Standings and Bonus row, highlight the entirety of a driver's row, hit Ctrl+C, and then go to the first free spot and right click > paste special > paste values only. Then enter the new driver's information where the old driver's info used to be. All that's changed is that you'll have to manually add the old driver's points-scored into the constructor's championship thing when you post it.

Q: Can a driver drive for two teams during a season.
A: ...yes, but it's a massive fart. I'd instigate a 'one team per season' rule if I were you.


EDIT: Fixed issue with race reliability. Please re-download. 14/5/17

EDIT: Automated RP bonus multipliers and added info on this to instructions. 3/11/17
Last edited by Audioslavia on Thu Nov 02, 2017 4:05 pm, edited 2 times in total.

User avatar
Barunia
Minister
 
Posts: 2068
Founded: Dec 23, 2012
Liberal Democratic Socialists

Postby Barunia » Mon May 08, 2017 9:30 pm

Audioslavia wrote: - Now, copy the driver numbers. To do this, highlight everything from field A3 to field A28 and hit 'ctrl+c'. If you have more active drivers than this, then you have too many drivers.
- Now, go to the 'Standings and bonus' tab, click on column B3 and hit ctrl+v. All stats for the driver with this number should appear on the sheet automatically.
- The information should automatically appear on all the relevant sheets.
- You should also paste these numbers into the L32 - L57 fields in the Race tab. This is the place (or, rather, K32 - K57 is the place) where the starting grid is set.


I haven't opened it yet (I'll do so when I have some free time), but it should be possible to streamline this by simply entering in B3 of the standings tab the formula =(sheetname that the cells are in*)A3, which should automatically update the destination cells with the source data. You can even use "IFBLANK" to eliminate empty cells.

* I can't remember the exact formula for cross-sheet formulas off the top of my head, but it is definitely possible.
Head of Dipomacy for the Union of Red Nations
Join the URN! A place for all communists, socialists, and left-wing nations.
I use my factbook!

Officially jolly good sporting chaps! Winners of the 2nd Chap Olympiad! (As MCSA)

Football
Baptism of Fire 51: Quarter-finalists
Cup of Harmony 62 & 64: Runner-ups
Qualified for World Cup 67,68,73,74,75

Rugby Union World Cup 25 - Third Place

Hosts of the 4th T20 Cricket World Cup
Third Place in the 4th T20 Cricket World Cup

Hosts of the Celebration of Field Hockey

Board Member of the World Calvinball Federation


Rugby World Cup 26 Champions
Author of Issue #604

User avatar
Vilita
Minister
 
Posts: 2112
Founded: Feb 23, 2004
Ex-Nation

Postby Vilita » Mon May 08, 2017 11:01 pm

As long as nothing is in the cells you can just do =if(Info!A3="","",Info!A3)

So if there is nothing in Info A3, then it returns nothing. Otherwise it returns Cell A3 of Info.

Then drag down from B3 through B28 and it should take care of all.
-¤-¤-¤World Cup 20 Champions¤-¤-¤-¤-¤-¤World Cup 68 Champions¤-¤-¤-
-¤-¤-¤World Cup 77 Champions¤-¤-¤-

Region: Atlantian Oceania - The Home of Sport

User avatar
Audioslavia
Game Moderator
 
Posts: 3486
Founded: Antiquity
Left-Leaning College State

Postby Audioslavia » Tue May 09, 2017 3:49 am

Barunia wrote:
Audioslavia wrote: - Now, copy the driver numbers. To do this, highlight everything from field A3 to field A28 and hit 'ctrl+c'. If you have more active drivers than this, then you have too many drivers.
- Now, go to the 'Standings and bonus' tab, click on column B3 and hit ctrl+v. All stats for the driver with this number should appear on the sheet automatically.
- The information should automatically appear on all the relevant sheets.
- You should also paste these numbers into the L32 - L57 fields in the Race tab. This is the place (or, rather, K32 - K57 is the place) where the starting grid is set.


I haven't opened it yet (I'll do so when I have some free time), but it should be possible to streamline this by simply entering in B3 of the standings tab the formula =(sheetname that the cells are in*)A3, which should automatically update the destination cells with the source data. You can even use "IFBLANK" to eliminate empty cells.

* I can't remember the exact formula for cross-sheet formulas off the top of my head, but it is definitely possible.


I wanted that part to be done manually so that the order of the drivers on the info sheet can be re-arranged without it affecting the other sheets, and so the drivers on the Standings and Bonus sheet can be replaced quickly without the need to fiddle around too much.

User avatar
Audioslavia
Game Moderator
 
Posts: 3486
Founded: Antiquity
Left-Leaning College State

Postby Audioslavia » Sun May 14, 2017 11:54 am

Just a heads up, there was a small error on the sheet which messed up the reliability for races. Fixed now. You'll need to re-download it again.

User avatar
Isiasovoria
Secretary
 
Posts: 26
Founded: Sep 04, 2016
Ex-Nation

Postby Isiasovoria » Sat Jun 24, 2017 7:30 pm

How does one implement KPB and style points into xkorenate? Thanks.

User avatar
Free Republics
Minister
 
Posts: 3114
Founded: May 03, 2013
Ex-Nation

Postby Free Republics » Sat Jun 24, 2017 11:46 pm

Isiasovoria wrote:How does one implement KPB and style points into xkorenate? Thanks.


KPB or any other sort of ranking is just entered into the "skill" column. To implement an RP bonus or roster bonus, just record the bonus data elsewhere (I recommend using a spreadsheet if you're familiar with how to use spreadsheets to do basic math) and then add that to what's in the skill column. Leave the minimum skill set to 0 and set the maximum skill to whatever the #1 ranked team's ranking is or the highest rank+bonus, whichever is higher (setting that value higher than necessary increases the number of upsets). Unless you're scorinating an Olympics (or something like that), avoid the bonus tab because its easy to set it up wrong and end up with an extremely large (or worse extremely small) bonus. Style mods are implemented by entering them into the "style" column. If there is no "style" column listed, then you'll need to select a different formula (or maybe a different sport) to use style mods.
Why I left NS Sports
World Cup 85 Champions
1st: DBC 28, X Winter Olympics, Independents Cup 4, CoH 66, WBC 46, World Bowl XXXVIII, World Cup 85
2nd: World Cup 68, DBC 27, U15WC 8, UWCFA Gold Cup I, BoI 15, 2nd Imperial Chap Olympiad, NSCF 11
Host: World Cups 68 & 81, CoH 58, Games of XIII Olympiad, X Winter Olympics, World Bowls XXII, XXXI & XXXVIII, WBCs 42 & 46, RUWC 25
Current Senior Consul: Nova Hellstrom-Hancock (Golden Age)
Current Junior Consul: Samuel Izmailov (Nat-Gre)
Demonym: Republican
Trigram: FFR
Official Nation Name: Federation of Free Republics
Stop Biden: Vote Trump!

User avatar
Isiasovoria
Secretary
 
Posts: 26
Founded: Sep 04, 2016
Ex-Nation

Postby Isiasovoria » Sun Jun 25, 2017 8:06 am

Free Republics wrote:
Isiasovoria wrote:How does one implement KPB and style points into xkorenate? Thanks.


KPB or any other sort of ranking is just entered into the "skill" column. To implement an RP bonus or roster bonus, just record the bonus data elsewhere (I recommend using a spreadsheet if you're familiar with how to use spreadsheets to do basic math) and then add that to what's in the skill column. Leave the minimum skill set to 0 and set the maximum skill to whatever the #1 ranked team's ranking is or the highest rank+bonus, whichever is higher (setting that value higher than necessary increases the number of upsets). Unless you're scorinating an Olympics (or something like that), avoid the bonus tab because its easy to set it up wrong and end up with an extremely large (or worse extremely small) bonus. Style mods are implemented by entering them into the "style" column. If there is no "style" column listed, then you'll need to select a different formula (or maybe a different sport) to use style mods.


Thank you!

User avatar
Gregoryisgodistan
Senator
 
Posts: 3907
Founded: Jun 22, 2013
Ex-Nation

Postby Gregoryisgodistan » Mon Jul 17, 2017 7:59 pm

Is there any way in editing the xkoronate files to change the point values for each score in extra time? I'm trying to modify the SQIS and/or NSFS scorinators to force extra time since it would be helpful for scorinating two-legged ties, but I've tried a bunch of different things and the only remaining thing I can think of is setting point values to 0 in regulation and keeping them at 1 in extra time, but I don't know if such a thing is possible.
Gregoryisgodistan, population 75,000,000. All citizens are required to worship Lord Almighty Gregory, our head of state, as a deity.
IBS II Champions
Beach Cup IX Round of 16
World Indoor Soccer Championship 6 - 2nd place
BoI XIV Champion
IBS III Champions
WCoH 22 Round of 16
WB XXII 10th Place in Casaran, advanced to Round of 32
IBS IV host, champion
4th in WCoH 23
WBC 29 QF
HWC 12 hosts
WJHC VI 2nd place,
CoH 60 4th place
WCoH XXIV Champs
CoH 61 Runner-Up
IBS VI Champs
BOI XVI Host
IBS VII Champs
WCoH XXV 2nd Place
WBC 32 2nd Place
IBS VIII host and champs
WBC 33 Host/QF
WCoH 27 co-host and champs
WC 72 Qualifier
WBC 34 champs
CoH 67 Third place

User avatar
Free Republics
Minister
 
Posts: 3114
Founded: May 03, 2013
Ex-Nation

Postby Free Republics » Mon Jul 17, 2017 9:48 pm

Gregoryisgodistan wrote:Is there any way in editing the xkoronate files to change the point values for each score in extra time? I'm trying to modify the SQIS and/or NSFS scorinators to force extra time since it would be helpful for scorinating two-legged ties, but I've tried a bunch of different things and the only remaining thing I can think of is setting point values to 0 in regulation and keeping them at 1 in extra time, but I don't know if such a thing is possible.


I'd have thought setting the attacks to 0 might work but from my testing that seems to force a shootout 100% of the time (assuming you're talking about soccer) though the regulation score may be higher than 0-0 depending upon the style mods used. I tested this on SQIS.

Since it appears that there is an "extra time attacks coefficient" which is 1/3rd and since the default number of attacks for SQIS is 12, I think you could create something functionally equivalent to extra time by cutting the attacks to 4 and deleting extra time as a tiebreaker (I've done this in the code tag below). I would suggest using the below formula with style mods disabled as style mods can produce some ridiculous extra scores.

Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<sport version="0.3">
   <name>Association football—SQIS Extra Time formula</name>
   <discipline>Association football</discipline>
   <event>SQIS Extra Time formula</event>
   <scorinator /> <!-- only one scorinator is needed for this event -->
   
   <paradigm>sqis</paradigm>
   <paradigmOptions>
      <double type="constantA">0.1</double>
      <double type="constantB">0.07</double>
      <double type="homeAdvantage">1.333333333333</double>
      <double type="homeAdvantageGG">0.133333333333</double>
      <int type="attacks">4</int>
      <double type="etAttackCoeff">0.333333333333</double>
      <int type="shootoutLength">5</int>
      <double type="goldenGoalProb">0.5</double>
      <double type="shootoutProb">0.65</double>
      <int type="pointValues">1</int>
      <double type="attackCoeffs">1</double>
      <double type="NSFSStyleCoeffA">2.0991677816057</double>
      <double type="NSFSStyleCoeffB">1.2442581729602</double>
      <double type="NSFSStyleExponent">-0.42705203296846</double>
      <double type="NSFSStyleOffset">0.072435335725325</double>
      <string type="tableHeaderGoalsFor">GF</string>
      <string type="tableHeaderGoalsAgainst">GA</string>
      <string type="tableHeaderGoalDifference">GD</string>
      <list type="tiebreakers">
<!--         <string>extratime</string>-->
         <string>shootout</string>
      </list>
      <list type="tiebreakerNames">
<!--         <string>AET</string>-->
         <string>pen.</string>
      </list>
   </paradigmOptions>
   
   <!-- the style modifier distribution is a bit wonky because negative modifiers are less likely to take effect -->
   <dataPoints name="style">
      <dataPoint pos="0">-3</dataPoint>
      <dataPoint pos="0.4">-1</dataPoint>
      <dataPoint pos="0.5">0</dataPoint>
      <dataPoint pos="0.65">0</dataPoint>
      <dataPoint pos="1">3</dataPoint>
   </dataPoints>
</sport>


I'm nowhere near as familiar with NSFS so I wouldn't have any idea if it'd be possible to force a 0-0 regulation draw in it but from a glimpse that doesn't appear to be possible.

One other thing that would probably work, which I didn't try, is setting the number of attacks in SQIS to 1 and changing the extra time attack coefficient to 4.0, which would leave teams with just 1 attack where they could score in regulation making a 0-0 draw very likely (and thus minimizing the need for a resim).
Why I left NS Sports
World Cup 85 Champions
1st: DBC 28, X Winter Olympics, Independents Cup 4, CoH 66, WBC 46, World Bowl XXXVIII, World Cup 85
2nd: World Cup 68, DBC 27, U15WC 8, UWCFA Gold Cup I, BoI 15, 2nd Imperial Chap Olympiad, NSCF 11
Host: World Cups 68 & 81, CoH 58, Games of XIII Olympiad, X Winter Olympics, World Bowls XXII, XXXI & XXXVIII, WBCs 42 & 46, RUWC 25
Current Senior Consul: Nova Hellstrom-Hancock (Golden Age)
Current Junior Consul: Samuel Izmailov (Nat-Gre)
Demonym: Republican
Trigram: FFR
Official Nation Name: Federation of Free Republics
Stop Biden: Vote Trump!

User avatar
Savojarna
Ambassador
 
Posts: 1452
Founded: Nov 11, 2016
Scandinavian Liberal Paradise

Postby Savojarna » Wed Jul 19, 2017 8:47 am

Is there a possibility to play around with the road cycling scorinator of Xkoranate to make it produce different outcomes depending on profile of a race or whether it's a one-day or a stage race?

Currently it seems to just generate some result, from what I get. But realistically results would differ quite a lot depending on whether a race is flat, in which case it's likely we have a mass sprint; or hilly/mountainous which would look very different. Same goes for one-day vs. stage races, as riders are usually more offensive on the former and generally dynamics are different. It would be cool to be able to implement this, as currently it's basically impossible to have a realistic stage race. Is that possible under any currently available scorinator?
MT socialist (mostly) island state - Cultural mixture of Scandinavia, Finland and Russia -Exports iron, steel, silver and wood - Low fantasy in terms of animal species - Sports-loving - 22.8 million inhabitants.

The adjective is Savojar; Savojarnan is not a word!
I am a student of (European) politics, ice hockey fan, left-wing communist bordering on anarchy, and European federalist. Enjoy!

User avatar
Darmen
Powerbroker
 
Posts: 7502
Founded: Jan 16, 2011
Moralistic Democracy

Postby Darmen » Wed Jul 19, 2017 10:17 am

Savojarna wrote:Is there a possibility to play around with the road cycling scorinator of Xkoranate to make it produce different outcomes depending on profile of a race or whether it's a one-day or a stage race?

Currently it seems to just generate some result, from what I get. But realistically results would differ quite a lot depending on whether a race is flat, in which case it's likely we have a mass sprint; or hilly/mountainous which would look very different. Same goes for one-day vs. stage races, as riders are usually more offensive on the former and generally dynamics are different. It would be cool to be able to implement this, as currently it's basically impossible to have a realistic stage race. Is that possible under any currently available scorinator?

The road cycling in xkoranate is designed to produce results similar to the road race held at the Olympics. It is not designed for use in scorinating something more akin to the Tour de France or any other multi-stage race. I suppose you could create multiple files for road cycling to simulate different lengths for stages, but that wouldn't necessarily take into account whether a rider was a climber or sprinter or domestique.

There is a spreadsheet cycling scorinator however, created by Liventia iirc, the link to which can probably be found somewhere in this thread, that did take into account a riders skill at various disciplines. I'll see if I can't dig it up, I know I was able to find it a few years ago. Buyan, as Some Village, updated that spreadsheet for use during a World Tour season, but I'm not sure if that updated version was ever publicly released.

EDIT: Linky, linky!
84733842 wrote:Liventia has one in Excel.
Last edited by Darmen on Wed Jul 19, 2017 10:21 am, edited 1 time in total.
The Republic of Darmen
President: Sebastian Elliott (NLP) | Capital: Scott City | Population: 10.6 mil | Demonym: Darmeni | Trigramme: DAR
Factbook (WIP) | Encylopedia | Domestic Sports Newswire
Champions: CoH 51, CR 13, GCF Test 9, GCF Test 13, WBC 25, QWC 7 Runners-up: CoH 53, CR 10, GCF Test 11, T20C 2, T20C 4, RLWC 10, WBC 42
Third: CR 20, T20C 10, RLWC 20, RLWC 22, R7WC 4, WBC 21, BC 6 Host: CR 9, RWC 18, RWC 26, RWC 35, RLWC 12, RLWC 18, RLWC 22, BC 6, BC 10, WVE 4

User avatar
Liventia
Negotiator
 
Posts: 7339
Founded: Feb 04, 2008
Inoffensive Centrist Democracy

Postby Liventia » Wed Jul 19, 2017 12:28 pm

Funny you mention this – I sent Buyan a TG just the other day asking for his most recent scorinator (which he's agreed to provide me with once he's back from holiday) as I'm planning to run a small stage race soon. My scorinator will do a job, but it's by no means efficient or even necessarily technically brilliant. I never got round to developing it further.
Слава Україні!

User avatar
Savojarna
Ambassador
 
Posts: 1452
Founded: Nov 11, 2016
Scandinavian Liberal Paradise

Postby Savojarna » Thu Jul 20, 2017 6:18 am

Darmen wrote:
Savojarna wrote:Is there a possibility to play around with the road cycling scorinator of Xkoranate to make it produce different outcomes depending on profile of a race or whether it's a one-day or a stage race?

Currently it seems to just generate some result, from what I get. But realistically results would differ quite a lot depending on whether a race is flat, in which case it's likely we have a mass sprint; or hilly/mountainous which would look very different. Same goes for one-day vs. stage races, as riders are usually more offensive on the former and generally dynamics are different. It would be cool to be able to implement this, as currently it's basically impossible to have a realistic stage race. Is that possible under any currently available scorinator?

The road cycling in xkoranate is designed to produce results similar to the road race held at the Olympics. It is not designed for use in scorinating something more akin to the Tour de France or any other multi-stage race. I suppose you could create multiple files for road cycling to simulate different lengths for stages, but that wouldn't necessarily take into account whether a rider was a climber or sprinter or domestique.

There is a spreadsheet cycling scorinator however, created by Liventia iirc, the link to which can probably be found somewhere in this thread, that did take into account a riders skill at various disciplines. I'll see if I can't dig it up, I know I was able to find it a few years ago. Buyan, as Some Village, updated that spreadsheet for use during a World Tour season, but I'm not sure if that updated version was ever publicly released.

EDIT: Linky, linky!
84733842 wrote:Liventia has one in Excel.


I don't understand how this works, but it's at least something I can play around with a bit I guess :D
MT socialist (mostly) island state - Cultural mixture of Scandinavia, Finland and Russia -Exports iron, steel, silver and wood - Low fantasy in terms of animal species - Sports-loving - 22.8 million inhabitants.

The adjective is Savojar; Savojarnan is not a word!
I am a student of (European) politics, ice hockey fan, left-wing communist bordering on anarchy, and European federalist. Enjoy!

User avatar
Lisander
Minister
 
Posts: 2259
Founded: Feb 09, 2013
New York Times Democracy

Postby Lisander » Sun Jul 23, 2017 8:16 pm

I was talking to some friends about xkoranate, and one of them told me about something he called a "trend of results."

For this friend, xkoranate has the tendency (sometimes good) of not allowing unexpected results, so in individual games the strongest always wins and the weakest always loses much more often. Simulating the championship all at once, this changes completely. The strongest does not always win, and the weakest does not always lose.

This trend seems clear to you?
The Principality of Lisander, a sports loving, very highly developed nation in Astyria.
Disappointing people and missing deadlines since 2013.

User avatar
Osarius
Senator
 
Posts: 4031
Founded: Mar 21, 2006
Civil Rights Lovefest

Postby Osarius » Mon Jul 24, 2017 3:18 am

Lisander wrote:xkoranate has the tendency (sometimes good) of not allowing unexpected results, so in individual games the strongest always wins and the weakest always loses much more often. Simulating the championship all at once, this changes completely. The strongest does not always win, and the weakest does not always lose.

I don't see how it could be "always" given how xkoranate calculates results. There is always a possibility of the underdog winning, as far as I'm aware.
This, to me, sounds like it's a simple product of probability. If you were to re-sim that individual game a thousand times, you'd see something closer to the true probability of the outcome. If the skill disparity means there is a very small chance of the underdog winning, you're obviously less likely to see it in an individual scorination.

Over a season of games, there are (by the very nature of the competition) a lot more instances, which means a lot more individual calculations. In turn, this means the likelihood of an "unexpected result" (i.e. one in which the underdog wins) increases.

There may be more to it -- like if xkoranate generates an array of unique numbers to use when scorinating a larger number of games at once, like a full league championship -- but I don't think is the case (not least because this would be a highly unusual method to use, and I believe it would actually require extra work in the background to make sure the values are unique). I'd imagine it's much more likely that it's just probability at work.
Monarch: Alexander III | First Minister: Mathieu Lupin | Population: ~125 million | Capital: Burningham, Mount Crown
Civilisation Index: 13.43 • Tier 7, Level 2, Type 5
Current Project(s): a discord scorination bot, and a football manager knock-off

Useful NSSports Stuff | RabaSport.net

||A Loyal Citizen of Wakanda||

User avatar
Free Republics
Minister
 
Posts: 3114
Founded: May 03, 2013
Ex-Nation

Postby Free Republics » Mon Jul 24, 2017 8:58 am

To make it easier to find where to download scorinators and other hosting-related programs, I'm going to be creating a list of scorinators on the NS Sports History nation soon. I know where to find all of the scorinators I've created and the big 2 (xkoranate and NSFS). If there are other scorinators that you want to see on that list, please post links here or TG them to NS Sports History.
Why I left NS Sports
World Cup 85 Champions
1st: DBC 28, X Winter Olympics, Independents Cup 4, CoH 66, WBC 46, World Bowl XXXVIII, World Cup 85
2nd: World Cup 68, DBC 27, U15WC 8, UWCFA Gold Cup I, BoI 15, 2nd Imperial Chap Olympiad, NSCF 11
Host: World Cups 68 & 81, CoH 58, Games of XIII Olympiad, X Winter Olympics, World Bowls XXII, XXXI & XXXVIII, WBCs 42 & 46, RUWC 25
Current Senior Consul: Nova Hellstrom-Hancock (Golden Age)
Current Junior Consul: Samuel Izmailov (Nat-Gre)
Demonym: Republican
Trigram: FFR
Official Nation Name: Federation of Free Republics
Stop Biden: Vote Trump!

User avatar
Lisander
Minister
 
Posts: 2259
Founded: Feb 09, 2013
New York Times Democracy

Postby Lisander » Mon Jul 24, 2017 9:10 am

Free Republics wrote:To make it easier to find where to download scorinators and other hosting-related programs, I'm going to be creating a list of scorinators on the NS Sports History nation soon. I know where to find all of the scorinators I've created and the big 2 (xkoranate and NSFS). If there are other scorinators that you want to see on that list, please post links here or TG them to NS Sports History.


I'd like to put my hands on Starblaydia Rugby Scorinator and NSFS Rugby Mod (would be great to my duties of NSRB President). If someone have them, please shoot me a TG.
The Principality of Lisander, a sports loving, very highly developed nation in Astyria.
Disappointing people and missing deadlines since 2013.

User avatar
Eastfield Lodge
Postmaster-General
 
Posts: 10027
Founded: May 23, 2008
Democratic Socialists

Postby Eastfield Lodge » Mon Jul 24, 2017 11:40 am

Last edited by Eastfield Lodge on Mon Jul 24, 2017 11:41 am, edited 1 time in total.
Economic Left/Right: -5.01 (formerly -5.88)
Social Libertarian/Authoritarian: -2.31 (formerly 2.36)
ISideWith UK
My motto translates to: "All Eat Fish and Chips!"
First person to post the 10,000th reply to a thread on these forums.
International Geese Brigade - Celebrating 0 Radiation and 3rd Place!
info to be added
stuff to be added
This nation partially represents my political, social and economic views.

User avatar
Osarius
Senator
 
Posts: 4031
Founded: Mar 21, 2006
Civil Rights Lovefest

Postby Osarius » Mon Jul 24, 2017 1:50 pm

I have a page up on my site with a few scorinators I host for others (and some other crap I made). There's also a google drive folder with other assorted bits and pieces I threw together over the years. Dunno how useful most of it is though.
Last edited by Osarius on Mon Jul 24, 2017 1:52 pm, edited 1 time in total.
Monarch: Alexander III | First Minister: Mathieu Lupin | Population: ~125 million | Capital: Burningham, Mount Crown
Civilisation Index: 13.43 • Tier 7, Level 2, Type 5
Current Project(s): a discord scorination bot, and a football manager knock-off

Useful NSSports Stuff | RabaSport.net

||A Loyal Citizen of Wakanda||

PreviousNext

Advertisement

Remove ads

Return to NS Sports

Who is online

Users browsing this forum: No registered users

Advertisement

Remove ads