Skip to content

Instantly share code, notes, and snippets.

@espinielli
Last active October 5, 2016 14:10
Show Gist options
  • Save espinielli/4d6f69898852877e39334a1f01277d4d to your computer and use it in GitHub Desktop.
Save espinielli/4d6f69898852877e39334a1f01277d4d to your computer and use it in GitHub Desktop.
STATFOR Forecast
license: mit
height: 900
scrolling: no
border: no
budgetYear forecastYear actual forecast value type
1990 1990 1437937 93804 actual
1990 1990 1437937 1431140 -6797 forecast
1990 1991 1521951 1506100 -15851 forecast
1990 1992 1671557 1588540 -83017 forecast
1990 1993 1754912 1675180 -79732 forecast
1990 1994 1830726 1764740 -65986 forecast
1990 1995 1954810 1859840 -94970 forecast
1990 1996 2070688 1960710 -109978 forecast
1991 1991 1521951 84014 actual
1991 1991 1521951 1527515 5564 forecast
1991 1992 1671557 1631295 -40262 forecast
1991 1993 1754912 1707855 -47057 forecast
1991 1994 1830726 1788255 -42471 forecast
1991 1995 1954810 1872045 -82765 forecast
1991 1996 2070688 1961115 -109573 forecast
1991 1997 2172571 2053745 -118826 forecast
1992 1992 1671557 149606 actual
1992 1992 1671557 1621220 -50337 forecast
1992 1993 1754912 1703830 -51082 forecast
1992 1994 1830726 1790720 -40006 forecast
1992 1995 1954810 1882070 -72740 forecast
1992 1996 2070688 1969830 -100858 forecast
1992 1997 2172571 2062010 -110561 forecast
1992 1998 2354379 2159680 -194699 forecast
1993 1993 1754912 83355 actual
1993 1993 1754912 1760870 5958 forecast
1993 1994 1830726 1841980 11254 forecast
1993 1995 1954810 1928660 -26150 forecast
1993 1996 2070688 2019520 -51168 forecast
1993 1997 2172571 2115010 -57561 forecast
1993 1998 2354379 2216510 -137869 forecast
1993 1999 2479025 2322460 -156565 forecast
1994 1994 1830726 75814 actual
1994 1994 1830726 1829605 -1121 forecast
1994 1995 1954810 1906715 -48095 forecast
1994 1996 2070688 1983415 -87273 forecast
1994 1997 2172571 2064925 -107646 forecast
1994 1998 2354379 2152285 -202094 forecast
1994 1999 2479025 2243525 -235500 forecast
1994 2000 2628678 2340155 -288523 forecast
1995 1995 1954810 124084 actual
1995 1995 1954810 1919920 -34890 forecast
1995 1996 2070688 2004710 -65978 forecast
1995 1997 2172571 2096100 -76471 forecast
1995 1998 2354379 2191670 -162709 forecast
1995 1999 2479025 2293100 -185925 forecast
1995 2000 2628678 2399770 -228908 forecast
1995 2001 2541125 2499950 -41175 forecast
1996 1996 2070688 115878 actual
1996 1996 2070688 2043880 -26808 forecast
1996 1997 2172571 2134840 -37731 forecast
1996 1998 2354379 2226300 -128079 forecast
1996 1999 2479025 2324160 -154865 forecast
1996 2000 2628678 2428410 -200268 forecast
1996 2001 2541125 2512960 -28165 forecast
1996 2002 2474730 2602900 128170 forecast
1997 1997 2172571 101883 actual
1997 1997 2172571 2193445 20874 forecast
1997 1998 2354379 2313755 -40624 forecast
1997 1999 2479025 2442075 -36950 forecast
1997 2000 2628678 2576545 -52133 forecast
1997 2001 2541125 2688735 147610 forecast
1997 2002 2474730 2804495 329765 forecast
1997 2003 2547057 2922295 375238 forecast
1998 1998 2354379 181808 actual
1998 1998 2354379 2279220 -75159 forecast
1998 1999 2479025 2384320 -94705 forecast
1998 2000 2628678 2498560 -130118 forecast
1998 2001 2541125 2622690 81565 forecast
1998 2002 2474730 2757800 283070 forecast
1998 2003 2547057 2905300 358243 forecast
1998 2004 2711843 3066090 354247 forecast
1999 1999 2479025 124646 actual
1999 1999 2479025 2477805 -1220 forecast
1999 2000 2628678 2621575 -7103 forecast
1999 2001 2541125 2790875 249750 forecast
1999 2002 2474730 2939015 464285 forecast
1999 2003 2547057 3082135 535078 forecast
1999 2004 2711843 3233855 522012 forecast
1999 2005 2851707 3363345 511638 forecast
2000 2000 2628678 149653 actual
2000 2000 2628678 2651200 22522 forecast
2000 2001 2541125 2807510 266385 forecast
2000 2002 2474730 2977040 502310 forecast
2000 2003 2547057 3149890 602833 forecast
2000 2004 2711843 3315860 604017 forecast
2000 2005 2851707 3467780 616073 forecast
2000 2006 2971116 3584890 613774 forecast
2001 2001 2541125 -38246 actual
2001 2001 2541125 2646535 105410 forecast
2001 2002 2474730 2756845 282115 forecast
2001 2003 2547057 2888555 341498 forecast
2001 2004 2711843 3005705 293862 forecast
2001 2005 2851707 3125895 274188 forecast
2001 2006 2971116 3244075 272959 forecast
2001 2007 3107628 3360095 252467 forecast
2002 2002 2474730 -66395 actual
2002 2002 2474730 2527850 53120 forecast
2002 2003 2547057 2638832 91775 forecast
2002 2004 2711843 2759556 47713 forecast
2002 2005 2851707 2846473 -5234 forecast
2002 2006 2971116 2936938 -34178 forecast
2002 2007 3107628 3036513 -71115 forecast
2002 2008 3150924 3142342 -8582 forecast
2003 2003 2547057 72327 actual
2003 2003 2547057 2524482 -22575 forecast
2003 2004 2711843 2628226 -83617 forecast
2003 2005 2851707 2728010 -123697 forecast
2003 2006 2971116 2842681 -128435 forecast
2003 2007 3107628 2943541 -164087 forecast
2003 2008 3150924 3055257 -95667 forecast
2003 2009 2930100 3166835 236735 forecast
2004 2004 2711843 158441 actual
2004 2004 2711843 2622999 -88844 forecast
2004 2005 2851707 2705527 -146180 forecast
2004 2006 2971116 2773303 -197813 forecast
2004 2007 3107628 2867270 -240358 forecast
2004 2008 3150924 2950322 -200602 forecast
2004 2009 2930100 3029369 99269 forecast
2004 2010 2980761 3119204 138443 forecast
2005 2005 2851707 139864 actual
2005 2005 2851707 2833171 -18536 forecast
2005 2006 2971116 2929890 -41226 forecast
2005 2007 3107628 3013753 -93875 forecast
2005 2008 3150924 3092996 -57928 forecast
2005 2009 2930100 3168364 238264 forecast
2005 2010 2980761 3292190 311429 forecast
2005 2011 3077567 3394422 316855 forecast
2006 2006 2971116 119409 actual
2006 2006 2971116 2950557 -20559 forecast
2006 2007 3107628 3045884 -61744 forecast
2006 2008 3150924 3129785 -21139 forecast
2006 2009 2930100 3230948 300848 forecast
2006 2010 2980761 3353712 372951 forecast
2006 2011 3077567 3456617 379050 forecast
2006 2012 3017636 3562090 544454 forecast
2007 2007 3107628 136512 actual
2007 2007 3107628 3077218 -30410 forecast
2007 2008 3150924 3181335 30411 forecast
2007 2009 2930100 3283437 353337 forecast
2007 2010 2980761 3377868 397107 forecast
2007 2011 3077567 3515435 437868 forecast
2007 2012 3017636 3628142 610506 forecast
2007 2013 2990043 3739529 749486 forecast
2008 2008 3150924 43296 actual
2008 2008 3150924 3227284 76360 forecast
2008 2009 2930100 3360937 430837 forecast
2008 2010 2980761 3480588 499827 forecast
2008 2011 3077567 3587958 510391 forecast
2008 2012 3017636 3750415 732779 forecast
2008 2013 2990043 3864513 874470 forecast
2008 2014 3030019 3977226 947207 forecast
2009 2009 2930100 -220824 actual
2009 2009 2930100 2994009 63909 forecast
2009 2010 2980761 3044531 63770 forecast
2009 2011 3077567 3149288 71721 forecast
2009 2012 3017636 3281071 263435 forecast
2009 2013 2990043 3381186 391143 forecast
2009 2014 3030019 3493749 463730 forecast
2009 2015 3080476 3604966 524490 forecast
2010 2010 2980761 50661 actual
2010 2010 2980761 2961934 -18827 forecast
2010 2011 3077567 3059759 -17808 forecast
2010 2012 3017636 3165885 148249 forecast
2010 2013 2990043 3256675 266632 forecast
2010 2014 3030019 3356861 326842 forecast
2010 2015 3080476 3454204 373728 forecast
2011 2011 3077567 96806 actual
2011 2011 3077567 3124057 46490 forecast
2011 2012 3017636 3240186 222550 forecast
2011 2013 2990043 3313221 323178 forecast
2011 2014 3030019 3397430 367411 forecast
2011 2015 3080476 3481246 400770 forecast
2012 2012 3017636 -59931 actual
2012 2012 3017636 3041017 23381 forecast
2012 2013 2990043 3081990 91947 forecast
2012 2014 3030019 3167441 137422 forecast
2012 2015 3080476 3255219 174743 forecast
2013 2013 2990043 -27593 actual
2013 2013 2990043 2965471 -24572 forecast
2013 2014 3030019 3050685 20666 forecast
2013 2015 3080476 3135541 55065 forecast
2014 2014 3030019 39976 actual
2014 2014 3030019 2988686 -41333 forecast
2014 2015 3080476 3056360 -24116 forecast
2015 2015 3080476 50457 actual
2015 2015 3080476 3058723 -21753 forecast
[
{
"budgetYear": 1990,
"forecastYear": 1990,
"actual": 1437937,
"forecast": "",
"value": 93804,
"type": "actual"
},
{
"budgetYear": 1990,
"forecastYear": 1990,
"actual": 1437937,
"forecast": 1431140,
"value": -6797,
"type": "forecast"
},
{
"budgetYear": 1990,
"forecastYear": 1991,
"actual": 1521951,
"forecast": 1506100,
"value": -15851,
"type": "forecast"
},
{
"budgetYear": 1990,
"forecastYear": 1992,
"actual": 1671557,
"forecast": 1588540,
"value": -83017,
"type": "forecast"
},
{
"budgetYear": 1990,
"forecastYear": 1993,
"actual": 1754912,
"forecast": 1675180,
"value": -79732,
"type": "forecast"
},
{
"budgetYear": 1990,
"forecastYear": 1994,
"actual": 1830726,
"forecast": 1764740,
"value": -65986,
"type": "forecast"
},
{
"budgetYear": 1990,
"forecastYear": 1995,
"actual": 1954810,
"forecast": 1859840,
"value": -94970,
"type": "forecast"
},
{
"budgetYear": 1990,
"forecastYear": 1996,
"actual": 2070688,
"forecast": 1960710,
"value": -109978,
"type": "forecast"
},
{
"budgetYear": 1991,
"forecastYear": 1991,
"actual": 1521951,
"forecast": "",
"value": 84014,
"type": "actual"
},
{
"budgetYear": 1991,
"forecastYear": 1991,
"actual": 1521951,
"forecast": 1527515,
"value": 5564,
"type": "forecast"
},
{
"budgetYear": 1991,
"forecastYear": 1992,
"actual": 1671557,
"forecast": 1631295,
"value": -40262,
"type": "forecast"
},
{
"budgetYear": 1991,
"forecastYear": 1993,
"actual": 1754912,
"forecast": 1707855,
"value": -47057,
"type": "forecast"
},
{
"budgetYear": 1991,
"forecastYear": 1994,
"actual": 1830726,
"forecast": 1788255,
"value": -42471,
"type": "forecast"
},
{
"budgetYear": 1991,
"forecastYear": 1995,
"actual": 1954810,
"forecast": 1872045,
"value": -82765,
"type": "forecast"
},
{
"budgetYear": 1991,
"forecastYear": 1996,
"actual": 2070688,
"forecast": 1961115,
"value": -109573,
"type": "forecast"
},
{
"budgetYear": 1991,
"forecastYear": 1997,
"actual": 2172571,
"forecast": 2053745,
"value": -118826,
"type": "forecast"
},
{
"budgetYear": 1992,
"forecastYear": 1992,
"actual": 1671557,
"forecast": "",
"value": 149606,
"type": "actual"
},
{
"budgetYear": 1992,
"forecastYear": 1992,
"actual": 1671557,
"forecast": 1621220,
"value": -50337,
"type": "forecast"
},
{
"budgetYear": 1992,
"forecastYear": 1993,
"actual": 1754912,
"forecast": 1703830,
"value": -51082,
"type": "forecast"
},
{
"budgetYear": 1992,
"forecastYear": 1994,
"actual": 1830726,
"forecast": 1790720,
"value": -40006,
"type": "forecast"
},
{
"budgetYear": 1992,
"forecastYear": 1995,
"actual": 1954810,
"forecast": 1882070,
"value": -72740,
"type": "forecast"
},
{
"budgetYear": 1992,
"forecastYear": 1996,
"actual": 2070688,
"forecast": 1969830,
"value": -100858,
"type": "forecast"
},
{
"budgetYear": 1992,
"forecastYear": 1997,
"actual": 2172571,
"forecast": 2062010,
"value": -110561,
"type": "forecast"
},
{
"budgetYear": 1992,
"forecastYear": 1998,
"actual": 2354379,
"forecast": 2159680,
"value": -194699,
"type": "forecast"
},
{
"budgetYear": 1993,
"forecastYear": 1993,
"actual": 1754912,
"forecast": "",
"value": 83355,
"type": "actual"
},
{
"budgetYear": 1993,
"forecastYear": 1993,
"actual": 1754912,
"forecast": 1760870,
"value": 5958,
"type": "forecast"
},
{
"budgetYear": 1993,
"forecastYear": 1994,
"actual": 1830726,
"forecast": 1841980,
"value": 11254,
"type": "forecast"
},
{
"budgetYear": 1993,
"forecastYear": 1995,
"actual": 1954810,
"forecast": 1928660,
"value": -26150,
"type": "forecast"
},
{
"budgetYear": 1993,
"forecastYear": 1996,
"actual": 2070688,
"forecast": 2019520,
"value": -51168,
"type": "forecast"
},
{
"budgetYear": 1993,
"forecastYear": 1997,
"actual": 2172571,
"forecast": 2115010,
"value": -57561,
"type": "forecast"
},
{
"budgetYear": 1993,
"forecastYear": 1998,
"actual": 2354379,
"forecast": 2216510,
"value": -137869,
"type": "forecast"
},
{
"budgetYear": 1993,
"forecastYear": 1999,
"actual": 2479025,
"forecast": 2322460,
"value": -156565,
"type": "forecast"
},
{
"budgetYear": 1994,
"forecastYear": 1994,
"actual": 1830726,
"forecast": "",
"value": 75814,
"type": "actual"
},
{
"budgetYear": 1994,
"forecastYear": 1994,
"actual": 1830726,
"forecast": 1829605,
"value": -1121,
"type": "forecast"
},
{
"budgetYear": 1994,
"forecastYear": 1995,
"actual": 1954810,
"forecast": 1906715,
"value": -48095,
"type": "forecast"
},
{
"budgetYear": 1994,
"forecastYear": 1996,
"actual": 2070688,
"forecast": 1983415,
"value": -87273,
"type": "forecast"
},
{
"budgetYear": 1994,
"forecastYear": 1997,
"actual": 2172571,
"forecast": 2064925,
"value": -107646,
"type": "forecast"
},
{
"budgetYear": 1994,
"forecastYear": 1998,
"actual": 2354379,
"forecast": 2152285,
"value": -202094,
"type": "forecast"
},
{
"budgetYear": 1994,
"forecastYear": 1999,
"actual": 2479025,
"forecast": 2243525,
"value": -235500,
"type": "forecast"
},
{
"budgetYear": 1994,
"forecastYear": 2000,
"actual": 2628678,
"forecast": 2340155,
"value": -288523,
"type": "forecast"
},
{
"budgetYear": 1995,
"forecastYear": 1995,
"actual": 1954810,
"forecast": "",
"value": 124084,
"type": "actual"
},
{
"budgetYear": 1995,
"forecastYear": 1995,
"actual": 1954810,
"forecast": 1919920,
"value": -34890,
"type": "forecast"
},
{
"budgetYear": 1995,
"forecastYear": 1996,
"actual": 2070688,
"forecast": 2004710,
"value": -65978,
"type": "forecast"
},
{
"budgetYear": 1995,
"forecastYear": 1997,
"actual": 2172571,
"forecast": 2096100,
"value": -76471,
"type": "forecast"
},
{
"budgetYear": 1995,
"forecastYear": 1998,
"actual": 2354379,
"forecast": 2191670,
"value": -162709,
"type": "forecast"
},
{
"budgetYear": 1995,
"forecastYear": 1999,
"actual": 2479025,
"forecast": 2293100,
"value": -185925,
"type": "forecast"
},
{
"budgetYear": 1995,
"forecastYear": 2000,
"actual": 2628678,
"forecast": 2399770,
"value": -228908,
"type": "forecast"
},
{
"budgetYear": 1995,
"forecastYear": 2001,
"actual": 2541125,
"forecast": 2499950,
"value": -41175,
"type": "forecast"
},
{
"budgetYear": 1996,
"forecastYear": 1996,
"actual": 2070688,
"forecast": "",
"value": 115878,
"type": "actual"
},
{
"budgetYear": 1996,
"forecastYear": 1996,
"actual": 2070688,
"forecast": 2043880,
"value": -26808,
"type": "forecast"
},
{
"budgetYear": 1996,
"forecastYear": 1997,
"actual": 2172571,
"forecast": 2134840,
"value": -37731,
"type": "forecast"
},
{
"budgetYear": 1996,
"forecastYear": 1998,
"actual": 2354379,
"forecast": 2226300,
"value": -128079,
"type": "forecast"
},
{
"budgetYear": 1996,
"forecastYear": 1999,
"actual": 2479025,
"forecast": 2324160,
"value": -154865,
"type": "forecast"
},
{
"budgetYear": 1996,
"forecastYear": 2000,
"actual": 2628678,
"forecast": 2428410,
"value": -200268,
"type": "forecast"
},
{
"budgetYear": 1996,
"forecastYear": 2001,
"actual": 2541125,
"forecast": 2512960,
"value": -28165,
"type": "forecast"
},
{
"budgetYear": 1996,
"forecastYear": 2002,
"actual": 2474730,
"forecast": 2602900,
"value": 128170,
"type": "forecast"
},
{
"budgetYear": 1997,
"forecastYear": 1997,
"actual": 2172571,
"forecast": "",
"value": 101883,
"type": "actual"
},
{
"budgetYear": 1997,
"forecastYear": 1997,
"actual": 2172571,
"forecast": 2193445,
"value": 20874,
"type": "forecast"
},
{
"budgetYear": 1997,
"forecastYear": 1998,
"actual": 2354379,
"forecast": 2313755,
"value": -40624,
"type": "forecast"
},
{
"budgetYear": 1997,
"forecastYear": 1999,
"actual": 2479025,
"forecast": 2442075,
"value": -36950,
"type": "forecast"
},
{
"budgetYear": 1997,
"forecastYear": 2000,
"actual": 2628678,
"forecast": 2576545,
"value": -52133,
"type": "forecast"
},
{
"budgetYear": 1997,
"forecastYear": 2001,
"actual": 2541125,
"forecast": 2688735,
"value": 147610,
"type": "forecast"
},
{
"budgetYear": 1997,
"forecastYear": 2002,
"actual": 2474730,
"forecast": 2804495,
"value": 329765,
"type": "forecast"
},
{
"budgetYear": 1997,
"forecastYear": 2003,
"actual": 2547057,
"forecast": 2922295,
"value": 375238,
"type": "forecast"
},
{
"budgetYear": 1998,
"forecastYear": 1998,
"actual": 2354379,
"forecast": "",
"value": 181808,
"type": "actual"
},
{
"budgetYear": 1998,
"forecastYear": 1998,
"actual": 2354379,
"forecast": 2279220,
"value": -75159,
"type": "forecast"
},
{
"budgetYear": 1998,
"forecastYear": 1999,
"actual": 2479025,
"forecast": 2384320,
"value": -94705,
"type": "forecast"
},
{
"budgetYear": 1998,
"forecastYear": 2000,
"actual": 2628678,
"forecast": 2498560,
"value": -130118,
"type": "forecast"
},
{
"budgetYear": 1998,
"forecastYear": 2001,
"actual": 2541125,
"forecast": 2622690,
"value": 81565,
"type": "forecast"
},
{
"budgetYear": 1998,
"forecastYear": 2002,
"actual": 2474730,
"forecast": 2757800,
"value": 283070,
"type": "forecast"
},
{
"budgetYear": 1998,
"forecastYear": 2003,
"actual": 2547057,
"forecast": 2905300,
"value": 358243,
"type": "forecast"
},
{
"budgetYear": 1998,
"forecastYear": 2004,
"actual": 2711843,
"forecast": 3066090,
"value": 354247,
"type": "forecast"
},
{
"budgetYear": 1999,
"forecastYear": 1999,
"actual": 2479025,
"forecast": "",
"value": 124646,
"type": "actual"
},
{
"budgetYear": 1999,
"forecastYear": 1999,
"actual": 2479025,
"forecast": 2477805,
"value": -1220,
"type": "forecast"
},
{
"budgetYear": 1999,
"forecastYear": 2000,
"actual": 2628678,
"forecast": 2621575,
"value": -7103,
"type": "forecast"
},
{
"budgetYear": 1999,
"forecastYear": 2001,
"actual": 2541125,
"forecast": 2790875,
"value": 249750,
"type": "forecast"
},
{
"budgetYear": 1999,
"forecastYear": 2002,
"actual": 2474730,
"forecast": 2939015,
"value": 464285,
"type": "forecast"
},
{
"budgetYear": 1999,
"forecastYear": 2003,
"actual": 2547057,
"forecast": 3082135,
"value": 535078,
"type": "forecast"
},
{
"budgetYear": 1999,
"forecastYear": 2004,
"actual": 2711843,
"forecast": 3233855,
"value": 522012,
"type": "forecast"
},
{
"budgetYear": 1999,
"forecastYear": 2005,
"actual": 2851707,
"forecast": 3363345,
"value": 511638,
"type": "forecast"
},
{
"budgetYear": 2000,
"forecastYear": 2000,
"actual": 2628678,
"forecast": "",
"value": 149653,
"type": "actual"
},
{
"budgetYear": 2000,
"forecastYear": 2000,
"actual": 2628678,
"forecast": 2651200,
"value": 22522,
"type": "forecast"
},
{
"budgetYear": 2000,
"forecastYear": 2001,
"actual": 2541125,
"forecast": 2807510,
"value": 266385,
"type": "forecast"
},
{
"budgetYear": 2000,
"forecastYear": 2002,
"actual": 2474730,
"forecast": 2977040,
"value": 502310,
"type": "forecast"
},
{
"budgetYear": 2000,
"forecastYear": 2003,
"actual": 2547057,
"forecast": 3149890,
"value": 602833,
"type": "forecast"
},
{
"budgetYear": 2000,
"forecastYear": 2004,
"actual": 2711843,
"forecast": 3315860,
"value": 604017,
"type": "forecast"
},
{
"budgetYear": 2000,
"forecastYear": 2005,
"actual": 2851707,
"forecast": 3467780,
"value": 616073,
"type": "forecast"
},
{
"budgetYear": 2000,
"forecastYear": 2006,
"actual": 2971116,
"forecast": 3584890,
"value": 613774,
"type": "forecast"
},
{
"budgetYear": 2001,
"forecastYear": 2001,
"actual": 2541125,
"forecast": "",
"value": -38246,
"type": "actual"
},
{
"budgetYear": 2001,
"forecastYear": 2001,
"actual": 2541125,
"forecast": 2646535,
"value": 105410,
"type": "forecast"
},
{
"budgetYear": 2001,
"forecastYear": 2002,
"actual": 2474730,
"forecast": 2756845,
"value": 282115,
"type": "forecast"
},
{
"budgetYear": 2001,
"forecastYear": 2003,
"actual": 2547057,
"forecast": 2888555,
"value": 341498,
"type": "forecast"
},
{
"budgetYear": 2001,
"forecastYear": 2004,
"actual": 2711843,
"forecast": 3005705,
"value": 293862,
"type": "forecast"
},
{
"budgetYear": 2001,
"forecastYear": 2005,
"actual": 2851707,
"forecast": 3125895,
"value": 274188,
"type": "forecast"
},
{
"budgetYear": 2001,
"forecastYear": 2006,
"actual": 2971116,
"forecast": 3244075,
"value": 272959,
"type": "forecast"
},
{
"budgetYear": 2001,
"forecastYear": 2007,
"actual": 3107628,
"forecast": 3360095,
"value": 252467,
"type": "forecast"
},
{
"budgetYear": 2002,
"forecastYear": 2002,
"actual": 2474730,
"forecast": "",
"value": -66395,
"type": "actual"
},
{
"budgetYear": 2002,
"forecastYear": 2002,
"actual": 2474730,
"forecast": 2527850,
"value": 53120,
"type": "forecast"
},
{
"budgetYear": 2002,
"forecastYear": 2003,
"actual": 2547057,
"forecast": 2638832,
"value": 91775,
"type": "forecast"
},
{
"budgetYear": 2002,
"forecastYear": 2004,
"actual": 2711843,
"forecast": 2759556,
"value": 47713,
"type": "forecast"
},
{
"budgetYear": 2002,
"forecastYear": 2005,
"actual": 2851707,
"forecast": 2846473,
"value": -5234,
"type": "forecast"
},
{
"budgetYear": 2002,
"forecastYear": 2006,
"actual": 2971116,
"forecast": 2936938,
"value": -34178,
"type": "forecast"
},
{
"budgetYear": 2002,
"forecastYear": 2007,
"actual": 3107628,
"forecast": 3036513,
"value": -71115,
"type": "forecast"
},
{
"budgetYear": 2002,
"forecastYear": 2008,
"actual": 3150924,
"forecast": 3142342,
"value": -8582,
"type": "forecast"
},
{
"budgetYear": 2003,
"forecastYear": 2003,
"actual": 2547057,
"forecast": "",
"value": 72327,
"type": "actual"
},
{
"budgetYear": 2003,
"forecastYear": 2003,
"actual": 2547057,
"forecast": 2524482,
"value": -22575,
"type": "forecast"
},
{
"budgetYear": 2003,
"forecastYear": 2004,
"actual": 2711843,
"forecast": 2628226,
"value": -83617,
"type": "forecast"
},
{
"budgetYear": 2003,
"forecastYear": 2005,
"actual": 2851707,
"forecast": 2728010,
"value": -123697,
"type": "forecast"
},
{
"budgetYear": 2003,
"forecastYear": 2006,
"actual": 2971116,
"forecast": 2842681,
"value": -128435,
"type": "forecast"
},
{
"budgetYear": 2003,
"forecastYear": 2007,
"actual": 3107628,
"forecast": 2943541,
"value": -164087,
"type": "forecast"
},
{
"budgetYear": 2003,
"forecastYear": 2008,
"actual": 3150924,
"forecast": 3055257,
"value": -95667,
"type": "forecast"
},
{
"budgetYear": 2003,
"forecastYear": 2009,
"actual": 2930100,
"forecast": 3166835,
"value": 236735,
"type": "forecast"
},
{
"budgetYear": 2004,
"forecastYear": 2004,
"actual": 2711843,
"forecast": "",
"value": 158441,
"type": "actual"
},
{
"budgetYear": 2004,
"forecastYear": 2004,
"actual": 2711843,
"forecast": 2622999,
"value": -88844,
"type": "forecast"
},
{
"budgetYear": 2004,
"forecastYear": 2005,
"actual": 2851707,
"forecast": 2705527,
"value": -146180,
"type": "forecast"
},
{
"budgetYear": 2004,
"forecastYear": 2006,
"actual": 2971116,
"forecast": 2773303,
"value": -197813,
"type": "forecast"
},
{
"budgetYear": 2004,
"forecastYear": 2007,
"actual": 3107628,
"forecast": 2867270,
"value": -240358,
"type": "forecast"
},
{
"budgetYear": 2004,
"forecastYear": 2008,
"actual": 3150924,
"forecast": 2950322,
"value": -200602,
"type": "forecast"
},
{
"budgetYear": 2004,
"forecastYear": 2009,
"actual": 2930100,
"forecast": 3029369,
"value": 99269,
"type": "forecast"
},
{
"budgetYear": 2004,
"forecastYear": 2010,
"actual": 2980761,
"forecast": 3119204,
"value": 138443,
"type": "forecast"
},
{
"budgetYear": 2005,
"forecastYear": 2005,
"actual": 2851707,
"forecast": "",
"value": 139864,
"type": "actual"
},
{
"budgetYear": 2005,
"forecastYear": 2005,
"actual": 2851707,
"forecast": 2833171,
"value": -18536,
"type": "forecast"
},
{
"budgetYear": 2005,
"forecastYear": 2006,
"actual": 2971116,
"forecast": 2929890,
"value": -41226,
"type": "forecast"
},
{
"budgetYear": 2005,
"forecastYear": 2007,
"actual": 3107628,
"forecast": 3013753,
"value": -93875,
"type": "forecast"
},
{
"budgetYear": 2005,
"forecastYear": 2008,
"actual": 3150924,
"forecast": 3092996,
"value": -57928,
"type": "forecast"
},
{
"budgetYear": 2005,
"forecastYear": 2009,
"actual": 2930100,
"forecast": 3168364,
"value": 238264,
"type": "forecast"
},
{
"budgetYear": 2005,
"forecastYear": 2010,
"actual": 2980761,
"forecast": 3292190,
"value": 311429,
"type": "forecast"
},
{
"budgetYear": 2005,
"forecastYear": 2011,
"actual": 3077567,
"forecast": 3394422,
"value": 316855,
"type": "forecast"
},
{
"budgetYear": 2006,
"forecastYear": 2006,
"actual": 2971116,
"forecast": "",
"value": 119409,
"type": "actual"
},
{
"budgetYear": 2006,
"forecastYear": 2006,
"actual": 2971116,
"forecast": 2950557,
"value": -20559,
"type": "forecast"
},
{
"budgetYear": 2006,
"forecastYear": 2007,
"actual": 3107628,
"forecast": 3045884,
"value": -61744,
"type": "forecast"
},
{
"budgetYear": 2006,
"forecastYear": 2008,
"actual": 3150924,
"forecast": 3129785,
"value": -21139,
"type": "forecast"
},
{
"budgetYear": 2006,
"forecastYear": 2009,
"actual": 2930100,
"forecast": 3230948,
"value": 300848,
"type": "forecast"
},
{
"budgetYear": 2006,
"forecastYear": 2010,
"actual": 2980761,
"forecast": 3353712,
"value": 372951,
"type": "forecast"
},
{
"budgetYear": 2006,
"forecastYear": 2011,
"actual": 3077567,
"forecast": 3456617,
"value": 379050,
"type": "forecast"
},
{
"budgetYear": 2006,
"forecastYear": 2012,
"actual": 3017636,
"forecast": 3562090,
"value": 544454,
"type": "forecast"
},
{
"budgetYear": 2007,
"forecastYear": 2007,
"actual": 3107628,
"forecast": "",
"value": 136512,
"type": "actual"
},
{
"budgetYear": 2007,
"forecastYear": 2007,
"actual": 3107628,
"forecast": 3077218,
"value": -30410,
"type": "forecast"
},
{
"budgetYear": 2007,
"forecastYear": 2008,
"actual": 3150924,
"forecast": 3181335,
"value": 30411,
"type": "forecast"
},
{
"budgetYear": 2007,
"forecastYear": 2009,
"actual": 2930100,
"forecast": 3283437,
"value": 353337,
"type": "forecast"
},
{
"budgetYear": 2007,
"forecastYear": 2010,
"actual": 2980761,
"forecast": 3377868,
"value": 397107,
"type": "forecast"
},
{
"budgetYear": 2007,
"forecastYear": 2011,
"actual": 3077567,
"forecast": 3515435,
"value": 437868,
"type": "forecast"
},
{
"budgetYear": 2007,
"forecastYear": 2012,
"actual": 3017636,
"forecast": 3628142,
"value": 610506,
"type": "forecast"
},
{
"budgetYear": 2007,
"forecastYear": 2013,
"actual": 2990043,
"forecast": 3739529,
"value": 749486,
"type": "forecast"
},
{
"budgetYear": 2008,
"forecastYear": 2008,
"actual": 3150924,
"forecast": "",
"value": 43296,
"type": "actual"
},
{
"budgetYear": 2008,
"forecastYear": 2008,
"actual": 3150924,
"forecast": 3227284,
"value": 76360,
"type": "forecast"
},
{
"budgetYear": 2008,
"forecastYear": 2009,
"actual": 2930100,
"forecast": 3360937,
"value": 430837,
"type": "forecast"
},
{
"budgetYear": 2008,
"forecastYear": 2010,
"actual": 2980761,
"forecast": 3480588,
"value": 499827,
"type": "forecast"
},
{
"budgetYear": 2008,
"forecastYear": 2011,
"actual": 3077567,
"forecast": 3587958,
"value": 510391,
"type": "forecast"
},
{
"budgetYear": 2008,
"forecastYear": 2012,
"actual": 3017636,
"forecast": 3750415,
"value": 732779,
"type": "forecast"
},
{
"budgetYear": 2008,
"forecastYear": 2013,
"actual": 2990043,
"forecast": 3864513,
"value": 874470,
"type": "forecast"
},
{
"budgetYear": 2008,
"forecastYear": 2014,
"actual": 3030019,
"forecast": 3977226,
"value": 947207,
"type": "forecast"
},
{
"budgetYear": 2009,
"forecastYear": 2009,
"actual": 2930100,
"forecast": "",
"value": -220824,
"type": "actual"
},
{
"budgetYear": 2009,
"forecastYear": 2009,
"actual": 2930100,
"forecast": 2994009,
"value": 63909,
"type": "forecast"
},
{
"budgetYear": 2009,
"forecastYear": 2010,
"actual": 2980761,
"forecast": 3044531,
"value": 63770,
"type": "forecast"
},
{
"budgetYear": 2009,
"forecastYear": 2011,
"actual": 3077567,
"forecast": 3149288,
"value": 71721,
"type": "forecast"
},
{
"budgetYear": 2009,
"forecastYear": 2012,
"actual": 3017636,
"forecast": 3281071,
"value": 263435,
"type": "forecast"
},
{
"budgetYear": 2009,
"forecastYear": 2013,
"actual": 2990043,
"forecast": 3381186,
"value": 391143,
"type": "forecast"
},
{
"budgetYear": 2009,
"forecastYear": 2014,
"actual": 3030019,
"forecast": 3493749,
"value": 463730,
"type": "forecast"
},
{
"budgetYear": 2009,
"forecastYear": 2015,
"actual": 3080476,
"forecast": 3604966,
"value": 524490,
"type": "forecast"
},
{
"budgetYear": 2010,
"forecastYear": 2010,
"actual": 2980761,
"forecast": "",
"value": 50661,
"type": "actual"
},
{
"budgetYear": 2010,
"forecastYear": 2010,
"actual": 2980761,
"forecast": 2961934,
"value": -18827,
"type": "forecast"
},
{
"budgetYear": 2010,
"forecastYear": 2011,
"actual": 3077567,
"forecast": 3059759,
"value": -17808,
"type": "forecast"
},
{
"budgetYear": 2010,
"forecastYear": 2012,
"actual": 3017636,
"forecast": 3165885,
"value": 148249,
"type": "forecast"
},
{
"budgetYear": 2010,
"forecastYear": 2013,
"actual": 2990043,
"forecast": 3256675,
"value": 266632,
"type": "forecast"
},
{
"budgetYear": 2010,
"forecastYear": 2014,
"actual": 3030019,
"forecast": 3356861,
"value": 326842,
"type": "forecast"
},
{
"budgetYear": 2010,
"forecastYear": 2015,
"actual": 3080476,
"forecast": 3454204,
"value": 373728,
"type": "forecast"
},
{
"budgetYear": 2011,
"forecastYear": 2011,
"actual": 3077567,
"forecast": "",
"value": 96806,
"type": "actual"
},
{
"budgetYear": 2011,
"forecastYear": 2011,
"actual": 3077567,
"forecast": 3124057,
"value": 46490,
"type": "forecast"
},
{
"budgetYear": 2011,
"forecastYear": 2012,
"actual": 3017636,
"forecast": 3240186,
"value": 222550,
"type": "forecast"
},
{
"budgetYear": 2011,
"forecastYear": 2013,
"actual": 2990043,
"forecast": 3313221,
"value": 323178,
"type": "forecast"
},
{
"budgetYear": 2011,
"forecastYear": 2014,
"actual": 3030019,
"forecast": 3397430,
"value": 367411,
"type": "forecast"
},
{
"budgetYear": 2011,
"forecastYear": 2015,
"actual": 3080476,
"forecast": 3481246,
"value": 400770,
"type": "forecast"
},
{
"budgetYear": 2012,
"forecastYear": 2012,
"actual": 3017636,
"forecast": "",
"value": -59931,
"type": "actual"
},
{
"budgetYear": 2012,
"forecastYear": 2012,
"actual": 3017636,
"forecast": 3041017,
"value": 23381,
"type": "forecast"
},
{
"budgetYear": 2012,
"forecastYear": 2013,
"actual": 2990043,
"forecast": 3081990,
"value": 91947,
"type": "forecast"
},
{
"budgetYear": 2012,
"forecastYear": 2014,
"actual": 3030019,
"forecast": 3167441,
"value": 137422,
"type": "forecast"
},
{
"budgetYear": 2012,
"forecastYear": 2015,
"actual": 3080476,
"forecast": 3255219,
"value": 174743,
"type": "forecast"
},
{
"budgetYear": 2013,
"forecastYear": 2013,
"actual": 2990043,
"forecast": "",
"value": -27593,
"type": "actual"
},
{
"budgetYear": 2013,
"forecastYear": 2013,
"actual": 2990043,
"forecast": 2965471,
"value": -24572,
"type": "forecast"
},
{
"budgetYear": 2013,
"forecastYear": 2014,
"actual": 3030019,
"forecast": 3050685,
"value": 20666,
"type": "forecast"
},
{
"budgetYear": 2013,
"forecastYear": 2015,
"actual": 3080476,
"forecast": 3135541,
"value": 55065,
"type": "forecast"
},
{
"budgetYear": 2014,
"forecastYear": 2014,
"actual": 3030019,
"forecast": "",
"value": 39976,
"type": "actual"
},
{
"budgetYear": 2014,
"forecastYear": 2014,
"actual": 3030019,
"forecast": 2988686,
"value": -41333,
"type": "forecast"
},
{
"budgetYear": 2014,
"forecastYear": 2015,
"actual": 3080476,
"forecast": 3056360,
"value": -24116,
"type": "forecast"
},
{
"budgetYear": 2015,
"forecastYear": 2015,
"actual": 3080476,
"forecast": "",
"value": 50457,
"type": "actual"
},
{
"budgetYear": 2015,
"forecastYear": 2015,
"actual": 3080476,
"forecast": 3058723,
"value": -21753,
"type": "forecast"
}
]
<html>
<head>
<title>STATFOR Forecasts</title>
<script src="https://vega.github.io/vega-editor/vendor/d3.min.js"></script>
<script src="https://vega.github.io/vega-editor/vendor/vega.min.js"></script>
</head>
<body>
<div id="vis"></div>
</body>
<script type="text/javascript">
// parse a spec and create a visualization view
function parse(spec) {
vg.parse.spec(spec, function(chart) { chart({el:"#vis"}).update(); });
}
parse("spec.json");
</script>
</html>
{
"width": 800,
"height": 600,
"padding": {"top": 10,"left": 10,"right": 80,"bottom": 10},
"background": "#edf1f7",
"signals": [
{
"name": "dragging",
"init": false,
"streams": [
{"type": "@handle:mousedown","expr": "true"},
{"type": "mouseup","expr": "false"}
]
},
{
"name": "handleYear",
"streams": [
{
"type": "mousemove[dragging]",
"expr": "clamp(eventX(), 10, 10000)",
"scale": {"name": "x","invert": true}
}
]
},
{
"name": "currentYear",
"init": 2010,
"expr": "clamp(handleYear, 1990, 2015)"
},
{
"name": "tipYear",
"streams": [
{
"type": "mousemove[!dragging]",
"expr": "eventX()",
"scale": {"name": "x","invert": true}
}
]
},
{
"name": "tipValue",
"streams": [
{
"type": "mousemove[!dragging]",
"expr": "eventY()",
"scale": {"name": "y","invert": true}
}
]
},
{
"name": "cursor",
"streams": [
{
"type": "dragging",
"expr": "dragging ? 'pointer' : 'default'"
}
]
}
],
"data": [
{
"name": "all",
"url": "forecasts.json"
},
{
"name": "forecasts",
"source": "all",
"transform": [
{
"type": "filter",
"test": "datum.type === 'forecast'"
},
{
"type": "formula",
"field": "abs",
"expr": "abs(datum.value)"
},
{
"type": "formula",
"field": "type",
"expr": "datum.value < 0 ? '➷' : '➹'"
}
]
},
{
"name": "actuals",
"source": "all",
"transform": [{"type": "filter","test": "datum.type === 'actual'"}]
},
{
"name": "tooltip",
"source": "forecasts",
"transform": [
{
"type": "filter",
"test": "datum.budgetYear <= currentYear && datum.forecastYear == tipYear && abs(datum.forecast - tipValue) < 100000"
},
{
"type": "aggregate",
"summarize": [
{
"field": "value",
"ops": ["min","argmin"],
"as": ["min","argmin"]
}
]
},
{
"type": "formula",
"field": "minYear",
"expr": "datum.argmin.budgetYear"
}
]
},
{
"name": "tipForecast",
"source": "forecasts",
"transform": [
{
"type": "lookup",
"on": "tooltip",
"onKey": "minYear",
"keys": ["budgetYear"],
"as": ["t"]
},
{"type": "filter","test": "datum.t"}
]
}
],
"scales": [
{
"name": "x",
"type": "ordinal",
"domain": {"data": "forecasts","field": "forecastYear"},
"range": "width",
"round": true,
"nice": true
},
{
"name": "y",
"type": "linear",
"exponent": 2.2,
"domain": {"data": "forecasts","field": "forecast"},
"range": "height",
"round": true,
"zero": false,
"nice": true
}
],
"axes": [
{
"type": "x",
"scale": "x",
"grid": true,
"layer": "back",
"tickSize": 0,
"properties": {
"grid": {
"stroke": {"value": "white"},
"strokeOpacity": {"value": 0.75}
},
"axis": {"stroke": {"value": "#edf1f7"}},
"labels": {"fill": {"value": "#edf1f7"}}
}
},
{
"type": "y",
"scale": "y",
"grid": true,
"layer": "back",
"orient": "right",
"values": [
1400000,
1600000,
1800000,
2000000,
2200000,
2400000,
2600000,
2800000,
3000000,
3200000,
3400000,
3600000,
3800000,
4000000
],
"title": "Movements",
"tickSize": 1,
"properties": {
"grid": {
"stroke": {"value": "white"},
"strokeOpacity": {"value": 0.75}
},
"axis": {"stroke": {"value": "#edf1f7"}},
"labels": {
"text": {
"template": "{{datum.data | number:'.2s'}}"
}
}
}
}
],
"marks": [
{
"type": "group",
"from": {
"data": "forecasts",
"transform": [
{
"type": "filter",
"test": "datum.budgetYear <= currentYear"
},
{"type": "facet","groupby": ["budgetYear"]}
]
},
"marks": [
{
"type": "line",
"properties": {
"update": {
"x": {"scale": "x","field": "forecastYear"},
"y": {"scale": "y","field": "forecast"},
"stroke": {"value": "steelblue"},
"strokeWidth": {"value": 1},
"strokeOpacity": {"value": 0.25}
}
}
}
]
},
{
"type": "symbol",
"from": {
"data": "actuals",
"transform": [
{
"type": "filter",
"test": "datum.budgetYear <= currentYear"
}
]
},
"properties": {
"update": {
"x": {"scale": "x","field": "forecastYear"},
"y": {"scale": "y","field": "actual"},
"stroke": {"value": "steelblue"},
"strokeWidth": {"value": 3},
"size": {"value": 16},
"shape": {"value": "diamond"}
}
}
},
{
"type": "line",
"from": {"data": "tipForecast"},
"properties": {
"update": {
"x": {"scale": "x","field": "forecastYear"},
"y": {"scale": "y","field": "forecast"},
"stroke": {"value": "black"},
"strokeWidth": {"value": 1}
}
}
},
{
"type": "symbol",
"from": {"data": "tooltip"},
"properties": {
"update": {
"x": {"scale": "x","field": "argmin.forecastYear"},
"y": {"scale": "y","field": "argmin.forecast"},
"size": {"value": 50},
"fill": {"value": "black"}
}
}
},
{
"type": "rule",
"properties": {
"enter": {
"y": {"scale": "y","value": 3900000},
"stroke": {"value": "#000"},
"strokeWidth": {"value": 1}
},
"update": {
"x": {"value": 0},
"x2": {"scale": "x","signal": "currentYear"}
}
}
},
{
"name": "handle",
"type": "symbol",
"properties": {
"enter": {
"y": {"scale": "y","value": 3900000,"offset": 1},
"shape": {"value": "triangle-down"},
"size": {"value": 150},
"stroke": {"value": "#000"},
"strokeWidth": {"value": 0.5}
},
"update": {
"x": {"scale": "x","signal": "currentYear"},
"fill": {"value": "#fff"}
},
"hover": {
"fill": {"value": "lemonchiffon"},
"cursor": {"value": "pointer"}
}
}
},
{
"type": "text",
"properties": {
"enter": {
"x": {"value": 0},
"y": {"value": 16},
"fontSize": {"value": 32},
"fontWeight": {"value": "bold"},
"fill": {"value": "steelblue"}
},
"update": {"text": {"signal": "currentYear"}}
}
},
{
"type": "group",
"from": {"data": "tooltip"},
"properties": {
"update": {
"x": {
"scale": "x",
"field": "argmin.forecastYear",
"offset": -5
},
"y": {
"scale": "y",
"field": "argmin.forecast",
"offset": 20
},
"width": {"value": 150},
"height": {"value": 35},
"fill": {"value": "#fff"},
"fillOpacity": {"value": 0.85},
"stroke": {"value": "#aaa"},
"strokeWidth": {"value": 0.5}
}
},
"marks": [
{
"type": "text",
"properties": {
"update": {
"x": {"value": 6},
"y": {"value": 14},
"text": {
"template": "Forecast from early {{parent.argmin.budgetYear}}"
},
"fill": {"value": "black"},
"fontWeight": {"value": "bold"}
}
}
},
{
"type": "text",
"properties": {
"update": {
"x": {"value": 6},
"y": {"value": 29},
"text": {
"template": "{{parent.argmin.forecastYear}} \t {{parent.argmin.abs|number:'d'}} flights {{parent.argmin.type}}"
},
"fill": {"value": "black"},
"align": {"value": "left"}
}
}
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment