« July 2016 | Main | September 2016 »

More to Paste Special than Values


I was working with a spreadsheet and needed to convert some numbers from negative to positive.  While I knew I could add another  column with a formula to multiply each of the numbers by -1 and then copy and use paste special: values to paste the results back into the spreadsheet or I could select the column of numbers and do a find and replace to replace the – with nothing, I decided to see if Excel had a quick widget that would do the work for me.

I didn’t find a quick “switch from positive to negative” button but I did find a different way to go about changing the numbers.  

  1. Put -1 in one of the Excel cells.
  2. Copy that cell.
  3. Select the numbers you want to convert.
  4. Right click and choose Paste Special. 
  5. In the middle of the Paste Special window, there’s a section called Operation.  Select Multiply and click on Ok.  Your numbers have now been switched.

I’d seen the Operation choices before but, frankly, I’d ignored them. Until now I’ve always wanted one of the choices from the upper section (Formulas, Values, Formats, etc.) so I’d never really looked at any of the Operation (Add, Subtract, Multiply and Divide) options.

Now while a simple find and replace would have worked for my original problem, something like this could really come in handy for other situations. For example, if I needed to subtract 10% off of a set of numbers, I could put .9 in the cell instead of -1 and I'd get the numbers without having to insert a column and create a formula.

TechSoup for Libraries

TechSoup for LibrariesDo you know about the TechSoup for Libraries blog? It's one of my favorites!

TechSoup for Libraries is a project of TechSoup, a 501(c)(3) nonprofit devoted to making technology and technology education available and affordable to nonprofits and libraries all over the world. TechSoup for Libraries continues to gather and share stories from the field so libraries can keep learning from each other.

I was just looking over the blog recently and was amazed all over again at what a helpful collection of topics it covers. Some recent examples:

And those are just some of the posts that I find most appealing given my interests! There are many, many more posts on a variety of library technology topics.

You can browse to the blog, sign up for their monthly newsletters, follow them via RSS, or follow them on Twitter.

Guest Post: Madison Public Library's Personal Archiving Lab

This Guest Post is from Samantha Abrams, a soon-to-be graduate of the University of Wisconsin-Madison's School of Library and Information Studies. You can find her on Twitter as @sabramse.

Inspired by similar projects like the Memory Lab (in Washington) and the Inspiration Lab (in Vancouver), the Personal Archiving Lab at the Madison Public Library made its debut in June of this year. Funded through the Madison Public Library Foundation by a gift from Martin J. Levy, the Lab is a collection of equipment that can be used by Library patrons to digitize at-risk analog materials, like home movies, video tapes, audio cassettes, photographs, floppy disks, and paper-based documents (including photographs).

Personal Archiving LabThe Lab — as it stands — fits on a small cart (like this one), and is fully mobile. In addition to a Macbook Air, the Lab contains a flatbed scanner (which can handle poster-sized documents as well as slides and film negatives), a Sony HandyCam, a portable miniDV player, a tape deck, a combination VHS / DVD player, and a floppy disk drive. For video-based transfers, the Lab uses Elgato Video Capture. Some form of external storage (thumb drives are recommended) is required to use the lab, and the transfer of all tape-based media occurs in real time (60 min video = 60 min to complete the transfer).

The equipment we use to capture important memories today — smartphones, digital cameras, social media — makes the tangible feel less urgent. As a result, our tapes and our photographs are often stored out of sight, and out of mind. It isn’t until we run across that box in the attic, or garage, or relative’s basement, that we rediscover them. Since the debut of the Lab at the Madison Public Library, I have helped patrons access memories that are — seemingly — trapped on all kinds of outdated material: VHS and Hi8 tapes have been the most commonly digitized, but it has not been uncommon to work with patrons interested in digitizing cassette tapes, too.

Of course, not all obsolete media can be saved. Often, old tapes become demagnetized, or unintentionally damaged as time passes. But what the Lab can do — at the very least — is provide the equipment needed to access old media and the instruction required to begin the digitization process. And, based on the fact that the Lab’s appointments are often booked weeks in advance, this seems to be a much-needed service, met with great enthusiasm.

What makes the Lab truly great is not its equipment, but its ability to foster connections: not only does it allow Library staff to interact one-on-one with interested parties, but it allows patrons the ability to interact with the past. Earlier in the year, at Madison Public Library’s Pinney Branch, I sat down with a patron interested in digitizing a single cassette tape. As I prepared the computer and tape deck for our work, I made conversation with them: how did they hear about the Lab? What was it about the Lab that made them stop in? Eventually, we landed on the subject of her cassette: a conversation, recorded long ago, between the patron and their father. As they explained further, their father had passed away years before and the cassette — which was over twenty years old — was the only remaining recording of his voice. And what the Lab was able to provide the patron with was this connection: a memory from long ago, brought back to life.
More about Samantha's personal experiences with the lab can be found here.

Taking screen shots from a smartphone

Has something ever popped up on your smartphone and you wanted to take a screen shot of it?

Pretty much any task that can be done on a computer can also be performed on a smartphone. It’s just a matter of finding out how for that particular make and model.   Fish3

This post will describe one method to take screens shots with the Samsung S7: the “Palm Swipe to Capture” method.

Check your settings. Before getting started, you need to check your settings. The “Palm Swipe to Capture” setting must be ‘enabled’. This is located in ‘Settings, Advanced features’.

Think like a ‘scanner’. If you hold your hand perpendicular to the screen and slowly swipe it across the screen from right to left, that’s not unlike what some types of scanners do. The camera snapshot feature is activated by this “Palm Swipe” motion.  You'll know if the picture 'took' because you'll hear the camera 'click'.


Capture the content. Once you have content that you want to capture, think and more importantly act like a scanner with the ‘Palm Swipe’.

