TypeRacer News

TypeRacer Update 2021 What’s Been Happening? Dark Mode, Universes, Private Tracks, Enhancements More to Come…

Posted on September 24, 2021. Filed under: TypeRacer News |

TypeRacer Dark Mode Feb 2021

Hello Typists! We have come a long way with TypeRacer since our last update and still going strong. We’ve been listening and hearing your feedback all this time. We take all feedback into consideration when working on the site. Here are the most notable changes since. We will continue to develop TypeRacer, making it the greatest multiplayer typing site.

🎨 New facelift + Dark Mode (finally)

We’ve given TypeRacer a huge facelift as of last year and we’re still adjusting it as we go. One of many of our biggest achievements to finally modernize TypeRacer and include a native Dark mode.

Dark mode was the most requested feature with TypeRacer and we can proudly say that it is available to everyone. You can continue to play on TypeRacer while saving your eyes. You’re welcome.

Image
New TypeRacer Userbar Aug 2021

New Userbar Information

Our most recent addition as of August 2021, we gave the userbar information (the info panel on the top-right) a facelift that gives this a more clean look than it once was to display your stats and information neatly.




🌌 Official Public Universes – Different TypeRacer Gamemodes and Themes!

TypeRacer Universe Themes

With the introduction of the new theme, we’ve included a “Featured Universes” section on our site that highlights the most interesting and unique universes that you can play on. “Universes” are sub-sections of TypeRacer with separated leaderboards, stats, theme, and texts.

One of the most popular Universes on TypeRacer is the “Dictionary” gamemode, which includes randomized words from the English dictionary to type from. We also have different themes of content to type from on universes, such as the “Anime” universe where you can type quotes from your favorite anime and manga series such as Tokyo Ghoul to Attack on Titan.

🏁 New Private Racetrack Upgrades – Up to 200 players maximum and chat commands!

Private Racetracks have been upgraded to support up to 200 players at once in a race to allow for some interesting games, especially to have fun with larger groups and streamers to play with the audiences.

Large TypeRacer Racetrack with over 120+ players

Commands

Certain chat messages prefixed with a double slash are now interpreted as commands that can be executed by the racetrack’s creator. The following commands allow viewing or modifying the current racetrack’s settings and adding or removing bots.

Configuration commands:

The //set <property> <new value> command can be used to view or change the value of a configurable racetrack setting. Without a <new value>, it simply prints the current value of the given <property>.

The following settings are configurable with this command:

//set maxPlayers <2-300?>

Sets the maximum players allowed in the current racetrack (which includes both racers and spectators).

//set maxPlayersPerGame <2-300?>

Sets the maximum players allowed to join in a race.

//set newGameDelaySeconds <10-600?>

Sets how long to keep displaying an ended race in the UI before starting a new one (specified in seconds).

Bot commands:

//addbot <wpm1> <wpm2> <wpm3>

Adds one or more bots. Can specify multiple speeds, each speed adds a bot.

//addbots <number> <avgWpm?>

Adds number of bots with the given average speed. The speed parameter is optional; if omitted, it defaults to the average speed for the track creator’s skill level.

//removebots

Removes all bots.

Other commands:

//help

Prints info about how to use the most common commands. For now, only the //set commands are documented there.

More to Come

TypeRacer is always expanding and innovating! Do you have ideas or feedback for TypeRacer? Please feel free to come chat in our official Discord server @ https://discord.gg/typeracer or feel free to send us an email support[at]typeracer.com.

Have a great rest of the year, cheers to all. See you on the track. – Jon Lachney (jlachney)

Read Full Post | Make a Comment ( None so far )

New English Texts Added February 2020 & and Purge of Unpopular Texts

Posted on February 25, 2020. Filed under: TypeRacer News |

 

Hey Typists! 

Have you ever ragequit a TypeRacer race after taking one look at the race text? 

 

 

What the tarnation is that? I can’t type this!

We want to make sure you’re enjoying the content on TypeRacer, so we’re taking this opportunity to purge the most hated texts — and we’re asking the community to vote on which texts have got to go. See the next section for info on how to participate.

While we’re removing texts, we’re also adding new ones. We’ve also activated ~150 user-submitted texts from our submission form into the main track, bringing TypeRacer to ~6,500 English texts total. If you’re interested in recommending your favorite content, feel free to submit them via this form

Please make sure you carefully follow the guidelines outlined on the form; you may see your submission in the next batch!

