1# Linked sources: ten million rows of Parquet (made by gensales) linked2# as a source (Data > Linked file > Link a source, here from the3# palette), sorted by amount Z to A in the background, its rows4# numbered past the grid's last, and read whole by formulas on Sheet1:5# a count grouped, an AVERAGEIFS, the last day as a date, and a MEDIAN of6# every amount, sorted on disk in the background.7Output out/sources.gif8Source lib/setup.tape9Set Theme "GruvboxDark"1011Hide12Type "go run ./gensales out/sales.parquet && clear && ../bin/012" Enter13Wait+Screen@90s /Help/14Show1516Sleep 500ms17Ctrl+K18Type@80ms "link a source"19Sleep 400ms20Enter21Sleep 500ms22Type@40ms "out/sales.parquet"23Enter24Sleep 800ms25Down26Up27Sleep 1s28Screenshot out/stills/sources-linked.png29Sleep 400ms30Right 231Ctrl+K32Type@80ms "sort sheet z to a"33Sleep 400ms34Enter35Wait+Screen@30s /sorted by amount Z to A/36Sleep 1.2s37Screenshot out/stills/sources-sorted.png38Sleep 400ms39Ctrl+K40Type@80ms "previous sheet"41Sleep 400ms42Enter43Sleep 400ms44Type@8ms "Rows"45Tab46Type@8ms "=ROWS(sales)"47Enter48Type@8ms "North"49Tab50Type@8ms `=AVERAGEIFS(sales[amount],sales[cat],"north")`51Enter52Type@8ms "Last day"53Tab54Type@8ms "=MAX(sales[day])"55Enter56Type@8ms "Median"57Tab58Type@8ms "=MEDIAN(sales[amount])"59Enter60Up61Right62Wait+Screen@60s /Median +[0-9]/63Sleep 1.5s64Screenshot out/stills/sources-formulas.png65Sleep 1s