{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["Vorbemerkungen","Formblatt 1 - Einzelkosten","Formblatt 2 - BGK mit Zuschlag","Formblatt 3 - Zuschlagssätze","Formblatt 4- Gemeinkostenumlage","Formblatt 5 - Vertragspreise","Formblatt 6 - Angebotssumme"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":52,"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":"Vorbemerkungen","index":0,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,0,29,1],[1,0,1,1],[2,0,2,1],[4,0,4,1],[18,0,18,1],[20,0,20,1]]}
[]
["Kalkulationsverfahren für den\nPartnerschaftlichen Einheitspreisvertrag"]
["Diese Excel-Datei enthält die Formblätter des Kalkulationsverfahren Kalkulation zur Angebotssumme für die Kalkulation der Fixpreise und der Einheitspreise, die für die Vergütungsform des  Partnerschaftlichen Einheitspreispreisvertrages benötigt werden. Die Formblätter sind über Formeln miteinander verknüpft."]
[]
["Eine Kalkulation der Fixpreise und der Einheitspreise kann mit folgenden Formblättern durchgeführt werden:"]
[]
[null,"Formblatt 1 – Ermittlung der fixen und variablen Einzelkosten der Teilleistungen "]
[]
[null,"Formblatt 2 – Ermittlung der Baustellengemeinkosten mit Zuschlag"]
[]
[null,"Formblatt 3 – Zuschlagssätze für die Umlage"]
[]
[null,"Formblatt 4 – Durchführung der Umlage"]
[]
[null,"Formblatt 5 – Ermittlung der Vertragspreise"]
[]
[null,"Formblatt 6 – Ermittlung der Angebotssumme"]
[]
["Die Eingaben in die Formblätter erfolgen in den farblich hinterlegten Zellen. In den anderen Zellen sind Formeln hinterlegt, die den Zelleninhalt automatisch berechnen."]
[]
["Eine Anleitung zur Anwendung der Formblätter kann unter www.kalkulation.einheitspreisvertrag.de nachgeschlagen werden."]
[]
["Autor: ","Christian Flemming"]
[]
["Kontakt:","info@einheitspreisvertrag.de"]
[]
["Quelle:","www.einheitspreisvertrag.de"]
[null,"www.kalkulation.einheitspreisvertrag.de"]
[]
["Das Werk einschließlich aller seiner Teile ist urheberrechtlich geschützt. Jede wissenschaftliche, nicht kommerzielle Verwertung ist unter Angabe des Autors zulässig. "]

{"sheet":"Formblatt 1 - Einzelkosten","index":1,"n_rows":17,"n_cols":22,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,16,3,21],[4,5,4,9],[4,10,4,15],[4,16,4,21],[4,3,6,4],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,8,6,8],[5,9,6,9],[5,10,5,11],[5,16,5,17],[5,18,6,18],[8,0,8,1],[8,3,8,4],[3,0,3,4],[3,5,3,9],[3,10,3,15],[4,0,6,1],[4,2,6,2],[5,15,6,15],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,12,6,12],[5,13,6,13],[5,14,6,14]]}
["Formblatt 1 – Ermittlung der fixen und variablen Einzelkosten der Teilleistungen "]
[]
[]
["Beschreibung der Teilleistung",{"$nulls":4},"Variable Einzelkosten je Einheit (ohne Zuschlag)",{"$nulls":4},"Variable Einzelkosten je Teilleistung (ohne Zuschlag)",{"$nulls":5},"Fixe Einzelkosten je Teilleistung (ohne Zuschlag)"]
["Positions-nummer",null,"Kurztext der Teilleistung","Mengenansatz",null,"Kostenarten",{"$nulls":4},"Kostenarten",{"$nulls":5},"Kostenarten"]
[{"$nulls":5},"Lohnkosten","Stoffkosten","Gerätekosten","Sonstige Kosten","NU-Leistungen","Lohnkosten",null,"Stoffkosten","Gerätekosten","Sonstige Kosten","NU-Leistungen","Lohnkosten",null,"Stoffkosten","Gerätekosten","Sonstige Kosten","NU-Leistungen"]
[{"$nulls":10},"Mittellohn =",26.15,{"$nulls":4},"Mittellohn =",{"$f":"L7","v":26.15}]
[{"$nulls":5},"[h]","[€]","[€]","[€]","[€]","[h]","[€]","[€]","[€]","[€]","[€]","[h]","[€]","[€]","[€]","[€]","[€]"]
[1,null,2,3,null,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[{"$nulls":10},"[3] · [4]","[9] · ML","[3] · [5]","[3] · [6]","[3] · [7]","[3] · [8]"]
["14.2.85",null,"Schalung der Beckenwand",687.63,"m²",0.4,0,null,null,null,{"$f":"D11*F11","v":275.05200000000002},{"$f":"ROUND(K11*$L$7,2)","v":7192.61},{"$f":"ROUND(D11*G11,2)","v":0},{"$f":"ROUND(D11*H11,2)","v":0},{"$f":"ROUND(D11*I11,2)","v":0},{"$f":"ROUND(D11*J11,2)","v":0},103.62,{"$f":"ROUND(Q11*$R$7,2)","v":2709.66},946,2746.84,734.24,0]
["Rest",null,"restliche Leistungspositionen",1,"psch.",16315.44,792102.8,20217.75,24562.87,243439.89,{"$f":"D12*F12","v":16315.44},{"$f":"ROUND(K12*$L$7,2)","v":426648.76},{"$f":"ROUND(D12*G12,2)","v":792102.8},{"$f":"ROUND(D12*H12,2)","v":20217.75},{"$f":"ROUND(D12*I12,2)","v":24562.87},{"$f":"ROUND(D12*J12,2)","v":243439.89},3341.72,{"$f":"ROUND(Q12*$R$7,2)","v":87385.98},128946.97,17222.52,66410.73,136934.94]
[{"$nulls":10},{"$f":"D13*F13","v":0},{"$f":"ROUND(K13*$L$7,2)","v":0},{"$f":"ROUND(D13*G13,2)","v":0},{"$f":"ROUND(D13*H13,2)","v":0},{"$f":"ROUND(D13*I13,2)","v":0},{"$f":"ROUND(D13*J13,2)","v":0},null,{"$f":"ROUND(Q13*$R$7,2)","v":0}]
[{"$nulls":10},0,0,0,0,0,0,null,0]
[{"$nulls":10},0,0,0,0,0,0,null,0]
[{"$nulls":10},0,0,0,0,0,0,null,0]
[{"$nulls":9},"Summe",{"$f":"SUM(K11:K16)","v":16590.492000000002},433841.37,792102.8,20217.75,24562.87,243439.89,3445.3399999999997,90095.64,129892.97,19969.36,67144.97,136934.94]

{"sheet":"Formblatt 2 - BGK mit Zuschlag","index":2,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[31,0,31,3],[38,0,38,1],[39,0,39,3],[15,0,15,3],[14,0,14,1],[51,0,51,2],[52,0,52,2],[46,0,46,1],[47,0,47,3],[3,0,3,8],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,8],[48,0,48,8],[49,0,49,2],[50,0,50,2],[22,0,22,1],[23,0,23,3],[30,0,30,1]]}
["Formblatt 2 – Ermittlung der Baustellengemeinkosten mit Zuschlag"]
[]
[]
["   Baustellengemeinkosten"]
["Kostenarten",null,null,"Lohnkosten [€]","Stoffkosten [€]","Gerätekosten [€]","Sonstige Kosten [€]","NU-Leistungen [€]","Summe [€]"]
["zeitunabhängige BGK",null,null,6966.36,26111.78,30235.200000000001,62625.67,1969.54,{"$f":"SUM(D6:H6)","v":127908.54999999999}]
["zeitabhängige BGK",null,null,22060.14,42603.43,8281.2800000000007,11567.85,0,{"$f":"SUM(D7:H7)","v":84512.700000000012}]
["Summe der BGK",null,null,{"$f":"SUM(D6:D7)","v":29026.5},{"$f":"SUM(E6:E7)","v":68715.209999999992},{"$f":"SUM(F6:F7)","v":38516.480000000003},{"$f":"SUM(G6:G7)","v":74193.52},{"$f":"SUM(H6:H7)","v":1969.54},{"$f":"SUM(D8:H8)","v":212421.25000000003}]
["   Allgemeine Geschäftskosten, Wagnis und Gewinn für die Baustellengemeinkosten"]
["Allgemeine Geschäftskosten (AGK), Wagnis (W) und Gewinn (G)"]
["für die Baustellengemeinkosten der Kostenart LOHN"]
[]
[null,"AGK:",9,"der","Baustellengemeinkosten für Lohnkosten",null,null,{"$f":"D8","v":29026.5}]
[null,"W + G:",2,"Baustellen-"]
["Summe:",null,{"$f":"C13+C14","v":11},"gemeinkosten"]
["Umrechnung auf Herstellkosten",null,null,null,{"$f":"C15","v":11},{"$f":"C15","v":11},{"$f":"ROUNDUP(C15*100/(100-C15),2)","v":12.36},{"$f":"SUM(H13:H15)","v":29026.5},{"$f":"ROUND(H16*G16/100,2)","v":3587.68}]
[]
["Allgemeine Geschäftskosten (AGK), Wagnis (W) und Gewinn (G)"]
["für die Baustellengemeinkosten der Kostenart STOFFKOSTEN"]
[]
[null,"AGK:",9,"der","Baustellengemeinkosten für Stoffkosten",null,null,{"$f":"E8","v":68715.209999999992}]
[null,"W + G:",2,"Baustellen-"]
["Summe:",null,{"$f":"C21+C22","v":11},"gemeinkosten"]
["Umrechnung auf Herstellkosten",null,null,null,{"$f":"C23","v":11},{"$f":"C23","v":11},{"$f":"ROUNDUP(C23*100/(100-C23),2)","v":12.36},{"$f":"SUM(H21:H23)","v":68715.209999999992},{"$f":"ROUND(H24*G24/100,2)","v":8493.2000000000007}]
[]
["Allgemeine Geschäftskosten (AGK), Wagnis (W) und Gewinn (G)"]
["für die Baustellengemeinkosten der Kostenart GERÄTEKOSTEN"]
[]
[null,"AGK:",9,"der","Baustellengemeinkosten für Gerätekosten",null,null,{"$f":"F8","v":38516.480000000003}]
[null,"W + G:",2,"Baustellen-"]
["Summe:",null,{"$f":"C29+C30","v":11},"gemeinkosten"]
["Umrechnung auf Herstellkosten",null,null,null,{"$f":"C31","v":11},{"$f":"C31","v":11},{"$f":"ROUNDUP(C31*100/(100-C31),2)","v":12.36},{"$f":"SUM(H29:H31)","v":38516.480000000003},{"$f":"ROUND(H32*G32/100,2)","v":4760.6400000000003}]
[]
["Allgemeine Geschäftskosten (AGK), Wagnis (W) und Gewinn (G)"]
["für die Baustellengemeinkosten der Kostenart SONSTIGE KOSTEN"]
[]
[null,"AGK:",9,"der","Baustellengemeinkosten für sonstige Kosten",null,null,{"$f":"G8","v":74193.52}]
[null,"W + G:",2,"Baustellen-"]
["Summe:",null,{"$f":"C37+C38","v":11},"gemeinkosten"]
["Umrechnung auf Herstellkosten",null,null,null,{"$f":"C39","v":11},{"$f":"C39","v":11},{"$f":"ROUNDUP(C39*100/(100-C39),2)","v":12.36},{"$f":"SUM(H37:H39)","v":74193.52},{"$f":"ROUND(H40*G40/100,2)","v":9170.32}]
[]
["Allgemeine Geschäftskosten (AGK), Wagnis (W) und Gewinn (G)"]
["für die Baustellengemeinkosten der Kostenart NACHUNTERNEHMERLEISTUNGEN"]
[]
[null,"AGK:",7,"der","Baustellengemeinkosten für Nachunternehmerleistungen",null,null,{"$f":"H8","v":1969.54}]
[null,"W + G:",2,"Baustellen-"]
["Summe:",null,{"$f":"C45+C46","v":9},"gemeinkosten"]
["Umrechnung auf Herstellkosten",null,null,null,{"$f":"C47","v":9},{"$f":"C47","v":9},{"$f":"ROUND(C47*100/(100-C47),2)","v":9.89},{"$f":"SUM(H45:H47)","v":1969.54},{"$f":"ROUND(H48*G48/100,2)","v":194.79}]
["   Summe der Baustellengemeinkosten mit Zuschlag"]
["Kostenarten",null,null,"Lohnkosten [€]","Stoffkosten [€]","Gerätekosten [€]","Sonstige Kosten [€]","Fremdleistung [€]","Summe [€]"]
["Baustellengemeinkosten",null,null,{"$f":"D8","v":29026.5},{"$f":"E8","v":68715.209999999992},{"$f":"F8","v":38516.480000000003},{"$f":"G8","v":74193.52},{"$f":"H8","v":1969.54},{"$f":"SUM(D51:H51)","v":212421.25000000003}]
["AGK, W + G auf BGK",null,null,{"$f":"I16","v":3587.68},{"$f":"I24","v":8493.2000000000007},{"$f":"I32","v":4760.6400000000003},{"$f":"I40","v":9170.32},{"$f":"I48","v":194.79},{"$f":"SUM(D52:H52)","v":26206.63}]
["Summe",null,null,{"$f":"SUM(D51:D52)","v":32614.18},{"$f":"SUM(E51:E52)","v":77208.409999999989},{"$f":"SUM(F51:F52)","v":43277.120000000003},{"$f":"SUM(G51:G52)","v":83363.839999999997},{"$f":"SUM(H51:H52)","v":2164.33},{"$f":"SUM(D53:H53)","v":238627.87999999998}]

