This exercise shows how to use the Excel. macro command family to take data from an Excel spreadsheet, reduce the data in EES, and finally return the results of the calculations to the Excel spreadsheet.
The EES file solution and data spreadsheet are at:
https://fchartsoftware.com//assets/downloads/eesfiles/usingmacroscourseexercise3.zip
00:00 Using Macros Exercise 3
02:00 Solution
02:45 Calculations in EES
08:45 Reduce a single data point
14:00 Reduce all of the data