Special thanks to our text managers for painstakingly reviewing and curating the list of user-submitted texts; these dedicated users have also continuously supported on moderation, making TypeRacer the best-moderated typing site on the net.

Andreaak00JosasimKeeganTPoemShoemaker-Levy-9Styrofoamppentalon & timjeffery44

How you can participate

You can come join us and the rest of the community on the official TypeRacer Discord where we’re listening to user feedback 24/7. We have various channels dedicated to collecting feedback on the website, as well as on texts specifically. 

Enter our #text-voting channel to vote on candidates for new texts, and purge recommendations.

Vote by right clicking a message and using the 👍 / 👎 reactions to make your voice heard.

:mag_right: Where can I find a text ID?

You can find the text ID of any text on the Pit Stop here — https://data.typeracer.com/pit/texts — by searching for the first few words (or other keywords) in the content you’re looking for. You can also use TypeRacerData to find a variety of information and stats about texts on TypeRacer: http://typeracerdata.com/texts

:x: What will happen to purged texts?

You will still be able to find “purged” texts by searching the TypeRacer Texts Database , and you’ll still be able to use the “ghost race” feature to race on this content if you want to. Premium users can also save these ghost races. However, after being purged, texts will no longer show up in the main track, so they will only be kept around for people who really want to race them.

You can view the status of the “purge” in this spreadsheet. Check out the “Text Purge” Sheet. https://docs.google.com/spreadsheets/d/1S8K530n-JLBkD20wUvAw71QFBz76bWfxcuGtYehunaM/edit?usp=sharing

Texts submitted in February 2020’s batch are from the following users and have been activated.

21yanka1, Aerosmith727, Ducktypist, KeeganT, Lulzwagon, NOTMystik_, Xernious, aji3, chakk, charlieog, deluxemoons, josasim, jsilvers27, jupxters, loboru, mxmoon, pastashapes, poem, rocketjuice, solarscopez, styrofoamp, timjeffery44, veggiemans, vlaki007, volhosis

See y’all on the track! — Jon Lachney (jlachneyTRData)

 

Read Full Post | Make a Comment ( 1 so far )

TypeRacer Security Reminder

Posted on January 6, 2020. Filed under: TypeRacer News |

💬 Chat with other typists in the official TypeRacer Discord!

Discord

Hi TypeRacers:

Recently there have been several cases of TypeRacer users’ accounts being compromised; the accounts were subsequently used for cheating on TypeRacer, spamming/profanity, and other undesirable behavior. Some were banned as a result. In response, this blog post is a quick public service announcement — and a quick reminder about best practices in online security.

In investigating the recent cases, TypeRacer staff spoke with some of the impacted users, who acknowledged their practice of re-using passwords and even username+password combinations across multiple websites. In other cases, our moderation team actually identified usernames/passwords of the impacted users in publicly-available data dumps online (following a security breach on a third-party site unrelated to TypeRacer). This means that anyone with enough time on their hands (without any “hacking” skills) could literally look up the victim’s publicly-available passwords and log directly into the victim’s TypeRacer account. 

So, fellow typists: if you care about your TypeRacer account at all, please use a unique password!

David (valikor)

P.S. If you’re in the habit of reusing the same password on different websites, there are several useful tools that let you check if your data has been compromised in a security breach:

https://haveibeenpwned.com/

https://monitor.firefox.com/

Click here to update your password.

This is where you can update your password.

Read Full Post | Make a Comment ( 1 so far )

TypeRacer for Kids – October 2019 Update

Posted on October 28, 2019. Filed under: TypeRacer News, Universes |

Hey teachers and students!

We’re expanding TypeRacer for Kids with new content carefully curated for educational contexts. This month we added new texts from books earning the ALSC’s Caldecott Medal, Newbery Medal, and other Honor Books. You can access the 100%-free educational typing environment here: http://play.typeracer.com/?universe=education

🏫 New Content – TypeRacer for Kids

index

Some of the selections included in October’s update.

This month, we’ve added texts from the following books:

One of our favorites here on TypeRacer is Alma and How She Got Her Name. Alma, the main character, is puzzled about why she has so many names that don’t seem to fit her. It’s a tale of self-exploration and understanding one’s roots, and through her father, she comes to appreciate the traditions of her ancestors that gave birth to her long name. What seemed so weird to her actually fits her perfectly and connects her to her precious heritage.

We hope students love improving their typing speed on age-appropriate and engaging content! For more information about TypeRacer for Kids, please read our previous blog post.

🍎 Teachers – you can contribute, too!

