{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Contents","Introduction","Cost of Attendance","Checklist","Basis of Costs","Visa Letter (Office Use Only)","late start letter","School DATA (Office Use Only)","Pvt L. Letter (Office Use Only)","late start Cost of Attendance"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":6,"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":"Contents","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Introduction","index":1,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Cost of Attendance - How to use this spreadsheet"]
[]
["This spreadsheet is to help you and us"]
["a. To make the process as speedy and as simple as possible"]
["b. To cut out the risk of your application being rejected and you having to start again"]
[]
["There is nothing which tells The Courtauld that everything the applicant needs to do has been completed."]
["There is nothing which tells the applicant that everything they need to do has been completed."]
["Information sent by the US Dept of Ed to schools also includes all those who may not apply or enroll."]
["There are sets of documents which we have to receive before we can even start to certify or complete your loans"]
[]
["You must complete and send us the spreadsheet \"Cost of Attendance\" tab"]
[]
["It is used to help you and the school in several ways"]
["1. you tell us what we need to know about you before we can start to process your application (Section 1)"]
["2. you can re-calculate your costs (Sections 2 & 3) and if needed you can change our values shown in blue"]
["3. it calculates how much you need and are eligible to borrow (Section 4)"]
["4. it tells you whether the school will accept the costs you have proposed (Section 5)"]
["5. It tells you how much of your loan will be retained by the government as origination fee"]
["6. It calculates the cost of the originations fees and increases the PLUS loan to cover them"]
["6. you tell us how much you want to borrow (Section 6) You adjust the figures shown in blue"]
[]
["You must also complete the Checklist"]
["The checklist helps you ensure that everything needed has been completed for us to process your application; without it nothing can be processed"]
["The checklist will tell you the consequence of anything missing"]
["If anything is missing or incomplete, your application will be rejected."]
[]
["For your information …"]
["The Basis of Costs tab shows you how we calculated the Cost of Attendance"]
["To ensure that your application is as smooth as possible, you must complete the Cost of Attendance spreadsheet and the checklist"]
[]
["When we will receive this spreadsheet - and ALL the required attachments - that is our trigger that you have done everything for us to start on your loan"]
["If anything on the checklist is missing we will not be able to start to process your application"]
["It  will not be the school's decision to reject your application or to process your loan with things missing"]
["If anything on the checklist or spreadsheet is missing or untrue your application will be rejected by the ED Dept's systems"]

{"sheet":"Cost of Attendance","index":2,"n_rows":98,"n_cols":15,"rows_kept":98,"cut":false,"hidden":false,"merged":[[72,2,72,3]]}
[]
[null,null,"Cost of Attendance",null,"v.180215"]
[null,null,"& Loan Calculation"]
[null,null,{"$f":"\"for Academic Year \"& 'School DATA (Office Use Only)'!D6","v":"for Academic Year 2021/22"},null,"uncle","p/w hint"]
[null,null,"RETAIL (Main Street) RATE - NOT INTERBANK RATE",null,null,null,null,{"$f":"'School DATA (Office Use Only)'!H48","v":97966},"Max CoA before Interview"]
[null,null,"This form and exchange rates revised",null,"2018-06-15",null,null,{"$f":"'School DATA (Office Use Only)'!H50","v":102108.00248},"Max Loan after grossing up for Fees adjustments"]
[null,null,"Worst possible rate for Retail US Dollar Rate - best guess",{"$f":"IF(('School DATA (Office Use Only)'!I44>0),'School DATA (Office Use Only)'!I44,'School DATA (Office Use Only)'!H44)","v":1.4},{"$f":"'School DATA (Office Use Only)'!I29","v":"2021-05-27"}]
[null,null,"Next review date for Exchange Rate",null,{"$f":"'School DATA (Office Use Only)'!I30","v":"2021-12-01"},null,"Depend","Choice","Year"]
[null,null,"No of Weeks for Undergraduates",{"$f":"'School DATA (Office Use Only)'!E11","v":41},null,null,"I","N",1]
[null,null,"No of Weeks for Postrgraduates",{"$f":"'School DATA (Office Use Only)'!E13","v":52},null,null,"D","Y",2]
[null,null,null,null,null,null,null,null,"3 or above",null,null,null,"ONLY ENTER DATES"]
[1,null,"COMPLETE THE YELLOW BOXES ONLY",null,null,null,"Private Loan","STANDING DATA","Loan Dates",null,null,"DISBURSEMENTS","Disburse Dates","VALUES ARE AUTOMATIC"]
[null,null,null,null,null,null,"Government Loan","Undergrads","Start",{"$f":"'School DATA (Office Use Only)'!D7","v":"2021-09-27"},null,{"$f":"COUNT(M13:M19)","v":3},{"$f":"IF(('School DATA (Office Use Only)'!D18>10/10/2010),'School DATA (Office Use Only)'!D18,\"\")","v":"2021-09-27"},{"$f":"ROUND((IF((ISNUMBER(M13)),(D90/L13),\"\")),0)","v":{"$error":"#VALUE!"}}]
["Family Name (Surname)",null,"surname",null,null,null,null,null,"End",{"$f":"'School DATA (Office Use Only)'!D11","v":"2022-07-12"},null,"put 2nd date",{"$f":"IF(('School DATA (Office Use Only)'!D19>10/10/2010),'School DATA (Office Use Only)'!D19,\"\")","v":"2022-01-10"},{"$f":"ROUND((IF((ISNUMBER(M14)),(D90/L13),\"\")),0)","v":{"$error":"#VALUE!"}}]
["Given Name (Forename)",null,"forename",null,null,null,null,"Postgrads","Start",{"$f":"'School DATA (Office Use Only)'!D7","v":"2021-09-27"},null,"put 3rd date or blank",{"$f":"IF(('School DATA (Office Use Only)'!D20>10/10/2010),'School DATA (Office Use Only)'!D20,\"\")","v":"2022-04-20"},{"$f":"ROUND((IF((ISNUMBER(M15)),(D90/L13),\"\")),0)","v":{"$error":"#VALUE!"}}]
["Address Line 1",null,"line 1",null,null,null,null,null,"End",{"$f":"'School DATA (Office Use Only)'!E7","v":"2022-09-26"},null,"put 4th date or blank",{"$f":"IF(('School DATA (Office Use Only)'!D21>10/10/2010),'School DATA (Office Use Only)'!D21,\"\")","v":""},{"$f":"IF((ISNUMBER(M16)),(ROUND((D90/L13),0)),\"\")","v":""}]
["Address Line 2",null,"line 2",null,null,null,"sub entitled, conditions are per cell",null,null,null,null,null,null,{"$f":"SUM(N13:N16)","v":{"$error":"#VALUE!"}}]
["Address Line 3",null,"line 3",null,null,null,"inc BA, UG/PG, porev degree,yr"]
["Address Line 4",null,"line 4",null,null,null,"but not dependency"]
["Zipcode / Postcode",null,"postcode/zipcode",null,null,null,"tot below is max"]
["Email",null,"email address",null,null,null,"MAXIMUM LOAN LEVELS FOR THIS STU","MAXIMUM LOAN LEVELS FOR THIS STU","MAX THIS STU",null,"MAXIMUM LOAN LEVELS AVAILABLE"]
["Date of Birth dd/mm/yyyy",null,"dd/mm/yyyy",null,null,null,"Sub","Unsub Depend","Unsub Ind",null,"Sub","Unsub Depend","Unsub Ind"]
["Full Social Security Number",null,"Full Social Security Number",null,null,null,{"$f":"IF(D30=\"Y\",0,K23)","v":0},{"$f":"IF((D30=\"N\"),K23,0)","v":0},{"$f":"IF((D30=\"N\"),M23,0)","v":20500},"postgraduates",0,0,20500]
["Application/Student Number",null,"Application/Student Number",null,null,null,{"$f":"IF((AND(D30=\"Y\",D31=\"N\",D33=1)),K24,0)","v":0},{"$f":"IF((AND(D30=\"Y\",D34=\"D\",D33=1)),L24,0)","v":0},{"$f":"IF((AND(D30=\"Y\",D34=\"I\",D33=1)),M24,0)","v":0},"Undergraduate1",3500,2000,6000]
["Full name of your course",null,"Course Name",null,null,null,{"$f":"IF((AND(D30=\"Y\",D31=\"N\",D33=2)),K25,0)","v":0},{"$f":"IF((AND(D30=\"Y\",D34=\"D\",D33=2)),L25,0)","v":0},{"$f":"IF((AND(D30=\"Y\",D34=\"I\",D33=2)),M25,0)","v":0},"Undergraduate2",4500,2000,6000]
["Then answer these",null,null,null,null,null,{"$f":"IF((AND(D30=\"Y\",D31=\"N\",D33>2)),K26,0)","v":0},{"$f":"IF((AND(D30=\"Y\",D34=\"D\",D33>2)),L26,0)","v":0},{"$f":"IF((AND(D30=\"Y\",D34=\"I\",D33>2)),M26,0)","v":0},"Undergraduate>2",5500,2000,7000]
[null,{"$f":"IF((D27=\"Y\"),1,0)","v":0},"Does your course - whole course, in any year - have any time in USA other than vacations? Only answer Y or N","N",{"$f":"IF((D27=\"Y\"),\"PRIVATE LOANS ONLY\",\"\")","v":""},null,{"$f":"IF((AND(D30=\"Y\", D31=\"Y\", D32=\"Y\")),K27,0)","v":0},{"$f":"IF((AND(D30=\"Y\",D31=\"Y\",D32=\"Y\")),I27,0)","v":0},{"$f":"IF((AND(D30=\"Y\", D31=\"Y\", D32=\"Y\")),M27,0)","v":0},"Law",{"$f":"K23","v":0},{"$f":"L23","v":0},{"$f":"M23","v":20500}]
[null,null,"Does your course involve any time at another university or school, or campus? Only answer Y or N","N",{"$f":"IF((D28=\"Y\"),\"For school codes - click below\",\"\")","v":""},null,{"$f":"MAX(G23:G27)","v":0},null,{"$f":"MAX(H23:I27)","v":20500},"Max Loan Available",null,"From July 2012 there is no Subsidised Loan for postgraduates"]
[null,{"$f":"IF((D29=\"N\"),1,0)","v":0},{"$f":"IF((D28=\"Y\"),\"Is that school in the List of federal School Codes at the website link now showing in red box\",\"do not adjust this line\")","v":"do not adjust this line"},"Y",{"$f":"IF((D28=\"Y\"),\"https://fafsa.ed.gov/FAFSA/app/schoolSearch?locale=en_EN\",\"\")","v":""}]
[null,null,"Is this course for a Bachelor degree such as BSc or BA? Only answer Y or N","N",{"$f":"IF((D29=\"n\"), \"PRIVATE LOANS ONLY\",\"\")","v":""},null,null,"CONVERTING FEES AND CONTRIBUTIONS TO DOLLARS",null,null,null,"Undergrad Courses which could get Postgrad funding"]
[null,null,{"$f":"IF(D30=\"N\", \"Do not adjust this line\", \"Are you taking an undergraduate course but at graduate/professional level? Only answer Y or N\")","v":"Do not adjust this line"},"N",null,null,"Rate","Convert £ ","Already $","Actual Loans",null,"Law"]
[null,null,{"$f":"IF((AND( D30=\"Y\", D31=\"Y\")), \"Do you already have another undergraduate degree - answer Y or N\", \"Do not adjust this line\" )","v":"Do not adjust this line"},"N",null,null,{"$f":"D7","v":1.4},{"$f":"D36*G32","v":0},{"$f":"E36","v":0},"Fees"]
[null,null,"What will be your year of study - select from the dropbox only - WARNING: this must match your FAFSA & SAR",1,null,null,{"$f":"G32","v":1.4},{"$f":"D37*G33","v":0},{"$f":"E37","v":0},"Sponsors"]
[null,null,"What does your SAR say for \"dependancy status\" Only answer I or D","D",null,null,{"$f":"G33","v":1.4},{"$f":"D38*G34","v":0},{"$f":"E38","v":0},"School Aid"]
[null,null,"What is you EFC (top right of front page of SAR) Even zero must be entered",0,null,null,{"$f":"G34","v":1.4},{"$f":"D39*G35","v":0},{"$f":"E39","v":0},"Other Aid £UK"]
[null,null,"Enter the Tuition Fees - only write the figures - don't type in the £ sign as it is already formatted",0,null,null,{"$f":"G34","v":1.4},{"$f":"D40*G36","v":0},{"$f":"E40","v":0},"Other Aid $USA"]
[null,null,"How much of the tuition fees will be paid to your school by a sponsor (only enter in the $ or £ box - not both)",0,0,null,null,null,{"$f":"SUM(H33:I36)","v":0},"Deduct from \"Need\""]
[null,null,"How much has already been awarded by this school as a Scholarship or Financial Aid",0]
[null,null,"How much has been awarded by any other Scholarship or Financial Aid in the UK",0,null,null,null,"CONVERTING WEEKLY COSTS TO DOLLARS"]
["Calcs above/beside",null,"How much has been awarded by any other Scholarship or Financial Aid from the USA",null,0,null,"UG Weeks","UG Costs","PG Costs","PG Weeke"]
[{"$f":"SUM(B27:B41)","v":0},{"$f":"IF((D41=\"PRIVATE LOAN\"),1,0)","v":0},"Are you seeking a Government or Private loan (Sallie Mae), select from this drop-box","Government Loan",{"$f":"IF((A41>0),\"PRIVATE LOANS ONLY\",\"\")","v":""},null,{"$f":"D9","v":41},{"$f":"E44*G32*G41","v":0},{"$f":"J41*G32*E44","v":0},{"$f":"D10","v":52}]
[2,"Weekly Essential Costs - School Maximum Estimates - you can adjust the values but may be asked for proofs of your adjusted costs",null,null,null,null,{"$f":"D9","v":41},{"$f":"E45*G33*G42","v":0},{"$f":"J42*G33*E45","v":0},{"$f":"J41","v":52}]
[null,null,null,"School's Estimate per week","Your Request",null,{"$f":"G42","v":41},{"$f":"E46*G32*G43","v":0},{"$f":"J43*G34*E46","v":0},{"$f":"J42","v":52}]
[null,null,"Room - Rent",{"$f":"'School DATA (Office Use Only)'!I11","v":326},0,null,{"$f":"G43","v":41},{"$f":"E47*G33*G44","v":0},{"$f":"J44*G35*E47","v":0},{"$f":"J43","v":52}]
[null,null,"Board - Food and Power",{"$f":"'School DATA (Office Use Only)'!H12+'School DATA (Office Use Only)'!H13","v":100},0,null,{"$f":"G44","v":41},{"$f":"E48*G34*G45","v":0},{"$f":"J45*G36*E48","v":0},{"$f":"J44","v":52}]
[null,null,"Books & Copying",{"$f":"'School DATA (Office Use Only)'!H14","v":15},0]
[null,null,"Travelcard/Transport Costs",{"$f":"'School DATA (Office Use Only)'!H15","v":30},0]
[null,null,"Personal",{"$f":"'School DATA (Office Use Only)'!H16","v":60},0,null,null,"CONVERTING ANNUAL COSTS TO DOLLARS",null,null,"Origination Fees"]
[]
[3,"Single Costs for the year - you may adjust or add in these columns - you may be asked for proof",null,"School's Estimate per Year",{"$f":"E43","v":"Your Request"},null,{"$f":"D7","v":1.4},{"$f":"E51*G50","v":0},null,null,null,"% Rate","Interest","Final","Actual"]
[null,null,{"$f":"'School DATA (Office Use Only)'!G19","v":"2 Midweek return flights with BA from Los Angeles to London"},{"$f":"'School DATA (Office Use Only)'!H19","v":1550},0,null,{"$f":"G50","v":1.4},0,null,null,"Loan Type",null,"Rebate","Rate","Factor"]
[null,null,{"$f":"'School DATA (Office Use Only)'!G20","v":"Visa Application / Flights to Interview"},{"$f":"'School DATA (Office Use Only)'!H20","v":341},0,null,1.4,0,null,null,"Sub Orig Fee",{"$f":"'School DATA (Office Use Only)'!D38","v":1.0569999999999999},{"$f":"'School DATA (Office Use Only)'!E38","v":0},{"$f":"L52-M52","v":1.0569999999999999},{"$f":"N52*0.01","v":1.057E-2}]
[null,null,{"$f":"'School DATA (Office Use Only)'!G21","v":"PC / Laptop"},{"$f":"'School DATA (Office Use Only)'!H21","v":500},0,null,1.4,0,null,null,"Unsub Orig Fee",{"$f":"'School DATA (Office Use Only)'!D39","v":"1/057"},{"$f":"'School DATA (Office Use Only)'!E39","v":0},{"$f":"L53-M53","v":{"$error":"#VALUE!"}},{"$f":"N53*0.01","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"'School DATA (Office Use Only)'!G22","v":"Visa £322 and NHS Charge £150"},{"$f":"'School DATA (Office Use Only)'!H22","v":472},0,null,1.4,0,null,null,"PLUS Orig fee",{"$f":"'School DATA (Office Use Only)'!D40","v":4.2279999999999998},{"$f":"'School DATA (Office Use Only)'!E40","v":0},{"$f":"L54-M54","v":4.2279999999999998},{"$f":"N54*0.01","v":4.2279999999999998E-2}]
[null,null,{"$f":"'School DATA (Office Use Only)'!G23","v":"Academic field trips"},{"$f":"'School DATA (Office Use Only)'!H23","v":750},0,null,1.4,0]
[null,null,{"$f":"'School DATA (Office Use Only)'!G24","v":"Add any other essential costs - write here - only in £"},{"$f":"'School DATA (Office Use Only)'!H24","v":0},{"$f":"D56","v":0},null,1.4,0]
[null,null,{"$f":"'School DATA (Office Use Only)'!G25","v":"Add any other essential costs - write here - only in £"},{"$f":"'School DATA (Office Use Only)'!H25","v":0},0]
[4,null,"YOUR ESTIMATED FINAL COSTS & US ED DEPT MAXIMUM LOAN ELIGIBILITY - YOU MAY BORROW LESS IF YOU CHOOSE",null,null,null,null,"FINAL CALCULATIONS",null,null,"SUB NEED","UNSUB NEED","ORIG FEE NOT INC","ORIG FEE INC"]
[null,null,{"$f":"G59","v":"Requested Cost of Attendance (Values rounded)"},{"$f":"H59","v":"$"},null,null,"Requested Cost of Attendance (Values rounded)","$",null,"CoA",{"$f":"H69","v":0}]
[null,null,{"$f":"G60","v":"Tuition Fees"},{"$f":"H60","v":0},null,null,"Tuition Fees",{"$f":"ROUND(H32,0)","v":0},null,"Less EFC",{"$f":"-D35","v":0}]
[null,null,{"$f":"G61","v":"Room"},{"$f":"H61","v":0},null,null,"Room",{"$f":"ROUND((IF(D30=\"N\",I41,H41)),0)","v":0},null,"Need for Sub",{"$f":"IF((SUM(K59:K60)>0),(SUM(K59:K60)),0)","v":0},null,null,{"$f":"IF((K61<K63),(K63-K61),0)","v":0}]
[null,null,"Board",0,null,null,"Board",{"$f":"ROUND((IF(D30=\"N\",I42,H42)),0)","v":0},null,"Sub available",{"$f":"G28","v":0}]
[null,null,"Books",0,null,null,"Books",{"$f":"ROUND((IF(D30=\"N\",I43,H43)),0)","v":0},null,"Sub Calc",{"$f":"IF((((K61/(100-N52))*100)<K62),((K61/(100-N52))*100),K62)","v":0},null,{"$f":"IF((N61>0),0,(K63*O52))","v":0}]
[null,null,"Travel",0,null,null,"Travel",{"$f":"ROUND((IF(D30=\"N\",I44,H44)),0)","v":0}]
[null,null,"Personal",0,null,null,"Personal",{"$f":"ROUND((IF(D30=\"N\",I45,H45)),0)","v":0},null,"Need for Unsub",null,{"$f":"IF((N61>0),(K59+N61-K63),(K59-K63+M63))","v":0},null,{"$f":"IF((((L67-L65)>0)),(L67-L65),0)","v":{"$error":"#VALUE!"}}]
[null,null,"Other Essential Costs",0,null,null,"Other Essential Costs",{"$f":"SUM(H50:H56)","v":0},null,"Unsub available",null,{"$f":"G28+I28-K63","v":20500}]
[null,null,"Total Cost of Attendance",0,null,null,"Total Cost of Attendance",{"$f":"SUM(H60:H66)","v":0},null,"Unsub Calc",null,{"$f":"IF((((L65/(100-N53))*100)<L66),((L65/(100-N53))*100),L66)","v":{"$error":"#VALUE!"}},{"$f":"+IF((N65>0),0,(L67*O53))","v":{"$error":"#VALUE!"}}]
[null,null,"Adjust for Sponsorship, Awards or other Aid",0,null,null,"Adjust for Sponsorship, Awards or other Aid",{"$f":"ROUND((-I37),0)","v":0}]
[null,null,"Total Requested Cost of Attendance",0,null,null,"Total Requested Cost of Attendance",{"$f":"ROUND((SUM(H67:H68)),0)","v":0},null,"PLUS NEED"]
[null,null,{"$f":"IF(((SUM(B27:B30))>0),\"As you will be in places not allowed by your government you are not entitled to Federal Loans - only private loans\",\"\")","v":""},null,null,null,null,null,null,"Need for PLUS",{"$f":"IF((N65=0),(K59-K63-L67+M63+M67),0)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF((A41>0),\"For more information - click on this link to see your government regulations\",\"\")","v":""},{"$f":"IF((A41>0),\"https://ifap.ed.gov/dpcletters/GEN1420.html\",\"\")","v":""}]
[null,null,{"$f":"IF((A41>0),\"Maximum Private (Sallie Mae) loan we will certify is\",\"\")","v":""},{"$f":"IF((A41>0),H69,\"\")","v":""}]
[null,null,{"$f":"IF((A41>0),\"You must  now go to the Sallie Mae website to apply for your loan. When done, send this form to us, same address as for federal loans, then we can connect to Sallie Mae to certify your application\",\"\")","v":""},null,null,null,"Maximum Govt. Loan you can borrow","$",null,"PLUS Available",{"$f":"H5-K63-L67","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF((A41>0),\"As you will apply for a Sallie Mae loan there is no need to complete anything below this line.\",\" \")","v":" "},null,null,null,"You could have borrowed these Govt. Loans"]
[null,null,{"$f":"IF((A41>0),\"\",(IF((D41=G12),G74,G73)))","v":"Maximum Govt. Loan you can borrow"},null,null,null,"Subsidised - Adjusted by EFC",{"$f":"K63","v":0},null,"PLUS Calc",{"$f":"IF((((K70/(100-N54)*100))<K73),((K70/(100-N54)*100)),(((K73+M63+M67)/(100-N54))*100))","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF((A41>0),\"\",(IF((D30=\"N\"),L28,G75)))","v":"From July 2012 there is no Subsidised Loan for postgraduates"},{"$f":"IF((A41>0),0,H75)","v":0},{"$f":"IF((N61>0),\"Grossed up for fees\",\"\")","v":""},null,"Unsubsudised",{"$f":"L67","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF((A41>0),\"\",G76)","v":"Unsubsudised"},{"$f":"IF((A41>0),0,H76)","v":{"$error":"#VALUE!"}},{"$f":"IF((N65>0),\"Grossed up for fees\",\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF((J78=2),K78,(IF((H69>H5),\"PLUS Loan to fulfil this CoA\",\"\")))","v":""},null,{"$f":"IF((K73<K70),K70,\"\")","v":{"$error":"#VALUE!"}},"Indep Undergrad Score"]
[null,null,{"$f":"G77","v":""},null,{"$f":"I77","v":{"$error":"#VALUE!"}},null,{"$f":"IF((J78=2),\"\",\"Maximum PLUS Loan allowed for this CoA before grossing up for fees\")","v":"Maximum PLUS Loan allowed for this CoA before grossing up for fees"},{"$f":"IF((J78=2),\"\",(IF((K70<K73),(K70-M67-M63),K73)))","v":{"$error":"#VALUE!"}},null,{"$f":"(IF(AND(D31=\"N\",D30=\"Y\"),1,0))+(IF((D34=\"I\"),1,0))","v":0},"Independent Undergraduates are not eligible for a PLUS Loan"]
[null,null,{"$f":"IF((A41>0),\"\",G78)","v":"Maximum PLUS Loan allowed for this CoA before grossing up for fees"},{"$f":"IF((A41>0),0,H78)","v":{"$error":"#VALUE!"}},null,null,"Undergraduate treated as Graduate PLUS Loan"]
[null,null,{"$f":"IF((A41>0),\"\",G80)","v":"Total Eligible before adjustment for Fees"},{"$f":"IF((A41>0),0,H80)","v":{"$error":"#VALUE!"}},null,null,"Total Eligible before adjustment for Fees",{"$f":"SUM(H75:H79)","v":{"$error":"#VALUE!"}}]
[]
[5,null,"SCHOOL COMMENT ON YOUR PROPOSED COSTS & ELIGIBLE LOANS"]
[null,null,{"$f":"IF(H67>H5, I83,\"  \")","v":"  "},null,null,null,null,"Qualify 1","THE COSTS YOU HAVE SUGGESTED ARE TOO HIGH TO BE ACCEPTABLE"]
[null,null,{"$f":"IF((A41>0),\"\",(IF(H67>H5, I84,I85)))","v":"You are allowed to borrow up to the values above"},null,null,null,null,"Qualify 2","Provide evidence of your needs for any increase to  PLUS to be considered or borrow less in Section 6"]
[6,null,{"$f":"IF((D41=G12),\"THIS SECTION DOES NOT APPLY TO SALLIE MAE LOANS\",\"YOU TELL US HOW MUCH WOULD YOU LIKE TO BORROW - YOU MAY REDUCE THE FIGURES IN BLUE\")","v":"YOU TELL US HOW MUCH WOULD YOU LIKE TO BORROW - YOU MAY REDUCE THE FIGURES IN BLUE"},null,null,null,null,"OK Statement","You are allowed to borrow up to the values above"]
["Max Allowed Adjusted for Fees","Government Fees *** Deducted","State how much you would like to borrow for each loan type - adjust the figures in blue in the \"Your Request\" column","Your Request  -  you may only leave or reduce these values","After Origination Fees You Get"]
[{"$f":"IF((A41>0),0,(IF((D41=G12),0,G88)))","v":0},{"$f":"O52","v":1.057E-2},{"$f":"C76","v":"From July 2012 there is no Subsidised Loan for postgraduates"},{"$f":"A87","v":0},{"$f":"ROUND(((D87*(1-O52))),0)","v":0},{"$f":"IF((D87>A87),(\"You cannot borrow more than  \"&A87),\"\")","v":""},"Max Loans Allowed Adjusted for Fees","After Origination Fees You Get"]
[{"$f":"IF((A41>0),0,(IF((D41=G12),0,G89)))","v":{"$error":"#VALUE!"}},{"$f":"O53","v":{"$error":"#VALUE!"}},"Unsubsudised",{"$f":"A88","v":{"$error":"#VALUE!"}},{"$f":"ROUND(((D88*(1-O53))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF((D88>A88),(\"You cannot borrow more than  \"&A88),\"\")","v":{"$error":"#VALUE!"}},{"$f":"ROUND(K63,0)","v":0},{"$f":"ROUND(((G88*(1-O52))),0)","v":0}]
[{"$f":"IF((A41>0),0,(IF((D41=G12),0,G90)))","v":{"$error":"#VALUE!"}},{"$f":"O54","v":4.2279999999999998E-2},{"$f":"IF((J78=2),K78,\"PLUS Loan (Adjusted up to include all fees)\")","v":"PLUS Loan (Adjusted up to include all fees)"},{"$f":"A89","v":{"$error":"#VALUE!"}},{"$f":"ROUND(((D89*(1-O54))),0)","v":{"$error":"#VALUE!"}},{"$f":"IF((D89>A89),(\"You cannot borrow more than  \"&ROUND(A89,2)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"ROUND(L67,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(((G89*(1-O53))),0)","v":{"$error":"#VALUE!"}}]
[{"$f":"IF((A41>0),0,(IF((D41=G12),0,G91)))","v":{"$error":"#VALUE!"}},null,"Total (after rounding, may be slightly higher than total of section 4)",{"$f":"SUM(D87:D89)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E87:E89)","v":{"$error":"#VALUE!"}},{"$f":"IF((E90<>D80),\"Includes $\"&(E90-D80)&\" rounding differences\",\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF((J78=2),\"\",(ROUND(K75,0)))","v":{"$error":"#VALUE!"}},{"$f":"ROUND(((G90*(1-O54))),0)","v":{"$error":"#VALUE!"}}]
["7   School Responses",null,{"$f":"IF((A41>0),\"\",(IF((D90<(H5*1.04)),I92,I94)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"SUM(G88:G90)","v":{"$error":"#VALUE!"}},{"$f":"SUM(H88:H90)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF((A41>0),\"\",(IF((D90<(H5*1.04)),I93,I95)))","v":{"$error":"#VALUE!"}},null,null,null,null,"OK Statement 1","We will check everything you have provided with the USDE data and regulations"]
[null,null,{"$f":"IF((A41>0),\"REMEMBER - TELL US WHEN YOU HAVE DONE YOUR SALLIE MAE APPLICATION SO WE CAN CERTIFY IT\",\"\")","v":""},null,null,null,null,"OK Statement 2","If everything is correct we will originate your loans and issue a certificate for visa application"]
["8      U.S. Government Fees deducted from your disbursement",null,null,null,null,null,null,"Qualify 1","You must provide evidence of your costs/needs before we can process your application"]
[null,{"$f":"B87","v":1.057E-2},{"$f":"C87&\" Origination Fee of \"&L52&\"% less Interest Rebate of \"&M52&\"%\"","v":"From July 2012 there is no Subsidised Loan for postgraduates Origination Fee of 1.057% less Interest Rebate of 0%"},null,null,null,null,"Qualify 2"]
[null,{"$f":"B88","v":{"$error":"#VALUE!"}},{"$f":"C88&\" Origination Fee of \"&L53&\"% less Interest Rebate of \"&M53&\"%\"","v":"Unsubsudised Origination Fee of 1/057% less Interest Rebate of 0%"}]
[null,{"$f":"B89","v":4.2279999999999998E-2},{"$f":"C89&\" Origination Fee of \"&L54&\"% less Interest Rebate of \"&M54&\"%\"","v":"PLUS Loan (Adjusted up to include all fees) Origination Fee of 4.228% less Interest Rebate of 0%"}]
[null,null,"The exchange rate is deliberately high to allow for unforseen circumstances"]

{"sheet":"Checklist","index":3,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Checklist for Direct List Loan Applications",null,null,null,"Allowed"]
["Please put Y or N in the response box for each question",null,null,null,"Y"]
["The default setting is \"N\""]
[null,null,null,null,"N"]
[null,"Response","School Comments"]
["Cost of Attendance","Only Y or N"]
["Have you entered your name and full address on the  Cost of Attendance","n",{"$f":"IF((B7=\"n\"),\"Go back to the Cost of Attendance and enter it or we cannot process your application\",\"\")","v":"Go back to the Cost of Attendance and enter it or we cannot process your application"}]
["Have you entered your SSN on the  Cost of Attendance","n","Go back to the Cost of Attendance and enter it or we cannot process your application"]
["Have you correctly entered your email address on the  Cost of Attendance","n","Go back to the Cost of Attendance and enter it or we cannot process your application"]
["Have you entered the EFC from your SAR on the  Cost of Attendance","n","Go back to the Cost of Attendance and enter it or we cannot process your application"]
["Have you entered your tuition fees on the  Cost of Attendance","n","Go back to the Cost of Attendance and enter it or we cannot process your application"]
["Have you entered on the Cost of Attendance how much you wish to borrow (Section 6)","n","Go back to the Cost of Attendance and enter it or we cannot process your application"]
[]
[]
["Selective Service"]
["Are you female","N"]
[{"$f":"IF((B16=\"N\"),\"Have you signed up for selective service\",\"\")","v":"Have you signed up for selective service"},"n"]
[{"$f":"IF((B17=\"N\"),\"Have you attached proof you are exempt from selective service\",\"\")","v":"Have you attached proof you are exempt from selective service"},"n",{"$f":"IF(((B18=\"n\")*AND(B17=\"n\")),\"Application Rejected\",\"\")","v":"Application Rejected"}]
[]
["Promissory Notes"]
["Have you attached your Stafford MPN","n",{"$f":"IF((B21=\"n\"),\"Application Rejected\",\"\")","v":"Application Rejected"}]
["Have you applied for a PLUS Loan","n"]
[{"$f":"IF((B22=\"Y\"),\"Have you attached your PLUS MPN\",\"\")","v":""},"n",{"$f":"IF(((B23=\"n\")*AND(B22=\"y\")),\"Application Rejected\",\"\")","v":""}]
[{"$f":"IF((B22=\"Y\"),\"Have you attached your Credit Check result email or screenshot\",\"\")","v":""},"n",{"$f":"IF(((B24=\"n\")*AND(B22=\"y\")),\"Application Rejected\",\"\")","v":""}]
[]
["Entrance Counselling"]
["Have you attached your entrance counselling completion","n",{"$f":"IF((B27=\"n\"),\"Application Rejected\",\"\")","v":"Application Rejected"}]
[null,null,{"$f":"IF((B28=\"n\"),\"Application Rejected\",\"\")","v":""}]
["If there are no school comments then we have sufficient information to start the origination process. If anything is missing or incorrect, then we cannot originate your loans."]

{"sheet":"Basis of Costs","index":4,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["How these Costs are Calculated"]
[]
["Exchange Rate","The exchange rate is set by a review of High Street banks and selecting the worst possible rate and incrementing it by the worst possible commission. This is sufficient to enable loans to be calculated and originated. The rate will not be re-assessed until after the end of the registration period. Should the rate change unfavourably once the course has started, then the whole Cost of Attendance can be reviewed again."]
[]
["Room - Rent","First, check the prices of all halls of residence and select the highest below self-contained suite. Second, search for the average price of a room in a shared flat and for a studio flat in the close area (use the web and general estate agent searches). Select the higher average price of the two scenarios."]
[]
["Board - Food and Power","Keep all shopping receipts for a month, This covers all the bills for a month for a normal household including alcohol, all household cleaning materials and all food etc. Divide the weekly average by 1 less than are in the household. This is more than enough to cover the food, provisions and power for a single person."]
[]
["Books & Copying","The cost of a single course pack (for the term) applied for each week which is more than sufficient for book purchase."]
[]
["Travel","Cost of zone 1-2 London weekly travel card"]
[]
["Personal","The Office Manager's 'pocket money' for a week"]
[]
["2 return flights","Cost of two BA return flights Heathrow/LA travelling midweek"]
[]
["PC","Cost of a good quality laptop from a PC chainstore"]
[]
["Visa application","Visa costs plus cost of midweek return next day flight US New York to LA and rounded"]
[]
["PLUS Loan","The balance of the cost of attendance after Sub & Unsub and grossed up to include Origination Fee  on Sub & Unsub added to PLUS loan needs and then increased again to include the origination fee charged on PLUS Loans as quoted on Direct Lending website, and reduced by any rebate offered by USDE. This ensures that the cash you receive, after foreign exchange and deduction of origination fees, is the sterling cost of attendance."]
[]
["Government Fees","Your government takes an origination fee. "]
[null,"There was a partial refund of the origination fee which has been withdrawn since 2012 entry"]
[null,"If those repayments are not all on-time then the refund which was given to you will be charged back to you"]
[]
["Year Dates","These dates are set to minimise the risk of your loan being rejected by overlapping a previous year."]
[null,"Postgraduates - The loan year will be 365 days"]
[null,"Undergraduates - The loan year will be start of academic year to end of final term"]
[]
["Disbursement Dates","The transfer of funds from ED Dept to our UK bank and a refund for your living money takes a good 10 days."]
[null,"WARNING - THESE DATES ARE EXPECTED AND NOT ACTUAL. Allow for about 3 days delay - just in case."]

{"sheet":"Visa Letter (Office Use Only)","index":5,"n_rows":61,"n_cols":2,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"'Cost of Attendance'!C15&\" \"&'Cost of Attendance'!C14","v":"forename surname"}]
[{"$f":"'Cost of Attendance'!C16","v":"line 1"}]
[{"$f":"'Cost of Attendance'!C17","v":"line 2"}]
[{"$f":"'Cost of Attendance'!C18","v":"line 3"}]
[{"$f":"'Cost of Attendance'!C19","v":"line 4"}]
[{"$f":"'Cost of Attendance'!C20","v":"postcode/zipcode"}]
[]
[]
[]
[]
["Notification of Student Loan"]
[{"$f":"'Cost of Attendance'!C4","v":"for Academic Year 2021/22"}]
[]
[]
["This is to certify that "]
[]
["Student Name",{"$f":"'Cost of Attendance'!C15&\" \"&'Cost of Attendance'!C14","v":"forename surname"}]
["Date of Birth",{"$f":"'Cost of Attendance'!C22","v":"dd/mm/yyyy"}]
["Student/Applicant ID",{"$f":"'Cost of Attendance'!C24","v":"Application/Student Number"}]
[]
["has been accepted in a degree-granting program (or otherwise eligible program) at our school."]
[]
["We participate in the William D. Ford Federal Direct Loan (Direct Loan) Program administered by the United States (U.S.) Department of Education. "]
["Eligible students from the U.S. who attend our school may borrow through the Direct Loan Program. "]
["Undergraduate students and graduate/professional students may receive Direct Subsidized Loans and Direct Unsubsidized Loans."]
["Graduate/professional students and parents may receive Direct PLUS Loans. "]
[]
["Based on our calculation of the student’s financial needs and Direct Loan eligibility for the loan period"]
["Start Date",{"$f":"IF(('Cost of Attendance'!D30=\"n\"),'Cost of Attendance'!J15,'Cost of Attendance'!J13)","v":"2021-09-27"}]
["End Date",{"$f":"IF(('Cost of Attendance'!D30=\"n\"),'Cost of Attendance'!J16,'Cost of Attendance'!J14)","v":"2022-09-26"}]
[]
[" the student (or, in some cases, the student’s parent) will receive the following Direct Loan awards"]
["which come from the US Dept of Education and are administered through this school."]
["Loan Type","Loan Amount"]
["Direct Subsidized Loan",{"$f":"'Cost of Attendance'!D87","v":0}]
["Direct Unsubsidized Loan",{"$f":"'Cost of Attendance'!D88","v":{"$error":"#VALUE!"}}]
["Direct PLUS Loan",{"$f":"'Cost of Attendance'!D89","v":{"$error":"#VALUE!"}}]
["Total",{"$f":"'Cost of Attendance'!D90","v":{"$error":"#VALUE!"}}]
[]
["The initial anticipated disbursement dates are as follows (subject to change and notice via email):"]
[{"$f":"'Cost of Attendance'!M13","v":"2021-09-27"},{"$f":"'Cost of Attendance'!N13","v":{"$error":"#VALUE!"}}]
[{"$f":"'Cost of Attendance'!M14","v":"2022-01-10"},{"$f":"'Cost of Attendance'!N14","v":{"$error":"#VALUE!"}}]
[{"$f":"'Cost of Attendance'!M15","v":"2022-04-20"},{"$f":"'Cost of Attendance'!N15","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(('Cost of Attendance'!M16>'Cost of Attendance'!J15),'Cost of Attendance'!M16,\"\")","v":""},{"$f":"'Cost of Attendance'!N16","v":""}]
["Rounding Difference",{"$f":"B39-(SUM(B42:B45))","v":{"$error":"#VALUE!"}}]
["Total",{"$f":"SUM(B42:B46)","v":{"$error":"#VALUE!"}}]
[]
["This certificate is only valid"]
["if printed on school headed paper"]
["and signed across the school logo"]
["by the person whose initials are ringed below","This certificate has been issued by Alex Hawkins at the"]
[{"$f":"(IF(('School DATA (Office Use Only)'!D26>0),'School DATA (Office Use Only)'!D26,\"\"))&\"    \"&(IF(('School DATA (Office Use Only)'!D30>0),'School DATA (Office Use Only)'!D30,\"\"))","v":"AH    AB"}]
[{"$f":"(IF(('School DATA (Office Use Only)'!D27>0),'School DATA (Office Use Only)'!D27,\"\"))&\"    \"&(IF(('School DATA (Office Use Only)'!D31>0),'School DATA (Office Use Only)'!D31,\"\"))","v":"EH    KB"}]
[{"$f":"(IF(('School DATA (Office Use Only)'!D28>0),'School DATA (Office Use Only)'!D28,\"\"))&\"    \"&(IF(('School DATA (Office Use Only)'!D32>0),'School DATA (Office Use Only)'!D32,\"\"))","v":"TH    RB"}]
[{"$f":"(IF(('School DATA (Office Use Only)'!D29>0),'School DATA (Office Use Only)'!D29,\"\"))&\"    \"&(IF(('School DATA (Office Use Only)'!D33>0),'School DATA (Office Use Only)'!D33,\"\"))","v":"GF    RS"}]
[]
["and stamped by the Office stamp","and can be verified by emailing alex.hawkins@courtuald.ac.uk"]
[]
[]
["Date Issued",{"$f":"TODAY()","v":"2021-07-19"}]

{"sheet":"late start letter","index":6,"n_rows":60,"n_cols":2,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'late start Cost of Attendance'!C15&\" \"&'late start Cost of Attendance'!C14","v":"forename surname"}]
[{"$f":"'late start Cost of Attendance'!C16","v":"line 1"}]
[{"$f":"'late start Cost of Attendance'!C17","v":"line 2"}]
[{"$f":"'late start Cost of Attendance'!C18","v":"line 3"}]
[{"$f":"'late start Cost of Attendance'!C19","v":"line 4"}]
[{"$f":"'late start Cost of Attendance'!C20","v":"postcode/zipcode"}]
[]
[]
[]
[]
["Notification of Student Loan"]
[{"$f":"'Cost of Attendance'!C4","v":"for Academic Year 2021/22"}]
[]
[]
["This is to certify that "]
[]
["Student Name",{"$f":"A1","v":"forename surname"}]
["Date of Birth",{"$f":"'late start Cost of Attendance'!C22","v":"1952-12-30"}]
["Student/Applicant ID",{"$f":"'late start Cost of Attendance'!C24","v":"201055555"}]
[]
["has been accepted in a degree-granting program (or otherwise eligible program) at our school."]
[]
["We participate in the William D. Ford Federal Direct Loan (Direct Loan) Program administered by the United States (U.S.) Department of Education. "]
["Eligible students from the U.S. who attend our school may borrow through the Direct Loan Program. "]
["Undergraduate students and graduate/professional students may receive Direct Subsidized Loans and Direct Unsubsidized Loans."]
["Graduate/professional students and parents may receive Direct PLUS Loans. "]
[]
["Based on our calculation of the student’s financial needs and Direct Loan eligibility for the loan period"]
["Start Date",{"$f":"'late start Cost of Attendance'!D27","v":"2018-04-01"}]
["End Date",{"$f":"IF(('Cost of Attendance'!D30=\"n\"),'Cost of Attendance'!J16,'Cost of Attendance'!J14)","v":"2022-09-26"}]
[]
[" the student (or, in some cases, the student’s parent) will receive the following Direct Loan awards"]
["which come from the US Dept of Education and are administered through this school."]
["Loan Type","Loan Amount"]
["Direct Subsidized Loan",{"$f":"'late start Cost of Attendance'!D93","v":0}]
["Direct Unsubsidized Loan",{"$f":"'late start Cost of Attendance'!D94","v":{"$error":"#VALUE!"}}]
["Direct PLUS Loan",{"$f":"'late start Cost of Attendance'!D95","v":{"$error":"#VALUE!"}}]
["Total",{"$f":"SUM(B35:B37)","v":{"$error":"#VALUE!"}}]
[]
["The disbursement dates are as follows:"]
[{"$f":"'late start Cost of Attendance'!M13","v":"2021-09-27"},{"$f":"'late start Cost of Attendance'!N13","v":{"$error":"#VALUE!"}}]
[{"$f":"'late start Cost of Attendance'!M14","v":"2022-01-10"},{"$f":"'late start Cost of Attendance'!N14","v":{"$error":"#VALUE!"}}]
[{"$f":"'late start Cost of Attendance'!M15","v":"2022-04-20"},{"$f":"'late start Cost of Attendance'!N15","v":{"$error":"#VALUE!"}}]
[{"$f":"'late start Cost of Attendance'!M16","v":""},{"$f":"'late start Cost of Attendance'!N16","v":""}]
["Rounding Difference",{"$f":"B38-(SUM(B41:B44))","v":{"$error":"#VALUE!"}}]
["Total",{"$f":"SUM(B41:B45)","v":{"$error":"#VALUE!"}}]
[]
["This certificate is only valid"]
["if printed on school headed paper"]
["and signed across the coat of arms"]
["by the person whose initials are ringed below"]
[{"$f":"(IF(('School DATA (Office Use Only)'!D26>0),'School DATA (Office Use Only)'!D26,\"\"))&\"    \"&(IF(('School DATA (Office Use Only)'!D30>0),'School DATA (Office Use Only)'!D30,\"\"))","v":"AH    AB"}]
[{"$f":"(IF(('School DATA (Office Use Only)'!D27>0),'School DATA (Office Use Only)'!D27,\"\"))&\"    \"&(IF(('School DATA (Office Use Only)'!D31>0),'School DATA (Office Use Only)'!D31,\"\"))","v":"EH    KB"}]
[{"$f":"(IF(('School DATA (Office Use Only)'!D28>0),'School DATA (Office Use Only)'!D28,\"\"))&\"    \"&(IF(('School DATA (Office Use Only)'!D32>0),'School DATA (Office Use Only)'!D32,\"\"))","v":"TH    RB"}]
[{"$f":"(IF(('School DATA (Office Use Only)'!D29>0),'School DATA (Office Use Only)'!D29,\"\"))&\"    \"&(IF(('School DATA (Office Use Only)'!D33>0),'School DATA (Office Use Only)'!D33,\"\"))","v":"GF    RS"}]
[]
["and stamped by the Office stamp"]
[]
[]
["Date Issued"]

{"sheet":"School DATA (Office Use Only)","index":7,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[null,"FOR SCHOOL USE ONLY",null,"DON'T TOUCH THE BLUE BOXES - They are calculations which feed other parts of this workbook"]
[null,null,null,"School to Complete ONLY the yellow boxes"]
[null,null,null,"SCHOOL INFORMATION",null,null,null,"MONEY INFORMATION"]
[]
[null,null,null,"Academic Year Calculations",null,null,null,"Calculates max allowed before prroof of costs needed"]
[1,"Which Academic Year is this","Year format yyyy/yy","2021/22",null,6,"Complete this Fee Estimate"]
[null,null,"Start day of the year","2021-09-27",{"$f":"D7+364","v":"2022-09-26"},null,"Avg highest Tuition Fee charged in London for MSc",30839,null,{"$f":"H7","v":30839}]
[null,null,"When did you complete this form","2021-07-19"]
[null,"Complete these dates",null,null,null,7,"Complete these Cost Estimates which are PER WEEK","Calculates school CoA"]
[null,"When do think your undergraduates start to arrive (occupy their bedroom)",null,"2021-09-27","Undergrad weeks",null,"What is the highest charge for your halls of residence per week",326]
[null,"What is the date of your last Bachelors' graduation ceremony in the summer ",null,"2022-07-12",{"$f":"ROUND(((MAX(D11:D12)-D10)/7),0)","v":41},null,"What is your best estimate at the high-end going rate for a room per week in the area",300,{"$f":"MAX(H10:H11)","v":326}]
[null,"AND/OR","official end of summer term - ONLY if earlier","2022-07-01","Postgrad weeks",null,"What is your best estimate for electricity/gas for a week (use our own home direct debits?)",50]
[null,null,null,null,52,null,"What is your normal family shopping for a week and adjust for one adult",50]
[2,"What will be the dates your students get their disbursements",null,null,null,null,"What is your best estimate for book buying or photocopying or course packs per week",15]
[null,"Your dates in COD might be earlier [to allow processing time]",null,null,null,null,"What is your best estimate at travel costs for the area for a week",30]
[null,"Only put in the date against each term",null,null,null,null,"What is your estimate for enough pocket money including beer/nights out/movie/pizza per week",60,{"$f":"SUM(H12:H16)","v":205},{"$f":"(SUM(I11:I16))*E13","v":27612}]
[null,"Do NOT put in a date where you don't have a disbursement",null,"Payment periods - terms"]
[null,"Term 1 [could be autumn or 1st semester]",null,"2021-09-27",{"$f":"D19-1","v":"2022-01-09"},8,"Look up these costs on the web"]
[null,"Term 2 [could be spring - after Christmas - or 2nd semester]",null,"2022-01-10",{"$f":"IF((D20>0),(D20-1),(MAX(D10:D11)))","v":"2022-04-19"},null,"2 Midweek return flights with BA from Los Angeles to London",1550,null,{"$f":"H19*2","v":3100}]
[null,"Term 3 [could be summer - after Easter]",null,"2022-04-20",{"$f":"IF((D21>0),(D21-1),(MAX(D11:D12)))","v":"2022-07-12"},null,"Visa Application / Flights to Interview",341]
[null,"Term 4 [could be the writing up term after May/June exams if you have such a term]",null,null,{"$f":"IF((D22>0),(D22-1),(MAX(D11:D12)))","v":"2022-07-12"},null,"PC / Laptop",500]
[null,null,null,null,{"$f":"E18","v":"2022-01-09"},"PG T1","Visa £322 and NHS Charge £150",472]
[3,"What are the initials of your staff allowed to sign visa letters USE BLOCK CAPS",null,null,{"$f":"IF((D20>1),(D20-1),E7)","v":"2022-04-19"},"PG T2","Academic field trips",750]
[null,null,"Only put in the staff you authorise",null,{"$f":"IF((D21>1),(D21-1),E7)","v":"2022-09-26"},"PG T3","Add any other essential costs - write here - only in £",0]
[null,null,"Do not put in initials where you don't have staff",null,{"$f":"IF((D22>1),(D22-1),E7)","v":"2022-09-26"},"PG T4","Add any other essential costs - write here - only in £",0,null,{"$f":"SUM(H20:H25)","v":2063}]
[null,null,"person 1","AH"]
[null,null,"person 2","EH"]
[null,null,"person 3","TH",null,9,"Go to the banks near you and collect their exchange rates",null,"Calculates exchange rate for CoA"]
[null,null,"person 4","GF",null,null,"When did you do this","Write in the date","2021-05-27","London"]
[null,null,"person 5","AB",null,null,"When - long after the first disbursement - will you review the exchange rate","Write in the date","2021-12-01"]
[null,null,"person 6","KB",null,null,"If any bank showed a commission rate then enter it against that bank","Bank Number","Rate","Commission %"]
[null,null,"person 7","RB",null,null,"Do not write the name of any bank","Bank 1 ",1.41,0]
[null,null,"person 8","RS",null,null,null,"Bank 2",1.39,0]
[null,null,null,null,null,null,null,"Bank 3"]
[4,"These are 01 Oct 2015 - http://ifap.ed.gov/dpcletters/GEN1507.html",null,null,null,null,null,"Bank 4"]
[null,"Be absolutely sure you are looking at the right year",null,"Calculates gross loan to cash",null,null,null,"Bank 5"]
[null,"Rate from 1st Oct 2014","Loan Type","Origination Fee %","Rebate %",null,"only 3 banks would accept or exchange dollars","Bank 6"]
[null,null,"Subsidised Loans",1.0569999999999999,0,null,null,"Bank 7"]
[null,null,"Unsubsidised Loans","1/057",0,null,null,"Bank 8"]
[null,null,"PLUS Loans",4.2279999999999998,0,null,null,"Bank 9"]
[null,null,"Worst Fee Rate",{"$f":"MAX(D38:D40)","v":4.2279999999999998},null,null,null,"Bank 10"]
[null,null,null,null,null,null,null,"Worst case rates",{"$f":"MAX(I32:I41)","v":1.41},{"$f":"MAX(J32:J41)","v":0}]
[5,"These are 15/16 - If you know levels have changed, go to the USDE website and find the loan levels for each type of student"]
[null,"The information in the FSA Handbook is confusing so use another site to confirm details",null,null,null,null,"Worst combination goes to the CoA",{"$f":"IF((I44>0),I44,(ROUND((I42+(I42*(J42/100))),2)))","v":1.4},1.4]
[null,null,null,"Loan values eligible"]
[null,"Undergrads","Subsidised","Dependent Unsubsidised","Independent Unsubsidised",null,"Worst case costs at selected or calculated exchange rate",{"$f":"ROUND(((SUM(J7:J25))*H44),0)","v":89060}]
[null,"Year 1",3500,2000,6000,null,"and inflated by 10%",{"$f":"ROUND((H46*0.1),0)","v":8906}]
[null,"Year 2",4500,2000,6000,null,null,{"$f":"SUM(H46:H47)","v":97966}]
[null,"Year 3",5500,2000,7000,null,"plus worst origination rates",{"$f":"H48/100*D41","v":4142.0024799999992}]
[null,"Year 4",5500,2000,7000,null,"Max Loans allowed before review",{"$f":"SUM(H48:H49)","v":102108.00248}]
[null,"Postgrads",0,0,20500]
[]
[]
[10,"Calculating fields for late starters - do not adjust these fields"]
[null,null,"Start","End","weeks"]
[null,"PG",{"$f":"'late start Cost of Attendance'!D27","v":"2018-04-01"},{"$f":"E7","v":"2022-09-26"},{"$f":"ROUND(((D56-C56)/7),0)","v":234}]
[null,"UG",{"$f":"C56","v":"2018-04-01"},{"$f":"D11","v":"2022-07-12"},{"$f":"ROUND(((D57-C57)/7),0)","v":223}]

{"sheet":"Pvt L. Letter (Office Use Only)","index":8,"n_rows":52,"n_cols":2,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Cost of Attendance'!C15&\" \"&'Cost of Attendance'!C14","v":"forename surname"}]
[{"$f":"'Cost of Attendance'!C16","v":"line 1"}]
[{"$f":"'Cost of Attendance'!C17","v":"line 2"}]
[{"$f":"'Cost of Attendance'!C18","v":"line 3"}]
[{"$f":"'Cost of Attendance'!C19","v":"line 4"}]
[{"$f":"'Cost of Attendance'!C20","v":"postcode/zipcode"}]
[]
[]
[]
[]
["Notification of Student Loan"]
[{"$f":"'Cost of Attendance'!C4","v":"for Academic Year 2021/22"}]
[]
[]
["This is to certify that "]
[]
["Student Name",{"$f":"'Cost of Attendance'!C15&\" \"&'Cost of Attendance'!C14","v":"forename surname"}]
["Date of Birth (dd/mm/yyyy)",{"$f":"'Cost of Attendance'!C22","v":"dd/mm/yyyy"}]
["Student/Applicant ID",{"$f":"'Cost of Attendance'!C24","v":"Application/Student Number"}]
[]
["has been accepted in a degree-granting program (or otherwise eligible program) at our school."]
[]
["Eligible students from the U.S. who attend our school may borrow private loans through Sallie Mae. "]
["The School certifies the value of these loans and receives the disbursements to give to the student."]
[]
["We have certified a loan with Sallie Mae as follows:"]
["Start Date",{"$f":"IF(('Cost of Attendance'!D30=\"n\"),'Cost of Attendance'!J15,'Cost of Attendance'!J13)","v":"2021-09-27"}]
["End Date",{"$f":"IF(('Cost of Attendance'!D30=\"n\"),'Cost of Attendance'!J16,'Cost of Attendance'!J14)","v":"2022-09-26"}]
[]
[" the student will receive the following Private Loan awards:"]
["Sallie Mae Smart Loan",{"$f":"'Cost of Attendance'!E90","v":{"$error":"#VALUE!"}}]
[]
["The disbursement dates are as follows:"]
[{"$f":"'Cost of Attendance'!M13","v":"2021-09-27"},{"$f":"B31","v":{"$error":"#VALUE!"}}]
[]
[]
[]
["Total",{"$f":"SUM(B34:B37)","v":{"$error":"#VALUE!"}}]
[]
["This certificate is only valid"]
["if printed on school headed paper"]
["and signed across the coat of arms"]
["by the person whose initials are ringed below"]
[{"$f":"(IF(('School DATA (Office Use Only)'!D26>0),'School DATA (Office Use Only)'!D26,\"\"))&\"    \"&(IF(('School DATA (Office Use Only)'!D30>0),'School DATA (Office Use Only)'!D30,\"\"))","v":"AH    AB"}]
[{"$f":"(IF(('School DATA (Office Use Only)'!D27>0),'School DATA (Office Use Only)'!D27,\"\"))&\"    \"&(IF(('School DATA (Office Use Only)'!D31>0),'School DATA (Office Use Only)'!D31,\"\"))","v":"EH    KB"}]
[{"$f":"(IF(('School DATA (Office Use Only)'!D28>0),'School DATA (Office Use Only)'!D28,\"\"))&\"    \"&(IF(('School DATA (Office Use Only)'!D32>0),'School DATA (Office Use Only)'!D32,\"\"))","v":"TH    RB"}]
[{"$f":"(IF(('School DATA (Office Use Only)'!D29>0),'School DATA (Office Use Only)'!D29,\"\"))&\"    \"&(IF(('School DATA (Office Use Only)'!D33>0),'School DATA (Office Use Only)'!D33,\"\"))","v":"GF    RS"}]
[]
["and stamped by the Office stamp"]
[]
[]
["Date Issued",{"$f":"TODAY()","v":"2021-07-19"}]

{"sheet":"late start Cost of Attendance","index":9,"n_rows":104,"n_cols":15,"rows_kept":104,"cut":false,"hidden":true,"merged":[[77,2,77,3]]}
[]
[null,null,"Cost of Attendance",null,"v.180215"]
[null,null,"& Loan Calculation"]
[null,null,{"$f":"\"for Academic Year \"& 'School DATA (Office Use Only)'!D6","v":"for Academic Year 2021/22"},null,"uncle","p/w hint"]
[null,null,"RETAIL (Main Street) RATE - NOT INTERBANK RATE",null,null,null,null,{"$f":"'School DATA (Office Use Only)'!H48","v":97966},"Max CoA before Interview"]
[null,null,"This form and exchange rates revised",null,"2018-06-15",null,null,{"$f":"'School DATA (Office Use Only)'!H50","v":102108.00248},"Max Loan after grossing up for Fees adjustments"]
[null,null,"Worst possible rate for Retail US Dollar Rate - best guess",{"$f":"IF(('School DATA (Office Use Only)'!I44>0),'School DATA (Office Use Only)'!I44,'School DATA (Office Use Only)'!H44)","v":1.4},{"$f":"'School DATA (Office Use Only)'!I29","v":"2021-05-27"}]
[null,null,"Next review date for Exchange Rate",null,{"$f":"'School DATA (Office Use Only)'!I30","v":"2021-12-01"},null,"Depend","Choice","Year"]
[null,null,"No of Weeks for Undergraduates and % of 9 months  sub/unsub loan allowed",{"$f":"'School DATA (Office Use Only)'!E57","v":223},{"$f":"ROUND((D9/36),2)","v":6.19},null,"I","N",1]
[null,null,"No of Weeks for Postrgraduates and % of 12 months sub/unsub loan allowed",{"$f":"'School DATA (Office Use Only)'!E56","v":234},{"$f":"ROUND((D10/52),2)","v":4.5},null,"D","Y",2]
[null,null,null,null,null,null,null,null,"3 or above",null,null,null,"ONLY ENTER DATES"]
[1,null,"COMPLETE THE YELLOW BOXES ONLY",null,null,null,"Private Loan","STANDING DATA","Loan Dates",null,null,"DISBURSEMENTS","Disburse Dates","VALUES ARE AUTOMATIC"]
[null,null,null,null,null,null,"Government Loan","Undergrads","Start",{"$f":"D27","v":"2018-04-01"},null,{"$f":"COUNT(M13:M19)","v":3},{"$f":"IF(('School DATA (Office Use Only)'!D18>'late start Cost of Attendance'!D27),'School DATA (Office Use Only)'!D18,\"\")","v":"2021-09-27"},{"$f":"IF((ISNUMBER(M13)),(ROUND((D96/L13),0)),\"\")","v":{"$error":"#VALUE!"}}]
["Family Name (Surname)",null,"surname",null,null,null,null,null,"End",{"$f":"'School DATA (Office Use Only)'!D11","v":"2022-07-12"},null,"put 2nd date",{"$f":"IF(('School DATA (Office Use Only)'!D19>'late start Cost of Attendance'!D27),'School DATA (Office Use Only)'!D19,\"\")","v":"2022-01-10"},{"$f":"IF((ISNUMBER(M14)),(ROUND((D96/L13),0)),\"\")","v":{"$error":"#VALUE!"}}]
["Given Name (Forename)",null,"forename",null,null,null,null,"Postgrads","Start",{"$f":"D27","v":"2018-04-01"},null,"put 3rd date or blank",{"$f":"IF(('School DATA (Office Use Only)'!D20>'late start Cost of Attendance'!D27),'School DATA (Office Use Only)'!D20,\"\")","v":"2022-04-20"},{"$f":"IF((ISNUMBER(M15)),(ROUND((D96/L13),0)),\"\")","v":{"$error":"#VALUE!"}}]
["Address Line 1",null,"line 1",null,null,null,null,null,"End",{"$f":"'School DATA (Office Use Only)'!E7","v":"2022-09-26"},null,"put 4th date or blank",{"$f":"IF(('School DATA (Office Use Only)'!D21>'late start Cost of Attendance'!D27),'School DATA (Office Use Only)'!D21,\"\")","v":""},{"$f":"IF((ISNUMBER(M16)),(ROUND((D96/L13),0)),\"\")","v":""}]
["Address Line 2",null,"line 2",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N13:N16)","v":{"$error":"#VALUE!"}}]
["Address Line 3",null,"line 3"]
["Address Line 4",null,"line 4"]
["Zipcode / Postcode",null,"postcode/zipcode"]
["Email",null,"email address",null,null,null,null,"MAXIMUM LOAN LEVELS FOR THIS STU",null,null,"MAXIMUM LOAN LEVELS AVAILABLE"]
["Date of Birth dd/mm/yyyy",null,"1952-12-30",null,null,null,"Sub","Unsub Depend","Unsub Ind",null,"Sub","Unsub Depend","Unsub Ind","Pro Rata Factor"]
["Full Social Security Number",null,"123 45 6789",null,null,null,{"$f":"IF(D31=\"Y\",0,(K23*N23))","v":0},null,{"$f":"IF((D31=\"N\"),(M23*N23),0)","v":92250},"postgraduates",0,0,20500,{"$f":"E10","v":4.5}]
["Application/Student Number",null,"201055555",null,null,null,{"$f":"IF((AND(D31=\"Y\",D32=\"N\",D34=1)),(K24*N24),0)","v":0},{"$f":"IF((AND(D31=\"Y\",D35=\"D\",D34=1)),(L24*N24),0)","v":0},{"$f":"IF((AND(D31=\"Y\",D35=\"I\",D34=1)),(M24*N24),0)","v":0},"Undergraduate1",3500,2000,6000,{"$f":"E9","v":6.19}]
["Full name of your course",null,"MSc Gastronomy and Taxidermy",null,null,null,{"$f":"IF((AND(D31=\"Y\",D32=\"N\",D34=2)),(K25*N25),0)","v":0},{"$f":"IF((AND(D31=\"Y\",D35=\"D\",D34=2)),(L25*N25),0)","v":0},{"$f":"IF((AND(D31=\"Y\",D35=\"I\",D34=2)),(M25*N25),0)","v":0},"Undergraduate2",4500,2000,6000,{"$f":"N24","v":6.19}]
[null,null,null,null,null,null,{"$f":"IF((AND(D31=\"Y\",D32=\"N\",D34>2)),(K26*N26),0)","v":0},{"$f":"IF((AND(D31=\"Y\",D35=\"D\",D34>2)),(L26*N26),0)","v":0},{"$f":"IF((AND(D31=\"Y\",D35=\"I\",D34>2)),(M26*N26),0)","v":0},"Undergraduate>2",5500,2000,7000,{"$f":"N25","v":6.19}]
["Then answer these",null,"On what date will you start the course","2018-04-01"]
[null,{"$f":"IF((D28=\"Y\"),1,0)","v":0},"Does your course - whole course, in any year - have any time in USA other than vacations? Only answer Y or N","N",{"$f":"IF((D28=\"Y\"),\"PRIVATE LOANS ONLY\",\"\")","v":""},null,{"$f":"IF((AND(D31=\"Y\", D32=\"Y\", D33=\"Y\")),(K28*N28),0)","v":0},{"$f":"IF((AND(D32=\"Y\",D36=\"D\",D35>2)),(L28*N28),0)","v":0},{"$f":"IF((AND(D31=\"Y\", D32=\"Y\", D33=\"Y\")),(M28*N28),0)","v":0},"Law",{"$f":"K23","v":0},{"$f":"L23","v":0},{"$f":"M23","v":20500},{"$f":"N26","v":6.19}]
[null,null,"Does your course involve any time at another university or school, or campus? Only answer Y or N","N",{"$f":"IF((D29=\"Y\"),\"For school codes - click below\",\"\")","v":""},null,{"$f":"MAX(G23:G28)","v":0},null,{"$f":"MAX(H23:I28)","v":92250},"Max Loan Available",null,"From July 2012 there is no Subsidised Loan for postgraduates"]
[null,{"$f":"IF((D30=\"N\"),1,0)","v":0},{"$f":"IF((D29=\"Y\"),\"Is that school in the List of federal School Codes at the website link now showing in red box\",\"do not adjust this line\")","v":"do not adjust this line"},"Y",{"$f":"IF((D29=\"Y\"),\"https://fafsa.ed.gov/FAFSA/app/schoolSearch?locale=en_EN\",\"\")","v":""}]
[null,null,"Is this course for BSc or BA or BLL? Only answer Y or N","N",null,null,null,"CONVERTING FEES AND CONTRIBUTIONS TO DOLLARS",null,null,null,"Undergrad Courses which could get Postgrad funding"]
[null,null,{"$f":"IF(D31=\"N\", \"Do not adjust this line\", \"Are you taking a profesional course but at undergraduate level? Only answer Y or N\")","v":"Do not adjust this line"},"N",null,null,"Rate","Convert £ ","Already $","Actual Loans",null,"Law"]
[null,null,{"$f":"IF((AND( D31=\"Y\", D32=\"Y\")), \"Do you already have another undergraduate degree - answer Y or N\", \"Do not adjust this line\" )","v":"Do not adjust this line"},"N",null,null,{"$f":"D7","v":1.4},{"$f":"D37*G33","v":30799.999999999996},{"$f":"E37","v":0},"Fees"]
[null,null,"What will be your year of study - select from the dropbox only",1,null,null,{"$f":"G33","v":1.4},{"$f":"D38*G34","v":0},{"$f":"E38","v":0},"Sponsors"]
[null,null,"What does your SAR say for \"dependancy status\" Only answer I or D","I",null,null,{"$f":"G34","v":1.4},{"$f":"D39*G35","v":0},{"$f":"E39","v":0},"School Aid"]
[null,null,"What is you EFC (top right of front page of SAR) Even zero must be entered",0,null,null,{"$f":"G35","v":1.4},{"$f":"D40*G36","v":0},{"$f":"E40","v":0},"Other Aid £UK"]
[null,null,"Enter Tuition Fee for the remainder of this school year - write the figures not the £ sign which is already formatted",22000,null,null,{"$f":"G35","v":1.4},{"$f":"D41*G37","v":0},{"$f":"E41","v":0},"Other Aid $USA"]
[null,null,"How much of the tuition fees will be paid to your school by a sponsor (only enter in the $ or £ box - not both)",0,0,null,null,null,{"$f":"SUM(H34:I37)","v":0},"Deduct from \"Need\""]
[null,null,"How much has already been awarded by this school as a Scholarship or Financial Aid",0]
[null,null,"How much has been awarded by any other Scholarship or Financial Aid in the UK",0,null,null,null,"CONVERTING WEEKLY COSTS TO DOLLARS"]
["Calcs above/beside",null,"How much has been awarded by any other Scholarship or Financial Aid from the USA",null,0,null,"UG Weeks","UG Costs","PG Costs","PG Weeke"]
[{"$f":"SUM(B28:B42)","v":0},{"$f":"IF((D42=\"PRIVATE LOAN\"),1,0)","v":0},"Are you seeking a Government or Private loan (Sallie Mae), select from this drop-box","Government Loan",null,null,{"$f":"D9","v":223},{"$f":"E46*G33*G42","v":101777.2},{"$f":"J42*G33*E46","v":106797.59999999999},{"$f":"D10","v":234}]
[null,null,null,null,null,null,{"$f":"D9","v":223},{"$f":"E47*G34*G43","v":31220},{"$f":"J43*G34*E47","v":32759.999999999996},{"$f":"J42","v":234}]
[2,"Weekly Essential Costs - School Maximum Estimates - you can adjust the values but may be asked for proofs of your adjusted costs",null,null,null,null,{"$f":"G43","v":223},{"$f":"E48*G33*G44","v":4683},{"$f":"J44*G35*E48","v":4913.9999999999991},{"$f":"J43","v":234}]
[null,null,null,"School's Estimate per week","Your Request",null,{"$f":"G44","v":223},{"$f":"E49*G34*G45","v":9366},{"$f":"J45*G36*E49","v":9827.9999999999982},{"$f":"J44","v":234}]
[null,null,"Room - Rent",{"$f":"'School DATA (Office Use Only)'!I11","v":326},{"$f":"MAX('School DATA (Office Use Only)'!H10:H11)","v":326},null,{"$f":"G45","v":223},{"$f":"E50*G35*G46","v":18732},{"$f":"J46*G37*E50","v":19655.999999999996},{"$f":"J45","v":234}]
[null,null,"Board - Food and Power",{"$f":"'School DATA (Office Use Only)'!H12+'School DATA (Office Use Only)'!H13","v":100},{"$f":"'School DATA (Office Use Only)'!H12+'School DATA (Office Use Only)'!H13","v":100}]
[null,null,"Books & Copying",{"$f":"'School DATA (Office Use Only)'!H14","v":15},{"$f":"'School DATA (Office Use Only)'!H14","v":15}]
[null,null,"Travelcard/Transport Costs",{"$f":"'School DATA (Office Use Only)'!H15","v":30},{"$f":"'School DATA (Office Use Only)'!H15","v":30},null,null,"CONVERTING ANNUAL COSTS TO DOLLARS",null,null,"Origination Fees"]
[null,null,"Personal",{"$f":"'School DATA (Office Use Only)'!H16","v":60},{"$f":"'School DATA (Office Use Only)'!H16","v":60}]
[null,null,null,null,null,null,{"$f":"D7","v":1.4},{"$f":"E55*G51","v":2170},null,null,null,"% Rate","Interest","Final","Actual"]
[null,null,null,null,null,null,{"$f":"G51","v":1.4},477.4,null,null,"Loan Type",null,"Rebate","Rate","Factor"]
[3,"Single Costs for the year - you may adjust or add extras in these columns - you may be asked for proof of your extra needs",null,null,null,null,1.4,700,null,null,"Sub Orig Fee",{"$f":"'School DATA (Office Use Only)'!D38","v":1.0569999999999999},{"$f":"'School DATA (Office Use Only)'!E38","v":0},{"$f":"L53-M53","v":1.0569999999999999},{"$f":"N53*0.01","v":1.057E-2}]
[null,null,null,"School's Estimate per Year",{"$f":"E45","v":"Your Request"},null,1.4,660.8,null,null,"Unsub Orig Fee",{"$f":"'School DATA (Office Use Only)'!D39","v":"1/057"},{"$f":"'School DATA (Office Use Only)'!E39","v":0},{"$f":"L54-M54","v":{"$error":"#VALUE!"}},{"$f":"N54*0.01","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"'School DATA (Office Use Only)'!G19","v":"2 Midweek return flights with BA from Los Angeles to London"},{"$f":"'School DATA (Office Use Only)'!H19","v":1550},{"$f":"D55","v":1550},null,1.4,1050,null,null,"PLUS Orig fee",{"$f":"'School DATA (Office Use Only)'!D40","v":4.2279999999999998},{"$f":"'School DATA (Office Use Only)'!E40","v":0},{"$f":"L55-M55","v":4.2279999999999998},{"$f":"N55*0.01","v":4.2279999999999998E-2}]
[null,null,{"$f":"'School DATA (Office Use Only)'!G20","v":"Visa Application / Flights to Interview"},{"$f":"'School DATA (Office Use Only)'!H20","v":341},{"$f":"D56","v":341},null,1.4,0]
[null,null,{"$f":"'School DATA (Office Use Only)'!G21","v":"PC / Laptop"},{"$f":"'School DATA (Office Use Only)'!H21","v":500},500,null,1.4,0]
[null,null,{"$f":"'School DATA (Office Use Only)'!G22","v":"Visa £322 and NHS Charge £150"},{"$f":"'School DATA (Office Use Only)'!H22","v":472},472]
[null,null,{"$f":"'School DATA (Office Use Only)'!G23","v":"Academic field trips"},{"$f":"'School DATA (Office Use Only)'!H23","v":750},750,null,null,"FINAL CALCULATIONS",null,null,"SUB NEED","UNSUB NEED","ORIG FEE NOT INC","ORIG FEE INC"]
[null,null,{"$f":"'School DATA (Office Use Only)'!G24","v":"Add any other essential costs - write here - only in £"},{"$f":"'School DATA (Office Use Only)'!H24","v":0},0,null,"Requested Cost of Attendance (Values rounded)","$",null,"CoA",{"$f":"H70","v":209814}]
[null,null,{"$f":"'School DATA (Office Use Only)'!G25","v":"Add any other essential costs - write here - only in £"},{"$f":"'School DATA (Office Use Only)'!H25","v":0},0,null,"Tuition Fees",{"$f":"ROUND(H33,0)","v":30800},null,"Less EFC",{"$f":"-D36","v":0}]
[null,null,null,null,null,null,"Room",{"$f":"ROUND((IF(D31=\"N\",I42,H42)),0)","v":106798},null,"Need for Sub",{"$f":"IF((SUM(K60:K61)>0),(SUM(K60:K61)),0)","v":209814},null,null,{"$f":"IF((K62<K64),(K64-K62),0)","v":0}]
[4,null,"YOUR ESTIMATED FINAL COSTS & US ED DEPT MAXIMUM LOAN ELIGIBILITY - YOU MAY BORROW LESS IF YOU CHOOSE",null,null,null,"Board",{"$f":"ROUND((IF(D31=\"N\",I43,H43)),0)","v":32760},null,"Sub available",{"$f":"G29","v":0}]
[null,null,{"$f":"G60","v":"Requested Cost of Attendance (Values rounded)"},{"$f":"H60","v":"$"},null,null,"Books",{"$f":"ROUND((IF(D31=\"N\",I44,H44)),0)","v":4914},null,"Sub Calc",{"$f":"IF((((K62/(100-N53))*100)<K63),((K62/(100-N53))*100),K63)","v":0},null,{"$f":"IF((N62>0),0,(K64*O53))","v":0}]
[null,null,{"$f":"G61","v":"Tuition Fees"},{"$f":"H61","v":30800},null,null,"Travel",{"$f":"ROUND((IF(D31=\"N\",I45,H45)),0)","v":9828}]
[null,null,{"$f":"G62","v":"Room"},106798,null,null,"Personal",{"$f":"ROUND((IF(D31=\"N\",I46,H46)),0)","v":19656},null,"Need for Unsub",null,{"$f":"IF((N62>0),(K60+N62-K64),(K60-K64+M64))","v":209814},null,{"$f":"IF((((L68-L66)>0)),(L68-L66),0)","v":{"$error":"#VALUE!"}}]
[null,null,"Board",32760,null,null,"Other Essential Costs",{"$f":"SUM(H51:H57)","v":5058.2},null,"Unsub available",null,{"$f":"G29+I29-K64","v":92250}]
[null,null,"Books",4914,null,null,"Total Cost of Attendance",{"$f":"SUM(H61:H67)","v":209814.2},null,"Unsub Calc",null,{"$f":"IF((((L66/(100-N54))*100)<L67),((L66/(100-N54))*100),L67)","v":{"$error":"#VALUE!"}},{"$f":"+IF((N66>0),0,(L68*O54))","v":{"$error":"#VALUE!"}}]
[null,null,"Travel",9828,null,null,"Adjust for Sponsorship, Awards or other Aid",{"$f":"ROUND((-I38),0)","v":0}]
[null,null,"Personal",19656,null,null,"Total Requested Cost of Attendance",{"$f":"ROUND((SUM(H68:H69)),0)","v":209814},null,"PLUS NEED"]
[null,null,"Other Essential Costs",5058.2,null,null,null,null,null,"Need for PLUS",{"$f":"IF((N66=0),(K60-K64-L68+M64+M68),0)","v":{"$error":"#VALUE!"}}]
[null,null,"Total Cost of Attendance",209814.2]
[null,null,"Adjust for Sponsorship, Awards or other Aid",0]
[{"$f":"IF((D42=\"Private Loan\"),\"Private loan requested\",\"\")","v":""},null,{"$f":"G70","v":"Total Requested Cost of Attendance"},209814,null,null,"Maximum Govt. Loan you can borrow","$",null,"PLUS Available",{"$f":"H5-K64-L68","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF(((SUM(B32:B35))>0),\"As you will be in places not allowed by your government you are not entitled to Federal Loans - only private loans\",\"\")","v":""},null,null,null,"You could have borrowed these Govt. Loans"]
[null,null,{"$f":"IF((A46>0),\"For more information - click on this link to see your government regulations\",\"\")","v":""},{"$f":"IF((A46>0),\"https://ifap.ed.gov/dpcletters/GEN1420.html\",\"\")","v":""},null,null,{"$f":"\"Subsidised adjusted by EFC and prorated to \"&(IF((D31=\"Y\"),(E9*100),(E10*100)))&\"%\"","v":"Subsidised adjusted by EFC and prorated to 450%"},{"$f":"K64","v":0},null,"PLUS Calc",{"$f":"IF((((K71/(100-N55)*100))<K74),((K71/(100-N55)*100)),(((K74+M64+M68)/(100-N55))*100))","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF((A46>0),\"Maximum Private (Sallie Mae) loan we will certify is\",\"\")","v":""},{"$f":"IF((A46>0),H74,\"\")","v":""},null,null,{"$f":"\"Unsubsidised prorated to \"&(IF((D32=\"Y\"),(E9*100),(E10*100)))&\"%\"","v":"Unsubsidised prorated to 450%"},{"$f":"L68","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF((A46>0),\"You must  now go to the Sallie Mae website to apply for your loan. When done, send this form to us, same address as for federal loans, then we can connect to Sallie Mae to certify your application\",\"\")","v":""},null,null,null,{"$f":"IF((J79=2),K79,(IF((H70>H5),\"PLUS Loan to fulfil this CoA\",\"\")))","v":"PLUS Loan to fulfil this CoA"},null,{"$f":"IF((K74<K71),K71,\"\")","v":{"$error":"#VALUE!"}},"Indep Undergrad Score"]
[null,null,{"$f":"IF((A46>0),\"As you will apply for a Sallie Mae loan there is no need to complete anything below this line.\",\" \")","v":" "},null,null,null,{"$f":"IF((J79=2),\"\",\"Maximum PLUS Loan allowed for this CoA\")","v":"Maximum PLUS Loan allowed for this CoA"},{"$f":"IF((J79=2),\"\",(IF((K71<K74),(K71-M68-M64),K74)))","v":{"$error":"#VALUE!"}},null,{"$f":"(IF(AND(D32=\"N\",D31=\"Y\"),1,0))+(IF((D35=\"I\"),1,0))","v":1},"Independent Undergraduates are not eligible for a PLUS Loan"]
[null,null,{"$f":"IF((D42=G12),G75,G74)","v":"Maximum Govt. Loan you can borrow"},null,null,null,"Total Eligible before adjustment for Fees",{"$f":"SUM(H76:H79)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF((D31=\"N\"),L29,G76)","v":"From July 2012 there is no Subsidised Loan for postgraduates"},{"$f":"H76","v":0},{"$f":"IF((N62>0),\"Grossed up for fees\",\"\")","v":""}]
[null,null,{"$f":"G77","v":"Unsubsidised prorated to 450%"},{"$f":"H77","v":{"$error":"#VALUE!"}},{"$f":"IF((N66>0),\"Grossed up for fees\",\"\")","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"G78","v":"PLUS Loan to fulfil this CoA"},null,{"$f":"I78","v":{"$error":"#VALUE!"}},null,null,"Qualify 1","THE COSTS YOU HAVE SUGGESTED ARE TOO HIGH TO BE ACCEPTABLE"]
[null,null,{"$f":"G79","v":"Maximum PLUS Loan allowed for this CoA"},{"$f":"H79","v":{"$error":"#VALUE!"}},null,null,null,"Qualify 2","Provide evidence of your needs for any increase to  PLUS to be considered or borrow less in Section 6"]
[null,null,{"$f":"G80","v":"Total Eligible before adjustment for Fees"},{"$f":"H80","v":{"$error":"#VALUE!"}},null,null,null,"OK Statement","You are allowed to borrow up to the values above"]
[]
[5,null,"SCHOOL COMMENT ON YOUR PROPOSED COSTS & ELIGIBLE LOANS",null,null,null,"Max Loans Allowed Adjusted for Fees","After Origination Fees You Get"]
[null,null,{"$f":"IF(H68>H5, I83,\"  \")","v":"THE COSTS YOU HAVE SUGGESTED ARE TOO HIGH TO BE ACCEPTABLE"},null,null,null,{"$f":"ROUND(K64,0)","v":0},{"$f":"ROUND(((G88*(1-O53))),0)","v":0}]
[null,null,{"$f":"IF(H68>H5, I84,I85)","v":"Provide evidence of your needs for any increase to  PLUS to be considered or borrow less in Section 6"},null,null,{"$f":"IF((D93>A93),(\"You cannot borrow more than  \"&A93),\"\")","v":""},{"$f":"ROUND(L68,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(((G89*(1-O54))),0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,{"$f":"IF((D94>A94),(\"You cannot borrow more than  \"&A94),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF((J79=2),\"\",(ROUND(K76,0)))","v":{"$error":"#VALUE!"}},{"$f":"ROUND(((G90*(1-O55))),0)","v":{"$error":"#VALUE!"}}]
[6,null,{"$f":"IF((D42=G12),\"THIS SECTION DOES NOT APPLY TO SALLIE MAE LOANS\",\"YOU TELL US HOW MUCH WOULD YOU LIKE TO BORROW - YOU MAY REDUCE THE FIGURES IN BLUE\")","v":"YOU TELL US HOW MUCH WOULD YOU LIKE TO BORROW - YOU MAY REDUCE THE FIGURES IN BLUE"},null,null,{"$f":"IF((D95>A95),(\"You cannot borrow more than  \"&ROUND(A95,2)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"SUM(G88:G90)","v":{"$error":"#VALUE!"}},{"$f":"SUM(H88:H90)","v":{"$error":"#VALUE!"}}]
["Max Loans Allowed Adjusted for Fees","Government Fees *** Deducted","State how much you would like to borrow for each loan type - adjust the figures in blue in the \"Your Request\" column","Your Request  -  you may reduce these values","After Origination Fees You Get",{"$f":"IF((E96<>D85),\"Includes $\"&(E96-D85)&\" rounding differences\",\"\")","v":{"$error":"#VALUE!"}},null,"OK Statement 1","We will check everything you have provided with the USDE data and regulations"]
[{"$f":"IF((D42=G12),0,G88)","v":0},{"$f":"O53","v":1.057E-2},{"$f":"C81","v":"From July 2012 there is no Subsidised Loan for postgraduates"},{"$f":"A93","v":0},{"$f":"ROUND(((D93*(1-O53))),0)","v":0},null,null,"OK Statement 2","If everything is correct we will originate your loans and issue a certificate for visa application"]
[{"$f":"IF((D42=G12),0,G89)","v":{"$error":"#VALUE!"}},{"$f":"O54","v":{"$error":"#VALUE!"}},"Unsubsudised",{"$f":"A94","v":{"$error":"#VALUE!"}},{"$f":"ROUND(((D94*(1-O54))),0)","v":{"$error":"#VALUE!"}},null,null,"Qualify 1","You must provide evidence of your costs/needs before we can process your application"]
[{"$f":"IF((D42=G12),0,G90)","v":{"$error":"#VALUE!"}},{"$f":"O55","v":4.2279999999999998E-2},{"$f":"IF((J79=2),K79,\"PLUS Loan (Adjusted up to include all fees)\")","v":"PLUS Loan (Adjusted up to include all fees)"},{"$f":"IF((A95=\"\"),0,((ROUND(A95,0))))","v":{"$error":"#VALUE!"}},{"$f":"ROUND(((D95*(1-O55))),0)","v":{"$error":"#VALUE!"}},null,null,"Qualify 2"]
[{"$f":"IF((D42=G12),0,G91)","v":{"$error":"#VALUE!"}},null,"Total (after rounding, may be slightly higher than total of section 4)",{"$f":"SUM(D93:D95)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E93:E95)","v":{"$error":"#VALUE!"}}]
["7 School Responses",null,{"$f":"IF((D96<(H5*1.04)),I92,I94)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF((D96<(H5*1.04)),I93,I95)","v":{"$error":"#VALUE!"}}]
[]
["8 Government Fees ***",{"$f":"B93","v":1.057E-2},{"$f":"C93&\" Origination Fee of \"&L53&\"% less Interest Rebate of \"&M53&\"%\"","v":"From July 2012 there is no Subsidised Loan for postgraduates Origination Fee of 1.057% less Interest Rebate of 0%"}]
[null,{"$f":"B94","v":{"$error":"#VALUE!"}},{"$f":"C94&\" Origination Fee of \"&L54&\"% less Interest Rebate of \"&M54&\"%\"","v":"Unsubsudised Origination Fee of 1/057% less Interest Rebate of 0%"}]
[null,{"$f":"B95","v":4.2279999999999998E-2},{"$f":"C95&\" Origination Fee of \"&L55&\"% less Interest Rebate of \"&M55&\"%\"","v":"PLUS Loan (Adjusted up to include all fees) Origination Fee of 4.228% less Interest Rebate of 0%"}]
[]
[null,null,"The exchange rate is artificially high to ( hopefully) cover origination fee increases"]