{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Budget Form tab","Program Detail tab","Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":48,"n_cols":1,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Instructions for Completing the Study Abroad Program Budget Template "]
[]
["Complete the budget template in full and upload it into the Faculty-Led Program Renewal section of the UGA GoAbroad Portal. You also may upload other program related materials for review into the Portal.  If you have any questions regarding the budget template, please contact Office of International Education-International Finance via email: oiefinance@uga.edu "]
[]
["The budget template includes two tabs to enter program data. The first is the Budget Form tab. This form will report a summary of the program and all financial needs. The second tab is the Program Details tab. Here, you can enter specific information, detailing the financial needs of the program. "]
[]
["The budget template is designed for ease of use. You will complete only the YELLOW-colored cells with your program budget information. BLUE-colored cells will populate automatically when you complete the yellow-colored cells on the Budget Form tab and on the Program Detail tab.  Data entered into the Program Detail tab will auto sum and populate into the appropriate field on the Budget Form tab. The Budget Form tab is labeled in sections (Section I, Section II, etc.). The Program Detail tab is also labeled in section. The sections on the Program Detail tab correspond to the summary cell on the Budget Form tab. When you enter data into the Program Detail form, the totals will automatically transfer to the appropriate cell on the Budget Form. All other cells are protected."]
[]
["Provide as complete and accurate information as possible. All cells are required to be completed. The budget template will be returned to you if it is not completed in full.  Additionally, please keep in mind that this budget will be compared and analyzed against your actual expenditures upon completion of the program."]
[]
[]
["Section I:"]
["General Program Information:  All general information, including account numbers and contact information, is required.  Use the exact Program name that is recorded in the UGA GoAbroad Portal. "]
["Foreign Currency:  List all currencies which will be used to pay expenses and their current exchange rates. Example 1 USD = 0.8934 EUR"]
[]
["SABD Course Information:  List the correct course number for this program."]
[]
["Academic Courses:   Enter all course ID and title information along with credit hours and the name of the planned teaching faculty for each of the academic courses planned to be offered on the program. If you do not know the name of the faculty, enter TBD into the field. "]
[]
["Program Participation:  Enter the minimum and maximum number of students allowed for this program. List only students paying tuition (student must be enrolled for academic credit). Enter the number of credit hours allowed.  Enter 0 (zero) into the field if no students or credit hours are allowed. "]
["Prepare your budget based on minimum expected enrollment. All instructional and non-instructional costs should be based on the minimum expected enrollment."]
[]
["Section II:"]
["For the Other Instructions Expenditures section, select the Program Detail tab and complete the three sections related to Other Instructional Expenditures: (1) Salaries and Honoraria for Faculty and Guest Speakers/Lecturers names and designation of the appropriate type of payment, (2) Program related expenses for UGA Employees including travel expenses, and (3) miscellaneous Other Instructional Expenditures. "]
[]
["Use the Salaries and Honoraria for Faculty and Guest Speakers/Lecturers section to record all compensation to non-UGA faculty. Any non-UGA employed international teaching Faculty will be required to submit all necessary paperwork for a Faculty appointment.  Use the Travel and Other Expenses for UGA Employees section to record travel expenses for UGA-employed faculty, staff and graduate assistants. Use the Other Instructional Expenditures section to record any other expenses.  Be sure to include a detailed explanation of the expense. "]
[]
["This section with automatically total the expected expenditures in the field labeled Total Other Instructional Expenditures. However, if you will receive support for these type expenditures from your Department or from Other Resources, please enter the total amount of support you expect to receive into the cells labeled Other Instructional Expenses to be supported by Department and Other Instructional Expenditures to be supported by Other Resources, as appropriate. The amount listed as compensation that is supported by the department or other will reduce the total expenditures and automatically populate the Total Other Instructional Expenditures Required to be Support by the Program field. This amount will be used for the Program Fee calculation in Section V.    "]
[]
["If you use the categories Honoraria for Guest Speakers or Honoraria for Guest Speakers-Non-Resident Alien, you must submit the appropriate form to UGA Accounts Payable when submitting the expenses for payment. These forms can be found at www.busfin.uga.edu/forms/. The specific links are http://www.busfin.uga.edu/forms/honoraria_fees_outside.pdf and http://www.busfin.uga.edu/forms/non_emp_payment.pdf."]
[]
[]
["Section III:"]
["Non-Instructional Expenditures:   Use this section to record student program costs. You will be allowed to enter a flat amount into the promotional materials and provider fee cells.  For the specific expenses related students, the budget form will automatically calculate based on the minimum number of students allowed for the program as entered in Section I.  Enter the average cost expected per student in each of these categories. "]
["If you have expenses not listed, use the Program Detail tab section labeled Section IV: Other Non-Instructional Expenditures to detail additional expenses.  Provide a detailed explanation of the expense."]
[]
[]
["Section IV:"]
["Program Fee calculation:  This section prepopulates totals from the previous sections to facilitate calculating the program fee to be charged students.  The Program Fee per student is calculated using the estimated costs and number of students. "]
["·       Enter the amount of Support requested from the Office of International Education. The amount of requested OIE support cannot exceed instructional expenses required to operate program.  OIE may adjust this amount during review to reflect only reasonable qualifying expenses. "]
["·       Enter any External Support you have not previously reported, if any."]
[]
["·       Enter the Deposit you will require per student for this program."]
[]
[]
["Actuals Columns: "]
[]
["These columns, shown as Green-colored cells, are intended to help you track your actual expenditures against your expected budget. This data will be requested of you at the close of your program and is due to the Office of International Education within 60 days of the end of the program. Additionally, you will be asked to produce this data when submitting new budgets for comparable programs in future years."]

