would like to get help move Cash table from tournament to cash games, and the stats in it.

Hi, I have Cash table in tournament sheet, would like to move it to the Cash games section, right under my Graph., and have all stats along with my Main
bankroll and transactions, work accordingly with my total bankroll, and cash. along with the total running balance.

There is already a table, tbl_CashGames83, under the graph. Do you want to replace it with tbl_CashGames8?

Filled in the gray cells except for those in the BB/100 column as I don't know what that means.
Profit: =[@Result]-([@[Buy-in]]*([@Rebuys]+1))
Length: =[@End]-MOD([@[Date Time]],1)
ROI: =[@Profit]/([@[Buy-in]]*([@Rebuys]+1))
$/Hr: =[@Profit]/([@Length]*24)
Balance: =SUM(W42,[@Profit])

Thank you mate, it means Big blinds won per 100 games. If you can se Cash Profit by stake in cash games column B12
the blinds are 01-02 1 is the small blind and .02 is the big blind. thats the blinds small and big
.01-.02
.02-.04
.05-.10
.10-.20
.10-.25
.25-.50

Mate, what would be the best way to link the bankroll from bankrool to the cash. Its because when I play cash from ACR is the total bankroll money its not separate so when i jump in a cash table it grabs the money from the total balance and if in or loose its from the total in the bankroll

the stats are pretty much from this workbook, maybe you want to take a look it be easier to write the formulas.
https://docs.google.com/spreadsheets...998/edit#gid=0

maybe is helpfull

Attempting to open the link in post #6 gets me to a page with a tab header "Access Denied".

The formula being shown for BB/100 is: =(((J12/D12)/G12) * 100)/2
Where J12 is the profit, D12 is the big blind and G12 is the number of hands.
The problem is that in the Tournaments in Pivot table 5-13-23 (west123).xlsb‎ file there is no column for big blind in row 42 on the Cash Games sheet.
You need to add a column for big blind before we can put a formula in cells V43:V44

thank you mate, I will paste thats fine whatever need to be added to make it work your the Master, were you able to see the workbook in post #8 maybe that would help. will download

do i paste that in cell V43?

"were you able to see the workbook in post #8..." >> Yes, I got the formula =(((J12/D12)/G12) * 100)/2 from cell N12 on the Sessions sheet of the Version: 1.3 workbook
"do i paste that in cell V43?" >> No, that formula will not work in your workbook. In order to write a formula for your workbook, you need to add a column in tbl_CashGames83 for big blind

okay, mate will add and upload ty
mate but BB/100 that one wont work?
the one there. Okay mate I added the column BB

