1# Macros: Data > Macros > Record macro with relative references (here2# from the palette) records a column total as a Starlark script; saved3# with a name and a shortcut, it replays from any cell, from Run macro4# or the palette (or Ctrl+Alt+Shift+1, which VHS can't type), as one5# undo step.6Output out/macros.gif7Source lib/setup.tape8Set Theme "Github"910Hide11Type "../bin/012 data/spending.csv" Enter12Sleep 2s13Show1415Sleep 800ms16Ctrl+Down Down17Type "Total" Enter18Up Right19Sleep 500ms20Ctrl+K21Type@100ms "relative references"22Sleep 600ms23Enter24Sleep 1s25Type "=SUM(B2:B7)" Enter26Up27Ctrl+B28Sleep 800ms29Screenshot out/stills/macro-recording.png30Ctrl+K31Type@100ms "stop and save"32Sleep 600ms33Enter34Sleep 800ms35Type@120ms "Column total"36Enter37Sleep 800ms38Enter39Sleep 1.2s40Right41Ctrl+K42Type@100ms "run macro"43Sleep 600ms44Enter45Sleep 1s46Enter47Sleep 1.5s48Right49Ctrl+K50Type@100ms "column total"51Sleep 1s52Enter53Sleep 2s54Screenshot out/stills/macro-replayed.png55Sleep 1.5s