ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Explainer summary
2
This Excel sheet highlights examples of how a proportional representation MOU between Democrats, independent voters, small political parties, and NGOs can be used to change the margins of elections at the federal level.
3
Proportional Representation MOU Calculations and Assumptions:
4
Most of these districts encompass entire counties; thus, the county data can be used. However, for races where only parts of it are included, a standard deviation of +- 4.7% will be applied to the final vote total percentages, in hopes of getting 99.7% of the eligible voter data.
5
Only 4 Districts in NC were tested, 3 Republican seats, 1 Democrat. While the NC U.S. senate seat was tested. I then used Florida district 19 and Arizona District 5 (both Republican controlled seats). I also tested the U.S. Senate race in Alaska.
6
If you are in one of the 30 states from the Ballotpedia study, you can try to replicate this model for yourself in similar races.
7
Remember, the numbers are never going to be exactly like the theoretical proportions. However, in Alaska's case, even lower Democratic Party voter registration was mitigated because of high Independent voter registration. North Carolina, however, very closely matches the theoretical proportions in all Districts.
8
One chatGDT prompt for the range of +- 4.7% I used is" what would be +_ 4.7% of the vote total number" (For the MOU candidate)
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100