The futile quest for a pasteboard format which transfers numbers as numbers rather than text which has to be converted back in integers, floating point numbers, and so on.
Excel
On 2 October, public health authorities discovered figures had lost nearly 16,000 recent cases. Was this an error in file formats, using an old version of Excel, or what?
Looks at plain text, CSV, XML, JSON, RTF, RTFD, .docx, .xlsx, and PDF. Which should you trust with your important documents in archives?
A detailed tutorial showing how you can time events, such as moving from one note to the next, using free and simple tools.
Browsing my log in Excel for the first time was a revelation of its potential. We have the tools – all we need is the imagination.
JSON is a popular standard for data obtained from internet sources. How well is it supported by spreadsheets? And two major upgrades: Tinderbox 7 and Dash 4.
How to import complete log extracts into Excel or Numbers, using R as a conversion platform. It’s a bit convoluted, but it works.
Sierra’s new logs have new uses, such as collecting and analysing test and use data – only if you can import log extracts into a suitable app.
When starting or quitting Excel, it complains of a file access error. How can I stop that?