{"sheet":"Formblatt 3 - Zuschlagssätze","index":3,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[8,0,8,8],[3,0,3,8],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2]]}
["Formblatt 3 – Zuschlagssätze für die Umlage"]
[]
[]
["   Ermittlung der Bezugsbasis"]
["Kostenarten",null,null,"Lohnkosten [€]","Stoffkosten [€]","Gerätekosten [€]","Sonstige Kosten [€]","NU-Leistungen [€]","Summe [€]"]
["Variable Einzelkosten",null,null,{"$f":"'Formblatt 1 - Einzelkosten'!L17","v":433841.37},{"$f":"'Formblatt 1 - Einzelkosten'!M17","v":792102.8},{"$f":"'Formblatt 1 - Einzelkosten'!N17","v":20217.75},{"$f":"'Formblatt 1 - Einzelkosten'!O17","v":24562.87},{"$f":"'Formblatt 1 - Einzelkosten'!P17","v":243439.89},{"$f":"SUM(D6:H6)","v":1514164.6800000002}]
["Fixe Einzelkosten",null,null,{"$f":"'Formblatt 1 - Einzelkosten'!R17","v":90095.64},{"$f":"'Formblatt 1 - Einzelkosten'!S17","v":129892.97},{"$f":"'Formblatt 1 - Einzelkosten'!T17","v":19969.36},{"$f":"'Formblatt 1 - Einzelkosten'!U17","v":67144.97},{"$f":"'Formblatt 1 - Einzelkosten'!V17","v":136934.94},{"$f":"SUM(D7:H7)","v":444037.87999999995}]
["Summe der Einzelkosten",null,null,{"$f":"SUM(D6:D7)","v":523937.01},{"$f":"SUM(E6:E7)","v":921995.77},{"$f":"SUM(F6:F7)","v":40187.11},{"$f":"SUM(G6:G7)","v":91707.839999999997},{"$f":"SUM(H6:H7)","v":380374.83},{"$f":"SUM(D8:H8)","v":1958202.5600000003}]
["   Ermittlung der Zuschlagsätze"]
["Summe der Baustellengemeinkosten mit Zuschlag",{"$nulls":7},{"$f":"'Formblatt 2 - BGK mit Zuschlag'!I53","v":238627.87999999998}]
["abzüglich gewählten Zuschlag auf",{"$nulls":5},"Einzelkosten","Umlagebetrag"]
[{"$nulls":4},"Stoffkosten",15,{"$f":"E8","v":921995.77},{"$f":"ROUND(G12/100*F12,2)","v":138299.37}]
[{"$nulls":4},"Gerätekosten",15,{"$f":"F8","v":40187.11},{"$f":"ROUND(G13/100*F13,2)","v":6028.07}]
[{"$nulls":4},"Sonstige Kosten",15,{"$f":"G8","v":91707.839999999997},{"$f":"ROUND(G14/100*F14,2)","v":13756.18}]
[{"$nulls":4},"NU-Leistungen",10,{"$f":"H8","v":380374.83},{"$f":"ROUND(G15/100*F15,2)","v":38037.480000000003}]
[{"$nulls":7},"Summe gewählter Zuschläge:",{"$f":"SUM(H12:H15)","v":196121.1}]
["zu verrechnender Zuschlag auf Lohnkosten (Restumlage)",{"$nulls":7},{"$f":"I10-I16","v":42506.77999999997}]
["Mittellohn",{"$nulls":7},{"$f":"'Formblatt 1 - Einzelkosten'!L7","v":26.15}]
["Zuschlag auf Mittellohn",null,null,null,{"$f":"I17","v":42506.77999999997},{"$f":"D8","v":523937.01},{"$f":"IF(ISERROR(ROUND(I17/D8,4)),0,ROUND(I17/D8,4))","v":8.1100000000000005E-2},null,{"$f":"ROUND(I18*G19,2)","v":2.12}]

