Excel欄位的自動編號

使用Excel製作數據列表時經常需要為列表編流水號。 如果要編的號碼不多，最簡單的方法是在第一；二欄內輸入順序數字，選擇後按住右下角向下拖到適當的欄位放手即可。

Bootcamp安裝windows 7

Bootcamp利用windows iso檔作USB開機windows隨身碟:

1. 打開第一個封印的選項
Full solution:

1. Add your Boot Rom Version(from system info) under DARequiredROMVersions.
2. Add Model Identifier(from system info) under PreUSBBootSupportedModels
3. Delete "Pre" from "PreUSBBootSupportedModels", so you have "USBBootSupportedModels"

The first 3 steps are same as before and if its not clear you can easily google solutions with screenshots.
The next step is only for OSX 10.9, as it employs some kind of code signature to prevent you from changing info.plist and cause bootcamp to crash.

4. Open your terminal, use the following command
sudo codesign -fs - /Applications/Utilities/Boot\ Camp\ Assistant.app

Sudo means using administrator privilege and u need to enter your mac password. And the command resigns the bootcamp application so that it runs with the new info.plist file and not crash.

5. Continue on with your installation....

2.參考以下文章
http://7--8.com/article.php?id=106
http://steachs.com/archives/2734

How VirtualBox enable the command tab switching between MAC and windows.

You can try to disable "Auto capture keyboard" in the Input section of the Global Preferences. This should give you the desired behavior. Please note that in this case even most of the F-keys aren't send to the guest.

喜好設定->Input->自動擷取鍵盤(不要選取)

How to send break in securecrt?

http://tekcert.com/blog/2012/06/25/how-do-crtlbreak-sequence-securecrt-without-break-key

1. Start out by establishing your console connection.
2. In Secure CRT, Click on the Options button (or go to the Options menu and click Session Options).
3. Click on Mapped Keys under the Emulation Section.
4. Click on the Map a Key button, then type whatever key combination you want when it prompts you (I typed Ctrl+delete).
5. In the Function drop down, select Telnet Function.
6. In the Telnet Function drop down, select TN_BREAK.
7. Click Ok.

Mac OS 安裝嘸蝦米輸入法

http://hopeyoung1208.blogspot.com/2011/12/mac-os.html

Mac OS 使用Air Video Client

安裝下面這個軟體
http://dl.dropbox.com/u/6713110/MacAirVideoClient/Site/Home.html

如何在iphone共用他人行事曆

把iphone語言先改成英文

接下來設定sync
http://www.ckizumi.com/2011/03/icaliphone-google-calendar.html

加入caldav帳號
http://jimgau.pixnet.net/blog/post/19769184-%5Biphone%5D%E5%88%A9%E7%94%A8caldav%E5%90%8C%E6%AD%A5google%E8%A1%8C%E4%BA%8B%E6%9B%86
http://www.ckizumi.com/2011/03/icaliphone-google-calendar.html

重新命名所有windows檔名軟體

批次改檔名：CKRename v1.08

http://milo0922.pixnet.net/blog/post/33053136-%E3%80%90%E4%B8%8B%E8%BC%89%E3%80%91%E5%8F%96%E4%BB%A3ckrename---%E6%94%AF%E6%8F%B4unicode-%E5%A4%A7%E9%87%8F%E9%87%8D%E6%96%B0%E5%91%BD

Macbook Pro replaces the optical drive with a hard drive and make a raid 0/fusion drive

Reference Link:

How to make a mac USB bootable hardware with Carbon Copy Cloner?
http://mac4twn.blogspot.com/2011/09/mac-bootable-harddrive.html

How to replace the optical drive and hard drive?
http://www.ifixit.com/Device/MacBook_Pro_13%22_Unibody_Early_2011

How to use software raid0 and carbon copy clone?
http://macuknow.com/node/6592

How to use software fusion drive?
http://blog.roodo.com/appleseed/archives/21280476.html
http://www.macuknow.com/node/21313

How to fix the DVD player can not play the external optical drive?
http://www.macuknow.com/node/17715

