{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["All Years","2023","2022","2021","2020","2019","2018","2017","2016","2015","2014","2013","Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":12,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"All Years","index":0,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[36,17,36,22],[1,17,1,23],[2,17,2,23],[2,13,2,14],[3,13,3,14]]}
[null,"All Years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the county name in column \"S\" to populate QSOs & Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter County",null,"Rank"]
[null,"County","Stations","CW Qs","Phone Qs","Total Qs","% CW","Fixed Qs","Mobile Qs","% Mobile Qs","Rcvd Qs","Rank",null,null,null,{"$f":"IFERROR(IF(N4=\"\",\"\",INDEX($L$6:$L$77,MATCH(N4,$B$6:$B$77,0))),\"\")","v":""},null,"Sequence","County","CW Qs","PH Qs","Total Qs","Rcvd Qs","Rank"]
[]
["Adams","Taylor",14,407,148,555,0.73299999999999998,57,498,0.89700000000000002,906,1,null,null,null,null,null,1,"Taylor",{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,3,FALSE))","v":407},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,4,FALSE))","v":148},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,5,FALSE))","v":555},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,10,FALSE))","v":906},{"$f":"IF(S6=\"\",\"\",INDEX($L$6:$L$77,MATCH(S6,$B$6:$B$77,0)))","v":1}]
["Ashland","Florence",16,638,209,847,0.753,216,631,0.745,933,2,null,null,null,null,null,2,"Door",{"$f":"IF(S7=\"\",\"\",VLOOKUP($S7,$B$6:$L$77,3,FALSE))","v":368},490,858,1353,{"$f":"IF(S7=\"\",\"\",INDEX($L$6:$L$77,MATCH(S7,$B$6:$B$77,0)))","v":3}]
["Barron","Door",14,368,490,858,0.42899999999999999,541,317,0.36899999999999999,1353,3,null,null,null,null,null,3,"Grant",5377,4844,10221,7469,66]
["Bayfield","Menominee",17,584,277,861,0.67800000000000005,230,631,0.73299999999999998,661,4,null,null,null,null,null,4,null,"","","","",""]
["Brown","Langlade",21,755,116,871,0.86699999999999999,61,810,0.93,716,5,null,null,null,null,null,5,null,"","","","",""]
["Buffalo","Clark",21,786,115,901,0.872,49,852,0.94599999999999995,750,6,null,null,null,null,null,6,null,"","","","",""]
["Burnett","Burnett",24,375,537,912,0.41099999999999998,523,389,0.42699999999999999,2071,7,null,null,null,null,null,7,null,"","","","",""]
["Calumet","Crawford",17,384,532,916,0.41899999999999998,525,391,0.42699999999999999,904,8,null,null,null,null,null,8,null,"","","","",""]
["Chippewa","Ashland",16,476,508,984,0.48399999999999999,389,595,0.60499999999999998,852,9,null,null,null,null,null,9,null,"","","","",""]
["Clark","Shawano",17,749,240,989,0.75700000000000001,0,989,1,843,10,null,null,null,null,null,10,null,"","","","",""]
["Columbia","Monroe",20,821,173,994,0.82599999999999996,145,849,0.85399999999999998,861,11,null,null,null,null,null,11,null,"","","","",""]
["Crawford","Juneau",24,954,182,1136,0.84,120,1016,0.89400000000000002,917,12,null,null,null,null,null,12,null,"","","","",""]
["Dane","Iowa",15,558,604,1162,0.48,615,547,0.47099999999999997,955,13,null,null,null,null,null,13,null,"","","","",""]
["Dodge","Iron",12,228,948,1176,0.19400000000000001,885,291,0.247,596,14,null,null,null,null,null,14,null,"","","","",""]
["Door","Bayfield",19,661,566,1227,0.53900000000000003,682,545,0.44400000000000001,960,15,null,null,null,null,null,15,null,"","","","",""]
["Douglas","Forest",19,1031,266,1297,0.79500000000000004,384,913,0.70399999999999996,1012,16,null,null,null,null,null,16,null,"","","","",""]
["Dunn","Marinette",15,788,522,1310,0.60199999999999998,837,473,0.36099999999999999,1290,17,null,null,null,null,null,17,null,"","","","",""]
["Eau Claire","Jackson",21,1042,309,1351,0.77100000000000002,299,1052,0.77900000000000003,1008,18,null,null,null,null,null,18,null,"","","","",""]
["Florence","Sawyer",20,831,543,1374,0.60499999999999998,550,824,0.6,1174,19,null,null,null,null,null,19,null,"","","","",""]
["Fond du Lac","Pierce",28,1065,320,1385,0.76900000000000002,340,1045,0.755,1379,20,null,null,null,null,null,20,null,"","","","",""]
["Forest","Lincoln",29,906,495,1401,0.64700000000000002,404,997,0.71199999999999997,1303,21,null,null,null,null,null,21,null,"","","","",""]
["Grant","Barron",24,977,428,1405,0.69499999999999995,383,1022,0.72699999999999998,1288,22,null,null,null,null,null,22,null,"","","","",""]
["Green","Polk",29,789,647,1436,0.54900000000000004,628,808,0.56299999999999994,1395,23,null,null,null,null,null,23,null,"","","","",""]
["Green Lake","Adams",26,800,707,1507,0.53100000000000003,696,811,0.53800000000000003,1124,24,null,null,null,null,null,24,null,"","","","",""]
["Iowa","Pepin",28,971,570,1541,0.63,445,1096,0.71099999999999997,1214,25,null,null,null,null,null,25,null,"","","","",""]
["Iron","Chippewa",27,1042,541,1583,0.65800000000000003,366,1217,0.76900000000000002,1569,26,null,null,null,null,null,26,null,"","","","",""]
["Jackson","Rusk",22,953,649,1602,0.59499999999999997,654,948,0.59199999999999997,1183,27,null,null,null,null,null,27,null,"","","","",""]
["Jefferson","Oneida",27,721,962,1683,0.42799999999999999,943,740,0.44,1727,28,null,null,null,null,null,28,null,"","","","",""]
["Juneau","Green",18,585,1118,1703,0.34399999999999997,1309,394,0.23100000000000001,1541,29,null,null,null,null,null,29,null,"","","","",""]
["Kenosha","Vilas",23,703,1055,1758,0.4,1207,551,0.313,1282,30,null,null,null,null,null,30,null,"","","","",""]
["Kewaunee","Kewaunee",23,434,1355,1789,0.24299999999999999,1281,508,0.28399999999999997,1819,31]
["La Crosse","Wood",31,1092,837,1929,0.56599999999999995,1115,814,0.42199999999999999,1886,32,null,null,null,null,null,"Average need out of 72.  A lower number is more needed overall:",null,null,null,null,null,{"$f":"(IFERROR(SUM(X6:X36)/COUNTIF(X6:X35,\">0\"),\"\"))","v":23.333333333333332}]
["Lafayette","Trempealeau",26,817,1162,1979,0.41299999999999998,1137,842,0.42499999999999999,1764,33]
["Langlade","Douglas",19,1090,930,2020,0.54,1713,307,0.152,1723,34]
["Lincoln","Washburn",23,915,1302,2217,0.41299999999999998,1800,417,0.188,1527,35]
["Manitowoc","St Croix",37,1656,715,2371,0.69799999999999995,1309,1062,0.44800000000000001,2048,36]
["Marathon","Buffalo",41,949,1467,2416,0.39300000000000002,1395,1021,0.42299999999999999,1989,37]
["Marinette","Marquette",31,1079,1384,2463,0.438,1440,1023,0.41499999999999998,2085,38]
["Marquette","Dunn",36,1806,849,2655,0.68,1341,1314,0.495,2491,39]
["Menominee","Manitowoc",34,603,2099,2702,0.223,2038,664,0.246,2561,40]
["Milwaukee","Columbia",39,1484,1354,2838,0.52300000000000002,2135,703,0.248,2601,41]
["Monroe","Waushara",41,1469,1582,3051,0.48099999999999998,1817,1234,0.40400000000000003,2285,42]
["Oconto","Oconto",27,1935,1222,3157,0.61299999999999999,2550,607,0.192,2178,43]
["Oneida","Walworth",26,1173,2143,3316,0.35399999999999998,2996,320,9.7000000000000003E-2,2578,44]
["Outagamie","Marathon",54,1037,2342,3379,0.307,2158,1221,0.36099999999999999,3551,45]
["Ozaukee","Green Lake",31,880,2634,3514,0.25,2910,604,0.17199999999999999,2404,46]
["Pepin","Lafayette",31,2495,1092,3587,0.69599999999999995,3316,271,7.5999999999999998E-2,2415,47]
["Pierce","Richland",14,1930,1663,3593,0.53700000000000003,3226,367,0.10199999999999999,2254,48]
["Polk","Jefferson",35,2630,1002,3632,0.72399999999999998,3175,457,0.126,3449,49]
["Portage","Calumet",47,1267,2376,3643,0.34799999999999998,3010,633,0.17399999999999999,2858,50]
["Price","Racine",37,868,3101,3969,0.219,3761,208,5.1999999999999998E-2,2997,51]
["Racine","Price",36,2937,2452,5389,0.54500000000000004,4697,692,0.128,4374,52]
["Richland","Waupaca",55,2856,2537,5393,0.53,4488,905,0.16800000000000001,3935,53]
["Rock","Vernon",36,1559,3960,5519,0.28199999999999997,4562,957,0.17299999999999999,3607,54]
["Rusk","Ozaukee",54,1230,4655,5885,0.20899999999999999,5308,577,9.8000000000000004E-2,3824,55]
["Sauk","Dodge",55,1608,4310,5918,0.27200000000000002,5372,546,9.1999999999999998E-2,4599,56]
["Sawyer","Sauk",56,2832,3147,5979,0.47399999999999998,5395,584,9.8000000000000004E-2,4854,57]
["Shawano","Sheboygan",52,1195,5056,6251,0.191,5780,471,7.4999999999999997E-2,4710,58]
["Sheboygan","Portage",56,4144,3430,7574,0.54700000000000004,6123,1451,0.192,5634,59]
["St Croix","Outagamie",101,1799,5992,7791,0.23100000000000001,6927,864,0.111,6698,60]
["Taylor","Washington",62,3785,4108,7893,0.48,7525,368,4.7E-2,6247,61]
["Trempealeau","La Crosse",48,1789,6340,8129,0.22,7462,667,8.2000000000000003E-2,5827,62]
["Vernon","Rock",53,2879,5484,8363,0.34399999999999997,8009,354,4.2000000000000003E-2,5904,63]
["Vilas","Kenosha",30,4318,4537,8855,0.48799999999999999,8722,133,1.4999999999999999E-2,5846,64]
["Walworth","Brown",91,1936,8007,9943,0.19500000000000001,8881,1062,0.107,7487,65]
["Washburn","Grant",68,5377,4844,10221,0.52600000000000002,9867,354,3.5000000000000003E-2,7469,66]
["Washington","Eau Claire",44,5610,8019,13629,0.41199999999999998,12518,1111,8.2000000000000003E-2,9261,67]
["Waukesha","Winnebago",82,5707,8241,13948,0.40899999999999997,13072,876,6.3E-2,10036,68]
["Waupaca","Fond du Lac",126,1287,15307,16594,7.8E-2,15991,603,3.5999999999999997E-2,10366,69]
["Waushara","Waukesha",153,4080,12603,16683,0.245,16335,348,2.1000000000000001E-2,12799,70]
["Winnebago","Dane",140,8584,14440,23024,0.373,22557,467,0.02,16282,71]
["Wood","Milwaukee",179,7354,16023,23377,0.315,23003,374,1.6E-2,18668,72]
[]
[null,"All Years:",{"$f":"SUM(C6:C78)","v":2883},{"$f":"SUM(D6:D78)","v":122423},{"$f":"SUM(E6:E78)","v":190880},{"$f":"SUM(F6:F78)","v":313303},{"$f":"D79/F79","v":0.39074953000769225},{"$f":"SUM(H6:H78)","v":262700},{"$f":"SUM(I6:I78)","v":50603},{"$f":"I79/F79","v":0.1615145721553895},{"$f":"SUM(K6:K78)","v":241657}]

