3 ms·
Have you considered trying to get people to use something like Jupyter or R Notebook?
by crooked-v 8y ago
Have you considered trying to get people to use something like Jupyter or R Notebook?
- throwanem 8y ago"Now you have two problems."
- crooked-v 8y agoDebugging R code, even badly-written R code, seems like it'd be less hassle than debugging layers of formulas and auto-written macros.
- irrational 8y agoCan you help me with RegEx in Excel?
- intended 8y agoCurious- what’s the issue you are trying to solve ? There are Addins which give regex support as I recall. Usually though it’s a matter of find/right and other hackery to make it work.
- irrational 8y agoSorry that was a joke. You know, "Some people, when confronted with a problem, think 'I know, I'll use regular expressions.' Now they have two problems."
- peatmoss 8y agoPast a low complexity bar, I feel like R is a much easier answer than Excel. Excel can get pretty hairy pretty fast. As you mention below, debugging even terrible R code is easier than debugging Excel.
- ams6110 8y agoReally? I took a stab at R about a year ago and found it utterly confusing.
- bachmeier 8y agoI think the point is that formulas and macros are more utterly confusing.
- patmcguire 8y agoYeah, at least the R code only goes up and down, line by line. Most non-trivial excel code will have different bits of code going right and left (formulas sit in a row,column pair). One you get into extra tabs/sheets that's yet another dimension.
- wyoung2 8y agoThe problem with debugging formula code is that it's hidden in the default view, and you have to know which cells to click on to find each bit of code. In simple spreadsheets, the proper cell to click on is obvious, because the formula only updates the one cell where the formula is. The problem comes with multi-cell functions like Excel's VLOOKUP or Google Sheets' QUERY, where a cell that looks like it contains literal text might contain the complex formula call, and then all of those around it might look like plain text, but they're also the call's results. Editing any of this wrecks the sheet. Despite these dangers, I recently perpetrated such a thing in Google Sheets, because that's the only platform I could get to easily work across many sites, some of which have users that are often offline. The next step up from that would be to stand up a custom web app, and the project simply did not demand that amount of effort. The next-best idea was to keep passing around .xls files via email; barf. That's the seductive nature of these one-off spreadsheet "apps": they're quick and easy to stand up, yet difficult to extend and debug by the time that they grow to the point where they would justify development time for a proper application. By then, they've also gained a big enough user base and feature set that rebuilding the app properly also means a big effort in all axes: development, testing, deployment, and retraining.
- wombatpm 8y agoNumber One reason to use Jupyter, R Notebooks or anything else: Source Control. They can write bad code all they want, if you can put it in source control you point out what they broke. Try doing that with an excel file where they are cutting and pasting formulas.