{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Freigabeblatt","Freigabeblatt_TO","Abrechnung_Teilobjekte","Hilfstext"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":8,"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":"Freigabeblatt","index":0,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[45,0,45,2],[54,4,54,5],[52,10,52,11],[47,10,47,11],[54,0,54,3],[41,2,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[41,10,41,11],[42,0,42,3],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[52,8,52,9],[51,0,51,2],[53,10,53,11],[51,10,51,11],[53,4,53,5],[51,8,51,9],[53,8,53,9],[56,0,56,2],[56,4,56,5],[56,6,56,7],[57,0,57,3],[57,8,57,9],[59,4,59,5],[59,6,59,7],[58,0,58,3],[59,0,59,3],[56,8,56,9],[27,10,27,11],[26,8,26,9],[25,10,25,11],[25,8,25,9],[25,6,25,7],[22,10,22,11],[12,0,12,11],[28,8,28,9],[26,6,26,7],[16,4,16,5],[21,0,21,3],[24,0,24,3],[28,10,28,11],[24,4,24,5],[24,6,24,7],[24,8,24,9],[23,0,23,3],[23,4,23,5],[22,8,22,9],[21,6,21,7],[21,8,21,9],[26,10,26,11],[22,0,22,3],[28,0,28,3],[9,0,9,11],[27,0,27,3],[27,4,27,5],[27,6,27,7],[23,10,23,11],[24,10,24,11],[16,10,16,11],[18,10,18,11],[14,10,14,11],[21,10,21,11],[18,8,18,9],[21,4,21,5],[10,8,10,9],[16,0,16,3],[19,0,19,11],[13,10,13,11],[18,4,18,5],[17,10,17,11],[11,4,11,5],[11,6,11,7],[13,0,13,2],[13,6,13,7],[26,0,26,3],[26,4,26,5],[30,10,30,11],[45,4,45,5],[30,0,30,3],[51,4,51,5],[54,6,54,7],[54,8,54,9],[51,6,51,7],[50,4,50,5],[50,6,50,7],[50,8,50,9],[34,8,34,9],[46,0,46,11],[37,0,37,11],[45,10,45,11],[50,10,50,11],[34,10,34,11],[39,2,39,3],[39,4,39,5],[39,6,39,7],[39,8,39,9],[39,10,39,11],[32,10,32,11],[35,0,35,2],[35,4,35,5],[14,4,14,5],[14,6,14,7],[17,4,17,5],[11,8,11,9],[13,8,13,9],[30,8,30,9],[49,0,49,3],[48,6,48,7],[30,6,30,7],[28,6,28,7],[40,2,40,3],[40,4,40,5],[40,6,40,7],[40,8,40,9],[22,4,22,5],[22,6,22,7],[23,6,23,7],[23,8,23,9],[48,0,48,3],[27,8,27,9],[43,0,43,11],[47,4,47,5],[47,6,47,7],[48,10,48,11],[0,0,0,1],[0,2,0,11],[1,0,1,1],[1,2,1,11],[2,0,2,1],[2,2,2,11],[8,2,8,5],[4,0,4,1],[6,6,6,7],[6,8,6,11],[8,6,8,7],[8,8,8,11],[4,2,4,11],[5,0,5,1],[5,2,5,11],[6,2,6,5],[3,9,3,11],[3,0,3,6],[7,2,7,5],[7,6,7,7],[7,8,7,11],[10,10,10,11],[10,4,10,5],[10,0,10,2],[11,0,11,3],[20,10,20,11],[10,6,10,7],[25,0,25,3],[20,0,20,2],[16,6,16,7],[16,8,16,9],[17,6,17,7],[17,8,17,9],[20,4,20,5],[20,6,20,7],[20,8,20,9],[13,4,13,5],[14,8,14,9],[11,10,11,11],[17,0,17,2],[15,0,15,11],[18,0,18,3],[14,0,14,3],[18,6,18,7],[25,4,25,5],[35,6,35,7],[35,8,35,9],[35,10,35,11],[32,0,32,2],[33,0,33,11],[44,0,44,11],[36,0,36,3],[36,4,36,5],[36,6,36,7],[34,0,34,2],[34,6,34,7],[34,4,34,5],[36,8,36,9],[40,10,40,11],[69,0,69,3],[36,10,36,11],[45,6,45,7],[45,8,45,9],[32,4,32,5],[32,6,32,7],[32,8,32,9],[31,1,31,3],[31,4,31,5],[31,6,31,7],[48,4,48,5],[49,8,49,11],[48,8,48,9],[49,4,49,7],[38,0,38,11],[56,10,56,11],[54,10,54,11],[47,0,47,2],[47,8,47,9],[53,6,53,7],[52,0,52,2],[53,0,53,2],[52,4,52,5],[52,6,52,7],[68,10,68,11],[28,4,28,5],[30,4,30,5],[31,8,31,9],[31,10,31,11],[71,0,71,3],[71,4,71,7],[71,8,71,11],[70,0,70,3],[70,4,70,5],[70,10,70,11],[70,7,70,8],[55,0,55,11],[61,4,61,5],[62,0,62,3],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[61,6,61,7],[61,8,61,9],[61,10,61,11],[58,10,58,11],[58,8,58,9],[65,0,65,3],[65,4,65,5],[65,6,65,7],[65,8,65,9],[65,10,65,11],[66,0,66,3],[66,4,66,5],[69,4,69,11],[64,0,64,3],[68,0,68,3],[68,4,68,5],[68,7,68,8],[66,6,66,7],[66,8,66,9],[66,10,66,11],[67,0,67,3],[67,4,67,5],[67,6,67,7],[67,8,67,9],[67,10,67,11],[64,4,64,5],[64,6,64,7],[64,8,64,9],[64,10,64,11],[57,10,57,11],[59,10,59,11],[61,0,61,3],[57,4,57,5],[57,6,57,7],[58,4,58,5],[63,6,63,7],[63,8,63,9],[63,10,63,11],[63,0,63,3],[63,4,63,5],[58,6,58,7],[60,4,60,5],[60,6,60,7],[60,8,60,9],[60,10,60,11],[60,0,60,3],[59,8,59,9]]}
["Projektauftraggeber:\n\n",null,"Landeshauptstadt Dresden I Amt für Hochbau und Immobilienverwaltung"]
["Projekt:",null,"<Projektbezeichnung gemäß Projektauftrag>"]
["Projektleitung:",null,"Amt für Hochbau und Immobilienverwaltung I <Name Projektleiter> I <Telefon>"]
["Rechnungsbegleitblatt",null,null,null,null,null,null,null,"Rechnungsart:"]
["Auftragnehmer:",null,"<Firma>"]
["Gewerk/Los:",null,"<Gewerk/Los>"]
["Auftragsnummer:",null,"<Auftragsnummer>",null,null,null,"Auftragsdatum:",null,"<Auftragsdatum>"]
["Rechnungsnummer:",null,"<Rechnungsnummer>",null,null,null,"Rechnungsdatum:",null,"<Rechnungsdatum>"]
["Rechnungseingang:",null,"<Datum>",null,null,null,"Zahlungsziel:",null,"<Datum>"]
[]
["1. Auftragssummen",null,null,null," Nettobetrag",null,"Mwst.satz",null,"Mwst.betrag",null,"Bruttobetrag"]
["Auftragssumme (incl. Nachträge + Nachlass)",null,null,null,{"$f":"ROUND(K12-I12,3)","v":0},null,0.19,null,{"$f":"ROUND(K12/(100%+G12)*G12,3)","v":0},null,0]
[]
["2. Vergütungsanspruch",null,null,null,"Nettobetrag",null,"Mwst.satz",null,"Mwst.betrag",null,"Bruttobetrag"]
["ungeprüfte Rechnungssumme (nur informativ)",null,null,null,0,null,0.19,null,{"$f":"ROUND(E15*G15,3)","v":0},null,{"$f":"ROUND(E15+I15,3)","v":0}]
[]
["geprüfte Rechnungssumme (ohne Nachlass)",null,null,null,0,null,0.19,null,{"$f":"ROUND(E17*G17,3)","v":0},null,{"$f":"ROUND(E17+I17,3)","v":0}]
["Nachlass",null,null,0,{"$f":"ROUND(E17*D18,3)","v":0},null,0.19,null,{"$f":"ROUND(E18*G18,3)","v":0},null,{"$f":"ROUND(E18+I18,3)","v":0}]
["geprüfte Rechnungssumme",null,null,null,{"$f":"ROUND(E17-E18,3)","v":0},null,0.19,null,{"$f":"ROUND(E19*G19,3)","v":0},null,{"$f":"ROUND(E19+I19,3)","v":0}]
[]
["3. Zahlungsstand",null,null,null,"Nettobetrag",null,"Mwst.satz",null,"Mwst.betrag",null,"Bruttobetrag"]
["1. Abschlagszahlung",null,null,null,{"$f":"ROUND(K22-I22,3)","v":0},null,0.19,null,{"$f":"ROUND(K22/(100%+G22)*G22,3)","v":0},null,0]
["2. Abschlagszahlung",null,null,null,0,null,0.19,null,0,null,0]
["3. Abschlagszahlung",null,null,null,0,null,0.19,null,0,null,0]
["4. Abschlagszahlung",null,null,null,0,null,0.19,null,0,null,0]
["5. Abschlagszahlung",null,null,null,0,null,0.19,null,0,null,0]
["6. Abschlagszahlung",null,null,null,0,null,0.19,null,0,null,0]
["7. Abschlagszahlung",null,null,null,0,null,0.19,null,0,null,0]
["8. Abschlagszahlung",null,null,null,0,null,0.19,null,0,null,0]
[]
["Geleistete Zahlungen",null,null,null,{"$f":"SUM(E22:F30)","v":0},null,0.19,null,{"$f":"SUM(I22:J30)","v":0},null,{"$f":"SUM(K22:L30)","v":0}]
[]
["4. Abzüge",null,null,null,"Nettobetrag",null,"Mwst.satz",null,"Mwst.betrag",null,"Bruttobetrag"]
["4.1 Baumedien (Nettoabzug)"]
["Bauwasser",null,null,0,{"$f":"ROUND(D35*E19,3)","v":0}]
["Baustrom",null,null,0,{"$f":"ROUND(D36*E19,3)","v":0}]
["Summe",null,null,null,{"$f":"SUM(E35:F36)","v":0}]
[]
["4.2 weitere Abzüge (Leistungsmängel, Leistungsminderungen, Vertragsstrafen) (Nettoabzug)"]
["weitere Abzüge:",null,"<Grund des Abzugs>",null,0]
["weitere Abzüge:",null,"<Grund des Abzugs>",null,0]
["weitere Abzüge:",null,"<Grund des Abzugs>",null,0]
["Summe",null,null,null,{"$f":"SUM(E40:F42)","v":0}]
[]
["4.3 Bauleistungsversicherung (Ermittlung vom Nettobetrag, Bruttoabzug)"]
["Bauleistungsversicherung",null,null,1.25E-3,{"$f":"ROUND(D46*E19,3)","v":0}]
[]
["5. Einbehalte",null,null,null,"Nettobetrag",null,"Mwst.satz",null,"Mwst.betrag",null,"Bruttobetrag"]
["Bürgschaften",null,null,null,null,null,0,null,null,null,0]
[]
["Sicherheitseinbehalt (BVB)",null,null,"Festbetrag",{"$f":"ROUND(K51-I51,3)","v":0},null,0.19,null,{"$f":"ROUND(K51/(100%+G51)*G51,3)","v":0},null,0]
["Gewährleistungseinbehalt",null,null,0,0,null,0.19,null,0,null,{"$f":"ROUND(D52*K19,3)","v":0}]
["<Art des Einbehalts>",null,null,"<Datum>",{"$f":"ROUND(K53-I53,3)","v":0},null,0.19,null,{"$f":"ROUND(K53/(100%+G53)*G53,3)","v":0},null,0]
["<Art des Einbehalts>",null,null,"<Datum>",0,null,0.19,null,0,null,0]
["Summe",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K51:L54)","v":0}]
[]
["6. Zahlungsanspruch",null,null,null,"Nettobetrag",null,"Mwst.satz",null,"Mwst.betrag",null,"Bruttobetrag"]
["Auftragssumme",null,null,null,{"$f":"E12","v":0}]
["geprüfte Rechnungssumme",null,null,null,{"$f":"E19","v":0}]
["Abzug Baumedien (siehe 4.1)",null,null,null,{"$f":"E37","v":0}]
["Abzug weitere Abzüge (siehe 4.2)",null,null,null,{"$f":"E43","v":0}]
["Zwischensumme",null,null,null,{"$f":"ROUND(E59-E60-E61,3)","v":0},null,0.19,null,{"$f":"ROUND(E62*G62,3)","v":0},null,{"$f":"ROUND(E62+I62,3)","v":0}]
["Abzug Bauleistungsversicherung (siehe 4.3)",null,null,null,null,null,null,null,null,null,{"$f":"E46","v":0}]
["Zwischensumme",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(K62-K63,3)","v":0}]
["Abzug geleistete Zahlungen (siehe 3.)",null,null,null,null,null,null,null,null,null,{"$f":"K31","v":0}]
["Rechnungsendbetrag (vor Abzug Einbehalte)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(K64-K65,3)","v":0}]
["Abzug Einbehalte (siehe 5.)",null,null,null,null,null,null,null,null,null,{"$f":"K55","v":0}]
["Auszahlungsbetrag",null,null,null,{"$f":"ROUND(K68-I68,3)","v":0},null,0.19,null,{"$f":"ROUND(K68/(100%+G68)*G68,3)","v":0},null,{"$f":"ROUND(K66-K67,3)","v":0}]
[]
["Bemerkungen"]
[]
["vom Planungsbüro geprüft                    \n\n\n      . . . . . . . . . . . . . . . . . . . . . . . . . . . .\nDatum / Unterschrift\n\n",null,null,null,"von der Projektsteuerung geprüft                    \n\n\n      . . . . . . . . . . . . . . . . . . . . . . . . . . . .\nDatum / Unterschrift\n\n",null,null,null,"vom Projektleiter/Fachingenieur freigegeben:                    \n\n\n      . . . . . . . . . . . . . . . . . . . . . . . . . . . .\nDatum / Unterschrift\n\n"]

