{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Consolidation","SysX.ch Pers.","SysX.ch Equip. ","SystX.ch Cons.","SystX.ch Misc","OC Pers."," OC Equipment","OC Cons.","OC Misc","2nd Party Pers.","2nd Party Equip. & Cons. & Misc","3rd Party Pers.","3rd Party Equip. & Cons. & Misc","Tables"],"not_rendered":{"images":3,"defined_names":33,"comments":11},"read":"whole","date_system":"1900"}

{"sheet":"Consolidation","index":0,"n_rows":39,"n_cols":6,"rows_kept":39,"merged":[[0,1,0,4],[4,5,5,6],[5,1,5,2],[15,1,15,2],[16,5,16,6],[17,6,18,6],[19,1,19,2],[19,6,20,6],[21,6,22,6],[24,5,24,6],[25,6,26,6],[27,6,28,6],[29,6,30,6],[32,5,32,6],[33,6,34,6],[35,6,36,6],[37,6,38,6]]}
[null,"Please fill out one reporting file per project and institution"]
[null,"IPhD - Annual Financial Report 2017"]
[]
[null,"General Information:"]
[{"$nulls":4},"Project Title: "]
[null,"Principal Investigator (PI)"]
[null,"Institution:"]
[null,"Institute/Department:"]
[]
[null,"Surname:",null,null,"Reporting period:"]
[null,"First Name:"]
[{"$nulls":4},"Your int.ref.:"]
[]
[{"$nulls":4},"SysX.ch int.ref.:"]
[]
[null,"Your Institution"]
[null,"Institution:",{"$nulls":3},"Confirmation: Grant recipient / account holder at your institution"]
[null,"Institute/Department:"]
[{"$nulls":5},"Place, date:"]
[null,"Contact (e.g. Co-PI)"]
[null,"Surname:",{"$nulls":3},"Name, First Name:"]
[null,"First Name:"]
[null,"Position:",{"$nulls":3},"Signature:"]
[]
[{"$nulls":5},"Confirmation:  Finance Department"]
[null,"Total for whole project:","Year 2017  in CHF"]
[{"$nulls":5},"Place, date:"]
[null,"Total SystemsX.ch Funds:\n",{"$f":"'SysX.ch Pers.'!J23+'SystX.ch Misc'!I33+'SysX.ch Equip. '!$I$23+'SystX.ch Cons.'!I33","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Name, First Name:"]
[null,"Total Own Contributions:\n",{"$f":"'OC Pers.'!L22+'OC Misc'!K23+' OC Equipment'!K27+'OC Cons.'!K24","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Signature:"]
[null,"Total Second-Party Funds:",{"$f":"'2nd Party Pers.'!L31+'2nd Party Equip. & Cons. & Misc'!H22","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Confirmation: Rector / president / dean (optional) (optional)"]
[null,"Total Third-Party Funds:",{"$f":"'3rd Party Pers.'!L31+'3rd Party Equip. & Cons. & Misc'!H22","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Place, date:"]
[null,"Total Funds whole Project:",{"$f":"C28+C30+C32+C34","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Name, First Name:"]
[]
[{"$nulls":5},"Signature:"]

{"sheet":"SysX.ch Pers.","index":1,"n_rows":23,"n_cols":11,"rows_kept":23,"merged":[[1,4,1,7],[2,0,2,2],[3,0,3,6]]}
[]
["SystemsX.ch Funds",null,null,"Project Titel:",{"$f":"Consolidation!F5","v":0}]
["Personnel",null,null,"SystX.ch int.ref.:",{"$f":"Consolidation!F14","v":0}]
["Please provide details for ALL personnel involved in the project paid with SystemsX.ch, and not simply totals per group"]
[]
[null,{"$f":"J23","v":0}]
["Project","Institution","Research Group","Funding Category","Cost Type","Name ","Internal Reference/ Personnel Number","Function (of the Personnel)","Number of months employed (0.5-23)","Total CHF 2017","Comments"]
[{"$f":"E2","v":0},null,null,"SystemsX.ch","Personnel"]
[{"$f":"A8","v":0},null,null,"SystemsX.ch","Personnel"]
[{"$f":"A9","v":0},null,null,"SystemsX.ch","Personnel"]
[0,null,null,"SystemsX.ch","Personnel"]
[0,null,null,"SystemsX.ch","Personnel"]
[0,null,null,"SystemsX.ch","Personnel"]
[0,null,null,"SystemsX.ch","Personnel"]
[0,null,null,"SystemsX.ch","Personnel"]
[0,null,null,"SystemsX.ch","Personnel"]
[0,null,null,"SystemsX.ch","Personnel"]
[0,null,null,"SystemsX.ch","Personnel"]
[0,null,null,"SystemsX.ch","Personnel"]
[0,null,null,"SystemsX.ch","Personnel"]
[0,null,null,"SystemsX.ch","Personnel"]
[]
[{"$nulls":9},{"$f":"SUM(J8:J22)","v":0}]

{"sheet":"SysX.ch Equip. ","index":2,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[1,4,1,6],[2,0,2,2],[3,0,3,6]]}
[]
["SystemsX.ch Funds",null,null,"Project Titel:",{"$f":"Consolidation!F5","v":0}]
["Equipment",null,null,"SystX.ch int.ref.:",{"$f":"Consolidation!F14","v":0}]
[]
[]
[null,{"$f":"I23","v":{"v":0,"d":"0.00"}}]
["Project","Institution","Research Group","Funding Category","Cost Type","Description","Internal Reference","Purchase date","Total CHF 2017","Comments"]
[{"$f":"E2","v":0},null,null,"SystemsX.ch","Equipment"]
[{"$f":"A8","v":0},null,null,"SystemsX.ch","Equipment"]
[{"$f":"A9","v":0},null,null,"SystemsX.ch","Equipment"]
[0,null,null,"SystemsX.ch","Equipment"]
[0,null,null,"SystemsX.ch","Equipment"]
[0,null,null,"SystemsX.ch","Equipment"]
[0,null,null,"SystemsX.ch","Equipment"]
[0,null,null,"SystemsX.ch","Equipment"]
[0,null,null,"SystemsX.ch","Equipment"]
[0,null,null,"SystemsX.ch","Equipment"]
[0,null,null,"SystemsX.ch","Equipment"]
[0,null,null,"SystemsX.ch","Equipment"]
[0,null,null,"SystemsX.ch","Equipment"]
[0,null,null,"SystemsX.ch","Equipment"]
[]
[{"$nulls":8},{"$f":"SUM(I8:I21)","v":{"v":0,"d":"0.00"}}]

{"sheet":"SystX.ch Cons.","index":3,"n_rows":33,"n_cols":10,"rows_kept":33,"merged":[[1,4,1,6],[2,0,2,2],[3,0,3,16383]]}
[]
["SystemsX.ch Funds",null,null,"Project Titel:",{"$f":"Consolidation!F5","v":0}]
["Consumables",null,null,"SystX.ch int.ref.:",{"$f":"Consolidation!F14","v":0}]
["You may enter totals per FUNDING CATEGORY and RESEARCH GROUP, IF you submit the details as a separate Excel file. "]
[]
[null,{"$f":"I33","v":{"v":0,"d":"0.00"}}]
["Project","Institution","Research Group","Funding Category","Cost Type","Name / Description","Internal Reference","Purchase date","Total \nCHF 2017","Comments"]
[{"$f":"E2","v":0},null,null,"SystemsX.ch","Consumables"]
[{"$f":"A8","v":0},null,null,"SystemsX.ch","Consumables"]
[{"$f":"A9","v":0},null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[0,null,null,"SystemsX.ch","Consumables"]
[]
[{"$nulls":8},{"$f":"SUM(I8:I31)","v":{"v":0,"d":"0.00"}}]

{"sheet":"SystX.ch Misc","index":4,"n_rows":33,"n_cols":10,"rows_kept":33,"merged":[[1,4,1,6],[2,0,2,2],[3,0,3,16383]]}
[]
["SystemsX.ch Funds",null,null,"Project Titel:",{"$f":"Consolidation!F5","v":0}]
["Miscellaneous",null,null,"SystX.ch int.ref.:",{"$f":"Consolidation!F14","v":0}]
["You may enter totals per FUNDING CATEGORY and RESEARCH GROUP, IF you submit the details as a separate Excel file. "]
[]
[null,{"$f":"I33","v":{"v":0,"d":"0.00"}}]
["Project","Institution","Research Group","Funding Category","Cost Type","Name / Description","Internal Reference","Purchase date","Total \nCHF 2017","Comments"]
[{"$f":"E2","v":0},null,null,"SystemsX.ch","Miscellaneous"]
[{"$f":"A8","v":0},null,null,"SystemsX.ch","Miscellaneous"]
[{"$f":"A9","v":0},null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[0,null,null,"SystemsX.ch","Miscellaneous"]
[]
[{"$nulls":8},{"$f":"SUM(I8:I31)","v":{"v":0,"d":"0.00"}}]

{"sheet":"OC Pers.","index":5,"n_rows":22,"n_cols":13,"rows_kept":22,"merged":[[1,4,1,10],[2,0,2,1],[3,0,3,7]]}
[]
["Own Contribution",null,null,"Project Titel:",{"$f":"Consolidation!F5","v":0}]
["Personnel",null,null,"SystX.ch int.ref.:",{"$f":"Consolidation!F14","v":0}]
[]
[null,{"$f":"L22","v":0},null,"Note: optional (if you do not fill in the OC tables, OC will be reported to be equal to the reported expenses)"]
["Project","Institution","Research Group","Funding Category","Cost Type","Name ","Internal Reference/\nPersonnel Number","Function (must be chosen from list)","Annual % for SysX.ch ","Annual Base Salary Cost","Employed for (0.5-23) months","Total CHF 2017","Comments"]
[{"$f":"E2","v":0},null,null,"Own Contributions","Personnel",{"$nulls":3},{"$f":"IF(D7=\"\",0,IF(D7=\"Own Contributions\",\"0\",\"\"))","v":"0"},{"$f":"IF(H7=\"\",0,(VLOOKUP(H7,Tables!$A$2:$B$9,2,FALSE))*I7)","v":0},null,{"$f":"J7/12*K7","v":0}]
[{"$f":"A7","v":0},null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H8=\"\",0,(VLOOKUP(H8,Tables!$A$2:$B$9,2,FALSE))*I8)","v":0},null,{"$f":"J8/12*K8","v":0}]
[{"$f":"A8","v":0},null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H9=\"\",0,(VLOOKUP(H9,Tables!$A$2:$B$9,2,FALSE))*I9)","v":0},null,0]
[{"$f":"A9","v":0},null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H10=\"\",0,(VLOOKUP(H10,Tables!$A$2:$B$9,2,FALSE))*I10)","v":0},null,0]
[0,null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H11=\"\",0,(VLOOKUP(H11,Tables!$A$2:$B$9,2,FALSE))*I11)","v":0},null,0]
[0,null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H12=\"\",0,(VLOOKUP(H12,Tables!$A$2:$B$9,2,FALSE))*I12)","v":0},null,0]
[0,null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H13=\"\",0,(VLOOKUP(H13,Tables!$A$2:$B$9,2,FALSE))*I13)","v":0},null,0]
[0,null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H14=\"\",0,(VLOOKUP(H14,Tables!$A$2:$B$9,2,FALSE))*I14)","v":0},null,0]
[0,null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H15=\"\",0,(VLOOKUP(H15,Tables!$A$2:$B$9,2,FALSE))*I15)","v":0},null,0]
[0,null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H16=\"\",0,(VLOOKUP(H16,Tables!$A$2:$B$9,2,FALSE))*I16)","v":0},null,0]
[0,null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H17=\"\",0,(VLOOKUP(H17,Tables!$A$2:$B$9,2,FALSE))*I17)","v":0},null,0]
[0,null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H18=\"\",0,(VLOOKUP(H18,Tables!$A$2:$B$9,2,FALSE))*I18)","v":0},null,0]
[0,null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H19=\"\",0,(VLOOKUP(H19,Tables!$A$2:$B$9,2,FALSE))*I19)","v":0},null,0]
[0,null,null,"Own Contributions","Personnel",{"$nulls":3},"0",{"$f":"IF(H20=\"\",0,(VLOOKUP(H20,Tables!$A$2:$B$9,2,FALSE))*I20)","v":0},null,0]
[]
[{"$nulls":11},{"$f":"SUM(L7:L20)","v":0}]

