Docstoc

Timeshare - Basic

Document Sample
Timeshare - Basic Powered By Docstoc
					                                      Instructions

All white cells can be edited, purple cells you can change by selecting items from a drop
    down box. Other cells are either formulas or headings and should be edited with
                                          caution.

There are currently 5 default members, you can add more if you need to, add them to
       the "Summary" sheet first and then you can add them to the list below.

        Week Distribution                     Distribute the weeks using the list on your
   25 Jun 2012 Member 1                        right, remember to add the members to
    02 Jul 2012 Member 2                        the summary sheet first, if you insert a
    09 Jul 2012 Member 3                      row there, it must be in the middle of the
    16 Jul 2012 Member 4
                                                 members list or it won't transfer here
    23 Jul 2012 Member 5
                                                               properly.
    30 Jul 2012 Member 1
  06 Aug 2012 Member 2
  13 Aug 2012 Member 3                          You can also re-colour the blocks on the
  20 Aug 2012 Member 4                           "Calendar" tab so that it is a different
  27 Aug 2012 Member 5
                                               colour for each member, you will have to
   03 Sep 2012 Member 1
                                                do it manually for this spreadsheet but I
   10 Sep 2012 Member 2
                                               have different spreadsheets available to
   17 Sep 2012 Member 3
   24 Sep 2012 Member 4                                  do this automatically.
   01 Oct 2012 Member 5
   08 Oct 2012 Member 1                        You can delete all the information blocks
   15 Oct 2012 Member 2
                                                from this sheet if you don't need them
   22 Oct 2012 Member 3
                                                  anymore, you will have to keep the
   29 Oct 2012 Member 4
                                               weekly distribution tabel in order for the
  05 Nov 2012 Member 5
  12 Nov 2012 Member 1                                 sheet to work properly.
  19 Nov 2012 Member 2
  26 Nov 2012 Member 3
   03 Dec 2012 Member 4
   10 Dec 2012 Member 5
   17 Dec 2012 Member 1
   24 Dec 2012 Member 2
   31 Dec 2012 Member 3
   07 Jan 2013 Member 4
   14 Jan 2013 Member 5
   21 Jan 2013 Member 1
   28 Jan 2013 Member 2
   04 Feb 2013 Member 3
   11 Feb 2013 Member 4
   18 Feb 2013 Member 5
   25 Feb 2013 Member 1
  04 Mar 2013 Member 2
  11 Mar 2013 Member 3
  18 Mar 2013 Member 4
  25 Mar 2013 Member 5
   01 Apr 2013 Member 1
   08 Apr 2013 Member 2
   15 Apr 2013 Member 3
   22 Apr 2013 Member 4
   29 Apr 2013 Member 5
  06 May 2013 Member 1
  13 May 2013 Member 2
  20 May 2013 Member 3
  27 May 2013 Member 4
   03 Jun 2013 Member 5
   10 Jun 2013 Member 1
   17 Jun 2013 Member 2
   24 Jun 2013 Member 3
    01 Jul 2013 Member 4
    08 Jul 2013 Member 5
    15 Jul 2013 Member 1
    22 Jul 2013 Member 2
    29 Jul 2013 Member 3
  05 Aug 2013 Member 4
  12 Aug 2013 Member 5
  19 Aug 2013 Member 1
                 Weeks         Reserved Prospect          Total
                                                                       Capacity
                                 Days     Days            Days
Member 1               13             0        0                   0     0.00%
Member 2               12             0        0                   0     0.00%
Member 3               12             0        0                   0     0.00%
Member 4               12             0        0                   0     0.00%
Member 5               12             0        0                   0     0.00%
Total                  61             0        0                   0     0.00%

                                                                       Dates set at Calender and not Actual Months
                  Jul 12       Aug 12       Sep 12        Oct 12       Nov 12     Dec 12     Dec 12    Feb 13   Mar 13     Apr 13       May 13     Jul 13       Aug 13       Total
Member 1                   0            0            0             0          0          0          0         0        0            0         0             0            0           0
Member 2                   0            0            0             0          0          0          0         0        0            0         0             0            0           0
Member 3                   0            0            0             0          0          0          0         0        0            0         0             0            0           0
Member 4                   0            0            0             0          0          0          0         0        0            0         0             0            0           0
Member 5                   0            0            0             0          0          0          0         0        0            0         0             0            0           0
   Total                   0            0            0             0          0          0          0         0        0            0         0             0            0           0


 You can change the the description                        You can add additional people to this                 The dates will
                                                                                                                                                  You can delete these
    of the top tabel in regards to                       summary. Insert a row and then copy the              automatically update
                                                                                                                                                  information blocks if
 "Reserved" and "Prospect". This will                     existing formulas into the new row. You                 if it has been
                                                                                                                                                   you no longer need
