Poker Worksheet Calculate summary data for all Months

Mate, Can the Time and calendar, be added. to the workbook. I also Added FT in column Q in bankrollsheet.

time.jpg

Mate, Please help me look all I have to go thru and i cant make this work.

I am trying to find out why the Turbo hypers is not working here.

formula.jpg

hypers.jpg

I have looked at the file attached to post #202 for almost an hour and cannot figure out what is wrong. I suggest that we go back to the file attached to post #192 as that was the last one that seemed to work.
Please list very specifically one or two changes that need to be made and then wait until I have a chance to look.
Again, my real-life project is going to mean that it may take some time before I get to look at new requests.

I have one thats working, it seems to work in all catagorys. Im not sure exactly, what I did but all these days that you been gone I been trying my best to fix things. looking everywhere for clues to find the missing waldo, but many times I can't find the solution. even watch some videos, but not seem to get to far without you. here is a picture. Hope things going well in your real-life project or getting better.

d.jpg

1. From the picture most important is the Balance to reflect in pivot table after loss/profit
2. The number of wins by all 4 catagorys by player
the rest as you get time lastly the Blank on the Catagory chart.

thank you by stopping by

How would balance be manually calculated? What is speed_race's balance?
To get speed_race's # of wins in all 3 categories use: =COUNTIFS(Bankroll!F15:F1185,C3,Bankroll!Q15:Q1185,1)
To get rid of blank category change the source of the pivot table to: Bankroll!$B$14:$T$1185

Thank you, Mate The balance total Bankroll: in Bankroll column F c9 to reflect as either winning or loosing.
and the players balance so I can see progress in pivot table the running balance for player to have idea when his playing good or not

Speed racer, #wins its showing 1 win for all catagorys.
I would like for individual. when searching Speed Racer he has 1
" "Tournament either none or whichever he has same for hyper and turbos, and when searching for
All to reflect all catagorys. I opologize if I didn't explain myself right.

Player Running balance example. I manualy input that for BaNkRoLISuX

Formula for cell G3: =IF(D3="All",COUNTIFS(Bankroll!F15:F1185,C3,Bankroll!Q15:Q1185,1),COUNTIFS(Bankroll!F15:F1185,C3,Bankroll!T15:T1185,D3,Bankroll!Q15:Q1185,1))
Still not understanding about the balance.
I feel that there is something different between the spreadsheet used to produce the screenshot and the one in post #204. Please attach a file that manually shows how you want BaNkRoLISuX's balance displayed.

Player Running balance example. I manualy input that for BaNkRoLISuX

1111.png

closer picture to see numbers better

222.png

Mate, Would it be an easier way to identified the duplicates in sheet1, instead of looking for waldo. maybe highlight or anything else so i can quickly revised the bankroll sheet. 202263 its not on the list and 202268 shows to times I alredy check for spaces.

333.png

Is it possible to add this to allResults sheet in column AA both sheets of this spreadsheet in allResults

Not sure what the random-names file has to do with this thread.
I am going to continue with the Staking - Copy file. I feel that we are having to repeat previously solved issues (i.e. number of wins) because the file keeps changing.
To get a Total add a column (T) to the bankroll sheet: =SUMIFS(S$15:S15,F$15:F15,F15)
To get the bankroll total add a calculated field to the pivot table: =Total +1000
Note that in the pivot table both columns are conditionally formatted to hide values when the corresponding cell in column C is blank.
Player 202263 is listed in cell F282 on the bankroll sheet.
Player 202268 only appears once in the player slicer (approximately cell H6).

thank you Mate, the random-names I would like to put it in the sheet so here and there I can do a random pick it get tough sometimes to pick players and other win maybe i can pick and do 2 in random pick. Thats fine mate ill keep making the changes no worrys.
as per column F282 I am seeing 202268 and in post 208 I marked where 202268 is showing on the 4th column on top and on the 3rd column he is way in the bottom. let me see the changes.


i see in your sheet it shows player 202263 in column F282 but not on mine i delete him from bankrollsheet but still apears in slicer.
i am not to sure how that Bankroll Total is working. many blanks with no total down the column between alot of players like this one
FiSH STAKING he has no Total for Bankroll. Also where would I input the amount i started with maybe thats easier i will total my deposits,
and that would be my starting bankroll. which should end up negative for now. This is my Total deposits $1,373.06 where can I input,
if you go to Transactions in columns AF AG AH in bankroll sheet I make a deposit and it will reflect in column F9 thats how it should pretty much work.fishg.png

