{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Main","Data","PAR01-General","PAR02-Mode","PAR03-List"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":"Main","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"On the Edge of Tomorrow"]
[null,null,"Dynamic Data Validation"]
[null,null,"Version 0.1"]
[]
[]
[]
[null,null,{"$f":"\"If the button above does not take you to the \"&Data!B1&\" worksheets, click on the link below to learn how to\"","v":"If the button above does not take you to the Data worksheets, click on the link below to learn how to"}]
[null,null,"Enable or disable macros in Office files"]
[]
[null,null,{"$f":"\"Current Mode: \"&rng_mode_current","v":"Current Mode: User Mode"}]
[]
[null,null,"At any time ..."]
[null,null,"Shift + Ctrl + U for User Mode"]
[null,null,"Shift + Ctrl + A for Admin Mode (password is admin)"]

{"sheet":"Data","index":1,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)","v":"Data"},null,null,null,null,null,null,null,"Dynamic Data Validation Lists via two methods"]
[null,"Worksheet where the key data of the model resides.",null,null,null,null,null,null,null,"Method 1","Method 2"]
[null,"See post:","http://sprestridge.net/excel/2017/03/14/Dynamic-Data-Validation.html",null,null,null,null,null,null,null,null,null,"These columns demonstrate the results of MATCH and COUNTIF"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rows","Range"]
[null,"UniqueID","Asset Description","Data2","Qty","UoM","PRV","Risk","DomainID","SystemValue","Value",null,"below C7","Height"]
[null,1,"Building 101",47,92876,"SF",1731266,4,"BLDG","Administrative","Administrative",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":11},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":10}]
[null,2,"Building 102",8,4025,"SF",1553687,9,"BLDG","Utility","Utility",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":11},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":10}]
[null,3,"Building 103",71,8342,"SF",1269428,4,"BLDG","Transportation","Transportation",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":11},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":10}]
[null,4,"Building 104",31,16333,"SF",1275805,3,"BLDG","Storage","Storage",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":11},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":10}]
[null,5,"Building 105",68,52152,"SF",1919720,6,"BLDG","Maintenance","Maintenance",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":11},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":10}]
[null,6,"Building 106",99,86113,"SF",3698073,3,"BLDG","Laboratory / Research","Laboratory / Research",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":11},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":10}]
[null,7,"Building 107",80,86553,"SF",2980870,1,"BLDG","Educational Center","Educational Center",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":11},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":10}]
[null,8,"Building 108",27,15554,"SF",2824328,7,"BLDG","Medical","Medical",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":11},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":10}]
[null,9,"Building 109",15,23644,"SF",2041228,6,"BLDG","Power Generating","Power Generating",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":11},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":10}]
[null,10,"Parking Lot 10",90,139000,"SF",118257,7,"PARKLOT","Paved","Paved",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":65},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":2}]
[null,11,"Parking Lot 11",57,124000,"SF",121561,10,"PARKLOT","Paved","Paved",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":65},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":2}]
[null,12,"Parking Lot 12",77,126200,"SF",103779,1,"PARKLOT","Paved","Paved",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":65},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":2}]
[null,13,"Parking Lot 13",70,67800,"SF",99670,10,"PARKLOT","Paved","Paved",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":65},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":2}]
[null,14,"Parking Lot 14",78,122900,"SF",68582,7,"PARKLOT","Paved","Paved",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":65},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":2}]
[null,15,"Parking Lot 15",51,26900,"SF",115847,7,"PARKLOT","Unpaved","Unpaved",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":65},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":2}]
[null,16,"Parking Lot 16",60,26700,"SF",134908,10,"PARKLOT","Unpaved","Unpaved",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":65},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":2}]
[null,17,"Parking Lot 17",62,126000,"SF",57882,5,"PARKLOT","Paved","Paved",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":65},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":2}]
[null,18,"Parking Lot 18",39,149400,"SF",88155,2,"PARKLOT","Paved","Paved",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":65},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":2}]
[null,19,"Parking Lot 19",28,66900,"SF",103914,2,"PARKLOT","Paved","Paved",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":65},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":2}]
[null,20,"Trail 220",56,2.8902800232510124,"MI",1048751,5,"TREADTYPE","Native","Native",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":67},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":8}]
[null,21,"Trail 221",84,4.7271357496344688,"MI",493499,5,"TREADTYPE","Gravel","Gravel",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":67},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":8}]
[null,22,"Trail 222",18,2.2032282562090653,"MI",1124216,1,"TREADTYPE","Chunk Wood","Chunk Wood",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":67},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":8}]
[null,23,"Trail 223",37,3.6184549130934545,"MI",815034,6,"TREADTYPE","Asphalt","Asphalt",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":67},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":8}]
[null,24,"Culvert 324",45,null,null,45571,5,"CULVERT","CONCR","CONCR",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":60},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":5}]
[null,25,"Culvert 325",35,null,null,33385,3,"CULVERT","CONCR","CONCR",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":60},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":5}]
[null,26,"Culvert 326",12,null,null,30467,6,"CULVERT","CONCR","CONCR",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":60},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":5}]
[null,27,"Footbridge 327",39,{"$f":"2*8","v":16},"SF",96243,9,"BRDTYPE","Wood or Timber","Wood or Timber",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":21},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":31}]
[null,28,"Footbridge 328",19,{"$f":"6*40","v":240},"SF",119013,9,"BRDTYPE","Wood or Timber","Wood or Timber",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":21},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":31}]
[null,29,"Footbridge 329",65,{"$f":"8*50","v":400},"SF",115888,3,"BRDTYPE","Wood or Timber","Wood or Timber",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":21},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":31}]
[null,30,"Vehicle Bridge 330",38,{"$f":"24*40","v":960},"SF",418627,4,"BRDTYPE","Beam Bridge","Beam Bridge",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":21},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":31}]
[null,31,"Vehicle Bridge 332",89,{"$f":"24*25","v":600},"SF",695626,4,"BRDTYPE","Girder","Girder",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":21},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":31}]
[null,32,{"$f":"\"HVAC Unit 1\"&B37","v":"HVAC Unit 132"},12,1,"EA",27046,10,"ACPACKHEAT","Electric","Electric",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":0},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":11}]
[null,33,{"$f":"\"HVAC Unit 1\"&B38","v":"HVAC Unit 133"},68,1,"EA",21192,8,"ACPACKHEAT","Gas","Gas",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":0},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":11}]
[null,34,"HVAC Unit 134",33,1,"EA",21925,9,"ACPACKHEAT","Oil","Oil",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":0},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":11}]
[null,35,"HVAC Unit 135",89,1,"EA",21927,3,"ACPACKHEAT","Hydronic","Hydronic",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":0},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":11}]
[null,36,"Building 101",67,92876,"SF",1731266,1,"YEAR",2005,2005,null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":75},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":18}]
[null,37,"Building 102",41,4025,"SF",1553687,6,"YEAR",2003,2003,null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":75},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":18}]
[null,38,"Building 103",76,8342,"SF",1269428,6,"YEAR",2016,2016,null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":75},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":18}]
[null,39,"Bus 939",51,1,"EA",415937,2,"BUSTYPE","30 FOOT","30 FOOT",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":52},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":8}]
[null,40,"Bus 940",42,1,"EA",637488,1,"BUSTYPE","ARTICULATED","ARTICULATED",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":52},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":8}]
[null,41,"Bus 941",63,1,"EA",619657,3,"BUSTYPE","40 FOOT","40 FOOT",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":52},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":8}]
[null,42,"Bus 942",80,1,"EA",612527,1,"BUSTYPE","SHUTTLE","SHUTTLE",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":52},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":8}]
[null,43,"Bus 939",51,1,"EA",415937,2,"YORN","Yes","Yes",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":93},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":2}]
[null,44,"Bus 941",63,1,"EA",619657,3,"YORN","No","No",null,{"$f":"MATCH(tbl_data[[#This Row],[DomainID]],rng_DomainID,0) - 1","v":93},{"$f":"COUNTIF(tbl_list[DomainID],tbl_data[[#This Row],[DomainID]])","v":2}]

