dataset = { // all/male/female runners sorted on net time(+loss time) let arr = await (FileAttachment("TM2021-FULL.arr.json").json()); arr = arr.map(([ bib, name, sex, age, ageGroup, category, region, residence, half, time_net, time_gross, overallPlace, genderPlace, agePlace, categoryPlace, regionPlace, 都道府県別順位, jname, jsex, jcategory, jyusho]) => [ bib, sex, age, ageGroup, category, region, residence, jyusho, half, time_net, time_gross, convert.to_second(half), // 11 = seconds of half time convert.to_second(time_net), // 12 = seconds of net time convert.to_second(time_gross), // 13 = seconds of gross time convert.to_second(time_gross) - convert.to_second(time_net), // 14 = seconds of start loss ]).sort((a, b) => { let t = a[12] - b[12]; return t !== 0 ? t : a[14] - b[14]; }); let M = arr.filter(d => d[1] === 'Men'); let F = arr.filter(d => d[1] !== 'Men'); return { ALL: arr, M, F, AGE: { M: { YOUNG : M.filter(d => d[2] < 30), G30 : M.filter(d => d[2] >= 30 && d[2] < 40), G40 : M.filter(d => d[2] >= 40 && d[2] < 50), G50 : M.filter(d => d[2] >= 50 && d[2] < 60), G60 : M.filter(d => d[2] >= 60 && d[2] < 70), SENIOR : M.filter(d => d[2] >= 70), }, F: { YOUNG : F.filter(d => d[2] < 30), G30 : F.filter(d => d[2] >= 30 && d[2] < 40), G40 : F.filter(d => d[2] >= 40 && d[2] < 50), G50 : F.filter(d => d[2] >= 50 && d[2] < 60), G60 : F.filter(d => d[2] >= 60 && d[2] < 70), SENIOR : F.filter(d => d[2] >= 70), } }} }