{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["EZ"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"EZ","index":0,"n_rows":79,"n_cols":11,"rows_kept":79,"merged":[[0,5,0,7],[7,6,7,7],[8,6,8,7],[53,2,53,3]]}
[{"$nulls":5},"ZAHLUNGSANWEISUNG\n\n"]
[]
[]
[null,"Rechnungsjahr"]
[null,"Beleg Nr. ",{"$nulls":3},"Standort"]
[null,"BKP-Nummer",{"$nulls":3},"Projekt"]
[null,"Arbeitsgattung",{"$nulls":3},"ID-Nummer"]
[null,"ZA-Nr.:",{"$nulls":3},"Sachkonto","50400001 Hochbauten"]
[{"$nulls":5},"Vertrags ID",45000]
[]
[null,"Postcheckkonto",{"$nulls":3},"Unternehmer"]
[null,"Bankverbindung"]
[null,"IBAN-Nr."]
[null,"Bankkonto"]
[null,"Bemerkungen"]
[]
[null,"Zuschlag:",{"$nulls":3},"Prognose Abrechnung:"]
[]
[null,"Vertragssumme:"]
[null,"Nachträge:",{"$nulls":3},"bisherige Zahlungen"]
[null,"Regie:",{"$nulls":3},"aktuelle Zahlung",null,{"$f":"SUM(H41)","v":{"v":0,"d":"Fr. 0.00"}}]
[null,"Total Auftragssumme",null,"  ",{"$f":"SUM(E19:E21)","v":{"v":0,"d":"Fr. 0.00"}},"Total Zahlungen",null,{"$f":"SUM(H20:H21)","v":{"v":0,"d":"Fr. 0.00"}}]
[]
[null,"Rechnung/Nr.",null,"vom",null,"Rechnung brutto"]
[]
[null,"Abzüge / Korrekturen"]
[null,"Rabatt",{"$nulls":5},{"$f":"ROUND(($H$24*G27)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[]
[null,"Skonto",{"$nulls":5},{"$f":"ROUND(((H24-H27)*G29)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[]
[null,"Zwischentotal 1",{"$nulls":5},{"$f":"SUM(H24-H27-H28-H29)","v":{"v":0,"d":"0.00"}}]
[null,"Bauversicherung","von Zwischentotal 1 berechnet",null,null,"-",{"v":2E-3,"d":"0.20%"},{"$f":"ROUND(($H$31*G32)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(H31<300000,H31=300000),0.1,0)","v":{"v":0.1,"d":"10.00%"}},{"$f":"ROUND((H$31*J32)/0.05,0)*0.05","v":0}]
[null,"Baureinigung","von Zwischentotal 1 berechnet (wenn %)",null,null,"-",null,{"$f":"ROUND(($H$31*G33)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Bauschäden","von Zwischentotal 1 berechnet (wenn %)",null,null,"-",null,{"$f":"ROUND(($H$31*G34)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(H31>600000,H31=600000),0.05,0)","v":{"v":0,"d":"0.00%"}},{"$f":"ROUND((H$31*J34)/0.05,0)*0.05","v":0}]
[null,"Baureklame","von Zwischentotal 1 berechnet (wenn %)",null,null,"-",null,{"$f":"ROUND(($H$31*G35)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"weitere Abzüge","von Zwischentotal 1 berechnet (wenn %)",null,null,"-",null,{"$f":"ROUND(($H$31*G36)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[]
[null,"Zwischentotal 2",{"$nulls":5},{"$f":"SUM(H31-H32-H33-H34-H36)","v":{"v":0,"d":"0.00"}}]
[null,"Mehrwertsteuer von Zwischentotal 3",{"$nulls":4},{"v":0.081,"d":"8.10%"},{"$f":"ROUND((H38*G39)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[]
[null,"Total (inkl. Mehrwertsteuer)",{"$nulls":4},"CHF",{"$f":"SUM(H38+H39)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Einzelrechnung"]
[null,"Zahlungsfrist:",null,null,"30 Tage"]
[null,"Garantieschein vorhanden"]
[]
[]
[null,"Visum Bauleitung / Kostenplaner",null,null,"Visum Dienststelle Immobilien",null,null,"Kopie an:"]
[]
[]
[]
[]
[]
[null,"Anweisung erstellt:    ",{"$f":"TODAY()","v":"2023-11-30"}]
{"$rows_empty":18}
[null,"50400001 Hochbauten"]
[null,"50600001 Mobiliar, Maschine, Apparate"]
[null,"51400001 IV a.R. Dritter Hochbauten"]
[null,"59900001 Investitionen LUKS"]
[null,"59900002 Investitionen LUPS"]
[null,"59900003 Bauprojekte Dritte"]
[null,"34300001 Baulicher Unterhalt Liegenschaften FV"]