May
26
由於今年的端午有四天連休,所以活動又更盛大了,歡迎來鹿港玩
附上活動表
交通指引
http://www.lukang.go...3/title-8/index.html
下載活動表
下載檔案 (已下載 938 次)
附上活動表
交通指引
http://www.lukang.go...3/title-8/index.html
下載活動表
![](template/underonev2/images/download.gif)
May
20
由於受人之託,處理名單可是上頭都沒有郵遞區號(村里長名單,在內政部網站可以下載)
想到了中華郵政有3+2的郵遞區號轉檔程式可以使用
但是沒想到我在用的時候困難重重,還沒辦法轉成才糟糕
所以只好自己寫了一小段VBA程式來處理
Sheet1 為名單
Sheet2 為 郵遞區號 table表,格式為 (鄉鎮市區,區碼)
![點擊在新視窗中瀏覽此圖片 點擊在新視窗中瀏覽此圖片](attachment.php?fid=39)
在名單資料中有一個重要的地方是在有一個鄉鎮市的欄位,所以為了比較方便使用了該欄位做為比對的欄位
用了 迴圈,判斷式,字串比對 三個基本的指令
不是我不想用3+2碼,而是3碼,反正還是寄的到...
下次中華郵政的3+2碼的產生軟體可以聰明一些,那3+2碼才會有人用
想到了中華郵政有3+2的郵遞區號轉檔程式可以使用
但是沒想到我在用的時候困難重重,還沒辦法轉成才糟糕
所以只好自己寫了一小段VBA程式來處理
Sheet1 為名單
Sheet2 為 郵遞區號 table表,格式為 (鄉鎮市區,區碼)
在名單資料中有一個重要的地方是在有一個鄉鎮市的欄位,所以為了比較方便使用了該欄位做為比對的欄位
用了 迴圈,判斷式,字串比對 三個基本的指令
i = 1
j = 1
For i = 2 To 7833
For j = 1 To 392
If InStr(Sheet1.Cells(i, 2), Sheet2.Cells(j, 1)) = 1 Then
Sheet1.Cells(i, 8) = Sheet2.Cells(j, 2)
Exit For
End If
Next
Next
j = 1
For i = 2 To 7833
For j = 1 To 392
If InStr(Sheet1.Cells(i, 2), Sheet2.Cells(j, 1)) = 1 Then
Sheet1.Cells(i, 8) = Sheet2.Cells(j, 2)
Exit For
End If
Next
Next
不是我不想用3+2碼,而是3碼,反正還是寄的到...
下次中華郵政的3+2碼的產生軟體可以聰明一些,那3+2碼才會有人用
May
17
這個照片我沒記錯的話...粉久了吔!!
記者吳大人不要這麼不努力了,拿流傳這麼久的照片來當新聞
也太混了吧!!難道沒有新鮮的東西可以報了嗎?
P3的時代,這組照片記得沒錯,超過六年了吧!!那時是P3轉P4的時代
原出處 自由時報
http://www.libertyti...may/17/today-so6.htm
記者吳大人不要這麼不努力了,拿流傳這麼久的照片來當新聞
也太混了吧!!難道沒有新鮮的東西可以報了嗎?
P3的時代,這組照片記得沒錯,超過六年了吧!!那時是P3轉P4的時代
引用
裸女教電腦 網友噴血學組裝
更新日期:2009/05/17 04:09
〔記者吳岳修/台北報導〕不會組裝電腦嗎?網路流傳一封名為「女大生脫衣實地操作教你電腦基本DIY」的KUSO文章,一名女子寬衣解帶,以圖解方式教導網友如何組裝電腦,不少網友瘋狂點閱轉載,留言直呼「太勁爆了!」
電腦專家Luis表示,圖片中的電腦屬Intel P3等級的古董,現在已經不必用螺絲起子裝風扇,而且圖中用腳裝RAM也是搞笑作法,大家笑笑就好,不必當真。
這篇文章被轉載在各大電腦討論區及論壇,總共分成13個步驟,配合文字說明,從最重要的主機板開始,女子逐一介紹CPU、散熱風扇、RAM、硬碟、光碟機等零組件,配合女子脫去胸罩,擺出各種撩人性感姿勢,並以電腦組件巧妙地遮住重點部位,讓網友們看得血脈僨張。
更令網友們充滿無限想像的是,每張圖片還都附上充滿性暗示的組裝說明,「要注意方向喔,CPU可是不接受69式的」、「接下來要插入的就是這個RAM」等雙關用語,讓網友們直呼受不了。
電腦專家則指出,電腦零件並不便宜,建議初學者最好不要自行組裝,以免造成零件損壞。
更新日期:2009/05/17 04:09
〔記者吳岳修/台北報導〕不會組裝電腦嗎?網路流傳一封名為「女大生脫衣實地操作教你電腦基本DIY」的KUSO文章,一名女子寬衣解帶,以圖解方式教導網友如何組裝電腦,不少網友瘋狂點閱轉載,留言直呼「太勁爆了!」
電腦專家Luis表示,圖片中的電腦屬Intel P3等級的古董,現在已經不必用螺絲起子裝風扇,而且圖中用腳裝RAM也是搞笑作法,大家笑笑就好,不必當真。
這篇文章被轉載在各大電腦討論區及論壇,總共分成13個步驟,配合文字說明,從最重要的主機板開始,女子逐一介紹CPU、散熱風扇、RAM、硬碟、光碟機等零組件,配合女子脫去胸罩,擺出各種撩人性感姿勢,並以電腦組件巧妙地遮住重點部位,讓網友們看得血脈僨張。
更令網友們充滿無限想像的是,每張圖片還都附上充滿性暗示的組裝說明,「要注意方向喔,CPU可是不接受69式的」、「接下來要插入的就是這個RAM」等雙關用語,讓網友們直呼受不了。
電腦專家則指出,電腦零件並不便宜,建議初學者最好不要自行組裝,以免造成零件損壞。
原出處 自由時報
http://www.libertyti...may/17/today-so6.htm
May
12
VMWare Server從Guest 連線至HOST分享的檔案時會出現檔案毀損...
Host 的作業系統是 Windows Server 2003
Guest 的作業系統為 Windows Server 2003 / Windows XP
下面是官方的的解決方法
http://kb.vmware.com...stateId=1 0 19462003
This error is seen because the VMware virtual bridge can operate at any speed and is constrained only by the processing power of the host computer's processor. When traffic is sent from the guest to the host it can be sent at very fast speeds. Windows Server 2003 includes security features that interpret network requests at speeds above a specified limit as denial of service attacks. In response, Windows Server 2003 disconnects the client — in this case, the guest VM. Once it is disconnected Windows will not allow it to connect again.
There are several ways you can avoid such disconnections. Use the one that is most convenient in your environment.
Use the bandwidth limiting feature of VMware Workstation 5 (this workaround does not apply to GSX Server). Using a text editor, add two lines to the configuration (.vmx) file of the affected virtual machine.
If the physical Ethernet adapter on the host computer is running at 100Mbps, use the following two lines:
ethernet0.txbw.limit=100000
ethernet0.rxbw.limit=100000
If the physical Ethernet adapter on the host computer is running at 10Mbps, use the following two lines:
ethernet0.txbw.limit=10000
ethernet0.rxbw.limit=10000
In both examples above, the setting affects the virtual machine's first virtual Ethernet adapter (ethernet0). To modify the setting for a second virtual Ethernet adapter, substitute ethernet1. For a third virtual Ethernet adapter, use ethernet2.
This approach increases the load on the host computer's processor and may affect performance.
Disable large send offload in the network settings for the physical Ethernet adapter on the host computer. Note: This is host operating system dependent, not a VMware setting.
This approach increases the load on the host computer's processor and may affect performance.
Use a gigabit switch. Connecting the host computer's network adapter to a gigabit switch helps because the bridge cannot produce traffic that exceeds the 1000Mbps speed of the switch. This workaround provides the highest throughput when you copy large files.
Change the configuration of the virtual machine to use host-only networking. This change is simple to make and may be appropriate for some virtual machines.
Disable or change the Windows Server 2003 settings on the host to disable the security feature. Note: this may increase the security risk of the host as it affects connections to external hosts as well. See: http://support.microsoft.com/kb/898468 for instructions on how to do this.
受影響的版本
VMware GSX Server 3.x (Windows hosts)
VMware Server 1.0.x (Windows Hosts)
VMware Workstation 5.0.x (Windows hosts)
VMware Workstation 5.5.x (Windows hosts)
VMware Workstation 6.0.x (Windows Hosts)
我使用的方法有兩種
1.設定網路卡 關閉-Offload TCP largeSend <<失敗>>
2.限制網路卡最大頻寬 為100Mbps <<成功>>
Host 的作業系統是 Windows Server 2003
Guest 的作業系統為 Windows Server 2003 / Windows XP
下面是官方的的解決方法
引用
http://kb.vmware.com...stateId=1 0 19462003
This error is seen because the VMware virtual bridge can operate at any speed and is constrained only by the processing power of the host computer's processor. When traffic is sent from the guest to the host it can be sent at very fast speeds. Windows Server 2003 includes security features that interpret network requests at speeds above a specified limit as denial of service attacks. In response, Windows Server 2003 disconnects the client — in this case, the guest VM. Once it is disconnected Windows will not allow it to connect again.
There are several ways you can avoid such disconnections. Use the one that is most convenient in your environment.
Use the bandwidth limiting feature of VMware Workstation 5 (this workaround does not apply to GSX Server). Using a text editor, add two lines to the configuration (.vmx) file of the affected virtual machine.
If the physical Ethernet adapter on the host computer is running at 100Mbps, use the following two lines:
ethernet0.txbw.limit=100000
ethernet0.rxbw.limit=100000
If the physical Ethernet adapter on the host computer is running at 10Mbps, use the following two lines:
ethernet0.txbw.limit=10000
ethernet0.rxbw.limit=10000
In both examples above, the setting affects the virtual machine's first virtual Ethernet adapter (ethernet0). To modify the setting for a second virtual Ethernet adapter, substitute ethernet1. For a third virtual Ethernet adapter, use ethernet2.
This approach increases the load on the host computer's processor and may affect performance.
Disable large send offload in the network settings for the physical Ethernet adapter on the host computer. Note: This is host operating system dependent, not a VMware setting.
This approach increases the load on the host computer's processor and may affect performance.
Use a gigabit switch. Connecting the host computer's network adapter to a gigabit switch helps because the bridge cannot produce traffic that exceeds the 1000Mbps speed of the switch. This workaround provides the highest throughput when you copy large files.
Change the configuration of the virtual machine to use host-only networking. This change is simple to make and may be appropriate for some virtual machines.
Disable or change the Windows Server 2003 settings on the host to disable the security feature. Note: this may increase the security risk of the host as it affects connections to external hosts as well. See: http://support.microsoft.com/kb/898468 for instructions on how to do this.
受影響的版本
VMware GSX Server 3.x (Windows hosts)
VMware Server 1.0.x (Windows Hosts)
VMware Workstation 5.0.x (Windows hosts)
VMware Workstation 5.5.x (Windows hosts)
VMware Workstation 6.0.x (Windows Hosts)
我使用的方法有兩種
1.設定網路卡 關閉-Offload TCP largeSend <<失敗>>
2.限制網路卡最大頻寬 為100Mbps <<成功>>