To get the stats to populate correctly follow these directions
Go to your Yahoo League Web Page
Then Click on Schedules & Results.
Then copy each week’s information following these easy steps.
Using Week1 as an example:
From the Schedule & Results page click on Week 1, under Regular Season.
Then click on the final link next to each match up. You will then be greeted with the screen showing the results for that match up. Then highlight only the data as shown, with a yellow background in this example, and copy the highlighted data by clicking edit -> copy in Internet Explorer. Notice you do not highlight the upper row.
|
Team |
R |
HR |
RBI |
SB |
AVG |
|
W |
SV |
K |
ERA |
WHIP |
|
Score |
|
Manager 1 |
49 |
12 |
37 |
8 |
.285 |
|
3 |
3 |
29 |
3.14 |
1.39 |
|
6 |
|
Manager 2 |
43 |
8 |
41 |
3 |
.302 |
|
4 |
2 |
35 |
3.71 |
1.16 |
|
6 |
Then open webfbb.xls file and paste the information into the Week1 Tab, starting on Row 3. If everything went correctly for each match up the result should look as it does below. Please note that you must use the same manager name for each week. And when you copy and paste the data it will take the Team Name. Something I do, is just change all Manager Names to their actual Manager Name, and when I update each week’s data I change the Team Name of the week to match their real Manager Name. Whatever you do just ensure the names are consistent
|
|
|
|
Week 1 |
|
|
|
|||||||
|
Team |
R |
HR |
RBI |
SB |
AVG |
|
W |
SV |
K |
ERA |
WHIP |
|
Score |
|
Manager 1 |
39 |
5 |
27 |
8 |
.306 |
|
3 |
5 |
37 |
4.53 |
1.47 |
|
3 |
|
Manager 2 |
46 |
12 |
58 |
5 |
.311 |
|
5 |
1 |
60 |
4.48 |
1.35 |
|
9 |
|
Manager 3 |
43 |
18 |
50 |
5 |
.328 |
|
1 |
1 |
38 |
6.31 |
1.51 |
|
5 |
|
Manager 4 |
42 |
9 |
34 |
6 |
.288 |
|
3 |
3 |
47 |
6.04 |
1.44 |
|
7 |
|
Manager 5 |
39 |
10 |
36 |
1 |
.280 |
|
5 |
0 |
46 |
3.94 |
1.38 |
|
3 |
|
Manager 6 |
49 |
14 |
37 |
5 |
.365 |
|
5 |
4 |
26 |
4.71 |
1.13 |
|
8 |
|
Manager 7 |
37 |
11 |
43 |
6 |
.305 |
|
6 |
1 |
55 |
3.54 |
1.00 |
|
10 |
|
Manager 8 |
35 |
12 |
33 |
1 |
.294 |
|
4 |
0 |
37 |
5.63 |
1.47 |
|
2 |
|
Manager 9 |
42 |
17 |
48 |
5 |
.347 |
|
2 |
0 |
50 |
4.38 |
1.29 |
|
7 |
|
Manager
10 |
36 |
13 |
40 |
3 |
.300 |
|
4 |
5 |
53 |
4.23 |
1.39 |
|
5 |
After doing the above for each scheduled match up for each week, you’re done. Now let the real magic begin! Close the webfbb.xls file and open the webver.xls in Excel. When you open the file Excel will ask if you want to update the file. Click Yes. And get ready to complete the last step.
Go to the Summary Tab, and type in the 10 managers names, as they were listed in your webfbb.xls file. I would like to say you could copy and paste the names, but Excel didn’t like it when I tried. This will allow all of the VLOOKUPs to be performed. If all goes well, as you add the names the stats will appear.
Now you are all set! If you are running Office 2000 or Office XP, just save as a web page and copy the resulting file, AND FOLDER, and you can have a web page with all this information. Like I did for my league.
If you have any questions drop me a line at [email protected].