{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["дт02-98","пр02-98","м03-98","Результат"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"дт02-98","index":0,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Ведомость по отгрузке за февраль"]
[]
[]
["№","Дата ","Марка ","Коли-","     Отгрузочные",null,null,"   Товарная продукция",null,null,"Налог на","НДС","Сумма к оплате","Железно-","Сбор за","Услуги ","Услуги по","НДС","Сумма к оплате","Приме-"]
["п/п","отгрузки","отгр.","чество","       реквизиты",null,"факт.","факт.","отпус-","стоимость","реализа-","на товарную","за товарную","дорожный","выделе-","по подаче","наливу и ","на услуги","за услуги","чание"]
[null,null,"прод.","тн",null,"Кол-во","с/ст-ть","с/стоимость","кная це-","всего","цию ГСМ","продукцию","продукцию","тариф","ние пла-",null,"транспор-","20%"]
[null,null,null,null,"Получатель","цис-","1 тн","всего","на 1 тн","объема",0.35,null,null,null,"на",null,"тировке"]
[null,null,null,null,null,"терн",null,"объема"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,16,17,18,19]
["ООО-1"]
[421,16.02,".",15.6,null,null,null,null,1000,{"$f":"D12*I12","v":15600},{"$f":"J12*35%","v":5460},{"$f":"J12*20%","v":3120},{"$f":"J12+K12+L12","v":24180}]
[]
["ООО-2"]
[1259,13.02,"    .",41.4,null,null,null,null,1032.4000000000001,{"$f":"D15*I15","v":42741.36},{"$f":"J15*35%","v":14959.475999999999},8548.2720000000008,66249.107999999993]
[1282,4.0199999999999996,null,60.6,null,null,null,null,1032.4000000000001,{"$f":"D16*I16","v":62563.44000000001},{"$f":"J16*35%","v":21897.204000000002},12512.688000000002,96973.332000000024]
[null,"итого",null,{"$f":"SUM(D15:D16)","v":102},null,null,null,null,1032.4000000000001,{"$f":"SUM(J15:J16)","v":105304.80000000002},{"$f":"SUM(K15:K16)","v":36856.68},{"$f":"SUM(L15:L16)","v":21060.960000000003},{"$f":"SUM(M15:M16)","v":163222.44}]
[]
[]
["ООО-3"]
[1262,27.02,".",27.2,null,null,null,null,1100.5,{"$f":"D21*I21","v":29933.599999999999},{"$f":"J21*35%","v":10476.759999999998},{"$f":"J21*20%","v":5986.72},{"$f":"J21+K21+L21","v":46397.08}]
[]
["ООО-4"]
[1264,5.0199999999999996,".",31.8,null,null,null,null,896.77,{"$f":"D24*I24","v":28517.286},{"$f":"J24*35%","v":9981.0500999999986},{"$f":"J24*20%","v":5703.4572000000007},{"$f":"J24+K24+L24","v":44201.793300000005}]

{"sheet":"пр02-98","index":1,"n_rows":20,"n_cols":20,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["Ведомость по отгрузке за февраль"]
[]
[]
["№","Дата ","Марка ","Коли-","     Отгрузочные",null,null,"   Товарная продукция",null,null,"Налог на","НДС","Сумма к оплате","Железно-","Сбор за","Услуги ","Услуги по","НДС","Сумма к оплате","Приме-"]
["п/п","отгрузки","отгр.","чество","       реквизиты",null,"факт.","факт.","отпус-","стоимость","реализа-","на товарную","за товарную","дорожный","выделе-","по подаче","наливу и ","на услуги","за услуги","чание"]
[null,null,"прод.","тн",null,"Кол-во","с/ст-ть","с/стоимость","кная це-","всего","цию ГСМ","продукцию","продукцию","тариф","ние пла-",null,"транспор-","20%"]
[null,null,null,null,"Получатель","цис-","1 тн","всего","на 1 тн","объема",0.35,null,null,null,"на",null,"тировке"]
[null,null,null,null,null,"терн",null,"объема"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,16,17,18,19]
[]
["ООО-5"]
[1308,28.02,"прямог.б.",69474,null,null,null,null,489.93,{"$f":"I13*D13","v":34037396.82},null,{"$f":"J13*20%","v":6807479.3640000001},{"$f":"J13+L13","v":40844876.184}]
[1272,9.02,"тяж.бензин",331.51900000000001,null,null,null,null,1000,{"$f":"I14*D14","v":331519},null,{"$f":"J14*20%","v":66303.8},{"$f":"J14+L14","v":397822.8}]
[]
[]
[]
["ООО-6"]
[1297,28.02,"тяж.бензин",4848,null,null,null,null,791.67,{"$f":"I19*D19","v":3838016.1599999997},null,{"$f":"J19*20%","v":767603.23199999996},{"$f":"J19+L19","v":4605619.392}]
[1298,28.02,"ВУФ",5107,null,null,null,null,441.67,{"$f":"I20*D20","v":2255608.69},null,{"$f":"J20*20%","v":451121.73800000001},{"$f":"J20+L20","v":2706730.4279999998}]

{"sheet":"м03-98","index":2,"n_rows":84,"n_cols":19,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[]
["Ведомость по отгрузке за февраль"]
[]
[]
["№","Дата ","Марка ","Коли-","     Отгрузочные",null,null,"   Товарная продукция",null,null,"НДС","Сумма к оплате","Железно-","Сбор за","Услуги ","Услуги по","НДС","Сумма к оплате","Приме-"]
["п/п","отгрузки","отгр.","чество","       реквизиты",null,"факт.","факт.","отпус-","стоимость","на товарную","за товарную","дорожный","выделе-","по подаче","наливу и ","на услуги","за услуги","чание"]
[null,null,"прод.","тн",null,"Кол-во","с/ст-ть","с/стоимость","кная це-","всего","продукцию","продукцию","тариф","ние пла-",null,"транспор-","20%"]
[null,null,null,null,"Получатель","цис-","1 тн","всего","на 1 тн","объема",null,null,null,"на",null,"тировке"]
[null,null,null,null,null,"терн",null,"объема"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]
["ООО-7"]
[1409,1.03,null,56.067999999999998,null,1,null,null,433.33,{"$f":"I12*D12","v":24295.94644},{"$f":"J12*20%","v":4859.1892880000005},29155.135728000001,4555.3999999999996,{"$f":"275.8*F12","v":275.8},{"$f":"3.06*D12","v":171.56808000000001},468.16779999999994,{"$f":"(M12+N12+O12+P12)*20%","v":1094.1871760000001},{"$f":"M12+N12+O12+P12+Q12","v":6565.1230560000004}]
[1410,1.03,null,60,null,1,null,null,433.33,25999.8,5199.96,31199.759999999998,4276.8,275.8,183.6,501,1047.4400000000003,6284.6400000000012]
[1440,3.03,null,1169.481,null,20,null,null,433.33,506771.20172999997,101354.24034600001,608125.44207599992,135129.60000000001,5516,3578.61186,9765.1663499999995,30797.875641999999,184787.25385199999]
[1473,5.03,null,56.128999999999998,null,1,null,null,433.33,24322.379569999997,4864.4759139999996,29186.855483999996,6115,275.8,171.75474,468.67714999999998,1406.2463780000003,8437.4782680000008]
[1474,5.03,null,172.25800000000001,null,3,null,null,433.33,74644.559139999998,14928.911828,89573.470967999994,13906,827.40000000000009,527.10948000000008,1438.3543,3339.7727560000003,20038.636535999998]
[1475,5.03,null,1032.998,null,17,null,null,433.33,447629.02334000001,89525.804668000012,537154.82800800004,76978.2,4688.6000000000004,3160.97388,8625.5332999999991,18690.661436000002,112143.968616]
[1476,5.03,null,171.93600000000001,null,3,null,null,433.33,74505.026880000005,14901.005376000001,89406.032256000006,17936.7,827.40000000000009,526.12416000000007,1435.6656,4145.1779520000009,24871.067712000004]
[1481,5.03,null,422.62799999999999,null,7,null,null,433.33,183137.39124,36627.478247999999,219764.869488,40793.800000000003,1930.6000000000001,1293.2416800000001,3528.9437999999996,9509.3170960000007,57055.902576]
[1482,5.03,null,232.25800000000001,null,4,null,null,433.33,100644.35914,20128.871828000003,120773.230968,0,1103.2,710.7094800000001,1939.3543,750.65275600000007,4503.9165360000006]
[1483,5.03,null,60,null,1,null,null,433.33,25999.8,5199.96,31199.759999999998,4795.2,275.8,183.6,501,1151.1200000000001,6906.72]
[1484,5.03,null,56.128999999999998,null,1,null,null,433.33,24322.379569999997,4864.4759139999996,29186.855483999996,4555.3999999999996,275.8,171.75474,468.67714999999998,1094.3263780000002,6565.9582680000003]
[1491,5.03,null,236.12899999999999,null,4,null,null,433.33,102321.77957,20464.355914,122786.135484,48803,1103.2,722.55474000000004,1971.6771499999998,10520.086378,63120.518268]
[1496,6.03,null,236.012,null,4,null,null,433.33,102271.07996,20454.215992000001,122725.295952,20818.099999999999,1103.2,722.19672000000003,1970.7002,4922.8393839999999,29537.036303999997]
[1528,8.0299999999999994,null,1506.1120000000001,null,21,null,null,433.33,652643.51295999996,130528.702592,783172.21555199998,107989.1,5791.8,4608.7027200000002,12576.0352,26193.127584000002,157158.76550400001]
[1628,12.03,null,291.07100000000003,null,5,null,null,433.33,126129.79643,25225.959286000001,151355.75571600001,19972.8,1379,890.67726000000005,2430.4428499999999,4934.584022,29607.504131999998]
[1629,12.03,null,309.04700000000003,null,5,null,null,433.33,133919.33650999999,26783.867301999999,160703.20381199999,24775.200000000001,1379,945.68382000000008,2580.5424499999999,5936.0852540000005,35616.511524000001]
[1630,13.03,null,59.884999999999998,null,1,null,null,433.33,25949.967049999999,5189.99341,31139.960459999998,5486.4,275.8,183.24809999999999,500.03974999999997,1289.0975699999999,7734.5854199999994]
[1810,20.03,null,308.75599999999997,null,5,null,null,433.33,133793.23747999998,26758.647495999998,160551.88497599997,63835.1,1379,944.79335999999989,2578.1125999999995,13747.401191999999,82484.407152]
[1811,20.03,null,288.96300000000002,null,5,null,null,433.33,125216.33679,25043.267358000001,150259.60414800001,23256.6,1379,884.22678000000008,2412.84105,5586.5335660000001,33519.201395999997]
[1842,21.03,null,1030.914,null,18,null,null,433.33,446725.96361999999,89345.192724000008,536071.15634400002,183456,4964.4000000000005,3154.5968400000002,8608.1319000000003,40036.625748000006,240219.75448800001]
[1903,22.03,null,969.12699999999995,null,16,null,null,433.33,419951.80290999997,83990.360581999994,503942.16349199996,171990,4412.8,2965.52862,8092.2104499999996,37492.107814000003,224952.64688399999]
[1909,22.03,null,2823.3690000000001,null,48,null,null,433.33,1223450.4887699999,244690.09775399999,1468140.5865239999,327628.79999999999,13238.400000000001,8639.5091400000001,23575.131150000001,74616.368057999993,447698.20834799996]
[1927,22.03,null,1051.905,null,18,null,null,433.33,455821.99364999996,91164.398730000001,546986.39237999998,121766.39999999999,4964.4000000000005,3218.8292999999999,8783.4067500000001,27746.607210000002,166479.64325999998]
[1977,25.03,null,475.53699999999998,null,8,null,null,433.33,206064.44820999997,41212.889641999995,247277.33785199997,38121.800000000003,2206.4,1455.1432199999999,3970.7339499999998,9150.8154340000019,54904.892604000008]
[2040,26.03,null,65.254999999999995,null,1,null,null,433.33,28276.949149999997,5655.3898300000001,33932.33898,4514.3999999999996,275.8,199.68029999999999,544.87924999999996,1106.95191,6641.7114599999995]
[2041,26.03,null,60,null,1,null,null,433.33,25999.8,5199.96,31199.759999999998,4104,275.8,183.6,501,1012.8800000000001,6077.2800000000007]
[2049,26.03,null,65.254999999999995,null,1,null,null,433.33,28276.949149999997,5655.3898300000001,33932.33898,5274.7,275.8,199.68029999999999,544.87924999999996,1259.0119100000002,7554.0714600000001]
[2065,27.03,null,704.202,null,6,null,null,433.33,305151.85265999998,61030.370532000001,366182.22319199995,48427.199999999997,1654.8000000000002,2154.8581199999999,5880.0866999999998,11623.388964,69740.333784000002]
[2072,27.03,null,117.367,null,1,null,null,433.33,50858.642110000001,10171.728422,61030.370532000001,11299.7,275.8,359.14302000000004,980.01445000000001,2582.9314940000004,15497.588964]
[2073,27.03,null,117.367,null,1,null,null,433.33,50858.642110000001,10171.728422,61030.370532000001,11299.7,275.8,359.14302000000004,980.01445000000001,2582.9314940000004,15497.588964]
[2086,28.03,null,486,null,8,null,null,433.33,210598.38,42119.676000000007,252718.05600000001,74533,2206.4,1487.16,4058.1,16456.932000000001,98741.592000000004]
[2087,28.03,null,227.703,null,4,null,null,433.33,98670.540989999994,19734.108198000002,118404.649188,65577.5,1103.2,696.77118000000007,1901.32005,13855.758245999998,83134.549475999986]
[2088,28.03,null,296.00799999999998,null,5,null,null,433.33,128269.14663999999,25653.829328,153922.97596799998,20314.8,1379,905.78447999999992,2471.6668,5014.2502559999994,30085.501535999996]
[2095,28.03,null,60,null,1,null,null,433.33,25999.8,5199.96,31199.759999999998,3369.6,275.8,183.6,501,866,5196]
[2096,28.03,null,56.008000000000003,null,1,null,null,433.33,24269.946640000002,4853.9893280000006,29123.935968000002,3201.1,275.8,171.38448000000002,467.66680000000002,823.19025600000009,4939.1415360000001]
[2097,28.03,null,60,null,1,null,null,433.33,25999.8,5199.96,31199.759999999998,11145.6,275.8,183.6,501,2421.2000000000003,14527.2]
[2098,28.03,null,56.008000000000003,null,1,null,null,433.33,24269.946640000002,4853.9893280000006,29123.935968000002,10588.3,275.8,171.38448000000002,467.66680000000002,2300.6302559999999,13803.781536]
[2099,28.03,null,60,null,1,null,null,433.33,25999.8,5199.96,31199.759999999998,7732.8,275.8,183.6,501,1738.6400000000003,10431.84]
[2100,28.03,null,56.008000000000003,null,1,null,null,433.33,24269.946640000002,4853.9893280000006,29123.935968000002,7346.2,275.8,171.38448000000002,467.66680000000002,1652.2102560000001,9913.261536]
[2113,29.03,null,409.51299999999998,null,7,null,null,433.33,177454.26828999998,35490.853658,212945.12194799999,23138,1930.6000000000001,1253.10978,3419.4335499999997,5948.228666,35689.371996000002]
[2114,29.03,null,1651.432,null,19,null,null,433.33,715615.02856000001,143123.00571200001,858738.03427199996,123105.9,5240.2,5053.3819199999998,13789.457199999999,29437.787823999999,176626.72694399999]
[2121,29.03,null,349.601,null,6,null,null,433.33,151492.60133,30298.520266000003,181791.12159600001,26104.400000000001,1654.8000000000002,1069.7790600000001,2919.1683499999999,6349.6294820000003,38097.776892000002]
[2122,29.03,null,179.34899999999999,null,3,null,null,433.33,77717.302169999995,15543.460434000001,93260.762603999989,14385.6,827.40000000000009,548.80794000000003,1497.5641499999999,3451.8744180000003,20711.246508]
[2133,29.03,null,59.884999999999998,null,1,null,null,433.33,25949.967049999999,5189.99341,31139.960459999998,2462.4,275.8,183.24809999999999,500.03974999999997,684.29757000000006,4105.7854200000002]
[2134,29.03,null,59.731999999999999,null,1,null,null,433.33,25883.667559999998,5176.7335119999998,31060.401071999997,4104,275.8,182.77992,498.76219999999995,1012.2684240000001,6073.6105440000001]
[2135,29.03,null,59.884999999999998,null,1,null,null,433.33,25949.967049999999,5189.99341,31139.960459999998,4449.6000000000004,275.8,183.24809999999999,500.03974999999997,1081.73757,6490.4254200000005]
[2138,30.03,null,476.53500000000003,null,8,null,null,433.33,206496.91154999999,41299.382310000001,247796.29385999998,45773.4,2206.4,1458.1971000000001,3979.0672500000001,10683.41287,64100.477220000001]
[2139,30.03,null,412.74799999999999,null,4,null,null,433.33,178856.09083999999,35771.218167999999,214627.30900799998,34577.4,1103.2,1263.0088800000001,3446.4458,8078.0109360000006,48468.065616]
[2158,30.03,null,55.707999999999998,null,1,null,null,433.33,24139.947639999999,4827.9895280000001,28967.937167999997,6451.2,275.8,170.46647999999999,465.16179999999997,1472.525656,8835.1539360000006]
[2159,30.03,null,117.621,null,1,null,null,433.33,50968.707929999997,10193.741586,61162.449515999993,13593.6,275.8,359.92025999999998,982.1353499999999,3042.2911220000005,18253.746732]
[2161,30.03,null,117.621,null,1,null,null,433.33,50968.707929999997,10193.741586,61162.449515999993,11299.7,275.8,359.92025999999998,982.1353499999999,2583.5111220000003,15501.066732000001]
[2162,30.03,null,117.621,null,1,null,null,433.33,{"$f":"I63*D63","v":50968.707929999997},10193.741586,61162.449515999993,11299.7,{"$f":"275.8*F63","v":275.8},{"$f":"3.06*D63","v":359.92025999999998},982.1353499999999,{"$f":"(M63+N63+O63+P63)*20%","v":2583.5111220000003},{"$f":"M63+N63+O63+P63+Q63","v":15501.066732000001}]
[null,"итого",null,{"$f":"SUM(D12:D63)","v":19631.143999999989},null,null,null,null,null,{"$f":"SUM(J12:J63)","v":8506763.629519999},1701352.7259039998,10208116.355424,2076414.8999999997,84119.000000000058,60071.300639999994,163920.05239999996,476905.05060799996,2861430.3036479992]
[]
["ООО-8"]
[1780,18.03,null,534.48199999999997,null,9,null,null,450,{"$f":"I67*D67","v":240516.9},48103.380000000005,288620.28000000003,137001.60000000001,{"$f":"275.8*F67","v":2482.2000000000003},{"$f":"3.06*D67","v":1635.5149199999998},4462.9246999999996,{"$f":"(M67+N67+O67+P67)*20%","v":29116.447924000004},{"$f":"M67+N67+O67+P67+Q67","v":174698.68754400001}]
[1779,18.03,null,536.35900000000004,null,9,null,null,450,{"$f":"I68*D68","v":241361.55000000002},48272.310000000005,289633.86,142935.9,{"$f":"275.8*F68","v":2482.2000000000003},{"$f":"3.06*D68","v":1641.25854},4478.5976499999997,{"$f":"(M68+N68+O68+P68)*20%","v":30307.591238000008},{"$f":"M68+N68+O68+P68+Q68","v":181845.54742800002}]
[1726,17.03,null,1011.764,null,17,null,null,450,{"$f":"I69*D69","v":455293.8},91058.760000000009,546352.56000000006,188175,{"$f":"275.8*F69","v":4688.6000000000004},{"$f":"3.06*D69","v":3095.99784},8448.2294000000002,{"$f":"(M69+N69+O69+P69)*20%","v":40881.565448000008},{"$f":"M69+N69+O69+P69+Q69","v":245289.39268800002}]
[null,"итого",null,{"$f":"SUM(D67:D69)","v":2082.605},null,null,null,null,null,{"$f":"SUM(J67:J69)","v":937172.25},{"$f":"SUM(K67:K69)","v":187434.45},1124606.7,468112.5,9653,6372.7713000000003,17389.751749999999,100305.60461000002,601833.62766]
[]
["ООО-9"]
[1642,13.03,null,59.884999999999998,null,1,null,null,450,{"$f":"I73*D73","v":26948.25},5389.6500000000005,32337.9,10584,{"$f":"275.8*F73","v":275.8},{"$f":"3.06*D73","v":183.24809999999999},500.03974999999997,{"$f":"(M73+N73+O73+P73)*20%","v":2308.6175699999999},{"$f":"M73+N73+O73+P73+Q73","v":13851.70542}]
[1447,3.03,null,2473.0650000000001,null,21,null,null,450,1112879.25,222575.85,1335455.1000000001,683333.7,5791.8,7567.5789000000004,20650.09275,143468.63433,860811.80597999995]
[1643,13.03,null,646.04499999999996,null,11,null,null,450,290720.25,58144.05,348864.3,114483.6,3033.8,1976.8977,5394.4757499999996,24977.754690000002,149866.52814000001]
[1480,5.03,null,297.44299999999998,null,5,null,null,450,133849.35,{"$f":"J76*20%","v":26769.870000000003},160619.22,82728,1379,910.17557999999997,2483.6490499999995,17500.164925999998,105000.98955599999]
[1446,3.03,null,1804.9780000000001,null,30,null,null,450,812240.1,162448.02000000002,974688.12,498849.9,8274,5523.2326800000001,15071.5663,105543.73979600001,633262.43877599994]
[1847,21.03,null,1001.192,null,16,null,null,450,450536.4,90107.280000000013,540643.68000000005,77271.100000000006,4412.8,3063.64752,8359.9531999999999,18621.500144000001,111729.00086400002]
[1466,4.03,null,3084.5360000000001,null,26,null,null,450,1388041.2,277608.24,1665649.44,853200.4,7170.8,9438.6801599999999,25755.875599999999,179113.15115200003,1074678.9069120002]
[1437,2.0299999999999998,null,2350.2399999999998,null,20,null,null,450,1057608,211521.6,1269129.6000000001,650794,5516,7191.7343999999994,19624.503999999997,136625.24768,819751.48607999994]
[1644,13.03,null,529.99900000000002,null,9,null,null,450,238499.55000000002,47699.91,286199.46000000002,42517.4,2482.2000000000003,1621.7969400000002,4425.4916499999999,10209.377718000002,61256.266308000006]
[1641,13.03,null,55.707999999999998,null,1,null,null,450,25068.6,5013.72,30082.32,9878.4,275.8,170.46647999999999,465.16179999999997,2157.9656559999999,12947.793935999998]
[3000,25.03,null,295.72899999999998,null,5,null,null,450,133078.04999999999,26615.61,159693.66,64152,1379,904.93074000000001,2469.3371499999998,13781.053578000001,82686.321468000009]
[null,"итого",null,{"$f":"SUM(D73:D83)","v":12598.82},null,null,null,null,null,{"$f":"SUM(J73:J83)","v":5669468.9999999991},{"$f":"SUM(K73:K83)","v":1133893.8},6803362.7999999998,3087792.5,39991,38552.389200000005,105200.147,654307.20724000002,3925843.2434400003]

{"sheet":"Результат","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}