{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Ethics and Consents","Costings","MOU info"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"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":"Summary","index":0,"n_rows":106,"n_cols":29,"rows_kept":106,"cut":false,"hidden":false,"merged":[[48,1,48,2],[55,1,55,8],[52,1,52,8],[43,1,43,2],[53,1,53,8],[54,1,54,8],[48,7,48,8],[49,3,49,5],[48,3,48,5],[49,1,49,2],[65,1,65,8],[58,1,58,8],[59,1,59,8],[60,1,60,8],[61,1,61,8],[62,1,62,8],[63,1,63,8],[64,1,64,8],[39,3,39,5],[43,3,43,5],[35,7,35,8],[35,3,35,5],[31,1,33,8],[36,7,36,8],[36,3,36,5],[42,3,42,5],[38,3,38,5],[42,7,42,8],[1,4,1,6],[1,7,1,8],[3,2,3,6],[4,6,4,8],[39,1,39,2],[39,7,39,8],[35,1,35,2],[38,1,38,2],[29,7,29,8],[30,7,30,8],[5,2,5,8],[30,3,30,5],[36,1,36,2],[9,5,9,6],[9,7,9,8],[18,1,18,2],[0,1,0,8],[4,2,4,4],[2,3,2,8],[29,3,29,5],[29,1,29,2],[12,1,12,2],[27,3,27,5],[19,6,19,8],[20,1,20,2],[21,1,21,2],[21,3,21,4],[13,1,13,2],[26,1,26,2],[14,1,14,2],[15,1,15,2],[27,1,27,2],[57,1,57,8],[7,7,7,8],[8,5,8,6],[8,7,8,8],[6,7,6,8],[19,1,19,2],[56,1,56,8],[43,7,43,8],[26,3,26,5],[26,7,26,8],[42,1,42,2],[30,1,30,2],[7,2,7,4],[25,3,25,4],[23,3,23,4],[22,3,22,4],[11,1,11,2],[16,1,16,2],[17,1,17,2],[27,7,27,8],[13,6,13,10],[22,1,22,2],[21,6,22,9],[24,9,24,10]]}
[null,"University of Otago Costing and Consents Worksheet",null,null,null,null,null,null,null," ",null,null,null,null,null,"Calculations page"]
[null,"Research Advisor or Business Development Manager",null,null,"Date of creation/change:",null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,null,null,null,"Departments",null,"ISR Code","Dept O/H"]
[null,"PI: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead Rate",105,null,"Title","Prof",null,"Super",null,null,"Accountancy & Finance","DB","10.DB.A01","10.DB.A01"]
[null,"Department:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124,null,null,"A.Prof",null,"Uni",6.7500000000000004E-2,null,"Anatomy","LA","10.LA.A01","10.LA.C01"]
[null,"Research Unit: ",null,null,null,"Division:",null,null,null,null,null,null,null,null,null,null,null,"Full",null,null,"Dr",null,"Gvt",0.13300000000000001,null,"Archaeology","AE","10.AE.A03","10.AE.A12"]
[null,"Project title: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",null,null,"Mr",null,"Kiwi",0.03,null,"Applied Sciences","IF","10.IF.A02","10.IF.A02"]
[null,"Start Date:",null,"End Date: ",null,null,"REDS Contract # ",null,null,null,null,null,"No",null,null,null,"GST Rate",0.15,null,null,"Mrs",null,"None",0,null,"Biochemistry","LH","10.LH.A01","10.LH.A04"]
[null,"Funding Body:",null,null,null,null,"Funder Contract # ",null,null,null,null,null,"Yes",null,null,null,"Acc Levy",6.0000000000000001E-3,null,null,"Ms",null,null,null,null,"Biostatistics Teaching","OR","10.OR.A01","10.OR.A01"]
[null,"New project:","Yes","Variation:",null,"Finance 1 Acc # ",null,null,null,null,null,null,null,null,null,null,"Holiday pay rate",1.08,null,null,null,null,null,null,null,"Bioethics","OW","10.OW.C01","10.OW.C01"]
[null,"PBRF?","Yes",null,null,"Linked Acc # ",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Botany","FC","10.FC.A01","10.FC.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"  ",null,null,"RA/EM",null,null,null,"National Science Challenges",null,null,null,null,"Centre For Irish and Scottish Studies","AQ","10.AQ.A01","10.AQ.A01"]
[null,"All Years",null,"Full Cost","Price",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable",null,null,null,null,"Centre for Materials Science & Technology","IM","10.IM.A02","10.IM.A02"]
[null,"Travel",null,{"$f":"Costings!M7","v":0},{"$f":"D13","v":0},null,null,null,null,null,null,null,null,null,null,null,"AC","Ali Cameron",null,null,"1 A Better Start",null,null,null,null,"Centre for Childrens Issues","EA","10.EA.A01","10.EA.A01"]
[null,"Consumables",null,{"$f":"Costings!M26","v":0},{"$f":"D14","v":0},null,"Enter ANZSRC codes for F.O.R & S.E.O ",null,null,null,null,"FOR codes",null,null,null,null,"AT","Amarni Thomas",null,null,"2 Ageing Well",null,null," ",null,"Centre for Science Communication","FY","10.FY.A03","10.FY.A03"]
[null,"Equipment",null,{"$f":"Costings!M35","v":0},{"$f":"D15","v":0},null,"FOR","%","SEO","%",null,"https://royalsociety.org.nz/what-we-do/research-practice/field-of-research-calculator",null,null,null,null,"AO","Annie O'Connell",null,null,"3 Healthier Lives  ",null,null,null,null,"Chemistry","FE","10.FE.A50","10.FE.C01"]
[null,"Students",null,{"$f":"Costings!M42","v":0},{"$f":"D16","v":0},null,null,null,null,null,null,null,null,null,null,null,"CL","Carthika Luxmanan",null,null,"4 High-Value Nutrition",null,null,null,null,"Classics","AG","10.AG.C01","10.AG.C01"]
[null,"Profit",null,null,null,null,null,null,null,null,null,"% of each code must add up to 100% and be multiples of 10",null,null,null,null,"CA","Chelvica Ariyanayagam"," ",null,"5 New Zealand’s Biological Heritage",null,null,null,null,"Commerce Divisional Office","DE","Contact Admin","Contact Admin"]
[null,"TOTAL ex GST",null,{"$f":"SUM(D13:D16)","v":0},{"$f":"SUM(E13:E17)","v":0},null,null,null,null,null,null,null,null,null,null,null,"XG","Christine Groves",null,null,"6 Our Land and Water",null,null,null,null,"Computer Science","FH","10.FH.A01","10.FH.C01"]
[null,"GST",null,{"$f":"D18*0.15","v":0},{"$f":"E18*0.15","v":0},null,"Type of Activity (TOA)",null,null,null,null,"SEO codes",null,null,null,null,"DP","David Powell",null,null,"7 Resilience to Nature's Challenges",null,null,null,null,"CSAFE","AT","10.AT.C03","10.AT.C03"]
[null,"GRAND TOTAL",null,{"$f":"D18+D19","v":0},{"$f":"E18+E19","v":0},null,null,null,null,null,null,"https://royalsociety.org.nz/what-we-do/research-practice/socio-economic-objectives-calculator",null,null,null,null,"DR","Diana Rothstein",null,null,"8 Science for Technological Innovation  ",null,null,null,null,"Dental Clinics","JH","10.JH.A01"]
[null,"Cost/Price Difference (ex GST)",null,null,{"$f":"E18-D18","v":0},null,"Keywords",null,null,null,null,null,null,null,null,null,"EM","Edwin Meijerink",null,null,"9 Sustainable Seas",null,null,null,null,"Dental School","JD","10.JD.A21","10.JD.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EH","Elizabeth Hogbin",null,null,"10 The Deep South",null,null,null,null,"Dietetics","FN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EO","Emily Oughton",null,null,"11 Building Better Homes, Towns, and Cities",null,null,null,null,"Dodd-Walls CORE","FQ","10.FQ.C04","10.FQ.C01"]
[null,"Authorisation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EL","Eric Lord",null,null,null,null,null,null,null,"DSM - Dean's Office","NB","10.NB.A01","10.NB.A01"]
[null,"ALL INFORMATION PROVIDED IS TRUE AND CORRECT",null,null,null,null,null,null,"GST included in price ?","Yes",null,null,null,null,null,null,"FM","Fran Munro",null,null,null,null,null,null,null,"DSM - General Practice and Rural Health","NC","10.NC.C02","10.NC.C02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IC","Ian Cooke",null,null,null,null,null,null,null,"DSM - Medicine","NJ","10.NJ.A01","10.NJ.C01"]
[null,{"$f":"CONCATENATE(C3,\" \",D3)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JN","Jacqui Nielsen",null,null,"Decision","Yes","No",null,null,"DSM - Pathology","NE","10.NE.C10","10.NE.C10"]
[null,"Applicant/ Supervisor",null,"Signature",null,null,null,"Date",null,null,null,null,null,null,null,null,"KB","Kate Berard",null,null,null,"No","Yes",null,null,"DSM - Preventive & Social Medicine","NF","10.NF.A01","10.NF.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KG","Kerry Galvin",null,null,null,null,null,null,null,"DSM - Psychological Medicine","NG","10.NG.C01","10.NG.C01"]
[null,{"$f":"Costings!B40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ES","EJ Sinclair",null,null,null,null,null,null,null,"DSM - Surgical Sciences","NK","10.NK.A01","10.NK.C01"]
[null,"Student (If applicable)",null,"Signature",null,null,null,"Date",null,null,null,null,null,null,null,null,"MW","Michelle Walker",null,null,"Division","Health Sciences",null,null,null,"DSM - Womens & Child Health","NH","10.NH.C10","10.NH.C10"]
[null,"Recommendations: I hereby endorse this application/proposal to undertake this research/ activity on behalf of the University and guarantee the availability of facilities, equipment and any special support which may be required as detailed in the application/proposal. I confirm that it is in accordance with current University policy. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MG","Mary Gower",null,null,null,"Sciences",null,null,null,"Economics","DM","10.DM.A01","10.DM.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M_R","Melanie Remy",null,null,null,"Commerce",null,null,null,"English and Linguistics","AO","10.AO.A01","10.AO.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MB","Melony Black",null,null,null,"Humanities",null,null,null,"Executive Programmes","DA",null,"10.DA.A11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MD","Muriel Dufour",null,null,null,"Academic",null,null,null,"External Engagement - Divisional Office","YS","10.YS.C01","10.YS.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MX","Natalie Harfoot",null,null,null,"Research",null,null,null,"Faculty of Law","EA","10.EA.A01","10.EA.A01"]
[null,"HOD",null,"Signature",null,null,null,"Date",null,null,null,null,null,null,null,null,"NB","Nina Barton",null,null,null,null,null,null,null,"Food Science","IC","10.IC.A06","10.IC.A06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PF","Paul Foster-Bell",null,null,"Res_Unit","Not Applicable",null,null,null,"Geography","AT","10.AT.A04","10.AT.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RE","Rachel Elliot",null,null,null,"Anaesthesia",null,null,null,"Geology","FK","10.FK.A01","10.FK.A01"]
[null,"Dean / PVC",null,"Signature",null,null,null,"Date",null,null,null,null,null,null,null,null,"DG","David Grimmett",null,null,null,"Brain Health Res Cnt",null,null,null,"Health Sciences Divisional Office","OZ","10.OZ.C01","10.OZ.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SB","Suzanne Benjes",null,null,null,"Bioengineering",null,null,null,"Health Sciences Pacific","OS","10.OS.C01","10.OS.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SH","Sam Heenan",null,null,null,"BRNZ",null,null,null,"Higher Education Development Centre","TF","10.TF.A01","10.TF.A01"]
[null,{"$f":"C2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of Activity","TR","Tomas Ribeiro",null,null,null,"CCERG",null,null,null,"History","BA","10.BA.A01","10.BA.A01"]
[null,"Research & Enterprise",null,"Signature",null,null,null,"Date",null,null,null,null,null,null,null,null,"TS","Tamsin Sheen",null,null,null,"Centre Entrepreneur",null,null,null,"Human Nutrition","FM","10.FM.C01","10.FM.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VB","Val Berry",null,null,null,"Centre for Int Hlth",null,null,null,"Humanities Divisional Office","AC"]
[null,"APPROVED By",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CKRG",null,null,null,"Indigenous Science","FI","10.FI.A01","10.FI.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clothing & Textile",null,null,null,"Information Science","DL","10.DL.A01","10.DL.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pure Basic Research",null,null,null,null,"CRCF",null,null,null,"Kōhatu—Centre for Hauora Māori","OV","10.OV.A03","10.OV.A03"]
[null,{"$f":"IF(E18>50000,\"Prof Richard Blaikie\", \"Dr Martin Gagnon\")","v":"Dr Martin Gagnon"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strategic Basic Research",null,null,null,null,"CSAFE",null,null,null,"Languages and Cultures","AF","10.AF.A07","10.AF.A07"]
[null,{"$f":"IF(B49=\"Dr Martin Gagnon\",\"Director (R&E)\",\"DVC(R)\")","v":"Director (R&E)"},null,"Signature",null,null,null,"Date",null,null,null,null,null,null,null,"Status","Applied Research",null,null,null,null,"Chair Viral Path",null,null,null,"Management","DG","10.DG.A01","10.DG.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimental Development",null,null,null,null,"Core Department",null,null,null,"Marine Science","FS","Various - Chk","10.FS.C01"]
[null,"Comments (Please date any new comments)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Services Non-PBRF",null,null,null,null,"Design Studies",null,null,null,"Marketing","DI","10.DI.A01","10.DI.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diabetes",null,null,null,"Mathematics & Statistics","FO","10.F0.C54","10.FO.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DMHDRU",null,null,null,"Media Film & Communications","AI","10.AI.A01","10.AI.A02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct-Academic 2111",1,null,null,null,"Dodd-Walls Ctr CoRE",null,null,null,"Microbiology & Immunology","LI","10.LI.C01","10.LI.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct-General 2211",2,null,null,null,"ELPD Centre",null,null,null,"School of Performing Arts","BI","10.BI.A01","10.BI.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"student","Direct-Casual 2221",3,null,null,null,"Genomics Aotearoa",null,null,null,"Otago Medical School","OY",null,"10.OY.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indirect - Academic 7611",4,null,null,null,"Gastro",null,null,null,"OU College of Education","BP","10.BP.A12","10.BP.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indirect - General 7612",5,null,null,null,"Gerontol",null,null,null,"National Centre for Peace and Conflict Studies","AP","10.AP.C01","10.AP.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HAU",null,null,null,"Pharmacology & Toxicology","LM","10.LM.A99","10.LM.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Injury Prevention",null,null,null,"Pharmacy","LZ","10.LZ.A02","10.LZ.C07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equip type","PhD",null,null,null,null,"LAPBRF",null,null,null,"Philosophy","BM","10.BM.A01","10.BM.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Masters",null,null,null,null,"NAC",null,null,null,"Physics","FP","10.FP.A50","10.FP.A50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hons",null,null,null,null,"Neuro",null,null,null,"Physiology","LP","10.LP.A01","10.LP.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer",null,null,null,null,"Nat Poisons Centre",null,null,null,"Political Studies","BO","10.BO.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NSCAW Research Centr",null,null,null,"Psychology","FU","10.FU.A01","10.FU.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8846,"Equipment",null,null,null,"NSCHL Research Centr",null,null,null,"Religion","CB","10.CB.A01","10.CB.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8848,"Computers",null,null,null,"Ngai Tahu Maori Hlth",null,null,null,"Research Divisional Office","YJ","10.YJ.C01","10.YJ.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8851,"Furniture",null,null,null,null,null,null,null,"Research Infrastructure Centre","OX","10.OX.C02","10.OX.C02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZPhvC",null,null,null,"School of Arts","BB","10.BB.A01","10.BB.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5141,null,null,null,null,"Orthopaedic Surgery",null,null,null,"School of Physical Education Sport & Exercise Sciences","HA","10.HA.A01","10.HA.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product Develop",null,null,null,"School of Physiotherapy","LX","10.LX.A01","10.LX.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5151,null,null,null,null,"Preventive and Socia",null,null,null,"School of Social Sciences","AJ","10.AJ.A01","10.AJ.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5171,null,null,null,null,"Psych Med",null,null,null,"Sciences Divisional Office","FA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radiology",null,null,null,"Social Anthropology","AE","10.AE.A03","10.AE.A12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Respirat",null,null,null,"Sociology, Gender Studies and Criminology","BR","10.BR.A01","10.BR.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rheumatol",null,null,null,"Social and Community Work","BR","10.BR.A01","10.BR.C01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Social& Behaviourial",null,null,null,"Surveying","FW","104030.01.S.FW","10.FW.C02    "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southern Pacific Arc",null,null,null,"Te Tumu: School of Maori, Pacific & Indigenous Studies","BG","10.BG.A01","10.BG.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surgery UoC",null,null,null,"Theology","CA","10.CA.A01","10.CA.A01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Theatre Studies",null,null,null,"Tourism Department","DT","10.DT.A03 ","10.DT.A03 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US Federally Funded",null,null,null,"UOC - Centre PG Nursing Studies","PN","10.PI.C16","10.PI.C20"]
[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,"UOC - Deans Dept","PI","10.PI.C16","10.PI.C20"]
[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,"UOC - General Practice","PG","10.PI.C16","10.PI.C20"]
[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,"UOC - Medicine","PM","10.PI.C16","10.PI.C20"]
[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,"UOC - Obstetrics & Gynaecology","PP","10.PI.C16","10.PI.C20"]
[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,"UOC - Orthopaedics","QN","10.PI.C16","10.PI.C20"]
[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,"UOC - Paediatrics","PX","10.PI.C16","10.PI.C20"]
[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,"UOC - Pathology & Biomedical Science","PZ","10.PI.C16","10.PI.C20"]
[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,"UOC - Population Health","PH","10.PI.C16","10.PI.C20"]
[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,"UOC - Psychological Medicine","QF","10.PI.C16","10.PI.C20"]
[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,"UOC - Surgery","QN","10.PI.C16","10.PI.C20"]
[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,"UOC - Surgery, Orthopaedics, Anaesthesia & Radiology","QN","10.PI.C16","10.PI.C20"]
[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,"UOC- Anatomy","QN","10.PI.C16","10.PI.C20"]
[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,"UOC- Radiology","QN","10.PI.C15","10.PI.C20"]
[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,"UOW - Deans Dept","RU","10.RU.C02","10.RU.C02"]
[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,"UOW - Medicine","RZ","10.RZ.A22","10.RZ.C01"]
[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,"UOW - Obstetrics & Gynaecology& Womens health","RF","10.RF.A32","10.RF.C01"]
[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,"UOW - Paediatrics","RJ","10.RJ.A73","10.RJ.C01"]
[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,"UOW - Pathology","RG","10.RG.A42","10.RG.C01"]
[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,"UOW - Primary Health Care & GP","RS","10.RS.A11","10.RS.C01"]
[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,"UOW - Psychological Medicine","RP","10.RP.A52","10.RP.C01"]
[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,"UOW - Public Health","RL","10.RL.A14","10.RL.C01"]
[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,"UOW - Radiation Therapy","RM","10.RM.A36","10.RM.C01"]
[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,"UOW - Surgery & Anaesthesia","RH","10.RH.A62","10.RH.C01"]
[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,"Zoology","FZ","10.FZ.A50","10.FZ.C01"]

{"sheet":"Ethics and Consents","index":1,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[[14,7,14,11],[33,0,34,0],[47,0,47,14],[2,9,2,11],[6,5,6,10],[3,0,3,1],[7,5,7,10],[13,0,13,4],[13,5,13,6],[14,1,14,5]]}
["STATUTORY & REGULATORY CONSENTS AND APPROVALS SECTION"]
[]
["Ethical Approval:"]
["Needed?",null,null,null,"Human",null,"Animal"]
["Application made",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["Approval given and attached",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
["Research Location (eg.UoO)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
["Ethical Approval Number(s)"]
["Development Approvals (Hazardous Substances and New Organisms (HSNO) Act):"]
[]
["Does this project involve the development of an organism modified "]
[null,"through the use of recombinant DNA techniques (ie, a GMO)?"]
["Is the development approved under HSNO?"]
["Copy of approval is enclosed."]
[null,"Development Approval Number "]
["Approval to be secured before development is initiated"]
["Importation Approvals (Hazardous Substances and New Organisms (HSNO) Act)"]
[]
["Does this project involve the importation of an organism modified "]
[null,"through the use of recombinant DNA techniques (ie, a GMO)?"]
["Is the importation approved under HSNO?"]
[null,"Approval applied for"]
[null,"Copy of approval attached"]
["Is the importation covered by a valid MPI permit?"]
[null,"Permit  applied for"]
[null,"Copy of importation permit attached"]
[]
["Other Regulatory Consents (eg, DoC, MAF, Fish & Game, etc):"]
["Are any other approvals required?"]
["Has application been made for the relevant Approval(s)?"]
["Has the relevant Approval(s) been given?"]
[null,"Copy of approval is enclosed."]
[]
["NOTE:"]
[]
["The Researcher, under the supervision of the HOD, will be held accountable for ensuring that all ethical "]
["and/or regulatory obligations are met throughout the research and that all appropriate consultation is made."]
["Evidence of all Approvals must be received by the Research Office before funds can be released."]
["or before importing organisms."]
["Maori Consultation:  "]
["It is a requirement that all research has appropriate consultation with Maori prior to "]
["commencing http://www.otago.ac.nz/research/maoriconsultation/"]
[]
["Has consultation been initiated/undertaken through the University process?"]
["Has consultation been initiated/undertaken through any other process?"]
[null,"Copy of evidence (eg, correspondence) is enclosed"]
["Has consultation reached a conclusion?"]

{"sheet":"Costings","index":2,"n_rows":44,"n_cols":19,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,9],[22,1,22,4],[23,1,23,4],[18,1,18,4],[12,1,12,4],[9,1,9,4],[10,1,10,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[8,1,8,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[11,1,11,4],[19,1,19,4],[13,1,13,4],[40,1,40,3],[39,1,39,3],[33,1,33,4],[17,1,17,4],[29,1,29,4],[28,1,28,4],[24,1,24,4],[20,1,20,4],[21,1,21,4]]}
[null,"University of Otago Costing and Consents Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PhD","y"]
[null,"Travel",null,null,null,1,2,3,4,5,6]
[3351,null,null,null,null,null,null,null,null,null,null,null,null,3351,"Airfares - Domestic"]
[3351,null,null,null,null,null,null,null,null,null,null,null,null,3356,"Airfares - International"]
[3351,null,null,null,null,null,null,null,null,null,null,null,null,3361,"Accommodation"]
[3351,null,null,null,null,null,null,null,null,null,null,null,null,3371,"Mileage Reimbursements"]
[null,null,null,null,null,{"$f":"SUM(F3:F6)","v":0},0,0,0,0,0,null,{"$f":"SUM(F7:K7)","v":0},3376,"Taxi and Car Rentals"]
[null,"Consumables",null,null,null,1,2,3,4,5,6,null,null,3395,"Travel Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3451,"Vehicle Expenses - Fuel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3456,"Vehicle Expenses - Other"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3111,"Printing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3115,"Photocopier/Printer Supplies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3121,"Postage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3125,"Courier & Freight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3211,"Equipment Maintenance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3213,"Equipment Rental"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3216,"Equipment Purchases (Minor)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3241,"Chemicals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3246,"Gas Cylinders"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3248,"Samples Analysis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3279,"Laboratory Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3281,"General Materials"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3321,"Computer Equipment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3416,"Publications"]
[null,null,null,null,null,{"$f":"SUM(F9:F25)","v":0},0,0,0,0,0,null,{"$f":"SUM(F26:K26)","v":0},3495,"Sundry Operating Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3411,"Media"]
[null,"Equipment",null,null,null,1,2,3,4,5,6,null,null,3450,"Other Operational Expenses"]
[8846,null,null,null,null,null,null,null,null,null,null,null,null,3135,"Mobile Phone/Device Costs"]
[8846]
[8846,null,null,null,null,null,null,null,null,null,null,null,null,8846,"Equipment"]
[8846,null,null,null,null,null,null,null,null,null,null,null,null,8848,"Computers"]
[8846]
[8846]
[null,null,null,null,null,{"$f":"SUM(F29:F34)","v":0},0,0,0,0,0,null,{"$f":"SUM(F35:K35)","v":0}]
[]
[]
[null,"Post Graduate Students",null,null,null,"Y1","Y2","Y3","Y4","Y5","Y6"]
[3616,null,null,null,"Stipend",null,null,null,null,null,null,null,null,{"$f":"SUM(F39:K39)","v":0},null,null,"Phd"]
[3611,null,null,null,"Fees",null,null,null,null,null,null,null,null,{"$f":"SUM(F40:K40)","v":0},null,null,"Masters"]
[3691,null,null,null,"Thesis",null,null,null,null,null,null,null,null,{"$f":"SUM(F41:K41)","v":0},null,null,"Hons"]
[null,null,null,null,null,{"$f":"SUM(F39:F41)","v":0},0,0,0,0,0,null,{"$f":"SUM(F42:K42)","v":0},null,null,null,"Summer "]
[]
[null,null,null,null,"Total",{"$f":"F42+F35+F26+F7","v":0},0,0,0,0,0,null,{"$f":"SUM(F44:K44)","v":0}]

{"sheet":"MOU info","index":3,"n_rows":76,"n_cols":12,"rows_kept":76,"cut":false,"hidden":true,"merged":[[6,3,6,6],[75,1,76,1],[8,3,9,6],[25,2,25,5],[15,3,15,5],[24,2,24,5],[26,2,26,5],[29,1,34,6],[70,1,71,1],[71,3,72,5],[17,3,17,6],[21,2,21,5],[22,2,22,5],[23,2,23,5]]}
[]
[null,null,null,"Memorandum of Understanding"]
[]
[1,"Parties to the Memorandum:",null,null,null,null,null,null,null,4,"Select MOU to generate"]
[null,"University:",null,"University of Otago"]
[]
[null,"Subcontractor:",null,{"$f":"VLOOKUP($J$4,$J$8:$L$12,2)","v":{"$error":"#REF!"}},null,null,null,null,null,null,"Subcontracted staff"]
[null,null,null,null,null,null,null,null,null,1,{"$f":"Costings!#REF!","v":{"$error":"#REF!"}},{"$f":"Costings!#REF!","v":{"$error":"#REF!"}}]
[2,"Short Title of Project",null,{"$f":"Summary!$C$6","v":0},null,null,null,null,null,2,{"$f":"Costings!#REF!","v":{"$error":"#REF!"}},{"$f":"Costings!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,3,{"$f":"Costings!#REF!","v":{"$error":"#REF!"}},{"$f":"Costings!#REF!","v":{"$error":"#REF!"}}]
[3,"Research Project Funding Body:",null,{"$f":"Summary!$C$8","v":0},null,null,null,null,null,4,{"$f":"Costings!#REF!","v":{"$error":"#REF!"}},{"$f":"Costings!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,5,{"$f":"Costings!#REF!","v":{"$error":"#REF!"}},{"$f":"Costings!#REF!","v":{"$error":"#REF!"}}]
[4,"Term of Research Project:",null,{"$f":"Summary!$C$7","v":"00:00:00"},"to ",{"$f":"Summary!$E$7","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!C3","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!D3","v":0}]
[5,"Principal Investigator, University:",null,{"$f":"CONCATENATE(K14,\" \",K15)","v":"0 0"}]
[]
[6,"Key Personnel, Subcontractor: ",null,{"$f":"VLOOKUP($J$4,$J$8:$L$12,3)","v":{"$error":"#REF!"}}]
[]
[]
[7,"Contact Details, Subcontractor:"]
[null,"Address:"]
[]
[]
[null,"Phone:"]
[]
[null,"Email:"]
[]
[8,"Brief Description of Research Subcontractors to Supply:"]
[]
[]
[]
[]
[]
[]
[]
[9,"Intended Level of Funding:"]
[null,"The University will pay the Subcontractor a maximum value of",null,null,null,{"$f":"SUM(C51:H51)","v":{"$error":"#REF!"}},"(Inc GST)"]
[null,"for the total period of the grant (subject to funding provided by the Sponsor)."]
[]
[null,"OH rate used",null,"%"]
[null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"Name(s)","FTE","FTE","FTE","FTE","FTE"]
[null,null,"%","%","%","%","%"]
[null,"Salary cost"]
[null,"Overheads ",{"$f":"(C45*$C$41)/100","v":0},{"$f":"(D45*$C$41)/100","v":0},{"$f":"(E45*$C$41)/100","v":0},{"$f":"(F45*$C$41)/100","v":0},{"$f":"(G45*$C$41)/100","v":0}]
[null,"Salary costs"]
[null,"Consumables"]
[null,"Sub Total",{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0},{"$f":"SUM(F45:F48)","v":0},{"$f":"SUM(G45:G48)","v":0}]
[null,"        GST",{"$f":"C49*GST_Rate","v":{"$error":"#REF!"}},{"$f":"D49*GST_Rate","v":{"$error":"#REF!"}},{"$f":"E49*GST_Rate","v":{"$error":"#REF!"}},{"$f":"F49*GST_Rate","v":{"$error":"#REF!"}},{"$f":"G49*GST_Rate","v":{"$error":"#REF!"}}]
[null,"TOTAL (incl GST)",{"$f":"SUM(C49:C50)","v":{"$error":"#REF!"}},{"$f":"SUM(D49:D50)","v":{"$error":"#REF!"}},{"$f":"SUM(E49:E50)","v":{"$error":"#REF!"}},{"$f":"SUM(F49:F50)","v":{"$error":"#REF!"}},{"$f":"SUM(G49:G50)","v":{"$error":"#REF!"}}]
[]
[]
[10,"Agreement"]
[null,"This Memorandum formalises the intention of the parties to collaborate in the research "]
[null,"project outlined above and to enter into a sub-contract.  "]
[null,"Commencement of the research project is subject to the parties reaching a mutually "]
[null,"satisfactory final agreement on the terms and conditions of the sub-contract following  "]
[null,"confirmation of the final funding level allocated by the Sponsor and agreement on "]
[null,"intellectual property matters."]
[null,"Should the requested Level of Funding be reduced by the Funding Body, then the University "]
[null,"in discussion with the Subcontractor) will determine the re-allocation funds based on the "]
[null,"Funding Bodies decision in a manner which maintains equity in the funding of the project."]
[]
[null,"If the subcontractor is a Tertiary Education Organisation (TEO), the allocation of funding "]
[null,"recognised for Performance Based Researched Funding (PBRF) assessment purposes, will be "]
[null,"negotiated between the parties upon entering into a sub-contract"]
[]
[]
[null,"Signed by:"]
[null,"Authorised signatory of the University",null,null,null,null,"Date"]
[null,null,null,"Acting Assoc. Dean of Research & Post Graduate Studies"]
[]
[]
[null,"Signed by:"]
[null,"Authorised signatory of the Subcontractor",null,null,null,null,"Date"]