{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PM List"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"PM List","index":0,"n_rows":122,"n_cols":23,"rows_kept":122,"cut":false,"hidden":false,"merged":[]}
["Region of Inspection Program","County #  OR Municipality #","County/Municipality Name","Commissioner","Designated Program Manager","Inspector #","PM - Agency","Consultant","Commissioner Email","PM Email",null,"Additional Requested Email","Additional Requested Email (2)",null,null,"CTY","Row","Commissioner Email","PM Email","Region Email","Additional Requested Email","Additional Requested Email (2)","Local"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$f":"MATCH(IF(ISNUMBER(VALUE(P2)),VALUE(P2),P2),B:B,0)","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(I:I,$Q2)=\"\",\"\",INDEX(I:I,$Q2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(J:J,$Q2)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q2),$R2:R2,0)),\"\",INDEX(J:J,$Q2)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q2)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q2),$R2:S2,0)),\"\",INDEX(K:K,$Q2)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q2)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q2),$R2:T2,0)),\"\",INDEX(L:L,$Q2)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q2)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q2),$R2:U2,0)),\"\",INDEX(M:M,$Q2)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
["Statewide                      Inspection Program Manager",null,null,null,"Richard Marz",9023,"State",null,null,"Richard.Marz@dot.wi.gov",null,"Travis.McDaniel@dot.wi.gov",null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(INDEX(I:I,$Q3)=\"\",\"\",INDEX(I:I,$Q3))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(J:J,$Q3)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q3),$R3:R3,0)),\"\",INDEX(J:J,$Q3)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q3)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q3),$R3:S3,0)),\"\",INDEX(K:K,$Q3)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q3)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q3),$R3:T3,0)),\"\",INDEX(L:L,$Q3)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q3)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q3),$R3:U3,0)),\"\",INDEX(M:M,$Q3)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
["Assistant Statewide Inspection Program Manager",null,null,null,null,null,null,null,null,null,null,"Matthew.coupar@dot.wi.gov",null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q4)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q4),$R4:R4,0)),\"\",INDEX(J:J,$Q4)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q4)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q4),$R4:S4,0)),\"\",INDEX(K:K,$Q4)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q4)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q4),$R4:T4,0)),\"\",INDEX(L:L,$Q4)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q4)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q4),$R4:U4,0)),\"\",INDEX(M:M,$Q4)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q5)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q5),$R5:R5,0)),\"\",INDEX(J:J,$Q5)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q5)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q5),$R5:S5,0)),\"\",INDEX(K:K,$Q5)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q5)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q5),$R5:T5,0)),\"\",INDEX(L:L,$Q5)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q5)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q5),$R5:U5,0)),\"\",INDEX(M:M,$Q5)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
["NE - Green Bay",{"$f":"joinVert(B7:B17)","v":"05,08,15,20,31,36,38,42,44,59,70"},null,null,"Dale Weber",3007,"State",null,null,"Dale.Weber@dot.wi.gov",null,"Christian.Blazek@dot.wi.gov",null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q6)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q6),$R6:R6,0)),\"\",INDEX(J:J,$Q6)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q6)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q6),$R6:S6,0)),\"\",INDEX(K:K,$Q6)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q6)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q6),$R6:T6,0)),\"\",INDEX(L:L,$Q6)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q6)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q6),$R6:U6,0)),\"\",INDEX(M:M,$Q6)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,5,"Brown","Paul Fontecchio","Nick Uitenbroek",3527,"County",null,"fontecchio_pa@co.brown.wi.us","uitenbroek_ns@co.brown.wi.us",{"$f":"$J$6","v":"Dale.Weber@dot.wi.gov"},null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q7)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q7),$R7:R7,0)),\"\",INDEX(J:J,$Q7)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q7)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q7),$R7:S7,0)),\"\",INDEX(K:K,$Q7)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q7)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q7),$R7:T7,0)),\"\",INDEX(L:L,$Q7)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q7)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q7),$R7:U7,0)),\"\",INDEX(M:M,$Q7)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,8,"Calumet","Brian Glaeser ","Brian Schroeder ",9540,"Consultant ","Ayres","glaeser.brian@co.calumet.wi.us","schroederb@ayresassociates.com",{"$f":"$J$6","v":"Dale.Weber@dot.wi.gov"},null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q8)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q8),$R8:R8,0)),\"\",INDEX(J:J,$Q8)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q8)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q8),$R8:S8,0)),\"\",INDEX(K:K,$Q8)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q8)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q8),$R8:T8,0)),\"\",INDEX(L:L,$Q8)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q8)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q8),$R8:U8,0)),\"\",INDEX(M:M,$Q8)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,15,"Door","John Kolodziej","Brian Schroeder ",9540,"Consultant ","Ayres","kolodzie@co.door.wi.us","schroederb@ayresassociates.com","Dale.Weber@dot.wi.gov",null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q9)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q9),$R9:R9,0)),\"\",INDEX(J:J,$Q9)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q9)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q9),$R9:S9,0)),\"\",INDEX(K:K,$Q9)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q9)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q9),$R9:T9,0)),\"\",INDEX(L:L,$Q9)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q9)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q9),$R9:U9,0)),\"\",INDEX(M:M,$Q9)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,20,"Fond Du Lac","Tom Janke","Ryan Sommer",3526,"County",null,"tom.janke@fdlco.wi.gov","ryan.sommer@fdlco.wi.gov","Dale.Weber@dot.wi.gov",null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q10)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q10),$R10:R10,0)),\"\",INDEX(J:J,$Q10)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q10)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q10),$R10:S10,0)),\"\",INDEX(K:K,$Q10)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q10)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q10),$R10:T10,0)),\"\",INDEX(L:L,$Q10)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q10)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q10),$R10:U10,0)),\"\",INDEX(M:M,$Q10)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,31,"Kewaunee","Todd Every","Brian Schroeder ",9540,"Consultant ","Ayres","EveryT@kewauneeco.org","schroederb@ayresassociates.com","Dale.Weber@dot.wi.gov",null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q11)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q11),$R11:R11,0)),\"\",INDEX(J:J,$Q11)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q11)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q11),$R11:S11,0)),\"\",INDEX(K:K,$Q11)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q11)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q11),$R11:T11,0)),\"\",INDEX(L:L,$Q11)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q11)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q11),$R11:U11,0)),\"\",INDEX(M:M,$Q11)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,36,"Manitowoc","Marc Holsen","John Kropp ",3509,"Consultant ","SMI","marcholsen@co.manitowoc.wi.us","jmkropp@att.net","Dale.Weber@dot.wi.gov",null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q12)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q12),$R12:R12,0)),\"\",INDEX(J:J,$Q12)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q12)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q12),$R12:S12,0)),\"\",INDEX(K:K,$Q12)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q12)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q12),$R12:T12,0)),\"\",INDEX(L:L,$Q12)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q12)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q12),$R12:U12,0)),\"\",INDEX(M:M,$Q12)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,38,"Marinette","Eric Burmeister - Interim","Mark Pilgrim",9506,"Consultant ","CORRE","egov@marinettecounty.com","mpilgrim@correinc.com","Dale.Weber@dot.wi.gov",null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q13)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q13),$R13:R13,0)),\"\",INDEX(J:J,$Q13)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q13)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q13),$R13:S13,0)),\"\",INDEX(K:K,$Q13)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q13)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q13),$R13:T13,0)),\"\",INDEX(L:L,$Q13)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q13)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q13),$R13:U13,0)),\"\",INDEX(M:M,$Q13)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,42,"Oconto","Patrick Scanlan","Kris Olson ",9566,"Consultant ","Omnni","pat.scanlan@co.oconto.wi.us","Kris.Olson@omnni.com","Dale.Weber@dot.wi.gov",null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q14)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q14),$R14:R14,0)),\"\",INDEX(J:J,$Q14)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q14)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q14),$R14:S14,0)),\"\",INDEX(K:K,$Q14)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q14)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q14),$R14:T14,0)),\"\",INDEX(L:L,$Q14)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q14)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q14),$R14:U14,0)),\"\",INDEX(M:M,$Q14)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,44,"Outagamie","Dean Steingraber","Dean Steingraber",4504,"*County",null,"dean.steingraber@outagamie.org","dean.steingraber@outagamie.org","Dale.Weber@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q15)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q15),$R15:R15,0)),\"\",INDEX(J:J,$Q15)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q15)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q15),$R15:S15,0)),\"\",INDEX(K:K,$Q15)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q15)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q15),$R15:T15,0)),\"\",INDEX(L:L,$Q15)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q15)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q15),$R15:U15,0)),\"\",INDEX(M:M,$Q15)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,59,"Sheboygan","Greg Schnell","Jim Foshag",3518,"County",null,"schnegfs@co.sheboygan.wi.us","james.foshag@sheboygancounty.com","Dale.Weber@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q16)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q16),$R16:R16,0)),\"\",INDEX(J:J,$Q16)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q16)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q16),$R16:S16,0)),\"\",INDEX(K:K,$Q16)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q16)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q16),$R16:T16,0)),\"\",INDEX(L:L,$Q16)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q16)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q16),$R16:U16,0)),\"\",INDEX(M:M,$Q16)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,70,"Winnebago","Ray Palonen","Bob Doemel",3517,"County",null,"rpalonen@co.winnebago.wi.us","RDoemel@co.winnebago.wi.us","Dale.Weber@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q17)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q17),$R17:R17,0)),\"\",INDEX(J:J,$Q17)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q17)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q17),$R17:S17,0)),\"\",INDEX(K:K,$Q17)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q17)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q17),$R17:T17,0)),\"\",INDEX(L:L,$Q17)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q17)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q17),$R17:U17,0)),\"\",INDEX(M:M,$Q17)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q18)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q18),$R18:R18,0)),\"\",INDEX(J:J,$Q18)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q18)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q18),$R18:S18,0)),\"\",INDEX(K:K,$Q18)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q18)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q18),$R18:T18,0)),\"\",INDEX(L:L,$Q18)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q18)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q18),$R18:U18,0)),\"\",INDEX(M:M,$Q18)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
["NC - Wisconsin Rapids",{"$f":"joinVert(B20:B27)","v":"01,24,37,39,49,68,69,71"},null,null,"Tom Hardinger",4001,"State",null,null,"Thomas.Hardinger@dot.wi.gov",null,"Anna.Wisner@dot.wi.gov",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q19)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q19),$R19:R19,0)),\"\",INDEX(J:J,$Q19)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q19)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q19),$R19:S19,0)),\"\",INDEX(K:K,$Q19)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q19)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q19),$R19:T19,0)),\"\",INDEX(L:L,$Q19)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q19)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q19),$R19:U19,0)),\"\",INDEX(M:M,$Q19)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,1,"Adams","Pat Kotlowski","Chris Blum",9528,"Consultant ","SEH Inc","pkotlowski@co.adams.wi.us","cblum@sehinc.com",{"$f":"$J$19","v":"Thomas.Hardinger@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q20)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q20),$R20:R20,0)),\"\",INDEX(J:J,$Q20)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q20)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q20),$R20:S20,0)),\"\",INDEX(K:K,$Q20)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q20)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q20),$R20:T20,0)),\"\",INDEX(L:L,$Q20)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q20)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q20),$R20:U20,0)),\"\",INDEX(M:M,$Q20)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,24,"Green Lake","Amy Brooks","Amy Brooks",4519,"*County",null,"abrooks@co.green-lake.wi.us","abrooks@co.green-lake.wi.us",{"$f":"$J$19","v":"Thomas.Hardinger@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q21)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q21),$R21:R21,0)),\"\",INDEX(J:J,$Q21)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q21)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q21),$R21:S21,0)),\"\",INDEX(K:K,$Q21)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q21)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q21),$R21:T21,0)),\"\",INDEX(L:L,$Q21)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q21)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q21),$R21:U21,0)),\"\",INDEX(M:M,$Q21)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,37,"Marathon","Jim Griesbach","Kris Baguhn",4510,"County",null,"jmgriesbach@mail.co.marathon.wi.us","kjbaguhn@mail.co.marathon.wi.us","Thomas.Hardinger@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q22)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q22),$R22:R22,0)),\"\",INDEX(J:J,$Q22)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q22)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q22),$R22:S22,0)),\"\",INDEX(K:K,$Q22)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q22)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q22),$R22:T22,0)),\"\",INDEX(L:L,$Q22)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q22)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q22),$R22:U22,0)),\"\",INDEX(M:M,$Q22)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,39,"Marquette","Brian Trebiatowski","Gary Ruchti",9544,"Consultant ","Mead & Hunt","btrebiatowski@co.marquette.wi.us","gary.ruchti@meadhunt.com","Thomas.Hardinger@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q23)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q23),$R23:R23,0)),\"\",INDEX(J:J,$Q23)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q23)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q23),$R23:S23,0)),\"\",INDEX(K:K,$Q23)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q23)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q23),$R23:T23,0)),\"\",INDEX(L:L,$Q23)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q23)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q23),$R23:U23,0)),\"\",INDEX(M:M,$Q23)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,49,"Portage","Nathan Check","Nathan Check",4520,"*County",null,"checkn@co.portage.wi.us","checkn@co.portage.wi.us","Thomas.Hardinger@dot.wi.gov","rintalaj@co.portage.wi.us",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q24)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q24),$R24:R24,0)),\"\",INDEX(J:J,$Q24)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q24)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q24),$R24:S24,0)),\"\",INDEX(K:K,$Q24)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q24)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q24),$R24:T24,0)),\"\",INDEX(L:L,$Q24)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q24)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q24),$R24:U24,0)),\"\",INDEX(M:M,$Q24)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,68,"Waupaca","Casey Beyersdorf","Greg Flohr",4527,"County",null,"Casey.Beyersdorf@co.waupaca.wi.us","greg.flohr@co.waupaca.wi.us","Thomas.Hardinger@dot.wi.gov","Al.Kriesel@co.waupaca.wi.us",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q25)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q25),$R25:R25,0)),\"\",INDEX(J:J,$Q25)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q25)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q25),$R25:S25,0)),\"\",INDEX(K:K,$Q25)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q25)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q25),$R25:T25,0)),\"\",INDEX(L:L,$Q25)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q25)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q25),$R25:U25,0)),\"\",INDEX(M:M,$Q25)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,69,"Waushara","Brian Freimark","Thomas Dahlke",4500,"County",null,"brianf.highway@co.waushara.wi.us","tdahlke60@gmail.com","Thomas.Hardinger@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q26)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q26),$R26:R26,0)),\"\",INDEX(J:J,$Q26)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q26)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q26),$R26:S26,0)),\"\",INDEX(K:K,$Q26)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q26)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q26),$R26:T26,0)),\"\",INDEX(L:L,$Q26)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q26)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q26),$R26:U26,0)),\"\",INDEX(M:M,$Q26)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,71,"Wood","Roland Hawk","Roland Hawk",4518,"*County",null,"rhawk@co.wood.wi.us","rhawk@co.wood.wi.us","Thomas.Hardinger@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q27)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q27),$R27:R27,0)),\"\",INDEX(J:J,$Q27)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q27)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q27),$R27:S27,0)),\"\",INDEX(K:K,$Q27)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q27)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q27),$R27:T27,0)),\"\",INDEX(L:L,$Q27)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q27)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q27),$R27:U27,0)),\"\",INDEX(M:M,$Q27)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
["NC - Rhinelander",{"$f":"joinVert(B29:B38)","v":"19,21,26,34,35,43,50,58,63,73"},null,null,"Brock Gehrig",7006,"State",null,null,"Brock.Gehrig@dot.wi.gov",null,"Anna.Wisner@dot.wi.gov",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q28)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q28),$R28:R28,0)),\"\",INDEX(J:J,$Q28)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q28)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q28),$R28:S28,0)),\"\",INDEX(K:K,$Q28)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q28)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q28),$R28:T28,0)),\"\",INDEX(L:L,$Q28)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q28)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q28),$R28:U28,0)),\"\",INDEX(M:M,$Q28)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,19,"Florence","Jeffery DeMuri","William Knaack Sr",7501,"Consultant ","KBIS","jdemuri@co.florence.wi.us","wm.kbis@gmail.com",{"$f":"$J$28","v":"Brock.Gehrig@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q29)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q29),$R29:R29,0)),\"\",INDEX(J:J,$Q29)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q29)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q29),$R29:S29,0)),\"\",INDEX(K:K,$Q29)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q29)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q29),$R29:T29,0)),\"\",INDEX(L:L,$Q29)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q29)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q29),$R29:U29,0)),\"\",INDEX(M:M,$Q29)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,21,"Forest","Bill Anderson","William Knaack Sr",7501,"Consultant ","KBIS","banderson@co.forest.wi.us","wm.kbis@gmail.com",{"$f":"$J$28","v":"Brock.Gehrig@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q30)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q30),$R30:R30,0)),\"\",INDEX(J:J,$Q30)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q30)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q30),$R30:S30,0)),\"\",INDEX(K:K,$Q30)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q30)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q30),$R30:T30,0)),\"\",INDEX(L:L,$Q30)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q30)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q30),$R30:U30,0)),\"\",INDEX(M:M,$Q30)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,26,"Iron","Michael Swartz","William Knaack Sr",7501,"Consultant ","KBIS","commissioner@ironcountywi.org","wm.kbis@gmail.com","Brock.Gehrig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q31)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q31),$R31:R31,0)),\"\",INDEX(J:J,$Q31)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q31)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q31),$R31:S31,0)),\"\",INDEX(K:K,$Q31)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q31)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q31),$R31:T31,0)),\"\",INDEX(L:L,$Q31)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q31)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q31),$R31:U31,0)),\"\",INDEX(M:M,$Q31)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,34,"Langlade","Brian Braun","William Knaack Jr",7508,"Consultant ","KBIS","bbraun@co.langlade.wi.us","wm.kbis@gmail.com","Brock.Gehrig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q32)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q32),$R32:R32,0)),\"\",INDEX(J:J,$Q32)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q32)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q32),$R32:S32,0)),\"\",INDEX(K:K,$Q32)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q32)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q32),$R32:T32,0)),\"\",INDEX(L:L,$Q32)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q32)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q32),$R32:U32,0)),\"\",INDEX(M:M,$Q32)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,35,"Lincoln","John Hanz","William Knaack Jr",7508,"Consultant ","KBIS","jhanz@co.lincoln.wi.us","wm.kbis@gmail.com","Brock.Gehrig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q33)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q33),$R33:R33,0)),\"\",INDEX(J:J,$Q33)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q33)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q33),$R33:S33,0)),\"\",INDEX(K:K,$Q33)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q33)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q33),$R33:T33,0)),\"\",INDEX(L:L,$Q33)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q33)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q33),$R33:U33,0)),\"\",INDEX(M:M,$Q33)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,43,"Oneida","Bruce Stefonek","William Knaack Jr",7508,"Consultant ","KBIS","bstefonek@co.oneida.wi.us","wm.kbis@gmail.com","Brock.Gehrig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q34)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q34),$R34:R34,0)),\"\",INDEX(J:J,$Q34)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q34)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q34),$R34:S34,0)),\"\",INDEX(K:K,$Q34)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q34)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q34),$R34:T34,0)),\"\",INDEX(L:L,$Q34)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q34)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q34),$R34:U34,0)),\"\",INDEX(M:M,$Q34)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,50,"Price","Don Grande","William Knaack Sr",7501,"Consultant ","KBIS","don.grande@co.price.wi.us","wm.kbis@gmail.com","Brock.Gehrig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q35)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q35),$R35:R35,0)),\"\",INDEX(J:J,$Q35)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q35)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q35),$R35:S35,0)),\"\",INDEX(K:K,$Q35)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q35)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q35),$R35:T35,0)),\"\",INDEX(L:L,$Q35)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q35)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q35),$R35:U35,0)),\"\",INDEX(M:M,$Q35)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,58,"Shawano","Grant Bystol","Grant Bystol",7509,"*County",null,"grant.bystol@co.shawano.wi.us","grant.bystol@co.shawano.wi.us","Brock.Gehrig@dot.wi.gov","Hunter.Hoffman@co.shawano.wi.us",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q36)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q36),$R36:R36,0)),\"\",INDEX(J:J,$Q36)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q36)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q36),$R36:S36,0)),\"\",INDEX(K:K,$Q36)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q36)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q36),$R36:T36,0)),\"\",INDEX(L:L,$Q36)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q36)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q36),$R36:U36,0)),\"\",INDEX(M:M,$Q36)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,63,"Vilas","Nick Scholtes","William Knaack Sr",7501,"Consultant ","KBIS","nischo@co.vilas.wi.us","wm.kbis@gmail.com","Brock.Gehrig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q37)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q37),$R37:R37,0)),\"\",INDEX(J:J,$Q37)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q37)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q37),$R37:S37,0)),\"\",INDEX(K:K,$Q37)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q37)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q37),$R37:T37,0)),\"\",INDEX(L:L,$Q37)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q37)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q37),$R37:U37,0)),\"\",INDEX(M:M,$Q37)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,73,"Menominee","Jeremy Weso","Brian Schroeder",9540,"Consultant ","Ayres","jweso@co.menominee.wi.us","schroederb@ayresassociates.com","Brock.Gehrig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q38)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q38),$R38:R38,0)),\"\",INDEX(J:J,$Q38)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q38)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q38),$R38:S38,0)),\"\",INDEX(K:K,$Q38)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q38)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q38),$R38:T38,0)),\"\",INDEX(L:L,$Q38)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q38)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q38),$R38:U38,0)),\"\",INDEX(M:M,$Q38)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q39)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q39),$R39:R39,0)),\"\",INDEX(J:J,$Q39)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q39)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q39),$R39:S39,0)),\"\",INDEX(K:K,$Q39)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q39)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q39),$R39:T39,0)),\"\",INDEX(L:L,$Q39)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q39)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q39),$R39:U39,0)),\"\",INDEX(M:M,$Q39)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
["NW - Superior",{"$f":"joinVert(B41:B50)","v":"02,03,04,07,16,48,54,57,60,65"},null,null,"Al Bjorklund",8003,"State",null,null,"Allan.Bjorklund@dot.wi.gov",null,"Michael.Ostrenga@dot.wi.gov","William.Kovaleski@dot.wi.gov",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q40)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q40),$R40:R40,0)),\"\",INDEX(J:J,$Q40)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q40)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q40),$R40:S40,0)),\"\",INDEX(K:K,$Q40)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q40)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q40),$R40:T40,0)),\"\",INDEX(L:L,$Q40)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q40)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q40),$R40:U40,0)),\"\",INDEX(M:M,$Q40)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,2,"Ashland","Emmer Shields","Emmer Shields",9529,"*County",null,"ashcohwy@yahoo.com","ashcohwy@yahoo.com",{"$f":"$J$40","v":"Allan.Bjorklund@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q41)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q41),$R41:R41,0)),\"\",INDEX(J:J,$Q41)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q41)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q41),$R41:S41,0)),\"\",INDEX(K:K,$Q41)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q41)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q41),$R41:T41,0)),\"\",INDEX(L:L,$Q41)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q41)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q41),$R41:U41,0)),\"\",INDEX(M:M,$Q41)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,3,"Barron","Mark Servi","Dan Fedderly",9558,"Consultant ","DJ Fedderly","mark.servi@co.barron.wi.us","hwype@wwt.net",{"$f":"$J$40","v":"Allan.Bjorklund@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q42)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q42),$R42:R42,0)),\"\",INDEX(J:J,$Q42)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q42)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q42),$R42:S42,0)),\"\",INDEX(K:K,$Q42)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q42)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q42),$R42:T42,0)),\"\",INDEX(L:L,$Q42)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q42)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q42),$R42:U42,0)),\"\",INDEX(M:M,$Q42)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,4,"Bayfield","Paul Johanik","Mark Pilgrim",9501,"Consultant ","CORRE","pjohanik@bayfieldcounty.org","mpilgrim@correinc.com","Allan.Bjorklund@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q43)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q43),$R43:R43,0)),\"\",INDEX(J:J,$Q43)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q43)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q43),$R43:S43,0)),\"\",INDEX(K:K,$Q43)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q43)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q43),$R43:T43,0)),\"\",INDEX(L:L,$Q43)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q43)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q43),$R43:U43,0)),\"\",INDEX(M:M,$Q43)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,7,"Burnett","Michael Hoefs","Troy Peterson",9505,"Consultant ","Cedar Corp","mhoefs@burnettcounty.org","Troy.peterson@cedarcorp.com","Allan.Bjorklund@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q44)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q44),$R44:R44,0)),\"\",INDEX(J:J,$Q44)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q44)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q44),$R44:S44,0)),\"\",INDEX(K:K,$Q44)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q44)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q44),$R44:T44,0)),\"\",INDEX(L:L,$Q44)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q44)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q44),$R44:U44,0)),\"\",INDEX(M:M,$Q44)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,16,"Douglas","Jason Jackman","Jason Jackman",8502,"*County",null,"Jason.Jackman@douglascountywi.org","Jason.Jackman@douglascountywi.org","Allan.Bjorklund@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q45)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q45),$R45:R45,0)),\"\",INDEX(J:J,$Q45)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q45)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q45),$R45:S45,0)),\"\",INDEX(K:K,$Q45)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q45)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q45),$R45:T45,0)),\"\",INDEX(L:L,$Q45)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q45)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q45),$R45:U45,0)),\"\",INDEX(M:M,$Q45)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,48,"Polk","Emil Norby","Brian Schroeder",9540,"Consultant ","Ayres","emil.norby@co.polk.wi.us","schroederb@ayresassociates.com","Allan.Bjorklund@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q46)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q46),$R46:R46,0)),\"\",INDEX(J:J,$Q46)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q46)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q46),$R46:S46,0)),\"\",INDEX(K:K,$Q46)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q46)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q46),$R46:T46,0)),\"\",INDEX(L:L,$Q46)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q46)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q46),$R46:U46,0)),\"\",INDEX(M:M,$Q46)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,54,"Rusk","Scott Emch","Scott Emch",8512,"*County",null,"semch@ruskcountywi.us","semch@ruskcountywi.us","Allan.Bjorklund@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q47)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q47),$R47:R47,0)),\"\",INDEX(J:J,$Q47)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q47)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q47),$R47:S47,0)),\"\",INDEX(K:K,$Q47)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q47)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q47),$R47:T47,0)),\"\",INDEX(L:L,$Q47)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q47)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q47),$R47:U47,0)),\"\",INDEX(M:M,$Q47)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,57,"Sawyer","Gary Gedart","Mark Pilgrim",9501,"Consultant ","CORRE","highway@sawyercountygov.org","mpilgrim@correinc.com","Allan.Bjorklund@dot.wi.gov",null,null,null,null,"05,08,15,20,31,36,38,42,44,59,70",6,"",{"$f":"IF(INDEX(J:J,$Q48)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q48),$R48:R48,0)),\"\",INDEX(J:J,$Q48)))","v":"Dale.Weber@dot.wi.gov"},{"$f":"IF(INDEX(K:K,$Q48)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q48),$R48:S48,0)),\"\",INDEX(K:K,$Q48)))","v":""},{"$f":"IF(INDEX(L:L,$Q48)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q48),$R48:T48,0)),\"\",INDEX(L:L,$Q48)))","v":"Christian.Blazek@dot.wi.gov"},{"$f":"IF(INDEX(M:M,$Q48)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q48),$R48:U48,0)),\"\",INDEX(M:M,$Q48)))","v":""},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,60,"Taylor","Jess Sackmann","Roger Petrick",8510,"County",null,"jess.sackmann@co.taylor.wi.us","roger.petrick@co.taylor.wi.us","Allan.Bjorklund@dot.wi.gov",null,null,null,null,"05,08,15,20,31,36,38,42,44,59,70",6,"",{"$f":"IF(INDEX(J:J,$Q49)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q49),$R49:R49,0)),\"\",INDEX(J:J,$Q49)))","v":"Dale.Weber@dot.wi.gov"},{"$f":"IF(INDEX(K:K,$Q49)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q49),$R49:S49,0)),\"\",INDEX(K:K,$Q49)))","v":""},{"$f":"IF(INDEX(L:L,$Q49)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q49),$R49:T49,0)),\"\",INDEX(L:L,$Q49)))","v":"Christian.Blazek@dot.wi.gov"},{"$f":"IF(INDEX(M:M,$Q49)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q49),$R49:U49,0)),\"\",INDEX(M:M,$Q49)))","v":""},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,65,"Washburn","Frank Scalzo","Dan Fedderly",9558,"Consultant ","DJ Fedderly","Fscalzo@co.washburn.wi.us","hwype@wwt.net","Allan.Bjorklund@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q50)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q50),$R50:R50,0)),\"\",INDEX(J:J,$Q50)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q50)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q50),$R50:S50,0)),\"\",INDEX(K:K,$Q50)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q50)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q50),$R50:T50,0)),\"\",INDEX(L:L,$Q50)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q50)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q50),$R50:U50,0)),\"\",INDEX(M:M,$Q50)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
["NW - Eau Claire",{"$f":"joinVert(B52:B61)","v":"06,09,10,17,18,27,46,47,55,61"},null,null,"Greg Haig",5014,"State",null,null,"Gregory.Haig@dot.wi.gov",null,"Jeffrey.Kern@dot.wi.gov",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q51)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q51),$R51:R51,0)),\"\",INDEX(J:J,$Q51)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q51)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q51),$R51:S51,0)),\"\",INDEX(K:K,$Q51)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q51)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q51),$R51:T51,0)),\"\",INDEX(L:L,$Q51)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q51)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q51),$R51:U51,0)),\"\",INDEX(M:M,$Q51)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,6,"Buffalo","Bob Platteter","David McDermid",9595,"Consultant ","MSA","bob.platteter@co.buffalo.wi.us","dmcdermid@msa-ps.com",{"$f":"$J$51","v":"Gregory.Haig@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q52)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q52),$R52:R52,0)),\"\",INDEX(J:J,$Q52)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q52)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q52),$R52:S52,0)),\"\",INDEX(K:K,$Q52)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q52)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q52),$R52:T52,0)),\"\",INDEX(L:L,$Q52)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q52)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q52),$R52:U52,0)),\"\",INDEX(M:M,$Q52)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,9,"Chippewa","Brian Kelley","Wayne Krejci ",6504,"County",null,"bkelley@co.chippewa.wi.us","wkrejci@co.chippewa.wi.us",{"$f":"$J$51","v":"Gregory.Haig@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q53)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q53),$R53:R53,0)),\"\",INDEX(J:J,$Q53)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q53)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q53),$R53:S53,0)),\"\",INDEX(K:K,$Q53)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q53)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q53),$R53:T53,0)),\"\",INDEX(L:L,$Q53)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q53)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q53),$R53:U53,0)),\"\",INDEX(M:M,$Q53)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,10,"Clark","Brian Duell","Jay Gardner",6517,"County",null,"brian.duell@co.clark.wi.us","Jay.Gardner@co.clark.wi.us","Gregory.Haig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q54)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q54),$R54:R54,0)),\"\",INDEX(J:J,$Q54)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q54)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q54),$R54:S54,0)),\"\",INDEX(K:K,$Q54)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q54)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q54),$R54:T54,0)),\"\",INDEX(L:L,$Q54)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q54)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q54),$R54:U54,0)),\"\",INDEX(M:M,$Q54)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,17,"Dunn","John Sworski","Dustin Binder",6518,"*County",null,"jsworski@co.dunn.wi.us","dbinder@co.dunn.wi.us","Gregory.Haig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q55)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q55),$R55:R55,0)),\"\",INDEX(J:J,$Q55)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q55)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q55),$R55:S55,0)),\"\",INDEX(K:K,$Q55)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q55)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q55),$R55:T55,0)),\"\",INDEX(L:L,$Q55)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q55)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q55),$R55:U55,0)),\"\",INDEX(M:M,$Q55)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,18,"Eau Claire","Jon Johnson","Rod Thorson",6516,"County",null,"jon.johnson@co.eau-claire.wi.us","rod.thorson@co.eau-claire.wi.us","Gregory.Haig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q56)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q56),$R56:R56,0)),\"\",INDEX(J:J,$Q56)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q56)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q56),$R56:S56,0)),\"\",INDEX(K:K,$Q56)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q56)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q56),$R56:T56,0)),\"\",INDEX(L:L,$Q56)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q56)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q56),$R56:U56,0)),\"\",INDEX(M:M,$Q56)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,27,"Jackson","Jay Borek","Jay Gardner",6517,"County",null,"Jay.Borek@co.jackson.wi.us","Jay.Gardner@co.clark.wi.us","Gregory.Haig@dot.wi.gov","Paul.Olson@co.jackson.wi.us",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q57)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q57),$R57:R57,0)),\"\",INDEX(J:J,$Q57)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q57)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q57),$R57:S57,0)),\"\",INDEX(K:K,$Q57)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q57)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q57),$R57:T57,0)),\"\",INDEX(L:L,$Q57)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q57)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q57),$R57:U57,0)),\"\",INDEX(M:M,$Q57)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,46,"Pepin","Kris Quandt","Troy Peterson",9505,"Consultant ","Cedar Corp","kquandt@co.pepin.wi.us","Troy.peterson@cedarcorp.com","Gregory.Haig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q58)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q58),$R58:R58,0)),\"\",INDEX(J:J,$Q58)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q58)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q58),$R58:S58,0)),\"\",INDEX(K:K,$Q58)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q58)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q58),$R58:T58,0)),\"\",INDEX(L:L,$Q58)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q58)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q58),$R58:U58,0)),\"\",INDEX(M:M,$Q58)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,47,"Pierce","Chad Johnson","Jeff Redding",6510,"County",null,"chad.johnson@co.pierce.wi.us","jeff.redding@co.pierce.wi.us","Gregory.Haig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q59)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q59),$R59:R59,0)),\"\",INDEX(J:J,$Q59)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q59)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q59),$R59:S59,0)),\"\",INDEX(K:K,$Q59)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q59)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q59),$R59:T59,0)),\"\",INDEX(L:L,$Q59)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q59)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q59),$R59:U59,0)),\"\",INDEX(M:M,$Q59)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,55,"St. Croix","Robbie Krejci","Jeff Durkee",6514,"County",null,"robbie.krejci@co.saint-croix.wi.us","Jeffrey.Durkee@co.saint-croix.wi.us","Gregory.Haig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q60)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q60),$R60:R60,0)),\"\",INDEX(J:J,$Q60)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q60)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q60),$R60:S60,0)),\"\",INDEX(K:K,$Q60)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q60)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q60),$R60:T60,0)),\"\",INDEX(L:L,$Q60)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q60)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q60),$R60:U60,0)),\"\",INDEX(M:M,$Q60)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,61,"Trempealeau","Al Rinka","Mark Pilgrim",9501,"Consultant ","CORRE","al.rinka@tremplocounty.com","mpilgrim@correinc.com","Gregory.Haig@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q61)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q61),$R61:R61,0)),\"\",INDEX(J:J,$Q61)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q61)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q61),$R61:S61,0)),\"\",INDEX(K:K,$Q61)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q61)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q61),$R61:T61,0)),\"\",INDEX(L:L,$Q61)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q61)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q61),$R61:U61,0)),\"\",INDEX(M:M,$Q61)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q62)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q62),$R62:R62,0)),\"\",INDEX(J:J,$Q62)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q62)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q62),$R62:S62,0)),\"\",INDEX(K:K,$Q62)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q62)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q62),$R62:T62,0)),\"\",INDEX(L:L,$Q62)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q62)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q62),$R62:U62,0)),\"\",INDEX(M:M,$Q62)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
["SW - La Crosse",{"$f":"joinVert(B64:B70)","v":"12,22,29,32,41,52,62"},null,null,"Dave Bohnsack",5015,"State",null,null,"David.Bohnsack@dot.wi.gov",null,"Richard.Vydrzal@dot.wi.gov",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q63)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q63),$R63:R63,0)),\"\",INDEX(J:J,$Q63)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q63)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q63),$R63:S63,0)),\"\",INDEX(K:K,$Q63)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q63)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q63),$R63:T63,0)),\"\",INDEX(L:L,$Q63)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q63)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q63),$R63:U63,0)),\"\",INDEX(M:M,$Q63)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,12,"Crawford ","Dennis Pelock","Greg Jewell",9575,"Consultant","Jewell Associates","dpelock@crawfordcountywi.org","Greg.Jewell@JewellAssoc.com",{"$f":"$J$63","v":"David.Bohnsack@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q64)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q64),$R64:R64,0)),\"\",INDEX(J:J,$Q64)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q64)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q64),$R64:S64,0)),\"\",INDEX(K:K,$Q64)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q64)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q64),$R64:T64,0)),\"\",INDEX(L:L,$Q64)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q64)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q64),$R64:U64,0)),\"\",INDEX(M:M,$Q64)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,22,"Grant ","Dave Lambert","Dave Lambert",9502,"*County",null,"dlambert@co.grant.wi.gov","dlambert@co.grant.wi.gov",{"$f":"$J$63","v":"David.Bohnsack@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q65)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q65),$R65:R65,0)),\"\",INDEX(J:J,$Q65)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q65)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q65),$R65:S65,0)),\"\",INDEX(K:K,$Q65)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q65)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q65),$R65:T65,0)),\"\",INDEX(L:L,$Q65)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q65)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q65),$R65:U65,0)),\"\",INDEX(M:M,$Q65)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,29,"Juneau ","Dennis Weiss","Mike Keichinger",4509,"County",null,"dweiss@co.juneau.wi.us","mikekeic@mwt.net","David.Bohnsack@dot.wi.gov","tcilley@co.juneau.wi.us",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"MATCH(IF(ISNUMBER(VALUE(P66)),VALUE(P66),P66),B:B,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q66)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q66),$R66:R66,0)),\"\",INDEX(J:J,$Q66)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q66)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q66),$R66:S66,0)),\"\",INDEX(K:K,$Q66)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q66)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q66),$R66:T66,0)),\"\",INDEX(L:L,$Q66)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q66)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q66),$R66:U66,0)),\"\",INDEX(M:M,$Q66)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,32,"La Crosse ","Ronald Chamberlain","Joe Langeberg",5020,"County",null,"rchamberlain@lacrossecounty.org","JLangeberg@lacrossecounty.org","David.Bohnsack@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(INDEX(I:I,$Q67)=\"\",\"\",INDEX(I:I,$Q67))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(J:J,$Q67)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q67),$R67:R67,0)),\"\",INDEX(J:J,$Q67)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q67)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q67),$R67:S67,0)),\"\",INDEX(K:K,$Q67)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q67)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q67),$R67:T67,0)),\"\",INDEX(L:L,$Q67)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q67)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q67),$R67:U67,0)),\"\",INDEX(M:M,$Q67)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,41,"Monroe ","David Ohnstad","Greg Jewell",9575,"Consultant","Jewell Associates","david.ohnstad@co.monroe.wi.us","Greg.Jewell@JewellAssoc.com","David.Bohnsack@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q68)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q68),$R68:R68,0)),\"\",INDEX(J:J,$Q68)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q68)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q68),$R68:S68,0)),\"\",INDEX(K:K,$Q68)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q68)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q68),$R68:T68,0)),\"\",INDEX(L:L,$Q68)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q68)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q68),$R68:U68,0)),\"\",INDEX(M:M,$Q68)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,52,"Richland ","Bill Condon","Aaron Palmer",9508,"Consultant","Westbrook","bill.condon@co.richland.wi.us","apalmer@westbrookeng.com","David.Bohnsack@dot.wi.gov",null,null,null,null,"30,40,45,51,64,66,67",83,"",{"$f":"IF(INDEX(J:J,$Q69)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q69),$R69:R69,0)),\"\",INDEX(J:J,$Q69)))","v":"John.Bolka@dot.wi.gov"},{"$f":"IF(INDEX(K:K,$Q69)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q69),$R69:S69,0)),\"\",INDEX(K:K,$Q69)))","v":""},{"$f":"IF(INDEX(L:L,$Q69)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q69),$R69:T69,0)),\"\",INDEX(L:L,$Q69)))","v":"Bao.Tran@dot.wi.gov"},{"$f":"IF(INDEX(M:M,$Q69)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q69),$R69:U69,0)),\"\",INDEX(M:M,$Q69)))","v":""},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,62,"Vernon ","Phil Hewitt","Greg Jewell",9575,"Consultant","Jewell Associates","phil.hewitt@vernoncounty.org","Greg.Jewell@JewellAssoc.com","David.Bohnsack@dot.wi.gov",null,null,null,null,"30,40,45,51,64,66,67",83,"",{"$f":"IF(INDEX(J:J,$Q70)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q70),$R70:R70,0)),\"\",INDEX(J:J,$Q70)))","v":"John.Bolka@dot.wi.gov"},{"$f":"IF(INDEX(K:K,$Q70)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q70),$R70:S70,0)),\"\",INDEX(K:K,$Q70)))","v":""},{"$f":"IF(INDEX(L:L,$Q70)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q70),$R70:T70,0)),\"\",INDEX(L:L,$Q70)))","v":"Bao.Tran@dot.wi.gov"},{"$f":"IF(INDEX(M:M,$Q70)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q70),$R70:U70,0)),\"\",INDEX(M:M,$Q70)))","v":""},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
["SW - Madison (1)",{"$f":"joinVert(B72:B74)","v":"13,14,28"},null,null,"Mike Williams",9016,"State",null,null,"Michael.Williams@dot.wi.gov",null,"Richard.Vela@dot.wi.gov",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q71)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q71),$R71:R71,0)),\"\",INDEX(J:J,$Q71)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q71)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q71),$R71:S71,0)),\"\",INDEX(K:K,$Q71)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q71)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q71),$R71:T71,0)),\"\",INDEX(L:L,$Q71)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q71)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q71),$R71:U71,0)),\"\",INDEX(M:M,$Q71)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,13,"Dane","Gerald Mandli","Matt Rice",1508,"County",null,"mandli@co.dane.wi.us","rice@co.dane.wi.us",{"$f":"$J$71","v":"Michael.Williams@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q72)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q72),$R72:R72,0)),\"\",INDEX(J:J,$Q72)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q72)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q72),$R72:S72,0)),\"\",INDEX(K:K,$Q72)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q72)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q72),$R72:T72,0)),\"\",INDEX(L:L,$Q72)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q72)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q72),$R72:U72,0)),\"\",INDEX(M:M,$Q72)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,14,"Dodge","Brian Field","Peter Thompson",5510,"County",null,"bfield@co.dodge.wi.us","pthompson@co.dodge.wi.us",{"$f":"$J$71","v":"Michael.Williams@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q73)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q73),$R73:R73,0)),\"\",INDEX(J:J,$Q73)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q73)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q73),$R73:S73,0)),\"\",INDEX(K:K,$Q73)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q73)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q73),$R73:T73,0)),\"\",INDEX(L:L,$Q73)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q73)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q73),$R73:U73,0)),\"\",INDEX(M:M,$Q73)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,28,"Jefferson","Bill Kern","Brian Udovich",1517,"County",null,"billk@co.jefferson.wi.us","BrianU@jeffersoncountywi.gov","Michael.Williams@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q74)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q74),$R74:R74,0)),\"\",INDEX(J:J,$Q74)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q74)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q74),$R74:S74,0)),\"\",INDEX(K:K,$Q74)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q74)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q74),$R74:T74,0)),\"\",INDEX(L:L,$Q74)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q74)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q74),$R74:U74,0)),\"\",INDEX(M:M,$Q74)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
["SW - Madison (2)",{"$f":"joinVert(B76:B81)","v":"11,23,25,33,53,56"},null,null,"Steve Katzner",1011,"State",null,null,"Steven.Katzner@dot.wi.gov",null,"Richard.Vela@dot.wi.gov",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q75)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q75),$R75:R75,0)),\"\",INDEX(J:J,$Q75)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q75)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q75),$R75:S75,0)),\"\",INDEX(K:K,$Q75)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q75)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q75),$R75:T75,0)),\"\",INDEX(L:L,$Q75)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q75)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q75),$R75:U75,0)),\"\",INDEX(M:M,$Q75)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,11,"Columbia","Chris Hardy","David McDermid",9595,"Consultant","MSA","chris.hardy@co.columbia.wi.us","dmcdermid@msa-ps.com",{"$f":"$J$75","v":"Steven.Katzner@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q76)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q76),$R76:R76,0)),\"\",INDEX(J:J,$Q76)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q76)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q76),$R76:S76,0)),\"\",INDEX(K:K,$Q76)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q76)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q76),$R76:T76,0)),\"\",INDEX(L:L,$Q76)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q76)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q76),$R76:U76,0)),\"\",INDEX(M:M,$Q76)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,23,"Green","Chris Narveson","Mike Mertens",9516,"Consultant","Jewell Associates","cnarveson@greencountywi.org","Michael.Mertens@JewellAssoc.com",{"$f":"$J$75","v":"Steven.Katzner@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q77)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q77),$R77:R77,0)),\"\",INDEX(J:J,$Q77)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q77)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q77),$R77:S77,0)),\"\",INDEX(K:K,$Q77)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q77)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q77),$R77:T77,0)),\"\",INDEX(L:L,$Q77)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q77)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q77),$R77:U77,0)),\"\",INDEX(M:M,$Q77)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,25,"Iowa","Craig Hardy","Craig Hardy",1516,"*County",null,"craig.hardy@iowacounty.org","craig.hardy@iowacounty.org","Steven.Katzner@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q78)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q78),$R78:R78,0)),\"\",INDEX(J:J,$Q78)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q78)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q78),$R78:S78,0)),\"\",INDEX(K:K,$Q78)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q78)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q78),$R78:T78,0)),\"\",INDEX(L:L,$Q78)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q78)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q78),$R78:U78,0)),\"\",INDEX(M:M,$Q78)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,33,"Lafayette","Tom R. Jean","Mike Reynolds",9538,"Consultant","Michael Reynolds","tom.jean@lafayettecountywi.org","mreynolds@wppienergy.org","Steven.Katzner@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q79)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q79),$R79:R79,0)),\"\",INDEX(J:J,$Q79)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q79)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q79),$R79:S79,0)),\"\",INDEX(K:K,$Q79)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q79)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q79),$R79:T79,0)),\"\",INDEX(L:L,$Q79)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q79)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q79),$R79:U79,0)),\"\",INDEX(M:M,$Q79)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,53,"Rock","Duane Jorgenson","David McDermid",9595,"Consultant","MSA","duane.jorgenson@co.rock.wi.us","dmcdermid@msa-ps.com","Steven.Katzner@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q80)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q80),$R80:R80,0)),\"\",INDEX(J:J,$Q80)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q80)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q80),$R80:S80,0)),\"\",INDEX(K:K,$Q80)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q80)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q80),$R80:T80,0)),\"\",INDEX(L:L,$Q80)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q80)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q80),$R80:U80,0)),\"\",INDEX(M:M,$Q80)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,56,"Sauk","Pat Gavinski","Pat Gavinski",1015,"*County",null,"pgavinski@co.sauk.wi.us","pgavinski@co.sauk.wi.us","Steven.Katzner@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q81)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q81),$R81:R81,0)),\"\",INDEX(J:J,$Q81)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q81)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q81),$R81:S81,0)),\"\",INDEX(K:K,$Q81)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q81)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q81),$R81:T81,0)),\"\",INDEX(L:L,$Q81)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q81)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q81),$R81:U81,0)),\"\",INDEX(M:M,$Q81)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q82)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q82),$R82:R82,0)),\"\",INDEX(J:J,$Q82)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q82)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q82),$R82:S82,0)),\"\",INDEX(K:K,$Q82)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q82)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q82),$R82:T82,0)),\"\",INDEX(L:L,$Q82)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q82)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q82),$R82:U82,0)),\"\",INDEX(M:M,$Q82)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
["SE - Waukesha",{"$f":"joinVert(B84:B90)","v":"30,40,45,51,64,66,67"},null,null,"John Bolka",2007,"State",null,null,"John.Bolka@dot.wi.gov",null,"Bao.Tran@dot.wi.gov",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q83)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q83),$R83:R83,0)),\"\",INDEX(J:J,$Q83)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q83)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q83),$R83:S83,0)),\"\",INDEX(K:K,$Q83)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q83)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q83),$R83:T83,0)),\"\",INDEX(L:L,$Q83)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q83)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q83),$R83:U83,0)),\"\",INDEX(M:M,$Q83)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,30,"Kenosha","Clement Abongwa","Aaron Palmer",9508,"Consultant","Westbrook","Clement.Abongwa@kenoshacounty.org","apalmer@westbrookeng.com",{"$f":"$J$83","v":"John.Bolka@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q84)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q84),$R84:R84,0)),\"\",INDEX(J:J,$Q84)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q84)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q84),$R84:S84,0)),\"\",INDEX(K:K,$Q84)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q84)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q84),$R84:T84,0)),\"\",INDEX(L:L,$Q84)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q84)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q84),$R84:U84,0)),\"\",INDEX(M:M,$Q84)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,40,"Milwaukee","Aziz Aleiow","Steve Miller",9535,"Consultant","Collins","Abdulaziz.Aleiow@milwaukeecountywi.gov","smiller@collinsengr.com",{"$f":"$J$83","v":"John.Bolka@dot.wi.gov"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q85)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q85),$R85:R85,0)),\"\",INDEX(J:J,$Q85)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q85)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q85),$R85:S85,0)),\"\",INDEX(K:K,$Q85)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q85)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q85),$R85:T85,0)),\"\",INDEX(L:L,$Q85)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q85)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q85),$R85:U85,0)),\"\",INDEX(M:M,$Q85)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,45,"Ozaukee","Jon Edgren","Greg Jewell",9575,"Consultant","Jewell Associates","jedgren@co.ozaukee.wi.us","Greg.Jewell@JewellAssoc.com","John.Bolka@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q86)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q86),$R86:R86,0)),\"\",INDEX(J:J,$Q86)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q86)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q86),$R86:S86,0)),\"\",INDEX(K:K,$Q86)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q86)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q86),$R86:T86,0)),\"\",INDEX(L:L,$Q86)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q86)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q86),$R86:U86,0)),\"\",INDEX(M:M,$Q86)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,51,"Racine","Roland Behm","Tom Ludwig",9546,"Consultant","Foth Infrastrucutre","Roland.Behm@racinecounty.com","tom.ludwig@foth.com","John.Bolka@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q87)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q87),$R87:R87,0)),\"\",INDEX(J:J,$Q87)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q87)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q87),$R87:S87,0)),\"\",INDEX(K:K,$Q87)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q87)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q87),$R87:T87,0)),\"\",INDEX(L:L,$Q87)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q87)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q87),$R87:U87,0)),\"\",INDEX(M:M,$Q87)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,64,"Walworth","Richard Hough","Brian Schroeder",9540,"Consultant","Ayres","rhough@co.walworth.wi.us","schroederb@ayresassociates.com","John.Bolka@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q88)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q88),$R88:R88,0)),\"\",INDEX(J:J,$Q88)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q88)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q88),$R88:S88,0)),\"\",INDEX(K:K,$Q88)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q88)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q88),$R88:T88,0)),\"\",INDEX(L:L,$Q88)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q88)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q88),$R88:U88,0)),\"\",INDEX(M:M,$Q88)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,66,"Washington","Scott Schmidt","Scott Schmidt",2500,"*County",null,"scott.schmidt@co.washington.wi.us","scott.schmidt@co.washington.wi.us","John.Bolka@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q89)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q89),$R89:R89,0)),\"\",INDEX(J:J,$Q89)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q89)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q89),$R89:S89,0)),\"\",INDEX(K:K,$Q89)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q89)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q89),$R89:T89,0)),\"\",INDEX(L:L,$Q89)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q89)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q89),$R89:U89,0)),\"\",INDEX(M:M,$Q89)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,67,"Waukesha","Allison Bussler","Kevin Yanny",2504,"County",null,"abussler@waukeshacounty.gov","kyanny@waukeshacounty.gov","John.Bolka@dot.wi.gov",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q90)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q90),$R90:R90,0)),\"\",INDEX(J:J,$Q90)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q90)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q90),$R90:S90,0)),\"\",INDEX(K:K,$Q90)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q90)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q90),$R90:T90,0)),\"\",INDEX(L:L,$Q90)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q90)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q90),$R90:U90,0)),\"\",INDEX(M:M,$Q90)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q91)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q91),$R91:R91,0)),\"\",INDEX(J:J,$Q91)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q91)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q91),$R91:S91,0)),\"\",INDEX(K:K,$Q91)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q91)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q91),$R91:T91,0)),\"\",INDEX(L:L,$Q91)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q91)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q91),$R91:U91,0)),\"\",INDEX(M:M,$Q91)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q92)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q92),$R92:R92,0)),\"\",INDEX(J:J,$Q92)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q92)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q92),$R92:S92,0)),\"\",INDEX(K:K,$Q92)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q92)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q92),$R92:T92,0)),\"\",INDEX(L:L,$Q92)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q92)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q92),$R92:U92,0)),\"\",INDEX(M:M,$Q92)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(INDEX(J:J,$Q93)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(J:J,$Q93),$R93:R93,0)),\"\",INDEX(J:J,$Q93)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(K:K,$Q93)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(K:K,$Q93),$R93:S93,0)),\"\",INDEX(K:K,$Q93)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(L:L,$Q93)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(L:L,$Q93),$R93:T93,0)),\"\",INDEX(L:L,$Q93)))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(M:M,$Q93)=\"\",\"\",IF(ISNUMBER(MATCH(INDEX(M:M,$Q93),$R93:U93,0)),\"\",INDEX(M:M,$Q93)))","v":{"$error":"#REF!"}},{"$f":"ISNUMBER(SEARCH(\"local\",#REF!))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(#REF!,2)","v":{"$error":"#REF!"}}]