3 ms·
"The tradeoff is that you have be disciplined in your data entry process...i.e. unique identifiers have to be spelled consistently, as you don't have the abilit
by kalven 11y ago
"The tradeoff is that you have be disciplined in your data entry process...i.e. unique identifiers have to be spelled consistently, as you don't have the ability to enforce constraints or enumeration"
This is a really good point and one I should have included (I wrote the piece above). There is no easy way to validate syntax and spelling in the spreadsheet and we would often find ourselves hunting around, trying to find the typo that was breaking a particular project. We obviously got better at avoiding this situation as time went on, but it made the learning curve all the more difficult for new users.
- aendruk 11y agoWhen I attempted a similar setup (Middleman + Google Sheets) I was quickly cornered into using fuzzy string matching to load data successfully. I ended up adding unplanned data validations that enabled the app to suggest corrections, but in retrospect I wish I'd done more validation in the spreadsheet itself for a tighter feedback loop early on.
- Someone 11y agoPivot tables can help there. If you pivot on color, you will more easily see that lone "grey" between the "gray"'s. You can also copy-paste-as-values a known-good one, and compare what you have know against what you had last week. And of course, you can enforce an enumeration in Excel. See https://support.office.com/en-us/article/Apply-data-validation-to-cells-c743a24a-bc48-41f1-bd92-95b6aeeb73c9 https://support.office.com/en-us/article/Apply-data-validati...
- epochwolf 11y agoLet me point out that Excel has had data validation in spreadsheets for years. It is trivial to enforce basic data validation without writing any code.