2008 Cookie Finder by HC120705064654

VIEWS: 4 PAGES: 19

									Cookie Booth Finder


Booth Manager (Admin) Training
                  For Cookie Sale 2009

               The Booth Finder will be LIVE
  March 2, 2008 (1 week before public sale) - March 22, 2008
  Website Address
www.CookieFinder.org
Last Year’s Stats at a Glance

   • 3,702 Booth Sales in the System
   • 14,654 Hits on Cookie Finder
   • 10,077 Unique Visitors to Cookie Finder
   • 8,604 Searches
   • 289 Cities Searched
            How Does it Work?
                        Overview

1) CREATE AN EXCEL SPREADSHEET of “booth
   locations” and “booth dates & times” in the exact format
   provided.

2) EMAIL THE SPREADSHEET to
   productsales@girlscoutsnorcal.org by February 16,
   2009. The FIRST BATCH of booth sales will be ADDED
   BY COUNCIL.
3) REVIEW, ADD, AND MAKE CHANGES to booth
   locations and times throughout the sale starting MARCH
   3, 2009
1) CREATE AN EXCEL
  SPREADSHEET
                    Overview Spreadsheet
                            Spreadsheet Template can be downloaded at
                               www.GirlScoutsNorCal.org/boothsetup
                 (use the username and password you are given at the training – or call your local
                       council office to speak to a product sales representative to obtain one)
                                     Cells are referenced by their column label
    Columns are labeled A, B, C, etc…and then their row number
                     Columns                                  Cell “C2”
                   (A, B, C etc…)                         (Column C, Row 2)

                                                                                               Header Row
   Rows                                                               The header row gives each column
(1, 2, 3 etc…)
                                                                      a title.
 Rows are numbered 1, 2, 3, etc…




                                     Sheets
                       There are 2 Sheets in this spread sheet. One for “Booth Locations”
                       (addresses), and one for the “Booth Sales” (dates and times)
Separate Locations from Dates & Times
 Since there are MANY BOOTH DATES AND TIMES FOR EACH
BOOTH LOCATION, this system separates booth sale locations from
                   booth sale dates & times.


 The result is a system that is MORE EFFICIENT for the computer
   that’s powering it, as well as you in terms of data-entry time.


 You will only have to ENTER THE SPECIFICS OF A LOCATION
ONCE (name, address etc.), which will assign it an ID number. You’ll
 then assign a location to each booth sale by using the location ID
    number. The next slides explain this process in more detail.


   Also, ANY CHANGES TO THE LOCATION WILL BE COPIED
      AUTOMATICALLY across all booth sales at that location.
 Add Booth Locations to Spreadsheet
Start by entering all booth locations onto the “Booth Locations” sheet.




                                                         Booth Locations


NOTE: Use one line per address.                  For locations with booth sales on multiple floors,
sides of an intersection, or common areas like BART Stations use more than one line with a
different name on each line, ex: “Powel St. BART - Flower Stall” & “Powel St. BART - North
Stairwell”. DO NOT CHANGE THE NUMBER IN THE ID COLUMN



For each location enter:                                 • City
     • Service Unit Name                                 • State
     • Name of Booth Location                            • Zip Code
     (give each location a DIFFERENT name)
     • Address                                           • DOT NOT CHANGE
                                                         NUMBER IN THE ID COLUMN
     Add Booth Sales to Spreadsheet


                                                           Booth Sales


1)   Print Out the “Booth Locations” sheet for reference

2)   Click on the “Booth Sales” tab (bottom) to switch to the “Booth Sales” sheet.

3)   Type the Location ID number in the column titled “ENTER LOCATION ID”
     (look-up location ID numbers on your Booth Locations print-out). This will
     automatically find the Location Name from the “Booth Locations” sheet.

4)   Add the booth date, times, and troop number (troop numbers are for your
     reference only, they will not be posted online)

5)   Repeat for all Booth Sales
2) EMAIL THE SPREADSHEET TO
productsales@girlscoutsnorcal.org
 3) REVIEW, ADD, AND MAKE
CHANGES Starting March 3, 2009
www.GirlScoutsNorCal.org/boothsetup
                            Log In
1. Open your web browser (Internet Explorer, Firefox, Safari, etc.)
   and go to www.GirlScoutsNorCal.org/boothsetup




2. Type in your username and password. Your username and
   password will be given to you during training, or you can call your
   local council office and speak with the product sales
   representative.
The Cookie Booth Set-Up Home Page
From the homepage you can Set-up New Booth Locations (most locations
should already be set-up by March 3, 2008), Set-Up New Booth
Dates/Times, and Edit previously Set-Up Booth Dates/Times or “Check
Your Work”.




  Click the button labeled “Check Your Work” to review booth data
        Find Cookie Booth Dates/Times




1. Scroll down to the section labeled “Find/Edit Cookie
   Booth Dates/Times”
2. Choose the dates, service unit, or troop number for
   which you would like to limit your results.
3. Click on “Find Booth Sales.”
           The Booth Sale Detail Page
                You can sort the results by Troop, Service
                Unit, Location, Date, Start Time & End Time
                by clicking on the column header




Make any changes necessary and click on “Update Booths”
  Set-Up New Booth Sales & Locations
1. Please check to MAKE SURE the booth sales you want
   to add are not already in the system. The booth sale
   spreadsheet you sent to the council will add the bulk of
   booth sales into the system. If you don’t see booth sales
   that should already have been added, please email
   jvoytek@girlscoutsnorcal.org

2. Booth Locations only need to be set-up once. This means
   that if you need to add a booth to a location that you
   included on your spreadsheet to council, you do not have
   to set up that location again.

3. To add NEW booth sale locations please follow the
   instructions on the Cookie Booth Set-Up Instructions (PDF)
   available at www.GirlScoutsNorCal.org/boothsetup
                    Questions?
Local product sales staff members are available to help.
                          OR
         Email the webmaster Jessica Voytek
             jvoytek@girlscoutsnorcal.org (preferred)
                 or call (510) 562-8470 ext. 160

A copy of this presentation and other documentation will be
                   available for download at
           www.GirlScoutsNorCal.org/boothsetup



      Thank YOU for volunteering!

								
To top