Multiple Worksheets and Workbooks
This problem is inspired by an actual task I have recently worked on.
	Problem Description: In this problem you are working for a business that is interested in identifying and tracking their power useage. They would like to be able to identify where they are using lots of electricity and then have a way to graphically compare their efforts in subsequent periods to reduce their electrical usage. Problem Instructions: There is a partially completed Excel file in the class folder. In this file one of the 12 source files is completed from the input tab all the way to the graphs on the last tab. Use the Excel file as a guide to connect the other 11 source files. There are also 12 data files in the class folder on the Maggini Server Download the 12 files, import them into excel and make them a part of the spreadsheet mentioned above. Each of the import files should end up as a tab on the first excel workbook. Complete all the data on the Totals Tab Create a series of charts that allow you to compare electrical consumption by meter and by year. There is a plot started on the last tab of the workbook.
Submit your completed spreadsheet as an attachment in an email Use "Lab Assignment 7 " for the Subject line and remember to identify yourself by name and class in the email body.
Return to Assignments Index