<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="ko">
	<id>https://www.togotech.co.kr/index.php?action=history&amp;feed=atom&amp;title=VBA-fix-sim-01.txt</id>
	<title>VBA-fix-sim-01.txt - 편집 역사</title>
	<link rel="self" type="application/atom+xml" href="https://www.togotech.co.kr/index.php?action=history&amp;feed=atom&amp;title=VBA-fix-sim-01.txt"/>
	<link rel="alternate" type="text/html" href="https://www.togotech.co.kr/index.php?title=VBA-fix-sim-01.txt&amp;action=history"/>
	<updated>2026-04-26T15:53:31Z</updated>
	<subtitle>이 문서의 편집 역사</subtitle>
	<generator>MediaWiki 1.31.1</generator>
	<entry>
		<id>https://www.togotech.co.kr/index.php?title=VBA-fix-sim-01.txt&amp;diff=75918&amp;oldid=prev</id>
		<title>Togotech: 새 문서: 위로 E5071C VBA 프로그래밍  &lt;pre&gt; Private Sub UserForm_Click() Dim FmtData As Variant, Freq As Variant Dim BwData As Variant Dim SaveData(99, 800) Dim i, j, No As Integer...</title>
		<link rel="alternate" type="text/html" href="https://www.togotech.co.kr/index.php?title=VBA-fix-sim-01.txt&amp;diff=75918&amp;oldid=prev"/>
		<updated>2024-07-08T04:36:45Z</updated>

		<summary type="html">&lt;p&gt;새 문서: 위로 &lt;a href=&quot;/index.php/E5071C_VBA_%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%B0%8D&quot; title=&quot;E5071C VBA 프로그래밍&quot; data-bs-title=&quot;E5071C_VBA_프로그래밍&quot;&gt;E5071C VBA 프로그래밍&lt;/a&gt;  &amp;lt;pre&amp;gt; Private Sub UserForm_Click() Dim FmtData As Variant, Freq As Variant Dim BwData As Variant Dim SaveData(99, 800) Dim i, j, No As Integer...&lt;/p&gt;
&lt;p&gt;&lt;b&gt;새 문서&lt;/b&gt;&lt;/p&gt;&lt;div&gt;위로 [[E5071C VBA 프로그래밍]]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
Private Sub UserForm_Click()&lt;br /&gt;
Dim FmtData As Variant, Freq As Variant&lt;br /&gt;
Dim BwData As Variant&lt;br /&gt;
Dim SaveData(99, 800)&lt;br /&gt;
Dim i, j, No As Integer&lt;br /&gt;
&lt;br /&gt;
Dim Savefile, Calfile As String&lt;br /&gt;
Dim dmy As Long&lt;br /&gt;
Dim start, finish&lt;br /&gt;
&lt;br /&gt;
pico = 0.000000000001&lt;br /&gt;
nano = 0.000000001&lt;br /&gt;
micro = 0.000001&lt;br /&gt;
mega = 1000000#&lt;br /&gt;
giga = 1000000000#&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Savefile = &amp;quot;C:\Documents and Settings\All Users\Documents\2.txt&amp;quot;&lt;br /&gt;
Calfile = &amp;quot;D:\2PORT-500M-3G-TOGO.STA&amp;quot;&lt;br /&gt;
SCPI.MMEMory.Load.STATe = Calfile&lt;br /&gt;
mark1 = 1930 * mega&lt;br /&gt;
mark2 = 1960 * mega&lt;br /&gt;
mark3 = 1990 * mega&lt;br /&gt;
&lt;br /&gt;
SCPI.SENSe(1).FREQuency.CENTer = 1960 * mega&lt;br /&gt;
SCPI.SENSe(1).FREQuency.SPAN = 100 * mega&lt;br /&gt;
&lt;br /&gt;
SCPI.CALCulate(1).SELected.MARKer(1).X = mark1&lt;br /&gt;
SCPI.CALCulate(1).SELected.MARKer(3).X = mark3&lt;br /&gt;
SCPI.CALCulate(1).SELected.MARKer(2).X = mark2&lt;br /&gt;
&lt;br /&gt;
SCPI.CALCulate(1).PARameter(1).Count = 3&lt;br /&gt;
SCPI.DISPlay.WINDow(1).Split = &amp;quot;D12_33&amp;quot;&lt;br /&gt;
SCPI.DISPlay.WINDow(1).TRACe(3).Y.SCALe.PDIVision = 1&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Open Savefile For Output As #1&lt;br /&gt;
'Print #1, i, Peak, fc1, fc2, fc3, Bw1, Bw2, Bw3, Q, delta1, delta2, delta3, delta4&lt;br /&gt;
Print #1, &amp;quot;,No,C[pF],L[nH],Peak-amp,fc1,fc2,fc3,Bw1,Bw2,Bw3,Q3&amp;quot;&lt;br /&gt;
&lt;br /&gt;
SCPI.SENSe(1).SWEep.POINts = 801&lt;br /&gt;
Nop = SCPI.SENSe(1).SWEep.POINts&lt;br /&gt;
SCPI.DISPlay.ENABle = True&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
ECHO &amp;quot;Nop=&amp;quot;, Nop&lt;br /&gt;
ECHO &amp;quot;Measurement Cycle=100&amp;quot;&lt;br /&gt;
&lt;br /&gt;
SCPI.TRIGger.SEQuence.Source = &amp;quot;BUS&amp;quot;&lt;br /&gt;
&lt;br /&gt;
Freq = SCPI.SENSe(1).FREQuency.DATA&lt;br /&gt;
start = Timer&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
  'fixure simulator on&lt;br /&gt;
