Spreadsheet: 696766d1600962843-nested-if-function-morte1974-example
Sheet: R+D projects

Name project/ idea | Synonym | Status | Budget brutto | Budget netto totaal | Duration from | Duration to | Responsible Chanfood | Remarks | 1 Betalingstermijn | 1 Bedrag | 2 Betalingstermijn | 2 Bedrag | 3 Betalingstermijn | 3 Bedrag | 4 Betalingstermijn | 4 Bedrag | 5 Betalingstermijn | 5 Bedrag
 | SAFEGUARD | [NAME] |  | 226860 | 2009-02-01 00:00:00 | 2012-12-31 00:00:00 | JZI Johan | JZ Investments is partner, Aannames betalingen op basis inschatting aug 2011 | 2010-07-23 00:00:00 | 9384 | 2011-10-01 00:00:00 | 45414 | 2012-03-01 00:00:00 | 47146 | 2012-07-01 00:00:00 | 43243 | 2013-08-01 00:00:00 | 81673
 | [NAME] | [NAME] |  | 130048 | 2007-01-01 00:00:00 | 2011-12-31 00:00:00 | [NAME] |  |  | 121058 | 2012-08-30 00:00:00
 | SOPHY | Begin jan 2012 verwacht |  | 406960 | 2012-02-01 00:00:00 | 2014-12-31 00:00:00 | [NAME] | Aannames op basis gesprek Caroline Hennigs aug 2011 | 2012-02-15 00:00:00 |  | 2012-09-15 00:00:00 |  | 2013-03-30 00:00:00 |  | 2014-01-10 00:00:00 | 91567 | 2015-07-30 00:00:00 | 91566
 | Chill-On | Afgesloten 31-12-2010 |  | 424221 | 2006-07-01 00:00:00 | 2011-12-31 00:00:00 | [NAME] | Laatste payment eind 2011 te verwachten (zie mail Maria, 28.06.2011) |  | 401484 | 2011-12-31 00:00:00
 | Foodfuture FSP | [NAME] | 230000 | 115000 | 2012-03-01 00:00:00 | 2013-12-31 00:00:00 | [NAME] | Chainfood Nederland | 2012-12-31 00:00:00 | 27000 | 2013-05-30 00:00:00 | 53000 | 2014-01-31 00:00:00 | 35000
 | SafeGuard | SafeGuard | 24000 | 14400 | 2013-01-01 00:00:00 | 2013-10-31 00:00:00 | [NAME] | Via JZI Uitbreiding samen met EGR
 | [NAME] | Food Future | 204000 | 102000 | 2013-06-01 00:00:00 | 2014-06-30 00:00:00 | [NAME] |  | 2014-03-01 00:00:00 | ? | 2014-09-01 00:00:00 | ?
Projectideen actueel
SmartAgriFood | SmartAgriFood | Toeslag voor vervolgfase in 2014 |  | 150000 |  |  | [NAME] | App-project mogelijk
Eurostars | EHEC monitoring | Projectidee Bio-Security en Pronacon
Flexscreen | BLE call Antibiotikaresistenzen | ingediend | 643000 | 450100 | 2015-07-01 00:00:00 | 2017-12-31 00:00:00 | [NAME]
Development of new sensor technologies | BMBF idee
Food Wastage | horizon 2020 | Versie 1 ingediend | 500000 | 800000 |  |  | [NAME]
Development of new sensor technologies | Interreg V | Voorstel wordt uitgewerkt | 350000 |  |  |  | [NAME] | [NAME] heeft de lead
Projectideen niet concreet/ vervallen
 | ? | ttz
Interreg V | ? | GIQS |  |  |  |  |  | met oliver [NAME] opvolgen
Optimierung des Risikomanagements durch [NAME] an KMUs der [NAME] | [NAME] QHP | Projectidee |  | 60000 |  |  | [NAME] | [NAME]
BMBF Obst und Gemüse | Globe | Geen toeslag, alternatief wordt uitgewerkt | 454000 | 227000 | 2013-01-01 00:00:00 | 2017-12-31 00:00:00 | [NAME]
BMBF Obst und Gemüse | Globe | Geen toeslag, alternatief wordt uitgewerkt | 115200 | 115200 | 2013-01-01 00:00:00 | 2017-12-31 00:00:00 | [NAME]
Antibiotika FP 7 |  | Geen toeslag, projectidee wordt door GIQS verder vervolgd | 331200 | 248400
BLE | Bacteria4Force | Geen toeslag | 427000 | 298900 | 2013-07-01 00:00:00 | 2015-06-30 00:00:00 | [NAME]
SiFAV | residumonitoring | Geen toeslag | 480000 | 194000 |  | 2014-06-10 00:00:00 | [NAME]