News for hackers. Stuff that matters.
Re:Like MS Excel, Pivot tables never die by bArray on Thursday October 16, 2025 @10:47AM (#45606037)
I can't find it now (would appreciate a link if somebody has one), but "pivot table" I believe was the name for a process where you would follow the intersecting points on a multi-equation graph that would represent the maximal value.

Essentially you have some maximal resource, i.e. money, and you are trying to figure out how it can be used most effectively under several constraints (don't have to be linear).

I remember distinctly having the calculate them by hand in an A-level math exam in the UK.

Re:Like MS Excel, Pivot tables never die by alphalima on Thursday October 16, 2025 @11:20AM (#45606508)
Are you talking about linear programming. https://en.wikipedia.org/wiki/Linear_programming
Re:Like MS Excel, Pivot tables never die by HPsquared on Thursday October 16, 2025 @12:24PM (#45607399)
Specifically the Simplex algorithm
Re:Like MS Excel, Pivot tables never die by bArray on Friday October 17, 2025 @08:50AM (#45616155)
I believe you are correct on the algorithm, for some reason they were called "pivot tables". Thank you for answering!
Re:Like MS Excel, Pivot tables never die by bArray on Friday October 17, 2025 @08:49AM (#45616146)
I believe this is the correct problem being solved, thank you.
Re:Like MS Excel, Pivot tables never die by hackingonempty on Thursday October 16, 2025 @11:25AM (#45606558)
Re:Like MS Excel, Pivot tables never die by adammarples on Thursday October 16, 2025 @11:20AM (#45606507)
Linear optimisation? Ie. The excel "solver"
Re:Like MS Excel, Pivot tables never die by Ylpertnodi on Thursday October 16, 2025 @11:08AM (#45606332)
* maths exam...