--- title: K1 K1RS/RPM Reset description: Clubspeed Customer Knowledge Center --- [Skip to content](https://help.clubspeed.com/clubspeed-knowledge-center/k1-k1rs/rpm-reset#main-content) English Show submenu for translations [More support](https://help.clubspeed.com/clubspeed-knowledge-center/kb-tickets/new?hsLang=en) [![Clubspeed Logo](https://help.clubspeed.com/hs-fs/hubfs/Logo_Grey.png?width=500&height=86&name=Logo_Grey.png)](https://help.clubspeed.com/clubspeed-knowledge-center?hsLang=en) Open main navigation Close main navigation - English Show submenu for translations - [More support](https://help.clubspeed.com/clubspeed-knowledge-center/kb-tickets/new) - [Contact us](https://share.hsforms.com/1B5QyPF-YRQutaoGEnmQD5w1etz6) [Contact us](https://share.hsforms.com/1B5QyPF-YRQutaoGEnmQD5w1etz6) How can we help you? - There are no suggestions because the search field is empty. 1. [Clubspeed Customer Knowledge Center](https://help.clubspeed.com/clubspeed-knowledge-center?hsLang=en) December 6, 2024 # K1 K1RS/RPM Reset Search ### K1 K1RS/RPM Reset **Overview** Each year, K1 Speed resets their RPM (they call it K1 Race Score/K1RS) back to 1200 on January 1 at midnight. This procedure ensures that all locations are finished replicating their data to the other locations and then resets the RPM/K1RS back to 1200.  **Step 1: Ensure Replication is Complete at All K1 Locations** **If rows are returned that are recent**, run replication manually by double clicking C:\\ClubSpeed\\cs\_replication\\cs\_replication.exe. The launches and runs in the background. It takes about 10-15min to complete. You may look in Processes to see it active. It also logs into C:\\ClubSpeed\\cs\_replication\\logs. **If rows are returned that are NOT recent or the replication is otherwise stuck**, you can forcefully mark data as having been replicated. Make a note of the IDs that are stuck for later investigation and to ensure that the results of the top 250 are not impacted. Note the highest ID that you would like to mark as "replicated" and run this query, replacing *123456* with your ID number: **Step 2: Backup/Reset RPM/K1RS (After Step 1 is Done at ALL Locations)** **Only perform these steps after the TriggerLogs table at all K1 locations do not return any rows eligible for replication. If this is not the case, replication will overwrite the RPM scores that you reset below.** 1. Backup Customers table: ``` SELECT CustID, RPM, Fname, Lname, Address, Address2, City, State, Zip, EmailAddress, PhoneNumber, PhoneNumber2 INTO RPM_Backup_2015 FROM Customers ``` 2. Reset all RPMs to 1200: ``` UPDATE Customers SET RPM = 1200 ``` **Step 3: Verify the Reset** To verify that the scores have been reset, visit the top RPM page at each location: [http://k1sacramento.clubspeedtiming.com/sp\_center/SpeedLimit.aspx](http://k1sacramento.clubspeedtiming.com/sp_center/SpeedLimit.aspx) **How to Pull Top 250 RPM/K1RS Scores** This can be done from one location if replication is in sync. It will calculate from the table backup made in Step 2.1.   Once the query is run, save the results to CSV. It is helpful to spot check several locations to verify that replication was indeed working. - - - - ### Related Articles - [FAQs](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#main-content) - [Software Questions](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#software-questions) - [Payments Questions](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#payments-questions) - [Getting started](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#main-content) - [Clubspeed](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#clubspeed) - [Administration](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#administration) - [Product Setup](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#product-setup) - [Customer Experience](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#customer-experience) - [Race Control](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#race-control) - [Manager Controls](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#manager-controls) - [Point of Sale Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#point-of-sale-operations) - [Venue Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#venue-operations) - [Race Control Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#race-control-operations) - [Event Calendar](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#event-calendar) - [Open & Closing Shifts](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#open-closing-shifts) - [Activity Setup (FEC Non Karting)](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#activity-setup-fec-non-karting) - [Kart Focused](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#kart-focused) - [Troubleshooting](https://help.clubspeed.com/clubspeed-knowledge-center/troubleshooting?hsLang=en#main-content) - [networking](https://help.clubspeed.com/clubspeed-knowledge-center/troubleshooting?hsLang=en#networking) - [General](https://help.clubspeed.com/clubspeed-knowledge-center/general?hsLang=en) - [Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reports?hsLang=en#main-content) - [Gift Cards](https://help.clubspeed.com/clubspeed-knowledge-center/reports?hsLang=en#gift-cards) - [Integrations](https://help.clubspeed.com/clubspeed-knowledge-center/integrations?hsLang=en) - [Payments](https://help.clubspeed.com/clubspeed-knowledge-center/payments?hsLang=en) - [Email and Text Messaging](https://help.clubspeed.com/clubspeed-knowledge-center/email-and-text-messaging?hsLang=en) - [Item Management](https://help.clubspeed.com/clubspeed-knowledge-center/item-management?hsLang=en) - [Resources](https://help.clubspeed.com/clubspeed-knowledge-center/resources?hsLang=en) - [Calendar Management](https://help.clubspeed.com/clubspeed-knowledge-center/calendar-management?hsLang=en) - [Customer Management](https://help.clubspeed.com/clubspeed-knowledge-center/customer-management?hsLang=en) - [Promotions and Marketing](https://help.clubspeed.com/clubspeed-knowledge-center/promotions-and-marketing?hsLang=en) - [Updates](https://help.clubspeed.com/clubspeed-knowledge-center/updates?hsLang=en#main-content) - [Release Notes](https://help.clubspeed.com/clubspeed-knowledge-center/updates?hsLang=en#release-notes) - [Registration](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#main-content) - [Setting up Your Registration](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#setting-up-your-registration) - [iPads](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#ipads) - [Products](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#main-content) - [Business Additions](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#business-additions) - [Extra Tips & Tricks](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#extra-tips-tricks) - [Setup](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#setup) - [Point of Sale](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#point-of-sale) - [Barcode](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#barcode) - [Activities](https://help.clubspeed.com/clubspeed-knowledge-center/activities?hsLang=en#main-content) - [Activity Operations](https://help.clubspeed.com/clubspeed-knowledge-center/activities?hsLang=en#activity-operations) - [Reporting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#main-content) - [Sales Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#sales-reports) - [Operational Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#operational-reports) - [Labor Report](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#labor-report) - [Accounting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#accounting) - [Race Operations](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#race-operations) - [Quickbooks Online](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#quickbooks-online) - [Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#main-content) - [Setup - Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#setup-club-booking) - [Operations](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#operations) - [Booking Manager](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#booking-manager) - [Bonus Material - Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#bonus-material-club-booking) - [Operational Flows](https://help.clubspeed.com/clubspeed-knowledge-center/operational-flows?hsLang=en) - [Food & Beverage](https://help.clubspeed.com/clubspeed-knowledge-center/food-beverage?hsLang=en) - [Speed Screen Displays](https://help.clubspeed.com/clubspeed-knowledge-center/speed-screen-displays?hsLang=en) - [Garage](https://help.clubspeed.com/clubspeed-knowledge-center/garage?hsLang=en) - [Support Task](https://help.clubspeed.com/clubspeed-knowledge-center/support-task?hsLang=en) - [Webinar](https://help.clubspeed.com/clubspeed-knowledge-center/webinar?hsLang=en) - [Playbook](https://help.clubspeed.com/clubspeed-knowledge-center/playbook?hsLang=en) [![2022-clubspeed-newsletter-header-logo](https://help.clubspeed.com/hs-fs/hubfs/2022-clubspeed-newsletter-header-logo.png?width=240&height=42&name=2022-clubspeed-newsletter-header-logo.png "2022-clubspeed-newsletter-header-logo")](https://help.clubspeed.com/?hsLang=en) Copyright © 2024, Club Speed, LLC