calculate gla adjustment -- open office
Post on 25-Nov-2014
28 Views
Preview:
TRANSCRIPT
3 Sales
Page 1
1 2GLA Sale Price Adj / Sq.Ft. $40 $41
Sale 1 $0 $0Sale 2 $0 $0Sale 3 $0 $0
Subject Max-Min $0 $0Auto Min Amt $0Adj Amt / Ft
Fill in GLA and Sale Prices of Comparables (Column B & D) - Leave Column C Alone
Minimum amount will automatically show-up in Yellow SquareAt that point you can move Right to see Adjustment you need, or keep modifying G2
For your own records, if you save this spreadsheet with other data in report, fill in Green Square G8
You can change intitial adjustment at BLUE number in G2 Whenever you want, following amounts automatically adjust
3 Sales
Page 2
3 4 5 6 7 8$42 $43 $44 $45 $46 $47$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
Fill in GLA and Sale Prices of Comparables (Column B & D) - Leave Column C Alone
At that point you can move Right to see Adjustment you need, or keep modifying G2
For your own records, if you save this spreadsheet with other data in report, fill in Green Square G8
number in G2 Whenever you want, following amounts automatically adjust
3 Sales
Page 3
9 10 11 12 13 14$48 $49 $50 $51 $52 $53$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 4
15 16 17 18 19 20$54 $55 $56 $57 $58 $59$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 5
21 22 23 24 25 26$60 $61 $62 $63 $64 $65$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 6
27 28 29 30 31 32$66 $67 $68 $69 $70 $71$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 7
33 34 35 36 37 38$72 $73 $74 $75 $76 $77$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 8
39 40 41 42 43 44$78 $79 $80 $81 $82 $83$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 9
45 46 47 48 49 50$84 $85 $86 $87 $88 $89$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 10
51 52 53 54 55 56$90 $91 $92 $93 $94 $95$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 11
57 58 59 60 61 62$96 $97 $98 $99 $100 $101$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 12
63 64 65 66 67 68$102 $103 $104 $105 $106 $107$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 13
69 70 71 72 73 74$108 $109 $110 $111 $112 $113$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 14
75 76 77 78 79 80$114 $115 $116 $117 $118 $119$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 15
81 82 83 84 85 86$120 $121 $122 $123 $124 $125$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 16
87 88 89 90 91 92$126 $127 $128 $129 $130 $131$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 17
93 94 95 96 97 98$132 $133 $134 $135 $136 $137$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 18
99 100 101 102 103 104$138 $139 $140 $141 $142 $143$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 19
105 106 107 108 109 110$144 $145 $146 $147 $148 $149$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 20
111 112 113 114 115 116$150 $151 $152 $153 $154 $155$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 21
117 118 119 120 121 122$156 $157 $158 $159 $160 $161$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 22
123 124 125 126 127 128$162 $163 $164 $165 $166 $167$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 23
129 130 131 132 133 134$168 $169 $170 $171 $172 $173$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 24
135 136 137 138 139 140$174 $175 $176 $177 $178 $179$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 25
141 142 143 144 145 146$180 $181 $182 $183 $184 $185$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
3 Sales
Page 26
147 148 149 150$186 $187 $188 $189$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
4 Sales
Page 27
1 2GLA Sale Price Adj / Sq.Ft. $40 $41
Sale 1 $0 $0Sale 2 $0 $0Sale 3 $0 $0
Sale 4 $0 $0
Subject Max-Min $0 $0Auto Min Amt $0Adj Amt / Ft
Fill in GLA and Sale Prices of Comparables (Column B & D) - Leave Column C Alone
Minimum amount will automatically show-up in Yellow SquareAt that point you can move Right to see Adjustment you need, or keep modifying G2
For your own records, if you save this spreadsheet with other data in report, fill in Green Square G8
You can change intitial adjustment at BLUE number in G2 Whenever you want, following amounts automatically adjust
4 Sales
Page 28
3 4 5 6 7 8$42 $43 $44 $45 $46 $47$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
Fill in GLA and Sale Prices of Comparables (Column B & D) - Leave Column C Alone
At that point you can move Right to see Adjustment you need, or keep modifying G2
For your own records, if you save this spreadsheet with other data in report, fill in Green Square G8
number in G2 Whenever you want, following amounts automatically adjust
4 Sales
Page 29
9 10 11 12 13 14$48 $49 $50 $51 $52 $53$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 30
15 16 17 18 19 20$54 $55 $56 $57 $58 $59$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 31
21 22 23 24 25 26$60 $61 $62 $63 $64 $65$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 32
27 28 29 30 31 32$66 $67 $68 $69 $70 $71$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 33
33 34 35 36 37 38$72 $73 $74 $75 $76 $77$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 34
39 40 41 42 43 44$78 $79 $80 $81 $82 $83$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 35
45 46 47 48 49 50$84 $85 $86 $87 $88 $89$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 36
51 52 53 54 55 56$90 $91 $92 $93 $94 $95$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 37
57 58 59 60 61 62$96 $97 $98 $99 $100 $101$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 38
63 64 65 66 67 68$102 $103 $104 $105 $106 $107$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 39
69 70 71 72 73 74$108 $109 $110 $111 $112 $113$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 40
75 76 77 78 79 80$114 $115 $116 $117 $118 $119$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 41
81 82 83 84 85 86$120 $121 $122 $123 $124 $125$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 42
87 88 89 90 91 92$126 $127 $128 $129 $130 $131$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 43
93 94 95 96 97 98$132 $133 $134 $135 $136 $137$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 44
99 100 101 102 103 104$138 $139 $140 $141 $142 $143$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 45
105 106 107 108 109 110$144 $145 $146 $147 $148 $149$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 46
111 112 113 114 115 116$150 $151 $152 $153 $154 $155$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 47
117 118 119 120 121 122$156 $157 $158 $159 $160 $161$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 48
123 124 125 126 127 128$162 $163 $164 $165 $166 $167$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 49
129 130 131 132 133 134$168 $169 $170 $171 $172 $173$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 50
135 136 137 138 139 140$174 $175 $176 $177 $178 $179$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 51
141 142 143 144 145 146$180 $181 $182 $183 $184 $185$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
4 Sales
Page 52
147 148 149 150$186 $187 $188 $189$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
5 Sales
Page 53
1 2GLA Sale Price Adj / Sq.Ft. $40 $41
Sale 1 $0 $0Sale 2 $0 $0Sale 3 $0 $0
Sale 4 $0 $0
Sale 5 $0 $0
Subject Max-Min $0 $0Auto Min Amt $0Adj Amt / Ft
Fill in GLA and Sale Prices of Comparables (Column B & D) - Leave Column C Alone
Minimum amount will automatically show-up in Yellow SquareAt that point you can move Right to see Adjustment you need, or keep modifying G2
For your own records, if you save this spreadsheet with other data in report, fill in Green Square G8
You can change intitial adjustment at BLUE number in G2 Whenever you want, following amounts automatically adjust
5 Sales
Page 54
3 4 5 6 7 8$42 $43 $44 $45 $46 $47$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
Fill in GLA and Sale Prices of Comparables (Column B & D) - Leave Column C Alone
At that point you can move Right to see Adjustment you need, or keep modifying G2
For your own records, if you save this spreadsheet with other data in report, fill in Green Square G8
number in G2 Whenever you want, following amounts automatically adjust
5 Sales
Page 55
9 10 11 12 13 14$48 $49 $50 $51 $52 $53$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 56
15 16 17 18 19 20$54 $55 $56 $57 $58 $59$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 57
21 22 23 24 25 26$60 $61 $62 $63 $64 $65$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 58
27 28 29 30 31 32$66 $67 $68 $69 $70 $71$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 59
33 34 35 36 37 38$72 $73 $74 $75 $76 $77$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 60
39 40 41 42 43 44$78 $79 $80 $81 $82 $83$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 61
45 46 47 48 49 50$84 $85 $86 $87 $88 $89$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 62
51 52 53 54 55 56$90 $91 $92 $93 $94 $95$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 63
57 58 59 60 61 62$96 $97 $98 $99 $100 $101$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 64
63 64 65 66 67 68$102 $103 $104 $105 $106 $107$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 65
69 70 71 72 73 74$108 $109 $110 $111 $112 $113$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 66
75 76 77 78 79 80$114 $115 $116 $117 $118 $119$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 67
81 82 83 84 85 86$120 $121 $122 $123 $124 $125$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 68
87 88 89 90 91 92$126 $127 $128 $129 $130 $131$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 69
93 94 95 96 97 98$132 $133 $134 $135 $136 $137$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 70
99 100 101 102 103 104$138 $139 $140 $141 $142 $143$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 71
105 106 107 108 109 110$144 $145 $146 $147 $148 $149$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 72
111 112 113 114 115 116$150 $151 $152 $153 $154 $155$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 73
117 118 119 120 121 122$156 $157 $158 $159 $160 $161$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 74
123 124 125 126 127 128$162 $163 $164 $165 $166 $167$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 75
129 130 131 132 133 134$168 $169 $170 $171 $172 $173$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 76
135 136 137 138 139 140$174 $175 $176 $177 $178 $179$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 77
141 142 143 144 145 146$180 $181 $182 $183 $184 $185$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
5 Sales
Page 78
147 148 149 150$186 $187 $188 $189$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 79
1GLA Sale Price Adj / Sq.Ft. $40
Sale 1 $0Sale 2 $0Sale 3 $0
Sale 4 $0
Sale 5 $0
Sale 6 $0Subject Max-Min $0
Auto Min Amt $0Adj Amt / Ft
Fill in GLA and Sale Prices of Comparables (Column B & D) - Leave Column C Alone
Minimum amount will automatically show-up in Yellow SquareAt that point you can move Right to see Adjustment you need, or keep modifying G2
For your own records, if you save this spreadsheet with other data in report, fill in Green Square G8
You can change intitial adjustment at BLUE number in G2 Whenever you want, following amounts automatically adjust
6 Sales
Page 80
2 3 4 5$41 $42 $43 $44$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
Fill in GLA and Sale Prices of Comparables (Column B & D) - Leave Column C Alone
At that point you can move Right to see Adjustment you need, or keep modifying G2
For your own records, if you save this spreadsheet with other data in report, fill in Green Square G8
number in G2 Whenever you want, following amounts automatically adjust
6 Sales
Page 81
6 7 8 9$45 $46 $47 $48$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 82
10 11 12 13$49 $50 $51 $52$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 83
14 15 16 17$53 $54 $55 $56$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 84
18 19 20 21$57 $58 $59 $60$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 85
22 23 24 25$61 $62 $63 $64$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 86
26 27 28 29$65 $66 $67 $68$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 87
30 31 32 33$69 $70 $71 $72$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 88
34 35 36 37$73 $74 $75 $76$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 89
38 39 40 41$77 $78 $79 $80$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 90
42 43 44 45$81 $82 $83 $84$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 91
46 47 48 49$85 $86 $87 $88$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 92
50 51 52 53$89 $90 $91 $92$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 93
54 55 56 57$93 $94 $95 $96$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 94
58 59 60 61$97 $98 $99 $100$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 95
62 63 64 65$101 $102 $103 $104$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 96
66 67 68 69$105 $106 $107 $108$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 97
70 71 72 73$109 $110 $111 $112$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 98
74 75 76 77$113 $114 $115 $116$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 99
78 79 80 81$117 $118 $119 $120$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 100
82 83 84 85$121 $122 $123 $124$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 101
86 87 88 89$125 $126 $127 $128$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 102
90 91 92 93$129 $130 $131 $132$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 103
94 95 96 97$133 $134 $135 $136$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 104
98 99 100 101$137 $138 $139 $140$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 105
102 103 104 105$141 $142 $143 $144$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 106
106 107 108 109$145 $146 $147 $148$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 107
110 111 112 113$149 $150 $151 $152$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 108
114 115 116 117$153 $154 $155 $156$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 109
118 119 120 121$157 $158 $159 $160$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 110
122 123 124 125$161 $162 $163 $164$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 111
126 127 128 129$165 $166 $167 $168$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 112
130 131 132 133$169 $170 $171 $172$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 113
134 135 136 137$173 $174 $175 $176$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 114
138 139 140 141$177 $178 $179 $180$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 115
142 143 144 145$181 $182 $183 $184$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 116
146 147 148 149$185 $186 $187 $188$0 $0 $0 $0$0 $0 $0 $0$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
6 Sales
Page 117
150$189$0$0$0
$0
$0
$0
$0
top related