script and sql to calculate offset for last x days

[zc] / gnuplot / calc-offset.sql

select pn,-avg(x_axis_angle),-avg(y_axis_angle) from zc
where time > now() - interval '90 days'
group by pn
order by pn ;