Using the attached floor plan recreate the load calculation table shown in Figure $17-10$ and fully populate to determine the heating and cooling load calculations. You can follow steps $1-15$ that begin on page $394.\backslash$table$[[$COOLING HEAT TRANSFER FACTORS$],[$Type of Construction,Cooling Factor $^(**)],[$Walls$],[$Wood Frame with Sheeting, Siding, and Veneer or Other Finish$],[$No insulation, $1/2^($e $)$ gypsum board,$5\mathrm{.}0,6\mathrm{.}4,7\mathrm{.}8],[$R$-13$ cavity insulation $+1/2^(\text{'}\text{'})$ gypsum board,$1\mathrm{.}5,1\mathrm{.}9,2\mathrm{.}3],[$R$-13$ cavity insulation $+3/4^(\text{'}\text{'})$ bead board $($R$-2\mathrm{.}7),1\mathrm{.}3,1\mathrm{.}7,2\mathrm{.}0],[$R$-19$ cavity insulation $+1/2^(\text{'}\text{'})$ gypsum board,$1\mathrm{.}1,1\mathrm{.}4,1\mathrm{.}7],[$R$-19$ cavity insulation $+3/4^()$ extruded poly,$0\mathrm{.}9,1\mathrm{.}2,1\mathrm{.}4],[$Above grade $+$ R$-11,0\mathrm{.}9,1\mathrm{.}3,1\mathrm{.}6],[$Below grade $-$ No insulation,$0\mathrm{.}0,0\mathrm{.}0,0\mathrm{.}0],[$Below grade $+$ R$-5,0\mathrm{.}0,0\mathrm{.}0,0\mathrm{.}0],[$Below grade $+$ R$-11,0\mathrm{.}0,0\mathrm{.}0,0\mathrm{.}0],[$Ceilings$],[$No insulation,$17\mathrm{.}0,19\mathrm{.}2,21\mathrm{.}4],[2^($of $)-21/2^($I$)$ insulation R$-7,4\mathrm{.}4,4\mathrm{.}9,5\mathrm{.}5],[3^(\text{'}\text{'})-31/2^($n$)$ insulation R $-11,3\mathrm{.}2,3\mathrm{.}7,4\mathrm{.}1],[51/4^(\text{'}\text{'})-61/2^(\text{'}\text{'})$ insulation R$-19,2\mathrm{.}1,2\mathrm{.}3,2\mathrm{.}6],[$R$-19,1\mathrm{.}9,2\mathrm{.}2,2\mathrm{.}4],[$R$-22,1\mathrm{.}8,2\mathrm{.}0,2\mathrm{.}2],[$Floors$],[$Over Unconditioned Space$],[$Over basement or enclosed crawl space $($not vented$),0\mathrm{.}0,0\mathrm{.}0,0\mathrm{.}0],[$Over vented space or garage,$3\mathrm{.}9,5\mathrm{.}8,7\mathrm{.}7],[$Over vented space or garage $+$ R$-11$ insulation,$0\mathrm{.}8,1\mathrm{.}3,1\mathrm{.}7],[$Over vented space or garage $+$R $-19$ insulation,$0\mathrm{.}5,0\mathrm{.}8,1\mathrm{.}1],[$Basement Concrete Slab Floor Unheated$],[$No edge insulation,$0\mathrm{.}0,0\mathrm{.}0,0\mathrm{.}0],[1^(($I$)$ edge insulation R$-5,0\mathrm{.}0,0\mathrm{.}0,0\mathrm{.}0],[2^(\text{'}\text{'})$ edge insulation R$-9,0\mathrm{.}0,0\mathrm{.}0,0\mathrm{.}0],[$Basement Concrete Slab Floor Duct in Slab$],[$No edge insulation,$0\mathrm{.}0,0\mathrm{.}0,0\mathrm{.}0],[1^(($I$)$ edge insulation R$-5,0\mathrm{.}0,0\mathrm{.}0,0\mathrm{.}0],[2^(\text{'}\text{'})$ edge insulation R$-9,0\mathrm{.}0,0\mathrm{.}0,0\mathrm{.}0]]$

NOTES:

Location: Flagstaff, Arizona

Windows: Casement with insulating glass

Doors: Door to deck is double glass, entry door is weatherstripped and with storm door

Walls: Block furred with R$-5$ insulation

Ceiling: Under unconditioned space R$-22$ insulation $(6"-7")$

Floor: Over unconditioned space R$-19$ insulation $(51/4"-61/2")$

$\backslash$table$[[$OUTDOOR DESIGN TEMPERATURE$],[$State and City,Lat. $^(5),\backslash$table$[[\backslash$table$[[$Winter$],[$DB$^(*)]]]],$Summer$],[$DB$*^(*),\backslash$table$[[\backslash$table$[[$Daily$],[$Range$*]]]],$WB$*^(*)],[$ALABAMA$],[$Alexander City,$32,18,96,21,79],[$Auburn$,32,18,96,21,79],[$Birmingham$,33,17,96,21,78],[$Huntsville$,34,11,95,23,78],[$Mobile$,30,25,95,18,80],[$Montgomery$,32,22,96,21,79],[$Talladega$,33,18,97,21,79],[$Tuscaloosa$,33,20,98,22,79],[$ALASKA$],[$Anchorage$,61,-23,71,15,60],[$Barrow$,71,-45,57,12,54],[$Fairbanks$,64,-51,82,24,64],[$Juneau$,58,-4,74,15,61],[$Kodiak$,57,10,69,10,60],[$Nome$,64,-31,66,10,58],[$ARIZONA$],[$Flagstaft$,35,-2,84,31,61],[$Phoenix$,33,31,109,27,76],[$Tucson$,32,28,104,26,72],[$Yuma$,32,36,111,27,79]]$