{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["cotação empresas aereas","cotação empresas rod - enviado","rodoviário"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"cotação empresas aereas","index":0,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[[29,0,29,1],[30,0,30,1],[31,11,31,14],[31,15,31,16],[29,11,29,15],[28,0,28,1],[28,11,28,14],[28,15,28,16],[0,2,0,14],[1,12,1,16],[26,8,26,10],[27,11,27,14],[27,15,27,16]]}
[null,null,"PLANILHA PARA COTAÇÃO DE PREÇOS -  Item 1 - Transporte aéreo porta a porta"]
["BSB","DF     ","Tarifa mínima (R$)","<= 10KG","Até 25,500 Kg (R$)","Até 25,5KH","25,501 Kg à 50,500 Kg (R$)","25,5 à 50,50","50,501 Kg à 300,500 Kg (R$)","300,501 Kg à 500,500 Kg (R$)","500,501 Kg à 1000,500 Kg (R$)","Acima de 1000,500 Kg (R$)","Planilha de cálculo  estimado para o serviço"]
["AJU     ","SE     ",82.71,1,9.5756579100000021,20,8.3392405425000007,null,6.2610070950000001,5.8400990550000005,4.9851295987500013,4.9851295987500013,"Valor peso",{"$f":"C3*D3","v":82.71},{"$f":"SUM((F3-10)*C31)+(F3*E3)","v":195.41315820000005}]
[null,null,null,2,{"$nulls":8},"Coleta/entrega",{"$f":"D4*C30","v":34},{"$f":"SUM((F3-10)*C31)+(C30*2)","v":37.9}]
[{"$nulls":13},{"$f":"SUM(N3:N4)","v":116.71},{"$f":"SUM(O3:O4)","v":233.31315820000006},{"$f":"SUM(P3:P4)","v":0},{"$f":"SUM(N5:P5)","v":350.02315820000007}]
["CNF     ","MG     ",59.703174798750005,1,5.8927125600000014,11,5.1298167375000006,30,3.8407858650000004,3.5908717162500006,3.0778900425,3.0778900425,"Valor peso",{"$f":"C6*D6","v":59.703174798750005},{"$f":"SUM((F6-10)*C31)+(F6*E6)","v":65.209838160000018},{"$f":"SUM((H6-10)*C31)+(G6*H6)","v":161.69450212500004}]
[null,null,null,2,{"$nulls":8},"Coleta/entrega",{"$f":"D7*C30","v":34},{"$f":"SUM((F6-10)*C31)+(C30*2)","v":34.39},{"$f":"SUM((H6-10)*C31)+(C30*2)","v":41.8}]
[{"$nulls":13},{"$f":"SUM(N6:N7)","v":93.703174798750013},{"$f":"SUM(O6:O7)","v":99.599838160000019},{"$f":"SUM(P6:P7)","v":203.49450212500005},{"$f":"SUM(N8:P8)","v":396.79751508375011}]
["MCZ     ","AL     ",82.708429860000024,1,10.41747399,11,9.0495228600000015,30,6.7739887687500007,6.3136206000000001,5.419191015,5.419191015,"Valor peso",{"$f":"C9*D9","v":82.708429860000024},{"$f":"SUM((F9-10)*C31)+(F9*E9)","v":114.98221389},{"$f":"SUM((H9-10)*C31)+(G9*H9)","v":279.28568580000007}]
[null,null,null,2,{"$nulls":8},"Coleta/entrega",{"$f":"D10*C30","v":34},{"$f":"SUM((F9-10)*C31)+(C30*2)","v":34.39},{"$f":"SUM((H9-10)*C31)+(C30*2)","v":41.8}]
[{"$nulls":13},{"$f":"SUM(N9:N10)","v":116.70842986000002},{"$f":"SUM(O9:O10)","v":149.37221389000001},{"$f":"SUM(P9:P10)","v":321.08568580000008},{"$f":"SUM(N11:P11)","v":587.16632955000011}]
["REC     ","PE     ",82.708429860000024,1,11.219829941250001,20,9.7729585537499997,30,7.3395839475000004,6.8266022737500007,5.8400990550000005,5.8400990550000005,"Valor peso",{"$f":"C12*D12","v":82.708429860000024},{"$f":"SUM((F12-10)*C31)+(F12*E12)","v":228.29659882500002},{"$f":"SUM((H12-10)*C31)+(G12*H12)","v":300.98875661250003}]
[null,null,null,2,{"$nulls":8},"Coleta/entrega",{"$f":"D13*C30","v":34},{"$f":"SUM((F12-10)*C31)+(C30*2)","v":37.9},{"$f":"SUM((H12-10)*C31)+(C30*2)","v":41.8}]
[{"$nulls":13},{"$f":"SUM(N12:N13)","v":116.70842986000002},{"$f":"SUM(O12:O13)","v":266.19659882500002},{"$f":"SUM(P12:P13)","v":342.78875661250004},{"$f":"SUM(N14:P14)","v":725.69378529750009}]
["SLZ     ","MA     ",82.708429860000024,1,11.43028396125,15,9.8387254350000024,30,7.5237312150000006,6.94498266,5.9321726887499997,5.7874855500000013,"Valor peso",{"$f":"C15*D15","v":82.708429860000024},{"$f":"SUM((F15-10)*C31)+(F15*E15)","v":173.40425941874997},{"$f":"SUM((H15-10)*C31)+(G15*H15)","v":302.96176305000006}]
[null,null,null,2,{"$nulls":8},"Coleta/entrega",{"$f":"D16*C30","v":34},{"$f":"SUM((F15-10)*C31)+(C30*2)","v":35.950000000000003},{"$f":"SUM((H15-10)*C31)+(C30*2)","v":41.8}]
[{"$nulls":13},{"$f":"SUM(N15:N16)","v":116.70842986000002},{"$f":"SUM(O15:O16)","v":209.35425941874996},{"$f":"SUM(P15:P16)","v":344.76176305000007},{"$f":"SUM(N17:P17)","v":670.82445232875011}]
["SSA     ","BA     ",82.708429860000024,1,8.4050074237500016,15,7.3001238187500004,30,5.45865114375,5.1166633612500014,4.3932276675000006,4.3932276675000006,"Valor peso",{"$f":"C18*D18","v":82.708429860000024},{"$f":"SUM((F18-10)*C31)+(F18*E18)","v":128.02511135625002},{"$f":"SUM((H18-10)*C31)+(G18*H18)","v":226.80371456250003}]
[null,null,null,2,{"$nulls":8},"Coleta/entrega",{"$f":"D19*C30","v":34},{"$f":"SUM((F18-10)*C31)+(C30*2)","v":35.950000000000003},{"$f":"SUM((H18-10)*C31)+(C30*2)","v":41.8}]
[{"$nulls":13},{"$f":"SUM(N18:N19)","v":116.70842986000002},{"$f":"SUM(O18:O19)","v":163.97511135625001},{"$f":"SUM(P18:P19)","v":268.60371456250004},{"$f":"SUM(N20:P20)","v":549.28725577875002}]
["THE     ","PI     ",82.708429860000024,1,9.5493511575000003,15,8.3918540475000007,30,6.22154696625,5.9321726887499997,4.9193627175000012,4.9193627175000012,"Valor peso",{"$f":"C21*D21","v":82.708429860000024},{"$f":"SUM((F21-10)*C31)+(F21*E21)","v":145.19026736249998},{"$f":"SUM((H21-10)*C31)+(G21*H21)","v":259.55562142500003}]
[null,null,null,2,{"$nulls":8},"Coleta/entrega",{"$f":"D22*C30","v":34},{"$f":"SUM((F21-10)*C31)+(C30*2)","v":35.950000000000003},{"$f":"SUM((H21-10)*C31)+(C30*2)","v":41.8}]
[{"$nulls":13},{"$f":"SUM(N21:N22)","v":116.70842986000002},{"$f":"SUM(O21:O22)","v":181.14026736249997},{"$f":"SUM(P21:P22)","v":301.35562142500004},{"$f":"SUM(N23:P23)","v":599.20431864750003}]
["UDI     ","MG     ",59.703174798750005,1,3.7618656075000003,null,3.3278041912500003,null,2.6043684974999999,2.3149942200000004,2.0256199425000001,1.8809328037500002,"Valor peso",{"$f":"C24*D24","v":59.703174798750005}]
[null,null,null,2,{"$nulls":8},"Coleta/entrega",{"$f":"D25*C30","v":34}]
[{"$nulls":13},{"$f":"SUM(N24:N25)","v":93.703174798750013},{"$f":"SUM(O24:O25)","v":0},{"$f":"SUM(P24:P25)","v":0},{"$f":"SUM(N26:P26)","v":93.703174798750013}]
[null,null,null,{"$f":"SUM(D3+D6+D9+D12+D15+D18+D21+D24)*10","v":80},null,{"$f":"SUM(F3:F26)","v":107},null,{"$f":"SUM(H3:H26)","v":180},"Total de Quilogramas anual",null,null,{"$f":"D27+F27+H27","v":367}]
[{"$nulls":11},"Valor deste item/serviço mês",null,null,null,{"$f":"SUM(Q3:Q26)","v":3972.6999896850007}]
["Peso",null,"Coleta","Entrega",{"$nulls":7},"Valor deste item/serviço anual",null,null,null,{"$f":"P28*12","v":47672.399876220006}]
["até 10 KG",null,17,17,{"$nulls":7},"Desconto a ser aplicado pela empresa",{"$nulls":4},0]
["Exedente",null,0.39,0.39,{"$nulls":12},{"$f":"P29*Q30","v":0}]
[{"$nulls":11},"Valor final deste item/serviço anual",null,null,null,{"$f":"P29-Q31","v":47672.399876220006}]
[{"$nulls":16},14545.92]
[{"$nulls":16},{"$f":"P32+Q33","v":62218.319876220005}]

{"sheet":"cotação empresas rod - enviado","index":1,"n_rows":24,"n_cols":23,"rows_kept":24,"cut":false,"hidden":false,"merged":[[22,0,22,1],[23,16,23,20],[23,21,23,22],[21,3,22,13],[1,9,2,9],[19,10,19,12],[19,13,19,14],[0,0,0,22],[2,18,2,22],[19,16,19,20],[19,21,19,22],[21,0,21,1],[21,16,21,21],[20,0,20,1],[20,16,20,20],[20,21,20,22],[1,3,1,4],[1,5,1,6],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,7,2,7],[1,8,2,8]]}
["PLANILHA PARA COTAÇÃO DE PREÇOS -  Item 2 - Transporte rodoviário porta a porta"]
["Brasília","DF     ","Distância (KM)","Taxa despacho",null,"Redespacho",null,"Taxa Emergência","Taxa Seguro (%)"]
[null,null,null,"Valor (R$) da coleta/entrega até 10Kg","Valor (R$/KG) para excedente de 10Kg","Valor (R$) da coleta/entrega até 10Kg","Valor (R$/KG) para excedente de 10Kg",null,null,null,"até 10KG (R$)","Até 20 Kg (R$)","Até 30Kg (R$)","até 50 Kg (R$)","até 70 Kg (R$)","até 100 Kg (R$)","Acima de 100 Kg (R$)","Ad valorem (%)","Planilha de cálculo  estimado para o serviço"]
["Aracaju","SE     ",1640,28.33,1,105,1.57,204,null,"Peso",8,20,{"$nulls":6},"Valor peso",{"$f":"K5","v":66.19},{"$f":"SUM((L4-10)*L5)+(L5*L4)","v":113.39999999999999}]
[{"$nulls":9},"Taxa",66.19,3.78,3.5,3.26,3.03,2.81,2.63,0.59,"Coleta/entrega",{"$f":"D4*2","v":56.66},{"$f":"SUM((L4-10)*E4)+(D4*2)","v":66.66}]
[{"$nulls":19},{"$f":"SUM(T4:T5)","v":122.85},{"$f":"SUM(U4:U5)","v":180.06},{"$f":"SUM(V4:V5)","v":0},{"$f":"SUM(T6:V6)","v":302.90999999999997}]
["Belo Horizonte","MG     ",735,28.33,1,105,1.57,204,null,"Peso",8.5,15,{"$nulls":6},"Valor peso",{"$f":"K8","v":45.27},{"$f":"SUM((L7-10)*L8)+(L8*L7)","v":41}]
[{"$nulls":9},"Taxa",45.27,2.0499999999999998,1.92,1.78,1.66,1.56,1.45,0.59,"Coleta/entrega",{"$f":"D7*2","v":56.66},{"$f":"SUM((L7-10)*E7)+(D7*2)","v":61.66}]
[{"$nulls":19},{"$f":"SUM(T7:T8)","v":101.93},{"$f":"SUM(U7:U8)","v":102.66},{"$f":"SUM(V7:V8)","v":0},{"$f":"SUM(T9:V9)","v":204.59}]
["Maceio","AL     ",1897,28.33,1,105,1.57,204,null,"Peso",null,20,{"$nulls":6},"Valor peso",null,{"$f":"SUM((L10-10)*L11)+(L11*L10)","v":114.89999999999999}]
[{"$nulls":9},"Taxa",67.73,3.83,3.55,3.31,3.08,2.86,2.68,0.59,"Coleta/entrega",null,{"$f":"SUM((L10-10)*E10)+(D10*2)","v":66.66}]
[{"$nulls":19},{"$f":"SUM(T10:T11)","v":0},{"$f":"SUM(U10:U11)","v":181.56},{"$f":"SUM(V10:V11)","v":0},{"$f":"SUM(T12:V12)","v":181.56}]
["Recife","PE     ",2099,28.33,1,105,1.57,204,null,"Peso",10,11,{"$nulls":6},"Valor peso",{"$f":"K14","v":92.1},{"$f":"SUM((L13-10)*L14)+(L14*L13)","v":95.4}]
[{"$nulls":9},"Taxa",92.1,7.95,7.3,6.71,6.17,5.69,5.25,0.59,"Coleta/entrega",{"$f":"D13*2","v":56.66},{"$f":"SUM((L13-10)*E13)+(D13*2)","v":57.66}]
[{"$nulls":19},{"$f":"SUM(T13:T14)","v":148.76},{"$f":"SUM(U13:U14)","v":153.06},{"$f":"SUM(V13:V14)","v":0},{"$f":"SUM(T15:V15)","v":301.82}]
["Salvador","BA     ",1465,28.33,1,105,1.57,204,null,"Peso",9,11,{"$nulls":6},"Valor peso",{"$f":"K17","v":62.44},{"$f":"SUM((L16-10)*L17)+(L17*L16)","v":44.52}]
[{"$nulls":9},"Taxa",62.44,3.71,3.43,3.19,2.96,2.74,2.56,0.59,"Coleta/entrega",{"$f":"D16*2","v":56.66},{"$f":"SUM((L16-10)*E16)+(D16*2)","v":57.66}]
[{"$nulls":19},{"$f":"SUM(T16:T17)","v":119.1},{"$f":"SUM(U16:U17)","v":102.18},{"$f":"SUM(V16:V17)","v":0},{"$f":"SUM(T18:V18)","v":221.28}]
[{"$nulls":9},"Peso",{"$f":"SUM(K4+K7+K10+K13+K16)","v":35.5},{"$f":"SUM(L4+L7+L10+L13+L16)","v":77},{"$f":"SUM(M4+M7+M10+M13+M16)","v":0}]
[{"$nulls":10},"Peso Total (quilogramas)",null,null,{"$f":"M19+L19+K19","v":112.5},null,null,"Valor deste item/serviço mês",{"$nulls":4},{"$f":"SUM(W4:W18)","v":1212.1599999999999}]
[{"$nulls":16},"Valor deste item/serviço anual",{"$nulls":4},{"$f":"V20*12","v":14545.919999999998}]
[null,null,null,"A empresa deverá anexar a sua tabela de tarifas completa, apresentando todas as capitais do país, tendo como origem BRASÍLIA/DF.",{"$nulls":12},"Desconto a ser aplicado pela empresa",{"$nulls":5},0]
[{"$nulls":22},{"$f":"V21*W22","v":0}]
[{"$nulls":16},"Valor final deste item/serviço anual",{"$nulls":4},{"$f":"V21-W23","v":14545.919999999998}]

