New Perspectives Excel 2019 Module 5: SAM Project 1a Narbonne Suites GENERATING REPORTS FROM MULTIPLE WORKBOOKS Author: Justin Gross New Perspectives Excel 2019 | Module 5: SAM Project 1a Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.   Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of   Narbonne Suites State Statewide Manager Location Email Idaho Lenard Zimmerman Nampa, ID Montana Doretta Burnam Oregon Thomasena Bustamante Gresham, OR Washington Frederic Brickley Tacoma, WA idahomgr@example.com Bozeman, MT montanamgr@example.com oregonmgr@example.com http://www.narbonnesuites.cengage.com/   Narbonne Suites Idaho 2021 Sales Q1 Q2 Q3 Q4 Total In Person $ 103,021.00 $ 138,048.00 $ 207,072.00 $ 109,202.00 $ 557,343.00 Online $ 88,980.00 $ 148,597.00 $ 239,241.00 $ 79,192.00 $ 556,010.00 AAA $ 201,042.00 $ 281,459.00 $ 425,003.00 $ 215,115.00 $ 1,122,619.00 Other $ 23,522.00 $ 31,519.00 $ 46,648.00 $ 16,936.00 $ 118,625.00 Total $ -   Narbonne Suites Montana 2021 Sales Q1 Q2 Q3 Q4 Total In Person $185,437.80 $248,486.40 $372,729.60 $196,563.60 $1,003,217.40 Online $96,988.20 $161,970.73 $260,772.69 $86,319.28 $606,050.90 AAA $349,813.08 $489,738.66 $739,505.22 $374,300.10 $1,953,357.06 Other $37,870.42 $50,745.59 $75,103.28 $27,266.96 $190,986.25 Total $0.00   Narbonne Suites Oregon 2021 Sales Q1 Q2 Q3 Q4 Total In Person $537,770 $720,611 $1,080,916 $570,034 $2,909,330 Online $242,471 $404,927 $651,932 $215,798 $1,515,127 AAA $1,248,833 $1,748,367 $2,640,034 $1,336,251 $6,973,485 Other $102,250 $137,013 $202,779 $73,621 $515,663 Total $0   Narbonne Suites Consolidated 2021 Sales Q1 Q2 Q3 Q4 Total 2020 Total $0 $0 $0 $0 Total $0 $0 $0 $0 $0