This is a new offering. Please let us know your feedback so that we can continue to make improvements. If there is content that you use with your students and want to see on TypeRacer for Kids, feel free to recommend it to us. You can contact us at education [at] typeracer.com.

Read Full Post | Make a Comment ( 1 so far )

New English Texts Added – September 2019

Posted on September 7, 2019. Filed under: TypeRacer News |

💬 Chat with other typists in the official TypeRacer Discord!

Discord

We’ve reviewed and collected your text submissions this past week, with ~250 new English texts activated and ready to be typed! The “play” universe has now officially reached 6,200+ unique texts.

Special thanks go to Styro (styrofoamTRData), JGG (jgg_im_bad TRData), and Keegan (keegant TRData) — from our team of our dedicated Text Managers –  for reviewing hundreds of user-submitted quotes.

💡 We’re listening to feedback!

Corrections of the texts such as typographical errors and non-typeable characters have been implemented across a variety of languages based on user feedback. See a problem? Email support [at] typeracer.com, or head to our Discord. We read 100% of messages shared in the #feedback channel, and also have a #new-text-discussion channel dedicated to the content additions in any language. As always, we hope you enjoy the new content.

📝 Want to contribute?

Do you want to type your favorite quotes on TypeRacer? Everyone can send in submissions! Just click on the “Contribute” button at the bottom of the page and fill out the form. Please fill out the form carefully and completely, including a valid ISBN-10 or ASIN for all English content. You can find ASIN or ISBN-10 numbers by scrolling down on the Amazon product page for any book/movie/etc. and checking the “Product details“.

Note that typos and formatting issues will generally result in your submission being rejected.

6WXSi

Thanks to all users whose content submissions were activated in the batch!

You can see the new content, and the users who submitted and reviewed them, in this public spreadsheet. Feel free to save a copy to your Google Drive and filter for Status: Activated 9/2/2019.

Read Full Post | Make a Comment ( 1 so far )

Introducing TypeRacer for Kids – a free, educational TypeRacing experience

Posted on August 31, 2019. Filed under: TypeRacer News, Universes |

To celebrate the back-to-school season, TypeRacer is announcing TypeRacer for Kids. It’s the same as the classic, public TypeRacer environment you’re familiar with, but with its own texts, high scores, and unique URL. Most importantly, the carefully-curated race content is optimized for educational contexts with students 14-years-old and below, e.g. classrooms, homeschooling, computer camps, etc.

It’s available here: http://play.typeracer.com/?universe=education 

🏫 What’s inside?

Some of the selections included in TypeRacer for Kids.

TypeRacer for Kids is loaded exclusively with  educational texts from the ASLC’s notable children’s book lists. The ASLC is a division of the American Library Association, and each book has been carefully selected as having “especially commendable quality, books that exhibit venturesome creativity, and books of fiction, information, poetry and pictures for all age levels (birth through age 14) that reflect and encourage children’s interests in exemplary ways.”

 

🌌 How is this different from “TypeRacer for Schools”?

TypeRacer for Schools is a paid product which affords teachers full control over their students’ typing — from controlling access to their private universe, and customizing every text their students type. It’s also 100% ad-free and optimized for student privacy. Click here for more info.

TypeRacer for Kids is a free, ad-supported environment which is accessible to anyone on the internet. Each race text is optimized for kids — being age-appropriate and bolstering educational value.

 

🙋 Other FAQs

❓I’m a TypeRacer for Schools customer. Can I use texts from TypeRacer for Kids?

Sure! Shoot us an email at education [at] typeracer [dot] com and we’ll help you set it up.

❓There are users with inappropriate usernames/profile pictures in the TypeRacer for Kids environment! Can you help? 

Because TypeRacer for Kids is a free, publicly-available environment, we cannot guarantee bad guys don’t get in. For a fully private environment, you can consider TypeRacer for Schools.

However, you can right-click and “report” offensive users. Our moderation team will address it as soon as possible.

❓I have some content I’d love to see in TypeRacer for Kids. Can I recommend it?

Sure! Please click the “Contribute” link at the bottom of the main TypeRacer page and fill out the form with your favorite content. Note that we’re currently only accepting award-winning content from American Library Association’s children’s book lists. After submission, please shoot us an email letting us know which list(s) your content is from.

Read Full Post | Make a Comment ( None so far )

New English Texts Added – May 2019

Posted on May 27, 2019. Filed under: TypeRacer News, Universes |

💬 Chat with other typists in the official TypeRacer Discord!

Discord

