{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Intro","Scales","Assess","Assess2","Lists","Chart","ChartData","Export"],"not_rendered":{"charts":1,"images":6,"macros":1,"external_links":1,"defined_names":16,"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":"Intro","index":0,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,28,2],[3,1,25,9],[1,1,2,13],[3,11,3,13],[5,11,7,12],[26,4,29,6]]}
[]
[null,"Summary Higher Education Risk Assessment"]
[]
[null,"Welcome to the Summary Higher Education Risk Assessment workbook.   This workbook will help you consider your campus' risk portfolio for a specified list of the most common risks in Higher Education.  This workbook will not make decisions for you, but it will help you organize your thinking as you consider your campus' risk profile and related enterprise risk managment implications. \n\nIdentify the following for each set of objectives and identified risks:\n■ Estimated impact and likelihood of each identified risk by objective type\n■ Controls used to mitigate identified risks\n■ Frequency and effectiveness of the compensating controls\n■ Strategies used to monitor control activities, such as reports and dashboards\n■ Individual/department(s) responsible for executing the strategies identified\n\nBefore you begin, please complete the identifying information at the top of this page and save this workbook in a secure location with an appropriate, unique name. This will minimize confusion if multiple workbooks are completed. Use the button below to get started. Also, be sure to document the scale parameters used completing this workbook on the tab provided. When you have completed the worksheet, you may export the data into a new workbook and save your information in comma separated value file (.csv) for use in the University's Enterprise Risk Management Information System (ERMIS) by coming back to this page and selecting the \"Export\" button when you're done.",null,null,null,null,null,null,null,null,null,"Project Information"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Project Name:","Ines Detomana"]
[null,null,null,null,null,null,null,null,null,null,null,"Names and titles of person(s) completing this workbook:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"UC Location:","Office of the President"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Department/College:","UC Education Abroad Program"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Date workbook completed:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"All done? Click here to export your data to an ERMIS-compatible .csv format."]
[null,"Get Started!"]

{"sheet":"Scales","index":1,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,4,2,5],[11,4,11,5],[20,4,20,5],[0,1,1,2]]}
[null,"Setting Common Parameters"]
[]
[null,null,null,null,"Risk Impact"]
[null,null,null,null,"Scale","Definition"]
[null,null,null,null,"Very high","Loss of multiple lives;  extensive permanent disabling injuries or illness requiring evacuation; long-term incarceration or denial of freedom; Losses greater than $100,000; Public embarrassment, high wide-spread news profile, third party actions; Loss of accreditation; Termination of program; Loss of demand for services",15]
[null,null,null,null,"High","Loss of a life;  major injuries or illness requiring hospitalization; short-term incarceration or denial of freedom; Losses between $50,000 and $100,000; Public embarrassment, high news profile, third party actions; Probation by accrediting agency; Disruption of program up to 1 month; Major decline in demand for services",12]
[null,null,null,null,"Moderate","Injuries requiring medical attention; Delays over 1 week inconveniencing travelers; Losses between $5,000 and $50,000; Public embarrassment, moderate news profile; Failure to meet one or more accreditation standards; Disruption of program up to 1 week; Noticeable decline in demand for services",9]
[null,null,null,null,"Low","Injuries requiring first aid; Minor delays to travelers of 2 to 3 days; Losses between $0 and $5,000; Low news profile; Weakness in meeting one or more accreditation standards; Disruption of program up to 1 day; Minor effect on demand for services",6]
[null,null,null,null,"Very low","No injuries; Minor delays to travelers of up to 1 day; No dollar loss; No news items",3]
[null,null,null,null,"Unsure/Don't Know",null,7.5]
[]
[null,null,null,null,"Risk Likelihood"]
[null,null,null,null,"Scale","Definition"]
[null,null,null,null,"Very high","Expected to occur daily",10]
[null,null,null,null,"High","Will probably occur weekly",8]
[null,null,null,null,"Moderate","Might occur monthly",6]
[null,null,null,null,"Low","Could occur yearly",4]
[null,null,null,null,"Very low","May occur in exceptional circumstances > 1 year",2]
[null,null,null,null,"Unsure/Don't Know",null,5]
[]
[null,null,null,null,"Control Effectiveness"]
[null,null,null,null,"Scale","Definition"]
[null,null,null,null,"Nearly complete","Always or almost always having an effect",0.95]
[null,null,null,null,"Significant","having or likely to have influence or effect: important",0.9]
[null,null,null,null,"Substantial","ample to satisfy; being largely but not wholly what is specified",0.75]
[null,null,null,null,"Moderate","tending toward the average; limited in scope or effect",0.6]
[null,null,null,null,"Minor","comparitively unimportant",0.3]
[null,null,null,null,"Minimal","barely adequate",0.1]
[null,null,null,null,"None","not any; no effect",0]
[null,null,null,null,"Unsure/Don't Know",null,0]

