레이블이 Written in English인 게시물을 표시합니다. 모든 게시물 표시
레이블이 Written in English인 게시물을 표시합니다. 모든 게시물 표시

2016년 2월 15일 월요일

(E)Adding custom Folding to Notepad++(User Defined Language)

1. I need to Fold codes
    - folding code and adding appropriate comment make Understanding Big Picture easy.
    - Well made function name, structure could enough but folding option is good option.
    - I select Batch language(simplest syntax)
2. that function is in Visual Studio as #pragma region#pragma endregion but other Editors don't have it.
3. in Notepad++ User can define Folding
   * that need 2 function
      - Comment Line Style (Comment Line Style)
      - Folding in Comment Style (Comment Folding Style)

Abstract - Notepad++ Code Folding
in Notepad++ to make Customized Folding, you should make User Defined Language.(if not please, let me know)

when batch, make Keyword, Operator, String, Comment etc.. and add Code Folding 

Sequence Notepad++ User Defined Language
1. decide what to make - batch
2. List to make
    1) Keyword 1, 2
    2) string
    3) Operator
    4) Comment
    5) String Variable
    6) Number
    7) Folding(Comment)
    8) start point of GOTO
    9) Function name - no method yet

3. Information
    1) Keyword 1, 2
        - Reference 1(below)
    2) String
        - 'string' ,  "string" 사용
    3) Operator
        -  / \ == !==! | @ * > >> < + - * =
    4) Comment
        - ::
    5) String Variables
        - %variable%, 혹은 %something
    6) Number
        - Default numbers
    7) Folding(in Comment)
        - comment :: has  { and } , it could  be foldded
    8) start point of GOTO
        - start with : 

4. Notepad++ Setting Screen
    1) Keyword 1, 2


    2) String

    3) Operator

    4) Comment

    5) String Variables

    6) Number

    7) Folding(in Comment)

5. Check Effectiveness by Code Folding
    5.1 Not Folded Code

before applying Fold

    5.2 Folded Code
after applying Fold, not Folded yet

after applying Fold, Folded


Reference 1
set if else exist errorlevel for in do break call copy chcp cd chdir choice cls country ctty date del erase dir echo exit goto loadfix loadhigh mkdir md move path pause prompt rename ren rmdir rd shift time type ver verify vol com con lpt nul defined not errorlevel cmdextversion BREAK CALL CD CHDIR CLS COPY DEL DIR DATE ECHO ELSE ERASE EXIT FOR GOTO IF MD MKDIR MOVE PATH PAUSE PROMPT RD REN RENAME RMDIR SET TYPE VER VERIFY VOL SHIFT TIME CHCP CHOICE break call cd chdir cls copy del dir date echo else erase exit for goto if md mkdir move path pause prompt rd ren rename rmdir set shift type ver verify vol time chcp choice

ASSOC COLOR ENDLOCAL FTYPE MKLINK POPD PUSHD SETLOCAL START TITLE ARP AT ATTRIB BCDEDIT CACLS CHKDSK CHKNTFS CIPHER CLIP CMD COMP COMPACT CONVERT DEBUG DISKCOMP DISKCOPY DISKPART DOSKEY DRIVERQUERY EXPAND FC FIND FINDSTR FORFILES FORMAT FSUTIL GPRESULT GRAFTABL HELP ICACLS IPCONFIG LABEL MAKECAB MODE MORE NET OPENFILES PING RECOVER REPLACE ROBOCOPY RUNDLL32 SCHTASKS SETX SHUTDOWN SORT SUBST SYSTEMINFO TASKKILL TASKLIST TIMEOUT TREE WHERE WMIC XCOPY assoc color endlocal ftype mklink popd pushd setlocal start title arp at attrib bcdedit cacls chkdsk chkntfs cipher clip cmd comp compact convert debug diskcomp diskcopy diskpart doskey driverquery expand fc find findstr forfiles format fsutil gpresult graftabl help icacls ipconfig label makecab mode more net openfiles ping recover replace robocopy rundll32 schtasks setx shutdown sort subst systeminfo taskkill tasklist timeout tree where wmic xcopy


2016년 2월 13일 토요일

(E) ASPICE Understanding - 2

ASPICE has an official Website: http://www.automotivespice.com/

Home
by consensus of the car manufacturers within the Automotive Special Interest Group (SIG), a joint special interest group of The Procurement Forum and The SPICE User Group.

The members of the Automotive Special Interest Group include AUDI AG, BMW Group, Daimler AG, Fiat Auto S.p.A., Ford Werke GmbH, Jaguar, Land Rover, Dr. Ing. h.c. F. Porsche AG, Volkswagen AG and Volvo Car Corporation.

The Automotive SPICE® Process Assessment Model will be used to perform conformant assessments of the software process capability of automotive suppliers in accordance with the requirements of ISO/IEC 15504-2: 2003 and is based on ISO/IEC 15504-5: 2006.