{"sheet":"2023","index":1,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[1,17,1,23],[2,13,2,14],[2,17,2,23],[3,13,3,14],[36,17,36,22]]}
[null,2023]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the county name in column \"S\" to populate QSOs & Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter County",null,"Rank"]
[null,"County","Stations","CW Qs","Phone Qs","Total Qs","% CW","Fixed Qs","Mobile Qs","% Mobile Qs","Rcvd Qs","Rank",null,null,null,{"$f":"IFERROR(IF(N4=\"\",\"\",INDEX($L$6:$L$77,MATCH(N4,$B$6:$B$77,0))),\"\")","v":""},null,"Sequence","County","CW Qs","PH Qs","Total Qs","Rcvd Qs","Rank"]
[]
["Adams","Adams",3,139,292,431,0.32300000000000001,291,140,0.32500000000000001,329,1,null,null,null,null,null,1,null,{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,3,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,4,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,5,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,10,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",INDEX($L$6:$L$77,MATCH(S6,$B$6:$B$77,0)))","v":""}]
["Ashland","Ashland",1,0,83,83,0,83,0,0,81,2,null,null,null,null,null,2,null,{"$f":"IF(S7=\"\",\"\",VLOOKUP($S7,$B$6:$L$77,3,FALSE))","v":""},"","","",{"$f":"IF(S7=\"\",\"\",INDEX($L$6:$L$77,MATCH(S7,$B$6:$B$77,0)))","v":""}]
["Barron","Barron",1,37,0,37,1,0,37,1,26,3,null,null,null,null,null,3,null,"","","","",""]
["Bayfield","Bayfield",0,0,0,0,0,0,0,0,0,4,null,null,null,null,null,4,null,"","","","",""]
["Brown","Brown",11,44,647,691,6.4000000000000001E-2,559,132,0.191,699,5,null,null,null,null,null,5,null,"","","","",""]
["Buffalo","Buffalo",4,36,367,403,8.8999999999999996E-2,367,36,8.8999999999999996E-2,312,6,null,null,null,null,null,6,null,"","","","",""]
["Burnett","Burnett",1,8,0,8,1,0,8,1,121,7,null,null,null,null,null,7,null,"","","","",""]
["Calumet","Calumet",10,239,800,1039,0.23,883,156,0.15,874,8,null,null,null,null,null,8,null,"","","","",""]
["Chippewa","Chippewa",3,73,260,333,0.219,174,159,0.47699999999999998,217,9,null,null,null,null,null,9,null,"","","","",""]
["Clark","Clark",0,0,0,0,0,0,0,0,1,10,null,null,null,null,null,10,null,"","","","",""]
["Columbia","Columbia",4,473,272,745,0.63500000000000001,611,134,0.18,616,11,null,null,null,null,null,11,null,"","","","",""]
["Crawford","Crawford",1,0,57,57,0,57,0,0,78,12,null,null,null,null,null,12,null,"","","","",""]
["Dane","Dane",11,354,847,1201,0.29499999999999998,1137,64,5.2999999999999999E-2,1123,13,null,null,null,null,null,13,null,"","","","",""]
["Dodge","Dodge",7,79,1093,1172,6.7000000000000004E-2,1093,79,6.7000000000000004E-2,851,14,null,null,null,null,null,14,null,"","","","",""]
["Door","Door",1,48,0,48,1,0,48,1,155,15,null,null,null,null,null,15,null,"","","","",""]
["Douglas","Douglas",1,23,49,72,0.31900000000000001,72,0,0,67,16,null,null,null,null,null,16,null,"","","","",""]
["Dunn","Dunn",5,501,429,930,0.53900000000000003,683,247,0.26600000000000001,719,17,null,null,null,null,null,17,null,"","","","",""]
["Eau Claire","Eau Claire",4,459,625,1084,0.42299999999999999,782,302,0.27900000000000003,1063,18,null,null,null,null,null,18,null,"","","","",""]
["Florence","Florence",0,0,0,0,0,0,0,0,1,19,null,null,null,null,null,19,null,"","","","",""]
["Fond du Lac","Fond du Lac",11,112,1540,1652,6.8000000000000005E-2,1537,115,7.0000000000000007E-2,1203,20,null,null,null,null,null,20,null,"","","","",""]
["Forest","Forest",0,0,0,0,0,0,0,0,14,21,null,null,null,null,null,21,null,"","","","",""]
["Grant","Grant",5,401,575,976,0.41099999999999998,976,0,0,793,22,null,null,null,null,null,22,null,"","","","",""]
["Green","Green",1,2,35,37,5.3999999999999999E-2,37,0,0,48,23,null,null,null,null,null,23,null,"","","","",""]
["Green Lake","Green Lake",5,322,851,1173,0.27500000000000002,1131,42,3.5999999999999997E-2,769,24,null,null,null,null,null,24,null,"","","","",""]
["Iowa","Iowa",1,0,259,259,0,259,0,0,211,25,null,null,null,null,null,25,null,"","","","",""]
["Iron","Iron",0,0,0,0,0,0,0,0,0,26,null,null,null,null,null,26,null,"","","","",""]
["Jackson","Jackson",2,68,299,367,0.185,299,68,0.185,286,27,null,null,null,null,null,27,null,"","","","",""]
["Jefferson","Jefferson",3,313,13,326,0.96,255,71,0.218,295,28,null,null,null,null,null,28,null,"","","","",""]
["Juneau","Juneau",3,126,31,157,0.80300000000000005,49,108,0.68799999999999994,153,29,null,null,null,null,null,29,null,"","","","",""]
["Kenosha","Kenosha",5,244,352,596,0.40899999999999997,536,60,0.10100000000000001,489,30,null,null,null,null,null,30,null,"","","","",""]
["Kewaunee","Kewaunee",2,63,193,256,0.246,193,63,0.246,202,31]
["La Crosse","La Crosse",5,589,1061,1650,0.35699999999999998,1583,67,4.1000000000000002E-2,1176,32,null,null,null,null,null,"Average need out of 72.  A lower number is more needed overall:",null,null,null,null,null,{"$f":"(IFERROR(SUM(X6:X36)/COUNTIF(X6:X35,\">0\"),\"\"))","v":""}]
["Lafayette","Lafayette",0,0,0,0,0,0,0,0,125,33]
["Langlade","Langlade",0,0,0,0,0,0,0,0,0,34]
["Lincoln","Lincoln",0,0,0,0,0,0,0,0,22,35]
["Manitowoc","Manitowoc",4,76,327,403,0.189,335,68,0.16900000000000001,308,36]
["Marathon","Marathon",2,35,45,80,0.438,0,80,1,230,37]
["Marinette","Marinette",0,0,0,0,0,0,0,0,50,38]
["Marquette","Marquette",3,111,65,176,0.63100000000000001,104,72,0.40899999999999997,138,39]
["Menominee","Menominee",1,55,175,230,0.23899999999999999,230,0,0,173,40]
["Milwaukee","Milwaukee",20,547,2082,2629,0.20799999999999999,2548,81,3.1E-2,2204,41]
["Monroe","Monroe",1,39,0,39,1,0,39,1,46,42]
["Oconto","Oconto",2,0,473,473,0,426,47,9.9000000000000005E-2,170,43]
["Oneida","Oneida",0,0,0,0,0,0,0,0,4,44]
["Outagamie","Outagamie",19,199,879,1078,0.185,936,142,0.13200000000000001,925,45]
["Ozaukee","Ozaukee",9,335,899,1234,0.27100000000000002,1172,62,0.05,869,46]
["Pepin","Pepin",2,89,0,89,1,0,89,1,75,47]
["Pierce","Pierce",3,191,56,247,0.77300000000000002,118,129,0.52200000000000002,195,48]
["Polk","Polk",1,49,0,49,1,0,49,1,42,49]
["Portage","Portage",5,176,220,396,0.44400000000000001,183,213,0.53800000000000003,410,50]
["Price","Price",2,96,306,402,0.23899999999999999,402,0,0,306,51]
["Racine","Racine",3,44,295,339,0.13,295,44,0.13,316,52]
["Richland","Richland",1,97,0,97,1,0,97,1,85,53]
["Rock","Rock",7,327,1194,1521,0.215,1489,32,2.1000000000000001E-2,995,54]
["Rusk","Rusk",0,0,0,0,0,0,0,0,0,55]
["Sauk","Sauk",5,684,341,1025,0.66700000000000004,946,79,7.6999999999999999E-2,970,56]
["Sawyer","Sawyer",1,0,207,207,0,207,0,0,199,57]
["Shawano","Shawano",2,42,118,160,0.26300000000000001,0,160,1,104,58]
["Sheboygan","Sheboygan",5,75,267,342,0.219,265,77,0.22500000000000001,291,59]
["St Croix","St Croix",5,260,238,498,0.52200000000000002,418,80,0.161,413,60]
["Taylor","Taylor",1,0,57,57,0,57,0,0,54,61]
["Trempealeau","Trempealeau",2,133,176,309,0.43,180,129,0.41699999999999998,248,62]
["Vernon","Vernon",3,227,724,951,0.23899999999999999,554,397,0.41699999999999998,654,63]
["Vilas","Vilas",1,225,154,379,0.59399999999999997,379,0,0,296,64]
["Walworth","Walworth",4,80,883,963,8.3000000000000004E-2,889,74,7.6999999999999999E-2,525,65]
["Washburn","Washburn",1,13,0,13,1,0,13,1,88,66]
["Washington","Washington",7,810,256,1066,0.76,1025,41,3.7999999999999999E-2,997,67]
["Waukesha","Waukesha",23,552,2052,2604,0.21199999999999999,2591,13,5.0000000000000001E-3,1966,68]
["Waupaca","Waupaca",10,46,305,351,0.13100000000000001,276,75,0.214,290,69]
["Waushara","Waushara",7,241,189,430,0.56000000000000005,314,116,0.27,349,70]
["Winnebago","Winnebago",16,1287,1271,2558,0.503,2397,161,6.3E-2,1601,71]
["Wood","Wood",4,108,311,419,0.25800000000000001,293,126,0.30099999999999999,328,72]
[]
[null,"Totals:",{"$f":"SUM(C6:C78)","v":293},{"$f":"SUM(D6:D78)","v":12002},{"$f":"SUM(E6:E78)","v":25595},{"$f":"SUM(F6:F78)","v":37597},{"$f":"D79/F79","v":0.31922759794664468},{"$f":"SUM(H6:H78)","v":32676},{"$f":"SUM(I6:I78)","v":4921},{"$f":"I79/F79","v":0.13088810277415752},{"$f":"SUM(K6:K78)","v":30033}]

{"sheet":"2022","index":2,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[36,17,36,22],[1,17,1,23],[2,17,2,23],[2,13,2,14],[3,13,3,14]]}
[null,2022]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the county name in column \"S\" to populate QSOs & Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter County",null,"Rank"]
[null,"County","Stations","CW Qs","Phone Qs","Total Qs","% CW","Fixed Qs","Mobile Qs","% Mobile Qs","Rcvd Qs","Rank",null,null,null,{"$f":"IFERROR(IF(N4=\"\",\"\",INDEX($L$6:$L$77,MATCH(N4,$B$6:$B$77,0))),\"\")","v":""},null,"Sequence","County","CW Qs","PH Qs","Total Qs","Rcvd Qs","Rank"]
[]
["Adams","Adams",1,60,0,60,1,0,60,1,54,1,null,null,null,null,null,1,null,{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,3,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,4,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,5,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,10,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",INDEX($L$6:$L$77,MATCH(S6,$B$6:$B$77,0)))","v":""}]
["Ashland","Ashland",2,90,80,170,0.52900000000000003,80,90,0.52900000000000003,160,2,null,null,null,null,null,2,null,{"$f":"IF(S7=\"\",\"\",VLOOKUP($S7,$B$6:$L$77,3,FALSE))","v":""},"","","",{"$f":"IF(S7=\"\",\"\",INDEX($L$6:$L$77,MATCH(S7,$B$6:$B$77,0)))","v":""}]
["Barron","Barron",0,0,0,0,0,0,0,0,2,3,null,null,null,null,null,3,null,"","","","",""]
["Bayfield","Bayfield",1,31,0,31,1,0,31,1,25,4,null,null,null,null,null,4,null,"","","","",""]
["Brown","Brown",5,291,232,523,0.55600000000000005,472,51,9.8000000000000004E-2,651,5,null,null,null,null,null,5,null,"","","","",""]
["Buffalo","Buffalo",3,23,245,268,8.5999999999999993E-2,245,23,8.5999999999999993E-2,199,6,null,null,null,null,null,6,null,"","","","",""]
["Burnett","Burnett",0,0,0,0,0,0,0,0,288,7,null,null,null,null,null,7,null,"","","","",""]
["Calumet","Calumet",4,43,239,282,0.152,238,44,0.156,212,8,null,null,null,null,null,8,null,"","","","",""]
["Chippewa","Chippewa",1,1,35,36,2.8000000000000001E-2,36,0,0,45,9,null,null,null,null,null,9,null,"","","","",""]
["Clark","Clark",1,54,0,54,1,0,54,1,46,10,null,null,null,null,null,10,null,"","","","",""]
["Columbia","Columbia",2,83,0,83,1,0,83,1,98,11,null,null,null,null,null,11,null,"","","","",""]
["Crawford","Crawford",1,0,50,50,0,50,0,0,52,12,null,null,null,null,null,12,null,"","","","",""]
["Dane","Dane",10,91,1595,1686,5.3999999999999999E-2,1655,31,1.7999999999999999E-2,1158,13,null,null,null,null,null,13,null,"","","","",""]
["Dodge","Dodge",4,272,366,638,0.42599999999999999,572,66,0.10299999999999999,534,14,null,null,null,null,null,14,null,"","","","",""]
["Door","Door",1,61,1,62,0.98399999999999999,0,62,1,142,15,null,null,null,null,null,15,null,"","","","",""]
["Douglas","Douglas",1,207,171,378,0.54800000000000004,378,0,0,268,16,null,null,null,null,null,16,null,"","","","",""]
["Dunn","Dunn",2,353,142,495,0.71299999999999997,474,21,4.2000000000000003E-2,454,17,null,null,null,null,null,17,null,"","","","",""]
["Eau Claire","Eau Claire",4,475,699,1174,0.40500000000000003,1124,50,4.2999999999999997E-2,955,18,null,null,null,null,null,18,null,"","","","",""]
["Florence","Florence",1,26,32,58,0.44800000000000001,0,58,1,39,19,null,null,null,null,null,19,null,"","","","",""]
["Fond du Lac","Fond du Lac",3,0,749,749,0,749,0,0,572,20,null,null,null,null,null,20,null,"","","","",""]
["Forest","Forest",1,46,52,98,0.46899999999999997,0,98,1,73,21,null,null,null,null,null,21,null,"","","","",""]
["Grant","Grant",7,504,624,1128,0.44700000000000001,1029,99,8.7999999999999995E-2,838,22,null,null,null,null,null,22,null,"","","","",""]
["Green","Green",0,0,0,0,0,0,0,0,41,23,null,null,null,null,null,23,null,"","","","",""]
["Green Lake","Green Lake",3,23,441,464,0.05,441,23,0.05,301,24,null,null,null,null,null,24,null,"","","","",""]
["Iowa","Iowa",2,13,22,35,0.371,22,13,0.371,12,25,null,null,null,null,null,25,null,"","","","",""]
["Iron","Iron",0,0,0,0,0,0,0,0,1,26,null,null,null,null,null,26,null,"","","","",""]
["Jackson","Jackson",1,46,0,46,1,0,46,1,44,27,null,null,null,null,null,27,null,"","","","",""]
["Jefferson","Jefferson",2,112,148,260,0.43099999999999999,260,0,0,163,28,null,null,null,null,null,28,null,"","","","",""]
["Juneau","Juneau",2,73,0,73,1,0,73,1,51,29,null,null,null,null,null,29,null,"","","","",""]
["Kenosha","Kenosha",4,611,583,1194,0.51200000000000001,1194,0,0,824,30,null,null,null,null,null,30,null,"","","","",""]
["Kewaunee","Kewaunee",1,59,0,59,1,0,59,1,56,31]
["La Crosse","La Crosse",3,162,619,781,0.20699999999999999,781,0,0,538,32,null,null,null,null,null,"Average need out of 72.  A lower number is more needed overall:",null,null,null,null,null,{"$f":"(IFERROR(SUM(X6:X36)/COUNTIF(X6:X35,\">0\"),\"\"))","v":""}]
["Lafayette","Lafayette",2,0,104,104,0,104,0,0,76,33]
["Langlade","Langlade",1,63,0,63,1,0,63,1,57,34]
["Lincoln","Lincoln",1,84,0,84,1,0,84,1,59,35]
["Manitowoc","Manitowoc",3,91,9,100,0.91,26,74,0.74,97,36]
["Marathon","Marathon",3,41,327,368,0.111,327,41,0.111,372,37]
["Marinette","Marinette",0,0,0,0,0,0,0,0,33,38]
["Marquette","Marquette",3,152,248,400,0.38,284,116,0.28999999999999998,328,39]
["Menominee","Menominee",1,27,10,37,0.73,0,37,1,29,40]
["Milwaukee","Milwaukee",12,234,1189,1423,0.16400000000000001,1388,35,2.5000000000000001E-2,1090,41]
["Monroe","Monroe",1,34,0,34,1,0,34,1,29,42]
["Oconto","Oconto",0,0,0,0,0,0,0,0,2,43]
["Oneida","Oneida",0,0,0,0,0,0,0,0,13,44]
["Outagamie","Outagamie",4,108,299,407,0.26500000000000001,336,71,0.17399999999999999,386,45]
["Ozaukee","Ozaukee",6,130,709,839,0.155,805,34,4.1000000000000002E-2,544,46]
["Pepin","Pepin",1,16,0,16,1,0,16,1,14,47]
["Pierce","Pierce",1,29,1,30,0.96699999999999997,30,0,0,43,48]
["Polk","Polk",0,0,0,0,0,0,0,0,5,49]
["Portage","Portage",5,594,48,642,0.92500000000000004,455,187,0.29099999999999998,500,50]
["Price","Price",4,319,362,681,0.46800000000000003,595,86,0.126,521,51]
["Racine","Racine",3,102,732,834,0.122,834,0,0,469,52]
["Richland","Richland",0,0,0,0,0,0,0,0,3,53]
["Rock","Rock",5,441,558,999,0.441,973,26,2.5999999999999999E-2,713,54]
["Rusk","Rusk",1,75,0,75,1,0,75,1,59,55]
["Sauk","Sauk",6,552,259,811,0.68100000000000005,811,0,0,649,56]
["Sawyer","Sawyer",2,97,140,237,0.40899999999999997,140,97,0.40899999999999997,177,57]
["Shawano","Shawano",1,83,0,83,1,0,83,1,86,58]
["Sheboygan","Sheboygan",3,28,147,175,0.16,147,28,0.16,285,59]
["St Croix","St Croix",2,95,28,123,0.77200000000000002,123,0,0,126,60]
["Taylor","Taylor",1,58,0,58,1,0,58,1,45,61]
["Trempealeau","Trempealeau",3,37,149,186,0.19900000000000001,149,37,0.19900000000000001,151,62]
["Vernon","Vernon",3,137,467,604,0.22700000000000001,604,0,0,414,63]
["Vilas","Vilas",0,0,0,0,0,0,0,0,0,64]
["Walworth","Walworth",2,39,50,89,0.438,50,39,0.438,100,65]
["Washburn","Washburn",0,0,0,0,0,0,0,0,46,66]
["Washington","Washington",4,685,277,962,0.71199999999999997,962,0,0,698,67]
["Waukesha","Waukesha",16,95,848,943,0.10100000000000001,928,15,1.6E-2,798,68]
["Waupaca","Waupaca",6,341,326,667,0.51100000000000001,622,45,6.7000000000000004E-2,476,69]
["Waushara","Waushara",3,171,130,301,0.56799999999999995,208,93,0.309,317,70]
["Winnebago","Winnebago",5,536,26,562,0.95399999999999996,487,75,0.13300000000000001,566,71]
["Wood","Wood",3,137,12,149,0.91900000000000004,13,136,0.91300000000000003,192,72]
[]
[null,"Totals:",{"$f":"SUM(C6:C78)","v":190},{"$f":"SUM(D6:D78)","v":9441},{"$f":"SUM(E6:E78)","v":14580},{"$f":"SUM(F6:F78)","v":24021},{"$f":"D79/F79","v":0.39303109778943424},{"$f":"SUM(H6:H78)","v":21201},{"$f":"SUM(I6:I78)","v":2820},{"$f":"I79/F79","v":0.1173972773822905},{"$f":"SUM(K6:K78)","v":19464}]