i see in your sheet it shows player 202263 in column F282 but not on mine...

That is my point. In order to make avoid having to go back over the same issues we need to keep working from the same workbook and you will need to attach the updated workbook to your posts when you have made changes.
I changed 202263 to 202268 in cell F282 and then refreshed the pivot table. 202263 still shows as the next to the last selection but is grayed out. Not really sure why.
The Bankroll Total now shows for Fish Staking.
Formatting for the Bankroll Total column is Number with two decimal places. Conditional formatting as stated in post #209.
As to adding deposits:
1. Added another column (U) to Bankroll sheet: =SUM(T15,SUMIFS(AK$14:AK$1185,AI$14:AI$1185,"deposit"))
Note that deposit total is 1270
2. Removed Bankroll Total calculated field from pivot table and replaced with the Bankroll Total field.
I will be away from my computer for the next few days. Hope that you have a blessed weekend.

Mate, I simplify the Bankroll columns. Showing the running balances. I have all the deposits here too.
is it possible to write a formula where it sorts every tournament as per is catagory, to give the totals on its Totals section?
The reason this change is because I find myself inputing the information all day. Now it would only be to input buying and prize for all.
But its on the same column. let me know what you think, here the workbook.

I notice that in the file attached to post #213 the playersHistory sheet is blank. I feel that is because the formulas that were added to the Bankroll sheet (T:W of file attached to post #211) were removed.
So, using the file attached to post #211 a Total Balance column is added: =SUM(SUMIFS(AC$14:AC$1185,AA$14:AA$1185,"deposit"),-SUM(H15,J15,L15),SUM(I15,K15,M15))
The filter button on cell V14 can be used to to filter the categories.

Hi, Mate yes the file in post#213 is the one I would like modifications on. I ask if there is a formula to index or sort the games to its catagory. I would like to have just one column for all buyins and for results not have 3 buyins, and 3 results where I have to input the results. In post #213 I modify
and make some changes to the layout. can we convert to the new layout.

Mate in #213 I mean if name of tournament in All Games can reflect amount in Totals sections by catagory. example
I enter any Speed Racer Bounty don't matter which amount, when I input in all games column to reflect profit or lost, number of games etc.
in Speed Racer columns G,H,and I
and for all catagorys the same. anything with turbo/hyper to sort to that catagory in O column cells 3 to 8
same for tournaments could be anything to reflect without speed racer or hyper turbos in the name of game.

This thread has become a moving target, as in each time that some progress is made, there is a major change made to the request.
To get the category, the following formula is used in column Q: =IF(ISNUMBER(SEARCH("Speed Racer Bounty",F14)),"Speed Racer",IF(OR(ISNUMBER(SEARCH("Hyper",F14)),ISNUMBER(SEARCH("Turbo",F14))),"Hyper Turbos","Tournament"))

Mate, How do I input the chinese Zodiac catagory?
lets say I want to add this tournament.
Allinwin7 Zodiac Tiger King Bounty ¥108 $5.77 $19.94
Mate the profit and Total Balance won't update automatic I have to hit F9 how come.
After testing when inputing tournament game, it also inputs in Turbo Hypers. should only be tournaments
same for hypers when inputing Turbo Hyper it also reflects in tournament Catagory
not sure its working either for speed racer it calculates amount in tournament section

Hi, Mate need your help get the workbook running the formulas not quiet calculating where the values suppose to go.
the whole Inchilada mate, here look

111.png

2222.png

mate this is the last thing i need help me how do I have this on the workbook to label players see picture
444.png

5555.png

Please upload a file and not a picture.
Tell us which cell(s) are not calculating correctly, and what the correct value(s) should be and unless it is blatantly obvious, explain how the calculation would be done manually.
I only have a limited amount time to work on this so I cannot look at "the whole Inchilada".

I will upload mate, ty your the best. yes please let me upload