automatically update the formulas to                     have to insert the new row somewhere in                 updated in the                          them.
    calculate the totals correctly.                            the middle of the list of people.                     calendar.
TIMESHARE                                          This sheet will display bookings and events for each date, you can change the dates by
                                                 changing the date of the heading of the first month just below this block. You can add and
                                                 remove weeks from each month, as long as you don't copy or remove the first week of the
           Bookings Format   Name
                                                                 month. You can remove this block if you no longer need it.


                                                  July 2012
                   Mon        Tue      Wed             Thu                      Fri                    Sat                      Sun
Member 1




                  25 Jun     26 Jun   27 Jun          28 Jun                  29 Jun                  30 Jun                   01 Jul



                   Mon        Tue     Wed              Thu                     Fri                     Sat                      Sun
Member 2




                   02 Jul    03 Jul   04 Jul          05 Jul                  06 Jul                  07 Jul                   08 Jul



                   Mon        Tue     Wed              Thu                     Fri                     Sat                      Sun
Member 3




                   09 Jul    10 Jul   11 Jul          12 Jul                  13 Jul                  14 Jul                   15 Jul



                   Mon        Tue     Wed              Thu                     Fri                     Sat                      Sun
Member 4




                   16 Jul    17 Jul   18 Jul          19 Jul                  20 Jul                  21 Jul                   22 Jul



                   Mon        Tue     Wed              Thu                     Fri                     Sat                      Sun
Member 5




                   23 Jul    24 Jul   25 Jul          26 Jul                  27 Jul                  28 Jul                   29 Jul




                                                August 2012
                   Mon        Tue      Wed             Thu                      Fri                     Sat                    Sun
Member 1




                   30 Jul    31 Jul   01 Aug          02 Aug                  03 Aug                  04 Aug                  05 Aug



                   Mon        Tue      Wed             Thu                      Fri                     Sat                    Sun
Member 2




                  06 Aug     07 Aug   08 Aug          09 Aug                  10 Aug                  11 Aug                  12 Aug



                   Mon        Tue      Wed             Thu                      Fri                     Sat                    Sun
Member 3




                  13 Aug     14 Aug   15 Aug          16 Aug                  17 Aug                  18 Aug                  19 Aug



                   Mon        Tue      Wed             Thu                      Fri                     Sat                    Sun
Member 4




                  20 Aug     21 Aug   22 Aug          23 Aug                  24 Aug                  25 Aug                  26 Aug




                                               September 2012
                   Mon        Tue      Wed             Thu                      Fri                    Sat                     Sun
Member 5




                  27 Aug     28 Aug   29 Aug          30 Aug                  31 Aug                  01 Sep                  02 Sep



                   Mon        Tue      Wed             Thu                      Fri                    Sat                     Sun
Member 1




                  03 Sep     04 Sep   05 Sep          06 Sep                  07 Sep                  08 Sep                  09 Sep



                   Mon        Tue      Wed             Thu                      Fri                    Sat                     Sun
Member 2




                  10 Sep     11 Sep   12 Sep          13 Sep                  14 Sep                  15 Sep                  16 Sep



                   Mon        Tue      Wed             Thu                      Fri                    Sat                     Sun
Member 3




                  17 Sep     18 Sep   19 Sep          20 Sep                  21 Sep                  22 Sep                  23 Sep
                                       October 2012
            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 4



           24 Sep   25 Sep   26 Sep       27 Sep      28 Sep   29 Sep   30 Sep



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 5




           01 Oct   02 Oct   03 Oct       04 Oct      05 Oct   06 Oct   07 Oct



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 1




           08 Oct   09 Oct   10 Oct       11 Oct      12 Oct   13 Oct   14 Oct



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 2




           15 Oct   16 Oct   17 Oct       18 Oct      19 Oct   20 Oct   21 Oct



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 3




           22 Oct   23 Oct   24 Oct       25 Oct      26 Oct   27 Oct   28 Oct




                                      November 2012
            Mon      Tue      Wed          Thu          Fri      Sat     Sun
Member 4




           29 Oct   30 Oct   31 Oct       01 Nov      02 Nov   03 Nov   04 Nov



            Mon      Tue      Wed          Thu          Fri      Sat     Sun
Member 5




           05 Nov   06 Nov   07 Nov       08 Nov      09 Nov   10 Nov   11 Nov



            Mon      Tue      Wed          Thu          Fri      Sat     Sun
Member 1




           12 Nov   13 Nov   14 Nov       15 Nov      16 Nov   17 Nov   18 Nov



            Mon      Tue      Wed          Thu          Fri      Sat     Sun
