My dashboard is a mess, I need help.

[ehh]

Any chance you have a spreadsheet example for “savings” vs rack rate?

Okay, this one is gonna require some explanation.

This is my 'Stays' tab, with a bunch of columns hidden to fit in what's most relevant to your ask. A lot of the 'work', especially calculating the 'used cost', is formulas you can't see here referencing other tabs, so idk how great this screenshot is gonna be.

And, to be blunt, I don't recommend this approach to others. It might not even be what I would do if I were starting from scratch...

But here goes:

• Column A - Stay Name, free text
• Column B - Resort, in a dropdown format
• Column C - Formula to show running number of stays-to-date at that resort, the running number of nights, and running number of points
• Column D - Room type, in a dropdown format
• Column E - Formula to show running number of stays-to-date in that room type, the running number of nights, and running number of points
• Column F - Check-in date for the stay
• Column G - Check-out date for the stay
• Column H - Stay duration, simple formula based on F/G
• Column I - Total points for stay, simple sum based on J
• Column J - Points used on this stay from a specific UY/contract, manually entered
• Column K - Contract where points are coming from for this line, manually entered
• Column L - Use Year where points are coming from for this line, manually entered
• Column M - Dropdown for Banked/Borrowed/Standard/OTUP/Comp points (used for other analysis, forgot to hide the column lol)
• Column S - Free text notes to describe the room/view, occasionally other stuff
• Column U - 'Used cost' of using those points from that contract+UY combo, a complex (but copy/pastable) formula that pulls data from each contract's financial tracking tab
  • This is basically the cost of using specific DVC points, including dues and upfront costs
  • Includes TOT for AUL/VDH stays
• Column V - Total 'used cost' for that stay, just a sum of all the 'used cost' values for that stay, as stays can have multiple contract+UY components
• Column W - Cost of renting points for the equivalent stay, though I have not done a good job keeping up with renting prices so it's probably not accurate
• Column X - Cost of equivalent stay on rack rate, manually entered
  • Typically I get this by going through the booking process on WDW/DL/AUL's site the day inventory is released
  • Sometimes I use mousesavers.com data
• Column Y - Breaking out the rack rate cost by the portion of points from that contract+UY line item; this feeds back into other tabs
  • Example, if a specific contract+UY combo contributes 20 of the 100 points for a stay, then 20% of the rack rate is attributed to that line item
• Column Z - Rack rate divided by points used, a kind of barometer for value
• Column AA - Discount % vs. rack rate, based on columns V and X
• Columns AB-AE - Same thing as columns X-AA, but with the best publicly available discount that is released
  • Public discounts are general public, and more recently, Disney+ subscriber discounts
  • I document it even if there's never any inventory available for the equivalent stay--if the offer says it covers the equivalent stay, then it gets documented
• Columns AF-AI - Same thing again, but with an AP discount
  • I document it even if there's never any inventory available for the equivalent stay--if the offer says it covers the equivalent stay, then it gets documented
• Columns AJ-BY - In addition to documenting the cost of equivalent rooms, I document the cost of the following resorts for the same dates with no discount, general public discount, and AP discount:
  • Pop Century, Preferred View/Room
  • Coronado, Standard/Resort View
  • Port Orleans Riverside, King Bed
  • Port Orleans Riverside, Royal Room with best view
  • Art of Animation, Lion King Suite
  • Wilderness Lodge, Courtyard/Resort View
  • Yacht Club, Garden/Resort View
  • Animal Kingdom Lodge, Savanna View
  • Polynesian, Standard/Resort View
  • Grand Floridian, Lagoon/Water View
  • BoardWalk, Garden Room
  • Bay Lake Tower, 2BR TPV
  • Copper Creek Cabin
  • Polynesian Bungalow

I also have multiple other tabs that use data from this tab, including 'savings vs. rack rate', but it's just different representations of the same data shown here.

 

[PlutoNotPlanet]