I would like, each tournament, I input in All games to input in its catagory if is " Zodiac, or Omaholic", in the name its a chinese Zodiac or omaholic tournament. Speed Racer is catagory, speed racer. Anything with turbo or hyper goes in that catagory. Satellites will have in the name SAT or Sat which will be identified to be in Satellite catagory.
also in the player list i would like to have that button working to go to the bottom to input a new player would save ton of time. Not sure why when I sort out things get a bit strange in all the workbook

You have not made this easy. I had to hunt to find the category column (A) hidden behind the button.
I changed the formula in column A to read:

Formula:

Please Login or Register  to view this content.

I put the following into cell H3: =COUNTIFS(A14:A3059,"chinese zodiac")
I continued across until cell Y3: =COUNTIFS(A14:A3059,"satellite") however this appears to produce an erroneous count because cells containing the word Saturday are included.
I suggest that instead of just putting SAT or Sat in the All games cells that if you are not going to spell out satellite, at least put Sate or SATE.
As to the button that would require VBA of which I know too little to help, although I did move it so that it doesn't block the column headers in row 13.
I suggest that the names of the players and their winnings be moved outside of the range of records in columns A:Q.

As to post #222, I have asked before that you wait until I answer one question to ask another.
I'll look into the request in #222 when I get a chance and would really need to see what you have applied to the file attached to post #223.

Oh ok mate, I will upload. I will add the Rank columns I will keep trying to fixed any issues that I can figure out myself.

Mate, I only added column L for the Rank, and remove player list out of A:Q
Also after testing the catagorys, I notice "catagory Tournaments" is decreasing when entering a, chinese, speed racer, tubo/hyper tournament.
not sure its the right amount for tournaments played for that catagory. example: all tournament games for tournament Catagory. would be
any games that don't have" Zodiac, Omaholic, Speed Racer, Turbo/hyper or Satellites.
these tournament would be under tournaments:
Bounty Hunters Mini Big Game $2.16
GGMasters Bounty Warm-Up $25, $50K
GGMasters Classic $25, $30K
GGMasters Asia $25, $20K
Bounty Hunters Big Game $21.60
APT Online: Bounty Head Hunter $15
and many more on the all games list, longest they don't have speed racer, turbo/hyper or zodiac omaholic, satellite. would fall down in Tournaments catagory.
Can we add Sit & Go and Spin & Go to the catagorys. to do the same.

There do not appear to be any examples of Sit & Go or Spin & Go in the All Games column of the sample file.
Nevertheless I amended the formula in column D to read:

Formula:

Please Login or Register  to view this content.

I added formulas in W3 and AA3 like the one in F3.
I suggest converting the range A12:P1581 into an Excel table so that the formulas in F3, I3, N3 etc. can be modified to use structured references so that they will not have to be changed if the data gets large enough to fill down past row 3057.
In the file I added a Speed Racer Bounty in row 1582. Before and after adding the count of Tournament was 434.
Also that there are 1571 entries in the "all games" column and the sum of the categories played (F3, I3, N3 etc.) is 1571.
Let us know if you have any questions.

Thank you mate, I will see changes? How do i convert the range into that range in a table, I don't know how to do that?
also question is the players notes section? something that ca be done? into inputing a player and tendencies of play? to be label accordingly.
When you get a chance would like totals to calculate, accordingly, to its catagory along with all other secctions from deposits to profit, total balance and current month profit.

Yes, please upload the updated workbook.

Okay mate cheers
I made them changes. not sure if Notes: for players is possible, but is one inportant, must have in order to keep record of players tendencys of play.
Instead I put the Cash section. Its looking nice thanks to you mate

The Totals: for each catagory or the same, would like them to calculate accordingly by each game to reflect in the Total revenue, cost, profit and ITM% and ROI%

mate how can i fixed this is under share%
percentage.png

I have changed the range A12:P1584 into tbl_TournamentTotals.
To increase the size of the table go to cell P1584 and press the Tab key (formulas will automatically adjust).
In the Chinese Zodiac area:
The formula for played is: =COUNTIFS(tbl_TournamentTotals[Category],"chinese zodiac")
The formula for revenue is: =SUMIFS(tbl_TournamentTotals[Prize],tbl_TournamentTotals[Category],"chinese zodiac")
The formula for cost is: =-SUMIFS(tbl_TournamentTotals[Buy-in],tbl_TournamentTotals[Category],"chinese zodiac")
The formula for ITM% is: =COUNTIFS(tbl_TournamentTotals[Category],"chinese zodiac",tbl_TournamentTotals[Prize],">0")/Bankroll!F3
Profit and ROI% are the same as in the file attached to post #231.
To change the formulas for the other categories just change "chinese zodiac" to that category. (i.e. "tournament")
Let us know if you have any questions.

