{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","Calculator","Summary","ValQuals","ValUnits","ValCombs","ValDrops","For Info"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"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":"Introduction","index":0,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,1,8,11],[10,1,10,14],[14,4,14,13],[16,4,16,13],[19,4,19,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Introduction"]
[]
[null,"This calculator will help you to select the appropriate combination of 30, 60 or 90 GLH units for learners to undertake, to complete the chosen qualification route.  The calculator will ensure that you choose the correct amount of Guided Learning Hours (GLH) required, in the mandatory and optional sections of the qualification. The calculator will generate a clear table of the selected units, which can be printed out and included in your learners' portfolios or other records."]
[]
[null,"How to use this Qualification Calculator "]
[]
[null,null,"Step 1:",null,"The Instructions in the top left of the Calculator screen will explain what you need to do. Please note, if you select Foundation Diploma or Diploma you will see additional Pathway options."]
[]
[null,null,"Step 2:",null,"Select the appropriate units using the tick boxes. If you need to re-start your selection, click on the Reset button. Once you have selected the appropriate units you can then move onto the Summary page."]
[]
[]
[null,null,"Step 3:",null,"Click on the Unit Summary button to see your selection in a printable format."]

{"sheet":"Calculator","index":1,"n_rows":61,"n_cols":42,"rows_kept":61,"cut":false,"hidden":false,"merged":[[42,41,42,44],[43,41,43,44],[44,41,44,44],[45,41,45,44],[26,4,26,17],[28,4,28,17],[41,18,41,20],[37,22,38,22],[38,41,38,44],[39,41,39,44],[40,41,40,44],[41,41,41,44],[26,19,27,24],[28,19,28,24],[42,18,42,22],[43,19,43,21],[8,1,8,20],[36,18,36,22],[37,18,37,20],[38,18,38,20],[39,18,39,20],[26,1,26,3],[28,1,28,3],[37,2,37,5],[30,4,32,17],[33,4,35,17],[37,23,38,25],[39,23,40,25],[41,23,41,25],[40,18,40,20],[58,2,58,5],[56,2,56,5],[57,2,57,5],[50,2,50,5],[51,2,51,5],[52,2,52,5],[53,2,53,5],[54,2,54,5],[55,2,55,5],[49,2,49,5],[38,2,38,5],[39,2,39,5],[47,2,47,5],[48,2,48,5],[44,2,44,5],[45,2,45,5],[40,2,40,5],[41,2,41,5],[42,2,42,5],[43,2,43,5],[46,2,46,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Calculator"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Required qualification:",null,null,"SELECT QUALIFICATION HERE",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO39=3,\"PATHWAY\",IF(AO39=4,\"PATHWAY2\",\"\"))","v":""},{"$f":"IFERROR(IF(E27=\"SELECT QUALIFICATION HERE\",\"\",IF(AO41=0,\"\",INDEX(ValCombs!N10:N24,(MATCH(AO41,ValCombs!M10:M24,0))))),\"\")","v":""}]
[]
[null,"Required pathway:",null,null,"SELECT PATHWAY HERE"]
[]
[null,null,null,null,{"$f":"IF(OR(AO41=15,AO41=30,AO41=75,AO41=105,AO41=135,AO41=220,AO41=260,AO41=90),\"Click 'NEXT' to view the available units for this qualification.\",\"\")","v":""}]
[]
[]
[]
[]
[]
[null,"Key:  M Mandatory   O Optional  ",null,null,null,null,null,null,null,"Activity Leadership","Fitness Instructing","Recreational Assistant","Sports Coaching","Personal Training",null,null,null,null,"Summary Table:"]
[null,"Unit  No.","Unit Title",null,null,null,"GLH","M/O","M/O","M/O","M/O","M/O","M/O","M/O","M/O","M/O","Select",null,"Total GLH required:",null,null,0,{"$f":"IF(V38=0,\"\",IF(OR(V38=V39,V39=V38+30),\"ü\",\"û\"))","v":""},{"$f":"IF(V38=0,\"\",IF(V39<V38,\"Please select more units to achieve the required GLH.\",IF(V39=V38,\"You have a valid selection.\",IF(V39=V38+30,\"You have a valid selection, but have selected more than the required GLH. Please correct this if it is not what you intended.\",IF(V39>V38+30,\"You have selected many more GLH than required. Please revise your selection.\",\"\")))))","v":""},null,null,null,null,"Unit  No.","Link Cell","Mand. Flag","Mand. Selected","Mand. GLH","PO Flag","PO Selected","PO GLH","Unavail. Units","Unavail. Selected","Total Selected GLH",null,"Flags"]
[null,1,{"$f":"ValUnits!C13","v":"Body systems and the effects of physical activity"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D13","v":90},{"$f":"ValUnits!F13","v":"M"},{"$f":"ValUnits!G13","v":"M"},{"$f":"ValUnits!I13","v":"M"},{"$f":"ValUnits!J13","v":"M"},{"$f":"ValUnits!K13","v":"M"},{"$f":"ValUnits!M13","v":"M"},{"$f":"ValUnits!N13","v":"M"},{"$f":"ValUnits!P13","v":"M"},"M",null,null,"Total GLH selected:",null,null,{"$f":"AM60","v":0},null,null,null,null,null,null,1,false,0,{"$f":"IF(AND(AE39=1,AD39=TRUE),1,0)","v":0},0,0,0,0,0,{"$f":"IF(AND(AD39=TRUE,AK39=1),1,0)","v":0},{"$f":"IF(AD39=TRUE,G39,0)","v":0},null,{"$f":"INDEX(ValQuals!J10:J19,(MATCH(Calculator!E27,ValQuals!B10:B19,0)))","v":0},"Qualification Flag"]
[null,2,{"$f":"ValUnits!C14","v":"Sports coaching and activity leadership"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D14","v":90},{"$f":"ValUnits!F14","v":"M"},{"$f":"ValUnits!G14","v":"M"},{"$f":"ValUnits!I14","v":"M"},{"$f":"ValUnits!J14","v":"M"},{"$f":"ValUnits!K14","v":"M"},{"$f":"ValUnits!M14","v":"M"},{"$f":"ValUnits!N14","v":"M"},{"$f":"ValUnits!P14","v":"M"},"M",null,null,"Mandatory units selected:",null,null,{"$f":"AF60","v":0},{"$f":"IF(V40=0,\"\",IF($AE$60=$AF$60,\"ü\",\"û\"))","v":""},null,null,null,null,null,2,false,0,{"$f":"IF(AND(AE40=1,AD40=TRUE),1,0)","v":0},0,0,{"$f":"IF(AND(AD40=TRUE,AH40=1),1,0)","v":0},0,0,{"$f":"IF(AND(AD40=TRUE,AK40=1),1,0)","v":0},0,null,{"$f":"INDEX(ValCombs!L10:L24,(MATCH(Calculator!E29,ValCombs!C10:C24,0)))","v":15},"Pathway Flag"]
[null,3,{"$f":"ValUnits!C15","v":"Sports organisation and development"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D15","v":60},{"$f":"ValUnits!F15","v":"---"},{"$f":"ValUnits!G15","v":"M"},{"$f":"ValUnits!I15","v":"M"},{"$f":"ValUnits!J15","v":"M"},{"$f":"ValUnits!K15","v":"M"},{"$f":"ValUnits!M15","v":"M"},{"$f":"ValUnits!N15","v":"M"},{"$f":"ValUnits!P15","v":"M"},"M",null,null,null,null,null,null,null,null,null,null,null,null,3,false,0,0,0,0,0,0,0,0,0,null,{"$f":"AO39*AO40","v":0},"Combination Flag"]
[null,4,{"$f":"ValUnits!C16","v":"Working safely in sport, exercise, health and leisure"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D16","v":90},{"$f":"ValUnits!F16","v":"---"},{"$f":"ValUnits!G16","v":"---"},{"$f":"ValUnits!I16","v":"M"},{"$f":"ValUnits!J16","v":"M"},{"$f":"ValUnits!K16","v":"M"},{"$f":"ValUnits!M16","v":"M"},{"$f":"ValUnits!N16","v":"M"},{"$f":"ValUnits!P16","v":"M"},"M",null,null,null,null,null,null,null,null,null,null,null,null,4,false,0,0,0,0,0,0,0,0,0]
[null,5,{"$f":"ValUnits!C17","v":"Performance analysis in sport and exercise"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D17","v":60},{"$f":"ValUnits!F17","v":"---"},{"$f":"ValUnits!G17","v":"O"},{"$f":"ValUnits!I17","v":"---"},{"$f":"ValUnits!J17","v":"---"},{"$f":"ValUnits!K17","v":"---"},{"$f":"ValUnits!M17","v":"M"},{"$f":"ValUnits!N17","v":"---"},{"$f":"ValUnits!P17","v":"M"},"M",null,null,{"$f":"V39","v":0},null,null,null,null,null,null,null,null,null,5,false,0,0,0,0,0,0,0,0,0,null,0,"No. of mandatory units required"]
[null,6,{"$f":"ValUnits!C18","v":"Group exercise to music"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D18","v":60},{"$f":"ValUnits!F18","v":"---"},{"$f":"ValUnits!G18","v":"---"},{"$f":"ValUnits!I18","v":"---"},{"$f":"ValUnits!J18","v":"M"},{"$f":"ValUnits!K18","v":"---"},{"$f":"ValUnits!M18","v":"---"},{"$f":"ValUnits!N18","v":"M"},{"$f":"ValUnits!P18","v":"O"},"O",null,null,0,"Progress Bar",null,null,{"$f":"V38","v":0},null,null,null,null,null,6,false,0,0,0,0,0,0,0,{"$f":"IF(AND(AD44=TRUE,AK44=1),1,0)","v":0},0]
[null,7,{"$f":"ValUnits!C19","v":"Improving fitness for sport and physical activity"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D19","v":60},{"$f":"ValUnits!F19","v":"---"},{"$f":"ValUnits!G19","v":"---"},{"$f":"ValUnits!I19","v":"---"},{"$f":"ValUnits!J19","v":"---"},{"$f":"ValUnits!K19","v":"---"},{"$f":"ValUnits!M19","v":"---"},{"$f":"ValUnits!N19","v":"M"},{"$f":"ValUnits!P19","v":"M"},"O",null,null,null,null,null,null,null,null,null,null,null,null,7,false,0,0,0,0,0,0,0,{"$f":"IF(AND(AD45=TRUE,AK45=1),1,0)","v":0},0]
[null,8,{"$f":"ValUnits!C20","v":"Organisation of sports events"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D20","v":60},{"$f":"ValUnits!F20","v":"---"},{"$f":"ValUnits!G20","v":"O"},{"$f":"ValUnits!I20","v":"O"},{"$f":"ValUnits!J20","v":"---"},{"$f":"ValUnits!K20","v":"M"},{"$f":"ValUnits!M20","v":"M"},{"$f":"ValUnits!N20","v":"---"},{"$f":"ValUnits!P20","v":"M"},"---",null,null,null,null,null,null,null,null,null,null,null,null,8,false,0,0,0,0,0,0,0,0,0]
[null,9,{"$f":"ValUnits!C21","v":"Unused"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D21","v":0},{"$f":"ValUnits!F21","v":"---"},{"$f":"ValUnits!G21","v":"---"},{"$f":"ValUnits!I21","v":"---"},{"$f":"ValUnits!J21","v":"---"},{"$f":"ValUnits!K21","v":"---"},{"$f":"ValUnits!M21","v":"---"},{"$f":"ValUnits!N21","v":"---"},{"$f":"ValUnits!P21","v":"---"},"M",null,null,null,null,null,null,null,null,null,null,null,null,9,null,0,null,null,0,null,null,0]
[null,10,{"$f":"ValUnits!C22","v":"Biomechanics and movement analysis"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D22","v":60},{"$f":"ValUnits!F22","v":"---"},{"$f":"ValUnits!G22","v":"O"},{"$f":"ValUnits!I22","v":"---"},{"$f":"ValUnits!J22","v":"---"},{"$f":"ValUnits!K22","v":"---"},{"$f":"ValUnits!M22","v":"O"},{"$f":"ValUnits!N22","v":"O"},{"$f":"ValUnits!P22","v":"O"},"M",null,null,null,null,null,null,null,null,null,null,null,null,10,false,0,0,0,0,0,0,0,0,0]
[null,11,{"$f":"ValUnits!C23","v":"Physical activity for specific groups"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D23","v":30},{"$f":"ValUnits!F23","v":"---"},{"$f":"ValUnits!G23","v":"O"},{"$f":"ValUnits!I23","v":"M"},{"$f":"ValUnits!J23","v":"M"},{"$f":"ValUnits!K23","v":"M"},{"$f":"ValUnits!M23","v":"M"},{"$f":"ValUnits!N23","v":"M"},{"$f":"ValUnits!P23","v":"M"},"M",null,null,null,null,null,null,null,null,null,null,null,null,11,false,0,0,0,0,0,0,0,0,0]
[null,12,{"$f":"ValUnits!C24","v":"Nutrition and diet for sport and exercise"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D24","v":30},{"$f":"ValUnits!F24","v":"---"},{"$f":"ValUnits!G24","v":"O"},{"$f":"ValUnits!I24","v":"O"},{"$f":"ValUnits!J24","v":"O"},{"$f":"ValUnits!K24","v":"O"},{"$f":"ValUnits!M24","v":"O"},{"$f":"ValUnits!N24","v":"O"},{"$f":"ValUnits!P24","v":"M"},"M",null,null,null,null,null,null,null,null,null,null,null,null,12,false,0,0,0,0,0,0,0,0,0]
[null,13,{"$f":"ValUnits!C25","v":"Health and fitness testing for sport and exercise"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D25","v":60},{"$f":"ValUnits!F25","v":"---"},{"$f":"ValUnits!G25","v":"---"},{"$f":"ValUnits!I25","v":"---"},{"$f":"ValUnits!J25","v":"O"},{"$f":"ValUnits!K25","v":"---"},{"$f":"ValUnits!M25","v":"O"},{"$f":"ValUnits!N25","v":"M"},{"$f":"ValUnits!P25","v":"O"},"M",null,null,null,null,null,null,null,null,null,null,null,null,13,false,0,0,0,0,0,0,0,0,0]
[null,14,{"$f":"ValUnits!C26","v":"Working in active leisure facilities"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D26","v":60},{"$f":"ValUnits!F26","v":"---"},{"$f":"ValUnits!G26","v":"---"},{"$f":"ValUnits!I26","v":"---"},{"$f":"ValUnits!J26","v":"---"},{"$f":"ValUnits!K26","v":"M"},{"$f":"ValUnits!M26","v":"---"},{"$f":"ValUnits!N26","v":"---"},{"$f":"ValUnits!P26","v":"M"},"---",null,null,null,null,null,null,null,null,null,null,null,null,14,false,0,0,0,0,0,0,0,0,0]
[null,15,{"$f":"ValUnits!C27","v":"Unused"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D27","v":0},{"$f":"ValUnits!F27","v":"---"},{"$f":"ValUnits!G27","v":"---"},{"$f":"ValUnits!I27","v":"---"},{"$f":"ValUnits!J27","v":"---"},{"$f":"ValUnits!K27","v":"---"},{"$f":"ValUnits!M27","v":"---"},{"$f":"ValUnits!N27","v":"---"},{"$f":"ValUnits!P27","v":"---"},"---",null,null,null,null,null,null,null,null,null,null,null,null,15,null,0,null,null,0,null,null,0]
[null,16,{"$f":"ValUnits!C28","v":"Unused"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D28","v":0},{"$f":"ValUnits!F28","v":"---"},{"$f":"ValUnits!G28","v":"---"},{"$f":"ValUnits!I28","v":"---"},{"$f":"ValUnits!J28","v":"---"},{"$f":"ValUnits!K28","v":"---"},{"$f":"ValUnits!M28","v":"---"},{"$f":"ValUnits!N28","v":"---"},{"$f":"ValUnits!P28","v":"---"},"---",null,null,null,null,null,null,null,null,null,null,null,null,16,null,0,null,null,0,null,null,0]
[null,17,{"$f":"ValUnits!C29","v":"Sports injuries and rehabilitation"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D29","v":60},{"$f":"ValUnits!F29","v":"---"},{"$f":"ValUnits!G29","v":"O"},{"$f":"ValUnits!I29","v":"O"},{"$f":"ValUnits!J29","v":"O"},{"$f":"ValUnits!K29","v":"O"},{"$f":"ValUnits!M29","v":"M"},{"$f":"ValUnits!N29","v":"O"},{"$f":"ValUnits!P29","v":"M"},"M",null,null,null,null,null,null,null,null,null,null,null,null,17,false,0,0,0,0,0,0,0,0,0]
[null,18,{"$f":"ValUnits!C30","v":"Practical skills in sport and physical activities"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D30","v":60},{"$f":"ValUnits!F30","v":"---"},{"$f":"ValUnits!G30","v":"O"},{"$f":"ValUnits!I30","v":"O"},"---",{"$f":"ValUnits!K30","v":"O"},{"$f":"ValUnits!M30","v":"M"},{"$f":"ValUnits!N30","v":"---"},{"$f":"ValUnits!P30","v":"M"},"O",null,null,null,null,null,null,null,null,null,null,null,null,18,false,0,0,0,0,0,0,0,0,0]
[null,19,{"$f":"ValUnits!C31","v":"Sport and exercise psychology"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D31","v":60},{"$f":"ValUnits!F31","v":"---"},{"$f":"ValUnits!G31","v":"O"},{"$f":"ValUnits!I31","v":"---"},{"$f":"ValUnits!J31","v":"---"},{"$f":"ValUnits!K31","v":"---"},{"$f":"ValUnits!M31","v":"O"},{"$f":"ValUnits!N31","v":"O"},{"$f":"ValUnits!P31","v":"O"},"M",null,null,null,null,null,null,null,null,null,null,null,null,19,false,0,0,0,0,0,0,0,0,0]
[null,20,{"$f":"ValUnits!C32","v":"Sport and exercise sociology"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D32","v":60},{"$f":"ValUnits!F32","v":"---"},{"$f":"ValUnits!G32","v":"O"},{"$f":"ValUnits!I32","v":"---"},{"$f":"ValUnits!J32","v":"---"},{"$f":"ValUnits!K32","v":"---"},{"$f":"ValUnits!M32","v":"---"},{"$f":"ValUnits!N32","v":"---"},{"$f":"ValUnits!P32","v":"O"},"M",null,null,null,null,null,null,null,null,null,null,null,null,20,false,0,0,0,0,0,0,0,0,0]
[null,21,{"$f":"ValUnits!C33","v":"The business of sport"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D33","v":90},{"$f":"ValUnits!F33","v":"---"},{"$f":"ValUnits!G33","v":"---"},{"$f":"ValUnits!I33","v":"---"},{"$f":"ValUnits!J33","v":"---"},{"$f":"ValUnits!K33","v":"---"},{"$f":"ValUnits!M33","v":"---"},{"$f":"ValUnits!N33","v":"---"},{"$f":"ValUnits!P33","v":"M"},"M",null,null,null,null,null,null,null,null,null,null,null,null,21,false,0,{"$f":"IF(AND(AE59=1,AD59=TRUE),1,0)","v":0},0,0,{"$f":"IF(AND(AD59=TRUE,AH59=1),1,0)","v":0},0,0,{"$f":"IF(AND(AD59=TRUE,AK59=1),1,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE39:AE59)","v":0},{"$f":"SUM(AF39:AF59)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mand. Flag","Mand. Selected","Mand. GLH","PO Flag","PO Selected","PO GLH","Unavail. Units","Unavail. Selected","Total Selected GLH"]

{"sheet":"Summary","index":2,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[13,1,13,4],[13,5,13,10],[7,1,7,11],[8,1,8,10],[10,1,10,10],[12,1,12,4],[12,5,12,10],[20,2,20,9],[14,1,14,4],[14,5,14,10],[15,1,15,4],[15,5,15,10],[16,1,16,4],[16,5,16,6],[17,1,17,4],[17,5,17,6],[16,7,17,10],[32,2,32,9],[21,2,21,9],[22,2,22,9],[23,2,23,9],[24,2,24,9],[25,2,25,9],[26,2,26,9],[27,2,27,9],[28,2,28,9],[29,2,29,9],[30,2,30,9],[31,2,31,9],[41,2,41,9],[39,2,39,9],[40,2,40,9],[33,2,33,9],[34,2,34,9],[35,2,35,9],[36,2,36,9],[37,2,37,9],[38,2,38,9]]}
[]
[]
[]
[]
[]
[]
[]
[null,"OCR Cambridge Technical in Sport and Physical Activity Level 3"]
[null,{"$f":"Calculator!E27","v":"SELECT QUALIFICATION HERE"}]
[null,{"$f":"IF(Calculator!E29=\"SELECT PATHWAY HERE\",\"\",Calculator!E29)","v":""}]
[null,"Summary Sheet"]
[]
[null,"Learner's Name:"]
[null,"Tutor's Name:"]
[null,"Centre Name:"]
[null,"Centre Number:"]
[null,"Guided Learning Hours (GLH) Required:",null,null,null,{"$f":"Calculator!V38","v":0}]
[null,"Guided Learning Hours (GLH) Selected:",null,null,null,{"$f":"Calculator!V39","v":0}]
[null,"Selected units:"]
[]
[null,"Unit No.","Unit Title",null,null,null,null,null,null,null,"GLH"]
[null,1,{"$f":"ValUnits!C13","v":"Body systems and the effects of physical activity"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D13","v":90}]
[null,2,{"$f":"ValUnits!C14","v":"Sports coaching and activity leadership"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D14","v":90}]
[null,3,{"$f":"ValUnits!C15","v":"Sports organisation and development"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D15","v":60}]
[null,4,{"$f":"ValUnits!C16","v":"Working safely in sport, exercise, health and leisure"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D16","v":90}]
[null,5,{"$f":"ValUnits!C17","v":"Performance analysis in sport and exercise"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D17","v":60}]
[null,6,{"$f":"ValUnits!C18","v":"Group exercise to music"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D18","v":60}]
[null,7,{"$f":"ValUnits!C19","v":"Improving fitness for sport and physical activity"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D19","v":60}]
[null,8,{"$f":"ValUnits!C20","v":"Organisation of sports events"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D20","v":60}]
[null,9,{"$f":"ValUnits!C21","v":"Unused"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D21","v":0}]
[null,10,{"$f":"ValUnits!C22","v":"Biomechanics and movement analysis"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D22","v":60}]
[null,11,{"$f":"ValUnits!C23","v":"Physical activity for specific groups"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D23","v":30}]
[null,12,{"$f":"ValUnits!C24","v":"Nutrition and diet for sport and exercise"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D24","v":30}]
[null,13,{"$f":"ValUnits!C25","v":"Health and fitness testing for sport and exercise"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D25","v":60}]
[null,14,{"$f":"ValUnits!C26","v":"Working in active leisure facilities"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D26","v":60}]
[null,15,{"$f":"ValUnits!C27","v":"Unused"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D27","v":0}]
[null,16,{"$f":"ValUnits!C28","v":"Unused"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D28","v":0}]
[null,17,{"$f":"ValUnits!C29","v":"Sports injuries and rehabilitation"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D29","v":60}]
[null,18,{"$f":"ValUnits!C30","v":"Practical skills in sport and physical activities"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D30","v":60}]
[null,19,{"$f":"ValUnits!C31","v":"Sport and exercise psychology"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D31","v":60}]
[null,20,{"$f":"ValUnits!C32","v":"Sport and exercise sociology"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D32","v":60}]
[null,21,{"$f":"ValUnits!C33","v":"The business of sport"},"Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity","Body systems and the effects of physical activity",{"$f":"ValUnits!D33","v":90}]

{"sheet":"ValQuals","index":3,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":true,"merged":[[3,1,3,9]]}
[]
[null,"Validation Page - Qualification"]
[]
[null,"The table below outlines the structure of the qualifications covered by this Qualifications Calculater. Changes made on this page will perculate through the other pages of this QC. DO NOT CHANGE any data on this page, unless you are sure about the implications."]
[]
[null,"Qualification Look Up Table"]
[null,"Space has been left in the table for later changes or additions to the qualifications."]
[]
[null,"Qualification Name","Total   GLH","Total Units Required","No. of Mandatory Units","GLH from Mandatory Units","No. of PO Units","GLH from PO Units","Max GLH from O* Units ","Qual Code"]
[null,"SELECT QUALIFICATION HERE",null,null,null,null,null,null,null,0]
[null,"Level 3 Cambridge Technical Certificate in Sport and Physical Activity",180,2,2,180,0,0,0,1]
[null,"Level 3 Cambridge Technical Extended Certificate in Sport and Physical Activity",360,5,3,240,0,0,0,2]
[]
[null,"Level 3 Cambridge Technical Foundation Diploma in Sport and Physical Activity",540,null,"6 / 7",540,0,0,0,3]
[]
[null,"Level 3 Cambridge Technical Diploma in Sport and Physical Activity",720,10,8,720,0,0,0,4]
[]
[null,"Level 3 Cambridge Technical Extended Diploma in Sport and Physical Activity Development",1080,null,13,840,0,0,0,6]

{"sheet":"ValUnits","index":4,"n_rows":47,"n_cols":40,"rows_kept":47,"cut":false,"hidden":true,"merged":[[11,5,11,18],[10,22,10,39],[3,1,3,12],[6,1,6,12]]}
[]
[null,"Validation Page - Units"]
[]
[null,"The table below outlines the structure of the units for each qualifications covered by this Qualifications Calculater. Changes made on this page will perculate through the other pages of this QC. DO NOT CHANGE any data on this page, unless you are sure about the implications."]
[]
[null,"Units Look Up Table"]
[null,"Space has been left in the table for later changes or additions to the qualifications. To help identify any errors in the data table, see the Error Trapping Table to the right of the main table, below."]
[]
[]
[null,null,null,null,null,"Level 3 Cambridge Technical Certificate in Sport and Physical Activity","Level 3 Cambridge Technical Extended Certificate in Sport and Physical Activity",null,"Level 3 Cambridge Technical Foundation Diploma in Sport and Physical Activity","Level 3 Cambridge Technical Foundation Diploma in Sport and Physical Activity","Level 3 Cambridge Technical Foundation Diploma in Sport and Physical Activity",null,"Level 3 Cambridge Technical Diploma in Sport and Physical Activity","Level 3 Cambridge Technical Diploma in Sport and Physical Activity",null,"Level 3 Cambridge Technical Extended Diploma in Sport and Physical Activity Development","Level 3 Cambridge Technical Extended Diploma in Sport and Physical Activity"]
[null,null,null,null,"Pathways","N/A","N/A",null,"Activity Leadership","Fitness Instructing","Recreational Assistant",null,"Sports Coaching","Personal Training",null,"N/A","Sport Science",null,null,null,null,null,"Error Trapping Table - the table below will help to identify where data is missing or may be incorrect in the main table. If any notes appear in this table check the corresponding cell in the main table for possible errors."]
[null,"Unit No.","Unit Name","GLH","Assessment Type","Pathway Unit Types",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S"]
[null,1,"Body systems and the effects of physical activity",90,"External","M","M",null,"M","M","M",null,"M","M",null,"M","M",null,null,null,null,13,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,2,"Sports coaching and activity leadership",90,"Internal","M","M",null,"M","M","M",null,"M","M",null,"M","M",null,null,null,null,14,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,3,"Sports organisation and development",60,"External","---","M",null,"M","M","M",null,"M","M",null,"M","M",null,null,null,null,15,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,4,"Working safely in sport, exercise, health and leisure",90,"External","---","---",null,"M","M","M",null,"M","M",null,"M","M",null,null,null,null,16,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,5,"Performance analysis in sport and exercise",60,"Internal","---","O",null,"---","---","---",null,"M","---",null,"M","M",null,null,null,null,17,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,6,"Group exercise to music",60,"Internal","---","---",null,"---","M","---",null,"---","M",null,"O","O",null,null,null,null,18,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,7,"Improving fitness for sport and physical activity",60,"Internal","---","---",null,"---","---","---",null,"---","M",null,"M","M",null,null,null,null,19,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,8,"Organisation of sports events",60,"Internal","---","O",null,"O","---","M",null,"M","---",null,"M","---",null,null,null,null,20,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,9,"Unused",null,null,"---","---",null,"---","---","---",null,"---","---",null,"---","---",null,null,null,null,21,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,10,"Biomechanics and movement analysis",60,"Internal","---","O",null,"---","---","---",null,"O","O",null,"O","M",null,null,null,null,22,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,11,"Physical activity for specific groups",30,"Internal","---","O",null,"M","M","M",null,"M","M",null,"M","M",null,null,null,null,23,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,12,"Nutrition and diet for sport and exercise",30,"Internal","---","O",null,"O","O","O",null,"O","O",null,"M","M",null,null,null,null,24,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,13,"Health and fitness testing for sport and exercise",60,"Internal","---","---",null,"---","O","---",null,"O","M",null,"O","M",null,null,null,null,25,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,14,"Working in active leisure facilities",60,"Internal","---","---",null,"---","---","M",null,"---","---",null,"M","---",null,null,null,null,26,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,15,"Unused",null,null,"---","---",null,"---","---","---",null,"---","---",null,"---","---",null,null,null,null,27,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,16,"Unused",null,null,"---","---",null,"---","---","---",null,"---","---",null,"---","---",null,null,null,null,28,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,17,"Sports injuries and rehabilitation",60,"Internal","---","O",null,"O","O","O",null,"M","O",null,"M","M",null,null,null,null,29,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,18,"Practical skills in sport and physical activities",60,"Internal","---","O",null,"O","O","O",null,"M","---",null,"M","O",null,null,null,null,30,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,19,"Sport and exercise psychology",60,"Internal","---","O",null,"---","---","---",null,"O","O",null,"O","M",null,null,null,null,31,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,20,"Sport and exercise sociology",60,"Internal","---","O",null,"---","---","---",null,"---","---",null,"O","M",null,null,null,null,32,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,21,"The business of sport",90,"External","---","---",null,"---","---","---",null,"---","---",null,"M","M",null,null,null,null,33,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,22,"Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"",null,"",null,"","","Missing","","Missing","","","Missing","","Missing","Missing","Missing","Missing","Missing"]
[null,23,"Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"",null,"",null,"","","","","","","","","","","","","",""]
[null,24,"Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"",null,"",null,"","","","","","","","","","","","","",""]
[null,25,"Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"",null,"",null,"","","","","","","","","","","","","",""]
[null,26,"Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"",null,"",null,"","","","","","","","","","","","","",""]
[null,27,"Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"",null,"",null,"","","","","","","","","","","","","",""]
[null,28,"Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"",null,"",null,"","","","","","","","","","","","","",""]
[null,29,"Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,"",null,"",null,"","","","","","","","","","","","","",""]
[null,30,"Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"",null,"",null,"","","","","","","","","","","","","",""]
[]
[]
[null,null,null,"Number of Mandatory Units",null,{"$f":"COUNTIF(F13:F42,\"M\")","v":2},{"$f":"COUNTIF(G13:G42,\"M\")","v":3},0,5,6,7,0,9,8,0,13,14,0,0]
[]
[null,null,null,"Number of PO Units",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"ValCombs","index":5,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":true,"merged":[[3,1,3,13]]}
[]
[null,"Validation Page - Combinations"]
[]
[null,"The table below outlines the possible qualification and pathway combinations that are available for the qualifications covered by this Qualifications Calculater. Changes made on this page will perculate through the other pages of this QC. DO NOT CHANGE any data on this page, unless you are sure about the implications."]
[]
[null,"Combinations Look Up Table"]
[null,"Space has been left in the table for later changes or additions to the qualifications."]
[]
[null,"Qualification Name","Pathway","Total   GLH","Total Units Required","No. of Mandatory Units","GLH from Mandatory Units","No. of PO Units","GLH from PO Units","Max GLH from O* Units ","Qual Code","Path Code","Comb Code","Descriptive Statement","Calculator Table Column Letter","No. of Mand Units in words"]
[null,"SELECT QUALIFICATION HERE","SELECT PATHWAY HERE",null,null,null,null,null,null,null,0,15,{"$f":"K10*L10","v":0}]
[null,"Level 3 Cambridge Technical Certificate in Sport and Physical Activity",null,180,2,2,120,0,0,0,1,15,{"$f":"K11*L11","v":15},{"$f":"CONCATENATE(\"For this qualification learners must achieve an appropriate combination of 30, 60 and 90 GLH units, totalling \",D11,\" GLH (\",P11,\" of which are mandatory.)\")","v":"For this qualification learners must achieve an appropriate combination of 30, 60 and 90 GLH units, totalling 180 GLH (two of which are mandatory.)"},"H","two"]
[null,"Level 3 Cambridge Technical Extended Certificate in Sport and Physical Activity",null,360,5,3,240,0,0,0,2,15,30,{"$f":"CONCATENATE(\"For this qualification learners must achieve an appropriate combination of 30, 60 and 90 GLH units, totalling \",D12,\" GLH (\",P12,\" of which are mandatory.)\")","v":"For this qualification learners must achieve an appropriate combination of 30, 60 and 90 GLH units, totalling 360 GLH (three of which are mandatory.)"},"I","three"]
[null,"Level 3 Cambridge Technical Foundation Diploma in Sport and Physical Activity","Activity Leadership",540,null,5,360,0,0,0,3,25,75,"For this qualification learners must achieve an appropriate combination of 30, 60 and 90 GLH units, totalling 540 GLH (five of which are mandatory.)","J","five"]
[null,"Level 3 Cambridge Technical Foundation Diploma in Sport and Physical Activity","Fitness Instructing",540,null,6,420,0,0,0,3,35,105,"For this qualification learners must achieve an appropriate combination of 30, 60 and 90 GLH units, totalling 540 GLH (six of which are mandatory.)","K","six"]
[null,"Level 3 Cambridge Technical Foundation Diploma in Sport and Physical Activity","Recreational Assistant",540,null,7,480,0,0,0,3,45,135,"For this qualification learners must achieve an appropriate combination of 30, 60 and 90 GLH units, totalling 540 GLH (seven of which are mandatory.)","L","seven"]
[null,"Level 3 Cambridge Technical Diploma in Sport and Physical Activity","Sports Coaching",720,null,9,600,0,0,0,4,55,220,"For this qualification learners must achieve an appropriate combination of 30, 60 and 90 GLH units, totalling 720 GLH (nine of which are mandatory.)","M","nine"]
[null,"Level 3 Cambridge Technical Diploma in Sport and Physical Activity","Personal Training",720,null,8,540,0,0,0,4,65,260,"For this qualification learners must achieve an appropriate combination of 30, 60 and 90 GLH units, totalling 720 GLH (eight of which are mandatory.)","N","eight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O"]
[null,"Level 3 Cambridge Technical Extended Diploma in Sport and Physical Activity Development",null,1080,15,13,840,0,0,0,6,15,90,{"$f":"CONCATENATE(\"For this qualification learners must achieve an appropriate combination of 30, 60 and 90 GLH units, totalling \",D19,\" GLH (\",P19,\" of which are mandatory.)\")","v":"For this qualification learners must achieve an appropriate combination of 30, 60 and 90 GLH units, totalling 1080 GLH (thirteen of which are mandatory.)"},"P","thirteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U"]

{"sheet":"ValDrops","index":6,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":true,"merged":[[14,1,16,1],[17,3,19,3],[15,7,17,7],[18,5,20,5],[3,1,3,12]]}
[]
[null,"Validation Page - Dropdowns"]
[]
[null,"This page defines the dropdown lists used on various pages of the Qualifications Calculater. Changes made on this page will perculate through the other pages of this QC. DO NOT CHANGE any data on this page, unless you are sure about the implications."]
[]
[null,"Drowdown Lists"]
[null,"Each list has a descriptive name, its defined NAME within this workbook, a reference to where it is used and the list items. Dependent lists are indicated by an arrow between them."]
[]
[null,"Assessment Type",null,"Unit Types",null,"Qualifications Available",null,"Pathways Available",null,"Pathways Available",null,"Pathways Available"]
[null,"ASSTYPE",null,"UNITTYPE",null,"QUALS",null,"PATHWAY",null,"PATHWAY2",null,"PATHWAY3"]
[null,"External",null,"M",null,"SELECT QUALIFICATION HERE",null,"SELECT PATHWAY HERE",null,"SELECT PATHWAY HERE",null,"SELECT PATHWAY HERE"]
[null,"Internal",null,"PO",null,"Level 3 Cambridge Technical Certificate in Sport and Physical Activity",null,"Activity Leadership",null,"Sports Coaching",null,"Sport Studies"]
[null,null,null,"O",null,"Level 3 Cambridge Technical Extended Certificate in Sport and Physical Activity",null,"Fitness Instructing",null,"Personal Training",null,"Sport Science"]
[null,null,null,"O*",null,"Level 3 Cambridge Technical Foundation Diploma in Sport and Physical Activity",null,"Recreational Assistant"]
[null,"Used within the Units Look-up Table on the ValUnits page.",null,"---",null,"Level 3 Cambridge Technical Diploma in Sport and Physical Activity"]
[null,null,null,null,null,"Level 3 Cambridge Technical Extended Diploma in Sport and Physical Activity Development",null,"Used on the Calculator Page to select the Pathway"]
[]
[null,null,null,"Used within the Units Look-up Table on the ValUnits page."]
[null,null,null,null,null,"Used on the Calculator Page to select the qualification type"]

{"sheet":"For Info","index":7,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[null,"For Information"]
[]
[]
[null,"Main Colour",null,"Calculator Hidden Table Ref","Column","Rows"]
[null,"28 : 63 : 119",null,"Mandatory Unit Flags","AJ"]
[null,null,null,"PO Unit Flags","AM"]
[null,"Highlight Colour",null,"Unavailable Unit Flags","AP"]
[null,"168 : 193 : 234",null,"Select Units (True/False)","AI"]
[]
[null,"Second Highlight Colour",null,"Unit Type Columns","H:U"]
[null,"211 : 224 : 245",null,"No. Mandatory Unite Requ","AT"]
[null,null,null,"Summary Table ","AA"]