Response Questions Part A To B A) Show Steps How You Do It On Excel: use the filter arrows to limit the table display to projects that are not in development B H C Number of Project Name Start Date D D.. Project Type Residential Days E Funding Type Tax Credit Loan 2 1 Grant S 2 Cook Street Lot 3 Orchid Drive Zoning 4 Historic Survey 5 Hallifax Brothers Expansion 6 Lahua Street Apartments 7 Oceanside Hotel 8 Kai Center Annexation 9 Orion Lake Pavilion 10 Laki Professional Building 11 East Ridge Mixed Use 12 Hoku Lane Subdivision 6/13/2021 11/20/2021 11/18/2021 7/12/2021 9/1/2021 10/3/2021 9/20/2021 11/1/2021 10/9/2021 7/28/2021 6/2/2021 30 240 420 328 Public Mixed Use Residential Commercial Commercial Public Commercial Mixed Use Residential Funding $ 2,000 $ 2,000 $ 2.200 2,200 $ 2,500 $ 3,010 $ 5,000 $ 8,555 $ 9,700 $ 20,000 $ 28,500 $ 45,500 Tax Credit Grant Tax Credit Loan Grant Grant Tax Credit Loan Approved? Yes No Yes Yes Yes No Yes Yes Yes 60 In Development? Yes No Yes No Yes No Yes Yes No No No 240 180 360 No Projects in Development Project Type Funding Type Project Name Number of Days Start Date Funding Approved? In Development? Yes Project Name Start Date Project Type Funding Type Funding Approved? In Development? Number of Days Number of Days Project Name Start Date Project Type Funding Type Funding Approved? In Development? B) 1) Show Steps How You Do It On Excel: In the range A2:A14, create a conditional formatting Highlight Cells Rule that displays cells with duplicate values using Light Red Fill and Dark Red Text. 2) Show Steps How You Do It On Excel: Delete the second instance of the duplicate record so that you can summarize the data accurately. Project Total wher Prop Average aber P Funding Type Funding Project Name 2 Old Town Design Plan 3 Honu Point Sports Complex 4 Mahina Regional Park 5 Downtown Bike Path 6 Burton Estates Expansion 7 Highacre Farms Modification 8 Makana Road Multifamily 9 Honu Point Center 10 Sunset Heights Zoning 11 Manu Hill Drive Parking 12 Allied Insurance 13 Nalu Parks Village 14 Sunset Heights Zoning Commercial Mixed Use Public Residential Start Date 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 4/20/2022 Number of Days 24 340 148 360 90 90 180 120 21 125 60 420 21 Project Type Public Commercial Public Public Mixed Use Residential Residential Mixed Use Mixed Use Commercial Commercial Mixed Use Mixed Use Funding Type Grant Loan Grant Grant Tax Credit Loan Tax Credit Grant Loan Tax Credit Tax Credit Loan Loan Funding $ 1,500 S 24,000 $ 12,500 S 15,000 $ 4,500 $ 10,000 S 15,000 $ 4,000 2021 Summary $ S S $ 9,500 6,000 50,000 2,500