Member 2




           19 Nov   20 Nov   21 Nov       22 Nov      23 Nov   24 Nov   25 Nov




                                      December 2012
            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 3




           26 Nov   27 Nov   28 Nov       29 Nov      30 Nov   01 Dec   02 Dec



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 4




           03 Dec   04 Dec   05 Dec       06 Dec      07 Dec   08 Dec   09 Dec



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 5




           10 Dec   11 Dec   12 Dec       13 Dec      14 Dec   15 Dec   16 Dec



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 1




           17 Dec   18 Dec   19 Dec       20 Dec      21 Dec   22 Dec   23 Dec
                                      January 2013
            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 2



           24 Dec   25 Dec   26 Dec       27 Dec      28 Dec   29 Dec   30 Dec



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 3




           31 Dec   01 Jan   02 Jan       03 Jan      04 Jan   05 Jan   06 Jan



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 4




           07 Jan   08 Jan   09 Jan       10 Jan      11 Jan   12 Jan   13 Jan



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 5




           14 Jan   15 Jan   16 Jan       17 Jan      18 Jan   19 Jan   20 Jan



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 1




           21 Jan   22 Jan   23 Jan       24 Jan      25 Jan   26 Jan   27 Jan




                                      February 2013
            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 2




           28 Jan   29 Jan   30 Jan       31 Jan      01 Feb   02 Feb   03 Feb



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 3




           04 Feb   05 Feb   06 Feb       07 Feb      08 Feb   09 Feb   10 Feb



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 4




           11 Feb   12 Feb   13 Feb       14 Feb      15 Feb   16 Feb   17 Feb



            Mon      Tue      Wed          Thu          Fri     Sat      Sun
Member 5




           18 Feb   19 Feb   20 Feb       21 Feb      22 Feb   23 Feb   24 Feb




                                       March 2013
            Mon      Tue      Wed          Thu          Fri      Sat     Sun
Member 1




           25 Feb   26 Feb   27 Feb       28 Feb      01 Mar   02 Mar   03 Mar



            Mon      Tue      Wed          Thu          Fri      Sat     Sun
Member 2




           04 Mar   05 Mar   06 Mar       07 Mar      08 Mar   09 Mar   10 Mar



            Mon      Tue      Wed          Thu          Fri      Sat     Sun
Member 3




           11 Mar   12 Mar   13 Mar       14 Mar      15 Mar   16 Mar   17 Mar



            Mon      Tue      Wed          Thu          Fri      Sat     Sun
Member 4




           18 Mar   19 Mar   20 Mar       21 Mar      22 Mar   23 Mar   24 Mar
                                      April 2013
            Mon      Tue      Wed        Thu         Fri      Sat     Sun
Member 5



           25 Mar   26 Mar   27 Mar     28 Mar     29 Mar   30 Mar   31 Mar



            Mon      Tue      Wed        Thu         Fri     Sat      Sun
Member 1




           01 Apr   02 Apr   03 Apr     04 Apr     05 Apr   06 Apr   07 Apr



            Mon      Tue      Wed        Thu         Fri     Sat      Sun
Member 2




           08 Apr   09 Apr   10 Apr     11 Apr     12 Apr   13 Apr   14 Apr



            Mon      Tue      Wed        Thu         Fri     Sat      Sun
Member 3




           15 Apr   16 Apr   17 Apr     18 Apr     19 Apr   20 Apr   21 Apr



            Mon      Tue      Wed        Thu         Fri     Sat      Sun
Member 4




           22 Apr   23 Apr   24 Apr     25 Apr     26 Apr   27 Apr   28 Apr




                                      May 2013
            Mon      Tue      Wed         Thu        Fri      Sat      Sun
Member 5




           29 Apr   30 Apr   01 May     02 May     03 May   04 May   05 May



            Mon       Tue     Wed         Thu        Fri      Sat      Sun
Member 1




           06 May   07 May   08 May     09 May     10 May   11 May   12 May



            Mon       Tue     Wed         Thu        Fri      Sat      Sun
Member 2




           13 May   14 May   15 May     16 May     17 May   18 May   19 May



            Mon       Tue     Wed         Thu        Fri      Sat      Sun
Member 3




           20 May   21 May   22 May     23 May     24 May   25 May   26 May




                                      June 2013
            Mon       Tue     Wed         Thu        Fri     Sat      Sun
Member 4




           27 May   28 May   29 May     30 May     31 May   01 Jun   02 Jun



            Mon      Tue      Wed        Thu         Fri     Sat      Sun
Member 5




           03 Jun   04 Jun   05 Jun     06 Jun     07 Jun   08 Jun   09 Jun



            Mon      Tue      Wed        Thu         Fri     Sat      Sun
