{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Enable Macros ","Summary","Int Coll_Programme Costing","Activity costing","Spine points for template","New data"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":5,"defined_names":89,"comments":2,"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":"Enable Macros ","index":0,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Click on the options Button as soon as you open the workbook"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. If the Options button is not there close the spreadsheet and re-open"]
[]
[]
[null,null,"3. The following POP Up will appear"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"4. Click the \"Enable this content\" under the Macro's section"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"5. Click the \"OK\" button"]

{"sheet":"Summary","index":1,"n_rows":41,"n_cols":24,"rows_kept":41,"cut":false,"hidden":false,"merged":[[27,2,27,6],[28,2,28,6],[29,2,29,7],[2,0,2,9],[10,0,10,6],[10,8,10,12],[12,0,12,6],[12,8,12,12],[14,0,14,6],[14,8,14,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None","None","None","None","None","Business"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None","None","None","None","None"]
["Business Plan"]
[]
[]
[null,null,"00:00:00"]
[null,null,null,"04/10/2012",null,null,null,null,null,"Date:","2021-10-08"]
[]
[]
[]
["Partnership College/ Institution"]
[]
["Region"]
[]
["Programme"]
[]
[null,null,null,null,null,null,null,null,"Year 1  ",null,"Year 2   ",null,"Year 3   "]
[null,null,null,null,null,null,null,null,"£",null,"£",null,"£"]
[]
[null,null,"Income"]
[]
[]
[null,null,"Fee income",null,null,null,null,null,{"$f":"'Int Coll_Programme Costing'!J22","v":0},null,{"$f":"'Int Coll_Programme Costing'!N22","v":0},null,{"$f":"'Int Coll_Programme Costing'!R22","v":0}]
[null,null,"Total Fee Income",null,null,null,null,null,{"$f":"+I23","v":0},null,{"$f":"+K23","v":0},null,{"$f":"+M23","v":0}]
[]
[null,null,"Direct Cost"]
[]
[null,null,"Approval Event ",null,null,null,null,null,{"$f":"+'Int Coll_Programme Costing'!J30","v":24064.186111585277},null,0,null,0]
[null,null,"Staff cost (Link tutor & Prog Leader)",null,null,null,null,null,{"$f":"+'Int Coll_Programme Costing'!J41","v":15833.352416786729},null,{"$f":"+'Int Coll_Programme Costing'!N41","v":16150.019465122465},null,{"$f":"+'Int Coll_Programme Costing'!R41","v":16473.019854424914}]
[null,null,"Assessments  (Setting/Approving  Exam paper)",null,null,null,null,null,{"$f":"+'Int Coll_Programme Costing'!J48","v":0},null,{"$f":"+'Int Coll_Programme Costing'!N48","v":0},null,{"$f":"+'Int Coll_Programme Costing'!R48","v":0}]
[null,null,"Marking & Moderation",null,null,null,null,null,{"$f":"+'Int Coll_Programme Costing'!J89","v":0},null,{"$f":"+'Int Coll_Programme Costing'!N89","v":0},null,{"$f":"+'Int Coll_Programme Costing'!R89","v":0}]
[null,null,"Other Quality Assurance Costs",null,null,null,null,null,{"$f":"+'Int Coll_Programme Costing'!J96","v":3181.9519176817753},null,{"$f":"+'Int Coll_Programme Costing'!N96","v":3181.9519176817753},null,{"$f":"+'Int Coll_Programme Costing'!R96","v":3181.9519176817753}]
[null,null,"Staff Travel & Subsistence",null,null,null,null,null,{"$f":"+'Int Coll_Programme Costing'!J104","v":0},null,{"$f":"+'Int Coll_Programme Costing'!N104","v":0},null,{"$f":"+'Int Coll_Programme Costing'!R104","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I28:I33)","v":43079.490446053787},null,{"$f":"SUM(K28:K33)","v":19331.97138280424},null,{"$f":"SUM(M28:M33)","v":19654.971772106688}]
[null,null,"Indirect Cost"]
[]
[null,null,"Estate ",null,null,null,null,null,{"$f":"+'Int Coll_Programme Costing'!J114","v":1928.25},null,{"$f":"+'Int Coll_Programme Costing'!N114","v":1966.8150000000003},null,{"$f":"+'Int Coll_Programme Costing'!R114","v":2006.1513000000002}]
[null,null,"Indirect TRAC Costs ",null,null,null,null,null,{"$f":"+'Int Coll_Programme Costing'!J120","v":8206.5},null,{"$f":"+'Int Coll_Programme Costing'!N120","v":8370.630000000001},null,{"$f":"+'Int Coll_Programme Costing'!R120","v":8538.0426000000007}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I37:I38)","v":10134.75},null,{"$f":"SUM(K37:K38)","v":10337.445000000002},null,{"$f":"SUM(M37:M38)","v":10544.1939}]
[]
[null,null,"Profit/Loss",null,null,null,null,null,{"$f":"+I24-(I34+I39)","v":-53214.240446053787},null,{"$f":"+K24-(K34+K39)","v":-29669.416382804244},null,{"$f":"+M24-(M34+M39)","v":-30199.16567210669}]

{"sheet":"Int Coll_Programme Costing","index":2,"n_rows":126,"n_cols":44,"rows_kept":126,"cut":false,"hidden":false,"merged":[[4,8,4,9],[4,12,4,13],[4,16,4,17],[124,1,124,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SG2 - SP5",null,null,null,null,"AC4 - SP45","AC3 - mid point","SG7 - mid point","Approving Exam and Feedback when set by others","Setting Exam Paper",null,null,null,null,null,null,"Yes"]
[null,"International Collaborations: Programme Costing"]
[]
[]
[null,null,null,null,null,null,null,null,"YEAR 1 (1st Year of Operation)",null,null,null,"YEAR 2 (2nd Year of Operation)",null,"",null,"YEAR 3(3rd Year of Operation)"]
[]
[null,"Student Numbers, Fee & Income",null,null,null,null,null,null,"Student    Nos","£",null,null,"Student    Nos","£",null,null,"Student    Nos","£"]
[]
[null,null,null,"Student Nos: Year 1"]
[null,null,null,"Student Nos: Year 2"]
[null,null,null,"Student Nos: Year 3"]
[null,null,null,"Student Nos: Year 2 (top-up)"]
[null,null,null,"Student Nos: Year 3 (top-up)"]
[]
[]
[null,null,null,null,null,null,null,null,"Fee per Student"]
[]
[null,null,null,"Fee per student: Year 1-3"]
[null,null,null,"Fee per student: Year 2 (top-up)"]
[null,null,null,"Fee per student: Year 3 (top up)"]
[]
[null,null,null,"Total Fee Income",null,null,null,null,null,{"$f":"(SUM(I9:I11)*I18)+(I12*I19)+(I13*I20)","v":0},null,null,null,{"$f":"(SUM(M9:M11)*M18)+(M12*M19)+(M13*M20)","v":0},null,null,null,{"$f":"(SUM(Q9:Q11)*Q18)+(Q12*Q19)+(Q13*Q20)","v":0}]
[]
[]
[]
[]
[null,"Approval Events Costs:-",null,"Is an onsite approval event required? ",null,null,null,null,null,{"$f":"IF(AR1=\"yes\",'Activity costing'!$C25,'Activity costing'!$C18)","v":24164.186111585277}]
[]
[null,null,null,"partner is contributing to the cost of the approval event ",null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,{"$f":"+J27-J29","v":24064.186111585277}]
[]
[]
[]
[null,"Staff                           Costs:-",null,null,"Grade",null,null,null,"FTE","          £",null,null,"FTE","£",null,null,"FTE","£"]
[null,null,null,"Principal Lecturer",null,{"$f":"VLOOKUP(AG1,'Spine points for template'!$A$7:$B$137,2,FALSE)","v":77295.048335734566},null,null,0.05,{"$f":"F35*I35","v":3864.7524167867286},null,null,0.05,{"$f":"($F35*M35)*(1+'Activity costing'!$B$44)","v":3942.0474651224631},null,null,0.05,{"$f":"($F35*Q35)*(1+'Activity costing'!$B$44)*(1+'Activity costing'!$C$44)","v":4020.8884144249123},null,null,"2% Annual Pay Award "]
[]
[null,null,null,"Senior Lecturer",null,{"$f":"VLOOKUP(AH1,'Spine points for template'!$A$7:$B$137,2,FALSE)","v":66473},null,null,0.1,{"$f":"F37*I37","v":6647.3},null,null,0.1,{"$f":"($F37*M37)*(1+'Activity costing'!$B$44)","v":6780.2460000000001},null,null,0.1,{"$f":"($F37*Q37)*(1+'Activity costing'!$B$44)*(1+'Activity costing'!$C$44)","v":6915.8509199999999},null,null,"2% Annual Pay Award "]
[]
[null,null,null,"Administration",null,{"$f":"VLOOKUP(AI1,'Spine points for template'!$A$7:$B$137,2,FALSE)","v":53213},null,null,0.1,{"$f":"F39*I39","v":5321.3},null,null,0.1,{"$f":"($F39*M39)*(1+'Activity costing'!$B$44)","v":5427.7260000000006},null,null,0.1,{"$f":"($F39*Q39)*(1+'Activity costing'!$B$44)*(1+'Activity costing'!$C$44)","v":5536.2805200000003},null,null,"2% Annual Pay Award "]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J35:J40)","v":15833.352416786729},null,null,null,{"$f":"SUM(N35:N40)","v":16150.019465122465},null,null,null,{"$f":"SUM(R35:R40)","v":16473.019854424914}]
[]
[]
[null,"Assessments                Costs:-",null,null,null,null,null,null,"Nos.","              £",null,null,"Nos.","              £",null,null,"Nos.","              £"]
["`",null,null,null,null,{"$f":"VLOOKUP(AK1,'Activity costing'!$A$74:$C$77,3,FALSE)","v":570},null,null,null,{"$f":"IF(I45>0,($F45*I45),0)","v":0},null,null,null,{"$f":"IF(M45>0,($F45*M45),0)","v":0},null,null,null,{"$f":"IF(Q45>0,($F45*Q45),0)","v":0}]
[null,null,null,null,null,{"$f":"VLOOKUP(AJ1,'Activity costing'!$A$74:$C$77,3,FALSE)","v":10},null,null,null,{"$f":"IF(I46>0,($F46*I46),0)","v":0},null,null,null,{"$f":"IF(M46>0,($F46*M46),0)","v":0},null,null,null,{"$f":"IF(Q46>0,($F46*Q46),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J45:J47)","v":0},null,null,null,{"$f":"SUM(N45:N47)","v":0},null,null,null,{"$f":"SUM(R45:R47)","v":0}]
[]
[]
[]
[null,"Marking & Moderation Costs:-",null,null,null,"Cost Per Assess -ment",null,null,"Number of Assess -ments","       £",null,null,"Number of Assess -ments","       £",null,null,"Number of Assess -ments","       £"]
[null,null,null,"Examination Marking",null,{"$f":"+'Activity costing'!$C$5","v":50},null,null,null,{"$f":"SUM(J54:J58)","v":0},null,null,null,{"$f":"SUM(N54:N58)","v":0},null,null,null,{"$f":"SUM(R54:R58)","v":0}]
[null,null,null,"                  : Year 1",null,{"$f":"+'Activity costing'!$C$5","v":50},null,null,null,{"$f":"F54*I54*I9","v":0},null,null,null,{"$f":"F54*M54*M9","v":0},null,null,null,{"$f":"F54*Q54*Q9","v":0}]
[null,null,null,"                  : Year 2",null,{"$f":"+'Activity costing'!$C$5","v":50},null,null,null,{"$f":"F55*I55*I10","v":0},null,null,null,{"$f":"F55*M55*M10","v":0},null,null,null,{"$f":"F55*Q55*Q10","v":0}]
[null,null,null,"                  : Year 3",null,{"$f":"+'Activity costing'!$C$5","v":50},null,null,null,{"$f":"F56*I56*I11","v":0},null,null,null,{"$f":"F56*M56*M11","v":0},null,null,null,{"$f":"F56*Q56*Q11","v":0}]
[null,null,null,"                  : Year 2 (top-up)",null,{"$f":"+'Activity costing'!$C$5","v":50},null,null,null,{"$f":"F57*I57*I12","v":0},null,null,null,{"$f":"F57*M57*M12","v":0},null,null,null,{"$f":"F57*Q57*Q12","v":0}]
[null,null,null,"                  : Year 3 (top-up)",null,{"$f":"+'Activity costing'!$C$5","v":50},null,null,null,{"$f":"F58*I58*I13","v":0},null,null,null,{"$f":"F58*M58*M13","v":0},null,null,null,{"$f":"F58*Q58*Q13","v":0}]
[]
[null,null,null,"Coursework Marking",null,10,null,null,null,{"$f":"SUM(J61:J65)","v":0},null,null,null,{"$f":"SUM(N61:N65)","v":0},null,null,null,{"$f":"SUM(R61:R65)","v":0}]
[null,null,null,"                  : Year 1",null,{"$f":"+'Activity costing'!$C$6","v":50},null,null,null,{"$f":"+F61*I61*I9","v":0},null,null,null,{"$f":"+F61*M61*M9","v":0},null,null,null,{"$f":"+F61*Q61*Q9","v":0}]
[null,null,null,"                  : Year 2",null,{"$f":"+'Activity costing'!$C$6","v":50},null,null,null,{"$f":"+F62*I62*I10","v":0},null,null,null,{"$f":"+F62*M62*M10","v":0},null,null,null,{"$f":"+F62*Q62*Q10","v":0}]
[null,null,null,"                  : Year 3",null,{"$f":"+'Activity costing'!$C$6","v":50},null,null,null,{"$f":"+F63*I63*I11","v":0},null,null,null,{"$f":"+F63*M63*M11","v":0},null,null,null,{"$f":"+F63*Q63*Q11","v":0}]
[null,null,null,"                  : Year 2 (top-up)",null,{"$f":"+'Activity costing'!$C$6","v":50},null,null,null,{"$f":"+F64*I64*I12","v":0},null,null,null,{"$f":"+F64*M64*M12","v":0},null,null,null,{"$f":"+F64*Q64*Q12","v":0}]
[null,null,null,"                  : Year 3 (top-up)",null,{"$f":"+'Activity costing'!$C$6","v":50},null,null,null,{"$f":"+F65*I65*I13","v":0},null,null,null,{"$f":"+F65*M65*M13","v":0},null,null,null,{"$f":"+F65*Q65*Q13","v":0}]
[]
[null,null,null,"Dissertation Marking",null,{"$f":"+'Activity costing'!$C$7","v":160},null,null,null,{"$f":"SUM(J68:J69)","v":0},null,null,null,{"$f":"SUM(N68:N69)","v":0},null,null,null,{"$f":"SUM(R68:R69)","v":0}]
[null,null,null,"                  : Year 3",null,{"$f":"+'Activity costing'!$C$7","v":160},null,null,null,{"$f":"+F68*I68*I11","v":0},null,null,null,{"$f":"+F68*M68*M11","v":0},null,null,null,{"$f":"+F68*Q68*Q11","v":0}]
[null,null,null,"                  : Year 3 (top-up)",null,{"$f":"+'Activity costing'!$C$7","v":160},null,null,null,{"$f":"+F69*I69*I13","v":0},null,null,null,{"$f":"+F69*M69*M13","v":0},null,null,null,{"$f":"+F69*Q69*Q13","v":0}]
[]
[null,null,null,"Examination Moderation",null,{"$f":"+'Activity costing'!$E$5","v":27},null,null,null,{"$f":"SUM(J72:J76)","v":0},null,null,null,{"$f":"SUM(N72:N76)","v":0},null,null,null,{"$f":"SUM(R72:R76)","v":0},null,null,"Cost here is: cost of time for one moderation x number of exams x number of students (<100 students =10, >100 = 10% of student number)"]
[null,null,null,"                  : Year 1",null,{"$f":"+'Activity costing'!$E$5","v":27},null,null,null,{"$f":"F72*I72*IF($I$9<100,10,$I$9*0.1)","v":0},null,null,null,{"$f":"F72*M72*IF($M$9<100,10,$M$9*0.1)","v":0},null,null,null,{"$f":"F72*Q72*IF($Q$9<100,10,$Q$9*0.1)","v":0}]
[null,null,null,"                  : Year 2",null,{"$f":"+'Activity costing'!$E$5","v":27},null,null,null,{"$f":"F73*I73*IF($I$10<100,10,$I$10*0.1)","v":0},null,null,null,{"$f":"F73*M73*IF($M$10<100,10,$M$10*0.1)","v":0},null,null,null,{"$f":"F73*Q73*IF($Q$10<100,10,$Q$10*0.1)","v":0}]
[null,null,null,"                  : Year 3",null,{"$f":"+'Activity costing'!$E$5","v":27},null,null,null,{"$f":"F74*I74*IF($I$11<100,10,$I$11*0.1)","v":0},null,null,null,{"$f":"F74*M74*IF($M$11<100,10,$M$11*0.1)","v":0},null,null,null,{"$f":"F74*Q74*IF($Q$11<100,10,$Q$11*0.1)","v":0}]
[null,null,null,"                  : Year 2 (top-up)",null,{"$f":"+'Activity costing'!$E$5","v":27},null,null,null,{"$f":"F75*I75*IF($I$12<100,10,$I$12*0.1)","v":0},null,null,null,{"$f":"F75*M75*IF($M$12<100,10,$M$12*0.1)","v":0},null,null,null,{"$f":"F75*Q75*IF($Q$12<100,10,$Q$12*0.1)","v":0}]
[null,null,null,"                  : Year 3 (top-up)",null,{"$f":"+'Activity costing'!$E$5","v":27},null,null,null,{"$f":"F76*I76*IF($I$13<100,10,$I$13*0.1)","v":0},null,null,null,{"$f":"F76*M76*IF($M$13<100,10,$M$13*0.1)","v":0},null,null,null,{"$f":"F76*Q76*IF($Q$13<100,10,$Q$13*0.1)","v":0}]
[]
[null,null,null,"Coursework Moderation",null,{"$f":"+'Activity costing'!$E$6","v":27},null,null,null,{"$f":"SUM(J79:J83)","v":0},null,null,null,{"$f":"SUM(N79:N83)","v":0},null,null,null,{"$f":"SUM(R79:R83)","v":0},null,null,"Cost here is: cost of time for one moderation x number of courseworks x number of students (<100 students =10, >100 = 10% of student number)"]
[null,null,null,"                  : Year 1",null,{"$f":"+'Activity costing'!$E$6","v":27},null,null,null,{"$f":"F79*I79*IF($I$9<100,10,$I$9*0.1)","v":0},null,null,null,{"$f":"F79*M79*IF($M$9<100,10,$M$9*0.1)","v":0},null,null,null,{"$f":"F79*Q79*IF($Q$9<100,10,$Q$9*0.1)","v":0}]
[null,null,null,"                  : Year 2",null,{"$f":"+'Activity costing'!$E$6","v":27},null,null,null,{"$f":"F80*I80*IF($I$10<100,10,$I$10*0.1)","v":0},null,null,null,{"$f":"F80*M80*IF($M$10<100,10,$M$10*0.1)","v":0},null,null,null,{"$f":"F80*Q80*IF($Q$10<100,10,$Q$10*0.1)","v":0}]
[null,null,null,"                  : Year 3",null,{"$f":"+'Activity costing'!$E$6","v":27},null,null,null,{"$f":"F81*I81*IF($I$11<100,10,$I$11*0.1)","v":0},null,null,null,{"$f":"F81*M81*IF($M$11<100,10,$M$11*0.1)","v":0},null,null,null,{"$f":"F81*Q81*IF($Q$11<100,10,$Q$11*0.1)","v":0}]
[null,null,null,"                  : Year 2 (top-up)",null,{"$f":"+'Activity costing'!$E$6","v":27},null,null,null,{"$f":"F82*I82*IF($I$12<100,10,$I$12*0.1)","v":0},null,null,null,{"$f":"F82*M82*IF($M$12<100,10,$M$12*0.1)","v":0},null,null,null,{"$f":"F82*Q82*IF($Q$12<100,10,$Q$12*0.1)","v":0}]
[null,null,null,"                  : Year 3 (top-up)",null,{"$f":"+'Activity costing'!$E$6","v":27},null,null,null,{"$f":"F83*I83*IF($I$13<100,10,$I$13*0.1)","v":0},null,null,null,{"$f":"F83*M83*IF($M$13<100,10,$M$13*0.1)","v":0},null,null,null,{"$f":"F83*Q83*IF($Q$13<100,10,$Q$13*0.1)","v":0}]
[]
[null,null,null,"Dissertation Moderation",null,{"$f":"+'Activity costing'!$E$7","v":65},null,null,null,{"$f":"SUM(J86:J87)","v":0},null,null,null,{"$f":"IF(M85>0,($F85*M85),0)","v":0},null,null,null,{"$f":"IF(Q85>0,($F85*Q85),0)","v":0},null,null,"Cost here is: cost of time for one moderation x number of dissertations x number of students (<100 students =10, >100 = 10% of student number)"]
[null,null,null,"                  : Year 3",null,{"$f":"+'Activity costing'!$E$7","v":65},null,null,null,{"$f":"F86*I86*IF($I$11<100,10,$I$11*0.1)","v":0},null,null,null,{"$f":"F86*M86*IF($M$11<100,10,$M$11*0.1)","v":0},null,null,null,{"$f":"F86*Q86*IF($Q$11<100,10,$Q$11*0.1)","v":0}]
[null,null,null,"                  : Year 3 (top-up)",null,{"$f":"+'Activity costing'!$E$7","v":65},null,null,null,{"$f":"F87*I87*IF($I$13<100,10,$I$13*0.1)","v":0},null,null,null,{"$f":"F87*M87*IF($M$13<100,10,$M$13*0.1)","v":0},null,null,null,{"$f":"F87*Q87*IF($Q$11<100,10,$Q$11*0.1)","v":0}]
[]
[null,null,null,"Total Marking and Moderation Costs",null,null,null,null,null,{"$f":"+J53+J60+J67+J71+J78+J85","v":0},null,null,null,{"$f":"+N53+N60+N67+N71+N78+N85","v":0},null,null,null,{"$f":"+R53+R60+R67+R71+R78+R85","v":0}]
[]
[]
[null,"Other Quality Assurance Costs:-",null,null,null,null,null,null,null,"       £",null,null,null,"       £",null,null,null,"       £"]
[null,null,null,"External Examiner Fee",null,null,null,null,null,{"$f":"+'Activity costing'!C36","v":400},null,null,null,{"$f":"+J93","v":400},null,null,null,{"$f":"+'Activity costing'!C36","v":400}]
[null,null,null,"Reapproval Cost ( Programme Review)",null,null,null,null,null,{"$f":"+'Activity costing'!C18/3","v":2781.9519176817753},null,null,null,{"$f":"+'Activity costing'!C18/3","v":2781.9519176817753},null,null,null,{"$f":"+'Activity costing'!C18/3","v":2781.9519176817753}]
[]
[null,null,null,"    Note: cost split equally across 3 years",null,null,null,null,null,{"$f":"SUM(J93:J95)","v":3181.9519176817753},null,null,null,{"$f":"SUM(N93:N95)","v":3181.9519176817753},null,null,null,{"$f":"SUM(R93:R95)","v":3181.9519176817753}]
[]
[]
[null,"Staff Travel & Subsistence:-",null,null,null,"Cost Per trip ",null,null,"No. Of Trips","       £",null,null,"No. Of Trips","       £",null,null,"No. Of Trips","       £"]
[null,null,null,"Travel","Cost per flight",{"$f":"IF(Summary!$I$13=\"Europe\",'Activity costing'!$B$68,'Activity costing'!B65)","v":1000},null,null,null,{"$f":"IF(I100>0,($F100*I100),0)","v":0},null,null,null,{"$f":"IF(M100>0,($F100*M100),0)*(1+'Activity costing'!$D$40)","v":0},null,null,null,{"$f":"IF(Q100>0,($F100*Q100),0)*(1+'Activity costing'!$D$41)","v":0},null,null,"2% Annual Inflationary Rate"]
[null,null,null,"Accommodation ","Cost per night",150,null,null,null,{"$f":"IF(I101>0,($F101*I101),0)","v":0},null,null,null,{"$f":"IF(M101>0,($F101*M101),0)*(1+'Activity costing'!$D$40)","v":0},null,null,null,{"$f":"IF(Q101>0,($F101*Q101),0)*(1+'Activity costing'!$D$41)","v":0},null,null,"2% Annual Inflationary Rate"]
[null,null,null,"Living Expenses ","Cost per day",50,null,null,null,{"$f":"IF(I102>0,($F102*I102),0)","v":0},null,null,null,{"$f":"IF(M102>0,($F102*M102),0)*(1+'Activity costing'!$D$40)","v":0},null,null,null,{"$f":"IF(Q102>0,($F102*Q102),0)*(1+'Activity costing'!$D$41)","v":0},null,null,"2% Annual Inflationary Rate"]
[]
[null,null,null,"http://www.gre.ac.uk/offices/finance/regs/Financial-Regulations-1-April-2011-Approved-by-Court-on-28-March-2011-final-revised-Oct-11-DH-Revi-Feb-12-1.pdf",null,null,null,null,null,{"$f":"SUM(J100:J103)","v":0},null,null,null,{"$f":"SUM(N100:N103)","v":0},null,null,null,{"$f":"SUM(R100:R103)","v":0}]
[null,null,null,"Please see the web page above claims for guidance note of allowable business expenses incurred by staff"]
[]
[]
[null,"Estate Costs:-",null,null,null,null,null,null,"       FTE","           £",null,null,"       FTE","           £",null,null,"       FTE","           £"]
[]
[null,null,null,"xxx Principal Lecturer","@ TRAC costs",7713,null,null,{"$f":"I35","v":0.05},{"$f":"$F110*I110","v":385.65000000000003},null,null,{"$f":"M35","v":0.05},{"$f":"$F110*M110*(1+'Activity costing'!$B$44)","v":393.36300000000006},null,null,{"$f":"Q35","v":0.05},{"$f":"$F110*Q110*(1+'Activity costing'!$B$44)*(1+'Activity costing'!$B$44)","v":401.23026000000004},null,null,"2% Annual Pay Award "]
[null,null,null,"xxx Senior Lecturer",null,7713,null,null,{"$f":"I37","v":0.1},{"$f":"$F111*I111","v":771.30000000000007},null,null,{"$f":"M37","v":0.1},{"$f":"$F111*M111*(1+'Activity costing'!$B$44)","v":786.72600000000011},null,null,{"$f":"Q37","v":0.1},{"$f":"$F111*Q111*(1+'Activity costing'!$B$44)*(1+'Activity costing'!$B$44)","v":802.46052000000009},null,null,"2% Annual Pay Award "]
[null,null,null,"xxx Administration (Intl Collab)",null,7713,null,null,{"$f":"I39","v":0.1},{"$f":"$F112*I112","v":771.30000000000007},null,null,{"$f":"M39","v":0.1},{"$f":"$F112*M112*(1+'Activity costing'!$B$44)","v":786.72600000000011},null,null,{"$f":"Q39","v":0.1},{"$f":"$F112*Q112*(1+'Activity costing'!$B$44)*(1+'Activity costing'!$B$44)","v":802.46052000000009},null,null,"2% Annual Pay Award "]
[]
[null,null,null,"      Total",null,null,null,null,null,{"$f":"SUM(J108:J113)","v":1928.25},null,null,null,{"$f":"SUM(N108:N113)","v":1966.8150000000003},null,null,null,{"$f":"SUM(R108:R113)","v":2006.1513000000002}]
[]
[]
[null,"Indirect TRAC Costs :-",null,null,null,null,null,null,"       FTE","           £",null,null,null,"           £",null,null,null,"           £"]
[null,null,null,"Indirect TRAC Costs","@ TRAC costs",32826,null,null,{"$f":"SUM(I110:I112)","v":0.25},{"$f":"+$F$118*$I$118","v":8206.5},null,null,null,{"$f":"+J118*(1+'Activity costing'!D40)","v":8370.630000000001},null,null,null,{"$f":"+J118*(1+'Activity costing'!D41)","v":8538.0426000000007},null,null,"2% Annual Inflationary Rate"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J118:J118)","v":8206.5},null,null,null,{"$f":"SUM(N118:N118)","v":8370.630000000001},null,null,null,{"$f":"SUM(R118:R118)","v":8538.0426000000007}]
[]
[]
[null,"* Unit:  exam paper, an assignment, Dissertation"]
[null,"* Item: flight, night, etc"]
[null,"This FTE has been set by APC"]
[null,"Marketing is Events has been excluded from this version of the Business plan as it is part of the memorandum of agreement  that marketing cost would be entirely covered by the partners"]

{"sheet":"Activity costing","index":3,"n_rows":77,"n_cols":5,"rows_kept":77,"cut":false,"hidden":true,"merged":[[0,0,0,4],[3,0,3,2],[3,3,3,4],[7,0,7,2],[7,3,7,4]]}
["Activity Costs"]
["Variable costs:  Marking & Moderation"]
["Unit","Activity ","Activity Costs","Activity ","Activity Costs"]
["Marking",null,null,"Moderation of pieces of work "]
["Exam Paper","1 hour  (per paper)",{"$f":"ROUND(($E$30/7)/10,0)*10","v":50},"30 mins per paper",{"$f":"ROUND(($E$30/7)/60*30,0)","v":27}]
["Piece of Coursework ","1 hour (per piece) ",{"$f":"ROUND(($E$30/7)/10,0)*10","v":50},"30 mins per piece",{"$f":"ROUND(($E$30/7)/60*30,0)","v":27}]
["Dissertation ","3 hours ",{"$f":"ROUND($E$30/7*3/10,0)*10","v":160},"1.2 hours",{"$f":"ROUND(($E$30/7)*12/10,0)","v":65}]
["Setting a paper",null,null,"Approving someone else's  "]
["Exam Paper","1 ½ days (per paper)",{"$f":"ROUND($E$30*1.5/10,0)*10","v":570},"15 minutes ",{"$f":"ROUND(($E$30/7)/60*15/10,0)*10","v":10}]
["Piece of Coursework ","2-3 hours  ",{"$f":"ROUND($E$30/7*2/10,0)*10","v":110},"15 minutes ",{"$f":"ROUND(($E$30/7)/60*15/10,0)*10","v":10}]
[]
[]
[]
["Approval Costs (virtual event) "]
["Programme Design/ Document Preparation ","PL 14 days ",{"$f":"+E30*14","v":5279.8971962616824}]
["Approval Panel (4 UoG members)","HoD, PL, SL, Snr admin ",{"$f":"((E29*2)+(E30*1)+(E31*1)+(E32*2))","v":2065.9585567836434}]
["Approval Panel (External Member)","Fee and expenses ",1000]
[null,null,{"$f":"SUM(C15:C17)","v":8345.8557530453254}]
[]
["Approval Costs (onsite event) "]
["Programme Design/ Document Preparation ","PL 14 days ",{"$f":"E30*14","v":5279.8971962616824}]
["Approval Panel (4 UoG members)","HoD, PL, SL, Snr admin ",{"$f":"((E29*5)+(E30*5)+(E31*5)+(E32*5))","v":6884.2889153235938}]
["Approval Panel (External Member)","Fee and expenses ",2000]
["Plus travel and subsistence costs ",null,{"$f":"2000*5","v":10000}]
[null,null,{"$f":"SUM(C21:C24)","v":24164.186111585277}]
[]
["Approval Panel (4 UoG members)"]
["Job Title","Grades","Salary Cost Per Annum","No of working days per yer","Cost per day "]
["Head of Department","AC5 Midpoint",{"$f":"+'Spine points for template'!B38","v":96961},219,{"$f":"+C29/D29","v":442.74429223744295}]
["Principal Lecturer","AC4 Midpoint",{"$f":"+'Spine points for template'!B31","v":80707},214,{"$f":"+C30/D30","v":377.13551401869159}]
["Senior Lecturer","AC3 Midpoint",{"$f":"+'Spine points for template'!B22","v":66473},214,310.62149532710282]
["Senior admin staff","SG7 Midpoint",{"$f":"+'Spine points for template'!B81","v":53213},216,246.3564814814815]
[]
[]
["Reapproval Costs ","split over 3 years ",{"$f":"+C18","v":8345.8557530453254}]
["External Examiners fee",null,400]
[]
["Annual Inflationary Rate",null,null,0.02]
[null,null,"Year 1",0]
[null,null,"Year 2",{"$f":"$D$38","v":0.02}]
[null,null,"Year 3",{"$f":"(D40*(1+$D$38))+$D$38","v":4.0400000000000005E-2}]
[]
[null,"2012/13","2013/14","2014/15","2015/16"]
["Annual Pay Award &  London Weighting Increase",0.02,0.02,0.02,0.02]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Asia",1000]
["Africa",1000]
["Middle East",1000]
["Europe",500]
["North /South America and the Caribbean",1000]
[]
[]
[]
[]
["Setting Exam Paper",null,{"$f":"+C9","v":570}]
["Setting Coursework",null,{"$f":"+C10","v":110}]
["Approving Exam and Feedback when set by others",null,{"$f":"+E9","v":10}]
["Approving Coursework and Feedback when set by others",null,{"$f":"+E10","v":10}]

{"sheet":"Spine points for template","index":4,"n_rows":137,"n_cols":19,"rows_kept":137,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orgs"]
["AC1 - mid point",45952]
["AC1 - SP23",42342.018127940399,null,null,null,null,null,null,null,null,null,null,null,null,"School of CMS","0222",null,null,"Yes"]
["AC1 - SP24",43485.778281999999,null,null,null,null,null,null,null,null,null,null,null,null,"School of Design","0224",null,null,"No"]
["AC1 - SP25",44666.060399776157,null,null,null,null,null,null,null,null,null,null,null,null,"School of HSS","0226"]
["AC1 - SP26",45878.906024853117,null,null,null,null,null,null,null,null,null,null,null,null,"School of Law","0228"]
["AC1 - SP27",47129.350209628072,null,null,null,null,null,null,null,null,null,null,null,null,"Education","0321"]
["AC1 - SP28",48418.595051999997,null,null,null,null,null,null,null,null,null,null,null,null,"Business","0461"]
["AC1 - SP29",49745.641373999999,null,null,null,null,null,null,null,null,null,null,null,null,"School of Science","0541"]
["AC2 - mid point",54775,null,null,null,null,null,null,null,null,null,null,null,null,"Engineering","0641"]
["AC2 - SP30",51113.889626020151,null,null,null,null,null,null,null,null,null,null,null,null,"Health and Social Care","0721"]
["AC2 - SP31",52517.99670230256,null,null,null,null,null,null,null,null,null,null,null,null,"Health - Psychology & Counselling","0722"]
["AC2 - SP32",53969.604389999993,null,null,null,null,null,null,null,null,null,null,null,null,"Please select from the dropdown menu"]
["AC2 - SP33",55462.263890555994]
["AC2 - SP34",57001.123352914954]
["AC2 - SP35",58584.826126911532]
["AC3 - mid point",66473]
["AC3 - SP36",60218.283483999992]
["AC3 - SP37",61898.501513696647]
["AC3 - SP38",63664.975824000001]
["AC3 - SP39",65413.655154790562]
["AC3 - SP40",67250.850096285198]
["AC3 - SP41",69143.253453296653]
["AC3 - SP42",71090.036907999995]
["AC3 - SP43",73098.888012318246]
["AC4 - mid point",80707]
["AC4 - SP44",75165.165415880081]
["AC4 - SP45",77295.048335734566]
["AC4 - SP46",79487.665882000001]
["AC4 - SP47",81748.228899999987]
["AC4 - SP48",84074.68720081223]
["AC4 - SP49",86469.802192043993]
["AC5 - mid point",96961]
["AC5 - SP50",88938.887803447593]
["AC5 - SP51",91483.170534247198]
["AC5 - SP52",94104.321785994485]
["AC5 - SP53",96800.8184579136]
["AC5 - SP54",99578.456351556248]
["AC5 - SP55",102437.23546692239]
["AC5 - SP56",105387.29845672751]
["SG1 - mid point"]
["SG1 - SP1"]
["SG1 - SP2"]
["SG2 - mid point",28032]
["SG2 - SP3",27675.29]
["SG2 - SP4",28010.948]
["SG2 - SP5",28407.753000000001]
["SG3 - mid point",30230]
["SG3 - SP6",28812.363999999998]
["SG3 - SP7",29224.781000000003]
["SG3 - SP8",29645.004000000001]
["SG3 - SP9",30109.461000000003]
["SG3 - SP10",30648.075000000001]
["SG3 - SP11",31258.244000000002]
["SG3 - SP12",31919.152000000002]
["SG4 - mid point",34107]
["SG4 - SP13",32615.186999999998]
["SG4 - SP14",33332.038]
["SG4 - SP15",34071.006000000001]
["SG4 - SP16",34842.498999999996]
["SG4 - SP17",35675.138999999996]
["SG5 - mid point",38458]
["SG5 - SP18",36568.925999999999]
["SG5 - SP19",37475.722999999998]
["SG5 - SP20",38459.279000000002]
["SG5 - SP21",39388.192999999999]
["SG5 - SP22",40396.012612531194]
["SG6 - mid point",44864]
["SG6 - SP23",41447.699968322995]
["SG6 - SP24",42530.062464999995]
["SG6 - SP25",43646.986406829194]
["SG6 - SP26",44794.725829454401]
["SG6 - SP27",45978.045500964596]
["SG6 - SP28",47198.082989999995]
["SG6 - SP29",48453.892754999993]
["SG7 - mid point",53213]
["SG7 - SP30",49748.692708359195]
["SG7 - SP31",51077.426565097201]
["SG7 - SP32",52451.111174999991]
["SG7 - SP33",53863.643914469998]
["SG7 - SP34",55319.896577060194]
["SG7 - SP35",56818.585338312405]
["SG8 - mid point",64283]
["SG8 - SP36",58364.357829999994]
["SG8 - SP37",59954.380856356809]
["SG8 - SP38",61626.029880000002]
["SG8 - SP39",63280.839168157203]
["SG8 - SP40",65019.412501649]
["SG8 - SP41",66810.230633356812]
["SG8 - SP42",68652.509709999984]
["SG8 - SP43",70553.524611598797,null,null,null,null,216]
["SG9 - mid point",77753]
["SG9 - SP44",72508.883137954603,null,null,null,{"$f":"B88/G96","v":297.60648148148147},{"$f":"F98*6","v":1785.6388888888887}]
["SG9 - SP45",74524.432802437193,null,null,null,{"$f":"B97/G96","v":359.96759259259261},{"$f":"F99*3","v":1079.9027777777778}]
["SG9 - SP46",76599.349464999992,null,null,null,null,{"$f":"G98+G99","v":2865.5416666666665}]
["SG9 - SP47",78738.564249999996]
["SG9 - SP48",80940.137023753792,null,null,null,{"$f":"B88/365","v":176.11780821917807}]
["SG9 - SP49",83206.680960029989,null,null,null,{"$f":"F102/7*5","v":125.79843444227006}]
["SG10 - mid point",93136]
["SG10 - SP50",85543.224733986994]
["SG10 - SP51",87950.929005714002]
["SG10 - SP52",90431.375455032598]
["SG10 - SP53",92983.122742031992]
["SG10 - SP54",95611.655546533817]
["SG10 - SP55",98316.973868537985]
["SG10 - SP56",101108.67589773241]
["SMG1",81494.353829018655]
["SMG2",84263.278230782467]
["SMG3",87026.30188795006]
["SMG4",89798.176662011974]
["SMG5",92568.576249924823]
["SMG6",95343.401396284811]
["SMG7",98113.800984197675]
["SMG8",100882.72538596146]
["SMG9",103653.12497387434]
["SMG10",106423.52456178717]
["SMG11",109193.92414970002]
["SMG12",111967.27410991096]
["SMG13",114737.6736978238]
["SMG14",117503.6477272895]
["SMG15",120274.04731520236]
["SMG16",123047.39727541333]
["SMG17",125822.2224217733]
["SMG18",128591.14682353713]
["SMG19",131361.54641144996]
["SMG20",134130.47081321379]
["SMG21",136902.34558727566]
["SMG22",139675.69554748663]
["SMG23",142440.19439080326]
["SMG24",145213.54435101422]
["SMG25",147988.36949737419]
["None",0]

{"sheet":"New data","index":5,"n_rows":137,"n_cols":9,"rows_kept":137,"cut":false,"hidden":true,"merged":[]}
[]
[null,"The payroll data is the same we used for the bids template, ie. Data from Chris"]
[]
[null,"From new payscales",null,null,null,null,"The School and org code data is the most recent, the only one missing from the old list is Partnership Division as 0502 is no longer current, I do not know what the current arrangement is."]
[null,null,"No LW with OC","With LW and OC"]
["AC1 - mid point",30550,40780,45952,null,null,null,"Faculty of Liberal Arts & Sciences","0220"]
["AC1  SP23",27924.018422999998,37170.020527940396,42342.018127940399,null,null,null,"School of CMS","0222"]
["AC1  SP24",28755.964999999997,38313.780681999997,43485.778281999999,null,null,null,"School of Design","0224"]
["AC1  SP25",29614.476869199996,39494.062799776155,44666.060399776157,null,null,null,"School of HSS","0226"]
["AC1  SP26",30496.6747344,40706.908424853122,45878.906024853117,null,null,null,"School of Law","0228"]
["AC1  SP27",31406.220984599997,41957.352609628077,47129.350209628072,null,null,null,"Education","0321"]
["AC1  SP28",32343.989999999998,43246.597452000002,48418.595051999997,null,null,null,"Business","0461"]
["AC1  SP29",33309.254999999997,44573.643773999996,49745.641373999999,null,null,null,"School of Science","0541"]
["AC2 - mid point",36967,49603,54775,null,null,null,"Engineering","0641"]
["AC2  SP30",34304.489399199992,45941.892026020148,51113.889626020151,null,null,null,"Health and Social Care","0721"]
["AC2  SP31",35325.8067372,47345.999102302558,52517.99670230256,null,null,null,"Health - Psychology & Counselling","0722"]
["AC2  SP32",36381.674999999996,48797.606789999991,53969.604389999993]
["AC2  SP33",37467.403469999997,50290.266290555992,55462.263890555994]
["AC2  SP34",38586.736800199993,51829.125752914952,57001.123352914954]
["AC2  SP35",39738.688192400004,53412.828526911529,58584.826126911532]
["AC3 - mid point",45476,61301,66473]
["AC3  SP36",40926.829999999994,55046.28588399999,60218.283483999992]
["AC3  SP37",42148.984516800003,56726.503913696644,61898.501513696647]
["AC3  SP38",43433.88,58492.978223999999,63664.975824000001]
["AC3  SP39",44705.8317972,60241.65755479056,65413.655154790562]
["AC3  SP40",46042.167949000002,62078.85249628521,67250.850096285198]
["AC3  SP41",47418.661516800006,63971.25585329665,69143.253453296653]
["AC3  SP42",48834.709999999992,65918.039307999992,71090.036907999995]
["AC3  SP43",50295.9051588,67926.890412318244,73098.888012318246]
["AC4 - mid point",55830,75535,80707]
["AC4  SP44",51798.870974599995,69993.167815880079,75165.165415880081]
["AC4  SP45",53348.102077199997,72123.050735734563,77295.048335734566]
["AC4  SP46",54942.964999999997,74315.668281999999,79487.665882000001]
["AC4  SP47",56587.249999999993,76576.231299999999,81748.228899999987]
["AC4  SP48",58279.465813799994,78902.689600812228,84074.68720081223]
["AC4  SP49",60021.621029999995,81297.804592044005,86469.802192043993]
["AC5 - mid point",67653,91789,96961]
["AC5  SP50",61817.580886999996,83766.89020344759,88938.887803447593]
["AC5  SP51",63668.237514,86311.172934247195,91483.170534247198]
["AC5  SP52",65574.806652600004,88932.324185994483,94104.321785994485]
["AC5  SP53",67536.180431999994,91628.820857913597,96800.8184579136]
["AC5  SP54",69556.574593800004,94406.458751556245,99578.456351556248]
["AC5  SP55",71635.98913799999,97265.237866922384,102437.23546692239]
["AC5  SP56",73781.801612399999,100215.30085672751,105387.29845672751]
["SG1 - mid point",0]
["SG1  SP1",0]
["SG1  SP2",0]
["SG2 - mid point",17612,21693,28032]
["SG2  SP3",17338,21336.817999999999,27675.29]
["SG2  SP4",17596,21672.476000000002,28010.948]
["SG2  SP5",17901,22069.281000000003,28407.753000000001]
["SG3 - mid point",19302,23892,30230]
["SG3  SP6",18212,22473.892,28812.363999999998]
["SG3  SP7",18529,22886.308999999997,29224.781000000003]
["SG3  SP8",18852,23306.531999999999,29645.004000000001]
["SG3  SP9",19209,23770.988999999998,30109.461000000003]
["SG3  SP10",19623,24309.602999999999,30648.075000000001]
["SG3  SP11",20092,24919.772000000001,31258.244000000002]
["SG3  SP12",20600,25580.68,31919.152000000002]
["SG4 - mid point",22282,27769,34107]
["SG4  SP13",21135,26276.715,32615.186999999998]
["SG4  SP14",21686,26993.565999999999,33332.038]
["SG4  SP15",22254,27732.534000000003,34071.006000000001]
["SG4  SP16",22847,28504.027000000002,34842.498999999996]
["SG4  SP17",23487,29336.667000000001,35675.138999999996]
["SG5 - mid point",25626,32119,38458]
["SG5  SP18",24174,30230.454000000002,36568.925999999999]
["SG5  SP19",24871,31137.250999999997,37475.722999999998]
["SG5  SP20",25627,32120.807000000001,38459.279000000002]
["SG5  SP21",26341,33049.720999999998,39388.192999999999]
["SG5  SP22",27115.649971199997,34057.540612531193,40396.012612531194]
["SG6 - mid point",30550,38526,44864]
["SG6  SP23",27924.018422999998,35109.227968322994,41447.699968322995]
["SG6  SP24",28755.964999999997,36191.590464999994,42530.062464999995]
["SG6  SP25",29614.476869199996,37308.514406829192,43646.986406829194]
["SG6  SP26",30496.6747344,38456.253829454399,44794.725829454401]
["SG6  SP27",31406.220984599997,39639.573500964601,45978.045500964596]
["SG6  SP28",32343.989999999998,40859.610990000001,47198.082989999995]
["SG6  SP29",33309.254999999997,42115.420754999992,48453.892754999993]
["SG7 - mid point",36967,46875,53213]
["SG7  SP30",34304.489399199992,43410.220708359193,49748.692708359195]
["SG7  SP31",35325.8067372,44738.9545650972,51077.426565097201]
["SG7  SP32",36381.674999999996,46112.639174999989,52451.111174999991]
["SG7  SP33",37467.403469999997,47525.171914469996,53863.643914469998]
["SG7  SP34",38586.736800199993,48981.424577060192,55319.896577060194]
["SG7  SP35",39738.688192400004,50480.113338312411,56818.585338312405]
["SG8 - mid point",45476,57945,64283]
["SG8  SP36",40926.829999999994,52025.885829999992,58364.357829999994]
["SG8  SP37",42148.984516800003,53615.908856356808,59954.380856356809]
["SG8  SP38",43433.88,55287.557879999993,61626.029880000002]
["SG8  SP39",44705.8317972,56942.367168157201,63280.839168157203]
["SG8  SP40",46042.167949000002,58680.940501649005,65019.412501649]
["SG8  SP41",47418.661516800006,60471.758633356811,66810.230633356812]
["SG8  SP42",48834.709999999992,62314.03770999999,68652.509709999984]
["SG8  SP43",50295.9051588,64215.052611598803,70553.524611598797]
["SG9 - mid point",55830,71415,77753]
["SG9  SP44",51798.870974599995,66170.411137954594,72508.883137954603]
["SG9  SP45",53348.102077199997,68185.960802437199,74524.432802437193]
["SG9  SP46",54942.964999999997,70260.877464999998,76599.349464999992]
["SG9  SP47",56587.249999999993,72400.092250000002,78738.564249999996]
["SG9  SP48",58279.465813799994,74601.665023753798,80940.137023753792]
["SG9  SP49",60021.621029999995,76868.208960029995,83206.680960029989]
["SG10 - mid point",67653,86796,93136]
["SG10  SP50",61817.580886999996,79204.752733986999,85543.224733986994]
["SG10  SP51",63668.237514,81612.457005713994,87950.929005714002]
["SG10  SP52",65574.806652600004,84092.903455032603,90431.375455032598]
["SG10  SP53",67536.180431999994,86644.650742031998,92983.122742031992]
["SG10  SP54",69556.574593800004,89273.183546533808,95611.655546533817]
["SG10  SP55",71635.98913799999,91978.501868537991,98316.973868537985]
["SG10  SP56",73781.801612399999,94770.203897732397,101108.67589773241]
["SMG1",56131.75576739791,75950.01782901866,81494.353829018655]
["SMG2",58145.811922303212,78718.942230782457,84263.278230782467]
["SMG3",60155.576002291287,81481.965887950064,87026.30188795006]
["SMG4",62171.778194655199,84253.840662011979,89798.176662011974]
["SMG5",64186.907368289802,87024.240249924827,92568.576249924823]
["SMG6",66205.255598112315,89799.065396284816,95343.401396284811]
["SMG7",68220.384771746918,92569.464984197664,98113.800984197675]
["SMG8",70234.440926652213,95338.389385961462,100882.72538596146]
["SMG9",72249.57010028683,98108.788973874325,103653.12497387434]
["SMG10",74264.699273921418,100879.18856178716,106423.52456178717]
["SMG11",76279.828447556021,103649.58814970002,109193.92414970002]
["SMG12",78297.103658649226,106422.93810991096,111967.27410991096]
["SMG13",80312.232832283815,109193.33769782379,114737.6736978238]
["SMG14",82324.142949730507,111959.3117272895,117503.6477272895]
["SMG15",84339.272123365125,114729.71131520237,120274.04731520236]
["SMG16",86356.547334458344,117503.06127541333,123047.39727541333]
["SMG17",88374.895564280843,120277.88642177331,125822.2224217733]
["SMG18",90388.951719186152,123046.81082353712,128591.14682353713]
["SMG19",92404.080892820741,125817.21041144997,131361.54641144996]
["SMG20",94418.13704772605,128586.13481321376,134130.47081321379]
["SMG21",96434.339240089947,131358.00958727565,136902.34558727566]
["SMG22",98451.614451183166,134131.35954748662,139675.69554748663]
["SMG23",100462.45154990054,136895.85839080327,142440.19439080326]
["SMG24",102479.72676099376,139669.20835101421,145213.54435101422]
["SMG25",104498.07499081625,142444.03349737418,147988.36949737419]
["SMG26",106508.91208953364,145208.53234069084,150752.86834069085]
["SMG27",108526.18730062686,147981.88230090181,153526.21830090179]