Difference between revisions of "Talk:Collins Foundation Final Report"
Jump to navigation
Jump to search
m |
|||
| Line 1: | Line 1: | ||
| − | + | '''this is the formula used for generating numbers relating to volunteers & their hours''' | |
| − | + | =="Build" volunteer count by year:== | |
| − | + | fgdb=# SELECT EXTRACT( YEAR FROM created), COUNT( DISTINCT memberid ) | |
| − | jobtype | + | FROM memberhour WHERE jobtype IN ('AdvancedTesting', 'Build', |
| − | + | 'Enterprise', 'Evaluation', 'Laptops', 'Quality', 'Repair', 'Sorting', | |
| − | + | 'Teaching') GROUP BY 1 ORDER BY 1; | |
| − | |||
| − | AdvancedTesting | ||
| − | Build | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | Enterprise | ||
| − | Evaluation | ||
| − | |||
| − | Laptops | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | Quality | ||
| − | |||
| − | |||
| − | Repair | ||
| − | |||
| − | Sorting | ||
| − | |||
| − | |||
| − | Teaching | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | ''' | + | =="Adoption" volunteer count by year:== |
| − | + | ||
| − | + | fgdb=# SELECT EXTRACT( YEAR FROM created), COUNT( DISTINCT memberid ) | |
| − | + | FROM memberhour WHERE jobtype IN ('DataEntry', 'FrontDesk', 'Misc', | |
| − | + | 'Printers', 'Receiving', 'Recycling', 'Testing', 'Adoption') GROUP BY 1 | |
| − | + | ORDER BY 1; | |
| − | + | ||
| − | + | ||
| − | |||
| − | |||
| − | |||
Revision as of 18:05, 25 January 2007
this is the formula used for generating numbers relating to volunteers & their hours
"Build" volunteer count by year:
fgdb=# SELECT EXTRACT( YEAR FROM created), COUNT( DISTINCT memberid ) FROM memberhour WHERE jobtype IN ('AdvancedTesting', 'Build', 'Enterprise', 'Evaluation', 'Laptops', 'Quality', 'Repair', 'Sorting', 'Teaching') GROUP BY 1 ORDER BY 1;
"Adoption" volunteer count by year:
fgdb=# SELECT EXTRACT( YEAR FROM created), COUNT( DISTINCT memberid ) FROM memberhour WHERE jobtype IN ('DataEntry', 'FrontDesk', 'Misc', 'Printers', 'Receiving', 'Recycling', 'Testing', 'Adoption') GROUP BY 1 ORDER BY 1;
should I include any recycling data? Is it really pertinent at all?
- Note: Teaching might be people teaching adoption classes. RfS 18:23, 24 January 2007 (PST)