Hi lads,

Complete Excel noob here, looking for some answers.

I play on a site that doesn't allow HUD software, so I can't get an automated graph of my annual earnings. I'd like to manually make a graph and believe Excel to be the best option out there. If anyone knows of other software that would be better suited, let me know.

I'm able to receive somewhat detailed reports by my poker provider of every Sit & Go I play, containing the starting time, the buy-in amount, the position I finished and the amount of money won/lost. I want to do the following with that information:

- Create a line graph with preferably two variables on the X-axis and one on the Y-axis. I'd like the X-axis to contain 1) the amount of Sit & Go's played and 2) the months of the year in which they were played (sort of like on PokerTableRatings back in the day, but with all twelve months). I'd like the Y-axis to contain profits.
- Find a way to make the line graph update automatically with every Sit & Go win/loss that I provide.
- Create a pie chart which shows the positions I finished in all Sit & Go's across the year.
- Find a way to make the pie chart update automatically with every Sit & Go finish I provide.

If anyone can offer me some tips and tricks, that would be much appreciated.

Cheers,
OG_Tuff

is this the real tuff fish? in all seriousness if you can pm proof I'll build it for you

what you want is fairly simple to do on your own but here's a quick and easy template


this is assuming your site provides columns A-D for you

just create a new column for +/- on each sng and then an additional column for total win/loss then you can make charts out of that pretty easily, just clicking around would be pretty simple

in column E you'd just type "=D2-B2" without quotes in E2 and then drag that down so it will automatically fill in E3 as =D3-B3 etc

for column F it's slightly trickier, in F2 type "=0+E2" and then in F3 type "=F2+E3" and then drag that down so the next one is "=F3+E4" and so on

if you're unclear what i mean by drag down there is a dot in the bottom right corner of each cell and you can click and drag that down to more cells

then go to the insert tab, highlight the columns you want to use and you'll see a bunch of graph options available

there's a million ways to tackle it, this is one of the simpler manners

This isn't helping me out at all! God almighty! Okay, well ehhduf, **** me to GODDAYUM TEARS! **** me to tears, okay it'sehh you know, we're all done.

Proof enough there, young gun? Bet ya some random on here couldn't pull off an impression like that if they practiced for a lifetime. Don't tussle with the Tuff, kid.

In all seriousness, thanks for the help. After I asked for advice on this thread I figured I shouldn't be relying on others too much and started working things out myself. Got like 80% through and then returned to the thread, where I found out I had to make a column that showed how my bankroll fluctuated to get the line across time. Nice easy fix with the explanation you gave as well. Thank you so much.

Made a simple, but clear and pretty graph now that's completely accurate. Very happy, wanted to figure this out for a while now. Now I only need to know how I can also implement the time period on the X-axis along with the Sit & Go's over time, like PokerTableRatings did it back in the day. That's for another time though.

Have a good one, mate!

I have string values and I want to parse out the numbers.

The string length varies though, it's A(number)B(number) where number is between 1 and 20. Examples of 4 different forms you could get:

A4B1 (I want the 4 and the 1)
A12B5
A6B11
A14B19

I can see how to do first and last case, but middle cases are the issue. I know of using LEFT and RIGHT functions - are there others for this problem?

Found this online, tested it and it works:

=SUMPRODUCT(MID(0&A2, LARGE(INDEX(ISNUMBER(--MID(A2, ROW(INDIRECT("1:"&LEN(A2))), 1)) * ROW(INDIRECT("1:"&LEN(A2))), 0), ROW(INDIRECT("1:"&LEN(A2))))+1, 1) * 10^ROW(INDIRECT("1:"&LEN(A2)))/10)

that's amazing it was out there, thanks....it does work - one issue though - I didn't explain output enough - I need the numbers in separate cells, otherwise still can't distinguish middle 2 cases

so like
A2B15 2 15
A11B5 11 5

seems like this formula could be tweaked to get it

I guess I could parse the 3 digit versions both ways - like 215 to get 2 15 or 21 5, and one way will not be possible, here the second way since 21>20...nope won't work because of 111

Ah right, in that case this will do it, although its use is limited to the format of the input you've specified AxBy where x and y are 1 or 2 digits.

To get the first number:

=IF(ISNUMBER(VALUE(MID(A2,2,2))),VALUE(MID(A2,2,2) ),VALUE(MID(A2,2,1)))

To get the second number:

=IF(ISNUMBER(VALUE(MID(A2,2,2))),VALUE(MID(A2,5,2) ),VALUE(MID(A2,4,2)))

that is perfect, thanks.

why would you not just split the data by a delimiter

having some issues with this



i'm unable to figure out how to do a sumif type of function in the S & T columns after the 2nd row

the formula for S2 is
T2 is
these work fine for the entire list, but not if I wanted to isolate for a specific buyin level such as in cell M3 = and O3 = I'm sure the solution is probably pretty simple, but i'm having a pretty big brain fart and unable to phrase it properly to find via google