PDF簡轉繁

http://snotyboy.site90.net/?p=2454

使用FreeFileSync自動定期備份檔案

http://blog.hwjh.ylc.edu.tw/wpmu/beetlebug/?p=1310

iOS JB  後需知
1. 加respoistory --> http://cydia.hackulo.us
2. 加installous
3. 加appsync

PS3 Media Server 設定

記得把port改成不是5001，否則會找不到PS3

參考文章
http://www.mobile01.com/topicdetail.php?f=348&t=1987739&m=f&last=25601181
http://www.mobile01.com/topicdetail.php?f=281&t=993580

P874 硬體撥接 + EDIMAX BR-6264N AP分享器 + 網路芳鄰

首先確認小烏龜是P874型號，並請中華電信設定硬體撥接 + DHCP
接下來設定各品牌無線AP分享器

目的是為了連上P874無線網路所得到的ip(192.168.1.100~192.168.2.200)也可以存取在所有接在無線AP分享器後面機器的網路芳鄰功能，並且MOD也可以正常觀看。

架構:

P874小烏龜 port2 -> Home Plug -> Hub -> MOD and Mac Mini (Samba Client)
                   port3 -> 無線AP分享器Lan port (Wifi AP Server for Mac book/iphone/ipad/epson l355 printer server) -> 網路芳鄰(Windows 7 Samba Server)

無線AP分享器設定:

1. 確定P874小烏龜設定為硬體撥接 + DHCP
2. Home Plug不要從P874小烏龜的MOD port接出來到無線AP分享器。舉我的例子，我的P874小烏龜的MOD port設定是在ETH1(連進去192.168.1.1就可以看到)，所以必需要從ETH2(port 2)~ETH4(port 4)接到Home Plug.
3. P874小烏龜不要從MOD port接出來，且不要接到無線AP分享器的Internet Port(或WAN Port),要接到無線AP分享器的Lan Port.
4. 關閉無線AP分享器的DHCP Server功能。
5. 將無線AP分享器的網頁設定IP位址改為192.168.1.200以後的IP。(如192.168.1.218)

舉例我的無線AP分享器網頁ip設定位址: 192.168.1.218
Server的電腦ip設定位址: 192.168.1.168
Client的電腦ip設定位址: 192.168.1.109

參考文章
http://www.mobile01.com/topicdetail.php?f=110&t=2443641&m=s&s=10&r=10&last=31971263

Set up FileZilla Server

After installing the filezilla with default setting, remember to add the two settings.
1.  Add Filezilla FTP client and Filezilla server interface into firewall exception.

 2. Add FTP server port 21 and filezilla port 20 into firewall service hinet and local ethernet connection 

Set Tonido Server

Set up Tonido server in windows to share photo and music on laptop, iOS and Android devices.

Change the default sync folder path
Find the file of syncserverconfig.xml C:\Documents and Settings\kody\Application Data\Tonido\data\profiles\kodyannie\plugindata\syncserver
Replace the "DEFAULT" as "D:\Photos\Sync_photos"

  xml version="1.0" encoding="UTF-8" standalone="no" ?>

- <variantrow>

- <rowentry>

  <name>syncclientlocationname>

  <type>stringtype>

  <value>DEFAULTvalue>

  rowentry>

- <rowentry>

  <name>syncfolderlocationname>

  <type>stringtype>

  <value>DEFAULTvalue>

  rowentry>

- <rowentry>

  <name>syncserverlocationname>

  <type>stringtype>

  <value>D:\Photos\Sync_photosvalue>

  rowentry>

variantrow>

The private line:
http://kodyannie.tonidoid.com

How to set up the server:
http://walker-a.com/archives/789
http://blog.hmes.kh.edu.tw/wordpress/fatball/2011/09/21/%E5%88%A9%E7%94%A8tonido%E4%BE%86%E6%9E%B6%E8%A8%AD%E5%80%8B%E4%BA%BA%E9%9B%B2%E7%AB%AF%E6%9C%8D%E5%8B%991-pc%E4%BC%BA%E6%9C%8D%E5%99%A8%E5%AE%89%E8%A3%9D/

