{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Projektkalkulation"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Projektkalkulation","index":0,"n_rows":67,"n_cols":10,"rows_kept":67,"merged":[[39,1,39,9]]}
[]
[]
[]
[]
[]
[null,"Projekttitel","FIELD_PROJEKTTITEL"]
[null,"Projektnummer","FIELD_PROJEKTNUMMER"]
[null,"Projektlaufzeit","FIELD_PROJEKTSTART"]
[]
["FBE","Förderbudget für externe Projektpartner"]
[]
["PB","Personalbudget","Anmerkungen",2019,2020,2021,2022,"Gesamtsumme in EUR","davon Stiftung Mercator","davon Eigen- \nund Drittmittel"]
["PB01","Personalkosten Geschäftsführung (AG-Brutto)",{"$nulls":5},{"$f":"SUM(D13:G13)","v":{"v":0,"d":"0.00 €"}}]
["PB02","Personalkosten Projektleitung (AG-Brutto)",{"$nulls":5},{"$f":"SUM(D14:G14)","v":{"v":0,"d":"0.00 €"}}]
["PB03","Personalkosten Projektmitarbeiter (AG-Brutto)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["PB04","Personalkosten Kommunikationsmitarbeiter (AG-Brutto)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["PB05","Personalkosten Sekretariat (AG-Brutto)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["PB06","Personalkosten kaufmännische Mitarbeiter (AG-Brutto)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["PB07","Personalkosten Hilfskräfte (AG-Brutto)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["PBS","Zwischensumme Personalbudget",null,{"$f":"SUM(D13:D19)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(E13:E19)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F13:F19)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G13:G19)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
["SB","Sachbudget","Anmerkungen",2019,2020,2021,2022,"Gesamtsumme in EUR","davon Stiftung Mercator","davon Eigen-\n und Drittmittel"]
["SB01","Dienst- & Werkverträge (Schulungen/Beratungen)",{"$nulls":5},{"$f":"SUM(D23:G23)","v":{"v":0,"d":"0.00 €"}}]
["SB02","Honorare",{"$nulls":5},{"$f":"SUM(D24:G24)","v":{"v":0,"d":"0.00 €"}}]
["SB03","Mieten inkl. Nebenkosten",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB04","Reisekosten/Unterkunft/Transfer",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB05","Veranstaltungen",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB06","Bürobedarf/Telefon/Porto",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB07","Publikationen",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB08","Öffentlichkeitsarbeit (Anzeigen, Design, Fotos, PK, etc.)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB09","IT-Ausstattung (Computer, Drucker, Laptops, etc.)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB10","Büroausstattung (Schreibtische, Stühle, Lampen, etc.)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB11","Entwicklung Website & Corporate Design",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB12","Sonstige Sachkosten",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB13","Sonstige Sachkosten",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB14","Sonstige Sachkosten",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SBS","Zwischensumme Sachbudget",null,{"$f":"SUM(D23:D36)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
["IK","Infrastrukturkosten-Pauschale"]
[null,"Die Infrastrukturkosten-Pauschale ist ein Zuschlag bei der Zusammenarbeit mit Projektpartnern zur Deckung der mit der Fördervereinbarung verbundenen Infrastrukturkosten. Die Infrastrukturkosten-Pauschale\nbeträgt maximal 20% der Fördersumme (Personalbudget + Sachbudget)."]
["IK01","Infrastrukturkosten ",{"$nulls":5},{"$f":"SUM(D41:G41)","v":{"v":0,"d":"0.00 €"}},{"$f":"H41","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"}]
["IKS"]
[]
["FBES","Zwischensumme Förderbudget für externe Projektpartner:",null,{"$f":"D20+D37+D41","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
["OBM","Operatives Budget der Stiftung Mercator"]
[]
["OBM01","operatives Budget für Öffentlichkeitsarbeit (MD)",{"$nulls":5},{"$f":"SUM(D48:G48)","v":{"v":0,"d":"0.00 €"}}]
["OBM02","operatives Budget für Honorare, Recht- & Beratung (MD)",{"$nulls":5},{"$f":"SUM(D49:G49)","v":{"v":0,"d":"0.00 €"}}]
["OBM03","operatives Budget für Dienstleistungen (MD)",{"$nulls":5},{"$f":"SUM(D50:G50)","v":{"v":0,"d":"0.00 €"}}]
["OBM04","operatives Budget für Reisen intern (MD)",{"$nulls":5},{"$f":"SUM(D51:G51)","v":{"v":0,"d":"0.00 €"}}]
["OBM05","operatives Budget für Reisen extern (MD)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["OBM06","operatives Budget für Sachmittel & Sonstiges (MD)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["OBM07","operatives Budget für Bewirtungen (MD)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["OBM08","operatives Budget für Evaluation (MD)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
[]
["OBMS","Zwischensumme operatives Budget (MD)",null,{"$f":"SUM(D48:D55)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
["GS","Gesamtsumme direkt Projektbudget (Gesamtförderbudget + operatives Budget MD)",null,{"$f":"D44+D57","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
["DM","Anteil Kofinanzierer (Eigen- und Drittmittel)",null,{"$f":"J59","v":0},"Anteil in %"]
["DM01","\"Freitextfeld\"",null,null,{"$f":"IF(D62=0,0,100/(D61/D62)/100)","v":{"v":0,"d":"0%"}}]
["DM02","\"Freitextfeld\"",null,null,{"$f":"IF(D63=0,0,100/(D61/D63)/100)","v":{"v":0,"d":"0%"}}]
["DM03","\"Freitextfeld\"",null,null,{"$f":"IF(D64=0,0,100/(D61/D64)/100)","v":{"v":0,"d":"0%"}}]
["DM04","\"Freitextfeld\"",null,null,{"$f":"IF(D65=0,0,100/(D61/D65)/100)","v":{"v":0,"d":"0%"}}]
["DM05","\"Freitextfeld\"",null,null,{"$f":"IF(D66=0,0,100/(D61/D66)/100)","v":{"v":0,"d":"0%"}}]
["DMS"]