{"sheet":"2021","index":3,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[36,17,36,22],[1,17,1,23],[2,17,2,23],[2,13,2,14],[3,13,3,14]]}
[null,2021]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the county name in column \"S\" to populate QSOs & Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter County",null,"Rank"]
[null,"County","Stations","CW Qs","Phone Qs","Total Qs","% CW","Fixed Qs","Mobile Qs","% Mobile Qs","Rcvd Qs","Rank",null,null,null,{"$f":"IFERROR(IF(N4=\"\",\"\",INDEX($L$6:$L$77,MATCH(N4,$B$6:$B$77,0))),\"\")","v":""},null,"Sequence","County","CW Qs","PH Qs","Total Qs","Rcvd Qs","Rank"]
[]
["Adams","Adams",3,76,234,310,0.245,234,76,0.245,211,1,null,null,null,null,null,1,null,{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,3,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,4,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,5,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,10,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",INDEX($L$6:$L$77,MATCH(S6,$B$6:$B$77,0)))","v":""}]
["Ashland","Ashland",3,96,115,211,0.45500000000000002,41,170,0.80600000000000005,144,2,null,null,null,null,null,2,null,{"$f":"IF(S7=\"\",\"\",VLOOKUP($S7,$B$6:$L$77,3,FALSE))","v":""},"","","",{"$f":"IF(S7=\"\",\"\",INDEX($L$6:$L$77,MATCH(S7,$B$6:$B$77,0)))","v":""}]
["Barron","Barron",2,170,0,170,1,0,170,1,149,3,null,null,null,null,null,3,null,"","","","",""]
["Bayfield","Bayfield",4,168,243,411,0.40899999999999997,243,168,0.40899999999999997,286,4,null,null,null,null,null,4,null,"","","","",""]
["Brown","Brown",7,401,655,1056,0.38,965,91,8.5999999999999993E-2,816,5,null,null,null,null,null,5,null,"","","","",""]
["Buffalo","Buffalo",4,75,139,214,0.35,139,75,0.35,182,6,null,null,null,null,null,6,null,"","","","",""]
["Burnett","Burnett",2,69,41,110,0.627,41,69,0.627,92,7,null,null,null,null,null,7,null,"","","","",""]
["Calumet","Calumet",4,23,355,378,6.0999999999999999E-2,332,46,0.122,306,8,null,null,null,null,null,8,null,"","","","",""]
["Chippewa","Chippewa",1,45,0,45,1,0,45,1,64,9,null,null,null,null,null,9,null,"","","","",""]
["Clark","Clark",2,112,0,112,1,0,112,1,92,10,null,null,null,null,null,10,null,"","","","",""]
["Columbia","Columbia",3,421,106,527,0.79900000000000004,506,21,0.04,437,11,null,null,null,null,null,11,null,"","","","",""]
["Crawford","Crawford",2,52,67,119,0.437,67,52,0.437,111,12,null,null,null,null,null,12,null,"","","","",""]
["Dane","Dane",15,704,1197,1901,0.37,1901,0,0,1474,13,null,null,null,null,null,13,null,"","","","",""]
["Dodge","Dodge",5,125,105,230,0.54300000000000004,91,139,0.60399999999999998,213,14,null,null,null,null,null,14,null,"","","","",""]
["Door","Door",1,52,1,53,0.98099999999999998,0,53,1,166,15,null,null,null,null,null,15,null,"","","","",""]
["Douglas","Douglas",2,63,59,122,0.51600000000000001,59,63,0.51600000000000001,107,16,null,null,null,null,null,16,null,"","","","",""]
["Dunn","Dunn",3,111,1,112,0.99099999999999999,0,112,1,236,17,null,null,null,null,null,17,null,"","","","",""]
["Eau Claire","Eau Claire",4,208,430,638,0.32600000000000001,478,160,0.251,708,18,null,null,null,null,null,18,null,"","","","",""]
["Florence","Florence",0,0,0,0,0,0,0,0,1,19,null,null,null,null,null,19,null,"","","","",""]
["Fond du Lac","Fond du Lac",11,122,960,1082,0.113,940,142,0.13100000000000001,875,20,null,null,null,null,null,20,null,"","","","",""]
["Forest","Forest",0,0,0,0,0,0,0,0,21,21,null,null,null,null,null,21,null,"","","","",""]
["Grant","Grant",10,554,774,1328,0.41699999999999998,1325,3,2E-3,947,22,null,null,null,null,null,22,null,"","","","",""]
["Green","Green",3,220,102,322,0.68300000000000005,255,67,0.20799999999999999,295,23,null,null,null,null,null,23,null,"","","","",""]
["Green Lake","Green Lake",5,82,440,522,0.157,440,82,0.157,354,24,null,null,null,null,null,24,null,"","","","",""]
["Iowa","Iowa",1,111,0,111,1,0,111,1,121,25,null,null,null,null,null,25,null,"","","","",""]
["Iron","Iron",1,0,37,37,0,0,37,1,37,26,null,null,null,null,null,26,null,"","","","",""]
["Jackson","Jackson",1,80,0,80,1,0,80,1,74,27,null,null,null,null,null,27,null,"","","","",""]
["Jefferson","Jefferson",3,380,30,410,0.92700000000000005,320,90,0.22,388,28,null,null,null,null,null,28,null,"","","","",""]
["Juneau","Juneau",2,124,0,124,1,0,124,1,99,29,null,null,null,null,null,29,null,"","","","",""]
["Kenosha","Kenosha",3,476,654,1130,0.42099999999999999,1130,0,0,776,30,null,null,null,null,null,30,null,"","","","",""]
["Kewaunee","Kewaunee",1,70,1,71,0.98599999999999999,0,71,1,79,31]
["La Crosse","La Crosse",6,343,1105,1448,0.23699999999999999,1448,0,0,981,32,null,null,null,null,null,"Average need out of 72.  A lower number is more needed overall:",null,null,null,null,null,{"$f":"(IFERROR(SUM(X6:X36)/COUNTIF(X6:X35,\">0\"),\"\"))","v":""}]
["Lafayette","Lafayette",2,288,129,417,0.69099999999999995,417,0,0,328,33]
["Langlade","Langlade",1,0,57,57,0,57,0,0,39,34]
["Lincoln","Lincoln",1,0,269,269,0,269,0,0,180,35]
["Manitowoc","Manitowoc",3,136,14,150,0.90700000000000003,38,112,0.747,254,36]
["Marathon","Marathon",1,28,0,28,1,0,28,1,109,37]
["Marinette","Marinette",1,37,0,37,1,0,37,1,41,38]
["Marquette","Marquette",3,120,98,218,0.55000000000000004,110,108,0.495,147,39]
["Menominee","Menominee",0,0,0,0,0,0,0,0,0,40]
["Milwaukee","Milwaukee",18,1152,1752,2904,0.39700000000000002,2899,5,2E-3,2461,41]
["Monroe","Monroe",2,136,0,136,1,0,136,1,114,42]
["Oconto","Oconto",1,65,2,67,0.97,0,67,1,54,43]
["Oneida","Oneida",1,94,150,244,0.38500000000000001,244,0,0,211,44]
["Outagamie","Outagamie",10,205,1042,1247,0.16400000000000001,1167,80,6.4000000000000001E-2,879,45]
["Ozaukee","Ozaukee",6,111,667,778,0.14299999999999999,726,52,6.7000000000000004E-2,449,46]
["Pepin","Pepin",2,114,0,114,1,0,114,1,100,47]
["Pierce","Pierce",3,132,0,132,1,0,132,1,139,48]
["Polk","Polk",3,109,48,157,0.69399999999999995,48,109,0.69399999999999995,239,49]
["Portage","Portage",6,613,193,806,0.76100000000000001,683,123,0.153,667,50]
["Price","Price",4,388,273,661,0.58699999999999997,529,132,0.2,502,51]
["Racine","Racine",5,0,322,322,0,322,0,0,340,52]
["Richland","Richland",2,330,332,662,0.498,631,31,4.7E-2,454,53]
["Rock","Rock",3,219,429,648,0.33800000000000002,646,2,3.0000000000000001E-3,462,54]
["Rusk","Rusk",2,167,0,167,1,0,167,1,142,55]
["Sauk","Sauk",5,529,413,942,0.56200000000000006,942,0,0,720,56]
["Sawyer","Sawyer",3,224,0,224,1,0,224,1,180,57]
["Shawano","Shawano",0,0,0,0,0,0,0,0,10,58]
["Sheboygan","Sheboygan",4,55,208,263,0.20899999999999999,194,69,0.26200000000000001,336,59]
["St Croix","St Croix",5,301,140,441,0.68300000000000005,262,179,0.40600000000000003,345,60]
["Taylor","Taylor",1,52,0,52,1,0,52,1,103,61]
["Trempealeau","Trempealeau",3,66,118,184,0.35899999999999999,118,66,0.35899999999999999,242,62]
["Vernon","Vernon",4,261,447,708,0.36899999999999999,648,60,8.5000000000000006E-2,507,63]
["Vilas","Vilas",1,0,13,13,0,0,13,1,7,64]
["Walworth","Walworth",2,185,3,188,0.98399999999999999,186,2,1.0999999999999999E-2,213,65]
["Washburn","Washburn",2,50,0,50,1,0,50,1,88,66]
["Washington","Washington",8,784,487,1271,0.61699999999999999,1183,88,6.9000000000000006E-2,1064,67]
["Waukesha","Waukesha",17,80,1407,1487,5.3999999999999999E-2,1482,5,3.0000000000000001E-3,1139,68]
["Waupaca","Waupaca",7,527,413,940,0.56100000000000005,787,153,0.16300000000000001,731,69]
["Waushara","Waushara",3,199,104,303,0.65700000000000003,216,87,0.28699999999999998,255,70]
["Winnebago","Winnebago",9,690,863,1553,0.44400000000000001,1435,118,7.5999999999999998E-2,1169,71]
["Wood","Wood",1,65,0,65,1,0,65,1,88,72]
[]
[null,"Totals:",{"$f":"SUM(C6:C78)","v":269},{"$f":"SUM(D6:D78)","v":14045},{"$f":"SUM(E6:E78)","v":18244},{"$f":"SUM(F6:F78)","v":32289},{"$f":"D79/F79","v":0.43497785623586982},{"$f":"SUM(H6:H78)","v":27194},{"$f":"SUM(I6:I78)","v":5095},{"$f":"I79/F79","v":0.15779367586484561},{"$f":"SUM(K6:K78)","v":26350}]

{"sheet":"2020","index":4,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[36,17,36,22],[1,17,1,23],[2,17,2,23],[2,13,2,14],[3,13,3,14]]}
[null,2020]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the county name in column \"S\" to populate QSOs & Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter County",null,"Rank"]
[null,"County","Stations","CW Qs","Phone Qs","Total Qs","% CW","Fixed Qs","Mobile Qs","% Mobile Qs","Rcvd Qs","Rank",null,null,null,{"$f":"IFERROR(IF(N4=\"\",\"\",INDEX($L$6:$L$77,MATCH(N4,$B$6:$B$77,0))),\"\")","v":""},null,"Sequence","County","CW Qs","PH Qs","Total Qs","Rcvd Qs","Rank"]
[]
["Adams","Adams",3,36,87,123,0.29299999999999998,87,36,0.29299999999999998,105,1,null,null,null,null,null,1,null,{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,3,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,4,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,5,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,10,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",INDEX($L$6:$L$77,MATCH(S6,$B$6:$B$77,0)))","v":""}]
["Ashland","Ashland",0,0,0,0,0,0,0,0,2,2,null,null,null,null,null,2,null,{"$f":"IF(S7=\"\",\"\",VLOOKUP($S7,$B$6:$L$77,3,FALSE))","v":""},"","","",{"$f":"IF(S7=\"\",\"\",INDEX($L$6:$L$77,MATCH(S7,$B$6:$B$77,0)))","v":""}]
["Barron","Barron",2,119,1,120,0.99199999999999999,0,120,1,96,3,null,null,null,null,null,3,null,"","","","",""]
["Bayfield","Bayfield",0,0,0,0,0,0,0,0,18,4,null,null,null,null,null,4,null,"","","","",""]
["Brown","Brown",6,17,185,202,8.4000000000000005E-2,120,82,0.40600000000000003,304,5,null,null,null,null,null,5,null,"","","","",""]
["Buffalo","Buffalo",4,134,234,368,0.36399999999999999,222,146,0.39700000000000002,283,6,null,null,null,null,null,6,null,"","","","",""]
["Burnett","Burnett",2,0,86,86,0,86,0,0,69,7,null,null,null,null,null,7,null,"","","","",""]
["Calumet","Calumet",3,0,249,249,0,216,33,0.13300000000000001,213,8,null,null,null,null,null,8,null,"","","","",""]
["Chippewa","Chippewa",3,82,1,83,0.98799999999999999,0,83,1,148,9,null,null,null,null,null,9,null,"","","","",""]
["Clark","Clark",4,174,38,212,0.82099999999999995,37,175,0.82499999999999996,169,10,null,null,null,null,null,10,null,"","","","",""]
["Columbia","Columbia",2,22,87,109,0.20200000000000001,87,22,0.20200000000000001,168,11,null,null,null,null,null,11,null,"","","","",""]
["Crawford","Crawford",1,0,62,62,0,62,0,0,99,12,null,null,null,null,null,12,null,"","","","",""]
["Dane","Dane",10,431,487,918,0.46899999999999997,892,26,2.8000000000000001E-2,827,13,null,null,null,null,null,13,null,"","","","",""]
["Dodge","Dodge",5,154,298,452,0.34100000000000003,426,26,5.8000000000000003E-2,335,14,null,null,null,null,null,14,null,"","","","",""]
["Door","Door",1,55,0,55,1,55,0,0,36,15,null,null,null,null,null,15,null,"","","","",""]
["Douglas","Douglas",1,0,93,93,0,93,0,0,321,16,null,null,null,null,null,16,null,"","","","",""]
["Dunn","Dunn",3,149,0,149,1,0,149,1,218,17,null,null,null,null,null,17,null,"","","","",""]
["Eau Claire","Eau Claire",4,143,171,314,0.45500000000000002,191,123,0.39200000000000002,440,18,null,null,null,null,null,18,null,"","","","",""]
["Florence","Florence",1,32,0,32,1,0,32,1,30,19,null,null,null,null,null,19,null,"","","","",""]
["Fond du Lac","Fond du Lac",6,0,649,649,0,636,13,0.02,446,20,null,null,null,null,null,20,null,"","","","",""]
["Forest","Forest",2,50,27,77,0.64900000000000002,27,50,0.64900000000000002,65,21,null,null,null,null,null,21,null,"","","","",""]
["Grant","Grant",8,276,490,766,0.36,763,3,4.0000000000000001E-3,553,22,null,null,null,null,null,22,null,"","","","",""]
["Green","Green",3,44,120,164,0.26800000000000002,164,0,0,111,23,null,null,null,null,null,23,null,"","","","",""]
["Green Lake","Green Lake",2,40,16,56,0.71399999999999997,0,56,1,42,24,null,null,null,null,null,24,null,"","","","",""]
["Iowa","Iowa",1,0,185,185,0,185,0,0,119,25,null,null,null,null,null,25,null,"","","","",""]
["Iron","Iron",0,0,0,0,0,0,0,0,0,26,null,null,null,null,null,26,null,"","","","",""]
["Jackson","Jackson",2,96,0,96,1,0,96,1,68,27,null,null,null,null,null,27,null,"","","","",""]
["Jefferson","Jefferson",2,228,47,275,0.82899999999999996,255,20,7.2999999999999995E-2,262,28,null,null,null,null,null,28,null,"","","","",""]
["Juneau","Juneau",1,38,0,38,1,0,38,1,27,29,null,null,null,null,null,29,null,"","","","",""]
["Kenosha","Kenosha",5,792,549,1341,0.59099999999999997,1341,0,0,827,30,null,null,null,null,null,30,null,"","","","",""]
["Kewaunee","Kewaunee",2,42,18,60,0.7,0,60,1,88,31]
["La Crosse","La Crosse",3,13,435,448,2.9000000000000001E-2,448,0,0,305,32,null,null,null,null,null,"Average need out of 72.  A lower number is more needed overall:",null,null,null,null,null,{"$f":"(IFERROR(SUM(X6:X36)/COUNTIF(X6:X35,\">0\"),\"\"))","v":""}]
["Lafayette","Lafayette",2,278,84,362,0.76800000000000002,362,0,0,256,33]
["Langlade","Langlade",1,47,0,47,1,0,47,1,39,34]
["Lincoln","Lincoln",2,45,2,47,0.95699999999999996,2,45,0.95699999999999996,41,35]
["Manitowoc","Manitowoc",2,1,114,115,8.9999999999999993E-3,100,15,0.13,118,36]
["Marathon","Marathon",7,118,187,305,0.38700000000000001,171,134,0.439,364,37]
["Marinette","Marinette",3,59,101,160,0.36899999999999999,101,59,0.36899999999999999,120,38]
["Marquette","Marquette",1,33,0,33,1,0,33,1,30,39]
["Menominee","Menominee",3,102,10,112,0.91100000000000003,0,112,1,82,40]
["Milwaukee","Milwaukee",20,1823,1637,3460,0.52700000000000002,3423,37,1.0999999999999999E-2,2642,41]
["Monroe","Monroe",1,29,0,29,1,0,29,1,25,42]
["Oconto","Oconto",4,98,28,126,0.77800000000000002,0,126,1,100,43]
["Oneida","Oneida",0,0,0,0,0,0,0,0,23,44]
["Outagamie","Outagamie",14,302,523,825,0.36599999999999999,706,119,0.14399999999999999,809,45]
["Ozaukee","Ozaukee",7,361,969,1330,0.27100000000000002,1293,37,2.8000000000000001E-2,663,46]
["Pepin","Pepin",3,164,3,167,0.98199999999999998,0,167,1,133,47]
["Pierce","Pierce",2,145,0,145,1,0,145,1,124,48]
["Polk","Polk",0,0,0,0,0,0,0,0,7,49]
["Portage","Portage",6,466,330,796,0.58499999999999996,700,96,0.121,583,50]
["Price","Price",2,390,122,512,0.76200000000000001,512,0,0,526,51]
["Racine","Racine",3,0,351,351,0,351,0,0,284,52]
["Richland","Richland",1,291,228,519,0.56100000000000005,519,0,0,364,53]
["Rock","Rock",3,399,7,406,0.98299999999999998,378,28,6.9000000000000006E-2,404,54]
["Rusk","Rusk",2,156,1,157,0.99399999999999999,0,157,1,130,55]
["Sauk","Sauk",3,98,297,395,0.248,395,0,0,296,56]
["Sawyer","Sawyer",0,0,0,0,0,0,0,0,0,57]
["Shawano","Shawano",2,0,50,50,0,0,50,1,45,58]
["Sheboygan","Sheboygan",3,0,173,173,0,161,12,6.9000000000000006E-2,217,59]
["St Croix","St Croix",2,88,33,121,0.72699999999999998,33,88,0.72699999999999998,136,60]
["Taylor","Taylor",2,104,1,105,0.99,0,105,1,127,61]
["Trempealeau","Trempealeau",4,156,238,394,0.39600000000000002,234,160,0.40600000000000003,301,62]
["Vernon","Vernon",1,6,205,211,2.8000000000000001E-2,211,0,0,143,63]
["Vilas","Vilas",0,0,0,0,0,0,0,0,2,64]
["Walworth","Walworth",3,215,60,275,0.78200000000000003,244,31,0.113,242,65]
["Washburn","Washburn",1,269,244,513,0.52400000000000002,513,0,0,331,66]
["Washington","Washington",7,745,419,1164,0.64,1136,28,2.4E-2,806,67]
["Waukesha","Waukesha",11,136,541,677,0.20100000000000001,629,48,7.0999999999999994E-2,612,68]
["Waupaca","Waupaca",7,340,274,614,0.55400000000000005,522,92,0.15,462,69]
["Waushara","Waushara",5,76,560,636,0.11899999999999999,566,70,0.11,319,70]
["Winnebago","Winnebago",7,480,595,1075,0.44700000000000001,982,93,8.6999999999999994E-2,813,71]
["Wood","Wood",4,273,173,446,0.61199999999999999,403,43,9.6000000000000002E-2,382,72]
[]
[null,"Totals:",{"$f":"SUM(C6:C78)","v":243},{"$f":"SUM(D6:D78)","v":11460},{"$f":"SUM(E6:E78)","v":13175},{"$f":"SUM(F6:F78)","v":24635},{"$f":"D79/F79","v":0.46519180028414858},{"$f":"SUM(H6:H78)","v":21040},{"$f":"SUM(I6:I78)","v":3595},{"$f":"I79/F79","v":0.14593058656383195},{"$f":"SUM(K6:K78)","v":19895}]

