News for hackers. Stuff that matters.

A comment on Ditching Excel for Python in a legacy industry. Parent comment

Re:Ditching Excel for Python in a legacy industry by mehrdadn on Thursday December 31, 2020 @02:13AM (#25590353)
> There are ways of building spreadsheets that are reliable and auditable. Then there's how 95% of people do it

Do you have any pointers to learning materials on how to do this? Would be interested in reading more on it.

[ Parent | on HN ]
Re:Ditching Excel for Python in a legacy industry by sam_bristow on Thursday December 31, 2020 @02:53AM (#25590574)
This Twitter thread is a good start: https://mobile.twitter.com/keith_ng/status/13079610874515251...

There also Joel Spolsky video I linked in another comment: https://youtu.be/0nbkaYsR94c

I don't actually use Excel much so others might have better resources.

[ Parent | on HN ]
Re:Ditching Excel for Python in a legacy industry by mehrdadn on Thursday December 31, 2020 @07:00AM (#25591887)
Oh I've already seen the Spolsky video, but I seem to recall for the most part (except for using tables, which is great) it's about how to use Excel effectively, not about how to produce maintainable sheets. The Twitter thread looks good though. Thanks!
[ Parent | on HN ]