{"sheet":"Formblatt 4- Gemeinkostenumlage","index":4,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,0,3,2],[3,3,3,7],[3,8,3,12],[4,3,4,7],[4,8,4,12],[4,0,6,1],[4,2,6,2],[3,13,6,13],[5,12,6,12],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[8,0,8,1],[5,5,6,5],[5,6,6,6],[16,2,16,12],[5,3,6,3],[5,4,6,4],[5,7,6,7]]}
["Formblatt 4 – Durchführung der Umlage"]
[]
[]
["Beschreibung der Teilleistung",null,null,"Summe der variablen und fixen Einzelkosten je Teilleistung",{"$nulls":4},"Anteil an den Baustellengemeinkosten mit Zuschlag je Teilleistung",{"$nulls":4},"Gesamtanteil\nan den BGK\nmit Zuschlag\nje Teilleistung"]
["Positions-nummer",null,"Kurztext der Teilleistung","Kostenarten",{"$nulls":4},"Kostenarten"]
[null,null,null,"Lohnkosten","Stoffkosten","Gerätekosten","Sonstige Kosten","NU-Leistungen","Lohnkosten","Stoffkosten","Gerätekosten","Sonstige Kosten","NU-Leistungen"]
[]
[null,null,null,"[h]","[€]","[€]","[€]","[€]","[€]","[€]","[€]","[€]","[€]","[€]"]
[1,null,2,3,4,5,6,7,8,9,10,11,12,13]
[{"$nulls":8},{"$f":"'Formblatt 3 - Zuschlagssätze'!I19","v":2.12},{"$f":"'Formblatt 3 - Zuschlagssätze'!F12/100","v":0.15},{"$f":"'Formblatt 3 - Zuschlagssätze'!F13/100","v":0.15},{"$f":"'Formblatt 3 - Zuschlagssätze'!F14/100","v":0.15},{"$f":"'Formblatt 3 - Zuschlagssätze'!F15/100","v":0.1},"Σ [8] bis [12]"]
[{"$f":"'Formblatt 1 - Einzelkosten'!A11","v":"14.2.85"},null,{"$f":"'Formblatt 1 - Einzelkosten'!C11","v":"Schalung der Beckenwand"},{"$f":"'Formblatt 1 - Einzelkosten'!K11+'Formblatt 1 - Einzelkosten'!Q11","v":378.67200000000003},{"$f":"'Formblatt 1 - Einzelkosten'!M11+'Formblatt 1 - Einzelkosten'!S11","v":946},{"$f":"'Formblatt 1 - Einzelkosten'!N11+'Formblatt 1 - Einzelkosten'!T11","v":2746.84},{"$f":"'Formblatt 1 - Einzelkosten'!O11+'Formblatt 1 - Einzelkosten'!U11","v":734.24},{"$f":"'Formblatt 1 - Einzelkosten'!P11+'Formblatt 1 - Einzelkosten'!V11","v":0},{"$f":"ROUND(D11*$I$10,2)","v":802.78},{"$f":"ROUND(E11*$J$10,2)","v":141.9},{"$f":"ROUND(F11*$K$10,2)","v":412.03},{"$f":"ROUND(G11*$L$10,2)","v":110.14},{"$f":"ROUND(H11*$M$10,2)","v":0},{"$f":"SUM(I11:M11)","v":1466.8500000000001}]
[{"$f":"'Formblatt 1 - Einzelkosten'!A12","v":"Rest"},null,{"$f":"'Formblatt 1 - Einzelkosten'!C12","v":"restliche Leistungspositionen"},{"$f":"'Formblatt 1 - Einzelkosten'!K12+'Formblatt 1 - Einzelkosten'!Q12","v":19657.16},{"$f":"'Formblatt 1 - Einzelkosten'!M12+'Formblatt 1 - Einzelkosten'!S12","v":921049.77},{"$f":"'Formblatt 1 - Einzelkosten'!N12+'Formblatt 1 - Einzelkosten'!T12","v":37440.270000000004},{"$f":"'Formblatt 1 - Einzelkosten'!O12+'Formblatt 1 - Einzelkosten'!U12","v":90973.599999999991},{"$f":"'Formblatt 1 - Einzelkosten'!P12+'Formblatt 1 - Einzelkosten'!V12","v":380374.83},{"$f":"ROUND(D12*$I$10,2)","v":41673.18},{"$f":"ROUND(E12*$J$10,2)","v":138157.47},{"$f":"ROUND(F12*$K$10,2)","v":5616.04},{"$f":"ROUND(G12*$L$10,2)","v":13646.04},{"$f":"ROUND(H12*$M$10,2)","v":38037.480000000003},{"$f":"SUM(I12:M12)","v":237130.21000000002}]
[{"$f":"'Formblatt 1 - Einzelkosten'!A13","v":0},null,{"$f":"'Formblatt 1 - Einzelkosten'!C13","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!K13+'Formblatt 1 - Einzelkosten'!Q13","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!M13+'Formblatt 1 - Einzelkosten'!S13","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!N13+'Formblatt 1 - Einzelkosten'!T13","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!O13+'Formblatt 1 - Einzelkosten'!U13","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!P13+'Formblatt 1 - Einzelkosten'!V13","v":0},{"$f":"ROUND(D13*$I$10,2)","v":0},{"$f":"ROUND(E13*$J$10,2)","v":0},{"$f":"ROUND(F13*$K$10,2)","v":0},{"$f":"ROUND(G13*$L$10,2)","v":0},{"$f":"ROUND(H13*$M$10,2)","v":0},{"$f":"SUM(I13:M13)","v":0}]
[{"$f":"'Formblatt 1 - Einzelkosten'!A14","v":0},null,{"$f":"'Formblatt 1 - Einzelkosten'!C14","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!K14+'Formblatt 1 - Einzelkosten'!Q14","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!M14+'Formblatt 1 - Einzelkosten'!S14","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!N14+'Formblatt 1 - Einzelkosten'!T14","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!O14+'Formblatt 1 - Einzelkosten'!U14","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!P14+'Formblatt 1 - Einzelkosten'!V14","v":0},0,0,0,0,0,0]
[{"$f":"'Formblatt 1 - Einzelkosten'!A15","v":0},null,{"$f":"'Formblatt 1 - Einzelkosten'!C15","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!K15+'Formblatt 1 - Einzelkosten'!Q15","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!M15+'Formblatt 1 - Einzelkosten'!S15","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!N15+'Formblatt 1 - Einzelkosten'!T15","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!O15+'Formblatt 1 - Einzelkosten'!U15","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!P15+'Formblatt 1 - Einzelkosten'!V15","v":0},0,0,0,0,0,0]
[{"$f":"'Formblatt 1 - Einzelkosten'!A16","v":0},null,{"$f":"'Formblatt 1 - Einzelkosten'!C16","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!K16+'Formblatt 1 - Einzelkosten'!Q16","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!M16+'Formblatt 1 - Einzelkosten'!S16","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!N16+'Formblatt 1 - Einzelkosten'!T16","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!O16+'Formblatt 1 - Einzelkosten'!U16","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!P16+'Formblatt 1 - Einzelkosten'!V16","v":0},0,0,0,0,0,0]
[null,null,"Summe der Baustellengemeinkosten mit Zuschlag   ",{"$nulls":10},{"$f":"SUM(N11:N16)","v":238597.06000000003}]

