{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["1. Alnwick Base Budget","1) Instructions & Examples","2) Faculty-led Extension","3) Comprehensive Budget","Dropdowns"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Alnwick Base Budget","index":0,"n_rows":141,"n_cols":9,"rows_kept":141,"cut":false,"hidden":true,"merged":[[0,8,4,16],[14,8,16,14],[126,4,127,6],[129,2,129,6],[130,4,132,6],[39,3,39,6],[45,3,45,6],[65,3,65,6],[68,3,68,6],[71,3,71,6],[74,3,74,6],[2,2,2,6],[4,3,4,6],[5,3,5,6],[21,3,21,6],[27,3,27,6],[33,3,33,6],[134,2,134,6],[135,4,137,6],[77,3,77,6],[80,3,80,6],[83,3,83,6],[109,4,111,6],[117,4,119,6],[125,2,125,6]]}
[null,null,null,null,null,null,null,null,"Suggestion: keep everything in this spreadsheet. One option is keeping separate tabs. Second option, shortening the base program tab by tailoring even more to Alnwick and prefilling some fields, and adding the info from the extension program here. Either way, just by keeping everything in one spreadhseet it better."]
[]
[null,null,"Alnwick Program Budget"]
[]
[null,null,"Destination"]
[null,null,"Faculty Leader Names: ",null,null,null,null,null,"I will go to Jadyn to make any changes here though as she created this and she knows where all the formulas are. I dont want to mess with these"]
[null,null,"# of Faculty Leaders",null,"# of Students"]
[null,null,"Departure Date",null,"Return Date"]
[null,null,"Total Days",{"$f":"F8-D8","v":0}]
[null,null,"Fill in grey cells"]
[]
[]
[null,null,"Description of Costs",null,"Per-Faculty Expenses","Per-Student Expenses","Additional Expense",null,"Pre-fill this as much as possible. Mark differently if there are fields they need to input something (this would be needed if it's an expense that is not the same for everyone)"]
[null,null,"Travel Necessities (if applicable)",null,null,null,null,null,"Meals, lodging, transportation, and activities will be the same for everyone. Just provide that"]
[null,null,"Comprehensive Insurance (medical and/or travel)",null,null,null," ",null,"this area of travel necessities could be what differs the most. maybe add below by miscellaneous expenses, so that you are showing everything pre-filled first, and the personalized expenses."]
[null,null,"Passport Fees"]
[null,null,"Visa Fees"]
[null,null,"Immunizations",null,null,null,null,null,"Students: 51.72; Stacey: 68.96; Jay and Brennan paid 206.88"]
[null,null,"Global Phone Plan/SIM Card/Local Phone",null,null,null," "]
[null,null,"Subtotal of Travel Necessities",null,null,null,{"$f":"SUM(G15:G19)","v":0}]
[null,null,"Lodging/Accomodations",null,null,null,null,null,"Just show the total costs per student/faculty. they dont need to see these calculations if this is pre-filled"]
[null," ","Name of Hotel",null,null,null,null," ","Only two hotels are going to be part of this section: Alnwick Castle and YHA hostel"]
[null,null,"# of nights "," "," "," "," "," "]
[null," ","Cost of Faculty Room (per night)",null," "," "," "," "]
[null," ","# of Faculty per room"," "," "," "," "," "]
[null," ","Cost of Student Room (per night)"," "," "," "," "," "]
[null," ","# of Students per room"," ",{"$f":"IFERROR((D23*D24)/D25, 0)","v":0},{"$f":"IFERROR((D23*D26)/D27,0)","v":0}," "," "]
[null," ","Name of Hotel",null,null,null,null," "]
[null," ","# of nights "," "," "," "," "," "]
[null," ","Cost of Faculty Room (per night)"," "," "," "," "," "]
[null," ","# of Faculty per room"," "," "," "," "," "]
[null," ","Cost of Student Room (per night)"," "," "," "," "," "]
[null," ","# of Students per room"," ",{"$f":"IFERROR((D29*D30)/D31, 0)","v":0},{"$f":"IFERROR((D29*D32)/D33,0)","v":0}," "," "]
[null," ","Name of Hotel",null,null,null,null," "]
[null," ","# of nights ",null," "," "," "," "]
[null," ","Cost of Faculty Room (per night)",null," "," "," "," "]
[null," ","# of Faculty per room",null," "," "," "," "]
[null," ","Cost of Student Room (per night)",null," "," "," "," "]
[null," ","# of Students per room",null,{"$f":"IFERROR((D35*D36)/D37, 0)","v":0},{"$f":"IFERROR((D35*D38)/D39,0)","v":0}," "," "]
[null," ","Name of Hotel"," ",null,null,null," "]
[null," ","# of nights ",null," "," "," "," "]
[null," ","Cost of Faculty Room (per night)",null," "," "," "," "]
[null," ","# of Faculty per room",null," "," "," "," "]
[null," ","Cost of Student Room (per night)",null," "," "," "," "]
[null," ","# of Students per room",null,{"$f":"IFERROR((D41*D42)/D43, 0)","v":0},{"$f":"IFERROR((D41*D44)/D45,0)","v":0}," "," "]
[null," ","Name of Hotel",null,null,null,null," "]
[null," ","# of nights ",null," "," "," "," "]
[null," ","Cost of Faculty Room (per night)",null," "," "," "," "]
[null," ","# of Faculty per room",null," "," "," "," "]
[null," ","Cost of Student Room (per night)",null," "," "," "," "]
[null," ","# of Students per room",null,{"$f":"IFERROR((D47*D48)/D49, 0)","v":0},{"$f":"IFERROR((D47*D50)/D51,0)","v":0}," "," "]
[null,null,"Subtotal of Lodging/Accomodations",null,{"$f":"E27+E33+E39+E45+E51","v":0},{"$f":"F27+F33+F39+F45+F51","v":0}]
[null,null,"Meals"]
[null,null,"Group meals (to be included in program package)"]
[null,null,"# of meals"]
[null,null,"estimated cost per meal per person",null,{"$f":"D55*D56","v":0},{"$f":"D55*D56","v":0}]
[null,null,"Individual Meals (responsibility of individual to pay during program)"]
[null,null,"# of meals"]
[null,null,"estimated cost per meal",null,null,null,{"$f":"D58*D59","v":0}]
[null,null,"Transportation"]
[null,null,"Roundtrip Airfare from US gateway",null,null,null,null,null,"this could be more tailored to Alnwick"]
[null,null,"Transportation to US gateway",null,null,null," ",null,"they will enter their airfare"]
[null,null,"Transportation during program (host country)",null,{"$f":"SUM(D61:D63)","v":0},{"$f":"SUM(D61:D63)","v":0}]
[null,null,"Activities/Tours (only list ones with cost)"]
[null,null,"(if not using group rate, enter 0) "]
[null," ","Name of activity",null,null,null,null," "]
[null," ","Single Rate",null,{"$f":"IF(ISBLANK(D67),0,D67)","v":0},{"$f":"IF(ISBLANK(D67),0,D67)","v":0}," "," ","alnwick 195 for faculty"]
[null,null,"Group Rate",null,{"$f":"IF(ISBLANK(D68),0,(D68/($D$7+$F$7)))","v":0},{"$f":"IF(ISBLANK(D68),0,(D68/($D$7+$F$7)))","v":0}]
[null," ","Name of activity",null,null,null,null," "]
[null," ","Single Rate",null,{"$f":"IF(ISBLANK(D70),0,D70)","v":0},{"$f":"IF(ISBLANK(D70),0,D70)","v":0}," "," "]
[null,null,"Group Rate",null,{"$f":"IF(ISBLANK(D71),0,(D71/($D$7+$F$7)))","v":0},{"$f":"IF(ISBLANK(D71),0,(D71/($D$7+$F$7)))","v":0}]
[null," ","Name of activity",null,null,null,null," "]
[null," ","Single Rate",null,{"$f":"IF(ISBLANK(D73),0,D73)","v":0},{"$f":"IF(ISBLANK(D73),0,D73)","v":0}," "," "]
[null,null,"Group Rate",null,{"$f":"IF(ISBLANK(D74),0,(D74/($D$7+$F$7)))","v":0},{"$f":"IF(ISBLANK(D74),0,(D74/($D$7+$F$7)))","v":0}]
[null," ","Name of activity",null,null,null,null," "]
[null," ","Single Rate",null,{"$f":"IF(ISBLANK(D76),0,D76)","v":0},{"$f":"IF(ISBLANK(D76),0,D76)","v":0}," "," "]
[null,null,"Group Rate",null,{"$f":"IF(ISBLANK(D77),0,(D77/($D$7+$F$7)))","v":0},{"$f":"IF(ISBLANK(D77),0,(D77/($D$7+$F$7)))","v":0}]
[null," ","Name of activity",null,null,null,null," "]
[null," ","Single Rate",null,{"$f":"IF(ISBLANK(D79),0,D79)","v":0},{"$f":"IF(ISBLANK(D79),0,D79)","v":0}," "," "]
[null,null,"Group Rate",null,{"$f":"IF(ISBLANK(D80),0,(D80/($D$7+$F$7)))","v":0},{"$f":"IF(ISBLANK(D80),0,(D80/($D$7+$F$7)))","v":0}]
[null," ","Name of activity",null,null,null,null," "]
[null," ","Single Rate",null,{"$f":"IF(ISBLANK(D82),0,D82)","v":0},{"$f":"IF(ISBLANK(D82),0,D82)","v":0}," "," "]
[null,null,"Group Rate",null,{"$f":"IF(ISBLANK(D83),0,(D83/($D$7+$F$7)))","v":0},{"$f":"IF(ISBLANK(D83),0,(D83/($D$7+$F$7)))","v":0}]
[null," ","Name of activity",null,null,null,null," "]
[null," ","Single Rate",null,{"$f":"IF(ISBLANK(D85),0,D85)","v":0},{"$f":"IF(ISBLANK(D85),0,D85)","v":0}," "," "]
[null,null,"Group Rate",null,{"$f":"IF(ISBLANK(D86),0,(D86/($D$7+$F$7)))","v":0},{"$f":"IF(ISBLANK(D86),0,(D86/($D$7+$F$7)))","v":0}]
[null,null,"Subtotal of Activities/Tours",null,{"$f":"E67+E68+E70+E71+E73+E74+E76+E77+E79+E80+E82+E83+E85+E86","v":0},{"$f":"F67+F68+F70+F71+F73+F74+F76+F77+F79+F80+F82+F83+F85+F86","v":0}]
[null,null,"Other Miscellaneous Expenses (If applicable)"]
[null,null,"Incidentals (Internet, Laundry, etc.)",null,null,null,null,null,"The travel necessities from above could come with closer to this section"]
[null,null,"Gifts/Gratuities"]
[null,null,"Personal Expenses"]
[null,null,"Other"]
[null,null,"Sub-total of Miscellaneous Expenses",null,{"$f":"SUM(D89:D92)","v":0},{"$f":"SUM(D89:D92)","v":0},{"$f":"SUM(G89:G92)","v":0}]
[null,null,"Subtotal of Program Costs",null,{"$f":"SUM(E20,E52,E56,E63,E87,E93)","v":0},{"$f":"SUM(F20,F52,F56,F63,F87,F93)","v":0},{"$f":"SUM(G20,G52,G59,G62,G87,G93)","v":0}]
[null,null,"Financial Assistance"]
[null,null,"College scholarship for each student",null,null,{"$f":"-D96","v":0},null,null,"just see what truly applies to this trip"]
[null,null,"Department scholarship for each student",null,null,{"$f":"-D97","v":0},null,null,"remove this"]
[null,null,"College financial assistance for faculty leader",null,{"$f":"-D98","v":0}]
[null,null,"Department financial assistance for faculty leader",null,{"$f":"-D99","v":0}]
[null,null,"College financial assistance for faculty co-leader",null,{"$f":"IF(D100=\"\",\"0\",-D100)","v":"0"}]
[null,null,"Department financial assistance for faculty co-leader",null,{"$f":"IF(D101=\"\",\"0\",-D101)","v":"0"}]
[null,null,"Subtotal of Financial Assistance (includes both leaders)",null,{"$f":"SUM(E26,E58,E62,E92,E96:E101)","v":0},{"$f":"SUM(F26,F58,F62,F92,F96:F101)","v":0}]
[null,null,"Total Program Cost (Student)",null,null,{"$f":"F94+F102","v":0},{"$f":"G94","v":0}]
[null,null,"Total Program Cost (Faculty Leader)",null,{"$f":"E94+(E98+E99)","v":0}]
[null,null,"Total Program Cost (Co-Faculty Leader)",null,{"$f":"E94+E100+E101","v":0}]
[null,null,"Estimated total cost of program (including personal expenses) ",null,{"$f":"MAX(E104:E105)+G103","v":0},{"$f":"F103+G103","v":0}]
[]
[]
[null,null,"Undergraduate Tuition Calculation"]
[null,null,"Online or In-person Course (Drop Down)","In-Person","Based on current semester in-state tuition and fees rate\nhttps://www.fhsu.edu/sfs/students_parents/tuition/",null,null,null,"make sure this all related to Alnwick"]
[null,null,"Undergraduate Tuition (per credit)",null,null,null,null,null,"maybe none of these is needed"]
[null,null,"Undergraduate Online Tuition (per credit)"]
[null,null,"Course Credit Hours",null,null,{"$f":"(D111*D113)+D114","v":0}]
[null,null,"Textbooks for UG",null,null,{"$f":"(D113*D112)+D114","v":0}]
[null,null,"Total Undergraduate Tution and Fees",{"$f":"IF(D110=\"In-Person\",F113,F114)","v":0}]
[]
[null,null,"Graduate Tuition Calculation"]
[null,null,"Online or In-person Course (Drop Down)","Online","Based on current semester in-state tuition and fees rate\nhttps://www.fhsu.edu/sfs/students_parents/tuition/"]
[null,null,"Graduate Tuition Rate (per credit)"]
[null,null,"Graduate Online Tuition Rate (per credit)"]
[null,null,"Course Credit Hours",null,null,{"$f":"(D119*D121)+D122","v":0}]
[null,null,"Textbooks for GR",null,null,{"$f":"(D120*D121)+D122","v":0}]
[null,null,"Total Graduate Tuition and Fees",{"$f":"IF(D118=\"In-Person\",F121,F122)","v":0}]
[]
[]
[null,null,"Estimated Total cost of Experience Per Person"]
[null,null,"Undergraduate",{"$f":"D115+F106","v":0},"** Includes program cost, additional expense, and tuition"]
[null,null,"Graduate",{"$f":"D123+F106","v":0}]
[]
[null,null,"Estimated Total Program Cost",null,null,null,null,null,"maybe not all the totals are needed. what is truly needed?I think just the first box."]
[null,null,"Total Faculty Portion",{"$f":"E104+E105","v":0},"** Does not include tuition\n** Does not include additional expense"]
[null,null,"Total Student Portion",{"$f":"(F7*F103)","v":0}]
[null,null,"Total Cost of Program",{"$f":"D132+D131","v":0}]
[]
[null,null,"Estimated Total Program Cost"]
[null,null,"Total Faculty Portion",{"$f":"(E104+E105)","v":0},"**Includes tuition\n** Does not include additional expense"]
[null,null,"Total Student Portion",{"$f":"(F103 + IF(OR(ISBLANK(D115), D115 = 0), D123, D115))*F7","v":0}]
[null,null,"Total Cost of Program",{"$f":"D137+D136","v":0}]
[null,null,"DO NOT DELETE"]
[null,null,"Online"]
[null,null,"In-Person"]

{"sheet":"1) Instructions & Examples","index":1,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[11,3,13,16],[9,3,10,16],[2,2,3,18]]}
[]
[null,null,"Instructions & Examples on How to Use this Spreadsheet"]
[null,null,"Important: Open this spreadsheet in the desktop version of Excel, not in a browser or online version, to ensure all dropdowns, formulas, and formatting work correctly.\nChoose \"Enable Content\" and then \"trust\" when prompted."]
[]
[null,null,"Color-coding:",null,"grey cells","indicate that your input is required"]
[null,null,null,null,"blue cells","no input allowed; these are pre-filled with values or formulas"]
[null,null,"Overview of Spreadsheet Structure"]
[null,null,"There are three tabs in this Excel Workbook."]
[null,null,null,"Tab 1: Instructions & Examples (this tab)"]
[null,null,null,"Tab 2: Faculty-led Extension: this tab must be completely filled out by the faculty member proposing to lead an extension program. Cost totals are auto-calculated at the end and will carry over into the Comprehensive Budget tab."]
[]
[null,null,null,"Tab 3: Comprehensive Budget: this tab contains the Alnwick base program budget and helps you understand which items are included and not included in the pre-paid program fee. Values entered in Tab 2 for the Faculty-led Customized Extension Program will also carry over automatically to this tab for the applicable sections so that you can see total costs."]
[]
[]
[]
[null,null,"Example for Faculty-led Extension; Section 2.1 Itinerary Overview"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Each cell will auto-adjust to the length of text you type:"]
[null,null,null,"Column 2: Venue/Activity Name"]
[null,null,null,"If you plan more than one activity per time block, include them in the same cell and combine costs if possible. You can leave additional comments for clarification if needed."]
[]
[null,null,null,"Column 4: Payment Type - Wording Clarification"]
[null,null,null,"Included in program fee – Cost is prepaid and built into the total program price for all participants."]
[null,null,null,"Paid separately – Cost varies by participant and is paid individually (either before departure or on-site)."]

{"sheet":"2) Faculty-led Extension","index":2,"n_rows":94,"n_cols":9,"rows_kept":94,"cut":false,"hidden":false,"merged":[[47,7,47,8],[19,2,19,3],[54,7,54,8],[55,7,55,8],[49,3,49,4],[49,7,49,8],[50,3,50,4],[50,7,50,8],[51,3,51,4],[51,7,51,8],[54,3,54,4],[55,3,55,4],[84,5,91,8],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[20,2,20,3],[21,2,21,3],[26,5,26,6],[59,7,59,8],[60,3,60,4],[60,7,60,8],[58,3,58,4],[61,3,61,4],[67,7,67,8],[70,3,70,4],[70,7,70,8],[65,3,65,4],[66,3,66,4],[64,3,64,4],[61,7,61,8],[62,3,62,4],[62,7,62,8],[63,3,63,4],[2,2,2,8],[12,2,12,8],[67,3,67,4],[29,2,29,6],[41,3,41,4],[42,3,42,4],[43,3,43,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[31,2,31,8],[48,3,48,4],[48,7,48,8],[53,3,53,4],[18,2,18,8],[46,3,46,4],[46,7,46,8],[47,3,47,4],[58,7,58,8],[59,3,59,4],[64,7,64,8],[65,7,65,8],[14,2,14,8],[15,2,16,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[35,7,35,8],[34,7,34,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[52,3,52,4],[52,7,52,8],[53,7,53,8],[66,7,66,8],[9,3,9,5],[63,7,63,8],[3,2,8,8],[77,7,77,8],[78,7,78,8],[79,7,79,8],[83,5,83,8],[82,2,82,8],[74,3,74,4],[74,7,74,8],[75,3,75,4],[75,7,75,8],[76,3,76,4],[76,7,76,8],[77,3,77,4],[78,3,78,4],[79,3,79,4],[71,3,71,4],[71,7,71,8],[72,3,72,4],[72,7,72,8],[73,3,73,4],[73,7,73,8]]}
[]
[]
[null,null,"Faculty-led Customized Program Extension"]
[null,null,"The optional customized extension will begin on Day 12. Faculty leaders are responsible for coordinating all logistics and facilitating 1–4 days of travel with their student cohort. Global Affairs staff will not accompany faculty during the extension period. At the conclusion of the program, faculty must assist students with their return travel to the United States, including ensuring safe departure from the United Kingdom.\nPlease complete the grey cells with accurate, non-hypothetical information. While we understand that some details may change as arrangements are finalized, all information provided must be confirmed and will be used for administrative approval and risk assessment purposes."]
[]
[]
[]
[]
[]
[null,null,"Faculty Leader Name: ",null,null,null,"Total Days"]
[null,null,"Start Date:","2027-06-16","End Date:",null,{"$f":"IF(F11<>\"\", F11-D11, \"\")","v":""}]
[]
[null,null,"SECTION 1: GENERAL OVERVIEW"]
[]
[null,null,"1.1: Describe how the pre-trip coursework connects to the academic experience during the program extension: "]
[]
[]
[]
[null,null,"1.2: List locations to be visited and considerations of each one:"]
[null,null,"Cities/Towns, Countries",null,"Dates at each location","Potential Risks \n(geopolitical, environmental, health, safety)",null,"Cultural Considerations\n(etiquette, protocols, expectations, etc.)","On-site Partners\n(academic institutions, local organizations, industry stakeholders, etc.)"]
[null,null,"Example: Hays, KS, USA",null,"June 10-June 14","Tornado season, seasonal allergies (bring necessary medication), heat",null,"Friendly, tipping customary (18%), taxes not included in listed price","Hays Convention & Visitors Bureau"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"SECTION 2: ITINERARY OVERVIEW"]
[]
[null,null,"2.1: Provide details for each day of the extension program:"]
[]
[null,null,"DAY 1",null,null,null,"Choose from dropdown"]
[null,null,"Time Block","Venue/Activity Name",null,"Estimated USD Cost (Per Person)","Payment Type","Additional Comments"]
[null,null,"Breakfast"]
[null,null,"Morning"]
[null,null,"Lunch"]
[null,null,"Afternoon"]
[null,null,"Dinner"]
[null,null,"Evening"]
[null,null,"Lodging Name"]
[null,null,"Local Transportation (bus, uber, train, etc.)"]
[null,null,"Airfare","from/to"]
[]
[null,null,"DAY 2",null,null,null,"Choose from dropdown"]
[null,null,"Time Block","Venue/Activity Name",null,"Estimated USD Cost (Per Person)","Payment Type","Additional Comments"]
[null,null,"Breakfast"]
[null,null,"Morning"]
[null,null,"Lunch"]
[null,null,"Afternoon"]
[null,null,"Dinner"]
[null,null,"Evening"]
[null,null,"Lodging Name"]
[null,null,"Local Transportation (bus, uber, train, etc.)"]
[null,null,"Airfare","from/to"]
[]
[null,null,"DAY 3",null,null,null,"Choose from dropdown"]
[null,null,"Time Block","Venue/Activity Name",null,"Estimated USD Cost (Per Person)","Payment Type","Additional Comments"]
[null,null,"Breakfast"]
[null,null,"Morning"]
[null,null,"Lunch"]
[null,null,"Afternoon"]
[null,null,"Dinner"]
[null,null,"Evening"]
[null,null,"Lodging Name"]
[null,null,"Local Transportation (bus, uber, train, etc.)"]
[null,null,"Airfare","from/to"]
[]
[null,null,"DAY 4",null,null,null,"Choose from dropdown"]
[null,null,"Time Block","Venue/Activity Name",null,"Estimated USD Cost (Per Person)","Payment Type","Additional Comments"]
[null,null,"Breakfast"]
[null,null,"Morning"]
[null,null,"Lunch"]
[null,null,"Afternoon"]
[null,null,"Dinner"]
[null,null,"Evening"]
[null,null,"Lodging Name"]
[null,null,"Local Transportation (bus, uber, train, etc.)"]
[null,null,"Airfare","from/to"]
[]
[]
[null,null,"2.2: Customized Extension Cost Summary (per person)"]
[null,null,"Description","Included In Program Fee\n(Prepaid)","Not Included\n(Paid separately by participants)","Additional Comments"]
[null,null,"Airfare",{"$f":"SUMIFS($F$33:$F$80, $G$33:$G$80, \"Included in program fee\", $C$33:$C$80, \"Airfare\")","v":0},{"$f":"SUMIFS($F$33:$F$80, $G$33:$G$80, \"Paid separately\", $C$33:$C$80, \"Airfare\")","v":0}]
[null,null,"UK Local Transportation",{"$f":"SUMIFS($F$33:$F$80, $G$33:$G$80, \"Included in program fee\", $C$33:$C$80, \"Local Transportation (bus, uber, train, etc.)\")","v":0},{"$f":"SUMIFS($F$33:$F$80, $G$33:$G$80, \"Paid separately\", $C$33:$C$80, \"Local Transportation (bus, uber, train, etc.)\")","v":0}]
[null,null,"Tours & activities",{"$f":"SUM(SUMIFS($F$33:$F$80, $G$33:$G$80, \"Included in program fee\", $C$33:$C$80, {\"Morning\",\"Afternoon\",\"Evening\"}))","v":0},{"$f":"SUM(SUMIFS($F$33:$F$80, $G$33:$G$80, \"Paid separately\", $C$33:$C$80, {\"Morning\",\"Afternoon\",\"Evening\"}))","v":0}]
[null,null,"Meals",{"$f":"SUM(SUMIFS($F$33:$F$80,$G$33:$G$80, \"Included in program fee\",$C$33:$C$80, {\"Breakfast\",\"Lunch\",\"Dinner\"}))","v":0},{"$f":"SUM(SUMIFS($F$35:$F$80,$G$35:$G$80, \"Paid separately\",$C$35:$C$80, {\"Breakfast\",\"Lunch\",\"Dinner\"}))","v":0}]
[null,null,"Lodging",{"$f":"SUMIFS($F$33:$F$80, $G$33:$G$80, \"Included in program fee\", $C$33:$C$80, \"Lodging Name\")","v":0},{"$f":"SUMIFS($F$33:$F$80, $G$33:$G$80, \"Paid separately\", $C$33:$C$80, \"Lodging Name\")","v":0}]
[null,null,"Other (specify)"]
[null,null,"Other (specify)"]
[null,null,"Other (specify)"]
[]
[null,null,"Total Cost (per person)",{"$f":"SUM(D85:D91)","v":0},{"$f":"SUM(E85:E91)","v":0}]

{"sheet":"3) Comprehensive Budget","index":3,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,10,9,22],[2,2,2,8],[21,4,28,8],[7,4,17,8],[6,2,6,8],[20,2,20,8],[4,2,4,8]]}
[]
[]
[null,null,"COMPREHENSIVE BUDGET"]
[]
[null,null,"The values shown below are estimated and tentative until arrangements are finalized. "]
[]
[null,null,"Included in Package Fee"]
[null,null,"Alnwick Base Program",null,"Includes all shared, group costs: \n- Lodging (Alnwick Castle, YHA Hostel at York)\n- Some activities and tours\n- Private coach transfer from Airport to Alnwick Castle\n-24/7 risk management support\n\nNotes:\n-This budget does not include faculty leader lodging upgrades.\n-Global Affairs will work with each department to ensure full understanding of collecting payments."]
[null,null,"Alnwick, England: June 6-13"]
[null,null,"York, England: June 14-15"]
[]
[null,null,"Total Cost (per person)",1200]
[]
[null,null,"Faculty-led Customized Extension Program"]
[null,null,"Total days:",{"$f":"'2) Faculty-led Extension'!G11","v":""}]
[null,null,"Total Cost (per person)",{"$f":"'2) Faculty-led Extension'!D94","v":0}]
[]
[null,null,"Base + Extension",{"$f":"D12+D16","v":1200}]
[]
[]
[null,null,"Not Included in Package Fee (Estimations)"]
[null,null,"Airfare",{"$f":"1500+'2) Faculty-led Extension'!E85","v":1500},"These costs are not included in the program package, as they vary based on individual preferences and circumstances. These estimates are for reference only, and each traveler is responsible for their actual out-of-pocket expenses."]
[null,null,"Mandatory Intl Health Insurance",40]
[null,null,"UK Local Transportation",{"$f":"150+'2) Faculty-led Extension'!E86","v":150}]
[null,null,"Independent Tours and Activities",{"$f":"200+'2) Faculty-led Extension'!E87","v":200}]
[null,null,"Meals",{"$f":"400+'2) Faculty-led Extension'!E88","v":400}]
[null,null,"Other",{"$f":"SUM('2) Faculty-led Extension'!E90,'2) Faculty-led Extension'!E91)","v":0}]
[]
[null,null,"Base + Extension",{"$f":"SUM(D22:D27)","v":2290}]

{"sheet":"Dropdowns","index":4,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Payment Type"]
["Included in program fee"]
["Paid separately"]