Difference between revisions of "Talk:Collins Foundation Final Report"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
'''this is the formula used for generating numbers relating to volunteers & their hours''' | '''this is the formula used for generating numbers relating to volunteers & their hours''' | ||
Line 25: | Line 22: | ||
− | + | : Note: Teaching might be people teaching adoption classes. [[User:Rfs|RfS]] 18:23, 24 January 2007 (PST) | |
+ | |||
+ | ==Income/Expenses Calculations== | ||
+ | note: | ||
+ | all expenses = total expenses for year | ||
+ | |||
+ | 2004 | ||
+ | *Operational Income = total income - fundraisers - grants - online | ||
+ | *Overall Income = total income | ||
− | + | 2005 | |
+ | *Operational Income = total income - c4k donations - online donations - fundraisers - grants - untracked adjustments | ||
+ | *Overall Income = total income | ||
+ | |||
+ | 2006 | ||
+ | *Operational Income = total income - c4k donations - online donations - grants - unsolicited grants - employee matching | ||
+ | *Overall Income = total income |
Revision as of 19:21, 1 February 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;
Total hours by year:
fgdb=# SELECT EXTRACT( YEAR FROM created), SUM( hours ) FROM memberhour WHERE jobtype NOT IN ('Adoption') GROUP BY 1 ORDER BY 1;
- Note: Teaching might be people teaching adoption classes. RfS 18:23, 24 January 2007 (PST)
Income/Expenses Calculations
note: all expenses = total expenses for year
2004
- Operational Income = total income - fundraisers - grants - online
- Overall Income = total income
2005
- Operational Income = total income - c4k donations - online donations - fundraisers - grants - untracked adjustments
- Overall Income = total income
2006
- Operational Income = total income - c4k donations - online donations - grants - unsolicited grants - employee matching
- Overall Income = total income