{"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,20,{"$nulls":7},"Рублей на счету","Рублей было"]
[null,19.88,{"$f":"B4*0.02","v":0.39760000000000001},null,{"$f":"E3*0.9915","v":19.830000000000002},{"$f":"E4*0.02","v":0.39660000000000006},null,null,75,null,null,null,"Разница в рублях","Налог"]
["1 год",{"$f":"B4*0.08","v":1.5904},{"$f":"C4*0.85","v":0.33795999999999998},null,{"$f":"E4*0.08","v":1.5864000000000003},{"$f":"F4*0.85","v":0.33711000000000002},{"$nulls":6},"Итог в рублях",null,"Итог в рублях"]
[null,{"$f":"B4+B5+C5","v":21.808359999999997},null,null,{"$f":"E4+E5+F5","v":21.753510000000002},{"$nulls":7},"Итог в долларах",null,"Итог в долларах"]
[{"$nulls":4},{"$f":"E6*0.9915","v":21.568605165000005},{"$f":"E7*0.02","v":0.43137210330000009},null,null,{"$f":"I4*1.07","v":80.25},null,null,null,"Разница в долларах","Налог"]
["2 год",{"$f":"B6*0.08","v":1.7446687999999997},{"$f":"B6*0.02","v":0.43616719999999992},null,{"$f":"E7*0.08","v":1.7254884132000003},{"$f":"F7*0.85","v":0.36666628780500005},{"$nulls":6},"Итог в долларах"]
[null,{"$f":"B6+B8+C9-0.12","v":23.803770919999995},{"$f":"C8*0.85","v":0.3707421199999999},null,{"$f":"E7+E8+F8","v":23.660759866005005},{"$nulls":7},"Итог в рублях"]
[{"$nulls":4},{"$f":"E9*0.9915","v":23.459643407143965},{"$f":"E10*0.02","v":0.4691928681428793},null,null,{"$f":"I7*1.07","v":85.867500000000007}]
["3 год",{"$f":"B9*0.08","v":1.9043016735999996},{"$f":"B9*0.02","v":0.47607541839999989},null,{"$f":"E10*0.08","v":1.8767714725715172},{"$f":"F10*0.85","v":0.39881393792144743}]
[null,{"$f":"B9+B11+C12-0.12","v":25.992736699239991},{"$f":"C11*0.85","v":0.40466410563999988},null,{"$f":"E10+E11+F11","v":25.735228817636926},{"$nulls":7},{"$f":"B12*I13","v":2388.1665108185298},1500]
[{"$nulls":4},{"$f":"E12*0.9915","v":25.516479372687012},{"$f":"E13*0.02","v":0.51032958745374024},null,null,{"$f":"I10*1.07","v":91.878225000000015},null,null,null,{"$f":"M12-N12","v":888.16651081852979},{"$f":"M13*0.13","v":115.46164640640887}]
["4 год",{"$f":"B12*0.08","v":2.0794189359391995},{"$f":"B12*0.02","v":0.51985473398479987},null,{"$f":"E13*0.08","v":2.041318349814961},{"$f":"F13*0.85","v":0.43378014933567921},{"$nulls":6},{"$f":"M12-N13","v":2272.704864412121},null,{"$f":"E12*I13","v":2364.5071437333299}]
[null,{"$f":"B12+B14+C15-0.12","v":28.394032159066267},{"$f":"C14*0.85","v":0.44187652388707988},null,{"$f":"E13+E14+F14","v":27.991577871837652},{"$nulls":7},{"$f":"M14/I13","v":24.736055408255009},null,{"$f":"E12","v":25.735228817636926}]
[{"$nulls":4},{"$f":"E15*0.9915","v":27.753649459927033},{"$f":"E16*0.02","v":0.55507298919854065},null,null,{"$f":"I13*1.07","v":98.309700750000019},null,null,null,{"$f":"B12-20","v":5.9927366992399911},{"$f":"M16*0.13","v":0.77905577090119882}]
["5 год",2.2715225727253014,{"$f":"B15*0.02","v":0.56788064318132536},null,{"$f":"E16*0.08","v":2.2202919567941626},{"$f":"F16*0.85","v":0.47181204081875955},{"$nulls":6},{"$f":"B12-N16","v":25.213680928338793}]
[null,{"$f":"B15+B17+C18-0.12","v":31.028253278495697},{"$f":"C17*0.85","v":0.48269854670412654},null,{"$f":"E16+E17+F17","v":30.445753457539954},{"$nulls":7},{"$f":"M17*I13","v":2316.5882494121211}]
[{"$nulls":4},{"$f":"E18*0.9915","v":30.186964553150865},{"$f":"E19*0.02","v":0.60373929106301727},null,null,{"$f":"I16*1.07","v":105.19137980250002}]
["6 год",2.4822602622796559,{"$f":"B18*0.02","v":0.62056506556991398},null,{"$f":"E19*0.08","v":2.4149571642520691},{"$f":"F19*0.85","v":0.51317839740356463}]
[null,{"$f":"B18+B20+C21-0.12","v":33.917993846509781},{"$f":"C20*0.85","v":0.52748030573442684},null,{"$f":"E19+E20+F20","v":33.115100114806495}]
[{"$nulls":4},{"$f":"E21*0.9915","v":32.833621763830642},{"$f":"E22*0.02","v":0.6566724352766129},null,null,{"$f":"I19*1.07","v":112.55477638867504}]
["7 год",2.7134395077207825,{"$f":"B21*0.02","v":0.67835987693019562},null,{"$f":"E22*0.08","v":2.6266897411064516},{"$f":"F22*0.85","v":0.55817156998512096}]
[null,{"$f":"B21+B23+C24-0.12","v":37.088039249621232},{"$f":"C23*0.85","v":0.57660589539066631},null,{"$f":"E22+E23+F23","v":36.018483074922216}]
[{"$nulls":4},{"$f":"E24*0.9915","v":35.712325968785379},{"$f":"E25*0.02","v":0.7142465193757076},null,null,{"$f":"I22*1.07","v":120.4336107358823}]
["8 год",2.9670431399696988,{"$f":"B24*0.02","v":0.7417607849924247},null,{"$f":"E25*0.08","v":2.8569860775028304},{"$f":"F25*0.85","v":0.60710954146935148}]
[null,{"$f":"B24+B26+C27-0.12","v":40.565579056834494},{"$f":"C26*0.85","v":0.63049666724356102},null,{"$f":"E25+E26+F26","v":39.176421587757559}]
[{"$nulls":4},{"$f":"E27*0.9915","v":38.843422004261619},{"$f":"E28*0.02","v":0.77686844008523237},null,null,{"$f":"I25*1.07","v":128.86396348739407}]
["9 год",3.2452463245467595,{"$f":"B27*0.02","v":0.81131158113668989},null,{"$f":"E28*0.08","v":3.1074737603409295},{"$f":"F28*0.85","v":0.66033817407244755}]
[null,{"$f":"B27+B29+C30-0.12","v":44.380440225347442},{"$f":"C29*0.85","v":0.68961484396618633},null,{"$f":"E28+E29+F29","v":42.611233938674999}]
[{"$nulls":4},{"$f":"E30*0.9915","v":42.249038450196267},{"$f":"E31*0.02","v":0.84498076900392538},null,null,{"$f":"I28*1.07","v":137.88444093151168}]
["10 год",3.5504352180277956,{"$f":"B30*0.02","v":0.8876088045069489},null,{"$f":"E31*0.08","v":3.3799230760157015},{"$f":"F31*0.85","v":0.71823365365333658}]
[null,{"$f":"B30+B32+C33-0.12","v":48.565342927206146},{"$f":"C32*0.85","v":0.75446748383090656},null,{"$f":"E31+E32+F32","v":46.347195179865302},{"$nulls":7},{"$f":"B33*I34","v":7165.1535192365118},1500]
[{"$nulls":4},{"$f":"E33*0.9915","v":45.953244020836451},{"$f":"E34*0.02","v":0.91906488041672907},null,null,{"$f":"I31*1.07","v":147.5363517967175},null,null,null,{"$f":"M33-N33","v":5665.1535192365118},{"$f":"M34*0.13","v":736.46995750074655}]
["11 год",3.8852274341764916,{"$f":"B33*0.02","v":0.97130685854412291},null,{"$f":"E34*0.08","v":3.6762595216669163},{"$f":"F34*0.85","v":0.78120514835421972},{"$nulls":6},{"$f":"M33-N34","v":6428.6835617357656},null,{"$f":"E33*I34","v":6837.8960928477363}]
[null,{"$f":"B33+B35+C36-0.12","v":53.156181191145144},{"$f":"C35*0.85","v":0.82561082976250444},null,{"$f":"E34+E35+F35","v":50.410708690857582},{"$nulls":7},{"$f":"M35/I34","v":43.573556506219617},null,{"$f":"E33","v":46.347195179865302}]
[{"$nulls":4},{"$f":"E36*0.9915","v":49.982217666985292},{"$f":"E37*0.02","v":0.99964435333970592},null,null,{"$f":"I34*1.07","v":157.86389642248773},null,null,null,{"$f":"B33-20","v":28.565342927206146},{"$f":"M37*0.13","v":3.7134945805367989}]
["12 год",4.2524944952916117,{"$f":"B36*0.02","v":1.0631236238229029},null,{"$f":"E37*0.08","v":3.9985774133588237},{"$f":"F37*0.85","v":0.84969770033875003},{"$nulls":6},{"$f":"B33-N37","v":44.85184834666935}]
[null,{"$f":"B36+B38+C39-0.12","v":58.192330766686226},{"$f":"C38*0.85","v":0.9036550802494675},null,{"$f":"E37+E38+F38","v":54.830492780682867},{"$nulls":7},{"$f":"M38*I34","v":6617.2780764072313}]
[{"$nulls":4},{"$f":"E39*0.9915","v":54.364433592047064},{"$f":"E40*0.02","v":1.0872886718409414},null,null,{"$f":"I37*1.07","v":168.91436917206187}]
["13 год",4.6553864613348983,{"$f":"B39*0.02","v":1.1638466153337246},null,{"$f":"E40*0.08","v":4.3491546873637654},{"$f":"F40*0.85","v":0.9241953710648001}]
[null,{"$f":"B39+B41+C42-0.12","v":63.716986851054791},{"$f":"C41*0.85","v":0.98926962303366583},null,{"$f":"E40+E41+F41","v":59.637783650475626}]
[{"$nulls":4},{"$f":"E42*0.9915","v":59.130862489446585},{"$f":"E43*0.02","v":1.1826172497889318},null,null,{"$f":"I40*1.07","v":180.7383750141062}]
["14 год",5.0973589480843833,{"$f":"B42*0.02","v":1.2743397370210958},null,{"$f":"E43*0.08","v":4.7304689991557272},{"$f":"F43*0.85","v":1.005224662320592}]
[null,{"$f":"B42+B44+C45-0.12","v":69.777534575607106},{"$f":"C44*0.85","v":1.0831887764679313},null,{"$f":"E43+E44+F44","v":64.866556150922904}]
[{"$nulls":4},{"$f":"E45*0.9915","v":64.315190423640061},{"$f":"E46*0.02","v":1.2863038084728013},null,null,{"$f":"I43*1.07","v":193.39006126509364}]
["15 год",5.5822027660485682,{"$f":"B45*0.02","v":1.3955506915121421},null,{"$f":"E46*0.08","v":5.1452152338912054},{"$f":"F46*0.85","v":1.0933582372018811}]
[null,{"$f":"B45+B47+C48-0.12","v":76.42595542944099},{"$f":"C47*0.85","v":1.1862180877853208},null,{"$f":"E46+E47+F47","v":70.553763894733152}]
[{"$nulls":4},{"$f":"E48*0.9915","v":69.954056901627922},{"$f":"E49*0.02","v":1.3990811380325585},null,null,{"$f":"I46*1.07","v":206.92736555365019}]
["16 год",6.1140764343552796,{"$f":"B48*0.02","v":1.5285191085888199},null,{"$f":"E49*0.08","v":5.5963245521302341},{"$f":"F49*0.85","v":1.1892189673276747}]
[null,{"$f":"B48+B50+C51-0.12","v":83.719273106096765},{"$f":"C50*0.85","v":1.2992412423004969},null,{"$f":"E49+E50+F50","v":76.739600421085825}]
[{"$nulls":4},{"$f":"E51*0.9915","v":76.087313817506598},{"$f":"E52*0.02","v":1.5217462763501319},null,null,{"$f":"I49*1.07","v":221.4122811424057}]
["17 год",6.6975418484877416,{"$f":"B51*0.02","v":1.6743854621219354},null,{"$f":"E52*0.08","v":6.0869851054005277},{"$f":"F52*0.85","v":1.2934843348976122}]
[null,{"$f":"B51+B53+C54-0.12","v":91.720042597388144},{"$f":"C53*0.85","v":1.423227642803645},null,{"$f":"E52+E53+F53","v":83.46778325780474}]
[{"$nulls":4},{"$f":"E54*0.9915","v":82.758307100113399},{"$f":"E55*0.02","v":1.6551661420022681},null,null,{"$f":"I52*1.07","v":236.91114082237411}]
["18 год",{"$f":"B54*0.08","v":7.3376034077910512},{"$f":"B54*0.02","v":1.8344008519477628},null,{"$f":"E55*0.08","v":6.6206645680090723},{"$f":"F55*0.85","v":1.4068912207019277}]
[null,{"$f":"B54+B56+C57","v":100.61688672933479},{"$f":"C56*0.85","v":1.5592407241555983},null,{"$f":"E55+E56+F56","v":90.785862888824397}]
[{"$nulls":4},{"$f":"E57*0.9915","v":90.014183054269395},{"$f":"E58*0.02","v":1.8002836610853878},null,null,{"$f":"I55*1.07","v":253.49492067994032}]
["19 год",{"$f":"B57*0.08","v":8.0493509383467838},{"$f":"B57*0.02","v":2.012337734586696},null,{"$f":"E58*0.08","v":7.2011346443415514},{"$f":"F58*0.85","v":1.5302411119225796}]
[null,{"$f":"B57+B59+C60","v":110.37672474208026},{"$f":"C59*0.85","v":1.7104870743986915},null,{"$f":"E58+E59+F59","v":98.745558810533524}]
[{"$nulls":4},{"$f":"E60*0.9915","v":97.906221560643999},{"$f":"E61*0.02","v":1.95812443121288},null,null,{"$f":"I58*1.07","v":271.23956512753614}]
["20 год",{"$f":"B60*0.08","v":8.8301379793664214},{"$f":"B60*0.02","v":2.2075344948416054},null,{"$f":"E61*0.08","v":7.8324977248515202},{"$f":"F61*0.85","v":1.664405766530948}]
[null,{"$f":"B60+B62+C63","v":121.08326704206205},{"$f":"C62*0.85","v":1.8764043206153644},null,{"$f":"E61+E62+F62","v":107.40312505202647}]
[{"$nulls":4},{"$f":"E63*0.9915","v":106.49019848908425},{"$f":"E64*0.02","v":2.1298039697816851},null,null,{"$f":"I61*1.07","v":290.2263346864637}]
["21 год",{"$f":"B63*0.08","v":9.6866613633649639},{"$f":"B63*0.02","v":2.421665340841241},null,{"$f":"E64*0.08","v":8.5192158791267403},{"$f":"F64*0.85","v":1.8103333743144323}]
[null,{"$f":"B63+B65+C66","v":132.82834394514205},{"$f":"C65*0.85","v":2.058415539715055},null,{"$f":"E64+E65+F65","v":116.81974774252544}]
[{"$nulls":4},{"$f":"E66*0.9915","v":115.82677988671398},{"$f":"E67*0.02","v":2.3165355977342794},null,null,{"$f":"I64*1.07","v":310.54217811451616}]
["22 год",{"$f":"B66*0.08","v":10.626267515611364},{"$f":"B66*0.02","v":2.6565668789028409},null,{"$f":"E67*0.08","v":9.2661423909371177},{"$f":"F67*0.85","v":1.9690552580741374}]
[null,{"$f":"B66+B68+C69","v":145.71269330782084},{"$f":"C68*0.85","v":2.2580818470674147},null,{"$f":"E67+E68+F68","v":127.06197753572523}]
[{"$nulls":4},{"$f":"E69*0.9915","v":125.98195072667157},{"$f":"E70*0.02","v":2.5196390145334315},null,null,{"$f":"I67*1.07","v":332.28013058253231}]
["23 год",{"$f":"B69*0.08","v":11.657015464625667},{"$f":"B69*0.02","v":2.9142538661564168},null,{"$f":"E70*0.08","v":10.078556058133726},{"$f":"F70*0.85","v":2.1416931623534166}]
[null,{"$f":"B69+B71+C72","v":159.84682455867946},{"$f":"C71*0.85","v":2.4771157862329543},null,{"$f":"E70+E71+F71","v":138.2021999471587}]
[{"$nulls":4},{"$f":"E72*0.9915","v":137.02748124760785},{"$f":"E73*0.02","v":2.7405496249521573},null,null,{"$f":"I70*1.07","v":355.53973972330959}]
["24 год",{"$f":"B72*0.08","v":12.787745964694357},{"$f":"B72*0.02","v":3.1969364911735894},null,{"$f":"E73*0.08","v":10.962198499808629},{"$f":"F73*0.85","v":2.3294671812093335}]
[null,{"$f":"B72+B74+C75","v":175.35196654087136},{"$f":"C74*0.85","v":2.7173960174975509},null,{"$f":"E73+E74+F74","v":150.31914692862583}]
[{"$nulls":4},{"$f":"E75*0.9915","v":149.04143417973251},{"$f":"E76*0.02","v":2.98082868359465},null,null,{"$f":"I73*1.07","v":380.42752150394131}]
["25 год",{"$f":"B75*0.08","v":14.02815732326971},{"$f":"B75*0.02","v":3.5070393308174275},null,{"$f":"E76*0.08","v":11.9233147343786},{"$f":"F76*0.85","v":2.5337043810554523}]
[null,{"$f":"B75+B77+C78","v":192.36110729533587},{"$f":"C77*0.85","v":2.9809834311948133},null,{"$f":"E76+E77+F77","v":163.49845329516657}]
[{"$nulls":4},{"$f":"E78*0.9915","v":162.10871644215766},{"$f":"E79*0.02","v":3.242174328843153},null,null,{"$f":"I76*1.07","v":407.05744800921724}]
["26 год",{"$f":"B78*0.08","v":15.388888583626869},{"$f":"B78*0.02","v":3.8472221459067173},null,{"$f":"E79*0.08","v":12.968697315372612},{"$f":"F79*0.85","v":2.75584817951668}]
[null,{"$f":"B78+B80+C81","v":211.02013470298346},{"$f":"C80*0.85","v":3.2701388240207097},null,{"$f":"E79+E80+F80","v":177.83326193704696}]
[{"$nulls":4},{"$f":"E81*0.9915","v":176.32167921058206},{"$f":"E82*0.02","v":3.5264335842116412},null,null,{"$f":"I79*1.07","v":435.55146936986245}]
["27 год",16.881610776238677,4.2204026940596693,null,{"$f":"E82*0.08","v":14.105734336846565},{"$f":"F82*0.85","v":2.9974685465798951}]
[null,{"$f":"B81+B83+C84","v":231.48908776917287},{"$f":"C83*0.85","v":3.5873422899507186},null,{"$f":"E82+E83+F83","v":193.4248820940085}]
[{"$nulls":4},{"$f":"E84*0.9915","v":191.78077059620944},{"$f":"E85*0.02","v":3.8356154119241888},null,null,{"$f":"I82*1.07","v":466.04007222575285}]
["28 год",18.51912702153383,4.6297817553834575,null,{"$f":"E85*0.08","v":15.342461647696755},{"$f":"F85*0.85","v":3.2602731001355605}]
[null,{"$f":"B84+B86+C87","v":253.94352928278263},{"$f":"C86*0.85","v":3.9353144920759386},null,{"$f":"E85+E86+F86","v":210.38350534404174}]
[{"$nulls":4},{"$f":"E87*0.9915","v":208.59524554861738},{"$f":"E88*0.02","v":4.1719049109723478},null,null,{"$f":"I85*1.07","v":498.66287728155555}]
["29 год",{"$f":"B87*0.08","v":20.315482342622612},{"$f":"B87*0.02","v":5.0788705856556531},null,{"$f":"E88*0.08","v":16.687619643889391},{"$f":"F88*0.85","v":3.5461191743264955}]
[null,{"$f":"B87+B89+C90","v":278.57605162321255},{"$f":"C89*0.85","v":4.3170399978073046},null,{"$f":"E88+E89+F89","v":228.82898436683328}]
[{"$nulls":4},{"$f":"E90*0.9915","v":226.88393799971522},{"$f":"E91*0.02","v":4.5376787599943045},null,null,{"$f":"I88*1.07","v":533.56927869126446}]
["30 год",22.286084129857006,5.5715210324642515,null,{"$f":"E91*0.08","v":18.150715039977218},{"$f":"F91*0.85","v":3.8570269459951585}]
[null,{"$f":"B90+B92+C93","v":305.59792863066417},{"$f":"C92*0.85","v":4.7357928775946139},null,{"$f":"E91+E92+F92","v":248.8916799856876},{"$nulls":7},{"$f":"B93*I94","v":174471.70299343855},1500]
[{"$nulls":4},{"$f":"E93*0.9915","v":246.77610070580926},{"$f":"E94*0.02","v":4.9355220141161853},null,null,{"$f":"I91*1.07","v":570.91912819965296},null,null,null,{"$f":"M93-N93","v":172971.70299343855},{"$f":"M94*0.13","v":22486.321389147011}]
["31 год",24.447834290453134,6.1119585726132835,null,{"$f":"E94*0.08","v":19.742088056464741},{"$f":"F94*0.85","v":4.1951937119987575},{"$nulls":6},{"$f":"M93-N94","v":151985.38160429153}]
[null,{"$f":"B93+B95+C96","v":335.24092770783864},{"$f":"C95*0.85","v":5.1951647867212909},null,{"$f":"E94+E95+F95","v":270.71338247427275},{"$nulls":7},{"$f":"M95/I94","v":266.21175241327973},null,{"$f":"E93","v":248.8916799856876}]
[{"$nulls":4},{"$f":"E96*0.9915","v":268.41231872324147},{"$f":"E97*0.02","v":5.3682463744648299},null,null,{"$f":"I94*1.07","v":610.88346717362867},null,null,null,{"$f":"B93-20","v":285.59792863066417},{"$f":"M97*0.13","v":37.127730721986346},{"$f":"O96*I94","v":142097.02095357579}]
["32 год",26.819274216627093,6.7048185541567733,null,{"$f":"E97*0.08","v":21.47298549785932},{"$f":"F97*0.85","v":4.5630094182951053},{"$nulls":6},{"$f":"B93-N97","v":268.47019790867785}]
[null,{"$f":"B96+B98+C99","v":367.75929769549901},{"$f":"C98*0.85","v":5.6990957710332575},null,{"$f":"E97+E98+F98","v":294.44831363939591}]

{"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":[]}