2014年3月17日星期一
Excel VBA for select/paste data and create new Worksheet
Due to the large amount of data (~40,000 points in a 40 seconds measurement) obtained from experiment each time. It is essential to develop programs for selecting useful data for further analysis like plotting and calculation.
Excel VBA is used to achieve the requirements. Two programs were written, one is to copy different ranges of data in origin Worksheet and paste them to new Worksheets. The other program copies other ranges of data and paste them to the second columns of newly created Worksheets.
Excel VBA codes are shown below:
Source codes (.bas files) for two modules, click here to download.
Excel VBA is used to achieve the requirements. Two programs were written, one is to copy different ranges of data in origin Worksheet and paste them to new Worksheets. The other program copies other ranges of data and paste them to the second columns of newly created Worksheets.
Excel VBA codes are shown below:
 |
| Figure 1 copy, create new sheet and paste |
 |
| Figure 2 copy and paste to existing sheets |
2014年2月6日星期四
2ed Pulsed CV measurement, high-k material, Data
A negative feedback operational amplifier is used in today's pulsed CV measurement. This circuit has more accuracy than previous design.
Pictures below show some settings and waveforms on oscilloscope. Data recorded in the experiment can be found at last. Voltages used are 4V, 4.5V, 5V, 5.5V and 6V. The sample which is a high-k capacitor was broken after the first pulse under 6V.
Data recorded, please click here.
Pictures below show some settings and waveforms on oscilloscope. Data recorded in the experiment can be found at last. Voltages used are 4V, 4.5V, 5V, 5.5V and 6V. The sample which is a high-k capacitor was broken after the first pulse under 6V.
 |
| LabView Setting |
 |
| Fuction Generator |
 |
| 4 volt |
 |
| 4.5 volts |
 |
| 5 volts |
 |
| 5.5 volts |
 |
| 6 volts, sample broken |
Data recorded, please click here.
订阅：
博文 (Atom)