{"text_format":"3","workbook":"xls","n_sheets":15,"sheets":["Таб 1","Таб 2","Таб 3","Таб 4","Таб 5","Таб 6","Таб 7","Таб 8","Таб 9","Таб 10","Таб 11","Лист13","Лист14","Лист15","Лист16"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Таб 1","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"flags":["formulas_cached_only"]}
[{"$nulls":4},"Таблица 1"]
["Экспликация угодий"]
["№ п/п","Вид угодий","Площадь га","Балл бонитета ","Оценочная стоимость тыс.т/га"]
[1,2,3,4,5]
[1,"Всего земель",{"v":2554,"d":"2,554"},null,{"v":3880450,"d":"3,880,450 "}]
[2,"Пашня",53]
[3,"Сенокос",37]
[4,"Пастбища",{"v":2464,"d":"2,464"}]
[5,"Прочие",0]

{"sheet":"Таб 2","index":1,"n_rows":19,"n_cols":8,"rows_kept":19,"flags":["formulas_cached_only"]}
[{"$nulls":7},"Таблица 2"]
["Основные средства "]
["№ п/п","Наименование","Год выпуска, сдачи в эксплуатацию, возраст скота","Кол-во","Цена тыс.тенге","Оценочная стоимость тыс.тенге","Залог кол-во","Залоговая стоимость тыс.тенге"]
[1,2,3,4,5,6,7,8]
[2,"КРС всего",null,15,10000,150000,null,0]
[3,"в.т.ч. коров",null,10,null,0,null,0]
[2,"Лошади всего",null,10,15000,150000,null,0]
[4,"в т.ч. конематок",null,4,null,0,null,0]
[5,"Овец",null,150,null,0,null,0]
[7,"в т.ч. овцематок",null,120,null,0,null,0]
[8,"Автомашина ГАЗ - 53",1985,1,100000,100000,1,100000]
[9,"Трактор МТЗ - 80",1991,1,400000,400000,1,400000]
[10,"Прицеп 2ПТС - 4",1990,1,70000,70000,1,70000]
[11,"Кашара  № 1 саманная",1991,1,450000,450000,1,450000]
[12,"Кашара  № 2 саманная",1986,1,300000,300000,1,300000]
[13,"Жилой дом 2-х квартирный саманный",1991,1,320000,320000,1,320000]
[14,"Жилой дом  одноквартирный",null,1,260000,260000,1,260000]
[15,"Юрта 6-ти канатная чабанская в комплекте",null,1,100000,100000,1,100000]
[14,"ИТОГО:",{"$nulls":3},2300000,null,2000000]

{"sheet":"Таб 3","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"flags":["formulas_cached_only"]}
[{"$nulls":6},"Таблица 3"]
["Затраты на приобретение основные и оборотных средств "]
["№ п/п","Наименование","Ед.изм.","Кол-во ","Цена тенге за ед.","Оценочная стоимость тыс.т","Поставщик"]
[1,2,3,4,5,6,7]
[2,null,"ц",null,null,0]
[3,{"$nulls":4},0]
[4,{"$nulls":4},0]
[5,{"$nulls":4},0]
[6,{"$nulls":4},0]
[7,{"$nulls":4},0]
[8,{"$nulls":4},0]
[9,{"$nulls":4},0]
[null,"ИТОГО:"]

{"sheet":"Таб 4","index":3,"n_rows":15,"n_cols":12,"rows_kept":15,"flags":["formulas_cached_only"]}
[{"$nulls":11},"Таблица 4"]
["План производства "]
["РАСТЕНИЕВОДСТВО И КОРМОПРОИЗВОДСТВО"]
["№ ","Наименование","Пло-","Урожай- ","Цена ","Валовая продукция",null,"Товарная продукция",null,"Затраты",null,"Прибыль от "]
[" п/п",null,"щадь га","ность ц/га","т/ц","Объем     ц","Стоимость тыс.тенге","Объем     ц","Стоимость тыс.тенге","на ед.                т / ц","всего      тыс. т ","реализации тыс.тенге"]
[1,2,3,4,5,6,7,8,9,null,10,11]
[1,"Пшеница яровая",20,12,{"v":1120,"d":"1,120"},240,{"v":268.8,"d":"269"},196,{"v":219.52,"d":"220"},665,{"v":130.34,"d":"130"},{"v":89.18,"d":"89"}]
[3,"Ячмень",10,15,700,150,105,128,{"v":89.6,"d":"90"},468,{"v":59.904,"d":"60"},{"v":29.69599999999999,"d":"30"}]
[4,"Овес",10,15,700,150,105,{"v":-106.84239999999997,"d":"-107"},{"v":-74.78967999999998,"d":"-75"},370,{"v":-39.53168799999999,"d":"-40"},{"v":-35.25799199999999,"d":"-35"}]
[5,"Кукуруза на силос",{"v":8.743515,"d":"9"},100,220,{"v":874.3515,"d":"874"},{"v":192.35733,"d":"192"},{"v":-1.1368683772161603e-13,"d":"-0"},{"v":-2.5011104298755527e-14,"d":"-0"}]
[6,"Пары",11]
[7,"ИТОГО",{"v":59.743515,"d":"60"},{"$nulls":3},{"v":478.8,"d":"479"},null,{"v":234.33032000000003,"d":"234"},null,{"v":150.712312,"d":"151"},{"v":83.61800800000002,"d":"84"}]
[8,"Сено естественных сенокосов",37,15,null,555]
[9,"Зеленый корм естес- твенных  пастбищ",2464,20,null,{"v":49280,"d":"49,280"}]
[10,"ВСЕГО",{"v":2560.743515,"d":"2561"},{"$nulls":3},{"v":478.8,"d":"479"},null,{"v":234.33032000000003,"d":"234"},null,{"v":150.712312,"d":"151"},{"v":83.61800800000002,"d":"84"}]

{"sheet":"Таб 5","index":4,"n_rows":12,"n_cols":12,"rows_kept":12,"flags":["formulas_cached_only"]}
[{"$nulls":11},"Таблица 5"]
["План производства "]
["ЖИВОТНОВОДСТВО"]
["№",null,"Пого-","Продук-","Цена ","Валовая продукция",null,"Товарная продукция",null,"Цена ","Затраты","Прибыль от "]
[" п/п","Наименование","ловье гол.","тивность ц/гол","т/ц","Объем     ц","Стоимость тыс.тенге","Объем     ц","Стоимость тыс.тенге",null,"тыс. тенге","реализа- ции тыс.тенге"]
[1,2,3,4,5,6,7,8,9,null,10,11]
[1,"КРС (мясо)",15,1.22,{"v":7500,"d":"7,500"},{"v":18.3,"d":"18"},{"v":137.25,"d":"137"},12,90,{"v":6375,"d":"6,375"},{"v":76.5,"d":"77"},{"v":13.5,"d":"14"}]
[3,"КРС (молоко)",10,{"v":15,"d":"15.00"},{"v":2000,"d":"2,000"},150,300,10,20,{"v":1400,"d":"1,400"},14,6]
[5,"Лошади (мясо)",10,{"v":1.2,"d":"1.20"},{"v":7000,"d":"7,000"},12,84,{"v":4.5,"d":"5"},{"v":31.5,"d":"32"},{"v":4000,"d":"4,000"},18,{"v":13.5,"d":"14"}]
[6,"Овцы (мясо) ",150,0.14,{"v":7000,"d":"7,000"},{"v":21.000000000000004,"d":"21"},{"v":147.00000000000003,"d":"147"},21,147,{"v":4000,"d":"4,000"},84,63]
[7,"Овцы (шерсть) ",150,0.03,{"v":6000,"d":"6,000"},{"v":4.5,"d":"5"},27,5,30,{"v":3000,"d":"3,000"},15,15]
[9,"ИТОГО",{"$nulls":4},{"v":695.25,"d":"695"},null,{"v":318.5,"d":"319"},null,{"v":207.5,"d":"208"},111]

{"sheet":"Таб 6","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"flags":["formulas_cached_only"]}
[{"$nulls":6},"Таблица 6"]
["Расчет потребности в кормах "]
["№      п/п","Наименование","Поголовье голов","Выход на одну голову, ц","Объем                ц","Норма расхода на цетнер продукции (голову)            ц  к.ед.","Потребность           в кормах                     ц  к.ед."]
[1,2,3,5,6,7,8]
[1,"КРС (мясо)",15,1.22,{"v":18.3,"d":"18"},{"v":8.8,"d":"8.80"},{"v":161.04000000000002,"d":"161"}]
[2,"КРС (молоко)",10,{"v":15,"d":"15.00"},150,{"v":1.5,"d":"1.50"},225]
[4,"Лошади всего",10,{"v":1.2,"d":"1.20"},12,{"v":24,"d":"24.00"},288]
[5,"Овцы (мясо) ",150,0.14,{"v":21.000000000000004,"d":"21"},{"v":10.2,"d":"10.20"},{"v":214.20000000000002,"d":"214"}]
[6,"Овцы (шерсть) ",150,0.03,{"v":4.5,"d":"5"},{"v":98.5,"d":"98.50"},{"v":443.25,"d":"443"}]
[7,"ИТОГО",{"$nulls":4},{"v":1331.49,"d":"1,331"}]

{"sheet":"Таб 7","index":6,"n_rows":25,"n_cols":11,"rows_kept":25,"flags":["formulas_cached_only"]}
[{"$nulls":10},"Таблица 7"]
["Баланс кормов"]
["№ ",null,"Потребность ","В том числе по видам"]
["п/п","Наименование","в кормах                    ц к.ед.","конц.","сено","сенаж","солома","силос","корне- плоды"," з / к","молоч-ные"]
[1,2,3,4,5,6,7,8,9,10,11]
[1,"КРС (мясо)",{"v":161.04000000000002,"d":"161"},{"v":33.818400000000004,"d":"34"},{"v":30.597600000000007,"d":"31"},0,{"v":12.883200000000002,"d":"13"},{"v":28.987200000000005,"d":"29"},0,{"v":48.31200000000001,"d":"48"},{"v":6.441600000000001,"d":"6"}]
[2,"Структура в %",100,{"v":21,"d":"21.0"},{"v":19,"d":"19.0"},null,{"v":8,"d":"8.0"},{"v":18,"d":"18.0"},null,{"v":30,"d":"30.0"},{"v":4,"d":"4.0"}]
[3,"КРС (молоко)",225,63,27,0,27,{"v":51.75,"d":"52"},0,{"v":56.25,"d":"56"},0]
[4,"Структура в %",100,{"v":28,"d":"28.0"},{"v":12,"d":"12.0"},null,{"v":12,"d":"12.0"},{"v":23,"d":"23.0"},null,{"v":25,"d":"25.0"}]
[5,"Лошади (мясо)",288,{"v":32.832,"d":"33"},{"v":61.919999999999995,"d":"62"},0,0,{"v":3.168,"d":"3"},0,{"v":190.07999999999998,"d":"190"}]
[6,"Структура в %",100,11.4,21.5,null,null,1.1,null,{"v":66,"d":"66.0"}]
[7,"Овцы (мясо)",{"v":214.20000000000002,"d":"214"},{"v":34.272000000000006,"d":"34"},{"v":32.13,"d":"32"},0,{"v":10.71,"d":"11"},{"v":19.278000000000002,"d":"19"},0,{"v":117.81000000000002,"d":"118"}]
[8,"Структура в %",100,{"v":16,"d":"16.0"},{"v":15,"d":"15.0"},null,{"v":5,"d":"5.0"},{"v":9,"d":"9.0"},null,{"v":55,"d":"55.0"}]
[9,"Овцы (шерсть)",{"v":443.25,"d":"443"},{"v":70.92,"d":"71"},{"v":66.4875,"d":"66"},0,{"v":22.1625,"d":"22"},{"v":39.8925,"d":"40"},0,{"v":243.7875,"d":"244"}]
[10,"Структура в %",100,{"v":16,"d":"16.0"},{"v":15,"d":"15.0"},null,{"v":5,"d":"5.0"},{"v":9,"d":"9.0"},null,{"v":55,"d":"55.0"}]
[11,"Итого в ц к.ед.",{"v":1331.4900000000002,"d":"1,331"},{"v":234.8424,"d":"235"},{"v":218.13510000000002,"d":"218"},0,{"v":72.7557,"d":"73"},{"v":143.0757,"d":"143"},0,{"v":656.2395,"d":"656"},{"v":6.441600000000001,"d":"6"}]
[12,"Страховой фонд в ц к.ед.",{"v":133.14900000000003,"d":"133"},{"v":23.48424,"d":"23"},{"v":21.813510000000004,"d":"22"},0,{"v":7.275570000000001,"d":"7"},{"v":14.307570000000002,"d":"14"},0,{"v":65.62395000000001,"d":"66"}]
[13,"Итого со страхфондом",{"v":1464.6390000000004,"d":"1,465"},{"v":258.32664,"d":"258"},{"v":239.94861000000003,"d":"240"},0,{"v":80.03127,"d":"80"},{"v":157.38327,"d":"157"},0,{"v":721.8634500000001,"d":"722"}]
[14,"К-ты перевода к.ед. ",null,{"v":1.1,"d":"1.10"},0.44,0.36,0.25,0.18,0.26,0.22]
[15,"Общая потребность в ц",null,{"v":234.84239999999997,"d":"235"},{"v":545.33775,"d":"545"},0,{"v":320.12508,"d":"320"},{"v":874.3515000000001,"d":"874"},0,{"v":3281.1975,"d":"3,281"}]
[16,"Потребность в угодьях, га:"]
[17,"пашни",null,{"v":15.656159999999998,"d":"16"},null,null,{"v":26.677090000000003,"d":"27"},{"v":8.743515,"d":"9"}]
[18,"сенокосов",null,null,{"v":36.355850000000004,"d":"36"}]
[19,"пастбищ",{"$nulls":7},{"v":164.059875,"d":"164"}]
[20,"Обеспеченность кормами",null,"100%",{"v":9.662249999999943,"d":"10"},null,"100%","100%",null,{"v":45998.802500000005,"d":"45999"}]

{"sheet":"Таб 8","index":7,"n_rows":10,"n_cols":7,"rows_kept":10,"flags":["formulas_cached_only"]}
[{"$nulls":6},"Таблица 8"]
["Распределение продукции животноводства "]
[" ",null,"            ","В том числе"]
["№ п/п","Наименование","Всего       ц","на выпойку телятам","общепит","натуропла- та","на продажу"]
[1,2,3,4,5,6,7]
[1,"КРС (мясо)",{"v":18.3,"d":"18"},{"$nulls":3},{"v":18.3,"d":"18"}]
[2,"КРС (молоко)",150,{"v":21.472000000000005,"d":"21"},null,null,{"v":128.528,"d":"129"}]
[3,"Лошади (мясо)",12,{"$nulls":3},12]
[4,"Овцы (мясо) ",{"v":21.000000000000004,"d":"21"},{"$nulls":3},{"v":21.000000000000004,"d":"21"}]
[5,"Овцы (шерсть) ",{"v":4.5,"d":"5"},{"$nulls":3},{"v":4.5,"d":"5"}]

{"sheet":"Таб 9","index":8,"n_rows":10,"n_cols":8,"rows_kept":10,"flags":["formulas_cached_only"]}
[{"$nulls":6},"Таблица 9"]
["Распределение продукции растениеводства "]
[" ",null,"            ","В том числе"]
["№ п/п","Наименование","Всего       ц","корма ","обще- пит","натур- опла- та","семе-на","на продажу"]
[1,2,3,4,5,6,7,9]
[1,"Пшеница яровая",240,{"$nulls":3},44,196]
[2,"Ячмень",150,{"$nulls":3},22,128]
[3,"Овес",150,{"v":234.84239999999997,"d":"235"},null,null,22,{"v":-106.84239999999997,"d":"-107"}]
[4,"Кукуруза на силос",{"v":874.3515,"d":"874"},{"v":874.3515000000001,"d":"874"},{"$nulls":3},{"v":-1.1368683772161603e-13,"d":"-0"}]
[5,"Сено естественных сенокосов",555,{"v":545.33775,"d":"545"},{"$nulls":3},{"v":9.662249999999972,"d":"10"}]

{"sheet":"Таб 10","index":9,"n_rows":19,"n_cols":4,"rows_kept":19,"flags":["formulas_cached_only"]}
[{"$nulls":3},"Таблица 10"]
["Финансовый баланс и план"]
[" №  п/п","Наименование статей","Отчет   1996 год тыс.т","План   1997 год тыс.т"]
[1,2,null,3]
[1,"           ВАЛОВОЙ ОБЪЕМ ПРОДАЖ",null,{"v":552.83032,"d":"553 "}]
[2,"Зарплата"]
[3,"Семена"]
[4,"Удобрения и гербициды"]
[5,"ГСМ"]
[6,"Электроэнергия"]
[7,"Амортизация основных средств"]
[8,"Прочие затраты"]
[9,"           ИТОГО  ПРЯМЫХ  ЗАТРАТ",null,{"v":358.212312,"d":"358 "}]
[10,"Торговые издержки",null,{"v":27.641516000000003,"d":"28 "}]
[11,"Налоги "]
[12,"Проценты по кредитам",null,{"v":18,"d":"18 "}]
[13,"            ПРИБЫЛЬ",null,{"v":148.97649200000004,"d":"149 "}]
[14,"Налог на прибыль",null,{"v":44.69294760000001,"d":"45 "}]
[15,"            ЧИСТАЯ  ПРИБЫЛЬ",null,{"v":104.28354440000003,"d":"104 "}]

{"sheet":"Таб 11","index":10,"n_rows":20,"n_cols":8,"rows_kept":20,"flags":["formulas_cached_only"]}
[{"$nulls":6},"Таблица 11"]
["Баланс труда"]
["№","Наименование","Объем ","Норматив затрат труда",null,"Требуется",null,"Фактически"]
["  п/п"," затрат","производства","ед.изм","кол-во","чел.-дней","чел."," занято     чел."]
[1,2,3,4,5,6,7,8]
[1,"КРС всего",{"v":18.3,"d":"18"},"чел.-дн./ гол.",10.8,{"v":197.64000000000001,"d":"198"},{"v":0.8166942148760331,"d":"0.8"}]
[2,"в.т.ч. коров"]
[3,"Лошади всего",10,"гол./ чел.",20,null,0.5]
[4,"в т.ч. конематок"]
[5,"Овец",150,null,null,{"v":462.80487804878055,"d":"463"},{"v":1.9124168514412418,"d":"1.9"}]
[6,"в т.ч. овцематок"]
[7,"ИТОГО"," "," "," "," ",{"v":3.229111066317275,"d":"3.2"}]
[8,"Пшеница яровая",240,"чел.-час./ ц",0.85,{"v":24.878048780487806,"d":"25"},{"v":0.10280185446482565,"d":"0.1"}]
[9,"Ячмень",150,"чел.-час./ ц",0.85,{"v":15.54878048780488,"d":"16"},{"v":0.06425115904051604,"d":"0.1"}]
[10,"Овес",150,"чел.-час./ ц",0.85,{"v":15.54878048780488,"d":"16"},{"v":0.06425115904051604,"d":"0.1"}]
[11,"Кукуруза на силос",{"v":874.3515,"d":"874"},"чел.-час./ ц",0.21,{"v":22.391928658536585,"d":"22"},{"v":0.09252863082039911,"d":"0.1"}]
[12,"Сено естественных сенокосов",555,"чел.-час./ ц",0.38,{"v":25.719512195121954,"d":"26"},{"v":0.10627897601290064,"d":"0.1"}]
[13,"ИТОГО",{"$nulls":4},{"v":0.4301117793791575,"d":"0.4"}]
[14,"АУП",null,"% ",15,null,{"v":0.5488834268544648,"d":"0.5"}]
[15,"ВСЕГО",{"$nulls":4},{"v":4.208106272550897,"d":"4.2"},54]

{"sheet":"Лист13","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Лист14","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Лист15","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Лист16","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}