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