{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INSTRUCTIONS","What counts as BCPM","Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["READ THESE TIPS BEFORE FILLING OUT THE GPA CALCULATION GRID (which appears on the next tab within this Excel document)"]
["1. Note that columns that are greyed-out will be calculated automatically for you. Do not attempt to input data in greyed-out columns."]
["2. To get from one field to the next in the Excel grid, USE THE TAB KEY."]
["3. DO NOT ENTER COURSES IN WHICH YOU EARNED a W, I, P/NP, NC, CLEP, Test/ AP Credits, etc. Only enter courses in which you earned a differentiated (A-F) grade."]
["4. When entering credits into the grid, be sure to enter courses and credits as they appear on the transcript from the institution where you took the courses. Leave colmun H unchecked if the credits were taken at an institution using the semester system (FIU is a semester system). This means you must have (unoffical) transcripts on hand from each institution attended when filling out the grid "]
["5. Transfer credits taken at another institution and then transferred to FIU should be entered as they appear on the transcript of that institution (where you took the credits) - NOT as they appear on your FIU unofficial transcript."]
["6. AMCAS years begin with summer and end with spring. Courses taken in the summer should be entered with the next academic year.  For example, if you took a course in the first summer session of 2016, you should enter it as the 2016-2017 academic year with corresponding grade level. "]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"What counts as BCPM","index":1,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Classified as Biology","Classified as Chemistry","Classified as Physics ","Classified as Math"]
["Anatomy","Biochemistry","Astronomy","Applied Mathematics"]
["Biology","Chemistry","Physics","Biostatistics"]
["Biophysics","Physical Chemistry",null,"Mathematics"]
["Biotechnology","Thermodynamics",null,"Statistics"]
["Botany","Analytical Chemistry"]
["Cell Biology","Medicinal Chemistry"]
["Ecology","Organic Chemistry"]
["Entomology","Environmental Chemistry"]
["Genetics","Forensic chemistry"]
["Histology"]
["Immunology"]
["Microbiology"]
["Molecular Biology"]
["Neuroscience"]
["Physiology"]
["Zoology"]
["Virology"]
[]
["Will not classify as BCPM"]
[]
["Anthropology","Composition & Rhetoric","Physical Therapy"]
["Economics","Creative Writing","Physician Assistant"]
["Family Studies","Literature","Public Health"]
["Psychology","Art","Pharmacology & Pharmacy"]
["Sociology","Art History","Sports Medicine"]
["Accounting","Dance","Veterinary Medicine"]
["Finance","Fine Arts","Medical Terminology"]
["Human Resource Studies","Music","Gender Studies"]
["Management","Photography","History"]
["Marketing","Theatre","Agriculture"]
["Organizational Studies","American Sign Language","Animal & Avian Sciences"]
["Journalism","Comparative Literature","Environmental Science & Policy"]
["Media Production & Studies","Foreign Language(s) & Literature","Forestry"]
["TV, Video, & Audio","Linguistics","Geography"]
["Computer Science","Criminology & Criminal Justice","Geology"]
["Computer Engineering","Government","Horticulture"]
["Information Systems","International Relations & Studies","Landscape Architecture"]
["Telecommunications","Law/Legal Studies","Meteorology"]
["Counseling & Personnel Services","Political Science","Natural Resources"]
["Curriculum & Instruction","Public Affairs & Policy","Oceanography"]
["Educational Administration","Urban Policy & Planning","Architecture"]
["Educational Policy","Allied Health","Library Science"]
["Health Education","Chiropractic","Military Science"]
["Human Development","Dentistry","Sports (tennis, golf, aerobics, etc.)"]
["Physical Education","Hearing & Speech Studies","Ethics"]
["Special Education","Hospital Administration","Logic"]
["Aerospace Engineering","Kinesiology","Philosophy"]
["Biomedical Engineering","Nursing","Religion"]
["Chemical Engineering","Nutrition","Theology"]
["Civil Engineering","Occupational Therapy","Afro-American Studies"]
["Electrical Engineering","Optometry","American Studies"]
["Environmental Engineering","Osteopathy"]
["Nuclear Engineering","Psychiatry"]

{"sheet":"Calculator","index":2,"n_rows":393,"n_cols":15,"rows_kept":393,"cut":false,"hidden":false,"merged":[[263,3,270,3],[228,8,235,8],[225,3,225,4],[225,5,225,7],[227,3,227,4],[227,5,227,7],[282,0,282,2],[282,3,282,4],[278,3,278,4],[281,3,281,4],[282,5,282,7],[279,3,279,4],[279,0,279,2],[281,0,281,2],[278,0,278,2],[281,5,281,7],[285,3,285,4],[285,5,285,7],[279,5,279,7],[278,5,278,7],[285,8,292,8],[284,0,284,2],[284,3,284,4],[284,5,284,7],[285,0,285,2],[277,0,277,7],[2,0,2,7],[3,0,3,7],[36,0,36,7],[74,0,74,7],[112,0,112,7],[150,0,150,7],[234,0,234,7],[222,0,222,2],[225,0,225,2],[222,3,222,4],[222,5,222,7],[224,5,224,7],[65,3,72,3],[103,3,110,3],[141,3,148,3],[27,3,34,3],[228,5,228,7],[228,0,228,2],[228,3,228,4],[220,0,220,7],[221,3,221,4],[179,3,186,3],[224,3,224,4],[211,3,218,3],[188,0,188,7],[221,5,221,7],[224,0,224,2],[221,0,221,2],[227,0,227,2]]}
[]
[]
["GPA Calculator "]
["Dual Enrollment"]
["Course Name","Enter Transcript Grade","AMCAS Weight Grade Point Conversion (Automatically Entered)","Enter Number of Units Hours on Transcript","AMCAS Calculated Hours (Automatically Entered)","Quality Points (Automatically Entered)","Biology, Chemistry, Physics or Math Cass (BCPM) (Check Box if YES)","Check Box if Class is Based on the Quarter System (Leave Unchecked if Semester System Based)",null,null," "]
[null,null,{"$f":"IF(B6=\"\",0,VLOOKUP(B6,$A$375:$B$390,2))","v":0},null,{"$f":"IF(I6=TRUE,IF(D6=\"\",0,VLOOKUP(D6,$D$375:$E$393,2)),D6)","v":0},{"$f":"E6*C6","v":0},null,null,false,false]
[null,null,0,null,{"$f":"IF(I7=TRUE,IF(D7=\"\",0,VLOOKUP(D7,$D$375:$E$393,2)),D7)","v":0},{"$f":"E7*C7","v":0},null,null,false,false]
[null,null,0,null,{"$f":"IF(I8=TRUE,IF(D8=\"\",0,VLOOKUP(D8,$D$375:$E$393,2)),D8)","v":0},0,null,null,false,false]
[null,null,0,null,{"$f":"IF(I9=TRUE,IF(D9=\"\",0,VLOOKUP(D9,$D$375:$E$393,2)),D9)","v":0},0,null,null,false,false]
[null,null,0,null,0,0,null,null,false,false]
[null,null,0,null,0,0,null,null,false,false]
[null,null,0,null,0,0,null,null,false,false,null,null,null,null,{"$f":"C39:C53","v":0}]
[null,null,0,null,0,0,null,null,false,false,null,null,null,null,0]
[null,null,0,null,0,0,null,null,false,false,null,null,null,null,0]
[null,null,0,null,0,0,null,null,false,false,null,null,null,null,0]
[null,null,0,null,0,0,null,null,false,false,null,null,null,null,0]
[null,null,0,null,0,0,null,null,false,false,null,null,null,null,0]
[null,null,0,null,0,0,null,null,false,false,null,null,null,null,0]
[null,null,0,null,0,0,null,null,false,false,null,null,null,null,0]
[null,null,0,null,0,0,null,null,false,false,null,null,null,null,0]
[null,null,0,null,0,0,null,null,false,false,null,null,null,null,0]
[null,null,0,null,{"$f":"IF(I22=TRUE,IF(D22=\"\",0,VLOOKUP(D22,$D$375:$E$393,2)),D22)","v":0},0," ",null,false,false,null,null,null,null,0]
[null,null,0,null,{"$f":"IF(I23=TRUE,IF(D23=\"\",0,VLOOKUP(D23,$D$375:$E$393,2)),D23)","v":0},0,null,null,false,false,null,null,null,null,0]
[null,null,0,null,{"$f":"IF(H24=TRUE,IF(D24=\"\",0,VLOOKUP(D24,$D$375:$E$393,2)),D24)","v":0},0,null,null,false,false,null,null,null,null,0]
[null,null,0,null,{"$f":"IF(I25=TRUE,IF(D25=\"\",0,VLOOKUP(D25,$D$375:$E$393,2)),D25)","v":0},0,null,null,false,false,null,null,null,null,0]
[null,null,0,null,{"$f":"IF(I26=TRUE,IF(D26=\"\",0,VLOOKUP(D26,$D$375:$E$393,2)),D26)","v":0},0,null,null,false,false,null,null,null,null,0]
[]
[null,null,null,"Dual Enrollement","Total Semester Hours","Total Pre-College Quality points","AMCAS Pre-College GPA","Running Overall GPA"]
[null,null,null,null,{"$f":"SUM(E6:E26)","v":0},{"$f":"SUM(F6:F26)","v":0},{"$f":"F29/IF(E29=0,1,E29)","v":0},{"$f":"G29","v":0}]
[]
[null,null,null,null,"BCPM Semester Hours","BCPM Quality Points","Pre-College BCPM GPA","Running BCPM GPA"]
[null,null,null,null,{"$f":"SUMIF($J$6:$J$26,TRUE,$E6:$E$26)","v":0},{"$f":"SUMIF($J$6:$J$26,TRUE,$F$6:$F$26)","v":0},{"$f":"F32/IF(E32=0,1,E32)","v":0},{"$f":"G32","v":0}]
[]
[null,null,null,null,"All Other Hours","All Other Quality Points","All Other Pre-College GPA","Running All Other GPA"]
[null,null,null,null,{"$f":"E29-E32","v":0},{"$f":"F29-F32","v":0},{"$f":"F35/IF(E35=0,1,E35)","v":0},{"$f":"G35","v":0}]
[]
["Freshman Year"]
["Course Name","Enter Transcript Grade ","AMCAS Weight - Grade Point Conversion (Automatically Entered)","Enter Number of Unit Hours on Transcript","AMCAS Calculated Hours                    (Automatically Entered)","Quality Points (Automatically Entered)","Biology, Chemistry, Physics, or Math Class (BCPM)                               (Check Box if Yes)","Check Box if Class is Based on the Quarter System                                   (Leave Unchecked if Semester System Based)"]
[null,null,{"$f":"IF(B39=\"\", 0, VLOOKUP(B39,$A$375:$B$390,2))","v":0},null,{"$f":"IF(H39=TRUE, IF(D39=\"\", 0, VLOOKUP(D39,$D$375:$E$393,2)), D39)","v":0},{"$f":" E39*C39","v":0},false,false]
[null,null,0,null,0,{"$f":" E40*C40","v":0},false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[]
[null,null,null,"Freshman Year","Total Semester Hours","Total Freshman Quality Points","AMCAS Freshman GPA","Running Overall GPA"]
[null,null,null,null,{"$f":"SUM(E39:E64)","v":0},{"$f":"SUM(F39:F64)","v":0},{"$f":" F67/IF(E67=0, 1,E67)","v":0},{"$f":"(F29+F67)/IF((E67+E29)=0,1,(E67+E29))","v":0}]
[]
[null,null,null,null,"BCPM Semester Hours","BCPM Quality Points","Freshman BCPM GPA","Running BCPM GPA"]
[null,null,null,null,{"$f":"SUMIF($G$39:$G$64,TRUE,$E$39:$E$64)","v":0},{"$f":"SUMIF($G$39:$G$64,TRUE,$F$39:$F$64)","v":0},{"$f":"F70/IF(E70=0, 1, E70)","v":0},{"$f":"(F32+F70)/IF((E70+E32)=0,1,(E70+E32))","v":0}]
[]
[null,null,null,null,"All Other Hours","All Other Quality Points","All Other Freshman GPA","Running All Other GPA"]
[null,null,null,null,{"$f":" E67-E70","v":0},{"$f":"F67-F70","v":0},{"$f":"F73/IF(E73=0, 1, E73)","v":0},{"$f":"(F35+F73)/IF((E73+E35)=0,1,(E73+E35))","v":0}]
[]
["Sophomore Year"]
["Course Name","Enter Transcript Grade ","AMCAS Weight - Grade Point Conversion (Automatically Entered)","Enter Number of Unit Hours on Transcript","AMCAS Calculated Semester Hours                    (Automatically Entered)","Quality Points (Automatically Entered)","Biology, Chemistry, Physics, or Math Class (BCPM)                           (Check Box if Yes)","Check Box if Class is Based on the Quarter System                                   (Leave Unchecked if Semester System Based)"]
[null,null,{"$f":"IF(B77=\"\", 0, VLOOKUP(B77,$A$375:$B$390,2))","v":0},null,{"$f":"IF(H77=TRUE, IF(D77=\"\", 0, VLOOKUP(D77,$D$375:$E$393,2)), D77)","v":0},{"$f":" E77*C77","v":0},false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[]
[null,null,null,"Sophmore Year","Total Semester Hours","Total Sophmore Quality Points","AMCAS Sophmore GPA","Running Overall GPA"]
[null,null,null,null,{"$f":"SUM(E77:E102)","v":0},{"$f":"SUM(F77:F102)","v":0},{"$f":" F105/IF(E105=0, 1,E105)","v":0},{"$f":" (F29+F67+F105)/IF((E105+E67+E29)=0, 1, (E105+E67+E29))","v":0}]
[]
[null,null,null,null,"BCPM Semester Hours","BCPM Quality Points","Sophmore BCPM GPA","Running BCPM GPA"]
[null,null,null,null,{"$f":"SUMIF($G$77:$G$102,TRUE,$E$77:$E$102)","v":0},{"$f":"SUMIF($G$77:$G$102,TRUE,$F$77:$F$102)","v":0},{"$f":" F108/IF(E108=0, 1,E108)","v":0},{"$f":"(F32+F70+F108)/IF((E108+E70+E32)=0,1,(E108+E70+E32))","v":0}]
[]
[null,null,null,null,"All Other Hours","All Other Quality Points","All Other Sophmore GPA","Running All Other GPA"]
[null,null,null,null,{"$f":" E105-E108","v":0},{"$f":"F105-F108","v":0},{"$f":" F111/IF(E111=0, 1,E111)","v":0},{"$f":"(F35+F73+F111)/IF((E111+E73+E35)=0,1,(E111+E73+E35))","v":0}]
[]
["Junior Year"]
["Course Name","Enter Transcript Grade ","AMCAS Weight - Grade Point Conversion (Automatically Entered)","Enter Number of Unit Hours on Transcript","AMCAS Calculated Semester Hours                    (Automatically Entered)","Quality Points (Automatically Entered)","Biology, Chemistry, Physics, or Math Class (BCPM)                              (Check Box if Yes)","Check Box if Class is Based on the Quarter System                                   (Leave Unchecked if Semester System Based)"]
[null,null,{"$f":"IF(B115=\"\", 0, VLOOKUP(B115,$A$375:$B$390,2))","v":0},null,{"$f":"IF(H115=TRUE, IF(D115=\"\", 0, VLOOKUP(D115,$D$375:$E$393,2)), D115)","v":0},{"$f":" E115*C115","v":0},false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[]
[null,null,null,"Junior Year","Total Semester Hours","Total Junior Quality Points","AMCAS Junior GPA","Running Overall GPA"]
[null,null,null,null,{"$f":"SUM(E115:E140)","v":0},{"$f":"SUM(F115:F140)","v":0},{"$f":" F143/IF(E143=0, 1, E143)","v":0},{"$f":"(F29+F67+F105+F143)/IF((E143+E105+E67+E29)=0,1,(E143+E105+E67+E29))","v":0}]
[]
[null,null,null,null,"BCPM Semester Hours","BCPM Quality Points","Junior BCPM GPA","Running BCPM GPA"]
[null,null,null,null,{"$f":"SUMIF($G$115:$G$140,TRUE,$E$115:$E$140)","v":0},{"$f":"SUMIF($G$115:$G$140,TRUE,$F$115:$F$140)","v":0},{"$f":" F146/IF(E146=0, 1, E146)","v":0},{"$f":"(F32+F70+F108+F146)/IF((E146+E108+E70+E32)=0,1,(E146+E108+E70+E32))","v":0}]
[]
[null,null,null,null,"All Other Hours","All Other Quality Points","All Other Junior GPA","Running All Other GPA"]
[null,null,null,null,{"$f":" E143-E146","v":0},{"$f":"F143-F146","v":0},{"$f":" F149/IF(E149=0, 1, E149)","v":0},{"$f":"(F35+F73+F111+F149)/IF((E149+E111+E73+E35)=0,1,(E149+E111+E73+E35))","v":0}]
[]
["Senior Year"]
["Course Name","Enter Transcript Grade ","AMCAS Weight - Grade Point Conversion (Automatically Entered)","Enter Number of Unit Hours on Transcript","AMCAS Calculated Semester Hours                    (Automatically Entered)","Quality Points (Automatically Entered)","Biology, Chemistry, Physics, or Math Class (BCPM)                         (Check Box if Yes)","Check Box if Class is Based on the Quarter System                                   (Leave Unchecked if Semester System Based)"]
[null,null,{"$f":"IF(B153=\"\", 0, VLOOKUP(B153,$A$375:$B$390,2))","v":0},null,{"$f":"IF(H153=TRUE, IF(D153=\"\", 0, VLOOKUP(D153,$D$375:$E$393,2)), D153)","v":0},{"$f":" E153*C153","v":0},false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[]
[null,null,null,"Senior Year","Total Semester Hours","Total Senior Quality Points","AMCAS Senior GPA","Running Overall GPA"]
[null,null,null,null,{"$f":"SUM(E153:E178)","v":0},{"$f":"SUM(F153:F178)","v":0},{"$f":" F181/IF(E181=0, 1, E181)","v":0},{"$f":"(F29+F67+F105+F143+F181)/IF((E181+E143+E105+E67+E29)=0,1,(E181+E143+E105+E67+E29))","v":0}]
[]
[null,null,null,null,"BCPM Semester Hours","BCPM Quality Points","Senior BCPM GPA","Running BCPM GPA"]
[null,null,null,null,{"$f":"SUMIF($G$153:$G$178,TRUE,$E$153:$E$178)","v":0},{"$f":"SUMIF($G$153:$G$178,TRUE,$F$153:$F$178)","v":0},{"$f":" F184/IF(E184=0, 1, E184)","v":0},{"$f":"(F32+F70+F108+F146+F184)/IF((E184+E146+E108+E70+E32)=0,1,(E184+E146+E108+E70+E32))","v":0}]
[]
[null,null,null,null,"All Other Hours","All Other Quality Points","All Other Senior GPA","Running All Other GPA"]
[null,null,null,null,{"$f":" E181-E184","v":0},{"$f":"F181-F184","v":0},{"$f":" F187/IF(E187=0, 1, E187)","v":0},{"$f":"(F35+F73+F111+F149+F187)/IF((E187+E149+E111+E73+E35)=0,1,(E187+E149+E111+E73+E35))","v":0}]
[]
["5th Year"]
["Course Name","Enter Transcript Grade ","AMCAS Weight - Grade Point Conversion (Automatically Entered)","Enter Number of Unit Hours on Transcript","AMCAS Calculated Semester Hours                    (Automatically Entered)","Quality Points (Automatically Entered)","Biology, Chemistry, Physics, or Math Class (BCPM)                         (Check Box if Yes)","Check Box if Class is Based on the Quarter System                                   (Leave Unchecked if Semester System Based)"]
[null,null,{"$f":"IF(B191=\"\",0,VLOOKUP(B191,$A$375:$B$390,2))","v":0},null,{"$f":"IF(L191=TRUE,IF(D191=\"\",0,VLOOKUP(D191,$D$378:$E$393,2)),D191)","v":0},{"$f":"E191*C191","v":0},null,null,null,null,false,false]
[null,null,{"$f":"IF(B192=\"\",0,VLOOKUP(B192,$A$375:$B$390,2))","v":0},null,{"$f":"IF(L192=TRUE,IF(D192=\"\",0,VLOOKUP(D192,$D$378:$E$393,2)),D192)","v":0},{"$f":"E192*C192","v":0},null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,{"$f":"IF(B206=\"\",0,VLOOKUP(B206,$A$375:$B$390,2))","v":0},null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[null,null,0,null,0,0,null,null,null,null,false,false]
[]
[null,null,null,"5th Year","Total Semester Hours","Total 5th Year Quality Points","AMCAS 5th Year GPA","Running Overall GPA"]
[null,null,null,null,{"$f":"SUM(E191:E210)","v":0},{"$f":"SUM(F191:F210)","v":0},{"$f":"F213/IF(E213=0,1,E213)","v":0},{"$f":"(F29+F67+F105+F143+F181+F213)/IF((E213+E181+E143+E105+E67+E29)=0,1,(E213+E181+E143+E105+E67+E29))","v":0}]
[null,null,null,null,null,null,null,{"$f":"(F29+F67+F105+F143+F181+F213)/IF((E29+E67+E105+E143+E181+E213)=0,1,(E29+E67+E105+E143+E181+E213))","v":0}]
[null,null,null,null,"BCPM Semester GPA","BCPM Quality Points","5th Year BCPM GPA","Running BCPM GPA"]
[null,null,null,null,{"$f":"SUMIF($K$191:$K$210,TRUE,$E$191:$E$210)","v":0},{"$f":"SUMIF($K$191:$K$210,TRUE,$F$191:$F$210)","v":0},{"$f":"F216/IF(E216=0,1,E216)","v":0},{"$f":"(F32+F70+F108+F146+F184+F216)/IF((E216+E184+E146+E108+E70+E32)=0,1,(E216+E184+E146+E108+E70+E32))","v":0}]
[]
[null,null,null,null,"All Other Hours","All Other Quality Points","All Other 5th Year GPA","Running All Other GPA"]
[null,null,null,null,{"$f":"E213-E216","v":0},{"$f":"F213-F216","v":0},{"$f":"F219/IF(E219=0,1,E219)","v":0},{"$f":"(F35+F73+F111+F149+F187+F219)/IF((E219+E187+E149+E111+E73+E35)=0,1,(E219+E187+E149+E111+E73+E35))","v":0}]
[]
["Cumulative Undergraduate GPA"]
["Cumulative Undergraduate Hours",null,null,"Cumulative Undergraduate Quality Points",null,"Cumulative Undergraduate AMCAS GPA"]
[{"$f":"SUM(E29,E67,E105,E143,E181,E213)","v":0},null,null,{"$f":"SUM(F29,F67,F105,F143,F181,F213)","v":0},null,{"$f":"D223/IF(A223=0, 1, A223)","v":0}]
[]
["Cumulative Undergraduate BCPM Hours",null,null,"Cumulative Undergraduate BCPM Quality Points",null,"Cumulative Undergraduate BCPM AMCAS GPA"]
[{"$f":"SUM(E32,E70,E108,E46, E184,E216)","v":0},null,null,{"$f":"SUM(F32,F70,F108,F146,F184,F216)","v":0},null,{"$f":"D226/IF(A226=0, 1, A226)","v":0}]
[]
["Cumulative Undergraduate All Other Hours",null,null,"Cumulative Undergraduate All Other Quality Points",null,"Cumulative Undergraduate All Other AMCAS GPA"]
[{"$f":"SUM(E35,E73,E111,E149,E187,E219)","v":0},null,null,{"$f":"SUM(F35,F73,F111,F149,F187,F219)","v":0},null,{"$f":"D229/IF(A229=0, 1, A229)","v":0},null,null,"Undergraduate Data"]
[]
[]
[]
[]
[]
["Post-Bacc"]
["Post-Bac Classes","Enter Transcript Grade ","AMCAS Weight - Grade Point Conversion (Automatically Entered)","Enter Number of Unit Hours on Transcript","AMCAS Calculated Semester Hours                    (Automatically Entered)","Quality Points (Automatically Entered)","Biology, Chemistry, Physics, or Math Class (BCPM)                            (Check Box if Yes)","Check Box if Class is Based on the Quarter System                                   (Leave Unchecked if Semester System Based)"]
[null,null,{"$f":"IF(B237=\"\", 0, VLOOKUP(B237,$A$375:$B$390,2))","v":0},null,{"$f":"IF(H237=TRUE, IF(D237=\"\", 0, VLOOKUP(D237,$D$375:$E$393,2)), D237)","v":0},{"$f":" E237*C237","v":0},false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[null,null,0,null,0,0,false,false]
[]
[null,null,null,"Post Bac","Total Semester Hours","Total Post Bac Quality Points","AMCAS Post Bac GPA","Running Overall GPA"]
[null,null,null,null,{"$f":"SUM(E237:E262)","v":0},{"$f":"SUM(F237:F262)","v":0},{"$f":" F265/IF(E265=0, 1, E265)","v":0},{"$f":" (F67+F105+F143+F181+F265)/IF((E105+E67+E143+E181+E265)=0, 1, (E105+E67+E143+E181+E265))","v":0}]
[]
[null,null,null,null,"BCPM Semester Hours","BCPM Quality Points","Post Bac BCPM GPA","Running BCPM GPA"]
[null,null,null,null,{"$f":"SUMIF($G$237:$G$262,TRUE,$E$237:$E$262)","v":0},{"$f":"SUMIF($G$237:$G$262,TRUE,$F$237:$F$262)","v":0},{"$f":" F268/IF(E268=0, 1, E268)","v":0},{"$f":" (F70+F108+F146+F184+F268)/IF((E108+E70+E146+E184+E268)=0, 1, (E108+E70+E146+E184+E268))","v":0}]
[]
[null,null,null,null,"All Other Hours","All Other Quality Points","All Other Post Bac GPA","Running All Other GPA"]
[null,null,null,null,{"$f":" E265-E268","v":0},{"$f":"F265-F268","v":0},{"$f":" F271/IF(E271=0, 1, E271)","v":0},{"$f":" (F73+F111+F149+F187+F271)/IF((E111+E73+E149+E187+E271)=0, 1, (E111+E73+E149+E187+E271))","v":0}]
[]
[]
[]
[]
[]
[]
["Cumulative Undergraduate + Post Bacc GPA"]
["Cumulative Hours Inc. Post Bac",null,null,"Cumulative Quality Points Inc. Post Bac",null,"Cumulative Undergraduate AMCAS GPA Inc. Post Bac"]
[{"$f":"SUM(E265,E181,E143,E105,E67)","v":0},null,null,{"$f":"SUM(F265,F181,F143,F105,F67)","v":0},null,{"$f":"D280/IF(A280=0, 1, A280)","v":0}]
[]
["Cumulative BCPM Hours Inc. Post Bac",null,null,"Cumulative BCPM Quality Points Inc. Post Bac",null,"Cumulative Undergraduate AMCAS BCPM GPA Inc. Post Bac"]
[{"$f":"SUM(E268,E184,E146,E108,E70)","v":0},null,null,{"$f":"SUM(F268,F184,F146,F108,F70)","v":0},null,{"$f":"D283/IF(A283=0, 1, A283)","v":0}]
[]
["Cumulative All Other Hours Inc. Post Bac",null,null,"Cumulative All Other Quality Points Inc. Post Bac",null,"Cumulative All Other Undergraduate AMCAS GPA Inc. Post Bac"]
[{"$f":"SUM(E271,E187,E149,E111,E73)","v":0},null,null,{"$f":"SUM(F271,F187,F149,F111,F73)","v":0},null,{"$f":"D286/IF(A286=0, 1, A286)","v":0},null,null,"All Data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Do not modify the information presented below!"]
[]
[]
["Letter Grade","AMCAS Grade Points",null,"AMCAS Quarter System Units","Semester Conversion "]
["Enter Grade",0,null,0.5,0.3]
["A",4,null,1,0.7]
["A-",3.7,null,1.5,1]
["A+",4,null,2,1.3]
["B",3,null,2.5,1.7]
["B-",2.7,null,3,2]
["B+",3.3,null,3.5,2.2999999999999998]
["C",2,null,4,2.7]
["C-",1.7,null,4.5,3]
["C+",2.2999999999999998,null,5,3.3]
["D",1,null,6,4]
["D-",0.7,null,7,4.7]
["D+",1.3,null,8,5.3]
["Enter Grade",0,null,9,6]
["F",0,null,10,6.7]
[null,null,null,12,8]
[null,null,null,15,10]
[null,null,null,20,13.3]
[null,null,null,"Enter Quarter Units",0]