Tier 2 & 3 Rugby Forum

Draft Alternative 2019 Tipping

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Draft Alternative 2019 Tipping

Postby RugInt » Sun, 10 Feb 2019, 02:42

Greetings all
Following on from my suggested change in tipping last year I have worked out a draft system proposal to date. I'd like to keep it a draft for 2019 so that there is plenty of time to iron out bugs and to determine whether it is too complicated or not. The pointing out of my errors and what has been omitted is welcome.


I just need to know how to copy a landscape size excel spreadsheet from my PC onto this thread.

User avatar
Posts: 965
Joined: Sat, 19 Apr 2014, 14:41
National Flag:
NetherlandsNetherlands

Re: Draft Alternative 2019 Tipping

Postby NedRugby » Sun, 10 Feb 2019, 03:19

You could put it google sheets or some other cloud-based thing and just post a link.

User avatar
Posts: 156
Joined: Fri, 18 Apr 2014, 07:02
National Flag:
ItalyItaly

Re: Draft Alternative 2019 Tipping

Postby m.map » Sun, 10 Feb 2019, 09:33

I agree NedRugby, google sheets looks the only option :?

Posts: 863
Joined: Mon, 12 Jan 2015, 09:13
National Flag:
WalesWales

Re: Draft Alternative 2019 Tipping

Postby dwpeate » Mon, 18 Feb 2019, 15:28

Hey RugInt, interested to take a peek when you're able to :)

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Wed, 20 Feb 2019, 01:12

Yep will do. Up to my eyeballs in other stuff. Not even able to fully updating rugbyinternational website which is a bummer. :(

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Fri, 01 Mar 2019, 08:00

Hmmm. Not doing to well trying to upload the alt tipping. Hang in there :roll:

https://docs.google.com/spreadsheets/d/ ... ingle=true


Not done this before. So you are all witness to a less than savy computer person stumbling around in the dark.
So we now have a link as per above. It doesn't all fit and idealy it should come up in this window for all to see.


No it doesn't. Back to google sheets.

Ive tried embedding but this site wont give me permission :?

Posts: 863
Joined: Mon, 12 Jan 2015, 09:13
National Flag:
WalesWales

Re: Draft Alternative 2019 Tipping

Postby dwpeate » Fri, 01 Mar 2019, 10:57

Oh I see! Very interesting

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Fri, 01 Mar 2019, 11:13

I have an updated version in which it all fits in-smaller font less row height. So it can be seen in the link but others seem to get pics and excel up on the actual page.

https://docs.google.com/spreadsheets/d/ ... output=pdf

This link is okay but if I can get the excel sheet up as a diagram that would be better. You see I will need to post a new cut-down version each week otherwise the results section will go on forever.

Please also keep in mind that it is all done manually so expect mistakes, which I need to know about. Post any errors or questions on this thread

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Sun, 03 Mar 2019, 23:12

Here is Draft Tipping No.02, meaning results for weekend 2-3 March updated

https://docs.google.com/spreadsheets/d/e/2PACX-1vSHwcNDryOYz1zwqs4p0tsSeqWf8CuGw4qQfrIFmae_nJz4EwqN8c4nhcwlBsGgGmSb6qMmNwwg0GoX/pub?output=xlsx

I haven't worked out on google sheets nor on this site how to actually copy the image of the spreadsheet. So the best I can do is make the link above.

As I have said the spreadsheet is worked manually (please don't suggest how I can do it automatically via formulas etc..my head hurts so much with google sheets) so expect mistakes. None have been pointed out so far.

Cheers

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Tue, 12 Mar 2019, 12:56

In the draft alternative tipping there were the first promotions/relegations between divisions.

The spreadsheet is below

https://docs.google.com/spreadsheets/d/e/2PACX-1vSps74GrbYkMQe01RrhUrMA2qBQuwnrYw8jeLMEWWE1pSTVDlhG4p00WUfx99CxLIIgAOiRv_--thGN/pubhtml

User avatar
Posts: 965
Joined: Sat, 19 Apr 2014, 14:41
National Flag:
NetherlandsNetherlands

Re: Draft Alternative 2019 Tipping

Postby NedRugby » Tue, 12 Mar 2019, 16:04

Noooo! Relegated, the shame!


So how many bonus points for getting the right margin?

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Fri, 15 Mar 2019, 09:16

You already get 3 for correct margin. No bonus there nor for anybody. Bonus is only for those who get closest to actual margin without anybody getting correct margin.

Relegated? Dig deep and get it back when you gain promotion :thumbup:

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Mon, 18 Mar 2019, 01:27

Here we go for an update from last weekend. Remember this is only a draft programme designed to see if my ideas as per last year re bonus points for closest margins and divisions work without major problems. This draft is not in competition with the present tipping on this forum.

https://docs.google.com/spreadsheets/d/ ... ingle=true

If you are new to the forum or a tipping oldie get going and join the fun.

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Wed, 27 Mar 2019, 22:36


Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Sun, 07 Apr 2019, 12:03

A bit of a glitch at end of March. Results for 30/03 included in April draft.

As per below
https://docs.google.com/spreadsheets/d/ ... qI/pubhtml

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Sat, 20 Apr 2019, 01:39

Draft tipping as per last weekend. Got overwhelmed with Easter.

https://docs.google.com/spreadsheets/d/ ... ingle=true

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Fri, 03 May 2019, 13:54


Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Sat, 11 May 2019, 02:06


Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Fri, 17 May 2019, 12:08


User avatar
Posts: 220
Joined: Sun, 29 Jun 2014, 15:09
National Flag:
Czech RepublicCzech Republic

Re: Draft Alternative 2019 Tipping

Postby vis maior » Fri, 17 May 2019, 16:17

loving this alternative tipping… :thumbup: 8-)

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Tue, 21 May 2019, 12:06


Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Fri, 31 May 2019, 11:26

Draft tipping updated for 25-29 May

https://docs.google.com/spreadsheets/d/ ... ingle=true

Same two leaders tie as per up to May as official tipping.

Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Sat, 08 Jun 2019, 04:21


Posts: 942
Joined: Sun, 27 Apr 2014, 03:45
Location: Australia
National Flag:
New ZealandNew Zealand

Re: Draft Alternative 2019 Tipping

Postby RugInt » Thu, 13 Jun 2019, 12:30

Draft Tipping updated to 9 June

https://docs.google.com/spreadsheets/d/ ... WQ/pubhtml

Results as per 9/06/2019
mmap promoted to Division 1
Lord Lamp relegated to Division 2
Vis Maior retains the lead

Posts: 109
Joined: Mon, 10 Nov 2014, 06:54
National Flag:
ArgentinaArgentina

Re: Draft Alternative 2019 Tipping

Postby Hernan14 » Thu, 13 Jun 2019, 21:38

Magically, I went from have 2 BP's to only one :cry: ;)

Next

Return to Rugby Forum

Who is online

Users browsing this forum: No registered users and 15 guests