Response Questions Part A To B A) Show Steps How You Do It On Excel: Insert a table in the range 18:L12, specifying that the data has headers H J Number Proposed K Total Funding L Average I Project Type * Type Commercial Mixed Use Public Residential Project Type 2 Public 3 Commercial 4 Public 5 Public 6 Mixed Use 7 Residential 8 Residential 9 Mixed Use 10 Mixed Use 11 Commercial 12 Commercial 13 Mixed Use I E Funding Type Grant Loan Grant Grant Tax Credit Loan Tax Credit Grant Loan Tax Credit Tax Credit Loan F Funding $ 1,500 $ 24,000 $ 12,500 $ 15,000 $ 4,500 $ 10,000 $ 15,000 $ 4,000 2,500 $ 9,500 $ 6,000 $ 50,000 $ 52,500 G Fast Track FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE TRUE 2021 Summary Started Completed $ Toject Type Commerical Mixed Use Public Residential Funding $ 45,500 $ 57,800 $ 33,750 $ 41,325 3 3 14 15 B) Show Steps How You Do It On Excel fron 1) to 5) : 1) Insert a subtotal at each change in the Funding Type value. 2) Use the Sum function to calculate the subtotals. 3) Add subtotals to the Funding values only. 4) Include a summary below the data. 5) Collapse the outline to display only the subtotals for each funding type and the grand total. Project Name Start Date Number of Project Type Funding Type Funding Approved? In Development? 6/2/2021 6/13/2021 7/12/2021 7/28/2021 No Yes No No Days 720 21 240 360 420 60 328 180 240 30 2 Hoku Lane Subdivision 3 Cook Street Lot 4 Hallifax Brothers Expansion 5 East Ridge Mixed Use 6 Lahua Street Apartments 7 Kai Center Annexation 8 Oceanside Hotel 9 Laki Professional Building 10 Orion Lake Pavilion 11 Historic Survey 12 Old Town Design Plan 13 Honu Point Sports Complex int Sports Complex 14 Downtown Bike Path 15 Mahina Regional Park 16 Burton Estates Expansion 17 Highacre Farms Modification 18 Makana Road Multifamily 19 Honu Point Center 20 Sunset Heights Zoning 21 Allied Insurance 22 Manu Hill Drive Parking 23 Nalu Parks Village Yes Yes No No Yes 24 Residential Residential Mixed Use Mixed Use Residential Commercial Commercial Commercial Public Public Public Commercial Public Public Mixed Use Residential Residential Mixed Use Mixed Use Commercial Commercial Mixed Use No Yes Yes No Yes Yes No Yes Yes Yes No No Yes 9/20/2021 10/3/2021 10/9/2021 11/1/2021 11/18/2021 1/10/2022 1/13/2022 2/22/2022 2/22/2022 3/3/2022 3/13/2022 3/19/2022 3/20/2022 3/20/2022 4/9/2022 4/9/2022 4/18/2022 Loan Tax Credit Tax Credit Tax Credit Grant Loan Tax Credit Grant Grant Grant Grant Loan Grant Grant Tax Credit Loan Tax Credit Grant Loan Tax Credit Tax Credit Loan $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 45,500 2.000 2,500 28,500 3,010 8,555 5,000 20,000 9,700 2,200 1,500 24,000 15,000 12,500 4,500 10,000 15,000 4,000 2,500 6,000 0,500 50,000 340 360 148 90 00 180 No No Yes Yes No Yes 120 21 60 125 420 No No No No No Yes No No 24
