This time I have set up the template in a spreadsheet and set up the row data elements in a row so it goes .tr..td..X../td..td.X../td..td..X../td…………./tr. and copied in the original table to the same spreadsheet. I then link each data element (.X.) of the html data back to the original table data element and then C&P the html parts from the spreadsheet into wordpress.
It seems to work. And next week I can just copy the original table into the same R/C and that will produce next week’s table. All I need to do is C&P. (The Total column is for the Season, the +/- column is point delta since Monday)
| TeamName | HR | R | RBI | AVG | SB | W | SV | SO | ERA | WHIP | TOTAL | +/- |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Budchuggers | 7.5 | 10 | 10 | 9 | 2 | 7.5 | 7 | 8 | 8 | 9 | 78 | 2 |
| Rocky Coloradans | 7.5 | 9 | 8 | 8 | 9 | 9 | 3 | 7 | 9 | 5 | 74.5 | -3.5 |
| Dingleberries | 10 | 5.5 | 6.5 | 1 | 8 | 1 | 10 | 1 | 10 | 10 | 63 | 0 |
| Pork Pirates | 6 | 7 | 6.5 | 5 | 1 | 10 | 4 | 10 | 7 | 6 | 62.5 | 2.5 |
| Indians | 4 | 5.5 | 4 | 3 | 7 | 5 | 6 | 6 | 6 | 7 | 53.5 | 2 |
| GANYFs | 1 | 2 | 5 | 10 | 3 | 7.5 | 9 | 5 | 5 | 4 | 51.5 | -0.5 |
| Shamu Whales | 9 | 8 | 9 | 7 | 4 | 6 | 1 | 2 | 1 | 1 | 48 | 0 |
| Boston Ballbusters | 5 | 3 | 2 | 2 | 6 | 3.5 | 2 | 9 | 4 | 8 | 44.5 | 0.5 |
| Homestead Grays | 2 | 4 | 3 | 6 | 5 | 2 | 8 | 4 | 2 | 3 | 39 | 4 |
| Rangers | 3 | 1 | 1 | 4 | 10 | 3.5 | 5 | 3 | 3 | 2 | 35.5 | -7 |