Saving the World from Spreadsheets [video]
youtube.com
Saving the World from Spreadsheets [video]
1–10 of 27 posts
Re: Saving the World from Spreadsheets [video]
#2Re: Saving the World from Spreadsheets [video]
#3I don't know of anything similar for Jupyter notebooks or sql either. I guess testing with simulated data designed to yield expected results would be the way I test my stuff.
Re: Saving the World from Spreadsheets [video]
#4and then people just love AirTable... especially the dev community I feel
Re: Saving the World from Spreadsheets [video]
#5Here's the corresponding papers:
CheckCell - https://people.cs.umass.edu/~emery/pubs/CheckCell-preprint-O...
ExceLint - https://arxiv.org/pdf/1901.11100.pdf
Re: Saving the World from Spreadsheets [video]
#6I don't know of anything similar for Jupyter notebooks or sql either. I guess testing with simulated data designed to yield expected results would be the way I test my stuff.
Seems that bootstrapping and outlier detection is the way to go independent of what language of “editor”(Eg notebook use) you are using.
The really cool thing here is that they parse the excel formula in order to automatically “figure out” how they can perform the bootstrapping.
Re: Saving the World from Spreadsheets [video]
#7Check out the guy with his face planted in his keyboard at 9:05!
Is that what spreadsheet debugging looks like?
Edit: at 13:40, maybe he's just using facebook.
Edit2: I'm sorry for putting it that way, I didn't mean to shame him about his vision. I only thought it seemed like he wasn't paying much attention to the lecture when he kept switching between using his phone and laptop, while wearing a "facebook" t-shirt.
Re: Saving the World from Spreadsheets [video]
#8Check out the guy with his face planted in his keyboard at 9:05! Is that what spreadsheet debugging looks like? Edit: at 13:40, maybe he's just using facebook. Edit2: I'm sorry for putting it that way, I didn't mean to shame him about his vision. I only thought it seemed like he wasn't paying much attention to the lecture when he kept switching between using his phone and laptop, while wearing a "facebook" t-shirt.
He could have a vision impairment.
Re: Saving the World from Spreadsheets [video]
#9I don't know of anything similar for Jupyter notebooks or sql either. I guess testing with simulated data designed to yield expected results would be the way I test my stuff.
> I don't know of anything similar for Jupyter notebooks or sql either
Exactly. It feels like we're falling into the exact same problem with Jupyter notebooks as with spreadsheets: they become increasingly used by professionals who code (but who aren't software devs) to create bug-ridden, unmaintainable, large-scale software because they become familiar with the tool they have at hand.
Re: Saving the World from Spreadsheets [video]
#10Check out the guy with his face planted in his keyboard at 9:05! Is that what spreadsheet debugging looks like? Edit: at 13:40, maybe he's just using facebook. Edit2: I'm sorry for putting it that way, I didn't mean to shame him about his vision. I only thought it seemed like he wasn't paying much attention to the lecture when he kept switching between using his phone and laptop, while wearing a "facebook" t-shirt.
Really? He clearly has vision trouble.