{"sheet":"Formblatt 5 - Vertragspreise","index":5,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[8,0,8,1],[3,3,3,8],[4,8,6,8],[5,9,6,9],[16,0,16,15],[3,9,3,15],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[4,14,6,14],[4,15,6,15],[5,6,6,6],[5,7,6,7],[4,9,4,13],[5,3,6,3],[5,4,6,4],[5,5,6,5],[3,0,3,2],[4,3,4,7],[4,0,6,1],[4,2,6,2]]}
["Formblatt 5 – Ermittlung der Vertragspreise"]
[]
[]
["Beschreibung der Teilleistung",null,null,"Variable Kosten je Einheit (mit Zuschlag)",{"$nulls":5},"Fixe Kosten je Teilleistung (mit Zuschlag)"]
["Positions-nummer",null,"Kurztext der Teilleistung","variable Einzelkosten",{"$nulls":4},"Einheitspreis","fixe Einzelkosten",{"$nulls":4},"Gesamtanteil\nan den BGK\nmit Zuschlag\nje Teilleistung","Fixpreis"]
[null,null,null,"Lohnkosten","Stoffkosten","Gerätekosten","Sonstige Kosten","NU-Leistungen",null,"Lohnkosten","Stoffkosten ","Gerätekosten","Sonstige Kosten","NU-Leistungen"]
[]
[null,null,null,"[€]","[€]","[€]","[€]","[€]","[€]","[€]","[€]","[€]","[€]","[€]","[€]","[€]"]
[1,null,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,"Zuschlag für AGK, W + G = ",{"$f":"'Formblatt 2 - BGK mit Zuschlag'!G16","v":12.36},{"$f":"'Formblatt 2 - BGK mit Zuschlag'!G24","v":12.36},{"$f":"'Formblatt 2 - BGK mit Zuschlag'!G32","v":12.36},{"$f":"'Formblatt 2 - BGK mit Zuschlag'!G40","v":12.36},{"$f":"'Formblatt 2 - BGK mit Zuschlag'!G48","v":9.89},"Σ [3] von [7]",{"$f":"D10","v":12.36},{"$f":"E10","v":12.36},{"$f":"F10","v":12.36},{"$f":"G10","v":12.36},{"$f":"H10","v":9.89},null,"Σ [9] bis [14]"]
[{"$f":"'Formblatt 1 - Einzelkosten'!A11","v":"14.2.85"},null,{"$f":"'Formblatt 1 - Einzelkosten'!C11","v":"Schalung der Beckenwand"},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!F11*(1+$D$10/100)*'Formblatt 1 - Einzelkosten'!$L$7,2)","v":11.75},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!G11*(1+$E$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!H11*(1+$F$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!I11*(1+$G$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!J11*(1+$H$10/100),2)","v":0},{"$f":"SUM(D11:H11)","v":11.75},{"$f":"ROUNDDOWN('Formblatt 1 - Einzelkosten'!Q11*(1+$J$10/100)*'Formblatt 1 - Einzelkosten'!$L$7,2)","v":3044.57},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!S11*(1+$K$10/100),2)","v":1062.93},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!T11*(1+$L$10/100),2)","v":3086.35},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!U11*(1+$M$10/100),2)","v":824.99},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!V11*(1+$N$10/100),2)","v":0},{"$f":"ROUND('Formblatt 4- Gemeinkostenumlage'!N11,2)","v":1466.85},{"$f":"SUM(J11:O11)","v":9485.69}]
[{"$f":"'Formblatt 1 - Einzelkosten'!A12","v":"Rest"},null,{"$f":"'Formblatt 1 - Einzelkosten'!C12","v":"restliche Leistungspositionen"},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!F12*(1+$D$10/100)*'Formblatt 1 - Einzelkosten'!$L$7,2)","v":479382.54},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!G12*(1+$E$10/100),2)","v":890006.71},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!H12*(1+$F$10/100),2)","v":22716.66},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!I12*(1+$G$10/100),2)","v":27598.84},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!J12*(1+$H$10/100),2)","v":267516.09999999998},{"$f":"SUM(D12:H12)","v":1687220.85},{"$f":"ROUNDUP('Formblatt 1 - Einzelkosten'!Q12*(1+$J$10/100)*'Formblatt 1 - Einzelkosten'!$L$7,2)","v":98186.89},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!S12*(1+$K$10/100),2)","v":144884.82},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!T12*(1+$L$10/100),2)","v":19351.22},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!U12*(1+$M$10/100),2)","v":74619.100000000006},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!V12*(1+$N$10/100),2)","v":150477.81},{"$f":"ROUND('Formblatt 4- Gemeinkostenumlage'!N12,2)","v":237130.21},{"$f":"SUM(J12:O12)","v":724650.05}]
[{"$f":"'Formblatt 1 - Einzelkosten'!A13","v":0},null,{"$f":"'Formblatt 1 - Einzelkosten'!C13","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!F13*(1+$D$10/100)*'Formblatt 1 - Einzelkosten'!$L$7,2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!G13*(1+$E$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!H13*(1+$F$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!I13*(1+$G$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!J13*(1+$H$10/100),2)","v":0},{"$f":"SUM(D13:H13)","v":0},{"$f":"ROUNDUP('Formblatt 1 - Einzelkosten'!Q13*(1+$J$10/100)*'Formblatt 1 - Einzelkosten'!$L$7,2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!S13*(1+$K$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!T13*(1+$L$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!U13*(1+$M$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!V13*(1+$N$10/100),2)","v":0},{"$f":"ROUND('Formblatt 4- Gemeinkostenumlage'!N13,2)","v":0},{"$f":"SUM(J13:O13)","v":0}]
[{"$f":"'Formblatt 1 - Einzelkosten'!A14","v":0},null,{"$f":"'Formblatt 1 - Einzelkosten'!C14","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!F14*(1+$D$10/100)*'Formblatt 1 - Einzelkosten'!$L$7,2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!G14*(1+$E$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!H14*(1+$F$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!I14*(1+$G$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!J14*(1+$H$10/100),2)","v":0},0,{"$f":"ROUNDUP('Formblatt 1 - Einzelkosten'!Q14*(1+$J$10/100)*'Formblatt 1 - Einzelkosten'!$L$7,2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!S14*(1+$K$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!T14*(1+$L$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!U14*(1+$M$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!V14*(1+$N$10/100),2)","v":0},{"$f":"ROUND('Formblatt 4- Gemeinkostenumlage'!N14,2)","v":0},0]
[{"$f":"'Formblatt 1 - Einzelkosten'!A15","v":0},null,{"$f":"'Formblatt 1 - Einzelkosten'!C15","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!F15*(1+$D$10/100)*'Formblatt 1 - Einzelkosten'!$L$7,2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!G15*(1+$E$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!H15*(1+$F$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!I15*(1+$G$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!J15*(1+$H$10/100),2)","v":0},0,{"$f":"ROUNDUP('Formblatt 1 - Einzelkosten'!Q15*(1+$J$10/100)*'Formblatt 1 - Einzelkosten'!$L$7,2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!S15*(1+$K$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!T15*(1+$L$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!U15*(1+$M$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!V15*(1+$N$10/100),2)","v":0},{"$f":"ROUND('Formblatt 4- Gemeinkostenumlage'!N15,2)","v":0},0]
[{"$f":"'Formblatt 1 - Einzelkosten'!A16","v":0},null,{"$f":"'Formblatt 1 - Einzelkosten'!C16","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!F16*(1+$D$10/100)*'Formblatt 1 - Einzelkosten'!$L$7,2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!G16*(1+$E$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!H16*(1+$F$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!I16*(1+$G$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!J16*(1+$H$10/100),2)","v":0},0,{"$f":"ROUNDUP('Formblatt 1 - Einzelkosten'!Q16*(1+$J$10/100)*'Formblatt 1 - Einzelkosten'!$L$7,2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!S16*(1+$K$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!T16*(1+$L$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!U16*(1+$M$10/100),2)","v":0},{"$f":"ROUND('Formblatt 1 - Einzelkosten'!V16*(1+$N$10/100),2)","v":0},{"$f":"ROUND('Formblatt 4- Gemeinkostenumlage'!N16,2)","v":0},0]

