{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ЛИСТ1","ЛИСТ2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":"ЛИСТ1","index":0,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[{"$f":"ЛИСТ2!B2","v":130}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(\"ЛИСТ2!C\"&ROW(INDIRECT(SUBSTITUTE(формула,\"=\",))))","v":127}]
[]
[null,null,null,null,{"$f":"INDIRECT(\"ЛИСТ2!E\"&ROW(INDIRECT(SUBSTITUTE(формула,\"=\",))))","v":126}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(\"ЛИСТ2!D\"&ROW(INDIRECT(SUBSTITUTE(формула,\"=\",))))","v":110}]
[]
[]
[null,{"$f":"INDIRECT(\"ЛИСТ2!J\"&ROW(INDIRECT(SUBSTITUTE(формула,\"=\",))))","v":11726}]
[]
[]
[null,null,null,"ГДЕ n-номер строки импортированного значения в ЛИСТ1 A1 (т.е. в моем примере 2)"]

{"sheet":"ЛИСТ2","index":1,"n_rows":138,"n_cols":13,"rows_kept":138,"cut":false,"hidden":false,"merged":[[0,0,0,12],[86,0,86,4],[137,0,137,4]]}
[]
[40,130,127,110,126,{"$f":"A2+B2+C2+D2+E2","v":533},22,1,{"$f":"H2*G2:G3","v":22},{"$f":"F2*G2","v":11726},{"$f":"(J2/100)*63","v":7387.38},{"$f":"18*H2*G2","v":396},{"$f":"L2*(F2/2)","v":105534}]
[20,110,126,121,153,530,24,1,{"$f":"H3*G3:G4","v":24},{"$f":"F3*G3","v":12720},{"$f":"(J3/100)*63","v":8013.6},{"$f":"18*H3*G3","v":432},{"$f":"L3*(F3/2)","v":114480}]
[40,121,153,130,140,584,23,1,23,13432,8462.16,414,120888]
[61,130,140,130,127,588,25,1,25,14700,9261,450,132300]
[40,130,127,87,87,471,25,1,25,11775,7418.25,450,105975]
[40,87,87,110,130,454,23,2,46,10442,6578.46,828,187956]
[20,110,130,65,65,390,23,1,23,8970,5651.1,414,80730]
[20,65,65,130,157,437,3,2,6,1311,825.93,108,23598]
[40,130,157,65,65,457,23,1,23,10511,6621.93,414,94599]
[20,65,65,85,85,320,14,2,28,4480,2822.3999999999996,504,80640]
[40,85,85,67,80,357,23,2,46,8211,5172.93,828,147798]
[20,67,80,68,68,303,22,1,22,6666,4199.58,396,59994]
[61,68,68,110,130,437,23,2,46,10051,6332.13,828,180918]
[20,110,130,110,130,500,20,1,20,10000,6300,360,90000]
[20,110,130,110,130,500,25,1,25,12500,7875,450,112500]
[20,110,130,87,87,434,5,1,5,2170,1367.1,90,19530]
[40,87,87,110,130,454,10,2,20,4540,2860.2,360,81720]
[20,110,130,65,65,390,12,1,12,4680,2948.3999999999996,216,42120]
[20,65,65,43,43,236,20,2,40,4720,2973.6000000000004,720,84960]
[61,43,43,45,83,275,19,2,38,5225,3291.75,684,94050]
[20,110,130,null,null,260,4,1,4,1040,655.20000000000005,72,9360]
[40,87,87,85,78,377,6,2,12,2262,1425.0600000000002,216,40716]
[40,121,153,null,null,314,14,1,14,4396,2769.48,252,39564]
[40,85,85,83,76,369,22,2,44,8118,5114.34,792,146124]
[40,121,153,null,null,314,15,1,15,4710,2967.3,270,42390]
[20,67,67,67,80,301,12,2,24,3612,2275.56,432,65016]
[40,130,157,null,null,327,18,1,18,5886,3708.18,324,52974]
[20,65,65,65,79,294,3,2,6,882,555.66,108,15876]
[40,121,153,null,null,314,8,1,8,2512,1582.5600000000002,144,22608]
[61,66,66,68,88,349,9,2,18,3141,1978.83,324,56538]
[20,69,69,69,82,309,16,2,{"$f":"H32*G32:G32","v":32},4944,3114.72,576,88992]
[20,110,130,null,null,260,5,1,{"$f":"H33*G33:G34","v":5},{"$f":"F33*G33","v":1300},819,{"$f":"18*H33*G33","v":90},{"$f":"L33*(F33/2)","v":11700}]
[20,65,65,65,79,{"$f":"A34+B34+C34+D34+E34","v":294},20,2,{"$f":"H34*G34:G35","v":40},{"$f":"F34*G34","v":5880},3704.3999999999996,{"$f":"18*H34*G34","v":720},{"$f":"L34*(F34/2)","v":105840}]
[20,67,67,67,80,301,19,2,38,5719,3602.97,684,102942]
[61,130,140,null,null,331,1,1,1,331,208.53,18,2979]
[61,66,66,68,88,349,18,2,36,6282,3957.66,648,113076]
[40,130,127,null,null,297,17,1,17,5049,3180.8700000000003,306,45441]
[40,130,127,null,null,297,16,1,16,4752,2993.76,288,42768]
[61,43,43,45,83,275,13,2,26,3575,2252.25,468,64350]
[20,114,114,114,135,497,12,2,24,5964,3757.32,432,107352]
[20,110,130,null,null,260,4,1,4,1040,655.20000000000005,72,9360]
[40,121,153,null,null,314,9,1,9,2826,1780.38,162,25434]
[20,67,67,67,80,301,8,2,16,2408,1517.04,288,43344]
[20,110,130,null,null,260,22,1,22,5720,3603.6000000000004,396,51480]
[61,130,140,null,null,331,5,1,5,1655,1042.6500000000001,90,14895]
[20,69,69,69,82,309,1,2,2,309,194.67,36,5562]
[20,112,112,110,130,484,10,2,20,4840,3049.2,360,87120]
[40,121,153,null,null,314,22,1,22,6908,4352.04,396,62172]
[40,87,87,85,78,377,5,2,10,1885,1187.5500000000002,180,33930]
[20,110,130,null,null,260,10,1,10,2600,1638,180,23400]
[61,45,45,45,83,279,15,2,30,4185,2636.55,540,75330]
[40,121,153,null,null,314,1,1,1,314,197.82000000000002,18,2826]
[20,69,69,69,82,309,14,2,28,4326,2725.3799999999997,504,77868]
[40,130,127,null,null,297,16,1,16,4752,2993.76,288,42768]
[40,121,153,null,null,314,6,1,6,1884,1186.92,108,16956]
[40,127,125,null,null,292,10,1,10,2920,1839.6,180,26280]
[61,70,70,68,88,357,14,2,28,4998,3148.74,504,89964]
[61,68,68,70,90,357,5,2,10,1785,1124.5500000000002,180,32130]
[20,110,111,111,130,482,15,2,30,7230,4554.8999999999996,540,130140]
[20,114,114,114,135,497,6,2,12,2982,1878.66,216,53676]
[20,110,130,null,null,260,21,1,21,5460,3439.8,378,49140]
[20,110,110,110,130,480,10,2,{"$f":"H63*G63:G63","v":20},4800,3024,360,86400]
[40,89,89,87,80,385,3,2,{"$f":"H64*G64:G65","v":6},{"$f":"F64*G64","v":1155},727.65000000000009,{"$f":"18*H64*G64","v":108},{"$f":"L64*(F64/2)","v":20790}]
[40,85,85,83,76,369,17,2,{"$f":"H65*G65:G66","v":34},{"$f":"F65*G65","v":6273},3951.99,{"$f":"18*H65*G65","v":612},{"$f":"L65*(F65/2)","v":112914}]
[40,87,87,85,78,{"$f":"A66+B66+C66+D66+E66","v":377},4,2,8,1508,950.04,144,27144]
[40,130,127,null,null,297,18,1,18,5346,{"$f":"(J67/100)*63","v":3367.98},324,48114]
[61,68,68,70,90,357,25,2,50,8925,5622.75,900,160650]
[20,67,80,null,null,167,26,1,26,4342,2735.46,468,39078]
[20,110,130,null,null,260,14,1,14,3640,2293.1999999999998,252,32760]
[61,66,66,68,88,349,15,2,30,5235,3298.05,540,94230]
[40,127,125,null,null,292,3,1,3,876,551.88,54,7884]
[40,87,87,85,78,377,25,2,50,9425,5937.75,900,169650]
[20,69,69,69,82,309,16,2,32,4944,3114.72,576,88992]
[40,85,85,83,76,369,6,2,12,2214,1394.82,216,39852]
[61,45,45,47,85,283,13,2,26,3679,2317.77,468,66222]
[61,43,43,45,83,275,9,2,18,2475,1559.25,324,44550]
[20,114,114,114,135,497,18,2,36,8946,5635.98,648,161028]
[20,110,130,null,null,260,15,1,15,3900,2457,270,35100]
[20,110,110,110,130,480,13,2,26,6240,3931.2,468,112320]
[20,69,69,69,82,309,6,2,12,1854,1168.02,216,33372]
[61,68,68,70,90,357,1,2,2,357,224.91,36,6426]
[null,null,null,null,null,0,null,null,0,0,0,0,0]
[null,null,null,null,null,0,null,null,0,0,0,0,0]
[null,null,null,null,null,0,null,null,{"$f":"H85*G85:G86","v":0},0,0,0,0]
[null,null,null,null,null,0,null,null,{"$f":"H86*G86:G88","v":0},0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F2:F86)","v":28896},1108,125,1667,406346,255997.98000000004,30006,{"$f":"SUM(M2:M86)","v":5478147}]
[20,110,110,110,130,{"$f":"[1]Лист1!F95+[1]Лист1!G95+[1]Лист1!H95+[1]Лист1!I95+[1]Лист1!J95","v":480},18,2,36,8640,{"$f":"(J88/100)*47","v":4060.8},{"$f":"13.5*H88*G88","v":486},116640]
[61,130,140,null,null,{"$f":"[1]Лист1!F96+[1]Лист1!G96+[1]Лист1!H96+[1]Лист1!I96+[1]Лист1!J96","v":377},3,2,6,1131,531.57000000000005,{"$f":"13.5*H89*G89","v":81},15268.5]
[40,130,127,null,null,{"$f":"[1]Лист1!F97+[1]Лист1!G97+[1]Лист1!H97+[1]Лист1!I97+[1]Лист1!J97","v":257},18,2,36,4626,2174.2199999999998,486,62451]
[40,127,125,null,null,{"$f":"[1]Лист1!F98+[1]Лист1!G98+[1]Лист1!H98+[1]Лист1!I98+[1]Лист1!J98","v":260},20,1,20,5200,2444,270,35100]
[40,127,125,null,null,{"$f":"[1]Лист1!F99+[1]Лист1!G99+[1]Лист1!H99+[1]Лист1!I99+[1]Лист1!J99","v":369},15,2,30,5535,2601.4500000000003,405,74722.5]
[61,43,43,45,83,{"$f":"[1]Лист1!F100+[1]Лист1!G100+[1]Лист1!H100+[1]Лист1!I100+[1]Лист1!J100","v":330},23,1,23,7590,3567.3,310.5,51232.5]
[20,110,125,null,null,{"$f":"[1]Лист1!F101+[1]Лист1!G101+[1]Лист1!H101+[1]Лист1!I101+[1]Лист1!J101","v":327},10,1,10,3270,1536.9,135,22072.5]
[20,110,110,null,null,{"$f":"[1]Лист1!F102+[1]Лист1!G102+[1]Лист1!H102+[1]Лист1!I102+[1]Лист1!J102","v":294},17,2,{"$f":"H95*G95:G95","v":34},4998,2349.06,459,67473]
[40,83,83,81,76,{"$f":"[1]Лист1!F103+[1]Лист1!G103+[1]Лист1!H103+[1]Лист1!I103+[1]Лист1!J103","v":301},4,2,{"$f":"H96*G96:G97","v":8},{"$f":"F96*G96","v":1204},{"$f":"(J96/100)*47","v":565.88},108,{"$f":"L96*(F96/2)","v":16254}]
[40,130,157,null,null,{"$f":"[1]Лист1!F104+[1]Лист1!G104+[1]Лист1!H104+[1]Лист1!I104+[1]Лист1!J104","v":357},16,2,{"$f":"H97*G97:G98","v":32},{"$f":"F97*G97","v":5712},{"$f":"(J97/100)*47","v":2684.64},432,{"$f":"L97*(F97/2)","v":77112}]
[20,67,67,67,80,{"$f":"ЛИСТ2!A51+ЛИСТ2!B51+ЛИСТ2!C51+ЛИСТ2!D51+ЛИСТ2!E51","v":260},11,1,11,2860,1344.2,148.5,19305]
[20,110,126,null,null,{"$f":"ЛИСТ2!A52+ЛИСТ2!B52+ЛИСТ2!C52+ЛИСТ2!D52+ЛИСТ2!E52","v":279},26,2,52,7254,3409.38,702,97929]
[20,110,110,110,130,{"$f":"ЛИСТ2!A53+ЛИСТ2!B53+ЛИСТ2!C53+ЛИСТ2!D53+ЛИСТ2!E53","v":314},9,1,9,2826,1328.22,121.5,19075.5]
[40,127,125,null,null,{"$f":"ЛИСТ2!A54+ЛИСТ2!B54+ЛИСТ2!C54+ЛИСТ2!D54+ЛИСТ2!E54","v":309},16,2,32,4944,2323.6799999999998,432,66744]
[40,121,153,null,null,{"$f":"ЛИСТ2!A55+ЛИСТ2!B55+ЛИСТ2!C55+ЛИСТ2!D55+ЛИСТ2!E55","v":297},24,1,24,7128,3350.16,324,48114]
[61,43,43,45,83,{"$f":"[1]Лист1!F11+[1]Лист1!G11+[1]Лист1!H11+[1]Лист1!I11+[1]Лист1!J11","v":301},11,1,11,3311,1556.17,148.5,22349.25]
[40,130,157,null,null,{"$f":"[1]Лист1!F12+[1]Лист1!G12+[1]Лист1!H12+[1]Лист1!I12+[1]Лист1!J12","v":256},6,2,12,1536,721.92,162,20736]
[61,68,68,70,90,{"$f":"[1]Лист1!F13+[1]Лист1!G13+[1]Лист1!H13+[1]Лист1!I13+[1]Лист1!J13","v":480},10,1,10,4800,2256,135,32400]
[61,68,68,68,88,{"$f":"[1]Лист1!F14+[1]Лист1!G14+[1]Лист1!H14+[1]Лист1!I14+[1]Лист1!J14","v":292},15,2,30,4380,2058.6,405,59130]
[61,68,68,68,88,{"$f":"[1]Лист1!F15+[1]Лист1!G15+[1]Лист1!H15+[1]Лист1!I15+[1]Лист1!J15","v":314},22,2,44,6908,3246.7599999999998,594,93258]
[20,110,130,null,null,{"$f":"[1]Лист1!F16+[1]Лист1!G16+[1]Лист1!H16+[1]Лист1!I16+[1]Лист1!J16","v":275},6,2,12,1650,775.5,162,22275]
[61,66,107,null,null,{"$f":"[1]Лист1!F17+[1]Лист1!G17+[1]Лист1!H17+[1]Лист1!I17+[1]Лист1!J17","v":327},13,2,26,4251,1997.9699999999998,351,57388.5]
[40,87,87,85,78,{"$f":"[1]Лист1!F18+[1]Лист1!G18+[1]Лист1!H18+[1]Лист1!I18+[1]Лист1!J18","v":357},19,1,19,6783,3188.0099999999998,256.5,45785.25]
[40,83,83,81,76,{"$f":"[1]Лист1!F19+[1]Лист1!G19+[1]Лист1!H19+[1]Лист1!I19+[1]Лист1!J19","v":353},18,2,36,6354,2986.38,486,85779]
[40,130,127,null,null,{"$f":"[1]Лист1!F20+[1]Лист1!G20+[1]Лист1!H20+[1]Лист1!I20+[1]Лист1!J20","v":353},14,1,14,4942,2322.7400000000002,189,33358.5]
[20,110,110,110,130,{"$f":"[1]Лист1!F21+[1]Лист1!G21+[1]Лист1!H21+[1]Лист1!I21+[1]Лист1!J21","v":260},13,2,26,3380,1588.6,351,45630]
[20,110,110,110,130,{"$f":"[1]Лист1!F22+[1]Лист1!G22+[1]Лист1!H22+[1]Лист1!I22+[1]Лист1!J22","v":234},6,1,6,1404,659.88,81,9477]
[20,69,69,69,82,{"$f":"[1]Лист1!F23+[1]Лист1!G23+[1]Лист1!H23+[1]Лист1!I23+[1]Лист1!J23","v":377},12,1,12,4524,2126.2800000000002,162,30537]
[60,130,140,null,null,{"$f":"[1]Лист1!F24+[1]Лист1!G24+[1]Лист1!H24+[1]Лист1!I24+[1]Лист1!J24","v":363},24,1,24,8712,4094.6400000000003,324,58806]
[61,68,68,68,88,{"$f":"[1]Лист1!F25+[1]Лист1!G25+[1]Лист1!H25+[1]Лист1!I25+[1]Лист1!J25","v":297},3,1,3,891,418.77,40.5,6014.25]
[20,110,110,null,null,{"$f":"[1]Лист1!F26+[1]Лист1!G26+[1]Лист1!H26+[1]Лист1!I26+[1]Лист1!J26","v":480},16,2,32,7680,3609.6,432,103680]
[40,85,85,83,76,{"$f":"[1]Лист1!F27+[1]Лист1!G27+[1]Лист1!H27+[1]Лист1!I27+[1]Лист1!J27","v":480},10,1,10,4800,2256,135,32400]
[40,121,153,null,null,{"$f":"[1]Лист1!F28+[1]Лист1!G28+[1]Лист1!H28+[1]Лист1!I28+[1]Лист1!J28","v":309},6,1,6,1854,871.38,81,12514.5]
[40,83,83,81,76,{"$f":"[1]Лист1!F29+[1]Лист1!G29+[1]Лист1!H29+[1]Лист1!I29+[1]Лист1!J29","v":330},12,2,24,3960,1861.2,324,53460]
[20,69,69,69,82,{"$f":"[1]Лист1!F30+[1]Лист1!G30+[1]Лист1!H30+[1]Лист1!I30+[1]Лист1!J30","v":353},9,1,9,3177,1493.19,121.5,21444.75]
[20,110,130,null,null,{"$f":"[1]Лист1!F31+[1]Лист1!G31+[1]Лист1!H31+[1]Лист1!I31+[1]Лист1!J31","v":240},4,1,4,960,451.2,54,6480]
[61,66,107,null,null,{"$f":"[1]Лист1!F32+[1]Лист1!G32+[1]Лист1!H32+[1]Лист1!I32+[1]Лист1!J32","v":369},10,2,20,3690,1734.3,270,49815]
[20,69,75,null,null,{"$f":"[1]Лист1!F33+[1]Лист1!G33+[1]Лист1!H33+[1]Лист1!I33+[1]Лист1!J33","v":314},26,1,26,8164,3837.08,351,55107]
[20,69,75,null,null,{"$f":"[1]Лист1!F34+[1]Лист1!G34+[1]Лист1!H34+[1]Лист1!I34+[1]Лист1!J34","v":363},12,2,{"$f":"H126*G126:G126","v":24},4356,2047.3200000000002,324,58806]
[61,45,45,47,85,{"$f":"[1]Лист1!F35+[1]Лист1!G35+[1]Лист1!H35+[1]Лист1!I35+[1]Лист1!J35","v":309},6,2,{"$f":"H127*G127:G128","v":12},{"$f":"F127*G127","v":1854},{"$f":"(J127/100)*47","v":871.38},162,{"$f":"L127*(F127/2)","v":25029}]
[61,68,68,68,88,{"$f":"[1]Лист1!F36+[1]Лист1!G36+[1]Лист1!H36+[1]Лист1!I36+[1]Лист1!J36","v":260},3,1,{"$f":"H128*G128:G129","v":3},{"$f":"F128*G128","v":780},{"$f":"(J128/100)*47","v":366.59999999999997},40.5,{"$f":"L128*(F128/2)","v":5265}]
[40,130,157,null,null,{"$f":"[1]Лист1!F37+[1]Лист1!G37+[1]Лист1!H37+[1]Лист1!I37+[1]Лист1!J37","v":234},9,1,9,2106,989.81999999999994,121.5,14215.5]
[20,110,130,null,null,{"$f":"[1]Лист1!F38+[1]Лист1!G38+[1]Лист1!H38+[1]Лист1!I38+[1]Лист1!J38","v":164},6,1,6,984,462.48,81,6642]
[20,110,130,null,null,{"$f":"[1]Лист1!F39+[1]Лист1!G39+[1]Лист1!H39+[1]Лист1!I39+[1]Лист1!J39","v":164},14,2,28,2296,1079.1200000000001,378,30996]
[20,65,65,65,79,{"$f":"[1]Лист1!F40+[1]Лист1!G40+[1]Лист1!H40+[1]Лист1!I40+[1]Лист1!J40","v":283},2,1,2,566,266.02,27,3820.5]
[null,null,null,null,null,{"$f":"A133+B133+C133+D133+E133","v":0},null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"A134+B134+C134+D134+E134","v":0},null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"A135+B135+C135+D135+E135","v":0},null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"A136+B136+C136+D136+E136","v":0},null,null,{"$f":"H136*G136:G136","v":0},0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F88:F136)","v":14302},{"$f":"SUM(G88:G136)","v":567},67,{"$f":"SUM(I88:I136)","v":863},{"$f":"SUM(J88:J136)","v":183971},{"$f":"SUM(K88:K136)","v":86466.370000000024},{"$f":"SUM(L88:L136)","v":11650.5},1892092.5]
[null,null,null,null,null,{"$f":"SUM(F2:F137)-SUM(F137,F87)","v":43198},{"$f":"SUM(G2:G137)-SUM(G137,G87)","v":1675},192,{"$f":"SUM(I2:I137)-SUM(I137,I87)","v":2530},{"$f":"SUM(J2:J137)-SUM(J137,J87)","v":590317},{"$f":"SUM(K2:K137)-SUM(K137,K87)","v":342464.34999999986},{"$f":"SUM(L2:L137)-SUM(L137,L87)","v":41656.5},7370239.5]

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