Spreadsheet: 111990d1308187993-excel-2007-pasting-data-into-a-cell-only-if-the-cell-has-a-background-color-data-collection-for-forum
Sheet: Data Collection Input

 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 121 | 1570 |  |  |  |  |  | 1 | 1810
 | 122 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 | Total: | 1570 | 0 | 0 | 0 | #N/A |  | Total: | 1810 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 62 | 1650 |  |  |  |  |  | 4 | 1965
 | 63 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | 6
 | Total: | 1650 | 0 | 0 | 0 | #N/A |  | Total: | 1965 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 64 | 1750 |  |  |  |  |  | 7 | 1720
 | 65 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | 9
 | Total: | 1750 | 0 | 0 | 0 | #N/A |  | Total: | 1720 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 66 | 1815 |  |  |  |  |  | 10 | 1715
 | 67 |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  | 12
 | Total: | 1815 | 0 | 0 | 0 | #N/A |  | Total: | 1715 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 68 | 1540 |  |  |  |  |  | 13 | 1645
 | 69 |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  | 15
 | Total: | 1540 | 0 | 0 | 0 | #N/A |  | Total: | 1645 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 70 | 1685 |  |  |  |  |  | 16 | 1520
 | 71 |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  | 18
 | Total: | 1685 | 0 | 0 | 0 | #N/A |  | Total: | 1520 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 72 | 1560 |  |  |  |  |  | 19 | 1200
 | 73 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  | 21
 | Total: | 1560 | 0 | 0 | 0 | #N/A |  | Total: | 1200 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 74 | 1785 |  |  |  |  |  | 22 | 1620
 | 75 |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 24
 | Total: | 1785 | 0 | 0 | 0 | #N/A |  | Total: | 1620 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 76 | 1990 |  |  |  |  |  | 26 | 1725
 | 77 |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  | 28
 | Total: | 1990 | 0 | 0 | 0 | #N/A |  | Total: | 1725 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 78 | 1770 |  |  |  |  |  | 30 | 1725
 | 79 |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  | 32
 | Total: | 1770 | 0 | 0 | 0 | #N/A |  | Total: | 1725 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 80 | 1945 |  |  |  |  |  | 33 | 1635
 | 81 |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  | 35
 | Total: | 1945 | 0 | 0 | 0 | #N/A |  | Total: | 1635 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 82 | 2270 |  |  |  |  |  | 36 | 1530
 | 83 |  |  |  |  |  |  | 37
 | Total: | 2270 | 0 | 0 | 0 | #N/A |  | Total: | 1530 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 84 | 2245 |  |  |  |  |  | 38 | 1410
 | 85 |  |  |  |  |  |  | 39
 | Total: | 2245 | 0 | 0 | 0 | #N/A |  | Total: | 1410 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 86 | 2605 |  |  |  |  |  | 40 | 1410
 | 87 |  |  |  |  |  |  | 41
 | Total: | 2605 | 0 | 0 | 0 | #N/A |  | Total: | 1410 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 88 | 3445 |  |  |  |  |  | 42 | 1255
 | 89 |  |  |  |  |  |  | 43
 | Total: | 3445 | 0 | 0 | 0 | #N/A |  | Total: | 1255 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 91 | 3805 |  |  |  |  |  | 44 | 1270
 | 92 |  |  |  |  |  |  | 45
 | Total: | 3805 | 0 | 0 | 0 | #N/A |  | Total: | 1270 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 94 | 3805 |  |  |  |  |  | 46 | 1465
 | 95 |  |  |  |  |  |  | 47
 | Total: | 3805 | 0 | 0 | 0 | #N/A |  | Total: | 1465 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 96 | 2975 |  |  |  |  |  | 48 | 1255
 | 97 |  |  |  |  |  |  | 49
 | Total: | 2975 | 0 | 0 | 0 | #N/A |  | Total: | 1255 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 98 | 3015 |  |  |  |  |  | 50 | 1250
 | 99 |  |  |  |  |  |  | 51
 | 100
 | Total: | 3015 | 0 | 0 | 0 | #N/A |  | Total: | 1250 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 101 | 2595 |  |  |  |  |  | 52 | 1375
 | 102 |  |  |  |  |  |  | 53
 | 103
 | Total: | 2595 | 0 | 0 | 0 | #N/A |  | Total: | 1375 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 104 | 2420 |  |  |  |  |  | 54 | 1240
 | 105 |  |  |  |  |  |  | 55
 | 106
 | Total: | 2420 | 0 | 0 | 0 | #N/A |  | Total: | 1240 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 107 | 2320 |  |  |  |  |  | 56 | 1510
 | 108 |  |  |  |  |  |  | 57
 | 109
 | Total: | 2320 | 0 | 0 | 0 | #N/A |  | Total: | 1510 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 110 | 2155 |  |  |  |  |  | 58 | 1450
 | 111 |  |  |  |  |  |  | 59
 | 112
 | Total: | 2155 | 0 | 0 | 0 | #N/A |  | Total: | 1450 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 113 | 2345 |  |  |  |  |  | 60 | 1280
 | 114 |  |  |  |  |  |  | 61
 | 115
 | Total: | 2345 | 0 | 0 | 0 | #N/A |  | Total: | 1280 | 0 | 0 | 0 | #N/A
 | Data Collection No. | Name of location |  |  |  |  |  | Data Collection No. | Name of location
 |  | Demand | Volume | Min Speed | [NAME] | [NAME] |  |  | Demand | Volume | Min Speed | [NAME] | [NAME]
 | 116 | 2220 |  |  |  |  |  | 119 | 1265
 | 117 |  |  |  |  |  |  | 120
 | 118
 | Total: | 2220 | 0 | 0 | 0 | #N/A |  | Total: | 1265 | 0 | 0 | 0 | #N/A