今天早上突然想到 Excel 中 Sum 或者其他基本函數中，有些引數的數量其實不固定，那如果要在自定義的 Function 中要怎麼使用？
於是就整理在這兒了 (￣ー￣)
於是就整理在這兒了 (￣ー￣)
Just a note, enjoy it!
前幾天在教 Excel函數時，發現 Match函數的功能常常會讓人困擾，有些人還會將 Match函數和 Vlookup函數搞混。
使用的範例資料來源是 Excel 裡對於函數 Match 的說明。
Function，所謂的自訂函數。
在Function裡寫入自己想要的功能，而後在工作表(Sheet)裡就能自由運用該函數。
接下來的範例，在Function裡寫入可以抓取該模組(Module)裡全域變數的相關程式碼，就可以在工作表(Sheet)裡使用。
在Function裡寫入自己想要的功能，而後在工作表(Sheet)裡就能自由運用該函數。
接下來的範例，在Function裡寫入可以抓取該模組(Module)裡全域變數的相關程式碼，就可以在工作表(Sheet)裡使用。
Synergy 是一個可以把鍵盤&滑鼠 分享到網絡的東東, 對於我有多台電腦的人 真的很方便.
以下是下載網址
http://synergy-foss.org/zh-tw/
設定方面也沒有有煩, 只是一台電腦開 Server mode 然後把其他電腦加入到 Screen 些定位置就可以了
在我的設定中 一台放左邊 中間是主機 右邊是Mac, 開啟後 就可以主機的鍵盤&滑鼠 在三台電腦之間跑來跑去, 而且 copy & paste 之類也support :p
以下是下載網址
http://synergy-foss.org/zh-tw/
設定方面也沒有有煩, 只是一台電腦開 Server mode 然後把其他電腦加入到 Screen 些定位置就可以了
在我的設定中 一台放左邊 中間是主機 右邊是Mac, 開啟後 就可以主機的鍵盤&滑鼠 在三台電腦之間跑來跑去, 而且 copy & paste 之類也support :p
Cause of work, i has long time didn't update this blog.
In last week, i need to install an project management system redmine. redmine develop in ruby on rails, so i try to install ruby on rails in ubuntu server.
Please follow below step use root account.
1. Install curl.
apt-get install curl
2. Install RVM with ruby.
\curl -L https://get.rvm.io | bash -s stable --ruby
RVM is a command-line tool which allows you to easily install, manage, and work with multiple ruby environments from interpreters to sets of gems.
3. Load rvm source
source [path your install rvm]/rvm
4. Install dependancies
rvm requirements
after this command, will showing the dependeices package you need to install
5. Install Ruby 1.9.3
rvm install 1.9.3
6. Set defualt ruby version
rvm use 1.9.3 --default
7. Install RubyGems
rvm rubygems current
RubyGems is a package manager for the Ruby programming language that provides a standard format for distributing Ruby programs and libraries (in a self-contained format called a "gem").
8. Install Rails
rvm 1.9.3 do gem install rails
When finish all step, now we can start develop our ror projects.
In last week, i need to install an project management system redmine. redmine develop in ruby on rails, so i try to install ruby on rails in ubuntu server.
Please follow below step use root account.
1. Install curl.
apt-get install curl
2. Install RVM with ruby.
\curl -L https://get.rvm.io | bash -s stable --ruby
RVM is a command-line tool which allows you to easily install, manage, and work with multiple ruby environments from interpreters to sets of gems.
3. Load rvm source
source [path your install rvm]/rvm
4. Install dependancies
rvm requirements
after this command, will showing the dependeices package you need to install
5. Install Ruby 1.9.3
rvm install 1.9.3
6. Set defualt ruby version
rvm use 1.9.3 --default
7. Install RubyGems
rvm rubygems current
RubyGems is a package manager for the Ruby programming language that provides a standard format for distributing Ruby programs and libraries (in a self-contained format called a "gem").
8. Install Rails
rvm 1.9.3 do gem install rails
When finish all step, now we can start develop our ror projects.
