{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Holiday club booking form","Terms & Conditions","Admin"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Holiday club booking form","index":0,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,2,2,8],[10,2,10,5],[10,7,10,8],[8,1,8,8],[24,4,27,5],[27,2,27,3],[24,1,25,3],[5,7,5,8],[5,1,5,3],[6,4,6,6],[7,4,7,6],[5,4,5,6],[7,1,7,3],[6,1,6,3],[16,7,19,7],[12,1,12,8],[24,6,24,7],[25,6,25,7],[27,6,27,7],[22,2,22,6],[26,6,26,7],[16,1,19,1],[16,6,19,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[31,1,31,2],[29,5,29,8],[30,5,30,6],[31,5,31,6]]}
[null,null,null,null,null,null,null,null,null,"    "]
[]
[null,null,"WOSC Holiday Club Advance booking form"]
[]
[]
[null,"Booking form period",null,null,{"$f":"Admin!G4","v":"Autumn Half Term"},null,null,{"$f":"Admin!G3","v":2020},null,"2020-10-05T10:44:37"]
[null,null,null,null,"Form submission Deadline:",null,null,{"$f":"Admin!G6","v":"2020-10-09"},23.59,{"$f":"IF(H7+1>= J6,FALSE,TRUE)","v":false}]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(\"Total\",J9:J110,0) +8","v":23}]
[null,"All places are allocated on a first come, first serve basis, with priority given as per terms and condtions.",null,null,null,null,null,null,null,{"$f":"MATCH(\"Header\",J10:J111,0) +9","v":15}]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(\"Payment\",J11:J111,0) +10","v":29}]
[null,"Childs Name*",null,null,null,null,"Year*"]
[]
[null,"Please complete one form per child. Place an x in the relevant session boxes that you require. Full day bookings (8:15 - 5:30) only and you need to book the whole week block i.e. Monday to Wednesday. No refunds for any sessions cancelled. Payment required within 5 days of a place being confirmed. Please see Terms & Conditions."]
[]
[null,"Week","Time","Mon","Tues","Wed","Thurs","Fri","Weekly total","Header"]
[]
[null,"26/10/2020 - 30/10/2020","Full Day",null,null,null,"Club Closed","Club Closed",{"$f":"SUM(J17:N17)","v":0},{"$f":"IF(OR(D17=\"\",D17=Admin!$D$16, D17=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$4,'Terms & Conditions'!$F$4))","v":0},{"$f":"IF(OR(E17=\"\",E17=Admin!$D$16, E17=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$4,'Terms & Conditions'!$F$4))","v":0},{"$f":"IF(OR(F17=\"\",F17=Admin!$D$16, F17=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$4,'Terms & Conditions'!$F$4))","v":0},{"$f":"IF(OR(G17=\"\",G17=Admin!$D$16, G17=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$4,'Terms & Conditions'!$F$4))","v":0},{"$f":"IF(OR(H17=\"\",H17=Admin!$D$16, H17=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$4,'Terms & Conditions'!$F$4))","v":0}]
[null,null,"School Day",null,null,null,null,null,{"$f":"SUM(J18:N18)","v":0}]
[null,null,"Morning",null,null,null,null,null,{"$f":"SUM(J19:N19)","v":0}]
[null,null,"Afternoon",null,null,null,null,null,{"$f":"SUM(J20:N20)","v":0}]
[]
[]
[null,null,"Please ensure this form is received by WOSC before the deadline above.",null,null,null,null,"Holiday club total fees",{"$f":"SUM(I16:I22)","v":0},"Total"]
[]
[null,"Note that payment must be received by Early bird payment date otherwise full rate will be charged",null,null,"Payment method*",null,"Amount to be paid by cheque:"]
[null,null,null,null,null,null,"Amount to be paid by BACS:"]
[null,null,null,null,null,null,"Amount to be paid by credit:"]
[null,"Voucher scheme name",null,null,null,null,"Amount to be paid by Voucher"]
[null,null,null,null,null,null,null,"Total payment",{"$f":"SUM(I25:I28)","v":0},"Payment"]
[null,null,null,null,null,"Warning: Total payment does not equal total half term fees!"]
[null,"Admin only","EB","FR",null,null,null,"Early bird","Full rate"]
[null,"Date form received",null,null,null,{"$f":"Admin!O4","v":"Full Day"},null,{"$f":"Admin!P4","v":32},{"$f":"Admin!Q4","v":32}]

