Giter Club home page Giter Club logo

testsequencer's Introduction

日本語 | English

about Test Sequencer

Test Sequencer is an open source software for easy control of measurment instruments. Communication commands can be written in an Excel file and sent and received by various communication interfaces. It is intended to be used as a jig program to check the communication with the measurement instruments.

Features

  • Works on Excel VBA and commucation library.
  • Communicates with measurment instruments via GP-IB, RS232, USB, or Ethernet.
  • Controls up to eithgt measurment instruments.
  • Japanese, English, Chinese and Korean text can be switched.
  • You do not need to install third party software. You can use it immediately after download.
    • If using GP-IB or USB, device drivers is needed.

Operating environment

Bolded are tested environments. For other environments, I would appreciate a report.

  • OS:Windows XP, Vista, 7, 10, 11
  • Excel:2010, 2013, 2016, 2019, 2021
    • Office for Mac and Microsoft 365 are not supported.
  • Note: if you want to run on 64-bit version of Excel. install Microsoft Visual C++ Redistributable Package for Visual Studio 2017
  • Note: If you use GP-IB communication, install NI-488.2.
  • Note: When using USB communication, install NI-VISA or [Yokogawa USB driver](https://tmi. yokogawa.com/jp/library/documents-downloads/software/usb-drivers/).

Target devices

  • Measurment instruments compliant with IEEE488.2-1987

Communication interface

  • GP-IB: Environment in which National Instruments GP-IB interface works.
  • RS232C: Environment in which serial port or virtual COM port operates.
  • Ethernet: Socket communication, VXI-11, or HiSLIP must work.
  • USB: Environment where National Instruments NI-VISA or Yokogawa Measurement USB driver works.

How to use

Download and Extract

After downloading the ZIP file, extract the 5 file (ExcelCommand.xlsm, tmctl.dll, tmctl64.dll, YKMUSB.dll and YKMUSB64.dll), and place these files in the same directory.

Open a book containing macros

By default Excel displays a security warning and disables macros when you try to open a book containing macros. To enable macros, follow these steps

  • In an Excel program, on the File tab, click Options.
  • Click Trust Center, and then click Trust Center Settings. The following screen is an example from
  • Click "Macro Settings".
  • Select "Enable VBA macros" from the "Macro Settings" list

Address string

<img src="docs/101e.png">

Instruction

<img src="docs/102e.png">

Example

<img src="docs/103e.png">

Copyright

Test Sequencer: An macro file to communicate some measurement insturuments.

Copyright (C) 2023 Takatoshi Yamaoka

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

testsequencer's People

Contributors

mitakamakers avatar

Stargazers

 avatar

Watchers

 avatar

testsequencer's Issues

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.