SVN MF Historical Database is now LIVE!

hypnotiq · Oct 11, 2013

Hey all,

I have finished building the site and database (well at least I think I have

) so that we can easily track and find historical data about SVN MF's, SA's, and Property taxes!

Here is your starting point:

Starwood Vacation Network MF Database

Notes

Entering new data:
- Unit sizes will show up once you select a property/phase
- Only unit sizes valid for a particular property/phase will be displayed
- You can choose between MF bill, Sep. Property Tax bill, and Sep. Special Assessment bill
- You are only required to put data in for the MF field, the rest is optional. I also won't let you submit with the MF data.
- I validate the format of the currency entered, so that we don't get bizarre data
- I check to see if we already have the information that you're hitting, if we do, I give you a message. If we don't, it gets added to the DB
Querying data: I'm not sure which feature I'm more excited for...
- I allow real time display of data as you select the drop downs. Every time you make a new choice, the table gets scoped. You can be as vague as you want (all data) down to a specific property, unit size, and usage.
  OR
- The table is sortable! If you click on the blue link at the top of the table (for any of the fields) it will switch between Ascending and Descending sort.

I've verified this site works against IE11, IE10, Firefox 24, Chrome 30, Safari 5.1.7 for Windows, Windows Phone 8, Android S3, and iPhone 5.

If you have any issues, shoot me a message.

Otherwise, let's get that database filled!

-Nico

PamMo · Oct 11, 2013

Can't input data for Ka'anapali. Incorrect syntax using the " ' " in Ka'anapali.

hypnotiq · Oct 11, 2013

PamMo said:
Can't input data for Ka'anapali. Incorrect syntax using the " ' " in Ka'anapali.

Whoops, forgot to use Encode in one spot. Fixed now.

Hit Ctrl-F5 to force reload the page.

alexadeparis · Oct 11, 2013

Thank you for all your efforts in this. I added the one I have access to from mystarcentral. Now, if we all do our part, we should have all the data in no time!

LisaRex · Oct 11, 2013

I added WKORV-N from 2008-2013. I add SVV Bella EOY odd for 2012-2013

PamMo · Oct 11, 2013

Wow! I was just poking around, and it looks/works GREAT so far!!!! If everyone inputs their resort MF's, it will be so much easier to find information than searching through separate threads on MF's.

(Lisa, it's really eye-popping to see Maui's MF's charted!

)

DavidnRobin · Oct 11, 2013

now I just need to remember where I put my electronic MFs file for our weeks

SMHarman · Oct 11, 2013

DavidnRobin said:
now I just need to remember where I put my electronic MFs file for our weeks

As David highlighted with the HI properties I think we have to many BIO types.

I found GRGS list of SO vs VOI.

I'll compare and contrast next week and let hypnotic know which to remove.

Ken555 · Oct 11, 2013

Looks great! I just added a bunch of info.

A couple bugs:

1. I entered 2008 WMH MFs, then went back to enter a separate entry for the property tax and it wouldn't let me add the property tax as a new record.

2. Different units at the same property, same phase, sometimes have different MFs and taxes. While confusing, it may be worth permitting multiple entries for the same year/property/phase.

3. I inadvertently entered the property tax info in the tax field by error...multiple times. User error, yes, but I would suggest moving the property tax field directly after MF since it's more common for property tax than tax (none of my properties have tax; just property tax - other than WKORV, which do?).

I know, these are probably "features" (Microsoft-speak) but may be more practical if you update.

Suggestion: I track % increase in my spreadsheets. It would be wonderful if you would add an analysis page of some type which shows some details about a particular resort and unit type. Perhaps a report displaying each year, % increase for MF and property tax, SVN fee, etc.

Thanks much!

grgs · Oct 11, 2013

Thanks for all your work on this!

Ken555 said:
1. I entered 2008 WMH MFs, then went back to enter a separate entry for the property tax and it wouldn't let me add the property tax as a new record.

I had a similar issue with trying to the special assessment for Sheraton Vistana Cascades as a separate entry.

Glorian

dioxide45 · Oct 11, 2013

