Emicly, wow.

Also, from work! My boss's boss (probably the equivalent of a step under owning an entire national business) believes that the definition of "land-locked" is having no floor space. Landlocked means...well...look it up. Long story short, that's not what it means

Also, I have to update this Excel spreadsheet that has a bunch of info on it for a model. Which basically means I opened it and went like "Damn. Not only are half the numbers wrong, there's a crapload of useless or redundant info."

Two pairs of sheets were redundant. One of those pairs had this magical reference "map" (did trace dependents) on ONE cell in each sheet. (Obscured "sensitive" info that no one would use ever)


I'm fixing that mess. Technically twice. Yayyyyyyy...y.

Edit: So there's a lot more wrong with this sheet than what I've mentioned/shown. For example, the Summary sheet is referenced in the calculation sheets. Several times. Repeat...the Summary (results, end product) is referenced by the calculation sheets (process) as inputs. The original writer also couldn't decide whether or not to lock column references whenever he wrote code, so copy-pasting or dragging cells across to new columns will alternatively work or not work. Despite having a general information tab for cells to reference, he allows the user to change equipment specs on the calculation sheets. The equipment info was completely different on the calculation sheets and the eqpmt spec sheet. Aaaaaand, the original writer is the equivalent of my boss's boss.