Please upload the file with the changes made as per post #235.
As to adding 100 games, if you are pasting them into the table then select cell A1585 and paste. The table should update automatically. If it doesn't then select the table tools tab > resize table > change A11:P1584 to A11:P1684 (assuming that row 1684 is the last row with data).
As to profit/total balance, modify the formula in cell D8 to read: =-(SUMIF(AC12:AC3057,"Deposit",AE12:AE3057)+(SUMIF(AC12:AC3057,"Withdrawal",AE12:AE3057)))
I don't know how the value in cell C9, -$1,799.23, was calculated, so I can't help there.
Let us know if you have any questions.

Happy morning mate, oops I though I did mate it was late must forgot to attached will now.

I will do the change now. Mate
my Starting Roll was 8.06 then it only reflect on D9 total deposits is 1720 + -71.17 =1791.17 + 8.06 = $1799.23

The Balance in P12 and down is where it need to be correct, starting with my 8.06 then making all the deposits after to calculate the right numbers in P column and down.

Satellite inputing "tournament games" in satellite catagory, because of Saturday word.?

sat.png

Mate need your advice, have question. Since I have to input lots of data entry. I was looking at some videos, last night as well as this morning. about power query, to download to excel the information from the staking website into excel. but I don't get the information. is it because is a loggin website password require? not sure how that power query really works but it would same my life when it comes to do the entries since is going to be about 100 entries per day. would like to hear your opinion

This formula in cell D12 and then copied down should correct the Satellite issue:

Formula:

Please Login or Register  to view this content.

As for the values in column P.
The easiest way to add in the deposits would be to insert a new column in the tbl_TournamentTotals that puts deposit records in a row on their correct date.
If the name of the new column is Deposit, then the formula for column P could then be: =SUM([@Prize],[@[Buy-in]],[@[Deposit]])
Let us know if you have any questions.

Mate, Having trouble with Balance, and deposit. why can it be from the transaction column, from here.

transaction.png

I try adding the column, and paste the formula into p, not sure its working as it should. Things not adding up right. would like to do all the transactions from the, transaction secction. Profit, Balance, Deposit not calculating correct. I will upload

Can't figure out the totals for profit, balance desposit

I made the following changes:
1. Formula for column P: =SUM([@Prize],[@[Buy-in]],[@Deposit],P11)
2. Formula for column D:

Formula:

Please Login or Register  to view this content.

3. Resized tbl_TournamentTotals so that the last row is 1581, which is the last row of data.
Let us know if you have any questions.

Mate, I confused now how this is suppose to work. with the balances and deposits.
can we do everything from the transactions section? do I need to input all my deposit in column Q? from column AF ?
in column AF is from start to now all deposits. Starting Roll was 8.06, can I ask for the reason of having the Deposit on column Q ?
I just paste all my deposit on column Q and i get all this strange amounts, and nothing calculating in column D3:D9 so confusing. all morning trying to figure it out going on a few days trying to make that run smooth

ddd.png

The deposits need to be put in the rows with the corresponding dates. For example 8.06 in the row for 1/1/2023, 100 in the row for 1/7/2023 and another 100 in one of the rows for 1/10/2023 etc. (see attached file).
While it isn't completely necessary to fill every row of a table it probably speeds up calculations, so that resources are not being wasted on empty rows, especially in a large table, which I feel tbl_TournamentTotals may become.

I would of never thought of that Mate need way easier tasks. Can a formula do it from when I deposit in the Transaction section.
let say I run out of money, make a deposit in the transaction section and it will input in the Q column.
okay I will always keep it fill unless I need to input information. Its going to become very large huge data. up download.

In column P12 under balance. why is it adding deposit is 8.06 balance is 9.19 in profit -1.13 ?

Done inputing the deposits. I still don't understand the balance on P not accurate, I think

The formula is adding prize, buy-in, deposit and the previous balance.
Prize and buy-in are shown as being added together in the file attached to your post #237, so I assume that is what you want.
If not, then what should the value in cell P12 be and why?