We’ve reviewed and collected your text submissions this month, with ~150 new English texts activated and ready to be typed! The “play” universe has now officially reached 6,000 unique texts.

Special thanks go to Styro (styrofoamTRData) and JGG (jgg_im_bad TRData) for reviewing hundreds of user-submitted quotes, as well as Pentalon (pentalon TRData) for managing recent user feedback and corrections.

💡 We’re listening to feedback!

Corrections of the texts such as typographical errors and non-typeable characters have been implemented across a variety of languages based on user feedback. See a problem? Email support [at] typeracer.com, or head to our Discord. We read 100% of messages shared in the #feedback channel, and also have #new-text-discussion, channel dedicated to discussion round new content in any language. As always, we hope you enjoy the new content.

📝 Want to contribute?

Do you want to type your favorite quotes on TypeRacer? We’re encouraging everyone to send in submissions! Just click on the “Contribute” button at the bottom of the page to submit any content (in any language). Typos and formatting issues will generally result in your submission being denied. Remember, only complete submissions will be considered, including a valid ISBN-10 or ASIN number for all English content. You can find ASIN or ISBN-10 numbers by scrolling down on the Amazon product page for any book/movie/etc. and checking the “Product details“.

6WXSi

Thanks to these users whose content submissions were activated in the batch:

musashiaharon, baited, doodled, volhosis, Purple_love, viggojohansen, robodude22, kido2976, mysticaleevee, tkpwaeub, LeCleric, terrible_typist, Eruannion, plorksauce, trickroom, ashbygeek, mattbierwirth, newchip35, rom10cort, Tayloryams, joeborez79, lilblukat, aaronadams, dragoness_lily, lion2509, 4beth_esda, mxlxdx, jgg_im_bad, hyper_racer, lunardrift, teiloq, styrofoam, Mavanore, Jazzanaih, ridlzz1, aji3, timjeffery44, KeeganT, h0nny, joshybigmac, ciaerwinbtanpiengco, ambizzle, svt17, toowanjeon, delawarelights, chakk, baconhawka7x, lewist, and BioLlama112.

Read Full Post | Make a Comment ( 3 so far )

New English and International Texts – Apr. 2019

Posted on April 14, 2019. Filed under: TypeRacer News, Universes |

Chat with other typists on the TypeRacer Discord chat!

Over the past couple weeks we activated a bunch of new content on TypeRacer. In English, there’s a total of ~250 new user-submitted English quotes, bringing the total number of English quotes in the main “play” universe up to 5,900. A special thanks goes to Styro (styrofoam – TRData) and JGG (jgg_im_bad – TRData) for reviewing hundreds of user-submitted quotes here, as well as Pentalon (pentalonTRData) for curating a list of high quality content activated last week.

If you see your name at the bottom of this post, at least one quote you’ve contributed is now active, and the user-submitted quotes spreadsheet above will help you see which of your submissions were accepted.

TypeRacer International also continues to move forward. We recently added:

Corrections to texts (typographical errors, non-typeable characters) have been implemented across a variety of languages, based on user feedback. See a problem? Email support [at] typeracer.com, or head to our Discord. We read 100% of messages shared in the #feedback channel, and also have #new-text-discussion channel dedicated to discussion around new content in any language.

As always, we hope you enjoy the new content, and we encourage everyone to click the Contribute link at the bottom of the main TypeRacer page to submit the content you want to type on TypeRacer (in any language). As a reminder, only complete submissions can be considered (including a valid ISBN-10 or ASIN number for all English content). Typos and formatting issues will generally result in your submission being denied.

Thanks to everyone who contributed! See you on the racetrack.

David (valikor – TRData)

 

Users whose content submissions were activated in this batch:

23bmoney23
aaronadams
abigail_w
aji3
akgabe
alstr
arielhsu2011
Aryore
atthetop
Avanier
awesomerly
BenyoBoy
bhuyquang1
blade5468
bookaddict13
boydkeizer
cdbriggs
chakk
ciaerwinbtanpiengco
cws2002
Cymek
Dauxsis
doodled
dr_gammaray
erono
estevaoima
ethbomb
Favidavid
FlyingAce
foggyy
Fusion035
Garvin Lim
guccigraain
iamvariant
jack_ery
jgg_im_bad
Jody
johanliebert
josh924
jostwiththemost
loltyger1
m7anfash
mattbierwirth
MrBumblepants
myle_7894
Polyatomic
ppubalo
ryuzakisultan
sigma_phi_delta
skylos
SlagTheRisen
slickserpent99
specialized
spu-qwerty
styrofoam
timjeffery44
trickroom
volhosis
xKDxx

 

