Upload Points & Standings Update - Revision history

Cmott at 04:22, 1 April 2025

2025-04-01T04:22:05Z

← Older revision		Revision as of 04:22, 1 April 2025
Line 25:		Line 25:
	Owner's points are tracked manually using the Franchise spreadsheets. Select the correct spreadsheet from the table below to begin updating the Owner's points:		Owner's points are tracked manually using the Franchise spreadsheets. Select the correct spreadsheet from the table below to begin updating the Owner's points:

	~~{{center\|~~{\| class="wikitable" style:"margin:auto"		{\| class="wikitable" style:"margin:auto"
	\|+ Franchise Spreadsheets		\|+ Franchise Spreadsheets
	\|-		\|-
Line 36:		Line 36:
	\| Truck Series \|\| [https://docs.google.com/spreadsheets/d/1Zy-gcpK0qyag_bvtD3niAaFXIgPYvJ8USX53g_B4LiQ/edit?usp=sharing Truck Franchises & Owner Standings]		\| Truck Series \|\| [https://docs.google.com/spreadsheets/d/1Zy-gcpK0qyag_bvtD3niAaFXIgPYvJ8USX53g_B4LiQ/edit?usp=sharing Truck Franchises & Owner Standings]
	\|}		\|}
	}}

	<strong>IMPORTANT NOTE:</strong> Any time you are working within the Franchise spreadsheets, only make edits on the "Franchises" and "Entry Lists" tabs. The "Standings" tab will automatically update based off the information in the other tabs.		<strong>IMPORTANT NOTE:</strong> Any time you are working within the Franchise spreadsheets, only make edits on the "Franchises" and "Entry Lists" tabs. The "Standings" tab will automatically update based off the information in the other tabs.

Cmott: /* Owner's Points */

2025-04-01T04:21:52Z

Owner's Points

← Older revision		Revision as of 04:21, 1 April 2025
Line 25:		Line 25:
	Owner's points are tracked manually using the Franchise spreadsheets. Select the correct spreadsheet from the table below to begin updating the Owner's points:		Owner's points are tracked manually using the Franchise spreadsheets. Select the correct spreadsheet from the table below to begin updating the Owner's points:

	{\| class="wikitable" style:"margin:auto"		{{center\|{\| class="wikitable" style:"margin:auto"
	\|+ Franchise Spreadsheets		\|+ Franchise Spreadsheets
	\|-		\|-
Line 36:		Line 36:
	\| Truck Series \|\| [https://docs.google.com/spreadsheets/d/1Zy-gcpK0qyag_bvtD3niAaFXIgPYvJ8USX53g_B4LiQ/edit?usp=sharing Truck Franchises & Owner Standings]		\| Truck Series \|\| [https://docs.google.com/spreadsheets/d/1Zy-gcpK0qyag_bvtD3niAaFXIgPYvJ8USX53g_B4LiQ/edit?usp=sharing Truck Franchises & Owner Standings]
	\|}		\|}
			}}

	<strong>IMPORTANT NOTE:</strong> Any time you are working within the Franchise spreadsheets, only make edits on the "Franchises" and "Entry Lists" tabs. The "Standings" tab will automatically update based off the information in the other tabs.		<strong>IMPORTANT NOTE:</strong> Any time you are working within the Franchise spreadsheets, only make edits on the "Franchises" and "Entry Lists" tabs. The "Standings" tab will automatically update based off the information in the other tabs.

Cmott: /* Overview */

2025-04-01T04:03:48Z

Overview

← Older revision		Revision as of 04:03, 1 April 2025
Line 5:		Line 5:
	*Google Drive Access		*Google Drive Access

	== ~~Overview~~ ==		== Procedure ==
	Crown Jewel Racing uses a combination of two systems to track driver's and owner's points. SimRacerHub is used to track driver's points, and a manual spreadsheet is used to track owner's points. Points are tracked differently depending on the series, so make sure to pay attention to series specific instructions.		Crown Jewel Racing uses a combination of two systems to track driver's and owner's points. SimRacerHub is used to track driver's points, and a manual spreadsheet is used to track owner's points. Points are tracked differently depending on the series, so make sure to pay attention to series specific instructions.

Cmott at 04:03, 1 April 2025

2025-04-01T04:03:25Z

← Older revision		Revision as of 04:03, 1 April 2025
Line 42:		Line 42:

	#Navigate to the spreadsheet for the division you are updating from the table above.		#Navigate to the spreadsheet for the division you are updating from the table above.
			#Find the column for the race that you are updating.
			#*Starting with first place, input the total points earned for each franchise (by car number) from the SimRacerHub Race Results page.
			#For all cars that miss a race, leave the cell for that car blank and fill it with a red background.
			#Make sure to double check that all points have been input correctly for each franchise. It is a good idea to have another admin double check your work to ensure this is done correctly to avoid issues later in the season.

			=== Invalidating Driver Points ===
			Drivers who are not eligible for points in a specific series may still be participating in a race in the various divisions. These drivers need to have their points invalidated once the Owner's Standings are updated. Follow the process below to complete this:

			#Ensure that Owner's Points are input correctly as once you begin this step, you will have to start the process over in order to update the Owner's Standings any further for a race.
			#Using the entry list for the race, locate all drivers that are ineligible for Driver's points in the series (indicated by a "(i)" next to their name).
			#For each ineligible driver, edit their race points using the pencil next to the point values and change them to 0.
			#*If a driver earned stage points, they can be invalidated by scrolling down to the stage and editing the value to 0.
			#Verify that all ineligible drivers listed on the entry form have 0 points.

			=== Notify Drivers ===
			When all points are updated, post an announcement in the #league-announcements channel in the Discord server and tag the relevant league drivers and owners (@Cup Driver / @Cup Owner, etc.).

Cmott at 03:49, 1 April 2025

2025-04-01T03:49:34Z

← Older revision		Revision as of 03:49, 1 April 2025
Line 39:		Line 39:
	<strong>IMPORTANT NOTE:</strong> Any time you are working within the Franchise spreadsheets, only make edits on the "Franchises" and "Entry Lists" tabs. The "Standings" tab will automatically update based off the information in the other tabs.		<strong>IMPORTANT NOTE:</strong> Any time you are working within the Franchise spreadsheets, only make edits on the "Franchises" and "Entry Lists" tabs. The "Standings" tab will automatically update based off the information in the other tabs.

	==== Updating		==== Updating Owner's Points ====

			#Navigate to the spreadsheet for the division you are updating from the table above.

Cmott at 03:34, 1 April 2025

2025-04-01T03:34:12Z

← Older revision		Revision as of 03:34, 1 April 2025
Line 16:		Line 16:
	#Select the league in which you are updating and navigate to the schedule.		#Select the league in which you are updating and navigate to the schedule.
	#*''League'' > ''Season''		#*''League'' > ''Season''
	#Under the race you are uploading, look in the furthest ~~left~~ column for labeled "ADMIN". Listed in the Admin box of the race will be a green arrow labeled "Upload Race Results" - click the arrow to continue.		#Under the race you are uploading, look in the furthest right column for labeled "ADMIN". Listed in the Admin box of the race will be a green arrow labeled "Upload Race Results" - click the arrow to continue.
	#Select the iRacing League and Season under the dropdowns listed. Under Sessions, click "Select All" and verify the correct points scheme is selected for the race.		#Select the iRacing League and Season under the dropdowns listed. Under Sessions, click "Select All" and verify the correct points scheme is selected for the race.
	#*If the race had stages, ensure to add the stages using the "Add Stage" button and select the correct points scheme.		#*If the race had stages, ensure to add the stages using the "Add Stage" button and select the correct points scheme.
Line 38:		Line 38:

	<strong>IMPORTANT NOTE:</strong> Any time you are working within the Franchise spreadsheets, only make edits on the "Franchises" and "Entry Lists" tabs. The "Standings" tab will automatically update based off the information in the other tabs.		<strong>IMPORTANT NOTE:</strong> Any time you are working within the Franchise spreadsheets, only make edits on the "Franchises" and "Entry Lists" tabs. The "Standings" tab will automatically update based off the information in the other tabs.

			==== Updating

Cmott: Created page with "== Required Permissions == The following permissions are required to complete the following task: SimRacerHub Administrator Google Drive Access == Overview == Crown Jewel Racing uses a combination of two systems to track driver's and owner's points. SimRacerHub is used to track driver's points, and a manual spreadsheet is used to track owner's points. Points are tracked differently depending on the series, so make sure to pay attention to series specific instructions..."

2025-04-01T03:32:16Z

Created page with "== Required Permissions == The following permissions are required to complete the following task: *SimRacerHub Administrator *Google Drive Access == Overview == Crown Jewel Racing uses a combination of two systems to track driver's and owner's points. SimRacerHub is used to track driver's points, and a manual spreadsheet is used to track owner's points. Points are tracked differently depending on the series, so make sure to pay attention to series specific instructions..."

New page

== Required Permissions ==
The following permissions are required to complete the following task:

*SimRacerHub Administrator
*Google Drive Access

== Overview ==
Crown Jewel Racing uses a combination of two systems to track driver's and owner's points. SimRacerHub is used to track driver's points, and a manual spreadsheet is used to track owner's points. Points are tracked differently depending on the series, so make sure to pay attention to series specific instructions.

=== Upload Race Results ===

#Log into [https://simracerhub.com/index.php?welcome=y SimRacerHub]
#*Admin > Admin Login
#Navigate to Crown Jewel Racing
#*Admin > My Leagues > Crown Jewel Racing
#Select the league in which you are updating and navigate to the schedule.
#*''League'' > ''Season''
#Under the race you are uploading, look in the furthest left column for labeled "ADMIN". Listed in the Admin box of the race will be a green arrow labeled "Upload Race Results" - click the arrow to continue.
#Select the iRacing League and Season under the dropdowns listed. Under Sessions, click "Select All" and verify the correct points scheme is selected for the race.
#*If the race had stages, ensure to add the stages using the "Add Stage" button and select the correct points scheme.
#**<strong>If a stage ended early, ensure the "End Lap" field is the lap that the caution came out on. SimRacerHub will automatically pull the running order at the time of caution. It is encouraged to manually review this via the broadcast or replay file.</strong>
#Verify the information is correct in all fields and click "Import Results" to finalize the results.

=== Owner's Points ===
Owner's points are tracked manually using the Franchise spreadsheets. Select the correct spreadsheet from the table below to begin updating the Owner's points:

{| class="wikitable" style:"margin:auto"
|+ Franchise Spreadsheets
|-
! Division !! Spreadsheet
|-
| Cup Series || [https://docs.google.com/spreadsheets/d/1L1vhVdfyl6iwvp3ZwIJGg9fSW9J7AHQwPjsqC2_GZDM/edit?usp=sharing Cup Franchises & Owner Standings]
|-
| Xfinity Series || [https://docs.google.com/spreadsheets/d/17ZRZEeUBpDsZ54IAPABzsCUHmd2rwPE8bIpUNhhEwE0/edit?usp=sharing Xfinity Franchises & Owner Standings]
|-
| Truck Series || [https://docs.google.com/spreadsheets/d/1Zy-gcpK0qyag_bvtD3niAaFXIgPYvJ8USX53g_B4LiQ/edit?usp=sharing Truck Franchises & Owner Standings]
|}

<strong>IMPORTANT NOTE:</strong> Any time you are working within the Franchise spreadsheets, only make edits on the "Franchises" and "Entry Lists" tabs. The "Standings" tab will automatically update based off the information in the other tabs.