Difference between revisions of "Talk:Collins Foundation Final Report"

From FreekiWiki
Jump to navigation Jump to search
 
Line 1: Line 1:
include here the criteria used for pulling numbers out of database
+
* include here the criteria used for pulling numbers out of database
 +
 
 +
fgdb=# SELECT jobtype, count(*) FROM memberhour GROUP BY 1 ORDER BY 1;
 +
jobtype    | count
 +
-----------------+-------
 +
 
 +
Admin          |  1875
 +
Adoption        |  5191
 +
AdvancedTesting |  2428
 +
Build          | 10228
 +
Comp4Kids      |  125
 +
CREAM          |    19
 +
DataEntry      |  959
 +
Education      |  551
 +
Enterprise      |    24
 +
Evaluation      |  6997
 +
FrontDesk      |  126
 +
Laptops        |  231
 +
Misc            |  5473
 +
Orientation    |    33
 +
Outreach        |    43
 +
Printers        |    32
 +
Programming    |  228
 +
Quality        |  1397
 +
Receiving      |  6788
 +
Recycling      | 11093
 +
Repair          |  1033
 +
Sales          |  479
 +
Sorting        |  1813
 +
Support        |  277
 +
SysAdmin        |  115
 +
Teaching        |  1675
 +
Testing        |  4435
 +
(28 rows)
 +
 
 +
'''I will use the following in reference to adoption:
 +
  (with note that a certain overlap exists with build for MISC)'''
 +
*Adoption       
 +
*DataEntry   
 +
*FrontDesk 
 +
*Misc         
 +
*Printers   
 +
*Receiving   
 +
*Recycling   
 +
*Testing
 +
 
 +
'''I will use the following in reference to build:
 +
  (with note that a certain overlap exists with build for MISC)'''
 +
*AdvancedTesting
 +
*Build         
 +
*Enterprise   
 +
*Evaluation 
 +
*Laptops     
 +
*Misc       
 +
*Quality 
 +
*Repair     
 +
*Sorting     
 +
*Teaching     
 +
 
 +
 
 +
''should I include any recycling data?  Is it really pertinent at all?''

Revision as of 18:59, 24 January 2007

  • include here the criteria used for pulling numbers out of database

fgdb=# SELECT jobtype, count(*) FROM memberhour GROUP BY 1 ORDER BY 1; jobtype | count


+-------

Admin | 1875 Adoption | 5191 AdvancedTesting | 2428 Build | 10228 Comp4Kids | 125 CREAM | 19 DataEntry | 959 Education | 551 Enterprise | 24 Evaluation | 6997 FrontDesk | 126 Laptops | 231 Misc | 5473 Orientation | 33 Outreach | 43 Printers | 32 Programming | 228 Quality | 1397 Receiving | 6788 Recycling | 11093 Repair | 1033 Sales | 479 Sorting | 1813 Support | 277 SysAdmin | 115 Teaching | 1675 Testing | 4435 (28 rows)

I will use the following in reference to adoption:

  (with note that a certain overlap exists with build for MISC)
  • Adoption
  • DataEntry
  • FrontDesk
  • Misc
  • Printers
  • Receiving
  • Recycling
  • Testing

I will use the following in reference to build:

  (with note that a certain overlap exists with build for MISC)
  • AdvancedTesting
  • Build
  • Enterprise
  • Evaluation
  • Laptops
  • Misc
  • Quality
  • Repair
  • Sorting
  • Teaching


should I include any recycling data? Is it really pertinent at all?