{"sheet":"2019","index":5,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[36,17,36,22],[1,17,1,23],[2,17,2,23],[2,13,2,14],[3,13,3,14]]}
[null,2019]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the county name in column \"S\" to populate QSOs & Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter County",null,"Rank"]
[null,"County","Stations","CW Qs","Phone Qs","Total Qs","% CW","Fixed Qs","Mobile Qs","% Mobile Qs","Rcvd Qs","Rank",null,null,null,{"$f":"IFERROR(IF(N4=\"\",\"\",INDEX($L$6:$L$77,MATCH(N4,$B$6:$B$77,0))),\"\")","v":""},null,"Sequence","County","CW Qs","PH Qs","Total Qs","Rcvd Qs","Rank"]
[]
["Adams","Adams",2,0,30,30,0,28,2,6.7000000000000004E-2,33,1,null,null,null,null,null,1,null,{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,3,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,4,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,5,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,10,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",INDEX($L$6:$L$77,MATCH(S6,$B$6:$B$77,0)))","v":""}]
["Ashland","Ashland",0,0,0,0,0,0,0,0,1,2,null,null,null,null,null,2,null,{"$f":"IF(S7=\"\",\"\",VLOOKUP($S7,$B$6:$L$77,3,FALSE))","v":""},"","","",{"$f":"IF(S7=\"\",\"\",INDEX($L$6:$L$77,MATCH(S7,$B$6:$B$77,0)))","v":""}]
["Barron","Barron",0,0,0,0,0,0,0,0,0,3,null,null,null,null,null,3,null,"","","","",""]
["Bayfield","Bayfield",2,171,267,438,0.39,438,0,0,318,4,null,null,null,null,null,4,null,"","","","",""]
["Brown","Brown",8,322,328,650,0.495,523,127,0.19500000000000001,554,5,null,null,null,null,null,5,null,"","","","",""]
["Buffalo","Buffalo",3,28,163,191,0.14699999999999999,147,44,0.23,164,6,null,null,null,null,null,6,null,"","","","",""]
["Burnett","Burnett",1,0,148,148,0,148,0,0,67,7,null,null,null,null,null,7,null,"","","","",""]
["Calumet","Calumet",3,72,63,135,0.53300000000000003,62,73,0.54100000000000004,112,8,null,null,null,null,null,8,null,"","","","",""]
["Chippewa","Chippewa",2,43,69,112,0.38400000000000001,66,46,0.41099999999999998,104,9,null,null,null,null,null,9,null,"","","","",""]
["Clark","Clark",1,49,0,49,1,0,49,1,42,10,null,null,null,null,null,10,null,"","","","",""]
["Columbia","Columbia",4,20,241,261,7.6999999999999999E-2,227,34,0.13,181,11,null,null,null,null,null,11,null,"","","","",""]
["Crawford","Crawford",2,51,10,61,0.83599999999999997,10,51,0.83599999999999997,40,12,null,null,null,null,null,12,null,"","","","",""]
["Dane","Dane",7,247,420,667,0.37,640,27,0.04,551,13,null,null,null,null,null,13,null,"","","","",""]
["Dodge","Dodge",3,143,209,352,0.40600000000000003,326,26,7.3999999999999996E-2,287,14,null,null,null,null,null,14,null,"","","","",""]
["Door","Door",3,97,6,103,0.94199999999999995,44,59,0.57299999999999995,98,15,null,null,null,null,null,15,null,"","","","",""]
["Douglas","Douglas",0,0,0,0,0,0,0,0,2,16,null,null,null,null,null,16,null,"","","","",""]
["Dunn","Dunn",1,65,17,82,0.79300000000000004,0,82,1,81,17,null,null,null,null,null,17,null,"","","","",""]
["Eau Claire","Eau Claire",3,230,246,476,0.48299999999999998,476,0,0,436,18,null,null,null,null,null,18,null,"","","","",""]
["Florence","Florence",1,80,4,84,0.95199999999999996,0,84,1,66,19,null,null,null,null,null,19,null,"","","","",""]
["Fond du Lac","Fond du Lac",5,99,484,583,0.17,555,28,4.8000000000000001E-2,445,20,null,null,null,null,null,20,null,"","","","",""]
["Forest","Forest",1,71,0,71,1,0,71,1,77,21,null,null,null,null,null,21,null,"","","","",""]
["Grant","Grant",7,512,202,714,0.71699999999999997,714,0,0,541,22,null,null,null,null,null,22,null,"","","","",""]
["Green","Green",1,0,158,158,0,158,0,0,118,23,null,null,null,null,null,23,null,"","","","",""]
["Green Lake","Green Lake",1,0,158,158,0,158,0,0,118,24,null,null,null,null,null,24,null,"","","","",""]
["Iowa","Iowa",1,19,130,149,0.128,149,0,0,105,25,null,null,null,null,null,25,null,"","","","",""]
["Iron","Iron",1,0,293,293,0,293,0,0,104,26,null,null,null,null,null,26,null,"","","","",""]
["Jackson","Jackson",1,46,8,54,0.85199999999999998,0,54,1,40,27,null,null,null,null,null,27,null,"","","","",""]
["Jefferson","Jefferson",1,161,85,246,0.65400000000000003,246,0,0,263,28,null,null,null,null,null,28,null,"","","","",""]
["Juneau","Juneau",2,48,84,132,0.36399999999999999,71,61,0.46200000000000002,110,29,null,null,null,null,null,29,null,"","","","",""]
["Kenosha","Kenosha",3,367,279,646,0.56799999999999995,614,32,0.05,436,30,null,null,null,null,null,30,null,"","","","",""]
["Kewaunee","Kewaunee",3,84,173,257,0.32700000000000001,170,87,0.33900000000000002,168,31]
["La Crosse","La Crosse",3,54,299,353,0.153,299,54,0.153,262,32,null,null,null,null,null,"Average need out of 72.  A lower number is more needed overall:",null,null,null,null,null,{"$f":"(IFERROR(SUM(X6:X36)/COUNTIF(X6:X35,\">0\"),\"\"))","v":""}]
["Lafayette","Lafayette",2,252,67,319,0.79,319,0,0,228,33]
["Langlade","Langlade",1,22,0,22,1,0,22,1,19,34]
["Lincoln","Lincoln",1,25,12,37,0.67600000000000005,37,0,0,35,35]
["Manitowoc","Manitowoc",3,79,48,127,0.622,48,79,0.622,110,36]
["Marathon","Marathon",5,26,196,222,0.11700000000000001,183,39,0.17599999999999999,284,37]
["Marinette","Marinette",1,60,0,60,1,0,60,1,51,38]
["Marquette","Marquette",2,32,6,38,0.84199999999999997,0,38,1,28,39]
["Menominee","Menominee",1,31,0,31,1,0,31,1,24,40]
["Milwaukee","Milwaukee",14,434,1002,1436,0.30199999999999999,1410,26,1.7999999999999999E-2,1053,41]
["Monroe","Monroe",2,79,4,83,0.95199999999999996,0,83,1,57,42]
["Oconto","Oconto",1,52,4,56,0.92900000000000005,0,56,1,70,43]
["Oneida","Oneida",0,0,0,0,0,0,0,0,47,44]
["Outagamie","Outagamie",9,149,656,805,0.185,753,52,6.5000000000000002E-2,587,45]
["Ozaukee","Ozaukee",4,51,325,376,0.13600000000000001,354,22,5.8999999999999997E-2,276,46]
["Pepin","Pepin",1,33,9,42,0.78600000000000003,0,42,1,38,47]
["Pierce","Pierce",0,0,0,0,0,0,0,0,12,48]
["Polk","Polk",2,0,116,116,0,116,0,0,101,49]
["Portage","Portage",5,186,343,529,0.35199999999999998,473,56,0.106,350,50]
["Price","Price",2,170,116,286,0.59399999999999997,286,0,0,247,51]
["Racine","Racine",3,16,161,177,0.09,161,16,0.09,103,52]
["Richland","Richland",2,207,284,491,0.42199999999999999,491,0,0,271,53]
["Rock","Rock",5,439,554,993,0.442,966,27,2.7E-2,594,54]
["Rusk","Rusk",0,0,0,0,0,0,0,0,1,55]
["Sauk","Sauk",5,96,327,423,0.22700000000000001,373,50,0.11799999999999999,346,56]
["Sawyer","Sawyer",0,0,0,0,0,0,0,0,0,57]
["Shawano","Shawano",2,46,12,58,0.79300000000000004,0,58,1,49,58]
["Sheboygan","Sheboygan",4,19,299,318,0.06,299,19,0.06,276,59]
["St Croix","St Croix",1,0,23,23,0,23,0,0,32,60]
["Taylor","Taylor",0,0,0,0,0,0,0,0,75,61]
["Trempealeau","Trempealeau",1,45,13,58,0.77600000000000002,0,58,1,143,62]
["Vernon","Vernon",2,60,146,206,0.29099999999999998,146,60,0.29099999999999998,156,63]
["Vilas","Vilas",0,0,0,0,0,0,0,0,2,64]
["Walworth","Walworth",2,211,15,226,0.93400000000000005,193,33,0.14599999999999999,245,65]
["Washburn","Washburn",1,230,122,352,0.65300000000000002,352,0,0,251,66]
["Washington","Washington",7,481,682,1163,0.41399999999999998,1163,0,0,787,67]
["Waukesha","Waukesha",13,545,947,1492,0.36499999999999999,1492,0,0,1190,68]
["Waupaca","Waupaca",4,239,384,623,0.38400000000000001,619,4,6.0000000000000001E-3,439,69]
["Waushara","Waushara",3,71,422,493,0.14399999999999999,462,31,6.3E-2,254,70]
["Winnebago","Winnebago",6,138,862,1000,0.13800000000000001,956,44,4.3999999999999997E-2,620,71]
["Wood","Wood",5,50,224,274,0.182,233,41,0.15,307,72]
[]
[null,"Totals:",{"$f":"SUM(C6:C78)","v":198},{"$f":"SUM(D6:D78)","v":7653},{"$f":"SUM(E6:E78)","v":12955},{"$f":"SUM(F6:F78)","v":20608},{"$f":"D79/F79","v":0.37136063664596275},{"$f":"SUM(H6:H78)","v":18470},{"$f":"SUM(I6:I78)","v":2138},{"$f":"I79/F79","v":0.10374611801242237},{"$f":"SUM(K6:K78)","v":15682}]

