TOP
Convert ExcelData(tab separated value) to query
Step1
->
Step2
->
Step3
->
Step4
->
Step5
->
Result
Sample 2010/1/1 2010/2/1 2010/3/1 2010/4/1 2010/5/1 2010/6/1 2010/7/1 2010/8/1 2010/9/1 2010/10/1 2010/11/1 2010/12/1 total product "plan or achievement" amount sales amount sales amount sales amount sales amount sales amount sales amount sales amount sales amount sales amount sales amount sales amount sales amount sales mode-3 plan 1 1,000.01 2 1,000.02 3 1,000.03 4 1,000.04 5 1,000.05 6 1,000.06 7 1,000.07 8 1,000.08 9 1,000.09 10 1,000.10 11 1,000.11 12 1,000.12 78 12,000.78 achievement 101 2,001.00 102 2,002.00 103 2,003.00 104 2,004.00 105 2,005.00 106 2,006.00 107 2,007.00 108 2,008.00 109 2,009.00 110 2,010.00 111 2,011.00 112 2,012.00 1278 24,078.00 mode-3S plan 13 1,000.13 14 1,000.14 15 1,000.15 16 1,000.16 17 1,000.17 18 1,000.18 19 1,000.19 20 1,000.20 21 1,000.21 22 1,000.22 23 1,000.23 24 1,000.24 222 12,002.22 achievement 113 2,013.00 114 2,014.00 115 2,015.00 116 2,016.00 117 2,017.00 118 2,018.00 119 2,019.00 120 2,020.00 121 2,021.00 122 2,022.00 123 2,023.00 124 2,024.00 1422 24,222.00 mode-4 plan 25 1,000.25 26 1,000.26 27 1,000.27 28 1,000.28 29 1,000.29 30 1,000.30 31 1,000.31 32 1,000.32 33 1,000.33 34 1,000.34 35 1,000.35 36 1,000.36 366 12,003.66 achievement 125 2,025.00 126 2,026.00 127 2,027.00 128 2,028.00 129 2,029.00 130 2,030.00 131 2,031.00 132 2,032.00 133 2,033.00 134 2,034.00 135 2,035.00 136 2,036.00 1566 24,366.00 mode-4S plan 37 1,000.37 38 1,000.38 39 1,000.39 40 1,000.40 41 1,000.41 42 1,000.42 43 1,000.43 44 1,000.44 45 1,000.45 46 1,000.46 47 1,000.47 48 1,000.48 510 12,005.10 achievement 137 2,037.00 138 2,038.00 139 2,039.00 140 2,040.00 141 2,041.00 142 2,042.00 143 2,043.00 144 2,044.00 145 2,045.00 146 2,046.00 147 2,047.00 148 2,048.00 1710 24,510.00 mode-5 plan 0 0.00 achievement 0 0.00 "mode-5 Plus" plan 49 1,000.49 50 1,000.50 51 1,000.51 52 1,000.52 53 1,000.53 54 1,000.54 55 1,000.55 56 1,000.56 57 1,000.57 58 1,000.58 59 1,000.59 60 1,000.60 654 12,006.54 achievement 149 2,049.00 150 2,050.00 151 2,051.00 152 2,052.00 153 2,053.00 154 2,054.00 155 2,055.00 156 2,056.00 157 2,057.00 158 2,058.00 159 2,059.00 160 2,060.00 1854 24,654.00