{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Page 1","Page 2","Page 3"," Intro & Notes","Pg 1 Cost-centre codes"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":8,"comments":35,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Page 1","index":0,"n_rows":192,"n_cols":19,"rows_kept":192,"cut":false,"hidden":false,"merged":[[1,4,1,7],[2,4,2,7],[3,4,3,7],[4,4,4,7],[36,6,36,7],[38,8,38,9],[38,6,38,7],[38,4,38,5],[12,3,12,4],[23,4,23,5],[41,6,41,7],[39,8,39,9],[41,8,41,9],[39,6,39,7],[46,8,46,9],[39,4,39,5],[42,8,42,9],[42,6,42,7],[38,1,39,2],[51,3,51,5],[50,3,50,5],[41,4,41,5],[42,4,42,5],[46,3,46,5],[49,3,49,5],[36,1,36,2],[14,5,14,9],[35,1,35,9],[22,8,22,9],[23,8,23,9],[21,4,21,9],[22,4,22,5],[18,4,20,9],[36,8,36,9],[36,4,36,5],[17,4,17,9],[13,6,13,7],[13,3,13,4],[12,6,12,7],[10,3,10,4],[11,3,11,4],[10,6,10,7],[11,6,11,7]],"flags":["formulas_cached_only"]}
[]
[null,"University of Glasgow",null,null,"CPD - Event Details",{"$nulls":4},"INTERNAL USE ONLY"]
[null,"Page 1 of 3",null,null,"CONFIDENTIAL"]
[{"$nulls":4},"Please send to "]
[{"$nulls":4},"Research Support Office,Awards team,300 Bath Street,Glasgow.G2 4LH"]
[null,"To be used for Non-accredited CPD courses, Conferences, and other Short Courses"]
[null,"N.B. Please read the accompanying 'Introduction and Completion Notes' (tab below) BEFORE completing. "]
[null,"         ENTER INFORMATION IN WHITE AREAS ONLY",{"$nulls":5},"  Research System project no. (Note 1.1)"]
[null,"Applicant/s (Note 1.2)",null,null,null," ",null,null," "]
[null,null,"Title, Initials, Surname",null,null,"School / RI","College",null,"Phone","GU Ownership %"]
[null,"Budget Holder"]
[null,"Organiser"]
[]
[]
[null,"Contact e-mail address "]
[]
[null,"Event Details"]
[null,"TITLE:"]
[null,"AIMS:","(Note 1.3)"]
[]
[]
[null,"Is it a conference?",{"$nulls":8},0]
[null,"If it is a course, is it Accredited?",{"$nulls":4},"On-Campus?",null,null,null,0,0]
[null,"Proposed Start Date",{"$nulls":4},"Proposed End Date"]
[]
[null,"Authorisation (Note 1.6)",{"$nulls":7},"Scenario  1"]
[{"$nulls":4},"Summary of Costs (will enter automatically after page 2 has been completed)"]
[null,"Staff Costs",{"$nulls":7},0]
[null,"Other Direct Costs",{"$nulls":7},0]
[null,"Indirect Costs - Net",{"$nulls":7},0]
[null,"FULL ECONOMIC COSTS",{"$nulls":7},0]
[{"$nulls":9},0]
[null,"Net Costs - to be met by Income",{"$nulls":7},0]
[null,"Income",{"$nulls":7},0]
[null,"NET SURPLUS (£) / DEFICIT (-£) (If deficit, state here Agresso Project to cover)",{"$nulls":6},"Agresso Project",0]
[null,"I agree to return the required data to the University central administration for its transmission to the Government agencies and other statutory bodies. Signature by Head of School/RI and Head of College imply that this proposal has received both academic and financial  (based on costs identified on P2 and summarised above)  approval at the School/RI and Collage level."]
[null,"Applicant",null,"SIGNATURE"]
[null,"Publicity",null,"DATE","00:00:00",null,"00:00:00",null,"00:00:00"]
[null,"School / \nResearch Institute",null,"PRINT NAME"]
[null,null,null,"SIGNATURE"]
[null,null,null,"DATE","00:00:00",null,"00:00:00",null,"00:00:00"]
[null,"College",null,"PRINT NAME"]
[null,null,null,"SIGNATURE"]
[null,null,null,"DATE","00:00:00",null,"00:00:00",null,"00:00:00"]
[]
[null,"Data collection (please click on boxes then select category from drop-down menu on right)",{"$nulls":5}," (Note 1.7)"]
[null,"Purpose (Note 1.8)    11/",{"$nulls":4},"   Target Group                   14/","14/ "]
[]
[null,"For R&E use only"]
[null,"Categorization"]
[null,"Date Passed to Finance"]
[null,"Finance System project"]
[null,"(Note 1.9)"]
[]
["Yes"]
["No"]
[]
["Organization:",null,null,9]
[null," ",null,null,null," "]
["00 Not organised jointly",{"$nulls":4},"00 Not organised jointly "]
["01 Through a subsidiary company of the University ",{"$nulls":4},"01 Through a subsidiary company of the University  "]
["02 With other HEI(s)",{"$nulls":4},"02 With other HEI(s) "]
["04 With FE institution(s)",{"$nulls":4},"04 With FE institution(s) "]
["05 With local authorities",{"$nulls":4},"05 With local authorities "]
["06 With a professional body/bodies",{"$nulls":4},"06 With a professional body/bodies "]
["07 With Workers Educational  Assoc",{"$nulls":4},"07 With Workers Educational  Assoc "]
["08 With an employer or employers",{"$nulls":4},"08 With an employer or employers "]
["09 With a TEC or LEC",{"$nulls":4},"09 With a TEC or LEC "]
["10 With the EU/EC or a European public body",{"$nulls":4},"10 With the EU/EC or a European public body "]
["18 With combinations of the above",{"$nulls":4},"18 With combinations of the above "]
["19 With any other body",{"$nulls":4},"19 With any other body "]
["999 On behalf of another body (minimal GU involvement)",{"$nulls":4},"999 On behalf of another body (minimal GU involvement) "]
[]
[]
[]
[]
["Course Level:"]
["1 HE/advanced",{"$nulls":4},"1 HE/advanced "]
["2 FE/non-advanced/access",{"$nulls":4},"2 FE/non-advanced/access "]
["3 Mixed HE/FE",{"$nulls":4},"3 Mixed HE/FE "]
[]
["Purpose:",null,11]
[]
["01 INSETT (primary) ",{"$nulls":4},"01 INSETT (primary)  "]
["02 INSETT (secondary) ",{"$nulls":4},"02 INSETT (secondary)  "]
["03 INSETT (FE) ",{"$nulls":4},"03 INSETT (FE)  "]
["04 INSETT (other / combinations) ",{"$nulls":4},"04 INSETT (other / combinations)  "]
["10 Continuing Professional  Development (CPD)",{"$nulls":4},"10 Continuing Professional  Development (CPD) "]
["11 Other vocational & professional  updating",{"$nulls":4},"11 Other vocational & professional  updating "]
["21 Liberal adult education ",{"$nulls":4},"21 Liberal adult education  "]
["31 Access (validated) ",{"$nulls":4},"31 Access (validated)  "]
["32 Access (not validated) ",{"$nulls":4},"32 Access (not validated)  "]
["99 Other PG Certificate"]
["99 Other PG Diploma"]
["99 Other PG Masters"]
["99 Other Accredited CPD"]
[{"$nulls":5}," "]
[{"$nulls":5}," "]
["Principal source of funding: ",null,null,12,null,"Principal source of funding:  "]
["03 SHEFC",{"$nulls":4},"03 SHEFC "]
["91 Funded entirely by participants'  fees (including fees paid by employer)",{"$nulls":4},"91 Funded entirely by participants'  fees (including fees paid by employer) "]
[" Other -please specify - below",{"$nulls":4}," Other -please specify - below "]
[{"$nulls":5}," "]
["Fee level:",null,null,13,null,"Fee level: "]
["1 Full cost recovery",{"$nulls":4},"1 Full cost recovery "]
["2 Part cost recovery",{"$nulls":4},"2 Part cost recovery "]
["3 No cost recovery",{"$nulls":4},"3 No cost recovery "]
[]
["Primary target group:       "]
["10 General public ",{"$nulls":4},"10 General public  "]
["11 European Community ",{"$nulls":4},"11 European Community  "]
["12 Other overseas ",{"$nulls":4},"12 Other overseas  "]
["13 Professional groups/ employees ",{"$nulls":4},"13 Professional groups/ employees  "]
["14 Glasgow University employees ",{"$nulls":4},"14 Glasgow University employees  "]
["20 Unemployed ",{"$nulls":4},"20 Unemployed  "]
["21 Ethnic minorities ",{"$nulls":4},"21 Ethnic minorities  "]
["22 Disabled ",{"$nulls":4},"22 Disabled  "]
["29 Disadvantaged groups (not specified) ",{"$nulls":4},"29 Disadvantaged groups (not specified)  "]
["90 Other, & combinations of the above",{"$nulls":4},"90 Other, & combinations of the above "]
[]
["Enrolment restrictions:",null,null,null,15]
["0 No restrictions ",{"$nulls":4},"0 No restrictions  "]
["1 Restricted to specific clients ",{"$nulls":4},"1 Restricted to specific clients  "]
["2 Restricted by qualifications or experience",{"$nulls":4},"2 Restricted by qualifications or experience "]
[{"$nulls":5}," "]
["Mode of attendance:                16",null,16,null,null,"Mode of attendance:                16 "]
["A Full-time, 24 weeks or more",{"$nulls":4},"A Full-time, 24 weeks or more "]
["B Full-time, less than 24 weeks",{"$nulls":4},"B Full-time, less than 24 weeks "]
["C Part-time, full days",{"$nulls":4},"C Part-time, full days "]
["2 Part day(s) - daytime ",{"$nulls":4},"2 Part day(s) - daytime  "]
["3 Part day(s) - evening ",{"$nulls":4},"3 Part day(s) - evening  "]
["4 Weekends ",{"$nulls":4},"4 Weekends  "]
["5 Combinations of above ",{"$nulls":4},"5 Combinations of above  "]
["6 Other blocks of time ",{"$nulls":4},"6 Other blocks of time  "]
["7 Open or Distance learning",{"$nulls":4},"7 Open or Distance learning "]
[{"$nulls":5}," "]
["Location of course:",null,null,20,null,"Location of course: "]
["1 In Glasgow University premises ",{"$nulls":4},"1 In Glasgow University premises  "]
["2 In other educational premises ",{"$nulls":4},"2 In other educational premises  "]
["3 In employer's premises ",{"$nulls":4},"3 In employer's premises  "]
["4 Higher Education Institution & field work ",{"$nulls":4},"4 Higher Education Institution & field work  "]
["5 Higher Education Institution & employer's premises",{"$nulls":4},"5 Higher Education Institution & employer's premises "]
["8 Other premises ",{"$nulls":4},"8 Other premises  "]
["9 No prescribed location",{"$nulls":4},"9 No prescribed location "]
[]
[]
["Categorisation"]
["CF R"]
["CF NR"]
["CPD"]
["CPD ACC"]
["OC"]
["ON-CAMPUS"]
["OFF-CAMPUS"]
[]
[{"$nulls":18},"Yes"]
[{"$nulls":18},"No"]
{"$rows_empty":34}
[null,null,null,0,{"$nulls":4},0]

{"sheet":"Page 2","index":1,"n_rows":108,"n_cols":48,"rows_kept":108,"cut":false,"hidden":false,"merged":[[70,0,70,3],[49,6,49,7],[25,0,25,4],[26,0,26,4],[30,0,30,4],[28,0,28,4],[29,0,29,4],[29,5,29,6],[27,0,27,4],[1,16,1,17],[21,0,21,4],[22,0,22,4],[23,0,23,4],[1,5,1,13],[30,5,30,6],[24,5,24,6],[25,5,25,6],[15,5,15,11],[28,5,28,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[26,5,26,6],[27,5,27,6],[13,0,13,4],[14,0,14,4],[14,5,14,11],[18,0,18,3],[18,5,20,6],[24,0,24,4],[13,5,13,11]],"flags":["formulas_cached_only"]}
["University of Glasgow",{"$nulls":8},"CPD - Budget Plan",{"$nulls":7},"INTERNAL USE ONLY",{"$nulls":5},"< 4 hours",2,null,null,"Home"]
["Page 2 of 3",{"$nulls":4},"CONFIDENTIAL -  if received in error, please return to R&E",{"$nulls":8},"RS project",null,0,{"$nulls":6},"1 Day",3,null,null,"O'seas"]
["FULL ECONOMIC COSTS",{"$nulls":5},"Title:",0,{"$nulls":6},"ENTER INFORMATION IN WHITE AREAS ONLY ",{"$nulls":8},"2 Days",4]
["EXTERNAL FUNDING (INCOME)",{"$nulls":6},"Scenarios","(Note 2.1)",null,null,null,"Scenarios",{"$nulls":10},"3 Days",5]
["please use a different box(s)",{"$nulls":5},"Home/EU",1,2,3,4,5,1,2,3,4,5,"TOTAL",{"$nulls":5},"4 Days",6]
["for each fee rate (Note 2.2).",{"$nulls":4},"£/Participant","/O'seas","Numbers of Participants  (Note 2.3)",{"$nulls":4},0,0,0,0,0,{"$nulls":6},"5 Days",7]
["No. of participants at rate 1",{"$nulls":11},0,0,0,0,0,0,{"$nulls":5},"7 Days",8]
["No. of participants at rate 2",{"$nulls":11},0,0,0,0,0,0,{"$nulls":5},"8 Days",9]
["No. of participants at rate 3",{"$nulls":11},0,0,0,0,0,0,{"$nulls":5},"9 Days",10]
["No. of participants at rate 4",{"$nulls":11},0,0,0,0,0,0,{"$nulls":5},"10 Days",11]
["No. of participants at rate 5",{"$nulls":11},0,0,0,0,0,0,{"$nulls":5},"11 Days",12]
["No. of participants at zero rate",{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,{"$nulls":5},"12 Days",13]
["Total Participants",{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,0,{"$nulls":5},"13 Days",14]
["Donation (please specify)",{"$nulls":16},0,{"$nulls":5},"14 Days",15]
["Grant (please specify)",{"$nulls":16},0,{"$nulls":5},"15 Days",16]
["Contract (Please specify)",{"$nulls":12},0,0,0,0,0,{"$nulls":5},"16 Days",17]
["TOTAL INCOME",{"$nulls":11},0,0,0,0,0,0,{"$nulls":5},"17 Days",18]
[{"$nulls":23},"18 Days",19]
["GU STAFF COSTS (all staff categories) (Note 2.4)",{"$nulls":4},"Employee Number",null,null,"Gross",null,null,null,"Scenarios",{"$nulls":10},"19 Days",20]
["Name",{"$nulls":6},"Agresso","Salary","£ per","Number","COST £",1,2,3,4,5,"TOTAL",{"$nulls":5},"20 Days",21]
[{"$nulls":7},"Project","Cost","Day","of Days","Inc ERs costs",0,0,0,0,0,{"$nulls":6},"None"]
[{"$nulls":11},0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0]
["EXTERNAL STAFF COSTS",{"$nulls":16},0]
[{"$nulls":11},0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,null,null,"PROMOTED"]
[{"$nulls":11},0,0,0,0,0,0,0]
["TOTAL STAFF COSTS",{"$nulls":4},"http://www.gla.ac.uk/services/humanresources/policies/p-z/salaryscales/",{"$nulls":5},0,0,0,0,0,0,0]
["OTHER DIRECT COSTS",{"$nulls":11},"Scenarios"]
["Promotional Costs (Note 2.5)",{"$nulls":7},"£/ COURSE",null,null,null,1,2,3,4,5,"TOTAL"]
[null,"Brochure design / printing",{"$nulls":5},"@",{"$nulls":4},0,0,0,0,0,0]
[null,"Mailshots ",null,"– postage",null,null,null,"@",{"$nulls":4},0,0,0,0,0,0]
[null,null,null,"– stationery",null,null,null,"@",{"$nulls":4},0,0,0,0,0,0]
[null,"Advertisements",{"$nulls":5},"@",{"$nulls":4},0,0,0,0,0,0]
[null,"Other",{"$nulls":5},"@",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":13},0,0,0,0]
[null,"Contingency @ 5% of total promotional costs (Note 2.6)",{"$nulls":7},0.05,null,null,0,0,0,0,0,0]
[null,"Total promotional",{"$nulls":10},0,0,0,0,0,0]
[]
[]
["Fixed running costs (Notes 2.7-2.9)",{"$nulls":7},"£/ COURSE"]
[null,"Speakers' expenses",{"$nulls":10},0,0,0,0,0,0]
[null,"Travel",{"$nulls":10},0,0,0,0,0,0]
[null,"Janitorial overtime",{"$nulls":10},0,0,0,0,0,0]
[null,"Hire of venue - external",{"$nulls":6},0,null,null,null,0,0,0,0,0,0]
[null,"Hire of venue-internal",null,null,null,"None",null,null,0,null,null,null,0,0,0,0,0,0]
[null,"Software",{"$nulls":10},0,0,0,0,0,0]
[null,"Library",{"$nulls":10},0,0,0,0,0,0]
[null,"Other (please detail)",{"$nulls":10},0,0,0,0,0,0]
[{"$nulls":13},0,0,0,0,0]
[null,"Total fixed running costs",{"$nulls":10},0,0,0,0,0,0]
[]
["Variable running costs (Note 2.10 & 2.11)",{"$nulls":6},"£/Participant"]
[null,"Hand-outs (printing, stationery, binders)",{"$nulls":4}," @",{"$nulls":5},0,0,0,0,0,0]
[null,"Disks / materials",{"$nulls":4}," @",{"$nulls":5},0,0,0,0,0,0]
[null,"Accommodation (overnight)",{"$nulls":4}," @",{"$nulls":5},0,0,0,0,0,0]
[null,"Catering",{"$nulls":4}," @",{"$nulls":5},0,0,0,0,0,0]
[null,"Correspondence with participants",{"$nulls":4}," @",{"$nulls":5},0,0,0,0,0,0]
[null,"Badges",{"$nulls":4}," @",{"$nulls":5},0,0,0,0,0,0]
[null,"Other",{"$nulls":4}," @",{"$nulls":5},0,0,0,0,0,0,{"$nulls":29},false]
[null,"Contingency @ 5% of variable running costs (Note 2.6)",{"$nulls":7},0.05,null,null,0,0,0,0,0,0]
[null,"Total variable running costs",{"$nulls":10},0,0,0,0,0,0]
[]
["TOTAL OTHER DIRECT COSTS",{"$nulls":11},0,0,0,0,0,0]
["STAFF + OTHER DIRECT COSTS",{"$nulls":11},0,0,0,0,0,0]
["INDIRECT COSTS",null,null,null,"as a percentage of total salary costs.  (Note 2.12)"]
["Conference",{"$nulls":4},0,{"$nulls":5},0,0,0,0,0,0,0]
["Course",{"$nulls":4},0.15,{"$nulls":4},"00:00:00",0.15,0,0,0,0,0,0]
[" ","Less Hire of Venue",{"$nulls":9}," ",0,0,0,0,0,0]
["Net Indirect Costs",{"$nulls":11},0,0,0,0,0,0]
["TOTAL FULL ECONOMIC COSTS",{"$nulls":11},0,0,0,0,0,0]
[{"$nulls":12},0,0,0,0,0,0]
["NET COSTS - to be met by income",{"$nulls":11},0,0,0,0,0,0]
[]
["SURPLUS / (DEFICIT)"]
["Anticipated Surplus/(Deficit): If deficit, state budget centre to cover",{"$nulls":11},0,0,0,0,0,0]
["Cumulative Surplus/(Deficit)",{"$nulls":11},0,0,0,0,0,0]
[]
[]
[]
[{"$nulls":26},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[{"$nulls":24},"< 4 hours","1 Day","2 Days","3 Days","4 Days","5 Days","6 Days","7 Days","8 Days","9 Days","10 Days","11 Days","12 Days","13 Days","14 Days","15 Days","16 Days","17 Days","18 Days","19 Days","20 Days"]
[{"$nulls":23},"Room 0-50",95,150,300,450,600,750,900,1050,1200,1350,1500,1650,1800,1950,2100,2250,2400,2550,2700,2850,3000]
[{"$nulls":23},"Room 50-100",125,200,400,600,800,1000,1200,1400,1600,1800,2000,2200,2400,2600,2800,3000,3200,3400,3600,3800,4000]
[{"$nulls":23}," Room 100-150",145,250,500,750,1000,1250,1500,1750,2000,2250,2500,2750,3000,3250,3500,3750,4000,4250,4500,4750,5000]
[{"$nulls":23},"Room 150-200",175,300,600,900,1200,1500,1800,2100,2400,2700,3000,3300,3600,3900,4200,4500,4800,5100,5400,5700,6000]
[{"$nulls":23},"Room 200-250",195,350,700,1050,1400,1750,2100,2450,2800,3150,3500,3850,4200,4550,4900,5250,5600,5950,6300,6650,7000]
[{"$nulls":23},"Room 250-300",220,400,800,1200,1600,2000,2400,2800,3200,3600,4000,4400,4800,5200,5600,6000,6400,6800,7200,7600,8000]
[{"$nulls":23},"Bute & Randolph",1100,2000,4000,6000,8000,10000,12000,14000,16000,18000,20000,22000,24000,26000,28000,30000,32000,34000,36000,38000,40000]
[{"$nulls":23},"Chapel",250,300,600,900,1200,1500,1800,2100,2400,2700,3000,3300,3600,3900,4200,4500,4800,5100,5400,5700,6000]
[{"$nulls":23},"Concert Hall",250,300,600,900,1200,1500,1800,2100,2400,2700,3000,3300,3600,3900,4200,4500,4800,5100,5400,5700,6000]
[{"$nulls":23},"Concert Hall Foyer",150,150,300,450,600,750,900,1050,1200,1350,1500,1650,1800,1950,2100,2250,2400,2550,2700,2850,3000]
[{"$nulls":23},"Hunter Hall East",500,650,1300,1950,2600,3250,3900,4550,5200,5850,6500,7150,7800,8450,9100,9750,10400,11050,11700,12350,13000]
[{"$nulls":23},"Hunter Hall West",500,650,1300,1950,2600,3250,3900,4550,5200,5850,6500,7150,7800,8450,9100,9750,10400,11050,11700,12350,13000]
[{"$nulls":23},"Hunterian Gallery","N/A",300,600,900,1200,1500,1800,2100,2400,2700,3000,3300,3600,3900,4200,4500,4800,5100,5400,5700,6000]
[{"$nulls":23},"Hunterian Museum","N/A",600,1200,1800,2400,3000,3600,4200,4800,5400,6000,6600,7200,7800,8400,9000,9600,10200,10800,11400,12000]
[{"$nulls":23},"John McIntyre",175,200,400,600,800,1000,1200,1400,1600,1800,2000,2200,2400,2600,2800,3000,3200,3400,3600,3800,4000]
[{"$nulls":23},"Kelvin Gallery",700,1000,2000,3000,4000,5000,6000,7000,8000,9000,10000,11000,12000,13000,14000,15000,16000,17000,18000,19000,20000]
[{"$nulls":23},"Randolph",350,500,1000,1500,2000,2500,3000,3500,4000,4500,5000,5500,6000,6500,7000,7500,8000,8500,9000,9500,10000]
[{"$nulls":23},"Visitors Centre",150,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[{"$nulls":23},"None"]
[{"$nulls":24}," ","Scenario ",1,"Scenario  1"]
[{"$nulls":23},"Years"]
[{"$nulls":23},"Scenarios"]

{"sheet":"Page 3","index":2,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,4,59,7],[59,8,59,11],[49,1,49,10],[20,3,20,4],[22,3,22,10],[18,3,18,5],[20,7,20,10],[41,3,41,5],[44,5,44,7],[45,5,45,7],[1,3,1,11],[26,3,29,10],[24,3,24,4],[24,7,24,8],[16,3,16,5],[14,3,14,5],[12,3,12,10],[3,9,3,10],[4,9,4,10]],"flags":["formulas_cached_only"]}
["University of Glasgow",{"$nulls":4},"CPD - Data collection & transfer of surplus",{"$nulls":4},"INTERNAL USE ONLY",{"$nulls":4},"Yes",{"$nulls":10},"1 Clinical Medicine"]
[null,"Page 3 of 3",null,"                             CONFIDENTIAL ",{"$nulls":11},"No",{"$nulls":10},"2 Clinical Dentistry"]
[{"$nulls":6},"if received in error, please return to R&E",{"$nulls":19},"3 Veterinary Science"]
[{"$nulls":8},"Research System project",0,{"$nulls":16},"4 Anatomy and Physiology"]
[{"$nulls":8},"Finance System project ",0,{"$nulls":16},"5 Nursing and Paramedical Studies"]
[null,"Data Collection and Transfer of Surplus                                                                                                                        ",{"$nulls":7},"(Note 3.1)",{"$nulls":5}," ",{"$nulls":10},"6 Health and Community Studies"]
[{"$nulls":26},"7 Psychology and Behavioural Sciences"]
[null,"Please compete all unshaded areas of this page AFTER the event/programme has run",{"$nulls":24},"8 Pharmacy and Pharmacology"]
[null,"or at the end of the academic year for a longer programme, or after the intended start date if it does not run.",{"$nulls":24},"10 Biosciences"]
[{"$nulls":26},"11 Chemistry"]
[null,"SECTION 1 (will be filled automatically for lead person from Part 1, except * )",{"$nulls":24},"12 Physics"]
[{"$nulls":26},"13 Agriculture and Forestry"]
[null,"School / RI / College",null," ",{"$nulls":22},"14 Earth, Marine and Environmental Sciences"]
[{"$nulls":26},"16 General Engineering"]
[null,"Budget Holder",null,0,{"$nulls":22},"17 Chemical Engineering"]
[{"$nulls":26},"18 Mineral, Metallurgy and Materials Engineering"]
[null,"Organiser",null,0,{"$nulls":22},"19 Civil Engineering"]
[{"$nulls":26},"20 Electrical, Electronic and Computer Engineering"]
[null,"Signature*:",{"$nulls":4},"* signature of lead person - sign printout, don't fill in on screen)",{"$nulls":19},"21 Mechanical, Aero and Production Engineering"]
[{"$nulls":26},"23 Architecture, Built Environment and Planning"]
[null,"Telephone:",null,0,null,null,"e-mail:",0,{"$nulls":18},"24 Mathematics"]
[{"$nulls":26},"25 Information Technology and Systems Sciences and Computer Software Engineering"]
[null,"Title of Event:",null,0,{"$nulls":22},"26 Catering and Hospitality Management"]
[{"$nulls":26},"27 Business and Management Studies"]
[null,"Start Date:",null,"00:00:00",null,null,"End Date:","00:00:00",{"$nulls":18},"28 Geography"]
[{"$nulls":26},"29 Social Studies"]
[null,"Aims:",null,0,{"$nulls":22},"30 Media Studies"]
[{"$nulls":26},"31 Humanities and Language Based Studies"]
[{"$nulls":26},"33 Design and Creative Arts"]
[{"$nulls":26},"34 Education"]
[{"$nulls":26},"35 Modern Languages"]
[null,"SECTION 2",{"$nulls":24},"37 Archaeology"]
[{"$nulls":26},"38 Sports Science and Leisure Studies"]
[null,"Did the Event/Programme Run?",{"$nulls":24},"41 Continuing Education"]
[{"$nulls":26},"51 Total Academic Services"]
[null,"Length in contact hours:",{"$nulls":4},"Number of participants",null,null,"Were most of the participants    ",{"$nulls":16},"54 Central Administration and Services, General Educational Expenditure"]
[null,"for each participant (incl. lectures / tutorials,",{"$nulls":4},"(Note 3.2)",null,null,"matriculated students?  ",{"$nulls":16},"55 Staff and Student Facilities"]
[null,"field study, & other supervised study, but not private study)",{"$nulls":24},"56 Premises"]
[{"$nulls":6},"students based on domicile",{"$nulls":19},"57 Residences and Catering"]
[{"$nulls":7},"Home","EU","Overseas"]
[]
[null,null,"Cost Centre :",null,null,null," (Identify HESA cost centre from drop down list)"]
[]
[null,"Is it a conference?  ",null,null,null,"No"]
[null,"Data collection ",null,"Purpose",null,0]
[null,null,null,"Target Group",null,0]
[]
[null,"SECTION 3",null,"OVERHEADS AND SURPLUS"]
[]
[null,"From 2004/05 Indirect Costs should be calculated at 20% Staff Costs (15% off-campus), less internal accommodation costs, for non-accredited CPD and other short courses or £5 per delegate for conferences.  These costs will be recouped by the Finance Office and repaid to Colleges.  Income for accredited CPD/PGT will be allocated through the RAM and Indirect Costs at 50% Staff Costs (40% if delivered off-campus) are likely to be recouped by College before allocating the budget to Schools/RIs  A summary of income and expenditure will appear on your latest monthly budgetary report."]
[null,"Please complete the following boxes to instruct the Finance Office to transfer surplus funds to a discretionary FS project.  If the transfer is "]
[null,"to more than one FS project, please specify the percentage to each."]
[{"$nulls":8},"Percentage","FS project"]
[null,"SURPLUS",null,"Transfer to discretionary fund(s)  ",{"$nulls":4},1]
[]
[]
[{"$nulls":8},""]
[null,"On completion of Part 3, return copies of this part to: "]
[]
[{"$nulls":4},"Research Support Office,Post award team,300 Bath Street,Glasgow.G2 4LH  "]

{"sheet":" Intro & Notes","index":3,"n_rows":205,"n_cols":11,"rows_kept":205,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Costing Form for Non-accredited CPD, Conferences, and Other Short Courses"]
[]
[]
["Introduction"]
[]
["This 'Costing Form' is to be completed as appropriate prior to the running of all non-accredited CPD events, conferences,"]
["and other short courses.  Each such event requires School/RI and College approval. The Costing Form consists of  three pages "]
["and this version was introduced in March 2005."]
[]
["Course Organisers should be aware of the obligation to complete fully the required management and statistical information "]
["for all relevant sections of the Costing Form.  It is therefore recommended that prior to any filling in, the associated text "]
["and notes relating to the completing of sections and pages are read in full."]
[]
["The Costing Form spreadsheet (workbook) consists of three main Pages."]
["1.","Page 1 - Applicant(s)/Event/Programme Details"]
["2.","Page 2 - Budget Plan"]
["3.","Page 3 - Data Collection and Transfer of Surplus"]
["The worksheets may be navigated via the tabs at the bottom (on-line version). It is recommended that the Form is completed  on-line "]
["as many calculations/data transfer are completed automatically."]
[]
["NOTE: Sometimes the same information is asked for on more than one page of the form. However, if you fill in the data on screen "]
["before printing, much of the duplicate data will be automatically copied to subsequent pages. To ensure this happens, please use "]
["the nearest left hand side part of boxed cells."]
[]
["Please keep a copy of the completed Pages of the form to facilitate the swift return of Page 3 after the activity has taken place."]
[]
["Costing Form Procedure"]
["To gain Court approval for your event, in order:"]
["1.","Fill in Pages 1 and 2 of the Costing Form on screen."]
["2.","Save and print off the pages. "]
["3.","Have Page 1 signed by your Head of School/RI and Head of College"]
["4.","Send signed copy of Pages 1 and 2 to Joyce Dawson, ROSS Finance Section, (Tay House), Finance Department, University of Glasgow, G12 8QQ"]
[null,"This allows grant awards to log the event on the Research System and forward to Finance for a Finance System project to be opened."]
[]
[null,"To complete the procedure (once the event has run or been cancelled):"]
["5.","Complete and send Page 3 to ROSS Finance, (Tay House),Finance Department, University of Glasgow, G12 8QQ"]
[]
[]
["Completion Notes "]
[]
["ENTER INFORMATION IN WHITE AREAS ONLY"]
[]
["N.B. Some boxes have red flags indicating comment boxes that reproduce these notes.  Clicking on some boxes "]
["activates a drop-down menu from which you should choose a response."]
[]
[]
["Page 1 - Applicant(s)/Event/Programme Details"]
["This shows the basic information and should be completed first.  "]
[]
[1.1,"Research System project no."]
[null,"Leave this box blank; a project number for the Research System  will be set up and you will be informed of it."]
[]
[1.2,"Applicant/s"]
[null,"The name of the Budget holder must be inserted, though the Budget holder need not be the Organiser of the activity. It may be"]
[null," convenient to give an administrator's e-mail address if s/he is to be the first point of contact for queries."]
[]
[1.3,"Aim"]
[null,"The ‘Aims’ field is important for SFC audit purposes and must be completed for all events.  If the event is CPD, the text must "]
[null,"briefly demonstrate that the aims of the activity are consistent with the CPD definition which can be found via the GU CPD web page:"]
[null,"http://www.gla.ac.uk/services/cpd/definitions.html"]
[]
[1.6,"Authorisation"]
[null,"The Summary of Costs will enter automatically after page 2 has been completed (see also Note 2.13). There may be occasions when "]
[null,"it is desirable to run a one-off event even if a deficit is predicted. This is acceptable if the Finance System project that will cover the deficit"]
[null,"is given. Signatures by Heads of School/RI and College below the summary indicate support for such a decision. In the case of events running over "]
[null,"a longer period, the budget plan should clearly indicate when the activity plans to become self-financing."]
[]
[1.7,"Data Collection"]
[null,"The DATA COLLECTION section must be completed to help the Planning Office in categorizing the activity for the purposes of SFC"]
[null,"ER and CPD Returns and the HESA Return, allowing an appropriate  budget centre to be opened and confirming the appropriate "]
[null,"overhead charge. The small numbers adjacent to some boxes are the reference numbers of the fields required by HESA."]
[]
[1.8,"Purpose"]
[null,"For most short courses, this will be code 10 – ‘Continuing Professional Development’.  If you are unsure whether this applies to your"]
[null,"event, enter code 10 and we will revise it if necessary. ‘INSETT’ stands for ‘In-Service Teacher Training’."]
[]
["1.9","Finance System project number"]
[null,"Leave this box blank; registration of the activity by R&E will result in the Finance Office setting up an OSR (other services rendered) "]
[null,"account and informing you. (All CPD, Conferences and other short courses should be run through the FS project.)"]
[]
[]
["Page 2 - Scenario Costings/Business Plan"]
["In any of the sections, unused categories of income or expenditure can be scored out or renamed (if assistance is needed, contact Finance Office, ROSS section)."]
[]
[]
[2.1,"Years/Scenarios"]
[null,"This allows the Course Organiser to show several costing scenarios for a one-off event or an accumulative business plan over a"]
[null," 5-year period for a single 'scenario'. The latter format is particularly important for self-financing accredited CPD/PGT. In such  "]
[null,"cases, alternative scenarios for the activity should be planned using additional copies of Page 2.  Click on the Years/Scenario"]
[null,"box and select the mode you require from the drop-down menu.  Note that in 'Years' mode, inflation is built into the calculations"]
[null,"from years 2-5."]
[]
["2.2","Course Fees"]
[null,"Space is allowed for a number of different fee levels.  Please indicate whether fee rates are applicable to Home/EU or Overseas students."]
[null,"The price charged for a course should be set by market forces. Customers’ willingness to pay is the primary factor here and can"]
[null,"be ascertained through competitors’ information/market research etc. However, income must at least cover total expenditure on"]
[null,"the project (i.e. it must at least reach a break-even point) unless there is an agreed internal subsidy (see also Note 2.13). If, once"]
[null,"the costing  is complete, expenditure exceeds income, the price must be raised or the activity should be re-thought/re-designed. "]
[null,"CPD, Conferences, and short-courses of this nature must be fully costed."]
[]
[2.3,"Number of Participants"]
[null,"Estimates of the number of participants at each fee level should be given. "]
[null,"Certain assumptions must be made in the initial stages of course development – particularly when offering an ‘open’ course. The   "]
[null,"important point is not to be overly optimistic in thinking of numbers that may be attracted to the course.  Be as realistic as possible."]
[null,"For accredited CPD, there is a requirement to consult SRAS during the planning stage to discuss the potential market and fees "]
[null,"charged."]
[]
[2.4,"Staff Costs"]
[null,"Since these courses should be fully costed, staff time associated with them should be clearly identified. Details of staff costs may be"]
[null,"found at:","http://www.gla.ac.uk/services/humanresources/policies/p-z/salaryscales/"]
[]
[null,"CALCULATION OF STAFF COSTS"]
[null,"This may be done using the Research System costing model – administrators have access to the model and should be able to "]
[null,"assist. Alternatively the SIRIUS salary calculator may be used by individual staff."]
[null,"Costs of existing staff will be recouped and retained by the School/RI/College. "]
[]
[2.5,"Promotional Costs"]
[null,"Promotional costs are incurred whether a course eventually runs or not.  These costs can therefore be considered as the ‘risk’ – if the "]
[null,"course does not attract sufficient interest and is cancelled, these costs must be met by the School/RI. Promotional costs are likely"]
[null," to be most significant in Year 1."]
[]
[2.6,"Contingency"]
[null,"It is usually wise to add a contingency element into costings, since there are often ‘hidden’ costs which only appear when the course "]
[null,"actually gets off the ground."]
[]
[2.7,"Fixed Costs"]
[null," ‘Fixed’ costs are those which do not change with the number of participants attending."]
[]
[2.8,"Janitorial Overtime "]
[null,"Only certain buildings are open in the evenings (Boyd Orr; Adam Smith; St Andrews; Stair; Hetherington). For all other buildings and "]
[null,"at all other times Janitorial overheads will need to be charged over and above the overhead payment. Please contact Cula Murphy"]
[null,"(ext. 4586) or Gail Devlin (ext. 5622) in the first instance."]
[]
[2.9,"Room Hire "]
[null,"Charges for use of all University rooms must be costed in here.  At the present time, this charge should be subtracted from the "]
[null,"overhead charge paid to central University funds, although this policy may be reviewed at a latter date. For further information on "]
[null,"central room bookings, you should contact Cula Murphy (ext. 4586) or Gail Devlin (ext. 5622) in the first instance."]
[]
["2.10","Variable Costs"]
[null,"‘Variable’ costs are those which change as number of participants attending changes. Costs per student are entered in this section "]
[null,"and the total costs will be calculated based on the student numbers entered."]
[]
[null,"A 24-hour delegate rate charged by a hotel should be included under ‘Other’ variable running costs."]
[]
[2.11,"Accommodation and Catering"]
[null,"At the present time income-generating CPD activity run by educational establishments, whether for profit or not, are VAT exempt.  "]
[null,"Prices charged to the client should not include VAT.  "]
[]
[null,"In costing any project, however, Departments should be aware that they may have to pay VAT on certain services, including "]
[null,"accommodation and catering. Non-University accommodation and catering prices will include VAT. If University accommodation"]
[null,"or catering is used, the course organiser may apply for VAT relief to Anne Wheeler  in the Finance Office (ext. 5193)."]
[]
["2.12","Indirect Costs "]
[null,"In addition to direct costs associated with any project, a number of Indirect Costs exist (including Finance Office staff handling and"]
[null,"processing cheques from participants, phone calls made in connection with the project and so on). These Indirect Costs must be "]
[null,"recouped."]
[]
[null,"With the introduction of the new Resource Allocation Model (RAM) in 2004/5, Faculties are attributed with Indirect Costs which "]
[null,"are based on a number of 'drivers' including staff numbers, student numbers, and space occupied."]
[]
[null,"In turn, it is expected that Faculties will recover some of these Indirect Costs from the full range of activities in which it is engaged."]
[]
[null,"In anticipation of the moves towards full economic costing (FEC) and in order to align the CPD indirect cost calculations with"]
[null,"those of other Knowledge Transfer activites the calculation of Indirect Costs has recently been modified."]
[]
[null,"Currently, the Indirect Costs associated with CPD activity are calculated as follows:"]
[]
[null,"Non-Accredited CPD"]
[null,"for courses delivered on campus not leading to an award of the University",{"$nulls":7},0.2,"Salary Costs"]
[null,"for courses delivered off campus not leading to an award of the University",{"$nulls":7},0.15,"Salary Costs"]
[null,"Conferences"]
[null,"£5 per delegate with a minimum of £100 and a maximum of £500 "]
[]
[null,"Eligible deductions at present are any charges for the hire of accommodation (excluding overnight accommodation)."]
[]
[null,"For CPD that is run through a FS project, the Finance Office will continue to charge the indirect costs against that FS project "]
[null,"before closing it down and transferring surpluses to discretionary FS project. These Indirect Costs will be credited to a "]
[null,"central FS project and repaid to College in due course."]
[]
[null,"This means that Heads of College have discretion to re-direct some of the Indirect Costs back to Schools/RIs if they wish to subsidise or "]
[null,"incentivise CPD activities."]
[]
[null,"Ideally such agreements should be made at the event costing stage so that event organisers may reduce the fees to participants if "]
[null,"such reductions/cost waivers are agreed. The new version of the CPD costing form makes provision for recording such agreements"]
[null,"(see Note: 2.10)."]
[]
[]
[null,"When all income and expenditure transactions are completed, or at the end of each academic year for a longer activity fill in Page 3, "]
[null,"giving the final participant details and the departmental discretionary budget centre to which surplus (after deduction of the "]
[null,"appropriate central overhead) is to be transferred."]
[]
[null,"After signing, send completed Page 3 to Mrs Maureen McAleenan, Finance Office"]
[]
[null,"Page 3 can only be completed after the event.  It gives the final participant information required for the HESA Return and informs "]
[null,"the Finance Office about  where to transfer any surplus generated."]
[]
["Page 3 - Data Collection and Transfer of Surplus"]
[]
[3.1,"References"]
[null,"The FS project number and Research System project number will be notified to you by the Finance Office following"]
[null,"submission of Pages 1 & 2. These need to be inserted here by you if they have not been completed automatically."]
[]
[3.2,"Participants"]
[null,"As well as the total number of participants being required, a split of this number by domicile is also needed. The split should"]
[null,"differentiate between UK (home), remainder of EU (EU), and other overseas."]

{"sheet":"Pg 1 Cost-centre codes","index":4,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":true,"merged":[[1,0,1,1]],"flags":["formulas_cached_only"]}
["HESA COST CENTRES",null," "]
["It is recognised that in some institutions, separate specialist departments of Continuing Education, Adult Education or Extra-Mural Studies may exist. In cases where these departments exist and the institution wishes to identify them separately, for resource attribution purposes, code 41 should be used."]
[]
["List of valid cost centres:"]
[1,"Clinical Medicine","1 Clinical Medicine"]
[2,"Clinical Dentistry","2 Clinical Dentistry"]
[3,"Veterinary Science","3 Veterinary Science"]
[4,"Anatomy and Physiology","4 Anatomy and Physiology"]
[5,"Nursing and Paramedical Studies","5 Nursing and Paramedical Studies"]
[6,"Health and Community Studies","6 Health and Community Studies"]
[7,"Psychology and Behavioural Sciences","7 Psychology and Behavioural Sciences"]
[8,"Pharmacy and Pharmacology","8 Pharmacy and Pharmacology"]
[10,"Biosciences","10 Biosciences"]
[11,"Chemistry","11 Chemistry"]
[12,"Physics","12 Physics"]
[13,"Agriculture and Forestry","13 Agriculture and Forestry"]
[14,"Earth, Marine and Environmental Sciences","14 Earth, Marine and Environmental Sciences"]
[16,"General Engineering","16 General Engineering"]
[17,"Chemical Engineering","17 Chemical Engineering"]
[18,"Mineral, Metallurgy and Materials Engineering","18 Mineral, Metallurgy and Materials Engineering"]
[19,"Civil Engineering","19 Civil Engineering"]
[20,"Electrical, Electronic and Computer Engineering","20 Electrical, Electronic and Computer Engineering"]
[21,"Mechanical, Aero and Production Engineering","21 Mechanical, Aero and Production Engineering"]
[23,"Architecture, Built Environment and Planning","23 Architecture, Built Environment and Planning"]
[24,"Mathematics","24 Mathematics"]
[25,"Information Technology and Systems Sciences and Computer Software Engineering","25 Information Technology and Systems Sciences and Computer Software Engineering"]
[26,"Catering and Hospitality Management","26 Catering and Hospitality Management"]
[27,"Business and Management Studies","27 Business and Management Studies"]
[28,"Geography","28 Geography"]
[29,"Social Studies","29 Social Studies"]
[30,"Media Studies","30 Media Studies"]
[31,"Humanities and Language Based Studies","31 Humanities and Language Based Studies"]
[33,"Design and Creative Arts","33 Design and Creative Arts"]
[34,"Education","34 Education"]
[35,"Modern Languages","35 Modern Languages"]
[37,"Archaeology","37 Archaeology"]
[38,"Sports Science and Leisure Studies","38 Sports Science and Leisure Studies"]
[41,"Continuing Education","41 Continuing Education"]
[51,"Total Academic Services","51 Total Academic Services"]
[54,"Central Administration and Services, General Educational Expenditure","54 Central Administration and Services, General Educational Expenditure"]
[55,"Staff and Student Facilities","55 Staff and Student Facilities"]
[56,"Premises","56 Premises"]
[57,"Residences and Catering","57 Residences and Catering"]