{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset Overview","Permutations Fomula","Using PERMUT Function","Combination of COUNTA and PERMU","Using Combined Excel Functi (2)","Using Combined Excel Functions","Formulas","VBA (2)","VBA","Sheet5"],"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":"Dataset Overview","index":0,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Dataset Overview",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Total Numbers","Chosen Numbers","All Permutations",null,null,null,null,null,null,"Total Numbers","Chosen Numbers","All Permutations"]
[null,20,2,null,null,null,null,null,null,null,10,1]
[null,20,4,null,null,null,null,null,null,null,10,2]
[null,20,6,null,null,null,null,null,null,null,10,3]
[null,20,8,null,null,null,null,null,null,null,10,4]
[null,20,10]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROW()>2^(COUNTA($B$5:$B$8)),\"\",_xlfn.TEXTJOIN(\" , \",TRUE,IF(MID(TEXT(DEC2BIN(ROW()-1),REPT(\"0\",COUNTA($B$5:$B$8))),ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8))),1)+0,TRIM(MID($C$6,(ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8)))-1)*$C$5+1,$C$5)),\"\")))","v":"4"}]

{"sheet":"Permutations Fomula","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Using PERMUTATIONA Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Total Numbers","Chosen Numbers","All Permutations",null,null,null,null,null,null,"Total Numbers","Chosen Numbers","All Permutations"]
[null,20,2,{"$f":"_xlfn.PERMUTATIONA(B5,C5)","v":400},null,null,null,null,null,null,10,1]
[null,20,4,{"$f":"_xlfn.PERMUTATIONA(B6,C6)","v":160000},null,null,null,null,null,null,10,2]
[null,20,6,64000000,null,null,null,null,null,null,10,3]
[null,20,8,25600000000,null,null,null,null,null,null,10,4]
[null,20,10,{"$f":"_xlfn.PERMUTATIONA(B9,C9)","v":10240000000000}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROW()>2^(COUNTA($B$5:$B$8)),\"\",_xlfn.TEXTJOIN(\" , \",TRUE,IF(MID(TEXT(DEC2BIN(ROW()-1),REPT(\"0\",COUNTA($B$5:$B$8))),ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8))),1)+0,TRIM(MID($C$6,(ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8)))-1)*$C$5+1,$C$5)),\"\")))","v":"4"}]

{"sheet":"Using PERMUT Function","index":2,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of PERMUT Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Total Numbers","Chosen Numbers","All Permutations",null,null,null,null,null,null,"Total Numbers","Chosen Numbers","All Permutations"]
[null,20,2,{"$f":"PERMUT(B5,C5)","v":380},null,null,null,null,null,null,10,1]
[null,20,4,{"$f":"PERMUT(B6,C6)","v":116280},null,null,null,null,null,null,10,2]
[null,20,6,27907200,null,null,null,null,null,null,10,3]
[null,20,8,5079110400,null,null,null,null,null,null,10,4]
[null,20,10,670442572800]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROW()>2^(COUNTA($B$5:$B$8)),\"\",_xlfn.TEXTJOIN(\" , \",TRUE,IF(MID(TEXT(DEC2BIN(ROW()-1),REPT(\"0\",COUNTA($B$5:$B$8))),ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8))),1)+0,TRIM(MID($C$6,(ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8)))-1)*$C$5+1,$C$5)),\"\")))","v":"4"}]

{"sheet":"Combination of COUNTA and PERMU","index":3,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Calculating Unique Permutation Numbers",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Symbol of Cards","Helper Column","Possible Permutations",null,null,null,null,null,"Total Numbers","Chosen Numbers","All Permutations"]
[null,"Club",1,{"$f":"PERMUT(COUNTA($B$5:$B$8),C5)","v":4},null,null,null,null,null,10,1]
[null,"Diamond",2,{"$f":"PERMUT(COUNTA($B$5:$B$8),C6)","v":12},null,null,null,null,null,10,2]
[null,"Heart",3,24,null,null,null,null,null,10,3]
[null,"Spade",4,24,null,null,null,null,null,10,4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROW()>2^(COUNTA($B$5:$B$8)),\"\",_xlfn.TEXTJOIN(\" , \",TRUE,IF(MID(TEXT(DEC2BIN(ROW()-1),REPT(\"0\",COUNTA($B$5:$B$8))),ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8))),1)+0,TRIM(MID($C$6,(ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8)))-1)*$C$5+1,$C$5)),\"\")))","v":"2"}]

