calculate gla adjustment -- open office

117
3 Sales Page 1 1 GLA Sale Price Adj / Sq.Ft. $40 Sale 1 $0 Sale 2 $0 Sale 3 $0 Subject Max-Min $0 Auto Min Amt $0 Adj Amt / Ft Fill in GLA and Sale Prices of Comparables (Column B & D Minimum amount will automatically show-up in Yellow Squa At that point you can move Right to see Adjustment you n For your own records, if you save this spreadsheet with You can change intitial adjustment at BLUE number in G2

Upload: lexar2011

Post on 25-Nov-2014

27 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 2: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 3: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 4: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 5: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 6: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 7: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 8: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 9: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 10: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 11: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 12: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 13: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 14: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 15: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 16: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 17: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 18: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 19: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 20: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 21: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 22: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 23: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 24: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 25: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 26: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 27: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 28: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 29: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 30: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 31: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 32: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 33: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 34: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 35: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 36: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 37: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 38: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 39: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 40: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 41: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 42: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 43: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 44: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 45: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 46: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 47: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 48: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 49: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 50: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 51: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 52: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 53: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 54: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 55: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 56: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 57: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 58: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 59: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 60: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 61: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 62: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 63: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 64: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 65: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 66: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 67: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 68: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 69: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 70: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 71: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 72: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 73: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 74: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 75: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 76: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 77: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 78: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 79: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 80: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 81: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 82: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 83: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 84: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 85: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 86: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 87: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 88: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 89: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 90: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 91: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 92: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 93: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 94: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 95: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 96: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 97: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 98: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 99: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 100: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 101: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 102: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 103: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 104: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 105: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 106: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 107: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 108: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 109: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 110: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 111: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 112: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 113: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 114: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 115: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 116: CALCULATE GLA ADJUSTMENT -- Open Office

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

Page 117: CALCULATE GLA ADJUSTMENT -- Open Office

6 Sales

Page 117

150$189$0$0$0

$0

$0

$0

$0