New Inquirer Spreadsheet Output Format

In order to provide a column for 182 categories and still fit on an Excel spreadsheet, each document creates two row, the first (shown as yellow) for raw counts and the second (shown as blue/green) for scaled scores. These can be selected by the "r" (for raw) and "s" (for scaled) in the "format" column, using the Excel "filter" option or exclude/include selection options in SPSS or JMP.

Note that the first three columns were produced from the file names, for example, "bradley speech race3" yielded the information for the first four columns.

The scaled scores are as a percentage to one decimal place. For example, in the first document, there were 135 leftover words (words not in the Inquirer dictionary, which was 4.1% of the text. In the text, there were 6.5% positive words and 1.8% negative words, etc.

Primary candidates

Person	Form	Topic	Serial#	format	wordcount	leftovers	Positiv	Negativ	Affil	Hostile	Strong
bradley	speech	announce	1	r	3,312	135	215	61	131	23	319
bradley	speech	announce	1	s	3,312	4.1	6.5	1.8	4.0	0.7	9.6
bradley	speech	announce	2	r	805	21	72	18	37	5	125
bradley	speech	announce	2	s	805	2.6	8.9	2.2	4.6	0.6	15.5
bradley	speech	campaignfinance	1	r	3,687	154	211	87	106	35	404
bradley	speech	campaignfinance	1	s	3,687	4.2	5.7	2.4	2.9	0.9	11.0
bradley	speech	democrat	1	r	3,491	86	238	94	171	24	439
bradley	speech	democrat	1	s	3,491	2.5	6.8	2.7	4.9	0.7	12.6
bradley	speech	family	1	r	3,396	141	294	75	180	16	369
bradley	speech	family	1	s	3,396	4.2	8.7	2.2	5.3	0.5	10.9
bradley	speech	foreign	1	r	2,785	101	144	54	69	25	292
bradley	speech	foreign	1	s	2,785	3.6	5.2	1.9	2.5	0.9	10.5
bradley	speech	foreign	2	r	3,068	96	181	64	62	33	283
bradley	speech	foreign	2	s	3,068	3.1	5.9	2.1	2.0	1.1	9.2
bradley	speech	gunviolence	1	r	3,005	133	179	209	107	153	449
bradley	speech	gunviolence	1	s	3,005	4.4	6.0	7.0	3.6	5.1	14.9
bradley	speech	healthcare	1	r	3,821	138	351	137	187	28	445
bradley	speech	healthcare	1	s	3,821	3.6	9.2	3.6	4.9	0.7	11.6
bradley	speech	poverty	1	r	3,412	91	195	136	121	26	313
bradley	speech	poverty	1	s	3,412	2.7	5.7	4.0	3.5	0.8	9.2
bradley	speech	poverty	2	r	3,354	103	206	87	162	24	303
bradley	speech	poverty	2	s	3,354	3.1	6.1	2.6	4.8	0.7	9.0
bradley	speech	president	1	r	648	23	31	4	16	0	61
bradley	speech	president	1	s	648	3.5	4.8	0.6	2.5	0.0	9.4
bradley	speech	race	1	r	3,244	119	152	66	94	24	329
bradley	speech	race	1	s	3,244	3.7	4.7	2.0	2.9	0.7	10.1
bradley	speech	race	2	r	5,372	244	296	251	179	110	528
bradley	speech	race	2	s	5,372	4.5	5.5	4.7	3.3	2.0	9.8
bradley	speech	race	3	r	1,225	132	45	74	37	41	116
bradley	speech	race	3	s	1,225	10.8	3.7	6.0	3.0	3.3	9.5
bradley	speech	race	4	r	4,166	160	265	214	143	79	460
bradley	speech	race	4	s	4,166	3.8	6.4	5.1	3.4	1.9	11.0
bradley	speech	race	5	r	3,468	132	217	162	104	55	389
bradley	speech	race	5	s	3,468	3.8	6.3	4.7	3.0	1.6	11.2
bradley	speech	union	1	r	5,169	163	228	79	108	17	403
bradley	speech	union	1	s	5,169	3.2	4.4	1.5	2.1	0.3	7.8
buchanan	speech	abortion	1	r	2,793	180	100	89	68	45	286
buchanan	speech	abortion	1	s	2,793	6.4	3.6	3.2	2.4	1.6	10.2
buchanan	speech	agriculture	1	r	2,254	206	94	105	61	42	221
buchanan	speech	agriculture	1	s	2,254	9.1	4.2	4.7	2.7	1.9	9.8
buchanan	speech	announce	1	r	2,285	110	138	88	114	44	261
buchanan	speech	announce	1	s	2,285	4.8	6.0	3.9	5.0	1.9	11.4
buchanan	speech	china	1	r	2,479	204	113	138	62	94	334
buchanan	speech	china	1	s	2,479	8.2	4.6	5.6	2.5	3.8	13.5
buchanan	speech	foreign	1	r	2,101	158	117	86	66	48	213
buchanan	speech	foreign	1	s	2,101	7.5	5.6	4.1	3.1	2.3	10.1
buchanan	speech	republicans	1	r	2,066	235	126	103	67	64	258
buchanan	speech	republicans	1	s	2,066	11.4	6.1	5.0	3.2	3.1	12.5
buchanan	speech	stump	1	r	2,013	160	127	51	70	25	211
buchanan	speech	stump	1	s	2,013	7.9	6.3	2.5	3.5	1.2	10.5
buchanan	speech	trade	1	r	3,317	224	145	116	68	39	340
buchanan	speech	trade	1	s	3,317	6.8	4.4	3.5	2.1	1.2	10.3
buchanan	speech	values	1	r	3,254	253	194	107	140	65	258
buchanan	speech	values	1	s	3,254	7.8	6.0	3.3	4.3	2.0	7.9
bush	speech	agriculture	1	r	1,238	28	93	59	58	19	155
bush	speech	agriculture	1	s	1,238	2.3	7.5	4.8	4.7	1.5	12.5
bush	speech	announce	1	r	2,036	53	187	67	98	23	208
bush	speech	announce	1	s	2,036	2.6	9.2	3.3	4.8	1.1	10.2
bush	speech	announce	2	r	1,048	13	92	16	53	4	139
bush	speech	announce	2	s	1,048	1.2	8.8	1.5	5.1	0.4	13.3
bush	speech	defense	1	r	3,306	110	276	161	185	101	532
bush	speech	defense	1	s	3,306	3.3	8.3	4.9	5.6	3.1	16.1
bush	speech	education	1	r	3,444	126	342	141	157	68	364
bush	speech	education	1	s	3,444	3.7	9.9	4.1	4.6	2.0	10.6
bush	speech	education	2	r	3,792	149	302	126	155