{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Calculator","Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":5,"comments":1,"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":"Instructions","index":0,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[10,4,10,5],[11,4,11,7],[2,4,2,5],[4,4,4,5],[5,4,5,5],[7,4,7,5],[8,4,8,7]]}
[]
[]
[null,null,null,null,"LEED v4\nAlternative Transportation Calculator"]
[]
[null,null,null,null,"Step 1. "]
[null,null,null,null,"Enable macros."]
[]
[null,null,null,null,"Step 2. "]
[null,null,null,null,"Compile the survey results and use the data to complete the Calculator tab."]
[]
[null,null,null,null,"Step 3. "]
[null,null,null,null,"Use the information on the Summary tab to complete the LEED Credit Form."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Regular or visitors","Sample Size"]
[null,null,null,null,null,null,null,null,null,null,50,45]
[null,null,null,null,null,null,null,null,null,null,75,64]
[null,null,null,null,null,null,null,null,null,null,100,81]
[null,null,null,null,null,null,null,null,null,null,125,96]
[null,null,null,null,null,null,null,null,null,null,150,110]
[null,null,null,null,null,null,null,null,null,null,175,122]
[null,null,null,null,null,null,null,null,null,null,200,134]
[null,null,null,null,null,null,null,null,null,null,225,144]
[null,null,null,null,null,null,null,null,null,null,250,154]
[null,null,null,null,null,null,null,null,null,null,275,163]
[null,null,null,null,null,null,null,null,null,null,300,172]
[null,null,null,null,null,null,null,null,null,null,325,180]
[null,null,null,null,null,null,null,null,null,null,350,187]
[null,null,null,null,null,null,null,null,null,null,375,194]
[null,null,null,null,null,null,null,null,null,null,400,201]
[null,null,null,null,null,null,null,null,null,null,425,207]
[null,null,null,null,null,null,null,null,null,null,450,212]
[null,null,null,null,null,null,null,null,null,null,500,222]
[null,null,null,null,null,null,null,null,null,null,600,240]
[null,null,null,null,null,null,null,null,null,null,700,255]
[null,null,null,null,null,null,null,null,null,null,800,267]
[null,null,null,null,null,null,null,null,null,null,900,277]
[null,null,null,null,null,null,null,null,null,null,1000,286]
[null,null,null,null,null,null,null,null,null,null,2000,333]
[null,null,null,null,null,null,null,null,null,null,3000,353]
[null,null,null,null,null,null,null,null,null,null,4000,364]
[null,null,null,null,null,null,null,null,null,null,5000,370]
[null,null,null,null,null,null,null,null,null,null,6000,375]
[null,null,null,null,null,null,null,null,null,null,7000,378]
[null,null,null,null,null,null,null,null,null,null,8000,381]
[null,null,null,null,null,null,null,null,null,null,9000,383]
[null,null,null,null,null,null,null,null,null,null,10000,385]
[null,null,null,null,null,null,null,null,null,null,15000,390]
[null,null,null,null,null,null,null,null,null,null,20000,392]
[null,null,null,null,null,null,null,null,null,null,25000,394]
[null,null,null,null,null,null,null,null,null,null,50000,397]
[null,null,null,null,null,null,null,null,null,null,100000,398]

{"sheet":"Calculator","index":1,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[5,1,5,2],[15,3,15,4],[15,1,16,2],[36,1,36,6],[15,5,15,6],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2]]}
[]
[null,"Calculator"]
[]
[]
[null,"Response Rates"]
[null,null,null,"Regular Project Occupants","Transient Project Occupants"]
[null,"Total",null,40]
[null,"Survey of entire project population or a random sample",null,"Entire population","Random sample"]
[null,"Total number of occupants required to receive the survey",null,{"$f":"IFERROR(VLOOKUP(D7,Instructions!K17:L53,2,TRUE),IF(D7<50,IF(D7-1<0,0,D7-1),\"\"))","v":39},{"$f":"IFERROR(VLOOKUP(E7,Instructions!K17:L53,2,TRUE),IF(E7<50,IF(E7-1<0,0,E7-1),\"\"))","v":0}]
[null,"Total number of occupants who received the survey",null,40]
[null,"Total number of occupants who responsed",null,36]
[null,"Occupant response rate (%)",null,{"$f":"IFERROR(D11/D10,0)","v":0.9},{"$f":" IFERROR(E11/E10,0)","v":0}]
[null,"Extrapolation factor for survey non-respondents",null,{"$f":"IF(AND(D12>=0, D12<0.3), 0, IF(AND(D12>=0.3, D12<0.4), 0.4, IF(AND(D12>=0.4, D12<0.5), 0.6, IF(AND(D12>=0.5, D12<0.6), 0.8, 1))))","v":1},{"$f":"IF(AND(E12>=0, E12<0.3), 0, IF(AND(E12>=0.3, E12<0.4), 0.4, IF(AND(E12>=0.4, E12<0.5), 0.6, IF(AND(E12>=0.5, E12<0.6), 0.8, 1))))","v":0}]
[]
[null,"Survey Results"]
[null,"Transportation Mode",null,"Regular Project Occupants",null,"Transient Project Occupants"]
[null,null,null,"Number\nof Trips","Weighted\nNumber \nof Trips","Number\nof Trips","Weighted Number \nof Trips"]
[null,"Trips not taken due to absence (sick, vacation, jury duty, etc.)",null,22,"N/A",null,"N/A"]
[null,"Single occupancy vehicle (SOV)",null,106,"N/A",null,"N/A"]
[null,"Human-powered conveyance (e.g. walking or biking)",null,66,"N/A",null,"N/A"]
[null,"Public transportation",null,99,"N/A",null,"N/A"]
[null,"Low-emitting or fuel-efficient vehicle",null,26,"N/A",null,"N/A"]
[null,"Total trips avoided due to telecommuting",null,26,"N/A",null,"N/A"]
[null,"Total trips avoided due to compressed work week",null,4,"N/A",null,"N/A"]
[null,"Ridesharing",null,0,"N/A",null,"N/A"]
[null,"Other alternative transportation mode (see below)",null,0,"N/A",null,"N/A"]
[null,"Carpool or Vanpool ID","Number of People in Carpool or Vanpool","Number\nof Trips","Weighted\nNumber \nof Trips","Number\nof Trips","Weighted Number \nof Trips"]
[{"$f":"IF(C28>=0,0,0)","v":0},"Group 1",2,3,{"$f":"IFERROR(D28*($C28-1/$C28),0)","v":4.5},null,{"$f":"IFERROR(F28*($C28-1/$C28),0)","v":0}]
[{"$f":"IF(C29>=0,0,0)","v":0},"Group 2",5,25,{"$f":"IFERROR(D29*($C29-1/$C29),0)","v":120},null,{"$f":"IFERROR(F29*($C29-1/$C29),0)","v":0}]
[{"$f":"IF(C30>=0,0,0)","v":0},"Group 3",5,11,{"$f":"IFERROR(D30*($C30-1/$C30),0)","v":52.8},null,{"$f":"IFERROR(F30*($C30-1/$C30),0)","v":0}]
[0,null,null,null,0,null,0]
[0,null,null,null,0,null,0]
[null,null,null,null,{"$f":"IFERROR(D33*($C33-1/$C33),0)","v":0},null,{"$f":"IFERROR(F33*($C33-1/$C33),0)","v":0}]
["A"]
[]
[null,"If applicable, describe the other alternative transportation mode."]

