+ Reply to Thread
Page 2 of 2 FirstFirst 2
Results 201 to 217 of 217

Help with Total bankroll Balances in different sheets an all DOn SNg stats

  1. #201
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    Their are 88 rows of duplicates. So you should delete 44 of those rows. For example sessions 1174 and 1181 are duplicates. Select cell A1234 and right click the mouse. Select delete > entire sheet row and click the mouse.
    You'll need to repeat that process for one row of each pair of duplicates.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  2. #202
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,853

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    Mate, can we work on this file i work on it all day today, in pokerstake tab
    I highlighted in blue a section column L:Q I would like to use that as when im doing the staking i can play with % and see how much to buy base on BI % of BR. i also have 2 notes in cells Q8 and R8. In column Y and AA the numbers below should replace the above numbers of the same column, I also included the Daily pokers sessions where you can also see the calculations. i would like to have these changes then copy everything from the tournament live play games to this file when we have all the stats mention above.
    can all the zeros in these cells be eliminated or don't show n7, n8, t7, t8, u7, w7, and w8
    Attached Files Attached Files
    Last edited by west123; 03-25-2024 at 11:08 PM.

  3. #203
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,853

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    thank you. i just complete deleting all duplicates now in this file show 44
    not sure how to remove false from column T
    Attached Files Attached Files
    Last edited by west123; 03-26-2024 at 11:16 AM.

  4. #204
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    not sure how to remove false from column T
    Select cell T7, press and hold the Ctrl, Shift while pressing the down arrow key, and then then press the delete key.

  5. #205
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,853

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    thank you mate will do that now.
    please let me know about post # 202 will here to anwers any question yo may have
    Last edited by west123; 03-26-2024 at 01:20 PM.

  6. #206
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,853

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    mate please give me this fixed
    i have this formula in s9 where the amt. of -1.10 =[@Cashes]*(1-[@[Sold % ]])-[@[cost player]]*(1+[@Rebuy])
    amt. should be 0.99 its $0.11 x 9 rebuys but instead returns -$1.1099.png
    just found out that fixing this issues will then can be applied to original workbook as is 2 different things going on with GG games and the other games base on formula, thats why i see amt. in cell s7 -$8.80 when it should be 7.70 due to the cost player amt.
    Last edited by west123; 03-26-2024 at 01:45 PM.

  7. #207
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    Column Y: =IF([@Tournaments]="","",N([@Results])-[@[Buy-in]])
    Column AA: =IF([@Tournaments]="","",ROUND(N([@Results])*(1-[@[%]])-[@[cost player]],2))
    To hide the zeros change the custom formatting:
    Column N: $#,##0.00;[Red]-$#,##0.00;
    Columns T, U and W: $#,##0.00;;
    I don't know what is meant by the comment in cell Q8 "can BI % of BR be fixed to be able to use base on Sugg. Buy-in from cell M2"
    Please give specific examples of how changes in cell M2 as well as cells in columns L:P should affect cells in column Q.
    Attached Files Attached Files

  8. #208
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,853

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    thank you mate. will test everything i will spend all day today looking at the file

  9. #209
    Registered User
    Join Date
    03-26-2024
    Location
    Ukraine
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    To calculate total bankroll balances:Sum up tournament balances from the Tournaments sheet.Total cash game balances from the Cash sheet.Add balances from Double or Nothing Sit and Go entries in the Don Sng sheet.Combine balances from all game types in the Pokerstake sheet for the overall bankroll balance.

  10. #210
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,853

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    thank you. maybe i am wrong about Q8 comments since Bi % of BR is from the actual balance amt.
    Last edited by west123; 03-26-2024 at 02:17 PM.

  11. #211
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,853

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    thank you zorik, as per your advice i think that is the way we already have it set up
    using this formula =SUM(K8,Cash!H5,'DoN SnG'!H4,'Stake Bankroll'!J5) you can see that in bankroll sheet
    for Total Bankroll. once again thank you for steping in to help

  12. #212
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,853

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    thank you, for berst steven changes are almost complete few other adjustments
    1. can column AA calculate the results per column R percentage when i chage %
    2. can we add the negatives in column T cells
    t9,($151.37)
    t10,($106.66)
    t11($40.25)
    3. column W Running balance. for 9:13 cells
    4. the todays buyins in pokerstake bankroll
    Todays Buyins $0.00
    Todays Cashes $0.00
    Todays Profit: $0.00
    Attached Files Attached Files

  13. #213
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,853

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    please disregard post # 206 in this file here very simple changes i think needed
    i would like amounts to stay the same when chaing rebuys in cells
    1. v8 to (7) rebuys
    and
    V9 to (9) rebuys
    total bankroll to be 30.29 using include adjustment
    2. can we remove $13.44 from starting roll in cells k7 and j7 to not have #value! erros and the #div/0!
    something like this with outh #value! error proof.png
    Attached Files Attached Files
    Last edited by west123; 03-26-2024 at 03:33 PM.

  14. #214
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    West123 please check my PM to you.

    Also, I find it hard to understand that after over 200 posts, this thread is still about the initial question?
    If you have strayed away from the original question, please start a new thread for the new question.
    Last edited by FDibbins; 03-26-2024 at 11:35 PM.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  15. #215
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,853

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    FDibbins
    I just reply via PM
    I am sorry things got a bit carry out I know is my bad, but i assure you that, i was going to create new post once the 200 hit when i saw 2nd page
    For now i will strayed and once i see 2nd page will create. new post not letting it go beyond.
    ones again i apologize for my mistakes
    Last edited by west123; 03-27-2024 at 12:17 AM.

  16. #216
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    Apology accepted, but please do not start a new thread for the same question, we require 1 thread per question - you will end up bumping heads with some of the mods if you do that

  17. #217
    Forum Contributor
    Join Date
    11-13-2022
    Location
    usa
    MS-Off Ver
    plus 2021
    Posts
    1,853

    Re: Help with Total bankroll Balances in different sheets an all DOn SNg stats

    okay thank you FDibbins i will open
    with new question.

+ Reply to Thread
Page 2 of 2 FirstFirst 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] help with Bankroll stats from different sheets to be calculated
    By west123 in forum Excel General
    Replies: 739
    Last Post: 01-27-2024, 04:21 PM
  2. Replies: 129
    Last Post: 11-15-2023, 01:34 PM
  3. Replies: 99
    Last Post: 07-30-2023, 12:08 PM
  4. [SOLVED] Calculate summary data for Tournaments categories w/ total bankroll
    By west123 in forum Excel General
    Replies: 138
    Last Post: 07-06-2023, 01:23 PM
  5. [SOLVED] Create list for sheets based on balances in last row
    By abdo M in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-15-2023, 10:21 AM
  6. Want Split Alpha Numerials and then compare the balances from 2 sheets using macro
    By aravindkm in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 04-06-2015, 11:51 PM
  7. Replies: 2
    Last Post: 07-19-2012, 11:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1