Siamese method

 

Put digit 1 in the middle of the top row. Put the digits 2 up to n (= length of the square) each time one cell diagonal up and to the right. Put digit n+1 below digit n. Put the digits n+2 up to 2n each time one cell diagonal up and to the right. Put digit 2n+1 below digit 2n. Etcetera ...

 

 

13x13 symmetric magic square

93 108 123 138 153 168 1 16 31 46 61 76 91
107 122 137 152 167 13 15 30 45 60 75 90 92
121 136 151 166 12 14 29 44 59 74 89 104 106
135 150 165 11 26 28 43 58 73 88 103 105 120
149 164 10 25 27 42 57 72 87 102 117 119 134
163 9 24 39 41 56 71 86 101 116 118 133 148
8 23 38 40 55 70 85 100 115 130 132 147 162
22 37 52 54 69 84 99 114 129 131 146 161 7
36 51 53 68 83 98 113 128 143 145 160 6 21
50 65 67 82 97 112 127 142 144 159 5 20 35
64 66 81 96 111 126 141 156 158 4 19 34 49
78 80 95 110 125 140 155 157 3 18 33 48 63
79 94 109 124 139 154 169 2 17 32 47 62 77

 

 

You can use this method to construct magic squares of odd order from 3x3 to infinite and you get a symmetric (but not pan)magic square.

 

 

Download
13x13, Siamese method.xls
Microsoft Excel werkblad 9.9 KB