Spreadsheet: 92044d1291718479-converting-hours-to-number-value-schedule-help
Sheet: Sheet2

 | MON |  |  | TUE |  |  | WED |  |  | THUR |  |  | FRI |  |  | SAT |  |  | SUN |  |  |  |  | 0 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101 | 4
10-11 | 57 |  |  | 98 |  |  | 65 |  |  | 126 |  |  | 75 |  |  | 74 |  |  | 46 |  |  |  |  | 146 | 5
11-12 | 421 |  |  | 462 |  |  | 330 |  |  | 519 |  |  | 430 |  |  | 370 |  |  | 92 |  |  |  |  | 221 | 6
12-1 | 744 |  |  | 729 |  |  | 687 |  |  | 868 |  |  | 726 |  |  | 577 |  |  | 301 |  |  |  |  | 296 | 7
1-2 | 425 |  |  | 375 |  |  | 372 |  |  | 587 |  |  | 431 |  |  | 430 |  |  | 322 |  |  |  |  | 372 | 8
2-3 | 318 |  |  | 402 |  |  | 285 |  |  | 220 |  |  | 354 |  |  | 582 |  |  | 253 |  |  |  |  | 452 | 9
3-4 | 258 |  |  | 258 |  |  | 260 |  |  | 284 |  |  | 211 |  |  | 285 |  |  | 203 |  |  |  |  | 542 | 10
4-5 | 295 |  |  | 278 |  |  | 306 |  |  | 329 |  |  | 224 |  |  | 406 |  |  | 174 |  |  |  |  | 641 | 11
5-6 | 346 |  |  | 361 |  |  | 565 |  |  | 459 |  |  | 445 |  |  | 374 |  |  | 318 |  |  |  |  | 742 | 12
6-7 | 364 |  |  | 283 |  |  | 474 |  |  | 446 |  |  | 459 |  |  | 322 |  |  | 202 |  |  |  |  | 851 | 13
7-8 | 227 |  |  | 245 |  |  | 329 |  |  | 325 |  |  | 337 |  |  | 259 |  |  | 279 |  |  |  |  | 951 | 14
8-9 | 180 |  |  | 231 |  |  | 336 |  |  | 293 |  |  | 259 |  |  | 146 |  |  | 162
9-10 | 100 |  |  | 128 |  |  | 177 |  |  | 237 |  |  | 191 |  |  | 218 |  |  | 131
10-11 | 76 |  |  | 173 |  |  | 165 |  |  | 100 |  |  | 200 |  |  | 178 |  |  | 184
11-12 | 50 |  |  | 28 |  |  | 122 |  |  | 102 |  |  | 81 |  |  | 137 |  |  | 39
12-1 | 77 |  |  | 59 |  |  | 44 |  |  | 166 |  |  | 66 |  |  | 72 |  |  | 24
1-2 | 39 |  |  | 29 |  |  | 10 |  |  | 41 |  |  | 30 |  |  | 26 |  |  | 23
TOTAL | 3977 |  |  | 4139 |  |  | 4527 |  |  | 5102 |  |  | 4519 |  |  | 4456 |  |  | 2753 |  | 29473
last years sales
 | 3955 |  |  | 4214 |  |  | 4432 |  |  | 5240 |  |  | 4561 |  |  | 4153 |  |  | 2468 |  | 29023
HAVE/NEEDS | MON |  |  | TUES |  |  | WED |  |  | THUR |  |  | FRI |  |  | SAT |  |  | SUN
 | Have | Need | VAR | Have | Need | VAR | Have | Need | VAR | Have | Need | VAR | Have | Need | VAR | Have | Need | VAR | Have | Need | VAR
10-11 | 5 | 3 | 2 | 4 | 3 | 1 | 3 | 3 | 0 | 4 | 4 | 0 | 5 | 3 | 2 | 6 | 3 | 3 | 3 | 3 | 0
11-12 | 8 | 8 | 0 | 9 | 9 | 0 | 10 | 7 | 3 | 10 | 9 | 1 | 9 | 8 | 1 | 9 | 7 | 2 | 6 | 3 | 3
12-1 | 9 | 12 | -3 | 9 | 11 | -2 | 9 | 11 | -2 | 10 | 13 | -3 | 9 | 11 | -2 | 9 | 10 | -1 | 7 | 7 | 0
1-2 | 9 | 8 | 1 | 9 | 8 | 1 | 9 | 8 | 1 | 10 | 10 | 0 | 9 | 8 | 1 | 9 | 8 | 1 | 7 | 7 | 0
2-3 | 6 | 7 | -1 | 6 | 8 | -2 | 9 | 6 | 3 | 7 | 5 | 2 | 6 | 7 | -1 | 6.5 | 10 | -3.5 | 6 | 6 | 0
3-4 | 5 | 6 | -1 | 5 | 6 | -1 | 6 | 6 | 0 | 7 | 6 | 1 | 6 | 5 | 1 | 6 | 6 | 0 | 6 | 5 | 1
4-5 | 5 | 6 | -1 | 5 | 6 | -1 | 6 | 7 | -1 | 7 | 7 | 0 | 6 | 6 | 0 | 6 | 8 | -2 | 6 | 5 | 1
5-6 | 6 | 7 | -1 | 6 | 7 | -1 | 6 | 10 | -4 | 6 | 9 | -3 | 7 | 8 | -1 | 7 | 8 | -1 | 6 | 7 | -1
6-7 | 6 | 7 | -1 | 6 | 6 | 0 | 8 | 9 | -1 | 6 | 8 | -2 | 7 | 9 | -2 | 6 | 7 | -1 | 6 | 5 | 1
7-8 | 5 | 6 | -1 | 6 | 6 | 0 | 7 | 7 | 0 | 5 | 7 | -2 | 7 | 7 | 0 | 7 | 6 | 1 | 7 | 6 | 1
8-9 | 5 | 5 | 0 | 6 | 6 | 0 | 6 | 7 | -1 | 5 | 6 | -1 | 6 | 6 | 0 | 6 | 5 | 1 | 6 | 5 | 1
9-10 | 5 | 3 | 2 | 6 | 4 | 2 | 6 | 5 | 1 | 5 | 6 | -1 | 6 | 5 | 1 | 6 | 5 | 1 | 5 | 4 | 1
10-11 | 4 | 3 | 1 | 5 | 5 | 0 | 4 | 5 | -1 | 4 | 3 | 1 | 4 | 5 | -1 | 5 | 5 | 0 | 5 | 5 | 0
11-12 | 3 | 3 | 0 | 3 | 3 | 0 | 4 | 4 | 0 | 4 | 4 | 0 | 4 | 3 | 1 | 4 | 4 | 0 | 4 | 3 | 1
12-1 | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 5 | -2 | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 3 | 0
1-2 | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 3 | 0
 |  |  | -3 |  |  | -3 |  |  | -2 |  |  | -9 |  |  | 0 |  |  | 0.5 |  |  | 9