// kajla tankolási napló – új, üres Google-táblázatban futtasd.
function setupTemplate() {
  const book = SpreadsheetApp.getActiveSpreadsheet();
  if (!book) throw new Error('Nyiss egy új Google-táblázatot, majd annak Bővítmények → Apps Script menüjét.');
  const active = Session.getActiveUser().getEmail().toLowerCase();
  const effective = Session.getEffectiveUser().getEmail().toLowerCase();
  if (!active || active !== effective) throw new Error('A saját Google-fiókodból futtasd.');
  const props = PropertiesService.getScriptProperties();
  if (props.getProperty('OWNER_EMAIL') && props.getProperty('OWNER_EMAIL') !== active) throw new Error('Másik tulajdonos van beállítva.');
  if (props.getProperty('BOOK_ID')) {
    if (props.getProperty('BOOK_ID') !== book.getId()) throw new Error('Ez a program már másik táblázathoz tartozik.');
    initialize();
    setupStatistics();
    return 'A napló már elkészült. A meglévő adatok nem változtak.';
  }
  const names = ['Tankolások','Éves bontás','Dashboard','Szervizek','Listák'];
  if (names.some(name => book.getSheetByName(name))) throw new Error('Már létezik egy naplólap. A sablont új, üres táblázatban állítsd be; meglévő lapot nem ír felül.');
  if (book.getSheets().some(sheet => sheet.getLastRow() > 0)) throw new Error('A táblázat nem üres. Hozz létre új, üres táblázatot.');
  book.setSpreadsheetLocale('hu_HU').setSpreadsheetTimeZone(ZONE);
  const sheets = {};
  names.forEach(name => sheets[name] = book.insertSheet(name));
  const fuel = sheets['Tankolások'], annual = sheets['Éves bontás'], dash = sheets['Dashboard'], lists = sheets['Listák'];
  fuel.insertRowsAfter(fuel.getMaxRows(), 2001 - fuel.getMaxRows());
  const headers = ['Dátum','Idő','Márka','Hely','Egységár','Teljes költség','Mennyiség','Kilométer óra','Megtett út','Átlagfogyasztás','Üzemanyag típus','Pénznem','Tele tank?','Megjegyzés'];
  styleTable_(fuel, headers, 2001);
  fuel.setFrozenColumns(4);
  fuel.getRange('A2:A2001').setNumberFormat('yyyy.mm.dd.');
  fuel.getRange('B2:B2001').setNumberFormat('hh:mm');
  fuel.getRange('E2:E2001').setNumberFormat('#,##0.00" Ft/l"');
  fuel.getRange('F2:F2001').setNumberFormat('#,##0" Ft"');
  fuel.getRange('G2:G2001').setNumberFormat('#,##0.00" l"');
  fuel.getRange('H2:I2001').setNumberFormat('#,##0" km"');
  fuel.getRange('J2:J2001').setNumberFormat('0.00" l/100 km"');
  fuel.getRange('M2:M2001').insertCheckboxes().setValue(true);
  fuel.getRange('M1').setNote('Az űrlapon: Teletankoltam. Részleges tankolásnál kapcsold ki.');
  fuel.getRange('J1').setNote('Az előző teletankolás óta tankolt összes liter / megtett út × 100. Az első teletankolásnál és részleges tankoláskor üres.');
  fuel.getRange('G2:G2001').setBackground('#edf4ef');
  fuel.getRange('I2:J2001').setBackground('#edf4ef');
  styleTable_(lists, ['Márka','Hely'], 200);
  lists.getRange('A2:A4').setValues([['MOL'],['OMV'],['Shell']]);
  for (const [column, range] of [[3,'A2:A200'],[4,'B2:B200']]) fuel.getRange(2,column,2000,1).setDataValidation(SpreadsheetApp.newDataValidation().requireValueInRange(lists.getRange(range),true).setAllowInvalid(false).build());
  fuel.getRange('K2:K2001').setDataValidation(SpreadsheetApp.newDataValidation().requireValueInList(['Prémium 95','100-as benzin','Dízel','Prémium dízel'],true).setAllowInvalid(false).build());
  fuel.getRange('L2:L2001').setDataValidation(SpreadsheetApp.newDataValidation().requireValueInList(CURRENCIES,true).setAllowInvalid(false).build());
  fuel.getRange('A1:N2001').createFilter();
  fuel.setColumnWidth(4,180).setColumnWidth(14,280);
  setupAnnual_(annual);
  styleTable_(dash,['Mutató','Érték'],8);
  dash.getRange('A2:A7').setValues([['Tankolások száma'],['Megtett út'],['Tankolt mennyiség'],['Költség (HUF)'],['Költség (EUR)'],['Leghosszabb táv két tankolás között']]);
  dash.getRange('B2:B7').setFormulas([
    ['=SUM(\'Éves bontás\'!B2:B201)'],['=SUM(\'Éves bontás\'!C2:C201)'],['=SUM(\'Éves bontás\'!D2:D201)'],['=SUM(\'Éves bontás\'!E2:E201)'],['=SUM(\'Éves bontás\'!F2:F201)'],['=IF(COUNT(\'Éves bontás\'!M2:M201)=0,"",MAX(\'Éves bontás\'!M2:M201))']
  ].map(row => row.map(huFormula_)));
  dash.getRange('A8').setValue('Leghosszabb táv dátuma (záró tankolás)');
  dash.getRange('B8').setFormula(huFormula_('=IF(B7="","",INDEX(\'Éves bontás\'!N2:N201,MATCH(B7,\'Éves bontás\'!M2:M201,0)))')).setNumberFormat('yyyy.mm.dd.');
  dash.getRange('B3').setNumberFormat('#,##0" km"');
  dash.getRange('B4').setNumberFormat('#,##0.00" l"');
  dash.getRange('B5').setNumberFormat('#,##0" Ft"');
  dash.getRange('B6').setNumberFormat('#,##0.00" €"');
  dash.getRange('B7').setNumberFormat('#,##0" km"');
  dash.setColumnWidth(1,350).setColumnWidth(2,190);
  const services = sheets['Szervizek'];
  styleTable_(services,['Dátum','Km-óraállás','Munka / alkatrész','Költség (Ft)','Megjegyzés'],501);
  services.getRange('A2:A501').setNumberFormat('yyyy.mm.dd.');
  services.getRange('B2:B501').setNumberFormat('#,##0" km"');
  services.getRange('D2:D501').setNumberFormat('#,##0" Ft"');
  services.setColumnWidth(3,260).setColumnWidth(5,300);
  lists.hideSheet();
  book.setActiveSheet(fuel);
  props.setProperty('BOOK_ID',book.getId());
  initialize();
  setupStatistics();
  SpreadsheetApp.flush();
  return 'Elkészült az üres napló. Bevezetés → Új bevezetés → Internetes alkalmazás. Végrehajtás: Én; hozzáférés: Csak nekem.';
}

function styleTable_(sheet, headers, rows) {
  sheet.getRange(1,1,rows,headers.length).setFontFamily('Arial').setFontSize(10);
  sheet.getRange(1,1,1,headers.length).setValues([headers]);
  sheet.getRange(1,1,rows,headers.length).applyRowBanding(SpreadsheetApp.BandingTheme.LIGHT_GREY);
  sheet.getRange(1,1,1,headers.length).setBackground('#173d48').setFontColor('#ffffff').setFontWeight('bold').setWrap(true);
  sheet.setFrozenRows(1).setRowHeight(1,44).setColumnWidths(1,headers.length,145);
}

// Hungarian Sheets uses semicolons between formula arguments.
// Leave commas inside quoted text and sheet names unchanged.
function huFormula_(formula) {
  return formula.replace(/"(?:[^"]|"")*"|'(?:[^']|'')*'|,/g, token => token === ',' ? ';' : token);
}

function setupAnnual_(sheet) {
  const headers=['Év','Tankolások','Megtett út','Tankolt mennyiség','Költség (HUF)','Költség (EUR)','Mért átlagfogyasztás','Mérések száma','Min. literár (HUF)','Max. literár (HUF)','Min. literár (EUR)','Max. literár (EUR)','Leghosszabb táv','Dátuma'];
  styleTable_(sheet,headers,201);
  const col=letter=>"'Tankolások'!"+letter+'$2:'+letter+'$2001';
  const dates=col('A');
  sheet.getRange('A2').setFormula(huFormula_('=IF(COUNT('+dates+')=0,YEAR(TODAY()),YEAR(MIN('+dates+')))'));
  sheet.getRange('A3:A201').setFormulas(Array.from({length:199},(_,i)=>{const r=i+3;return [huFormula_('=IF(A'+(r-1)+'="","",IF(A'+(r-1)+'<MAX(YEAR(TODAY())+5,YEAR(MAX('+dates+'))),A'+(r-1)+'+1,""))')];}));
  const formulas = Array.from({length:200},(_,i)=>{
    const r=i+2, year='A'+r, start='DATE('+year+',1,1)', end='DATE('+year+'+1,1,1)';
    const criteria=dates+',">="&'+start+','+dates+',"<"&'+end;
    const filter=dates+'>='+start+','+dates+'<'+end;
    const price=currency=>col('L')+'="'+currency+'"';
    const stat=(fn,currency)=>'IFERROR('+fn+'(FILTER('+col('E')+','+filter+','+price(currency)+','+col('E')+'>0)),"")';
    const expr=[
      'COUNTIFS('+criteria+')',
      'SUMIFS('+col('I')+','+criteria+')',
      'SUMIFS('+col('G')+','+criteria+')',
      'SUMIFS('+col('F')+','+criteria+','+col('L')+',"HUF")',
      'SUMIFS('+col('F')+','+criteria+','+col('L')+',"EUR")',
      'IFERROR(AVERAGE(FILTER('+col('J')+','+filter+','+col('J')+'>0)),"")',
      'COUNTIFS('+criteria+','+col('J')+',">0")',
      stat('MIN','HUF'),stat('MAX','HUF'),stat('MIN','EUR'),stat('MAX','EUR'),
      'IFERROR(MAX(FILTER('+col('I')+','+filter+','+col('I')+'>0)),"")',
      'IF(M'+r+'="","",IFERROR(INDEX(FILTER('+dates+','+filter+','+col('I')+'=M'+r+'),1),""))'
    ];
    return expr.map(e=>huFormula_('=IF('+year+'="","",'+e+')'));
  });
  sheet.getRange('B2:N201').setFormulas(formulas);
  sheet.getRange('C2:C201').setNumberFormat('#,##0" km"');
  sheet.getRange('D2:D201').setNumberFormat('#,##0.00" l"');
  sheet.getRange('E2:E201').setNumberFormat('#,##0" Ft"');
  sheet.getRange('F2:F201').setNumberFormat('#,##0.00" €"');
  sheet.getRange('G2:G201').setNumberFormat('0.00" l/100 km"');
  sheet.getRange('I2:J201').setNumberFormat('#,##0.00" Ft/l"');
  sheet.getRange('K2:L201').setNumberFormat('0.000" €/l"');
  sheet.getRange('M2:M201').setNumberFormat('#,##0" km"');
  sheet.getRange('N2:N201').setNumberFormat('yyyy.mm.dd.');
  sheet.getRange('G1').setNote('A tankoláskor mért fogyasztások egyszerű átlaga. Csak befejezett teletankolási szakaszok; nem éves liter/km hányados.');
  sheet.getRange('N1').setNote('A szakaszt lezáró tankolás dátuma. Holtversenynél az első előfordulás.');
  const chart=(title,type,ranges,row,colors)=>{
    let b=sheet.newChart().setChartType(type).setPosition(row,16,0,0).setOption('title',title).setOption('width',640).setOption('height',300).setOption('colors',colors).setOption('backgroundColor','#ffffff').setNumHeaders(1);
    ranges.forEach(range=>b=b.addRange(sheet.getRange(range)));
    sheet.insertChart(b.build());
  };
  chart('Éves költség • HUF',Charts.ChartType.COLUMN,['A1:A201','E1:E201'],2,['#237a61']);
  chart('Literár • minimum és maximum (Ft/l)',Charts.ChartType.LINE,['A1:A201','I1:J201'],19,['#2447ed','#ff742f']);
  chart('Mért átlagfogyasztás (l/100 km)',Charts.ChartType.LINE,['A1:A201','G1:G201'],36,['#237a61']);
}


