Schedule Body

Schedule Body

The schedule body is simply a spreadsheet. The engine behind the application makes use of the relationship between your scheduled shifts and associated hours providing powerful features and analysis.

Names of staff go in the left-hand column and shift abbreviations go in the other columns for the date range of the schedule.

schedule body

To navigate around the spreadsheet, you can use the arrow keys, tab and enter just as you would in other spreadsheet applications.

Enter Schedule Information

To enter schedule information, select a cell and begin typing.

typing in cell

Highlighting

Highlighting of cells can be done by clicking (and holding down click) while dragging over the range of cells you wish to highlight. Here we're highlighting the 7 shift abbreviations coinciding with the 7am to 3pm shifts for Amy during the first week of January.

highlighting cells

Copy/Paste/Delete

Within the Spreadsheet

With those cells still highlighted, we can click the copy button, select the cell that will mark the beginning of where we want the copied values to be pasted and click the paste button. Highlighting for copying, pasting and deleting speeds up workflow when creating or making changes to a schedule.

copy and paste highlighted cells

From Another Source

We can copy and paste from another source such as an Excel or Google spreadsheet, for example. To do so, select and copy (ctr+c or cmd+c) the range from the source spreadsheet to copy it to your computer's clipboard. Then select the cell of the starting position in One Click Schedule and paste (ctr+p or cmd+p).

Copy Paste From Excel or Google Spreadsheet

{note} Note that only shift abbreviations existing in the Shift List are permitted for use in the schedule. This way all scheduled shifts will be accounted for and tracked correctly by the application.

Insert/Delete Rows

Say we've added a few more people to the schedule and want to add Jessica in between Amy and Emma because Amy and Jessica have similar schedules, and we want to group similar schedules together. By clicking on the left-hand numbered column, we select Emma's row. (By clicking and dragging, we can select multiple rows, but for this example it's not necessary.) By then right-clicking, the pop-up menu appears giving us the ability to insert and delete rows. We choose to insert 1 above, and now we have a new row to begin entering the Jessica's schedule.

row pop-up menu and insert and deleting rows