EDUC 6000 - Week 11

This week we were finally able to work on the spreadsheets that we've been putting off for various reasons.  For this project, we took 8 spreadsheets that were created to coincide with the 8 agency districts and created a master spreadsheet that contains all the information in the individual spreadsheets.  The individual spreadsheets track equipment that is kept in each district.  I worked on the individual spreadsheets in a previous week.  This week we wanted to link the spreadsheets to the master spreadsheet.  As a result, when the individual districts make changes on their spreadsheets, it will automatically update the master.  We actually found this process easier in an older version of Excel.  The 2010 version wouldn't allow some things that the older version would.  We don't think that will create an issue as the field staff is using the older version.  Anyway, the link works great.  We also protected the individual worksheets by linking them to the staff id of only the staff that should be allowed to make changes.  It was interesting to find that you can only do this in MS Office 2010.  The older version doesn't have that option, but it will still work on the older versions if it's created in the 2010 version and saved.  The worksheets are saved to a network drive, so everyone has access, but we don't want everyone to be able to make changes.   Finally, I created a pivot table for the master spreadsheet.  Yes, I finally figured it out!