{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["MENU PRINCIPAL","DASHBOARD","CONSUMO DE COMBUSTIVEL","DINÂMICAS"],"not_rendered":{"charts":3,"images":56,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":6},"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":"MENU PRINCIPAL","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DASHBOARD","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CONSUMO DE COMBUSTIVEL","index":2,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["DATA DO ABASTECIMENTO","VALOR ABASTECIDO","TIPO DE COMBUSTIVEL","R$ POR LITRO","KM INICIAL","KM FINAL","LITROS ABASTECIDO","KM RODADO","MÊS",null,null,null,null,"GASOLINA"]
[44197,100,"ETANOL",5,100,200,{"$f":"IFERROR($B8/$D8,\"\")","v":20},{"$f":"IF(F8-E8=0,\"\",F8-E8)","v":100},{"$f":"IF(BASE[[#This Row],[DATA DO ABASTECIMENTO]]=\"\",\"\",UPPER(TEXT($A8,\"MMM\")))","v":"JAN"},null,null,null,null,"ETANOL"]
[44198,400,"GASOLINA",10,205,305,40,100,{"$f":"IF(BASE[[#This Row],[DATA DO ABASTECIMENTO]]=\"\",\"\",UPPER(TEXT($A9,\"MMM\")))","v":"JAN"}]
[44199,300,"GASOLINA",2.5,400,500,120,100,{"$f":"IF(BASE[[#This Row],[DATA DO ABASTECIMENTO]]=\"\",\"\",UPPER(TEXT($A10,\"MMM\")))","v":"JAN"}]
[44231,200,"ETANOL",5,100,200,40,100,{"$f":"IF(BASE[[#This Row],[DATA DO ABASTECIMENTO]]=\"\",\"\",UPPER(TEXT($A11,\"MMM\")))","v":"FEV"}]
[44237,200,"GASOLINA",3.5,200,300,57.142857142857146,100,{"$f":"IF(BASE[[#This Row],[DATA DO ABASTECIMENTO]]=\"\",\"\",UPPER(TEXT($A12,\"MMM\")))","v":"FEV"}]
[44256,100,"GASOLINA",3.5,500,650,{"$f":"IFERROR($B13/$D13,\"\")","v":28.571428571428573},{"$f":"IF(F13-E13=0,\"\",F13-E13)","v":150},{"$f":"IF(BASE[[#This Row],[DATA DO ABASTECIMENTO]]=\"\",\"\",UPPER(TEXT($A13,\"MMM\")))","v":"MAR"}]
[44275,15,"ETANOL",2.5499999999999998,700,800,{"$f":"IFERROR($B14/$D14,\"\")","v":5.882352941176471},{"$f":"IF(F14-E14=0,\"\",F14-E14)","v":100},{"$f":"IF(BASE[[#This Row],[DATA DO ABASTECIMENTO]]=\"\",\"\",UPPER(TEXT($A14,\"MMM\")))","v":"MAR"}]

{"sheet":"DINÂMICAS","index":3,"n_rows":19,"n_cols":36,"rows_kept":19,"cut":false,"hidden":false,"merged":[[7,4,7,19],[7,22,7,35]]}
[]
[]
[]
[]
[]
[]
[]
[null,"FILTRO",null,null,"ANÁLISE DE FATURAMENTO E CONSUMO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VALOR GASTO MENSAL"]
[]
[null,"Rótulos de Linha",null,null,"Soma de VALOR ABASTECIDO",null,"Soma de LITROS ABASTECIDO",null,"Soma de KM RODADO",null,"Média RS por Litro",null,"Média km/ por litro",null,null,"Rótulos de Linha","Soma de LITROS ABASTECIDO",null,null,null,null,null,null,"Rótulos de Coluna"]
[null,"JAN",null,null,800,null,180,null,300,null,{"$f":"IFERROR(GETPIVOTDATA(\"VALOR ABASTECIDO\",$E$10)/GETPIVOTDATA(\"LITROS ABASTECIDO\",$G$10),\"\")","v":4.4444444444444446},null,{"$f":"IFERROR(GETPIVOTDATA(\"KM RODADO\",$I$10)/GETPIVOTDATA(\"LITROS ABASTECIDO\",$G$10),\"\")","v":1.6666666666666667},null,null,"ETANOL",0.1111111111111111,null,null,null,null,null,null,"JAN","FEV","MAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GASOLINA",0.88888888888888884,null,null,null,null,null,"Soma de VALOR ABASTECIDO",800,400,115]
[null,null,null,null,{"$f":"IF(GETPIVOTDATA(\"VALOR ABASTECIDO\",$E$10)=0,\"\",GETPIVOTDATA(\"VALOR ABASTECIDO\",$E$10))","v":800},null,{"$f":"IF(GETPIVOTDATA(\"LITROS ABASTECIDO\",$G$10)=0,\"\",GETPIVOTDATA(\"LITROS ABASTECIDO\",$G$10))","v":180},null,{"$f":"IF(GETPIVOTDATA(\"KM RODADO\",$I$10)=0,\"\",GETPIVOTDATA(\"KM RODADO\",$I$10))","v":300},null,{"$f":"IF(K11=0,\"\",K11)","v":4.4444444444444446},null,{"$f":"IF(M11=0,\"\",M11)","v":1.6666666666666667},null,null,"Total Geral",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X11","v":"JAN"},{"$f":"Y11","v":"FEV"},{"$f":"IF(Z11=0,\"\",Z11)","v":"MAR"},{"$f":"IF(AA11=0,\"\",AA11)","v":""},"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GASOLINA",{"$f":"IFERROR(VLOOKUP(P16,P10:Q12,2,0),\"\")","v":0.88888888888888884},{"$f":"1-Q16","v":0.11111111111111116},null,null,null,null,null,{"$f":"X12","v":800},400,{"$f":"IF(Z12=0,NA(),Z12)","v":115},{"$f":"IF(AA12=0,NA(),AA12)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AJ12=0,\"\",AJ12)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ETANOL",{"$f":"IFERROR(VLOOKUP(P17,P10:Q12,2,0),\"\")","v":0.1111111111111111},{"$f":"1-Q17","v":0.88888888888888884}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(X$15,$B$11:$B$23,1,0)","v":"JAN"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X$18=X$15,X$16+$W$21,NA())","v":800},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]