About
I think below words are good explanation why they start the ASPICE(in about - Introduction)
http://www.automotivespice.com/about/
"As project schedules get even shorter, the pressure on software development and target hardware costs get ever greater, and the potential recall and safety issues due to electronic systems malfunction becomes ever more calculable. With more than 85% of the functionality in the modern motor vehicle now controlled by software, both the motor vehicle manufacturer and the supplier need to take action to address these issues.

The motor vehicle manufacturers have started to take pro-active action to address the situation; by focussing on software capability of the supplier in the supplier evaluation process; making provision for contractual demands with respect to software quality: and in performing supplier software capability assessments both before and during contract performance. " 

Download
Download the latest version of the Automotive SPICE® Process Assessment Model (PAM) and Process Reference Model (PRM):
http://www.automotivespice.com/download/


Next I need to understand Abstract of the Document

2016년 2월 12일 금요일

(E)ASPICE Understanding - 1

ASPICE
is from SPICE
(Automotive) Software Process Improvement and Capability dEtermination.
originally
Software Process Improvement and Capability Evaluation.(do to meaning of 'Evaluation' in French)

1. So, I need to understand SPICE

---

SPICE is ISO/IEC 15504

ISO(International Organization for Standardization)
IEC(International Electronitechnical Commision)
ISO, IEC joint subcommittee

SPICE is Capability Maturity Model(consisting of capability levels which in turn consist of the process attribute and further consist of generic practice)


The first versions of the standard focused exclusively on software development processes

expanded to cover all related processes in a software business(project management, configuration management, quality assurance, and so on)
 - organizational, management, engineering, acquisition supply, support, and operations

The Technical Report (TR) document for ISO/IEC TR 15504 was divided into 9 parts.
The 7th part is currently in an advanced Final Draft Standard form[3] and work has started on part 8.

Parts Summary
Part 1 of ISO/IEC TR 15504 explains the concepts and gives an overview of the framework.
part 2 refers to external process lifecycle standards including ISO/IEC 12207 and ISO/IEC 15288.
Performing assessments is the subject of parts 2 and 3 of ISO/IEC 15504.[8]
Part 2 is the normative part and part 3 gives a guidance to fulfill the requirements in part 2.
The competency of assessors is the subject of part 3 of ISO/IEC 15504.
Process improvement is the subject of part 4 of ISO/IEC 15504.
ISO/IEC 15504 (Part 4) can also be used to inform supplier selection decisions.
Part 5 specifies software process assessment and part 6 specifies system process assessment.
The process assessment model (PAM) in part 5 is based on the process reference model (PRM) for software: ISO/IEC 12207.[12]
The process assessment model in part 6 is based on the process reference model for systems: ISO/IEC 15288.
The latest work in the ISO standards working group includes creation of a maturity model, which is planned to become ISO/IEC 15504 part 7
The International Standard (IS) version of ISO/IEC 15504 now comprises 6 parts. The 7th part is currently in an advanced Final Draft Standard form[3] and work has started on part 8.


Further reading
ISO/IEC 15504-1:2004 Information technology — Process assessment — Part 1: Concepts and vocabulary
ISO/IEC 15504-2:2003 Information technology — Process assessment — Part 2: Performing an assessment
ISO/IEC 15504-2:2003/Cor 1:2004
ISO/IEC 15504-3:2004 Information technology — Process assessment — Part 3: Guidance on performing an assessment
ISO/IEC 15504-4:2004 Information technology — Process assessment — Part 4: Guidance on use for process improvement and process capability determination
ISO/IEC 15504-5:2012 Information technology — Process Assessment — Part 5: An exemplar Process Assessment Model
ISO/IEC TR 15504-6:2013 Information technology — Process assessment — Part 6: An exemplar system life cycle process assessment model
ISO/IEC TR 15504-7:2008 Information technology — Process assessment — Part 7: Assessment of organizational maturity
ISO/IEC PDTR 15504-8 Information technology — Process assessment — Part 8: An exemplar process assessment model for IT service management
ISO/IEC TS 15504-9:2011 Information technology — Process assessment — Part 9: Target process profiles
ISO/IEC TS 15504-10:2011 Information technology — Process assessment — Part 10: Safety extension

External links
Automotive SPICE - http://www.automotivespice.com/


Reference
https://en.wikipedia.org/wiki/ISO/IEC_15504 - SPICE

2016년 2월 10일 수요일

(E+K)표가 있는 컴퓨터 메모, Computer Memo with tables

1. 메모에 표가 필요하다.
2. Windows 기본 메모에 표를 만들 수 있다.
3. 자동으로 생성하는 것이 아니라 엑셀에 적어서 붙여 넣으면 된다.

1. I needed memo with table
2. Windows Memo could have it.
3. Can not create table, but can use it with paste from Excel.


4. 메모는 항상 위에 떠있어야 편한데, 윈도우 메모에는해당 기능이 없어서,
5. 매크로(Auto Hot Key) 이용해서 해당기능 사용

