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

{"sheet":"AZ","index":0,"n_rows":55,"n_cols":11,"rows_kept":55,"merged":[[0,5,0,7],[8,6,8,7],[9,6,9,7],[54,2,54,3]]}
[null,"Dienststelle Immobilien",{"$nulls":3},"ZAHLUNGSANWEISUNG\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(H43)","v":{"v":0,"d":"Fr. 0.00"}}]
[null,"Total Auftragssumme",null,"  ",{"$f":"SUM(E20:E22)","v":{"v":0,"d":"Fr. 0.00"}},"Total Zahlungen",null,{"$f":"SUM(H21:H22)","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$25*G28)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[]
[null,"Skonto",{"$nulls":5},{"$f":"ROUND(((H25-H28-H29)*G30)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[]
[null,"Zwischentotal 1",{"$nulls":5},{"$f":"SUM(H25-H28-H29-H30)","v":{"v":0,"d":"0.00"}}]
[null,"Garantierückbehalt von Zw'total 1",null,null,"bis CHF 300'000.00",null,{"$f":"IF(OR(H32<300000,H32=300000),0.1,\" \")","v":{"v":0.1,"d":"10.00%"}},{"$f":"IF(K33>0,K33,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(H32<300000,H32=300000),0.1,0)","v":{"v":0.1,"d":"10.00%"}},{"$f":"ROUND((H$32*J33)/0.05,0)*0.05","v":0}]
[null,"Garantierückbehalt von Zw'total 1",null,null,"CHF 300'000.00 bis 600'000.00",null,{"$f":"IF(AND(H32>300000,H32<600000),\"fix\",\" \")","v":" "},{"$f":"IF(G34=\"fix\",30000,0)","v":{"v":0,"d":"0.00"}}]
[null,"Garantierückbehalt von Zw'total 1",null,null,"über CHF 600'000.00",null,null,{"$f":"IF(K35>0,K35,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(H32>600000,H32=600000),0.05,0)","v":{"v":0,"d":"0.00%"}},{"$f":"ROUND((H$32*J35)/0.05,0)*0.05","v":0}]
[]
[null,"Zwischentotal 2",{"$nulls":5},{"$f":"SUM(H32-H33-H34-H35-H36)","v":{"v":0,"d":"0.00"}}]
[null,"Akontozahlungen bis heute",null,null,"Betrag ohne Mwst."]
[]
[null,"Zwischentotal 3",{"$nulls":5},{"$f":"SUM(H37-H38-H39)","v":{"v":0,"d":"0.00"}}]
[null,"Mehrwertsteuer von Zwischentotal 3",{"$nulls":4},{"v":0.081,"d":"8.10%"},{"$f":"ROUND((H40*G41)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[]
[null,"Total (inkl. Mehrwertsteuer)",{"$nulls":4},"CHF",{"$f":"SUM(H40+H41)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Akontozahlung",null,"Nr."]
[null,"Zahlungsfrist:",null,null,{"v":45,"d":"45 Tage netto"}]
[]
[]
[null,"Visum Bauleitung / Kostenplaner",null,null,"Visum Dienststelle Immobilien",null,null,"Kopie an:"]
[]
[]
[]
[]
[]
[null,"Anweisung erstellt:    ",{"$f":"TODAY()","v":"2023-11-30"}]

{"sheet":"SZ","index":1,"n_rows":74,"n_cols":11,"rows_kept":74,"merged":[[0,5,0,7],[8,6,8,7],[9,6,9,7],[57,2,57,3]]}
[null,"Dienststelle Immobilien",{"$nulls":3},"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,"Zuschlagsverfügung:",{"$nulls":3},"Prognose Abrechnung:"]
[]
[null,"Vertragssumme:"]
[null,"Nachträge:",{"$nulls":3},"bisherige Zahlungen"]
[null,"Regie:",{"$nulls":3},"aktuelle Zahlung",null,{"$f":"SUM(H45)","v":{"v":0,"d":"Fr. 0.00"}}]
[null,"Total Auftragssumme",null,"  ",{"$f":"SUM(E20:E22)","v":{"v":0,"d":"Fr. 0.00"}},"Total Zahlungen",null,{"$f":"SUM(H21:H22)","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$25*G28)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[]
[null,"Skonto",{"$nulls":5},{"$f":"ROUND(((H25-H28-H29)*G30)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[]
[null,"Zwischentotal 1",{"$nulls":5},{"$f":"SUM(H25-H28-H29-H30)","v":{"v":0,"d":"0.00"}}]
[null,"Bauversicherung","von Zwischentotal 1 berechnet",null,null,"-",{"v":2E-3,"d":"0.20%"},{"$f":"ROUND(($H$32*G33)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(H32<300000,H32=300000),0.1,0)","v":{"v":0.1,"d":"10.00%"}},{"$f":"ROUND((H$32*J33)/0.05,0)*0.05","v":0}]
[null,"Baureinigung","von Zwischentotal 1 berechnet (wenn %)",null,null,"-"]
[null,"Bauschäden","von Zwischentotal 1 berechnet (wenn %)",null,null,"-",{"$nulls":3},{"$f":"IF(OR(H32>600000,H32=600000),0.05,0)","v":{"v":0,"d":"0.00%"}},{"$f":"ROUND((H$32*J35)/0.05,0)*0.05","v":0}]
[null,"Baureklame","von Zwischentotal 1 berechnet (wenn %)",null,null,"-"]
[null,"weitere Abzüge","von Zwischentotal 1 berechnet (wenn %)",null,null,"-"]
[]
[null,"Zwischentotal 2",{"$nulls":5},{"$f":"SUM(H32-H33-H34-H35-H36-H37)","v":{"v":0,"d":"0.00"}}]
[null,"Akontozahlungen bis heute",null,null,"Betrag ohne Mwst."]
[]
[null,"Zwischentotal 3",{"$nulls":5},{"$f":"SUM(H39-H40-H41)","v":{"v":0,"d":"0.00"}}]
[null,"Mehrwertsteuer von Zwischentotal 3",{"$nulls":4},{"v":0.081,"d":"8.10%"},{"$f":"ROUND((H42*G43)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[]
[null,"Total (inkl. Mehrwertsteuer)",{"$nulls":4},"CHF",{"$f":"SUM(H42+H43)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Schlusszahlung"]
[null,"Zahlungsfrist:",null,null,{"v":60,"d":"60 Tage netto"}]
[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":9}
[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"]