{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Read Me","Step 1. Exposure DATA","Step 1. Exposure Data Scores","Step 2. Sensitivity DATA","Step 2. Sensitivity Data Scores","Step 3. Potential Impact","Step 4. Adaptive Capacity DATA","Step 4. Adapt. Capacity Scores","Step 5. Vulnerability Analysis","Exposure Data Scoring","Sensitivity Data Scoring","Adaptive Capacity Scoring"],"not_rendered":{"charts":0,"images":0,"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":"Read Me","index":0,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Read Me","This tab presents a brief overview and introduction to the sequential tabs necessary to complete the vulnerability analysis. For more detailed information regarding the tabs and data sources, please refer to the instructions document that has been provided separately. Cells that are GREEN are meant for user input. All other cells should not be tampered with. If the user is not familiar with GIS data analysis, skip to Step 1. Exposure Data Scores and Step 2. Sensitivity Data Score and enter manual input using the Override? cells.",null,null,null,null,null,null,null,null,null,null,null,null,"Determine adaptive capacity below in Cell O9."]
["Tab","Description"]
["Read Me","This tab provides a brief overview and introduction to the process of the vulnerability analysis."]
["Step 1. Exposure DATA","Use this tab to populate the assets for the site of interest (includes an ID [e.g., FB1], asset name [e.g., Parking Lot], and site name [e.g., Flood Bay Wayside]) and populate data for the exposure indicators for each asset. Exposure indicators include flooding, storm surge/seiche, lake level rise, historical flooding, erosion, geology, soils, and fish and wildlife habitat. Data sources are discussed in detail in the instructions document provided separately."]
["Step 1. Exposure Data Scores","This tab provides scores for each of the exposure indicators based on the data sources compiled in the Exposure DATA tab and the scoring system identified in the Exposure Data Scoring tab. Summary scores are calculated for each of the exposure indicators for review by the user. Should the user identify an indicator score that should be overridden, this tab provides the opportunity to do so using the Override? columns and selecting from the assorted drop-down menu options. The tab then calculates the exposure score sum, the exposure score (average of the scores for each indicator), and the exposure rank."]
["Step 2. Sensitivity DATA","Use this tab to populate data for the sensitivity indicators for each asset. Sensitivity indicators include flood damage potential, storm resistance and condition, historical damage, protective engineering, infrastructure, fish and wildlife habitat, climate, and water quality. Data sources are discussed in detail in the instructions document provided separately."]
["Step 2. Sensitivity Data Scores","This tab provides scores for each of the sensitivity indicators based on the data sources compiled in the Sensitivity DATA tab and the scoring system identified in the Sensitivity Data Scoring tab. Summary scores are calculated for each of the sensitivity indicators for review by the user. Should the user identify an indicator score that should be overridden, this tab provides the opportunity to do so using the Override? columns and selecting from the assorted drop-down menu options. The tab then calculates the sensitivity score sum, the sensitivity score (average of the scores for each indicator), and the sensitivity rank."]
["Step 3. Potential Impact","This tab summarizes the results of the exposure and sensitivity analyses. The potential impact to the assets is calculated by averaging the exposure and sensitivity scores. This potential impact score is also used to create a potential impact rank. At this point, if adaptive capacity strategies are not going to be included, skip to the final tab: Step 5. Vulnerability Analysis. If adapative capacity strategies are going to be included, continue in order to the next tab, Adaptive Capacity DATA. If strategies will be implemented, select \"Yes\" from the drop down menu to the right. If strategies will not be implemented, select \"No\" and proceed to Step 5. "]
["Step 4. Adaptive Capacity DATA","This tab is optional and only applicable if adaptive capacity strategies are going to be implemented. If strategies will be implemented, select \"Yes\" from the drop-down menu to the right. If strategies will not be implemented, select \"No\" and proceed to Step 5. Use this tab to populate data for the adaptive capacity strategies and associated actions for each asset using the drop-down menus. Based on user selections, the options for each strategy will be dynamic; however, the user must select the actions in order (i.e., start at decommission and remove, followed by elevate, then relocate, then protect/engineer, then storm resistant design, then engineering downgrade). If the user selects \"Yes\" under decommission and remove, the user then must select the only option available on the rest of the adaptive strategies (\"N/A\"). Adaptive capacity strategies include decommission and remove, elevate, relocate, protect/engineer, storm resistant design, and engineering downgrade. Adaptive capacity actions associated with each strategy are provided in detail in the instructions document provided separately.",null,null,null,null,null,null,null,null,null,null,null,null,"Yes","Is adaptive capacity applicable to this site?"]
["Step 4. Adaptive Capacity Scores","This tab is optional and only applicable if adaptive capacity strategies are going to be implemented. If strategies will be implemented, select \"Yes\" from the drop-down menu to the right. If strategies will not be implemented, select \"No\" and proceed to Step 5. This tab provides summary scores for each of the adaptive capacity strategies and actions for review by the user. The tab then calculates the exposure adaptive capacity score, sensitivity adaptive capacity score, a sum of the adaptive capacity score, and the adaptive capacity score based on an average of the exposure and sensitivity adaptive capacity scores. Note that if \"Yes\" is chosen under decommission and remove, the adaptive capacity score automatically becomes 4 because the asset is eliminated."]
["Step 5. Vulnerability Analysis","This tab summarizes the results of the exposure, sensitivity, and potential impact analyses described on the previous tabs. The adaptive capacity score from the previous tab is also provided here (if applicable) which is subtracted from the potential impact score to provide a final vulnerability score and vulnerability rank. If adaptive capacity strategies are not included, the adaptive capacity score will be 0 and the potential impact score will be the same as the vulnerability score. However, if adaptive capacity strategies are incorporated, the final vulnerability score of the asset can be reduced. Note that if \"Yes\" is chosen under decommission and remove, the vulnerability score will automatically go to 0 because the asset has been eliminated."]
["Exposure Data Scoring","This hidden tab provides details for the scoring system for each of the exposure indicators based on the data compiled in the previous tab. The scoring can be altered based on preferences or updated data sources but should generally be left as provided."]
["Sensitivity Data Scoring","This hidden tab provides details for the scoring system for each of the sensitivity indicators based on the data compiled in the previous tab. The scoring can be altered based on preferences or updated data sources but should generally be left as provided."]
["Adaptive Capacity Scoring","This hidden tab provides details for the scoring system for each of the adaptive capacity strategies and actions based on the data compiled in the previous tab. The scoring can be altered based on preferences or updated adaptive strategies or actions but should generally be left as provided."]
["END OF WORKSHEET"]

