added some much needed verification on the macro fields now I just need to figure out how to get the piechart to update correctly