[jolmscheid]

Hey guys...im looking for a spreadsheet that is easy to use and calculates a running bankroll...I know sbr has a good one but I prefer to have my stats offline in excel format...I would appreciate anyone willing to lend some help..

[jolmscheid]

If I was at all computer savvy I could do it on my own, but obviously im not too good with excel since im asking for some help...ha...thanks guys..

[jolmscheid]

Bump...

[TCU]

Here's a link to one I use, hope it's the sort of thing you're looking for

http://www.aussportsbetting.com/tool...cel-worksheet/

[jolmscheid]

Thanks TCU...I will take a look at it...

[Hereindallas]

All the pages are protected and need a password to unprotect. Do you have the password?

[shari91]

This is the one I use. Durito showed me it a couple of years ago; it's from TomG at 2+2.

There are instructions that go along with it so if anyone is interested let me know and I'll pass them along. It's definitely helped me out a ton though, especially when I was betting a lot more.

http://www.sendspace.com/file/ygu24d

[jjgold]

Which check link out and see if any good

[70kgman]

This is the one I use. Durito showed me it a couple of years ago; it's from TomG at 2+2.

There are instructions that go along with it so if anyone is interested let me know and I'll pass them along. It's definitely helped me out a ton though, especially when I was betting a lot more.

http://www.sendspace.com/file/ygu24d

Do you know how if there is a way to quickly change the date range for the entire spreadsheet including the graphs and all?

[jjgold]

well lets say go to the summary sheet
then the first date box click it and then with your mouse go to bottom right edge of box and wait until you see a + sign and then click and hold drag them all down and you will see dates changing

[Sam Odom]

[shari91]

Do you know how if there is a way to quickly change the date range for the entire spreadsheet including the graphs and all?

All of your info will go into the Details sheet and that's where all of the calculations and graphs are performed from. Manually enter the first 2 or 3 dates you want to start with ie 10/5/12, 10/6/12, 10/7/12.

Highlight those 3 boxes with your mouse and then go the bottom right corner like JJ suggested to grab the cross. Left click and scroll down as far as you want... the dates will auto populate sequentially until you stop. But unless you're only going to make one wager a day, this won't be of much use to you as you'll still have to go into change it manually.

[shari91]

Here are Tom's instructions from 2010 (he usually makes an updated spreadsheet each year so I posted the 2012 version):

The 'Details' tab is where all the data entry is performed. Enter each wager's information in columns A:K and O:Q. Try to use consistent naming conventions for stuff like "Sportsbook" (e.g., always use either TheGreek or Greek), "Wager Type" and "Bet Type" as those fields power the 'Analytics' tab.

When each game is finished, grade the results in the "Results" column by entering either WIN, LOSS, or PUSH. Next, click on the 'Pivots' tab. Right click any of the pivot tables and Refresh. The 'Summary' and 'Analytics' tabs will auto-populate with the results. For the most part you don't need to change anything on either of the 'Summary' or 'Analytics' tabs. The exception is if you make no wagers on a certain day (???). Then you need to manually enter 0's for that day on 'Summary' tab in columns B:I.

Each month, the monthly graphs need to be manually updated. Right click the graph and select new data using the same conventions as the previous month.

[shari91]

And this was the last post I've seen him make about it...

oh looks like on the summary tab you need to fix the empty cells. copy and paste the formulas in cells B185:E185 for example and paste those formulas in all the cells above and it will work

[HoulihansTX]

Bookmarking this thread. We are working on this in my class.

[baskets]

so funny. guy says he makes 10-15 wagers a day, then says he makes hundreds of wagers a day ... whatever is +EV. guy says he doesn't use excel b/c it's too much effort, then provides a spreadsheet. says he makes 20 - 30k /month gambling .... yet has no money in Pinnacle... and on and on.

as Andywend said, 'he is one sick fukk of a human being' .... but I would like to know about the accuracy of his pro gambling claims

[szk1983]

I'm sure there must be something out there, but I have no clue what it is! Sorry!

[shari91]

so funny. guy says he makes 10-15 wagers a day, then says he makes hundreds of wagers a day ... whatever is +EV. guy says he doesn't use excel b/c it's too much effort, then provides a spreadsheet. says he makes 20 - 30k /month gambling .... yet has no money in Pinnacle... and on and on.

as Andywend said, 'he is one sick fukk of a human being' .... but I would like to know about the accuracy of his pro gambling claims

It's not his spreadsheet although I'd assume he used it at least at some point. I had asked for help with this ages ago and he pointed me towards TomG's spreadsheet. SBR spreadsheet is great too but I wanted something a bit more advanced. Thankfully Tom is generous enough to share an updated version each year.

[jjgold]

Its not good

I deleted it already.........way too much manual input

[shari91]

Its not good

I deleted it already.........way too much manual input

Where is there a spreadsheet that you don't have to input your bets and the result??? That's all you have to do here. One page: Details.

Definitely not at SBR. The only difference with Tom's is that you need to be consistent with how you input the book name as it actually means something on his sheet whereas at SBR's you can skip it. Nowhere else offers this. At least not for free. Maybe someone has figured out a way to link it with auto scoring on everyone's home computer and they're charging for it across every sport? If so, let me know but I'm not aware of it.

Either way Tom's spreadsheet has been a perfect accompaniment for me to SBR's. The OP was asking for options. This spreadsheet is probably the most used - and its updates anticipated - by gamblers every year. Between SBR and TomG I can't see how anyone can screw it up.

[jgilmartin]

Duff posted a link to http://www.betdog.eu not long ago; it's a pretty powerful (free) bet tracking tool. It does a lot of the work for you when entering games.

[daneblazer]

Was googling betting spreadsheets and this popped up. Good stuff

[jayem]

This is the one I use. Durito showed me it a couple of years ago; it's from TomG at 2+2.

There are instructions that go along with it so if anyone is interested let me know and I'll pass them along. It's definitely helped me out a ton though, especially when I was betting a lot more.

http://www.sendspace.com/file/ygu24d

planning to use this for a world cup bankroll, is there another instructions besides those you posted on the forum?

[phinfan27615]

These aren't working for me, is there an updated version? When I try to open the file it says I don't have a program that can open it

[jjgold]

I use SBR

But for custom stuff here you go

http://www.aussportsbetting.com/tool...cel-worksheet/

[phinfan27615]

I use SBR

But for custom stuff here you go

http://www.aussportsbetting.com/tool...cel-worksheet/

How do you use sbr?

[gauchojake]

Where is baskets????

[jjgold]

http://phinfan27615.mysbrforum.com/spreadsheet/

[Slipknot26]

I've used Google sheets for awhile. Basically excel , send links and people can get updates , etc.
Excellent way to track and share also

[phinfan27615]

http://phinfan27615.mysbrforum.com/spreadsheet/

So it doesn't automatically track previous picks? I would need to start putting mine in for the future?

[jjgold]

Have To Start new

[phinfan27615]

Have To Start new

Awesome well im starting today, kinda nice no one will see all my losers from the past couple of months lol. Im using money on the sheet but really its sbr betpoints

[magaman]

Hey guys...im looking for a spreadsheet that is easy to use and calculates a running bankroll...I know sbr has a good one but I prefer to have my stats offline in excel format...I would appreciate anyone willing to lend some help..

Make your own excel spreadsheet... you can do anything you want. It's pretty simple

[HurryUpAndDrink]

Im pissed... spent like 2 hrs trying and using new spreadsheets and was not able to find or set one to American sports

FUKK that decimal shit

[jjgold]