jmyoon4488

Option Explicit
Sub Lottery()
Dim RngLot As Range, R As Range
Dim CountAll As Long, CountLot As Long
  
Range("B:B").ClearContents
CountLot = Val(InputBox("input count for pick"))
Set RngLot = Range(Range("B2"), Range("B2").Offset(CountLot - 1, 0))
CountAll = Range(Range("A2"), Range("A2").End(xlDown)).Count

jmyoon4488

# for mac

# https://subicura.com/2017/11/22/mac-os-development-environment-setup.html
# https://medium.com/harrythegreat/oh-my-zsh-iterm2%EB%A1%9C-%ED%84%B0%EB%AF%B8%EB%84%90%EC%9D%84-%EB%8D%94-%EA%B0%95%EB%A0%A5%ED%95%98%EA%B2%8C-a105f2c01bec

# brew install
/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
#/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

# git

jmyoon4488

// json 내의 주석부분 붉은 바탕의 경우 github 에서 jsonparser 에 의한 오류부분을 나타냄
// json 에서 기본적으로 주석 사용이 불가능하기 때문에 표시되는 것으로 보임.
// 무시하고 사용하거나 사용시 오류가 발생할 경우 지워보기를 권장.
// 참고 : https://stackoverflow.com/a/30669730

// This file was initially generated by Windows Terminal 1.0.1401.0
// It should still be usable in newer versions, but newer versions might have additional
// settings, help text, or changes that you will not see unless you clear this file
// and let us generate a new one for you.

jmyoon4488

# Read more about SSH config files
Host github-home
    HostName github.com
    User git
    IdentityFile ~/.ssh/jm-home
    
# Example - Clone from github
git@github-home:jmyoon4488/ML_Study

# edit file permission

jmyoon4488

import requests
import json

TELEGRAM_TOKEN = 'token'
CHANNEL_ID = 'id'
ADMIN_ID = 'id'
BOT_INFO_URL = 'https://api.telegram.org/bot{token}/getme'
BOT_UPDATES_URL = 'https://api.telegram.org/bot{token}/getUpdates'
BOT_SEND_MSG_URL = 'https://api.telegram.org/bot{token}/sendMessage?chat_id={chat_id}&text={msg}'

jmyoon4488

from tqdm import tqdm
import requests
import json

api_key = 'x'*40
header_data = {'Referer':'http://dart.fss.or.kr/dsap001/guide.do'}
start_date = '20090101'
end_date = '20190101'

def get_reports_list_by_code_from_dart(code, page_number) :