Canada General Discussion 1.5: The Countdown Begins
       |           

Welcome, Guest. Please login or register.
Did you miss your activation email?
March 28, 2024, 08:24:19 AM
News: Election Simulator 2.0 Released. Senate/Gubernatorial maps, proportional electoral votes, and more - Read more

  Talk Elections
  General Politics
  International General Discussion (Moderators: afleitch, Hash)
  Canada General Discussion 1.5: The Countdown Begins
« previous next »
Pages: 1 ... 26 27 28 29 30 [31] 32 33 34 35 36 ... 64
Author Topic: Canada General Discussion 1.5: The Countdown Begins  (Read 159499 times)
RogueBeaver
Atlas Star
*****
Posts: 20,058
Canada
Show only this user's posts in this thread
« Reply #750 on: July 02, 2014, 09:42:57 PM »

Paul Manly, son of former NDP BC MP Jim Manly, has been vetoed in Nanaimo-Ladysmith. Claims his Mideast views, which are closer to Davies than Mulcair, are why.
Logged
RogueBeaver
Atlas Star
*****
Posts: 20,058
Canada
Show only this user's posts in this thread
« Reply #751 on: July 03, 2014, 03:03:48 PM »

MP LaVar Payne (Medicine Hat) will retire next year.
Logged
DC Al Fine
Atlas Icon
*****
Posts: 14,085
Canada


Show only this user's posts in this thread
« Reply #752 on: July 03, 2014, 04:30:37 PM »

Question for the guys with projection models:

I'm making my own model and I want to have a column that has the winner of each seat so I can do seat counts and quickly check who won each seat.

ie.
       A        B       C            D
1   Tory Liberal NDP     Winner
2    40%   30%  30%      Tory

The problem is, I'm having trouble coming with a formula to spit out the winner of each seat.

My current attempt is =LOOKUP(MAX(A2:C2), A2:C2, A1:C1), which sort of works. If the NDP, Bloc or Greens win the seat the cell correctly states the winner. However, if the Tories or Liberals win the seat, it says the Greens are the winner Tongue

Thoughts?
Logged
True Federalist (진정한 연방 주의자)
Ernest
Moderators
Atlas Legend
*****
Posts: 42,157
United States


Show only this user's posts in this thread
« Reply #753 on: July 03, 2014, 08:01:03 PM »
« Edited: July 04, 2014, 12:16:28 AM by True Federalist »

Disclaimer I use OpenOffice, not Excel, so it's possible your mileage may vary.

LOOKUP requires that the vector you are searching be in ascending order, not random order, so that is probably what is giving you problems.
Anyway, the method in OpenOffice that doesn't require sorting anything first involves using the MATCH and OFFSET functions.  (IIRC, OpenOffice uses semicolons where Excel uses commas, so translate as needed.)

=OFFSET(A$1;0;MATCH(MAX(A2:C2);A2:C2;0)-1) is the formula I'd use in OpenOffice to find the winner.  You may need to adjust a few things to get them to work in Excel.
Logged
DC Al Fine
Atlas Icon
*****
Posts: 14,085
Canada


Show only this user's posts in this thread
« Reply #754 on: July 03, 2014, 08:24:08 PM »

Thanks Ernest, it works great!
Logged
RogueBeaver
Atlas Star
*****
Posts: 20,058
Canada
Show only this user's posts in this thread
« Reply #755 on: July 03, 2014, 08:28:57 PM »

NDP parliamentary staff has split with UNIFOR, political in nature.
Logged
Hatman 🍁
EarlAW
Atlas Star
*****
Posts: 25,977
Canada


WWW Show only this user's posts in this thread
« Reply #756 on: July 04, 2014, 08:35:08 AM »


Good riddance.
Logged
RogueBeaver
Atlas Star
*****
Posts: 20,058
Canada
Show only this user's posts in this thread
« Reply #757 on: July 04, 2014, 02:53:47 PM »

Good reads from Wells and Ling on the state of play.

Some Stampede bipartisanship today.



Logged
You kip if you want to...
change08
Junior Chimp
*****
Posts: 8,940
United Kingdom
Show only this user's posts in this thread
« Reply #758 on: July 04, 2014, 07:02:57 PM »

Trudeau makes Harper look down to Earth.
Logged
RogueBeaver
Atlas Star
*****
Posts: 20,058
Canada
Show only this user's posts in this thread
« Reply #759 on: July 04, 2014, 07:04:36 PM »

^ First time I've ever heard that.
Logged
Njall
Jr. Member
***
Posts: 1,019
Canada


Political Matrix
E: -1.55, S: -5.91

Show only this user's posts in this thread
« Reply #760 on: July 08, 2014, 12:44:46 AM »

It would appear that Mike Allen (MLA for Fort McMurray-Wood Buffalo) has rejoined the PC caucus; a fact that I was unaware of until I ran into him at tonight's Calgary-West PC Association Stampede barbeque.

Looks like caucus voted on and approved his re-entry at a meeting this week.  For those who don't remember, Allen left caucus last summer after attempting to hire two "prostitutes" (who were actually undercover cops) while on a government trip to Minnesota.
Logged
MaxQue
Atlas Icon
*****
Posts: 12,600
Canada


Show only this user's posts in this thread
« Reply #761 on: July 08, 2014, 01:58:49 AM »

