VDB function and half-year convention

joebobjoe · Oct 30, 2011

I'm doing a project for an engineering economy class and part of it requires calculating the MACRS depreciation in year n. We are expected to use double-declining balance switching to SL depreciation with the half-year convention and I just don't understand why VDB doesn't work. My results don't match the MACRS table on Wikipedia: http://en.wikipedia.org/wiki/MACRS#MACRS_applicable_percentage_for_property_class.

For example, =VDB(100,0,5,1,2,2,FALSE) = $24.00, not $32.00 as in the table. Can someone help? I've scoured Google and I can't find what I'm doing wrong.

Derek Brown · Oct 31, 2011

Hello and welcome to The Board.
I won't even pretend to know what you are talking about but hopefully this reply will bring your question back to the front page where someone who can help, sees it.
Entering that formula in my workbook using Excel 2010 gives the result of £24.00.
The following may also be of interest:
http://support.microsoft.com/kb/819437
http://www.mrexcel.com/forum/showthread.php?t=72491

xenou · Oct 31, 2011

I've never been able to replicate MACRS using Excel's VDB(). I haven't tried for years - I guess it's possible somehow. You have to play around with the years to get the half-year convention going, then fiddle with the switch to straight line too. The lack of a half-year convention in VDB means you can't do it with VDB() alone - you'd need a schedule, or at least some series of tweaked VDB() formulas that would imitate the effects of a schedule to account for the half years at the beginning and the end. I find it easier to use a simple Double Declining Balance schedule the old fashioned way:

Excel Workbook

A

B

C

D

1

Cost Basis

DDB

Periods (Years)

Depreciation

2

$100.00

0.5

3

1

4

1

5

1

6

1

7

0.5

8

TOTALS

5

$100.00

Sheet1

Note that you *can* get the correct value for year one with VDB() by taking a full first year's depreciation with VDB() formula, and dividing it in half to make a half-year of depreciation.
=0.5*VDB(100,0,5,0,1,2,FALSE)
Result is $20 as expected.

What get's a little confusing after that is that the next year is really the last half of year 1 and the first half of year 2, and so on ... until you switch to straight line, which is where I'm afraid I gave up, at least for tonight

jmayer · Nov 29, 2011

MACRS, including half year convention and all, is actually pretty straightforward to do in Excel, using VDB.

Here's an example that should help:

