$City_1 = Battle Creek, MI
$e =
$City_2 = Kalamazoo-Portage, MI
$e =
function get_years(Array,Battle Creek, MI,) {
1960
Selecting city: Battle Creek, MI
Searching backwards from 2025 for most recent data.
0: Year 2025 not found in data for Battle Creek, MI.
Most recent data for Battle Creek, MI is from 2024.
2024
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
1986
The first year data is available for Battle Creek, MI is : 1986 the most recent year of data is 2024.
return Array
}
function get_years(Array,Kalamazoo-Portage, MI,) {
1960
Selecting city: Kalamazoo-Portage, MI
Searching backwards from 2025 for most recent data.
0: Year 2025 not found in data for Kalamazoo-Portage, MI.
Most recent data for Kalamazoo-Portage, MI is from 2024.
2024
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
1978
The first year data is available for Kalamazoo-Portage, MI is : 1978 the most recent year of data is 2024.
return Array
}

Inputs:

City_1 Battle Creek, MI
City_2 Kalamazoo-Portage, MI
Price 200000
YearStart 1986
QuarterStart 1
YearEnd 2011
QuarterEnd 3

function check_year(Battle Creek, MI,1986):

Data for 1986 is in the $c[Battle Creek, MI] element.

function check_quarter():

function get_years(Array,Battle Creek, MI,) {
1960
Selecting city: Battle Creek, MI
Searching backwards from 2025 for most recent data.
0: Year 2025 not found in data for Battle Creek, MI.
Most recent data for Battle Creek, MI is from 2024.
2024
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
1986
The first year data is available for Battle Creek, MI is : 1986 the most recent year of data is 2024.
return Array
}
Sorry, no data for the 1 quarter in 1986. Searching for first quarter of data.
START $v_year = 2011

function check_year(Battle Creek, MI,2011):

Data for 2011 is in the $c[Battle Creek, MI] element.
END $v_year = 2011

function check_quarter():

Data for the 3 quarter is in the $c[Battle Creek, MI][2011] element.

function check_year(Kalamazoo-Portage, MI,1986):

Data for 1986 is in the $c[Kalamazoo-Portage, MI] element.

function check_quarter():

Data for the 2 quarter is in the $c[Kalamazoo-Portage, MI][1986] element.

function check_year(Kalamazoo-Portage, MI,2011):

Data for 2011 is in the $c[Kalamazoo-Portage, MI] element.

function check_quarter():

Data for the 3 quarter is in the $c[Kalamazoo-Portage, MI][2011] element.

function get_valuation():

Purchase price: $200000
Purchase year: 1986
Purchase quarter: 2
Start price index:64.34
Current price index:140.04
Based on HPI the home has appreciated 117.66% in 25.25 years at an average rate of 4.66% per year.
The current appreciations value is: $435312.4
Evaluation year: 2011
Evaluation quarter: 3
Evaluation period: 25.25 years (101 quarters or 303 months).


