{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["LOTES LICITAÇÃO"],"not_rendered":{"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"LOTES LICITAÇÃO","index":0,"n_rows":96,"n_cols":25,"rows_kept":96,"merged":[[0,0,0,21],[1,0,1,21],[2,0,2,21],[3,0,3,21],[4,0,4,21],[6,0,7,21],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,7],[9,8,10,8],[9,9,10,9],[9,10,9,12],[9,13,9,16],[9,17,10,17],[9,18,9,21],[14,0,14,9],[16,0,17,0],[16,1,17,1],[16,2,17,2],[16,3,17,3],[16,4,17,4],[16,5,17,5],[16,6,16,7],[16,8,17,8],[16,9,17,9],[16,10,16,12],[16,13,16,16],[16,17,17,17],[16,18,16,21],[21,0,21,9],[23,0,24,0],[23,1,24,1],[23,2,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[23,6,23,7],[23,8,24,8],[23,9,24,9],[23,10,23,12],[23,13,23,16],[23,17,24,17],[23,18,23,21],[29,0,29,9],[31,0,32,0],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,32,5],[31,6,31,7],[31,8,32,8],[31,9,32,9],[31,10,31,12],[31,13,31,16],[31,17,32,17],[31,18,31,21],[37,0,37,9],[39,0,40,0],[39,1,40,1],[39,2,40,2],[39,3,40,3],[39,4,40,4],[39,5,40,5],[39,6,39,7],[39,8,40,8],[39,9,40,9],[39,10,39,12],[39,13,39,16],[39,17,40,17],[39,18,39,21],[44,0,44,9],[46,0,47,0],[46,1,47,1],[46,2,47,2],[46,3,47,3],[46,4,47,4],[46,5,47,5],[46,6,46,7],[46,8,47,8],[46,9,47,9],[46,10,46,12],[46,13,46,16],[46,17,47,17],[46,18,46,21],[52,0,52,9],[54,0,55,0],[54,1,55,1],[54,2,55,2],[54,3,55,3],[54,4,55,4],[54,5,55,5],[54,6,54,7],[54,8,55,8],[54,9,55,9],[54,10,54,12],[54,13,54,16],[54,17,55,17],[54,18,54,21],[59,0,59,9],[61,0,62,0],[61,1,62,1],[61,2,62,2],[61,3,62,3],[61,4,62,4],[61,5,62,5],[61,6,61,7],[61,8,62,8],[61,9,62,9],[61,10,61,12],[61,13,61,16],[61,17,62,17],[61,18,61,21],[69,0,69,9],[71,0,72,0],[71,1,72,1],[71,2,72,2],[71,3,72,3],[71,4,72,4],[71,5,72,5],[71,6,71,7],[71,8,72,8],[71,9,72,9],[71,10,71,12],[71,13,71,16],[71,17,72,17],[71,18,71,21],[81,0,81,9],[83,0,84,0],[83,1,84,1],[83,2,84,2],[83,3,84,3],[83,4,84,4],[83,5,84,5],[83,6,83,7],[83,8,84,8],[83,9,84,9],[83,10,83,12],[83,13,83,16],[83,17,84,17],[83,18,83,21],[91,0,91,9],[93,0,93,9],[95,0,95,21]]}
["GOVERNO DO ESTADO DO ESPÍRITO SANTO",{"$nulls":21},"DIAS SEMANA","DIAS ANO","OBS"]
["SECRETARIA DE ESTADO DA EDUCAÇÃO",{"$nulls":21},5,204,"Regular/EJA"]
["SUBSECRETARIA DE SUPORTE A EDUCAÇÃO",{"$nulls":21},4,{"$f":"ROUNDUP(X2 / W2 * W3, 0)","v":164}]
["GERÊNCIA DE APOIO ESCOLAR",{"$nulls":21},3,{"$f":"ROUNDUP(X2 / W2 * W4, 0)","v":123}]
["PROGRAMA ESTADUAL DE TRANSPORTE ESCOLAR - PETE",{"$nulls":21},2,{"$f":"ROUNDUP(X2 / W2 * W5, 0)","v":82},"AEE/CAEE"]
[{"$nulls":20},204,"DIAS LETIVOS*",1,{"$f":"ROUNDUP(X2 / W2 * W6, 0)","v":41}]
["LOTES POR VEÍCULO - MUNICÍPIO DE JOAO NEIVA"]
[]
[]
["Veículo","Código Rota","Descrição da Rota","Escola","Tipo de\nLinha","Turno","Horários*",null,"Dias/\nSemana","Monitor","Alunos",null,null,"Quilometragem",{"$nulls":3},"Capacidade\nVeículo","Custo"]
[{"$nulls":6},"Entrada*","Saída",null,null,"Estado","Município","Total","Ida","Volta","Aprov.","Total",null,"R$/km","Estado","Município","Total"]
[1,20222130067,"IDA MUNICÍPIO E ESTADO - PROP MADSON X BR 259 X SANTA EMILIA X CAVALINHO X JOAO NEIVA X ESCOLA","EEEFM JOAO NEIVA / EMPEIF CAVALINHO / EMEF PROFESSORA MARIA OLIRIA SARCINELLI CAMPAGNARO","TR","M",null,null,5,"SIM",2,5,{"$f":"SUM(K12:L12)","v":7},30.6,0,6.7,{"$f":"SUM(N12:P12)","v":37.300000000000004},"08 passageiros",{"v":5.96,"d":"R$ 5.96"},{"$f":"ROUND(V12*K12/M12,2)","v":{"v":12957.38,"d":"R$ 12,957.38"}},{"$f":"V12-T12","v":{"v":32393.450000000004,"d":"R$ 32,393.45"}},{"$f":"IF(M12=0,0,ROUND(S12*Q12*VLOOKUP(I12, W2:Y6, 2, FALSE),2))","v":{"v":45350.83,"d":"R$ 45,350.83"}}]
[1,20222130068,"VOLTA ESTADO - BR 259 X PROP MADSON ( CONEXÃO BARRA TRIUNFO)","EEEFM JOAO NEIVA","CO","M",null,null,5,"NÃO",1,0,{"$f":"SUM(K13:L13)","v":1},0,5,0,{"$f":"SUM(N13:P13)","v":5},"08 passageiros",{"v":5.96,"d":"R$ 5.96"},{"$f":"ROUND(V13*K13/M13,2)","v":{"v":6079.2,"d":"R$ 6,079.20"}},{"$f":"V13-T13","v":{"v":0,"d":"R$ 0.00"}},{"$f":"IF(M13=0,0,ROUND(S13*Q13*VLOOKUP(I13, W2:Y6, 2, FALSE),2))","v":{"v":6079.2,"d":"R$ 6,079.20"}}]
[1,2130067,"VOLTA MUNICÍPIO - PROP MADSON X BR 259 X SANTA EMILIA X CAVALINHO X JOAO NEIVA X ESCOLA","EMPEIF CAVALINHO / EMEF PROFESSORA MARIA OLIRIA SARCINELLI CAMPAGNARO","TR","M",null,null,5,"SIM",0,5,{"$f":"SUM(K14:L14)","v":5},0,30.7,0,{"$f":"SUM(N14:P14)","v":30.7},"08 passageiros",{"v":5.96,"d":"R$ 5.96"},{"$f":"ROUND(V14*K14/M14,2)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"V14-T14","v":{"v":37326.29,"d":"R$ 37,326.29"}},{"$f":"IF(M14=0,0,ROUND(S14*Q14*VLOOKUP(I14, W2:Y6, 2, FALSE),2))","v":{"v":37326.29,"d":"R$ 37,326.29"}}]
["TOTAL DO LOTE",{"$nulls":9},{"$f":"SUM(K12:K14)","v":3},10,13,30.6,35.7,6.7,73,null,null,{"$f":"SUM(T12:T14)","v":{"v":19036.579999999998,"d":"R$ 19,036.58"}},{"$f":"SUM(U12:U14)","v":{"v":69719.74,"d":"R$ 69,719.74"}},{"$f":"SUM(V12:V14)","v":{"v":88756.32,"d":"R$ 88,756.32"}}]
[]
["Veículo","Código Rota","Descrição da Rota","Escola","Tipo de\nLinha","Turno","Horários*",null,"Dias/\nSemana","Monitor","Alunos",null,null,"Quilometragem",{"$nulls":3},"Capacidade\nVeículo","Custo"]
[{"$nulls":6},"Entrada*","Saída",null,null,"Estado","Município","Total","Ida","Volta","Aprov.","Total",null,"R$/km","Estado","Município","Total"]
[2,20172130005,"IDA ESTADO E MUNICÍPIO - LAGOA DO LIMÃO - VALADA DE CAVALINHO - EMPEIF CAVALINHO -EMEF PROF. MARIA OLIRIA - EEEFM JOÃO NEIVA","EEEFM JOAO NEIVA / EMPEIF CAVALINHO /  EMEF PROFESSORA MARIA OLIRIA SARCINELLI CAMPAGNARO ","TR","M",null,null,5,"SIM",5,8,{"$f":"SUM(K19:L19)","v":13},23.3,0,14.3,{"$f":"SUM(N19:P19)","v":37.6},"15 passageiros",{"v":7.82,"d":"R$ 7.82"},{"$f":"ROUND(V19*K19/M19,2)","v":{"v":23070.2,"d":"R$ 23,070.20"}},{"$f":"V19-T19","v":{"v":36912.33,"d":"R$ 36,912.33"}},{"$f":"IF(M19=0,0,ROUND(S19*Q19*VLOOKUP(I19, W2:Y6, 2, FALSE),2))","v":{"v":59982.53,"d":"R$ 59,982.53"}}]
[2,20222130066,"VOLTA ESTADO - LAGOA DO LIMÃO - VALADA DE CAVALINHO - EEEFM JOÃO NEIVA (BARRA DO TRIUNFO)","EEEFM JOAO NEIVA","CO","M",null,null,5,"NÃO",5,0,{"$f":"SUM(K20:L20)","v":5},0,8.2,0,{"$f":"SUM(N20:P20)","v":8.2},"15 passageiros",{"v":7.82,"d":"R$ 7.82"},{"$f":"ROUND(V20*K20/M20,2)","v":{"v":13081.3,"d":"R$ 13,081.30"}},{"$f":"V20-T20","v":{"v":0,"d":"R$ 0.00"}},{"$f":"IF(M20=0,0,ROUND(S20*Q20*VLOOKUP(I20, W2:Y6, 2, FALSE),2))","v":{"v":13081.3,"d":"R$ 13,081.30"}}]
[2,2130005,"VOLTA MUNICÍPIO - LAGOA DO LIMÃO - VALADA DE CAVALINHO - EMPEIF CAVALINHO -EMEF PROF. MARIA OLIRIA - EEEFM JOÃO NEIVA","EMPEIF CAVALINHO /  EMEF PROFESSORA MARIA OLIRIA SARCINELLI CAMPAGNARO ","TR","M",null,null,5,"SIM",0,8,{"$f":"SUM(K21:L21)","v":8},0,23.3,0,{"$f":"SUM(N21:P21)","v":23.3},"15 passageiros",{"v":7.82,"d":"R$ 7.82"},{"$f":"ROUND(V21*K21/M21,2)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"V21-T21","v":{"v":37170.02,"d":"R$ 37,170.02"}},{"$f":"IF(M21=0,0,ROUND(S21*Q21*VLOOKUP(I21, W2:Y6, 2, FALSE),2))","v":{"v":37170.02,"d":"R$ 37,170.02"}}]
["TOTAL DO LOTE",{"$nulls":9},{"$f":"SUM(K19:K21)","v":10},16,26,23.3,31.5,14.3,69.1,null,null,{"$f":"SUM(T19:T21)","v":{"v":36151.5,"d":"R$ 36,151.50"}},{"$f":"SUM(U19:U21)","v":{"v":74082.35,"d":"R$ 74,082.35"}},{"$f":"SUM(V19:V21)","v":{"v":110233.85,"d":"R$ 110,233.85"}}]
[]
["Veículo","Código Rota","Descrição da Rota","Escola","Tipo de\nLinha","Turno","Horários*",null,"Dias/\nSemana","Monitor","Alunos",null,null,"Quilometragem",{"$nulls":3},"Capacidade\nVeículo","Custo"]
[{"$nulls":6},"Entrada*","Saída",null,null,"Estado","Município","Total","Ida","Volta","Aprov.","Total",null,"R$/km","Estado","Município","Total"]
[3,21300732,"VOLTA INTEGRAL MUNICIPAL - PASTO NOVO X FAZENDA PANDONFI X PROPIEDADE ROGÉRIO SOEIRO - CONEXÃO COM A ROTA 20172130015","EMEIF JOSE REBUZZI SARCINELLI ","CO","I",null,null,5,"SIM",0,1,{"$f":"SUM(K26:L26)","v":1},0,6.6,0,{"$f":"SUM(N26:P26)","v":6.6},"08 passageiros",{"v":14.49,"d":"R$ 14.49"},{"$f":"ROUND(V26*K26/M26,2)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"V26-T26","v":{"v":19509.34,"d":"R$ 19,509.34"}},{"$f":"IF(M26=0,0,ROUND(S26*Q26*VLOOKUP(I26, W2:Y6, 2, FALSE),2))","v":{"v":19509.34,"d":"R$ 19,509.34"}}]
[3,20222130076,"VOLTA ESTADO - PASTO NOVO X FAZENDA PANDONFI X PROPIEDADE ROGÉRIO SOEIRO - CONEXÃO COM A ROTA 20172130015","EEEFM JOAO NEIVA","CO","M",null,null,5,"NÃO",1,0,{"$f":"SUM(K27:L27)","v":1},0,5.2,0,{"$f":"SUM(N27:P27)","v":5.2},"08 passageiros",{"v":14.49,"d":"R$ 14.49"},{"$f":"ROUND(V27*K27/M27,2)","v":{"v":15370.99,"d":"R$ 15,370.99"}},{"$f":"V27-T27","v":{"v":0,"d":"R$ 0.00"}},{"$f":"IF(M27=0,0,ROUND(S27*Q27*VLOOKUP(I27, W2:Y6, 2, FALSE),2))","v":{"v":15370.99,"d":"R$ 15,370.99"}}]
[3,20222130073,"IDA ESTADO E MUNICÍPIO - PASTO NOVO X FAZENDA PANDONFI X PROPIEDADE ROGÉRIO SOEIRO - CONEXÃO COM A ROTA 20172130015 (RIBEIRÃO DE CIMA/ RIBEIRÃO DO MEIO )","EEEFM JOAO NEIVA / EMEIF JOSE REBUZZI SARCINELLI / EMEF PROFESSORA MARIA OLIRIA SARCINELLI CAMPAGNARO","CO","M",null,null,5,"SIM",1,6,{"$f":"SUM(K28:L28)","v":7},6.6,0,6.6,{"$f":"SUM(N28:P28)","v":13.2},"08 passageiros",{"v":14.49,"d":"R$ 14.49"},{"$f":"ROUND(V28*K28/M28,2)","v":{"v":5574.1,"d":"R$ 5,574.10"}},{"$f":"V28-T28","v":{"v":33444.57,"d":"R$ 33,444.57"}},{"$f":"IF(M28=0,0,ROUND(S28*Q28*VLOOKUP(I28, W2:Y6, 2, FALSE),2))","v":{"v":39018.67,"d":"R$ 39,018.67"}}]
[3,2130073,"VOLTA MUNICÍPIO - PASTO NOVO X FAZENDA PANDONFI X PROPIEDADE ROGÉRIO SOEIRO - CONEXÃO COM A ROTA 20172130015","EMEIF JOSE REBUZZI SARCINELLI / EMEF PROFESSORA MARIA OLIRIA SARCINELLI CAMPAGNARO","CO","M",null,null,5,"SIM",0,5,{"$f":"SUM(K29:L29)","v":5},0,6.6,0,{"$f":"SUM(N29:P29)","v":6.6},"08 passageiros",{"v":14.49,"d":"R$ 14.49"},{"$f":"ROUND(V29*K29/M29,2)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"V29-T29","v":{"v":19509.34,"d":"R$ 19,509.34"}},{"$f":"IF(M29=0,0,ROUND(S29*Q29*VLOOKUP(I29, W2:Y6, 2, FALSE),2))","v":{"v":19509.34,"d":"R$ 19,509.34"}}]
["TOTAL DO LOTE",{"$nulls":9},{"$f":"SUM(K26:K29)","v":2},12,14,6.6,18.4,6.6,31.6,null,null,{"$f":"SUM(T26:T29)","v":{"v":20945.09,"d":"R$ 20,945.09"}},{"$f":"SUM(U26:U29)","v":{"v":72463.25,"d":"R$ 72,463.25"}},{"$f":"SUM(V26:V29)","v":{"v":93408.34,"d":"R$ 93,408.34"}}]
[]
["Veículo","Código Rota","Descrição da Rota","Escola","Tipo de\nLinha","Turno","Horários*",null,"Dias/\nSemana","Monitor","Alunos",null,null,"Quilometragem",{"$nulls":3},"Capacidade\nVeículo","Custo"]
[{"$nulls":6},"Entrada*","Saída",null,null,"Estado","Município","Total","Ida","Volta","Aprov.","Total",null,"R$/km","Estado","Município","Total"]
[4,2130077,"IDA MUNICÍPIO - PRIMEIRA VIAGEM -  BARRA DO TRIUNFO X CHOEIRINHA (CONEXÃO BARRA DO TRIUNFO)"," EMEIF GUILHERME BAPTISTA","CO","M",null,null,5,"SIM",0,1,{"$f":"SUM(K34:L34)","v":1},0,3.8,11.2,{"$f":"SUM(N34:P34)","v":15},"08 passageiros",{"v":7.22,"d":"R$ 7.22"},{"$f":"ROUND(V34*K34/M34,2)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"V34-T34","v":{"v":22093.2,"d":"R$ 22,093.20"}},{"$f":"IF(M34=0,0,ROUND(S34*Q34*VLOOKUP(I34, W2:Y6, 2, FALSE),2))","v":{"v":22093.2,"d":"R$ 22,093.20"}}]
[4,21300721,"IDA MUNICÍPIO - SEGUNDA VIAGEM - ALTO DA BOA VISTA -  EMPEIF BARRA DO TRIUNFO ","EMPEIF BARRA DO TRIUNFO","TR","M",null,null,5,"SIM",0,4,{"$f":"SUM(K35:L35)","v":4},10.3,0,0,{"$f":"SUM(N35:P35)","v":10.3},"08 passageiros",{"v":7.22,"d":"R$ 7.22"},{"$f":"ROUND(V35*K35/M35,2)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"V35-T35","v":{"v":15170.66,"d":"R$ 15,170.66"}},{"$f":"IF(M35=0,0,ROUND(S35*Q35*VLOOKUP(I35, W2:Y6, 2, FALSE),2))","v":{"v":15170.66,"d":"R$ 15,170.66"}}]
[4,2130007,"VOLTA MUNICÍPIO - PRIMEIRA VIAGEM - ALTO DA BOA VISTA X CHOEIRINHA - EMPEIF BARRA DO TRIUNFO ","EMEIF GUILHERME BAPTISTA / EMPEIF BARRA DO TRIUNFO","CO","M",null,null,5,"SIM",0,7,{"$f":"SUM(K36:L36)","v":7},0,16,0,{"$f":"SUM(N36:P36)","v":16},"08 passageiros",{"v":7.22,"d":"R$ 7.22"},{"$f":"ROUND(V36*K36/M36,2)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"V36-T36","v":{"v":23566.08,"d":"R$ 23,566.08"}},{"$f":"IF(M36=0,0,ROUND(S36*Q36*VLOOKUP(I36, W2:Y6, 2, FALSE),2))","v":{"v":23566.08,"d":"R$ 23,566.08"}}]
[4,20172130007,"VOLTA ESTADO - SEGUNDA VIAGEM - BARRA DO TRIUNFO X CHOEIRINHA (CONEXÃO BARRA DO TRIUNFO)","EEEFM JOAO NEIVA","CO","M",null,null,5,"NÃO",2,0,{"$f":"SUM(K37:L37)","v":2},0,6.6,11.2,{"$f":"SUM(N37:P37)","v":17.799999999999997},"08 passageiros",{"v":7.22,"d":"R$ 7.22"},{"$f":"ROUND(V37*K37/M37,2)","v":{"v":26217.26,"d":"R$ 26,217.26"}},{"$f":"V37-T37","v":{"v":0,"d":"R$ 0.00"}},{"$f":"IF(M37=0,0,ROUND(S37*Q37*VLOOKUP(I37, W2:Y6, 2, FALSE),2))","v":{"v":26217.26,"d":"R$ 26,217.26"}}]
["TOTAL DO LOTE",{"$nulls":9},{"$f":"SUM(K34:K37)","v":2},12,14,10.3,26.4,22.4,59.099999999999994,null,null,{"$f":"SUM(T34:T37)","v":{"v":26217.26,"d":"R$ 26,217.26"}},{"$f":"SUM(U34:U37)","v":{"v":60829.94,"d":"R$ 60,829.94"}},{"$f":"SUM(V34:V37)","v":{"v":87047.2,"d":"R$ 87,047.20"}}]
[]
["Veículo","Código Rota","Descrição da Rota","Escola","Tipo de\nLinha","Turno","Horários*",null,"Dias/\nSemana","Monitor","Alunos",null,null,"Quilometragem",{"$nulls":3},"Capacidade\nVeículo","Custo"]
[{"$nulls":6},"Entrada*","Saída",null,null,"Estado","Município","Total","Ida","Volta","Aprov.","Total",null,"R$/km","Estado","Município","Total"]
[5,2130061,"VOLTA MUNICÍPIO - PROP ERALDO FAVARATO X EDSON FAVARATO X BR 259 X LINHA DE FERRO X CAVALINHO X TURCO GUIDOLINE X  CAVALINHO X JOÃO NEIVA","EMPEIF CAVALINHO / EMEF PROFESSORA MARIA OLIRIA SARCINELLI CAMPAGNARO","TR","M",null,null,5,"SIM",0,10,{"$f":"SUM(K42:L42)","v":10},0,32.9,0,{"$f":"SUM(N42:P42)","v":32.9},"15 passageiros",{"v":7.03,"d":"R$ 7.03"},{"$f":"ROUND(V42*K42/M42,2)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"V42-T42","v":{"v":47182.55,"d":"R$ 47,182.55"}},{"$f":"IF(M42=0,0,ROUND(S42*Q42*VLOOKUP(I42, W2:Y6, 2, FALSE),2))","v":{"v":47182.55,"d":"R$ 47,182.55"}}]
[5,20222130061,"IDA ESTADO E MUNICÍPIO - PROP ERALDO FAVARATO X EDSON FAVARATO X BR 259 X LINHA DE FERRO X CAVALINHO X TURCO GUIDOLINE X  CAVALINHO X JOÃO NEIVA","EEEFM JOAO NEIVA / EMPEIF CAVALINHO / EMEF PROFESSORA MARIA OLIRIA SARCINELLI CAMPAGNARO","TR","M",null,null,5,"SIM",1,10,{"$f":"SUM(K43:L43)","v":11},33.5,0,11,{"$f":"SUM(N43:P43)","v":44.5},"15 passageiros",{"v":7.03,"d":"R$ 7.03"},{"$f":"ROUND(V43*K43/M43,2)","v":{"v":5801.67,"d":"R$ 5,801.67"}},{"$f":"V43-T43","v":{"v":58016.67,"d":"R$ 58,016.67"}},{"$f":"IF(M43=0,0,ROUND(S43*Q43*VLOOKUP(I43, W2:Y6, 2, FALSE),2))","v":{"v":63818.34,"d":"R$ 63,818.34"}}]
[5,20222130078,"VOLTA ESTADO  - CAVALINHO X LINHA DE FERRO - CONEXÃO BARRA DO TRIUNFO","EEEFM JOAO NEIVA","CO","M",null,null,5,"NÃO",1,0,{"$f":"SUM(K44:L44)","v":1},0,2.4,0,{"$f":"SUM(N44:P44)","v":2.4},"15 passageiros",{"v":7.03,"d":"R$ 7.03"},{"$f":"ROUND(V44*K44/M44,2)","v":{"v":3441.89,"d":"R$ 3,441.89"}},{"$f":"V44-T44","v":{"v":0,"d":"R$ 0.00"}},{"$f":"IF(M44=0,0,ROUND(S44*Q44*VLOOKUP(I44, W2:Y6, 2, FALSE),2))","v":{"v":3441.89,"d":"R$ 3,441.89"}}]
["TOTAL DO LOTE",{"$nulls":9},{"$f":"SUM(K42:K44)","v":2},20,22,33.5,35.3,11,79.80000000000001,null,null,{"$f":"SUM(T42:T44)","v":{"v":9243.56,"d":"R$ 9,243.56"}},{"$f":"SUM(U42:U44)","v":{"v":105199.22,"d":"R$ 105,199.22"}},{"$f":"SUM(V42:V44)","v":{"v":114442.78,"d":"R$ 114,442.78"}}]
[]
["Veículo","Código Rota","Descrição da Rota","Escola","Tipo de\nLinha","Turno","Horários*",null,"Dias/\nSemana","Monitor","Alunos",null,null,"Quilometragem",{"$nulls":3},"Capacidade\nVeículo","Custo"]
[{"$nulls":6},"Entrada*","Saída",null,null,"Estado","Município","Total","Ida","Volta","Aprov.","Total",null,"R$/km","Estado","Município","Total"]
[6,20222130069,"VOLTA ESTADO - ALARICO X PELADO (CONEXÃO COM A ROTA 20212130030 ) - (RIBEIRÃO) ","EEEFM JOAO NEIVA","CO","M",null,null,5,"NÃO",3,0,{"$f":"SUM(K49:L49)","v":3},0,3.7,0,{"$f":"SUM(N49:P49)","v":3.7},"23 passageiros",{"v":9.57,"d":"R$ 9.57"},{"$f":"ROUND(V49*K49/M49,2)","v":{"v":7223.44,"d":"R$ 7,223.44"}},{"$f":"V49-T49","v":{"v":0,"d":"R$ 0.00"}},{"$f":"IF(M49=0,0,ROUND(S49*Q49*VLOOKUP(I49, W2:Y6, 2, FALSE),2))","v":{"v":7223.44,"d":"R$ 7,223.44"}}]
[6,21300632,"VOLTA MUNICÍPIO INTEGRAL - CRISTAL X PIRAQUEAÇU X PELADO X RETIRO"," EMEIF JOSE REBUZZI SARCINELLI ","TR","I",null,null,5,"SIM",0,4,{"$f":"SUM(K50:L50)","v":4},0,15.6,0,{"$f":"SUM(N50:P50)","v":15.6},"23 passageiros",{"v":9.57,"d":"R$ 9.57"},{"$f":"ROUND(V50*K50/M50,2)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"V50-T50","v":{"v":30455.57,"d":"R$ 30,455.57"}},{"$f":"IF(M50=0,0,ROUND(S50*Q50*VLOOKUP(I50, W2:Y6, 2, FALSE),2))","v":{"v":30455.57,"d":"R$ 30,455.57"}}]
[6,2130063,"VOLTA MUNICÍPIO - JOÃO NEIVA X CRISTAL X RETIRO X PELADO X PIRAQUEAÇU","EMEIF JOSE REBUZZI SARCINELLI / EMEIF DOUTOR ORLINDO FRANCISCO BORGES / EMEF PROFESSORA MARIA OLIRIA SARCINELLI CAMPAGNARO","TR","M",null,null,5,"SIM",0,15,{"$f":"SUM(K51:L51)","v":15},0,23.8,0,{"$f":"SUM(N51:P51)","v":23.8},"23 passageiros",{"v":9.57,"d":"R$ 9.57"},{"$f":"ROUND(V51*K51/M51,2)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"V51-T51","v":{"v":46464.26,"d":"R$ 46,464.26"}},{"$f":"IF(M51=0,0,ROUND(S51*Q51*VLOOKUP(I51, W2:Y6, 2, FALSE),2))","v":{"v":46464.26,"d":"R$ 46,464.26"}}]
[6,20222130063,"IDA ESTADO E MUNICÍPIO - RETIRO X  PELADO X PIRAQUEAÇU X CRISTAL X JOÃO NEIVA","EEEFM JOAO NEIVA / EMEIF JOSE REBUZZI SARCINELLI / EMEIF DOUTOR ORLINDO FRANCISCO BORGES / EMEF PROFESSORA MARIA OLIRIA SARCINELLI CAMPAGNARO","TR","M",null,null,5,"SIM",3,19,{"$f":"SUM(K52:L52)","v":22},22.6,0,7.3,{"$f":"SUM(N52:P52)","v":29.900000000000002},"23 passageiros",{"v":9.57,"d":"R$ 9.57"},{"$f":"ROUND(V52*K52/M52,2)","v":{"v":7959.98,"d":"R$ 7,959.98"}},{"$f":"V52-T52","v":{"v":50413.19,"d":"R$ 50,413.19"}},{"$f":"IF(M52=0,0,ROUND(S52*Q52*VLOOKUP(I52, W2:Y6, 2, FALSE),2))","v":{"v":58373.17,"d":"R$ 58,373.17"}}]
["TOTAL DO LOTE",{"$nulls":9},{"$f":"SUM(K49:K52)","v":6},38,44,22.6,43.1,7.3,73,null,null,{"$f":"SUM(T49:T52)","v":{"v":15183.419999999998,"d":"R$ 15,183.42"}},{"$f":"SUM(U49:U52)","v":{"v":127333.02,"d":"R$ 127,333.02"}},{"$f":"SUM(V49:V52)","v":{"v":142516.44,"d":"R$ 142,516.44"}}]
[]
["Veículo","Código Rota","Descrição da Rota","Escola","Tipo de\nLinha","Turno","Horários*",null,"Dias/\nSemana","Monitor","Alunos",null,null,"Quilometragem",{"$nulls":3},"Capacidade\nVeículo","Custo"]
[{"$nulls":6},"Entrada*","Saída",null,null,"Estado","Município","Total","Ida","Volta","Aprov.","Total",null,"R$/km","Estado","Município","Total"]
[7,20222130064,"IDA ESTADO E MUNICÍPIO - AREA RURAL MUNDO NOVO X EEEFM JOAO NEIVA","EEEFM JOAO NEIVA / EMEF PEDRO NOLASCO / EMEF PROFESSORA MARIA OLIRIA SARCINELLI CAMPAGNARO / EMEF MISSIONARIOS COMBONIANOS / EMEIF TERESITA BORRINI FARINA","TR","M",null,null,5,"SIM",3,9,{"$f":"SUM(K57:L57)","v":12},8.5,0,5.3,{"$f":"SUM(N57:P57)","v":13.8},"15 passageiros",{"v":15.44,"d":"R$ 15.44"},{"$f":"ROUND(V57*K57/M57,2)","v":{"v":10866.67,"d":"R$ 10,866.67"}},{"$f":"V57-T57","v":{"v":32600.020000000004,"d":"R$ 32,600.02"}},{"$f":"IF(M57=0,0,ROUND(S57*Q57*VLOOKUP(I57, W2:Y6, 2, FALSE),2))","v":{"v":43466.69,"d":"R$ 43,466.69"}}]
[7,20222130074,"VOLTA ESTADO - AREA RURAL MUNDO NOVO X EEEFM JOAO NEIVA","EEEFM JOAO NEIVA","TR","M",null,null,5,"NÃO",3,0,{"$f":"SUM(K58:L58)","v":3},0,5.3,0,{"$f":"SUM(N58:P58)","v":5.3},"15 passageiros",{"v":15.44,"d":"R$ 15.44"},{"$f":"ROUND(V58*K58/M58,2)","v":{"v":16693.73,"d":"R$ 16,693.73"}},{"$f":"V58-T58","v":{"v":0,"d":"R$ 0.00"}},{"$f":"IF(M58=0,0,ROUND(S58*Q58*VLOOKUP(I58, W2:Y6, 2, FALSE),2))","v":{"v":16693.73,"d":"R$ 16,693.73"}}]
[7,2130064,"VOLTA MUNICÍPIO - AREA RURAL MUNDO NOVO X EEEFM JOAO NEIVA","EMEF PEDRO NOLASCO / EMEF PROFESSORA MARIA OLIRIA SARCINELLI CAMPAGNARO / EMEF MISSIONARIOS COMBONIANOS / EMEIF TERESITA BORRINI FARINA","TR","M",null,null,5,"SIM",0,9,{"$f":"SUM(K59:L59)","v":9},0,8.5,0,{"$f":"SUM(N59:P59)","v":8.5},"15 passageiros",{"v":15.44,"d":"R$ 15.44"},{"$f":"ROUND(V59*K59/M59,2)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"V59-T59","v":{"v":26772.96,"d":"R$ 26,772.96"}},{"$f":"IF(M59=0,0,ROUND(S59*Q59*VLOOKUP(I59, W2:Y6, 2, FALSE),2))","v":{"v":26772.96,"d":"R$ 26,772.96"}}]
["TOTAL DO LOTE",{"$nulls":9},{"$f":"SUM(K57:K59)","v":6},18,24,8.5,13.8,5.3,27.6,null,null,{"$f":"SUM(T57:T59)","v":{"v":27560.4,"d":"R$ 27,560.40"}},{"$f":"SUM(U57:U59)","v":{"v":59372.98,"d":"R$ 59,372.98"}},{"$f":"SUM(V57:V59)","v":{"v":86933.38,"d":"R$ 86,933.38"}}]
[]
["Veículo","Código Rota","Descrição da Rota","Escola","Tipo de\nLinha","Turno","Horários*",null,"Dias/\nSemana","Monitor","Alunos",null,null,"Quilometragem",{"$nulls":3},"Capacidade\nVeículo","Custo"]
[{"$nulls":6},"Entrada*","Saída",null,null,"Estado","Município","Total","Ida","Volta","Aprov.","Total",null,"R$/km","Estado","Município","Total"]
[8,20222130070,"IDA ESTADO E MUNICÍPIO - PRIMEIRA VIAGEM - PROP REINALDO FAVARATO X BR-259 X ACIOLI "," EMEIF GUILHERME BAPTISTA / EEEFM JOAO NEIVA","CO","M",null,null,5,"SIM",1,1,{"$f":"SUM(K64:L64)","v":2},15.4,0,44.2,{"$f":"SUM(N64:P64)","v":59.6},"08 passageiros",{"v":4.92,"d":"R$ 4.92"},{"$f":"ROUND(V64*K64/M64,2)","v":{"v":29909.67,"d":"R$ 29,909.67"}},{"$f":"V64-T64","v":{"v":29909.660000000003,"d":"R$ 29,909.66"}},{"$f":"IF(M64=0,0,ROUND(S64*Q64*VLOOKUP(I64, W2:Y6, 2, FALSE),2))","v":{"v":59819.33,"d":"R$ 59,819.33"}}]
[8,20222130071,"VOLTA ESTADO - QUINTA VIAGEM -  PROP REINALDO FAVARATO X BR-259 X ACIOLI ","EEEFM JOAO NEIVA","CO","M",null,null,5,"NÃO",1,0,1,0,15.4,0,15.4,"08 passageiros",{"v":4.92,"d":"R$ 4.92"},{"v":15456.67,"d":"R$ 15,456.67"},{"v":0,"d":"R$ 0.00"},{"$f":"IF(M65=0,0,ROUND(S65*Q65*VLOOKUP(I65, W2:Y6, 2, FALSE),2))","v":{"v":15456.67,"d":"R$ 15,456.67"}}]
[8,2130071,"IDA MUNICÍPIO VESPERTINO - TERCEIRA VIAGEM - PROP ELTON FAVARATO X PROP RENATO MARIN X  EMEIF GUILHERME BAPTISTA"," EMEIF GUILHERME BAPTISTA","TR","V",null,null,5,"SIM",0,2,2,8.7,0,0,8.7,"08 passageiros",{"v":4.92,"d":"R$ 4.92"},{"v":0,"d":"R$ 0.00"},{"v":8732.02,"d":"R$ 8,732.02"},{"$f":"IF(M66=0,0,ROUND(S66*Q66*VLOOKUP(I66, W2:Y6, 2, FALSE),2))","v":{"v":8732.02,"d":"R$ 8,732.02"}}]
[8,21300701," IDA MUNICÍPIO - SEGUNDA VIAGEM - PROP ELTON FAVARATO X PROP RENATO MARIN X  EMEIF GUILHERME BAPTISTA"," EMEIF GUILHERME BAPTISTA","TR","M",null,null,5,"SIM",0,4,4,8.6,0,0,8.6,"08 passageiros",{"v":4.92,"d":"R$ 4.92"},{"v":0,"d":"R$ 0.00"},{"v":8631.65,"d":"R$ 8,631.65"},{"$f":"IF(M67=0,0,ROUND(S67*Q67*VLOOKUP(I67, W2:Y6, 2, FALSE),2))","v":{"v":8631.65,"d":"R$ 8,631.65"}}]
[8,21300703,"VOLTA DO MUNICÍPIO MATUTINO - QUARTA VIAGEM - PROP REINALDO FAVARATO X PROP ELTON FAVARATO X BR-259 X PROP RENATO MARIN X ACIOLI "," EMEIF GUILHERME BAPTISTA","TR","M",null,null,5,"SIM",0,5,5,0,19.2,0,19.2,"08 passageiros",{"v":4.92,"d":"R$ 4.92"},{"v":0,"d":"R$ 0.00"},{"v":19270.66,"d":"R$ 19,270.66"},{"$f":"IF(M68=0,0,ROUND(S68*Q68*VLOOKUP(I68, W2:Y6, 2, FALSE),2))","v":{"v":19270.66,"d":"R$ 19,270.66"}}]
[8,2130070,"VOLTA MUNICÍPIO VESPERTINO - SEXTA VIAGEM - PROP ELTON FAVARATO X PROP RENATO MARIN X  EMEIF GUILHERME BAPTISTA"," EMEIF GUILHERME BAPTISTA","TR","V",null,null,5,"SIM",0,2,2,0,8.7,0,8.7,"08 passageiros",{"v":4.92,"d":"R$ 4.92"},{"v":0,"d":"R$ 0.00"},{"v":8732.02,"d":"R$ 8,732.02"},{"$f":"IF(M69=0,0,ROUND(S69*Q69*VLOOKUP(I69, W2:Y6, 2, FALSE),2))","v":{"v":8732.02,"d":"R$ 8,732.02"}}]
["TOTAL DO LOTE",{"$nulls":9},{"$f":"SUM(K64:K69)","v":2},14,16,32.7,43.3,44.2,120.2,null,null,{"$f":"SUM(T64:T69)","v":{"v":45366.34,"d":"R$ 45,366.34"}},{"$f":"SUM(U64:U69)","v":{"v":75276.01000000001,"d":"R$ 75,276.01"}},{"$f":"SUM(V64:V69)","v":{"v":120642.35,"d":"R$ 120,642.35"}}]
[]
["Veículo","Código Rota","Descrição da Rota","Escola","Tipo de\nLinha","Turno","Horários*",null,"Dias/\nSemana","Monitor","Alunos",null,null,"Quilometragem",{"$nulls":3},"Capacidade\nVeículo","Custo"]
[{"$nulls":6},"Entrada*","Saída",null,null,"Estado","Município","Total","Ida","Volta","Aprov.","Total",null,"R$/km","Estado","Município","Total"]
[9,20172130006,"IDA ESTADO - PROPRIEDADE FLORENCIO FAVARATO - BR 259  (CONEXÃO BARRA DO TRIUNFO) ","EEEFM JOAO NEIVA","CO","M",null,null,5,"NÃO",2,0,{"$f":"SUM(K74:L74)","v":2},3,0,0,{"$f":"SUM(N74:P74)","v":3},"08 passageiros",{"v":7.48,"d":"R$ 7.48"},{"$f":"ROUND(V74*K74/M74,2)","v":{"v":4577.76,"d":"R$ 4,577.76"}},{"$f":"V74-T74","v":{"v":0,"d":"R$ 0.00"}},{"$f":"IF(M74=0,0,ROUND(S74*Q74*VLOOKUP(I74, W2:Y6, 2, FALSE),2))","v":{"v":4577.76,"d":"R$ 4,577.76"}}]
[9,21300754,"VOLTA VESPERTINO - (SOMENTE MUNICÍPIO)  SANTA HELENA X  EMEIF GUILHERME BATISTA","EMEIF GUILHERME BATISTA","TR","V",null,null,5,"SIM",0,4,4,0,5.3,0,5.3,"08 passageiros",{"v":7.48,"d":"R$ 7.48"},{"v":0,"d":"R$ 0.00"},{"v":8087.38,"d":"R$ 8,087.38"},{"$f":"IF(M75=0,0,ROUND(S75*Q75*VLOOKUP(I75, W2:Y6, 2, FALSE),2))","v":{"v":8087.38,"d":"R$ 8,087.38"}}]
[9,2130006,"IDA MUNICÍPIO - ESPERANÇA X PROPRIEDADE FLORENCIO FAVARATO - BR 259 - EMEIF GUILHERME BATISTA ","EMEIF GUILHERME BATISTA ","TR","M",null,null,5,"SIM",0,2,2,10,0,0,10,"08 passageiros",{"v":7.48,"d":"R$ 7.48"},{"v":0,"d":"R$ 0.00"},{"v":15259.2,"d":"R$ 15,259.20"},{"$f":"IF(M76=0,0,ROUND(S76*Q76*VLOOKUP(I76, W2:Y6, 2, FALSE),2))","v":{"v":15259.2,"d":"R$ 15,259.20"}}]
[9,20222130075,"VOLTA ESTADO  - PROPRIEDADE FLORENCIO FAVARATO - BR 259  ( CONEXÃO BARRA DO TRIUNFO) ","EEEFM JOAO NEIVA","CO","M",null,null,5,"NÃO",2,0,2,0,3,11.6,14.6,"08 passageiros",{"v":7.48,"d":"R$ 7.48"},{"v":22278.43,"d":"R$ 22,278.43"},{"v":0,"d":"R$ 0.00"},{"$f":"IF(M77=0,0,ROUND(S77*Q77*VLOOKUP(I77, W2:Y6, 2, FALSE),2))","v":{"v":22278.43,"d":"R$ 22,278.43"}}]
[9,21300751,"VOLTA MATUTINO - (SOMENTE MUNICÍPIO)  SANTA HELENA X  EMEIF GUILHERME BATISTA","EMEIF GUILHERME BATISTA","TR","M",null,null,5,"SIM",0,4,4,0,4.5,0,4.5,"08 passageiros",{"v":7.48,"d":"R$ 7.48"},{"v":0,"d":"R$ 0.00"},{"v":6866.64,"d":"R$ 6,866.64"},{"$f":"IF(M78=0,0,ROUND(S78*Q78*VLOOKUP(I78, W2:Y6, 2, FALSE),2))","v":{"v":6866.64,"d":"R$ 6,866.64"}}]
[9,21300753,"VOLTA MUNICÍPIO VESPERTINO -  PROPRIEDADE FLORENCIO FAVARATO - BR 259 - EMEIF GUILHERME BATISTA ","EMEIF GUILHERME BATISTA ","TR","V",null,null,5,"SIM",0,3,3,0,3,0,3,"08 passageiros",{"v":7.48,"d":"R$ 7.48"},{"v":0,"d":"R$ 0.00"},{"v":4577.76,"d":"R$ 4,577.76"},{"$f":"IF(M79=0,0,ROUND(S79*Q79*VLOOKUP(I79, W2:Y6, 2, FALSE),2))","v":{"v":4577.76,"d":"R$ 4,577.76"}}]
[9,21300755," IDA VESPERTINO - (SOMENTE MUNICÍPIO)  SANTA HELENA X  EMEIF GUILHERME BATISTA","EMEIF GUILHERME BATISTA","TR","V",null,null,5,"SIM",0,3,3,4.6,0,0,4.6,"08 passageiros",{"v":7.48,"d":"R$ 7.48"},{"v":0,"d":"R$ 0.00"},{"v":7019.23,"d":"R$ 7,019.23"},{"$f":"IF(M80=0,0,ROUND(S80*Q80*VLOOKUP(I80, W2:Y6, 2, FALSE),2))","v":{"v":7019.23,"d":"R$ 7,019.23"}}]
[9,21300752,"VOLTA MUNICÍPIO - ESPERANÇA X PROPRIEDADE FLORENCIO FAVARATO - BR 259 - EMEIF GUILHERME BATISTA "," EMEIF GUILHERME BATISTA ","TR","M",null,null,5,"SIM",0,2,2,0,10,11.6,21.6,"08 passageiros",{"v":7.48,"d":"R$ 7.48"},{"v":0,"d":"R$ 0.00"},{"v":32959.87,"d":"R$ 32,959.87"},{"$f":"IF(M81=0,0,ROUND(S81*Q81*VLOOKUP(I81, W2:Y6, 2, FALSE),2))","v":{"v":32959.87,"d":"R$ 32,959.87"}}]
["TOTAL DO LOTE",{"$nulls":9},{"$f":"SUM(K74:K81)","v":4},18,22,17.6,25.8,23.2,66.6,null,null,{"$f":"SUM(T74:T81)","v":{"v":26856.190000000002,"d":"R$ 26,856.19"}},{"$f":"SUM(U74:U81)","v":{"v":74770.08000000002,"d":"R$ 74,770.08"}},{"$f":"SUM(V74:V81)","v":{"v":101626.27000000002,"d":"R$ 101,626.27"}}]
[]
["Veículo","Código Rota","Descrição da Rota","Escola","Tipo de\nLinha","Turno","Horários*",null,"Dias/\nSemana","Monitor","Alunos",null,null,"Quilometragem",{"$nulls":3},"Capacidade\nVeículo","Custo"]
[{"$nulls":6},"Entrada*","Saída",null,null,"Estado","Município","Total","Ida","Volta","Aprov.","Total",null,"R$/km","Estado","Município","Total"]
[10,21300072,"IDA MUNICÍPIO - BARRA DO TRIUNFO X PROP BARCELO X SANTA HELENA X ACIOLE","EEEFM JOAO NEIVA /  EMEIF GUILHERME BAPTISTA","TR","M",null,null,5,"SIM",0,5,{"$f":"SUM(K86:L86)","v":5},12.3,0,0,{"$f":"SUM(N86:P86)","v":12.3},"15 passageiros",{"v":7.23,"d":"R$ 7.23"},{"$f":"ROUND(V86*K86/M86,2)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"V86-T86","v":{"v":18141.52,"d":"R$ 18,141.52"}},{"$f":"IF(M86=0,0,ROUND(S86*Q86*VLOOKUP(I86, W2:Y6, 2, FALSE),2))","v":{"v":18141.52,"d":"R$ 18,141.52"}}]
[10,21300073,"IDA MUNICÍPIO - DELABARBA (CACHOEIRA) X GIACOMIN X BARRA DO TRIUNFO","EEEFM JOAO NEIVA / EMPEIF BARRA DO TRIUNFO","TR","M",null,null,5,"SIM",0,11,11,9,0,0,9,"15 passageiros",{"v":7.23,"d":"R$ 7.23"},{"v":0,"d":"R$ 0.00"},{"v":13274.28,"d":"R$ 13,274.28"},{"$f":"IF(M87=0,0,ROUND(S87*Q87*VLOOKUP(I87, W2:Y6, 2, FALSE),2))","v":{"v":13274.28,"d":"R$ 13,274.28"}}]
[10,21300075,"VOLTA MUNICÍPIO  - BARRA DO TRIUNFO X GIACOMIN  X BARCELOS X DELABARBA (CACHOEIRA) ","EEEFM JOAO NEIVA / EMPEIF BARRA DO TRIUNFO / EMEIF GUILHERME BAPTISTA","TR","M",null,null,5,"SIM",0,11,11,0,9,0,9,"15 passageiros",{"v":7.23,"d":"R$ 7.23"},{"v":0,"d":"R$ 0.00"},{"v":13274.28,"d":"R$ 13,274.28"},{"$f":"IF(M88=0,0,ROUND(S88*Q88*VLOOKUP(I88, W2:Y6, 2, FALSE),2))","v":{"v":13274.28,"d":"R$ 13,274.28"}}]
[10,21300076,"VOLTA  MUNICÍPIO -  PROP MAZOLINE X BARRA DO TRIUNFO","EEEFM JOAO NEIVA / EMPEIF BARRA DO TRIUNFO / EMEIF GUILHERME BAPTISTA","TR","M",null,null,5,"SIM",0,6,6,0,4.3,0,4.3,"15 passageiros",{"v":7.23,"d":"R$ 7.23"},{"v":0,"d":"R$ 0.00"},{"v":6342.16,"d":"R$ 6,342.16"},{"$f":"IF(M89=0,0,ROUND(S89*Q89*VLOOKUP(I89, W2:Y6, 2, FALSE),2))","v":{"v":6342.16,"d":"R$ 6,342.16"}}]
[10,20222130077,"IDA ESTADO E MUNICÍPIO - CÓRREGO CACHEIRINHA X BARRA DO TRIUNFO X PROP MAZOLINE ","EEEFM JOAO NEIVA / EMEIF GUILHERME BAPTISTA","CO","M",null,null,5,"SIM",2,4,6,11.7,0,31.3,43,"15 passageiros",{"v":7.23,"d":"R$ 7.23"},{"v":21140.52,"d":"R$ 21,140.52"},{"v":42281.03999999999,"d":"R$ 42,281.04"},{"$f":"IF(M90=0,0,ROUND(S90*Q90*VLOOKUP(I90, W2:Y6, 2, FALSE),2))","v":{"v":63421.56,"d":"R$ 63,421.56"}}]
[10,21300074,"IDA  MUNICÍPIO -  PROP MAZOLINE X BARRA DO TRIUNFO","EEEFM JOAO NEIVA / EMPEIF BARRA DO TRIUNFO","TR","M",null,null,5,"SIM",0,4,4,4.3,0,0,4.3,"15 passageiros",{"v":7.23,"d":"R$ 7.23"},{"v":0,"d":"R$ 0.00"},{"v":6342.16,"d":"R$ 6,342.16"},{"$f":"IF(M91=0,0,ROUND(S91*Q91*VLOOKUP(I91, W2:Y6, 2, FALSE),2))","v":{"v":6342.16,"d":"R$ 6,342.16"}}]
["TOTAL DO LOTE",{"$nulls":9},{"$f":"SUM(K86:K91)","v":2},41,43,37.3,13.3,31.3,81.89999999999999,null,null,{"$f":"SUM(T86:T91)","v":{"v":21140.52,"d":"R$ 21,140.52"}},{"$f":"SUM(U86:U91)","v":{"v":99655.44,"d":"R$ 99,655.44"}},{"$f":"SUM(V86:V91)","v":{"v":120795.96,"d":"R$ 120,795.96"}}]
[]
["TOTAL GERAL",{"$nulls":9},{"$f":"+K15+K22+K30+K38+K45+K53+K60+K70+K82+K92","v":39},199,238,223,286.6,172.3,681.9000000000001,null,null,{"$f":"+T15+T22+T30+T38+T45+T53+T60+T70+T82+T92","v":{"v":247700.86,"d":"R$ 247,700.86"}},{"$f":"+U15+U22+U30+U38+U45+U53+U60+U70+U82+U92","v":{"v":818702.03,"d":"R$ 818,702.03"}},{"$f":"+V15+V22+V30+V38+V45+V53+V60+V70+V82+V92","v":{"v":1066402.89,"d":"R$ 1,066,402.89"}}]
[]
["Obs: Dias Letivos Ano*: Regular 5 ; EJA 5 ; APAE/AEE 2.\nObservação: As capacidades dos veículos definidas pela SEDU são as mínimas exigidas em cada uma das 4 faixas de veículos (08, 15, 23 e 41 passageiros), podendo ser executadas por veículos de maior capacidade nos casos em que a via permita e que não haja prejuízo aos alunos.\nHorários: Estimativa de horários de entrada e saída dos alunos da escola."]