Spreadsheet Betting Formulas - Betting Forum

**kompressaur** · #1 (**permalink**) 12-10-2007, 05:12

Hello im looking for a buit of help here
http://www.thedailypunt.com/forum/sh...wpost&t=106103

Ive set it up so as folks have a spreadsheet in their blog admin and when they update it it appears on the front page of their blog for eeryone to see. Thing is i dont know how to set it up so as it auto works things out etc. can anyone with a bit of knowledge pop by and maybe assist me as it would be nice to see if this should work for us or not.

thanks

**kompressaur** · #2 (**permalink**) 12-10-2007, 05:13

I was wanting maybe for it to auto work out profit and loss and maybe even show a bit of yield. Would that be possible? Aslo any other things that ytou think would fit on there well then let me know.

brimson · #3 (**permalink**) 12-10-2007, 11:36

I'll have a look komp.

Hope you are well. I am shit. Good luck for your boys tomorrow.

**kompressaur** · #4 (**permalink**) 12-10-2007, 12:26

Thanks Broms. are you shit in a health way broms or just in general? I don't know if im well or not as i dont know what being well is. I know i could be a lot worse off so i suppose i must be well. bloody hell. fcuk i can go and make a coffee in my nice clean house and maybe lie on my clean duveted bed (with 2 dirty pillows in a clean case) and watch a Colombo film whilst drifting off to sleep. I could wake up and have a few ciders whilst playing poker and enjoy the break from a saturda coupon. I could then go out later and maybe get my first ride in a year. aye i suppose i am well bromsgrove. It could all go wrong if i rock the boat though so thats why i prefer to stay in and stress out on here

Aye i'd love to see some spreadie experts getting their teeth into this one for me. Check out the TDP BLOG REQUEST thread bromsgrove im just gonna start. actually nope im away to make you all memebers

(youll need to be to help with this spreadsheet)

thehandicapman · #5 (**permalink**) 13-10-2007, 00:06

I might be able to help, spent a few years pissing about on excel. Give me a shout if you need me

**kompressaur** · #6 (**permalink**) 13-10-2007, 03:14

Well due to the lack of response THM i think we need you. I'll set you up a TDP site later tonight THM and you can have a look in the backend admin. truth be told i was looking at using excel for this when i posted but then i found something new to add to the TDP Sites admin menu to make life easier for folks. Im hoping that that can still do a job for us.

Does this look likely anyone?
http://timrohrer.com/blog/?page_id=80

**kompressaur** · #7 (**permalink**) 13-10-2007, 03:16

looking at it now i suppose it can work out the totals with SUM, it can work out hte average odds vbacked with Average, bah and that look about it

Can't it work out yield?

**kompressaur** · #8 (**permalink**) 13-10-2007, 04:26

i forgot there's a admin demo here if anyone wants to try making it better
http://kompressaur.thedailypunt.com/sites/betting/

just save it when your done

Computer Guy · #9 (**permalink**) 13-10-2007, 09:44

Yield added

**kompressaur** · #10 (**permalink**) 13-10-2007, 10:32

Top man CG

How does it all work? I mean does it all work as it could in Excel CG? I'll need to look at way of getting around the width problem. I'll make you up a computerguy blog for ease sakes CG by way of appreciation. I'll Mike tV pm u later. Ive a feeling i wont have the net at work tonight so i might be limited in my net time. You think this 'works' CG and will folks like it?

Computer Guy · #11 (**permalink**) 13-10-2007, 10:38

I use Microsoft Works for all mine but doubt that any formulaes would need changing much for Excel.

It works, but guess its down to individual users tastes as to wether its useful or not.

**kompressaur** · #12 (**permalink**) 13-10-2007, 11:28

Excellent CG. So in effect it could do any function that would be in the most intricate of Betting Record spreadsheets? has anyone any thoughts on how it should look and function best? I'm just giving folks that want to keep a record be it publicly or privately CG. I think it could work for those that like to keep records of their betting and arent afraid to stand up and be counted too. Nice and easy to admin in the back end too. Oh is there any way to have new entries be added at the top? Or do the coloums sort by date. I suppose we need a date coloum to sort by.

Computer Guy · #13 (**permalink**) 13-10-2007, 11:39

only had a quick look at the things it can do but i cant find any 'sort columns' feature although it may be there somewhere.

**kompressaur** · #14 (**permalink**) 13-10-2007, 12:32

Cheers CG. I can't even see how to remove fields. I suppose i will be able to in the files themself. Is there anyway CG/anyone that we can make it so as when you enter your price and stake it automatically tells you your returns. If a cell/coloum has a W in it then let the amount stand and if it has a L in it then maybe it takes away your stake from your total bank. Or would that be a bit too complicated for a spreadsheet

(image im wrong and its all a piece of piss a s spreadsheets are really great really)

**kompressaur** · #15 (**permalink**) 13-10-2007, 12:39

oh aye that looks nice. That you CG?

I got out of bed with a big grin on my face after seeing that. Very nice. I like it. I like it a lot.

New To Site?	Need Help?
Register to Participate Contact Us	Frequently Asked Questions Did you forget your password? Mark Forums Read

Powered by vBulletin® Version 3.7.1 Copyright ©2000 - 2008, Jelsoft Enterprises Ltd. vB.Sponsors The Daily Punt Search Engine Friendly URLs by vBSEO 3.2.0 RC7	style developed by HoxxyByDesign