{"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,"Project title","FIELD_PROJEKTTITEL"]
[null,"Project number","FIELD_PROJEKTNUMMER"]
[null,"Funding period","FIELD_PROJEKTSTART"]
[]
["FBE","Budget Project Partner"]
[]
["PB","Personnel costs","Comment",2019,2020,2021,2022,"Total cost\n in EUR","Costs covered by Stiftung Mercator","Costs covered by third party funders/own funds"]
["PB01","Personnel costs business management (gross employer cost)",{"$nulls":5},{"$f":"SUM(D13:G13)","v":{"v":0,"d":"0.00 €"}}]
["PB02","Personnel costs project management (gross employer cost)",{"$nulls":5},{"$f":"SUM(D14:G14)","v":{"v":0,"d":"0.00 €"}}]
["PB03","Personnel costs project staff (gross employer cost)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["PB04","Personnel costs communication staff (gross employer cost)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["PB05","Personnel costs secretariat (gross employer cost)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["PB06","Personnel costs commercial staff (gross employer cost)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["PB07","Personnel costs assitants (gross employer cost)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["PBS","Subtotal personnel costs",null,{"$f":"SUM(D13:D19)","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 €"}]
[]
["SB","Material costs","Anmerkungen",2019,2020,2021,2022,"Total cost\n in EUR","Costs covered by Stiftung Mercator","Costs covered by third party funders/own funds"]
["SB01","Contracts for services",{"$nulls":5},{"$f":"SUM(D23:G23)","v":{"v":0,"d":"0.00 €"}}]
["SB02","Fees",{"$nulls":5},{"$f":"SUM(D24:G24)","v":{"v":0,"d":"0.00 €"}}]
["SB03","Rents incl. additonal costs",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB04","Travel costs/accomodation",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB05","Events",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB06","Office supplies/telephone/postage",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB07","Publications",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB08","Public relations (adverts, design, photographs, press conference, etc.)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB09","IT-Equipment (computer, printer, notebooks, etc.)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB10","Office equipment (desks, chairs, lamps, etc.)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB11","Development Website & Corporate Design",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB12","Other material costs",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB13","Other material costs",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SB14","Other material costs",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["SBS","Subtotal material costs",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","Infrastructure costs-flat charge"]
[null,"The infrastructure fee is a supplement to cooperation with project partners to cover the infrastructure costs associated with the grant agreement. The infrastructure costs flat rate\namounts to a maximum of 20% of the funding amount (personal budget + property budget)."]
["IK01","Infrastructure costs",{"$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","Subtotal budget project partners",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","Operative budget from Stiftung Mercator"]
[]
["OBM01","operative budget for public relations (MD)",{"$nulls":5},{"$f":"SUM(D48:G48)","v":{"v":0,"d":"0.00 €"}}]
["OBM02","operative budget for fees, law and advices  (MD)",{"$nulls":5},{"$f":"SUM(D49:G49)","v":{"v":0,"d":"0.00 €"}}]
["OBM03","operative budget for services  (MD)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["OBM04","operative budget for travel cost - intern (MD)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["OBM05","operative budget for travel costs - extern (MD)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["OBM06","operative budget for material expenses (MD)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["OBM07","operative budget for hospitality (MD)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
["OBM08","operative budget for evaluation (MD)",{"$nulls":5},{"v":0,"d":"0.00 €"}]
[]
["OBMS","Subtotal operative 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","Total 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","Co-Funding (own funds, third-party funds)",null,{"$f":"J59","v":0},"percentage (%)"]
["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"]