Here's an example spreadsheet which will probably need some converting, and would need the population growth/loss formulas added, but I've tested my current countries and it seems to be working fine. I think the information is correct.

https://docs.google.com/...Upf8-wPo/edit?usp=sharing