Next year I start working as an
analyst at an economic consulting firm who provides expert witness testimony in
court cases. One of the primary tasks of analysts at the firm is producing
graphs to be used as individual evidence exhibits to aid the expert witness.
Because they are to be used in court, and for standardization purposes, the
graphs all must conform to fairly strict visual standards regarding fonts, line
widths, custom footers, placement of legends and titles, and so forth. I have created a system to export data from a
statistical package and automatically create graphs that conform to the firm’s
visual standards. Additionally, analysts using my final workbook can use it to
automatically format graphs in other workbooks, so they don’t even need to
import the data into the workbook I have created. My project will allow me, and
other analysts who use it, to spend more time in exploratory data analysis and
less time formatting graphs.
Documentation: http://files.gove.net/shares/files/13w/nickj22/Nick_Jones_VBA_Final_Project_Write_Up.pdf
No comments:
Post a Comment