timestream in timestream-0.0.3

- old
+ new
@@ -1,42 +1,8 @@
 #!/usr/bin/env ruby
 
 require 'rubygems'
-require 'spreadsheet'
+require 'timestream/employee_activity_report'
 
-# TODO Add selector for spreadsheets
-spreadsheet = Spreadsheet.open ARGV[0] 
-worksheet = spreadsheet.worksheet "EAR - Current Week"
+employee_activity_report = Timestream::EmployeeActivityReport.new ARGV[0]
 
-DATE_ROW = 2
-DATE_COLUMN = 1
-
-saturday_date = worksheet.row(DATE_ROW)[DATE_COLUMN]
-project_totals_by_day = Hash.new { |hash, day|
-  hash[day] = Hash.new(0)
-}
-
-DAY_COLUMN_SPAN = 3
-PROJECT_NUMBER_COLUMN = 0
-
-# 0-indexed - rows are for this week's time
-(12 .. 36).each do |row_index|
-  row = worksheet.row(row_index)
-  project_number = row[PROJECT_NUMBER_COLUMN]
-  
-  # TODO handle Vacation / Holiday / Sick time
-  # no project number assigned
-  next if project_number.nil?
-  
-  # 0 - Weekend
-  # 1 - Monday
-  # 2 - Tuesday...
-  (0 .. 5).each do |day_index|
-    day_column = 9 + DAY_COLUMN_SPAN * day_index
-    hours = row[day_column] || 0
-    
-    total_by_project = project_totals_by_day[day_index]
-    total_by_project[project_number] += hours 
-  end
-end
-
-puts project_totals_by_day.inspect
+puts employee_activity_report.to_text_table