Best coefficient trendline and the best range

montecarlo2012

montecarlo2012

Well-known Member
Joined
Jan 26, 2011
Messages
984
Office Version
  1. 2010
Platform
  1. Windows
I am trying to find the best coefficient trendline, but therange of the information is also very important.<o:p></o:p>
So the goal is what is the best RANGE, and the bestCOEFFICIENT TRENDLINE, that really can be trustfull when you try to forecastingsomething and is not a ferrytail.<o:p></o:p>
Is a five columns of random numbers A1:E37 I would like tocalculate the coefficient trend line in the range of two rows (A2:E3) andcompare with A1:E1, and see how many numbers of the trendline match with in thewhole six trend lines, and in the whole data (my data is A1:E6060), after ,calculate for 3 rows, four, etc until 18 in this experiment, the output is bypercent, wich line and wich coefficient trend line have more matches when youtry to forecasting anything.<o:p></o:p>
Code: 
[/SIZE][TABLE="width: 85"]
[SIZE=3] [/SIZE]<colgroup><col style="width: 17pt; mso-width-source: userset; mso-width-alt: 736;" span="5" width="23">[SIZE=3][/SIZE][SIZE=3] [/SIZE]<tbody>[TR]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 23, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]2[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 23, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]3[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 23, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]17[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 23, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]33[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 23, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]36[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]2[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]9[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]10[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]21[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]9[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]16[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]27[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]31[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]36[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]6[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]7[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]21[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]26[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]36[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]17[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]20[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]21[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]24[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]36[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]4[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]11[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]13[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]18[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]35[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]5[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]22[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]29[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]32[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]3[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]10[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]20[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]24[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3][/SIZE]</tbody>[/TABLE]
[SIZE=3]
In this little example I can say the first coefficient trendlines must be calculate for 2-9 andcount matches with the next line 2-3-17-33-36 if not matches the percentes ofthe lines will be 0% otherwise indicate it; and after 9-16 etc, etc. and after2-9-6 and the same, after 2-9-6-17 and so on.and the same for the whole sixcoefficient trendline and for the whole ranges and data.
Code: 
[/SIZE]
[TABLE="width: 342"]
[SIZE=3] [/SIZE]<colgroup><col style="width: 48pt;" width="64">[SIZE=3][/SIZE][SIZE=3] [/SIZE]<col style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;" width="72">[SIZE=3] [/SIZE]<col style="width: 48pt;" span="5" width="64">[SIZE=3] [/SIZE]<tbody>[TR]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 72, bgcolor: transparent"][SIZE=3]LOG[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]POLY[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]LINEAR[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]pwer[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]moving[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]exponent[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3]RANGE[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]45%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]0%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]5%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-23%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-43%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-63%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]10%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]0.10%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]15.00%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]13%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]15.87%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]18.37%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]4[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]0.50%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]0%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]25%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]33.00%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]45%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]58%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]75%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]0%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]35%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-3%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-23%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-43%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]6[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]100%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]25%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]45.00%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]2%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-26%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]-53.33%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]7[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]99%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]20%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]55%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]14%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-8%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-29%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]8[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]116%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]24.98%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]65%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]18%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]-7.96%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-34%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]9[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]133.60%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]30%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]75.00%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]20.92%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-8%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]-37.68%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]10[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]151%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]35%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]85%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]24%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-9%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-42%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]11[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]169%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]40%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]95%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]28%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-9%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-46%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]12[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]186%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]45%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]105.00%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]31%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-10%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]-50.19%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]13[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]204%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]49.93%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]115%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]34%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]-10.06%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-54%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]14[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]221.10%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]55%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]125%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]37.57%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-10%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-59%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]15[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]239%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]60%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]135.00%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]41%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-11%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]-62.70%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]16[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]256%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]65%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]145%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]44%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-11%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-67%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]17[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]274%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]70%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]155%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]48%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-12%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]-71%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]18[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]291%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]74.88%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]165.00%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl64, bgcolor: transparent, align: right"][SIZE=3]51%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]-12.16%[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]-75.21%[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3][/SIZE]</tbody>[/TABLE]

[SIZE=3]
this is the output. I don't know how to calculate; output numbers are fake, you know if I know ,I don't ask. is just how looks like the output.

next is the data example only. because my data is A1:E6060.

Code: 
[/SIZE]
[TABLE="width: 85"]
[SIZE=3] [/SIZE]<colgroup><col style="width: 17pt; mso-width-source: userset; mso-width-alt: 736;" span="5" width="23">[SIZE=3][/SIZE][SIZE=3] [/SIZE]<tbody>[TR]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 23, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]2[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 23, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]3[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 23, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]17[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 23, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]33[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 23, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]36[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]2[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]9[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]10[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]21[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]9[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]16[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]27[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]31[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]36[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]6[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]7[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]21[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]26[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]36[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]17[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]20[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]21[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]24[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]36[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]4[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]11[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]13[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]18[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]35[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]5[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]22[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]29[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]32[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]3[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]10[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]20[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]24[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]8[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]10[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]12[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]21[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]31[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]2[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]12[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]31[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]35[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]1[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]25[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]28[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]29[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]12[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]23[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]26[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]34[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]35[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]5[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]16[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]21[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]28[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]11[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]12[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]13[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]31[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]1[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]7[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]25[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]30[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]33[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]23[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]24[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]30[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]33[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]34[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]1[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]3[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]23[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]33[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]36[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]2[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]11[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]12[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]27[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]10[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]12[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]20[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]33[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]36[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]8[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]12[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]22[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]26[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]31[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]2[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]5[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]6[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]7[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]31[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]1[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]5[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]28[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]32[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]6[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]8[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]17[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]27[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]36[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]6[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]8[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]9[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]11[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]17[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]6[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]17[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]24[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]33[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]4[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]10[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]24[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]28[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]33[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]5[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]6[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]17[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]31[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]34[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]14[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]18[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]23[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]33[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]5[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]11[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]27[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]36[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]2[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]7[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]24[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]27[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]30[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]2[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]12[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]26[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]27[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]28[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]9[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]14[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]15[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]29[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]30[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]4[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]6[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]8[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]24[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]28[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]1[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]5[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]16[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]34[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]2[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]10[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]14[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]19[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]31[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]3[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]10[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]14[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]29[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]32[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]6[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]20[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]23[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]27[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]30[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]15[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]21[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]23[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]27[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]29[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]16[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]22[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]23[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]25[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]31[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]1[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]3[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]5[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]7[/SIZE][/FONT][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][FONT=Arial][SIZE=3]9[/SIZE][/FONT][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3][/SIZE]</tbody>[/TABLE]

[SIZE=3]
thanks for reading this post, HAPPY HOLYDAY FOR EVERYBODY.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
You must log in or register to reply here.

Similar threads

K
  • Question
conditional formatting question
Replies
2
Views
188
kerm007
K
imback2nite
  • Solved
VBA help.
2
Replies
10
Views
388
Peter_SSs
Peter_SSs
J
  • Solved
Count Values in sequence
Replies
3
Views
162
myall_blues
myall_blues
M
  • Solved
Automating episode numbers when date changes
Replies
6
Views
124
Keebler
Keebler
K
  • Question
Excel Pivot table Time Values is not populating same as Source Sheet
Replies
1
Views
324
awoohaw
awoohaw

Forum statistics

Threads
1,215,474
Messages
6,125,024
Members
449,204
Latest member
LKN2GO

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top