25 ms·
If think it is more like, if I have to share this process with people who are non-coders, then I'm going to use excel.
by sosborn 6y ago
If think it is more like, if I have to share this process with people who are non-coders, then I'm going to use excel.
- hencq 6y agoYes, or, do I want to be on point to maintain this until the end of days? If no, use Excel.
- macNchz 6y agoAbsolutely, if you're generating any kind of ad-hoc reports for biz/marketing folks it is often a much better to implement it in a way that they understand and update than to write your own code to produce it. "Paste the export from {business system} in this tab, then drag down column F in the first tab to update the vlookups." Boom, no more 5-minutes-before-the-board-meeting-can-you-just-rerun-this-report-with-different-parameters emergencies. For the most part.
- pietromenna 6y agoThis is how I do it as well.
- kevinmchugh 6y agoI think almost the opposite. Excel is useful for quick exploration or entry of data. If I need data entry from many people, a web spreadsheet can be useful, too. At the point that others will be dependent on the output, I want version control and tests. You can make that happen with excel but it's not easy.