May 19th, 2012 Brian Herzog
This question wasn't difficult in the least, just kind of fun - and great because I got to give a patron very good news.
On Friday, a patron called in and asked if I could go to the website of Skinner auction house. He said he had an item that was included in their auction that day, and wanted to see how much it sold for.
Finding the website was no problem, but it took me a little while to find the right auction results. The auction went from noon to 4pm, and the patron called about 2:30. So, although I found the auction results, it turned out his item hadn't come up yet. We did learn that his item was estimated to sell for between $1,200-1,800, which sounded good. He thanked me and said he'd call back in a little bit.
About 4:30 he called back, thinking that since the auction ended at 4pm, all the results would be posted. But they weren't - they were still only about halfway through, and his lot was towards the end.
I told him we were open until 5:30, and he's welcome to call back, or I could keep checking and call him. But, he said he was leaving for the day, so he'd just stop in the next morning.
It was my Saturday to work, so I was at the desk when he came in right at 9:30. I think we were both kind of excited as we went back to the website and looked up the auction results. Everything had been posted by then, so we scrolled down to his lot number to see how it did. Amazing: $4,148.
The patron was astonished, and had to ask me a couple times if that was the actual sale value. We doubled-checked by looking at the individual item listing, and sure enough, his painting sold for $4,148. However, because of Skinner's 15% commission, he'll only receive $3,500, but he still had a big smile on his face as he walked away from the desk.
Wow, what a nice way to start a weekend.
May 8th, 2012 Brian Herzog
Here's a more in-your-face twist on the Library Value Calculator. Another library in my consortium figured out how to display the total cost of a patron's items on their checkout receipt, and since we never let a good idea go to waste, we adopted it in my library, too.
Basically, it's a little macro that pulls the cost figure from each item's record, adds them all up, and provides a total. We present it in kind of a cutesy context, but the intent is to show people how much they save by using the library. Check it out:
Our phrasing is deliberate - if people bought the items themselves, they'd get to keep them (which obviously isn't the case with libraries). Also, we only print out receipts if people ask for them (to save on paper), so I'm not sure what impact this will have - we'll see.
Also: speaking of valuable things, I'm off for the next week to see my family over Mother's Day weekend (hence all the audiobooks I'm checking out above). So no Reference Question of the Week this week, and I'll be back next week.
This is how I was able to add this to our receipts - as far as I know, this only works with Evergreen version 2.1 and later. If you have a different ILS, contact your vendor and demand they offer it:
- In Evergreen, open the Receipt Template Editor
- Choose the checkout template
- At the bottom of whatever you have in the Line Item, add this:
<span style="display: none;" sum="sum1">%price%</span>
- Somewhere in the footer, add this:
You saved: $<span sumout="sum1" fixed="2"></span>
(or whatever you'd like it to read. Also, the fixed="2" rounds to two places.)
- Click the Save Locally button
Keep in mind that if the items checked out somehow don't have price values assigned to them, the receipt will read "You saved: $0.00" at the bottom.
November 8th, 2011 Brian Herzog
This year while we were compiling all of my library's FY11 statistics to report to the state, it occurred to me to try something new with them.
Since everything we tally up for the state report is how much each library service get used, I thought I'd put all those totals into the Library Use Value Calculator - this then, in theory, will show how much value the entire community gets from using the library (instead of just using the calculator on an individual level).
Here's how things broke down*:
So at retail prices, the entirety of our activity last fiscal year should have cost our patrons a staggering $12,371,068.30 - over twelve million dollars. The library's total budget is about $1.5 million. So, by funding and using the library, our community saves about $10.5 million dollars a year.
I think that pretty clearly spells out the value of public libraries. Hopefully we'll be able to work this into some marketing materials to make the case of why our (meager) budget is important to the community.
*A couple notes on the figures:
- Interlibrary Loan Requests I think includes all of our network transfers within our consortium
- I was surprised ebooks was so low, but our Overdrive stats show that downloadable audio is still far more popular than ebooks (of course, ebooks are still new to us, so we're still building that collection)
- The state report has a single line for "Periodicals" - so I put that into the Magazines box in the calculator, and left Newspapers empty
- The state report groups all "CD" usage, so our audiobooks and music CDs are combined under Audiobooks, and I left CDs empty
- I left Meeting Room Use (per hour) empty, and am just replying on the attendance numbers - the per hour use is more individual and doesn't really scale out well to the community level
- I didn't have a total for Database Searches, so the number there is the number of times our databases were accessed (as opposed to searched) - which, again, makes more sense for the community level rather than individual level
April 30th, 2011 Brian Herzog
One slow afternoon, and elderly woman called and asked,
Can you tell me how many silver dimes it takes to make an ounce of silver?
I said sure, and started an internet search. Initially I searched for "silver dimes in an ounce site:.gov" hoping that a Government site would have the most authoratative information on the different metal composition of different coins, and provide a nice chart to equate silver coins to pure silver ounce. But after skimming the first couple pages of results, I was getting nowhere fast.
I dropped the "site:.gov," which produced a ton of results - by comparing various answers, which were all roughly the same, I felt confident to give her the answer that it takes 14 dimes make an ounce of silver.
To this she said,
Thank you, that's wonderful. If it's not too much trouble, could you also tell me how many silver quarters make an ounce? You see, my husband always kept a jar of silver coins, and he told me never to touch them. He said the silver in them was worth more than the coins, so to never spend them. I heard that the price of silver is getting high now, and with my husband gone, I wanted to know if it was time to cash them in.
I ran the same search for quarters (6 quarters) and also for nickels (18 nickels - I did not know that nickels minted during WWII were made of silver).
While I was looking for these, the woman kept talking about her husband, and why he collected coins.
He always said that you can't lose with coins, because you have options. He said the value of the silver in them will always be the highest. But, there's also the value to coin collectors if you have something rare. And, if all else fails, at least you can still spend them as dimes and quarters. You can buy a block of silver, but you can't spend it at a store - at least you'll always be able to spend coins in a pinch.
This whole call had an air of sorrow to it, because I got the feeling that her husband had died awhile ago, and she had hung on to these coins with that memory of him. But with her investigating the value of the silver, it felt as if she was ready to cash out because she needed the money - and the thought of an elderly woman taking a mason jar full of her late husband's coin collection to a cash-for-gold place just made me sad.
But this cheered me up: she asked me to look up the current price of silver (about $48/ounce), then did some quick math and said,
Well, that's either $1.40 in dimes or $1.50 in quarters - I've got a lot more dimes anyway, so I'm going to turn in enough to buy myself something nice. This'll be the best $1.40 I ever spent.
Ha - that brightened my entire day.
After I hung up with her, I kept searching to see what else I could find. Coinflation.com offers some good tools - a handy listing of the face value and silver value of circulated coins (which also links to individual pages about each type of coin), and a silver coin calculator in which you enter the number of different types of coins and it tells you how much they are worth.
Some people might remember that one of my hobbies is metal detecting (fitting for a reference librarian, right?) - it turns out that the four Mercury dimes I've found are worth $13.87 in silver. Neat (but I'm keeping them).
Tags: coin, coins, collection, dime, dimes, libraries, Library, nickel, nickels, ounce, public, quarter, quarters, silver, value, worth
March 1st, 2011 Brian Herzog
This post isn't about the current ebook debacle, because Bobbi and Kate are doing a better job than I could.
This is just a quick announcement that I've updated the Library Use Value Calculator - here's a rundown of the changes:
- Updated costs, in conjunction with staff from the MLA
- Added lines for ebooks* and music downloads
- Removed the distinction between magazines/newspapers browsed in library and those checked out (my feeling was, if they used them at all, it counts)
- Changed some wording and reordered the services to (hopefully) make things more clear - materials at the top, services at the bottom
- Added additional instructions on how to host or modify the calculator code yourself
I also wanted to add a "Share on Facebook" link, but I haven't tackled that yet. If anyone is looking for a project, let me know.
All of this is available at http://www.swissarmylibrarian.net/librarycalculator. If you already had the calculator embedded in your library website, the updates will take effect automatically.
If anyone has any questions, or needs help with the calculator, please let me know.
Tags: calculator, cost, economic justification, embed, funding, libraries, Library, library calculator, library use calculator, library use value calculator, library valuation, library value, public, value, value of libraries
October 23rd, 2010 Brian Herzog
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."
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.
*Feel free to download, edit and reuse our volunteer bookmark* [ppt, 1.2MB]
or the Excel spreadsheet* [xls]
if you like.
**This was designed to figure out height in inches - to use different measurements, the form below will convert those values into inches: