{"text_format":"1","workbook":"xls","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,"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","formulas":"cached_only"}

{"sheet":"Лист1","index":0,"n_rows":279,"n_cols":25,"rows_kept":279,"cut":false,"hidden":false,"merged":[[55,9,55,10],[56,1,56,2],[56,3,56,4],[56,5,56,6],[56,7,56,8],[28,12,28,15],[29,8,29,9],[29,10,29,11],[8,19,8,20],[8,21,8,22],[8,23,8,24],[28,16,28,21],[29,12,29,13],[29,14,29,15],[29,16,29,17],[29,18,29,19],[29,20,29,21],[7,13,7,16],[7,17,7,20],[7,21,7,24],[8,5,8,6],[8,7,8,8],[8,9,8,10],[8,11,8,12],[8,13,8,14],[8,15,8,16],[8,17,8,18],[7,9,7,12],[111,7,111,8],[112,1,112,3],[112,4,112,6],[85,0,86,0],[85,1,86,1],[85,2,86,2],[85,3,85,7],[7,0,7,1],[7,5,7,8],[18,0,18,4],[28,0,28,3],[28,4,28,7],[28,8,28,11],[39,0,39,1],[29,0,29,1],[29,2,29,3],[29,4,29,5],[29,6,29,7],[56,9,56,10],[55,0,56,0],[55,1,55,2],[55,3,55,4],[55,5,55,6],[55,7,55,8],[162,6,162,7],[162,8,162,9],[162,10,162,11],[162,12,162,13],[162,14,162,15],[152,0,153,2],[80,0,81,2],[162,0,162,1],[162,2,162,3],[162,4,162,5],[136,0,137,0],[136,1,137,1],[136,2,136,3],[136,4,136,5],[113,1,113,3],[114,1,114,3],[115,1,115,3],[113,4,113,6],[114,4,114,6],[115,4,115,6],[85,8,86,8],[110,0,110,8],[111,0,112,0],[111,1,111,6],[240,10,240,11],[267,1,267,2],[268,1,268,2],[269,1,269,2],[270,1,270,2],[263,0,264,2],[218,2,218,3],[218,0,219,0],[218,1,219,1],[218,4,219,4],[236,0,237,2],[276,1,276,2],[277,1,277,2],[278,1,278,2],[0,0,1,2],[4,0,4,3],[24,0,24,2],[52,0,52,2],[109,0,109,4],[161,0,161,5],[172,3,173,5],[0,3,1,5],[271,1,271,2],[272,1,272,2],[273,1,273,2],[274,1,274,2],[275,1,275,2],[163,0,163,1],[164,0,168,0],[172,0,173,2],[192,0,193,2]],"flags":["formulas_cached_only"]}
["Пункт 1",null,null,"РГР1"]
[]
[]
[]
[]
[]
["Таблица 1.1 – Результаты расчета количества машин для депо по периодам работы"]
["окончание работы",null,"Si ,","vi ,","ti ,","6:00-9:00",null,null,null,"9:00-15:00",null,null,null,"15:00-19:00",null,null,null,"19:00-22:00",null,null,null,"после  22:00"]
["будн","вых","км","км/ч","мин","чпу ti, мин",null,"чпу ni, ед",null,"мпу ti, мин",null,"мпу ni, ед",null,"чпв ti, мин",null,"чпв ni, ед",null,"мпв ti, мин",null,"мпв ni, ед",null,"Дг ti, мин",null,"Дг ni, ед"]
["-","-",24.8,18.835443037974684,79,16,0,5,"-",0,0,"-","-",20,0,4,"-",0,0,"-","-",0,0,"-","-"]
["04:43:00","01:47:00",31.4,17.28440366972477,109,3,4,37,28,6,4,23,28,4,4,28,28,14,8,8,14,22,22,5,5]
["05:17:00","00:35:00",21.7,19.432835820895523,67,4,13,17,6,13,13,6,6,4,13,17,6,13,13,6,6,13,13,6,6]
["04:44:00","01:50:00",30.9,16.4070796460177,113,6,8,19,15,8,8,15,15,6,8,19,15,23,16,5,8,23,23,5,5]
["04:33:00","01:33:00",33.1,18.220183486238533,109,5,7,22,16,9,7,13,16,5,7,22,16,14,14,8,8,18,18,7,7]
["-","-",24.3,18.692307692307693,78,16,0,5,"-",0,0,"-","-",16,0,5,"-",0,0,"-","-",0,0,"-","-"]
["-","-",30.5,17.941176470588236,102,26,0,4,"-",0,0,"-","-",26,0,4,"-",0,0,"-","-",0,0,"-","-"]
["09:30:00","16:30:00",25.5,17.386363636363637,88,29,44,4,2,29,44,2,2,29,44,2,2,29,88,4,1,0,0,"-","-"]
["05:50:00","21:54:00",19.1,17.104477611940297,67,22,17,4,4,22,17,4,4,34,17,4,4,34,34,2,2,67,67,1,1]
["сумма",null,null,null,null,null,null,117,71,null,null,63,71,null,null,105,71,null,null,33,39,null,null,24,24]
[]
[]
[]
["nр, ед",117,"nв, ед",71]
[]
[]
[]
[]
["Таблица 1.2 – Результаты расчета машино-часов по периодам работы"]
["6:00-9:00 (3)",null,null,null,"9:00-15:00 (5)",null,null,null,"15:00-19:00 (4)",null,null,null,"19:00-22:00 (3)",null,null,null,"после 22:00"]
["чпу ni, ед",null,"чпу Ti, маш. Ч.",null,"мпу ni, ед",null,"мпу Ti, маш. Ч.",null,"чпв ni, ед",null,"чпв Ti, маш. Ч.",null,"мпв ni, ед",null,"мпв Ti, маш. Ч.",null,"тау ДГ",null,"Дг ni, ед",null,"Дг Ti, маш. Ч."]
[5,"-",15,"-","-","-","-","-",4,"-",16,"-","-","-","-","-","-","-","-","-","-","-"]
[37,28,111,84,23,28,115,140,28,28,112,112,8,14,24,42,4,4,5,5,20,20]
[17,6,51,18,6,6,30,30,17,6,68,24,6,6,18,18,2.5,2.5,6,6,15,15]
[19,15,57,45,15,15,75,75,19,15,76,60,5,8,15,24,3.5,4,5,5,17.5,20]
[22,16,66,48,13,16,65,80,22,16,88,64,8,8,24,24,3.5,3.5,7,7,24.5,24.5]
[5,"-",15,"-","-","-","-","-",5,"-",20,"-","-","-","-","-","-","-","-","-","-","-"]
[4,"-",12,"-","-","-","-","-",4,"-",16,"-","-","-","-","-","-","-","-","-","-","-"]
[4,2,12,6,2,2,10,10,2,2,8,8,4,1,12,3,"-","-","-","-","-","-"]
[4,4,12,12,4,4,20,20,4,4,16,16,2,2,6,6,0.5,"-",1,1,0.5,"-"]
["Сумма",null,351,213,null,null,315,355,null,null,420,284,null,null,99,117,null,null,null,null,77.5,79.5]
[]
[]
[]
["Тр, маш.•ч",1262.5,"Тв, маш*ч",1048.5]
["tccp, ч",10.790598290598291,"tccв, ч",14.767605633802816]
["tcc, ч",12.040503552870907]
["Tо, маш*ч",438107]
["Tсг, маш*ч",3561.8455284552847]
["nи, ед",123]
["Др, дней",254]
["Дв, дней",112]
[]
[]
[]
["Таблица 1.3 – Результаты расчета машино-километров пробега по периодам работы"]
["Vi","6:00-9:00",null,"9:00-15:00",null,"15:00-19:00",null,"19:00-22:00",null,"после  22:00"]
[null,"чпу Li, маш*км",null,"мпу Li, маш*км",null,"чпв Li, маш*км",null,"мпв Li, маш*км",null,"Дг Li, мин"]
[18.835443037974684,282.53164556962025,"-","-","-",301.36708860759495,"-","-","-","-","-"]
[17.28440366972477,1918.5688073394497,1451.8899082568807,1987.7064220183486,2419.816513761468,1935.8532110091744,1935.8532110091744,414.82568807339453,725.9449541284404,345.6880733944954,345.6880733944954]
[19.432835820895523,991.0746268656717,349.7910447761194,582.9850746268656,582.9850746268656,1321.4328358208957,466.3880597014926,349.7910447761194,349.7910447761194,291.4925373134328,291.4925373134328]
[16.4070796460177,935.2035398230089,738.3185840707964,1230.5309734513276,1230.5309734513276,1246.9380530973451,984.4247787610619,246.10619469026548,393.7699115044248,287.12389380530976,328.141592920354]
[18.220183486238533,1202.532110091743,874.5688073394496,1184.3119266055046,1457.6146788990827,1603.3761467889908,1166.091743119266,437.2844036697248,437.2844036697248,446.39449541284404,446.39449541284404]
[18.692307692307693,280.3846153846154,"-","-","-",373.84615384615387,"-","-","-","-","-"]
[17.941176470588236,215.29411764705884,"-","-","-",287.05882352941177,"-","-","-","-","-"]
[17.386363636363637,208.63636363636363,104.31818181818181,173.86363636363637,173.86363636363637,139.0909090909091,139.0909090909091,208.63636363636363,52.15909090909091,"-","-"]
[17.104477611940297,205.25373134328356,205.25373134328356,342.08955223880594,342.08955223880594,273.67164179104475,273.67164179104475,102.62686567164178,102.62686567164178,8.552238805970148,"-"]
["Сумма",6239.479557700815,3724.1402576047117,5501.487585304489,6206.900429341185,7482.63486358152,4965.520343472949,1759.2705605175095,2061.5762706594423,1379.2512387320521,1411.7166990411263]
[]
[]
[]
["Lp, маш*км",22362.12380583639]
["Lв, маш*км",18369.854000119416]
["Lccp, км",191.12926329774692]
["Lccв, км",258.73033802985094]
["Lcc, км",212.39624859444118]
["L0, маш*км",7737403.094695818]
["Lcг, км",62905.71621703917]
[]
[]
[]
["2 пункт"]
[]
[]
[]
["Таблица 2.7 – Программа ремонтов и обслуживаний на плановый период"]
["Пробег тыс. км.","Вид рем.","Qб, чел ч","Коррект. Коэфф.",null,null,null,null,"Q, чел ч"]
[null,null,null,"k1","k2","k3","k4","k5"]
[200,"то-1",10.1,1,1,1.25,1,1.05,13.256250000000001]
[202.5,"то-1",10.1,1,1,1.25,1,1.05,13.256250000000001]
[205,"то-2",32.6,1,1,1.25,1,1.05,42.7875]
[207.5,"то-1",10.1,1,1,1.25,1,1.05,13.256250000000001]
[210,"то-1",10.1,1,1,1.25,1,1.05,13.256250000000001]
[212.5,"то-1",10.1,1,1,1.25,1,1.05,13.256250000000001]
[215,"то-2 СО(л)",39.12,1,1,1,1,1.05,41.076]
[217.5,"то-1",10.1,1,1,1,1,1.05,10.605]
[220,"то-1",10.1,1,1,1,1,1.05,10.605]
[222.5,"то-1",10.1,1,1,1,1,1.05,10.605]
[225,"то-2",32.6,1,1,1,1,1.05,34.230000000000004]
[227.5,"то-1",10.1,1,1,1,1,1.05,10.605]
[230,"тр",1723,1,1,1,1,1.05,1809.15]
[232.5,"то-1",10.1,1,1,1,1,1.05,10.605]
[235,"то-1",10.1,1,1,1,1,1.05,10.605]
[237.5,"то-1",10.1,1,1,1,1,1.05,10.605]
[240,"то-2 СО(з)",42.38,1,1,1.25,1,1.05,55.62375]
[242.5,"то-1",10.1,1,1,1.25,1,1.05,13.256250000000001]
[245,"то-1",10.1,1,1,1.25,1,1.05,13.256250000000001]
[247.5,"то-1",10.1,1,1,1.25,1,1.05,13.256250000000001]
[]
[]
["Таблица 2.8 – Производственный план депо"]
["производственный план депо"]
["вид рем. И ослуж.","количество ремонта и обслуживания за плановый период",null,null,null,null,null,"трудоемкость ремонтов и обслуживаний, чел. Ч."]
[null,"1-ого троллейбуса",null,null,"всего парка",null,null,"1-го трол.","всего парка"]
["тр",1,null,null,123,null,null,1809.15,222525.45]
["то2",4,null,null,492,null,null,173.71725,21367.22175]
["то-1",15,null,null,1845,null,null,180.285,22175.055]
[]
[]
[]
[]
[]
["Таблица 2.9 – Время нахождения машин в ремонте и обслуживании"]
["вид рем. и обсл.","ni","норм. продолж. ремонта и обслуживания раб. дни ","время затраченое на ремонт или обсл., ч","время нахожд. или обсл.","время которое ПС не раб. на  маршруте по причине ремонта и обслуживания, ч"]
["тр",123,8,7872,23616,11847.855496024973]
["то-2",492,1,3936,11808,5923.9277480124865]
["то-1",1845,2,3690,3690,44429.45811009365]
[null,null,null,null,"Сумма",62201.24135413111]
[]
[]
[]
["Др, дней",254,null,"n то-2 ф",0.9717729245427307,"Дmin",246.8303228338536,247,"Дmax",7.169677166146409,8]
["Дв, дней",111,null,"n то-1 ф",7.28829693407048,"Дmin",73.22742125390202,74,"Дmax",180.77257874609796,181]
[null,null,null,"n тр ф",1.9435458490854614,"Дmin",239.66064566770717,240,"Дmax",14.339354332292817,15]
[]
[]
["Таблица 2.10 – Фронт ремонтов"]
["Вид  рем. И осл","кол-во","фронт ремонтов или обсл, ед",null,"число дней с max или min фронтом ремонта I вида, дней"]
[null,null,"min","max","min","max"]
["тр",123,1,2,240,15]
["то-2",492,0,1,247,8]
["то-1",1845,7,8,74,181]
[]
[]
["n ф, ед",11,null,null,"α вр",0.8211382113821138]
[]
["n и, ед",122.10000000000001,123,null,"n ео, ед",37599]
[]
[null,null,null,null,"α вр Г",0.8374874707651186]
[]
[]
[]
[]
["3 пункт"]
[]
[]
[]
["Teo, чел*ч",2.25,null,"t cм, ч",8]
["T сум eo, чел*ч",276.75,null,"n бр, чел",4.375,5]
["n cум, чел",34.59375,35]
[]
[]
["Схема работы бригад ЕО и ЗР приведена на рисунке 3.1."]
["сутки",null,1,null,2,null,3,null,4,null,5,null,6,null,7]
["время смены",null,"08:00:00","19:00:00","08:00:00","19:00:00","08:00:00","19:00:00","08:00:00","19:00:00","08:00:00","19:00:00","08:00:00","19:00:00","08:00:00","19:00:00"]
["бригады ",1,"зр",null,null,"ео",null,null,null,"ео",null,null,null,"ео"]
[null,2,null,null,"зр",null,null,"ео",null,null,null,"ео",null,null,null,"ео"]
[null,3,null,"ео",null,null,null,"ео",null,null,"зр",null,null,null,"зр"]
[null,4,"зр",null,null,"ео",null,null,"зр",null,null,null,"зр"]
[null,5,null,"ео",null,null,"зр",null,null,null,"зр",null,null,null,null,"ео"]
[]
[]
[]
["5 пункт",null,null,"РГР2"]
[]
[]
[]
[]
["Ч в я, чел",171.7,null,"Фр, ч",2708]
["Ч в е, чел",178.56799999999998]
[]
[]
[]
["Ч p тр, чел",82.17335672082719,83]
["Ч p то-2, чел",7.890406850073855,8]
["Ч p то-1, чел",8.18872045790251,9]
[]
[]
["Ч р ео, чел",32]
["Ч р всп, чел",25,25]
[]
[]
[]
["6 пункт"]
[]
[]
[]
[]
["n тр ео, тролл",13.5,14,null,"L1, м",2]
["nд, тролл",103.0109589041096,103,null,"L2, м",1.25]
["nео, мест",7.357142857142857,8,null,"L3, м",0.5]
["n р, тролл",0.515,1,null,"A п, чел",8]
["L му, м",109.14,null,null,"L пс, м",11.83]
["L оэ, м",122.14,null,null,"L мт, м",1]
[null,null,null,null,"L мк, м",4]
[]
[]
["n тр м, тролл",1.452755905511811,2,null,"Т м, дней",3]
["n тр к, тролл",2.421259842519685,3,null,"n тр, тролл",123]
[null,null,null,null,"Д р, дней",254]
[null,null,null,null,"t тр, дней",8]
[]
[]
[]
[]
[]
[]
[]
["Таблица 1.1 – Расчёт площади производственных мастерских"]
["Наим уч и отд","Кол-во работ","Уд-ая площадь, м^2",null,"F п, м^2"]
[null,null,"f1","f0"]
["агрегатное",10,25,10,115]
["электротезн",14,20,10,150]
["кузнечно-ресс",7,30,15,120]
["сварочное",8,15,10,85]
["столярое",5,20,10,60]
["обойное",4,20,10,50]
["слесарно-кузн",42,20,8,348]
["слесарно-механ",20,25,10,215]
["аккумул",6,25,12,85]
["машиномонтажн",7,25,10,85]
[]
[]
[]
[]
[]
[]
["7 пункт"]
[]
[]
[]
["V к, м3",7.38,null,null,null,"v к, м3/ед",0.06]
["n комп, компрессоров",1.476,3,null,null,"n и, чел",123]
["F к, м2",45,null,null,null,"f к, м2",15]
["P с т, кВА/ед",307.5,null,null,null,"p",2.5]
["n с т, трансф-в",1.23,3,null,null,"P, кВА",250]
["F т, м2",108,null,null,null,"f т, м2",36]
["F м, м2",24.6,null,null,null,"f м, м2",0.2]
["F кл, м2",123,null,null,null,"f кл, м2",1]
["F ст, м2",185,null,null,null,"f авт, м2",45]
["F гсм, м2",61.5,null,null,null,"f мост, м2",50]
["F кл р, м2",null,null,null,null,"n авт",3]
["L, км",773740.3094695816,null,null,null,"f гсм, м2",0.5]
["n з, ед",0.6933156894888723,1,null,null,"L сг, м",1048.4286036173191]
["n о з , ед",2,null,null,null,"n ",6]
["n оз п, ед",0.1,1,null,null,"l п",93000]
["n оз к, ед",0.13333333333333333,1,null,null,"k1",20]
["F кл, м2",4,null,null,null,"k2",15]
[null,null,null,null,null,"f п, м2",3]
[null,null,null,null,null,"f к, м2",1]
[]
[]
[]
[]
["8 пункт"]
[]
[]
[null,null,null,null,null,"А1, чел",16]
["А гв, чел",20,null,null,null,"А с, чел",16]
["S гв, м2",20,null,null,null,"f гв, м2",1]
["S р м, м2",40.949999999999996,null,null,null,"f r, м2",0.5]
["S р ж, м2",17.55,null,null,null,"A r, чел",117]
["S д м , м2",46.8,null,null,null,"f д, м2",4]
["S д ж, м2",20.057142857142857,null,null,null,"f у, м2",2.5]
["S у м, м2",20.475,null,null,null,"f з, м2",0.25]
["S уж, м2",8.775,null,null,null,"f  и, м2",0.25]
["S уб м, м2",32.2875,null,null,null,"f уб, м2",4.5]
["S убж, м2",13.837499999999999]
["S з, м2",30.75]
["S и, м2",43]

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

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