Betting Records

[kompressaur]

I'm still looing at the best way for us to do this. Ive got one or two ideas and also one or two things we can try. In PLUGINS activate the SPREADSHEET FOR WORDPRESS plugin. Now go WRITE and you'll see wpspreadsheets option. Now im stuck as i havent used spreadsheets for years. If someone could lok at developing a spreadsheet in there it would be interesting to see what it can do. It's just basic. After youve created a spread sheet you'll see it will be numbered 1 at the bottom. Now go to your Betting record PAGE or to you blog POSTS and write a page or a post and include this to show your spreadsheet-

To embed a spreadsheet in a post, you simply type {spreadsheet id=x display=interactive} in your post, where x is replaced by the number of the spreadsheet you want to embed. Alternately you can use display=plain or display=table to present the spreadsheet data with limited or no interactivity–and if you omit the display variable entirely, WordPress Spreadsheet will display the spreadsheet with limited interactivity.

ive got 3 examples here-
http://kompressaur.thedailypunt.com/sites/betting/

Right ive got another option now where we can upload excel docs to display in posts but that sounds a buit too manual to me. My other option is a company that does online speadsheet and if i can get them embedded and incorporated into this then that could work best. If the spreadsheets aint too basic in the first one then that really could do us for now and be the first step towards us getting it totally auttomated.

[kompressaur]

I'll leave this to you but here's some more info that could help-

To create a new spreadsheet, go to the Write menu while logged into the WordPress administrator account. Choose the “wpSpreadSheet” submenu. You can save this spreadsheet as a new ID # by changing the ID # field at the bottom. Be sure you don’t choose an ID # that is already used, or you will overwrite your old spreadsheet with no warning! You can then embed the spreadsheet into a post as above. This page also provides you with a convenient place to edit any previously exisitng spreadsheet, even if that spreadsheed has only limited interactivity within the post.

You can now set autolocking columns and rows from the “wpSpreadSheet” submenu under the Options menu from the WordPress admin panel. Be aware that applying autolocking to ‘all’ spreadsheet id #’s is very powerful. Autolocking is always turned off from the editing SpreadSheet page described above. From the Options panel, you can also choose a new default id # to select which spreadsheet which is first loaded into the editing SpreadSheet page. Be sure to pick an id # to a spreadsheet that already exists.

Individual cells may be locked (or ‘protected’) by pressing ctrl-L with a cell selected (but not being edited); pressing ctrl-L again will unlock the cell. Locked cells save when the spreadsheet saves (if the spreadsheet is interactive ). However, pressing ctrl-L does not unlock autolocked cells–that may only be done from the admin Options panel.

You can resize columns or rows by using the mouse to grab and drag the edge of a column or row seperator in the column or row bar. There are toolbar buttons to add more columns at the right and rows at the bottom, and to format your text.

You can copy and paste data by selecting a range using the mouse. You can use the clipboard to import or export data between wpSS and other spreadsheet programs.

There’s a cheat sheet that lists all the available formula functions. Tip: Be sure to use the FIXED() function for more easily readable numbers. The “0.00″ toolbar button formats irrational numbers nicely by limiting the display to only 2 decimal places unsing the FIXED function.

Function List here
http://timrohrer.com/blog/?page_id=80



If anyone could make somewthing that resembles a betting record keeper then that would be much appreciated. I still dont know if this is the way to go

[kompressaur]

l;ooking at it you can keep a record backend and then when it saves it updates the plain table frontend. You might have to edit and then post the page again. Looks like a few possibilities with this. Lots we could improve on

[kompressaur]

that works well i have to say. It lets you just add fro the back end (change the number bottom left to start another - dont forget to save your previos spread sheet. View output here-
http://kompressaur.thedailypunt.com/...-record-final/

So now im hoping presuming that you spread sheet fellas will be able to work it out so as it works out the bet returns automatically and also gkeeps a running total automatically

[kompressaur]

also need to have it so as ytour latest selections are at the top i would say.

[kompressaur]

Another option would be for us to use this service
http://www.thinkfreedocs.com/docs/vi...17&b=0&t=0&l=1

I cant really make it out but ive a feeling it could be more than ideal. They offer a Wordpress pluing to add the spreadsheets to a post. From what i can make out you can use this online to make your EXCEL spreadsheet and then display your spreadsheet/nbetting record in your page or post. If the first one doesnt have enough functionality then i think we would have to look at it.

[kompressaur]

Right it looks like the only way to dispaly your spreadsheet is in table mode (ie no interaction front end) I was able to edit Chief's record when it was placed in 'interactive' mode. Not a problem though and probably best. All you do is update your record back en and it automatically appears front end. To make it appear in a page or a post use-

PHP Code:

{spreadsheet id=x display=table} 


where x is your spreadsheet number (1 if you just have one)

Right no takers on showing us a few formulas for the spreadsheet?

[kompressaur]

when using more than one spreadsheet just change the SS ID#: to whatever number and reload. dont forget to save your other spreadhseet beforehand. If you want to make a new one just change the number and then save.

[kompressaur]

we could maybe do a huge interactive one for TDP and let folks just add their picks to it and we can see how well we do. Im sure that we could do something with the data that is entered into it to reproduce something else. Maybe it could morph into be ing a tipping competition. i dunno it just seems interesting.

[kompressaur]

There's also some options for it in OPTIONS>>>wpSpreadSheets About auto locking etc. Proobably something important to note for the future. I can add coloums and rows but i cant seem to take them away.

[Bigkegman]

I'll have a look later tonight komp

[kompressaur]

Good man Kegman. I think if it can do the simplest of maths functions it could actually do the job. Nice and easy to update in your admin and if its all calculating it for folks then it makes it all nice and easy. Looks good too. If i see some cnut offering 10/10 bet potential i want to see how well he's been doing in whatever event and a link to his Betting Record would be ideal. Maybe we should 'sell' these blogs/betting differantly. See how you get on with it kegman. I suppose all it is is having an online place for folks to enter their selections with ease through an interface of sorts. folks like that. stand up and be counted folks.

[Chief77]

How do you save your picks in the spreadsheet?

[kompressaur]

Easy Chief . Its so easy that it seems hard.

WRITE>>>>wpspreadsheets

edit an add to it and then hit SAVE SPREADSHEET bottom left. Make sure you have the spreadsheet on a page or post by using

PHP Code:

{spreadsheet id=1 display=table} 


where the number (1) correspons with your spreadsheet number.

[Mike TV]

Chief your username is now Crowie as i used test for his PM sent