Skip to main content

<a href="https://definitely.cn/file/8a6b06b7e017d14a95383e3010c65c9e"><img src="https://definitely.cn/file/8a6b06b7e017d14a95383e3010c65c9e" width="600" height="450" style="display: inline-block; max-height: 200px; width: auto; padding: 1px;" class="sunlit_image" /></a><a href="https://definitely.cn/file/f56f6df9da42e88451ec09b83c919a8a"><img src="https://definitely.cn/file/f56f6df9da42e88451ec09b83c919a8a" width="600" height="104" style="display: inline-block; max-height: 200px; width: auto; padding: 1px;" class="sunlit_image" /></a>

Another set of pictures sent via new Sunlit

What one should try not to be:

@qikipedia: Word of the day: DORYPHORE - someone who derives intense satisfaction from pointing out the errors of others.

https://twitter.com/qikipedia/status/991211226876301312

2018-05-01

1 min read

The first of the month is a good time to note down this little trick for spreadsheets:

`=sumif(B1514:B1543,"<>",C1514:C1543)`

This is useful in the solar generation spreadsheet I run, since it sums in column C only when there’s a value in column B; the near–OCD spreadsheet has running calculations in place that make this better than daily editing of the total at the monthly termini in column C (itself a collection of differences).

e.g. C1543 : `=B1543-B1542`

Poll: Has the social internet been reduced to meaningless polls?

Yes, or no.