Home

Welcome to the Shift Roster Generator wiki!

This Wiki-Page will show you how to use the Shift Roster Generator.

How-To

Your inital Shift Plan with all Candidates who need to be distributed:

Save the sheet as .CSV File:

In this example, we saved the table-sheet (excel, openoffice, libeoffice, etc.) as "ShiftPlan_Candidates.csv". Please make shure, that a SEMICOLON-SEPERATED .CSV File will be generated!

Open a terminal and start executable by adding two arguments like:

Executable will create a output file with the name "ShiftPlan_Final.csv" (set by second argument).

Generated outfile "ShiftPlan_Final.csv"

If you prefer the result of generation in standard output of the terminal, you can leave the second argument.

Open a terminal and start executable with only one argument:

You will see the result as .CSV structure. By using pipes, you can redirect the output into a file. Your output file should end with .csv so your OS will recognize it as a file, which can be opened by a spreadsheet program.

If you open the result .CSV File, you will see a sheet like:

Your shift plan is generated and the candidates should be fair distributed.

Sheet-Structure

Your sheet need a fix defined structure:

• the first line of your sheet must contain the column-titles

• the first column of each tow must contain the row-title

• there aren't allowed data outside the range of your sheet. The column- and row-titles are spanning the table-range. Data are allowed in that spanned range only. Data outside of that range will lead to incorrect results! So make shure, that every data has a column- and a row-title.

There are three reported bugs:

1. Please don't use double quotes in your sheet. the application don't support double quotes as data value. The use of double quotes leads to incorrect results!

2. Please don't use newlines in the last column of a row. The application accepts newlines in each column, but newlines in the last column leads to incorrect results.

Bugs

There are three reported bugs:

1. Please don't use double quotes in your sheet. the application don't support double quotes as data value. The use of double quotes leads to incorrect results!

2. Please don't use newlines in the last column of a row. The application accepts newlines in each column, but newlines in the last column leads to incorrect results.