Skip to content

Swiss Army Spreadsheets

How to do just about anything with software you already have

  • Home
  • About
  • All
  • Author
  • Presentations and Publications
  • Welcome to Swiss Army Spreadsheets

Month: June 2013

Using concatenate() and if() to improve charts and graphs

June 30, 2013 gexner

If you look at the example I discussed last week, specifically the Present_Pie and Present_Line worksheets, you might notice that when making pie charts and the single-value line graph, I had three columns for the source data. This is significant,… Read moreUsing concatenate() and if() to improve charts and graphs

Presenting data in tables and graphs

June 23, 2013 gexner

Offhand I can think of a number of different ways I could present the data from the daily downloaded statistics project I discussed last week. I could…

Project: Statistics from daily downloaded data

June 16, 2013 gexner

One thing I do every month is compile statistics on how many questions have come in to our chat reference service from various libraries. On the one hand, these statistics are automatically generated, so there’s no fussing or worry about… Read moreProject: Statistics from daily downloaded data

Adding exemptions to checking for missed data

June 9, 2013 gexner

In step 6 of last week’s post I suggested that you might want to just delete the formula from any cell that was marking a valid cell as “check”, so you could easily see when you had checked all of… Read moreAdding exemptions to checking for missed data

Finding missed data

June 2, 2013 gexner

Most of the time when doing time-based statistics, you’re supposed to have statistics for every unit of time you’re reporting on. That is to say, every hour for hourly statistics, every day for daily ones, every month for monthly, and… Read moreFinding missed data

Recent Posts

  • Working with big data sets: using different functions
  • Working with big data sets: streamlining formulas
  • How big is big?
  • The same but different: conditional formatting in adjacent cells
  • Identifying opening and closing tags

Archives

  • January 2014
  • December 2013
  • November 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010

Categories

  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© 2025 All rights reserved
Proudly powered by WordPress | Theme: Simple Life by Nilambar.
Go to top