{"sheet":"rodoviário","index":2,"n_rows":56,"n_cols":57,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,2,3,2],[2,7,2,10],[0,0,0,55],[1,52,1,55],[2,11,2,14],[2,15,2,18],[1,28,1,31],[1,32,1,35],[2,3,2,6],[1,36,1,39],[1,40,1,43],[1,44,1,47],[1,48,1,51],[1,11,1,18],[55,0,55,1],[55,6,56,39],[56,0,56,1],[1,24,1,27],[1,23,2,23],[53,27,53,35],[53,39,53,43],[54,0,54,1],[1,19,1,22],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,22,3,22],[1,3,1,10],[1,0,3,0],[1,1,3,1]]}
["Tarifário de transporte rodoviário - CODEVASF"]
["Brasília","DF     ","Distância (KM)","Taxa despacho",{"$nulls":7},"Redespacho",{"$nulls":7},"Taxa Emergência",{"$nulls":4},"até 10KG (R$)",null,null,null,"Até 20 Kg (R$)",null,null,null,"Até 30 Kg (R$)",null,null,null,"até 50 Kg (R$)",null,null,null,"até 70 Kg (R$)",null,null,null,"até 100 Kg (R$)",null,null,null,"Acima de 100 Kg (R$)",null,null,null,"Taxa de seguro (%)"]
[null,null,null,"Valor (R$) da coleta/entrega até 10Kg",null,null,null,"Valor (R$/KG) para excedente de 10Kg",null,null,null,"Valor (R$) da coleta/entrega até 10Kg",null,null,null,"Valor (R$/KG) para excedente de 10Kg",null,null,null,"AVG","Aerocargas","Voetur","Média",null,"AVG","AEROCARGAS","Voetur","Média","AVG","AEROCARGAS","Voetur","Média","AVG","AEROCARGAS","Voetru","Média","AVG","AEROCARGAS","Voetru","Média","AVG","AEROCARGAS","Voetur","Média","AVG","AEROCARGAS","Voetur","Média","AVG","AEROCARGAS","Voetur","Média","AVG","AEROCARGAS","Voetur","Média"]
[null,null,null,"AVG","AEROCARGAS","Voetur","Média","AVG","AEROCARGAS","Voetur","Média","AVG","AEROCARGAS","Voetur","Média","AVG","AEROCARGAS","Voetur","Média"]
["Aracaju","SE     ",1640,30,35,20,{"$f":"(D5+E5+F5)/3","v":28.333333333333332},0.35,1.1499999999999999,1.5,{"$f":"(H5+I5+J5)/3","v":1},30,145,140,{"$f":"(L5+M5+N5)/3","v":105},0.35,1.65,2.72,{"$f":"(P5+Q5+R5)/3","v":1.5733333333333335},179.35,350,84.2,{"$f":"(T5+U5+V5)/3","v":204.51666666666668},"Peso"]
[{"$nulls":6},{"$f":"(D6+E6+F6)/3","v":0},null,null,null,{"$f":"(H6+I6+J6)/3","v":0},null,null,null,{"$f":"(L6+M6+N6)/3","v":0},null,null,null,{"$f":"(P6+Q6+R6)/3","v":0},null,null,null,{"$f":"(T6+U6+V6)/3","v":0},"Taxa",56.46,31.09,111.01,{"$f":"(AA6+Z6+Y6)/3","v":66.186666666666667},4.8499999999999996,4.2699999999999996,2.2200000000000002,{"$f":"(AE6+AD6+AC6)/3","v":3.78},4.4000000000000004,3.88,2.2200000000000002,{"$f":"(AG6+AH6+AI6)/3","v":3.5000000000000004},4.0199999999999996,3.54,2.2200000000000002,{"$f":"(AM6+AL6+AK6)/3","v":3.26},3.65,3.22,2.2200000000000002,{"$f":"(AQ6+AP6+AO6)/3","v":3.03},3.3,2.91,2.2200000000000002,{"$f":"(AS6+AT6+AU6)/3","v":2.81},3.02,2.66,2.2200000000000002,{"$f":"(AY6+AX6+AW6)/3","v":2.6333333333333333},0.45,0.33,1,{"$f":"(BA6+BB6+BC6)/3","v":0.59333333333333338}]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},{"$f":"(AA7+Z7+Y7)/3","v":0},null,null,null,{"$f":"(AE7+AD7+AC7)/3","v":0},{"$nulls":7},{"$f":"(AM7+AL7+AK7)/3","v":0},null,null,null,{"$f":"(AQ7+AP7+AO7)/3","v":0},null,null,null,{"$f":"(AS7+AT7+AU7)/3","v":0},null,null,null,{"$f":"(AY7+AX7+AW7)/3","v":0},null,null,null,{"$f":"(BA7+BB7+BC7)/3","v":0}]
["Belo Horizonte","MG     ",735,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",35.57,19.59,80.66,45.273333333333333,2.54,2.2400000000000002,1.37,2.0500000000000003,2.33,2.0499999999999998,1.37,{"$f":"(AG9+AH9+AI9)/3","v":1.9166666666666667},2.11,1.86,1.37,1.78,1.92,1.69,1.37,1.6600000000000001,1.76,1.55,1.37,1.5599999999999998,1.59,1.4,1.37,1.4533333333333334,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Campo Grande","MS",1061,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",41.7,28.38,90.27,53.449999999999996,3.22,null,1.7,1.64,2.94,null,1.7,1.5466666666666666,2.67,null,1.7,1.4566666666666668,2.42,null,1.7,1.3733333333333333,2.2200000000000002,null,1.7,1.3066666666666666,2,null,1.7,1.2333333333333334,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Curitiba","PR",1081,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",51.54,28.38,90.27,56.73,4.3,3.79,1.7,3.2633333333333332,3.92,3.45,1.7,3.0233333333333334,3.55,3.13,1.7,2.793333333333333,3.23,2.85,1.7,2.5933333333333333,2.94,2.59,1.7,2.4099999999999997,2.42,2.35,1.7,2.1566666666666667,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Florinópolis","SC",1678,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",58.93,32.450000000000003,111.01,67.463333333333338,5.12,4.51,2.2200000000000002,3.9500000000000006,4.6500000000000004,4.0999999999999996,2.2200000000000002,3.6566666666666667,4.2300000000000004,3.73,2.2200000000000002,3.3933333333333331,3.84,3.38,2.2200000000000002,3.1466666666666665,3.5,3.08,2.2200000000000002,2.9333333333333336,3.17,2.79,2.2200000000000002,2.7266666666666666,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Fortaleza","CE",1981,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",130.37,71.790000000000006,119.12,107.09333333333335,14.83,13.07,2.44,10.113333333333333,13.48,11.88,2.44,9.2666666666666675,12.26,10.8,2.44,8.5,11.13,9.81,2.44,7.7933333333333339,10.119999999999999,8.92,2.44,7.16,9.1999999999999993,8.11,2.44,6.583333333333333,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Goiania","GO",209,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,490,null,null,null,0,{"$nulls":7},0,"Taxa",23.31,12.84,68.97,35.04,1.23,1.08,0.98,1.0966666666666667,1.1100000000000001,0.98,0.98,1.0233333333333332,1.01,0.89,0.98,0.96,0.9,0.79,0.98,0.89,0.83,0.73,0.98,0.84666666666666668,0.75,0.66,0.98,0.79666666666666675,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},{"$f":"G23","v":28.333333333333332},null,null,null,{"$f":"K24*K23","v":490},{"$nulls":11},0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,490,null,null,null,0]
["Joao Pessoa","PB",2192,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,{"$f":"AZ25*AZ24","v":390.36666666666673},null,null,null,0,{"$f":"G25+K25+AZ26","v":908.7}]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",104.5,57.54,121.98,94.673333333333332,11.8,10.47,2.5299999999999998,8.2666666666666675,10.81,9.52,2.5299999999999998,7.62,9.83,8.66,2.5299999999999998,7.0066666666666668,8.93,7.87,2.5299999999999998,6.4433333333333325,8.1199999999999992,7.15,2.5299999999999998,5.9333333333333336,7.37,6.49,2.5299999999999998,5.4633333333333338,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Maceio","AL     ",1897,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",56.46,31.09,115.65,67.733333333333334,4.8499999999999996,4.2699999999999996,2.37,3.8299999999999996,4.4000000000000004,3.88,2.37,3.5500000000000007,4.0199999999999996,3.54,2.37,3.31,3.65,3.22,2.37,3.08,3.3,2.91,2.37,2.86,3.02,2.66,2.37,2.6833333333333336,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Natal","RN",2360,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",110.48,60.84,123.35,98.223333333333343,12.58,11.08,2.61,8.7566666666666659,11.43,10.07,2.61,8.0366666666666671,10.39,9.15,2.61,7.3833333333333329,9.44,8.32,2.61,6.7899999999999991,8.58,7.56,2.61,6.25,7.8,6.87,2.61,5.7600000000000007,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Porto Alegre","RS",2117,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",71.2,39.21,121.98,77.463333333333324,7.18,6.33,2.5299999999999998,5.3466666666666667,6.53,5.75,2.5299999999999998,4.9366666666666665,5.92,5.22,2.5299999999999998,4.5566666666666666,5.4,4.76,2.5299999999999998,4.2299999999999995,4.8899999999999997,4.3099999999999996,2.5299999999999998,3.9099999999999997,4.46,3.93,2.5299999999999998,3.64,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Recife","PE     ",2099,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",99.52,54.8,121.98,92.100000000000009,11.33,9.98,2.5299999999999998,7.9466666666666663,10.29,9.07,2.5299999999999998,7.2966666666666669,9.35,8.24,2.5299999999999998,6.7066666666666661,8.5,7.49,2.5299999999999998,6.1733333333333329,7.73,6.81,2.5299999999999998,5.69,7.03,6.19,2.5299999999999998,5.25,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Rio de Janeiro","RJ",1162,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",46.62,25.67,91.74,54.676666666666669,3.77,3.32,1.75,2.9466666666666668,3.42,3.01,1.75,2.7266666666666666,3.12,2.75,1.75,2.54,2.83,2.4900000000000002,1.75,2.3566666666666669,2.57,2.2599999999999998,1.75,2.1933333333333334,2.35,2.0699999999999998,1.75,2.0566666666666666,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Salvador","BA     ",1465,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",56.46,31.09,99.78,62.443333333333335,4.8499999999999996,4.2699999999999996,2.02,3.7133333333333329,4.3899999999999997,3.88,2.02,3.4299999999999997,4.0199999999999996,3.54,2.02,3.1933333333333334,3.64,3.22,2.02,2.9600000000000004,3.3,2.91,2.02,2.7433333333333336,3.01,2.66,2.02,2.563333333333333,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["São Paulo","SP",1008,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,"Taxa",41.7,22.96,90.27,51.643333333333338,3.22,2.84,1.7,2.5866666666666664,2.94,2.59,1.7,2.4099999999999997,2.67,2.35,1.7,2.2399999999999998,2.42,2.13,1.7,2.0833333333333335,2.2200000000000002,1.96,1.7,1.96,2,1.76,1.7,1.82,0.45,0.33,1,0.59333333333333338]
[{"$nulls":6},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Vitória","ES",1251,30,35,20,28.333333333333332,0.35,1.1499999999999999,1.5,1,30,145,140,105,0.35,1.65,2.72,1.5733333333333335,179.35,350,84.2,204.51666666666668,"Peso",null,null,null,0,null,null,null,0,{"$nulls":7},0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[{"$nulls":23},"Taxa",47.87,26.36,94.95,56.393333333333338,4.34,3.82,1.86,3.34,3.94,3.47,1.86,3.09,3.58,3.15,1.86,2.8633333333333333,3.26,2.87,1.86,2.6633333333333336,2.95,2.6,1.86,2.4700000000000002,2.69,2.37,1.86,2.3066666666666666,0.45,0.33,1,0.59333333333333338]
[]
[{"$nulls":23},"Peso",null,null,null,{"$f":"SUM(AB5+AB8+AB29+AB38+AB44)","v":0},null,null,null,{"$f":"SUM(AF5+AF8+AF29+AF38+AF44)","v":0},null,null,null,{"$f":"SUM(AJ5+AJ8+AJ29+AJ38+AJ44)","v":0}]
[{"$nulls":27},"Peso Total (quilogramas)",{"$nulls":11},{"$f":"AJ53+AI53+AB53","v":0}]
[]
[{"$nulls":6},"A empresa deverá anexar a sua tabela de tarifas completa, apresentando todas as capitais do país, tendo como origem BRASÍLIA/DF."]