Member 1




           10 Jun   11 Jun   12 Jun     13 Jun     14 Jun   15 Jun   16 Jun



            Mon      Tue      Wed        Thu         Fri     Sat      Sun
Member 2




           17 Jun   18 Jun   19 Jun     20 Jun     21 Jun   22 Jun   23 Jun
                                       July 2013
            Mon      Tue      Wed         Thu         Fri     Sat      Sun
Member 3



           24 Jun   25 Jun   26 Jun      27 Jun     28 Jun   29 Jun   30 Jun



           Mon       Tue     Wed          Thu        Fri      Sat      Sun
Member 4




           01 Jul   02 Jul   03 Jul      04 Jul     05 Jul   06 Jul   07 Jul



           Mon       Tue     Wed          Thu        Fri      Sat      Sun
Member 5




           08 Jul   09 Jul   10 Jul      11 Jul     12 Jul   13 Jul   14 Jul



           Mon       Tue     Wed          Thu        Fri      Sat      Sun
Member 1




           15 Jul   16 Jul   17 Jul      18 Jul     19 Jul   20 Jul   21 Jul



           Mon       Tue     Wed          Thu        Fri      Sat      Sun
Member 2




           22 Jul   23 Jul   24 Jul      25 Jul     26 Jul   27 Jul   28 Jul




                                      August 2013
           Mon       Tue     Wed          Thu         Fri      Sat     Sun
Member 3




           29 Jul   30 Jul   31 Jul      01 Aug     02 Aug   03 Aug   04 Aug



            Mon      Tue      Wed         Thu         Fri      Sat     Sun
Member 4




           05 Aug   06 Aug   07 Aug      08 Aug     09 Aug   10 Aug   11 Aug



            Mon      Tue      Wed         Thu         Fri      Sat     Sun
Member 5




           12 Aug   13 Aug   14 Aug      15 Aug     16 Aug   17 Aug   18 Aug



            Mon      Tue      Wed         Thu         Fri      Sat     Sun
Member 1




           19 Aug   20 Aug   21 Aug      22 Aug     23 Aug   24 Aug   25 Aug
You can enter the bookings here so that it will display on the calendar and the
                                                                                             The blue blocks are formulas and are for
                                 summary.
                                                                                             information purposes only, and you can
The departure date assumes that a different booking can also be made on that                delete them if you don't need them, if you
  date, since the guests will departure early that day to make room for new                want to use them, copy them down with the
                                    arrivals.                                                rest of the new bookings that you enter.

    The status column is currently accomodated to handle "reserved" and                     Be careful when printing this sheet, please
"prospect". You can change this as long as you also change the text heading on             select print preview and ensure that you only
                             the "Summary tab.                                                        print the pages you need.

    You can add bookings outside the calendar dates, this will show on the                 You can delete these information blocks if you no
           calendar later on when you change the calendar dates.                                          longer need them.

       Guest Name           Timeshare Name        Arrival Date     Dep Date       Nights      Status
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
                           Outside Calendar                                         0
are formulas and are for
poses only, and you can
u don't need them, if you
 copy them down with the
bookings that you enter.

printing this sheet, please
w and ensure that you only
 pages you need.

e information blocks if you no
er need them.
You can enter events here that you want displayed on the calendar. In the case of
                                                                                     You can delete these information
  multiple events falling on the same date, then the item with the highest item
                                                                                    blocks if you no longer need them,
  number will be displayed. A example of an event is school holidays which can
                                                                                       currently, the events calendar
   effect the bookings. Please do not edit the blue blocks as these are used to
                                                                                      can't take more than 30 events.
                        transfer the events to the calendar.


                                    Events
Item         Description            Start Date          End Date        Length
   1                                                                          1
   2                                                                          1
   3                                                                          1
   4                                                                          1
   5                                                                          1
   6                                                                          1
   7                                                                          1
   8                                                                          1
   9                                                                          1
  10                                                                          1
  11                                                                          1
  12                                                                          1
  13                                                                          1
  14                                                                          1
  15                                                                          1
  16                                                                          1
  17                                                                          1
  18                                                                          1
  19                                                                          1
  20                                                                          1
  21                                                                          1
  22                                                                          1
  23                                                                          1
  24                                                                          1
  25                                                                          1
  26                                                                          1
  27                                                                          1
  28                                                                          1
  29                                                                          1
  30                                                                          1
