This supplemental calculator Excel file only seems to create problems every time I used it! Right now, I'm trying to document the prescriptive method for toplighting, but the floor area isn't registering and summing in the total. I put in the floor area the skylight covers, the area of the skylight, and the Tvis but nothing is happening. The spreadsheet caclulates the skylight coverage percentage, but nothing happens in the "toplighted area subtotal" column. Anyone know what else I need to do for this? I have used the calculator before using the simulation and sidelighitng prescriptive options, so I'm not sure what is wrong this time.
Thanks!
TODD REED
Energy Program SpecialistPA DMVA
LEEDuser Expert
890 thumbs up
November 17, 2011 - 9:13 am
Sounds like a download issue, or an error in the script. Down load it again and save it some where else. I personally create my own spreadsheets that do the same thing as the one's available. This way it can be modified and i can correct any issues.
Eddy Santosa
Director of SustainabilityDBR Engineering Consultants
376 thumbs up
November 17, 2011 - 1:14 pm
Lauren, if you can send me the spreadsheet, I can take a look on that.
Todd is correct that it may be the macros from the excel. I didn't have any problem using their spreadsheet last time but there was a formula error last time in one of them. I agree with Todd, if you can make your own, it's much better.
Lauren Fakhoury
Research Assistant85 thumbs up
November 17, 2011 - 2:14 pm
Thanks, Eddy. I figured out what is going on with the template. I am trying to get the toplighting percentage between 3 and 6 to comply, and am reducing the zone floor area to reach that number. The calculator is using the actual floor area, but I think that it should be using the zone floor area to calculate the toplighted area. Someone from GBCI has been helping me, but it's still not working! At least I know what is wrong now. Thank you!
Eddy Santosa
Director of SustainabilityDBR Engineering Consultants
376 thumbs up
November 22, 2011 - 3:59 pm
It's good, Lauren.. You may need to double check though.. as I remember, the new amendment define that the zone floor area is the daylit area.