peterbirks (![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
peterbirks) wrote2005-08-31 07:54 pm
peterbirks) wrote2005-08-31 07:54 pm
This month's figures
Just to show that I am not the type to hide my face from the grizzly stuff, here's the month's figures.
BTW Mike, I've had some thoughts about how to convert the Excel stuff into HTML, but it's messy. Basically you use the macro (or parts thereof) that I sent you, which converts from Excel to raw HTML. You then open that HTML in Word and run a Word macro on it which looks for the minus figure. When it finds a minus figure, it "steps back in time" to find the "td" code before that minus figure. It then pastes in the bgcolor="#FF0000" directly after the td code. It then searches for the next minus figure, and repeats the process. This gives you a customised red figure, but does not delete the minus sign.
You then close the file (saving it as a text file) and repopen int in Notepad. Strip out the crap, and you have a nice HTML table.
Well, I said it was messy. But it's quicker than doing it manually.
Not much to be said, really. A sea of red, but somehow I still managed to end up in profit on Party on the month (not that we are counting months any more :-). The Betfair numbers really are a bit of an anomaly -- I've won so much on that site in the last year (given how few hours I have played on it seriously) that a couple of hours' nightmare in a good game are going to wreck any figures.
I still need a break. I think I shall just play out the bonus on Party this month. In fact, I might go on a bonus hunting foray.
BTW Mike, I've had some thoughts about how to convert the Excel stuff into HTML, but it's messy. Basically you use the macro (or parts thereof) that I sent you, which converts from Excel to raw HTML. You then open that HTML in Word and run a Word macro on it which looks for the minus figure. When it finds a minus figure, it "steps back in time" to find the "td" code before that minus figure. It then pastes in the bgcolor="#FF0000" directly after the td code. It then searches for the next minus figure, and repeats the process. This gives you a customised red figure, but does not delete the minus sign.
You then close the file (saving it as a text file) and repopen int in Notepad. Strip out the crap, and you have a nice HTML table.
Well, I said it was messy. But it's quicker than doing it manually.
| SITE | $10-$20 | $5-$10 | $15-$30 | $5.00 | 25c-50c(PLO) | 50C-$1(TD) | $25.00 | Grand Total |
| PTY | $102 | -$255 | $175 | $22 | ||||
| PP | $47 | $47 | ||||||
| Betfair | -$351 | -$86 | -$17 | -$454 | ||||
| UB | $159 | -$3 | $156 | |||||
| SJ | -$55 | -$55 | ||||||
| Winnings | -$249 | -$341 | $175 | -$17 | $206 | -$3 | -$55 | -$284 |
| Sum of Hours | 1.50 | 64.75 | 16.75 | 6.00 | 16.50 | 0.25 | 2.00 | 107.75 |
| Avge Per hour | -$166 | -$5 | $10 | -$2.83 | $12.48 | -$12 | -$27 | -$2.64 |
Not much to be said, really. A sea of red, but somehow I still managed to end up in profit on Party on the month (not that we are counting months any more :-). The Betfair numbers really are a bit of an anomaly -- I've won so much on that site in the last year (given how few hours I have played on it seriously) that a couple of hours' nightmare in a good game are going to wreck any figures.
I still need a break. I think I shall just play out the bonus on Party this month. In fact, I might go on a bonus hunting foray.