{"sheet":"Assess","index":2,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[7,1,7,2],[2,1,5,2]]}
[]
[null,"Instructions:"]
[null,"Please review the list of risks below and consider the estimated impact and likelihood for each event, taking into consideration the potential impact on the strategic, financial, operational, compliance, reputational and reporting goals of your organization."]
[]
[]
[]
[]
[null,"Strategic Risks",null,"Potential Consequences \nof Control Failure","Impact","Likelihood","Current Management and Mitigation","Existing Control Effectiveness","Risk Rating","Show on Chart?"]
[null,"A","Students contract vaccine preventable diseases: Yellow Fever, Hepatitis A & B, Typhoid, Meningococcal (Meningitis), Rabies, Polio","Loss of program benefits, serious illness, death","High","Moderate","Students expected to follow CDC vaccine recommendations","Minor",{"$f":"P9","v":"Under-controlled"},"Yes",null,{"$f":"IF(E9=\"\",\"\",VLOOKUP(E9,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F9=\"\",\"\",VLOOKUP(F9,Scales!$E$14:$G$19,3,FALSE))","v":6},{"$f":"IF(H9=\"\",\"\",VLOOKUP(H9,Scales!$E$23:$G$30,3,FALSE))","v":0.3},{"$f":"IF(L9=\"\",\"\",IF(M9=\"\",\"\",IF(N9=\"\",\"\",(L9+M9)*(1-N9))))","v":12.6},{"$f":"IF(O9=\"\",\"\",VLOOKUP(O9,Lists!$A$40:$B$290,2,FALSE))","v":"Under-controlled"}]
[null,"B","Meningitis - Students with risk factors for Meningitis (poor overall health, prior infection, birth defect in the skull, a head injury or brain surgery, previous infections such as upper respiratory or Lyme disease, cochlear implant; impaired immune system","Serious illness (Meningococcal disease is an acute bacterial infection characterized by sudden onset with fever, intense headache, nausea, vomiting, stiff neck, and, frequently, a rash with pink spots)","High","Moderate","1) All EAP students are required to complete the online UCEAP Travel Health Certification course through MyEAP and strongly encouraged to follow through about vaccine recommendations with a travel health professional.  2) Avoid close human contact in crowded areas. 3) Frequent hand washing with soap and water.","Moderate",{"$f":"P10","v":"Potentially under-controlled"},"Yes",null,{"$f":"IF(E10=\"\",\"\",VLOOKUP(E10,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F10=\"\",\"\",VLOOKUP(F10,Scales!$E$14:$G$19,3,FALSE))","v":6},{"$f":"IF(H10=\"\",\"\",VLOOKUP(H10,Scales!$E$23:$G$30,3,FALSE))","v":0.6},{"$f":"IF(L10=\"\",\"\",IF(M10=\"\",\"\",IF(N10=\"\",\"\",(L10+M10)*(1-N10))))","v":7.2},{"$f":"IF(O10=\"\",\"\",VLOOKUP(O10,Lists!$A$40:$B$290,2,FALSE))","v":"Potentially under-controlled"}]
[null,"C","Malaria - Students with risk factors for Malaria (stopping or not adhering to prophylaxis, not taking personal protective measures, using substandard drugs purchased over seas, not follow-up if symptoms occur)","Students could get critically sick, temporarily or permanently","Very high","Very high","Recommendations for prevention of malaria must be individualized.  1) Students are required to complete the UCEAP Online Travel Health Education Certification course and strongly recommended to meet with a travel health specialist after the course to understand the health risks, get necessary medication based on length of stay and current medical condition, and learn how diseases are transmitted.  2) Students advised to spray insecticide on walls; use a pyrethroid-containing flying-insect spray in living and sleeping areas; understand behaviors to minimize exposure to mosquitoes; wear barrier clothing; use insecticide-impregnated bed nets; spray residence; take an appropriate antimalarial drug regimen exactly as prescribed and carefully following antimosquito measures. 3) Students sign a mandatory Malaria Prophylaxis Agreement form. Students who do not comply may be dismissed.  3) EAP student health insurance provides adequate coverage and medical evacuation benefits. 4) UCEAP insurance coverage includes 100% coverage for prophylaxis.  5) Students told to continue taking the medication as recommended after leaving the malaria-risk area. ","Substantial","Potentially under-controlled","Yes",null,{"$f":"IF(E11=\"\",\"\",VLOOKUP(E11,Scales!$E$5:$G$10,3,FALSE))","v":15},{"$f":"IF(F11=\"\",\"\",VLOOKUP(F11,Scales!$E$14:$G$19,3,FALSE))","v":10},{"$f":"IF(H11=\"\",\"\",VLOOKUP(H11,Scales!$E$23:$G$30,3,FALSE))","v":0.75},6.25,{"$f":"IF(O11=\"\",\"\",VLOOKUP(O11,Lists!$A$40:$B$290,2,FALSE))","v":"Potentially under-controlled"}]
[null,"D","Parasitic Infection - Students contract parasitic infections (consuming or exposure to contaminated water by drinking, swimming or bathing) for which no vaccines or preventive drugs are available","Schistosoma parasites can penetrate the skin of persons who are wading, swimming, bathing, or washing in contaminated water. Within several weeks, worms grow inside the blood vessels of the body and produce eggs. Some of these eggs travel to the bladder or intestines and are passed into the urine or stool.  Occasionally, eggs may be deposited in the brain or spinal cord, leading to seizures or paralysis.","Very high","Very high","Students advised to avoid 1) swimming or wading in freshwater; 2) drink safe water; either boil water for 1 minute or filter water before drinking. Iodine treatment alone WILL NOT GUARANTEE that water is safe and free of all parasites. 3) If a student accidentally come into contact with fresh water, vigorous towel drying after a very brief water exposure may help to prevent the Schistosoma parasite from penetrating the skin. Students should NOT rely on vigorous towel drying to prevent Schistosomiasis","Substantial","Potentially under-controlled","Yes",null,{"$f":"IF(E12=\"\",\"\",VLOOKUP(E12,Scales!$E$5:$G$10,3,FALSE))","v":15},{"$f":"IF(F12=\"\",\"\",VLOOKUP(F12,Scales!$E$14:$G$19,3,FALSE))","v":10},{"$f":"IF(H12=\"\",\"\",VLOOKUP(H12,Scales!$E$23:$G$30,3,FALSE))","v":0.75},6.25,{"$f":"IF(O12=\"\",\"\",VLOOKUP(O12,Lists!$A$40:$B$290,2,FALSE))","v":"Potentially under-controlled"}]
[null,"E","Rabies - a preventable and acute viral disease of the central nervous system, most often transmitted through the bite of a rabid animal.","The disease is nearly always fatal when the person begins showing symptoms (fever, headache, agitation, anxiety, confusion, difficulty swallowing, excessive salivation, hydrophobia, hallucinations, insomnia and partial paralysis","Very high","Moderate","The risk of rabies in an encounter with an animal and the precautions necessary to prevent rabies are the same as they are in the United States.  Students are told to consult with a health care professional after the required UCEAP online Travel Health Education Certification course.  Consider getting a rabies vaccine if your activities will put you in contact with animals (approximately $160 at UC Student Health Services).  Avoid approaching any wild or domestic animals.  Avoid all contact with animals, especially stray dogs and cats.  If bitten or scratched, wash the wound immediately with soap and water (and povidone iodine, if available); seek medical attention immediately to determine if mediation or anti-rabies vaccine is needed. Immediate local treatment will substantially reduce the risk of rabies.  Treat any bite from a potentially rabid animal as a medical emergency.","Substantial","Potentially under-controlled","Yes",null,{"$f":"IF(E13=\"\",\"\",VLOOKUP(E13,Scales!$E$5:$G$10,3,FALSE))","v":15},{"$f":"IF(F13=\"\",\"\",VLOOKUP(F13,Scales!$E$14:$G$19,3,FALSE))","v":6},{"$f":"IF(H13=\"\",\"\",VLOOKUP(H13,Scales!$E$23:$G$30,3,FALSE))","v":0.75},5.25,{"$f":"IF(O13=\"\",\"\",VLOOKUP(O13,Lists!$A$40:$B$290,2,FALSE))","v":"Potentially under-controlled"}]
[null,"F","Insect Precautions – Many serious diseases transmitted by insects require careful avoidance and use of protective measures as there are no immunizations and medications. Travelers visiting rural areas or engaging in camping, hiking or adventure travel are at the greatest risk of exposure to mosquitoes, ticks, mites, fleas and other disease-carrying insects, but even urban visitors need to take precautions to avoid insect exposure in some areas.","Students contract insect borne diseases (Dengue fever, Leishmaniasis, Malaria); Students injured by exposure to toxic insect repellants; Condition of student with serious illness or injury made worse by substandard medical treatment; Medical treatment withheld because student does not have cash to pay for services","High","Moderate","Students instructed to cover as much skin as possible; perform body tick checks daily; sleep in protected areas with screens or air conditioning or use a permethrin-impregnated sleeping bed nets; eliminate any mosquitoes from inside rooms and sleeping areas prior to retiring. Insecticide sprays may be used to clear rooms of mosquitoes, but coils should be only used outdoors. ","Significant","Adequately controlled","Yes",null,{"$f":"IF(E14=\"\",\"\",VLOOKUP(E14,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F14=\"\",\"\",VLOOKUP(F14,Scales!$E$14:$G$19,3,FALSE))","v":6},{"$f":"IF(H14=\"\",\"\",VLOOKUP(H14,Scales!$E$23:$G$30,3,FALSE))","v":0.9},1.7999999999999996,{"$f":"IF(O14=\"\",\"\",VLOOKUP(O14,Lists!$A$40:$B$290,2,FALSE))","v":"Adequately controlled"}]
[null,"G","Food/Water Safety - Students consume unsafe food and/or water contaminated with toxins or diseases  Local water supplies are limited and contaminated with raw sewage, pesticides and industrial waste.  Some types of fish may contain poisonous biotoxins even when cooked. ","Illness (serious or mild); death; medical evacuation","High","High","Students are instructed to drink only known brands of bottled water that have not been tampered with; eat in well-established, clean restaurants; eat only well-cooked food served hot; avoid salads, buffets, and cooked foods that have been left at room temperature; not eat fruits or vegetables unless they have been peeled or cooked; avoid cooked foods that are no longer piping hot; avoid buying food from street vendors; not drink tap water (unless boiled, filtered, or chemically disinfected) or unbottled beverages or drinks with ice; avoid unpasteurized milk and dairy products such as ice cream; and not eat raw or undercooked meat or fish. ","Moderate","Potentially under-controlled","Yes",null,{"$f":"IF(E15=\"\",\"\",VLOOKUP(E15,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F15=\"\",\"\",VLOOKUP(F15,Scales!$E$14:$G$19,3,FALSE))","v":8},{"$f":"IF(H15=\"\",\"\",VLOOKUP(H15,Scales!$E$23:$G$30,3,FALSE))","v":0.6},8,{"$f":"IF(O15=\"\",\"\",VLOOKUP(O15,Lists!$A$40:$B$290,2,FALSE))","v":"Potentially under-controlled"}]
[null,"H","Medical Facilities - Students seriously sick and requiring hospitalization do not get needed care or receive substandard care; medical facilities are limited in Accra and may be nonexistent elsewhere; most doctors and hospitals expect payment in cash, regardless of travel health insurance.  Differing cultural expectations in Ghana affect care. ","Illness (serious or mild); death; medical evacuation; students unable to receive needed medication","High","High","1) The EAP student health insurance adequately covers medical evacuation from Ghana.2) Europ Assistance, UCEAP Travel Assistance provider can refer students to local medical facilities and can guarantee payment of services directly.  3) The U.S. Embassy has on their website a list of medical services providers. 4) Students need to be prepared for the inevitable cultural differences in medical services and find out in advance whether any particular care needed is available.  5) Prescription medications are often not available so students may want to consider bringing a sufficient supply. 6) Students and their families should inform themselves about health management while in Ghana and discuss health options with their health care provider.  7) Students with chronic health conditions, need to consult carefully with a physician in the U.S. before departure. 8)  Access to a freezer/refrigerator for some medical equipment/medication may be difficult as electricity is sporadic throughout Ghana. The student dorms are not equipped with fridges or freezers. 9) The UC Study Center staff is present to assist students if they get sick or injured.  10) Students should complete all routine and required medical exams before coming to Accra and obtain all required and recommended immunization. 11) Students should refer to the U.S. Department of State website and 12) follow advice acquired during the Online UCEAP Travel Health Certification course.","Significant","Adequately controlled","Yes",null,{"$f":"IF(E16=\"\",\"\",VLOOKUP(E16,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F16=\"\",\"\",VLOOKUP(F16,Scales!$E$14:$G$19,3,FALSE))","v":8},{"$f":"IF(H16=\"\",\"\",VLOOKUP(H16,Scales!$E$23:$G$30,3,FALSE))","v":0.9},1.9999999999999996,{"$f":"IF(O16=\"\",\"\",VLOOKUP(O16,Lists!$A$40:$B$290,2,FALSE))","v":"Adequately controlled"}]
[null,"I","Mental Health - Students with recent or ongoing mental health concerns fail to document in advance of the EAP health clearance and travel, her/his condition and detailed plan for continuing care while away. ","Student receives inadequate or inappropriate medication; condition is exacerbated due to lack of care","Moderate","Moderate","The EAP student health insurance covers outpatient counseling up to 30 visits.  If students will need care, the U.S. Embassy provides a list of counselors and can help UC Study Center staff to establish contact to provide confidential treatment.  If a student is seeing a counselor/therapist in the U.S., the student should consult carefully about health and medication management before departure.  Student should bring adequate supply of prescription medication to last through the stay along with a doctor’s prescription and a letter indicating condition. Students need to be prepared for the inevitable cultural differences in medical services. Students who need a particular type of medical care should find out in advance whether such care is available. Students should discuss options with their health care provider.","Significant","Adequately controlled","Yes",null,{"$f":"IF(E17=\"\",\"\",VLOOKUP(E17,Scales!$E$5:$G$10,3,FALSE))","v":9},{"$f":"IF(F17=\"\",\"\",VLOOKUP(F17,Scales!$E$14:$G$19,3,FALSE))","v":6},{"$f":"IF(H17=\"\",\"\",VLOOKUP(H17,Scales!$E$23:$G$30,3,FALSE))","v":0.9},1.4999999999999996,{"$f":"IF(O17=\"\",\"\",VLOOKUP(O17,Lists!$A$40:$B$290,2,FALSE))","v":"Adequately controlled"}]
[null,"J","Illicit drugs - the unlawful possession, use, or distribution of alcohol by students or employees on University of Ghana premises or as part of any University of Ghana activities is prohibited.","The possession of, distribution, or use of drugs is a crime in Ghana.  The unlawful possession, use, or distribution of alcohol by students or employees on University/College premises or as part of any University/College activities is prohibited. Anyone found in possession of or using such drugs on University property will be severely dealt with and suspended from the University, in addition to facing criminal charges.  Persons violating Ghanaian laws, even unknowingly, may be expelled, arrested, or imprisoned.  Penalties for possessing, using, or trafficking in illegal drugs in Ghana are severe, and convicted offenders can expect long jail sentences and heavy fines.  The use of illegal drugs procured in Ghana may have life-threatening consequences. There have been several deaths of U.S. citizens resulting from the use of narcotics procured locally. ","High","Moderate","Students must decide to act responsibly.   University of Ghana expects students to comport themselves in a manner consistent with University policy and that they must conduct themselves in a lawful manner at all times.  Violation of University of Ghana and University of California policies subjects students to disciplinary procedures.  Violation of country laws exposes the student to criminal charges and/or arrest.","Substantial","Adequately controlled","No",null,{"$f":"IF(E18=\"\",\"\",VLOOKUP(E18,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F18=\"\",\"\",VLOOKUP(F18,Scales!$E$14:$G$19,3,FALSE))","v":6},{"$f":"IF(H18=\"\",\"\",VLOOKUP(H18,Scales!$E$23:$G$30,3,FALSE))","v":0.75},4.5,{"$f":"IF(O18=\"\",\"\",VLOOKUP(O18,Lists!$A$40:$B$290,2,FALSE))","v":"Adequately controlled"}]
[null,"K","Road Safety - Road traffic accidents may be one of the main threats facing students.  Roads are mainly in a poor condition, particularly in rural areas.  Road travel can be extremely hazardous due to poor driving practices, poorly maintained vehicles, insufficient street lighting, roaming livestock, pedestrians and cyclists.  Safety standards on small private buses and taxis are often low and do not meet US standards","Travel to tourist and historic areas of the country is popular and generally safe, although incidents of machete robberies occur on rural roads. There are occasional reports of clashes between government forces and bandits; however, foreigners are normally not affected.\n","High","High","Students should avoid traveling by road outside the main towns after dark, when the risk of accidents and robbery is greater.  Students should check with local staff before venturing off main roads in outlying areas.  Due to poor driving conditions and the poor mechanical state of many vehicles in Ghana, that vehicular travel after dark outside Accra should be avoided","Moderate","Potentially under-controlled","Yes",null,{"$f":"IF(E19=\"\",\"\",VLOOKUP(E19,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F19=\"\",\"\",VLOOKUP(F19,Scales!$E$14:$G$19,3,FALSE))","v":8},{"$f":"IF(H19=\"\",\"\",VLOOKUP(H19,Scales!$E$23:$G$30,3,FALSE))","v":0.6},8,{"$f":"IF(O19=\"\",\"\",VLOOKUP(O19,Lists!$A$40:$B$290,2,FALSE))","v":"Potentially under-controlled"}]
[null,"L","Tro Tro Accidents - Tro-Tros are the cheapest way to get around Accra.  Tro-tros are usually made from converted minibuses and are designed to fit as many people, possessions, and occasionally livestock, as possible.","Tro-tro accidents are quite common due to unidentified speed limits, disregard of stop signs and lack of general defensive driving.  Informal and loosely regulated routes engender fierce competition and reckless driving that injures, and sometimes kills, thousands of passengers, pedestrians and cyclists every year.","High","High","Do not travel by tro-tros, especially when it is dark.","Moderate","Potentially under-controlled","Yes",null,{"$f":"IF(E20=\"\",\"\",VLOOKUP(E20,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F20=\"\",\"\",VLOOKUP(F20,Scales!$E$14:$G$19,3,FALSE))","v":8},{"$f":"IF(H20=\"\",\"\",VLOOKUP(H20,Scales!$E$23:$G$30,3,FALSE))","v":0.6},8,{"$f":"IF(O20=\"\",\"\",VLOOKUP(O20,Lists!$A$40:$B$290,2,FALSE))","v":"Potentially under-controlled"}]
[null,"M","Taxis - Criminals sometimes use taxis to rob patrons.","The operation of streetlights in Ghana at night is inconsistent and dark areas become prime targets for criminals.  The potential for carjacking exists in Ghana and there have been some reported armed robberies and snatching of taxis from drivers.","Moderate","Moderate","The Accra Metropolitan Assembly (AMA) requires all taxi drivers to wear a sea blue shirt and dark blue trousers as their uniform.  Also, drivers are required to register their vehicles with the Assembly to get a special serial number consisting of only three digits to be embossed with reflectors on both sides of the front doors to make identification easy even at night. This measure has been implemented to further enhance security for both taxi patrons and owners.  Students are told to exercise caution when traveling in taxis.  Students should confirm that the taxi has sufficient gas before hiring it, because drivers will lure taxi occupants to gas stations to be robbed by awaiting criminals.  Never board a taxi with all male occupants already in or a female passenger and two male passengers as they could be decoys.","Substantial","Adequately controlled","Yes",null,{"$f":"IF(E21=\"\",\"\",VLOOKUP(E21,Scales!$E$5:$G$10,3,FALSE))","v":9},{"$f":"IF(F21=\"\",\"\",VLOOKUP(F21,Scales!$E$14:$G$19,3,FALSE))","v":6},{"$f":"IF(H21=\"\",\"\",VLOOKUP(H21,Scales!$E$23:$G$30,3,FALSE))","v":0.75},3.75,{"$f":"IF(O21=\"\",\"\",VLOOKUP(O21,Lists!$A$40:$B$290,2,FALSE))","v":"Adequately controlled"}]
[null,"N","Ghanaian law criminalizes homosexuality.  A large portion of Ghanaian society does not accept that such activity exists.  A gay social life exists, mostly in the form of house parties, and a few queer-friendly clubs in Accra, but there are risks.","There is a minimum misdemeanor charge for homosexual activity.  Lesbians and gays face widespread discrimination, as well as police harassment and extortion attempts.  There is a small gay community.  There is a lot of stigma towards gay men and lesbians living in Ghana","High","Low","Further information is available from the Gay and Lesbian Association of Ghana or Behind the Mask (http://www.mask.org.za/index.php?page=home)","Substantial","Adequately controlled","Yes",null,{"$f":"IF(E22=\"\",\"\",VLOOKUP(E22,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F22=\"\",\"\",VLOOKUP(F22,Scales!$E$14:$G$19,3,FALSE))","v":4},{"$f":"IF(H22=\"\",\"\",VLOOKUP(H22,Scales!$E$23:$G$30,3,FALSE))","v":0.75},4,{"$f":"IF(O22=\"\",\"\",VLOOKUP(O22,Lists!$A$40:$B$290,2,FALSE))","v":"Adequately controlled"}]
[null,"O","Non-Violent Crime - Street theft is the most common; Street persons asking for handouts may grab jewelry or other items from one's neck or wrist, or distract the victim for a pickpocket; criminals will sometimes use motorcycles to drive by unsuspecting pedestrians and snatch their bags.  Theft of unattended property is common in Ghana.","Loss of property","Moderate","High","Students are advised to be constantly aware of their surroundings, especially in crowded streets and shopping/market areas;  never venture out alone; use the buddy system; go in groups; proceed to a location where help is available if afraid; monitor the media for information about new safety or security risks; stay in well-lit areas; carry only necessary credit cards and money, not air tickets; act suspicious if followed; never hitchhike; be discreet; avoid uncontrolled crowds; look confident and do not wander into unknown areas. Exercise caution; do not accept lifts or drinks from strangers; ensure others know whereabouts;  use safest route to destination; lock up valuables; keep a vigilant eye on property; carry money in several locations; trust instincts; protect cell phones; ask Study Center staff for advice; and read the U.S. Department of State, Country Specific Information on Ghana UCEAP insurance covers personal property up to a certain amount.  Students are advised to supplement coverage if UCEAP benefit is inadequate based on her personal belongings.","Substantial","Adequately controlled","Yes",null,{"$f":"IF(E23=\"\",\"\",VLOOKUP(E23,Scales!$E$5:$G$10,3,FALSE))","v":9},{"$f":"IF(F23=\"\",\"\",VLOOKUP(F23,Scales!$E$14:$G$19,3,FALSE))","v":8},{"$f":"IF(H23=\"\",\"\",VLOOKUP(H23,Scales!$E$23:$G$30,3,FALSE))","v":0.75},4.25,{"$f":"IF(O23=\"\",\"\",VLOOKUP(O23,Lists!$A$40:$B$290,2,FALSE))","v":"Adequately controlled"}]
[null,"P","Violent Crime - includes muggings carried out by groups of men; armed robbery using machetes or handguns; Home invasions by criminals who are sometimes armed;","Loss of life; Serious injury","High","Moderate","If confronted by would-be assailants, comply.  There have been several incidents where people have resisted trying to hang on to their purse/bag, or it was perceived as resistance and they were seriously injured.  See \"O\" above.","Substantial","Adequately controlled","Yes",null,{"$f":"IF(E24=\"\",\"\",VLOOKUP(E24,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F24=\"\",\"\",VLOOKUP(F24,Scales!$E$14:$G$19,3,FALSE))","v":6},{"$f":"IF(H24=\"\",\"\",VLOOKUP(H24,Scales!$E$23:$G$30,3,FALSE))","v":0.75},4.5,{"$f":"IF(O24=\"\",\"\",VLOOKUP(O24,Lists!$A$40:$B$290,2,FALSE))","v":"Adequately controlled"}]
[null,"Q","The Ghanaian Police Service (GPS) is almost solely a reactive force and demonstrates moderate proactive techniques to deter criminals. Police often lack the equipment, resources, training, and personnel to respond to calls for assistance or other emergencies. The police have a poor record of investigating and solving serious crimes.","Loss of life; Serious injury; Loss of property","High","Moderate","If confronted by would-be assailants, comply.  There have been several incidents where people have resisted trying to hang on to their purse/bag, or it was perceived as resistance and they were seriously injured.  See \"O\" above.",null,"","Yes",null,{"$f":"IF(E25=\"\",\"\",VLOOKUP(E25,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F25=\"\",\"\",VLOOKUP(F25,Scales!$E$14:$G$19,3,FALSE))","v":6},{"$f":"IF(H25=\"\",\"\",VLOOKUP(H25,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O25=\"\",\"\",VLOOKUP(O25,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"R","Credit card skimming is especially prevalent in Ghana.  ","Loss of property; credit card not valid when needed","High","Moderate","Students advised to limit purchases or cash advances using credit cards; not allow anyone to take your credit card out of your sight; use credit cards only in reputable restaurants or shops; ask to be present during the transaction process; retain and destroy all receipts and carbons; keep accurate records of any transactions; and notify your bank’s fraud department immediately if you suspect fraudulent charges.",null,"","No",null,{"$f":"IF(E26=\"\",\"\",VLOOKUP(E26,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F26=\"\",\"\",VLOOKUP(F26,Scales!$E$14:$G$19,3,FALSE))","v":6},{"$f":"IF(H26=\"\",\"\",VLOOKUP(H26,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O26=\"\",\"\",VLOOKUP(O26,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"S","Crime on Campus - The campus is extremely large and there are numerous points of entry beyond the official, guarded gates.  Lighting on certain parts of the campus is substandard.  ","Student injury or death; Loss of property; Student activity in violation of campus policy and Ghanaian law may result in both internal and external judicial action being taken. The Dean of Students initiates disciplinary action in accordance with the University Statutes for violators who are students. Cases of incidents involving international students are initially dealt with by a specific committee of inquiry constituted by the Office of the Dean of International Programs.","High","Moderate","Primary responsibility for security on campus resides with the University Security Office of the University. The University Security services enforce order, protect life and property, make arrests as provided by law, conduct investigations, and exercise powers similar to the police. University Security is on duty 24 hours a day, 365 days a year and in constant communication with the main Security centre.  The University security guards patrol the exterior areas of the campus, twenty-four hours a day. In some cases, additional regular tours of the interior of the residence halls to check lounges, corridors and other common residence areas are carried out. Guards, assisted by Porters or other resident staff members, may confront residents and visitors suspected of violations of University policy.  Students are advised of safety rules and best practices",null,"","No",null,{"$f":"IF(E27=\"\",\"\",VLOOKUP(E27,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F27=\"\",\"\",VLOOKUP(F27,Scales!$E$14:$G$19,3,FALSE))","v":6},{"$f":"IF(H27=\"\",\"\",VLOOKUP(H27,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O27=\"\",\"\",VLOOKUP(O27,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"T","Legal Considerations - Photography at airports, railway stations, naval bases, air bases, military installations, public water and energy plants, police stations, harbors, mines and bridges is prohibited in Ghana.","Laws are strictly enforced and all restrictions should be observed;  Students could be fined or jailed.","High","High","Risk is preventable. Awareness of the laws is the key to avoiding trouble.  Foreigners are more likely to be at risk than locals.  Students should research the legal system in Ghana to be aware of penalties and other laws, e.g., laws relating to drugs/alcohol, sexuality; severity of punishment for crimes; nature of the legal system; obtaining legal assistance.",null,"","No",null,{"$f":"IF(E28=\"\",\"\",VLOOKUP(E28,Scales!$E$5:$G$10,3,FALSE))","v":12},{"$f":"IF(F28=\"\",\"\",VLOOKUP(F28,Scales!$E$14:$G$19,3,FALSE))","v":8},{"$f":"IF(H28=\"\",\"\",VLOOKUP(H28,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O28=\"\",\"\",VLOOKUP(O28,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"U",null,null,null,null,null,null,"","No",null,{"$f":"IF(E29=\"\",\"\",VLOOKUP(E29,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F29=\"\",\"\",VLOOKUP(F29,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H29=\"\",\"\",VLOOKUP(H29,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O29=\"\",\"\",VLOOKUP(O29,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"V",null,null,null,null,null,null,"","No",null,{"$f":"IF(E30=\"\",\"\",VLOOKUP(E30,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F30=\"\",\"\",VLOOKUP(F30,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H30=\"\",\"\",VLOOKUP(H30,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O30=\"\",\"\",VLOOKUP(O30,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"W",null,null,null,null,null,null,"","No",null,{"$f":"IF(E31=\"\",\"\",VLOOKUP(E31,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F31=\"\",\"\",VLOOKUP(F31,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H31=\"\",\"\",VLOOKUP(H31,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O31=\"\",\"\",VLOOKUP(O31,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"X",null,null,null,null,null,null,"","No",null,{"$f":"IF(E32=\"\",\"\",VLOOKUP(E32,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F32=\"\",\"\",VLOOKUP(F32,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H32=\"\",\"\",VLOOKUP(H32,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O32=\"\",\"\",VLOOKUP(O32,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"Y",null,null,null,null,null,null,"","No",null,{"$f":"IF(E33=\"\",\"\",VLOOKUP(E33,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F33=\"\",\"\",VLOOKUP(F33,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H33=\"\",\"\",VLOOKUP(H33,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O33=\"\",\"\",VLOOKUP(O33,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"Z",null,null,null,null,null,null,"","No",null,{"$f":"IF(E34=\"\",\"\",VLOOKUP(E34,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F34=\"\",\"\",VLOOKUP(F34,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H34=\"\",\"\",VLOOKUP(H34,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O34=\"\",\"\",VLOOKUP(O34,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"AA",null,null,null,null,null,null,"","No",null,{"$f":"IF(E35=\"\",\"\",VLOOKUP(E35,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F35=\"\",\"\",VLOOKUP(F35,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H35=\"\",\"\",VLOOKUP(H35,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O35=\"\",\"\",VLOOKUP(O35,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"BB",null,null,null,null,null,null,"","No",null,{"$f":"IF(E36=\"\",\"\",VLOOKUP(E36,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F36=\"\",\"\",VLOOKUP(F36,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H36=\"\",\"\",VLOOKUP(H36,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O36=\"\",\"\",VLOOKUP(O36,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"CC",null,null,null,null,null,null,"","No",null,{"$f":"IF(E37=\"\",\"\",VLOOKUP(E37,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F37=\"\",\"\",VLOOKUP(F37,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H37=\"\",\"\",VLOOKUP(H37,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O37=\"\",\"\",VLOOKUP(O37,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"DD",null,null,null,null,null,null,"","No",null,{"$f":"IF(E38=\"\",\"\",VLOOKUP(E38,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F38=\"\",\"\",VLOOKUP(F38,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H38=\"\",\"\",VLOOKUP(H38,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O38=\"\",\"\",VLOOKUP(O38,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"EE",null,null,null,null,null,null,"","No",null,{"$f":"IF(E39=\"\",\"\",VLOOKUP(E39,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F39=\"\",\"\",VLOOKUP(F39,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H39=\"\",\"\",VLOOKUP(H39,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O39=\"\",\"\",VLOOKUP(O39,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"FF",null,null,null,null,null,null,"","No",null,{"$f":"IF(E40=\"\",\"\",VLOOKUP(E40,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F40=\"\",\"\",VLOOKUP(F40,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H40=\"\",\"\",VLOOKUP(H40,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O40=\"\",\"\",VLOOKUP(O40,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"GG",null,null,null,null,null,null,"","No",null,{"$f":"IF(E41=\"\",\"\",VLOOKUP(E41,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F41=\"\",\"\",VLOOKUP(F41,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H41=\"\",\"\",VLOOKUP(H41,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O41=\"\",\"\",VLOOKUP(O41,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"HH",null,null,null,null,null,null,"","No",null,{"$f":"IF(E42=\"\",\"\",VLOOKUP(E42,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F42=\"\",\"\",VLOOKUP(F42,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H42=\"\",\"\",VLOOKUP(H42,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O42=\"\",\"\",VLOOKUP(O42,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"II",null,null,null,null,null,null,"","No",null,{"$f":"IF(E43=\"\",\"\",VLOOKUP(E43,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F43=\"\",\"\",VLOOKUP(F43,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H43=\"\",\"\",VLOOKUP(H43,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O43=\"\",\"\",VLOOKUP(O43,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"JJ",null,null,null,null,null,null,"","No",null,{"$f":"IF(E44=\"\",\"\",VLOOKUP(E44,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F44=\"\",\"\",VLOOKUP(F44,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H44=\"\",\"\",VLOOKUP(H44,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O44=\"\",\"\",VLOOKUP(O44,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"KK",null,null,null,null,null,null,"","No",null,{"$f":"IF(E45=\"\",\"\",VLOOKUP(E45,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F45=\"\",\"\",VLOOKUP(F45,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H45=\"\",\"\",VLOOKUP(H45,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O45=\"\",\"\",VLOOKUP(O45,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"LL",null,null,null,null,null,null,"","No",null,{"$f":"IF(E46=\"\",\"\",VLOOKUP(E46,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F46=\"\",\"\",VLOOKUP(F46,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H46=\"\",\"\",VLOOKUP(H46,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O46=\"\",\"\",VLOOKUP(O46,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"MM",null,null,null,null,null,null,"","No",null,{"$f":"IF(E47=\"\",\"\",VLOOKUP(E47,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F47=\"\",\"\",VLOOKUP(F47,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H47=\"\",\"\",VLOOKUP(H47,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O47=\"\",\"\",VLOOKUP(O47,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"NN",null,null,null,null,null,null,"","No",null,{"$f":"IF(E48=\"\",\"\",VLOOKUP(E48,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F48=\"\",\"\",VLOOKUP(F48,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H48=\"\",\"\",VLOOKUP(H48,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O48=\"\",\"\",VLOOKUP(O48,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"OO",null,null,null,null,null,null,"","No",null,{"$f":"IF(E49=\"\",\"\",VLOOKUP(E49,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F49=\"\",\"\",VLOOKUP(F49,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H49=\"\",\"\",VLOOKUP(H49,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O49=\"\",\"\",VLOOKUP(O49,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"PP",null,null,null,null,null,null,"","No",null,{"$f":"IF(E50=\"\",\"\",VLOOKUP(E50,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F50=\"\",\"\",VLOOKUP(F50,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H50=\"\",\"\",VLOOKUP(H50,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O50=\"\",\"\",VLOOKUP(O50,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"QQ",null,null,null,null,null,null,"","No",null,{"$f":"IF(E51=\"\",\"\",VLOOKUP(E51,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F51=\"\",\"\",VLOOKUP(F51,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H51=\"\",\"\",VLOOKUP(H51,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O51=\"\",\"\",VLOOKUP(O51,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"RR",null,null,null,null,null,null,"","No",null,{"$f":"IF(E52=\"\",\"\",VLOOKUP(E52,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F52=\"\",\"\",VLOOKUP(F52,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H52=\"\",\"\",VLOOKUP(H52,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O52=\"\",\"\",VLOOKUP(O52,Lists!$A$40:$B$290,2,FALSE))","v":""}]
[null,"SS",null,null,null,null,null,null,"","No",null,{"$f":"IF(E53=\"\",\"\",VLOOKUP(E53,Scales!$E$5:$G$10,3,FALSE))","v":""},{"$f":"IF(F53=\"\",\"\",VLOOKUP(F53,Scales!$E$14:$G$19,3,FALSE))","v":""},{"$f":"IF(H53=\"\",\"\",VLOOKUP(H53,Scales!$E$23:$G$30,3,FALSE))","v":""},"",{"$f":"IF(O53=\"\",\"\",VLOOKUP(O53,Lists!$A$40:$B$290,2,FALSE))","v":""}]

{"sheet":"Assess2","index":3,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":false,"merged":[[7,1,7,2],[2,1,5,3]]}
[]
[null,"Instructions:"]
[null,"Please note additional controls needed to reduce risks to an acceptable level.  In the next column, please indicate how effective the new controls will be at bringing the overall level of risk to an acceptable level.  Consider both the existing controls and the additional controls."]
[]
[]
[]
[]
[null,"Strategic Risks",null,"Current Management and Mitigation","Risk Rating with \nCurrent Controls","Changes to Controls","Change to Control Effectiveness","Risk Rating after \nChanges to Controls","Accountable\nPerson/Department",null,"Orig F","Orig S","Orig Control","Change Multiplier","New Control","New Rating"]
[null,{"$f":"Assess!B9","v":"A"},{"$f":"IF(Assess!C9=\"\",\"\",Assess!C9)","v":"Students contract vaccine preventable diseases: Yellow Fever, Hepatitis A & B, Typhoid, Meningococcal (Meningitis), Rabies, Polio"},{"$f":"IF(Assess!G9=\"\",\"\",Assess!G9)","v":"Students expected to follow CDC vaccine recommendations"},{"$f":"Assess!I9","v":"Under-controlled"},"1) Remind students to follow CDC vaccine recommendations before departure.  2) Get students authorization to speak to parents and send information to parents. 3) Emphasize with campus offices to mention malaria prevention and/or include someone from SH during pre-departure orientation. ","Significant improvement",{"$f":"Q9","v":"Adequately controlled"},"Ines? Campus? Onsite? Students?--- Student's must choose to follow detailed advise.",null,{"$f":"Assess!L9","v":12},{"$f":"Assess!M9","v":6},{"$f":"Assess!N9","v":0.3},{"$f":"IF(G9=\"\",\"\",VLOOKUP(G9,Lists!$L$6:$M$18,2,FALSE))","v":0.9},{"$f":"IF(N9=\"\",\"\",IF(N9=0,M9,IF(N9<0,M9+(M9*N9),IF(N9>0,M9+((1-M9)*N9)))))","v":0.92999999999999994},{"$f":"IF(K9=\"\",\"\",IF(L9=\"\",\"\",IF(O9=\"\",\"\",ROUND((K9+L9)*(1-O9),1))))","v":1.3},{"$f":"IF(E9=\"\",\"\",IF(N9=\"\",\"\",VLOOKUP(P9,Lists!$D$41:$E$291,2,FALSE)))","v":"Adequately controlled"}]
[null,{"$f":"Assess!B10","v":"B"},{"$f":"IF(Assess!C10=\"\",\"\",Assess!C10)","v":"Meningitis - Students with risk factors for Meningitis (poor overall health, prior infection, birth defect in the skull, a head injury or brain surgery, previous infections such as upper respiratory or Lyme disease, cochlear implant; impaired immune system"},{"$f":"IF(Assess!G10=\"\",\"\",Assess!G10)","v":"1) All EAP students are required to complete the online UCEAP Travel Health Certification course through MyEAP and strongly encouraged to follow through about vaccine recommendations with a travel health professional.  2) Avoid close human contact in crowded areas. 3) Frequent hand washing with soap and water."},{"$f":"Assess!I10","v":"Potentially under-controlled"},"1) Remind students to follow CDC vaccine recommendations before departure.  2) Get students authorization to speak to parents and send information to parents. 3) Emphasize with campus offices to mention malaria prevention and/or include someone from SH during pre-departure orientation. ","Substantial improvement",{"$f":"Q10","v":"Adequately controlled"},"Ines? Campus? Onsite? Students?--- Student's must choose to follow detailed advise.",null,{"$f":"Assess!L10","v":12},{"$f":"Assess!M10","v":6},{"$f":"Assess!N10","v":0.6},{"$f":"IF(G10=\"\",\"\",VLOOKUP(G10,Lists!$L$6:$M$18,2,FALSE))","v":0.75},{"$f":"IF(N10=\"\",\"\",IF(N10=0,M10,IF(N10<0,M10+(M10*N10),IF(N10>0,M10+((1-M10)*N10)))))","v":0.9},{"$f":"IF(K10=\"\",\"\",IF(L10=\"\",\"\",IF(O10=\"\",\"\",ROUND((K10+L10)*(1-O10),1))))","v":1.8},{"$f":"IF(E10=\"\",\"\",IF(N10=\"\",\"\",VLOOKUP(P10,Lists!$D$41:$E$291,2,FALSE)))","v":"Adequately controlled"}]
[null,{"$f":"Assess!B11","v":"C"},{"$f":"IF(Assess!C11=\"\",\"\",Assess!C11)","v":"Malaria - Students with risk factors for Malaria (stopping or not adhering to prophylaxis, not taking personal protective measures, using substandard drugs purchased over seas, not follow-up if symptoms occur)"},{"$f":"IF(Assess!G11=\"\",\"\",Assess!G11)","v":"Recommendations for prevention of malaria must be individualized.  1) Students are required to complete the UCEAP Online Travel Health Education Certification course and strongly recommended to meet with a travel health specialist after the course to understand the health risks, get necessary medication based on length of stay and current medical condition, and learn how diseases are transmitted.  2) Students advised to spray insecticide on walls; use a pyrethroid-containing flying-insect spray in living and sleeping areas; understand behaviors to minimize exposure to mosquitoes; wear barrier clothing; use insecticide-impregnated bed nets; spray residence; take an appropriate antimalarial drug regimen exactly as prescribed and carefully following antimosquito measures. 3) Students sign a mandatory Malaria Prophylaxis Agreement form. Students who do not comply may be dismissed.  3) EAP student health insurance provides adequate coverage and medical evacuation benefits. 4) UCEAP insurance coverage includes 100% coverage for prophylaxis.  5) Students told to continue taking the medication as recommended after leaving the malaria-risk area. "},{"$f":"Assess!I11","v":"Potentially under-controlled"},"1) Remind students to follow CDC vaccine recommendations before departure.  2) Get students authorization to speak to parents and send information to parents. 3) Emphasize with campus offices to mention malaria prevention and/or include someone from SH during pre-departure orientation. ","No Change","Potentially under-controlled","Student Health Centers for those students who attend the UCEAP clearance on their UC campuses.  Can't reach private practitioners. Students?--- Student's must choose to follow detailed advise.",null,{"$f":"Assess!L11","v":15},{"$f":"Assess!M11","v":10},{"$f":"Assess!N11","v":0.75},{"$f":"IF(G11=\"\",\"\",VLOOKUP(G11,Lists!$L$6:$M$18,2,FALSE))","v":0},0.75,6.3,{"$f":"IF(E11=\"\",\"\",IF(N11=\"\",\"\",VLOOKUP(P11,Lists!$D$41:$E$291,2,FALSE)))","v":"Potentially under-controlled"}]
[null,{"$f":"Assess!B12","v":"D"},{"$f":"IF(Assess!C12=\"\",\"\",Assess!C12)","v":"Parasitic Infection - Students contract parasitic infections (consuming or exposure to contaminated water by drinking, swimming or bathing) for which no vaccines or preventive drugs are available"},{"$f":"IF(Assess!G12=\"\",\"\",Assess!G12)","v":"Students advised to avoid 1) swimming or wading in freshwater; 2) drink safe water; either boil water for 1 minute or filter water before drinking. Iodine treatment alone WILL NOT GUARANTEE that water is safe and free of all parasites. 3) If a student accidentally come into contact with fresh water, vigorous towel drying after a very brief water exposure may help to prevent the Schistosoma parasite from penetrating the skin. Students should NOT rely on vigorous towel drying to prevent Schistosomiasis"},{"$f":"Assess!I12","v":"Potentially under-controlled"},null,"No Change","Potentially under-controlled","Student Health Centers for those students who attend the UCEAP clearance on their UC campuses.  Can't reach private practitioners. Student's must choose to follow detailed advise.",null,{"$f":"Assess!L12","v":15},{"$f":"Assess!M12","v":10},{"$f":"Assess!N12","v":0.75},{"$f":"IF(G12=\"\",\"\",VLOOKUP(G12,Lists!$L$6:$M$18,2,FALSE))","v":0},0.75,6.3,{"$f":"IF(E12=\"\",\"\",IF(N12=\"\",\"\",VLOOKUP(P12,Lists!$D$41:$E$291,2,FALSE)))","v":"Potentially under-controlled"}]
[null,{"$f":"Assess!B13","v":"E"},{"$f":"IF(Assess!C13=\"\",\"\",Assess!C13)","v":"Rabies - a preventable and acute viral disease of the central nervous system, most often transmitted through the bite of a rabid animal."},{"$f":"IF(Assess!G13=\"\",\"\",Assess!G13)","v":"The risk of rabies in an encounter with an animal and the precautions necessary to prevent rabies are the same as they are in the United States.  Students are told to consult with a health care professional after the required UCEAP online Travel Health Education Certification course.  Consider getting a rabies vaccine if your activities will put you in contact with animals (approximately $160 at UC Student Health Services).  Avoid approaching any wild or domestic animals.  Avoid all contact with animals, especially stray dogs and cats.  If bitten or scratched, wash the wound immediately with soap and water (and povidone iodine, if available); seek medical attention immediately to determine if mediation or anti-rabies vaccine is needed. Immediate local treatment will substantially reduce the risk of rabies.  Treat any bite from a potentially rabid animal as a medical emergency."},{"$f":"Assess!I13","v":"Potentially under-controlled"},null,"No Change","Potentially under-controlled","Students?--- Student's must choose to follow detailed advise.",null,{"$f":"Assess!L13","v":15},{"$f":"Assess!M13","v":6},{"$f":"Assess!N13","v":0.75},{"$f":"IF(G13=\"\",\"\",VLOOKUP(G13,Lists!$L$6:$M$18,2,FALSE))","v":0},0.75,5.3,{"$f":"IF(E13=\"\",\"\",IF(N13=\"\",\"\",VLOOKUP(P13,Lists!$D$41:$E$291,2,FALSE)))","v":"Potentially under-controlled"}]
[null,{"$f":"Assess!B14","v":"F"},{"$f":"IF(Assess!C14=\"\",\"\",Assess!C14)","v":"Insect Precautions – Many serious diseases transmitted by insects require careful avoidance and use of protective measures as there are no immunizations and medications. Travelers visiting rural areas or engaging in camping, hiking or adventure travel are at the greatest risk of exposure to mosquitoes, ticks, mites, fleas and other disease-carrying insects, but even urban visitors need to take precautions to avoid insect exposure in some areas."},{"$f":"IF(Assess!G14=\"\",\"\",Assess!G14)","v":"Students instructed to cover as much skin as possible; perform body tick checks daily; sleep in protected areas with screens or air conditioning or use a permethrin-impregnated sleeping bed nets; eliminate any mosquitoes from inside rooms and sleeping areas prior to retiring. Insecticide sprays may be used to clear rooms of mosquitoes, but coils should be only used outdoors. "},{"$f":"Assess!I14","v":"Adequately controlled"},null,"No Change","Adequately controlled","Students?--- Student's must choose to follow detailed advise.",null,{"$f":"Assess!L14","v":12},{"$f":"Assess!M14","v":6},{"$f":"Assess!N14","v":0.9},{"$f":"IF(G14=\"\",\"\",VLOOKUP(G14,Lists!$L$6:$M$18,2,FALSE))","v":0},0.9,1.8,{"$f":"IF(E14=\"\",\"\",IF(N14=\"\",\"\",VLOOKUP(P14,Lists!$D$41:$E$291,2,FALSE)))","v":"Adequately controlled"}]
[null,{"$f":"Assess!B15","v":"G"},{"$f":"IF(Assess!C15=\"\",\"\",Assess!C15)","v":"Food/Water Safety - Students consume unsafe food and/or water contaminated with toxins or diseases  Local water supplies are limited and contaminated with raw sewage, pesticides and industrial waste.  Some types of fish may contain poisonous biotoxins even when cooked. "},{"$f":"IF(Assess!G15=\"\",\"\",Assess!G15)","v":"Students are instructed to drink only known brands of bottled water that have not been tampered with; eat in well-established, clean restaurants; eat only well-cooked food served hot; avoid salads, buffets, and cooked foods that have been left at room temperature; not eat fruits or vegetables unless they have been peeled or cooked; avoid cooked foods that are no longer piping hot; avoid buying food from street vendors; not drink tap water (unless boiled, filtered, or chemically disinfected) or unbottled beverages or drinks with ice; avoid unpasteurized milk and dairy products such as ice cream; and not eat raw or undercooked meat or fish. "},{"$f":"Assess!I15","v":"Potentially under-controlled"},null,"No Change","Potentially under-controlled","Students?--- Student's must choose to follow detailed advise.",null,{"$f":"Assess!L15","v":12},{"$f":"Assess!M15","v":8},{"$f":"Assess!N15","v":0.6},{"$f":"IF(G15=\"\",\"\",VLOOKUP(G15,Lists!$L$6:$M$18,2,FALSE))","v":0},0.6,8,{"$f":"IF(E15=\"\",\"\",IF(N15=\"\",\"\",VLOOKUP(P15,Lists!$D$41:$E$291,2,FALSE)))","v":"Potentially under-controlled"}]
[null,{"$f":"Assess!B16","v":"H"},{"$f":"IF(Assess!C16=\"\",\"\",Assess!C16)","v":"Medical Facilities - Students seriously sick and requiring hospitalization do not get needed care or receive substandard care; medical facilities are limited in Accra and may be nonexistent elsewhere; most doctors and hospitals expect payment in cash, regardless of travel health insurance.  Differing cultural expectations in Ghana affect care. "},{"$f":"IF(Assess!G16=\"\",\"\",Assess!G16)","v":"1) The EAP student health insurance adequately covers medical evacuation from Ghana.2) Europ Assistance, UCEAP Travel Assistance provider can refer students to local medical facilities and can guarantee payment of services directly.  3) The U.S. Embassy has on their website a list of medical services providers. 4) Students need to be prepared for the inevitable cultural differences in medical services and find out in advance whether any particular care needed is available.  5) Prescription medications are often not available so students may want to consider bringing a sufficient supply. 6) Students and their families should inform themselves about health management while in Ghana and discuss health options with their health care provider.  7) Students with chronic health conditions, need to consult carefully with a physician in the U.S. before departure. 8)  Access to a freezer/refrigerator for some medical equipment/medication may be difficult as electricity is sporadic throughout Ghana. The student dorms are not equipped with fridges or freezers. 9) The UC Study Center staff is present to assist students if they get sick or injured.  10) Students should complete all routine and required medical exams before coming to Accra and obtain all required and recommended immunization. 11) Students should refer to the U.S. Department of State website and 12) follow advice acquired during the Online UCEAP Travel Health Certification course."},{"$f":"Assess!I16","v":"Adequately controlled"},null,"No Change","Adequately controlled","Ines ",null,{"$f":"Assess!L16","v":12},{"$f":"Assess!M16","v":8},{"$f":"Assess!N16","v":0.9},{"$f":"IF(G16=\"\",\"\",VLOOKUP(G16,Lists!$L$6:$M$18,2,FALSE))","v":0},0.9,2,{"$f":"IF(E16=\"\",\"\",IF(N16=\"\",\"\",VLOOKUP(P16,Lists!$D$41:$E$291,2,FALSE)))","v":"Adequately controlled"}]
[null,{"$f":"Assess!B17","v":"I"},{"$f":"IF(Assess!C17=\"\",\"\",Assess!C17)","v":"Mental Health - Students with recent or ongoing mental health concerns fail to document in advance of the EAP health clearance and travel, her/his condition and detailed plan for continuing care while away. "},{"$f":"IF(Assess!G17=\"\",\"\",Assess!G17)","v":"The EAP student health insurance covers outpatient counseling up to 30 visits.  If students will need care, the U.S. Embassy provides a list of counselors and can help UC Study Center staff to establish contact to provide confidential treatment.  If a student is seeing a counselor/therapist in the U.S., the student should consult carefully about health and medication management before departure.  Student should bring adequate supply of prescription medication to last through the stay along with a doctor’s prescription and a letter indicating condition. Students need to be prepared for the inevitable cultural differences in medical services. Students who need a particular type of medical care should find out in advance whether such care is available. Students should discuss options with their health care provider."},{"$f":"Assess!I17","v":"Adequately controlled"},null,"No Change","Adequately controlled","Ines",null,{"$f":"Assess!L17","v":9},{"$f":"Assess!M17","v":6},{"$f":"Assess!N17","v":0.9},{"$f":"IF(G17=\"\",\"\",VLOOKUP(G17,Lists!$L$6:$M$18,2,FALSE))","v":0},0.9,1.5,{"$f":"IF(E17=\"\",\"\",IF(N17=\"\",\"\",VLOOKUP(P17,Lists!$D$41:$E$291,2,FALSE)))","v":"Adequately controlled"}]
[null,{"$f":"Assess!B18","v":"J"},{"$f":"IF(Assess!C18=\"\",\"\",Assess!C18)","v":"Illicit drugs - the unlawful possession, use, or distribution of alcohol by students or employees on University of Ghana premises or as part of any University of Ghana activities is prohibited."},{"$f":"IF(Assess!G18=\"\",\"\",Assess!G18)","v":"Students must decide to act responsibly.   University of Ghana expects students to comport themselves in a manner consistent with University policy and that they must conduct themselves in a lawful manner at all times.  Violation of University of Ghana and University of California policies subjects students to disciplinary procedures.  Violation of country laws exposes the student to criminal charges and/or arrest."},{"$f":"Assess!I18","v":"Adequately controlled"},null,"No Change","Adequately controlled",null,null,{"$f":"Assess!L18","v":12},{"$f":"Assess!M18","v":6},{"$f":"Assess!N18","v":0.75},{"$f":"IF(G18=\"\",\"\",VLOOKUP(G18,Lists!$L$6:$M$18,2,FALSE))","v":0},0.75,4.5,{"$f":"IF(E18=\"\",\"\",IF(N18=\"\",\"\",VLOOKUP(P18,Lists!$D$41:$E$291,2,FALSE)))","v":"Adequately controlled"}]
[null,{"$f":"Assess!B19","v":"K"},{"$f":"IF(Assess!C19=\"\",\"\",Assess!C19)","v":"Road Safety - Road traffic accidents may be one of the main threats facing students.  Roads are mainly in a poor condition, particularly in rural areas.  Road travel can be extremely hazardous due to poor driving practices, poorly maintained vehicles, insufficient street lighting, roaming livestock, pedestrians and cyclists.  Safety standards on small private buses and taxis are often low and do not meet US standards"},{"$f":"IF(Assess!G19=\"\",\"\",Assess!G19)","v":"Students should avoid traveling by road outside the main towns after dark, when the risk of accidents and robbery is greater.  Students should check with local staff before venturing off main roads in outlying areas.  Due to poor driving conditions and the poor mechanical state of many vehicles in Ghana, that vehicular travel after dark outside Accra should be avoided"},{"$f":"Assess!I19","v":"Potentially under-controlled"},null,"No Change","Potentially under-controlled","Students?--- Student's must choose to follow detailed advise.",null,{"$f":"Assess!L19","v":12},{"$f":"Assess!M19","v":8},{"$f":"Assess!N19","v":0.6},{"$f":"IF(G19=\"\",\"\",VLOOKUP(G19,Lists!$L$6:$M$18,2,FALSE))","v":0},0.6,8,{"$f":"IF(E19=\"\",\"\",IF(N19=\"\",\"\",VLOOKUP(P19,Lists!$D$41:$E$291,2,FALSE)))","v":"Potentially under-controlled"}]
[null,{"$f":"Assess!B20","v":"L"},{"$f":"IF(Assess!C20=\"\",\"\",Assess!C20)","v":"Tro Tro Accidents - Tro-Tros are the cheapest way to get around Accra.  Tro-tros are usually made from converted minibuses and are designed to fit as many people, possessions, and occasionally livestock, as possible."},{"$f":"IF(Assess!G20=\"\",\"\",Assess!G20)","v":"Do not travel by tro-tros, especially when it is dark."},{"$f":"Assess!I20","v":"Potentially under-controlled"},null,"No Change","Potentially under-controlled","Students?--- Student's must choose to follow detailed advise.",null,{"$f":"Assess!L20","v":12},{"$f":"Assess!M20","v":8},{"$f":"Assess!N20","v":0.6},{"$f":"IF(G20=\"\",\"\",VLOOKUP(G20,Lists!$L$6:$M$18,2,FALSE))","v":0},0.6,8,{"$f":"IF(E20=\"\",\"\",IF(N20=\"\",\"\",VLOOKUP(P20,Lists!$D$41:$E$291,2,FALSE)))","v":"Potentially under-controlled"}]
[null,{"$f":"Assess!B21","v":"M"},{"$f":"IF(Assess!C21=\"\",\"\",Assess!C21)","v":"Taxis - Criminals sometimes use taxis to rob patrons."},{"$f":"IF(Assess!G21=\"\",\"\",Assess!G21)","v":"The Accra Metropolitan Assembly (AMA) requires all taxi drivers to wear a sea blue shirt and dark blue trousers as their uniform.  Also, drivers are required to register their vehicles with the Assembly to get a special serial number consisting of only three digits to be embossed with reflectors on both sides of the front doors to make identification easy even at night. This measure has been implemented to further enhance security for both taxi patrons and owners.  Students are told to exercise caution when traveling in taxis.  Students should confirm that the taxi has sufficient gas before hiring it, because drivers will lure taxi occupants to gas stations to be robbed by awaiting criminals.  Never board a taxi with all male occupants already in or a female passenger and two male passengers as they could be decoys."},{"$f":"Assess!I21","v":"Adequately controlled"},null,"No Change","Adequately controlled","Students?--- Student's must choose to follow detailed advise.",null,{"$f":"Assess!L21","v":9},{"$f":"Assess!M21","v":6},{"$f":"Assess!N21","v":0.75},{"$f":"IF(G21=\"\",\"\",VLOOKUP(G21,Lists!$L$6:$M$18,2,FALSE))","v":0},0.75,3.8,{"$f":"IF(E21=\"\",\"\",IF(N21=\"\",\"\",VLOOKUP(P21,Lists!$D$41:$E$291,2,FALSE)))","v":"Adequately controlled"}]
[null,{"$f":"Assess!B22","v":"N"},{"$f":"IF(Assess!C22=\"\",\"\",Assess!C22)","v":"Ghanaian law criminalizes homosexuality.  A large portion of Ghanaian society does not accept that such activity exists.  A gay social life exists, mostly in the form of house parties, and a few queer-friendly clubs in Accra, but there are risks."},{"$f":"IF(Assess!G22=\"\",\"\",Assess!G22)","v":"Further information is available from the Gay and Lesbian Association of Ghana or Behind the Mask (http://www.mask.org.za/index.php?page=home)"},{"$f":"Assess!I22","v":"Adequately controlled"},null,"No Change","Adequately controlled",null,null,{"$f":"Assess!L22","v":12},{"$f":"Assess!M22","v":4},{"$f":"Assess!N22","v":0.75},{"$f":"IF(G22=\"\",\"\",VLOOKUP(G22,Lists!$L$6:$M$18,2,FALSE))","v":0},0.75,4,{"$f":"IF(E22=\"\",\"\",IF(N22=\"\",\"\",VLOOKUP(P22,Lists!$D$41:$E$291,2,FALSE)))","v":"Adequately controlled"}]
[null,{"$f":"Assess!B23","v":"O"},{"$f":"IF(Assess!C23=\"\",\"\",Assess!C23)","v":"Non-Violent Crime - Street theft is the most common; Street persons asking for handouts may grab jewelry or other items from one's neck or wrist, or distract the victim for a pickpocket; criminals will sometimes use motorcycles to drive by unsuspecting pedestrians and snatch their bags.  Theft of unattended property is common in Ghana."},{"$f":"IF(Assess!G23=\"\",\"\",Assess!G23)","v":"Students are advised to be constantly aware of their surroundings, especially in crowded streets and shopping/market areas;  never venture out alone; use the buddy system; go in groups; proceed to a location where help is available if afraid; monitor the media for information about new safety or security risks; stay in well-lit areas; carry only necessary credit cards and money, not air tickets; act suspicious if followed; never hitchhike; be discreet; avoid uncontrolled crowds; look confident and do not wander into unknown areas. Exercise caution; do not accept lifts or drinks from strangers; ensure others know whereabouts;  use safest route to destination; lock up valuables; keep a vigilant eye on property; carry money in several locations; trust instincts; protect cell phones; ask Study Center staff for advice; and read the U.S. Department of State, Country Specific Information on Ghana UCEAP insurance covers personal property up to a certain amount.  Students are advised to supplement coverage if UCEAP benefit is inadequate based on her personal belongings."},{"$f":"Assess!I23","v":"Adequately controlled"},null,"No Change","Adequately controlled","Students?--- Student's must choose to follow detailed advise.",null,{"$f":"Assess!L23","v":9},{"$f":"Assess!M23","v":8},{"$f":"Assess!N23","v":0.75},{"$f":"IF(G23=\"\",\"\",VLOOKUP(G23,Lists!$L$6:$M$18,2,FALSE))","v":0},0.75,4.3,{"$f":"IF(E23=\"\",\"\",IF(N23=\"\",\"\",VLOOKUP(P23,Lists!$D$41:$E$291,2,FALSE)))","v":"Adequately controlled"}]
[null,{"$f":"Assess!B24","v":"P"},{"$f":"IF(Assess!C24=\"\",\"\",Assess!C24)","v":"Violent Crime - includes muggings carried out by groups of men; armed robbery using machetes or handguns; Home invasions by criminals who are sometimes armed;"},{"$f":"IF(Assess!G24=\"\",\"\",Assess!G24)","v":"If confronted by would-be assailants, comply.  There have been several incidents where people have resisted trying to hang on to their purse/bag, or it was perceived as resistance and they were seriously injured.  See \"O\" above."},{"$f":"Assess!I24","v":"Adequately controlled"},null,"No Change","Adequately controlled",null,null,{"$f":"Assess!L24","v":12},{"$f":"Assess!M24","v":6},{"$f":"Assess!N24","v":0.75},{"$f":"IF(G24=\"\",\"\",VLOOKUP(G24,Lists!$L$6:$M$18,2,FALSE))","v":0},0.75,4.5,{"$f":"IF(E24=\"\",\"\",IF(N24=\"\",\"\",VLOOKUP(P24,Lists!$D$41:$E$291,2,FALSE)))","v":"Adequately controlled"}]
[null,{"$f":"Assess!B25","v":"Q"},{"$f":"IF(Assess!C25=\"\",\"\",Assess!C25)","v":"The Ghanaian Police Service (GPS) is almost solely a reactive force and demonstrates moderate proactive techniques to deter criminals. Police often lack the equipment, resources, training, and personnel to respond to calls for assistance or other emergencies. The police have a poor record of investigating and solving serious crimes."},{"$f":"IF(Assess!G25=\"\",\"\",Assess!G25)","v":"If confronted by would-be assailants, comply.  There have been several incidents where people have resisted trying to hang on to their purse/bag, or it was perceived as resistance and they were seriously injured.  See \"O\" above."},{"$f":"Assess!I25","v":""},null,null,"",null,null,{"$f":"Assess!L25","v":12},{"$f":"Assess!M25","v":6},{"$f":"Assess!N25","v":""},{"$f":"IF(G25=\"\",\"\",VLOOKUP(G25,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E25=\"\",\"\",IF(N25=\"\",\"\",VLOOKUP(P25,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B26","v":"R"},{"$f":"IF(Assess!C26=\"\",\"\",Assess!C26)","v":"Credit card skimming is especially prevalent in Ghana.  "},{"$f":"IF(Assess!G26=\"\",\"\",Assess!G26)","v":"Students advised to limit purchases or cash advances using credit cards; not allow anyone to take your credit card out of your sight; use credit cards only in reputable restaurants or shops; ask to be present during the transaction process; retain and destroy all receipts and carbons; keep accurate records of any transactions; and notify your bank’s fraud department immediately if you suspect fraudulent charges."},{"$f":"Assess!I26","v":""},null,null,"",null,null,{"$f":"Assess!L26","v":12},{"$f":"Assess!M26","v":6},{"$f":"Assess!N26","v":""},{"$f":"IF(G26=\"\",\"\",VLOOKUP(G26,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E26=\"\",\"\",IF(N26=\"\",\"\",VLOOKUP(P26,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B27","v":"S"},{"$f":"IF(Assess!C27=\"\",\"\",Assess!C27)","v":"Crime on Campus - The campus is extremely large and there are numerous points of entry beyond the official, guarded gates.  Lighting on certain parts of the campus is substandard.  "},{"$f":"IF(Assess!G27=\"\",\"\",Assess!G27)","v":"Primary responsibility for security on campus resides with the University Security Office of the University. The University Security services enforce order, protect life and property, make arrests as provided by law, conduct investigations, and exercise powers similar to the police. University Security is on duty 24 hours a day, 365 days a year and in constant communication with the main Security centre.  The University security guards patrol the exterior areas of the campus, twenty-four hours a day. In some cases, additional regular tours of the interior of the residence halls to check lounges, corridors and other common residence areas are carried out. Guards, assisted by Porters or other resident staff members, may confront residents and visitors suspected of violations of University policy.  Students are advised of safety rules and best practices"},{"$f":"Assess!I27","v":""},null,null,"",null,null,{"$f":"Assess!L27","v":12},{"$f":"Assess!M27","v":6},{"$f":"Assess!N27","v":""},{"$f":"IF(G27=\"\",\"\",VLOOKUP(G27,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E27=\"\",\"\",IF(N27=\"\",\"\",VLOOKUP(P27,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B28","v":"T"},{"$f":"IF(Assess!C28=\"\",\"\",Assess!C28)","v":"Legal Considerations - Photography at airports, railway stations, naval bases, air bases, military installations, public water and energy plants, police stations, harbors, mines and bridges is prohibited in Ghana."},{"$f":"IF(Assess!G28=\"\",\"\",Assess!G28)","v":"Risk is preventable. Awareness of the laws is the key to avoiding trouble.  Foreigners are more likely to be at risk than locals.  Students should research the legal system in Ghana to be aware of penalties and other laws, e.g., laws relating to drugs/alcohol, sexuality; severity of punishment for crimes; nature of the legal system; obtaining legal assistance."},{"$f":"Assess!I28","v":""},null,null,"",null,null,{"$f":"Assess!L28","v":12},{"$f":"Assess!M28","v":8},{"$f":"Assess!N28","v":""},{"$f":"IF(G28=\"\",\"\",VLOOKUP(G28,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E28=\"\",\"\",IF(N28=\"\",\"\",VLOOKUP(P28,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B29","v":"U"},{"$f":"IF(Assess!C29=\"\",\"\",Assess!C29)","v":""},{"$f":"IF(Assess!G29=\"\",\"\",Assess!G29)","v":""},{"$f":"Assess!I29","v":""},null,null,"",null,null,{"$f":"Assess!L29","v":""},{"$f":"Assess!M29","v":""},{"$f":"Assess!N29","v":""},{"$f":"IF(G29=\"\",\"\",VLOOKUP(G29,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E29=\"\",\"\",IF(N29=\"\",\"\",VLOOKUP(P29,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B30","v":"V"},{"$f":"IF(Assess!C30=\"\",\"\",Assess!C30)","v":""},{"$f":"IF(Assess!G30=\"\",\"\",Assess!G30)","v":""},{"$f":"Assess!I30","v":""},null,null,"",null,null,{"$f":"Assess!L30","v":""},{"$f":"Assess!M30","v":""},{"$f":"Assess!N30","v":""},{"$f":"IF(G30=\"\",\"\",VLOOKUP(G30,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E30=\"\",\"\",IF(N30=\"\",\"\",VLOOKUP(P30,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B31","v":"W"},{"$f":"IF(Assess!C31=\"\",\"\",Assess!C31)","v":""},{"$f":"IF(Assess!G31=\"\",\"\",Assess!G31)","v":""},{"$f":"Assess!I31","v":""},null,null,"",null,null,{"$f":"Assess!L31","v":""},{"$f":"Assess!M31","v":""},{"$f":"Assess!N31","v":""},{"$f":"IF(G31=\"\",\"\",VLOOKUP(G31,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E31=\"\",\"\",IF(N31=\"\",\"\",VLOOKUP(P31,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B32","v":"X"},{"$f":"IF(Assess!C32=\"\",\"\",Assess!C32)","v":""},{"$f":"IF(Assess!G32=\"\",\"\",Assess!G32)","v":""},{"$f":"Assess!I32","v":""},null,null,"",null,null,{"$f":"Assess!L32","v":""},{"$f":"Assess!M32","v":""},{"$f":"Assess!N32","v":""},{"$f":"IF(G32=\"\",\"\",VLOOKUP(G32,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E32=\"\",\"\",IF(N32=\"\",\"\",VLOOKUP(P32,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B33","v":"Y"},{"$f":"IF(Assess!C33=\"\",\"\",Assess!C33)","v":""},{"$f":"IF(Assess!G33=\"\",\"\",Assess!G33)","v":""},{"$f":"Assess!I33","v":""},null,null,"",null,null,{"$f":"Assess!L33","v":""},{"$f":"Assess!M33","v":""},{"$f":"Assess!N33","v":""},{"$f":"IF(G33=\"\",\"\",VLOOKUP(G33,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E33=\"\",\"\",IF(N33=\"\",\"\",VLOOKUP(P33,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B34","v":"Z"},{"$f":"IF(Assess!C34=\"\",\"\",Assess!C34)","v":""},{"$f":"IF(Assess!G34=\"\",\"\",Assess!G34)","v":""},{"$f":"Assess!I34","v":""},null,null,"",null,null,{"$f":"Assess!L34","v":""},{"$f":"Assess!M34","v":""},{"$f":"Assess!N34","v":""},{"$f":"IF(G34=\"\",\"\",VLOOKUP(G34,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E34=\"\",\"\",IF(N34=\"\",\"\",VLOOKUP(P34,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B35","v":"AA"},{"$f":"IF(Assess!C35=\"\",\"\",Assess!C35)","v":""},{"$f":"IF(Assess!G35=\"\",\"\",Assess!G35)","v":""},{"$f":"Assess!I35","v":""},null,null,"",null,null,{"$f":"Assess!L35","v":""},{"$f":"Assess!M35","v":""},{"$f":"Assess!N35","v":""},{"$f":"IF(G35=\"\",\"\",VLOOKUP(G35,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E35=\"\",\"\",IF(N35=\"\",\"\",VLOOKUP(P35,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B36","v":"BB"},{"$f":"IF(Assess!C36=\"\",\"\",Assess!C36)","v":""},{"$f":"IF(Assess!G36=\"\",\"\",Assess!G36)","v":""},{"$f":"Assess!I36","v":""},null,null,"",null,null,{"$f":"Assess!L36","v":""},{"$f":"Assess!M36","v":""},{"$f":"Assess!N36","v":""},{"$f":"IF(G36=\"\",\"\",VLOOKUP(G36,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E36=\"\",\"\",IF(N36=\"\",\"\",VLOOKUP(P36,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B37","v":"CC"},{"$f":"IF(Assess!C37=\"\",\"\",Assess!C37)","v":""},{"$f":"IF(Assess!G37=\"\",\"\",Assess!G37)","v":""},{"$f":"Assess!I37","v":""},null,null,"",null,null,{"$f":"Assess!L37","v":""},{"$f":"Assess!M37","v":""},{"$f":"Assess!N37","v":""},{"$f":"IF(G37=\"\",\"\",VLOOKUP(G37,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E37=\"\",\"\",IF(N37=\"\",\"\",VLOOKUP(P37,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B38","v":"DD"},{"$f":"IF(Assess!C38=\"\",\"\",Assess!C38)","v":""},{"$f":"IF(Assess!G38=\"\",\"\",Assess!G38)","v":""},{"$f":"Assess!I38","v":""},null,null,"",null,null,{"$f":"Assess!L38","v":""},{"$f":"Assess!M38","v":""},{"$f":"Assess!N38","v":""},{"$f":"IF(G38=\"\",\"\",VLOOKUP(G38,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E38=\"\",\"\",IF(N38=\"\",\"\",VLOOKUP(P38,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B39","v":"EE"},{"$f":"IF(Assess!C39=\"\",\"\",Assess!C39)","v":""},{"$f":"IF(Assess!G39=\"\",\"\",Assess!G39)","v":""},{"$f":"Assess!I39","v":""},null,null,"",null,null,{"$f":"Assess!L39","v":""},{"$f":"Assess!M39","v":""},{"$f":"Assess!N39","v":""},{"$f":"IF(G39=\"\",\"\",VLOOKUP(G39,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E39=\"\",\"\",IF(N39=\"\",\"\",VLOOKUP(P39,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B40","v":"FF"},{"$f":"IF(Assess!C40=\"\",\"\",Assess!C40)","v":""},{"$f":"IF(Assess!G40=\"\",\"\",Assess!G40)","v":""},{"$f":"Assess!I40","v":""},null,null,"",null,null,{"$f":"Assess!L40","v":""},{"$f":"Assess!M40","v":""},{"$f":"Assess!N40","v":""},{"$f":"IF(G40=\"\",\"\",VLOOKUP(G40,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E40=\"\",\"\",IF(N40=\"\",\"\",VLOOKUP(P40,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B41","v":"GG"},{"$f":"IF(Assess!C41=\"\",\"\",Assess!C41)","v":""},{"$f":"IF(Assess!G41=\"\",\"\",Assess!G41)","v":""},{"$f":"Assess!I41","v":""},null,null,"",null,null,{"$f":"Assess!L41","v":""},{"$f":"Assess!M41","v":""},{"$f":"Assess!N41","v":""},{"$f":"IF(G41=\"\",\"\",VLOOKUP(G41,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E41=\"\",\"\",IF(N41=\"\",\"\",VLOOKUP(P41,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B42","v":"HH"},{"$f":"IF(Assess!C42=\"\",\"\",Assess!C42)","v":""},{"$f":"IF(Assess!G42=\"\",\"\",Assess!G42)","v":""},{"$f":"Assess!I42","v":""},null,null,"",null,null,{"$f":"Assess!L42","v":""},{"$f":"Assess!M42","v":""},{"$f":"Assess!N42","v":""},{"$f":"IF(G42=\"\",\"\",VLOOKUP(G42,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E42=\"\",\"\",IF(N42=\"\",\"\",VLOOKUP(P42,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B43","v":"II"},{"$f":"IF(Assess!C43=\"\",\"\",Assess!C43)","v":""},{"$f":"IF(Assess!G43=\"\",\"\",Assess!G43)","v":""},{"$f":"Assess!I43","v":""},null,null,"",null,null,{"$f":"Assess!L43","v":""},{"$f":"Assess!M43","v":""},{"$f":"Assess!N43","v":""},{"$f":"IF(G43=\"\",\"\",VLOOKUP(G43,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E43=\"\",\"\",IF(N43=\"\",\"\",VLOOKUP(P43,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B44","v":"JJ"},{"$f":"IF(Assess!C44=\"\",\"\",Assess!C44)","v":""},{"$f":"IF(Assess!G44=\"\",\"\",Assess!G44)","v":""},{"$f":"Assess!I44","v":""},null,null,"",null,null,{"$f":"Assess!L44","v":""},{"$f":"Assess!M44","v":""},{"$f":"Assess!N44","v":""},{"$f":"IF(G44=\"\",\"\",VLOOKUP(G44,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E44=\"\",\"\",IF(N44=\"\",\"\",VLOOKUP(P44,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B45","v":"KK"},{"$f":"IF(Assess!C45=\"\",\"\",Assess!C45)","v":""},{"$f":"IF(Assess!G45=\"\",\"\",Assess!G45)","v":""},{"$f":"Assess!I45","v":""},null,null,"",null,null,{"$f":"Assess!L45","v":""},{"$f":"Assess!M45","v":""},{"$f":"Assess!N45","v":""},{"$f":"IF(G45=\"\",\"\",VLOOKUP(G45,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E45=\"\",\"\",IF(N45=\"\",\"\",VLOOKUP(P45,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B46","v":"LL"},{"$f":"IF(Assess!C46=\"\",\"\",Assess!C46)","v":""},{"$f":"IF(Assess!G46=\"\",\"\",Assess!G46)","v":""},{"$f":"Assess!I46","v":""},null,null,"",null,null,{"$f":"Assess!L46","v":""},{"$f":"Assess!M46","v":""},{"$f":"Assess!N46","v":""},{"$f":"IF(G46=\"\",\"\",VLOOKUP(G46,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E46=\"\",\"\",IF(N46=\"\",\"\",VLOOKUP(P46,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B47","v":"MM"},{"$f":"IF(Assess!C47=\"\",\"\",Assess!C47)","v":""},{"$f":"IF(Assess!G47=\"\",\"\",Assess!G47)","v":""},{"$f":"Assess!I47","v":""},null,null,"",null,null,{"$f":"Assess!L47","v":""},{"$f":"Assess!M47","v":""},{"$f":"Assess!N47","v":""},{"$f":"IF(G47=\"\",\"\",VLOOKUP(G47,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E47=\"\",\"\",IF(N47=\"\",\"\",VLOOKUP(P47,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B48","v":"NN"},{"$f":"IF(Assess!C48=\"\",\"\",Assess!C48)","v":""},{"$f":"IF(Assess!G48=\"\",\"\",Assess!G48)","v":""},{"$f":"Assess!I48","v":""},null,null,"",null,null,{"$f":"Assess!L48","v":""},{"$f":"Assess!M48","v":""},{"$f":"Assess!N48","v":""},{"$f":"IF(G48=\"\",\"\",VLOOKUP(G48,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E48=\"\",\"\",IF(N48=\"\",\"\",VLOOKUP(P48,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B49","v":"OO"},{"$f":"IF(Assess!C49=\"\",\"\",Assess!C49)","v":""},{"$f":"IF(Assess!G49=\"\",\"\",Assess!G49)","v":""},{"$f":"Assess!I49","v":""},null,null,"",null,null,{"$f":"Assess!L49","v":""},{"$f":"Assess!M49","v":""},{"$f":"Assess!N49","v":""},{"$f":"IF(G49=\"\",\"\",VLOOKUP(G49,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E49=\"\",\"\",IF(N49=\"\",\"\",VLOOKUP(P49,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B50","v":"PP"},{"$f":"IF(Assess!C50=\"\",\"\",Assess!C50)","v":""},{"$f":"IF(Assess!G50=\"\",\"\",Assess!G50)","v":""},{"$f":"Assess!I50","v":""},null,null,"",null,null,{"$f":"Assess!L50","v":""},{"$f":"Assess!M50","v":""},{"$f":"Assess!N50","v":""},{"$f":"IF(G50=\"\",\"\",VLOOKUP(G50,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E50=\"\",\"\",IF(N50=\"\",\"\",VLOOKUP(P50,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B51","v":"QQ"},{"$f":"IF(Assess!C51=\"\",\"\",Assess!C51)","v":""},{"$f":"IF(Assess!G51=\"\",\"\",Assess!G51)","v":""},{"$f":"Assess!I51","v":""},null,null,"",null,null,{"$f":"Assess!L51","v":""},{"$f":"Assess!M51","v":""},{"$f":"Assess!N51","v":""},{"$f":"IF(G51=\"\",\"\",VLOOKUP(G51,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E51=\"\",\"\",IF(N51=\"\",\"\",VLOOKUP(P51,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B52","v":"RR"},{"$f":"IF(Assess!C52=\"\",\"\",Assess!C52)","v":""},{"$f":"IF(Assess!G52=\"\",\"\",Assess!G52)","v":""},{"$f":"Assess!I52","v":""},null,null,"",null,null,{"$f":"Assess!L52","v":""},{"$f":"Assess!M52","v":""},{"$f":"Assess!N52","v":""},{"$f":"IF(G52=\"\",\"\",VLOOKUP(G52,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E52=\"\",\"\",IF(N52=\"\",\"\",VLOOKUP(P52,Lists!$D$41:$E$291,2,FALSE)))","v":""}]
[null,{"$f":"Assess!B53","v":"SS"},{"$f":"IF(Assess!C53=\"\",\"\",Assess!C53)","v":""},{"$f":"IF(Assess!G53=\"\",\"\",Assess!G53)","v":""},{"$f":"Assess!I53","v":""},null,null,"",null,null,{"$f":"Assess!L53","v":""},{"$f":"Assess!M53","v":""},{"$f":"Assess!N53","v":""},{"$f":"IF(G53=\"\",\"\",VLOOKUP(G53,Lists!$L$6:$M$18,2,FALSE))","v":""},"","",{"$f":"IF(E53=\"\",\"\",IF(N53=\"\",\"\",VLOOKUP(P53,Lists!$D$41:$E$291,2,FALSE)))","v":""}]

{"sheet":"Lists","index":4,"n_rows":291,"n_cols":13,"rows_kept":291,"cut":false,"hidden":false,"merged":[[35,7,50,10],[4,17,4,18]]}
["Location","ID"]
["UC Berkeley",1,null,"Yes"]
["UC San Francisco",2,null,"No"]
["UC Davis",3]
["UC Los Angeles",4,null,"Names"]
["UC Riverside",5,null,"Letters",null,null,null,null,null,null,null,"Maximum effectiveness",0.95]
["UC San Diego",6,null,null,null,null,null,null,null,null,null,"Significant improvement",0.9]
["UC Santa Cruz",7,null,"Under-controlled",null,null,null,null,null,null,null,"Substantial improvement",0.75]
["UC Santa Barbara",8,null,"Potentially under-controlled",null,null,null,null,null,null,null,"Moderate improvement",0.6]
["UC Irvine",9,null,"Adequately controlled",null,null,null,null,null,null,null,"Minor improvement",0.3]
["UC Merced",10,null,"Potentially over-controlled",null,null,null,null,null,null,null,"Minimal improvement",0.1]
["UC San Francisco Medical Center",11,null,null,null,null,null,null,null,null,null,"No Change",0]
["UC Davis Medical Center",12,null,"Without Any Controls",null,null,null,null,null,null,null,"Minimal decrease",-0.1]
["UC Los Angeles Medical Center",13,null,"With Current Controls",null,null,null,null,null,null,null,"Minor decrease",-0.3]
["UC San Diego Medical Center",14,null,"After Proposed Control Changes",null,null,null,null,null,null,null,"Moderate decrease",-0.6]
["UC Irvine Medical Center",15,null,null,null,null,null,null,null,null,null,"Substantial decrease",-0.75]
["Office of the President",16,null,"Very high",null,null,null,null,null,null,null,"Significant decrease",-0.9]
["Agriculture and Natural Resources",18,null,"High",null,null,null,null,null,null,null,"Control removed",-1]
["Other/Not Listed",17,null,"Moderate"]
[null,null,null,"Low"]
[null,null,null,"Very low"]
[null,null,null,"Unsure/Don't know"]
[]
[null,null,null,"Less than",null,1.25]
[null,null,null,"Between 1.25 and ",null,5]
[null,null,null,"Between 5 and",null,10]
[null,null,null,"Greater than 10"]
[]
[null,null,"Risk\nAssessment","Compliance Risks",null,"Return to Introduction"]
[null,null,"Additional Controls","Reputational Risks",null,"Return to Parameters"]
[null,null,"Operational Risks","Reporting Risks",null,"Chart"]
[]
[null,null,"Strategic \nRisks","Compliance Risks"]
[null,null,"Financial \nRisks","Reputational Risks"]
[null,null,"Operational Risks","Reporting Risks"]
[null,null,null,null,null,null,null,"Before you begin evaluating these risks, it's necessary to set some common definitions for the scales used to identify varying degrees of a risk's impact and likelihood. It's also important to set common parameters for evaluating the effectiveness of controls. Each of the scales listed corresponds to a numeric value that is used in calculating the final rating for each risk. Sample definitions are provided, but they can be modified to suit your organization's risk appetite and the timeframe of your review. When you've completed this step, begin evaluating your organization's risks on the page linked below."]
[]
[]
[]
["Outcome","Label",null,"Outcome","Label"]
[25,"Under-controlled",null,25,"Under-controlled"]
[23,"Under-controlled",null,24.9,"Under-controlled"]
[22.5,"Under-controlled",null,24.8,"Under-controlled"]
[22,"Under-controlled",null,24.7,"Under-controlled"]
[21,"Under-controlled",null,24.6,"Under-controlled"]
[20.7,"Under-controlled",null,24.5,"Under-controlled"]
[20,"Under-controlled",null,24.4,"Under-controlled"]
[19.8,"Under-controlled",null,24.3,"Under-controlled"]
[19,"Under-controlled",null,24.2,"Under-controlled"]
[18.900000000000002,"Under-controlled",null,24.1,"Under-controlled"]
[18,"Under-controlled",null,24,"Under-controlled"]
[17.5,"Under-controlled",null,23.9,"Under-controlled"]
[17.100000000000001,"Under-controlled",null,23.8,"Under-controlled"]
[17,"Under-controlled",null,23.7,"Under-controlled"]
[16.2,"Under-controlled",null,23.6,"Under-controlled"]
[16.099999999999998,"Under-controlled",null,23.5,"Under-controlled"]
[16,"Under-controlled",null,23.4,"Under-controlled"]
[15.75,"Under-controlled",null,23.3,"Under-controlled"]
[15.5,"Under-controlled",null,23.2,"Under-controlled"]
[15.399999999999999,"Under-controlled",null,23.1,"Under-controlled"]
[15.3,"Under-controlled",null,23,"Under-controlled"]
[15,"Under-controlled",null,22.9,"Under-controlled"]
[14.7,"Under-controlled",null,22.8,"Under-controlled"]
[14.4,"Under-controlled",null,22.7,"Under-controlled"]
[14,"Under-controlled",null,22.6,"Under-controlled"]
[13.950000000000001,"Under-controlled",null,22.5,"Under-controlled"]
[13.5,"Under-controlled",null,22.4,"Under-controlled"]
[13.299999999999999,"Under-controlled",null,22.3,"Under-controlled"]
[13,"Under-controlled",null,22.2,"Under-controlled"]
[12.6,"Under-controlled",null,22.1,"Under-controlled"]
[12.5,"Under-controlled",null,22,"Under-controlled"]
[12.25,"Under-controlled",null,21.9,"Under-controlled"]
[12.15,"Under-controlled",null,21.8,"Under-controlled"]
[12,"Under-controlled",null,21.7,"Under-controlled"]
[11.899999999999999,"Under-controlled",null,21.6,"Under-controlled"]
[11.700000000000001,"Under-controlled",null,21.5,"Under-controlled"]
[11.5,"Under-controlled",null,21.4,"Under-controlled"]
[11.25,"Under-controlled",null,21.3,"Under-controlled"]
[11.2,"Under-controlled",null,21.2,"Under-controlled"]
[11,"Under-controlled",null,21.1,"Under-controlled"]
[10.85,"Under-controlled",null,21,"Under-controlled"]
[10.8,"Under-controlled",null,20.9,"Under-controlled"]
[10.5,"Under-controlled",null,20.8,"Under-controlled"]
[10.35,"Under-controlled",null,20.7,"Under-controlled"]
[10,"Under-controlled",null,20.6,"Under-controlled"]
[9.9,"Potentially under-controlled",null,20.5,"Under-controlled"]
[9.7999999999999989,"Potentially under-controlled",null,20.399999999999999,"Under-controlled"]
[9.5,"Potentially under-controlled",null,20.3,"Under-controlled"]
[9.4499999999999993,"Potentially under-controlled",null,20.2,"Under-controlled"]
[9.2000000000000011,"Potentially under-controlled",null,20.100000000000001,"Under-controlled"]
[9.1,"Potentially under-controlled",null,20,"Under-controlled"]
[9,"Potentially under-controlled",null,19.899999999999999,"Under-controlled"]
[8.8000000000000007,"Potentially under-controlled",null,19.8,"Under-controlled"]
[8.75,"Potentially under-controlled",null,19.7,"Under-controlled"]
[8.5500000000000007,"Potentially under-controlled",null,19.600000000000001,"Under-controlled"]
[8.4,"Potentially under-controlled",null,19.5,"Under-controlled"]
[8.3999999999999986,"Potentially under-controlled",null,19.399999999999999,"Under-controlled"]
[8.1,"Potentially under-controlled",null,19.3,"Under-controlled"]
[8.0499999999999989,"Potentially under-controlled",null,19.2,"Under-controlled"]
[8,"Potentially under-controlled",null,19.100000000000001,"Under-controlled"]
[7.6999999999999993,"Potentially under-controlled",null,19,"Under-controlled"]
[7.6000000000000005,"Potentially under-controlled",null,18.899999999999999,"Under-controlled"]
[7.2,"Potentially under-controlled",null,18.8,"Under-controlled"]
[7,"Potentially under-controlled",null,18.7,"Under-controlled"]
[6.8000000000000007,"Potentially under-controlled",null,18.600000000000001,"Under-controlled"]
[6.6499999999999995,"Potentially under-controlled",null,18.5,"Under-controlled"]
[6.4,"Potentially under-controlled",null,18.399999999999999,"Under-controlled"]
[6.3,"Potentially under-controlled",null,18.3,"Under-controlled"]
[6.25,"Potentially under-controlled",null,18.2,"Under-controlled"]
[6.2,"Potentially under-controlled",null,18.100000000000001,"Under-controlled"]
[6,"Potentially under-controlled",null,18,"Under-controlled"]
[5.75,"Potentially under-controlled",null,17.899999999999999,"Under-controlled"]
[5.6000000000000005,"Potentially under-controlled",null,17.8,"Under-controlled"]
[5.6,"Potentially under-controlled",null,17.7,"Under-controlled"]
[5.5,"Potentially under-controlled",null,17.600000000000001,"Under-controlled"]
[5.4,"Potentially under-controlled",null,17.5,"Under-controlled"]
[5.25,"Potentially under-controlled",null,17.399999999999999,"Under-controlled"]
[5.2,"Potentially under-controlled",null,17.3,"Under-controlled"]
[5,"Potentially under-controlled",null,17.2,"Under-controlled"]
[4.8999999999999995,"Adequately controlled",null,17.100000000000001,"Under-controlled"]
[4.8000000000000007,"Adequately controlled",null,17,"Under-controlled"]
[4.75,"Adequately controlled",null,16.899999999999999,"Under-controlled"]
[4.6000000000000005,"Adequately controlled",null,16.8,"Under-controlled"]
[4.5,"Adequately controlled",null,16.7,"Under-controlled"]
[4.4000000000000004,"Adequately controlled",null,16.600000000000001,"Under-controlled"]
[4.375,"Adequately controlled",null,16.5,"Under-controlled"]
[4.25,"Adequately controlled",null,16.399999999999999,"Under-controlled"]
[4,"Adequately controlled",null,16.3,"Under-controlled"]
[3.875,"Adequately controlled",null,16.2,"Under-controlled"]
[3.8000000000000003,"Adequately controlled",null,16.100000000000001,"Under-controlled"]
[3.75,"Adequately controlled",null,16,"Under-controlled"]
[3.6,"Adequately controlled",null,15.9,"Under-controlled"]
[3.5,"Adequately controlled",null,15.8,"Under-controlled"]
[3.375,"Adequately controlled",null,15.7,"Under-controlled"]
[3.25,"Adequately controlled",null,15.6,"Under-controlled"]
[3.2,"Adequately controlled",null,15.5,"Under-controlled"]
[3.125,"Adequately controlled",null,15.4,"Under-controlled"]
[3,"Adequately controlled",null,15.3,"Under-controlled"]
[2.875,"Adequately controlled",null,15.2,"Under-controlled"]
[2.8000000000000003,"Adequately controlled",null,15.1,"Under-controlled"]
[2.75,"Adequately controlled",null,15,"Under-controlled"]
[2.5,"Adequately controlled",null,14.9,"Under-controlled"]
[2.4999999999999996,"Adequately controlled",null,14.8,"Under-controlled"]
[2.375,"Adequately controlled",null,14.7,"Under-controlled"]
[2.2999999999999994,"Adequately controlled",null,14.6,"Under-controlled"]
[2.25,"Adequately controlled",null,14.5,"Under-controlled"]
[2.1999999999999993,"Adequately controlled",null,14.4,"Under-controlled"]
[2.0999999999999996,"Adequately controlled",null,14.3,"Under-controlled"]
[2,"Adequately controlled",null,14.2,"Under-controlled"]
[1.9999999999999996,"Adequately controlled",null,14.1,"Under-controlled"]
[1.8999999999999995,"Adequately controlled",null,14,"Under-controlled"]
[1.7999999999999996,"Adequately controlled",null,13.9,"Under-controlled"]
[1.75,"Adequately controlled",null,13.8,"Under-controlled"]
[1.7499999999999996,"Adequately controlled",null,13.7,"Under-controlled"]
[1.6999999999999997,"Adequately controlled",null,13.6,"Under-controlled"]
[1.5999999999999996,"Adequately controlled",null,13.5,"Under-controlled"]
[1.5499999999999996,"Adequately controlled",null,13.4,"Under-controlled"]
[1.4999999999999996,"Adequately controlled",null,13.3,"Under-controlled"]
[1.3999999999999997,"Adequately controlled",null,13.2,"Under-controlled"]
[1.3499999999999996,"Adequately controlled",null,13.1,"Under-controlled"]
[1.2999999999999998,"Adequately controlled",null,13,"Under-controlled"]
[1.2500000000000011,"Adequately controlled",null,12.9,"Under-controlled"]
[1.25,"Adequately controlled",null,12.8,"Under-controlled"]
[1.2499999999999998,"Adequately controlled",null,12.7,"Under-controlled"]
[1.1999999999999997,"Potentially over-controlled",null,12.6,"Under-controlled"]
[1.150000000000001,"Potentially over-controlled",null,12.5,"Under-controlled"]
[1.1499999999999997,"Potentially over-controlled",null,12.4,"Under-controlled"]
[1.100000000000001,"Potentially over-controlled",null,12.3,"Under-controlled"]
[1.0999999999999996,"Potentially over-controlled",null,12.2,"Under-controlled"]
[1.0500000000000009,"Potentially over-controlled",null,12.1,"Under-controlled"]
[1.0000000000000009,"Potentially over-controlled",null,12,"Under-controlled"]
[0.99999999999999978,"Potentially over-controlled",null,11.9,"Under-controlled"]
[0.95000000000000084,"Potentially over-controlled",null,11.8,"Under-controlled"]
[0.94999999999999973,"Potentially over-controlled",null,11.7,"Under-controlled"]
[0.9000000000000008,"Potentially over-controlled",null,11.6,"Under-controlled"]
[0.8999999999999998,"Potentially over-controlled",null,11.5,"Under-controlled"]
[0.87500000000000078,"Potentially over-controlled",null,11.4,"Under-controlled"]
[0.85000000000000075,"Potentially over-controlled",null,11.3,"Under-controlled"]
[0.80000000000000071,"Potentially over-controlled",null,11.2,"Under-controlled"]
[0.79999999999999982,"Potentially over-controlled",null,11.1,"Under-controlled"]
[0.77500000000000069,"Potentially over-controlled",null,11,"Under-controlled"]
[0.75000000000000067,"Potentially over-controlled",null,10.9,"Under-controlled"]
[0.70000000000000062,"Potentially over-controlled",null,10.8,"Under-controlled"]
[0.69999999999999984,"Potentially over-controlled",null,10.7,"Under-controlled"]
[0.6750000000000006,"Potentially over-controlled",null,10.6,"Under-controlled"]
[0.65000000000000058,"Potentially over-controlled",null,10.5,"Under-controlled"]
[0.62500000000000056,"Potentially over-controlled",null,10.4,"Under-controlled"]
[0.60000000000000053,"Potentially over-controlled",null,10.3,"Under-controlled"]
[0.57500000000000051,"Potentially over-controlled",null,10.199999999999999,"Under-controlled"]
[0.55000000000000049,"Potentially over-controlled",null,10.1,"Under-controlled"]
[0.50000000000000044,"Potentially over-controlled",null,10,"Under-controlled"]
[0.49999999999999989,"Potentially over-controlled",null,9.9,"Potentially under-controlled"]
[0.47500000000000042,"Potentially over-controlled",null,9.8000000000000007,"Potentially under-controlled"]
[0.4500000000000004,"Potentially over-controlled",null,9.6999999999999993,"Potentially under-controlled"]
[0.40000000000000036,"Potentially over-controlled",null,9.6,"Potentially under-controlled"]
[0.35000000000000031,"Potentially over-controlled",null,9.5,"Potentially under-controlled"]
[0.25000000000000022,"Potentially over-controlled",null,9.4,"Potentially under-controlled"]
[null,null,null,9.3000000000000007,"Potentially under-controlled"]
[null,null,null,9.1999999999999993,"Potentially under-controlled"]
[null,null,null,9.1,"Potentially under-controlled"]
[null,null,null,9,"Potentially under-controlled"]
[null,null,null,8.9,"Potentially under-controlled"]
[null,null,null,8.8000000000000007,"Potentially under-controlled"]
[null,null,null,8.6999999999999993,"Potentially under-controlled"]
[null,null,null,8.6,"Potentially under-controlled"]
[null,null,null,8.5,"Potentially under-controlled"]
[null,null,null,8.4,"Potentially under-controlled"]
[null,null,null,8.3000000000000007,"Potentially under-controlled"]
[null,null,null,8.1999999999999993,"Potentially under-controlled"]
[null,null,null,8.1,"Potentially under-controlled"]
[null,null,null,8,"Potentially under-controlled"]
[null,null,null,7.9,"Potentially under-controlled"]
[null,null,null,7.8,"Potentially under-controlled"]
[null,null,null,7.7,"Potentially under-controlled"]
[null,null,null,7.6,"Potentially under-controlled"]
[null,null,null,7.5,"Potentially under-controlled"]
[null,null,null,7.4,"Potentially under-controlled"]
[null,null,null,7.3,"Potentially under-controlled"]
[null,null,null,7.2,"Potentially under-controlled"]
[null,null,null,7.1,"Potentially under-controlled"]
[null,null,null,7,"Potentially under-controlled"]
[null,null,null,6.9,"Potentially under-controlled"]
[null,null,null,6.8,"Potentially under-controlled"]
[null,null,null,6.7,"Potentially under-controlled"]
[null,null,null,6.6,"Potentially under-controlled"]
[null,null,null,6.5,"Potentially under-controlled"]
[null,null,null,6.4,"Potentially under-controlled"]
[null,null,null,6.3,"Potentially under-controlled"]
[null,null,null,6.2,"Potentially under-controlled"]
[null,null,null,6.1,"Potentially under-controlled"]
[null,null,null,6,"Potentially under-controlled"]
[null,null,null,5.9,"Potentially under-controlled"]
[null,null,null,5.8,"Potentially under-controlled"]
[null,null,null,5.7,"Potentially under-controlled"]
[null,null,null,5.6,"Potentially under-controlled"]
[null,null,null,5.5,"Potentially under-controlled"]
[null,null,null,5.4,"Potentially under-controlled"]
[null,null,null,5.3,"Potentially under-controlled"]
[null,null,null,5.2,"Potentially under-controlled"]
[null,null,null,5.0999999999999996,"Potentially under-controlled"]
[null,null,null,5,"Potentially under-controlled"]
[null,null,null,4.9000000000000004,"Adequately controlled"]
[null,null,null,4.8,"Adequately controlled"]
[null,null,null,4.7,"Adequately controlled"]
[null,null,null,4.5999999999999996,"Adequately controlled"]
[null,null,null,4.5,"Adequately controlled"]
[null,null,null,4.4000000000000004,"Adequately controlled"]
[null,null,null,4.3,"Adequately controlled"]
[null,null,null,4.2,"Adequately controlled"]
[null,null,null,4.0999999999999996,"Adequately controlled"]
[null,null,null,4,"Adequately controlled"]
[null,null,null,3.9,"Adequately controlled"]
[null,null,null,3.8,"Adequately controlled"]
[null,null,null,3.7,"Adequately controlled"]
[null,null,null,3.6,"Adequately controlled"]
[null,null,null,3.5,"Adequately controlled"]
[null,null,null,3.4,"Adequately controlled"]
[null,null,null,3.3,"Adequately controlled"]
[null,null,null,3.2,"Adequately controlled"]
[null,null,null,3.1,"Adequately controlled"]
[null,null,null,3,"Adequately controlled"]
[null,null,null,2.9,"Adequately controlled"]
[null,null,null,2.8,"Adequately controlled"]
[null,null,null,2.7,"Adequately controlled"]
[null,null,null,2.6,"Adequately controlled"]
[null,null,null,2.5,"Adequately controlled"]
[null,null,null,2.4,"Adequately controlled"]
[null,null,null,2.2999999999999998,"Adequately controlled"]
[null,null,null,2.2000000000000002,"Adequately controlled"]
[null,null,null,2.1,"Adequately controlled"]
[null,null,null,2,"Adequately controlled"]
[null,null,null,1.9,"Adequately controlled"]
[null,null,null,1.8,"Adequately controlled"]
[null,null,null,1.7,"Adequately controlled"]
[null,null,null,1.6,"Adequately controlled"]
[null,null,null,1.5,"Adequately controlled"]
[null,null,null,1.4,"Adequately controlled"]
[null,null,null,1.3,"Adequately controlled"]
[null,null,null,1.2,"Potentially over-controlled"]
[null,null,null,1.1000000000000001,"Potentially over-controlled"]
[null,null,null,1,"Potentially over-controlled"]
[null,null,null,0.9,"Potentially over-controlled"]
[null,null,null,0.8,"Potentially over-controlled"]
[null,null,null,0.7,"Potentially over-controlled"]
[null,null,null,0.6,"Potentially over-controlled"]
[null,null,null,0.5,"Potentially over-controlled"]
[null,null,null,0.4,"Potentially over-controlled"]
[null,null,null,0.3,"Potentially over-controlled"]
[null,null,null,0.2,"Potentially over-controlled"]
[null,null,null,0.1,"Potentially over-controlled"]
[null,null,null,0,"Potentially over-controlled"]

{"sheet":"Chart","index":5,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[12,1,12,2],[11,1,11,2],[2,1,9,2]]}
[]
[null,"Overview:"]
[null,"This chart is a graphical representation of the different types of risks identified during your assessment.  The larger the bubble, the higher the residual risk.  The closer the bubble moves to the upper-right hand corner of the graph, the higher the estimated impact and likelihood."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Chart Parameters:"]
[null,"With Current Controls"]
[]
[null,"Labels:"]
[null,"Letters"]

{"sheet":"ChartData","index":6,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["LabelChart","ImpactChart","LikeChart","Rating","Letter","RiskName","ImpactNoControls","LikeNoControls","Controls","ImpactControls","LikeControls","Added","ImpactAdded","LikeAdded"]
[{"$f":"IF(Assess!C9=\"\",\"\",IF(Assess!J9=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E2,F2)))","v":"A"},{"$f":"IF(Assess!C9=\"\",\"\",IF(Assess!J9=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G2,IF(G2=J2,G2,IF(Chart!$B$13=Lists!$D$14,IF(M2=\"\",\"\",G2-J2),G2-M2)))))","v":8.4},{"$f":"IF(Assess!E9=\"\",\"\",IF(Assess!K9=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H2,IF(H2=K2,H2,IF(Chart!$B$13=Lists!$D$14,H2-K2,H2-N2)))))","v":4.2},{"$f":"IF(Assess!C9=\"\",\"\",IF(Assess!J9=\"No\",\"\",SUM(B2:C2)))","v":12.600000000000001},{"$f":"IF(Assess!B9=\"\",\"\",IF(Assess!J9=\"No\",\"\",Assess!B9))","v":"A"},{"$f":"IF(Assess!C9=\"\",\"\",IF(Assess!J9=\"No\",\"\",Assess!C9))","v":"Students contract vaccine preventable diseases: Yellow Fever, Hepatitis A & B, Typhoid, Meningococcal (Meningitis), Rabies, Polio"},{"$f":"IF(Assess!L9=\"\",\"\",IF(Assess!J9=\"No\",\"\",Assess!L9))","v":12},{"$f":"IF(Assess!M9=\"\",\"\",IF(Assess!J9=\"No\",\"\",Assess!M9))","v":6},{"$f":"IF(Assess!J9=\"No\",\"\",IF(Assess!N9=\"\",1,Assess!N9))","v":0.3},{"$f":"IF(I2=\"\",\"\",IF(G2=\"\",\"\",I2*G2))","v":3.5999999999999996},{"$f":"IF(I2=\"\",\"\",IF(H2=\"\",\"\",I2*H2))","v":1.7999999999999998},{"$f":"IF(Assess!J9=\"No\",\"\",IF(Assess2!O9=\"\",I2,Assess2!O9))","v":0.92999999999999994},{"$f":"IF(L2=\"\",\"\",IF(G2=\"\",\"\",L2*G2))","v":11.16},{"$f":"IF(L2=\"\",\"\",IF(H2=\"\",\"\",L2*H2))","v":5.58}]
[{"$f":"IF(Assess!C10=\"\",\"\",IF(Assess!J10=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E3,F3)))","v":"B"},{"$f":"IF(Assess!C10=\"\",\"\",IF(Assess!J10=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G3,IF(G3=J3,G3,IF(Chart!$B$13=Lists!$D$14,IF(M3=\"\",\"\",G3-J3),G3-M3)))))","v":4.8000000000000007},{"$f":"IF(Assess!E10=\"\",\"\",IF(Assess!K10=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H3,IF(H3=K3,H3,IF(Chart!$B$13=Lists!$D$14,H3-K3,H3-N3)))))","v":2.4000000000000004},{"$f":"IF(Assess!C10=\"\",\"\",IF(Assess!J10=\"No\",\"\",SUM(B3:C3)))","v":7.2000000000000011},{"$f":"IF(Assess!B10=\"\",\"\",IF(Assess!J10=\"No\",\"\",Assess!B10))","v":"B"},{"$f":"IF(Assess!C10=\"\",\"\",IF(Assess!J10=\"No\",\"\",Assess!C10))","v":"Meningitis - Students with risk factors for Meningitis (poor overall health, prior infection, birth defect in the skull, a head injury or brain surgery, previous infections such as upper respiratory or Lyme disease, cochlear implant; impaired immune system"},{"$f":"IF(Assess!L10=\"\",\"\",IF(Assess!J10=\"No\",\"\",Assess!L10))","v":12},{"$f":"IF(Assess!M10=\"\",\"\",IF(Assess!J10=\"No\",\"\",Assess!M10))","v":6},{"$f":"IF(Assess!J10=\"No\",\"\",IF(Assess!N10=\"\",1,Assess!N10))","v":0.6},{"$f":"IF(I3=\"\",\"\",IF(G3=\"\",\"\",I3*G3))","v":7.1999999999999993},{"$f":"IF(I3=\"\",\"\",IF(H3=\"\",\"\",I3*H3))","v":3.5999999999999996},{"$f":"IF(Assess!J10=\"No\",\"\",IF(Assess2!O10=\"\",I3,Assess2!O10))","v":0.9},{"$f":"IF(L3=\"\",\"\",IF(G3=\"\",\"\",L3*G3))","v":10.8},{"$f":"IF(L3=\"\",\"\",IF(H3=\"\",\"\",L3*H3))","v":5.4}]
[{"$f":"IF(Assess!C11=\"\",\"\",IF(Assess!J11=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E4,F4)))","v":"C"},{"$f":"IF(Assess!C11=\"\",\"\",IF(Assess!J11=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G4,IF(G4=J4,G4,IF(Chart!$B$13=Lists!$D$14,IF(M4=\"\",\"\",G4-J4),G4-M4)))))","v":3.75},{"$f":"IF(Assess!E11=\"\",\"\",IF(Assess!K11=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H4,IF(H4=K4,H4,IF(Chart!$B$13=Lists!$D$14,H4-K4,H4-N4)))))","v":2.5},{"$f":"IF(Assess!C11=\"\",\"\",IF(Assess!J11=\"No\",\"\",SUM(B4:C4)))","v":6.25},{"$f":"IF(Assess!B11=\"\",\"\",IF(Assess!J11=\"No\",\"\",Assess!B11))","v":"C"},{"$f":"IF(Assess!C11=\"\",\"\",IF(Assess!J11=\"No\",\"\",Assess!C11))","v":"Malaria - Students with risk factors for Malaria (stopping or not adhering to prophylaxis, not taking personal protective measures, using substandard drugs purchased over seas, not follow-up if symptoms occur)"},{"$f":"IF(Assess!L11=\"\",\"\",IF(Assess!J11=\"No\",\"\",Assess!L11))","v":15},{"$f":"IF(Assess!M11=\"\",\"\",IF(Assess!J11=\"No\",\"\",Assess!M11))","v":10},{"$f":"IF(Assess!J11=\"No\",\"\",IF(Assess!N11=\"\",1,Assess!N11))","v":0.75},11.25,7.5,{"$f":"IF(Assess!J11=\"No\",\"\",IF(Assess2!O11=\"\",I4,Assess2!O11))","v":0.75},11.25,7.5]
[{"$f":"IF(Assess!C12=\"\",\"\",IF(Assess!J12=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E5,F5)))","v":"D"},{"$f":"IF(Assess!C12=\"\",\"\",IF(Assess!J12=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G5,IF(G5=J5,G5,IF(Chart!$B$13=Lists!$D$14,IF(M5=\"\",\"\",G5-J5),G5-M5)))))","v":3.75},{"$f":"IF(Assess!E12=\"\",\"\",IF(Assess!K12=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H5,IF(H5=K5,H5,IF(Chart!$B$13=Lists!$D$14,H5-K5,H5-N5)))))","v":2.5},{"$f":"IF(Assess!C12=\"\",\"\",IF(Assess!J12=\"No\",\"\",SUM(B5:C5)))","v":6.25},{"$f":"IF(Assess!B12=\"\",\"\",IF(Assess!J12=\"No\",\"\",Assess!B12))","v":"D"},{"$f":"IF(Assess!C12=\"\",\"\",IF(Assess!J12=\"No\",\"\",Assess!C12))","v":"Parasitic Infection - Students contract parasitic infections (consuming or exposure to contaminated water by drinking, swimming or bathing) for which no vaccines or preventive drugs are available"},{"$f":"IF(Assess!L12=\"\",\"\",IF(Assess!J12=\"No\",\"\",Assess!L12))","v":15},{"$f":"IF(Assess!M12=\"\",\"\",IF(Assess!J12=\"No\",\"\",Assess!M12))","v":10},{"$f":"IF(Assess!J12=\"No\",\"\",IF(Assess!N12=\"\",1,Assess!N12))","v":0.75},11.25,7.5,{"$f":"IF(Assess!J12=\"No\",\"\",IF(Assess2!O12=\"\",I5,Assess2!O12))","v":0.75},11.25,7.5]
[{"$f":"IF(Assess!C13=\"\",\"\",IF(Assess!J13=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E6,F6)))","v":"E"},{"$f":"IF(Assess!C13=\"\",\"\",IF(Assess!J13=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G6,IF(G6=J6,G6,IF(Chart!$B$13=Lists!$D$14,IF(M6=\"\",\"\",G6-J6),G6-M6)))))","v":3.75},{"$f":"IF(Assess!E13=\"\",\"\",IF(Assess!K13=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H6,IF(H6=K6,H6,IF(Chart!$B$13=Lists!$D$14,H6-K6,H6-N6)))))","v":1.5},{"$f":"IF(Assess!C13=\"\",\"\",IF(Assess!J13=\"No\",\"\",SUM(B6:C6)))","v":5.25},{"$f":"IF(Assess!B13=\"\",\"\",IF(Assess!J13=\"No\",\"\",Assess!B13))","v":"E"},{"$f":"IF(Assess!C13=\"\",\"\",IF(Assess!J13=\"No\",\"\",Assess!C13))","v":"Rabies - a preventable and acute viral disease of the central nervous system, most often transmitted through the bite of a rabid animal."},{"$f":"IF(Assess!L13=\"\",\"\",IF(Assess!J13=\"No\",\"\",Assess!L13))","v":15},{"$f":"IF(Assess!M13=\"\",\"\",IF(Assess!J13=\"No\",\"\",Assess!M13))","v":6},{"$f":"IF(Assess!J13=\"No\",\"\",IF(Assess!N13=\"\",1,Assess!N13))","v":0.75},11.25,4.5,{"$f":"IF(Assess!J13=\"No\",\"\",IF(Assess2!O13=\"\",I6,Assess2!O13))","v":0.75},11.25,4.5]
[{"$f":"IF(Assess!C14=\"\",\"\",IF(Assess!J14=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E7,F7)))","v":"F"},{"$f":"IF(Assess!C14=\"\",\"\",IF(Assess!J14=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G7,IF(G7=J7,G7,IF(Chart!$B$13=Lists!$D$14,IF(M7=\"\",\"\",G7-J7),G7-M7)))))","v":1.1999999999999993},{"$f":"IF(Assess!E14=\"\",\"\",IF(Assess!K14=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H7,IF(H7=K7,H7,IF(Chart!$B$13=Lists!$D$14,H7-K7,H7-N7)))))","v":0.59999999999999964},{"$f":"IF(Assess!C14=\"\",\"\",IF(Assess!J14=\"No\",\"\",SUM(B7:C7)))","v":1.7999999999999989},{"$f":"IF(Assess!B14=\"\",\"\",IF(Assess!J14=\"No\",\"\",Assess!B14))","v":"F"},{"$f":"IF(Assess!C14=\"\",\"\",IF(Assess!J14=\"No\",\"\",Assess!C14))","v":"Insect Precautions – Many serious diseases transmitted by insects require careful avoidance and use of protective measures as there are no immunizations and medications. Travelers visiting rural areas or engaging in camping, hiking or adventure travel are at the greatest risk of exposure to mosquitoes, ticks, mites, fleas and other disease-carrying insects, but even urban visitors need to take precautions to avoid insect exposure in some areas."},{"$f":"IF(Assess!L14=\"\",\"\",IF(Assess!J14=\"No\",\"\",Assess!L14))","v":12},{"$f":"IF(Assess!M14=\"\",\"\",IF(Assess!J14=\"No\",\"\",Assess!M14))","v":6},{"$f":"IF(Assess!J14=\"No\",\"\",IF(Assess!N14=\"\",1,Assess!N14))","v":0.9},10.8,5.4,{"$f":"IF(Assess!J14=\"No\",\"\",IF(Assess2!O14=\"\",I7,Assess2!O14))","v":0.9},10.8,5.4]
[{"$f":"IF(Assess!C15=\"\",\"\",IF(Assess!J15=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E8,F8)))","v":"G"},{"$f":"IF(Assess!C15=\"\",\"\",IF(Assess!J15=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G8,IF(G8=J8,G8,IF(Chart!$B$13=Lists!$D$14,IF(M8=\"\",\"\",G8-J8),G8-M8)))))","v":4.8000000000000007},{"$f":"IF(Assess!E15=\"\",\"\",IF(Assess!K15=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H8,IF(H8=K8,H8,IF(Chart!$B$13=Lists!$D$14,H8-K8,H8-N8)))))","v":3.2},{"$f":"IF(Assess!C15=\"\",\"\",IF(Assess!J15=\"No\",\"\",SUM(B8:C8)))","v":8},{"$f":"IF(Assess!B15=\"\",\"\",IF(Assess!J15=\"No\",\"\",Assess!B15))","v":"G"},{"$f":"IF(Assess!C15=\"\",\"\",IF(Assess!J15=\"No\",\"\",Assess!C15))","v":"Food/Water Safety - Students consume unsafe food and/or water contaminated with toxins or diseases  Local water supplies are limited and contaminated with raw sewage, pesticides and industrial waste.  Some types of fish may contain poisonous biotoxins even when cooked. "},{"$f":"IF(Assess!L15=\"\",\"\",IF(Assess!J15=\"No\",\"\",Assess!L15))","v":12},{"$f":"IF(Assess!M15=\"\",\"\",IF(Assess!J15=\"No\",\"\",Assess!M15))","v":8},{"$f":"IF(Assess!J15=\"No\",\"\",IF(Assess!N15=\"\",1,Assess!N15))","v":0.6},7.1999999999999993,4.8,{"$f":"IF(Assess!J15=\"No\",\"\",IF(Assess2!O15=\"\",I8,Assess2!O15))","v":0.6},7.1999999999999993,4.8]
[{"$f":"IF(Assess!C16=\"\",\"\",IF(Assess!J16=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E9,F9)))","v":"H"},{"$f":"IF(Assess!C16=\"\",\"\",IF(Assess!J16=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G9,IF(G9=J9,G9,IF(Chart!$B$13=Lists!$D$14,IF(M9=\"\",\"\",G9-J9),G9-M9)))))","v":1.1999999999999993},{"$f":"IF(Assess!E16=\"\",\"\",IF(Assess!K16=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H9,IF(H9=K9,H9,IF(Chart!$B$13=Lists!$D$14,H9-K9,H9-N9)))))","v":0.79999999999999982},{"$f":"IF(Assess!C16=\"\",\"\",IF(Assess!J16=\"No\",\"\",SUM(B9:C9)))","v":1.9999999999999991},{"$f":"IF(Assess!B16=\"\",\"\",IF(Assess!J16=\"No\",\"\",Assess!B16))","v":"H"},{"$f":"IF(Assess!C16=\"\",\"\",IF(Assess!J16=\"No\",\"\",Assess!C16))","v":"Medical Facilities - Students seriously sick and requiring hospitalization do not get needed care or receive substandard care; medical facilities are limited in Accra and may be nonexistent elsewhere; most doctors and hospitals expect payment in cash, regardless of travel health insurance.  Differing cultural expectations in Ghana affect care. "},{"$f":"IF(Assess!L16=\"\",\"\",IF(Assess!J16=\"No\",\"\",Assess!L16))","v":12},{"$f":"IF(Assess!M16=\"\",\"\",IF(Assess!J16=\"No\",\"\",Assess!M16))","v":8},{"$f":"IF(Assess!J16=\"No\",\"\",IF(Assess!N16=\"\",1,Assess!N16))","v":0.9},10.8,7.2,{"$f":"IF(Assess!J16=\"No\",\"\",IF(Assess2!O16=\"\",I9,Assess2!O16))","v":0.9},10.8,7.2]
[{"$f":"IF(Assess!C17=\"\",\"\",IF(Assess!J17=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E10,F10)))","v":"I"},{"$f":"IF(Assess!C17=\"\",\"\",IF(Assess!J17=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G10,IF(G10=J10,G10,IF(Chart!$B$13=Lists!$D$14,IF(M10=\"\",\"\",G10-J10),G10-M10)))))","v":0.90000000000000036},{"$f":"IF(Assess!E17=\"\",\"\",IF(Assess!K17=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H10,IF(H10=K10,H10,IF(Chart!$B$13=Lists!$D$14,H10-K10,H10-N10)))))","v":0.59999999999999964},{"$f":"IF(Assess!C17=\"\",\"\",IF(Assess!J17=\"No\",\"\",SUM(B10:C10)))","v":1.5},{"$f":"IF(Assess!B17=\"\",\"\",IF(Assess!J17=\"No\",\"\",Assess!B17))","v":"I"},{"$f":"IF(Assess!C17=\"\",\"\",IF(Assess!J17=\"No\",\"\",Assess!C17))","v":"Mental Health - Students with recent or ongoing mental health concerns fail to document in advance of the EAP health clearance and travel, her/his condition and detailed plan for continuing care while away. "},{"$f":"IF(Assess!L17=\"\",\"\",IF(Assess!J17=\"No\",\"\",Assess!L17))","v":9},{"$f":"IF(Assess!M17=\"\",\"\",IF(Assess!J17=\"No\",\"\",Assess!M17))","v":6},{"$f":"IF(Assess!J17=\"No\",\"\",IF(Assess!N17=\"\",1,Assess!N17))","v":0.9},8.1,5.4,{"$f":"IF(Assess!J17=\"No\",\"\",IF(Assess2!O17=\"\",I10,Assess2!O17))","v":0.9},8.1,5.4]
[{"$f":"IF(Assess!C18=\"\",\"\",IF(Assess!J18=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E11,F11)))","v":""},{"$f":"IF(Assess!C18=\"\",\"\",IF(Assess!J18=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G11,IF(G11=J11,G11,IF(Chart!$B$13=Lists!$D$14,IF(M11=\"\",\"\",G11-J11),G11-M11)))))","v":""},{"$f":"IF(Assess!E18=\"\",\"\",IF(Assess!K18=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H11,IF(H11=K11,H11,IF(Chart!$B$13=Lists!$D$14,H11-K11,H11-N11)))))","v":""},{"$f":"IF(Assess!C18=\"\",\"\",IF(Assess!J18=\"No\",\"\",SUM(B11:C11)))","v":""},{"$f":"IF(Assess!B18=\"\",\"\",IF(Assess!J18=\"No\",\"\",Assess!B18))","v":""},{"$f":"IF(Assess!C18=\"\",\"\",IF(Assess!J18=\"No\",\"\",Assess!C18))","v":""},{"$f":"IF(Assess!L18=\"\",\"\",IF(Assess!J18=\"No\",\"\",Assess!L18))","v":""},{"$f":"IF(Assess!M18=\"\",\"\",IF(Assess!J18=\"No\",\"\",Assess!M18))","v":""},{"$f":"IF(Assess!J18=\"No\",\"\",IF(Assess!N18=\"\",1,Assess!N18))","v":""},"","",{"$f":"IF(Assess!J18=\"No\",\"\",IF(Assess2!O18=\"\",I11,Assess2!O18))","v":""},"",""]
[{"$f":"IF(Assess!C19=\"\",\"\",IF(Assess!J19=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E12,F12)))","v":"K"},{"$f":"IF(Assess!C19=\"\",\"\",IF(Assess!J19=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G12,IF(G12=J12,G12,IF(Chart!$B$13=Lists!$D$14,IF(M12=\"\",\"\",G12-J12),G12-M12)))))","v":4.8000000000000007},{"$f":"IF(Assess!E19=\"\",\"\",IF(Assess!K19=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H12,IF(H12=K12,H12,IF(Chart!$B$13=Lists!$D$14,H12-K12,H12-N12)))))","v":3.2},{"$f":"IF(Assess!C19=\"\",\"\",IF(Assess!J19=\"No\",\"\",SUM(B12:C12)))","v":8},{"$f":"IF(Assess!B19=\"\",\"\",IF(Assess!J19=\"No\",\"\",Assess!B19))","v":"K"},{"$f":"IF(Assess!C19=\"\",\"\",IF(Assess!J19=\"No\",\"\",Assess!C19))","v":"Road Safety - Road traffic accidents may be one of the main threats facing students.  Roads are mainly in a poor condition, particularly in rural areas.  Road travel can be extremely hazardous due to poor driving practices, poorly maintained vehicles, insufficient street lighting, roaming livestock, pedestrians and cyclists.  Safety standards on small private buses and taxis are often low and do not meet US standards"},{"$f":"IF(Assess!L19=\"\",\"\",IF(Assess!J19=\"No\",\"\",Assess!L19))","v":12},{"$f":"IF(Assess!M19=\"\",\"\",IF(Assess!J19=\"No\",\"\",Assess!M19))","v":8},{"$f":"IF(Assess!J19=\"No\",\"\",IF(Assess!N19=\"\",1,Assess!N19))","v":0.6},7.1999999999999993,4.8,{"$f":"IF(Assess!J19=\"No\",\"\",IF(Assess2!O19=\"\",I12,Assess2!O19))","v":0.6},7.1999999999999993,4.8]
[{"$f":"IF(Assess!C20=\"\",\"\",IF(Assess!J20=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E13,F13)))","v":"L"},{"$f":"IF(Assess!C20=\"\",\"\",IF(Assess!J20=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G13,IF(G13=J13,G13,IF(Chart!$B$13=Lists!$D$14,IF(M13=\"\",\"\",G13-J13),G13-M13)))))","v":4.8000000000000007},{"$f":"IF(Assess!E20=\"\",\"\",IF(Assess!K20=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H13,IF(H13=K13,H13,IF(Chart!$B$13=Lists!$D$14,H13-K13,H13-N13)))))","v":3.2},{"$f":"IF(Assess!C20=\"\",\"\",IF(Assess!J20=\"No\",\"\",SUM(B13:C13)))","v":8},{"$f":"IF(Assess!B20=\"\",\"\",IF(Assess!J20=\"No\",\"\",Assess!B20))","v":"L"},{"$f":"IF(Assess!C20=\"\",\"\",IF(Assess!J20=\"No\",\"\",Assess!C20))","v":"Tro Tro Accidents - Tro-Tros are the cheapest way to get around Accra.  Tro-tros are usually made from converted minibuses and are designed to fit as many people, possessions, and occasionally livestock, as possible."},{"$f":"IF(Assess!L20=\"\",\"\",IF(Assess!J20=\"No\",\"\",Assess!L20))","v":12},{"$f":"IF(Assess!M20=\"\",\"\",IF(Assess!J20=\"No\",\"\",Assess!M20))","v":8},{"$f":"IF(Assess!J20=\"No\",\"\",IF(Assess!N20=\"\",1,Assess!N20))","v":0.6},7.1999999999999993,4.8,{"$f":"IF(Assess!J20=\"No\",\"\",IF(Assess2!O20=\"\",I13,Assess2!O20))","v":0.6},7.1999999999999993,4.8]
[{"$f":"IF(Assess!C21=\"\",\"\",IF(Assess!J21=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E14,F14)))","v":"M"},{"$f":"IF(Assess!C21=\"\",\"\",IF(Assess!J21=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G14,IF(G14=J14,G14,IF(Chart!$B$13=Lists!$D$14,IF(M14=\"\",\"\",G14-J14),G14-M14)))))","v":2.25},{"$f":"IF(Assess!E21=\"\",\"\",IF(Assess!K21=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H14,IF(H14=K14,H14,IF(Chart!$B$13=Lists!$D$14,H14-K14,H14-N14)))))","v":1.5},{"$f":"IF(Assess!C21=\"\",\"\",IF(Assess!J21=\"No\",\"\",SUM(B14:C14)))","v":3.75},{"$f":"IF(Assess!B21=\"\",\"\",IF(Assess!J21=\"No\",\"\",Assess!B21))","v":"M"},{"$f":"IF(Assess!C21=\"\",\"\",IF(Assess!J21=\"No\",\"\",Assess!C21))","v":"Taxis - Criminals sometimes use taxis to rob patrons."},{"$f":"IF(Assess!L21=\"\",\"\",IF(Assess!J21=\"No\",\"\",Assess!L21))","v":9},{"$f":"IF(Assess!M21=\"\",\"\",IF(Assess!J21=\"No\",\"\",Assess!M21))","v":6},{"$f":"IF(Assess!J21=\"No\",\"\",IF(Assess!N21=\"\",1,Assess!N21))","v":0.75},6.75,4.5,{"$f":"IF(Assess!J21=\"No\",\"\",IF(Assess2!O21=\"\",I14,Assess2!O21))","v":0.75},6.75,4.5]
[{"$f":"IF(Assess!C22=\"\",\"\",IF(Assess!J22=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E15,F15)))","v":"N"},{"$f":"IF(Assess!C22=\"\",\"\",IF(Assess!J22=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G15,IF(G15=J15,G15,IF(Chart!$B$13=Lists!$D$14,IF(M15=\"\",\"\",G15-J15),G15-M15)))))","v":3},{"$f":"IF(Assess!E22=\"\",\"\",IF(Assess!K22=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H15,IF(H15=K15,H15,IF(Chart!$B$13=Lists!$D$14,H15-K15,H15-N15)))))","v":1},{"$f":"IF(Assess!C22=\"\",\"\",IF(Assess!J22=\"No\",\"\",SUM(B15:C15)))","v":4},{"$f":"IF(Assess!B22=\"\",\"\",IF(Assess!J22=\"No\",\"\",Assess!B22))","v":"N"},{"$f":"IF(Assess!C22=\"\",\"\",IF(Assess!J22=\"No\",\"\",Assess!C22))","v":"Ghanaian law criminalizes homosexuality.  A large portion of Ghanaian society does not accept that such activity exists.  A gay social life exists, mostly in the form of house parties, and a few queer-friendly clubs in Accra, but there are risks."},{"$f":"IF(Assess!L22=\"\",\"\",IF(Assess!J22=\"No\",\"\",Assess!L22))","v":12},{"$f":"IF(Assess!M22=\"\",\"\",IF(Assess!J22=\"No\",\"\",Assess!M22))","v":4},{"$f":"IF(Assess!J22=\"No\",\"\",IF(Assess!N22=\"\",1,Assess!N22))","v":0.75},9,3,{"$f":"IF(Assess!J22=\"No\",\"\",IF(Assess2!O22=\"\",I15,Assess2!O22))","v":0.75},9,3]
[{"$f":"IF(Assess!C23=\"\",\"\",IF(Assess!J23=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E16,F16)))","v":"O"},{"$f":"IF(Assess!C23=\"\",\"\",IF(Assess!J23=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G16,IF(G16=J16,G16,IF(Chart!$B$13=Lists!$D$14,IF(M16=\"\",\"\",G16-J16),G16-M16)))))","v":2.25},{"$f":"IF(Assess!E23=\"\",\"\",IF(Assess!K23=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H16,IF(H16=K16,H16,IF(Chart!$B$13=Lists!$D$14,H16-K16,H16-N16)))))","v":2},{"$f":"IF(Assess!C23=\"\",\"\",IF(Assess!J23=\"No\",\"\",SUM(B16:C16)))","v":4.25},{"$f":"IF(Assess!B23=\"\",\"\",IF(Assess!J23=\"No\",\"\",Assess!B23))","v":"O"},{"$f":"IF(Assess!C23=\"\",\"\",IF(Assess!J23=\"No\",\"\",Assess!C23))","v":"Non-Violent Crime - Street theft is the most common; Street persons asking for handouts may grab jewelry or other items from one's neck or wrist, or distract the victim for a pickpocket; criminals will sometimes use motorcycles to drive by unsuspecting pedestrians and snatch their bags.  Theft of unattended property is common in Ghana."},{"$f":"IF(Assess!L23=\"\",\"\",IF(Assess!J23=\"No\",\"\",Assess!L23))","v":9},{"$f":"IF(Assess!M23=\"\",\"\",IF(Assess!J23=\"No\",\"\",Assess!M23))","v":8},{"$f":"IF(Assess!J23=\"No\",\"\",IF(Assess!N23=\"\",1,Assess!N23))","v":0.75},6.75,6,{"$f":"IF(Assess!J23=\"No\",\"\",IF(Assess2!O23=\"\",I16,Assess2!O23))","v":0.75},6.75,6]
[{"$f":"IF(Assess!C24=\"\",\"\",IF(Assess!J24=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E17,F17)))","v":"P"},{"$f":"IF(Assess!C24=\"\",\"\",IF(Assess!J24=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G17,IF(G17=J17,G17,IF(Chart!$B$13=Lists!$D$14,IF(M17=\"\",\"\",G17-J17),G17-M17)))))","v":3},{"$f":"IF(Assess!E24=\"\",\"\",IF(Assess!K24=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H17,IF(H17=K17,H17,IF(Chart!$B$13=Lists!$D$14,H17-K17,H17-N17)))))","v":1.5},{"$f":"IF(Assess!C24=\"\",\"\",IF(Assess!J24=\"No\",\"\",SUM(B17:C17)))","v":4.5},{"$f":"IF(Assess!B24=\"\",\"\",IF(Assess!J24=\"No\",\"\",Assess!B24))","v":"P"},{"$f":"IF(Assess!C24=\"\",\"\",IF(Assess!J24=\"No\",\"\",Assess!C24))","v":"Violent Crime - includes muggings carried out by groups of men; armed robbery using machetes or handguns; Home invasions by criminals who are sometimes armed;"},{"$f":"IF(Assess!L24=\"\",\"\",IF(Assess!J24=\"No\",\"\",Assess!L24))","v":12},{"$f":"IF(Assess!M24=\"\",\"\",IF(Assess!J24=\"No\",\"\",Assess!M24))","v":6},{"$f":"IF(Assess!J24=\"No\",\"\",IF(Assess!N24=\"\",1,Assess!N24))","v":0.75},9,4.5,{"$f":"IF(Assess!J24=\"No\",\"\",IF(Assess2!O24=\"\",I17,Assess2!O24))","v":0.75},9,4.5]
[{"$f":"IF(Assess!C25=\"\",\"\",IF(Assess!J25=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E18,F18)))","v":"Q"},{"$f":"IF(Assess!C25=\"\",\"\",IF(Assess!J25=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G18,IF(G18=J18,G18,IF(Chart!$B$13=Lists!$D$14,IF(M18=\"\",\"\",G18-J18),G18-M18)))))","v":12},{"$f":"IF(Assess!E25=\"\",\"\",IF(Assess!K25=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H18,IF(H18=K18,H18,IF(Chart!$B$13=Lists!$D$14,H18-K18,H18-N18)))))","v":6},{"$f":"IF(Assess!C25=\"\",\"\",IF(Assess!J25=\"No\",\"\",SUM(B18:C18)))","v":18},{"$f":"IF(Assess!B25=\"\",\"\",IF(Assess!J25=\"No\",\"\",Assess!B25))","v":"Q"},{"$f":"IF(Assess!C25=\"\",\"\",IF(Assess!J25=\"No\",\"\",Assess!C25))","v":"The Ghanaian Police Service (GPS) is almost solely a reactive force and demonstrates moderate proactive techniques to deter criminals. Police often lack the equipment, resources, training, and personnel to respond to calls for assistance or other emergencies. The police have a poor record of investigating and solving serious crimes."},{"$f":"IF(Assess!L25=\"\",\"\",IF(Assess!J25=\"No\",\"\",Assess!L25))","v":12},{"$f":"IF(Assess!M25=\"\",\"\",IF(Assess!J25=\"No\",\"\",Assess!M25))","v":6},{"$f":"IF(Assess!J25=\"No\",\"\",IF(Assess!N25=\"\",1,Assess!N25))","v":1},12,6,{"$f":"IF(Assess!J25=\"No\",\"\",IF(Assess2!O25=\"\",I18,Assess2!O25))","v":1},12,6]
[{"$f":"IF(Assess!C26=\"\",\"\",IF(Assess!J26=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E19,F19)))","v":""},{"$f":"IF(Assess!C26=\"\",\"\",IF(Assess!J26=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G19,IF(G19=J19,G19,IF(Chart!$B$13=Lists!$D$14,IF(M19=\"\",\"\",G19-J19),G19-M19)))))","v":""},{"$f":"IF(Assess!E26=\"\",\"\",IF(Assess!K26=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H19,IF(H19=K19,H19,IF(Chart!$B$13=Lists!$D$14,H19-K19,H19-N19)))))","v":""},{"$f":"IF(Assess!C26=\"\",\"\",IF(Assess!J26=\"No\",\"\",SUM(B19:C19)))","v":""},{"$f":"IF(Assess!B26=\"\",\"\",IF(Assess!J26=\"No\",\"\",Assess!B26))","v":""},{"$f":"IF(Assess!C26=\"\",\"\",IF(Assess!J26=\"No\",\"\",Assess!C26))","v":""},{"$f":"IF(Assess!L26=\"\",\"\",IF(Assess!J26=\"No\",\"\",Assess!L26))","v":""},{"$f":"IF(Assess!M26=\"\",\"\",IF(Assess!J26=\"No\",\"\",Assess!M26))","v":""},{"$f":"IF(Assess!J26=\"No\",\"\",IF(Assess!N26=\"\",1,Assess!N26))","v":""},"","",{"$f":"IF(Assess!J26=\"No\",\"\",IF(Assess2!O26=\"\",I19,Assess2!O26))","v":""},"",""]
[{"$f":"IF(Assess!C27=\"\",\"\",IF(Assess!J27=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E20,F20)))","v":""},{"$f":"IF(Assess!C27=\"\",\"\",IF(Assess!J27=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G20,IF(G20=J20,G20,IF(Chart!$B$13=Lists!$D$14,IF(M20=\"\",\"\",G20-J20),G20-M20)))))","v":""},{"$f":"IF(Assess!E27=\"\",\"\",IF(Assess!K27=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H20,IF(H20=K20,H20,IF(Chart!$B$13=Lists!$D$14,H20-K20,H20-N20)))))","v":""},{"$f":"IF(Assess!C27=\"\",\"\",IF(Assess!J27=\"No\",\"\",SUM(B20:C20)))","v":""},{"$f":"IF(Assess!B27=\"\",\"\",IF(Assess!J27=\"No\",\"\",Assess!B27))","v":""},{"$f":"IF(Assess!C27=\"\",\"\",IF(Assess!J27=\"No\",\"\",Assess!C27))","v":""},{"$f":"IF(Assess!L27=\"\",\"\",IF(Assess!J27=\"No\",\"\",Assess!L27))","v":""},{"$f":"IF(Assess!M27=\"\",\"\",IF(Assess!J27=\"No\",\"\",Assess!M27))","v":""},{"$f":"IF(Assess!J27=\"No\",\"\",IF(Assess!N27=\"\",1,Assess!N27))","v":""},"","",{"$f":"IF(Assess!J27=\"No\",\"\",IF(Assess2!O27=\"\",I20,Assess2!O27))","v":""},"",""]
[{"$f":"IF(Assess!C28=\"\",\"\",IF(Assess!J28=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E21,F21)))","v":""},{"$f":"IF(Assess!C28=\"\",\"\",IF(Assess!J28=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G21,IF(G21=J21,G21,IF(Chart!$B$13=Lists!$D$14,IF(M21=\"\",\"\",G21-J21),G21-M21)))))","v":""},{"$f":"IF(Assess!E28=\"\",\"\",IF(Assess!K28=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H21,IF(H21=K21,H21,IF(Chart!$B$13=Lists!$D$14,H21-K21,H21-N21)))))","v":""},{"$f":"IF(Assess!C28=\"\",\"\",IF(Assess!J28=\"No\",\"\",SUM(B21:C21)))","v":""},{"$f":"IF(Assess!B28=\"\",\"\",IF(Assess!J28=\"No\",\"\",Assess!B28))","v":""},{"$f":"IF(Assess!C28=\"\",\"\",IF(Assess!J28=\"No\",\"\",Assess!C28))","v":""},{"$f":"IF(Assess!L28=\"\",\"\",IF(Assess!J28=\"No\",\"\",Assess!L28))","v":""},{"$f":"IF(Assess!M28=\"\",\"\",IF(Assess!J28=\"No\",\"\",Assess!M28))","v":""},{"$f":"IF(Assess!J28=\"No\",\"\",IF(Assess!N28=\"\",1,Assess!N28))","v":""},"","",{"$f":"IF(Assess!J28=\"No\",\"\",IF(Assess2!O28=\"\",I21,Assess2!O28))","v":""},"",""]
[{"$f":"IF(Assess!C29=\"\",\"\",IF(Assess!J29=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E22,F22)))","v":""},{"$f":"IF(Assess!C29=\"\",\"\",IF(Assess!J29=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G22,IF(G22=J22,G22,IF(Chart!$B$13=Lists!$D$14,IF(M22=\"\",\"\",G22-J22),G22-M22)))))","v":""},{"$f":"IF(Assess!E29=\"\",\"\",IF(Assess!K29=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H22,IF(H22=K22,H22,IF(Chart!$B$13=Lists!$D$14,H22-K22,H22-N22)))))","v":""},{"$f":"IF(Assess!C29=\"\",\"\",IF(Assess!J29=\"No\",\"\",SUM(B22:C22)))","v":""},{"$f":"IF(Assess!B29=\"\",\"\",IF(Assess!J29=\"No\",\"\",Assess!B29))","v":""},{"$f":"IF(Assess!C29=\"\",\"\",IF(Assess!J29=\"No\",\"\",Assess!C29))","v":""},{"$f":"IF(Assess!L29=\"\",\"\",IF(Assess!J29=\"No\",\"\",Assess!L29))","v":""},{"$f":"IF(Assess!M29=\"\",\"\",IF(Assess!J29=\"No\",\"\",Assess!M29))","v":""},{"$f":"IF(Assess!J29=\"No\",\"\",IF(Assess!N29=\"\",1,Assess!N29))","v":""},"","",{"$f":"IF(Assess!J29=\"No\",\"\",IF(Assess2!O29=\"\",I22,Assess2!O29))","v":""},"",""]
[{"$f":"IF(Assess!C30=\"\",\"\",IF(Assess!J30=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E23,F23)))","v":""},{"$f":"IF(Assess!C30=\"\",\"\",IF(Assess!J30=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G23,IF(G23=J23,G23,IF(Chart!$B$13=Lists!$D$14,IF(M23=\"\",\"\",G23-J23),G23-M23)))))","v":""},{"$f":"IF(Assess!E30=\"\",\"\",IF(Assess!K30=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H23,IF(H23=K23,H23,IF(Chart!$B$13=Lists!$D$14,H23-K23,H23-N23)))))","v":""},{"$f":"IF(Assess!C30=\"\",\"\",IF(Assess!J30=\"No\",\"\",SUM(B23:C23)))","v":""},{"$f":"IF(Assess!B30=\"\",\"\",IF(Assess!J30=\"No\",\"\",Assess!B30))","v":""},{"$f":"IF(Assess!C30=\"\",\"\",IF(Assess!J30=\"No\",\"\",Assess!C30))","v":""},{"$f":"IF(Assess!L30=\"\",\"\",IF(Assess!J30=\"No\",\"\",Assess!L30))","v":""},{"$f":"IF(Assess!M30=\"\",\"\",IF(Assess!J30=\"No\",\"\",Assess!M30))","v":""},{"$f":"IF(Assess!J30=\"No\",\"\",IF(Assess!N30=\"\",1,Assess!N30))","v":""},"","",{"$f":"IF(Assess!J30=\"No\",\"\",IF(Assess2!O30=\"\",I23,Assess2!O30))","v":""},"",""]
[{"$f":"IF(Assess!C31=\"\",\"\",IF(Assess!J31=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E24,F24)))","v":""},{"$f":"IF(Assess!C31=\"\",\"\",IF(Assess!J31=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G24,IF(G24=J24,G24,IF(Chart!$B$13=Lists!$D$14,IF(M24=\"\",\"\",G24-J24),G24-M24)))))","v":""},{"$f":"IF(Assess!E31=\"\",\"\",IF(Assess!K31=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H24,IF(H24=K24,H24,IF(Chart!$B$13=Lists!$D$14,H24-K24,H24-N24)))))","v":""},{"$f":"IF(Assess!C31=\"\",\"\",IF(Assess!J31=\"No\",\"\",SUM(B24:C24)))","v":""},{"$f":"IF(Assess!B31=\"\",\"\",IF(Assess!J31=\"No\",\"\",Assess!B31))","v":""},{"$f":"IF(Assess!C31=\"\",\"\",IF(Assess!J31=\"No\",\"\",Assess!C31))","v":""},{"$f":"IF(Assess!L31=\"\",\"\",IF(Assess!J31=\"No\",\"\",Assess!L31))","v":""},{"$f":"IF(Assess!M31=\"\",\"\",IF(Assess!J31=\"No\",\"\",Assess!M31))","v":""},{"$f":"IF(Assess!J31=\"No\",\"\",IF(Assess!N31=\"\",1,Assess!N31))","v":""},"","",{"$f":"IF(Assess!J31=\"No\",\"\",IF(Assess2!O31=\"\",I24,Assess2!O31))","v":""},"",""]
[{"$f":"IF(Assess!C32=\"\",\"\",IF(Assess!J32=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E25,F25)))","v":""},{"$f":"IF(Assess!C32=\"\",\"\",IF(Assess!J32=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G25,IF(G25=J25,G25,IF(Chart!$B$13=Lists!$D$14,IF(M25=\"\",\"\",G25-J25),G25-M25)))))","v":""},{"$f":"IF(Assess!E32=\"\",\"\",IF(Assess!K32=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H25,IF(H25=K25,H25,IF(Chart!$B$13=Lists!$D$14,H25-K25,H25-N25)))))","v":""},{"$f":"IF(Assess!C32=\"\",\"\",IF(Assess!J32=\"No\",\"\",SUM(B25:C25)))","v":""},{"$f":"IF(Assess!B32=\"\",\"\",IF(Assess!J32=\"No\",\"\",Assess!B32))","v":""},{"$f":"IF(Assess!C32=\"\",\"\",IF(Assess!J32=\"No\",\"\",Assess!C32))","v":""},{"$f":"IF(Assess!L32=\"\",\"\",IF(Assess!J32=\"No\",\"\",Assess!L32))","v":""},{"$f":"IF(Assess!M32=\"\",\"\",IF(Assess!J32=\"No\",\"\",Assess!M32))","v":""},{"$f":"IF(Assess!J32=\"No\",\"\",IF(Assess!N32=\"\",1,Assess!N32))","v":""},"","",{"$f":"IF(Assess!J32=\"No\",\"\",IF(Assess2!O32=\"\",I25,Assess2!O32))","v":""},"",""]
[{"$f":"IF(Assess!C33=\"\",\"\",IF(Assess!J33=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E26,F26)))","v":""},{"$f":"IF(Assess!C33=\"\",\"\",IF(Assess!J33=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G26,IF(G26=J26,G26,IF(Chart!$B$13=Lists!$D$14,IF(M26=\"\",\"\",G26-J26),G26-M26)))))","v":""},{"$f":"IF(Assess!E33=\"\",\"\",IF(Assess!K33=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H26,IF(H26=K26,H26,IF(Chart!$B$13=Lists!$D$14,H26-K26,H26-N26)))))","v":""},{"$f":"IF(Assess!C33=\"\",\"\",IF(Assess!J33=\"No\",\"\",SUM(B26:C26)))","v":""},{"$f":"IF(Assess!B33=\"\",\"\",IF(Assess!J33=\"No\",\"\",Assess!B33))","v":""},{"$f":"IF(Assess!C33=\"\",\"\",IF(Assess!J33=\"No\",\"\",Assess!C33))","v":""},{"$f":"IF(Assess!L33=\"\",\"\",IF(Assess!J33=\"No\",\"\",Assess!L33))","v":""},{"$f":"IF(Assess!M33=\"\",\"\",IF(Assess!J33=\"No\",\"\",Assess!M33))","v":""},{"$f":"IF(Assess!J33=\"No\",\"\",IF(Assess!N33=\"\",1,Assess!N33))","v":""},"","",{"$f":"IF(Assess!J33=\"No\",\"\",IF(Assess2!O33=\"\",I26,Assess2!O33))","v":""},"",""]
[{"$f":"IF(Assess!C34=\"\",\"\",IF(Assess!J34=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E27,F27)))","v":""},{"$f":"IF(Assess!C34=\"\",\"\",IF(Assess!J34=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G27,IF(G27=J27,G27,IF(Chart!$B$13=Lists!$D$14,IF(M27=\"\",\"\",G27-J27),G27-M27)))))","v":""},{"$f":"IF(Assess!E34=\"\",\"\",IF(Assess!K34=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H27,IF(H27=K27,H27,IF(Chart!$B$13=Lists!$D$14,H27-K27,H27-N27)))))","v":""},{"$f":"IF(Assess!C34=\"\",\"\",IF(Assess!J34=\"No\",\"\",SUM(B27:C27)))","v":""},{"$f":"IF(Assess!B34=\"\",\"\",IF(Assess!J34=\"No\",\"\",Assess!B34))","v":""},{"$f":"IF(Assess!C34=\"\",\"\",IF(Assess!J34=\"No\",\"\",Assess!C34))","v":""},{"$f":"IF(Assess!L34=\"\",\"\",IF(Assess!J34=\"No\",\"\",Assess!L34))","v":""},{"$f":"IF(Assess!M34=\"\",\"\",IF(Assess!J34=\"No\",\"\",Assess!M34))","v":""},{"$f":"IF(Assess!J34=\"No\",\"\",IF(Assess!N34=\"\",1,Assess!N34))","v":""},"","",{"$f":"IF(Assess!J34=\"No\",\"\",IF(Assess2!O34=\"\",I27,Assess2!O34))","v":""},"",""]
[{"$f":"IF(Assess!C35=\"\",\"\",IF(Assess!J35=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E28,F28)))","v":""},{"$f":"IF(Assess!C35=\"\",\"\",IF(Assess!J35=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G28,IF(G28=J28,G28,IF(Chart!$B$13=Lists!$D$14,IF(M28=\"\",\"\",G28-J28),G28-M28)))))","v":""},{"$f":"IF(Assess!E35=\"\",\"\",IF(Assess!K35=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H28,IF(H28=K28,H28,IF(Chart!$B$13=Lists!$D$14,H28-K28,H28-N28)))))","v":""},{"$f":"IF(Assess!C35=\"\",\"\",IF(Assess!J35=\"No\",\"\",SUM(B28:C28)))","v":""},{"$f":"IF(Assess!B35=\"\",\"\",IF(Assess!J35=\"No\",\"\",Assess!B35))","v":""},{"$f":"IF(Assess!C35=\"\",\"\",IF(Assess!J35=\"No\",\"\",Assess!C35))","v":""},{"$f":"IF(Assess!L35=\"\",\"\",IF(Assess!J35=\"No\",\"\",Assess!L35))","v":""},{"$f":"IF(Assess!M35=\"\",\"\",IF(Assess!J35=\"No\",\"\",Assess!M35))","v":""},{"$f":"IF(Assess!J35=\"No\",\"\",IF(Assess!N35=\"\",1,Assess!N35))","v":""},"","",{"$f":"IF(Assess!J35=\"No\",\"\",IF(Assess2!O35=\"\",I28,Assess2!O35))","v":""},"",""]
[{"$f":"IF(Assess!C36=\"\",\"\",IF(Assess!J36=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E29,F29)))","v":""},{"$f":"IF(Assess!C36=\"\",\"\",IF(Assess!J36=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G29,IF(G29=J29,G29,IF(Chart!$B$13=Lists!$D$14,IF(M29=\"\",\"\",G29-J29),G29-M29)))))","v":""},{"$f":"IF(Assess!E36=\"\",\"\",IF(Assess!K36=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H29,IF(H29=K29,H29,IF(Chart!$B$13=Lists!$D$14,H29-K29,H29-N29)))))","v":""},{"$f":"IF(Assess!C36=\"\",\"\",IF(Assess!J36=\"No\",\"\",SUM(B29:C29)))","v":""},{"$f":"IF(Assess!B36=\"\",\"\",IF(Assess!J36=\"No\",\"\",Assess!B36))","v":""},{"$f":"IF(Assess!C36=\"\",\"\",IF(Assess!J36=\"No\",\"\",Assess!C36))","v":""},{"$f":"IF(Assess!L36=\"\",\"\",IF(Assess!J36=\"No\",\"\",Assess!L36))","v":""},{"$f":"IF(Assess!M36=\"\",\"\",IF(Assess!J36=\"No\",\"\",Assess!M36))","v":""},{"$f":"IF(Assess!J36=\"No\",\"\",IF(Assess!N36=\"\",1,Assess!N36))","v":""},"","",{"$f":"IF(Assess!J36=\"No\",\"\",IF(Assess2!O36=\"\",I29,Assess2!O36))","v":""},"",""]
[{"$f":"IF(Assess!C37=\"\",\"\",IF(Assess!J37=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E30,F30)))","v":""},{"$f":"IF(Assess!C37=\"\",\"\",IF(Assess!J37=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G30,IF(G30=J30,G30,IF(Chart!$B$13=Lists!$D$14,IF(M30=\"\",\"\",G30-J30),G30-M30)))))","v":""},{"$f":"IF(Assess!E37=\"\",\"\",IF(Assess!K37=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H30,IF(H30=K30,H30,IF(Chart!$B$13=Lists!$D$14,H30-K30,H30-N30)))))","v":""},{"$f":"IF(Assess!C37=\"\",\"\",IF(Assess!J37=\"No\",\"\",SUM(B30:C30)))","v":""},{"$f":"IF(Assess!B37=\"\",\"\",IF(Assess!J37=\"No\",\"\",Assess!B37))","v":""},{"$f":"IF(Assess!C37=\"\",\"\",IF(Assess!J37=\"No\",\"\",Assess!C37))","v":""},{"$f":"IF(Assess!L37=\"\",\"\",IF(Assess!J37=\"No\",\"\",Assess!L37))","v":""},{"$f":"IF(Assess!M37=\"\",\"\",IF(Assess!J37=\"No\",\"\",Assess!M37))","v":""},{"$f":"IF(Assess!J37=\"No\",\"\",IF(Assess!N37=\"\",1,Assess!N37))","v":""},"","",{"$f":"IF(Assess!J37=\"No\",\"\",IF(Assess2!O37=\"\",I30,Assess2!O37))","v":""},"",""]
[{"$f":"IF(Assess!C38=\"\",\"\",IF(Assess!J38=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E31,F31)))","v":""},{"$f":"IF(Assess!C38=\"\",\"\",IF(Assess!J38=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G31,IF(G31=J31,G31,IF(Chart!$B$13=Lists!$D$14,IF(M31=\"\",\"\",G31-J31),G31-M31)))))","v":""},{"$f":"IF(Assess!E38=\"\",\"\",IF(Assess!K38=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H31,IF(H31=K31,H31,IF(Chart!$B$13=Lists!$D$14,H31-K31,H31-N31)))))","v":""},{"$f":"IF(Assess!C38=\"\",\"\",IF(Assess!J38=\"No\",\"\",SUM(B31:C31)))","v":""},{"$f":"IF(Assess!B38=\"\",\"\",IF(Assess!J38=\"No\",\"\",Assess!B38))","v":""},{"$f":"IF(Assess!C38=\"\",\"\",IF(Assess!J38=\"No\",\"\",Assess!C38))","v":""},{"$f":"IF(Assess!L38=\"\",\"\",IF(Assess!J38=\"No\",\"\",Assess!L38))","v":""},{"$f":"IF(Assess!M38=\"\",\"\",IF(Assess!J38=\"No\",\"\",Assess!M38))","v":""},{"$f":"IF(Assess!J38=\"No\",\"\",IF(Assess!N38=\"\",1,Assess!N38))","v":""},"","",{"$f":"IF(Assess!J38=\"No\",\"\",IF(Assess2!O38=\"\",I31,Assess2!O38))","v":""},"",""]
[{"$f":"IF(Assess!C39=\"\",\"\",IF(Assess!J39=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E32,F32)))","v":""},{"$f":"IF(Assess!C39=\"\",\"\",IF(Assess!J39=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G32,IF(G32=J32,G32,IF(Chart!$B$13=Lists!$D$14,IF(M32=\"\",\"\",G32-J32),G32-M32)))))","v":""},{"$f":"IF(Assess!E39=\"\",\"\",IF(Assess!K39=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H32,IF(H32=K32,H32,IF(Chart!$B$13=Lists!$D$14,H32-K32,H32-N32)))))","v":""},{"$f":"IF(Assess!C39=\"\",\"\",IF(Assess!J39=\"No\",\"\",SUM(B32:C32)))","v":""},{"$f":"IF(Assess!B39=\"\",\"\",IF(Assess!J39=\"No\",\"\",Assess!B39))","v":""},{"$f":"IF(Assess!C39=\"\",\"\",IF(Assess!J39=\"No\",\"\",Assess!C39))","v":""},{"$f":"IF(Assess!L39=\"\",\"\",IF(Assess!J39=\"No\",\"\",Assess!L39))","v":""},{"$f":"IF(Assess!M39=\"\",\"\",IF(Assess!J39=\"No\",\"\",Assess!M39))","v":""},{"$f":"IF(Assess!J39=\"No\",\"\",IF(Assess!N39=\"\",1,Assess!N39))","v":""},"","",{"$f":"IF(Assess!J39=\"No\",\"\",IF(Assess2!O39=\"\",I32,Assess2!O39))","v":""},"",""]
[{"$f":"IF(Assess!C40=\"\",\"\",IF(Assess!J40=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E33,F33)))","v":""},{"$f":"IF(Assess!C40=\"\",\"\",IF(Assess!J40=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G33,IF(G33=J33,G33,IF(Chart!$B$13=Lists!$D$14,IF(M33=\"\",\"\",G33-J33),G33-M33)))))","v":""},{"$f":"IF(Assess!E40=\"\",\"\",IF(Assess!K40=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H33,IF(H33=K33,H33,IF(Chart!$B$13=Lists!$D$14,H33-K33,H33-N33)))))","v":""},{"$f":"IF(Assess!C40=\"\",\"\",IF(Assess!J40=\"No\",\"\",SUM(B33:C33)))","v":""},{"$f":"IF(Assess!B40=\"\",\"\",IF(Assess!J40=\"No\",\"\",Assess!B40))","v":""},{"$f":"IF(Assess!C40=\"\",\"\",IF(Assess!J40=\"No\",\"\",Assess!C40))","v":""},{"$f":"IF(Assess!L40=\"\",\"\",IF(Assess!J40=\"No\",\"\",Assess!L40))","v":""},{"$f":"IF(Assess!M40=\"\",\"\",IF(Assess!J40=\"No\",\"\",Assess!M40))","v":""},{"$f":"IF(Assess!J40=\"No\",\"\",IF(Assess!N40=\"\",1,Assess!N40))","v":""},"","",{"$f":"IF(Assess!J40=\"No\",\"\",IF(Assess2!O40=\"\",I33,Assess2!O40))","v":""},"",""]
[{"$f":"IF(Assess!C41=\"\",\"\",IF(Assess!J41=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E34,F34)))","v":""},{"$f":"IF(Assess!C41=\"\",\"\",IF(Assess!J41=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G34,IF(G34=J34,G34,IF(Chart!$B$13=Lists!$D$14,IF(M34=\"\",\"\",G34-J34),G34-M34)))))","v":""},{"$f":"IF(Assess!E41=\"\",\"\",IF(Assess!K41=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H34,IF(H34=K34,H34,IF(Chart!$B$13=Lists!$D$14,H34-K34,H34-N34)))))","v":""},{"$f":"IF(Assess!C41=\"\",\"\",IF(Assess!J41=\"No\",\"\",SUM(B34:C34)))","v":""},{"$f":"IF(Assess!B41=\"\",\"\",IF(Assess!J41=\"No\",\"\",Assess!B41))","v":""},{"$f":"IF(Assess!C41=\"\",\"\",IF(Assess!J41=\"No\",\"\",Assess!C41))","v":""},{"$f":"IF(Assess!L41=\"\",\"\",IF(Assess!J41=\"No\",\"\",Assess!L41))","v":""},{"$f":"IF(Assess!M41=\"\",\"\",IF(Assess!J41=\"No\",\"\",Assess!M41))","v":""},{"$f":"IF(Assess!J41=\"No\",\"\",IF(Assess!N41=\"\",1,Assess!N41))","v":""},"","",{"$f":"IF(Assess!J41=\"No\",\"\",IF(Assess2!O41=\"\",I34,Assess2!O41))","v":""},"",""]
[{"$f":"IF(Assess!C42=\"\",\"\",IF(Assess!J42=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E35,F35)))","v":""},{"$f":"IF(Assess!C42=\"\",\"\",IF(Assess!J42=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G35,IF(G35=J35,G35,IF(Chart!$B$13=Lists!$D$14,IF(M35=\"\",\"\",G35-J35),G35-M35)))))","v":""},{"$f":"IF(Assess!E42=\"\",\"\",IF(Assess!K42=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H35,IF(H35=K35,H35,IF(Chart!$B$13=Lists!$D$14,H35-K35,H35-N35)))))","v":""},{"$f":"IF(Assess!C42=\"\",\"\",IF(Assess!J42=\"No\",\"\",SUM(B35:C35)))","v":""},{"$f":"IF(Assess!B42=\"\",\"\",IF(Assess!J42=\"No\",\"\",Assess!B42))","v":""},{"$f":"IF(Assess!C42=\"\",\"\",IF(Assess!J42=\"No\",\"\",Assess!C42))","v":""},{"$f":"IF(Assess!L42=\"\",\"\",IF(Assess!J42=\"No\",\"\",Assess!L42))","v":""},{"$f":"IF(Assess!M42=\"\",\"\",IF(Assess!J42=\"No\",\"\",Assess!M42))","v":""},{"$f":"IF(Assess!J42=\"No\",\"\",IF(Assess!N42=\"\",1,Assess!N42))","v":""},"","",{"$f":"IF(Assess!J42=\"No\",\"\",IF(Assess2!O42=\"\",I35,Assess2!O42))","v":""},"",""]
[{"$f":"IF(Assess!C43=\"\",\"\",IF(Assess!J43=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E36,F36)))","v":""},{"$f":"IF(Assess!C43=\"\",\"\",IF(Assess!J43=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G36,IF(G36=J36,G36,IF(Chart!$B$13=Lists!$D$14,IF(M36=\"\",\"\",G36-J36),G36-M36)))))","v":""},{"$f":"IF(Assess!E43=\"\",\"\",IF(Assess!K43=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H36,IF(H36=K36,H36,IF(Chart!$B$13=Lists!$D$14,H36-K36,H36-N36)))))","v":""},{"$f":"IF(Assess!C43=\"\",\"\",IF(Assess!J43=\"No\",\"\",SUM(B36:C36)))","v":""},{"$f":"IF(Assess!B43=\"\",\"\",IF(Assess!J43=\"No\",\"\",Assess!B43))","v":""},{"$f":"IF(Assess!C43=\"\",\"\",IF(Assess!J43=\"No\",\"\",Assess!C43))","v":""},{"$f":"IF(Assess!L43=\"\",\"\",IF(Assess!J43=\"No\",\"\",Assess!L43))","v":""},{"$f":"IF(Assess!M43=\"\",\"\",IF(Assess!J43=\"No\",\"\",Assess!M43))","v":""},{"$f":"IF(Assess!J43=\"No\",\"\",IF(Assess!N43=\"\",1,Assess!N43))","v":""},"","",{"$f":"IF(Assess!J43=\"No\",\"\",IF(Assess2!O43=\"\",I36,Assess2!O43))","v":""},"",""]
[{"$f":"IF(Assess!C44=\"\",\"\",IF(Assess!J44=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E37,F37)))","v":""},{"$f":"IF(Assess!C44=\"\",\"\",IF(Assess!J44=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G37,IF(G37=J37,G37,IF(Chart!$B$13=Lists!$D$14,IF(M37=\"\",\"\",G37-J37),G37-M37)))))","v":""},{"$f":"IF(Assess!E44=\"\",\"\",IF(Assess!K44=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H37,IF(H37=K37,H37,IF(Chart!$B$13=Lists!$D$14,H37-K37,H37-N37)))))","v":""},{"$f":"IF(Assess!C44=\"\",\"\",IF(Assess!J44=\"No\",\"\",SUM(B37:C37)))","v":""},{"$f":"IF(Assess!B44=\"\",\"\",IF(Assess!J44=\"No\",\"\",Assess!B44))","v":""},{"$f":"IF(Assess!C44=\"\",\"\",IF(Assess!J44=\"No\",\"\",Assess!C44))","v":""},{"$f":"IF(Assess!L44=\"\",\"\",IF(Assess!J44=\"No\",\"\",Assess!L44))","v":""},{"$f":"IF(Assess!M44=\"\",\"\",IF(Assess!J44=\"No\",\"\",Assess!M44))","v":""},{"$f":"IF(Assess!J44=\"No\",\"\",IF(Assess!N44=\"\",1,Assess!N44))","v":""},"","",{"$f":"IF(Assess!J44=\"No\",\"\",IF(Assess2!O44=\"\",I37,Assess2!O44))","v":""},"",""]
[{"$f":"IF(Assess!C45=\"\",\"\",IF(Assess!J45=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E38,F38)))","v":""},{"$f":"IF(Assess!C45=\"\",\"\",IF(Assess!J45=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G38,IF(G38=J38,G38,IF(Chart!$B$13=Lists!$D$14,IF(M38=\"\",\"\",G38-J38),G38-M38)))))","v":""},{"$f":"IF(Assess!E45=\"\",\"\",IF(Assess!K45=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H38,IF(H38=K38,H38,IF(Chart!$B$13=Lists!$D$14,H38-K38,H38-N38)))))","v":""},{"$f":"IF(Assess!C45=\"\",\"\",IF(Assess!J45=\"No\",\"\",SUM(B38:C38)))","v":""},{"$f":"IF(Assess!B45=\"\",\"\",IF(Assess!J45=\"No\",\"\",Assess!B45))","v":""},{"$f":"IF(Assess!C45=\"\",\"\",IF(Assess!J45=\"No\",\"\",Assess!C45))","v":""},{"$f":"IF(Assess!L45=\"\",\"\",IF(Assess!J45=\"No\",\"\",Assess!L45))","v":""},{"$f":"IF(Assess!M45=\"\",\"\",IF(Assess!J45=\"No\",\"\",Assess!M45))","v":""},{"$f":"IF(Assess!J45=\"No\",\"\",IF(Assess!N45=\"\",1,Assess!N45))","v":""},"","",{"$f":"IF(Assess!J45=\"No\",\"\",IF(Assess2!O45=\"\",I38,Assess2!O45))","v":""},"",""]
[{"$f":"IF(Assess!C46=\"\",\"\",IF(Assess!J46=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E39,F39)))","v":""},{"$f":"IF(Assess!C46=\"\",\"\",IF(Assess!J46=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G39,IF(G39=J39,G39,IF(Chart!$B$13=Lists!$D$14,IF(M39=\"\",\"\",G39-J39),G39-M39)))))","v":""},{"$f":"IF(Assess!E46=\"\",\"\",IF(Assess!K46=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H39,IF(H39=K39,H39,IF(Chart!$B$13=Lists!$D$14,H39-K39,H39-N39)))))","v":""},{"$f":"IF(Assess!C46=\"\",\"\",IF(Assess!J46=\"No\",\"\",SUM(B39:C39)))","v":""},{"$f":"IF(Assess!B46=\"\",\"\",IF(Assess!J46=\"No\",\"\",Assess!B46))","v":""},{"$f":"IF(Assess!C46=\"\",\"\",IF(Assess!J46=\"No\",\"\",Assess!C46))","v":""},{"$f":"IF(Assess!L46=\"\",\"\",IF(Assess!J46=\"No\",\"\",Assess!L46))","v":""},{"$f":"IF(Assess!M46=\"\",\"\",IF(Assess!J46=\"No\",\"\",Assess!M46))","v":""},{"$f":"IF(Assess!J46=\"No\",\"\",IF(Assess!N46=\"\",1,Assess!N46))","v":""},"","",{"$f":"IF(Assess!J46=\"No\",\"\",IF(Assess2!O46=\"\",I39,Assess2!O46))","v":""},"",""]
[{"$f":"IF(Assess!C47=\"\",\"\",IF(Assess!J47=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E40,F40)))","v":""},{"$f":"IF(Assess!C47=\"\",\"\",IF(Assess!J47=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G40,IF(G40=J40,G40,IF(Chart!$B$13=Lists!$D$14,IF(M40=\"\",\"\",G40-J40),G40-M40)))))","v":""},{"$f":"IF(Assess!E47=\"\",\"\",IF(Assess!K47=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H40,IF(H40=K40,H40,IF(Chart!$B$13=Lists!$D$14,H40-K40,H40-N40)))))","v":""},{"$f":"IF(Assess!C47=\"\",\"\",IF(Assess!J47=\"No\",\"\",SUM(B40:C40)))","v":""},{"$f":"IF(Assess!B47=\"\",\"\",IF(Assess!J47=\"No\",\"\",Assess!B47))","v":""},{"$f":"IF(Assess!C47=\"\",\"\",IF(Assess!J47=\"No\",\"\",Assess!C47))","v":""},{"$f":"IF(Assess!L47=\"\",\"\",IF(Assess!J47=\"No\",\"\",Assess!L47))","v":""},{"$f":"IF(Assess!M47=\"\",\"\",IF(Assess!J47=\"No\",\"\",Assess!M47))","v":""},{"$f":"IF(Assess!J47=\"No\",\"\",IF(Assess!N47=\"\",1,Assess!N47))","v":""},"","",{"$f":"IF(Assess!J47=\"No\",\"\",IF(Assess2!O47=\"\",I40,Assess2!O47))","v":""},"",""]
[{"$f":"IF(Assess!C48=\"\",\"\",IF(Assess!J48=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E41,F41)))","v":""},{"$f":"IF(Assess!C48=\"\",\"\",IF(Assess!J48=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G41,IF(G41=J41,G41,IF(Chart!$B$13=Lists!$D$14,IF(M41=\"\",\"\",G41-J41),G41-M41)))))","v":""},{"$f":"IF(Assess!E48=\"\",\"\",IF(Assess!K48=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H41,IF(H41=K41,H41,IF(Chart!$B$13=Lists!$D$14,H41-K41,H41-N41)))))","v":""},{"$f":"IF(Assess!C48=\"\",\"\",IF(Assess!J48=\"No\",\"\",SUM(B41:C41)))","v":""},{"$f":"IF(Assess!B48=\"\",\"\",IF(Assess!J48=\"No\",\"\",Assess!B48))","v":""},{"$f":"IF(Assess!C48=\"\",\"\",IF(Assess!J48=\"No\",\"\",Assess!C48))","v":""},{"$f":"IF(Assess!L48=\"\",\"\",IF(Assess!J48=\"No\",\"\",Assess!L48))","v":""},{"$f":"IF(Assess!M48=\"\",\"\",IF(Assess!J48=\"No\",\"\",Assess!M48))","v":""},{"$f":"IF(Assess!J48=\"No\",\"\",IF(Assess!N48=\"\",1,Assess!N48))","v":""},"","",{"$f":"IF(Assess!J48=\"No\",\"\",IF(Assess2!O48=\"\",I41,Assess2!O48))","v":""},"",""]
[{"$f":"IF(Assess!C49=\"\",\"\",IF(Assess!J49=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E42,F42)))","v":""},{"$f":"IF(Assess!C49=\"\",\"\",IF(Assess!J49=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G42,IF(G42=J42,G42,IF(Chart!$B$13=Lists!$D$14,IF(M42=\"\",\"\",G42-J42),G42-M42)))))","v":""},{"$f":"IF(Assess!E49=\"\",\"\",IF(Assess!K49=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H42,IF(H42=K42,H42,IF(Chart!$B$13=Lists!$D$14,H42-K42,H42-N42)))))","v":""},{"$f":"IF(Assess!C49=\"\",\"\",IF(Assess!J49=\"No\",\"\",SUM(B42:C42)))","v":""},{"$f":"IF(Assess!B49=\"\",\"\",IF(Assess!J49=\"No\",\"\",Assess!B49))","v":""},{"$f":"IF(Assess!C49=\"\",\"\",IF(Assess!J49=\"No\",\"\",Assess!C49))","v":""},{"$f":"IF(Assess!L49=\"\",\"\",IF(Assess!J49=\"No\",\"\",Assess!L49))","v":""},{"$f":"IF(Assess!M49=\"\",\"\",IF(Assess!J49=\"No\",\"\",Assess!M49))","v":""},{"$f":"IF(Assess!J49=\"No\",\"\",IF(Assess!N49=\"\",1,Assess!N49))","v":""},"","",{"$f":"IF(Assess!J49=\"No\",\"\",IF(Assess2!O49=\"\",I42,Assess2!O49))","v":""},"",""]
[{"$f":"IF(Assess!C50=\"\",\"\",IF(Assess!J50=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E43,F43)))","v":""},{"$f":"IF(Assess!C50=\"\",\"\",IF(Assess!J50=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G43,IF(G43=J43,G43,IF(Chart!$B$13=Lists!$D$14,IF(M43=\"\",\"\",G43-J43),G43-M43)))))","v":""},{"$f":"IF(Assess!E50=\"\",\"\",IF(Assess!K50=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H43,IF(H43=K43,H43,IF(Chart!$B$13=Lists!$D$14,H43-K43,H43-N43)))))","v":""},{"$f":"IF(Assess!C50=\"\",\"\",IF(Assess!J50=\"No\",\"\",SUM(B43:C43)))","v":""},{"$f":"IF(Assess!B50=\"\",\"\",IF(Assess!J50=\"No\",\"\",Assess!B50))","v":""},{"$f":"IF(Assess!C50=\"\",\"\",IF(Assess!J50=\"No\",\"\",Assess!C50))","v":""},{"$f":"IF(Assess!L50=\"\",\"\",IF(Assess!J50=\"No\",\"\",Assess!L50))","v":""},{"$f":"IF(Assess!M50=\"\",\"\",IF(Assess!J50=\"No\",\"\",Assess!M50))","v":""},{"$f":"IF(Assess!J50=\"No\",\"\",IF(Assess!N50=\"\",1,Assess!N50))","v":""},"","",{"$f":"IF(Assess!J50=\"No\",\"\",IF(Assess2!O50=\"\",I43,Assess2!O50))","v":""},"",""]
[{"$f":"IF(Assess!C51=\"\",\"\",IF(Assess!J51=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E44,F44)))","v":""},{"$f":"IF(Assess!C51=\"\",\"\",IF(Assess!J51=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G44,IF(G44=J44,G44,IF(Chart!$B$13=Lists!$D$14,IF(M44=\"\",\"\",G44-J44),G44-M44)))))","v":""},{"$f":"IF(Assess!E51=\"\",\"\",IF(Assess!K51=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H44,IF(H44=K44,H44,IF(Chart!$B$13=Lists!$D$14,H44-K44,H44-N44)))))","v":""},{"$f":"IF(Assess!C51=\"\",\"\",IF(Assess!J51=\"No\",\"\",SUM(B44:C44)))","v":""},{"$f":"IF(Assess!B51=\"\",\"\",IF(Assess!J51=\"No\",\"\",Assess!B51))","v":""},{"$f":"IF(Assess!C51=\"\",\"\",IF(Assess!J51=\"No\",\"\",Assess!C51))","v":""},{"$f":"IF(Assess!L51=\"\",\"\",IF(Assess!J51=\"No\",\"\",Assess!L51))","v":""},{"$f":"IF(Assess!M51=\"\",\"\",IF(Assess!J51=\"No\",\"\",Assess!M51))","v":""},{"$f":"IF(Assess!J51=\"No\",\"\",IF(Assess!N51=\"\",1,Assess!N51))","v":""},"","",{"$f":"IF(Assess!J51=\"No\",\"\",IF(Assess2!O51=\"\",I44,Assess2!O51))","v":""},"",""]
[{"$f":"IF(Assess!C52=\"\",\"\",IF(Assess!J52=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E45,F45)))","v":""},{"$f":"IF(Assess!C52=\"\",\"\",IF(Assess!J52=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G45,IF(G45=J45,G45,IF(Chart!$B$13=Lists!$D$14,IF(M45=\"\",\"\",G45-J45),G45-M45)))))","v":""},{"$f":"IF(Assess!E52=\"\",\"\",IF(Assess!K52=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H45,IF(H45=K45,H45,IF(Chart!$B$13=Lists!$D$14,H45-K45,H45-N45)))))","v":""},{"$f":"IF(Assess!C52=\"\",\"\",IF(Assess!J52=\"No\",\"\",SUM(B45:C45)))","v":""},{"$f":"IF(Assess!B52=\"\",\"\",IF(Assess!J52=\"No\",\"\",Assess!B52))","v":""},{"$f":"IF(Assess!C52=\"\",\"\",IF(Assess!J52=\"No\",\"\",Assess!C52))","v":""},{"$f":"IF(Assess!L52=\"\",\"\",IF(Assess!J52=\"No\",\"\",Assess!L52))","v":""},{"$f":"IF(Assess!M52=\"\",\"\",IF(Assess!J52=\"No\",\"\",Assess!M52))","v":""},{"$f":"IF(Assess!J52=\"No\",\"\",IF(Assess!N52=\"\",1,Assess!N52))","v":""},"","",{"$f":"IF(Assess!J52=\"No\",\"\",IF(Assess2!O52=\"\",I45,Assess2!O52))","v":""},"",""]
[{"$f":"IF(Assess!C53=\"\",\"\",IF(Assess!J53=\"No\",\"\",IF(Chart!$B$16=\"Letters\",E46,F46)))","v":""},{"$f":"IF(Assess!C53=\"\",\"\",IF(Assess!J53=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,G46,IF(G46=J46,G46,IF(Chart!$B$13=Lists!$D$14,IF(M46=\"\",\"\",G46-J46),G46-M46)))))","v":""},{"$f":"IF(Assess!E53=\"\",\"\",IF(Assess!K53=\"No\",\"\",IF(Chart!$B$13=Lists!$D$13,H46,IF(H46=K46,H46,IF(Chart!$B$13=Lists!$D$14,H46-K46,H46-N46)))))","v":""},{"$f":"IF(Assess!C53=\"\",\"\",IF(Assess!J53=\"No\",\"\",SUM(B46:C46)))","v":""},{"$f":"IF(Assess!B53=\"\",\"\",IF(Assess!J53=\"No\",\"\",Assess!B53))","v":""},{"$f":"IF(Assess!C53=\"\",\"\",IF(Assess!J53=\"No\",\"\",Assess!C53))","v":""},{"$f":"IF(Assess!L53=\"\",\"\",IF(Assess!J53=\"No\",\"\",Assess!L53))","v":""},{"$f":"IF(Assess!M53=\"\",\"\",IF(Assess!J53=\"No\",\"\",Assess!M53))","v":""},{"$f":"IF(Assess!J53=\"No\",\"\",IF(Assess!N53=\"\",1,Assess!N53))","v":""},"","",{"$f":"IF(Assess!J53=\"No\",\"\",IF(Assess2!O53=\"\",I46,Assess2!O53))","v":""},"",""]

{"sheet":"Export","index":7,"n_rows":46,"n_cols":23,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Project Name","UC Location ID","Department/College","Person1","Person2","Person3","Person4","Date","Letter","RiskName","PotentialConsequences","ImpactNoControls","LikelihoodNoControls","RiskRatingNone","CurrentDescription","CurrentEffectiveness","RiskRatingCurrent","RiskRatingCurrentLanguage","AdditionalDescription","AdditionalEffectiveness","RiskRatingAdditional","RiskRatingAdditionalLanguage","ResponsiblePersonnel"]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B9=\"\",\"\",Assess!B9)","v":"A"},{"$f":"IF(Assess!C9=\"\",\"\",Assess!C9)","v":"Students contract vaccine preventable diseases: Yellow Fever, Hepatitis A & B, Typhoid, Meningococcal (Meningitis), Rabies, Polio"},{"$f":"IF(Assess!D9=\"\",\"\",Assess!D9)","v":"Loss of program benefits, serious illness, death"},{"$f":"IF(Assess!E9=\"\",\"\",Assess!E9)","v":"High"},{"$f":"IF(Assess!F9=\"\",\"\",Assess!F9)","v":"Moderate"},{"$f":"IF(Assess!L9=\"\",\"\",IF(Assess!M9=\"\",\"\",SUM(Assess!L9:M9)))","v":18},{"$f":"IF(Assess!G9=\"\",\"\",Assess!G9)","v":"Students expected to follow CDC vaccine recommendations"},{"$f":"IF(Assess!H9=\"\",\"\",Assess!H9)","v":"Minor"},{"$f":"IF(Assess!O9=\"\",\"\",Assess!O9)","v":12.6},{"$f":"IF(Assess!P9=\"\",\"\",Assess!P9)","v":"Under-controlled"},{"$f":"IF(Assess2!F9=\"\",\"\",Assess2!F9)","v":"1) Remind students to follow CDC vaccine recommendations before departure.  2) Get students authorization to speak to parents and send information to parents. 3) Emphasize with campus offices to mention malaria prevention and/or include someone from SH during pre-departure orientation. "},{"$f":"IF(Assess2!G9=\"\",\"\",Assess2!G9)","v":"Significant improvement"},{"$f":"Assess2!O9","v":0.92999999999999994},{"$f":"Assess2!H9","v":"Adequately controlled"},{"$f":"IF(Assess2!I9=\"\",\"\",Assess2!I9)","v":"Ines? Campus? Onsite? Students?--- Student's must choose to follow detailed advise."}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B10=\"\",\"\",Assess!B10)","v":"B"},{"$f":"IF(Assess!C10=\"\",\"\",Assess!C10)","v":"Meningitis - Students with risk factors for Meningitis (poor overall health, prior infection, birth defect in the skull, a head injury or brain surgery, previous infections such as upper respiratory or Lyme disease, cochlear implant; impaired immune system"},{"$f":"IF(Assess!D10=\"\",\"\",Assess!D10)","v":"Serious illness (Meningococcal disease is an acute bacterial infection characterized by sudden onset with fever, intense headache, nausea, vomiting, stiff neck, and, frequently, a rash with pink spots)"},{"$f":"IF(Assess!E10=\"\",\"\",Assess!E10)","v":"High"},{"$f":"IF(Assess!F10=\"\",\"\",Assess!F10)","v":"Moderate"},{"$f":"IF(Assess!L10=\"\",\"\",IF(Assess!M10=\"\",\"\",SUM(Assess!L10:M10)))","v":18},{"$f":"IF(Assess!G10=\"\",\"\",Assess!G10)","v":"1) All EAP students are required to complete the online UCEAP Travel Health Certification course through MyEAP and strongly encouraged to follow through about vaccine recommendations with a travel health professional.  2) Avoid close human contact in crowded areas. 3) Frequent hand washing with soap and water."},{"$f":"IF(Assess!H10=\"\",\"\",Assess!H10)","v":"Moderate"},{"$f":"IF(Assess!O10=\"\",\"\",Assess!O10)","v":7.2},{"$f":"IF(Assess!P10=\"\",\"\",Assess!P10)","v":"Potentially under-controlled"},{"$f":"IF(Assess2!F10=\"\",\"\",Assess2!F10)","v":"1) Remind students to follow CDC vaccine recommendations before departure.  2) Get students authorization to speak to parents and send information to parents. 3) Emphasize with campus offices to mention malaria prevention and/or include someone from SH during pre-departure orientation. "},{"$f":"IF(Assess2!G10=\"\",\"\",Assess2!G10)","v":"Substantial improvement"},{"$f":"Assess2!O10","v":0.9},{"$f":"Assess2!H10","v":"Adequately controlled"},{"$f":"IF(Assess2!I10=\"\",\"\",Assess2!I10)","v":"Ines? Campus? Onsite? Students?--- Student's must choose to follow detailed advise."}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B11=\"\",\"\",Assess!B11)","v":"C"},{"$f":"IF(Assess!C11=\"\",\"\",Assess!C11)","v":"Malaria - Students with risk factors for Malaria (stopping or not adhering to prophylaxis, not taking personal protective measures, using substandard drugs purchased over seas, not follow-up if symptoms occur)"},{"$f":"IF(Assess!D11=\"\",\"\",Assess!D11)","v":"Students could get critically sick, temporarily or permanently"},{"$f":"IF(Assess!E11=\"\",\"\",Assess!E11)","v":"Very high"},{"$f":"IF(Assess!F11=\"\",\"\",Assess!F11)","v":"Very high"},{"$f":"IF(Assess!L11=\"\",\"\",IF(Assess!M11=\"\",\"\",SUM(Assess!L11:M11)))","v":25},{"$f":"IF(Assess!G11=\"\",\"\",Assess!G11)","v":"Recommendations for prevention of malaria must be individualized.  1) Students are required to complete the UCEAP Online Travel Health Education Certification course and strongly recommended to meet with a travel health specialist after the course to understand the health risks, get necessary medication based on length of stay and current medical condition, and learn how diseases are transmitted.  2) Students advised to spray insecticide on walls; use a pyrethroid-containing flying-insect spray in living and sleeping areas; understand behaviors to minimize exposure to mosquitoes; wear barrier clothing; use insecticide-impregnated bed nets; spray residence; take an appropriate antimalarial drug regimen exactly as prescribed and carefully following antimosquito measures. 3) Students sign a mandatory Malaria Prophylaxis Agreement form. Students who do not comply may be dismissed.  3) EAP student health insurance provides adequate coverage and medical evacuation benefits. 4) UCEAP insurance coverage includes 100% coverage for prophylaxis.  5) Students told to continue taking the medication as recommended after leaving the malaria-risk area. "},{"$f":"IF(Assess!H11=\"\",\"\",Assess!H11)","v":"Substantial"},{"$f":"IF(Assess!O11=\"\",\"\",Assess!O11)","v":6.25},{"$f":"IF(Assess!P11=\"\",\"\",Assess!P11)","v":"Potentially under-controlled"},{"$f":"IF(Assess2!F11=\"\",\"\",Assess2!F11)","v":"1) Remind students to follow CDC vaccine recommendations before departure.  2) Get students authorization to speak to parents and send information to parents. 3) Emphasize with campus offices to mention malaria prevention and/or include someone from SH during pre-departure orientation. "},{"$f":"IF(Assess2!G11=\"\",\"\",Assess2!G11)","v":"No Change"},{"$f":"Assess2!O11","v":0.75},{"$f":"Assess2!H11","v":"Potentially under-controlled"},{"$f":"IF(Assess2!I11=\"\",\"\",Assess2!I11)","v":"Student Health Centers for those students who attend the UCEAP clearance on their UC campuses.  Can't reach private practitioners. Students?--- Student's must choose to follow detailed advise."}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B12=\"\",\"\",Assess!B12)","v":"D"},{"$f":"IF(Assess!C12=\"\",\"\",Assess!C12)","v":"Parasitic Infection - Students contract parasitic infections (consuming or exposure to contaminated water by drinking, swimming or bathing) for which no vaccines or preventive drugs are available"},{"$f":"IF(Assess!D12=\"\",\"\",Assess!D12)","v":"Schistosoma parasites can penetrate the skin of persons who are wading, swimming, bathing, or washing in contaminated water. Within several weeks, worms grow inside the blood vessels of the body and produce eggs. Some of these eggs travel to the bladder or intestines and are passed into the urine or stool.  Occasionally, eggs may be deposited in the brain or spinal cord, leading to seizures or paralysis."},{"$f":"IF(Assess!E12=\"\",\"\",Assess!E12)","v":"Very high"},{"$f":"IF(Assess!F12=\"\",\"\",Assess!F12)","v":"Very high"},{"$f":"IF(Assess!L12=\"\",\"\",IF(Assess!M12=\"\",\"\",SUM(Assess!L12:M12)))","v":25},{"$f":"IF(Assess!G12=\"\",\"\",Assess!G12)","v":"Students advised to avoid 1) swimming or wading in freshwater; 2) drink safe water; either boil water for 1 minute or filter water before drinking. Iodine treatment alone WILL NOT GUARANTEE that water is safe and free of all parasites. 3) If a student accidentally come into contact with fresh water, vigorous towel drying after a very brief water exposure may help to prevent the Schistosoma parasite from penetrating the skin. Students should NOT rely on vigorous towel drying to prevent Schistosomiasis"},{"$f":"IF(Assess!H12=\"\",\"\",Assess!H12)","v":"Substantial"},{"$f":"IF(Assess!O12=\"\",\"\",Assess!O12)","v":6.25},{"$f":"IF(Assess!P12=\"\",\"\",Assess!P12)","v":"Potentially under-controlled"},{"$f":"IF(Assess2!F12=\"\",\"\",Assess2!F12)","v":""},{"$f":"IF(Assess2!G12=\"\",\"\",Assess2!G12)","v":"No Change"},{"$f":"Assess2!O12","v":0.75},{"$f":"Assess2!H12","v":"Potentially under-controlled"},{"$f":"IF(Assess2!I12=\"\",\"\",Assess2!I12)","v":"Student Health Centers for those students who attend the UCEAP clearance on their UC campuses.  Can't reach private practitioners. Student's must choose to follow detailed advise."}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B13=\"\",\"\",Assess!B13)","v":"E"},{"$f":"IF(Assess!C13=\"\",\"\",Assess!C13)","v":"Rabies - a preventable and acute viral disease of the central nervous system, most often transmitted through the bite of a rabid animal."},{"$f":"IF(Assess!D13=\"\",\"\",Assess!D13)","v":"The disease is nearly always fatal when the person begins showing symptoms (fever, headache, agitation, anxiety, confusion, difficulty swallowing, excessive salivation, hydrophobia, hallucinations, insomnia and partial paralysis"},{"$f":"IF(Assess!E13=\"\",\"\",Assess!E13)","v":"Very high"},{"$f":"IF(Assess!F13=\"\",\"\",Assess!F13)","v":"Moderate"},{"$f":"IF(Assess!L13=\"\",\"\",IF(Assess!M13=\"\",\"\",SUM(Assess!L13:M13)))","v":21},{"$f":"IF(Assess!G13=\"\",\"\",Assess!G13)","v":"The risk of rabies in an encounter with an animal and the precautions necessary to prevent rabies are the same as they are in the United States.  Students are told to consult with a health care professional after the required UCEAP online Travel Health Education Certification course.  Consider getting a rabies vaccine if your activities will put you in contact with animals (approximately $160 at UC Student Health Services).  Avoid approaching any wild or domestic animals.  Avoid all contact with animals, especially stray dogs and cats.  If bitten or scratched, wash the wound immediately with soap and water (and povidone iodine, if available); seek medical attention immediately to determine if mediation or anti-rabies vaccine is needed. Immediate local treatment will substantially reduce the risk of rabies.  Treat any bite from a potentially rabid animal as a medical emergency."},{"$f":"IF(Assess!H13=\"\",\"\",Assess!H13)","v":"Substantial"},{"$f":"IF(Assess!O13=\"\",\"\",Assess!O13)","v":5.25},{"$f":"IF(Assess!P13=\"\",\"\",Assess!P13)","v":"Potentially under-controlled"},{"$f":"IF(Assess2!F13=\"\",\"\",Assess2!F13)","v":""},{"$f":"IF(Assess2!G13=\"\",\"\",Assess2!G13)","v":"No Change"},{"$f":"Assess2!O13","v":0.75},{"$f":"Assess2!H13","v":"Potentially under-controlled"},{"$f":"IF(Assess2!I13=\"\",\"\",Assess2!I13)","v":"Students?--- Student's must choose to follow detailed advise."}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B14=\"\",\"\",Assess!B14)","v":"F"},{"$f":"IF(Assess!C14=\"\",\"\",Assess!C14)","v":"Insect Precautions – Many serious diseases transmitted by insects require careful avoidance and use of protective measures as there are no immunizations and medications. Travelers visiting rural areas or engaging in camping, hiking or adventure travel are at the greatest risk of exposure to mosquitoes, ticks, mites, fleas and other disease-carrying insects, but even urban visitors need to take precautions to avoid insect exposure in some areas."},{"$f":"IF(Assess!D14=\"\",\"\",Assess!D14)","v":"Students contract insect borne diseases (Dengue fever, Leishmaniasis, Malaria); Students injured by exposure to toxic insect repellants; Condition of student with serious illness or injury made worse by substandard medical treatment; Medical treatment withheld because student does not have cash to pay for services"},{"$f":"IF(Assess!E14=\"\",\"\",Assess!E14)","v":"High"},{"$f":"IF(Assess!F14=\"\",\"\",Assess!F14)","v":"Moderate"},{"$f":"IF(Assess!L14=\"\",\"\",IF(Assess!M14=\"\",\"\",SUM(Assess!L14:M14)))","v":18},{"$f":"IF(Assess!G14=\"\",\"\",Assess!G14)","v":"Students instructed to cover as much skin as possible; perform body tick checks daily; sleep in protected areas with screens or air conditioning or use a permethrin-impregnated sleeping bed nets; eliminate any mosquitoes from inside rooms and sleeping areas prior to retiring. Insecticide sprays may be used to clear rooms of mosquitoes, but coils should be only used outdoors. "},{"$f":"IF(Assess!H14=\"\",\"\",Assess!H14)","v":"Significant"},{"$f":"IF(Assess!O14=\"\",\"\",Assess!O14)","v":1.7999999999999996},{"$f":"IF(Assess!P14=\"\",\"\",Assess!P14)","v":"Adequately controlled"},{"$f":"IF(Assess2!F14=\"\",\"\",Assess2!F14)","v":""},{"$f":"IF(Assess2!G14=\"\",\"\",Assess2!G14)","v":"No Change"},{"$f":"Assess2!O14","v":0.9},{"$f":"Assess2!H14","v":"Adequately controlled"},{"$f":"IF(Assess2!I14=\"\",\"\",Assess2!I14)","v":"Students?--- Student's must choose to follow detailed advise."}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B15=\"\",\"\",Assess!B15)","v":"G"},{"$f":"IF(Assess!C15=\"\",\"\",Assess!C15)","v":"Food/Water Safety - Students consume unsafe food and/or water contaminated with toxins or diseases  Local water supplies are limited and contaminated with raw sewage, pesticides and industrial waste.  Some types of fish may contain poisonous biotoxins even when cooked. "},{"$f":"IF(Assess!D15=\"\",\"\",Assess!D15)","v":"Illness (serious or mild); death; medical evacuation"},{"$f":"IF(Assess!E15=\"\",\"\",Assess!E15)","v":"High"},{"$f":"IF(Assess!F15=\"\",\"\",Assess!F15)","v":"High"},{"$f":"IF(Assess!L15=\"\",\"\",IF(Assess!M15=\"\",\"\",SUM(Assess!L15:M15)))","v":20},{"$f":"IF(Assess!G15=\"\",\"\",Assess!G15)","v":"Students are instructed to drink only known brands of bottled water that have not been tampered with; eat in well-established, clean restaurants; eat only well-cooked food served hot; avoid salads, buffets, and cooked foods that have been left at room temperature; not eat fruits or vegetables unless they have been peeled or cooked; avoid cooked foods that are no longer piping hot; avoid buying food from street vendors; not drink tap water (unless boiled, filtered, or chemically disinfected) or unbottled beverages or drinks with ice; avoid unpasteurized milk and dairy products such as ice cream; and not eat raw or undercooked meat or fish. "},{"$f":"IF(Assess!H15=\"\",\"\",Assess!H15)","v":"Moderate"},{"$f":"IF(Assess!O15=\"\",\"\",Assess!O15)","v":8},{"$f":"IF(Assess!P15=\"\",\"\",Assess!P15)","v":"Potentially under-controlled"},{"$f":"IF(Assess2!F15=\"\",\"\",Assess2!F15)","v":""},{"$f":"IF(Assess2!G15=\"\",\"\",Assess2!G15)","v":"No Change"},{"$f":"Assess2!O15","v":0.6},{"$f":"Assess2!H15","v":"Potentially under-controlled"},{"$f":"IF(Assess2!I15=\"\",\"\",Assess2!I15)","v":"Students?--- Student's must choose to follow detailed advise."}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B16=\"\",\"\",Assess!B16)","v":"H"},{"$f":"IF(Assess!C16=\"\",\"\",Assess!C16)","v":"Medical Facilities - Students seriously sick and requiring hospitalization do not get needed care or receive substandard care; medical facilities are limited in Accra and may be nonexistent elsewhere; most doctors and hospitals expect payment in cash, regardless of travel health insurance.  Differing cultural expectations in Ghana affect care. "},{"$f":"IF(Assess!D16=\"\",\"\",Assess!D16)","v":"Illness (serious or mild); death; medical evacuation; students unable to receive needed medication"},{"$f":"IF(Assess!E16=\"\",\"\",Assess!E16)","v":"High"},{"$f":"IF(Assess!F16=\"\",\"\",Assess!F16)","v":"High"},{"$f":"IF(Assess!L16=\"\",\"\",IF(Assess!M16=\"\",\"\",SUM(Assess!L16:M16)))","v":20},{"$f":"IF(Assess!G16=\"\",\"\",Assess!G16)","v":"1) The EAP student health insurance adequately covers medical evacuation from Ghana.2) Europ Assistance, UCEAP Travel Assistance provider can refer students to local medical facilities and can guarantee payment of services directly.  3) The U.S. Embassy has on their website a list of medical services providers. 4) Students need to be prepared for the inevitable cultural differences in medical services and find out in advance whether any particular care needed is available.  5) Prescription medications are often not available so students may want to consider bringing a sufficient supply. 6) Students and their families should inform themselves about health management while in Ghana and discuss health options with their health care provider.  7) Students with chronic health conditions, need to consult carefully with a physician in the U.S. before departure. 8)  Access to a freezer/refrigerator for some medical equipment/medication may be difficult as electricity is sporadic throughout Ghana. The student dorms are not equipped with fridges or freezers. 9) The UC Study Center staff is present to assist students if they get sick or injured.  10) Students should complete all routine and required medical exams before coming to Accra and obtain all required and recommended immunization. 11) Students should refer to the U.S. Department of State website and 12) follow advice acquired during the Online UCEAP Travel Health Certification course."},{"$f":"IF(Assess!H16=\"\",\"\",Assess!H16)","v":"Significant"},{"$f":"IF(Assess!O16=\"\",\"\",Assess!O16)","v":1.9999999999999996},{"$f":"IF(Assess!P16=\"\",\"\",Assess!P16)","v":"Adequately controlled"},{"$f":"IF(Assess2!F16=\"\",\"\",Assess2!F16)","v":""},{"$f":"IF(Assess2!G16=\"\",\"\",Assess2!G16)","v":"No Change"},{"$f":"Assess2!O16","v":0.9},{"$f":"Assess2!H16","v":"Adequately controlled"},{"$f":"IF(Assess2!I16=\"\",\"\",Assess2!I16)","v":"Ines "}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B17=\"\",\"\",Assess!B17)","v":"I"},{"$f":"IF(Assess!C17=\"\",\"\",Assess!C17)","v":"Mental Health - Students with recent or ongoing mental health concerns fail to document in advance of the EAP health clearance and travel, her/his condition and detailed plan for continuing care while away. "},{"$f":"IF(Assess!D17=\"\",\"\",Assess!D17)","v":"Student receives inadequate or inappropriate medication; condition is exacerbated due to lack of care"},{"$f":"IF(Assess!E17=\"\",\"\",Assess!E17)","v":"Moderate"},{"$f":"IF(Assess!F17=\"\",\"\",Assess!F17)","v":"Moderate"},{"$f":"IF(Assess!L17=\"\",\"\",IF(Assess!M17=\"\",\"\",SUM(Assess!L17:M17)))","v":15},{"$f":"IF(Assess!G17=\"\",\"\",Assess!G17)","v":"The EAP student health insurance covers outpatient counseling up to 30 visits.  If students will need care, the U.S. Embassy provides a list of counselors and can help UC Study Center staff to establish contact to provide confidential treatment.  If a student is seeing a counselor/therapist in the U.S., the student should consult carefully about health and medication management before departure.  Student should bring adequate supply of prescription medication to last through the stay along with a doctor’s prescription and a letter indicating condition. Students need to be prepared for the inevitable cultural differences in medical services. Students who need a particular type of medical care should find out in advance whether such care is available. Students should discuss options with their health care provider."},{"$f":"IF(Assess!H17=\"\",\"\",Assess!H17)","v":"Significant"},{"$f":"IF(Assess!O17=\"\",\"\",Assess!O17)","v":1.4999999999999996},{"$f":"IF(Assess!P17=\"\",\"\",Assess!P17)","v":"Adequately controlled"},{"$f":"IF(Assess2!F17=\"\",\"\",Assess2!F17)","v":""},{"$f":"IF(Assess2!G17=\"\",\"\",Assess2!G17)","v":"No Change"},{"$f":"Assess2!O17","v":0.9},{"$f":"Assess2!H17","v":"Adequately controlled"},{"$f":"IF(Assess2!I17=\"\",\"\",Assess2!I17)","v":"Ines"}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B18=\"\",\"\",Assess!B18)","v":"J"},{"$f":"IF(Assess!C18=\"\",\"\",Assess!C18)","v":"Illicit drugs - the unlawful possession, use, or distribution of alcohol by students or employees on University of Ghana premises or as part of any University of Ghana activities is prohibited."},{"$f":"IF(Assess!D18=\"\",\"\",Assess!D18)","v":"The possession of, distribution, or use of drugs is a crime in Ghana.  The unlawful possession, use, or distribution of alcohol by students or employees on University/College premises or as part of any University/College activities is prohibited. Anyone found in possession of or using such drugs on University property will be severely dealt with and suspended from the University, in addition to facing criminal charges.  Persons violating Ghanaian laws, even unknowingly, may be expelled, arrested, or imprisoned.  Penalties for possessing, using, or trafficking in illegal drugs in Ghana are severe, and convicted offenders can expect long jail sentences and heavy fines.  The use of illegal drugs procured in Ghana may have life-threatening consequences. There have been several deaths of U.S. citizens resulting from the use of narcotics procured locally. "},{"$f":"IF(Assess!E18=\"\",\"\",Assess!E18)","v":"High"},{"$f":"IF(Assess!F18=\"\",\"\",Assess!F18)","v":"Moderate"},{"$f":"IF(Assess!L18=\"\",\"\",IF(Assess!M18=\"\",\"\",SUM(Assess!L18:M18)))","v":18},{"$f":"IF(Assess!G18=\"\",\"\",Assess!G18)","v":"Students must decide to act responsibly.   University of Ghana expects students to comport themselves in a manner consistent with University policy and that they must conduct themselves in a lawful manner at all times.  Violation of University of Ghana and University of California policies subjects students to disciplinary procedures.  Violation of country laws exposes the student to criminal charges and/or arrest."},{"$f":"IF(Assess!H18=\"\",\"\",Assess!H18)","v":"Substantial"},{"$f":"IF(Assess!O18=\"\",\"\",Assess!O18)","v":4.5},{"$f":"IF(Assess!P18=\"\",\"\",Assess!P18)","v":"Adequately controlled"},{"$f":"IF(Assess2!F18=\"\",\"\",Assess2!F18)","v":""},{"$f":"IF(Assess2!G18=\"\",\"\",Assess2!G18)","v":"No Change"},{"$f":"Assess2!O18","v":0.75},{"$f":"Assess2!H18","v":"Adequately controlled"},{"$f":"IF(Assess2!I18=\"\",\"\",Assess2!I18)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B19=\"\",\"\",Assess!B19)","v":"K"},{"$f":"IF(Assess!C19=\"\",\"\",Assess!C19)","v":"Road Safety - Road traffic accidents may be one of the main threats facing students.  Roads are mainly in a poor condition, particularly in rural areas.  Road travel can be extremely hazardous due to poor driving practices, poorly maintained vehicles, insufficient street lighting, roaming livestock, pedestrians and cyclists.  Safety standards on small private buses and taxis are often low and do not meet US standards"},{"$f":"IF(Assess!D19=\"\",\"\",Assess!D19)","v":"Travel to tourist and historic areas of the country is popular and generally safe, although incidents of machete robberies occur on rural roads. There are occasional reports of clashes between government forces and bandits; however, foreigners are normally not affected.\n"},{"$f":"IF(Assess!E19=\"\",\"\",Assess!E19)","v":"High"},{"$f":"IF(Assess!F19=\"\",\"\",Assess!F19)","v":"High"},{"$f":"IF(Assess!L19=\"\",\"\",IF(Assess!M19=\"\",\"\",SUM(Assess!L19:M19)))","v":20},{"$f":"IF(Assess!G19=\"\",\"\",Assess!G19)","v":"Students should avoid traveling by road outside the main towns after dark, when the risk of accidents and robbery is greater.  Students should check with local staff before venturing off main roads in outlying areas.  Due to poor driving conditions and the poor mechanical state of many vehicles in Ghana, that vehicular travel after dark outside Accra should be avoided"},{"$f":"IF(Assess!H19=\"\",\"\",Assess!H19)","v":"Moderate"},{"$f":"IF(Assess!O19=\"\",\"\",Assess!O19)","v":8},{"$f":"IF(Assess!P19=\"\",\"\",Assess!P19)","v":"Potentially under-controlled"},{"$f":"IF(Assess2!F19=\"\",\"\",Assess2!F19)","v":""},{"$f":"IF(Assess2!G19=\"\",\"\",Assess2!G19)","v":"No Change"},{"$f":"Assess2!O19","v":0.6},{"$f":"Assess2!H19","v":"Potentially under-controlled"},{"$f":"IF(Assess2!I19=\"\",\"\",Assess2!I19)","v":"Students?--- Student's must choose to follow detailed advise."}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B20=\"\",\"\",Assess!B20)","v":"L"},{"$f":"IF(Assess!C20=\"\",\"\",Assess!C20)","v":"Tro Tro Accidents - Tro-Tros are the cheapest way to get around Accra.  Tro-tros are usually made from converted minibuses and are designed to fit as many people, possessions, and occasionally livestock, as possible."},{"$f":"IF(Assess!D20=\"\",\"\",Assess!D20)","v":"Tro-tro accidents are quite common due to unidentified speed limits, disregard of stop signs and lack of general defensive driving.  Informal and loosely regulated routes engender fierce competition and reckless driving that injures, and sometimes kills, thousands of passengers, pedestrians and cyclists every year."},{"$f":"IF(Assess!E20=\"\",\"\",Assess!E20)","v":"High"},{"$f":"IF(Assess!F20=\"\",\"\",Assess!F20)","v":"High"},{"$f":"IF(Assess!L20=\"\",\"\",IF(Assess!M20=\"\",\"\",SUM(Assess!L20:M20)))","v":20},{"$f":"IF(Assess!G20=\"\",\"\",Assess!G20)","v":"Do not travel by tro-tros, especially when it is dark."},{"$f":"IF(Assess!H20=\"\",\"\",Assess!H20)","v":"Moderate"},{"$f":"IF(Assess!O20=\"\",\"\",Assess!O20)","v":8},{"$f":"IF(Assess!P20=\"\",\"\",Assess!P20)","v":"Potentially under-controlled"},{"$f":"IF(Assess2!F20=\"\",\"\",Assess2!F20)","v":""},{"$f":"IF(Assess2!G20=\"\",\"\",Assess2!G20)","v":"No Change"},{"$f":"Assess2!O20","v":0.6},{"$f":"Assess2!H20","v":"Potentially under-controlled"},{"$f":"IF(Assess2!I20=\"\",\"\",Assess2!I20)","v":"Students?--- Student's must choose to follow detailed advise."}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B21=\"\",\"\",Assess!B21)","v":"M"},{"$f":"IF(Assess!C21=\"\",\"\",Assess!C21)","v":"Taxis - Criminals sometimes use taxis to rob patrons."},{"$f":"IF(Assess!D21=\"\",\"\",Assess!D21)","v":"The operation of streetlights in Ghana at night is inconsistent and dark areas become prime targets for criminals.  The potential for carjacking exists in Ghana and there have been some reported armed robberies and snatching of taxis from drivers."},{"$f":"IF(Assess!E21=\"\",\"\",Assess!E21)","v":"Moderate"},{"$f":"IF(Assess!F21=\"\",\"\",Assess!F21)","v":"Moderate"},{"$f":"IF(Assess!L21=\"\",\"\",IF(Assess!M21=\"\",\"\",SUM(Assess!L21:M21)))","v":15},{"$f":"IF(Assess!G21=\"\",\"\",Assess!G21)","v":"The Accra Metropolitan Assembly (AMA) requires all taxi drivers to wear a sea blue shirt and dark blue trousers as their uniform.  Also, drivers are required to register their vehicles with the Assembly to get a special serial number consisting of only three digits to be embossed with reflectors on both sides of the front doors to make identification easy even at night. This measure has been implemented to further enhance security for both taxi patrons and owners.  Students are told to exercise caution when traveling in taxis.  Students should confirm that the taxi has sufficient gas before hiring it, because drivers will lure taxi occupants to gas stations to be robbed by awaiting criminals.  Never board a taxi with all male occupants already in or a female passenger and two male passengers as they could be decoys."},{"$f":"IF(Assess!H21=\"\",\"\",Assess!H21)","v":"Substantial"},{"$f":"IF(Assess!O21=\"\",\"\",Assess!O21)","v":3.75},{"$f":"IF(Assess!P21=\"\",\"\",Assess!P21)","v":"Adequately controlled"},{"$f":"IF(Assess2!F21=\"\",\"\",Assess2!F21)","v":""},{"$f":"IF(Assess2!G21=\"\",\"\",Assess2!G21)","v":"No Change"},{"$f":"Assess2!O21","v":0.75},{"$f":"Assess2!H21","v":"Adequately controlled"},{"$f":"IF(Assess2!I21=\"\",\"\",Assess2!I21)","v":"Students?--- Student's must choose to follow detailed advise."}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B22=\"\",\"\",Assess!B22)","v":"N"},{"$f":"IF(Assess!C22=\"\",\"\",Assess!C22)","v":"Ghanaian law criminalizes homosexuality.  A large portion of Ghanaian society does not accept that such activity exists.  A gay social life exists, mostly in the form of house parties, and a few queer-friendly clubs in Accra, but there are risks."},{"$f":"IF(Assess!D22=\"\",\"\",Assess!D22)","v":"There is a minimum misdemeanor charge for homosexual activity.  Lesbians and gays face widespread discrimination, as well as police harassment and extortion attempts.  There is a small gay community.  There is a lot of stigma towards gay men and lesbians living in Ghana"},{"$f":"IF(Assess!E22=\"\",\"\",Assess!E22)","v":"High"},{"$f":"IF(Assess!F22=\"\",\"\",Assess!F22)","v":"Low"},{"$f":"IF(Assess!L22=\"\",\"\",IF(Assess!M22=\"\",\"\",SUM(Assess!L22:M22)))","v":16},{"$f":"IF(Assess!G22=\"\",\"\",Assess!G22)","v":"Further information is available from the Gay and Lesbian Association of Ghana or Behind the Mask (http://www.mask.org.za/index.php?page=home)"},{"$f":"IF(Assess!H22=\"\",\"\",Assess!H22)","v":"Substantial"},{"$f":"IF(Assess!O22=\"\",\"\",Assess!O22)","v":4},{"$f":"IF(Assess!P22=\"\",\"\",Assess!P22)","v":"Adequately controlled"},{"$f":"IF(Assess2!F22=\"\",\"\",Assess2!F22)","v":""},{"$f":"IF(Assess2!G22=\"\",\"\",Assess2!G22)","v":"No Change"},{"$f":"Assess2!O22","v":0.75},{"$f":"Assess2!H22","v":"Adequately controlled"},{"$f":"IF(Assess2!I22=\"\",\"\",Assess2!I22)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B23=\"\",\"\",Assess!B23)","v":"O"},{"$f":"IF(Assess!C23=\"\",\"\",Assess!C23)","v":"Non-Violent Crime - Street theft is the most common; Street persons asking for handouts may grab jewelry or other items from one's neck or wrist, or distract the victim for a pickpocket; criminals will sometimes use motorcycles to drive by unsuspecting pedestrians and snatch their bags.  Theft of unattended property is common in Ghana."},{"$f":"IF(Assess!D23=\"\",\"\",Assess!D23)","v":"Loss of property"},{"$f":"IF(Assess!E23=\"\",\"\",Assess!E23)","v":"Moderate"},{"$f":"IF(Assess!F23=\"\",\"\",Assess!F23)","v":"High"},{"$f":"IF(Assess!L23=\"\",\"\",IF(Assess!M23=\"\",\"\",SUM(Assess!L23:M23)))","v":17},{"$f":"IF(Assess!G23=\"\",\"\",Assess!G23)","v":"Students are advised to be constantly aware of their surroundings, especially in crowded streets and shopping/market areas;  never venture out alone; use the buddy system; go in groups; proceed to a location where help is available if afraid; monitor the media for information about new safety or security risks; stay in well-lit areas; carry only necessary credit cards and money, not air tickets; act suspicious if followed; never hitchhike; be discreet; avoid uncontrolled crowds; look confident and do not wander into unknown areas. Exercise caution; do not accept lifts or drinks from strangers; ensure others know whereabouts;  use safest route to destination; lock up valuables; keep a vigilant eye on property; carry money in several locations; trust instincts; protect cell phones; ask Study Center staff for advice; and read the U.S. Department of State, Country Specific Information on Ghana UCEAP insurance covers personal property up to a certain amount.  Students are advised to supplement coverage if UCEAP benefit is inadequate based on her personal belongings."},{"$f":"IF(Assess!H23=\"\",\"\",Assess!H23)","v":"Substantial"},{"$f":"IF(Assess!O23=\"\",\"\",Assess!O23)","v":4.25},{"$f":"IF(Assess!P23=\"\",\"\",Assess!P23)","v":"Adequately controlled"},{"$f":"IF(Assess2!F23=\"\",\"\",Assess2!F23)","v":""},{"$f":"IF(Assess2!G23=\"\",\"\",Assess2!G23)","v":"No Change"},{"$f":"Assess2!O23","v":0.75},{"$f":"Assess2!H23","v":"Adequately controlled"},{"$f":"IF(Assess2!I23=\"\",\"\",Assess2!I23)","v":"Students?--- Student's must choose to follow detailed advise."}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B24=\"\",\"\",Assess!B24)","v":"P"},{"$f":"IF(Assess!C24=\"\",\"\",Assess!C24)","v":"Violent Crime - includes muggings carried out by groups of men; armed robbery using machetes or handguns; Home invasions by criminals who are sometimes armed;"},{"$f":"IF(Assess!D24=\"\",\"\",Assess!D24)","v":"Loss of life; Serious injury"},{"$f":"IF(Assess!E24=\"\",\"\",Assess!E24)","v":"High"},{"$f":"IF(Assess!F24=\"\",\"\",Assess!F24)","v":"Moderate"},{"$f":"IF(Assess!L24=\"\",\"\",IF(Assess!M24=\"\",\"\",SUM(Assess!L24:M24)))","v":18},{"$f":"IF(Assess!G24=\"\",\"\",Assess!G24)","v":"If confronted by would-be assailants, comply.  There have been several incidents where people have resisted trying to hang on to their purse/bag, or it was perceived as resistance and they were seriously injured.  See \"O\" above."},{"$f":"IF(Assess!H24=\"\",\"\",Assess!H24)","v":"Substantial"},{"$f":"IF(Assess!O24=\"\",\"\",Assess!O24)","v":4.5},{"$f":"IF(Assess!P24=\"\",\"\",Assess!P24)","v":"Adequately controlled"},{"$f":"IF(Assess2!F24=\"\",\"\",Assess2!F24)","v":""},{"$f":"IF(Assess2!G24=\"\",\"\",Assess2!G24)","v":"No Change"},{"$f":"Assess2!O24","v":0.75},{"$f":"Assess2!H24","v":"Adequately controlled"},{"$f":"IF(Assess2!I24=\"\",\"\",Assess2!I24)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B25=\"\",\"\",Assess!B25)","v":"Q"},{"$f":"IF(Assess!C25=\"\",\"\",Assess!C25)","v":"The Ghanaian Police Service (GPS) is almost solely a reactive force and demonstrates moderate proactive techniques to deter criminals. Police often lack the equipment, resources, training, and personnel to respond to calls for assistance or other emergencies. The police have a poor record of investigating and solving serious crimes."},{"$f":"IF(Assess!D25=\"\",\"\",Assess!D25)","v":"Loss of life; Serious injury; Loss of property"},{"$f":"IF(Assess!E25=\"\",\"\",Assess!E25)","v":"High"},{"$f":"IF(Assess!F25=\"\",\"\",Assess!F25)","v":"Moderate"},{"$f":"IF(Assess!L25=\"\",\"\",IF(Assess!M25=\"\",\"\",SUM(Assess!L25:M25)))","v":18},{"$f":"IF(Assess!G25=\"\",\"\",Assess!G25)","v":"If confronted by would-be assailants, comply.  There have been several incidents where people have resisted trying to hang on to their purse/bag, or it was perceived as resistance and they were seriously injured.  See \"O\" above."},{"$f":"IF(Assess!H25=\"\",\"\",Assess!H25)","v":""},{"$f":"IF(Assess!O25=\"\",\"\",Assess!O25)","v":""},{"$f":"IF(Assess!P25=\"\",\"\",Assess!P25)","v":""},{"$f":"IF(Assess2!F25=\"\",\"\",Assess2!F25)","v":""},{"$f":"IF(Assess2!G25=\"\",\"\",Assess2!G25)","v":""},{"$f":"Assess2!O25","v":""},{"$f":"Assess2!H25","v":""},{"$f":"IF(Assess2!I25=\"\",\"\",Assess2!I25)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B26=\"\",\"\",Assess!B26)","v":"R"},{"$f":"IF(Assess!C26=\"\",\"\",Assess!C26)","v":"Credit card skimming is especially prevalent in Ghana.  "},{"$f":"IF(Assess!D26=\"\",\"\",Assess!D26)","v":"Loss of property; credit card not valid when needed"},{"$f":"IF(Assess!E26=\"\",\"\",Assess!E26)","v":"High"},{"$f":"IF(Assess!F26=\"\",\"\",Assess!F26)","v":"Moderate"},{"$f":"IF(Assess!L26=\"\",\"\",IF(Assess!M26=\"\",\"\",SUM(Assess!L26:M26)))","v":18},{"$f":"IF(Assess!G26=\"\",\"\",Assess!G26)","v":"Students advised to limit purchases or cash advances using credit cards; not allow anyone to take your credit card out of your sight; use credit cards only in reputable restaurants or shops; ask to be present during the transaction process; retain and destroy all receipts and carbons; keep accurate records of any transactions; and notify your bank’s fraud department immediately if you suspect fraudulent charges."},{"$f":"IF(Assess!H26=\"\",\"\",Assess!H26)","v":""},{"$f":"IF(Assess!O26=\"\",\"\",Assess!O26)","v":""},{"$f":"IF(Assess!P26=\"\",\"\",Assess!P26)","v":""},{"$f":"IF(Assess2!F26=\"\",\"\",Assess2!F26)","v":""},{"$f":"IF(Assess2!G26=\"\",\"\",Assess2!G26)","v":""},{"$f":"Assess2!O26","v":""},{"$f":"Assess2!H26","v":""},{"$f":"IF(Assess2!I26=\"\",\"\",Assess2!I26)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B27=\"\",\"\",Assess!B27)","v":"S"},{"$f":"IF(Assess!C27=\"\",\"\",Assess!C27)","v":"Crime on Campus - The campus is extremely large and there are numerous points of entry beyond the official, guarded gates.  Lighting on certain parts of the campus is substandard.  "},{"$f":"IF(Assess!D27=\"\",\"\",Assess!D27)","v":"Student injury or death; Loss of property; Student activity in violation of campus policy and Ghanaian law may result in both internal and external judicial action being taken. The Dean of Students initiates disciplinary action in accordance with the University Statutes for violators who are students. Cases of incidents involving international students are initially dealt with by a specific committee of inquiry constituted by the Office of the Dean of International Programs."},{"$f":"IF(Assess!E27=\"\",\"\",Assess!E27)","v":"High"},{"$f":"IF(Assess!F27=\"\",\"\",Assess!F27)","v":"Moderate"},{"$f":"IF(Assess!L27=\"\",\"\",IF(Assess!M27=\"\",\"\",SUM(Assess!L27:M27)))","v":18},{"$f":"IF(Assess!G27=\"\",\"\",Assess!G27)","v":"Primary responsibility for security on campus resides with the University Security Office of the University. The University Security services enforce order, protect life and property, make arrests as provided by law, conduct investigations, and exercise powers similar to the police. University Security is on duty 24 hours a day, 365 days a year and in constant communication with the main Security centre.  The University security guards patrol the exterior areas of the campus, twenty-four hours a day. In some cases, additional regular tours of the interior of the residence halls to check lounges, corridors and other common residence areas are carried out. Guards, assisted by Porters or other resident staff members, may confront residents and visitors suspected of violations of University policy.  Students are advised of safety rules and best practices"},{"$f":"IF(Assess!H27=\"\",\"\",Assess!H27)","v":""},{"$f":"IF(Assess!O27=\"\",\"\",Assess!O27)","v":""},{"$f":"IF(Assess!P27=\"\",\"\",Assess!P27)","v":""},{"$f":"IF(Assess2!F27=\"\",\"\",Assess2!F27)","v":""},{"$f":"IF(Assess2!G27=\"\",\"\",Assess2!G27)","v":""},{"$f":"Assess2!O27","v":""},{"$f":"Assess2!H27","v":""},{"$f":"IF(Assess2!I27=\"\",\"\",Assess2!I27)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B28=\"\",\"\",Assess!B28)","v":"T"},{"$f":"IF(Assess!C28=\"\",\"\",Assess!C28)","v":"Legal Considerations - Photography at airports, railway stations, naval bases, air bases, military installations, public water and energy plants, police stations, harbors, mines and bridges is prohibited in Ghana."},{"$f":"IF(Assess!D28=\"\",\"\",Assess!D28)","v":"Laws are strictly enforced and all restrictions should be observed;  Students could be fined or jailed."},{"$f":"IF(Assess!E28=\"\",\"\",Assess!E28)","v":"High"},{"$f":"IF(Assess!F28=\"\",\"\",Assess!F28)","v":"High"},{"$f":"IF(Assess!L28=\"\",\"\",IF(Assess!M28=\"\",\"\",SUM(Assess!L28:M28)))","v":20},{"$f":"IF(Assess!G28=\"\",\"\",Assess!G28)","v":"Risk is preventable. Awareness of the laws is the key to avoiding trouble.  Foreigners are more likely to be at risk than locals.  Students should research the legal system in Ghana to be aware of penalties and other laws, e.g., laws relating to drugs/alcohol, sexuality; severity of punishment for crimes; nature of the legal system; obtaining legal assistance."},{"$f":"IF(Assess!H28=\"\",\"\",Assess!H28)","v":""},{"$f":"IF(Assess!O28=\"\",\"\",Assess!O28)","v":""},{"$f":"IF(Assess!P28=\"\",\"\",Assess!P28)","v":""},{"$f":"IF(Assess2!F28=\"\",\"\",Assess2!F28)","v":""},{"$f":"IF(Assess2!G28=\"\",\"\",Assess2!G28)","v":""},{"$f":"Assess2!O28","v":""},{"$f":"Assess2!H28","v":""},{"$f":"IF(Assess2!I28=\"\",\"\",Assess2!I28)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B29=\"\",\"\",Assess!B29)","v":"U"},{"$f":"IF(Assess!C29=\"\",\"\",Assess!C29)","v":""},{"$f":"IF(Assess!D29=\"\",\"\",Assess!D29)","v":""},{"$f":"IF(Assess!E29=\"\",\"\",Assess!E29)","v":""},{"$f":"IF(Assess!F29=\"\",\"\",Assess!F29)","v":""},{"$f":"IF(Assess!L29=\"\",\"\",IF(Assess!M29=\"\",\"\",SUM(Assess!L29:M29)))","v":""},{"$f":"IF(Assess!G29=\"\",\"\",Assess!G29)","v":""},{"$f":"IF(Assess!H29=\"\",\"\",Assess!H29)","v":""},{"$f":"IF(Assess!O29=\"\",\"\",Assess!O29)","v":""},{"$f":"IF(Assess!P29=\"\",\"\",Assess!P29)","v":""},{"$f":"IF(Assess2!F29=\"\",\"\",Assess2!F29)","v":""},{"$f":"IF(Assess2!G29=\"\",\"\",Assess2!G29)","v":""},{"$f":"Assess2!O29","v":""},{"$f":"Assess2!H29","v":""},{"$f":"IF(Assess2!I29=\"\",\"\",Assess2!I29)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B30=\"\",\"\",Assess!B30)","v":"V"},{"$f":"IF(Assess!C30=\"\",\"\",Assess!C30)","v":""},{"$f":"IF(Assess!D30=\"\",\"\",Assess!D30)","v":""},{"$f":"IF(Assess!E30=\"\",\"\",Assess!E30)","v":""},{"$f":"IF(Assess!F30=\"\",\"\",Assess!F30)","v":""},{"$f":"IF(Assess!L30=\"\",\"\",IF(Assess!M30=\"\",\"\",SUM(Assess!L30:M30)))","v":""},{"$f":"IF(Assess!G30=\"\",\"\",Assess!G30)","v":""},{"$f":"IF(Assess!H30=\"\",\"\",Assess!H30)","v":""},{"$f":"IF(Assess!O30=\"\",\"\",Assess!O30)","v":""},{"$f":"IF(Assess!P30=\"\",\"\",Assess!P30)","v":""},{"$f":"IF(Assess2!F30=\"\",\"\",Assess2!F30)","v":""},{"$f":"IF(Assess2!G30=\"\",\"\",Assess2!G30)","v":""},{"$f":"Assess2!O30","v":""},{"$f":"Assess2!H30","v":""},{"$f":"IF(Assess2!I30=\"\",\"\",Assess2!I30)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B31=\"\",\"\",Assess!B31)","v":"W"},{"$f":"IF(Assess!C31=\"\",\"\",Assess!C31)","v":""},{"$f":"IF(Assess!D31=\"\",\"\",Assess!D31)","v":""},{"$f":"IF(Assess!E31=\"\",\"\",Assess!E31)","v":""},{"$f":"IF(Assess!F31=\"\",\"\",Assess!F31)","v":""},{"$f":"IF(Assess!L31=\"\",\"\",IF(Assess!M31=\"\",\"\",SUM(Assess!L31:M31)))","v":""},{"$f":"IF(Assess!G31=\"\",\"\",Assess!G31)","v":""},{"$f":"IF(Assess!H31=\"\",\"\",Assess!H31)","v":""},{"$f":"IF(Assess!O31=\"\",\"\",Assess!O31)","v":""},{"$f":"IF(Assess!P31=\"\",\"\",Assess!P31)","v":""},{"$f":"IF(Assess2!F31=\"\",\"\",Assess2!F31)","v":""},{"$f":"IF(Assess2!G31=\"\",\"\",Assess2!G31)","v":""},{"$f":"Assess2!O31","v":""},{"$f":"Assess2!H31","v":""},{"$f":"IF(Assess2!I31=\"\",\"\",Assess2!I31)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B32=\"\",\"\",Assess!B32)","v":"X"},{"$f":"IF(Assess!C32=\"\",\"\",Assess!C32)","v":""},{"$f":"IF(Assess!D32=\"\",\"\",Assess!D32)","v":""},{"$f":"IF(Assess!E32=\"\",\"\",Assess!E32)","v":""},{"$f":"IF(Assess!F32=\"\",\"\",Assess!F32)","v":""},{"$f":"IF(Assess!L32=\"\",\"\",IF(Assess!M32=\"\",\"\",SUM(Assess!L32:M32)))","v":""},{"$f":"IF(Assess!G32=\"\",\"\",Assess!G32)","v":""},{"$f":"IF(Assess!H32=\"\",\"\",Assess!H32)","v":""},{"$f":"IF(Assess!O32=\"\",\"\",Assess!O32)","v":""},{"$f":"IF(Assess!P32=\"\",\"\",Assess!P32)","v":""},{"$f":"IF(Assess2!F32=\"\",\"\",Assess2!F32)","v":""},{"$f":"IF(Assess2!G32=\"\",\"\",Assess2!G32)","v":""},{"$f":"Assess2!O32","v":""},{"$f":"Assess2!H32","v":""},{"$f":"IF(Assess2!I32=\"\",\"\",Assess2!I32)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B33=\"\",\"\",Assess!B33)","v":"Y"},{"$f":"IF(Assess!C33=\"\",\"\",Assess!C33)","v":""},{"$f":"IF(Assess!D33=\"\",\"\",Assess!D33)","v":""},{"$f":"IF(Assess!E33=\"\",\"\",Assess!E33)","v":""},{"$f":"IF(Assess!F33=\"\",\"\",Assess!F33)","v":""},{"$f":"IF(Assess!L33=\"\",\"\",IF(Assess!M33=\"\",\"\",SUM(Assess!L33:M33)))","v":""},{"$f":"IF(Assess!G33=\"\",\"\",Assess!G33)","v":""},{"$f":"IF(Assess!H33=\"\",\"\",Assess!H33)","v":""},{"$f":"IF(Assess!O33=\"\",\"\",Assess!O33)","v":""},{"$f":"IF(Assess!P33=\"\",\"\",Assess!P33)","v":""},{"$f":"IF(Assess2!F33=\"\",\"\",Assess2!F33)","v":""},{"$f":"IF(Assess2!G33=\"\",\"\",Assess2!G33)","v":""},{"$f":"Assess2!O33","v":""},{"$f":"Assess2!H33","v":""},{"$f":"IF(Assess2!I33=\"\",\"\",Assess2!I33)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B34=\"\",\"\",Assess!B34)","v":"Z"},{"$f":"IF(Assess!C34=\"\",\"\",Assess!C34)","v":""},{"$f":"IF(Assess!D34=\"\",\"\",Assess!D34)","v":""},{"$f":"IF(Assess!E34=\"\",\"\",Assess!E34)","v":""},{"$f":"IF(Assess!F34=\"\",\"\",Assess!F34)","v":""},{"$f":"IF(Assess!L34=\"\",\"\",IF(Assess!M34=\"\",\"\",SUM(Assess!L34:M34)))","v":""},{"$f":"IF(Assess!G34=\"\",\"\",Assess!G34)","v":""},{"$f":"IF(Assess!H34=\"\",\"\",Assess!H34)","v":""},{"$f":"IF(Assess!O34=\"\",\"\",Assess!O34)","v":""},{"$f":"IF(Assess!P34=\"\",\"\",Assess!P34)","v":""},{"$f":"IF(Assess2!F34=\"\",\"\",Assess2!F34)","v":""},{"$f":"IF(Assess2!G34=\"\",\"\",Assess2!G34)","v":""},{"$f":"Assess2!O34","v":""},{"$f":"Assess2!H34","v":""},{"$f":"IF(Assess2!I34=\"\",\"\",Assess2!I34)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B35=\"\",\"\",Assess!B35)","v":"AA"},{"$f":"IF(Assess!C35=\"\",\"\",Assess!C35)","v":""},{"$f":"IF(Assess!D35=\"\",\"\",Assess!D35)","v":""},{"$f":"IF(Assess!E35=\"\",\"\",Assess!E35)","v":""},{"$f":"IF(Assess!F35=\"\",\"\",Assess!F35)","v":""},{"$f":"IF(Assess!L35=\"\",\"\",IF(Assess!M35=\"\",\"\",SUM(Assess!L35:M35)))","v":""},{"$f":"IF(Assess!G35=\"\",\"\",Assess!G35)","v":""},{"$f":"IF(Assess!H35=\"\",\"\",Assess!H35)","v":""},{"$f":"IF(Assess!O35=\"\",\"\",Assess!O35)","v":""},{"$f":"IF(Assess!P35=\"\",\"\",Assess!P35)","v":""},{"$f":"IF(Assess2!F35=\"\",\"\",Assess2!F35)","v":""},{"$f":"IF(Assess2!G35=\"\",\"\",Assess2!G35)","v":""},{"$f":"Assess2!O35","v":""},{"$f":"Assess2!H35","v":""},{"$f":"IF(Assess2!I35=\"\",\"\",Assess2!I35)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B36=\"\",\"\",Assess!B36)","v":"BB"},{"$f":"IF(Assess!C36=\"\",\"\",Assess!C36)","v":""},{"$f":"IF(Assess!D36=\"\",\"\",Assess!D36)","v":""},{"$f":"IF(Assess!E36=\"\",\"\",Assess!E36)","v":""},{"$f":"IF(Assess!F36=\"\",\"\",Assess!F36)","v":""},{"$f":"IF(Assess!L36=\"\",\"\",IF(Assess!M36=\"\",\"\",SUM(Assess!L36:M36)))","v":""},{"$f":"IF(Assess!G36=\"\",\"\",Assess!G36)","v":""},{"$f":"IF(Assess!H36=\"\",\"\",Assess!H36)","v":""},{"$f":"IF(Assess!O36=\"\",\"\",Assess!O36)","v":""},{"$f":"IF(Assess!P36=\"\",\"\",Assess!P36)","v":""},{"$f":"IF(Assess2!F36=\"\",\"\",Assess2!F36)","v":""},{"$f":"IF(Assess2!G36=\"\",\"\",Assess2!G36)","v":""},{"$f":"Assess2!O36","v":""},{"$f":"Assess2!H36","v":""},{"$f":"IF(Assess2!I36=\"\",\"\",Assess2!I36)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B37=\"\",\"\",Assess!B37)","v":"CC"},{"$f":"IF(Assess!C37=\"\",\"\",Assess!C37)","v":""},{"$f":"IF(Assess!D37=\"\",\"\",Assess!D37)","v":""},{"$f":"IF(Assess!E37=\"\",\"\",Assess!E37)","v":""},{"$f":"IF(Assess!F37=\"\",\"\",Assess!F37)","v":""},{"$f":"IF(Assess!L37=\"\",\"\",IF(Assess!M37=\"\",\"\",SUM(Assess!L37:M37)))","v":""},{"$f":"IF(Assess!G37=\"\",\"\",Assess!G37)","v":""},{"$f":"IF(Assess!H37=\"\",\"\",Assess!H37)","v":""},{"$f":"IF(Assess!O37=\"\",\"\",Assess!O37)","v":""},{"$f":"IF(Assess!P37=\"\",\"\",Assess!P37)","v":""},{"$f":"IF(Assess2!F37=\"\",\"\",Assess2!F37)","v":""},{"$f":"IF(Assess2!G37=\"\",\"\",Assess2!G37)","v":""},{"$f":"Assess2!O37","v":""},{"$f":"Assess2!H37","v":""},{"$f":"IF(Assess2!I37=\"\",\"\",Assess2!I37)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B38=\"\",\"\",Assess!B38)","v":"DD"},{"$f":"IF(Assess!C38=\"\",\"\",Assess!C38)","v":""},{"$f":"IF(Assess!D38=\"\",\"\",Assess!D38)","v":""},{"$f":"IF(Assess!E38=\"\",\"\",Assess!E38)","v":""},{"$f":"IF(Assess!F38=\"\",\"\",Assess!F38)","v":""},{"$f":"IF(Assess!L38=\"\",\"\",IF(Assess!M38=\"\",\"\",SUM(Assess!L38:M38)))","v":""},{"$f":"IF(Assess!G38=\"\",\"\",Assess!G38)","v":""},{"$f":"IF(Assess!H38=\"\",\"\",Assess!H38)","v":""},{"$f":"IF(Assess!O38=\"\",\"\",Assess!O38)","v":""},{"$f":"IF(Assess!P38=\"\",\"\",Assess!P38)","v":""},{"$f":"IF(Assess2!F38=\"\",\"\",Assess2!F38)","v":""},{"$f":"IF(Assess2!G38=\"\",\"\",Assess2!G38)","v":""},{"$f":"Assess2!O38","v":""},{"$f":"Assess2!H38","v":""},{"$f":"IF(Assess2!I38=\"\",\"\",Assess2!I38)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B39=\"\",\"\",Assess!B39)","v":"EE"},{"$f":"IF(Assess!C39=\"\",\"\",Assess!C39)","v":""},{"$f":"IF(Assess!D39=\"\",\"\",Assess!D39)","v":""},{"$f":"IF(Assess!E39=\"\",\"\",Assess!E39)","v":""},{"$f":"IF(Assess!F39=\"\",\"\",Assess!F39)","v":""},{"$f":"IF(Assess!L39=\"\",\"\",IF(Assess!M39=\"\",\"\",SUM(Assess!L39:M39)))","v":""},{"$f":"IF(Assess!G39=\"\",\"\",Assess!G39)","v":""},{"$f":"IF(Assess!H39=\"\",\"\",Assess!H39)","v":""},{"$f":"IF(Assess!O39=\"\",\"\",Assess!O39)","v":""},{"$f":"IF(Assess!P39=\"\",\"\",Assess!P39)","v":""},{"$f":"IF(Assess2!F39=\"\",\"\",Assess2!F39)","v":""},{"$f":"IF(Assess2!G39=\"\",\"\",Assess2!G39)","v":""},{"$f":"Assess2!O39","v":""},{"$f":"Assess2!H39","v":""},{"$f":"IF(Assess2!I39=\"\",\"\",Assess2!I39)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B40=\"\",\"\",Assess!B40)","v":"FF"},{"$f":"IF(Assess!C40=\"\",\"\",Assess!C40)","v":""},{"$f":"IF(Assess!D40=\"\",\"\",Assess!D40)","v":""},{"$f":"IF(Assess!E40=\"\",\"\",Assess!E40)","v":""},{"$f":"IF(Assess!F40=\"\",\"\",Assess!F40)","v":""},{"$f":"IF(Assess!L40=\"\",\"\",IF(Assess!M40=\"\",\"\",SUM(Assess!L40:M40)))","v":""},{"$f":"IF(Assess!G40=\"\",\"\",Assess!G40)","v":""},{"$f":"IF(Assess!H40=\"\",\"\",Assess!H40)","v":""},{"$f":"IF(Assess!O40=\"\",\"\",Assess!O40)","v":""},{"$f":"IF(Assess!P40=\"\",\"\",Assess!P40)","v":""},{"$f":"IF(Assess2!F40=\"\",\"\",Assess2!F40)","v":""},{"$f":"IF(Assess2!G40=\"\",\"\",Assess2!G40)","v":""},{"$f":"Assess2!O40","v":""},{"$f":"Assess2!H40","v":""},{"$f":"IF(Assess2!I40=\"\",\"\",Assess2!I40)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B41=\"\",\"\",Assess!B41)","v":"GG"},{"$f":"IF(Assess!C41=\"\",\"\",Assess!C41)","v":""},{"$f":"IF(Assess!D41=\"\",\"\",Assess!D41)","v":""},{"$f":"IF(Assess!E41=\"\",\"\",Assess!E41)","v":""},{"$f":"IF(Assess!F41=\"\",\"\",Assess!F41)","v":""},{"$f":"IF(Assess!L41=\"\",\"\",IF(Assess!M41=\"\",\"\",SUM(Assess!L41:M41)))","v":""},{"$f":"IF(Assess!G41=\"\",\"\",Assess!G41)","v":""},{"$f":"IF(Assess!H41=\"\",\"\",Assess!H41)","v":""},{"$f":"IF(Assess!O41=\"\",\"\",Assess!O41)","v":""},{"$f":"IF(Assess!P41=\"\",\"\",Assess!P41)","v":""},{"$f":"IF(Assess2!F41=\"\",\"\",Assess2!F41)","v":""},{"$f":"IF(Assess2!G41=\"\",\"\",Assess2!G41)","v":""},{"$f":"Assess2!O41","v":""},{"$f":"Assess2!H41","v":""},{"$f":"IF(Assess2!I41=\"\",\"\",Assess2!I41)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B42=\"\",\"\",Assess!B42)","v":"HH"},{"$f":"IF(Assess!C42=\"\",\"\",Assess!C42)","v":""},{"$f":"IF(Assess!D42=\"\",\"\",Assess!D42)","v":""},{"$f":"IF(Assess!E42=\"\",\"\",Assess!E42)","v":""},{"$f":"IF(Assess!F42=\"\",\"\",Assess!F42)","v":""},{"$f":"IF(Assess!L42=\"\",\"\",IF(Assess!M42=\"\",\"\",SUM(Assess!L42:M42)))","v":""},{"$f":"IF(Assess!G42=\"\",\"\",Assess!G42)","v":""},{"$f":"IF(Assess!H42=\"\",\"\",Assess!H42)","v":""},{"$f":"IF(Assess!O42=\"\",\"\",Assess!O42)","v":""},{"$f":"IF(Assess!P42=\"\",\"\",Assess!P42)","v":""},{"$f":"IF(Assess2!F42=\"\",\"\",Assess2!F42)","v":""},{"$f":"IF(Assess2!G42=\"\",\"\",Assess2!G42)","v":""},{"$f":"Assess2!O42","v":""},{"$f":"Assess2!H42","v":""},{"$f":"IF(Assess2!I42=\"\",\"\",Assess2!I42)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B43=\"\",\"\",Assess!B43)","v":"II"},{"$f":"IF(Assess!C43=\"\",\"\",Assess!C43)","v":""},{"$f":"IF(Assess!D43=\"\",\"\",Assess!D43)","v":""},{"$f":"IF(Assess!E43=\"\",\"\",Assess!E43)","v":""},{"$f":"IF(Assess!F43=\"\",\"\",Assess!F43)","v":""},{"$f":"IF(Assess!L43=\"\",\"\",IF(Assess!M43=\"\",\"\",SUM(Assess!L43:M43)))","v":""},{"$f":"IF(Assess!G43=\"\",\"\",Assess!G43)","v":""},{"$f":"IF(Assess!H43=\"\",\"\",Assess!H43)","v":""},{"$f":"IF(Assess!O43=\"\",\"\",Assess!O43)","v":""},{"$f":"IF(Assess!P43=\"\",\"\",Assess!P43)","v":""},{"$f":"IF(Assess2!F43=\"\",\"\",Assess2!F43)","v":""},{"$f":"IF(Assess2!G43=\"\",\"\",Assess2!G43)","v":""},{"$f":"Assess2!O43","v":""},{"$f":"Assess2!H43","v":""},{"$f":"IF(Assess2!I43=\"\",\"\",Assess2!I43)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B44=\"\",\"\",Assess!B44)","v":"JJ"},{"$f":"IF(Assess!C44=\"\",\"\",Assess!C44)","v":""},{"$f":"IF(Assess!D44=\"\",\"\",Assess!D44)","v":""},{"$f":"IF(Assess!E44=\"\",\"\",Assess!E44)","v":""},{"$f":"IF(Assess!F44=\"\",\"\",Assess!F44)","v":""},{"$f":"IF(Assess!L44=\"\",\"\",IF(Assess!M44=\"\",\"\",SUM(Assess!L44:M44)))","v":""},{"$f":"IF(Assess!G44=\"\",\"\",Assess!G44)","v":""},{"$f":"IF(Assess!H44=\"\",\"\",Assess!H44)","v":""},{"$f":"IF(Assess!O44=\"\",\"\",Assess!O44)","v":""},{"$f":"IF(Assess!P44=\"\",\"\",Assess!P44)","v":""},{"$f":"IF(Assess2!F44=\"\",\"\",Assess2!F44)","v":""},{"$f":"IF(Assess2!G44=\"\",\"\",Assess2!G44)","v":""},{"$f":"Assess2!O44","v":""},{"$f":"Assess2!H44","v":""},{"$f":"IF(Assess2!I44=\"\",\"\",Assess2!I44)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B45=\"\",\"\",Assess!B45)","v":"KK"},{"$f":"IF(Assess!C45=\"\",\"\",Assess!C45)","v":""},{"$f":"IF(Assess!D45=\"\",\"\",Assess!D45)","v":""},{"$f":"IF(Assess!E45=\"\",\"\",Assess!E45)","v":""},{"$f":"IF(Assess!F45=\"\",\"\",Assess!F45)","v":""},{"$f":"IF(Assess!L45=\"\",\"\",IF(Assess!M45=\"\",\"\",SUM(Assess!L45:M45)))","v":""},{"$f":"IF(Assess!G45=\"\",\"\",Assess!G45)","v":""},{"$f":"IF(Assess!H45=\"\",\"\",Assess!H45)","v":""},{"$f":"IF(Assess!O45=\"\",\"\",Assess!O45)","v":""},{"$f":"IF(Assess!P45=\"\",\"\",Assess!P45)","v":""},{"$f":"IF(Assess2!F45=\"\",\"\",Assess2!F45)","v":""},{"$f":"IF(Assess2!G45=\"\",\"\",Assess2!G45)","v":""},{"$f":"Assess2!O45","v":""},{"$f":"Assess2!H45","v":""},{"$f":"IF(Assess2!I45=\"\",\"\",Assess2!I45)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B46=\"\",\"\",Assess!B46)","v":"LL"},{"$f":"IF(Assess!C46=\"\",\"\",Assess!C46)","v":""},{"$f":"IF(Assess!D46=\"\",\"\",Assess!D46)","v":""},{"$f":"IF(Assess!E46=\"\",\"\",Assess!E46)","v":""},{"$f":"IF(Assess!F46=\"\",\"\",Assess!F46)","v":""},{"$f":"IF(Assess!L46=\"\",\"\",IF(Assess!M46=\"\",\"\",SUM(Assess!L46:M46)))","v":""},{"$f":"IF(Assess!G46=\"\",\"\",Assess!G46)","v":""},{"$f":"IF(Assess!H46=\"\",\"\",Assess!H46)","v":""},{"$f":"IF(Assess!O46=\"\",\"\",Assess!O46)","v":""},{"$f":"IF(Assess!P46=\"\",\"\",Assess!P46)","v":""},{"$f":"IF(Assess2!F46=\"\",\"\",Assess2!F46)","v":""},{"$f":"IF(Assess2!G46=\"\",\"\",Assess2!G46)","v":""},{"$f":"Assess2!O46","v":""},{"$f":"Assess2!H46","v":""},{"$f":"IF(Assess2!I46=\"\",\"\",Assess2!I46)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B47=\"\",\"\",Assess!B47)","v":"MM"},{"$f":"IF(Assess!C47=\"\",\"\",Assess!C47)","v":""},{"$f":"IF(Assess!D47=\"\",\"\",Assess!D47)","v":""},{"$f":"IF(Assess!E47=\"\",\"\",Assess!E47)","v":""},{"$f":"IF(Assess!F47=\"\",\"\",Assess!F47)","v":""},{"$f":"IF(Assess!L47=\"\",\"\",IF(Assess!M47=\"\",\"\",SUM(Assess!L47:M47)))","v":""},{"$f":"IF(Assess!G47=\"\",\"\",Assess!G47)","v":""},{"$f":"IF(Assess!H47=\"\",\"\",Assess!H47)","v":""},{"$f":"IF(Assess!O47=\"\",\"\",Assess!O47)","v":""},{"$f":"IF(Assess!P47=\"\",\"\",Assess!P47)","v":""},{"$f":"IF(Assess2!F47=\"\",\"\",Assess2!F47)","v":""},{"$f":"IF(Assess2!G47=\"\",\"\",Assess2!G47)","v":""},{"$f":"Assess2!O47","v":""},{"$f":"Assess2!H47","v":""},{"$f":"IF(Assess2!I47=\"\",\"\",Assess2!I47)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B48=\"\",\"\",Assess!B48)","v":"NN"},{"$f":"IF(Assess!C48=\"\",\"\",Assess!C48)","v":""},{"$f":"IF(Assess!D48=\"\",\"\",Assess!D48)","v":""},{"$f":"IF(Assess!E48=\"\",\"\",Assess!E48)","v":""},{"$f":"IF(Assess!F48=\"\",\"\",Assess!F48)","v":""},{"$f":"IF(Assess!L48=\"\",\"\",IF(Assess!M48=\"\",\"\",SUM(Assess!L48:M48)))","v":""},{"$f":"IF(Assess!G48=\"\",\"\",Assess!G48)","v":""},{"$f":"IF(Assess!H48=\"\",\"\",Assess!H48)","v":""},{"$f":"IF(Assess!O48=\"\",\"\",Assess!O48)","v":""},{"$f":"IF(Assess!P48=\"\",\"\",Assess!P48)","v":""},{"$f":"IF(Assess2!F48=\"\",\"\",Assess2!F48)","v":""},{"$f":"IF(Assess2!G48=\"\",\"\",Assess2!G48)","v":""},{"$f":"Assess2!O48","v":""},{"$f":"Assess2!H48","v":""},{"$f":"IF(Assess2!I48=\"\",\"\",Assess2!I48)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B49=\"\",\"\",Assess!B49)","v":"OO"},{"$f":"IF(Assess!C49=\"\",\"\",Assess!C49)","v":""},{"$f":"IF(Assess!D49=\"\",\"\",Assess!D49)","v":""},{"$f":"IF(Assess!E49=\"\",\"\",Assess!E49)","v":""},{"$f":"IF(Assess!F49=\"\",\"\",Assess!F49)","v":""},{"$f":"IF(Assess!L49=\"\",\"\",IF(Assess!M49=\"\",\"\",SUM(Assess!L49:M49)))","v":""},{"$f":"IF(Assess!G49=\"\",\"\",Assess!G49)","v":""},{"$f":"IF(Assess!H49=\"\",\"\",Assess!H49)","v":""},{"$f":"IF(Assess!O49=\"\",\"\",Assess!O49)","v":""},{"$f":"IF(Assess!P49=\"\",\"\",Assess!P49)","v":""},{"$f":"IF(Assess2!F49=\"\",\"\",Assess2!F49)","v":""},{"$f":"IF(Assess2!G49=\"\",\"\",Assess2!G49)","v":""},{"$f":"Assess2!O49","v":""},{"$f":"Assess2!H49","v":""},{"$f":"IF(Assess2!I49=\"\",\"\",Assess2!I49)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B50=\"\",\"\",Assess!B50)","v":"PP"},{"$f":"IF(Assess!C50=\"\",\"\",Assess!C50)","v":""},{"$f":"IF(Assess!D50=\"\",\"\",Assess!D50)","v":""},{"$f":"IF(Assess!E50=\"\",\"\",Assess!E50)","v":""},{"$f":"IF(Assess!F50=\"\",\"\",Assess!F50)","v":""},{"$f":"IF(Assess!L50=\"\",\"\",IF(Assess!M50=\"\",\"\",SUM(Assess!L50:M50)))","v":""},{"$f":"IF(Assess!G50=\"\",\"\",Assess!G50)","v":""},{"$f":"IF(Assess!H50=\"\",\"\",Assess!H50)","v":""},{"$f":"IF(Assess!O50=\"\",\"\",Assess!O50)","v":""},{"$f":"IF(Assess!P50=\"\",\"\",Assess!P50)","v":""},{"$f":"IF(Assess2!F50=\"\",\"\",Assess2!F50)","v":""},{"$f":"IF(Assess2!G50=\"\",\"\",Assess2!G50)","v":""},{"$f":"Assess2!O50","v":""},{"$f":"Assess2!H50","v":""},{"$f":"IF(Assess2!I50=\"\",\"\",Assess2!I50)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B51=\"\",\"\",Assess!B51)","v":"QQ"},{"$f":"IF(Assess!C51=\"\",\"\",Assess!C51)","v":""},{"$f":"IF(Assess!D51=\"\",\"\",Assess!D51)","v":""},{"$f":"IF(Assess!E51=\"\",\"\",Assess!E51)","v":""},{"$f":"IF(Assess!F51=\"\",\"\",Assess!F51)","v":""},{"$f":"IF(Assess!L51=\"\",\"\",IF(Assess!M51=\"\",\"\",SUM(Assess!L51:M51)))","v":""},{"$f":"IF(Assess!G51=\"\",\"\",Assess!G51)","v":""},{"$f":"IF(Assess!H51=\"\",\"\",Assess!H51)","v":""},{"$f":"IF(Assess!O51=\"\",\"\",Assess!O51)","v":""},{"$f":"IF(Assess!P51=\"\",\"\",Assess!P51)","v":""},{"$f":"IF(Assess2!F51=\"\",\"\",Assess2!F51)","v":""},{"$f":"IF(Assess2!G51=\"\",\"\",Assess2!G51)","v":""},{"$f":"Assess2!O51","v":""},{"$f":"Assess2!H51","v":""},{"$f":"IF(Assess2!I51=\"\",\"\",Assess2!I51)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B52=\"\",\"\",Assess!B52)","v":"RR"},{"$f":"IF(Assess!C52=\"\",\"\",Assess!C52)","v":""},{"$f":"IF(Assess!D52=\"\",\"\",Assess!D52)","v":""},{"$f":"IF(Assess!E52=\"\",\"\",Assess!E52)","v":""},{"$f":"IF(Assess!F52=\"\",\"\",Assess!F52)","v":""},{"$f":"IF(Assess!L52=\"\",\"\",IF(Assess!M52=\"\",\"\",SUM(Assess!L52:M52)))","v":""},{"$f":"IF(Assess!G52=\"\",\"\",Assess!G52)","v":""},{"$f":"IF(Assess!H52=\"\",\"\",Assess!H52)","v":""},{"$f":"IF(Assess!O52=\"\",\"\",Assess!O52)","v":""},{"$f":"IF(Assess!P52=\"\",\"\",Assess!P52)","v":""},{"$f":"IF(Assess2!F52=\"\",\"\",Assess2!F52)","v":""},{"$f":"IF(Assess2!G52=\"\",\"\",Assess2!G52)","v":""},{"$f":"Assess2!O52","v":""},{"$f":"Assess2!H52","v":""},{"$f":"IF(Assess2!I52=\"\",\"\",Assess2!I52)","v":""}]
[{"$f":"IF(Intro!$N$5=\"\",\"\",Intro!$N$5)","v":"Ines Detomana"},{"$f":"IF(Intro!$N$10=\"\",\"\",VLOOKUP(Intro!$N$10,Lists!$A$1:$B$19,2,FALSE))","v":16},{"$f":"IF(Intro!$N$11=\"\",\"\",Intro!$N$11)","v":"UC Education Abroad Program"},{"$f":"IF(Intro!$N$6=\"\",\"\",Intro!$N$6)","v":""},{"$f":"IF(Intro!$N$7=\"\",\"\",Intro!$N$7)","v":""},{"$f":"IF(Intro!$N$8=\"\",\"\",Intro!$N$8)","v":""},{"$f":"IF(Intro!$N$9=\"\",\"\",Intro!$N$9)","v":""},{"$f":"IF(Intro!$N$12=\"\",\"\",Intro!$N$12)","v":""},{"$f":"IF(Assess!B53=\"\",\"\",Assess!B53)","v":"SS"},{"$f":"IF(Assess!C53=\"\",\"\",Assess!C53)","v":""},{"$f":"IF(Assess!D53=\"\",\"\",Assess!D53)","v":""},{"$f":"IF(Assess!E53=\"\",\"\",Assess!E53)","v":""},{"$f":"IF(Assess!F53=\"\",\"\",Assess!F53)","v":""},{"$f":"IF(Assess!L53=\"\",\"\",IF(Assess!M53=\"\",\"\",SUM(Assess!L53:M53)))","v":""},{"$f":"IF(Assess!G53=\"\",\"\",Assess!G53)","v":""},{"$f":"IF(Assess!H53=\"\",\"\",Assess!H53)","v":""},{"$f":"IF(Assess!O53=\"\",\"\",Assess!O53)","v":""},{"$f":"IF(Assess!P53=\"\",\"\",Assess!P53)","v":""},{"$f":"IF(Assess2!F53=\"\",\"\",Assess2!F53)","v":""},{"$f":"IF(Assess2!G53=\"\",\"\",Assess2!G53)","v":""},{"$f":"Assess2!O53","v":""},{"$f":"Assess2!H53","v":""},{"$f":"IF(Assess2!I53=\"\",\"\",Assess2!I53)","v":""}]