Difference between revisions of "NASAT results by state"

From QBWiki
Jump to navigation Jump to search
m
Line 81: Line 81:
 
|-
 
|-
 
|}</onlyinclude>
 
|}</onlyinclude>
 +
<!--
  
−
{{#loop:i|2010|{{#expr:{{CURRENTYEAR}}-2009}}|{{#ifexpr:{{#var:i}}=2020| <!-- ignore 2020
+
Hello - welcome to the monstrosity that is this page.
−
-->|
+
 
 +
This table is constructed from the "NASAT results by state by year" page for every instance of NASAT.
 +
Those pages contain raw data in the form of a comma-delimited list of "state=placement" pairs.
 +
 
 +
This table is assembled by transforming those pairs to have information about the year to distinguish each set from one another.
 +
 
 +
--><!--
 +
 
 +
Process the data from each year.
 +
 
 +
"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"
+
{| class="wikitable sortable" style="text-align:center"
 
! State {{#loop:j|2010|{{#expr:{{CURRENTYEAR}}-2009}}|{{#ifexpr:{{#var:j}}=2020||
 
! State {{#loop:j|2010|{{#expr:{{CURRENTYEAR}}-2009}}|{{#ifexpr:{{#var:j}}=2020||
−
!! data-sort-type="number" width=50 {{!}} {{#var:j}}
+
!! data-sort-type="number" {{!}} {{#var:j}}
 
}}}}
 
}}}}
 
! Played
 
! Played
 
! Wins
 
! Wins
−
! Top 2s
+
! Top 2's
−
! Top 3s
+
! Top 3's
−
! Top 4s
+
! Top 4's
 
|-
 
|-
−
 
+
{{#loop:l|0|51|{{!-}}
 +
<!--
 +
"row_state" - "District of Columbia"
 +
-->{{#vardefine:row_state|{{All states and DC|{{#var:l}}}}}}<!--
 +
-->{{#vardefine:n|0}}<!--
 +
-->{{#vardefine:top_count|0}}<!--
 +
-->{{#vardefine:top_2_count|0}}<!--
 +
-->{{#vardefine:top_3_count|0}}<!--
 +
-->{{#vardefine:top_4_count|0}}<!--
 +
-->{{#while:<!--
 +
"District of Columbia" - "2012=3,2019=17, etc."
 +
--><!---->|{{#explode:{{#var:{{#var:row_state}}}}|,|{{#var:n}}}}<!--
 +
"row_year_placement" = "2012=3"
 +
--><!---->|{{#vardefine:row_year_placement|{{#explode:{{#var:{{#var:row_state}}}}|,|{{#var:n}}}}}} <!--
 +
"row_placement" = "3"
 +
--><!---->{{#vardefine:row_placement|{{#explode:{{#var:row_year_placement}}|=|1}}}} <!--
 +
"District of Columbia_2012" = "3"
 +
--><!---->{{#vardefine:{{#var:row_state}}_{{#explode:{{#var:row_year_placement}}|=|0}}|{{#var:row_placement}}}}<!--
 +
Tick up "top_count", "top_2_count", etc. based on whether the placement is 1st, at least 3rd, etc.
 +
--><!---->{{#ifexpr:{{#var:row_placement}}<5<!--
 +
--><!----><!---->|{{#vardefine:top_4_count|{{#expr:{{#var:top_4_count}}+1}}}}<!--
 +
--><!----><!---->{{#ifexpr:{{#var:row_placement}}<4<!--
 +
--><!----><!----><!---->|{{#vardefine:top_3_count|{{#expr:{{#var:top_4_count}}+1}}}}<!--
 +
--><!----><!----><!---->{{#ifexpr:{{#var:row_placement}}<3<!--
 +
--><!----><!----><!----><!---->|{{#vardefine:top_2_count|{{#expr:{{#var:top_4_count}}+1}}}}<!--
 +
--><!----><!----><!----><!---->{{#ifexpr:{{#var:row_placement}}<2<!--
 +
--><!----><!----><!----><!----><!---->|{{#vardefine:top_count|{{#expr:{{#var:top_4_count}}+1}}}}<!--
 +
--><!----><!----><!----><!---->}}<!--
 +
--><!----><!----><!---->}}<!--
 +
--><!----><!---->}}<!--
 +
--><!---->}}<!--
 +
n = n+1
 +
--><!---->{{#vardefine:n|{{#expr:{{#var:n}}+1}}}}<!--
 +
-->}}<!--
 +
-->{{#ifexpr:{{#var:n}}>0<!--
 +
--><!---->|{{!}}{{#var:row_state}}<!--
 +
--><!---->{{#loop:m|2010|{{#expr:{{CURRENTYEAR}}-2009}}|{{#ifexpr:{{#var:m}}=2020|<!--
 +
--><!----><!---->|<!--
 +
--><!----><!---->{{#if:{{#var:{{#var:row_state}}_{{#var:m}}}}<!--
 +
--><!----><!----><!---->|{{!}}{{Placement cell|{{#var:{{#var:row_state}}_{{#var:m}}}}}} <!--
 +
--><!----><!----><!---->|{{!!}}data-sort-value="100"{{!}}<nowiki> </nowiki><!--
 +
--><!----><!---->}}<!--
 +
--><!---->}}}}<!--
 +
--><!---->{{!!}} {{#var:n}} <!--
 +
--><!---->{{!!}} {{#var:top_count}} <!--
 +
--><!---->{{!!}} {{#var:top_2_count}} <!--
 +
--><!---->{{!!}} {{#var:top_3_count}} <!--
 +
--><!---->{{!!}} {{#var:top_4_count}}<!--
 +
-->}}
 +
{{!-}}
 +
}}
 
|}
 
|}

Revision as of 15:54, 20 June 2022

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 Played Wins Top 2s Top 3s Top 4s
Alabama 12 14 2
Arizona 13 1
California 7 4 1 3 3 1 2 4 3 t-10th 10 2 3 6 8
China 25 1
Connecticut 23 1
Delaware 15 6 2
District of Columbia 6 7 2
Florida 9 22 2
Georgia 5 4 11 13 11 4 5 22 8 2
Illinois 3 2 2 6 2 3 1 1 1 1 10 4 7 9 9
Indiana 13 12 12 3
Iowa 22 1
Kentucky 10 8 11 7 11 8 9 21 23 8 10
Maryland 6 5 6 11 8 6 6
Massachusetts 16 1
Michigan 5 17 4 13 18 16 6 1
Minnesota 12 13 2
Missouri 12 9 6 1 8 10 9 6 6 15 10 1 1 1 1
New Hampshire 15 1
New Jersey 10 8 10 4 5 16 4 7 2
New York 9 3 9 14 6 2 t-10th 7 1 2 2
Nevada 27 1
North Carolina 7 15 2
Ohio 8 3 9 4 7 7 3 7 3 2 10 1 4 5
Oklahoma 14 12 19 3
Pennsylvania 1 9 5 9 5 12 6 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 7 2 3 5 5
Vermont 16 1
Virginia 4 10 8 6 2 8 2 7 8 2 2 3
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 0 0 0 0
Arizona 13 1 0 0 0 0
Arkansas 14 1 0 0 0 0
California 7 4 1 3 3 1 2 4 3 10 7 9 2 13 6 10 10 9
Connecticut 23 21 10 3 0 0 0 0
Delaware 15 6 2 0 0 0 0
District of Columbia 6 7 2 0 0 0 0
Florida 9 22 9 3 0 0 0 0
Georgia 5 4 11 13 11 4 5 22 2 9 0 4 4 3
Illinois 3 2 2 6 2 3 1 1 1 1 1 2 1 3 14 13 13 14 13
Indiana 13 12 12 22 11 5 0 0 0 0
Iowa 22 27 21 3 0 0 0 0
Kentucky 10 8 11 7 11 8 9 21 23 8 10 15 9 4 14 0 0 0 1
Maryland 6 5 6 11 8 6 13 4 7 2 10 0 3 3 2
Massachusetts 16 1 0 0 0 0
Michigan 5 17 4 13 18 16 7 7 0 0 0 1
Minnesota 12 13 5 13 15 5 0 0 0 0
Missouri 12 9 6 1 8 10 9 6 6 15 8 3 7 1 14 4 4 4 3
Nevada 17 27 2 0 0 0 0
New Hampshire 15 1 0 0 0 0
New Jersey 10 8 10 4 5 16 4 6 1 5 10 4 4 4 3
New York 9 3 9 14 6 2 10 7 0 3 3 2
North Carolina 7 15 13 5 4 0 0 0 0
Ohio 8 3 9 4 7 7 3 7 4 2 3 10 12 0 6 7 6
Oklahoma 14 12 19 31 6 5 0 0 0 0
Pennsylvania 1 9 5 9 5 12 6 13 8 2 2 2 1
South Carolina 2 12 2 0 2 2 1
Tennessee 11 10 6 7 4 0 0 0 0
Texas 5 1 5 2 1 3 3 4 8 4 4 6 6
Vermont 16 1 0 0 0 0
Virginia 4 10 8 6 2 8 2 7 11 8 10 0 4 4 3
Retrieved from "https://www.qbwiki.com/w/index.php?title=NASAT_results_by_state&oldid=56797"