# Excel Spread sheet for HU SNGS

• Bronze
Joined: 30.08.2010
Hey community, does anyone know how one would go about creating a HU SNG spread sheet (Roi, Ev etc.) in Excel?

Thanks!
• 2 replies
• Super Moderator
Super Moderator
Joined: 02.09.2010
Hi,
I put moved this to the Beginner's Question board.

It is a really tough question to answer without a lot more detail about what you want.

I suggest googling to see if you can find ones others have done, and modify to suit your own taste.

--VS
• Bronze
Joined: 25.09.2008
Pretty sure you'll find some if you google, but it's easy to make a simple one to keep track of profit and RoI

So for a 1.50 game where winning is +1.38 and losing is -1.50

Put these headings in A1 - F1: Games, Stake, Won, Lost, Profit, ROI

Then :
A2 type in the number of games you've played
B2 type in the stake
C2 type in the number of games you've won
D2 type =(A2-C2)
E2 type =(C2*1.38)-(D2*1.5)
F2 type =(E2/(B2*A2)*100)

Depending on the stake and rake you're paying change the numbers to suit and there ya go, simple way to keep track of your results.