2022/04/23

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

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

2019/12/05

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.

2019/11/08

滑鼠右鍵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等指令變成空白。

2019/07/27

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.

2018/06/04

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.

2017/08/18

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.
根據泵浦銘牌,輸入標準最大流量與揚程,至少輸入三種資訊,最後輸入需求流量,即刻顯示泵浦所能提供揚程,請根據需求調整曲線曲率

2017/08/11

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:

2016/11/30

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.)