VerStraten AMCAS_GPA_Calculator_v3 (EMDP2) DO NOT OPEN IN GOOGLE SHEETS.xlsx

	A	B	C	D	E	F	G	H	I
1	AMCAS GPA Calculator
2	DOWNLOAD THIS DOCUMENT TO OPEN AND COMPLETE IN EXCEL ONLY. DO NOT COMPLETE IN GOOGLE SHEETS, it will not work properly in Google Sheets. Please put in all of your coursework information. To be totally accurate enter every grade for all courses even if the class was repeated. If the course is P/F or S/NS, leave the transcript grade and credit hour cells BLANK. Also check the boxes to the right if apply to the coursework listed, do not edit greyed out boxes or Data sections, these will automomatically populate.
3	Freshman Classes (Enter Class Name and Catalog Number)		Transcript Grade	Credit Hours on Transcript	AMCAS Weight Grade Point Conversion	AMCAS Calculated Hours	Quality Points	Check box if Biology, Chemistry, Physics, or Math Class (BCPM)	Check box if class is based on the quarter system
4	American Military University		3.956	45	#N/A	45.00	#N/A	FALSE	FALSE
5	Chandler-Gilbert Community College		3.191	68	#N/A	68.00	#N/A	FALSE	FALSE
6	JST-School			62		62.00		FALSE	FALSE
7
8								FALSE	FALSE
9
10								FALSE
11								FALSE
12
13
14
15
16								FALSE
17									FALSE
18
19									FALSE
20									FALSE
21
22									FALSE
23
24
25	Freshman Year Data	Total Semester Hours	Total Freshman Quality Points	AMCAS Freshman GPA	Running Overall GPA	BCPM Semester Hours	BCPM Quality Hours	Freshman BCPM GPA	Running BCPM GPA
26		175.00	#N/A	#N/A	#N/A			#DIV/0!	#DIV/0!
27
28		OA Hours	OA Quality Points	Freshman OA GPA	Running OA GPA
29		175	#N/A	#N/A	#N/A
30
31	Sophomore Classes (Enter Class Name and Catalog Number)		Transcript Grade	Credit Hours on Transcript	AMCAS Weight Grade Point Conversion	AMCAS Calculated Hours	Quality Points	Check box if Biology, Chemistry, Physics, or Math Class (BCPM)	Check box if class is based on the quarter system
32								FALSE	FALSE
33									FALSE
34									FALSE
35									FALSE
36									FALSE
37
38
39								FALSE
40								FALSE
41
42								FALSE
43
44								FALSE
45
46
47								FALSE	FALSE
48								FALSE	FALSE
49
50
51
52
53	Sophomore Year Data	Total Semester Hours	Total Sophomore Quality Points	AMCAS Sophomore GPA	Running Overall GPA	BCPM Semester Hours	BCPM Quality Hours	Sophomore BCPM GPA	Running BCPM GPA
54				#N/A	#N/A			#N/A	#N/A
55
56		OA Hours	OA Quality Points	Sophomore OA GPA	Running OA GPA
57		0		#N/A	#N/A
58	Junior Classes (Enter Class Name and Catalog Number)		Transcript Grade	Credit Hours on Transcript	AMCAS Weight Grade Point Conversion	AMCAS Calculated Hours	Quality Points	Check box if Biology, Chemistry, Physics, or Math Class (BCPM)	Check box if class is based on the quarter system
59								FALSE	FALSE
60								FALSE	FALSE
61								FALSE	FALSE
62								FALSE	FALSE
63									FALSE
64
65
66								FALSE
67
68
69
70
71
72
73
74									FALSE
75									FALSE
76
77
78
79
80	Junior Year Data	Total Semester Hours	Total Junior Quality Points	AMCAS Junior GPA	Running Overall GPA	BCPM Semester Hours	BCPM Quality Hours	Junior BCPM GPA	Running BCPM GPA
81				#N/A	#N/A			#N/A	#N/A
82
83		All Other Hours	All Other Quality Points	All Other Junior GPA	Running All Other GPA
84		0		#N/A	#N/A
85
86	Senior Classes (Enter Class Name and Catalog Number)		Transcript Grade	Credit Hours on Transcript	AMCAS Weight Grade Point Conversion	AMCAS Calculated Hours	Quality Points	Check box if Biology, Chemistry, Physics, or Math Class (BCPM)	Check box if class is based on the quarter system
87								FALSE	FALSE
88								FALSE	FALSE
89								FALSE	FALSE
90
91									FALSE
92
93
94								FALSE
95
96
97
98
99
100