{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Historico","D_PASS","APURA","publicar"],"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":"Historico","index":0,"n_rows":35,"n_cols":22,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,1,6,2],[6,3,6,6],[6,7,7,10]]}
[]
[]
[null,"PREFEITURA MUNICIPAL DE CHAPECO"]
[]
[null,"HISTÓRICO DA TARIFA"]
[]
[null,"DATA",null,"TARIFA",null,null,null,"VARIAÇÃO"]
[null,"Inicial","Final","ÚNICA","Antecipada","Embarcada","Estudante"]
[]
[null,"2005-02-22","2006-01-23",null,1.5,1.7,0.75]
[null,{"$f":"+C10+1","v":"2006-01-24"},"2006-12-28",1.7,null,null,0.85,null,null,null,{"$f":"+G11/G10-1","v":0.1333333333333333}]
[null,{"$f":"+C11+1","v":"2006-12-29"},"2008-01-17",1.8,null,null,0.9,{"$f":"+D12/D11-1","v":5.8823529411764719E-2},null,null,5.8823529411764719E-2]
[null,{"$f":"+C12+1","v":"2008-01-18"},"2009-01-07",1.9,null,null,0.95,{"$f":"+D13/D12-1","v":5.555555555555558E-2},null,null,5.555555555555558E-2]
[null,{"$f":"+C13+1","v":"2009-01-08"},"2010-03-03",null,2.0299999999999998,2.1,1,null,null,null,5.2631578947368363E-2]
[null,{"$f":"+C14+1","v":"2010-03-04"},"2011-01-07",null,2.0299999999999998,2.2999999999999998,1,null,{"$f":"+E15/E14-1","v":0},{"$f":"+F15/F14-1","v":9.5238095238095122E-2},0]
[null,"2012-10-01","ATUAL",null,2.2000000000000002,2.5,1.1000000000000001,null,{"$f":"+E16/E15-1","v":8.374384236453225E-2},{"$f":"+F16/F15-1","v":8.6956521739130599E-2},0.10000000000000009]
[null,null,"VARIAÇÃO",null,{"$f":"+E16/E10-1","v":0.46666666666666679},{"$f":"+F16/F10-1","v":0.47058823529411775},{"$f":"+G16/G10-1","v":0.46666666666666679}]
[]
[null,"Mês",2005,{"$f":"+C19+1","v":2006},{"$f":"+D19+1","v":2007},2008,2009,{"$f":"+G19+1","v":2010},2011,2012,2013]
[null,"Janeiro",8.6E-3,4.0000000000000001E-3,6.1999999999999998E-3,9.7000000000000003E-3,2.8999999999999998E-3,2.3999999999999998E-3,6.0000000000000001E-3,5.1000000000000004E-3,7.4000000000000003E-3,null,null,{"$f":"(1+C20)-1","v":8.599999999999941E-3},4.0000000000000036E-3,6.1999999999999833E-3,9.7000000000000419E-3,2.8999999999999027E-3,2.3999999999999577E-3,6.0000000000000053E-3,5.1000000000001044E-3,7.4000000000000732E-3]
[null,"Fevereiro",5.7000000000000002E-3,3.8E-3,4.8999999999999998E-3,6.8999999999999999E-3,6.4000000000000003E-3,8.8000000000000005E-3,9.3999999999999986E-3,5.1000000000000004E-3,9.1999999999999998E-3,null,null,{"$f":"(1+C21)*(1+N20)-1","v":1.4349020000000046E-2},7.8152000000000221E-3,1.1130379999999995E-2,1.6666929999999969E-2,9.3185599999998647E-3,1.1221119999999862E-2,1.5456400000000148E-2,1.022601000000023E-2,1.6668080000000085E-2]
[null,"Março",4.4000000000000003E-3,2.3E-3,4.1999999999999997E-3,4.7999999999999996E-3,3.0999999999999999E-3,7.0000000000000001E-3,5.4000000000000003E-3,3.8999999999999998E-3,5.1999999999999998E-3,null,null,{"$f":"(1+C22)*(1+N21)-1","v":1.8812155688000098E-2},1.0133174959999991E-2,1.5377127595999962E-2,2.154693126399998E-2,1.2447447535999911E-2,1.8299667839999811E-2,2.0939864560000299E-2,1.4165891439000156E-2,2.1954754016000111E-2]
[null,"Abril",7.3000000000000001E-3,2.7000000000000001E-3,4.4000000000000003E-3,5.1000000000000004E-3,2E-3,7.0999999999999995E-3,6.6E-3,1.8E-3,6.0000000000000001E-3,null,null,2.6249484424522684E-2,1.2860534532391998E-2,1.9844786957422311E-2,2.675682061344653E-2,1.4472342431071983E-2,2.5529595481663891E-2,2.7678067666096151E-2,1.5991390043590403E-2,2.8086482540096158E-2]
[null,"Maio",9.1000000000000004E-3,1.1999999999999999E-3,2.5999999999999999E-3,6.4000000000000003E-3,5.4999999999999997E-3,7.3000000000000001E-3,7.1999999999999998E-3,6.4000000000000003E-3,5.8999999999999999E-3,null,null,3.5588354732785987E-2,1.4075967173830861E-2,2.2496383403511455E-2,3.3328064265372603E-2,2.0051940314443017E-2,3.3015961528680027E-2,3.5077349753292131E-2,2.2493734939869281E-2,3.4152192787082702E-2]
[null,"Junho",7.0000000000000001E-3,1.2999999999999999E-3,2.5999999999999999E-3,9.5999999999999992E-3,6.0000000000000001E-3,4.3E-3,5.6999999999999993E-3,5.4999999999999997E-3,3.5000000000000001E-3,null,null,4.2837473215915356E-2,1.5394265931157003E-2,2.5154874000360428E-2,4.3248013682320341E-2,2.6172251956329662E-2,3.7457930163253383E-2,4.0977290646885933E-2,2.8117450482038731E-2,3.7771725461837491E-2]
[null,"Julho",-1.1000000000000001E-3,-6.9999999999999999E-4,3.0999999999999999E-3,9.1000000000000004E-3,4.1999999999999997E-3,-1.1000000000000001E-3,2.2000000000000001E-3,2.5999999999999999E-3,0,null,null,4.1690351995377961E-2,1.4683489945005235E-2,2.8332854109761607E-2,5.2741570606829491E-2,3.048217541454612E-2,3.6316726440073888E-2,4.3267440686309167E-2,3.0790555853291934E-2,3.7771725461837491E-2]
[null,"Agosto",2.9999999999999997E-4,1.1000000000000001E-3,3.2000000000000002E-3,5.7999999999999996E-3,2.3E-3,-7.000000000000001E-4,0,4.3E-3,0,null,null,4.2002859100976453E-2,1.5799641783944773E-2,3.1623519242912845E-2,5.8847471716349187E-2,3.2852284417999478E-2,3.5591304731565909E-2,4.3267440686309167E-2,3.5222955243461085E-2,3.7771725461837491E-2]
[null,"Setembro",0,-2.0000000000000001E-4,5.8999999999999999E-3,2.0999999999999999E-3,8.0000000000000004E-4,-7.000000000000001E-4,4.1999999999999997E-3,4.4999999999999997E-3,0,null,null,4.2002859100976453E-2,1.559648185558804E-2,3.771009800644598E-2,6.1071051406953458E-2,3.3678566245533892E-2,3.4866390818253823E-2,4.7649163937191652E-2,3.9881458542056603E-2,3.7771725461837491E-2]
[null,"Outubro",1.5E-3,1.6000000000000001E-3,2.5000000000000001E-3,1.5E-3,1.6000000000000001E-3,5.4000000000000003E-3,4.5000000000000005E-3,6.3E-3,0,null,null,4.3565863389627868E-2,1.722143622655703E-2,4.0304373251462078E-2,6.2662657984063896E-2,3.5332451951526789E-2,4.0454669328672477E-2,5.2363585174908911E-2,4.6432711730871601E-2,3.7771725461837491E-2]
[null,"Novembro",5.7999999999999996E-3,4.3E-3,3.0000000000000001E-3,5.0000000000000001E-3,2.3999999999999998E-3,9.1999999999999998E-3,3.2000000000000002E-3,7.1000000000000004E-3,0,null,null,4.9618545397287717E-2,2.1595488402331275E-2,4.3425286371216343E-2,6.7975971273984026E-2,3.7817249836210376E-2,5.0026852286496393E-2,5.5731148647468753E-2,5.3862383984160989E-2,3.7771725461837491E-2]
[null,"Dezembro",5.4000000000000003E-3,4.1999999999999997E-3,4.3E-3,3.8E-3,3.7000000000000002E-3,1.03E-2,5.6999999999999993E-3,5.4000000000000003E-3,0,null,null,{"$f":"(1+C31)*(1+N30)-1","v":5.5286485542433095E-2},2.5886189453621089E-2,4.7912015102612449E-2,7.2034279964825254E-2,4.1657173660604396E-2,6.0842128865047362E-2,6.174881619475947E-2,5.9553240857675549E-2,3.7771725461837491E-2]
[]
[null,"Variação Anual",{"$f":"(1+C31)*(1+N30)-1","v":5.5286485542433095E-2},2.5886189453621089E-2,4.7912015102612449E-2,7.2034279964825254E-2,4.1657173660604396E-2,6.0842128865047362E-2,6.174881619475947E-2,5.9553240857675549E-2,3.7771725461837491E-2]
[]
[null,"% Acumulada",{"$f":"(1+C33)*(1+N32)-1","v":5.5286485542433095E-2},{"$f":"(1+C35)*(1+D33)-1","v":8.2603831435030584E-2},{"$f":"(1+D35)*(1+E33)-1","v":0.1344735625568918},0.21619454877480759,0.26685777629820007,0.34393610037742239,0.42692256361712966,0.51190042673347236,0.56900751457768406]

{"sheet":"D_PASS","index":1,"n_rows":78,"n_cols":26,"rows_kept":78,"cut":false,"hidden":false,"merged":[[9,6,9,7],[8,2,8,9],[9,8,9,9],[9,15,9,17],[12,1,12,9],[8,14,8,19],[1,1,1,11],[2,1,2,11],[8,1,9,1],[9,2,9,3],[9,4,9,5],[4,1,4,21],[6,1,6,21]]}
[null,null,666666666]
[null,"PREFEITURA MUNICIPAL DE CHAPECO"]
[null,"CONTROLADORIA GERAL DO MUNICIPIO"]
[]
[null,"SISTEMA DE TRANSPORTE COLETIVO URBANO DE CHAPECÓ"]
[]
[null,"PASSAGEIROS TRANSPORTADOS"]
[]
[null,"Período/Mês","Passageiros Pagantes",null,null,null,null,null,null,null,null,null,null,null,"QUILOMETRAGEM "]
[null,null,"Antecipado",null,"Embarcado",null,"Estudante",null,"Vale Transporte",null,"Soma","Passag. Equival.","Gratuid","Passag. Transport","Km Program","Km Ocioso",null,null,"KM Total","KM Médial","IPK mês","IPK média",null,"S"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)","(h)","(i)","(j)","(k)","(l)","(m)","(n)","(o)","(p)","(q)","(r)","(s)","(t)","(u)",null,"(t)"]
[]
[null,"AUTO VIAÇÃO CHAPECO"]
[]
[null,"2009-07-31"]
[null,"2009-08-31"]
[null,"2009-09-30"]
[null,"2009-10-31"]
[null,"2009-11-30"]
[null,"2009-12-31",274584,2.0299999999999998,88665,2.2999999999999998,64075,1,359475,2.0299999999999998,786799,766080.92118226597,100793,887592,324729.40000000002,16236,0.05,4.9998552641060526E-2,340965.4,340965.4,2.2467999999999999,2.2467999999999999,null,1]
[null,"2010-01-31",83998,2.0299999999999998,230840,2.2999999999999998,2492,1,319984,2.0299999999999998,637314,666752.44334975374,69576,706890,293056.3,14653,0.05,5.0000631278017231E-2,307709.3,324337.34999999998,2.1667999999999998,2.2088999999999999,null,1]
[null,"2010-02-28",71265,2.0299999999999998,206546,2.2999999999999998,35689,1,272840,2.0299999999999998,586340,595703.42364532023,65838,652178,284151.3,14208,0.05,5.0001530874572805E-2,298359.3,315678,1.9965999999999999,2.1419999999999999,null,1]
[null,"2010-03-31",121814,2.0299999999999998,244148,2.2999999999999998,149419,1,391291,2.0299999999999998,906672,863331.30541871919,121739,1028411,338954.6,16948,0.05,5.0000796566855861E-2,355902.6,325734.15000000002,2.4258000000000002,2.2195,null,1]
[null,"2010-04-30",113107,2.0299999999999998,206508,2.2999999999999998,134204,1,356390,2.0299999999999998,810209,769581.92610837449,108584,918793,311440.7,15572,0.05,4.999988761905557E-2,327012.7,325989.86,2.3534000000000002,2.2464,null,1]
[null,"2010-05-31",119188,2.0299999999999998,212984,2.2999999999999998,145197,1,381363,2.0299999999999998,858732,813388.53694581287,109896,968628,325026.40000000002,16251,0.05,4.9999015464589951E-2,341277.4,328537.78333333338,2.3834,2.2700999999999998,null,1]
[null,"2010-06-30",117715,2.0299999999999998,202987,2.2999999999999998,136514,1,372332,2.0299999999999998,829548,787280.54679802957,111380,940928,317712,15886,0.05,5.0001259001863321E-2,333598,329260.67142857146,2.36,2.2831000000000001,null,1]
[null,"2010-07-31",122252,2.0299999999999998,211052,2.2999999999999998,84882,1,383025,2.0299999999999998,801211,786213.74876847281,103473,904684,328781.09999999998,16439,0.05,4.9999832715445024E-2,345220.1,331255.59999999998,2.2774000000000001,2.2824,null,1]
[null,"2010-08-31",118771,2.0299999999999998,217312,2.2999999999999998,135095,1,373777,2.0299999999999998,844955,805312.82758620696,111324,956279,323966.11,16198,0.05,4.9999057000128813E-2,340164.11,332245.43444444449,2.3673999999999999,2.2919999999999998,null,1]
[null,"2010-09-30",115997,2.0299999999999998,211995,2.2999999999999998,138424,1,370783,2.0299999999999998,837199,795160.54187192116,113486,950685,322640,16132,0.05,0.05,338772,332898.09100000001,2.3472,2.2976000000000001,null,1]
[null,"2010-10-31",111756,2.0299999999999998,211401,2.2999999999999998,130119,1,362244,2.0299999999999998,815520,777616.40394088672,110715,926235,317752.5,15888,0.05,5.0001180163806738E-2,333640.5,332965.58272727276,2.3307000000000002,2.3007,null,1]
[null,"2010-11-30",110343,2.0299999999999998,209761,2.2999999999999998,133725,1,360129,2.0299999999999998,813958,774006.630541872,113670,927628,306854.8,15343,0.05,5.0000847306282972E-2,322197.8,332068.26750000002,2.4022999999999999,2.3089,null,1]
[null,"2010-12-31",null,2.0299999999999998,null,2.2999999999999998,null,1,null,2.0299999999999998,0,0,null,0,null,null,null,0,0,0,0,0,null,0]
[null,"2011-01-31",null,2.0299999999999998,null,2.2999999999999998,null,1,null,2.0299999999999998,0,0,null,0,null,null,null,0,0,0,0,0,null,0]
[null,"2011-02-28",null,2.0299999999999998,null,2.2999999999999998,null,1,null,2.0299999999999998,0,0,null,0,null,null,null,0,0,0,0,0,null,0]
[null,"2011-03-31",null,2.0299999999999998,null,2.2999999999999998,null,1,null,2.0299999999999998,0,0,null,0,null,null,null,0,0,0,0,0,null,0]
[null,"2011-04-30",null,2.0299999999999998,null,2.2999999999999998,null,1,null,2.0299999999999998,0,0,null,0,null,null,null,0,0,0,0,0,null,0]
[null,"2011-05-31",null,2.0299999999999998,null,2.2999999999999998,null,1,null,2.0299999999999998,0,0,null,0,null,null,null,0,0,0,0,0,null,0]
[null,"2011-06-30",null,2.0299999999999998,null,2.2999999999999998,null,1,null,2.0299999999999998,0,0,null,0,null,null,null,0,0,0,0,0,null,0]
[null,"2011-07-31",null,2.0299999999999998,null,2.2999999999999998,null,1,null,2.0299999999999998,0,0,null,0,null,null,null,0,0,0,0,0,null,0]
[null,"2011-08-31",null,2.0299999999999998,null,2.2999999999999998,null,1,null,2.0299999999999998,0,0,null,0,null,null,null,0,0,0,0,0,null,0]
[null,"2011-09-30",null,2.0299999999999998,null,2.2999999999999998,null,1,null,2.0299999999999998,0,0,null,0,null,null,null,0,0,0,0,0,null,0]
[null,"2011-10-31",123119,2.0299999999999998,281402,2.2999999999999998,148237,1,402538,2.0299999999999998,955296,917510.00492610841,83549,1038845,333917,9351,null,2.800396505718487E-2,343268,332732.90000000002,2.6728999999999998,2.5419,null,1,845758.31773399026,2.5418535940809885]
[null,"2011-11-30",114818,2.0299999999999998,214475,2.2999999999999998,146066,1,381672,2.0299999999999998,857031,811444.92610837438,84383,941414,306234,9812,null,3.2040857644807567E-2,316046,329657,2.5674999999999999,2.6223999999999998,null,1,864477.46551724139,2.6223543425962177]
[null,"2011-12-31",113758,2.0299999999999998,243013,2.2999999999999998,89965,1,369040,2.0299999999999998,815776,802450.6600985222,83169,898945,321413,9121,null,2.8377819192129752E-2,330534,329949.33333333331,2.4277000000000002,2.5573999999999999,null,1,843801.8637110017,2.5573679909774079]
[null,"2012-01-31",114494,2.0299999999999998,220687,2.2999999999999998,1731,1,332682,2.0299999999999998,669594,698068.16748768475,78636,748230,303107,8465,null,2.7927431567070376E-2,311572,325355,2.2404999999999999,2.4815,null,1,807368.43965517241,2.4815000219918932]
[null,"2012-02-29",114801,2.0299999999999998,232993,2.2999999999999998,62058,1,344221,2.0299999999999998,754073,753574.6600985222,78039,832112,293581,8624,null,2.9375197986245705E-2,302205,320725,2.4935999999999998,2.4838,null,1,796609.6837438423,2.4837779522763812]
[null,"2012-03-31",126574,2.0299999999999998,241310,2.2999999999999998,176186,1,399739,2.0299999999999998,943809,886509.55172413797,92003,1035812,327754,10898,null,3.3250547666847693E-2,338652,323712.83333333331,2.6177999999999999,2.5070999999999999,null,1,811592.99507389159,2.5071387708567574]
[null,"2012-04-30",109670,2.0299999999999998,213877,2.2999999999999998,153926,1,360309,2.0299999999999998,837782,788128.31034482748,83876,921658,299461,9896,null,3.3046039384093423E-2,309357,321662,2.5476000000000001,2.5127000000000002,null,1,808240.89725545386,2.5127024555448076]
[null,"2012-05-31",121952,2.0299999999999998,226312,2.2999999999999998,175312,1,404086,2.0299999999999998,927662,868811.20197044336,91437,1019099,325409,9087,null,2.7924857640692174E-2,334496,323266.25,2.5973999999999999,2.5236999999999998,null,1,815812.18534482748,2.5236540633141487]
[null,"2012-06-30",110235,2.0299999999999998,209395,2.2999999999999998,147748,1,368096,2.0299999999999998,835474,788358.83251231525,81012,916486,307422,8466,null,2.7538692741573473E-2,315888,322446.44444444444,2.4956999999999998,2.5206,null,1,812761.81280788174,2.5206102495818206]
[null,"2012-07-31",115559,2.0299999999999998,218969,2.2999999999999998,96048,1,384786,2.0299999999999998,815362,795752.24137931038,81057,896419,307422,8466,null,2.7538692741573473E-2,315888,321790.59999999998,2.5190999999999999,2.5205000000000002,null,1,811060.8556650246,2.5204616159235997]
[null,"2012-08-31",122395,2.0299999999999998,229825,2.2999999999999998,174809,1,404320,2.0299999999999998,931349,873220.66502463061,91555,1022904,326873,10839,null,3.3159667516130115E-2,337712,323238,2.5857000000000001,2.5266999999999999,null,1,816711.74742498877,2.5266575941720615]
[null,"2012-09-30",105244,2.0299999999999998,204655,2.2999999999999998,148785,1,354280,2.0299999999999998,812964,764692.22660098516,83118,896082,297893,8465,null,2.8416243416260201E-2,306358,321831.33333333331,2.4961000000000002,2.5242,null,1,812376.78735632182,2.5242314940009627]
[null,"2012-10-31",116797,2.0299999999999998,220817,2.2999999999999998,167641,1,401655,2.0299999999999998,906910,851220.52216748777,87859,994769,323920,10015,null,3.091812793282292E-2,333935,321053.58333333331,2.5491000000000001,2.5131000000000001,null,1,806852.66379310342,2.5131401911667499]
[null,"2012-11-30",108098,2.2000000000000002,206581,2.5,153777,1.1000000000000001,373290,2.2000000000000002,841746,793027.63636363647,84585,926331,305611,9199,null,3.0100356335341333E-2,314810,320950.58333333331,2.5190999999999999,2.5091999999999999,null,1,805317.88964770862,2.5091647483043222]
[null,"2012-12-31",94178,2.2000000000000002,214798,2.5,74071,1.1000000000000001,323586,2.2000000000000002,706633,698888.13636363624,72680,779313,296397,8462,null,2.8549546722807587E-2,304859,318811,2.2925,2.4988999999999999,null,1,796687.67933646822,2.4989340999415584]
[null,"2013-01-31",105901,2.2000000000000002,217749,2.5,1934,1.1000000000000001,331084,2.2000000000000002,656668,685394.04545454541,72864,729532,308249,8721,null,2.8292062585766702E-2,316970,319260.83333333331,2.1623000000000001,2.4921000000000002,null,1,795631.50250037329,2.4921049481496267]
[null,"2013-02-28",97742,2.2000000000000002,222306,2.5,62139,1.1000000000000001,328536,2.2000000000000002,710723,709967.95454545447,70603,781326,278017,9148,null,3.2904462676742789E-2,287165,318007.5,2.4723000000000002,2.4904999999999999,null,1,791997.61037095089,2.4904997849766151]
[null,"2013-03-31",219007,2.2000000000000002,104444,2.5,146374,1.1000000000000001,369407,2.2000000000000002,839232,780287.36363636365,79148,918380,305141,9084,null,2.9769844104856443E-2,314225,315971.91666666669,2.4832000000000001,2.4784999999999999,null,1,783145.76136363635,2.4785296415751179]
[null,"2013-04-30",111381,2.2000000000000002,223309,2.5,159681,1.1000000000000001,399302,2.2000000000000002,893673,844283.72727272718,87009,980682,319719,9708,null,3.0364163531100746E-2,329427,317644.41666666669,2.5629,2.4802,null,1,787825.37944096129,2.4802116395066327]
[null,"2013-05-31",211872,2.2000000000000002,103325,2.5,153464,1.1000000000000001,382756,2.2000000000000002,851417,788774.77272727271,80963,932380,313949,8566,null,2.728468636625694E-2,322515,316646,2.4457,{"$f":"+T61/L61","v":0.40144032358586057},null,1,781155.67700403044,2.4669684032137797]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,781155.67700403044,null,null,null,null,null,null,316646,null,2.4670000000000001]
[]
[null,null,"GRATUIDADES",null,"HABIT",null,"UTILIZADO",null,null,null,"ESTUDANTES",null,1,127886.66666666667]
[null,null,"ACIMA 65",null,10000,null,51000,null,5.0999999999999996,null,null,"ADIC",1.2,153464]
[null,null,"ACIMA 60",null,5000,null,25500,null,15000,null,null,"ADIC",1.4,179041.33333333334,25577.333333333343]
[null,null,null,null,15000,null,76500]
[]
[null,"MEIDA ANUAL",126534.08333333333,2.2000000000000002,198014.41666666666,2.5,123872.58333333333,1.1000000000000001,368424.83333333331,2.2000000000000002,816845.91666666663,781911.59090909082,81037.75,897883.66666666663,307551.08333333331,9094.9166666666661,null,null,316646]
[null,"GRATUIDADE",null,2.2000000000000002,-25500,2.5,null,1.1000000000000001,null,2.2000000000000002,-25500,-28977.272727272724,25500,0]
[null,"PASSE 20 40",null,2.2000000000000002,-25577.333333333343,2.5,25577.333333333343,1.1000000000000001,null,2.2000000000000002,0,-16276.484848484852,0,0]
[null,null,126534.08333333333,2.2000000000000002,146937.08333333331,2.5,149449.91666666669,1.1000000000000001,368424.83333333331,2.2000000000000002,791345.91666666663,736657.83333333326,106537.75,897883.66666666663,307551.08333333331,9094.9166666666661,null,null,316646,316646,2.3264]
[]
[null,"MEIDA ANUAL",126534.08333333333,2.2000000000000002,146937.08333333331,2.4,149449.91666666669,1.1000000000000001,368424.83333333331,2.2000000000000002,791345.91666666663,729978.87499999988,null,897883.66666666663,307551.08333333331,9094.9166666666661,null,null,316646,316646,2.3052999999999999]
[]
[]
[null,"MEIDA ANUAL",126534.08333333333,2.2000000000000002,146937.08333333331,2.2999999999999998,149449.91666666669,1.1000000000000001,368424.83333333331,2.2000000000000002,791345.91666666663,723299.91666666651,null,897883.66666666663,307551.08333333331,9094.9166666666661,null,2.9572052122506479E-2,316646,316646,2.2843]

