{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Budget","Schlussabrechnung","Einstellungen"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Budget","index":0,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[[38,1,38,2],[4,1,4,6],[26,1,26,2],[14,1,14,2],[8,1,8,2],[10,1,10,2],[12,1,12,2],[18,1,18,4],[28,1,28,2],[30,1,30,2],[32,1,32,2],[34,1,34,2],[36,1,36,2],[62,6,62,10],[2,2,2,6],[2,9,2,10],[63,0,63,1],[63,6,63,10],[24,1,24,2],[54,1,54,2],[56,1,56,2],[61,1,61,2],[59,1,59,2],[21,1,21,2],[40,1,40,2],[42,1,42,2],[44,1,44,2],[49,1,49,2],[52,1,52,2]]}
["Zusammenfassung Budget"]
[]
["Projektname"]
[]
["1","Aufwand über die gesamte Projektlaufzeit"]
[]
[{"$nulls":4},"Betrag in CHF"]
[]
[1.1000000000000001,"Eigene Personalkosten"]
[]
[1.2,"Sachaufwand und Drittleistungen"]
[]
["1.3","Reserven"]
[]
[1,"Total Aufwand",null,null,{"$f":"SUM(E9:E13)","v":0}]
[]
[]
[]
[2,"Ertrag über die Gesamte Projektlaufzeit"]
[]
[{"$nulls":4},"Betrag in CHF",null,"Anteil"]
["2.1","Beitrag Tabakpräventionsfonds",{"$nulls":4},{"$f":"IF(E15>0,E22/E15,\"\")","v":""}]
[]
[]
["2.2","Andere Geldgeber",null,null,"Betrag in CHF",null,"Stand"]
[]
["2.2.1"]
[]
["2.2.2"]
[]
["2.2.3"]
[]
["2.2.4"]
[]
["2.2.5"]
[]
["2.2.6"]
[]
["2.2.7"]
[]
["2.2.8"]
[]
["2.2.9"]
[]
["2.2.10","Andere (noch nicht spezifiziert)"]
[]
[]
[{"$nulls":4},"Betrag in CHF"]
[]
["2.3","Eigenleistungen"]
[]
[]
["2.4","Weitere Erträge",null,null,"Betrag in CHF"]
[]
["2.4.1","Zinsen auf TPF-Subvention"]
[]
["2.4.2","Andere"]
[]
[]
["2","Total Ertrag",null,null,{"$f":"E22+SUM(E27:E45)+SUM(E50:E50)+SUM(E55:E57)","v":0}]
[]
[null,"Gewinn (+) oder Verlust (-)",null,null,{"$f":"E60-E15","v":0}]
[]
["Ort, Datum",null,null,null,"Unterschrift"]