Array ( [0] => Battle Creek, MI [1] => 200000 [2] => 1986 [3] => 2 [4] => 2011 [5] => 3 [6] => 25.25 [7] => 101 [8] => 303 [9] => 435312.4 [10] => 1.176562014299 [11] => 0.046596515417784 ) 1
Battle Creek, MI
200000
1986
2
2011
3
25.25
101
303
435312.4
1.176562014299
0.046596515417784
Battle Creek, MI
200000
1986
2
2011
3
25.25
101
303
435312.4
1.176562014299
0.046596515417784
64.34
140.04
p_year=1986 / ycount=1986 / v_year=2011
qcount=2 / qend=4 / v_quarter=3
200000
1986(2) : Array[1986][2] : Value = 200000 (200000 / 200000)
qcount=3 / qend=4 / v_quarter=3
195897
1986(3) : Array[1986][3] : Value = 195897 (195897 / 200000)
qcount=4 / qend=4 / v_quarter=3
206093
1986(4) : Array[1986][4] : Value = 206093 (195897 / 206093)
p_year=1986 / ycount=1987 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
210569
1987(1) : Array[1987][1] : Value = 210569 (195897 / 210569)
qcount=2 / qend=4 / v_quarter=3
207523
1987(2) : Array[1987][2] : Value = 207523 (195897 / 210569)
qcount=3 / qend=4 / v_quarter=3
217687
1987(3) : Array[1987][3] : Value = 217687 (195897 / 217687)
qcount=4 / qend=4 / v_quarter=3
209698
1987(4) : Array[1987][4] : Value = 209698 (195897 / 217687)
p_year=1986 / ycount=1988 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
214672
1988(1) : Array[1988][1] : Value = 214672 (195897 / 217687)
qcount=2 / qend=4 / v_quarter=3
224308
1988(2) : Array[1988][2] : Value = 224308 (195897 / 224308)
qcount=3 / qend=4 / v_quarter=3
229344
1988(3) : Array[1988][3] : Value = 229344 (195897 / 229344)
qcount=4 / qend=4 / v_quarter=3
216475
1988(4) : Array[1988][4] : Value = 216475 (195897 / 229344)
p_year=1986 / ycount=1989 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
234100
1989(1) : Array[1989][1] : Value = 234100 (195897 / 234100)
qcount=2 / qend=4 / v_quarter=3
248586
1989(2) : Array[1989][2] : Value = 248586 (195897 / 248586)
qcount=3 / qend=4 / v_quarter=3
250233
1989(3) : Array[1989][3] : Value = 250233 (195897 / 250233)
qcount=4 / qend=4 / v_quarter=3
248896
1989(4) : Array[1989][4] : Value = 248896 (195897 / 250233)
p_year=1986 / ycount=1990 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
251445
1990(1) : Array[1990][1] : Value = 251445 (195897 / 251445)
qcount=2 / qend=4 / v_quarter=3
251477
1990(2) : Array[1990][2] : Value = 251477 (195897 / 251477)
qcount=3 / qend=4 / v_quarter=3
257787
1990(3) : Array[1990][3] : Value = 257787 (195897 / 257787)
qcount=4 / qend=4 / v_quarter=3
259061
1990(4) : Array[1990][4] : Value = 259061 (195897 / 259061)
p_year=1986 / ycount=1991 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
253217
1991(1) : Array[1991][1] : Value = 253217 (195897 / 259061)
qcount=2 / qend=4 / v_quarter=3
260864
1991(2) : Array[1991][2] : Value = 260864 (195897 / 260864)
qcount=3 / qend=4 / v_quarter=3
268387
1991(3) : Array[1991][3] : Value = 268387 (195897 / 268387)
qcount=4 / qend=4 / v_quarter=3
267920
1991(4) : Array[1991][4] : Value = 267920 (195897 / 268387)
p_year=1986 / ycount=1992 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
272987
1992(1) : Array[1992][1] : Value = 272987 (195897 / 272987)
qcount=2 / qend=4 / v_quarter=3
274790
1992(2) : Array[1992][2] : Value = 274790 (195897 / 274790)
qcount=3 / qend=4 / v_quarter=3
276220
1992(3) : Array[1992][3] : Value = 276220 (195897 / 276220)
qcount=4 / qend=4 / v_quarter=3
280821
1992(4) : Array[1992][4] : Value = 280821 (195897 / 280821)
p_year=1986 / ycount=1993 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
276749
1993(1) : Array[1993][1] : Value = 276749 (195897 / 280821)
qcount=2 / qend=4 / v_quarter=3
280758
1993(2) : Array[1993][2] : Value = 280758 (195897 / 280821)
qcount=3 / qend=4 / v_quarter=3
283432
1993(3) : Array[1993][3] : Value = 283432 (195897 / 283432)
qcount=4 / qend=4 / v_quarter=3
289866
1993(4) : Array[1993][4] : Value = 289866 (195897 / 289866)
p_year=1986 / ycount=1994 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
291265
1994(1) : Array[1994][1] : Value = 291265 (195897 / 291265)
qcount=2 / qend=4 / v_quarter=3
302362
1994(2) : Array[1994][2] : Value = 302362 (195897 / 302362)
qcount=3 / qend=4 / v_quarter=3
305284
1994(3) : Array[1994][3] : Value = 305284 (195897 / 305284)
qcount=4 / qend=4 / v_quarter=3
313149
1994(4) : Array[1994][4] : Value = 313149 (195897 / 313149)
p_year=1986 / ycount=1995 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
310849
1995(1) : Array[1995][1] : Value = 310849 (195897 / 313149)
qcount=2 / qend=4 / v_quarter=3
323966
1995(2) : Array[1995][2] : Value = 323966 (195897 / 323966)
qcount=3 / qend=4 / v_quarter=3
334193
1995(3) : Array[1995][3] : Value = 334193 (195897 / 334193)
qcount=4 / qend=4 / v_quarter=3
335126
1995(4) : Array[1995][4] : Value = 335126 (195897 / 335126)
p_year=1986 / ycount=1996 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
342586
1996(1) : Array[1996][1] : Value = 342586 (195897 / 342586)
qcount=2 / qend=4 / v_quarter=3
348306
1996(2) : Array[1996][2] : Value = 348306 (195897 / 348306)
qcount=3 / qend=4 / v_quarter=3
354554
1996(3) : Array[1996][3] : Value = 354554 (195897 / 354554)
qcount=4 / qend=4 / v_quarter=3
362512
1996(4) : Array[1996][4] : Value = 362512 (195897 / 362512)
p_year=1986 / ycount=1997 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
365403
1997(1) : Array[1997][1] : Value = 365403 (195897 / 365403)
qcount=2 / qend=4 / v_quarter=3
371588
1997(2) : Array[1997][2] : Value = 371588 (195897 / 371588)
qcount=3 / qend=4 / v_quarter=3
377495
1997(3) : Array[1997][3] : Value = 377495 (195897 / 377495)
qcount=4 / qend=4 / v_quarter=3
386136
1997(4) : Array[1997][4] : Value = 386136 (195897 / 386136)
p_year=1986 / ycount=1998 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
393130
1998(1) : Array[1998][1] : Value = 393130 (195897 / 393130)
qcount=2 / qend=4 / v_quarter=3
404352
1998(2) : Array[1998][2] : Value = 404352 (195897 / 404352)
qcount=3 / qend=4 / v_quarter=3
403544
1998(3) : Array[1998][3] : Value = 403544 (195897 / 404352)
qcount=4 / qend=4 / v_quarter=3
405782
1998(4) : Array[1998][4] : Value = 405782 (195897 / 405782)
p_year=1986 / ycount=1999 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
412714
1999(1) : Array[1999][1] : Value = 412714 (195897 / 412714)
qcount=2 / qend=4 / v_quarter=3
414548
1999(2) : Array[1999][2] : Value = 414548 (195897 / 414548)
qcount=3 / qend=4 / v_quarter=3
420329
1999(3) : Array[1999][3] : Value = 420329 (195897 / 420329)
qcount=4 / qend=4 / v_quarter=3
432608
1999(4) : Array[1999][4] : Value = 432608 (195897 / 432608)
p_year=1986 / ycount=2000 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
428070
2000(1) : Array[2000][1] : Value = 428070 (195897 / 432608)
qcount=2 / qend=4 / v_quarter=3
433572
2000(2) : Array[2000][2] : Value = 433572 (195897 / 433572)
qcount=3 / qend=4 / v_quarter=3
440597
2000(3) : Array[2000][3] : Value = 440597 (195897 / 440597)
qcount=4 / qend=4 / v_quarter=3
446348
2000(4) : Array[2000][4] : Value = 446348 (195897 / 446348)
p_year=1986 / ycount=2001 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
456264
2001(1) : Array[2001][1] : Value = 456264 (195897 / 456264)
qcount=2 / qend=4 / v_quarter=3
458875
2001(2) : Array[2001][2] : Value = 458875 (195897 / 458875)
qcount=3 / qend=4 / v_quarter=3
464905
2001(3) : Array[2001][3] : Value = 464905 (195897 / 464905)
qcount=4 / qend=4 / v_quarter=3
469381
2001(4) : Array[2001][4] : Value = 469381 (195897 / 469381)
p_year=1986 / ycount=2002 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
474790
2002(1) : Array[2002][1] : Value = 474790 (195897 / 474790)
qcount=2 / qend=4 / v_quarter=3
479671
2002(2) : Array[2002][2] : Value = 479671 (195897 / 479671)
qcount=3 / qend=4 / v_quarter=3
482592
2002(3) : Array[2002][3] : Value = 482592 (195897 / 482592)
qcount=4 / qend=4 / v_quarter=3
486385
2002(4) : Array[2002][4] : Value = 486385 (195897 / 486385)
p_year=1986 / ycount=2003 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
488654
2003(1) : Array[2003][1] : Value = 488654 (195897 / 488654)
qcount=2 / qend=4 / v_quarter=3
496860
2003(2) : Array[2003][2] : Value = 496860 (195897 / 496860)
qcount=3 / qend=4 / v_quarter=3
503792
2003(3) : Array[2003][3] : Value = 503792 (195897 / 503792)
qcount=4 / qend=4 / v_quarter=3
511004
2003(4) : Array[2003][4] : Value = 511004 (195897 / 511004)
p_year=1986 / ycount=2004 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
517345
2004(1) : Array[2004][1] : Value = 517345 (195897 / 517345)
qcount=2 / qend=4 / v_quarter=3
519956
2004(2) : Array[2004][2] : Value = 519956 (195897 / 519956)
qcount=3 / qend=4 / v_quarter=3
522599
2004(3) : Array[2004][3] : Value = 522599 (195897 / 522599)
qcount=4 / qend=4 / v_quarter=3
533882
2004(4) : Array[2004][4] : Value = 533882 (195897 / 533882)
p_year=1986 / ycount=2005 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
542462
2005(1) : Array[2005][1] : Value = 542462 (195897 / 542462)
qcount=2 / qend=4 / v_quarter=3
535872
2005(2) : Array[2005][2] : Value = 535872 (195897 / 542462)
qcount=3 / qend=4 / v_quarter=3
543736
2005(3) : Array[2005][3] : Value = 543736 (195897 / 543736)
qcount=4 / qend=4 / v_quarter=3
549953
2005(4) : Array[2005][4] : Value = 549953 (195897 / 549953)
p_year=1986 / ycount=2006 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
551010
2006(1) : Array[2006][1] : Value = 551010 (195897 / 551010)
qcount=2 / qend=4 / v_quarter=3
549487
2006(2) : Array[2006][2] : Value = 549487 (195897 / 551010)
qcount=3 / qend=4 / v_quarter=3
544545
2006(3) : Array[2006][3] : Value = 544545 (195897 / 551010)
qcount=4 / qend=4 / v_quarter=3
546130
2006(4) : Array[2006][4] : Value = 546130 (195897 / 551010)
p_year=1986 / ycount=2007 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
547560
2007(1) : Array[2007][1] : Value = 547560 (195897 / 551010)
qcount=2 / qend=4 / v_quarter=3
530650
2007(2) : Array[2007][2] : Value = 530650 (195897 / 551010)
qcount=3 / qend=4 / v_quarter=3
523562
2007(3) : Array[2007][3] : Value = 523562 (195897 / 551010)
qcount=4 / qend=4 / v_quarter=3
516288
2007(4) : Array[2007][4] : Value = 516288 (195897 / 551010)
p_year=1986 / ycount=2008 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
526173
2008(1) : Array[2008][1] : Value = 526173 (195897 / 551010)
qcount=2 / qend=4 / v_quarter=3
508921
2008(2) : Array[2008][2] : Value = 508921 (195897 / 551010)
qcount=3 / qend=4 / v_quarter=3
502704
2008(3) : Array[2008][3] : Value = 502704 (195897 / 551010)
qcount=4 / qend=4 / v_quarter=3
484147
2008(4) : Array[2008][4] : Value = 484147 (195897 / 551010)
p_year=1986 / ycount=2009 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
508269
2009(1) : Array[2009][1] : Value = 508269 (195897 / 551010)
qcount=2 / qend=4 / v_quarter=3
486696
2009(2) : Array[2009][2] : Value = 486696 (195897 / 551010)
qcount=3 / qend=4 / v_quarter=3
451383
2009(3) : Array[2009][3] : Value = 451383 (195897 / 551010)
qcount=4 / qend=4 / v_quarter=3
456854
2009(4) : Array[2009][4] : Value = 456854 (195897 / 551010)
p_year=1986 / ycount=2010 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
448710
2010(1) : Array[2010][1] : Value = 448710 (195897 / 551010)
qcount=2 / qend=4 / v_quarter=3
446658
2010(2) : Array[2010][2] : Value = 446658 (195897 / 551010)
qcount=3 / qend=4 / v_quarter=3
467143
2010(3) : Array[2010][3] : Value = 467143 (195897 / 551010)
qcount=4 / qend=4 / v_quarter=3
458968
2010(4) : Array[2010][4] : Value = 458968 (195897 / 551010)
p_year=1986 / ycount=2011 / v_year=2011