oh ok its a bit complicated to explain is here in this workbook that we started working on. in the Month of July starts it shows
the Sesion amount, evolution Balance, Evolution Profit, and Balance in pink letters

Balance in P12 i would think it would be 8.06 - 1.13 = 6.93 on Balance

here is an Example:

thats why I don't understand the deposit column for I been with this for a few days.

333.png

not sure if the pictures is clear enough for you to see.
but thats how.
I start with $8.06
i stake
-1.13 balace 6.93
-3.11 bal. 3.82
-2.25 bal. 1.57
-1.57 bal. 0 zero in column P and on column D9 0 too
I go to the transaction section make a deposit of 100 it reloads balance on column P and on column D9

I don't understand the connection between the workbook attached to post #248 and the Staking - Copy 2-27-23 1st.(west123).xlsb workbook.
The formula that corresponds to the description in post #248 is: =SUM([@Profit],[@Deposit])
However, this results in cell P13 displaying -3.11 which I doubt is correct.
In order to help I would need to know how balance is calculated using the data in the Staking - Copy 2-27-23 1st.(west123).xlsb workbook.

Mate, the amount 1.57 is not in the workbook, i use for example of going zero. oh and lets say I made a deposit but not input it in the
transaction section and I was staking total bankroll on column D9 it would turned into - negative just the way it is now.
1720 its the total deposit. plus the negative 71.17 =1791.17 + the 8.06 total tournament profit its (1799.23) on column D5
the 8.06 is the Starting Roll as you see in the deposit section
then the deposits come after the 8.06 was wipeout

The following formula, placed in cell P12 and copied down, yields the values given in post #248: =SUM([@Profit],[@Deposit],P11)
Let us know if you have any questions.

Mate, Do we still need the Q column for deposits, or can we use the deposits from the transactions secction?
please make it work from the transaction secction so we can delete column Q
also this message keeps poping up.

Attachment 819621

reference issue is fixed, but the formula stops working on row 187, will upload
disregard, references where a formula refers to its own. still poping up. Not fixed.

The reason that it quits working at row 189 is because from Q189 and down the cells aren't blank, they contain a formula.
Erase the formula from the cells in column Q leaving only the deposit values.
I removed the formula from cells Q189:Q221 so that you could see that this will work.
If we attempt to use the deposit values in the transaction section, then Excel will add a $100 deposit for each line that has the date 1/10/2023 in column A (43 of them).
I feel that we may be able to go the other way around as in once the deposits are placed in column Q and the formulas are erased, then we should be able to write formulas to fill columns AC:AF.
Let us know if you have any questions.

Thank you, Mate ok i will download. as for deposits if we can do the change to go around it, would be great idea. yes do the change please. let me download an see. The circular refrences pop up show right when opening the workbook. not sure if it happens to you.
I see the formulas that stop working from row 223 it shows amt. 113.86 and down do i delete everything from there.

I delete everything from row223 on P column and down. then i pull fill handle down to the last row on the table. and not seem to work it repeats the number from where i start

Did you remove the formulas?

I highlight cells hit Delete would that not do it?33.png
then i pull the fill but it repeats the number above555.png

I try cutting and paste from a blank part in the workbook and pasting on column P from the cells not working but no luck

You need to delete the formulas in the Deposit column cells, leaving only the deposit values.

Cool, Mate its working,. will upload
ready for the formula,. mate I also notice that column Q for deposits would not show in Pivot table.

Columns AC, AE and AF are populated using formulas similar to:

Formula:

Please Login or Register  to view this content.

Column AD is populated using: =IF(AC13="","","Deposit")
Not sure to which pivot table you want to add deposit so put it on the one on the allResults sheet.
Let us know if you have any questions.

thank you, mate Yes pivot table in allresults would be. let me look at the changes. Also mate can we get the Stake results started in
Profit by Stake Amount. Micro, low, Medium, and High Roller

So give me a run down of how the deposit would work now. also to add more rows would be the same way pull the fill handle down?
when I add rows the formatting don't seem to continued going down

To add rows go to the cell in column Q in the last row of data, cell Q1582, and press the Tab key.
Deposit works by putting the amount of the deposit in column Q in a row that corresponds to the correct date. The formulas in columns AC:AF will then record the deposit date, transaction, site and amount. I have filled the formulas down to row 200. If you need to add rows in that section then select AC200:AF200 and pull the fill handle down.
You'll need to define the terms Micro, low, Medium, and High Roller before I can help.
Let us know if you have any questions.