{"sheet":"Schlussabrechnung","index":1,"n_rows":85,"n_cols":10,"rows_kept":85,"cut":false,"hidden":false,"merged":[[28,1,28,2],[30,1,30,2],[32,1,32,2],[15,1,15,4],[18,1,18,2],[20,1,20,2],[24,1,24,2],[26,1,26,2],[2,2,2,6],[8,1,8,2],[10,1,10,2],[12,1,12,2],[4,1,4,4],[34,1,34,2],[36,1,36,2],[38,1,38,2],[2,11,2,12],[84,0,84,1],[73,1,73,2],[75,1,75,2],[77,1,77,2],[80,1,80,2],[82,1,82,2],[61,1,61,2],[63,1,63,2],[65,1,65,2],[67,1,67,2],[69,1,69,2],[22,1,22,2],[83,6,83,10],[84,6,84,10],[40,1,40,2],[43,1,43,2],[45,1,45,2],[71,1,71,2],[49,1,49,2],[55,1,55,2],[57,1,57,2],[59,1,59,2],[51,1,51,2],[53,1,53,2],[47,1,47,2]]}
["Zusammenfassung Schlussabrechnung"]
[]
["Projektname",null,{"$f":"IF(Budget!C3<>\"\",Budget!C3,\"\")","v":""},{"$nulls":6},"Verfügungs-Nr:"]
[]
["1","Aufwand über die gesamte Projektlaufzeit"]
[]
[{"$nulls":4},"Betrag in CHF",null,"Budget",null,"Abweichung"]
[]
[1.1000000000000001,"Eigene Personalkosten",{"$nulls":4},{"$f":"Budget!E9","v":0},null,{"$f":"E9-G9","v":0}]
[]
[1.2,"Sachaufwand und Drittleistungen",{"$nulls":4},{"$f":"Budget!E11","v":0},null,{"$f":"E11-G11","v":0}]
[]
[1,"Total Aufwand",null,null,{"$f":"SUM(E9:E12)","v":0},null,null,null,{"$f":"SUM(I9:I12)","v":0}]
[]
[]
[2,"Ertrag über die Gesamte Projektlaufzeit"]
[]
[]
["2.1","Zahlungen Tabakpräventionsfonds",null,null,"Betrag in CHF"]
[]
["2.1.1","Erste Zahlung"]
[]
["2.1.2","Zweite Zahlung"]
[]
["2.1.3","Dritte Zahlung"]
[]
["2.1.4","Vierte Zahlung"]
[]
["2.1.5","Fünfte Zahlung"]
[]
["2.1.6","Sechste Zahlung"]
[]
["2.1.7","Siebte Zahlung"]
[]
["2.1.8","Achte Zahlung"]
[]
["2.1.9","Neunte Zahlung"]
[]
["2.1.10","Zehnte Zahlung"]
[]
["2.1.11","Geforderte Schlusszahlung"]
[{"$nulls":6},"Budget",null,"Abweichung"]
[]
["2.1","Total TPF",null,null,{"$f":"SUM(E21:E41)","v":0},null,{"$f":"Budget!E22","v":0},null,{"$f":"E44-G44","v":0}]
[]
[null,"Anteil TPF",null,null,{"$f":"IF(E13>0,E44/E13,\"\")","v":""}]
[]
["2.2","Andere Geldgeber",null,null,"Betrag in CHF",null,"Budget",null,"Abweichung"]
[]
["2.2.1",{"$nulls":5},{"$f":"IF(Budget!E27<>\"\",Budget!E27,\"\")","v":""},null,{"$f":"IF(E50=\"\",IF(G50=\"\",\"\",0-G50),IF(G50=\"\",E50-0,E50-G50))","v":""}]
[]
["2.2.2",{"$nulls":5},{"$f":"IF(Budget!E29<>\"\",Budget!E29,\"\")","v":""},null,{"$f":"IF(E52=\"\",IF(G52=\"\",\"\",0-G52),IF(G52=\"\",E52-0,E52-G52))","v":""}]
[]
["2.2.3",{"$nulls":5},{"$f":"IF(Budget!E31<>\"\",Budget!E31,\"\")","v":""},null,{"$f":"IF(E54=\"\",IF(G54=\"\",\"\",0-G54),IF(G54=\"\",E54-0,E54-G54))","v":""}]
[]
["2.2.4",{"$nulls":5},{"$f":"IF(Budget!E33<>\"\",Budget!E33,\"\")","v":""},null,{"$f":"IF(E56=\"\",IF(G56=\"\",\"\",0-G56),IF(G56=\"\",E56-0,E56-G56))","v":""}]
[]
["2.2.5",{"$nulls":5},{"$f":"IF(Budget!E35<>\"\",Budget!E35,\"\")","v":""},null,{"$f":"IF(E58=\"\",IF(G58=\"\",\"\",0-G58),IF(G58=\"\",E58-0,E58-G58))","v":""}]
[]
["2.2.6",{"$nulls":5},{"$f":"IF(Budget!E37<>\"\",Budget!E37,\"\")","v":""},null,{"$f":"IF(E60=\"\",IF(G60=\"\",\"\",0-G60),IF(G60=\"\",E60-0,E60-G60))","v":""}]
[]
["2.2.7",{"$nulls":5},{"$f":"IF(Budget!E39<>\"\",Budget!E39,\"\")","v":""},null,{"$f":"IF(E62=\"\",IF(G62=\"\",\"\",0-G62),IF(G62=\"\",E62-0,E62-G62))","v":""}]
[]
["2.2.8",{"$nulls":5},{"$f":"IF(Budget!E41<>\"\",Budget!E41,\"\")","v":""},null,{"$f":"IF(E64=\"\",IF(G64=\"\",\"\",0-G64),IF(G64=\"\",E64-0,E64-G64))","v":""}]
[]
["2.2.9",{"$nulls":5},{"$f":"IF(Budget!E43<>\"\",Budget!E43,\"\")","v":""},null,{"$f":"IF(E66=\"\",IF(G66=\"\",\"\",0-G66),IF(G66=\"\",E66-0,E66-G66))","v":""}]
[]
["2.2.10","Weitere Geldgeber",{"$nulls":4},{"$f":"IF(Budget!E45<>\"\",Budget!E45,\"\")","v":""},null,{"$f":"IF(E68=\"\",IF(G68=\"\",\"\",0-G68),IF(G68=\"\",E68-0,E68-G68))","v":""}]
[]
["2.3",null,null,null,"Betrag in CHF",null,"Budget",null,"Abweichung"]
[]
["2.3","Eigenleistungen",{"$nulls":4},{"$f":"IF(Budget!E50<>\"\",Budget!E50,\"\")","v":""},null,{"$f":"IF(E72=\"\",IF(G72=\"\",\"\",0-G72),IF(G72=\"\",E72-0,E72-G72))","v":""}]
[]
["2.4","Weitere Erträge",null,null,"Betrag in CHF",null,"Budget",null,"Abweichung"]
[]
["2.4.1","Zinsen auf TPF-Subvention",{"$nulls":4},{"$f":"IF(Budget!E55<>\"\",Budget!E55,\"\")","v":""},null,{"$f":"IF(E76=\"\",IF(G76=\"\",\"\",0-G76),IF(G76=\"\",E76-0,E76-G76))","v":""}]
[]
["2.4.2","Andere",{"$nulls":4},{"$f":"IF(Budget!E57<>\"\",Budget!E57,\"\")","v":""},null,{"$f":"IF(E78=\"\",IF(G78=\"\",\"\",0-G78),IF(G78=\"\",E78-0,E78-G78))","v":""}]
[]
[]
["2","Total Ertrag",null,null,{"$f":"E44+SUM(E50:E69)+SUM(E72:E72)+SUM(E76:E78)","v":0}]
[]
[null,"Gewinn (+) oder Verlust (-)",null,null,{"$f":"E81-E13","v":0}]
[]
["Ort, Datum",null,null,null,"Unterschrift"]

{"sheet":"Einstellungen","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["zugesichert"]
["angefragt"]
["geplant"]