{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["المرفق رقم 1","الدالة (RANDBETWEEN)","ورقة2"],"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":"المرفق رقم 1","index":0,"n_rows":23,"n_cols":43,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,29,0,42]]}
[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,null,null,null,1,10]
["م","A1","A2","A3","A4","A5","A6","A7","A8","A9","A10","A11","A12","A13","A14","A15","A16","A17","A18","A19","A20",null,"م","A1","A2","A3","A4","A5","A6","A7","A8","A9","A10","A11","A12","A13","A14","A15","A16","A17","A18","A19","A20"]
[1,2,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,null,1,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A1)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B1)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C1)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D1)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E1)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F1)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G1)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H1)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I1)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J1)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K1)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L1)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M1)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N1)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O1)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P1)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q1)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R1)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S1)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ3, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T1)))","v":6}]
[2,4,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,null,2,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A2)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B2)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C2)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D2)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E2)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F2)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G2)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H2)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I2)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J2)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K2)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L2)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M2)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N2)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O2)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P2)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q2)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R2)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S2)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ4, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T2)))","v":12}]
[3,9,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,null,3,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A3)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B3)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C3)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D3)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E3)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F3)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G3)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H3)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I3)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J3)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K3)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L3)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M3)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N3)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O3)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P3)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q3)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R3)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S3)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ5, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T3)))","v":2}]
[4,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,null,4,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A4)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B4)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C4)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D4)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E4)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F4)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G4)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H4)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I4)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J4)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K4)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L4)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M4)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N4)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O4)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P4)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q4)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R4)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S4)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ6, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T4)))","v":10}]
[5,8,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,null,5,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A5)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B5)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C5)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D5)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E5)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F5)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G5)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H5)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I5)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J5)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K5)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L5)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M5)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N5)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O5)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P5)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q5)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R5)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S5)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ7, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T5)))","v":11}]
[6,5,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,null,6,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A6)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B6)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C6)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D6)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E6)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F6)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G6)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H6)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I6)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J6)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K6)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L6)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M6)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N6)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O6)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P6)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q6)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R6)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S6)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ8, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T6)))","v":15}]
[7,10,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,7,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A7)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B7)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C7)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D7)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E7)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F7)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G7)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H7)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I7)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J7)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K7)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L7)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M7)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N7)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O7)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P7)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q7)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R7)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S7)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ9, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T7)))","v":4}]
[8,6,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,null,8,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A8)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B8)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C8)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D8)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E8)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F8)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G8)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H8)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I8)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J8)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K8)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L8)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M8)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N8)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O8)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P8)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q8)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R8)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S8)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ10, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T8)))","v":14}]
[9,3,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,null,9,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A9)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B9)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C9)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D9)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E9)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F9)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G9)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H9)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I9)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J9)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K9)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L9)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M9)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N9)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O9)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P9)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q9)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R9)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S9)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ11, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T9)))","v":3}]
[10,1,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,null,10,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A10)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B10)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C10)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D10)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E10)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F10)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G10)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H10)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I10)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J10)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K10)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L10)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M10)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N10)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O10)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P10)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q10)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R10)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S10)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ12, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T10)))","v":5}]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A11)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B11)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C11)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D11)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E11)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F11)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G11)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H11)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I11)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J11)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K11)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L11)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M11)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N11)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O11)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P11)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q11)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R11)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S11)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ13, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T11)))","v":9}]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A12)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B12)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C12)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D12)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E12)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F12)))","v":6},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G12)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H12)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I12)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J12)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K12)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L12)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M12)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N12)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O12)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P12)))","v":5},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q12)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R12)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S12)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ14, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T12)))","v":8}]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A13)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B13)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C13)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D13)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E13)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F13)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G13)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H13)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I13)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J13)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K13)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L13)))","v":10},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M13)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N13)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O13)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P13)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q13)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R13)))","v":11},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S13)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ15, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T13)))","v":13}]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($X$3:X16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(A14)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Y$3:Y16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(B14)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($Z$3:Z16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(C14)))","v":2},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AA$3:AA16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(D14)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AB$3:AB16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(E14)))","v":15},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AC$3:AC16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(F14)))","v":9},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AD$3:AD16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(G14)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AE$3:AE16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(H14)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AF$3:AF16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(I14)))","v":12},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AG$3:AG16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(J14)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AH$3:AH16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(K14)))","v":14},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AI$3:AI16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(L14)))","v":8},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AJ$3:AJ16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(M14)))","v":4},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AK$3:AK16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(N14)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AL$3:AL16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(O14)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AM$3:AM16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(P14)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AN$3:AN16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(Q14)))","v":3},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AO$3:AO16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(R14)))","v":7},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AP$3:AP16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(S14)))","v":13},{"$f":"LARGE(ROW($1:$15)*NOT(COUNTIF($AQ$3:AQ16, ROW($1:$15))), RANDBETWEEN(1,15-ROW(T14)))","v":7}]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[]
[1]
[2]
[3]
["S"]

