Spreadsheet: 763512d1642200297-determining-data-peaks-and-valleys-in-data-peaks-valleys-5pm-1-14-22
Sheet: Void

 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | A)  Column B contains my numbers smoothed using a custom Savitzky-Golay filter.  Below is a graph of the smoothed results.
Data |  | Method 1 Refers to an average in row 1982.  I keep adding data so this method won’t work.  This method does not use slope. |  | Method 2 - Using Slope
 |  |  |  |  |  |  |  | B) I believe Method 1 - Columns C & D - does a better job of identifying valleys and peaks but it is not accurate either.
 |  |  |  |  |  |  |  | C)  Issue:  The formulas used in Method 1 require that an average be calculated in row 1989.
 |  |  |  |  |  |  |  | D)  Data is constantly being added in my case, so I can’t "look ahead" as Method 1 requires and use a average that changes.
 |  |  |  |  |  |  |  | E)  I want to calculate peaks and valleys in separate columns so I can graph them as 2 different lines
 | Smoothed |  |  |  |  |  |  | F)  Columns F and G use slope and the suggested separate formulas, but the results do not match up with Method 1.
x | y | Valleys | Peaks | Slope | Valleys | Peaks
1 | 1 |  |  |  |  |  |  | G)  Visual inspection tells me Method 1 is more accurate but not entirely correct.  In column B I highlighted a few  numbers of Red.
2 | 8
3 | 11 |  |  |  |  |  |  | H)  I'd love to be able to omit theminor peaks and valleys, identified by Methods 1 and 2.
4 | 13
5 | 16 |  |  |  |  |  |  | [NAME] In C18:    IF(AND(B17>B18,B19>B18),IF(B18<$B$1989,B18,""),"")
6 | 20 |  |  |  |  |  |  | [NAME] In D18:   IF(AND(B17<B18,B19<B18),IF(B18>$B$1989,B18,""),"") |  |  |  |  |  |  |  |  |  | 24 Hour Cycles, Automatically Heating & Cooling Different Metals To Determine Amount Of Heat Absorbtion & Heat Loss
7 | 25 |  |  |  |  |  |  | [NAME] In E18:    SLOPE(B17:B18,A17:A18) |  |  |  |  |  |  |  |  |  | Time Periods Omitted Along X Axis
8 | 28 |  |  |  |  |  |  | [NAME] In F18:    IF(AND(E17<0,E18>0),B18,"") |  |  |  |  |  |  |  |  |  | Y Axis = Degrees Centigrade
9 | 27 |  |  |  |  |  |  | [NAME] In G 18:   IF(AND(E17>0,E18<0),B18,"") |  |  |  |  |  |  |  |  |  | Controlled Laboratory  Conditions
10 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "Explosions" Depict Stress Points
11 | 22
12 | 22
13 | 23
14 | 25
15 | 25
16 | 25
17 | 27
18 | 30
19 | 35
20 | 37
21 | 38
22 | 37
23 | 36
24 | 32
25 | 27
26 | 22
27 | 17
28 | 8
29 | -2
30 | -11
31 | -21
32 | -30
33 | -37
34 | -41
35 | -39
36 | -34
37 | -29
38 | -25
39 | -24
40 | -27
41 | -29
42 | -26
43 | -23
44 | -21
45 | -17
46 | -15
47 | -12
48 | -5
49 | 2
50 | 6
51 | 7
52 | 4
53 | 3
54 | 2
55 | 2
56 | -1
57 | -4
58 | -4
59 | -2
60 | 0
61 | 2
62 | 5
63 | 10
64 | 15
65 | 16
66 | 13
67 | 11
68 | 10
69 | 11
70 | 13
71 | 19
72 | 25
73 | 31
74 | 32
75 | 32
76 | 32
77 | 31
78 | 30
79 | 28
80 | 24
81 | 20
82 | 14
83 | 9
84 | 11
85 | 16
86 | 14
87 | 9
88 | 4
89 | 4
90 | 4
91 | 4
92 | 2
93 | 1
94 | 2
95 | 2
96 | 3
97 | 6
98 | 7
99 | 8
100 | 7
101 | 6
102 | 8
103 | 6
104 | -2
105 | -14
106 | -21
107 | -20
108 | -11
109 | 2
110 | 14
111 | 26
112 | 34
113 | 40
114 | 41
115 | 44
116 | 45
117 | 41
118 | 32
119 | 23
120 | 16
121 | 12
122 | 9
123 | 5
124 | 2
125 | 1
126 | 0
127 | 0
128 | 3
129 | 6
130 | 8
131 | 8
132 | 8
133 | 10
134 | 13
135 | 14
136 | 14
137 | 12
138 | 10
139 | 9
140 | 7
141 | 4
142 | 3
143 | 3
144 | 5
145 | 8
146 | 10
147 | 10
148 | 10
149 | 10
150 | 10
151 | 8
152 | 6
153 | 6
154 | 7
155 | 9
156 | 10
157 | 11
158 | 11
159 | 12
160 | 13
161 | 21
162 | 35
163 | 44
164 | 41
165 | 30
166 | 21
167 | 15
168 | 12
169 | 6
170 | 0
171 | -1
172 | 1
173 | 5
174 | 8
175 | 10
176 | 10
177 | 10
178 | 21
179 | 31
180 | 38
181 | 49
182 | 58
183 | 59
184 | 55
185 | 47
186 | 43
187 | 49
188 | 54
189 | 49
190 | 42
191 | 37
192 | 41
193 | 49
194 | 54
195 | 59
196 | 61
197 | 57
198 | 50
199 | 45
200 | 41
201 | 39
202 | 39
203 | 35
204 | 42
205 | 53
206 | 65
207 | 74
208 | 81
209 | 85
210 | 80
211 | 75
212 | 71
213 | 64
214 | 53
215 | 40
216 | 28
217 | 24
218 | 22
219 | 16
220 | 9
221 | 4
222 | 0
223 | -3
224 | -8
225 | -17
226 | -25
227 | -31
228 | -36
229 | -39
230 | -39
231 | -38
232 | -34
233 | -30
234 | -25
235 | -19
236 | -15
237 | -12
238 | -9
239 | -4
240 | 1
241 | 6
242 | 7
243 | 6
244 | 7
245 | 9
246 | 12
247 | 14
248 | 16
249 | 16
250 | 16
251 | 17
252 | 17
253 | 13
254 | 6
255 | 0
256 | -4
257 | -5
258 | -6
259 | -10
260 | -18
261 | -19
262 | -13
263 | -3
264 | 6
265 | 15
266 | 26
267 | 38
268 | 40
269 | 35
270 | 28
271 | 24
272 | 19
273 | 13
274 | 5
275 | -3
276 | -7
277 | -9
278 | -10
279 | -12
280 | -14
281 | -15
282 | -16
283 | -17
284 | -18
285 | -19
286 | -17
287 | -16
288 | -15
289 | -14
290 | -11
291 | -7
292 | -3
293 | -1
294 | -1
295 | 0
296 | 0
297 | 3
298 | 5
299 | 5
300 | 3
301 | 3
302 | 3
303 | 3
304 | 3
305 | 5
306 | 6
307 | 6
308 | 4
309 | 3
310 | 2
311 | 1
312 | 0
313 | 0
314 | 5
315 | 12
316 | 18
317 | 23
318 | 24
319 | 25
320 | 25
321 | 27
322 | 31
323 | 32
324 | 32
325 | 33
326 | 36
327 | 37
328 | 38
329 | 40
330 | 43
331 | 43
332 | 42
333 | 39
334 | 37
335 | 34
336 | 30
337 | 8
338 | -17
339 | -39
340 | -60
341 | -81
342 | -87
343 | -86
344 | -80
345 | -73
346 | -68
347 | -60
348 | -49
349 | -48
350 | -48
351 | -44
352 | -39
353 | -42
354 | -42
355 | -39
356 | -32
357 | -28
358 | -34
359 | -41
360 | -46
361 | -43
362 | -51
363 | -65
364 | -75
365 | -76
366 | -82
367 | -90
368 | -96
369 | -88
370 | -71
371 | -59
372 | -55
373 | -49
374 | -40
375 | -31
376 | -25
377 | -20
378 | -18
379 | -17
380 | -17
381 | -15
382 | -15
383 | -15
384 | -16
385 | -16
386 | -14
387 | -11
388 | -9
389 | -7
390 | -3
391 | 2
392 | 7
393 | 8
394 | 5
395 | 4
396 | 4
397 | 4
398 | 2
399 | -1
400 | -4
401 | -4
402 | -4
403 | -7
404 | -16
405 | -19
406 | -16
407 | -10
408 | -5
409 | -2
410 | -1
411 | 1
412 | 2
413 | 2
414 | 3
415 | 13
416 | 21
417 | 21
418 | 9
419 | -5
420 | -9
421 | -11
422 | -24
423 | -38
424 | -38
425 | -28
426 | -16
427 | -12
428 | -10
429 | -2
430 | 7
431 | 12
432 | 14
433 | 13
434 | 12
435 | 11
436 | 8
437 | 7
438 | 7
439 | 8
440 | 7
441 | 4
442 | 2
443 | 5
444 | 8
445 | 7
446 | 5
447 | 5
448 | 7
449 | 8
450 | 7
451 | 6
452 | 5
453 | 3
454 | 0
455 | -3
456 | -3
457 | -2
458 | -1
459 | -2
460 | -2
461 | -3
462 | -2
463 | -2
464 | -5
465 | -7
466 | -8
467 | -8
468 | -11
469 | -12
470 | -15
471 | -17
472 | -19
473 | -23
474 | -28
475 | -29
476 | -25
477 | -19
478 | -14
479 | -10
480 | -6
481 | -4
482 | -7
483 | -14
484 | -22
485 | -28
486 | -36
487 | -45
488 | -48
489 | -46
490 | -42
491 | -38
492 | -35
493 | -30
494 | -24
495 | -19
496 | -14
497 | -7
498 | 5
499 | 20
500 | 36
501 | 38
502 | 35
503 | 29
504 | 24
505 | 20
506 | 15
507 | 5
508 | -2
509 | -4
510 | -5
511 | -5
512 | -12
513 | -20
514 | -23
515 | -21
516 | -23
517 | -29
518 | -42
519 | -50
520 | -51
521 | -57
522 | -69
523 | -74
524 | -68
525 | -56
526 | -46
527 | -43
528 | -39
529 | -29
530 | -19
531 | -13
532 | -10
533 | -9
534 | -7
535 | -6
536 | -5
537 | -7
538 | -10
539 | -12
540 | -14
541 | -21
542 | -31
543 | -35
544 | -32
545 | -28
546 | -25
547 | -25
548 | -23
549 | -15
550 | -9
551 | -3
552 | 4
553 | 9
554 | 12
555 | 16
556 | 20
557 | 26
558 | 32
559 | 38
560 | 41
561 | 46
562 | 49
563 | 52
564 | 53
565 | 53
566 | 54
567 | 51
568 | 42
569 | 29
570 | 17
571 | -12
572 | -40
573 | -55
574 | -55
575 | -51
576 | -47
577 | -47
578 | -41
579 | -33
580 | -35
581 | -42
582 | -42
583 | -38
584 | -35
585 | -34
586 | -35
587 | -31
588 | -23
589 | -17
590 | -13
591 | -11
592 | -10
593 | -11
594 | -13
595 | -21
596 | -31
597 | -35
598 | -33
599 | -30
600 | -28
601 | -27
602 | -26
603 | -20
604 | -16
605 | -13
606 | -12
607 | -11
608 | -11
609 | -11
610 | -12
611 | -14
612 | -15
613 | -17
614 | -16
615 | -14
616 | -12
617 | -11
618 | -10
619 | -11
620 | -18
621 | -29
622 | -32
623 | -29
624 | -33
625 | -33
626 | -30
627 | -19
628 | -5
629 | 6
630 | 12
631 | 20
632 | 25
633 | 27
634 | 30
635 | 30
636 | 28
637 | 25
638 | 21
639 | 17
640 | 10
641 | 4
642 | 1
643 | -1
644 | -5
645 | -11
646 | -17
647 | -25
648 | -38
649 | -58
650 | -74
651 | -89
652 | -98
653 | -97
654 | -92
655 | -98
656 | -109
657 | -121
658 | -127
659 | -131
660 | -138
661 | -142
662 | -144
663 | -140
664 | -142
665 | -145
666 | -149
667 | -143
668 | -130
669 | -115
670 | -101
671 | -89
672 | -77
673 | -70
674 | -73
675 | -75
676 | -69
677 | -64
678 | -64
679 | -63
680 | -57
681 | -46
682 | -37
683 | -47
684 | -60
685 | -57
686 | -46
687 | -37
688 | -34
689 | -35
690 | -30
691 | -20
692 | -16
693 | -21
694 | -29
695 | -30
696 | -26
697 | -22
698 | -20
699 | -22
700 | -33
701 | -34
702 | -26
703 | -23
704 | -19
705 | -14
706 | -7
707 | 2
708 | 7
709 | 6
710 | 7
711 | 10
712 | 10
713 | 11
714 | 13
715 | 15
716 | 18
717 | 20
718 | 25
719 | 29
720 | 32
721 | 37
722 | 44
723 | 45
724 | 40
725 | 34
726 | 30
727 | 42
728 | 63
729 | 81
730 | 89
731 | 97
732 | 96
733 | 94
734 | 86
735 | 75
736 | 72
737 | 73
738 | 72
739 | 70
740 | 70
741 | 71
742 | 80
743 | 89
744 | 95
745 | 88
746 | 74
747 | 63
748 | 64
749 | 73
750 | 81
751 | 72
752 | 59
753 | 50
754 | 49
755 | 60
756 | 59
757 | 49
758 | 38
759 | 35
760 | 34
761 | 35
762 | 29
763 | 23
764 | 20
765 | 15
766 | 10
767 | 7
768 | 4
769 | 4
770 | 4
771 | 4
772 | 6
773 | 6
774 | 4
775 | 0
776 | -6
777 | -12
778 | -17
779 | -22
780 | -28
781 | -31
782 | -31
783 | -33
784 | -36
785 | -37
786 | -33
787 | -28
788 | -23
789 | -19
790 | -15
791 | -11
792 | -8
793 | -3
794 | 2
795 | 7
796 | 10
797 | 12
798 | 14
799 | 17
800 | 20
801 | 19
802 | 19
803 | 27
804 | 39
805 | 47
806 | 50
807 | 50
808 | 59
809 | 72
810 | 80
811 | 77
812 | 71
813 | 74
814 | 76
815 | 74
816 | 63
817 | 56
818 | 49
819 | 44
820 | 32
821 | 22
822 | 15
823 | 11
824 | 5
825 | -3
826 | -6
827 | -7
828 | -6
829 | -5
830 | -5
831 | -4
832 | -3
833 | -1
834 | 2
835 | 3
836 | 1
837 | -2
838 | -4
839 | -4
840 | -5
841 | -7
842 | -10
843 | -11
844 | -9
845 | -7
846 | -5
847 | -5
848 | -6
849 | -5
850 | -5
851 | -6
852 | -8
853 | -12
854 | -17
855 | -21
856 | -24
857 | -25
858 | -24
859 | -23
860 | -24
861 | -28
862 | -32
863 | -31
864 | -29
865 | -27
866 | -24
867 | -21
868 | -17
869 | -15
870 | -15
871 | -21
872 | -33
873 | -48
874 | -60
875 | -68
876 | -66
877 | -59
878 | -51
879 | -45
880 | -40
881 | -35
882 | -29
883 | -33
884 | -47
885 | -64
886 | -79
887 | -89
888 | -86
889 | -77
890 | -66
891 | -56
892 | -46
893 | -36
894 | -26
895 | -22
896 | -21
897 | -22
898 | -22
899 | -29
900 | -37
901 | -45
902 | -42
903 | -36
904 | -29
905 | -27
906 | -25
907 | -22
908 | -18
909 | -22
910 | -30
911 | -30
912 | -26
913 | -22
914 | -21
915 | -20
916 | -14
917 | -4
918 | 5
919 | 10
920 | 15
921 | 19
922 | 23
923 | 26
924 | 27
925 | 29
926 | 32
927 | 34
928 | 34
929 | 37
930 | 40
931 | 45
932 | 48
933 | 51
934 | 52
935 | 51
936 | 48
937 | 45
938 | 41
939 | 35
940 | 28
941 | 21
942 | 15
943 | 11
944 | 10
945 | 10
946 | 10
947 | 10
948 | 10
949 | 11
950 | 9
951 | 6
952 | 4
953 | 6
954 | 9
955 | 15
956 | 23
957 | 25
958 | 23
959 | 21
960 | 24
961 | 43
962 | 59
963 | 59
964 | 51
965 | 52
966 | 54
967 | 55
968 | 48
969 | 39
970 | 34
971 | 31
972 | 24
973 | 16
974 | 12
975 | 8
976 | 3
977 | -1
978 | -4
979 | -6
980 | -8
981 | -7
982 | -4
983 | 1
984 | 3
985 | 4
986 | 5
987 | 8
988 | 10
989 | 11
990 | 12
991 | 15
992 | 19
993 | 23
994 | 24
995 | 23
996 | 23
997 | 22
998 | 22
999 | 23
1000 | 23
1001 | 23
1002 | 22
1003 | 24
1004 | 26
1005 | 27
1006 | 31
1007 | 38
1008 | 46
1009 | 55
1010 | 62
1011 | 68
1012 | 68
1013 | 65
1014 | 65
1015 | 71
1016 | 68
1017 | 64
1018 | 54
1019 | 46
1020 | 46
1021 | 55
1022 | 58
1023 | 59
1024 | 59
1025 | 66
1026 | 68
1027 | 63
1028 | 53
1029 | 53
1030 | 51
1031 | 44
1032 | 28
1033 | 14
1034 | 7
1035 | 3
1036 | -2
1037 | -8
1038 | -9
1039 | 3
1040 | 16
1041 | 18
1042 | 11
1043 | 1
1044 | -7
1045 | -7
1046 | -7
1047 | -11
1048 | -13
1049 | -13
1050 | -12
1051 | -9
1052 | -6
1053 | -3
1054 | 1
1055 | 11
1056 | 23
1057 | 41
1058 | 53
1059 | 66
1060 | 67
1061 | 63
1062 | 57
1063 | 53
1064 | 46
1065 | 37
1066 | 27
1067 | 21
1068 | 21
1069 | 19
1070 | 18
1071 | 15
1072 | 13
1073 | 11
1074 | 10
1075 | 10
1076 | 9
1077 | 9
1078 | 9
1079 | 8
1080 | 6
1081 | 6
1082 | 7
1083 | 8
1084 | 7
1085 | 6
1086 | 5
1087 | 7
1088 | 11
1089 | 14
1090 | 17
1091 | 24
1092 | 39
1093 | 43
1094 | 39
1095 | 31
1096 | 29
1097 | 35
1098 | 36
1099 | 35
1100 | 36
1101 | 36
1102 | 45
1103 | 59
1104 | 72
1105 | 85
1106 | 96
1107 | 105
1108 | 118
1109 | 114
1110 | 100
1111 | 98
1112 | 101
1113 | 96
1114 | 94
1115 | 97
1116 | 109
1117 | 109
1118 | 88
1119 | 59
1120 | 45
1121 | 39
1122 | 33
1123 | 23
1124 | 14
1125 | 18
1126 | 35
1127 | 48
1128 | 54
1129 | 55
1130 | 53
1131 | 61
1132 | 73
1133 | 76
1134 | 72
1135 | 69
1136 | 72
1137 | 71
1138 | 63
1139 | 55
1140 | 56
1141 | 52
1142 | 45
1143 | 33
1144 | 26
1145 | 24
1146 | 21
1147 | 16
1148 | 12
1149 | 9
1150 | 8
1151 | 16
1152 | 32
1153 | 48
1154 | 55
1155 | 56
1156 | 51
1157 | 46
1158 | 43
1159 | 50
1160 | 60
1161 | 69
1162 | 68
1163 | 71
1164 | 80
1165 | 80
1166 | 71
1167 | 58
1168 | 50
1169 | 51
1170 | 46
1171 | 31
1172 | 15
1173 | 6
1174 | -1
1175 | -5
1176 | -11
1177 | -17
1178 | -19
1179 | -18
1180 | -17
1181 | -15
1182 | -12
1183 | -9
1184 | -11
1185 | -14
1186 | -16
1187 | -17
1188 | -18
1189 | -23
1190 | -29
1191 | -29
1192 | -25
1193 | -17
1194 | -10
1195 | -10
1196 | -17
1197 | -18
1198 | -12
1199 | -4
1200 | 0
1201 | -1
1202 | 1
1203 | 12
1204 | 24
1205 | 33
1206 | 43
1207 | 43
1208 | 50
1209 | 61
1210 | 72
1211 | 78
1212 | 82
1213 | 83
1214 | 75
1215 | 62
1216 | 46
1217 | 35
1218 | 26
1219 | 18
1220 | 6
1221 | -3
1222 | -8
1223 | -10
1224 | -12
1225 | -14
1226 | -18
1227 | -22
1228 | -26
1229 | -26
1230 | -25
1231 | -25
1232 | -27
1233 | -32
1234 | -35
1235 | -37
1236 | -37
1237 | -38
1238 | -40
1239 | -41
1240 | -40
1241 | -36
1242 | -33
1243 | -30
1244 | -27
1245 | -23
1246 | -19
1247 | -15
1248 | -12
1249 | -10
1250 | -10
1251 | -9
1252 | -10
1253 | -11
1254 | -12
1255 | -11
1256 | -7
1257 | -1
1258 | 3
1259 | 6
1260 | 9
1261 | 12
1262 | 11
1263 | 7
1264 | 2
1265 | -3
1266 | -8
1267 | -13
1268 | -17
1269 | -17
1270 | -14
1271 | -10
1272 | -4
1273 | 5
1274 | 24
1275 | 52
1276 | 74
1277 | 72
1278 | 61
1279 | 54
1280 | 55
1281 | 56
1282 | 54
1283 | 52
1284 | 49
1285 | 45
1286 | 38
1287 | 30
1288 | 23
1289 | 15
1290 | 5
1291 | -4
1292 | -12
1293 | -17
1294 | -20
1295 | -21
1296 | -21
1297 | -22
1298 | -23
1299 | -26
1300 | -28
1301 | -28
1302 | -26
1303 | -24
1304 | -23
1305 | -23
1306 | -19
1307 | -14
1308 | -11
1309 | -13
1310 | -15
1311 | -17
1312 | -17
1313 | -20
1314 | -29
1315 | -44
1316 | -54
1317 | -51
1318 | -43
1319 | -38
1320 | -35
1321 | -32
1322 | -25
1323 | -29
1324 | -43
1325 | -52
1326 | -60
1327 | -58
1328 | -65
1329 | -77
1330 | -81
1331 | -69
1332 | -56
1333 | -44
1334 | -40
1335 | -37
1336 | -31
1337 | -26
1338 | -24
1339 | -30
1340 | -37
1341 | -49
1342 | -54
1343 | -50
1344 | -40
1345 | -32
1346 | -24
1347 | -19
1348 | -15
1349 | -22
1350 | -38
1351 | -56
1352 | -66
1353 | -69
1354 | -76
1355 | -84
1356 | -80
1357 | -67
1358 | -50
1359 | -35
1360 | -25
1361 | -13
1362 | -3
1363 | 2
1364 | 5
1365 | 8
1366 | 10
1367 | 12
1368 | 12
1369 | 14
1370 | 18
1371 | 21
1372 | 22
1373 | 23
1374 | 25
1375 | 24
1376 | 18
1377 | 11
1378 | 5
1379 | 2
1380 | -1
1381 | -4
1382 | -6
1383 | -7
1384 | -8
1385 | -7
1386 | -6
1387 | -3
1388 | 1
1389 | 4
1390 | 7
1391 | 8
1392 | 9
1393 | 9
1394 | 8
1395 | 6
1396 | 3
1397 | -1
1398 | -2
1399 | -3
1400 | -4
1401 | -5
1402 | -6
1403 | -5
1404 | -3
1405 | -2
1406 | -3
1407 | -7
1408 | -12
1409 | -17
1410 | -22
1411 | -25
1412 | -28
1413 | -29
1414 | -29
1415 | -28
1416 | -28
1417 | -30
1418 | -35
1419 | -41
1420 | -42
1421 | -41
1422 | -40
1423 | -45
1424 | -49
1425 | -51
1426 | -47
1427 | -42
1428 | -39
1429 | -31
1430 | -9
1431 | 19
1432 | 32
1433 | 32
1434 | 28
1435 | 32
1436 | 42
1437 | 48
1438 | 42
1439 | 34
1440 | 29
1441 | 26
1442 | 23
1443 | 17
1444 | 9
1445 | 3
1446 | 1
1447 | -1
1448 | -3
1449 | -4
1450 | -3
1451 | -1
1452 | 1
1453 | 2
1454 | 3
1455 | 5
1456 | 8
1457 | 10
1458 | 11
1459 | 12
1460 | 13
1461 | 14
1462 | 13
1463 | 12
1464 | 9
1465 | 4
1466 | 0
1467 | -4
1468 | -7
1469 | -10
1470 | -12
1471 | -12
1472 | -12
1473 | -11
1474 | -11
1475 | -14
1476 | -18
1477 | -18
1478 | -15
1479 | -10
1480 | -8
1481 | -6
1482 | -3
1483 | 1
1484 | 3
1485 | 1
1486 | 1
1487 | 3
1488 | 6
1489 | 8
1490 | 9
1491 | 9
1492 | 13
1493 | 18
1494 | 23
1495 | 28
1496 | 31
1497 | 35
1498 | 44
1499 | 53
1500 | 52
1501 | 48
1502 | 52
1503 | 61
1504 | 64
1505 | 56
1506 | 45
1507 | 55
1508 | 68
1509 | 68
1510 | 67
1511 | 68
1512 | 66
1513 | 60
1514 | 50
1515 | 40
1516 | 37
1517 | 29
1518 | 16
1519 | 7
1520 | 3
1521 | 1
1522 | -2
1523 | -7
1524 | -9
1525 | -8
1526 | -7
1527 | -8
1528 | -11
1529 | -14
1530 | -13
1531 | -11
1532 | -11
1533 | -11
1534 | -11
1535 | -10
1536 | -9
1537 | -9
1538 | -11
1539 | -11
1540 | -10
1541 | -8
1542 | -6
1543 | -4
1544 | -3
1545 | 0
1546 | 5
1547 | 12
1548 | 19
1549 | 23
1550 | 23
1551 | 23
1552 | 24
1553 | 28
1554 | 33
1555 | 36
1556 | 38
1557 | 41
1558 | 44
1559 | 49
1560 | 55
1561 | 64
1562 | 63
1563 | 57
1564 | 47
1565 | 41
1566 | 37
1567 | 34
1568 | 28
1569 | 24
1570 | 23
1571 | 23
1572 | 23
1573 | 29
1574 | 39
1575 | 47
1576 | 44
1577 | 38
1578 | 40
1579 | 49
1580 | 56
1581 | 51
1582 | 40
1583 | 29
1584 | 27
1585 | 5
1586 | -19
1587 | -41
1588 | -47
1589 | -52
1590 | -60
1591 | -67
1592 | -69
1593 | -73
1594 | -69
1595 | -59
1596 | -45
1597 | -34
1598 | -30
1599 | -29
1600 | -22
1601 | -17
1602 | -16
1603 | -17
1604 | -18
1605 | -20
1606 | -21
1607 | -22
1608 | -23
1609 | -29
1610 | -36
1611 | -43
1612 | -48
1613 | -47
1614 | -42
1615 | -39
1616 | -36
1617 | -33
1618 | -30
1619 | -27
1620 | -23
1621 | -21
1622 | -19
1623 | -16
1624 | -13
1625 | -9
1626 | -4
1627 | 1
1628 | 4
1629 | 8
1630 | 10
1631 | 10
1632 | 10
1633 | 11
1634 | 13
1635 | 16
1636 | 19
1637 | 22
1638 | 25
1639 | 29
1640 | 30
1641 | 29
1642 | 26
1643 | 24
1644 | 23
1645 | 25
1646 | 27
1647 | 28
1648 | 29
1649 | 28
1650 | 24
1651 | 20
1652 | 14
1653 | 9
1654 | 4
1655 | -2
1656 | -6
1657 | -7
1658 | -6
1659 | -9
1660 | -14
1661 | -18
1662 | -22
1663 | -13
1664 | -5
1665 | 0
1666 | 0
1667 | 5
1668 | 15
1669 | 28
1670 | 30
1671 | 26
1672 | 32
1673 | 45
1674 | 58
1675 | 63
1676 | 66
1677 | 75
1678 | 86
1679 | 86
1680 | 77
1681 | 64
1682 | 53
1683 | 45
1684 | 36
1685 | 25
1686 | 14
1687 | 6
1688 | 0
1689 | -2
1690 | -2
1691 | 1
1692 | 3
1693 | 6
1694 | 8
1695 | 10
1696 | 13
1697 | 17
1698 | 18
1699 | 18
1700 | 18
1701 | 15
1702 | 11
1703 | 6
1704 | 0
1705 | -6
1706 | -11
1707 | -17
1708 | -23
1709 | -29
1710 | -34
1711 | -38
1712 | -37
1713 | -35
1714 | -32
1715 | -29
1716 | -27
1717 | -23
1718 | -17
1719 | -10
1720 | -4
1721 | 0
1722 | 3
1723 | 8
1724 | 12
1725 | 12
1726 | 8
1727 | 0
1728 | -8
1729 | -15
1730 | -24
1731 | -31
1732 | -31
1733 | -29
1734 | -26
1735 | -28
1736 | -33
1737 | -35
1738 | -32
1739 | -28
1740 | -27
1741 | -19
1742 | -7
1743 | 7
1744 | 25
1745 | 48
1746 | 69
1747 | 74
1748 | 67
1749 | 57
1750 | 51
1751 | 44
1752 | 33
1753 | 17
1754 | 5
1755 | -2
1756 | -6
1757 | -8
1758 | -9
1759 | -10
1760 | -10
1761 | -9
1762 | -7
1763 | -5
1764 | -3
1765 | -3
1766 | -2
1767 | -1
1768 | -1
1769 | -1
1770 | 0
1771 | 1
1772 | 4
1773 | 8
1774 | 12
1775 | 17
1776 | 23
1777 | 25
1778 | 24
1779 | 20
1780 | 14
1781 | 8
1782 | 0
1783 | -9
1784 | -18
1785 | -24
1786 | -26
1787 | -25
1788 | -24
1789 | -24
1790 | -23
1791 | -21
1792 | -20
1793 | -19
1794 | -19
1795 | -27
1796 | -45
1797 | -70
1798 | -85
1799 | -98
1800 | -94
1801 | -85
1802 | -87
1803 | -97
1804 | -105
1805 | -96
1806 | -78
1807 | -76
1808 | -91
1809 | -104
1810 | -108
1811 | -108
1812 | -112
1813 | -123
1814 | -123
1815 | -108
1816 | -91
1817 | -83
1818 | -82
1819 | -91
1820 | -97
1821 | -95
1822 | -93
1823 | -95
1824 | -98
1825 | -101
1826 | -107
1827 | -114
1828 | -121
1829 | -114
1830 | -98
1831 | -82
1832 | -74
1833 | -67
1834 | -57
1835 | -45
1836 | -37
1837 | -34
1838 | -32
1839 | -29
1840 | -25
1841 | -22
1842 | -22
1843 | -21
1844 | -19
1845 | -16
1846 | -15
1847 | -14
1848 | -14
1849 | -13
1850 | -12
1851 | -10
1852 | -7
1853 | -4
1854 | 0
1855 | 3
1856 | 6
1857 | 10
1858 | 11
1859 | 11
1860 | 7
1861 | 2
1862 | -4
1863 | -9
1864 | -14
1865 | -20
1866 | -32
1867 | -45
1868 | -55
1869 | -60
1870 | -58
1871 | -53
1872 | -50
1873 | -48
1874 | -51
1875 | -56
1876 | -51
1877 | -42
1878 | -35
1879 | -30
1880 | -27
1881 | -22
1882 | -14
1883 | -8
1884 | -4
1885 | -1
1886 | 3
1887 | 6
1888 | 7
1889 | 6
1890 | 4
1891 | 2
1892 | -3
1893 | -15
1894 | -31
1895 | -38
1896 | -49
1897 | -44
1898 | -34
1899 | -22
1900 | -12
1901 | -4
1902 | -2
1903 | 2
1904 | 4
1905 | 1
1906 | -1
1907 | -1
1908 | -2
1909 | -4
1910 | -19
1911 | -37
1912 | -52
1913 | -55
1914 | -50
1915 | -43
1916 | -39
1917 | -35
1918 | -27
1919 | -19
1920 | -9
1921 | 0
1922 | 6
1923 | 12
1924 | 15
1925 | 18
1926 | 24
1927 | 30
1928 | 32
1929 | 31
1930 | 27
1931 | 24
1932 | 23
1933 | 21
1934 | 19
1935 | 19
1936 | 18
1937 | 18
1938 | 19
1939 | 19
1940 | 19
1941 | 20
1942 | 21
1943 | 26
1944 | 34
1945 | 43
1946 | 50
1947 | 51
1948 | 50
1949 | 46
1950 | 42
1951 | 35
1952 | 27
1953 | 19
1954 | 15
1955 | 13
1956 | 13
1957 | 16
1958 | 28
1959 | 44
1960 | 48
1961 | 41
1962 | 32
1963 | 28
1964 | 27
1965 | 22
1966 | 11
1967 | 0
1968 | -8
1969 | -15
1970 | -17
1971 | -17
1972 | -17
1973 | -15
X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X