{"sheet":"Using Combined Excel Functi (2)","index":4,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,13]]}
[]
[null,"Using Combined Functions to Determine Permutation Table",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"List 1","List 2","List 3","All Permutations",null,null,null,null,null,null,"Total Numbers","Chosen Numbers","All Permutations"]
[null,"C","x",5,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B5)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B5)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B5)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - x - 5"},null,null,null,null,null,null,10,1]
[null,"D","y",6,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B6)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B6)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B6)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - x - 6"},null,null,null,null,null,null,10,2]
[null,null,"z",7,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B7)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B7)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B7)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - x - 7"},null,null,null,null,null,null,10,3]
[null,null,null,8,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B8)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B8)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B8)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - x - 8"},null,null,null,null,null,null,10,4]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B9)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B9)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B9)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - y - 5"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B10)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B10)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B10)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - y - 6"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B11)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B11)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B11)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - y - 7"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROW()>2^(COUNTA($B$5:$B$8)),\"\",_xlfn.TEXTJOIN(\" , \",TRUE,IF(MID(TEXT(DEC2BIN(ROW()-1),REPT(\"0\",COUNTA($B$5:$B$8))),ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8))),1)+0,TRIM(MID($C$6,(ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8)))-1)*$C$5+1,$C$5)),\"\")))","v":""}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B12)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B12)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B12)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - y - 8"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B13)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B13)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B13)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - z - 5"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B14)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B14)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B14)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - z - 6"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B15)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B15)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B15)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - z - 7"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B16)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B16)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B16)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - z - 8"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B17)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B17)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B17)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - x - 5"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B18)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B18)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B18)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - x - 6"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B19)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B19)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B19)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - x - 7"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B20)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B20)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B20)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - x - 8"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B21)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B21)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B21)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - y - 5"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B22)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B22)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B22)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - y - 6"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B23)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B23)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B23)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - y - 7"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B24)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B24)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B24)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - y - 8"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B25)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B25)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B25)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - z - 5"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B26)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B26)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B26)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - z - 6"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B27)-5)/((COUNTA($C$5:$C$7)*\n(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B27)-5)\n/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,\nMOD((ROW(B27)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - z - 7"}]

{"sheet":"Using Combined Excel Functions","index":5,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,13]]}
[]
[null,"Using Combined Excel Functions to Determine Permutation Table",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"List 1","List 2","List 3","All Permutations",null,null,null,null,null,null,"Total Numbers","Chosen Numbers","All Permutations"]
[null,"C","x",5,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B5)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B5)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B5)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - x - 5"},null,null,null,null,null,null,10,1]
[null,"D","y",6,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B6)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B6)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B6)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - x - 6"},null,null,null,null,null,null,10,2]
[null,null,"z",7,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B7)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B7)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B7)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - x - 7"},null,null,null,null,null,null,10,3]
[null,null,null,8,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B8)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B8)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B8)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - x - 8"},null,null,null,null,null,null,10,4]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B9)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B9)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B9)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - y - 5"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B10)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B10)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B10)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - y - 6"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B11)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B11)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B11)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - y - 7"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROW()>2^(COUNTA($B$5:$B$8)),\"\",_xlfn.TEXTJOIN(\" , \",TRUE,IF(MID(TEXT(DEC2BIN(ROW()-1),REPT(\"0\",COUNTA($B$5:$B$8))),ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8))),1)+0,TRIM(MID($C$6,(ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8)))-1)*$C$5+1,$C$5)),\"\")))","v":""}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B12)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B12)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B12)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - y - 8"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B13)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B13)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B13)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - z - 5"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B14)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B14)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B14)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - z - 6"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B15)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B15)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B15)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - z - 7"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B16)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B16)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B16)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"C - z - 8"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B17)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B17)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B17)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - x - 5"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B18)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B18)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B18)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - x - 6"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B19)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B19)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B19)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - x - 7"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B20)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B20)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B20)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - x - 8"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B21)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B21)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B21)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - y - 5"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B22)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B22)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B22)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - y - 6"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B23)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B23)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B23)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - y - 7"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B24)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B24)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B24)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - y - 8"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B25)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B25)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B25)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - z - 5"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B26)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B26)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B26)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - z - 6"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B27)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B27)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B27)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - z - 7"}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8,INT((ROW(B28)-5)/((COUNTA($C$5:$C$7)*(COUNTA($D$5:$D$8)))))+1)&\" - \"&INDEX($C$5:$C$7,MOD(INT((ROW(B28)-5)/COUNTA($D$5:$D$8)),COUNTA($C$5:$C$7))+1)&\" - \"&INDEX($D$5:$D$8,MOD((ROW(B28)-5),COUNTA($D$5:$D$8))+1),\"\")","v":"D - z - 8"}]

