this is what i just tried and it works pretty good, i used our canada super 7 since it has 47 balls.
1. Like Brad said, print your last page of chart 4 into a file.
2. open with word etc.
3. copy from word and paste in excel.
4. replace doubles spaces with a single space.
5. then convert text to columns, using delimited and make sure the tab , space is selected and also the other use = |
6. do this to all 3 sets to get your 47 colimns.
then cut the bottom to columns to the top 1 to stitch all 3 sets to make 47 columns.
7. select the new 47 and do a format-column-autofit [note get rid of any extra stuff, like a big line of dashes that would make the 1st column too big].
8. while still having the 47 columns selected do a file-printarea-set print area.
9. goto file-page setup and set to lansdscape and also fit to print to 1 page also sets the margins real small, i used .2 for top bottom right left and header footer, also select print gridlines.
10. print = looks beautifull all on 1 page. lots of work though