{"sheet":"Budget Form tab","index":1,"n_rows":109,"n_cols":8,"rows_kept":109,"cut":false,"hidden":false,"merged":[[67,7,67,8],[57,7,64,9],[49,0,49,3],[32,1,32,3],[74,0,74,1],[50,0,50,3],[51,0,51,3],[52,0,52,3],[53,0,53,3],[55,0,55,3],[54,0,54,3],[40,3,41,6],[98,2,102,3],[14,1,14,2],[32,6,37,6],[60,0,60,3],[61,0,61,3],[63,0,63,2],[64,0,64,2],[73,0,73,1],[77,0,77,1],[48,0,48,3],[75,0,75,1],[76,0,76,1],[4,1,4,5],[33,1,33,3],[34,1,34,3],[35,1,35,3],[20,1,20,2],[21,1,21,2],[23,1,23,2],[30,1,30,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[5,1,5,2],[6,1,6,2],[84,0,84,1],[85,0,85,1],[86,0,86,1],[78,0,78,1],[79,0,79,1],[80,0,80,1],[81,0,81,1],[82,0,82,1],[59,0,59,3],[69,1,69,2],[65,0,65,2],[62,0,62,3],[83,0,83,1],[7,4,7,5],[22,1,22,2],[56,0,56,3],[57,0,57,3],[58,0,58,3],[7,1,7,2],[47,0,47,3],[24,1,24,2],[10,1,10,2],[37,1,37,3],[36,1,36,3],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
["UGA Study Abroad Budget Template ",null,null," "]
["EMBEDDED PROGRAMS FY19"]
[]
["SECTION I","Complete yellow fields. Blue fields will be filled automatically by completing yellow fields on this sheet and on the Program Detail tab."]
["UGA Study Abroad Program Name and Location:"]
["Term:","Fall 2018"]
["Program Begins: First meeting with enrolled students"]
["Program Ends: Last meeting with enrolled students or final project due date",null,null,null,"FOR OIE USE"]
["Travel Begins: ",null,"Number of Travel Days",null,"Prelim Budget Reviewed"]
["Travel Ends:",null,{"$f":"+B10-B9+1","v":1},null,"Prelim Allocation Allowed"]
["Program Director:",null,null,null,"Final Budget Approved"]
["Director's Phone:",null,null,null,"Final Allocation"]
["Director's E-Mail:",null,null,null,"Final SABD Amount",{"$f":"B106","v":{"$error":"#DIV/0!"}}]
["Department Name:"," ",null,null,"Deposit",{"$f":"B105","v":200}]
["Department Number:"]
["Destination/Destinations:"]
["Business Manager:"]
["Manager's Phone:"]
["Manager's E-Mail:"]
["Course Scheduler:"," "]
["Scheduler's Phone:"]
["Scheduler's E-Mail:"]
["Project ID for PS (assigned by OIE Finance)"]
["Tuition/In-Service Account No. (legacy 1011GVxxxxxx)"]
["Departmental Sales & Service Acct Number ( legacy 1011DVxxxxxx)"]
[]
["Foreign Currency   (Example 1 USD = 0.8934 EUR)","Currency Name","Exchange Rate"]
["     Currency #1"]
["     Currency #2"]
[]
["SABD Course #"," "]
[]
["Academic Course(s) Information","Course ID & Title",null,null,"Name of Faculty Teaching","Credit Hours"," "]
["       1 Course ID & Title"]
["       2 Course ID & Title"]
["       3 Course ID & Title"]
["       4 Course ID & Title"]
["Total Number of Courses Offered",null,null,null,null,{"$f":"SUM(F34:F37)","v":0}]
[null,null,null,null,null," "]
["Program Participation  *All students must be enrolled for academic credit.","Minimum #","Maximum #"]
["Total Number of Undergraduate Participants in the Program",0,null,"Group size must be at least 15 students, and no more than 30, and courses must meet UGA and BOR contact hour policies.",null,null,null," "]
["Total Number of Credits Taken by Each Undergrad Student",0]
["Total Number of Graduate Participants in the Program",0,null," "]
["Total Number of Credits Taken by Each Grad Student",0,null,null," "]
[]
[]
["SECTION II","Complete yellow fields. Blue fields will be filled automatically by completing yellow fields on this sheet and on the Program Detail tab."]
["Instructional Expenditures"]
["For this section, complete the corresponding section on the Program Detail tab to list travelers and their expense.",null,null,null,"# of Persons","Total"]
["Salaries and Honoraria for Faculty and Guest Speakers/Lecturers:"]
["International Teaching Faculty's Salaries  (requires Faculty Appointment)",null,null,null,{"$f":"'Program Detail tab'!C25","v":0},{"$f":"'Program Detail tab'!C24","v":0}]
["International Teaching Faculty's Salaries-Non-Resident Alien",null,null,null,{"$f":"'Program Detail tab'!D25","v":0},{"$f":"'Program Detail tab'!D24","v":0}]
["Honoraria for Guest Speakers (Proper accounts payable form must be submitted. See instructions.)",null,null,null,{"$f":"'Program Detail tab'!E25","v":0},{"$f":"+'Program Detail tab'!E24","v":0}]
["Honoraria for Guest Speakers-Non-Resident Alien (Proper accounts payable form must be submitted. See instructions.)",null,null,null,{"$f":"'Program Detail tab'!F25","v":0},{"$f":"+'Program Detail tab'!F24","v":0}]
["Travel and Other Expenses for UGA Employees:"]
["International Airfare ",null,null,null,{"$f":"'Program Detail tab'!C51","v":0},{"$f":"+'Program Detail tab'!C50","v":0}]
[" International Hotel/Accommodations",null,null,null,{"$f":"'Program Detail tab'!D51","v":0},{"$f":"+'Program Detail tab'!D50","v":0}]
[" International Meals ",null,null,null,{"$f":"'Program Detail tab'!E51","v":0},{"$f":"+'Program Detail tab'!E50","v":0}]
["International Transportation ",null,null,null,{"$f":"'Program Detail tab'!F51","v":0},{"$f":"+'Program Detail tab'!F50","v":0}]
["Visa/Exit Fees",null,null,null,{"$f":"'Program Detail tab'!G51","v":0},{"$f":"+'Program Detail tab'!G50","v":0}]
["Study Abroad Insurance ($1.28/day)",null,null,null,{"$f":"'Program Detail tab'!H51","v":0},{"$f":"'Program Detail tab'!H50","v":0}]
["Entrance to Educational Venues - International: UGA Faculty & Staff (UGA-hired and Other) ",null,null,null,{"$f":"'Program Detail tab'!I51","v":0},{"$f":"'Program Detail tab'!I50","v":0}]
["Classroom Rental (Enter Total Amount)",null,null,null," "," "]
[null,null,null,"# of Persons","Amount","Total"]
["Entrance to Educational Venues - International: Students",null,null,{"$f":"B41+B43","v":0},null,{"$f":"E65*D65","v":0}]
["     Other Instructional Expenses - If you use this category, complete the corresponding section on the Program Detail tab.",null,null," ",null,{"$f":"'Program Detail tab'!D76","v":0}]
["Total  Other Instructional Expenditures ",null,null,null," ",{"$f":"SUM(F51:F66)","v":0},"Program Support"]
["     Other Instructional Expenses to be supported by Department",null,null,null,"Enter total amount received in support from department for Instructional Expenses Only",0,"Dept Support"," "]
["Total Other Instructional Expenditures  Required to be Supported by Program",null,null,null," ",{"$f":"F67-F68","v":0}," "]
[null," ",null," "," "]
[]
[]
["SECTION III","Complete yellow fields. Blue fields will be filled automatically by completing yellow fields on this sheet and on the Program Detail tab."]
["Non-Instructional Expenditures"]
["Description",null,null,"Amount per Student","# of Students"]
["     (74201) Promotional Materials ",null,null,null,{"$f":"B41+B43","v":0},{"$f":"+D76*E76","v":0}]
["     (72765) Provider Fee: Provide copy of agreement, subject to approval. Upload into Terra Dotta.",null,null,null,{"$f":"B41+B43","v":0},0]
["     (71400) International Phone ",null," ",null,{"$f":"B41+B43","v":0},{"$f":"+D78*E78","v":0}]
["     (71400) International Airfare",null,null,null,{"$f":"B41+B43","v":0},0]
["     (71400) International Transportation",null,null,null,{"$f":"B41+B43","v":0},0]
["     (71400) International Hotel/Accommodations",null,null,null,{"$f":"B41+B43","v":0},0]
["     (71400) Meals",null," ",null,{"$f":"B41+B43","v":0},0]
["     (71400) Entrance Fees- Cultural/Non-Educational",null,null,null,{"$f":"B41+B43","v":0},0]
["     (71400) Visa/Passport/Exit Fees",null,null,null,{"$f":"B41+B43","v":0},0]
["     (72000) Study Abroad Insurance ($1.25/day) plus 2 days",null,null,{"$f":"1.25*(C10+2)","v":3.75},{"$f":"B41+B43","v":0},{"$f":"E85*D85","v":0}]
["     Other - If you use this category, complete the corresponding section on the Program Detail tab.",null,null," "," ",{"$f":"'Program Detail tab'!D101","v":0}]
["Total Non-Instructional Expenditures to be Supported by Program",null,null,null,null,{"$f":"SUM(F76:F86)","v":0}]
[" "]
[]
["SECTION IV","Complete yellow fields. Blue fields will be filled automatically by completing yellow fields on this sheet and on the Program Detail tab."]
["Program Fee Calculation"]
["Budgeted Expenses"]
["     Other Instructional Expenditures supported by Program",{"$f":"+F69","v":0}]
["     Non-Instructional Expenditures",{"$f":"F87","v":0}]
["Total Budgeted Expenses",{"$f":"SUM(B93:B94)","v":0}]
[]
["Revenues (excluding Program Fees)"]
["    OIE SUPPORT ALLOCATION",0," "]
["     Departmental Support",{"$f":"F68","v":0}," "]
["    Other External Support (not reported above)",0]
["Total Revenues (excluding Program Fees)",{"$f":"SUM(B98:B100)","v":0}]
["Total Program Fees Needed",{"$f":"+B95-B101","v":0}]
[]
["Estimated Program Fee per Student",{"$f":"(+B102)/(B41+B43)","v":{"$error":"#DIV/0!"}}]
["Less Required Deposit (per Student) $200 for Embedded Programs",200]
["Amount to be billed as program fee to students \"SABD\"",{"$f":"+B104-B105","v":{"$error":"#DIV/0!"}}]
[]
[" "]
[" "]

{"sheet":"Program Detail tab","index":2,"n_rows":101,"n_cols":9,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,0,0,5],[75,0,75,2],[52,0,52,3],[78,0,78,3],[26,0,26,8],[1,0,1,5]]}
["Sections listed below correspond with Sections on Budget Form Tab. The data entered in the yellow-colored cells will automatically sum and populate in the appropriate cell on the Budget Form tab."]
["Section III: Salaries and Honoraria for Faculty and Guest Speakers/Lecturers"]
["Name of Non-UGA Faculty or Guest Speaker","Dates of Travel","Amount International Teaching Faculty's Salaries (requires Faculty Appointment) ","International Teaching Faculty's Salaries-Non-Resident Alien ","Honoraria for Guest Speakers  ","Honoraria for Guest Speakers-Non-Resident Alien "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" ",null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[]
[]
[]
[]
["TOTAL EXPENSE TO BUDGET FORM",null,{"$f":"SUM(C4:C23)","v":0},{"$f":"SUM(D4:D23)","v":0},0,0]
["COUNT",null,{"$f":"COUNT(C4:C23)","v":0},{"$f":"COUNT(D4:D23)","v":0},0,0]
[]
["Section III:  Travel and Other Expenses for UGA Employees "]
["Name of UGA Employees           (Faculty, GA or Staff)","Dates of Travel","International Airfare (64200)","International Hotel/Accomodations     (64200)","International Meals (64200)","International Transportation (64200)","Visa/Exit Fees (64200)","SA Insurance (Please use caluculation of $1.25/per travel day + 2 days) (72000)","Entrance Fees to Educational Venues - International    (72714)"]
["c"]
[]
["v"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TOTAL EXPENSE TO BUDGET FORM",null,{"$f":"SUM(C29:C49)","v":0},{"$f":"SUM(D29:D49)","v":0},0,0,0,0,{"$f":"SUM(I29:I49)","v":0}]
["COUNT",null,{"$f":"COUNT(C29:C49)","v":0},0,0,0,0,0,0]
[]
["Section III: Other Instructional Expenditures "]
["Explanation of Expense","#                                    (you must enter a number here for calculation)","Amount","Total"]
[null,null,null,{"$f":"C55*B55","v":0}]
[null,null,null,{"$f":"C56*B56","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"C65*B65","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["TOTAL EXPENSE TO BUDGET FORM",null,null,{"$f":"SUM(D55:D75)","v":0}]
["COUNT",null,null,{"$f":"COUNT(B55:B75)","v":0}]
[]
["Section IV: Other Non-Instructional Expenditures "]
["Explanation","#                                    (you must enter a number here for calculation)","Amount","Total"]
["Credit Card Fee (per student deposit)",null,10,{"$f":"C81*B81","v":0}," "]
["Contingency",null,null,{"$f":"C82*B82","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["TOTAL EXPENSE TAKE TO BUDGET FORM",null," ",{"$f":"SUM(D81:D100)","v":0}]

{"sheet":"Sheet1","index":3,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
["D","department support"]
["P","program support"]

{"sheet":"Sheet2","index":4,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Fall 2018"]
["Spring 2019"]
["Maymester 2019"]
["Summer 2019"]

{"sheet":"Sheet3","index":5,"n_rows":81,"n_cols":6,"rows_kept":81,"cut":false,"hidden":true,"merged":[[3,1,3,5],[0,1,0,5]]}
[null,"ACTUAL EXPENDITURES"]
[null,"Actual Students"]
[null," "]
[null,"To be completed within 60 days of Program end date"]
[null,"GV Actual Expenses","DV Actual Expenses","Other Dept Account         Actual Expenses","Variance","Comments"]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B6:D6)","v":{"$error":"#REF!"}}]
[null," ",null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B7:D7)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B8:D8)","v":{"$error":"#REF!"}},"  "]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B9:D9)","v":{"$error":"#REF!"}}," "]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B10:D10)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B11:D11)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B12:D12)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B13:D13)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B14:D14)","v":{"$error":"#REF!"}}]
[null,{"$f":"SUMIF('Budget Form tab'!#REF!,\"D\",B6:B14)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"D\",C6:C14)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"D\",D6:D14)","v":{"$error":"#REF!"}},{"$f":"-'Budget Form tab'!#REF!+SUM(B15:D15)","v":{"$error":"#REF!"}}]
[null,{"$f":"SUMIF('Budget Form tab'!#REF!,\"Other\",B6:B14)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"Other\",C6:C14)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"Other\",D6:D14)","v":{"$error":"#REF!"}},{"$f":"-'Budget Form tab'!#REF!+SUM(B16:D16)","v":{"$error":"#REF!"}}]
[null,{"$f":"SUMIF('Budget Form tab'!#REF!,\"P\",B6:B14)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"P\",C6:C14)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"P\",D6:D14)","v":{"$error":"#REF!"}},{"$f":"-'Budget Form tab'!#REF!+SUM(B17:D17)","v":{"$error":"#REF!"}}]
[]
[null,"GV Actual Expenses","DV Actual Expenses","Other Dept Account         Actual Expenses","Variance","Comments"]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B20:D20)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B21:D21)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B22:D22)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B23:D23)","v":{"$error":"#REF!"}}]
[null,{"$f":"SUMIF('Budget Form tab'!#REF!,\"D\",B20:B23)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"D\",C20:C23)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"D\",D20:D23)","v":{"$error":"#REF!"}},{"$f":"-'Budget Form tab'!#REF!+SUM(B24:D24)","v":{"$error":"#REF!"}}]
[null,{"$f":"SUMIF('Budget Form tab'!#REF!,\"Other\",B20:B23)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"Other\",C20:C23)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"Other\",D20:D23)","v":{"$error":"#REF!"}},{"$f":"-'Budget Form tab'!#REF!+SUM(B25:D25)","v":{"$error":"#REF!"}}]
[null,{"$f":"SUMIF('Budget Form tab'!#REF!,\"P\",B20:B23)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"P\",C20:C23)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"P\",D20:D23)","v":{"$error":"#REF!"}},{"$f":"-'Budget Form tab'!#REF!+SUM(B26:D26)","v":{"$error":"#REF!"}}]
[]
[null,"GV Actual Expenses","DV Actual Expenses","Other Dept Account         Actual Expenses","Variance","Comments"]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B29:D29)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B30:D30)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B31:D31)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B32:D32)","v":{"$error":"#REF!"}}]
[null,{"$f":"SUMIF('Budget Form tab'!#REF!,\"D\",B29:B32)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"D\",C29:C32)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"D\",D29:D32)","v":{"$error":"#REF!"}},{"$f":"-'Budget Form tab'!#REF!+SUM(B33:D33)","v":{"$error":"#REF!"}}]
[null,{"$f":"SUMIF('Budget Form tab'!#REF!,\"Other\",B29:B32)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"Other\",C29:C32)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"Other\",D29:D32)","v":{"$error":"#REF!"}},{"$f":"-'Budget Form tab'!#REF!+SUM(B34:D34)","v":{"$error":"#REF!"}}]
[null,{"$f":"SUMIF('Budget Form tab'!#REF!,\"P\",B29:B32)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"P\",C29:C32)","v":{"$error":"#REF!"}},{"$f":"SUMIF('Budget Form tab'!#REF!,\"P\",D29:D32)","v":{"$error":"#REF!"}},{"$f":"-'Budget Form tab'!#REF!+SUM(B35:D35)","v":{"$error":"#REF!"}}]
[null,{"$f":"+B35+B26+B17","v":{"$error":"#REF!"}},{"$f":"+C35+C26+C17","v":{"$error":"#REF!"}},{"$f":"+D35+D26+D17","v":{"$error":"#REF!"}},{"$f":"+E35+E26+E17","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"GV Actual Expenses","DV Actual Expenses","Other Dept Account         Actual Expenses","Variance","Comments"]
[]
[null,null,null,null,{"$f":"-'Budget Form tab'!F51+SUM(B42:D42)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F52+SUM(B43:D43)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F53+SUM(B44:D44)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F54+SUM(B45:D45)","v":0}]
[null,null,null,null," "]
[null,null,null,null,{"$f":"-'Budget Form tab'!F56+SUM(B47:D47)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F57+SUM(B48:D48)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F58+SUM(B49:D49)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F59+SUM(B50:D50)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F60+SUM(B51:D51)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F61+SUM(B52:D52)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F62+SUM(B53:D53)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F63+SUM(B54:D54)","v":{"$error":"#VALUE!"}}]
[null,null,null,null," "]
[null,null," ",null,{"$f":"-'Budget Form tab'!F65+SUM(B56:D56)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F66+SUM(B57:D57)","v":0}]
[null,null,null,null," "]
[null,null,null,null," "]
[null,null,null,null," "]
[null,{"$f":"SUM(B41:B60)","v":0},{"$f":"SUM(C41:C60)","v":0},{"$f":"SUM(D41:D60)","v":0},{"$f":"SUM(E41:E60)","v":{"$error":"#VALUE!"}}]
[null," ",null,null," "]
[null,{"$f":"SUM(B61,B36)","v":{"$error":"#REF!"}},{"$f":"SUM(C61,C36)","v":{"$error":"#REF!"}},{"$f":"SUM(D61,D36)","v":{"$error":"#REF!"}},{"$f":"SUM(E61,E36)","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[null,"GV Actual Expenses","DV Actual Expenses","Other Dept Account         Actual Expenses","Variance","Comments"]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B69:D69)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"-'Budget Form tab'!#REF!+SUM(B70:D70)","v":{"$error":"#REF!"}}]
[null,null,null,null," "]
[null,null,null,null," "]
[null,null,null,null,{"$f":"-'Budget Form tab'!F78+SUM(B73:D73)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F79+SUM(B74:D74)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F80+SUM(B75:D75)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F81+SUM(B76:D76)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F82+SUM(B77:D77)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F83+SUM(B78:D78)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F84+SUM(B79:D79)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F85+SUM(B80:D80)","v":0}]
[null,null,null,null,{"$f":"-'Budget Form tab'!F86+SUM(B81:D81)","v":0}]