엑셀을 새로운 윈도우로 열고 싶은데 자꾸 같은 창에 열린다.

두개를 나누어서 보고 싶은데 동시에 뜬다.

해결법 3 가지 선택 사용~



@새로운 엑셀 실행하여 열기


1. 열고싶은 엑셀 파일 말고 새롭게 뜨는 Microsoft Excel 을 실행

2. 열고싶은 엑셀 파일을 드래그 & 드랍으로 Excel 프로세스에 넣기 (혹은 열기 메뉴 활용)



@레지스트리 편집을 통하여 따로 뜨게 할 수 있다. (삭제가 이루어짐)


1. 윈도우키 + R   [실행]켜기

2. regedit 입력

3. 왼쪽 창 폴더들 중 HKEY_CLASSES_ROOT 폴더 선택

* pre. 4. Open 안에 삭제를 하게 되니 미리 백업을 하면 좋음.

4. Excel.Sheet.12 선택 -> sheel 폴더 선택  -> Open 폴더 선택

5. Open 폴더 하위에 있는 ddeexec 폴더 삭제 -> 영구적 삭제? Yes

6. Open 폴더 하위에 있는 command 폴더 안에 command 삭제

7.. (기본값) 이라 써져있는 파일  오른쪽 클릭 -> 수정 선택 후 내부 값데이터(V): 란 맨 마지막에 한칸 띄우고 "%1"  입력


8. Excel.Sheet 8 에도 위 4~7경우 똑같이 수행


* Excel.Sheet.8  -> xls 확장자에 대한

* Excel.Sheet.12 -> xlsx 확장자에 대한



@ 정식 microsoft 제공 방법 (https://support.microsoft.com/ko-kr/kb/2551928)


1. 메모장에 다음 텍스트를 넣고 저장. 확장자를 .reg 로 만들어서 저장. (파일명은 아무거나...)

2. 만들어진 파일을 실행하여 사용자 계정 컨트롤 암호입력하거나 예 눌러서 진행

* 여기서 C:\\Program Files\\ 는 설치경로에 맞추어서 설정 ( 예> C:\\Program Files (x86) )

Windows Registry Editor Version 5.00
 
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open]
@="열기(&O)"
 
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command]
@="\"C:\\Program Files\\Microsoft Office\\Office14\\EXCEL.EXE\" /m \"%1\""

3. 메모장에 다음 텍스트를 넣고 저장. 확장자를 .reg 로 만들어서 저장. (파일명은 아무거나...)

4. 만들어진 파일을 실행하여 사용자 계정 컨트롤 암호입력하거나 예 눌러서 진행

Windows Registry Editor Version 5.00
 
[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open]
@="열기(&O)"
 
[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command]
@="\"C:\\Program Files\\Microsoft Office\\Office14\\EXCEL.EXE\" /m \"%1\""


Posted by 초올싹
,

Solutions of “Windows cannot be installed to disk 0 partition 1”


In fact, every error message has tips behind it. If your partition is GPT, you should ensure that your motherboard support UEFI/EFI, so system can boot from from GPT partition. Otherwise you have to convert GPT to MBR. GPT is one of partition styles, NTFS is one of file system. If it asked you installed to a NTFS partition, you can select NTFS when you formatting it, you can also try to convert FAT to NTFS.


The main problem is many users don’t know their machine’s partitions very well, so they have to deal with every different question time after time. Thus spend lots of time. So, is there any solution help you solve all of them at one time? Yes, some geeks have already found out practical methods and post them on Internet.


At first, let me tell you that most of them who come across these problems is due to they want re-install Windows or install a second OS as dual boot system. That is to say, their partitions are used before.


Solution 1:


If there is no reason to keep these partitions, you can remove them by using Windows Disk Management tool on the installation disk as follows:


Left click a partition to highlight it. Click on the blue link “Drive options (advanced)”. Select the “Delete” option.


Repeat this for each partition listed.


When done, you should see just 1 entry showing as “Disk 0 Unallocated space”


Click the “Next” button to install Windows 7 continuely.


Be aware that Windows 7 will also create a hidden “System Reserved” partition of around 100Mb which contains the boot files and recovery environment. Backup your important things before deleting.


Solution 2:


At the screen when it ask you to choose which drive to install Windows on, press Shift+F10 and a DOS window would open.


Type: diskpart Type: list disk (you should see only Disk0) Type: select disk 0 Type: clean


Close the DOS window, click on Refresh, select the disk that is listed, and click Next.

Posted by 초올싹
,

Python - Numpy 를 사용하여 데이터 피팅





#curve_fit code (figure2)


import numpy as np

import matplotlib.pyplot as plt

from scipy.optimize import curve_fit


#최소자승법사용

def func(x, a, b, c):

return a*np.exp(-(x-b)**2/(2*c**2))

x = np.linspace(0,10,100)

y = func(x, 1, 5, 2)


yn = y + 0.2 * np.random.normal(size=len(x))


popt, pcov = curve_fit(func, x, yn)


cur_y = func(x, popt[0], popt[1], popt[2])


#그래프그리기

g1, = plt.plot(x, y, 'k')

g2, = plt.plot(x, yn, 'b.')

g3, = plt.plot(x, cur_y, 'r')


plt.legend([g1,g3], ['Funtion', 'Best fit'], loc = 2)


plt.axis([-2,12,-0.5,1.5])


plt.show()




Python - Numpy를 이용하여 함수의 해 도출



#code (figure5)


import numpy as np

import matplotlib.pyplot as plt

from scipy.optimize import fsolve


def findIntersection(func1, func2, x0):

    return fsolve(lambda x : func1(x) - func2(x), x0)


funky = lambda x : np.cos(x/5) * np.sin(x /2)

line = lambda x : 0.01 * x - 0.5


x = np.linspace(0,45,10000)

result = findIntersection(funky, line, [15,20,30,35,40,45])


funky_v = funky(x)

line_v = line(x)


#그래프그리기

g1, = plt.plot(x, funky_v, 'b')

g2, = plt.plot(x, line_v , 'k')

g3, = plt.plot(result, line(result), 'ro')


plt.legend([g1,g2], ['Funky func', 'Line func'], loc = 3)


plt.axis([0,45,-1.0,1.0])


plt.show()


Posted by 초올싹
,