{"sheet":"Summary","index":2,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,7,4,7],[2,9,4,9]]}
[]
[]
[null,null,"Summary ",null,null,null,null,"Regular Occupants",null,"Transient Occupants"]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see previous tab. "]
[]
[null,null,"Total project occupants",null,null,null,null,{"$f":"Calculator!D7","v":40},null,{"$f":"Calculator!E7","v":0}]
[]
[null,null,"Total number of theoretical trips",null,null,null,null,{"$f":"IFERROR(Calculator!D10*10,0)","v":400},null,{"$f":"IFERROR(Calculator!E9*10,0)","v":0}]
[]
[null,null,"Total number of trips and absences",null,null,null,null,{"$f":"SUM(Calculator!D18:D34)","v":388},null,{"$f":"SUM(Calculator!F18:F34)","v":0}]
[]
[null,null,"Total number of actual trips",null,null,null,null,{"$f":" H10-Calculator!D18","v":366},null,{"$f":" J10-Calculator!F18","v":0}]
[]
[null,null,"Total single occupancy vehicle trips",null,null,null,null,{"$f":"Calculator!D19","v":106},null,{"$f":"Calculator!F19","v":0}]
[]
[null,null,"Total alternative transportation trips",null,null,null,null,{"$f":"H12-H14","v":260},null,{"$f":"J12-J14","v":0}]
[]
[null,null,"Alternative transportation rate (%)",null,null,null,null,{"$f":"IFERROR(H16/H6,0)","v":6.5},null,{"$f":"IFERROR(J16/J6,0)","v":0}]