• The TUGBBS forums are completely free and open to the public and exist as the absolute best place for owners to get help and advice about their timeshares for more than 30 years!

    Join Tens of Thousands of other Owners just like you here to get any and all Timeshare questions answered 24 hours a day!
  • TUG started 30 years ago in October 1993 as a group of regular Timeshare owners just like you!

    Read about our 30th anniversary: Happy 30th Birthday TUG!
  • TUG has a YouTube Channel to produce weekly short informative videos on popular Timeshare topics!

    Free memberships for every 50 subscribers!

    Visit TUG on Youtube!
  • TUG has now saved timeshare owners more than $21,000,000 dollars just by finding us in time to rescind a new Timeshare purchase! A truly incredible milestone!

    Read more here: TUG saves owners more than $21 Million dollars
  • Sign up to get the TUG Newsletter for free!

    60,000+ subscribing owners! A weekly recap of the best Timeshare resort reviews and the most popular topics discussed by owners!
  • Our official "end my sales presentation early" T-shirts are available again! Also come with the option for a free membership extension with purchase to offset the cost!

    All T-shirt options here!
  • A few of the most common links here on the forums for newbies and guests!

Wyndham Info Excel Sheet

Ty1on

TUG Review Crew: Veteran
TUG Member
Joined
Jun 10, 2015
Messages
5,127
Reaction score
1,958
Points
348
If you use Excel, the attached workbook is information on points charts, maintenance fees, weeks/seasons, etc., gathered from public sources. If you look at it and find errors, kindly let me know. I know some properties are missing. This is a work in progress. If it's useless, please let me know also.
 

Attachments

  • Wyndham Info.zip
    207.6 KB · Views: 302

Bigrob

TUG Member
Joined
Jul 9, 2011
Messages
2,099
Reaction score
141
Points
273
Location
Centreville, VA
If you use Excel, the attached workbook is information on points charts, maintenance fees, weeks/seasons, etc., gathered from public sources. If you look at it and find errors, kindly let me know. I know some properties are missing. This is a work in progress. If it's useless, please let me know also.

Definitely not useless, but there is probably more value here than I immediately know how to use...
 

Ty1on

TUG Review Crew: Veteran
TUG Member
Joined
Jun 10, 2015
Messages
5,127
Reaction score
1,958
Points
348
Definitely not useless, but there is probably more value here than I immediately know how to use...

Well if you have any questions how to drive it, ask away and that may be helpful to others who might use it.
 

Bigrob

TUG Member
Joined
Jul 9, 2011
Messages
2,099
Reaction score
141
Points
273
Location
Centreville, VA
Well if you have any questions how to drive it, ask away and that may be helpful to others who might use it.

First question - is there a way to tell on the first sheet, after selecting the resort(s) you want, which weeks are prime, high, value, or quiet for that resort? Or do you have to go to the second tab each time to look up for each resort the weeks that fall into each category?

Second question - there are more resorts listed in the maintenance fees weeks and timeshare calendars than in the points charts. Am I missing some in the pulldown or just not added yet? some pretty big ones like grand desert, ocean boulevard, etc.
 

Ty1on

TUG Review Crew: Veteran
TUG Member
Joined
Jun 10, 2015
Messages
5,127
Reaction score
1,958
Points
348
First question - is there a way to tell on the first sheet, after selecting the resort(s) you want, which weeks are prime, high, value, or quiet for that resort? Or do you have to go to the second tab each time to look up for each resort the weeks that fall into each category?

Second question - there are more resorts listed in the maintenance fees weeks and timeshare calendars than in the points charts. Am I missing some in the pulldown or just not added yet? some pretty big ones like grand desert, ocean boulevard, etc.

Let me play with it.....I am developing an Access DB that pretty much will give the same info and some other stuff, like for example, the weeks, and put in dates you want and points you have available, and it will return all possible locations that fit within your budget. The problem is that Access is less widely usable. I'll have to write some VBA to scrunch the week sets down in Excel so that the chart is readable, but that sounds like a good challenge.

Edit: Yes, I can add week groupings like you see in the Member Guide, but I am going to write code to do this because I don't want to manually key it all. First wave might be all weeks in a given season even though they are detached, next wave I'll add groupings to make it look just like the MG matrices. Stay tuned.
 
Last edited:

uscav8r

TUG Review Crew: Expert
TUG Member
Joined
Feb 1, 2013
Messages
1,961
Reaction score
266
Points
294
Location
Virginia
Reinventing the wheel

Ty1on: Here is a MF calculator I found on the Wyndham Owners BBS. I think this is a bit more useful from the MF calculation standpoint. The guy who put in the data used to have access to system-wide MF rates, but it hasn't been updated in quite some time. It may be something worth building up from.

As for the data you do have... What do you mean by Average of Average MF? Are these numbers taken from verified observations or eBay-like reports?

It would be nice to have an option to select either the $.55 Program fee or the $.57 program fee with Plus Partners. I'd also recommend using the official names vice non-standard nicknames (for instance, you have "Washington DC" instead of Old Town Alexandria).

Interesting project that I would opt to help with, but I have quite a few other things on my plate for the time being.
 

Attachments

  • Maintenance Calculator v2-2012.zip
    29.3 KB · Views: 71

Ty1on

TUG Review Crew: Veteran
TUG Member
Joined
Jun 10, 2015
Messages
5,127
Reaction score
1,958
Points
348
Ty1on: Here is a MF calculator I found on the Wyndham Owners BBS. I think this is a bit more useful from the MF calculation standpoint. The guy who put in the data used to have access to system-wide MF rates, but it hasn't been updated in quite some time. It may be something worth building up from.