would tab key. only do one. I would like to do many at the time.
the deposit, what you did, when you mention going the other way around is what you did?
when having the formulas in AC:AF disables my button for transaction when clicking it takes me to roww 200.
Micro would be tournaments starting from amount. 1.08 to 4.40 dollars
Low would be tournaments Starting from amount. 5 to 15 dollars
Medium " " 20 to 88 dollars
High " " 100 to 26500k
I did a break down for section

like thats it would give me more detail of where I stake and gain more profit

As to the stake amount levels there is no mention of amounts between 4.40 and 5.00; 15.00 and 20.00; 88.00 and 100.00.
I assume that any amounts less than 1.08, including negative amounts, should produce blanks.
The formula, as modeled in column R, is: =IF([@Profit]<1.08,"",IF([@Profit]<5,"Mirco",IF([@Profit]<20,"Low",IF([@Profit]<100,"Medium","High Roller"))))
Let us know if you have any questions.

Mate, maybe I didn't explain well. the tournaments in *All Games* have the amount lets say
micro all tournaments buying range from 1.08 to 4.40
low would be anything from 5 to 15 is the amount of the actual buy-in to enter the turnament. I only buy a share of action
but would like to know in which of the 4 Stake catagories I make the most
Micro
low
medium
or high

in this section mate

ddd.png

colums AH:AS

For Profit: =SUMIF(tbl_TournamentTotals[Buy-in],AH13,tbl_TournamentTotals[Profit])
For # Stake: =COUNTIFS(tbl_TournamentTotals[Buy-in],AH13)
Let us know if you have any questions.

Thank you Mate, will download
Mate, not quiet what i want,
You see column row 15 BaNkRoLISuX He play the Bounty Hunters Sunday Special $54 Profit was 176.96
I would want all the Games of $54 dollars to reflect the profit. on column AO cell 20
only for the buying of $54 in the All Games that thave that amount.
same for all other buyins,
and the Number of Stakes for each amount in the stake amount column

Mate, I have a question. I Stop and think for a minute, wanted to see the Big Picture, of how everything
would work. I though Okay, its going to be about 10 sites in total. Tournament names change a bit, but the
big issue, I see is. How is it going to calculate or give me the breakdown of each site. Would I need to have
10 Different workbooks? to know how much revenue, cost or profit for each site.? I wounld want to have the Totals
mixed up with all the other sites. I would like each site separate to have its breakdown for each catagory totals.
What would be the best thing to do, I wouldn't want have 10 workbooks to have to input data.
What do you recommend?
Mate, I though maybe we can have a dropdown for all sites in the totals where we can pick which site to see totals from
would that work?

Mate, I made some updates. will upload workbook

for Daily turbo hyper the word key would be Daily, since both have "Daily Turbo or Daily Hyper"
for bounty hunter just like that.
Daily Big or Deep would be Daily Big or Daily Deep Stack

Mate I adjusted the colums E,F to get a bit more of space to try to fit as much cholser together.
but I don't know how to combine or merge, the column Column E and F in row 11 to merge All Games with the new Column6 on F11445.png

I notice that there are circular references in the Balance column.
Those issues had previously resolved, but now it appears that they need to be resolved it again.
What is the purpose of Column 6?
The problem with trying to get the stake amounts from the All Games column is that they are inconsistent. Some are at the end of the text (i.e. Bounty Hunters Mini Encore $5.40 in cell E12), others are in the text (i.e. WSOPC $25 Sunday Mini Cooler Bounty Turbo in cell E25) and some appear to have two amounts (i.e. GGMasters Classic $25, $40K in cell E108).

Hi, mate, Column 6 the All Games? thats the games I am staking.
I can arrange the amount where you want it to be for when, I do the Input. I can also remove 1 mount
on the GGmaster I can only make it what the buy-in is $25 and get the $40k out

Do you want me to arrange all the tournaments to have the amount at the End, and only have one. I can start working on it.
Im going to arrange it

Would it make a diferrence if is on the front or end? can you work with either or?

almost done mate will upload. I may missed a few. I left amount either front or back
Need to redo it. not sure what happend

