Originally Posted by
margarita girl
Highlight what you want to copy hit Ctrl C, click on the first box in the new excel spreadsheet, hit Ctrl V.
At the beginning of the year, I note the miles in my account. I then calculate how many miles I used during the year and how many I accumulated, and I know how many will expire in 7 years. Each year is a new tab on the spreadsheet.
Comedy, this is exactly what I do!
Although, in my template, I have also added an estimated point redemption value and miles classification columns to have a subtotal of where the miles come from: ie. BIS, airline bonus, credit card, hotel, car rental, etc...just for the sake of curiosity.
When I look back, I see a mass (massive for me anyway) of redemptions for myself and family totaling 335,000...nearly clearing out my account over the 12 month period right after the 1/7 year expiry announcement.