const KAJLA_STATISTICS = [{"title":"Kútstatisztika","dataTitle":"Grafikonadatok","rows":[[0,0,"A grafikonok élő összesítői"],[1,0,"A darabszám minden dátummal és márkával rögzített tankolást számol. A literösszeg a kitöltött mennyiségeket használja."],[4,0,"=IFERROR(QUERY('Tankolások'!A1:N;\"select C,count(A),sum(G),avg(G) where A is not null and C is not null group by C order by count(A) desc label C 'Kútmárka',count(A) 'Tankolások',sum(G) 'Tankolt liter',avg(G) 'Átlag liter / alkalom'\";1);\"\")"],[109,0,"=IFERROR(QUERY('Tankolások'!A1:N;\"select C,sum(F) where A is not null and C is not null and L = 'HUF' group by C order by sum(F) desc label C 'Kútmárka',sum(F) 'Költség (HUF)'\";1);\"\")"],[214,0,"=IFERROR(QUERY('Tankolások'!A1:N;\"select C,D,count(A),sum(G) where A is not null and C is not null group by C,D order by count(A) desc limit 10 label C 'Márka',D 'Hely',count(A) 'Tankolások',sum(G) 'Tankolt liter'\";1);\"\")"],[214,4,"Kút"],[215,4,"=IF(A216=\"\";\"\";A216&\" · \"&B216)"],[216,4,"=IF(A217=\"\";\"\";A217&\" · \"&B217)"],[217,4,"=IF(A218=\"\";\"\";A218&\" · \"&B218)"],[218,4,"=IF(A219=\"\";\"\";A219&\" · \"&B219)"],[219,4,"=IF(A220=\"\";\"\";A220&\" · \"&B220)"],[220,4,"=IF(A221=\"\";\"\";A221&\" · \"&B221)"],[221,4,"=IF(A222=\"\";\"\";A222&\" · \"&B222)"],[222,4,"=IF(A223=\"\";\"\";A223&\" · \"&B223)"],[223,4,"=IF(A224=\"\";\"\";A224&\" · \"&B224)"],[224,4,"=IF(A225=\"\";\"\";A225&\" · \"&B225)"],[234,0,"Hónap"],[234,1,"Tankolások"],[234,2,"Tankolt liter"],[234,3,"Költség (HUF)"],[235,0,"=EDATE(DATE(YEAR(TODAY());MONTH(TODAY());1);-23)"],[235,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A236;'Tankolások'!A$2:A;\"<\"&EDATE(A236;1))"],[235,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A236;'Tankolások'!A$2:A;\"<\"&EDATE(A236;1))"],[235,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A236;'Tankolások'!A$2:A;\"<\"&EDATE(A236;1);'Tankolások'!L$2:L;\"HUF\")"],[236,0,"=EDATE(A236;1)"],[236,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A237;'Tankolások'!A$2:A;\"<\"&EDATE(A237;1))"],[236,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A237;'Tankolások'!A$2:A;\"<\"&EDATE(A237;1))"],[236,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A237;'Tankolások'!A$2:A;\"<\"&EDATE(A237;1);'Tankolások'!L$2:L;\"HUF\")"],[237,0,"=EDATE(A237;1)"],[237,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A238;'Tankolások'!A$2:A;\"<\"&EDATE(A238;1))"],[237,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A238;'Tankolások'!A$2:A;\"<\"&EDATE(A238;1))"],[237,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A238;'Tankolások'!A$2:A;\"<\"&EDATE(A238;1);'Tankolások'!L$2:L;\"HUF\")"],[238,0,"=EDATE(A238;1)"],[238,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A239;'Tankolások'!A$2:A;\"<\"&EDATE(A239;1))"],[238,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A239;'Tankolások'!A$2:A;\"<\"&EDATE(A239;1))"],[238,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A239;'Tankolások'!A$2:A;\"<\"&EDATE(A239;1);'Tankolások'!L$2:L;\"HUF\")"],[239,0,"=EDATE(A239;1)"],[239,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A240;'Tankolások'!A$2:A;\"<\"&EDATE(A240;1))"],[239,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A240;'Tankolások'!A$2:A;\"<\"&EDATE(A240;1))"],[239,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A240;'Tankolások'!A$2:A;\"<\"&EDATE(A240;1);'Tankolások'!L$2:L;\"HUF\")"],[240,0,"=EDATE(A240;1)"],[240,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A241;'Tankolások'!A$2:A;\"<\"&EDATE(A241;1))"],[240,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A241;'Tankolások'!A$2:A;\"<\"&EDATE(A241;1))"],[240,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A241;'Tankolások'!A$2:A;\"<\"&EDATE(A241;1);'Tankolások'!L$2:L;\"HUF\")"],[241,0,"=EDATE(A241;1)"],[241,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A242;'Tankolások'!A$2:A;\"<\"&EDATE(A242;1))"],[241,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A242;'Tankolások'!A$2:A;\"<\"&EDATE(A242;1))"],[241,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A242;'Tankolások'!A$2:A;\"<\"&EDATE(A242;1);'Tankolások'!L$2:L;\"HUF\")"],[242,0,"=EDATE(A242;1)"],[242,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A243;'Tankolások'!A$2:A;\"<\"&EDATE(A243;1))"],[242,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A243;'Tankolások'!A$2:A;\"<\"&EDATE(A243;1))"],[242,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A243;'Tankolások'!A$2:A;\"<\"&EDATE(A243;1);'Tankolások'!L$2:L;\"HUF\")"],[243,0,"=EDATE(A243;1)"],[243,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A244;'Tankolások'!A$2:A;\"<\"&EDATE(A244;1))"],[243,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A244;'Tankolások'!A$2:A;\"<\"&EDATE(A244;1))"],[243,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A244;'Tankolások'!A$2:A;\"<\"&EDATE(A244;1);'Tankolások'!L$2:L;\"HUF\")"],[244,0,"=EDATE(A244;1)"],[244,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A245;'Tankolások'!A$2:A;\"<\"&EDATE(A245;1))"],[244,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A245;'Tankolások'!A$2:A;\"<\"&EDATE(A245;1))"],[244,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A245;'Tankolások'!A$2:A;\"<\"&EDATE(A245;1);'Tankolások'!L$2:L;\"HUF\")"],[245,0,"=EDATE(A245;1)"],[245,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A246;'Tankolások'!A$2:A;\"<\"&EDATE(A246;1))"],[245,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A246;'Tankolások'!A$2:A;\"<\"&EDATE(A246;1))"],[245,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A246;'Tankolások'!A$2:A;\"<\"&EDATE(A246;1);'Tankolások'!L$2:L;\"HUF\")"],[246,0,"=EDATE(A246;1)"],[246,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A247;'Tankolások'!A$2:A;\"<\"&EDATE(A247;1))"],[246,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A247;'Tankolások'!A$2:A;\"<\"&EDATE(A247;1))"],[246,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A247;'Tankolások'!A$2:A;\"<\"&EDATE(A247;1);'Tankolások'!L$2:L;\"HUF\")"],[247,0,"=EDATE(A247;1)"],[247,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A248;'Tankolások'!A$2:A;\"<\"&EDATE(A248;1))"],[247,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A248;'Tankolások'!A$2:A;\"<\"&EDATE(A248;1))"],[247,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A248;'Tankolások'!A$2:A;\"<\"&EDATE(A248;1);'Tankolások'!L$2:L;\"HUF\")"],[248,0,"=EDATE(A248;1)"],[248,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A249;'Tankolások'!A$2:A;\"<\"&EDATE(A249;1))"],[248,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A249;'Tankolások'!A$2:A;\"<\"&EDATE(A249;1))"],[248,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A249;'Tankolások'!A$2:A;\"<\"&EDATE(A249;1);'Tankolások'!L$2:L;\"HUF\")"],[249,0,"=EDATE(A249;1)"],[249,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A250;'Tankolások'!A$2:A;\"<\"&EDATE(A250;1))"],[249,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A250;'Tankolások'!A$2:A;\"<\"&EDATE(A250;1))"],[249,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A250;'Tankolások'!A$2:A;\"<\"&EDATE(A250;1);'Tankolások'!L$2:L;\"HUF\")"],[250,0,"=EDATE(A250;1)"],[250,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A251;'Tankolások'!A$2:A;\"<\"&EDATE(A251;1))"],[250,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A251;'Tankolások'!A$2:A;\"<\"&EDATE(A251;1))"],[250,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A251;'Tankolások'!A$2:A;\"<\"&EDATE(A251;1);'Tankolások'!L$2:L;\"HUF\")"],[251,0,"=EDATE(A251;1)"],[251,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A252;'Tankolások'!A$2:A;\"<\"&EDATE(A252;1))"],[251,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A252;'Tankolások'!A$2:A;\"<\"&EDATE(A252;1))"],[251,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A252;'Tankolások'!A$2:A;\"<\"&EDATE(A252;1);'Tankolások'!L$2:L;\"HUF\")"],[252,0,"=EDATE(A252;1)"],[252,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A253;'Tankolások'!A$2:A;\"<\"&EDATE(A253;1))"],[252,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A253;'Tankolások'!A$2:A;\"<\"&EDATE(A253;1))"],[252,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A253;'Tankolások'!A$2:A;\"<\"&EDATE(A253;1);'Tankolások'!L$2:L;\"HUF\")"],[253,0,"=EDATE(A253;1)"],[253,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A254;'Tankolások'!A$2:A;\"<\"&EDATE(A254;1))"],[253,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A254;'Tankolások'!A$2:A;\"<\"&EDATE(A254;1))"],[253,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A254;'Tankolások'!A$2:A;\"<\"&EDATE(A254;1);'Tankolások'!L$2:L;\"HUF\")"],[254,0,"=EDATE(A254;1)"],[254,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A255;'Tankolások'!A$2:A;\"<\"&EDATE(A255;1))"],[254,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A255;'Tankolások'!A$2:A;\"<\"&EDATE(A255;1))"],[254,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A255;'Tankolások'!A$2:A;\"<\"&EDATE(A255;1);'Tankolások'!L$2:L;\"HUF\")"],[255,0,"=EDATE(A255;1)"],[255,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A256;'Tankolások'!A$2:A;\"<\"&EDATE(A256;1))"],[255,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A256;'Tankolások'!A$2:A;\"<\"&EDATE(A256;1))"],[255,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A256;'Tankolások'!A$2:A;\"<\"&EDATE(A256;1);'Tankolások'!L$2:L;\"HUF\")"],[256,0,"=EDATE(A256;1)"],[256,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A257;'Tankolások'!A$2:A;\"<\"&EDATE(A257;1))"],[256,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A257;'Tankolások'!A$2:A;\"<\"&EDATE(A257;1))"],[256,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A257;'Tankolások'!A$2:A;\"<\"&EDATE(A257;1);'Tankolások'!L$2:L;\"HUF\")"],[257,0,"=EDATE(A257;1)"],[257,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A258;'Tankolások'!A$2:A;\"<\"&EDATE(A258;1))"],[257,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A258;'Tankolások'!A$2:A;\"<\"&EDATE(A258;1))"],[257,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A258;'Tankolások'!A$2:A;\"<\"&EDATE(A258;1);'Tankolások'!L$2:L;\"HUF\")"],[258,0,"=EDATE(A258;1)"],[258,1,"=COUNTIFS('Tankolások'!A$2:A;\">=\"&A259;'Tankolások'!A$2:A;\"<\"&EDATE(A259;1))"],[258,2,"=SUMIFS('Tankolások'!G$2:G;'Tankolások'!A$2:A;\">=\"&A259;'Tankolások'!A$2:A;\"<\"&EDATE(A259;1))"],[258,3,"=SUMIFS('Tankolások'!F$2:F;'Tankolások'!A$2:A;\">=\"&A259;'Tankolások'!A$2:A;\"<\"&EDATE(A259;1);'Tankolások'!L$2:L;\"HUF\")"]],"charts":[{"title":"Tankolások kútmárkánként","subtitle":"Teljes napló · alkalom","type":"BAR","legend":"NO_LEGEND","domain":{"startRowIndex":4,"endRowIndex":104,"startColumnIndex":0,"endColumnIndex":1},"series":[{"range":{"startRowIndex":4,"endRowIndex":104,"startColumnIndex":1,"endColumnIndex":2},"color":{"red":0.2,"green":0.47843137,"blue":0.64705884}}],"position":{"anchorCell":{"rowIndex":4},"offsetXPixels":5,"widthPixels":695,"heightPixels":415}},{"title":"Tankolt mennyiség kútmárkánként","subtitle":"Teljes napló · kitöltött litermennyiségek","type":"BAR","legend":"NO_LEGEND","domain":{"startRowIndex":4,"endRowIndex":104,"startColumnIndex":0,"endColumnIndex":1},"series":[{"range":{"startRowIndex":4,"endRowIndex":104,"startColumnIndex":2,"endColumnIndex":3},"color":{"red":0.2,"green":0.47843137,"blue":0.64705884}}],"position":{"anchorCell":{"rowIndex":4,"columnIndex":8},"offsetXPixels":5,"widthPixels":695,"heightPixels":415}},{"title":"Forintköltés kútmárkánként","subtitle":"Csak HUF-bejegyzések · átváltás nélkül","type":"BAR","legend":"NO_LEGEND","domain":{"startRowIndex":109,"endRowIndex":210,"startColumnIndex":0,"endColumnIndex":1},"series":[{"range":{"startRowIndex":109,"endRowIndex":210,"startColumnIndex":1,"endColumnIndex":2},"color":{"red":0.2,"green":0.47843137,"blue":0.64705884}}],"position":{"anchorCell":{"rowIndex":24},"offsetXPixels":5,"widthPixels":695,"heightPixels":415}},{"title":"A 10 leggyakoribb benzinkút","subtitle":"Kútmárka és hely · alkalom","type":"BAR","legend":"NO_LEGEND","domain":{"startRowIndex":214,"endRowIndex":225,"startColumnIndex":4,"endColumnIndex":5},"series":[{"range":{"startRowIndex":214,"endRowIndex":225,"startColumnIndex":2,"endColumnIndex":3},"color":{"red":0.2,"green":0.47843137,"blue":0.64705884}}],"position":{"anchorCell":{"rowIndex":24,"columnIndex":8},"offsetXPixels":5,"widthPixels":695,"heightPixels":415}},{"title":"Havi tankolt mennyiség","subtitle":"Utolsó 24 hónap · a folyó hónap még nem teljes","type":"COLUMN","legend":"NO_LEGEND","domain":{"startRowIndex":234,"endRowIndex":259,"startColumnIndex":0,"endColumnIndex":1},"series":[{"range":{"startRowIndex":234,"endRowIndex":259,"startColumnIndex":2,"endColumnIndex":3},"color":{"red":0.2,"green":0.47843137,"blue":0.64705884}}],"position":{"anchorCell":{"rowIndex":44},"offsetXPixels":5,"widthPixels":695,"heightPixels":415}},{"title":"Havi forintköltés","subtitle":"Utolsó 24 hónap · csak HUF · folyó hónap részleges","type":"COLUMN","legend":"NO_LEGEND","domain":{"startRowIndex":234,"endRowIndex":259,"startColumnIndex":0,"endColumnIndex":1},"series":[{"range":{"startRowIndex":234,"endRowIndex":259,"startColumnIndex":3,"endColumnIndex":4},"color":{"red":0.2,"green":0.47843137,"blue":0.64705884}}],"position":{"anchorCell":{"rowIndex":44,"columnIndex":8},"offsetXPixels":5,"widthPixels":695,"heightPixels":415}}],"description":"Kútmárkák: tankolásszám, liter és HUF-költés; a 10 leggyakoribb kút; havi liter és HUF-költés az utolsó 24 hónapban. Átváltás nincs.","auxiliary":{"title":"Kútszínek","rows":[[0,0,"Kútmárka"],[0,1,"MOL"],[0,2,"MOL · felirat"],[0,3,"OMV"],[0,4,"OMV · felirat"],[0,5,"Shell"],[0,6,"Shell · felirat"],[0,7,"BGW"],[0,8,"BGW · felirat"],[0,9,"INA"],[0,10,"INA · felirat"],[0,11,"Petrol"],[0,12,"Petrol · felirat"],[0,13,"AVIA"],[0,14,"AVIA · felirat"],[0,15,"Mobil Petrol"],[0,16,"Mobil Petrol · felirat"],[0,17,"Eni"],[0,18,"Eni · felirat"],[0,19,"Egyéb"],[0,20,"Egyéb · felirat"],[0,21,"Petrom"],[0,22,"Petrom · felirat"],[0,23,"JET"],[0,24,"JET · felirat"],[0,25,"Lukoil"],[0,26,"Lukoil · felirat"],[0,27,"Mini Tank"],[0,28,"Mini Tank · felirat"],[0,29,"Orlen"],[0,30,"Orlen · felirat"],[0,31,"Q8"],[0,32,"Q8 · felirat"],[0,33,"Tankomat"],[0,34,"Tankomat · felirat"],[0,35,"További márkák"],[0,36,"További márkák · felirat"],[1,0,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";Grafikonadatok!A6:A104))"],[1,1,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=B$1;Grafikonadatok!B6:B104;0)))"],[1,2,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=B$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,3,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=D$1;Grafikonadatok!B6:B104;0)))"],[1,4,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=D$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,5,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=F$1;Grafikonadatok!B6:B104;0)))"],[1,6,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=F$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,7,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=H$1;Grafikonadatok!B6:B104;0)))"],[1,8,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=H$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,9,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=J$1;Grafikonadatok!B6:B104;0)))"],[1,10,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=J$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,11,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=L$1;Grafikonadatok!B6:B104;0)))"],[1,12,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=L$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,13,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=N$1;Grafikonadatok!B6:B104;0)))"],[1,14,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=N$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,15,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=P$1;Grafikonadatok!B6:B104;0)))"],[1,16,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=P$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,17,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=R$1;Grafikonadatok!B6:B104;0)))"],[1,18,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=R$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,19,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=T$1;Grafikonadatok!B6:B104;0)))"],[1,20,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=T$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,21,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=V$1;Grafikonadatok!B6:B104;0)))"],[1,22,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=V$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,23,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=X$1;Grafikonadatok!B6:B104;0)))"],[1,24,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=X$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,25,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=Z$1;Grafikonadatok!B6:B104;0)))"],[1,26,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=Z$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,27,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AB$1;Grafikonadatok!B6:B104;0)))"],[1,28,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AB$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,29,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AD$1;Grafikonadatok!B6:B104;0)))"],[1,30,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AD$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,31,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AF$1;Grafikonadatok!B6:B104;0)))"],[1,32,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AF$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,33,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AH$1;Grafikonadatok!B6:B104;0)))"],[1,34,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AH$1;TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[1,35,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(ISNA(MATCH(Grafikonadatok!A6:A104;{$B$1;$D$1;$F$1;$H$1;$J$1;$L$1;$N$1;$P$1;$R$1;$T$1;$V$1;$X$1;$Z$1;$AB$1;$AD$1;$AF$1;$AH$1};0));Grafikonadatok!B6:B104;0)))"],[1,36,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(ISNA(MATCH(Grafikonadatok!A6:A104;{$B$1;$D$1;$F$1;$H$1;$J$1;$L$1;$N$1;$P$1;$R$1;$T$1;$V$1;$X$1;$Z$1;$AB$1;$AD$1;$AF$1;$AH$1};0));TEXT(Grafikonadatok!B6:B104;\"#,##0\");\"\")))"],[110,0,"Kútmárka"],[110,1,"MOL"],[110,2,"MOL · felirat"],[110,3,"OMV"],[110,4,"OMV · felirat"],[110,5,"Shell"],[110,6,"Shell · felirat"],[110,7,"BGW"],[110,8,"BGW · felirat"],[110,9,"INA"],[110,10,"INA · felirat"],[110,11,"Petrol"],[110,12,"Petrol · felirat"],[110,13,"AVIA"],[110,14,"AVIA · felirat"],[110,15,"Mobil Petrol"],[110,16,"Mobil Petrol · felirat"],[110,17,"Eni"],[110,18,"Eni · felirat"],[110,19,"Egyéb"],[110,20,"Egyéb · felirat"],[110,21,"Petrom"],[110,22,"Petrom · felirat"],[110,23,"JET"],[110,24,"JET · felirat"],[110,25,"Lukoil"],[110,26,"Lukoil · felirat"],[110,27,"Mini Tank"],[110,28,"Mini Tank · felirat"],[110,29,"Orlen"],[110,30,"Orlen · felirat"],[110,31,"Q8"],[110,32,"Q8 · felirat"],[110,33,"Tankomat"],[110,34,"Tankomat · felirat"],[110,35,"További márkák"],[110,36,"További márkák · felirat"],[111,0,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";Grafikonadatok!A6:A104))"],[111,1,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=B$111;Grafikonadatok!C6:C104;0)))"],[111,2,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=B$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,3,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=D$111;Grafikonadatok!C6:C104;0)))"],[111,4,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=D$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,5,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=F$111;Grafikonadatok!C6:C104;0)))"],[111,6,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=F$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,7,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=H$111;Grafikonadatok!C6:C104;0)))"],[111,8,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=H$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,9,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=J$111;Grafikonadatok!C6:C104;0)))"],[111,10,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=J$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,11,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=L$111;Grafikonadatok!C6:C104;0)))"],[111,12,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=L$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,13,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=N$111;Grafikonadatok!C6:C104;0)))"],[111,14,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=N$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,15,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=P$111;Grafikonadatok!C6:C104;0)))"],[111,16,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=P$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,17,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=R$111;Grafikonadatok!C6:C104;0)))"],[111,18,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=R$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,19,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=T$111;Grafikonadatok!C6:C104;0)))"],[111,20,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=T$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,21,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=V$111;Grafikonadatok!C6:C104;0)))"],[111,22,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=V$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,23,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=X$111;Grafikonadatok!C6:C104;0)))"],[111,24,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=X$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,25,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=Z$111;Grafikonadatok!C6:C104;0)))"],[111,26,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=Z$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,27,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AB$111;Grafikonadatok!C6:C104;0)))"],[111,28,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AB$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,29,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AD$111;Grafikonadatok!C6:C104;0)))"],[111,30,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AD$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,31,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AF$111;Grafikonadatok!C6:C104;0)))"],[111,32,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AF$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,33,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AH$111;Grafikonadatok!C6:C104;0)))"],[111,34,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(Grafikonadatok!A6:A104=AH$111;TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[111,35,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(ISNA(MATCH(Grafikonadatok!A6:A104;{$B$111;$D$111;$F$111;$H$111;$J$111;$L$111;$N$111;$P$111;$R$111;$T$111;$V$111;$X$111;$Z$111;$AB$111;$AD$111;$AF$111;$AH$111};0));Grafikonadatok!C6:C104;0)))"],[111,36,"=ARRAYFORMULA(IF(Grafikonadatok!A6:A104=\"\";\"\";IF(ISNA(MATCH(Grafikonadatok!A6:A104;{$B$111;$D$111;$F$111;$H$111;$J$111;$L$111;$N$111;$P$111;$R$111;$T$111;$V$111;$X$111;$Z$111;$AB$111;$AD$111;$AF$111;$AH$111};0));TEXT(Grafikonadatok!C6:C104;\"#,##0.0\");\"\")))"],[220,0,"Kútmárka"],[220,1,"MOL"],[220,2,"MOL · felirat"],[220,3,"OMV"],[220,4,"OMV · felirat"],[220,5,"Shell"],[220,6,"Shell · felirat"],[220,7,"BGW"],[220,8,"BGW · felirat"],[220,9,"INA"],[220,10,"INA · felirat"],[220,11,"Petrol"],[220,12,"Petrol · felirat"],[220,13,"AVIA"],[220,14,"AVIA · felirat"],[220,15,"Mobil Petrol"],[220,16,"Mobil Petrol · felirat"],[220,17,"Eni"],[220,18,"Eni · felirat"],[220,19,"Egyéb"],[220,20,"Egyéb · felirat"],[220,21,"Petrom"],[220,22,"Petrom · felirat"],[220,23,"JET"],[220,24,"JET · felirat"],[220,25,"Lukoil"],[220,26,"Lukoil · felirat"],[220,27,"Mini Tank"],[220,28,"Mini Tank · felirat"],[220,29,"Orlen"],[220,30,"Orlen · felirat"],[220,31,"Q8"],[220,32,"Q8 · felirat"],[220,33,"Tankomat"],[220,34,"Tankomat · felirat"],[220,35,"További márkák"],[220,36,"További márkák · felirat"],[221,0,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";Grafikonadatok!A111:A210))"],[221,1,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=B$221;Grafikonadatok!B111:B210;0)))"],[221,2,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=B$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,3,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=D$221;Grafikonadatok!B111:B210;0)))"],[221,4,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=D$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,5,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=F$221;Grafikonadatok!B111:B210;0)))"],[221,6,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=F$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,7,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=H$221;Grafikonadatok!B111:B210;0)))"],[221,8,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=H$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,9,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=J$221;Grafikonadatok!B111:B210;0)))"],[221,10,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=J$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,11,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=L$221;Grafikonadatok!B111:B210;0)))"],[221,12,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=L$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,13,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=N$221;Grafikonadatok!B111:B210;0)))"],[221,14,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=N$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,15,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=P$221;Grafikonadatok!B111:B210;0)))"],[221,16,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=P$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,17,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=R$221;Grafikonadatok!B111:B210;0)))"],[221,18,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=R$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,19,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=T$221;Grafikonadatok!B111:B210;0)))"],[221,20,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=T$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,21,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=V$221;Grafikonadatok!B111:B210;0)))"],[221,22,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=V$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,23,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=X$221;Grafikonadatok!B111:B210;0)))"],[221,24,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=X$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,25,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=Z$221;Grafikonadatok!B111:B210;0)))"],[221,26,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=Z$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,27,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=AB$221;Grafikonadatok!B111:B210;0)))"],[221,28,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=AB$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,29,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=AD$221;Grafikonadatok!B111:B210;0)))"],[221,30,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=AD$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,31,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=AF$221;Grafikonadatok!B111:B210;0)))"],[221,32,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=AF$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,33,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=AH$221;Grafikonadatok!B111:B210;0)))"],[221,34,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(Grafikonadatok!A111:A210=AH$221;TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[221,35,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(ISNA(MATCH(Grafikonadatok!A111:A210;{$B$221;$D$221;$F$221;$H$221;$J$221;$L$221;$N$221;$P$221;$R$221;$T$221;$V$221;$X$221;$Z$221;$AB$221;$AD$221;$AF$221;$AH$221};0));Grafikonadatok!B111:B210;0)))"],[221,36,"=ARRAYFORMULA(IF(Grafikonadatok!A111:A210=\"\";\"\";IF(ISNA(MATCH(Grafikonadatok!A111:A210;{$B$221;$D$221;$F$221;$H$221;$J$221;$L$221;$N$221;$P$221;$R$221;$T$221;$V$221;$X$221;$Z$221;$AB$221;$AD$221;$AF$221;$AH$221};0));TEXT(Grafikonadatok!B111:B210;\"#,##0\");\"\")))"],[330,0,"Benzinkút"],[330,1,"MOL"],[330,2,"MOL · felirat"],[330,3,"OMV"],[330,4,"OMV · felirat"],[330,5,"Shell"],[330,6,"Shell · felirat"],[330,7,"BGW"],[330,8,"BGW · felirat"],[330,9,"INA"],[330,10,"INA · felirat"],[330,11,"Petrol"],[330,12,"Petrol · felirat"],[330,13,"AVIA"],[330,14,"AVIA · felirat"],[330,15,"Mobil Petrol"],[330,16,"Mobil Petrol · felirat"],[330,17,"Eni"],[330,18,"Eni · felirat"],[330,19,"Egyéb"],[330,20,"Egyéb · felirat"],[330,21,"Petrom"],[330,22,"Petrom · felirat"],[330,23,"JET"],[330,24,"JET · felirat"],[330,25,"Lukoil"],[330,26,"Lukoil · felirat"],[330,27,"Mini Tank"],[330,28,"Mini Tank · felirat"],[330,29,"Orlen"],[330,30,"Orlen · felirat"],[330,31,"Q8"],[330,32,"Q8 · felirat"],[330,33,"Tankomat"],[330,34,"Tankomat · felirat"],[330,35,"További márkák"],[330,36,"További márkák · felirat"],[331,0,"=ARRAYFORMULA(IF(Grafikonadatok!E216:E225=\"\";\"\";Grafikonadatok!E216:E225))"],[331,1,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=B$331;Grafikonadatok!C216:C225;0)))"],[331,2,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=B$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,3,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=D$331;Grafikonadatok!C216:C225;0)))"],[331,4,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=D$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,5,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=F$331;Grafikonadatok!C216:C225;0)))"],[331,6,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=F$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,7,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=H$331;Grafikonadatok!C216:C225;0)))"],[331,8,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=H$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,9,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=J$331;Grafikonadatok!C216:C225;0)))"],[331,10,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=J$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,11,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=L$331;Grafikonadatok!C216:C225;0)))"],[331,12,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=L$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,13,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=N$331;Grafikonadatok!C216:C225;0)))"],[331,14,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=N$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,15,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=P$331;Grafikonadatok!C216:C225;0)))"],[331,16,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=P$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,17,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=R$331;Grafikonadatok!C216:C225;0)))"],[331,18,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=R$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,19,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=T$331;Grafikonadatok!C216:C225;0)))"],[331,20,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=T$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,21,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=V$331;Grafikonadatok!C216:C225;0)))"],[331,22,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=V$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,23,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=X$331;Grafikonadatok!C216:C225;0)))"],[331,24,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=X$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,25,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=Z$331;Grafikonadatok!C216:C225;0)))"],[331,26,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=Z$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,27,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=AB$331;Grafikonadatok!C216:C225;0)))"],[331,28,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=AB$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,29,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=AD$331;Grafikonadatok!C216:C225;0)))"],[331,30,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=AD$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,31,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=AF$331;Grafikonadatok!C216:C225;0)))"],[331,32,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=AF$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,33,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=AH$331;Grafikonadatok!C216:C225;0)))"],[331,34,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(Grafikonadatok!A216:A225=AH$331;TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"],[331,35,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(ISNA(MATCH(Grafikonadatok!A216:A225;{$B$331;$D$331;$F$331;$H$331;$J$331;$L$331;$N$331;$P$331;$R$331;$T$331;$V$331;$X$331;$Z$331;$AB$331;$AD$331;$AF$331;$AH$331};0));Grafikonadatok!C216:C225;0)))"],[331,36,"=ARRAYFORMULA(IF(Grafikonadatok!A216:A225=\"\";\"\";IF(ISNA(MATCH(Grafikonadatok!A216:A225;{$B$331;$D$331;$F$331;$H$331;$J$331;$L$331;$N$331;$P$331;$R$331;$T$331;$V$331;$X$331;$Z$331;$AB$331;$AD$331;$AF$331;$AH$331};0));TEXT(Grafikonadatok!C216:C225;\"#,##0\");\"\")))"]]},"nativeCharts":[{"spec":{"title":"Tankolások kútmárkánként","basicChart":{"chartType":"BAR","legendPosition":"NO_LEGEND","axis":[{"position":"BOTTOM_AXIS","title":"Alkalom","format":{"fontFamily":"Calibri","fontSize":13},"viewWindowOptions":{}},{"position":"LEFT_AXIS","viewWindowOptions":{}}],"domains":[{"domain":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":0,"endColumnIndex":1}]}}}],"series":[{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":1,"endColumnIndex":2}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":2,"endColumnIndex":3}]}}},"color":{"red":0.2627451,"green":0.5019608,"blue":0.3764706},"colorStyle":{"rgbColor":{"red":0.2627451,"green":0.5019608,"blue":0.3764706}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":3,"endColumnIndex":4}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":4,"endColumnIndex":5}]}}},"color":{"red":0.27450982,"green":0.47058824,"blue":0.6156863},"colorStyle":{"rgbColor":{"red":0.27450982,"green":0.47058824,"blue":0.6156863}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":5,"endColumnIndex":6}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":6,"endColumnIndex":7}]}}},"color":{"red":0.77254903,"green":0.6392157,"blue":0.29803923},"colorStyle":{"rgbColor":{"red":0.77254903,"green":0.6392157,"blue":0.29803923}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":7,"endColumnIndex":8}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":8,"endColumnIndex":9}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":9,"endColumnIndex":10}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":10,"endColumnIndex":11}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":11,"endColumnIndex":12}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":12,"endColumnIndex":13}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":13,"endColumnIndex":14}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":14,"endColumnIndex":15}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":15,"endColumnIndex":16}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":16,"endColumnIndex":17}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":17,"endColumnIndex":18}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":18,"endColumnIndex":19}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":19,"endColumnIndex":20}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":20,"endColumnIndex":21}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":21,"endColumnIndex":22}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":22,"endColumnIndex":23}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":23,"endColumnIndex":24}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":24,"endColumnIndex":25}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":25,"endColumnIndex":26}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":26,"endColumnIndex":27}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":27,"endColumnIndex":28}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":28,"endColumnIndex":29}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":29,"endColumnIndex":30}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":30,"endColumnIndex":31}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":31,"endColumnIndex":32}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":32,"endColumnIndex":33}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":33,"endColumnIndex":34}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":34,"endColumnIndex":35}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":35,"endColumnIndex":36}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":0,"endRowIndex":100,"startColumnIndex":36,"endColumnIndex":37}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}}],"headerCount":1,"stackedType":"STACKED"},"hiddenDimensionStrategy":"SHOW_ALL","titleTextFormat":{"foregroundColor":{"red":0.14117648,"green":0.19607843,"blue":0.2784314},"fontFamily":"Calibri","fontSize":20,"bold":true,"foregroundColorStyle":{"rgbColor":{"red":0.14117648,"green":0.19607843,"blue":0.2784314}}},"fontName":"Calibri","subtitle":"Teljes napló · alkalom","subtitleTextFormat":{"foregroundColor":{"red":0.41960785,"green":0.44705883,"blue":0.5019608},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.41960785,"green":0.44705883,"blue":0.5019608}}}},"position":{"anchorCell":{"sheetTitle":"Kútstatisztika","rowIndex":5},"offsetXPixels":8,"widthPixels":1080,"heightPixels":680}},{"spec":{"title":"Tankolt mennyiség kútmárkánként","basicChart":{"chartType":"BAR","legendPosition":"NO_LEGEND","axis":[{"position":"BOTTOM_AXIS","title":"Liter","format":{"fontFamily":"Calibri","fontSize":13},"viewWindowOptions":{}},{"position":"LEFT_AXIS","viewWindowOptions":{}}],"domains":[{"domain":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":0,"endColumnIndex":1}]}}}],"series":[{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":1,"endColumnIndex":2}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":2,"endColumnIndex":3}]}}},"color":{"red":0.2627451,"green":0.5019608,"blue":0.3764706},"colorStyle":{"rgbColor":{"red":0.2627451,"green":0.5019608,"blue":0.3764706}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":3,"endColumnIndex":4}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":4,"endColumnIndex":5}]}}},"color":{"red":0.27450982,"green":0.47058824,"blue":0.6156863},"colorStyle":{"rgbColor":{"red":0.27450982,"green":0.47058824,"blue":0.6156863}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":5,"endColumnIndex":6}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":6,"endColumnIndex":7}]}}},"color":{"red":0.77254903,"green":0.6392157,"blue":0.29803923},"colorStyle":{"rgbColor":{"red":0.77254903,"green":0.6392157,"blue":0.29803923}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":7,"endColumnIndex":8}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":8,"endColumnIndex":9}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":9,"endColumnIndex":10}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":10,"endColumnIndex":11}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":11,"endColumnIndex":12}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":12,"endColumnIndex":13}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":13,"endColumnIndex":14}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":14,"endColumnIndex":15}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":15,"endColumnIndex":16}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":16,"endColumnIndex":17}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":17,"endColumnIndex":18}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":18,"endColumnIndex":19}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":19,"endColumnIndex":20}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":20,"endColumnIndex":21}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":21,"endColumnIndex":22}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":22,"endColumnIndex":23}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":23,"endColumnIndex":24}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":24,"endColumnIndex":25}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":25,"endColumnIndex":26}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":26,"endColumnIndex":27}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":27,"endColumnIndex":28}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":28,"endColumnIndex":29}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":29,"endColumnIndex":30}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":30,"endColumnIndex":31}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":31,"endColumnIndex":32}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":32,"endColumnIndex":33}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":33,"endColumnIndex":34}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":34,"endColumnIndex":35}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":35,"endColumnIndex":36}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":110,"endRowIndex":210,"startColumnIndex":36,"endColumnIndex":37}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}}],"headerCount":1,"stackedType":"STACKED"},"hiddenDimensionStrategy":"SHOW_ALL","titleTextFormat":{"foregroundColor":{"red":0.14117648,"green":0.19607843,"blue":0.2784314},"fontFamily":"Calibri","fontSize":20,"bold":true,"foregroundColorStyle":{"rgbColor":{"red":0.14117648,"green":0.19607843,"blue":0.2784314}}},"fontName":"Calibri","subtitle":"Teljes napló · kitöltött litermennyiségek","subtitleTextFormat":{"foregroundColor":{"red":0.41960785,"green":0.44705883,"blue":0.5019608},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.41960785,"green":0.44705883,"blue":0.5019608}}}},"position":{"anchorCell":{"sheetTitle":"Kútstatisztika","rowIndex":39},"offsetXPixels":8,"widthPixels":1080,"heightPixels":680}},{"spec":{"title":"Forintköltés kútmárkánként","basicChart":{"chartType":"BAR","legendPosition":"NO_LEGEND","axis":[{"position":"BOTTOM_AXIS","title":"Forint","format":{"fontFamily":"Calibri","fontSize":13},"viewWindowOptions":{}},{"position":"LEFT_AXIS","viewWindowOptions":{}}],"domains":[{"domain":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":0,"endColumnIndex":1}]}}}],"series":[{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":1,"endColumnIndex":2}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":2,"endColumnIndex":3}]}}},"color":{"red":0.2627451,"green":0.5019608,"blue":0.3764706},"colorStyle":{"rgbColor":{"red":0.2627451,"green":0.5019608,"blue":0.3764706}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":3,"endColumnIndex":4}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":4,"endColumnIndex":5}]}}},"color":{"red":0.27450982,"green":0.47058824,"blue":0.6156863},"colorStyle":{"rgbColor":{"red":0.27450982,"green":0.47058824,"blue":0.6156863}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":5,"endColumnIndex":6}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":6,"endColumnIndex":7}]}}},"color":{"red":0.77254903,"green":0.6392157,"blue":0.29803923},"colorStyle":{"rgbColor":{"red":0.77254903,"green":0.6392157,"blue":0.29803923}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":7,"endColumnIndex":8}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":8,"endColumnIndex":9}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":9,"endColumnIndex":10}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":10,"endColumnIndex":11}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":11,"endColumnIndex":12}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":12,"endColumnIndex":13}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":13,"endColumnIndex":14}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":14,"endColumnIndex":15}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":15,"endColumnIndex":16}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":16,"endColumnIndex":17}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":17,"endColumnIndex":18}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":18,"endColumnIndex":19}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":19,"endColumnIndex":20}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":20,"endColumnIndex":21}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":21,"endColumnIndex":22}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":22,"endColumnIndex":23}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":23,"endColumnIndex":24}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":24,"endColumnIndex":25}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":25,"endColumnIndex":26}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":26,"endColumnIndex":27}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":27,"endColumnIndex":28}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":28,"endColumnIndex":29}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":29,"endColumnIndex":30}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":30,"endColumnIndex":31}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":31,"endColumnIndex":32}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":32,"endColumnIndex":33}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":33,"endColumnIndex":34}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":34,"endColumnIndex":35}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":35,"endColumnIndex":36}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":220,"endRowIndex":321,"startColumnIndex":36,"endColumnIndex":37}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}}],"headerCount":1,"stackedType":"STACKED"},"hiddenDimensionStrategy":"SHOW_ALL","titleTextFormat":{"foregroundColor":{"red":0.14117648,"green":0.19607843,"blue":0.2784314},"fontFamily":"Calibri","fontSize":20,"bold":true,"foregroundColorStyle":{"rgbColor":{"red":0.14117648,"green":0.19607843,"blue":0.2784314}}},"fontName":"Calibri","subtitle":"Csak HUF-bejegyzések · átváltás nélkül","subtitleTextFormat":{"foregroundColor":{"red":0.41960785,"green":0.44705883,"blue":0.5019608},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.41960785,"green":0.44705883,"blue":0.5019608}}}},"position":{"anchorCell":{"sheetTitle":"Kútstatisztika","rowIndex":73},"offsetXPixels":8,"widthPixels":1080,"heightPixels":680}},{"spec":{"title":"A 10 leggyakoribb benzinkút","basicChart":{"chartType":"BAR","legendPosition":"NO_LEGEND","axis":[{"position":"BOTTOM_AXIS","title":"Alkalom","format":{"fontFamily":"Calibri","fontSize":13},"viewWindowOptions":{}},{"position":"LEFT_AXIS","viewWindowOptions":{}}],"domains":[{"domain":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":0,"endColumnIndex":1}]}}}],"series":[{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":1,"endColumnIndex":2}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":2,"endColumnIndex":3}]}}},"color":{"red":0.2627451,"green":0.5019608,"blue":0.3764706},"colorStyle":{"rgbColor":{"red":0.2627451,"green":0.5019608,"blue":0.3764706}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":3,"endColumnIndex":4}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":4,"endColumnIndex":5}]}}},"color":{"red":0.27450982,"green":0.47058824,"blue":0.6156863},"colorStyle":{"rgbColor":{"red":0.27450982,"green":0.47058824,"blue":0.6156863}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":5,"endColumnIndex":6}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":6,"endColumnIndex":7}]}}},"color":{"red":0.77254903,"green":0.6392157,"blue":0.29803923},"colorStyle":{"rgbColor":{"red":0.77254903,"green":0.6392157,"blue":0.29803923}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":7,"endColumnIndex":8}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":8,"endColumnIndex":9}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":9,"endColumnIndex":10}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":10,"endColumnIndex":11}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":11,"endColumnIndex":12}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":12,"endColumnIndex":13}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":13,"endColumnIndex":14}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":14,"endColumnIndex":15}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":15,"endColumnIndex":16}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":16,"endColumnIndex":17}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":17,"endColumnIndex":18}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":18,"endColumnIndex":19}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":19,"endColumnIndex":20}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":20,"endColumnIndex":21}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":21,"endColumnIndex":22}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":22,"endColumnIndex":23}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":23,"endColumnIndex":24}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":24,"endColumnIndex":25}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":25,"endColumnIndex":26}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":26,"endColumnIndex":27}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":27,"endColumnIndex":28}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":28,"endColumnIndex":29}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":29,"endColumnIndex":30}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":30,"endColumnIndex":31}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":31,"endColumnIndex":32}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":32,"endColumnIndex":33}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":33,"endColumnIndex":34}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":34,"endColumnIndex":35}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}},{"series":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":35,"endColumnIndex":36}]}},"targetAxis":"BOTTOM_AXIS","dataLabel":{"type":"CUSTOM","textFormat":{"foregroundColor":{"red":0.2,"green":0.25490198,"blue":0.33333334},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.2,"green":0.25490198,"blue":0.33333334}}},"placement":"OUTSIDE_END","customLabelData":{"sourceRange":{"sources":[{"sheetTitle":"Kútszínek","startRowIndex":330,"endRowIndex":341,"startColumnIndex":36,"endColumnIndex":37}]}}},"color":{"red":0.627451,"green":0.6745098,"blue":0.72156864},"colorStyle":{"rgbColor":{"red":0.627451,"green":0.6745098,"blue":0.72156864}}}],"headerCount":1,"stackedType":"STACKED"},"hiddenDimensionStrategy":"SHOW_ALL","titleTextFormat":{"foregroundColor":{"red":0.14117648,"green":0.19607843,"blue":0.2784314},"fontFamily":"Calibri","fontSize":20,"bold":true,"foregroundColorStyle":{"rgbColor":{"red":0.14117648,"green":0.19607843,"blue":0.2784314}}},"fontName":"Calibri","subtitle":"Kútmárka és hely · alkalom","subtitleTextFormat":{"foregroundColor":{"red":0.41960785,"green":0.44705883,"blue":0.5019608},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.41960785,"green":0.44705883,"blue":0.5019608}}}},"position":{"anchorCell":{"sheetTitle":"Kútstatisztika","rowIndex":107},"offsetXPixels":8,"widthPixels":1080,"heightPixels":680}},{"spec":{"title":"Havi tankolt mennyiség","basicChart":{"chartType":"LINE","legendPosition":"NO_LEGEND","axis":[{"position":"BOTTOM_AXIS","title":"Hónap","format":{"fontFamily":"Calibri","fontSize":13},"viewWindowOptions":{}},{"position":"LEFT_AXIS","title":"Liter","format":{"fontFamily":"Calibri","fontSize":13},"viewWindowOptions":{}}],"domains":[{"domain":{"sourceRange":{"sources":[{"sheetTitle":"Grafikonadatok","startRowIndex":234,"endRowIndex":259,"startColumnIndex":0,"endColumnIndex":1}]}}}],"series":[{"series":{"sourceRange":{"sources":[{"sheetTitle":"Grafikonadatok","startRowIndex":234,"endRowIndex":259,"startColumnIndex":2,"endColumnIndex":3}]}},"targetAxis":"LEFT_AXIS","lineStyle":{"width":3,"type":"SOLID"},"color":{"red":0.4627451,"green":0.4,"blue":0.6392157},"pointStyle":{"size":4},"colorStyle":{"rgbColor":{"red":0.4627451,"green":0.4,"blue":0.6392157}}}],"headerCount":1},"hiddenDimensionStrategy":"SHOW_ALL","titleTextFormat":{"foregroundColor":{"red":0.14117648,"green":0.19607843,"blue":0.2784314},"fontFamily":"Calibri","fontSize":20,"bold":true,"foregroundColorStyle":{"rgbColor":{"red":0.14117648,"green":0.19607843,"blue":0.2784314}}},"fontName":"Calibri","subtitle":"Utolsó 24 hónap · a folyó hónap még nem teljes","subtitleTextFormat":{"foregroundColor":{"red":0.41960785,"green":0.44705883,"blue":0.5019608},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.41960785,"green":0.44705883,"blue":0.5019608}}}},"position":{"anchorCell":{"sheetTitle":"Kútstatisztika","rowIndex":141},"offsetXPixels":8,"widthPixels":1080,"heightPixels":580}},{"spec":{"title":"Havi forintköltés","basicChart":{"chartType":"LINE","legendPosition":"NO_LEGEND","axis":[{"position":"BOTTOM_AXIS","title":"Hónap","format":{"fontFamily":"Calibri","fontSize":13},"viewWindowOptions":{}},{"position":"LEFT_AXIS","title":"Forint","format":{"fontFamily":"Calibri","fontSize":13},"viewWindowOptions":{}}],"domains":[{"domain":{"sourceRange":{"sources":[{"sheetTitle":"Grafikonadatok","startRowIndex":234,"endRowIndex":259,"startColumnIndex":0,"endColumnIndex":1}]}}}],"series":[{"series":{"sourceRange":{"sources":[{"sheetTitle":"Grafikonadatok","startRowIndex":234,"endRowIndex":259,"startColumnIndex":3,"endColumnIndex":4}]}},"targetAxis":"LEFT_AXIS","lineStyle":{"width":3,"type":"SOLID"},"color":{"red":0.29411766,"green":0.5647059,"blue":0.5411765},"pointStyle":{"size":4},"colorStyle":{"rgbColor":{"red":0.29411766,"green":0.5647059,"blue":0.5411765}}}],"headerCount":1},"hiddenDimensionStrategy":"SHOW_ALL","titleTextFormat":{"foregroundColor":{"red":0.14117648,"green":0.19607843,"blue":0.2784314},"fontFamily":"Calibri","fontSize":20,"bold":true,"foregroundColorStyle":{"rgbColor":{"red":0.14117648,"green":0.19607843,"blue":0.2784314}}},"fontName":"Calibri","subtitle":"Utolsó 24 hónap · csak HUF · folyó hónap részleges","subtitleTextFormat":{"foregroundColor":{"red":0.41960785,"green":0.44705883,"blue":0.5019608},"fontFamily":"Calibri","fontSize":13,"foregroundColorStyle":{"rgbColor":{"red":0.41960785,"green":0.44705883,"blue":0.5019608}}}},"position":{"anchorCell":{"sheetTitle":"Kútstatisztika","rowIndex":175},"offsetXPixels":8,"widthPixels":1080,"heightPixels":580}}]},{"title":"Üzemanyagstatisztika","dataTitle":"Üzemanyagadatok","rows":[[0,0,"Dátum"],[0,1,"Márka"],[0,2,"Üzemanyagtípus"],[0,3,"Csoport"],[0,4,"Liter"],[0,5,"Tele tank?"],[0,7,"=IFERROR(QUERY(A1:F;\"select D,count(A),sum(E) where A is not null group by D order by count(A) desc label D 'Üzemanyagcsoport',count(A) 'Tankolások',sum(E) 'Tankolt liter'\";1);\"\")"],[1,0,"=ARRAYFORMULA(IF('Tankolások'!A2:A=\"\";\"\";'Tankolások'!A2:A))"],[1,1,"=ARRAYFORMULA(IF('Tankolások'!A2:A=\"\";\"\";'Tankolások'!C2:C))"],[1,2,"=ARRAYFORMULA(IF('Tankolások'!A2:A=\"\";\"\";IF(TRIM('Tankolások'!K2:K)=\"\";\"Sima 95-ös (üres típus)\";TRIM('Tankolások'!K2:K))))"],[1,3,"=ARRAYFORMULA(IF('Tankolások'!A2:A=\"\";\"\";IF(REGEXMATCH(LOWER('Tankolások'!K2:K);\"maxxmotion|v.?power|100|98|99|prémium\");\"Prémium / magas oktánszám\";IF((TRIM('Tankolások'!K2:K)=\"\")+REGEXMATCH(LOWER('Tankolások'!K2:K);\"^e95 e10$|^omv super 95$|^sima 95|^normál\");\"Normál 95-ös\";\"Nem egyértelmű\"))))"],[1,4,"=ARRAYFORMULA(IF('Tankolások'!A2:A=\"\";\"\";'Tankolások'!G2:G))"],[1,5,"=ARRAYFORMULA(IF('Tankolások'!A2:A=\"\";\"\";IF('Tankolások'!M2:M=TRUE;\"Tele tank\";IF('Tankolások'!M2:M=FALSE;\"Részleges tankolás\";\"Nincs jelölés\"))))"],[9,7,"=IFERROR(QUERY(A1:F;\"select C,count(A),sum(E) where A is not null group by C order by count(A) desc label C 'Üzemanyagtípus',count(A) 'Tankolások',sum(E) 'Tankolt liter'\";1);\"\")"],[44,7,"Év"],[44,8,"Prémium / magas oktánszám"],[44,9,"Normál 95-ös"],[44,10,"Nem egyértelmű"],[45,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+0<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+0;\"\")"],[45,8,"=IF(H46=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H46;1;1);A$2:A;\"<\"&DATE(H46+1;1;1);D$2:D;I$45))"],[45,9,"=IF(H46=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H46;1;1);A$2:A;\"<\"&DATE(H46+1;1;1);D$2:D;J$45))"],[45,10,"=IF(H46=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H46;1;1);A$2:A;\"<\"&DATE(H46+1;1;1);D$2:D;K$45))"],[46,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+1<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+1;\"\")"],[46,8,"=IF(H47=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H47;1;1);A$2:A;\"<\"&DATE(H47+1;1;1);D$2:D;I$45))"],[46,9,"=IF(H47=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H47;1;1);A$2:A;\"<\"&DATE(H47+1;1;1);D$2:D;J$45))"],[46,10,"=IF(H47=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H47;1;1);A$2:A;\"<\"&DATE(H47+1;1;1);D$2:D;K$45))"],[47,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+2<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+2;\"\")"],[47,8,"=IF(H48=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H48;1;1);A$2:A;\"<\"&DATE(H48+1;1;1);D$2:D;I$45))"],[47,9,"=IF(H48=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H48;1;1);A$2:A;\"<\"&DATE(H48+1;1;1);D$2:D;J$45))"],[47,10,"=IF(H48=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H48;1;1);A$2:A;\"<\"&DATE(H48+1;1;1);D$2:D;K$45))"],[48,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+3<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+3;\"\")"],[48,8,"=IF(H49=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H49;1;1);A$2:A;\"<\"&DATE(H49+1;1;1);D$2:D;I$45))"],[48,9,"=IF(H49=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H49;1;1);A$2:A;\"<\"&DATE(H49+1;1;1);D$2:D;J$45))"],[48,10,"=IF(H49=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H49;1;1);A$2:A;\"<\"&DATE(H49+1;1;1);D$2:D;K$45))"],[49,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+4<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+4;\"\")"],[49,8,"=IF(H50=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H50;1;1);A$2:A;\"<\"&DATE(H50+1;1;1);D$2:D;I$45))"],[49,9,"=IF(H50=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H50;1;1);A$2:A;\"<\"&DATE(H50+1;1;1);D$2:D;J$45))"],[49,10,"=IF(H50=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H50;1;1);A$2:A;\"<\"&DATE(H50+1;1;1);D$2:D;K$45))"],[50,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+5<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+5;\"\")"],[50,8,"=IF(H51=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H51;1;1);A$2:A;\"<\"&DATE(H51+1;1;1);D$2:D;I$45))"],[50,9,"=IF(H51=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H51;1;1);A$2:A;\"<\"&DATE(H51+1;1;1);D$2:D;J$45))"],[50,10,"=IF(H51=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H51;1;1);A$2:A;\"<\"&DATE(H51+1;1;1);D$2:D;K$45))"],[51,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+6<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+6;\"\")"],[51,8,"=IF(H52=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H52;1;1);A$2:A;\"<\"&DATE(H52+1;1;1);D$2:D;I$45))"],[51,9,"=IF(H52=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H52;1;1);A$2:A;\"<\"&DATE(H52+1;1;1);D$2:D;J$45))"],[51,10,"=IF(H52=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H52;1;1);A$2:A;\"<\"&DATE(H52+1;1;1);D$2:D;K$45))"],[52,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+7<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+7;\"\")"],[52,8,"=IF(H53=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H53;1;1);A$2:A;\"<\"&DATE(H53+1;1;1);D$2:D;I$45))"],[52,9,"=IF(H53=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H53;1;1);A$2:A;\"<\"&DATE(H53+1;1;1);D$2:D;J$45))"],[52,10,"=IF(H53=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H53;1;1);A$2:A;\"<\"&DATE(H53+1;1;1);D$2:D;K$45))"],[53,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+8<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+8;\"\")"],[53,8,"=IF(H54=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H54;1;1);A$2:A;\"<\"&DATE(H54+1;1;1);D$2:D;I$45))"],[53,9,"=IF(H54=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H54;1;1);A$2:A;\"<\"&DATE(H54+1;1;1);D$2:D;J$45))"],[53,10,"=IF(H54=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H54;1;1);A$2:A;\"<\"&DATE(H54+1;1;1);D$2:D;K$45))"],[54,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+9<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+9;\"\")"],[54,8,"=IF(H55=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H55;1;1);A$2:A;\"<\"&DATE(H55+1;1;1);D$2:D;I$45))"],[54,9,"=IF(H55=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H55;1;1);A$2:A;\"<\"&DATE(H55+1;1;1);D$2:D;J$45))"],[54,10,"=IF(H55=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H55;1;1);A$2:A;\"<\"&DATE(H55+1;1;1);D$2:D;K$45))"],[55,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+10<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+10;\"\")"],[55,8,"=IF(H56=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H56;1;1);A$2:A;\"<\"&DATE(H56+1;1;1);D$2:D;I$45))"],[55,9,"=IF(H56=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H56;1;1);A$2:A;\"<\"&DATE(H56+1;1;1);D$2:D;J$45))"],[55,10,"=IF(H56=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H56;1;1);A$2:A;\"<\"&DATE(H56+1;1;1);D$2:D;K$45))"],[56,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+11<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+11;\"\")"],[56,8,"=IF(H57=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H57;1;1);A$2:A;\"<\"&DATE(H57+1;1;1);D$2:D;I$45))"],[56,9,"=IF(H57=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H57;1;1);A$2:A;\"<\"&DATE(H57+1;1;1);D$2:D;J$45))"],[56,10,"=IF(H57=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H57;1;1);A$2:A;\"<\"&DATE(H57+1;1;1);D$2:D;K$45))"],[57,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+12<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+12;\"\")"],[57,8,"=IF(H58=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H58;1;1);A$2:A;\"<\"&DATE(H58+1;1;1);D$2:D;I$45))"],[57,9,"=IF(H58=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H58;1;1);A$2:A;\"<\"&DATE(H58+1;1;1);D$2:D;J$45))"],[57,10,"=IF(H58=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H58;1;1);A$2:A;\"<\"&DATE(H58+1;1;1);D$2:D;K$45))"],[58,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+13<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+13;\"\")"],[58,8,"=IF(H59=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H59;1;1);A$2:A;\"<\"&DATE(H59+1;1;1);D$2:D;I$45))"],[58,9,"=IF(H59=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H59;1;1);A$2:A;\"<\"&DATE(H59+1;1;1);D$2:D;J$45))"],[58,10,"=IF(H59=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H59;1;1);A$2:A;\"<\"&DATE(H59+1;1;1);D$2:D;K$45))"],[59,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+14<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+14;\"\")"],[59,8,"=IF(H60=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H60;1;1);A$2:A;\"<\"&DATE(H60+1;1;1);D$2:D;I$45))"],[59,9,"=IF(H60=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H60;1;1);A$2:A;\"<\"&DATE(H60+1;1;1);D$2:D;J$45))"],[59,10,"=IF(H60=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H60;1;1);A$2:A;\"<\"&DATE(H60+1;1;1);D$2:D;K$45))"],[60,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+15<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+15;\"\")"],[60,8,"=IF(H61=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H61;1;1);A$2:A;\"<\"&DATE(H61+1;1;1);D$2:D;I$45))"],[60,9,"=IF(H61=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H61;1;1);A$2:A;\"<\"&DATE(H61+1;1;1);D$2:D;J$45))"],[60,10,"=IF(H61=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H61;1;1);A$2:A;\"<\"&DATE(H61+1;1;1);D$2:D;K$45))"],[61,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+16<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+16;\"\")"],[61,8,"=IF(H62=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H62;1;1);A$2:A;\"<\"&DATE(H62+1;1;1);D$2:D;I$45))"],[61,9,"=IF(H62=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H62;1;1);A$2:A;\"<\"&DATE(H62+1;1;1);D$2:D;J$45))"],[61,10,"=IF(H62=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H62;1;1);A$2:A;\"<\"&DATE(H62+1;1;1);D$2:D;K$45))"],[62,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+17<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+17;\"\")"],[62,8,"=IF(H63=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H63;1;1);A$2:A;\"<\"&DATE(H63+1;1;1);D$2:D;I$45))"],[62,9,"=IF(H63=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H63;1;1);A$2:A;\"<\"&DATE(H63+1;1;1);D$2:D;J$45))"],[62,10,"=IF(H63=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H63;1;1);A$2:A;\"<\"&DATE(H63+1;1;1);D$2:D;K$45))"],[63,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+18<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+18;\"\")"],[63,8,"=IF(H64=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H64;1;1);A$2:A;\"<\"&DATE(H64+1;1;1);D$2:D;I$45))"],[63,9,"=IF(H64=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H64;1;1);A$2:A;\"<\"&DATE(H64+1;1;1);D$2:D;J$45))"],[63,10,"=IF(H64=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H64;1;1);A$2:A;\"<\"&DATE(H64+1;1;1);D$2:D;K$45))"],[64,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+19<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+19;\"\")"],[64,8,"=IF(H65=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H65;1;1);A$2:A;\"<\"&DATE(H65+1;1;1);D$2:D;I$45))"],[64,9,"=IF(H65=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H65;1;1);A$2:A;\"<\"&DATE(H65+1;1;1);D$2:D;J$45))"],[64,10,"=IF(H65=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H65;1;1);A$2:A;\"<\"&DATE(H65+1;1;1);D$2:D;K$45))"],[65,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+20<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+20;\"\")"],[65,8,"=IF(H66=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H66;1;1);A$2:A;\"<\"&DATE(H66+1;1;1);D$2:D;I$45))"],[65,9,"=IF(H66=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H66;1;1);A$2:A;\"<\"&DATE(H66+1;1;1);D$2:D;J$45))"],[65,10,"=IF(H66=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H66;1;1);A$2:A;\"<\"&DATE(H66+1;1;1);D$2:D;K$45))"],[66,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+21<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+21;\"\")"],[66,8,"=IF(H67=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H67;1;1);A$2:A;\"<\"&DATE(H67+1;1;1);D$2:D;I$45))"],[66,9,"=IF(H67=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H67;1;1);A$2:A;\"<\"&DATE(H67+1;1;1);D$2:D;J$45))"],[66,10,"=IF(H67=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H67;1;1);A$2:A;\"<\"&DATE(H67+1;1;1);D$2:D;K$45))"],[67,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+22<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+22;\"\")"],[67,8,"=IF(H68=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H68;1;1);A$2:A;\"<\"&DATE(H68+1;1;1);D$2:D;I$45))"],[67,9,"=IF(H68=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H68;1;1);A$2:A;\"<\"&DATE(H68+1;1;1);D$2:D;J$45))"],[67,10,"=IF(H68=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H68;1;1);A$2:A;\"<\"&DATE(H68+1;1;1);D$2:D;K$45))"],[68,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+23<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+23;\"\")"],[68,8,"=IF(H69=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H69;1;1);A$2:A;\"<\"&DATE(H69+1;1;1);D$2:D;I$45))"],[68,9,"=IF(H69=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H69;1;1);A$2:A;\"<\"&DATE(H69+1;1;1);D$2:D;J$45))"],[68,10,"=IF(H69=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H69;1;1);A$2:A;\"<\"&DATE(H69+1;1;1);D$2:D;K$45))"],[69,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+24<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+24;\"\")"],[69,8,"=IF(H70=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H70;1;1);A$2:A;\"<\"&DATE(H70+1;1;1);D$2:D;I$45))"],[69,9,"=IF(H70=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H70;1;1);A$2:A;\"<\"&DATE(H70+1;1;1);D$2:D;J$45))"],[69,10,"=IF(H70=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H70;1;1);A$2:A;\"<\"&DATE(H70+1;1;1);D$2:D;K$45))"],[70,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+25<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+25;\"\")"],[70,8,"=IF(H71=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H71;1;1);A$2:A;\"<\"&DATE(H71+1;1;1);D$2:D;I$45))"],[70,9,"=IF(H71=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H71;1;1);A$2:A;\"<\"&DATE(H71+1;1;1);D$2:D;J$45))"],[70,10,"=IF(H71=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H71;1;1);A$2:A;\"<\"&DATE(H71+1;1;1);D$2:D;K$45))"],[71,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+26<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+26;\"\")"],[71,8,"=IF(H72=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H72;1;1);A$2:A;\"<\"&DATE(H72+1;1;1);D$2:D;I$45))"],[71,9,"=IF(H72=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H72;1;1);A$2:A;\"<\"&DATE(H72+1;1;1);D$2:D;J$45))"],[71,10,"=IF(H72=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H72;1;1);A$2:A;\"<\"&DATE(H72+1;1;1);D$2:D;K$45))"],[72,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+27<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+27;\"\")"],[72,8,"=IF(H73=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H73;1;1);A$2:A;\"<\"&DATE(H73+1;1;1);D$2:D;I$45))"],[72,9,"=IF(H73=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H73;1;1);A$2:A;\"<\"&DATE(H73+1;1;1);D$2:D;J$45))"],[72,10,"=IF(H73=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H73;1;1);A$2:A;\"<\"&DATE(H73+1;1;1);D$2:D;K$45))"],[73,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+28<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+28;\"\")"],[73,8,"=IF(H74=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H74;1;1);A$2:A;\"<\"&DATE(H74+1;1;1);D$2:D;I$45))"],[73,9,"=IF(H74=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H74;1;1);A$2:A;\"<\"&DATE(H74+1;1;1);D$2:D;J$45))"],[73,10,"=IF(H74=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H74;1;1);A$2:A;\"<\"&DATE(H74+1;1;1);D$2:D;K$45))"],[74,7,"=IF(YEAR(MIN('Tankolások'!A$2:A))+29<=MAX(YEAR(TODAY());YEAR(MAX('Tankolások'!A$2:A)));YEAR(MIN('Tankolások'!A$2:A))+29;\"\")"],[74,8,"=IF(H75=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H75;1;1);A$2:A;\"<\"&DATE(H75+1;1;1);D$2:D;I$45))"],[74,9,"=IF(H75=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H75;1;1);A$2:A;\"<\"&DATE(H75+1;1;1);D$2:D;J$45))"],[74,10,"=IF(H75=\"\";\"\";COUNTIFS(A$2:A;\">=\"&DATE(H75;1;1);A$2:A;\"<\"&DATE(H75+1;1;1);D$2:D;K$45))"],[79,7,"=IFERROR(QUERY(A1:F;\"select B,count(A) where A is not null and D = 'Prémium / magas oktánszám' group by B order by count(A) desc label B 'Kútmárka',count(A) 'Prémium tankolások'\";1);\"\")"],[189,7,"=IFERROR(QUERY(A1:F;\"select F,count(A) where A is not null group by F order by count(A) desc label F 'Tankolás módja',count(A) 'Tankolások'\";1);\"\")"]],"charts":[{"title":"Prémium és normál tankolások","subtitle":"Alkalom · bizonytalan típusok külön","type":"COLUMN","legend":"NO_LEGEND","domain":{"startRowIndex":0,"endRowIndex":4,"startColumnIndex":7,"endColumnIndex":8},"series":[{"range":{"startRowIndex":0,"endRowIndex":4,"startColumnIndex":8,"endColumnIndex":9},"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"overrides":[{"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":1,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":2,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}}]}],"position":{"anchorCell":{"rowIndex":6},"offsetXPixels":5,"widthPixels":695,"heightPixels":525}},{"title":"Milyen üzemanyagot tankoltál?","subtitle":"Az eredeti típusnevek szerint · alkalom","type":"BAR","legend":"NO_LEGEND","domain":{"startRowIndex":9,"endRowIndex":40,"startColumnIndex":7,"endColumnIndex":8},"series":[{"range":{"startRowIndex":9,"endRowIndex":40,"startColumnIndex":8,"endColumnIndex":9},"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"overrides":[{"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":1,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":2,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":3,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":4,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":5,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":6,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":7,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":8,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":9,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":10,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":11,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":12,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":13,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":14,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":15,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":16,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":17,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":18,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":19,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":20,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":21,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":22,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":23,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":24,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":25,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":26,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":27,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":28,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":29,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}}]}],"position":{"anchorCell":{"rowIndex":6,"columnIndex":8},"offsetXPixels":5,"widthPixels":695,"heightPixels":525}},{"title":"Tankolt liter üzemanyagcsoportonként","subtitle":"A kitöltött litermennyiségek összege","type":"COLUMN","legend":"NO_LEGEND","domain":{"startRowIndex":0,"endRowIndex":4,"startColumnIndex":7,"endColumnIndex":8},"series":[{"range":{"startRowIndex":0,"endRowIndex":4,"startColumnIndex":9,"endColumnIndex":10},"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"overrides":[{"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":1,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":2,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}}]}],"position":{"anchorCell":{"rowIndex":32},"offsetXPixels":5,"widthPixels":695,"heightPixels":525}},{"title":"Üzemanyagcsoportok éves aránya","subtitle":"Tankolásszám alapján · folyó év részleges","type":"COLUMN","stacked":"PERCENT_STACKED","legend":"BOTTOM_LEGEND","domain":{"startRowIndex":44,"endRowIndex":75,"startColumnIndex":7,"endColumnIndex":8},"series":[{"range":{"startRowIndex":44,"endRowIndex":75,"startColumnIndex":8,"endColumnIndex":9},"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}},{"range":{"startRowIndex":44,"endRowIndex":75,"startColumnIndex":9,"endColumnIndex":10},"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}},{"range":{"startRowIndex":44,"endRowIndex":75,"startColumnIndex":10,"endColumnIndex":11},"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}],"position":{"anchorCell":{"rowIndex":32,"columnIndex":8},"offsetXPixels":5,"widthPixels":695,"heightPixels":525}},{"title":"Prémium tankolások kútmárkánként","subtitle":"Prémium / magas oktánszám · alkalom","type":"BAR","legend":"NO_LEGEND","domain":{"startRowIndex":79,"endRowIndex":180,"startColumnIndex":7,"endColumnIndex":8},"series":[{"range":{"startRowIndex":79,"endRowIndex":180,"startColumnIndex":8,"endColumnIndex":9},"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"overrides":[{"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":1,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":2,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":3,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":4,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":5,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":6,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":7,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":8,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":9,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":10,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":11,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":12,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":13,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":14,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":15,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":16,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":17,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":18,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":19,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":20,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":21,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":22,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":23,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":24,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":25,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":26,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":27,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":28,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":29,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":30,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":31,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":32,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":33,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":34,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":35,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":36,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":37,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":38,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":39,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":40,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":41,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":42,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":43,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":44,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":45,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":46,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":47,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":48,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":49,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":50,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":51,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":52,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":53,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":54,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":55,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":56,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":57,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":58,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":59,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":60,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":61,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":62,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":63,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":64,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":65,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":66,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":67,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":68,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":69,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":70,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":71,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":72,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":73,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":74,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":75,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":76,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":77,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":78,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":79,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":80,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":81,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":82,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":83,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":84,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":85,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":86,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":87,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":88,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":89,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":90,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":91,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":92,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":93,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":94,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":95,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":96,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":97,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":98,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":99,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}}]}],"position":{"anchorCell":{"rowIndex":58},"offsetXPixels":5,"widthPixels":695,"heightPixels":525}},{"title":"Tele vagy részleges tankolás?","subtitle":"Tankolásszám · teljes napló","type":"COLUMN","legend":"NO_LEGEND","domain":{"startRowIndex":189,"endRowIndex":193,"startColumnIndex":7,"endColumnIndex":8},"series":[{"range":{"startRowIndex":189,"endRowIndex":193,"startColumnIndex":8,"endColumnIndex":9},"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"overrides":[{"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":1,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":2,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}}]}],"position":{"anchorCell":{"rowIndex":58,"columnIndex":8},"offsetXPixels":5,"widthPixels":695,"heightPixels":525}}],"description":"Prémium / magas oktánszám: MaxxMotion, V-Power, 98/99/100-as és prémium jelölés. Üres típus = sima 95-ös. A bizonytalan típusok külön szerepelnek."},{"title":"Tankolási szokások","dataTitle":"Szokásadatok","rows":[[0,0,"Dátum"],[0,1,"Liter"],[0,2,"Megtett km"],[0,3,"Napok két tankolás között"],[0,4,"Hét napja"],[0,5,"Év"],[0,11,"Nap"],[0,12,"Tankolások"],[1,0,"=IFERROR(FILTER('Tankolások'!A2:A;'Tankolások'!A2:A<>\"\");\"\")"],[1,1,"=IFERROR(FILTER('Tankolások'!G2:G;'Tankolások'!A2:A<>\"\");\"\")"],[1,2,"=IFERROR(FILTER('Tankolások'!I2:I;'Tankolások'!A2:A<>\"\");\"\")"],[1,4,"=ARRAYFORMULA(IF(A2:A=\"\";\"\";WEEKDAY(A2:A;2)))"],[1,5,"=ARRAYFORMULA(IF(A2:A=\"\";\"\";YEAR(A2:A)))"],[1,11,"Hétfő"],[1,12,"=COUNTIF(E2:E;1)"],[2,3,"=ARRAYFORMULA(IF(A3:A2500=\"\";\"\";IF(A2:A2499=\"\";\"\";A3:A2500-A2:A2499)))"],[2,11,"Kedd"],[2,12,"=COUNTIF(E2:E;2)"],[3,11,"Szerda"],[3,12,"=COUNTIF(E2:E;3)"],[4,11,"Csütörtök"],[4,12,"=COUNTIF(E2:E;4)"],[5,11,"Péntek"],[5,12,"=COUNTIF(E2:E;5)"],[6,11,"Szombat"],[6,12,"=COUNTIF(E2:E;6)"],[7,11,"Vasárnap"],[7,12,"=COUNTIF(E2:E;7)"],[11,11,"Mennyiség"],[11,12,"Tankolások"],[12,11,"0–20 liter"],[12,12,"=COUNTIFS(B2:B;\">0\";B2:B;\"<20\")"],[13,11,"20–30 liter"],[13,12,"=COUNTIFS(B2:B;\">=20\";B2:B;\"<30\")"],[14,11,"30–40 liter"],[14,12,"=COUNTIFS(B2:B;\">=30\";B2:B;\"<40\")"],[15,11,"40–50 liter"],[15,12,"=COUNTIFS(B2:B;\">=40\";B2:B;\"<50\")"],[16,11,"50+ liter"],[16,12,"=COUNTIFS(B2:B;\">=50\";B2:B;\"<100000\")"],[23,11,"Távolság"],[23,12,"Tankolások"],[24,11,"0–300 km"],[24,12,"=COUNTIFS(C2:C;\">0\";C2:C;\"<300\")"],[25,11,"300–500 km"],[25,12,"=COUNTIFS(C2:C;\">=300\";C2:C;\"<500\")"],[26,11,"500–700 km"],[26,12,"=COUNTIFS(C2:C;\">=500\";C2:C;\"<700\")"],[27,11,"700+ km"],[27,12,"=COUNTIFS(C2:C;\">=700\";C2:C;\"<100000\")"],[35,11,"Időköz"],[35,12,"Tankolások"],[36,11,"0–7 nap"],[36,12,"=COUNTIFS(D2:D;\">=0\";D2:D;\"<8\")"],[37,11,"8–14 nap"],[37,12,"=COUNTIFS(D2:D;\">=8\";D2:D;\"<15\")"],[38,11,"15–21 nap"],[38,12,"=COUNTIFS(D2:D;\">=15\";D2:D;\"<22\")"],[39,11,"22–30 nap"],[39,12,"=COUNTIFS(D2:D;\">=22\";D2:D;\"<31\")"],[40,11,"31+ nap"],[40,12,"=COUNTIFS(D2:D;\">=31\";D2:D;\"<100000\")"],[47,11,"=IFERROR(QUERY(A1:F;\"select F,avg(B) where A is not null and B > 0 group by F order by F label F 'Év',avg(B) 'Átlag liter / tankolás'\";1);\"\")"],[81,11,"=IFERROR(QUERY(A1:F;\"select F,avg(D) where A is not null and D >= 0 group by F order by F label F 'Év',avg(D) 'Átlag nap két tankolás között'\";1);\"\")"]],"charts":[{"title":"A hét melyik napján tankolsz?","subtitle":"Teljes napló · alkalom","type":"COLUMN","legend":"NO_LEGEND","domain":{"startRowIndex":0,"endRowIndex":8,"startColumnIndex":11,"endColumnIndex":12},"series":[{"range":{"startRowIndex":0,"endRowIndex":8,"startColumnIndex":12,"endColumnIndex":13},"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"overrides":[{"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":1,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":2,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":3,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":4,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}},{"index":5,"color":{"red":0.13725491,"green":0.69803923,"blue":0.8},"colorStyle":{"rgbColor":{"red":0.13725491,"green":0.69803923,"blue":0.8}}},{"index":6,"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}}]}],"position":{"anchorCell":{"rowIndex":5},"offsetXPixels":5,"widthPixels":695,"heightPixels":525}},{"title":"Mennyi kerül a tankba egyszerre?","subtitle":"Pozitív, kitöltött litermennyiségek","type":"COLUMN","legend":"NO_LEGEND","domain":{"startRowIndex":11,"endRowIndex":17,"startColumnIndex":11,"endColumnIndex":12},"series":[{"range":{"startRowIndex":11,"endRowIndex":17,"startColumnIndex":12,"endColumnIndex":13},"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"overrides":[{"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":1,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":2,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":3,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":4,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}}]}],"position":{"anchorCell":{"rowIndex":5,"columnIndex":8},"offsetXPixels":5,"widthPixels":695,"heightPixels":525}},{"title":"Mekkora út után tankolsz?","subtitle":"Bejegyzések közötti ismert távolság · km","type":"COLUMN","legend":"NO_LEGEND","domain":{"startRowIndex":23,"endRowIndex":28,"startColumnIndex":11,"endColumnIndex":12},"series":[{"range":{"startRowIndex":23,"endRowIndex":28,"startColumnIndex":12,"endColumnIndex":13},"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"overrides":[{"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":1,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":2,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":3,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}}]}],"position":{"anchorCell":{"rowIndex":31},"offsetXPixels":5,"widthPixels":695,"heightPixels":525}},{"title":"Hány nap telik el két tankolás között?","subtitle":"Dátumos bejegyzések sorrendje szerint","type":"COLUMN","legend":"NO_LEGEND","domain":{"startRowIndex":35,"endRowIndex":41,"startColumnIndex":11,"endColumnIndex":12},"series":[{"range":{"startRowIndex":35,"endRowIndex":41,"startColumnIndex":12,"endColumnIndex":13},"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"overrides":[{"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039},"colorStyle":{"rgbColor":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}},{"index":1,"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275},"colorStyle":{"rgbColor":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}},{"index":2,"color":{"red":0.95686275,"green":0.64705884,"blue":0.1764706},"colorStyle":{"rgbColor":{"red":0.95686275,"green":0.64705884,"blue":0.1764706}}},{"index":3,"color":{"red":0.5568628,"green":0.30980393,"blue":0.81960785},"colorStyle":{"rgbColor":{"red":0.5568628,"green":0.30980393,"blue":0.81960785}}},{"index":4,"color":{"red":0.9098039,"green":0.29803923,"blue":0.44705883},"colorStyle":{"rgbColor":{"red":0.9098039,"green":0.29803923,"blue":0.44705883}}}]}],"position":{"anchorCell":{"rowIndex":31,"columnIndex":8},"offsetXPixels":5,"widthPixels":695,"heightPixels":525}},{"title":"Átlagos tankolt mennyiség évente","subtitle":"Liter / tankolás · kitöltött mennyiségekből","type":"LINE","legend":"NO_LEGEND","domain":{"startRowIndex":47,"endRowIndex":78,"startColumnIndex":11,"endColumnIndex":12},"series":[{"range":{"startRowIndex":47,"endRowIndex":78,"startColumnIndex":12,"endColumnIndex":13},"color":{"red":0.21960784,"green":0.5294118,"blue":0.9098039}}],"position":{"anchorCell":{"rowIndex":57},"offsetXPixels":5,"widthPixels":695,"heightPixels":525}},{"title":"Átlagos időköz évente","subtitle":"Nap / tankolás · a záró tankolás évéhez rendelve","type":"LINE","legend":"NO_LEGEND","domain":{"startRowIndex":81,"endRowIndex":112,"startColumnIndex":11,"endColumnIndex":12},"series":[{"range":{"startRowIndex":81,"endRowIndex":112,"startColumnIndex":12,"endColumnIndex":13},"color":{"red":0.078431375,"green":0.64705884,"blue":0.5686275}}],"position":{"anchorCell":{"rowIndex":57,"columnIndex":8},"offsetXPixels":5,"widthPixels":695,"heightPixels":525}}],"description":"A hét napjai, tankolt mennyiségek, ismert utak és bejegyzések közötti időközök. A hiányzó mennyiségek és távolságok kimaradnak. A záró tankolás évéhez rendelve."}];

// Új statisztikai lapokat ad hozzá. A Tankolások és a meglévő jelentések adatait nem módosítja.
function setupStatistics() {
  if (typeof Sheets === 'undefined') throw new Error('Másold be a frissített appsscript.json fájlt: a Google Sheets v4 szolgáltatás szükséges.');
  authorize_();
  const book = workbook_();
  const definitions = KAJLA_STATISTICS;
  const requests = [], planned = [];
  const color = {red:0.14,green:0.27,blue:0.36};
  definitions.forEach(def => {
    const existing = book.getSheetByName(def.title), existingData = book.getSheetByName(def.dataTitle);
    const state = sheet => sheet && sheet.getDeveloperMetadata().find(m => m.getKey() === 'kajla_statistics_v1');
    const marker = state(existing), dataMarker = state(existingData);
    if (existing || existingData) {
      if (marker && dataMarker && marker.getValue() === 'ready' && dataMarker.getValue() === 'ready') return;
      if (!marker || !dataMarker || marker.getValue() !== 'pending' || dataMarker.getValue() !== 'pending') {
        throw new Error('A '+def.title+' nevű lap már létezik. A program nem írja felül.');
      }
    }
    const chartSheet = existing || book.insertSheet(def.title), dataSheet = existingData || book.insertSheet(def.dataTitle);
    if (!existing) chartSheet.addDeveloperMetadata('kajla_statistics_v1','pending');
    if (!existingData) dataSheet.addDeveloperMetadata('kajla_statistics_v1','pending');
    const sid=chartSheet.getSheetId(), did=dataSheet.getSheetId(), needed=Math.max(2500,book.getSheetByName('Tankolások').getMaxRows()+500);
    if(dataSheet.getMaxRows()<needed)dataSheet.insertRowsAfter(dataSheet.getMaxRows(),needed-dataSheet.getMaxRows());
    if(dataSheet.getMaxColumns()<26)dataSheet.insertColumnsAfter(dataSheet.getMaxColumns(),26-dataSheet.getMaxColumns());
    chartSheet.setHiddenGridlines(true).setColumnWidths(1,16,90).setRowHeights(1,90,22);
    chartSheet.getRange(1,1,1,16).merge().setValue(def.title).setBackground('#244457').setFontColor('#ffffff').setFontWeight('bold').setFontSize(16);
    chartSheet.getRange(2,1,3,16).merge().setValue(def.description).setWrap(true).setFontSize(11);
    const height=Math.max(...def.rows.map(r=>r[0]))+1, width=Math.max(...def.rows.map(r=>r[1]))+1;
    const values=Array.from({length:height},()=>Array(width).fill(''));
    def.rows.forEach(([r,c,value])=>values[r][c]=value);
    dataSheet.getRange(1,1,height,width).setValues(values);
    if(def.dataTitle==='Grafikonadatok')dataSheet.getRange('A236:A259').setNumberFormat('yyyy.mm');
    if(def.dataTitle==='Szokásadatok')dataSheet.getRange('A2:A2500').setNumberFormat('yyyy.mm.dd.');
    if (def.nativeCharts) {
      const auxDef=def.auxiliary;
      let aux=book.getSheetByName(auxDef.title);
      if (aux && !state(aux)) throw new Error('A '+auxDef.title+' nevű lap már létezik. A program nem írja felül.');
      if (!aux) { aux=book.insertSheet(auxDef.title);aux.addDeveloperMetadata('kajla_statistics_v1','pending'); }
      if(aux.getMaxRows()<500)aux.insertRowsAfter(aux.getMaxRows(),500-aux.getMaxRows());
      if(aux.getMaxColumns()<37)aux.insertColumnsAfter(aux.getMaxColumns(),37-aux.getMaxColumns());
      const auxValues=Array.from({length:432},()=>Array(37).fill(''));
      auxDef.rows.forEach(([r,c,value])=>auxValues[r][c]=value);
      aux.getRange(1,1,432,37).setValues(auxValues);
      chartSheet.setRowHeight(1,48);
      chartSheet.getRange(1,1,1,16).setBackground('#f7f8fc').setFontColor('#243247').setFontSize(20).setVerticalAlignment('middle');
      chartSheet.getRange(2,1,3,16).setFontColor('#6b7280').setFontSize(12);
      const sources={};sources[def.title]=chartSheet;sources[def.dataTitle]=dataSheet;sources[auxDef.title]=aux;
      const resolve=value=>{
        if(Array.isArray(value))return value.map(resolve);
        if(value && typeof value==='object'){
          const out={};Object.keys(value).forEach(key=>{
            if(key==='sheetTitle'){if(!sources[value[key]])throw new Error('Hiányzó grafikonforrás.');out.sheetId=sources[value[key]].getSheetId();}
            else out[key]=resolve(value[key]);
          });return out;
        }return value;
      };
      def.nativeCharts.forEach(chart=>requests.push({addChart:{chart:{spec:resolve(chart.spec),position:{overlayPosition:resolve(chart.position)}}}}));
      planned.push([chartSheet,dataSheet,aux]);
      return;
    }
    def.charts.forEach((chart,i)=>{
      const source=range=>({sourceRange:{sources:[Object.assign({},range,{sheetId:did})]}});
      const basic={chartType:chart.type,headerCount:1,legendPosition:chart.legend||'NO_LEGEND',domains:[{domain:source(chart.domain)}],series:chart.series.map(ser=>({series:source(ser.range),targetAxis:chart.type==='BAR'?'BOTTOM_AXIS':'LEFT_AXIS',colorStyle:{rgbColor:ser.color||{red:.22,green:.53,blue:.91}},...(ser.overrides?{styleOverrides:ser.overrides}:{}),...(chart.type==='LINE'?{pointStyle:{shape:'CIRCLE',size:5}}:{})}))};
      if(chart.stacked)basic.stackedType=chart.stacked;
      requests.push({addChart:{chart:{spec:{title:chart.title,subtitle:chart.subtitle,fontName:'Calibri',titleTextFormat:{fontSize:16,bold:true},hiddenDimensionStrategy:'SHOW_ALL',backgroundColor:{red:1,green:1,blue:1},basicChart:basic},position:{overlayPosition:{anchorCell:{sheetId:sid,rowIndex:5+Math.floor(i/2)*26,columnIndex:i%2?8:0},offsetXPixels:5,widthPixels:695,heightPixels:525}}}}});
    });
    planned.push([chartSheet,dataSheet]);
  });
  if(requests.length) Sheets.Spreadsheets.batchUpdate({requests:requests},book.getId());
  planned.forEach(([chartSheet,dataSheet,aux])=>{
    [chartSheet,dataSheet,...(aux?[aux]:[])].forEach(sheet=>sheet.getDeveloperMetadata().find(m=>m.getKey()==='kajla_statistics_v1').setValue('ready'));
    dataSheet.hideSheet();
    if(aux)aux.hideSheet();
  });
  SpreadsheetApp.flush();
  return 'Elkészültek a kút-, üzemanyag- és tankolási szokásgrafikonok. A meglévő adatok megmaradtak.';
}