In-Geol Choi

From CSBLwiki

Contents 1 Introduction 2 Human Disease Network 2.1 CoPubMed 2.2 UMLS 2.3 GAD 3 Metabolome 4 Tips - think unthinkable! 4.1 Mac OS X 5 Misc.

Introduction

Human Disease Network

CoPubMed

• Mysql database tutorial
• Retrieved publications

UMLS

• MRHIER,MRCONSO,MRXNW_ENG,MRRELM

GAD

• Hanseong's Data GAD_data

Metabolome

• beta-carotenoid pathway in Sde

Tips - think unthinkable!

• 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. That's what appears to be opening the .jnlp files I download on my Mac.

Misc.

Paul W. K. Rothemund manipulated molecules of DNA to create smiley faces that are one one-thousandth the width of a human hair.	DNA origami
Huge dust storms can be easily seen from space like this dust from China blowing across Korea and Japan in April 2002.	Dust in the Wind