(saveFormat "2.3")
(date "Wed 05/Dec/2001 08:44:11 ")
(veerev "6.0")
(platform "PC")
(execMode v6)
(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 53)
(popupTitleText "Untitled")
(popupMoveable 1)
(deleteGlobals 0))
(deviceList
(device 1 FORMULA
(properties
(name "Set up Excel Worksheet")
(expr 6 "set sheet = CreateObject(\"Excel.Sheet\").worksheets(1);"
"sheet.Application.Visible = TRUE;"
"sheet.Application.Windows(1).Caption = \"Test System Results\";"
"set range = sheet.Range(\"A2:A21\");" "set range = sheet.range(\"A2:A21\");"
"range.NumberFormat = \"0.000\";")))
(device 4 FORMULA
(properties
(name "Fill in Cells")
(expr 1 "range = transpose([A])"))
(interface
(input 1
(name "A")
(optional yes))))
(device 16 FORMULA
(properties
(name "Fill in Title")
(expr 1 "sheet.Range(\"A1:A1\") = \"DC Volts\""))
(interface
(output 1
(name "Result")
(tag "Result")
(lock name constraints)
(optional yes))))
(device 18 FORMULA
(properties
(name "Have Excel Calculate Std Deviation")
(expr 1 "sheet.Application.WorksheetFunction.StDev(range)"))
(interface
(output 1
(name "Result")
(tag "Result")
(lock name constraints)
(optional yes))))
(device 19 TEXTDISPLAY
(properties
(name "Standard Deviation"))
(interface
(input 1
(name "Data"))))
(device 39 FORMULA
(properties
(name "Array of Test Data")
(expr 1 "randomize(ramp(20), 4.5, 5.5)"))
(interface
(output 1
(name "Result")
(tag "Result")
(lock name constraints)
(optional yes))))
(device 41 DECLVAR
(properties
(name "Declare range")
(scope glob)
(globalName "range"))
(implementation
(value Object
(data  "ANY "))))
(device 44 DECLVAR
(properties
(name "Declare sheet")
(scope glob)
(globalName "sheet"))
(implementation
(value Object
(data  "ANY "))))
(device 46 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.")))
(device 48 FORMULA
(properties
(name "Close Excel App")
(expr 1 "sheet.Application.Quit()"))
(interface
(output 1
(name "Result")
(tag "Result")
(lock name constraints)
(optional yes))))
(device 49 MESSAGEBOX
(properties
(autoTimeout 1)
(popupTitle "VEE Example")
(message "Shutdown Excel ?")
(symbol Question))
(interface
(output 1
(name "Yes")
(lock name constraints))
(output 2
(name "No")
(lock name constraints))
(output 3
(name "Timeout")
(lock name constraints)))
(implementation
(customButtons 0)
(displayMode 0)
(buttons "Yes  No")
(buttonLabel1 "Yes")
(buttonLabel2 "No")
(buttonLabel3 "")
(bdefault "Yes")))
(device 50 BEEP
(properties
(frequency 1000)
(duration 0.1)
(volume 80))
(implementation))
(device 52 NOTE
(properties
(text2 6 "Requirements: Excel97" ""
"This example uses Excel97 and ActiveX Automation to insert an array "
"of random data into a spreadsheet in one operation.  It then uses "
"Excel\'s StDev function to calculate the standard deviation of "
"the data inserted into Excel.")))
(configuration
(connect D2:0 D1:0)
(connect D5:1 D1:1)
(connect D0:0 D2:0)
(connect D1:0 D3:0)
(connect D3:1 D4:1)
(connect D10:1 D9:0)
(connect D11:0 D10:0)
(connect D3:0 D11:0)))
(contextCarrier
(wndRestoredOrigin 2 2)
(wndRestoredExtent 911 562)
(wndState max)
(active detail)
(detail
(extent 1020 660)
(anchorPt 131 -117)
(configuration
(devCarrierFor 1
(active open)
(icon
(extent 165 0))
(open
(extent 373 109))
(pinCenter 270 20))
(devCarrierFor 4
(active open)
(icon
(extent 74 0))
(open
(extent 316 35))
(terminals on)
(pinCenter 270 230))
(devCarrierFor 16
(active open)
(icon
(extent 70 0))
(open
(extent 375 39))
(pinCenter 270 140))
(devCarrierFor 18
(active open)
(icon
(extent 209 0))
(open
(extent 375 35))
(pinCenter 270 320))
(devCarrierFor 19
(active open)
(icon
(extent 114 0))
(open
(extent 182 34)
(scFont "Lucida Sans" 18 italic))
(fg "Black")
(pinCenter 600 320))
(devCarrierFor 39
(active open)
(icon
(extent 135 16))
(open
(extent 185 32))
(pinCenter -30 230))
(devCarrierFor 41
(active icon)
(icon
(extent 112 17))
(open
(extent 421 126))
(pinCenter -30 0))
(devCarrierFor 44
(active icon)
(icon
(extent 104 15))
(open
(extent 388 126))
(pinCenter -30 -40))
(devCarrierFor 46
(active icon)
(icon
(extent 338 48)
(iconImage "disclaim.icn")
(label off))
(open
(extent 419 127)
(editing disabled))
(pinCenter 580 -130))
(devCarrierFor 48
(active open)
(icon
(extent 112 25))
(open
(extent 180 35))
(pinCenter 360 490))
(devCarrierFor 49
(active icon)
(icon
(extent 81 34))
(open
(extent 219 126))
(terminals on)
(pinCenter 270 420))
(devCarrierFor 50
(active icon)
(icon
(extent 33 15))
(open
(extent 162 79))
(pinCenter 270 370))
(devCarrierFor 52
(active open)
(icon
(iconImage "notepad.icn"))
(open
(extent 499 112)
(editing disabled))
(titleBg "Teal")
(pinCenter 130 -130))
(connect D2:0 D1:0
(points 2 270 162 270 192))
(connect D5:1 D1:1
(points 2 65 230 79 230))
(connect D0:0 D2:0
(points 2 270 77 270 100))
(connect D1:0 D3:0
(points 2 270 250 270 282))
(connect D3:1 D4:1
(points 2 460 320 506 320))
(connect D10:1 D9:0
(points 3 313 410 360 410 360 452))
(connect D11:0 D10:0
(points 2 270 380 270 400))
(connect D3:0 D11:0
(points 2 270 340 270 360)))
(stackingOrder 7 6 9 11 0 2 1 5 3 4 8 12 10))
(numberFormats
(realFormat standard)
(realSigDigits 4)
(realRadixSpec 4)
(integerBase decimal))))