The formula for the BB/100 column is: =((([@Profit]/[@BB])/[@['#Hands]])*100)/2
At the moment it displays #DIV/0! because there are no values in either the BB or #Hands columns.

okay thank you mate, let me download
Mate, is the column I added BB needed? don't see a formula in ?

If you want to calculate the value of BB/100 then it is needed.
Look at the CG Bankroll Challenge Template v 1.3 file. There is a Big Blind column (D) for which each row has to be manually filled so that the calculation in the BB/100 column (N) can be made.
If you don't need to know BB/100 then you could delete both columns.

Updated the formulas in cell D4:E8 to include the profit from tbl_CashGames83

thank you, mate, will see changes cheers

Mate, which section would be next? mate if you have questions please feel free to ask me.

The section with which you are in the most need.
Question: Have you tested the Cash Games and Total Deposit & Balances sections to make sure they are working properly?

Mate, I am in need for all, thats why I ask you which is easier to acomplish all lets figure out the bankroll and total, or you want to start elwhere? I will test all now.
thank you
Mate, I don't see the Time calculating Length. Do you want me to upload

I move Big to the left before the Start time.

All of the formulas that I had put in when I made post #4 had been changed to static values.
I have put them in again.
Also corrected the formulas in the Cash Profit by Site section, the table is tbl_CashGames83 and not tbl_CashGames8.

Thank you, mate. Okay will see changes. ty
Mate, which section would be next? do we need to figure out the Total Balance to be link to cash to move forward with the Current Stakes buyins?

I assume that you mean Total Bankroll in cell D1.
If so then it seems it should be: =Info!Y3
If not then please explain how it would be manually calculated.

The Balance column is now populated using: =SUM(U1,[@Profit],[@Deposit],IF(ROW()-1=MAX(ROWS([Network])),tbl_CashGames83[Profit],0))
Note that this adds the total of the profit from the cash games sheet to the last row of tbl_Tournaments.

Does post #28 mean to combine tbl_CashGames83 and tbl_Tournaments?
If you do include the records from tbl_CashGames83 into tbl_Tournaments then please keep the name of the table as tbl_Tournaments otherwise all of the formulas on the Bankroll sheet will need to be rewritten which will take a considerable amount of time. Even so the formulas on the Cash Games sheet will need to be rewritten.
I don't know what posts #29:30 mean.
How would current stakes relate to total bankroll (Bankroll sheet) which is actually in cells N1:Q1 (merged)?
I can see that on the Cash Games sheet cell W42 displays 15.43 and cell W43 displays 24.77, but I don't see a cash table so I dont know which would be better to have.

Mate, yes regarding post#28 I mean if there was a better way, than having to add the cash to tournament running balance. I ask if combining it or any other way around it. NO way Mate, I don't want to do that, would put lots of more time to finished. Its fine to have the way it is separate into 2 tables. then having you to write all formulas no no. we leave it the way it is.
Okay about post# 29 if you go to the copy of GG Bankroll Challenge V 1.3 in google sheets. and you type $100 in column I15 the bankroll will be 118.39 and the current stake will now load to $0.02/$0.05 and if change it to 200 then it would load to $0.05/$0.10
base on the worksheet. Also please type 50 in line N8 so you can see that funcion as well. about w42 shouldn't it be the bankroll total there ? just the way it generates in the CG Bankroll challenge template V 1.3

http://blog.microrollers.com/

link to the workbook http://blog.microrollers.com/2010/03...anagement.html

In the copy of GG Bankroll Challenge V 1.3:
Current Stakes has the formula: =getCurrentStakesText(D1). I don't know of a corresponding formula in Excel.
Have to Leave Table has the formula: =checkChipsInPlay(D1,N8,'Bankroll Rules'!B5) and again I don't know of a corresponding formula in Excel.
You might ask about the above in a separate thread in the For Other Platforms(Mac, Google Docs, Mobile OS etc) forum.
I am guessing that you intend to put the dates for the cash sheet in descending order. If so then the formula for Bankroll could be: =SUM(W44,[@Profit])

I don't know what @getCurrentStakesText does to the amount in cell D1.
That is why I suggested posting the question in the For Other Platforms(Mac, Google Docs, Mobile OS etc) forum.
I think that I have translated the formula found in cell D1 into an Excel formula that works for your setup.
The formula is in cell Y3 of the Info sheet: =SUM(SUM(tbl_Tournaments[Profit]),SUM(tbl_CashGames83[Profit]),SUM(tbl_AllTransacations[Amount]))

I see a table on the Worksheet sheet that seems to have something to do with the current stakes cell, but not sure if/how it is used.

This is about as much of the Cash Games sheet as I can complete without knowing more about what each section should display.
Note that I added the "Worksheet" data from the CG Bankroll Challenge V 1.3 into columns AF:AO on the Info sheet.
Note that I also added some of the Bankroll rules into X11:Z13 on the Info sheet.

Mate, the Cash Profit By Stake columns B:E
would be base on the stake I played, hours and profit/hour
Cash game by number of tables
would be a breakdown of how many tables i played ROI hours and how many sessions.

It seems to me that there would have to be a column for Stake played in tbl_CashGames83 in order to have data to use to fill columns C:E. I feel that it would be wise to avoid making changes to the setup of that page until after 6StringJazzer responds with a code for filling cells O1:P1. I believe that it would be alright to rename a column in the tbl_CashGames83 but I would not recommend adding columns or merging cells.

May not have stated my previous post very well. I suggest renaming one of the columns (i.e. the ID column) in tbl_CashGames83 "Stake" and put some sample data in that column.
BTW, I am getting ready to be away from my computer for a week or more.

I don't see an instance where ID is needed for calculations of any of the sections of the Cash Games sheet so I put Stake in that column.
The formula for Profit (column C) is: =SUMIFS(tbl_CashGames83[Profit],tbl_CashGames83[Stake],B13)
The formula for Hours is: =SUMIFS(tbl_CashGames83[Length],tbl_CashGames83[Stake],B13)
The formula for Profit/Hour is: =IF(D13=0,0,C13/(D13*24))
Thanks for the well wishes.

Thank you mate, let me see the changes now.

Is that a 2nd option besides using the code?

nice mate thank you, i see pretty much all the stats done now. ty

Mate, I think we need a column for game like a dropdown heads up, 4 heads up, NL and down to Single Table.
the games now would be under NL like that it would show in the cash profit by game. in cells AE:AG row 5

It looks like "Big" isn't needed so I put "Game" in its place.
In the Cash Profit by Game section:
Profit: =SUMIFS(tbl_CashGames83[Profit],tbl_CashGames83[Game],AD3)
Hours: =SUMIFS(tbl_CashGames83[Length],tbl_CashGames83[Game],AD3)
Profit/Hour: =IF(AF3=0,0,AE3/(AF3*24))

It also seems that Tbls Name might be better named Num Tbls.
In the Cash Game by Number of Tables section:
ROI: =IFERROR(SUMIFS(tbl_CashGames83[Profit],tbl_CashGames83[Num Tbls],Y13)/SUMPRODUCT((tbl_CashGames83[Num Tbls]=Y13)*(tbl_CashGames83[Buy-in])*(tbl_CashGames83[Rebuys]+1)),"")
Hours: =SUMIFS(tbl_CashGames83[Length],tbl_CashGames83[Num Tbls],Y13)
Sessions: =COUNTIFS(tbl_CashGames83[Num Tbls],Y13)

Thank You. Hope that you have had a good week.

File without macros or buttons.