Difference between revisions of "User:Rfs/Other Other Scratch Page"
< User:Rfs
Jump to navigation
Jump to search
Line 19: | Line 19: | ||
** these percentages can be applied to staffing costs as a start | ** these percentages can be applied to staffing costs as a start | ||
** you will need to add to them other costs (that are not staffing related) | ** you will need to add to them other costs (that are not staffing related) | ||
+ | |||
+ | {| class="wikitable sortable" | ||
+ | |+Sortable table | ||
+ | |- | ||
+ | ! Alphabetic !! Numeric !! Date !! class="unsortable" | Unsortable | ||
+ | |- | ||
+ | | d || 2 || 2008-11-24 || This | ||
+ | |- | ||
+ | | b || 8 || 2004-03-01 || column | ||
+ | |- | ||
+ | | a || 6 || 1979-07-23 || cannot | ||
+ | |- | ||
+ | | c || 4 || 1492-12-08 || be | ||
+ | |- | ||
+ | | e || 0 || 1601-08-13 || sorted. | ||
+ | |} |
Revision as of 06:55, 17 May 2009
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)
- SELECT work_shifts.kind, jobs.name, SUM(end_time - start_time) AS work_hours FROM work_shifts LEFT JOIN jobs ON work_shifts.job_id = jobs.id WHERE kind <> 'Unavailability' AND shift_date BETWEEN '###date1###' AND '###date2###' GROUP BY 1, 2 ORDER BY 1, 2;
- get a summary of all hours worked by worker in time frame (from skedujlnator) (B)
- SELECT workers.name, SUM(end_time - start_time) AS work_hours FROM work_shifts LEFT JOIN workers ON work_shifts.worker_id = workers.id WHERE kind <> 'Unavailability' AND name <> '0 nobody 0' AND shift_date BETWEEN '###date1###' AND '###date2###' GROUP BY 1 ORDER BY 1;
- 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 and second columns
- define programs and descriptions
- create a column for each program
- create a column for overhead/admin (non-program)
- for each row, define and record how each job (or person) breaks down into programs (and admin)
- check amounts by creating a total column for all program totals and a column that shows the difference between the program totals and the original and the second column
- correct any mistakes
- create a total row showing amount of time spent on each program
- if each person makes the same amount (or near enough) you can use the program totals to create a pie chart showing the breakdown by program
- these percentages can be applied to staffing costs as a start
- you will need to add to them other costs (that are not staffing related)
Alphabetic | Numeric | Date | Unsortable |
---|---|---|---|
d | 2 | 2008-11-24 | This |
b | 8 | 2004-03-01 | column |
a | 6 | 1979-07-23 | cannot |
c | 4 | 1492-12-08 | be |
e | 0 | 1601-08-13 | sorted. |