{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Исходные данные","Результат после макроса","Power Query"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Исходные данные","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Имя","Билетов","Номер билета"]
["Яна",1,{"$f":"RANDBETWEEN(100000,999999)","v":355252}]
["Диана",1,{"$f":"RANDBETWEEN(100000,999999)","v":678812}]
["Анастасия",1,129722]
["Михаил",4,209203]
["Артём",1,338885]
["Таисия",1,982560]
["Ольга",2,320780]
["Ксения",1,685495]
["Евгений",1,379362]

{"sheet":"Результат после макроса","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Имя","Билетов","Номер билета"]
["Яна",1,{"$f":"RANDBETWEEN(100000,999999)","v":531901}]
["Диана",1,{"$f":"RANDBETWEEN(100000,999999)","v":283367}]
["Анастасия",1,436024]
["Михаил",4,487478]
["Михаил",4,642429]
["Михаил",4,363026]
["Михаил",4,439435]
["Артём",1,598199]
["Таисия",1,297846]
["Ольга",2,739379]
["Ольга",2,885312]
["Ксения",1,372144]
["Евгений",1,825611]

{"sheet":"Power Query","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Имя","Билетов",null,null,"Имя","Билетов","Номер"]
["Яна",1,null,null,"Яна",1,{"$f":"RANDBETWEEN(100000,999999)","v":538461}]
["Диана",1,null,null,"Диана",1,670441]
["Анастасия",1,null,null,"Анастасия",1,137922]
["Михаил",4,null,null,"Михаил",4,510080]
["Артём",1,null,null,"Михаил",4,435229]
["Таисия",1,null,null,"Михаил",4,831096]
["Ольга",2,null,null,"Михаил",4,478943]
["Ксения",1,null,null,"Артём",1,449087]
["Евгений",1,null,null,"Таисия",1,657778]
[null,null,null,null,"Ольга",2,433955]
[null,null,null,null,"Ольга",2,308702]
[null,null,null,null,"Ксения",1,734799]
[null,null,null,null,"Евгений",1,393248]