{"sheet":"الدالة (RANDBETWEEN)","index":1,"n_rows":38,"n_cols":24,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,10,0,23],[33,0,33,20],[26,0,26,20],[19,0,19,20],[19,23,30,27],[2,23,2,27],[4,23,7,27],[9,23,13,27],[15,23,16,27]]}
[null,null,null,null,null,null,null,null,null,null,"للأسف تطبيق الدالة (RANDBETWEEN) لا تفي بالغرض"]
[]
["م","A1","A2","A3","A4","A5","A6","A7","A8","A9","A10","A11","A12","A13","A14","A15","A16","A17","A18","A19","A20",null,null,"هل هناك دالة تقوم بعمل توزيع عشوائى لقيم محددة"]
[1,{"$f":"RANDBETWEEN(1,3)","v":1},{"$f":"RANDBETWEEN(1,3)","v":2},2,2,1,3,2,3,1,1,3,1,3,2,3,3,3,3,2,2]
[2,{"$f":"RANDBETWEEN(1,3)","v":2},1,2,3,2,1,2,2,1,3,1,1,3,1,3,3,1,2,3,3,null,null,"أريد دالة تقوم بإعادة ترتيب الأعمدة السابقة من عمود (B) إلي العمود (U) بشكل عشوائي بحيث يظل كل عمود به نفس القيم مع عرضها بشكل عشوائي وليس مرتب"]
[3,2,2,3,1,3,3,3,1,2,3,2,2,2,1,3,2,3,2,1,1]
[4,2,3,3,3,1,2,3,1,3,2,2,2,3,1,1,2,1,3,2,1]
[5,3,2,1,1,2,3,1,3,1,1,1,1,3,2,3,3,2,3,1,3]
[6,1,1,3,3,1,1,2,2,2,3,3,3,3,3,2,1,1,3,3,2]
[7,1,3,2,2,1,1,1,3,1,3,2,1,2,2,2,3,1,1,3,1,null,null,"وإذا لم يصلح لذلك إلا كود برمجي فبرجاء توضيح كيفية تحديد نطاق البيانات في الكود وكذلك إذا كان هناك مدخلات أخري (1-2-3-4-5 ..إلخ) وليس الإقتصار علي ثلاثة أرقام فقط (1-2-3) حيث أنني أتعامل مع جداول أكبر وبيانات أخري أكثر مما هو محدد في المثال"]
[8,3,3,3,2,2,3,1,3,2,2,3,1,3,1,2,2,2,3,2,1]
[9,2,3,3,2,3,3,1,1,2,3,1,3,2,2,3,1,2,2,2,2]
[10,3,2,3,3,2,3,2,1,1,2,3,1,2,1,2,3,2,1,3,1]
[11,2,1,2,3,1,3,3,2,3,3,1,2,1,3,2,1,3,3,1,1]
[12,3,3,2,3,2,1,1,1,1,2,3,3,2,2,1,3,1,2,3,1]
[13,2,2,1,3,3,2,2,1,2,3,2,2,3,2,1,2,1,2,1,1,null,null,"وجزاكم الله خيراً"]
[14,3,1,1,1,3,2,3,1,2,{"$f":"RANDBETWEEN(1,3)","v":3},2,3,2,2,1,1,3,3,3,1]
[15,2,1,2,2,1,3,3,1,2,1,1,3,3,2,2,2,1,2,3,1]
[]
["الدالة COUNTIF لحساب عدد تكرارات كل رقم بكل عمود",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"تم هنا استخدام الدالة COUNTIF لحساب تكرار كل رقم في كل عمود علي حدة\n فمثلاً في جدول لصق القيم العمود (B) يشتمل علي عدد (5) تكرارت للرقم (1) -- و (5) تكرارات للرقم (2) -- و (5) تكرارات للرقم (3) ،،،، والعمود (C) يشتمل علي عدد (2) تكرارت للرقم (1) -- و (2) تكرارات للرقم (2) -- و (11) تكرار للرقم (3)  ....... وهكذا وعند إستخدام \nالدالة (RANDBETWEEN)\n  يتغير عدد تكرار الأرقام المحددة في كل عمود وأنا أريد أن يظل التكرار لكل رقم ثابت والمطلوب فقط هو إعادة توزيع تلك الأرقام في كل عمود بشكل عشوائي وليس مرتب كما هو كائن في المرفق الأول وأن تظل التكرارات ثابتة لكل رقم."]
[1,{"$f":"COUNTIF(B$4:B$18,$A21)","v":3},5,3,3,6,4,5,8,6,3,{"$f":"COUNTIF(L$4:L$18,$A21)","v":5},6,1,5,4,4,7,2,4,10]
[2,7,5,6,5,5,3,5,3,7,4,5,4,6,8,6,5,4,6,4,3]
[3,5,5,{"$f":"COUNTIF(D$4:D$18,$A23)","v":6},7,4,8,5,4,2,8,5,5,8,2,5,6,4,7,7,2]
["S",{"$f":"SUM(B21:B23)","v":15},15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15]
[]
[]
["لصق قيم للدالة COUNTIF"]
[1,5,2,3,12,9,4,2,5,2,3,11,3,13,0,1,2,11,1,11,3]
[2,5,2,2,1,3,1,6,4,2,4,2,6,1,3,3,1,2,6,2,4]
[3,5,11,10,2,3,10,7,6,11,8,2,6,1,12,11,12,2,8,2,8]
["S",15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15]
[]
[]
["مقارنة بين عدد تكرارت كل رقم بكل عمود بين المثال الذي أرسلته بالمرفق الأول وبعد تطبيق الدالة (RANDBETWEEN)"]
[1,{"$f":"B21=B28","v":false},false,true,false,false,true,false,false,false,true,false,false,false,false,false,false,false,false,false,false]
[2,{"$f":"B22=B29","v":false},false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,true,false,false]
[3,{"$f":"B23=B30","v":true},false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,false,false,false]
["S",{"$f":"B24=B31","v":true},true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true]

{"sheet":"ورقة2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}