Spreadsheet: 116713d1312044656-transferring-results-and-drop-down-lists-example1
Sheet: Input Tab 2011

 |  | NUMBER | NAME |  |  |  | 2010 | 2010 | 2010 | 2010 | 2010
 |  |  | . |  |  |  | Data 1 | Data 2 | Data 3 | Data 4 | Data 5 |  |  | Comments
 | 1 | 80001 |  | 12001 | 2010-06-30 00:00:00 | Y
 | 2 | 80002 |  | 12001 | 2009-12-31 00:00:00
 | 3 | 000003 |  | 12001 | 2009-12-31 00:00:00 |  | 80985.95 | 133388.63 | 80985.95 | 80985.95
 | 4 | 000004 |  | 12901 | 2009-12-31 00:00:00 | Y | 0 | 0 | 0 | 0 | 0
 | 5 | 000005 |  | 12001 | 2010-06-30 00:00:00 |  | 87875.61 | 144736.3 | 145561.45 | 144736.29
 | 6 | 000006 |  | 12001 | 2010-06-30 00:00:00 |  | 87875.61 | 144736.3 | 87875.61 | 87875.61
 | 7 | 000007 |  | 12001 | 2009-12-31 00:00:00 | Y | 87369.07 | 143902.01 | 134778.92 | 127623.75 | 102787.15
 | 8 | 000008 |  | 12001 | 2010-06-30 00:00:00 | Y | 87875.61 | 144736.3 | 102191.56 | 96766.4 | 103383.06
 | 9 | 000009 |  | 12001 | 2010-06-30 00:00:00 | Y | 87875.61 | 144736.3 | 116841.77 | 110638.87 | 103383.06
 | 10 | 000010 |  | 12001 | 2010-06-30 00:00:00 |  | 87875.61 | 144736.3 | 87875.61 | 87875.61
 | 11 | 000011 |  | 12001 | 2010-06-30 00:00:00 |  | 87875.61 | 144736.3 | 87875.61 | 87875.61
 | 12 | 000012 |  | 12001 | 2010-09-30 00:00:00 |  | 0 | 0 | 0 | 0
 | 13 | 000013 |  | 12901 | 2009-12-31 00:00:00 | Y | 0 | 0 | 0 | 0 | 0
 | 14 | 000014 |  | 12001 | 2010-06-30 00:00:00 | Y | 82739.5 | 136276.82 | 82739.5 | 82739.5 | 0
 | 15 | 000015 |  | 12001 | 2010-06-30 00:00:00 |  | 82739.5 | 136276.82 | 82739.5 | 82739.5
 | 16 | 000016 |  | 12001 | 2010-06-30 00:00:00 |  | 82739.5 | 136276.82 | 84499.36 | 82739.5
 | 17 | 000017 |  | 12001 | 2010-06-30 00:00:00 |  | 82739.5 | 136276.82 | 82739.5 | 82739.5
 | 18 | 000018 |  | 12001 | 2010-06-30 00:00:00 |  | 82739.5 | 136276.82 | 82739.5 | 82739.5
 | 19 | 000019 |  | 12001 | 2010-06-30 00:00:00 |  | 82739.5 | 136276.82 | 82739.5 | 82739.5
 | 20 | 000020 |  | 12001 | 2010-06-30 00:00:00 |  | 82739.5 | 136276.82 | 82739.5 | 82739.5
 | 21 | 000021 |  | 12001 | 2010-06-30 00:00:00 |  | 82739.5 | 136276.82 | 82739.5 | 82739.5
 | 22 | 000022 |  | 12001 | 2010-06-30 00:00:00 |  | 82739.5 | 136276.82 | 82739.5 | 82739.5
 | 23 | 000023 |  | 12001 | 2010-06-30 00:00:00 |  | 82739.5 | 136276.82 | 82739.5 | 82739.5
 | 24 | 000024 |  | 12001 | 2010-06-30 00:00:00 | Y | 82739.5 | 136276.82 | 82739.5 | 82739.5 | #N/A
 | 25 | 000025 |  | 12001 | 2010-06-30 00:00:00 | Y | 82739.5 | 136276.82 | 82739.5 | 82739.5 | 0
 | 26 | 000026 |  | 12001 | 2010-06-30 00:00:00 | Y | 82739.5 | 136276.82 | 82739.5 | 82739.5 | 0
 | 27 | 000027 |  | 12001 | 2010-06-30 00:00:00 |  | 82739.5 | 136276.82 | 83331.88 | 82739.5
 | 28 | 000028 |  | 12001 | 2010-06-30 00:00:00 |  | 82739.5 | 136276.82 | 82739.5 | 82739.5
 | 29 | 000029 |  | 12001 | 2010-06-30 00:00:00 |  | 82739.5 | 136276.82 | 127795.2 | 121010.81
 | 30 | 000030 |  | 12001 | 2010-06-30 00:00:00 | Y | 82739.5 | 136276.82 | 82739.5 | 82739.5 | 0
 | 31 | 000031 |  | 12001 | 2010-06-30 00:00:00 | Y | 82739.5 | 136276.82 | 122536.16 | 116030.97 | 97340.59
 | 32 | 000032 |  | 12901 | 2009-12-31 00:00:00 |  | 0 | 0 | 0 | 0
 | 33 | 000033 |  | 12901 | 2009-12-31 00:00:00 |  | 0 | 0 | 0 | 0
 | 34 | 000034 |  | 12001 | 2009-12-31 00:00:00 |  | 87688.24 | 144427.68 | 103559.03 | 98061.28
 | 35 | 000035 |  | 12001 | 2009-12-31 00:00:00 | Y | 83299.84 | 137199.72 | 83299.84 | 83299.84 | 97999.8
 | 36 | 000036 |  | 12001 | 2009-12-31 00:00:00 |  | 87688.24 | 144427.68 | 147701.12 | 145776.02
 | 37 | 000037 |  | 12001 | 2009-12-31 00:00:00 | Y | 83299.84 | 137199.72 | 102925.64 | 97461.5 | 97999.8
 | 38 | 000038 |  | 12001 | 2009-12-31 00:00:00 | Y | 83299.84 | 137199.72 | 138367.75 | 138083.56 | 97999.8
 | 39 | 000039 |  | 12001 | 2009-12-31 00:00:00 | Y | 87688.24 | 144427.68 | 99498.18 | 94216.02 | 103162.63
 | 40 | 000040 |  | 12001 | 2009-12-31 00:00:00 | Y | 81210.96 | 133759.23 | 94084.87 | 94084.87 | 97119.94
 | 41 | 000041 |  | 12001 | 2009-12-31 00:00:00 | Y | 87688.24 | 144427.68 | 98964.79 | 93710.92 | 103162.63
 | 42 | 000042 |  | 12001 | 2009-12-31 00:00:00 | Y | 83299.84 | 137199.72 | 89801.31 | 85033.92 | 97999.8
 | 43 | 000043 |  | 12001 | 2009-12-31 00:00:00 | Y | 83299.84 | 137199.72 | 107730.31 | 102011.13 | 97999.8
 | 44 | 000044 |  | 12001 | 2009-12-31 00:00:00 | Y | 87688.24 | 144427.68 | 87688.24 | 87688.24 | 103162.63
 | 45 | 000045 |  | 12001 | 2009-12-31 00:00:00 | Y | 83299.84 | 137199.72 | 99271.06 | 94000.94 | 97999.8
 | 46 | 000046 |  | 12001 | 2009-12-31 00:00:00 |  | 83299.84 | 137199.72 | 132930.93 | 125873.88
 | 47 | 000047 |  | 12001 | 2009-12-31 00:00:00 |  | 83299.84 | 137199.72 | 93622.26 | 93622.26
 | 48 | 000048 |  | 12001 | 2009-12-31 00:00:00 | Y | 83299.84 | 137199.72 | 95183.15 | 90130.03 | 97999.8
 | 49 | 000049 |  | 12001 | 2009-12-31 00:00:00 |  | 83299.84 | 137199.72 | 140600.49 | 140205.8
 | 50 | 000050 |  | 12001 | 2009-12-31 00:00:00 | Y | 87442.81 | 144023.45 | 139408.33 | 132007.38 | 104221.53
 | 51 | 000051 |  | 12001 | 2009-12-31 00:00:00 |  | 83299.84 | 137199.72 | 109027.93 | 109027.93
 | 52 | 000052 |  | 12001 | 2008-12-31 00:00:00 | Y | 83299.84 | 137199.72 | 100394.1 | 95064.38 | 97999.8
 | 53 | 000053 |  | 12001 | 2009-12-31 00:00:00 | Y | 87688.24 | 144427.68 | 87688.24 | 87688.24 | 105762.33
 | 54 | 000054 |  | 12001 | 2009-12-31 00:00:00 | Y | 87688.24 | 144427.68 | 127011.53 | 120268.73 | 103162.63
 | 55 | 000055 |  | 12001 | 2009-12-31 00:00:00 |  | 87701.4 | 144449.36 | 138785.74 | 131417.84
 | 56 | 000056 |  | 12001 | 2009-12-31 00:00:00 | Y | 83299.84 | 137199.72 | 94943.52 | 89903.15 | 97999.8
 | 57 | 000057 |  | 12001 | 2009-12-31 00:00:00 | Y | 87688.24 | 144427.68 | 100021.16 | 94711.21 | 103162.63
 | 58 | 000058 |  | 12001 | 2009-12-31 00:00:00 |  | 87688.24 | 144427.68 | 147466.26 | 147052.31
 | 59 | 000059 |  | 12001 | 2009-12-31 00:00:00 |  | 83299.84 | 137199.72 | 110489.69 | 110489.69
 | 60 | 000060 |  | 12001 | 2009-12-31 00:00:00 | Y | 83299.84 | 137199.72 | 89863.82 | 85093.1 | 97999.8
 | 61 | 000061 |  | 12001 | 2009-12-31 00:00:00 | Y | 87688.24 | 144427.68 | 87688.24 | 87688.24 | 103162.63
 | 62 | 000062 |  | 12001 | 2009-12-31 00:00:00 |  | 83299.84 | 137199.72 | 99154.41 | 93890.46
 | 63 | 000063 |  | 12001 | 2009-12-31 00:00:00 | Y | 87688.24 | 144427.68 | 87688.24 | 87688.24 | 103162.63
 | 64 | 000064 |  | 12001 | 2009-12-31 00:00:00 |  | 83299.84 | 137199.72 | 88622 | 83917.23
 | 65 | 000065 |  | 12001 | 2009-12-31 00:00:00 |  | 83299.84 | 137199.72 | 93439.19 | 88478.68
 | 66 | 000066 |  | 12001 | 2009-12-31 00:00:00 |  | 83299.84 | 137199.72 | 138544.74 | 138328.76
 | 67 | 000067 |  | 12001 | 2009-12-31 00:00:00 | Y | 83299.84 | 137199.72 | 103146.49 | 97670.65 | 97999.8
 | 68 | 000068 |  | 12001 | 2009-12-31 00:00:00 | Y | 83299.84 | 137199.72 | 108376.2 | 102622.71 | 97999.8
 | 69 | 000069 |  | 12001 | 2004-12-31 00:00:00 | Y | 87688.24 | 144427.68 | 87688.24 | 87688.24 | 103162.63
 | 70 | 000070 |  | 12001 | 2009-12-31 00:00:00 | Y | 87688.24 | 144427.68 | 145358.06 | 137107.83 | 103162.63
 | 71 | 000071 |  | 12001 | 2009-12-31 00:00:00 |  | 87688.24 | 144427.68 | 87688.24 | 87688.24
 | 72 | 000072 |  | 12001 | 2010-06-30 00:00:00 | Y | 88196.62 | 145265.02 | 88196.63 | 88196.63 | 103760.74
 | 73 | 000073 |  | 12001 | 2010-06-30 00:00:00 |  | 88196.62 | 145265.02 | 88196.63 | 88196.63
 | 74 | 000074 |  | 12001 | 2010-06-30 00:00:00 |  | 83782.78 | 137995.15 | 265628.21 | 252041.75
 | 75 | 000075 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 79472.1 | 76078.61 | 89504.23
 | 76 | 000076 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 91880.54 | 87002.78 | 89504.23
 | 77 | 000077 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 100786.73 | 100786.73 | 89504.23
 | 78 | 000078 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 93709.38 | 88734.53 | 89504.23
 | 79 | 000079 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 125593.3 | 126162.55 | 89504.23
 | 80 | 000080 |  | 12001 | 2010-06-30 00:00:00 | Y | 84986.55 | 139977.85 | 107777.55 | 102055.85 | 99984.18
 | 81 | 000081 |  | 12001 | 2010-06-30 00:00:00 | Y | 75060.71 | 123629.4 | 125915.9 | 124285.56 | 89504.23
 | 82 | 000082 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 125918.91 | 125308.42 | 89504.23
 | 83 | 000083 |  | 12001 | 2010-06-30 00:00:00 |  | 76078.61 | 125305.96 | 126133.65 | 125446.87
 | 84 | 000084 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 76078.61 | 76078.61 | 89504.23
 | 85 | 000085 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 80368.59 | 76101.94 | 89504.23
 | 86 | 000086 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 108822.22 | 103045.06 | 89504.23
 | 87 | 000087 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 102894.77 | 97432.29 | 89504.23
 | 88 | 000088 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 100019.59 | 94709.73 | 89504.23
 | 89 | 000089 |  | 12001 | 2010-06-30 00:00:00 |  | 76078.61 | 125305.96 | 127315.48 | 125305.95
 | 90 | 000090 |  | 12001 | 2010-06-30 00:00:00 |  | 76078.61 | 125305.96 | 83255.37 | 83255.37
 | 91 | 000091 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 97558.36 | 92379.16 | 89504.23
 | 92 | 000092 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 97529.95 | 92352.25 | 89504.23
 | 93 | 000093 |  | 12001 | 2010-06-30 00:00:00 |  | 84986.55 | 139977.85 | 84986.55 | 84986.55
 | 94 | 000094 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 125560.18 | 125411.67 | 89504.23
 | 95 | 000095 |  | 12001 | 2010-06-30 00:00:00 |  | 76078.61 | 125305.96 | 80602.42 | 76323.36
 | 96 | 000096 |  | 12901 | 2010-06-30 00:00:00 |  | 0 | 0 | 0 | 0
 | 97 | 000097 |  | 12001 | 2010-06-30 00:00:00 | Y | 84986.55 | 139977.85 | 139977.84 | 139403.84 | 99984.18
 | 98 | 000098 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 105348.24 | 99755.49 | 89504.23
 | 99 | 000099 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 76078.61 | 76078.61 | 89504.23
 | 100 | 000100 |  | 12001 | 2010-06-30 00:00:00 |  | 84986.55 | 139977.85 | 93469.44 | 93469.44
 | 101 | 000101 |  | 12901 | 2010-06-30 00:00:00 | Y | 0 | 0 | 0 | 0 | 0
 | 102 | 000102 |  | 12901 | 2010-06-30 00:00:00 | Y | 0 | 0 | 0 | 0 | 0
 | 103 | 000103 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 133224.68 | 126152.04 | 89504.23
 | 104 | 000104 |  | 12901 | 2010-06-30 00:00:00 |  | 0 | 0 | 0 | 0
 | 105 | 000105 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 105352.34 | 99759.37 | 89504.23
 | 106 | 000106 |  | 12901 | 2010-06-30 00:00:00 |  | 0 | 0 | 0 | 0
 | 107 | 000107 |  | 12001 | 2010-06-30 00:00:00 |  | 76078.61 | 125305.96 | 122018.5 | 122018.5
 | 108 | 000108 |  | 12001 | 2010-06-30 00:00:00 |  | 76078.61 | 125305.96 | 125305.95 | 119428.83
 | 109 | 000109 |  | 12001 | 2010-06-30 00:00:00 |  | 84986.55 | 139977.85 | 91018.64 | 86186.66
 | 110 | 000110 |  | 12001 | 2009-12-31 00:00:00 | Y | 84496.66 | 139170.99 | 84496.66 | 84496.66 | 99407.85
 | 111 | 000111 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 127974 | 125305.95 | 89504.23
 | 112 | 000112 |  | 12001 | 2010-06-30 00:00:00 | Y | 84986.55 | 139977.85 | 84986.55 | 84986.55 | 99984.18
 | 113 | 000113 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 83586.1 | 79148.69 | 89504.23
 | 114 | 000114 |  | 12001 | 2010-06-30 00:00:00 | Y | 76314.31 | 125694.17 | 93830.97 | 88849.68 | 89781.53
 | 115 | 000115 |  | 12901 | 2010-06-30 00:00:00 | Y | 0 | 0 | 0 | 0 | 0
 | 116 | 000116 |  | 12001 | 2010-06-30 00:00:00 | Y | 84986.55 | 139977.85 | 139977.84 | 138119.35 | 99984.18
 | 117 | 000117 |  | 12001 | 2010-06-30 00:00:00 |  | 76078.61 | 125305.96 | 94835.13 | 89800.51
 | 118 | 000118 |  | 12001 | 2009-12-31 00:00:00 | Y | 84496.66 | 139170.99 | 141314.16 | 142972.73 | 99407.85
 | 119 | 000119 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 125305.95 | 119348.76 | 89504.23
 | 120 | 000120 |  | 12901 | 2010-06-30 00:00:00 |  | 0 | 0 | 0 | 0
 | 121 | 000121 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 88867.6 | 84149.82 | 89504.23
 | 122 | 000122 |  | 12001 | 2010-06-30 00:00:00 | Y | 84986.55 | 139977.85 | 111022.47 | 105128.53 | 99984.18
 | 123 | 000123 |  | 12001 | 2009-12-31 00:00:00 | Y | 0 | 0 | 0 | 0 | 0
 | 124 | 000124 |  | 12901 | 2010-06-30 00:00:00 |  | 0 | 0 | 0 | 0
 | 125 | 000125 |  | 12001 | 2010-06-30 00:00:00 | Y | 84986.55 | 139977.85 | 105736.69 | 100123.32 | 99984.18
 | 126 | 000126 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 99624.02 | 94335.18 | 89504.23
 | 127 | 000127 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 80348.18 | 76082.66 | 89504.23
 | 128 | 000128 |  | 12001 | 2009-12-31 00:00:00 |  | 84496.66 | 139170.99 | 84496.66 | 84496.66
 | 129 | 000129 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 136729.36 | 129470.68 | 89504.23
 | 130 | 000130 |  | 12901 | 2010-06-30 00:00:00 |  | 0 | 0 | 0 | 0
 | 131 | 000131 |  | 12901 | 2010-06-30 00:00:00 | Y | 0 | 0 | 0 | 0 | 0
 | 132 | 000132 |  | 12901 | 2010-06-30 00:00:00 | Y | 0 | 0 | 0 | 0 | 0
 | 133 | 000133 |  | 12001 | 2009-12-31 00:00:00 | Y | 0 | 0 | 0 | 0 | 0
 | 134 | 000134 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 107248.59 | 101554.95 | 89504.23
 | 135 | 000135 |  | 12001 | 2009-12-31 00:00:00 | Y | 0 | 0 | 0 | 0 | 0
 | 136 | 000136 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 76078.61 | 76078.61 | 89504.23
 | 137 | 000137 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 121738.54 | 115275.69 | 89504.23
 | 138 | 000138 |  | 12001 | 2010-06-30 00:00:00 |  | 76078.61 | 125305.96 | 106212.65 | 76078.61
 | 139 | 000139 |  | 12901 | 2009-12-31 00:00:00 |  | 0 | 0 | 0 | 0
 | 140 | 000140 |  | 12901 | 2010-06-30 00:00:00 | Y | 0 | 0 | 0 | 0 | 0
 | 141 | 000141 |  | 12001 | 2010-06-30 00:00:00 |  | 84986.55 | 139977.85 | 142020.61 | 139977.84
 | 142 | 000142 |  | 12001 | 2010-06-30 00:00:00 | Y | 76078.61 | 125305.96 | 76078.61 | 76078.61 | 89504.23
 | 143 | 000143 |  | 12001 | 2010-06-30 00:00:00 |  | 84986.55 | 139977.85 | 140929.41 | 142689.1
 | 144 | 000144 |  | 12901 | 2009-12-31 00:00:00 |  | 0 | 0 | 0 | 0
 | 145 | 000145 |  | 12901 | 2009-12-31 00:00:00 |  | 0 | 0 | 0 | 0
 | 2 | 80002 |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A