Glad to see this working again, I tried yesterday and was really sad when I thought it was no longer active. Although I cant ever seem to get it to work for CA properties.

They seem to get rack rate from mousesavers.com
If it's not available there, it won't work

 

[JulieBeeRN]

Okay, this one is gonna require some explanation.

This is my 'Stays' tab, with a bunch of columns hidden to fit in what's most relevant to your ask. A lot of the 'work', especially calculating the 'used cost', is formulas you can't see here referencing other tabs, so idk how great this screenshot is gonna be.

And, to be blunt, I don't recommend this approach to others. It might not even be what I would do if I were starting from scratch...

But here goes:

• Column A - Stay Name, free text
• Column B - Resort, in a dropdown format
• Column C - Formula to show running number of stays-to-date at that resort, the running number of nights, and running number of points
• Column D - Room type, in a dropdown format
• Column E - Formula to show running number of stays-to-date in that room type, the running number of nights, and running number of points
• Column F - Check-in date for the stay
• Column G - Check-out date for the stay
• Column H - Stay duration, simple formula based on F/G
• Column I - Total points for stay, simple sum based on J
• Column J - Points used on this stay from a specific UY/contract, manually entered
• Column K - Contract where points are coming from for this line, manually entered
• Column L - Use Year where points are coming from for this line, manually entered
• Column M - Dropdown for Banked/Borrowed/Standard/OTUP/Comp points (used for other analysis, forgot to hide the column lol)
• Column S - Free text notes to describe the room/view, occasionally other stuff
• Column U - 'Used cost' of using those points from that contract+UY combo, a complex (but copy/pastable) formula that pulls data from each contract's financial tracking tab
  • This is basically the cost of using specific DVC points, including dues and upfront costs
  • Includes TOT for AUL/VDH stays
• Column V - Total 'used cost' for that stay, just a sum of all the 'used cost' values for that stay, as stays can have multiple contract+UY components
• Column W - Cost of renting points for the equivalent stay, though I have not done a good job keeping up with renting prices so it's probably not accurate
• Column X - Cost of equivalent stay on rack rate, manually entered
  • Typically I get this by going through the booking process on WDW/DL/AUL's site the day inventory is released
  • Sometimes I use mousesavers.com data
• Column Y - Breaking out the rack rate cost by the portion of points from that contract+UY line item; this feeds back into other tabs
  • Example, if a specific contract+UY combo contributes 20 of the 100 points for a stay, then 20% of the rack rate is attributed to that line item
• Column Z - Rack rate divided by points used, a kind of barometer for value
• Column AA - Discount % vs. rack rate, based on columns V and X
• Columns AB-AE - Same thing as columns X-AA, but with the best publicly available discount that is released
  • Public discounts are general public, and more recently, Disney+ subscriber discounts
  • I document it even if there's never any inventory available for the equivalent stay--if the offer says it covers the equivalent stay, then it gets documented
• Columns AF-AI - Same thing again, but with an AP discount
  • I document it even if there's never any inventory available for the equivalent stay--if the offer says it covers the equivalent stay, then it gets documented
• Columns AJ-BY - In addition to documenting the cost of equivalent rooms, I document the cost of the following resorts for the same dates with no discount, general public discount, and AP discount:
  • Pop Century, Preferred View/Room
  • Coronado, Standard/Resort View
  • Port Orleans Riverside, King Bed
  • Port Orleans Riverside, Royal Room with best view
  • Art of Animation, Lion King Suite
  • Wilderness Lodge, Courtyard/Resort View
  • Yacht Club, Garden/Resort View
  • Animal Kingdom Lodge, Savanna View
  • Polynesian, Standard/Resort View
  • Grand Floridian, Lagoon/Water View
  • BoardWalk, Garden Room
  • Bay Lake Tower, 2BR TPV
  • Copper Creek Cabin
  • Polynesian Bungalow

I also have multiple other tabs that use data from this tab, including 'savings vs. rack rate', but it's just different representations of the same data shown here.