{"sheet":"PAR01-General","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)","v":"PAR01-General"}]
[null,"General Parameters"]
[]
[null,null," = tbl_NamedRanges"]
[]
[null,null,"Name","Range"]
[null,null,"pick_Value","(dynamic)"]
[null,null,"rng_DomainID","=Table4[DomainID]"]
[null,null,"rng_mode_current","='PAR02-Mode'!$E$4"]
[null,null,"rng_Value","=Table4[Value]"]

{"sheet":"PAR02-Mode","index":3,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)","v":"PAR02-Mode"}]
[null,"Worksheet to manage the unique state of protection, visibility & other settings by Mode"]
[]
[null,null,null,"Current Mode","User Mode","= rng_mode_current"]
[]
[null,null,null,"Mode","Show Tabs"]
[null,null,null,"User Mode",1]
[null,null,null,"Admin Mode",1]
[]
[null,null,null,null,{"$f":"INDEX(tbl_mode[Mode],1)","v":"User Mode"},null,null,{"$f":"INDEX(tbl_mode[Mode],2)","v":"Admin Mode"}]
[null,null,null,"Name","U Visible","U Protect","U Heading","A Visible","A Protect","A Heading"]
[null,null,null,"Main",1,0,0,1,0,1]
[null,null,null,{"$f":"Data!B1","v":"Data"},1,0,1,1,0,1]
[null,null,null,{"$f":"'PAR01-General'!B1","v":"PAR01-General"},-1,1,0,1,0,1]
[null,null,null,{"$f":"B1","v":"PAR02-Mode"},-1,0,0,1,0,1]
[null,null,null,{"$f":"'PAR03-List'!B1","v":"PAR03-List"},1,0,1,1,0,1]
[]
[]
[null,null,null,null,{"$f":"INDEX(tbl_mode[Mode],1)","v":"User Mode"},null,null,{"$f":"INDEX(tbl_mode[Mode],2)","v":"Admin Mode"}]
[null,"R/C","Worksheet","Name","U Visible","U Points","Unused 1","A Visible","A Points","Unused 2"]
[null,"C","PAR02-Mode","K:K",1,0,null,1,0]

