Tuesday, May 26, 2020

Determining carbon in timber products

  • The moisture content of the tree biomass is about 35%.
    • The dry matter conversion rate from a tree is 65%. -Source
  • Carbon constitutes 50% of the dry mass of trees.
    • "The carbon content of vegetation is surprisingly constant across a wide variety of tissue types and species. Schlesinger (1991) noted that C content of biomass is almost always found to be between 45 and 50% (by oven-dry mass)." -Source: FAO

Tuesday, May 19, 2020

疫情1-5月记录

2020年,一切都是那么地猝不及防。

让我们把时光倒流四个月,1月18号

这一天,我收拾好了行李,从香港飞到了IAD。在飞机上,隔壁连续打个好几个喷嚏,我心里还有点发怵,只不过当时我脑海里害怕的是流感。两天之后,我和所有人一样看到了央视采访中钟南山院士提到不明肺炎人传人的现象。这几幕似曾相识,当时我就大感不妙,提醒爸妈提高警惕,让我妈赶紧网购N95口罩和酒精。只是没想到这接下来的5天,事情发酵的速度和程度远远超过了大众的想象,疫情随着春运的飞机火车蔓延到了全国各地,根本买不到口罩和消毒用品。后来的事情我们也知道了,疫情还蔓延到了世界各地

Wednesday, May 13, 2020

Edit yourself

我们的故事
像一本遗失的日记
在什么时候写过
在什么地方读过

Tuesday, May 12, 2020

[Excel] Basic functions

Compare two columns

  • see if there are mismatched values (most of them are correct, want to check inconsistency)
Conditional Formatting > Hightlight Cell Rules >  Duplicate Values > Select "Unique"
  • see if there are matched values (only want to find a limited amount of similar values)
Conditional Formatting > Hightlight Cell Rules >  Duplicate Values > Select "Duplicate"

Merge two sheets based on the same key/column

=INDEX(input column, MATCH(reference key, keys of input column, 0))

Get the rank by group 

=SUMPRODUCT((A2=$A$2:$A$205)*(B2<$B$2:$B$205))+1
see this webpage

Monday, May 11, 2020

A glimmer into a dark forest

Fairytale Places to visit in Germany | Great Value Vacations
It's like a dormant soul rising from a deep slumber.
From Embers: New Content in December 2018 - It's Going Down
The racing thoughts remain like embers in a once tempestuous fire.

Tuesday, May 5, 2020

[TV] the Midnight Gospel S1 E1

When I first watched a short excerpt of the Midnight Gospel, the shoddy quality does not appeal to me at all. While I questioned the look of the characters, it turns out I become attracted to the disentanglement of the lines and the scenes. The lines are super thought-invoking but the plots are so irrelevant. This contrast makes it like a late-night talk show with some laid-back background noises, mostly country music and guitars.

Episode 1 so far is quite mind blowing, already. I am more interested in the meditation part than the drug and pro-pot part, but they are certainly deeply connected. I note down my favorite lines.