{"sheet":"2018","index":6,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[36,17,36,22],[1,17,1,23],[2,17,2,23],[2,13,2,14],[3,13,3,14]]}
[null,2018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the county name in column \"S\" to populate QSOs & Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter County",null,"Rank"]
[null,"County","Stations","CW Qs","Phone Qs","Total Qs","% CW","Fixed Qs","Mobile Qs","% Mobile Qs","Rcvd Qs","Rank",null,null,null,{"$f":"IFERROR(IF(N4=\"\",\"\",INDEX($L$6:$L$77,MATCH(N4,$B$6:$B$77,0))),\"\")","v":""},null,"Sequence","County","CW Qs","PH Qs","Total Qs","Rcvd Qs","Rank"]
[]
["Adams","Adams",1,30,0,30,1,0,30,1,30,1,null,null,null,null,null,1,null,{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,3,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,4,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,5,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,10,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",INDEX($L$6:$L$77,MATCH(S6,$B$6:$B$77,0)))","v":""}]
["Ashland","Ashland",0,0,0,0,0,0,0,0,3,2,null,null,null,null,null,2,null,{"$f":"IF(S7=\"\",\"\",VLOOKUP($S7,$B$6:$L$77,3,FALSE))","v":""},"","","",{"$f":"IF(S7=\"\",\"\",INDEX($L$6:$L$77,MATCH(S7,$B$6:$B$77,0)))","v":""}]
["Barron","Barron",1,6,12,18,0.33300000000000002,0,18,1,50,3,null,null,null,null,null,3,null,"","","","",""]
["Bayfield","Bayfield",1,17,0,17,1,0,17,1,30,4,null,null,null,null,null,4,null,"","","","",""]
["Brown","Brown",11,40,585,625,6.4000000000000001E-2,519,106,0.17,386,5,null,null,null,null,null,5,null,"","","","",""]
["Buffalo","Buffalo",5,108,91,199,0.54300000000000004,91,108,0.54300000000000004,167,6,null,null,null,null,null,6,null,"","","","",""]
["Burnett","Burnett",4,65,126,191,0.34,126,65,0.34,164,7,null,null,null,null,null,7,null,"","","","",""]
["Calumet","Calumet",3,0,108,108,0,91,17,0.157,93,8,null,null,null,null,null,8,null,"","","","",""]
["Chippewa","Chippewa",1,51,0,51,1,0,51,1,110,9,null,null,null,null,null,9,null,"","","","",""]
["Clark","Clark",2,103,0,103,1,0,103,1,74,10,null,null,null,null,null,10,null,"","","","",""]
["Columbia","Columbia",4,0,190,190,0,147,43,0.22600000000000001,176,11,null,null,null,null,null,11,null,"","","","",""]
["Crawford","Crawford",1,29,1,30,0.96699999999999997,0,30,1,28,12,null,null,null,null,null,12,null,"","","","",""]
["Dane","Dane",10,741,775,1516,0.48899999999999999,1457,59,3.9E-2,1050,13,null,null,null,null,null,13,null,"","","","",""]
["Dodge","Dodge",8,323,387,710,0.45500000000000002,668,42,5.8999999999999997E-2,516,14,null,null,null,null,null,14,null,"","","","",""]
["Door","Door",1,0,12,12,0,0,12,1,36,15,null,null,null,null,null,15,null,"","","","",""]
["Douglas","Douglas",3,264,221,485,0.54400000000000004,471,14,2.9000000000000001E-2,296,16,null,null,null,null,null,16,null,"","","","",""]
["Dunn","Dunn",2,54,12,66,0.81799999999999995,0,66,1,58,17,null,null,null,null,null,17,null,"","","","",""]
["Eau Claire","Eau Claire",5,696,1431,2127,0.32700000000000001,2083,44,2.1000000000000001E-2,1009,18,null,null,null,null,null,18,null,"","","","",""]
["Florence","Florence",2,97,4,101,0.96,0,101,1,149,19,null,null,null,null,null,19,null,"","","","",""]
["Fond du Lac","Fond du Lac",10,26,780,806,3.2000000000000001E-2,773,33,4.1000000000000002E-2,587,20,null,null,null,null,null,20,null,"","","","",""]
["Forest","Forest",2,130,17,147,0.88400000000000001,0,147,1,78,21,null,null,null,null,null,21,null,"","","","",""]
["Grant","Grant",6,385,272,657,0.58599999999999997,657,0,0,511,22,null,null,null,null,null,22,null,"","","","",""]
["Green","Green",1,20,0,20,1,0,20,1,23,23,null,null,null,null,null,23,null,"","","","",""]
["Green Lake","Green Lake",1,25,0,25,1,0,25,1,23,24,null,null,null,null,null,24,null,"","","","",""]
["Iowa","Iowa",1,0,2,2,0,0,2,1,2,25,null,null,null,null,null,25,null,"","","","",""]
["Iron","Iron",1,26,0,26,1,0,26,1,22,26,null,null,null,null,null,26,null,"","","","",""]
["Jackson","Jackson",2,87,0,87,1,0,87,1,61,27,null,null,null,null,null,27,null,"","","","",""]
["Jefferson","Jefferson",4,240,163,403,0.59599999999999997,372,31,7.6999999999999999E-2,397,28,null,null,null,null,null,28,null,"","","","",""]
["Juneau","Juneau",1,41,0,41,1,0,41,1,30,29,null,null,null,null,null,29,null,"","","","",""]
["Kenosha","Kenosha",2,366,303,669,0.54700000000000004,669,0,0,447,30,null,null,null,null,null,30,null,"","","","",""]
["Kewaunee","Kewaunee",3,0,168,168,0,144,24,0.14299999999999999,154,31]
["La Crosse","La Crosse",5,108,762,870,0.124,845,25,2.9000000000000001E-2,504,32,null,null,null,null,null,"Average need out of 72.  A lower number is more needed overall:",null,null,null,null,null,{"$f":"(IFERROR(SUM(X6:X36)/COUNTIF(X6:X35,\">0\"),\"\"))","v":""}]
["Lafayette","Lafayette",3,216,47,263,0.82099999999999995,251,12,4.5999999999999999E-2,195,33]
["Langlade","Langlade",3,94,1,95,0.98899999999999999,4,91,0.95799999999999996,108,34]
["Lincoln","Lincoln",3,75,20,95,0.78900000000000003,49,46,0.48399999999999999,88,35]
["Manitowoc","Manitowoc",2,0,30,30,0,0,30,1,21,36]
["Marathon","Marathon",3,86,80,166,0.51800000000000002,80,86,0.51800000000000002,241,37]
["Marinette","Marinette",2,71,50,121,0.58699999999999997,50,71,0.58699999999999997,112,38]
["Marquette","Marquette",1,33,0,33,1,0,33,1,72,39]
["Menominee","Menominee",1,36,0,36,1,0,36,1,26,40]
["Milwaukee","Milwaukee",16,373,1203,1576,0.23699999999999999,1534,42,2.7E-2,1125,41]
["Monroe","Monroe",1,35,0,35,1,0,35,1,25,42]
["Oconto","Oconto",3,78,98,176,0.443,84,92,0.52300000000000002,151,43]
["Oneida","Oneida",3,53,121,174,0.30499999999999999,121,53,0.30499999999999999,150,44]
["Outagamie","Outagamie",9,149,204,353,0.42199999999999999,299,54,0.153,340,45]
["Ozaukee","Ozaukee",8,126,406,532,0.23699999999999999,478,54,0.10199999999999999,393,46]
["Pepin","Pepin",2,79,0,79,1,0,79,1,71,47]
["Pierce","Pierce",2,108,0,108,1,0,108,1,84,48]
["Polk","Polk",3,38,80,118,0.32200000000000001,80,38,0.32200000000000001,129,49]
["Portage","Portage",5,443,554,997,0.44400000000000001,946,51,5.0999999999999997E-2,587,50]
["Price","Price",4,174,183,357,0.48699999999999999,329,28,7.8E-2,306,51]
["Racine","Racine",5,34,348,382,8.8999999999999996E-2,370,12,3.1E-2,296,52]
["Richland","Richland",1,269,192,461,0.58399999999999996,461,0,0,284,53]
["Rock","Rock",3,267,90,357,0.748,324,33,9.1999999999999998E-2,316,54]
["Rusk","Rusk",1,0,141,141,0,141,0,0,99,55]
["Sauk","Sauk",7,61,714,775,7.9000000000000001E-2,730,45,5.8000000000000003E-2,288,56]
["Sawyer","Sawyer",1,42,0,42,1,0,42,1,30,57]
["Shawano","Shawano",1,31,0,31,1,0,31,1,61,58]
["Sheboygan","Sheboygan",8,304,736,1040,0.29199999999999998,974,66,6.3E-2,803,59]
["St Croix","St Croix",2,68,15,83,0.81899999999999995,0,83,1,68,60]
["Taylor","Taylor",0,0,0,0,0,0,0,0,34,61]
["Trempealeau","Trempealeau",2,65,0,65,1,0,65,1,50,62]
["Vernon","Vernon",3,102,309,411,0.248,382,29,7.0999999999999994E-2,279,63]
["Vilas","Vilas",3,24,120,144,0.16700000000000001,117,27,0.188,114,64]
["Walworth","Walworth",3,153,44,197,0.77700000000000002,182,15,7.5999999999999998E-2,181,65]
["Washburn","Washburn",2,84,0,84,1,0,84,1,84,66]
["Washington","Washington",9,188,460,648,0.28999999999999998,607,41,6.3E-2,400,67]
["Waukesha","Waukesha",13,466,949,1415,0.32900000000000001,1400,15,1.0999999999999999E-2,1088,68]
["Waupaca","Waupaca",4,268,146,414,0.64700000000000002,343,71,0.17100000000000001,314,69]
["Waushara","Waushara",2,50,51,101,0.495,51,50,0.495,118,70]
["Winnebago","Winnebago",5,250,445,695,0.36,686,9,1.2999999999999999E-2,547,71]
["Wood","Wood",3,111,102,213,0.52100000000000002,163,50,0.23499999999999999,203,72]
[]
[null,"Totals:",{"$f":"SUM(C6:C78)","v":256},{"$f":"SUM(D6:D78)","v":9182},{"$f":"SUM(E6:E78)","v":14361},{"$f":"SUM(F6:F78)","v":23543},{"$f":"D79/F79","v":0.39000976935819565},{"$f":"SUM(H6:H78)","v":20349},{"$f":"SUM(I6:I78)","v":3194},{"$f":"I79/F79","v":0.13566665250817653},{"$f":"SUM(K6:K78)","v":17145}]

{"sheet":"2017","index":7,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[36,17,36,22],[1,17,1,23],[2,17,2,23],[2,13,2,14],[3,13,3,14]]}
[null,2017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the county name in column \"S\" to populate QSOs & Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter County",null,"Rank"]
[null,"County","Stations","CW Qs","Phone Qs","Total Qs","% CW","Fixed Qs","Mobile Qs","% Mobile Qs","Rcvd Qs","Rank",null,null,null,{"$f":"IFERROR(IF(N4=\"\",\"\",INDEX($L$6:$L$77,MATCH(N4,$B$6:$B$77,0))),\"\")","v":""},null,"Sequence","County","CW Qs","PH Qs","Total Qs","Rcvd Qs","Rank"]
[]
["Adams","Adams",2,80,1,81,0.98799999999999999,0,81,1,61,1,null,null,null,null,null,1,null,{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,3,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,4,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,5,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,10,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",INDEX($L$6:$L$77,MATCH(S6,$B$6:$B$77,0)))","v":""}]
["Ashland","Ashland",2,103,0,103,1,0,103,1,80,2,null,null,null,null,null,2,null,{"$f":"IF(S7=\"\",\"\",VLOOKUP($S7,$B$6:$L$77,3,FALSE))","v":""},"","","",{"$f":"IF(S7=\"\",\"\",INDEX($L$6:$L$77,MATCH(S7,$B$6:$B$77,0)))","v":""}]
["Barron","Barron",3,118,0,118,1,0,118,1,88,3,null,null,null,null,null,3,null,"","","","",""]
["Bayfield","Bayfield",3,133,0,133,1,0,133,1,93,4,null,null,null,null,null,4,null,"","","","",""]
["Brown","Brown",11,96,872,968,9.9000000000000005E-2,862,106,0.11,713,5,null,null,null,null,null,5,null,"","","","",""]
["Buffalo","Buffalo",5,52,59,111,0.46800000000000003,59,52,0.46800000000000003,97,6,null,null,null,null,null,6,null,"","","","",""]
["Burnett","Burnett",3,62,0,62,1,0,62,1,144,7,null,null,null,null,null,7,null,"","","","",""]
["Calumet","Calumet",5,0,162,162,0,120,42,0.25900000000000001,149,8,null,null,null,null,null,8,null,"","","","",""]
["Chippewa","Chippewa",3,134,0,134,1,0,134,1,139,9,null,null,null,null,null,9,null,"","","","",""]
["Clark","Clark",2,98,0,98,1,0,98,1,79,10,null,null,null,null,null,10,null,"","","","",""]
["Columbia","Columbia",3,40,53,93,0.43,50,43,0.46200000000000002,65,11,null,null,null,null,null,11,null,"","","","",""]
["Crawford","Crawford",1,16,0,16,1,0,16,1,44,12,null,null,null,null,null,12,null,"","","","",""]
["Dane","Dane",13,314,1091,1405,0.223,1393,12,8.9999999999999993E-3,929,13,null,null,null,null,null,13,null,"","","","",""]
["Dodge","Dodge",5,17,99,116,0.14699999999999999,76,40,0.34499999999999997,156,14,null,null,null,null,null,14,null,"","","","",""]
["Door","Door",2,12,14,26,0.46200000000000002,0,26,1,50,15,null,null,null,null,null,15,null,"","","","",""]
["Douglas","Douglas",2,82,0,82,1,0,82,1,75,16,null,null,null,null,null,16,null,"","","","",""]
["Dunn","Dunn",2,60,4,64,0.93799999999999994,0,64,1,46,17,null,null,null,null,null,17,null,"","","","",""]
["Eau Claire","Eau Claire",2,432,649,1081,0.4,1025,56,5.1999999999999998E-2,577,18,null,null,null,null,null,18,null,"","","","",""]
["Florence","Florence",3,67,125,192,0.34899999999999998,137,55,0.28599999999999998,131,19,null,null,null,null,null,19,null,"","","","",""]
["Fond du Lac","Fond du Lac",16,193,1479,1672,0.115,1642,30,1.7999999999999999E-2,914,20,null,null,null,null,null,20,null,"","","","",""]
["Forest","Forest",2,99,0,99,1,0,99,1,80,21,null,null,null,null,null,21,null,"","","","",""]
["Grant","Grant",5,412,334,746,0.55200000000000005,710,36,4.8000000000000001E-2,505,22,null,null,null,null,null,22,null,"","","","",""]
["Green","Green",1,14,0,14,1,0,14,1,58,23,null,null,null,null,null,23,null,"","","","",""]
["Green Lake","Green Lake",3,46,232,278,0.16500000000000001,220,58,0.20899999999999999,156,24,null,null,null,null,null,24,null,"","","","",""]
["Iowa","Iowa",1,18,1,19,0.94699999999999995,0,19,1,46,25,null,null,null,null,null,25,null,"","","","",""]
["Iron","Iron",2,72,0,72,1,0,72,1,53,26,null,null,null,null,null,26,null,"","","","",""]
["Jackson","Jackson",2,54,0,54,1,0,54,1,38,27,null,null,null,null,null,27,null,"","","","",""]
["Jefferson","Jefferson",5,278,89,367,0.75700000000000001,264,103,0.28100000000000003,359,28,null,null,null,null,null,28,null,"","","","",""]
["Juneau","Juneau",2,85,0,85,1,0,85,1,64,29,null,null,null,null,null,29,null,"","","","",""]
["Kenosha","Kenosha",2,331,268,599,0.55300000000000005,571,28,4.7E-2,382,30,null,null,null,null,null,30,null,"","","","",""]
["Kewaunee","Kewaunee",3,26,197,223,0.11700000000000001,175,48,0.215,140,31]
["La Crosse","La Crosse",2,0,384,384,0,384,0,0,214,32,null,null,null,null,null,"Average need out of 72.  A lower number is more needed overall:",null,null,null,null,null,{"$f":"(IFERROR(SUM(X6:X36)/COUNTIF(X6:X35,\">0\"),\"\"))","v":""}]
["Lafayette","Lafayette",3,17,10,27,0.63,9,18,0.66700000000000004,21,33]
["Langlade","Langlade",2,73,4,77,0.94799999999999995,0,77,1,66,34]
["Lincoln","Lincoln",4,140,6,146,0.95899999999999996,0,146,1,129,35]
["Manitowoc","Manitowoc",5,11,76,87,0.126,24,63,0.72399999999999998,158,36]
["Marathon","Marathon",6,156,102,258,0.60499999999999998,100,158,0.61199999999999999,304,37]
["Marinette","Marinette",2,49,2,51,0.96099999999999997,0,51,1,52,38]
["Marquette","Marquette",2,63,4,67,0.94,0,67,1,228,39]
["Menominee","Menominee",2,35,6,41,0.85399999999999998,0,41,1,35,40]
["Milwaukee","Milwaukee",15,541,820,1361,0.39800000000000002,1336,25,1.7999999999999999E-2,1077,41]
["Monroe","Monroe",2,18,145,163,0.11,145,18,0.11,53,42]
["Oconto","Oconto",3,350,191,541,0.64700000000000002,516,25,4.5999999999999999E-2,282,43]
["Oneida","Oneida",6,103,148,251,0.41,148,103,0.41,229,44]
["Outagamie","Outagamie",12,134,825,959,0.14000000000000001,856,103,0.107,612,45]
["Ozaukee","Ozaukee",6,23,205,228,0.10100000000000001,80,148,0.64900000000000002,172,46]
["Pepin","Pepin",3,58,0,58,1,0,58,1,42,47]
["Pierce","Pierce",2,37,0,37,1,0,37,1,35,48]
["Polk","Polk",4,125,74,199,0.628,74,125,0.628,157,49]
["Portage","Portage",4,392,279,671,0.58399999999999996,574,97,0.14499999999999999,456,50]
["Price","Price",5,510,165,675,0.75600000000000001,545,130,0.193,488,51]
["Racine","Racine",7,214,198,412,0.51900000000000002,340,72,0.17499999999999999,368,52]
["Richland","Richland",2,261,280,541,0.48199999999999998,507,34,6.3E-2,294,53]
["Rock","Rock",6,206,658,864,0.23799999999999999,786,78,0.09,462,54]
["Rusk","Rusk",3,87,92,179,0.48599999999999999,92,87,0.48599999999999999,101,55]
["Sauk","Sauk",5,55,112,167,0.32900000000000001,134,33,0.19800000000000001,187,56]
["Sawyer","Sawyer",4,118,1,119,0.99199999999999999,43,76,0.63900000000000001,107,57]
["Shawano","Shawano",1,26,0,26,1,0,26,1,39,58]
["Sheboygan","Sheboygan",7,36,553,589,6.0999999999999999E-2,547,42,7.0999999999999994E-2,366,59]
["St Croix","St Croix",2,18,3,21,0.85699999999999998,0,21,1,56,60]
["Taylor","Taylor",2,59,1,60,0.98299999999999998,0,60,1,42,61]
["Trempealeau","Trempealeau",2,51,0,51,1,0,51,1,56,62]
["Vernon","Vernon",2,109,289,398,0.27400000000000002,398,0,0,226,63]
["Vilas","Vilas",4,99,34,133,0.74399999999999999,34,99,0.74399999999999999,108,64]
["Walworth","Walworth",3,162,2,164,0.98799999999999999,56,108,0.65900000000000003,161,65]
["Washburn","Washburn",4,70,73,143,0.49,78,65,0.45500000000000002,73,66]
["Washington","Washington",6,15,305,320,4.7E-2,250,70,0.219,240,67]
["Waukesha","Waukesha",16,485,1189,1674,0.28999999999999998,1592,82,4.9000000000000002E-2,1308,68]
["Waupaca","Waupaca",5,172,74,246,0.69899999999999995,178,68,0.27600000000000002,169,69]
["Waushara","Waushara",3,80,23,103,0.77700000000000002,0,103,1,84,70]
["Winnebago","Winnebago",7,244,724,968,0.252,937,31,3.2000000000000001E-2,645,71]
["Wood","Wood",4,108,3,111,0.97299999999999998,3,108,0.97299999999999998,86,72]
[]
[null,"Totals:",{"$f":"SUM(C6:C78)","v":301},{"$f":"SUM(D6:D78)","v":9054},{"$f":"SUM(E6:E78)","v":13789},{"$f":"SUM(F6:F78)","v":22843},{"$f":"D79/F79","v":0.39635774635555748},{"$f":"SUM(H6:H78)","v":18070},{"$f":"SUM(I6:I78)","v":4773},{"$f":"I79/F79","v":0.2089480365976448},{"$f":"SUM(K6:K78)","v":16499}]

