NOTICE: Updated DVC Points Planner now available

Discussion in 'Purchasing DVC' started by Caskbill, Mar 23, 2002.

  1. Caskbill

    Caskbill <font color="blue">DVC-Operations<br>DVC-Planning< Moderator

    Joined:
    Nov 19, 2000
    Messages:
    7,189
    Just wanted to post a note that I have updated my Excel DVC Points planner program.

    It now contains points charts for all 6 DVC resorts (BCV, BWV, OKW, VWL, HH, VB).

    It has point charts for the years 2001 thru 2010. And no, that is NOT a typing error....thru the year 2010. ;)

    Charts 2001 thru 2003 are taken from published Disney charts. Charts for 2004 thru 2010 were developed using the same patterns DVC has been using since 1993 in determining the Easter and Thanksgiving periods.

    If you're not already familiar, this is a point PLANNING tool, not a point tracking tool. It does not keep track of your personal points, usages, banking or borrowing.

    It does make it very simple to plan a vacation, and do any number of 'what-if's" with your points.

    To use, a single mouse click selects a resort. A single mouse click selects a room type. (If applicable, another click selects a view type). Then simply click directly on dates on the calendar, or click and drag to select multiple dates. Points required for that stay are instantly calculated.

    Ever wonder how many points it takes to stay at any of the resorts for a year? The program will figure it out in about a second. No need to dig out those point charts, try to find out what season your dates are in, then how many points it takes for weekdays, or weekends. Want to do BWV instead of OKW, one click changes the resort and recalculates all the points.

    Want to know your 7-month or 11-month booking dates? They're displayed automatically on a vacation plan page.

    The color coded calendar shows 24 months at a time. No need to use a simple planer where you put in a start date and how many days you want. See at a glance the full point structure for any resort, and see by colors where the points apply on a regular calendar page.

    This program is a spreadsheet, and does require Microsoft Excel 97 or later to run. Sorry. I hope some day to convert it to a free standing program, but it'll be awhile.

    The program uses dynamic macro routines written in VisualBasic to perform all the tasks. The working page is 'hot' meaning that simply clicking on the appropriate cells causes an appropriate routine to run. A full set of directions and explanations for the program is included on a separate worksheet tab.

    The spreadsheet has been placed on the Simtel.net download site. To conserve space, it is in a self extracting zip file named <b>DVCPOINT.EXE</b>. To use, simply download the file and run the executable. After it extracts you will have the Excel file (about 880 Kb, and a short TXT file.)

    Once extracted simply run your Microsoft Excel program and load the file. (Or from Explore, find the filename and double-click on it.) You might even want to put a shortcut on your desktop.

    Feedback comments are welcomed, and suggestions for future changes are appreciated.

    Have fun and enjoy your DVC calculations.

    Download the latest version of the DVC Planner DVCPOINT.EXE at this location:

    http://www.simtel.net/pub/dl/54928.shtml


    :wave:

    Are you computer challenged? Never performed a download before? Don't know how to run an executable? Then follow these instructions:

    Remember, this requires Microsoft Excel first. If you don't have it then you can't use the planner. If you do have Excel, then do this:

    1. Click on the link above. This will take you to the download page.
    2. From the list, select a location close to you.
    3. Your computer will ask you whether to open the program or save it to disk. Select save it to disk.
    4. The computer will ask for a location on your disk. It's easiest just to use what the computer suggests, but change it if you like. Be sure to remember the name of this location.
    5. The program will download in about 40 seconds or less.
    6. You can log off the internet now if you want.
    7. Either: A: Click on the START button, select RUN, type in the path that the file was downloaded to (you did write it down didn't you?) followed by \dvcpoint.exe
    Or B: Right click on START button, select EXPLORE to get into Windows Explorer. Scan through the directory tree to find the correct directory. You should see dvcpoint.exe listed as one of the files. Double click on it to run it.
    8. The spreadsheet file will self extract. If you're still in the directory tree, it should show. (press F5 to update the screen if you need to). Double click on the file Disney DVC Planner.xls to run it.
    9. Want a shortcut on your desktop? While still in the EXPLORE tree, right click on the file Disney DVC Planner.xls, select Create Shortcut. Now, if your window is full screen, shrink it to a window by clicking on the middle icon at the top right corner of your window screen. This should allow you to see both the smaller window and the desktop behind it. Click and drag the shortcut file you just created onto the desktop. Bingo, you're all set to run the planner at the click of a button.

    Thanks. If you have any questions about the program, just ask Doc. He's helped test it for both versions.
     
  2. Avatar

    DIS Sponsor The Official Ticket Center is Orlando’s #1 discount attraction ticket agency, selling millions of Walt Disney tickets around the world.



    to hide this adverts.
  3. Caskbill

    Caskbill <font color="blue">DVC-Operations<br>DVC-Planning< Moderator

    Joined:
    Nov 19, 2000
    Messages:
    7,189
    Bump for those who might have missed the first post.
     
  4. Terry S

    Terry S <a href="http://www.wdwinfo.com/dis-sponsor/index.

    Joined:
    Aug 9, 2001
    Messages:
    3,971
    Caskbill... Thank you very much. I have downloaded your excel file and I am using it. I like it a lot! Thanks for the effort you put into it.
     
  5. Mickeygolf

    Mickeygolf DIS Veteran

    Joined:
    Feb 27, 2001
    Messages:
    1,089
    Caskbill, this is really cool. I love all the differant types of room calculators out there and this is definitely one of the tops!!!

    Thanks for taking the time and energy to create this. As a new DVC member, I'm always looking for new things to try.
     
  6. TheWho

    TheWho DIS Veteran<br><font color="#0d858e">preachin' fro

    Joined:
    Sep 15, 2000
    Messages:
    426
    Great spreadsheet Bill, thanks
     
  7. BWVDenise

    BWVDenise I believe in something, I just don't know what it

    Joined:
    Feb 1, 2000
    Messages:
    2,348
    I am trying to do this and when I click on "Pennsylvania" I am taken to a page which tells me it will download in 30 seconds. In about 30 seconds, I am taken to another page which is an advertisement. My computer never asks me for the location, etc., as described in Bill's instructions. I even tried picking Massachusetts and the same thing happened. :confused:

    Any advice?
     
  8. BWVDenise

    BWVDenise I believe in something, I just don't know what it

    Joined:
    Feb 1, 2000
    Messages:
    2,348
    DH helped me when he got home from work. The PA location isn't working, but Illinois worked. Bill, thanks so much for this! What a great tool!:D :D
     
  9. Winnie's Friend

    Winnie's Friend Earning My Ears

    Joined:
    Jul 11, 2001
    Messages:
    1
    I love the DVC Planner! Thanks for updating it!!!
     
  10. disneyma

    disneyma Can't wait to get back to DVC and Disney....

    Joined:
    Oct 3, 2000
    Messages:
    200
    I was wondering if there was a way to get this for a mac? I have the Microsoft package Excel for the MACS. The download is for PC's

    Thanks,
    Ed
     
  11. TIdoublegaER

    TIdoublegaER <a href="http://www.wdwinfo.com/dis-sponsor/index.

    Joined:
    Dec 12, 2001
    Messages:
    1,008
    I must chime-in, and add to the list of thank you's!

    Thanks for sharing this with us ... it is great! Your work is appreciated.


    Tig
     
  12. Caskbill

    Caskbill <font color="blue">DVC-Operations<br>DVC-Planning< Moderator

    Joined:
    Nov 19, 2000
    Messages:
    7,189
    ED: It didn't work last year on the MAC when another DISer tried it with the first release, so don't know if it will work with your copy of Excel or not. I sent you an E-mail and can send you the excel file directly if you'd like.
     
  13. triple7

    triple7 Earning My Ears

    Joined:
    May 21, 2001
    Messages:
    54
    Caskbill

    Great Program!. I have already used it to do some initial planning fror next year.

    Thanks very much!!
     

Share This Page