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`

Testing [my idea](https://definitely.cn/2018/would-microblog-impact-my-bandwidth-less-if-i-migrated-to) appears to have stopped posts syndicating 🤔

Masochism: n. attempting to fix the issue you yourself filed earlier in the day.

https://github.com/mapkyca/BashKnown/issues/3

String variable manipulation in a bash script to feed the -F parts to its curl call.

Struggling to translate a single -F, say the body text, to a reference to $F without spaces ruining it for me…

Via one of my namesakes on T: [Google’s Guinea–Pig City](https://www.theatlantic.com/technology/archive/2018/02/googles-guinea-pig-city/552932/), I’m surprised [@macgenie](https://micro.blog/macgenie) hasn’t posted about it yet, however tenuous the link to small mammals… :o)

Other 📚 reading;

_Wind turbine syndrome: a communicated disease_ by Simon Chapman and Fiona Crichton, [Sydney University Press](https://sup-estore.sydney.edu.au/jspcart/cart/Product.jsp?nID=1093&nCategoryID=1).💨

Ostatnią godzinę przepływu energii elektrycznej 37% 🔋

( if @cn_solar posted to a [micro] blog )

Last night’s 📚 reading;

Continued both _Captain Blood_ ☠️, and _The Graveyard Heart_.

Started _Second Landing_ by Murray Leinster from _The Third Science Fiction Megapack_.

Last night’s 📚 reading;

Started _The Graveyard Heart_ by Roger Zelazny,

Started Chapter XXII of ☠️ _Captain Blood_ by Rafael Sabatini.