Ken555 said:
Looks great! I just added a bunch of info.

2. Different units at the same property, same phase, sometimes have different MFs and taxes. While confusing, it may be worth permitting multiple entries for the same year/property/phase.

But aren't the units actually a different size? Like a 2BR-LO vs a 2BR? So you would never have two 2BR-LO with different maintenance fee amounts?

dioxide45 · Oct 11, 2013

It looks like the ampersand symbol in the resort names is causing issues in the search. Tried searching for resort=Westin Mission Hills Resort & Villas but it returned no results. Though Westin Mission Hills Resort & Villas shows in the database.

Ken555 · Oct 11, 2013

dioxide45 said:
But aren't the units actually a different size? Like a 2BR-LO vs a 2BR? So you would never have two 2BR-LO with different maintenance fee amounts?

No, we only wish it were that logical. I had two identical units at the same resort and phase with different MFs and property taxes (tho not a large difference); the only difference was the deeded week and unit number. I wouldn't have posted what I did if it were as simple as you suggest. I only wish it was.

Sent from my iPad

dioxide45 · Oct 11, 2013

Ken555 said:
No, we only wish it were that logical. I had two identical units at the same resort and phase with different MFs and property taxes (tho not a large difference); the only difference was the deeded week and unit number. I wouldn't have posted what I did if it were as simple as you suggest. I only wish it was.

Sent from my iPad

Are they Florida properties? I know for a fact that properties in Florida will have different MF amounts based on the season owned. This is because the taxes that are billed with the maintenance fees are different based on the season owned. That is why I suggested early on in the other thread to include the season as a field.

grgs · Oct 11, 2013

On some of the mf statements (Kierland & SVR Cascades), there's a prior tax credit. Should I just deduct the credit from the current year's tax total?

Glorian

DeniseM · Oct 11, 2013

dioxide45 said:
Are they Florida properties? I know for a fact that properties in Florida will have different MF amounts based on the season owned. This is because the taxes that are billed with the maintenance fees are different based on the season owned. That is why I suggested early on in the other thread to include the season as a field.

Not for Starwood... The difference in the tax is the sales price, not the MF.

alohakevin · Oct 11, 2013

Very cool.entered what info I had thanks hypnotiq

hypnotiq · Oct 12, 2013

Thanks everyone for the feedback! Keep it coming.

Ken555 said:
1. I entered 2008 WMH MFs, then went back to enter a separate entry for the property tax and it wouldn't let me add the property tax as a new record.

Fixed!

Ken555 said:
2. Different units at the same property, same phase, sometimes have different MFs and taxes. While confusing, it may be worth permitting multiple entries for the same year/property/phase.

I'll add an optional week field later this weekend.

Ken555 said:
3. I inadvertently entered the property tax info in the tax field by error...multiple times. User error, yes, but I would suggest moving the property tax field directly after MF since it's more common for property tax than tax (none of my properties have tax; just property tax - other than WKORV, which do?).

Fixed your entries. I also moved swapped the tax fields to help avoid this issue going forward.

Ken555 said:
I know, these are probably "features" (Microsoft-speak) but may be more practical if you update.

Yup, lots of 'features'.

You get what you pay for.

Ken555 said:
Suggestion: I track % increase in my spreadsheets. It would be wonderful if you would add an analysis page of some type which shows some details about a particular resort and unit type. Perhaps a report displaying each year, % increase for MF and property tax, SVN fee, etc.

Good suggestion, I'll work on this for my next update (after adding week field)

dioxide45 said:
It looks like the ampersand symbol in the resort names is causing issues in the search. Tried searching for resort=Westin Mission Hills Resort & Villas but it returned no results. Though Westin Mission Hills Resort & Villas shows in the database.

Fixed!

grgs said:
I had a similar issue with trying to the special assessment for Sheraton Vistana Cascades as a separate entry.

Fixed!

dioxide45 said:
That is why I suggested early on in the other thread to include the season as a field.

Sorry, I missed this in the earlier thread. As I told Ken above, I'll be adding an optional week field later this weekend.

Thanks again.
-Nico

