Here is how you can work with the Excel/SCOUT combination:
•Start Excel and load the file angles.xls.
•With Alt-F11 switch to the VisualBasic editor. Run the routine 'Create_server'
•Change to the main window of SCOUT which appears on the screen. With File|Open load the last configuration of example 3 of this tutorial.
•Change back to Excel and start the macro compute_data. This will fill the Excel table with angle-dependent reflectance spectra calculated by SCOUT.
The Excel file contains a page called 'Graph' which shows a 3D view of the computed data:
In Excel, it is quite easy to change the type of graph. You could also display the data in a 2D view: