NoSQL Sayings

• In NoSQL, consistency is a choice, not a guarantee.
• Transactions in NoSQL are like spices — use them sparingly, but know when they’re essential.
• Eventual consistency means your data will agree… eventually.
• The best transaction is the one you don’t need.

Shortcomings of Excel

• No column header
• No data type (confused by format?)
• Column may hold different data types
• No validation
• No concept of a row (record), just try sorting
• No enforcement of "rectangularity"
• No way to relate rows on different sheets
• No concurrency control
• No permission management

De Minimis Excel

• &, ""
• TRIM()
• TEXT()
• Text to Columns

How to Convert Number to Text in Excel

• TEXT()
• Apostrophe

The format function only effectuates an appearance change.

Shortcomings of Excel

• No column header
• No data type (confused by format?)
• No validation
• No concept of a row (record), just try sorting
• No enforcement of "rectangularity"
• No way to relate rows on different sheets
• No concurrency control
• No permission management

De Minimis Excel

• &, ""
• TRIM()
• TEXT()
• Text to Columns

How to Convert Number to Text in Excel

• TEXT()
• Apostrophe

The format function only effectuates an appearance change.