In-Geol Choi

From CSBLwiki

Revision as of 02:52, 9 August 2009 (view source) Igchoi (Talk | contribs) (→Misc.) ← Older edit		Revision as of 07:02, 18 August 2009 (view source) Igchoi (Talk | contribs) (→CoPubMed) Newer edit →
Line 2:		Line 2:
	==Human Disease Network==		==Human Disease Network==
	===CoPubMed===		===CoPubMed===
-	*[http://database.sarang.net/database/mysql/tutorial/beginning_mysql_tutorial Mysql database tutorial]
	*Retrieved publications		*Retrieved publications
		+
	===UMLS===		===UMLS===
	*MRHIER,MRCONSO,MRXNW_ENG,MRRELM		*MRHIER,MRCONSO,MRXNW_ENG,MRRELM

---

Revision as of 07:02, 18 August 2009

Contents 1 Introduction 2 Human Disease Network 2.1 CoPubMed 2.2 UMLS 2.3 GAD 3 Metabolome 4 Tips - think unthinkable! 4.1 MS Windows 4.2 Mac OS X 4.3 R 4.4 Matlab 5 Misc. 5.1 Bioenergy & Synbio

Introduction

Human Disease Network

CoPubMed

• Retrieved publications

UMLS

• MRHIER,MRCONSO,MRXNW_ENG,MRRELM

GAD

• Hanseong's Data GAD_data

Metabolome

• beta-carotenoid pathway in Sde

Tips - think unthinkable!

MS Windows

• Removing all animations at once from MS powerpoints slides VBA code
• Merging many Excel files into a single sheet - VB code

Sub 파일통합()
Dim OpenSheet As Workbook
Dim file As Variant
Dim WorkFiles As Variant
Dim copyTo As Range
WorkFiles = Application.GetOpenFilename(filefilter:="Excel,*.xls", Title:="파일선택", MultiSelect:=True)
For Each file In WorkFiles
Set OpenSheet = Workbooks.Open(file)
'선택한 파일을 하나씩 열고 OpenSheet변수에 담습니다.
Set copyTo = Sheet2.Cells(65536, 1).End(xlUp).Offset(1, 0)
'sheet2의 마지막 데이터 끝부분에 붙여 넣기위해 입니다.
OpenSheet.Worksheets(1).UsedRange.Copy copyTo
'파일의 내용을 복사해서 붙여넣기 합니다.
'단, 통합하고자 하는 파일들의 sheet1에 데이터가 입력되어 있어야 합니다.
Application.CutCopyMode = False
OpenSheet.Close savechanges:=False
Next file
End Sub 

Mac OS X

• 레오퍼드 설치 후 FireFox에서 한글이 첫번째 그림과 같이 나올 경우 아래에 방법을 따라하면됨 (썬더버드도 마찬가지)

1. FireFox 완전 종료
2. Finder -> Applications -> FireFox 마우스 오른쪽 버튼 클릭 -> Show Package Contents 클릭
3. Resources 폴더안 en.lproj 폴더의 폴더명 Korean.lproj로 변경 (주의) 대문자 K 사용
4. FireFox 실행 후 확인

• .jnlp opening:

On a .jnlp file you're trying to use Java Web Start on, change the "Open with:" to /System/CoreServices/Java Web Start.

R

• R

Matlab

• Matlab

Misc.

Bioenergy & Synbio

• Biofuel related synthetic biology (by Green Car Congress)
• Special Reports on Biofuels
• MIT energy biofuel blog