This is the last cause I'll promote (for awhile), but it's a big one. Hopefully by now you've heard of the two bills in Congress that threaten the future of the internet - SOPA in the House and PIPA in the Senate.

If you're not sure how either of these will affect you (and libraries), here's a few quick descriptions I've seen recently:

The harm that does to ordinary, non-infringing users is best described via a hypothetical user: Abe. Abe has never even so much as breathed on a company’s copyright but he does many of the things typical of Internet users today. He stores the photos of his children, now three and six years old, online at PickUpShelf* so that he doesn’t have to worry about maintaining backups. He is a teacher and keeps copies of his classes accessible for his students via another service called SunStream that makes streaming audio and video easy. He engages frequently in conversation in several online communities and has developed a hard-won reputation and following on a discussion host called SpeakFree. And, of course, he has a blog called “Abe’s Truths” that is hosted on a site called NewLeaflet. He has never infringed on any copyright and each of the entities charged with enforcing SOPA know that he hasn’t.

And yet, none of that matters. Under SOPA, every single one of the services that Abe uses can be obliterated from his view without him having any remedy. Abe may wake up one morning and not be able to access any of his photos of his children. Neither he, nor his students, would be able to access any of his lectures. His trove of smart online discussions would likewise evaporate and he wouldn’t even be able to complain about it on his blog. And, in every case, he has absolutely no power to try to regain access. That may sound far-fetched but under SOPA, all that needs to happen for this scenario to come true is for the Attorney General to decide that some part of PickUpShelf, SunStream, SpeakFree and NewLeaflet would be copyright infringement in the US. If a court agrees, and with no guarantee of an adversarial proceeding that seems very likely, the entire site is “disappeared” from the US internet. When that happens Abe has NO remedy. None. No way of getting the photos of his kids other than leaving the United States for a country that doesn’t have overly broad censorship laws.

A much more succinct description, from Consumer Electronics Association president Gary Shapiro (also via BoingBoing):

[SOPA is championed by] politicians who are proudly unfamiliar with how the internet works, but who are well familiar with favors from well-heeled copyright extremists.

No call to action will work unless people actually take action. Right now many Congressmen and Senators are still at home on vacation, but will be back in session in the next week or two. Now is the time to contact them, as them to explain what these bills are, and urge them to vote against them. Here are some things to help:

This week's question is actually one I needed to answer myself - it's a little bit random, so bear with me.

My library just held our annual thank-you dinner for all of our adult volunteers. To illustrate "the value of volunteers" (in other words, how much money volunteers save us) my director and I came up with a "volunteer stats" bookmark* [ppt, 1.2MB] to hand out.

We had 241 volunteers last year, with a total of 5804 volunteer hours. We figured if we paid them each $15/hour, their labor would have cost the library $87,060. Just to add another little fact to the bookmark, I wanted to figure out just how tall $87,060 was in $100 bills.

So of course, I turned to the internet. I did a search for something like how tall is a stack of money, and after clicking on a few results, I found a forum posting that provided the Excel formulas needed to calculate not just the height of a stack of bills, but also the cubic volume and value of different denominations. Neat.

I copy/pasted the formulas into an Excel spreadsheet* [xls], and after a little tweaking, had my answer. And just to double-check it, I went back to the internet to find a "known value" (in this case, the height of $1 million in $100's). It checked out, so I had my fact for the bookmark, and a job well done, right?

Well, not so fast: being me, I thought, "hey, wouldn't it be awesome to turn this Excel spreadsheet into a web form that other people could play with? After all, that was so popular the last time."

But this was all happening late in the day on Thursday, and I didn't have time to figure out how to convert the Excel formulas into javascript. So once again, I turn to the internet, thinking, "I just bet there's some easy spreadsheet-to-javascript converter out there."

And it turns out, there is: I found SpreadsheetConverter.com, which does exactly that. After you download the software, it converts spreadsheets to a web-ready format with just a click of a button - pretty neat.

But even better was their free demo offer, where you email them your spreadsheet and they convert it for you. Within 24 hours they sent back the converted webpage, and it works great - just enter the height** of your money stack below, and the spreadsheet tells you the value of various denominations, for both a single stack and a cubic block of bills.

One condition of the free demo is that it is for evaluation purposes only, so evaluate away and keep this tool in mind if you ever need to throw a spreadsheet up on your website - it can save you a lot of time. Too bad I didn't know about it when I was coding the Library Use Value Calculator.

The thank-you dinner went well, and the bookmarks were a big hit. Yay for volunteers.