{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["D_PA_EQUI","D_PASS","apura","resumo"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":29,"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":"D_PA_EQUI","index":0,"n_rows":48,"n_cols":25,"rows_kept":48,"cut":false,"hidden":false,"merged":[[10,1,11,1],[10,7,11,7],[10,8,11,8],[10,9,11,9],[10,15,11,15],[10,11,10,13],[10,6,11,6],[10,2,10,5]]}
[]
[null,"PREFEITURA MUNICIPAL DE CHAPECO"]
[null,"CONTROLADORIA GERAL DO MUNICIPIO"]
[]
[null,"SISTEMA DE TRANSPORTE COLETIVO URBANO DE CHAPECÓ"]
[]
[null,"PASSAGEIROS TRANSPORTADOS"]
[]
[null,"TOTAL DO SISTEMA"]
[]
[null,"Período/Mês","Passageiros Pagantes",null,null,null,"Soma","Gratuidades","Passageiros Transportados","Passageiros Equivalentes",null,"QUILOMETRAGEM ",null,null,null,"IPK"]
[null,null,"Antecipado","Embarcado","Estudante","Vale Transporte",null,null,null,null,null,"Km Programado","Km Ocioso","KM Total"]
[]
[null,"TARIFA",2.0299999999999998,2.2999999999999998,1,2.0299999999999998,null,null,null,2.0299999999999998,null,null,0.05]
[]
[null,"2009-12-31",300917,139812,76210,470870,987809,125976,1113785,967736.55665024626,null,397879.4,19893.97,417773.37,null,2.3164151335214265,null,610861.51,321567.59999999998,76210,955866.1,1964505.21,1.7638100800423775]
[null,"2010-01-31",108179,274093,2910,423075,808257,87536,895793,843236.21674876846,null,366206.3,18310.315000000002,384516.61499999999,null,2.1929773223161462,null,219603.37,630413.9,2910,858842.25,1711769.52,1.9108985223148649]
[null,"2010-02-28",96766,251868,45097,378933,772664,86297,858961,783281.95566502458,null,357301.3,17865.065000000002,375166.36499999999,null,2.0878256388069985,null,196434.98,579296.4,45097,769233.99,1590062.37,1.851146175437534]
[null,"2010-03-31",156385,290385,181684,514023,1142477,151955,1294432,1088915.142857143,null,412104.6,20605.23,432709.83,null,2.5165019774502069,null,317461.55,667885.5,181684,1043466.69,2210497.7400000002,1.7076970748559985]
[null,"2010-04-30",144157,246245,166788,469286,1026476,134952,1161428,974601.37438423652,null,384590.7,19229.535000000003,403820.23499999999,null,2.413453536780386,null,292638.71000000002,566363.5,166788,952650.58,1978440.79,1.7034553928439817]
[null,"2010-05-31",151918,253453,181441,500724,1087536,136848,1224384,1029185.3004926108,null,398176.4,19908.82,418085.22,null,2.461663917448722,null,308393.53999999998,582941.9,181441,1016469.72,2089246.16,1.7063651272803302]
[null,"2010-06-30",150048,241811,170006,492224,1054089,139111,1193200,999991.85221674875,null,390862,19543.099999999999,410405.1,null,2.4365970408670576,null,304597.44,556165.30000000005,170006,999214.72,2029983.46,1.7012935467650012]
[null,"2010-07-31",154747,249651,107962,502981,1015341,128725,1144066,993767.06403940893,null,401931.1,20096.555,422027.65499999997,null,2.3547439421698773,null,314136.40999999997,574197.30000000005,107962,1021051.43,2017347.14,1.7633136025369165]
[null,"2010-08-31",151888,257748,168231,495192,1073059,137994,1211053,1021982.1674876848,null,397116.11,19855.805500000002,416971.9155,null,2.4509616343398184,null,308332.64,592820.4,168231,1005239.76,2074623.8,1.7130743245753899]
[null,"2010-09-30",145294,255592,164715,486808,1052409,139056,1191465,1002829.3891625615,null,395790,19789.5,415579.5,null,2.4130867599642465,null,294946.82,587861.6,164715,988220.24,2035743.66,1.7086055066661627]
[null,"2010-10-31",141603,258385,154887,479777,1034652,138434,1173086,990430.49261083745,null,390902.5,19545.125,410447.625,null,2.4130496372365107,null,287454.09000000003,594285.5,154887,973947.31,2010573.9,1.713918587384045]
[null,"2010-11-30",143339,251090,168470,477273,1040172,141193,1181365,988088.35467980301,null,380004.8,19000.240000000002,399005.04,null,2.4763806358932285,null,290978.17,577507,168470,968864.19,2005819.36,1.6978828389193854]
[null,"Total",1845241,2970133,1588401,5691166,12094941,1548077,13643018,11684045.866995074,null,4672865.21,233643.26049999997,4906508.4704999998,null,null,null,3745839.23,6831305.8999999985,1588401,11553066.979999999,23718613.109999996,1.7385165884850402]
[null,"Média Mensal",153770.08333333334,247511.08333333334,132366.75,474263.83333333331,1007911.75,129006.41666666667,1136918.1666666667,973670.48891625612,null,389405.43416666664,19470.27170833333,408875.70587499999,null,2.3813361247095544]
[]
[null,null,0.13300000000000001,0.13300000000000001,0.13300000000000001,0.13300000000000001,0.98634776995172702]
[null,null,2.2999999999999998,2.5,1.1000000000000001,2.2999999999999998]
[null,"TARIFA",2.0300088261253308,2.206531332744925,0.97087378640776711,2.0300088261253308,null,null,null,2.0300088261253308]
[]
[null,"2009-12-31",300917,139812,76210,470870,987809,125976,1113785,967736.55665024626,null,397879.4,19893.97,417773.37,null,2.3164151335214265,null,610864.16593115614,308499.55869373347,73990.291262135928,955870.25595763454,1949224.2718446602,1.7500902524676307]
[null,"2010-01-31",108179,274093,2910,423075,808257,87536,895793,843236.21674876846,null,366206.3,18310.315000000002,384516.61499999999,null,2.1929773223161462,null,219604.32480141218,604794.79258605477,2825.2427184466023,858845.98411297437,1686070.3442188881,1.8822097786194891]
[null,"2010-02-28",96766,251868,45097,378933,772664,86297,858961,783281.95566502458,null,357301.3,17865.065000000002,375166.36499999999,null,2.0878256388069985,null,196435.83406884377,555754.63371579873,43783.495145631074,769237.33451015002,1565211.2974404236,1.8222146260894541]
[null,"2010-03-31",156385,290385,181684,514023,1142477,151955,1294432,1088915.142857143,null,412104.6,20605.23,432709.83,null,2.5165019774502069,null,317462.93027360988,640743.60105913505,176392.23300970875,1043471.2268314209,2178069.9911738746,1.6826453542355833]
[null,"2010-04-30",144157,246245,166788,469286,1026476,134952,1161428,974601.37438423652,null,384590.7,19229.535000000003,403820.23499999999,null,2.413453536780386,null,292639.98234774929,543347.30803177401,161930.09708737867,952654.72197705205,1950572.1094439537,1.6794602071277374]
[null,"2010-05-31",151918,253453,181441,500724,1087536,136848,1224384,1029185.3004926108,null,398176.4,19908.82,418085.22,null,2.461663917448722,null,308394.88084730803,559251.98587819946,176156.31067961166,1016474.1394527801,2060277.3168578993,1.6827051944960889]
[null,"2010-06-30",150048,241811,170006,492224,1054089,139111,1193200,999991.85221674875,null,390862,19543.099999999999,410405.1,null,2.4365970408670576,null,304598.76434245362,533563.54810238304,165054.36893203887,999219.06443071482,2002435.7458075902,1.6782062904857444]
[null,"2010-07-31",154747,249651,107962,502981,1015341,128725,1144066,993767.06403940893,null,401931.1,20096.555,422027.65499999997,null,2.3547439421698773,null,314137.7758164166,550862.7537511033,104817.47572815535,1021055.869373345,1990873.8746690203,1.7401739713172319]
[null,"2010-08-31",151888,257748,168231,495192,1073059,137994,1211053,1021982.1674876848,null,397116.11,19855.805500000002,416971.9155,null,2.4509616343398184,null,308333.98058252427,568729.03795233893,163331.06796116507,1005244.1306266548,2045638.2171226831,1.6891401260908343]
[null,"2010-09-30",145294,255592,164715,486808,1052409,139056,1191465,1002829.3891625615,null,395790,19789.5,415579.5,null,2.4130867599642465,null,294948.1023830538,563971.75639894081,159917.47572815535,988224.53662842012,2007061.8711385704,1.6845327988137044]
[null,"2010-10-31",141603,258385,154887,479777,1034652,138434,1173086,990430.49261083745,null,390902.5,19545.125,410447.625,null,2.4130496372365107,null,287455.33980582521,570134.59841129743,150375.72815533984,973951.54457193287,1981917.2109443953,1.6894901234388573]
[null,"2010-11-30",143339,251090,168470,477273,1040172,141193,1181365,988088.35467980301,null,380004.8,19000.240000000002,399005.04,null,2.4763806358932285,null,290979.4351279788,554037.95233892323,163563.10679611654,968868.402471315,1977448.8967343336,1.6738678534867155]
[null,"Total",1845241,2970133,1588401,5691166,12094941,1548077,13643018,11684045.866995074,null,4672865.21,233643.26049999997,4906508.4704999998,null,null,null,3745855.5163283311,6553691.5269196816,1542136.8932038837,11553117.210944392,23394801.147396293,1.7147819600763037,0.98634776995172702,1.3841193202009494E-2]
[null,"Média Mensal",153770.08333333334,247511.08333333334,132366.75,474263.83333333331,1007911.75,129006.41666666667,1136918.1666666667,973670.48891625612,null,389405.43416666664,19470.27170833333,408875.70587499999,null,2.3813361247095544]

{"sheet":"D_PASS","index":1,"n_rows":78,"n_cols":16,"rows_kept":78,"cut":false,"hidden":false,"merged":[[10,15,11,15],[10,11,10,13],[10,6,11,6],[10,2,10,5],[10,1,11,1],[10,7,11,7],[10,8,11,8],[10,9,11,9]]}
[]
[null,"PREFEITURA MUNICIPAL DE CHAPECO"]
[null,"CONTROLADORIA GERAL DO MUNICIPIO"]
[]
[null,"SISTEMA DE TRANSPORTE COLETIVO URBANO DE CHAPECÓ"]
[]
[null,"PASSAGEIROS TRANSPORTADOS"]
[]
[null,"TOTAL DO SISTEMA"]
[]
[null,"Período/Mês","Passageiros Pagantes",null,null,null,"Soma","Gratuidades","Passageiros Transportados","Passageiros Equivalentes",null,"QUILOMETRAGEM ",null,null,null,"IPK"]
[null,null,"Antecipado","Embarcado","Estudante","Vale Transporte",null,null,null,null,null,"Km Programado","Km Ocioso","KM Total"]
[]
[null,"TARIFA",2.0299999999999998,2.2999999999999998,1,2.0299999999999998,null,null,null,2.0299999999999998,null,null,0.05]
[]
[null,"2009-12-31",300917,139812,76210,470870,987809,125976,1113785,967736.55665024626,null,397879.4,19893.97,417773.37,null,2.3164151335214265]
[null,"2010-01-31",108179,274093,2910,423075,808257,87536,895793,843236.21674876846,null,366206.3,18310.315000000002,384516.61499999999,null,2.1929773223161462]
[null,"2010-02-28",96766,251868,45097,378933,772664,86297,858961,783281.95566502458,null,357301.3,17865.065000000002,375166.36499999999,null,2.0878256388069985]
[null,"2010-03-31",156385,290385,181684,514023,1142477,151955,1294432,1088915.142857143,null,412104.6,20605.23,432709.83,null,2.5165019774502073]
[null,"2010-04-30",144157,246245,166788,469286,1026476,134952,1161428,974601.37438423652,null,384590.7,19229.535000000003,403820.23499999999,null,2.413453536780386]
[null,"2010-05-31",151918,253453,181441,500724,1087536,136848,1224384,1029185.3004926108,null,398176.4,19908.82,418085.22,null,2.461663917448722]
[null,"2010-06-30",150048,241811,170006,492224,1054089,139111,1193200,999991.85221674875,null,390862,19543.099999999999,410405.1,null,2.4365970408670576]
[null,"2010-07-31",154747,249651,107962,502981,1015341,128725,1144066,993767.06403940893,null,401931.1,20096.555,422027.65499999997,null,2.3547439421698773]
[null,"2010-08-31",151888,257748,168231,495192,1073059,137994,1211053,1021982.1674876848,null,397116.11,19855.805500000002,416971.9155,null,2.4509616343398184]
[null,"2010-09-30",145294,255592,164715,486808,1052409,139056,1191465,1002829.3891625615,null,395790,19789.5,415579.5,null,2.4130867599642465]
[null,"2010-10-31",141603,258385,154887,479777,1034652,138434,1173086,990430.49261083745,null,390902.5,19545.125,410447.625,null,2.4130496372365107]
[null,"2010-11-30",143339,251090,168470,477273,1040172,141193,1181365,988088.35467980301,null,380004.8,19000.240000000002,399005.04,null,2.4763806358932285]
[null,"Total",1845241,2970133,1588401,5691166,12094941,1548077,13643018,11684045.866995074,null,4672865.21,233643.26049999997,4906508.4704999998]
[null,"Média Mensal",153770.08333333334,247511.08333333334,132366.75,474263.83333333331,1007911.75,129006.41666666667,1136918.1666666667,973670.48891625612,null,389405.43416666664,19470.27170833333,408875.70587499999,null,2.3813361247095544]
[]
[null,"AUTO VIAÇÃO CHAPECO"]
[]
[null,"2009-12-31",274584,88665,64075,359475,786799,100793,887592,766080.92118226597,null,324729.40000000002,16236.47,340965.87,null,2.2467964936850309]
[null,"2010-01-31",83998,230840,2492,319984,637314,69576,706890,666752.44334975374,null,293056.3,14652.815000000001,307709.11499999999,null,2.1668270806659522]
[null,"2010-02-28",71265,206546,35689,272840,586340,65838,652178,595703.42364532023,null,284151.3,14207.565000000001,298358.86499999999,null,1.9966003813740216]
[null,"2010-03-31",121814,244148,149419,391291,906672,121739,1028411,863331.30541871919,null,338954.6,16947.73,355902.33,null,2.4257534515683536]
[null,"2010-04-30",113107,206508,134204,356390,810209,108584,918793,769581.92610837449,null,311440.7,15572.035000000002,327012.73499999999,null,2.3533698958493909]
[null,"2010-05-31",119188,212984,145197,381363,858732,109896,968628,813388.53694581287,null,325026.40000000002,16251.32,341277.72,null,2.383362549848882]
[null,"2010-06-30",117715,202987,136514,372332,829548,111380,940928,787280.54679802957,null,317712,15885.6,333597.59999999998,null,2.3599706556582829]
[null,"2010-07-31",122252,211052,84882,383025,801211,103473,904684,786213.74876847281,null,328781.09999999998,16439.055,345220.15499999997,null,2.27742713564471]
[null,"2010-08-31",118771,217312,135095,373777,844955,111324,956279,805312.82758620696,null,323966.11,16198.3055,340164.4155,null,2.3674223137140777]
[null,"2010-09-30",115997,211995,138424,370783,837199,113486,950685,795160.54187192116,null,322640,16132,338772,null,2.3471849558756954]
[null,"2010-10-31",111756,211401,130119,362244,815520,110715,926235,777616.40394088672,null,317752.5,15887.625,333640.125,null,2.3307040900457845]
[null,"2010-11-30",110343,209761,133725,360129,813958,113670,927628,774006.630541872,null,306854.8,15342.74,322197.53999999998,null,2.402273557215465]
[null,"Total",1480790,2454199,1289835,4303633,9528457,1240474,10768931,9200429.2561576348,null,2707120.7,135356.08500000002,2842476.7349999999]
[null,"Média Mensal",123399.16666666667,204516.58333333334,107486.25,358636.08333333331,794038.08333333337,103372.83333333333,897410.91666666663,766702.43801313627,null,306854.8,15342.74,322197.53999999998,null,2.3796036369897062]
[]
[null,"2011-10-31",115997,211995,138424,370783,837199,113486,950685,795160.54187192116,null,322640,16132,338772,null,2.3471849558756954]
[null,"2011-11-30",111756,211401,130119,362244,815520,110715,926235,777616.40394088672,null,317752.5,15887.625,333640.125,null,2.3307040900457845]
[null,"2011-12-31",110343,209761,133725,360129,813958,113670,927628,774006.630541872,null,306854.8,15342.74,322197.53999999998,null,2.402273557215465]
[null,"2012-01-31",114494,220687,1731,332682,669594,78636,748230,698068.16748768475,null,303107,8465,311572,null,2.2404714399486627]
[null,"2012-02-29",114801,232993,62058,344221,754073,78039,832112,753574.6600985222,null,293581,8624,302205,null,2.4935876643289232]
[null,"2012-03-31",126574,241310,176186,399739,943809,92003,1035812,886509.55172413797,null,327754,10898,338652,null,2.6177596816913469]
[null,"2012-04-30",109670,213877,153926,360309,837782,83876,921658,788128.31034482748,null,299461,9896,309357,null,2.547633673538428]
[null,"2012-05-31",121952,226312,175312,404086,927662,91437,1019099,868811.20197044336,null,325409,9087,334496,null,2.5973739655195978]
[null,"2012-06-30",110235,209395,147748,368096,835474,81012,916486,788358.83251231525,null,307422,8466,315888,null,2.495690980703019]
[null,"2012-07-31",115559,218969,96048,384786,815362,81057,896419,795752.24137931038,null,307422,8466,315888,null,2.5190961397055616]
[null,"2012-08-31",122395,229825,174809,404320,931349,91555,1022904,873220.66502463061,null,326873,10839,337712,null,2.5856962886264943]
[null,"2012-09-30",105244,204655,148785,354280,812964,83118,896082,764692.22660098516,null,297893,8465,306358,null,2.4960739611858842]
[null,"Total",1379020,2631180,1538871,4445675,9994746,1098604,11093350,9563899.4334975369,null,3736169.3,130568.36499999999,3866737.665]
[null,"Média Mensal",114918.33333333333,219265,128239.25,370472.91666666669,832895.5,91550.333333333328,924445.83333333337,796991.61945812812,null,311347.44166666665,10880.697083333333,322228.13874999998,null,2.4733768520336219]
[]
[null,"TRANSPORTES E TURISMO TIQUIM"]
[]
[null,"2009-12-31",26333,51147,12135,81395,171010,25183,196193,171655.63546798029,null,73150,3657.5,76807.5,null,2.2348811700417315]
[null,"2010-01-31",24181,43253,418,73091,140943,17960,158903,146483.77339901475,null,73150,3657.5,76807.5,null,1.9071545539044332]
[null,"2010-02-28",25501,45322,9408,76093,156324,20459,176783,157578.53201970441,null,73150,3657.5,76807.5,null,2.0516034504404441]
[null,"2010-03-31",34571,46237,32265,92732,205805,30216,236021,195583.83743842362,null,73150,3657.5,76807.5,null,2.5464158765540295]
[null,"2010-04-30",31050,39737,32584,82896,186267,26368,212635,175019.44827586209,null,73150,3657.5,76807.5,null,2.2786765390861841]
[null,"2010-05-31",32730,40469,36244,89361,198804,26952,225756,185796.76354679803,null,73150,3657.5,76807.5,null,2.4189924622829544]
[null,"2010-06-30",32333,38824,33492,89892,194541,27731,222272,182711.30541871922,null,73150,3657.5,76807.5,null,2.3788211492200531]
[null,"2010-07-31",32495,38599,23080,89956,184130,25252,209382,177553.31527093597,null,73150,3657.5,76807.5,null,2.3116663772539918]
[null,"2010-08-31",33117,40436,33136,91415,198104,26670,224774,186669.33990147786,null,73150,3657.5,76807.5,null,2.4303530241379794]
[null,"2010-09-30",29297,43597,26291,86025,185210,25570,210780,177668.84729064038,null,73150,3657.5,76807.5,null,2.3131705535350111]
[null,"2010-10-31",29847,46984,24768,87533,189132,27719,216851,182814.08866995075,null,73150,3657.5,76807.5,null,2.3801593421208964]
[null,"2010-11-30",32996,41329,34745,87144,196214,27523,223737,184081.72413793104,null,73150,3657.5,76807.5,null,2.3966634005524337]
[null,"Total",364451,515934,298566,1027533,2206484,307603,2514087,2123616.6108374381,null,877800,43890,921690]
[null,"Média Mensal",30370.916666666668,42994.5,24880.5,85627.75,183873.66666666666,25633.583333333332,209507.25,176968.05090311985,null,73150,3657.5,76807.5,null,2.3040464915941783]

{"sheet":"apura","index":2,"n_rows":574,"n_cols":17,"rows_kept":574,"cut":false,"hidden":false,"merged":[[6,8,6,10],[427,9,428,9],[432,9,433,9],[436,9,437,9],[361,9,365,9],[394,9,398,9],[377,9,382,9],[500,9,507,9],[539,2,539,7],[437,5,437,6],[488,9,491,9],[494,9,497,9],[519,2,519,7],[400,9,405,9],[407,9,411,9],[413,9,418,9],[467,2,467,7],[422,9,424,9],[427,5,427,6],[428,5,428,6],[432,5,432,6],[433,5,433,6],[436,5,436,6],[442,9,443,9],[448,9,449,9],[512,9,513,9],[469,9,473,9],[476,9,485,9],[342,9,347,9],[349,9,354,9],[374,9,375,9],[367,9,372,9],[386,2,386,7],[47,9,51,9],[53,9,57,9],[241,9,242,9],[150,9,155,9],[184,9,193,9],[196,9,205,9],[207,9,216,9],[218,9,227,9],[229,9,238,9],[160,9,169,9],[172,9,181,9],[24,8,29,8],[31,8,36,8],[38,8,43,8],[24,9,29,9],[10,9,15,9],[31,9,36,9],[38,9,43,9],[17,9,22,9],[10,8,15,8],[17,8,22,8],[109,9,113,9],[115,9,120,9],[124,9,128,9],[103,9,107,9],[47,8,51,8],[53,8,57,8],[59,8,63,8],[68,8,69,8],[71,8,72,8],[91,9,95,9],[97,9,101,9],[68,9,69,9],[84,9,89,9],[59,9,63,9],[1,1,1,7],[2,1,2,7],[4,1,4,7],[8,2,8,7],[66,2,66,7],[6,1,6,7],[336,9,340,9],[77,2,77,7],[276,9,280,9],[285,9,289,9],[291,9,295,9],[300,9,304,9],[312,9,316,9],[318,9,322,9],[324,9,328,9],[330,9,334,9],[306,9,310,9],[257,2,257,7],[270,9,274,9],[132,9,136,9],[144,9,148,9],[138,9,142,9],[537,3,537,7],[541,3,541,7],[543,3,543,7],[545,3,545,7],[565,3,565,6],[548,2,548,7]]}
[null,null,null,null,null,null,null,null,null,null,null,2.587363370599427,2.0726176778500012,null,2.765770148036153,2.2486473515662149]
[null,"PREFEITURA MUNICIPAL DE CHAPECO"]
[null,"CONTROLADORIA GERAL DO MUNICIPIO"]
[]
[null,"SISTEMA DE TRANSPORTE COLETIVO URBANO DE CHAPECÓ"]
[]
[null,"Discriminação",null,null,null,null,null,null,"Referência",null,null,"Empresa  NOV/2010","Calculo PMC NOV/2010",null,"Empresa  SET/2012","Calculo PMC SET/2012"]
[]
[null,"FR","FROTA"]
[]
[null,null,"FR_01","FROTA TOTAL",null,null,null,null,"FR_01","(IE)",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1]
[null,null,null,"Pesado",null,null,null,null,null,null,null,70,70,null,66,66]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,74,74,null,69,69]
[]
[null,null,"FR_02","FROTA COMPLEMENTAR",null,null,null,null,"FR_02","(IE)",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Pesado",null,null,null,null,null,null,null,3,3,null,10,10]
[null,null,null,"Articulado",null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,3,3,null,10,10]
[]
[null,null,"FR_03","FROTA OPERANTE",null,null,null,null,"FR_03","( FS)",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1]
[null,null,null,"Pesado",null,null,null,null,null,null,null,67,67,null,56,56]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,71,71,null,59,59]
[]
[null,null,"FR_04","FROTA RESERVA (5%)",null,null,null,null,"FR_04","(IE)",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Pesado",null,null,null,null,null,null,null,3,3,null,10,10]
[null,null,null,"Articulado",null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,3,3,null,10,10]
[]
[null,null,"FR_05","FROTA BASE",null,null,null,null,"FR_05","( FS)",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1]
[null,null,null,"Pesado",null,null,null,null,null,null,null,70,70,null,66,66]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,74,74,null,69,69]
[]
[null,null,null,"VALOR DA FROTA"]
[]
[null,null,"FR_11","Valor - Onibus com Rodagem",null,null,null,null,"FR_11","(IE)",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Micro",null,null,null,null,null,null,null,182750.89,182750.89,null,185501.77000000002,185501.77000000002]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,218354,218354]
[null,null,null,"Pesado",null,null,null,null,null,null,null,237994.54828571429,237994.54828571429,null,228656.41999999998,228656.41999999998]
[null,null,null,"Articulado",null,null,null,null,null,null,null,314282.05499999999,314282.05499999999,null,318564.11,318564.11]
[]
[null,null,"FR_12","valor - Rodagem",null,null,null,null,"FR_12","(IE)",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Micro",null,null,null,null,null,null,null,4554,4554,null,4428,4428]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,8850,8850]
[null,null,null,"Pesado",null,null,null,null,null,null,null,7860,7860,null,8534,8534]
[null,null,null,"Articulado",null,null,null,null,null,null,null,13500,13500,null,14190,14190]
[]
[null,null,"FR_13","Onibus sem rodagem",null,null,null,null,"FR_13","(IE)",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Micro",null,null,null,null,null,null,null,178196.89,178196.89,null,181073.77,181073.77]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,209504,209504]
[null,null,null,"Pesado",null,null,null,null,null,null,null,230134.54828571429,230134.54828571429,null,220122.42,220122.42]
[null,null,null,"Articulado",null,null,null,null,null,null,null,300782.05499999999,300782.05499999999,null,304374.11,304374.11]
[]
[]
[null,"KM","QUILOMETRAGEM "]
[]
[null,null,null,"MÉDIA PERCURSO TOTAL (MÉDIA MÊS)",null,null,null,null,"KM_01","D_PASS",null,"KM","KM",null,"KM","KM"]
[null,null,null,null,null,null,null,null,null,null,null,408876,408876,null,306358,306358]
[]
[null,null,"KM_02","PMM - PERCURSO MÉDIO MENSAL - KM/VEICULO/MÊS",null,null,null,null,"KM_02",null,null,"KM (média)","KM (média)",null,"KM (média)","KM (média)"]
[null,null,null,"KM_01 / ",null,null,null,null,null,null,null,5759,5759,null,5193,5193]
[]
[null,null,null,"MÉDIA DIA (30 dias)",null,null,null,null,null,null,null,192,192,null,173,173]
[null,null,null,"VELOCIDADE MÉDIA - (6 horas dia)",null,null,null,null,null,null,null,19.2,32,null,28.833333333333332,28.833333333333332]
[]
[null,"CA","CAPITAL - REMUNERAÇÃO E DEPRECIAÇÃO"]
[]
[null,null,"CA_01","REMUNERAÇÃO - TAXA ANUAL",null,null,null,null,"CA_01",null,null,0.12,0.12,null,0.12,0.12]
[null,null,"CA_02","REMUNERAÇÃO - TAXA MENSAL",null,null,null,null,"CA_02",null,null,9.4887929345830457E-3,9.4887929345830457E-3,null,9.4887929345830457E-3,9.4887929345830457E-3]
[]
[null,null,"CA_11","VEICULOS"]
[]
[null,null,null,"FROTA BASE",null,null,null,null,null,"FR_05",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1]
[null,null,null,"Pesado",null,null,null,null,null,null,null,70,70,null,66,66]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,74,74,null,69,69]
[]
[null,null,null,"Valor veiculo sem rodagem",null,null,null,null,null,"FR_13",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Micro",null,null,null,null,null,null,null,178196.89,178196.89,null,181073.77,181073.77]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,209504,209504]
[null,null,null,"Pesado",null,null,null,null,null,null,null,230134.54828571429,230134.54828571429,null,220122.42,220122.42]
[null,null,null,"Articulado",null,null,null,null,null,null,null,300782.05499999999,300782.05499999999,null,304374.11,304374.11]
[]
[null,null,null,"Vida útil do veiculo (anos)",null,null,null,null,null,"(IE)",null,"Anos","Anos",null,"Anos","Anos"]
[null,null,null,"Micro",null,null,null,null,null,null,null,null,10,null,null,10]
[null,null,null,"Leve",null,null,null,null,null,null,null,null,10,null,null,10]
[null,null,null,"Pesado",null,null,null,null,null,null,null,null,12,null,null,12]
[null,null,null,"Articulado",null,null,null,null,null,null,null,null,15,null,null,15]
[]
[null,null,null,"Valor residual do veiculo (%)",null,null,null,null,null,"(IE)",null,"%","%",null,"%","%"]
[null,null,null,"Micro",null,null,null,null,null,null,null,null,0.1,null,null,0.1]
[null,null,null,"Leve",null,null,null,null,null,null,null,null,0.1,null,null,0.1]
[null,null,null,"Pesado",null,null,null,null,null,null,null,null,0.1,null,null,0.1]
[null,null,null,"Articulado",null,null,null,null,null,null,null,null,0.1,null,null,0.1]
[]
[null,null,null,"Coeficiente de Amortização/Depr Mês",null,null,null,null,null,"( FS)",null,"Coeficiente","Coeficiente",null,"Coeficiente","Coeficiente"]
[null,null,null,"Micro",null,null,null,null,null,null,null,null,-1.3544124941555838E-2,null,null,-1.3544124941555838E-2]
[null,null,null,"Leve",null,null,null,null,null,null,null,null,-1.3544124941555838E-2,null,null,-1.3544124941555838E-2]
[null,null,null,"Pesado",null,null,null,null,null,null,null,null,-1.2437682588054867E-2,null,null,-1.2437682588054867E-2]
[null,null,null,"Articulado",null,null,null,null,null,null,null,null,-1.1397765351821602E-2,null,null,-1.1397765351821602E-2]
[]
[null,null,null,"Remuneração/Depreciação do mês",null,null,null,null,null,"( FS)",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Micro",null,null,null,null,null,null,null,0,-4827.0418847133642,null,0,-2452.4857645185457]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,0,-2837.5483517557141]
[null,null,null,"Pesado",null,null,null,null,null,null,null,0,-200363.83248861707,null,0,-180695.64417131702]
[null,null,null,"Articulado",null,null,null,null,null,null,null,0,-6856.4865698573985,null,0,-3469.1846849495369]
[null,null,null,"TOTAL REMUNERAÇÃO/DEPRECIAÇÃO DE VEICULOS",null,null,null,null,null,null,"CA_11",0,-212047.36094318784,null,0,-189454.86297254084]
[]
[null,null,"CA_12","OUTROS EQUIPAMENTOS"]
[]
[null,null,null,"Valores de investimentos","Inferior","Valor em Uso","Superior","Calculo PMC",null,"(IE)",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Validadores",null,null,null,null,null,null,null,11980.44,11980.44,null,7952.11,11980.44]
[null,null,null,"Sistema Bilhetagem Eletronica",null,null,null,null,null,null,null,11980.44,11980.44,null,7952.11,11980.44]
[null,null,null,"Sistema de Monitoramento",null,null,null,null,null,null,null,13757.98,13757.98,null,11963.46,13757.98]
[null,null,null,"Maquinas Instalações e Equipamentos",null,null,null,null,null,null,null,1765.3684270000001,1765.3684270000001,null,1559.5389599999999,1559.5389599999999]
[null,null,null,null,null,null,null,null,null,null,null,17653684.27,17653684.27,null,15595389.599999998,15595389.599999998]
[]
[]
[null,null,null,"Vida útil (anos)",null,null,null,null,null,"(IE)",null,"Anos","Anos",null,"Anos","Anos"]
[null,null,null,"Validadores",null,null,null,null,null,null,null,null,5,null,null,5]
[null,null,null,"Sistema Bilhetagem Eletronica",null,null,null,null,null,null,null,null,5,null,null,5]
[null,null,null,"Sistema de Monitoramento",null,null,null,null,null,null,null,null,5,null,null,5]
[null,null,null,"Maquinas Instalações e Equipamentos",null,null,null,null,null,null,null,null,5,null,null,5]
[]
[null,null,null,"Valor residual (%)",null,null,null,null,null,"(IE)",null,"%","%",null,"%","%"]
[null,null,null,"Validadores",null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,"Sistema Bilhetagem Eletronica",null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,"Sistema de Monitoramento",null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,"Maquinas Instalações e Equipamentos",null,null,null,null,null,null,null,null,0,null,null,0]
[]
[null,null,null,"Coeficiente de Amortização e Depr Mês",null,null,null,null,null,"( FS)",null,"Coeficiente","Coeficiente",null,"Coeficiente","Coeficiente"]
[null,null,null,"Validadores",null,null,null,null,null,null,null,null,-2.1935695870223159E-2,null,null,-2.1935695870223159E-2]
[null,null,null,"Sistema Bilhetagem Eletronica",null,null,null,null,null,null,null,null,-2.1935695870223159E-2,null,null,-2.1935695870223159E-2]
[null,null,null,"Sistema de Monitoramento",null,null,null,null,null,null,null,null,-2.1935695870223159E-2,null,null,-2.1935695870223159E-2]
[null,null,null,"Maquinas Instalações e Equipamentos",null,null,null,null,null,null,null,null,-2.1935695870223159E-2,null,null,-2.1935695870223159E-2]
[]
[null,null,null,"Remuneração e Depreciação do mês",null,null,null,null,null,"( FS)",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Validadores",null,null,null,null,null,null,null,0,-19447.147329127769,null,0,-18133.150887970485]
[null,null,null,"Sistema Bilhetagem Eletronica",null,null,null,null,null,null,null,0,-19447.147329127769,null,0,-18133.150887970485]
[null,null,null,"Sistema de Monitoramento",null,null,null,null,null,null,null,0,-22332.524015077346,null,0,-20823.569689734282]
[null,null,null,"Maquinas Instalações e Equipamentos",null,null,null,null,null,null,null,0,-2865.6192836039027,null,0,-2360.4604903783638]
[null,null,null,"TOTAL REMUNERAÇÃO/DEPRECIAÇÃO DE OUTROS EQUIPAMENTOS",null,null,null,null,null,null,"CA_12",0,-64092.437956936788,null,0,-59450.331956053618]
[]
[]
[null,null,"CA_13","OUTROS INVESTIMENTOS"]
[]
[null,null,null,"Valores de investimentos",null,null,"TOT ANOS",null,null,"(IE)",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2006,20,null,null,null,null,12056.5,12056.5,null,12056.5,12056.5]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2007,20,null,null,null,null,138339.46,138339.46,null,138339.46,138339.46]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2008,20,null,null,null,null,1257183.47,1257183.47,null,1257183.47,1257183.47]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2006,20,null,null,null,null,2400,2400,null,2400,2400]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2008,20,null,null,null,null,262227.21999999997,262227.21999999997,null,262227.21999999997,262227.21999999997]
[null,null,null,"Outorga - Minima","AVC",2010,20,null,null,null,null,4000000,4000000,null,4000000,4000000]
[null,null,null,"Outorga - Minima","TTT",2010,20,null,null,null,null,1000000,1000000,null,1000000,1000000]
[null,null,null,"Outorga - Final","AVC",2010,20,null,null,null,null,0,0,null,0,0]
[null,null,null,"Outorga - Final","TTT",2010,20,null,null,null,null,0,0,null,0,0]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,6672206.6500000004]
[]
[null,null,null,"Valores de investimentos Atualização",null,null,null,null,null,"(IE)",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2006,0.23389733197886109,null,null,null,null,2820,2820,null,2820,2820]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2007,0.1775986098988096,null,null,null,null,24569,24569,null,24569,24569]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2008,9.7924176071311209E-2,null,null,null,null,123109,123109,null,123109,123109]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2006,0.23389733197886087,null,null,null,null,561,561,null,561,561]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2008,9.7924176071311431E-2,null,null,null,null,25678,25678,null,25678,25678]
[null,null,null,"Outorga - Minima","AVC",2010,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Outorga - Minima","TTT",2010,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Outorga - Final","AVC",2010,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Outorga - Final","TTT",2010,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,176737]
[]
[null,null,null,"Valores de investimentos",null,null,null,null,null,"(IE)",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2010,4,null,null,null,null,11901.2,11901.2,null,11901.2,11901.2]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2010,3,null,null,null,null,138472.19099999999,138472.19099999999,null,138472.19099999999,138472.19099999999]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2010,2,null,null,null,null,1242263.223,1242263.223,null,1242263.223,1242263.223]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2010,4,null,null,null,null,2368.8000000000002,2368.8000000000002]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2010,2,null,null,null,null,259114.69799999997,259114.69799999997]
[null,null,null,"Outorga - Minima","AVC",2010,0,null,null,null,null,4000000,4000000,null,4000000,4000000]
[null,null,null,"Outorga - Minima","TTT",2010,0,null,null,null,null,1000000,1000000]
[null,null,null,"Outorga - Final","AVC",2010,0,null,null,null,null,0,0,null,0,0]
[null,null,null,"Outorga - Final","TTT",2010,0,null,null,null,null,0,0,null,0,0]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,6654120.1119999997]
[]
[null,null,null,"Vida útil (anos)",null,null,null,null,null,"(IE)",null,"Anos","Anos",null,"Anos","Anos"]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2010,0,null,null,null,null,null,10,null,null,10]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2010,0,null,null,null,null,null,10,null,null,10]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2010,0,null,null,null,null,null,10,null,null,20]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2010,0,null,null,null,null,null,10,null,null,20]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2010,0,null,null,null,null,null,10,null,null,10]
[null,null,null,"Outorga - Minima","AVC",2010,0,null,null,null,null,null,10,null,null,10]
[null,null,null,"Outorga - Minima","TTT",2010,0,null,null,null,null,null,10,null,null,10]
[null,null,null,"Outorga - Final","AVC",2010,0,null,null,null,null,null,10,null,null,10]
[null,null,null,"Outorga - Final","TTT",2010,0,null,null,null,null,null,10,null,null,10]
[]
[null,null,null,"Valor residual (%)",null,null,null,null,null,"(IE)",null,"%","%",null,"%","%"]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,"Outorga - Minima","AVC",null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,"Outorga - Minima","TTT",null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,"Outorga - Final","AVC",null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,"Outorga - Final","TTT",null,null,null,null,null,null,null,0,null,null,0]
[]
[null,null,null,"Coeficiente de Amortização e Depr Mês",null,null,null,null,null,"( FS)",null,"Coeficiente","Coeficiente",null,"Coeficiente","Coeficiente"]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",null,null,null,null,null,null,null,-1.3994717386775036E-2,null,null,-1.3994717386775036E-2]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",null,null,null,null,null,null,null,-1.3994717386775036E-2,null,null,-1.3994717386775036E-2]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",null,null,null,null,null,null,null,-1.3994717386775036E-2,null,null,-1.0586233517757716E-2]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",null,null,null,null,null,null,null,-1.3994717386775036E-2,null,null,-1.0586233517757716E-2]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",null,null,null,null,null,null,null,-1.3994717386775036E-2,null,null,-1.3994717386775036E-2]
[null,null,null,"Outorga - Minima","AVC",null,null,null,null,null,null,null,-1.3994717386775036E-2,null,null,-1.3994717386775036E-2]
[null,null,null,"Outorga - Minima","TTT",null,null,null,null,null,null,null,-1.3994717386775036E-2,null,null,-1.3994717386775036E-2]
[null,null,null,"Outorga - Final","AVC",null,null,null,null,null,null,null,-1.3994717386775036E-2,null,null,-1.3994717386775036E-2]
[null,null,null,"Outorga - Final","TTT",null,null,null,null,null,null,null,-1.3994717386775036E-2,null,null,-1.3994717386775036E-2]
[]
[null,null,null,"Remuneração e Depreciação do mês",null,null,null,null,null,"( FS)",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",null,null,null,null,null,null,0,-166.55393056348706,null,0,-166.55393056348706]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",null,null,null,null,null,null,0,-1937.8791789725335,null,0,-1937.8791789725335]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",null,null,null,null,null,null,0,-17385.122725869292,null,0,-13150.888569200328]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",null,null,null,null,null,null,0,-33.150686545792709,null,0,0]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",null,null,null,null,null,null,0,-3626.2369692695625,null,0,0]
[null,null,null,"Outorga - Minima","AVC",null,null,null,null,null,null,0,-55978.869547100141,null,0,-55978.869547100141]
[null,null,null,"Outorga - Minima","TTT",null,null,null,null,null,null,0,-13994.717386775035,null,0,0]
[null,null,null,"Outorga - Final","AVC",null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Outorga - Final","TTT",null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Total",null,null,null,null,null,null,"CA_13",0,-93122.530425095843,null,0,-71234.19122583649]
[]
[null,null,null,"MÉDIA PERCURSO TOTAL (MÉDIA MÊS)",null,null,null,null,null,"KM_01",null,"KM","KM",null,"KM","KM"]
[null,null,null,null,null,null,null,null,null,null,null,408876,408876,null,306358,306358]
[]
[null,null,"CA_21","REMUNERAÇÃO/DEPRECIAÇÃO/KM"]
[null,null,null,"VEICULOS",null,null,null,null,null,"CA_11",null,0,-212047.36094318784,null,0,-189454.86297254084]
[null,null,null,"OUTROS EQUIPAMENTOS",null,null,null,null,null,"CA_12",null,0,-64092.437956936788,null,0,-59450.331956053618]
[null,null,null,"OUTROS INVESTIMENTOS",null,null,null,null,null,"CA_13",null,0,-93122.530425095843,null,0,-71234.19122583649]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,0,-369262.32932522043,null,0,-320139.38615443092]
[]
[null,null,null,"REMUNERAÇÃO/DEPRECIAÇÃO POR KM",null,null,null,null,null,null,null,"Custo KM","Custo KM",null,"Custo KM","Custo KM"]
[null,null,null,"VEICULOS",null,null,null,null,null,null,null,null,0.51861043676612917,null,null,0.61841003979834319]
[null,null,null,"OUTROS EQUIPAMENTOS",null,null,null,null,null,null,null,null,0.15675275134010505,null,null,0.19405509879309049]
[null,null,null,"OUTROS INVESTIMENTOS",null,null,null,null,null,null,null,null,0.22775249812925152,null,null,0.23251944204439412]
[null,null,null,"Total",null,null,null,null,null,null,"CA_21",0,0.90311568623548566,null,0,1.0449845806358278]
[]
[]
[null,"GA","GASTOS VARIÁVEIS"]
[]
[null,null,"VA_01","Valor combustível",null,null,null,null,null,"( IE  )",null,1.7549999999999999,1.7549999999999999,null,1.855,1.855]
[]
[null,null,"VA_11","COMBUSTÍVEL"]
[]
[null,null,null,"FROTA BASE"]
[null,null,null,"Micro"]
[null,null,null,"Leve"]
[null,null,null,"Pesado"]
[null,null,null,"Articulado"]
[null,null,null,"Total"]
[]
[null,null,null,"Consumo (L-KM)","Inferior","Valor em Uso","Superior","Calculo PMC",null,"( IE  )",null,"Empresa","Calculo PMC",null,"Empresa","Calculo PMC"]
[null,null,null,"Micro",0.28000000000000003,0.3,0.33,0.3,null,null,null,0.3,0.3,null,0.3,0.3,0.30499999999999999]
[null,null,null,"Leve",0.33,0.37,0.39,0.36,null,null,null,0.37,0.36,null,0.39,0.36,0.37]
[null,null,null,"Pesado",0.43,0.47499999999999998,0.53,0.48,null,null,null,0.47499999999999998,0.48,null,0.5,0.48,0.47499999999999998]
[null,null,null,"Articulado",0.53,0.59,0.65,0.59,null,null,null,0.59,0.59,null,0.65,0.59,0.59]
[]
[null,null,null,"Custo Combustível",null,null,null,null,null,"( IE  )",null,"Empresa","Calculo PMC",null,"Empresa","Calculo PMC"]
[null,null,null,"Micro",null,null,null,null,null,null,null,1.4229729729729728E-2,1.4229729729729728E-2,null,8.0652173913043478E-3,8.0652173913043478E-3]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1.0484782608695653E-2,9.678260869565216E-3]
[null,null,null,"Pesado",null,null,null,null,null,null,null,0.78856418918918914,0.79686486486486485,null,0.88717391304347826,0.85168695652173909]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2.7985135135135134E-2,2.7985135135135134E-2,null,1.7474637681159422E-2,1.5861594202898552E-2]
[null,null,null,"Total",null,null,null,null,null,null,"VA_11",0.83077905405405394,0.83907972972972966,null,0.92319855072463763,0.88529202898550718]
[]
[null,null,"VA_12","LUBRIFICANTES"]
[]
[null,null,null,"Consumo (L-KM)","Inferior","Valor em Uso","Superior","Calculo PMC",null,"( IE  )",null,"Empresa","Calculo PMC",null,"Empresa","Calculo PMC"]
[null,null,null,"Micro",0.04,0.06,0.06,0.05,null,null,null,0.06,0.05,null,0.06,0.05]
[null,null,null,"Leve",0.04,0.06,0.06,0.05,null,null,null,0.06,0.05,null,0.06,0.05]
[null,null,null,"Pesado",0.04,0.06,0.06,0.05,null,null,null,0.06,0.05,null,0.06,0.05]
[null,null,null,"Articulado",0.04,0.06,0.06,0.05,null,null,null,0.06,0.05,null,0.06,0.05]
[]
[null,null,null,"Custo Lubrificantes",null,null,null,null,null,"( FS)",null,"Empresa","Calculo PMC",null,"Empresa","Calculo PMC"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2.8459459459459456E-3,2.3716216216216213E-3,null,1.6130434782608695E-3,1.3442028985507246E-3]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1.6130434782608695E-3,1.3442028985507246E-3]
[null,null,null,"Pesado",null,null,null,null,null,null,null,9.9608108108108107E-2,8.3006756756756755E-2,null,0.10646086956521739,8.8717391304347831E-2]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2.8459459459459456E-3,2.3716216216216213E-3,null,1.6130434782608695E-3,1.3442028985507246E-3]
[null,null,null,"Total",null,null,null,null,null,null,"VA_12",0.1053,8.7749999999999995E-2,null,0.1113,9.2749999999999999E-2]
[]
[null,null,"VA_13","RODAGEM"]
[]
[null,null,null,"Vida Util","Inferior","Valor em Uso","Superior","Calculo PMC",null,"( IE  )",null,"Empresa","Calculo PMC",null,"Empresa","Calculo PMC"]
[null,null,null,"Micro",85000,100000,125000,105000,null,null,null,100000,105000,null,105000,105000]
[null,null,null,"Leve",85000,100000,125000,105000,null,null,null,100000,105000,null,105000,105000]
[null,null,null,"Pesado",105000,100000,125000,115000,null,null,null,100000,115000,null,105000,115000]
[null,null,null,"Articulado",105000,100000,125000,115000,null,null,null,100000,115000,null,105000,115000]
[]
[null,null,null,"Valor por veiculo",null,null,null,null,null,"( FS  )",null,"Valor Indiv","Valor Indiv",null,"Valor Indiv","Valor Indiv"]
[null,null,null,"Micro",null,null,null,null,null,null,null,8004,8004,null,7878,7878]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,14625,14625]
[null,null,null,"Pesado",null,null,null,null,null,null,null,13410,13410,null,14454,14454]
[null,null,null,"Articulado",null,null,null,null,null,null,null,23400,23400,null,24090,24090]
[]
[null,null,null,"Pneus","Quantidade",null,null,null,null,"( IE  )",null,"Valor Indiv","Valor Indiv",null,"Valor Indiv","Valor Indiv"]
[null,null,null,"Micro",6,null,null,null,null,null,null,759,759,null,738,738]
[null,null,null,"Leve",6,null,null,null,null,null,null,0,0,null,1475,1475]
[null,null,null,"Pesado",6,null,null,null,null,null,null,1310,1310,null,1419,1419]
[null,null,null,"Articulado",10,null,null,null,null,null,null,1350,1350,null,1419,1419]
[]
[null,null,null,"Camara de Ar","Quantidade",null,null,null,null,"( IE  )",null,"Valor Indiv","Valor Indiv",null,"Valor Indiv","Valor Indiv"]
[null,null,null,"Micro",12,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Leve",12,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Pesado",12,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Articulado",20,null,null,null,null,null,null,0,0,null,0,0]
[]
[null,null,null,"Protetor","Quantidade",null,null,null,null,"( IE  )",null,"Valor Indiv","Valor Indiv",null,"Valor Indiv","Valor Indiv"]
[null,null,null,"Micro",12,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Leve",12,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Pesado",12,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Articulado",20,null,null,null,null,null,null,0,0,null,0,0]
[]
[null,null,null,"Recapagem","Quantidade",null,null,null,null,"( IE  )",null,"Valor Indiv","Valor Indiv",null,"Valor Indiv","Valor Indiv"]
[null,null,null,"Micro",15,null,null,null,null,null,null,230,230,null,230,230]
[null,null,null,"Leve",15,null,null,null,null,null,null,0,0,null,385,385]
[null,null,null,"Pesado",15,null,null,null,null,null,null,370,370,null,396,396]
[null,null,null,"Articulado",25,null,null,null,null,null,null,396,396,null,396,396]
[]
[null,null,null,"Custo Rodagem",null,null,null,null,null,"( FS  )",null,"Custo KM","Custo KM",null,"Custo KM","Custo KM"]
[null,null,null,"Micro",null,null,null,null,null,null,null,8.004E-2,7.6228571428571423E-2,null,7.5028571428571431E-2,7.5028571428571431E-2]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,0.13928571428571429,0.13928571428571429]
[null,null,null,"Pesado",null,null,null,null,null,null,null,0.1341,0.11660869565217391,null,0.13765714285714287,0.12568695652173914]
[null,null,null,"Articulado",null,null,null,null,null,null,null,0.23400000000000001,0.20347826086956522,null,0.22942857142857143,0.20947826086956522]
[]
[null,null,null,"FROTA OPERANTE",null,null,null,null,null,"FR_03",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1]
[null,null,null,"Pesado",null,null,null,null,null,null,null,67,67,null,56,56]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,71,71,null,59,59]
[]
[null,null,null,"Custo Rodagem Frota operante",null,null,null,null,null,"( FS)",null,"Custo KM","Custo KM",null,"Custo KM","Custo KM"]
[null,null,null,"Micro",null,null,null,null,null,null,null,0.16008,0.15245714285714285,null,7.5028571428571431E-2,7.5028571428571431E-2]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,0.13928571428571429,0.13928571428571429]
[null,null,null,"Pesado",null,null,null,null,null,null,null,8.9847000000000001,7.8127826086956524,null,7.7088000000000001,7.0384695652173921]
[null,null,null,"Articulado",null,null,null,null,null,null,null,0.46800000000000003,0.40695652173913044,null,0.22942857142857143,0.20947826086956522]
[null,null,null,"Total",null,null,null,null,null,null,null,9.6127800000000008,8.3721962732919266,null,8.1525428571428566,7.4622621118012429]
[]
[null,null,null,"CUSTO RODAGEM POR KM",null,null,null,null,null,null,"VA_13",0.1353912676056338,0.11791825737030882,null,0.13817869249394674,0.12647901884408885]
[]
[]
[null,null,"VA_14","PEÇAS E ACESSÓRIOS"]
[]
[null,null,null,"Indice de consumo","Inferior","Valor em Uso","Superior","Calculo PMC",null,"( IE  )",null,"Empresa","Calculo PMC",null,"Empresa","Calculo PMC"]
[null,null,null,"Micro",3.3300000000000001E-3,8.3000000000000001E-3,8.3000000000000001E-3,5.8149999999999999E-3,null,null,null,8.3000000000000001E-3,5.8149999999999999E-3,null,8.3000000000000001E-3,5.8149999999999999E-3]
[null,null,null,"Leve",3.3300000000000001E-3,8.3000000000000001E-3,8.3000000000000001E-3,5.8149999999999999E-3,null,null,null,8.3000000000000001E-3,5.8149999999999999E-3,null,8.3000000000000001E-3,5.8149999999999999E-3]
[null,null,null,"Pesado",3.3300000000000001E-3,8.3000000000000001E-3,8.3000000000000001E-3,5.8149999999999999E-3,null,null,null,8.3000000000000001E-3,5.8149999999999999E-3,null,8.3000000000000001E-3,5.8149999999999999E-3]
[null,null,null,"Articulado",3.3300000000000001E-3,8.3000000000000001E-3,8.3000000000000001E-3,5.8149999999999999E-3,null,null,null,8.3000000000000001E-3,5.8149999999999999E-3,null,8.3000000000000001E-3,5.8149999999999999E-3]
[]
[null,null,null,"FROTA BASE",null,null,null,null,null,"FR_03",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1]
[null,null,null,"Pesado",null,null,null,null,null,null,null,67,67,null,56,56]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,71,71,null,59,59]
[]
[null,null,null,"PMM - PERCURSO MÉDIO MENSAL - KM/VEICULO/MÊS",null,null,null,null,null,"KM_02",null,"KM (média)","KM (média)",null,"KM (média)","KM (média)"]
[null,null,null,null,null,null,null,null,null,null,null,5759,5759,null,5193,5193]
[]
[null,null,null,"Custo Peças e acessórios",null,null,null,null,null,"( FS)",null,"Empresa","Calculo PMC",null,"Empresa","Calculo PMC"]
[null,null,null,"Micro",null,null,null,null,null,null,null,7.4192868333459701E-3,5.1979702332417841E-3,null,5.0252285214451011E-3,3.5206872111088268E-3]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,5.9151928769823779E-3,4.1441983830906659E-3]
[null,null,null,"Pesado",null,null,null,null,null,null,null,0.32367896495549092,0.22677026279713006,null,0.34687993947523882,0.24302492145162816]
[null,null,null,"Articulado",null,null,null,null,null,null,null,1.2759164743976972E-2,8.9391015646055529E-3,null,8.6298769627954196E-3,6.0461125950187176E-3]
[null,null,null,"Total",null,null,null,null,null,null,null,0.34385741653281388,0.2409073345949774,null,0.36645023783646175,0.25673591964084636]
[]
[null,null,null,"Custo Peças e acessórios",null,null,null,null,null,null,"VA_14",0.34385741653281388,0.2409073345949774,null,0.36645023783646175,0.25673591964084636]
[]
[null,"CP","CUSTO DE PESSOAL"]
[]
[null,null,null,"FROTA OPERANTE",null,null,null,null,null,"FR_03",null,71,71,null,59,59]
[]
[null,null,"PE_01","ENCARGOS DE PESSOAL",null,null,null,null,null,null,null,0.82369999999999999,0.82369999999999999,null,0.82369999999999999,0.82369999999999999,0.63780000000000003]
[]
[null,null,"PE_02","PESSOAL DIRETO",null,null,null,null,null,null,null,4,0,null,4,0]
[]
[null,null,null,"Fatores de utilização","Inferior","Valor em Uso","Superior","Calculo PMC",null,"( IE  )",null,"Empresa","Calculo PMC",null,"Empresa","Calculo PMC"]
[null,null,null,"Motorista",2.2000000000000002,2.65,2.8,2,null,null,null,2.65,2,null,2.8,2,2]
[null,null,null,"Cobrador",2.2000000000000002,2.65,2.8,2,null,null,null,2.65,2,null,2.8,1.55,2]
[null,null,null,"Fiscal/Despachante",0.2,0.3,0.5,0.3,null,null,null,0.3,0.3,null,0.35,0.3,0.05]
[null,null,null,"Bilheteiro",0.08,0.08,0.08,0.08,null,null,null,0.08,0.08,null,0.08,0.08,0]
[]
[null,null,null,"Numero de Funcionários",null,null,null,null,null,"( FS)",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Motorista",null,null,null,null,null,null,null,188.15,142,null,165.2,118]
[null,null,null,"Cobrador",null,null,null,null,null,null,null,188.15,142,null,165.2,91]
[null,null,null,"Fiscal/Despachante",null,null,null,null,null,null,null,21.3,21,null,20.65,18]
[null,null,null,"Bilheteiro",null,null,null,null,null,null,null,5.68,6,null,4.72,5]
[null,null,null,"TOTAL",null,null,null,null,"BC TF",null,null,403.28,311,null,355.77,232]
[]
[null,null,null,"Salário com incidencia de encargos",null,null,null,null,null,"( IE  )",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Motorista",null,null,null,null,null,null,null,1405.92,1405.92,null,1560.45,1560.45]
[null,null,null,"Cobrador",null,null,null,null,null,null,null,766.69,766.69,null,736.78,736.78]
[null,null,null,"Fiscal/Despachante",null,null,null,null,null,null,null,1755.54,1755.54,null,1648.83,1648.83]
[null,null,null,"Bilheteiro",null,null,null,null,null,null,null,691.01,691.01,null,689.92,689.92]
[]
[null,null,null,"Custo Mensal Pessoal Direto",null,null,null,null,null,"( FS)",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Motorista",null,null,null,null,"BC P1",null,null,482412.14159760001,364084.63516800007,null,470124.94825800002,335803.53447000001]
[null,null,null,"Cobrador",null,null,null,null,"BC P2",null,null,263073.69184695004,198546.18252600002,null,221973.57132719998,122273.577426]
[null,null,null,"Fiscal/Despachante",null,null,null,null,"BC P3",null,null,68193.6177474,67233.144258,null,62093.95674614999,54125.482878000003]
[null,null,null,"Bilheteiro",null,null,null,null,"BC P4",null,null,7157.9072421600004,7561.1696219999994,null,5938.7375308799992,6291.0355200000004]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,820837.35843411006,637425.131574,null,760131.21386223007,518493.63029399997]
[]
[null,null,"PE_03","PESSOAL INDIRETO"]
[]
[null,null,null,"Fatores de utilização",null,null,null,null,null,"( IE  )",null,"Empresa","Calculo PMC",null,"Empresa","Calculo PMC"]
[null,null,null,"Manutenção",null,null,null,null,null,null,null,0.15,0.15,null,0.15,0.15]
[null,null,null,"Pessoal administrativo",null,null,null,null,null,null,null,0.13,0.13,null,0.13,0.13]
[]
[null,null,null,"Numero de Funcionários",null,null,null,null,null,null,null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Manutenção",null,null,null,null,null,"( FS  )",null,60,47,null,53,35]
[null,null,null,"Pessoal administrativo",null,null,null,null,null,null,null,52,40,null,46,30]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,112,87,null,99,65]
[]
[null,null,null,"Salário com incidencia de encargos",null,null,null,null,null,null,null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Manutenção",null,null,null,null,null,"( IE  )",null,2052.0933960852749,2034.3355262999999,null,2151.3147562138588,2222.115558402857]
[null,null,null,"Pessoal administrativo",null,null,null,null,null,null,null,2052.0933960852753,2071.6316776154999,null,2148.1969087410853,2246.8057312739998]
[]
[null,null,null,"Custo Mensal Pessoal Direto",null,null,null,null,null,null,null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Manutenção",null,null,null,null,"BC P5","( FS  )",null,123125.60376511651,95613.769736100003,null,114019.68207933451,77774.04454409999]
[null,null,null,"Pessoal administrativo",null,null,null,null,"BC P6",null,null,106708.85659643431,82865.267104619998,null,98817.057802089912,67404.171938219995]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,229834.46036155082,178479.03684071999,null,212836.73988142441,145178.21648231999]
[]
[null,null,null,"TOTAL DESPESAS DE PESSOAL",null,null,null,null,null,null,null,1050671.818795661,815904.16841471998,null,972967.95374365454,663671.8467763199]
[]
[null,null,null,"Honorários diretoria",null,null,null,null,"BC P8","( IE  )",null,5700,5700,null,6696.03,6696.03]
[null,null,null,"Benefícios sociais",null,null,null,null,"BC P9",null,null,12708.61,12708.61,null,51109.36,51109.36]
[]
[]
[null,null,"PE_11","CUSTO PESSOAL POR KM"]
[]
[null,null,null,"MÉDIA PERCURSO TOTAL (MÉDIA MÊS)",null,null,null,null,null,"KM_01",null,"KM","KM",null,"KM","KM"]
[null,null,null,null,null,null,null,null,null,null,null,408876,408876,null,306358,306358]
[null,null,null,"PESSOAL DIRETO"]
[null,null,null,"Motorista",null,null,null,null,"CP 51","BC P1",null,1.1798494937281718,0.89045244809673363,null,1.5345607043328393,1.0961147888091709]
[null,null,null,"Cobrador",null,null,null,null,"CP 52","BC P2",null,0.64340702767330449,0.48559020956475807,null,0.72455614453417239,0.39911991012475601]
[null,null,null,"Fiscal/Despachante",null,null,null,null,"CP 53","BC P3",null,0.16678312678513779,0.16443406866140345,null,0.2026842998914668,0.17667396600708976]
[null,null,null,"Bilheteiro",null,null,null,null,"CP 54","BC P4",null,1.7506303236580284E-2,1.8492573841458044E-2,null,1.9384959853765853E-2,2.0534915099328237E-2]
[]
[null,null,null,"PESSOAL INDIRETO"]
[null,null,null,"Manutenção",null,null,null,null,"CP 55","BC P5",null,0.30113189271347918,0.23384539502465296,null,0.37217791629183672,0.25386653700605172]
[null,null,null,"Pessoal administrativo",null,null,null,null,"CP 56","BC P6",null,0.26098097368501527,0.20266600902136589,null,0.3225541941195918,0.22001766540524484]
[null,null,null,"Honorários diretoria",null,null,null,null,"CP 58","BC P8",null,1.3940656825052094E-2,1.3940656825052094E-2,null,2.1856879859510767E-2,2.1856879859510767E-2]
[null,null,null,"Benefícios sociais",null,null,null,null,"CP 59","BC P9",null,3.1081819426916721E-2,3.1081819426916721E-2,null,0.16682887340954047,0.16682887340954047]
[]
[null,null,null,"TOTAL",null,null,null,null,null,null,"PE_11",2.6146812940736579,2.0405031804623412,null,3.3646039722927243,2.3550135357206927]
[]
[null,null,null,"Total de funcionários",null,null,null,null,null,null,null,515.28,398,null,454.77,297]
[]
[]
[null,"DA","DESPESAS ADMINISTRATIVAS"]
[]
[null,null,"DA_01","DESPESAS MENSAIS",null,null,null,null,null,"( IE  )",null,"Valor mês","Valor mês",null,"Valor mês","Valor mês"]
[null,null,null,"Serviços de Bilhetagem Eletrônica - SBE",null,null,null,null,null,null,null,19752.23,19752.23,null,14360.42,14360.42]
[null,null,null,"Serviços de Atendimento ao Passageiro - SAC",null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Serviço Especial de Atendimento a Pessoa Portadora de Dificuldade de Locomoção Severa",null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Serviço de Manutenção de Abrigos e Terminais",null,null,null,null,null,null,null,3591.2,3591.2,null,179.12,179.12]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,23343.43,23343.43,null,14539.54,14539.54]
[]
[null,null,null,"Despesas Administrativas Gerais",null,null,null,null,null,"( IE  )",null,"Valor mês","Valor mês",null,"Valor mês","Valor mês"]
[null,null,null,"Veículo de Apoio",null,null,null,null,null,null,null,2582.8000000000002,2582.8000000000002]
[null,null,null,"Treinamento",null,null,null,null,null,null,null,1371.26,1371.26]
[null,null,null,"Atualização Tecnológica",null,null,null,null,null,null,null,51503.85,51503.85]
[null,null,null,"Assessoria Técnica",null,null,null,null,null,null,null,11903.87,11903.87]
[null,null,null,"Manutenção e Segurança",null,null,null,null,null,null,null,19968.400000000001,19968.400000000001]
[null,null,null,"Serviço de Utilidade Pública",null,null,null,null,null,null,null,8853.52,8853.52]
[null,null,null,"Representação Viagens e Estadias",null,null,null,null,null,null,null,149.82,149.82]
[null,null,null,"Material de Consumo",null,null,null,null,null,null,null,6316.16,6316.16]
[null,null,null,"Outras Despesas Administrativas",null,null,null,null,null,null,null,56892.67,56892.67]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,159542.35,159542.35,null,151673.75,151673.75]
[]
[null,null,null,"Encargos Financeiros",null,null,null,null,null,"( IE  )",null,"Valor mês","Valor mês",null,"Valor mês","Valor mês"]
[null,null,null,"Juros Pagos",null,null,null,null,null,null,null,89568.055999999997,10000,null,0,{"$f":"+O490","v":0}]
[null,null,null,"Despesas Bancárias",null,null,null,null,null,null,null,368,368,null,16590.919999999998,16590.919999999998]
[null,null,null,"Seguro Garantia",null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,89936.055999999997,10368,null,16590.919999999998,16590.919999999998]
[]
[null,null,null,"Outros Custos Operacionais",null,null,null,null,null,"( IE  )",null,"Valor mês","Valor mês",null,"Valor mês","Valor mês"]
[null,null,null,"Higienizacão e Limpeza de Veículos",null,null,null,null,null,null,null,1712.72,1712.72]
[null,null,null,"Conserto de Pneus",null,null,null,null,null,null,null,1285,1285]
[null,null,null,"Vistoria do Poder Concedente",null,null,null,null,null,null,null,2800,2800,null,1692.56,1692.56]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,5797.72,5797.72,null,1692.56,1692.56]
[]
[null,null,null,"GRIS - Gerenciamento de Riscos",null,null,null,null,null,"( IE  )",null,"Valor mês","Valor mês",null,"Valor mês","Valor mês"]
[null,null,null,"Despesa Anual com o Seguro Responsabilidade cívil",null,null,null,null,null,null,null,14695,14695,null,11661.666666666666,11661.666666666666]
[null,null,null,"Despesa Anual com o Seguro Obrigatório",null,null,null,null,null,null,null,null,null,null,1904.15,1904.15]
[null,null,null,"Despesas Anual com Emplacamento",null,null,null,null,null,null,null,2120.8166666666666,2120.8166666666666,null,291.66666666666669,291.66666666666669]
[null,null,null,"Despesa Anual com o IPVA Por Veículo",null,null,null,null,null,null,null,373.33333333333331,373.33333333333331,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,"Receitas Complementar",null,null,null,null,null,null,null,-1100,-1100,null,-225,-225]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,16089.15,16089.15,null,13632.483333333332,13632.483333333332]
[]
[null,null,null,"TOTAL DE DESPESAS ADMINISTRATIVAS",null,null,null,null,null,null,null,294708.70600000001,215140.65,null,198129.25333333333,198129.25333333333]
[]
[null,null,null,"MÉDIA PERCURSO TOTAL (MÉDIA MÊS)",null,null,null,null,null,"KM_01",null,"KM","KM",null,"KM","KM"]
[null,null,null,null,null,null,null,null,null,null,null,408876,408876,null,306358,306358]
[]
[null,null,null,"DESPESAS ADMINISTRATIVAS POR KM",null,null,null,null,null,null,"DA_01",0.7207777076668721,0.52617578434537615,null,0.64672459453754538,0.64672459453754538]
[]
[]
[]
[null,"RF","DEMONSTRATIVO DO CUSTO POR KM"]
[]
[null,null,"CA","CAPITAL - REMUNERAÇÃO E DEPRECIAÇÃO",null,null,null,null,null,"CA_21","C_CA",1.0145999999999999,0.90311568623548566,null,1.1012,1.0449845806358278]
[]
[null,null,"GA","GASTOS VARIÁVEIS",null,null,null,null,null,null,"C_GA",1.4153277381925018,1.285655321695016,null,1.5391274810550462,1.3612569674704422]
[null,null,null,"COMBUSTÍVEL",null,null,null,null,null,"VA_11",null,0.83077905405405394,0.83907972972972966,null,0.92319855072463763,0.88529202898550718]
[null,null,null,"LUBRIFICANTES",null,null,null,null,null,"VA_12",null,0.1053,8.7749999999999995E-2,null,0.1113,9.2749999999999999E-2]
[null,null,null,"RODAGEM",null,null,null,null,null,"VA_13",null,0.1353912676056338,0.11791825737030882,null,0.13817869249394674,0.12647901884408885]
[null,null,null,"PEÇAS E ACESSÓRIOS",null,null,null,null,null,"VA_14",null,0.34385741653281388,0.2409073345949774,null,0.36645023783646175,0.25673591964084636]
[]
[null,null,"PE","CUSTO COM PESSOAL",null,null,null,null,null,"PE_11","C_CP",2.6146812940736579,2.0405031804623412,null,3.3646039722927243,2.3550135357206927]
[]
[null,null,"DA","DESPESAS ADMINISTRATIVAS",null,null,null,null,null,"DA_01","C_DA",0.7207777076668721,0.52617578434537615,null,0.64672459453754538,0.64672459453754538]
[]
[null,null,null,"TOTAL",null,null,null,null,null,null,"SOMA",5.7653867399330316,4.7554499727382193,null,6.6516560478853162,5.4079796783645087]
[]
[null,null,null,"IMPOSTOS","COFINS",3.6499999999999998E-2,null,null,null,null,"IMP",0.21840852725226334,0.18014937623761806,null,0.25198281862772554,0.20486897587992114]
[]
[null,null,"CK","CUSTO TOTAL POR QUILOMETRO",null,null,null,null,null,null,"TOTAL",5.983795267185295,4.9355993489758374,null,6.9036388665130417,5.6128486542444298]
[]
[null,"TA","APURAÇÃO DA TARIFA",null,null,null,null,null,null,null,null,"Empresa  NOV/2010","Calculo PMC NOV/2010",null,"Empresa  SET/2012","Calculo PMC SET/2012"]
[]
[null,null,"CK","CUSTO TOTAL POR QUILOMETRO",null,null,null,null,null,null,"TOTAL",5.983795267185295,4.9355993489758374,null,6.9036388665130417,5.6128486542444298]
[]
[null,null,null,"INDICE PASSAGEIRO QUILOMETRO",null,null,null,null,null,null,"IPK",2.3127,2.3813361247095544,null,2.4961000000000002,2.4961000000000002]
[]
[null,null,null,"VALAOR DA TARIFA",null,null,null,null,null,null,"TAR",2.587363370599427,2.0726176778500012,null,2.765770148036153,2.2486473515662149]
[null,null,null,"VARIAÇÃO",null,null,null,null,null,null,null,null,null,null,6.8953120177856375E-2,8.4931087675955474E-2]
[]
[null,"TA","APURAÇÃO DA TARIFA"]
[]
[null,null,null,null,null,null,null,"Equivalencia"]
[null,null,null,"TARIFA ANTERIOR - MARÇO DE 2010",null,null,"2010-03-01","2010-03-01"]
[null,null,null,"ANTECIPADO (base)",null,null,2.0299999999999998,1,null,"APURADO",null,null,2.0726176778500012]
[null,null,null,"EMBARCADO",null,null,2.2999999999999998,1.1330049261083743]
[null,null,null,"ESTUDANTE",null,null,1,0.49261083743842371]
[null,null,null,"VALE TRANSPORTE",null,null,2.0299999999999998,1]
[]
[null,null,null,"INFLAÇÃO DO PERIODO - 03/2010 A 10/2012",null,null,0.1583]
[null,null,null,null,null,null,null,"Equivalencia"]
[null,null,null,"ANTECIPADO (base)",null,null,"2012-10-01","2012-10-01"]
[null,null,null,"EMBARCADO",null,null,2.3513489999999999,1]
[null,null,null,"ESTUDANTE",null,null,2.6640899999999998,1.1330049261083743]
[null,null,null,"VALE TRANSPORTE",null,null,1.1583000000000001,0.49261083743842371]
[null,null,null,null,null,null,2.3513489999999999,1]
[]
[null,null,null,"NOVA TARIFA - OUTUBRO DE 2012",null,null,null,"Equivalencia","Var %"]
[null,null,null,null,null,null,"2012-10-01","2012-10-01"]
[null,null,null,"ANTECIPADO (base)",null,null,2.2000000000000002,1,8.374384236453225E-2,null,null,null,"APURADO",null,null,2.2486473515662149]
[null,null,null,"EMBARCADO",null,null,2.5,1.1363636363636362,8.6956521739130599E-2]
[null,null,null,"ESTUDANTE",null,null,1.1000000000000001,0.5,0.1]
[null,null,null,"VALE TRANSPORTE",null,null,2.2000000000000002,1,8.374384236453225E-2]
[]
[]
[null,null,"LF","LF","LF","LF","LF","LF","LF","LF","LF","LF","LF","LF","LF","LF"]

