|
Set this up on your own machine.
Solution:
=-2
|
=A1+1
|
=B1+1
|
=C1+1
|
=D1+1
|
=E1+1
|
=F1+1
|
=A1+1
|
1
|
|
|
|
|
|
=A2+1
|
|
=C2*C$1+B2
|
=D2*D$1+C2
|
=E2*E$1+D2
|
=F2*F$1+E2
|
=G2*G$1+F2
|
=A3+1
|
|
=C3*C$1+B3
|
=D3*D$1+C3
|
=E3*E$1+D3
|
=F3*F$1+E3
|
=G3*G$1+F3
|
=A4+1
|
|
=C4*C$1+B4
|
=D4*D$1+C4
|
=E4*E$1+D4
|
=F4*F$1+E4
|
=G4*G$1+F4
|
=A5+1
|
|
=C5*C$1+B5
|
=D5*D$1+C5
|
=E5*E$1+D5
|
=F5*F$1+E5
|
=G5*G$1+F5
|
=A6+1
|
|
=C6*C$1+B6
|
=D6*D$1+C6
|
=E6*E$1+D6
|
=F6*F$1+E6
|
=G6*G$1+F6
|
=A7+1
|
|
=C7*C$1+B7
|
=D7*D$1+C7
|
=E7*E$1+D7
|
=F7*F$1+E7
|
=G7*G$1+F7
|
=A8+1
|
|
=C8*C$1+B8
|
=D8*D$1+C8
|
=E8*E$1+D8
|
=F8*F$1+E8
|
=G8*G$1+F8
|
=A9+1
|
|
=C9*C$1+B9
|
=D9*D$1+C9
|
=E9*E$1+D9
|
=F9*F$1+E9
|
=G9*G$1+F9
|
=A10+1
|
|
=C10*C$1+B10
|
=D10*D$1+C10
|
=E10*E$1+D10
|
=F10*F$1+E10
|
=G10*G$1+F10
|
=A11+1
|
|
=C11*C$1+B11
|
=D11*D$1+C11
|
=E11*E$1+D11
|
=F11*F$1+E11
|
=G11*G$1+F11
|
=A12+1
|
|
=C12*C$1+B12
|
=D12*D$1+C12
|
=E12*E$1+D12
|
=F12*F$1+E12
|
=G12*G$1+F12
|
=A13+1
|
|
=C13*C$1+B13
|
=D13*D$1+C13
|
=E13*E$1+D13
|
=F13*F$1+E13
|
=G13*G$1+F13
|
=A14+1
|
|
=C14*C$1+B14
|
=D14*D$1+C14
|
=E14*E$1+D14
|
=F14*F$1+E14
|
=G14*G$1+F14
|
=A15+1
|
|
=C15*C$1+B15
|
=D15*D$1+C15
|
=E15*E$1+D15
|
=F15*F$1+E15
|
=G15*G$1+F15
|
=A16+1
|
|
=C16*C$1+B16
|
=D16*D$1+C16
|
=E16*E$1+D16
|
=F16*F$1+E16
|
=G16*G$1+F16
|
=A17+1
|
|
=C17*C$1+B17
|
=D17*D$1+C17
|
=E17*E$1+D17
|
=F17*F$1+E17
|
=G17*G$1+F17
|
=A18+1
|
|
=C18*C$1+B18
|
=D18*D$1+C18
|
=E18*E$1+D18
|
=F18*F$1+E18
|
=G18*G$1+F18
|
=A19+1
|
|
=C19*C$1+B19
|
=D19*D$1+C19
|
=E19*E$1+D19
|
=F19*F$1+E19
|
=G19*G$1+F19
|
=A20+1
|
|
=C20*C$1+B20
|
=D20*D$1+C20
|
=E20*E$1+D20
|
=F20*F$1+E20
|
=G20*G$1+F20
|
|
|
=C21*C$1+B21
|
=D21*D$1+C21
|
=E21*E$1+D21
|
=F21*F$1+E21
|
=G21*G$1+F21
|
which becomes
-2
|
-1
|
0
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
-1
|
1
|
|
|
|
|
|
|
|
|
0
|
|
1
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
1
|
|
0
|
1
|
0
|
0
|
0
|
0
|
0
|
0
|
2
|
|
0
|
1
|
1
|
0
|
0
|
0
|
0
|
0
|
3
|
|
0
|
1
|
3
|
1
|
0
|
0
|
0
|
0
|
4
|
|
0
|
1
|
7
|
6
|
1
|
0
|
0
|
0
|
5
|
|
0
|
1
|
15
|
25
|
10
|
1
|
0
|
0
|
6
|
|
0
|
1
|
31
|
90
|
65
|
15
|
1
|
0
|
7
|
|
0
|
1
|
63
|
301
|
350
|
140
|
21
|
1
|
8
|
|
0
|
1
|
127
|
966
|
1701
|
1050
|
266
|
28
|
9
|
|
0
|
1
|
255
|
3025
|
7770
|
6951
|
2646
|
462
|
10
|
|
0
|
1
|
511
|
9330
|
34105
|
42525
|
22827
|
5880
|
11
|
|
0
|
1
|
1023
|
28501
|
145750
|
246730
|
179487
|
63987
|
12
|
|
0
|
1
|
2047
|
86526
|
611501
|
1379400
|
1323652
|
627396
|
13
|
|
0
|
1
|
4095
|
261625
|
3E+06
|
7508501
|
9321312
|
5715424
|
14
|
|
0
|
1
|
8191
|
788970
|
1E+07
|
40075035
|
63436373
|
49329280
|
15
|
|
0
|
1
|
16383
|
2E+06
|
4E+07
|
2.11E+08
|
4.21E+08
|
408741333
|
16
|
|
0
|
1
|
32767
|
7E+06
|
2E+08
|
1.1E+09
|
2.73E+09
|
3281882604
|
17
|
|
0
|
1
|
65535
|
2E+07
|
7E+08
|
5.65E+09
|
1.75E+10
|
25708104786
|
18
|
|
0
|
1
|
131071
|
6E+07
|
3E+09
|
2.9E+10
|
1.11E+11
|
1.97462E+11
|
19
|
|
0
|
1
|
262143
|
2E+08
|
1E+10
|
1.48E+11
|
6.93E+11
|
1.49292E+12
|
|
|