Mate do I remove the 7-max, 6-max ? would that affect

Mate do I remove the 7-max, 6-max ? would that affect

I think that as long as the dollar amounts are preceded by a $ there is probably a way to parse them out of the text string.
It would be nice if the dollar amounts were in the form of $54.00 and not just $54, if not however, it I believe it could still be done.

I thought about the Dollar $ it matters if is in front or anywhere the amount?
Okay let me make them $54.00

Make a new post when you upload the new file as I don't get notified when a post is edited.

Okay, question would the $30K, 25K, 500K be a problem leaving it.

Ready, would like all games and column F to be fixed mate,. it says column6

We can try to work with $30K, however it would be better if it was $30,000.00

In the last file you sent cell E1581 displays: GGMasters Asia $25, $20K
In the All Stakes area, should that counted as $25.00 or $20,000?
If the former then I think we can attempt to work with what is already there.

Yes, make a new post once you upload so that I will get a notification.

you mean a whole new post? done,
where you able to figure out the All stakes profit?

I mean add a new post, probably #287, to this thread.
I have been waiting for the upload that you mentioned back in post #274 before working on the All stakes profit.

Populate the Stake Amt. using:

Formula:

Please Login or Register  to view this content.

The above works for all but six entries which the attached file has been filtered to show.
When the filter in cell S11 is cleared then you can see that the All Stakes area is populated as follows:
Profit: =SUMIF(tbl_TournamentTotals[Stake Amt.],AJ13,tbl_TournamentTotals[Profit])
# Stake: =COUNTIFS(tbl_TournamentTotals[Stake Amt.],AJ13)
Let us know if you have any questions.

Thank you mate, will take a look. how about the totals did you get a chance to see why is not giving the correct calculations
what do i need to do to correct them 6 entries to work? or why they are not working?
I correct the 5 of them the other one its a Chinese Zodiac and since their tournaments are in Yuan money I would have to manually do it.

I don't quiet understand the amts. in column "S" is the All Stake amounts accurate?

Mate, Can we finished the other catagorys, I highlight with Red on top of header that ones that need to be added.
Bounty Hunters
Daily Big, Deep
Flip & Go
Satellites:
would be anything with Sat. Mega, Step or Seats in the names
I also added Column K for Duration of the game I put few example of the time format I will be using start time Jan 01, 12:40 and end time would be just the finished time. 20:38. Can the date and time have like a shortcut key to input time and hour.
Mate also would like to know how I add up rows with out the gray lines that come out when I pull the fill Handle.

fil.png

I have to input all the games tomorrow again. when trying to saved workbook would not let me, and i lost all the information. and its late ohh no message is back!!!

I upload this file for you to see where are the new changes to add. Not sure why it won't let me saved the other file. these one just to know where changes need to be made.

As to post #291:
1. The issue with the zodiac amount is not the Yuan symbol, it is the 1M, so yes you will need to correct that manually to either 1000000 or 1000000.00 assuming you want zodiac stakes included in the all stakes area.
2. I believe that amounts in column S are correct, but if you find some that aren't let me know which ones and I'll see if the formula can be adjusted.
As to post #292: I have filtered tbl_TournamentTotals to show those records corresponding to a stake of 108. The total of the profits is -198/14. Please tell us how you came up with -223.7
As to post #293: I don't understand why you are asking how to enter the all games, I would assume that you would enter them the same as those in the attached file were entered.
As to post #294:
1. The file attached to post #290 could be a back up file which is up to date until the games that are listed in post #293.
2. The situation of having a filter button in cell F11 came about because the player column was moved. Each column in an Excel table must have a header. I hid the name Column 6 by changing the font to black but as far as I know the filter button can't be hidden. You could put the the columns back into the order that they were prior to moving the player column.
Will look at the rest later, however I may not be able to answer questions that go beyond formulas, so you may have to reach out to other contributors for formatting questions like the "gray lines".

Hi, mate happy morning.
Yes I can delete the 1m, I did all the 6 corrections but after making changes, I can't no longer saved the file. Yes I would like the Zodiac as well, but it will need to be in a separate section only zodiac. with the yuan currency
or converted to dollars.
I came up with -223.7 when I do a search under games with the amount, of 108 it list all the games and the profit would be -223.7
I am asking if they need to be enter $54.00, 5.00, 15.00 in that format if it is that I have to do it that way I need to find a way because it would take me lots of time to go one by one to change the amounts. okay mate
will download now. thank you

