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