• Title/Summary/Keyword: VBA

Search Result 128, Processing Time 0.026 seconds

Development of auto calibration program for instruments by Excel VBA (VBA를 이용한 계측기기 자동 교정용 프로그램 개발)

  • Cho, Hyeon-Seob;Park, Jong-Chun;Lee, Keun-Wang;Oh, Hun
    • Proceedings of the KIEE Conference
    • /
    • 2004.07d
    • /
    • pp.2480-2483
    • /
    • 2004
  • 본 논문에서는 컴퓨터로 정밀 계측기기들을 자동 제어하고 데이터를 측정하기 위하여 기존의 상용 프로그램을 사용하지 않고 Excel VBA(Visual Basic for Applications)를 이용하는 방법에 대하여 연구하였다. 이는 반복측정 및 통계적 수치계산 등에서 많은 장점을 지니고 있어 수많은 국가교정기관 및 일반 산업체에서 유용하게 사용될 수 있으리라 사료된다.

  • PDF

Development of auto calibration program for instruments by Excel VBA (Excel VBA를 이용한 계측기기 자동 교정용 프로그램 개발)

  • 조현섭;송용화;이흥원;윤종민
    • Proceedings of the KAIS Fall Conference
    • /
    • 2003.06a
    • /
    • pp.203-207
    • /
    • 2003
  • 본 논문에서는 컴퓨터로 정밀 계측기 기들을 자동 제어하고 데이터? 측정하기 위하여 기존의 상용 프로그램을 사용하지 않고 Extol VBA(Visual Basic for Applications)를 이용하는 방법에 대하여 연구하였다. 이는 반복측정 및 통계적 수치계산 둥에서 많은 장점을 지니고 있어 수많은 국가교정기관 및 일반 산업체에서 유용하게 사용될 수 있으리라 사료된다.

  • PDF

Development of Auto Calibration Program for Instruments by Excel Vba (Excel VBA를 이용한 계측기기 자동 교정용 프로그램 개발)

  • 조현섭;김희숙
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.5 no.1
    • /
    • pp.29-33
    • /
    • 2004
  • In this paper, I'm tying to define the connection of the Device Characteristics and the Error Terms, and yield maximum estimated value of the mismatching errors by modeling the individual devices with signal-flow graph, and by seeking the transfer function of the system with the mismatching error in the combination of the devices using the Signal-flow Graph Gain Formula.

  • PDF

A Case Study for application of WMS which is made of Excel VBA for SMB logistics companies (Excel VBA를 활용한 중소 물류기업 창고 관리 시스템 적용 사례 연구)

  • Kim, Jung-Hyun;Lee, Seog-Hyeon;Jung, Jae-Jung;Kwon, Young-Jin;Lee, Kye-Chung;Hwang, Dae-Sung
    • Journal of the Korea Safety Management & Science
    • /
    • v.14 no.2
    • /
    • pp.167-176
    • /
    • 2012
  • This research studies the present status of utilization of IT in SMB, Small & Medium Business, logistics companies, and analyzes the examples of utilizing Excel VBA for building and operating IT system in SMB logistics companies. Through the study, this research suggests main issues of building and operating logistic systems and the effective way of utilizing the systems in SMB logistics companies.

A Case Study for application of WMS which is made of Excel VBA for SMB logistics companies (Excel VBA를 활용한 중소 물류기업 창고 관리 시스템 적용 사례 연구)

  • Kim, Jeong-Hyeon;Lee, Seok-Hyeon;Jeong, Jae-Jeong;Lee, Gye-Jeong;Seong, Haeng-Gi;Gwon, Yeong-Jin
    • Proceedings of the Safety Management and Science Conference
    • /
    • 2011.11a
    • /
    • pp.181-189
    • /
    • 2011
  • This research studies the present status of utilization of IT in SMB, Small & Medium Business, logistics companies, and analyzes the examples of utilizing Excel VBA for building and operating IT system in SMB logistics companies. Through this study, this research suggests main issues of building and operating logistic systems and the effective way of utilizing the systems in SMB logistics companies.

  • PDF