{"sheet":"Step 1. Exposure DATA","index":1,"n_rows":7,"n_cols":26,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Step 1. Exposure DATA",null,null,null,"Flooding Indicator",null,"Storm Surge/Seiche Indicator",null,null,null,"Lake Level Rise",null,"Historical Flooding Indicator",null,"Erosion","Indicator","Geology","Indicator","Soils","Indicator",null,null,"Fish and Wildlife Habitat Indicator"]
["ID","Asset","Site","FEMA Flood Data","LiDAR Elevation Data","Flood Elevation Data","NOAA CO-OP Data","Slope Data","Fetch Exposure Index Data","Elevation Data","NOAA CO-OP Data","Elevation Data","USGS Stream Gage Data","NOAA AHPS Data","Erosion Data","CEHM Data","Bedrock Geology Data","Surficial Geology Data","gSSURGO Data","North Shore Red Clay Soils Data","Scientific and Natural Areas?","State Aquatic Management Areas?","Native Plant Communities?","Site of Biodiversity Signficance?","National Wetland Inventory?","Wildlife Management Area?"]
[null,null,null,null,null,{"$f":"E3-608.4","v":-608.4},null,null,null,{"$f":"E3-G3","v":0},null,{"$f":"J3-K3","v":0}]
[null,null,null,null,null,{"$f":"E4-608.4","v":-608.4},null,null,null,{"$f":"E4-G4","v":0},null,{"$f":"J4-K4","v":0}]
[null,null,null,null,null,-608.4,null,null,null,0,null,0]
[null,null,null,null,null,-608.4,null,null,null,0,null,0]
["END OF WORKSHEET"]

{"sheet":"Step 1. Exposure Data Scores","index":2,"n_rows":7,"n_cols":53,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Step 1. Exposure Data Scores",null,null,null,null,"Flooding Indicator",null,null,null,null,null,null,"Storm Surge/Seiche Indicator",null,null,null,null,null,"Lake Level Rise Indicator",null,null,null,null,"Historical Flooding Indicator",null,null,null,null,"Erosion Indicator",null,null,null,null,"Geology Indicator",null,null,null,null,"Soils Indicator",null,null,null,null,null,"Fish and Wildlife Habitat Indicator"]
["ID","Asset","Site","FEMA Flood Score","LiDAR Elevation Score","Flood Elevation Score","Flooding Score","Override?","Flooding Score Final","NOAA CO-OP Score","Slope Score","Fetch Exposure Index Score","Elevation Score","Storm Surge/Seiche Score","Override?","Storm Surge/Seiche Score Final","NOAA CO-OP Score","Elevation Score","Lake Level Rise Score","Override?","Lake Level Rise Score Final","USGS Stream Gage Score","NOAA AHPS Score","Historical Flooding Score","Override?","Historical Flooding Score Final","Erosion Score","CEHM Score","Erosion Score","Override?","Erosion Score Final","USGS Bedrock Geology Score","USGS Surficial Geology Score","Geology Score","Override?","Geology Score Final","gSSURGO Score","North Shore Red Clay Soils Score","Soils Score","Override?","Soils Score Final","Scientific and Natural Areas Score","State Aquatic Management Areas Score","Native Plant Communities Score","Site of Biodiversity Significance Score","National Wetland Inventory Score","Wildlife Management Area Score","Fish and Wildlife Habitat Score","Override?","Fish and Wildlife Habitat Score Final","Exposure Score Sum","Exposure Score","Exposure Rank"]
[{"$f":"'Step 1. Exposure DATA'!A3","v":0},{"$f":"'Step 1. Exposure DATA'!B3","v":0},{"$f":"'Step 1. Exposure DATA'!C3","v":0},{"$f":"VLOOKUP('Step 1. Exposure DATA'!D3,'Exposure Data Scoring'!$A$3:$B$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"RANK('Step 1. Exposure DATA'!E3,'Step 1. Exposure DATA'!$E$3:$E$6,0)","v":{"$error":"#N/A"}},{"$f":"IF('Step 1. Exposure DATA'!F3<0,4,1)","v":4},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!D3:F3)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(H3),G3,ISNUMBER(H3),H3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!G3,'Exposure Data Scoring'!$G$3:$H$7,2,FALSE)","v":1},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!H3>='Exposure Data Scoring'!$I$3,4,'Step 1. Exposure DATA'!H3>='Exposure Data Scoring'!$I$4,3,'Step 1. Exposure DATA'!H3>='Exposure Data Scoring'!$I$5,2,'Step 1. Exposure DATA'!H3>='Exposure Data Scoring'!$I$6,1,'Step 1. Exposure DATA'!H3<'Exposure Data Scoring'!$I$6,0)","v":0},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!I3>='Exposure Data Scoring'!$K$3,4,'Step 1. Exposure DATA'!I3>='Exposure Data Scoring'!$K$4,3,'Step 1. Exposure DATA'!I3>='Exposure Data Scoring'!$K$5,2,'Step 1. Exposure DATA'!I3>='Exposure Data Scoring'!$K$6,1,'Step 1. Exposure DATA'!I3<'Exposure Data Scoring'!$K$6,0)","v":0},{"$f":"RANK('Step 1. Exposure DATA'!J3,'Step 1. Exposure DATA'!$J$3:$J$6,0)","v":1},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!J3:M3)","v":0.5},null,{"$f":"_xlfn.IFS(ISBLANK(O3),N3,ISNUMBER(O3),O3)","v":0.5},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!K3>=4,4,'Step 1. Exposure DATA'!K3>=3,3,'Step 1. Exposure DATA'!K3>=2,2,'Step 1. Exposure DATA'!K3>=1,1,'Step 1. Exposure DATA'!K3<1,0)","v":0},{"$f":"RANK('Step 1. Exposure DATA'!L3,'Step 1. Exposure DATA'!$L$3:$L$6,0)","v":1},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!Q3:R3)","v":0.5},null,{"$f":"_xlfn.IFS(ISBLANK(T3),S3,ISNUMBER(T3),T3)","v":0.5},{"$f":"_xlfn.RANK.EQ('Step 1. Exposure DATA'!M3,'Step 1. Exposure DATA'!$M$3:$M$6,1)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!N3>='Exposure Data Scoring'!$U$3,4,'Step 1. Exposure DATA'!N3>='Exposure Data Scoring'!$U$4,3,'Step 1. Exposure DATA'!N3>='Exposure Data Scoring'!$U$5,2,'Step 1. Exposure DATA'!N3>='Exposure Data Scoring'!$U$6,1)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!V3:W3)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(Y3),X3,ISNUMBER(Y3),Y3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!O3,'Exposure Data Scoring'!$W$3:$X$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!P3,'Exposure Data Scoring'!$Y$3:$Z$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AA3:AB3)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AD3),AC3,ISNUMBER(AD3),AD3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!Q3,'Exposure Data Scoring'!$AA$3:$AB$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!R3,'Exposure Data Scoring'!$AC$3:$AD$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AF3:AG3)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AI3),AH3,ISNUMBER(AI3),AI3)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!S3>='Exposure Data Scoring'!$AE$3,4,'Step 1. Exposure DATA'!S3>='Exposure Data Scoring'!$AE$4,3,'Step 1. Exposure DATA'!S3>='Exposure Data Scoring'!$AE$5,2,'Step 1. Exposure DATA'!S3>='Exposure Data Scoring'!$AE$6,1,'Step 1. Exposure DATA'!S3='Exposure Data Scoring'!$AE$7,0)","v":0},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!T3='Exposure Data Scoring'!$AG$3,4,'Step 1. Exposure DATA'!T3='Exposure Data Scoring'!$AG$4,2,'Step 1. Exposure DATA'!T3='Exposure Data Scoring'!$AG$5,1,'Step 1. Exposure DATA'!T3=\"N/A\",0)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AK3:AL3)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AN3),AM3,ISNUMBER(AN3),AN3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!U3,'Exposure Data Scoring'!$AI$3:$AJ$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!V3,'Exposure Data Scoring'!$AK$3:$AL$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!W3,'Exposure Data Scoring'!$AM$3:$AN$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!X3,'Exposure Data Scoring'!$AO$3:$AP$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!Y3,'Exposure Data Scoring'!$AQ$3:$AR$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!Z3,'Exposure Data Scoring'!$AS$3:$AT$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AP3:AS3)","v":{"$error":"#N/A"}},0,{"$f":"_xlfn.IFS(ISBLANK(AW3),AV3,ISNUMBER(AW3),AW3)","v":0},{"$f":"'Step 1. Exposure Data Scores'!I3+'Step 1. Exposure Data Scores'!P3+'Step 1. Exposure Data Scores'!U3+'Step 1. Exposure Data Scores'!Z3+'Step 1. Exposure Data Scores'!AE3+'Step 1. Exposure Data Scores'!AJ3+'Step 1. Exposure Data Scores'!AO3+'Step 1. Exposure Data Scores'!AX3","v":{"$error":"#N/A"}},{"$f":"MEDIAN('Step 1. Exposure Data Scores'!I3,'Step 1. Exposure Data Scores'!P3,'Step 1. Exposure Data Scores'!U3,'Step 1. Exposure Data Scores'!Z3,'Step 1. Exposure Data Scores'!AE3,'Step 1. Exposure Data Scores'!AJ3,'Step 1. Exposure Data Scores'!AO3,'Step 1. Exposure Data Scores'!AX3)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(AZ3>=3, \"High\",AZ3>=2, \"Moderate\", AZ3>=1, \"Low\", AZ3<1, \"Minimal\")","v":{"$error":"#N/A"}}]
[{"$f":"'Step 1. Exposure DATA'!A4","v":0},{"$f":"'Step 1. Exposure DATA'!B4","v":0},{"$f":"'Step 1. Exposure DATA'!C4","v":0},{"$f":"VLOOKUP('Step 1. Exposure DATA'!D4,'Exposure Data Scoring'!$A$3:$B$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"RANK('Step 1. Exposure DATA'!E4,'Step 1. Exposure DATA'!$E$3:$E$6,0)","v":{"$error":"#N/A"}},{"$f":"IF('Step 1. Exposure DATA'!F4<0,4,1)","v":4},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!D4:F4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(H4),G4,ISNUMBER(G4),G4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!G4,'Exposure Data Scoring'!$G$3:$H$7,2,FALSE)","v":1},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!H4>='Exposure Data Scoring'!$I$3,4,'Step 1. Exposure DATA'!H4>='Exposure Data Scoring'!$I$4,3,'Step 1. Exposure DATA'!H4>='Exposure Data Scoring'!$I$5,2,'Step 1. Exposure DATA'!H4>='Exposure Data Scoring'!$I$6,1,'Step 1. Exposure DATA'!H4<'Exposure Data Scoring'!$I$6,0)","v":0},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!I4>='Exposure Data Scoring'!$K$3,4,'Step 1. Exposure DATA'!I4>='Exposure Data Scoring'!$K$4,3,'Step 1. Exposure DATA'!I4>='Exposure Data Scoring'!$K$5,2,'Step 1. Exposure DATA'!I4>='Exposure Data Scoring'!$K$6,1,'Step 1. Exposure DATA'!I4<'Exposure Data Scoring'!$K$6,0)","v":0},{"$f":"RANK('Step 1. Exposure DATA'!J4,'Step 1. Exposure DATA'!$J$3:$J$6,0)","v":1},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!J4:M4)","v":0.5},null,{"$f":"_xlfn.IFS(ISBLANK(O4),N4,ISNUMBER(N4),N4)","v":0.5},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!K4>=4,4,'Step 1. Exposure DATA'!K4>=3,3,'Step 1. Exposure DATA'!K4>=2,2,'Step 1. Exposure DATA'!K4>=1,1,'Step 1. Exposure DATA'!K4<1,0)","v":0},{"$f":"RANK('Step 1. Exposure DATA'!L4,'Step 1. Exposure DATA'!$L$3:$L$6,0)","v":1},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!Q4:R4)","v":0.5},null,{"$f":"_xlfn.IFS(ISBLANK(T4),S4,ISNUMBER(S4),S4)","v":0.5},{"$f":"_xlfn.RANK.EQ('Step 1. Exposure DATA'!M4,'Step 1. Exposure DATA'!$M$3:$M$6,1)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!N4>='Exposure Data Scoring'!$U$3,4,'Step 1. Exposure DATA'!N4>='Exposure Data Scoring'!$U$4,3,'Step 1. Exposure DATA'!N4>='Exposure Data Scoring'!$U$5,2,'Step 1. Exposure DATA'!N4>='Exposure Data Scoring'!$U$6,1)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!V4:W4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(Y4),X4,ISNUMBER(X4),X4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!O4,'Exposure Data Scoring'!$W$3:$X$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!P4,'Exposure Data Scoring'!$Y$3:$Z$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AA4:AB4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AD4),AC4,ISNUMBER(AC4),AC4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!Q4,'Exposure Data Scoring'!$AA$3:$AB$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!R4,'Exposure Data Scoring'!$AC$3:$AD$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AF4:AG4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AI4),AH4,ISNUMBER(AH4),AH4)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!S4>='Exposure Data Scoring'!$AE$3,4,'Step 1. Exposure DATA'!S4>='Exposure Data Scoring'!$AE$4,3,'Step 1. Exposure DATA'!S4>='Exposure Data Scoring'!$AE$5,2,'Step 1. Exposure DATA'!S4>='Exposure Data Scoring'!$AE$6,1,'Step 1. Exposure DATA'!S4='Exposure Data Scoring'!$AE$7,0)","v":0},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!T4='Exposure Data Scoring'!$AG$3,4,'Step 1. Exposure DATA'!T4='Exposure Data Scoring'!$AG$4,2,'Step 1. Exposure DATA'!T4='Exposure Data Scoring'!$AG$5,1,'Step 1. Exposure DATA'!T4=\"N/A\",0)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AK4:AL4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AN4),AM4,ISNUMBER(AM4),AM4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!U4,'Exposure Data Scoring'!$AI$3:$AJ$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!V4,'Exposure Data Scoring'!$AK$3:$AL$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!W4,'Exposure Data Scoring'!$AM$3:$AN$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!X4,'Exposure Data Scoring'!$AO$3:$AP$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!Y4,'Exposure Data Scoring'!$AQ$3:$AR$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!Z4,'Exposure Data Scoring'!$AS$3:$AT$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AP4:AS4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AW4),AV4,ISNUMBER(AV4),AV4)","v":{"$error":"#N/A"}},{"$f":"'Step 1. Exposure Data Scores'!I4+'Step 1. Exposure Data Scores'!P4+'Step 1. Exposure Data Scores'!U4+'Step 1. Exposure Data Scores'!Z4+'Step 1. Exposure Data Scores'!AE4+'Step 1. Exposure Data Scores'!AJ4+'Step 1. Exposure Data Scores'!AO4+'Step 1. Exposure Data Scores'!AX4","v":{"$error":"#N/A"}},{"$f":"MEDIAN('Step 1. Exposure Data Scores'!I4,'Step 1. Exposure Data Scores'!P4,'Step 1. Exposure Data Scores'!U4,'Step 1. Exposure Data Scores'!Z4,'Step 1. Exposure Data Scores'!AE4,'Step 1. Exposure Data Scores'!AJ4,'Step 1. Exposure Data Scores'!AO4,'Step 1. Exposure Data Scores'!AX4)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(AZ4>=3, \"High\",AZ4>=2, \"Moderate\", AZ4>=1, \"Low\", AZ4<1, \"Minimal\")","v":{"$error":"#N/A"}}]
[{"$f":"'Step 1. Exposure DATA'!A5","v":0},{"$f":"'Step 1. Exposure DATA'!B5","v":0},{"$f":"'Step 1. Exposure DATA'!C5","v":0},{"$f":"VLOOKUP('Step 1. Exposure DATA'!D5,'Exposure Data Scoring'!$A$3:$B$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"RANK('Step 1. Exposure DATA'!E5,'Step 1. Exposure DATA'!$E$3:$E$6,0)","v":{"$error":"#N/A"}},{"$f":"IF('Step 1. Exposure DATA'!F5<0,4,1)","v":4},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!D5:F5)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(H5),G5,ISNUMBER(G5),G5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!G5,'Exposure Data Scoring'!$G$3:$H$7,2,FALSE)","v":1},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!H5>='Exposure Data Scoring'!$I$3,4,'Step 1. Exposure DATA'!H5>='Exposure Data Scoring'!$I$4,3,'Step 1. Exposure DATA'!H5>='Exposure Data Scoring'!$I$5,2,'Step 1. Exposure DATA'!H5>='Exposure Data Scoring'!$I$6,1,'Step 1. Exposure DATA'!H5<'Exposure Data Scoring'!$I$6,0)","v":0},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!I5>='Exposure Data Scoring'!$K$3,4,'Step 1. Exposure DATA'!I5>='Exposure Data Scoring'!$K$4,3,'Step 1. Exposure DATA'!I5>='Exposure Data Scoring'!$K$5,2,'Step 1. Exposure DATA'!I5>='Exposure Data Scoring'!$K$6,1,'Step 1. Exposure DATA'!I5<'Exposure Data Scoring'!$K$6,0)","v":0},{"$f":"RANK('Step 1. Exposure DATA'!J5,'Step 1. Exposure DATA'!$J$3:$J$6,0)","v":1},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!J5:M5)","v":0.5},null,{"$f":"_xlfn.IFS(ISBLANK(O5),N5,ISNUMBER(N5),N5)","v":0.5},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!K5>=4,4,'Step 1. Exposure DATA'!K5>=3,3,'Step 1. Exposure DATA'!K5>=2,2,'Step 1. Exposure DATA'!K5>=1,1,'Step 1. Exposure DATA'!K5<1,0)","v":0},{"$f":"RANK('Step 1. Exposure DATA'!L5,'Step 1. Exposure DATA'!$L$3:$L$6,0)","v":1},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!Q5:R5)","v":0.5},null,{"$f":"_xlfn.IFS(ISBLANK(T5),S5,ISNUMBER(S5),S5)","v":0.5},{"$f":"_xlfn.RANK.EQ('Step 1. Exposure DATA'!M5,'Step 1. Exposure DATA'!$M$3:$M$6,1)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!N5>='Exposure Data Scoring'!$U$3,4,'Step 1. Exposure DATA'!N5>='Exposure Data Scoring'!$U$4,3,'Step 1. Exposure DATA'!N5>='Exposure Data Scoring'!$U$5,2,'Step 1. Exposure DATA'!N5>='Exposure Data Scoring'!$U$6,1)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!V5:W5)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(Y5),X5,ISNUMBER(X5),X5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!O5,'Exposure Data Scoring'!$W$3:$X$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!P5,'Exposure Data Scoring'!$Y$3:$Z$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AA5:AB5)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AD5),AC5,ISNUMBER(AC5),AC5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!Q5,'Exposure Data Scoring'!$AA$3:$AB$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!R5,'Exposure Data Scoring'!$AC$3:$AD$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AF5:AG5)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AI5),AH5,ISNUMBER(AH5),AH5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!S5>='Exposure Data Scoring'!$AE$3,4,'Step 1. Exposure DATA'!S5>='Exposure Data Scoring'!$AE$4,3,'Step 1. Exposure DATA'!S5>='Exposure Data Scoring'!$AE$5,2,'Step 1. Exposure DATA'!S5>='Exposure Data Scoring'!$AE$6,1,'Step 1. Exposure DATA'!S5='Exposure Data Scoring'!$AE$7,0)","v":0},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!T5='Exposure Data Scoring'!$AG$3,4,'Step 1. Exposure DATA'!T5='Exposure Data Scoring'!$AG$4,2,'Step 1. Exposure DATA'!T5='Exposure Data Scoring'!$AG$5,1,'Step 1. Exposure DATA'!T5=\"N/A\",0)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AK5:AL5)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AN5),AM5,ISNUMBER(AM5),AM5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!U5,'Exposure Data Scoring'!$AI$3:$AJ$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!V5,'Exposure Data Scoring'!$AK$3:$AL$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!W5,'Exposure Data Scoring'!$AM$3:$AN$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!X5,'Exposure Data Scoring'!$AO$3:$AP$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!Y5,'Exposure Data Scoring'!$AQ$3:$AR$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!Z5,'Exposure Data Scoring'!$AS$3:$AT$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AP5:AS5)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AW5),AV5,ISNUMBER(AV5),AV5)","v":{"$error":"#N/A"}},{"$f":"'Step 1. Exposure Data Scores'!I5+'Step 1. Exposure Data Scores'!P5+'Step 1. Exposure Data Scores'!U5+'Step 1. Exposure Data Scores'!Z5+'Step 1. Exposure Data Scores'!AE5+'Step 1. Exposure Data Scores'!AJ5+'Step 1. Exposure Data Scores'!AO5+'Step 1. Exposure Data Scores'!AX5","v":{"$error":"#N/A"}},{"$f":"MEDIAN('Step 1. Exposure Data Scores'!I5,'Step 1. Exposure Data Scores'!P5,'Step 1. Exposure Data Scores'!U5,'Step 1. Exposure Data Scores'!Z5,'Step 1. Exposure Data Scores'!AE5,'Step 1. Exposure Data Scores'!AJ5,'Step 1. Exposure Data Scores'!AO5,'Step 1. Exposure Data Scores'!AX5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(AZ5>=3, \"High\",AZ5>=2, \"Moderate\", AZ5>=1, \"Low\", AZ5<1, \"Minimal\")","v":{"$error":"#N/A"}}]
[{"$f":"'Step 1. Exposure DATA'!A6","v":0},{"$f":"'Step 1. Exposure DATA'!B6","v":0},{"$f":"'Step 1. Exposure DATA'!C6","v":0},{"$f":"VLOOKUP('Step 1. Exposure DATA'!D6,'Exposure Data Scoring'!$A$3:$B$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"RANK('Step 1. Exposure DATA'!E6,'Step 1. Exposure DATA'!$E$3:$E$6,0)","v":{"$error":"#N/A"}},{"$f":"IF('Step 1. Exposure DATA'!F6<0,4,1)","v":4},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!D6:F6)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(H6),G6,ISNUMBER(G6),G6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!G6,'Exposure Data Scoring'!$G$3:$H$7,2,FALSE)","v":1},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!H6>='Exposure Data Scoring'!$I$3,4,'Step 1. Exposure DATA'!H6>='Exposure Data Scoring'!$I$4,3,'Step 1. Exposure DATA'!H6>='Exposure Data Scoring'!$I$5,2,'Step 1. Exposure DATA'!H6>='Exposure Data Scoring'!$I$6,1,'Step 1. Exposure DATA'!H6<'Exposure Data Scoring'!$I$6,0)","v":0},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!I6>='Exposure Data Scoring'!$K$3,4,'Step 1. Exposure DATA'!I6>='Exposure Data Scoring'!$K$4,3,'Step 1. Exposure DATA'!I6>='Exposure Data Scoring'!$K$5,2,'Step 1. Exposure DATA'!I6>='Exposure Data Scoring'!$K$6,1,'Step 1. Exposure DATA'!I6<'Exposure Data Scoring'!$K$6,0)","v":0},{"$f":"RANK('Step 1. Exposure DATA'!J6,'Step 1. Exposure DATA'!$J$3:$J$6,0)","v":1},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!J6:M6)","v":0.5},null,{"$f":"_xlfn.IFS(ISBLANK(O6),N6,ISNUMBER(N6),N6)","v":0.5},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!K6>=4,4,'Step 1. Exposure DATA'!K6>=3,3,'Step 1. Exposure DATA'!K6>=2,2,'Step 1. Exposure DATA'!K6>=1,1,'Step 1. Exposure DATA'!K6<1,0)","v":0},{"$f":"RANK('Step 1. Exposure DATA'!L6,'Step 1. Exposure DATA'!$L$3:$L$6,0)","v":1},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!Q6:R6)","v":0.5},null,{"$f":"_xlfn.IFS(ISBLANK(T6),S6,ISNUMBER(S6),S6)","v":0.5},{"$f":"_xlfn.RANK.EQ('Step 1. Exposure DATA'!M6,'Step 1. Exposure DATA'!$M$3:$M$6,1)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!N6>='Exposure Data Scoring'!$U$3,4,'Step 1. Exposure DATA'!N6>='Exposure Data Scoring'!$U$4,3,'Step 1. Exposure DATA'!N6>='Exposure Data Scoring'!$U$5,2,'Step 1. Exposure DATA'!N6>='Exposure Data Scoring'!$U$6,1)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!V6:W6)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(Y6),X6,ISNUMBER(X6),X6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!O6,'Exposure Data Scoring'!$W$3:$X$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!P6,'Exposure Data Scoring'!$Y$3:$Z$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AA6:AB6)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AD6),AC6,ISNUMBER(AC6),AC6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!Q6,'Exposure Data Scoring'!$AA$3:$AB$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!R6,'Exposure Data Scoring'!$AC$3:$AD$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AF6:AG6)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AI6),AH6,ISNUMBER(AH6),AH6)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!S6>='Exposure Data Scoring'!$AE$3,4,'Step 1. Exposure DATA'!S6>='Exposure Data Scoring'!$AE$4,3,'Step 1. Exposure DATA'!S6>='Exposure Data Scoring'!$AE$5,2,'Step 1. Exposure DATA'!S6>='Exposure Data Scoring'!$AE$6,1,'Step 1. Exposure DATA'!S6='Exposure Data Scoring'!$AE$7,0)","v":0},{"$f":"_xlfn.IFS('Step 1. Exposure DATA'!T6='Exposure Data Scoring'!$AG$3,4,'Step 1. Exposure DATA'!T6='Exposure Data Scoring'!$AG$4,2,'Step 1. Exposure DATA'!T6='Exposure Data Scoring'!$AG$5,1,'Step 1. Exposure DATA'!T6=\"N/A\",0)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AK6:AL6)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AN6),AM6,ISNUMBER(AM6),AM6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!U6,'Exposure Data Scoring'!$AI$3:$AJ$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!V6,'Exposure Data Scoring'!$AK$3:$AL$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!W6,'Exposure Data Scoring'!$AM$3:$AN$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!X6,'Exposure Data Scoring'!$AO$3:$AP$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!Y6,'Exposure Data Scoring'!$AQ$3:$AR$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 1. Exposure DATA'!Z6,'Exposure Data Scoring'!$AS$3:$AT$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE('Step 1. Exposure Data Scores'!AP6:AS6)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AW6),AV6,ISNUMBER(AV6),AV6)","v":{"$error":"#N/A"}},{"$f":"'Step 1. Exposure Data Scores'!I6+'Step 1. Exposure Data Scores'!P6+'Step 1. Exposure Data Scores'!U6+'Step 1. Exposure Data Scores'!Z6+'Step 1. Exposure Data Scores'!AE6+'Step 1. Exposure Data Scores'!AJ6+'Step 1. Exposure Data Scores'!AO6+'Step 1. Exposure Data Scores'!AX6","v":{"$error":"#N/A"}},{"$f":"MEDIAN('Step 1. Exposure Data Scores'!I6,'Step 1. Exposure Data Scores'!P6,'Step 1. Exposure Data Scores'!U6,'Step 1. Exposure Data Scores'!Z6,'Step 1. Exposure Data Scores'!AE6,'Step 1. Exposure Data Scores'!AJ6,'Step 1. Exposure Data Scores'!AO6,'Step 1. Exposure Data Scores'!AX6)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(AZ6>=3, \"High\",AZ6>=2, \"Moderate\", AZ6>=1, \"Low\", AZ6<1, \"Minimal\")","v":{"$error":"#N/A"}}]
["END OF WORKSHEET"]

{"sheet":"Step 2. Sensitivity DATA","index":3,"n_rows":7,"n_cols":25,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Step 2. Sensitivity DATA",null,null,null,"Flood Damage Potential Indicator",null,null,"Storm Resistance and Condition Indicator",null,"Historical Damage Indicator",null,"Protective Engineering Indicator",null,"Infrastructure Indicator",null,null,null,"Fish and Wildlife Habitat Indicator",null,null,null,"Climate Indicator",null,"Water Quality Indicator"]
["ID","Asset","Site","FEMA Flood Data","LiDAR Elevation Data","Asset Elevated?","500 Year Flood Potential?","Built Resistivity?","Natural Resistivity?","Historical Damage?","Current Maintenance Level Data","Protective Engineering?","Engineered Element Condition Data","Critical Infrastructure Present?","Infrastructure Protected?","Scientific and Natural Areas?","State Aquatic Management Areas?","Native Plant Communities?","Site of Biodiversity Signficance?","National Wetland Inventory?","Wildlife Management Area?","Precipitation Change Data","Temperature Change Data","Invasive Species?","Buffer Protection Data"]
[{"$f":"'Step 1. Exposure Data Scores'!A3","v":0},{"$f":"'Step 1. Exposure Data Scores'!B3","v":0},{"$f":"'Step 1. Exposure Data Scores'!C3","v":0},{"$f":"'Step 1. Exposure DATA'!D3","v":0},{"$f":"'Step 1. Exposure DATA'!E3","v":0},null,{"$f":"IF('Step 1. Exposure DATA'!F3<0,\"Yes\", \"No\")","v":"Yes"}]
[{"$f":"'Step 1. Exposure Data Scores'!A4","v":0},{"$f":"'Step 1. Exposure Data Scores'!B4","v":0},{"$f":"'Step 1. Exposure Data Scores'!C4","v":0},{"$f":"'Step 1. Exposure DATA'!D4","v":0},{"$f":"'Step 1. Exposure DATA'!E4","v":0},null,{"$f":"IF('Step 1. Exposure DATA'!F4<0,\"Yes\", \"No\")","v":"Yes"}]
[{"$f":"'Step 1. Exposure Data Scores'!A5","v":0},{"$f":"'Step 1. Exposure Data Scores'!B5","v":0},{"$f":"'Step 1. Exposure Data Scores'!C5","v":0},{"$f":"'Step 1. Exposure DATA'!D5","v":0},{"$f":"'Step 1. Exposure DATA'!E5","v":0},null,{"$f":"IF('Step 1. Exposure DATA'!F5<0,\"Yes\", \"No\")","v":"Yes"}]
[{"$f":"'Step 1. Exposure Data Scores'!A6","v":0},{"$f":"'Step 1. Exposure Data Scores'!B6","v":0},{"$f":"'Step 1. Exposure Data Scores'!C6","v":0},{"$f":"'Step 1. Exposure DATA'!D6","v":0},{"$f":"'Step 1. Exposure DATA'!E6","v":0},null,{"$f":"IF('Step 1. Exposure DATA'!F6<0,\"Yes\", \"No\")","v":"Yes"}]
["END OF WORKSHEET"]

{"sheet":"Step 2. Sensitivity Data Scores","index":4,"n_rows":7,"n_cols":52,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Step 2. Sensitivity Data Scores",null,null,null,null,null,"Flood Damage Potential Indicator",null,null,null,null,null,"Storm Resistance and Condition Indicator",null,null,null,null,"Historical Damage Indicator",null,null,null,null,"Protective Engineering Indicator",null,null,null,null,"Infrastructure Indicator",null,null,null,null,null,null,"Fish and Wildlife Habitat Indicator",null,null,null,null,null,null,"Climate Indicator",null,null,null,"Water Quality Indicator"]
["ID","Asset","Site","FEMA Flood Score","LiDAR Elevation Score","Asset Structure Elevation Score","500 Year Flood Score","Flood Damage Potential Score","Override?","Flood Damage Potential Score Final","Built Resistivity Score","Natural Resistivity Score","Storm Resistance and Condition Score","Override?","Storm Resistance and Condition Score Final","Historical Damage Score","Current Maintenance Level Score","Historical Damage Score","Override?","Historical Damage Score Final","Protective Engineering Score","Engineered Element Condition Score","Protective Engineering Score","Override?","Protective Engineering Score Final","Critical Infrastructure Present Score","Infrastructure Protection Score","Infrastructure Score","Override?","Infrastructure Score Final","Scientific and Natural Areas Score","State Aquatic Management Areas Score","Native Plant Communities Score","Site of Biodiversity Significance Score","National Wetland Inventory Score","Wildlife Management Area Score","Fish and Wildlife Habitat Score","Override?","Fish and Wildlife Habitat Score Final","Precipitation Change Score","Temperature Change Score","Climate Score","Override?","Climate Score Final","Invasive Species Score","Buffer Protection Score","Water Quality Score","Override?","Water Quality Score Final","Sensitivity Score Sum","Sensitivity Score","Sensitivity Rank"]
[{"$f":"'Step 2. Sensitivity DATA'!A3","v":0},{"$f":"'Step 2. Sensitivity DATA'!B3","v":0},{"$f":"'Step 2. Sensitivity DATA'!C3","v":0},{"$f":"VLOOKUP('Step 1. Exposure DATA'!D3,'Sensitivity Data Scoring'!$A$3:$B$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"RANK('Step 1. Exposure DATA'!E3,'Step 1. Exposure DATA'!$E$3:$E$6,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!F3,'Sensitivity Data Scoring'!$E$3:$F$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Step 2. Sensitivity DATA'!G3=\"Yes\", 4, 1)","v":4},{"$f":"AVERAGE('Step 2. Sensitivity Data Scores'!D3:G3)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(I3),H3,ISNUMBER(I3),I3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!H3,'Sensitivity Data Scoring'!$I$3:$J$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!I3,'Sensitivity Data Scoring'!$K$3:$L$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(K3:L3)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(N3),M3,ISNUMBER(N3),N3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!J3,'Sensitivity Data Scoring'!$M$3:$N$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!K3,'Sensitivity Data Scoring'!$O$3:$P$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(P3:Q3)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(S3),R3,ISNUMBER(S3),S3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!L3,'Sensitivity Data Scoring'!$Q$3:$R$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!M3,'Sensitivity Data Scoring'!$S$3:$T$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(U3:V3)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(X3),W3,ISNUMBER(X3),X3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!N3,'Sensitivity Data Scoring'!$U$3:$V$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!O3,'Sensitivity Data Scoring'!$W$3:$X$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(Z3:AA3)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AC3),AB3,ISNUMBER(AC3),AC3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!P3,'Sensitivity Data Scoring'!$Y$3:$Z$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!Q3,'Sensitivity Data Scoring'!$AA$3:$AB$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!R3,'Sensitivity Data Scoring'!$AC$3:$AD$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!S3,'Sensitivity Data Scoring'!$AE$3:$AF$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!T3,'Sensitivity Data Scoring'!$AG$3:$AH$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!U3,'Sensitivity Data Scoring'!$AI$3:$AJ$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(AE3:AJ3)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AL3),AK3,ISNUMBER(AL3),AL3)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Step 2. Sensitivity DATA'!V3>=0.26,4,'Step 2. Sensitivity DATA'!V3<0.26,2)","v":2},{"$f":"_xlfn.IFS('Step 2. Sensitivity DATA'!W3>=0.24,4,'Step 2. Sensitivity DATA'!W3<0.24,2)","v":2},{"$f":"AVERAGE(AN3:AO3)","v":2},null,{"$f":"_xlfn.IFS(ISBLANK(AQ3),AP3,ISNUMBER(AQ3),AQ3)","v":2},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!X3,'Sensitivity Data Scoring'!$AO$3:$AP$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!Y3,'Sensitivity Data Scoring'!$AQ$3:$AR$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(AS3:AT3)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AV3),AU3,ISNUMBER(AV3),AV3)","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!J3+'Step 2. Sensitivity Data Scores'!O3+'Step 2. Sensitivity Data Scores'!T3+'Step 2. Sensitivity Data Scores'!Y3+'Step 2. Sensitivity Data Scores'!AD3+'Step 2. Sensitivity Data Scores'!AM3+'Step 2. Sensitivity Data Scores'!AR3+'Step 2. Sensitivity Data Scores'!AW3","v":{"$error":"#N/A"}},{"$f":"MEDIAN('Step 2. Sensitivity Data Scores'!J3,'Step 2. Sensitivity Data Scores'!O3,'Step 2. Sensitivity Data Scores'!T3,'Step 2. Sensitivity Data Scores'!Y3,'Step 2. Sensitivity Data Scores'!AD3,'Step 2. Sensitivity Data Scores'!AM3,'Step 2. Sensitivity Data Scores'!AR3,'Step 2. Sensitivity Data Scores'!AW3)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(AY3>=3, \"High\",AY3>=2, \"Moderate\", AY3>=1, \"Low\", AY3<1, \"Minimal\")","v":{"$error":"#N/A"}}]
[{"$f":"'Step 2. Sensitivity DATA'!A4","v":0},{"$f":"'Step 2. Sensitivity DATA'!B4","v":0},{"$f":"'Step 2. Sensitivity DATA'!C4","v":0},{"$f":"VLOOKUP('Step 1. Exposure DATA'!D4,'Sensitivity Data Scoring'!$A$3:$B$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"RANK('Step 1. Exposure DATA'!E4,'Step 1. Exposure DATA'!$E$3:$E$6,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!F4,'Sensitivity Data Scoring'!$E$3:$F$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Step 2. Sensitivity DATA'!G4=\"Yes\", 4, 1)","v":4},{"$f":"AVERAGE('Step 2. Sensitivity Data Scores'!D4:G4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(I4),H4,ISNUMBER(I4),I4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!H4,'Sensitivity Data Scoring'!$I$3:$J$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!I4,'Sensitivity Data Scoring'!$K$3:$L$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(K4:L4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(N4),M4,ISNUMBER(N4),N4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!J4,'Sensitivity Data Scoring'!$M$3:$N$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!K4,'Sensitivity Data Scoring'!$O$3:$P$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(P4:Q4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(S4),R4,ISNUMBER(R4),R4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!L4,'Sensitivity Data Scoring'!$Q$3:$R$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!M4,'Sensitivity Data Scoring'!$S$3:$T$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(U4:V4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(X4),W4,ISNUMBER(X4),X4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!N4,'Sensitivity Data Scoring'!$U$3:$V$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!O4,'Sensitivity Data Scoring'!$W$3:$X$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(Z4:AA4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AC4),AB4,ISNUMBER(AB4),AB4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!P4,'Sensitivity Data Scoring'!$Y$3:$Z$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!Q4,'Sensitivity Data Scoring'!$AA$3:$AB$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!R4,'Sensitivity Data Scoring'!$AC$3:$AD$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!S4,'Sensitivity Data Scoring'!$AE$3:$AF$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!T4,'Sensitivity Data Scoring'!$AG$3:$AH$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!U4,'Sensitivity Data Scoring'!$AI$3:$AJ$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(AE4:AJ4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AL4),AK4,ISNUMBER(AL4),AL4)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Step 2. Sensitivity DATA'!V4>=0.26,4,'Step 2. Sensitivity DATA'!V4<0.26,2)","v":2},{"$f":"_xlfn.IFS('Step 2. Sensitivity DATA'!W4>=0.24,4,'Step 2. Sensitivity DATA'!W4<0.24,2)","v":2},{"$f":"AVERAGE(AN4:AO4)","v":2},null,{"$f":"_xlfn.IFS(ISBLANK(AQ4),AP4,ISNUMBER(AP4),AP4)","v":2},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!X4,'Sensitivity Data Scoring'!$AO$3:$AP$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!Y4,'Sensitivity Data Scoring'!$AQ$3:$AR$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(AS4:AT4)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(AV4),AU4,ISNUMBER(AV4),AV4)","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!J4+'Step 2. Sensitivity Data Scores'!O4+'Step 2. Sensitivity Data Scores'!T4+'Step 2. Sensitivity Data Scores'!Y4+'Step 2. Sensitivity Data Scores'!AD4+'Step 2. Sensitivity Data Scores'!AM4+'Step 2. Sensitivity Data Scores'!AR4+'Step 2. Sensitivity Data Scores'!AW4","v":{"$error":"#N/A"}},{"$f":"MEDIAN('Step 2. Sensitivity Data Scores'!J4,'Step 2. Sensitivity Data Scores'!O4,'Step 2. Sensitivity Data Scores'!T4,'Step 2. Sensitivity Data Scores'!Y4,'Step 2. Sensitivity Data Scores'!AD4,'Step 2. Sensitivity Data Scores'!AM4,'Step 2. Sensitivity Data Scores'!AR4,'Step 2. Sensitivity Data Scores'!AW4)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(AY4>=3, \"High\",AY4>=2, \"Moderate\", AY4>=1, \"Low\", AY4<1, \"Minimal\")","v":{"$error":"#N/A"}}]
[{"$f":"'Step 2. Sensitivity DATA'!A5","v":0},{"$f":"'Step 2. Sensitivity DATA'!B5","v":0},{"$f":"'Step 2. Sensitivity DATA'!C5","v":0},{"$f":"VLOOKUP('Step 1. Exposure DATA'!D5,'Sensitivity Data Scoring'!$A$3:$B$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"RANK('Step 1. Exposure DATA'!E5,'Step 1. Exposure DATA'!$E$3:$E$6,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!F5,'Sensitivity Data Scoring'!$E$3:$F$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Step 2. Sensitivity DATA'!G5=\"Yes\", 4, 1)","v":4},{"$f":"AVERAGE('Step 2. Sensitivity Data Scores'!D5:G5)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(I5),H5,ISNUMBER(I5),I5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!H5,'Sensitivity Data Scoring'!$I$3:$J$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!I5,'Sensitivity Data Scoring'!$K$3:$L$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.IFS(ISBLANK(N5),M5,ISNUMBER(N5),N5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!J5,'Sensitivity Data Scoring'!$M$3:$N$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!K5,'Sensitivity Data Scoring'!$O$3:$P$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.IFS(ISBLANK(S5),R5,ISNUMBER(R5),R5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!L5,'Sensitivity Data Scoring'!$Q$3:$R$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!M5,'Sensitivity Data Scoring'!$S$3:$T$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.IFS(ISBLANK(X5),W5,ISNUMBER(X5),X5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!N5,'Sensitivity Data Scoring'!$U$3:$V$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!O5,'Sensitivity Data Scoring'!$W$3:$X$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.IFS(ISBLANK(AC5),AB5,ISNUMBER(AB5),AB5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!P5,'Sensitivity Data Scoring'!$Y$3:$Z$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!Q5,'Sensitivity Data Scoring'!$AA$3:$AB$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!R5,'Sensitivity Data Scoring'!$AC$3:$AD$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!S5,'Sensitivity Data Scoring'!$AE$3:$AF$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!T5,'Sensitivity Data Scoring'!$AG$3:$AH$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!U5,'Sensitivity Data Scoring'!$AI$3:$AJ$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.IFS(ISBLANK(AL5),AK5,ISNUMBER(AL5),AL5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Step 2. Sensitivity DATA'!V5>=0.26,4,'Step 2. Sensitivity DATA'!V5<0.26,2)","v":2},{"$f":"_xlfn.IFS('Step 2. Sensitivity DATA'!W5>=0.24,4,'Step 2. Sensitivity DATA'!W5<0.24,2)","v":2},2,null,{"$f":"_xlfn.IFS(ISBLANK(AQ5),AP5,ISNUMBER(AP5),AP5)","v":2},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!X5,'Sensitivity Data Scoring'!$AO$3:$AP$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!Y5,'Sensitivity Data Scoring'!$AQ$3:$AR$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.IFS(ISBLANK(AV5),AU5,ISNUMBER(AV5),AV5)","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!J5+'Step 2. Sensitivity Data Scores'!O5+'Step 2. Sensitivity Data Scores'!T5+'Step 2. Sensitivity Data Scores'!Y5+'Step 2. Sensitivity Data Scores'!AD5+'Step 2. Sensitivity Data Scores'!AM5+'Step 2. Sensitivity Data Scores'!AR5+'Step 2. Sensitivity Data Scores'!AW5","v":{"$error":"#N/A"}},{"$f":"MEDIAN('Step 2. Sensitivity Data Scores'!J5,'Step 2. Sensitivity Data Scores'!O5,'Step 2. Sensitivity Data Scores'!T5,'Step 2. Sensitivity Data Scores'!Y5,'Step 2. Sensitivity Data Scores'!AD5,'Step 2. Sensitivity Data Scores'!AM5,'Step 2. Sensitivity Data Scores'!AR5,'Step 2. Sensitivity Data Scores'!AW5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(AY5>=3, \"High\",AY5>=2, \"Moderate\", AY5>=1, \"Low\", AY5<1, \"Minimal\")","v":{"$error":"#N/A"}}]
[{"$f":"'Step 2. Sensitivity DATA'!A6","v":0},{"$f":"'Step 2. Sensitivity DATA'!B6","v":0},{"$f":"'Step 2. Sensitivity DATA'!C6","v":0},{"$f":"VLOOKUP('Step 1. Exposure DATA'!D6,'Sensitivity Data Scoring'!$A$3:$B$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"RANK('Step 1. Exposure DATA'!E6,'Step 1. Exposure DATA'!$E$3:$E$6,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!F6,'Sensitivity Data Scoring'!$E$3:$F$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Step 2. Sensitivity DATA'!G6=\"Yes\", 4, 1)","v":4},{"$f":"AVERAGE('Step 2. Sensitivity Data Scores'!D6:G6)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.IFS(ISBLANK(I6),H6,ISNUMBER(I6),I6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!H6,'Sensitivity Data Scoring'!$I$3:$J$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!I6,'Sensitivity Data Scoring'!$K$3:$L$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.IFS(ISBLANK(N6),M6,ISNUMBER(N6),N6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!J6,'Sensitivity Data Scoring'!$M$3:$N$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!K6,'Sensitivity Data Scoring'!$O$3:$P$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.IFS(ISBLANK(S6),R6,ISNUMBER(R6),R6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!L6,'Sensitivity Data Scoring'!$Q$3:$R$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!M6,'Sensitivity Data Scoring'!$S$3:$T$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.IFS(ISBLANK(X6),W6,ISNUMBER(X6),X6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!N6,'Sensitivity Data Scoring'!$U$3:$V$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!O6,'Sensitivity Data Scoring'!$W$3:$X$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.IFS(ISBLANK(AC6),AB6,ISNUMBER(AB6),AB6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!P6,'Sensitivity Data Scoring'!$Y$3:$Z$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!Q6,'Sensitivity Data Scoring'!$AA$3:$AB$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!R6,'Sensitivity Data Scoring'!$AC$3:$AD$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!S6,'Sensitivity Data Scoring'!$AE$3:$AF$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!T6,'Sensitivity Data Scoring'!$AG$3:$AH$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!U6,'Sensitivity Data Scoring'!$AI$3:$AJ$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.IFS(ISBLANK(AL6),AK6,ISNUMBER(AL6),AL6)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Step 2. Sensitivity DATA'!V6>=0.26,4,'Step 2. Sensitivity DATA'!V6<0.26,2)","v":2},{"$f":"_xlfn.IFS('Step 2. Sensitivity DATA'!W6>=0.24,4,'Step 2. Sensitivity DATA'!W6<0.24,2)","v":2},2,null,{"$f":"_xlfn.IFS(ISBLANK(AQ6),AP6,ISNUMBER(AP6),AP6)","v":2},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!X6,'Sensitivity Data Scoring'!$AO$3:$AP$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 2. Sensitivity DATA'!Y6,'Sensitivity Data Scoring'!$AQ$3:$AR$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.IFS(ISBLANK(AV6),AU6,ISNUMBER(AV6),AV6)","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!J6+'Step 2. Sensitivity Data Scores'!O6+'Step 2. Sensitivity Data Scores'!T6+'Step 2. Sensitivity Data Scores'!Y6+'Step 2. Sensitivity Data Scores'!AD6+'Step 2. Sensitivity Data Scores'!AM6+'Step 2. Sensitivity Data Scores'!AR6+'Step 2. Sensitivity Data Scores'!AW6","v":{"$error":"#N/A"}},{"$f":"MEDIAN('Step 2. Sensitivity Data Scores'!J6,'Step 2. Sensitivity Data Scores'!O6,'Step 2. Sensitivity Data Scores'!T6,'Step 2. Sensitivity Data Scores'!Y6,'Step 2. Sensitivity Data Scores'!AD6,'Step 2. Sensitivity Data Scores'!AM6,'Step 2. Sensitivity Data Scores'!AR6,'Step 2. Sensitivity Data Scores'!AW6)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(AY6>=3, \"High\",AY6>=2, \"Moderate\", AY6>=1, \"Low\", AY6<1, \"Minimal\")","v":{"$error":"#N/A"}}]
["END OF WORKSHEET"]

{"sheet":"Step 3. Potential Impact","index":5,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Step 3. Potential Impact"]
["ID","Asset","Site","Exposure Score","Exposure Rank","Sensitivity Score","Sensitivity Rank","Potential Impact Score","Potential Impact Rank"]
[{"$f":"'Step 2. Sensitivity Data Scores'!A3","v":0},{"$f":"'Step 2. Sensitivity Data Scores'!B3","v":0},{"$f":"'Step 2. Sensitivity Data Scores'!C3","v":0},{"$f":"'Step 1. Exposure Data Scores'!AZ3","v":{"$error":"#N/A"}},{"$f":"'Step 1. Exposure Data Scores'!BA3","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AY3","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AZ3","v":{"$error":"#N/A"}},{"$f":"AVERAGE(D3,F3)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(H3>=3, \"High\",H3>=2, \"Moderate\", H3>=1, \"Low\", H3<1, \"Minimal\")","v":{"$error":"#N/A"}}]
[{"$f":"'Step 2. Sensitivity Data Scores'!A4","v":0},{"$f":"'Step 2. Sensitivity Data Scores'!B4","v":0},{"$f":"'Step 2. Sensitivity Data Scores'!C4","v":0},{"$f":"'Step 1. Exposure Data Scores'!AZ4","v":{"$error":"#N/A"}},{"$f":"'Step 1. Exposure Data Scores'!BA4","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AY4","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AZ4","v":{"$error":"#N/A"}},{"$f":"AVERAGE(D4,F4)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(H4>=3, \"High\",H4>=2, \"Moderate\", H4>=1, \"Low\", H4<1, \"Minimal\")","v":{"$error":"#N/A"}}]
[{"$f":"'Step 2. Sensitivity Data Scores'!A5","v":0},{"$f":"'Step 2. Sensitivity Data Scores'!B5","v":0},{"$f":"'Step 2. Sensitivity Data Scores'!C5","v":0},{"$f":"'Step 1. Exposure Data Scores'!AZ5","v":{"$error":"#N/A"}},{"$f":"'Step 1. Exposure Data Scores'!BA5","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AY5","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AZ5","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"_xlfn.IFS(H5>=3, \"High\",H5>=2, \"Moderate\", H5>=1, \"Low\", H5<1, \"Minimal\")","v":{"$error":"#N/A"}}]
[{"$f":"'Step 2. Sensitivity Data Scores'!A6","v":0},{"$f":"'Step 2. Sensitivity Data Scores'!B6","v":0},{"$f":"'Step 2. Sensitivity Data Scores'!C6","v":0},{"$f":"'Step 1. Exposure Data Scores'!AZ6","v":{"$error":"#N/A"}},{"$f":"'Step 1. Exposure Data Scores'!BA6","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AY6","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AZ6","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"_xlfn.IFS(H6>=3, \"High\",H6>=2, \"Moderate\", H6>=1, \"Low\", H6<1, \"Minimal\")","v":{"$error":"#N/A"}}]
["END OF WORKSHEET"]

{"sheet":"Step 4. Adaptive Capacity DATA","index":6,"n_rows":136,"n_cols":34,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
["Step 4. Adaptive Capacity DATA"]
["ID","Asset","Site","1. Decommission and Remove","2. Elevate","3. Relocate","4. Protect/Engineer","5. Storm Resistant Design","6. Engineering Downgrade",null,"Level 1","Level 2 Lists",null,null,null,null,"Level 3 Lists",null,null,null,null,"Level 4 Lists",null,null,null,null,"Level 5 Lists",null,null,null,null,"Level 6 Lists"]
[{"$f":"'Step 3. Potential Impact'!A3","v":0},{"$f":"'Step 3. Potential Impact'!B3","v":0},{"$f":"'Step 3. Potential Impact'!C3","v":0},null,null,null,null,null,null,null,"Decommission or Remove?","Yes","No","N/A",null,null,"Elevate Above","Fill Above","Elevate Needs","No Elevating","N/A","Outside Floodplain","Outside Baseflood","From Shore","No Relocating","N/A","Living Shoreline","Soft Hardening","Hardening","No Protection","N/A","Yes","No","N/A"]
[{"$f":"'Step 3. Potential Impact'!A4","v":0},{"$f":"'Step 3. Potential Impact'!B4","v":0},{"$f":"'Step 3. Potential Impact'!C4","v":0},null,null,null,null,null,null,null,"Yes","N/A","Elevate Above","Elevate Above",null,null,"From Shore","From Shore","From Shore","Outside Floodplain","Outside Floodplain","No Protection","Living Shoreline","Living Shoreline","Living Shoreline","Living Shoreline","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes"]
[{"$f":"'Step 3. Potential Impact'!A5","v":0},{"$f":"'Step 3. Potential Impact'!B5","v":0},{"$f":"'Step 3. Potential Impact'!C5","v":0},null,null,null,null,null,null,null,"No",null,"Fill Above","Fill Above",null,null,"No Relocating","No Relocating","No Relocating","Outside Baseflood","Outside Baseflood","N/A","Soft Hardening","Soft Hardening","Soft Hardening","Soft Hardening","No","No","No","No","No","No","No","No"]
[{"$f":"'Step 3. Potential Impact'!A6","v":0},{"$f":"'Step 3. Potential Impact'!B6","v":0},{"$f":"'Step 3. Potential Impact'!C6","v":0},null,null,null,null,null,null,null,"N/A",null,"Elevate Needs","Elevate Needs",null,null,"N/A","N/A","N/A","From Shore","From Shore",null,"Hardening","Hardening","Hardening","Hardening","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["END OF WORKSHEET",null,null,null,null,null,null,null,null,null,null,null,"No Elevating","No Elevating",null,null,null,null,null,"No Relocating","No Relocating",null,"No Protection","No Protection","No Protection","No Protection"]
[null,null,null,null,null,null,null,null,null,null,null,null,"N/A","N/A",null,null,null,null,null,"N/A","N/A",null,"N/A","N/A","N/A","N/A"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Level 2 Filter",null,null,null,null,"Level 3 Filter",null,null,null,null,"Level 4 Filter",null,null,null,null,"Level 5 Filter",null,null,null,null,"Level 6 Filter"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D3,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E3,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F3,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G3,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H3,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D4,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E4,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F4,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G4,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H4,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D5,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E5,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F5,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G5,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H5,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D6,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E6,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F6,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G6,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H6,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D7,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E7,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F7,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G7,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H7,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D8,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E8,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F8,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G8,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H8,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D9,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E9,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F9,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G9,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H9,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D10,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E10,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F10,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G10,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H10,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D11,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E11,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F11,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G11,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H11,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D12,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E12,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F12,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G12,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H12,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D13,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E13,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F13,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G13,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H13,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D14,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E14,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F14,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G14,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H14,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D15,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E15,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F15,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G15,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H15,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D16,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E16,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F16,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G16,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H16,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D17,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E17,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F17,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G17,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H17,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D18,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E18,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F18,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G18,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H18,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D19,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E19,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F19,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G19,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H19,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D20,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E20,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F20,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G20,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H20,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D21,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E21,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F21,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G21,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H21,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D22,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E22,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F22,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G22,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H22,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D23,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E23,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F23,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G23,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H23,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D24,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E24,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F24,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G24,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H24,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D25,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E25,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F25,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G25,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H25,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D26,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E26,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F26,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G26,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H26,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D27,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E27,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F27,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G27,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H27,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D28,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E28,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F28,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G28,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H28,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D29,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E29,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F29,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G29,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H29,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D30,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E30,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F30,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G30,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H30,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D31,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E31,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F31,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G31,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H31,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D32,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E32,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F32,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G32,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H32,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D33,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E33,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F33,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G33,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H33,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D34,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E34,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F34,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G34,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H34,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D35,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E35,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F35,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G35,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H35,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D36,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E36,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F36,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G36,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H36,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D37,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E37,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F37,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G37,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H37,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D38,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E38,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F38,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G38,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H38,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D39,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E39,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F39,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G39,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H39,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D40,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E40,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F40,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G40,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H40,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D41,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E41,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F41,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G41,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H41,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D42,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E42,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F42,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G42,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H42,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D43,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E43,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F43,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G43,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H43,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D44,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E44,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F44,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G44,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H44,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D45,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E45,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F45,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G45,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H45,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D46,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E46,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F46,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G46,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H46,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D47,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E47,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F47,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G47,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H47,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D48,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E48,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F48,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G48,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H48,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D49,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E49,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F49,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G49,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H49,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D50,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E50,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F50,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G50,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H50,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D51,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E51,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F51,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G51,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H51,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D52,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E52,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F52,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G52,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H52,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D53,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E53,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F53,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G53,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H53,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D54,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E54,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F54,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G54,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H54,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D55,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E55,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F55,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G55,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H55,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D56,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E56,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F56,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G56,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H56,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D57,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E57,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F57,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G57,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H57,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D58,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E58,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F58,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G58,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H58,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D59,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E59,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F59,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G59,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H59,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D60,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E60,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F60,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G60,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H60,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D61,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E61,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F61,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G61,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H61,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D62,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E62,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F62,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G62,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H62,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D63,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E63,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F63,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G63,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H63,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D64,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E64,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F64,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G64,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H64,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D65,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E65,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F65,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G65,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H65,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D66,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E66,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F66,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G66,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H66,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D67,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E67,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F67,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G67,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H67,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D68,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E68,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F68,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G68,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H68,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D69,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E69,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F69,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G69,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H69,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D70,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E70,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F70,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G70,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H70,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D71,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E71,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F71,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G71,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H71,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D72,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E72,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F72,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G72,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H72,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D73,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E73,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F73,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G73,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H73,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D74,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E74,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F74,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G74,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H74,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D75,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E75,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F75,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G75,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H75,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D76,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E76,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F76,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G76,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H76,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D77,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E77,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F77,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G77,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H77,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D78,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E78,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F78,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G78,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H78,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D79,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E79,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F79,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G79,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H79,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D80,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E80,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F80,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G80,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H80,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D81,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E81,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F81,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G81,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H81,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D82,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E82,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F82,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G82,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H82,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D83,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E83,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F83,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G83,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H83,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D84,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E84,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F84,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G84,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H84,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D85,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E85,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F85,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G85,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H85,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D86,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E86,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F86,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G86,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H86,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D87,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E87,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F87,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G87,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H87,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D88,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E88,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F88,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G88,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H88,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D89,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E89,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F89,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G89,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H89,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D90,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E90,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F90,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G90,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H90,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D91,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E91,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F91,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G91,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H91,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D92,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E92,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F92,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G92,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H92,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D93,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E93,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F93,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G93,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H93,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D94,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E94,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F94,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G94,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H94,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D95,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E95,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F95,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G95,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H95,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D96,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E96,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F96,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G96,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H96,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D97,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E97,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F97,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G97,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H97,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D98,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E98,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F98,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G98,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H98,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D99,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E99,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F99,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G99,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H99,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D100,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E100,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F100,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G100,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H100,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D101,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E101,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F101,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G101,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H101,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D102,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E102,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F102,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G102,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H102,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D103,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E103,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F103,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G103,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H103,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D104,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E104,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F104,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G104,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H104,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D105,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E105,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F105,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G105,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H105,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D106,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E106,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F106,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G106,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H106,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D107,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E107,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F107,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G107,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H107,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D108,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E108,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F108,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G108,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H108,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D109,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E109,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F109,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G109,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H109,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D110,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E110,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F110,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G110,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H110,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D111,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E111,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F111,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G111,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H111,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D112,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E112,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F112,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G112,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H112,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D113,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E113,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F113,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G113,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H113,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D114,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E114,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F114,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G114,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H114,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D115,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E115,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F115,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G115,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H115,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D116,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E116,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F116,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G116,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H116,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D117,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E117,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F117,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G117,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H117,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D118,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E118,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F118,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G118,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H118,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D119,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E119,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F119,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G119,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H119,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D120,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E120,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F120,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G120,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H120,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D121,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E121,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F121,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G121,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H121,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D122,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E122,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F122,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G122,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H122,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D123,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E123,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F123,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G123,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H123,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D124,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E124,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F124,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G124,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H124,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D125,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E125,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F125,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G125,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H125,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($D126,$L$3:$N$3,$L$4:$N$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($E126,$Q$3:$U$3,$Q$4:$U$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($F126,$V$3:$Z$3,$V$4:$Z$8),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($G126,$AA$3:$AE$3,$AA$4:$AE$6),,TRUE))","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn.XLOOKUP($H126,$AF$3:$AH$3,$AF$4:$AH$6),,TRUE))","v":{"$error":"#N/A"}}]

{"sheet":"Step 4. Adapt. Capacity Scores","index":7,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Step 4. Adapt. Capacity Scores"]
["ID","Asset","Site","1. Decommission and Remove","2. Elevate","3. Relocate","4. Protect/Engineer","5. Storm Resistant Design","6. Engineering Downgrade","Exposure Adaptive Capacity Score","Sensitivity Adaptive Capacity Score","Adaptive Capacity Score Sum","Adaptive Capacity Score"]
[{"$f":"'Step 4. Adaptive Capacity DATA'!A3","v":0},{"$f":"'Step 4. Adaptive Capacity DATA'!B3","v":0},{"$f":"'Step 4. Adaptive Capacity DATA'!C3","v":0},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!D3,'Adaptive Capacity Scoring'!$G$3:$H$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!E3,'Adaptive Capacity Scoring'!$A$3:$B$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!F3,'Adaptive Capacity Scoring'!$C$3:$D$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!G3,'Adaptive Capacity Scoring'!$E$3:$F$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!H3,'Adaptive Capacity Scoring'!$I$3:$J$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!I3,'Adaptive Capacity Scoring'!$K$3:$L$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(F3,G3)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(E3,G3,H3,I3)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(D3=4,4,D3<4,SUM(J3:K3))","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(D3=4,4,D3<4,AVERAGE(J3:K3))","v":{"$error":"#N/A"}}]
[{"$f":"'Step 4. Adaptive Capacity DATA'!A4","v":0},{"$f":"'Step 4. Adaptive Capacity DATA'!B4","v":0},{"$f":"'Step 4. Adaptive Capacity DATA'!C4","v":0},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!D4,'Adaptive Capacity Scoring'!$G$3:$H$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!E4,'Adaptive Capacity Scoring'!$A$3:$B$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!F4,'Adaptive Capacity Scoring'!$C$3:$D$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!G4,'Adaptive Capacity Scoring'!$E$3:$F$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!H4,'Adaptive Capacity Scoring'!$I$3:$J$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!I4,'Adaptive Capacity Scoring'!$K$3:$L$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"AVERAGE(E4,G4,H4,I4)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(D4=4,4,D4<4,SUM(J4:K4))","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(D4=4,4,D4<4,AVERAGE(J4:K4))","v":{"$error":"#N/A"}}]
[{"$f":"'Step 4. Adaptive Capacity DATA'!A5","v":0},{"$f":"'Step 4. Adaptive Capacity DATA'!B5","v":0},{"$f":"'Step 4. Adaptive Capacity DATA'!C5","v":0},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!D5,'Adaptive Capacity Scoring'!$G$3:$H$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!E5,'Adaptive Capacity Scoring'!$A$3:$B$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!F5,'Adaptive Capacity Scoring'!$C$3:$D$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!G5,'Adaptive Capacity Scoring'!$E$3:$F$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!H5,'Adaptive Capacity Scoring'!$I$3:$J$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!I5,'Adaptive Capacity Scoring'!$K$3:$L$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"AVERAGE(E5,G5,H5,I5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(D5=4,4,D5<4,SUM(J5:K5))","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(D5=4,4,D5<4,AVERAGE(J5:K5))","v":{"$error":"#N/A"}}]
[{"$f":"'Step 4. Adaptive Capacity DATA'!A6","v":0},{"$f":"'Step 4. Adaptive Capacity DATA'!B6","v":0},{"$f":"'Step 4. Adaptive Capacity DATA'!C6","v":0},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!D6,'Adaptive Capacity Scoring'!$G$3:$H$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!E6,'Adaptive Capacity Scoring'!$A$3:$B$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!F6,'Adaptive Capacity Scoring'!$C$3:$D$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!G6,'Adaptive Capacity Scoring'!$E$3:$F$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!H6,'Adaptive Capacity Scoring'!$I$3:$J$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Step 4. Adaptive Capacity DATA'!I6,'Adaptive Capacity Scoring'!$K$3:$L$7,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"AVERAGE(E6,G6,H6,I6)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(D6=4,4,D6<4,SUM(J6:K6))","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(D6=4,4,D6<4,AVERAGE(J6:K6))","v":{"$error":"#N/A"}}]
["END OF WORKSHEET"]

{"sheet":"Step 5. Vulnerability Analysis","index":8,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Step 5. Vulnerability Analysis"]
["ID","Asset","Site","Exposure Score","Exposure Rank","Sensitivity Score","Sensitivity Rank","Potential Impact Score","Potential Impact Rank","Adaptive Capacity Score","Vulnerability Score","Vulnerability Rank"]
[{"$f":"'Step 4. Adapt. Capacity Scores'!A3","v":0},{"$f":"'Step 4. Adapt. Capacity Scores'!B3","v":0},{"$f":"'Step 4. Adapt. Capacity Scores'!C3","v":0},{"$f":"'Step 1. Exposure Data Scores'!AZ3","v":{"$error":"#N/A"}},{"$f":"'Step 1. Exposure Data Scores'!BA3","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AY3","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AZ3","v":{"$error":"#N/A"}},{"$f":"AVERAGE(D3,F3)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(H3>=3, \"High\",H3>=2, \"Moderate\", H3>=1, \"Low\", H3<1, \"Negligible\")","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Read Me'!$O$9=\"No\",0,'Step 4. Adapt. Capacity Scores'!M3>=H3,H3,'Step 4. Adapt. Capacity Scores'!M3<H3,'Step 4. Adapt. Capacity Scores'!M3)","v":{"$error":"#N/A"}},{"$f":"H3-J3","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(K3>=3, \"High\",K3>=2, \"Moderate\", K3>=0.5, \"Low\", K3<0.5, \"Minimal\")","v":{"$error":"#N/A"}}]
[{"$f":"'Step 4. Adapt. Capacity Scores'!A4","v":0},{"$f":"'Step 4. Adapt. Capacity Scores'!B4","v":0},{"$f":"'Step 4. Adapt. Capacity Scores'!C4","v":0},{"$f":"'Step 1. Exposure Data Scores'!AZ4","v":{"$error":"#N/A"}},{"$f":"'Step 1. Exposure Data Scores'!BA4","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AY4","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AZ4","v":{"$error":"#N/A"}},{"$f":"AVERAGE(D4,F4)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(H4>=3, \"High\",H4>=2, \"Moderate\", H4>=1, \"Low\", H4<1, \"Negligible\")","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Read Me'!$O$9=\"No\",0,'Step 4. Adapt. Capacity Scores'!M4>=H4,H4,'Step 4. Adapt. Capacity Scores'!M4<H4,'Step 4. Adapt. Capacity Scores'!M4)","v":{"$error":"#N/A"}},{"$f":"H4-J4","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS(K4>=3, \"High\",K4>=2, \"Moderate\", K4>=0.5, \"Low\", K4<0.5, \"Minimal\")","v":{"$error":"#N/A"}}]
[{"$f":"'Step 4. Adapt. Capacity Scores'!A5","v":0},{"$f":"'Step 4. Adapt. Capacity Scores'!B5","v":0},{"$f":"'Step 4. Adapt. Capacity Scores'!C5","v":0},{"$f":"'Step 1. Exposure Data Scores'!AZ5","v":{"$error":"#N/A"}},{"$f":"'Step 1. Exposure Data Scores'!BA5","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AY5","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AZ5","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"_xlfn.IFS(H5>=3, \"High\",H5>=2, \"Moderate\", H5>=1, \"Low\", H5<1, \"Negligible\")","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Read Me'!$O$9=\"No\",0,'Step 4. Adapt. Capacity Scores'!M5>=H5,H5,'Step 4. Adapt. Capacity Scores'!M5<H5,'Step 4. Adapt. Capacity Scores'!M5)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"_xlfn.IFS(K5>=3, \"High\",K5>=2, \"Moderate\", K5>=0.5, \"Low\", K5<0.5, \"Minimal\")","v":{"$error":"#N/A"}}]
[{"$f":"'Step 4. Adapt. Capacity Scores'!A6","v":0},{"$f":"'Step 4. Adapt. Capacity Scores'!B6","v":0},{"$f":"'Step 4. Adapt. Capacity Scores'!C6","v":0},{"$f":"'Step 1. Exposure Data Scores'!AZ6","v":{"$error":"#N/A"}},{"$f":"'Step 1. Exposure Data Scores'!BA6","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AY6","v":{"$error":"#N/A"}},{"$f":"'Step 2. Sensitivity Data Scores'!AZ6","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"_xlfn.IFS(H6>=3, \"High\",H6>=2, \"Moderate\", H6>=1, \"Low\", H6<1, \"Negligible\")","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFS('Read Me'!$O$9=\"No\",0,'Step 4. Adapt. Capacity Scores'!M6>=H6,H6,'Step 4. Adapt. Capacity Scores'!M6<H6,'Step 4. Adapt. Capacity Scores'!M6)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"_xlfn.IFS(K6>=3, \"High\",K6>=2, \"Moderate\", K6>=0.5, \"Low\", K6<0.5, \"Minimal\")","v":{"$error":"#N/A"}}]
["END OF WORKSHEET"]

{"sheet":"Exposure Data Scoring","index":9,"n_rows":8,"n_cols":46,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Exposure Data Scoring",null,null,"Flooding Indicator Scoring",null,null,null,null,null,"Storm Surge/Seiche Indicator Scoring",null,null,null,null,null,"Lake Level Rise Indicator Scoring",null,null,null,"Historical Flooding Indicator Scoring",null,null,null,"Erosion Indicator Scoring",null,null,null,"Geology Indicator Scoring",null,null,null,"Soils Indicator Scoring",null,null,null,null,null,null,"Fish and Wildlife Habitat Scoring Indicator"]
["FEMA Flood Data","Score","LiDAR Elevation Data","Score","Flood Elevation Data","Score","NOAA CO-OP Data","Score","Slope Data","Score","Fetch Exposure Index Data","Score","Elevation Data","Score","NOAA CO-OP Data","Score","Elevation Data","Score","USGS Stream Gage Data","Score","NOAA AHPS Data","Score","Erosion Data","Score","CEHM Data","Score","USGS Bedrock Geology Data","Score","USGS Surficial Geology Data","Score","gSSURGO Data","Score","North Shore Red Clay Soils Data","Score","Scientific and Natural Areas Data","Score","State Aquatic Management Areas Data","Score","Native Plant Communities","Score","Site of Biodiversity Significance","Score","National Wetland Inventory","Score","Wildlife Management Area","Score"]
["Zone AO",4,null,4,"< 0",4,null,4,14.8,4,529117,4,null,4,"> 4 ft",4,null,4,null,4,31.27,4,"High",4,"High",4,"Basalt",4,"Fill",4,0.6,4,">15%",4,"Yes",4,"Yes",4,"Yes",4,"Yes",4,"Yes",4,"Yes",4]
["Zone A",3,null,3,null,3,null,3,7.5,3,382041,3,null,3,"3 - 4 ft",3,null,3,null,3,27.75,3,"Moderate",2,null,3,"Andesite",3,"Alluvium",3,0.4,3,"8-15%",2,null,3,null,3,null,3,null,3,null,3,null,3]
["Zone AH",2,null,2,null,2,601.79999999999995,2,3.6,2,249691,2,null,2,"2 - 3 ft",2,null,2,null,2,24.3,2,null,null,null,2,"Basalt/Rhyolite",2,"Barnum Formation",2,0.2,2,"0-8%",1,null,2,null,2,null,2,null,2,null,2,null,2]
["Zone C",1,null,1,"> 0",1,{"$f":"'Step 1. Exposure DATA'!G3","v":0},1,1.1000000000000001,1,121122,1,null,1,"1 - 2 ft",1,null,1,null,1,20.7,1,"Low",1,"Low",1,"Rhyolite",1,"Clayey Sediment",1,0.1,1,null,0,"No",1,"No",1,"No",1,"No",1,"No",1,"No",1]
["N/A",0,null,0,null,0,null,0,0,0,null,0,null,0,"0 - 1 ft",0,null,0,null,0,null,0,"Unknown",0,"Unknown",0,"Granitic",0,"Bedrock",0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["END OF WORKSHEET"]

{"sheet":"Sensitivity Data Scoring","index":10,"n_rows":8,"n_cols":44,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Sensitivity Data Scoring",null,null,null,"Flood Damage Potential Indicator Scoring",null,null,null,"Storm Resistance and Condition Indicator Scoring",null,null,null,null,"Historical Damage Indicator Scoring",null,null,null,"Protective Engineering Indicator Scoring",null,null,null,"Infrastructure Indicator Scoring",null,null,null,null,null,null,null,"Fish and Wildlife Habitat Indicator Scoring",null,null,null,null,null,null,null,"Climate Indicator Scoring",null,null,null,"Water Quality Indicator Scoring"]
["FEMA Flood Data","Score","LiDAR Elevation Data","Score","Asset Elevated?","Score","500 Year Flood Potential?","Score","Built to Resist Flood/Wave Damage?","Score","Natural Resistivity?","Score","Historical Damage?","Score","Current Maintenance Level","Score","Protective Engineering In Place?","Score","Engineered Element Condition","Score","Critical Infrastructure Present?","Score","Infrastructure Protected?","Score","Scientific and Natural Areas Data","Score","State Aquatic Management Areas Data","Score","Native Plant Communities","Score","Site of Biodiversity Significance","Score","National Wetland Inventory","Score","Wildlife Management Area","Score","Preciptiation Change","Score","Temperature Change","Score","Invasive Species Present?","Score","Buffer Protection","Score"]
["Zone AO",4,null,4,"No",4,"Yes",4,"No",4,"No",4,"Yes",4,"Poor",4,"No",4,"Poor",4,"Yes",4,"No",4,"No",4,"No",4,"No",4,"No",4,"No",4,"No",4,">0.26",4,">0.24",4,"Yes",4,"Potential Trout Stream",4]
["Zone A",3,null,3,null,null,null,null,null,null,null,null,null,null,"Moderate",3,null,null,"Moderate",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,3,null,3,"50 Foot Buffer",3]
["Zone AH",2,null,2,null,null,null,null,null,null,null,null,null,null,"Good",2,null,null,"Good",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<0.26",2,"<0.24",2,null,2,"16.5 Foot Buffer",2]
["Zone C",1,null,1,"Yes",1,"No",1,"Yes",1,"Yes",1,"No",1,"New",1,"Yes",1,"New",1,null,null,"Yes",1,"Yes",1,"Yes",1,"Yes",1,"Yes",1,"Yes",1,"Yes",1,null,1,null,1,"No",1,"Needs Field Review",1]
["N/A",0,null,0,"N/A",0,null,null,"N/A",0,"N/A",0,"N/A",0,"None",0,"N/A",0,"None",0,"No",0,"N/A",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,"None",0]
["END OF WORKSHEET"]

{"sheet":"Adaptive Capacity Scoring","index":11,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Adaptive Capacity Scoring"]
["Elevate","Score","Relocate","Score","Protect/Engineer","Score","Decommission and Remove","Score","Storm Resistant Design","Score","Engineering Downgrade","Score"]
["Elevate Above",4,"Outside Floodplain",4,"Living Shoreline",4,"Yes",4,"Yes",4,"Yes",4]
["Fill Above",3,"Outside Baseflood",3,"Soft Hardening",3,null,3,null,3,null,3]
["Elevate Needs",2,"From Shore",2,"Hardening",2,null,2,null,2,null,2]
["No Elevating",1,"No Relocating",1,"No Protection",1,"No",1,"No",1,"No",1]
["N/A",0,"N/A",0,"N/A",0,"N/A",0,"N/A",0,"N/A",0]
["END OF WORKSHEET"]