Questions and answers
Short, direct answers about spreadsheet formats, formulas, engineering, chemistry, accounting, bidding and management methods, public data and how the membership works. Each answer links to a longer explanation.
Formats
- Can Google Sheets open ODS files?
- How are Sheet Reserve files converted in my browser?
- How do you convert JSON records into CSV columns?
- How do I convert XLSX to CSV without losing data?
- How do I keep leading zeros in a CSV file?
- How do I open a .numbers file on Windows?
- How should you prepare CSV data before importing it?
- How can you remove duplicate CSV rows without an upload?
- How do you split a CSV and keep the header in every file?
- What is a .numbers file?
- What is an ODS file?
- What is an XLSX file?
- What is an XML spreadsheet (Excel 2003 XML)?
- Why does Excel put my whole CSV in one column?
- What is the difference between XLSX and CSV?
Spreadsheet skills
- What is the difference between COUNTIF and COUNTIFS?
- How do I calculate percentage change in a spreadsheet?
- How do you check for duplicate spreadsheet lookup keys?
- How do I freeze the header row in Excel, Google Sheets, LibreOffice and Numbers?
- What is the difference between SUMIF and SUMIFS?
- VLOOKUP or XLOOKUP: which should I use?
- What does the #REF! error mean and how do I fix it?
- Why does an exact VLOOKUP return #N/A?
Engineering
Industrial engineering
Sales engineering
Architecture
Bidding
Chemistry
- How do you calculate molarity?
- How do you calculate purity-adjusted reaction percent yield?
- How do you calculate the overall serial dilution factor?
- How do you find the limiting reagent?
- How do you make a calibration curve with the Beer-Lambert law?
- How do you prepare a buffer with the Henderson-Hasselbalch equation?
- How does mass percent differ from mass per volume percent?
Finance
Accounting
- How do you amortize a prepaid expense by month?
- How do you calculate the allowance for doubtful accounts from an aging report?
- How do you calculate days overdue for an unpaid invoice?
- How do you calculate sum-of-the-years'-digits depreciation?
- How do you track partial payments against an invoice?
- What is a bank reconciliation?
- What is the current ratio?
Budgeting
Management
- What is the difference between an action item and a project issue?
- How do you calculate project milestone delay?
- How do you calculate SPI and CPI?
- How do you grade OKR key results?
- How do you make a Gantt chart in Excel or Google Sheets?
- How do you score a risk register?
- What is a RACI matrix and what does each letter mean?