{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["vision_summary","csv_export","instructions"],"not_rendered":{"charts":11,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"vision_summary","index":0,"n_rows":130,"n_cols":4,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"A98&\" \"&B98","v":"Vision Name: 0"}]
[]
[{"$f":"A99&\" \"&B99","v":"Author: 0"}]
[]
[{"$f":"\"Year: \"&csv_export!B3","v":"Year: "}]
[]
[{"$f":"\"Report Date: \" & TEXT(csv_export!B4, \"MM/DD/YYYY\")","v":"Report Date: 01/00/1900"}]
[]
[]
[]
[]
[{"$f":"A106","v":"Water"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A119","v":"Biodiversity"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A113","v":"Carbon"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A125","v":"Population"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Vision Name:",{"$f":"csv_export!B1","v":0}]
["Author:",{"$f":"csv_export!B2","v":0}]
[]
[null,{"$f":"B99&\"'s Vision\"","v":"0's Vision"},"Mannahatta (1609)","Manhattan (2010)"]
["lifestyle",{"$f":"csv_export!B6","v":0},{"$f":"csv_export!C6","v":0},{"$f":"csv_export!D6","v":0}]
["climate",{"$f":"csv_export!B7","v":0},{"$f":"csv_export!C7","v":0},{"$f":"csv_export!D7","v":0}]
["precipitation event",{"$f":"csv_export!B8","v":0},{"$f":"csv_export!C8","v":0},{"$f":"csv_export!D8","v":0}]
[]
["Water"]
[]
["stormwater drainage",{"$f":"ROUND(SUMIFS(csv_export!I$11:I$1048576, csv_export!$E$11:$E$1048576, $A108), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!J$11:J$1048576, csv_export!$E$11:$E$1048576, $A108), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!K$11:K$1048576, csv_export!$E$11:$E$1048576, $A108), 1)","v":0}]
["piped water",{"$f":"ROUND(SUMIFS(csv_export!I$11:I$1048576, csv_export!$B$11:$B$1048576, $A109), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!J$11:J$1048576, csv_export!$B$11:$B$1048576, $A109), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!K$11:K$1048576, csv_export!$B$11:$B$1048576, $A109), 1)","v":0}]
["floodwaters",{"$f":"ROUND(SUMIFS(csv_export!I$11:I$1048576, csv_export!$E$11:$E$1048576, $A110), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!J$11:J$1048576, csv_export!$E$11:$E$1048576, $A110), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!K$11:K$1048576, csv_export!$E$11:$E$1048576, $A110), 1)","v":0}]
[]
[]
["Carbon"]
[]
["greenhouse gases",{"$f":"ROUND(SUMIFS(csv_export!I$11:I$1048576, csv_export!$B$11:$B$1048576, $A115), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!J$11:J$1048576, csv_export!$B$11:$B$1048576, $A115), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!K$11:K$1048576, csv_export!$B$11:$B$1048576, $A115), 1)","v":0}]
["solid waste",{"$f":"ROUND(SUMIFS(csv_export!I$11:I$1048576, csv_export!$C$11:$C$1048576, $A116), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!J$11:J$1048576, csv_export!$C$11:$C$1048576, $A116), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!K$11:K$1048576, csv_export!$C$11:$C$1048576, $A116), 1)","v":0}]
[]
[]
["Biodiversity"]
[]
["species",{"$f":"ROUND(SUMIFS(csv_export!I$11:I$1048576, csv_export!$E$11:$E$1048576, $A121), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!J$11:J$1048576, csv_export!$E$11:$E$1048576, $A121), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!K$11:K$1048576, csv_export!$E$11:$E$1048576, $A121), 1)","v":0}]
["habitat",{"$f":"ROUND(SUMIFS(csv_export!I$11:I$1048576, csv_export!$E$11:$E$1048576, $A122), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!J$11:J$1048576, csv_export!$E$11:$E$1048576, $A122), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!K$11:K$1048576, csv_export!$E$11:$E$1048576, $A122), 1)","v":0}]
[]
[]
["Population"]
[]
["residents",{"$f":"ROUND(SUMIFS(csv_export!I$11:I$1048576, csv_export!$E$11:$E$1048576, $A127), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!J$11:J$1048576, csv_export!$E$11:$E$1048576, $A127), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!K$11:K$1048576, csv_export!$E$11:$E$1048576, $A127), 1)","v":0}]
["workers",{"$f":"ROUND(SUMIFS(csv_export!I$11:I$1048576, csv_export!$E$11:$E$1048576, $A128), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!J$11:J$1048576, csv_export!$E$11:$E$1048576, $A128), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!K$11:K$1048576, csv_export!$E$11:$E$1048576, $A128), 1)","v":0}]
["daytime density",{"$f":"ROUND(SUMIFS(csv_export!I$11:I$1048576, csv_export!$E$11:$E$1048576, $A129), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!J$11:J$1048576, csv_export!$E$11:$E$1048576, $A129), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!K$11:K$1048576, csv_export!$E$11:$E$1048576, $A129), 1)","v":0}]
["nighttime density",{"$f":"ROUND(SUMIFS(csv_export!I$11:I$1048576, csv_export!$E$11:$E$1048576, $A130), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!J$11:J$1048576, csv_export!$E$11:$E$1048576, $A130), 1)","v":0},{"$f":"ROUND(SUMIFS(csv_export!K$11:K$1048576, csv_export!$E$11:$E$1048576, $A130), 1)","v":0}]

{"sheet":"csv_export","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"instructions","index":2,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["This template allows you to graph and compare the output from your vision and the same area in 1609 and 2010."]
["Simply download the CSV of your vision's data summary and paste it into cell A1 in the \"csv_export\" sheet."]
["This will populate the tables found in the \"vision_summary\" sheet in this workbook. By default, the same metrics compared in the Environmental Performance tab are shown here; you can modify the included formulas to compare any metric."]
["The \"vision_summary\" sheet is formatted to print as three 8.5\" x 11\" sheets of paper."]