AleoMagus Spreadsheet v2.3h

[TruFloridaGator]

First question, do you use PT?

[TruFloridaGator]

Yeah, the best possibility could be in the Money tab, just add a rakeback field, or people could just use the "Other" field, however I use that for bonus money right now, so maybe an extra field would be nice, or just 2, one for "bonus" and one for "rakeback".

[astarck]

I like the idea of having a Bonus box and Rakeback box (since it's apparently not easily done with a simple formula) in addition to the Other box.

What about a column added to the individual sng pages that you type "R" or "Yes" or a checkbox that you recieved rakeback for that sng? Or a column where you manually indicate what site you played at, so rakeback could be tracked?

[astarck]

I know it wouldn't be hard to look through your affiliate for how much rakeback you generated, but it would really be nice to see how much you have in the spreadsheet.

[TruFloridaGator]

Yup, all of that sounds good.

[xLukex]

[ QUOTE ]
First question, do you use PT?

[/ QUOTE ]

Yes. I click the "Import from PT" button and all this funky crap comes up.

[astarck]

I was thinking about the spreadsheet today during a set and thought how it would be nice to have a page where my daily profit/tourney info is all on one page. For example:


Daily profit
-------------
Date | T#SNG1 | SNG Profit | T#SNG2 | SNG2 Profit
Jan-01 | 5 | 50.00 | 2 | <font color="red">(20.00)</font>


Also included might be Daily T#...Daily Total Wagered, Daily Profit, Daily ROI???

I realize that all of this information can be found under the black line on each sng tab, but maybe a page devoted to detailed daily breakdowns would be nice. Just more thoughts on how the spreadsheet can be improved.

EDIT - If you can't tell, I'm a HUGE fan of this spreadsheet.

[TruFloridaGator]

I'm a huge fan too, I don't mind it under the blackline, it's no big deal. I just want to be able to change the + numbers to green so they stand out more. Scrolling through it makes my eyes hurt. Is it possible?

[dfscott]

[ QUOTE ]
I'm a huge fan too, I don't mind it under the blackline, it's no big deal. I just want to be able to change the + numbers to green so they stand out more. Scrolling through it makes my eyes hurt. Is it possible?

[/ QUOTE ]

This is actually pretty easy.

1) Select all the cells you want to show green, red, or whatever.
2) From the main menu, select Format-&gt;Conditional Formatting.
3) Leave the first box at "Cell Value," set the second to "Greater than or equal to", and put "0" (no quotes) in the third box.
4) Click the "Format..." button and on the font tab, choose the color you want.

[J-Lo]

To anyone who can answer. Is there something wrong with MY spreadsheet? If I mulitply the ROI*buying*# SNGs played, it SHOULD equal the net total. But it is nowhere close to is. Also, the net total below the line, is different from above the line. Do I need to play more SNGs before it is all equal, because i have 975 @ $22 buyin and those number match up. 650 @ $33 and they don't matchup. and only 450@ $55's and those are no where close to checking against each other.