Kens Idea Lab

1. \tiny
2. \scriptsize
3. \footnotesize
4. \small
5. \normalsize
6. \large
7. \Large
8. \LARGE
9. \huge
10. \Huge

• Download a connector / ODBC for your platform & Install it

• Add "MySQL ODBC 5.2w Driver" (or yours installed) on Control Panel >> Administrator Tool >> Data Sources (ODBC).

• Put Connection Parameters. Last Parameters 'Database' would be listed if all inputs are correct.

• Test example below.

library(RODBC)
 
con <- odbcConnect("RODBC", uid="myid", pwd="mypw")
 
raw <- sqlQuery(con, "SELECT * FROM table1");

R package rqpd: Regression Quantiles for Panel Data

• Install the package by typing "install.package("rqpd", repos="http://R-forge.R-project.org")" in R. 

• Install other packages for dependencies - 'quantreg', 'SparseM', 'MatrixModels'.
  

      You can install those packages by typing "units:::menuInstallPkgs()" or using Menu>>Package>>Install Package(s).

• Load rqpd by using Menu>>Package>>Load Package or typing "local({pkg <- select.list(sort(.packages(all.available = TRUE)),graphics=TRUE) if(nchar(pkg)) library(pkg, character.only=TRUE)})

  
  

data(bwd)

### A fixed-effects model :
# formula is specified model :
fe.form <- dbitwt ~ smoke + dmage +agesq + novisit + pretri2 + pretri3 
        | as.factor(momid3)

# estimate the model :
fe.fit <- rqpd(fe.form, panel(lambda=0.5), data=bwd)

### A CRE model :
# formula is specified as
cre.form <- dbirwt ~ smoke + dmage + agesq + novisit + pretri2 + pretri3 | momid3 
        | smoke + dmage + agesq

# estimate the model :
cre.fit <- rqpd(cre.form, panel(method="cre"), data=bwd)

cvtnam = "[folder]/[filename].bmp;
cmdstr = " -c=5" $+ " -cf=" $+ cvtnam;
//cmdstr = cmdstr $+ " -q";	
graphprt(cmdstr);

일부를 복사하여 수식에 붙이는 스크립트 매크로 방식. 

동작하는 방식은 원하는 부분을 복사하여 수식편집기에 변수로 집어 넣어 수식을 만들어 낸다.

일반적으로 스크립트 매크로를 생성하게 되면 수식편집기에는 클립보드의 내용이 들어가지 않고 

수식(2)가 String = 고정된 값이 되어 원하는 값을 집어 넣을 수 없다. 

다음과 같이 수식1로 블럭설정된 원하는 값을 변수text에 받고, 수식2에서 text값을 수식 중간에 넣어주게 되면

원하는 값으로 수식을 완성할 수 있다.  

function OnScriptMacro_수식바꾸기()
{
HAction.Run("MoveLineBegin");
HAction.Run("MoveSelRight");
HAction.Run("MoveSelRight");
HAction.Run("MoveSelRight");
HAction.Run("Delete");
HAction.Run("MoveSelRight");
HAction.Run("MoveSelRight");

var text = GetTextFile("TEXT","saveblock");    ---- 수식(1)

HAction.GetDefault("EquationCreate", HParameterSet.HEqEdit.HSet);
with (HParameterSet.HEqEdit)
{
String = "beta _{" + text + "} ^{DELTAP}";   ---- 수식(2)
BaseUnit = PointToHwpUnit(8.0);
Width = 1350;
Height = 1105;
}
HAction.Execute("EquationCreate", HParameterSet.HEqEdit.HSet);
HAction.Run("MoveSelRight");
HAction.Run("MoveSelRight");
HAction.Run("Delete");
HAction.Run("MoveDown");
HAction.Run("MoveLineEnd");
}

1. Download & Install Oracle VM VirualBox (https://www.virtualbox.org/wiki/Downloads)

2. How to boot from a USB Flash Drive in VirtualBox

1. Click Start > Run Type diskmgmt.msc and click OK  (Start > Search Box in Win7).
2. Find the USB Disk number.
3. Open a command prompt cmd.exe 
4. Type cd %programfiles%\oracle\virtualbox
5. Type the following (replace # with your USB Disk number from step 2 and you can find your %USERPROFILE% by typing set at  cmd.exe)    VBoxManage internalcommands createrawvmdk -filename %USERPROFILE%\.VirtualBox\usb.vmdk -rawdisk \\.\PhysicalDrive#
6. Start VirtualBox and create a New Virtual Machine.
7. When prompted for a Virtual Hard Disk, tick use existing hard disk and select usb.vmdk.
8. Once you have finished creating your New Virtual Machine, click Start. 

잠시만.

 - 겐 -