Anti-lulz
1 06 2008Those other things are still up (plotter, graphics, recursion) and this is an Excel spreadsheet which I used to do a bunch of simultaneous equations to determine that the sum from r=1 to n of r4 is n5/5 + n4/2 + n3/3 - n/30. I’ll simplify that later I suppose.
The idea was that the sum of rp can be expressed as a polynomial of order p + 1, so I just got 5 simultaneous equations involving the 5 coefficients of the quintic expression and got Excel to solve them in an “algorithmic” way similar to the triangular form thing we have to do.
I was revising FP1 and the sections on triangular form and summations of rp “inspired” me to do this.
Pax






[...] the algorithmic techniques already. I made a spreadsheet to solve the equations in a way similar to my sum of r4 thing so when you enter two points (x co-ord, y co-ord, gradient at that point), it tells you the [...]