I want to test my spreadsheet
       |           

Welcome, Guest. Please login or register.
Did you miss your activation email?
April 18, 2024, 07:47:23 PM
News: Election Simulator 2.0 Released. Senate/Gubernatorial maps, proportional electoral votes, and more - Read more

  Talk Elections
  Presidential Elections - Analysis and Discussion
  Presidential Election Trends (Moderator: 100% pro-life no matter what)
  I want to test my spreadsheet
« previous next »
Pages: [1]
Author Topic: I want to test my spreadsheet  (Read 704 times)
pops
katman46
Jr. Member
***
Posts: 770


Political Matrix
E: -7.00, S: 4.00

P P P
Show only this user's posts in this thread
« on: December 12, 2018, 01:29:46 PM »

Okay, I'm doing this to test something I made. I want you guys to give me a percent of how much each of these five regions will move left or right compared to the generic 2018 results (AKA 2018 with a 50/50 popular vote) to 2020 results. I have a spreadsheet that I want to test out with this. Here are the regions:

South
West
Pacific
Northwest
Midwest

After that, I'll give you a map and the margin of every state within 5%.

So, for example, let's say I think that the south will favor Democrats 2.1% more, west will favor Dems 1.7% more, etc, I would put this:

South D+2.1
West D+1.7
Pacific R+0.7
Northwest R+1.1
Midwest R+3.5

Then I would put that info into my magic spreadsheet and pump out this map:



And give you this list:

CO D+3.8
NH D+1.2
MN R+0.7
NV R+1.6
PA R+2.9
MI R+4.4
WI R+4.6

Catch my drift? Here are some notes about this:

Missouri is considered both a part of the south and a part of the midwest. Texas is considered both a part of the south and the west. Pennsylvania is both in the northwest and the midwest. I don't have house vote totals for Tennessee and New York, so I am using the Senate races until I can get those numbers. This is purely experimental and I would love suggestions as to how I could improve this. Also, if anyone has the US House numbers in TN or NY, PLEASE SEND THEM.

As a final note, if you want to predict far future trends, I am willing to do that too, but I don't really expect any sense of accuracy there.
Logged
ElectionsGuy
Atlas Star
*****
Posts: 21,106
United States


Political Matrix
E: 7.10, S: -7.65

P P
Show only this user's posts in this thread
« Reply #1 on: December 12, 2018, 03:32:18 PM »

Hmmm interesting

South: D+0.5%
West: D+4%
Pacific: D+2%
Northeast: R+2.5%
Midwest: R+4.5%
Logged
pops
katman46
Jr. Member
***
Posts: 770


Political Matrix
E: -7.00, S: 4.00

P P P
Show only this user's posts in this thread
« Reply #2 on: December 12, 2018, 03:42:08 PM »
« Edited: December 12, 2018, 03:48:56 PM by katman46 »

Hmmm interesting

South: D+0.5%
West: D+4%
Pacific: D+2%
Northeast: R+2.5%
Midwest: R+4.5%



PA R+4.6
AZ R+3.7
MN R+1.7
NH R+0.2
NV D+0.7
ME D+3.9

The only state right now that's highly questionable is Florida, and I am considering dividing the Florida number by 8-10 to replicate it's closeness. (It was R+13.6 in this scenario, which is probably not going to happen)

EDIT: I have now divided Florida numbers by 7 and added 1% to Dems, representing a 0.94% win for Trump in this scenario. If I see anything else odd with these I will make similar fixes.
Logged
RoyCooper2020
Rookie
**
Posts: 40
United States


Show only this user's posts in this thread
« Reply #3 on: December 12, 2018, 09:12:21 PM »

South: D+3.5%
West: D+6%
Pacific: D+3%
Northeast: R+0.5%
Midwest: R+1%
Logged
pops
katman46
Jr. Member
***
Posts: 770


Political Matrix
E: -7.00, S: 4.00

P P P
Show only this user's posts in this thread
« Reply #4 on: December 12, 2018, 11:46:09 PM »

South: D+3.5%
West: D+6%
Pacific: D+3%
Northeast: R+0.5%
Midwest: R+1%

There are exactly zero changes from 2016 to this.



WI R+2.1
MI R+1.9
AZ R+1.7
FL R+0.51
PA R+0.12
MN D+1.8
NH D+1.8
NV D+2.7
Logged
Del Tachi
Republican95
Atlas Icon
*****
Posts: 17,820
United States


Political Matrix
E: 0.52, S: 1.46

P P P

Show only this user's posts in this thread
« Reply #5 on: December 13, 2018, 01:56:50 AM »

South R+2.2
West D+3.4
Pacific D+5.0
Northeast D+2.3
Midwest D+4.6
Logged
pops
katman46
Jr. Member
***
Posts: 770


Political Matrix
E: -7.00, S: 4.00

P P P
Show only this user's posts in this thread
« Reply #6 on: December 13, 2018, 02:02:55 AM »

South R+2.2
West D+3.4
Pacific D+5.0
Northeast D+2.3
Midwest D+4.6



AZ R+4.3
FL R+1.3
IA R+0.10
NV D+0.13
VA D+3.2
WI D+3.5
MI D+3.7
NH D+4.6
Logged
LAKISYLVANIA
Lakigigar
Atlas Icon
*****
Posts: 15,166
Belgium


Political Matrix
E: -7.42, S: -4.78

P P P
Show only this user's posts in this thread
« Reply #7 on: December 13, 2018, 08:44:28 AM »

South R+2.4
West D+12.4
Pacific D+8.9
Northeast R+4.8
Midwest R+0.9
Logged
Karpatsky
Jr. Member
***
Posts: 1,545
Ukraine


Show only this user's posts in this thread
« Reply #8 on: December 13, 2018, 09:14:45 AM »

Can you upload the spreadsheet? I'd love to take a closer look at it.
Logged
Zaybay
Junior Chimp
*****
Posts: 6,076
United States


Political Matrix
E: -7.25, S: -6.50

Show only this user's posts in this thread
« Reply #9 on: December 13, 2018, 09:39:25 AM »

Ill take a shot:

South D+0.3
West D+2.2
Pacific R+0.7
Northeast D+5.3
Midwest D+2.1
Logged
pops
katman46
Jr. Member
***
Posts: 770


Political Matrix
E: -7.00, S: 4.00

P P P
Show only this user's posts in this thread
« Reply #10 on: December 13, 2018, 12:42:58 PM »

South R+2.4
West D+12.4
Pacific D+8.9
Northeast R+4.8
Midwest R+0.9



NH R+2.5
PA R+2.2
WI R+2.0
MI R+1.8
FL R+1.4
MT R+1.2
ME D+1.6
MN D+1.9
VA D+3.0
AZ D+4.7

Ill take a shot:

South D+0.3
West D+2.2
Pacific R+0.7
Northeast D+5.3
Midwest D+2.1



IA R+2.6
NV R+1.1
FL R+0.97
WI D+0.98
MI D+1.2
CO D+4.3
MN D+4.9
Logged
Vern
vern1988
Sr. Member
****
Posts: 2,183
United States


Political Matrix
E: -1.30, S: -0.70

P P P

Show only this user's posts in this thread
« Reply #11 on: December 14, 2018, 09:25:52 PM »



South: D+8.4%
West: R +4.5%
Pacific: D+4%
Northeast: R+5%
Midwest: D+1%
Logged
Pages: [1]  
« 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.044 seconds with 12 queries.