Application of Hepatocyte Specific Polymers with Functional group (기능성 고분자의 세포특이성 재료로의 이용에 관한 연구)

  • Lee, Jung Bock;Kim, Jae Woong
    • Analytical Science and Technology
    • /
    • v.9 no.1
    • /
    • pp.84-90
    • /
    • 1996
  • New hepatocyte specific copolymers, that have oligosaccharide and biotin residue on the side chain of styrene, were designed and synthesized to use as a multifunctional recognition. In order to measure initial adhesion efficiency, 1mL of copolymer solutions (0.01%, w/v) such as p(VLA-co-VBA) 90 : 10, p(VLA-co-VBA) 80 : 10 and PYLA as a standard were added to polystyrene petri dish, respectively. In the absence and presence of serum, hepatocyte solution of rat by method of Seglen was added. After 60 min, adhesion efficiency was 70%, that is similar to those of the absence of serum. Aggregation capacity between biotin residue in p(VLA-co-VBA) 70 : 30 and avidin was measured by using UV-transmittance.

  • PDF

The Teaching of Statistics using Excel VBA

  • Choi, Hyun-Seok
    • 한국데이터정보과학회:학술대회논문집
    • /
    • 2006.04a
    • /
    • pp.155-161
    • /
    • 2006
  • To enhance the interest and comprehension of learners studying Statistics. The program which learners can use is needed. With the help of this program, the interest and concentration of the learners can be enhanced, and the effects of the study of Statistics can be maximized, through the convenience of calculation to the theoretical contents of Statistics, various graphs, the, simulation.

  • PDF

SAP R/3 System Interface Technologies Analysis and VBA Applied Data Input Proposal (SAP R/3 시스템 인터페이스 기술분석과 VBA 활용 데이터 입력 제안)

  • Kim, Yeong Real;Kang, Tae Gu;Lee, Eun Beom
    • Journal of Korea Society of Industrial Information Systems
    • /
    • v.21 no.2
    • /
    • pp.93-105
    • /
    • 2016
  • Many companies have attempted to strengthen competitiveness by introducing information technology ERP system in a changing and global competitive business environment. However, ERP systems can not meet all the requirements that occur in the enterprise. After the system introduced, When it operates with existing systems or with new systems, the need for strong interface technology along with the appearance of the ERP have been gradually increased. In this paper, we selected SAP R/3 system as a typical ERP system. Among the modules of SAP R/3, MM module was chosen. Interface technologies for SAP R/3 Systems integrate mulltiple R/3 systems and non R/3 systems, and play important roles in expanding the company's business process. VBA approach was implemented as the data interface design between SAP R/3 and other systems. It proved to reduce the feeling of resistance from user's point of view. It also proved to improve the operational efficiency in a convenient input and output manner of purchase request data.

Development of auto calibration program for instruments by Excel VBA (정밀 계측기기 자동 교정을 위한 Excel VBA 프로그램 개발)

  • Cho, Hyun-Seob;Ryu, In-Ho;Jang, Sung-Whan;Rheu, Ki-Soo
    • Proceedings of the KIEE Conference
    • /
    • 2006.07d
    • /
    • pp.1947-1948
    • /
    • 2006
  • 본 논문에서는 컴퓨터로 정밀 계측기기들을 자동 제어하고 데이터를 측정하기 위하여 기존의 상용 프로그램을 사용하지 않고 Excel VBA(Visual Basic for Applications)를 이용하는 방법에 대하여 연구하였다. 이는 반복측정 및 통계적 수치계산 등에서 많은 장점을 지니고 있어 수많은 국가교정기관 및 일반 산업체에서 유용하게 사용될 수 있으리라 사료된다.

  • PDF