Cell Maps – Critical Comments

Link: https://logiccomppeople.blogspot.com/2021/04/cell-maps-critical-comments.html

Graphic:

Excerpt:

Cell maps are intended as tools for reviewing spreadsheets. If you spot an error or an inconsistency in the cell map this should be recorded and, if practicable, corrected.

The cell mapping software provides a method for recording a reviewer’s comments. All comments are linked to a specific map (or data table), The comments for a workbook under review are collated in a single worksheet.

Publication Date: 18 April 2021

Publication Site: Logic, Computing, and People

Excel Never Dies: The Spreadsheet That Launched A Million Companies

Link: https://www.notboring.co/p/excel-never-dies

Graphic:

Excerpt:

Excel may be the most influential software ever built. It is a canonical example of Steve Job’s bicycle of the mind, endowing its users with computational superpowers normally reserved for professional software engineers. Armed with those superpowers, users can create fully functional software programs in the form of a humble spreadsheet to solve problems in a seemingly limitless number of domains. These programs often serve as high-fidelity prototypes of domain specific applications just begging to be brought to market in a more polished form. 

If you want to see the future of B2B software, look at what Excel users are hacking together in spreadsheets today. Excel’s success has inspired the creation of software whose combined enterprise value dwarfs that of Excel alone.

Author(s): Packy McCormick

Publication Date: 8 March 2021

Publication Site: Not Boring

Analyzing Census Data in Excel

Link: https://www.census.gov/data/academy/courses/excel.html

Description

Excel is a very popular tool among all data users. It can be leveraged to unlock the value of open data of all kinds, and it is particularly well-suited to transforming, analyzing, and visualizing Census data. This course will show how to use Excel to access, manipulate, and visualize Census data.  It will also tools for doing advanced statistical analysis.

After completing this course, you will be able to:
    ✓    Access data from the Census Bureau using the American FactFinder
    ✓    Format tables for data analysis
    ✓    Perform basic and advanced analysis of Census data using Excel
    ✓    Create data visualizations such as sparklines, hierarchical charts, and histograms

Author(s): Andy Hecktman, Alexandra Barker

Date Accessed: 27 February 2021

Publication Site: U.S. Census Bureau

Improving on perfection — where next for the spreadsheet?

Link: https://medium.com/dawn-capital/improving-on-perfection-where-next-for-the-spreadsheet-7e15c99e7e5c

Graphic:

Excerpt:

The sheer versatility and accessibility of the spreadsheet has made it the Swiss Army Knife of modern day productivity, inserting itself into almost every workflow across every industry. Over the past three decades, spreadsheets have become the de facto way for information to be collected, distributed and analysed.

But, as our operational and computational needs become ever greater, the limits of Excel become clear, and opportunities emerge for companies and tools to replace the spreadsheet.

Author(s): Dawn Capital

Publication Date: 16 December 2021

Publication Site: Medium

Spreadsheet Wars: Excel vs Lotus 1-2-3

Link: https://archive.org/details/CC606_spreadsheet_wars

Excerpt:

Excel now dominates the spreadsheet world, but once upon a time there was actual competition among spreadsheet products. This program looks at Quattro 1.0, Allways 1.0, Lotus 1-2-3 3.0, Ashton-Tate’s Full Impact, and Excel 2.1. Guests include Gary Kildall, Jan Lewis, and Jared Taylor of PC Magazine. Originally broadcast in 1988.

Author(s): PBS – Computer Chronicles

Related: https://en.wikipedia.org/wiki/Computer_Chronicles

Publication Date: 1988

Publication Site: PBS at archive.org

The Cycle Plot

Link: https://policyviz.com/2021/02/09/the-cycle-plot/

Graphic:

Excerpt:

Two primary things came out of last week’s video from Kennedy Elliott about the cycle plot. First, Naomi Robbins shared the original paper where the cycle plot was introduced, which I hadn’t seen before. In William S. Cleveland & Irma J. Terpenning’s Graphical Methods for Seasonal Adjustment (1982) paper, they focus on the importance of seasonal adjustments in various data series and how graphs and charts should be a routine part of the process of seasonally adjusting data.

Spreadsheet link: https://policyviz.com/wp-content/uploads/2021/02/SeaIceIndex_to_share.xlsx

Publication Date: 9 February 2021

Publication Site: PolicyViz