{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Steuerung","Berechnungen","Diagramme"],"not_rendered":{"charts":40,"images":2,"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":"Steuerung","index":0,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,5,7,11],[8,5,9,11],[8,2,8,4],[1,1,1,11],[2,1,2,11],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[9,2,9,4]]}
[]
[null,"Finanzierung aus Abschreibung"]
[null,"Kapazitätserweiterungseffekt"]
[]
[null,"Maschinenanfangsbestand",12,null,null,"Geben Sie die Ausgangsdaten ein und lassen Sie sich durch Klick auf die Buttons die Entwicklung der Perioden- und Gesamt- kapazitäten bei unterschiedlicher kalkulatorischer Nutzungsdauer anzeigen. "]
[null,"Maschinenkapazität je Jahr ",5000]
[null,"Anschaffungswert je Maschine",5000]
[null,"bilanzielle Nutzungsdauer in Jahren",6]
[null,"bilanzielle Abschreibung (linear)",{"$f":"C7/C8","v":833.33333333333337}]
[null,"Wiederbeschaffungswert",10000]
[]
[null,"kalkulatorische Nutzungsdauer in Jahren",1,2,3,4,5,6,7,8,9,10]
[null,"Berechnung"]
[null,"Diagramm"]
[]
[null,"kalkulatorische Nutzungsdauer in Jahren",11,12,13,14,15,16,17,18,19,20]
[null,"Berechnung"]
[null,"Diagramm"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]

{"sheet":"Berechnungen","index":1,"n_rows":406,"n_cols":22,"rows_kept":406,"cut":false,"hidden":false,"merged":[]}
[]
["Wiederbeschaffungswert je Maschine",{"$f":"Steuerung!C10","v":10000}]
["bilanzielle Nutzungsdauer in Jahren",{"$f":"Steuerung!C8","v":6}]
["Erstanschaffung",{"$f":"Steuerung!C5","v":12}]
["bilanzielle Abschreibung je Maschine",{"$f":"Steuerung!C9","v":833.33333333333337}]
["Maschinenkapazität je Jahr",{"$f":"Steuerung!C6","v":5000}]
[]
["kalkulatorische Nutzungsdauer in Jahren",1,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B8","v":10000}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B10-B11+B17","v":13},{"$f":"C10-C11+C17","v":14},{"$f":"D10-D11+D17","v":15},16,17,7,6,6,5,5,{"$f":"L10-L11+L17","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B10","v":12},{"$f":"B17","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B10*$B$6","v":60000},{"$f":"C10*$B$6","v":65000},{"$f":"D10*$B$6","v":70000},{"$f":"E10*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M10*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F8*B10","v":120000},{"$f":"$F8*C10","v":130000},{"$f":"$F8*D10","v":140000},{"$f":"$F8*E10","v":150000},160000,170000,70000,60000,60000,50000,50000,{"$f":"$F8*M10","v":40000},30000,30000,20000,20000,10000,10000,10000,10000,10000]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F8)*B10","v":-110000},{"$f":"($B$5-$F8)*C10","v":-119166.66666666666},{"$f":"($B$5-$F8)*D10","v":-128333.33333333333},{"$f":"($B$5-$F8)*E10","v":-137500},-146666.66666666666,-155833.33333333331,-64166.666666666664,-55000,-55000,-45833.333333333328,-45833.333333333328,{"$f":"($B$5-$F8)*M10","v":-36666.666666666664},-27500,-27500,-18333.333333333332,-18333.333333333332,-9166.6666666666661,-9166.6666666666661,-9166.6666666666661,-9166.6666666666661,-9166.6666666666661]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B16-B18","v":0},{"$f":"C16-C18","v":833.33333333334303},{"$f":"D16-D18","v":2500.0000000000146},5000.0000000000146,8333.3333333333576,2500.0000000000437,8333.3333333333794,3333.3333333333794,8333.3333333333794,2500.0000000000509,{"$f":"L16-L18","v":6666.6666666667224},5.8207660913467407E-11,2500.0000000000582,5000.0000000000582,6666.6666666667261,8333.333333333394,9166.6666666667279,6.184563972055912E-11,833.33333333339579,1666.6666666667297]
["Gesamtfreisetzung",{"$f":"B13+B14+B15","v":10000},10833.333333333343,12500.000000000015,15000.000000000015,18333.333333333358,22500.000000000044,8333.3333333333794,13333.333333333379,8333.3333333333794,12500.000000000051,6666.6666666667224,10000.000000000058,2500.0000000000582,5000.0000000000582,6666.6666666667261,8333.333333333394,9166.6666666667279,10000.000000000062,833.33333333339579,1666.6666666667297,2500.0000000000637]
["Anzahl neuer Maschinen",{"$f":"INT(B16/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B17*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B10*$B$6*$B8","v":60000},{"$f":"B22","v":5000},{"$f":"C22","v":-55000},{"$f":"D22","v":-120000},-190000,-265000,-340000,-375000,-400000,-430000,-450000,{"$f":"L22","v":-475000},-490000,-505000,-520000,-530000,-540000,-545000,-545000,-550000,-555000]
["Kapazitäsrückgang während des Jahres",{"$f":"B10*$B$6","v":60000},{"$f":"C10*$B$6","v":65000},{"$f":"D10*$B$6","v":70000},{"$f":"E10*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M10*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B17*$B$6*$B8","v":5000},{"$f":"C17*$B$6*$B8","v":5000},{"$f":"D17*$B$6*$B8","v":5000},{"$f":"E17*$B$6*$B8","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M17*$B$6*$B8","v":5000},0,0,0,0,0,5000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B19-B20+B21","v":5000},-55000,-120000,-190000,-265000,-340000,-375000,-400000,-430000,-450000,-475000,-490000,-505000,-520000,-530000,-540000,-545000,-545000,-550000,-555000,-560000]
["Periodenkapazität am Jahresanfang",{"$f":"B10*$B$6","v":60000},65000,70000,{"$f":"E10*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M10*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E11*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M11*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B17*$B$6","v":5000},{"$f":"C17*$B$6","v":5000},{"$f":"D17*$B$6","v":5000},{"$f":"E17*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M17*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B23-B24+B25","v":65000},{"$f":"C23+C25","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",2,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B28","v":5000}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B30-B31+B37","v":13},{"$f":"C30-C31+C37","v":14},{"$f":"D30-D31+D37","v":15},16,17,7,6,6,5,5,{"$f":"L30-L31+L37","v":4},2,3,2,2,1,1,1,0,0]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B30","v":12},{"$f":"B37","v":1},1,1,1,1,2,0,1,0,1,0,0,1,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B30*$B$6","v":60000},{"$f":"C30*$B$6","v":65000},{"$f":"D30*$B$6","v":70000},{"$f":"E30*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M30*$B$6","v":20000},10000,15000,10000,10000,5000,5000,5000,0,0]
["Kapitalfreisetzung am Jahresende",{"$f":"$F28*B30","v":60000},{"$f":"$F28*C30","v":65000},{"$f":"$F28*D30","v":70000},{"$f":"$F28*E30","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"$F28*M30","v":20000},10000,15000,10000,10000,5000,5000,5000,0,0]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F28)*B30","v":-50000},{"$f":"($B$5-$F28)*C30","v":-54166.666666666672},{"$f":"($B$5-$F28)*D30","v":-58333.333333333336},{"$f":"($B$5-$F28)*E30","v":-62500.000000000007},-66666.666666666672,-70833.333333333343,-29166.666666666668,-25000,-25000,-20833.333333333336,-20833.333333333336,{"$f":"($B$5-$F28)*M30","v":-16666.666666666668},-8333.3333333333339,-12500,-8333.3333333333339,-8333.3333333333339,-4166.666666666667,-4166.666666666667,-4166.666666666667,0,0]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B36-B38","v":0},{"$f":"C36-C38","v":833.33333333332848},{"$f":"D36-D38","v":2499.9999999999927},4999.9999999999854,8333.3333333333139,2499.9999999999709,8333.333333333303,3333.333333333303,8333.333333333303,2499.9999999999673,{"$f":"L36-L38","v":6666.6666666666315},9999.9999999999636,1666.6666666666297,4166.6666666666297,5833.3333333332957,7499.9999999999618,8333.3333333332957,9166.6666666666279,9999.99999999996,9999.99999999996]
["Gesamtfreisetzung",{"$f":"B33+B34+B35","v":10000},10833.333333333328,12499.999999999993,14999.999999999985,18333.333333333314,22499.999999999971,8333.333333333303,13333.333333333303,8333.333333333303,12499.999999999967,6666.6666666666315,9999.9999999999636,11666.66666666663,4166.6666666666297,5833.3333333332957,7499.9999999999618,8333.3333333332957,9166.6666666666279,9999.99999999996,9999.99999999996,9999.99999999996]
["Anzahl neuer Maschinen",{"$f":"INT(B36/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,0,1,0,0,0,0,0,0,0,0]
["Investition",{"$f":"B37*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,0,10000,0,0,0,0,0,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B30*$B$6*$B28","v":120000},{"$f":"B42","v":70000},{"$f":"C42","v":15000},{"$f":"D42","v":-45000},-110000,-180000,-245000,-280000,-300000,-330000,-345000,{"$f":"L42","v":-370000},-390000,-390000,-405000,-415000,-425000,-430000,-435000,-440000,-440000]
["Kapazitäsrückgang während des Jahres",{"$f":"B30*$B$6","v":60000},{"$f":"C30*$B$6","v":65000},{"$f":"D30*$B$6","v":70000},{"$f":"E30*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M30*$B$6","v":20000},10000,15000,10000,10000,5000,5000,5000,0,0]
["Gesamtkapazitätszunahme",{"$f":"B37*$B$6*$B28","v":10000},{"$f":"C37*$B$6*$B28","v":10000},{"$f":"D37*$B$6*$B28","v":10000},{"$f":"E37*$B$6*$B28","v":10000},10000,20000,0,10000,0,10000,0,{"$f":"M37*$B$6*$B28","v":0},10000,0,0,0,0,0,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B39-B40+B41","v":70000},15000,-45000,-110000,-180000,-245000,-280000,-300000,-330000,-345000,-370000,-390000,-390000,-405000,-415000,-425000,-430000,-435000,-440000,-440000,-440000]
["Periodenkapazität am Jahresanfang",{"$f":"B30*$B$6","v":60000},65000,70000,{"$f":"E30*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M30*$B$6","v":20000},10000,15000,10000,10000,5000,5000,5000,0,0]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E31*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M31*$B$6","v":10000},0,5000,0,5000,0,0,5000,0,0]
["Periodenkapazitätszunahme",{"$f":"B37*$B$6","v":5000},{"$f":"C37*$B$6","v":5000},{"$f":"D37*$B$6","v":5000},{"$f":"E37*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M37*$B$6","v":0},5000,0,0,0,0,0,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B43-B44+B45","v":65000},{"$f":"C43+C45","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,20000,15000,15000,10000,10000,5000,5000,5000,0,0]
[]
["kalkulatorische Nutzungsdauer in Jahren",3,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B48","v":3333.3333333333335}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B50-B51+B57","v":13},{"$f":"C50-C51+C57","v":14},{"$f":"D50-D51+D57","v":15},16,17,7,6,6,5,5,{"$f":"L50-L51+L57","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B50","v":12},{"$f":"B57","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B50*$B$6","v":60000},{"$f":"C50*$B$6","v":65000},{"$f":"D50*$B$6","v":70000},{"$f":"E50*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M50*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F48*B50","v":40000},{"$f":"$F48*C50","v":43333.333333333336},{"$f":"$F48*D50","v":46666.666666666672},{"$f":"$F48*E50","v":50000},53333.333333333336,56666.666666666672,23333.333333333336,20000,20000,16666.666666666668,16666.666666666668,{"$f":"$F48*M50","v":13333.333333333334},10000,10000,6666.666666666667,6666.666666666667,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F48)*B50","v":-30000},{"$f":"($B$5-$F48)*C50","v":-32500},{"$f":"($B$5-$F48)*D50","v":-35000},{"$f":"($B$5-$F48)*E50","v":-37500},-40000,-42500,-17500,-15000,-15000,-12500,-12500,{"$f":"($B$5-$F48)*M50","v":-10000},-7500,-7500,-5000,-5000,-2500,-2500,-2500,-2500,-2500]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B56-B58","v":0},{"$f":"C56-C58","v":833.33333333333576},{"$f":"D56-D58","v":2500.0000000000073},5000.0000000000073,8333.333333333343,2500.0000000000146,8333.3333333333503,3333.3333333333503,8333.3333333333503,2500.0000000000182,{"$f":"L56-L58","v":6666.6666666666861},2.0008883439004421E-11,2500.00000000002,5000.00000000002,6666.666666666687,8333.3333333333539,9166.6666666666879,2.1827872842550278E-11,833.33333333335531,1666.6666666666888]
["Gesamtfreisetzung",{"$f":"B53+B54+B55","v":10000},10833.333333333336,12500.000000000007,15000.000000000007,18333.333333333343,22500.000000000015,8333.3333333333503,13333.33333333335,8333.3333333333503,12500.000000000018,6666.6666666666861,10000.00000000002,2500.00000000002,5000.00000000002,6666.666666666687,8333.3333333333539,9166.6666666666879,10000.000000000022,833.33333333335531,1666.6666666666888,2500.0000000000223]
["Anzahl neuer Maschinen",{"$f":"INT(B56/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B57*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B50*$B$6*$B48","v":180000},{"$f":"B62","v":135000},85000,30000,-30000,-95000,-150000,-185000,-200000,-230000,-240000,{"$f":"L62","v":-265000},-270000,-285000,-300000,-310000,-320000,-325000,-315000,-320000,-325000]
["Kapazitäsrückgang während des Jahres",{"$f":"B50*$B$6","v":60000},65000,70000,75000,80000,85000,35000,30000,30000,25000,25000,{"$f":"M50*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B57*$B$6*$B48","v":15000},15000,15000,15000,15000,30000,0,15000,0,15000,0,{"$f":"M57*$B$6*$B48","v":15000},0,0,0,0,0,15000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B59-B60+B61","v":135000},85000,30000,-30000,-95000,-150000,-185000,-200000,-230000,-240000,-265000,-270000,-285000,-300000,-310000,-320000,-325000,-315000,-320000,-325000,-330000]
["Periodenkapazität am Jahresanfang",{"$f":"B50*$B$6","v":60000},65000,70000,75000,80000,85000,35000,30000,30000,25000,25000,{"$f":"M50*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",{"$f":"B51*$B$6","v":0},0,0,0,0,60000,5000,5000,5000,5000,5000,{"$f":"M51*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B57*$B$6","v":5000},5000,5000,5000,5000,10000,0,5000,0,5000,0,{"$f":"M57*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B63-B64+B65","v":65000},{"$f":"C63+C65","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",4,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B68","v":2500}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B70-B71+B77","v":13},{"$f":"C70-C71+C77","v":14},{"$f":"D70-D71+D77","v":15},16,17,7,6,6,5,5,{"$f":"L70-L71+L77","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B70","v":12},{"$f":"B77","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B70*$B$6","v":60000},{"$f":"C70*$B$6","v":65000},{"$f":"D70*$B$6","v":70000},{"$f":"E70*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M70*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F68*B70","v":30000},{"$f":"$F68*C70","v":32500},{"$f":"$F68*D70","v":35000},{"$f":"$F68*E70","v":37500},40000,42500,17500,15000,15000,12500,12500,{"$f":"$F68*M70","v":10000},7500,7500,5000,5000,2500,2500,2500,2500,2500]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F68)*B70","v":-20000},{"$f":"($B$5-$F68)*C70","v":-21666.666666666664},{"$f":"($B$5-$F68)*D70","v":-23333.333333333332},{"$f":"($B$5-$F68)*E70","v":-24999.999999999996},-26666.666666666664,-28333.333333333332,-11666.666666666666,-10000,-10000,-8333.3333333333321,-8333.3333333333321,{"$f":"($B$5-$F68)*M70","v":-6666.6666666666661},-5000,-5000,-3333.333333333333,-3333.333333333333,-1666.6666666666665,-1666.6666666666665,-1666.6666666666665,-1666.6666666666665,-1666.6666666666665]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B76-B78","v":0},{"$f":"C76-C78","v":833.33333333333576},{"$f":"D76-D78","v":2500.0000000000036},5000.0000000000073,8333.333333333343,2500.0000000000109,8333.3333333333449,3333.3333333333449,8333.3333333333449,2500.0000000000127,{"$f":"L76-L78","v":6666.6666666666806},1.4551915228366852E-11,2500.0000000000146,5000.0000000000146,6666.6666666666815,8333.3333333333485,9166.6666666666824,1.6370904631912708E-11,833.33333333334986,1666.6666666666833]
["Gesamtfreisetzung",{"$f":"B73+B74+B75","v":10000},10833.333333333336,12500.000000000004,15000.000000000007,18333.333333333343,22500.000000000011,8333.3333333333449,13333.333333333345,8333.3333333333449,12500.000000000013,6666.6666666666806,10000.000000000015,2500.0000000000146,5000.0000000000146,6666.6666666666815,8333.3333333333485,9166.6666666666824,10000.000000000016,833.33333333334986,1666.6666666666833,2500.0000000000168]
["Anzahl neuer Maschinen",{"$f":"INT(B76/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B77*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B70*$B$6*$B68","v":240000},{"$f":"B82","v":200000},{"$f":"C82","v":155000},{"$f":"D82","v":105000},50000,-10000,-55000,-90000,-100000,-130000,-135000,{"$f":"L82","v":-160000},-160000,-175000,-190000,-200000,-210000,-215000,-200000,-205000,-210000]
["Kapazitäsrückgang während des Jahres",{"$f":"B70*$B$6","v":60000},{"$f":"C70*$B$6","v":65000},{"$f":"D70*$B$6","v":70000},{"$f":"E70*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M70*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B77*$B$6*$B68","v":20000},{"$f":"C77*$B$6*$B68","v":20000},{"$f":"D77*$B$6*$B68","v":20000},{"$f":"E77*$B$6*$B68","v":20000},20000,40000,0,20000,0,20000,0,{"$f":"M77*$B$6*$B68","v":20000},0,0,0,0,0,20000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B79-B80+B81","v":200000},155000,105000,50000,-10000,-55000,-90000,-100000,-130000,-135000,-160000,-160000,-175000,-190000,-200000,-210000,-215000,-200000,-205000,-210000,-215000]
["Periodenkapazität am Jahresanfang",{"$f":"B70*$B$6","v":60000},65000,70000,{"$f":"E70*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M70*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E71*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M71*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B77*$B$6","v":5000},{"$f":"C77*$B$6","v":5000},{"$f":"D77*$B$6","v":5000},{"$f":"E77*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M77*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B83-B84+B85","v":65000},{"$f":"C83+C85","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",5,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B88","v":2000}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B90-B91+B97","v":13},{"$f":"C90-C91+C97","v":14},{"$f":"D90-D91+D97","v":15},16,17,7,6,6,5,5,{"$f":"L90-L91+L97","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B90","v":12},{"$f":"B97","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B90*$B$6","v":60000},{"$f":"C90*$B$6","v":65000},{"$f":"D90*$B$6","v":70000},{"$f":"E90*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M90*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F88*B90","v":24000},{"$f":"$F88*C90","v":26000},{"$f":"$F88*D90","v":28000},{"$f":"$F88*E90","v":30000},32000,34000,14000,12000,12000,10000,10000,{"$f":"$F88*M90","v":8000},6000,6000,4000,4000,2000,2000,2000,2000,2000]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F88)*B90","v":-13999.999999999998},{"$f":"($B$5-$F88)*C90","v":-15166.666666666664},{"$f":"($B$5-$F88)*D90","v":-16333.333333333332},{"$f":"($B$5-$F88)*E90","v":-17499.999999999996},-18666.666666666664,-19833.333333333332,-8166.6666666666661,-6999.9999999999991,-6999.9999999999991,-5833.3333333333321,-5833.3333333333321,{"$f":"($B$5-$F88)*M90","v":-4666.6666666666661},-3499.9999999999995,-3499.9999999999995,-2333.333333333333,-2333.333333333333,-1166.6666666666665,-1166.6666666666665,-1166.6666666666665,-1166.6666666666665,-1166.6666666666665]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B96-B98","v":0},{"$f":"C96-C98","v":833.33333333333576},{"$f":"D96-D98","v":2500.0000000000036},5000.0000000000073,8333.333333333343,2500.0000000000109,8333.3333333333449,3333.3333333333467,8333.3333333333467,2500.0000000000146,{"$f":"L96-L98","v":6666.6666666666824},1.6370904631912708E-11,2500.0000000000168,5000.0000000000173,6666.6666666666843,8333.3333333333503,9166.6666666666843,1.8189894035458565E-11,833.33333333335167,1666.6666666666852]
["Gesamtfreisetzung",{"$f":"B93+B94+B95","v":10000.000000000002},10833.333333333336,12500.000000000004,15000.000000000007,18333.333333333343,22500.000000000011,8333.3333333333449,13333.333333333347,8333.3333333333467,12500.000000000015,6666.6666666666824,10000.000000000016,2500.0000000000168,5000.0000000000173,6666.6666666666843,8333.3333333333503,9166.6666666666843,10000.000000000018,833.33333333335167,1666.6666666666852,2500.0000000000186]
["Anzahl neuer Maschinen",{"$f":"INT(B96/$B$2)","v":1},{"$f":"INT(C96/$B$2)","v":1},1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B97*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B90*$B$6*$B88","v":300000},{"$f":"B102","v":265000},{"$f":"C102","v":225000},{"$f":"D102","v":180000},130000,75000,40000,5000,0,-30000,-30000,{"$f":"L102","v":-55000},-50000,-65000,-80000,-90000,-100000,-105000,-85000,-90000,-95000]
["Kapazitäsrückgang während des Jahres",{"$f":"B90*$B$6","v":60000},{"$f":"C90*$B$6","v":65000},{"$f":"D90*$B$6","v":70000},{"$f":"E90*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M90*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B97*$B$6*$B88","v":25000},{"$f":"C97*$B$6*$B88","v":25000},{"$f":"D97*$B$6*$B88","v":25000},{"$f":"E97*$B$6*$B88","v":25000},25000,50000,0,25000,0,25000,0,{"$f":"M97*$B$6*$B88","v":25000},0,0,0,0,0,25000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B99-B100+B101","v":265000},225000,180000,130000,75000,40000,5000,0,-30000,-30000,-55000,-50000,-65000,-80000,-90000,-100000,-105000,-85000,-90000,-95000,-100000]
["Periodenkapazität am Jahresanfang",{"$f":"B90*$B$6","v":60000},65000,70000,{"$f":"E90*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M90*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E91*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M91*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B97*$B$6","v":5000},{"$f":"C97*$B$6","v":5000},{"$f":"D97*$B$6","v":5000},{"$f":"E97*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M97*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B103-B104+B105","v":65000},{"$f":"C103+C105","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",6,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B108","v":1666.6666666666667}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B110-B111+B117","v":13},{"$f":"C110-C111+C117","v":14},{"$f":"D110-D111+D117","v":15},16,17,7,6,6,5,5,{"$f":"L110-L111+L117","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B110","v":12},{"$f":"B117","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B110*$B$6","v":60000},{"$f":"C110*$B$6","v":65000},{"$f":"D110*$B$6","v":70000},{"$f":"E110*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M110*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F108*B110","v":20000},{"$f":"$F108*C110","v":21666.666666666668},{"$f":"$F108*D110","v":23333.333333333336},{"$f":"$F108*E110","v":25000},26666.666666666668,28333.333333333336,11666.666666666668,10000,10000,8333.3333333333339,8333.3333333333339,{"$f":"$F108*M110","v":6666.666666666667},5000,5000,3333.3333333333335,3333.3333333333335,1666.6666666666667,1666.6666666666667,1666.6666666666667,1666.6666666666667,1666.6666666666667]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F108)*B110","v":-10000},{"$f":"($B$5-$F108)*C110","v":-10833.333333333334},{"$f":"($B$5-$F108)*D110","v":-11666.666666666668},{"$f":"($B$5-$F108)*E110","v":-12500},-13333.333333333334,-14166.666666666668,-5833.3333333333339,-5000,-5000,-4166.666666666667,-4166.666666666667,{"$f":"($B$5-$F108)*M110","v":-3333.3333333333335},-2500,-2500,-1666.6666666666667,-1666.6666666666667,-833.33333333333337,-833.33333333333337,-833.33333333333337,-833.33333333333337,-833.33333333333337]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B116-B118","v":0},{"$f":"C116-C118","v":833.33333333333394},{"$f":"D116-D118","v":2500.0000000000018},5000.0000000000018,8333.3333333333358,2500.0000000000036,8333.3333333333376,3333.3333333333376,8333.3333333333376,2500.0000000000036,{"$f":"L116-L118","v":6666.6666666666706},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B113+B114+B115","v":10000},10833.333333333334,12500.000000000002,15000.000000000002,18333.333333333336,22500.000000000004,8333.3333333333376,13333.333333333338,8333.3333333333376,12500.000000000004,6666.6666666666706,10000.000000000004,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B116/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B117*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B110*$B$6*$B108","v":360000},{"$f":"B122","v":330000},{"$f":"C122","v":295000},{"$f":"D122","v":255000},210000,160000,135000,100000,100000,70000,75000,{"$f":"L122","v":50000},60000,45000,30000,20000,10000,5000,30000,25000,20000]
["Kapazitäsrückgang während des Jahres",{"$f":"B110*$B$6","v":60000},{"$f":"C110*$B$6","v":65000},{"$f":"D110*$B$6","v":70000},{"$f":"E110*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M110*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B117*$B$6*$B108","v":30000},{"$f":"C117*$B$6*$B108","v":30000},{"$f":"D117*$B$6*$B108","v":30000},{"$f":"E117*$B$6*$B108","v":30000},30000,60000,0,30000,0,30000,0,{"$f":"M117*$B$6*$B108","v":30000},0,0,0,0,0,30000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B119-B120+B121","v":330000},295000,255000,210000,160000,135000,100000,100000,70000,75000,50000,60000,45000,30000,20000,10000,5000,30000,25000,20000,15000]
["Periodenkapazität am Jahresanfang",{"$f":"B110*$B$6","v":60000},65000,70000,{"$f":"E110*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M110*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E111*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M111*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B117*$B$6","v":5000},{"$f":"C117*$B$6","v":5000},{"$f":"D117*$B$6","v":5000},{"$f":"E117*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M117*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B123-B124+B125","v":65000},{"$f":"C123+C125","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",7,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B128","v":1428.5714285714287}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B130-B131+B137","v":13},{"$f":"C130-C131+C137","v":14},{"$f":"D130-D131+D137","v":15},16,17,7,6,6,5,5,{"$f":"L130-L131+L137","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B130","v":12},{"$f":"B137","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B130*$B$6","v":60000},{"$f":"C130*$B$6","v":65000},{"$f":"D130*$B$6","v":70000},{"$f":"E130*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M130*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F128*B130","v":17142.857142857145},{"$f":"$F128*C130","v":18571.428571428572},{"$f":"$F128*D130","v":20000},{"$f":"$F128*E130","v":21428.571428571431},22857.142857142859,24285.714285714286,10000,8571.4285714285725,8571.4285714285725,7142.8571428571431,7142.8571428571431,{"$f":"$F128*M130","v":5714.2857142857147},4285.7142857142862,4285.7142857142862,2857.1428571428573,2857.1428571428573,1428.5714285714287,1428.5714285714287,1428.5714285714287,1428.5714285714287,1428.5714285714287]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F128)*B130","v":-7142.8571428571431},{"$f":"($B$5-$F128)*C130","v":-7738.0952380952385},{"$f":"($B$5-$F128)*D130","v":-8333.3333333333339},{"$f":"($B$5-$F128)*E130","v":-8928.5714285714294},-9523.8095238095248,-10119.04761904762,-4166.666666666667,-3571.4285714285716,-3571.4285714285716,-2976.1904761904766,-2976.1904761904766,{"$f":"($B$5-$F128)*M130","v":-2380.9523809523812},-1785.7142857142858,-1785.7142857142858,-1190.4761904761906,-1190.4761904761906,-595.2380952380953,-595.2380952380953,-595.2380952380953,-595.2380952380953,-595.2380952380953]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B136-B138","v":0},{"$f":"C136-C138","v":833.33333333333394},{"$f":"D136-D138","v":2500},5000.0000000000018,8333.3333333333358,2500,8333.3333333333321,3333.3333333333321,8333.3333333333321,2499.9999999999982,{"$f":"L136-L138","v":6666.6666666666642},0,2500.0000000000005,5000.0000000000009,6666.6666666666679,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B133+B134+B135","v":10000.000000000002},10833.333333333334,12500,15000.000000000002,18333.333333333336,22500,8333.3333333333321,13333.333333333332,8333.3333333333321,12499.999999999998,6666.6666666666642,9999.9999999999982,2500.0000000000005,5000.0000000000009,6666.6666666666679,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B136/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B137*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B130*$B$6*$B128","v":420000},{"$f":"B142","v":395000},{"$f":"C142","v":365000},{"$f":"D142","v":330000},290000,245000,230000,195000,200000,170000,180000,{"$f":"L142","v":155000},170000,155000,140000,130000,120000,115000,145000,140000,135000]
["Kapazitäsrückgang während des Jahres",{"$f":"B130*$B$6","v":60000},{"$f":"C130*$B$6","v":65000},{"$f":"D130*$B$6","v":70000},{"$f":"E130*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M130*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B137*$B$6*$B128","v":35000},{"$f":"C137*$B$6*$B128","v":35000},{"$f":"D137*$B$6*$B128","v":35000},{"$f":"E137*$B$6*$B128","v":35000},35000,70000,0,35000,0,35000,0,{"$f":"M137*$B$6*$B128","v":35000},0,0,0,0,0,35000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B139-B140+B141","v":395000},365000,330000,290000,245000,230000,195000,200000,170000,180000,155000,170000,155000,140000,130000,120000,115000,145000,140000,135000,130000]
["Periodenkapazität am Jahresanfang",{"$f":"B130*$B$6","v":60000},65000,70000,{"$f":"E130*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M130*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E131*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M131*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B137*$B$6","v":5000},{"$f":"C137*$B$6","v":5000},{"$f":"D137*$B$6","v":5000},{"$f":"E137*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M137*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B143-B144+B145","v":65000},{"$f":"C143+C145","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",8,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B148","v":1250}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B150-B151+B157","v":13},{"$f":"C150-C151+C157","v":14},{"$f":"D150-D151+D157","v":15},16,17,7,6,6,5,5,{"$f":"L150-L151+L157","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B150","v":12},{"$f":"B157","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B150*$B$6","v":60000},{"$f":"C150*$B$6","v":65000},{"$f":"D150*$B$6","v":70000},{"$f":"E150*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M150*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F148*B150","v":15000},{"$f":"$F148*C150","v":16250},{"$f":"$F148*D150","v":17500},{"$f":"$F148*E150","v":18750},20000,21250,8750,7500,7500,6250,6250,{"$f":"$F148*M150","v":5000},3750,3750,2500,2500,1250,1250,1250,1250,1250]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F148)*B150","v":-5000},{"$f":"($B$5-$F148)*C150","v":-5416.6666666666661},{"$f":"($B$5-$F148)*D150","v":-5833.333333333333},{"$f":"($B$5-$F148)*E150","v":-6249.9999999999991},-6666.6666666666661,-7083.333333333333,-2916.6666666666665,-2500,-2500,-2083.333333333333,-2083.333333333333,{"$f":"($B$5-$F148)*M150","v":-1666.6666666666665},-1250,-1250,-833.33333333333326,-833.33333333333326,-416.66666666666663,-416.66666666666663,-416.66666666666663,-416.66666666666663,-416.66666666666663]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B156-B158","v":0},{"$f":"C156-C158","v":833.33333333333394},{"$f":"D156-D158","v":2500.0000000000018},5000.0000000000018,8333.3333333333358,2500.0000000000036,8333.3333333333376,3333.3333333333376,8333.3333333333376,2500.0000000000036,{"$f":"L156-L158","v":6666.6666666666706},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B153+B154+B155","v":10000},10833.333333333334,12500.000000000002,15000.000000000002,18333.333333333336,22500.000000000004,8333.3333333333376,13333.333333333338,8333.3333333333376,12500.000000000004,6666.6666666666706,10000.000000000004,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B156/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B157*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B150*$B$6*$B148","v":480000},{"$f":"B162","v":460000},{"$f":"C162","v":435000},{"$f":"D162","v":405000},370000,330000,325000,290000,300000,270000,285000,{"$f":"L162","v":260000},280000,265000,250000,240000,230000,225000,260000,255000,250000]
["Kapazitäsrückgang während des Jahres",{"$f":"B150*$B$6","v":60000},{"$f":"C150*$B$6","v":65000},{"$f":"D150*$B$6","v":70000},{"$f":"E150*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M150*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B157*$B$6*$B148","v":40000},{"$f":"C157*$B$6*$B148","v":40000},{"$f":"D157*$B$6*$B148","v":40000},{"$f":"E157*$B$6*$B148","v":40000},40000,80000,0,40000,0,40000,0,{"$f":"M157*$B$6*$B148","v":40000},0,0,0,0,0,40000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B159-B160+B161","v":460000},435000,405000,370000,330000,325000,290000,300000,270000,285000,260000,280000,265000,250000,240000,230000,225000,260000,255000,250000,245000]
["Periodenkapazität am Jahresanfang",{"$f":"B150*$B$6","v":60000},65000,70000,{"$f":"E150*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M150*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E151*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M151*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B157*$B$6","v":5000},{"$f":"C157*$B$6","v":5000},{"$f":"D157*$B$6","v":5000},{"$f":"E157*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M157*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B163-B164+B165","v":65000},{"$f":"C163+C165","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",9,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B168","v":1111.1111111111111}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B170-B171+B177","v":13},{"$f":"C170-C171+C177","v":14},{"$f":"D170-D171+D177","v":15},16,17,7,6,6,5,5,{"$f":"L170-L171+L177","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B170","v":12},{"$f":"B177","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B170*$B$6","v":60000},{"$f":"C170*$B$6","v":65000},{"$f":"D170*$B$6","v":70000},{"$f":"E170*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M170*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F168*B170","v":13333.333333333332},{"$f":"$F168*C170","v":14444.444444444443},{"$f":"$F168*D170","v":15555.555555555555},{"$f":"$F168*E170","v":16666.666666666668},17777.777777777777,18888.888888888887,7777.7777777777774,6666.6666666666661,6666.6666666666661,5555.5555555555557,5555.5555555555557,{"$f":"$F168*M170","v":4444.4444444444443},3333.333333333333,3333.333333333333,2222.2222222222222,2222.2222222222222,1111.1111111111111,1111.1111111111111,1111.1111111111111,1111.1111111111111,1111.1111111111111]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F168)*B170","v":-3333.3333333333326},{"$f":"($B$5-$F168)*C170","v":-3611.1111111111104},{"$f":"($B$5-$F168)*D170","v":-3888.8888888888878},{"$f":"($B$5-$F168)*E170","v":-4166.6666666666661},-4444.4444444444434,-4722.2222222222208,-1944.4444444444439,-1666.6666666666663,-1666.6666666666663,-1388.8888888888887,-1388.8888888888887,{"$f":"($B$5-$F168)*M170","v":-1111.1111111111109},-833.33333333333314,-833.33333333333314,-555.55555555555543,-555.55555555555543,-277.77777777777771,-277.77777777777771,-277.77777777777771,-277.77777777777771,-277.77777777777771]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B176-B178","v":0},{"$f":"C176-C178","v":833.33333333333212},{"$f":"D176-D178","v":2500},5000.0000000000018,8333.3333333333358,2500,8333.3333333333339,3333.3333333333339,8333.3333333333339,2500,{"$f":"L176-L178","v":6666.666666666667},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B173+B174+B175","v":10000},10833.333333333332,12500,15000.000000000002,18333.333333333336,22500,8333.3333333333339,13333.333333333334,8333.3333333333339,12500,6666.666666666667,10000,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B176/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B177*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B170*$B$6*$B168","v":540000},{"$f":"B182","v":525000},{"$f":"C182","v":505000},{"$f":"D182","v":480000},450000,415000,420000,385000,400000,370000,390000,{"$f":"L182","v":365000},390000,375000,360000,350000,340000,335000,375000,370000,365000]
["Kapazitäsrückgang während des Jahres",{"$f":"B170*$B$6","v":60000},{"$f":"C170*$B$6","v":65000},{"$f":"D170*$B$6","v":70000},{"$f":"E170*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M170*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B177*$B$6*$B168","v":45000},{"$f":"C177*$B$6*$B168","v":45000},{"$f":"D177*$B$6*$B168","v":45000},{"$f":"E177*$B$6*$B168","v":45000},45000,90000,0,45000,0,45000,0,{"$f":"M177*$B$6*$B168","v":45000},0,0,0,0,0,45000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B179-B180+B181","v":525000},505000,480000,450000,415000,420000,385000,400000,370000,390000,365000,390000,375000,360000,350000,340000,335000,375000,370000,365000,360000]
["Periodenkapazität am Jahresanfang",{"$f":"B170*$B$6","v":60000},65000,70000,{"$f":"E170*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M170*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E171*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M171*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B177*$B$6","v":5000},{"$f":"C177*$B$6","v":5000},{"$f":"D177*$B$6","v":5000},{"$f":"E177*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M177*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B183-B184+B185","v":65000},{"$f":"C183+C185","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",10,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B188","v":1000}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B190-B191+B197","v":13},{"$f":"C190-C191+C197","v":14},{"$f":"D190-D191+D197","v":15},16,17,7,6,6,5,5,{"$f":"L190-L191+L197","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B190","v":12},{"$f":"B197","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B190*$B$6","v":60000},{"$f":"C190*$B$6","v":65000},{"$f":"D190*$B$6","v":70000},{"$f":"E190*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M190*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F188*B190","v":12000},{"$f":"$F188*C190","v":13000},{"$f":"$F188*D190","v":14000},{"$f":"$F188*E190","v":15000},16000,17000,7000,6000,6000,5000,5000,{"$f":"$F188*M190","v":4000},3000,3000,2000,2000,1000,1000,1000,1000,1000]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F188)*B190","v":-1999.9999999999995},{"$f":"($B$5-$F188)*C190","v":-2166.6666666666661},{"$f":"($B$5-$F188)*D190","v":-2333.333333333333},{"$f":"($B$5-$F188)*E190","v":-2499.9999999999995},-2666.6666666666661,-2833.3333333333326,-1166.6666666666665,-999.99999999999977,-999.99999999999977,-833.33333333333314,-833.33333333333314,{"$f":"($B$5-$F188)*M190","v":-666.66666666666652},-499.99999999999989,-499.99999999999989,-333.33333333333326,-333.33333333333326,-166.66666666666663,-166.66666666666663,-166.66666666666663,-166.66666666666663,-166.66666666666663]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B196-B198","v":0},{"$f":"C196-C198","v":833.33333333333394},{"$f":"D196-D198","v":2500.0000000000018},5000.0000000000018,8333.3333333333358,2500.0000000000036,8333.3333333333376,3333.3333333333376,8333.3333333333376,2500.0000000000036,{"$f":"L196-L198","v":6666.6666666666706},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B193+B194+B195","v":10000},10833.333333333334,12500.000000000002,15000.000000000002,18333.333333333336,22500.000000000004,8333.3333333333376,13333.333333333338,8333.3333333333376,12500.000000000004,6666.6666666666706,10000.000000000004,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B196/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B197*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B190*$B$6*$B188","v":600000},{"$f":"B202","v":590000},{"$f":"C202","v":575000},{"$f":"D202","v":555000},530000,500000,515000,480000,500000,470000,495000,{"$f":"L202","v":470000},500000,485000,470000,460000,450000,445000,490000,485000,480000]
["Kapazitäsrückgang während des Jahres",{"$f":"B190*$B$6","v":60000},{"$f":"C190*$B$6","v":65000},{"$f":"D190*$B$6","v":70000},{"$f":"E190*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M190*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B197*$B$6*$B188","v":50000},{"$f":"C197*$B$6*$B188","v":50000},{"$f":"D197*$B$6*$B188","v":50000},{"$f":"E197*$B$6*$B188","v":50000},50000,100000,0,50000,0,50000,0,{"$f":"M197*$B$6*$B188","v":50000},0,0,0,0,0,50000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B199-B200+B201","v":590000},575000,555000,530000,500000,515000,480000,500000,470000,495000,470000,500000,485000,470000,460000,450000,445000,490000,485000,480000,475000]
["Periodenkapazität am Jahresanfang",{"$f":"B190*$B$6","v":60000},65000,70000,{"$f":"E190*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M190*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E191*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M191*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B197*$B$6","v":5000},{"$f":"C197*$B$6","v":5000},{"$f":"D197*$B$6","v":5000},{"$f":"E197*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M197*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B203-B204+B205","v":65000},{"$f":"C203+C205","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",11,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B208","v":909.09090909090912}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B210-B211+B217","v":13},{"$f":"C210-C211+C217","v":14},{"$f":"D210-D211+D217","v":15},16,17,7,6,6,5,5,{"$f":"L210-L211+L217","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B210","v":12},{"$f":"B217","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B210*$B$6","v":60000},{"$f":"C210*$B$6","v":65000},{"$f":"D210*$B$6","v":70000},{"$f":"E210*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M210*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F208*B210","v":10909.09090909091},{"$f":"$F208*C210","v":11818.181818181818},{"$f":"$F208*D210","v":12727.272727272728},{"$f":"$F208*E210","v":13636.363636363636},14545.454545454546,15454.545454545456,6363.636363636364,5454.545454545455,5454.545454545455,4545.454545454546,4545.454545454546,{"$f":"$F208*M210","v":3636.3636363636365},2727.2727272727275,2727.2727272727275,1818.1818181818182,1818.1818181818182,909.09090909090912,909.09090909090912,909.09090909090912,909.09090909090912,909.09090909090912]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F208)*B210","v":-909.09090909090901},{"$f":"($B$5-$F208)*C210","v":-984.84848484848476},{"$f":"($B$5-$F208)*D210","v":-1060.6060606060605},{"$f":"($B$5-$F208)*E210","v":-1136.3636363636363},-1212.121212121212,-1287.8787878787878,-530.30303030303025,-454.5454545454545,-454.5454545454545,-378.78787878787875,-378.78787878787875,{"$f":"($B$5-$F208)*M210","v":-303.030303030303},-227.27272727272725,-227.27272727272725,-151.5151515151515,-151.5151515151515,-75.757575757575751,-75.757575757575751,-75.757575757575751,-75.757575757575751,-75.757575757575751]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B216-B218","v":0},{"$f":"C216-C218","v":833.33333333333394},{"$f":"D216-D218","v":2500.0000000000018},5000.0000000000018,8333.3333333333358,2500.0000000000036,8333.3333333333376,3333.3333333333376,8333.3333333333376,2500.0000000000036,{"$f":"L216-L218","v":6666.6666666666706},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B213+B214+B215","v":10000},10833.333333333334,12500.000000000002,15000.000000000002,18333.333333333336,22500.000000000004,8333.3333333333376,13333.333333333338,8333.3333333333376,12500.000000000004,6666.6666666666706,10000.000000000004,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B216/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B217*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B210*$B$6*$B208","v":660000},{"$f":"B222","v":655000},{"$f":"C222","v":645000},{"$f":"D222","v":630000},610000,585000,610000,575000,600000,570000,600000,{"$f":"L222","v":575000},610000,595000,580000,570000,560000,555000,605000,600000,595000]
["Kapazitäsrückgang während des Jahres",{"$f":"B210*$B$6","v":60000},{"$f":"C210*$B$6","v":65000},{"$f":"D210*$B$6","v":70000},{"$f":"E210*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M210*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B217*$B$6*$B208","v":55000},{"$f":"C217*$B$6*$B208","v":55000},{"$f":"D217*$B$6*$B208","v":55000},{"$f":"E217*$B$6*$B208","v":55000},55000,110000,0,55000,0,55000,0,{"$f":"M217*$B$6*$B208","v":55000},0,0,0,0,0,55000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B219-B220+B221","v":655000},645000,630000,610000,585000,610000,575000,600000,570000,600000,575000,610000,595000,580000,570000,560000,555000,605000,600000,595000,590000]
["Periodenkapazität am Jahresanfang",{"$f":"B210*$B$6","v":60000},65000,70000,{"$f":"E210*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M210*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E211*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M211*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B217*$B$6","v":5000},{"$f":"C217*$B$6","v":5000},{"$f":"D217*$B$6","v":5000},{"$f":"E217*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M217*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B223-B224+B225","v":65000},{"$f":"C223+C225","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",12,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B228","v":833.33333333333337}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B230-B231+B237","v":13},{"$f":"C230-C231+C237","v":14},{"$f":"D230-D231+D237","v":15},16,17,7,6,6,5,5,{"$f":"L230-L231+L237","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B230","v":12},{"$f":"B237","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B230*$B$6","v":60000},{"$f":"C230*$B$6","v":65000},{"$f":"D230*$B$6","v":70000},{"$f":"E230*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M230*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F228*B230","v":10000},{"$f":"$F228*C230","v":10833.333333333334},{"$f":"$F228*D230","v":11666.666666666668},{"$f":"$F228*E230","v":12500},13333.333333333334,14166.666666666668,5833.3333333333339,5000,5000,4166.666666666667,4166.666666666667,{"$f":"$F228*M230","v":3333.3333333333335},2500,2500,1666.6666666666667,1666.6666666666667,833.33333333333337,833.33333333333337,833.33333333333337,833.33333333333337,833.33333333333337]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F228)*B230","v":0},{"$f":"($B$5-$F228)*C230","v":0},{"$f":"($B$5-$F228)*D230","v":0},{"$f":"($B$5-$F228)*E230","v":0},0,0,0,0,0,0,0,{"$f":"($B$5-$F228)*M230","v":0},0,0,0,0,0,0,0,0,0]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B236-B238","v":0},{"$f":"C236-C238","v":833.33333333333394},{"$f":"D236-D238","v":2500.0000000000018},5000.0000000000018,8333.3333333333358,2500.0000000000036,8333.3333333333376,3333.3333333333376,8333.3333333333376,2500.0000000000036,{"$f":"L236-L238","v":6666.6666666666706},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B233+B234+B235","v":10000},10833.333333333334,12500.000000000002,15000.000000000002,18333.333333333336,22500.000000000004,8333.3333333333376,13333.333333333338,8333.3333333333376,12500.000000000004,6666.6666666666706,10000.000000000004,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B236/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B237*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B230*$B$6*$B228","v":720000},{"$f":"B242","v":720000},{"$f":"C242","v":715000},{"$f":"D242","v":705000},690000,670000,705000,670000,700000,670000,705000,{"$f":"L242","v":680000},720000,705000,690000,680000,670000,665000,720000,715000,710000]
["Kapazitäsrückgang während des Jahres",{"$f":"B230*$B$6","v":60000},{"$f":"C230*$B$6","v":65000},{"$f":"D230*$B$6","v":70000},{"$f":"E230*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M230*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B237*$B$6*$B228","v":60000},{"$f":"C237*$B$6*$B228","v":60000},{"$f":"D237*$B$6*$B228","v":60000},{"$f":"E237*$B$6*$B228","v":60000},60000,120000,0,60000,0,60000,0,{"$f":"M237*$B$6*$B228","v":60000},0,0,0,0,0,60000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B239-B240+B241","v":720000},715000,705000,690000,670000,705000,670000,700000,670000,705000,680000,720000,705000,690000,680000,670000,665000,720000,715000,710000,705000]
["Periodenkapazität am Jahresanfang",{"$f":"B230*$B$6","v":60000},65000,70000,{"$f":"E230*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M230*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E231*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M231*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B237*$B$6","v":5000},{"$f":"C237*$B$6","v":5000},{"$f":"D237*$B$6","v":5000},{"$f":"E237*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M237*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B243-B244+B245","v":65000},{"$f":"C243+C245","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",13,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B248","v":769.23076923076928}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B250-B251+B257","v":13},{"$f":"C250-C251+C257","v":14},{"$f":"D250-D251+D257","v":15},16,17,7,6,6,5,5,{"$f":"L250-L251+L257","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B250","v":12},{"$f":"B257","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B250*$B$6","v":60000},{"$f":"C250*$B$6","v":65000},{"$f":"D250*$B$6","v":70000},{"$f":"E250*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M250*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F248*B250","v":9230.7692307692305},{"$f":"$F248*C250","v":10000},{"$f":"$F248*D250","v":10769.23076923077},{"$f":"$F248*E250","v":11538.461538461539},12307.692307692309,13076.923076923078,5384.6153846153848,4615.3846153846152,4615.3846153846152,3846.1538461538466,3846.1538461538466,{"$f":"$F248*M250","v":3076.9230769230771},2307.6923076923076,2307.6923076923076,1538.4615384615386,1538.4615384615386,769.23076923076928,769.23076923076928,769.23076923076928,769.23076923076928,769.23076923076928]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F248)*B250","v":769.23076923076906},{"$f":"($B$5-$F248)*C250","v":833.33333333333314},{"$f":"($B$5-$F248)*D250","v":897.43589743589723},{"$f":"($B$5-$F248)*E250","v":961.53846153846132},1025.6410256410254,1089.7435897435894,448.71794871794862,384.61538461538453,384.61538461538453,320.51282051282044,320.51282051282044,{"$f":"($B$5-$F248)*M250","v":256.41025641025635},192.30769230769226,192.30769230769226,128.20512820512818,128.20512820512818,64.102564102564088,64.102564102564088,64.102564102564088,64.102564102564088,64.102564102564088]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B256-B258","v":0},{"$f":"C256-C258","v":833.33333333333394},{"$f":"D256-D258","v":2500},5000,8333.3333333333358,2500.0000000000036,8333.3333333333358,3333.3333333333358,8333.3333333333358,2500.0000000000036,{"$f":"L256-L258","v":6666.6666666666706},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B253+B254+B255","v":10000},10833.333333333334,12500,15000,18333.333333333336,22500.000000000004,8333.3333333333358,13333.333333333336,8333.3333333333358,12500.000000000004,6666.6666666666706,10000.000000000004,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B256/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B257*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B250*$B$6*$B248","v":780000},{"$f":"B262","v":785000},{"$f":"C262","v":785000},{"$f":"D262","v":780000},770000,755000,800000,765000,800000,770000,810000,{"$f":"L262","v":785000},830000,815000,800000,790000,780000,775000,835000,830000,825000]
["Kapazitäsrückgang während des Jahres",{"$f":"B250*$B$6","v":60000},{"$f":"C250*$B$6","v":65000},{"$f":"D250*$B$6","v":70000},{"$f":"E250*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M250*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B257*$B$6*$B248","v":65000},{"$f":"C257*$B$6*$B248","v":65000},{"$f":"D257*$B$6*$B248","v":65000},{"$f":"E257*$B$6*$B248","v":65000},65000,130000,0,65000,0,65000,0,{"$f":"M257*$B$6*$B248","v":65000},0,0,0,0,0,65000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B259-B260+B261","v":785000},785000,780000,770000,755000,800000,765000,800000,770000,810000,785000,830000,815000,800000,790000,780000,775000,835000,830000,825000,820000]
["Periodenkapazität am Jahresanfang",{"$f":"B250*$B$6","v":60000},65000,70000,{"$f":"E250*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M250*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E251*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M251*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B257*$B$6","v":5000},{"$f":"C257*$B$6","v":5000},{"$f":"D257*$B$6","v":5000},{"$f":"E257*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M257*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B263-B264+B265","v":65000},{"$f":"C263+C265","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",14,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B268","v":714.28571428571433}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B270-B271+B277","v":13},{"$f":"C270-C271+C277","v":14},{"$f":"D270-D271+D277","v":15},16,17,7,6,6,5,5,{"$f":"L270-L271+L277","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B270","v":12},{"$f":"B277","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B270*$B$6","v":60000},{"$f":"C270*$B$6","v":65000},{"$f":"D270*$B$6","v":70000},{"$f":"E270*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M270*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F268*B270","v":8571.4285714285725},{"$f":"$F268*C270","v":9285.7142857142862},{"$f":"$F268*D270","v":10000},{"$f":"$F268*E270","v":10714.285714285716},11428.571428571429,12142.857142857143,5000,4285.7142857142862,4285.7142857142862,3571.4285714285716,3571.4285714285716,{"$f":"$F268*M270","v":2857.1428571428573},2142.8571428571431,2142.8571428571431,1428.5714285714287,1428.5714285714287,714.28571428571433,714.28571428571433,714.28571428571433,714.28571428571433,714.28571428571433]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F268)*B270","v":1428.5714285714284},{"$f":"($B$5-$F268)*C270","v":1547.6190476190475},{"$f":"($B$5-$F268)*D270","v":1666.6666666666665},{"$f":"($B$5-$F268)*E270","v":1785.7142857142856},1904.7619047619046,2023.8095238095236,833.33333333333326,714.28571428571422,714.28571428571422,595.23809523809518,595.23809523809518,{"$f":"($B$5-$F268)*M270","v":476.19047619047615},357.14285714285711,357.14285714285711,238.09523809523807,238.09523809523807,119.04761904761904,119.04761904761904,119.04761904761904,119.04761904761904,119.04761904761904]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B276-B278","v":0},{"$f":"C276-C278","v":833.33333333333394},{"$f":"D276-D278","v":2500},5000.0000000000018,8333.3333333333358,2500,8333.3333333333321,3333.3333333333321,8333.3333333333321,2500,{"$f":"L276-L278","v":6666.666666666667},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B273+B274+B275","v":10000},10833.333333333334,12500,15000.000000000002,18333.333333333336,22500,8333.3333333333321,13333.333333333332,8333.3333333333321,12500,6666.666666666667,10000,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B276/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B277*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B270*$B$6*$B268","v":840000},{"$f":"B282","v":850000},{"$f":"C282","v":855000},{"$f":"D282","v":855000},850000,840000,895000,860000,900000,870000,915000,{"$f":"L282","v":890000},940000,925000,910000,900000,890000,885000,950000,945000,940000]
["Kapazitäsrückgang während des Jahres",{"$f":"B270*$B$6","v":60000},{"$f":"C270*$B$6","v":65000},{"$f":"D270*$B$6","v":70000},{"$f":"E270*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M270*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B277*$B$6*$B268","v":70000},{"$f":"C277*$B$6*$B268","v":70000},{"$f":"D277*$B$6*$B268","v":70000},{"$f":"E277*$B$6*$B268","v":70000},70000,140000,0,70000,0,70000,0,{"$f":"M277*$B$6*$B268","v":70000},0,0,0,0,0,70000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B279-B280+B281","v":850000},855000,855000,850000,840000,895000,860000,900000,870000,915000,890000,940000,925000,910000,900000,890000,885000,950000,945000,940000,935000]
["Periodenkapazität am Jahresanfang",{"$f":"B270*$B$6","v":60000},65000,70000,{"$f":"E270*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M270*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E271*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M271*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B277*$B$6","v":5000},{"$f":"C277*$B$6","v":5000},{"$f":"D277*$B$6","v":5000},{"$f":"E277*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M277*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B283-B284+B285","v":65000},{"$f":"C283+C285","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",15,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B288","v":666.66666666666663}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B290-B291+B297","v":13},{"$f":"C290-C291+C297","v":14},{"$f":"D290-D291+D297","v":15},16,17,7,6,6,5,5,{"$f":"L290-L291+L297","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B290","v":12},{"$f":"B297","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B290*$B$6","v":60000},{"$f":"C290*$B$6","v":65000},{"$f":"D290*$B$6","v":70000},{"$f":"E290*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M290*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F288*B290","v":8000},{"$f":"$F288*C290","v":8666.6666666666661},{"$f":"$F288*D290","v":9333.3333333333321},{"$f":"$F288*E290","v":10000},10666.666666666666,11333.333333333332,4666.6666666666661,4000,4000,3333.333333333333,3333.333333333333,{"$f":"$F288*M290","v":2666.6666666666665},2000,2000,1333.3333333333333,1333.3333333333333,666.66666666666663,666.66666666666663,666.66666666666663,666.66666666666663,666.66666666666663]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F288)*B290","v":2000.0000000000009},{"$f":"($B$5-$F288)*C290","v":2166.6666666666679},{"$f":"($B$5-$F288)*D290","v":2333.3333333333344},{"$f":"($B$5-$F288)*E290","v":2500.0000000000009},2666.6666666666679,2833.3333333333348,1166.6666666666672,1000.0000000000005,1000.0000000000005,833.33333333333371,833.33333333333371,{"$f":"($B$5-$F288)*M290","v":666.66666666666697},500.00000000000023,500.00000000000023,333.33333333333348,333.33333333333348,166.66666666666674,166.66666666666674,166.66666666666674,166.66666666666674,166.66666666666674]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B296-B298","v":0},{"$f":"C296-C298","v":833.33333333333394},{"$f":"D296-D298","v":2500},5000,8333.3333333333358,2500.0000000000036,8333.3333333333358,3333.3333333333358,8333.3333333333358,2500.0000000000036,{"$f":"L296-L298","v":6666.6666666666706},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B293+B294+B295","v":10000},10833.333333333334,12500,15000,18333.333333333336,22500.000000000004,8333.3333333333358,13333.333333333336,8333.3333333333358,12500.000000000004,6666.6666666666706,10000.000000000004,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B296/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B297*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B290*$B$6*$B288","v":900000},{"$f":"B302","v":915000},{"$f":"C302","v":925000},{"$f":"D302","v":930000},930000,925000,990000,955000,1000000,970000,1020000,{"$f":"L302","v":995000},1050000,1035000,1020000,1010000,1000000,995000,1065000,1060000,1055000]
["Kapazitäsrückgang während des Jahres",{"$f":"B290*$B$6","v":60000},{"$f":"C290*$B$6","v":65000},{"$f":"D290*$B$6","v":70000},{"$f":"E290*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M290*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B297*$B$6*$B288","v":75000},{"$f":"C297*$B$6*$B288","v":75000},{"$f":"D297*$B$6*$B288","v":75000},{"$f":"E297*$B$6*$B288","v":75000},75000,150000,0,75000,0,75000,0,{"$f":"M297*$B$6*$B288","v":75000},0,0,0,0,0,75000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B299-B300+B301","v":915000},925000,930000,930000,925000,990000,955000,1000000,970000,1020000,995000,1050000,1035000,1020000,1010000,1000000,995000,1065000,1060000,1055000,1050000]
["Periodenkapazität am Jahresanfang",{"$f":"B290*$B$6","v":60000},65000,70000,{"$f":"E290*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M290*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E291*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M291*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B297*$B$6","v":5000},{"$f":"C297*$B$6","v":5000},{"$f":"D297*$B$6","v":5000},{"$f":"E297*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M297*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B303-B304+B305","v":65000},{"$f":"C303+C305","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",16,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B308","v":625}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B310-B311+B317","v":13},{"$f":"C310-C311+C317","v":14},{"$f":"D310-D311+D317","v":15},16,17,7,6,6,5,5,{"$f":"L310-L311+L317","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B310","v":12},{"$f":"B317","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B310*$B$6","v":60000},{"$f":"C310*$B$6","v":65000},{"$f":"D310*$B$6","v":70000},{"$f":"E310*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M310*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F308*B310","v":7500},{"$f":"$F308*C310","v":8125},{"$f":"$F308*D310","v":8750},{"$f":"$F308*E310","v":9375},10000,10625,4375,3750,3750,3125,3125,{"$f":"$F308*M310","v":2500},1875,1875,1250,1250,625,625,625,625,625]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F308)*B310","v":2500.0000000000005},{"$f":"($B$5-$F308)*C310","v":2708.3333333333339},{"$f":"($B$5-$F308)*D310","v":2916.666666666667},{"$f":"($B$5-$F308)*E310","v":3125.0000000000005},3333.3333333333339,3541.6666666666674,1458.3333333333335,1250.0000000000002,1250.0000000000002,1041.666666666667,1041.666666666667,{"$f":"($B$5-$F308)*M310","v":833.33333333333348},625.00000000000011,625.00000000000011,416.66666666666674,416.66666666666674,208.33333333333337,208.33333333333337,208.33333333333337,208.33333333333337,208.33333333333337]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B316-B318","v":0},{"$f":"C316-C318","v":833.33333333333394},{"$f":"D316-D318","v":2500.0000000000018},5000.0000000000018,8333.3333333333358,2500.0000000000036,8333.3333333333376,3333.3333333333376,8333.3333333333376,2500.0000000000036,{"$f":"L316-L318","v":6666.6666666666706},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B313+B314+B315","v":10000},10833.333333333334,12500.000000000002,15000.000000000002,18333.333333333336,22500.000000000004,8333.3333333333376,13333.333333333338,8333.3333333333376,12500.000000000004,6666.6666666666706,10000.000000000004,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B316/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B317*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B310*$B$6*$B308","v":960000},{"$f":"B322","v":980000},{"$f":"C322","v":995000},{"$f":"D322","v":1005000},1010000,1010000,1085000,1050000,1100000,1070000,1125000,{"$f":"L322","v":1100000},1160000,1145000,1130000,1120000,1110000,1105000,1180000,1175000,1170000]
["Kapazitäsrückgang während des Jahres",{"$f":"B310*$B$6","v":60000},{"$f":"C310*$B$6","v":65000},{"$f":"D310*$B$6","v":70000},{"$f":"E310*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M310*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B317*$B$6*$B308","v":80000},{"$f":"C317*$B$6*$B308","v":80000},{"$f":"D317*$B$6*$B308","v":80000},{"$f":"E317*$B$6*$B308","v":80000},80000,160000,0,80000,0,80000,0,{"$f":"M317*$B$6*$B308","v":80000},0,0,0,0,0,80000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B319-B320+B321","v":980000},995000,1005000,1010000,1010000,1085000,1050000,1100000,1070000,1125000,1100000,1160000,1145000,1130000,1120000,1110000,1105000,1180000,1175000,1170000,1165000]
["Periodenkapazität am Jahresanfang",{"$f":"B310*$B$6","v":60000},65000,70000,{"$f":"E310*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M310*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E311*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M311*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B317*$B$6","v":5000},{"$f":"C317*$B$6","v":5000},{"$f":"D317*$B$6","v":5000},{"$f":"E317*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M317*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B323-B324+B325","v":65000},{"$f":"C323+C325","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",17,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B328","v":588.23529411764707}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B330-B331+B337","v":13},{"$f":"C330-C331+C337","v":14},{"$f":"D330-D331+D337","v":15},16,17,7,6,6,5,5,{"$f":"L330-L331+L337","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B330","v":12},{"$f":"B337","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B330*$B$6","v":60000},{"$f":"C330*$B$6","v":65000},{"$f":"D330*$B$6","v":70000},{"$f":"E330*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M330*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F328*B330","v":7058.8235294117649},{"$f":"$F328*C330","v":7647.0588235294117},{"$f":"$F328*D330","v":8235.2941176470595},{"$f":"$F328*E330","v":8823.5294117647063},9411.7647058823532,10000,4117.6470588235297,3529.4117647058824,3529.4117647058824,2941.1764705882351,2941.1764705882351,{"$f":"$F328*M330","v":2352.9411764705883},1764.7058823529412,1764.7058823529412,1176.4705882352941,1176.4705882352941,588.23529411764707,588.23529411764707,588.23529411764707,588.23529411764707,588.23529411764707]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F328)*B330","v":2941.1764705882356},{"$f":"($B$5-$F328)*C330","v":3186.2745098039218},{"$f":"($B$5-$F328)*D330","v":3431.3725490196084},{"$f":"($B$5-$F328)*E330","v":3676.4705882352946},3921.5686274509808,4166.666666666667,1715.6862745098042,1470.5882352941178,1470.5882352941178,1225.4901960784314,1225.4901960784314,{"$f":"($B$5-$F328)*M330","v":980.3921568627452},735.2941176470589,735.2941176470589,490.1960784313726,490.1960784313726,245.0980392156863,245.0980392156863,245.0980392156863,245.0980392156863,245.0980392156863]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B336-B338","v":0},{"$f":"C336-C338","v":833.33333333333394},{"$f":"D336-D338","v":2500.0000000000018},5000.0000000000018,8333.3333333333358,2500.0000000000036,8333.3333333333376,3333.3333333333376,8333.3333333333376,2500.0000000000036,{"$f":"L336-L338","v":6666.6666666666697},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B333+B334+B335","v":10000},10833.333333333334,12500.000000000002,15000.000000000002,18333.333333333336,22500.000000000004,8333.3333333333376,13333.333333333338,8333.3333333333376,12500.000000000004,6666.6666666666697,10000.000000000004,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B336/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B337*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B330*$B$6*$B328","v":1020000},{"$f":"B342","v":1045000},{"$f":"C342","v":1065000},{"$f":"D342","v":1080000},1090000,1095000,1180000,1145000,1200000,1170000,1230000,{"$f":"L342","v":1205000},1270000,1255000,1240000,1230000,1220000,1215000,1295000,1290000,1285000]
["Kapazitäsrückgang während des Jahres",{"$f":"B330*$B$6","v":60000},{"$f":"C330*$B$6","v":65000},{"$f":"D330*$B$6","v":70000},{"$f":"E330*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M330*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B337*$B$6*$B328","v":85000},{"$f":"C337*$B$6*$B328","v":85000},{"$f":"D337*$B$6*$B328","v":85000},{"$f":"E337*$B$6*$B328","v":85000},85000,170000,0,85000,0,85000,0,{"$f":"M337*$B$6*$B328","v":85000},0,0,0,0,0,85000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B339-B340+B341","v":1045000},1065000,1080000,1090000,1095000,1180000,1145000,1200000,1170000,1230000,1205000,1270000,1255000,1240000,1230000,1220000,1215000,1295000,1290000,1285000,1280000]
["Periodenkapazität am Jahresanfang",{"$f":"B330*$B$6","v":60000},65000,70000,{"$f":"E330*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M330*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E331*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M331*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B337*$B$6","v":5000},{"$f":"C337*$B$6","v":5000},{"$f":"D337*$B$6","v":5000},{"$f":"E337*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M337*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B343-B344+B345","v":65000},{"$f":"C343+C345","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",18,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B348","v":555.55555555555554}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B350-B351+B357","v":13},{"$f":"C350-C351+C357","v":14},{"$f":"D350-D351+D357","v":15},16,17,7,6,6,5,5,{"$f":"L350-L351+L357","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B350","v":12},{"$f":"B357","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B350*$B$6","v":60000},{"$f":"C350*$B$6","v":65000},{"$f":"D350*$B$6","v":70000},{"$f":"E350*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M350*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F348*B350","v":6666.6666666666661},{"$f":"$F348*C350","v":7222.2222222222217},{"$f":"$F348*D350","v":7777.7777777777774},{"$f":"$F348*E350","v":8333.3333333333339},8888.8888888888887,9444.4444444444434,3888.8888888888887,3333.333333333333,3333.333333333333,2777.7777777777778,2777.7777777777778,{"$f":"$F348*M350","v":2222.2222222222222},1666.6666666666665,1666.6666666666665,1111.1111111111111,1111.1111111111111,555.55555555555554,555.55555555555554,555.55555555555554,555.55555555555554,555.55555555555554]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F348)*B350","v":3333.3333333333339},{"$f":"($B$5-$F348)*C350","v":3611.1111111111118},{"$f":"($B$5-$F348)*D350","v":3888.8888888888896},{"$f":"($B$5-$F348)*E350","v":4166.6666666666679},4444.4444444444453,4722.2222222222226,1944.4444444444448,1666.666666666667,1666.666666666667,1388.8888888888891,1388.8888888888891,{"$f":"($B$5-$F348)*M350","v":1111.1111111111113},833.33333333333348,833.33333333333348,555.55555555555566,555.55555555555566,277.77777777777783,277.77777777777783,277.77777777777783,277.77777777777783,277.77777777777783]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B356-B358","v":0},{"$f":"C356-C358","v":833.33333333333394},{"$f":"D356-D358","v":2500.0000000000018},5000.0000000000036,8333.3333333333358,2500,8333.3333333333339,3333.3333333333339,8333.3333333333339,2500,{"$f":"L356-L358","v":6666.666666666667},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B353+B354+B355","v":10000},10833.333333333334,12500.000000000002,15000.000000000004,18333.333333333336,22500,8333.3333333333339,13333.333333333334,8333.3333333333339,12500,6666.666666666667,10000,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B356/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B357*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B350*$B$6*$B348","v":1080000},{"$f":"B362","v":1110000},{"$f":"C362","v":1135000},{"$f":"D362","v":1155000},1170000,1180000,1275000,1240000,1300000,1270000,1335000,{"$f":"L362","v":1310000},1380000,1365000,1350000,1340000,1330000,1325000,1410000,1405000,1400000]
["Kapazitäsrückgang während des Jahres",{"$f":"B350*$B$6","v":60000},{"$f":"C350*$B$6","v":65000},{"$f":"D350*$B$6","v":70000},{"$f":"E350*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M350*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B357*$B$6*$B348","v":90000},{"$f":"C357*$B$6*$B348","v":90000},{"$f":"D357*$B$6*$B348","v":90000},{"$f":"E357*$B$6*$B348","v":90000},90000,180000,0,90000,0,90000,0,{"$f":"M357*$B$6*$B348","v":90000},0,0,0,0,0,90000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B359-B360+B361","v":1110000},1135000,1155000,1170000,1180000,1275000,1240000,1300000,1270000,1335000,1310000,1380000,1365000,1350000,1340000,1330000,1325000,1410000,1405000,1400000,1395000]
["Periodenkapazität am Jahresanfang",{"$f":"B350*$B$6","v":60000},65000,70000,{"$f":"E350*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M350*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E351*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M351*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B357*$B$6","v":5000},{"$f":"C357*$B$6","v":5000},{"$f":"D357*$B$6","v":5000},{"$f":"E357*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M357*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B363-B364+B365","v":65000},{"$f":"C363+C365","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",19,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B368","v":526.31578947368416}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B370-B371+B377","v":13},{"$f":"C370-C371+C377","v":14},{"$f":"D370-D371+D377","v":15},16,17,7,6,6,5,5,{"$f":"L370-L371+L377","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B370","v":12},{"$f":"B377","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B370*$B$6","v":60000},{"$f":"C370*$B$6","v":65000},{"$f":"D370*$B$6","v":70000},{"$f":"E370*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M370*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F368*B370","v":6315.78947368421},{"$f":"$F368*C370","v":6842.1052631578941},{"$f":"$F368*D370","v":7368.4210526315783},{"$f":"$F368*E370","v":7894.7368421052624},8421.0526315789466,8947.3684210526299,3684.2105263157891,3157.894736842105,3157.894736842105,2631.5789473684208,2631.5789473684208,{"$f":"$F368*M370","v":2105.2631578947367},1578.9473684210525,1578.9473684210525,1052.6315789473683,1052.6315789473683,526.31578947368416,526.31578947368416,526.31578947368416,526.31578947368416,526.31578947368416]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F368)*B370","v":3684.2105263157905},{"$f":"($B$5-$F368)*C370","v":3991.2280701754398},{"$f":"($B$5-$F368)*D370","v":4298.2456140350887},{"$f":"($B$5-$F368)*E370","v":4605.2631578947385},4912.2807017543873,5219.2982456140362,2149.1228070175443,1842.1052631578953,1842.1052631578953,1535.0877192982462,1535.0877192982462,{"$f":"($B$5-$F368)*M370","v":1228.0701754385968},921.05263157894763,921.05263157894763,614.03508771929842,614.03508771929842,307.01754385964921,307.01754385964921,307.01754385964921,307.01754385964921,307.01754385964921]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B376-B378","v":0},{"$f":"C376-C378","v":833.33333333333394},{"$f":"D376-D378","v":2500.0000000000018},5000.0000000000018,8333.3333333333358,2500,8333.3333333333339,3333.3333333333339,8333.3333333333339,2500,{"$f":"L376-L378","v":6666.666666666667},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B373+B374+B375","v":10000},10833.333333333334,12500.000000000002,15000.000000000002,18333.333333333336,22500,8333.3333333333339,13333.333333333334,8333.3333333333339,12500,6666.666666666667,10000,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B376/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B377*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B370*$B$6*$B368","v":1140000},{"$f":"B382","v":1175000},{"$f":"C382","v":1205000},{"$f":"D382","v":1230000},1250000,1265000,1370000,1335000,1400000,1370000,1440000,{"$f":"L382","v":1415000},1490000,1475000,1460000,1450000,1440000,1435000,1525000,1520000,1515000]
["Kapazitäsrückgang während des Jahres",{"$f":"B370*$B$6","v":60000},{"$f":"C370*$B$6","v":65000},{"$f":"D370*$B$6","v":70000},{"$f":"E370*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M370*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B377*$B$6*$B368","v":95000},{"$f":"C377*$B$6*$B368","v":95000},{"$f":"D377*$B$6*$B368","v":95000},{"$f":"E377*$B$6*$B368","v":95000},95000,190000,0,95000,0,95000,0,{"$f":"M377*$B$6*$B368","v":95000},0,0,0,0,0,95000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B379-B380+B381","v":1175000},1205000,1230000,1250000,1265000,1370000,1335000,1400000,1370000,1440000,1415000,1490000,1475000,1460000,1450000,1440000,1435000,1525000,1520000,1515000,1510000]
["Periodenkapazität am Jahresanfang",{"$f":"B370*$B$6","v":60000},65000,70000,{"$f":"E370*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M370*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E371*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M371*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B377*$B$6","v":5000},{"$f":"C377*$B$6","v":5000},{"$f":"D377*$B$6","v":5000},{"$f":"E377*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M377*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B383-B384+B385","v":65000},{"$f":"C383+C385","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]
[]
["kalkulatorische Nutzungsdauer in Jahren",20,"kalkulatorische Abschreibung je Machine",null,null,{"$f":"$B$2/$B388","v":500}]
["Periode",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Maschinenbestand",{"$f":"$B$4","v":12},{"$f":"B390-B391+B397","v":13},{"$f":"C390-C391+C397","v":14},{"$f":"D390-D391+D397","v":15},16,17,7,6,6,5,5,{"$f":"L390-L391+L397","v":4},3,3,2,2,1,1,1,1,1]
["Betriebsmittelabgang",0,0,0,0,0,{"$f":"B390","v":12},{"$f":"B397","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0]
["Kapazitäsrückgang während des Jahres",{"$f":"B390*$B$6","v":60000},{"$f":"C390*$B$6","v":65000},{"$f":"D390*$B$6","v":70000},{"$f":"E390*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M390*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Kapitalfreisetzung am Jahresende",{"$f":"$F388*B390","v":6000},{"$f":"$F388*C390","v":6500},{"$f":"$F388*D390","v":7000},{"$f":"$F388*E390","v":7500},8000,8500,3500,3000,3000,2500,2500,{"$f":"$F388*M390","v":2000},1500,1500,1000,1000,500,500,500,500,500]
["Freisetzung aus stiller Selbstfinanzierung am Jahresende",{"$f":"($B$5-$F388)*B390","v":4000.0000000000005},{"$f":"($B$5-$F388)*C390","v":4333.3333333333339},{"$f":"($B$5-$F388)*D390","v":4666.666666666667},{"$f":"($B$5-$F388)*E390","v":5000.0000000000009},5333.3333333333339,5666.666666666667,2333.3333333333335,2000.0000000000002,2000.0000000000002,1666.666666666667,1666.666666666667,{"$f":"($B$5-$F388)*M390","v":1333.3333333333335},1000.0000000000001,1000.0000000000001,666.66666666666674,666.66666666666674,333.33333333333337,333.33333333333337,333.33333333333337,333.33333333333337,333.33333333333337]
["freigesetzte Mittel aus Vorjahr",0,{"$f":"B396-B398","v":0},{"$f":"C396-C398","v":833.33333333333394},{"$f":"D396-D398","v":2500.0000000000018},5000.0000000000018,8333.3333333333358,2500.0000000000036,8333.3333333333376,3333.3333333333376,8333.3333333333376,2500.0000000000036,{"$f":"L396-L398","v":6666.6666666666706},0,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,0,833.33333333333337,1666.6666666666667]
["Gesamtfreisetzung",{"$f":"B393+B394+B395","v":10000},10833.333333333334,12500.000000000002,15000.000000000002,18333.333333333336,22500.000000000004,8333.3333333333376,13333.333333333338,8333.3333333333376,12500.000000000004,6666.6666666666706,10000.000000000004,2500,5000,6666.666666666667,8333.3333333333339,9166.6666666666679,10000.000000000002,833.33333333333337,1666.6666666666667,2500]
["Anzahl neuer Maschinen",{"$f":"INT(B396/$B$2)","v":1},1,1,1,1,2,0,1,0,1,0,1,0,0,0,0,0,1,0,0,0]
["Investition",{"$f":"B397*$B$2","v":10000},10000,10000,10000,10000,20000,0,10000,0,10000,0,10000,0,0,0,0,0,10000,0,0,0]
["Gesamtkapazität Jahresanfang",{"$f":"B390*$B$6*$B388","v":1200000},{"$f":"B402","v":1240000},{"$f":"C402","v":1275000},{"$f":"D402","v":1305000},1330000,1350000,1465000,1430000,1500000,1470000,1545000,{"$f":"L402","v":1520000},1600000,1585000,1570000,1560000,1550000,1545000,1640000,1635000,1630000]
["Kapazitäsrückgang während des Jahres",{"$f":"B390*$B$6","v":60000},{"$f":"C390*$B$6","v":65000},{"$f":"D390*$B$6","v":70000},{"$f":"E390*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M390*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Gesamtkapazitätszunahme",{"$f":"B397*$B$6*$B388","v":100000},{"$f":"C397*$B$6*$B388","v":100000},{"$f":"D397*$B$6*$B388","v":100000},{"$f":"E397*$B$6*$B388","v":100000},100000,200000,0,100000,0,100000,0,{"$f":"M397*$B$6*$B388","v":100000},0,0,0,0,0,100000,0,0,0]
["Gesamtkapazität Jahresende",{"$f":"B399-B400+B401","v":1240000},1275000,1305000,1330000,1350000,1465000,1430000,1500000,1470000,1545000,1520000,1600000,1585000,1570000,1560000,1550000,1545000,1640000,1635000,1630000,1625000]
["Periodenkapazität am Jahresanfang",{"$f":"B390*$B$6","v":60000},65000,70000,{"$f":"E390*$B$6","v":75000},80000,85000,35000,30000,30000,25000,25000,{"$f":"M390*$B$6","v":20000},15000,15000,10000,10000,5000,5000,5000,5000,5000]
["Periodenkapazitätsabnahme",0,0,0,{"$f":"E391*$B$6","v":0},0,60000,5000,5000,5000,5000,5000,{"$f":"M391*$B$6","v":10000},0,5000,0,5000,0,5000,0,0,0]
["Periodenkapazitätszunahme",{"$f":"B397*$B$6","v":5000},{"$f":"C397*$B$6","v":5000},{"$f":"D397*$B$6","v":5000},{"$f":"E397*$B$6","v":5000},5000,10000,0,5000,0,5000,0,{"$f":"M397*$B$6","v":5000},0,0,0,0,0,5000,0,0,0]
["Periodenkapazität am Jahresende",{"$f":"B403-B404+B405","v":65000},{"$f":"C403+C405","v":70000},75000,80000,85000,95000,35000,35000,30000,30000,25000,25000,15000,15000,10000,10000,5000,10000,5000,5000,5000]

{"sheet":"Diagramme","index":2,"n_rows":383,"n_cols":5,"rows_kept":383,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,8]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,9]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,11]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,12]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,13]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,14]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,15]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,16]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,17]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,18]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,19]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulatorische Nutzungsdauer :",null,null,20]