{"sheet":"PAR03-List","index":4,"n_rows":101,"n_cols":5,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)","v":"PAR03-List"}]
[null,"Worksheet for Validation lists"]
[]
[null,null,"= tbl_list"]
[]
[null,null,"DomainID","Value","Sort"]
[null,null,"ACPACKHEAT","Electric",1]
[null,null,"ACPACKHEAT","Gas",2]
[null,null,"ACPACKHEAT","Oil",3]
[null,null,"ACPACKHEAT","Propane",4]
[null,null,"ACPACKHEAT","Other",5]
[null,null,"ACPACKHEAT","Natural Gas",6]
[null,null,"ACPACKHEAT","Radiant",7]
[null,null,"ACPACKHEAT","Hydronic",8]
[null,null,"ACPACKHEAT","LPG Butane",9]
[null,null,"ACPACKHEAT","No Heat",10]
[null,null,"ACPACKHEAT","None",11]
[null,null,"BLDG","Administrative",1]
[null,null,"BLDG","Storage",2]
[null,null,"BLDG","Maintenance",3]
[null,null,"BLDG","Laboratory / Research",4]
[null,null,"BLDG","Utility",5]
[null,null,"BLDG","Educational Center",6]
[null,null,"BLDG","Medical",7]
[null,null,"BLDG","Power Generating",8]
[null,null,"BLDG","Transportation",9]
[null,null,"BLDG","Emergency Operations",10]
[null,null,"BRDTYPE","Arch - Deck",1]
[null,null,"BRDTYPE","Box Beam Multi",1]
[null,null,"BRDTYPE","Arch - Thru",2]
[null,null,"BRDTYPE","Box Girder",2]
[null,null,"BRDTYPE","Arch Bridge",3]
[null,null,"BRDTYPE","Cable Stay Brdg",3]
[null,null,"BRDTYPE","Beam Bridge",4]
[null,null,"BRDTYPE","Channel Beam",4]
[null,null,"BRDTYPE","Corrugated Steel; New Jersey Type",5]
[null,null,"BRDTYPE","Culvert",6]
[null,null,"BRDTYPE","Frame",7]
[null,null,"BRDTYPE","Girder",8]
[null,null,"BRDTYPE","Girder Box",9]
[null,null,"BRDTYPE","Girder Stayed",10]
[null,null,"BRDTYPE","Girder/Beam",11]
[null,null,"BRDTYPE","Lift Bridge",12]
[null,null,"BRDTYPE","Mixed Type",13]
[null,null,"BRDTYPE","Movable-Bascule",14]
[null,null,"BRDTYPE","Moveable - Lift",15]
[null,null,"BRDTYPE","Moveable - Swing",16]
[null,null,"BRDTYPE","Orthotropic",17]
[null,null,"BRDTYPE","Other",18]
[null,null,"BRDTYPE","Slab",19]
[null,null,"BRDTYPE","Steel Plates",20]
[null,null,"BRDTYPE","Stringer/Beam",21]
[null,null,"BRDTYPE","Suspension",22]
[null,null,"BRDTYPE","Tee Beam",23]
[null,null,"BRDTYPE","Truss - Deck",24]
[null,null,"BRDTYPE","Truss - Thru",25]
[null,null,"BRDTYPE","Tunnel",26]
[null,null,"BRDTYPE","Wood or Timber",27]
[null,null,"BUSTYPE","22 FOOT",1]
[null,null,"BUSTYPE","30 FOOT",2]
[null,null,"BUSTYPE","40 FOOT",3]
[null,null,"BUSTYPE","ARTICULATED",4]
[null,null,"BUSTYPE","SCHOOL",5]
[null,null,"BUSTYPE","SHUTTLE",6]
[null,null,"BUSTYPE","TROLLEY",7]
[null,null,"BUSTYPE","TROLLEY REP",8]
[null,null,"CULVERT","ASPH",1]
[null,null,"CULVERT","CONCR",2]
[null,null,"CULVERT","GRASS",3]
[null,null,"CULVERT","OTHER",4]
[null,null,"CULVERT","UNPAV",5]
[null,null,"PARKLOT","Paved",1]
[null,null,"PARKLOT","Unpaved",2]
[null,null,"TREADTYPE","Native",1]
[null,null,"TREADTYPE","Gravel",2]
[null,null,"TREADTYPE","Chunk Wood",3]
[null,null,"TREADTYPE","Asphalt",4]
[null,null,"TREADTYPE","Boardwalk",5]
[null,null,"TREADTYPE","Concrete",6]
[null,null,"TREADTYPE","Paver Block",7]
[null,null,"TREADTYPE","Riprap",8]
[null,null,"YEAR",2000,1]
[null,null,"YEAR",2001,2]
[null,null,"YEAR",2002,3]
[null,null,"YEAR",2003,4]
[null,null,"YEAR",2004,5]
[null,null,"YEAR",2005,6]
[null,null,"YEAR",2006,7]
[null,null,"YEAR",2007,8]
[null,null,"YEAR",2008,9]
[null,null,"YEAR",2009,10]
[null,null,"YEAR",2010,11]
[null,null,"YEAR",2011,12]
[null,null,"YEAR",2012,13]
[null,null,"YEAR",2013,14]
[null,null,"YEAR",2014,15]
[null,null,"YEAR",2015,16]
[null,null,"YEAR",2016,17]
[null,null,"YEAR",2017,18]
[null,null,"YORN","Yes",1]
[null,null,"YORN","No",2]