function check_quarter():

Data for the 1 quarter is in the $c[Battle Creek, MI][2011] element.
qcount=1 / qend=3 / v_quarter=3
440037
2011(1) : Array[2011][1] : Value = 440037 (195897 / 551010)
qcount=2 / qend=3 / v_quarter=3
433323
2011(2) : Array[2011][2] : Value = 433323 (195897 / 551010)
qcount=3 / qend=3 / v_quarter=3
435312
2011(3) : Array[2011][3] : Value = 435312 (195897 / 551010)

function get_valuation():

Purchase price: $200000
Purchase year: 1986
Purchase quarter: 2
Start price index:65.78
Current price index:140.11
Based on HPI the home has appreciated 113% in 25.25 years at an average rate of 4.48% per year.
The current appreciations value is: $425995.74
Evaluation year: 2011
Evaluation quarter: 3
Evaluation period: 25.25 years (101 quarters or 303 months).


Kalamazoo-Portage, MI
200000
1986
2
2011
3
25.25
101
303
425995.74
1.1299787169352
0.044751632353871
65.78
140.11
p_year=1986 / ycount=1986 / v_year=2011
qcount=2 / qend=4 / v_quarter=3
200000
1986(2) : Array[1986][2] : Value = 200000 (200000 / 200000)
qcount=3 / qend=4 / v_quarter=3
204591
1986(3) : Array[1986][3] : Value = 204591 (200000 / 204591)
qcount=4 / qend=4 / v_quarter=3
208027
1986(4) : Array[1986][4] : Value = 208027 (200000 / 208027)
p_year=1986 / ycount=1987 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
207327
1987(1) : Array[1987][1] : Value = 207327 (200000 / 208027)
qcount=2 / qend=4 / v_quarter=3
211493
1987(2) : Array[1987][2] : Value = 211493 (200000 / 211493)
qcount=3 / qend=4 / v_quarter=3
217361
1987(3) : Array[1987][3] : Value = 217361 (200000 / 217361)
qcount=4 / qend=4 / v_quarter=3
215233
1987(4) : Array[1987][4] : Value = 215233 (200000 / 217361)
p_year=1986 / ycount=1988 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
223624
1988(1) : Array[1988][1] : Value = 223624 (200000 / 223624)
qcount=2 / qend=4 / v_quarter=3
229796
1988(2) : Array[1988][2] : Value = 229796 (200000 / 229796)
qcount=3 / qend=4 / v_quarter=3
231317
1988(3) : Array[1988][3] : Value = 231317 (200000 / 231317)
qcount=4 / qend=4 / v_quarter=3
231043
1988(4) : Array[1988][4] : Value = 231043 (200000 / 231317)
p_year=1986 / ycount=1989 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
230648
1989(1) : Array[1989][1] : Value = 230648 (200000 / 231317)
qcount=2 / qend=4 / v_quarter=3
237884
1989(2) : Array[1989][2] : Value = 237884 (200000 / 237884)
qcount=3 / qend=4 / v_quarter=3
242718
1989(3) : Array[1989][3] : Value = 242718 (200000 / 242718)
qcount=4 / qend=4 / v_quarter=3
244117
1989(4) : Array[1989][4] : Value = 244117 (200000 / 244117)
p_year=1986 / ycount=1990 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
245333
1990(1) : Array[1990][1] : Value = 245333 (200000 / 245333)
qcount=2 / qend=4 / v_quarter=3
249438
1990(2) : Array[1990][2] : Value = 249438 (200000 / 249438)
qcount=3 / qend=4 / v_quarter=3
253208
1990(3) : Array[1990][3] : Value = 253208 (200000 / 253208)
qcount=4 / qend=4 / v_quarter=3
251140
1990(4) : Array[1990][4] : Value = 251140 (200000 / 253208)
p_year=1986 / ycount=1991 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
258954
1991(1) : Array[1991][1] : Value = 258954 (200000 / 258954)
qcount=2 / qend=4 / v_quarter=3
258711
1991(2) : Array[1991][2] : Value = 258711 (200000 / 258954)
qcount=3 / qend=4 / v_quarter=3
258589
1991(3) : Array[1991][3] : Value = 258589 (200000 / 258954)
qcount=4 / qend=4 / v_quarter=3
264123
1991(4) : Array[1991][4] : Value = 264123 (200000 / 264123)
p_year=1986 / ycount=1992 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
264974
1992(1) : Array[1992][1] : Value = 264974 (200000 / 264974)
qcount=2 / qend=4 / v_quarter=3
266190
1992(2) : Array[1992][2] : Value = 266190 (200000 / 266190)
qcount=3 / qend=4 / v_quarter=3
268623
1992(3) : Array[1992][3] : Value = 268623 (200000 / 268623)
qcount=4 / qend=4 / v_quarter=3
271359
1992(4) : Array[1992][4] : Value = 271359 (200000 / 271359)
p_year=1986 / ycount=1993 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
272697
1993(1) : Array[1993][1] : Value = 272697 (200000 / 272697)
qcount=2 / qend=4 / v_quarter=3
274430
1993(2) : Array[1993][2] : Value = 274430 (200000 / 274430)
qcount=3 / qend=4 / v_quarter=3
278139
1993(3) : Array[1993][3] : Value = 278139 (200000 / 278139)
qcount=4 / qend=4 / v_quarter=3
279112
1993(4) : Array[1993][4] : Value = 279112 (200000 / 279112)
p_year=1986 / ycount=1994 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
282639
1994(1) : Array[1994][1] : Value = 282639 (200000 / 282639)
qcount=2 / qend=4 / v_quarter=3
290787
1994(2) : Array[1994][2] : Value = 290787 (200000 / 290787)
qcount=3 / qend=4 / v_quarter=3
296625
1994(3) : Array[1994][3] : Value = 296625 (200000 / 296625)
qcount=4 / qend=4 / v_quarter=3
300061
1994(4) : Array[1994][4] : Value = 300061 (200000 / 300061)
p_year=1986 / ycount=1995 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
304044
1995(1) : Array[1995][1] : Value = 304044 (200000 / 304044)
qcount=2 / qend=4 / v_quarter=3
309182
1995(2) : Array[1995][2] : Value = 309182 (200000 / 309182)
qcount=3 / qend=4 / v_quarter=3
318942
1995(3) : Array[1995][3] : Value = 318942 (200000 / 318942)
qcount=4 / qend=4 / v_quarter=3
318851
1995(4) : Array[1995][4] : Value = 318851 (200000 / 318942)
p_year=1986 / ycount=1996 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
325327
1996(1) : Array[1996][1] : Value = 325327 (200000 / 325327)
qcount=2 / qend=4 / v_quarter=3
331012
1996(2) : Array[1996][2] : Value = 331012 (200000 / 331012)
qcount=3 / qend=4 / v_quarter=3
337914
1996(3) : Array[1996][3] : Value = 337914 (200000 / 337914)
qcount=4 / qend=4 / v_quarter=3
339739
1996(4) : Array[1996][4] : Value = 339739 (200000 / 339739)
p_year=1986 / ycount=1997 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
346610
1997(1) : Array[1997][1] : Value = 346610 (200000 / 346610)
qcount=2 / qend=4 / v_quarter=3
353086
1997(2) : Array[1997][2] : Value = 353086 (200000 / 353086)
qcount=3 / qend=4 / v_quarter=3
355853
1997(3) : Array[1997][3] : Value = 355853 (200000 / 355853)
qcount=4 / qend=4 / v_quarter=3
361174
1997(4) : Array[1997][4] : Value = 361174 (200000 / 361174)
p_year=1986 / ycount=1998 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
365217
1998(1) : Array[1998][1] : Value = 365217 (200000 / 365217)
qcount=2 / qend=4 / v_quarter=3
369018
1998(2) : Array[1998][2] : Value = 369018 (200000 / 369018)
qcount=3 / qend=4 / v_quarter=3
369960
1998(3) : Array[1998][3] : Value = 369960 (200000 / 369960)
qcount=4 / qend=4 / v_quarter=3
374673
1998(4) : Array[1998][4] : Value = 374673 (200000 / 374673)
p_year=1986 / ycount=1999 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
375646
1999(1) : Array[1999][1] : Value = 375646 (200000 / 375646)
qcount=2 / qend=4 / v_quarter=3
377501
1999(2) : Array[1999][2] : Value = 377501 (200000 / 377501)
qcount=3 / qend=4 / v_quarter=3
385923
1999(3) : Array[1999][3] : Value = 385923 (200000 / 385923)
qcount=4 / qend=4 / v_quarter=3
384555
1999(4) : Array[1999][4] : Value = 384555 (200000 / 385923)
p_year=1986 / ycount=2000 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
392733
2000(1) : Array[2000][1] : Value = 392733 (200000 / 392733)
qcount=2 / qend=4 / v_quarter=3
395014
2000(2) : Array[2000][2] : Value = 395014 (200000 / 395014)
qcount=3 / qend=4 / v_quarter=3
402189
2000(3) : Array[2000][3] : Value = 402189 (200000 / 402189)
qcount=4 / qend=4 / v_quarter=3
403861
2000(4) : Array[2000][4] : Value = 403861 (200000 / 403861)
p_year=1986 / ycount=2001 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
410824
2001(1) : Array[2001][1] : Value = 410824 (200000 / 410824)
qcount=2 / qend=4 / v_quarter=3
416814
2001(2) : Array[2001][2] : Value = 416814 (200000 / 416814)
qcount=3 / qend=4 / v_quarter=3
422134
2001(3) : Array[2001][3] : Value = 422134 (200000 / 422134)
qcount=4 / qend=4 / v_quarter=3
429127
2001(4) : Array[2001][4] : Value = 429127 (200000 / 429127)
p_year=1986 / ycount=2002 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
432898
2002(1) : Array[2002][1] : Value = 432898 (200000 / 432898)
qcount=2 / qend=4 / v_quarter=3
436151
2002(2) : Array[2002][2] : Value = 436151 (200000 / 436151)
qcount=3 / qend=4 / v_quarter=3
441897
2002(3) : Array[2002][3] : Value = 441897 (200000 / 441897)
qcount=4 / qend=4 / v_quarter=3
445303
2002(4) : Array[2002][4] : Value = 445303 (200000 / 445303)
p_year=1986 / ycount=2003 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
446914
2003(1) : Array[2003][1] : Value = 446914 (200000 / 446914)
qcount=2 / qend=4 / v_quarter=3
450745
2003(2) : Array[2003][2] : Value = 450745 (200000 / 450745)
qcount=3 / qend=4 / v_quarter=3
457920
2003(3) : Array[2003][3] : Value = 457920 (200000 / 457920)
qcount=4 / qend=4 / v_quarter=3
464427
2003(4) : Array[2003][4] : Value = 464427 (200000 / 464427)
p_year=1986 / ycount=2004 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
465035
2004(1) : Array[2004][1] : Value = 465035 (200000 / 465035)
qcount=2 / qend=4 / v_quarter=3
467407
2004(2) : Array[2004][2] : Value = 467407 (200000 / 467407)
qcount=3 / qend=4 / v_quarter=3
474308
2004(3) : Array[2004][3] : Value = 474308 (200000 / 474308)
qcount=4 / qend=4 / v_quarter=3
482974
2004(4) : Array[2004][4] : Value = 482974 (200000 / 482974)
p_year=1986 / ycount=2005 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
484433
2005(1) : Array[2005][1] : Value = 484433 (200000 / 484433)
qcount=2 / qend=4 / v_quarter=3
487200
2005(2) : Array[2005][2] : Value = 487200 (200000 / 487200)
qcount=3 / qend=4 / v_quarter=3
493676
2005(3) : Array[2005][3] : Value = 493676 (200000 / 493676)
qcount=4 / qend=4 / v_quarter=3
493129
2005(4) : Array[2005][4] : Value = 493129 (200000 / 493676)
p_year=1986 / ycount=2006 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
494558
2006(1) : Array[2006][1] : Value = 494558 (200000 / 494558)
qcount=2 / qend=4 / v_quarter=3
490818
2006(2) : Array[2006][2] : Value = 490818 (200000 / 494558)
qcount=3 / qend=4 / v_quarter=3
486804
2006(3) : Array[2006][3] : Value = 486804 (200000 / 494558)
qcount=4 / qend=4 / v_quarter=3
489967
2006(4) : Array[2006][4] : Value = 489967 (200000 / 494558)
p_year=1986 / ycount=2007 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
490818
2007(1) : Array[2007][1] : Value = 490818 (200000 / 494558)
qcount=2 / qend=4 / v_quarter=3
486713
2007(2) : Array[2007][2] : Value = 486713 (200000 / 494558)
qcount=3 / qend=4 / v_quarter=3
480906
2007(3) : Array[2007][3] : Value = 480906 (200000 / 494558)
qcount=4 / qend=4 / v_quarter=3
478382
2007(4) : Array[2007][4] : Value = 478382 (200000 / 494558)
p_year=1986 / ycount=2008 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
482031
2008(1) : Array[2008][1] : Value = 482031 (200000 / 494558)
qcount=2 / qend=4 / v_quarter=3
462755
2008(2) : Array[2008][2] : Value = 462755 (200000 / 494558)
qcount=3 / qend=4 / v_quarter=3
452600
2008(3) : Array[2008][3] : Value = 452600 (200000 / 494558)
qcount=4 / qend=4 / v_quarter=3
453968
2008(4) : Array[2008][4] : Value = 453968 (200000 / 494558)
p_year=1986 / ycount=2009 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
464214
2009(1) : Array[2009][1] : Value = 464214 (200000 / 494558)
qcount=2 / qend=4 / v_quarter=3
455458
2009(2) : Array[2009][2] : Value = 455458 (200000 / 494558)
qcount=3 / qend=4 / v_quarter=3
441472
2009(3) : Array[2009][3] : Value = 441472 (200000 / 494558)
qcount=4 / qend=4 / v_quarter=3
439465
2009(4) : Array[2009][4] : Value = 439465 (200000 / 494558)
p_year=1986 / ycount=2010 / v_year=2011
qcount=1 / qend=4 / v_quarter=3
434813
2010(1) : Array[2010][1] : Value = 434813 (200000 / 494558)
qcount=2 / qend=4 / v_quarter=3
431286
2010(2) : Array[2010][2] : Value = 431286 (200000 / 494558)
qcount=3 / qend=4 / v_quarter=3
434691
2010(3) : Array[2010][3] : Value = 434691 (200000 / 494558)
qcount=4 / qend=4 / v_quarter=3
433506
2010(4) : Array[2010][4] : Value = 433506 (200000 / 494558)
p_year=1986 / ycount=2011 / v_year=2011

