Project Description Winning Proposal Conclusion ||| Using my data
| Like everyone else, I have practical goals, like paying the rent. So I registered my professional self,
Dr. Claudia Krenz, at guru.com as ID #467830 (datafriend @ gmail-.-com).
I knew I needed to stay organized to make system guru work for me--my goal being to make money, not submit proposals for the joy of writing--and, being the trained methodologist I am, I knew that meant collecting data (keeping my browser windows organized was simple, because icab is my browser). I posted a small project on 08092004 (one line of PERL).
|
|
Below is my input file sonofgurusubmits: created as described above, by copy/pasting from my browser window after it read my raw .html submits file. I truncated it after 3 examples just for simplicity. title:suicide preventon -inv; when closed: awards,applicants; when applied: 0awards,8applicants;20days of 30days left; budget:ns; location:india( ir);rated:n; DATE: August 13, 2004 TO: Project ID #4795321 FROM: #467830 Note that the admin data between title: and TO: varies but the structure's the same. cloud% wc sonofgurusubmits |
This is what I want my output file to look like, the admin data stripped from the input file to your left. I realize I could delete my proposal text by hand but who wants the hassle. title:suicide preventon -inv; when closed: awards, applicants; when applied:0awards,8applicants;20days of 30days left; budget:ns;location:india ( ir);rated:n; DATE:August 13, 2004 TO:Project ID #4795321 title:seo copy writer; when closed: awards, applicants; when applied:0awards,3applicants;4days of 7days left; budget:lt250;location:CA(ir);rated:y; DATE:August 10, 2004 TO:Project ID #465432 title:grant writer;when closed: awards, applicants; when applied:0awards,15applicants;5days of 40days left; budget:5k;location:ND(r but project_qb later said ir);rated:n; DATE:August 5, 2004 TO:Project ID #123456
but wait! there's more (!!): What good are data without being able to create more variables? When a project shows up as closed in my Project Tracker window, I lst copy the project ID from the screen, 2nd do a find on it in my word-processed file gurusubmits.html, open up the Project Description window in my browser and then paste--into my raw .html file--- the total # of applicants when the project closed and whether or not it was awarded. I typed a "Q" into file, just before "when closed:".
|
QNwhen closed: 0awards, 9applicants; QYwhen closed: 0awards, 15applicants; QNwhen closed: 1awards, 17applicants;
--
I'd never heard of it but, since someone had proposed a GAWK solution, I
went to google to find it for downloading. Here's what my semblance of a
shell says:
*cloud% perl -v This is perl, v5.6.0 built for darwin *cloud% awk Usage: awk [-f programfile | 'program'] [-Ffieldsep] [-v var=value] [files] *cloud% gawk gawk: Command not found.
perl -e 'eval pack("H*", "756e64656620242f3b666f726561636820283c3e203d7e206d2f5e287469746c653a2e2a3f2946524f4d3a2e2a3f2f67736d297b732f3b2f5c6e2f673b732f285c732a544f3a292f5c6e24312f673b7072696e742022245f5c6e5c6e223b7d")' <sonofgurusubmits> out.txt
The submitted code--although I might as well be throwing pixie dust over my shoulders for all I understand--gives me exactly what I wanted, a means of tracking my work--exactly like shown in the 2nd column of the table above--it is now very easy for me to track all kinds of data.
post project fun with real-time data
Thanks to this project, I can now obtain real-time data reflecting my
actual use of system guru. On 082804, I applied the pixie
dust--after, of course, creating the kind of input file described above
(I named it sunofgurusubmits828).
cloud% perl -e 'eval pack("H*", "756e64656620242f3b666f726561636820283c3e203d7e206d2f5e287469746c653a2e2a3f2946524f4d3a2e2a3f2f67736d297b732f3b2f5c6e2f673b732f285c732a544f3a292f5c6e24312f673b7072696e742022245f5c6e5c6e223b7d")' <sunofgurusubmits828 > out828.txt
cloud% grep -c DATE: sunofgurusubmits828
83
cloud% grep -c DATE: out828.txt
83
What does this tell me? That I've submitted proposals to 83 projects (no wonder I don't have time for TV--I'm consoled by Lord Kelvin's earlier words: "if you can't quantify, your knowledge is meek and humble") .... Contrast what's now on my hdd with the many uninformative constants being collected online these days--at great cost to us all and of no benefit to anyone: Instead of useless constants, *I* have *real* variables, lovely data like # projects applied for, # that I applied for that closed: gorgeous interval-level data (none of that crummy so-so science stuff, ordinal or worse, nominal categorical data-- quasi-variables like SES). While lacking the general relevance of the U.S. Geological Survey's Mount St. Helen's seismic measures, my data are every bit as good as USGS's (!!): both equal interval scales of measurement with--get this--meaningful, interpretable 0s and so ratio data, the best of the best--the only difference being that the USGS doesn't call anything "pixie dust." Heady thoughts indeed. |
|
cloud% grep Q out828.txt | awk '{print NR, $0}' > QYQN
cloud% grep Q -c out828.txt
cloud% grep Q -c QYQN About half of the projects to which I've applied--42 to be exact--have closed (at this particular point in time). I want to find out more about projects closing without awardees.
cloud% grep QY -c QYQN #projects closed by employers w/ a rating
cloud% grep QN -c QYQN #projects closed by employers w/o a rating 35 + 7 = 42, the total number of closed projects. |
Here are the details about my closed projects, first for those w/o a rating
and second those with.
cloud% grep QY QYQN 1 QYwhen closed: 0awards, 15applicants 4 QYwhen closed: 1awards, 5applicants 6 QYwhen closed: 0awards, 33applicants 7 QYwhen closed: 1awards, 18applicants 8 QYwhen closed: 1awards, 14applicants 10 QYwhen closed: 0awards, 8applicants 13 QYwhen closed: 0awards, 9applicantsgrep QY QYQN | grep 0awards -c 4 cloud% grep QN QYQN 2 QNwhen closed: 0awards, 19applicants 3 QNwhen closed: 0awards, 24applicants 5 QNwhen closed: 1awards, 42applicants 9 QNwhen closed: 1awards, 30applicants 11 QNwhen closed: 0awards, 11applicants 12 QNwhen closed: 0awards, 8applicants 14 QNwhen closed: 0awards, 12applicants 15 QNwhen closed: 0awards, 11applicants 16 QNwhen closed: 1awards, 10applicants 17 QNwhen closed: 0awards, 10applicants 18 QNwhen closed: 0awards, 22applicants 19 QNwhen closed: 0awards, 1applicants 20 QNwhen closed: 0awards, 5applicants 21 QNwhen closed: 0awards, 12applicants 22 QNwhen closed: 0awards, 37applicants 23 QNwhen closed: 0awards, 21applicants 24 QNwhen closed: 0awards, 17applicants 25 QNwhen closed: 0awards, 1applicants 26 QNwhen closed: 1awards, 22applicants 27 QNwhen closed: 1awards, 22applicants 28 QNwhen closed: 0awards, 9applicants 29 QNwhen closed: 0awards, 3applicants 30 QNwhen closed: 0awards, 18applicants 31 QNwhen closed: 0awards, 11applicants 32 QNwhen closed: 0awards, 24applicants 33 QNwhen closed: 0awards, 18applicants 34 QNwhen closed: 0awards, 4applicants 35 QNwhen closed: 0awards, 12applicants 36 QNwhen closed: 1awards, 2applicants 37 QNwhen closed: 0awards, 49applicants 38 QNwhen closed: 0awards, 21applicants 39 QNwhen closed: 0awards, 10applicants 40 QNwhen closed: 1awards , 5applicants 41 QNwhen closed: 0awards, 8applicants 42 QNwhen closed: 0awards, 21applicantsgrep QN QYQN | grep 0awards -c 28 |
I cross-tabulate these data below, with columns indicating whether the project had been posted by an employer w/ a rating (or not) and rows, whether the project had been awarded to someone (or not). The left column displays what I did to fill in the table cells (the ones obtained by addition or subtraction are self-evident).
|
|
Looking now at the table cells: employers with a rating closed about half their posted projects without making an award--and those w/o a rating closed about 3/4 of their projects without awarding them to anyone. |