(saveFormat "2.3")
(date "Thu 26/Feb/2004 21:16:12 ")
(veerev "6.03")
(platform "PC")
(execMode v6)
(prefExecMode v9)
(filterNAN 0)
(workspaceStackingOrder M)
(SaveCF no)
(device 0 ROOTCONTEXT
(automationRefs
(automationRef 1
(libid "{00020813-0000-0000-C000-000000000046}")
(desc "Microsoft Excel 8.0 Object Library")
(filename "D:\\APPS\\MICROSOFT\\OFFICE97\\OFFICE\\excel8.olb")
(verMajor 1)
(verMinor 2)
(lcid 0)))
(properties
(trigMode deg)
(nextID 29)
(popupTitleText "Untitled")
(popupMoveable 1)
(deleteGlobals 0))
(deviceList
(device 1 FORMULA
(properties
(name "Set up Excel Worksheet")
(expr 8 "set sheet = CreateObject(\"Excel.Sheet\").worksheets(1);"
"set app = sheet.application;" "app.visible = 1;" "set window = app.windows(1);"
"window.caption = \"Test System Results\";" "window.windowState = wndState;"
"memTotal = app.memoryTotal;" "memUsed = app.memoryUsed;"))
(interface
(input 1
(name "wndState")
(optional yes))
(output 1
(name "Result")
(tag "Result")
(lock name constraints)
(optional yes))
(output 2
(name "window")
(optional yes))
(output 3
(name "memUsed")
(optional yes))
(output 4
(name "memTotal")
(optional yes))))
(device 3 FORRANGE
(properties
(name "For 1 to 20 step 1")
(from 1)
(thru 20)
(step 1))
(interface
(output 1
(name "Data")
(lock name constraints))))
(device 4 FORMULA
(properties
(name "Fill in Cells")
(expr 1 "sheet.cells(A+1, 1) = random(1, 100)"))
(interface
(input 1
(name "A")
(optional yes))
(output 1
(name "Result")
(tag "Result")
(lock name constraints)
(optional yes))))
(device 7 FORMULA
(properties
(name "Close Excel")
(expr 1 "app.quit()"))
(interface
(output 1
(name "Result")
(tag "Result")
(lock name constraints)
(optional yes))))
(device 10 CONFIRM25
(properties
(name "Press to Kill EXCEL"))
(interface
(output 1
(name "Go")
(lock name constraints)))
(implementation))
(device 11 FORMULA
(properties
(name "Save Worksheet")
(expr 1 "sheet.SaveAs(filename)"))
(interface
(input 1
(name "filename")
(optional yes))
(output 1
(name "Result")
(tag "Result")
(lock name constraints)
(optional yes))))
(device 12 FILESELECT
(properties
(name "File Name Selection")
(prompt "Enter File Name:")
(initialDirectory "d:\\tmp")
(initialFile "veeToExcel.xls")
(dialogMode Writing))
(interface
(input 1
(name "Initial File")
(tag "Initial File")
(requires
(datatype Text)
(shape "Scalar"))
(lock constraints)
(optional yes)
(buffer YES))
(output 1
(name "File Name")
(lock name constraints))
(output 2
(name "Cancel")
(lock name constraints)))
(implementation))
(device 13 LITERALCONSTANT
(properties
(name "Initial Filename"))
(interface
(output 1
(name "Text")
(lock name constraints)))
(implementation
(value Text
(data  "veeToExcel.xls"))
(initValue Text
(data  ""))))
(device 14 ENUMCONSTANT
(properties
(name "Drop-Down List"))
(interface
(output 1
(name "Enum")
(lock name constraints))
(output 2
(name "Ordinal")
(lock name constraints)))
(implementation
(value Enum
(values
("xlMaximized" 0)
("xlMinimized" 1)
("xlNormal" 2))
(data  "xlMaximized"))
(initValue Text
(data  "xlMaximized"))))
(device 15 FORMULA
(properties
(expr 1 " -4137-(A*3)"))
(interface
(input 1
(name "A")
(optional yes))
(output 1
(name "Result")
(tag "Result")
(lock name constraints)
(optional yes))))
(device 16 FORMULA
(properties
(name "Fill in Title")
(expr 1 "sheet.cells(1, 1) = \"Voltage AC/RMS\""))
(interface
(output 1
(name "Result")
(tag "Result")
(lock name constraints)
(optional yes))))
(device 18 FORMULA
(properties
(expr 3 "set range = sheet.range(\"A2:A21\");"
"range.NumberFormat = \"$##,#00.00\";" "app.worksheetFunction.average(range);"))
(interface
(output 1
(name "Result")
(tag "Result")
(lock name constraints)
(optional yes))
(output 2
(name "range")
(optional yes))))
(device 19 TEXTDISPLAY
(properties
(name "Results Average"))
(interface
(input 1
(name "Data"))))
(device 21 METER
(properties
(name "Memory Used")
(range 0 1237176)
(redRange 0 742305.6)
(yellowRange 742305.6 1051599.6)
(greenRange 1051599.6 1237176))
(interface
(input 1
(name "Data")
(requires
(datatype Real64)
(shape "Scalar"))
(lock name constraints))
(input 2
(type control)
(name "Max Value")
(tag "Max Value")
(requires
(datatype Real64)
(shape "Scalar"))
(lock name constraints)
(optional yes))
(input 3
(type control)
(name "Min Value")
(tag "Min Value")
(requires
(datatype Real64)
(shape "Scalar"))
(lock name constraints)
(optional yes))
(input 4
(type control)
(name "Range 1 Max")
(tag "Range 1 Max")
(requires
(datatype Real64)
(shape "Scalar"))
(lock name constraints)
(optional yes))
(input 5
(type control)
(name "Range 2 Max")
(tag "Range 2 Max")
(requires
(datatype Real64)
(shape "Scalar"))
(lock name constraints)
(optional yes))
(input 6
(type control)
(name "Range 3 Max")
(tag "Range 3 Max")
(requires
(datatype Real64)
(shape "Scalar"))
(lock name constraints)
(optional yes))
(input 7
(type control)
(name "Range 2 Min")
(tag "Range 2 Min")
(requires
(datatype Real64)
(shape "Scalar"))
(lock name constraints)
(optional yes))
(input 8
(type control)
(name "Range 3 Min")
(tag "Range 3 Min")
(requires
(datatype Real64)
(shape "Scalar"))
(lock name constraints)
(optional yes))))
(device 22 CONSTANT
(properties
(name "0"))
(interface
(output 1
(name "Int32")
(lock name constraints)))
(implementation
(value Int32
(data  0))
(initValue Int32
(data  0))))
(device 23 FORMULA
(properties
(name "Calc ranges")
(expr 1 "range1 = .60*memTotal, range2 = .85*memTotal"))
(interface
(input 1
(name "memTotal")
(optional yes))
(output 1
(name "Result")
(tag "Result")
(lock name constraints)
(optional yes))
(output 2
(name "range1")
(optional yes))
(output 3
(name "range2")
(optional yes))))
(device 25 DECLVAR
(properties
(name "Declare sheet")
(scope glob)
(globalName "sheet"))
(implementation
(value Object
(data  "COM OFF Excel.Worksheet"))))
(device 26 DECLVAR
(properties
(name "Declare app")
(scope glob)
(globalName "app"))
(implementation
(value Object
(data  "COM OFF Excel.Application"))))
(device 28 NOTE
(properties
(name "Warranty Disclaimer")
(text2 4 "This example is provided as an illustration"
"\"as is\", and Agilent Technologies makes"
"no warranty of any kind with regard to this" "example.")))
(configuration
(connect D9:1 D0:1)
(connect D10:0 D1:0)
(connect D1:1 D2:1)
(connect D4:0 D3:0)
(connect D5:0 D4:0)
(connect D6:1 D5:1)
(connect D11:0 D6:0)
(connect D7:1 D6:1)
(connect D8:2 D9:1)
(connect D0:0 D10:0)
(connect D1:0 D11:0)
(connect D11:1 D12:1)
(connect D15:0 D13:0)
(connect D0:3 D13:1)
(connect D0:4 D13:2)
(connect D14:1 D13:3)
(connect D15:2 D13:4)
(connect D15:3 D13:5)
(connect D0:4 D13:6)
(connect D15:2 D13:7)
(connect D15:3 D13:8)
(connect D14:0 D15:0)
(connect D0:4 D15:1)))
(contextCarrier
(wndRestoredOrigin 2 2)
(wndRestoredExtent 556 410)
(wndState max)
(active detail)
(detail
(extent 1061 864)
(anchorPt 190 108)
(configuration
(devCarrierFor 1
(active open)
(icon
(extent 183 45))
(open
(extent 379 155))
(pinCenter 270 90))
(devCarrierFor 3
(active icon)
(icon
(extent 124 48)
(pictureMode scaled)
(iconImage "loop.icn"))
(open
(extent 160 82))
(pinCenter 270 320))
(devCarrierFor 4
(active open)
(icon
(extent 74 0))
(open
(extent 263 36))
(pinCenter 510 320))
(devCarrierFor 7
(active open)
(icon
(extent 80 0))
(open
(extent 103 36))
(terminals on)
(pinCenter 670 520))
(devCarrierFor 10
(active open)
(icon
(extent 134 0))
(open
(extent 169 36))
(title off)
(bg "White")
(fg "Black")
(pinCenter 480 510))
(devCarrierFor 11
(active open)
(icon
(extent 114 0))
(open
(extent 181 38))
(pinCenter 270 520))
(devCarrierFor 12
(active icon)
(icon
(extent 141 29))
(open
(extent 308 110))
(terminals on)
(pinCenter 90 530))
(devCarrierFor 13
(active icon)
(icon
(extent 109 19))
(open
(extent 139 30))
(pinCenter -50 530))
(devCarrierFor 14
(active open)
(icon)
(open
(extent 160 27)
(format dropDown))
(pinCenter -30 20))
(devCarrierFor 15
(active icon)
(icon
(extent 65 16))
(open
(extent 111 32))
(terminals on)
(pinCenter -20 90))
(devCarrierFor 16
(active open)
(icon
(extent 70 0))
(open
(extent 263 38))
(pinCenter 270 250))
(devCarrierFor 18
(active open)
(icon)
(open
(extent 354 70))
(pinCenter 270 410))
(devCarrierFor 19
(active open)
(icon
(extent 114 0))
(open
(extent 185 39)
(scFont "Lucida Sans" 18 italic))
(bg "White")
(pinCenter 600 410))
(devCarrierFor 21
(active open)
(icon
(extent 94 0))
(open
(extent 149 235)
(formatter
(realFormat standard)
(realSigDigits 4)
(realRadixSpec 1)
(integerBase decimal))
(layout vertical)
(extratics)
(labelSpacing 2)
(fastmode off)
(hicolor "Green")
(lowcolor "Warning Red"))
(bg "Gray")
(pinCenter 720 130))
(devCarrierFor 22
(active icon)
(icon
(extent 24 16))
(open
(extent 84 30)
(showFormat int))
(pinCenter 530 100))
(devCarrierFor 23
(active icon)
(icon
(extent 87 36))
(open
(extent 338 48))
(pinCenter 530 150))
(devCarrierFor 25
(active icon)
(icon
(extent 102 18))
(open
(extent 388 126))
(pinCenter -30 130))
(devCarrierFor 26
(active icon)
(icon
(extent 87 20))
(open
(extent 388 126))
(pinCenter -30 160))
(devCarrierFor 28
(active icon)
(icon
(extent 338 48)
(iconImage "disclaim.icn")
(label off))
(open
(extent 410 78)
(editing enabled))
(pinCenter 90 -60))
(connect D9:1 D0:1
(points 2 15 90 78 90))
(connect D10:0 D1:0
(points 2 270 271 270 293))
(connect D1:1 D2:1
(points 2 334 320 376 320))
(connect D4:0 D3:0
(points 6 480 530 480 550 580 550 580 460 680 460 680 481))
(connect D5:0 D4:0
(points 6 270 541 270 560 380 560 380 470 480 470 480 489))
(connect D6:1 D5:1
(points 2 163 520 177 520))
(connect D11:0 D6:0
(points 4 270 447 270 470 90 470 90 513))
(connect D7:1 D6:1
(points 2 7 530 17 530))
(connect D8:2 D9:1
(points 6 52 30 60 30 60 60 -70 60 -70 90 -55 90))
(connect D0:0 D10:0
(points 2 270 170 270 210))
(connect D1:0 D11:0
(points 2 270 346 270 354))
(connect D11:1 D12:1
(points 4 449 390 470 390 470 410 505 410))
(connect D15:0 D13:0
(points 8 530 170 530 240 620 240 620 270 820 270 820 -30 720 -30 720 -8))
(connect D0:3 D13:1
(points 4 462 110 480 110 480 20 643 20))
(connect D0:4 D13:2
(points 6 462 150 470 150 470 200 600 200 600 50 643 50))
(connect D14:1 D13:3
(points 4 544 100 560 100 560 80 643 80))
(connect D15:2 D13:4
(points 4 576 150 620 150 620 110 643 110))
(connect D15:3 D13:5
(points 4 576 160 610 160 610 140 643 140))
(connect D0:4 D13:6
(points 6 462 150 470 150 470 200 600 200 600 170 643 170))
(connect D15:2 D13:7
(points 4 576 150 620 150 620 200 643 200))
(connect D15:3 D13:8
(points 4 576 160 590 160 590 230 643 230))
(connect D14:0 D15:0
(points 2 530 110 530 129))
(connect D0:4 D15:1
(points 2 462 150 484 150)))
(stackingOrder 10 2 11 13 5 1 12 3 8 0 14 6 7 15 9 16 17 4 18))
(numberFormats
(realFormat standard)
(realSigDigits 4)
(realRadixSpec 4)
(integerBase decimal))))
