2 ms·
There are also many downsides
by walshemj 10y ago
There are also many downsides
- gravypod 10y agoYou can say that about every technology but the question is if the good out ways the bad in your specific usecase.
- valarauca1 10y agoYes and No. If all the data you receiving is also coming to you as an Excel format (csv, xls, xlsx), but with major differences in formatting, or wholly inconsistent formatting. Now you have a multi-month long project just to have a consistent import script. Replacing a 1 second task done 2-3's times a day with a 4month project has an ROI on the scale of decades. Not worth it. Then you add visualization. What is 3-4 keystrokes in Excel is a lot of back of forth, learning a new library, ensuring it works on your system. Vetting the visualizing, dealing with that weird bug on the triple line double axis line chart. Then you have to validate integer handling and mathematics to ensure your newly written Python, Julia, etc. handles the same as your well vetted Excel Spread Sheet. Replacing that one slow bloated spread sheet is now nearly a year long project which requires a new employee who will have comparable pay to the person who ALREADY operates excel.
- Swizec 10y ago> spread sheet is now nearly a year long project which requires a new employee who will have comparable pay to the person who ALREADY operates excel. And now you have a scalable system. You can go from something one employee takes all day to look at 2x/day, to something anyone in the company can see in real time on a dashboard of some sort. Is that worth it? Depends
- digikata 10y agoDon't know if this is the best study, but it contains an overview of many studies that show that excel calcs tend to have huge error rates. http://panko.shidler.hawaii.edu/SSR/Mypapers/whatknow.htm http://panko.shidler.hawaii.edu/SSR/Mypapers/whatknow.htm Of course that raises the question would any other software environment have a lower error rate?