Spreadsheet: 116713d1312044656-transferring-results-and-drop-down-lists-example1
Sheet: PRA Log

 |  | 145 | <--------  Select
 |  | NUMBER | NAME |  |  |  | 2009 | 2009 | 2009 | 2009 | 2009
 |  |  | . |  |  |  | Data 1 | Data 2 | Data 3 | Data 4 | Data 5 |  |  | Comments
 | 1 | 80001 |  |  |  | Y | 79337.17360864984 | 130672.9939277066 | 88584.54 | 84053.6 | 93337.86 |  | 1.0267
 | 2 | 80002 |  |  |  |  | 80073.11931354947 | 131885.1355531205 | 122476.05 | 115974.04 |  |  | 1.0114
 | 3 | 000003 |  |  |  |  | 80073.11931354947 | 131885.1355531205 | 80073.12 | 80073.12 |  |  | 1.0114
 | 4 | 000004 |  |  |  | Y |  |  |  |  |  |  | 1.0114
 | 5 | 000005 |  |  |  |  | 85590.34791762226 | 140972.337746672 | 141776.03 | 140972.33 |  |  | 1.0267
 | 6 | 000006 |  |  |  |  | 85590.34791762226 | 140972.337746672 | 85590.35 | 85590.35 |  |  | 1.0267
 | 7 | 000007 |  |  |  | Y | 86384.29241060246 | 142280.0131690121 | 133259.76 | 126185.24 | 101628.58 |  | 1.0114
 | 8 | 000008 |  |  |  | Y | 85590.34791762226 | 140972.337746672 | 99534 | 94249.93 | 100694.52 |  | 1.0267
 | 9 | 000009 |  |  |  | Y | 85590.34791762226 | 140972.337746672 | 113803.22 | 107761.63 | 100694.52 |  | 1.0267
 | 10 | 000010 |  |  |  |  | 85590.34791762226 | 140972.337746672 | 85590.35 | 85590.35 |  |  | 1.0267
 | 11 | 000011 |  |  |  |  | 85590.34791762226 | 140972.337746672 | 85590.35 | 85590.35 |  |  | 1.0267
 | 12 | 000012 |  |  |  |  |  |  |  |  |  |  | 1.0228
 | 13 | 000013 |  |  |  | Y |  |  |  |  |  |  | 1.0114
 | 14 | 000014 |  |  |  | Y | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 15 | 000015 |  |  |  |  | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 16 | 000016 |  |  |  |  | 80587.80132468078 | 132732.8555457362 | 82301.9 | 80587.80132468078 |  |  | 1.0267
 | 17 | 000017 |  |  |  |  | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 18 | 000018 |  |  |  |  | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 19 | 000019 |  |  |  |  | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 20 | 000020 |  |  |  |  | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 21 | 000021 |  |  |  |  | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 22 | 000022 |  |  |  |  | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 23 | 000023 |  |  |  |  | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 24 | 000024 |  |  |  | Y | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 25 | 000025 |  |  |  | Y | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 26 | 000026 |  |  |  | Y | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 27 | 000027 |  |  |  |  | 80587.80132468078 | 132732.8555457362 | 81164.78 | 80587.80132468078 |  |  | 1.0267
 | 28 | 000028 |  |  |  |  | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 29 | 000029 |  |  |  |  | 80587.80132468078 | 132732.8555457362 | 124471.8 | 117863.85 |  |  | 1.0267
 | 30 | 000030 |  |  |  | Y | 80587.80132468078 | 132732.8555457362 | 80587.80132468078 | 80587.80132468078 |  |  | 1.0267
 | 31 | 000031 |  |  |  | Y | 80587.80132468078 | 132732.8555457362 | 119349.53 | 113013.51 | 94809.18 |  | 1.0267
 | 32 | 000032 |  |  |  |  |  |  |  |  |  |  | 1.0114
 | 33 | 000033 |  |  |  |  |  |  |  |  |  |  | 1.0114
 | 34 | 000034 |  |  |  |  | 86699.85712817781 | 142799.7582623512 | 102391.76 | 96955.98 |  |  | 1.0114
 | 35 | 000035 |  |  |  | Y | 82360.92410827322 | 135653.2753543837 | 82360.93 | 82360.93 | 96895.19 |  | 1.0114
 | 36 | 000036 |  |  |  |  | 86699.85712817781 | 142799.7582623512 | 147701.12 | 145776.02 |  |  | 1.0114
 | 37 | 000037 |  |  |  | Y | 82360.92410827322 | 135653.2753543837 | 101765.51 | 96362.96 | 96895.19 |  | 1.0114
 | 38 | 000038 |  |  |  | Y | 82360.92410827322 | 135653.2753543837 | 138367.75 | 138083.56 | 96895.19 |  | 1.0114
 | 39 | 000039 |  |  |  | Y | 86699.85712817781 | 142799.7582623512 | 98376.69 | 93154.06 | 101999.83 |  | 1.0114
 | 40 | 000040 |  |  |  | Y | 80295.59052189175 | 132251.5659428308 | 93024.39 | 93024.39 | 96025.25 |  | 1.0114
 | 41 | 000041 |  |  |  | Y | 86699.85712817781 | 142799.7582623512 | 97849.31 | 92654.66 | 101999.83 |  | 1.0114
 | 42 | 000042 |  |  |  | Y | 82360.92410827322 | 135653.2753543837 | 88789.11 | 84075.46 | 96895.19 |  | 1.0114
 | 43 | 000043 |  |  |  | Y | 82360.92410827322 | 135653.2753543837 | 106516.03 | 100861.31 | 96895.19 |  | 1.0114
 | 44 | 000044 |  |  |  | Y | 86699.85712817781 | 142799.7582623512 | 86699.86 | 86699.86 | 101999.83 |  | 1.0114
 | 45 | 000045 |  |  |  | Y | 82360.92410827322 | 135653.2753543837 | 98152.13 | 92941.41 | 96895.19 |  | 1.0114
 | 46 | 000046 |  |  |  |  | 82360.92410827322 | 135653.2753543837 | 131432.6 | 124455.09 |  |  | 1.0114
 | 47 | 000047 |  |  |  |  | 82360.92410827322 | 135653.2753543837 | 92567 | 92567 |  |  | 1.0114
 | 48 | 000048 |  |  |  | Y | 82360.92410827322 | 135653.2753543837 | 94110.29 | 89114.13 | 96895.19 |  | 1.0114
 | 49 | 000049 |  |  |  |  | 82360.92410827322 | 135653.2753543837 | 140600.4906 | 140205.8 |  |  | 1.0114
 | 50 | 000050 |  |  |  | Y | 86457.19804222124 | 142400.088789641 | 137836.99 | 130519.46 | 103046.8 |  | 1.0114
 | 51 | 000051 |  |  |  |  | 82360.92410827322 | 135653.2753543837 | 107799.02 | 107799.02 |  |  | 1.0114
 | 52 | 000052 |  |  |  | Y | 82360.92410827322 | 135653.2753543837 | 99262.51 | 93992.86 | 96895.19 |  | 1.0114
 | 53 | 000053 |  |  |  | Y | 86699.85712817781 | 142799.7582623512 | 86699.86 | 86699.86 | 104570.23 |  | 1.0114
 | 54 | 000054 |  |  |  | Y | 86699.85712817781 | 142799.7582623512 | 125579.92 | 118913.12 | 101999.83 |  | 1.0114
 | 55 | 000055 |  |  |  |  | 86712.87394636858 | 142821.1977266428 | 137221.42 | 129936.56 |  |  | 1.0114
 | 56 | 000056 |  |  |  | Y | 82360.92410827322 | 135653.2753543837 | 93873.36 | 88889.81 | 96895.19 |  | 1.0114
 | 57 | 000057 |  |  |  | Y | 86699.85712817781 | 142799.7582623512 | 98893.77 | 93643.67 | 101999.83 |  | 1.0114
 | 58 | 000058 |  |  |  |  | 86699.85712817781 | 142799.7582623512 | 147466.264653 | 147052.31 |  |  | 1.0114
 | 59 | 000059 |  |  |  |  | 82360.92410827322 | 135653.2753543837 | 109244.3 | 109244.3 |  |  | 1.0114
 | 60 | 000060 |  |  |  | Y | 82360.92410827322 | 135653.2753543837 | 88850.92 | 84133.97 | 96895.19 |  | 1.0114
 | 61 | 000061 |  |  |  | Y | 86699.85712817781 | 142799.7582623512 | 86699.86 | 86699.86 | 101999.83 |  | 1.0114
 | 62 | 000062 |  |  |  |  | 82360.92410827322 | 135653.2753543837 | 98036.79 | 92832.17 |  |  | 1.0114
 | 63 | 000063 |  |  |  | Y | 86699.85712817781 | 142799.7582623512 | 86699.86 | 86699.86 | 101999.83 |  | 1.0114
 | 64 | 000064 |  |  |  |  | 82360.92410827322 | 135653.2753543837 | 87623.1 | 82971.36 |  |  | 1.0114
 | 65 | 000065 |  |  |  |  | 82360.92410827322 | 135653.2753543837 | 92385.99 | 87481.39 |  |  | 1.0114
 | 66 | 000066 |  |  |  |  | 82360.92410827322 | 135653.2753543837 | 138544.74 | 138328.76 |  |  | 1.0114
 | 67 | 000067 |  |  |  | Y | 82360.92410827322 | 135653.2753543837 | 101983.87 | 96569.75 | 96895.19 |  | 1.0114
 | 68 | 000068 |  |  |  | Y | 82360.92410827322 | 135653.2753543837 | 107154.64 | 101466 | 96895.19 |  | 1.0114
 | 69 | 000069 |  |  |  | Y | 86699.85712817781 | 142799.7582623512 | 86699.86 | 86699.86 | 101999.83 |  | 1.0114
 | 70 | 000070 |  |  |  | Y | 86699.85712817781 | 142799.7582623512 | 145358.06 | 135562.42 | 101999.83 |  | 1.0114
 | 71 | 000071 |  |  |  |  | 86699.85712817781 | 142799.7582623512 | 86699.86 | 86699.86 |  |  | 1.0114
 | 72 | 000072 |  |  |  | Y | 85903.01080143293 | 141487.3091059823 | 85903.02 | 85903.02 | 101062.37 |  | 1.0267
 | 73 | 000073 |  |  |  |  | 85903.01080143293 | 141487.3091059823 | 85903.02 | 85903.02 |  |  | 1.0267
 | 74 | 000074 |  |  |  |  | 81603.95271966406 | 134406.5005538889 | 265628.21 | 252041.75 |  |  | 1.0267
 | 75 | 000075 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 77405.38 | 74100.14 | 87176.61 |  | 1.0267
 | 76 | 000076 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 89491.13 | 84740.22 | 87176.61 |  | 1.0267
 | 77 | 000077 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 98165.71 | 98165.71 | 87176.61 |  | 1.0267
 | 78 | 000078 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 91272.41 | 86426.93 | 87176.61 |  | 1.0267
 | 79 | 000079 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 122327.16 | 122881.61 | 87176.61 |  | 1.0267
 | 80 | 000080 |  |  |  | Y | 82776.4176921438 | 136337.6312416967 | 104974.72 | 99401.82 | 97384.03 |  | 1.0267
 | 81 | 000081 |  |  |  | Y | 73108.7072617931 | 120414.3399778641 | 122641.38 | 121053.43 | 87176.61 |  | 1.0267
 | 82 | 000082 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 125918.91 | 122049.69 | 87176.61 |  | 1.0267
 | 83 | 000083 |  |  |  |  | 74100.13878505476 | 122047.295116894 | 126133.65 | 122184.54 |  |  | 1.0267
 | 84 | 000084 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 74100.14 | 74100.14 | 87176.61 |  | 1.0267
 | 85 | 000085 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 78278.55 | 74122.86 | 87176.61 |  | 1.0267
 | 86 | 000086 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 105992.23 | 100365.31 | 87176.61 |  | 1.0267
 | 87 | 000087 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 100218.92 | 94898.5 | 87176.61 |  | 1.0267
 | 88 | 000088 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 97418.52 | 92246.74 | 87176.61 |  | 1.0267
 | 89 | 000089 |  |  |  |  | 74100.13878505476 | 122047.295116894 | 124004.56 | 122047.29 |  |  | 1.0267
 | 90 | 000090 |  |  |  |  | 74100.13878505476 | 122047.295116894 | 81090.26 | 81090.26 |  |  | 1.0267
 | 91 | 000091 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 95021.29 | 89976.78 | 87176.61 |  | 1.0267
 | 92 | 000092 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 94993.62 | 89950.57 | 87176.61 |  | 1.0267
 | 93 | 000093 |  |  |  |  | 82776.4176921438 | 136337.6312416967 | 82776.42 | 82776.42 |  |  | 1.0267
 | 94 | 000094 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 122294.91 | 122150.26 | 87176.61 |  | 1.0267
 | 95 | 000095 |  |  |  |  | 74100.13878505476 | 122047.295116894 | 78506.3 | 74338.52 |  |  | 1.0267
 | 96 | 000096 |  |  |  |  |  |  |  |  |  |  | 1.0267
 | 97 | 000097 |  |  |  | Y | 82776.4176921438 | 136337.6312416967 | 136337.63 | 135778.55 | 97384.03 |  | 1.0267
 | 98 | 000098 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 102608.59 | 97161.28 | 87176.61 |  | 1.0267
 | 99 | 000099 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 74100.14 | 74100.14 | 87176.61 |  | 1.0267
 | 100 | 000100 |  |  |  |  | 82776.4176921438 | 136337.6312416967 | 91038.71 | 91038.71 |  |  | 1.0267
 | 101 | 000101 |  |  |  | Y |  |  |  |  |  |  | 1.0267
 | 102 | 000102 |  |  |  | Y |  |  |  |  |  |  | 1.0267
 | 103 | 000103 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 133224.68 | 126152.04 | 87176.61 |  | 1.0267
 | 104 | 000104 |  |  |  |  |  |  |  |  |  |  | 1.0267
 | 105 | 000105 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 102612.58 | 97165.06 | 87176.61 |  | 1.0267
 | 106 | 000106 |  |  |  |  |  |  |  |  |  |  | 1.0267
 | 107 | 000107 |  |  |  |  | 74100.13878505476 | 122047.295116894 | 118845.33 | 118845.33 |  |  | 1.0267
 | 108 | 000108 |  |  |  |  | 74100.13878505476 | 122047.295116894 | 122047.29 | 116323.01 |  |  | 1.0267
 | 109 | 000109 |  |  |  |  | 82776.4176921438 | 136337.6312416967 | 88651.64 | 83945.32 |  |  | 1.0267
 | 110 | 000110 |  |  |  | Y | 83544.2584542059 | 137602.3194544054 | 83544.26 | 83544.26 | 98287.37 |  | 1.0114
 | 111 | 000111 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 124645.95 | 122047.29 | 87176.61 |  | 1.0267
 | 112 | 000112 |  |  |  | Y | 82776.4176921438 | 136337.6312416967 | 82776.42 | 82776.42 | 97384.03 |  | 1.0267
 | 113 | 000113 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 81412.39 | 77090.38 | 87176.61 |  | 1.0267
 | 114 | 000114 |  |  |  | Y | 74329.71147167646 | 122425.4148599106 | 91390.83 | 86539.09 | 87446.7 |  | 1.0267
 | 115 | 000115 |  |  |  | Y |  |  |  |  |  |  | 1.0267
 | 116 | 000116 |  |  |  | Y | 82776.4176921438 | 136337.6312416967 | 136337.63 | 134527.47 | 97384.03 |  | 1.0267
 | 117 | 000117 |  |  |  |  | 74100.13878505476 | 122047.295116894 | 92368.88 | 87465.19 |  |  | 1.0267
 | 118 | 000118 |  |  |  | Y | 83544.2584542059 | 137602.3194544054 | 141314.16 | 142972.73 | 98287.37 |  | 1.0114
 | 119 | 000119 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 122047.29 | 116245.02 | 87176.61 |  | 1.0267
 | 120 | 000120 |  |  |  |  |  |  |  |  |  |  | 1.0267
 | 121 | 000121 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 86556.54 | 81961.45 | 87176.61 |  | 1.0267
 | 122 | 000122 |  |  |  | Y | 82776.4176921438 | 136337.6312416967 | 108135.26 | 102394.59 | 97384.03 |  | 1.0267
 | 123 | 000123 |  |  |  | Y |  |  |  |  |  |  | 1.0114
 | 124 | 000124 |  |  |  |  |  |  |  |  |  |  | 1.0267
 | 125 | 000125 |  |  |  | Y | 82776.4176921438 | 136337.6312416967 | 102986.94 | 97519.55 | 97384.03 |  | 1.0267
 | 126 | 000126 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 97033.23 | 91881.93 | 87176.61 |  | 1.0267
 | 127 | 000127 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 78258.67 | 74104.08 | 87176.61 |  | 1.0267
 | 128 | 000128 |  |  |  |  | 83544.2584542059 | 137602.3194544054 | 83544.26 | 83544.26 |  |  | 1.0114
 | 129 | 000129 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 136729.36 | 129470.68 | 87176.61 |  | 1.0267
 | 130 | 000130 |  |  |  |  |  |  |  |  |  |  | 1.0267
 | 131 | 000131 |  |  |  | Y |  |  |  |  |  |  | 1.0267
 | 132 | 000132 |  |  |  | Y |  |  |  |  |  |  | 1.0267
 | 133 | 000133 |  |  |  | Y |  |  |  |  |  |  | 1.0114
 | 134 | 000134 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 104459.52 | 98913.95 | 87176.61 |  | 1.0267
 | 135 | 000135 |  |  |  | Y |  |  |  |  |  |  | 1.0114
 | 136 | 000136 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 74100.14 | 74100.14 | 87176.61 |  | 1.0267
 | 137 | 000137 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 118572.65 | 112277.87 | 87176.61 |  | 1.0267
 | 138 | 000138 |  |  |  |  | 74100.13878505476 | 122047.295116894 | 103450.52 | 74100.14 | 86369.21 |  | 1.0267
 | 139 | 000139 |  |  |  |  |  |  |  |  |  |  | 1.0114
 | 140 | 000140 |  |  |  | Y |  |  |  |  |  |  | 1.0267
 | 141 | 000141 |  |  |  |  | 82776.4176921438 | 136337.6312416967 | 138327.27 | 136337.63 |  |  | 1.0267
 | 142 | 000142 |  |  |  | Y | 74100.13878505476 | 122047.295116894 | 74100.14 | 74100.14 | 87176.61 |  | 1.0267
 | 143 | 000143 |  |  |  |  | 82776.4176921438 | 136337.6312416967 | 137264.45 | 138978.38 |  |  | 1.0267
 | 144 | 000144 |  |  |  |  |  |  |  |  |  |  | 1.0114
 | 145 | 000145 |  |  |  |  |  |  |  |  |  |  | 1.0114