These are data calculations in order to make the calendar display correctly
                 Bookings       Name         Status        Event        Marker     Name     Event 1   Event 2
  25 Jun 2012             0                                                      Member 1
  26 Jun 2012             0                                                      Member 1
  27 Jun 2012             0                                                      Member 1
  28 Jun 2012             0                                                      Member 1
  29 Jun 2012             0                                                      Member 1
  30 Jun 2012             0                                                      Member 1
   01 Jul 2012            0                                                      Member 1
   02 Jul 2012            0                                                      Member 2
   03 Jul 2012            0                                                      Member 2
   04 Jul 2012            0                                                      Member 2
   05 Jul 2012            0                                                      Member 2
   06 Jul 2012            0                                                      Member 2
   07 Jul 2012            0                                                      Member 2
   08 Jul 2012            0                                                      Member 2
   09 Jul 2012            0                                                      Member 3
   10 Jul 2012            0                                                      Member 3
   11 Jul 2012            0                                                      Member 3
   12 Jul 2012            0                                                      Member 3
   13 Jul 2012            0                                                      Member 3
   14 Jul 2012            0                                                      Member 3
   15 Jul 2012            0                                                      Member 3
   16 Jul 2012            0                                                      Member 4
   17 Jul 2012            0                                                      Member 4
   18 Jul 2012            0                                                      Member 4
   19 Jul 2012            0                                                      Member 4
   20 Jul 2012            0                                                      Member 4
   21 Jul 2012            0                                                      Member 4
   22 Jul 2012            0                                                      Member 4
   23 Jul 2012            0                                                      Member 5
   24 Jul 2012            0                                                      Member 5
   25 Jul 2012            0                                                      Member 5
   26 Jul 2012            0                                                      Member 5
   27 Jul 2012            0                                                      Member 5
   28 Jul 2012            0                                                      Member 5
   29 Jul 2012            0                                                      Member 5
   30 Jul 2012            0                                                      Member 1
   31 Jul 2012            0                                                      Member 1
  01 Aug 2012             0                                                      Member 1
  02 Aug 2012             0                                                      Member 1
  03 Aug 2012             0                                                      Member 1
  04 Aug 2012             0                                                      Member 1
  05 Aug 2012             0                                                      Member 1
  06 Aug 2012             0                                                      Member 2
  07 Aug 2012             0                                                      Member 2
  08 Aug 2012             0                                                      Member 2
  09 Aug 2012             0                                                      Member 2
  10 Aug 2012             0                                                      Member 2
  11 Aug 2012             0                                                      Member 2
  12 Aug 2012             0                                                      Member 2
  13 Aug 2012             0                                                      Member 3
  14 Aug 2012             0                                                      Member 3
  15 Aug 2012             0                                                      Member 3
  16 Aug 2012             0                                                      Member 3