{"sheet":"2016","index":8,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[36,17,36,22],[1,17,1,23],[2,17,2,23],[2,13,2,14],[3,13,3,14]]}
[null,2016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the county name in column \"S\" to populate QSOs & Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter County",null,"Rank"]
[null,"County","Stations","CW Qs","Phone Qs","Total Qs","% CW","Fixed Qs","Mobile Qs","% Mobile Qs","Rcvd Qs","Rank",null,null,null,{"$f":"IFERROR(IF(N4=\"\",\"\",INDEX($L$6:$L$77,MATCH(N4,$B$6:$B$77,0))),\"\")","v":""},null,"Sequence","County","CW Qs","PH Qs","Total Qs","Rcvd Qs","Rank"]
[]
["Adams","Adams",5,143,56,199,0.71899999999999997,56,143,0.71899999999999997,90,1,null,null,null,null,null,1,null,{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,3,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,4,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,5,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,10,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",INDEX($L$6:$L$77,MATCH(S6,$B$6:$B$77,0)))","v":""}]
["Ashland","Ashland",2,51,21,72,0.70799999999999996,0,72,1,50,2,null,null,null,null,null,2,null,{"$f":"IF(S7=\"\",\"\",VLOOKUP($S7,$B$6:$L$77,3,FALSE))","v":""},"","","",{"$f":"IF(S7=\"\",\"\",INDEX($L$6:$L$77,MATCH(S7,$B$6:$B$77,0)))","v":""}]
["Barron","Barron",4,96,26,122,0.78700000000000003,0,122,1,176,3,null,null,null,null,null,3,null,"","","","",""]
["Bayfield","Bayfield",3,49,31,80,0.61299999999999999,0,80,1,47,4,null,null,null,null,null,4,null,"","","","",""]
["Brown","Brown",10,86,1607,1693,5.0999999999999997E-2,1654,39,2.3E-2,802,5,null,null,null,null,null,5,null,"","","","",""]
["Buffalo","Buffalo",3,103,27,130,0.79200000000000004,0,130,1,142,6,null,null,null,null,null,6,null,"","","","",""]
["Burnett","Burnett",3,36,12,48,0.75,0,48,1,275,7,null,null,null,null,null,7,null,"","","","",""]
["Calumet","Calumet",3,223,11,234,0.95299999999999996,204,30,0.128,171,8,null,null,null,null,null,8,null,"","","","",""]
["Chippewa","Chippewa",5,132,130,262,0.504,90,172,0.65600000000000003,192,9,null,null,null,null,null,9,null,"","","","",""]
["Clark","Clark",1,16,0,16,1,0,16,1,10,10,null,null,null,null,null,10,null,"","","","",""]
["Columbia","Columbia",7,211,150,361,0.58399999999999996,198,163,0.45200000000000001,398,11,null,null,null,null,null,11,null,"","","","",""]
["Crawford","Crawford",2,46,95,141,0.32600000000000001,95,46,0.32600000000000001,110,12,null,null,null,null,null,12,null,"","","","",""]
["Dane","Dane",16,1607,1909,3516,0.45700000000000002,3472,44,1.2999999999999999E-2,2255,13,null,null,null,null,null,13,null,"","","","",""]
["Dodge","Dodge",7,44,490,534,8.2000000000000003E-2,496,38,7.0999999999999994E-2,555,14,null,null,null,null,null,14,null,"","","","",""]
["Door","Door",3,15,456,471,3.2000000000000001E-2,442,29,6.2E-2,323,15,null,null,null,null,null,15,null,"","","","",""]
["Douglas","Douglas",3,60,22,82,0.73199999999999998,0,82,1,51,16,null,null,null,null,null,16,null,"","","","",""]
["Dunn","Dunn",4,83,74,157,0.52900000000000003,31,126,0.80300000000000005,140,17,null,null,null,null,null,17,null,"","","","",""]
["Eau Claire","Eau Claire",5,803,1134,1937,0.41499999999999998,1859,78,0.04,1303,18,null,null,null,null,null,18,null,"","","","",""]
["Florence","Florence",3,128,17,145,0.88300000000000001,79,66,0.45500000000000002,161,19,null,null,null,null,null,19,null,"","","","",""]
["Fond du Lac","Fond du Lac",12,0,1877,1877,0,1835,42,2.1999999999999999E-2,906,20,null,null,null,null,null,20,null,"","","","",""]
["Forest","Forest",4,133,0,133,1,0,133,1,102,21,null,null,null,null,null,21,null,"","","","",""]
["Grant","Grant",5,500,430,930,0.53800000000000003,883,47,5.0999999999999997E-2,610,22,null,null,null,null,null,22,null,"","","","",""]
["Green","Green",2,96,0,96,1,0,96,1,79,23,null,null,null,null,null,23,null,"","","","",""]
["Green Lake","Green Lake",0,0,0,0,0,0,0,0,2,24,null,null,null,null,null,24,null,"","","","",""]
["Iowa","Iowa",2,121,0,121,1,0,121,1,99,25,null,null,null,null,null,25,null,"","","","",""]
["Iron","Iron",1,38,0,38,1,0,38,1,27,26,null,null,null,null,null,26,null,"","","","",""]
["Jackson","Jackson",2,91,0,91,1,0,91,1,55,27,null,null,null,null,null,27,null,"","","","",""]
["Jefferson","Jefferson",5,247,221,468,0.52800000000000002,414,54,0.115,401,28,null,null,null,null,null,28,null,"","","","",""]
["Juneau","Juneau",4,147,0,147,1,0,147,1,97,29,null,null,null,null,null,29,null,"","","","",""]
["Kenosha","Kenosha",2,399,381,780,0.51200000000000001,767,13,1.7000000000000001E-2,535,30,null,null,null,null,null,30,null,"","","","",""]
["Kewaunee","Kewaunee",3,13,194,207,6.3E-2,188,19,9.1999999999999998E-2,203,31]
["La Crosse","La Crosse",7,121,897,1018,0.11899999999999999,897,121,0.11899999999999999,620,32,null,null,null,null,null,"Average need out of 72.  A lower number is more needed overall:",null,null,null,null,null,{"$f":"(IFERROR(SUM(X6:X36)/COUNTIF(X6:X35,\">0\"),\"\"))","v":""}]
["Lafayette","Lafayette",4,381,8,389,0.97899999999999998,321,68,0.17499999999999999,248,33]
["Langlade","Langlade",4,111,0,111,1,0,111,1,75,34]
["Lincoln","Lincoln",4,170,5,175,0.97099999999999997,0,175,1,148,35]
["Manitowoc","Manitowoc",2,0,145,145,0,140,5,3.4000000000000002E-2,307,36]
["Marathon","Marathon",8,219,262,481,0.45500000000000002,238,243,0.505,373,37]
["Marinette","Marinette",1,32,0,32,1,0,32,1,82,38]
["Marquette","Marquette",5,117,425,542,0.216,393,149,0.27500000000000002,272,39]
["Menominee","Menominee",2,33,24,57,0.57899999999999996,0,57,1,49,40]
["Milwaukee","Milwaukee",14,546,1107,1653,0.33,1636,17,0.01,1446,41]
["Monroe","Monroe",4,186,0,186,1,0,186,1,123,42]
["Oconto","Oconto",3,51,109,160,0.31900000000000001,104,56,0.35,192,43]
["Oneida","Oneida",5,136,190,326,0.41699999999999998,184,142,0.436,222,44]
["Outagamie","Outagamie",6,191,403,594,0.32200000000000001,546,48,8.1000000000000003E-2,642,45]
["Ozaukee","Ozaukee",3,14,109,123,0.114,15,108,0.878,77,46]
["Pepin","Pepin",3,114,96,210,0.54300000000000004,0,210,1,145,47]
["Pierce","Pierce",4,114,61,175,0.65100000000000002,36,139,0.79400000000000004,187,48]
["Polk","Polk",5,98,103,201,0.48799999999999999,84,117,0.58199999999999996,136,49]
["Portage","Portage",6,231,547,778,0.29699999999999999,514,264,0.33900000000000002,351,50]
["Price","Price",5,346,581,927,0.373,793,134,0.14499999999999999,468,51]
["Racine","Racine",3,141,369,510,0.27600000000000002,474,36,7.0999999999999994E-2,149,52]
["Richland","Richland",2,311,344,655,0.47499999999999998,617,38,5.8000000000000003E-2,367,53]
["Rock","Rock",7,83,639,722,0.115,670,52,7.1999999999999995E-2,641,54]
["Rusk","Rusk",4,120,268,388,0.309,295,93,0.24,231,55]
["Sauk","Sauk",8,373,236,609,0.61199999999999999,461,148,0.24299999999999999,467,56]
["Sawyer","Sawyer",4,110,164,274,0.40100000000000002,160,114,0.41599999999999998,179,57]
["Shawano","Shawano",3,157,33,190,0.82599999999999996,0,190,1,135,58]
["Sheboygan","Sheboygan",7,223,874,1097,0.20300000000000001,1046,51,4.5999999999999999E-2,611,59]
["St Croix","St Croix",5,93,76,169,0.55000000000000004,30,139,0.82199999999999995,95,60]
["Taylor","Taylor",2,34,21,55,0.61799999999999999,0,55,1,71,61]
["Trempealeau","Trempealeau",3,33,151,184,0.17899999999999999,151,33,0.17899999999999999,121,62]
["Vernon","Vernon",4,224,425,649,0.34499999999999997,561,88,0.13600000000000001,410,63]
["Vilas","Vilas",4,143,65,208,0.68799999999999994,65,143,0.68799999999999994,137,64]
["Walworth","Walworth",4,128,136,264,0.48499999999999999,246,18,6.8000000000000005E-2,275,65]
["Washburn","Washburn",4,29,300,329,8.7999999999999995E-2,289,40,0.122,126,66]
["Washington","Washington",4,10,211,221,4.4999999999999998E-2,178,43,0.19500000000000001,158,67]
["Waukesha","Waukesha",13,490,1025,1515,0.32300000000000001,1429,86,5.7000000000000002E-2,1138,68]
["Waupaca","Waupaca",3,344,51,395,0.871,234,161,0.40799999999999997,267,69]
["Waushara","Waushara",5,188,19,207,0.90800000000000003,0,207,1,136,70]
["Winnebago","Winnebago",7,464,933,1397,0.33200000000000002,1340,57,4.1000000000000002E-2,890,71]
["Wood","Wood",2,58,0,58,1,0,58,1,73,72]
[]
[null,"Totals:",{"$f":"SUM(C6:C78)","v":324},{"$f":"SUM(D6:D78)","v":12684},{"$f":"SUM(E6:E78)","v":20783},{"$f":"SUM(F6:F78)","v":33467},{"$f":"D79/F79","v":0.37900020916126331},{"$f":"SUM(H6:H78)","v":26910},{"$f":"SUM(I6:I78)","v":6557},{"$f":"I79/F79","v":0.19592434338303402},{"$f":"SUM(K6:K78)","v":23207}]

