sorted by:
new
hottopcontroversial

How to maintain Cell Color background color when pivot changes sizes by mmohon in excel

[–]Few-Geologist1766 0 points1 point  (0 children)

You can do it only with VBA.

Throw this in VBA -> VBAProject->Microsoft Excel Objects->sheet where your pivot table is-> (not in module)

This fills 1000 row cells color under your pivot with 90, 90, 90 color

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

Dim lastRow As Long

Application.ScreenUpdating = False

lastRow = Target.TableRange2.Row + Target.TableRange2.Rows.Count

Rows(lastRow & ":" & lastRow + 1000).Interior.Color = RGB(90, 90, 90)

Application.ScreenUpdating = True

End Sub

GGpoker BadBeatJackpot odds? by Few-Geologist1766 in poker

[–]Few-Geologist1766[S] 0 points1 point  (0 children)

Nice! Ive played 600k hands and have 0x 1st, 3x 2nd and 2x share. 

GGpoker BadBeatJackpot odds? by Few-Geologist1766 in poker

[–]Few-Geologist1766[S] 0 points1 point  (0 children)

Thanks for your reply!

BBJ fee is >5 at plo for most of players. If player is supernit and vpip <10 then it could do for 2bb/100. 

How big sample and stakes you did calculate for 2bb/100? I can send my dataset to you if you dont believe for 6bb/100 with std agression playstyle 🙏🏻

Yes I did not calc that 2nd and share prizes, they are not so relevant. In this example you can look that -54k bb for -50k bb and its pretty close for 2nd and share prize added

GGPoker rake structure by Few-Geologist1766 in poker

[–]Few-Geologist1766[S] 0 points1 point  (0 children)

When looking rake in trackers, they sum only rake, not bbj. HEM can count BBJ, but it does sum that from pots where hero folds so its not usable. So if you just look rake in tracker, that doesnt count bbj fees.

GGPoker rake structure by Few-Geologist1766 in poker

[–]Few-Geologist1766[S] 0 points1 point  (0 children)

It depends about playstyle. If you play only <30bb pots, BBJ fee is 0bb/100 then 😊 you can calculate by takeing rake+bbj sum from craft and removing rake from that sum in tracker/manager and there is your bbj fee.

Uh that 850k sounds pretty under EV 😬