Mar 15, 2012

Count the number of cells/values by multiple group/criteria in Excel 在 Excel 中依照多個群組計算值的次數

Excel count the number of values by countif function:
在 Excel 中可以用 countif 函數來計算值出現的次數


If we need count the number of values by multiple columns:
如果需要依照多個群組來計算的話:




Rank data by group in Excel 在 Excel 中依照群組排名資料

Excel Rank function can be used to rank for single column ("Charge") data easily.
Excel 使用 rank 函數可以很容易的排序單一行的數值,這裡以charge 為例。



How about if we want to rank "Charge" by "Method" like this ?
但是如果要先依照 Method 群組後,再排名 Charge呢?


Mar 9, 2012

Enable disk cache to speed up Firefox 設定磁碟快取來加速火狐瀏覽器

Firefox browse cache usually was limited by ram size.
Firefox 的瀏覽快取通常都被記憶體大小限制住。

Using disk cache can increase more browse cache efficiency especially with SSD disk.
所以使用硬碟快取的話可以更增加快取效率,尤其是使用 SSD 硬碟。



Step 1. type "about:config" in web address bar and press Enter.
步驟一. 在網址列輸入 about:cache 並按下Enter。


Mar 6, 2012

Make subsonic support rm and rmvb format 讓 Subsonic支援 rm/rmvb

Subsonic is a software to provide streaming music and video.
It's easy to install and manage.
Try it if you like listening music and watching video online even with your smartphone!

Subsonic 是一套可以線上串流音樂與影片的軟體,
不只安裝容易,管理也很方便,
適合喜歡在線上欣賞多媒體的使用者,也支援手機app!

Dec 21, 2011

View full text of RSS in Google Reader with Firefox 在 Firefox 中讀取完整全文的RSS

*. install extension: greasemonkey
在 Firefox 瀏覽器中安裝插件 Greasemonkey
https://addons.mozilla.org/en-US/firefox/addon/greasemonkey/


*. install the script "Google Reader Preview Enhanced v1.2" for greasemonkey
再安裝 Greasmonkey 的閱讀全文 RSS 腳本 Google Reader Preview Enhanced v1.2
http://userscripts.org/scripts/show/104222


*. If this function works, you can see the "Preview button" on every RSS feeds
如果成功的話,在 Google Reader 的每個RSS檢視中,右下角就會有個 Preview模式。


 *. click "Preview" button and you will get whole content of the feed.
按下 "Preview" 鈕後,就可以看到完整的內容。