4. Memo need to be always on, but windows memo couldn't do that.
5. With Macro(Auto Hot key) could do it.


2016년 1월 29일 금요일

(E, K)엑셀 유용한 기능들(실무에서 자주 사용중인 것), Excel efficientfeatures(frequently use ones in office)

엑셀 유용한 기능들(실무에서 자주 사용중인 것)
Excel efficient features(frequently use ones in office)

먼저 리스트를 만들어서 큰 그림을 본 다음
세부 예시를 만들어서 내용을 채워 나간다.

1.   Basic
A. Ctrl+1: 셀 서식 창을 부르고, 이 창에서 필요한 많은 걸 할 수 있다.
            This calls Cell Form window, do lots of things
B. Shift+Ctrl+방향키(Direction key): 선택 할 때 쓰며, Shift만 빼면 이동만 한다. 
                                           select region quickly, without shift move fast.

2.   Filter, Sort(필터, 정렬)
A. Alt+D+S, 여러 정렬 한번에 사용(sort multiple column condition)
B. Ctrl+Shift+L, 필터의 방법: 텍스트, 색(filter by text, color)

3.   Conditional Formatting

4.   Functions
A. Vlook up: 특정 값이 제공된 테이블 내에 있는지 확인(데이터는 수직으로)
                Specific value check in table in vertical order.
B. If: if 조건에 따라 결과를 선택하며, 작성자에 따라 다양하게 사용될 수 있다.
      Select result if or not condition, being used variously by person.
C. Sumifs, Countifs: 수학적 함수에 조건문을 붙여 필요한 것만 계산.
                         add condition at functions.
D. Indirect: 상대적 주소값 참조를 다른 행을 값으로 사용 가능
               Access cell indirectly with reference other cell value.
E.  Match, Index: table에서의 위치를 행, 열의 값의 변화에 따라 접근 가능
                     Access table value by row, column location change. 

5.   Pivot table
A. 각 칸의 의미와 바꿨을 때의 모양(Pivot options)
B. Chart
C. Grouping index

6.   Macro
A. Macro Recording: 엑셀의 실제 작업을 자동으로 저장하여 반복할 수 있도록 사용
                           Record real work in excel, and make short to do that. 
                         
B. VBA Edit in Macro edit page
             : Excel 의 동작을 컴퓨터 언어로 작성
               Programming excel work, with language VBA.
               Macro 도 VBA 로 작성되는 것인데 Macro 는 동작을 Excel 에서 변환해 주는 것으로 사람이 생각하는 것 만큼 동작해 주지 않는다(상대주소 참조 등)
               Macro's also made with VBA but is work not like human expectation.(like relative address)  


min, max if

2015년 10월 10일 토요일

(E)Simple but Core of Python Pandas.

Memo with simplest, and easiest youtube video.
Speaker is formal Google SW engineer, John Fries(He is OpenMail CTO now)


* Summary: Pandas is the most strong data analysis tool, so people should know this first at learning python.


* Abstract
   1. Distribution
   2. Data reading
   3. Data munging
   4. Graph(Chart) drawing


* Details
   1. Tools
      a. Anaconda
      b. Ipython Notebook when explaining
   2. Data Reading
      a. make DataFrame(2 dimension)(Series 1 dimenstion, Panel 3 dimension)
      b. read from csv (dataframe = read_csv(file address) <- simple)
   3. Data munging - manipulating data
      a. basic method
         i. select(indexing)
            1) .ix[]    - basic indexing(mostly, unless row is integer)
            2) .loc[]  - label based indexing, after ix
            3) .iloc[] - positional indexing, integer row based indexing
            4) .xs()   - multi index level selecting
            5) .iat[], at[] - no frequent use
         ii. filter
            1) specific column, specific condition
            2) boolean indexing(same length subset can be retrived)
      b. others
         i. update(update contents)
            1) .loc[]
         ii. insert(add contents)
            1) no recommend, but can be
     iii. map(Series), append(concatenate to dataframe)., join(add columns to different dataframe), group(grouping row or column), summarize agg(), sorting, clean na(dropna, fillna) drop duplicates, clean outliers, conform 잘 이해 안가지만 reindex 하거나 resample 하거나 등등, bin, rotate 멀티 인덱스 등 unstack 도 할 수 있다.(테이블로 바꾸어 버리는 것) unstack 두번하면 rotate 된다.

   4. Graph drawing - use matplotlib, after data munging use the data as a input.


*Add - 2016-01-17 Simplify Indexing
Different Choices for Indexing Selection by Label, Boolean Array single, array, slice of label and boolean indexing .loc - location Selection by Position single, array, slice of integer index and boolean indexing .iloc - integer location Advanced Indexing and Advanced Hierarchical. . Label ->(if not) Index Selection but if the label is integer, only Label Based Selection

Basics Wen Using [] lower level(Series-> scalar vlaue), Daraframe->Series, Panel->Dataframe