NY Times August 24, 2017, Steve Lohr. Read here.
Joe and Jesse talk about spreadsheets on The Roundtable, Tuesday, August 21, 2017 11:30 AM on WAMC.
Everyone uses spreadsheets. Most people use them incorrectly.
Here are some of Jesse's suggestions for spreadsheets.
- Spreadsheets are not for formatting data. If you want to make nice rows and columns, use a word processor or page layout app.
- If you don't have any formulas in your spreadsheet, see #1.
- If you have to check totals or subtotals, you're doing it wrong.
- If your formulas break when you add or remove data, you're probably not using SUM (and other functions) properly.
- If you have several tables in your spreadsheet, turn the tables into a workbook (Excel) or use separate tables (Numbers).
- Put a comment in your spreadsheet and update it when you make changes.
- Merge cells and center titles for neatness.
- Destroy old versions unless you clearly archive them by file and title.
- If you need to put multiple lines in a cell, you probably want a related table in a database (or a related spreadsheet)
- Run away quickly from anyone who says "According to the spreadsheet..."
It seems as if everyone uses spreadsheets. Most people don't think about them too much, but there are ways to improve your spreadsheet use.
Joe and Jesse talk about spreadsheets on The Roundtable what you probably know (that's right), what you probably know (that's irrelevant), and what you probably know (that's wrong).
Download a comparison of several sets of standards here: Standards Comparison
It's probably more than you want to know so we'll boil it down to a few simple practices.
We'll talk about the flip-side of data retention and archiving: getting rid of what you don't need to keep. We may also talk about how your communication and messaging apps may be saving lots and lots of data.
On the topic of security, this article from The Atlantic raises some good points. It starts from Henry Stimson's famous line: "Gentlemen do not read each others' mail."
Washington Post article: What We Lose When the World Moves On From Email. Read here.
Springtime (April - June) is developer conference time. It probably started with the back-to-school and holiday shopping seasons in the fall. In order to fill the pipeline and retail channel with software to go with the new hardware, companies invited their developers to preview the new features of the operating systems so they could write code for the new products.
Microsoft's Annual Build conference was held this month as was Google I/O. Facebook developers met in April, and Apple's turn is June 5. What's in the air? What will products look like in the next year?
Some of the words in the air at 2017 developer conferences:
- AI (artificial intelligence)
- AR (augmented reality)
- Speech recognition
Some of the developer conversations:
- Kotlln and Swift
- Neural networks
Some of the quotes from developer conferences:
"AI is going to disrupt every single business".-- Harry Shum, Microsoft EVP AI and Research Group at Microsoft Build 2017, 5/10/2017
"An important shift from a mobile first world to an AI first world" -- Google CEO Sundar Pichai at Google I/O 2017
“We can’t build the AR product that we want today, so building VR is the path to getting to those AR glasses” -- Mark Zuckerberg in Recode interview
Joe and Jesse talk about some of the highlights on The Roundtable on WAMC Tuesday, May 23, 2017 11 AM.