{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Einzelrechnung","Akontozahlungen","Schlussrechnung","untersch. MwSt."],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Einzelrechnung","index":0,"n_rows":24,"n_cols":4,"rows_kept":24}
[null,"Dienststelle Immobilien"]
[]
[]
[null,"Rechnungskontrolle"]
[]
[null,"Einzelrechnungen"]
[]
[null,"Rechnungsbetrag brutto, ohne Mwst"]
[null,"Rabatt",null,{"$f":"ROUND((D8*C9)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Rabatt in Franken"]
[null,"Zwischentotal 1",null,{"$f":"SUM(D8-D9-D10)","v":{"v":0,"d":"0.00"}}]
[null,"Skonto",null,{"$f":"ROUND((D11*C12)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Zwischentotal 2",null,{"$f":"SUM(D11-D12)","v":{"v":0,"d":"0.00"}}]
[null,"Bauversicherung",{"v":2E-3,"d":"0.20%"},{"$f":"ROUND(($D$13*C14)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Bauschäden",null,{"v":0,"d":"0.00"}]
[null,"Baureinigung",null,{"v":0,"d":"0.00"}]
[null,"Baureklame, Betrag"]
[null,"Baureklame in %",null,{"v":0,"d":"0.00"}]
[null,"weitere Abzüge, Betrag"]
[null,"weitere Abzüge in %",null,{"$f":"ROUND(($D$13*C20)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Zwischentotal Abzüge",{"$f":"SUM(C14:C20)","v":{"v":2E-3,"d":"0.20%"}}]
[null,"Zwischentotal 3",null,{"$f":"SUM(D13-D14-D15-D16-D17-D18-D19-D20)","v":{"v":0,"d":"0.00"}}]
[null,"Mehrwertsteuer",{"v":0.081,"d":"8.10%"},{"$f":"SUM(D22*C23)","v":{"v":0,"d":"0.00"}}]
[null,"Zahlungsbetrag, netto, inkl. Mwst.",null,{"$f":"SUM(D22+D23)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Akontozahlungen","index":1,"n_rows":31,"n_cols":10,"rows_kept":31}
[null,"Dienststelle Immobilien"]
[]
[]
[null,"Rechnungskontrolle"]
[]
[null,"Akontozahlungen",{"$nulls":6},"Grundlage für Garantierückbehalt:"]
[]
[null,"Rechnungsbetrag brutto, ohne Mwst",{"$nulls":6},"bis Fr. 300'000  =  10%"]
[null,"Rabatt",null,{"$f":"ROUND((D8*C9)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}},{"$nulls":4},"Fr. 300'000 bis 600'000  =  fix Fr. 30'000"]
[null,"Rabatt in Franken"]
[null,"Zwischentotal 1",null,{"$f":"SUM(D8-D9-D10)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"über Fr. 600'000  =  5%"]
[null,"Skonto",null,{"$f":"ROUND((D11*C12)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Zwischentotal 2",null,{"$f":"SUM(D11-D12)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"normal","zurück rechn."]
[null,"Garantierückbehalt bis 300'000",{"v":0.1,"d":"10.00%"},{"$f":"ROUND(I14/0.05,0)*0.05","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"IF(D$13<300000.001,D$13*C14,0)","v":0},{"$f":"IF(G$17/0.9*0.1>30000,0,G$17/0.9*F14)","v":0}]
[null,"Garantierückbehalt 300'000 bis 600'000","fix",{"$f":"ROUND(I15/0.05,0)*0.05","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"IF(AND(D$13>300000,D$13<600000),30000,0)","v":0},{"$f":"IF(AND(G$17>270000,G$17<570000),30000,0)","v":0}]
[null,"Garantierückbehalt über 600'000",{"v":0.05,"d":"5.00%"},{"$f":"ROUND(I16/0.05,0)*0.05","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"IF(D$13>599999.999,D$13*C16,0)","v":0},{"$f":"IF(G$17/0.95*0.05>29999.9999,G$17/0.95*F16,0)","v":0}]
[null,"Zwischentotal 3",null,{"$f":"SUM(D13-D14-D15-D16)","v":{"v":0,"d":"0.00"}}]
[null,"1. Akontozahlungen, ohne Mwst."]
[null,"2. Akontozahlungen, ohne Mwst."]
[null,"3. Akontozahlungen, ohne Mwst."]
[null,"4. Akontozahlungen, ohne Mwst."]
[null,"5. Akontozahlungen, ohne Mwst."]
[null,"6. Akontozahlungen, ohne Mwst."]
[null,"7. Akontozahlungen, ohne Mwst."]
[null,"8. Akontozahlungen, ohne Mwst."]
[null,"9. Akontozahlungen, ohne Mwst."]
[null,"10. Akontozahlungen, ohne Mwst."]
[null,"11. Akontozahlungen, ohne Mwst."]
[null,"Zwischentotal 4",null,{"$f":"SUM(D17-D18-D19-D20-D21-D22-D23-D24-D25-D26-D27-D28)","v":{"v":0,"d":"0.00"}}]
[null,"Mehrwertsteuer von Zw'total 4",{"v":0.081,"d":"8.10%"},{"$f":"SUM($D$29*C30)","v":{"v":0,"d":"0.00"}}]
[null,"A-Kontobetrag, netto, inkl. Mwst.",null,{"$f":"SUM(D29+D30)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Schlussrechnung","index":2,"n_rows":36,"n_cols":4,"rows_kept":36}
[null,"Dienststelle Immobilien"]
[]
[]
[null,"Rechnungskontrolle"]
[]
[null,"Schlussrechnung"]
[]
[null,"Rechnungsbetrag brutto, ohne Mwst"]
[null,"Rabatt",null,{"$f":"ROUND((D8*C9)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Rabatt in Franken"]
[null,"Zwischentotal 1",null,{"$f":"SUM(D8-D9-D10)","v":{"v":0,"d":"0.00"}}]
[null,"Skonto",null,{"$f":"ROUND((D11*C12)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Zwischentotal 2",null,{"$f":"SUM(D11-D12)","v":{"v":0,"d":"0.00"}}]
[null,"Bauversicherung von Zw'total 2",{"v":2E-3,"d":"0.20%"},{"$f":"ROUND(($D$13*C14)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Bauschäden von Zw'total 2",null,{"$f":"ROUND(($D$13*C15)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Baureinigung von Zw'total 2",null,{"$f":"ROUND(($D$13*C16)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Baureklame, Betrag"]
[null,"Baureklame in %",null,{"$f":"ROUND(($D$13*C18)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"weitere Abzüge, Betrag"]
[null,"weitere Abzüge in %",null,{"$f":"ROUND(($D$13*C20)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Total Abzüge",{"$f":"SUM(C14:C20)","v":{"v":2E-3,"d":"0.20%"}}]
[null,"Zwischentotal 3",null,{"$f":"SUM(D13-D14-D15-D16-D17-D18-D19-D20)","v":{"v":0,"d":"0.00"}}]
[null,"1. Akontozahlungen, ohne Mwst."]
[null,"2. Akontozahlungen, ohne Mwst."]
[null,"3. Akontozahlungen, ohne Mwst."]
[null,"4. Akontozahlungen, ohne Mwst."]
[null,"5. Akontozahlungen, ohne Mwst."]
[null,"6. Akontozahlungen, ohne Mwst."]
[null,"7. Akontozahlungen, ohne Mwst."]
[null,"8. Akontozahlungen, ohne Mwst."]
[null,"9. Akontozahlungen, ohne Mwst."]
[null,"10. Akontozahlungen, ohne Mwst."]
[null,"11. Akontozahlungen, ohne Mwst."]
[null,"Zwischentotal 4",null,{"$f":"SUM(D22-D23-D24-D25-D26-D27-D28-D29-D30-D31-D32-D33)","v":{"v":0,"d":"0.00"}}]
[null,"Mehrwertsteuer von Zw'total 4",{"v":0.081,"d":"8.10%"},{"$f":"SUM(D34*C35)","v":{"v":0,"d":"0.00"}}]
[null,"Schlusszahlungsbetrag, netto, inkl. Mwst.",null,{"$f":"SUM(D34+D35)","v":{"v":0,"d":"0.00"}}]

{"sheet":"untersch. MwSt.","index":3,"n_rows":24,"n_cols":10,"rows_kept":24}
[null,"Dienststelle Immobilien"]
[]
[]
[null,"Rechnungskontrolle"]
[]
[null,"Einzelrechnungen mit unterschiedlicher MwSt."]
[{"$nulls":9},"Total "]
[null,"Rechnungsbetrag brutto, ohne Mwst",2017,{"$f":"SUM(J8-H8)","v":{"v":0,"d":"0.00"}},null,"Rechnungsbetrag brutto, ohne Mwst",2018]
[null,"Rabatt",null,{"$f":"ROUND((D8*C9)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}},null,"Rabatt",null,{"$f":"ROUND((H8*G9)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Rabatt in Franken",{"$nulls":3},"Rabatt in Franken"]
[null,"Zwischentotal 1",null,{"$f":"SUM(D8-D9-D10)","v":{"v":0,"d":"0.00"}},null,"Zwischentotal 1",null,{"$f":"SUM(H8-H9-H10)","v":{"v":0,"d":"0.00"}}]
[null,"Skonto",null,{"$f":"ROUND((D11*C12)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}},null,"Skonto",null,{"$f":"ROUND((H11*G12)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Zwischentotal 2",null,{"$f":"SUM(D11-D12)","v":{"v":0,"d":"0.00"}},null,"Zwischentotal 2",null,{"$f":"SUM(H11-H12)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(H13+D13)","v":{"v":0,"d":"0.00  "}}]
[null,"Bauversicherung",{"v":0.003,"d":"0.30%"},{"$f":"ROUND(($D$13*C14)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}},null,"Bauversicherung",{"v":0.003,"d":"0.30%"},{"$f":"ROUND(($H$13*G14)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Bauschäden",null,{"v":0,"d":"0.00"},null,"Bauschäden",null,{"$f":"ROUND(($D$13*G15)/0.05,0)*0.05","v":{"v":0,"d":"0.00"}}]
[null,"Baureinigung",null,{"v":0,"d":"0.00"},null,"Baureinigung",null,{"v":0,"d":"0.00"}]
[null,"Baureklame, Betrag",{"$nulls":3},"Baureklame, Betrag"]
[null,"Baureklame in %",null,{"v":0,"d":"0.00"},null,"Baureklame in %",null,{"v":0,"d":"0.00"}]
[null,"weitere Abzüge, Betrag",{"$nulls":3},"weitere Abzüge, Betrag"]
[null,"weitere Abzüge in %",null,{"v":0,"d":"0.00"},null,"weitere Abzüge in %",null,{"v":0,"d":"0.00"}]
[null,"Zwischentotal Abzüge",{"$f":"SUM(C14:C20)","v":{"v":0.003,"d":"0.30%"}},null,null,"Zwischentotal Abzüge",{"$f":"SUM(G14:G20)","v":{"v":0.003,"d":"0.30%"}}]
[null,"Zwischentotal 3",null,{"$f":"SUM(D13-D14-D15-D16-D17-D18-D19-D20)","v":{"v":0,"d":"0.00"}},null,"Zwischentotal 3",null,{"$f":"SUM(H13-H14-H15-H16-H17-H18-H19-H20)","v":{"v":0,"d":"0.00"}}]
[null,"Mehrwertsteuer",{"v":0.077,"d":"7.70%"},{"$f":"SUM(D22*C23)","v":{"v":0,"d":"0.00"}},null,"Mehrwertsteuer",{"v":0.081,"d":"8.10%"},{"$f":"SUM(H22*G23)","v":{"v":0,"d":"0.00"}}]
[null,"Zahlungsbetrag, netto, inkl. Mwst.",null,{"$f":"SUM(D22+D23)","v":{"v":0,"d":"0.00"}},null,"Zahlungsbetrag, netto, inkl. Mwst.",null,{"$f":"SUM(H22+H23)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(H24+D24)","v":{"v":0,"d":"0.00  "}}]