Looks like caucus voted on and approved his re-entry at a meeting this week.  For those who don't remember, Allen left caucus last summer after attempting to hire two "prostitutes" (who were actually undercover cops) while on a government trip to Minnesota.

What a waste of taxpayers money.
Logged
Njall
Jr. Member
***
Posts: 1,019
Canada


Political Matrix
E: -1.55, S: -5.91

Show only this user's posts in this thread
« Reply #762 on: July 08, 2014, 11:52:57 AM »

In other news, it looks like Alberta's license plates will no longer proclaim the province to be "Wild Rose Country"

Quote
You must be logged in to read this quote.
Logged
RogueBeaver
Atlas Star
*****
Posts: 20,058
Canada
Show only this user's posts in this thread
« Reply #763 on: July 08, 2014, 06:45:52 PM »

SK, NB to join national securities regulator.

^ Nenshi pwned them on Twitter by asking if they realize there's also an Alberta Party. That said, Wildrose should switch it back if they win.
Logged
Hatman 🍁
EarlAW
Atlas Star
*****
Posts: 25,977
Canada


WWW Show only this user's posts in this thread
« Reply #764 on: July 08, 2014, 06:58:48 PM »

How on earth is a line from O Canada "too American sounding"?

This license plate thing is a joke. No reason to change it. Alberta and Quebec both have the most awesome license plate mottos.
Logged
MaxQue
Atlas Icon
*****
Posts: 12,600
Canada


Show only this user's posts in this thread
« Reply #765 on: July 08, 2014, 07:10:19 PM »

"Je me souviens" (I remember) is very ironic for a province which keep to reelect a very corrupt political party.
Logged
Vosem
Atlas Icon
*****
Posts: 15,618
United States


Political Matrix
E: 8.13, S: -6.09

Show only this user's posts in this thread
« Reply #766 on: July 08, 2014, 07:22:15 PM »

"Wild Rose Country" sounds amazing and, from the little I've seen of Alberta, is quite accurate. It'd be a shame if they dropped it.
Logged
You kip if you want to...
change08
Junior Chimp
*****
Posts: 8,940
United Kingdom
Show only this user's posts in this thread
« Reply #767 on: July 08, 2014, 07:24:04 PM »

If the NDP win in Sask, will they change the name of the state in case it looks bias to the Sask Party?
Logged
MaxQue
Atlas Icon
*****
Posts: 12,600
Canada


Show only this user's posts in this thread
« Reply #768 on: July 08, 2014, 07:35:27 PM »

If the NDP win in Sask, will they change the name of the state in case it looks bias to the Sask Party?

Sask Party leader has approvals in the 60-70, so, NDP winning won't happen.
Logged
You kip if you want to...
change08
Junior Chimp
*****
Posts: 8,940
United Kingdom
Show only this user's posts in this thread
« Reply #769 on: July 08, 2014, 07:37:01 PM »

If the NDP win in Sask, will they change the name of the state in case it looks bias to the Sask Party?

Sask Party leader has approvals in the 60-70, so, NDP winning won't happen.

That's not what I meant...
Logged
Hatman 🍁
EarlAW
Atlas Star
*****
Posts: 25,977
Canada


WWW Show only this user's posts in this thread
« Reply #770 on: July 08, 2014, 07:37:18 PM »

If the NDP win in Sask, will they change the name of the state in case it looks bias to the Sask Party?

Canada doesn't have states. Tongue
Logged
Njall
Jr. Member
***
Posts: 1,019
Canada


Political Matrix
E: -1.55, S: -5.91

Show only this user's posts in this thread
« Reply #771 on: July 09, 2014, 03:14:38 AM »

Here are the proposed new license plate designs.
Logged
True Federalist (진정한 연방 주의자)
Ernest
Moderators
Atlas Legend
*****
Posts: 42,157
United States


Show only this user's posts in this thread
« Reply #772 on: July 09, 2014, 03:58:17 AM »

They all look fairly insipid.  #3 is best IMO, but only because the web address is clearly visible in it.  With a lighter shade of grass, #2 would be best, but as I said they all are insipid, primarily because they are so generic.
Logged
Hatman 🍁
EarlAW
Atlas Star
*****
Posts: 25,977
Canada


WWW Show only this user's posts in this thread
« Reply #773 on: July 09, 2014, 06:49:11 AM »

Are they doing this now because they lack a proper Premier who can be blamed for such shenanigans? Maybe Newfoundland can do something sneaky too for the same reason.
Logged
RogueBeaver
Atlas Star
*****
Posts: 20,058
Canada
Show only this user's posts in this thread
« Reply #774 on: July 09, 2014, 05:26:33 PM »

On a more serious subject, Ivison sees the push for internal trade as a preview of the next Tory leadership battle. As I've said before, I highly doubt Wall runs. The whole thing is somewhat academic since whoever the next leader probably loses a general election either from government or opposition. Which isn't to say I won't support Kenney strongly - I will - but I'm under no illusions he'd be PM for very long if Harper passed the baton.
Logged
Pages: 1 ... 26 27 28 29 30 [31] 32 33 34 35 36 ... 64  
« previous next »
Jump to:  


Login with username, password and session length

Terms of Service - DMCA Agent and Policy - Privacy Policy and Cookies

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines

Page created in 0.052 seconds with 12 queries.