17 Aug 2012   0   Member 3
18 Aug 2012   0   Member 3
19 Aug 2012   0   Member 3
20 Aug 2012   0   Member 4
21 Aug 2012   0   Member 4
22 Aug 2012   0   Member 4
23 Aug 2012   0   Member 4
24 Aug 2012   0   Member 4
25 Aug 2012   0   Member 4
26 Aug 2012   0   Member 4
27 Aug 2012   0   Member 5
28 Aug 2012   0   Member 5
29 Aug 2012   0   Member 5
30 Aug 2012   0   Member 5
31 Aug 2012   0   Member 5
01 Sep 2012   0   Member 5
02 Sep 2012   0   Member 5
03 Sep 2012   0   Member 1
04 Sep 2012   0   Member 1
05 Sep 2012   0   Member 1
06 Sep 2012   0   Member 1
07 Sep 2012   0   Member 1
08 Sep 2012   0   Member 1
09 Sep 2012   0   Member 1
10 Sep 2012   0   Member 2
11 Sep 2012   0   Member 2
12 Sep 2012   0   Member 2
13 Sep 2012   0   Member 2
14 Sep 2012   0   Member 2
15 Sep 2012   0   Member 2
16 Sep 2012   0   Member 2
17 Sep 2012   0   Member 3
18 Sep 2012   0   Member 3
19 Sep 2012   0   Member 3
20 Sep 2012   0   Member 3
21 Sep 2012   0   Member 3
22 Sep 2012   0   Member 3
23 Sep 2012   0   Member 3
24 Sep 2012   0   Member 4
25 Sep 2012   0   Member 4
26 Sep 2012   0   Member 4
27 Sep 2012   0   Member 4
28 Sep 2012   0   Member 4
29 Sep 2012   0   Member 4
30 Sep 2012   0   Member 4
01 Oct 2012   0   Member 5
02 Oct 2012   0   Member 5
03 Oct 2012   0   Member 5
04 Oct 2012   0   Member 5
05 Oct 2012   0   Member 5
06 Oct 2012   0   Member 5
07 Oct 2012   0   Member 5
08 Oct 2012   0   Member 1
09 Oct 2012   0   Member 1
10 Oct 2012   0   Member 1
11 Oct 2012   0   Member 1
12 Oct 2012   0   Member 1
13 Oct 2012   0   Member 1
14 Oct 2012   0   Member 1
15 Oct 2012   0   Member 2
16 Oct 2012   0   Member 2
17 Oct 2012   0   Member 2
18 Oct 2012   0   Member 2
19 Oct 2012   0   Member 2
20 Oct 2012   0   Member 2
21 Oct 2012   0   Member 2
22 Oct 2012   0   Member 3
23 Oct 2012   0   Member 3
24 Oct 2012   0   Member 3
25 Oct 2012   0   Member 3
26 Oct 2012   0   Member 3
27 Oct 2012   0   Member 3
28 Oct 2012   0   Member 3
29 Oct 2012   0   Member 4
30 Oct 2012   0   Member 4
31 Oct 2012   0   Member 4
01 Nov 2012   0   Member 4
02 Nov 2012   0   Member 4
03 Nov 2012   0   Member 4
04 Nov 2012   0   Member 4
05 Nov 2012   0   Member 5
06 Nov 2012   0   Member 5
07 Nov 2012   0   Member 5
08 Nov 2012   0   Member 5
09 Nov 2012   0   Member 5
10 Nov 2012   0   Member 5
11 Nov 2012   0   Member 5
12 Nov 2012   0   Member 1
13 Nov 2012   0   Member 1
14 Nov 2012   0   Member 1
15 Nov 2012   0   Member 1
16 Nov 2012   0   Member 1
17 Nov 2012   0   Member 1
18 Nov 2012   0   Member 1
19 Nov 2012   0   Member 2
20 Nov 2012   0   Member 2
21 Nov 2012   0   Member 2
22 Nov 2012   0   Member 2
23 Nov 2012   0   Member 2
24 Nov 2012   0   Member 2
25 Nov 2012   0   Member 2
26 Nov 2012   0   Member 3
27 Nov 2012   0   Member 3
28 Nov 2012   0   Member 3
29 Nov 2012   0   Member 3
30 Nov 2012   0   Member 3
01 Dec 2012   0   Member 3
02 Dec 2012   0   Member 3
03 Dec 2012   0   Member 4
04 Dec 2012   0   Member 4
05 Dec 2012   0   Member 4
06 Dec 2012   0   Member 4
07 Dec 2012   0   Member 4
08 Dec 2012   0   Member 4
09 Dec 2012   0   Member 4
10 Dec 2012   0   Member 5
11 Dec 2012   0   Member 5
12 Dec 2012   0   Member 5
13 Dec 2012   0   Member 5
14 Dec 2012   0   Member 5
15 Dec 2012   0   Member 5
16 Dec 2012   0   Member 5
17 Dec 2012   0   Member 1
18 Dec 2012   0   Member 1
19 Dec 2012   0   Member 1
20 Dec 2012   0   Member 1
21 Dec 2012   0   Member 1
22 Dec 2012   0   Member 1
23 Dec 2012   0   Member 1
24 Dec 2012   0   Member 2
25 Dec 2012   0   Member 2
26 Dec 2012   0   Member 2
27 Dec 2012   0   Member 2
28 Dec 2012   0   Member 2
29 Dec 2012   0   Member 2
30 Dec 2012   0   Member 2
31 Dec 2012   0   Member 3
01 Jan 2013   0   Member 3
02 Jan 2013   0   Member 3
03 Jan 2013   0   Member 3
04 Jan 2013   0   Member 3
05 Jan 2013   0   Member 3
06 Jan 2013   0   Member 3
07 Jan 2013   0   Member 4
08 Jan 2013   0   Member 4
09 Jan 2013   0   Member 4
10 Jan 2013   0   Member 4
11 Jan 2013   0   Member 4
12 Jan 2013   0   Member 4
13 Jan 2013   0   Member 4
14 Jan 2013   0   Member 5
15 Jan 2013   0   Member 5
16 Jan 2013   0   Member 5
17 Jan 2013   0   Member 5
18 Jan 2013   0   Member 5
19 Jan 2013   0   Member 5
20 Jan 2013   0   Member 5
21 Jan 2013   0   Member 1
22 Jan 2013   0   Member 1
23 Jan 2013   0   Member 1
24 Jan 2013   0   Member 1
25 Jan 2013   0   Member 1
26 Jan 2013   0   Member 1
27 Jan 2013   0   Member 1
28 Jan 2013   0   Member 2
 29 Jan 2013   0   Member 2
 30 Jan 2013   0   Member 2
 31 Jan 2013   0   Member 2
