Secure Order
Software is provided as shareware with a free 7 day evaluation period. If you find this software useful or maintain it beyond the evaluation period payment of US$68.00 is required. Payment is online at http://www.busysoftorder.com/prog/bizpep/shift.htm
The Shift Scheduler will build a roster structure to your specifications, allocate staff, and generate a printable roster, all at the click of a button. It is compact and user friendly allowing you to add staff and shifts (maximum 150) with ease. Default values for continuous shifts mean that the only shift data required is the start date/time and length for the first shift, everything else is automated. For non-continuous or varying shifts you have the capacity to overwrite default data and structure shift settings to suit your specific requirements.
Constraints you can apply when allocating staff include the maximum hours a staff member can work within the roster period, the maximum continuous work hours, the minimum break between shifts, and the maximum number of days in a row that can be worked. You can also set a Yes or No work status to define a must work or must not work requirement. Your roster is printed using standard Excel commands or using the Format Print function to build a compact and easy to read roster schedule table. The Next Roster function allows you to roll roster details into the next roster period to quickly build consecutive rosters.
You can add or delete Shifts and Staff by selecting the required staff row or shift column to delete or the required insert row/column to add and then clicking the applicable Add Shift, Delete Shift, Add Staff, or Delete Staff button. The first staff row and the first 5 shifts can not be deleted. When you Add you will be asked how many shifts or staff to add, this is in addition to existing shifts and staff. When you select a cell within the roster matrix staff are added above it and shifts to the left. If there is no selection in the roster matrix staff are added to the top and shifts at the end of the roster matrix. The maximum number of shifts is 150.
In the blue cells of the first shift column input the Start Date/Time, the Length and the Shift Requirement (i.e the number of staff required to work this shift) for the first shift. The Start Time is in 24 hour format (hh:mm), the shift Length is in hours decimal format (1.5 is one and a half hours). Initial formula set the following shift details to follow on from the first shift with the same Length and Shift Requirement. If your shifts are not continuous or vary you can adjust the details in the yellow cells for each individual shift. Shifts should be set up in their Start order. Input a Title for your roster in the blue cell above the shift columns.
You can set a Yes or No work requirement by inputting a "Y" or "N" to mark a matrix cell before you Build Roster. For example if your first staff member cannot work your first shift input a "N" in the cell where the first staff row and the first shift column intersect (D24). If the first staff must work the first shift input a "Y". Marked cells only operate for 1 Build Roster and are then cleared to allow a new roster.
These are the limits applied in the roster. Input the limit values in the blue cells of the top table.
Maximum number of Hours staff members can work during the roster period. You can use Maximum hours to distribute shifts between staff. For example if you have 4 shifts of 8 hours with a shift requirement of 1 and 4 staff when you set Maximum Hours to 8 Build Roster will attempt to allocate 1 shift to each staff member. If there is no maximum then input a number greater than the total roster period.
Maximum number of Continuous (without a break) Hours staff members can work during the roster period. For this to apply you must also input Minimum Break Hours greater than 0. If there is no maximum then input a number greater than the total roster period.
Minimum Break in Hours staff members must have after completing a shift or group of shifts before they can work another shift. If there is no minimum then input 0. A staff member can work consecutive shifts without a break as long as the Maximum Continuous Hours limit is not exceeded or Minimum Break Hour is 0. Once a break starts a staff member cannot work another shift until the Minimum Break duration has passed.
Maximum Number of Days a staff member can work in a row. This the maximum number of days that can be worked before a full days break must be taken. If a staff member works any part of a day it is counted as a worked day.
Number of Build Attempts that should be made. Initially start with a Build Attempts value of 5 if a roster solution is not found increase the number of attempts. A random process is applied to solve the roster and it can follow a dead end path. The Build Attempts value allows it to exit the dead end and retry. When you Build Roster the Build Attempt number is displayed as the first character in the status line. As roster complexity increases more Build Attempts are required, this can increase the build time.
After you have added the required details for your roster period click Build Roster to identify a staff/shift allocation that meets your requirements. Staff members required to work a shift will be identified with "YES" in the shift column. Requirements that cannot be fulfilled are shaded tan. Program status is displayed at bottom of the window. To Exit Build Roster before it is complete press the Esc (escape) key. If you Exit in this way you should then Clear Roster to clear roster calculations. Build duration depends on roster complexity and the random process applied, the range is usually 1 to 10 minutes. Build Attempts is the number of times a solve will be attempted within one build roster, default value is 5. Complex rosters require more build attempts. Regardless of the build attempts setting the Build Roster will end as soon as a solution is found. Reset Roster removes all added shifts and staff and resets the roster to initial default values.
To maintain Staff and Shift headings while scrolling through your roster you can Freeze Panes. Select the cell below and to the left of the cells you wish to keep in view then from the Excel Toolbar go Window, Freeze Panes.
You can Print your roster using the standard Excel commands to print sections of the Input Sheet as displayed. To set the print area from the Excel Toolbar go View, Page Break Preview or use File, Print Area, Set Print Area. Format Print transfers Staff and Shift details to the Format Print sheet. Format Print builds a table with Staff Names in the rows and Day Names in the columns 7 columns wide (1 week). The title of each shift a staff member is to work is displayed in the Staff/Day matrix. The Format Print sheet is only updated with the current roster details when the Format Print command button is used. The Format Print sheet is not protected and all formatting can be adjusted as required. You can also copy and save the Format Print sheet in a new Excel workbook. To do this open a new workbook, highlight and copy the required area on the Format Print sheet, and then paste to the new workbook.
Next Roster allows you to roll your roster details into the next period. It applies current last shift details as input for the next roster period except cumulative hours worked which are reset to 0, maintains existing staff and shift inputs, and clears shift allocations. Start Date and Time of the first shift are set as the end of the last shift in the current roster. This allows you to build a roster for the next period considering the current roster.
Show Detail displays any roster Initiation set by the Next Roster function and the Calculation Rows for each staff line. Examining the these details will assist understanding of roster formulation. Hide Details hides Initiation and Calculation details. To clear the Initiation settings use Clear Next, this only clears the Next Roster function Initiation settings on the Input sheet not the staff or shift details.
Conditions of use apply to all Bizpep and bizpeponline.com services, software, and information presented. They cover Bizpep, bizpeponline.com and all principles, employees, distributors and other associated parties. Use acknowledges acceptance. Full copyright is maintained by Bizpep.
Software is provided free for 7 day evaluation. If you find this software useful or maintain it beyond the evaluation period payment is required. Print and Save functions are restricted during Evaluation. All other features including cell and macro protection are the same in evaluation and registered software. All non-input cells and macros remain protected to ensure the integrity of the formula and programming.
This software is in Microsoft Excel format. To run this software you must have Excel installed on your computer and macros must be enabled.
If the file you downloaded has an exe extension (***.exe) it includes a Setup program. To install run the Setup program and follow the prompts to unpack and install the software. You can then run the software from the program icons or by simply opening the Excel file (***.xls).
If the file you downloaded has a zip extension (***.zip) it is packaged in a standard compressed zip file. After download it must be unzipped. Trial Zip software is available free from www.winzip.com. You can then run the software by simply opening the Excel file (***.xls).
If the file you downloaded has an Excel extension (***.xls) it is a standard Excel file. You can run the software by simply opening the Excel file (***.xls).
The first time you open the Excel file a Welcome page is displayed, clicking the Access button on the Welcome page displays the software input sheet. For the software to function macros must enabled.
No system files are changed when you use this software. To uninstall run the Uninstall program or simply delete all associated files.
If you find this software useful or maintain it beyond the evaluation period payment is required. If payment is not provided all software must be deleted. Payment is online at:
http://www.busysoftorder.com/prog/bizpep/shift.htm
Upon receipt of payment Bizpep will provide by return email registration code to fully enable evaluation software. Registering software removes restrictions on Print and Save functions. All other features including cell and macro protection are the same in evaluation and registered software. All non-input cells and macros remain protected to ensure the integrity of the formula and programming. When you have your registration code click the Registration Button on the Terms and Conditions or Thank You sheet and follow the prompts.
Payment gives you license to use software on one system, for one user. The license is for non-commercial private and internal business use only. This license does not cover the commercial use of software for inter-business support, advice, or consulting.
Bizpep offer support for operation and application of registered software. Simply email your registration details and an outline of your question to support at bizpeponline.com
If this software does not fully encompass all your requirements consider our Software and Model Design service. Designing a solution specifically to cover your needs can provide increased functionality and flexibility.
Bizpep retain all intellectual property rights. It is prohibited to use the software, concepts, formats, and systems obtained from Bizpep in any manner outside their intended use as designed and defined by Bizpep. You may not modify, translate, reverse engineer, decompile, disassemble or create derivative works based on Bizpep software, services or concepts.
Bizpep provide tools to support business. The specific suitability of these tools must be independently assessed. Services including software, concepts, formats, and systems are provided as is and with no warranties of any kind, whether expressed or implied. The user must assume the entire risk of using Bizpep software or services, and agrees to hold Bizpep harmless from any claims or losses relating to service or software use. In no event shall Bizpep, its principals, distributors, employees, or other associated parties, be liable for any incidental, consequential, or punitive damages whatsoever relating to software or service use. In addition use of software and services is entirely at the users risk, and use acknowledges that Bizpep is held harmless from any claims or losses relating to software or services provided.
You may freely distribute this software in evaluation form without registration codes. Any software distributed must require the user to provide payment to Bizpep to maintain software beyond the evaluation period as originally designed. You may not sell or require payment in any form for Bizpep software. Evaluation software must be distributed without cost or penalty to the user.
All rights of any kind which are not expressly granted are entirely and exclusively reserved to and by Bizpep
Examples (file size : 48KB)
Secure Order
| Additional Information: Shift Scheduler Continuous | |
|
30 day Money back guarantee! Software is written with Excel 2000/2002 but most software features should run on Excel versions from 97 on. OS : Windows 9x/Me/NT/2000/XP |
|
|
$68.00 |
|
Business & Finance
Material Resources Planning Systems Accounting Amortization Business Business Plan Automation Finance
Info Managers Inventory Systems Bar Code Fonts Legal Planners/Schedulers Presentation Tools
Project Management Internet Marketing
Management Systems (
Real Estate Vehicles Venture Capital
Business Using Mail, Phone, or Email
Publishing Gem Management Rental Repair Travel )
Software for MS Excel (Accounting Analysis Budgeting Calculators Cars Charting Checks Converters E-Books Finance Forecasting Employment Inventory Investment Management Marketing Planners Project Management Quality Control Schedulers )