{"sheet":" OC Equipment","index":6,"n_rows":27,"n_cols":12,"rows_kept":27,"merged":[[1,4,1,9],[2,0,2,2]]}
[]
["Own Contribution",null,null,"Project Titel:",{"$f":"Consolidation!F5","v":0}]
["Equipment",null,null,"SystX.ch int.ref.:",{"$f":"Consolidation!F14","v":0}]
[]
[null,{"$f":"K27","v":0},null,"Note: optional (if you do not fill in the OC tables, OC will be reported to be equal to the reported expenses)"]
["Project","Institution","Research Group","Funding Category","Cost Type","Description","Internal Reference","Purchase date","Cost","% made available to SystemsX.ch","Total 2017","Comments"]
[{"$f":"E2","v":0},null,null,"Own Contributions","Equipment",{"$nulls":5},{"$f":"SUM(I7*J7)","v":0}]
[{"$f":"E2","v":0},null,null,"Own Contributions","Equipment",{"$nulls":5},{"$f":"SUM(I8*J8)","v":0}]
[{"$f":"A8","v":0},null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},0]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},{"$f":"SUM(I24*J24)","v":0}]
[0,null,null,"Own Contributions","Equipment",{"$nulls":5},{"$f":"SUM(I25*J25)","v":0}]
[]
[{"$nulls":10},{"$f":"SUM(K7:K25)","v":0}]

