{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Mailmerge","Project Info","Region_1","Region_2","Region_3","Region_4"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":3,"comments":5,"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":"Mailmerge","index":0,"n_rows":3,"n_cols":44,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["PIN","ROUTE","COUNTY","DESCRIPTION","OFFICE_HEAD","OF_PHONE","OF_EMAIL","Proj Manager","Design Manager","Owner","Address","City","State","ZIP","map","parcel","CC_Name1","CC_Name2","CC_Name3","CC_Name4","CC_Name5","CC_Name6","CC_Name7","CC_Name8","CC_Name9","CC_Name10","CC_Name11","CC_Name12","CC_Name13","CC_Name14","CC_Name15","Contact_1","Con1_Phone","Contact_2","Con2_Phone","Contact_3","Con3_Phone","Sig_1","PROJ_NUM","Mail_Date","LetterHead_Region","LetterHead_Address","LetterHead_CityState","Sig_2"]
["000343.00",23423,"BLOUNT;BLOUNT",23423,"Mr. Lance Click","(423) 928-4572","lance.click@tn.gov",null,"Mr. Paul Beebe",345,435,345,345,345,345,345,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3423]
["000343.00",23423,"BLOUNT;BLOUNT",23423,"Mr. Lance Click","(423) 928-4572","lance.click@tn.gov",null,"Mr. Paul Beebe",345,435,345,345,345,345,345,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3423]

{"sheet":"Project Info","index":1,"n_rows":20,"n_cols":27,"rows_kept":20,"cut":false,"hidden":false,"merged":[[7,2,9,2],[18,1,18,10],[7,0,9,1]]}
[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,1]
[null,"Region:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[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,3]
[null,"PIN No:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Route:"]
[null,"County:"]
[null,"Project No:"]
["Description:"]
[]
[]
[]
[null,"Office Head:"]
[]
[null,"Design Manager:"]
[null,"Phone:"]
[null,"Email:"]
[]
[]
[null,"Property Owner and R.O.W. Acquistion Table Information"]
[null,"Tract No.","Owner","Address","City","State","ZIP","Map","Parcel","Deed Book","Page No."]

{"sheet":"Region_1","index":2,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"County","Office Head","Office Head Phone","Office Head Email","Project Manager","Design Manager","Carbon Copy Names","Contacts","Contact Numbers","Signatures","Signature Picture Location or Text Font Name","Letterhead Office","Letterhead Address","Letterhead City, State","Consultant - For State Name"]
[null,"ANDERSON","Mr. C. Kent Fox","(865) 594-2358","Christopher.Fox@tn.gov",null,"Ms. Christie Brown","Mrs. Jennifer Lloyd","Mr. C. Kent Fox","(865) 594-2358","<DO NOT DELETE>","<DO NOT DELETE>","REGION 1 SURVEY & ROADWAY DESIGN OFFICE","7345 Region Lane","Knoxville, TN 37914-9563","Kent Fox, P.E.,R.L.S."]
[null,"BLOUNT","Mr. Michael Dick","(865) 594-2481","Michael.Dick@tn.gov",null,"Mr. Freddy Miller","Mr. Steve Borden","Mr. Michael Dick","(865) 594-2481"]
[null,"CAMPBELL","Mr. Jeff Arwood","(865) 594-0219","Jeffrey.Arwood@tn.gov",null,"Mr. Eric Wilson","Mr. Dexter Justis","Mr. Keith Hartman","(423) 854-0086"]
[null,"CARTER","Mr. Keith Hartman","(423) 854-0086","Edward.Hartman@tn.gov",null,"Mr. Andrew Padgett","Ms. Christie Brown","Mr. Jeff Arwood","(865) 594-0219"]
[null,"CLAIBORNE","Mr. Eric Pickering","(423) 854-5128","James.Pickering@tn.gov",null,"Mr. Stacy Weaver","Mr. Eric Wilson"]
[null,"COCKE","Ms. Bobbie Lowe","(423) 601-7018","Bobbie.Lowe@tn.gov",null,"Mr. Larry Jordan","Mr. Stacy Weaver"]
[null,"GRAINGER","Mr. Wesley Vaughn","(865) 594-2357","Wesley.Vaughn@tn.gov",null,"Mr. Pete Falkenberg","Mr. Andrew Padgett"]
[null,"GREENE","Mr. Eric Schindler","(865) 594-2356","Eric.Schindler@tn.gov",null,"Mr. Jim Bivens","Mr. C. Kent Fox"]
[null,"HAMBLEN",null,null,null,null,"Mr. Moosa Pourali","Mr. Michael Dick"]
[null,"HANCOCK",null,null,null,null,null,"Mr. Keith Hartman"]
[null,"HAWKINS",null,null,null,null,null,"Mr. Jeff Arwood"]
[null,"JEFFERSON",null,null,null,null,null,"File"]
[null,"JOHNSON"]
[null,"KNOX"]
[null,"LOUDON"]
[null,"MONROE"]
[null,"MORGAN"]
[null,"ROANE"]
[null,"SCOTT"]
[null,"SEVIER"]
[null,"SULLIVAN"]
[null,"UNICOI"]
[null,"UNION"]
[null,"WASHINGTON"]

{"sheet":"Region_2","index":3,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"County","Office Head","Office Head Phone","Office Head Email","Project Manager","Design Manager","Carbon Copy Names","Contacts","Contact Numbers","Signatures","Signature Picture Location or Text Font Name","Letterhead Office","Letterhead Address","Letterhead City, State","Consultant - For State Name"]
[null,"BLEDSOE","Mr. Gary Chapman"," (423) 510-1144","gary.chapman@tn.gov",null,"Mr. Robert Rodgers","Mrs. Jennifer Lloyd","Mr. Hatton Vanhook","(423) 510-1145","<DO NOT DELETE>","<DO NOT DELETE>","REGION 2 SURVEY & ROADWAY DESIGN OFFICE","7512 Volkswagen Dr., Bldg. C","Chattanooga, TN 37416-1758","Hatton Vanhook, P.E.,R.L.S."]
[null,"BRADLEY","Mr. Robert McClendon"," (423) 510-1240","Robert.mcclendon@tn.gov",null,"Mr. Greg Taylor ","Mr. Wesley Hughen","Mr. Gary Chapman","(423) 510-1144"]
[null,"CANNON","Mr. James Copeland"," (931) 528-9270","james.copeland@tn.gov",null,"Mr. Robert Rodgers","Mr. Robert Rodgers","Mr. Robert McCLendon","(423) 510-1240"]
[null,"CLAY","Mr. Robert Hamilton, Jr."," (423) 892-3430","robert.hamilton@tn.gov",null,"Mr. David Yates","Mr. Greg Taylor "]
[null,"COFFEE","Ms. Kay Reagan"," (931) 528-9270","kay.reagan@tn.gov",null,"Mr. Pete Falkenberg","Mr. Robert Rodgers"]
[null,"CUMBERLAND","Mr. David Sims"," (423) 949-2019","david.sims@tn.gov",null,"Mr. Jim Bivens","Mr. David Yates"]
[null,"DEKALB","Mr. Hatton Vanhook"," (423) 510-1145","hatton.vanhook@tn.gov",null,"Mr. Larry Jordan","Mr. Gary Chapman"]
[null,"FENTRESS",null,null,null,null,"Mr. Jerry Hughes","Mr. Robert McClendon"]
[null,"FRANKLIN",null,null,null,null,null,"Mr. Robert Hamilton, Jr."]
[null,"GRUNDY",null,null,null,null,null,"Mr. David Sims"]
[null,"HAMILTON",null,null,null,null,null,"Mr. Hatton Vanhook"]
[null,"JACKSON",null,null,null,null,null,"Ms. Kay Reagan"]
[null,"MCMINN",null,null,null,null,null,"File"]
[null,"MARION"]
[null,"MEIGS"]
[null,"OVERTON"]
[null,"PICKETT"]
[null,"POLK"]
[null,"PUTNAM"]
[null,"RHEA"]
[null,"SEQUATCHIE"]
[null,"VAN BUREN"]
[null,"WARREN"]
[null,"WHITE"]

{"sheet":"Region_3","index":4,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"County","Office Head","Office Head Phone","Office Head Email","Project Manager","Design Manager","Carbon Copy Names","Contacts","Contact Numbers","Signatures","Signature Picture Location or Text Font Name","Letterhead Office","Letterhead Address","Letterhead City, State","Consultant - For State Name"]
[null,"BEDFORD","Ms. Melissa Portell","(615) 350-4485","melissa.portell@tn.gov",null,"Ms. Sharon Schutz","Mrs. Jennifer Lloyd","Ms. Melissa Portell","(615) 350-4485","<DO NOT DELETE>","<DO NOT DELETE>","REGION 3 SURVEY & ROADWAY DESIGN OFFICE","6636 Centennial Boulevard","Nashville, TN  37243-1016","Melissa Portell, P.E., R.L.S."]
[null,"CHEATHAM","Mr. Terry Boguskie","(615) 350-4487","terry.boguskie@tn.gov",null,"Mr. Freddy Miller ","Mr. Shane Hester","Mr. Terry Boguskie","(615) 350-4487"]
[null,"DAVIDSON","Mr. Charles Gavaghan","(615) 350-4486","charles.gavaghan@tn.gov",null,"Mr. Brad Abel","Ms. Sharon Schutz","Mr. Nathan Gregory","(615) 350-4221"]
[null,"DICKSON","Mr. Rusty Boguskie","(615) 350-4265","rusty.boguskie@tn.gov",null,"Mr. Bradley Martin","Mr. Houston Greer"]
[null,"GILES","Mr. Brad Montgomery","(615) 350-4231","brad.montgomery@tn.gov",null,"Mr. Aso Hawrami","Mr. Brad Abel"]
[null,"HICKMAN","Mr. Chris Foster","(615) 837-5001","chris.foster@tn.gov",null,"Mr. Moosa Pourali","Mr. Bradley Martin"]
[null,"HOUSTON","Mr. Nathan Gregory","(615) 350-4221","nathan.gregory@tn.gov",null,"Mr. Larry Jordan","Mr. Aso Hawrami"]
[null,"HUMPHREYS","Ms. Lindsay Miller","(615) 253-4844","lindsay.miller@tn.gov",null,"Mr. Pete Falkenberg","Ms. Melissa Portell"]
[null,"LAWRENCE",null,null,null,null,"Mr. Jim Bivens","Mr. Terry Boguskie"]
[null,"LEWIS",null,null,null,null,null,"Mr. Robert Jowers"]
[null,"LINCOLN",null,null,null,null,null,"Ms. Kathryn Shulte"]
[null,"MACON",null,null,null,null,null,"Mr. James Kelley"]
[null,"MARSHALL",null,null,null,null,null,"Ms. Dawn Pruitt"]
[null,"MAURY",null,null,null,null,null,"Mr. Jon Zirkle"]
[null,"MONTGOMERY",null,null,null,null,null,"Mr. Jim Turrisi"]
[null,"MOORE",null,null,null,null,null,"File"]
[null,"PERRY"]
[null,"ROBERTSON"]
[null,"RUTHERFORD"]
[null,"SMITH"]
[null,"STEWART"]
[null,"SUMNER"]
[null,"TROUSDALE"]
[null,"WAYNE"]
[null,"WILLIAMSON"]
[null,"WILSON"]

{"sheet":"Region_4","index":5,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"County","Office Head","Office Head Phone","Office Head Email","Project Manager","Design Manager","Carbon Copy Names","Contacts","Contact Numbers","Signatures","Signature Picture Location or Text Font Name","Letterhead Office","Letterhead Address","Letterhead City, State","Consultant - For State Name"]
[null,"BENTON","Mr. Howard G. Blankenship"," (731) 935-0137","glen.blankenship@tn.gov",null,"Mr. Freddy Miller","Mrs. Jennifer Lloyd","Mr. Howard G. Blankenship","(615) 741-0450","<DO NOT DELETE>","<DO NOT DELETE>","REGION 4 SURVEY & ROADWAY DESIGN OFFICE","300 Benchmark Place","Jackson, TN 38301-9712","Howard G. Blankenship, P.E.,R.L.S."]
[null,"CARROLL","Mr. James Boyd"," (731) 935-0138","james.boyd@tn.gov",null,"Ms. Tabitha Cavaness","Mr. Jason Baker","Mr. James Boyd"," (731) 935-0137"]
[null,"CHESTER","Mr. Robert Hope, Jr."," (731) 935-0241","robert.hope@tn.gov",null,"Mr. Gary Scruggs","Ms. Tabitha Cavaness","Mr. Robert Hope, Jr."," (731) 935-0242"]
[null,"CROCKETT","Mr. Jonathan Dodd"," (731) 935-0295","jonathan.dodd@tn.gov",null,"Ms. Rachel Webb","Mr. Gary Scruggs","Mr. Jonathan Dodd","(615) 741-6339"]
[null,"DECATUR","Mr. Jimmy Hawks"," (731) 935-0242","jimmy.hawks@tn.gov",null,"Mr. Seth Hendren","Mr. Howard G. Blankenship"]
[null,"DYER","Mr. Dean Brown"," (731) 935-0240","bennie.brown@tn.gov",null,"Mr. Dennis Moultrie","Ms. Rachel Webb"]
[null,"FAYETTE",null,null,null,null,"Mr. Larry Jordan","Mr. James Boyd"]
[null,"GIBSON",null,null,null,null,"Mr. Jerry Hughes","Mr. Robert Hope, Jr."]
[null,"HARDEMAN",null,null,null,null,null,"Mr. Johnathan Dodd"]
[null,"HARDIN",null,null,null,null,null,"Mr. Steve Chipman"]
[null,"HAYWOOD",null,null,null,null,null,"Mr. Tim McLillie"]
[null,"HENDERSON",null,null,null,null,null,"Mr. Robert Jowers"]
[null,"HENRY",null,null,null,null,null,"File"]
[null,"LAKE"]
[null,"LAUDERDALE"]
[null,"MCNAIRY"]
[null,"MADISON"]
[null,"OBION"]
[null,"SHELBY"]
[null,"TIPTON"]
[null,"WEAKLEY"]