Stanford-SDSU predictions -- FORM UP

Stanford-SDSU predictions -- FORM UP - Printable Version

+- The CardBoard (https://thecardboard.org/board)
+-- Forum: C-House! (https://thecardboard.org/board/forum-4.html)
+--- Forum: The CardBoard (https://thecardboard.org/board/forum-5.html)
+--- Thread: Stanford-SDSU predictions -- FORM UP (/thread-16302.html)

Pages: 1 2 3 4

RE: Stanford-SDSU predictions -- FORM UP - BostonCard - 08-29-2018

(08-29-2018, 06:23 PM)martyup Wrote: I don't think the new forum software will accept this formatting.

BC used pivot tables, but I have never learned how to use them. You're never too old to learn new tricks, so I guess I could dig in and learn. I was hoping there was an excel wiz on this board that could knock this out with ease.

Correction, BigEasyCard did the pivot table thing. I just collected and calculated the scores.

BC
As for whether tables work on the new format...

test tablenew field line2line 2 field 2

RE: Stanford-SDSU predictions -- FORM UP - Stymie - 08-30-2018

Robber Barons 34
Emperors 17

Enough to beat the spread but not enough to become overconfident.

Perfect.

RE: Stanford-SDSU predictions -- FORM UP - stupac2 - 08-30-2018

(08-29-2018, 06:23 PM)martyup Wrote:
(08-29-2018, 01:41 PM)stupac2 Wrote:
(08-29-2018, 11:45 AM)martyup Wrote: Can someone who is an expert at creating complex spreadsheets help me with the tabulation sheet?

How is the output of the google form formatted?

It is csv.

Quote:Another issue is how to format the results so they can be posted and read on this board.

Quote:I do that by copy/pasting into notepad++, where everything will be tab-separated. You replace the tabs (via search and replace) with:

Code:
[/td][td] ...

I don't think the new forum software will accept this formatting.

BC used pivot tables, but I have never learned how to use them. You're never too old to learn new tricks, so I guess I could dig in and learn. I was hoping there was an excel wiz on this board that could knock this out with ease.

Column 1	Column 2
Entry 1	Entry 2

Well, looks like you're right. That could be a real pain then. You could use the code tags and somehow buffer with spaces but man that would be a pain. Maybe the solution is to just run it off a google doc.

RE: Stanford-SDSU predictions -- FORM UP - Mick - 08-30-2018

(08-29-2018, 12:49 PM)newguy Wrote: looks like the over-under is 49.

my prediction? bet on the over. we have an average defense and a high-powered offense.

I heard on KNBR last night that Stanford has outperformed the spread 60% of the time over the last 10 seasons.

RE: Stanford-SDSU predictions -- FORM UP - BostonCard - 08-30-2018

(08-30-2018, 08:21 AM)stupac2 Wrote: Well, looks like you're right. That could be a real pain then. You could use the code tags and somehow buffer with spaces but man that would be a pain. Maybe the solution is to just run it off a google doc.

I think the easiest thing would be to announce the winner and link to a protected google doc with the scores. It's a bit of a pain to have to click through to find out how one did, but it is the least painful alternative that I can think of.

After some googling, I found it can be done, but it is a pain:

Name	Stanford Score	Opponent Score	Total Error	Points
Boston Card	27	21	3	10
Mick	27	24	6	9
Stupak	35	18	11	8

Here's the syntax.

Start with the 'table' call and end with a '/table'. For each line start with a 'tr' and end in a '/tr'. Use 'th' and '/th' for the header columns. Use 'td' and '/td' for each cell within a row. It is very similar to the old code, but just enough different that the old code didn't work.

Code:
[table=5]

[tr]

[th]Name[/th]

[th]Stanford Score[/th]

[th]Opponent Score[/th]

[th]Total Error[/th]

[th]Points[/th]

[/tr]

[tr]

[td]Boston Card[/td]

[td]27[/td]

[td]21[/td]

[td]3[/td]

[td]10[/td]

[/tr]

[tr]

[td]Mick[/td]

[td]27[/td]

[td]24[/td]

[td]6[/td]

[td]9[/td]

[/tr]

[tr]

[td]Stupak[/td]

[td]35[/td]

[td]18[/td]

[td]11[/td]

[td]8[/td]

[/tr]

[/table]

RE: Stanford-SDSU predictions -- FORM UP - martyup - 08-30-2018

Thanks BC. That formatting sure looks pretty. Perhaps a script can be created that exports the results data and writes the formatting tags into a text document that can be pasted into a post. This might make this task simple.

A big shout out to shinsengumi for volunteering to help me create the spreadsheet for the game.

CardinalSagehen - CardinalSagehen - 08-30-2018

(08-30-2018, 02:42 PM)martyup Wrote: Thanks BC. That formatting sure looks pretty. Perhaps a script can be created that exports the results data and writes the formatting tags into a text document that can be pasted into a post. This might make this task simple.

Looks good! One simple option is to generate the syntax that BC provided directly in your Google Sheet with the CONCATENATE function. Let's assume BC's sample table exists in columns A through E. You would create a final column F with a formula that concatenates columns A-E as follows:

Code:
=CONCATENATE("[tr]","[td]",A2,"[/td]","[td]",B2,"[/td]","[td]",C2,"[/td]","[td]",D2,"[/td]","[td]",E2,"[/td]","[/tr]")

The tags and header row from BC's example never change, so you'd keep those and simply copy/paste all of Column F just above your

tag.

Hope this helps! I'm sure there are many other ways. All of this said, if this proves to be a pain, I also think it would be reasonable to require interested users to click into a protected Google Sheet for the results.

RE: Stanford-SDSU predictions -- FORM UP - martyup - 08-31-2018

Thanks CSH. That is helpful.

If you have not yet entered the prediction contest, please use the form for your entry. Here it is again:

https://goo.gl/forms/az1fhsI1JH3lhUT93

Good luck everyone.

RE: Stanford-SDSU predictions - JeffInCorvallis - 08-31-2018

Last year's game left me badly scarred. Hoping we come out of the gate stronger this time, but not confident in the offense beyond #20.

Stanford 24
SDSU 21

RE: Stanford-SDSU predictions -- FORM UP - PalmTree - 08-31-2018

My prediction, as I'm guessing our offense for this game will be, is pretty vanilla:

LSJU: 34
SDSU: 24

All I ask is that our D please keep the white-knuckled moments to a bare minimum - as one who's just used his first senior citizen discount, there's only so much excitement I can handle these days...

entered to the Google form

ps GO CARDINAL!

RE: Stanford-SDSU predictions -- FORM UP - BigEasyCard - 08-31-2018

(08-28-2018, 06:39 PM)martyup Wrote: Hey BigEasyCard,

Can you PM me? Your PM inbox is full and not accepting new messages.

Thanks,

Marty

(08-28-2018, 06:24 PM)BostonCard Wrote: One additional thing to consider is what happens when individuals enter their predictions more than once. When I ran it, I always took the last prediction entered (figuring that people could change their mind with updated info), but this is your call.

BC

Good point. I added that rule.

Marty,

Apologies for the delayed response. I have deleted some messages so PM should work now. I can help with pivot tables if that's the way we present results. I like the idea of having a locked Google spreadsheet and just publishing a link instead of dealing with tables and HTML on the board here.

As SnorLax noted, consistency of handle is important. I spent more time each week cleaning up names than I did actually creating the pivot table for BC to publish.

My time is dearer this year but if I can help with a modest time investment, I'm on board.

I can already taste the raw oysters and cold beer at the Blind Pelican in New Orleans tonight.

Cardinal 38
SDSU 21
Entered in form.

Geaux Cardinal!

RE: Stanford-SDSU predictions -- FORM UP - Langdude - 08-31-2018

Stanford 27
SDSU 17

Love with two TDs. Costello struggles a bit in the red zone. Toner is nails.

Entered in form.

-m.

RE: Stanford-SDSU predictions -- FORM UP - CTcard - 08-31-2018

Offense does well, but not quite a juggernaut.
Defense allows significant rushing yards, but doesn't get ripped up.

All together, a win that's reasonably comfortable but leaves plenty to worry/complain about for those so inclined.
Stanford 35
SDSU 20

Entered properly.

RE: Stanford-SDSU predictions -- FORM UP - PAsportsfan - 08-31-2018

Stanford 31
SDSU 17

RE: Stanford-SDSU predictions -- FORM UP - thunder_chik - 08-31-2018

Greetings, All,

Thunder_chik, here. Had to establish a new alias because I've not been able to log in for several weeks now.
I was able, however, to post my prediction in the form a couple of days ago:

Team formerly known by a Native American moniker, 27
Team currently known by a Native American moniker, 20

RE: Stanford-SDSU predictions -- FORM UP - martyup - 09-02-2018

Results have been posted in a new thread that is pinned to the top. All future entries and results will appear in that new thread. Thanks for playing!