{"sheet":"2015","index":9,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[36,17,36,22],[1,17,1,23],[2,17,2,23],[2,13,2,14],[3,13,3,14]]}
[null,2015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the county name in column \"S\" to populate QSOs & Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter County",null,"Rank"]
[null,"County","Stations","CW Qs","Phone Qs","Total Qs","% CW","Fixed Qs","Mobile Qs","% Mobile Qs","Rcvd Qs","Rank",null,null,null,{"$f":"IFERROR(IF(N4=\"\",\"\",INDEX($L$6:$L$77,MATCH(N4,$B$6:$B$77,0))),\"\")","v":""},null,"Sequence","County","CW Qs","PH Qs","Total Qs","Rcvd Qs","Rank"]
[]
["Adams","Adams",3,143,3,146,0.97899999999999998,0,146,1,104,1,null,null,null,null,null,1,null,{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,3,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,4,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,5,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,10,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",INDEX($L$6:$L$77,MATCH(S6,$B$6:$B$77,0)))","v":""}]
["Ashland","Ashland",1,0,5,5,0,0,5,1,85,2,null,null,null,null,null,2,null,{"$f":"IF(S7=\"\",\"\",VLOOKUP($S7,$B$6:$L$77,3,FALSE))","v":""},"","","",{"$f":"IF(S7=\"\",\"\",INDEX($L$6:$L$77,MATCH(S7,$B$6:$B$77,0)))","v":""}]
["Barron","Barron",3,112,267,379,0.29599999999999999,267,112,0.29599999999999999,230,3,null,null,null,null,null,3,null,"","","","",""]
["Bayfield","Bayfield",2,0,14,14,0,1,13,0.92900000000000005,28,4,null,null,null,null,null,4,null,"","","","",""]
["Brown","Brown",6,276,966,1242,0.222,1164,78,6.3E-2,756,5,null,null,null,null,null,5,null,"","","","",""]
["Buffalo","Buffalo",3,105,70,175,0.6,70,105,0.6,115,6,null,null,null,null,null,6,null,"","","","",""]
["Burnett","Burnett",1,49,0,49,1,0,49,1,32,7,null,null,null,null,null,7,null,"","","","",""]
["Calumet","Calumet",1,25,0,25,1,0,25,1,33,8,null,null,null,null,null,8,null,"","","","",""]
["Chippewa","Chippewa",2,131,0,131,1,0,131,1,126,9,null,null,null,null,null,9,null,"","","","",""]
["Clark","Clark",5,159,11,170,0.93500000000000005,0,170,1,155,10,null,null,null,null,null,10,null,"","","","",""]
["Columbia","Columbia",5,41,67,108,0.38,29,79,0.73099999999999998,85,11,null,null,null,null,null,11,null,"","","","",""]
["Crawford","Crawford",3,127,59,186,0.68300000000000005,59,127,0.68300000000000005,147,12,null,null,null,null,null,12,null,"","","","",""]
["Dane","Dane",15,1268,1839,3107,0.40799999999999997,3016,91,2.9000000000000001E-2,2016,13,null,null,null,null,null,13,null,"","","","",""]
["Dodge","Dodge",6,108,327,435,0.248,347,88,0.20200000000000001,338,14,null,null,null,null,null,14,null,"","","","",""]
["Door","Door",0,0,0,0,0,0,0,0,42,15,null,null,null,null,null,15,null,"","","","",""]
["Douglas","Douglas",1,0,47,47,0,47,0,0,39,16,null,null,null,null,null,16,null,"","","","",""]
["Dunn","Dunn",5,157,45,202,0.77700000000000002,45,157,0.77700000000000002,209,17,null,null,null,null,null,17,null,"","","","",""]
["Eau Claire","Eau Claire",5,601,1049,1650,0.36399999999999999,1531,119,7.1999999999999995E-2,837,18,null,null,null,null,null,18,null,"","","","",""]
["Florence","Florence",2,48,15,63,0.76200000000000001,0,63,1,97,19,null,null,null,null,null,19,null,"","","","",""]
["Fond du Lac","Fond du Lac",20,198,2644,2842,7.0000000000000007E-2,2749,93,3.3000000000000002E-2,1569,20,null,null,null,null,null,20,null,"","","","",""]
["Forest","Forest",2,60,40,100,0.6,0,100,1,64,21,null,null,null,null,null,21,null,"","","","",""]
["Grant","Grant",4,542,183,725,0.748,670,55,7.5999999999999998E-2,506,22,null,null,null,null,null,22,null,"","","","",""]
["Green","Green",1,47,0,47,1,0,47,1,76,23,null,null,null,null,null,23,null,"","","","",""]
["Green Lake","Green Lake",5,103,90,193,0.53400000000000003,77,116,0.60099999999999998,196,24,null,null,null,null,null,24,null,"","","","",""]
["Iowa","Iowa",1,70,0,70,1,0,70,1,42,25,null,null,null,null,null,25,null,"","","","",""]
["Iron","Iron",1,0,7,7,0,0,7,1,5,26,null,null,null,null,null,26,null,"","","","",""]
["Jackson","Jackson",5,261,2,263,0.99199999999999999,0,263,1,176,27,null,null,null,null,null,27,null,"","","","",""]
["Jefferson","Jefferson",6,198,170,368,0.53800000000000003,280,88,0.23899999999999999,301,28,null,null,null,null,null,28,null,"","","","",""]
["Juneau","Juneau",3,148,3,151,0.98,0,151,1,107,29,null,null,null,null,null,29,null,"","","","",""]
["Kenosha","Kenosha",1,358,366,724,0.49399999999999999,724,0,0,464,30,null,null,null,null,null,30,null,"","","","",""]
["Kewaunee","Kewaunee",0,0,0,0,0,0,0,0,168,31]
["La Crosse","La Crosse",6,221,455,676,0.32700000000000001,455,221,0.32700000000000001,662,32,null,null,null,null,null,"Average need out of 72.  A lower number is more needed overall:",null,null,null,null,null,{"$f":"(IFERROR(SUM(X6:X36)/COUNTIF(X6:X35,\">0\"),\"\"))","v":""}]
["Lafayette","Lafayette",3,316,6,322,0.98099999999999998,275,47,0.14599999999999999,194,33]
["Langlade","Langlade",3,74,24,98,0.755,0,98,1,81,34]
["Lincoln","Lincoln",4,90,57,147,0.61199999999999999,30,117,0.79600000000000004,197,35]
["Manitowoc","Manitowoc",1,0,325,325,0,325,0,0,147,36]
["Marathon","Marathon",7,99,234,333,0.29699999999999999,225,108,0.32400000000000001,274,37]
["Marinette","Marinette",2,102,262,364,0.28000000000000003,298,66,0.18099999999999999,244,38]
["Marquette","Marquette",4,143,188,331,0.432,221,110,0.33200000000000002,218,39]
["Menominee","Menominee",3,65,51,116,0.56000000000000005,0,116,1,93,40]
["Milwaukee","Milwaukee",19,336,1553,1889,0.17799999999999999,1816,73,3.9E-2,1568,41]
["Monroe","Monroe",3,171,0,171,1,0,171,1,274,42]
["Oconto","Oconto",5,520,80,600,0.86699999999999999,505,95,0.158,449,43]
["Oneida","Oneida",4,76,25,101,0.752,0,101,1,293,44]
["Outagamie","Outagamie",5,119,324,443,0.26900000000000002,344,99,0.223,390,45]
["Ozaukee","Ozaukee",1,8,15,23,0.34799999999999998,23,0,0,33,46]
["Pepin","Pepin",3,103,81,184,0.56000000000000005,81,103,0.56000000000000005,127,47]
["Pierce","Pierce",3,148,56,204,0.72499999999999998,56,148,0.72499999999999998,211,48]
["Polk","Polk",3,110,84,194,0.56699999999999995,84,110,0.56699999999999995,169,49]
["Portage","Portage",4,103,9,112,0.92,0,112,1,366,50]
["Price","Price",3,156,172,328,0.47599999999999998,321,7,2.1000000000000001E-2,255,51]
["Racine","Racine",3,148,70,218,0.67900000000000005,190,28,0.128,242,52]
["Richland","Richland",1,50,0,50,1,0,50,1,32,53]
["Rock","Rock",3,9,149,158,5.7000000000000002E-2,158,0,0,286,54]
["Rusk","Rusk",2,43,13,56,0.76800000000000002,0,56,1,39,55]
["Sauk","Sauk",3,67,50,117,0.57299999999999995,70,47,0.40200000000000002,166,56]
["Sawyer","Sawyer",1,0,18,18,0,0,18,1,23,57]
["Shawano","Shawano",2,111,27,138,0.80400000000000005,0,138,1,105,58]
["Sheboygan","Sheboygan",2,19,608,627,0.03,627,0,0,368,59]
["St Croix","St Croix",6,244,57,301,0.81100000000000005,96,205,0.68100000000000005,258,60]
["Taylor","Taylor",1,0,10,10,0,0,10,1,101,61]
["Trempealeau","Trempealeau",2,112,0,112,1,0,112,1,88,62]
["Vernon","Vernon",4,218,22,240,0.90800000000000003,84,156,0.65,152,63]
["Vilas","Vilas",4,10,394,404,2.5000000000000001E-2,364,40,9.9000000000000005E-2,256,64]
["Walworth","Walworth",1,0,189,189,0,189,0,0,165,65]
["Washburn","Washburn",2,47,295,342,0.13700000000000001,310,32,9.4E-2,163,66]
["Washington","Washington",3,57,218,275,0.20699999999999999,218,57,0.20699999999999999,269,67]
["Waukesha","Waukesha",15,398,1553,1951,0.20399999999999999,1867,84,4.2999999999999997E-2,1372,68]
["Waupaca","Waupaca",2,77,0,77,1,0,77,1,65,69]
["Waushara","Waushara",4,177,11,188,0.94099999999999995,0,188,1,163,70]
["Winnebago","Winnebago",7,585,1134,1719,0.34,1590,129,7.4999999999999997E-2,1160,71]
["Wood","Wood",4,175,12,187,0.93600000000000005,0,187,1,145,72]
[]
[null,"Totals:",{"$f":"SUM(C6:C78)","v":276},{"$f":"SUM(D6:D78)","v":10842},{"$f":"SUM(E6:E78)","v":17120},{"$f":"SUM(F6:F78)","v":27962},{"$f":"D79/F79","v":0.38774050497103213},{"$f":"SUM(H6:H78)","v":21898},{"$f":"SUM(I6:I78)","v":6064},{"$f":"I79/F79","v":0.21686574637007366},{"$f":"SUM(K6:K78)","v":21011}]

{"sheet":"2014","index":10,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[36,17,36,22],[1,17,1,23],[2,17,2,23],[2,13,2,14],[3,13,3,14]]}
[null,2014]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the county name in column \"S\" to populate QSOs & Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter County",null,"Rank"]
[null,"County","Stations","CW Qs","Phone Qs","Total Qs","% CW","Fixed Qs","Mobile Qs","% Mobile Qs","Rcvd Qs","Rank",null,null,null,{"$f":"IFERROR(IF(N4=\"\",\"\",INDEX($L$6:$L$77,MATCH(N4,$B$6:$B$77,0))),\"\")","v":""},null,"Sequence","County","CW Qs","PH Qs","Total Qs","Rcvd Qs","Rank"]
[]
["Adams","Adams",2,52,4,56,0.92900000000000005,0,56,1,46,1,null,null,null,null,null,1,null,{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,3,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,4,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,5,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,10,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",INDEX($L$6:$L$77,MATCH(S6,$B$6:$B$77,0)))","v":""}]
["Ashland","Ashland",1,57,0,57,1,0,57,1,50,2,null,null,null,null,null,2,null,{"$f":"IF(S7=\"\",\"\",VLOOKUP($S7,$B$6:$L$77,3,FALSE))","v":""},"","","",{"$f":"IF(S7=\"\",\"\",INDEX($L$6:$L$77,MATCH(S7,$B$6:$B$77,0)))","v":""}]
["Barron","Barron",3,125,0,125,1,0,125,1,184,3,null,null,null,null,null,3,null,"","","","",""]
["Bayfield","Bayfield",1,40,0,40,1,0,40,1,69,4,null,null,null,null,null,4,null,"","","","",""]
["Brown","Brown",8,212,682,894,0.23699999999999999,745,149,0.16700000000000001,673,5,null,null,null,null,null,5,null,"","","","",""]
["Buffalo","Buffalo",4,151,60,211,0.71599999999999997,55,156,0.73899999999999999,167,6,null,null,null,null,null,6,null,"","","","",""]
["Burnett","Burnett",3,49,55,104,0.47099999999999997,55,49,0.47099999999999997,376,7,null,null,null,null,null,7,null,"","","","",""]
["Calumet","Calumet",6,297,316,613,0.48499999999999999,566,47,7.6999999999999999E-2,369,8,null,null,null,null,null,8,null,"","","","",""]
["Chippewa","Chippewa",2,159,0,159,1,0,159,1,183,9,null,null,null,null,null,9,null,"","","","",""]
["Clark","Clark",0,0,0,0,0,0,0,0,18,10,null,null,null,null,null,10,null,"","","","",""]
["Columbia","Columbia",2,100,71,171,0.58499999999999996,115,56,0.32700000000000001,213,11,null,null,null,null,null,11,null,"","","","",""]
["Crawford","Crawford",3,63,131,194,0.32500000000000001,125,69,0.35599999999999998,195,12,null,null,null,null,null,12,null,"","","","",""]
["Dane","Dane",16,1147,1940,3087,0.372,3032,55,1.7999999999999999E-2,2268,13,null,null,null,null,null,13,null,"","","","",""]
["Dodge","Dodge",3,24,348,372,6.5000000000000002E-2,370,2,5.0000000000000001E-3,251,14,null,null,null,null,null,14,null,"","","","",""]
["Door","Door",1,28,0,28,1,0,28,1,146,15,null,null,null,null,null,15,null,"","","","",""]
["Douglas","Douglas",3,204,258,462,0.442,421,41,8.8999999999999996E-2,305,16,null,null,null,null,null,16,null,"","","","",""]
["Dunn","Dunn",4,102,108,210,0.48599999999999999,108,102,0.48599999999999999,172,17,null,null,null,null,null,17,null,"","","","",""]
["Eau Claire","Eau Claire",3,493,557,1050,0.47,1002,48,4.5999999999999999E-2,770,18,null,null,null,null,null,18,null,"","","","",""]
["Florence","Florence",2,104,0,104,1,0,104,1,149,19,null,null,null,null,null,19,null,"","","","",""]
["Fond du Lac","Fond du Lac",16,121,2153,2274,5.2999999999999999E-2,2245,29,1.2999999999999999E-2,1509,20,null,null,null,null,null,20,null,"","","","",""]
["Forest","Forest",4,365,129,494,0.73899999999999999,357,137,0.27700000000000002,384,21,null,null,null,null,null,21,null,"","","","",""]
["Grant","Grant",6,612,503,1115,0.54900000000000004,1024,91,8.2000000000000003E-2,860,22,null,null,null,null,null,22,null,"","","","",""]
["Green","Green",3,142,8,150,0.94699999999999995,0,150,1,275,23,null,null,null,null,null,23,null,"","","","",""]
["Green Lake","Green Lake",2,88,2,90,0.97799999999999998,0,90,1,79,24,null,null,null,null,null,24,null,"","","","",""]
["Iowa","Iowa",3,153,3,156,0.98099999999999998,0,156,1,155,25,null,null,null,null,null,25,null,"","","","",""]
["Iron","Iron",2,47,21,68,0.69099999999999995,21,47,0.69099999999999995,54,26,null,null,null,null,null,26,null,"","","","",""]
["Jackson","Jackson",1,66,0,66,1,0,66,1,53,27,null,null,null,null,null,27,null,"","","","",""]
["Jefferson","Jefferson",2,238,0,238,1,238,0,0,298,28,null,null,null,null,null,28,null,"","","","",""]
["Juneau","Juneau",2,98,4,102,0.96099999999999997,0,102,1,134,29,null,null,null,null,null,29,null,"","","","",""]
["Kenosha","Kenosha",1,374,374,748,0.5,748,0,0,453,30,null,null,null,null,null,30,null,"","","","",""]
["Kewaunee","Kewaunee",3,77,104,181,0.42499999999999999,104,77,0.42499999999999999,288,31]
["La Crosse","La Crosse",2,54,22,76,0.71099999999999997,22,54,0.71099999999999997,140,32,null,null,null,null,null,"Average need out of 72.  A lower number is more needed overall:",null,null,null,null,null,{"$f":"(IFERROR(SUM(X6:X36)/COUNTIF(X6:X35,\">0\"),\"\"))","v":""}]
["Lafayette","Lafayette",5,374,443,817,0.45800000000000002,717,100,0.122,363,33]
["Langlade","Langlade",4,142,30,172,0.82599999999999996,0,172,1,137,34]
["Lincoln","Lincoln",5,140,40,180,0.77800000000000002,17,163,0.90600000000000003,246,35]
["Manitowoc","Manitowoc",3,70,320,390,0.17899999999999999,320,70,0.17899999999999999,419,36]
["Marathon","Marathon",6,155,282,437,0.35499999999999998,273,164,0.375,448,37]
["Marinette","Marinette",2,97,0,97,1,0,97,1,135,38]
["Marquette","Marquette",4,166,317,483,0.34399999999999997,328,155,0.32100000000000001,447,39]
["Menominee","Menominee",2,100,0,100,1,0,100,1,76,40]
["Milwaukee","Milwaukee",14,297,1201,1498,0.19800000000000001,1498,0,0,1554,41]
["Monroe","Monroe",1,45,0,45,1,0,45,1,66,42]
["Oconto","Oconto",4,382,237,619,0.61699999999999999,576,43,6.9000000000000006E-2,429,43]
["Oneida","Oneida",4,120,124,244,0.49199999999999999,100,144,0.59,185,44]
["Outagamie","Outagamie",7,190,393,583,0.32600000000000001,530,53,9.0999999999999998E-2,621,45]
["Ozaukee","Ozaukee",2,12,304,316,3.7999999999999999E-2,316,0,0,171,46]
["Pepin","Pepin",4,114,158,272,0.41899999999999998,153,119,0.438,182,47]
["Pierce","Pierce",4,95,46,141,0.67400000000000004,0,141,1,191,48]
["Polk","Polk",4,98,45,143,0.68500000000000005,45,98,0.68500000000000005,167,49]
["Portage","Portage",6,500,499,999,0.501,859,140,0.14000000000000001,773,50]
["Price","Price",3,295,159,454,0.65,385,69,0.152,400,51]
["Racine","Racine",1,95,28,123,0.77200000000000002,123,0,0,169,52]
["Richland","Richland",2,114,3,117,0.97399999999999998,0,117,1,100,53]
["Rock","Rock",7,134,385,519,0.25800000000000001,443,76,0.14599999999999999,383,54]
["Rusk","Rusk",3,113,86,199,0.56799999999999995,86,113,0.56799999999999995,213,55]
["Sauk","Sauk",6,262,313,575,0.45600000000000002,489,86,0.15,624,56]
["Sawyer","Sawyer",1,74,0,74,1,0,74,1,105,57]
["Shawano","Shawano",2,140,0,140,1,0,140,1,119,58]
["Sheboygan","Sheboygan",4,40,906,946,4.2000000000000003E-2,906,40,4.2000000000000003E-2,483,59]
["St Croix","St Croix",3,96,4,100,0.96,0,100,1,96,60]
["Taylor","Taylor",1,30,0,30,1,0,30,1,67,61]
["Trempealeau","Trempealeau",2,50,305,355,0.14099999999999999,305,50,0.14099999999999999,233,62]
["Vernon","Vernon",6,157,470,627,0.25,501,126,0.20100000000000001,367,63]
["Vilas","Vilas",3,49,250,299,0.16400000000000001,248,51,0.17100000000000001,229,64]
["Walworth","Walworth",1,0,392,392,0,392,0,0,249,65]
["Washburn","Washburn",3,55,255,310,0.17699999999999999,258,52,0.16800000000000001,174,66]
["Washington","Washington",3,0,330,330,0,330,0,0,419,67]
["Waukesha","Waukesha",6,95,714,809,0.11700000000000001,809,0,0,649,68]
["Waupaca","Waupaca",3,234,408,642,0.36399999999999999,595,47,7.2999999999999995E-2,402,69]
["Waushara","Waushara",4,147,24,171,0.86,0,171,1,158,70]
["Winnebago","Winnebago",8,612,661,1273,0.48099999999999998,1191,82,6.4000000000000001E-2,1084,71]
["Wood","Wood",0,0,0,0,0,0,0,0,7,72]
[]
[null,"Totals:",{"$f":"SUM(C6:C78)","v":267},{"$f":"SUM(D6:D78)","v":11731},{"$f":"SUM(E6:E78)","v":17985},{"$f":"SUM(F6:F78)","v":29716},{"$f":"D79/F79","v":0.39477049400996095},{"$f":"SUM(H6:H78)","v":24146},{"$f":"SUM(I6:I78)","v":5570},{"$f":"I79/F79","v":0.18744110916677884},{"$f":"SUM(K6:K78)","v":24626}]

