{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Kontrolle","Berechnungen","Tabelle3"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Kontrolle","index":0,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Kostenvergleichsrechnung"]
[]
[null,"Anlagen","A","B","C"]
[null,"weitere Angaben","Anlage A","Anlage B","Anlage C"]
[null,"Anschaffungskosten",540000,150000,160000]
[null,"Nutzungsdauer in Jahren",6,5,5]
[null,"Liquidationserlös",10000,20000,35000]
[null,"ständiger Stoffvorrat (Roh-, Hilfs-, Betriebsstoffe)",4000,4000,4000]
[null,"kalkulatorischer Zinssatz in %",6,6,6]
[null,"Leistungseinheiten pro Jahr",22000,24000,25000]
[null,"Wartung",8000,4000,4000]
[null,"sonstige fixe Kosten",14000,18000,19000]
[null,"Energiekosten je Leistungseinheit",0.6,0.5,0.4]
[null,"Materialkosten je Leistungseinheit",4,4,4]
[null,"sonstige variable Kosten je Leistungseinheit",0.4,0.4,0.4]
[]
[]
[]
[null,"fixe Kosten"]
[null,"variable Kosten"]
[null,"Gesamtkosten"]
[null,"Kosten je Leistungseinheit"]

{"sheet":"Berechnungen","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Anlagen","A","B","C"]
[null,"durchschnittliche Kapitalbindung",{"$f":"(Kontrolle!C6-Kontrolle!C8)/2","v":265000},{"$f":"(Kontrolle!D6-Kontrolle!D8)/2","v":65000},{"$f":"(Kontrolle!E6-Kontrolle!E8)/2","v":62500}]
[null,"ständige Kapitalbindung (Liquidationserlös + Stoffvorrat)",{"$f":"Kontrolle!C8+Kontrolle!C9","v":14000},{"$f":"Kontrolle!D8+Kontrolle!D9","v":24000},{"$f":"Kontrolle!E8+Kontrolle!E9","v":39000}]
[null,"FIXE KOSTEN"]
[null,"Abschreibung",{"$f":"(Kontrolle!C6-Kontrolle!C8)/Kontrolle!C7","v":88333.333333333328},{"$f":"(Kontrolle!D6-Kontrolle!D8)/Kontrolle!D7","v":26000},{"$f":"(Kontrolle!E6-Kontrolle!E8)/Kontrolle!E7","v":25000}]
[null,"kalkulatorische Zinsen auf die durchschnittliche Kapitalbindung",{"$f":"(C5)*Kontrolle!C10/100","v":15900},{"$f":"(D5)*Kontrolle!D10/100","v":3900},{"$f":"(E5)*Kontrolle!E10/100","v":3750}]
[null,"kalkulatorische Zinsen auf die ständige Kapitalbindung",{"$f":"C6*Kontrolle!C10/100","v":840},{"$f":"D6*Kontrolle!D10/100","v":1440},{"$f":"E6*Kontrolle!E10/100","v":2340}]
[null,"Wartung",{"$f":"Kontrolle!C12","v":8000},{"$f":"Kontrolle!D12","v":4000},{"$f":"Kontrolle!E12","v":4000}]
[null,"sonstige fixe Kosten",{"$f":"Kontrolle!C13","v":14000},{"$f":"Kontrolle!D13","v":18000},{"$f":"Kontrolle!E13","v":19000}]
[null,"fixe Kosten",{"$f":"ROUND(SUM(C8:C12),2)","v":127073.33},{"$f":"ROUND(SUM(D8:D12),2)","v":53340},{"$f":"ROUND(SUM(E8:E12),2)","v":54090}]
[null,"VARIABLE KOSTEN"]
[null,"Energiekosten",{"$f":"Kontrolle!C14*Kontrolle!C11","v":13200},{"$f":"Kontrolle!D14*Kontrolle!D11","v":12000},{"$f":"Kontrolle!E14*Kontrolle!E11","v":10000}]
[null,"Materialkosten",{"$f":"Kontrolle!C15*Kontrolle!C11","v":88000},{"$f":"Kontrolle!D15*Kontrolle!D11","v":96000},{"$f":"Kontrolle!E15*Kontrolle!E11","v":100000}]
[null,"sonstige variable Kosten",{"$f":"Kontrolle!C16*Kontrolle!C11","v":8800},{"$f":"Kontrolle!D16*Kontrolle!D11","v":9600},{"$f":"Kontrolle!E16*Kontrolle!E11","v":10000}]
[null,"variable Kosten",{"$f":"ROUND(SUM(C15:C17),2)","v":110000},{"$f":"ROUND(SUM(D15:D17),2)","v":117600},{"$f":"ROUND(SUM(E15:E17),2)","v":120000}]
[]
[null,"Gesamtkosten pro Jahr",{"$f":"ROUND(C13+C18,2)","v":237073.33},{"$f":"ROUND(D13+D18,2)","v":170940},{"$f":"ROUND(E13+E18,2)","v":174090}]
[null,"Kosten je Leistungseinheit",{"$f":"ROUND(C20/Kontrolle!C11,4)","v":10.7761},{"$f":"ROUND(D20/Kontrolle!D11,4)","v":7.1224999999999996},{"$f":"ROUND(E20/Kontrolle!E11,4)","v":6.9635999999999996}]

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}