Excel Help

[supa]

I recently started using excel at work and haven't had any experience with it (or any other data entry programs) before. What I use it for for at work is very simple but I'm interested in learning it better.

What I'm trying to do now is create a formula I can use for sit n go's. I taught myself how to input the formula but creating one is starting to make my head spin. I guess the question is more math related.

What I'm looking for is: stake, games played, game won, games lost, profit and ROI. Whatever's easiest but something I can play around with to try and learn some more.

Thanks in advance for the help.

[celtic123]

stake, games played, game won, games lost, profit and ROI.

use them as titles ^^

Job done

[MadMojoMonkey]

umm...

What data have you collected (or do you plan to collect)?

Generally, it's a good idea to put data in columns, with a title at the top.

For formulas that track with the data, you'll want a column for those as well.

For formulas that are summaries, leave room at the top of the sheet, or off to the side of the data.

If you plan to make graphs, it's easiest if you make your left-most column of data the info you want for your x-axis... easiest, but by no means necessary.

[Pascal]

What kind of SNGs are they - heads up?

For your ones you could do:

Games played - column of numbers increasing by 1 each time
Game won - in each row you enter if you won that game (Yes or No)
Stake - you enter the stake (you could have a table containing rake amounts and have a function to automatically subtract rake)
Profit - + or - the stake after rake depending on won or lost
ROI - return on investment is profit (sum all profit) times total staked (games played * stake of each)

[supa]

What kind of SNGs are they - heads up?

For your ones you could do:

Games played - column of numbers increasing by 1 each time
Game won - in each row you enter if you won that game (Yes or No)
Stake - you enter the stake (you could have a table containing rake amounts and have a function to automatically subtract rake)
Profit - + or - the stake after rake depending on won or lost
ROI - return on investment is profit (sum all profit) times total staked (games played * stake of each)

Double or nothings (6max) right now but I might change that up at some point so I want to make it versatile.

Anyway, I'm not sure I'm asking the right question so here's what I've figured out. If I Type the stake in A1 and then my winnings in B1 and then the formula =B1/A1 in C1 I get my ROI unconverted to % and then I know how to do that. What I'm looking to do is come up with a formula that allows me to do everything I said in the OP and then change just 1 value (or more, whatever) and have them all update automatically.

It's probably a pretty long formula and really I'm just looking to learn this stuff so I'll keep working on it and see what happens.

[supa]

Also, trying to make it so whichever column I make ROI I can make that column the same all the way down for different stakes so C=B/A whether it C1, C2, C3...

[The Bean Counter]

Hover mouse over bottom right corner of cell with formula in it and click and drag down to copy and paste the formula. Would also have column c as profit and d as roi (that's what I have anyway, but I do one line for each sng and also include date, site, time, etc).

Also recommend looking into pivot tables-they're excellent for quickly tabulating any data you may want to drill into.

Sorry for short reply as on phone and half asleep.

[supa]

Thanks Bean, that helped.

I pretty much figured it out.

If A1, B1, C1, D1, E1 is
Stake, Games Won, Games Lost, $Won, ROI then
D1 is =A2*B2-A2*C2 and E1 is +D2/A2

Easy game.

*edit* what this doesn't do is allow me to put in total winnings without subtracting the buy-in. Back to work.

*edit2* this also doesn't account for rake

[Pascal]

More than one stake or just one stake?

[NightGizmo]

Supa -- it's easiest if you keep each row as a separate game, and don't try to keep a rolling total in each row. Instead, put a row at the bottom that adds up all of your single-game totals. (This is a pretty common way of tracking data in Excel).

Example (column headers starting from A1):
Buy-in, Rake, Gross $Won, Net $Won, ROI, Win?

Values (actual data starts in A2):
Buy-in, Rake, Gross $Won: enter the actual values
Net $Won: =C2-B2-A2
ROI: =D2/A2
Win? =IF(C2>0, 1, 0)

Then, if you want a summary row, you can just auto-sum for most of the columns (except ROI -- you'd use the same formula in the other rows). Auto-sum is the sigma button -- select the cell where you want the auto-sum to go, press the sigma button, then select the cells you want to add up and press enter.

[supa]

Thanks guys. Think I got it.

[kiwiMark]

You can make the cells have pretty colours!

[WillburForce]

You can make the cells have pretty colours!

You're wasted here. Get yourself a job at Microsoft!!!!

[kiwiMark]

I could be that paperclip.

[kiwiMark]

Hi! It looks like you're trying to use Excel to solve a simultaneous equation...would you like some help picking a nicer font?

[bode]

back when i still played poker there were many free excel spreadsheets that do exactly what you want and more floating around. Check on 2p2 maybe. Unless you just want the challenge of creating one from scratch.

[DoubleJ]

Net $Won: =C2-B2-A2

[Nitpick]

Net $Won: =C2-(A2+B2) is more elegant

[/Nitpick]

[DoubleJ]

ROI: =D2/A2

Also, you need to include impact of Rake in this formula:

ROI = (Gain from Investment - Cost of Investment)/Cost of Investment

or ROI = D2/(A2+B2)

[NightGizmo]

Also, you need to include impact of Rake in this formula:

ROI = (Gain from Investment - Cost of Investment)/Cost of Investment

or ROI = D2/(A2+B2)

I realized I made a mistake somewhere regarding rake (after I pressed submit), but didn't bother to fix it. Thanks for the clarification.

[DoubleJ]

no worries

[supa]

lol union spreadsheet.

[!Luck]

Learn python and call it GG.

[supa]

Googled python and no idea wtf any of that said.