{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Rota","About"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Rota","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,{"$f":"F4","v":null},{"$f":"G4","v":null},{"$f":"H4","v":null},{"$f":"I4","v":null},{"$f":"J4","v":null},{"$f":"K4","v":null},{"$f":"L4","v":null},{"$f":"M4","v":null}]
[null,"Name","Hours","Hourly rate","Pay","2015-10-05",{"$f":"F4+1","v":null},{"$f":"G4+1","v":null},{"$f":"H4+1","v":null},{"$f":"I4+1","v":null},{"$f":"J4+1","v":null},{"$f":"K4+1","v":null},{"$f":"L4+1","v":null}]
[]
[null,"Staff member #1",{"$f":"Hours(6:6)","v":null},null,{"$f":"Pay(6:6)","v":null}]
[null,"Staff member #2",{"$f":"Hours(7:7)","v":null},null,{"$f":"Pay(7:7)","v":null}]
[null,"Staff member #3",{"$f":"Hours(8:8)","v":null},null,{"$f":"Pay(8:8)","v":null}]
[null,"Staff member #4",{"$f":"Hours(9:9)","v":null},null,{"$f":"Pay(9:9)","v":null}]
[null,"Staff member #5",{"$f":"Hours(10:10)","v":null},null,{"$f":"Pay(10:10)","v":null}]
[null,"Staff member #6",{"$f":"Hours(11:11)","v":null},null,{"$f":"Pay(11:11)","v":null}]
[null,"Staff member #7",{"$f":"Hours(12:12)","v":null},null,{"$f":"Pay(12:12)","v":null}]
[null,"Staff member #8",{"$f":"Hours(13:13)","v":null},null,{"$f":"Pay(13:13)","v":null}]
[null,"Staff member #9",{"$f":"Hours(14:14)","v":null},null,{"$f":"Pay(14:14)","v":null}]
[null,"Staff member #10",{"$f":"Hours(15:15)","v":null},null,{"$f":"Pay(15:15)","v":null}]
[null,"Staff member #11",{"$f":"Hours(16:16)","v":null},null,{"$f":"Pay(16:16)","v":null}]
[null,"Staff member #12",{"$f":"Hours(17:17)","v":null},null,{"$f":"Pay(17:17)","v":null}]
[null,"Staff member #13",{"$f":"Hours(18:18)","v":null},null,{"$f":"Pay(18:18)","v":null}]
[null,"Staff member #14",{"$f":"Hours(19:19)","v":null},null,{"$f":"Pay(19:19)","v":null}]
[null,"Staff member #15",{"$f":"Hours(20:20)","v":null},null,{"$f":"Pay(20:20)","v":null}]
[null,"Staff member #16",{"$f":"Hours(21:21)","v":null},null,{"$f":"Pay(21:21)","v":null}]
[null,"Staff member #17",{"$f":"Hours(22:22)","v":null},null,{"$f":"Pay(22:22)","v":null}]
[null,"Staff member #18",{"$f":"Hours(23:23)","v":null},null,{"$f":"Pay(23:23)","v":null}]
[null,"Staff member #19",{"$f":"Hours(24:24)","v":null},null,{"$f":"Pay(24:24)","v":null}]
[null,"Staff member #20",{"$f":"Hours(25:25)","v":null},null,{"$f":"Pay(25:25)","v":null}]

{"sheet":"About","index":1,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Getting started"]
[null,"To get started you'll need to click \"Enable Editing\" when prompted at the top of the document. Once you enable editing you'll be able to add staff and their shifts. You'll also want to click \"Enable Content\" so that the macros can calculate the total hours and total pay for your staff."]
[]
[null,"Adding staff"]
[null,"If you've run out of rows for your staff you can always add more, but as there are formulas in the \"Hours\" and \"Pay\" columns it's best to select the row of an existing staff member, right click and select \"Copy\", then select the row where you'd like the new staff member, right click it and select \"Insert Copied Cells\"."]
[]
[null,"Entering shifts"]
[null,"For Excel to interpret shifts and calculate your totals correctly the shifts must be entered in a clear and consistent format, e.g. \"9am-5pm\" or \"9:00-17:00\". Shifts that cannot be interpreted will be ignored when totalling hours and pay. When staff are working two or more shifts per day you can split the shifts with a slash \"/\", or a new line by pressing alt + enter."]
[]
[null,"Unpaid breaks"]
[null,"To deduct an unpaid break from a staff member's hours and/or pay, you'll need to add an entry like you would add a shift (separated with a new line or a slash) in the format \"1 hour break\" or \"30 minute break\". You're free to enter any amount of time you like too, as long as you end the entry with the word \"break\"."]
[]
[null,"More features & functionality"]
[null,"For more features and functionality, Findmyshift provides all of the functionality found in this template in addition to time off requests, text & email alerts, real-time reporting, overtime rates, day rates, salaries, shift reminders, payroll exports, timesheets, time-clocking and 24/7 online access for managers and staff."]
[]
[null,"For more information please visit:"]
[null,"https://www.findmyshift.com/"]
[]
[null,"For another template please visit:"]
[null,"https://www.findmyshift.com/excel-template"]