Ken555 · Oct 12, 2013

hypnotiq said:
Fixed your entries. I also moved swapped the tax fields to help avoid this issue going forward.

Yup, lots of 'features'. You get what you pay for.

Thanks! If only certain software companies fixed bugs as quickly as you...

Sent from my iPad

DavidnRobin · Oct 12, 2013

Nico - I made an error in WSJ 2009 (it was a time of SA vs RR dispute) - can't email thru program (uses Robin's Biz email) - should be $2465.82.
I put in info for 2005 but forgot name.

I put in Property taxes as $130 as a reasonable approx for the years entered

Phase should be WSJ VGV (it is not Hillside - although some buildings are on the Hill, but the pool villas are lower in elevation than BV

)

WKV 1Bd Prem info that was entered for 2007 is incorrect (should be $596.7 and $32.60 tax) by some guy named Ken

Consider a total line (that doesn't include SVN fee) if you are going to include taxes and SA as separate line items.

hypnotiq · Oct 14, 2013

Fixed everything except for Ken's amount for WKV.

Ken, did you mess up your WKV? I want to confirm before I change the data.

Ill look at adding a total line when I add the confirmation/verification page (sometime this week).

Thanks for the feedback everyone.

We are up to 84 entries in the database. Keep them coming!

Ken555 · Oct 14, 2013

hypnotiq said:
Fixed everything except for Ken's amount for WKV.

Ken, did you mess up your WKV? I want to confirm before I change the data.

Ah. I see it. This line:

2007 Westin Kierland Villas 1 Bedroom Premium Annual 956.30 99 Ken555

Should be for a 2 Bed, not 1 Bed.

But it appears others are confused re property tax vs taxes. There should be no "taxes" for WKV.

DavidnRobin · Oct 14, 2013

I find the 'taxes' settings a bit confusing. For WSJ VGV the Property Taxes are separately billed. For WKV there is a tax incorporated into the MF, but not a property tax, and is also different for same VOI types.

Also, for WPORV - Owners pay a $50 annual fee (Princeville fee) on top of MF. Should this be included in MF or as separate line item.

hypnotiq · Oct 14, 2013

DavidnRobin said:
I find the 'taxes' settings a bit confusing. For WSJ VGV the Property Taxes are separately billed. For WKV there is a tax incorporated into the MF, but not a property tax, and is also different for same VOI types.

Also, for WPORV - Owners pay a $50 annual fee (Princeville fee) on top of MF. Should this be included in MF or as separate line item.

If you guys want to make show/hide dependent on resort, I can do that, I just need to know specifically which resorts have which taxes and which have none.

As far as WPORV, I would just include it as part of the MF unless owners want to track that amount changing.

DavidnRobin · Oct 14, 2013

hypnotiq said:
Fixed everything except for Ken's amount for WKV.

Ken, did you mess up your WKV? I want to confirm before I change the data.

Ill look at adding a total line when I add the confirmation/verification page (sometime this week).

Thanks for the feedback everyone.

We are up to 84 entries in the database. Keep them coming!

I guess I was not clear - the MFs for WSJ-VGV (2Bd TH) in 2009 was $2465.82 (not $1600.65). 2005 now has the 2009 MF (incorrect) - the original 2005 MF needs to be put back in

SVN MF Historical Database is now LIVE!

hypnotiq

PamMo

TUG Review Crew: Veteran

hypnotiq

alexadeparis

TUG Review Crew

LisaRex

TUG Review Crew

PamMo

TUG Review Crew: Veteran

DavidnRobin

SMHarman

Ken555

TUG Review Crew: Veteran

grgs

TUG Review Crew

dioxide45

TUG Review Crew: Expert

dioxide45

TUG Review Crew: Expert

Ken555

TUG Review Crew: Veteran

dioxide45

TUG Review Crew: Expert

grgs

TUG Review Crew

DeniseM

alohakevin

unconfirmed

hypnotiq

Ken555

TUG Review Crew: Veteran

DavidnRobin

hypnotiq

Ken555

TUG Review Crew: Veteran

DavidnRobin

hypnotiq

DavidnRobin