{"sheet":"Freigabeblatt_TO","index":1,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,3,8,6],[25,0,25,10],[3,8,3,10],[10,4,10,10],[37,0,37,10],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[4,3,4,10],[5,3,5,10],[7,9,7,10],[8,9,8,10],[6,9,6,10],[6,3,6,6],[7,3,7,6],[2,0,2,2],[1,0,1,2],[0,0,0,2],[0,3,0,10],[1,3,1,10],[2,3,2,10],[9,0,9,10],[24,1,24,2],[54,0,57,3],[52,0,52,10],[54,4,57,10],[60,0,60,3],[60,4,60,5],[60,7,60,8],[26,1,26,2],[32,0,32,1],[51,2,51,3],[51,4,51,5],[51,6,51,7],[51,8,51,9],[59,0,59,3],[59,4,59,7],[59,8,59,10],[58,0,58,3],[58,4,58,5],[58,7,58,8]]}
["Projektauftraggeber:\n\n",null,null,{"$f":"Freigabeblatt!C1","v":"Landeshauptstadt Dresden I Amt für Hochbau und Immobilienverwaltung"}]
["Projekt:",null,null,{"$f":"Freigabeblatt!C2","v":"<Projektbezeichnung gemäß Projektauftrag>"}]
["Projektleitung:",null,null,{"$f":"Freigabeblatt!C3","v":"Amt für Hochbau und Immobilienverwaltung I <Name Projektleiter> I <Telefon>"}]
["Rechnungsbegleitblatt 2 | Gliederung nach TO",null,null,null,null,null,null,"Rechnungsart:"]
["Auftragnehmer:",null,null,{"$f":"Freigabeblatt!C5","v":"<Firma>"}]
["Gewerk/Los:",null,null,{"$f":"Freigabeblatt!C6","v":"<Gewerk/Los>"}]
["Auftragsnummer:",null,null,{"$f":"Freigabeblatt!C7","v":"<Auftragsnummer>"},null,null,null,"Auftragsdatum:",null,{"$f":"Freigabeblatt!I7","v":"<Auftragsdatum>"}]
["Rechnungsnummer:",null,null,{"$f":"Freigabeblatt!C8","v":"<Rechnungsnummer>"},null,null,null,"Rechnungsdatum:",null,{"$f":"Freigabeblatt!I8","v":"<Rechnungsdatum>"}]
["Rechnungseingang:",null,null,{"$f":"Freigabeblatt!C9","v":"<Datum>"},null,null,null,"Zahlungsziel:",null,{"$f":"Freigabeblatt!I9","v":"<Datum>"}]
[]
["KG/LV-Nr.","Titel","Titelsumme","Bezug","Aufteilung der AZ / SZ auf Teilobjekte (Basis: Auszahlungsbetrag brutto)"]
[null,null,null,null,"TO1 - Schul-gebäude","TO2 - Sporthalle","TO3 - Freianlage","TO4","TO5","TO6","Gesamt"]
[300,null,null,"Prozent*",0.5,0.5,0,0,0,0,{"$f":"SUM(E13:J13)","v":1}]
["1",null,0,null,{"$f":"$C14*E$13","v":0},{"$f":"$C14*F$13","v":0},0,0,0,0,{"$f":"SUM(E14:J14)","v":0}]
["2",null,0,null,0,0,0,0,0,0,{"$f":"SUM(E15:J15)","v":0}]
["3",null,0,null,0,0,0,0,0,0,0]
["4",null,0,null,0,0,0,0,0,0,0]
["5",null,0,null,0,0,0,0,0,0,0]
["6",null,0,null,0,0,0,0,0,0,0]
["7",null,0,null,0,0,0,0,0,0,0]
["1.NT",null,0,null,0,0,0,0,0,0,0]
["2.NT",null,0,null,0,0,0,0,0,0,0]
["3.NT",null,0,null,0,0,0,0,0,0,0]
["4.NT",null,0,null,0,0,0,0,0,0,0]
["SUMME",{"$f":"SUM(C14:C21)","v":0},null,null,{"$f":"SUM(E14:E21)","v":0},0,0,0,0,0,{"$f":"SUM(E25:J25)","v":0}]
[]
["Netto",{"$f":"B25","v":0},null,null,{"$f":"E25","v":0},0,0,0,0,0,{"$f":"K25","v":0}]
[null,"Nachlass",0,null,{"$f":"ROUND(-E27*$C28,3)","v":0},{"$f":"ROUND(-F27*$C28,3)","v":0},{"$f":"ROUND(-G27*$C28,3)","v":0},0,0,0,{"$f":"ROUND(-K27*$C28,3)","v":0}]
[null,"Zwischen-Summe","NETTO",null,{"$f":"E27+E28","v":0},{"$f":"F27+F28","v":0},0,0,0,0,{"$f":"K27+K28","v":0}]
[null,"Zwischen-Summe","BRUTTO",null,{"$f":"ROUND(E29*1.19,3)","v":0},{"$f":"ROUND(F29*1.19,3)","v":0},{"$f":"ROUND(G29*1.19,3)","v":0},0,0,0,{"$f":"ROUND(K29*1.19,3)","v":0}]
[null,"BE-Wasser",{"$f":"Freigabeblatt!D35","v":0},"v. NETTO",{"$f":"ROUND(-$C31*E$29,3)","v":0},{"$f":"ROUND(-$C31*F$29,3)","v":0},{"$f":"ROUND(-$C31*G$29,3)","v":0},0,0,0,{"$f":"ROUND(-$C31*K$29,3)","v":0}]
[null,"BE-Strom",{"$f":"Freigabeblatt!D36","v":0},"v. NETTO",{"$f":"ROUND(-$C32*E$29,3)","v":0},0,0,0,0,0,{"$f":"ROUND(-$C32*K$29,3)","v":0}]
["BLV",null,{"$f":"Freigabeblatt!D46","v":1.25E-3},"v. NETTO",0,0,0,0,0,0,{"$f":"ROUND(-$C33*K$29,3)","v":0}]
[]
[null,"Netto inkl. Baumedien",null,null,{"$f":"E29+E31+E32","v":0},{"$f":"F29+F31+F32","v":0},{"$f":"G29+G31+G32","v":0},{"$f":"H29+H31+H32","v":0},{"$f":"I29+I31+I32","v":0},0,{"$f":"K29+K31+K32","v":0}]
[null,"MwSt",0.19,null,{"$f":"ROUND(E$35*$C36,3)","v":0},{"$f":"ROUND(F$35*$C36,3)","v":0},0,0,0,0,{"$f":"ROUND(K$35*$C36,3)","v":0}]
[null,"Brutto inkl. Bauleistungsvers.",null,null,{"$f":"ROUND(SUM(E35:E36)+E33,3)","v":0},{"$f":"ROUND(SUM(F35:F36)+F33,3)","v":0},{"$f":"ROUND(SUM(G35:G36)+G33,3)","v":0},0,0,0,{"$f":"ROUND(SUM(K35:K36)+K33,3)","v":0}]
[]
[null,"Abzüge aus vorher. AZ"]
[null,"1. AZ",0,null,{"$f":"$C40*E$13","v":0},{"$f":"$C40*F$13","v":0},0,0,{"$f":"$C40*I$13","v":0},{"$f":"$C40*J$13","v":0},{"$f":"SUM(E40:J40)","v":0}]
[null,"2. AZ",0,null,0,0,0,0,0,0,{"$f":"SUM(E41:J41)","v":0}]
[null,"3. AZ",0,null,0,0,0,0,0,0,0]
[null,"4. AZ",0,null,0,0,0,0,0,0,0]
[null,"5. AZ",0,null,{"$f":"$C44*E$13","v":0},0,0,0,0,0,0]
[null,"6. AZ",0,null,0,0,0,0,0,0,0]
[null,"7. AZ",0,null,0,0,0,0,0,0,0]
[null,"8. AZ",0,null,0,0,0,0,0,0,{"$f":"SUM(E47:J47)","v":0}]
[null,null,null,null,0,0,0,0,0,0]
[null,"Summe",{"$f":"SUM(C40:C48)","v":0},null,{"$f":"SUM(E40:E48)","v":0},0,0,0,0,0,0]
[]
[null,"Brutto",null,null,{"$f":"ROUND(E37-E49,3)","v":0},0,0,0,0,0,0]
[]
["*Die Teilbeträge je Titel und Teilobjekt können als Prozentsatz (Zeile 13) oder als Festbetrag (Zeile 14 ff. in den Spalten E bis J) eingetragen werden"]
[]
["Bemerkungen"]
[]
[]
[]
[]
["vom Planungsbüro geprüft                    \n\n\n      . . . . . . . . . . . . . . . . . . . . . . . . .\nDatum / Unterschrift\n\n",null,null,null,"von der Projektsteuerung geprüft                    \n\n\n      . . . . . . . . . . . . . . . . . . . . . . . . . . . .\nDatum / Unterschrift\n\n",null,null,null,"vom Projektleiter/Fachingenieur freigegeben:                    \n\n\n      . . . . . . . . . . . . . . . . . . . . . . . . . . . .\nDatum / Unterschrift\n\n"]

