{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Лист1","index":0,"n_rows":99,"n_cols":15,"rows_kept":99,"cut":false,"hidden":false,"merged":[[0,12,0,13]]}
[null,"IB",null,null,"Льгота",null,null,null,"Курс рубля",null,null,null,"Плоти нолог",null,"Льгота"]
[{"$nulls":4},"Сумма с шагом -0.85 за комиссию",{"$nulls":7},"IB"]
[null,"Сумма","Дивы до и после налога",null,100,{"$nulls":7},"Рублей на счету","Рублей было"]
[null,100,{"$f":"B4*0.02","v":2},null,{"$f":"E3*0.9915","v":99.15},{"$f":"E4*0.02","v":1.9830000000000001},null,null,75,null,null,null,"Разница в рублях","Налог"]
["1 год",{"$f":"B4*0.08","v":8},{"$f":"C4*0.9","v":1.8},null,{"$f":"E4*0.08","v":7.9320000000000004},{"$f":"F4*0.85","v":1.6855500000000001},{"$nulls":6},"Итог в рублях без вычета дивов","Сумма дивов в долларах","Итог в рублях"]
[null,{"$f":"B4+B5+C5","v":109.8},null,null,{"$f":"E4+E5+F5","v":108.76755000000001},{"$nulls":7},"Итог в долларах без вычета дивов","Сумма дивов в рублях","Итог в долларах"]
[{"$nulls":4},{"$f":"E6*0.9915","v":107.84302582500001},{"$f":"E7*0.02","v":2.1568605165000001},null,null,{"$f":"I4*1.07","v":80.25},null,null,null,"Итог в рублях","Налог на дивы"]
["2 год",{"$f":"B6*0.08","v":8.7840000000000007},{"$f":"B6*0.02","v":2.1960000000000002},null,{"$f":"E7*0.08","v":8.6274420660000004},{"$f":"F7*0.85","v":1.833331439025},{"$nulls":6},"Итог в долларах"]
[null,{"$f":"B6+B8+C9","v":120.45060000000001},{"$f":"C8*0.85","v":1.8666},null,{"$f":"E7+E8+F8","v":118.30379933002502}]
[{"$nulls":4},{"$f":"E9*0.9915","v":117.2982170357198},{"$f":"E10*0.02","v":2.3459643407143962},null,null,{"$f":"I7*1.07","v":85.867500000000007}]
["3 год",{"$f":"B9*0.08","v":9.6360480000000006},{"$f":"B9*0.02","v":2.4090120000000002},null,{"$f":"E10*0.08","v":9.3838573628575848},{"$f":"F10*0.85","v":1.9940696896072367}]
[null,{"$f":"B9+B11+C12","v":132.13430819999999},{"$f":"C11*0.85","v":2.0476602000000002},null,{"$f":"E10+E11+F11","v":128.67614408818463},{"$nulls":7},{"$f":"B12*I13","v":12140.265699018946},7500]
[{"$nulls":4},{"$f":"E12*0.9915","v":127.58239686343506},{"$f":"E13*0.02","v":2.5516479372687013},null,null,{"$f":"I10*1.07","v":91.878225000000015},null,null,null,{"$f":"M12-N12","v":4640.2656990189462},{"$f":"M13*0.13","v":603.23454087246307}]
["4 год",{"$f":"B12*0.08","v":10.570744656},{"$f":"B12*0.02","v":2.6426861640000001},null,{"$f":"E13*0.08","v":10.206591749074805},{"$f":"F13*0.85","v":2.1689007466783963},{"$nulls":6},{"$f":"M12-N13","v":11537.031158146483},{"$f":"C4+C8+C11","v":6.6050120000000003},{"$f":"E12*I13","v":11822.53571866665}]
[null,{"$f":"B12+B14+C15","v":144.95133609539997},{"$f":"C14*0.85","v":2.2462832393999999},null,{"$f":"E13+E14+F14","v":139.95788935918827},{"$nulls":7},{"$f":"M14/I13","v":125.56872053358107},{"$f":"N14*I13","v":606.85677866370008},{"$f":"E12","v":128.67614408818463}]
[{"$nulls":4},{"$f":"E15*0.9915","v":138.76824729963519},{"$f":"E16*0.02","v":2.7753649459927039},null,null,{"$f":"I13*1.07","v":98.309700750000019},null,null,null,{"$f":"M14-N16","v":11518.825454786573},{"$f":"N15*0.03","v":18.205703359911002}]
["5 год",{"$f":"B15*0.08","v":11.596106887631997},{"$f":"B15*0.02","v":2.8990267219079993},null,{"$f":"E16*0.08","v":11.101459783970816},{"$f":"F16*0.85","v":2.3590602040937982},{"$nulls":6},{"$f":"M16/I13","v":125.37057017358107}]
[null,{"$f":"B15+B17+C18","v":159.01161569665376},{"$f":"C17*0.85","v":2.4641727136217995},null,{"$f":"E16+E17+F17","v":152.22876728769981}]
[{"$nulls":4},{"$f":"E18*0.9915","v":150.93482276575438},{"$f":"E19*0.02","v":3.0186964553150877},null,null,{"$f":"I16*1.07","v":105.19137980250002}]
["6 год",{"$f":"B18*0.08","v":12.720929255732301},{"$f":"B18*0.02","v":3.1802323139330753},null,{"$f":"E19*0.08","v":12.074785821260351},{"$f":"F19*0.85","v":2.5658919870178245}]
[null,{"$f":"B18+B20+C21","v":174.43574241922917},{"$f":"C20*0.85","v":2.7031974668431138},null,{"$f":"E19+E20+F20","v":165.57550057403256}]
[{"$nulls":4},{"$f":"E21*0.9915","v":164.1681088191533},{"$f":"E22*0.02","v":3.2833621763830663},null,null,{"$f":"I19*1.07","v":112.55477638867504}]
["7 год",{"$f":"B21*0.08","v":13.954859393538333},{"$f":"B21*0.02","v":3.4887148483845833},null,{"$f":"E22*0.08","v":13.133448705532265},{"$f":"F22*0.85","v":2.7908578499256063}]
[null,{"$f":"B21+B23+C24","v":191.3560094338944},{"$f":"C23*0.85","v":2.9654076211268956},null,{"$f":"E22+E23+F23","v":180.09241537461116}]
[{"$nulls":4},{"$f":"E24*0.9915","v":178.56162984392697},{"$f":"E25*0.02","v":3.5712325968785392},null,null,{"$f":"I22*1.07","v":120.4336107358823}]
["8 год",{"$f":"B24*0.08","v":15.308480754711553},{"$f":"B24*0.02","v":3.8271201886778883},null,{"$f":"E25*0.08","v":14.284930387514157},{"$f":"F25*0.85","v":3.0355477073467583}]
[null,{"$f":"B24+B26+C27","v":209.91754234898215},{"$f":"C26*0.85","v":3.253052160376205},null,{"$f":"E25+E26+F26","v":195.88210793878787}]
[{"$nulls":4},{"$f":"E27*0.9915","v":194.21711002130817},{"$f":"E28*0.02","v":3.8843422004261634},null,null,{"$f":"I25*1.07","v":128.86396348739407}]
["9 год",{"$f":"B27*0.08","v":16.793403387918573},{"$f":"B27*0.02","v":4.1983508469796433},null,{"$f":"E28*0.08","v":15.537368801704654},{"$f":"F28*0.85","v":3.301690870362239}]
[null,{"$f":"B27+B29+C30","v":230.27954395683344},{"$f":"C29*0.85","v":3.5685982199326967},null,{"$f":"E28+E29+F29","v":213.05616969337507}]
[{"$nulls":4},{"$f":"E30*0.9915","v":211.2451922509814},{"$f":"E31*0.02","v":4.2249038450196279},null,null,{"$f":"I28*1.07","v":137.88444093151168}]
["10 год",{"$f":"B30*0.08","v":18.422363516546675},{"$f":"B30*0.02","v":4.6055908791366686},null,{"$f":"E31*0.08","v":16.899615380078512},{"$f":"F31*0.85","v":3.5911682682666837}]
[null,{"$f":"B30+B32+C33","v":252.61665972064628},{"$f":"C32*0.85","v":3.9147522472661684},null,{"$f":"E31+E32+F32","v":231.73597589932658},{"$nulls":7},{"$f":"B33*I34","v":37270.140378256947},7500]
[{"$nulls":4},{"$f":"E33*0.9915","v":229.76622010418231},{"$f":"E34*0.02","v":4.5953244020836461},null,null,{"$f":"I31*1.07","v":147.5363517967175},null,null,null,{"$f":"M33-N33","v":29770.140378256947},{"$f":"M34*0.13","v":3870.118249173403}]
["11 год",{"$f":"B33*0.08","v":20.209332777651703},{"$f":"B33*0.02","v":5.0523331944129257},null,{"$f":"E34*0.08","v":18.381297608334584},{"$f":"F34*0.85","v":3.9060257417710993},{"$nulls":6},{"$f":"M33-N34","v":33400.022129083547},{"$f":"C4+C8+C14+C11+C17+C20+C23+C26+C29+C32","v":31.446733963019859},{"$f":"E33*I34","v":34189.480464238695}]
[null,{"$f":"B33+B35+C36","v":277.12047571354896},{"$f":"C35*0.85","v":4.2944832152509864},null,{"$f":"E34+E35+F35","v":252.05354345428799},{"$nulls":7},{"$f":"M35/I34","v":226.38503475471362},{"$f":"N35*I34","v":4639.5364048258825},{"$f":"E33","v":231.73597589932658}]
[{"$nulls":4},{"$f":"E36*0.9915","v":249.91108833492655},{"$f":"E37*0.02","v":4.9982217666985314},null,null,{"$f":"I34*1.07","v":157.86389642248773},null,null,null,{"$f":"M35-N37","v":33260.836036938774},{"$f":"N36*0.03","v":139.18609214477647}]
["12 год",{"$f":"B36*0.08","v":22.169638057083915},{"$f":"B36*0.02","v":5.5424095142709788},null,{"$f":"E37*0.08","v":19.992887066794125},{"$f":"F37*0.85","v":4.2484885016937515},{"$nulls":6},{"$f":"M37/I34","v":225.44163273582305}]
[null,{"$f":"B36+B38+C39","v":304.00116185776318},{"$f":"C38*0.85","v":4.7110480871303322},null,{"$f":"E37+E38+F38","v":274.15246390341446}]
[{"$nulls":4},{"$f":"E39*0.9915","v":271.82216796023545},{"$f":"E40*0.02","v":5.4364433592047092},null,null,{"$f":"I37*1.07","v":168.91436917206187}]
["13 год",{"$f":"B39*0.08","v":24.320092948621056},{"$f":"B39*0.02","v":6.080023237155264},null,{"$f":"E40*0.08","v":21.745773436818837},{"$f":"F40*0.85","v":4.6209768553240025}]
[null,{"$f":"B39+B41+C42","v":333.48927455796621},{"$f":"C41*0.85","v":5.1680197515819746},null,{"$f":"E40+E41+F41","v":298.18891825237824}]
[{"$nulls":4},{"$f":"E42*0.9915","v":295.65431244723305},{"$f":"E43*0.02","v":5.9130862489446612},null,null,{"$f":"I40*1.07","v":180.7383750141062}]
["14 год",{"$f":"B42*0.08","v":26.679141964637296},{"$f":"B42*0.02","v":6.669785491159324},null,{"$f":"E43*0.08","v":23.652344995778645},{"$f":"F43*0.85","v":5.0261233116029622}]
[null,{"$f":"B42+B44+C45","v":365.8377341900889},{"$f":"C44*0.85","v":5.6693176674854255},null,{"$f":"E43+E44+F44","v":324.3327807546147}]
[{"$nulls":4},{"$f":"E45*0.9915","v":321.57595211820052},{"$f":"E46*0.02","v":6.4315190423640107},null,null,{"$f":"I43*1.07","v":193.39006126509364}]
["15 год",{"$f":"B45*0.08","v":29.267018735207113},{"$f":"B45*0.02","v":7.3167546838017783},null,{"$f":"E46*0.08","v":25.726076169456043},{"$f":"F46*0.85","v":5.4667911860094094}]
[null,{"$f":"B45+B47+C48","v":401.3239944065275},{"$f":"C47*0.85","v":6.2192414812315118},null,{"$f":"E46+E47+F47","v":352.76881947366599}]
[{"$nulls":4},{"$f":"E48*0.9915","v":349.77028450813987},{"$f":"E49*0.02","v":6.9954056901627979},null,null,{"$f":"I46*1.07","v":206.92736555365019}]
["16 год",{"$f":"B48*0.08","v":32.105919552522202},{"$f":"B48*0.02","v":8.0264798881305506},null,{"$f":"E49*0.08","v":27.981622760651192},{"$f":"F49*0.85","v":5.9460948366383777}]
[null,{"$f":"B48+B50+C51","v":440.25242186396071},{"$f":"C50*0.85","v":6.8225079049109674},null,{"$f":"E49+E50+F50","v":383.69800210542945}]
[{"$nulls":4},{"$f":"E51*0.9915","v":380.43656908753331},{"$f":"E52*0.02","v":7.6087313817506663},null,null,{"$f":"I49*1.07","v":221.4122811424057}]
["17 год",{"$f":"B51*0.08","v":35.220193749116859},{"$f":"B51*0.02","v":8.8050484372792148},null,{"$f":"E52*0.08","v":30.434925527002665},{"$f":"F52*0.85","v":6.4674216744880662}]
[null,{"$f":"B51+B53+C54","v":482.9569067847649},{"$f":"C53*0.85","v":7.4842911716873326},null,{"$f":"E52+E53+F53","v":417.3389162890241}]
[{"$nulls":4},{"$f":"E54*0.9915","v":413.79153550056742},{"$f":"E55*0.02","v":8.2758307100113484},null,null,{"$f":"I52*1.07","v":236.91114082237411}]
["18 год",{"$f":"B54*0.08","v":38.636552542781196},{"$f":"B54*0.02","v":9.659138135695299},null,{"$f":"E55*0.08","v":33.103322840045394},{"$f":"F55*0.85","v":7.0344561035096458}]
[null,{"$f":"B54+B56+C57","v":529.80372674288708},{"$f":"C56*0.85","v":8.2102674153410042},null,{"$f":"E55+E56+F56","v":453.92931444412244}]
[{"$nulls":4},{"$f":"E57*0.9915","v":450.07091527134742},{"$f":"E58*0.02","v":9.0014183054269488},null,null,{"$f":"I55*1.07","v":253.49492067994032}]
["19 год",{"$f":"B57*0.08","v":42.384298139430967},{"$f":"B57*0.02","v":10.596074534857742},null,{"$f":"E58*0.08","v":36.005673221707795},{"$f":"F58*0.85","v":7.6512055596129063}]
[null,{"$f":"B57+B59+C60","v":581.19468823694706},{"$f":"C59*0.85","v":9.0066633546290795},null,{"$f":"E58+E59+F59","v":493.72779405266812}]
[{"$nulls":4},{"$f":"E60*0.9915","v":489.53110780322044},{"$f":"E61*0.02","v":9.7906221560644084},null,null,{"$f":"I58*1.07","v":271.23956512753614}]
["20 год",{"$f":"B60*0.08","v":46.495575058955765},{"$f":"B60*0.02","v":11.623893764738941},null,{"$f":"E61*0.08","v":39.162488624257634},{"$f":"F61*0.85","v":8.3220288326547465}]
[null,{"$f":"B60+B62+C63","v":637.57057299593089},{"$f":"C62*0.85","v":9.8803097000280999},null,{"$f":"E61+E62+F62","v":537.01562526013277}]
[{"$nulls":4},{"$f":"E63*0.9915","v":532.45099244542166},{"$f":"E64*0.02","v":10.649019848908434},null,null,{"$f":"I61*1.07","v":290.2263346864637}]
["21 год",51.005645839674472,12.751411459918618,null,{"$f":"E64*0.08","v":42.596079395633737},{"$f":"F64*0.85","v":9.0516668715721682}]
[null,{"$f":"B63+B65+C66","v":699.41491857653614},{"$f":"C65*0.85","v":10.838699740930824},null,{"$f":"E64+E65+F65","v":584.09873871262755}]
[{"$nulls":4},{"$f":"E66*0.9915","v":579.13389943357026},{"$f":"E67*0.02","v":11.582677988671405},null,null,{"$f":"I64*1.07","v":310.54217811451616}]
["22 год",55.953193486122892,13.988298371530723,null,{"$f":"E67*0.08","v":46.330711954685619},{"$f":"F67*0.85","v":9.845276290370693}]
[null,{"$f":"B66+B68+C69","v":767.25816567846016},{"$f":"C68*0.85","v":11.890053615801115},null,{"$f":"E67+E68+F68","v":635.30988767862664}]
[{"$nulls":4},{"$f":"E69*0.9915","v":629.90975363335838},{"$f":"E70*0.02","v":12.598195072667167},null,null,{"$f":"I67*1.07","v":332.28013058253231}]
["23 год",61.380653254276815,15.345163313569204,null,{"$f":"E70*0.08","v":50.392780290668668},{"$f":"F70*0.85","v":10.708465811767091}]
[null,{"$f":"B69+B71+C72","v":841.68220774927079},{"$f":"C71*0.85","v":13.043388816533822},null,{"$f":"E70+E71+F71","v":691.01099973579414}]
[{"$nulls":4},{"$f":"E72*0.9915","v":685.13740623803994},{"$f":"E73*0.02","v":13.702748124760799},null,null,{"$f":"I70*1.07","v":355.53973972330959}]
["24 год",67.334576619941657,16.833644154985414,null,{"$f":"E73*0.08","v":54.810992499043195},{"$f":"F73*0.85","v":11.647335906046679}]
[null,{"$f":"B72+B74+C75","v":923.32538190095011},{"$f":"C74*0.85","v":14.308597531737602},null,{"$f":"E73+E74+F74","v":751.59573464312984}]
[{"$nulls":4},{"$f":"E75*0.9915","v":745.20717089866332},{"$f":"E76*0.02","v":14.904143417973266},null,null,{"$f":"I73*1.07","v":380.42752150394131}]
["25 год",73.866030552076012,18.466507638019003,null,{"$f":"E76*0.08","v":59.616573671893065},{"$f":"F76*0.85","v":12.668521905277276}]
[null,{"$f":"B75+B77+C78","v":1012.8879439453423},{"$f":"C77*0.85","v":15.696531492316153},null,{"$f":"E76+E77+F77","v":817.49226647583373}]
[{"$nulls":4},{"$f":"E78*0.9915","v":810.54358221078917},{"$f":"E79*0.02","v":16.210871644215782},null,null,{"$f":"I76*1.07","v":407.05744800921724}]
["26 год",81.03103551562738,20.257758878906845,null,{"$f":"E79*0.08","v":64.843486576863128},{"$f":"F79*0.85","v":13.779240897583414}]
[null,{"$f":"B78+B80+C81","v":1111.1380745080405},{"$f":"C80*0.85","v":17.21909504707082},null,{"$f":"E79+E80+F80","v":889.16630968523577}]
[{"$nulls":4},{"$f":"E81*0.9915","v":881.6083960529113},{"$f":"E82*0.02","v":17.632167921058226},null,null,{"$f":"I79*1.07","v":435.55146936986245}]
["27 год",88.89104596064324,22.22276149016081,null,{"$f":"E82*0.08","v":70.528671684232904},{"$f":"F82*0.85","v":14.987342732899492}]
[null,{"$f":"B81+B83+C84","v":1218.9184677353203},{"$f":"C83*0.85","v":18.889347266636687},null,{"$f":"E82+E83+F83","v":967.1244104700437}]
[{"$nulls":4},{"$f":"E84*0.9915","v":958.90385298104843},{"$f":"E85*0.02","v":19.178077059620968},null,null,{"$f":"I82*1.07","v":466.04007222575285}]
["28 год",97.51347741882563,24.378369354706408,null,{"$f":"E85*0.08","v":76.712308238483871},{"$f":"F85*0.85","v":16.301365500677822}]
[null,{"$f":"B84+B86+C87","v":1337.1535591056463},{"$f":"C86*0.85","v":20.721613951500444},null,{"$f":"E85+E86+F86","v":1051.9175267202102}]
[{"$nulls":4},{"$f":"E87*0.9915","v":1042.9762277430884},{"$f":"E88*0.02","v":20.859524554861768},null,null,{"$f":"I85*1.07","v":498.66287728155555}]
["29 год",{"$f":"B87*0.08","v":106.97228472845171},{"$f":"B87*0.02","v":26.743071182112928},null,{"$f":"E88*0.08","v":83.43809821944707},{"$f":"F88*0.85","v":17.730595871632502}]
[null,{"$f":"B87+B89+C90","v":1466.8574543388941},{"$f":"C89*0.85","v":22.731610504795988},null,{"$f":"E88+E89+F89","v":1144.1449218341679}]
[{"$nulls":4},{"$f":"E90*0.9915","v":1134.4196899985775},{"$f":"E91*0.02","v":22.68839379997155},null,null,{"$f":"I88*1.07","v":533.56927869126446}]
["30 год",117.34859634711152,29.337149086777881,null,{"$f":"E91*0.08","v":90.7535751998862},{"$f":"F91*0.85","v":19.285134729975816}]
[null,{"$f":"B90+B92+C93","v":1609.1426274097666},{"$f":"C92*0.85","v":24.936576723761199},null,{"$f":"E91+E92+F92","v":1244.4583999284396},{"$nulls":7},{"$f":"B93*I94","v":918690.30598968291},7500]
[{"$nulls":4},{"$f":"E93*0.9915","v":1233.8805035290479},{"$f":"E94*0.02","v":24.677610070580958},null,null,{"$f":"I91*1.07","v":570.91912819965296},null,null,null,{"$f":"M93-N93","v":911190.30598968291},{"$f":"M94*0.13","v":118454.73977865878}]
["31 год",128.73141019278134,32.182852548195335,null,{"$f":"E94*0.08","v":98.71044028232383},{"$f":"F94*0.85","v":20.975968559993813},{"$nulls":6},{"$f":"M93-N94","v":800235.56621102407},{"$f":"C4+C8+C11+C14+C17+C20+C23+C26+C29+C32+C35+C38+C41+C44+C47+C50+C53+C56+C59+C62+C65+C68+C71+C74+C77+C80+C83+C86+C89+C92","v":311.14280977520974},{"$f":"O96*I94","v":710485.10476787982}]
[null,{"$f":"B93+B95+C96","v":1765.229462268514},{"$f":"C95*0.85","v":27.355424665966034},null,{"$f":"E94+E95+F95","v":1353.5669123713656},{"$nulls":7},{"$f":"M95/I94","v":1401.6618583695065},{"$f":"N95*I94","v":177637.38170245322},{"$f":"E93","v":1244.4583999284396}]
[{"$nulls":4},{"$f":"E96*0.9915","v":1342.0615936162089},{"$f":"E97*0.02","v":26.84123187232418},null,null,{"$f":"I94*1.07","v":610.88346717362867},null,null,null,{"$f":"M95-N97","v":794906.44475995051},{"$f":"N96*0.03","v":5329.1214510735963}]
["32 год",141.21835698148112,35.304589245370281,null,{"$f":"E97*0.08","v":107.36492748929672},{"$f":"F97*0.85","v":22.815047091475552},{"$nulls":6},{"$f":"M97/I94","v":1392.3275740762501}]
[null,{"$f":"B96+B98+C99","v":1936.4567201085597},{"$f":"C98*0.85","v":30.008900858564736},null,{"$f":"E97+E98+F98","v":1472.2415681969812}]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}