{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["General report","2nd Party","3rd Party","Maximum Salary","Lists","Summary","list"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":25,"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":"General report","index":0,"n_rows":81,"n_cols":7,"rows_kept":81,"cut":false,"hidden":false,"merged":[[77,4,77,5],[65,1,65,5],[66,1,66,5],[67,1,67,5],[68,1,68,5],[73,4,73,5],[73,0,74,1],[72,1,72,5],[70,1,70,5],[28,4,28,5],[47,4,47,5],[50,4,50,5],[23,1,23,5],[26,1,26,5],[27,1,27,5],[41,4,41,5],[33,0,34,1],[36,0,37,1],[41,2,41,3],[55,1,55,5],[52,4,52,5],[53,4,53,5],[60,1,60,5],[61,1,61,5],[62,1,62,5],[63,4,63,5],[58,1,58,5],[30,0,30,2],[5,0,5,6],[12,4,12,5],[13,4,13,5],[15,4,15,5],[9,0,10,2],[30,4,30,5],[51,4,51,5],[14,4,14,5],[22,1,22,5],[24,1,24,5],[25,1,25,5],[38,0,39,2],[0,0,0,6],[16,4,16,5],[17,4,17,5],[20,1,20,5],[21,1,21,5],[7,0,8,0],[12,2,12,3],[13,2,13,3],[15,2,15,3],[14,2,14,3],[16,2,16,3],[17,2,17,3],[18,4,18,5],[51,0,52,0],[49,0,49,6],[42,4,42,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[42,2,42,3],[79,6,80,6],[79,4,80,5],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[75,4,75,5],[59,1,59,5],[46,4,46,5],[56,1,56,5],[57,1,57,5],[75,0,80,1],[71,1,71,5]]}
["Nano-Tera.ch ED Budget form"]
[]
["Activity Acronym "]
["PI name & institution"]
[]
["A. Nano-Tera Funds"]
[]
["Personnel",null,null,null,"Senior Researcher","max. 215'000 CHF"]
[null,null,null,null,"Technician","max. 125'000 CHF"]
["The full year salary (per year, per full-time position, including social charges) cannot exceed the maximum eligible amounts provided here. The amount is calculated based on 1'824 working hours/year.",null,null,null,"Post Doc","max. 100'000 CHF"]
[null,null,null,null,"PhD student","max.   62'000 CHF"]
[]
["Surname, first name","Position","Nb. hours spent",null,"Full yearly salary",null,"Amount (CHF)"]
[null,"(select)",null,null,null,null,{"$f":"IF(OR(AND(B14=\"Senior Researcher\",E14>215000),AND(B14=\"Technician\",E14>125000),AND(B14=\"Post Doc\",E14>100000),AND(B14=\"PhD student\",E14>62000)),\"Exceeds eligible salary!\",ROUND(20*C14*E14/1824,0)/20)","v":0}]
[null,"(select)",null,null,null,null,{"$f":"IF(OR(AND(B15=\"Senior Researcher\",E15>215000),AND(B15=\"Technician\",E15>125000),AND(B15=\"Post Doc\",E15>100000),AND(B15=\"PhD student\",E15>62000)),\"Exceeds eligible salary!\",ROUND(20*C15*E15/1824,0)/20)","v":0}]
[null,"(select)",null,null,null,null,{"$f":"IF(OR(AND(B16=\"Senior Researcher\",E16>215000),AND(B16=\"Technician\",E16>125000),AND(B16=\"Post Doc\",E16>100000),AND(B16=\"PhD student\",E16>62000)),\"Exceeds eligible salary!\",ROUND(20*C16*E16/1824,0)/20)","v":0}]
[null,"(select)",null,null,null,null,{"$f":"IF(OR(AND(B17=\"Senior Researcher\",E17>215000),AND(B17=\"Technician\",E17>125000),AND(B17=\"Post Doc\",E17>100000),AND(B17=\"PhD student\",E17>62000)),\"Exceeds eligible salary!\",ROUND(20*C17*E17/1824,0)/20)","v":0}]
[null,"(select)",null,null,null,null,{"$f":"IF(OR(AND(B18=\"Senior Researcher\",E18>215000),AND(B18=\"Technician\",E18>125000),AND(B18=\"Post Doc\",E18>100000),AND(B18=\"PhD student\",E18>62000)),\"Exceeds eligible salary!\",ROUND(20*C18*E18/1824,0)/20)","v":0}]
[null,null,null,"A1","Total",null,{"$f":"SUM(G14:G18)","v":0}]
["Equipment, consumables, miscellaneous"]
["Category","Details",null,null,null,null,"Amount (CHF)"]
["(select)",null,null,null,null,null,0]
["(select)",{"$f":"IF(A23=\"(select)\",\"\",\"Please specify\")","v":""},null,null,null,null,0]
["(select)",{"$f":"IF(A24=\"(select)\",\"\",\"Please specify\")","v":""},null,null,null,null,0]
["(select)",{"$f":"IF(A25=\"(select)\",\"\",\"Please specify\")","v":""},null,null,null,null,0]
["(select)","",null,null,null,null,0]
["(select)",{"$f":"IF(A27=\"(select)\",\"\",\"Please specify\")","v":""},null,null,null,null,0]
["(select)","",null,null,null,null,0]
[null,null,null,"A2","Total",null,{"$f":"SUM(G22:G28)","v":0}]
[]
["The standard requested funding A is maximum 10'000 CHF. You may request up to 33'000 CHF provided that the name of the workshop or conference includes the text \"Nano-Tera.ch\" in its title",null,null,"A","Total Nano-Tera Funds",null,{"$f":"G19+G29","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G31>33000, \"Cannot exceed 33'000 CHF!\", \"\")","v":""}]
["B. Matching Funds"]
["        (own contributions & third party contributions)",null,null,null,"Full professor","max. 325'000 CHF"]
[null,null,null,null,"Associate professor","max. 290'000 CHF"]
[null,null,null,null,"Assistant professor","max. 250'000 CHF"]
["Personnel",null,null,null,"Senior Researcher","max. 215'000 CHF"]
[null,null,null,null,"Technician","max. 125'000 CHF"]
["The full year salary (per year, per full-time position, including social charges) cannot exceed the maximum eligible amounts provided here. The amount is calculated based on 1'824 working hours/year.",null,null,null,"Post Doc","max. 100'000 CHF"]
[null,null,null,null,"PhD student","max.   62'000 CHF"]
[]
["Surname, first name","Position","Nb. hours spent",null,"Full yearly salary",null,"Amount (CHF)"]
[null,"(select)",null,null,null,null,{"$f":"IF(OR(AND(B43=\"Full professor\",E43>325000), AND(B43=\"Associate professor\",E43>290000), AND(B43=\"Assistant professor\",E43>255000),AND(B43=\"Senior Researcher\",E43>215000),AND(B43=\"Technician\",E43>125000),AND(B43=\"Post Doc\",E43>100000),AND(B43=\"PhD student\",E43>62000)),\"Exceeds eligible salary!\",ROUND(20*C43*E43/1824,0)/20)","v":0}]
[null,"(select)",null,null,null,null,{"$f":"IF(OR(AND(B44=\"Full professor\",E44>325000), AND(B44=\"Associate professor\",E44>290000), AND(B44=\"Assistant professor\",E44>255000),AND(B44=\"Senior Researcher\",E44>215000),AND(B44=\"Technician\",E44>125000),AND(B44=\"Post Doc\",E44>100000),AND(B44=\"PhD student\",E44>62000)),\"Exceeds eligible salary!\",ROUND(20*C44*E44/1824,0)/20)","v":0}]
[null,"(select)",null,null,null,null,{"$f":"IF(OR(AND(B45=\"Full professor\",E45>325000), AND(B45=\"Associate professor\",E45>290000), AND(B45=\"Assistant professor\",E45>255000),AND(B45=\"Senior Researcher\",E45>215000),AND(B45=\"Technician\",E45>125000),AND(B45=\"Post Doc\",E45>100000),AND(B45=\"PhD student\",E45>62000)),\"Exceeds eligible salary!\",ROUND(20*C45*E45/1824,0)/20)","v":0}]
[null,"(select)",null,null,null,null,{"$f":"IF(OR(AND(B46=\"Full professor\",E46>325000), AND(B46=\"Associate professor\",E46>290000), AND(B46=\"Assistant professor\",E46>255000),AND(B46=\"Senior Researcher\",E46>215000),AND(B46=\"Technician\",E46>125000),AND(B46=\"Post Doc\",E46>100000),AND(B46=\"PhD student\",E46>62000)),\"Exceeds eligible salary!\",ROUND(20*C46*E46/1824,0)/20)","v":0}]
[null,"(select)",null,null,null,null,{"$f":"IF(OR(AND(B47=\"Full professor\",E47>325000), AND(B47=\"Associate professor\",E47>290000), AND(B47=\"Assistant professor\",E47>255000),AND(B47=\"Senior Researcher\",E47>215000),AND(B47=\"Technician\",E47>125000),AND(B47=\"Post Doc\",E47>100000),AND(B47=\"PhD student\",E47>62000)),\"Exceeds eligible salary!\",ROUND(20*C47*E47/1824,0)/20)","v":0}]
[null,null,null,"B1","Total",null,{"$f":"SUM(G43:G47)","v":0}]
["Institutional overheads"]
["Indirect costs linked to the project can also be considered as own contributions, notably infrastructure services provided by each institution for the performance of the project. More precisely, the official institutional overhead rate (typically 40%) on the amount A and B1 above can be considered as matching contribution. In the table below, only enter your institution's overhead rate."]
["Institutional overhead rate (%)","Category",null,null,"Raw amount",null,"Amount (CHF)"]
[null,"Total Nano-Tera Funding A",null,null,{"$f":"G31","v":0},null,{"$f":"A52*E52","v":0}]
[null,"Personnel own contributions B1",null,null,{"$f":"G48","v":0},null,{"$f":"A52*E53","v":0}]
[null,null,null,"B2","Total",null,{"$f":"SUM(G52:G53)","v":0}]
["Equipment, consumables, miscellaneous"]
["Category","Details",null,null,null,null,"Amount (CHF)"]
["(select)",null,null,null,null,null,0]
["(select)",{"$f":"IF(A58=\"(select)\",\"\",\"Please specify\")","v":""},null,null,null,null,0]
["(select)",{"$f":"IF(A59=\"(select)\",\"\",\"Please specify\")","v":""},null,null,null,null,0]
["(select)",{"$f":"IF(A60=\"(select)\",\"\",\"Please specify\")","v":""},null,null,null,null,0]
["(select)","",null,null,null,null,0]
["(select)",{"$f":"IF(A62=\"(select)\",\"\",\"Please specify\")","v":""},null,null,null,null,0]
["(select)","",null,null,null,null,0]
[null,null,null,"B3","Total",null,{"$f":"SUM(G57:G63)","v":0}]
["Third party contributions"]
["In kind / In cash?","Details",null,null,null,null,"Amount (CHF)"]
["(select)",{"$f":"IF(A67=\"(select)\",\"\",\"Please specify\")","v":""},null,null,null,null,0]
["(select)",{"$f":"IF(A68=\"(select)\",\"\",\"Please specify\")","v":""},null,null,null,null,0]
["(select)","",null,null,null,null,0]
["(select)",{"$f":"IF(A70=\"(select)\",\"\",\"Please specify\")","v":""},null,null,null,null,0]
["(select)","",null,null,null,null,0]
["(select)",{"$f":"IF(A72=\"(select)\",\"\",\"Please specify\")","v":""},null,null,null,null,0]
["(select)","",null,null,null,null,0]
["Space for additional remarks",null,null,"B4","Total",null,{"$f":"SUM(G67:G73)","v":0}]
[]
[null,null,null,"B","Total Matching Funds",null,{"$f":"G48+G54+G64+G74","v":0}]
[]
[null,null,null,"A+B","OVERALL TOTAL",null,{"$f":"G31+G76","v":0}]
[]
[null,null,null,"  B  ","% of matching contributions\n(this value MUST be at least 55%)",null,{"$f":"IF(G78>0,G76/G78,\"\")","v":""}]
[null,null,null,"A+B"]

{"sheet":"2nd Party","index":1,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":true,"merged":[[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[30,1,30,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[20,1,20,3],[21,1,21,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[17,1,17,3],[18,1,18,3]]}
[]
[null,"Second-Party Funds",null,null,null,"Project Title:",null,{"$f":"'General report'!B3","v":0}]
[null,"(e.g. SNF, CTI, EU, NIH)",null,null,null,"NT.ch int.ref.:",null,{"$f":"'General report'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
["Please, send a copy of the contract(s) between your institution and the second-party to Nano-Tera.ch"]
[]
[]
[]
["Contract Partner 1:",null,null,null,null,"% Year 2009","CHF\n"]
[]
["Contact Person:"]
["Function:"]
["Address:"]
[]
["Phone:"]
["Fax:"]
["E-Mail:"]
[]
["Contract Partner 2:",null,null,null,null,"% Year 2009","CHF\n"]
[]
["Contact Person:"]
["Function:"]
["Address:"]
[]
["Phone:"]
["Fax:"]
["E-Mail:"]
[]
["Contract Partner 3:",null,null,null,null,"% Year 2009","CHF\n"]
[]
["Contact Person:"]
["Function:"]
["Address:"]
[]
["Phone:"]
["Fax:"]
["E-Mail:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Total CHF"]
[null,null,null,null,"TOTAL Second-Party Funds: ",null,{"$f":"(G12*F12%)+(G22*F22%)+(G32*F32%)","v":0}]

{"sheet":"3rd Party","index":2,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":true,"merged":[[31,1,31,3],[32,1,32,3],[33,1,33,3],[38,1,38,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[30,1,30,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[21,1,21,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[17,1,17,3],[20,1,20,3],[18,1,18,3]]}
[]
[null,"Third-Party Funds",null,null,null,"Project Title:",null,{"$f":"'General report'!B3","v":0}]
[null,"(e.g. industry, SME)",null,null,null,"NT.ch int.ref.:",null,{"$f":"'General report'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
["Please, send a copy of the contract(s) between your institution and the third-party to Nano-Tera.ch, signed by the industrial partner"]
["IF you have third-party funds, please complete the document \"3rd Party details\""]
[]
[]
["Contract Partner 1:",null,null,null,null,"% Year 2009","CHF"]
[]
["Contact Person:"]
["Function:"]
["Address:"]
[]
["Phone:"]
["Fax:"]
["E-Mail:"]
[]
["Contract Partner 2:",null,null,null,null,"% Year 2009","CHF"]
[]
["Contact Person:"]
["Function:"]
["Address:"]
[]
["Phone:"]
["Fax:"]
["E-Mail:"]
[]
["Contract Partner 3:",null,null,null,null,"% Year 2009","CHF\n"]
[]
["Contact Person:"]
["Function:"]
["Address:"]
[]
["Phone:"]
["Fax:"]
["E-Mail:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Total CHF"]
[null,null,null,null,"TOTAL Third-Party Funds: ",null,{"$f":"(G12*F12%)+(G22*F22%)+(G32*F32%)","v":0}]

{"sheet":"Maximum Salary","index":3,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["NT.ch Function:","CHF"]
["Senior Researcher",150000]
["PostDoc",120000]
["Technician",120000]
["PhD student",61000]
["Scientific Assistant",100000]
["Other",0]
[]
["OC Function:","CHF"]
["Professor",250000]
["Assistant Professor",180000]
["Senior Researcher",150000]
["PostDoc",120000]
["Technician",120000]
["PhD student",61000]
["Scientific Assistant",100000]

{"sheet":"Lists","index":4,"n_rows":230,"n_cols":6,"rows_kept":230,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Period"]
["Project name",null,"Project number",null,"Starting date"]
[]
["COMES",null,null,null,"2009-09-23"]
["EducationalKit",null,null,null,"2008-11-07"]
["TEDActivities",null,null,null,"2009-09-01"]
["PMD-Program",null,null,null,"2008-03-01"]
["ULP-Logic",null,null,null,"2008-10-01"]
[null,null,null,null,"2008-08-01"]
[]
[]
[]
[]
["Institute",null,"Cost Category",null,"Type","Type2"]
[null,null,"Nano-Tera",null,"Consumables","Equipment planned"]
["EPFL",null,"Own Contributions",null,"Miscellaneous","Exist. Equipment"]
["ETHZ"]
["FSRM"]
["USI"]
[null,null,null,null,"Type3","Type4"]
[null,null,null,null,"OC Personnel","Consumables"]
[null,null,null,null,null,"Miscellaneous"]
[]
[]
[]
[]
[]
[]
[]
["PI & CO PI Name"]
["Sebastian MAERKL"]
["Yusuf LEBLEBICI"]
["Mariagiovanna SAMI"]
["Daniel ROGGEN"]
["Dennis MAJOE"]
["Philippe FISCHER"]
["Nicolaas de ROOIJ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NT.ch Function:","CHF"]
["Senior Researcher",150000]
["PostDoc",120000]
["Technician",120000]
["PhD student",61000]
["Scientific Assistant",100000]
["Other",0]
[]
["OC Function:","CHF"]
["Professor",250000]
["Assistant Professor",180000]
["Senior Researcher",150000]
["PostDoc",120000]
["Technician",120000]
["PhD student",61000]
["Scientific Assistant",100000]
[]
["Purchase Year"]
[]
[2009]
[2010]
[2011]
[2012]
[2013]
[]
["%"]
[]
[0.01]
[2.5000000000000001E-2]
[0.05]
[7.4999999999999997E-2]
[0.1]
[0.125]
[0.15]
[0.16]
[0.17499999999999999]
[0.2]
[0.22500000000000001]
[0.25]
[0.27500000000000002]
[0.3]
[0.32500000000000001]
[0.35]
[0.375]
[0.4]
[0.42499999999999999]
[0.45]
[0.47499999999999998]
[0.5]
[0.52500000000000002]
[0.55000000000000004]
[0.57499999999999996]
[0.6]
[0.625]
[0.65]
[0.67500000000000004]
[0.7]
[0.72499999999999998]
[0.75]
[0.77500000000000002]
[0.8]
[0.82499999999999996]
[0.85]
[0.875]
[0.9]
[0.92500000000000004]
[0.95]
[0.97499999999999998]
[1]
[]
["From"]
["2009-03-01"]
["2009-03-15"]
["2009-04-01"]
["2009-04-15"]
["2009-05-01"]
["2009-05-15"]
["2009-06-01"]
["2009-06-15"]
["2009-07-01"]
["2009-07-15"]
["2009-08-01"]
["2009-08-15"]
["2009-09-01"]
["2009-09-15"]
["2009-10-01"]
["2009-10-15"]
["2009-11-01"]
["2009-11-15"]
["2009-12-01"]
["2009-12-15"]
[]
["Until"]
["2009-06-15"]
["2009-06-30"]
["2009-07-15"]
["2009-07-31"]
["2009-08-15"]
["2009-08-31"]
["2009-09-15"]
["2009-09-30"]
["2009-10-15"]
["2009-10-31"]
["2009-11-15"]
["2009-11-30"]
["2009-12-15"]
["2009-12-31"]
[]
["Number of months employed"]
[1]
[1.5]
[2]
[2.5]
[3]
[3.5]
[4]
[4.5]
[5]
[5.5]
[6]
[6.5]
[7]
[7.5]
[8]
[8.5]
[9]
[9.5]
[10]
[10.5]
[11]
[11.5]
[12]

{"sheet":"Summary","index":5,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,"Nano-Tera Funds",null,null,null,"Matching contributions (own contrib. & 3rd party)"]
[null,null,"Personnel",{"$f":"'General report'!G19","v":0},"A1",null,"Personnel",{"$f":"'General report'!G48","v":0},"B1"]
[null,null,"Equipment, consumables, misc.",{"$f":"'General report'!G29","v":0},"A2",null,"Institutional overheads",{"$f":"'General report'!G54","v":0},"B2"]
[null,null,null,{"$f":"'General report'!G31","v":0},"A",null,"Equipment, consumables, misc.",{"$f":"'General report'!G64","v":0},"B3"]
[null,null,null,null,null,null,"Third party contributions",{"$f":"'General report'!G74","v":0},"B4"]
[null,null,null,null,null,null,null,{"$f":"'General report'!G76","v":0},"B"]

{"sheet":"list","index":6,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Données"]
["(select)"]
["Equipment"]
["Consumables"]
["Miscellaneous"]
[]
["(select)"]
["in kind"]
["in cash"]
[]
["(select)"]
["Senior Researcher"]
["Technician"]
["Post Doc"]
["PhD student"]
[]
["(select)"]
["Full professor"]
["Associate professor"]
["Assistant professor"]
["Senior Researcher"]
["Technician"]
["Post Doc"]
["PhD student"]