montecarlo2012
Well-known Member
- Joined
- Jan 26, 2011
- Messages
- 986
- Office Version
- 2010
- Platform
- Windows
Hello.
I wish a real good weekend for all.
I am loading the macro for the all coefficient trendline, first need to be editing (loop require), and the real point for me is to be able to write the range of "X and Y" variable for the all formulas from the location J1 and K1, I would like to be able to say for example I need the formulas work from line 25 to 35 only or from 10 to 21 for example so I can see how really work.
On A3 column is the X and B3 the rest.
Thank you for reading this post.
I wish a real good weekend for all.
I am loading the macro for the all coefficient trendline, first need to be editing (loop require), and the real point for me is to be able to write the range of "X and Y" variable for the all formulas from the location J1 and K1, I would like to be able to say for example I need the formulas work from line 25 to 35 only or from 10 to 21 for example so I can see how really work.
On A3 column is the X and B3 the rest.
Code:
Sub Coe_fficient()Range("j3").Select
Selection.Formula = "=TRUNC(FORECAST(18,B3:B19,$A$3:$A$19))"
Range("j4").Select
Selection.Formula = "=TRUNC(TREND(B3:B19))"
Range("j5").Select
Selection.Formula = "=TRUNC(FORECAST(18,C3:C19,$A$3:$A$19))"
Range("j6").Select
Selection.Formula = "=TRUNC(TREND(C3:C19))"
Range("j7").Select
Selection.Formula = "=TRUNC(FORECAST(18,D3:D19,$A$3:$A$19))"
Range("j8").Select
Selection.Formula = "=TRUNC(TREND(D3:D19))"
Range("j9").Select
Selection.Formula = "=TRUNC(FORECAST(18,E3:E19,$A$3:$A$19))"
Range("j8").Select
Selection.Formula = "=TRUNC(TREND(E3:E19))"
Range("j10").Select
Selection.Formula = "=TRUNC(FORECAST(18,F3:F19,$A$3:$A$19))"
Range("j11").Select
Selection.Formula = "=TRUNC(TREND(F3:F19))"
Range("j12").Select
Selection.Formula = "=TRUNC(FORECAST(18,G3:G19,$A$3:$A$19))"
Range("j13").Select
Selection.Formula = "=TRUNC(TREND(G3:G19))"
Range("j14").Select
Selection.Formula = "=TRUNC(INTERCEPT(B3:B19,$A$3:$A$19))"
Range("j15").Select
Selection.Formula = "=TRUNC(INTERCEPT(C3:C19,$A$3:$A$19))"
Range("j16").Select
Selection.Formula = "=TRUNC(INTERCEPT(D3:D19,$A$3:$A$19))"
Range("j17").Select
Selection.Formula = "=TRUNC(INTERCEPT(E3:E19,$A$3:$A$19))"
Range("j18").Select
Selection.Formula = "=TRUNC(INTERCEPT(F3:F19,$A$3:$A$19))"
Range("j19").Select
Selection.Formula = "=TRUNC(INTERCEPT(G3:G19,$A$3:$A$19))"
Range("j20").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(B3:B37,LN($A$3:$A$37)),1,2))"
Range("j21").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(C3:C37,LN($A$3:$A$37)),1,2))"
Range("j22").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(D3:D37,LN($A$3:$A$37)),1,2))"
Range("j23").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(E3:E37,LN($A$3:$A$37)),1,2))"
Range("L3").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(F3:F37,LN($A$3:$A$37)),1,2))"
Range("L4").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(G3:G37,LN($A$3:$A$37)),1,2))"
Range("L5").Select
Selection.Formula = "=TRUNC(EXP(INDEX(LINEST(LN(B4:B37),LN($A$4:$A$37),,),1,2)))"
Range("L6").Select
Selection.Formula = "=TRUNC(EXP(INDEX(LINEST(LN(C4:C37),LN($A$4:$A$37),,),1,2)))"
Range("L7").Select
Selection.Formula = "=TRUNC(EXP(INDEX(LINEST(LN(D4:D37),LN($A$4:$A$37),,),1,2)))"
Range("L8").Select
Selection.Formula = "=TRUNC(EXP(INDEX(LINEST(LN(E4:E37),LN($A$4:$A$37),,),1,2)))"
Range("L9").Select
Selection.Formula = "=TRUNC(EXP(INDEX(LINEST(LN(F4:F37),LN($A$4:$A$37),,),1,2)))"
Range("L10").Select
Selection.Formula = "=TRUNC(EXP(INDEX(LINEST(LN(G4:G37),LN($A$4:$A$37),,),1,2)))"
Range("L11").Select
Selection.Formula = "=TRUNC(EXP(INDEX(LINEST(LN(B3:B19),$A$3:$A$19),1,2)))"
Range("L12").Select
Selection.Formula = "=TRUNC(EXP(INDEX(LINEST(LN(C3:C19),$A$3:$A$19),1,2)))"
Range("L13").Select
Selection.Formula = "=TRUNC(EXP(INDEX(LINEST(LN(D3:D19),$A$3:$A$19),1,2)))"
Range("L14").Select
Selection.Formula = "=TRUNC(EXP(INDEX(LINEST(LN(E3:E19),$A$3:$A$19),1,2)))"
Range("L15").Select
Selection.Formula = "=TRUNC(EXP(INDEX(LINEST(LN(F3:F19),$A$3:$A$19),1,2)))"
Range("L16").Select
Selection.Formula = "=TRUNC(EXP(INDEX(LINEST(LN(G3:G19),$A$3:$A$19),1,2)))"
Range("L17").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(B3:B19,$A$3:$A$19^{1,2}),1,3))"
Range("L18").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(C3:C19,$A$3:$A$19^{1,2}),1,3))"
Range("L19").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(D3:D19,$A$3:$A$19^{1,2}),1,3))"
Range("L20").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(E3:E19,$A$3:$A$19^{1,2}),1,3))"
Range("L21").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(F3:F19,$A$3:$A$19^{1,2}),1,3))"
Range("L22").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(G3:G19,$A$3:$A$19^{1,2}),1,3))"
Range("L23").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(B3:B19,$A$3:$A$19^{1,2,3}),1,4))"
Range("L24").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(C3:C19,$A$3:$A$19^{1,2,3}),1,4))"
Range("L25").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(D3:D19,$A$3:$A$19^{1,2,3}),1,4))"
Range("L26").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(E3:E19,$A$3:$A$19^{1,2,3}),1,4))"
Range("L27").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(F3:F19,$A$3:$A$19^{1,2,3}),1,4))"
Range("j48").Select
Selection.Formula = "=TRUNC(INDEX(LINEST(G3:G19,$A$3:$A$19^{1,2,3}),1,4))"
Range("a1").Select
End Sub
Code:
[TABLE="width: 832"]
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"] [/TD]
[TD="class: xl63, width: 64"] [/TD]
[TD="class: xl63, width: 64"] [/TD]
[TD="class: xl63, width: 64"] [/TD]
[TD="class: xl63, width: 64"] [/TD]
[TD="class: xl63, width: 64"] [/TD]
[TD="class: xl63, width: 64"] [/TD]
[TD="class: xl63, width: 64"] [/TD]
[TD="class: xl63, width: 64"] [/TD]
[TD="class: xl63, width: 64, align: right"]15[/TD]
[TD="class: xl63, width: 64, align: right"]33[/TD]
[TD="class: xl63, width: 64"] [/TD]
[TD="class: xl63, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]23[/TD]
[TD="class: xl63, align: right"]29[/TD]
[TD="class: xl63, align: right"]33[/TD]
[TD="class: xl63, align: right"]39[/TD]
[TD="class: xl63, align: right"]45[/TD]
[TD="class: xl63, align: right"]48[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]5[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]37[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]16[/TD]
[TD="class: xl63, align: right"]22[/TD]
[TD="class: xl63, align: right"]36[/TD]
[TD="class: xl63, align: right"]38[/TD]
[TD="class: xl63, align: right"]42[/TD]
[TD="class: xl63, align: right"]43[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]43[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]12[/TD]
[TD="class: xl63, align: right"]18[/TD]
[TD="class: xl63, align: right"]25[/TD]
[TD="class: xl63, align: right"]27[/TD]
[TD="class: xl63, align: right"]49[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]15[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]11[/TD]
[TD="class: xl63, align: right"]12[/TD]
[TD="class: xl63, align: right"]24[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]33[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]17[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]15[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]5[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]14[/TD]
[TD="class: xl63, align: right"]33[/TD]
[TD="class: xl63, align: right"]36[/TD]
[TD="class: xl63, align: right"]43[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]24[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]24[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]6[/TD]
[TD="class: xl63, align: right"]18[/TD]
[TD="class: xl63, align: right"]27[/TD]
[TD="class: xl63, align: right"]28[/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]35[/TD]
[TD="class: xl63, align: right"]43[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]32[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]33[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]7[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]17[/TD]
[TD="class: xl63, align: right"]27[/TD]
[TD="class: xl63, align: right"]36[/TD]
[TD="class: xl63, align: right"]42[/TD]
[TD="class: xl63, align: right"]45[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]34[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]34[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]8[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]21[/TD]
[TD="class: xl63, align: right"]27[/TD]
[TD="class: xl63, align: right"]32[/TD]
[TD="class: xl63, align: right"]53[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]43[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]41[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]9[/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]15[/TD]
[TD="class: xl63, align: right"]19[/TD]
[TD="class: xl63, align: right"]23[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]53[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]36[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]5[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]25[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]45[/TD]
[TD="class: xl63, align: right"]52[/TD]
[TD="class: xl63, align: right"]49[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]49[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]13[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]11[/TD]
[TD="class: xl63, align: right"]5[/TD]
[TD="class: xl63, align: right"]18[/TD]
[TD="class: xl63, align: right"]28[/TD]
[TD="class: xl63, align: right"]37[/TD]
[TD="class: xl63, align: right"]42[/TD]
[TD="class: xl63, align: right"]53[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]44[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]22[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]12[/TD]
[TD="class: xl63, align: right"]18[/TD]
[TD="class: xl63, align: right"]22[/TD]
[TD="class: xl63, align: right"]34[/TD]
[TD="class: xl63, align: right"]39[/TD]
[TD="class: xl63, align: right"]48[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]11[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]13[/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]8[/TD]
[TD="class: xl63, align: right"]36[/TD]
[TD="class: xl63, align: right"]37[/TD]
[TD="class: xl63, align: right"]40[/TD]
[TD="class: xl63, align: right"]46[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]17[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]35[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]14[/TD]
[TD="class: xl63, align: right"]9[/TD]
[TD="class: xl63, align: right"]18[/TD]
[TD="class: xl63, align: right"]22[/TD]
[TD="class: xl63, align: right"]37[/TD]
[TD="class: xl63, align: right"]44[/TD]
[TD="class: xl63, align: right"]53[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]24[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]43[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]15[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]13[/TD]
[TD="class: xl63, align: right"]23[/TD]
[TD="class: xl63, align: right"]49[/TD]
[TD="class: xl63, align: right"]51[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]32[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]19[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]16[/TD]
[TD="class: xl63, align: right"]13[/TD]
[TD="class: xl63, align: right"]17[/TD]
[TD="class: xl63, align: right"]19[/TD]
[TD="class: xl63, align: right"]23[/TD]
[TD="class: xl63, align: right"]39[/TD]
[TD="class: xl63, align: right"]34[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]35[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]22[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]17[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]21[/TD]
[TD="class: xl63, align: right"]23[/TD]
[TD="class: xl63, align: right"]25[/TD]
[TD="class: xl63, align: right"]33[/TD]
[TD="class: xl63, align: right"]53[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]44[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]25[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]18[/TD]
[TD="class: xl63, align: right"]11[/TD]
[TD="class: xl63, align: right"]29[/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]37[/TD]
[TD="class: xl63, align: right"]45[/TD]
[TD="class: xl63, align: right"]32[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]13[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]19[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]5[/TD]
[TD="class: xl63, align: right"]13[/TD]
[TD="class: xl63, align: right"]18[/TD]
[TD="class: xl63, align: right"]28[/TD]
[TD="class: xl63, align: right"]51[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]20[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]35[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]20[/TD]
[TD="class: xl63, align: right"]5[/TD]
[TD="class: xl63, align: right"]23[/TD]
[TD="class: xl63, align: right"]24[/TD]
[TD="class: xl63, align: right"]26[/TD]
[TD="class: xl63, align: right"]29[/TD]
[TD="class: xl63, align: right"]48[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]27[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]40[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]21[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63, align: right"]16[/TD]
[TD="class: xl63, align: right"]26[/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]34[/TD]
[TD="class: xl63, align: right"]27[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]35[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]22[/TD]
[TD="class: xl63, align: right"]8[/TD]
[TD="class: xl63, align: right"]9[/TD]
[TD="class: xl63, align: right"]19[/TD]
[TD="class: xl63, align: right"]23[/TD]
[TD="class: xl63, align: right"]26[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]23[/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]15[/TD]
[TD="class: xl63, align: right"]39[/TD]
[TD="class: xl63, align: right"]40[/TD]
[TD="class: xl63, align: right"]42[/TD]
[TD="class: xl63, align: right"]53[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]42[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]24[/TD]
[TD="class: xl63, align: right"]20[/TD]
[TD="class: xl63, align: right"]25[/TD]
[TD="class: xl63, align: right"]34[/TD]
[TD="class: xl63, align: right"]35[/TD]
[TD="class: xl63, align: right"]46[/TD]
[TD="class: xl63, align: right"]51[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]48[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]25[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]12[/TD]
[TD="class: xl63, align: right"]18[/TD]
[TD="class: xl63, align: right"]27[/TD]
[TD="class: xl63, align: right"]36[/TD]
[TD="class: xl63, align: right"]53[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63, align: right"]52[/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]26[/TD]
[TD="class: xl63, align: right"]14[/TD]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]32[/TD]
[TD="class: xl63, align: right"]34[/TD]
[TD="class: xl63, align: right"]52[/TD]
[TD="class: xl63, align: right"]52[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]27[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]12[/TD]
[TD="class: xl63, align: right"]16[/TD]
[TD="class: xl63, align: right"]29[/TD]
[TD="class: xl63, align: right"]43[/TD]
[TD="class: xl63, align: right"]44[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]28[/TD]
[TD="class: xl63, align: right"]9[/TD]
[TD="class: xl63, align: right"]27[/TD]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]37[/TD]
[TD="class: xl63, align: right"]41[/TD]
[TD="class: xl63, align: right"]49[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]29[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]12[/TD]
[TD="class: xl63, align: right"]40[/TD]
[TD="class: xl63, align: right"]44[/TD]
[TD="class: xl63, align: right"]47[/TD]
[TD="class: xl63, align: right"]53[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]5[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]35[/TD]
[TD="class: xl63, align: right"]51[/TD]
[TD="class: xl63, align: right"]47[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]31[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]6[/TD]
[TD="class: xl63, align: right"]15[/TD]
[TD="class: xl63, align: right"]20[/TD]
[TD="class: xl63, align: right"]24[/TD]
[TD="class: xl63, align: right"]53[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]32[/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]16[/TD]
[TD="class: xl63, align: right"]35[/TD]
[TD="class: xl63, align: right"]37[/TD]
[TD="class: xl63, align: right"]43[/TD]
[TD="class: xl63, align: right"]51[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]33[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]14[/TD]
[TD="class: xl63, align: right"]26[/TD]
[TD="class: xl63, align: right"]29[/TD]
[TD="class: xl63, align: right"]36[/TD]
[TD="class: xl63, align: right"]45[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]34[/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]5[/TD]
[TD="class: xl63, align: right"]7[/TD]
[TD="class: xl63, align: right"]19[/TD]
[TD="class: xl63, align: right"]34[/TD]
[TD="class: xl63, align: right"]46[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]35[/TD]
[TD="class: xl63, align: right"]6[/TD]
[TD="class: xl63, align: right"]8[/TD]
[TD="class: xl63, align: right"]19[/TD]
[TD="class: xl63, align: right"]21[/TD]
[TD="class: xl63, align: right"]39[/TD]
[TD="class: xl63, align: right"]47[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
</tbody>[/TABLE]