mate not sure why I got this pop up message in th workbook.

err.png

I was able to do a repair not sure it things chage.

Mate, why can I saved the workbook I get this error

bbb.png

I also get this msg. Mate help me with this why is it doing this.

ddd.png

The formula for Category is:

Formula:

Please Login or Register  to view this content.

The formula for Duration is: =IF(B12="","",B12-MOD(RIGHT(A12,5),1))
The formula for Chinese Zodiac Profit is: =SUMIF(tbl_TournamentTotals[¥ Stake Amt.],AV13,tbl_TournamentTotals[Profit])
The formula for Chinese Zodiac Stake is: =COUNTIFS(tbl_TournamentTotals[¥ Stake Amt.],AV13)
Let us know if you have any questions.

As to post #300, expand columns S and T so that you can see what the formulas are displaying for $ stake amount and ¥ stake amount. You would only need to make a change if the formula in one of those columns is showing to wrong value or an #VALUE error.
As to post #301, the formulas in all the categories seem correct to me. Which categories are reporting incorrectly?
As to post #302, as stated in cell AV6 we would need to know the exchange rate between yaun and dollars.
Let us know if you have any questions.

Hi, Mate, Happy morning.
Oh ok, But is not in USD currency converted the yuan. 1 Yuan its 0.14
I wanted the Satellite. To input anything with the words. Sat. Mega, Step, or Seats. their 4 tournaments but they only have either one of the words, but they are Satellites.

yuan.png

Mate, can you adjust Bounty Hunters columns O:Q. to only input "Bounty Hunters" just the two words
all the other Bounty Hunters are tournaments.
unless they have hyper or turbo they go in turbo or hyper.
After checking Dialy turbo hyper, notice when I do a search for daily games I have 34 in All games when i filter it. but only shows 18 in played

cou.png

Changed formula in cells Category column to read:

Formula:

Please Login or Register  to view this content.

Changed formula in Chinese Zodiac Profit column to read: =SUMIF(tbl_TournamentTotals[¥ Stake Amt.],AV13,tbl_TournamentTotals[Profit])*0.14
Note it would probably be better to put the exchange rate in a cell and then reference that cell in the formula so that if/when the exchange rate changes, the formula doesn't have to be changed, just the value in the cell.
Let us know if you have any questions.

As to the edit that was made to post #304 at 10:23 AM. Please upload the file from which the screen shot is taken. Be sure that the file is filtered as shown in the screen shot.

As to post #306, pick any cell ,i.e. cell AW5, and put the current exchange rate, 0.14, into that cell.
Change the formula in cell AW13 to read: =SUMIF(tbl_TournamentTotals[¥ Stake Amt.],AV13,tbl_TournamentTotals[Profit])*AW$5
Drag the fill handle down to cell AW32.

Mate, Can Satellites. Input anything with the words. Sat. Mega, Step, or Seats. their 4 tournaments but they only have either one of the 4 words , but they are Satellites.
Same for Daily Big, is 2 tournaments. one is Daily Big and the other is Daily Big stack.

k.png

here is the list of keywords for all Satellites that can fall under that catagory. I didn't use Global in some i used [day1] or [Stage 1] since not sure if tournament name may change.

keyword.png

Mate After checking Flip and Go not sure formula is the correct for that catagory. column AF:AH

Here is the file with the formula for Category changed to include all keywords for Daily Turbo Hyper.
Once you have confirmed that the formula giving the correct result for Daily Turbo Hyper then upload the file filtered to show Satellite All Games that are not being identified correctly in the Category column.
We'll work this one category at a time so as not to have to keep reapplying previous changes as in the file attached to post #309 doesn't include the change to the Chinese Zodiac as I assume the reply in post #310 implies.

Here is the file with the formula for Category changed to include all keywords for Satellite.

Mate here is the Bounty Hunters Filtered.
Can it only Recognize the 2 words "Bounty, Hunters"
All other Bounty hunters are either tournament, or turbo/hyperhunter.png

Here is the file with the formula for Category changed to meet the criteria for Bounty Hunters.

Thank you Mate, will download
Mate, how come everytime I have to Repair the workbook. because it won't let me saved.