Spreadsheet: 867825d1714626555-calculating-a-percentage-based-on-rows-above-and-below-column-k-2-aligw
Sheet: Sheet1

2824 |  | B0 |  |  |  |  |  | R | 0.2
2825 |  | B0 |  |  |  |  |  | R | 0.2 |  |  |  | 0.2 | 0.2
2826 |  | B0 |  |  |  |  |  | R | 0.15 |  |  |  | 0.15 | 0.15
2827 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2829 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2830 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2832 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2833 |  | B0 |  |  |  |  |  | R | 0.15 |  |  |  | 0.15 | 0.15
2834 |  | B0 |  |  |  |  |  | R | 0.15 |  |  |  | 0.15 | 0.15
2837 |  | B0 |  |  |  |  |  | R | 0.143 |  |  |  | 0.1428571428571428 | 0.143
2839 |  | B5 |  |  |  |  |  | R | 0.136 |  |  |  | 0.1363636363636364 | 0.136
2842 |  | B5 |  |  |  |  |  | R | 0.087 |  |  |  | 0.08695652173913043 | 0.087
2843 |  | B0 |  |  |  |  |  | R | 0.083 |  |  |  | 0.08333333333333333 | 0.083
2846 |  | B0 |  |  |  |  |  | R | 0.08 |  |  |  | 0.08 | 0.08
2848 |  | B0 |  |  |  |  |  | R | 0.077 |  |  |  | 0.07692307692307693 | 0.077
2851 |  | B0 |  |  |  |  |  | R | 0.111 |  |  |  | 0.1111111111111111 | 0.111
2853 |  | B0 |  |  |  |  |  | R | 0.107 |  |  |  | 0.1071428571428571 | 0.107
2854 |  | B0 |  |  |  |  |  | R | 0.103 |  |  |  | 0.103448275862069 | 0.103
2855 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2856 |  | B2 |  |  |  |  |  | R | 0.129 |  |  |  | 0.1290322580645161 | 0.129
2858 |  | B0 |  |  |  |  |  | R | 0.125 |  |  |  | 0.125 | 0.125
2862 |  | B0 |  |  |  |  |  | R | 0.121 |  |  |  | 0.1212121212121212 | 0.121
2865 |  | B0 |  |  |  |  |  | R | 0.117 |  |  |  | 0.1176470588235294 | 0.118
2866 |  | B0 |  |  |  |  |  | R | 0.114 |  |  |  | 0.1142857142857143 | 0.114
2871 |  | B0 |  |  |  |  |  | R | 0.111 |  |  |  | 0.1111111111111111 | 0.111
2874 |  | B0 |  |  |  |  |  | R | 0.108 |  |  |  | 0.1081081081081081 | 0.108
2876 |  | B0 |  |  |  |  |  | R | 0.105 |  |  |  | 0.1052631578947368 | 0.105
2877 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.07692307692307693 | 0.077
2879 |  | B5 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2880 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2883 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2884 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2885 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2886 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2889 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2892 |  | B5 |  |  |  |  |  | R | 0.0769 |  |  |  | 0.075 | 0.075
2893 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.075 | 0.075
2895 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2896 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2897 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.075 | 0.075
2898 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2902 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2903 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2904 |  | B3 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2907 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.075 | 0.075
2908 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.075 | 0.075
2911 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.075 | 0.075
2912 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.075 | 0.075
2913 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2915 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2920 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2921 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2922 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.075 | 0.075
2923 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.075 | 0.075
2925 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.075 | 0.075
2927 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.075 | 0.075
2928 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.075 | 0.075
2929 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2930 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2931 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2932 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2934 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2935 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2936 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2937 |  | B0 |  |  |  |  |  | R | 0.025 |  |  |  | 0.025 | 0.025
2938 |  | B0 |  |  |  |  |  | R | 0.025 |  |  |  | 0.025 | 0.025
2939 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2940 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2941 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2942 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2943 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2944 |  | B0 |  |  |  |  |  | R | 0.075 |  |  |  | 0.075 | 0.075
2945 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2946 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2947 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2948 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2949 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2950 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2951 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2952 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2953 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2954 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2955 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2956 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2957 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2958 |  | B0 |  |  |  |  |  | R | 0.05 |  |  |  | 0.05 | 0.05
2959 |  | B0 |  |  |  |  |  | R | 0.025 |  |  |  | 0.025 | 0.025
2960 |  | B0 |  |  |  |  |  | R | 0.025 |  |  |  | 0.025 | 0.025
2961 |  | B0 |  |  |  |  |  | R | 0.025 |  |  |  | 0.025 | 0.025
2962 |  | B0 |  |  |  |  |  | R | 0.02564 |  |  |  | 0.02564102564102564 | 0.026
2963 |  | B0 |  |  |  |  |  | R | 0.02631 |  |  |  | 0.02631578947368421 | 0.026
2964 |  | B0 |  |  |  |  |  | R | 0 |  |  |  | 0 | 0
2965 |  | B0 |  |  |  |  |  | R | 0 |  |  |  | 0 | 0
2966 |  | B0 |  |  |  |  |  | R | 0 |  |  |  | 0 | 0
2967 |  | B2 |  |  |  |  |  | R | 0 |  |  |  | 0 | 0
2968 |  | B0 |  |  |  |  |  | R | 0 |  |  |  | 0 | 0
2969 |  | B0 |  |  |  |  |  | R | 0 |  |  |  | 0 | 0
2970 |  | B0 |  |  |  |  |  | R | 0 |  |  |  | 0 | 0
2971 |  | B0 |  |  |  |  |  | R | 0 |  |  |  | 0 | 0
2972 |  | B3 |  |  |  |  |  | R | 0 |  |  |  | 0 | 0
2973 |  | B0 |  |  |  |  |  | R | 0 |  |  |  | 0 | 0
2974 |  | B0 |  |  |  |  |  | R | 0 |  |  |  | 0 | 0
2975 |  | B0 |  |  |  |  |  | R | 0 |  |  |  | 0 | 0
2976 |  | B0 |  |  |  |  |  | R | 0.04 |  |  |  | 0.04 | 0.04
2977 |  | B0 |  |  |  |  |  | R | 0.042 |  |  |  | 0.04166666666666666 | 0.042
2978 |  | B0 |  |  |  |  |  | R | 0.043 |  |  |  | 0.04347826086956522 | 0.043
2979 |  | B0 |  |  |  |  |  | R | 0.045 |  |  |  | 0.04545454545454546 | 0.045
2980 |  | B0 |  |  |  |  |  | R | 0.048 |  |  |  | 0.04761904761904762 | 0.048
2981 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2982 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2983 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2984 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2985 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2986 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2987 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2988 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1
2989 |  | B0 |  |  |  |  |  | R | 0.1 |  |  |  | 0.1 | 0.1