User:Rfs/Other Other Scratch Page

To estimate breakdown of hours spent on programs:


 * select time frame
 * get a summary of all hours worked by job in time frame (from skedujlnator) (A)
 * get a summary of all hours worked by worker in time frame (from skedujlnator) (B)
 * get actual hours reported by worker time frame (from staff worksheet in payroll) (C)
 * note difference by worker (essentially C - D). This is "flex" time (D)
 * put (A) and (D) in spreadsheet in first column
 * define programs and descriptions
 * create a column for each program
 * for each row, define and record