Excel 2007<table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2002</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2003</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2004</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2005</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2006</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2007</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2008</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2009</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2010</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2011</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2012</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2013</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2014</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2015</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2016</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2017</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2018</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2019</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;;">2020</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">Capex</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;border-top: 1px solid black;color: #0000FF;;"> 100 </td><td style="text-align: right;border-top: 1px solid black;color: #0000FF;;"> 100 </td><td style="text-align: right;border-top: 1px solid black;color: #0000FF;;"> 50 </td><td style="text-align: right;border-top: 1px solid black;color: #0000FF;;"> 50 </td><td style="text-align: right;border-top: 1px solid black;color: #0000FF;;"> 20 </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td><td style="text-align: right;border-top: 1px solid black;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">Depreciation (MACRS)</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> 14 </td><td style="text-align: right;;"> 39 </td><td style="text-align: right;;"> 49 </td><td style="text-align: right;;"> 49 </td><td style="text-align: right;;"> 45 </td><td style="text-align: right;;"> 38 </td><td style="text-align: right;;"> 32 </td><td style="text-align: right;;"> 25 </td><td style="text-align: right;;"> 15 </td><td style="text-align: right;;"> 8 </td><td style="text-align: right;;"> 4 </td><td style="text-align: right;;"> 1 </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;color: #0000FF;;"></td><td style="text-align: right;color: #0000FF;;"></td><td style="text-align: right;color: #0000FF;;"></td><td style="text-align: right;color: #0000FF;;"></td><td style="text-align: right;color: #0000FF;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Half Yr Convention</td><td style="text-align: right;color: #0000FF;;">On</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="font-weight: bold;text-decoration: underline;;">MACRS</td><td style="text-align: right;;"></td><td style=";">Life:</td><td style="text-align: right;color: #0000FF;;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">2002</td><td style="text-align: right;;"> 100 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> 14 </td><td style="text-align: right;;"> 24 </td><td style="text-align: right;;"> 17 </td><td style="text-align: right;;"> 12 </td><td style="text-align: right;;"> 9 </td><td style="text-align: right;;"> 9 </td><td style="text-align: right;;"> 9 </td><td style="text-align: right;;"> 4 </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">2003</td><td style="text-align: right;;"> 100 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> 14 </td><td style="text-align: right;;"> 24 </td><td style="text-align: right;;"> 17 </td><td style="text-align: right;;"> 12 </td><td style="text-align: right;;"> 9 </td><td style="text-align: right;;"> 9 </td><td style="text-align: right;;"> 9 </td><td style="text-align: right;;"> 4 </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">2004</td><td style="text-align: right;;"> 50 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> 7 </td><td style="text-align: right;;"> 12 </td><td style="text-align: right;;"> 9 </td><td style="text-align: right;;"> 6 </td><td style="text-align: right;;"> 4 </td><td style="text-align: right;;"> 4 </td><td style="text-align: right;;"> 4 </td><td style="text-align: right;;"> 2 </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">2005</td><td style="text-align: right;;"> 50 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> 7 </td><td style="text-align: right;;"> 12 </td><td style="text-align: right;;"> 9 </td><td style="text-align: right;;"> 6 </td><td style="text-align: right;;"> 4 </td><td style="text-align: right;;"> 4 </td><td style="text-align: right;;"> 4 </td><td style="text-align: right;;"> 2 </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">2006</td><td style="text-align: right;;"> 20 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> 3 </td><td style="text-align: right;;"> 5 </td><td style="text-align: right;;"> 3 </td><td style="text-align: right;;"> 2 </td><td style="text-align: right;;"> 2 </td><td style="text-align: right;;"> 2 </td><td style="text-align: right;;"> 2 </td><td style="text-align: right;;"> 1 </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">2007</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">2008</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">2009</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">2010</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">2011</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">2012</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">2013</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">2014</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">2015</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">2016</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">2017</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">2018</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;">2019</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;">2020</td><td style="text-align: right;;"> - </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td><td style="text-align: right;;"> - </td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Test Percent:</td><td style="text-align: right;;"></td><td style="text-align: right;;">14.29%</td><td style="text-align: right;;">24.49%</td><td style="text-align: right;;">17.49%</td><td style="text-align: right;;">12.49%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">4.46%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">14.29%</td><td style="text-align: right;;">24.49%</td><td style="text-align: right;;">17.49%</td><td style="text-align: right;;">12.49%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">4.46%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">14.29%</td><td style="text-align: right;;">24.49%</td><td style="text-align: right;;">17.49%</td><td style="text-align: right;;">12.49%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">4.46%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td></tr><tr ><td style="color: #161120;text-align: center;">34</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">14.29%</td><td style="text-align: right;;">24.49%</td><td style="text-align: right;;">17.49%</td><td style="text-align: right;;">12.49%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">4.46%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td></tr><tr ><td style="color: #161120;text-align: center;">35</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">14.29%</td><td style="text-align: right;;">24.49%</td><td style="text-align: right;;">17.49%</td><td style="text-align: right;;">12.49%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">8.92%</td><td style="text-align: right;;">4.46%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0.00%</td></tr></tbody></table>MACRS <table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" >Worksheet Formulas<table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G3</th><td style="text-align:left">=F3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H3</th><td style="text-align:left">=G3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I3</th><td style="text-align:left">=H3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J3</th><td style="text-align:left">=I3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K3</th><td style="text-align:left">=J3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L3</th><td style="text-align:left">=K3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M3</th><td style="text-align:left">=L3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N3</th><td style="text-align:left">=M3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O3</th><td style="text-align:left">=N3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P3</th><td style="text-align:left">=O3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q3</th><td style="text-align:left">=P3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R3</th><td style="text-align:left">=Q3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S3</th><td style="text-align:left">=R3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T3</th><td style="text-align:left">=S3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U3</th><td style="text-align:left">=T3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V3</th><td style="text-align:left">=U3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W3</th><td style="text-align:left">=V3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X3</th><td style="text-align:left">=W3+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F5</th><td style="text-align:left">=SUM(F9:F27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G5</th><td style="text-align:left">=SUM(G9:G27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H5</th><td style="text-align:left">=SUM(H9:H27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I5</th><td style="text-align:left">=SUM(I9:I27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J5</th><td style="text-align:left">=SUM(J9:J27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K5</th><td style="text-align:left">=SUM(K9:K27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L5</th><td style="text-align:left">=SUM(L9:L27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M5</th><td style="text-align:left">=SUM(M9:M27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N5</th><td style="text-align:left">=SUM(N9:N27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O5</th><td style="text-align:left">=SUM(O9:O27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P5</th><td style="text-align:left">=SUM(P9:P27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q5</th><td style="text-align:left">=SUM(Q9:Q27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R5</th><td style="text-align:left">=SUM(R9:R27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S5</th><td style="text-align:left">=SUM(S9:S27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T5</th><td style="text-align:left">=SUM(T9:T27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U5</th><td style="text-align:left">=SUM(U9:U27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V5</th><td style="text-align:left">=SUM(V9:V27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W5</th><td style="text-align:left">=SUM(W9:W27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X5</th><td style="text-align:left">=SUM(X9:X27)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A9</th><td style="text-align:left">=F3</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A10</th><td style="text-align:left">=+A9+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A11</th><td style="text-align:left">=+A10+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A12</th><td style="text-align:left">=+A11+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A13</th><td style="text-align:left">=+A12+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A14</th><td style="text-align:left">=+A13+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A15</th><td style="text-align:left">=+A14+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A16</th><td style="text-align:left">=+A15+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A17</th><td style="text-align:left">=+A16+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A18</th><td style="text-align:left">=+A17+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A19</th><td style="text-align:left">=+A18+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A20</th><td style="text-align:left">=+A19+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A21</th><td style="text-align:left">=+A20+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A22</th><td style="text-align:left">=+A21+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A23</th><td style="text-align:left">=+A22+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A24</th><td style="text-align:left">=+A23+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A25</th><td style="text-align:left">=+A24+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A26</th><td style="text-align:left">=+A25+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A27</th><td style="text-align:left">=+A26+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,F$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,G$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,H$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,I$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,J$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,K$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,L$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,M$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,N$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,O$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,P$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,Q$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,R$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,S$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,T$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,U$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,V$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,W$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X9</th><td style="text-align:left">=IF($B9>0,VDB($B9,0,$D$8,MIN($D$8,MAX(0,X$3-$A9-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A9+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,F$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,G$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,H$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,I$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,J$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,K$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,L$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,M$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,N$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,O$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,P$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,Q$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,R$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,S$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,T$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,U$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,V$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,W$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X10</th><td style="text-align:left">=IF($B10>0,VDB($B10,0,$D$8,MIN($D$8,MAX(0,X$3-$A10-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A10+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,F$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,G$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,H$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,I$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,J$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,K$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,L$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,M$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,N$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,O$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,P$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,Q$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,R$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,S$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,T$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,U$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,V$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,W$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X11</th><td style="text-align:left">=IF($B11>0,VDB($B11,0,$D$8,MIN($D$8,MAX(0,X$3-$A11-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A11+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,F$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,G$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,H$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,I$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,J$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,K$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,L$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,M$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,N$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,O$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,P$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,Q$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,R$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,S$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,T$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,U$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,V$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,W$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X12</th><td style="text-align:left">=IF($B12>0,VDB($B12,0,$D$8,MIN($D$8,MAX(0,X$3-$A12-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A12+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,F$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,G$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,H$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,I$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,J$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,K$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,L$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,M$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,N$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,O$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,P$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,Q$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,R$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,S$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,T$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,U$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,V$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,W$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X13</th><td style="text-align:left">=IF($B13>0,VDB($B13,0,$D$8,MIN($D$8,MAX(0,X$3-$A13-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A13+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,F$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,G$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,H$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,I$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,J$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,K$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,L$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,M$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,N$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,O$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,P$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,Q$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,R$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,S$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,T$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,U$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,V$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,W$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X14</th><td style="text-align:left">=IF($B14>0,VDB($B14,0,$D$8,MIN($D$8,MAX(0,X$3-$A14-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A14+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,F$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,G$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,H$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,I$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,J$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,K$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,L$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,M$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,N$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,O$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,P$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,Q$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,R$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,S$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,T$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,U$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,V$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,W$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X15</th><td style="text-align:left">=IF($B15>0,VDB($B15,0,$D$8,MIN($D$8,MAX(0,X$3-$A15-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A15+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,F$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,G$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,H$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,I$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,J$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,K$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,L$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,M$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,N$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,O$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,P$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,Q$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,R$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,S$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,T$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,U$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,V$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,W$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X16</th><td style="text-align:left">=IF($B16>0,VDB($B16,0,$D$8,MIN($D$8,MAX(0,X$3-$A16-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A16+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,F$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,G$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,H$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,I$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,J$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,K$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,L$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,M$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,N$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,O$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,P$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,Q$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,R$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,S$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,T$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,U$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,V$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,W$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X17</th><td style="text-align:left">=IF($B17>0,VDB($B17,0,$D$8,MIN($D$8,MAX(0,X$3-$A17-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A17+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,F$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,G$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,H$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,I$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,J$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,K$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,L$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,M$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,N$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,O$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,P$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,Q$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,R$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,S$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,T$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,U$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,V$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,W$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X18</th><td style="text-align:left">=IF($B18>0,VDB($B18,0,$D$8,MIN($D$8,MAX(0,X$3-$A18-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A18+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,F$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,G$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,H$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,I$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,J$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,K$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,L$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,M$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,N$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,O$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,P$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,Q$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,R$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,S$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,T$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,U$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,V$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,W$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X19</th><td style="text-align:left">=IF($B19>0,VDB($B19,0,$D$8,MIN($D$8,MAX(0,X$3-$A19-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A19+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,F$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,G$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,H$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,I$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,J$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,K$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,L$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,M$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,N$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,O$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,P$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,Q$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,R$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,S$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,T$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,U$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,V$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,W$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X20</th><td style="text-align:left">=IF($B20>0,VDB($B20,0,$D$8,MIN($D$8,MAX(0,X$3-$A20-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A20+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,F$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,G$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,H$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,I$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,J$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,K$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,L$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,M$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,N$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,O$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,P$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,Q$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,R$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,S$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,T$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,U$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,V$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,W$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X21</th><td style="text-align:left">=IF($B21>0,VDB($B21,0,$D$8,MIN($D$8,MAX(0,X$3-$A21-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A21+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,F$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,G$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,H$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,I$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,J$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,K$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,L$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,M$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,N$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,O$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,P$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,Q$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,R$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,S$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,T$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,U$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,V$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,W$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X22</th><td style="text-align:left">=IF($B22>0,VDB($B22,0,$D$8,MIN($D$8,MAX(0,X$3-$A22-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A22+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,F$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,G$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,H$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,I$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,J$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,K$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,L$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,M$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,N$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,O$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,P$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,Q$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,R$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,S$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,T$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,U$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,V$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,W$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X23</th><td style="text-align:left">=IF($B23>0,VDB($B23,0,$D$8,MIN($D$8,MAX(0,X$3-$A23-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A23+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,F$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,G$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,H$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,I$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,J$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,K$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,L$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,M$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,N$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,O$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,P$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,Q$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,R$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,S$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,T$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,U$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,V$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,W$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X24</th><td style="text-align:left">=IF($B24>0,VDB($B24,0,$D$8,MIN($D$8,MAX(0,X$3-$A24-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A24+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,F$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,G$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,H$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,I$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,J$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,K$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,L$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,M$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,N$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,O$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,P$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,Q$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,R$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,S$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,T$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,U$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,V$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,W$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X25</th><td style="text-align:left">=IF($B25>0,VDB($B25,0,$D$8,MIN($D$8,MAX(0,X$3-$A25-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A25+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,F$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,G$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,H$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,I$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,J$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,K$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,L$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,M$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,N$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,O$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,P$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,Q$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,R$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,S$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,T$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,U$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,V$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,W$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X26</th><td style="text-align:left">=IF($B26>0,VDB($B26,0,$D$8,MIN($D$8,MAX(0,X$3-$A26-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A26+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,F$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,F$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,G$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,G$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,H$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,H$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,I$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,I$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,J$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,J$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,K$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,K$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,L$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,L$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,M$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,M$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,N$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,N$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,O$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,O$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,P$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,P$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,Q$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,Q$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,R$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,R$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,S$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,S$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,T$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,T$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,U$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,U$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,V$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,V$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,W$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,W$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X27</th><td style="text-align:left">=IF($B27>0,VDB($B27,0,$D$8,MIN($D$8,MAX(0,X$3-$A27-($D$7*0.5))),MIN($D$8,MAX(0,X$3-$A27+1-($D$7*0.5))),2,FALSE),0)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F31</th><td style="text-align:left">=IF($B9>0,F9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G31</th><td style="text-align:left">=IF($B9>0,G9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H31</th><td style="text-align:left">=IF($B9>0,H9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I31</th><td style="text-align:left">=IF($B9>0,I9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J31</th><td style="text-align:left">=IF($B9>0,J9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K31</th><td style="text-align:left">=IF($B9>0,K9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L31</th><td style="text-align:left">=IF($B9>0,L9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M31</th><td style="text-align:left">=IF($B9>0,M9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N31</th><td style="text-align:left">=IF($B9>0,N9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O31</th><td style="text-align:left">=IF($B9>0,O9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P31</th><td style="text-align:left">=IF($B9>0,P9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q31</th><td style="text-align:left">=IF($B9>0,Q9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R31</th><td style="text-align:left">=IF($B9>0,R9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S31</th><td style="text-align:left">=IF($B9>0,S9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T31</th><td style="text-align:left">=IF($B9>0,T9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U31</th><td style="text-align:left">=IF($B9>0,U9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V31</th><td style="text-align:left">=IF($B9>0,V9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W31</th><td style="text-align:left">=IF($B9>0,W9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X31</th><td style="text-align:left">=IF($B9>0,X9/$B9,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F32</th><td style="text-align:left">=IF($B10>0,F10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G32</th><td style="text-align:left">=IF($B10>0,G10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H32</th><td style="text-align:left">=IF($B10>0,H10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I32</th><td style="text-align:left">=IF($B10>0,I10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J32</th><td style="text-align:left">=IF($B10>0,J10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K32</th><td style="text-align:left">=IF($B10>0,K10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L32</th><td style="text-align:left">=IF($B10>0,L10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M32</th><td style="text-align:left">=IF($B10>0,M10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N32</th><td style="text-align:left">=IF($B10>0,N10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O32</th><td style="text-align:left">=IF($B10>0,O10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P32</th><td style="text-align:left">=IF($B10>0,P10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q32</th><td style="text-align:left">=IF($B10>0,Q10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R32</th><td style="text-align:left">=IF($B10>0,R10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S32</th><td style="text-align:left">=IF($B10>0,S10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T32</th><td style="text-align:left">=IF($B10>0,T10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U32</th><td style="text-align:left">=IF($B10>0,U10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V32</th><td style="text-align:left">=IF($B10>0,V10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W32</th><td style="text-align:left">=IF($B10>0,W10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X32</th><td style="text-align:left">=IF($B10>0,X10/$B10,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F33</th><td style="text-align:left">=IF($B11>0,F11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G33</th><td style="text-align:left">=IF($B11>0,G11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H33</th><td style="text-align:left">=IF($B11>0,H11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I33</th><td style="text-align:left">=IF($B11>0,I11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J33</th><td style="text-align:left">=IF($B11>0,J11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K33</th><td style="text-align:left">=IF($B11>0,K11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L33</th><td style="text-align:left">=IF($B11>0,L11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M33</th><td style="text-align:left">=IF($B11>0,M11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N33</th><td style="text-align:left">=IF($B11>0,N11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O33</th><td style="text-align:left">=IF($B11>0,O11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P33</th><td style="text-align:left">=IF($B11>0,P11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q33</th><td style="text-align:left">=IF($B11>0,Q11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R33</th><td style="text-align:left">=IF($B11>0,R11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S33</th><td style="text-align:left">=IF($B11>0,S11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T33</th><td style="text-align:left">=IF($B11>0,T11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U33</th><td style="text-align:left">=IF($B11>0,U11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V33</th><td style="text-align:left">=IF($B11>0,V11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W33</th><td style="text-align:left">=IF($B11>0,W11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X33</th><td style="text-align:left">=IF($B11>0,X11/$B11,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F34</th><td style="text-align:left">=IF($B12>0,F12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G34</th><td style="text-align:left">=IF($B12>0,G12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H34</th><td style="text-align:left">=IF($B12>0,H12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I34</th><td style="text-align:left">=IF($B12>0,I12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J34</th><td style="text-align:left">=IF($B12>0,J12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K34</th><td style="text-align:left">=IF($B12>0,K12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L34</th><td style="text-align:left">=IF($B12>0,L12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M34</th><td style="text-align:left">=IF($B12>0,M12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N34</th><td style="text-align:left">=IF($B12>0,N12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O34</th><td style="text-align:left">=IF($B12>0,O12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P34</th><td style="text-align:left">=IF($B12>0,P12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q34</th><td style="text-align:left">=IF($B12>0,Q12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R34</th><td style="text-align:left">=IF($B12>0,R12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S34</th><td style="text-align:left">=IF($B12>0,S12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T34</th><td style="text-align:left">=IF($B12>0,T12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U34</th><td style="text-align:left">=IF($B12>0,U12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V34</th><td style="text-align:left">=IF($B12>0,V12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W34</th><td style="text-align:left">=IF($B12>0,W12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X34</th><td style="text-align:left">=IF($B12>0,X12/$B12,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F35</th><td style="text-align:left">=IF($B13>0,F13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G35</th><td style="text-align:left">=IF($B13>0,G13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H35</th><td style="text-align:left">=IF($B13>0,H13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I35</th><td style="text-align:left">=IF($B13>0,I13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J35</th><td style="text-align:left">=IF($B13>0,J13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K35</th><td style="text-align:left">=IF($B13>0,K13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L35</th><td style="text-align:left">=IF($B13>0,L13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M35</th><td style="text-align:left">=IF($B13>0,M13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N35</th><td style="text-align:left">=IF($B13>0,N13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">O35</th><td style="text-align:left">=IF($B13>0,O13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">P35</th><td style="text-align:left">=IF($B13>0,P13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q35</th><td style="text-align:left">=IF($B13>0,Q13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">R35</th><td style="text-align:left">=IF($B13>0,R13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">S35</th><td style="text-align:left">=IF($B13>0,S13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">T35</th><td style="text-align:left">=IF($B13>0,T13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U35</th><td style="text-align:left">=IF($B13>0,U13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">V35</th><td style="text-align:left">=IF($B13>0,V13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">W35</th><td style="text-align:left">=IF($B13>0,W13/$B13,"")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">X35</th><td style="text-align:left">=IF($B13>0,X13/$B13,"")</td></tr></tbody></table></td></tr></table> <table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" >Array Formulas<table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B9:B27</th><td style="text-align:left">{=TRANSPOSE(F4:X4)}</td></tr></tbody></table>Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself</td></tr></table>

VDB function and half-year convention

joebobjoe

New Member

Excel Facts

Derek Brown

Well-known Member

xenou

MrExcel MVP

jmayer

New Member

Similar threads

Forum statistics

Share this page

VDB function and half-year convention

joebobjoe

New Member

Excel Facts

Derek Brown

Well-known Member

xenou

MrExcel MVP

jmayer

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock