{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Stammdaten","31.12.2025"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":2,"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":"Stammdaten","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Um Ihnen die Bewertung Ihrer halbfertigen Arbeiten zu erleichtern ist es notwendig,"]
["einige Parameter Ihres Unternehmens zu erfassen. "]
["Am besten nehmen Sie hierzu die BWA vom Dezember des Vorjahres oder die Bilanz zur Hand."]
["Wenn Sie mit dem Cursor auf die Felder mit den roten Dreiecken gehen, erscheint ein "]
["Kommentar, was Sie in dieses Feld eintragen müssen bzw. was Excel in dieser Zelle errechnet."]
[]
[]
[]
["Vorgabewerte aus Ihrem Unternehmen",null,null,null,null,null,"Werte für die Berechnung der halbfertigen Arbeiten"]
[]
[]
["Betriebsleistung des Vorjahres",null,null,170000,null,null,"Sie können diese Werte beliebig überschreiben."]
[null,null,null,null,null,null,"Das System rechnet dann in Zukunft mit Ihren Eingabewerten."]
["Wareneinsatz des Vorjahres",null,null,80000]
[null,null,null,null,null,null,"Rohertrag/Stunde",null,{"$f":"D26","v":60}]
["Erzielter Rohertrag",null,null,{"$f":"D14-D16","v":90000}]
[null,null,null,null,null,null,"Wareneinsatz/Stunde",null,{"$f":"D28","v":53.333333333333336}]
["Gewinn vor Steuer",null,null,20000]
[null,null,null,null,null,null,"Abschlag Gewinnanteil",null,{"$f":"D30","v":0.11764705882352941}]
["Produktive Stunden des Vorjahres",null,null,1500]
[]
["Erzielte Betriebsleistung/prod. Stunde",null,null,{"$f":"D14/D22","v":113.33333333333333}]
[]
["Erzielter Rohertrag/Std.",null,null,{"$f":"D18/D22","v":60}]
[]
["Durchschnittlicher Wareneinsatz/prod. Stunde",null,null,{"$f":"D16/D22","v":53.333333333333336}]
[]
["Abschlag Gewinnanteil",null,null,{"$f":"D20/D14","v":0.11764705882352941}]

{"sheet":"31.12.2025","index":1,"n_rows":99,"n_cols":15,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["Kunde","Auftragssumme","fertig, noch nicht Schluß-gerechnet","gel. Stunden","Material Einkauf+ Fremdleistungen","Lohnleistung","erbrachte Leistungen netto in Euro","Korrektur","Bewertete Leistung","geschriebene Abschlags-Rechnungen","erhaltene Abschlags-Zahlungen ","nicht berechnete halbfertige Arbeiten","vorfinanzierte Leistung auf den Baustellen","Fertigstellungsgrad"]
["Summe",{"$f":"SUM(B3:B103)","v":353000},null,{"$f":"SUM(D3:D103)","v":190},{"$f":"SUM(E3:E103)","v":10133.333333333334},11400,21533.333333333332,600,{"$f":"SUM(I3:I99)","v":20792.156862745098},1500,1500,19292.156862745098,20633.333333333332,{"$f":"IF(B2>0,G2/B2,\"\")","v":6.1000944287063263E-2}]
["Projekt 1",80000,null,30,{"$f":"D3*Materialeinsatz_pro_Stunde","v":1600},{"$f":"D3*Rohertrag_pro_Stunde","v":1800},{"$f":"E3+F3","v":3400},2600,{"$f":"IF(C3=\"\",E3+H3+F3*(1-Abschlag),G3+H3)","v":5788.2352941176468},1500,1500,{"$f":"I3-J3","v":4288.2352941176468},{"$f":"G3+H3-K3","v":4500},4.2500000000000003E-2,{"$f":"IF(I3>B3,\"Achtung: Bewertete Leistung ist höher als die Auftragssumme\",\"\")","v":""}]
["Projekt 2",98000,null,50,2666.666666666667,3000,{"$f":"E4+F4","v":5666.666666666667},-2000,3313.7254901960787,null,null,{"$f":"I4-J4","v":3313.7254901960787},{"$f":"G4+H4-K4","v":3666.666666666667},5.7823129251700682E-2,""]
["Projekt 3",150000,null,100,5333.3333333333339,6000,11333.333333333334,null,10627.450980392157,null,null,10627.450980392157,11333.333333333334,7.5555555555555556E-2,""]
["Projekt 4",25000,null,10,533.33333333333337,600,1133.3333333333335,null,1062.7450980392157,null,null,1062.7450980392157,1133.3333333333335,4.5333333333333337E-2,""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null," ",0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,{"$f":"IF(B34>0,G34/B34,\"\")","v":""},""]
[null,null,null,null,{"$f":"D35*Materialeinsatz_pro_Stunde","v":0},{"$f":"D35*Rohertrag_pro_Stunde","v":0},0,null,{"$f":"IF(C35=\"\",E35+H35+F35*(1-Abschlag),G35+H35)","v":0},null,null,0,0,"",{"$f":"IF(I35>B35,\"Achtung: Bewertete Leistung ist höher als die Auftragssumme\",\"\")","v":""}]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,{"$f":"IF(B66>0,G66/B66,\"\")","v":""},""]
[null,null,null,null,{"$f":"D67*Materialeinsatz_pro_Stunde","v":0},{"$f":"D67*Rohertrag_pro_Stunde","v":0},0,null,{"$f":"IF(C67=\"\",E67+H67+F67*(1-Abschlag),G67+H67)","v":0},null,null,0,0,"",{"$f":"IF(I67>B67,\"Achtung: Bewertete Leistung ist höher als die Auftragssumme\",\"\")","v":""}]
[null,null,null,null,0,0,{"$f":"E68+F68","v":0},null,0,null,null,{"$f":"I68-J68","v":0},{"$f":"G68+H68-K68","v":0},"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,0,0,0,null,0,null,null,0,0,"",""]
[null,null,null,null,{"$f":"D99*Materialeinsatz_pro_Stunde","v":0},0,0,null,{"$f":"IF(C99=\"\",E99+H99+F99*(1-Abschlag),G99+H99)","v":0},null,null,0,0,"",""]