{"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":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[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],[12,1,12,8],[24,6,24,7],[25,6,25,7],[27,6,27,7],[22,2,22,6],[26,6,26,7],[24,4,27,5],[27,2,27,3],[24,1,25,3],[16,1,19,1],[16,3,19,3],[2,2,2,8],[10,2,10,5],[10,7,10,8],[8,1,8,8],[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]]}
[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":"Summer Half Term"},null,null,{"$f":"Admin!G3","v":2021},null,"2021-04-20T19:27:31"]
[null,null,null,null," Deadline:",null,null,{"$f":"Admin!G6","v":"2021-04-27"},"17:00:00",{"$f":"IF(H7+1>= J6,FALSE,TRUE)","v":false}]
[null,"Please see terms and conditions for booking conditions in light of Covid-19 restrictions.",null,null,null,null,null,null,null,{"$f":"MATCH(\"Total\",J9:J110,0) +8","v":23}]
[null,null,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 sessions only and you must book at least 2 days.  No refunds for any sessions cancelled. Payment required within 5 days of a place being confirmed. Please see terms and conditions."]
[]
[null,"Week","Time","Mon","Tues","Wed","Thurs","Fri","Weekly total","Header"]
[]
[null,"31/05/2021 - 04/06/2021","Full Day","Club closed",null,null,null,null,{"$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},{"$f":"IF(OR(D18=\"\",D18=Admin!$D$16, D18=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$5,'Terms & Conditions'!$F$5))","v":0},{"$f":"IF(OR(E18=\"\",E18=Admin!$D$16, E18=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$5,'Terms & Conditions'!$F$5))","v":0},{"$f":"IF(OR(F18=\"\",F18=Admin!$D$16, F18=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$5,'Terms & Conditions'!$F$5))","v":0},{"$f":"IF(OR(G18=\"\",G18=Admin!$D$16, G18=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$5,'Terms & Conditions'!$F$5))","v":0},{"$f":"IF(OR(H18=\"\",H18=Admin!$D$16, H18=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$5,'Terms & Conditions'!$F$5))","v":0}]
[null,null,"Morning",null,null,null,null,null,{"$f":"SUM(J19:N19)","v":0},{"$f":"IF(OR(D19=\"\",D19=Admin!$D$16, D19=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(E19=\"\",E19=Admin!$D$16, E19=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(F19=\"\",F19=Admin!$D$16, F19=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(G19=\"\",G19=Admin!$D$16, G19=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(H19=\"\",H19=Admin!$D$16, H19=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0}]
[null,null,"Afternoon",null,null,null,null,null,{"$f":"SUM(J20:N20)","v":0},{"$f":"IF(OR(D20=\"\",D20=Admin!$D$16, D20=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(E20=\"\",E20=Admin!$D$16, E20=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(F20=\"\",F20=Admin!$D$16, F20=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(G20=\"\",G20=Admin!$D$16, G20=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(H20=\"\",H20=Admin!$D$16, H20=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0}]
[]
[]
[null,null,null,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 (8:30 - 17:30)"},null,{"$f":"Admin!P4","v":32},{"$f":"Admin!Q4","v":32}]
[null,null,null,null,null,{"$f":"Admin!O5","v":"School Day (8.30 - 15.30"},null,{"$f":"Admin!P5","v":0},{"$f":"Admin!Q5","v":0}]
[null,null,null,null,null,{"$f":"Admin!O6","v":"Half day am (7:45 - 13.00)"},null,{"$f":"Admin!P6","v":0},{"$f":"Admin!Q6","v":0}]
[null,null,null,null,null,{"$f":"Admin!O7","v":"Half day pm (13.00 - 18.00)"},null,{"$f":"Admin!P7","v":0},{"$f":"Admin!Q7","v":0}]

{"sheet":"Terms & Conditions","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"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 (8:30 - 17:30)"},{"$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":"School Day (8.30 - 15.30"},{"$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":"Half day am (7:45 - 13.00)"},{"$f":"Admin!P6","v":0},{"$f":"Admin!Q6","v":0}]
[null,null,null,null,{"$f":"Admin!O7","v":"Half day pm (13.00 - 18.00)"},{"$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 May Holiday club 2021"]
[null,"i","Due to Covid-19, there will be no early bird booking this holiday club. "]
[null,"ii","We are only offering 4 day block booking so each day in the week must be booked. We are only offering a full day booking 8:35 - 17:30. "]
[null,"iii"," Places will be confirmed asap and are subject to a minimum number of bookings, and will follow our usual priority order.\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. Please note cheques must be received (posted in club postbox) by the early bird deadline.\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 by the early bird payment deadline or before your child starts sessions if paying full rate.   If insufficent payment is received by the early bird payment deadline, your place(s) cannot be guaranteed."]
[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,2021,null,null,null,null,null,null,null,null,"Early bird","Full rate"]
[null,null,"State the holiday period",null,null,null,"Summer Half Term",null,null,null,null,null,null,null,"Full Day (8:30 - 17:30)",32,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"School Day (8.30 - 15.30"]
[null,null,"Deadline date",null,null,null,"2021-04-27",null,null,null,null,null,null,null,"Half day am (7:45 - 13.00)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Half day pm (13.00 - 18.00)"]
[null,null,"No. of weeks in holiday period",null,null,null,1]
[null,null,"Date of Monday of first week",null,null,null,"2021-05-31",null,null,null,null,null,null,null,"Date rates entered/reviewed","2021-02-26"]
[]
[null,null,null,null,null,"wk no.","day","day #"]
[null,null,"Date of","Club closed",1,1,"Monday",{"$f":"VLOOKUP(G12,M$25:N$29,2,FALSE)","v":1}]
[null,null,null,null,2,null,null,{"$f":"VLOOKUP(G13,M$25:N$29,2,FALSE)","v":{"$error":"#N/A"}},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","Other",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,2021,"Autumn Half Term","Monday",1]
[null,null,null,null,11,null,null,{"$error":"#N/A"},null,null,2022,"Christmas","Tuesday",2]
[null,null,null,null,12,null,null,{"$error":"#N/A"},null,null,2023,"Spring Half Term","Wednesday",3]
[null,null,null,null,null,null,null,null,null,null,2024,"Easter","Thursday",4]
[null,null,null,null,null,null,null,null,null,null,2025,"Summer Half Term","Friday",5]
[null,null,null,null,null,null,null,null,null,null,2026,"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},{"$f":"IF(OR(D35=\"\",D35=Admin!$D$16, D35=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$5,'Terms & Conditions'!$F$5))","v":0},{"$f":"IF(OR(E35=\"\",E35=Admin!$D$16, E35=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$5,'Terms & Conditions'!$F$5))","v":0},{"$f":"IF(OR(F35=\"\",F35=Admin!$D$16, F35=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$5,'Terms & Conditions'!$F$5))","v":0},{"$f":"IF(OR(G35=\"\",G35=Admin!$D$16, G35=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$5,'Terms & Conditions'!$F$5))","v":0},{"$f":"IF(OR(H35=\"\",H35=Admin!$D$16, H35=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$5,'Terms & Conditions'!$F$5))","v":0}]
[null,null,"Morning",null,null,null,null,null,{"$f":"SUM(J36:N36)","v":0},{"$f":"IF(OR(D36=\"\",D36=Admin!$D$16, D36=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(E36=\"\",E36=Admin!$D$16, E36=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(F36=\"\",F36=Admin!$D$16, F36=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(G36=\"\",G36=Admin!$D$16, G36=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(H36=\"\",H36=Admin!$D$16, H36=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0}]
[null,null,"Afternoon",null,null,null,null,null,{"$f":"SUM(J37:N37)","v":0},{"$f":"IF(OR(D37=\"\",D37=Admin!$D$16, D37=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(E37=\"\",E37=Admin!$D$16, E37=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(F37=\"\",F37=Admin!$D$16, F37=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(G37=\"\",G37=Admin!$D$16, G37=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0},{"$f":"IF(OR(H37=\"\",H37=Admin!$D$16, H37=Admin!$D$12),0,IF('Holiday club booking form'!$J$7,'Terms & Conditions'!$G$6,'Terms & Conditions'!$F$6))","v":0}]