SCPI.CALCulate(1).FSIMulator.STATe = True&lt;br /&gt;
 'Port&lt;br /&gt;
SCPI.CALCulate(1).FSIMulator.SENDed.PMCircuit.STATe = True&lt;br /&gt;
 'NONE, SLPC, PCSL, PLSC, SCPL, PLPC, USER&lt;br /&gt;
 'SCPC, PCSC, SLPL, PLSL  v11.20&lt;br /&gt;
SCPI.CALCulate(1).FSIMulator.SENDed.PMCircuit.PORT(1).TYPE = &amp;quot;PCSL&amp;quot;&lt;br /&gt;
    &lt;br /&gt;
    &lt;br /&gt;
No = 0&lt;br /&gt;
For i = 1 To 21&lt;br /&gt;
    For j = 1 To 21&lt;br /&gt;
        No = No + 1&lt;br /&gt;
        C = (i - 1) * pico * 0.1&lt;br /&gt;
        L = (j - 1) * nano * 0.1 + nano&lt;br /&gt;
        SCPI.CALCulate(1).FSIMulator.SENDed.PMCircuit.PORT(1).PARameters.C = C&lt;br /&gt;
        SCPI.CALCulate(1).FSIMulator.SENDed.PMCircuit.PORT(1).PARameters.G = 0#&lt;br /&gt;
        SCPI.CALCulate(1).FSIMulator.SENDed.PMCircuit.PORT(1).PARameters.L = L&lt;br /&gt;
        SCPI.CALCulate(1).FSIMulator.SENDed.PMCircuit.PORT(1).PARameters.R = 0#&lt;br /&gt;
