Our facility has office staff who work Monday-Friday, and production staff who work Monday-Thursday... How would we handle this in the calculator when it asks "number of days in a typical work week", when it is 4 days for some, and 5 days for others?
You rely on LEEDuser. Can we rely on you?
LEEDuser is supported by our premium members, not by advertisers.Go premium for $12.95 »
Trista BrownProject Director
446 thumbs up
September 11, 2017 - 8:39 pm
Hi Claire, great question. I haven't submitted a project lately with this kind of work schedule, but I took a look at the calculator to see how you might do it.
One option I see is this: You can actually enter decimal values in cell F9, which then results in different number of total possible trips in cell F15. So it seems like you can adjust F9 based on the portion of regular occupants that work 4 days versus 5 days, and then the total possible trips will adjust for you accordingly. For example, if you have 10 occupants total, with half working 4 days and half working 5 days, you can enter 4.5 into F9 and it gives you 90 trips. This is the correct number since if everyone worked 4 days you'd get 80 trips, and if everyone worked 5 days you'd get 100 trips (all based on having 10 occupants total).
The second option I see is that you could categorize all occupants as working 5 days, but then for each production staff member that work 4 days, you'd enter 1 day/week as "trips avoided due to compressed work week" in cell F37. You'd just need to be sure that your survey lets production staff identify themselves so you can correctly account for their compressed workweeks.
I think option 2 might be the more straightforward way, but in either case, be sure you provide a narrative to GBCI so they understand how you've approached your calculations.