cgranier | 3 months ago | on: Ask HN: What Are You Working On? (Nov 2025)
cgranier's comments
cgranier | 3 months ago | on: Ask HN: What Are You Working On? (Nov 2025)
cgranier | 2 years ago | on: Show HN: Unity like game editor running in pure WASM
cgranier | 2 years ago | on: Reddit subs with millions of followers plan to extend the blackout indefinitely
cgranier | 3 years ago | on: The end of the high school essay
cgranier | 3 years ago | on: The end of the high school essay
cgranier | 3 years ago | on: Show HN: An Excel Wordle Solver
cgranier | 3 years ago | on: Great minds think alike: Twins beat school’s cheating claim, win $1.5M
cgranier | 3 years ago | on: How to write API errors that keep your users moving forward (2021)
I love finding easter eggs in code bases or error messages (as long as they don't introduce more headaches, of course).
cgranier | 3 years ago | on: The Receipts on Vaccine Efficacy
Cherry picking at its finest.
cgranier | 3 years ago
cgranier | 3 years ago | on: Ooh.directory
cgranier | 3 years ago | on: Books recommended by profitable founders
cgranier | 3 years ago | on: Lazy, a Capture Tool for Knowledge
Looks interesting though...
cgranier | 3 years ago | on: How diffusion models work: the math from scratch
If you find something like that for diffusion models, don't forget to share.
cgranier | 3 years ago | on: Mastodon Explained
cgranier | 3 years ago | on: Ask HN: What are the most prestigious badges a software developer can take/award
cgranier | 3 years ago | on: The first rule of Microsoft Excel: Don’t tell anyone you’re good at it
cgranier | 3 years ago | on: The first rule of Microsoft Excel: Don’t tell anyone you’re good at it
Where/how does Excel knowledge factor into this?
Well, we managed a lot of data, mostly (but not only) CSV files. It's very useful to learn a few text manipulation functions in Excel when creating CSV files with sequential and or repetitive content (think TV episodes, etc). Or creating several flavors of CSV for each platform. Yes, a database backend with smart exporting functions might work well, but sometimes fast beats perfect, especially for one-off jobs.
Uploading thousands of videos into YouTube was much quicker with one or two CSV files. By learning some basic Excel, everyone was able to minimize errors and maximize output.
What else could we do with Excel? We could export XML files of our video edits from Premiere/FinalCut Pro, run them through a script into Excel and immediately get a report showing all the editing errors that still needed fixing (we had to edit the videos in a very particular way). This alone saved sooooo much time. Interestingly enough, we were also able to identify individual editors by the mistakes they made (it seems each one had a particular quirk).
I also ran the entire digitizing project in an Excel file, complete with burn charts and velocity calculations.
Over the years, I've received calls from every one of my employees, now on with their lives in other jobs, and one thing they're always grateful for are the Excel lessons.
And once you learn the logic behind building Excel functions and spreadsheets it opens your mind to other uses or more programming skills.
It's much easier to teach someone the power of a few choice Excel functions than to teach them Python from scratch. Plus you can see their eyes light up immediately. Fun times.
cgranier | 3 years ago | on: The first rule of Microsoft Excel: Don’t tell anyone you’re good at it
I even have an Excel spreadsheet that helps me solve Wordle.
github link: https://github.com/cgranier/tabSidian
Links to all the browser extension stores on github.