{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,2,6,2],[14,0,14,1],[13,0,13,2],[2,0,2,1],[0,0,1,2],[3,0,3,1],[2,2,3,2]]}
["ADN Multicriteria Screening Calculator",null,null,"Current Licensure as LVN/ Respiratory Therapist/ Physical Therapist Assistant/ Occupational Therapy Aide"]
[null,null,null,"Current Allied Health Certification such as Phlebotomist/ Psychiatric Technician/ Paramedic/ EMT/ CNA/ Corpsman"]
["*This calculator should be used along with the ADN Multicriteria Screening Worksheet, which lists the criteria for qualifying for some of these point categories. You will also need to reference information on your completed Multicriteria Evaluation to use this caluclator. ",null,"Points","Relevant health care work or volunteer experience in a healthcare setting (100 hours within past 3 years)"]
["**INSTRUCTIONS: Beginning in the first grey box below, choose the appropriate answer from the drop down menu. *Typing directly into the cell and not using the drop down menu will result in an error in calculation. "]
["Do you have an academic degree that has been verified in section A of your Multicriteria Transcript Evaluation?",null,{"$f":"IF(B5=\"Yes\", 5, IF(B5=\"No\", 0, \"\"))","v":""},{"$f":"IF(B6=\"YES\", D1:D3, \"\")","v":""}]
[{"$f":"IF(B5<>\"\", \"Are you applying for points for recent work/volunteer experience?\", \"\")","v":""},null,{"$f":"IF(B6=\"No\", 0, IF(B7=\"Current Licensure as LVN/ Respiratory Therapist/ Physical Therapist Assistant/ Occupational Therapy Aide\", 5, IF(B7=\"Current Allied Health Certification such as Phlebotomist/ Psychiatric Technician/ Paramedic/ EMT/ CNA/ Corpsman\", 3, IF(B7=\"Relevant health care work or volunteer experience in a healthcare setting (100 hours within past 3 years)\", 2, \"\"))))","v":""}]
[{"$f":"IF(B6=\"Yes\", \"Which type of work/volunteer experience are you applying for (select one):\", IF(B6=\"No\", \"N/A\", \"\"))","v":""}]
[{"$f":"IF(B6<>\"\", \"Are you a Veteran?\", \"\")","v":""},null,{"$f":"IF(B8=\"Yes\", 10, IF(B8=\"No\", 0, \"\"))","v":""}]
[{"$f":"IF(B8<>\"\", \"Are you applying for points in the Life Experience/Special Circumstances category?\", \"\")","v":""},null,{"$f":"IF(B9=\"Yes\", 3, IF(B9=\"No\", 0, \"\"))","v":""}]
[{"$f":"IF(B9<>\"\", \"Are you applying for points for Proficiency or Advanced Level of Coursework in Language Other Than English?\", \"\")","v":""},null,{"$f":"IF(B10=\"Yes\", 2, IF(B10=\"No\", 0, \"\"))","v":""}]
[{"$f":"IF(B10<>\"\", \"Enter points from section F1 on your Multicriteria Tool Evaluation here:\", \"\")","v":""},null,{"$f":"B11","v":0}]
[{"$f":"IF(B11<>\"\", \"Enter points from section G1 on your Multicriteria Tool Evaluation here:\", \"\")","v":""},null,{"$f":"B12","v":0}]
[{"$f":"IF(B12<>\"\", \"Completion of Nursing Support Courses: Enter points from section G on your Multicriteria Tool Evaluation here: or Equivalent (select a point value):\", \"\")","v":""},null,{"$f":"B13","v":0}]
["I understand that the points shown on this calculator are unofficial and that my official points are determined by the ADN Verification Committee.  I also understand that I must meet all requirements for points as outlined in the ADN Multicriteria Screening Worksheet and submit all required documentation fully completed to qualify for the points indicated here. "]
["SUM Phase 1 Points: ",null,{"$f":"SUM(C5:C13)","v":0}]