Back from the dead 😛 Full time all year round collge, car wreck, moving, 40 hours a week, and my mobo dying have kept me pretty busy.
There is no easy way to pull it off the seti site, it takes about 15-25 minutes of work when I had it down pat, daily. I've got
Copy paste the whole stat page into the current date column, delete the last two colums of data, remove word wrap, insert if statement to check position changes, cut/paste the ones that have not changed first, then copy t he changed position names over to the old names, then carefully change the data of ones that have changed, then move the lines around so that the positions are in order, then drag the totals formula's over. Easy? heh Then go to the team performance page, change the weekly date because it will be wrong, update the names and max data, and erase the if statement name for the people that have a score of zero. Then go to top productivity page, update that. Then you are ready for the graphs. If there were any position changes for the people in that graph, then it needs to be updates by click and drag, and sometimes it will mess up and show no data. To correct that just add a name for the chart like 'Date'. You may need to change the min/max value for the charts so it's all visible.
Of course there is more but hopefully this jumble of words will help somehow. I reccomend you update it every 2 days instead of one.
<font color=green>"You talk like a drunk man walks: in every direction but where he is headed"</font color=green>