{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["BEP","Daten"],"not_rendered":{"charts":1,"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":"BEP","index":0,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,1,1,4],[39,1,39,2],[39,3,39,4],[13,1,14,2],[24,1,25,2],[5,1,5,2],[10,1,10,2],[43,1,43,2],[43,3,43,4],[16,1,19,2],[15,1,15,2]]}
[]
[null,"Wo ist der Break-Even-Point?"]
[]
[]
[]
[null,"Eingabewerte"]
[null,"variable Stückkosten",20]
[null,"Stückpreis",40]
[null,"fixe Kosten",50000]
[null,"Kapazitätsgrenze",6000]
[null,"Break-Even-Point"]
[null,"Deckungsbeitrag",{"$f":"C8-C7","v":20}]
[null,"Break-Even-Point",{"$f":"ROUNDUP(C9/C12,0)","v":2500}]
[null,{"$f":"IF(C13>C10,\"Break-Even-Point nicht erreichbar!\",\"\")","v":""}]
[]
[null,"Auftragsberechnung"]
[null,"Berechnen Sie den Unternehmenserfolg bei verschiedenen Produktionsmengen."]
[]
[]
[]
[null,"Produktionsmenge",5500]
[null,"Erlös",{"$f":"C21*C8","v":220000}]
[null,"Kosten",{"$f":"(C21*C7)+C9","v":160000}]
[null,"Gewinn/Verlust",{"$f":"C22-C23","v":60000}]
[null,{"$f":"IF(C24<0,\"Verlust!\",\"Gewinn!\")","v":"Gewinn!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Break-Even-Menge",null,"Kosten = Erlös"]
[null,{"$f":"C13","v":2500},0,0,{"$f":"C42","v":100000}]
[null,{"$f":"C13","v":2500},{"$f":"C13*C7+C9","v":100000},{"$f":"C13","v":2500},{"$f":"C42","v":100000}]
[]
[null,"Kapazitäsgrenze",null,"Gewinn"]
[null,{"$f":"C10","v":6000},0,{"$f":"C21","v":5500},{"$f":"C23","v":160000}]
[null,{"$f":"C10","v":6000},{"$f":"C8*C10","v":240000},{"$f":"C21","v":5500},{"$f":"C22","v":220000}]

{"sheet":"Daten","index":1,"n_rows":103,"n_cols":7,"rows_kept":103,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Datenreihen"]
[null,"Menge","fixe Kosten","variable Kosten","Gesamtkosten","Erlös","Gewinn"]
[1,0,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B4<1,0,B4*BEP!$C$7)","v":0},{"$f":"IF(B4<1,C4,C4+D4)","v":50000},{"$f":"B4*BEP!$C$8","v":0},{"$f":"F4-E4","v":-50000}]
[2,{"$f":"BEP!$C$10/99","v":60.606060606060609},{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B5<1,\"\",B5*BEP!$C$7)","v":1212.1212121212122},{"$f":"IF(B5<1,C5,C5+D5)","v":51212.121212121216},{"$f":"B5*BEP!$C$8","v":2424.2424242424245},{"$f":"F5-E5","v":-48787.878787878792}]
[3,{"$f":"B5+$B$5","v":121.21212121212122},{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B6<1,\"\",B6*BEP!$C$7)","v":2424.2424242424245},52424.242424242424,{"$f":"B6*BEP!$C$8","v":4848.484848484849},-47575.757575757576]
[4,{"$f":"B6+$B$5","v":181.81818181818181},{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B7<1,\"\",B7*BEP!$C$7)","v":3636.363636363636},53636.363636363632,{"$f":"B7*BEP!$C$8","v":7272.7272727272721},-46363.63636363636]
[5,242.42424242424244,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B8<1,\"\",B8*BEP!$C$7)","v":4848.484848484849},54848.484848484848,{"$f":"B8*BEP!$C$8","v":9696.9696969696979},-45151.515151515152]
[6,303.03030303030306,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B9<1,\"\",B9*BEP!$C$7)","v":6060.606060606061},56060.606060606064,{"$f":"B9*BEP!$C$8","v":12121.212121212122},-43939.393939393944]
[7,363.63636363636368,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B10<1,\"\",B10*BEP!$C$7)","v":7272.7272727272739},57272.727272727272,{"$f":"B10*BEP!$C$8","v":14545.454545454548},-42727.272727272721]
[8,424.24242424242431,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B11<1,\"\",B11*BEP!$C$7)","v":8484.8484848484859},58484.848484848488,{"$f":"B11*BEP!$C$8","v":16969.696969696972},-41515.15151515152]
[9,484.84848484848493,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B12<1,\"\",B12*BEP!$C$7)","v":9696.9696969696979},59696.969696969696,{"$f":"B12*BEP!$C$8","v":19393.939393939396},-40303.030303030304]
[10,545.4545454545455,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B13<1,\"\",B13*BEP!$C$7)","v":10909.09090909091},60909.090909090912,{"$f":"B13*BEP!$C$8","v":21818.18181818182},-39090.909090909088]
[11,606.06060606060612,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B14<1,\"\",B14*BEP!$C$7)","v":12121.212121212122},62121.21212121212,{"$f":"B14*BEP!$C$8","v":24242.424242424244},-37878.787878787873]
[12,666.66666666666674,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B15<1,\"\",B15*BEP!$C$7)","v":13333.333333333336},63333.333333333336,{"$f":"B15*BEP!$C$8","v":26666.666666666672},-36666.666666666664]
[13,727.27272727272737,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B16<1,\"\",B16*BEP!$C$7)","v":14545.454545454548},64545.454545454544,{"$f":"B16*BEP!$C$8","v":29090.909090909096},-35454.545454545449]
[14,787.87878787878799,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B17<1,\"\",B17*BEP!$C$7)","v":15757.57575757576},65757.57575757576,{"$f":"B17*BEP!$C$8","v":31515.15151515152},-34242.42424242424]
[15,848.48484848484861,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B18<1,\"\",B18*BEP!$C$7)","v":16969.696969696972},66969.696969696975,{"$f":"B18*BEP!$C$8","v":33939.393939393944},-33030.303030303032]
[16,909.09090909090924,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B19<1,\"\",B19*BEP!$C$7)","v":18181.818181818184},68181.818181818177,{"$f":"B19*BEP!$C$8","v":36363.636363636368},-31818.181818181809]
[17,969.69696969696986,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B20<1,\"\",B20*BEP!$C$7)","v":19393.939393939396},69393.939393939392,{"$f":"B20*BEP!$C$8","v":38787.878787878792},-30606.060606060601]
[18,1030.3030303030305,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B21<1,\"\",B21*BEP!$C$7)","v":20606.060606060608},70606.060606060608,{"$f":"B21*BEP!$C$8","v":41212.121212121216},-29393.939393939392]
[19,1090.909090909091,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B22<1,\"\",B22*BEP!$C$7)","v":21818.18181818182},71818.181818181823,{"$f":"B22*BEP!$C$8","v":43636.36363636364},-28181.818181818184]
[20,1151.5151515151515,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B23<1,\"\",B23*BEP!$C$7)","v":23030.303030303032},73030.303030303039,{"$f":"B23*BEP!$C$8","v":46060.606060606064},-26969.696969696975]
[21,1212.121212121212,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B24<1,\"\",B24*BEP!$C$7)","v":24242.42424242424},74242.42424242424,{"$f":"B24*BEP!$C$8","v":48484.84848484848},-25757.57575757576]
[22,1272.7272727272725,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B25<1,\"\",B25*BEP!$C$7)","v":25454.545454545449},75454.545454545441,{"$f":"B25*BEP!$C$8","v":50909.090909090897},-24545.454545454544]
[23,1333.333333333333,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B26<1,\"\",B26*BEP!$C$7)","v":26666.666666666661},76666.666666666657,{"$f":"B26*BEP!$C$8","v":53333.333333333321},-23333.333333333336]
[24,1393.9393939393935,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B27<1,\"\",B27*BEP!$C$7)","v":27878.787878787873},77878.787878787873,{"$f":"B27*BEP!$C$8","v":55757.575757575745},-22121.212121212127]
[25,1454.545454545454,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B28<1,\"\",B28*BEP!$C$7)","v":29090.909090909081},79090.909090909088,{"$f":"B28*BEP!$C$8","v":58181.818181818162},-20909.090909090926]
[26,1515.1515151515146,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B29<1,\"\",B29*BEP!$C$7)","v":30303.030303030289},80303.030303030289,{"$f":"B29*BEP!$C$8","v":60606.060606060579},-19696.969696969711]
[27,1575.7575757575751,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B30<1,\"\",B30*BEP!$C$7)","v":31515.151515151501},81515.151515151505,{"$f":"B30*BEP!$C$8","v":63030.303030303003},-18484.848484848502]
[28,1636.3636363636356,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B31<1,\"\",B31*BEP!$C$7)","v":32727.272727272713},82727.272727272706,{"$f":"B31*BEP!$C$8","v":65454.545454545427},-17272.727272727279]
[29,1696.9696969696961,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B32<1,\"\",B32*BEP!$C$7)","v":33939.393939393922},83939.393939393922,{"$f":"B32*BEP!$C$8","v":67878.787878787844},-16060.606060606078]
[30,1757.5757575757566,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B33<1,\"\",B33*BEP!$C$7)","v":35151.51515151513},85151.515151515137,{"$f":"B33*BEP!$C$8","v":70303.03030303026},-14848.484848484877]
[31,1818.1818181818171,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B34<1,\"\",B34*BEP!$C$7)","v":36363.636363636339},86363.636363636339,{"$f":"B34*BEP!$C$8","v":72727.272727272677},-13636.363636363661]
[32,1878.7878787878776,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B35<1,\"\",B35*BEP!$C$7)","v":37575.757575757554},87575.757575757554,{"$f":"B35*BEP!$C$8","v":75151.515151515108},-12424.242424242446]
[33,1939.3939393939381,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B36<1,\"\",B36*BEP!$C$7)","v":38787.878787878763},88787.878787878755,{"$f":"B36*BEP!$C$8","v":77575.757575757525},-11212.12121212123]
[34,1999.9999999999986,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B37<1,\"\",B37*BEP!$C$7)","v":39999.999999999971},89999.999999999971,{"$f":"B37*BEP!$C$8","v":79999.999999999942},-10000.000000000029]
[35,2060.6060606060591,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B38<1,\"\",B38*BEP!$C$7)","v":41212.121212121187},91212.121212121187,{"$f":"B38*BEP!$C$8","v":82424.242424242373},-8787.8787878788135]
[36,2121.2121212121197,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B39<1,\"\",B39*BEP!$C$7)","v":42424.242424242395},92424.242424242402,{"$f":"B39*BEP!$C$8","v":84848.48484848479},-7575.7575757576124]
[37,2181.8181818181802,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B40<1,\"\",B40*BEP!$C$7)","v":43636.363636363603},93636.363636363603,{"$f":"B40*BEP!$C$8","v":87272.727272727207},-6363.6363636363967]
[38,2242.4242424242407,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B41<1,\"\",B41*BEP!$C$7)","v":44848.484848484812},94848.484848484804,{"$f":"B41*BEP!$C$8","v":89696.969696969623},-5151.5151515151811]
[39,2303.0303030303012,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B42<1,\"\",B42*BEP!$C$7)","v":46060.60606060602},96060.60606060602,{"$f":"B42*BEP!$C$8","v":92121.21212121204},-3939.39393939398]
[40,2363.6363636363617,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B43<1,\"\",B43*BEP!$C$7)","v":47272.727272727236},97272.727272727236,{"$f":"B43*BEP!$C$8","v":94545.454545454471},-2727.2727272727643]
[41,2424.2424242424222,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B44<1,\"\",B44*BEP!$C$7)","v":48484.848484848444},98484.848484848451,{"$f":"B44*BEP!$C$8","v":96969.696969696888},-1515.1515151515632]
[42,2484.8484848484827,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B45<1,\"\",B45*BEP!$C$7)","v":49696.969696969652},99696.969696969652,{"$f":"B45*BEP!$C$8","v":99393.939393939305},-303.03030303034757]
[43,2545.4545454545432,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B46<1,\"\",B46*BEP!$C$7)","v":50909.090909090868},100909.09090909087,{"$f":"B46*BEP!$C$8","v":101818.18181818174},909.09090909086808]
[44,2606.0606060606037,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B47<1,\"\",B47*BEP!$C$7)","v":52121.212121212076},102121.21212121207,{"$f":"B47*BEP!$C$8","v":104242.42424242415},2121.2121212120837]
[45,2666.6666666666642,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B48<1,\"\",B48*BEP!$C$7)","v":53333.333333333285},103333.33333333328,{"$f":"B48*BEP!$C$8","v":106666.66666666657},3333.3333333332848]
[46,2727.2727272727248,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B49<1,\"\",B49*BEP!$C$7)","v":54545.454545454493},104545.4545454545,{"$f":"B49*BEP!$C$8","v":109090.90909090899},4545.4545454544859]
[47,2787.8787878787853,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B50<1,\"\",B50*BEP!$C$7)","v":55757.575757575702},105757.5757575757,{"$f":"B50*BEP!$C$8","v":111515.1515151514},5757.5757575757016]
[48,2848.4848484848458,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B51<1,\"\",B51*BEP!$C$7)","v":56969.696969696917},106969.69696969692,{"$f":"B51*BEP!$C$8","v":113939.39393939383},6969.6969696969172]
[49,2909.0909090909063,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B52<1,\"\",B52*BEP!$C$7)","v":58181.818181818126},108181.81818181812,{"$f":"B52*BEP!$C$8","v":116363.63636363625},8181.8181818181329]
[50,2969.6969696969668,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B53<1,\"\",B53*BEP!$C$7)","v":59393.939393939334},109393.93939393933,{"$f":"B53*BEP!$C$8","v":118787.87878787867},9393.939393939334]
[51,3030.3030303030273,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B54<1,\"\",B54*BEP!$C$7)","v":60606.06060606055},110606.06060606055,{"$f":"B54*BEP!$C$8","v":121212.1212121211},10606.06060606055]
[52,3090.9090909090878,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B55<1,\"\",B55*BEP!$C$7)","v":61818.181818181758},111818.18181818177,{"$f":"B55*BEP!$C$8","v":123636.36363636352},11818.181818181751]
[53,3151.5151515151483,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B56<1,\"\",B56*BEP!$C$7)","v":63030.303030302966},113030.30303030297,{"$f":"B56*BEP!$C$8","v":126060.60606060593},13030.303030302966]
[54,3212.1212121212088,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B57<1,\"\",B57*BEP!$C$7)","v":64242.424242424175},114242.42424242417,{"$f":"B57*BEP!$C$8","v":128484.84848484835},14242.424242424182]
[55,3272.7272727272693,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B58<1,\"\",B58*BEP!$C$7)","v":65454.545454545383},115454.54545454538,{"$f":"B58*BEP!$C$8","v":130909.09090909077},15454.545454545383]
[56,3333.3333333333298,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B59<1,\"\",B59*BEP!$C$7)","v":66666.666666666599},116666.6666666666,{"$f":"B59*BEP!$C$8","v":133333.3333333332},16666.666666666599]
[57,3393.9393939393904,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B60<1,\"\",B60*BEP!$C$7)","v":67878.787878787814},117878.78787878781,{"$f":"B60*BEP!$C$8","v":135757.57575757563},17878.787878787814]
[58,3454.5454545454509,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B61<1,\"\",B61*BEP!$C$7)","v":69090.909090909016},119090.90909090902,{"$f":"B61*BEP!$C$8","v":138181.81818181803},19090.909090909016]
[59,3515.1515151515114,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B62<1,\"\",B62*BEP!$C$7)","v":70303.030303030231},120303.03030303023,{"$f":"B62*BEP!$C$8","v":140606.06060606046},20303.030303030231]
[60,3575.7575757575719,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B63<1,\"\",B63*BEP!$C$7)","v":71515.151515151432},121515.15151515143,{"$f":"B63*BEP!$C$8","v":143030.30303030286},21515.151515151432]
[61,3636.3636363636324,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B64<1,\"\",B64*BEP!$C$7)","v":72727.272727272648},122727.27272727265,{"$f":"B64*BEP!$C$8","v":145454.5454545453},22727.272727272648]
[62,3696.9696969696929,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B65<1,\"\",B65*BEP!$C$7)","v":73939.393939393864},123939.39393939386,{"$f":"B65*BEP!$C$8","v":147878.78787878773},23939.393939393864]
[63,3757.5757575757534,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B66<1,\"\",B66*BEP!$C$7)","v":75151.515151515065},125151.51515151506,{"$f":"B66*BEP!$C$8","v":150303.03030303013},25151.515151515065]
[64,3818.1818181818139,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B67<1,\"\",B67*BEP!$C$7)","v":76363.63636363628},126363.63636363628,{"$f":"B67*BEP!$C$8","v":152727.27272727256},26363.63636363628]
[65,3878.7878787878744,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B68<1,\"\",B68*BEP!$C$7)","v":77575.757575757481},127575.75757575748,{"$f":"B68*BEP!$C$8","v":155151.51515151496},27575.757575757481]
[66,3939.3939393939349,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B69<1,\"\",B69*BEP!$C$7)","v":78787.878787878697},{"$f":"IF(B69<1,C69,C69+D69)","v":128787.8787878787},{"$f":"B69*BEP!$C$8","v":157575.75757575739},{"$f":"F69-E69","v":28787.878787878697}]
[67,3999.9999999999955,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B70<1,\"\",B70*BEP!$C$7)","v":79999.999999999913},129999.99999999991,{"$f":"B70*BEP!$C$8","v":159999.99999999983},29999.999999999913]
[68,{"$f":"B70+$B$5","v":4060.606060606056},{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B71<1,\"\",B71*BEP!$C$7)","v":81212.121212121114},131212.1212121211,{"$f":"B71*BEP!$C$8","v":162424.24242424223},31212.121212121128]
[69,4121.2121212121165,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B72<1,\"\",B72*BEP!$C$7)","v":82424.242424242329},132424.24242424231,{"$f":"B72*BEP!$C$8","v":164848.48484848466},32424.242424242344]
[70,4181.8181818181774,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B73<1,\"\",B73*BEP!$C$7)","v":83636.363636363545},133636.36363636353,{"$f":"B73*BEP!$C$8","v":167272.72727272709},33636.36363636356]
[71,4242.4242424242384,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B74<1,\"\",B74*BEP!$C$7)","v":84848.484848484775},134848.48484848478,{"$f":"B74*BEP!$C$8","v":169696.96969696955},34848.484848484775]
[72,4303.0303030302994,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B75<1,\"\",B75*BEP!$C$7)","v":86060.606060605991},136060.60606060599,{"$f":"B75*BEP!$C$8","v":172121.21212121198},36060.606060605991]
[73,4363.6363636363603,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B76<1,\"\",B76*BEP!$C$7)","v":87272.727272727207},137272.72727272721,{"$f":"B76*BEP!$C$8","v":174545.45454545441},37272.727272727207]
[74,4424.2424242424213,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B77<1,\"\",B77*BEP!$C$7)","v":88484.848484848422},138484.84848484842,{"$f":"B77*BEP!$C$8","v":176969.69696969684},38484.848484848422]
[75,4484.8484848484823,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B78<1,\"\",B78*BEP!$C$7)","v":89696.969696969638},139696.96969696964,{"$f":"B78*BEP!$C$8","v":179393.93939393928},39696.969696969638]
[76,4545.4545454545432,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B79<1,\"\",B79*BEP!$C$7)","v":90909.090909090868},140909.09090909088,{"$f":"B79*BEP!$C$8","v":181818.18181818174},40909.090909090854]
[77,4606.0606060606042,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B80<1,\"\",B80*BEP!$C$7)","v":92121.212121212084},142121.2121212121,{"$f":"B80*BEP!$C$8","v":184242.42424242417},42121.212121212069]
[78,4666.6666666666652,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B81<1,\"\",B81*BEP!$C$7)","v":93333.333333333299},143333.33333333331,{"$f":"B81*BEP!$C$8","v":186666.6666666666},43333.333333333285]
[79,4727.2727272727261,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B82<1,\"\",B82*BEP!$C$7)","v":94545.45454545453},144545.45454545453,{"$f":"B82*BEP!$C$8","v":189090.90909090906},44545.45454545453]
[80,4787.8787878787871,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B83<1,\"\",B83*BEP!$C$7)","v":95757.575757575745},145757.57575757575,{"$f":"B83*BEP!$C$8","v":191515.15151515149},45757.575757575745]
[81,4848.484848484848,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B84<1,\"\",B84*BEP!$C$7)","v":96969.696969696961},146969.69696969696,{"$f":"B84*BEP!$C$8","v":193939.39393939392},46969.696969696961]
[82,4909.090909090909,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B85<1,\"\",B85*BEP!$C$7)","v":98181.818181818177},148181.81818181818,{"$f":"B85*BEP!$C$8","v":196363.63636363635},48181.818181818177]
[83,4969.69696969697,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B86<1,\"\",B86*BEP!$C$7)","v":99393.939393939392},149393.93939393939,{"$f":"B86*BEP!$C$8","v":198787.87878787878},49393.939393939392]
[84,5030.3030303030309,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B87<1,\"\",B87*BEP!$C$7)","v":100606.06060606062},150606.06060606061,{"$f":"B87*BEP!$C$8","v":201212.12121212124},50606.060606060637]
[85,5090.9090909090919,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B88<1,\"\",B88*BEP!$C$7)","v":101818.18181818184},151818.18181818182,{"$f":"B88*BEP!$C$8","v":203636.36363636368},51818.181818181853]
[86,5151.5151515151529,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B89<1,\"\",B89*BEP!$C$7)","v":103030.30303030305},153030.30303030304,{"$f":"B89*BEP!$C$8","v":206060.60606060611},53030.303030303068]
[87,5212.1212121212138,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B90<1,\"\",B90*BEP!$C$7)","v":104242.42424242428},154242.42424242428,{"$f":"B90*BEP!$C$8","v":208484.84848484857},54242.424242424284]
[88,5272.7272727272748,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B91<1,\"\",B91*BEP!$C$7)","v":105454.5454545455},155454.5454545455,{"$f":"B91*BEP!$C$8","v":210909.090909091},55454.5454545455]
[89,5333.3333333333358,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B92<1,\"\",B92*BEP!$C$7)","v":106666.66666666672},156666.66666666672,{"$f":"B92*BEP!$C$8","v":213333.33333333343},56666.666666666715]
[90,5393.9393939393967,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B93<1,\"\",B93*BEP!$C$7)","v":107878.78787878793},157878.78787878793,{"$f":"B93*BEP!$C$8","v":215757.57575757586},57878.787878787931]
[91,5454.5454545454577,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B94<1,\"\",B94*BEP!$C$7)","v":109090.90909090915},159090.90909090915,{"$f":"B94*BEP!$C$8","v":218181.81818181829},59090.909090909146]
[92,5515.1515151515187,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B95<1,\"\",B95*BEP!$C$7)","v":110303.03030303038},160303.03030303039,{"$f":"B95*BEP!$C$8","v":220606.06060606075},60303.030303030362]
[93,5575.7575757575796,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B96<1,\"\",B96*BEP!$C$7)","v":111515.15151515159},161515.15151515161,{"$f":"B96*BEP!$C$8","v":223030.30303030318},61515.151515151578]
[94,5636.3636363636406,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B97<1,\"\",B97*BEP!$C$7)","v":112727.27272727281},162727.27272727282,{"$f":"B97*BEP!$C$8","v":225454.54545454562},62727.272727272793]
[95,5696.9696969697015,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B98<1,\"\",B98*BEP!$C$7)","v":113939.39393939404},163939.39393939404,{"$f":"B98*BEP!$C$8","v":227878.78787878808},63939.393939394038]
[96,5757.5757575757625,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B99<1,\"\",B99*BEP!$C$7)","v":115151.51515151525},165151.51515151525,{"$f":"B99*BEP!$C$8","v":230303.03030303051},65151.515151515254]
[97,5818.1818181818235,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B100<1,\"\",B100*BEP!$C$7)","v":116363.63636363647},166363.63636363647,{"$f":"B100*BEP!$C$8","v":232727.27272727294},66363.636363636469]
[98,5878.7878787878844,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B101<1,\"\",B101*BEP!$C$7)","v":117575.75757575769},167575.75757575769,{"$f":"B101*BEP!$C$8","v":235151.51515151537},67575.757575757685]
[99,5939.3939393939454,{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B102<1,\"\",B102*BEP!$C$7)","v":118787.8787878789},168787.8787878789,{"$f":"B102*BEP!$C$8","v":237575.7575757578},68787.878787878901]
[100,{"$f":"BEP!C10","v":6000},{"$f":"BEP!$C$9","v":50000},{"$f":"IF(B103<1,\"\",B103*BEP!$C$7)","v":120000},170000,{"$f":"B103*BEP!$C$8","v":240000},70000]