Search This Blog

Sunday 30 October 2022

The sum of two cubes in two different ways

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; -12+ -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; 12+ 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.


My book of STEAM activities for bright young minds, Playwiths, has a number of labour-saving ideas involving spreadsheets, and about 1729 and Ramanujan, but now I need to add some extra stuff, based on what I have written here.

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