To help with with the number of points to purchase I have created an Excel sheet. Since we may not use our points every year; the worksheet helps with the number of years you run out of points if you borrow. I would gladly share this sheet with someone experienced to see if it makes sense and then post it somewhere if it is thought to be helpful.
The worksheet works by entering:
1) The points you plan to purchase
2) Typical points used per year (there are links to point calculator)
3) If there are borrowed or used points as with resale
You can also enter the price/pt for purchase cost.
It ouputs for 15 years the available points, years with inadequate points, lost points, maintenance fees for all sites. You can then modify individual years with precise numbers to see the effect.
For instance - I entered 218 as typical used points (1br -OKW - Magic season) and only 170 purchased. It shows that years 4, 9 and 13 will not have enough points for the 1bdrm. I then modified individual years by entering 0 for year 1 and 344 for a Hawaii trip. It adjusted all the other years.
I will e-mail this sheet for someone to try if interested. It will work best with Excel 2000 since there is a macro in the sheet.
CIPG (formerly Coldnorth)
The worksheet works by entering:
1) The points you plan to purchase
2) Typical points used per year (there are links to point calculator)
3) If there are borrowed or used points as with resale
You can also enter the price/pt for purchase cost.
It ouputs for 15 years the available points, years with inadequate points, lost points, maintenance fees for all sites. You can then modify individual years with precise numbers to see the effect.
For instance - I entered 218 as typical used points (1br -OKW - Magic season) and only 170 purchased. It shows that years 4, 9 and 13 will not have enough points for the 1bdrm. I then modified individual years by entering 0 for year 1 and 344 for a Hawaii trip. It adjusted all the other years.
I will e-mail this sheet for someone to try if interested. It will work best with Excel 2000 since there is a macro in the sheet.
CIPG (formerly Coldnorth)
