LinkBack URL
About LinkBacks
I would like help, for worksheet to calculate all months into summary, If you can make any other adjustment to improve it, would be greatly appreciated.
if you have any questions, please feel free to ask.
I would like help, for worksheet to calculate all months into summary, If you can make any other adjustment to improve it, would be greatly appreciated.
if you have any questions, please feel free to ask.
Last edited by west123; 12-17-2022 at 05:17 PM.
Re: Poker Worksheet Calculate summary data for all Months
no help!!!
I am not sure what you want, however if it is to populate the Summary sheet with one formula try pasting the following into cell B5 and then drag the fill handle down and across:Formula:
Please Login or Register to view this content.
As stated in your previous thread on this topic it would help if you could tell, or show, us what cells need automation and what the expected values are for those cells based on the data in the monthly sheets.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
JeteMc
Thank you very much, for the reply and help highly appreciated.
I would upload a copy of only Tournament worksheet, sample of how, I would want mine to work.
I want both Tournament & cash combine on worksheet. To calculate all in summary which is not doing.
columns I added is from H to M, I will upload spreadsheet
and do what you told me to do.
Also how can I add that same graph to mines?
Last edited by west123; 12-18-2022 at 03:21 PM.
On mine cell N, O, P not calculating the results correct for my Tourney buying & CashOriginally Posted by west123
worksheet or tab name : Resumen
Cell B5 formula , Drag down and across
Formula:Please Login or Register to view this content.
There is a formula in worksheet name Julio cell I5, which can be copied to the same position of I5 in the worksheet of each month
Formula:Please Login or Register to view this content.
Last edited by wk9128; 12-18-2022 at 06:22 PM.
Mate, this is how I would want it with all cells working correctly to calculate in the summary.
here is a copy
Last edited by west123; 12-18-2022 at 07:06 PM.
Wait is the incorrect one will re upload
Last edited by west123; 12-18-2022 at 07:03 PM.
It is recommended that the 3:3 and 2:2 titles of each worksheet should be consistent, otherwise it will not be found
worksheet or tab name : Summary
Cell B5 formula , Drag down and across
Formula:Please Login or Register to view this content.
curious ask a question
The provided data is from Spain, why is your geographic location in the United States
Last edited by wk9128; 12-18-2022 at 07:51 PM.
Explain about the 3:3 and 2:2 Don't understand what you mean by that, and how do I fixed that tell me what I need to do or change there?
My location is United States, Los Angeles California
I will go head and paste the formula ill be posted for anything else
It means 2:2 AND 3:3, the title of worksheet Summary B3:O3 should be consistent with the title of other worksheets A2:U2
Example like this worksheet Summary Cell I2 Cash Buy Ins , not only Buy Ins
Last edited by wk9128; 12-18-2022 at 08:06 PM.
I'm sorry that's Expert excel talk, not quiet understand what all that means. Tell me how do I fixed it what to do or what changes to make, ill do the correction it
You try to use the POST#9 formula to see if it can solve the current problem
Yes I did, But I think where the issues are is the Months columns and cells, are incorrect or missing for each month
I will enter data to January & February take a look at the worksheet, I will upload.
Last edited by west123; 12-18-2022 at 08:30 PM.
worksheet or tab name : Summary
Cell B5 formula , Drag down and across
Formula:Please Login or Register to view this content.
oh okay
can you take quick look at January month, from cells Q, R, S, T, U, AND V don't think they are working correct
I think they are not working for all months.
this came out when I paste the Formula
screenshot.jpg
Last edited by west123; 12-18-2022 at 08:47 PM.
worksheet or Tab name : January
Cell U4 formula , Then copy to next month February cell U4 , March cell U4 , and so on
Formula:Please Login or Register to view this content.
Oh okay, done
what do I do after that.
Once paste don't do anything else drag down or any of that?
if you want to drag down , try this formula , then Copy this ranges (P3:U50) to next month Cell P3 and so on
Formula:Please Login or Register to view this content.
Last edited by wk9128; 12-18-2022 at 09:44 PM.
for each month paste and drag down?
done copy and paste for U4 and drag down for each month
but why my other cells don't work profit, length $/HR and Sesion, Evolucion Balance won't calculateworksheet.jpg
Last edited by west123; 12-18-2022 at 09:52 PM.
Cash Section not calculating in summary, for all months see picture for detail.
also I don't know the correct format for the time to calculate my Length and $/hr
For my BB/h I found this formula not sure if it can be used. see picture for detailAttachment 810014Attachment 810016
The sample worksheet its how I would much like mines to be see worksheet.
Last edited by west123; 12-19-2022 at 08:56 PM.
If I understand correctly...
On the monthly sheets:
1. Change the name of the sheet tabs to match the names given in column A on the Resumen sheet (i.e., Dec 22 and Oct 22)
2. Paste the following into cell R4 and copy down: =IF(N4="","",N4+(N4<M4)-M4)
3. Format cells in column R: [h]:mm;@
4. Paste the following into cell S3 and copy down: =IF(R3="","",Q3/(R3*24))
On the Resumen sheet:
1. Paste the following into cell N5 and copy down and over to cell O16: =INDIRECT("'"&$A5&"'!"&ADDRESS(3,COLUMN()+4))
2. Paste the following into cell B5 and copy down and over to cell G16: =INDIRECT("'"&$A5&"'!"&ADDRESS(3,COLUMN()))
Let us know if you have any questions.
okay let me do everything in your list, let you know once I'm done.
thank you very much. brb
Oh ok done. Now do I repeat the same for every Month ?
Do I do the same for every other month?
Mate, nothing is calculating in the Resume sheet, cash side which is the right side.
I think instead we put the formulas on Tournament side which is the left side, That side was working fine for my tournaments. Cash side not calculating the cash side on the right side of my resumen. Everything about the time and Length is working fine. see pictures.33.jpgeee.jpg
Last edited by west123; 12-19-2022 at 11:44 PM.
On the Resume sheet:
1. For J5 and down: =INDIRECT("'"&$A5&"'!L3")
2. For K5 down and over: =INDIRECT("'"&$A5&"'!"&ADDRESS(3,COLUMN()+4))
If this doesn't help, then please upload the file from which the screenshots in post #26 are taken.
Also please manually fill in a few of the values on the Resume sheet, cash side so that we will know when our formulas are correct.
Let us know if you have any questions.
thank you, let me work on it
oh okay, good big progress now
the only tabs not calculating in resumen, is all month Lenght Hrs total in resume and $/hr
Total hrs in Length Cell R3 not calculating in resume for the Total hours in the month played. either the $/Hr calculating in resume
see both picturesAttachment 810199hrs.jpg
Also my Month of January, looks like this. picture 1 seems to calculate cell R to 31 but not the total hrs played in resume. or $/HR
but picture 2 shows this for all other months.
1.png2.jpg
Last edited by west123; 12-21-2022 at 01:14 AM.
Selecting attachment 810199 results in: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
Please upload the file from which the pictures were taken.
here is the worksheet for pictures above.
here is the worksheet for pictures above.
See January Tab. for detail on cash. All other months show #div/0! on $/HR
Last edited by west123; 12-21-2022 at 10:45 PM.
any resolution
I had just gotten home and taken a look at the file when you bumped the thread a little less than 3 1/2 hours after your previous post.
I feel that the following does what you want:
1. As stated in post #22 "On the monthly sheets:... 3. Format cells in column R: [h]:mm;@"
2. Modify the formula for cells O5:O16 on the Resumen sheet to read: =IFERROR(INDIRECT("'"&$A5&"'!"&ADDRESS(3,COLUMN()+4)),"")
It helps move things along if you tell us what values a cell should show instead of just saying that the value displayed is not calculated correctly.
Let us know if you have any questions.
1. As stated in post #22 "On the monthly sheets:... 3. Format cells in column R: [h]:mm;@"
do I do that to all the Months? starting Feb-dec on the ones showing #DIV/0!?
OH okay,
in Jan22 Length Column R4 TO R31. I Want it to calculate all my hours played for the month in cell R3, to reflect on my Resumen Sheet for the month of Jan 22 with all hours played for the Month. Also how do I fixed all other months to do the same as month Jan 22
Do I repeat this process for all other months to fix the #DIV/0! ? because only Jan 22 doesn't have that it shows like this Attachment 810307
2. Paste the following into cell R4 and copy down: =IF(N4="","",N4+(N4<M4)-M4)
3. Format cells in column R: [h]:mm;@
all other months have this1.png
Last edited by west123; 12-21-2022 at 11:23 PM.
Yes, for every month.
In the attached file I have done Feb 22.
Let us know if you have any questions.
Thank you so much, let me take a look
Thank you so much, let me take a look
do I use this =IF(R3="","",Q3/(R3*24)) for all months?
Yes, in cell S3 of each month and copied down as far as needed.
I try not working. Stays like this #DIV/0!1.png See pic
Last edited by west123; 12-21-2022 at 11:49 PM.
Try: =IF(OR(R3=0,R3=""),"",Q3/(R3*24)) or =IFERROR(Q3/(R3*24),"")
oh ok yes that works ty let me do it for all months
Why do I get this? on Length?Attachment 810312
Mate, take a look Only Jan and Feb 22 adding up the total Hrs. in cell R3
see worksheet now1.png Total Hrs. for the months not adding in resumen in cell N5 to N16
Last edited by west123; 12-22-2022 at 12:43 AM.
Because only Jan 22 and Feb 22 have the correct formatting for cell R3.
The correct formatting is [h]:mm;@ not h:mm;@
Same issue in cells N4:N16 on the Resumen sheet, the formatting should be [h]:mm;@
Let us know if you have any questions.
good morning JeteMc thank you very much I will check that out talk to you later mate.
cool, its working only cell O5 to O16 for $/HR not doing the math correct? Attachment 810374
Selecting Attachment 810374 results in the following: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
Please upload the file so that we can see what O5:O16 display.
Also please tell us what those cells should display.
EDIT: If you want column O to calculate based on columns M:N rather than to pull values from the monthly sheets, then try: =IFERROR(M4/(N4*24),"")
Last edited by JeteMc; 12-22-2022 at 02:59 PM. Reason: Added edit
I think I need to leave it like the way it is. Is it possible to make the little green error on the top left corner? or Attachment 810430why does it show like error see picture.
I think I am going to leave it the way it is. Why does it show like error in cells O5 to O16 can the green marks be remove? see pictureAttachment 810431
How can I add the graph like in this worksheet?
As to post #54: If you select O5:O16 and click on the drop down arrow in the caution sign to the left of cell O5 you can select "Ignore error" being sure to save the file after making this change.
I'll have to look into the graph in post #55 later, unless someone else has already provided a solution.
I will make the changes, now and save it. ty much.
No one has reply for post #55 I will be waiting here
Can you answer this question on a different worksheet. I just want to know where can I edit the dropdown list of players.
in the Registered tab? Column A has drop down list. Would like to know where to edit the list
As to post #55:
Attached is a file that graphs the Evolución Bank for each of the months. Using the Octubre sheet as an example:
1. Select cells I5:I16
2. Press the Alt, N and R keys
3. In the Insert Chart dialog box select the Line Chart
4. Right click inside the chart and select "Select Data"
5. Under the horizontal axis labels select "Edit"
6. In the Axis Label dialog box select the range as =Octubre!A5:A16
7. Select OK
8. [Optional] Edit series one and select cell =Octubre!$I$3 as the series name.
I don't know what values are supposed to be charted in the Resumen sheet.
Let us know if you have any questions.
Its saying Reference is not valid. reference must be to an open worksheet. the one on post #55 is the sample of how I wanted in mine. here is mine.
Looks as if the chart is set up to display values from the Evolución balance column.
The series name is: ='Oct 22'!$I$2
The series values is: ='Oct 22'!$I$4:$I$22
The horizontal axis values is: ='Oct 22'!$A$4:$A$22
Let us know if you have any questions.
Cool thank you so much, I will be working on it now, ill make changes
cheers
Re post #58, when cell C3 on the Results sheet is selected and then Data Validation is selected from the Data tab the source shows as: =Names!$A$2:$A57
The Names sheet had been hidden in the file attached to post #58, however it is unhidden in the file attached to this post.
Let us know if you have any questions.
do I just that for the other months like this ='NOV 22'!$I$2 ='NOV 22'!$I$4:$I$22 and ='NOVE 22'!$A$4:$A$22
and continued for the others?
As the November date range is from rows 4 to 18 use
='NOV 22'!$I$2 ='NOV 22'!$I$4:$I$18 and ='NOVE 22'!$A$4:$A$18
Let us know if you have any questions.
how about for the rest of the Months?
Start with row 4 and end with the last row in column A in which there is a date.
Oh ok, I will. Before I proceed I have a very important question. my question is since, I have to rows with the same name Evolution on I2 and down to I31
and also J2 Evolutions too, both displaying the same information can, I just delete column I and keep J?1.png
it would look like the workbook in post #60
Last edited by west123; 12-23-2022 at 08:06 PM.
It looks to me as if you could, however I would suggest saving the workbook before making the deletion
Make sure that deleting column I doesn't change any values on the other monthly sheets, nor the resumen sheet.
If after the deletion, all the monthly sheets and the resumen sheet are still displaying the correct values, then you could save the workbook again.
If something has been affected, then you simply close the workbook in which the deletion was made without saving and have your previously saved workbook still intact (I hope that makes sense).
I did save it. see workbook. in months tabs. also I got this message.1.png
I Think I fixed the #REF! message. J5 to J16 not calculating my months sessions days not sure why
Last edited by west123; 12-23-2022 at 08:42 PM.
If you saved before making any deletions, then I don't understand why Excel found a problem as there were no problems indicated in the file attached to post #60.
If you saved the file after having made deletions, the file attached to post #60 can be downloaded as a backup, since it contains both columns I and J.
this is how it looks now, but the Sess in resumen J5 and down not working see worksheet.
After I delete column the J5 to J16 change from number 1 to this 11.6667, I want the number 1 for the sessions played for the month.
Last edited by west123; 12-23-2022 at 08:53 PM.
The Sess column in the monthly sheets is now in column K, so the formula for J5 and down on the Resumen sheet should read: =INDIRECT("'"&$A5&"'!k3")
thank you, your a genius. I try try many things to fixed it. but i didn't want to change anything there i thought it was something like that since we delete a column. cool its coming along
In profit =INDIRECT("'"&$A6&"'!"&ADDRESS(3,COLUMN()+4)) what do I need to change.
also changed to 1.166667?
Last edited by west123; 12-23-2022 at 09:13 PM.
In the Sesion: H4 and down, How can I make the negative sessions turn RED in color in the cell background and turn green in positive sessions automatically with out me having to change the color manually? Attachment 810543
Just finished making all the graphs for tournaments & cash.
Deleting the column, cause trouble, I can't fix. the Profit in resumen M4 and M16 not giving the correct values now
same happened with Length not calculating the months total hrs.
Selecting Attachment 810543 in post #75 results in: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
As to post #76 change the formula in M4 to read: =INDIRECT("'"&$A5&"'!"&ADDRESS(3,COLUMN()+3))
Drag the fill handle over to cell N4 and then, while M4:N4 are still selected, drag the fill handle down to cell N16.
I will be away from my computer until one day early next week.
I hope that you have a blessed day and Merry Christmas.
Thank you mate,
Merry Christmas, to you and all your love ones wish you all the best.
talked to you then.
cheers
Wuz up, mate hope you and your family had a great Christmas.
Mate, a need your help
Hope that you and yours had a Merry Christmas also.
I'll need some information and likely a sample workbook in order to help.
it was great thank you. same hope it was well for you.
okay, I will upload workbook.
I would like my Inf. sheet where, I change the current year. and to reflect on my More Stats for Tourney Yearly Stats & more random Stats along with my Charts years, also how to make my charts update automatedly. "cell" for current Months hours. not calculating or my cash yearly stats and tourney yearly stats.
Why does it have this ! on the icon
Last edited by west123; 12-27-2022 at 10:27 PM.
ill be here posted
I feel that we would be better able to help if there were 10-20 dates in columns B and R with either real or fictional result amounts in the corresponding result columns on the bankroll sheet.
I will get you that now
Last edited by west123; 12-27-2022 at 11:07 PM.
okay, I input some results in the workbook
On the More Stats sheet:
For the Amount columns: =SUMPRODUCT((Bankroll!$Q$14:$Q$6000<>"")*(MONTH(Bankroll!$Q$14:$Q$6000)=ROWS(D$14:D14))*(YEAR(Bankroll!$Q$14:$Q$6000)=D$12)*(Bankroll!$Y$14:$Y$6000))
For the Hours columns: =SUMPRODUCT((Bankroll!$Q$14:$Q$6000<>"")*(MONTH(Bankroll!$Q$14:$Q$6000)=ROWS(E$14:E14))*(YEAR(Bankroll!$Q$14:$Q$6000)=D$12)*(Bankroll!$W$14:$W$6000))
The years on the More States, Charts and Info sheets are changed to 2022 - 2027.
I will be pretty busy over the next couple of days and then off again for a while, so I may not be able to answer questions as quickly.
Let us know if you have any questions.
cool, let me make the changes. ty,.
oh okay, When you have the time mate. I spend many hours on this and don't get much, done. your a lots of help, with a few formulas you give me.
where do I, Make changes myself in the future for more stats, charts and info sheets? where did you make the change?
have a question about the Profit Charts, lets say I started bankroll with 1000 where do I upgrade the chart to show graph starting from $1000 and not Zero?
not sure whats going on but, I get this message when I try to save worksheet. 1.png 1.png
I fixed that issue. mate
After all I keep getting the message in the picture. be careful! Parts of your document may include personal inf. I can't save!
Last edited by west123; 12-28-2022 at 01:12 PM.
where do I, Make changes myself in the future for more stats, charts and info sheets? where did you make the change?
have a question about the Profit Charts, lets say I started bankroll with 1000 where do I upgrade the chart to show graph starting from $1000 and not Zero?
The formula changes are in the profits and hours columns (January through December) on the More Stats sheet.
As for the year changes on the More Stats, Charts and Info sheets, I manually changed each 2006 to 2022, 2007 to 2023 etc.
As to starting with 1000 as opposed to zero, I don't see anywhere on the bankroll sheet that would allow that.
It may be that there is something in the VBA programming that could be changed, however I don't know enough about VBA to help.
So, that is probably a question that could be better answered by the person who produced the workbook (email address is on the bankroll sheet).
mate help me on this list please.
on the workbook in the info sheet. I want to record wins/scores of players wins. I want top 54 to stay on top base on wins. I would check scores, and record the win, the ones with the most wins, I want them to stay on top. list will keep growing. I want to be able to add names to the list, and to make top players base on wins to stay on top. see pictureAttachment 811105
top 28 players to base on winnings to stay on top1.png
Last edited by west123; 12-29-2022 at 12:49 AM.
I would use that for staking, but I want to have list of the Winning players, please help me on this one since, I started the stake see workbook
I will have to use this one since, I don't have to make one. I just change the names
Oh ok, I though the changes for the years could be done through the sheet, that's fine I can do that manually. Yes the 1000 Starting could be input. in the transactions columns. I was asking about how in the graph. If I start my bankroll at 1k, that it would show that on the graph. when you get a chance please help me get the Players List done to keep track of winnings keeping them on top the top 28, making list available for me to add more players, with out any more formulas. So it won't be hard for me when I add more players to the list.
Since I enlarge the list of players down, in the Inf. sheet I move the 2022 Cas/Tourney box to the top of 2024, the formula now is not showing the resutls.
I can't figure it out how to fixed it. see picture for detail. 1.png
Last edited by west123; 12-29-2022 at 12:58 AM.
Put the following into cell J20 and then drag the fill handle down to cell J31: ='More Stats'!D14
Put the following into cell K20 and then drag the fill handle down to cell K31: ='More Stats'!D32
Let us know if you have any questions.
Last edited by JeteMc; 12-29-2022 at 08:30 PM.
hi, mate
okay besides that did you do anything else.
mate help me with the list. where I can make players go up as per wins they have the most wins to stay on top. please
This proposal employs three helper columns (Z:AB) and puts the final list in column AC.
1. Z2:Z29 are populated using: =IFERROR(INDEX(Bankroll!C$15:C$3011,MATCH(0,INDEX(COUNTIF(Z$1:Z1,Bankroll!C$15:C$3011),,),)),"")
2. AA2:AA29 are populated using: =IF(OR(Z2=0,Z2=""),"",SUMIFS(Bankroll!P$15:P$3011,Bankroll!C$15:C$3011,Z2))
3. AB2:AB29 are populated using: =IF(AA2="","",AGGREGATE(14,6,AA$2:AA$40,ROWS(AB$2:AB2)))
4. AC2:AC200 are populated using:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Ty, mate
that kind of something I want but I want to go way more detail that that.
Something like this mate1.png
Last edited by west123; 12-30-2022 at 10:01 PM.
Selecting Attachment 811375 results in the following message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
I will upload sheet, this one mate
my list is the one to the left, I want to be able to. give them the player its place# from the Results tab. and to reflect on my score sheet.
I want to do it for the whole year. Days need to be from arrange. example starting form column C,D maybe January, E,F February, and so on
in the Tem Rankings, I want to put the name of Tournament they Play. I am not to sure how the Registered tab works, do you?
Last edited by west123; 12-30-2022 at 10:16 PM.
I don't see a sheet that looks like the screenshot shown post #103 in the workbook attached to post #102.
Hi, I can't upload sheet its 1.68MB what do i do?
Yes, please save your original file as *.XLSB OR *.ZIP
Please Login or Register to view this content.
Last edited by wk9128; 01-25-2023 at 08:53 PM.
mate, help me on this one. please
take a look I will upload the two workbooks. via zip going to now
question before I upload, I been working on this imputing information and i close without saving I reopen file, then try to recover, but no luck? any advice
mate, can it be possilbe to add the workbook 2023 SpEv. on my workbook to generate the information in my spreadsheet. base on my staking. and get playerHistory just like on the 2023 workbook?
Last edited by west123; 01-26-2023 at 08:35 PM.
Mate, Is it possible to combine my workbook and make all information I input on the ALL Results and PlayerHistory? to just be able to Search the Players name?
In the Power Stake original workbook (post #92) on the Bankroll sheet it gives the name and email address of person who produced the workbook and states that they may be contacted for questions.
Since Power Stake is one of the workbooks in the poker.zip I suggest using that contact information to ask about combining with the other workbook, since that person would know more about how the Power Stake original workbook operates than me.
Mate, I have sent him few emails now. No response. Not sure why. the only person that can help me is you.
thats the only reason I log here to wait for you to log in. all day I am trying to get your help, but is been tough
now to get you to help me. can you help me. just to make it work like the 2023 workbook with my staking information.
is it to complicated, or not possible to do? mate?
Not sure what you mean by "...make it work like the 2023 workbook with my staking information..." but I'll guess:
1. That there should be a drop down list somewhere on the Bankroll sheet (i.e. cell C9)
2. That the formula for Current Month Tourney Profit could be:Formula:Please Login or Register to view this content.
3. That the formula for Current Month Cash Profit could be:Formula:Please Login or Register to view this content.
If those two do what you want, then we can look at some of the other totals.
FYI, I am tied up with a project that is taking much of my time, so if you are solely depending on me for help it could take quite a while.
Let us know if you have any questions.
Mate, what I mean by the 2023 workbook.
is if you can make it part of my workbook. Meaning ALL Names in the 2023 will be my players list and I would have a summary of all the players results.
Example I would have in the 2023 1. Total of money Won 2. Total ITM 3. Total Wins. The places they finishes on top which is 1 thru 16-60.
Example Zorro222_zorro222 His status are in Green When search his name. Total Points 22 ITM 1 Total FT 1 Total Wins 1 money won $15
and when you go to players history tab you see all the tournaments results Jan 22 23 place 16 of 64 name of tournament Bankroll Booster and his results to year to date are 7 tournaments.
Thats how I would like my results to generate like in the 2023 workbook, only column that can be remove is TOTAL LB POIONTS
In the 1 thru 16-60 rule on top it would give me how many times a players finishes in 1, 2, 3, 4, 5 etc and money won or if he is negative then I can see the whole list of tournaments I have stake him.
please make this a project, to him me get this done, to make workbook 2023 part of my spreadsheet.
I looked up the person who produced the poker staking workbook, Zach Hirst, and found this website: https://pokerdb.thehendonmob.com/player.php?n=163745
On the website, which has been updated through Jan 25, 2023, under the heading Poker Database there is a listing for poker players.
This is about the extent to which I will be able to help as I don't see a way to combine the two workbooks in the poker.zip file.
I hope that you have a blessed day.
Thats just his records of his results, which he is not active now. I have send him emails no response. Your and Excel Expert. should be a way to do it.
okay look I have try to put something not close of the 2023 workbook, but maybe you can help me on this. see workbook.
on profit tab, is there a way to make my number of Rank finishes to reflect on Profit tab, along with the players name and winnings.
Also on the cell AK Total: Profit/Loss By player can I get the Sum of the results of all 3 categories Speed racer, Tournament, Hyeper and Turbos, and can you make it automatically sort to be highest amount on top to lowest of loss.
Last edited by west123; 01-30-2023 at 02:41 AM.
Do any of the lists in columns A:C on the Info sheet contain all of the names that appear on the Profit sheet?
I created ABC list in info, because I din't know how to get the break down for each category, in Speed Racer, Tournament, Hyeper & Turbos. with one list.
to answer the question, is no each individual list is for each category to give me the amount for each player playing in either, But some of the players names are in all categories.
is it possible to only use one list? I can put all names in info A3 and down. if you can make it work like that? but not sure if ill get the results in More stats
Here is one way you can make a list in descending order on the Profit sheet:
1. In column V on the Info sheet is a list of distinct names produced using**:Formula:Please Login or Register to view this content.
**This formula sometimes has to be entered by first holding down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself), although you may be able to activate the formula using just the Enter key in the 2021 version.
2. Column W lists the totals from Speed racer, Tournament, Hyeper and Turbos using: =IF(V2="","",SUMPRODUCT((Profit!A$3:Y$5760=V2)*(Profit!B$2:Z$2="Profit"),Profit!B$3:Z$5760))
3. On the Profit sheet column AK displays the amounts using: =IFERROR(LARGE(Info!W$2:W$400,ROWS(AK$2:AK2)),"")
4. Column AW displays the names using: =IF(AK3="","",INDEX(Info!V$2:V$400,AGGREGATE(15,6,(ROW(Info!V$2:V$400)-ROW(Info!V$1))/(Info!W$2:W$400=AK3),COUNTIFS(AK$3:AK3,AK3))))
Let us know if you have any questions.
Mate, I really appreciate a bunch your help and time.
Would this do anything to the # finishes like generate the wins from the Bankroll sheet? I been working all morning, since you ask me about the lists in columns A:C
I try to simplify the sheet. Please take a look. I try to applied the formula on D9. Since I change players to be only on D column thought would be easier. also see allresults and playershistory tab.
Finaly I was able to shrink the file will upload
Last edited by west123; 01-30-2023 at 02:45 AM.
its not letting me upload its over 15mb i try zip
Since the names are all in column D on the Bankroll sheet the formula for cell D9 could be:Formula:Please Login or Register to view this content.
I set up a dropdown for cell C9 linked to the list in column AC on the Info sheet however it may be simpler to type in names as that list in very long and not in any particular order.
As for number of wins I put the following into cell E9:Formula:Please Login or Register to view this content.
As to the All Finishes:
1. Populate I2:W2 using: =IF(COUNTIF(playersHistory!$B$3:$B4368,I2)>0,COUNTIF(playersHistory!$B$3:$B4368,I2),"")
2. Populate X2 using: =IF(COUNTIFS(playersHistory!$B$3:$B4368,">=16",playersHistory!$B$3:$B4368,"<=60")>0,COUNTIFS(playersHistory!$B$3:$B4368,">=16",playersHistory!$B$3:$B4368,"<=60"),"")
3. Not sure why Y2 should be 20 as there are 22 items listed on the playersHistory sheet but I used: =COUNT(playersHistory!A3:A24)
4. Populate Z2 using: =I2
5. Populate AA2 using: =MAX(playersHistory!E3:E24)
Let us know if you have any questions.
Thank you, Thank you. Yes Thats great to type and auto fill name easier than, to look for the name in dropdown list. "Y2" would be in Bankroll cellO, I want to have the count of players who have the most rebuy/re-entry to a speed racer or tournament. to have and idea if his a Donkey meaning in poker a very loose player.
I will see the changes. ty again
please see pictures. I don't think I can upload ? is forum under maintenance
here is the link
https://imgur.com/OlPaq81
https://imgur.com/thTqAdx
Last edited by west123; 01-30-2023 at 03:46 PM.
RE: post #124, It would seem that the All Finishes values should only represent results for the player named in cell G2 and that those values should mostly be retrieved from the Bankroll sheet.
If that is correct then:
1. The formula for I3:W3 could be: =COUNTIFS(Bankroll!$D15:$D3062,$G2,Bankroll!$L15:$L3062,I2)
2. The formula for X3 could be: =COUNTIFS(Bankroll!$D15:$D3062,$G2,Bankroll!$L15:$L3062,">=16",Bankroll!$L15:$L3062,"<=60")
3. As there is nothing in column O on the Bankroll sheet I don't know how a rebuy is designated and can't write a formula for Y3.
4. The formula for Z3 could be: =COUNTIFS(Bankroll!$D15:$D3062,$G2,Bankroll!$N15:$N3062,1)
Note that I3:Z3 are custom formatted: 0;; to hide zero values.
5. The formula for AA3 could be: =INDEX(H3:H391,MATCH(G2,G3:G391,0))
The formula in column G is changed to read: =IF(H3="","",INDEX(Info!V$2:V$400,AGGREGATE(15,6,(ROW(Info!V$2:V$400)-ROW(Info!V$1))/(Info!W$2:W$400=H3),COUNTIFS(H$3:H3,H3))))
The formula in column H is changed to read: =IFERROR(LARGE(Info!W$2:W$400,ROWS(H$3:H3)),"")
Let us know if you have any questions.
okay. yes for cell O its going to be the times he enters a tournament could be 1, 2, 3, 4, 5 he his loose player that would give me total of player with most Rebuys which will alert me to stake him minimum.
For column H the amount won't auto calculate to top. I enter winnings in bankroll sheet and won't show in colum H.
Also in column H2 under catagory search, when I make a Name Search can I get the *All Finishes* for only the catagory I choose if is Speed Racer to only show finishes for each individual catagory.
I input some results in bankrollsheet.
please see tab allresults
I am guessing that only 2 and up are classified as rebuys....for cell O its going to be the times he enters a tournament could be 1, 2, 3, 4, 5 he his loose player that would give me total of player with most Rebuys which will alert me to stake him minimum
It would help if we could see some examples in the workbook of how column O will look as all the cells in that column are blank. Also please tell us the expected result for cell Y3 based on the name and category.
Should be working now. The formulas in post #120 were written for a workbook that had a sheet called Profit, which is not included in the workbook attached to post #121.For column H the amount won't auto calculate to top. I enter winnings in bankroll sheet and won't show in colum H.
Should these results come from the Bankroll sheet or from the allResults sheet?when I make a Name Search can I get the *All Finishes* for only the catagory I choose if is Speed Racer to only show finishes for each individual catagory.
yes 2 and up, top 10 entries. for column celll O in bankroll I input rebuy #s 3, 4, 5, 6, 7, 8, and 9 <--------------Y3 will be as many times the player enters the same tournament.
In other workbook. you made it auto calculate in post# 123
Results should come from bankrollsheet for individual catagory. Example i search name in G2 I want results from catagory Speed Racer all finishes and amount won or lost to reflect on All finishes.
Last edited by west123; 01-31-2023 at 01:28 AM.
In the search now, takes about 60 seconds to calculate the money won, before it was instant to reflect.
The file attached to post #130 lacks the formulas that were applied to the file in post #129.
Please always work from the file with the most current formulas, in this case the file attached to post #129, I have done that for you this time.
If your computer completes the calculations in 60 seconds then it is fast. Takes mine a few minutes. Looking through columns A:C to find a complete list of distinct players uses a lot of resources. It would be faster if the list in column A on the info sheet was complete so that the formula in column V was not needed. Note that the drop down in column D on the Bankroll sheet seems to reference column A on the Info sheet, so those would be the only names that could be used to index profits anyway.
The formula for rebuys could be: =SUMPRODUCT((Bankroll!D15:D3062=G2)*(Bankroll!O15:O3062>0),Bankroll!O15:O3062)-COUNTIFS(Bankroll!D15:D3062,G2,Bankroll!O15:O3062,">0")
Let us know if you have any questions.
okay, yes always from the current got it. Yes, but if I move the mouse calculations stop or reset. Column A on the info, complete? you mean where I don't have to add new Players? instead just add them in bankroll column D. If list on column A on info, shee is not needed lets get, rid of it. Question, the 3 list in info column A, B, C I use to get the amounts for each category in Allresults speed racer, tournament, and hyper and turbos, would that be affected if removing list ABC in info. and just using column D on bankroll?
which route would be the best to go, your the excel expert, mate the best of the west.
Also almost forgot.
in the *Name search* list take long to reflect amount in money won when doing a search. it need to calculate 1st to show result. Can istead be a formula in cell AA2 in money won to pull profit/loss from Speed, tournament, and hyper and turbos list. so like that when i do a search it won't affect having to wait. or maybe can it be done from banrkroll sheet?
In Speed racer tournament , hyper and turbos can it be a manual sort list or filter to where I can sort highst amount go up?
the least of list of players if they can be less would be great if not nessesarry
can you make this change. I would like to see how it works
so those would be the only names that could be used to index profits anyway.
Last edited by west123; 01-31-2023 at 05:28 PM.
I think that the best way to speed up all calculations is to make a list of names in column V on the Info sheet, of course you'll have to manually add new names to the list.
I added conditional formatting to cells 2:400 to identify duplicates in that column so that you would know if the name is already there.
I put a column between the Speed racer, tournament hyper and turbos columns and the rest and then added sort filter buttons to cells A2:F2 which can be used to sort or filter.
Let us know if you have any questions.
ill do the list, thats fine. ill deal with that. oh cool damn ty for that wow your a life saver. to identify duplicates awsome. wow you read my mind, I was going to say that, how would i know if name was on list. thank buch. cool. let me see the changes.
Question in the Search by category? is that something that can be applied?
on the sort filters why can all match highest amount on top? when I do one the others change can that be arrange?
totals.jpg
space.png
Last edited by west123; 01-31-2023 at 07:24 PM.
nice alot faster, ,cool
This update includes many of the requested changes, except for left alignment.
I don't think that find and replace is going to work in this instance. To get rid of the space to the left of the text you could highlight a group of cells (i.e. C74:C87) and then in the formula bar delete the offending space which will left align all those cells.
As for the rest...
To sort each type of tournament:
1. Separate the tournaments
2. Convert the individual tournaments into Excel tables
To show wins when rank is 1, populate column N using: =IF(L15=1,1,"")
To show money won by type of tournament use:Formula:Please Login or Register to view this content.
To highlight the name displayed in cell J2 use three conditional formatting rules similar to: =$A3=$J$2
Let us know if you have any questions.
okay, I will copy all and paste in notepad and do it from there. don't want to mess things up in the workbook. thats fine.
nice let me go see changes. so excited, when about to open workbook cheers
Question how can I remove, the green Arrows in workbook in allResults on the left corner to the names?
I don't think I explain my self, right in the speed racer, tournaments hyper and turbos? the amounts show all the same.
I want them as per catagory, each individual amount. I think i have workbook of when you had it that way. let me find and will upload now.
Its the workbook in post 120, it has the breakdown for each catagory. to the bottom Its the stats for players that are negative. that gives me a breakdown of how each player is doing in each catagory, where I can see in which field they are winning players. let me know if you need me to upload its on post #120 and to the total profit/loss it gives me the total of all catagorys which is right
I made these changes. hope everything is the same.
Attachment 815826
just notice the changes on the picture are no on the worksheet, will redo it.
I re-upload workbook with the changes in the pictures.search.jpg
Last edited by west123; 02-01-2023 at 01:45 AM.
Wow, a player in the list had me going in circles, till now I figure it out.
JESUSYAAZY Was in bankrollsheet with his name bit different from all other list including the one in info. cell V
i update every list to the correct name -----------------.> JESUISYAAZY now I am able to find him in the search
i started inputing the results for rank, entrants, #wins and rebuys.
Last edited by west123; 02-01-2023 at 12:51 AM.
I don't see them, but generally hover the cursor over the cell and then over the caution icon to the left (or right) of the cell and select ignore from the list that appears.Question how can I remove, the green Arrows in workbook in allResults on the left corner to the names?
Please explain how this would be done manually. The only ranks that I see are on the Bankroll sheet and they don't seem to be specific to speed racer, tournaments hyper and turbos, unless I am missing something.I don't think I explain my self, right in the speed racer, tournaments hyper and turbos? the amounts show all the same.
I want them as per catagory, each individual amount. I think i have workbook of when you had it that way. let me find and will upload now.
As for lengthening the list in column V on the Info sheet, could you tell me approximately how many names might be in the list once completed as there are formulas referencing that list that will need to be changed.
oh ok I will try that
Yes in bankroll sheet, I have the 3 catagorys. I input the names in row 13. can the stats be pull from there for each individual name amount and rebuys, rank and wins
list would not be complete soon since we have the stats for 7 years but it will be for each year, is it hard for you to explain of how I can do it myself as needed?
see barkroll sheet for catagorys
I added a column on AD on allResults. can you make it calculate the # of stakes, it would be how many times I have statke that player.
Last edited by west123; 02-01-2023 at 02:41 PM.
Can you see this workbook, maybe contains information of how it manually works,Thats pretty much the Big Picture of how I wan't the results. do a name search and catagory pick so you can see how it gives all the results. also when you choose a name go to playerHistory and for each player there it will generate the results.
also it has the option to search for All Sites
https://docs.google.com/spreadsheets...#gid=777467032
https://docs.google.com/spreadsheets...t#gid=66138952
Last edited by west123; 02-01-2023 at 03:27 PM.
I think that I have the allResults sheet working the way described.
1. The Profit columns have formulas like: =SUMIFS(Bankroll!$P$15:$P$3061,Bankroll!$D$15:$D$3061,A3,Bankroll!Q$15:Q$3061,A$2)
2. The Finishes cells have formulas like: =IF($K2="All",COUNTIFS(Bankroll!$D15:$D3061,$J2,Bankroll!$N15:$N3061,L2),COUNTIFS(Bankroll!$D15:$D3061,$J2,Bankroll!$Q15:$Q3061,$K2,Bankroll!$N15:$N3061,L2))
I have not had time to look at the google spreadsheets, but will try in the next few days.
Let us know if you have any questions.
awsome, I will see now. thats fine when you get a chance ty.
Can you, add the, Stake count ? I upload on post 141 I will reupload
I would like to have the count of Stake of how many times I have stake the same player for each catagory
how come on the rebuys in showing N/A for Speed Racer and tournaments not working
Last edited by west123; 02-01-2023 at 08:56 PM.
Got the rebuys working.
Formula for cell AD3 is: =IF(K2="All",COUNT(playersHistory!A3:A24),COUNTIFS(playersHistory!A3:A24,"<>",playersHistory!H3:H24,K2))
playersHistory is now showing data based on player and category.
1. Dates: =IFERROR(AGGREGATE(15,6,Bankroll!B$15:B$3061/(Bankroll!D$15:D$3061=allResults!J$2),ROWS(A$3:A3)),"")
2. Other columns are similar to: =IF(A3="","",INDEX(Bankroll!N$15:N$3061,AGGREGATE(15,6,(ROW(Bankroll!N$15:N$3061)-ROW(Bankroll!N$14))/(Bankroll!D$15:D$3061=allResults!J$2),ROWS(B$3:B3))))
Let us know if you have any questions.
Wow, mate thank you a bunch, can wait to download it, now you are amazing. cheersdownloading now
nice, nice nice mate.
mate few questions see pictures
hide.jpg
I notice in the picture when doing a search for *Speed Racer* it show all 3 Catagorys mixed
can we add here the # of rebuys from Bankroll sheet
rebuy count.jpg
Last edited by west123; 02-03-2023 at 02:55 PM.
can the Stake amount also be in the playersHistory. From bankroll sheet under buying for each catagory
stake amount.jpg
Last edited by west123; 02-03-2023 at 09:47 PM.
Please note that selecting attachment 816253 results in: "Invalid Attachment specified. If you followed a valid link, please notify the administrator" so I had to guess at where on the playersHistory sheet buy ins were supposed to go.
I believe that I have covered all other requests.
No, you should not have to fill column I on the playersHistory sheet as the formula there is copied down to row 51.
Let us know if you have any questions.
okay, Just re-upload. thanks mate, let me download see all the changes. and how about after row 51? list of staking results will continued to grow.
can I cut copy, paste stake amount to where the pictures shows?
I did a Panlux search get no results in playershistory. or stake amount
panlux.jpg
Last edited by west123; 02-03-2023 at 09:58 PM.
If need to add more rows, select cells A51:I51 and drag the fill handle down as far as needed.
Here is the file with buy ins in column E.
Let us know if you have any questions.
okay, I will. How about for the players list? in Info cell V
when doing search for player under Tournament no *Finishes* place show, rebuy or stake count. only Money Won
How am I suppose to manage this list? When I drag the fill handle down, to show stats for Finishes, stake, money won it will duplicate names.
duplicates.jpg
Formulas have been modified to addresses issues listed in posts #152:153.
As to post #154, in my opinion that would be easier to accomplish using a pivot table as modeled on the Pivot Table sheet.
Let us know if you have any questions.
cool, happpy morning, thank you mate. will see changes.
Mate the Stake Count seems not to be acurrate, for player *Allinwin7* he has in playerhistory 60 speed racers. in allResults #Stake he has 22
whats the pivot table for? how do I manage that. or i don't tounch anything there?
will upload
see these workbook with new inputs I will continued to input along the day almost done.
how can I change the Buying amount in color in playersHistory to yellow instead of white?
Since you created the Pivot Table, is the list in info ABC are they still needed? or can I delete? I would like file to shrink a bit keeps getting bigger
Player Allinwin7 didn't have any games stake for Hyper and turbos, I when and input to see results and I get this.
allinwin.jpg
All results for player not displaying see picture.
game stake.jpg
Last edited by west123; 02-04-2023 at 01:53 PM.
Not sure why pivot table show this results. for player Samir Amin. they are not in bankrollsheet see stats.
pivot.jpg
I believe that the requests in post #156 are fulfilled in the attached file.
I suggest making a copy of the file and deleting the names in columns A:C on the Info sheet from the copy file. That way if it causes problems elsewhere in the workbook you still have the working original.
The result for Samir appears to be for Tournaments (-10.04 and 14946.00)
Let us know if you have any questions.
okay, I will delete now.
In tournaments I don't see that amount of 14946, I will Double check. ty mate
I delete all 3 columns ABC, when I need to input new players that would be on info cell S ? or Pivot Table?
This happend when I delete all 3 columns on Info sheet I get the #REF! REF.jpg
Last edited by west123; 02-04-2023 at 11:24 PM.
when searching for all games, the palyersHistory is empty
catagory.jpg
Last edited by west123; 02-04-2023 at 11:40 PM.
Mate, I finished the inputs just now. Can we work out of these workbook, I want you to see, that Samir Amin still showing the high amounts after I delete from bankroll sheet, not sure why. also I added a new column on allResults Would like to Have the *Total of Wins* for all players from bankroll sheet column O.
Some Players show Stake Amount/buyin on *playersHistory* and some don't.
cheer mate and thank you very much for all your help.
To get the pivot table to show correct results after changes have been made to the Bankroll sheet, select any cell in the pivot table, right click the mouse and select Refresh.
The formula for cell AE2 on the allResults sheet is: =COUNTIFS(Bankroll!O15:O3061,1)
I restored the formulas to the playersHistory sheet so that they will show results for all categories as well as individual categories.
Let us know if you have any questions.
wow thank you mate, and happy morning. will see the new changes.
I don't want to mess up things. when inputing a new player inwhich list do I do it? info ABC and V ? do I input anything in Pivot table?
Last edited by west123; 02-05-2023 at 11:29 AM.
Mate, can this be adjusted in all Catagory's buyin/stake amount to reflect only when profit to the right, see picture for detail.
zer0.jpg
Last edited by west123; 02-05-2023 at 12:59 PM.
Mate, can the profit from these list be adjusted to reflect from Pivot Table instead.
see picture for detail.
profit list.jpg
I am not sure that I understand the request in post #164, please specifically state what should happen when:
1. the amount in column E is not zero and the amount in column F is positive
2. the amount in column E is not zero and the amount in column F is negative
3. the amount in column E is zero and the amount in column F is positive
4. the amount in column E is zero and the amount in column F is negative
As for the request in post #165 I have made the changes to the Info and allResults sheets and the workbook seems to operate correctly, although I encourage you to do further testing to make sure. We can always revert back to the version in post #162 if there is a problem.
Note that when no filter is placed on the pivot table the results are the same as in rows 3 and down on the allResults sheet, so you might consider removing rows 3 and down on the allResults sheet.
To add names to the player list select the last cell in column W that has a value (W392 in the attached file) and press the Tab key.
Let us know if you have any questions.
Hi, Mate in post #164 I would like the Amount in cell E to reflect only when amount in cell F is not negative, so it won't show both amounts the same.
I only need the amount in E when there is a Win I can see how much I buy and how much around the profit will be.
yes I will keep testing many things have been fixed, and every day seems to be working alot better, thanks mate.
Last edited by west123; 02-05-2023 at 11:04 PM.
sample
that would give me an idea how much profit once the buying shows when there is a profit.
check.jpg
Can pivot table be move here?
I kindoff like it when, you made it highlight the Yellow in all catagorys after a search giving me each amount
pivot.jpg
Last edited by west123; 02-05-2023 at 11:16 PM.
The search is inactive for player or catagory, I had deleted the this. is fixed now.
delete.jpg
I though it was not needed after all the other rows were taken out.
Last edited by west123; 02-05-2023 at 11:29 PM.
The pivot table is moved and formula in column E on the playersHistory sheet modified:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Happy, morning mate. cool ty I will download and see changes and keep testing
Mate, can pivot table be sortable to highest amount to lowest?
just saw how right quick and sort small to highest, disregard this msg
in the info sheet, can I cut and past all the way to the left? also wold be nice to have a Down Bottom to take me to the New name to input since list is going to get bigger.
Buyin/stake amount from bankrollsheet to reflec, in arrow and Squares too
games.jpg
Last edited by west123; 02-06-2023 at 10:44 AM.
when doing a search. can name of player, on pivot list move up to top to show result, instead of looking him for name if he is negative like in this case for *Allinwin&* in tournament he is $-1.00 and he is in row 142. can it be automatically to move up when doing the search. Not sure if there is a better way to show all the Yellow banners of all catagorys.
allin.jpg
Done.in the info sheet, can I cut and past all the way to the left?
Select any cell in the profit column of the table and press the Ctrl and down arrow keys....wold be nice to have a Down Bottom to take me to the New name to input since list is going to get bigger.
Changed formula in column E to read:Buyin/stake amount from bankrollsheet to reflec, in arrow and Squares tooFormula:Please Login or Register to view this content.
As to the request in post #176, if it is possible it would require VBA of which I know too little to help.
Let us know if you have any questions.
Cheer mate, wow I was able to be back, internet dificulties. I will see changes, I recall you mention to me that about VBA. Besides VBA is there no other solution to post #176
Last edited by west123; 02-06-2023 at 07:56 PM.
The list, and totals no longer here.
totals.jpg
how did you do this? I see the mistake count is 60 and its only showing 50 total
fixed count is now 60
allinwwww.jpg
a60.jpg
Last edited by west123; 02-06-2023 at 08:21 PM.
Fixed issue from post #179 using:Formula:Please Login or Register to view this content.
And: =IFERROR(LARGE(tbl_PlayersAndProfits[Profit],ROWS(I$3:I3)),"")
I don't know how you would move Allinwin7 to the top of player column on the pivot table however you could accomplish isolating the information on Allinwin7, such as profit, using a second pivot table as modeled on Sheet1.
It is not an eloquent solution, but the Player slicer illustrates that there are a lot of players who have been put into the Bankroll sheet with extra spaces in the name therefore causing Excel to view them as different people (i.e. AAApxs)
Let us know if you have any questions.
cool mate ty. Would that be the only funcions of Sheet1? of how it would work, by selecting a player to give me the profit/loss. I am working on removing all spaces from players, by tomorrow or maybe tonigh, I should have all spaces remove, have to go one by one. I will see changes,
can this be adjusted mate.
0.jpg
Last edited by west123; 02-07-2023 at 12:21 AM.
not to familiar with that player name slicer
How come some players in sheet1 are inactive, even tho they have games under the 3 catagorys?
mate, I cant firuge it out how to remove the more than 1 count for the players that are showing more than 1.
count.jpg
Last edited by west123; 02-07-2023 at 01:20 AM.
Can't see the name of the player in post #182; however, in the file attached to post #181 the category search can be changed to Speed Racer and Allinwin7's player history does show buy-ins when profit is positive, so I believe the formula is correct.
Custom formatting applied to display positive numbers in green: [Green]$#,##0.00;;[Yellow]$0.00
Please provide an example.How come some players in sheet1 are inactive, even tho they have games under the 3 catagorys?
The count just shows how many times the player participated in the category/categories selected. Allinwin7 participated 60 times in all categories although none in Hyper and Turbos.
If you don't want to show player count then right click on Count of Player, cell B3, and select Remove "Count of Player".
Let us know if you have any questions.
happy morning mate, Player in Post #181 its Luchenosets8. but can adjustment be made to show buyin/stake amount, and formatting to all players in all catagory's, some do have buyin/stake amount, and some are Zero and no formatting either which remain in yellow color.
I missed understand, when you mention in post #181 though the count was showing having many players similiar names like this name I found 2 times
example: Zan0za and ZanOza zer0 and O making it 2 players thats what i thoug the count was. but its fine, I like the count to show how many times they have played each tournament.
though you were refering to this #181
Player slicer illustrates that there are a lot of players who have been put into the Bankroll sheet with extra spaces in the name therefore causing Excel to view them as different people
Luchenosets8 is not in my file; however I removed the custom formatting and put in the following conditional formatting rule: =F3>0 (Green font and Black fill)
As I believe you have already found, it is the Player slicer found in columns D:AK on Sheet 1 that can be used find names that contain extra spaces.
Let us know if you have any questions.
Thank you, mate. I will down, now. Can modifications be made to workbook. I will upload shortly. I will look for slicer, very interested in seen how that works on removing spaces, since thats now an issue for me having to spend to much time on figuring out why that happens.
Made please see all new changes I made, not sure if things got mess up in all the cut and paste, I did. Also if everything is okay in allResults do we still need sheet1?
also can you adjust the totals: not sure since a formula need to be input because new rows would be added. in cell B6, and cell F3 for totals in allResults
Last edited by west123; 02-07-2023 at 10:40 PM.
Luchenosets8 is in player list on column A of the Info sheet.
Not sure why Excel would not let me put the name in the Name Search before; however, here is the file.
Let us know if you have any questions.
Mate, still not showing amount.
this is happening with lots of players I think mostly in tournaments, and turbo hypers some in speed race.
luche.jpg
Added a column R to the Bankroll sheet to calculate Buy-in from all categories using: =SUMIFS(F15:J15,F$14:J$14,"Buy-in")
Column E on playerHistory sheet is populated using:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
thank you, mate
I will see changes now. have you had a chance to see all the changes I made in the upload, would like to know your experience advice not sure if everything its working as it should.
I just re-upload the modify workbook mate
nice mate, I see all amounts reflecting
Mate, In The Player slicer, how do I use it to know whichones have extra space and what to do next, once identify.
Mate, can this changes be modify. Would be more productive to have list also here. than having to move from sheet to sheet, and not jumping thru the hoops, when staking player and trying to use the little information I have.
revised .jpg
Last edited by west123; 02-08-2023 at 01:41 AM.
As to post #196 the slicer may help identify which players, like HAY AAKK, need attention on the Bankroll sheet. You will need to go to the Bankroll sheet and use the filter button in cell D14 to find the rows containing HAY AAKK and remove the extra spaces found in cells D1115 and D1159. You'll need to repeat this process for each name that is listed more than once in the slicer.
As to post #197 I will have to look at that file later, my real-life project has become intense, and it may be a few days before I can get back to this. However, you could make a copy of your file and experiment without having to worry about destroying the work that has been done to the original. Then you can carry the things that work back to the original file.
cool mate, thank you a bunch. I will go one by one and remove all the extra espaces.
Yes, I will make copy and leave orginial as is. Hope things get well in your project.
wuz up Mate, glad to see you, hope things, got well.
Would like for you to see the workbook. I will Upload
Mate the Search where it highlights the player with the Yellow highlight is not working, every time I expand the pivit table many things change.
not sure why this empty spaces, also on the list, one is showing a (blank) player
why is this happening mate,
changin.jpg
spaces.jpg
west.png
Last edited by west123; 02-10-2023 at 10:13 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks