Logic App for BP Reduction in Hospitals

Developing a Logic-based Programming Application for Blood Pressure Reduction in Hospitals

Answered

Via MS Excel develop a logic-based programming application. Please use the data in Excel spreadsheet you used in Module 9. Each line in the attached file represents one patient treated at the hospital. You may assume that there is only one type of hospital (i.e., Methodist, Catholic, etc.) within each county within each state. Assume that a drop in blood pressure is “good”. As one can easily see, some hospitals have a greater average blood pressure drop than others. You have a Blood Pressure Reduction Team (BPRT) of physicians and nurse practitioners that can provide education to the existing medical professionals at each hospital.

Results indicate that the BPRT through improved practice and education can reduce blood pressure at these failing hospitals. You have a total of “x” hours of BPRT resources available. Develop a logic-based programming application (one button) that will: Analyze the data to determine those hospitals that have less than an x% reduction in blood pressure (averaged across all patients treated within that specific hospital). Your program should provide a list of these hospitals. I will type in the percentage in cell “C17” and then strike your command button to view the results. Via any technique you so choose, allocate “x” hours of (BPRT) resources to the hospitals that have less than an x% reduction in blood pressure. I will type the resource hours available in cell “C18” and then strike your command button to view the results.

Your program should provide a list of these hospitals along with the BPRT resource allocation. Please provide a ½ page description of the resource allocation model you defined and applied. Please submit the following files: Excel file containing your program A Word document describing the resource allocation model you have chosen to implement (just one paragraph or flow chart is sufficient) In the same Word document, comment on how you will use this technique in your professional career development (i.e., describe any problem you have dealt with in the past or plan to in the future, how can logic based programming provide knowledge as opposed to other more traditional techniques).

<td class="

