Wyndham Info Excel Sheet

[Ty1on]

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.

 

[Bigrob]

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]

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]

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]

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.

 

[uscav8r]

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.

 

[Ty1on]

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]

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]

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.

 

[ace2000]

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!

 

[Vacationfuntips]

Perhaps this thread regarding maintenance fees may be helpful to you?
http://tugbbs.com/forums/showthread.php?t=220076

Cynthia T.

 

[Ty1on]

Perhaps this thread regarding maintenance fees may be helpful to you?
http://tugbbs.com/forums/showthread.php?t=220076

Cynthia T.

Yes, I spent plenty time in this wonderful thread

 

[uscav8r]

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]

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.