iHelp – Worksheet

Add Google Calendar to Worksheet

 

Service Worksheet

The Worksheet is the hub of WorshiPlanner.  It is a series of independent lines  linked to Library, Songs, or Member databases.  Label a line Call to Worship on the left side, Adult Choir on the right side, and use the Library database.  Edit this line, and the Music Library appears on the screen. Double-click to select a song and it is entered on this line.  When the song title is in the worship order, its history usage is tracked.

The basic unit of the Service Worksheet is the line.  Each line is associated with a database (Library, Songs, or Members).

The Worksheet by the Numbers

  1. Left Line Heading – double click to change line – right click to insert or delete a line
  2. Center Value – double click to select song or person
  3. Right Value – double click to select song or person
  4. Services Click to select service to edit
  5. Edit Notes and Cues for Flow Charts double click to enlarge
  6. Multi-Week Planning – select date range to insert songs and people
  7. Service Ideas/Notes – sticky notes for service ideas/notes to for Flow Charts
  8. Database – reveals which database supports this line
  9. Event Time – edit estimated time for this event
  10. Service Start Time – must be entered for event time calculations
  11. Reports – service flow, instrumental notes, etc.  text lists, roadmaps, web links
  12. Tools – duplicate or delete services, view all service data, search
  13. Move lines – change the order of service lines
  14. History Panel – displays history for this song or person
  15. Teams and Bands – select praise teams, bands and tech teams for services
  16. Dropbox Links – Displays PDF, Mp3 or Folder links
  17. Service Theme – Enter a theme for this service
  18. Newsletter – Open the Newsletter Setup form or Go to Rehearsals

 

Double Clicking

Double clicking opens the many forms that are behind the Worksheet.  Nearly every area of the Worksheet has double click zones.

When the center of a line is double clicked, a list of songs or people appear for you to select.  These are called Song Pick, Library Pick, or Member Pick forms. By double-clicking a song title or soloist’s name, that data is immediately entered on the Worksheet.  To erase a selected song or name, either select another to replace it, or replace the entire line.

When the Right side of a line is double-clicked, the Select Line Form is opened.

Select Line Form

SelectLine

  • Double click Left Line Heading to view this form
  • Choose what kind of line you want this line to be.
  • Select by Double-Clicking the line
  • To erase a selected song title or member name, select the same line type to overwrite the line

Edit Line List

EditLineType

  • After opening the Select a Line form, click Edit Lines
  • Select the line to edit from the list in #1
  • Best to edit existing lines that you will never use than create an over-abundance of extra lines
  • When done, click the X in the Red box.

Duplicating Worship Orders

WS Copy

  • Select the Worship Order to copy
  • Open the Tools menu
  • Click the Copy current worship order button
  • Type the number of weeks you wish to duplicate (usually 13 to 52 weeks)
  • Enter the starting date for duplication by pressing the date on the Calendar
  • Be sure to give the correct starting date, and the computer will add the correct dates to each of the Worship orders created.

Create Service Template from Scratch

  • Click New (Worship Order)
  • This creates a blank service with 2 lines (you will need to double click and select the kind of line you want)
  • Type the title of your worship service or select Title from the list
  • Select AM, PM M1, M2 or This will identify the service in which the song is used
  • Right-Click a line to open the pop-up menu and click Insert Line
  • Double click the left side of the new line to open the Select a Line form
  • Select the line by double-clicking
  • Repeat the last 3 steps to complete your template

Calculate Event Times

  • Enter event times for each line
  • Enter a service Start time
  • Click the event time for the top line
  • Click the right side of the top line to calculate

WS Time

Popup Menu

Activated by Right-Clicking

WS Popup

Create Service Template from Existing Service

The easiest way to create a template is to start with an existing service.

  • Open the service you want to use
  • Click the Worksheet Tools button
  • Copy the service to today’s date
  • Close the service and re-open Service Worksheet
  • Double-click the first line that has a song or member
  • Replace that line with the line that matches it in the Select a Line form
  • Repeat the last 2 steps to complete your template
  • The service is ready to copy
  • After copy you can add the word Template to the title of this service, or delete it.

Worksheet Reports

Most reports are available in multiple formats.  emailing a PDF report is a on1 step process that creates the PDF, opens the Email component, and attaches the PDF to the email.

WS Reports
Worksheet Report

  1. Select Report – click to slect
  2. Edit Fonts, Alignment, etc.
  3. Select the Team Folder in Dropbox on this computer
  4. Select the Team Folder in Dropbox on the Internet
  5. Click to Open the Team Folder on your Internet Dropbox account
  6. Select Mode of Report

Teams and Bands

This module is for selecting team members for Praise Team or Band, Tech Teams, etc. Once a Team is selected, a Red ball appears on the View Teams button below the Teams and Bands button.

WS Teams

  • Requires groups in Membership that include the words Team, Tech or Band
  • Team lists can be included on Worksheet Reports
  • Select Team on left
  • At the top of a black box under the date, click to drop a list of teams and bands
  • Select group for this box
  • Drag and Drop members from the 2nd column to your box
  • To include the entire group, click the icon next to the trash can at the right of the top of the black box
  • To Clear the list, click Clear All
  • To remove one member, click their name and then the trash can at the bottom of the box

Email or Text Team

For everyone on a team this Sunday, use the Email or Text button at the top of the page.  To send to just selected members on one team, use the Email or Text button on that box.

History Pane

The History Pane appears on the right when a song or member name is touched in the Pick Form for that database, or a line is touched where a song or member has been added. If ever a wrong song title or member name appears in the History Pane, it means that the song title or member name was not selected from the list in the Pick Form, but was typed or pasted there.

Service Ideas

WS Ideas

Service Ideas can be stored by clicking the Light Bulb on the bottom right. When an idea is entered, the Light Bulb turns on.

Multi-Week Plans

Somewhere, every choir director keeps a list of upcoming songs. This is the easy way, assuming you have duplicated services into the future.

  • Click the button (Library, Soloists, or Songs)
  • Select the To Date
  • Every line from every service in the date range with that database will display
  • Add songs or members as in the Worksheet
  • Reports of your choices are available at the top of this form
  • Newly added data will appear in the appropriate Service Worksheet

Scroll Up