{"sheet":"Formblatt 6 - Angebotssumme","index":6,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[8,0,8,1],[8,3,8,4],[3,5,3,7],[16,0,16,6],[5,5,6,5],[5,6,6,6],[5,7,6,7],[3,0,3,4],[4,0,6,1],[4,2,6,2],[4,3,6,4]]}
["Formblatt 6 – Ermittlung der Angebotssumme"]
[]
[]
["Beschreibung der Teilleistung",{"$nulls":4},"Preis der Teilleistung"]
["Positions-nummer",null,"Kurztext der Teilleistung","Mengenansatz"]
[{"$nulls":5},"Einheitspreis je Teilleistung","Fixpreis je Teilleistung","Gesamtpreis je Teilleistung"]
[]
[{"$nulls":5},"[€]","[€]","[€]"]
[1,null,2,3,null,4,5,6]
[]
[{"$f":"'Formblatt 1 - Einzelkosten'!A11","v":"14.2.85"},null,{"$f":"'Formblatt 1 - Einzelkosten'!C11","v":"Schalung der Beckenwand"},{"$f":"'Formblatt 1 - Einzelkosten'!D11","v":687.63},{"$f":"'Formblatt 1 - Einzelkosten'!E11","v":"m²"},{"$f":"'Formblatt 5 - Vertragspreise'!I11","v":11.75},{"$f":"'Formblatt 5 - Vertragspreise'!P11","v":9485.69},{"$f":"ROUND(F11*D11+G11,2)","v":17565.34}]
[{"$f":"'Formblatt 1 - Einzelkosten'!A12","v":"Rest"},null,{"$f":"'Formblatt 1 - Einzelkosten'!C12","v":"restliche Leistungspositionen"},{"$f":"'Formblatt 1 - Einzelkosten'!D12","v":1},{"$f":"'Formblatt 1 - Einzelkosten'!E12","v":"psch."},{"$f":"'Formblatt 5 - Vertragspreise'!I12","v":1687220.85},{"$f":"'Formblatt 5 - Vertragspreise'!P12","v":724650.05},{"$f":"ROUND(F12*D12+G12,2)","v":2411870.9}]
[{"$f":"'Formblatt 1 - Einzelkosten'!A13","v":0},null,{"$f":"'Formblatt 1 - Einzelkosten'!C13","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!D13","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!E13","v":0},{"$f":"'Formblatt 5 - Vertragspreise'!I13","v":0},{"$f":"'Formblatt 5 - Vertragspreise'!P13","v":0},{"$f":"ROUND(F13*D13+G13,2)","v":0}]
[{"$f":"'Formblatt 1 - Einzelkosten'!A14","v":0},null,{"$f":"'Formblatt 1 - Einzelkosten'!C14","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!D14","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!E14","v":0},{"$f":"'Formblatt 5 - Vertragspreise'!I14","v":0},{"$f":"'Formblatt 5 - Vertragspreise'!P14","v":0},0]
[{"$f":"'Formblatt 1 - Einzelkosten'!A15","v":0},null,{"$f":"'Formblatt 1 - Einzelkosten'!C15","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!D15","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!E15","v":0},{"$f":"'Formblatt 5 - Vertragspreise'!I15","v":0},{"$f":"'Formblatt 5 - Vertragspreise'!P15","v":0},0]
[{"$f":"'Formblatt 1 - Einzelkosten'!A16","v":0},null,{"$f":"'Formblatt 1 - Einzelkosten'!C16","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!D16","v":0},{"$f":"'Formblatt 1 - Einzelkosten'!E16","v":0},{"$f":"'Formblatt 5 - Vertragspreise'!I16","v":0},{"$f":"'Formblatt 5 - Vertragspreise'!P16","v":0},0]
["Angebotssumme =   ",{"$nulls":6},{"$f":"SUM(H11:H16)","v":2429436.2399999998}]