Read Full Post | Make a Comment ( 3 so far )

New Texts – Feb. 2019

Posted on February 13, 2019. Filed under: TypeRacer News |

Chat with other typists on the TypeRacer Discord chat!

Last week we activated a new batch of 200 user-submitted English quotes on TypeRacer, bringing the total number of English quotes in the main “play” universe up to 5,645. A special thanks goes to Keegan (keegantTRData) and Jon (jlachneyTRData) for reviewing hundreds of user-submitted quotes here (large spreadsheet – scroll down to the bottom!)

To see all newly-added quotes in one place, check out TypeRacerData.com’s texts page sorted by “Active Since” date; this batch will show up at the bottom of the page, with “active since” dates of Feb-1 or Feb-2.

You can also save a copy of the spreadsheet above to your Google Drive and filter for STATUS: Added: Live: February 1, 2019. If you see your name at the bottom of this post, at least one quote you’ve contributed is now active, and the spreadsheet will help you see which of your submissions were accepted.

Here’s a small preview of some of the cool new content added to TypeRacer:

  • Hacking: The Art of Exploitation, a book by Jon Erickson
  • Dead by Daylight, a game by Behavior Interactive
  • Subterranean Homesick Alien, a song by Radiohead
  • The History of the Decline and Fall of the Roman Empire, a book by Edward Gibbon
  • How It Feels to Fly, a song by Alicia Keys
  • Bohemian Archive in Japanese Red, a book by ZUN
  • Earth to Echo, a movie by Dave Green
  • Made in Abyss, a comic book by Tukushi Akihito
  • Deltarune, a game by Toby Fox
  • What If?: Serious Scientific Answers to Absurd Hypothetical Questions, a book by Randall Munroe

As always, we hope you enjoy the new content, and we encourage everyone to click the Contribute link at the bottom of the main TypeRacer page to submit the content you want to type on TypeRacer. As a heads-up, only complete submissions can be considered (including a valid ISBN10 or ASIN number) and any typos or other issues will generally result in your submission being denied.

♕ David ♕ (valikor – TRData)

 

 

Users whose submissions were included in today’s update:

185157
_warrior_
aaronadams
adnanli
aji3
an3223
batfishtyperacer
Baxlyy
bhuyquang1
boombadabing
broccoliboys
chakk
charlieog
coffeesan
colonelclean
creepycat18_YT
CustardGod
czarliethegreat
d4tsoldiersaspy
dnatrixene135
douglasawesome
emmett95
etherealfog
foggyy
Fusion035
g0oni3
goddessofsass
gourd
guldan
honen
hyper_racer
jackrwoods
jeanrondel234
jgg_im_bad
jonathanshea
JuliusSW
jyin
keegant
KefkaP
KimotoNari
Kuruminha
laralex
linghaosmith
lordfarquaad
MankoGaDaisuki
mavenz
MaxisWJ
Memor123
mispelled
ntpofficial
nullatrum
OppaiBuster
pekoraali
phelistein
plorksauce
Promestein
QueenMaxine
qwright10
Raphaeltype
raven6
realer
RNarKy
roman_n
Saphndulc123
SharBurrus
Shasta20
sidd_
SomehowScarlet
styrofoam
tanuki73
thakim1003
theassassin201
TheBluestBerry
TheCornhobble
theengi321
timjeffery44
Timmity
tkpwaeub
tomato_head
Tycru
typeASDFracer
VahNabooty
viellain
volhosis
Voyager105
wllls
x7universe
yaboimlg
zrod1851
zzavakos

Read Full Post | Make a Comment ( None so far )

2018 Competition Results – Are you in the top-25,000?

Posted on January 27, 2019. Filed under: Contests, Stats, TypeRacer News |

Join to the TypeRacer Discord chat  where you can meet many of the best typists in the world!

The year 2018 has come to an end. Today we’re announcing winners of the 2018 Yearly competition.

Congrats to Belinda (wordracer888 – TRData), Michael (deroche1 – TRData), and Shoemaker (atthetopTRData) for taking the top-3 in both points and races completed. These guys completed around 50,000+ races each in 2018 alone!

Congrats to Henry (ghosthenryzhouTRData), Waleed (arxanasTRData), and Izzy (izzy5468TRData) for taking the top spots for averageWPM. These guys, among the fastest typists in the world, achieved an average speed of 200+ wpm on at least one of their accounts. (Note that premium racers can save practice or “ghost” races, giving them an advantage over free users and helping achieve these unbelievable speeds; additionally, Arxanas is a Steno typist).