{"sheet":"APURA","index":2,"n_rows":574,"n_cols":20,"rows_kept":574,"cut":false,"hidden":false,"merged":[[524,9,525,9],[478,9,482,9],[485,9,494,9],[512,9,519,9],[497,9,500,9],[506,9,509,9],[451,9,452,9],[457,9,458,9],[422,9,427,9],[232,9,241,9],[279,9,283,9],[288,9,292,9],[294,9,298,9],[273,9,277,9],[445,5,445,6],[309,9,313,9],[327,9,331,9],[315,9,319,9],[321,9,325,9],[345,9,350,9],[352,9,357,9],[333,9,337,9],[303,9,307,9],[441,9,442,9],[445,9,446,9],[364,9,368,9],[403,9,407,9],[380,9,385,9],[38,9,43,9],[87,9,92,9],[17,9,22,9],[47,9,51,9],[53,9,57,9],[59,9,63,9],[24,9,29,9],[94,9,98,9],[100,9,104,9],[153,9,158,9],[135,9,139,9],[147,9,151,9],[141,9,145,9],[112,9,116,9],[118,9,123,9],[127,9,131,9],[53,8,57,8],[59,8,63,8],[1,1,1,7],[2,1,2,7],[4,1,4,7],[8,2,8,7],[6,1,6,7],[6,8,6,10],[10,9,15,9],[31,9,36,9],[66,2,66,7],[10,8,15,8],[17,8,22,8],[80,2,80,7],[68,8,69,8],[71,8,72,8],[24,8,29,8],[31,8,36,8],[38,8,43,8],[47,8,51,8],[260,2,260,7],[244,9,245,9],[187,9,196,9],[199,9,208,9],[210,9,219,9],[106,9,110,9],[221,9,230,9],[163,9,172,9],[175,9,184,9],[554,3,554,7],[556,3,556,7],[339,9,343,9],[389,2,389,7],[532,2,532,7],[377,9,378,9],[370,9,375,9],[409,9,414,9],[391,9,396,9],[442,5,442,6],[565,3,565,7],[416,9,420,9],[530,2,530,7],[476,2,476,7],[431,9,433,9],[436,5,436,6],[437,5,437,6],[441,5,441,6],[446,5,446,6],[436,9,437,9]]}
[null,null,null,null,null,null,null,null,null,null,null,2.587363370599427,2.0785780117288413,null,2.7793425613047149,2.2460225554193816,null,2.845235053503016,2.1718537000907507,"verificado"]
[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","PMC SET/2012",null,"Empresa  MAI/2013","PMC MAI/2013"]
[]
[null,"FR","FROTA"]
[]
[null,null,"FR_01","FROTA TOTAL",null,null,null,null,"FR_01","(IE)",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1,null,15,15]
[null,null,null,"Pesado",null,null,null,null,null,null,null,70,70,null,66,66,null,52,52]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,74,74,null,69,69,null,69,69]
[]
[null,null,"FR_02","FROTA COMPLEMENTAR",null,null,null,null,"FR_02","(IE)",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Pesado",null,null,null,null,null,null,null,3,3,null,10,10,null,7,7,"ok"]
[null,null,null,"Articulado",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,3,3,null,10,10,null,7,7]
[]
[null,null,"FR_03","FROTA OPERANTE",null,null,null,null,"FR_03","( FS)",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1,"ok"]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1,null,15,15,"ok"]
[null,null,null,"Pesado",null,null,null,null,null,null,null,67,67,null,56,56,null,45,45,"ok"]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1,"ok"]
[null,null,null,"Total",null,null,null,null,null,null,null,71,71,null,59,59,null,62,62]
[]
[null,null,"FR_04","FROTA RESERVA (5%)",null,null,null,null,"FR_04","(IE)",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Pesado",null,null,null,null,null,null,null,3,3,null,10,10,null,7,7,"ok"]
[null,null,null,"Articulado",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,3,3,null,10,10,null,7,7]
[]
[null,null,"FR_05","FROTA BASE",null,null,null,null,"FR_05","( FS)",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1,null,15,15]
[null,null,null,"Pesado",null,null,null,null,null,null,null,70,70,null,66,66,null,52,52]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,74,74,null,69,69,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,"Valor","Valor"]
[null,null,null,"Micro",null,null,null,null,null,null,null,182750.89,182750.89,null,185501.77000000002,185501.77000000002,null,185501.77000000002,185501.77000000002,"ok"]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,218354,218354,null,108663.6,108663.6,"ok"]
[null,null,null,"Pesado",null,null,null,null,null,null,null,237994.54828571429,237994.54828571429,null,228656.41999999998,228656.41999999998,null,226325.65,226325.65,"ok"]
[null,null,null,"Articulado",null,null,null,null,null,null,null,314282.05499999999,314282.05499999999,null,318564.11,318564.11,null,318564.11,318564.11,"ok"]
[]
[null,null,"FR_12","valor - Rodagem",null,null,null,null,"FR_12","(IE)",null,"Valor","Valor",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Micro",null,null,null,null,null,null,null,4554,4554,null,4428,4428,null,5808,5808,"ok"]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,8850,8850,null,11160,11160,"ok"]
[null,null,null,"Pesado",null,null,null,null,null,null,null,7860,7860,null,8534,8534,null,10890,10890,"ok"]
[null,null,null,"Articulado",null,null,null,null,null,null,null,13500,13500,null,14190,14190,null,18150,18150,"ok"]
[]
[null,null,"FR_13","Onibus sem rodagem",null,null,null,null,"FR_13","(FS)",null,"Valor","Valor",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,179693.77,179693.77]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,209504,209504,null,97503.6,97503.6]
[null,null,null,"Pesado",null,null,null,null,null,null,null,230134.54828571429,230134.54828571429,null,220122.42,220122.42,null,215435.65,215435.65]
[null,null,null,"Articulado",null,null,null,null,null,null,null,300782.05499999999,300782.05499999999,null,304374.11,304374.11,null,300414.11,300414.11]
[]
[]
[null,"KM","QUILOMETRAGEM "]
[]
[null,null,null,"MÉDIA PERCURSO TOTAL (MÉDIA MÊS)",null,null,null,null,"KM_01",null,null,"KM","KM",null,"KM","KM",null,"KM","KM"]
[null,null,null,null,null,null,null,null,null,null,null,408876,408876,null,306358,306358,null,322515,316646,"ok"]
[]
[null,null,null,"FROTA OPERANTE",null,null,null,null,"FR_03"]
[null,null,null,null,null,null,null,null,null,null,null,71,71,null,59,59,null,62,62]
[]
[null,null,"KM_02","PMM - PERCURSO MÉDIO MENSAL - KM/VEICULO/MÊS",null,null,null,null,null,null,null,"KM (média)","KM (média)",null,"KM (média)","KM (média)",null,"KM (média)","KM (média)"]
[null,null,null,"KM_01 / FR_03",null,null,null,null,null,null,null,5759,5759,null,5193,5193,null,5202,5107]
[]
[null,null,null,"MÉDIA DIA (30 dias)",null,null,null,null,null,null,null,192,192,null,173,173,null,173,170]
[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,28.833333333333332,28.333333333333332]
[]
[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,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,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,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1,null,15,15]
[null,null,null,"Pesado",null,null,null,null,null,null,null,70,70,null,66,66,null,52,52]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,74,74,null,69,69,null,69,69]
[]
[null,null,null,"Valor veiculo sem rodagem",null,null,null,null,null,"FR_13",null,"Valor","Valor",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,179693.77,179693.77]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,209504,209504,null,97503.6,97503.6]
[null,null,null,"Pesado",null,null,null,null,null,null,null,230134.54828571429,230134.54828571429,null,220122.42,220122.42,null,215435.65,215435.65]
[null,null,null,"Articulado",null,null,null,null,null,null,null,300782.05499999999,300782.05499999999,null,304374.11,304374.11,null,300414.11,300414.11]
[]
[null,null,null,"Vida útil do veiculo (anos)",null,null,null,null,null,"(IE)",null,"Anos","Anos",null,"Anos","Anos",null,"Anos","Anos"]
[null,null,null,"Micro",null,null,null,null,null,null,null,null,10,null,null,10,null,null,10,"ok"]
[null,null,null,"Leve",null,null,null,null,null,null,null,null,10,null,null,10,null,null,10,"ok"]
[null,null,null,"Pesado",null,null,null,null,null,null,null,null,12,null,null,12,null,null,12,"ok"]
[null,null,null,"Articulado",null,null,null,null,null,null,null,null,15,null,null,15,null,null,15,"ok"]
[]
[null,null,null,"Valor residual do veiculo (%)",null,null,null,null,null,"(IE)",null,"%","%",null,"%","%",null,"%","%"]
[null,null,null,"Micro",null,null,null,null,null,null,null,null,0.1,null,null,0.1,null,null,0.1,"ok"]
[null,null,null,"Leve",null,null,null,null,null,null,null,null,0.1,null,null,0.1,null,null,0.1,"ok"]
[null,null,null,"Pesado",null,null,null,null,null,null,null,null,0.1,null,null,0.1,null,null,0.1,"ok"]
[null,null,null,"Articulado",null,null,null,null,null,null,null,null,0.1,null,null,0.1,null,null,0.1,"ok"]
[]
[null,null,null,"Coeficiente de Amortização/Depr Mês",null,null,null,null,null,"( FS)",null,"Coeficiente","Coeficiente",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,-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,-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,-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,-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,"Valor","Valor"]
[null,null,null,"Micro",null,null,null,null,null,null,null,0,-4827.0418847133642,null,0,-2452.4857645185457,null,0,-2433.7948720991985]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,0,-2837.5483517557141,null,0,-19809.014109772259]
[null,null,null,"Pesado",null,null,null,null,null,null,null,0,-200363.83248861707,null,0,-180695.64417131702,null,0,-139335.05210826668]
[null,null,null,"Articulado",null,null,null,null,null,null,null,0,-6856.4865698573985,null,0,-3469.1846849495369,null,0,-3424.0495341563233]
[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,0,-165001.91062429448]
[]
[null,null,"CA_12","OUTROS EQUIPAMENTOS"]
[]
[null,null,null,"Valores de investimentos","Inferior","Vlr Uso","Superior","Calculo PMC",null,"(IE)",null,"Valor","Valor",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,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,7952.11,11980.44]
[null,null,null,"Sistema de Monitoramento",825478.5,60,13757.975,13757.975,null,null,null,13757.98,13757.98,null,13757.98,13757.98,null,13757.98,13757.98]
[null,null,null,"Maquinas Instalações e Equipamentos",1E-4,1E-4,1E-4,1E-4,null,null,null,1765.3684270000001,1765.3684270000001,null,1559.5389599999999,1559.5389599999999,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,13902953.679999998,13902953.679999998]
[]
[]
[null,null,null,"Vida útil (anos)",null,null,null,null,null,"(IE)",null,"Anos","Anos",null,"Anos","Anos",null,"Anos","Anos"]
[null,null,null,"Validadores",null,null,null,null,null,null,null,null,5,null,null,5,null,null,5]
[null,null,null,"Sistema Bilhetagem Eletronica",2005,2010,null,null,null,null,null,null,5,null,null,5,null,null,5]
[null,null,null,"Sistema de Monitoramento",2005,2010,null,null,null,null,null,null,5,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,5]
[]
[null,null,null,"Valor residual (%)",null,null,null,null,null,"(IE)",null,"%","%",null,"%","%",null,"%","%"]
[null,null,null,"Validadores",null,null,null,null,null,null,null,null,0,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,0]
[null,null,null,"Sistema de Monitoramento",null,null,null,null,null,null,null,null,0,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,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,"Coeficiente","Coeficiente"]
[null,null,null,"Validadores",null,null,null,null,null,null,null,null,-2.1935695870223159E-2,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,-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,-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,-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,"Valor","Valor"]
[null,null,null,"Validadores",null,null,null,null,null,null,null,0,-19447.147329127769,null,0,-18133.150887970485,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,0,-18133.150887970485]
[null,null,null,"Sistema de Monitoramento",null,null,null,null,null,null,null,0,-22332.524015077346,null,0,-20823.569689734282,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,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,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,"Valor","Valor"]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2006,20,null,null,null,null,12056.5,12056.5,null,null,12056.5,null,null,12056.5]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2007,20,null,null,null,null,138339.46,138339.46,null,null,138339.46,null,null,138339.46]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2008,20,null,null,null,null,1257183.47,1257183.47,null,null,1257183.47,null,null,1257183.47]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2006,20,null,null,null,null,2400,2400,null,null,2400,null,null,2400]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2008,20,null,null,null,null,262227.21999999997,262227.21999999997,null,null,262227.21999999997,null,null,262227.21999999997]
[null,null,null,"Outorga - Minima","AVC",2010,20,null,null,null,null,4000000,4000000,null,null,4000000,null,null,4000000]
[null,null,null,"Outorga - Minima","TTT",2010,20,null,null,null,null,1000000,1000000,null,null,0,null,null,0]
[null,null,null,"Outorga - Final","AVC",2010,20,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,"Outorga - Final","TTT",2010,20,null,null,null,null,0,0,null,null,0,null,null,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,"Valor","Valor"]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2006,0.23389733197886109,null,null,null,null,2820,2820,null,null,2820,null,null,2820]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2007,0.1775986098988096,null,null,null,null,24569,24569,null,null,24569,null,null,24569]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2008,9.7924176071311209E-2,null,null,null,null,123109,123109,null,null,123109,null,null,123109]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2006,0.23389733197886087,null,null,null,null,561,561,null,null,561,null,null,561]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2008,9.7924176071311431E-2,null,null,null,null,25678,25678,null,null,25678,null,null,25678]
[null,null,null,"Outorga - Minima","AVC",2010,null,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,"Outorga - Minima","TTT",2010,null,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,"Outorga - Final","AVC",2010,null,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,"Outorga - Final","TTT",2010,null,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,176737,176737,null,null,176737,null,null,176737]
[]
[null,null,null,"Valores de investimentos",null,null,null,null,null,"(IE)",null,"Valor","Valor",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,null,11901.2,null,null,11901.2]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2010,3,null,null,null,null,138472.19099999999,138472.19099999999,null,null,138472.19099999999,null,null,138472.19099999999]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2010,2,null,null,null,null,1242263.223,1242263.223,null,null,1242263.223,null,null,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,null,4000000,null,null,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,null,0,null,null,0]
[null,null,null,"Outorga - Final","TTT",2010,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,6654120.1119999997,6654120.1119999997,null,null,5392636.6140000001,null,null,5392636.6140000001]
[]
[null,null,null,"Vida útil (anos)",null,null,null,null,null,"(IE)",null,"Anos","Anos",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,10]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",2010,0,null,null,null,null,null,10,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,20]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2010,0,null,null,null,null,null,10,null,null,20,null,null,20]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",2010,0,null,null,null,null,null,10,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,10]
[null,null,null,"Outorga - Minima","TTT",2010,0,null,null,null,null,null,10,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,10]
[null,null,null,"Outorga - Final","TTT",2010,0,null,null,null,null,null,10,null,null,10,null,null,10]
[]
[null,null,null,"Valor residual (%)",null,null,null,null,null,"(IE)",null,"%","%",null,"%","%",null,"%","%"]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",null,null,null,null,null,null,null,0,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,0]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",null,null,null,null,null,null,null,0,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,0]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",null,null,null,null,null,null,null,0,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,0]
[null,null,null,"Outorga - Minima","TTT",null,null,null,null,null,null,null,0,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,0]
[null,null,null,"Outorga - Final","TTT",null,null,null,null,null,null,null,0,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,"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,-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,-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,-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,-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,-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,-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,-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,-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,-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,"Valor","Valor"]
[null,null,null,"Investimento Terminal e Infraestrutura","AVC",null,null,null,null,null,null,0,-166.55393056348706,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,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,0,-13150.888569200328]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",null,null,null,null,null,null,0,-33.150686545792709,null,0,0,null,0,0]
[null,null,null,"Investimento Terminal e Infraestrutura","TTT",null,null,null,null,null,null,0,-3626.2369692695625,null,0,0,null,0,0]
[null,null,null,"Outorga - Minima","AVC",null,null,null,null,null,null,0,-55978.869547100141,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,0,0]
[null,null,null,"Outorga - Final","AVC",null,null,null,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Outorga - Final","TTT",null,null,null,null,null,null,0,0,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,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,"KM","KM"]
[null,null,null,null,null,null,null,null,null,null,null,408876,408876,null,306358,306358,null,322515,316646]
[]
[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,0,-165001.91062429448]
[null,null,null,"OUTROS EQUIPAMENTOS",null,null,null,null,null,"CA_12",null,0,-64092.437956936788,null,0,-59450.331956053618,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,0,-71234.19122583649]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,0,-369262.32932522043,null,0,-320139.38615443092,null,0,-295686.43380618456]
[]
[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,"Custo KM","Custo KM"]
[null,null,null,"VEICULOS",null,null,null,null,null,null,null,null,0.51861043676612917,null,null,0.61841003979834319,null,null,0.52109267328276521]
[null,null,null,"OUTROS EQUIPAMENTOS",null,null,null,null,null,null,null,null,0.15675275134010505,null,null,0.19405509879309049,null,null,0.18775014355480132]
[null,null,null,"OUTROS INVESTIMENTOS",null,null,null,null,null,null,null,null,0.22775249812925152,null,null,0.23251944204439412,null,null,0.2249647594658909]
[null,null,null,"Total",null,null,null,null,null,null,"CA_21",0,0.90311568623548566,null,0,1.0449845806358278,null,0,0.93380757630345745]
[]
[]
[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,2.5085000000000002,2.13,"ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.6980056980056926E-2]
[null,null,"VA_11","COMBUSTÍVEL"]
[]
[null,null,null,"FROTA BASE",null,null,null,null,null,null,null,"Quantidade","Quantidade",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1,null,15,15]
[null,null,null,"Pesado",null,null,null,null,null,null,null,70,70,null,66,66,null,52,52]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,74,74,null,69,69,null,71,69]
[]
[null,null,null,"Consumo (L-KM)","Inferior","Vlr Uso","Superior","Calculo PMC",null,"( IE  )",null,"Empresa","Calculo PMC",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,null,0.3,0.3]
[null,null,null,"Leve",0.33,0.37,0.39,0.36,null,null,null,0.37,0.36,null,0.39,0.36,null,0.39,0.36]
[null,null,null,"Pesado",0.43,0.47499999999999998,0.53,0.48,null,null,null,0.47499999999999998,0.48,null,0.5,0.48,null,0.5,0.48]
[null,null,null,"Articulado",0.53,0.59,0.65,0.59,null,null,null,0.59,0.59,null,0.65,0.59,null,0.65,0.59]
[]
[null,null,null,"Custo Combustível",null,null,null,null,null,"( IE  )",null,"Empresa","Calculo PMC",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,1.0599295774647887E-2,9.26086956521739E-3]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1.0484782608695653E-2,9.678260869565216E-3,null,0.20668626760563383,0.16669565217391302]
[null,null,null,"Pesado",null,null,null,null,null,null,null,0.78856418918918914,0.79686486486486485,null,0.88717391304347826,0.85168695652173909,null,0.9186056338028169,0.7705043478260869]
[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,2.2965140845070425E-2,1.821304347826087E-2]
[null,null,null,"Total",null,null,null,null,null,null,"VA_11",0.83077905405405394,0.83907972972972966,null,0.92319855072463763,0.88529202898550718,null,1.1588563380281691,0.96467391304347816]
[]
[null,null,"VA_12","LUBRIFICANTES"]
[]
[null,null,null,"Consumo (L-KM)","Inferior","Vlr Uso","Superior","Calculo PMC",null,"( IE  )",null,"Empresa","Calculo PMC",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,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,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,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,0.06,0.05]
[]
[null,null,null,"Custo Lubrificantes",null,null,null,null,null,"( FS)",null,"Empresa","Calculo PMC",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,2.1813043478260872E-3,1.5434782608695651E-3]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1.6130434782608695E-3,1.3442028985507246E-3,null,3.2719565217391312E-2,2.3152173913043479E-2]
[null,null,null,"Pesado",null,null,null,null,null,null,null,9.9608108108108107E-2,8.3006756756756755E-2,null,0.10646086956521739,8.8717391304347831E-2,null,0.11342782608695652,8.0260869565217399E-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,2.1813043478260872E-3,1.5434782608695651E-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,0.15051000000000003,0.10650000000000001]
[]
[null,null,"VA_13","RODAGEM"]
[]
[null,null,null,"Vida Util","Inferior","Vlr Uso","Superior","Calculo PMC",null,"( IE  )",null,"Empresa","Calculo PMC",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,105000,105000]
[null,null,null,"Leve",85000,100000,125000,105000,null,null,null,100000,105000,null,105000,105000,null,105000,105000]
[null,null,null,"Pesado",105000,100000,125000,115000,null,null,null,100000,115000,null,105000,115000,null,105000,115000]
[null,null,null,"Articulado",105000,100000,125000,115000,null,null,null,100000,115000,null,105000,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,"Valor Indiv","Valor Indiv"]
[null,null,null,"Micro",null,null,null,null,null,null,null,8004,8004,null,7878,7878,null,7878,7878]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,14625,14625,null,14625,14625]
[null,null,null,"Pesado",null,null,null,null,null,null,null,13410,13410,null,14454,14454,null,14454,14454]
[null,null,null,"Articulado",null,null,null,null,null,null,null,23400,23400,null,24090,24090,null,24090,24090]
[]
[null,null,null,"Pneus","Quantidade",null,null,null,null,"( IE  )",null,"Valor Indiv","Valor Indiv",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,738,738,"ok"]
[null,null,null,"Leve",6,null,null,null,null,null,null,0,0,null,1475,1475,null,1475,1475,"ok"]
[null,null,null,"Pesado",6,null,null,null,null,null,null,1310,1310,null,1419,1419,null,1419,1419,"ok"]
[null,null,null,"Articulado",10,null,null,null,null,null,null,1350,1350,null,1419,1419,null,1419,1419,"ok"]
[]
[null,null,null,"Camara de Ar","Quantidade",null,null,null,null,"( IE  )",null,"Valor Indiv","Valor Indiv",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,0,0]
[null,null,null,"Leve",12,null,null,null,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Pesado",12,null,null,null,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Articulado",20,null,null,null,null,null,null,0,0,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,"Valor Indiv","Valor Indiv"]
[null,null,null,"Micro",12,null,null,null,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Leve",12,null,null,null,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Pesado",12,null,null,null,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Articulado",20,null,null,null,null,null,null,0,0,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,"Valor Indiv","Valor Indiv"]
[null,null,null,"Micro",15,null,null,null,null,null,null,230,230,null,230,230,null,230,230]
[null,null,null,"Leve",15,null,null,null,null,null,null,0,0,null,385,385,null,385,385]
[null,null,null,"Pesado",15,null,null,null,null,null,null,370,370,null,396,396,null,396,396]
[null,null,null,"Articulado",25,null,null,null,null,null,null,396,396,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,"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,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,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,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,0.22942857142857143,0.20947826086956522]
[]
[null,null,null,"FROTA OPERANTE",null,null,null,null,null,"FR_03",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1,null,15,15]
[null,null,null,"Pesado",null,null,null,null,null,null,null,67,67,null,56,56,null,45,45]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,71,71,null,59,59,null,62,62]
[]
[null,null,null,"Custo Rodagem Frota operante",null,null,null,null,null,"( FS)",null,"Custo KM","Custo KM",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,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,2.0892857142857144,2.0892857142857144]
[null,null,null,"Pesado",null,null,null,null,null,null,null,8.9847000000000001,7.8127826086956524,null,7.7088000000000001,7.0384695652173921,null,6.1945714285714288,5.655913043478261]
[null,null,null,"Articulado",null,null,null,null,null,null,null,0.46800000000000003,0.40695652173913044,null,0.22942857142857143,0.20947826086956522,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,8.5883142857142847,8.029705590062111]
[]
[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,0.13852119815668201,0.12951138048487276]
[]
[]
[null,null,"VA_14","PEÇAS E ACESSÓRIOS"]
[]
[null,null,null,"Indice de consumo","Inferior","Vlr Uso","Superior","Calculo PMC",null,"( IE  )",null,"Empresa","Calculo PMC",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,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,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,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,8.3000000000000001E-3,5.8149999999999999E-3]
[]
[null,null,null,"FROTA OPERANTE",null,null,null,null,null,"FR_03",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1,null,15,15]
[null,null,null,"Pesado",null,null,null,null,null,null,null,67,67,null,56,56,null,52,45]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,71,71,null,59,59,null,69,62]
[]
[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,"KM (média)","KM (média)"]
[null,null,null,null,null,null,null,null,null,null,null,5759,5759,null,5193,5193,null,5202,5107]
[]
[null,null,null,"Custo Peças e acessórios",null,null,null,null,null,"( FS)",null,"Empresa","Calculo PMC",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,4.2895003900395058E-3,3.4067497253927252E-3]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,5.9151928769823779E-3,4.1441983830906659E-3,null,3.7690682513414578E-2,2.9934190611242001E-2]
[null,null,null,"Pesado",null,null,null,null,null,null,null,0.32367896495549092,0.22677026279713006,null,0.34687993947523882,0.24302492145162816,null,0.27214212632822382,0.18704170892497329]
[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,7.3664034262184552E-3,5.8504465712778779E-3]
[null,null,null,"Total",null,null,null,null,null,null,null,0.34385741653281388,0.2409073345949774,null,0.36645023783646175,0.25673591964084636,null,0.32148871265789636,0.22623309583288589]
[]
[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,0.32148871265789636,0.22623309583288589]
[]
[null,"CP","CUSTO DE PESSOAL"]
[]
[null,null,null,"FROTA OPERANTE",null,null,null,null,null,"FR_03",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Micro",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Leve",null,null,null,null,null,null,null,0,0,null,1,1,null,15,15]
[null,null,null,"Pesado",null,null,null,null,null,null,null,67,67,null,56,56,null,45,45]
[null,null,null,"Articulado",null,null,null,null,null,null,null,2,2,null,1,1,null,1,1]
[null,null,null,"Total",null,null,null,null,null,null,null,71,71,null,59,59,null,62,62]
[]
[]
[null,null,"PE_01","ENCARGOS DE PESSOAL",null,null,null,null,null,null,null,0.82369999999999999,0.82369999999999999,null,0.82369999999999999,0.82369999999999999,null,0.57820000000000005,0.57820000000000005,"ok"]
[]
[null,null,"PE_02","PESSOAL DIRETO",null,null,null,null,null,null,null,4,0,null,4,0,null,4,0]
[]
[null,null,null,"Fatores de utilização","Inferior","Vlr Uso","Superior","Calculo PMC",null,"( IE  )",null,"Empresa","Calculo PMC",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,null,2.8,2,"ok"]
[null,null,null,"Cobrador",2.2000000000000002,2.65,2.8,2,null,null,null,2.65,2,null,2.8,1.55,null,2.8,1,"ok"]
[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,null,0.35,0.15,"ok"]
[null,null,null,"Bilheteiro",0.08,0.08,0.08,0.08,null,null,null,0.08,0.08,null,0.08,0.08,null,0.08,0.08,"ok"]
[]
[null,null,null,"Numero de Funcionários",null,null,null,null,null,"( FS)",null,"Quantidade","Quantidade",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,173.6,124]
[null,null,null,"Cobrador",null,null,null,null,null,null,null,188.15,142,null,165.2,91,null,173.6,62]
[null,null,null,"Fiscal/Despachante",null,null,null,null,null,null,null,21.3,21,null,20.65,18,null,21.7,9]
[null,null,null,"Bilheteiro",null,null,null,null,null,null,null,5.68,6,null,4.72,5,null,4.96,5]
[null,null,null,"TOTAL",null,null,null,null,"BC TF",null,null,403.28,311,null,355.77,232,null,373.86,200]
[]
[null,null,null,"Salário com incidencia de encargos",null,null,null,null,null,"( IE  )",null,"Valor","Valor",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,1642.14,1642.14,"ok"]
[null,null,null,"Cobrador",null,null,null,null,null,null,null,766.69,766.69,null,736.78,736.78,null,845.27,845.27,"ok"]
[null,null,null,"Fiscal/Despachante",null,null,null,null,null,null,null,1755.54,1755.54,null,1648.83,1648.83,null,1326.33,1326.33,"ok"]
[null,null,null,"Bilheteiro",null,null,null,null,null,null,null,691.01,691.01,null,689.92,689.92,null,794.91,794.91,"ok"]
[]
[null,null,null,"Custo Mensal Pessoal Direto",null,null,null,null,null,"( FS)",null,"Valor","Valor",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,449906.16041280003,321361.54315200006]
[null,null,null,"Cobrador",null,null,null,null,"BC P2",null,null,263073.69184695004,198546.18252600002,null,221973.57132719998,122273.577426,null,231583.28779040001,82708.317068000004]
[null,null,null,"Fiscal/Despachante",null,null,null,null,"BC P3",null,null,68193.6177474,67233.144258,null,62093.95674614999,54125.482878000003,null,45422.743930199998,18838.926054]
[null,null,null,"Bilheteiro",null,null,null,null,"BC P4",null,null,7157.9072421600004,7561.1696219999994,null,5938.7375308799992,6291.0355200000004,null,6222.4537315200005,6272.6348099999996]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,820837.35843411006,637425.131574,null,760131.21386223007,518493.63029399997,null,733134.64586491999,429181.42108400003]
[]
[null,null,"PE_03","PESSOAL INDIRETO"]
[]
[null,null,null,"Fatores de utilização","Inferior","Vlr Uso","Superior","Calculo PMC",null,"( IE  )",null,"Empresa","Calculo PMC",null,"Empresa","Calculo PMC",null,"Empresa","Calculo PMC"]
[null,null,null,"Manutenção",0.08,0.15,0.15,0.15,null,null,null,0.15,0.15,null,0.15,0.15,null,0.15,0.15]
[null,null,null,"Pessoal administrativo",0.08,0.12,0.13,0.13,null,null,null,0.13,0.13,null,0.13,0.13,null,0.13,0.22500000000000001]
[]
[null,null,null,"Numero de Funcionários",null,null,null,null,null,null,null,"Quantidade","Quantidade",null,"Quantidade","Quantidade",null,"Quantidade","Quantidade"]
[null,null,null,"Manutenção",null,"REVER CRITÉRIO",null,null,null,"( FS  )",null,60,47,null,53,35,null,56,30]
[null,null,null,"Pessoal administrativo",null,"REVER CRITÉRIO",null,null,null,null,null,52,40,null,46,30,null,49,45]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,112,87,null,99,65,null,105,75]
[]
[null,null,null,"Salário com incidencia de encargos",null,null,null,null,null,null,null,"Valor","Valor",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Manutenção",null,"REVER CRITÉRIO",null,null,null,"( IE  )",null,2052.0933960852749,2034.3355262999999,null,2151.3147562138588,2222.115558402857,null,1963.7535157096072,2145.9071054199999]
[null,null,null,"Pessoal administrativo",null,"REVER CRITÉRIO",null,null,null,null,null,2052.0933960852753,2071.6316776154999,null,2148.1969087410853,2246.8057312739998,null,1945.0511012742777,2145.9071054200003]
[]
[null,null,null,"Custo Mensal Pessoal Direto",null,null,null,null,null,null,null,"Valor","Valor",null,"Valor","Valor",null,"Valor","Valor"]
[null,null,null,"Manutenção",null,"REVER CRITÉRIO",null,null,"BC P5","( FS  )",null,123125.60376511651,95613.769736100003,null,114019.68207933451,77774.04454409999,null,109970.196879738,64377.213162600005]
[null,null,null,"Pessoal administrativo",null,"REVER CRITÉRIO",null,null,"BC P6",null,null,106708.85659643431,82865.267104619998,null,98817.057802089912,67404.171938219995,null,95307.503962439601,96565.819743900007]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,229834.46036155082,178479.03684071999,null,212836.73988142441,145178.21648231999,null,205277.70084217761,160943.03290650001]
[]
[null,null,null,"TOTAL DESPESAS DE PESSOAL",null,null,null,null,null,null,null,1050671.818795661,815904.16841471998,null,972967.95374365454,663671.8467763199,null,938412.3467070976,590124.45399050007]
[]
[null,null,null,"Honorários diretoria",null,null,null,null,"BC P8","( IE  )",null,5700,5700,null,6696.03,6696.03,null,8600.74,8600.74,"ok"]
[null,null,null,"Benefícios sociais",null,null,null,null,"BC P9",null,null,12708.61,12708.61,null,51109.36,51109.36,null,60371.11,60371.11,"ok"]
[]
[]
[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,"KM","KM"]
[null,null,null,null,null,null,null,null,null,null,null,408876,408876,null,306358,306358,null,322515,316646]
[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,1.3949929783507744,1.0148921608104953]
[null,null,null,"Cobrador",null,null,null,null,"CP 52","BC P2",null,0.64340702767330449,0.48559020956475807,null,0.72455614453417239,0.39911991012475601,null,0.71805431620358739,0.26120120597765328]
[null,null,null,"Fiscal/Despachante",null,null,null,null,"CP 53","BC P3",null,0.16678312678513779,0.16443406866140345,null,0.2026842998914668,0.17667396600708976,null,0.14083916695409515,5.949522828016144E-2]
[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,1.9293532801637134E-2,1.9809613290551593E-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,0.34097699914651408,0.2033097312538292]
[null,null,null,"Pessoal administrativo",null,null,null,null,"CP 56","BC P6",null,0.26098097368501527,0.20266600902136589,null,0.3225541941195918,0.22001766540524484,null,0.29551339926031223,0.30496459688074384]
[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,2.6667720881199324E-2,2.7162004257119936E-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,0.18718853386664186,0.1906580534729635]
[]
[null,null,null,"TOTAL",null,null,null,null,null,null,"PE_11",2.6146812940736579,2.0405031804623412,null,3.3646039722927243,2.3550135357206927,null,3.1235266474647614,2.0814925942235183]
[]
[null,null,null,"Total de funcionários",null,null,null,null,null,null,null,515.28,398,null,454.77,297,null,478.86,275,"ok"]
[]
[]
[null,"DA","DESPESAS ADMINISTRATIVAS"]
[]
[null,null,"DA_01","DESPESAS MENSAIS",null,null,null,"Valor Ano",null,"( IE  )",null,"Valor mês","Valor mês",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,"( IE  )",237026.76,null,null,null,19752.23,19752.23,null,14360.42,14360.42,null,13848.68,13848.68,"ok"]
[null,null,null,"Serviços de Atendimento ao Passageiro - SAC",null,null,"( IE  )",0,null,null,null,0,0,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,"( IE  )",0,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Serviço de Manutenção de Abrigos e Terminais",null,null,"( IE  )",43094.399999999994,null,null,null,3591.2,3591.2,null,179.12,179.12,null,1181,1181,"ok"]
[null,null,null,"TOTAL",null,null,null,280121.15999999997,null,null,null,23343.43,23343.43,null,14539.54,14539.54,null,15029.68,15029.68]
[]
[null,null,null,"Despesas Administrativas Gerais",null,null,null,"Valor Ano",null,"( IE  )",null,"Valor mês","Valor mês",null,"Valor mês","Valor mês",null,"Valor mês","Valor mês"]
[null,null,null,"Veículo de Apoio",null,null,"( IE  )",30993.600000000002,null,null,null,2582.8000000000002,2582.8000000000002]
[null,null,null,"Treinamento",null,null,"( IE  )",16455.12,null,null,null,1371.26,1371.26]
[null,null,null,"Atualização Tecnológica",null,null,"( IE  )",618046.19999999995,null,null,null,51503.85,51503.85]
[null,null,null,"Assessoria Técnica",null,null,"( IE  )",142846.44,null,null,null,11903.87,11903.87]
[null,null,null,"Manutenção e Segurança",null,null,"( IE  )",239620.80000000002,null,null,null,19968.400000000001,19968.400000000001]
[null,null,null,"Serviço de Utilidade Pública",null,null,"( IE  )",106242.24000000001,null,null,null,8853.52,8853.52]
[null,null,null,"Representação Viagens e Estadias",null,null,"( IE  )",1797.84,null,null,null,149.82,149.82]
[null,null,null,"Material de Consumo",null,null,"( IE  )",75793.919999999998,null,null,null,6316.16,6316.16]
[null,null,null,"Outras Despesas Administrativas",null,null,"( IE  )",682712.04000000027,null,null,null,56892.67,56892.67]
[null,null,null,"TOTAL",null,null,null,1914508.2,null,null,null,159542.35,169542.35,null,161673.75,161673.75,null,166536.18,166536.18,"ok"]
[]
[null,null,null,"Encargos Financeiros",null,null,null,"Valor Ano",null,"( IE  )",null,"Valor mês","Valor mês",null,"Valor mês","Valor mês",null,"Valor mês","Valor mês"]
[null,null,null,"Juros Pagos",null,null,"( IE  )",1074816.672,null,null,null,89568.055999999997,0,null,16590.919999999998,0,null,36464.86]
[null,null,null,"Despesas Bancárias",null,null,"( IE  )",4416,null,null,null,368,5930,null,0,4657,null,368,4757,"ok"]
[null,null,null,"Seguro Garantia",null,null,"( IE  )",0,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"TOTAL",null,null,null,1079232.672,null,null,null,89936.055999999997,5930,null,16590.919999999998,4657,null,36832.86,4757]
[]
[null,null,null,"FATURAMENTO ESTIMADO",null,null,null,null,null,null,null,null,1976522.5301639999,null,null,1552341.4137139998,null,null,1526922.1606818181]
[null,null,null,null,null,null,null,null,null,null,null,null,5929.5675904919999,null,null,4657.0242411419995,null,null,4580.7664820454547]
[]
[null,null,null,"Outros Custos Operacionais",null,null,null,"Valor Ano",null,"( IE  )",null,"Valor mês","Valor mês",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,"( IE  )",20552.64,null,null,null,1712.72,1712.72]
[null,null,null,"Conserto de Pneus",null,null,"( IE  )",15420,null,null,null,1285,1285]
[null,null,null,"Vistoria do Poder Concedente",null,null,"( IE  )",33600,null,null,null,2800,2800,null,1692.56,1692.56,null,2232.94,2232.94]
[null,null,null,"TOTAL",null,null,null,69572.639999999999,null,null,null,5797.72,5797.72,null,1692.56,1692.56,null,2232.94,2232.94]
[]
[null,null,null,"GRIS - Gerenciamento de Riscos",null,null,null,"Valor Ano",null,"( IE  )",null,"Valor mês","Valor mês",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,"( IE  )",176340,null,null,null,14695,14695,null,11661.666666666666,11661.666666666666,null,11661.666666666666,11661.666666666666,"ok"]
[null,null,null,"Despesa Anual com o Seguro Obrigatório",null,null,"( IE  )",null,null,null,null,null,null,null,1904.15,1904.15,null,1904.15,1904.15,"ok"]
[null,null,null,"Despesas Anual com Emplacamento",null,null,"( IE  )",25449.8,null,null,null,2120.8166666666666,2120.8166666666666,null,291.66666666666669,291.66666666666669,null,291.66666666666669,291.66666666666669,"ok"]
[null,null,null,"Despesa Anual com o IPVA Por Veículo",null,null,"( IE  )",4480,null,null,null,373.33333333333331,373.33333333333331,null,0,0,null,0,0]
[null,null,null,null,null,null,"( IE  )",0,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,null,null,null,"( IE  )",0,null,null,null,0,0,null,0,0,null,0,0]
[null,null,null,"Receitas Complementar",null,null,"( IE  )",-13200,null,null,null,-1100,-1100,null,-225,-225,null,-8075,-8075,"ok"]
[null,null,null,"TOTAL",null,null,null,193069.8,null,null,null,16089.15,16089.15,null,13632.483333333332,13632.483333333332,null,5782.4833333333318,5782.4833333333318]
[]
[null,null,null,"TOTAL DE DESPESAS ADMINISTRATIVAS",null,null,null,null,null,null,null,294708.70600000001,220702.65,null,208129.25333333333,196195.33333333334,null,226414.14333333331,194338.28333333333]
[]
[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,"KM","KM"]
[null,null,null,null,null,null,null,null,null,null,null,408876,408876,null,306358,306358,null,322515,316646]
[]
[null,null,null,"DESPESAS ADMINISTRATIVAS POR KM",null,null,null,null,null,null,"DA_01",0.7207777076668721,0.53977893053150594,null,0.67936614461947564,0.64041197988410081,null,0.70202670676816059,0.61373989670904838]
[]
[]
[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,"Empresa  SET/2012","Calculo PMC SET/2012"]
[]
[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,0.97050000000000003,0.93380757630345745]
[]
[null,null,"GA","GASTOS VARIÁVEIS",null,null,null,null,null,null,"C_GA",1.4153277381925018,1.285655321695016,null,1.5391274810550462,1.3612569674704422,null,1.7693762488427476,1.4269183893612369]
[null,null,null,"COMBUSTÍVEL",null,null,null,null,null,"VA_11",null,0.83077905405405394,0.83907972972972966,null,0.92319855072463763,0.88529202898550718,null,1.1588563380281691,0.96467391304347816]
[null,null,null,"LUBRIFICANTES",null,null,null,null,null,"VA_12",null,0.1053,8.7749999999999995E-2,null,0.1113,9.2749999999999999E-2,null,0.15051000000000003,0.10650000000000001]
[null,null,null,"RODAGEM",null,null,null,null,null,"VA_13",null,0.1353912676056338,0.11791825737030882,null,0.13817869249394674,0.12647901884408885,null,0.13852119815668201,0.12951138048487276]
[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,0.32148871265789636,0.22623309583288589]
[]
[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,3.1235266474647614,2.0814925942235183]
[]
[null,null,"DA","DESPESAS ADMINISTRATIVAS",null,null,null,null,null,"DA_01","C_DA",0.7207777076668721,0.53977893053150594,null,0.67936614461947564,0.64041197988410081,null,0.70202670676816059,0.61373989670904838]
[]
[null,null,null,"TOTAL",null,null,null,null,null,null,"SOMA",5.7653867399330316,4.769053118924349,null,6.6842975979672463,5.4016670637110646,null,6.5654296030756694,5.0559584565972608]
[]
[null,null,null,"IMPOSTOS"]
[null,null,null,"% DE PIS E COFINS",null,null,null,null,null,null,null,3.6499999999999998E-2,3.6499999999999998E-2,null,3.6499999999999998E-2,3.6499999999999998E-2,null,3.6499999999999998E-2]
[null,null,null,"% DE INSS S/FATURAMENTO",null,null,null,null,null,null,null,null,null,null,null,null,null,0.02,0.02]
[null,null,null,"Valor PIS E COFINS",null,null,null,null,null,null,null,0.21840852725226326,0.18066470040554097,null,0.25321936930545352,0.20462983687125463,null,0.25398853260441112,0]
[null,null,null,"Valor INSS S/FATURAMENTO",null,null,null,null,null,null,null,0,0,null,0,0,null,0.13917179868734858,0.10318282564484205]
[]
[null,null,"CK","CUSTO TOTAL POR QUILOMETRO",null,null,null,null,null,null,"TOTAL",5.983795267185295,4.9497178193298899,null,6.9375169672726997,5.6062969005823193,null,6.9585899343674287,5.1591412822421026]
[]
[null,null,null,"INDICE PASSAGEIRO QUILOMETRO",null,null,null,null,null,null,"IPK",2.3127,2.3813,null,2.4961000000000002,2.4961000000000002,null,2.4456994953018394,2.3754552537431635]
[]
[null,null,null,"MPE - MÉDIA PASSAGEIROS EQUIVALENTES ",null,null,null,null,null,null,null,null,null,null,null,null,null,788774.77272727271,781155.67700403044]
[null,null,null,"MEDIA KM PERCORRIDOS",null,null,null,null,null,null,null,null,null,null,null,null,null,322515,316646]
[null,null,null,"I P K - atual",null,null,null,null,null,null,null,null,null,null,null,null,null,2.4456994953018394,2.4669684032137797]
[null,null,null," Novas Gratuidades - acima 60 anos - Reflexo na MPE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,-28977.272727272724]
[null,null,null,"MPE - Média Passag Equiv. c/Gratuidades",null,null,null,null,null,null,null,null,null,null,null,null,null,788774.77272727271,752178.40427675773]
[null,null,null,"Novo IPK",null,null,null,null,null,null,null,null,null,null,null,null,null,2.4456994953018394,2.3754552537431635]
[]
[null,null,null,"VALAOR DA TARIFA",null,null,null,null,null,null,"TAR",2.587363370599427,2.0785780117288413,null,2.7793425613047149,2.2460225554193816,null,2.845235053503016,2.1718537000907507]
[]
[]
[]
[]
[]
[]
[]
[null,null,"LF","LF","LF","LF","LF","LF","LF","LF","LF","LF","LF","LF","LF","LF",null,"LF","LF"]

{"sheet":"publicar","index":3,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[[5,9,5,10],[5,3,5,4],[5,6,5,7]]}
[]
[null,"PREFEITURA MUNICIPAL DE CHAPECO"]
[]
[null,null,"RESUMO PLANILHA APURAÇÃO DE CUSTO TARIFA"]
[]
[null,null,"Discriminação","NOVEMBRO DE 2010",null,null,"SETEMBRO DE 2012",null,null,"MAIO DE 2013"]
[null,null,null,"AVC/TTT","PMC",null,"AVC","PMC",null,"AVC","PMC"]
[]
[null,null,"CUSTOS DE OPERAÇÃO","Custo KM","Custo KM",null,"Custo KM","Custo KM",null,"Custo KM","Custo KM",null,null,"TARIFA R$"]
[]
[null,null,"FROTA BASE",74,74,null,69,69,null,69,69]
[null,null,"MÉDIA PERCURSO TOTAL (KM MÉDIA MÊS)",408876,408876,null,306358,306358,null,322515,316646,null,3.3581626724289881E-2]
[null,null,"NÚMERO DE PASSAGEIROS EQUIVALENTES",945607.52520000003,973656.41879999998,null,764700.20380000002,764700.20380000002,null,788774.77272727271,752178.40427675773,null,-1.6374782510869101E-2]
[]
[null,null,"CAPITAL - REMUNERAÇÃO E DEPRECIAÇÃO",1.0145999999999999,0.90311568623548566,null,1.1012,1.0449845806358278,null,0.97050000000000003,0.93380757630345745,null,-0.10639104766954932,0.39310678440774438]
[null,null,"Veiculos",0.64939999999999998,0.51861043676612917,null,0,0.61841003979834319,null,0,0.52109267328276521,null,null,0.21936539215447004]
[null,null,"Validadores, SBE, SM, Maq Equip",0.1822,0.15675275134010505,null,0,0.19405509879309049,null,0,0.18775014355480132,null,null,7.9037541649732562E-2]
[null,null,"Outros investimentos",0.183,0.22775249812925152,null,0,0.23251944204439412,null,0,0.2249647594658909,null,null,9.4703850603541737E-2]
[]
[null,null,"GASTOS VARIÁVEIS",1.4153277381925018,1.285655321695016,null,1.5391274810550462,1.3612569674704422,null,1.7693762488427476,1.4269183893612369,null,4.8235875708912079E-2,0.60069259865566671]
[null,null,"Combustíveis",0.83077905405405394,0.83907972972972966,null,0.92319855072463763,0.88529202898550718,null,1.1588563380281691,0.96467391304347816,null,null,0.40610064598075551]
[null,null,"Lubrificantes",0.1053,8.7749999999999995E-2,null,0.1113,9.2749999999999999E-2,null,0.15051000000000003,0.10650000000000001,null,null,4.4833511316275415E-2]
[null,null,"Rodagem",0.1353912676056338,0.11791825737030882,null,0.13817869249394674,0.12647901884408885,null,0.13852119815668201,0.12951138048487276,null,null,5.4520656737605575E-2]
[null,null,"Peças e Acessórios",0.34385741653281388,0.2409073345949774,null,0.36645023783646175,0.25673591964084636,null,0.32148871265789636,0.22623309583288589,null,null,9.5237784621030136E-2]
[]
[null,null,"CUSTO DE PESSOAL",2.6146812940736579,2.0405031804623412,null,3.3646039722927243,2.3550135357206927,null,3.1235266474647614,2.0814925942235183,null,-0.11614410590360802,0.87624996974519787]
[null,null,"PESSOAL DIRETO"]
[null,null,"Motorista",1.1798494937281718,0.89045244809673363,null,1.5345607043328393,1.0961147888091709,null,1.3949929783507744,1.0148921608104953,null,null,0.42724111902813655]
[null,null,"Cobrador",0.64340702767330449,0.48559020956475807,null,0.72455614453417239,0.39911991012475601,null,0.71805431620358739,0.26120120597765328,null,null,0.10995837769036529]
[null,null,"Fiscal/Despachante",0.16678312678513779,0.16443406866140345,null,0.2026842998914668,0.17667396600708976,null,0.14083916695409515,5.949522828016144E-2,null,null,2.5045821505755933E-2]
[null,null,"Bilheteiro",1.7506303236580284E-2,1.8492573841458044E-2,null,1.9384959853765853E-2,2.0534915099328237E-2,null,1.9293532801637134E-2,1.9809613290551593E-2,null,null,8.3392912829388238E-3]
[null,null,"PESSOAL INDIRETO"]
[null,null,"Manutenção",0.30113189271347918,0.23384539502465296,null,0.37217791629183672,0.25386653700605172,null,0.34097699914651408,0.2033097312538292,null,null,8.5587691426079471E-2]
[null,null,"Pessoal administrativo",0.26098097368501527,0.20266600902136589,null,0.3225541941195918,0.22001766540524484,null,0.29551339926031223,0.30496459688074384,null,null,0.12838153713911923]
[null,null,"Honorários diretoria",1.3940656825052094E-2,1.3940656825052094E-2,null,2.1856879859510767E-2,2.1856879859510767E-2,null,2.6667720881199324E-2,2.7162004257119936E-2,null,null,1.1434441551495846E-2]
[null,null,"Benefícios sociais",3.1081819426916721E-2,3.1081819426916721E-2,null,0.16682887340954047,0.16682887340954047,null,0.18718853386664186,0.1906580534729635,null,null,8.0261690121306586E-2]
[]
[null,null,"DESPESAS ADMINISTRATIVAS",0.72077770766687221,0.53977893053150594,null,0.67936614461947564,0.6404119798841007,null,0.7020267067681607,0.61373989670904849,null,-4.1648320163965691E-2,0.25836727328032705]
[null,null,"Serviços de Bilhetagem Eletrônica - SBE",4.8308607010438369E-2,4.8308607010438369E-2,null,4.6874636862755337E-2,4.6874636862755337E-2,null,4.2939646218005362E-2,4.3735528002880192E-2,null,null,1.8411429949675203E-2]
[null,null,"Serviços de Atendimento ao Passageiro - SAC",0,0,null,0,0,null,0,0,null,null,0]
[null,null,"Serviço Especial de Atendimento a PPDLSevera",0,0,null,0,0,null,0,0,null,null,0]
[null,null,"Serviço de Manutenção de Abrigos e Terminais",8.7831029456363289E-3,8.7831029456363289E-3,null,5.8467544506753534E-4,5.8467544506753534E-4,null,3.6618451854952484E-3,3.7297170973263519E-3,null,null,1.5701062318261678E-3]
[null,null,"Despesas Administrativas Gerais",0.39019739480918431,0.41465468748471429,null,0.52772818075584771,0.52772818075584771,null,0.51636723873308221,0.5259380506938347,null,null,0.22140516006987671]
[null,null,"Encargos Financeiros",0.21995924436748548,1.4503174556589284E-2,null,5.4155334608529886E-2,1.5201169873154936E-2,null,0.11420510673922143,1.5023085717173121E-2,null,null,6.32429749771133E-3]
[null,null,"Outros custos operacionais",1.4179653489077374E-2,1.4179653489077374E-2,null,5.5247782006671931E-3,5.5247782006671931E-3,null,6.9235229369176629E-3,7.0518496996646099E-3,null,null,2.9686308292073862E-3]
[null,null,"Despesa Anual c/Seguro Responsab. cívil",3.5939991586691318E-2,3.5939991586691318E-2,null,3.8065487653877704E-2,3.8065487653877704E-2,null,3.6158524926489202E-2,3.6828719347999549E-2,null,null,1.5503857330070132E-2]
[null,null,"Despesa Anual com o Seguro Obrigatório",0,0,null,6.2154407588507557E-3,6.2154407588507557E-3,null,5.9040664775281762E-3,6.0134977230092909E-3,null,null,2.5315137860557131E-3]
[null,null,"Despesas Anual com Emplacamento",5.1869433927808593E-3,5.1869433927808593E-3,null,9.5204521072296685E-4,9.5204521072296685E-4,null,9.0435070203453071E-4,9.2111274630554847E-4,null,null,3.8776261723056651E-4]
[null,null,"Despesa Anual com o IPVA Por Veículo",9.1307225988645287E-4,9.1307225988645287E-4,null,0,0,null,0,0,null,null,0]
[null,null,"Receitas Complementar",-2.6903021943082989E-3,-2.6903021943082989E-3,null,-7.3443487684343159E-4,-7.3443487684343159E-4,null,-2.503759515061315E-2,-2.5501664319145041E-2,null,null,-1.0735485031326254E-2]
[]
[null,null,"TOTAL",5.7653867399330316,4.769053118924349,null,6.6842975979672463,5.4016670637110629,null,6.5654296030756703,5.0559584565972608,null,-6.4000354526902781E-2,2.1284166260889359]
[]
[null,null,"IMPOSTOS"]
[null,null,"% DE PIS E COFINS",3.6499999999999998E-2,3.6499999999999998E-2,null,3.6499999999999998E-2,3.6499999999999998E-2,null,3.6499999999999998E-2]
[null,null,"% DE INSS S/FATURAMENTO",0,0,null,0,0,null,0.02,0.02]
[null,null,"Valor PIS E COFINS",0.21840852725226326,0.18066470040554097,null,0.25321936930545352,0.20462983687125463,null,0.25398853260441118,0,null,null,0]
[null,null,"Valor INSS S/FATURAMENTO",0,0,null,0,0,null,0.13917179868734861,0.10318282564484205,null,null,4.3437074001815013E-2]
[]
[null,null,"CUSTO TOTAL POR QUILOMETRO",5.983795267185295,4.9497178193298899,null,6.9375169672726997,5.6062969005823176,null,6.9585899343674296,5.1591412822421026,null,-7.9759532231296837E-2,2.1718537000907507]
[]
[]
[null,null,"CUSTO TOTAL POR QUILOMETRO",5.983795267185295,4.9497178193298899,null,6.9375169672726997,5.6062969005823176,null,6.9585899343674296,5.1591412822421026]
[]
[null,null,"INDICE PASSAGEIRO QUILOMETRO",2.3127,2.3813,null,2.4961000000000002,2.4961000000000002,null,2.4456994953018394,2.3754552537431635,null,-4.8333298448314022E-2]
[]
[null,null,"VALOR DA TARIFA CÁLCULADA",2.587363370599427,2.0785780117288413,null,2.7793425613047149,2.2460225554193811,null,2.8452350535030164,2.1718537000907507,null,-3.3022310995795556E-2,0]
[]
[null,null,"AUMENTO DE ESTUDANTES DE 20% - 40%"]
[null,null,"MEDIA PASSAGEIROS EQUIVALENTES",null,null,null,null,null,null,null,752934.31818181812]
[null,null,"AUMENTO PASSES ESTUDANTES 20 40 ",null,null,null,null,null,null,null,-16276.484848484852]
[null,null,"TOTAL",null,null,null,null,null,null,null,736657.83333333326]
[null,null,"MÉDIA KM PERCORRIDOS",null,null,null,null,null,null,null,316646]
[null,null,"NOVO IPK",null,null,null,null,null,null,null,2.3264397255399825]
[]
[null,null,"CUSTO TOTAL POR QUILOMETRO",null,null,null,null,null,null,null,5.1591412822421026]
[]
[null,null,"VALOR DA TARIFA CÁLCULADA",null,null,null,null,null,null,null,2.2176122706315251,null,null,2.1068900975633076E-2]
[]
[]
[null,null,"REDUÇÃO DA TARIFA EMBARCADO PARA "]
[null,null,"Media Passageiros Equivalentes - Embarcado de 2,50 para 2,40",null,2.4,null,null,null,null,null,729978.87499999988]
[null,null,"MÉDIA KM PERCORRIDOS",null,null,null,null,null,null,null,316646]
[null,null,"NOVO IPK",null,null,null,null,null,null,null,2.305346901587261]
[]
[null,null,"CUSTO TOTAL POR QUILOMETRO",null,null,null,null,null,null,null,5.1591412822421026]
[]
[null,null,"VALOR DA TARIFA CÁLCULADA",null,null,null,null,null,null,null,2.2379023645812124,null,null,3.0411194127717645E-2]