Spreadsheet: 168533d1342485615-need-calculation-that-considers-a-blank-cell-to-be-100-svl
Sheet: SVL

 |  | 2012-07-01 00:00:00 | 2012-07-02 00:00:00 | 2012-07-03 00:00:00 | 2012-07-04 00:00:00 | 2012-07-05 00:00:00 | 2012-07-06 00:00:00 | 2012-07-07 00:00:00 | 2012-07-08 00:00:00
 | Time | SVL
Daily SVL |  | 72.1 | 61.7 | 69.7 | 97.8 | 81.2 | 73.8 | 89.3 | 86.9
 | 06:00:00 | 50 | 100 | 100 | 100 | 100 | 0 | 100
 | 06:15:00 | 0 | 100 | 100 | 100 | 100 | 100 | 100
 | 06:30:00 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100
 | 06:45:00 | 60 | 100 | 100 | 100 | 100 | 100 | 100
 | 07:00:00 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 | 07:15:00 | 50 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 | 07:30:00 | 66.7 | 100 | 100 | 93.8 | 100 | 100 | 60 | 100
 | 07:45:00 | 100 | 100 | 100 | 95.7 | 100 | 100 | 100 | 80
 | 08:00:00 | 87.5 | 100 | 100 | 100 | 94.7 | 100 | 50 | 80
 | 08:15:00 | 100 | 100 | 80.8 | 100 | 67.6 | 86.2 | 85.7 | 50
 | 08:30:00 | 71.4 | 96.8 | 95.2 | 97.8 | 76.3 | 75.9 | 88.9 | 80
 | 08:45:00 | 100 | 100 | 100 | 91.5 | 96.7 | 98 | 86.7 | 85.7
 | 09:00:00 | 90.9 | 77 | 100 | 100 | 98.1 | 100 | 100 | 100
 | 09:15:00 | 100 | 56.1 | 100 | 93.9 | 97.4 | 94.7 | 100 | 100
 | 09:30:00 | 46.7 | 43.3 | 95.6 | 57.4 | 98.8 | 96.9 | 100 | 83.3
 | 09:45:00 | 50 | 5.8 | 92.4 | 88.2 | 98.2 | 99 | 100 | 66.7
 | 10:00:00 | 89.3 | 7.6 | 74.4 | 94.5 | 99.1 | 100 | 100 | 76.5
 | 10:15:00 | 58.1 | 8.3 | 79.8 | 100 | 97.2 | 100 | 100 | 89.5
 | 10:30:00 | 100 | 4.4 | 93.2 | 100 | 100 | 99.1 | 100 | 100
 | 10:45:00 | 96 | 4.9 | 99.1 | 100 | 97 | 91 | 100 | 100
 | 11:00:00 | 100 | 7.5 | 82 | 98.2 | 90.4 | 63.6 | 97.6 | 89.5
 | 11:15:00 | 38.2 | 10.3 | 94.7 | 100 | 64.8 | 35.1 | 96.8 | 100
 | 11:30:00 | 28.6 | 16.6 | 98.4 | 98.2 | 98.3 | 81.6 | 89.2 | 96.6
 | 11:45:00 | 90.9 | 56.3 | 98.1 | 100 | 98.9 | 75.7 | 97 | 82.6
 | 12:00:00 | 83.9 | 76.9 | 100 | 99.2 | 100 | 46.5 | 100 | 84.6
 | 12:15:00 | 80 | 64.4 | 100 | 100 | 100 | 22.1 | 100 | 100
 | 12:30:00 | 86.4 | 96.9 | 99 | 100 | 100 | 12.9 | 100 | 100
 | 12:45:00 | 96.8 | 100 | 100 | 100 | 83 | 23.1 | 100 | 85.7
 | 13:00:00 | 95.8 | 98.4 | 100 | 98.9 | 87.7 | 39.3 | 97.7 | 100
 | 13:15:00 | 100 | 99.2 | 100 | 99.2 | 100 | 13.6 | 100 | 90.9
 | 13:30:00 | 100 | 100 | 99 | 100 | 100 | 80 | 100 | 96.8
 | 13:45:00 | 100 | 100 | 100 | 100 | 99.1 | 98.9 | 100 | 95.8
 | 14:00:00 | 100 | 99.3 | 100 | 100 | 76 | 99 | 96 | 81.8
 | 14:15:00 | 100 | 100 | 99 | 100 | 94.6 | 100 | 87.5 | 100
 | 14:30:00 | 96.4 | 80.9 | 58.9 | 100 | 91.5 | 82.7 | 100 | 100
 | 14:45:00 | 44.8 | 20 | 57.4 | 100 | 48.7 | 50 | 100 | 100
 | 15:00:00 | 95 | 56.5 | 22.7 | 97.3 | 13.7 | 69 | 94.7 | 62.5
 | 15:15:00 | 84.2 | 97.5 | 42.9 | 100 | 9.1 | 65.7 | 100 | 65.7
 | 15:30:00 | 65.2 | 94.2 | 57 | 98.9 | 4.6 | 97.1 | 84.2 | 100
 | 15:45:00 | 58.1 | 92.9 | 13.2 | 100 | 9.7 | 77.8 | 38.1 | 100
 | 16:00:00 | 86.4 | 37.2 | 15.1 | 99 | 34.9 | 94.9 | 94.4 | 100
 | 16:15:00 | 85.7 | 61.9 | 37 | 100 | 56.4 | 80.4 | 88.9 | 100
 | 16:30:00 | 62.5 | 95.7 | 23.8 | 99.1 | 72.7 | 52 | 47.8 | 93.3
 | 16:45:00 | 100 | 98.9 | 6 | 98 | 73.8 | 53.1 | 35 | 100
 | 17:00:00 | 93.3 | 90.5 | 8.5 | 100 | 92.7 | 55.1 | 40 | 100
 | 17:15:00 | 88.2 | 90.9 | 13.1 | 100 | 100 | 100 | 53.3 | 100
 | 17:30:00 | 60 | 98.3 | 5.6 | 100 | 98 | 96.4 | 46.2 | 100
 | 17:45:00 | 25 | 56.3 | 4.5 | 100 | 100 | 100 | 100 | 100
 | 18:00:00 | 17.6 | 93 | 54.2 | 97.7 | 100 | 100 | 100 | 92.9
 | 18:15:00 | 31.6 | 78.5 | 82.1 | 98 | 100 | 100 | 100 | 94.7
 | 18:30:00 | 84.6 | 56.8 | 41.9 | 100 | 100 | 100 | 100 | 66.7
 | 18:45:00 | 100 | 52.1 | 90.9 | 97.3 | 97.2 | 100 | 100 | 94.4
 | 19:00:00 | 93.3 | 95.5 | 38.6 | 100 | 100 | 100 | 66.7 | 85.7
 | 19:15:00 | 83.3 | 96.4 | 43.9 | 100 | 100 | 100 | 83.3 | 92.9
 | 19:30:00 | 41.7 | 67.6 | 18.2 | 100 | 100 | 82.8 | 100 | 85.7
 | 19:45:00 | 100 | 16.7 | 28.2 | 100 | 100 | 100 | 100 | 100
 | 20:00:00 | 100 | 0 | 11.4 | 92 | 100 | 100 | 100 | 94.4
 | 20:15:00 | 80 | 11.1 | 34.5 | 96.8 | 100 | 87 | 50 | 100
 | 20:30:00 | 100 | 3.4 | 57.6 | 100 | 100 | 100 | 11.1 | 42.9
 | 20:45:00 | 100 | 20.6 | 89.3 | 100 | 100 | 100 | 50 | 35.3
 | 21:00:00 | 91.7 | 33.3 | 97 | 100 | 100 | 100 | 100 | 87.5
 | 21:15:00 | 14.3 | 26.9 | 100 | 100 | 100 | 68.8 | 100 | 77.8
 | 21:30:00 | 18.8 | 86.4 | 100 | 100 | 100 | 100 | 50 | 85.7
 | 21:45:00 | 0 | 93.8 | 100 | 100 | 100 | 100 | 60 | 85.7
 | 22:00:00 | 0 | 48 | 100 | 100 | 100 | 60 | 100 | 0
 | 22:15:00 | 0 | 85.7 | 100 | 100 | 100 | 28.6 | 100 | 7.7
 | 22:30:00 | 0 | 100 | 100 | 100 | 100 | 100 | 100 | 77.8
 | 22:45:00 | 0 | 100 | 100 | 100 | 100 | 60 | 66.7 | 100