function check_quarter():

Data for the 1 quarter is in the $c[Kalamazoo-Portage, MI][2011] element.
qcount=1 / qend=3 / v_quarter=3
424141
2011(1) : Array[2011][1] : Value = 424141 (200000 / 494558)
qcount=2 / qend=3 / v_quarter=3
422104
2011(2) : Array[2011][2] : Value = 422104 (200000 / 494558)
qcount=3 / qend=3 / v_quarter=3
425996
2011(3) : Array[2011][3] : Value = 425996 (200000 / 494558)
HomePriceGraph.com+++++++++++++++++Price+appreciation+in+Battle+Creek%2C+MI+for+years+1986+to+2011++++++++++++++++++++++++++++++++++++++++++++++++++%7CTotal+appreciation+%3D+%24235%2C312%28117.66%25%29+++Start%3A+%24200%2C000+End%3A+%24435%2C312
t:200000,195897,206093,210569,207523,217687,209698,214672,224308,229344,216475,234100,248586,250233,248896,251445,251477,257787,259061,253217,260864,268387,267920,272987,274790,276220,280821,276749,280758,283432,289866,291265,302362,305284,313149,310849,323966,334193,335126,342586,348306,354554,362512,365403,371588,377495,386136,393130,404352,403544,405782,412714,414548,420329,432608,428070,433572,440597,446348,456264,458875,464905,469381,474790,479671,482592,486385,488654,496860,503792,511004,517345,519956,522599,533882,542462,535872,543736,549953,551010,549487,544545,546130,547560,530650,523562,516288,526173,508921,502704,484147,508269,486696,451383,456854,448710,446658,467143,458968,440037,433323,435312|200000,204591,208027,207327,211493,217361,215233,223624,229796,231317,231043,230648,237884,242718,244117,245333,249438,253208,251140,258954,258711,258589,264123,264974,266190,268623,271359,272697,274430,278139,279112,282639,290787,296625,300061,304044,309182,318942,318851,325327,331012,337914,339739,346610,353086,355853,361174,365217,369018,369960,374673,375646,377501,385923,384555,392733,395014,402189,403861,410824,416814,422134,429127,432898,436151,441897,445303,446914,450745,457920,464427,465035,467407,474308,482974,484433,487200,493676,493129,494558,490818,486804,489967,490818,486713,480906,478382,482031,462755,452600,453968,464214,455458,441472,439465,434813,431286,434691,433506,424141,422104,425996
|||87||||88||||89||||90||||91||||92||||93||||94||||95||||96||||97||||98||||99||||00||||01||||02||||03||||04||||05||||06||||07||||08||||09||||10||||11|||
180000
570000
100000
180000
570000
Battle Creek, MI|Kalamazoo-Portage, MI
1
79
1986
2006
3
1
195897
551010

