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 in the terminal 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 row 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.

All Tabulators, Single-Quotes, Double-Quotes, Newlines and SEPERATOR-Characters will be removed in all Data-Columns (Candidate-Values)!