As for the data you do have... What do you mean by Average of Average MF? Are these numbers taken from verified observations or eBay-like reports?

It would be nice to have an option to select either the $.55 Program fee or the $.57 program fee with Plus Partners. I'd also recommend using the official names vice non-standard nicknames (for instance, you have "Washington DC" instead of Old Town Alexandria).

Interesting project that I would opt to help with, but I have quite a few other things on my plate for the time being.

Yeah, things like the naming conventions are something I am working out as I develop. .55 vs .57 i certainly something I can add.

I'll just say that the MF are from a very reliable resource, the only caveat being that I manually entered them so they are subject to fatfingers.
 

ace2000

TUG Member
Joined
Dec 17, 2006
Messages
5,032
Reaction score
152
Points
498
Definitely not useless, but there is probably more value here than I immediately know how to use...

Just had a chance to see the spreadsheet and that's exactly my first thoughts. However, since Ty1on took the time to build this data, I'm sure it has value to him. I would really like to know the major goals of the project and who is the targeting audience?

On the three Timeshare Calendar tabs, you could easily build drop down boxes at the top of one worksheet to filter on the checkin day and the year. That would allow you to have just one sheet instead of three.

I'm sure I'd have other suggestions, once I knew the answer to the questions above.
 

Ty1on

TUG Review Crew: Veteran
TUG Member
Joined
Jun 10, 2015
Messages
5,127
Reaction score
1,958
Points
348
Just had a chance to see the spreadsheet and that's exactly my first thoughts. However, since Ty1on took the time to build this data, I'm sure it has value to him. I would really like to know the major goals of the project and who is the targeting audience?

On the three Timeshare Calendar tabs, you could easily build drop down boxes at the top of one worksheet to filter on the checkin day and the year. That would allow you to have just one sheet instead of three.

I'm sure I'd have other suggestions, once I knew the answer to the questions above.

Now those are questions an analyst would ask.

My purpose was to make a tool that saves myself from leafing through the member guide to find stuff. I have also input the other info about resorts into the database as I built the points data, but including that stuff would be my very last priority as I'm not sure it is that useful.

Also, I wanted to be able to look up maintenance fees, both weeks and UDI, without having to search for posts listing them. I found the tool you attached to be rather awkward for me personally.

The "Average of Avg Week Stay" is a tool that tries to put weeks and UDI on a basic apples to apples comparison, by taking a look at what it would cost you in MF, on average, to own a UDI sufficient to reserve the most basic 2BR unit. It takes the number of weeks in each season into account in the weighting. Of course the intangibles, like ability to reserve at other properties, can't be quantified.

I plan on making the TS Calendar a single sheet. This is something I made on the fly for someone, and I haven't built the algorithm to roll the Week 1 date up to the next when adding 364 to the previous year's Week 1. Week 53 will require an algorithm, too. If you notice, whenever the first day moves forward in day of month instead of back, I've hard written the date. This change is a low priority for me, as I really want to get the Weeks grouping on the points chart and try to make it as accurate a recreation of the MG points chart as possible.

There are also anomalies in the points charts I need to work out, like a couple resorts with multiple point spreads per season. For now, they are excluded.

So in short, my intention is to put decision support tools for the purchase and usage of Wyndham contracts in one place. There are some things that I will likely only do in Access, because they would require scripting to do in Excel, and I would not recommend that anyone enable macro execution for any file from a person they don't know.
 
Last edited:

ace2000

TUG Member
Joined
Dec 17, 2006
Messages
5,032
Reaction score
152
Points
498
I found the tool you attached to be rather awkward for me personally.

uscav8r posted that other file you're referring to. Your "Average of Avg Week Stay" calculation is interesting. Nice job bringing it all together!
 

uscav8r

TUG Review Crew: Expert
TUG Member
Joined
Feb 1, 2013
Messages
1,961
Reaction score
266
Points
294
Location
Virginia
Now those are questions an analyst would ask.
... I found the tool you attached to be rather awkward for me personally.
...
LOL! Yes, the purpose of a tool is always a key factor. The MF calculator I found is great for finding the "cheaper" resorts and nuances within those resorts, as well as informing someone as to how their MF might change if they sell or buy a contract (as long as it is updated).

To me it is very simple and straightforward! Then again, I don't know how your desire/requirement does not lend itself to using this format...

This does introduce an interesting point. The same data can be used for different tools and different purposes. It may be valuable to simply have a separate data file (Excel format or CSV) that only has the adjudicated MF rates, and not have it buried in some proprietary spreadsheet or database.

Then anybody could use that data as they see fit. :whoopie:
 

Ty1on

TUG Review Crew: Veteran
TUG Member
Joined
Jun 10, 2015
Messages
5,127
Reaction score
1,958
Points
348
LOL! Yes, the purpose of a tool is always a key factor. The MF calculator I found is great for finding the "cheaper" resorts and nuances within those resorts, as well as informing someone as to how their MF might change if they sell or buy a contract (as long as it is updated).

To me it is very simple and straightforward! Then again, I don't know how your desire/requirement does not lend itself to using this format...

This does introduce an interesting point. The same data can be used for different tools and different purposes. It may be valuable to simply have a separate data file (Excel format or CSV) that only has the adjudicated MF rates, and not have it buried in some proprietary spreadsheet or database.

Then anybody could use that data as they see fit. :whoopie:

Unhide the sheet called ForMF ;)

I only hid the underlying data sheets so the workbook would be less confusing.
 
Top