{"sheet":"2013","index":11,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[36,17,36,22],[1,17,1,23],[2,17,2,23],[3,13,3,14],[2,13,2,14]]}
[null,2013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the county name in column \"S\" to populate QSOs & Rank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter County",null,"Rank"]
[null,"County","Stations","CW Qs","Phone Qs","Total Qs","% CW","Fixed Qs","Mobile Qs","% Mobile Qs","Rcvd Qs","Rank",null,null,null,{"$f":"IFERROR(IF(N4=\"\",\"\",INDEX($L$6:$L$77,MATCH(N4,$B$6:$B$77,0))),\"\")","v":""},null,"Sequence","County","CW Qs","PH Qs","Total Qs","Rcvd Qs","Rank"]
[]
["Adams","Adams",1,41,0,41,1,0,41,1,61,1,null,null,null,null,null,1,null,{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,3,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,4,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,5,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",VLOOKUP($S6,$B$6:$L$77,10,FALSE))","v":""},{"$f":"IF(S6=\"\",\"\",INDEX($L$6:$L$77,MATCH(S6,$B$6:$B$77,0)))","v":""}]
["Ashland","Ashland",4,79,204,283,0.27900000000000003,185,98,0.34599999999999997,196,2,null,null,null,null,null,2,null,{"$f":"IF(S7=\"\",\"\",VLOOKUP($S7,$B$6:$L$77,3,FALSE))","v":""},"","","",{"$f":"IF(S7=\"\",\"\",INDEX($L$6:$L$77,MATCH(S7,$B$6:$B$77,0)))","v":""}]
["Barron","Barron",5,194,122,316,0.61399999999999999,116,200,0.63300000000000001,287,3,null,null,null,null,null,3,null,"","","","",""]
["Bayfield","Bayfield",2,52,11,63,0.82499999999999996,0,63,1,46,4,null,null,null,null,null,4,null,"","","","",""]
["Brown","Brown",8,151,1248,1399,0.108,1298,101,7.1999999999999995E-2,1133,5,null,null,null,null,null,5,null,"","","","",""]
["Buffalo","Buffalo",3,134,12,146,0.91800000000000004,0,146,1,161,6,null,null,null,null,null,6,null,"","","","",""]
["Burnett","Burnett",4,37,69,106,0.34899999999999998,67,39,0.36799999999999999,443,7,null,null,null,null,null,7,null,"","","","",""]
["Calumet","Calumet",5,345,73,418,0.82499999999999996,298,120,0.28699999999999998,326,8,null,null,null,null,null,8,null,"","","","",""]
["Chippewa","Chippewa",4,191,46,237,0.80600000000000005,0,237,1,241,9,null,null,null,null,null,9,null,"","","","",""]
["Clark","Clark",3,21,66,87,0.24099999999999999,12,75,0.86199999999999999,64,10,null,null,null,null,null,10,null,"","","","",""]
["Columbia","Columbia",3,73,117,190,0.38400000000000001,165,25,0.13200000000000001,164,11,null,null,null,null,null,11,null,"","","","",""]
["Crawford","Crawford",0,0,0,0,0,0,0,0,0,12,null,null,null,null,null,12,null,"","","","",""]
["Dane","Dane",17,1680,2340,4020,0.41799999999999998,3962,58,1.4E-2,2631,13,null,null,null,null,null,13,null,"","","","",""]
["Dodge","Dodge",2,319,588,907,0.35199999999999998,907,0,0,563,14,null,null,null,null,null,14,null,"","","","",""]
["Door","Door",0,0,0,0,0,0,0,0,159,15,null,null,null,null,null,15,null,"","","","",""]
["Douglas","Douglas",2,187,10,197,0.94899999999999995,172,25,0.127,192,16,null,null,null,null,null,16,null,"","","","",""]
["Dunn","Dunn",5,171,17,188,0.91,0,188,1,158,17,null,null,null,null,null,17,null,"","","","",""]
["Eau Claire","Eau Claire",5,1070,1028,2098,0.51,1967,131,6.2E-2,1163,18,null,null,null,null,null,18,null,"","","","",""]
["Florence","Florence",1,56,12,68,0.82399999999999995,0,68,1,109,19,null,null,null,null,null,19,null,"","","","",""]
["Fond du Lac","Fond du Lac",16,416,1992,2408,0.17299999999999999,2330,78,3.2000000000000001E-2,1340,20,null,null,null,null,null,20,null,"","","","",""]
["Forest","Forest",1,77,1,78,0.98699999999999999,0,78,1,54,21,null,null,null,null,null,21,null,"","","","",""]
["Grant","Grant",5,679,457,1136,0.59799999999999998,1116,20,1.7999999999999999E-2,805,22,null,null,null,null,null,22,null,"","","","",""]
["Green","Green",2,0,695,695,0,695,0,0,417,23,null,null,null,null,null,23,null,"","","","",""]
["Green Lake","Green Lake",4,151,404,555,0.27200000000000002,443,112,0.20200000000000001,364,24,null,null,null,null,null,24,null,"","","","",""]
["Iowa","Iowa",1,53,2,55,0.96399999999999997,0,55,1,43,25,null,null,null,null,null,25,null,"","","","",""]
["Iron","Iron",3,45,590,635,7.0999999999999994E-2,571,64,0.10100000000000001,293,26,null,null,null,null,null,26,null,"","","","",""]
["Jackson","Jackson",2,147,0,147,1,0,147,1,113,27,null,null,null,null,null,27,null,"","","","",""]
["Jefferson","Jefferson",2,235,36,271,0.86699999999999999,271,0,0,322,28,null,null,null,null,null,28,null,"","","","",""]
["Juneau","Juneau",2,26,60,86,0.30199999999999999,0,86,1,45,29,null,null,null,null,null,29,null,"","","","",""]
["Kenosha","Kenosha",2,0,428,428,0,428,0,0,213,30,null,null,null,null,null,30,null,"","","","",""]
["Kewaunee","Kewaunee",2,0,307,307,0,307,0,0,273,31]
["La Crosse","La Crosse",6,124,301,425,0.29199999999999998,300,125,0.29399999999999998,425,32,null,null,null,null,null,"Average need out of 72.  A lower number is more needed overall:",null,null,null,null,null,{"$f":"(IFERROR(SUM(X6:X36)/COUNTIF(X6:X35,\">0\"),\"\"))","v":""}]
["Lafayette","Lafayette",5,373,194,567,0.65800000000000003,541,26,4.5999999999999999E-2,381,33]
["Langlade","Langlade",1,129,0,129,1,0,129,1,95,34]
["Lincoln","Lincoln",4,137,84,221,0.62,0,221,1,158,35]
["Manitowoc","Manitowoc",6,139,691,830,0.16700000000000001,682,148,0.17799999999999999,622,36]
["Marathon","Marathon",6,74,627,701,0.106,561,140,0.2,552,37]
["Marinette","Marinette",1,281,107,388,0.72399999999999998,388,0,0,370,38]
["Marquette","Marquette",3,109,33,142,0.76800000000000002,0,142,1,177,39]
["Menominee","Menominee",1,100,1,101,0.99,0,101,1,74,40]
["Milwaukee","Milwaukee",17,1071,2477,3548,0.30199999999999999,3515,33,8.9999999999999993E-3,2448,41]
["Monroe","Monroe",2,49,24,73,0.67100000000000004,0,73,1,49,42]
["Oconto","Oconto",1,339,0,339,1,339,0,0,279,43]
["Oneida","Oneida",4,139,204,343,0.40500000000000003,146,197,0.57399999999999995,350,44]
["Outagamie","Outagamie",6,53,444,497,0.107,454,43,8.6999999999999994E-2,507,45]
["Ozaukee","Ozaukee",2,59,47,106,0.55700000000000005,46,60,0.56599999999999995,177,46]
["Pepin","Pepin",4,87,223,310,0.28100000000000003,211,99,0.31900000000000001,287,47]
["Pierce","Pierce",4,66,100,166,0.39800000000000002,100,66,0.39800000000000002,158,48]
["Polk","Polk",4,162,97,259,0.625,97,162,0.625,243,49]
["Portage","Portage",4,440,408,848,0.51900000000000002,736,112,0.13200000000000001,591,50]
["Price","Price",2,93,13,106,0.877,0,106,1,355,51]
["Racine","Racine",1,74,227,301,0.246,301,0,0,261,52]
["Richland","Richland",0,0,0,0,0,0,0,0,0,53]
["Rock","Rock",4,355,821,1176,0.30199999999999999,1176,0,0,648,54]
["Rusk","Rusk",4,192,48,240,0.8,40,200,0.83299999999999996,168,55]
["Sauk","Sauk",3,55,85,140,0.39300000000000002,44,96,0.68600000000000005,141,56]
["Sawyer","Sawyer",3,166,13,179,0.92700000000000005,0,179,1,174,57]
["Shawano","Shawano",1,113,0,113,1,0,113,1,90,58]
["Sheboygan","Sheboygan",5,396,285,681,0.58099999999999996,614,67,9.8000000000000004E-2,674,59]
["St Croix","St Croix",4,393,98,491,0.8,324,167,0.34,423,60]
["Taylor","Taylor",3,70,58,128,0.54700000000000004,0,128,1,187,61]
["Trempealeau","Trempealeau",2,69,12,81,0.85199999999999998,0,81,1,131,62]
["Vernon","Vernon",4,58,456,514,0.113,473,41,0.08,299,63]
["Vilas","Vilas",3,153,25,178,0.86,0,178,1,131,64]
["Walworth","Walworth",1,0,369,369,0,369,0,0,222,65]
["Washburn","Washburn",3,68,13,81,0.84,0,81,1,103,66]
["Washington","Washington",4,10,463,473,2.1000000000000001E-2,473,0,0,409,67]
["Waukesha","Waukesha",10,738,1378,2116,0.34899999999999998,2116,0,0,1539,68]
["Waupaca","Waupaca",4,268,156,424,0.63200000000000001,312,112,0.26400000000000001,320,69]
["Waushara","Waushara",2,69,49,118,0.58499999999999996,0,118,1,132,70]
["Winnebago","Winnebago",5,421,727,1148,0.36699999999999999,1071,77,6.7000000000000004E-2,941,71]
["Wood","Wood",1,7,0,7,1,7,0,0,75,72]
[]
[null,"Totals:",{"$f":"SUM(C6:C78)","v":266},{"$f":"SUM(D6:D78)","v":14329},{"$f":"SUM(E6:E78)","v":22293},{"$f":"SUM(F6:F78)","v":36622},{"$f":"D79/F79","v":0.39126754409917536},{"$f":"SUM(H6:H78)","v":30746},{"$f":"SUM(I6:I78)","v":5876},{"$f":"I79/F79","v":0.16045000273059909},{"$f":"SUM(K6:K78)","v":27745}]

{"sheet":"Notes","index":12,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"NOTES:"]
[null,"Click the blue Sort buttons at the top of any column to arrange the information from smallest to largest values. The sorted "]
[null,"column header will highlight in yellow to indicate which sort was last applied."]
[]
[null,"Except for the last column, all counts are the transmitted counts from all logs submitted. The last column is the received "]
[null,"QSO count from each county. The difference reflects the fact that many stations do not submit logs. If everyone submitted "]
[null,"a log, the transmitted counts and received counts would be equal. "]
[]
[null,"The All Years worksheet is a composite of all the individual worksheets. It gives an idea of the action in each county over multiple years. "]
[]
[null,"This workbook (Rev 2) was created by Robert Chudek - K0RC on 5-Feb-2024"]
[]
[null,null,"INSTRUCTIONS:"]
[null,null,"1) The BLUE buttons at the top of columns B through K will sort the table from smallest to largest values in the selected column"]
[null,null,"2) The sorted column header will highlight in YELLOW to identify the most recent sort"]
[null,null,"3) The sorts allow you to compare which counties were less represented on CW, Phone, Total Qs, or other columns"]
[null,null,"4) Enter a county name in cell N4 (or use the picklist) to quickly reveal its rank within the 72 counties (within the current sort you selected)"]
[null,null,"5) A lower ranking number indicates a more rare county, i.e. the sort is most rare to most popular (top to bottom)"]
[null,null,"6) Column S can be used to compare the \"rarity\" among different counties. Enter a few county names to reveal their relative rarity"]
[null,null,"7) The rarity comparison will depend upon the column sort that was chosen with the BLUE sort buttons"]
[null,null,"8) This allows you to quickly compare CW vs Phone modes or other criteria of your choosing"]
[null,null,"9) All of the above functions work the same for the individual years as well as the \"All Years\" worksheets"]
[null,null,"10) On the \"All Years\" worksheet Tylor and Door counties have been pre-entered in cell N4 to show they rank 1st and 3rd in \"rarity\""]
[null,null,"11) On the \"All Years\" worksheet  Grant has been pre-entered in column S and shows it ranks  66th out of 72 indicating it is not very rare"]
[null,null,"12) You can sort on the CW or Phone columns and you will see their ranking changes in comparison to the Total Qs sort"]
[null,null,"13) You can perform this same function on the individual years too. This will show the variation in what is rare from year to year"]
[null,null,"14) This ranking will change, depending whether you sort on the CW, Phone, Totas Qs or other colums"]