{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MPF12","field entry","dropdownlistinfo"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":27,"comments":0,"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":"MPF12","index":0,"n_rows":120,"n_cols":14,"rows_kept":120,"cut":false,"hidden":false,"merged":[[115,0,115,13],[117,0,117,13],[118,0,118,13],[75,0,75,13],[76,0,76,13],[113,0,113,13],[15,0,15,13],[51,2,51,3],[52,2,52,3],[54,0,55,1],[54,2,55,3],[54,9,54,13],[55,9,55,13],[16,0,17,0],[50,2,50,3],[16,13,17,13],[54,4,54,6],[16,3,16,4],[49,4,49,13],[16,1,17,1],[16,2,17,2],[49,0,49,1],[50,4,50,6],[50,8,50,13],[50,0,50,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,7,54,8],[55,7,55,8],[55,5,55,6],[56,0,56,3],[56,4,56,8],[56,9,56,13],[53,2,53,3],[58,0,58,13],[51,4,53,13],[69,0,69,13],[70,0,70,13],[59,0,59,13],[57,0,57,3],[57,4,57,8],[71,0,71,13],[66,0,66,13],[68,0,68,13],[65,0,65,13],[57,9,57,13],[60,0,60,13],[0,0,0,13],[2,0,2,13],[3,0,3,13],[5,0,5,3],[1,0,1,1],[6,4,6,6],[6,7,6,8],[6,9,6,10],[11,10,11,12],[11,4,12,8],[6,1,6,3],[6,11,6,13],[9,7,9,8],[8,7,8,8],[8,4,8,6],[8,10,8,13],[9,10,9,13],[49,2,49,3],[16,6,17,6],[16,7,17,7],[16,8,17,8],[10,9,10,13],[13,9,13,10],[13,11,13,13],[12,10,12,12],[14,0,14,13],[10,4,10,6],[11,0,11,1],[12,0,12,1],[7,9,7,11],[72,0,72,13],[119,0,119,13],[4,10,4,13],[5,9,5,13],[5,4,5,8],[10,7,10,8],[62,0,62,13],[64,0,64,13],[16,10,16,11],[7,0,8,0],[9,0,10,0],[7,1,8,3],[9,1,10,3],[13,1,13,3],[13,4,13,5],[13,6,13,8],[7,12,7,13],[7,7,7,8],[7,4,7,6],[9,4,9,6],[16,5,17,5],[16,9,17,9],[16,12,17,12]]}
["Minnesota Department of Transportation   -   Bridge Office"]
[{"$f":"IF(AND(MIN(bpf)<24,MIN(bpf)>0),\"TRUE\",\"FALSE\")","v":"FALSE"},null,{"$f":"IF(MAX(bpf)>180,\"TRUE\",\"FALSE\")","v":"FALSE"},null,{"$f":"IF(MAX(penet)>5,\"TRUE\",\"FALSE\")","v":"FALSE"}]
["TEST PILE REPORT"]
["(MPF12)"]
[null,null,null,null,null,null,null,null,null,null,"SEE INSTRUCTIONS ON BACK SIDE"]
["PILE HAMMER DATA",null,null,null,"PILE DATA",null,null,null,null,"PROJECT DESCRIPTION"]
["TYPE:","SINGLE ACTING (Power)",null,null,"TEST PILE NO.:",null,null,null,null,"BRIDGE NO.:"]
["MAKE:",null,null,null,"TEST PILE TYPE:",null,null,"SELECT A PILE TYPE",null,"S.P. (OR S.A.P.) NO.:"]
[null,null,null,null,"SIZE:",null,null,"SELECT A SIZE",null,"COUNTY:",{"$f":"IF(ISBLANK(L7),\"SELECT A COUNTY\",VLOOKUP(LEFT(L7,2),dropdownlistinfo!H5:J91,2))","v":"SELECT A COUNTY"}]
["MODEL:",null,null,null,"LENGTH IN LEADS (FT):",null,null,null,null,"DIST.:",{"$f":"IF(ISBLANK(L7),\"SELECT A DISTRICT\",VLOOKUP(LEFT(L7,2),dropdownlistinfo!H5:J91,3))","v":"SELECT A DISTRICT"}]
[null,null,null,null,"CUT-OFF ELEV. (FT):",null,null,null,null,"SUBSTRUCTURE"]
["WT. RAM (PISTON):",null,null,"(lbs.)",{"$f":"IF(MAX(bpf)>180,\"MAX BLOW/FT VALUE TO BE USED IN MPF12 IS 180. WHEN ENTRY EXCEEDS 180, 180 USED IN BEARING CALCULATIONS\",IF(AND(MIN(last10)<0.66666,MIN(last10)>0),\"MIN PEN/INCH TO BE USED IN MPF12 IS 0.066. WHEN ENTRY IS LESS THAN 0.066, 0.066 IS USED IN BEARING CALCS.\",\"\"))","v":""},null,null,null,null,"ABUTMENT:"," "]
["MAX. RATED ENERGY:",null,null,"(ft.lbs.)",null,null,null,null,null,"PIER NO.:"," "]
["INSP BY:",null,null,null,"INSP. PHONE NO:",null,null,null,null,"CONTRACTOR:"]
[{"$f":"IF(ISBLANK($C$13),IF(AND(ISBLANK($C$13),MAX(drop)>0),\"ENTER MAX RATED ENERGY\",\"\"),IF(MAX(energy)=0.85*$C$13,\"ENERGY EXCEEDS 85% OF MAX RATED ENERGY, USING 85% IN BEARING CALCULATIONS\",\"\"))","v":""}]
[{"$f":"IF(error1=\"TRUE\",\"MPF12 IS NOT VALID BELOW 24 BPF. BEARING VALUES SHOWN FOR INFORMATION ONLY. CONSULT 2452 E.3\",IF(error3=\"TRUE\",\"MPF12 IS NOT VALID ABOVE 0.5 IN/BLOW. BEARING VALUES SHOWN FOR INFORMATION ONLY. CONSULT 2452.E.3\",\"\"))","v":""}]
["DISTANCE\nBELOW\nCUT-OFF\n(feet)","DROP OF\nHAMMER\nOR RAM\n(feet)","ENERGY\nPER\nBLOW\n(ft. lbs.)","BLOWS",null,"PENET.\nPER\nBLOW\n(inches)","BEARING\nIN TONS","DISTANCE\nBELOW\nCUT-OFF\n(feet)","DROP OF\nHAMMER\nOR RAM\n(feet)","ENERGY\nPER\nBLOW\n(ft. lbs.)","BLOWS",null,"PENET.\nPER\nBLOW\n(inches)","BEARING\nIN TONS"]
[null,null,null,"PER FOOT","PENET IN LAST 10 (inches)",null,null,null,null,null,"PER FOOT","PENET IN LAST 10 (inches)"]
[null,null,{"$f":"IF(OR(B19=\"\",$C$12=\"\",$C$13=\"\"),\"\",IF($C$12*B19<0.85*$C$13,$C$12*B19,0.85*$C$13))","v":""},null,null,{"$f":"IF(D19=\"\",IF(E19=\"\",\"\",E19/10),12/D19)","v":""},{"$f":"IF(OR(F19=\"\",C19=\"\"),\"\",20*SQRT(C19/1000)*LOG(10/MAX(F19,0.0666666)))","v":""},null,null,{"$f":"IF(OR(I19=\"\",$C$12=\"\",$C$13=\"\"),\"\",IF($C$12*I19<0.85*$C$13,$C$12*I19,0.85*$C$13))","v":""},null,null,{"$f":"IF(K19=\"\",IF(L19=\"\",\"\",L19/10),12/K19)","v":""},{"$f":"IF(OR(M19=\"\",J19=\"\"),\"\",20*SQRT(J19/1000)*LOG(10/MAX(M19,0.0666666)))","v":""}]
[null,null,{"$f":"IF(OR(B20=\"\",$C$12=\"\",$C$13=\"\"),\"\",IF($C$12*B20<0.85*$C$13,$C$12*B20,0.85*$C$13))","v":""},null,null,"","",null,null,{"$f":"IF(OR(I20=\"\",$C$12=\"\",$C$13=\"\"),\"\",IF($C$12*I20<0.85*$C$13,$C$12*I20,0.85*$C$13))","v":""},null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,"",null,null,"","",null,null,"",null,null,"",""]
[null,null,null,null,null,{"$f":"IF(D49=\"\",\"\",12/D49)","v":""}]
["DATE:",null,null,null,"REMARKS ON DRIVING CONDITIONS, PRE-BORING, ETC. (IDENTIFY BY PENET. DISTANCE.)"]
["START DRIVING TIME:",null,null,null,"SETUP INCREASE (%)"]
["END DRIVING TIME:"]
["DOWN TIME:"]
["TOTAL DRIVING TIME:"]
["FORMULA USED",null,"MPF12",null,"MPF12  Rn (tons)",null,null,"MIN. TIP ELEVATION",null,"PDA  Rn (tons)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E56),\"\",CONCATENATE(\"(115%) = \",ROUND(E56*1.15,0)))","v":""}]
["INSPECTOR SIGNATURE",null,null,null,"PROJECT ENGINEER SIGNATURE",null,null,null,null,"BRIDGE OFFICE (Initial and Date)"]
[]
[]
["INSTRUCTIONS FOR COMPLETING "]
["TEST PILE REPORT"]
["Pile Data:"]
["     1.  Select type of pile as CIP, H-Pile, Treated Timber, Precast Concrete, etc."]
["     2.  Show Size of pile; when using timber pile show butt and tip size to the nearest one-half inch.  Be certain that"]
["          diameters comply with the specifications.  Butt diameters should be measured 3 feet from the butt end."]
["     3.  Length in Leads should be total length in leads in feet."]
["     4.  INSP. BY should be the pile driving inspector (print or type name)."]
[]
["Column Tabulation:"]
["     5.  ENERGY PER BLOW (ft. lbs.)  is equal to WH, for single acting power-driven hammers.  "]
["     6.  PENET. PER BLOW (inches) may be based on blows per foot or on a measured penetration for a given number "]
["          of blows, and should be calculated in inches and decimals of inches."]
["     7.  BEARING IN TONS should be shown to the nearest ton."]
[]
[]
["SHOW SKETCH BELOW"]
["Show sketch indicating location of test pile.  Show North arrow."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DISTRIBUTION:"]
["State Projects:"]
["Original:  MNDOT Bridge Const. & Maint. Engineer  (MS 610)"]
["Email:  BridgeForms.DOT@state.mn.us"]
["County or Municipal Projects:"]
["Original: County or Municipal Engineer"]
["Railroad Projects:"]
["Copy:  Railroad"]
["Copy:  Engineer"]

{"sheet":"field entry","index":1,"n_rows":112,"n_cols":14,"rows_kept":112,"cut":false,"hidden":true,"merged":[[117,0,117,13],[118,0,118,13],[111,0,111,13],[113,0,113,13],[114,0,114,13],[116,0,116,13],[56,0,56,13],[73,0,73,13],[60,0,60,13],[61,0,61,13],[62,0,62,13],[63,0,63,13],[65,0,65,13],[66,0,66,13],[67,0,67,13],[68,0,68,13],[69,0,69,13],[72,0,72,13],[51,0,52,1],[51,2,52,3],[51,4,51,6],[58,0,58,13],[51,9,51,13],[52,4,52,6],[52,7,52,8],[52,9,52,13],[53,0,53,3],[53,4,53,8],[53,9,53,13],[51,7,51,8],[54,0,54,3],[54,4,54,8],[54,9,54,13],[55,0,55,13],[14,10,14,11],[14,0,15,0],[47,0,47,1],[47,2,47,3],[48,0,48,1],[48,2,48,3],[47,4,47,6],[48,4,50,13],[47,8,47,13],[46,0,46,1],[46,2,46,3],[46,4,46,13],[50,0,50,1],[50,2,50,3],[49,0,49,1],[49,2,49,3],[11,0,11,3],[11,4,11,8],[11,9,11,13],[10,9,10,13],[10,4,10,8],[5,4,5,8],[5,9,5,13],[7,9,7,13],[9,0,9,3],[9,4,9,8],[8,4,8,8],[8,9,8,11],[8,12,8,13],[7,1,7,3],[6,9,6,13],[7,4,7,8],[8,1,8,3],[5,0,6,3],[0,0,0,13],[1,0,1,1],[2,0,2,13],[3,0,3,13],[4,10,4,13],[12,0,12,3],[12,4,12,8],[12,9,12,13],[14,1,15,1],[14,2,15,2],[14,5,15,5],[14,13,15,13],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[13,0,13,3],[13,4,13,8],[13,9,13,13],[14,12,15,12],[14,3,14,4],[110,0,110,13],[115,0,115,13],[104,0,104,13],[105,0,105,13],[106,0,106,13],[107,0,107,13],[109,0,109,13]]}
["Minnesota Department of Transportation   -   Bridge Office"]
[]
["TEST PILE REPORT"]
["(MPF12)"]
[null,null,null,null,null,null,null,null,null,null,"SEE INSTRUCTIONS ON OTHER SIDE"]
["PILE HAMMER DATA",null,null,null,"PILE DATA",null,null,null,null,"PROJECT DESCRIPTION"]
[null,null,null,null," Test Pile No:  1  2  3  4  5  6  or ______",null,null,null,null," Bridge No.:"]
["r","SINGLE ACTING (Power)",null,null,"r  CIP       r  H-Pile     r ___________",null,null,null,null," S.P. (or S.A.P.) No.:"]
["r","DOUBLE ACTING (Power)",null,null," Size:",null,null,null,null," County:",null,null,"Dist."]
[" Make and Model:",null,null,null," Length in Leads (ft.):"]
[null,null,null,null," Weight of Pile (lbs.):",null,null,null,null,"SUBSTRUCTURE"]
[" Weight of Ram (piston)_______(lbs.)",null,null,null," Weight of Cap (lbs.):",null,null,null,null,"r   Abutment    N   S   E   W"]
[" Max. Rated Energy________(ft. lbs.)",null,null,null," Cut-off Elev. (ft.):",null,null,null,null,"r   Pier No.  1   2   3   4  or  _________"]
["INSP. BY:",null,null,null,"INSP. PHONE No:",null,null,null,null,"CONTRACTOR:"]
["DISTANCE\nBELOW\nCUT-OFF\n(feet)","DROP OF\nHAMMER\nOR RAM\n(feet)","ENERGY\nPER\nBLOW\n(ft. lbs.)","BLOWS",null,"PENET.\nPER\nBLOW\n(inches)","BEARING\nIN TONS","DISTANCE\nBELOW\nCUT-OFF\n(feet)","DROP OF\nHAMMER\nOR RAM\n(feet)","ENERGY\nPER\nBLOW\n(ft. lbs.)","BLOWS",null,"PENET.\nPER\nBLOW\n(inches)","BEARING\nIN TONS"]
[null,null,null,"PER FOOT","PENET IN LAST 10 (inches)",null,null,null,null,null,"BLOWS PER FOOT","PENET IN LAST 10 (inches)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DATE:",null,null,null,"REMARKS ON DRIVING CONDITIONS, PRE-BORING, ETC. (IDENTIFY BY PENET. DISTANCE.)"]
["START DRIVING TIME:",null,null,null,"SETUP PERCENT INCREASE"]
["END DRIVING TIME:"]
["DOWN TIME:"]
["TOTAL DRIVING TIME:"]
["FORMULA USED",null,"MPF12",null,"Rn (tons)",null,null,"MIN. TIP ELEVATION",null,"AUTHORIZED PILE LENGTHS"]
[]
["INSPECTOR SIGNATURE",null,null,null,"PROJECT ENGINEER SIGNATURE",null,null,null,null,"BRIDGE OFFICE (Initial and Date)"]
[]
["INSTRUCTIONS FOR COMPLETING "]
["TEST PILE REPORT"]
["Pile Data:"]
["     1.  Check type of pile as CIP, H-Pile, Treated Timber, Precast Concrete, etc."]
["     2.  Show Size of pile; when using timber pile show butt and tip size to the nearest one-half inch.  Be certain that"]
["          diameters comply with the specifications.  Butt diameters should be measured 3 feet from the butt end."]
["     3.  Length in Leads should be total length in leads in feet."]
["     4.  Show Weight of Pile and Weight of Cap to nearest ten pounds."]
["     5.  INSP. BY should be the pile driving inspector (print or type name)."]
[]
["Column Tabulation:"]
["     6.  ENERGY PER BLOW (ft. lbs.)  is equal to WH, for single power-driven hammers.  "]
["     7.  PENET. PER BLOW (inches) may be based on blows per foot or on a measured penetration for a given number "]
["          of blows, and should be calculated in inches and decimals of inches."]
["     8.  BEARING IN TONS should be shown to the nearest ton."]
[]
[]
["SHOW SKETCH BELOW"]
["Show sketch indicating location of test pile.  Show North arrow."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DISTRIBUTION:"]
["State Projects:"]
["Original:  Bridge Const. & Maint. Engineer  (MS 610)"]
["County or Municipal Projects:"]
["Original: County or Municipal Engineer"]
["FOR ALL PROJECTS:"]
["Copy:  Project Engineer"]
["Copy:  Railroad"]

{"sheet":"dropdownlistinfo","index":2,"n_rows":91,"n_cols":21,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["Name of List","TPN",null,"TPT",null,"PHD",null,null,"COU",null,"DIS ",null,"ABUT ",null,"PIER1",null,"SIZE",null,null,null,"LRFD"]
[null,"Test Pile Number",null,"Test Pile Type",null,"PILE HAMMER DATA",null,null,"COUNTY",null,"DISTRICT",null,"ABUTMENT",null,"PIER",null," ",null,null,null,"ASD/LRFD"]
[null,1,null,"   ",null," ",null,null,null,null,"      ",null," ",null," ",null,"SELECT A SIZE",null,null,null,"ASD"]
[null,2,null,"SELECT A PILE TYPE",null,"SINGLE ACTING (Power)",null,0,"SELECT A COUNTY","dist","SELECT A DISTRICT",null,"N/A",null,"N/A",null,"12\" DIA",null,null,null,"LRFD"]
[null,3,null,"CIP",null,"DOUBLE ACTING (Power)",null,"01","AITKIN","1 & 3","METRO",null,"NORTH",null,1,null,"12 3/4\" DIA",null,null,null,"MPF12"]
[null,4,null,"H-Pile",null,null,null,"02","ANOKA","Metro",1,null,"SOUTH",null,2,null,"16\" DIA"]
[null,5,null,"Timber",null,null,null,"03","BECKER",4,2,null,"EAST",null,3,null,"18\" DIA"]
[null,6,null,"Precast Concrete",null,null,null,"04","BELTRAMI",2,3,null,"WEST",null,4,null,"20\" DIA"]
[null,7,null,"Other",null,null,null,"05","BENTON",3,4,null,null,null,5,null,"24\" DIA"]
[null,8,null,null,null,null,null,"06","BIG STONE",4,6,null,null,null,6,null,"HP 8 x 36"]
[null,9,null,null,null,null,null,"07","BLUE EARTH",7,7,null,null,null,7,null,"HP 10 x 42"]
[null,10,null,null,null,null,null,"08","BROWN",7,8,null,null,null,8,null,"HP 10 x 57"]
[null,11,null,null,null,null,null,"09","CARLTON",1,null,null,null,null,9,null,"HP 12 x 53"]
[null,12,null,null,null,null,null,"10","CARVER","Metro",null,null,null,null,10,null,"HP 12 x 59"]
[null,13,null,null,null,null,null,"11","CASS","2 & 3",null,null,null,null,11,null,"HP 12 x 63"]
[null,14,null,null,null,null,null,"12","CHIPPEWA",8,null,null,null,null,12,null,"HP 12 x 74"]
[null,15,null,null,null,null,null,"13","CHISAGO","Metro",null,null,null,null,13,null,"HP 12 x 84"]
[null,16,null,null,null,null,null,"14","CLAY",4,null,null,null,null,14,null,"HP 14 x 73"]
[null,17,null,null,null,null,null,"15","CLEARWATER",2,null,null,null,null,15,null,"HP 14 x 89"]
[null,18,null,null,null,null,null,"16","COOK",1,null,null,null,null,16,null,"HP 14 x 102"]
[null,19,null,null,null,null,null,"17","COTTONWOOD",7,null,null,null,null,17,null,"HP 14 x 117"]
[null,20,null,null,null,null,null,"18","CROW WING",3,null,null,null,null,18,null,"HP 16 x 88"]
[null,21,null,null,null,null,null,"19","DAKOTA","Metro",null,null,null,null,19,null,"HP 16 x 101"]
[null,22,null,null,null,null,null,"20","DODGE",6,null,null,null,null,20,null,"HP 16 x 121"]
[null,23,null,null,null,null,null,"21","DOUGLAS",4,null,null,null,null,21,null,"HP 16 x 141"]
[null,24,null,null,null,null,null,"22","FARIBAULT",7,null,null,null,null,22,null,"HP 16 x 162"]
[null,25,null,null,null,null,null,"23","FILLMORE",6,null,null,null,null,23,null,"HP 16 x 183"]
[null,26,null,null,null,null,null,"24","FREEBORN",6,null,null,null,null,24,null,"HP 18 x 135"]
[null,27,null,null,null,null,null,"25","GOODHUE",6,null,null,null,null,25,null,"HP 18 x 157"]
[null,28,null,null,null,null,null,"26","GRANT",4,null,null,null,null,null,null,"HP 18 x 181"]
[null,29,null,null,null,null,null,"27","HENNEPIN","Metro",null,null,null,null,null,null,"HP 18 x 204"]
[null,30,null,null,null,null,null,"28","HOUSTON",6,null,null,null,null,null,null,"OTHER"]
[null,31,null,null,null,null,null,"29","HUBBARD",2]
[null,32,null,null,null,null,null,"30","ISANTI",3]
[null,33,null,null,null,null,null,"31","ITASCA","1, 2 & 3"]
[null,34,null,null,null,null,null,"32","JACKSON",7]
[null,35,null,null,null,null,null,"33","KANABEC",3]
[null,36,null,null,null,null,null,"34","KANDIYOHI",8]
[null,37,null,null,null,null,null,"35","KITTSON",2]
[null,38,null,null,null,null,null,"36","KOOCHICHING","1 & 2"]
[null,39,null,null,null,null,null,"37","LAC QUI PARLE",8]
[null,40,null,null,null,null,null,"38","LAKE",1]
[null,41,null,null,null,null,null,"39","LAKE OF THE WOODS",2]
[null,42,null,null,null,null,null,"40","LE SUEUR",7]
[null,43,null,null,null,null,null,"41","LINCOLN",8]
[null,44,null,null,null,null,null,"42","LYON",8]
[null,45,null,null,null,null,null,"43","MCLEOD",8]
[null,46,null,null,null,null,null,"44","MAHNOMEN","2 & 4"]
[null,47,null,null,null,null,null,"45","MARSHALL",2]
[null,48,null,null,null,null,null,"46","MARTIN",7]
[null,49,null,null,null,null,null,"47","MEEKER",8]
[null,50,null,null,null,null,null,"48","MILLE LACS",3]
[null,null,null,null,null,null,null,"49","MORRISON",3]
[null,null,null,null,null,null,null,"50","MOWER",6]
[null,null,null,null,null,null,null,"51","MURRAY",8]
[null,null,null,null,null,null,null,"52","NICOLLET",7]
[null,null,null,null,null,null,null,"53","NOBLES",7]
[null,null,null,null,null,null,null,"54","NORMAN",2]
[null,null,null,null,null,null,null,"55","OLMSTED",6]
[null,null,null,null,null,null,null,"56","OTTER TAIL",4]
[null,null,null,null,null,null,null,"57","PENNINGTON",2]
[null,null,null,null,null,null,null,"58","PINE",1]
[null,null,null,null,null,null,null,"59","PIPESTONE",8]
[null,null,null,null,null,null,null,"60","POLK",2]
[null,null,null,null,null,null,null,"61","POPE",4]
[null,null,null,null,null,null,null,"62","RAMSEY","Metro"]
[null,null,null,null,null,null,null,"63","RED LAKE",2]
[null,null,null,null,null,null,null,"64","REDWOOD",8]
[null,null,null,null,null,null,null,"65","RENVILLE",8]
[null,null,null,null,null,null,null,"66","RICE",6]
[null,null,null,null,null,null,null,"67","ROCK",7]
[null,null,null,null,null,null,null,"68","ROSEAU",2]
[null,null,null,null,null,null,null,"69","ST LOUIS",1]
[null,null,null,null,null,null,null,"70","SCOTT","Metro"]
[null,null,null,null,null,null,null,"71","SHERBURNE",3]
[null,null,null,null,null,null,null,"72","SIBLEY",7]
[null,null,null,null,null,null,null,"73","STEARNS",3]
[null,null,null,null,null,null,null,"74","STEELE",6]
[null,null,null,null,null,null,null,"75","STEVENS",4]
[null,null,null,null,null,null,null,"76","SWIFT",4]
[null,null,null,null,null,null,null,"77","TODD",3]
[null,null,null,null,null,null,null,"78","TRAVERSE",4]
[null,null,null,null,null,null,null,"79","WABASHA",6]
[null,null,null,null,null,null,null,"80","WADENA",3]
[null,null,null,null,null,null,null,"81","WASECA",7]
[null,null,null,null,null,null,null,"82","WASHINGTON","Metro"]
[null,null,null,null,null,null,null,"83","WATONWAN",7]
[null,null,null,null,null,null,null,"84","WILKIN",4]
[null,null,null,null,null,null,null,"85","WINONA",6]
[null,null,null,null,null,null,null,"86","WRIGHT",3]
[null,null,null,null,null,null,null,"87","YELLOW MEDICINE",8]