katbusch/women-in-software-eng

This is the data collection follow-up to "Where are the numbers?" https://medium.com/grace-hopper-2013/cb997a57252

Viewing Data

The easiest way to view the collected data is this Google spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AlZH8QBl60oodEJTdFA5TlZOcDJCMU02RkZoSHF5SHc#gid=0

Contributing Data

For the purposes of this project, I am counting "female engineers" as women who are writing or architecting software, and are in full-time roles. This generally does not include people just writing HTML/CSS (depending on the level of sophistication of the CSS being written), designers, PMs, sysadmins, etc. although the line can be blurry for people who are in mixed roles, like engineering managers who were formerly ICs and still contribute code -- use your judgment. Only full-timers please; no interns or contractors.

To contribute numbers for a company or team, whether your own or another, you can either

1. Send the information to me via Twitter at @triketora or email me at tracy at pinterest dot com. I am happy to anonymize contributions if they are sensitive.

2. Submit a pull request amending data.txt (click this link to easily submit a pull request: https://github.com/triketora/women-in-software-eng/edit/master/data.txt),

   in the git commit message include:

   • the contributor (the person providing the data, preferably with qualifications, and a contact method such as Twitter handle) and
   • source (e.g. internal headcount, /about team page count, etc.).

   The submitter of the PR does not have to be the contributor of the data. For example:

   https://github.com/triketora/women-in-software-eng/commit/e9d76a956512247fd5f8a9a2e220a4ca403b5452

   Adding Rent the Runway.
   
   Contributor: Camille Fournier, VP Architecture at Rent the Runway,
       @skamille
   Source: internal headcount
   
   https://medium.com/grace-hopper-2013/cb997a57252#d4d8-b3d509275bf9
   Rent the Runway is 7 out of 32 if you just count dev + ops, 10 out of
   37 if you count QA, 11 out of 39 if you count all the people I manage.
   

   It may be helpful to add your entry somewhere besides the end of the list, since everyone submitting to the end of the file means merge conflict party.

How does the spreadsheet get updated?

Right now, I manually run update_script.py to pull the numbers out of data.txt and submit them to the Google spreadsheet.

Something like this:

python update_script.py -e [email protected] -p [password] -d data.txt

You can pass it in to your own spreadsheet by supplying the Spreadsheet Key (SS_KEY):

python update_script.py -e $GOOGLE_EMAIL_ADDRESS -p $PASSWORD -d data.txt -s $SS_KEY

Where SS_KEY is the key found in a Google Docs spreadsheet URL:

https://docs.google.com/spreadsheet/ccc?key=$SS_KEY

Questions / Comments / Concerns?

Please reach out to me on Twitter at @triketora or email me at tracy at pinterest.com. Feedback on anything big or small is very welcome :)