LibreOffice – Formulae Auditing

If you have a excel sheet with lot of formula’s and you are trying to audit them, then a simple solution is to press “ctrl+`” (i.e. control key with back tick). This will put the excel sheet in Formula auditing mode and hence all the cells will show the formula rather than the values which will make it easier to audit them. Hope that helps.

Enhanced by Zemanta

using gnuplot for time plotting

Couple of days back, I was working with some data and wanted to plot it. I had couple of options Excel, ploticus and then our own gnuplot. My choice here was gnuplot, as this is most commonly available and helps me write scripts that can automate my repetitive task. So far, so good. The data I was plotting was against time, that was the problem. Couple of quick searches did not result into any luck to get me on the path and hence with some man pages and some documentation, finally I found this, might be this will be helpful for others.

1
2
3
4
5
gnuplot> set xdata time

gnuplot> set timefmt "%Y-%m-%d"

gnuplot> plot "sample.dat" using 1:2 with boxes
Enhanced by Zemanta