{"sheet":"resumo","index":3,"n_rows":84,"n_cols":8,"rows_kept":84,"cut":false,"hidden":false,"merged":[[4,2,4,7],[5,2,5,7],[71,6,71,7],[8,3,8,4],[8,6,8,7],[71,3,71,4]]}
[]
[null,"PREFEITURA MUNICIPAL DE CHAPECO"]
[null,"CONTROLADORIA GERAL DO MUNICIPIO"]
[]
[null,null,"TRANSPORTE COLETIVO URBANO"]
[null,null,"RESUMO PLANILHA APURAÇÃO DE CUSTO TARIFA"]
[]
[]
[null,null,"Discriminação","NOVEMBRO DE 2010",null,null,"SETEMBRO DE 2012"]
[null,null,null,"AVC/TTT","PMC",null,"AVC","PMC"]
[]
[null,null,"CUSTOS DE OPERAÇÃO","Custo KM","Custo KM",null,"Custo KM","Custo KM"]
[]
[null,null,"FROTA BASE",{"$f":"+apura!L44","v":74},{"$f":"+apura!M44","v":74},null,{"$f":"+apura!O44","v":69},{"$f":"+apura!P44","v":69}]
[null,null,"MÉDIA PERCURSO TOTAL (KM MÉDIA MÊS)",{"$f":"+apura!L70","v":408876},{"$f":"+apura!M70","v":408876},null,{"$f":"+apura!O70","v":306358},{"$f":"+apura!P70","v":306358}]
[]
[]
[null,null,"CAPITAL - REMUNERAÇÃO E DEPRECIAÇÃO",{"$f":"SUM(D19:D21)","v":1.0145999999999999},{"$f":"SUM(E19:E21)","v":0.90311568623548566},null,1.1012,{"$f":"SUM(H19:H21)","v":1.0449845806358278}]
[null,null,"Veiculos",0.64939999999999998,{"$f":"+apura!M252","v":0.51861043676612917},null,{"$f":"+apura!O252","v":0},{"$f":"+apura!P252","v":0.61841003979834319}]
[null,null,"Validadores, SBE, SM, Maq Equip",0.1822,{"$f":"+apura!M253","v":0.15675275134010505},null,{"$f":"+apura!O253","v":0},{"$f":"+apura!P253","v":0.19405509879309049}]
[null,null,"Outros investimentos",0.183,{"$f":"+apura!M254","v":0.22775249812925152},null,{"$f":"+apura!O254","v":0},{"$f":"+apura!P254","v":0.23251944204439412}]
[]
[null,null,"GASTOS VARIÁVEIS",{"$f":"SUM(D24:D27)","v":1.4153277381925018},{"$f":"SUM(E24:E27)","v":1.285655321695016},null,{"$f":"SUM(G24:G27)","v":1.5391274810550462},{"$f":"SUM(H24:H27)","v":1.3612569674704422}]
[null,null,"Combustíveis",{"$f":"+apura!L282","v":0.83077905405405394},{"$f":"+apura!M282","v":0.83907972972972966},null,{"$f":"+apura!O282","v":0.92319855072463763},{"$f":"+apura!P282","v":0.88529202898550718}]
[null,null,"Lubrificantes",{"$f":"+apura!L297","v":0.1053},{"$f":"+apura!M297","v":8.7749999999999995E-2},null,{"$f":"+apura!O297","v":0.1113},{"$f":"+apura!P297","v":9.2749999999999999E-2}]
[null,null,"Rodagem",{"$f":"+apura!L357","v":0.1353912676056338},{"$f":"+apura!M357","v":0.11791825737030882},null,{"$f":"+apura!O357","v":0.13817869249394674},{"$f":"+apura!P357","v":0.12647901884408885}]
[null,null,"Peças e Acessórios",{"$f":"+apura!L385","v":0.34385741653281388},{"$f":"+apura!M385","v":0.2409073345949774},null,{"$f":"+apura!O385","v":0.36645023783646175},{"$f":"+apura!P385","v":0.25673591964084636}]
[]
[null,null,"CUSTO DE PESSOAL",{"$f":"SUM(D34:D43)","v":2.6146812940736579},{"$f":"SUM(E34:E43)","v":2.0405031804623412},null,{"$f":"SUM(G34:G43)","v":3.3646039722927243},{"$f":"SUM(H34:H43)","v":2.3550135357206927}]
[]
[null,null,"ENCARGOS DE PESSOAL",{"$f":"+apura!L391","v":0.82369999999999999},{"$f":"+apura!M391","v":0.82369999999999999},null,{"$f":"+apura!O391","v":0.82369999999999999},{"$f":"+apura!P391","v":0.82369999999999999}]
[]
[null,null,"PESSOAL DIRETO"]
[null,null,"Motorista",{"$f":"+apura!L452","v":1.1798494937281718},{"$f":"+apura!M452","v":0.89045244809673363},null,{"$f":"+apura!O452","v":1.5345607043328393},{"$f":"+apura!P452","v":1.0961147888091709}]
[null,null,"Cobrador",{"$f":"+apura!L453","v":0.64340702767330449},{"$f":"+apura!M453","v":0.48559020956475807},null,{"$f":"+apura!O453","v":0.72455614453417239},{"$f":"+apura!P453","v":0.39911991012475601}]
[null,null,"Fiscal/Despachante",{"$f":"+apura!L454","v":0.16678312678513779},{"$f":"+apura!M454","v":0.16443406866140345},null,{"$f":"+apura!O454","v":0.2026842998914668},{"$f":"+apura!P454","v":0.17667396600708976}]
[null,null,"Bilheteiro",{"$f":"+apura!L455","v":1.7506303236580284E-2},{"$f":"+apura!M455","v":1.8492573841458044E-2},null,{"$f":"+apura!O455","v":1.9384959853765853E-2},{"$f":"+apura!P455","v":2.0534915099328237E-2}]
[]
[null,null,"PESSOAL INDIRETO"]
[null,null,"Manutenção",{"$f":"+apura!L458","v":0.30113189271347918},{"$f":"+apura!M458","v":0.23384539502465296},null,{"$f":"+apura!O458","v":0.37217791629183672},{"$f":"+apura!P458","v":0.25386653700605172}]
[null,null,"Pessoal administrativo",{"$f":"+apura!L459","v":0.26098097368501527},{"$f":"+apura!M459","v":0.20266600902136589},null,{"$f":"+apura!O459","v":0.3225541941195918},{"$f":"+apura!P459","v":0.22001766540524484}]
[null,null,"Honorários diretoria",{"$f":"+apura!L460","v":1.3940656825052094E-2},{"$f":"+apura!M460","v":1.3940656825052094E-2},null,{"$f":"+apura!O460","v":2.1856879859510767E-2},{"$f":"+apura!P460","v":2.1856879859510767E-2}]
[null,null,"Benefícios sociais",{"$f":"+apura!L461","v":3.1081819426916721E-2},{"$f":"+apura!M461","v":3.1081819426916721E-2},null,{"$f":"+apura!O461","v":0.16682887340954047},{"$f":"+apura!P461","v":0.16682887340954047}]
[]
[null,null,"DESPESAS ADMINISTRATIVAS",{"$f":"SUM(D46:D57)","v":0.72077770766687199},{"$f":"SUM(E46:E57)","v":0.52617578434537604},null,{"$f":"SUM(G46:G57)","v":0.64672459453754538},{"$f":"SUM(H46:H57)","v":0.64672459453754538}]
[null,null,"Serviços de Bilhetagem Eletrônica - SBE",{"$f":"+apura!L471/apura!L$514","v":4.8308607010438369E-2},{"$f":"+apura!M471/apura!M$514","v":4.8308607010438369E-2},null,{"$f":"+apura!O471/apura!O$514","v":4.6874636862755337E-2},{"$f":"+apura!P471/apura!P$514","v":4.6874636862755337E-2}]
[null,null,"Serviços de Atendimento ao Passageiro - SAC",{"$f":"+apura!L472/apura!L$514","v":0},{"$f":"+apura!M472/apura!M$514","v":0},null,{"$f":"+apura!O472/apura!O$514","v":0},{"$f":"+apura!P472/apura!P$514","v":0}]
[null,null,"Serviço Especial de Atendimento a PPDLSevera",{"$f":"+apura!L473/apura!L$514","v":0},{"$f":"+apura!M473/apura!M$514","v":0},null,{"$f":"+apura!O473/apura!O$514","v":0},{"$f":"+apura!P473/apura!P$514","v":0}]
[null,null,"Serviço de Manutenção de Abrigos e Terminais",{"$f":"+apura!L474/apura!L$514","v":8.7831029456363289E-3},{"$f":"+apura!M474/apura!M$514","v":8.7831029456363289E-3},null,{"$f":"+apura!O474/apura!O$514","v":5.8467544506753534E-4},{"$f":"+apura!P474/apura!P$514","v":5.8467544506753534E-4}]
[null,null,"Despesas Administrativas Gerais",{"$f":"+apura!L487/apura!L$514","v":0.39019739480918419},{"$f":"+apura!M487/apura!M$514","v":0.39019739480918419},null,{"$f":"+apura!O487/apura!O$514","v":0.49508663067391745},{"$f":"+apura!P487/apura!P$514","v":0.49508663067391745}]
[null,null,"Encargos Financeiros",{"$f":"+apura!L493/apura!L$514","v":0.21995924436748548},{"$f":"+apura!M493/apura!M$514","v":2.5357321045989492E-2},null,{"$f":"+apura!O493/apura!O$514","v":5.4155334608529886E-2},{"$f":"+apura!P493/apura!P$514","v":5.4155334608529886E-2}]
[null,null,"Outros custos operacionais",{"$f":"+apura!L499/apura!L$514","v":1.4179653489077374E-2},{"$f":"+apura!M499/apura!M$514","v":1.4179653489077374E-2},null,{"$f":"+apura!O499/apura!O$514","v":5.5247782006671931E-3},{"$f":"+apura!P499/apura!P$514","v":5.5247782006671931E-3}]
[null,null,"Despesa Anual c/Seguro Responsab. cívil",{"$f":"+apura!L502/apura!L$514","v":3.5939991586691318E-2},{"$f":"+apura!M502/apura!M$514","v":3.5939991586691318E-2},null,{"$f":"+apura!O502/apura!O$514","v":3.8065487653877704E-2},{"$f":"+apura!P502/apura!P$514","v":3.8065487653877704E-2}]
[null,null,"Despesa Anual com o Seguro Obrigatório",{"$f":"+apura!L503/apura!L$514","v":0},{"$f":"+apura!M503/apura!M$514","v":0},null,{"$f":"+apura!O503/apura!O$514","v":6.2154407588507566E-3},{"$f":"+apura!P503/apura!P$514","v":6.2154407588507566E-3}]
[null,null,"Despesas Anual com Emplacamento",{"$f":"+apura!L504/apura!L$514","v":5.1869433927808593E-3},{"$f":"+apura!M504/apura!M$514","v":5.1869433927808593E-3},null,{"$f":"+apura!O504/apura!O$514","v":9.5204521072296685E-4},{"$f":"+apura!P504/apura!P$514","v":9.5204521072296685E-4}]
[null,null,"Despesa Anual com o IPVA Por Veículo",{"$f":"+apura!L505/apura!L$514","v":9.1307225988645287E-4},{"$f":"+apura!M505/apura!M$514","v":9.1307225988645287E-4},null,{"$f":"+apura!O505/apura!O$514","v":0},{"$f":"+apura!P505/apura!P$514","v":0}]
[null,null,"Receitas Complementar",{"$f":"+apura!L508/apura!L$514","v":-2.6903021943082989E-3},{"$f":"+apura!M508/apura!M$514","v":-2.6903021943082989E-3},null,{"$f":"+apura!O508/apura!O$514","v":-7.3443487684343159E-4},{"$f":"+apura!P508/apura!P$514","v":-7.3443487684343159E-4}]
[]
[null,null,"TOTAL",{"$f":"+D23+D29+D45+D18","v":5.7653867399330307},{"$f":"+E23+E29+E45+E18","v":4.7554499727382185},null,{"$f":"+G23+G29+G45+G18","v":6.6516560478853162},{"$f":"+H23+H29+H45+H18","v":5.4079796783645078}]
[]
[null,null,"TOTAL",{"$f":"+D59","v":5.7653867399330307},{"$f":"+E59","v":4.7554499727382185},null,{"$f":"+G59","v":6.6516560478853162},{"$f":"+H59","v":5.4079796783645078}]
[]
[null,null,"IMPOSTOS",{"$f":"+D59/(1-0.0365)-D59","v":0.21840852725226334},{"$f":"+E59/(1-0.0365)-E59","v":0.18014937623761806},null,{"$f":"+G59/(1-0.0365)-G59","v":0.25198281862772554},{"$f":"+H59/(1-0.0365)-H59","v":0.20486897587992114}]
[]
[null,null,"CUSTO TOTAL POR QUILOMETRO",{"$f":"+D59+D63","v":5.9837952671852941},{"$f":"+E59+E63","v":4.9355993489758365},null,{"$f":"+G59+G63","v":6.9036388665130417},{"$f":"+H59+H63","v":5.6128486542444289}]
[]
[null,null,"INDICE PASSAGEIRO QUILOMETRO",{"$f":"+apura!L544","v":2.3127},{"$f":"+apura!M544","v":2.3813361247095544},null,{"$f":"+apura!O544","v":2.4961000000000002},{"$f":"+apura!P544","v":2.4961000000000002}]
[]
[null,null,"VALOR DA TARIFA CÁLCULADA",{"$f":"+D65/D67","v":2.5873633705994266},{"$f":"+E65/E67","v":2.0726176778500007},null,{"$f":"+G65/G67","v":2.765770148036153},{"$f":"+H65/H67","v":2.2486473515662149}]
[]
[]
[null,null,"TARIFA","Março de 2010",null,null,"Outubro de 2012"]
[]
[null,null,"TARIFA ANTERIOR","Valor ","% Equiv"]
[null,null,"ANTECIPADO (base)",2.0299999999999998,{"$f":"+D75/D$75","v":1}]
[null,null,"EMBARCADO",2.2999999999999998,{"$f":"+D76/D$75","v":1.1330049261083743}]
[null,null,"ESTUDANTE",1,{"$f":"+D77/D$75","v":0.49261083743842371}]
[null,null,"VALE TRANSPORTE",{"$f":"+D75","v":2.0299999999999998},{"$f":"+D78/D$75","v":1}]
[]
[null,null,"NOVA TARIFA",null,null,null,"Valor ","% Equiv"]
[null,null,"ANTECIPADO (base)",null,null,null,2.2000000000000002,{"$f":"+G81/G$81","v":1}]
[null,null,"EMBARCADO",null,null,null,2.5,{"$f":"+G82/G$81","v":1.1363636363636362}]
[null,null,"ESTUDANTE",null,null,null,1.1000000000000001,{"$f":"+G83/G$81","v":0.5}]
[null,null,"VALE TRANSPORTE",null,null,null,{"$f":"+G81","v":2.2000000000000002},{"$f":"+G84/G$81","v":1}]