{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Combination and Index","Index to Combination Example","Function Information"],"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":"Combination and Index","index":0,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,2,0,7]]}
["Index Value","Index to Combination","Combination Separated",null,null,null,null,null,"Combination to Index"]
[1,{"$f":"Index2Combin(49,6,A2)","v":"01 02 03 04 05 06"},{"$f":"VALUE(MID($B2,3*(CELL(\"col\",C2)-CELL(\"col\",$B2)-1)+1,2))","v":1},2,3,4,5,6,{"$f":"Combin2Index(49,6,C2:H2)","v":1}]
[2,{"$f":"Index2Combin(49,6,A3)","v":"01 02 03 04 05 07"},1,2,3,4,5,7,{"$f":"Combin2Index(49,6,C3:H3)","v":2}]
[3,"01 02 03 04 05 08",1,2,3,4,5,8,3]
[400,"01 02 03 04 15 20",1,2,3,4,15,20,400]
[500,"01 02 03 04 18 24",1,2,3,4,18,24,500,null,null,null,null,{"$f":"Index2Combin(K6,L6,M6)","v":""}]
[600,"01 02 03 04 21 37",1,2,3,4,21,37,600]
[7293487,"06 10 22 33 45 47",6,10,22,33,45,47,7293487]
[{"$f":"COMBIN(49,6)","v":13983816},"44 45 46 47 48 49",44,45,46,47,48,49,13983816]
[{"$f":"RandomLowerUpper(1,COMBIN(49,6))","v":7975767},"07 08 24 38 39 44",7,8,24,38,39,44,{"$f":"Combin2Index(49,6,C10:H10)","v":7975767}]
[{"$f":"RandomLowerUpper(1,COMBIN(49,6))","v":8093333},"07 10 12 23 25 30",7,10,12,23,25,30,8093333]
[4241622,"03 14 15 19 24 42",3,14,15,19,24,42,4241622]
[7701802,"06 18 23 32 43 45",6,18,23,32,43,45,7701802]
[3010463,"02 17 18 22 44 45",2,17,18,22,44,45,3010463]
[1933103,"02 04 10 11 12 21",2,4,10,11,12,21,1933103]
[9320058,"08 19 20 30 32 41",8,19,20,30,32,41,9320058]
[11940609,"13 22 24 25 44 48",13,22,24,25,44,48,11940609]
[3793525,"03 08 11 37 40 46",{"$f":"VALUE(MID($B18,3*(CELL(\"col\",C18)-CELL(\"col\",$B18)-1)+1,2))","v":3},8,11,37,40,46,3793525]
[11080648,"11 20 21 22 23 42",11,20,21,22,23,42,11080648]
[3159829,"02 22 29 31 42 47",2,22,29,31,42,47,3159829]
[7943967,"07 08 16 20 35 49",7,8,16,20,35,49,7943967]
[8032333,"07 09 15 29 30 47",7,9,15,29,30,47,8032333]
[8989527,"08 12 13 22 30 46",8,12,13,22,30,46,8989527]
[12307374,"14 24 40 43 45 49",14,24,40,43,45,49,12307374]
[7403070,"06 12 15 26 27 32",6,12,15,26,27,32,7403070]
[9720456,"09 13 15 27 37 43",9,13,15,27,37,43,9720456]
[794743,"01 07 12 31 41 45",1,7,12,31,41,45,794743]
[5631014,"04 17 28 35 43 47",4,17,28,35,43,47,5631014]
[8896728,"08 10 24 25 26 33",8,10,24,25,26,33,8896728]
[12893370,"17 18 24 27 31 49",17,18,24,27,31,49,12893370]
[2772731,"02 12 17 27 34 39",2,12,17,27,34,39,2772731]
[1150041,"01 11 13 28 36 41",1,11,13,28,36,41,1150041]
[3576126,"03 06 11 19 21 29",3,6,11,19,21,29,3576126]
[403212,"01 04 10 17 33 47",1,4,10,17,33,47,403212]
[12630872,"15 32 33 43 44 47",15,32,33,43,44,47,12630872]
[13398034,"20 21 25 26 36 42",20,21,25,26,36,42,13398034]
[290079,"01 03 15 17 33 34",1,3,15,17,33,34,290079]
[9066427,"08 13 16 22 31 38",8,13,16,22,31,38,9066427]
[980342,"01 09 11 39 43 45",1,9,11,39,43,45,980342]
[9272359,"08 17 24 30 37 41",8,17,24,30,37,41,9272359]
[4173589,"03 12 27 38 41 46",3,12,27,38,41,46,4173589]
[5780380,"04 24 29 35 40 48",4,24,29,35,40,48,5780380]
[11193781,"11 27 32 33 36 47",11,27,32,33,36,47,11193781]
[11605645,"12 24 39 42 44 47",12,24,39,42,44,47,11605645]
[10091654,"09 24 37 39 40 48",9,24,37,39,40,48,10091654]
[9663890,"09 12 16 18 27 46",9,12,16,18,27,46,9663890]
[13882365,"26 38 42 45 46 49",26,38,42,45,46,49,13882365]
[11549079,"12 21 25 30 36 49",12,21,25,30,36,49,11549079]
[9195459,"08 15 24 30 35 46",8,15,24,30,35,46,9195459]
[1598138,"01 21 23 31 33 49",1,21,23,31,33,49,1598138]

{"sheet":"Index to Combination Example","index":1,"n_rows":50,"n_cols":26,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Pool Size -",49]
["Pick Size -",6]
["Total Combinations -",{"$f":"COMB(B1,B2)","v":13983816}]
[null,null,"|---Combination Separated--->",null,null,null,null,"If more cells need to be filled, copy and paste the Z column to the remaining columns."]
["Index","Index to Combination",{"$f":"\"C\"&TEXT(CELL(\"col\",C6)-CELL(\"col\",$B6),\"0\")","v":"C1"},{"$f":"\"C\"&TEXT(CELL(\"col\",D6)-CELL(\"col\",$B6),\"0\")","v":"C2"},"C3","C4","C5","C6","C7","C8","C9","C10","C11","C12","C13","C14","C15","C16","C17","C18","C19","C20","C21","C22","C23","C24"]
[1,{"$f":"Index2Combin(B$1,B$2,A6)","v":"01 02 03 04 05 06"},{"$f":"IF(CELL(\"col\",C6)-CELL(\"col\",$B6)<=$B$2,VALUE(MID($B6,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",C6)-CELL(\"col\",$B6)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":1},2,3,4,5,6,"-","-","-","-",{"$f":"IF(CELL(\"col\",M6)-CELL(\"col\",$B6)<=$B$2,VALUE(MID($B6,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",M6)-CELL(\"col\",$B6)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-"]
[2,"01 02 03 04 05 07",1,2,3,4,5,7,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[3,"01 02 03 04 05 08",1,2,3,4,5,8,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[4,"01 02 03 04 05 09",1,2,3,4,5,9,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[5,"01 02 03 04 05 10",1,2,3,4,5,10,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[6,"01 02 03 04 05 11",1,2,3,4,5,11,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[7,"01 02 03 04 05 12",1,2,3,4,5,12,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[8,"01 02 03 04 05 13",1,2,3,4,5,13,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[9,"01 02 03 04 05 14",1,2,3,4,5,14,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[10,{"$f":"Index2Combin(B$1,B$2,A15)","v":"01 02 03 04 05 15"},{"$f":"IF(CELL(\"col\",C15)-CELL(\"col\",$B15)<=$B$2,VALUE(MID($B15,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",C15)-CELL(\"col\",$B15)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":1},2,3,4,5,15,"-","-","-","-","-","-","-","-","-","-",{"$f":"IF(CELL(\"col\",S15)-CELL(\"col\",$B15)<=$B$2,VALUE(MID($B15,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",S15)-CELL(\"col\",$B15)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":"-"},"-","-","-","-","-","-","-"]
[{"$f":"RandomLowerUpper(1,B$3)","v":3329528},"03 04 13 14 26 42",3,4,13,14,26,42,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[{"$f":"RandomLowerUpper(1,B$3)","v":10523851},"10 18 19 43 45 49",10,18,19,43,45,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[8969194,"08 11 23 28 44 47",8,11,23,28,44,47,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[10971949,"11 16 24 29 38 44",11,16,24,29,38,44,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[12590206,"15 25 28 38 39 42",15,25,28,38,39,42,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[10822583,"11 13 21 22 31 42",11,13,21,22,31,42,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[12868604,"16 32 34 40 45 48",16,32,34,40,45,48,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[8396498,"07 14 23 26 30 41",7,14,23,26,30,41,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[9191026,"08 15 22 33 40 49",8,15,22,33,40,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[13866465,"26 29 36 38 43 44",{"$f":"IF(CELL(\"col\",C25)-CELL(\"col\",$B25)<=$B$2,VALUE(MID($B25,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",C25)-CELL(\"col\",$B25)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":26},29,36,38,43,44,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[2526133,"02 09 13 22 26 30",2,9,13,22,26,30,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[2720598,"02 11 21 22 24 46",2,11,21,22,24,46,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[8536997,"07 18 19 20 38 41",7,18,19,20,38,41,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[4250489,"03 14 16 31 32 45",3,14,16,31,32,45,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[8202032,"07 11 18 24 25 34",7,11,18,24,25,34,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[13063069,"17 30 32 34 35 48",{"$f":"IF(CELL(\"col\",C31)-CELL(\"col\",$B31)<=$B$2,VALUE(MID($B31,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",C31)-CELL(\"col\",$B31)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":17},30,32,34,35,48,"-","-","-","-","-","-","-","-","-",{"$f":"IF(CELL(\"col\",R31)-CELL(\"col\",$B31)<=$B$2,VALUE(MID($B31,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",R31)-CELL(\"col\",$B31)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":"-"},"-","-","-","-","-","-","-","-"]
[1779304,"02 03 09 18 24 49",2,3,9,18,24,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[7649669,"06 16 38 43 45 48",6,16,38,43,45,48,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[10777483,"11 12 26 31 36 43",11,12,26,31,36,43,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[2607466,"02 10 13 19 38 49",2,10,13,19,38,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[1480572,"01 17 19 22 42 44",1,17,19,22,42,44,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[12372807,"15 16 19 28 41 43",15,16,19,28,41,43,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[11673678,"13 14 17 27 28 45",13,14,17,27,28,45,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[4456421,"03 19 22 34 38 39",3,19,22,34,38,39,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[{"$f":"A41-1","v":13983806},"42 44 45 46 48 49",42,44,45,46,48,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[13983807,"42 44 45 47 48 49",42,44,45,47,48,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[13983808,"42 44 46 47 48 49",42,44,46,47,48,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[13983809,"42 45 46 47 48 49",42,45,46,47,48,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[13983810,"43 44 45 46 47 48",43,44,45,46,47,48,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[13983811,"43 44 45 46 47 49",43,44,45,46,47,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[13983812,"43 44 45 46 48 49",43,44,45,46,48,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(CELL(\"col\",Z46)-CELL(\"col\",$B46)<=$B$2,VALUE(MID($B46,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",Z46)-CELL(\"col\",$B46)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":"-"}]
[13983813,"43 44 45 47 48 49",43,44,45,47,48,49,"-","-","-","-","-","-","-","-","-","-",{"$f":"IF(CELL(\"col\",S47)-CELL(\"col\",$B47)<=$B$2,VALUE(MID($B47,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",S47)-CELL(\"col\",$B47)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":"-"},"-","-","-","-","-","-",{"$f":"IF(CELL(\"col\",Z47)-CELL(\"col\",$B47)<=$B$2,VALUE(MID($B47,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",Z47)-CELL(\"col\",$B47)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":"-"}]
[13983814,"43 44 46 47 48 49",{"$f":"IF(CELL(\"col\",C48)-CELL(\"col\",$B48)<=$B$2,VALUE(MID($B48,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",C48)-CELL(\"col\",$B48)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":43},44,46,47,48,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(CELL(\"col\",Z48)-CELL(\"col\",$B48)<=$B$2,VALUE(MID($B48,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",Z48)-CELL(\"col\",$B48)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":"-"}]
[{"$f":"A50-1","v":13983815},"43 45 46 47 48 49",43,45,46,47,48,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(CELL(\"col\",Z49)-CELL(\"col\",$B49)<=$B$2,VALUE(MID($B49,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",Z49)-CELL(\"col\",$B49)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":"-"}]
[{"$f":"B3","v":13983816},"44 45 46 47 48 49",44,45,46,47,48,49,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(CELL(\"col\",Z50)-CELL(\"col\",$B50)<=$B$2,VALUE(MID($B50,(1+LEN(TEXT($B$1,\"0\")))*(CELL(\"col\",Z50)-CELL(\"col\",$B50)-1)+1,LEN(TEXT($B$1,\"0\")))),\"-\")","v":"-"}]

{"sheet":"Function Information","index":2,"n_rows":72,"n_cols":8,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["Function Information","Function Example"]
[]
["Note - integer refers to a mathematical integer {…, -3, -2, -1, 0, 1, 2, 3, …}"]
[]
["=RandomLowerUpper(L, U)",{"$f":"RandomLowerUpper(-10, 10)","v":-4},{"$f":"RandomLowerUpper(-10, 10)","v":-2},{"$f":"RandomLowerUpper(-10, 10)","v":8},{"$f":"RandomLowerUpper(-10, 10)","v":-6},{"$f":"RandomLowerUpper(-10, 10)","v":-8}]
[" Returns -"]
[" - An integer"]
[" - A randomly selected integer in a set of integers ranging from L to U"]
[]
["=Fact(N)",{"$f":"FACT(1)","v":1},{"$f":"FACT(2)","v":2},{"$f":"FACT(3)","v":6},{"$f":"FACT(4)","v":24},{"$f":"FACT(5)","v":120}]
[" Returns -"]
[" - An integer"]
[" - The factorial of N, mathematically written as ' N! '"]
[" - N!"]
[" - N · (N - 1) · (N - 2) · … · 3 · 2 · 1"]
[" - 0! = 1"]
[]
["=Perm(N, R)",{"$f":"Perm(49, 1)","v":49},{"$f":"Perm(49, 2)","v":2352},{"$f":"Perm(49, 3)","v":110544},{"$f":"Perm(49, 4)","v":5085024},{"$f":"Perm(49, 5)","v":228826080}]
[" Returns -"]
[" - An integer"]
[" - Using the Fact(N) function"]
[" - The number of permutations in a pool of N numbers taken R at a time"]
[" - (N! / (N - R)!)"]
[]
["=Comb(N, R)",{"$f":"COMB(49, 1)","v":49},{"$f":"COMB(49, 2)","v":1176},{"$f":"COMB(49, 3)","v":18424},{"$f":"COMB(49, 4)","v":211876},{"$f":"COMB(49, 5)","v":1906884}]
[" Returns -"]
[" - An integer"]
[" - Using the Perm(N, R) and Fact(N) functions"]
[" - The number of combinations in a pool of N numbers taken R at a time"]
[" - (Perm(N, R) / Fact(R))"]
[" - (Perm(N, R) / R!)"]
[" - ((N! / (N - R)!) / R!)"]
[" - (N! / (R! · (N - R)!))"]
[]
["=Cdist(N, R, C, Z)",{"$f":"Cdist(49, 6, 1, 1)","v":1712304},{"$f":"Cdist(49, 6, 1, 2)","v":1533939},{"$f":"Cdist(49, 6, 1, 3)","v":1370754},{"$f":"Cdist(49, 6, 1, 4)","v":1221759},{"$f":"Cdist(49, 6, 1, 5)","v":1086008}]
[" Returns -"]
[" - An integer"]
[" - Using the Comb(N, R) function"]
[" - The occurrence count of a number Z in a column C within a pool of N numbers taken R at a time"]
[" - Comb((Z - 1), (C - 1)) · Comb((N - Z), (R - C))"]
[" - (((Z - 1)! / ((C - 1)! · (Z - 1 - (C - 1))!) · ((N - Z)! / ((R - C)! · (N - Z - (R - C))!)))"]
[" - ((Z - 1)! · (N - Z)!) / ((C - 1)! · (Z - C)! · (R - C)! · (N - Z - R +C)!)"]
[]
["=fColumnSum(N, R, Z)",{"$f":"fColumnSum(49, 6, 1)","v":1712304},{"$f":"fColumnSum(49, 6, 2)","v":3246243},{"$f":"fColumnSum(49, 6, 3)","v":4616997},{"$f":"fColumnSum(49, 6, 4)","v":5838756},{"$f":"fColumnSum(49, 6, 5)","v":6924764}]
[" Returns -"]
[" - An integer"]
[" - Using the Cdist(N, R, C, Z) and Comb(N, R) functions"]
[" - The sum of occurrence counts in the first column, 1, from the first number 1 to a number Z"]
[]
["=Index2Combin(N, R, Index)",{"$f":"Index2Combin(49, 6, RandomLowerUpper(1, COMB(49, 6)))","v":"02 11 27 34 41 44"}]
[" Returns -"]
[" - A string"]
[" - Using the fColumnSum(N, R, Z) and Comb(N, R) functions"]
[" - A Combination based on an Index in a pool of N numbers taken R at a time"]
[" - 00's for an error condition"]
[null,null,"|--Range-->",null,null,null,null,"<---|"]
["=Combin2Index(N, R, Range)",{"$f":"Combin2Index(49, 6, C57:H57)","v":15180},1,2,3,47,48,49]
[" Returns -"]
[" - An integer"]
[" - Using the fColumnSum(N, R, Z) function"]
[" - An Index value from a Combination within a pool of N numbers taken R at a time"]
[" - A -1 for an error condition"]
[]
["Variables and Array"]
["L - Least integer value in a set of intergers, all integer values"]
["U - Greatest integer value in a set of integers, all integer values"]
["N - Pool Size, positive integer"]
["R - Pick Size, positive integer"]
["C - Column, positive integer"]
["Z - Number, positive integer"]
["Index - A positive integer index value within a combination of N numbers taken R at a time"]
["Range - An array of positive integer values in ascending order left to right; in a single row containing a combination of N numbers taken R at a time"]