Would love to see your planning spreadsheets!

[Ashlotte]

I'm waiting on ROFR for my first DVC account and have the points and potential uses of points swimming around in my head. I'd love to see examples of how others keep track of points and how you have everything organized. I know I'm not the only OCD vacation planner out there! Thanks in advance.

 

[Stargazer65]

Nothing too fancy:

	Use Year​	2021​	2022​	2023​	2024​
Bay Lake Tower	June​	0​	50​	100​	100​
	​		​	​	​
Saratoga Springs	June​	0​	160​	160​	160​
	​
Boulder Ridge	Sep​	0​	67 (17)​	100​	100​
	​		​	​	​
Totals	June​	0​	210​	260​	260​
	Sep​	0​	67 (17)​	100​	100​
Note: Banked Points = (X)

 

[Stargazer65]

On the above, the parenthesis is used to keep track of what points are use/lose in that year. i.e. I had 50 BRV points for 2022, and then banked the 17 2021 points into 2022. If I had other points that were use/lose (transferred, borrowed, holding) I would also add them to the parenthesis. So I suppose I should call the parenthesis Use/Lose instead of Banked but Banked is the only category I have right now.

 

[Ashlotte]

On the above, the parenthesis is used to keep track of what points are use/lose in that year. i.e. I had 50 BRV points for 2022, and then banked the 17 2021 points into 2022. If I had other points that were use/lose (transferred, borrowed, holding) I would also add them to the parenthesis. So I suppose I should call the parenthesis Use/Lose instead of Banked but Banked is the only category I have right now.

Thanks so much for sharing!

 

[MonaMN]

Mine looks essentially like a checkbook… deposits are each year’s points, payments are the points used per trip - with a date and description of each line.

 

[Ashlotte]

Mine looks essentially like a checkbook… deposits are each year’s points, payments are the points used per trip - with a date and description of each line.

Smart!

 

[Maistre Gracey]

This is one of the reasons I’m upset with Disney vacations…

You now need a spreadsheet to plan a vacation.

 

[AdamsMum]

This is one of the reasons I’m upset with Disney vacations…

You now need a spreadsheet to plan a vacation.

I always needed a spreadsheet to plan my vacation. Doesn't everybody? This was before the pandemic, now it doesn't fit on one sheet. My DVC points spreadsheet is much easier.

 

[Stargazer65]

We started this when we got to 60 days out:

 

[ak517]

My spreadsheets tend to focus on $pp costs for the trip and also include estimated rack rates (without discounts) of my preferred value and mod for comparison. My $pp costs include a simplifies lifetime value of the points (just in present $$, I am not fancy) plus current MF. I am largely interested in getting a sweet dollar value out of my contract and maximizing points, so it works out that my DH and travel during low point seasons.

 

[skshain1020]

Ours is pretty simple for tracking our points, but part of that is because even though we have two contracts they are same use year and resort...

Date

Pts.

Nights

Resort

Points Running Total

We won't talk about the color-coded individual trip spreadsheet that has the parks, dining, genie + and lightning lanes plans on it that's broken down by day. Although it works for me and hubby to see our plans and helps us track what we did on trips for future planning.