codeforboston / windfall-elimination

Windfall Elimination Provision Awareness Project: improving the experience of retirees around an obscure Social Security rule affecting 8+ states (previously https://ssacalculator.org)
https://windfall-develop.netlify.app/
MIT License
24 stars 45 forks source link

Update the wep table cache for 2020 #134

Closed thadk closed 4 years ago

thadk commented 4 years ago

I made a first pass to the spreadsheet to update the new values that were available at Christmas. Let's wait for the 2020 WEP substantial earnings threshold release in January if it comes out before we want to go live.

Then let's update the wep-table and wep-cache. You can pregenerate much of the cache using observable but it may or may not have the actuarial table yet.

From the Observable:

image
alexjcode commented 4 years ago

https://www.ssa.gov/OACT/COLA/bendpoints.html

thadk commented 4 years ago

The official PDF for Windfall is now updated for 2020:

image

I added the new value to the SubstantialEarningsClean spreadsheet.

We may want to link to this table in the FAQ as well: https://www.ssa.gov/planners/retire/wep-chart.html