{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Menu","Hinweise zum Ausfüllen","Gesamtprojektkosten","Partner 1","Partner 2","Partner 3","Partner 4","Partner 5","Partner 6"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Menu","index":0,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[null,"Menu"]
[]
["Umsatzsteuer","Umsatzsteuersatz","EBI oder TZW"]
["Ja",0.19,"Ja"]
["Nein",7.0000000000000007E-2,"Nein"]

{"sheet":"Hinweise zum Ausfüllen","index":1,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Hinweise zum Ausfüllen"]

{"sheet":"Gesamtprojektkosten","index":2,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Gesamtprojektkosten"]
["Partnernummer",1,2,3,4,5,6]
["Partnername",{"$f":"'Partner 1'!$B1","v":"Partner 1"},{"$f":"'Partner 2'!$B1","v":"Partner 2"},{"$f":"'Partner 3'!$B1","v":"Partner 3"},{"$f":"'Partner 4'!$B1","v":"Partner 4"},{"$f":"'Partner 5'!$B1","v":"Partner 5"},{"$f":"'Partner 6'!$B1","v":"Partner 6"}]
[null,null,null,null,null,null,null,"Gesamtprojekt"]
["Personalkosten",{"$f":"'Partner 1'!$L$6","v":0},{"$f":"'Partner 2'!$L$6","v":0},{"$f":"'Partner 3'!$L$6","v":0},{"$f":"'Partner 4'!$L$6","v":0},{"$f":"'Partner 5'!$L$6","v":0},{"$f":"'Partner 6'!$L$6","v":0},{"$f":"SUM(B5:G5)","v":0}]
["Sachkosten",{"$f":"'Partner 1'!$L$7","v":0},{"$f":"'Partner 2'!$L$7","v":0},{"$f":"'Partner 3'!$L$7","v":0},{"$f":"'Partner 4'!$L$7","v":0},{"$f":"'Partner 5'!$L$7","v":0},{"$f":"'Partner 6'!$L$7","v":0},0]
["Reisekosten",{"$f":"'Partner 1'!$L$8","v":0},{"$f":"'Partner 2'!$L$8","v":0},{"$f":"'Partner 3'!$L$8","v":0},{"$f":"'Partner 4'!$L$8","v":0},{"$f":"'Partner 5'!$L$8","v":0},{"$f":"'Partner 6'!$L$8","v":0},0]
["Fremdleistungen",{"$f":"'Partner 1'!$L$9","v":0},{"$f":"'Partner 2'!$L$9","v":0},{"$f":"'Partner 3'!$L$9","v":0},{"$f":"'Partner 4'!$L$9","v":0},{"$f":"'Partner 5'!$L$9","v":0},{"$f":"'Partner 6'!$L$9","v":0},0]
["Sonstige Kosten",{"$f":"'Partner 1'!$L$10","v":0},{"$f":"'Partner 2'!$L$10","v":0},{"$f":"'Partner 3'!$L$10","v":0},{"$f":"'Partner 4'!$L$10","v":0},{"$f":"'Partner 5'!$L$10","v":0},{"$f":"'Partner 6'!$L$10","v":0},0]
["Summe",{"$f":"'Partner 1'!$L$11","v":0},{"$f":"'Partner 2'!$L$11","v":0},{"$f":"'Partner 3'!$L$11","v":0},{"$f":"'Partner 4'!$L$11","v":0},{"$f":"'Partner 5'!$L$11","v":0},{"$f":"'Partner 6'!$L$11","v":0},0]
["Allgemeinkostenzuschlag Personal",{"$f":"'Partner 1'!$L$12","v":0},{"$f":"'Partner 2'!$L$12","v":0},{"$f":"'Partner 3'!$L$12","v":0},{"$f":"'Partner 4'!$L$12","v":0},{"$f":"'Partner 5'!$L$12","v":0},{"$f":"'Partner 6'!$L$12","v":0},0]
["Gesamtkosten brutto",{"$f":"'Partner 1'!$L$15","v":0},{"$f":"'Partner 2'!$L$15","v":0},{"$f":"'Partner 3'!$L$15","v":0},{"$f":"'Partner 4'!$L$15","v":0},{"$f":"'Partner 5'!$L$15","v":0},{"$f":"'Partner 6'!$L$15","v":0},0]
["Eigenanteil",{"$f":"'Partner 1'!$L$16","v":0},{"$f":"'Partner 2'!$L$16","v":0},{"$f":"'Partner 3'!$L$16","v":0},{"$f":"'Partner 4'!$L$16","v":0},{"$f":"'Partner 5'!$L$16","v":0},{"$f":"'Partner 6'!$L$16","v":0},0]
["DVGW-Förderung",{"$f":"'Partner 1'!$L$17","v":0},{"$f":"'Partner 2'!$L$17","v":0},{"$f":"'Partner 3'!$L$17","v":0},{"$f":"'Partner 4'!$L$17","v":0},{"$f":"'Partner 5'!$L$17","v":0},{"$f":"'Partner 6'!$L$17","v":0},0]
[]
["Zuschuss Dritter",{"$f":"'Partner 1'!B19+'Partner 2'!B19+'Partner 3'!B19+'Partner 4'!B19+'Partner 5'!B19+'Partner 6'!B19","v":0}]
["Eigenanteile aller Beteiligter",{"$f":"'Partner 1'!B20+'Partner 2'!B20+'Partner 3'!B20+'Partner 4'!B20+'Partner 5'!B20+'Partner 6'!B20","v":0}]

{"sheet":"Partner 1","index":3,"n_rows":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":false,"merged":[[0,2,0,3],[1,2,1,3],[2,2,2,3],[74,1,74,3],[24,0,24,13],[26,1,26,3],[41,1,41,3],[58,1,58,3],[65,1,65,3]]}
["Projektpartner","Partner 1","Umsatzsteuerpflichtig*",null,null,"*verpflichtend, bitte auswählen"]
[null,null,"Umsatzsteuersatz*"]
[null,null,"EBI oder TZW?*"]
[]
["Kostenart","AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10","Total"]
["Personalkosten",{"$f":"B39","v":0},{"$f":"C39","v":0},0,0,0,0,0,0,{"$f":"J39","v":0},{"$f":"K39","v":0},{"$f":"SUM(Tabelle1410[[#This Row],[AP1]:[AP10]])","v":0}]
["Sachkosten",{"$f":"B57","v":0},{"$f":"C57","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle1410[[#This Row],[AP1]:[AP10]])","v":0}]
["Reisekosten",{"$f":"B64","v":0},{"$f":"C64","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle1410[[#This Row],[AP1]:[AP10]])","v":0}]
["Fremdleistungen",{"$f":"B73","v":0},{"$f":"C73","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle1410[[#This Row],[AP1]:[AP10]])","v":0}]
["Sonstige Kosten",{"$f":"B82","v":0},{"$f":"C82","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle1410[[#This Row],[AP1]:[AP10]])","v":0}]
["Summe",{"$f":"SUM(B6:B10)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K6:K10)","v":0},{"$f":"SUM(Tabelle1410[[#This Row],[AP1]:[AP10]])","v":0}]
["Allgemeinkostenzuschlag Personal",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E1=\"Ja\",0,L6*B21)","v":0}]
["Gesamtkosten netto",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L6:L10,L12)","v":0}]
["Umsatzsteuer",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$3=\"Ja\",0, IF($E$1=\"Ja\",$L$13*$E$2,0))","v":0}]
["Gesamtkosten brutto",null,null,null,null,null,null,null,null,null,null,{"$f":"L13+L14","v":0}]
["Eigenanteil",null,null,null,null,null,null,null,null,null,null,{"$f":"B20","v":0}]
["DVGW-Förderung",null,null,null,null,null,null,null,null,null,null,{"$f":"L15-B19-L16","v":0}]
[]
["Zuschüsse Dritter (in €)"]
["Eigenanteil (in €)"]
["Allgemeinkostenzuschlag Personal (in %)"]
[]
[]
[]
["Berechnungen für die Kostenaufstellung "]
[]
["Personalkosten","Arbeitsaufwand in Personenmonate"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10","Stundensatz","Wochenstunden","Monatssatz"]
["Mitarbeiter 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L29*M29*4","v":0}]
["Mitarbeiter 2",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 3",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 4",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 5",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 6",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 7",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 8",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 9",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 10",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B29*$N$29+B30*$N$30+B31*$N$31+B32*$N$32+B33*$N$33+B34*$N$34+B35*$N$35+B36*$N$36+B37*$N$37+B38*$N$38","v":0},{"$f":"C29*$N$29+C30*$N$30+C31*$N$31+C32*$N$32+C33*$N$33+C34*$N$34+C35*$N$35+C36*$N$36+C37*$N$37+C38*$N$38","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(B39:K39)","v":0}]
[]
[]
["Sachkosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Material 1"]
["Material 2"]
["Material 3"]
["Material 4"]
["Material 5"]
["Material 6"]
["Material 7"]
["Material 8"]
["Material 9"]
["Material 10"]
["Material 11"]
["Material 12"]
["Material 13"]
[null,{"$f":"SUM(B44:B56)","v":0},{"$f":"SUM(C44:C56)","v":0},0,0,0,0,0,0,0,0]
[]
["Reisekosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Reise 1"]
["Reise 2"]
["Reise 3"]
[null,{"$f":"SUM(B61:B63)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Fremdleistungen"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Leistung 1"]
["Leistung 2"]
["Leistung 3"]
["Leistung 4"]
["Leistung 5"]
[null,{"$f":"SUM(B68:B72)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Sonstige Kosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Sonstige 1"]
["Sonstige 2"]
["Sonstige 3"]
["Sonstige 4"]
["Sonstige 5"]
[null,{"$f":"SUM(B77:B81)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Partner 2","index":4,"n_rows":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":false,"merged":[[58,1,58,3],[65,1,65,3],[74,1,74,3],[0,2,0,3],[1,2,1,3],[2,2,2,3],[24,0,24,13],[26,1,26,3],[41,1,41,3]]}
["Projektpartner","Partner 2","Umsatzsteuerpflichtig*",null,null,"*verpflichtend, bitte auswählen"]
[null,null,"Umsatzsteuersatz*"]
[null,null,"EBI oder TZW?*"]
[]
["Kostenart","AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10","Total"]
["Personalkosten",{"$f":"B39","v":0},0,0,0,0,0,0,0,{"$f":"J39","v":0},{"$f":"K39","v":0},{"$f":"SUM(Tabelle14108[[#This Row],[AP1]:[AP10]])","v":0}]
["Sachkosten",{"$f":"B57","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle14108[[#This Row],[AP1]:[AP10]])","v":0}]
["Reisekosten",{"$f":"B64","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle14108[[#This Row],[AP1]:[AP10]])","v":0}]
["Fremdleistungen",{"$f":"B73","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle14108[[#This Row],[AP1]:[AP10]])","v":0}]
["Sonstige Kosten",{"$f":"B82","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle14108[[#This Row],[AP1]:[AP10]])","v":0}]
["Summe",{"$f":"SUM(B6:B10)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K6:K10)","v":0},{"$f":"SUM(Tabelle14108[[#This Row],[AP1]:[AP10]])","v":0}]
["Allgemeinkostenzuschlag Personal",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E1=\"Ja\",0,L6*B21)","v":0}]
["Gesamtkosten netto",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L6:L10,L12)","v":0}]
["Umsatzsteuer",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$3=\"Ja\",0, IF($E$1=\"Ja\",$L$13*$E$2,0))","v":0}]
["Gesamtkosten brutto",null,null,null,null,null,null,null,null,null,null,{"$f":"L13+L14","v":0}]
["Eigenanteil",null,null,null,null,null,null,null,null,null,null,{"$f":"B20","v":0}]
["DVGW-Förderung",null,null,null,null,null,null,null,null,null,null,{"$f":"L15-B19-L16","v":0}]
[]
["Zuschüsse Dritter (in €)"]
["Eigenanteil (in €)"]
["Allgemeinkostenzuschlag Personal (in %)"]
[]
[]
[]
["Berechnungen für die Kostenaufstellung "]
[]
["Personalkosten","Arbeitsaufwand in Personenmonate"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10","Stundensatz","Wochenstunden","Monatssatz"]
["Mitarbeiter 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L29*M29*4","v":0}]
["Mitarbeiter 2",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 3",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 4",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 5",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 6",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 7",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 8",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 9",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 10",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B29*$N$29+B30*$N$30+B31*$N$31+B32*$N$32+B33*$N$33+B34*$N$34+B35*$N$35+B36*$N$36+B37*$N$37+B38*$N$38","v":0},{"$f":"C29*$N$29+C30*$N$30+C31*$N$31+C32*$N$32+C33*$N$33+C34*$N$34+C35*$N$35+C36*$N$36+C37*$N$37+C38*$N$38","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(B39:K39)","v":0}]
[]
[]
["Sachkosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Material 1"]
["Material 2"]
["Material 3"]
["Material 4"]
["Material 5"]
["Material 6"]
["Material 7"]
["Material 8"]
["Material 9"]
["Material 10"]
["Material 11"]
["Material 12"]
["Material 13"]
[null,{"$f":"SUM(B44:B56)","v":0},{"$f":"SUM(C44:C56)","v":0},0,0,0,0,0,0,0,0]
[]
["Reisekosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Reise 1"]
["Reise 2"]
["Reise 3"]
[null,{"$f":"SUM(B61:B63)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Fremdleistungen"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Leistung 1"]
["Leistung 2"]
["Leistung 3"]
["Leistung 4"]
["Leistung 5"]
[null,{"$f":"SUM(B68:B72)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Sonstige Kosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Sonstige 1"]
["Sonstige 2"]
["Sonstige 3"]
["Sonstige 4"]
["Sonstige 5"]
[null,{"$f":"SUM(B77:B81)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Partner 3","index":5,"n_rows":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":false,"merged":[[58,1,58,3],[65,1,65,3],[74,1,74,3],[0,2,0,3],[1,2,1,3],[2,2,2,3],[24,0,24,13],[26,1,26,3],[41,1,41,3]]}
["Projektpartner","Partner 3","Umsatzsteuerpflichtig*",null,null,"*verpflichtend, bitte auswählen"]
[null,null,"Umsatzsteuersatz*"]
[null,null,"EBI oder TZW?*"]
[]
["Kostenart","AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10","Total"]
["Personalkosten",{"$f":"B39","v":0},0,0,0,0,0,0,0,{"$f":"J39","v":0},{"$f":"K39","v":0},{"$f":"SUM(Tabelle141089[[#This Row],[AP1]:[AP10]])","v":0}]
["Sachkosten",{"$f":"B57","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle141089[[#This Row],[AP1]:[AP10]])","v":0}]
["Reisekosten",{"$f":"B64","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle141089[[#This Row],[AP1]:[AP10]])","v":0}]
["Fremdleistungen",{"$f":"B73","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle141089[[#This Row],[AP1]:[AP10]])","v":0}]
["Sonstige Kosten",{"$f":"B82","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle141089[[#This Row],[AP1]:[AP10]])","v":0}]
["Summe",{"$f":"SUM(B6:B10)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K6:K10)","v":0},{"$f":"SUM(Tabelle141089[[#This Row],[AP1]:[AP10]])","v":0}]
["Allgemeinkostenzuschlag Personal",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E1=\"Ja\",0,L6*B21)","v":0}]
["Gesamtkosten netto",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L6:L10,L12)","v":0}]
["Umsatzsteuer",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$3=\"Ja\",0, IF($E$1=\"Ja\",$L$13*$E$2,0))","v":0}]
["Gesamtkosten brutto",null,null,null,null,null,null,null,null,null,null,{"$f":"L13+L14","v":0}]
["Eigenanteil",null,null,null,null,null,null,null,null,null,null,{"$f":"B20","v":0}]
["DVGW-Förderung",null,null,null,null,null,null,null,null,null,null,{"$f":"L15-B19-L16","v":0}]
[]
["Zuschüsse Dritter (in €)"]
["Eigenanteil (in €)"]
["Allgemeinkostenzuschlag Personal (in %)"]
[]
[]
[]
["Berechnungen für die Kostenaufstellung "]
[]
["Personalkosten","Arbeitsaufwand in Personenmonate"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10","Stundensatz","Wochenstunden","Monatssatz"]
["Mitarbeiter 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L29*M29*4","v":0}]
["Mitarbeiter 2",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 3",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 4",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 5",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 6",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 7",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 8",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 9",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 10",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B29*$N$29+B30*$N$30+B31*$N$31+B32*$N$32+B33*$N$33+B34*$N$34+B35*$N$35+B36*$N$36+B37*$N$37+B38*$N$38","v":0},{"$f":"C29*$N$29+C30*$N$30+C31*$N$31+C32*$N$32+C33*$N$33+C34*$N$34+C35*$N$35+C36*$N$36+C37*$N$37+C38*$N$38","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(B39:K39)","v":0}]
[]
[]
["Sachkosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Material 1"]
["Material 2"]
["Material 3"]
["Material 4"]
["Material 5"]
["Material 6"]
["Material 7"]
["Material 8"]
["Material 9"]
["Material 10"]
["Material 11"]
["Material 12"]
["Material 13"]
[null,{"$f":"SUM(B44:B56)","v":0},{"$f":"SUM(C44:C56)","v":0},0,0,0,0,0,0,0,0]
[]
["Reisekosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Reise 1"]
["Reise 2"]
["Reise 3"]
[null,{"$f":"SUM(B61:B63)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Fremdleistungen"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Leistung 1"]
["Leistung 2"]
["Leistung 3"]
["Leistung 4"]
["Leistung 5"]
[null,{"$f":"SUM(B68:B72)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Sonstige Kosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Sonstige 1"]
["Sonstige 2"]
["Sonstige 3"]
["Sonstige 4"]
["Sonstige 5"]
[null,{"$f":"SUM(B77:B81)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Partner 4","index":6,"n_rows":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":false,"merged":[[58,1,58,3],[65,1,65,3],[74,1,74,3],[0,2,0,3],[1,2,1,3],[2,2,2,3],[24,0,24,13],[26,1,26,3],[41,1,41,3]]}
["Projektpartner","Partner 4","Umsatzsteuerpflichtig*",null,null,"*verpflichtend, bitte auswählen"]
[null,null,"Umsatzsteuersatz*"]
[null,null,"EBI oder TZW?*"]
[]
["Kostenart","AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10","Total"]
["Personalkosten",{"$f":"B39","v":0},0,0,0,0,0,0,0,{"$f":"J39","v":0},{"$f":"K39","v":0},{"$f":"SUM(Tabelle14108911[[#This Row],[AP1]:[AP10]])","v":0}]
["Sachkosten",{"$f":"B57","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle14108911[[#This Row],[AP1]:[AP10]])","v":0}]
["Reisekosten",{"$f":"B64","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle14108911[[#This Row],[AP1]:[AP10]])","v":0}]
["Fremdleistungen",{"$f":"B73","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle14108911[[#This Row],[AP1]:[AP10]])","v":0}]
["Sonstige Kosten",{"$f":"B82","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle14108911[[#This Row],[AP1]:[AP10]])","v":0}]
["Summe",{"$f":"SUM(B6:B10)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K6:K10)","v":0},{"$f":"SUM(Tabelle14108911[[#This Row],[AP1]:[AP10]])","v":0}]
["Allgemeinkostenzuschlag Personal",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E1=\"Ja\",0,L6*B21)","v":0}]
["Gesamtkosten netto",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L6:L10,L12)","v":0}]
["Umsatzsteuer",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$3=\"Ja\",0, IF($E$1=\"Ja\",$L$13*$E$2,0))","v":0}]
["Gesamtkosten brutto",null,null,null,null,null,null,null,null,null,null,{"$f":"L13+L14","v":0}]
["Eigenanteil",null,null,null,null,null,null,null,null,null,null,{"$f":"B20","v":0}]
["DVGW-Förderung",null,null,null,null,null,null,null,null,null,null,{"$f":"L15-B19-L16","v":0}]
[]
["Zuschüsse Dritter (in €)"]
["Eigenanteil (in €)"]
["Allgemeinkostenzuschlag Personal (in %)"]
[]
[]
[]
["Berechnungen für die Kostenaufstellung "]
[]
["Personalkosten","Arbeitsaufwand in Personenmonate"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10","Stundensatz","Wochenstunden","Monatssatz"]
["Mitarbeiter 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L29*M29*4","v":0}]
["Mitarbeiter 2",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 3",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 4",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 5",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 6",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 7",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 8",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 9",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 10",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B29*$N$29+B30*$N$30+B31*$N$31+B32*$N$32+B33*$N$33+B34*$N$34+B35*$N$35+B36*$N$36+B37*$N$37+B38*$N$38","v":0},{"$f":"C29*$N$29+C30*$N$30+C31*$N$31+C32*$N$32+C33*$N$33+C34*$N$34+C35*$N$35+C36*$N$36+C37*$N$37+C38*$N$38","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(B39:K39)","v":0}]
[]
[]
["Sachkosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Material 1"]
["Material 2"]
["Material 3"]
["Material 4"]
["Material 5"]
["Material 6"]
["Material 7"]
["Material 8"]
["Material 9"]
["Material 10"]
["Material 11"]
["Material 12"]
["Material 13"]
[null,{"$f":"SUM(B44:B56)","v":0},{"$f":"SUM(C44:C56)","v":0},0,0,0,0,0,0,0,0]
[]
["Reisekosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Reise 1"]
["Reise 2"]
["Reise 3"]
[null,{"$f":"SUM(B61:B63)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Fremdleistungen"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Leistung 1"]
["Leistung 2"]
["Leistung 3"]
["Leistung 4"]
["Leistung 5"]
[null,{"$f":"SUM(B68:B72)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Sonstige Kosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Sonstige 1"]
["Sonstige 2"]
["Sonstige 3"]
["Sonstige 4"]
["Sonstige 5"]
[null,{"$f":"SUM(B77:B81)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Partner 5","index":7,"n_rows":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":false,"merged":[[58,1,58,3],[65,1,65,3],[74,1,74,3],[0,2,0,3],[1,2,1,3],[2,2,2,3],[24,0,24,13],[26,1,26,3],[41,1,41,3]]}
["Projektpartner","Partner 5","Umsatzsteuerpflichtig*",null,null,"*verpflichtend, bitte auswählen"]
[null,null,"Umsatzsteuersatz*"]
[null,null,"EBI oder TZW?*"]
[]
["Kostenart","AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10","Total"]
["Personalkosten",{"$f":"B39","v":0},0,0,0,0,0,0,0,{"$f":"J39","v":0},{"$f":"K39","v":0},{"$f":"SUM(Tabelle1410891112[[#This Row],[AP1]:[AP10]])","v":0}]
["Sachkosten",{"$f":"B57","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle1410891112[[#This Row],[AP1]:[AP10]])","v":0}]
["Reisekosten",{"$f":"B64","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle1410891112[[#This Row],[AP1]:[AP10]])","v":0}]
["Fremdleistungen",{"$f":"B73","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle1410891112[[#This Row],[AP1]:[AP10]])","v":0}]
["Sonstige Kosten",{"$f":"B82","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle1410891112[[#This Row],[AP1]:[AP10]])","v":0}]
["Summe",{"$f":"SUM(B6:B10)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K6:K10)","v":0},{"$f":"SUM(Tabelle1410891112[[#This Row],[AP1]:[AP10]])","v":0}]
["Allgemeinkostenzuschlag Personal",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E1=\"Ja\",0,L6*B21)","v":0}]
["Gesamtkosten netto",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L6:L10,L12)","v":0}]
["Umsatzsteuer",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$3=\"Ja\",0, IF($E$1=\"Ja\",$L$13*$E$2,0))","v":0}]
["Gesamtkosten brutto",null,null,null,null,null,null,null,null,null,null,{"$f":"L13+L14","v":0}]
["Eigenanteil",null,null,null,null,null,null,null,null,null,null,{"$f":"B20","v":0}]
["DVGW-Förderung",null,null,null,null,null,null,null,null,null,null,{"$f":"L15-B19-L16","v":0}]
[]
["Zuschüsse Dritter (in €)"]
["Eigenanteil (in €)"]
["Allgemeinkostenzuschlag Personal (in %)"]
[]
[]
[]
["Berechnungen für die Kostenaufstellung "]
[]
["Personalkosten","Arbeitsaufwand in Personenmonate"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10","Stundensatz","Wochenstunden","Monatssatz"]
["Mitarbeiter 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L29*M29*4","v":0}]
["Mitarbeiter 2",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 3",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 4",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 5",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 6",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 7",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 8",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 9",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 10",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B29*$N$29+B30*$N$30+B31*$N$31+B32*$N$32+B33*$N$33+B34*$N$34+B35*$N$35+B36*$N$36+B37*$N$37+B38*$N$38","v":0},{"$f":"C29*$N$29+C30*$N$30+C31*$N$31+C32*$N$32+C33*$N$33+C34*$N$34+C35*$N$35+C36*$N$36+C37*$N$37+C38*$N$38","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(B39:K39)","v":0}]
[]
[]
["Sachkosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Material 1"]
["Material 2"]
["Material 3"]
["Material 4"]
["Material 5"]
["Material 6"]
["Material 7"]
["Material 8"]
["Material 9"]
["Material 10"]
["Material 11"]
["Material 12"]
["Material 13"]
[null,{"$f":"SUM(B44:B56)","v":0},{"$f":"SUM(C44:C56)","v":0},0,0,0,0,0,0,0,0]
[]
["Reisekosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Reise 1"]
["Reise 2"]
["Reise 3"]
[null,{"$f":"SUM(B61:B63)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Fremdleistungen"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Leistung 1"]
["Leistung 2"]
["Leistung 3"]
["Leistung 4"]
["Leistung 5"]
[null,{"$f":"SUM(B68:B72)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Sonstige Kosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Sonstige 1"]
["Sonstige 2"]
["Sonstige 3"]
["Sonstige 4"]
["Sonstige 5"]
[null,{"$f":"SUM(B77:B81)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Partner 6","index":8,"n_rows":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":false,"merged":[[58,1,58,3],[65,1,65,3],[74,1,74,3],[0,2,0,3],[1,2,1,3],[2,2,2,3],[24,0,24,13],[26,1,26,3],[41,1,41,3]]}
["Projektpartner","Partner 6","Umsatzsteuerpflichtig*",null,null,"*verpflichtend, bitte auswählen"]
[null,null,"Umsatzsteuersatz*"]
[null,null,"EBI oder TZW?*"]
[]
["Kostenart","AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10","Total"]
["Personalkosten",{"$f":"B39","v":0},0,0,0,0,0,0,0,{"$f":"J39","v":0},{"$f":"K39","v":0},{"$f":"SUM(Tabelle141089111213[[#This Row],[AP1]:[AP10]])","v":0}]
["Sachkosten",{"$f":"B57","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle141089111213[[#This Row],[AP1]:[AP10]])","v":0}]
["Reisekosten",{"$f":"B64","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle141089111213[[#This Row],[AP1]:[AP10]])","v":0}]
["Fremdleistungen",{"$f":"B73","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle141089111213[[#This Row],[AP1]:[AP10]])","v":0}]
["Sonstige Kosten",{"$f":"B82","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabelle141089111213[[#This Row],[AP1]:[AP10]])","v":0}]
["Summe",{"$f":"SUM(B6:B10)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K6:K10)","v":0},{"$f":"SUM(Tabelle141089111213[[#This Row],[AP1]:[AP10]])","v":0}]
["Allgemeinkostenzuschlag Personal",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E1=\"Ja\",0,L6*B21)","v":0}]
["Gesamtkosten netto",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L6:L10,L12)","v":0}]
["Umsatzsteuer",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$3=\"Ja\",0, IF($E$1=\"Ja\",$L$13*$E$2,0))","v":0}]
["Gesamtkosten brutto",null,null,null,null,null,null,null,null,null,null,{"$f":"L13+L14","v":0}]
["Eigenanteil",null,null,null,null,null,null,null,null,null,null,{"$f":"B20","v":0}]
["DVGW-Förderung",null,null,null,null,null,null,null,null,null,null,{"$f":"L15-B19-L16","v":0}]
[]
["Zuschüsse Dritter (in €)"]
["Eigenanteil (in €)"]
["Allgemeinkostenzuschlag Personal (in %)"]
[]
[]
[]
["Berechnungen für die Kostenaufstellung "]
[]
["Personalkosten","Arbeitsaufwand in Personenmonate"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10","Stundensatz","Wochenstunden","Monatssatz"]
["Mitarbeiter 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L29*M29*4","v":0}]
["Mitarbeiter 2",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 3",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 4",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 5",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 6",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 7",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 8",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 9",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Mitarbeiter 10",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B29*$N$29+B30*$N$30+B31*$N$31+B32*$N$32+B33*$N$33+B34*$N$34+B35*$N$35+B36*$N$36+B37*$N$37+B38*$N$38","v":0},{"$f":"C29*$N$29+C30*$N$30+C31*$N$31+C32*$N$32+C33*$N$33+C34*$N$34+C35*$N$35+C36*$N$36+C37*$N$37+C38*$N$38","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(B39:K39)","v":0}]
[]
[]
["Sachkosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Material 1"]
["Material 2"]
["Material 3"]
["Material 4"]
["Material 5"]
["Material 6"]
["Material 7"]
["Material 8"]
["Material 9"]
["Material 10"]
["Material 11"]
["Material 12"]
["Material 13"]
[null,{"$f":"SUM(B44:B56)","v":0},{"$f":"SUM(C44:C56)","v":0},0,0,0,0,0,0,0,0]
[]
["Reisekosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Reise 1"]
["Reise 2"]
["Reise 3"]
[null,{"$f":"SUM(B61:B63)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Fremdleistungen"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Leistung 1"]
["Leistung 2"]
["Leistung 3"]
["Leistung 4"]
["Leistung 5"]
[null,{"$f":"SUM(B68:B72)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Sonstige Kosten"]
[null,"AP1","AP2","AP3","AP4","AP5","AP6","AP7","AP8","AP9","AP10"]
["Sonstige 1"]
["Sonstige 2"]
["Sonstige 3"]
["Sonstige 4"]
["Sonstige 5"]
[null,{"$f":"SUM(B77:B81)","v":0},0,0,0,0,0,0,0,0,0]