{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["April2015","Set-up","Help"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":6,"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":"April2015","index":0,"n_rows":40,"n_cols":22,"rows_kept":40,"cut":false,"hidden":false,"merged":[[5,4,5,5]]}
[2015,"Name","Enter your name here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:18:00"]
["April",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:18:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Balance brought forward from previous month",null,null,null,null,null,null,null,"07:18:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum Credit Carry Forward 10 hrs",null,null,null,null,null,"07:18:00"]
[null,null,"Core hours","10:00:00","12:00:00","14:00:00","16:00:00",null,null,null,null,null,null,null,null,"You should not regularly carry a debit forward",null,null,null,null,null,"07:18:00"]
[null,null,"Earliest Start","07:30:00","Min lunch 30 mins",null,"19:00:00",null,"Latest Finish"]
[null,"Date","Day Type","In ","Out","In","Out",null,"Extra",null,"Hours / Day","Total for Day","Float Worked (hr)","Credited Hours","Float Running Hrs","Running Total","Comments"]
[{"$f":"B8","v":"2015-04-01"},{"$f":"DATEVALUE(\"1 \" & A2 & \" \" & A1)","v":"2015-04-01"},"WorkDay",null,null,null,null,null,null,{"$f":"TestDatai(D8,E8,F8,G8,I8,C8)","v":0},"07:18:00",{"$f":"IF(J8=0,0,CalcDayHrs(D8,E8,F8,G8,I8,J8))","v":"00:00:00"},{"$f":"IF(J8=0,0,L8-K8)","v":0},{"$f":"formatTime(M8)","v":"00:00"},{"$f":"M8+DTStrToReal(P3)","v":0},{"$f":"IF(J8=0,\"\",formatTime(O8))","v":""}]
[{"$f":"B9","v":"2015-04-02"},{"$f":"B8+1","v":"2015-04-02"},"WorkDay",null,null,null,null,null,null,{"$f":"TestDatai(D9,E9,F9,G9,I9,C9)","v":0},"07:18:00",{"$f":"IF(J9=0,0,CalcDayHrs(D9,E9,F9,G9,I9,J9))","v":"00:00:00"},{"$f":"IF(J9=0,0,L9-K9)","v":0},{"$f":"formatTime(M9)","v":"00:00"},{"$f":"M9+DTToReal(O8)","v":0},{"$f":"IF(J9=0,\"\",formatTime(O9))","v":""}]
["2015-04-03",{"$f":"B9+1","v":"2015-04-03"},"UniClosed",null,null,null,null,null,"07:18:00",20,"07:18:00",{"$f":"IF(J10=0,0,CalcDayHrs(D10,E10,F10,G10,I10,J10))","v":"07:18:00"},0,"00:00",{"$f":"M10+DTToReal(O9)","v":0},{"$f":"IF(J10=0,\"\",formatTime(O10))","v":"00:00"},"University Closed"]
["2015-04-04","2015-04-04",null,null,null,null,null,null,null,{"$f":"TestDatai(D11,E11,F11,G11,I11,C11)","v":0},null,"00:00:00",0,"00:00",{"$f":"M11+DTToReal(O10)","v":0},""]
[{"$f":"B12","v":"2015-04-05"},"2015-04-05",null,null,null,null,null,null,null,0,null,{"$f":"IF(J12=0,0,CalcDayHrs(D12,E12,F12,G12,I12,J12))","v":"00:00:00"},0,"00:00",0,""]
["2015-04-06","2015-04-06","UniClosed",null,null,null,null,null,"07:18:00",{"$f":"TestDatai(D13,E13,F13,G13,I13,C13)","v":20},"07:18:00",{"$f":"IF(J13=0,0,CalcDayHrs(D13,E13,F13,G13,I13,J13))","v":"07:18:00"},0,"00:00",0,"00:00","University Closed"]
["2015-04-07","2015-04-07","WorkDay",null,null,null,null,null,null,{"$f":"TestDatai(D14,E14,F14,G14,I14,C14)","v":0},"07:18:00",{"$f":"IF(J14=0,0,CalcDayHrs(D14,E14,F14,G14,I14,J14))","v":"00:00:00"},0,"00:00",0,""]
["2015-04-08","2015-04-08","WorkDay",null,null,null,null,null,null,{"$f":"TestDatai(D15,E15,F15,G15,I15,C15)","v":0},"07:18:00",{"$f":"IF(J15=0,0,CalcDayHrs(D15,E15,F15,G15,I15,J15))","v":"00:00:00"},0,"00:00",0,""]
["2015-04-09","2015-04-09","WorkDay",null,null,null,null,null,null,{"$f":"TestDatai(D16,E16,F16,G16,I16,C16)","v":0},"07:18:00",{"$f":"IF(J16=0,0,CalcDayHrs(D16,E16,F16,G16,I16,J16))","v":"00:00:00"},0,"00:00",0,""]
["2015-04-10","2015-04-10","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-11","2015-04-11",null,null,null,null,null,null,null,0,null,"00:00:00",0,"00:00",0,""]
["2015-04-12","2015-04-12",null,null,null,null,null,null,null,0,null,"00:00:00",0,"00:00",0,""]
["2015-04-13","2015-04-13","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-14","2015-04-14","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-15","2015-04-15","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-16","2015-04-16","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-17","2015-04-17","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-18","2015-04-18",null,null,null,null,null,null,null,0,null,"00:00:00",0,"00:00",0,""]
["2015-04-19","2015-04-19",null,null,null,null,null,null,null,0,null,"00:00:00",0,"00:00",0,""]
["2015-04-20","2015-04-20","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-21","2015-04-21","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-22","2015-04-22","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-23","2015-04-23","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-24","2015-04-24","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-25","2015-04-25",null,null,null,null,null,null,null,0,null,"00:00:00",0,"00:00",0,""]
["2015-04-26","2015-04-26",null,null,null,null,null,null,null,0,null,"00:00:00",0,"00:00",0,""]
["2015-04-27","2015-04-27","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-28","2015-04-28","WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-29",{"$f":"IF(MONTH(B35)=MONTH( B35+1),B35+1,\"\")","v":"2015-04-29"},"WorkDay",null,null,null,null,null,null,{"$f":"TestDatai(D36,E36,F36,G36,I36,C36)","v":0},"07:18:00","00:00:00",0,"00:00",0,""]
["2015-04-30",{"$f":"IF(B36=\"\",\"\",IF(MONTH(B36)=MONTH( B36+1),B36+1,\"\"))","v":"2015-04-30"},"WorkDay",null,null,null,null,null,null,0,"07:18:00","00:00:00",0,"00:00",0,""]
[{"$f":"B38","v":""},{"$f":"IF(B37=\"\",\"\",IF(MONTH(B37)=MONTH( B37+1),B37+1,\"\"))","v":""},null,null,null,null,null,null,null,0,null,"00:00:00",0,"00:00",0,""]
["For University Closure days please select Day Type ",null,null,null,null,null,null,null,null,null,null,null,null,"Carry forward to next month",{"$f":"O38","v":0},{"$f":"formatTime(O39)","v":"00:00"}]
["UniClosed"]

{"sheet":"Set-up","index":1,"n_rows":117,"n_cols":1,"rows_kept":117,"cut":false,"hidden":true,"merged":[]}
[]
["WorkDay"]
["Illness"]
["Holiday"]
["FlexiDay"]
["FlexiAM"]
["FlexiPM"]
["UniClosed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["January"]
["February"]
["March"]
["April"]
["May"]
["June"]
["July"]
["August"]
["September"]
["October"]
["November"]
["December"]

{"sheet":"Help","index":2,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,27,1],[3,0,3,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[15,0,15,1],[16,0,16,1],[19,0,19,1],[20,0,20,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[17,0,17,1],[18,0,18,1],[0,0,0,2],[2,0,2,2],[4,0,4,1],[5,0,5,1],[6,0,6,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1]]}
["Flexitime spreadsheet help"]
[]
["You must read the flexitime guidance before you start using this spreadsheet. This can be found in the Flexible Working toolkit on the website."]
["Macros",null,"The spreadsheet uses Macros which are automatic calculations. You need to make sure you have allowed Macros when you open the spreadsheet. You need to allow Macros everytime. If you see #Name? in any of the totals columns, marros are not working and need to be allowed.  There are instructions in the Flexible Working Toolkit on how to automatically allow Macros. "]
["Saving your timesheet",null,"Every month, you need to start a new timesheet and each timesheet should be saved separately. You should save your timesheets in the same folder. For easy reference, save the timesheet with your name and the month in the title. Your manager may have a specific place for everyone in your team's timesheets."]
["Name",null,"Enter your full name "]
["Set date",null,"Click this button to choose the correct month and year. If you are changing to a new month,  you must save the previous month before you change otherwise you may lose the data you have already entered."]
["Set hours",null,"The default setting of hours is 7:18 per day which is the usual full-time hours workedover 5 days. If you are part-time or work different hours per day, click 'set hours' and set your hours accordingly. You must use the format h:mm (so 6 hours and 20 minutes per day is 6:20)"]
["Core hours",null,"The cores hours listed are the standard University flexitime scheme core hours. Your team may have different core hours so you should check with your manager. If the hours you record on the spreadsheet fall outside of the standard core hours, the hours will be highlighted but this is just a visual reference and has no effect on the calculation of your flexitime. "]
["Earliest start and latest finish times",null,"The earliest start and latest finish times listed are the standrad University time flexitime earliest start and latest finish times (also known as bandwidth). If the hours you record on the spreadsheet fall outside of these times, the hours will be highlighted as a visual reference. You should not normally work outside of the bandwidth."]
["Maximum credit and debit carry forward",null,"The maximum credit carry forward listed is the standard University flexitime amounts. You should usually work your minimum contracted hours each month and not regularly carry a debit over."]
["Day type",null,"Choose the correct type from the dropdown list. If you have set your hours and do not work on some days of the week, you do no need to choose a day type."]
["Work day",null,"This is a normal working day for you. It is based on what you enter when you click 'Set hours'."]
["Illness","Illness","Choose this if you are off sick. The timesheet will automatically credit you the full number of hours that you usually work for that day."]
["Holiday","Holiday","Choose this option when you have a holiday. If you have a full day holiday, you do not need to do anything else as the spreadsheet will automatically credit you with your full hours. If you have a half day holiday, you should enter the hours you do in the other half of the day and then in the 'Extra' column enter the hours to equal half a day.You should write 'Holiday AM' or 'Holiday PM' in the Comments cell so that it is clear what you have taken as holiday. "]
["Flexiday","Flexiday","Flexiday should be used when you are taking off a whole day to use up some of your credited hours. This must be in agreement with your manager. "]
["Flexiday AM","Flexiday AM","Flexiday AM should be used when you are taking a morning off to use up some of your credited hours. This must be in agreement with your line manager. You just need to add your in and out times for the afternoon and leave the morning blank. "]
["Flexiday PM","Flexiday PM","Flexiday PM should be used when you are taking an afternoon off to use up some of your credited hours. This must be in agreement with your line manager. You just need to add your in and out times for the morning and leave the afternoon blank."]
["UniClosed","UniClosed","UniClosed should be used for days that the University is closed and you don't usually work e.g. Bank holidays. If you usually work on these days, then just choose 'WorkDay'"]
["In/out times",null,"Enter your start and finish times including when you break for lunch and re-start again. You must use the format hh:mm so if you start at 8am, you should type 08:00. Times must be entered in pairs using either the morning or afternoon pair of IN/OUT.  The calculations will not work if only the morning IN and the afternoon OUT has hours in it. You should follow the core hours and earliest start and finish times that are listed at the top of the spreadsheet unless you have different core hours/bandwidth within your team/line manager."]
["Extra",null,"This is used for half day holiday as explained in \"Holiday\" above. It can also be used for any hours you do that are out of scope of the flexitime scheme (such as occasional evening work) but you should make sure that you are clear what and why you did these hours in the comments section and check that your manager wants you to record it in this way."]
["Hours/Day",null,"You cannot edit this cell.  This cell automatically completes according to the information you put in when you press the \"Set hours\" button on the top left"]
["Total for Day",null,"You cannot edit this cell.  This cell automatically adds up the number of hours you have worked in a day according to what you write in the In/Out cells."]
["Credited Hours",null,"You cannot edit this cell. This cell automatically completes according to the times you enter in the In/Out cells for that day."]
["Running Total",null,"You cannot edit this cell. This cell automatically completes according to the information you put in the In/Out cells throughout the month and the balance you bring forward from the previous month."]
["Comments",null,"You can use this column to make any notes. For example, if your manager looks at your timesheet, they may wish you to use this column to explain any particularly long or short days. Or you may use it for your own reference."]
["Balance bought forward from previous month",null,"On your first month, this should be zero (0:00). Then on subsequent months, you should enter the number of hours you have as credit or debit from the previous month. You will find this information in red next to the 'Carry forward to next month' on your previous month's spreadsheet. "]
["Carry forward to next month",null,"You do not need to edit this cell. It automatically updates according to your running total."]