{"sheet":"OC Cons.","index":7,"n_rows":24,"n_cols":12,"rows_kept":24,"merged":[[1,4,1,8],[2,0,2,2],[3,0,3,9]]}
[]
["Own Contribution",null,null,"Project Titel:",{"$f":"Consolidation!F5","v":0}]
["Consumables",null,null,"SystX.ch int.ref.:",{"$f":"Consolidation!F14","v":0}]
["You may enter totals per FUNDING CATEGORY per RESEARCH GROUP, IF you submit the details as a separate Excel file. "]
[null,{"$f":"K24","v":0}]
["Project","Institution","Research Group","Funding Category","Cost Type","Name / Description","Internal Reference","Purchase date","Full Cost","% for SysX.ch","Total CHF 2017","Comments"]
[{"$f":"E2","v":0},null,null,"Own Contributions","Consumables",{"$nulls":5},{"$f":"J7*I7","v":0}]
[{"$f":"A7","v":0},null,null,"Own Contributions","Consumables",{"$nulls":5},{"$f":"J8*I8","v":0}]
[{"$f":"A8","v":0},null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[0,null,null,"Own Contributions","Consumables",{"$nulls":5},0]
[]
[{"$nulls":10},{"$f":"SUM(K7:K23)","v":0}]

{"sheet":"OC Misc","index":8,"n_rows":23,"n_cols":12,"rows_kept":23,"merged":[[1,4,1,8],[2,0,2,2],[3,0,3,9]]}
[]
["Own Contribution",null,null,"Project Titel:",{"$f":"Consolidation!F5","v":0}]
["Miscellaneous",null,null,"SystX.ch int.ref.:",{"$f":"Consolidation!F14","v":0}]
["You may enter totals per FUNDING CATEGORY per RESEARCH GROUP, IF you submit the details as a separate Excel file. "]
[null,{"$f":"K23","v":0}]
["Project","Institution","Research Group","Funding Category","Cost Type","Name / Description","Internal Reference","Purchase date","Full Cost","% for SysX.ch  ","Total CHF 2017  ","Comments"]
[{"$f":"E2","v":0},null,null,"Own Contributions","Miscellaneous",{"$nulls":5},{"$f":"J7*I7","v":0}]
[{"$f":"A7","v":0},null,null,"Own Contributions","Miscellaneous",{"$nulls":5},{"$f":"J8*I8","v":0}]
[{"$f":"A8","v":0},null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[0,null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[0,null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[0,null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[0,null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[0,null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[0,null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[0,null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[0,null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[0,null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[0,null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[0,null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[0,null,null,"Own Contributions","Miscellaneous",{"$nulls":5},0]
[]
[{"$nulls":10},{"$f":"SUM(K7:K22)","v":0}]

{"sheet":"2nd Party Pers.","index":9,"n_rows":31,"n_cols":13,"rows_kept":31,"merged":[[1,4,1,7],[2,0,2,2],[3,0,3,6]]}
[]
["Second-Party Funds",null,null,"Project Titel:",{"$f":"Consolidation!F5","v":0}]
["Personnel",null,null,"SystX.ch int.ref.:",{"$f":"Consolidation!F14","v":0}]
["Please provide details for ALL personnel involved in the project paid with 2nd party funds, and not simply totals per group"]
[]
[null,{"$f":"L31","v":0}]
["Project","Institution/\nFunding Agency","Research Group","Funding Category","Cost Type","Name ","Internal Reference/ Personnel Number","Function (of the Personnel)","Base Salary / Cost 2017","% for SysX.ch  2017","Number of months employed","Total CHF 2017","Comments"]
[{"$f":"E2","v":0},null,null,"2nd Party ","Personnel",{"$nulls":6},{"$f":"I8*J8/12*K8","v":0}]
[{"$f":"A8","v":0},null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[{"$f":"A9","v":0},null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"2nd Party ","Personnel",{"$nulls":6},0]
[]
[{"$nulls":11},{"$f":"SUM(L8:L30)","v":0}]

{"sheet":"2nd Party Equip. & Cons. & Misc","index":10,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[3,0,3,2]]}
[]
["Second-Party Funds",null,"Project Titel:",{"$f":"Consolidation!F5","v":0}]
["(e.g. SNSF, CTI, EU, NIH)",null,"SystX.ch int.ref.:",{"$f":"Consolidation!F14","v":0}]
["Equipment, consumables, miscellaneous"]
[]
[null,{"$f":"H22","v":{"v":0,"d":"0.00"}}]
[]
["Please, send a copy of the contract(s) between your institution and the second-party to SystemsX.ch."]
[]
[{"$nulls":6},"to be delivered by the (co-)PI"]
["Funding Agency","Project Title","Duration (from … to ...)","Research Group (PI)","Total approved funds","Funds Used in 2017","% eligible for  SysX.ch Proj","CHF 2nd Party Funds 2017","Remark, Note"]
[{"$nulls":7},{"$f":"G12*F12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":7},{"$f":"G13*F13","v":{"v":0,"d":"0.00"}}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"$f":"G21*F21","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},"TOTAL Second-Party Funds: ",{"$f":"SUM(H12:H21)","v":{"v":0,"d":"0.00"}}]

{"sheet":"3rd Party Pers.","index":11,"n_rows":31,"n_cols":13,"rows_kept":31,"merged":[[1,4,1,7],[2,0,2,2],[3,0,3,6]]}
[]
["Third-Party Funds",null,null,"Project Titel:",{"$f":"Consolidation!F5","v":0}]
["Personnel",null,null,"SystX.ch int.ref.:",{"$f":"Consolidation!F14","v":0}]
["Please provide details for ALL personnel involved in the project paid with 3rd party funds, and not simply totals per group"]
[]
[null,{"$f":"L31","v":0}]
["Project","Institution/\nFunding Agency","Research Group","Funding Category","Cost Type","Name ","Internal Reference/ Personnel Number","Function (of the Personnel)","Base Salary / Cost 2017","% for SysX.ch  2017","Number of months employed","Total CHF 2017","Comments"]
[{"$f":"E2","v":0},null,null,"3rd Party ","Personnel",{"$nulls":6},{"$f":"I8*J8/12*K8","v":0}]
[{"$f":"A8","v":0},null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[{"$f":"A9","v":0},null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[0,null,null,"3rd Party ","Personnel",{"$nulls":6},0]
[]
[{"$nulls":11},{"$f":"SUM(L8:L30)","v":0}]

{"sheet":"3rd Party Equip. & Cons. & Misc","index":12,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[3,0,3,2]]}
[]
["Third-Party Funds",null,"Project Titel:",{"$f":"Consolidation!F5","v":0}]
["(e.g. industry, SME)",null,"SystX.ch int.ref.:",{"$f":"Consolidation!F14","v":0}]
["Equipment, consumables, miscellaneous"]
[]
[null,{"$f":"H22","v":{"v":0,"d":"0.00"}}]
[]
["Please, send a copy of the contract(s) between your institution and the thrid-party to SystemsX.ch."]
[]
[{"$nulls":6},"to be delivered by the (co-)PI"]
["Funding Agency","Project Title","Duration (from … to ...)","Research Group (PI)","Total approved funds","Funds Used in 2017","% eligible for  SysX.ch Proj","CHF 3rd Party Funds 2017","Remark, Note"]
[{"$nulls":7},{"$f":"G12*F12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":7},{"$f":"G13*F13","v":{"v":0,"d":"0.00"}}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":6},"TOTAL Third-Party Funds: ",{"$f":"SUM(H12:H21)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Tables","index":13,"n_rows":42,"n_cols":6,"rows_kept":42}
["Function:","CHF"]
["Professor",{"v":270000,"d":"270,000"}]
["Assistant Professor",{"v":200000,"d":"200,000"}]
["Senior Researcher",{"v":170000,"d":"170,000"}]
["PostDoc",{"v":130000,"d":"130,000"}]
["Technician",{"v":130000,"d":"130,000"}]
["PhD student",{"v":60000,"d":"60,000"}]
["Scientific Assistant",{"v":110000,"d":"110,000"}]
["Admin/ Misc.",{"v":90000,"d":"90,000"}]
[]
["Institute",null,"Cost Category",null,"Type","Type2"]
["EPFL",null,"SystemsX.ch",null,null,"Equipment"]
["ETHZ",null,"Own Contributions",null,"Consumables","Exist. Infrastr."]
["FMI",{"$nulls":3},"Miscellaneous"]
["IBM Research"]
["KantSpit_SG"]
["PSI"]
["SIB",{"$nulls":3},"Type3","Type4"]
["UniBE",{"$nulls":3},"OC Personnel","Consumables"]
["UniBS",{"$nulls":4},"Miscellaneous"]
["UniBS_Spit"]
["UniBS_TPH"]
["UniFR"]
["UniGE"]
["UniL"]
["UniL_CHUV"]
["UniNE"]
["USI"]
["UZH"]
["UZH_Spit"]
["ZHAW"]
[]
[]
["Function:"]
["Professor"]
["Assistant Professor"]
["Senior Researcher"]
["PostDoc"]
["Technician"]
["PhD student"]
["Scientific Assistant"]
["Admin/ Misc."]