Locate captured content. Captured content is stored in the “Gallery”, just like any picture.

A quick Internet search should land you with the instructions that you need if your smartphone is some other make and model. 


DPLA + Recollection Wisconsin

Since TechBits last featured the Digital Public Library of America, DPLA has continued to grow in exciting ways. DPLA is a portal for finding digital resources, a platform enabling use of those resources, and an advocate for public access to digital materials. And now that Recollection Wisconsin is the latest DPLA service hub, the riches of Wisconsin's digital resources are a part of it too.

Wisconsin map image in DPLA results
Example of a Wisconsin resource found via DPLA

As libraries and other organizations build local digital collections, service hubs (like Recollection Wisconsin) harvest metadata about items in the collections and share it with DPLA. Using that metadata, DPLA provides a centralized portal website with many ways to discover digital resources across the country: search, curated exhibitions, a map for browsing by location, and a timeline for exploring throughout history. Now that Wisconsin resources are included in DPLA, it's a great resource for finding local materials and also getting a nationwide context. (Fans of libraries might enjoy the DPLA exhibition "A History of US Public Libraries.")

Using DPLA as a platform, developers can mash up digital resource metadata with DPLA's API to "create novel environments for learning, tools for discovery, and engaging apps." Wonder what that looks like? For starters, there is a Twitter bot app that tweets cat pictures found through DPLA. Other apps provide combined searching of DPLA and collections beyond US borders, find digital books by language, and other specialized tools for using DPLA.

DPLA's advocacy extends throughout projects that further their mission as well as community activities that build engagement with digital collections in fun and educational ways.

Inspired? DPLA also offers a free self-guided curriculum for public libraries to get started on digitization projects (more info & archived webinar).

Recollection Wisconsin

Many of you already know about Recollection Wisconsin or may have heard it mentioned at our 2016 Tech Day, where Emily Pfotenhauer shared information about digitization projects. I spent a little bit of time recently becoming more familiar with Recollection Wisconsin, and here's an overview of what I learned:

What is Recollection Wisconsin?

"Greetings from Wisconsin Rapids, Wisconsin" by McMillan Memorial Library is licensed under Creative Commons Attribution-Noncommercial-Share Alike 3.0.

Recollection Wisconsin is a space to discover digital historical and cultural resources from libraries, archives, museums and historical societies across Wisconsin. It brings together descriptive information (metadata) about digital resources and links back to full digital records from its Content Partners. (About Recollection Wisconsin)

What can I find there?

The Recollection Wisconsin search engine will point you to photographs, diaries, letters, maps, books, magazines, newspapers, postcards, oral histories, music, film clips, and museum artifacts with connections to Wisconsin's past.

What are my searching options?

Recollection Wisconsin has both basic and guided search options, as well as options to browse collection by category or explore collections on a map, and to view online exhibits. The online exhibits are my favorite so far. Who doesn't love a curated collection of items focused on a single topic like "Ice cream parlors," "The Good Stuff: Wisconsin's sausage heritage," and "Pictures of Main Street," to name just a few. (More about searching, including a video tutorial). While browsing collections by category, the "Ach Ya!: The Story of German Music in Wisconsin" collection also jumped out at me and reminded me of my grandma sitting at her kitchen table and responding with an "Ach Ya!" on many occasions.

More information

There's a lot more information on the Recollection Wisconsin site about searching, using the site in the classroom, Recollection Wisconsin projects, and how institutions can participate, as well as a newsletter to keep up with Recollection Wisconsin activities and newly-added collections! You'll also find information about how Recollection Wisconsin is now a service hub for the Digital Public Library of America (DPLA) so local digital collections can be discovered as part of this national program. 

Office 365 Email Clutter Feature Going Away

With my last Techbit in June, I was excited to talk about the Clutter feature in Office 365 Email.  I have just read an article announcing that the Clutter feature is being deprecated in favor of Emotion_focused-300px
the Focused Inbox.  Microsoft is discontinuing the feature because it interferes with users who have complex inbox filtering rules and business users are often seeking the help of their Email Admins to locate missing emails.  The Focused Inbox won't redirect email to a different folder like the Clutter feature.  Instead, it will offer a different view of your Inbox by showing you what Microsoft's algorithms believe are the emails most important to you.  The Focused Inbox could start appearing in your email as soon as September.

PumpAlarm can send you text messages about power outages, water on the floor, etc


Here at SCLS we are constantly looking for a simple solution that makes life a little bit easier and we found that with PumpAlarm.  The device is about $220 and the cellular service per year is $49.  Here is a video (no sound) that explains what it can do.


We use PumpAlarm in our server room to monitor power outages and if there is water detected on the floor.  It's a great tool for knowing exactly what is happening.  Could this be useful in your building or maybe even at home?

Tips and Tools for Teaching Older Adults Technology

TechSoup for Libraries hosted a webinar in May on teaching older adults technology at the library. The webinar featured two guest speakers: Steve Black, the founder of TechBoomers, who shared information about this free resource for technology training, and Kathy Faubion, a computer class instructor from the St. Mary's County Library in Maryland who shared how she teaches technology to the older adults in her community.

I hadn't heard of TechBoomers prior to the webinar, so it was a nice introduction to another resource for basic technology and internet tutorials and documentation. TechBoomers was launched with the mission to "improve the quality of lives of older adults by empowering them to learn how to use technology," and offers over 80 free courses, 1,000+ videos, and article tutorials, with plans to add more in the future. Steve suggested many ways libraries can incorporate the free TechBoomers materials to teach digital literacy.

Kathy had lots of tips and suggestions to improve attendance, make lesson planning easier, and tailor training for older adults.

Watch the webinar, or read about the highlights in this TechSoup for Libraries blog post. Lots of good ideas!