Staff myStaff;
		Work myWork;
		String fmt = "%-20s %10s";
		NumberFormat numC = NumberFormat.getCurrencyInstance();
		double workerSubtotal = 0, grandTotal=0;
		try
		{
			File sFile = new File("c:\\temp\\week6staff.csv");
			Scanner staffData = new Scanner(sFile);
			File wFile = new File("c:\\temp\\week6Work.csv");

			while (staffData.hasNextLine())
			{
				myStaff = new Staff(staffData.nextLine());
				System.out.println(String.format(fmt,
						myStaff.getName(),myStaff.getDept()));

				Scanner workData = new Scanner(wFile);
				while (workData.hasNext())
				{
					myWork = new Work(workData.nextLine());
					if (myStaff.getID().equals(myWork.getID()))
					{
						workerSubtotal = workerSubtotal+ myWork.showAmt();

					}
				}
				workData.close();

				System.out.println(String.format(fmt,
						"sub-total",numC.format(workerSubtotal)));
				System.out.println("");
				grandTotal = grandTotal + workerSubtotal;
				workerSubtotal = 0;

			}
			staffData.close();
			System.out.println(String.format(fmt,
					"grand-total",numC.format(grandTotal)));

		}
		catch (Exception ex)
		{
			System.out.println(ex.getMessage());
		}