This is a continuation of an entry last March on Ramanujan and the sums of two cubes. If the title makes no sense, start there.
This expands the list of solutions, and below it, I reveal my Diophantine approach to spreadsheets. I should note here that one of my most successful fraud investigations (the precise details of the client remain commercial-in-confidence) only worked because I used a spreadsheet to divine the cunning way a wages swindle was being run.
All I needed was a stapler and a pie chart, but to find out how I managed to get the data and wring out the answer, you need to ply me with beer.If you make it a Guinness, I will also throw in a practical demonstration of isostasy: look behind the harp in this shot, and see if you can spot it.
Anyhow, here are my solutions:
-9728: 163 + -243;
-123 + -203
-7657: -203 + 73;
-173 + -143
-6832: -193 + 33;
-183 + -103
-5859: -183 + -33;
-193 + 103
-5824: -183 + 23;
-163 + -123
-5256: -173 + -73;
-203 + 143
-5103:-153 + -123;
-183 + 93
-4104: -153 + -93; -163 + -23; -183 + 123 TRIPLE!
-3367: -163 + 93;
-153 + 23
-3087: -143 + -73;
-203 + 173
-2457: -183 + 153;
-123 + -93
-1736: -123 + -23;
-183 + 163
-1729: -93 + -103;
-13 + -123
-1512: -103 + -83;
-123 + 63
-1216: -123 + 83;
-103 + -63
-1027: -193 + 183;
-103 + -33
-999: -123 + 93;
-103 + 13
-728: -123 + 103;
-93 + 13; -83 + -63 TRIPLE!
-721: -163 + 153;
-93 + 23
-513: -93 + 63;
-83 + -13
-217: -63 + -13;
-93 + 83
-189: -63 + 33;
-53 + -4
-152: -53 + -33;
-63 + 43
-91: -43 + -33;
-63 + 53
91: 43 + 33;
63 + -53
152: 53 + 33;
63 + -43
189: 63 + -33;
53 + 4
217: 63 + 13;
93 + -83
513: 93 + -63;
83 + 13
721: 163 + -153;
93 + -23
728: 123 + -103;
93 + -13; 83 + 63 TRIPLE!
999: 123 + -93;
103 + -13
1027: 193 + -183;
103 + 33
1216: 123 + -83;
103 + 63
1512: 103 + 83;
123 + -63
1729: 93 + 103;
13 + 123
1736: 123 + 23;
183 + -163
2457: 183 + -153;
123 + 93
3087: 143 + 73;
203 + -173
3367: 163 + -93;
153 + -23
4104: 153 + 93;
163 + 23; 183 + -123 TRIPLE
5103:153 + 123;
183 + -93
5256: 173 + 73;
203 + -143
5824: 183 + -23;
163 + 123
5859: 183 + 33;
193 + -103
6832: 193 + -33;
183 + 103
7657: 203 + -73;
173 + 143
9728: -163 + 243;
123 + 203
Here is the base spreadsheet that spat out all the sums of two cubes where the source numbers were -20 to 20:
This is a bit kludgy, but once row 2 was done, I could use FILL-DOWN.
Next, I copied all of the sums of two cubes into a document, sorted them into order, and pasted them into column A of a fresh spreadsheet in column A. Column B had in B2 =IF(A1=A2, "hit","").
Next, I deleted the non-hit rows, and knew what to look for: here's a sample of the target list:
Now I was ready to search the first spreadsheet, and this was where I copied Diophantus. I might have come up with a routine that did it for me, but it was faster and less brain-damaging just to hack away.
I have been known to sneer at geography a colouring-in, but as I am colour blind, I think I'm allowed to do that. Anyhow, I used colouring-in to pin down my pairs:
All that remained to do now was to check the cells and enter the source values, but as I was doing this manually, I set a check in column E, where E1 read =C1*C1*C1+D1*D1*D1, followed by COPY-DOWN.
There was a time when hacking was an honourable activity, when the Kalashnikov rifle was described as a hack, and my fraud-busting spreadsheet was most emphatically a hack. We cannot turn the linguistic clock back to save hack, but we can at least try to make recreational computing respectable again!
No comments:
Post a Comment