• Title/Summary/Keyword: 엑셀

Search Result 266, Processing Time 0.025 seconds

A study on Preparing General Ledger with Microsoft Excel 97 (마이크로소프트 엑셀 97을 이용한 총계정원장 작성에 관한 연구)

  • 이정록;박상욱
    • Journal of the Korea Society of Computer and Information
    • /
    • v.3 no.2
    • /
    • pp.239-246
    • /
    • 1998
  • As the complexity of organizations grow, the practice of accounting necessarily becomes more and more sophisticated. As a result, accounting is becoming increasingly dependent upon computers to facilitate the interaction of measurement analysis, and reporting that is so essential in business today. Enhancements in technology-in particular, the development of computer technology-have dramatically altered the practice of accounting. This study represents a new approach in technology-based education and contains how to use Microsoft Excel 97 In preparing general ledger.

  • PDF

Benchmarking of Design Optimization Frameworks In View of Excel Interface (엑셀 인터페이스 관점에서의 최적설계 프레임웍의 벤치마크)

  • Yum Keun-Chul;Lee Se Jung
    • Transactions of the Korean Society of Mechanical Engineers A
    • /
    • v.29 no.3 s.234
    • /
    • pp.403-410
    • /
    • 2005
  • This study presents the benchmark results of several design frameworks for the purpose of developing an efficient design framework in view of Excel interface. For the benchmark, three optimum design problems are chosen and solved by using the design frameworks. In order to compare the frameworks with each other, the evaluation criteria are specified and modified to fit the problems with Excel interface. Three example cases are solved and compared. The evaluation report is summarized in terms of efficiency, ease of use, internal structure, API, etc. However, the optimization result itself is not focused because the specific optimization algorithm is not our concern. Finally, some suggestions of how to develop an efficient design framework with Excel interface are presented.

Mathematical Conjectures and Discoveries in the Diffy Activity (디피 활동에서의 수학적 추측과 발견)

  • Kang, Moon-Hong
    • School Mathematics
    • /
    • v.7 no.4
    • /
    • pp.319-336
    • /
    • 2005
  • This study is to find the properties of Diffy activity and to investigate the problems and conjectures which could be posed in the Diffy activity. The Diffy is a simple subtracting activity. But, 1 think it is a field where the mathematical thinking can take place. I proposed some problems and conjectures which can be posed. I solved the problems using excel and the software I developed and proposed the related data. I think such problems and the data will be the good materials for elementary students and gifted to think mathematically with.

  • PDF

Mathematical Modelling of the H1N1 Influenza (신종 인플루엔자의 수학적 모델링)

  • Lee, Sang-Gu;Ko, Rae-Young;Lee, Jae-Hwa
    • Communications of Mathematical Education
    • /
    • v.24 no.4
    • /
    • pp.877-889
    • /
    • 2010
  • Mathematical modelling is a useful method for reinterpreting the real world and for solving real problems. In this paper, we introduced a theory on mathematical modelling. Further, we developed a mathematical model of the H1N1 influenza with Excel. Then, we analyzed the model which tells us what role it can play in an appropriate prediction of the future and in the decision of accompanied policies.

A Study on Accelerator Emergence and Accelerator Service Stage (엑셀러레이터의 출현과 엑셀러레이터 서비스 단계 연구)

  • Choi, Joong Bin
    • Journal of Information Technology Services
    • /
    • v.18 no.3
    • /
    • pp.129-141
    • /
    • 2019
  • Currently, there is a wave of second startup companies in Korea as well as within the global market, and the role of accelerators have become highly important at the center of changes. In the early 2000s, Y-Combinator has made Airbnb and Dropbox grow into a global company, and its start-up support model has begun to gain worldwide attention, and further became the beginning of the "accelerator" industry. The accelerator industry has been expanding rapidly throughout the United States, Britain and Israel, as well as China and Southeast Asia in recent years. As of the end of 2018, more than 130 accelerators have been operating in Korea, starting with Primer in 2010, and the scope of its activities has been expanding into specialty fields such as Pintech, bio industry, and Block chain, as well as Game. The purpose of this study is to study the role of the accelerator through the phenomenon of these accelerators and their step-by-step support services.

A study on Modular Efficiency of game database using Excel (엑셀을 이용한 게임데이터베이스의 모듈화 효율성에 대한 연구)

  • Kim, In;Park, Chan-il
    • Proceedings of the Korean Society of Computer Information Conference
    • /
    • 2021.07a
    • /
    • pp.573-574
    • /
    • 2021
  • 본 논문에서는 게임 개발의 효율성을 증대하기 위한 데이터베이스 툴을 제안한다. 이 데이터베이스 툴은 엑셀을 기반으로 데이터의 모듈화와 VBA를 통한 자동화를 진행하여 데이터베이스 입력을 간략화 한다. 또한 별도의 스프레드시트를 통한 백업, 불러오기와 csv추출을 통해 관리적인 측면에서도 효율성을 보이게 된다. 해당 작업을 통해 실제 개발 환경에서의 실용성과 이점을 파악함과 동시에 문제파악을 통한 개선안을 낼 수 있도록 하였다. 본 논문에서는 데이터베이스 툴 설계과정에서의 이점과 전반적인 툴의 효율성에 대해 게임 개발의 관점으로 연구가 진행되었다.

  • PDF

Data Input Method for Cultural Heritage Standard Management System Using Web-Based Validation (웹 기반의 유효성 검사를 적용한 문화유산표준관리시스템 자료입력 방법)

  • Kyu-Jun Yu;Jae-Woong Kim;Youn-Yeoul Lee;Yi-Geun Chae;Koo-Rack Park
    • Proceedings of the Korean Society of Computer Information Conference
    • /
    • 2023.07a
    • /
    • pp.99-100
    • /
    • 2023
  • 국립중앙박물관에서는 국공사립 박물관 및 미술관 등의 소장품을 체계적인 관리지원을 위하여 문화유산표준관리시스템을 개발 및 배포하고 있다. 문화유산표준관리시스템의 자료등록 방법은 크게 두가지로 나뉘고 있다. 첫 번째는 소장품등록의 웹페이지화면에서 할 수 있으며 두 번째는 엑셀양식을 통한 일괄등록이다. 본 논문에서는 엑셀양식을 통한 일괄등록의 경우에서 별도의 웹페이지를 작성하여 자료입력방식에서 생길 수 있는 인적오류를 최소화하는 방법을 제시한다.

  • PDF

Web-based Excel-DB Integration using Apache POI (아파치 POI를 이용한 웹기반 엑셀-DB연동 기법)

  • Lee, Sang-Min;Kim, Sang-Woo;Lee, Sang-Won
    • Proceedings of the Korea Information Processing Society Conference
    • /
    • 2008.05a
    • /
    • pp.208-210
    • /
    • 2008
  • 정형 정보를 저장하는 대표적인 수단인 Microsoft Excel과 Database 간 상호변환에 있어서 다양한 방법들 중 Web을 기반으로 하는 변환 기술은 활용도가 매우 높을 것이다. 특히 많은 자료가 엑셀로 관리되는 경우 데이터 중복의 문제가 발생하며 DB를 통한 통합관리는 사용자 편의성 측면에서 높은 필요성을 갖는다. 본 논문은 이런 문제를 해결하기 위한 방안으로 POI를 이용한 변환 기법을 소개한다.