Number of Trips

Hi John, the number should account for round trips. This is because cell F15, which is calculating the total possible number of trips, uses the formula F14*F9*2. Assuming that F9 = 5 workdays, you have to actually input round trips due to the *2 in the formula. You'll be able to confirm you've accounted for all the survey responses correctly by checking that the value in F15 ends up matching F43. If they don't match you've likely entered something into the calculator incorrectly along the way.

Hi John, I double checked and cells F15 and F43 need to match in the current version of the calculator (updated 6/10/2016 to v02 - www.usgbc.org/resources/alternative-transportation-calculator).

Row 43 says: "Total number of data entries in table above (must match values in row 15)". Row 43 does take any absences into account. Absences are entered on row 42, which is included in the calculation for F43.

And like I said above, the *2 in the formula for cell F15 means you should enter round trips. For example, if you enter 10 regular occupants and 5 days in the workweek, you'll get 100 total possible trips in F15. If it was one-way only, it would show 50 trips.

Hi Trista, if you calculated 10 regular occupants x 5 days in a work week x 2 trips per day, that would result in 100 one way trips. If this is the case, wouldn't the calculator be based on one-way trips?

Hi Claire, I'm not sure I understand your question, since you're saying x 2 trips per day in your example. Basically, cell F15 in the calculator shows * 2 which means it's TOTAL trips for the 5 day period. So the rest of your calculator inputs need to account for the total number of trips taken. Maybe the "one way" vs "two way" vs "round trip" terminology is confusing. Essentially you need to account for how an individual gets to your project building (1 trip), and then how they leave from your project building (1 trip).