I'm not great at Excel. Really not.
But I wonder if it's possible to make a spreadsheet that calculates my pension? The formula is... ugly:
(standard monthly income × the number of service period
months/12 × 975/1,000) + {standard monthly income × the
number of service period months/12 ×(the period of one’s
service - 60)/12 × 65/10,000}
EDIT: I should also add that the standard monthly income changes for most teachers each year (up to maybe the 10 year mark?), as most universities do give a raise with each new contract. Also if people switch universities, their standard monthly income might change, but their time in the pension is still going. This is the part where my capabilities completely break down. No clue if this is even spreadsheet-able.
From
http://www.tp.or.kr:8088/hp/upload/fixform/english.pdfIf someone could explain how to set up a spreadsheet that could calculate the current amount in a pension, it would benefit me and thousands of teachers in Korea. This is actually the first time I've even seen the formula! There isn't much communication about the pension to English speaking teachers :-/
Help!
Sincerely,
Incompetent