Ch. 27, part 2, does not apply to open structures. You need Ch. 27 part 1 which covers open, monoslope free roofs. That said, in a pinch I can see the tables being conservative for a quick check of the MWFRS on a shed roof. The shed design is probably controlled by components and cladding anyway.
Ian Riley, PE, SE
Professional Engineer (ME, NH, MA) Structural Engineer (IL)
American Concrete Industries
Any free excel for this. I only see for enclosed structure. I'm checking the anchor bolt for uplift so I'm doing MWFRS. 27.4.3 formula is not complicated but an excel would be nice for faster repeated calcs.