Instructions: Depending on your Excel skill level, you may find this assignment challenging 1. This assignment is from Extended Learning Module D in your textbook. Locate the chapter, and review the process of how to use Filter, Custom Filter, Conditional Formatting and Creating Pivot tables in this chapter. 2. Download Customer.xls provided in the homework assignment link to practice these Excel tools, applying the explanation provided in this module (or chapter). Description of the assignment: 3. FINDING OUT INFORMATION ABOUT YOUR EMPLOYEES - download employee.xls. Suppose you own a small business and have a workbook with the following list: . ID_Unique employee's identification number First Name-Employee's first name Last Name>Employee's last name Department-Employee's department TitleEmployee's job title Salan-Employee's annual salary Hire Date-Date employee was hired Birth DateEmployee's birthday Gender-Female (F) or Male (M) ClearanceN (none), C (confidential), S (secret), or TS (top secret) . . . . 4. For each task listed below, present your result in individual worksheet. Rename the worksheets used for the results with names that are meaningful, for example: Original Data (this would contain the information for the employee list) Average salary (this worksheet contains the result of a pivot table that summarizes each department's average salary by gender Clearance (this worksheet would contain the count of employees for different types of clearance)....... Task: a. Create a pivot table that shows average salary by gender within department. b. Create a pivot table that shows the number of employees by type of security clearance c. Use conditional formatting to highlight those employees in the Engineering department d. Use conditional formatting to highlight those employees who have no clearance (none). e. Use basic Filter to show only those employees who have top secret clearance (TS) f. Use Custom Filter to show only those employees who earn more than $50,000 g. Create a pivot table to show the highest and lowest salary of employees for each type of security clearance 5. When you are done with completing the assignment, you would have an Excel file with 8 worksheets (original list, and 7 result worksheets for tasks a through g). Rename this Excel file from employee.xls to your name.xls. Submit this file using the assignment link provided. L M 1 2 ID First Name Last Name Department Title 3 1009 Kevin Grundies Marketing CSR 4 1016 Oscar Gomez Marketing CSR 5 1032 Hilary Flintsteel Marketing Staff 6 1042 Maria Andretti Marketing CSR 7 1119 Sharad Manispour Engineering Security Engineer 8 1173 Roberta Kurzweil Management Manager 9 1355 Barbara Grabowski Management Manager 10 1441 James Van Hom Management Manager 11 1614 Artie Lambros Marketing CSR 12 1851 Melinda English Management Manager 13 2002 Edgar Rothrock Engineering Security Engineer 14 2042 Hillary Cushner Management Staff 15 2105 Luca Pacioli Marketing Staff 16 2122 Yuan Chang Engineering Security Engineer 17 2344 Nemesha Mehta Engineering Security Engineer 18 2451 Francine Detweiler Engineering Security Engineer 19 2678 Koshi Yamamoto Engineering Security Engineer 20 2733 John Zumkowski Engineering Staff 21 2768 Phyllis Leonard Engineering Security Engineer 22 2696 Samuel Gates Engineering Security Engineer 23 2956 Michael Goldstein Engineering Security Engineer 24 3015 Patti Stonesier Engineering Security Engineer 25 3043 Joseph Patemo Marketing Staff 26 3117 Frederich Bednarczyk Engineering Security Engineer 27 3210 Carmen Ortega-Molina Engineering Security Engineer 28 3314 Svetlana Kartashev Human Resources Staff 29 4006 Alice ROV Human Resources Manager 30 Salary 38,900 43,500 34,500 42,500 45,600 63,000 75,700 66,500 41,000 56,400 53,300 32,000 42,300 46,540 65,000 56,700 49,600 33,000 59,800 66,300 51.000 64,300 32,000 56,700 46,000 38,000 43,000 Hire Dato 12/24/89 2/16/90 3/21/90 3/21/90 10/13/90 6/16/92 10/13/92 12/18/92 5/16/93 10/1/93 2/8/94 8/26/94 8/26/95 9/5/95 10/1/95 10/10/95 11/16/95 4/18/96 12/13/96 1/28/97 4/11/97 7/6/98 7/6/98 5/14/99 9/16/99 11/5/01 12/1/01 Birth Date 3/4/61 4/29/07 8/22/58 8/20/70 2/4/69 12/22/58 4/10/65 2/3/58 7/13/70 2/14/56 3/21/70 5/6/61 5/6/50 3/4/64 2/12/65 4/20/70 1/24/63 12/12/72 7/2/70 4/10/74 3/7/03 3/10/86 3/10/68 6/27/70 3/28/52 5/3/82 1/26/55 Gender Clearance M M N F N F N M S F S F M s M N TS M + S F TS M S M TS F S F S F S M TS F TS M S M TS F S M N M S F S F N M S 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 38 AGNO 2 CUST ID REGION RENT VS. OWN NUM HOUSEHOLD 3 1 North Own 1 4 2 South Own 4 5 3 North Rent 3 6 4 West Own 5 7 5 East Own 8 6 South Own 9 7 East Own 10 8 West Rent 11 9 North Own 5 12 10 West Rent 7 13 11 North Own 1 14 12 East Own 2 15 13 South Own 5 16 14 South Own 4 17 15 South Rent 18 16 West Own 5 19 17 North Own 6 20 18 East Rent 2 21 19 West Own 3 22 20 North Rent 23 21 East Own 4 24 22 South Own 25 23 West Rent 5 26 24 North Rent 6 27 25 East Rent 7 28 26 South Own 3 29 27 West Rent 2 30 28 North Own 4 31 29 East Own 5 32 30 South Rent 4 33 31 West Own 2 34 32 East Rent 3 35 33 East Own 1 36 34 North 6 37 35 North Own 5 38 36 West Rent 4 39 37 East Rent 1 40 38 South Rent 5 41 39 East Rent 3 + NON SONO NON + ANNUAL INCOME TOTAL PURCHASES NUM PURCHASES 10K-25K $ 1 100K+ $ 30 25K-50K $ 19 3 25K-50K $ 21 6 50K-100K $ 35 10K-25K $ 27 100K+ $ 26 25K-50K $ 25 50K-100K $ 30 25K-50K $ 26 50K-100K $ 21 4 100K+ $ 29 10K-25K $ 20 7 25K-50K $ 27 10 50K-100K $ 19 2 25K-50K $ 19 6 50K-100K $ 129 5 10K-25K $ 99 7 25K-50K $ 99 4 50K-100K $ 119 3 50K-100K $ 149 2 50K-100K $ 165 8 25K-50K $ 119 6 10K-25K $ 129 7 100K+ $ 165 5 10K-25K $ 99 3 25K-50K $ 155 6 50K-100K $ 115 8 50K-100K $ 129 1 50K-100K $ 99 8 25K-50K $ 169 6 25K-50K $ 40 4 50K-100K S 36 7 100K+ $ 45 3 10K-25K $ 29 1 100K+ $ 28 4 25K-50K $ 46 1 50K-100K $ 50 4 50K-100K 22 0 N Own 42 43 44 45 46 47 48 49 50 51 52 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 20 19 31 30 18 31 35 28 29 35 30 38 20 40 30 40 62 22 25 6 7 3 2 4 5 3 7 3 2 6 5 3 1 5 6 3 4 5 7 2 3 1 4 2 3 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 en + West North East South West East South West East South North South West North East South West North East West East South East East South West East North North North South West West North East North East South North East Weet Own Own Own Rent Rent Own Own Own Rent Rent Own Own Own Rent Rent Own Rent Rent Rent Rent Rent Own Own Own Rent Own Own Rent Rent Own Rent Rent Rent Own Own Own Rent Own Rent Own 56 57 58 59 60 61 62 63 64 65 66 67 68 50K-100K 25K-50K 50K-100K 50K-100K 25K-50K 25K-50K 10K-25K 25K-50K 100K+ 10K-25K 25K-50K 50K-100K 50K-100K 25K-50K 25K-50K 25K-50K 10K-25K 100K+ 100K+ 10K-25K 25K-50K 25K-50K 25K-50K 50K-100K 50K-100K 25K-50K 50K-100K 50K-100K 100K+ 100K+ 100K+ 25K-50K 50K-100K 50K-100K 100K+ 10K-25K 100K+ 25K-50K 50K-100K 10K-25K 27 $ $ $ $ $ $ $ $ $ $ $ $ 9 3 1 10 3 7 6 5 8 6 4 7 3 5 4 8 7 9 1 4 7 4 3 8 9 3 2 11 2 6 8 6 8 9 3 6 5 7 2 4 70 71 72 73 74 75 76 77 78 79 80 81 22 30 31 22 25 24 36 123 19 23 19 25 129 119 109 179 145 119 129 189 $ $ $ $ $ $ $ $ $ $ 4 SOV 10 nic B 3 4 5 6 7 18 39 30 91 32 23 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 79 East 80 West 81 North 82 East 83 South 84 North 85 West 86 East 87 South 88 West 89 East 90 North 91 North 92 West 93 South 94 East 95 South 96 West 97 West 98 West 99 East 100 North 101 South 102 West 103 East 104 North 105 South 106 West 107 East 108 North 109 South 110 West 111 North 112 North 113 East 114 North 115 East 116 North 117 West 118 South Own Own Rent Own Rent Rent Own Rent Rent Own Own Rent Own Rent Rent Own Rent Rent Rent Rent Rent Own Own Rent Own Rent Own Rent Own Rent Rent Rent Own Own Own Rent Rent Rent Own Rent 4 6 5 4 3 2 4 6 4 1 2 3 2 3 7 6 5 4 5 6 3 4 2 1 3 4 5 4 6 3 4 5 7 2 3 5 3 2 10K-25K 50K-100K 25K-50K 25K-50K 25K-50K 50K-100K 100K+ 50K-100K 25K-50K 50K-100K 50K-100K 100K+ 100K+ 100K+ 25K-50K 50K-100K 50K-100K 100K+ 10K-25K 100K+ 25K-50K 50K-100K 10K-25K 50K-100K 10K-25K 100K+ 25K-50K 50K-100K 10K-25K 50K-100K 25K-50K 25K-50K 25K-50K 50K-100K 100K+ 50K-100K 25K-50K 50K-100K 50K-100K 100K+ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ + 189 155 78 61 97 63 39 95 86 85 59 84 144 26 31 19 30 29 25 24 36 29 99 169 179 119 99 179 185 179 145 119 99 155 119 149 56 50 86 45 4 6 4 5 7 2 3 1 7 5 7 9 10 1 1 1 1 11 2 6 5 7 9 3 1 7 4 7 6 8 9 3 2 5 4 7 5 6 3 2 110 111 112 113 114 115 116 117 118 119 120 $ $ 14 1001 Sheet1 Sheet2 Shed $ 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 + 119 East 120 West 121 South 122 East 123 North 124 East 125 North 126 South 127 West 128 North 129 East 130 North 131 West 132 South 133 East 134 North 135 East 136 East 137 North 138 South 139 West 140 East 141 North 142 South 143 West 144 East 145 North 146 East 147 West 148 North 149 East 150 North 151 East 152 West 153 North 154 South 155 East 156 North 157 West East South Shant Rent Rent Rent Rent Rent Own Rent Rent Rent Own Own Rent Own Own Rent Own Rent Own Own Rent Rent Rent Rent Own Own Rent Rent Own Own Rent Rent Own Own 1 3 2 4 5 6 3 4 6 2 4 6 3 4 7 4 5 6 2 3 4 5 1 2 3 4 5 4 3 6 2 4 3 3 5 4 6 7 2 3 100K+ 100K+ 25K-50K 50K-100K 50K-100K 100K+ 10K-25K 50K-100K 50K-100K 25K-50K 25K-50K 50K-100K 100K+ 10K-25K 100K+ 25K-50K 50K-100K 50K-100K 50K-100K 25K-50K 50K-100K 50K-100K 25K-50K 25K-50K 10K-25K 25K-50K 100K 100K+ 25K-50K 50K-100K 10K-25K 50K-100K 25K-SOK 25K-50K 25K-50K 50K-100K 100K+ 50K-100K 25K-50K 50K-100K 50K-100K $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 95 86 97 40 50 59 75 68 63 56 86 45 78 68 95 95 39 56 31 29 41 62 51 37 19 38 56 41 51 19 29 41 19 30 19 21 23 29 18 26 20 6 8 11 8 5 3 4 3 1 10 2 6 8 7 6 4 7 8 9 6 7 4 3 2 6 5 7 5 8 4 3 5 6 7 8 3 2 5 2 5 Own Own Rent Own Own Own Own Own 158 159 Instructions: Depending on your Excel skill level, you may find this assignment challenging 1. This assignment is from Extended Learning Module D in your textbook. Locate the chapter, and review the process of how to use Filter, Custom Filter, Conditional Formatting and Creating Pivot tables in this chapter. 2. Download Customer.xls provided in the homework assignment link to practice these Excel tools, applying the explanation provided in this module (or chapter). Description of the assignment: 3. FINDING OUT INFORMATION ABOUT YOUR EMPLOYEES - download employee.xls. Suppose you own a small business and have a workbook with the following list: . ID_Unique employee's identification number First Name-Employee's first name Last Name>Employee's last name Department-Employee's department TitleEmployee's job title Salan-Employee's annual salary Hire Date-Date employee was hired Birth DateEmployee's birthday Gender-Female (F) or Male (M) ClearanceN (none), C (confidential), S (secret), or TS (top secret) . . . . 4. For each task listed below, present your result in individual worksheet. Rename the worksheets used for the results with names that are meaningful, for example: Original Data (this would contain the information for the employee list) Average salary (this worksheet contains the result of a pivot table that summarizes each department's average salary by gender Clearance (this worksheet would contain the count of employees for different types of clearance)....... Task: a. Create a pivot table that shows average salary by gender within department. b. Create a pivot table that shows the number of employees by type of security clearance c. Use conditional formatting to highlight those employees in the Engineering department d. Use conditional formatting to highlight those employees who have no clearance (none). e. Use basic Filter to show only those employees who have top secret clearance (TS) f. Use Custom Filter to show only those employees who earn more than $50,000 g. Create a pivot table to show the highest and lowest salary of employees for each type of security clearance 5. When you are done with completing the assignment, you would have an Excel file with 8 worksheets (original list, and 7 result worksheets for tasks a through g). Rename this Excel file from employee.xls to your name.xls. Submit this file using the assignment link provided. L M 1 2 ID First Name Last Name Department Title 3 1009 Kevin Grundies Marketing CSR 4 1016 Oscar Gomez Marketing CSR 5 1032 Hilary Flintsteel Marketing Staff 6 1042 Maria Andretti Marketing CSR 7 1119 Sharad Manispour Engineering Security Engineer 8 1173 Roberta Kurzweil Management Manager 9 1355 Barbara Grabowski Management Manager 10 1441 James Van Hom Management Manager 11 1614 Artie Lambros Marketing CSR 12 1851 Melinda English Management Manager 13 2002 Edgar Rothrock Engineering Security Engineer 14 2042 Hillary Cushner Management Staff 15 2105 Luca Pacioli Marketing Staff 16 2122 Yuan Chang Engineering Security Engineer 17 2344 Nemesha Mehta Engineering Security Engineer 18 2451 Francine Detweiler Engineering Security Engineer 19 2678 Koshi Yamamoto Engineering Security Engineer 20 2733 John Zumkowski Engineering Staff 21 2768 Phyllis Leonard Engineering Security Engineer 22 2696 Samuel Gates Engineering Security Engineer 23 2956 Michael Goldstein Engineering Security Engineer 24 3015 Patti Stonesier Engineering Security Engineer 25 3043 Joseph Patemo Marketing Staff 26 3117 Frederich Bednarczyk Engineering Security Engineer 27 3210 Carmen Ortega-Molina Engineering Security Engineer 28 3314 Svetlana Kartashev Human Resources Staff 29 4006 Alice ROV Human Resources Manager 30 Salary 38,900 43,500 34,500 42,500 45,600 63,000 75,700 66,500 41,000 56,400 53,300 32,000 42,300 46,540 65,000 56,700 49,600 33,000 59,800 66,300 51.000 64,300 32,000 56,700 46,000 38,000 43,000 Hire Dato 12/24/89 2/16/90 3/21/90 3/21/90 10/13/90 6/16/92 10/13/92 12/18/92 5/16/93 10/1/93 2/8/94 8/26/94 8/26/95 9/5/95 10/1/95 10/10/95 11/16/95 4/18/96 12/13/96 1/28/97 4/11/97 7/6/98 7/6/98 5/14/99 9/16/99 11/5/01 12/1/01 Birth Date 3/4/61 4/29/07 8/22/58 8/20/70 2/4/69 12/22/58 4/10/65 2/3/58 7/13/70 2/14/56 3/21/70 5/6/61 5/6/50 3/4/64 2/12/65 4/20/70 1/24/63 12/12/72 7/2/70 4/10/74 3/7/03 3/10/86 3/10/68 6/27/70 3/28/52 5/3/82 1/26/55 Gender Clearance M M N F N F N M S F S F M s M N TS M + S F TS M S M TS F S F S F S M TS F TS M S M TS F S M N M S F S F N M S 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 38 AGNO 2 CUST ID REGION RENT VS. OWN NUM HOUSEHOLD 3 1 North Own 1 4 2 South Own 4 5 3 North Rent 3 6 4 West Own 5 7 5 East Own 8 6 South Own 9 7 East Own 10 8 West Rent 11 9 North Own 5 12 10 West Rent 7 13 11 North Own 1 14 12 East Own 2 15 13 South Own 5 16 14 South Own 4 17 15 South Rent 18 16 West Own 5 19 17 North Own 6 20 18 East Rent 2 21 19 West Own 3 22 20 North Rent 23 21 East Own 4 24 22 South Own 25 23 West Rent 5 26 24 North Rent 6 27 25 East Rent 7 28 26 South Own 3 29 27 West Rent 2 30 28 North Own 4 31 29 East Own 5 32 30 South Rent 4 33 31 West Own 2 34 32 East Rent 3 35 33 East Own 1 36 34 North 6 37 35 North Own 5 38 36 West Rent 4 39 37 East Rent 1 40 38 South Rent 5 41 39 East Rent 3 + NON SONO NON + ANNUAL INCOME TOTAL PURCHASES NUM PURCHASES 10K-25K $ 1 100K+ $ 30 25K-50K $ 19 3 25K-50K $ 21 6 50K-100K $ 35 10K-25K $ 27 100K+ $ 26 25K-50K $ 25 50K-100K $ 30 25K-50K $ 26 50K-100K $ 21 4 100K+ $ 29 10K-25K $ 20 7 25K-50K $ 27 10 50K-100K $ 19 2 25K-50K $ 19 6 50K-100K $ 129 5 10K-25K $ 99 7 25K-50K $ 99 4 50K-100K $ 119 3 50K-100K $ 149 2 50K-100K $ 165 8 25K-50K $ 119 6 10K-25K $ 129 7 100K+ $ 165 5 10K-25K $ 99 3 25K-50K $ 155 6 50K-100K $ 115 8 50K-100K $ 129 1 50K-100K $ 99 8 25K-50K $ 169 6 25K-50K $ 40 4 50K-100K S 36 7 100K+ $ 45 3 10K-25K $ 29 1 100K+ $ 28 4 25K-50K $ 46 1 50K-100K $ 50 4 50K-100K 22 0 N Own 42 43 44 45 46 47 48 49 50 51 52 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 20 19 31 30 18 31 35 28 29 35 30 38 20 40 30 40 62 22 25 6 7 3 2 4 5 3 7 3 2 6 5 3 1 5 6 3 4 5 7 2 3 1 4 2 3 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 en + West North East South West East South West East South North South West North East South West North East West East South East East South West East North North North South West West North East North East South North East Weet Own Own Own Rent Rent Own Own Own Rent Rent Own Own Own Rent Rent Own Rent Rent Rent Rent Rent Own Own Own Rent Own Own Rent Rent Own Rent Rent Rent Own Own Own Rent Own Rent Own 56 57 58 59 60 61 62 63 64 65 66 67 68 50K-100K 25K-50K 50K-100K 50K-100K 25K-50K 25K-50K 10K-25K 25K-50K 100K+ 10K-25K 25K-50K 50K-100K 50K-100K 25K-50K 25K-50K 25K-50K 10K-25K 100K+ 100K+ 10K-25K 25K-50K 25K-50K 25K-50K 50K-100K 50K-100K 25K-50K 50K-100K 50K-100K 100K+ 100K+ 100K+ 25K-50K 50K-100K 50K-100K 100K+ 10K-25K 100K+ 25K-50K 50K-100K 10K-25K 27 $ $ $ $ $ $ $ $ $ $ $ $ 9 3 1 10 3 7 6 5 8 6 4 7 3 5 4 8 7 9 1 4 7 4 3 8 9 3 2 11 2 6 8 6 8 9 3 6 5 7 2 4 70 71 72 73 74 75 76 77 78 79 80 81 22 30 31 22 25 24 36 123 19 23 19 25 129 119 109 179 145 119 129 189 $ $ $ $ $ $ $ $ $ $ 4 SOV 10 nic B 3 4 5 6 7 18 39 30 91 32 23 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 79 East 80 West 81 North 82 East 83 South 84 North 85 West 86 East 87 South 88 West 89 East 90 North 91 North 92 West 93 South 94 East 95 South 96 West 97 West 98 West 99 East 100 North 101 South 102 West 103 East 104 North 105 South 106 West 107 East 108 North 109 South 110 West 111 North 112 North 113 East 114 North 115 East 116 North 117 West 118 South Own Own Rent Own Rent Rent Own Rent Rent Own Own Rent Own Rent Rent Own Rent Rent Rent Rent Rent Own Own Rent Own Rent Own Rent Own Rent Rent Rent Own Own Own Rent Rent Rent Own Rent 4 6 5 4 3 2 4 6 4 1 2 3 2 3 7 6 5 4 5 6 3 4 2 1 3 4 5 4 6 3 4 5 7 2 3 5 3 2 10K-25K 50K-100K 25K-50K 25K-50K 25K-50K 50K-100K 100K+ 50K-100K 25K-50K 50K-100K 50K-100K 100K+ 100K+ 100K+ 25K-50K 50K-100K 50K-100K 100K+ 10K-25K 100K+ 25K-50K 50K-100K 10K-25K 50K-100K 10K-25K 100K+ 25K-50K 50K-100K 10K-25K 50K-100K 25K-50K 25K-50K 25K-50K 50K-100K 100K+ 50K-100K 25K-50K 50K-100K 50K-100K 100K+ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ + 189 155 78 61 97 63 39 95 86 85 59 84 144 26 31 19 30 29 25 24 36 29 99 169 179 119 99 179 185 179 145 119 99 155 119 149 56 50 86 45 4 6 4 5 7 2 3 1 7 5 7 9 10 1 1 1 1 11 2 6 5 7 9 3 1 7 4 7 6 8 9 3 2 5 4 7 5 6 3 2 110 111 112 113 114 115 116 117 118 119 120 $ $ 14 1001 Sheet1 Sheet2 Shed $ 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 + 119 East 120 West 121 South 122 East 123 North 124 East 125 North 126 South 127 West 128 North 129 East 130 North 131 West 132 South 133 East 134 North 135 East 136 East 137 North 138 South 139 West 140 East 141 North 142 South 143 West 144 East 145 North 146 East 147 West 148 North 149 East 150 North 151 East 152 West 153 North 154 South 155 East 156 North 157 West East South Shant Rent Rent Rent Rent Rent Own Rent Rent Rent Own Own Rent Own Own Rent Own Rent Own Own Rent Rent Rent Rent Own Own Rent Rent Own Own Rent Rent Own Own 1 3 2 4 5 6 3 4 6 2 4 6 3 4 7 4 5 6 2 3 4 5 1 2 3 4 5 4 3 6 2 4 3 3 5 4 6 7 2 3 100K+ 100K+ 25K-50K 50K-100K 50K-100K 100K+ 10K-25K 50K-100K 50K-100K 25K-50K 25K-50K 50K-100K 100K+ 10K-25K 100K+ 25K-50K 50K-100K 50K-100K 50K-100K 25K-50K 50K-100K 50K-100K 25K-50K 25K-50K 10K-25K 25K-50K 100K 100K+ 25K-50K 50K-100K 10K-25K 50K-100K 25K-SOK 25K-50K 25K-50K 50K-100K 100K+ 50K-100K 25K-50K 50K-100K 50K-100K $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 95 86 97 40 50 59 75 68 63 56 86 45 78 68 95 95 39 56 31 29 41 62 51 37 19 38 56 41 51 19 29 41 19 30 19 21 23 29 18 26 20 6 8 11 8 5 3 4 3 1 10 2 6 8 7 6 4 7 8 9 6 7 4 3 2 6 5 7 5 8 4 3 5 6 7 8 3 2 5 2 5 Own Own Rent Own Own Own Own Own 158 159