{"sheet":"Terms & Conditions","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"WOSC Terms & Conditions (Please also see admissions policy)",null,null,"WOSC RATES 2019/20"]
[]
[1,"Annual Registration (membership)",null,null,null,"Early bird","Full rate"]
[null,"i","The annual registration form & consent forms must be completed before any child can be booked into the club. ",null,{"$f":"Admin!O4","v":"Full Day"},{"$f":"Admin!P4","v":32},{"$f":"Admin!Q4","v":32}]
[null,"ii","Any bookings received without a registration form will not be accepted.",null,{"$f":"Admin!O5","v":0},{"$f":"Admin!P5","v":0},{"$f":"Admin!Q5","v":0}]
[null,"iii","Registration forms must be submitted or resubmitted annually for each child for the start of the September term or in advance of the first booking made in the academic year. ",null,{"$f":"Admin!O6","v":0},{"$f":"Admin!P6","v":0},{"$f":"Admin!Q6","v":0}]
[null,null,null,null,{"$f":"Admin!O7","v":0},{"$f":"Admin!P7","v":0},{"$f":"Admin!Q7","v":0}]
[]
[2,"WOSC Calendar"]
[null,"i","The WOSC Calendar can be found on the club's website and contains all of the early bird deadline dates, form release and payment dates, bank holidays, WW training days and holiday club days.  "]
[]
[3,"Booking for October Holiday club 2020"]
[null,"i","Due to Covid-19, there will be no early bird booking this holiday club. The deadline for booking is 9.10.2020."]
[null,"ii","We are only offering 3 day block booking so each day Monday to Wednesday must be booked. We are only offering a full day booking 8:15 - 5:30. "]
[null,"iii","We are only able to take up to 15 children a day. Places will be confirmed on 12.10.2020 and are subject to a minimum number of bookings. The following priorities for place allocation will be made:\n1. Children of keyworkers or those with a critical need for childcare and vulnerable children currently attending William Westley. \n2. Children of committee and staff attending William Westley.\n3. Children currently attending William Westley on first come first serve basis (time/date of email). \nUnfortunately we are unable to take children from other schools (apart from children of staff who are attending with their parent). \nBooking requests for siblings will be managed together provided the individual booking forms are submitted simultaneously. \n\nPlease note, bookings need to be submitted by email."]
[null,"iv","Payment is due within 5 days of a place being offered.  "]
[null,"v","If payment is not received in full and on time, then your reserved places will be lost. In the event that payment is not received for a booking we will approach families that were not initially offered places to fill these places."]
[]
[]
[4,"Payment methods"]
[null,"i","Payment is prefered by BACS, however cheques will be accepted. \n\nCheques must be made payable to: Whittlesford Out of School Club CIO\n\nWOSC Bank account details for BACS:\nSort code: 09-01-29\nAccount number: 14319503\nPlease use child's full name as reference\n"]
[null,"ii","Payment or part payment can also be made using childcare vouchers.  Please use the dropdown list on the booking form to select your provider and ensure that the total payment made to the club covers the session fees in the booking form."]
[null,"iii","If payment or part payment is being made by childcare vouchers, please ensure that your WOSC account is in sufficient credit to cover fees."]
[null,"iv","If any parent has any problems with making payment, they should contact the treasurer@wosclub.co.uk to discuss appropriate options."]
[null,"v","Note that the committee is comprised of volunteers, therefore the club reserves the right to utilise date of payment on bank statements, date cheques received in club and date vouchers paid in as reference.  Follow up for non-payment therefore may not be immediate due to the personal commitments of the committee."]
[]
[5,"Cancellations"]
[null,"i","No refunds or credit will made for any holiday club sessions that are cancelled, regardless of the notice period given. See Admissions policy for cancellation rules.  Note that vouchers are not refundable."]

{"sheet":"Admin","index":2,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["WOSC admin only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Holiday Club Rates"]
[null,null,"Select year",null,null,null,2020,null,null,null,null,null,null,null,null,"Early bird","Full rate"]
[null,null,"State the holiday period",null,null,null,"Autumn Half Term",null,null,null,null,null,null,null,"Full Day",32,32]
[]
[null,null,"Deadline date",null,null,null,"2020-10-09"]
[null,null,"Early Bird payment date"]
[null,null,"No. of weeks in holiday period",null,null,null,1]
[null,null,"Date of Monday of first week",null,null,null,"2020-10-26",null,null,null,null,null,null,null,"Date rates entered/reviewed","2020-10-05"]
[]
[null,null,null,null,null,"wk no.","day","day #"]
[null,null,"Date of","Club Closed",1,1,"Thursday",{"$f":"VLOOKUP(G12,M$25:N$29,2,FALSE)","v":4}]
[null,null,null,null,2,1,"Friday",{"$f":"VLOOKUP(G13,M$25:N$29,2,FALSE)","v":5},null,null,null,null,null,null,"Voucher lookup"]
[null,null,null,null,3,null,null,{"$f":"VLOOKUP(G14,M$25:N$29,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Edenred"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Government Tax Free Childcare scheme"]
[null,null,"Date of",null,1,null,null,{"$f":"VLOOKUP(G16,M$25:N$29,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Kids Unlimited"]
[null,null,null,null,2,null,null,{"$error":"#N/A"},null,null,null,null,null,null,"Computershare"]
[null,null,null,null,3,null,null,{"$error":"#N/A"},null,null,null,null,null,null,"Sodexo/SayCarePass"]
[null,null,null,null,4,null,null,{"$error":"#N/A"},null,null,null,null,null,null,"Kiddivouchers"]
[null,null,null,null,5,null,null,{"$error":"#N/A"},null,null,null,null,null,null,"AllSave"]
[null,null,null,null,6,null,null,{"$error":"#N/A"},null,null,null,null,null,null,"You at Work"]
[null,null,null,null,7,null,null,{"$f":"VLOOKUP(G22,M$25:N$29,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Busy Bees Benefits"]
[null,null,null,null,8,null,null,{"$error":"#N/A"},null,null,"LOOKUP",null,null,null,"Care4"]
[null,null,null,null,9,null,null,{"$error":"#N/A"},null,null,"year","Holiday","BH Day","BH wk","Faircare"]
[null,null,null,null,10,null,null,{"$error":"#N/A"},null,null,2017,"Autumn Half Term","Monday",1]
[null,null,null,null,11,null,null,{"$error":"#N/A"},null,null,2018,"Christmas","Tuesday",2]
[null,null,null,null,12,null,null,{"$error":"#N/A"},null,null,2019,"Spring Half Term","Wednesday",3]
[null,null,null,null,null,null,null,null,null,null,2020,"Easter","Thursday",4]
[null,null,null,null,null,null,null,null,null,null,null,"Summer Half Term","Friday",5]
[null,null,null,null,null,null,null,null,null,null,null,"Summer",null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8]
["Do not move the table below including the line below it from Row 34 Column 2"]
[null,null,"Full Day",null,null,null,null,null,{"$f":"SUM(J34:N34)","v":0},{"$f":"IF(OR(D34=\"\",D34=Admin!$D$16, D34=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$4,'Terms & Conditions'!$F$4))","v":0},{"$f":"IF(OR(E34=\"\",E34=Admin!$D$16, E34=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$4,'Terms & Conditions'!$F$4))","v":0},{"$f":"IF(OR(F34=\"\",F34=Admin!$D$16, F34=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$4,'Terms & Conditions'!$F$4))","v":0},{"$f":"IF(OR(G34=\"\",G34=Admin!$D$16, G34=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$4,'Terms & Conditions'!$F$4))","v":0},{"$f":"IF(OR(H34=\"\",H34=Admin!$D$16, H34=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$4,'Terms & Conditions'!$F$4))","v":0}]
[null,null,"School Day",null,null,null,null,null,{"$f":"SUM(J35:N35)","v":0}]
[null,null,"Morning",null,null,null,null,null,{"$f":"SUM(J36:N36)","v":0}]
[null,null,"Afternoon",null,null,null,null,null,{"$f":"SUM(J37:N37)","v":0}]