function graph():

post_chtt HomePriceGraph.com Price appreciation in Battle Creek, MI for years 1986 to 2011 |Total appreciation = $235,312(117.66%) Start: $200,000 End: $435,312
post_cht ls
post_chd t:200000,195897,206093,210569,207523,217687,209698,214672,224308,229344,216475,234100,248586,250233,248896,251445,251477,257787,259061,253217,260864,268387,267920,272987,274790,276220,280821,276749,280758,283432,289866,291265,302362,305284,313149,310849,323966,334193,335126,342586,348306,354554,362512,365403,371588,377495,386136,393130,404352,403544,405782,412714,414548,420329,432608,428070,433572,440597,446348,456264,458875,464905,469381,474790,479671,482592,486385,488654,496860,503792,511004,517345,519956,522599,533882,542462,535872,543736,549953,551010,549487,544545,546130,547560,530650,523562,516288,526173,508921,502704,484147,508269,486696,451383,456854,448710,446658,467143,458968,440037,433323,435312|200000,204591,208027,207327,211493,217361,215233,223624,229796,231317,231043,230648,237884,242718,244117,245333,249438,253208,251140,258954,258711,258589,264123,264974,266190,268623,271359,272697,274430,278139,279112,282639,290787,296625,300061,304044,309182,318942,318851,325327,331012,337914,339739,346610,353086,355853,361174,365217,369018,369960,374673,375646,377501,385923,384555,392733,395014,402189,403861,410824,416814,422134,429127,432898,436151,441897,445303,446914,450745,457920,464427,465035,467407,474308,482974,484433,487200,493676,493129,494558,490818,486804,489967,490818,486713,480906,478382,482031,462755,452600,453968,464214,455458,441472,439465,434813,431286,434691,433506,424141,422104,425996
post_chl |||87||||88||||89||||90||||91||||92||||93||||94||||95||||96||||97||||98||||99||||00||||01||||02||||03||||04||||05||||06||||07||||08||||09||||10||||11|||
post_chxl
post_chbh a
post_chco 3972cc,cccccc
post_chs 800x375
post_chdl Battle Creek, MI|Kalamazoo-Portage, MI
post_chxt x,y
post_chxr 1,180000,570000,100000
post_chxs 1,0000DD,18,0,lt,0000DD|2,0000DD,0,l
post_chxtc 1,-800|2,-800
post_chds 180000,570000
post_chf
http://chart.apis.google.com/chart?chid=1e912a6e54acaeb841b7e65bba8c5b30+chtt=HomePriceGraph.com+++++++++++++++++Price+appreciation+in+Battle+Creek%2C+MI+for+years+1986+to+2011++++++++++++++++++++++++++++++++++++++++++++++++++%7CTotal+appreciation+%3D+%24235%2C312%28117.66%25%29+++Start%3A+%24200%2C000+End%3A+%24435%2C312&cht=ls&chd=t%3A200000%2C195897%2C206093%2C210569%2C207523%2C217687%2C209698%2C214672%2C224308%2C229344%2C216475%2C234100%2C248586%2C250233%2C248896%2C251445%2C251477%2C257787%2C259061%2C253217%2C260864%2C268387%2C267920%2C272987%2C274790%2C276220%2C280821%2C276749%2C280758%2C283432%2C289866%2C291265%2C302362%2C305284%2C313149%2C310849%2C323966%2C334193%2C335126%2C342586%2C348306%2C354554%2C362512%2C365403%2C371588%2C377495%2C386136%2C393130%2C404352%2C403544%2C405782%2C412714%2C414548%2C420329%2C432608%2C428070%2C433572%2C440597%2C446348%2C456264%2C458875%2C464905%2C469381%2C474790%2C479671%2C482592%2C486385%2C488654%2C496860%2C503792%2C511004%2C517345%2C519956%2C522599%2C533882%2C542462%2C535872%2C543736%2C549953%2C551010%2C549487%2C544545%2C546130%2C547560%2C530650%2C523562%2C516288%2C526173%2C508921%2C502704%2C484147%2C508269%2C486696%2C451383%2C456854%2C448710%2C446658%2C467143%2C458968%2C440037%2C433323%2C435312%7C200000%2C204591%2C208027%2C207327%2C211493%2C217361%2C215233%2C223624%2C229796%2C231317%2C231043%2C230648%2C237884%2C242718%2C244117%2C245333%2C249438%2C253208%2C251140%2C258954%2C258711%2C258589%2C264123%2C264974%2C266190%2C268623%2C271359%2C272697%2C274430%2C278139%2C279112%2C282639%2C290787%2C296625%2C300061%2C304044%2C309182%2C318942%2C318851%2C325327%2C331012%2C337914%2C339739%2C346610%2C353086%2C355853%2C361174%2C365217%2C369018%2C369960%2C374673%2C375646%2C377501%2C385923%2C384555%2C392733%2C395014%2C402189%2C403861%2C410824%2C416814%2C422134%2C429127%2C432898%2C436151%2C441897%2C445303%2C446914%2C450745%2C457920%2C464427%2C465035%2C467407%2C474308%2C482974%2C484433%2C487200%2C493676%2C493129%2C494558%2C490818%2C486804%2C489967%2C490818%2C486713%2C480906%2C478382%2C482031%2C462755%2C452600%2C453968%2C464214%2C455458%2C441472%2C439465%2C434813%2C431286%2C434691%2C433506%2C424141%2C422104%2C425996&chl=%7C%7C%7C87%7C%7C%7C%7C88%7C%7C%7C%7C89%7C%7C%7C%7C90%7C%7C%7C%7C91%7C%7C%7C%7C92%7C%7C%7C%7C93%7C%7C%7C%7C94%7C%7C%7C%7C95%7C%7C%7C%7C96%7C%7C%7C%7C97%7C%7C%7C%7C98%7C%7C%7C%7C99%7C%7C%7C%7C00%7C%7C%7C%7C01%7C%7C%7C%7C02%7C%7C%7C%7C03%7C%7C%7C%7C04%7C%7C%7C%7C05%7C%7C%7C%7C06%7C%7C%7C%7C07%7C%7C%7C%7C08%7C%7C%7C%7C09%7C%7C%7C%7C10%7C%7C%7C%7C11%7C%7C%7C&chbh=a&chco=3972cc%2Ccccccc&chs=800x375&chxt=x%2Cy&chxr=1%2C180000%2C570000%2C100000&chxs=1%2C0000DD%2C18%2C0%2Clt%2C0000DD%7C2%2C0000DD%2C0%2Cl&chxtc=1%2C-800%7C2%2C-800&chds=180000%2C570000&chdl=Battle+Creek%2C+MI%7CKalamazoo-Portage%2C+MI&chdlp=b&chm=tLOW+%3A+%24195%5C%2C897+in+1986%2C3972dd%2C0%2C1%2C16%2C%2Cl%3A%3A-10%7CtHIGH+%3A+%24551%5C%2C010+in+2006%2C3972dd%2C0%2C79%2C16%2C%2Cl%3A%3A1&chma=70%2C30%2C30%2C30DEBUGGING so... exiting before image dump...