it's not a big issue, don't really need this, but it bugs me that it should be pretty straightforward and yet i keep drawing blanks

You should be able to do this with countifs.

In S3, for example:

excellent, works perfectly much obliged

if any of you guys play bestball on yahoo and want this results tracker send me a pm

For home schooling purposes, what texts/resources would you recommend for a point just beyond the basics? We are just starting this now and aim to cover:

Open, navigate and close Microsoft Excel 2016
Enter, edit and format text and numbers
Enter basic Formulas
Use Relative and Absolute addressing
Print Worksheets
Basic charts

I have a decent guide for the above but nothing beyond this

thanks

I am exporting solver results across multiple flops

what i need is

instead of AhTh2d - how to get A T 2 with the card symbol?

I've found Google/YouTube are able to help you on a case by case basis

What is it you want to build? There's very likely a dozen video tutorials.

Find and replace

where are the card symbols? (preferably with colour)
ascii codes plz

I'm sure you can google just as well as rickroll can

I've no idea, it's to teach my daughter at home or more accurately something she can work through independently. I have a guide from a functional skills tutor for the basics that is good but nothing beyond the basics. Anything good tends to cost, eg a textbook, which I am happy to pay but don't know what to get. Rando YT vids are good when you know what you need to learn but not great when you want a broad scheme of work around say 'intermediate excel'. I guess its more of a question of teaching IT rather than how to perform specific functions, but the OP says ask him anything about excel so here it is!

Ah I see, everyone learns differently but I think by far the best thing to do here is to make it into a project based around one of her hobbies.

If I care about what I'm making I'm far likelier to both enjoy the process and remember what I learned.

Have never taken any of those courses or read any books etc so am in no place to rec nor judge then though so possibly I'm totally wrong and that is the proper path.

yeah great point. I am probably overly formal with learning styles, old school with the textbooks. Having said that my younger son who is 8 is using this thing called tynker which is basic programming/coding I think, he is doing Minecraft modding with it - to me this is recreational but I guess the skills are going to be useful, has to watch tutorials and focus quite a bit. Daughter is 11 and into lord of the rings at the minute, that could be a broad theme for a lot of IT and other projects, certainly powerpoint, word, literature, not too sure about excel. In any case thanks for the tip, I guess a lot of people will be having to think these things through for home schooling - schools are mostly not opening in the UK until September.

Hi,

I'm trying to use conditional formatting to colour code flops by monotone, two toned and rainbow. I've tried the format only cells that contain specific text and then by suit letter (c,s,d,h) 2 c and c or s and s or only one of each and then going to specific text and trying to write the formula. I don't know much about IF AND OR formulas though.

I've also tried using a formula to determine which cells to format but I don't know there either. This is tricky because I don't know the formula, but even when I do I need it to understand that there are four suits (c,h,s,d) but I want a 2 toned board to be the same regardless of whether it is ccs or hhd etc, and same with mono and rainbow.

Any advice?

How is this piece of **** software still in widespread use?

i could have sworn you've posted about this previously yeah? I don't get why you're using excel to tackle this or what specifically you are gaining from this - would be genuinely interested and if convinced it'd be nice would be happy to contribute hands on

i found a work around, but... it's not going to be pretty and very possibly brick your laptop if your dataset is massive because it requires a whole bunch of quite possibly unnecessary steps

ideally you can use this to filter and then color code the dataset manually in a separate file and then copy paste it into your master worksheet - that way you won't need to have the program perform the same operations over and over again as these flops are going to be static

Column A, where you flops are - using your formatof 5c7d9h etc
Column B "Clubs" = =IF(ISNUMBER(SEARCH("c",$A2)),1,0)
C - diamond = =IF(ISNUMBER(SEARCH("d",$A2)),1,0)
D - hearts = =IF(ISNUMBER(SEARCH("h",$A2)),1,0)
E - spades = =IF(ISNUMBER(SEARCH("s",$A2)),1,0)
Column F (the board) = =IF(SUM(B2:E2)=1,"mono",IF(SUM(B2:E2)=2,"two tone",IF(SUM(B2:E2)=3,"rainbow")))

this will output whether it's a mono/twotone/rainbow flop

i really can't stress enough that excel is not the tool you're looking for since your dataset is probably massive - so whenever humanly possible do all your data formatting and cleaning that originally relied upon a formula and copy paste the end result into a new file and use that to work with - if you attempted my workthrough on several thousand rows you'd be met with the black screen of death

I've never posted in this thread before and I'm just getting into working with solver outputs in excel, so probably someone else with the same intentions.

I'm on a Ryzen 7 3700x with 32gig of ram, so I hope this won't brick my computer. I'm intending to do this on 1755 flops.

I'll try it on a smaller number of boards I'm playing with right now. I mostly understand your formula, but I don't see how at the end it colour codes the flops.