Remix.run Logo
sgarland 2 days ago

You can do horrifying and amazing things with Excel. Samsung’s Austin fab, at least circa 2020-ish, was generating machine labels with it. These are paper cards, roughly 2” x 4”, which carry the following information:

* Machine name / number

* Owning technician’s name, shift, photo, and phone number

* Owning engineer’s name, shift, photo, and phone number

My team had something like 250 machines spread across 4 shifts. We had to redo cards anytime we gained or lost someone on any team, which often included rebalancing the workload. Luckily, someone had made an Excel macro that connected to a MSSQL DB that had employee information (IIRC, it didn’t have confidential information like pay in it; I think it was used for generating badges), pulled all of the required fields, and automatically filled the template. Send them to the printer, cut them apart, and go place them.

My contribution while there was to implement a crude pathing optimization that tried to assign contiguous machines to a given technician, to minimize the amount they had to walk for weekly checks. It kinda worked; better than nothing, anyway.

2PqboPPmKegvanx 2 days ago | parent | next [-]

>You can do horrifying and amazing things with Excel.

I've never seen a better explanation of the tool than that one sentence

spider-mario 2 days ago | parent [-]

“After all, He-Who-Must-Not-Be-Named did great things – terrible, yes, but great.”

kevin_thibedeau 2 days ago | parent | prev | next [-]

This should have either been a Word template that used mail merge to insert the data into fields or an Access form.

  Checklist:
   #1 Are you doing calculations?
    Yes: Use a spreadsheet
    No: Use another tool
kccqzy 2 days ago | parent | next [-]

Yeah. People usually forget that Word also supports tables. In my experience people think, I need tables therefore it’s Excel.

sgarland 2 days ago | parent [-]

Tbf trying to position things in Word is enraging. I get the appeal of having an explicit grid.

kccqzy 2 days ago | parent | next [-]

This is another thing Apple does right. Pages allows you to turn off the inline text and use only absolutely positioned non-floating text boxes. In this mode It’s more similar to desktop publishing tools than word processing tools.

sgarland 2 days ago | parent [-]

Really? That’s awesome! I’ve never bothered to use it, because GSuite is right there, but I will definitely keep that in mind.

kevin_thibedeau 2 days ago | parent | prev [-]

Access gives you an explicit grid in its report designer.

mpyne 2 days ago | parent [-]

Excel is already a solid grid without a separate report designer being necessary.

kevin_thibedeau 2 days ago | parent [-]

Except the OP had to write VBA code to link it to a database. That is almost guaranteed to be a brittle solution with hardcoded cell IDs.

pc86 2 days ago | parent | prev [-]

I mean nothing should be an Access form, ever. :)

dismalaf 2 days ago | parent [-]

After learning Access in university I agree. Just toss it into the ocean...

mcphage 2 days ago | parent | prev | next [-]

> You can do horrifying and amazing things with Excel. Samsung’s Austin fab, at least circa 2020-ish, was generating machine labels with it.

Generating machine labels seems useful, but I don't think that feels particularly horrifying or amazing. Just like, yeah, that's something it should be able to do.

EdwardDiego 2 days ago | parent | prev | next [-]

A former coworker was previously employed in high finance in London, his entire job was keeping the rickety lattice of interlinked spreadsheets across the company working and alive. People would type in a number in one spreadsheet, and after several hours, another number would appear via the lattice in a more influential spreadsheet.

The company made money, so it worked, but he swears is caused him to start prematurely balding. Maybe a convenient excuse, but also plausible.

flobosg 2 days ago | parent | prev [-]

> You can do horrifying and amazing things with Excel.

A friend of mine writes all of their correspondence in it.

saysjonathan 2 days ago | parent [-]

Can you expand more on this? Is it just for drafts or do they track all their correspondence in Excel?

flobosg 2 days ago | parent [-]

They literally compose and print their letters in Excel.