LinkBack URL
About LinkBacks
Hi, in this google workbook i have amounts correct. from columns AA & AB
https://docs.google.com/spreadsheets...it?usp=sharing
but in 5-17-2024 pokerstake things changed as it shows
0.575% in column AA
$0.12 in column AB
Hi, in this google workbook i have amounts correct. from columns AA & AB
https://docs.google.com/spreadsheets...it?usp=sharing
but in 5-17-2024 pokerstake things changed as it shows
0.575% in column AA
$0.12 in column AB
In the Excel file, the value in Sem straight X Y7 is 1.15. The value in Z7 is 0.5. The formula in AA7 multiplies those two values together then divides by 100, which results in 0.00575 (0.575%).
In the Google Sheets file, the value in Y7 is 1.15, the value in Z7 is 50. The same formula in AA7 results in 0.575 (57.5%).
The difference between the two files appears to be the value in Z7. From there, I'm not sure what you want to do with the difference.
Originally Posted by shg
hi MrShorty,
I would like the pokerstake file Sem Straight X to calculate the same as google sheet. what do i need to do to make the adjustment?
thank you MrShorty
was able to make the change. can you help with column AC for comission to calculate the same as daily Poker sessions sheet in pokerstake file.
In both sheets, the commission column contains the formula =#N/A. That's probably about as much help as I can be, since I cannot see how you intend to calculate these commissions.
What difficulties do you anticipate in these formulas? In my experience, commissions are usually a simple percentage of another value, so the formula is usually a simple multiplication formula.
did you see daily poker sessions in 5-13-2024 pokersstake file.
should be calculated percentage sold * buy-in and total cost+fee which is the commison $1.62
in Sem straight X i have formula =W7*Z7-AB7 but not sure why shows $1,067.58
in daily poker sessions sheet formula =((J10*I10)-L10)*-1 shows $1.62
may be simple formula or math, but i am horrible with numbers or math. which i wouln't know how to solved it myself.
Last edited by west123; 05-17-2024 at 07:56 PM.
As Mr. Shorty pointed out the issues are with Investor share and Investor % purchased.
Investor share should be 50% not 50.
Investor % purchased should have the formula: =Y7*Z7
The commission formula should be: =-(W7*Z7-AB7)
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
https://www.excelforum.com/excel-gen...ml#post5950980
would be marking thread as solved
thank you
JeteMc, MrShorty
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
not nowwwwwwwwwwwwwwwwwwwwwwww ohhhhh nooooooooooo Ty. you do too have a blessed day anywhere you go. stay safe ill keep working on things.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks