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

{"sheet":"Sheet1","index":0,"n_rows":134,"n_cols":8,"rows_kept":134,"cut":false,"hidden":false,"merged":[[0,0,0,7],[19,0,20,0],[19,4,20,4],[19,6,20,6],[9,0,9,7],[10,4,11,4],[10,6,11,6],[10,0,11,0],[23,0,23,7],[13,0,14,0],[13,2,14,2],[13,4,14,4],[13,6,14,6],[16,0,17,0],[16,6,17,6],[16,4,17,4],[24,0,25,0],[24,4,25,4],[24,6,25,6],[27,0,28,0],[27,4,28,4],[27,6,28,6],[61,0,62,0],[61,4,62,4],[61,6,62,6],[48,2,49,2],[48,4,49,4],[52,0,53,0],[52,2,53,2],[52,4,53,4],[52,6,53,6],[30,5,30,7],[42,5,42,7],[47,0,47,7],[55,5,55,7],[60,0,60,7],[35,0,35,7],[36,0,37,0],[36,2,37,2],[36,4,37,4],[36,6,37,6],[39,0,40,0],[39,2,40,2],[39,4,40,4],[39,6,40,6],[48,6,49,6],[54,0,54,7],[81,0,81,7],[65,0,65,5],[66,0,66,5],[67,0,67,5],[68,0,68,5],[69,0,69,5],[70,0,70,5],[71,0,71,5],[72,0,72,5],[73,0,73,5],[74,0,74,5],[76,5,76,7],[98,3,98,5],[99,3,99,5],[100,3,100,5],[6,0,6,7],[104,0,104,7],[7,0,7,7],[64,0,64,5],[50,0,50,7],[48,0,49,0],[95,3,95,5],[96,3,96,5],[97,3,97,5],[84,4,85,4],[84,6,85,6],[84,0,85,0],[89,5,89,7],[122,0,122,7],[105,0,105,7],[107,0,108,0],[107,4,108,4],[107,6,108,6],[112,4,113,4],[112,6,113,6],[112,0,113,0],[117,0,117,7],[118,0,118,7],[120,0,121,0],[120,4,121,4],[120,6,121,6],[130,3,130,5],[131,3,131,5],[132,3,132,5],[133,3,133,5],[126,0,126,7]]}
["Use the worksheet below to submit an estimated budget for the proposed mature Brock Experience. It is important to remember that these numbers will be estimates and are not considered final. They should, however, be well-researched and informed rather than speculative. When possible, numbers should be rounded up to the nearest whole number. Once complete, use the button below to export this worksheet as a pdf to attach to the completed application. You must enable macros for this worksheet to function properly."]
[]
["Number of Team Member"]
["Number of Students"]
["Nights staying in the field"]
[]
["Program Costs"]
["The first section of this budget form will help calculate the total cost of the program, regardless of funding sources. If information does not align with the provided categories, include it in the miscellaneous section for consideration. "]
[]
["Travel to/from Location"]
["Faculty/Staff airfare",null,null,"Per person","*","Team members","=","Total   "]
[null,null,null,null,null,{"$f":"B3","v":0},null,{"$f":"D12*F12","v":0}]
[]
["Mileage to/from airport ($.50/mile)","Miles","*","Rate","*","Cars","=","Total   "]
[null,null,null,0.5,null,null,null,{"$f":"B15*D15*F15","v":0}]
[]
["Baggage fees","Per person",null,"Roundtrip","*","Team members","=","Total   "]
[null,null,null,2,null,{"$f":"B3","v":0},null,{"$f":"F18*D18*B18","v":0}]
[]
["Airport parking",null,null,"Per person","*","Cars","=","Total   "]
[null,null,null,null,null,null,null,{"$f":"D21*F21","v":0}]
[]
[]
["Travel in Location"]
["Rental cars\n(assumes 8 to a car)",null,null,"Per car","*","# of cars","=","Total   "]
[null,null,null,null,null,{"$f":"ROUNDUP((B3+B4)/8, 0)","v":0},null,{"$f":"D26*F26","v":0}]
[]
["Public transportation",null,null,"Per person","*","People","=","Total   "]
[null,null,null,null,null,{"$f":"(B3+B4)","v":0},null,{"$f":"D29*F29","v":0}]
[]
[null,null,null,null,null,"                               Total from travel"]
[null,null,null,null,null,null,null,{"$f":"H12+H15+H18+H21+H26+H29","v":0}]
[]
[]
[]
["Lodging"]
["Faculty/Staff\n(assuming sharing)","Per room","*","Nights","*","Team members/2","=","Total   "]
[null,null,null,{"$f":"B5","v":0},null,{"$f":"ROUNDUP(B3/2, 0)","v":0},null,{"$f":"B38*D38*F38","v":0}]
[]
["Students\n(students per room below)","Per room","*","Nights","*",{"$f":"IF($B$43=\"\", \"Enter divisor\", CONCATENATE(\"Students/\", $B$43))","v":"Students/4"},"=","Total   "]
[null,null,null,{"$f":"B5","v":0},null,{"$f":"ROUNDUP(B4/B43,0)","v":0},null,{"$f":"B41*D41*F41","v":0}]
[]
["Students per room",4,null,null,null,"                            Total from lodging"]
[null,null,null,null,null,null,null,{"$f":"H41+H38","v":0}]
[]
[]
[]
["Meals"]
["Team meals","Per diem","*","Team members","*","Nights","=","Total   "]
[null,null,null,{"$f":"B3","v":0},null,{"$f":"B5","v":0},null,{"$f":"B50*D50*F50","v":0}]
["Use the rates found here for your particular location. https://www.gsa.gov/travel/plan-a-trip/per-diem-rates/per-diem-files"]
[]
["Student meals","Per diem*2/3","*","Students","*","Nights","=","Total   "]
[null,{"$f":"B50*0.6666","v":0},null,{"$f":"B4","v":0},null,{"$f":"B5","v":0},null,{"$f":"B54*D54*F54","v":0}]
["NOTE: This formula calculates 2/3 of the per diem rate entered for the team meals. Students are told an average of two meals a day will be covered by their program fee."]
[null,null,null,null,null,"                              Total from meals"]
[null,null,null,null,null,null,null,{"$f":"H54+H50","v":0}]
[]
[]
[]
["Activities and Miscellaneous"]
["Student scholarship support\n(assumes half apply)",null,null,"# of students/2","*","Avg. schol. Amount","=","Total   "]
[null,null,null,{"$f":"B4/2","v":0},null,1000,null,{"$f":"D63*F63","v":0}]
[]
["Activities, entrance fees, etc. (Detail them below)",null,null,null,null,null,null,"Total   "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"       Total from activities and misc."]
[null,null,null,null,null,null,null,{"$f":"H63+SUM(H66:H75)","v":0}]
[]
[]
[]
["Compensation"]
["Faculty lead"]
[]
["Team members \n(see compensation guidance document)",null,null,"Instructional faculty","*","Summer pay","=","Total   "]
[null,null,null,null,null,3800,null,{"$f":"F86*D86","v":0}]
[]
["Misc. honoraria"]
[]
[null,null,null,null,null,"               Total from compensation"]
[null,null,null,null,null,null,null,{"$f":"H83+H86+H88","v":0}]
[]
[]
[]
[]
[null,null,null,"Total from travel",null,null,null,{"$f":"H32","v":0}]
[null,null,null,"Total from lodging",null,null,"+",{"$f":"H44","v":0}]
[null,null,null,"Total from meals",null,null,"+",{"$f":"H57","v":0}]
[null,null,null,"Total from activities",null,null,"+",{"$f":"H78","v":0}]
[null,null,null,"Total from compensation",null,null,"+",{"$f":"H91","v":0}]
[null,null,null,"Total cost of program",null,null,null,{"$f":"SUM(H96:H100)","v":0}]
[]
[]
[]
["Student Costs"]
["This section will help calculate the approximate total cost for the student before any scholarship support. This will help keep the total cost of the Brock Experience in mind for planning purposes."]
[]
["Tution",null,null,"Per credit hour (summer)","*","Course credits","=","Total   "]
[null,null,null,null,null,3,null,{"$f":"D109*F109","v":0}]
[]
["Airfare/Transportation"]
[]
["Program fee",null,null,"Total cost of program","/","Students","=","Program fee   "]
[null,null,null,{"$f":"H101","v":0},null,{"$f":"B4","v":0},null,{"$f":"D114/F114","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Funding Sources"]
["This section will help determine how much budget support is needed from the University. These funds may be secured from the Brock Endowment, Academic Affairs, or other sources. If the course is approved for delivery, funds will be allocated from appropriate sources."]
[]
["Program fee revenue",null,null,"Students","*","Program fee","=","Total   "]
[null,null,null,{"$f":"B4","v":0},null,{"$f":"IF(H114>900, 900, H114)","v":{"$error":"#DIV/0!"}},null,{"$f":"D122*F122","v":{"$error":"#DIV/0!"}}]
["NOTE: The formula used here would represent the students program fee supporting 100% of the costs of the course. Best practice is to keep program fees under $900. If the program fee calculated previously exceeds this amount, the maximum of $900 will be shown."]
[]
["Course specific funds (i.e. Foundation accounts or fundraising)"]
["Explain nature of funds:"]
[]
[]
[]
[]
[null,null,null,"Total cost of program",null,null,null,{"$f":"H101","v":0}]
[null,null,null,"Program fee revenue",null,null,"-",{"$f":"H122","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Course funds",null,null,"-",{"$f":"H125","v":0}]
[null,null,null,"Total balance needed",null,null,null,{"$f":"H131-H132-H133","v":{"$error":"#DIV/0!"}}]