Difference between revisions of "NASAT results by state"

From QBWiki
Jump to navigation Jump to search
(Created page with "{|class="wikitable sortable" style=text-align:center !width=200|State !data-sort-type="number" width=50|2010 !data-sort-type="number" width=50|2011 !data-sort-type="number" wi...")
 
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
{|class="wikitable sortable" style=text-align:center
+
This page is not intended to be used directly, but rather transcluded. For its main usage, see the [[NASAT]] page.
−
!width=200|State
+
 
−
!data-sort-type="number" width=50|2010
+
{{NASAT results by state by year nav}}
−
!data-sort-type="number" width=50|2011
+
<!--
−
!data-sort-type="number" width=50|2012
+
 
−
!data-sort-type="number" width=50|2013
+
Hello - welcome to the monstrosity that is this page.
−
!data-sort-type="number" width=50|2014
+
 
−
!data-sort-type="number" width=50|2015
+
This table is constructed from the "NASAT results by state by year" page for every instance of NASAT.
−
!data-sort-type="numer" width=50|2016
+
Those pages contain raw data in the form of a comma-delimited list of "state=placement" pairs.
−
!data-sort-type="numer" width=50|2017
+
 
−
!data-sort-type="numer" width=50|2018
+
This table is assembled by transforming those pairs to have information about the year to distinguish each set from one another.
−
!data-sort-type="numer" width=50|2019
+
 
−
!width=100 bgcolor=lightgreen|Played
+
--><onlyinclude><!--
−
!width=75 bgcolor=gold|Wins
+
 
−
!width=75 bgcolor=silver|Top 2s
+
Process the data from each year.
−
!width=75 bgcolor=#cd7f32|Top 3s
+
 
−
!width=75 bgcolor=cyan|Top 4s
+
"i" - [2010 ... current year] / {2020}
 +
-->{{#loop:i|2010|{{#expr:{{CURRENTYEAR}}-2009}}|{{#ifexpr:{{#var:i}}=2020| <!--
 +
"k" - [1 ... # of states in $i NASAT]
 +
-->|{{#vardefine:k|0}}{{#while:<!--
 +
"year_raw" - "Alaska=3,Alabama=2, etc."
 +
--><!---->|{{#vardefine:year_raw|{{:NASAT results by state by year/{{#var:i}}}}}}<!--
 +
--><!---->{{#explode:{{#var:year_raw}}|,|{{#var:k}}}}<!--
 +
"year_raw_state_placement" - "Alaska=3"
 +
--><!---->|{{#vardefine:year_raw_state_placement|{{#explode:{{#var:year_raw}}|,|{{#var:k}}}}}}<!--
 +
"year_raw_state" - "Alaska"
 +
--><!---->{{#vardefine:year_raw_state|{{#explode:{{#var:year_raw_state_placement}}|=|0}}}}<!--
 +
"year_raw_placement" - "3"
 +
--><!---->{{#vardefine:year_raw_placement|{{#explode:{{#var:year_raw_state_placement}}|=|1}}}}<!--
 +
"Alaska" - "2010=4,2011=7,2012=10, etc."
 +
--><!---->{{#if:{{#var:{{#var:year_raw_state}}}}<!--
 +
--><!----><!---->|{{#vardefine:{{#var:year_raw_state}}|{{#var:{{#var:year_raw_state}}}},{{#var:i}}={{#var:year_raw_placement}}}}<!--
 +
--><!----><!---->|{{#vardefine:{{#var:year_raw_state}}|{{#var:i}}={{#var:year_raw_placement}}}} <!--
 +
--><!---->}}<!--
 +
k = k+1
 +
--><!---->{{#vardefine:k|{{#expr:{{#var:k}}+1}}}}<!--
 +
-->}}
 +
}}}}{| class="wikitable sortable" style="text-align:center"
 +
! State {{#loop:j|2010|{{#expr:{{CURRENTYEAR}}-2009}}|{{#ifexpr:{{#var:j}}=2020||
 +
!! data-sort-type="number" {{!}} {{#var:j}}
 +
}}}}
 +
! Played
 +
! Wins
 +
! Top 2's
 +
! Top 3's
 +
! Top 4's
 
|-
 
|-
−
|align=left|Alabama||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||12||14||data-sort-value="100"| ||data-sort-value="100"| ||2 || || || ||  
+
{{#loop:l|0|51|{{!-}}
−
|-
+
<!--
−
|align=left|Arizona||13||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| || ||1|| || || ||
+
"row_state" - "District of Columbia"
−
|-
+
-->{{#vardefine:row_state|{{All states and DC|{{#var:l}}}}}}<!--
−
|align=left|California||7||bgcolor=cyan|4||bgcolor=gold|1||bgcolor=#cd7f32|3||bgcolor=#cd7f32|3||bgcolor=gold|1||bgcolor=silver|2||bgcolor=cyan|4||bgcolor=#cd7f32|3||t-10th||bgcolor=lightgreen|'''10'''||bgcolor=gold|2||bgcolor=silver|3||bgcolor=#cd7f32|6||bgcolor=cyan|8
+
-->{{#vardefine:n|0}}<!--
−
|-
+
-->{{#vardefine:top_count|0}}<!--
−
|align=left|China||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||25||data-sort-value="100"| ||1|| || || ||
+
-->{{#vardefine:top_2_count|0}}<!--
−
|-
+
-->{{#vardefine:top_3_count|0}}<!--
−
|align=left|Connecticut||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||23||1|| || || ||
+
-->{{#vardefine:top_4_count|0}}<!--
−
|-
+
-->{{#while:<!--
−
|align=left|Delaware||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||15||data-sort-value="100"| |||6||data-sort-value="100"| || ||data-sort-value="100"| ||2|| || || ||
+
"District of Columbia" - "2012=3,2019=17, etc."
−
|-
+
--><!---->|{{#explode:{{#var:{{#var:row_state}}}}|,|{{#var:n}}}}<!--
−
|align=left|District of Columbia||6||7||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||2|| || || ||
+
"row_year_placement" = "2012=3"
−
|-
+
--><!---->|{{#vardefine:row_year_placement|{{#explode:{{#var:{{#var:row_state}}}}|,|{{#var:n}}}}}} <!--
−
|align=left|Florida||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||9||data-sort-value="100"| ||data-sort-value="100"| ||22||data-sort-value="100"| ||data-sort-value="100"| ||2|| || || ||
+
"row_placement" = "3"
−
|-
+
--><!---->{{#vardefine:row_placement|{{#explode:{{#var:row_year_placement}}|=|1}}}} <!--
−
|align=left|Georgia||data-sort-value="100"| ||5||bgcolor=cyan|4||11||13||11||bgcolor=cyan|4||5||22||data-sort-value="100"| ||8|| || || ||bgcolor=cyan|2
+
"District of Columbia_2012" = "3"
−
|-
+
--><!---->{{#vardefine:{{#var:row_state}}_{{#explode:{{#var:row_year_placement}}|=|0}}|{{#var:row_placement}}}}<!--
−
|align=left|[[Team Illinois|Illinois]]||bgcolor=#cd7f32|3||bgcolor=silver|2||bgcolor=silver|2||6||bgcolor=silver|2||bgcolor=#cd7f32|3||bgcolor=gold|1||bgcolor=gold|1||bgcolor=gold|1||bgcolor=gold|1||bgcolor=lightgreen|'''10'''||bgcolor=gold|'''4'''||bgcolor=silver|'''7'''||bgcolor=#cd7f32|'''9'''||bgcolor=cyan|'''9'''
+
Tick up "top_count", "top_2_count", etc. based on whether the placement is 1st, at least 3rd, etc.
−
|-
+
--><!---->{{#ifexpr:{{#var:row_placement}}<5<!--
−
|align=left|Indiana||data-sort-value="100"| ||data-sort-value="100"| ||13||12||12||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||3|| || || ||
+
--><!----><!---->|{{#vardefine:top_4_count|{{#expr:{{#var:top_4_count}}+1}}}}<!--
−
|-
+
--><!----><!---->{{#ifexpr:{{#var:row_placement}}<4<!--
−
|align=left|Iowa||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||22||1|| || || ||
+
--><!----><!----><!---->|{{#vardefine:top_3_count|{{#expr:{{#var:top_3_count}}+1}}}}<!--
−
|-
+
--><!----><!----><!---->{{#ifexpr:{{#var:row_placement}}<3<!--
−
|align=left|Kentucky||10||8||11||7||11||8||9||21||23||8||bgcolor=lightgreen|'''10'''|| || || ||
+
--><!----><!----><!----><!---->|{{#vardefine:top_2_count|{{#expr:{{#var:top_2_count}}+1}}}}<!--
−
|-
+
--><!----><!----><!----><!---->{{#ifexpr:{{#var:row_placement}}<2<!--
−
|align=left|Maryland||data-sort-value="100"| ||6||data-sort-value="100"| ||data-sort-value="100"| ||5||data-sort-value="100"| ||6||11||8||6||6|| || || ||
+
--><!----><!----><!----><!----><!---->|{{#vardefine:top_count|{{#expr:{{#var:top_count}}+1}}}}<!--
−
|-
+
--><!----><!----><!----><!---->}}<!--
−
|align=left|Massachusetts||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||16||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||1|| || || ||
+
--><!----><!----><!---->}}<!--
−
|-
+
--><!----><!---->}}<!--
−
|align=left|Michigan||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||5||17||bgcolor=cyan|4||data-sort-value="100"| ||13 ||18||16||6|| || || ||bgcolor=cyan|1
+
--><!---->}}<!--
−
|-
+
n = n+1
−
|align=left|Minnesota||data-sort-value="100"| ||data-sort-value="100"| ||12||13||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||2|| || || ||
+
--><!---->{{#vardefine:n|{{#expr:{{#var:n}}+1}}}}<!--
−
|-
+
-->}}<!--
−
|align=left|[[Team Missouri|Missouri]]||12||9||6||bgcolor=gold|1||8||10||9||6||6||15||bgcolor=lightgreen|'''10'''||bgcolor=gold|1||bgcolor=silver|1||bgcolor=#cd7f32|1||bgcolor=cyan|1
+
-->{{#ifexpr:{{#var:n}}>0<!--
−
|-
+
--><!---->|{{!}}{{#var:row_state}}<!--
−
|align=left|New Hampshire||15||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||1|| || || ||
+
--><!---->{{#loop:m|2010|{{#expr:{{CURRENTYEAR}}-2009}}|{{#ifexpr:{{#var:m}}=2020|<!--
−
|-
+
--><!----><!---->|<!--
−
|align=left|New Jersey||data-sort-value="100"| ||10||8||10||bgcolor=cyan|4||5||data-sort-value="100"| ||data-sort-value="100"| ||16||bgcolor=cyan|4||7|| || || ||bgcolor=cyan|2
+
--><!----><!---->{{#if:{{#var:{{#var:row_state}}_{{#var:m}}}}<!--
−
|-
+
--><!----><!----><!---->|{{!}}{{Placement cell|{{#var:{{#var:row_state}}_{{#var:m}}}}}} <!--
−
|align=left|New York||9||data-sort-value="100"| ||bgcolor=#cd7f32|3||9||14||data-sort-value="100"| ||6||bgcolor=silver|2||t-10th||data-sort-value="100"| ||7|| ||bgcolor=silver|1||bgcolor=#cd7f32|2||bgcolor=cyan|2
+
--><!----><!----><!---->|{{!!}}data-sort-value="100"{{!}}<nowiki> </nowiki><!--
−
|-
+
--><!----><!---->}}<!--
−
|align=left|Nevada||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||27||data-sort-value="100"| ||1|| || || ||
+
--><!---->}}}}<!--
−
|-
+
--><!---->{{!!}} bgcolor={{Hex interpolate|90e077|fraction={{#expr:{{#var:n}}/({{CURRENTYEAR}}-2009)}}}} {{!}} {{#var:n}} <!--
−
|align=left|[[North Carolina (state)|North Carolina]]||data-sort-value="100"| ||data-sort-value="100"| ||7||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||15||data-sort-value="100"| ||2|| || || ||
+
--><!---->{{!!}} {{#ifexpr:{{#var:top_count}}|bgcolor="gold" {{!}} {{Non-zero number|{{#var:top_count}}}}}} <!--
−
|-
+
--><!---->{{!!}} {{#ifexpr:{{#var:top_2_count}}|bgcolor="silver" {{!}} {{Non-zero number|{{#var:top_2_count}}}}}} <!--
−
|align=left|Ohio||8||bgcolor=#cd7f32|3||9||bgcolor=cyan|4||7||7||bgcolor=#cd7f32|3||7||bgcolor=#cd7f32|3||bgcolor=silver|2||bgcolor=lightgreen|'''10'''|| ||bgcolor=silver|1||bgcolor=#cd7f32|4||bgcolor=cyan|5
+
--><!---->{{!!}} {{#ifexpr:{{#var:top_3_count}}|bgcolor="#c96" {{!}} {{Non-zero number|{{#var:top_3_count}}}}}} <!--
−
|-
+
--><!---->{{!!}} {{Non-zero number|{{#var:top_4_count}}}}<!--
−
|align=left|Oklahoma||14||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||12||data-sort-value="100"| ||data-sort-value="100"| ||19||3|| || || ||
+
-->}}
−
|-
+
{{!-}}
−
|align=left|Pennsylvania||bgcolor=gold|1||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||9||5||9||5||12||6||bgcolor=gold|1||bgcolor=silver|1||bgcolor=#cd7f32|1||bgcolor=cyan|1
+
}}
−
|-
+
|}</onlyinclude>
−
|align=left|South Carolina||bgcolor=silver|2||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||12||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||2|| ||bgcolor=silver|1||bgcolor=#cd7f32|1||bgcolor=cyan|1
 
−
|-
 
−
|align=left|Tennessee||11||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||10||6||data-sort-value="100"| ||data-sort-value="100"| ||7||data-sort-value="100"| ||4|| || || ||
 
−
|-
 
−
|align=left|Texas||5||bgcolor=gold|1||5||bgcolor=silver|2||bgcolor=gold|1||data-sort-value="100"| ||data-sort-value="100"| ||bgcolor=#cd7f32|3 ||data-sort-value="100"| ||bgcolor=#cd7f32|3||7||bgcolor=gold|2||bgcolor=silver|3||bgcolor=#cd7f32|5||bgcolor=cyan|5
 
−
|-
 
−
|align=left|Vermont||16||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||data-sort-value="100"| ||1|| || || ||
 
−
|-
 
−
|align=left|Virginia||bgcolor=cyan|4||data-sort-value="100"| ||10||8||6||bgcolor=silver|2||data-sort-value="100"| ||8||bgcolor=silver|2||7||8|| ||bgcolor=silver|2||bgcolor=#cd7f32|2||bgcolor=cyan|3
 
−
|-
 
−
|}
 

Latest revision as of 10:06, 21 July 2022

This page is not intended to be used directly, but rather transcluded. For its main usage, see the NASAT page.

NASAT results by state by year

2010 · 2011 · 2012 · 2013 · 2014 · 2015 · 2016 · 2017 · 2018 · 2019 · 2020 · 2021 · 2022 · 2023 · 2024 · All

State 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2021 2022 2023 2024 Played Wins Top 2's Top 3's Top 4's
Alabama 12 14 2
Arizona 13 1
Arkansas 14 1
California 7 4 1 3 3 1 2 4 3 10 7 9 2 13 2 4 7 9
Connecticut 23 21 10 3
Delaware 15 6 2
District of Columbia 6 7 2
Florida 9 22 9 3
Georgia 5 4 11 13 11 4 5 22 2 9 1 1 3
Illinois 3 2 2 6 2 3 1 1 1 1 1 2 1 13 6 10 12 12
Indiana 13 12 12 22 4
Iowa 22 27 21 3
Kentucky 10 8 11 7 11 8 9 21 23 8 10 15 9 13
Maryland 6 5 6 11 8 6 13 4 7 9 1
Massachusetts 16 1
Michigan 5 17 4 13 18 16 7 7 1
Minnesota 12 13 5 13 4
Missouri 12 9 6 1 8 10 9 6 6 15 8 3 7 13 1 1 2 2
Nevada 17 27 2
New Hampshire 15 1
New Jersey 10 8 10 4 5 16 4 6 1 5 10 1 1 1 3
New York 9 3 9 14 6 2 10 7 1 2 2
North Carolina 7 15 13 5 4
Ohio 8 3 9 4 7 7 3 7 4 2 3 10 12 1 4 6
Oklahoma 14 12 19 31 4
Pennsylvania 1 9 5 9 5 12 6 13 8 1 1 1 1
South Carolina 2 12 2 1 1 1
Tennessee 11 10 6 7 4
Texas 5 1 5 2 1 3 3 4 8 2 3 5 6
Vermont 16 1
Virginia 4 10 8 6 2 8 2 7 11 9 2 2 3
Retrieved from "https://www.qbwiki.com/w/index.php?title=NASAT_results_by_state&oldid=56994"