{"sheet":"Abrechnung_Teilobjekte","index":2,"n_rows":98,"n_cols":13,"rows_kept":98,"cut":false,"hidden":false,"merged":[[97,0,103,1],[76,0,76,1],[72,10,72,11],[73,0,73,1],[73,2,73,3],[74,0,74,1],[74,2,74,3],[74,4,74,5],[74,6,74,7],[74,8,74,9],[74,10,74,11],[94,10,94,11],[76,2,76,3],[76,8,76,9],[76,10,76,11],[75,0,75,1],[75,2,75,3],[75,4,75,5],[75,6,75,7],[65,0,65,1],[45,0,45,1],[7,2,7,5],[7,6,7,7],[94,0,94,1],[94,2,94,3],[95,0,95,1],[60,2,60,3],[60,4,60,5],[60,6,60,7],[61,2,61,3],[61,4,61,5],[61,6,61,7],[62,2,62,3],[62,4,62,5],[62,6,62,7],[63,0,63,1],[63,2,63,3],[66,2,66,13],[67,2,67,13],[68,2,68,13],[42,0,42,1],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3],[71,2,71,3],[71,4,71,5],[71,6,71,7],[69,0,69,13],[45,2,45,3],[46,0,46,1],[46,2,46,3],[47,0,47,1],[47,2,47,3],[64,0,64,1],[64,2,64,3],[39,1,39,3],[41,2,41,3],[37,0,37,1],[37,2,37,3],[49,0,49,1],[49,2,49,3],[51,0,51,1],[51,2,51,3],[53,0,53,1],[53,2,53,3],[55,0,55,1],[55,2,55,3],[57,0,57,1],[57,2,57,3],[59,0,59,1],[95,10,95,11],[42,10,42,11],[43,4,43,5],[64,4,64,5],[64,6,64,7],[46,6,46,7],[46,8,46,9],[46,10,46,11],[43,6,43,7],[43,8,43,9],[43,10,43,11],[47,4,47,5],[65,10,65,11],[44,8,44,9],[44,10,44,11],[45,4,45,5],[45,6,45,7],[94,4,94,5],[94,6,94,7],[94,8,94,9],[45,8,45,9],[71,8,71,9],[72,4,72,5],[42,6,42,7],[42,8,42,9],[41,4,41,5],[41,6,41,7],[41,8,41,9],[39,4,39,5],[10,8,10,9],[10,10,10,11],[39,6,39,7],[39,8,39,9],[39,10,39,11],[11,8,11,9],[11,10,11,11],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[37,4,37,5],[37,6,37,7],[37,8,37,9],[17,10,17,11],[18,10,18,11],[14,4,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[26,8,26,9],[26,10,26,11],[18,8,18,9],[26,4,26,5],[26,6,26,7],[17,8,17,9],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[0,0,0,1],[1,0,1,1],[2,0,2,1],[6,2,6,5],[6,6,6,7],[4,0,4,1],[5,0,5,1],[0,2,0,13],[1,2,1,13],[2,2,2,13],[3,8,3,9],[4,2,4,13],[5,2,5,13],[6,8,6,13],[43,12,43,13],[44,12,44,13],[45,12,45,13],[46,12,46,13],[47,12,47,13],[64,12,64,13],[65,12,65,13],[18,4,18,5],[18,6,18,7],[27,4,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[45,10,45,11],[41,10,41,11],[46,4,46,5],[64,8,64,9],[64,10,64,11],[47,6,47,7],[47,8,47,9],[47,10,47,11],[44,4,44,5],[44,6,44,7],[42,4,42,5],[7,8,7,13],[8,8,8,13],[13,0,13,13],[40,0,40,13],[14,12,14,13],[17,12,17,13],[18,12,18,13],[26,12,26,13],[27,12,27,13],[26,2,26,3],[18,0,18,1],[18,2,18,3],[11,4,11,5],[11,6,11,7],[10,6,10,7],[26,0,26,1],[14,2,14,3],[8,2,8,5],[8,6,8,7],[27,2,27,3],[97,2,103,13],[10,12,10,13],[11,12,11,13],[71,12,71,13],[72,12,72,13],[73,12,73,13],[74,12,74,13],[94,12,94,13],[76,12,76,13],[95,12,95,13],[17,4,17,5],[17,6,17,7],[11,0,11,3],[10,0,10,2],[10,4,10,5],[27,0,27,1],[17,0,17,1],[17,2,17,3],[41,12,41,13],[42,12,42,13],[15,0,15,1],[16,0,16,1],[14,0,14,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[15,12,15,13],[16,2,16,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[15,2,15,3],[19,12,19,13],[20,2,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[21,2,21,3],[21,4,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[21,12,21,13],[19,2,19,3],[22,2,22,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[23,2,23,3],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[24,2,24,3],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[25,2,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[28,2,28,3],[28,4,28,5],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[29,2,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13],[30,2,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[30,10,30,11],[30,12,30,13],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[32,2,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,10,32,11],[32,12,32,13],[33,2,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[33,12,33,13],[34,2,34,3],[34,4,34,5],[34,6,34,7],[34,8,34,9],[34,10,34,11],[34,12,34,13],[35,2,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[35,10,35,11],[35,12,35,13],[36,2,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[36,10,36,11],[36,12,36,13],[37,12,37,13],[38,0,38,1],[38,10,38,11],[38,12,38,13],[37,10,37,11],[49,4,49,5],[49,6,49,7],[49,8,49,9],[49,10,49,11],[49,12,49,13],[50,0,50,1],[50,2,50,3],[50,4,50,5],[50,6,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,13],[51,4,51,5],[51,6,51,7],[51,8,51,9],[51,10,51,11],[51,12,51,13],[52,0,52,1],[52,2,52,3],[52,4,52,5],[52,6,52,7],[52,8,52,9],[52,10,52,11],[52,12,52,13],[53,4,53,5],[53,6,53,7],[53,8,53,9],[53,10,53,11],[53,12,53,13],[54,0,54,1],[54,2,54,3],[54,4,54,5],[54,6,54,7],[54,8,54,9],[54,10,54,11],[54,12,54,13],[55,4,55,5],[55,6,55,7],[55,8,55,9],[55,10,55,11],[55,12,55,13],[56,0,56,1],[56,2,56,3],[56,4,56,5],[56,6,56,7],[56,8,56,9],[56,10,56,11],[56,12,56,13],[57,4,57,5],[57,6,57,7],[57,8,57,9],[57,10,57,11],[57,12,57,13],[58,0,58,1],[58,2,58,3],[58,4,58,5],[58,6,58,7],[58,8,58,9],[58,10,58,11],[58,12,58,13],[59,10,59,11],[59,12,59,13],[60,0,60,1],[60,8,60,9],[60,10,60,11],[60,12,60,13],[61,0,61,1],[61,8,61,9],[61,10,61,11],[61,12,61,13],[62,0,62,1],[62,8,62,9],[62,10,62,11],[62,12,62,13],[63,4,63,5],[63,6,63,7],[63,8,63,9],[63,10,63,11],[63,12,63,13],[68,0,68,1],[72,0,72,1],[72,2,72,3],[72,6,72,7],[72,8,72,9],[66,0,66,1],[67,0,67,1],[76,6,76,7],[76,4,76,5],[75,12,75,13],[75,10,75,11],[75,8,75,9],[70,0,70,13],[73,4,73,5],[73,6,73,7],[73,8,73,9],[71,10,71,11],[73,10,73,11],[71,0,71,1],[77,0,77,1],[77,2,77,3],[77,4,77,5],[77,6,77,7],[77,8,77,9],[77,10,77,11],[77,12,77,13],[78,0,78,1],[78,2,78,3],[78,4,78,5],[78,6,78,7],[78,8,78,9],[78,10,78,11],[78,12,78,13],[79,0,79,1],[79,2,79,3],[79,4,79,5],[79,6,79,7],[79,8,79,9],[79,10,79,11],[79,12,79,13],[80,0,80,1],[80,2,80,3],[80,4,80,5],[80,6,80,7],[80,8,80,9],[80,10,80,11],[80,12,80,13],[81,0,81,1],[81,2,81,3],[81,4,81,5],[81,6,81,7],[81,8,81,9],[81,10,81,11],[81,12,81,13],[82,0,82,1],[82,2,82,3],[82,4,82,5],[82,6,82,7],[82,8,82,9],[82,10,82,11],[82,12,82,13],[83,0,83,1],[83,2,83,3],[83,4,83,5],[83,6,83,7],[83,8,83,9],[83,10,83,11],[83,12,83,13],[84,0,84,1],[84,2,84,3],[84,4,84,5],[84,6,84,7],[84,8,84,9],[84,10,84,11],[84,12,84,13],[85,0,85,1],[85,2,85,3],[85,4,85,5],[85,6,85,7],[85,8,85,9],[85,10,85,11],[85,12,85,13],[86,0,86,1],[86,2,86,3],[86,4,86,5],[86,6,86,7],[86,8,86,9],[86,10,86,11],[86,12,86,13],[87,0,87,1],[87,2,87,3],[87,4,87,5],[87,6,87,7],[87,8,87,9],[87,10,87,11],[87,12,87,13],[88,0,88,1],[88,2,88,3],[88,4,88,5],[88,6,88,7],[88,8,88,9],[88,10,88,11],[88,12,88,13],[89,0,89,1],[89,2,89,3],[89,4,89,5],[89,6,89,7],[89,8,89,9],[89,10,89,11],[89,12,89,13],[90,0,90,1],[90,2,90,3],[90,4,90,5],[90,6,90,7],[90,8,90,9],[90,10,90,11],[90,12,90,13],[91,0,91,1],[91,2,91,3],[91,4,91,5],[91,6,91,7],[91,8,91,9],[91,10,91,11],[91,12,91,13],[92,0,92,1],[92,2,92,3],[92,4,92,5],[92,6,92,7],[92,8,92,9],[92,10,92,11],[92,12,92,13],[93,0,93,1],[93,2,93,3],[93,4,93,5],[93,6,93,7],[93,8,93,9],[93,10,93,11],[93,12,93,13],[3,0,3,7],[41,0,41,1],[48,0,48,1],[48,2,48,3],[48,4,48,5],[48,6,48,7],[48,8,48,9],[48,10,48,11],[48,12,48,13],[59,2,59,3],[59,4,59,5],[59,6,59,7],[59,8,59,9]]}
["Projektauftraggeber:\n\n",null,{"$f":"Freigabeblatt!C1","v":"Landeshauptstadt Dresden I Amt für Hochbau und Immobilienverwaltung"}]
["Projekt:",null,{"$f":"Freigabeblatt!C2","v":"<Projektbezeichnung gemäß Projektauftrag>"}]
["Projektleitung:",null,{"$f":"Freigabeblatt!C3","v":"Amt für Hochbau und Immobilienverwaltung I <Name Projektleiter> I <Telefon>"}]
["Rechnungsbegleitblatt - Aufteilung in Teilobjekte",null,null,null,null,null,null,null,"Rechnungsart:"]
["Auftragnehmer:",null,{"$f":"Freigabeblatt!C5","v":"<Firma>"}]
["Gewerk/Los:",null,{"$f":"Freigabeblatt!C6","v":"<Gewerk/Los>"}]
["Auftragsnummer:",null,{"$f":"Freigabeblatt!C7","v":"<Auftragsnummer>"},null,null,null,"Auftragsdatum:",null,{"$f":"Freigabeblatt!I7","v":"<Auftragsdatum>"}]
["Rechnungsnummer:",null,{"$f":"Freigabeblatt!C8","v":"<Rechnungsnummer>"},null,null,null,"Rechnungsdatum:",null,{"$f":"Freigabeblatt!I8","v":"<Rechnungsdatum>"}]
["Rechnungseingang:",null,{"$f":"Freigabeblatt!C9","v":"<Datum>"},null,null,null,"Zahlungsziel:",null,{"$f":"Freigabeblatt!I9","v":"<Datum>"}]
[]
[null,null,null,null,null,null," Nettobetrag",null,"MWst.satz",null,"MWst.betrag",null,"Bruttobetrag"]
["Rechnungsendbetrag",null,null,null,null,null,{"$f":"ROUND(M12-K12,3)","v":0},null,0.19,null,{"$f":"ROUND(M12/(100%+I12)*I12,3)","v":0},null,{"$f":"Freigabeblatt!K66","v":0}]
[]
["Aufteilung der Abschlagszahlung auf Teilobjekte"]
["KGR",null,"TO1",null,"TO2",null,"TO3",null,"TO4",null,"TO5",null,"TO6"]
[210,null,0,null,0,null,0,null,0,null,0,null,0]
[230,null,0,null,0,null,0,null,0,null,0,null,0]
["310-360",null,0,null,0,null,0,null,0,null,0,null,0]
[370,null,0,null,0,null,0,null,0,null,0,null,0]
[390,null,0,null,0,null,0,null,0,null,0,null,0]
[410,null,0,null,0,null,0,null,0,null,0,null,0]
[420,null,0,null,0,null,0,null,0,null,0,null,0]
[430,null,0,null,0,null,0,null,0,null,0,null,0]
[440,null,0,null,0,null,0,null,0,null,0,null,0]
[450,null,0,null,0,null,0,null,0,null,0,null,0]
[460,null,0,null,0,null,0,null,0,null,0,null,0]
[470,null,0,null,0,null,0,null,0,null,0,null,0]
[480,null,0,null,0,null,0,null,0,null,0,null,0]
[490,null,0,null,0,null,0,null,0,null,0,null,0]
[510,null,0,null,0,null,0,null,0,null,0,null,0]
[520,null,0,null,0,null,0,null,0,null,0,null,0]
[530,null,0,null,0,null,0,null,0,null,0,null,0]
[540,null,0,null,0,null,0,null,0,null,0,null,0]
[550,null,0,null,0,null,0,null,0,null,0,null,0]
[590,null,0,null,0,null,0,null,0,null,0,null,0]
[610,null,0,null,0,null,0,null,0,null,0,null,0]
[620,null,0,null,0,null,0,null,0,null,0,null,0]
["Summe je TO",null,{"$f":"SUM(C16:D37)","v":0},null,{"$f":"SUM(E16:F37)","v":0},null,{"$f":"SUM(G16:H37)","v":0},null,{"$f":"SUM(I16:J37)","v":0},null,{"$f":"SUM(K16:L37)","v":0},null,{"$f":"SUM(M16:N37)","v":0}]
["Summe gesamt",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C38:N38)","v":0}]
[]
["Aufteilung der bereits geleisteten Zahlungen (Zahlungsstand) auf Teilobjekte"]
["KGR",null,"TO1",null,"TO2",null,"TO3",null,"TO4",null,"TO5",null,"TO6"]
[210,null,0,null,0,null,0,null,0,null,0,null,0]
[230,null,0,null,0,null,0,null,0,null,0,null,0]
["310-360",null,0,null,0,null,0,null,0,null,0,null,0]
[370,null,0,null,0,null,0,null,0,null,0,null,0]
[390,null,0,null,0,null,0,null,0,null,0,null,0]
[410,null,0,null,0,null,0,null,0,null,0,null,0]
[420,null,0,null,0,null,0,null,0,null,0,null,0]
[430,null,0,null,0,null,0,null,0,null,0,null,0]
[440,null,0,null,0,null,0,null,0,null,0,null,0]
[450,null,0,null,0,null,0,null,0,null,0,null,0]
[460,null,0,null,0,null,0,null,0,null,0,null,0]
[470,null,0,null,0,null,0,null,0,null,0,null,0]
[480,null,0,null,0,null,0,null,0,null,0,null,0]
[490,null,0,null,0,null,0,null,0,null,0,null,0]
[510,null,0,null,0,null,0,null,0,null,0,null,0]
[520,null,0,null,0,null,0,null,0,null,0,null,0]
[530,null,0,null,0,null,0,null,0,null,0,null,0]
[540,null,0,null,0,null,0,null,0,null,0,null,0]
[550,null,0,null,0,null,0,null,0,null,0,null,0]
[590,null,0,null,0,null,0,null,0,null,0,null,0]
[610,null,0,null,0,null,0,null,0,null,0,null,0]
[620,null,0,null,0,null,0,null,0,null,0,null,0]
["Summe je TO",null,{"$f":"SUM(C43:D60)+SUM(C61:D64)","v":0},null,{"$f":"SUM(E43:F60)+SUM(E61:F64)","v":0},null,{"$f":"SUM(G43:H60)+SUM(G61:H64)","v":0},null,{"$f":"SUM(I43:J60)+SUM(I61:J64)","v":0},null,{"$f":"SUM(K43:L60)+SUM(K61:L64)","v":0},null,{"$f":"SUM(M43:N60)+SUM(M61:N64)","v":0}]
["Summe gesamt",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C65:N65)","v":0}]
["Projektauftraggeber:\n\n",null,{"$f":"Freigabeblatt!C1","v":"Landeshauptstadt Dresden I Amt für Hochbau und Immobilienverwaltung"}]
["Projekt:",null,{"$f":"Freigabeblatt!C2","v":"<Projektbezeichnung gemäß Projektauftrag>"}]
["Projektleitung:",null,{"$f":"Freigabeblatt!C3","v":"Amt für Hochbau und Immobilienverwaltung I <Name Projektleiter> I <Telefon>"}]
["Rechnungsbegleitblatt - Aufteilung in Teilobjekte"]
["Summe aller Zahlungen (Zahlungsstand) auf Teilobjekte"]
["KGR",null,"TO1",null,"TO2",null,"TO3",null,"TO4",null,"TO5",null,"TO6"]
[210,null,0,null,0,null,0,null,0,null,0,null,0]
[230,null,0,null,0,null,0,null,0,null,0,null,0]
["310-360",null,0,null,0,null,0,null,0,null,0,null,0]
[370,null,0,null,0,null,0,null,0,null,0,null,0]
[390,null,0,null,0,null,0,null,0,null,0,null,0]
[410,null,0,null,0,null,0,null,0,null,0,null,0]
[420,null,0,null,0,null,0,null,0,null,0,null,0]
[430,null,0,null,0,null,0,null,0,null,0,null,0]
[440,null,0,null,0,null,0,null,0,null,0,null,0]
[450,null,0,null,0,null,0,null,0,null,0,null,0]
[460,null,0,null,0,null,0,null,0,null,0,null,0]
[470,null,0,null,0,null,0,null,0,null,0,null,0]
[480,null,0,null,0,null,0,null,0,null,0,null,0]
[490,null,0,null,0,null,0,null,0,null,0,null,0]
[510,null,0,null,0,null,0,null,0,null,0,null,0]
[520,null,0,null,0,null,0,null,0,null,0,null,0]
[530,null,0,null,0,null,0,null,0,null,0,null,0]
[540,null,0,null,0,null,0,null,0,null,0,null,0]
[550,null,0,null,0,null,0,null,0,null,0,null,0]
[590,null,0,null,0,null,0,null,0,null,0,null,0]
[610,null,0,null,0,null,0,null,0,null,0,null,0]
[620,null,0,null,0,null,0,null,0,null,0,null,0]
["Summe je TO",null,{"$f":"SUM(C73:D94)","v":0},null,{"$f":"SUM(E73:F94)","v":0},null,{"$f":"SUM(G73:H94)","v":0},null,{"$f":"SUM(I73:J94)","v":0},null,{"$f":"SUM(K73:L94)","v":0},null,{"$f":"SUM(M73:N94)","v":0}]
["Summe gesamt",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C95:N95)","v":0}]
[]
["Bemerkungen"]

{"sheet":"Hilfstext","index":3,"n_rows":38,"n_cols":1,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
["1. Abschlagszahlung"]
["2. Abschlagszahlung"]
["3. Abschlagszahlung"]
["4. Abschlagszahlung"]
["5. Abschlagszahlung"]
["6. Abschlagszahlung"]
["7. Abschlagszahlung"]
["8. Abschlagszahlung"]
["9. Abschlagszahlung"]
["10. Abschlagszahlung"]
["11. Abschlagszahlung"]
["12. Abschlagszahlung"]
["13. Abschlagszahlung"]
["14. Abschlagszahlung"]
["15. Abschlagszahlung"]
["16. Abschlagszahlung"]
["17. Abschlagszahlung"]
["18. Abschlagszahlung"]
["19. Abschlagszahlung"]
["20. Abschlagszahlung"]
["21. Abschlagszahlung"]
["22. Abschlagszahlung"]
["23. Abschlagszahlung"]
["24. Abschlagszahlung"]
["25. Abschlagszahlung"]
["26. Abschlagszahlung"]
["27. Abschlagszahlung"]
["28. Abschlagszahlung"]
["29. Abschlagszahlung"]
["30. Abschlagszahlung"]
["31. Abschlagszahlung"]
["32. Abschlagszahlung"]
["33. Abschlagszahlung"]
["34. Abschlagszahlung"]
["35. Abschlagszahlung"]
["Schlussrechnung"]
["Einzelrechnung"]