GDM-8300 Series Excel Add-In Manual
Contents
1. 13 Vi Add In Sof V ion 21 OTUWAlE VCP SION INSTEK GDM 8300 Series Excel Add In Manual NTRODUCTION This manual 1s suitable for any of the GDM 8300 Series DMMs GDM 8341 8342 8351 This manual is to be used with all versions of Excel from 2003 and onwards with Windows PCs Windows XP Vista and 7 32 or 64 bit Windows 8 32 bit Please note that Macros must be enabled for the Add In to function The GDM 8300 Excel AddIn software is an Add In for Microsoft Excel The Add In allows you to log measurements from the DMM and to plot the resulting data as a graph or a histogram using the built in Excel graphing functions Overview oave Load Setup Run Logging About Icon Multimeter Settings Worksheet y oO GDM 8300 Series EB NIE d T lt Play Pause Connect to Setup Stop Multimeter Multimeter Connect to Multimeter Clicking this icon will allow you to establish a connection to the DMM Save Load Multimeter Settings Clicking this icon will let you save or load settings to from the multimeter Setup Multimeter Clicking this icon will allow you to choose the measurement function range and rate to use for the data logging Setup Run Logging Worksheet Clicking this icon will allow you to setup the data logging and graph2. the USB menu Unlike the GDM 8342 8341 the baud rate does not need to be set when the CDC interface is used GDM 8351 RS232 The RS232 connection is the easiest way to use the add in software with the GDM 8351 as drivers are required 1 Connection 1 2 Configure the DMM Connect the rear panel RS232 port on the DMM to a RS232 port on the PC using a RS232 crossover cable Press MENU Go to I O on level 1 Go to RS232 on level 2 Set the baud rate Press Enter to confirm the settings Press EXIT to exit from the RS232 menu GY Installation SETUP Up to three items need to be installed the USB driver not needed if using the RS232 interface the GDM 8300 Series Excel Addin Software and the NI VISA Run Time 1 Installing the 1 USB driver 2 Installing the 1 Excel Add In 3 Installing the 1 NI VISA Run Time Connect the DMM to the PC using the supplied USB TypeA to TypeB cable GTL 246 The Windows Found New Hardware Wizard will detect the DMM as a new device and ask for the device driver Choose to locate the driver manually Direct the Wizard to the USB DRIVER directory on the User Manual CD or download the USB driver from the GW Instek Website Follow the instructions on the Hardware Wizard to finish the installation On the User Manual CD go to the Excel Add in subdirectory under the Software directory and execute the Setup exe f
3. to resume e Press the Stop Icon to stop data logging prematurely e Fach time you use the data logging function a new sheet will be created for the data and for the histogram data if the Histogram option 15 enabled e Note that the other icons are now disabled until logging has finished or is stopped Play Stop GU cGDM 8300 Series mul 88 gt Pause 19 GY Chart Example Logged data GDM 8300 Series Excel Add In Manual Excel Add In icons Data statistics Bookl Microsoft Excel 00 Data Renen View add ins Acrobat Custom Toolbers Fi G fe 8 28 2014 5 29 23 Time Function DCV Start Time 2014 8 28 17 29 23 E 7 29 24 000 2 8372 00 Interval 00 00 01 000 29 25 000 2 1203 00 Stop Time 2014 8 28 17 29 43 0 3 2078E 00 gt 20 000 1 6737 00 20 000 2 4758 00 20 000 3 0336E 00 0 000 1 5438 00 Function DCV 000 2 7898E 00 panei X 2 000 2 0458 00 000 000 3 2390 00 0000 00 1 7605 00 2 5000E 00 2 2943 00 200006400 3 1412E 00 1 5000 00 1 5981E 00 7 29 38 2 6099 00 3 0000 00 Function 29 39 000 1 8878E 00 5 0000 01 7 29 40 000 3 2562E 00 0 0000E 00 29 41 000 1 8571 00 5556566545 29 42 000 2 1743 00 PF PFS 5 5 9 S 7 29 43 000 3 1954 00 Vo er o e uo M4 gt M Sheett Sheet Sheet3 Sheet01 01 2 Ready a j t Hist
4. DM8351 GDM510001 0 964 SCAN FINISH None Connected Search Disconnect Connect Close 10 Move on to Measurement Disconnect Press Disconnect to end the remote control session Cancel and Exit Press Close to exit from the Connection window without connecting or disconnecting 12 GY INSTEK DATA LOGGING REMOTE CONTROL Data LOGGING REMOTE CONTROL 1 Establish Follow the procedures for connection and remote configuration on page 5 and page 10 connection 2 Setup 1 Press the Setup Multimeter icon T The Set Up Multimeter window appears Choose measurement item Choose the measurement range Choose the measurement rate Yee 299 i Press OK to confirm the settings and exit automatically Set Up Multimeter Function DC Voltage Ra nge AUTO DC Current AC Voltage AC Current Rate Slow Resistance 2W Resistance 4W Capacitance Frequency Period TEMP TC 7 Press Exit to cancel and exit with making a setting 13 GY 3 Save Recall Load Settings 14 1 GDM 8300 Series Excel Add In Manual Press the Save Load Multimeter Settings icon Save Load Multimeter Settings panel appears Save Load Multimeter Settings Load Multimeter Settings from File C Save Multimeter Settings to File Choose to Load Multimeter Settings from File ot Save Multimeter Sett
5. Excel Add In GDM 8300 Series GDM 8300 Series Excel Add In Manual GW INSTEK PART NO ERE ISO 9001 CERTIFIED MANUFACTURER GW INSTEK This manual contains proprietary information which is protected by copyrights All rights are reserved No part of this manual may be photocopied reproduced or translated to another language without prior written consent of Good Will company The information in this manual was correct at the time of printing However Good Will continues to improve products and reserves the right to change specifications equipment and maintenance procedures at any time without notice Good Will Instrument Co Ltd No 7 1 Jhongsing Rd Tucheng Dist New Taipei City 236 Taiwan GW INSTEK Table of Contents ABLE OF CONTENTS IN RODUCTION S E 4 SE UI 5 esse RE T T T 5 E 7 U 8 e TET P E COPE ATION EET E E OO T 10 DATA LOGGING REMOT E CON ROL
6. art in the same Excel sheet or to plot the graph in a new Excel sheet e Separate Places charts in a new sheet each time logging is started e Same Sheet Places charts in the same sheet as the logging data 8 The Histogram option will open a new sheet and perform statistical analysis on the logged data in real time so that a histogram can be created The average median standard deviation as well as minimum and maximum values will also be calculated e This option will disable the graphing option mentioned above e The number of bins for the data and thus the interval 1s determined automatically by the software This can be changed after data logging has stopped Setup Run Logging Worksheet Logging Cha rt Chart Type c No Chard Graph Strip Chart Place Charts In Separate Same Sheet Histogram OK Cancel 9 Press the OK button to save the settings and exit 18 GY 5 Starting Data Logging 1 DATA LOGGING REMOTE CONTROL After the data logging setup has been completed the Play Pause and Stop icons will become available The icons are colored orange when they are available To start measurement press the Play icon Measurements will automatically start to be logged If the Chart or Histogram options were selected then they will also be plotted as the data is logged e Press the Pause icon to pause logging Press the Play icon again
7. e the 15 recognized in the Test and Measurement node 4 USB Test and Measurement Devices il USB Test and Measurement Device IVI From the Windows Start menu select Start gt Programs gt GWINSTEK DMM gt GDM 8300 Series gt GDM 8300 Excel Addin J GWINSTEK DMM GDM 8300 Series GDM 8300 Excel Addin Uninstall GDM 8300 GY SETUP Opening GDM 8300 Series Excel Addin will automatically open an Excel Spreadsheet If asked by Windows to enable Macros choose Enable Macros For Excel 2007 and up Go to the Add Ins tab in the Ribbon UI Book Microsoft Exce view View Aclcl Ins Acrobat P Wrap Text General For older versions such as Excel 2003 Go to the Tools menu and select the Add Ins option The Add In will be shown in a custom tool bar 1 0 Custom Toolbars Click on the Connect to Multimeter icon aA In the Connect window that appears click Search to scan for the DMM After the DMM has been detected click on your DMM in the Select Address window A number of devices may be returned If the model name and serial number of your device are not returned click the Search key again Press Connect 11 GW INSTEK GDM 8300 Series Excel Add In Manual 9 The Splash screen will close automatically after the connection is successful E Connect Select Address Type Setup Model amp S N 115200 N 8 1 GW Instek G
8. ement Device IVI and choose the Uninstall option gt System devices Universal Serial Bus controllers USB Test and Measurement Devices USB Test and Measurement Update Driver Softwar Disable Uninstall Qran far hardhia rc chi GY Uninstalling the Excel Add In SETUP 3 Select Delete the driver software for this device then press the OK button The driver will uninstall automatically Contirm Device Uninstall GDM Series CDC COM23 E Warning You are aboutto uninstall this device from your system 1 Ftom the Windows Start menu select the Start gt Programs gt GWINSTEK DMM gt GDM 8300 Series directory and choose Uninstall GDM 8300 GW Instek GWINSTEK DMM GDM 8300 Series GDM 8300 Excel Addin Uninstall GDM 8300 2 Select Yes to uninstall the product Windows Installer Are you sure you want to uninstall this product 3 The Uninstaller will automatically finish the uninstallation GY GDM 8300 Series Excel Add In Manual Configuration 1 Configure the PC 2 Configure the Add In 10 jm 1 To make sure the DMM is recognized by the PC open the Device Manager Start gt Control Panel gt System gt Device Manager For RS232 VCP CDC connections check which COM port the device is assigned to and make note of it aS Ports COM amp LPT For TMC connections check to make sur
9. ile If the Microsoft User Account Control Shield appears allow the setup file to be executed Follow the InstallShield Wizard to install the GDM 8300 Excel Addin The NI VISA Run Time must be installed to use the Excel Add in software This is available on the NI website ine 5 4 4231 en Please follow the instructions on the NI website for installation details GW INSTEK GDM 8300 Series Excel Add In Manual Uninstallation Follow the procedures described in this section when the Excel Add In or one of the USB drivers needs to be updated or removed Uninstalling the To update or remove the USB driver it must be USB driver uninstalled from the Windows Device Manager 1 Launch Device Manager from the Start menu Start gt Control Panel Device Manager XP Windows 7 Windows 8 32 bit 2 For VCP driver Double click Ports COM amp LPT Right click GDM83XX VCP PORT COMXX and choose the Uninstall option For CDC driver Double click Ports COM amp LPT Right click GDM Series CDC COMXX and choose the Uninstall option gt E PCMCIA adapters Ports COM amp LPT IU GDM Series COMS gt BD Processors Update Driver Software SD host adapters d Disable Security Devices UTE 2 l Uninstall 8 Sound video and game co System devices Eran fer harrhaara rhanna For TMC driver Double click Test and Measurement Devices Right click Test and Measur
10. ing functions for the software Play Pause Stop These control keys will allow you to start pause and stop data logging About The about icon will display the software version GY Setup Connection SETUP GDM 8341 GDM 8342 Before using the Excel Add In you must set the baud rate for the GDM 8342 8341 in the USB menu This configuration will be used when using the software to connect to the DMM remotely Note This Add In cannot be used with the GPIB option 1 Connection 1 2 Configure the DMM Connect the rear panel USB B port on the DMM to a USB port on the PC using a Type A to Type B USB cable Press MENU Go to I O on level 1 Go to USB on level 2 Set the baud rate to an applicable rate Press Enter to confirm the baud rate settings Press EXIT to exit from the USB menu GDM 8351 USB GDM 8300 Series Excel Add In Manual The GDM 8351 can connect to the software using either the USB CDC or the USB interface Functionally there is no difference in which interface is chosen to interface with the PC 1 Connection 1 2 Configure the DMM Note 2 3 4 5 6 1 Connect the rear panel USB B port on the DMM to a USB port on the PC using a Type to Type B USB cable Press MENU Go to I O on level 1 Go to USB on level 2 Set the interface to either CDC or TMC Press Enter to confirm the settings Press EXIT to exit from
11. ings to File If saving a file choose a directory and filename Click Save to save the file The file will be saved as XXNXX DMM After a few moments if the save was successful a message Saved OK will appear Click OK M GDM 8300 Saved OK If loading a file choose a previously saved setup and click Open message will appear if the setup has been loaded successfully Click OK E GDM 8300 Loaded OK The panel will close automatically after saving loading settings GY 4 Setup Data Logging DATA LOGGING REMOTE CONTROL Press the Record Setup Start icon This icon will only be available after a measurement has been selected with the Setup Multimeter icon page 13 Choose the Logging tab Set the logging start time in Begin Logging Data panel e Immediately Choose this option to begin logging measurements as soon as the Play icon is pressed see page 19 for details e At Time This option allows you to choose the exact time that the logging will start The start date hour minute and second can be chosen e On Receiving External Trigger This option will only start logging after the TRIG key is pressed on the DMM front panel GDM 8342 8341 or pin 5 on the Digital I O port is triggered GDM 8351 15 GW INSTEK GDM 8300 Series Excel Add In Manual 4 select the logging interval configure the With Interval optio
12. n This option can set how often the DMM will trigger down to the number hours minutes and seconds between each measurement 5 Use the Terminating Upon panel to set when to stop the data logging e Number of Readings Configures the logger to stop after a set amount of measurements e Duration Sets the logger to stop logging measurements after a set amount of time or number of readings r Setup Run Logging Worksheet Logging Chart Begin Logging Data Immediately C At Time 2014 08 28 14 bh 30 59 IE On Receiving External Trigger With Interval hh 0 m 1 Le Terminating Upon Number Of Readings 100 Duration hh m 55 16 GY INSTEK DATA LOGGING REMOTE CONTROL By default the measurements are not plotted Press the Chart tab to edit the chart behavior The Chart Type panel selects which type of graph if any to plot e No Chart This option will disable plotting a graph This is the default option Graph This will plot each point in a graph as soon as it is logged e Strip Chart This option creates a graph that allows you to view detailed sections of the graph using Excel Format controls e Number of Data Points This option allows you to specify the number of data points to graph This number cannot exceed 1000 17 GW INSTEK GDM 8300 Series Excel Add In Manual 7 Use the Place Charts In panel to draw the ch
13. ogram Example Logged data 20 Chart Excel Add In icons Data statistics Bookl Microsoft Excel Acrobat Frequency m Frequency Histogram DATA LOGGING REMOTE CONTROL View Add In Software Version 1 View software 1 vetsion Click on the About Icon to view the softwate version number About Icon GDM 8300 series tara The About Multimeter splash screen will appear displaying the software version number r About Multimeter GWINSTEK GDM 834X MultiMeter GDM 835X MultiMeter Version 1 00 Copyright c 2014 GWINSTEK 21 GW INSTEK GDM 8300 Series Excel Add In Manual 22
Download Pdf Manuals
Related Search