01 Feb 2013    0   Member 2
02 Feb 2013    0   Member 2
03 Feb 2013    0   Member 2
04 Feb 2013    0   Member 3
05 Feb 2013    0   Member 3
06 Feb 2013    0   Member 3
07 Feb 2013    0   Member 3
08 Feb 2013    0   Member 3
09 Feb 2013    0   Member 3
10 Feb 2013    0   Member 3
11 Feb 2013    0   Member 4
12 Feb 2013    0   Member 4
13 Feb 2013    0   Member 4
14 Feb 2013    0   Member 4
15 Feb 2013    0   Member 4
16 Feb 2013    0   Member 4
17 Feb 2013    0   Member 4
18 Feb 2013    0   Member 5
19 Feb 2013    0   Member 5
20 Feb 2013    0   Member 5
21 Feb 2013    0   Member 5
22 Feb 2013    0   Member 5
23 Feb 2013    0   Member 5
24 Feb 2013    0   Member 5
25 Feb 2013    0   Member 1
26 Feb 2013    0   Member 1
27 Feb 2013    0   Member 1
28 Feb 2013    0   Member 1
01 Mar 2013    0   Member 1
02 Mar 2013    0   Member 1
03 Mar 2013    0   Member 1
04 Mar 2013    0   Member 2
05 Mar 2013    0   Member 2
06 Mar 2013    0   Member 2
07 Mar 2013    0   Member 2
08 Mar 2013    0   Member 2
09 Mar 2013    0   Member 2
10 Mar 2013    0   Member 2
11 Mar 2013    0   Member 3
12 Mar 2013    0   Member 3
13 Mar 2013    0   Member 3
14 Mar 2013    0   Member 3
15 Mar 2013    0   Member 3
16 Mar 2013    0   Member 3
17 Mar 2013    0   Member 3
18 Mar 2013    0   Member 4
19 Mar 2013    0   Member 4
20 Mar 2013    0   Member 4
21 Mar 2013    0   Member 4
22 Mar 2013    0   Member 4
23 Mar 2013    0   Member 4
24 Mar 2013    0   Member 4
25 Mar 2013    0   Member 5
26 Mar 2013    0   Member 5
27 Mar 2013    0   Member 5
28 Mar 2013    0   Member 5
29 Mar 2013    0   Member 5
30 Mar 2013    0   Member 5
31 Mar 2013    0   Member 5
 01 Apr 2013   0   Member 1
 02 Apr 2013   0   Member 1
 03 Apr 2013   0   Member 1
 04 Apr 2013   0   Member 1
 05 Apr 2013   0   Member 1
 06 Apr 2013   0   Member 1
 07 Apr 2013   0   Member 1
 08 Apr 2013   0   Member 2
 09 Apr 2013   0   Member 2
 10 Apr 2013   0   Member 2
 11 Apr 2013   0   Member 2
 12 Apr 2013   0   Member 2
 13 Apr 2013   0   Member 2
 14 Apr 2013   0   Member 2
 15 Apr 2013   0   Member 3
 16 Apr 2013   0   Member 3
 17 Apr 2013   0   Member 3
 18 Apr 2013   0   Member 3
 19 Apr 2013   0   Member 3
 20 Apr 2013   0   Member 3
 21 Apr 2013   0   Member 3
 22 Apr 2013   0   Member 4
 23 Apr 2013   0   Member 4
 24 Apr 2013   0   Member 4
 25 Apr 2013   0   Member 4
 26 Apr 2013   0   Member 4
 27 Apr 2013   0   Member 4
 28 Apr 2013   0   Member 4
 29 Apr 2013   0   Member 5
 30 Apr 2013   0   Member 5
