Agilent Technologies E3640-90001 Example Program for Excel 97

Chapter 6 Application Programs

Example Program for Excel 97

129

Example Program for Excel 97

This section contains the example program written using Excel Macros (Visual

BasicÒ for Applications) to control your power supply. With Excel you can

take the value of a cell in a spread sheet, send it to the power supply, and then

record the response on the worksheet. The example on the following pages

characterizes a component across the terminals of the power supply. This

example reads 11 voltages from a worksheet, programs the power supply to

that voltage, and then reads the current. The value of current is recorded next

to the voltage on the spread sheet.

Example The following table shows the result of the example program starting on page

131 for characterizing a diode. (Agilent Part number: 1901-1214, Manufacturer

Part number: MUR160, MotorolaÒ Co.)

program result

Contents

Main Agilent Technologies E364xA Single Output DC Power Supplies The Front Panel at a Glance Front-Panel Menu/Key Reference Front-Panel Voltage and Current Limit Settings + Display Annunciators The Rear Panel at a Glance In This Book Page Page Page Page Appendix Service Information Page Page Page Quick Start Preliminary Checkout Output Checkout Voltage Output Checkout Current Output Checkout If the Power Supply Does Not Turn On Line Voltage Conversion Page Page To Rack Mount the Instrument Page Page Page General Information Safety Considerations Safety and EMC Requirements Options and Accessories Options Accessories Description Page Installation Initial Inspection Cooling and Location Output Connections Current Ratings Voltage Drops Load Consideration Remote Voltage Sensing Connections Page Multiple Loads Page Front-Panel Operation and Features Front-Panel Operation Overview Constant Voltage Operation Page Constant Current Operation Page Configuring the Remote Interface GPIB Configuration SAVED GPIB / 488 ADDR 05 RS-232 Configuration GPIB / 488 RS-232 9600 BAUD NONE 8 BITS SAVED Storing and Recalling Operating States STORE STATE Name STATE 1:p15v_test 2: STatE2 Page Programming Overvoltage Protection Setting the OVP Level and Enable the OVP Circuit LEVEL 22 22 2.0V (E3640A) OVP ON CHANGED Checking OVP Operation Clearing the Overvoltage Condition Page Page Disabling the Output Disconnecting the Output Using an External Relay System-Related Operations State Storage Self-Test Error Conditions Firmware Revision Query SCPI Language Version GPIB Interface Reference RS-232 Interface Reference RS-232 Configuration Overview RS-232 Data Frame Format Connection to a Computer or Terminal RS-232 Troubleshooting Calibration Overview Calibration Security e3640A To Unsecure for Calibration SECURED 000000 UNSECURED To Secure Against Calibration UNSECURED secured 000000 Calibration Count Calibration Message Page Remote Interface Reference SCPI SCPI Command Summary SCPI SCPI Command Summary (see page 78 for more information) 70 Output Setting and Measurement Commands (see page 82 for more information) (see page 85 for more information) (see page 101 for more information) (see page 89 for more information) (see page 92 for more information) (see page 88 for more information) (see page 112 for more information) Simplified Programming Overview Using the APPLy Command Using the Low-Level Commands Reading a Query Response Selecting a Trigger Source Simplified Programming Overview 76 Power Supply Programming Ranges Table 4-2. Agilent E3641A/43A/45A Programming Ranges Using the APPLy Command Output Setting and Operation Commands Page Page Page Triggering Trigger Source Choices Page Triggering Commands System-Related Commands Page Page State Storage Commands Calibration Commands Page Page Interface Configuration Commands The SCPI Status Registers What is an Event Register? What is an Enable Register? The SCPI Status Registers 94 SCPI Status System The Questionable Status Register The Standard Event Register The Status Byte Register Using Service Request (SRQ) and Serial POLL Using *STB? to Read the Status Byte Using the Message Available Bit (MAV) To Interrupt Your Bus Controller Using SRQ To Determine When a Command Sequence is Completed Using *OPC to Signal When Data is in the Output Buffer Status Reporting Commands Page An Introduction to the SCPI Language Command Format Used in This Manual Command Separators Using the MIN and MAX Parameters Querying Parameter Settings SCPI Command Terminators IEEE-488.2 Common Commands SCPI Parameter Types Halting an Output in Progress SCPI Conformance Information SCPI Conformance Information 110 SCPI Confirmed Commands (continued) Page IEEE-488 Conformance Information Page Error Messages Execution Errors Page Page Page Page Self-Test Errors Calibration Errors Page Page Application Programs Example Program for C and C++ Example Program for C and C++ 126 Example Program for C and C++ 127 Page Example Program for Excel 97 Page 131 Diode Macro 132 End of Program 133 Declaration for Windows 3.1 Declaration for Windows 95/NT 4.0 Page Page Tutorial Overview of this Power Supply Operation Page Output Characteristics Page Unregulated State Unwanted Signals Page Extending the Voltage and Current Range Series Connections Parallel Connections Remote Programming Page Page Page Page Chapter 8 Specifications Performance Specifications 149 8 Performance Specifications calibration at 25 C. Table 8-1 Performance Specifications Page Supplemental Characteristics Page Page Page Page Service Information Operating Checklist Is the Power Supply Inoperative? Does the Power Supply Fail Self-Test? Types of Service Available Standard Repair Service (worldwide) Express Exchange (U.S.A. only) Repacking for Shipment Electrostatic Discharge (ESD) Precautions Surface Mount Repair To Replace the Power-Line Fuse Troubleshooting Hints Unit Reports Errors 740 to 750 Unit Fails Self-Test Bias Supplies Problems Self-Test Procedures Power-On Self-Test Complete Self-Test Page Page Recommended Test Equipment Test Considerations Operation Verification and Performance Tests Measurement Techniques Setup for Most Tests Current-Monitoring Resistor General Measurement Techniques Electronic Load Programming Constant Voltage (CV) Verifications Constant Voltage Test Setup Voltage Programming and Readback Accuracy CV Load Effect (Load Regulation) CV Source effect (Line Regulation) CV PARD (Ripple and Noise) Page Load Transient Response Time Constant Current (CC) Verifications Constant Current Test Setup Current Programming and Readback Accuracy CC Load Effect (Load Regulation) CC Source Effect (Line Regulation) CC PARD (Ripple and Noise) Common Mode Current Noise Performance Test Record for Your Power Supply 179 Performance Test Record for Your Power Supply CV Performance Test Record Performance Test Record for Your Power Supply 180 CC Performance Test Record Calibration Reference Agilent Technologies Calibration Services Calibration Interval To Unsecure the Power Supply Without the Security Code General Calibration/Adjustment Procedure Front Panel Voltage and Current Calibration CAL MODE voltage cal V LO 0.2 22 2000 V LO 0.4500 Page Page Page Calibration Record for Your Power Supply 187 Calibration Record for Your Power Supply Calibration Error Messages Replaceable Parts To Order Replaceable Parts Schematics and Diagrams Replaceable Parts 190 E3640A/41A/42A/43A/44A/45A Power Supply Assembly code Reference Designator Agilent Part Number Qty Part Description Mfr. Mfr. Part Number Manufacturers List Page Page Page Page Page Page Page Page Page Page Page Page Page Front Inside for E3640A (2 of 2) Warranty Statement (English Manual) ! DECLARATION OF CONFORMITY according to ISO/IEC Guide 22 and EN 45014