{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Overview","Data","Directly","Reference","COUNTA","VBA"],"not_rendered":{"charts":0,"images":0,"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":"Overview","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,4],[13,1,13,4],[4,1,5,4]]}
[]
[null,"Overview of COMBIN function"]
[]
[null,"=COMBIN(number, number_chosen)",null,null,null,">> syntax"]
[null,">> COMBIN function returns the number of combinations for a given number of items"]
[]
[null,"Number","Number_Chosen","Function","Output"]
[null,20,1,"=COMBIN(20,1)",{"$f":"COMBIN(B8,C8)","v":20},">> no of combinations for groups of 1 item out of 20"]
[null,20,2,"=COMBIN(20,2)",{"$f":"COMBIN(B9,C9)","v":190},">> no of combinations for groups of 2 item out of 20"]
[null,20,3,"=COMBIN(20,3)",1140,">> no of combinations for groups of 3 item out of 20"]
[null,20,4,"=COMBIN(20,4)",4845,">> no of combinations for groups of 4 item out of 20"]
[null,20,5,"=COMBIN(20,5)",15503.999999999998,">> no of combinations for groups of 5 item out of 20"]

{"sheet":"Data","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[9,1,9,2]]}
[]
[null,"Dataset Overview"]
[]
[null,"ID","Player"]
[null,1,"Mike"]
[null,2,"Adam"]
[null,3,"Stuart"]
[null,4,"David"]
[null,5,"Parker"]
[null,">> Total number of Players = 5"]

{"sheet":"Directly","index":2,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,11,1,14],[3,6,3,7],[14,6,14,7],[1,1,1,7]]}
[]
[null,"Calculating Number of Combinations Directly",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"ID","Player",null,null,null,"Possible Teams",null,null,null,null,"ID","Player"]
[null,1,"Mike",null,null,null,"Team: 1","Mike-Adam",null,null,null,1,"Mike"]
[null,2,"Adam",null,null,null,"Team: 2","Mike-Stuart",null,null,null,2,"Adam"]
[null,3,"Stuart",null,"No of Combinations",null,"Team: 3","Mike-David",null,null,null,3,"Stuart",null,"No of Combinations"]
[null,4,"David",null,{"$f":"COMBIN(5,2)","v":10},null,"Team: 4","Mike-Parker",null,null,null,4,"David"]
[null,5,"Parker",null,null,null,"Team: 5","Adam-Stuart",null,null,null,5,"Parker"]
[null,">> Total number of Players = 5",null,null,null,null,"Team: 6","Adam-David",null,null,null,6,"John"]
[null,null,null,null,null,null,"Team: 7","Adam-Parker",null,null,null,7,"Bob"]
[null,null,null,null,null,null,"Team: 8","Stuart-David",null,null,null,8,"Parker"]
[null,null,null,null,null,null,"Team: 9","Stuart-Parker",null,null,null,9,"Harker"]
[null,null,null,null,null,null,"Team: 10","David-Parker",null,null,null,10,"milford"]
[null,null,null,null,null,null,">>Total number of Teams= 10"]

{"sheet":"Reference","index":3,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using Cell Reference",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Chosen Players","No of Combination",null,null,null,null,null,"Chosen Players","No of Combination"]
[null,1,{"$f":"COMBIN($E$7,B5)","v":5},null,null,null,null,null,1]
[null,2,{"$f":"COMBIN($E$7,B6)","v":10},null,"Total No of Players",null,null,null,2,null,null,"Total No of Players"]
[null,3,10,null,5,null,null,null,3,null,null,5]
[null,4,5,null,null,null,null,null,4]
[null,5,1,null,null,null,null,null,5]

{"sheet":"COUNTA","index":4,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,7,1,10],[1,1,1,4],[6,4,7,4],[6,10,7,10]]}
[]
[null,"COUNTA Nested in COMBIN Function",null,null,null,null,null,"Practice Yourself"]
[]
[null,"ID","Player",null,"No of Combinations",null,null,"ID","Player",null,"No of Combinations"]
[null,1,"Mike",null,{"$f":"COMBIN(COUNTA(C5:C9),2)","v":10},null,null,1,"Mike"]
[null,2,"Adam",null,null,null,null,2,"Adam"]
[null,3,"Stuart",null,null,null,null,3,"Stuart"]
[null,4,"David",null,null,null,null,4,"David"]
[null,5,"Parker",null,null,null,null,5,"Parker"]

{"sheet":"VBA","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA Code"]