The blog post below contains some highlights of the 2018 competition statistics, as well as a number of links to larger data sets. Us “normal” folks might not see ourselves in the blog post below, but check out the stats for your country to see where you stand!

If you did more than 110+ races or averaged more than 75+wpm during 2018, you should be able to find yourself as a top player in your country! Check out the links below.

Prizes will be announced soon.

Points/Speed/# of Races – Worldwide TypeRacer Champions

Leaders in “points”, “avgWPM”, and “nRaces”. Click the picture to expand to the top-500 in each category (Google Sheets). The cutoff for inclusion in the top-500 is 224,000+ points, 130+ wpm average, or 3100+ races in 2018.

 

2018 Champions by Country – Points/Speed/# of Races

Veteran racers will know that the Pit Stop Competitions results page shows a maximum of the top-100, and on a site with millions of typists, even if you’re a talented and dedicated typist, chances are you didn’t make the cut.

To recognize more typists, and let people know how their 2018 performance stands, we crunched the numbers for three key categories, breaking the results down by country.

Note: Find your country by choosing the corresponding sheet at the bottom of each spreadsheet linked below. 

(1) points leaders by country – (speed * characters typed); (Google sheets – Click here to find yourself!)

(2) WPM leaders by country; (Google sheets – Click here to find yourself!) and;

(3) races completed leaders by country; (Google sheets – Click here to find yourself!)

The points category is broken down by country for TypeRacer’s top-35 countries (by points); averageWPM and nRaces are broken down by country for TypeRacer’s top-15 countries. If you’re from a smaller country, you’ll need to check the bottom of this post to see how to see the stats for your country.

The leaders from TypeRacer’s big-5 countries are below.

Top-25 Points Champions in the Top-5 Countries

#1 US 

#2 Canada

#3 Australia

#4 India 

#5 UK

Top Countries by Points

On the topic of top countries, here are the top-25 countries by points (click the image to see top-100).

 

Notes

  • The results in this post have been generated based on a list of the top-50k racers by points. The raw data is linked below (Google Sheets) and stats enthusiasts can feel free to manipulate the data in whatever way they wish.
  • The files are quite large.

Raw data: (Note: These are large files not recommended for slower computers!)

Top-25k – Fastest WPM (15+ races)

Top-25k – Races Completed

Top-50k – Most Points

  • The top-WPM list has been manually reviewed to ensure the top-100 racers do not include anybody banned for cheating. Approximately 30 users were removed to achieve this. From #100 onwards, banned users will appear in the data.
  • The WPM and nRaces data is referred to as top-25k, but actually contains 50k rows, and data should be considered highly accurate only for the top-25k. This is because these lists were generated by using the top-50k racers by points, and sorting by WPM and nRaces.
  • For the same reason as above, some of the fastest racers on TR will be excluded from the WPM data entirely if they completed fewer than ~15 races during 2018.
  • If there were multiple countries associated with your account during 2018, only one is used for the data in this post.
  • If you live in a smaller country which isn’t included in any of the “by country” stat sets above, you can save any of the three spreadsheets above to your own Google Drive and add your country yourself. Go to the far right tab of any data sets and look for the “OTHER COUNTRY” tab. Edit cell B2 to include your lowercase two letter country code in the formula. Example for the nRacers champions in Switzerland (ch):

Replace this (from “OTHER COUNTRIES cell B2”)

=query(importrange(“1AwaDms1e0nbj3t-QqwLsDcctLMeAq4oZcE1MgeOsbLE”,“Sheet1!A2:K12000”), ” Select * where Col4 =’ENTER_COUNTRY_CODE_HERE‘ “,0)

With this:

=query(importrange(“1AwaDms1e0nbj3t-QqwLsDcctLMeAq4oZcE1MgeOsbLE”,“Sheet1!A2:K12000”), ” Select * where Col4 =’ch’,0)

This will return results based on the first 12000 lines of source data (a Google Sheets limitation), which may be enough for you. For smaller countries this may only be a few dozen results; to show more results you’ll need to scroll to the first empty row and copy the formula above, updating the source data to populate from the next 12,000 rows. In the above example, that would mean you paste the exact same formula into column B of the first empty line, but change Sheet1!A2:K12000 to Sheet1!A12001:K24000.

Read Full Post | Make a Comment ( 4 so far )

« Previous Entries

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: