As you may know, Python is a popular high-level programming language, used by professional data analysts and novices alike. Pandas is a data analysis library, or set of tools that can be used inside of Python. The Pandas tools allow for quick and intuitive analysis of a dataset. Adding Python (and Pandas) to Microsoft Excel, Read More
Category Archives: Excel
WinDaq/XL and Graphics Acceleration Crashing WinDaq
It has come to our attention that a graphics setting in Microsoft Excel can cause our WinDaq data acquisition software to crash (freeze), and significantly slow down your PC when running the WinDaq/XL real-time bridging software. Fortunately, there’s a simple solution that involves disabling graphics acceleration. We’ll show you how! Disabling Hardware Graphics Acceleration in Read More
Stand-Alone Date/Time Stamps in Microsoft Excel
A critical component of data acquisition, date/time stamps allow you to determine the status of your device under test at a particular instant in time. How that date/time stamp is displayed, and the precision (to the nearest tenth or hundredth of a second) can be quite subjective. Some like to see the date first (mm/dd/yyyy), Read More
WinDaq/XL Real-time Bridging Software
Data Acquisition > Software > WinDaq > Add-ons WinDaq/XL is real-time bridging software that allows users to stream data from WinDaq data acquisition software or the WinDaq Waveform Browser, into a Microsoft Excel spreadsheet. Once there, users can take full advantage of Excels exceptional ability to perform calculations and chart data. Since it’s initial release Read More
Save a Segment of Data as a Second, Smaller File
Data Acquisition > Software > WinDaq The WinDaq Waveform Browser allows you to select a segment of data, and save it as a second, smaller file. Suppose you have a very large data file, recorded over several days, or even weeks. Now suppose that that file contains a significant event that transpired in a matter of Read More
Data Acquisition in Microsoft Excel—How to Import Recorded Data
Data Acquisition > Software > WinDaq > WinDaq/XL In our experience, Microsoft Excel is the most popular application for waveform analysis. Our customers ask about porting waveform data to Excel more so than all other applications combined. In response, DATAQ Instruments’ developed WinDaq/XL to allow users of WinDaq software (both recording and playback software) to Read More
Getting Started with WinDaq/XL
Data Acquisition > Software > WinDaq > WinDaq/XL Microsoft Excel is one of the most widely recognized and understood spreadsheet applications in the world. WinDaq/XL is an add-in for use with Microsoft Excel. WinDaq/XL allows users of WinDaq data acquisition software to import acquired data, in real time, directly into Microsoft Excel. Once imported, the Read More
Clutch Testing with Data Acquisition Products
Data Acquisition > Mixed Measurements Our customer, a manufacturer of clutches used in a variety of small and large vehicle applications, wanted to replace his aging test instrumentation. Consisting of a 20-year old Gould Mark 200 chart recorder and associated amplifiers, the old equipment was breaking down frequently, difficult to repair, and expensive to maintain Read More
ActiveX Controls for Data Acquisition Applications
Data Acquisition > Software > Active X This tutorial will show you how to use the activeX controls named XControls in Excel with WinDaq/XL. WinDaq/XL is DATAQ’s software add-on to WinDaq/Lite, /Pro, and /Pro+ that allows data acquired by these packages to be ported to a Microsoft Excel spreadsheet. Let’s say you need to measure Read More