Did you know that the Teddy Bear was named after Theodore Roosevelt in a successful marketing campaign by toymakers? Explore this and other fun facts about all 46 US presidents in our United States Presidents spreadsheet.
Beyond introducing you to Andrew Jackson's foul-mouthed parrot named Poll, this spreadsheet uses several unique Spreadsheet.com features to organize, link together, and aggregate information about US presidents across multiple worksheets. For example:
Column C (Photos) in the Presidents worksheet is set to the Attachment data type, providing a place for presidential photos. The States worksheet also uses Attachment columns for state flag and state quarter images.
Column G (Party) in the Presidents worksheet uses the Related row data type to link presidents to rows in the Political Parties worksheet. Similarly, column M uses Related rows to link presidents to rows in the States worksheet.
Kanban views in the Presidents worksheet allow you to explore presidents by columns that use the Select data type, such as Religion and # of Years served.
Related row rollups are used in the Political Parties and States worksheets to calculate total number of presidents and years in office for each political party, by counting and summing data from linked rows.
John Quincy Adams' morning skinny-dip might be just enough inspiration for you to take the plunge and make a copy of this spreadsheet. Explore how these unique features work, and learn something new about US presidential history.
Before collating presidential factoids, our template team published 5 new templates in the Spreadsheet.com Template Gallery for use cases ranging from goal tracking to a new hire task list, and café inventory management.
Charts We’re working on adding the ability to create floating charts in worksheets that update in real time, including 14 different configurable chart types.
Grouping Based on popular request, we're adding the ability to group rows in Sheet views by unique values in a column with multiple levels of grouping.
Row Movement Ability to drag and drop rows to reposition them in a Sheet view. This includes the ability to move parent rows in a hierarchy and have all child rows move with them.
Gantt View and Project Management Improvements From enabling formulas in project management columns, to support for multiple types of dependencies, we have a whole set of Gantt view and project management improvements coming soon.
Borders 2.0 We're redesigning how borders work in Spreadsheet.com to better align with traditional spreadsheet behavior.
API We're working on publishing an initial version of our REST API that can be used to programmatically interact with Spreadsheet.com workbooks.