1# Tracing: with precedents and dependents shown, the pointer on North's2# revenue marks the regions and revenues it reads and the price per unit3# that reads it; then Evaluate formula steps through the price, into4# the revenue it reads and back out.5Output out/tracing.gif6Source lib/setup.tape78Hide9Type "../bin/012 data/sales.csv" Enter10Sleep 2s11Ctrl+G12Type "F1" Enter13Type "North" Enter14Type@40ms '=SUMIF(A2:A17,"North",D2:D17)' Enter15Type "Units" Enter16Type@40ms '=SUMIF(A2:A17,"North",C2:C17)' Enter17Type "Per unit" Enter18Type@40ms "=F2/F4" Enter19Show2021Sleep 800ms22Ctrl+K23Type@60ms "show precedents"24Sleep 800ms25Enter26Sleep 3s27Ctrl+G28Type "F2" Enter29Sleep 3s30Screenshot out/stills/tracing-marks.png31Down@600ms 232Sleep 1.5s33Down@600ms 234Sleep 2s35Ctrl+K36Type@60ms "evaluate formula"37Sleep 800ms38Enter39Sleep 1.5s40Right41Sleep 1.5s42Screenshot out/stills/tracing-into.png43Enter44Sleep 1.2s45Left46Sleep 1.5s47Screenshot out/stills/tracing-evaluate.png48Enter49Sleep 1.2s50Enter51Sleep 2s52Screenshot out/stills/tracing-value.png53Escape54Sleep 1s