State	County	Hospital	Patient Age	Patient Gender	Blood Pressure Prior to Diagnosis	Blood Pressure 3 Months After Diagnosis	Blood Pressure 6 Months After Diagnosis
MI	SOUTH	Methodist	49	MALE	148	149	125
IN	SOUTH	Jewish	44	FEMALE	158	155	142
KY	SOUTH	Methodist	69	MALE	144	143	138
IN	CENTRAL	For Profit	57	MALE	119	110	105
IN	NORTH	Baptist	69	FEMALE	138	141	127
OH	SOUTH	Catholic	20	MALE	131	132	122
IN	NORTH	Non Profit	62	MALE	129	118	111
MI	SOUTH	Non Profit	51	FEMALE	133	134	130
WV	SOUTH	For Profit	42	MALE	128	110	107
WV	SOUTH	Catholic	19	MALE	147	150	143
KY	CENTRAL	Non Profit	56	MALE	134	128	104
OH	SOUTH	For Profit	55	MALE	109	110	88
KY	SOUTH	Non Profit	20	MALE	103	94	92
IN	SOUTH	Methodist	50	MALE	124	118	115
MI	NORTH	Non Profit	59	MALE	149	143	145
KY	CENTRAL	Catholic	69	MALE	139	142	138
IN	NORTH	Methodist	59	MALE	109	107	109
MI	NORTH	For Profit	27	FEMALE	129	122	123
OH	NORTH	Academic	50	MALE	157	147	143
WV	NORTH	Jewish	39	MALE	105	101	100
OH	CENTRAL	Jewish	44	MALE	123	113	109
MI	NORTH	Non Profit	58	MALE	150	153	150
MI	CENTRAL	Catholic	72	MALE	144	141	130
WV	CENTRAL	Non Profit	70	FEMALE	122	124	120
OH	NORTH	Non Profit	59	FEMALE	160	157	157
MI	CENTRAL	Lutheran	47	MALE	145	145	129
IN	CENTRAL	Jewish	58	FEMALE	162	154	129
OH	CENTRAL	Academic	65	MALE	138	136	127
IN	CENTRAL	Jewish	21	FEMALE	139	129	127
MI	NORTH	Baptist	50	MALE	148	138	140
KY	CENTRAL	Jewish	22	FEMALE	135	135	111
MI	CENTRAL	For Profit	39	MALE	90	87	85
WV	SOUTH	Catholic	43	FEMALE	114	91	90
IN	NORTH	Baptist	43	FEMALE	160	156	153
KY	NORTH	Academic	58	FEMALE	121	119	112
IN	CENTRAL	Baptist	69	FEMALE	118	113	111
IN	SOUTH	Baptist	55	FEMALE	136	138	132
IN	SOUTH	Academic	71	MALE	119	109	112
IN	NORTH	Lutheran	72	MALE	125	115	108
KY	CENTRAL	Catholic	66	MALE	153	141	128
OH	SOUTH	For Profit	67	MALE	128	126	123
WV	CENTRAL	Methodist	59	FEMALE	152	143	132
WV	SOUTH	Lutheran	26	MALE	174	172	162
OH	SOUTH	Jewish	52	MALE	120	120	119
IN	CENTRAL	For Profit	45	MALE	173	168	164
WV	NORTH	Non Profit	46	MALE	133	126	125
MI	SOUTH	Non Profit	20	FEMALE	127	124	117
WV	SOUTH	Lutheran	46	MALE	125	128	124
OH	CENTRAL	Academic	20	FEMALE	113	115	98
OH	CENTRAL	Lutheran	66	MALE	157	152	134
MI	NORTH	Jewish	23	MALE	133	133	135
IN	SOUTH	Academic	72	FEMALE	125	120	114
WV	SOUTH	Baptist	22	MALE	132	131	124
MI	SOUTH	Lutheran	60	FEMALE	121	115	114
OH	CENTRAL	Baptist	61	MALE	134	136	134
MI	NORTH	Methodist	20	MALE	134	136	132
OH	NORTH	Academic	39	MALE	125	115	109
MI	CENTRAL	Non Profit	53	MALE	123	120	122
WV	CENTRAL	Lutheran	60	FEMALE	152	146	143
OH	NORTH	For Profit	63	FEMALE	147	139	141
MI	SOUTH	Jewish	19	MALE	168	156	153
KY	NORTH	For Profit	62	MALE	144	134	129
MI	SOUTH	Jewish	60	FEMALE	131	130	131
IN	SOUTH	Academic	19	FEMALE	151	148	137
WV	NORTH	For Profit	55	MALE	144	141	127
WV	NORTH	Academic	44	MALE	124	117	117
MI	CENTRAL	Lutheran	61	MALE	137	136	125
MI	SOUTH	Lutheran	32	MALE	157	157	144
OH	SOUTH	Lutheran	22	FEMALE	134	123	118
WV	CENTRAL	Academic	34	MALE	121	124	119
OH	NORTH	Methodist	20	FEMALE	155	155	147
KY	SOUTH	Catholic	38	FEMALE	146	149	144
OH	SOUTH	Jewish	39	FEMALE	147	147	138
OH	CENTRAL	Lutheran	35	MALE	148	151	154
IN	CENTRAL	Catholic	41	MALE	158	149	150
WV	NORTH	Non Profit	51	MALE	154	134	129
KY	SOUTH	Lutheran	19	FEMALE	151	151	149
KY	SOUTH	Baptist	63	FEMALE	138	131	131
MI	SOUTH	For Profit	51	FEMALE	109	90	79
MI	CENTRAL	For Profit	35	MALE	145	146	138
MI	SOUTH	Jewish	57	MALE	115	107	100
MI	SOUTH	Academic	45	FEMALE	135	130	121
KY	NORTH	Academic	60	FEMALE	123	119	101
WV	SOUTH	Academic	27	MALE	155	147	141
IN	NORTH	Non Profit	26	MALE	153	147	145
KY	SOUTH	Jewish	28	FEMALE	130	127	118
MI	SOUTH	Lutheran	20	MALE	140	135	112
MI	SOUTH	Academic	55	FEMALE	126	120	115
IN	SOUTH	Catholic	30	MALE	149	145	120
IN	SOUTH	Methodist	66	MALE	146	146	118
OH	SOUTH	Non Profit	69	MALE	146	148	142
OH	CENTRAL	Methodist	66	MALE	163	166	169
IN	NORTH	Academic	41	MALE	136	119	109
MI	CENTRAL	For Profit	27	MALE	157	157	154
WV	NORTH	Jewish	53	MALE	145	142	145
IN	CENTRAL	Non Profit	39	FEMALE	140	139	138
KY	CENTRAL	For Profit	28	FEMALE	144	147	147
WV	CENTRAL	Non Profit	43	FEMALE	144	138	128
IN	NORTH	Methodist	53	FEMALE	133	129	131
IN	SOUTH	Methodist	43	MALE	131	125	120
KY	NORTH	Methodist	45	FEMALE	135	125	117
WV	NORTH	Jewish	71	FEMALE	104	90	91
MI	CENTRAL	Non Profit	59	FEMALE	127	104	98
KY	CENTRAL	Non Profit	45	MALE	110	95	94
MI	CENTRAL	Baptist	25	FEMALE	142	133	124
KY	CENTRAL	Baptist	18	MALE	132	109	102
KY	SOUTH	Baptist	69	MALE	143	143	117
IN	CENTRAL	Catholic	34	FEMALE	149	150	150
IN	SOUTH	Catholic	42	FEMALE	116	114	112
OH	SOUTH	Baptist	32	FEMALE	137	132	128
WV	NORTH	Catholic	32	MALE	130	121	119
IN	CENTRAL	Baptist	72	MALE	114	105	102
OH	SOUTH	Lutheran	71	MALE	116	105	99
IN	SOUTH	Lutheran	20	FEMALE	140	134	121
IN	SOUTH	Baptist	41	FEMALE	149	146	140
IN	SOUTH	Lutheran	68	FEMALE	159	149	146
WV	NORTH	Catholic	54	FEMALE	142	136	136
IN	NORTH	Jewish	39	MALE	114	110	102
MI	CENTRAL	Jewish	29	MALE	126	126	121
KY	CENTRAL	Baptist	55	MALE	155	144	132
KY	SOUTH	Methodist	65	FEMALE	145	139	114
OH	CENTRAL	Jewish	54	MALE	148	146	142
OH	CENTRAL	Lutheran	30	MALE	139	130	110
OH	CENTRAL	Academic	24	FEMALE	145	143	116
KY	SOUTH	Catholic	55	MALE	130	123	123
OH	SOUTH	Baptist	59	MALE	124	124	118
KY	CENTRAL	Lutheran	45	MALE	134	126	129
IN	CENTRAL	For Profit	24	FEMALE	121	115	106
KY	SOUTH	Catholic	35	MALE	125	128	103
MI	SOUTH	Methodist	39	FEMALE	168	168	168
WV	NORTH	Lutheran	46	FEMALE	134	137	115
OH	NORTH	Baptist	69	MALE	128	127	117
KY	SOUTH	Academic	22	MALE	108	107	94
MI	CENTRAL	Methodist	49	FEMALE	123	120	118
IN	SOUTH	Baptist	29	MALE	129	121	117
MI	SOUTH	Lutheran	53	MALE	134	124	125
OH	CENTRAL	Catholic	38	MALE	132	127	126
KY	SOUTH	Baptist	29	MALE	142	138	127
IN	SOUTH	For Profit	65	FEMALE	155	152	122
IN	CENTRAL	Methodist	37	MALE	126	108	95
OH	CENTRAL	Lutheran	42	MALE	117	109	103
WV	CENTRAL	Baptist	68	MALE	122	115	99
WV	NORTH	For Profit	58	FEMALE	145	139	134
IN	NORTH	Baptist	59	MALE	105	97	89
IN	SOUTH	Academic	57	FEMALE	126	125	115
MI	NORTH	Academic	51	MALE	123	122	102
KY	NORTH	Academic	66	FEMALE	144	148	129
WV	CENTRAL	Lutheran	32	FEMALE	138	132	131
MI	NORTH	Jewish	48	FEMALE	143	146	143
WV	SOUTH	Non Profit	43	MALE	104	102	96
OH	SOUTH	Academic	30	FEMALE	156	156	127
WV	NORTH	Baptist	58	FEMALE	134	128	119
MI	CENTRAL	Lutheran	29	MALE	146	148	136
OH	NORTH	For Profit	35	MALE	127	119	118
KY	SOUTH	Academic	23	FEMALE	114	116	111
WV	NORTH	Catholic	32	MALE	149	140	129
MI	NORTH	Catholic	35	FEMALE	153	143	146
OH	SOUTH	Academic	65	MALE	115	107	108
MI	NORTH	Catholic	57	FEMALE	133	130	120
MI	NORTH	Academic	32	MALE	147	146	145
OH	CENTRAL	Baptist	35	FEMALE	169	163	154
IN	NORTH	Baptist	67	MALE	172	169	155
IN	SOUTH	Baptist	70	FEMALE	128	125	120
IN	SOUTH	Methodist	36	MALE	147	141	140
IN	NORTH	Non Profit	55	FEMALE	151	153	154
MI	SOUTH	For Profit	32	FEMALE	117	107	103
IN	SOUTH	Catholic	29	MALE	105	103	96
WV	NORTH	Jewish	34	MALE	134	128	119
IN	CENTRAL	For Profit	63	FEMALE	142	138	114
IN	CENTRAL	Catholic	23	FEMALE	145	148	138
KY	CENTRAL	Catholic	47	MALE	133	136	118
WV	SOUTH	Jewish	72	FEMALE	159	148	150
WV	SOUTH	Non Profit	59	MALE	158	153	157
WV	SOUTH	Jewish	65	FEMALE	131	121	123
MI	CENTRAL	Jewish	24	MALE	158	150	141
WV	SOUTH	Methodist	47	MALE	123	115	108
IN	CENTRAL	Catholic	18	MALE	174	171	162