Source Insight 快速鍵及設定

1、背景色選擇
要改變背景色Options->preference->windows background->color設置背景色

2、解決字符等寬對齊問題。
SIS默認字體是VERDANA，很漂亮。這網頁上應該也是用的VERDANA字體。但由於美觀的緣故，VERDANA字體是不等寬的。比如下面兩行
llllllllll
MMMMMMMMMM
同樣10個字符，長度差多了.用VERDANA來看程序，有些本應該對齊的就歪了。解放方法是使用等寬的字體，但肯定比較醜。比較推薦的是用Courier New。

3、解決TAB鍵縮進問題
Options-> Document Options裏面的右下角Editing Options欄裏，把Expand tabs勾起來，然後確定。OK，現在TAB鍵的縮進和四個空格的縮進在SIS裏面看起來就對齊咯

4、SI中的自動對齊設置:
在C程序裏, 如果遇到行末沒有分號的語句,如IF, WHILE, SWITCH等, 寫到該行末按回車，則新行自動相對上一行縮進兩列。
Option->Document option下的Auto Indient中Auto Indient Type有三種類型 None,Simple,Smart。個人推薦選用Simple類型。

5、向項目中添加文件時，只添加特定類型的文件（文件類型過濾器）
編輯匯編代碼時，在SIS裏建立PROJECT並ADD TREE的時候，根據默認設置並不會把該TREE裏面所有匯編文件都包含進來
只加了.inc和.asm後綴的，.s後綴的沒有。而且用SIS打開.s的文件，一片黑白沒有色彩，感覺回到DOS的EDIT時代了……
解決方法是在Options->Document Options裏面，點左上的Document Type下拉菜單，選擇x86 Asm Source File，
然後在右邊的File filter裏*.asm；*.inc；的後面加上*.s；接著CLOSE就可以了。
上面問題解決了，但註意加入*.s後還需要重新ADD TREE一遍才能把這些匯編加到PROJECT裏面。

6、添加文件類型
用戶可以定義自己的類型，Options->Document Options->add type,定義文件類型名以及文件名後綴。
勾選include when adding to projects在添加目錄下文件到工程是該類文件就會添加進SI的工程。
如果需要將所有文件添加進SI的工程，可以定義一種文件類型*.*。

7、恢復ctrl+a的全選功能
通過關鍵詞save 找到save all，更改為ctrl+shift+a，通過關鍵詞select找到select all，更改為ctrl +a

Source Insight常用的快捷鍵：
Ctrl+= :Jump to definition
Alt+/ :Look up reference
F3 : search backward
F4 : search forward
F5: go to Line
F7 :Look up symbols
F8 :Look up local symbols
F9 :Ident left
F10 :Ident right
Alt+, :Jump backword
Alt+. : Jump forward
Shift+F3 : search the word under cusor backward
Shift+F4 : search the word under cusor forward
F12 : incremental search
Shift+Ctrl+f: search in project
shift+F8 : hilight word

Reference: http://lipingke.blog.hexun.com.tw/35698141_d.html

linux driver create file

Create file in linux file system directory

Under /sys directory:

DEVICE_ATTR(name, mode, show, store);

int device_create_file(struct device *device, struct device_attribute *entry);
void device_remove_file(struct device *dev, struct device_attribute *attr);

For example:
static DEVICE_ATTR(dev, S_IRUGO, sculld_show_dev, NULL);

static void sculld_register_dev(struct sculld_dev *dev, int index) {
sprintf(dev->devname, "sculld%d", index);
dev->ldev.name = dev->devname;
dev->ldev.driver = &sculld_driver;
dev->ldev.dev.driver_data = dev;
register_ldd_device(&dev->ldev);
device_create_file(&dev->ldev.dev, &dev_attr_dev);
}


Under /proc directory:
1. create_proc_entry( "file_name", S_IFREG | S_IWUSR, &proc_root);
2. SYSDEV_ATTR(_name, _mode, _show, _store)