01 May 2013    0   Member 5
02 May 2013    0   Member 5
03 May 2013    0   Member 5
04 May 2013    0   Member 5
05 May 2013    0   Member 5
06 May 2013    0   Member 1
07 May 2013    0   Member 1
08 May 2013    0   Member 1
09 May 2013    0   Member 1
10 May 2013    0   Member 1
11 May 2013    0   Member 1
12 May 2013    0   Member 1
13 May 2013    0   Member 2
14 May 2013    0   Member 2
15 May 2013    0   Member 2
16 May 2013    0   Member 2
17 May 2013    0   Member 2
18 May 2013    0   Member 2
19 May 2013     0   Member 2
20 May 2013     0   Member 3
21 May 2013     0   Member 3
22 May 2013     0   Member 3
23 May 2013     0   Member 3
24 May 2013     0   Member 3
25 May 2013     0   Member 3
26 May 2013     0   Member 3
27 May 2013     0   Member 4
28 May 2013     0   Member 4
29 May 2013     0   Member 4
30 May 2013     0   Member 4
31 May 2013     0   Member 4
 01 Jun 2013    0   Member 4
 02 Jun 2013    0   Member 4
 03 Jun 2013    0   Member 5
 04 Jun 2013    0   Member 5
 05 Jun 2013    0   Member 5
 06 Jun 2013    0   Member 5
 07 Jun 2013    0   Member 5
 08 Jun 2013    0   Member 5
 09 Jun 2013    0   Member 5
 10 Jun 2013    0   Member 1
 11 Jun 2013    0   Member 1
 12 Jun 2013    0   Member 1
 13 Jun 2013    0   Member 1
 14 Jun 2013    0   Member 1
 15 Jun 2013    0   Member 1
 16 Jun 2013    0   Member 1
 17 Jun 2013    0   Member 2
 18 Jun 2013    0   Member 2
 19 Jun 2013    0   Member 2
 20 Jun 2013    0   Member 2
 21 Jun 2013    0   Member 2
 22 Jun 2013    0   Member 2
 23 Jun 2013    0   Member 2
 24 Jun 2013    0   Member 3
 25 Jun 2013    0   Member 3
 26 Jun 2013    0   Member 3
 27 Jun 2013    0   Member 3
 28 Jun 2013    0   Member 3
 29 Jun 2013    0   Member 3
 30 Jun 2013    0   Member 3
  01 Jul 2013   0   Member 4
  02 Jul 2013   0   Member 4
  03 Jul 2013   0   Member 4
  04 Jul 2013   0   Member 4
  05 Jul 2013   0   Member 4
  06 Jul 2013   0   Member 4
  07 Jul 2013   0   Member 4
  08 Jul 2013   0   Member 5
  09 Jul 2013   0   Member 5
  10 Jul 2013   0   Member 5
  11 Jul 2013   0   Member 5
  12 Jul 2013   0   Member 5
 13 Jul 2013   0   Member 5
 14 Jul 2013   0   Member 5
 15 Jul 2013   0   Member 1
 16 Jul 2013   0   Member 1
 17 Jul 2013   0   Member 1
 18 Jul 2013   0   Member 1
 19 Jul 2013   0   Member 1
 20 Jul 2013   0   Member 1
 21 Jul 2013   0   Member 1
 22 Jul 2013   0   Member 2
 23 Jul 2013   0   Member 2
 24 Jul 2013   0   Member 2
 25 Jul 2013   0   Member 2
 26 Jul 2013   0   Member 2
 27 Jul 2013   0   Member 2
 28 Jul 2013   0   Member 2
 29 Jul 2013   0   Member 3
 30 Jul 2013   0   Member 3
 31 Jul 2013   0   Member 3
01 Aug 2013    0   Member 3
02 Aug 2013    0   Member 3
03 Aug 2013    0   Member 3
04 Aug 2013    0   Member 3
05 Aug 2013    0   Member 4
06 Aug 2013    0   Member 4
07 Aug 2013    0   Member 4
08 Aug 2013    0   Member 4
09 Aug 2013    0   Member 4
10 Aug 2013    0   Member 4
11 Aug 2013    0   Member 4
12 Aug 2013    0   Member 5
13 Aug 2013    0   Member 5
14 Aug 2013    0   Member 5
15 Aug 2013    0   Member 5
16 Aug 2013    0   Member 5
17 Aug 2013    0   Member 5
18 Aug 2013    0   Member 5
19 Aug 2013    0   Member 1
20 Aug 2013    0   Member 1
21 Aug 2013    0   Member 1
22 Aug 2013    0   Member 1
23 Aug 2013    0   Member 1
24 Aug 2013    0   Member 1
25 Aug 2013    0   Member 1
Event 3   Event 4   Event 5   Event 6   Event 7   Event 8   Event 9   Event 10   Event 11
Event 12   Event 13   Event 14   Event 15   Event 16   Event 17   Event 18   Event 19   Event 20
Event 21   Event 22   Event 23   Event 24   Event 25   Event 26   Event 27   Event 28   Event 29
Event 30   Marker
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
                    0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

				
DOCUMENT INFO
Stats:
views:43
posted:7/21/2012
language:English
pages:61
Description: This spreadsheet will help you keep track of your timeshare bookings. It includes the following: A sheet where you enter bookings. A calendar that shows Date/Day of the Week/Timeshare Holder/Bookings/Events. Ability to allocate weeks easily. A sheet where you can add relevant events (School Holidays). A summary sheet that displays information for each timeshare holder. Ability to add and remove timeshare holders. Instructions on how to use the spreadsheet. Easily changeble dates on calendat. A calendar which is arranged by weeks and is updated completely automatically. Make bookings outside the calendar, which will update automatically when the date changes, the same applies to events. This spreadsheet shows a standard layout on the calendar, there is another spreadsheet which will display each timeshareholder separately in its own colour so that you only view the information relevant to you, but this has a maximum of 5 to 10 timeshare holders.