&lt;br /&gt;
        SCPI.TRIGger.SEQuence.SINGle&lt;br /&gt;
        dmy = SCPI.IEEE4882.OPC&lt;br /&gt;
        SCPI.CALCulate(1).PARameter(3).SELect&lt;br /&gt;
        SCPI.CALCulate(1).SELected.MARKer(4).STATe = True&lt;br /&gt;
    &lt;br /&gt;
        SCPI.CALCulate(1).SELected.MARKer(4).FUNCtion.TYPE = &amp;quot;MAX&amp;quot;&lt;br /&gt;
        SCPI.CALCulate(1).SELected.MARKer(4).FUNCtion.EXECute&lt;br /&gt;
    &lt;br /&gt;
        SCPI.CALCulate(1).SELected.MARKer(4).BWIDth.THReshold = -1&lt;br /&gt;
        SCPI.CALCulate(1).SELected.MARKer(4).BWIDth.STATe = True&lt;br /&gt;
        BwData = SCPI.CALCulate(1).SELected.MARKer(4).BWIDth.DATA&lt;br /&gt;
        Bw1 = BwData(0) / mega&lt;br /&gt;
        fc1 = BwData(1) / mega&lt;br /&gt;
    &lt;br /&gt;
        SCPI.CALCulate(1).SELected.MARKer(4).BWIDth.THReshold = -2&lt;br /&gt;
        BwData = SCPI.CALCulate(1).SELected.MARKer(4).BWIDth.DATA&lt;br /&gt;
        Bw2 = BwData(0) / mega&lt;br /&gt;
        fc2 = BwData(1) / mega&lt;br /&gt;
    &lt;br /&gt;
        SCPI.CALCulate(1).SELected.MARKer(1).BWIDth.THReshold = -3&lt;br /&gt;
        BwData = SCPI.CALCulate(1).SELected.MARKer(4).BWIDth.DATA&lt;br /&gt;
        Bw3 = BwData(0) / mega&lt;br /&gt;
        fc3 = BwData(1) / mega&lt;br /&gt;
        Q3 = BwData(2)&lt;br /&gt;
        Peak = BwData(3)&lt;br /&gt;
    &lt;br /&gt;
        SCPI.CALCulate(1).SELected.MARKer(4).BWIDth.STATe = False&lt;br /&gt;
        SCPI.CALCulate(1).PARameter(1).SELect&lt;br /&gt;
    &lt;br /&gt;
        ECHO No&lt;br /&gt;
        Print #1, No, C / pico, L / nano, Peak, fc1, fc2, fc3, Bw1, Bw2, Bw3, Q3, delta1, delta2, delta3, delta4&lt;br /&gt;
    Next j&lt;br /&gt;
Next i&lt;br /&gt;
    &lt;br /&gt;
    &lt;br /&gt;
&lt;br /&gt;
'For i = 0 To 99&lt;br /&gt;
'    SCPI.TRIGger.SEQuence.SINGle&lt;br /&gt;
'    dmy = SCPI.IEEE4882.OPC&lt;br /&gt;
'    FmtData = SCPI.CALCulate(1).SELected.DATA.FDATa&lt;br /&gt;
'    For j = 0 To Nop - 1&lt;br /&gt;
'        SaveData(i, j) = FmtData(2 * j)&lt;br /&gt;
'    Next j&lt;br /&gt;
'Next i&lt;br /&gt;
&lt;br /&gt;
'finish = Timer&lt;br /&gt;
'ECHO &amp;quot;Elapsed Time=&amp;quot;, finish - start&lt;br /&gt;
&lt;br /&gt;
'For j = 0 To Nop - 1&lt;br /&gt;
'    Print #1, j + 1, Freq(j);&lt;br /&gt;
'    For i = 0 To 99&lt;br /&gt;
'        Print #1, SaveData(i, j);&lt;br /&gt;
'    Next i&lt;br /&gt;
'    Print #1,&lt;br /&gt;
'Next j&lt;br /&gt;
Close #1&lt;br /&gt;
SCPI.DISPlay.ENABle = True&lt;br /&gt;
&lt;br /&gt;
MsgBox &amp;quot;Measurement Completion&amp;quot;&lt;br /&gt;
SCPI.SYSTem.BEEPer.COMPlete.IMMediate&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
End Sub&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Togotech</name></author>
		
	</entry>
</feed>