{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["0_Erlaeuterungen","1_Eingabe_Grunddaten","2_Eingabe_Vertragsgrundlagen","3_Eingabe_Nachtragsofferten","4_Eingabe_Rechnungen","5_Eingabe_Variable_MwSt","6_Eingabe_Buergschaften","7_Ausdruck_Nachtragsofferte","8_Ausdruck_Abschlagszahlung","9_Ausdruck_Garantieschein","10_Stammdaten"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":332,"comments":1,"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":"0_Erlaeuterungen","index":0,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,3,1,16],[2,3,2,16]]}
[null,null,"Das Makro dieses Programmes kann nicht gestartet werden, da Ihre Makrosicherheit dies nicht zulässt."]
[null,null,"Bitte wählen Sie die Excel-Optionen aus und stellen Sie im Sicherheitscenter (od. Vertrauensstellungscenter) die Einstellungen der Makros auf 'alle Makros mit Benachrichtigung deaktivieren'. (Falls Sie damit Probleme haben, kontaktieren Sie Ihren EDV-Verantwortlichen)","Herzlich Willkommen zur App der \nKostenkontrolle \ndes Kantons St.Gallen"]
[null,null,"Anschliessend starten Sie die Datei neu und bei Nachfrage bestätigen Sie, dass Sie das Makro starten möchten.","Um das Programm starten zu können drücken Sie bitte folgenden Button:\n(je nach Vorkommen)"]
[]
[null,null,null,"entweder:",null,null,null,null,null,null,null,null,"und anschliessend:"]
[]
[]
[]
[]
[]
[]
[null,null,null,"oder:"]

{"sheet":"1_Eingabe_Grunddaten","index":1,"n_rows":60,"n_cols":6,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Eingabe vorhanden?"]
["Eingabeformular",null,null,"nein"]
[]
["Rubrik",null,null,"Bemerkung"]
["Formulargrundlagen"]
[]
["Auswählen: Budgetverwantworliche Stelle"]
[]
["Objektdaten"]
["Projektnummer"]
["Gemeinde / Objekt / Baulos"]
["Art der Arbeit oder Lieferung"]
["Schweiz. Hauptstrasse(n) Nr."]
["Kantonsstrasse(n) Nr."]
["Gemeinde(n) Nr."]
["Bauabschnitt Nr."]
["RMS-Stationierung km         von","von"]
[null,"bis"]
[" "]
[]
["Vertragsgrundlagen"]
["Angebot vom",null,null,"Datum"]
["Werk-/Ingenieurvertrag vom",null,null,"Datum"]
[]
["RRB/AS-Nr. (Regierungsratsbeschluss / Auftragsschreiben)",null,null,"Nummer"]
["RRB/AS vom",null,null,"Datum"]
["RRB/AS Betrag",null,null,"Fr."]
["Kreditreserve",null,null,"Nummer"]
[]
["Konditionen"]
["Konditionen (Zahlungsfrist in Tagen)",null,null,"Tage"]
["Rabatt",null,null,"Prozent"]
["Garantierückbehalt",null,null,"Prozent"]
["Skonto",null,null,"Prozent"]
["Zahlungsfrist Skonto",null,null,"Tage"]
["MwSt",null,7.7,"Prozent",2.5,0]
["MwSt var. Gem. Beilage ",null,null,"Fr."]
[]
["Angaben zum Unternehmer"]
["Firma"]
["Firmenname Adressfirma"]
["Strasse"]
["PLZ Ort"]
["MwSt. Nr."]
[]
["Angaben zur örtlichen Bauleitung"]
["Örtliche Bauleitung /INGE"]
["Örtliche Bauleitung Adressfirma "]
["Strasse"]
["PLZ Ort"]
[]
["Oberbauleitung"]
["Abteilung oder Sektion oder Fachstelle"]
["Sachbearbeiter"]
[]
["Bankverbindung"]
["Zahlbar an:"]
["Adresse"]
["Postkonto / ESR-Nr."]
["IBAN"]

{"sheet":"2_Eingabe_Vertragsgrundlagen","index":2,"n_rows":19,"n_cols":30,"rows_kept":19,"cut":false,"hidden":true,"merged":[[3,7,3,8],[4,2,4,4]]}
[]
[null,"Vertragsgrundlagen",null,null,null,null,7,8,9,null,11,null,13,null,null,null,17,18,19,null,null,22]
[null,null,null,null,1,null,5,6,7,null,9,null,11,null,13,14,null,null,null,18,19]
[null,null,null,null,null,null,null,"Vergabe",null,null,"Alle Nachtrags-\nofferten",null,"Vertrag (Vergabe + \nNachtragsofferte(n))"]
["Auswahl","BKA","Leistung",null,null,"MwSt-Satz","Eingabe Vergabe Brutto","Brutto","Netto",null,"Netto",null,"Netto",null,"Index","Zeile Nr.","Rang Vergabe","Netto Vor Korrektur","Vergleich Vergabe","Auftragszugehörigkeit","mit Abzügen","Brutto Neu für Rangberechnung","MwSt. Betrag\nohne NK, ZT, Teu","MwSt. Betrag\nnur Nebenkosten","MwSt. Betrag\nnur Zeittarif","MwSt. Betrag\nnur Teuerung","Mwst. Betrag nur Nebenkosten mit Abzug","Mwst. Betrag nur Zeittarif mit Abzug",null,"Netto ohne MwSt."]
[null,null,null,null,null,null,null,null,{"$f":"IF(P6=\"\",0,IF(P6=S6,R6+c_RundungskorrekturVergabe,R6))","v":0},null,{"$f":"'3_Eingabe_Nachtragsofferten'!U12","v":0},null,{"$f":"I6+K6","v":0},null,null,1,{"$f":"IF(H6=\"\",\"\",RANK(V6,r_VertragRangBruttoNeu,0))","v":""},{"$f":"IF(G6=0,0,IF(U6=\"Ja\",IF(T6=5,ROUND((AD6+AB6)/5,2)*5,IF(T6=6,ROUND((AD6+AA6)/5,2)*5,ROUND((AD6+W6)/5,2)*5)),IF(T6=5,ROUND((AD6+Y6)/5,2)*5,IF(T6=6,ROUND((AD6+X6)/5,2)*5,ROUND((AD6+Z6)/5,2)*5))))","v":0},{"$f":"IF(r_RangVergabe=\"\",\"\",MATCH(1,r_RangVergabe,0))","v":""},null,null,{"$f":"IF(G6<0,G6-2*G6,G6)","v":0},{"$f":"IF(AND($U6=\"Ja\",OR($T6=1,$T6=2,$T6=4)),IF($F6<>\"\",$AD6*(IF($F6=1,c_VertragMwst1,IF($F6=2,c_VertragMwst2,c_VertragMwst3)))/100,0),0)","v":0},{"$f":"IF(AND($T6=6,$U6=\"Nein\"),$AD6*(IF($F6=1,c_VertragMwst1,IF($F6=2,c_VertragMwst2,c_VertragMwst3)))/100,0)","v":0},{"$f":"IF(AND($T6=5,$U6=\"Nein\"),$AD6*(IF($F6=1,c_VertragMwst1,IF($F6=2,c_VertragMwst2,c_VertragMwst3)))/100,0)","v":0},{"$f":"IF(AND(OR($T6=3,$T6=7),$U6=\"Nein\"),$AD6*(IF($F6=1,c_VertragMwst1,IF($F6=2,c_VertragMwst2,c_VertragMwst3)))/100,0)","v":0},{"$f":"IF(AND($T6=6,$U6=\"Ja\"),$AD6*(IF($F6=1,c_VertragMwst1,IF($F6=2,c_VerMwst2,c_VertragMwst3)))/100,0)","v":0},{"$f":"IF(AND($T6=5,$U6=\"Ja\"),$AD6*(IF($F6=1,c_VertragMwst1,IF($F6=2,c_VertragMwst2,c_VertragMwst3)))/100,0)","v":0},null,{"$f":"IF($G6=0,0,IF($U6=\"Ja\",$G6*$R$13,$G6))","v":0}]
[null,null,null,null,null,null,null,null,0,null,{"$f":"'3_Eingabe_Nachtragsofferten'!U13","v":0},null,0,null,null,null,"",0,"",null,null,0,0,0,0,0,{"$f":"IF(AND($T7=6,$U7=\"Ja\"),$AD7*(IF($F7=1,c_VertragMwst1,IF($F7=2,c_VerMwst2,c_VertragMwst3)))/100,0)","v":0},0,null,{"$f":"IF($G7=0,0,IF($U7=\"Ja\",$G7*$R$13,$G7))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(r_VertragRangBruttoNeu)","v":0},{"$f":"SUM(r_VBetragMwstOhne)","v":0},{"$f":"SUM(r_VBetragMwst6)","v":0},{"$f":"SUM(r_VBetragMwst5)","v":0},{"$f":"SUM(r_VBetragMwst3)","v":0},{"$f":"SUM(r_VBetragMwst6mit)","v":0},{"$f":"SUM(r_VBetragMwst5mit)","v":0},null,{"$f":"SUM(r_VNettoohneMwst)","v":0}]
["Zwischentotal 1",null,null,null,null,null,{"$f":"SUM(r_GrundvertragBruttoEingabe)","v":0},{"$f":"SUM(r_GrundvertragBrutto)","v":0},{"$f":"SUM(r_GrundvertragNettoMitKorrektur)","v":0},null,{"$f":"SUM(r_ZusammenzugAllerNachtragsoffertenNetto)","v":0},null,{"$f":"SUM(r_VertragNetto)","v":0},null,null,{"$f":"c_SummeGrundvertragBrutto","v":0},null,{"$f":"SUM(r_GrundvertragNettoVorKorrektur)","v":0}]
["Rabatt",null,"-",{"$f":"'1_Eingabe_Grunddaten'!C32","v":0},"%",null,null,{"$f":"-ROUND((c_SummeGrundvertragBrutto*'1_Eingabe_Grunddaten'!C32/100)/5,2)*5","v":0},null,null,null,null,null,null,null,{"$f":"(c_SummeGrundvertragBrutto*'1_Eingabe_Grunddaten'!C32/100)*-1","v":0},null,null,null,null,null,null,1,2,3,4,5,6]
["Zwischentotal 2",null,null,null,null,null,null,{"$f":"SUM(H10:H11)","v":0},"ohne Nebenkosten ",null,"nur",null,"nur",null,"nur",{"$f":"P10+P11","v":0},null,"Faktor Netto/Brutto",null,null,null,null,{"$f":"IF(W9=0,\"\",RANK(W9,r_VertragRangTotal,0))","v":""},"","","","","",null,{"$f":"MATCH(1,r_RangVertragTotal,0)","v":{"$error":"#N/A"}}]
["Nebenkosten",null,null,null,{"$f":"COUNTIF(r_VertragMwst,1)","v":0},{"$f":"'1_Eingabe_Grunddaten'!C36","v":7.7},"Mwst 1",0,"Zeittarif, Teuerung",null,"Nebenkosten",null,"Zeittarif",null,"Teuerung","nur Nebenkosten","nur Zeittarif",{"$f":"P12/P10","v":{"$error":"#DIV/0!"}}]
["Zeittarif",null,null,null,{"$f":"COUNTIF(r_VertragMwst,2)","v":0},{"$f":"'1_Eingabe_Grunddaten'!E36","v":2.5},"Mwst 2",0,null,null,null,null,null,null,null,"mit Abzug","mit Abzug"]
["Teuerung",null,null,null,{"$f":"COUNTIF(r_VertragMwst,3)","v":0},{"$f":"'1_Eingabe_Grunddaten'!F36","v":0},"Mwst 3",0,0,null,null,null,null,null,null,0,0]
["Zwischentotal 3",null,null,null,null,{"$f":"SUM(E13:E15)","v":0},null,{"$f":"SUM(H12:H15)","v":0},{"$f":"IF(I15=0,0,I15*c_SummeGrundvertragMinusRabatt/c_SummeGrundvertragBrutto)","v":0},null,{"$f":"H13","v":0},null,{"$f":"H14","v":0},null,{"$f":"H15","v":0},{"$f":"IF(P15=0,0,P15*c_SummeGrundvertragMinusRabatt/c_SummeGrundvertragBrutto)","v":0},{"$f":"IF(Q15=0,0,Q15*c_SummeGrundvertragMinusRabatt/c_SummeGrundvertragBrutto)","v":0}]
["MwSt",null,"+",{"$f":"IF(AND(c_VertragMwst1Summe>0,c_VertragMwst2Summe>0,c_VertragMwst3Summe>0),TEXT(c_VertragMwst1,\"0.0\")&\" / \"&TEXT(c_VertragMwst2,\"0.0\")&\" / \"&TEXT(c_VertragMwst3,\"0.0\"),IF(AND(c_VertragMwst1Summe>0,c_VertragMwst2Summe>0),TEXT(c_VertragMwst1,\"0.0\")&\" / \"&TEXT(c_VertragMwst2,\"0.0\"),IF(AND(c_VertragMwst2Summe>0,c_VertragMwst3Summe>0),TEXT(c_VertragMwst2,\"0.0\")&\" / \"&TEXT(c_VertragMwst3,\"0.0\"),IF(AND(c_VertragMwst1Summe>0,c_VertragMwst3Summe>0),TEXT(c_VertragMwst1,\"0.0\")&\" / \"&TEXT(c_VertragMwst3,\"0.0\"),IF(c_VertragMwst1Summe>0,TEXT(c_VertragMwst1,\"0.0\"),IF(c_VertragMwst2Summe>0,TEXT(c_VertragMwst2,\"0.0\"),IF(c_VertragMwst3Summe>0,TEXT(c_VertragMwst3,\"0.0\"),\"0.0\")))))))","v":"0.0"},"%",null,null,{"$f":"ROUND(($I17+$K17+$M17+$O17+$P17+$Q17)/5,2)*5","v":0},{"$f":"$W9","v":0},null,{"$f":"$X9","v":0},null,{"$f":"$Y9","v":0},null,{"$f":"$Z9","v":0},{"$f":"$AA9","v":0},{"$f":"$AB9","v":0},"Rundungskorrektur Vergabe"]
["Manuelle Rundung",null,null,null,null,null,null,0]
["Gesamttotal (Netto)",null,null,null,null,null,null,{"$f":"SUM(H16:H18)","v":0},{"$f":"SUM(I16:I17)","v":0},null,{"$f":"SUM(K16:K17)","v":0},null,{"$f":"SUM(M16:M17)","v":0},null,{"$f":"SUM(O16:O17)","v":0},{"$f":"SUM(P16:P17)","v":0},{"$f":"SUM(Q16:Q17)","v":0},{"$f":"c_SummeGrundvertragNetto-c_SummeGrundvertragNettoVorKorrektur","v":0}]

{"sheet":"3_Eingabe_Nachtragsofferten","index":3,"n_rows":32,"n_cols":49,"rows_kept":32,"cut":false,"hidden":true,"merged":[[9,46,10,46],[9,47,10,47],[9,48,10,48],[8,7,8,12],[8,14,8,18],[8,29,8,32],[8,34,8,37],[8,40,8,44],[9,45,10,45]]}
[]
[null,"Nachtragsofferte(n)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ja"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vergleich Zeile","Vergleich Spalte"]
[null,null,"1",2,3,4,5,6,7,8,9,10,11,null,13,14,15,16,17,null,19,null,21,null,23,24,25,null,null,{"$f":"SMALL(IF(r_NachOffRang=1,ROW(r_NachOffRang)),ROW(A1))-11","v":{"$error":"#NUM!"}},{"$f":"SMALL(IF(INDEX(r_NachOffRangErsatz,AD7):INDEX(r_NachOffRangMehrMinder,AD7)=1,COLUMN(AD:AG)),COUNTIF($AD$7:AD7,AD7))","v":{"$error":"#NUM!"}},null,{"$f":"MAX(AI13:AL13)","v":0}]
[null,null,null,null,null,null,null,null,null,"Eigene Nummerierung:"]
[null,null,null,null,null,null,null,"Brutto",null,null,null,null,null,null,"Netto",null,null,null,null,null,"Alle Nachtragsofferten",null,"Vertrag (Vergabe + Nachtragsofferte(n)",null,null,null,null,null,null,"Rang Nachtragsofferte",null,null,null,null,"Absolutwerte zur Rangbestimmung Brutto",null,null,null,null,null,"NachOff Netto vor Korrektur"]
[null,null,null,null,null,null,null,"Ersatz","Ersetzt","Zusatz","Mehr-/Minderausmass","Eingabe Nachtrag Brutto Total","Total",null,"Ersatz","Ersetzt","Zusatz","Mehr-/Minderausmass","Total",null,"Netto",null,"Netto",null,null,null,null,null,null,"Ersatz","Ersetzt","Zusatz","Mehr-/Minderausmass",null,"Ersatz","Ersetzt","Zusatz","Mehr-/Minderausmass","Total",null,"Ersatz","Ersetzt","Zusatz","Mehr-/Minderausmass","Total","MwSt. Betrag\nohne NK, ZT, Teu","MwSt. Betrag\nnur Nebenkosten","MwSt. Betrag\nnur Zeittarif","MwSt. Betrag\nnur Teuerung"]
["Auswahl","BKA","Leistung",null,null,null,"Mwst-Satz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Index ","Auftragszugehörigkeit","mit Abzug","Zeile Nr."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H12:K12)","v":0},null,null,{"$f":"IF($AD12=\"\",0,IF(AND($AD$7=$AB12,$AE$7=30),AO12+c_RundungskorrekturNachtragsofferte,AO12))","v":0},{"$f":"IF($AE12=\"\",0,IF(AND($AD$7=$AB12,$AE$7=31),AP12+c_RundungskorrekturNachtragsofferte,AP12))","v":0},{"$f":"IF($AF12=\"\",0,IF(AND($AD$7=$AB12,$AE$7=32),AQ12+c_RundungskorrekturNachtragsofferte,AQ12))","v":0},{"$f":"IF($AG12=\"\",0,IF(AND($AD$7=$AB12,$AE$7=33),AR12+c_RundungskorrekturNachtragsofferte,AR12))","v":0},{"$f":"SUM(O12:R12)","v":0},null,0,null,{"$f":"'2_Eingabe_Vertragsgrundlagen'!M6","v":0},null,null,null,null,1,null,{"$f":"IF(AI12=0,\"\",IF(AI12=0,0,RANK(AI12,$AI12:$AL12)))","v":""},{"$f":"IF(AJ12=0,\"\",IF(AJ12=0,0,RANK(AJ12,$AI12:$AL12)))","v":""},{"$f":"IF(AK12=0,\"\",IF(AK12=0,0,RANK(AK12,$AI12:$AL12)))","v":""},{"$f":"IF(AL12=0,\"\",IF(AL12=0,0,RANK(AL12,$AI12:$AL12)))","v":""},null,{"$f":"IF(ABS(H12)=\"\",\"\",ABS(H12))","v":0},{"$f":"IF(ABS(I12)=\"\",\"\",ABS(I12))","v":0},{"$f":"IF(ABS(J12)=\"\",\"\",ABS(J12))","v":0},{"$f":"IF(ABS(K12)=\"\",\"\",ABS(K12))","v":0},{"$f":"SUM(AI12:AL12)","v":0},null,{"$f":"IF(H12=0,0,IF(AND($Z12=5,$AA12=\"Nein\"),ROUND(H12*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5,IF(AND($Z12=6,$AA12=\"Nein\"), ROUND(H12*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5,IF(AND(OR($Z12=3,$Z12=7),$AA12=\"Nein\"), ROUND(H12*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5, ROUND(H12*c_NachtragFaktorRabatt*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5))))","v":0},{"$f":"IF(I12=0,0,IF(AND($Z12=5,$AA12=\"Nein\"),ROUND(I12*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5,IF(AND($Z12=6,$AA12=\"Nein\"), ROUND(I12*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5,IF(AND(OR($Z12=3,$Z12=7),$AA12=\"Nein\"), ROUND(I12*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5, ROUND(I12*c_NachtragFaktorRabatt*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5))))","v":0},{"$f":"IF(J12=0,0,IF(AND($Z12=5,$AA12=\"Nein\"),ROUND(J12*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5,IF(AND($Z12=6,$AA12=\"Nein\"), ROUND(J12*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5,IF(AND(OR($Z12=3,$Z12=7),$AA12=\"Nein\"), ROUND(J12*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5, ROUND(J12*c_NachtragFaktorRabatt*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5))))","v":0},{"$f":"IF(K12=0,0,IF(AND($Z12=5,$AA12=\"Nein\"),ROUND(K12*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5,IF(AND($Z12=6,$AA12=\"Nein\"), ROUND(K12*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5,IF(AND(OR($Z12=3,$Z12=7),$AA12=\"Nein\"), ROUND(K12*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5, ROUND(K12*c_NachtragFaktorRabatt*(1+(IF($G12=1,c_NachtragMwst1,IF($G12=2,c_NachtragMwst2,c_NachtragMwst3))/100))/5,2)*5))))","v":0},{"$f":"SUM(AO12:AR12)","v":0},{"$f":"IF(AA12=\"Ja\",IF(G12<>\"\",c_NachtragFaktorRabatt*M12*(IF(G12=1,c_NachtragMwst1,IF(G12=2,c_NachtragMwst2,c_NachtragMwst3)))/100,0),0)","v":0},{"$f":"IF(AND(Z12=6,AA12=\"Nein\"),L12*(IF(G12=1,c_NachtragMwst1,IF(G12=2,c_NachtragMwst2,c_NachtragMwst3)))/100,0)","v":0},{"$f":"IF(AND(Z12=5,AA12=\"Nein\"),L12*(IF(G12=1,c_NachtragMwst1,IF(G12=2,c_NachtragMwst2,c_NachtragMwst3)))/100,0)","v":0},{"$f":"IF(AND(OR(Z12=3,Z12=7),AA12=\"Nein\"),L12*(IF(G12=1,c_NachtragMwst1,IF(G12=2,c_NachtragMwst2,c_NachtragMwst3)))/100,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,null,0,null,{"$f":"'2_Eingabe_Vertragsgrundlagen'!M7","v":0},null,null,null,null,null,null,"","","","",null,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Zwischentotal 1",null,null,null,null,null,{"$f":"SUM(r_NachOffErsatzBrutto)","v":0},{"$f":"SUM(r_NachOffErsetztBrutto)","v":0},{"$f":"SUM(r_NachOffZusatzBrutto)","v":0},{"$f":"SUM(r_NachOffMehrMinderBrutto)","v":0},{"$f":"SUM(r_NachOffTotalBrutto)","v":0},{"$f":"SUM(r_NachtragTotalAbzug)","v":0},null,{"$f":"SUM(r_NachOffErsatzNettoMitKorrektur)","v":0},{"$f":"SUM(r_NachOffErsetztNettoMitKorrektur)","v":0},{"$f":"SUM(r_NachOffZusatzNettoMitKorrektur)","v":0},{"$f":"SUM(r_NachOffMehrMinderNettoMitKorrektur)","v":0},{"$f":"SUM(r_NachOffTotalNettoMitKorrektur)","v":0},null,{"$f":"SUM(r_NachOffTotalALLEproZeile)","v":0},null,{"$f":"SUM(r_NachtragTotalVertrag)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(r_NachOffNettoVorKorrektur)","v":0},{"$f":"SUM(r_NachtragMwstO3567)","v":0},{"$f":"SUM(r_NachtragMwst6)","v":0},{"$f":"SUM(r_NachtragMwst5)","v":0},{"$f":"SUM(r_NachtragMwst37)","v":0}]
[null,"Rabatt",null,"-",{"$f":"'1_Eingabe_Grunddaten'!C32","v":0},"%",{"$f":"1-(E17/100)","v":1},"Faktor Rabatt",null,null,null,null,{"$f":"-ROUND((c_SummeNachOffBrutto*'1_Eingabe_Grunddaten'!C32/100)/5,2)*5","v":0}]
[null,"Zwischentotal 2",null,null,null,null,8,"Mwst1",null,null,null,null,{"$f":"SUM(M16:M17)","v":0},null,"ohne","nur","nur","nur"]
[null,"Zeittarif",null,null,null,null,0,"Mwst2",null,null,null,null,0,null,"Nebenkosten","Nebenkosten","Zeittarif","Teuerung",null,null,null,null,null,null,"Faktor"]
[null,"Nebenkosten",null,null,null,null,0,"Mwst3",null,null,null,null,0,null,"Zeittarif",null,null,null,null,null,null,null,null,null,{"$f":"IF(c_SummeNachOffBrutto=0,1,(c_SummeNachOffMinusRabatt/c_SummeNachOffBrutto))","v":1}]
[null,"Teuerung",null,null,null,null,null,null,null,null,null,null,0,null,"Teuerung"]
[null,"Zwischentotal 3",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M18:M21)","v":0},null,{"$f":"c_SummeNachOffMinusRabatt","v":0},{"$f":"c_NachtragNebenkosten","v":0},{"$f":"c_NachtragZeittarif","v":0},{"$f":"c_NachtragTeuerung","v":0}]
[null,"MwSt",null,"+",7.7,"%",null,null,null,null,null,null,{"$f":"IF('2_Eingabe_Vertragsgrundlagen'!F16>1,ROUND((O23+P23+Q23+R23)/5,2)*5,IF('2_Eingabe_Vertragsgrundlagen'!F16>0,ROUND(c_NachtragZwischentotal3*c_NachtragMwSt/100/5,2)*5,0))","v":0},null,{"$f":"ROUND(AT16/5,2)*5","v":0},{"$f":"ROUND(AU16/5,2)*5","v":0},{"$f":"ROUND(AV16/5,2)*5","v":0},{"$f":"ROUND(AW16/5,2)*5","v":0}]
[null,"Manuelle Rundung",null,null,null,"Fr.",null,null,null,null,null,null,0]
[null,"Gesamttotal (Netto)",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M22:M24)","v":0},null,{"$f":"SUM(O22:O23)","v":0},{"$f":"SUM(P22:P23)","v":0},{"$f":"SUM(Q22:Q23)","v":0},{"$f":"SUM(R22:R23)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rundungskorrektur-Nachtragsofferte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"c_SummeNachtragsofferteNetto-c_SummeNachOffNettoVorKorrektur","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,"Alle Nachtragsofferten",null,"Vertrag (Vergabe + Nachtragsofferte(n)",null,"Total Netto aller Nachtragsofferten OHNE Neue"]
["Nr.","BKA  1","Leistung  2",null,null,"Eigene Nr.  5","Mwst-Satz 6","Ersatz  7","Ersetzt  8","Zusatz  9","Ausmass 10","Total 11","Total  12",null,"Ersatz  14","Ersetzt  15","Zusatz  16","Ausmass  17","Total  18",null,"Netto  20",null,"Netto 22",null,"Netto 24","Auftragszugehörigkeit \n25","mit Abzug \n26","Begründung  \n27",null,null,null,"Index  \n31","Datum  \n32",null,"Rabatt  \n34","Manuelle Rundung  \n35","Zwischentotal  \n36","MwSt  \n37",null,"Gesamttotal Netto  \n39","Nebenkosten \n40","Zeittarif \n41","Teuerung \n42","Zwischentotal3\n43",null,"MwSt-Satz\n45","Leistungsjahr\n46"]

{"sheet":"4_Eingabe_Rechnungen","index":4,"n_rows":41,"n_cols":82,"rows_kept":41,"cut":false,"hidden":true,"merged":[[39,76,39,81],[9,45,10,45],[9,43,10,43],[9,44,10,44],[9,41,10,41],[9,42,10,42],[9,52,10,52],[9,47,10,47],[9,48,10,48],[9,49,10,49],[9,50,10,50],[9,51,10,51],[9,32,10,32],[9,33,10,33],[9,39,10,39],[9,40,10,40],[9,38,10,38],[9,34,10,34],[9,35,10,35],[9,36,10,36],[40,2,40,4],[9,9,9,10],[9,12,9,13],[9,15,9,16],[9,31,10,31]]}
[]
[null,"Rechnung(en)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Akkord = 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regie = 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Teuerung = 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kostentarif = 4"]
[null,null,null,null,null,null,null,null,null,null,"Eigene Nummerierung:",null,null,null,null,"Schlussrechnung",null,null,null,null,"Zeittarif = 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ja",null,null,null,null,"Nebenkosten = 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aus Ablage eintragen",null,"berechnet","aus Ablage eintragen",null,"berechnet","berechnet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Teuerung = 7",null,null,null,null,null,"AA12",null,null,"berechnet"]
[null,null,null,null,null,null,null,null,null,"Teilleistung",null,null,"Abgerechnete Leistung Gesamt",null,null,"Bis und mit AZ 0 abgerechnete Leistungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vergleich","MwSt. Betrag\nohne NK, ZT, Teu","MwSt. Betrag\nnur Nebenkosten","MwSt. Betrag\nnur Zeittarif","MwSt. Betrag\nnur Teuerung","MwSt. Betrag nur Nebenkosten mit Abzug","MwSt. Betrag nur Zeittarif mit Abzug",null,"Betrag Garantierückbehalt n-1 \n37","Betrag Garantierückbehalt\nn\n38","Korrektur Schlussrechnung\nGarantierückbehalt\n39","Betrag Auszahlung Garantierückbehalt\nn-1\n40","Betrag Auszahlung Garantierückbehalt\nn\n41","Korrektur Schlussrechnung Auszahlung Garantierückbehalt\n42","Variable Mwst\n43","Garantierückbehalt inkl. Mwst.\n44",null,"Rundung Betrag\nohne NK, ZT, Teu\n46","Rundung Betrag\nnur Nebenkosten\n47","Rundung Betrag\nnur Zeittarif\n48","Rundung Betrag\nnur Teuerung\n49","Rundung Betrag nur Nebenkosten mit Abzug\n50","Rundung Betrag nur Zeittarif mit Abzug\n51"]
["Auswahl","BKA 0","Leistung 1",null,null,null,"Mwst-Satz",null,null,"8 Brutto","9 Netto",null,"11 Brutto","12 Netto",null,"14 Brutto","15 Netto",null,"Index 17","Rundungskorrektur bisher 18","Auftragszugehörigkeit 19","Brutto Neu für Rangberechnung 20","Netto Neu ohne Mwst","mit Abzügen 22","Zeile Nr. 23",null,"Rang Rechnung 25","Rundungskorrektur Rechnung 26","Netto vor Korrektur 27","Variable Mwst.\n28",{"$f":"IF(INDIRECT(AA9)=\"\",\"\",MATCH(1,r_RangRechnung,0))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"H12","v":0},{"$f":"ROUND(SUM(N12-Q12)/5,2)*5","v":0},null,null,{"$f":"IF(c_RechnungSchlussrechnung=\"Ja\",IF(Y12=c_VergleichRechnung,ROUND(($AC12+c_RundungskorrekturRechnung+$T12)/5,2)*5,ROUND(($AC12+$T12)/5,2)*5),IF(Y12=c_VergleichRechnung,ROUND(($AC12+c_RundungskorrekturRechnung+$T12)/5,2)*5,ROUND(($AC12+$T12)/5,2)*5))","v":0},null,null,null,null,null,null,null,{"$f":"IF((H12)<0,(H12)*-1,(H12))","v":0},{"$f":"IF(AND(J12=0,P12=0),0,IF(X12=\"Ja\",(((P12+J12)*(100-c_RechnungRabattProzent)/100)-AN12+AQ12)*(100-c_RechnungSkontoProzent)/100,P12+J12))","v":0},null,1,null,{"$f":"IF(AND(V12=0,H12=\"\"),\"\",RANK(V12,r_RechnungRangBruttoNeu,0))","v":""},{"$f":"IF(c_RechnungSchlussrechnung=\"Ja\",IF(Y12=c_VergleichRechnung,c_RundungskorrekturRechnung+T12,0),IF(Y12=c_VergleichRechnung,c_RundungskorrekturRechnung,0))","v":0},{"$f":"IF(AND(J12=0,P12=0),0,IF(X12=\"Ja\",IF(U12=5,ROUND((W12+AK12+AS12)/5,2)*5,IF(U12=6,ROUND((W12+AJ12+AS12)/5,2)*5,ROUND((W12+AF12+AS12)/5,2)*5)),IF(U12=5,ROUND((W12+AH12+AS12)/5,2)*5,IF(U12=6,ROUND((W12+AG12+AS12)/5,2)*5,ROUND((W12+AI12+AS12)/5,2)*5))))","v":0},{"$f":"IF(c_RechnungSchlussrechnung=\"Nein\",ROUND(AS12/5,2)*5,IF(X12=\"Nein\",ROUND(AS12/5,2)*5,ROUND((AS12+AO12-AR12)/5,2)*5))","v":0},null,{"$f":"IF(AND($X12=\"Ja\",OR($U12=1,$U12=2,$U12=4)),IF($G12<>\"\",$W12*(IF($G12=1,c_RechnungMwst1,IF($G12=2,c_RechnungMwst2,c_RechnungMwst3)))/100,0),0)","v":0},{"$f":"IF(AND($U12=6,$X12=\"Nein\"),W12*(IF($G12=1,c_RechnungMwst1,IF($G12=2,c_RechnungMwst2,c_RechnungMwst3)))/100,0)","v":0},{"$f":"IF(AND($U12=5,$X12=\"Nein\"),W12*(IF($G12=1,c_RechnungMwst1,IF($G12=2,c_RechnungMwst2,c_RechnungMwst3)))/100,0)","v":0},{"$f":"IF(AND(OR($U12=3,$U12=7),$X12=\"Nein\"),W12*(IF($G12=1,c_RechnungMwst1,IF($G12=2,c_RechnungMwst2,c_RechnungMwst3)))/100,0)","v":0},{"$f":"IF(AND($U12=6,$X12=\"Ja\"),W12*(IF($G12=1,c_RechnungMwst1,IF($G12=2,c_RechnungMwst2,c_RechnungMwst3)))/100,0)","v":0},{"$f":"IF(AND($U12=5,$X12=\"Ja\"),W12*(IF($G12=1,c_RechnungMwst1,IF($G12=2,c_RechnungMwst2,c_RechnungMwst3)))/100,0)","v":0},null,0,{"$f":"IF(c_ProduktRechnungGarantierueckbehaltProzent+c_ProduktRechnungGarantierueckbehaltSIA+c_RechnungenManuelleRundungGarantierueckbehalt=0,0,IF(X12=\"Nein\",0,IF($G12<>\"\",(c_ProduktRechnungGarantierueckbehaltProzent+c_ProduktRechnungGarantierueckbehaltSIA+c_RechnungenManuelleRundungGarantierueckbehalt)/c_SummeRechnungGesamtBrutto*$M12*(-1),0)))","v":0},0,0,{"$f":"IF(c_RechnungenAuszahlungGarantierueckbehalt=0,0,IF(X12=\"Nein\",0,IF($G12<>\"\",IF($H$16=0,AP12+(c_RechnungenNeuAuszGrantie/$AN$16*AN12),AP12+(c_RechnungenNeuAuszGrantie/$AN$16*AN12)),0)))","v":0},0,0,{"$f":"IF(G12=1,((AN12-AQ12)*(100+c_RechnungMwst1)/100)+AO12-AR12,IF(G12=2,((AN12-AQ12)*(100+c_RechnungMwst2)/100)+AO12-AR12,((AN12-AQ12)*(100+c_RechnungMwst3)/100)+AO12-AR12))","v":0},null,{"$f":"IF(c_RechnungRundungsdifferenz-$T$35<>0,IF(AND($X12=\"Ja\",OR($U12=1,$U12=2,$U12=4),$Y12=c_VergleichRechnung),c_RechnungRundungsdifferenz-$T$35,0),0)","v":0},{"$f":"IF(c_RechnungRundungsdifferenz-$T$35<>0,IF(AND($U12=6,$X12=\"Nein\",$Y12=c_VergleichRechnung),c_RechnungRundungsdifferenz-$T$35,0),0)","v":0},{"$f":"IF(c_RechnungRundungsdifferenz-$T$35<>0,IF(AND($U12=5,$X12=\"Nein\",Y12=c_VergleichRechnung),c_RechnungRundungsdifferenz-$T$35,0),0)","v":0},{"$f":"IF(c_RechnungRundungsdifferenz-$T$35<>0,IF(AND(OR($U12=3,$U12=7),$X12=\"Nein\",Y12=c_VergleichRechnung),c_RechnungRundungsdifferenz-$T$35,0),0)","v":0},{"$f":"IF(c_RechnungRundungsdifferenz-$T$35<>0,IF(AND($U12=6,$X12=\"Ja\",Y12=c_VergleichRechnung),c_RechnungRundungsdifferenz-$T$35,0),0)","v":0},{"$f":"IF(c_RechnungRundungsdifferenz-$T$35<>0,IF(AND($U12=5,$X12=\"Ja\",Y12=c_VergleichRechnung),c_RechnungRundungsdifferenz-$T$35,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,null,null,null,null,null,null,0,0,null,null,null,"",0,0,0,null,0,0,0,0,0,0,null,null,0,null,null,{"$f":"IF(c_RechnungenAuszahlungGarantierueckbehalt=0,0,IF(X13=\"Nein\",0,IF($G13<>\"\",IF($H$16=0,AP13+(c_RechnungenNeuAuszGrantie/$AN$16*AN13),AP13+(c_RechnungenNeuAuszGrantie/$AN$16*AN13)),0)))","v":0},null,null,0,null,{"$f":"IF(c_RechnungRundungsdifferenz-$T$35<>0,IF(AND($X13=\"Ja\",OR($U13=1,$U13=2,$U13=4),$Y13=c_VergleichRechnung),c_RechnungRundungsdifferenz-$T$35,0),0)","v":0},{"$f":"IF(c_RechnungRundungsdifferenz-$T$35<>0,IF(AND($U13=6,$X13=\"Nein\",$Y13=c_VergleichRechnung),c_RechnungRundungsdifferenz-$T$35,0),0)","v":0},{"$f":"IF(c_RechnungRundungsdifferenz-$T$35<>0,IF(AND($U13=5,$X13=\"Nein\",Y13=c_VergleichRechnung),c_RechnungRundungsdifferenz-$T$35,0),0)","v":0},{"$f":"IF(c_RechnungRundungsdifferenz-$T$35<>0,IF(AND(OR($U13=3,$U13=7),$X13=\"Nein\",Y13=c_VergleichRechnung),c_RechnungRundungsdifferenz-$T$35,0),0)","v":0},{"$f":"IF(c_RechnungRundungsdifferenz-$T$35<>0,IF(AND($U13=6,$X13=\"Ja\",Y13=c_VergleichRechnung),c_RechnungRundungsdifferenz-$T$35,0),0)","v":0},{"$f":"IF(c_RechnungRundungsdifferenz-$T$35<>0,IF(AND($U13=5,$X13=\"Ja\",Y13=c_VergleichRechnung),c_RechnungRundungsdifferenz-$T$35,0),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(r_RechnungRundungBisher)","v":0}]
[null,"Abgerechnete Leistungen",null,null,null,null,null,{"$f":"SUMIF(r_RechnungBisherEingabe56,\"Ja\",r_RechnungBruttoEingaben)","v":0},null,{"$f":"SUM(r_RechnungNeuBrutto)","v":0},{"$f":"SUM(r_RechnungNeuNetto)","v":0},null,{"$f":"SUM(r_RechnungGesamtBrutto)","v":0},{"$f":"SUM(r_RechnungGesamtNetto)","v":0},null,{"$f":"SUM(r_RechnungBisherigeBrutto)","v":0},{"$f":"SUM(r_RechnungBisherigeNetto)","v":0},null,null,{"$f":"SUM(r_RechnungGesamtBrutto)","v":0},null,{"$f":"SUM(r_RechnungRangBruttoNeu)","v":0},{"$f":"SUM(r_RechnungNettoNeuOhneMwst)","v":0},null,null,null,null,{"$f":"SUM(AB12:AB13)","v":0},{"$f":"SUM(r_RechnungNettoVorKorrektur)+T15","v":0},{"$f":"SUM(r_RechnungVarMwst)","v":0},null,{"$f":"SUM(r_RechnungMwstOhne3567)","v":0},{"$f":"SUM(r_RechnungMwstOhne6)","v":0},{"$f":"SUM(r_RechnungMwstOhne5)","v":0},{"$f":"SUM(r_RechnungMwstOhne37)","v":0},{"$f":"SUM(r_RechnungMwstMit6)","v":0},{"$f":"SUM(r_RechnungMwstMit5)","v":0},null,{"$f":"SUM(AM12:AM13)","v":0},0,0,0,0,0,0,{"$f":"ROUND(SUM(AT12:AT13)/5,2)*5","v":0},null,{"$f":"SUM(AV12:AV13)","v":0},0,0,0,0,0]
[null,"Rabatt","-",{"$f":"'1_Eingabe_Grunddaten'!C32","v":0},null,null,null,null,null,null,null,null,{"$f":"-ROUND((c_SummeRechnungGesamtBrutto*'1_Eingabe_Grunddaten'!C32/100)/5,2)*5","v":0},null,null,null,null,null,null,{"$f":"(c_SummeRechnungGesamtBrutto*'1_Eingabe_Grunddaten'!C32/100)*-1","v":0}]
[null,"Manuelle Rundung Rabatt",null,null,"Fr.",null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"c_RechnungenManuelleRundungRabatt","v":0}]
[null,"Subtotal 1",null,null,null,null,7.7,"Mwst1",null,null,null,null,{"$f":"c_SummeRechnungGesamtBrutto+c_ProduktRabattRechnung+c_RechnungenManuelleRundungRabatt","v":0},null,null,null,null,null,null,{"$f":"SUM(T16:T18)","v":0},null,null,{"$f":"IF(AND(J19=0,P19=0),0,IF(X19=\"Ja\",IF(U19=5,(ROUND((P19*c_RechnungFaktorNetto+c_RechnungVarMwStZeittarifMAbzug+J19*c_RechnungFaktorNetto)/5,2)*5),IF(U19=6,(ROUND((P19*c_RechnungFaktorNetto*+c_RechnungVarMwStNebenkostenMAbzug+J19*c_RechnungFaktorNetto)/5,2)*5),(ROUND((P19*c_RechnungFaktorNetto+AD19+J19*c_RechnungFaktorNetto)/5,2)*5))),IF(U19=5,(ROUND((P19+c_RechnungVarMwStZeittarif+J19)/5,2)*5),IF(U19=6,(ROUND((P19+c_RechnungVarMwStNebenkosten+J19)/5,2)*5),IF(OR(U19=3,U19=7),(ROUND((P19+c_RechnungVarMwStTeuerung+J19)/5,2)*5))))))","v":0},null,null,null,null,null,null,null,null,1,2,3,4,5,6,"Spalten Nr.","Vergleich"]
[null,"Garantierückbehalt","-",{"$f":"IF(c_RechnungSchlussrechnung = \"Nein\",IF(c_GarantierueckbehaltProzentODERsia=\"FALSCH\",'1_Eingabe_Grunddaten'!C33,0),0)","v":0},"%",null,0,"Mwst2",null,null,null,null,{"$f":"IF(P8=\"Nein\",IF(c_GarantierueckbehaltProzentODERsia=\"FALSCH\",-ROUND(c_SummeRechnungMinusRabattSUBTOTAL1*'1_Eingabe_Grunddaten'!C33/100*20,0)/20,0),0)","v":0},null,null,null,null,null,null,{"$f":"IF(P8=\"Nein\",IF(c_GarantierueckbehaltProzentODERsia=\"FALSCH\",-c_SummeRechnungMinusRabattSUBTOTAL1*'1_Eingabe_Grunddaten'!C33/100,0),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF16=0,\"\",RANK(AF16,r_RechnungRangTotal,0))","v":""},"","","","","","Rang Rechnung Total",{"$f":"MATCH(1,r_RangRechnungTotal,0)","v":{"$error":"#N/A"}}]
[null,"Garantierückbehalt nach SIA",null,{"$f":"IF(c_RechnungSchlussrechnung=\"Nein\",IF(c_GarantierueckbehaltProzentODERsia=\"WAHR\",-c_ProduktRechnungGarantierueckbehaltSIA/c_SummeRechnungMinusRabattSUBTOTAL1*100,IF(c_GarantierueckbehaltProzentODERsia=\"WAHRneu\",-c_ProduktRechnungGarantierueckbehaltSIA/c_SummeRechnungMinusRabattSUBTOTAL1*100,0)),0)","v":0},"%",null,0,"Mwst3",null,null,null,null,{"$f":"IF(P8=\"Nein\",IF(c_GarantierueckbehaltProzentODERsia=\"WAHR\",IF(c_SummeRechnungMinusRabattSUBTOTAL1<=300000,-ROUND(c_SummeRechnungMinusRabattSUBTOTAL1*10/100/5,2)*5,IF(AND(c_SummeRechnungMinusRabattSUBTOTAL1>300000,c_SummeRechnungMinusRabattSUBTOTAL1<=600000),-30000,IF(AND(c_SummeRechnungMinusRabattSUBTOTAL1>600000,c_SummeRechnungMinusRabattSUBTOTAL1<=20000000),-ROUND(c_SummeRechnungMinusRabattSUBTOTAL1*5/100/5,2)*5,-1000000))),IF(c_GarantierueckbehaltProzentODERsia=\"WAHRneu\",IF(c_SummeRechnungMinusRabattSUBTOTAL1<=500000,-ROUND(c_SummeRechnungMinusRabattSUBTOTAL1*10/100/5,2)*5,IF(AND(c_SummeRechnungMinusRabattSUBTOTAL1>500000,c_SummeRechnungMinusRabattSUBTOTAL1<=1000000),-50000,IF(AND(c_SummeRechnungMinusRabattSUBTOTAL1>1000000,c_SummeRechnungMinusRabattSUBTOTAL1<=40000000),-ROUND(c_SummeRechnungMinusRabattSUBTOTAL1*5/100/5,2)*5,-2000000))),0)),0)","v":0},null,null,null,null,null,null,{"$f":"IF(P8=\"Nein\",IF(c_GarantierueckbehaltProzentODERsia=\"WAHR\",IF(c_SummeRechnungMinusRabattSUBTOTAL1<=300000,-ROUND(c_SummeRechnungMinusRabattSUBTOTAL1*10/100/5,2)*5,IF(AND(c_SummeRechnungMinusRabattSUBTOTAL1>300000,c_SummeRechnungMinusRabattSUBTOTAL1<=600000),-30000,IF(AND(c_SummeRechnungMinusRabattSUBTOTAL1>600000,c_SummeRechnungMinusRabattSUBTOTAL1<=20000000),-c_SummeRechnungMinusRabattSUBTOTAL1*5/100,-1000000))),IF(c_GarantierueckbehaltProzentODERsia=\"WAHRneu\",IF(c_SummeRechnungMinusRabattSUBTOTAL1<=500000,-c_SummeRechnungMinusRabattSUBTOTAL1*10/100,IF(AND(c_SummeRechnungMinusRabattSUBTOTAL1>500000,c_SummeRechnungMinusRabattSUBTOTAL1<=1000000),-50000,IF(AND(c_SummeRechnungMinusRabattSUBTOTAL1>1000000,c_SummeRechnungMinusRabattSUBTOTAL1<=40000000),-c_SummeRechnungMinusRabattSUBTOTAL1*5/100,-2000000))),0)),0)","v":0}]
[null,"Manuelle Rundung Garantierückbehalt",null,null,null,null,null,null,null,null,null,null,0,null,null,null,"Subtotal3 / Abgerech. Leistung",null,null,{"$f":"c_RechnungenManuelleRundungGarantierueckbehalt","v":0}]
[null,"Auszahlung Garantierückbehalt",null,null,null,null,null,null,null,null,null,null,0,0,null,"Neu",{"$f":"T28/T16","v":{"$error":"#DIV/0!"}},null,null,{"$f":"c_RechnungenAuszahlungGarantierueckbehalt","v":0}]
[null,"Garantierückbehalt Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M20:M23)","v":0},null,null,null,null,null,null,{"$f":"SUM(T20:T23)","v":0}]
[null,"Subtotal 2",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(c_SummeRechnungMinusRabattSUBTOTAL1,c_SummeRechnungGarantierueckbehaltTotal)","v":0},null,null,null,null,null,null,{"$f":"T19+T24","v":0}]
[null,"Skonto","-",{"$f":"'1_Eingabe_Grunddaten'!C34","v":0},"%",null,null,null,null,"Brutto","Brutto",null,{"$f":"-ROUND((c_SummeRechnungSUBTOTAL2*'1_Eingabe_Grunddaten'!C34/100)/5,2)*5","v":0},"Brutto",null,null,null,null,null,{"$f":"-(c_SummeRechnungSUBTOTAL2*'1_Eingabe_Grunddaten'!C34/100)","v":0}]
[null,"Manuelle Rundung Skonto",null,null,null,null,null,null,null,0,0,null,0,0,null,null,null,null,null,{"$f":"c_RechnungenManuelleRundungSkonto","v":0}]
[null,"Subtotal 3",null,null,null,null,null,null,null,"nur","nur",null,{"$f":"SUM(c_SummeRechnungSUBTOTAL2,c_ProduktRechnungSkonto,c_RechnungenManuelleRundungSkonto)","v":0},"ohne",null,"nur","nur",null,"nur",{"$f":"T25+T26+T27","v":0}]
[null,"Nebenkosten",null,null,null,null,null,null,null,"Nebenkosten","Zeittarif",null,0,"Nebenkosten",null,"Nebenkosten","Zeittarif",null,"Teuerung"]
[null,"Zeittarif",null,null,null,null,null,null,null,"mit Abzug","mit Abzug",null,0,"Zeittarif",null,"ohne Abzug","ohne Abzug",null,"ohne Abzug"]
[null,"Teuerung",null,null,null,null,null,null,null,null,null,null,0,"Teuerung"]
[null,"Subtotal 4",null,null,null,null,null,null,null,{"$f":"IF(J27=0,0,J27*c_SummeRechnungSUBTOTAL3/c_SummeRechnungGesamtBrutto)","v":0},{"$f":"IF(K27=0,0,K27*c_SummeRechnungSUBTOTAL3/c_SummeRechnungGesamtBrutto)","v":0},null,{"$f":"c_SummeRechnungSUBTOTAL3+c_RechnungNebenkosten+c_RechnungZusatzleistungen+c_RechnungTeuerung","v":0},{"$f":"IF(N27=0,0,N27*c_SummeRechnungSUBTOTAL3/c_SummeRechnungGesamtBrutto)","v":0},null,{"$f":"c_RechnungNebenkosten","v":0},{"$f":"SUM(c_RechnungZusatzleistungen)","v":0},null,{"$f":"SUM(c_RechnungTeuerung)","v":0}]
[null,"MwSt","+",7.7,"%",{"$f":"1+(c_RechnungMwStProzent/100)","v":1.077},null,null,null,{"$f":"ROUND(AJ16/5,2)*5","v":0},{"$f":"ROUND(AK16/5,2)*5","v":0},null,{"$f":"IF('2_Eingabe_Vertragsgrundlagen'!F16>1,ROUND((N33+P33+Q33+S33+J33+K33)/5,2)*5,IF('2_Eingabe_Vertragsgrundlagen'!F16>0,ROUND(c_SummeRechnungSUBTOTAL4*c_RechnungMwStProzent/100/5,2)*5,0))","v":0},{"$f":"ROUND(AF16/5,2)*5","v":0},null,{"$f":"ROUND(AG16/5,2)*5","v":0},{"$f":"ROUND(AH16/5,2)*5","v":0},null,{"$f":"ROUND(AI16/5,2)*5","v":0}]
[null,"Variable MwSt",null,null,null,null,null,null,null,0,0,null,{"$f":"c_RechnungSummeVarMwst","v":0},0,null,0,0,null,0,"Rundungsdifferenz bisher"]
[null,"Rundungsdifferenz",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0]
[null,"Subtotal 54",null,null,null,null,null,null,null,{"$f":"SUM(J32:J35)","v":0},{"$f":"SUM(K32:K35)","v":0},null,{"$f":"SUM(M32:M35)","v":0},{"$f":"SUM(N32:N35)","v":0},null,{"$f":"SUM(P32:P35)","v":0},{"$f":"SUM(Q32:Q35)","v":0},null,{"$f":"SUM(S32:S35)","v":0}]
[null,"AZ (inkl. MwSt)",null,null,null,null,null,null,null,null,null,null,{"$f":"c_RechnungBisherigeNetto","v":0},{"$f":"IF(N27=0,0,c_SummeRechnungSUBTOTAL5ohne56/N27)","v":0},null,"Berechnungsfaktor normal"]
[null,"Total Anweisungsbetrag",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(c_SummeRechnungSUBTOTAL5,-c_RechnungBisherigeNetto)","v":0},{"$f":"IF(N27=0,0,(c_SummeRechnungSUBTOTAL5ohne56-N34)/N27)","v":0},null,"Berechnungsfaktor var MwSt",null,null,"Rundungskorrektur Rechnung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(c_RechnungBruttoohne56=0,c_SummeRechnungSUBTOTAL5ohne56=0),0,c_SummeRechnungSUBTOTAL5ohne56/c_RechnungBruttoohne56)","v":0},null,"Berechnungsfaktor total",null,null,{"$f":"c_SummeRechnungSUBTOTAL5-c_SummeRechnungNettoVorKorrektur","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rundungsdifferenz Total"]
["Nr.","BKA  1","Leistung  2",null,null,"Eigene Nummer  5","Mwst-Satz 6","Eingabe der abgerechneten Leistungen Brutto",null,"Abgerechnete Leistung Neu Bruto  9","Abgerechnete Leistung Neu Netto  10",null,"Gesamte abgerechnete Leistung Brutto  12","Gesamte abgerechnete Leistung Netto 13",null,"Bis und mit letzte AZ abgerechnete Leitung Brutto  15","Bis und mit letzte AZ abgerechnete Leistung Netto  16",null,"Rechnungsnummer  18","Index  19","Auftragszugehörigkeit  20","Rechnungsdatum  21","Rundungskorrektur 22","Rabatt  23","Manuelle Rundung Rabatt  24","Subtotal 1  25","Garantierückbehalt  26","Garantierückbehalt nach SIA  27","Manuelle Rundung Garantierückbehalt  28","Total Garantierückbehalt  29","Subtotal 2  30","Skonto  31","Subtotal 3  32","MwSt  33","Variable MwSt  Total 34","Subtotal 4  35","AZ (inkl. MwSt.)  36","Total Anweisungsbetrag  37","Schlussrechnung  38","Rundungsdifferenz  39","Nebenkosten  40","Zeittarif  41","Subtotal 5  42","mit Abzügen  43","Art Leistung Alle oder Neue  44","Garantierückbehalt nach SIA %  45","Teuerung 46","Auszahlung Garantie  47","Subtotal 5 ohne 5-6 \n48","Subtotal 5 nur 6\nohne Abzug\n49","Subtotal 5\nnur 5\n50","Subtotal 5\nnur 3-7\n51","Subtotal 5 nur 6\nmit Abzug\n52","Subtotal 5 nur 5\nmit Abzug\n53","Berechnungsfaktor normal\n54","Berechnungsfaktor var\n55","Subtotal 4 nur 5\nmit Abzug\n56","Subtotal 4 nur 6\nmit Abzug\n57","Subtotal 4 ohne  5 6\nmit Abzug\n58","Subtotal 4 nur 5\nohne Abzug\n59","Subtotal 4 nur 6\nohne Abzug\n60","Subtotal 4 nur 7\nohne Abzug\n61","Berechnungsfaktor Total\n62","Manuelle Rundung Skonto  63","Faktor Sub4\n64","Netto ohne Mwst\n65","Variable Mwst\n66","Mwst %\n67","Leistungsjahr\n68","Betrag Garantierückbehalt n-1 \n69","Betrag Garantierückbehalt\nn\n70","Korrektur Schlussrechnung\nGarantierückbehalt\n71","Betrag Auszahlung Garantierückbehalt\nn-1\n72","Betrag Auszahlung Garantierückbehalt\nn\n73","Korrektur Schlussrechnung Auszahlung Garantierückbehalt\n74","Garantierückbehalt inkl. Mwst\n75","Rundung Betrag\nohne NK, ZT, Teu\n76","Rundung Betrag\nnur Nebenkosten\n77","Rundung Betrag\nnur Zeittarif\n78","Rundung Betrag\nnur Teuerung\n79","Rundung Betrag nur Nebenkosten mit Abzug\n80","Rundung Betrag nur Zeittarif mit Abzug\n81"]

{"sheet":"5_Eingabe_Variable_MwSt","index":5,"n_rows":49,"n_cols":16,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Mehrwertsteuer-Sätze",null,null,null,null,"Korrekturbetrag MwSt-Wechsel"]
[]
[]
[]
["MwSt.-Satz","Gültig von","Gültig bis","Index",null,"Rechnungsnummer","Datum\n1","Abgerechnete Leistung ohne MwSt. (Subtotal 4)\n2","alter MwSt-Satz 1\n3","neuer MwSt-Satz 1\n4","Differenz\n5","Betrag\n6","alter MwSt-Satz 2\n7","neuer MwSt-Satz 2\n8","alter MwSt-Satz 3\n9","neuer MwSt-Satz 3\n10"]
[6.5,"1995-01-01","1998-12-31",1]
[7.5,"1999-01-01","2000-12-31",2]
[7.6,"2001-01-01","2010-12-31",3]
[8,"2011-01-01","2017-12-31",4]
[7.7,"2018-01-01","2023-12-31",5]
[8.1,"2024-01-01",null,6]
[]
[]
[]
[]
[]
[]
[2,"1995-01-01","1998-12-31",1]
[2.2999999999999998,"1999-01-01","2000-12-31",2]
[2.4,"2001-01-01","2010-12-31",3]
[2.5,"2011-01-01","2023-12-31",4]
[2.6,"2024-01-01",null,5]
[]
[]
[]
[]
[]
[]
[]
[0,"1995-01-01",null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[8.1,2.6,0]
[7.7,2.5,0]
[8,2.5,0]
[7.6,2.4,0]
[7.5,2.2999999999999998,0]
[6.5,2,0]

{"sheet":"6_Eingabe_Buergschaften","index":6,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
["Nr.","Solidarbürge Name","Solidarbürge Adresse","Bürgschaft vom","Garantieschein-Nr.","Gültig bis","Betrag"]

{"sheet":"7_Ausdruck_Nachtragsofferte","index":7,"n_rows":191,"n_cols":26,"rows_kept":191,"cut":false,"hidden":true,"merged":[[34,9,34,10],[35,9,35,10],[122,0,122,21],[122,22,122,23],[123,0,123,23],[124,0,186,23],[120,0,120,2],[120,3,120,8],[120,9,120,10],[120,14,120,16],[120,17,120,20],[120,21,120,22],[119,0,119,2],[119,3,119,8],[119,9,119,10],[119,14,119,16],[119,17,119,20],[119,21,119,22],[118,0,118,2],[118,3,118,8],[118,9,118,10],[118,14,118,16],[118,17,118,20],[118,21,118,22],[117,0,117,2],[117,3,117,8],[117,9,117,10],[117,14,117,16],[117,17,117,20],[117,21,117,22],[116,0,116,2],[116,3,116,8],[116,9,116,10],[116,14,116,16],[116,17,116,20],[116,21,116,22],[115,0,115,2],[115,3,115,8],[115,9,115,10],[115,14,115,16],[115,17,115,20],[115,21,115,22],[114,0,114,2],[114,3,114,8],[114,9,114,10],[114,14,114,16],[114,17,114,20],[114,21,114,22],[113,0,113,2],[113,3,113,8],[113,9,113,10],[113,14,113,16],[113,17,113,20],[113,21,113,22],[112,0,112,2],[112,3,112,8],[112,9,112,10],[112,14,112,16],[112,17,112,20],[112,21,112,22],[111,0,111,2],[111,3,111,8],[111,9,111,10],[111,14,111,16],[111,17,111,20],[111,21,111,22],[110,0,110,2],[110,3,110,8],[110,9,110,10],[110,14,110,16],[110,17,110,20],[110,21,110,22],[109,0,109,2],[109,3,109,8],[109,9,109,10],[109,14,109,16],[109,17,109,20],[109,21,109,22],[108,0,108,2],[108,3,108,8],[108,9,108,10],[108,14,108,16],[108,17,108,20],[108,21,108,22],[107,0,107,2],[107,3,107,8],[107,9,107,10],[107,14,107,16],[107,17,107,20],[107,21,107,22],[106,0,106,2],[106,3,106,8],[106,9,106,10],[106,14,106,16],[106,17,106,20],[106,21,106,22],[105,0,105,2],[105,3,105,8],[105,9,105,10],[105,14,105,16],[105,17,105,20],[105,21,105,22],[104,0,104,2],[104,3,104,8],[104,9,104,10],[104,14,104,16],[104,17,104,20],[104,21,104,22],[103,0,103,2],[103,3,103,8],[103,9,103,10],[103,14,103,16],[103,17,103,20],[103,21,103,22],[102,0,102,2],[102,3,102,8],[102,9,102,10],[102,14,102,16],[102,17,102,20],[102,21,102,22],[101,0,101,2],[101,3,101,8],[101,9,101,10],[101,14,101,16],[101,17,101,20],[101,21,101,22],[100,0,100,2],[100,3,100,8],[100,9,100,10],[100,14,100,16],[100,17,100,20],[100,21,100,22],[99,0,99,2],[99,3,99,8],[99,9,99,10],[99,14,99,16],[99,17,99,20],[99,21,99,22],[98,0,98,2],[98,3,98,8],[98,9,98,10],[98,14,98,16],[98,17,98,20],[98,21,98,22],[97,0,97,2],[97,3,97,8],[97,9,97,10],[97,14,97,16],[97,17,97,20],[97,21,97,22],[96,0,96,2],[96,3,96,8],[96,9,96,10],[96,14,96,16],[96,17,96,20],[96,21,96,22],[95,0,95,2],[95,3,95,8],[95,9,95,10],[95,14,95,16],[95,17,95,20],[95,21,95,22],[94,0,94,2],[94,3,94,8],[94,9,94,10],[94,14,94,16],[94,17,94,20],[94,21,94,22],[93,0,93,2],[93,3,93,8],[93,9,93,10],[93,14,93,16],[93,17,93,20],[93,21,93,22],[92,0,92,2],[92,3,92,8],[92,9,92,10],[92,14,92,16],[92,17,92,20],[92,21,92,22],[91,0,91,2],[91,3,91,8],[91,9,91,10],[91,14,91,16],[91,17,91,20],[91,21,91,22],[90,0,90,2],[90,3,90,8],[90,9,90,10],[90,14,90,16],[90,17,90,20],[90,21,90,22],[89,0,89,2],[89,3,89,8],[89,9,89,10],[89,14,89,16],[89,17,89,20],[89,21,89,22],[88,0,88,2],[88,3,88,8],[88,9,88,10],[88,14,88,16],[88,17,88,20],[88,21,88,22],[87,0,87,2],[87,3,87,8],[87,9,87,10],[87,14,87,16],[87,17,87,20],[87,21,87,22],[86,0,86,2],[86,3,86,8],[86,9,86,10],[86,14,86,16],[86,17,86,20],[86,21,86,22],[85,0,85,2],[85,3,85,8],[85,9,85,10],[85,14,85,16],[85,17,85,20],[85,21,85,22],[84,0,84,2],[84,3,84,8],[84,9,84,10],[84,14,84,16],[84,17,84,20],[84,21,84,22],[83,0,83,2],[83,3,83,8],[83,9,83,10],[83,14,83,16],[83,17,83,20],[83,21,83,22],[82,0,82,2],[82,3,82,8],[82,9,82,10],[82,14,82,16],[82,17,82,20],[82,21,82,22],[81,0,81,2],[81,3,81,8],[81,9,81,10],[81,14,81,16],[81,17,81,20],[81,21,81,22],[80,0,80,2],[80,3,80,8],[80,9,80,10],[80,14,80,16],[80,17,80,20],[80,21,80,22],[79,0,79,2],[79,3,79,8],[79,9,79,10],[79,14,79,16],[79,17,79,20],[79,21,79,22],[78,0,78,2],[78,3,78,8],[78,9,78,10],[78,14,78,16],[78,17,78,20],[78,21,78,22],[77,0,77,2],[77,3,77,8],[77,9,77,10],[77,14,77,16],[77,17,77,20],[77,21,77,22],[76,0,76,2],[76,3,76,8],[76,9,76,10],[76,14,76,16],[76,17,76,20],[76,21,76,22],[75,0,75,2],[75,3,75,8],[75,9,75,10],[75,14,75,16],[75,17,75,20],[75,21,75,22],[74,0,74,2],[74,3,74,8],[74,9,74,10],[74,14,74,16],[74,17,74,20],[74,21,74,22],[73,0,73,2],[73,3,73,8],[73,9,73,10],[73,14,73,16],[73,17,73,20],[73,21,73,22],[72,0,72,2],[72,3,72,8],[72,9,72,10],[72,14,72,16],[72,17,72,20],[72,21,72,22],[66,3,66,11],[68,3,68,4],[69,3,69,4],[71,0,71,8],[71,9,71,10],[71,14,71,20],[60,3,60,11],[60,18,60,23],[61,3,61,11],[61,18,61,23],[62,3,62,4],[65,3,65,11],[53,3,53,11],[54,3,54,11],[58,3,58,11],[58,18,58,23],[59,3,59,11],[59,18,59,23],[46,0,46,2],[46,3,46,8],[46,9,46,10],[47,7,47,10],[51,3,51,11],[52,3,52,11],[44,3,44,8],[44,9,44,10],[45,0,45,2],[45,3,45,8],[45,9,45,10],[42,0,42,2],[42,3,42,8],[42,9,42,10],[43,0,43,2],[43,3,43,8],[43,9,43,10],[34,0,34,2],[34,3,34,8],[34,14,55,23],[35,0,35,2],[35,3,35,8],[36,0,36,2],[36,3,36,8],[36,9,36,10],[37,0,37,2],[37,3,37,8],[40,0,40,2],[40,3,40,8],[40,9,40,10],[41,0,41,2],[41,3,41,8],[41,9,41,10],[37,9,37,10],[38,0,38,2],[38,3,38,8],[38,9,38,10],[39,0,39,2],[39,3,39,8],[39,9,39,10],[44,0,44,2],[18,9,18,10],[18,21,18,23],[20,21,20,23],[24,9,24,10],[25,9,25,10],[33,0,33,8],[33,9,33,10],[33,14,33,23],[16,5,16,6],[16,9,16,10],[16,21,16,23],[17,5,17,6],[17,7,17,8],[17,9,17,10],[17,21,17,23],[14,5,14,6],[14,7,14,8],[14,21,14,23],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,21,15,23],[7,0,7,7],[7,8,7,10],[10,8,10,23],[11,8,11,23],[13,5,13,6],[13,7,13,8],[13,21,13,23],[8,8,8,18]]}
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,2,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,2,FALSE),\"\")","v":"Kanton St.Gallen"}]
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,3,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,3,FALSE),\"\")","v":"Bau- und Umweltdepartement"}]
[]
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,4,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,4,FALSE),\"\")","v":"Tiefbauamt"}]
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,26,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,26,FALSE),\"\")","v":"Amtsleitung"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Nachtragsofferte Nr.",null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,"Bau",null,null,"615300.501100"]
["Eigene Nummerierung",null,null,null,null,null,null,null,"abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz",null,null,null,null,null,null,null,null,null,null,null,"RRB/AS Nr.",null,null,"18.32040"]
[]
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,5,FALSE)=\"Gebietseinheit VI\",\"\",IF(VLOOKUP(c_Zustaendig,r_Briefkopf,7,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,7,FALSE),\"\"))","v":"Gemeinde / Objekt / Baulos"},null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,5,FALSE)=\"GEVI\",\"\",IF('1_Eingabe_Grunddaten'!C11 = \"\",\"\",'1_Eingabe_Grunddaten'!C11))","v":""}]
["Art der Arbeit oder Lieferung",null,null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C12=\"\",\"\",'1_Eingabe_Grunddaten'!C12)","v":""}]
[]
["Angebot",null,null,null,null,"vom",null,{"$f":"IF('1_Eingabe_Grunddaten'!C22=\"\",\"\",'1_Eingabe_Grunddaten'!C22)","v":""},null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,8,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,8,FALSE),\"\")","v":"KOA / Pos."},null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C10=\"\",\"\",'1_Eingabe_Grunddaten'!C10)","v":""}]
["Werk-/Ingenieurvertrag",null,null,null,null,"vom",null,{"$f":"IF('1_Eingabe_Grunddaten'!C23=\"\",\"\",'1_Eingabe_Grunddaten'!C23)","v":""},null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,10,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,10,FALSE),\"\")","v":"Kanton St.Gallen"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,11,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,11,FALSE),\"\")","v":"Nr."},{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,12,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,12,FALSE),\"\")","v":17}]
["RRB/AS",null,null,null,null,"vom",null,{"$f":"IF('1_Eingabe_Grunddaten'!C26=\"\",\"\",'1_Eingabe_Grunddaten'!C26)","v":""},null,"Fr.",null,{"$f":"'1_Eingabe_Grunddaten'!C27","v":0},null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,13,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,13,FALSE),\"\")","v":"Schweiz. Hauptstrasse(n)"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,14,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,14,FALSE),\"\")","v":"Nr."},{"$f":"IF(OR(O16=\"\",'1_Eingabe_Grunddaten'!C13=\"\"),\"\",'1_Eingabe_Grunddaten'!C13)","v":""}]
["Nachträge bisher",null,null,null,null,"Nr.",null," 1    -","1","Fr.",null,1757.65,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,15,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,15,FALSE),\"\")","v":"Kantonsstrasse(n)"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,16,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,16,FALSE),\"\")","v":"Nr."},{"$f":"IF(OR(O17=\"\",'1_Eingabe_Grunddaten'!C14=\"\"),\"\",'1_Eingabe_Grunddaten'!C14)","v":""}]
["Nachtrag neu",null,null,null,null,"Nr.",null," 2",null,"Fr.",null,3075.9,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,17,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,17,FALSE),\"\")","v":"Gemeinde(n)"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,18,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,18,FALSE),\"\")","v":"Nr."},{"$f":"IF(OR(O18=\"\",'1_Eingabe_Grunddaten'!C15=\"\"),\"\",'1_Eingabe_Grunddaten'!C15)","v":""}]
["Total Vertragssumme",null,null,null,null,null,null,null,null,"Fr.",null,{"$f":"SUM(L16:L18)","v":4833.55},null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,19,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,19,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,20,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,20,FALSE),\"\")","v":""},{"$f":"IF(OR(O19=\"\",'1_Eingabe_Grunddaten'!C16=\"\"),\"\",'1_Eingabe_Grunddaten'!C16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,21,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,21,FALSE),\"\")","v":"RMS-Stationierung"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,22,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,22,FALSE),\"\")","v":"km"},{"$f":"IF(OR(O20=\"\",'1_Eingabe_Grunddaten'!C17=\"\"),\"\",'1_Eingabe_Grunddaten'!C17)","v":""},{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,23,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,23,FALSE),\"\")","v":"-"},{"$f":"IF(OR(O20=\"\",'1_Eingabe_Grunddaten'!C18=\"\"),\"\",'1_Eingabe_Grunddaten'!C18)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,24,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,24,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,25,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,25,FALSE),\"\")","v":""},{"$f":"IF(OR(O21=\"\",'1_Eingabe_Grunddaten'!C19=\"\"),\"\",'1_Eingabe_Grunddaten'!C19)","v":""}]
[]
[]
[]
["a)",null,"Ersatzposition",null,null,null,null,null,null,"Fr.",null,0]
[null,null,"abzüglich ersetzte Positionen",null,null,null,null,null,null,"Fr.",null,0,null,null,null,null,null,null,null,null,null,"Fr.",null,{"$f":"SUM(L25:L26)","v":0}]
[]
["b)",null,"Zusatzpositionen",null,null,null,null,null,null,"(nicht in Hauptofferte enthalten)",null,null,null,null,null,null,null,null,null,null,null,"Fr.",null,3075.9]
[]
["c)",null,"Ausmass",null,null,{"$f":"IF(X30>0,\"X\",\"\")","v":""}," Mehrausmass",null,null,{"$f":"IF(X30<0,\"X\",\"\")","v":""}," Minderausmass",null,null,null,null,null,null,null,null,null,null,"Fr.",null,0]
[]
["TOTAL",null,null,null,null,{"$f":"IF(X32>0,\"X\",\"\")","v":"X"}," Mehrkosten",null,null,{"$f":"IF(X32<0,\"X\",\"\")","v":""}," Minderkosten",null,null,null,null,null,null,null,null,null,null,"Fr.",null,3075.9]
[]
["Baukostenart od. Benutzerdef. Leistung",null,null,null,null,null,null,null,null,"Mwst",null,"Fr.",null,null,"Begründung"]
[833,null,null,"Kopien (Nebenkosten)",null,null,null,null,null,7.7,null,60.300000000000004,null,null,"Aufgrund der internen Stellungnahmen des ANJF zum Vorprojekt musste der projektierte Durchlass mit zwei Kleintierbermen ergänzt und somit der Durchmesser des DL vergrössert werden. Dies erforderte neue hydraulische Berechnungen sowie die Anpassung sämtlicher Pläne."]
[872,null,null,"Bauingenieur (Kostentarif)",null,null,null,null,null,7.7,null,3015.6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(L35:L47)","v":3075.9}]
[]
[]
[]
["Firma",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C40>0,'1_Eingabe_Grunddaten'!C40,\"\")","v":""}]
[null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C41>0,'1_Eingabe_Grunddaten'!C41,IF('1_Eingabe_Grunddaten'!C42>0,'1_Eingabe_Grunddaten'!C42,\"\"))","v":""}]
[null,null,null,{"$f":"IF(AND('1_Eingabe_Grunddaten'!C42>0,'1_Eingabe_Grunddaten'!C41>0),'1_Eingabe_Grunddaten'!C42,IF('1_Eingabe_Grunddaten'!C43>0,'1_Eingabe_Grunddaten'!C43,\"\"))","v":""}]
[null,null,null,{"$f":"IF(AND('1_Eingabe_Grunddaten'!C43>0,'1_Eingabe_Grunddaten'!C41>0),'1_Eingabe_Grunddaten'!C43,\"\")","v":""}]
[]
[]
[]
["Örtliche",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C47>0,'1_Eingabe_Grunddaten'!C47,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Budgetverantwortung"]
["Bauleitung",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C48>0,'1_Eingabe_Grunddaten'!C48,IF('1_Eingabe_Grunddaten'!C49>0,'1_Eingabe_Grunddaten'!C49,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,"(Gesamtkosten)"]
[null,null,null,{"$f":"IF(AND('1_Eingabe_Grunddaten'!C49>0,'1_Eingabe_Grunddaten'!C48>0),'1_Eingabe_Grunddaten'!C49,IF('1_Eingabe_Grunddaten'!C50>0,'1_Eingabe_Grunddaten'!C50,\"\"))","v":""}]
[null,null,null,{"$f":"IF(AND('1_Eingabe_Grunddaten'!C50>0,'1_Eingabe_Grunddaten'!C48>0),'1_Eingabe_Grunddaten'!C50,\"\")","v":""}]
["Datum",null,null,null,null,null,null,"Kontrolliert",null,null,null,null,null,null,"Datum",null,null,null,null,null,null,"Visiert"]
[]
[]
["Oberbau-",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C53>0,'1_Eingabe_Grunddaten'!C53,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Bauherrschaft"]
["leitung",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C54>0,'1_Eingabe_Grunddaten'!C54,\"\")","v":""}]
[]
["Datum",null,null,null,null,null,null,"Geprüft"]
["Datum",null,null,null,null,null,null,"Visiert",null,null,null,null,null,null,"Datum",null,null,null,null,null,null,"Genehmigt"]
[]
["Baukostenart od. Benutzerdef. Leistung",null,null,null,null,null,null,null,null,"Mwst",null,"Fr.",null,null,"Baukostenart od. Benutzerdef. Leistung",null,null,null,null,null,null,"Mwst",null,"Fr."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total der Nachtragsofferte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L73:L121,X73:X121)","v":0}]
["Begründung"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Überprüfung Länge Begründung"]

{"sheet":"8_Ausdruck_Abschlagszahlung","index":8,"n_rows":297,"n_cols":25,"rows_kept":297,"cut":false,"hidden":true,"merged":[[6,23,6,24],[296,0,296,3],[296,4,296,17],[296,18,296,21],[296,22,296,24],[294,0,294,3],[294,4,294,17],[294,18,294,21],[294,22,294,24],[295,0,295,3],[295,4,295,17],[295,18,295,21],[295,22,295,24],[292,0,292,3],[292,4,292,17],[292,18,292,21],[292,22,292,24],[293,0,293,3],[293,4,293,17],[293,18,293,21],[293,22,293,24],[290,0,290,3],[290,4,290,17],[290,18,290,21],[290,22,290,24],[291,0,291,3],[291,4,291,17],[291,18,291,21],[291,22,291,24],[288,0,288,3],[288,4,288,17],[288,18,288,21],[288,22,288,24],[289,0,289,3],[289,4,289,17],[289,18,289,21],[289,22,289,24],[286,0,286,3],[286,4,286,17],[286,18,286,21],[286,22,286,24],[287,0,287,3],[287,4,287,17],[287,18,287,21],[287,22,287,24],[284,0,284,3],[284,4,284,17],[284,18,284,21],[284,22,284,24],[285,0,285,3],[285,4,285,17],[285,18,285,21],[285,22,285,24],[282,0,282,3],[282,4,282,17],[282,18,282,21],[282,22,282,24],[283,0,283,3],[283,4,283,17],[283,18,283,21],[283,22,283,24],[280,0,280,3],[280,4,280,17],[280,18,280,21],[280,22,280,24],[281,0,281,3],[281,4,281,17],[281,18,281,21],[281,22,281,24],[278,0,278,3],[278,4,278,17],[278,18,278,21],[278,22,278,24],[279,0,279,3],[279,4,279,17],[279,18,279,21],[279,22,279,24],[276,0,276,3],[276,4,276,17],[276,18,276,21],[276,22,276,24],[277,0,277,3],[277,4,277,17],[277,18,277,21],[277,22,277,24],[274,0,274,3],[274,4,274,17],[274,18,274,21],[274,22,274,24],[275,0,275,3],[275,4,275,17],[275,18,275,21],[275,22,275,24],[272,0,272,3],[272,4,272,17],[272,18,272,21],[272,22,272,24],[273,0,273,3],[273,4,273,17],[273,18,273,21],[273,22,273,24],[270,0,270,3],[270,4,270,17],[270,18,270,21],[270,22,270,24],[271,0,271,3],[271,4,271,17],[271,18,271,21],[271,22,271,24],[268,0,268,3],[268,4,268,17],[268,18,268,21],[268,22,268,24],[269,0,269,3],[269,4,269,17],[269,18,269,21],[269,22,269,24],[266,0,266,3],[266,4,266,17],[266,18,266,21],[266,22,266,24],[267,0,267,3],[267,4,267,17],[267,18,267,21],[267,22,267,24],[264,0,264,3],[264,4,264,17],[264,18,264,21],[264,22,264,24],[265,0,265,3],[265,4,265,17],[265,18,265,21],[265,22,265,24],[262,0,262,3],[262,4,262,17],[262,18,262,21],[262,22,262,24],[263,0,263,3],[263,4,263,17],[263,18,263,21],[263,22,263,24],[260,0,260,3],[260,4,260,17],[260,18,260,21],[260,22,260,24],[261,0,261,3],[261,4,261,17],[261,18,261,21],[261,22,261,24],[258,0,258,3],[258,4,258,17],[258,18,258,21],[258,22,258,24],[259,0,259,3],[259,4,259,17],[259,18,259,21],[259,22,259,24],[256,0,256,3],[256,4,256,17],[256,18,256,21],[256,22,256,24],[257,0,257,3],[257,4,257,17],[257,18,257,21],[257,22,257,24],[254,0,254,3],[254,4,254,17],[254,18,254,21],[254,22,254,24],[255,0,255,3],[255,4,255,17],[255,18,255,21],[255,22,255,24],[252,0,252,3],[252,4,252,17],[252,18,252,21],[252,22,252,24],[253,0,253,3],[253,4,253,17],[253,18,253,21],[253,22,253,24],[250,0,250,3],[250,4,250,17],[250,18,250,21],[250,22,250,24],[251,0,251,3],[251,4,251,17],[251,18,251,21],[251,22,251,24],[248,0,248,3],[248,4,248,17],[248,18,248,21],[248,22,248,24],[249,0,249,3],[249,4,249,17],[249,18,249,21],[249,22,249,24],[205,22,205,24],[206,22,206,24],[210,7,210,8],[212,7,212,8],[245,0,246,2],[245,8,245,24],[246,8,246,24],[200,8,200,9],[200,22,200,24],[201,8,201,9],[201,22,201,24],[202,22,202,24],[203,22,203,24],[195,8,195,24],[196,8,196,24],[198,8,198,9],[198,22,198,24],[199,8,199,9],[199,22,199,24],[188,0,188,1],[188,2,188,9],[188,10,188,11],[188,15,188,17],[188,18,188,21],[188,22,188,23],[187,0,187,1],[187,2,187,9],[187,10,187,11],[187,15,187,17],[187,18,187,21],[187,22,187,23],[186,0,186,1],[186,2,186,9],[186,10,186,11],[186,15,186,17],[186,18,186,21],[186,22,186,23],[185,0,185,1],[185,2,185,9],[185,10,185,11],[185,15,185,17],[185,18,185,21],[185,22,185,23],[184,0,184,1],[184,2,184,9],[184,10,184,11],[184,15,184,17],[184,18,184,21],[184,22,184,23],[183,0,183,1],[183,2,183,9],[183,10,183,11],[183,15,183,17],[183,18,183,21],[183,22,183,23],[182,0,182,1],[182,2,182,9],[182,10,182,11],[182,15,182,17],[182,18,182,21],[182,22,182,23],[181,0,181,1],[181,2,181,9],[181,10,181,11],[181,15,181,17],[181,18,181,21],[181,22,181,23],[180,0,180,1],[180,2,180,9],[180,10,180,11],[180,15,180,17],[180,18,180,21],[180,22,180,23],[179,0,179,1],[179,2,179,9],[179,10,179,11],[179,15,179,17],[179,18,179,21],[179,22,179,23],[178,0,178,1],[178,2,178,9],[178,10,178,11],[178,15,178,17],[178,18,178,21],[178,22,178,23],[177,0,177,1],[177,2,177,9],[177,10,177,11],[177,15,177,17],[177,18,177,21],[177,22,177,23],[176,0,176,1],[176,2,176,9],[176,10,176,11],[176,15,176,17],[176,18,176,21],[176,22,176,23],[175,0,175,1],[175,2,175,9],[175,10,175,11],[175,15,175,17],[175,18,175,21],[175,22,175,23],[174,0,174,1],[174,2,174,9],[174,10,174,11],[174,15,174,17],[174,18,174,21],[174,22,174,23],[173,0,173,1],[173,2,173,9],[173,10,173,11],[173,15,173,17],[173,18,173,21],[173,22,173,23],[172,0,172,1],[172,2,172,9],[172,10,172,11],[172,15,172,17],[172,18,172,21],[172,22,172,23],[171,0,171,1],[171,2,171,9],[171,10,171,11],[171,15,171,17],[171,18,171,21],[171,22,171,23],[170,0,170,1],[170,2,170,9],[170,10,170,11],[170,15,170,17],[170,18,170,21],[170,22,170,23],[169,0,169,1],[169,2,169,9],[169,10,169,11],[169,15,169,17],[169,18,169,21],[169,22,169,23],[168,0,168,1],[168,2,168,9],[168,10,168,11],[168,15,168,17],[168,18,168,21],[168,22,168,23],[167,0,167,1],[167,2,167,9],[167,10,167,11],[167,15,167,17],[167,18,167,21],[167,22,167,23],[166,0,166,1],[166,2,166,9],[166,10,166,11],[166,15,166,17],[166,18,166,21],[166,22,166,23],[165,0,165,1],[165,2,165,9],[165,10,165,11],[165,15,165,17],[165,18,165,21],[165,22,165,23],[164,0,164,1],[164,2,164,9],[164,10,164,11],[164,15,164,17],[164,18,164,21],[164,22,164,23],[163,0,163,1],[163,2,163,9],[163,10,163,11],[163,15,163,17],[163,18,163,21],[163,22,163,23],[162,0,162,1],[162,2,162,9],[162,10,162,11],[162,15,162,17],[162,18,162,21],[162,22,162,23],[161,0,161,1],[161,2,161,9],[161,10,161,11],[161,15,161,17],[161,18,161,21],[161,22,161,23],[160,0,160,1],[160,2,160,9],[160,10,160,11],[160,15,160,17],[160,18,160,21],[160,22,160,23],[159,0,159,1],[159,2,159,9],[159,10,159,11],[159,15,159,17],[159,18,159,21],[159,22,159,23],[158,0,158,1],[158,2,158,9],[158,10,158,11],[158,15,158,17],[158,18,158,21],[158,22,158,23],[157,0,157,1],[157,2,157,9],[157,10,157,11],[157,15,157,17],[157,18,157,21],[157,22,157,23],[156,0,156,1],[156,2,156,9],[156,10,156,11],[156,15,156,17],[156,18,156,21],[156,22,156,23],[155,0,155,1],[155,2,155,9],[155,10,155,11],[155,15,155,17],[155,18,155,21],[155,22,155,23],[154,0,154,1],[154,2,154,9],[154,10,154,11],[154,15,154,17],[154,18,154,21],[154,22,154,23],[153,0,153,1],[153,2,153,9],[153,10,153,11],[153,15,153,17],[153,18,153,21],[153,22,153,23],[152,0,152,1],[152,2,152,9],[152,10,152,11],[152,15,152,17],[152,18,152,21],[152,22,152,23],[151,0,151,1],[151,2,151,9],[151,10,151,11],[151,15,151,17],[151,18,151,21],[151,22,151,23],[150,0,150,1],[150,2,150,9],[150,10,150,11],[150,15,150,17],[150,18,150,21],[150,22,150,23],[149,0,149,1],[149,2,149,9],[149,10,149,11],[149,15,149,17],[149,18,149,21],[149,22,149,23],[148,0,148,1],[148,2,148,9],[148,10,148,11],[148,15,148,17],[148,18,148,21],[148,22,148,23],[147,0,147,1],[147,2,147,9],[147,10,147,11],[147,15,147,17],[147,18,147,21],[147,22,147,23],[146,0,146,1],[146,2,146,9],[146,10,146,11],[146,15,146,17],[146,18,146,21],[146,22,146,23],[145,0,145,1],[145,2,145,9],[145,10,145,11],[145,15,145,17],[145,18,145,21],[145,22,145,23],[144,0,144,1],[144,2,144,9],[144,10,144,11],[144,15,144,17],[144,18,144,21],[144,22,144,23],[143,0,143,1],[143,2,143,9],[143,10,143,11],[143,15,143,17],[143,18,143,21],[143,22,143,23],[142,0,142,1],[142,2,142,9],[142,10,142,11],[142,15,142,17],[142,18,142,21],[142,22,142,23],[141,0,141,1],[141,2,141,9],[141,10,141,11],[141,15,141,17],[141,18,141,21],[141,22,141,23],[134,3,134,12],[139,10,139,11],[139,22,139,23],[140,0,140,1],[140,2,140,9],[140,10,140,11],[140,15,140,17],[140,18,140,21],[140,22,140,23],[123,21,123,22],[124,21,124,22],[127,3,127,12],[128,3,128,12],[129,3,129,12],[133,3,133,12],[117,21,117,22],[118,21,118,22],[119,21,119,22],[120,21,120,22],[121,21,121,22],[122,21,122,22],[110,3,110,12],[111,3,111,12],[112,3,112,12],[113,3,113,12],[114,19,114,24],[115,19,115,24],[106,3,106,12],[107,3,107,12],[108,3,108,12],[109,2,109,3],[109,7,109,8],[109,11,109,12],[102,0,102,1],[102,2,102,9],[102,10,102,11],[103,0,103,1],[103,2,103,11],[105,3,105,12],[100,0,100,1],[100,2,100,9],[100,10,100,11],[101,0,101,1],[101,2,101,9],[101,10,101,11],[98,0,98,1],[98,2,98,9],[98,10,98,11],[99,0,99,1],[99,2,99,9],[99,10,99,11],[96,0,96,1],[96,2,96,9],[96,10,96,11],[97,0,97,1],[97,2,97,9],[97,10,97,11],[94,0,94,1],[94,2,94,9],[94,10,94,11],[95,0,95,1],[95,2,95,9],[95,10,95,11],[92,0,92,1],[92,2,92,9],[92,10,92,11],[93,0,93,1],[93,2,93,9],[93,10,93,11],[90,0,90,1],[90,2,90,9],[90,10,90,11],[91,0,91,1],[91,2,91,9],[91,10,91,11],[83,22,83,24],[84,22,84,24],[86,22,86,24],[87,22,87,24],[88,10,88,11],[89,0,89,1],[89,2,89,9],[89,10,89,11],[80,8,80,9],[80,22,80,24],[81,8,81,9],[81,22,81,24],[82,8,82,9],[82,22,82,24],[73,0,73,8],[73,9,73,11],[76,8,76,24],[77,8,77,24],[79,8,79,9],[79,22,79,24],[60,3,60,12],[60,21,60,22],[61,21,61,22],[62,21,62,22],[65,3,65,12],[66,3,66,12],[54,3,54,12],[57,3,57,12],[57,19,57,24],[58,3,58,12],[58,19,58,24],[59,3,59,12],[59,21,59,22],[49,2,49,3],[49,7,49,8],[49,11,49,12],[51,3,51,12],[52,3,52,12],[53,3,53,12],[43,0,43,1],[43,2,43,11],[45,3,45,12],[46,3,46,12],[47,3,47,12],[48,3,48,12],[41,0,41,1],[41,2,41,9],[41,10,41,11],[42,0,42,1],[42,2,42,9],[42,10,42,11],[39,0,39,1],[39,2,39,9],[39,10,39,11],[40,0,40,1],[40,2,40,9],[40,10,40,11],[37,0,37,1],[37,2,37,9],[37,10,37,11],[38,0,38,1],[38,2,38,9],[38,10,38,11],[35,0,35,1],[35,2,35,9],[35,10,35,11],[36,0,36,1],[36,2,36,9],[36,10,36,11],[33,0,33,1],[33,2,33,9],[33,10,33,11],[34,0,34,1],[34,2,34,9],[34,10,34,11],[31,0,31,1],[31,2,31,9],[31,10,31,11],[32,0,32,1],[32,2,32,9],[32,10,32,11],[29,10,29,11],[30,0,30,1],[30,2,30,9],[30,10,30,11],[14,8,14,9],[14,22,14,24],[15,8,15,9],[15,22,15,24],[16,8,16,9],[16,22,16,24],[7,0,7,9],[7,10,7,12],[10,8,10,24],[11,8,11,24],[13,8,13,9],[13,22,13,24],[17,22,17,24],[18,22,18,24],[20,22,20,24],[8,23,8,24],[7,23,7,24],[8,8,8,19]]}
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,2,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,2,FALSE),\"\")","v":"Kanton St.Gallen"}]
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,3,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,3,FALSE),\"\")","v":"Bau- und Umweltdepartement"}]
[]
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,4,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,4,FALSE),\"\")","v":"Tiefbauamt"}]
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,26,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,26,FALSE),\"\")","v":"Amtsleitung"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Abschlagszahlung Nr.",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,"Bau",null,"615300.501100"]
["Eigene Nummerierung",null,null,null,null,null,null,null,"NO2, DL Brunnacker",null,null,null,null,null,null,null,null,null,null,null,null,"RRB/AS Nr.",null,"18.32040"]
[]
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,5,FALSE)=\"Gebietseinheit VI\",\"\",IF(VLOOKUP(c_Zustaendig,r_Briefkopf,7,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,7,FALSE),\"\"))","v":"Gemeinde / Objekt / Baulos"},null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,5,FALSE)=\"GEVI\",\"\",IF('1_Eingabe_Grunddaten'!C11=\"\",\"\",'1_Eingabe_Grunddaten'!C11))","v":""}]
["Art der Arbeit oder Lieferung",null,null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C12=\"\",\"\",'1_Eingabe_Grunddaten'!C12)","v":""}]
[]
["Angebot",null,null,null,null,"vom",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C22=\"\",\"\",'1_Eingabe_Grunddaten'!C22)","v":""},null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,8,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,8,FALSE),\"\")","v":"KOA / Pos."},null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C10=\"\",\"\",'1_Eingabe_Grunddaten'!C10)","v":""}]
["Werk-/Ingenieurvertrag",null,null,null,null,"vom",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C23=\"\",\"\",'1_Eingabe_Grunddaten'!C23)","v":""},null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,10,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,10,FALSE),\"\")","v":"Kanton St.Gallen"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,11,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,11,FALSE),\"\")","v":"Nr."},{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,12,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,12,FALSE),\"\")","v":17}]
["RRB/AS",null,null,null,null,"vom",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C26=\"\",\"\",'1_Eingabe_Grunddaten'!C26)","v":""},null,"Fr.",null,{"$f":"'1_Eingabe_Grunddaten'!C27","v":0},null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,13,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,13,FALSE),\"\")","v":"Schweiz. Hauptstrasse(n)"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,14,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,14,FALSE),\"\")","v":"Nr."},{"$f":"IF(OR('1_Eingabe_Grunddaten'!C13=\"\",'1_Eingabe_Grunddaten'!A13=\"\"),\"\",'1_Eingabe_Grunddaten'!C13)","v":""}]
["Nachträge Nr.",null,null,null,1,"bis",null,null,2,null,"Fr.",null,4833.55,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,15,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,15,FALSE),\"\")","v":"Kantonsstrasse(n)"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,16,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,16,FALSE),\"\")","v":"Nr."},{"$f":"IF(OR('1_Eingabe_Grunddaten'!A14=\"\",'1_Eingabe_Grunddaten'!C14=\"\"),\"\",'1_Eingabe_Grunddaten'!C14)","v":""}]
["Total Vertragssumme",null,null,null,null,null,null,null,null,null,"Fr.",null,{"$f":"SUM(M16:M17)","v":4833.55},null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,17,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,17,FALSE),\"\")","v":"Gemeinde(n)"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,18,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,18,FALSE),\"\")","v":"Nr."},{"$f":"IF(OR('1_Eingabe_Grunddaten'!A15=\"\",'1_Eingabe_Grunddaten'!C15=\"\"),\"\",'1_Eingabe_Grunddaten'!C15)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,19,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,19,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,20,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,20,FALSE),\"\")","v":""},{"$f":"IF(OR('1_Eingabe_Grunddaten'!A16=\"\",'1_Eingabe_Grunddaten'!C16=\"\"),\"\",'1_Eingabe_Grunddaten'!C16)","v":""}]
["Zahlungsfrist",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$31<'1_Eingabe_Grunddaten'!$C$35,'1_Eingabe_Grunddaten'!$C$31,IF('1_Eingabe_Grunddaten'!$C$35>0,'1_Eingabe_Grunddaten'!$C$35,'1_Eingabe_Grunddaten'!C31))","v":0},"Tage",null,null,"Rabatt",null,{"$f":"IF('1_Eingabe_Grunddaten'!C32=\"\",\"0.0\",'1_Eingabe_Grunddaten'!C32)","v":"0.0"},"%",null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,21,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,21,FALSE),\"\")","v":"RMS-Stationierung"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,22,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,22,FALSE),\"\")","v":"km"},{"$f":"IF(P20=\"\",\"\",IF(OR('1_Eingabe_Grunddaten'!$A$17=\"\",'1_Eingabe_Grunddaten'!$C$17=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$17))","v":""},{"$f":"IF(P20=\"\",\"\",IF(VLOOKUP(c_Zustaendig,r_Briefkopf,23,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,23,FALSE),\"\"))","v":"-"},{"$f":"IF(P20=\"\",\"\",IF(OR('1_Eingabe_Grunddaten'!$A$17=\"\",'1_Eingabe_Grunddaten'!$C$18=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$18))","v":""}]
[null,null,null,null,null,null,null,"Skonto",null,{"$f":"IF('1_Eingabe_Grunddaten'!C34=\"\",\"0.0\",'1_Eingabe_Grunddaten'!C34)","v":"0.0"},"%",null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,24,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,24,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,25,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,25,FALSE),\"\")","v":""},{"$f":"IF(P21=\"\",\"\",IF(OR('1_Eingabe_Grunddaten'!A19=\"\",'1_Eingabe_Grunddaten'!C19=\"\"),\"\",'1_Eingabe_Grunddaten'!C19))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Detail der vorliegenden Zahlung",null,null,null,null,null,null,null,null,"Fr."]
["Bau-/Lieferaufträge",null,null,null,null,null,null,"Dienstleistungsaufträge",null,null,null,null,null,null,null,"Abgerechnete Leistung",null,null,null,null,null,null,null,null,29200]
[null," Akkord",null,null,null,null,null,"X"," Kostentarif",null,null,null,null,null,null,"-",null,"Rabatt",null,null,null,{"$f":"IF(Y24>0,Y25/Y24*100,0)","v":0},"%",null,0]
[null," Regie",null,null,null,null,null,null," Zeittarif",null,null,null,null,null,null,"Subtotal 1",null,null,null,null,null,null,null,null,29200]
[null," Teuerung",null,null,null,null,null,"X"," Nebenkosten",null,null,null,null,null,null,"-",null,"Garantierückbehalt",null,null,null,{"$f":"IF(Y26>0,Y27/Y26*100,0)","v":0},"%",null,0]
[null,null,null,null,null,null,null,null," Teuerung",null,null,null,null,null,null,"+",null,"Auszahlung Garantierückbehalt",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal 2",null,null,null,null,null,null,null,null,29200]
["Baukostenart od. Benutzerdef. Leistung",null,null,null,null,null,null,null,null,null,"Mwst",null,"Fr.",null,null,"-",null,"Skonto",null,null,null,{"$f":"IF(Y29>0,Y30/Y29*100,0)","v":0},"%",null,0]
["833",null,"Kopien (Nebenkosten)",null,null,null,null,null,null,null,7.7,null,60.3,null,null,"Subtotal 3",null,null,null,null,null,null,null,null,29200]
["872",null,"Bauingenieur (Kostentarif)",null,null,null,null,null,null,null,7.7,null,3015.6,null,null,"+",null,"Zeittarif",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"Nebenkosten",null,null,null,null,null,null,584]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"Teuerung",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal 4",null,null,null,null,null,null,null,null,29784]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"Mehrwertsteuer",null,null,null,7.7,"%",null,2293.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"Variable MwSt.",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"Rundungsdifferenz",null,null,null,null,null,null,-0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal 5",null,null,null,null,null,null,null,null,32077.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"AZ 1-5 (inkl. MwSt.)",null,null,null,null,null,null,-29001.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Anweisungsbetrag",null,null,null,null,null,null,null,null,3075.9]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Übersicht Zahlungen (inkl. MwSt.)",null,null,null,null,null,null,null,null,"Fr."]
[null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M31:M43)","v":3075.9},null,null,"Bau-/Lieferaufträge:",null,null,null,null,"-","Akkord",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(AZ 1-5)",null,null,null,null,"-","Regie",null,null,0]
["Firma",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$40>0,'1_Eingabe_Grunddaten'!$C$40,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","Teuerung",null,null,0]
[null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$41>0,'1_Eingabe_Grunddaten'!$C$41,IF('1_Eingabe_Grunddaten'!$C$42>0,'1_Eingabe_Grunddaten'!$C$42,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Dienstleistungsaufträge:",null,null,null,null,"-","Kostentarif",null,null,28432.75]
[null,null,null,{"$f":"IF(AND('1_Eingabe_Grunddaten'!$C$42>0,'1_Eingabe_Grunddaten'!$C$41>0),'1_Eingabe_Grunddaten'!$C$42,IF('1_Eingabe_Grunddaten'!$C$43>0,'1_Eingabe_Grunddaten'!$C$43,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,"(AZ 1-5)",null,null,null,null,"-","Zeittarif",null,null,0]
[null,null,null,{"$f":"IF(AND('1_Eingabe_Grunddaten'!$C$43>0,'1_Eingabe_Grunddaten'!$C$41>0),'1_Eingabe_Grunddaten'!$C$43,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","Nebenkosten",null,null,568.65]
["Rg.",null,"2.18.103-NT2",null,null,"Dat.",null,"2020-06-02",null,"MwSt.-Nr.",null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$44>0,'1_Eingabe_Grunddaten'!$C$44,\"\")","v":""},null,null,null,null,null,null,null,null,"-","Teuerung",null,null,0]
[]
["Zahlbar an",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$57=\"\",\"\",'1_Eingabe_Grunddaten'!$C$57)","v":""},null,null,null,null,null,null,null,null,null,null,null,"+",null,"Garantierückbehalt inkl. MwSt.",null,null,null,null,"(AZ 1-6)",null,0]
[null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$58=\"\",\"\",'1_Eingabe_Grunddaten'!$C$58)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Subtotal",null,null,null,null,null,null,null,null,{"$f":"SUM(Y44:Y52)","v":29001.4}]
["Postkonto-Nr.",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$59=\"\",\"\",'1_Eingabe_Grunddaten'!$C$59)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Anweisungsbetrag",null,null,null,"AZ 6",null,null,null,null,{"$f":"Y41","v":3075.9}]
["IBAN",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$60=\"\",\"\",'1_Eingabe_Grunddaten'!$C$60)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(Y53:Y54)","v":32077.300000000003}]
[]
[]
["Örtliche",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$47>0,'1_Eingabe_Grunddaten'!$C$47,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Solidarbürge"]
["Bauleitung",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$48>0,'1_Eingabe_Grunddaten'!$C$48,IF('1_Eingabe_Grunddaten'!$C$49>0,'1_Eingabe_Grunddaten'!$C$49,\"\"))","v":""}]
[null,null,null,{"$f":"IF(AND('1_Eingabe_Grunddaten'!$C$49>0,'1_Eingabe_Grunddaten'!$C$48>0),'1_Eingabe_Grunddaten'!$C$49,IF('1_Eingabe_Grunddaten'!$C$50>0,'1_Eingabe_Grunddaten'!$C$50,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Bürgschaft vom"]
[null,null,null,{"$f":"IF(AND('1_Eingabe_Grunddaten'!$C$50>0,'1_Eingabe_Grunddaten'!$C$48>0),'1_Eingabe_Grunddaten'!$C$50,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Garantieschein-Nr."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gültig bis"]
["Datum",null,null,null,null,null,null,"Kontrolliert",null,null,null,null,null,null,null,"Betrag"]
[]
[]
["Ober-",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$53>0,'1_Eingabe_Grunddaten'!$C$53,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Budgetverantwortung"]
["bauleitung",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$54>0,'1_Eingabe_Grunddaten'!$C$54,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"(Gesamtkostenstelle)"]
["Datum",null,null,null,null,null,null,"Geprüft"]
["Datum",null,null,null,null,null,null,"Visiert",null,null,null,null,null,null,null,"Datum",null,null,null,null,null,null,"Visiert"]
[]
[]
["Gebucht:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zahlungsfreigabe:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V7=\"\",\"\",V7)","v":""},null,null,{"$f":"IF(X7=\"\",\"\",X7)","v":""}]
["Schlusszahlung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V8=\"\",\"\",V8)","v":"Bau"},null,null,{"$f":"IF(X8=\"\",\"\",X8)","v":"615300.501100"}]
[{"$f":"IF(A9=\"\",\"\",A9)","v":"Eigene Nummerierung"},null,null,null,null,null,null,null,null,{"$f":"IF(I9=\"\",\"\",I9)","v":"NO2, DL Brunnacker"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V9=\"\",\"\",V9)","v":"RRB/AS Nr."},null,null,{"$f":"IF(X9=\"\",\"\",X9)","v":"18.32040"}]
[]
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,5,FALSE)=\"Gebietseinheit VI\",\"\",IF(VLOOKUP(c_Zustaendig,r_Briefkopf,7,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,7,FALSE),\"\"))","v":"Gemeinde / Objekt / Baulos"},null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,5,FALSE)=\"GEVI\",\"\",IF('1_Eingabe_Grunddaten'!C11=\"\",\"\",'1_Eingabe_Grunddaten'!C11))","v":""}]
["Art der Arbeit oder Lieferung",null,null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C12=\"\",\"\",'1_Eingabe_Grunddaten'!C12)","v":""}]
[]
["Angebot",null,null,null,null,"vom",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C22=\"\",\"\",'1_Eingabe_Grunddaten'!C22)","v":""},null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,8,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,8,FALSE),\"\")","v":"KOA / Pos."},null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$10=\"\",\"\",'1_Eingabe_Grunddaten'!$C$10)","v":""}]
["Werk-/Ingenieurvertrag",null,null,null,null,"vom",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C23=\"\",\"\",'1_Eingabe_Grunddaten'!C23)","v":""},null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,10,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,10,FALSE),\"\")","v":"Kanton St.Gallen"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,11,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,11,FALSE),\"\")","v":"Nr."},{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,12,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,12,FALSE),\"\")","v":17}]
["RRB/AS",null,null,null,null,"vom",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C26=\"\",\"\",'1_Eingabe_Grunddaten'!C26)","v":""},null,"Fr.",null,{"$f":"'1_Eingabe_Grunddaten'!C27","v":0},null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,13,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,13,FALSE),\"\")","v":"Schweiz. Hauptstrasse(n)"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,14,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,14,FALSE),\"\")","v":"Nr."},{"$f":"IF(OR('1_Eingabe_Grunddaten'!$C$13=\"\",'1_Eingabe_Grunddaten'!$A$13=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$13)","v":""}]
["Nachträge Nr.",null,null,null,{"$f":"IF(E17=\"\",\"\",E17)","v":1},{"$f":"IF(F17=\"\",\"\",F17)","v":"bis"},null,null,{"$f":"IF(I17=\"\",\"\",I17)","v":2},null,"Fr.",null,{"$f":"IF(M17=\"\",\"\",M17)","v":4833.55},null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,15,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,15,FALSE),\"\")","v":"Kantonsstrasse(n)"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,16,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,16,FALSE),\"\")","v":"Nr."},{"$f":"IF(OR('1_Eingabe_Grunddaten'!$A$14=\"\",'1_Eingabe_Grunddaten'!$C$14=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$14)","v":""}]
["Total Vertragssumme",null,null,null,null,null,null,null,null,null,"Fr.",null,{"$f":"SUM(M82:M83)","v":4833.55},null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,17,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,17,FALSE),\"\")","v":"Gemeinde(n)"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,18,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,18,FALSE),\"\")","v":"Nr."},{"$f":"IF(OR('1_Eingabe_Grunddaten'!$A$15=\"\",'1_Eingabe_Grunddaten'!$C$15=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$15)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,19,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,19,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,20,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,20,FALSE),\"\")","v":""},{"$f":"IF(OR('1_Eingabe_Grunddaten'!$A$16=\"\",'1_Eingabe_Grunddaten'!$C$16=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$16)","v":""}]
["Zahlungsfrist",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$31<'1_Eingabe_Grunddaten'!$C$35,'1_Eingabe_Grunddaten'!$C$31,IF('1_Eingabe_Grunddaten'!$C$35>0,'1_Eingabe_Grunddaten'!$C$35,'1_Eingabe_Grunddaten'!$C$31))","v":0},"Tage",null,null,"Rabatt",null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$32=\"\",\"0.0\",'1_Eingabe_Grunddaten'!$C$32)","v":"0.0"},"%",null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,21,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,21,FALSE),\"\")","v":"RMS-Stationierung"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,22,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,22,FALSE),\"\")","v":"km"},{"$f":"IF(OR('1_Eingabe_Grunddaten'!$A$17=\"\",'1_Eingabe_Grunddaten'!$C$17=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$17)","v":""},{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,23,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,23,FALSE),\"\")","v":"-"},{"$f":"IF(OR('1_Eingabe_Grunddaten'!$A$17=\"\",'1_Eingabe_Grunddaten'!$C$18=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$18)","v":""}]
[null,null,null,null,null,null,null,"Skonto",null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$34=\"\",\"0.0\",'1_Eingabe_Grunddaten'!$C$34)","v":"0.0"},"%",null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,24,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,24,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,25,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,25,FALSE),\"\")","v":""},{"$f":"IF(P87=\"\",\"\",IF(OR('1_Eingabe_Grunddaten'!$A$19=\"\",'1_Eingabe_Grunddaten'!$C$19=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$19))","v":""}]
[]
["Baukostenart od. Benutzerdef. Leistung",null,null,null,null,null,null,null,null,null,"Mwst",null,"Fr.",null,null,"Detail der vorliegenden Zahlung",null,null,null,null,null,null,null,null,"Fr."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abgerechnete Leistung",null,null,null,null,null,null,null,null,{"$f":"Y24","v":29200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"Rabatt",null,null,null,{"$f":"IF($Y$24>0,$Y$25/$Y$24*100,0)","v":0},"%",null,{"$f":"Y25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal 1",null,null,null,null,null,null,null,null,{"$f":"Y26","v":29200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"Skonto",null,null,null,{"$f":"IF(Y92>0,Y93/Y92*100,0)","v":0},"%",null,{"$f":"Y30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal 2",null,null,null,null,null,null,null,null,29200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"Zeittarif",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"Nebenkosten",null,null,null,null,null,null,584]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"Teuerung",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal 3",null,null,null,null,null,null,null,null,29784]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"Mehrwertsteuer",null,null,null,{"$f":"IF($Y$35>0,$Y$36/$Y$35*100,0)","v":7.6999395648670426},"%",null,2293.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"Variable MwSt.",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"Rundungsdifferenz",null,null,null,null,null,null,-0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal 4",null,null,null,null,null,null,null,null,32077.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,{"$f":"IF(R40<>\"\",R40,\"\")","v":"AZ 1-5 (inkl. MwSt.)"},null,null,null,null,null,null,-29001.4]
[null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M90:M103)","v":0},null,null,"Total Anweisungsbetrag",null,null,null,null,null,null,null,null,3075.9]
[]
["Firma",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$40>0,'1_Eingabe_Grunddaten'!$C$40,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Gesamtkosten (inkl. MwSt.)",null,null,null,null,null,null,null,null,"Fr."]
[null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$41>0,'1_Eingabe_Grunddaten'!$C$41,IF('1_Eingabe_Grunddaten'!$C$42>0,'1_Eingabe_Grunddaten'!$C$42,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Bau-/Lieferaufträge:",null,null,null,null,"-","Akkord",null,null,{"$f":"Y44","v":0}]
[null,null,null,{"$f":"IF(AND('1_Eingabe_Grunddaten'!$C$42>0,'1_Eingabe_Grunddaten'!$C$41>0),'1_Eingabe_Grunddaten'!$C$42,IF('1_Eingabe_Grunddaten'!$C$43>0,'1_Eingabe_Grunddaten'!$C$43,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","Regie",null,null,0]
[null,null,null,{"$f":"IF(AND('1_Eingabe_Grunddaten'!$C$43>0,'1_Eingabe_Grunddaten'!$C$41>0),'1_Eingabe_Grunddaten'!$C$43,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","Teuerung",null,null,0]
["Rg.",null,{"$f":"IF(C50=\"\",\"\",C50)","v":"2.18.103-NT2"},null,null,"Dat.",null,{"$f":"IF(H50=\"\",\"\",H50)","v":"2020-06-02"},null,"MwSt.-Nr.",null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$44>0,'1_Eingabe_Grunddaten'!$C$44,\"\")","v":""},null,null,null,"Dienstleistungsaufträge:",null,null,null,null,"-","Kostentarif",null,null,28432.75]
["Zahlbar an",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$57=\"\",\"\",'1_Eingabe_Grunddaten'!$C$57)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","Zeittarif",null,null,0]
[null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$58=\"\",\"\",'1_Eingabe_Grunddaten'!$C$58)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","Nebenkosten",null,null,568.65]
["Postkonto-Nr.",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$59=\"\",\"\",'1_Eingabe_Grunddaten'!$C$59)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","Teuerung",null,null,0]
["IBAN",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$60=\"\",\"\",'1_Eingabe_Grunddaten'!$C$60)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(Y107:Y113)","v":29001.4}]
["Sicherheitsleistung gemäss Werkvertrag und SIA Norm 118, Art. 181;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solidarbürge"]
["Solidarbürgschaft nach OR Art. 496;"]
["Schlussrechnung anerkannt unter Verzicht auf jede Nachforderung und"]
["unter Vorbehalt der Prüfung durch die Kant. und Eidg. Kontrollorgane!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bürgschaft vom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garantieschein-Nr."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gültig bis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Betrag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bürgschaft vom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garantieschein-Nr."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gültig bis"]
["(Datum, Stempel und Unterschrift der Firma)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Betrag"]
[]
[]
["Örtliche",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$47>0,'1_Eingabe_Grunddaten'!$C$47,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Budgetverantwortung"]
["Bauleitung",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$48>0,'1_Eingabe_Grunddaten'!$C$48,IF('1_Eingabe_Grunddaten'!$C$49>0,'1_Eingabe_Grunddaten'!$C$49,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,"(Gesamtkostenstelle)"]
[null,null,null,{"$f":"IF(AND('1_Eingabe_Grunddaten'!$C$50>0,'1_Eingabe_Grunddaten'!$C$48>0),'1_Eingabe_Grunddaten'!$C$50,IF('1_Eingabe_Grunddaten'!$C$50>0,'1_Eingabe_Grunddaten'!$C$50,\"\"))","v":""}]
["Datum",null,null,null,null,null,null,"Kontrolliert",null,null,null,null,null,null,null,"Datum",null,null,null,null,null,null,"Visiert"]
[]
[]
["Ober-",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$53>0,'1_Eingabe_Grunddaten'!$C$53,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Bauherrschaft"]
["bauleitung",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$54>0,'1_Eingabe_Grunddaten'!$C$54,\"\")","v":""}]
["Datum",null,null,null,null,null,null,"Geprüft"]
["Datum",null,null,null,null,null,null,"Visiert",null,null,null,null,null,null,null,"Datum",null,null,null,null,null,null,"Visiert"]
[]
["Gebucht.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zahlungsfreigabe:"]
["Baukostenart od. Benutzerdef. Leistung",null,null,null,null,null,null,null,null,null,"Mwst",null,"Fr.",null,null,"Baukostenart od. Benutzerdef. Leistung",null,null,null,null,null,null,"Mwst",null,"Fr."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total der Abschlagszahlung",null,{"$f":"SUM(M141:M189,Y141:Y189)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V7=\"\",\"\",V7)","v":""},null,null,{"$f":"IF(X7=\"\",\"\",X7)","v":""}]
["Beilage für variable Mehrwertsteuer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V8=\"\",\"\",V8)","v":"Bau"},null,null,{"$f":"IF(X8=\"\",\"\",X8)","v":"615300.501100"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V9=\"\",\"\",V9)","v":"RRB/AS Nr."},null,null,{"$f":"IF(X9=\"\",\"\",X9)","v":"18.32040"}]
[]
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,5,FALSE)=\"Gebietseinheit VI\",\"\",IF(VLOOKUP(c_Zustaendig,r_Briefkopf,7,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,7,FALSE),\"\"))","v":"Gemeinde / Objekt / Baulos"},null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,5,FALSE)=\"GEVI\",\"\",IF('1_Eingabe_Grunddaten'!C11=\"\",\"\",'1_Eingabe_Grunddaten'!C11))","v":""}]
["Art der Arbeit oder Lieferung",null,null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$12=\"\",\"\",'1_Eingabe_Grunddaten'!$C$12)","v":""}]
[]
["Angebot",null,null,null,null,"vom",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$22=\"\",\"\",'1_Eingabe_Grunddaten'!$C$22)","v":""},null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,8,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,8,FALSE),\"\")","v":"KOA / Pos."},null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$10=\"\",\"\",'1_Eingabe_Grunddaten'!$C$10)","v":""}]
["Werk-/Ingenieurvertrag",null,null,null,null,"vom",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$23=\"\",\"\",'1_Eingabe_Grunddaten'!$C$23)","v":""},null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,10,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,10,FALSE),\"\")","v":"Kanton St.Gallen"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,11,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,11,FALSE),\"\")","v":"Nr."},{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,12,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,12,FALSE),\"\")","v":17}]
["RRB/AS",null,null,null,null,"vom",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$26=\"\",\"\",'1_Eingabe_Grunddaten'!$C$26)","v":""},null,"Fr.",null,{"$f":"'1_Eingabe_Grunddaten'!$C$27","v":0},null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,13,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,13,FALSE),\"\")","v":"Schweiz. Hauptstrasse(n)"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,14,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,14,FALSE),\"\")","v":"Nr."},{"$f":"IF(OR('1_Eingabe_Grunddaten'!$C$13=\"\",'1_Eingabe_Grunddaten'!$A$13=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$13)","v":""}]
["Nachräge Nr.",null,null,null,{"$f":"IF($E$17=\"\",\"\",$E$17)","v":1},{"$f":"IF($F$17=\"\",\"\",$F$17)","v":"bis"},null,null,{"$f":"IF($I$17=\"\",\"\",$I$17)","v":2},null,"Fr.",null,{"$f":"IF($M$17=\"\",\"\",$M$17)","v":4833.55},null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,15,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,15,FALSE),\"\")","v":"Kantonsstrasse(n)"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,16,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,16,FALSE),\"\")","v":"Nr."},{"$f":"IF(OR('1_Eingabe_Grunddaten'!$A$14=\"\",'1_Eingabe_Grunddaten'!$C$14=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$14)","v":""}]
["Total Vertragssumme",null,null,null,null,null,null,null,null,null,"Fr.",null,{"$f":"SUM(M201:M202)","v":4833.55},null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,17,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,17,FALSE),\"\")","v":"Gemeinde(n)"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,18,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,18,FALSE),\"\")","v":"Nr."},{"$f":"IF(OR('1_Eingabe_Grunddaten'!$A$15=\"\",'1_Eingabe_Grunddaten'!$C$15=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$15)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,19,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,19,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,20,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,20,FALSE),\"\")","v":""},{"$f":"IF(OR('1_Eingabe_Grunddaten'!$A$16=\"\",'1_Eingabe_Grunddaten'!$C$16=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$16)","v":""}]
["Zahlungsfrist",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$31<'1_Eingabe_Grunddaten'!$C$35,'1_Eingabe_Grunddaten'!$C$31,IF('1_Eingabe_Grunddaten'!$C$35>0,'1_Eingabe_Grunddaten'!$C$35,'1_Eingabe_Grunddaten'!$C$31))","v":0},"Tage",null,null,"Rabatt",null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$32=\"\",\"0.0\",'1_Eingabe_Grunddaten'!$C$32)","v":"0.0"},"%",null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,21,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,21,FALSE),\"\")","v":"RMS-Stationierung"},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,22,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,22,FALSE),\"\")","v":"km"},{"$f":"IF(OR('1_Eingabe_Grunddaten'!$A$17=\"\",'1_Eingabe_Grunddaten'!$C$17=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$17)","v":""},{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,23,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,23,FALSE),\"\")","v":"-"},{"$f":"IF(OR('1_Eingabe_Grunddaten'!$A$17=\"\",'1_Eingabe_Grunddaten'!$C$18=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$18)","v":""}]
[null,null,null,null,null,null,null,"Skonto",null,{"$f":"IF('1_Eingabe_Grunddaten'!$C$34=\"\",\"0.0\",'1_Eingabe_Grunddaten'!$C$34)","v":"0.0"},"%",null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,24,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,24,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,25,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,25,FALSE),\"\")","v":""},{"$f":"IF(P206=\"\",\"\",IF(OR('1_Eingabe_Grunddaten'!$A$19=\"\",'1_Eingabe_Grunddaten'!$C$19=\"\"),\"\",'1_Eingabe_Grunddaten'!$C$19))","v":""}]
[]
["Detail des vorliegenden MwSt-Wechsels",null,null,null,null,null,null,null,null,null,null,null,"Fr.",null,null,"Detail des vorliegenden MwSt-Wechsels",null,null,null,null,null,null,null,null,"Fr."]
["von 8 auf 7.7 %"]
["Abgerechnete Leistung bis AZ Nr. 9",null,null,null,null,null,null,null,null,null,null,null,836918.15]
["-","Rabatt",null,null,null,null,null,{"$f":"IF(OR(c_DruckRechnungMwStLeistungWert1=\"\",c_DruckRechnungMwStLeistungWert1=0),0,c_DruckRechnungMwStRabatt1/c_DruckRechnungMwStLeistungWert1*100)","v":-19.000000179228998},null,"%",null,null,-159014.45000000001,null,null,"-",null,"Rabatt",null,null,null,{"$f":"IF(OR(c_DruckRechnungMwStLeistungWert3=\"\",c_DruckRechnungMwStLeistungWert3=0),0,c_DruckRechnungMwStRabatt3/c_DruckRechnungMwStLeistungWert3*100)","v":0},"%"]
["Subtotal 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(c_DruckRechnungMwStLeistungWert1=\"\",c_DruckRechnungMwStRabatt1=\"\"),\"\",c_DruckRechnungMwStLeistungWert1+c_DruckRechnungMwStRabatt1)","v":677903.7},null,null,"Subtotal 1",null,null,null,null,null,null,null,null,{"$f":"IF(AND(c_DruckRechnungMwStLeistungWert3=\"\",c_DruckRechnungMwStRabatt3=\"\"),\"\",c_DruckRechnungMwStLeistungWert3+c_DruckRechnungMwStRabatt3)","v":""}]
["-","Garantierückbehalt",null,null,null,null,null,{"$f":"IF(OR(M212=\"\",M212=0),0,c_DruckRechnungMwStRueckbehalt1/M212*100)","v":-7.3756788759229375},{"$f":"IF(M212<>\"\",c_DruckRechnungMwStRueckbehalt1/M212*100,0)","v":-7.3756788759229375},"%",null,null,-50000,null,null,"-",null,"Garantierückbehalt",null,null,null,{"$f":"IF(OR(Y212=\"\",Y212=0),0,c_DruckRechnungMwStRueckbehalt3/Y212*100)","v":0},"%"]
["+","Auszahlung Garantierückbehalt",null,null,null,null,null,null,null,null,null,null,0,null,null,"+",null,"Auszahlung Garantierückbehalt"]
["Subtotal 2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M212=\"\",c_DruckRechnungMwStRueckbehalt1=\"\",c_DruckRechnungMwStAuszahlung1=\"\"),\"\",M212+c_DruckRechnungMwStRueckbehalt1+c_DruckRechnungMwStAuszahlung1)","v":627903.69999999995},null,null,"Subtotal 2",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Y212=\"\",c_DruckRechnungMwStRueckbehalt3=\"\",c_DruckRechnungMwStAuszahlung3=\"\"),\"\",Y212+c_DruckRechnungMwStRueckbehalt3+c_DruckRechnungMwStAuszahlung3)","v":""}]
["-","Skonto",null,null,null,null,null,null,{"$f":"IF(OR(M215=\"\",M215=0),0,c_DruckRechnungMwStSkonto1/M215*100)","v":0},"%",null,null,0,null,null,"-",null,"Skonto",null,null,null,{"$f":"IF(OR(Y215=\"\",Y215=0),0,c_DruckRechnungMwStSkonto3/Y215*100)","v":0},"%"]
["Subtotal 3",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M215=\"\",c_DruckRechnungMwStSkonto1=\"\"),\"\",M215+c_DruckRechnungMwStSkonto1)","v":627903.69999999995},null,null,"Subtotal 3",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Y215=\"\",c_DruckRechnungMwStSkonto3=\"\"),\"\",Y215+c_DruckRechnungMwStSkonto3)","v":""}]
["+","Zeittarif",null,null,null,null,null,null,null,null,null,null,0,null,null,"+",null,"Zeittarif"]
["+","Nebenkosten",null,null,null,null,null,null,null,null,null,null,0,null,null,"+",null,"Nebenkosten"]
["+","Teuerung",null,null,null,null,null,null,null,null,null,null,0,null,null,"+",null,"Teuerung"]
["Subtotal 4",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M217=\"\",c_DruckRechnungMwStNebenkosten1=\"\",c_DruckRechnungMwStZusatzleistung1=\"\",c_DruckRechnungMwStTeuerung1=\"\"),\"\",SUM(M217:M220))","v":627903.69999999995},null,null,"Subtotal 4",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Y217=\"\",c_DruckRechnungMwStNebenkosten3=\"\",c_DruckRechnungMwStZusatzleistung3=\"\",c_DruckRechnungMwStTeuerung3=\"\"),\"\",SUM(Y217:Y220))","v":""}]
["> ","Mehrwertsteuerdifferenz",null,null,null,null,null,null,-0.29999999999999982,"%",null,null,-1883.75,null,null,">",null,"Mehrwertsteuerdifferenz",null,null,null,null,"%"]
[]
[]
["Detail des vorliegenden MwSt-Wechsels",null,null,null,null,null,null,null,null,null,null,null,"Fr.",null,null,"Detail des vorliegenden MwSt-Wechsels",null,null,null,null,null,null,null,null,"Fr."]
["von 7.7 auf 8 %"]
["Abgerechnete Leistung bis AZ Nr. 15",null,null,null,null,null,null,null,null,null,null,null,1943089.75]
["-","Rabatt",null,null,null,null,null,null,{"$f":"IF(OR(c_DruckRechnungMwStLeistungWert2=\"\",c_DruckRechnungMwStLeistungWert2=0),0,c_DruckRechnungMwStRabatt2/c_DruckRechnungMwStLeistungWert2*100)","v":-18.999999871338932},"%",null,null,-369187.05,null,null,"-",null,"Rabatt",null,null,null,{"$f":"IF(OR(c_DruckRechnungMwStLeistungWert4=\"\",c_DruckRechnungMwStLeistungWert4=0),0,c_DruckRechnungMwStRabatt4/c_DruckRechnungMwStLeistungWert4*100)","v":0},"%"]
["Subtotal 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(c_DruckRechnungMwStLeistungWert2=\"\",c_DruckRechnungMwStRabatt2=\"\"),\"\",c_DruckRechnungMwStLeistungWert2+c_DruckRechnungMwStRabatt2)","v":1573902.7},null,null,"Subtotal 1",null,null,null,null,null,null,null,null,{"$f":"IF(AND(c_DruckRechnungMwStLeistungWert4=\"\",c_DruckRechnungMwStRabatt4=\"\"),\"\",c_DruckRechnungMwStLeistungWert4+c_DruckRechnungMwStRabatt4)","v":""}]
["-","Garantierückbehalt",null,null,null,null,null,null,{"$f":"IF(OR(M229=\"\",M229=0),0,c_DruckRechnungMwStRueckbehalt2/M229*100)","v":-5.0000009530449372},"%",null,null,-78695.149999999994,null,null,"-",null,"Garantierückbehalt",null,null,null,{"$f":"IF(OR(Y229=\"\",Y229=0),0,c_DruckRechnungMwStRueckbehalt4/Y229*100)","v":0},"%"]
["+","Auszahlung Garantierückbehalt",null,null,null,null,null,null,null,null,null,null,0,null,null,"+",null,"Auszahlung Garantierückbehalt"]
["Subtotal 2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M229=\"\",c_DruckRechnungMwStRueckbehalt2=\"\",c_DruckRechnungMwStAuszahlung2=\"\"),\"\",M229+c_DruckRechnungMwStRueckbehalt2+c_DruckRechnungMwStAuszahlung2)","v":1495207.55},null,null,"Subtotal 2",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Y229=\"\",c_DruckRechnungMwStRueckbehalt4=\"\",c_DruckRechnungMwStAuszahlung4=\"\"),\"\",Y229+c_DruckRechnungMwStRueckbehalt4+c_DruckRechnungMwStAuszahlung4)","v":""}]
["-","Skonto",null,null,null,null,null,null,{"$f":"IF(OR(M232=\"\",M232=0),0,c_DruckRechnungMwStSkonto2/M232*100)","v":0},"%",null,null,0,null,null,"-",null,"Skonto",null,null,null,{"$f":"IF(OR(Y232=\"\",Y232=0),0,c_DruckRechnungMwStSkonto4/Y232*100)","v":0},"%"]
["Subtotal 3",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M232=\"\",c_DruckRechnungMwStSkonto2=\"\"),\"\",M232+c_DruckRechnungMwStSkonto2)","v":1495207.55},null,null,"Subtotal 3",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Y232=\"\",c_DruckRechnungMwStSkonto4=\"\"),\"\",Y232+c_DruckRechnungMwStSkonto4)","v":""}]
["+","Zeittarif",null,null,null,null,null,null,null,null,null,null,0,null,null,"+",null,"Zeittarif"]
["+","Nebenkosten",null,null,null,null,null,null,null,null,null,null,0,null,null,"+",null,"Nebenkosten"]
["+","Teuerung",null,null,null,null,null,null,null,null,null,null,0,null,null,"+",null,"Teuerung"]
["Subtotal 4",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M234=\"\",c_DruckRechnungMwStNebenkosten2=\"\",c_DruckRechnungMwStZusatzleistung2=\"\",c_DruckRechnungMwStTeuerung2=\"\"),\"\",SUM(M234:M237))","v":1495207.55},null,null,"Subtotal 4",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Y234=\"\",c_DruckRechnungMwStNebenkosten4=\"\",c_DruckRechnungMwStZusatzleistung4=\"\",c_DruckRechnungMwStTeuerung4=\"\"),\"\",SUM(Y234:Y237))","v":""}]
["> ","Mehrwertsteuerdifferenz",null,null,null,null,null,null,0.29999999999999982,"%",null,null,4485.6000000000004,null,null,">",null,"Mehrwertsteuerdifferenz",null,null,null,null,"%"]
[]
[]
["Total Mehrwertsteuerdifferenz (Übertrag in Variable MwSt. des Abschlagszahlungsformulars)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(c_DruckRechnungMwStDifferenz1=\"\",c_DruckRechnungMwStDifferenz2=\"\",c_DruckRechnungMwStDifferenz3=\"\",c_DruckRechnungMwStDifferenz4=\"\"),\"\",c_DruckRechnungMwStDifferenz1+c_DruckRechnungMwStDifferenz2+c_DruckRechnungMwStDifferenz3+c_DruckRechnungMwStDifferenz4)","v":2601.8500000000004}]
[]
["Beilage Solidarbürgschaften"]
[]
["Solidarbürge",null,null,"Name",null,null,null,null,""]
[null,null,null,"Adresse",null,null,null,null,""]
["",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["Bürgschaft vom",null,null,null,"Garantieschein-Nr.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gültig bis",null,null,null,"Betrag"]
["",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
["",null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(W250:Y295)","v":0}]

{"sheet":"9_Ausdruck_Garantieschein","index":9,"n_rows":69,"n_cols":25,"rows_kept":69,"cut":false,"hidden":true,"merged":[[53,0,61,1],[54,10,54,17],[60,10,60,17],[62,0,69,1],[63,10,63,17],[66,10,66,13],[66,14,66,17],[68,10,68,13],[68,14,68,17],[30,0,52,1],[52,10,52,17],[16,20,16,21],[19,9,19,23],[21,9,21,23],[22,9,22,23],[23,8,23,23],[25,13,25,16],[25,22,25,23],[26,8,26,9],[26,22,26,23],[28,22,28,23],[29,10,29,13],[29,14,29,17],[15,9,15,11],[10,9,10,23],[11,9,11,23],[12,9,12,23],[13,9,13,11],[14,9,14,11]]}
["Kanton St.Gallen"]
["Bau- und Umweltdepartement"]
[]
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,4,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,4,FALSE),\"\")","v":"Tiefbauamt"}]
[{"$f":"IF(VLOOKUP(c_Zustaendig,r_Briefkopf,26,FALSE)>0,VLOOKUP(c_Zustaendig,r_Briefkopf,26,FALSE),\"\")","v":"Amtsleitung"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Angaben zum Garantieschein (Solidarbürgschaft)"]
[]
[]
["KOA / Pos.",null,null,null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C10=\"\",\"\",'1_Eingabe_Grunddaten'!C10)","v":""}]
["Gemeinde / Objekt / Baulos",null,null,null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C10=\"\",\"\",'1_Eingabe_Grunddaten'!C11)","v":""}]
["Art der Arbeit oder Lieferung",null,null,null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C12=\"\",\"\",'1_Eingabe_Grunddaten'!C12)","v":""}]
["Angebot",null,null,null,null,null,null,null,null,"vom",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C22=\"\",\"\",'1_Eingabe_Grunddaten'!C22)","v":""}]
["Werk-/Ingenieurvertrag",null,null,null,null,null,null,null,null,"vom",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C23=\"\",\"\",'1_Eingabe_Grunddaten'!C23)","v":""}]
["RRB/AS",null,null,null,null,null,null,null,null,"vom",null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C26=\"\",\"\",'1_Eingabe_Grunddaten'!C26)","v":""},null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C25=\"\",\"\",\"Nr.  \" & '1_Eingabe_Grunddaten'!C25)","v":""},null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C27=\"\",\"\",'1_Eingabe_Grunddaten'!C27)","v":""}]
[null,null,null,""]
["Total Vertragssumme",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X16:X17)","v":0}]
[]
["Firma",null,null,null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C40=\"\",\"\",'1_Eingabe_Grunddaten'!C40 &  \", \" & '1_Eingabe_Grunddaten'!C43)","v":""}]
[]
["Örtliche Bauleitung",null,null,null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C47=\"\",\"\",'1_Eingabe_Grunddaten'!C47)","v":""}]
["Oberbauleitung",null,null,null,null,null,null,null,null,{"$f":"IF('1_Eingabe_Grunddaten'!C53=\"\",\"\",'1_Eingabe_Grunddaten'!C53 & \", \" & '1_Eingabe_Grunddaten'!C54)","v":""}]
[]
[]
["Sicherheitsleistungen nach SIA 118",null,null,null,null,null,null,null,null,"Ausgabe",null,null,null,"2013"]
[]
["Schlussrechnung - Solidarbürgschaft"]
[]
[null,null,null,null,null,null,null,null,null,null,"Garantieschein \n5 Jahre",null,null,null,"Garantieschein \n6 Jahre"]
["Schlussrechnung - Solidarbürgschaft"]
[null,null,"NPK","Leistungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPK","Leistungen",null,null,null,18]
[null,null,112,"Prüfungen",null,null,null,null,null,null,null,"Fr.",10000,null,null,"Fr.",3311.95,null,null,112,"Prüfungen"]
[null,null,113,"Baustelleneinrichtung",null,null,null,null,null,null,null,"Fr.",62608.45]
[null,null,117,"Abbrüche und Demontagen",null,null,null,null,null,null,null,"Fr.",55733.95]
[null,null,121,"Sichern, unterfangen, verstärken u",null,null,null,null,null,null,null,"Fr.",48141.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fr.",2523.65,null,null,131,"Instandsetzung u. Schutz v. Betonb"]
[null,null,151,"Bauarbeiten für Werkleitungen",null,null,null,null,null,null,null,"Fr.",5514.55]
[null,null,161,"Wasserhaltung",null,null,null,null,null,null,null,"Fr.",2641.5]
[null,null,171,"Pfähle",null,null,null,null,null,null,null,"Fr.",57586]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fr.",12724.95,null,null,172,"Abdicht. f. Bauten unter Terrain u"]
[null,null,211,"Baugruben u. Erdbau",null,null,null,null,null,null,null,"Fr.",16731.55]
[null,null,221,"Fundationsschichten für Verkehrsan",null,null,null,null,null,null,null,"Fr.",11891.15]
[null,null,222,"Pflästerungen und Abschlüsse",null,null,null,null,null,null,null,"Fr.",20894.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fr.",60532.85,null,null,223,"Belagsarbeiten"]
[null,null,237,"Kanalisationen und Entwässerungen",null,null,null,null,null,null,null,"Fr.",8986.85]
[null,null,241,"Ortbetonbau",null,null,null,null,null,null,null,"Fr.",208598.3]
[null,null,246,"Spannsysteme",null,null,null,null,null,null,null,"Fr.",25977.15]
[null,null,247,"Lehr-, Schutz- und Montagegerüste",null,null,null,null,null,null,null,"Fr.",21371.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fr.",30821.200000000001,null,null,281,"Fahrzeugrückhaltesysteme u. Geländ"]
[]
[null,null,"Total",null,null,null,null,null,null,null,null,"Fr.",{"$f":"SUM(M32:M51)","v":556676.85},null,null,"Fr.",{"$f":"SUM(Q32:Q51)","v":109914.59999999999}]
[null,null,"Totalsumme",null,null,null,null,null,null,null,{"$f":"M52+Q52","v":666591.44999999995}]
["Haftungsbetrag nach SIA 118, Art. 181"]
[null,null,"Prozentsatz / Pauschale",null,null,null,null,null,null,null,{"$f":"IF(N26=\"1977 / 1991\",IF(c_GarantieTotalsumme<=200000,10/100,IF(AND(c_GarantieTotalsumme>200000,c_GarantieTotalsumme<=400000),20000/c_GarantieTotalsumme,IF(AND(c_GarantieTotalsumme>400000,c_GarantieTotalsumme<=20000000),5/100,IF(c_GarantieTotalsumme>20000000,1000000/c_GarantieTotalsumme)))),IF(N26=\"2013\",IF(c_GarantieTotalsumme<=300000,10/100,IF(AND(c_GarantieTotalsumme>300000,c_GarantieTotalsumme<=600000),30000/c_GarantieTotalsumme,IF(AND(c_GarantieTotalsumme>600000,c_GarantieTotalsumme<=40000000),5/100,IF(c_GarantieTotalsumme>40000000,2000000/c_GarantieTotalsumme)))),IF(N26=\"\",'1_Eingabe_Grunddaten'!C33/100)))","v":0.05}]
[]
[]
[null,null,"Garantiescheinbeträge",null,null,null,null,null,null,null,null,"Fr.",{"$f":"ROUND(M52*K55*2,1)/2","v":27833.85},null,null,"Fr.",{"$f":"ROUND(Q52*K55*2,1)/2","v":5495.75}]
[]
[]
[null,null,"Total Haftungsbetrag",null,null,null,null,null,null,null,{"$f":"M58+Q58","v":33329.599999999999},"Fr.",{"$f":"ROUND(M55*K58*2,1)/2","v":0},null,null,"Fr.",{"$f":"ROUND(Q55*K58*2,1)/2","v":0}]
[]
["Fristen"]
[null,null,"Abnahmedatum",null,null,null,null,null,null,null,"25.02.2020"]
[]
[]
[null,null,"Ablauf Rügefrist",null,null,null,null,null,null,null,"24.02.2023  (3 J.)",null,null,null,"24.02.2025  (5 J.)"]
[]
[null,null,"Ablauf Verjährungsfrist / Bürgschaftsverpf.",null,null,null,null,null,null,null,"24.02.2025  (5 J.)",null,null,null,"24.02.2026  (6 J.)"]

{"sheet":"10_Stammdaten","index":10,"n_rows":216,"n_cols":26,"rows_kept":216,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
["Bereichname = r_Briefkopf",null,null,null,"Zellenname = c_Zustaendig","GEVI"]
["Liste der Abteilungen",null,null,null,1,15]
["Index: c_Zustaendig","Variable: KopfTextLinks1","Variable: KopfTextLinks2","Variable: KopfTextLinks4","Variable: KopfTestLinks5","c_Verrechnungsort","c_GemeindeObjektBaulos","c_KOAPOSBKAKONT","c_BauUnterhalt","c_Projektbezeichnung1","c_ProjektbezeichnungNr1","c_ProjektbezeichnungText1","c_Projektbezeichnung2","c_ProjektbezeichnungNr2","c_Projektbezeichnung3","c_ProjektbezeichnungNr3","c_Projektbezeichnung4","c_ProjektbezeichnungNr4","c_Projektbezeichnung5","c_ProjektbezeichnungNr5","c_Projektbezeichnung6","c_ProjektbezeichnungNr6","c_TrennstrichProjbez6","c_Projektbezeichnung7","c_ProjektbezeichnungNr7","Variable: KopfTextLins5Druck"]
[1,"Kanton St.Gallen","Bau- und Umweltdepartement","Tiefbauamt","Amtsleitung",615000,"Gemeinde / Objekt / Baulos","KOA / Pos.",null,"Kanton St.Gallen","Nr.",17,"Schweiz. Hauptstrasse(n)","Nr.","Kantonsstrasse(n)","Nr.","Gemeinde(n)","Nr.",null,null,"RMS-Stationierung","km","-",null,null,"Amtsleitung"]
[16,"Kanton St.Gallen","Bau- und Umweltdepartement","Tiefbauamt","Mobilität und Planung (Sektionen/Fachstellen)","615000","Gemeinde / Objekt / Baulos","KOA / Pos.",null,"Kanton St.Gallen","Nr.",17,"Schweiz. Hauptstrasse(n)","Nr.","Kantonsstrasse(n)","Nr.","Gemeinde(n)","Nr.",null,null,"RMS-Stationierung","km","-",null,null,"Mobilität und Planung"]
[19,"Kanton St.Gallen","Bau- und Umweltdepartement","Tiefbauamt","Mobilität und Planung (Verkehrstechnik)","615300","Gemeinde / Objekt / Baulos","KOA / Pos.",null,"Kanton St.Gallen","Nr.",17,"Schweiz. Hauptstrasse(n)","Nr.","Kantonsstrasse(n)","Nr.","Gemeinde(n)","Nr.",null,null,"RMS-Stationierung","km","-",null,null,"Mobilität und Planung"]
[2,"Kanton St.Gallen","Bau- und Umweltdepartement","Tiefbauamt","Strassen- und Kunstbauten (Bau)","615300.501100","Gemeinde / Objekt / Baulos","Projektnummer","Bau","Kanton St.Gallen","Nr.",17,"Schweiz. Hauptstrasse(n)","Nr.","Kantonsstrasse(n)","Nr.","Gemeinde(n)","Nr.","Bauabschnitt","Nr.","RMS-Stationierung","km","-",null,null,"Strassen- und Kunstbauten"]
[3,"Kanton St.Gallen","Bau- und Umweltdepartement","Tiefbauamt","Strassen- und Kunstbauten (Unterhalt)",615300,"Gemeinde / Objekt / Baulos","KOA / Pos.","Unterhalt","Kanton St.Gallen","Nr.",17,"Schweiz. Hauptstrasse(n)","Nr.","Kantonsstrasse(n)","Nr.","Gemeinde(n)","Nr.",null,null,"RMS-Stationierung","km","-",null,null,"Strassen- und Kunstbauten"]
[4,"Kanton St.Gallen","Bau- und Umweltdepartement","Tiefbauamt","Kantonales Strasseninspektorat ",615300,"Gemeinde / Objekt / Baulos","KOA / Pos.","Unterhalt","Kanton St.Gallen","Nr.",17,"Schweiz. Hauptstrasse(n)","Nr.","Kantonsstrasse(n)","Nr.","Gemeinde(n)","Nr.",null,null,"RMS-Stationierung","km","-",null,null,"Kantonales Strasseninspektorat"]
[5,"Kanton St.Gallen","Bau- und Umweltdepartement","Tiefbauamt","Strassenkreisinspektorat St.Gallen",615300,"Gemeinde / Objekt / Baulos","KOA / Pos.","Unterhalt","Kanton St.Gallen","Nr.",17,"Schweiz. Hauptstrasse(n)","Nr.","Kantonsstrasse(n)","Nr.","Gemeinde(n)","Nr.",null,null,"RMS-Stationierung","km","-",null,null,"Strassenkreisinspektorat St.Gallen"]
[6,"Kanton St.Gallen","Bau- und Umweltdepartement","Tiefbauamt","Strassenkreisinspektorat Buchs",615300,"Gemeinde / Objekt / Baulos","KOA / Pos.","Unterhalt","Kanton St.Gallen","Nr.",17,"Schweiz. Hauptstrasse(n)","Nr.","Kantonsstrasse(n)","Nr.","Gemeinde(n)","Nr.",null,null,"RMS-Stationierung","km","-",null,null,"Strassenkreisinspektorat Buchs"]
[7,"Kanton St.Gallen","Bau- und Umweltdepartement","Tiefbauamt","Strassenkreisinspektorat Schmerikon",615300,"Gemeinde / Objekt / Baulos","KOA / Pos.","Unterhalt","Kanton St.Gallen","Nr.",17,"Schweiz. Hauptstrasse(n)","Nr.","Kantonsstrasse(n)","Nr.","Gemeinde(n)","Nr.",null,null,"RMS-Stationierung","km","-",null,null,"Strassenkreisinspektorat Schmerikon"]
[8,"Kanton St.Gallen","Bau- und Umweltdepartement","Tiefbauamt","Strassenkreisinspektorat Wattwil",615300,"Gemeinde / Objekt / Baulos","KOA / Pos.","Unterhalt","Kanton St.Gallen","Nr.",17,"Schweiz. Hauptstrasse(n)","Nr.","Kantonsstrasse(n)","Nr.","Gemeinde(n)","Nr.",null,null,"RMS-Stationierung","km","-",null,null,"Strassenkreisinspektorat Wattwil"]
[9,"Kanton St.Gallen","Bau- und Umweltdepartement","Tiefbauamt","Strassenkreisinspektorat Gossau",615300,"Gemeinde / Objekt / Baulos","KOA / Pos.","Unterhalt","Kanton St.Gallen","Nr.",17,"Schweiz. Hauptstrasse(n)","Nr.","Kantonsstrasse(n)","Nr.","Gemeinde(n)","Nr.",null,null,"RMS-Stationierung","km","-",null,null,"Strassenkreisinspektorat Gossau"]
[10,"Kanton St.Gallen","Bau- und Umweltdepartement","Tiefbauamt","Steinbruch Starkenbach","615900","Gemeinde / Objekt / Baulos","KOA / Pos.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steinbruch Starkenbach"]
[11,"Kanton St.Gallen","Bau- und Umweltdepartement","Amt für Wasser und Energie","Wasserbau (Bau)","625200.314100","Gemeinde / Objekt / Baulos","Projektnummer","Bau","Kanton St.Gallen","Nr.",17,"Einzugsgebiet","Nr.","Gewässer",null,"Gemeinde(n)","Nr.","Kapitel / Subventionsabr.","Nr.","Kilometrierung","km","-",null,null,"Wasserbau"]
[12,"Kanton St.Gallen","Bau- und Umweltdepartement","Amt für Wasser und Energie","Wasserbau (Unterhalt)","625200.315100","Gemeinde / Objekt / Baulos","KOA / Pos.","Unterhalt","Kanton St.Gallen","Nr.",17,"Einzugsgebiet","Nr.","Gewässer",null,"Gemeinde(n)","Nr.","Kapitel / Subventionsabr.","Nr.","Kilometrierung","km","-",null,null,"Wasserbau"]
[13,"Kanton St.Gallen","Bau- und Umweltdepartement","Amt für Wasser und Energie","Wasserbau (Hafenanlagen)","625200.314920","Gemeinde / Objekt / Baulos","Projektnummer","Hafenanlagen","Kanton St.Gallen","Nr.",17,"Einzugsgebiet","Nr.","Gewässer",null,"Gemeinde(n)","Nr.","Kapitel / Subventionsabr.","Nr.","Kilometrierung","km","-",null,null,"Wasserbau"]
[14,"Kanton St.Gallen","Bau- und Umweltdepartement","Amt für Wasser und Energie","Wasserbau (Aufträge an Dritte)","625200.318800","Gemeinde / Objekt / Baulos","Projektnummer","Dritte","Kanton St.Gallen","Nr.",17,"Einzugsgebiet","Nr.","Gewässer",null,"Gemeinde(n)","Nr.","Kapitel / Subventionsabr.","Nr.","Kilometrierung","km","-",null,null,"Wasserbau"]
[17,"Kanton St.Gallen","Bau- und Umweltdepartement","Amt für Wasser und Energie","Naturgefahren (Aufträge an Dritte)","625300.318800","Gemeinde / Objekt / Baulos","Projektnummer","Dritte","Kanton St.Gallen","Nr.",17,"Einzugsgebiet","Nr.","Gewässer",null,"Gemeinde(n)","Nr.","Kapitel / Subventionsabr.","Nr.","Kilometrierung","km","-",null,null,"Naturgefahren"]
[18,"Kanton St.Gallen","Bau- und Umweltdepartement","Amt für Wasser und Energie","Rhein und Hydrometrie (Aufträge an Dritte)","625100.318800","Gemeinde / Objekt / Baulos","Projektnummer","Dritte","Kanton St.Gallen","Nr.",17,"Einzugsgebiet","Nr.","Gewässer",null,"Gemeinde(n)","Nr.","Kapitel / Subventionsabr.","Nr.","Kilometrierung","km","-",null,null,"Rhein und Hydrometrie"]
[15,"Tiefbauamt Kanton St.Gallen","Nationalstrassen Gebiet VI","Hauptsitz","GEVI",615401,null,"Kontierung","NS-Unterhalt","Gebietseinheit","Nr.","VI","Nationalstrassen","Nr.","Kantonsstrasse(n)","Nr.","Unterhaltsabschnitt","Nr.","Rapport-Position","Nr.",null,null,null,null,null,"GEVI"]
[]
[null,"Zellenname = \nc_AlleOderNeue","Zellenname = \nc_GarantierueckbehaltProzentODERsia",null,"Zellenname = \nc_FilenameVorlage","Zellenname = c_FileVersion"]
[null,false,"FALSCH",null,"I_Kostenkontrolle","Version 8.00"]
[]
[]
[]
["BKA","Leistung","Index","Auftragszugehörigkeit","Art der Leistung",null,"Garantiefrist","Kurzform",null,null,null,null,"Leistungsjahr"]
[21,"Grundstückserwerb",1,1,"Unternehmerleistung",null,5,"Grundstückserwerb"]
[29,"Gebäude",2,1,"Unternehmerleistung",null,5,"Gebäude",null,null,null,null,2016]
[39,"Nebenkosten",3,1,"Unternehmerleistung",null,5,"Nebenkosten",null,null,null,null,2017]
[49,"Entschädigungen",4,1,"Unternehmerleistung",null,5,"Entschädigungen",null,null,null,null,2018]
[111,"Regiearbeiten",5,2,"Unternehmerleistung",null,5,"Regiearbeiten",null,null,null,null,2019]
[112,"Prüfungen",6,1,"Unternehmerleistung",null,5,"Prüfungen",null,null,null,null,2020]
[113,"Baustelleneinrichtung",7,1,"Unternehmerleistung",null,5,"Baustelleneinrichtung",null,null,null,null,2021]
[114,"Gerüste",8,1,"Unternehmerleistung",null,5,"Gerüste",null,null,null,null,2022]
[116,"Holzen und Roden",9,1,"Unternehmerleistung",null,5,"Holzen und Roden",null,null,null,null,2023]
[117,"Abbrüche und Demontagen",10,1,"Unternehmerleistung",null,5,"Abbrüche u. Demontagen",null,null,null,null,2024]
[121,"Sichern, unterfangen, verstärken u. verschieben",11,1,"Unternehmerleistung",null,5,"Sichern, unterfangen, verstärken…",null,null,null,null,2025]
[124,"Hilfsbrücken",12,1,"Unternehmerleistung",null,5,"Hilfsbrücken",null,null,null,null,2026]
[125,"Temporäre Verkehrsführung",13,1,"Unternehmerleistung",null,5,"Temporäre Verkehrsführung",null,null,null,null,2027]
[131,"Instandsetzung u. Schutz v. Betonbauten",14,1,"Unternehmerleistung",null,6,"Instandsetzung u. Schutz v. Betonb.",null,null,null,null,2028]
[132,"Bohren u. Trennen von Beton u. Mauerwerk",15,1,"Unternehmerleistung",null,5,"Bohren u. Trennen",null,null,null,null,2029]
[151,"Bauarbeiten für Werkleitungen",16,1,"Unternehmerleistung",null,5,"Bauarbeiten für Werkleitungen",null,null,null,null,2030]
[152,"Rohrvortrieb",17,1,"Unternehmerleistung",null,5,"Rohrvortrieb",null,null,null,null,2031]
[161,"Wasserhaltung",18,1,"Unternehmerleistung",null,5,"Wasserhaltung",null,null,null,null,2032]
[162,"Baugrubenabschlüsse u. Aussteifungen",19,1,"Unternehmerleistung",null,5,"Baugrubenabschl. U. Aussteifungen"]
[164,"Verankerungen u. Nagelwände",20,1,"Unternehmerleistung",null,5,"Verankerungen u. Nagelwände"]
[171,"Pfähle",21,1,"Unternehmerleistung",null,5,"Pfähle"]
[172,"Abdicht. f. Bauten unter Terrain u. f. Brücken",22,1,"Unternehmerleistung",null,6,"Abdichtungen"]
[173,"Baugrundverbesserungen",23,1,"Unternehmerleistung",null,5,"Baugrundverbesserungen"]
[181,"Garten- und Landschaftsbau",24,1,"Unternehmerleistung",null,5,"Garten- und Landschaftsbau"]
[183,"Zäune und Arealeingänge",25,1,"Unternehmerleistung",null,5,"Zäune und Arealeingänge"]
[184,"Pflege v. Grün- u. Freiflächen",26,1,"Unternehmerleistung",null,5,"Pflege v. Grün- u. Freiflächen"]
[188,"Lärmschutzwände",27,1,"Unternehmerleistung",null,5,"Lärmschutzwände"]
[189,"Hochbauten: Stützpunkte u. Werkhöfe",28,1,"Unternehmerleistung",null,5,"Hochbauten: Stützpunkte+Werkhöfe"]
[211,"Baugruben u. Erdbau",29,1,"Unternehmerleistung",null,5,"Baugruben u. Erdbau"]
[213,"Wasserbau",30,1,"Unternehmerleistung",null,5,"Wasserbau"]
[214,"Lawinen- u. Steinschlagverbau",31,1,"Unternehmerleistung",null,5,"Lawinen- u. Steinschlagverbau"]
[216,"Altlasten, belastete Standorte und Entsorgung",32,1,"Unternehmerleistung",null,5,"Altlasten und Entsorgung"]
[221,"Fundationsschichten für Verkehrsanlagen",33,1,"Unternehmerleistung",null,5,"Fundationsschichten für Verkehrsa."]
[222,"Pflästerungen und Abschlüsse",34,1,"Unternehmerleistung",null,5,"Pflästerungen und Abschlüsse"]
[223,"Belagsarbeiten",35,1,"Unternehmerleistung",null,6,"Belagsarbeiten"]
[226,"Materialaufbereitung",36,1,"Unternehmerleistung",null,5,"Materialaufbereitung"]
[237,"Kanalisationen und Entwässerungen",37,1,"Unternehmerleistung",null,5,"Kanalisation und Entwässerung"]
[241,"Ortbetonbau",38,1,"Unternehmerleistung",null,5,"Ortbetonbau"]
[244,"Lager u. Fahrbahnübergänge f. Brücken",39,1,"Unternehmerleistung",null,6,"Lager u. Fahrbahnübergänge"]
[246,"Spannsysteme",40,1,"Unternehmerleistung",null,5,"Spannsysteme"]
[247,"Lehr-, Schutz- und Montagegerüste",41,1,"Unternehmerleistung",null,5,"Lehr-, Schutz- und Montagegerüste"]
[261,"Sprengvortrieb im Fels SPV",42,1,"Unternehmerleistung",null,5,"Sprengvortrieb im Fels SPV"]
[262,"Tunnelbohrmaschinen-Vortrieb im Fels TBM",43,1,"Unternehmerleistung",null,5,"Tunnelbohrmaschinen-Vortr. im Fels"]
[263,"Maschinenunterstützter Vortrieb im Fels MUF",44,1,"Unternehmerleistung",null,5,"Maschinenunterstützter Vort. im Fels"]
[264,"Masch.unterstü. Vortrieb im Lockergestein MUL",45,1,"Unternehmerleistung",null,5,"Masch.unterst. Vortr. im Lockergest."]
[265,"Schildmaschinen-Vortrieb im Lockergestein SM",46,1,"Unternehmerleistung",null,5,"Schildmasch.-Vortr. im Lockergest."]
[266,"Ausbruchsicherungen im Untertagbau",47,1,"Unternehmerleistung",null,5,"Ausbruchssicherungen im Untertagb."]
[267,"Bauhilfsmassnahmen im Untertagbau",48,1,"Unternehmerleistung",null,5,"Bauhilfsmassnahmen im Untertagb."]
[268,"Wasserhaltung im Untertagbau",49,1,"Unternehmerleistung",null,5,"Wasserhaltung im Untertagbau"]
[271,"Abdichtungen im Untertagbau",50,1,"Unternehmerleistung",null,5,"Abdichtungen im Untertagbau"]
[272,"Entwässerungen im Untertagbau",51,1,"Unternehmerleistung",null,5,"Entwässerungen im Untertagbau"]
[273,"Verkleidungen im Untertagbau",52,1,"Unternehmerleistung",null,5,"Verkleidungen im Untertagbau"]
[274,"Innenausbau im Untertagbau",53,1,"Unternehmerleistung",null,5,"Innenausbau im Untertagbau"]
[275,"Kabelrohranlagen im Untertagbau",54,1,"Unternehmerleistung",null,5,"Kabelrohranlagen im Untertagbau"]
[276,"Vorauserkund. und Überwach. im Untertagbau",55,1,"Unternehmerleistung",null,5,"Vorauserkundungen u. Überwach."]
[281,"Fahrzeugrückhaltesysteme u. Geländer",56,1,"Unternehmerleistung",null,6,"Rückhaltesysteme u. Geländer"]
[282,"Signalisierung: Strassensignale",57,1,"Unternehmerleistung",null,5,"Signalisierung: Strassensignale"]
[283,"Signalisierung: Grossflächentafeln",58,1,"Unternehmerleistung",null,5,"Signalisierung: Grossflächentafeln"]
[284,"Signalisierung: Verkehrsbeeinflussungsanlagen",59,1,"Unternehmerleistung",null,5,"Verkehrsbeeinflussungsanlagen"]
[286,"Markierung auf Verkehrsflächen",60,1,"Unternehmerleistung",null,5,"Markierung auf Verkehrsflächen"]
[314,"Maurerarbeiten",61,1,"Unternehmerleistung",null,5,"Maurerarbeiten"]
[321,"Montagebau in Stahl",62,1,"Unternehmerleistung",null,6,"Montagebau in Stahl"]
[331,"Tragkonstruktion",63,1,"Unternehmerleistung",null,5,"Zimmerarbeiten: Tragkonstruktion"]
[333,"Bekleidungen und Ausbau",64,1,"Unternehmerleistung",null,5,"Holzbau: Bekleidungen und Ausbau"]
[411,"Werkleitungen für Wasser und Gas",65,1,"Unternehmerleistung",null,5,"Werkleitungen für Wasser und Gas"]
[591,"Energieversorgung",66,1,"Unternehmerleistung",null,5,"Energieversorgung"]
[592,"Beleuchtung",67,1,"Unternehmerleistung",null,5,"Beleuchtung"]
[593,"Lüftung",68,1,"Unternehmerleistung",null,5,"Lüftung"]
[594,"Signalisationsmittel",69,1,"Unternehmerleistung",null,5,"Signalisationsmittel"]
[595,"Mess- u. Überwachungsanlagen",70,1,"Unternehmerleistung",null,5,"Mess- u. Überwachungsanlagen"]
[596,"Zentraleinrichtungen",71,1,"Unternehmerleistung",null,5,"Zentraleinrichtungen"]
[597,"Kabelanlagen",72,1,"Unternehmerleistung",null,5,"Kabelanlagen"]
[598,"Bauliche Massnahmen",73,1,"Unternehmerleistung",null,5,"Bauliche Massnahmen"]
[599,"Nebeneinrichtungen",74,1,"Unternehmerleistung",null,5,"Nebeneinrichtungen"]
[831,"Muster und Materialprüfungen",75,1,"Ingenieurleistung",null,5,"Muster und Materialprüfungen"]
[833,"Vervielfältigungen und Plankopien (Nebenkosten)",76,6,"Ingenieurleistung",null,5,"Kopien (Nebenkosten)"]
[835,"Versicherungen",77,1,"Ingenieurleistung",null,5,"Versicherungen"]
[851,"Projektleitung u. Projektbegleitung d. Bauherr",78,5,"Ingenieurleistung",null,5,"PL d. Bauherr"]
[872,"Honorare: Bauingenieur (Kostentarif)",79,4,"Ingenieurleistung","Kostentarif",5,"Bauingenieur (Kostentarif)"]
[872,"Honorare: Bauingenieur (Zeittarif)",80,5,"Ingenieurleistung","Zeittarif",5,"Bauingenieur (Zeittarif)"]
[873,"Honorare: Elektroingenieur (Kostentarif)",81,4,"Ingenieurleistung","Kostentarif",5,"Elektroingenieur (Kostentarif)"]
[873,"Honorare: Elektroingenieur (Zeittarif)",82,5,"Ingenieurleistung","Zeittarif",5,"Elektroingenieur (Zeittarif)"]
[876,"Honorare: Spezialisten (Kostentarif)",83,4,"Ingenieurleistung","Kostentarif",5,"Spezialisten (Kostentarif)"]
[876,"Honorare: Spezialisten (Zeittarif)",84,5,"Ingenieurleistung","Zeittarif",5,"Spezialisten (Zeittarif)"]
[882,"Teuerung (Bauaufträge)",85,3,"Ingenieurleistung",null,5,"Teuerung (Bauaufträge)"]
[882,"Teuerung (Dienstleistungsaufträge)",86,7,"Ingenieurleistung",null,5,"Teuerung (Dienstleistungsauftrag)"]
[900,"…………………………….. (BKA // Akkord)",87,1,"Unternehmerleistung"]
[901,"…………………………….. (BKA // Akkord)",88,1,"Unternehmerleistung"]
[902,"…………………………….. (BKA // Akkord)",89,1,"Unternehmerleistung"]
[903,"…………………………….. (BKA // Akkord)",90,1,"Unternehmerleistung"]
[904,"…………………………….. (BKA // Akkord)",91,1,"Unternehmerleistung"]
[905,"…………………………….. (BKA // Akkord)",92,1,"Unternehmerleistung"]
[906,"…………………………….. (BKA // Akkord)",93,1,"Unternehmerleistung"]
[907,"…………………………….. (BKA // Akkord)",94,1,"Unternehmerleistung"]
[908,"…………………………….. (BKA // Akkord)",95,1,"Unternehmerleistung"]
[909,"…………………………….. (BKA // Akkord)",96,1,"Unternehmerleistung"]
[910,"…………………………….. (BKA // Akkord)",97,1,"Unternehmerleistung"]
[911,"…………………………….. (BKA // Akkord)",98,1,"Unternehmerleistung"]
[912,"…………………………….. (BKA // Akkord)",99,1,"Unternehmerleistung"]
[913,"…………………………….. (BKA // Akkord)",100,1,"Unternehmerleistung"]
[914,"…………………………….. (BKA // Akkord)",101,1,"Unternehmerleistung"]
[915,"…………………………….. (BKA // Akkord)",102,1,"Unternehmerleistung"]
[916,"…………………………….. (BKA // Akkord)",103,1,"Unternehmerleistung"]
[917,"…………………………….. (BKA // Akkord)",104,1,"Unternehmerleistung"]
[918,"…………………………….. (BKA // Akkord)",105,1,"Unternehmerleistung"]
[919,"…………………………….. (BKA // Akkord)",106,1,"Unternehmerleistung"]
[920,"…………………………….. (BKA // Regie)",107,2,"Unternehmerleistung"]
[921,"…………………………….. (BKA // Regie)",108,2,"Unternehmerleistung"]
[922,"…………………………….. (BKA // Regie)",109,2,"Unternehmerleistung"]
[923,"…………………………….. (BKA // Regie)",110,2,"Unternehmerleistung"]
[924,"…………………………….. (BKA // Regie)",111,2,"Unternehmerleistung"]
[925,"…………………………….. (BKA // Regie)",112,2,"Unternehmerleistung"]
[926,"…………………………….. (BKA // Regie)",113,2,"Unternehmerleistung"]
[927,"…………………………….. (BKA // Regie)",114,2,"Unternehmerleistung"]
[928,"…………………………….. (BKA // Regie)",115,2,"Unternehmerleistung"]
[929,"…………………………….. (BKA // Regie)",116,2,"Unternehmerleistung"]
[930,"…………………………….. (BKA // Regie)",117,2,"Unternehmerleistung"]
[931,"…………………………….. (BKA // Regie)",118,2,"Unternehmerleistung"]
[932,"…………………………….. (BKA // Regie)",119,2,"Unternehmerleistung"]
[933,"…………………………….. (BKA // Regie)",120,2,"Unternehmerleistung"]
[934,"…………………………….. (BKA // Regie)",121,2,"Unternehmerleistung"]
[935,"…………………………….. (BKA // Regie)",122,2,"Unternehmerleistung"]
[936,"…………………………….. (BKA // Regie)",123,2,"Unternehmerleistung"]
[937,"…………………………….. (BKA // Regie)",124,2,"Unternehmerleistung"]
[938,"…………………………….. (BKA // Regie)",125,2,"Unternehmerleistung"]
[939,"…………………………….. (BKA // Regie)",126,2,"Unternehmerleistung"]
[940,"…………………………….. (BKA // Kostentarif)",127,4,"Ingenieurleistung"]
[941,"…………………………….. (BKA // Kostentarif)",128,4,"Ingenieurleistung"]
[942,"…………………………….. (BKA // Kostentarif)",129,4,"Ingenieurleistung"]
[943,"…………………………….. (BKA // Kostentarif)",130,4,"Ingenieurleistung"]
[944,"…………………………….. (BKA // Kostentarif)",131,4,"Ingenieurleistung"]
[945,"…………………………….. (BKA // Kostentarif)",132,4,"Ingenieurleistung"]
[946,"…………………………….. (BKA // Kostentarif)",133,4,"Ingenieurleistung"]
[947,"…………………………….. (BKA // Kostentarif)",134,4,"Ingenieurleistung"]
[948,"…………………………….. (BKA // Kostentarif)",135,4,"Ingenieurleistung"]
[949,"…………………………….. (BKA // Kostentarif)",136,4,"Ingenieurleistung"]
[950,"…………………………….. (BKA // Kostentarif)",137,4,"Ingenieurleistung"]
[951,"…………………………….. (BKA // Kostentarif)",138,4,"Ingenieurleistung"]
[952,"…………………………….. (BKA // Kostentarif)",139,4,"Ingenieurleistung"]
[953,"…………………………….. (BKA // Kostentarif)",140,4,"Ingenieurleistung"]
[954,"…………………………….. (BKA // Kostentarif)",141,4,"Ingenieurleistung"]
[955,"…………………………….. (BKA // Kostentarif)",142,4,"Ingenieurleistung"]
[956,"…………………………….. (BKA // Kostentarif)",143,4,"Ingenieurleistung"]
[957,"…………………………….. (BKA // Kostentarif)",144,4,"Ingenieurleistung"]
[958,"…………………………….. (BKA // Kostentarif)",145,4,"Ingenieurleistung"]
[959,"…………………………….. (BKA // Kostentarif)",146,4,"Ingenieurleistung"]
[960,"…………………………….. (BKA // Zeittarif)",147,5,"Ingenieurleistung"]
[961,"…………………………….. (BKA // Zeittarif)",148,5,"Ingenieurleistung"]
[962,"…………………………….. (BKA // Zeittarif)",149,5,"Ingenieurleistung"]
[963,"…………………………….. (BKA // Zeittarif)",150,5,"Ingenieurleistung"]
[964,"…………………………….. (BKA // Zeittarif)",151,5,"Ingenieurleistung"]
[965,"…………………………….. (BKA // Zeittarif)",152,5,"Ingenieurleistung"]
[966,"…………………………….. (BKA // Zeittarif)",153,5,"Ingenieurleistung"]
[967,"…………………………….. (BKA // Zeittarif)",154,5,"Ingenieurleistung"]
[968,"…………………………….. (BKA // Zeittarif)",155,5,"Ingenieurleistung"]
[969,"…………………………….. (BKA // Zeittarif)",156,5,"Ingenieurleistung"]
[970,"…………………………….. (BKA // Zeittarif)",157,5,"Ingenieurleistung"]
[971,"…………………………….. (BKA // Zeittarif)",158,5,"Ingenieurleistung"]
[972,"…………………………….. (BKA // Zeittarif)",159,5,"Ingenieurleistung"]
[973,"…………………………….. (BKA // Zeittarif)",160,5,"Ingenieurleistung"]
[974,"…………………………….. (BKA // Zeittarif)",161,5,"Ingenieurleistung"]
[975,"…………………………….. (BKA // Zeittarif)",162,5,"Ingenieurleistung"]
[976,"…………………………….. (BKA // Zeittarif)",163,5,"Ingenieurleistung"]
[977,"…………………………….. (BKA // Zeittarif)",164,5,"Ingenieurleistung"]
[978,"…………………………….. (BKA // Zeittarif)",165,5,"Ingenieurleistung"]
[979,"…………………………….. (BKA // Zeittarif)",166,5,"Ingenieurleistung"]
[980,"…………………………….. (BKA // Nebenkosten)",167,6,"Ingenieurleistung"]
[981,"…………………………….. (BKA // Nebenkosten)",168,6,"Ingenieurleistung"]
[982,"…………………………….. (BKA // Nebenkosten)",169,6,"Ingenieurleistung"]
[983,"…………………………….. (BKA // Nebenkosten)",170,6,"Ingenieurleistung"]
[984,"…………………………….. (BKA // Nebenkosten)",171,6,"Ingenieurleistung"]
[985,"…………………………….. (BKA // Nebenkosten)",172,6,"Ingenieurleistung"]
[986,"…………………………….. (BKA // Nebenkosten)",173,6,"Ingenieurleistung"]
[987,"…………………………….. (BKA // Nebenkosten)",174,6,"Ingenieurleistung"]
[988,"…………………………….. (BKA // Nebenkosten)",175,6,"Ingenieurleistung"]
[989,"…………………………….. (BKA // Nebenkosten)",176,6,"Ingenieurleistung"]
[990,"…………………………….. (BKA // Nebenkosten)",177,6,"Ingenieurleistung"]
[991,"…………………………….. (BKA // Nebenkosten)",178,6,"Ingenieurleistung"]
[992,"…………………………….. (BKA // Nebenkosten)",179,6,"Ingenieurleistung"]
[993,"…………………………….. (BKA // Nebenkosten)",180,6,"Ingenieurleistung"]
[994,"…………………………….. (BKA // Nebenkosten)",181,6,"Ingenieurleistung"]
[995,"…………………………….. (BKA // Nebenkosten)",182,6,"Ingenieurleistung"]
[996,"…………………………….. (BKA // Nebenkosten)",183,6,"Ingenieurleistung"]
[997,"…………………………….. (BKA // Nebenkosten)",184,6,"Ingenieurleistung"]
[998,"…………………………….. (BKA // Nebenkosten)",185,6,"Ingenieurleistung"]
[999,"…………………………….. (BKA // Nebenkosten)",186,6,"Ingenieurleistung"]