I would like to create a spreadsheet that would help me automatically manage the required amount of rest for baseball pitchers. The columns of the spreadsheet would be the date and the rows would be the players. The requirements are as follows:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 100px"><col width="100"></colgroup><tbody>
</tbody>
So it would look something like this and would automatically determine required rest based upon the number of pitches entered in on any given date.
3/1/17 3/2/17 3/3/17 3/4/17 3/5/17 3/6/17
Smith 120 REST REST REST REST
Lewis 0 27 REST 58 REST REST
Brown 0 40 REST 35 REST
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
1-25 | no rest |
26-55 | 1 day rest |
56-75 | 2 days rest |
76-119 | 3 days rest |
120 | 4 days rest |
<colgroup><col style="width: 100px"><col width="100"></colgroup><tbody>
</tbody>
So it would look something like this and would automatically determine required rest based upon the number of pitches entered in on any given date.
3/1/17 3/2/17 3/3/17 3/4/17 3/5/17 3/6/17
Smith 120 REST REST REST REST
Lewis 0 27 REST 58 REST REST
Brown 0 40 REST 35 REST