{"sheet":"Formulas","index":6,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using Combined Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Symbol of Cards","Helper Column","All Combinations",null,null,null,"Symbol of Cards","Helper Column","All Combinations"]
[null,"Club",{"$f":"MAX(LEN(B5:B8))","v":7},{"$f":"IF(ROW()>2^(COUNTA($B$5:$B$8)),\"\",_xlfn.TEXTJOIN(\" , \",TRUE,IF(MID(TEXT(DEC2BIN(ROW()-1),REPT(\"0\",COUNTA($B$5:$B$8))),ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8))),1)+0,TRIM(MID($C$6,(ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8)))-1)*$C$5+1,$C$5)),\"\")))","v":"Diamond"},null,null,null,"Club"]
[null,"Diamond",{"$f":"_xlfn.CONCAT(B5:B8&REPT(\" \",C5-LEN(B5:B8)))","v":"Club   DiamondHeart  Spade  "},{"$f":"IF(ROW()>2^(COUNTA($B$5:$B$8)),\"\",_xlfn.TEXTJOIN(\" , \",TRUE,IF(MID(TEXT(DEC2BIN(ROW()-1),REPT(\"0\",COUNTA($B$5:$B$8))),ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8))),1)+0,TRIM(MID($C$6,(ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8)))-1)*$C$5+1,$C$5)),\"\")))","v":"Diamond , Spade"},null,null,null,"Diamond"]
[null,"Heart",null,{"$f":"IF(ROW()>2^(COUNTA($B$5:$B$8)),\"\",_xlfn.TEXTJOIN(\" , \",TRUE,IF(MID(TEXT(DEC2BIN(ROW()-1),REPT(\"0\",COUNTA($B$5:$B$8))),ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8))),1)+0,TRIM(MID($C$6,(ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8)))-1)*$C$5+1,$C$5)),\"\")))","v":"Diamond , Heart"},null,null,null,"Heart"]
[null,"Spade",null,{"$f":"IF(ROW()>2^(COUNTA($B$5:$B$8)),\"\",_xlfn.TEXTJOIN(\" , \",TRUE,IF(MID(TEXT(DEC2BIN(ROW()-1),REPT(\"0\",COUNTA($B$5:$B$8))),ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8))),1)+0,TRIM(MID($C$6,(ROW(INDIRECT(\"1:\"&COUNTA($B$5:$B$8)))-1)*$C$5+1,$C$5)),\"\")))","v":"Diamond , Heart , Spade"},null,null,null,"Spade"]

{"sheet":"VBA (2)","index":7,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Application of VBA",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Symbol of Cards","Combination 1","Combination 2","Combination 3","Combination 4",null,null,null,"Symbol of Cards"]
[null,"Club","Club","Club,Diamond","Club,Diamond,Heart","Club,Diamond,Heart,Spade",null,null,null,"Club"]
[null,"Diamond","Diamond","Club,Heart","Club,Diamond,Spade",null,null,null,null,"Diamond"]
[null,"Heart","Heart","Club,Spade","Club,Heart,Spade",null,null,null,null,"Heart"]
[null,"Spade","Spade","Diamond,Heart","Diamond,Heart,Spade",null,null,null,null,"Spade"]
[null,null,null,"Diamond,Spade"]
[null,null,null,"Heart,Spade"]

{"sheet":"VBA","index":8,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Application of VBA",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Symbol of Cards","Combination 1","Combination 2","Combination 3","Combination 4",null,null,null,"Symbol of Cards"]
[null,"Club","Club","Club,Diamond","Club,Diamond,Heart","Club,Diamond,Heart,Spade",null,null,null,"Club"]
[null,"Diamond","Diamond","Club,Heart","Club,Diamond,Spade",null,null,null,null,"Diamond"]
[null,"Heart","Heart","Club,Spade","Club,Heart,Spade",null,null,null,null,"Heart"]
[null,"Spade","Spade","Diamond,Heart","Diamond,Heart,Spade",null,null,null,null,"Spade"]
[null,null,null,"Diamond,Spade"]
[null,null,null,"Heart,Spade"]

{"sheet":"Sheet5","index":9,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["A","a",1,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(1:1)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(1:1)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(1:1)-1),COUNTA(C:C))+1),\"\")","v":"A - a - 1"}]
["B","b",2,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(2:2)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(2:2)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(2:2)-1),COUNTA(C:C))+1),\"\")","v":"A - a - 2"}]
[null,"c",3,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(3:3)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(3:3)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(3:3)-1),COUNTA(C:C))+1),\"\")","v":"A - a - 3"}]
[null,null,4,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(4:4)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(4:4)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(4:4)-1),COUNTA(C:C))+1),\"\")","v":"A - a - 4"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(5:5)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(5:5)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(5:5)-1),COUNTA(C:C))+1),\"\")","v":"A - b - 1"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(6:6)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(6:6)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(6:6)-1),COUNTA(C:C))+1),\"\")","v":"A - b - 2"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(7:7)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(7:7)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(7:7)-1),COUNTA(C:C))+1),\"\")","v":"A - b - 3"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(8:8)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(8:8)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(8:8)-1),COUNTA(C:C))+1),\"\")","v":"A - b - 4"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(9:9)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(9:9)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(9:9)-1),COUNTA(C:C))+1),\"\")","v":"A - c - 1"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(10:10)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(10:10)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(10:10)-1),COUNTA(C:C))+1),\"\")","v":"A - c - 2"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(11:11)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(11:11)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(11:11)-1),COUNTA(C:C))+1),\"\")","v":"A - c - 3"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(12:12)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(12:12)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(12:12)-1),COUNTA(C:C))+1),\"\")","v":"A - c - 4"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(13:13)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(13:13)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(13:13)-1),COUNTA(C:C))+1),\"\")","v":"B - a - 1"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(14:14)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(14:14)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(14:14)-1),COUNTA(C:C))+1),\"\")","v":"B - a - 2"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(15:15)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(15:15)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(15:15)-1),COUNTA(C:C))+1),\"\")","v":"B - a - 3"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(16:16)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(16:16)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(16:16)-1),COUNTA(C:C))+1),\"\")","v":"B - a - 4"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(17:17)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(17:17)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(17:17)-1),COUNTA(C:C))+1),\"\")","v":"B - b - 1"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(18:18)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(18:18)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(18:18)-1),COUNTA(C:C))+1),\"\")","v":"B - b - 2"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(19:19)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(19:19)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(19:19)-1),COUNTA(C:C))+1),\"\")","v":"B - b - 3"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(20:20)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(20:20)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(20:20)-1),COUNTA(C:C))+1),\"\")","v":"B - b - 4"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(21:21)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(21:21)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(21:21)-1),COUNTA(C:C))+1),\"\")","v":"B - c - 1"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(22:22)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(22:22)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(22:22)-1),COUNTA(C:C))+1),\"\")","v":"B - c - 2"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(23:23)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(23:23)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(23:23)-1),COUNTA(C:C))+1),\"\")","v":"B - c - 3"}]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(24:24)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(24:24)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(24:24)-1),COUNTA(C:C))+1),\"\")","v":"B - c - 4"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IFERROR(INDEX($A$1:$A$4,INT((ROW(49:49)-1)/((COUNTA(B:B)*(COUNTA(C:C)))))+1)&\" - \"&INDEX(B:B,MOD(INT((ROW(49:49)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&\" - \"&INDEX(C:C,MOD((ROW(49:49)-1),COUNTA(C:C))+1),\"\")","v":""}]