The "classic" way to do it would be a simple table in an excel sheet. Years across the top, variable names down the side, data in the middle. I used a series of arrays in VBA for ease of updating tbh, but it's still a PITA!
So an array would look like:
The coe then works by picking the right one in the chain.![]()
rates(2012) = Array("2012/2013", 8105, 100000, 0.5, 2710, 0.1, 31660, 0.2, 115630, 0.4, 0.5, 0.1, 0.1, 0.325, 0.425, 0, 0, 0, 0, 0, 0, 0) rates(2013) = Array("2013/2014", 9440, 100000, 0.5, 2790, 0.1, 29220, 0.2, 117990, 0.4, 0.45, 0.1, 0.1, 0.325, 0.375, 0, 0, 0, 0, 0, 0, 0)
It's pretty unreadable and a bit of a nightmare to update. SO I thought about maybe using a simple query to say a postgresql database to pick up the relevant tables. I only need to do it as the workbooks linking in could be downloaded anywhere but the central repository of variables will be held on a server somewhere.
Was wondering what the easiet way to do this would be - seeing as there are a fair number of options from what I can work out.
Bookmarks