SP500市場寬度

在Excel中清除多餘的列(Row)

當Excel工作表下方有多餘、無法刪除的空白列，可參考以下步驟：

How to fix no HEAT from the central vent on BMW E36

One day I've found there was no heat air from the central vent,

so I spent some time checking it out.

滑鼠右鍵Adobe Acrobat等指令消失但可運作 (The Adobe Acrobat entry in Context Menu is missing but still works)

Windows 7 x64環境，
原先已安裝Adobe Acrobat X Pro，
再安裝Backup and Sync from Google後，
按滑鼠右鍵選單，
Convert to Adobe PDF等指令變成空白。

How to connect SONY PS3 controller to Mac (High Sierra) with Bluetooth

The information I've found on the Internet are mostly wrong. The steps below are tested and worked.

How to rotate the QuickTime MOV taken by iPhone?

Use the latest Exiftool to rotate the MOV.
https://www.sno.phy.queensu.ca/~phil/exiftool/

How to fix the wrong order while importing the photos into Photos App?

When there are great differences between GPSTimeStamp and CreateDate in the Exif, it will leave the TimeZone blank and show the wrong time and date in the "Adjust time & date" after importing the photos taken by old iphone, like iPhone4S.

Pump Q-H Curve Simulation

Please input standard or maximum Q and H derived from pump name plate (at least three variables), then input the required Q. The provided H will be shown immediately. Tune the curvature C as needed.
根據泵浦銘牌，輸入標準或最大流量與揚程，至少輸入三種資訊，最後輸入需求流量，即刻顯示泵浦所能提供揚程，請根據需求調整曲線曲率。

How to backup and restore system partition by AOMEI Backupper?

Symptom: The "Boot error" message will show when the new file created in the bootable USB disk made by AOMEI Backupper. I don't know why it causes, so I choose another way. Here are the steps:

How to fix "ASF2 force off" on Dell E7440

Model

Dell E7440 laptop.

Symptom

1. Automatically reboot when opening the lid in sleep (S3) mode.
2. "ASF2 force off" in the BIOS system log.
3. Display "Sending Inter(R) Management Engine FW Update" and stop while re-flashing the BIOS.
   (Unplug and remove the batteries will turn off the laptop. It should be fine to boot again.)

啟用Apache (2.2.22) 與Opencart SSL功能 (Debian Wheezy@網樂通)

啟用Apache (2.2.22) 與Opencart SSL功能 (Debian Wheezy@網樂通) 

網樂通改為Airplay喇叭

網樂通改為Airplay喇叭

Re-assign sharing path while restarting "Simple HTTP Server Pro"?

Here are the quick fix:

How to let SIP traffic pass through tomato (shibby build) router?

1. Go to "Port Forwarding".
2. Open 5070 port for internal IP.
3. Go to Advanced > Conntrack/Netfilter > Tracking / NAT Helpers
4. Uncheck "SIP"
5. Done!

How to upgrade firmware for UJ240AS Blu-ray recorder?

Follow the steps below to upgrade the firmware without any check.
("Target Drive Not Connected" will not be shown again)

Mac使用sftp連線時不會因為睡眠自動斷線

A: 使用sftp連線時不會因為睡眠自動斷線
http://thefragens.com/2011/12/chrootd-sftp-on-mac-os-x-server/
http://www.linickx.com/os-x-anonymous-ftp-directory-on-mountain-lion
A1. 設定 ftpd, sftp相關參數
A2. 試需要將使用帳號，"登入shell"改為"/bin/sh"
A2. 安裝 xcode
A3. 安裝 Homebrew
A4. 執行 brew install bindfs
(依照畫面安裝osxfuse等工具)

iOS無法與tomato router建立PPTP VPN連線？

在VPN Tunneling > PPTP Server中， 依個人需要啟用PPTP。
另外在Administration > Scripts > firewall新增
iptables -I INPUT -p gre -j ACCEPT
iptables -I INPUT -p tcp --dport 1723 -j ACCEPT
iptables -A FORWARD -j ACCEPT -i ppp+
iptables -A INPUT -j ACCEPT -i ppp+

Apple TV直接播放Mac中各種影片並支援網路喚醒

功能特色

1. 透過Apple TV直接播放Mac中各種格式的影片。
2. 不需使用iPhone、iPad作為中繼轉發。
3. 不用破解、修改Apple TV任何設定。
4. Mac在睡眠狀態時，可自動喚醒建立連線。
5. 徹底取代一般NAS。

Windows XP無法連Yosemite？外接硬碟無法設定檔案共享？

最近新買Mac mini來當NAS，
本以為很小事一件，
結果遇到超多奇怪問題。
特別整理近日心得，
分享給網友。

Enable PPPoE Relay on Netgear R7000 with FreshTomato

[2023/12/11 更新]

將路由器由RT-16N更換為R7000後，

原PPPoE Relay功能無法使用，
該程式適用MIPS架構(RT-16N)，

無法用於ARM架構(R7000)。